Project vba sqlcông việc

I am looking for a way which allows me to save PDF files with metadata of my choice. Currently when a PDF file is saved, the metadata is saved automatically. The way I save PDF files is by using the PDF Maker from Adobe Acrobat, which adds a tab in Excel. I read online that this can be achieved with some VBA code but I am not sure how. I also read that Acrobat is required so if you do this job, please make sure you have Acrobat . Unless there is a way to do this without Acorbat? I would like to be able to enter the metadata in some cells, and then when I save the file as PDF, the metadata automatically be applied to the file. Or if this is impossible, then maybe I can save the PDF file first, and then use the Excel that you create, to modify the existing PDF file already created...

I need a skilled freelancer to create a dynamic and interactive data dashboard that integrates various health-related metrics. Here's what's involved: - Data Integration: Import and synthesis of data from multiple sources including; - **Databases:** SQL and NoSQL databases. - **APIs:** RESTful services for real-time data. - **Spreadsheets:** Excel or Google Sheets. - **Files:** CSV, FIT, and GPX files. - Visualization Requirements: - **Health Data:** The dashboard should focus on presenting health metrics in a clear and actionable manner. - Key Metrics: - **Heart Rate:** Visualize resting and active heart rates. - **Blood Pressure:** Display systolic and diastolic readings. - **Steps Count:** Show daily and historical step count. - **Activities Tra...

As a new Insurance Health agent, I'm looking for someone proficient in Excel to assist me in designing a Excel spreadsheet that serves as a comprehensive member information database. I needed to easily help me access members information details for fast and efficient customer service. I want to be able to duplicated in multiple worksheet tabs for each member. I believe a VBA codes would help me search for specific tab fast but not sure how that would exactly work. This will include, but is not limited to, the following details: - Name - Phone number - Date of Birth - Address - Email - Emergency contact - Medicare Number - Medicare Part A Coverage date - Medicare Part B Coverage date - Medicaid Number - Medicaid Level - Health Plan enrolled - Health Plan Member ID - Primary ca...

I'm looking for a skilled developer to create a Lease & Rental Management system specifically targeted to managing commercial properties. The ideal candidate has a deep understanding of property management systems and possesse...Another crucial function is to allow tracking of rental payments. Experience in developing similar systems or property management software will be highly advantageous. We value efficiency and accuracy, so attention to detail and a proven track of delivering high-quality work is a must. Our existing system is developed on Codeigniter and we wish not only to migrate this to new technologies (dot net, SQL) but also would like to add functionalities to the system. This is a high-level requirement. Detailed requirement documents will be sent to shortl...

...with a solid experience in Excel automation. I need to automate tasks in Excel related to data entry, formulas and calculations, and data analysis. The files that need to be automated are small and simple, easing the task at hand. The automated Excel tool should emphasize on having minimal user interaction, focusing predominantly on automatic processes. Ideal Skills: • Experience with Excel and VBA • A good understanding of Excel formulas and calculations • Proficiency in Excel's data analysis tools • Knowledge in automating Excel tasks Experience in creating automated tools with minimal user interaction will be a huge plus. This is an exciting opportunity for freelancers with a knack for simplifying and automating Excel processes. Your expertise will...

I'm seeking a skillful website developer to build an informational website for my startup company, the main purpose of this web presence is to communicate the consult...holidays. Its completly new website and uniques i need complete Backend -- Node.js with Express (Efficient and scalable server-side development) Frontend -- React Native (Building a cross-platform, native-like user interface) Database -- SQL (Storing and retrieving data seamlessly) Version Control GitHub (Utilizing Git for version control, hosted on GitHub for collaboration) I don’t want any customized templates In website development i am looking into he technical stack that should include: - Frontend: React Native - Backend: Node.js with Express - Database: SQL please let me know if you can do it ...

