Excel vba switch database connections jobs
I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases
To help streamline operations in our manufacturing firm, I'm seeking a professional with deep expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to be processed, we require an array of security measures. These include...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
I am seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Format: The final deliverable should be in Excel or CSV format. Experience Required: - Proficiency in Chinese language and familiarity with Chinese business conventions. - Previous experience in retrieving contact information. - Attention to detail and accuracy in data collection. Please reach out if you believe you have the necessary skills and experience for this task.
I have a domain name, , which I'm looking to sell within a month. I'm seeking a professional domain broker who can assist in the sale, leveraging various platforms and networks to secure a good price for the domain. Key requirements include: - Experience in domain brokering and sales, with a strong track record of succ...- Familiarity and access to domain marketplace websites, social media platforms, and private networking channels. - Ability to work efficiently and effectively to sell the domain within the specified timeframe. - Willingness to negotiate on the price of the domain, if necessary. The agreed commission for the broker will be 20% of the final sale price. If you have the necessary expertise and connections in the domain trading industry, I'd love to he...
Hiring a hybrid NYC remote assistant for a clean energy company. Job is Mond...calling) Job includes: -Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please include a 15 second audio of your speaking voice to show you have english of working pr...
I am in need of an expert Excel VBA programmer who can enhance my existing proposal workbook. The primary focus of this project is to integrate xlookup functionality and to enable the workbook to generate additional rows and tabs that pull data from various sources. Key Tasks: - Implementing xlookup function: The freelancer is expected to introduce this specific function into the workbook, allowing for efficient data retrieval. - Generating additional rows: The workbook should seamlessly add rows as needed, ensuring comprehensive data management. - Pulling data from tabs: The expert should enable data extraction from various tabs within the workbook, ensuring a streamlined process. - Generating additional tabs: The workbook should be equipped to create new tabs as required,...
I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.
I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability to efficiently handle large datasets and work through complex data structures...
...of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Google Sheets and database creation - High attention to detail - Demonstrable ability to classify and categorize data. The goal of this project is to track changes over time, based on the data scrapped. This requires a design that will facilitate easy updates and quick overview of changes. Hence, knowledge and experience in data visualization will be an added advantage. I've added a few screenshots of...
I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and e... Irwin & Dow - Premier Recruitment - ManpowerGroup - Mark Williams - Robert Murray - Future Tense - Black & Grey - Education 1st recruitment - Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets.
i will create 1 power power point and 1 excel sheet adding the equations
I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.
As someone looking to hire a talented content writer, I have a variety of assignments that'll involve writing content within a word limit of 500-1000 words. I didn't specify the exact type of content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experie...content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experience: - Excellent writing skills - Versatility in content writing - Ability to generate creative ideas - Experience in varying styles and formats of writing - Understanding of SEO is beneficial, but not required If you believe you would excel at this, I encourage ...
We are looking for an individual with the ability to locate pointers within Nintendo Switch Pokemon games. These pointers will then be used to create a routine within the game required. C# is not used for pointer finding. There are specific programs available to find such pointers, which we can provide. Ideally, you have a v1 Nintendo Switch to enable you to do pointer finding. C# knowledge is essential to this project - as the pointers found, will be implemented into an already existing Windows application which is written in C#. We would then require the individual to write a routine using these pointers found. We can provide an example of how this routine would look, from previous Pokemon games. To ensure we know you have read the full description of this project, pleas...
I'd like to request a quote for "xl heet and powerpoint".
We're looking for a web developer to refine an existing HTML page! You'll take a previously converted Excel sheet (.html) and enhance its visual appeal. This involves adding CSS styling to improve the layout, formatting, and overall aesthetics of the page. Experience with HTML and CSS is a must, and an eye for clean and user-friendly design is a plus!
I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model w...
The project requires a freelancer with exceptional attention to detail and expertise in Excel to conduct a thorough review of a spreadsheet for any data inaccuracies and anomalies. The primary tasks involve identifying and rectifying incorrect or illogical entries, ensuring the consistency and integrity of the data, and highlighting any variables that require correction. The ideal candidate for this role should have strong proficiency in Excel and data handling, as well as experience in data quality assurance. This meticulous review is crucial to maintaining the accuracy and reliability of the data, which is essential for making informed decisions based on the spreadsheet information. Attached with the details is a sample of the spreadsheet with 20 participants. The complet...
...individual who can handle a medium-sized excel database (1000-5000 rows) that comprises of numerical, categorical and textual data. Key Tasks: - Data Entry: The selected candidate will need to input some outstanding data into the excel database accurately. Great attention to detail is vital for this task. - Data Analysis: I want someone who can decipher patterns and trends from raw data. This may include evaluating figures, trends, and other areas to draw practical insights. - Data Visualization: After carrying out an in-depth analysis, I want the extracted information to be presented visually to aid understanding and decision-making. Desirable Skills: - Proven experience in data entry, analysis, and visualization - Proficiency in using excel ...
As a beginner, I'm in need of someone skilled in typing data into Excel spreadsheets. The data entry will involve basic formulas and functions for simple data analysis, and I'm looking for someone who can make this process easy to understand and execute. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Able to explain basic formulas and functions in a clear and concise manner - Attention to detail to ensure accurate data entry - Patience and understanding of beginner level tasks
I am looking for a specialist to create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI tes...create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI test cases, with a clear emphasis on user interaction tests. - Setting up and integrating Routing and Guard Components for authorization. - Developing a backend in Spring Boot. - Saving credentials in a MySQL database. Ideal candidates should have solid experience with React Js, Spring Boot, and MySQL database. Proficiency in creating user interaction tests is also a must. Once completed please provide a GitHub link for the project in .docx file with scree...
...accurately entered into an Excel spreadsheet. This will be done manually, so you must have excellent typing skills and attention to detail. - **Turkish Characters Proficiency**: An essential requirement for this job is a strong proficiency with Turkish characters. As some of the books will have titles and authors in Turkish, you should be able to accurately interpret and enter these characters. - **Handling Missing Data**: In the event that a book's details are missing or illegible, I would like you to search online for the information. If this is not possible, then the field should be left empty. Please note that I do not want placeholders like "Unknown" used in the spreadsheet. Your responsibilities will include: - Typing in the book title and author accuratel...
I am seeking an flutter developer to make a single modification: switch it from dark mode to light mode. Here are the details: - I have purchased flutter app code from Codecanyon. I just want someone to build ios app with that purchased code & publish to app store by changing app name, app icon, package name, splash screen animation etc... - Color Adjustment: The color scheme should be shifted to neutrals and pastels to suit the light-mode aesthetic. Specifically, I want to change colors, not fonts or icons. - Publishing to the App Store: It's crucial that you have experience in this area, as I will need you to guide the app from final code to publication. Rest assured, I possess the necessary files and credentials. Ideal Skills: - Expertise in iOS app publishing - ...
I am seeking a proficient PCB Designer who can help me design a PCB layout for Buck Boost Converter circuit. The project specifics are: - The PCB is only two layers. Front copper layer and Back copper layer. - KiCad is the software to be used. - Working with both through-hole components and surface-mount devices to develop the PCB. - The primary application of this board is for prototyping, so accuracy and attention to detail are a must. Please make sure to include examples of your past PCB designs in your proposal if available.
...of a freelancer who can help me create a visually appealing PowerPoint presentation and handle some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication skills to understa...
...relevant and linguistically accurate, you'll help foster a deeper appreciation for literature among Tagalog and Thai-speaking readers, enriching their literary experience and broadening their project is not just about translation; it's about cultural exchange and mutual understanding. Through your work, you'll contribute to building bridges between languages and cultures, fostering connections and sparking conversations that transcend borders. Whether you're a seasoned translator or a budding linguist eager to make your mark in the world of literature, we invite you to join us on this rewarding journey of exploration and our team of passionate translators and play a vital role in bringing the timeless magic of English literature to Tagalog and Thai audiences...
I'm seeking a skilled app script professional to improve functionality in my current Google Sheets. The job entails creating connections with external APIs, and add a multiple drop down function in Google sheet. This is different than dependent drop-down and I require to use just one cell for the multiple drop down rather than using the next cell. Key requirements: - Add two dropdown menus - The menus need to feature a predefined list of words - Experience with Google Sheets and App Script Recommended skills: - Google Sheets - Google App Script - API Integration
I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.
I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.
My current server setup is causing slow response times for my web application and database system. This project involves optimizing the server settings to enhance the performance of both the web and database applications. Ideal Skills and Experience: - Proven experience in server performance optimization - Expertise in managing servers running web applications and database systems - Familiarity with Laravel, as the web application is built using this technology - Excellent understanding of server-side technologies and configurations Key responsibilities: - Diagnose the current server setup to identify performance bottlenecks - Implement necessary changes to optimize the server settings - Regularly monitor and fine-tune the server to maintain high performance - Provi...
I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data
I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English
I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high standards of accuracy and confidentiality ...
I'm in need of an electronics professional who can convert my detailed Arduino connections into a clean, organized schematic diagram. - You will work on the Digital input/output pins, Analog input pins, Power supply connections, literally all connections of my Arduino setup. Essential Skills and Experience: - Knowledge of Arduino - Proficiency in creating schematic diagrams - An eye for detail, and great organizational skills. A schematic will help us represent my setup visually. Our goal is to have a convenient direction for future referencing. In your bid, please include examples of similar work you've done in the past.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
I'm in need of a talented mobile app developer to create a cross-platform app for solo travelers. This app should work on both Android and iOS devices and must be completed as soon as possible. Key Features: - Social Networking: The app needs to facilitate connections between solo travelers. - Trip Planning: Users should be able to plan and organize their travel itineraries. - 1-1 Chat: A feature for private communication between users. - Create Travel Groups: Ability to create and join groups based on travel interests. - Explore Interests: Users should be able to discover and share their interests while traveling. - Explore Countries: Information and resources for understanding different countries. Ideal Skills and Experience: - Proficiency in both Android and iOS app develo...
Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I require a software solution that can extract and unlock full calibration data from a sensor for further analysis. The software must have the ability to interact wi...fully extract the calibration data from the sensor - the tool should be user-friendly and have a clear interface - the software should have a USB connection for the sensor - the software should be able to output the data in a readable format for further analysis Ideal Skills: - Proficiency in software development - Experience in sensor calibration and data extraction - Familiarity with USB connections and software interfacing - Strong understanding of data analysis and presentation The project will require a combination of technical and practical skills, so please only apply if you have the necessary experience in t...
...be dynamic connections for everything to our database, just as it currently is set up. Most of your images are currently 680x340 in size, so we will need you to run an AI process to increase the size of the images we currently have to match teh new site design. We want larger images anyway, so this is necessary. This will require 19 different types of pages. Must add a blog, including parent pages and blog posts pages The site must be set up with premium security, caching, JetPack, etc. We will supply all plugins and purchase all licenses but we need you to tell us which plugins/themes you need. After the pages are built, all content must be imported to the new site design. In other words, we need a completely new WP design for our website that is connected ...
...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...
...affecting all the pages on my website. I've been utilizing the WordPress default menu manager to handle the menus. This problem is hindering my ability to update and manage the content effectively. I am seeking a proficient Wordpress developer who can: - Diagnose why the dropdown menus aren't functioning properly. I believe it is has something to do with the theme I'm using (Roosevelt) because when I switch themes the dropdowns start working. This started when I updated to the newest version of Wordpress. - Use their extensive knowledge of Wordpress and its default menu manager to rectify this issue swiftly. - Provide a guideline on how to avoid this in the future to keep my website up and running optimally. Ideal skills for this job include excellent knowledge...
I'm looking for a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzing past purcha...
I'm looking for an experienced developer who can work on an Android application with significant social networking features. The app should have user profiles and authentication, as well as friend connections and messaging features. Ideal skills and experience: - Proficient in Python, with expertise in developing Android applications - Familiar with social networking app development - Experience with implementing user profiles, authentication, friend connections, and messaging Please only apply if you have a strong background in both Android and Python development, with a portfolio that demonstrates similar projects. Your understanding of social networking app dynamics will be a big plus. Thank you.
My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with ...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