I'm looking for a talented Excel wizard to create an automated attendance sheet that stream...workflow on Windows. This sheet will be integral to my daily operations and must include: - Complex macros for efficient management. - Conditional formatting to highlight patterns or issues. - Alert notifications to prompt immediate action. Key Skills Required: - Proficiency in Microsoft Excel. - Experience with Visual Basic for Applications (VBA). - Strong knowledge of conditional formatting. - Familiarity with creating alert systems in Excel. This project would best suit someone who has experience in automating Excel functionalities and can demonstrate a history of complex projects on this platform. A portfolio showcasing previous work with macros and conditional formatting...

In need...company’s data warehouse. I'm specifically looking for expertise in a few critical areas: - **Data Integration & Transformation:** - Unify disparate sources - Cohesive data flow creation - ETL processes for structured data - **Data Modeling & Design:** - Implement Snowflake Schema efficiently - Optimize for scalability and performance **Ideal Skills and Experience:** - Proficiency in SQL and ETL tools - Experience with Snowflake Schema modeling - Strong understanding of structured data integration - Familiarity with data warehousing best practices By applying your knowledge and skills, you will directly contribute to the robustness and intelligence of our data warehousing solutions. Looking forward to your expertise to create an optima...

...and secure system for managing the checkout and return of tools to personnel, reducing the risk of loss or misplacement. - **Access Control:** Implementation of RBAC to assign specific permissions based on user roles, enhancing our operational security. **Ideal Skills:** - Proficiency in HTML/CSS for professional design implementation - Experience with database management systems (preferably SQL) - Familiarity with creating and managing role-based access controls - Strong background in creating secure login and authentication systems - Portfolio showcasing similar inventory or asset management systems I am looking forward to working with a dedicated freelancer who can translate our specific needs into a secure and efficient web solution....

I'm seeking a seasoned VBA developer to refine my existing Excel workflows. With your expertise, I intend to take my data analysis to the next level and bolster the security of sensitive information within my spreadsheets. Here’s what I’m looking for: - Intermediate-level VBA coding for robust data analysis functions. - Implementing protection for specific spreadsheet tabs and formulas to prevent unauthorized access or alterations. - Coding solutions with hard-coded values to ensure consistency and simplify the usage for my team. Ideal Candidate Should Have: - Proven experience with Excel VBA, especially in data analysis and worksheet protection. - A solid understanding of best practices for secure and efficient VBA code. - Ability to deliver...

I need a professional freelancer experienced in SQL Server 2019, Plesk, and Windows operating system to establish a seamless connection between my Plesk installation and SQL Server. The work should focus primarily on the management of User Data. The ideal candidate should have: - Proven experience in working with SQL Server 2019 - A good understanding of Plesk, particularly on Windows Operating System - Proficiency in data management, specifically User Data The ultimate goal is to enable the smooth operation of our User Data on SQL Server through our Plesk platform. Bids are welcome!

...commonly used packages specially with GCP. Hands on experience on Data migration and data processing on the Google Cloud stack, specifically: Big Query Cloud Dataflow Cloud DataProc Cloud Storage Cloud DataPrep Cloud PubSub Cloud Composer & Airflow Experience designing and deploying large scale distributed data processing systems with few technologies such as PostgreSQL or equivalent databases, SQL, Hadoop, Spark, Tableau Hands on Experience with Python-Json nested data operation. Exposure or Knowledge of API design, REST including versioning, isolation, and micro-services. Proven ability to define and build architecturally sound solution designs. Demonstrated ability to rapidly build relationships with key stakeholders. Experience of automated unit testing, automated integra...

I'm in urgent need for an expert to automate our report generation. Our data resides in various databases, and we need to streamline our data to reports conversion process. This project demands precision and scalability. - Mastery of database management - Proven data automation portfolio - Expert in report generation tools - Strong scripting skills (SQL, Python, etc.) - Familiarity with the latest automation trends - Excellent problem-solving capabilities Ideal candidate will show previous work with database-to-report automation, effectively communicate progress, and deliver efficient, reliable solutions. Please revert to get more details.

I'm looking for an experienced Greek native senior developer based in Athens, Greece to build an e-shop from scratch using Aimeos. The end goal is to create a platform that operates as like Aliexpress. Key Project Requirements: - Deep expertise in Aimeos ecommerce framework, with a proven track record in developing large-scale ecommerce platforms using Aimeos. - Minimum 5 years of professional PHP development experience, with extensive knowledge of Laravel and/or Symfony. - Strong experience with SQL/NoSQL databases, cloud services (AWS, Azure, GCP), and serverless architectures. - Demonstrated ability in handling large datasets and optimizing performance in complex PHP applications. The ideal candidate will have prior experience in creating similar platforms...

Redesign of existing bespoke ecommerce website built on ASP.Net Forms with a SQL Server backend database. The replacement website will also need to be built using ASP.Net Forms with a SQL Server backend database. The business operates in the home furnishing sector and has been trading online for 14 years. The existing website functions adequately but has poor UX and is not mobile responsive. The design aesthetic of the replacement website needs to have a clean and minimalist design and communicate that we are selling a premium / high end product. There are a number of options with regard to the website redesign… 1. Outsource just the HTML, CSS, and Jscript website redesign work - The back-end code to link the website to the database etc would be done...

I'm looking to increase my proficiency with the OpenAI API, specifically to improve language understanding. My main focus will be on Python and SQL integrations, with an aim of harnessing the power of this AI for tasks like sentiment analysis and text generation. Fortunately, there's no hard deadlines on this, so we can take our time to truly comprehend and apply the material. Ideal freelancers for this job are those with significant experience in: - Python, SQL, and their applications within OpenAI. - Tutoring or instructional design, with a capacity to explain complex concepts in a clear, engaging manner. - Chatbot development and language processing capabilities, particularly with OpenAI. Interested? Let's learn together!

...obsługi zapytań HTTP (np. cURL) Umiejętność tworzenia testów jednostkowych i funkcjonalnych dla kodu w PHP, zgodnie z zasadami TDD (Test-Driven Development) Znajomość i stosowanie dobrych praktyk programowania, takich jak SOLID, DRY, KISS itp. Umiejętność optymalizacji kodu pod kątem wydajności i skalowalności. Znajomość i stosowanie zabezpieczeń w kontekście integracji, zapobieganie atakom typu SQL Injection, XSS itp. Staranność w tworzeniu dokumentacji kodu oraz instrukcji użytkownika dla stworzonej integracji. Napisane jako bundle do instalacji w Symfony 6 dokumentacja Zadania do wykonania to: Autentykacja z API: Implementacja skryptu autentykacji przy użyciu kluczy API Ustawienie Swagger UI do łatwej dokumentacji Dane testowe do autentykacji: Podamy osob...

I'm launching an exciting project and need a freelancer with specific expertise to make it a success. Here’s what I’m looking for: - Development of dynamic, responsive web functionality. - Robust user authentication system ensuring a secure user experience. - Seamless database integration for efficient data handling and storage. Ideal Skills and Experience: - Proven proficiency in Spring MVC and Java Server Pages (JSP). - Strong understanding of web security and authentication protocols. - Familiarity with SQL or similar databases. - Experience in developing user-oriented platforms. By joining me, you'll be instrumental in building a platform that has the potential to grow significantly. Please include in your proposal your past work that demonstrates...

I'm looking for a well-versed Python developer with a strong...specific tasks. Here are my requirements: - Develop a Python script for automation tasks. - The script should handle file management, automate data entry, and manage email notifications. - It must execute SQL queries on a MySQL database. - A critical feature is to trigger SQL report generation and email the report once complete. The ideal freelancer should demonstrate: - Proficiency in Python programming, especially with automation scripts. - Strong experience with MySQL database interactions. - Familiarity with file management and email handling within scripts. - Capability to integrate SQL report generation and email dispatch within the automation process. I am looking forward to streamlining the...

I’m in urgent need of an experienced developer to review and optimize my PHP and SQL code. The code is meant for database management but unfortunately, it's returning errors upon execution. What I'm looking for: - Strong background in PHP and SQL - Experience with debugging and optimizing code for database management systems - Ability to diagnose and resolve errors quickly Your task will be to: - Review the existing PHP/SQL code - Identify the causes of errors during execution - Optimize code to ensure smooth database operations - Provide recommendations for best practices and future maintenance Ideal candidates will have a proven track record of successful code reviews and optimizations, with specific expertise in database-related projects. Please ...

Seeking an Excel whizz to assist with data analysis and reporting, with an emphasis on descriptive statistics. Here's what I need from you: - Expertise in Excel including pivot tables, macros, and advanced functions - I won't have time to train you up. - Experience in spreadsheet f...whizz to assist with data analysis and reporting, with an emphasis on descriptive statistics. Here's what I need from you: - Expertise in Excel including pivot tables, macros, and advanced functions - I won't have time to train you up. - Experience in spreadsheet formatting and design. - Grasp on VBA automation for efficiency. - A knack for analyzing and reporting financial data - this is where our focus will be. If you've got a head for numbers and an eye for detail, this...

I'm seeking a talented individual with proficiency in PHP and SQL for my new project, a School Result Management System website. Here's what I need: - **Database Design**: Establish a robust, scalable database architecture to store and manage student results efficiently. - **Query Optimization**: Ensure that all database queries are optimized for speed and efficiency, providing a smooth user experience. - **PHP Coding**: Develop the website's backend using PHP, implementing the required functionalities for managing and displaying academic results. **Ideal skills:** - Expertise in PHP and SQL - Experience with database design and optimization - Familiarity with creating user-friendly interfaces - Knowledge of best practices in web security Experience i...

I'm looking for a talented developer to create a complete ASP.NET web application that my custom...comprehensive Customer Relationship Management (CRM) system. I'm not yet sure if I want it to include customer tracking, lead management, and communication history. We will discuss these aspects further once the project commences. - Functionality for managing projects, including tracking project status and steps. - SMS and SQL capabilities are also required. - An integral feature of the app will be mobile access, particularly for creating appointments. Ideal candidates will have extensive experience with ASP.NET, SQL, and SMS integrations, and a strong understanding of CRM systems and project management software. Familiarity with designing respo...

We have a busy contact lens ecommerce website and back end administration, we are looking for a seasoned web developer with an expert understanding of ASP. NET MVC 4.8, MS SQL Server, JQuery, with responsive website design experience. Both websites are existing, improved functionality and updates are frequently needed. Projects are briefed and recorded thru to completion using Google Sheets. We pay an hourly rate, projects can be worked on out of normal business hours with business owner available to test, clarify etc. Our previous developer is also available to troubleshoot any issues.

I'm searching for a seasoned website developer to help bring my start-up idea to life online. As a portfolio-centric platform, the website is expected to have less than 5 pages. Key functionalities include: - D...This will be a key feature on my website, allowing potential partners or investors to see past and ongoing work. - A Contact form: This will enable visitors to my site to get in touch easily. - Blog for updates: This will serve as a dynamic space for company updates and relevant news. The technical stack should include: - Frontend: React Native - Backend: Node.js with Express - Database: SQL Experience with GitHub is also necessary. Demonstrated expertise in creating responsive, visually compelling portfolio sites with the mentioned tech stack will be stro...

Buscamos Experto en Bases de Datos SQL para Proyecto en Gestión de Talento Humano ¡Hola! Somos una empresa en crecimiento y buscamos un profesional freelance con conocimientos expertos en SQL para un proyecto importante y desafiante en el área de Gestión de Talento Humano. Objetivo del Proyecto: Diseñar y configurar una base de datos robusta y eficiente que pueda administrar aproximadamente un millón de hojas de vida. Este proyecto es crucial para optimizar nuestro proceso de selección y gestión de Talento Humano. Responsabilidades: - Analizar y comprender nuestras necesidades en la gestión de Talento Humano. - Diseñar una base de datos en SQL que sea escalable, segura y fácil de mantener. -...

I'm seeking an accomplished Python developer to build an API that connects to a MySQL database. The key specifications are as follows: - Develop using Python as the primary programming language. - Implement Django framework for the API connection. - The core function...the primary programming language. - Implement Django framework for the API connection. - The core function would be retrieving product data. Useful Skills and Experience: - Extensive experience with Python and Django. - Proficient in MySQL databases and the creation of intricate SQL queries. - Solid understanding of API connections. This task requires strong technical abilities, especially with Python, Django, and MySQL. Your proficiency in these areas will be highly influential in accomplishing the pro...

I’m looking for a seasoned SQL programmer to establish a robust SQL Server database system for my project. I need someone who is well-versed in the intricacies of SQL Server and has a proven track record of designing efficient and scalable databases. **Key Deliverables:** - Design and set up a new SQL Server database - Develop a clear and efficient data model - Generate the schema design tailor-made for our needs - Create essential database objects: tables, views, and indexes - Implement reliable stored procedures and functions **Ideal Candidate Qualities:** - Experience in creating database for MS Power BI usage - Profound knowledge of SQL Server - Experience in database design and architecture - Expertise in SQL query performance...

JR Long term developer to work under our head developer on Front and Back end. Full Stack information -> Developer requirements: 1) Experience working full stack 2)Have 20+ hours a week available 3) Hourly rate U$4-5 inicial 4) Start immediately DO NOT BID HOURLY RATE DIFFERENTE THAN WHAT YOU INTEND TO CHARGE. Developer will work under supervision of our head developer fixing bugs, improving functionalities and also implementing new endpoints for our API.

...to take remote control of the mouse and keyboard for any of the student machines. - Integration of an IP whitelisting system to ensure secure access to this tool, preventing unauthorized use. - Capacity to handle a classroom size of 30 students simultaneously. Ideal skills and experience: - Proficiency in ASP.NET and VB.NET - Experience with remote desktop services and APIs - Familiarity with SQL databases for storing and retrieving IP addresses - Strong grasp of network security measures, specifically IP whitelisting - Past work involving grid view UI components I am looking for a developer who can offer a reliable and user-friendly solution. The end product should be easy-to-use for a non-technical user, ensuring a seamless teaching experience. If you have a portfolio showca...

...reality. This tool will become crucial for monitoring our Azure Release Pipelines. Here's what I'll need: - Development of an Excel dashboard utilizing VBA and macros. - Real-time tracking of pipeline statuses through a progress bar display. - Capability to automatically retrieve data from Azure Release Pipelines. - Implementation of error notifications and alerts to promptly address issues. - Integration of VBA code to approve release pipelines efficiently. - Adherence to our company's branding guidelines for a cohesive aesthetic. Ideal Freelancer Qualities: - Proven experience with Excel dashboard creation. - Strong knowledge of VBA and macro programming. - Familiarity with Azure services and their APIs. - Aesthetic sensitivity to mat...

As someone with intermediate level experience in Power BI, your primary tasks will be focused on data modeling and data visualization. Your skills and experience should include: - Strong proficiency in Power BI, specifically in the fields of data modeling and data visualization. - Proficiency with SQL Server and Excel spreadsheets, as these are the main data sources involved in this project. We are only Travel B2B Company and getting over 80 Million Searches on our system, all those searches that we are recieving we want to someone who can manage such logs in a real time dasboard and give the insight of all details based on our requirement.

I'm searching for an ASP.NET MVC 5 experienced developer to work on a project. I need someone with a proficient understanding of Microsoft SQL Server. Although I didn't specify functionalities required, being able to navigate the range of functionality aspects will be beneficial. Key skills for this project include: - Expert knowledge of ASP.NET MVC 5 - Strong experience with Microsoft SQL Server - Ability to implement broad functionalities without specific instruction Experience with user authentication, data management systems, and real-time notifications will be a plus. Be prepared to share examples of previous work with these technologies in your bid.

...can develop an informative website primarily dedicated to showcasing our company's services. The website will cater to the general public, communicating key features and benefits of our services. Required skills and experience for this project: - Strong background in website development, especially in designing informational websites - Proven track record of creating user-friendly websites for the general public - Ability to effectively communicate our company's services through compelling website content There are three main objectives for this project: - Create an engaging, easy-to-navigate website - Accurately present our company's services - Design a site that appeals to a broad audience, from young adults to seniors Understand that while usability a...

More details: What type of database do you currently use for data archiving? MS SQL database What information should successful freelancers include in their application? Past work How soon do you need your project completed? Within a month

I'm seeking a professional Mobile App Developer who can assist in the creation of a Gym App marketplace for both iOS and Android platforms. This project calls for: - Designing user profiles and registration features to ensure personalization and security. - Incorporating a search and filter functionality for gym listings to provide an intuitive user experience. - Developing a booking and reservation system for seamless transactions. - Integrating payments system to facilitate easy transactions. - Constructing a schedule builder to enable users create personalized routines. The ideal candidate will have previous experience in multi-platform app development. This includes a background in gym or health-related apps and a firm understanding of secure payment gateways. Familiarit...

Objective: Migrate a Business Central database from SQL Server 2014 to SQL Server 2017. This involves installing SQL Server 2017, transferring the database, and configuring the NAS server to connect to the new SQL Server instance. Tasks: Install SQL Server 2017 on a suitable server. Back up the Business Central database from SQL Server 2014. Restore the backed-up database to SQL Server 2017. Update the NAS server's connection settings to point to the new SQL Server 2017 instance. Verify that the Business Central database is accessible and functioning correctly.

Hello, We have a large scale solution written mostly in .net MVC5, that we need updated...web development. - Strong background in API integrations. - Git and bitBucket - 3rd party API consumption and creating new API endpoints. - SQL Server - React 17, this is for ongoing maint of an small feature we have to host. Project Specifics: - Initial tasks will be to update existing library from .net 4.8 to 8 if we can and still have a functioning solution - Add new features/controllers to the system for on going dev. - Maintain existing features that need refactoring Ideal candidates will have a portfolio demonstrating relevant projects. I look forward to collaborating and discussing my detailed requirements with you. This is an ongoing project that should take about 1...

As the client, I'm looking to hire a mid-level developer proficient in C++, Qt...mid-level developer proficient in C++, Qt frontend, and experience with FASTDB and other sql-based real-time databases. You will be required to create a fork of an existing open-source software then migrate it into a modern development environment. Key responsibilities include: - Implementing changes in the user interface for usability improvements. - Adding additional features to enhance software functionality for ICS/OT/IOT systems - Integrating the software with third-party systems. The software should be compatible with Windows operating system. Kindly provide your day and monthly rates. Your ability to comprehensively fulfill these requirements will go a long way in ensuring a successful ...

I am looking for an exper...with knowledge of deciphering and compiling sales, financial, and logistical data. The project will require: - Consolidation and reporting on sales and financial data. - Developing robust logistical reports that include product inventory, delivery timelines, and supplier performances, as well as other elements we may discuss later. Being proficient in Excel (Office Scripts, VBA Macros, ) and other spreadsheet software is a must, with a preference for those who have past experience in dealing with substantial financial, sales, and logistic data. While there is no pressing time constraint for the project completion, I seek someone who can work consistently and maintain open communication to ensure the project is progressing and any ...

I'm looking for an experienced freelancer who can take my existing Excel workbook, used monthly to calculate sales commissions for ab...reporting. * Employ advanced calculations to extract deeper insights from datasets. What I'm expecting from you: - Proven expertise in Excel, especially with pivot tables and data analysis tools. - Strong background in VBA for macro development. - Keen eye for detail and a knack for data organization. - Ability to deliver a user-friendly interface that simplifies complex processes. - Creative problem-solving skills and an analytical mindset. Please provide examples of previous work with automation and pivot tables when you bid. Your expertise will help drive my project forward, ensuring more efficient data management and impact...

Hello I want sql database expert for enter huge data. Thanks

...format for importing into a SQL database; or - directly into a SQL table The zipped files are downloaded to local PC via MFT. Key Requirements: - Extract ALL data fields including: - Title and author details - Pricing and availability - Full product descriptions and categories - etc. - Ensure all information from ONIX is captured Inputs & Outputs Inputs - XML 3.0 Additions file - (lists new products) - file name format = (N) - XML 3.0 Update file - (lists changes to existing products) - file name format = (N) - XML 3.0 Deletions file - (lists ISBN's no longer available) - file name format = '(N) Outputs - Separate CSV files for each of the above with naming convention (N) OR: - SQL scripts importing...

...part in an SQL Server Integration Services project, focusing primarily on ETL (Extract, Transform, Load) processes. Key Responsibilities: - Manage a wide variety of data sources involved in this process; this will include database tables, Excel spreadsheets as well as CSV files. - Carry out necessary data transformations such as data cleansing, aggregation and formatting. I'm keen to engage with individuals experienced in data handling, data transformation and SQL Server Integration Services. Proficiency in working with various data sources like database tables, Excel, and CSV files is critical. Additionally, anyone with a background in data cleansing, aggregation and formatting would be highly desirable. The job requires meticulous attention to detail and s...

connect SQL database credentials to existing Asp.net web site project currently its connected to another SQL server. i want to connect it to the one in my pc project is compiled, we will have to decompile it (decompiled source code not retrievable)

Require Steamlit and langchain chatbot, This project requires the integration of a robust MSSQL database to manage the data efficiently. Project Deliverables: - A chatbot that provides language-learning resources - Seamless SQL database integration

...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

...understanding and experience in Microsoft SQL Server, more specifically with SQL database replication used for load balancing. - Objective: The primary purpose of this project is to implement a database replication solution that focuses predominantly on load balancing. - Performance Requirements: An emphasis on high availability is an absolute must for this project. I need a system that will maintain a continuous service without any downtime. - Skill set: Proven experience in managing Microsoft SQL Server and implementing SQL replication for load balancing is required. Knowledge in maintaining high availability of the server is a plus. If these requirements align with your expertise, I encourage you to place your bid. Let's discuss how w...

I am in need of a VBA mastermind who can help repair my failing Excel workbook. As it stands, the workbook is experiencing: The worksheet is a simple sheet which converts to PDF. The ideal candidate should exhibit proven expertise in troubleshooting and fixing Excel formula issues, with a particular knack for lookup issues. Sound knowledge in dealing with issues regarding excel function input and data referencing will be highly beneficial. Looking forward to having my workbook up and running error-free!

I'm seeking an experienced developer to integrate Vidrio API with Excel, enabling automated data extraction and entry into my spreadsheets, along with setting up an OTP (One-Time Password) system. Here are the essent...(One-Time Password) system. Here are the essentials: - Establish Excel API to write data. - Extract data from Vidrio API in real-time. - Implement OTP system for secure access. Ideal candidate's skills: - Proficient in Excel API integrations. - Experienced with RESTful APIs, preferably Vidrio. - Capable of setting up secure OTP authentication. - Strong understanding of database connections, such as SQL. - Attention to details and data integrity. The successful freelancer will assist in automating my workflow, ensuring data accuracy, and enhancing the secu...