Import sql backup file excel jobs

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

I need a professional to analyze some data from an Excel file. The project primarily involves numerical analysis with a focus on identifying trends and patterns in sales data. Ideal candidate should: - Have proven experience in data analysis, particularly with Excel. - Be skilled in identifying and summarizing key trends and patterns in numerical data. - Be able to present findings in a clear and concise manner. - Have a good understanding of sales trends.

...number of historical records in some of the data fields has proven to be impractical (tens of millions of records) to download using the API as it is simply too slow. I am open to alternative methods here though. There will be a limited number of transforms (calculated fields) based upon the existing data structure, perhaps 15-20. Ideally, once the database is set up, I'd like to create a system (Excel or custom) to connect to the database and run a series of statistical queries on it. That does not need to be part of the original scope of work, but if the same developer can assist with this part that would be great. A previous freelancer started this project. They set up the database and tried using the API to do the initial download. Most of the data tables were able to...

I'm looking for a professional visual style for an interactive schedule planner in Excel. This project will require some experience with the developer tab. Key Requirements: - The schedule planner should feature automatic updates, conditional formatting, and data validation. - It should have a polished, professional appearance. - User interaction will be primarily through selecting from drop-down lists. Ideal Skills: Provide ideas that will make the spreadsheet user-friendly - Advanced Excel skills including developer tab proficiency. - Excellent understanding of conditional formatting and data validation. - Strong design skills for creating a professional layout. - Experience with creating interactive Excel tools. Please provide examples of similar projects ...

...Home-Based Businesses Traditional Business Mentorship 7. Jobs Skill Development for Employment Job Search Strategies Resume Building Interview Preparation 8. Wellness Fitness Coaching Mental Health Yoga, Meditation, and Ayurveda Vaastu & Astrology 9. Legal & Compliance Regulatory Compliance Business Contracts Company Law Legal Consulting 10. Exports and Imports Exporting Goods International Trade Import Regulations Customs Clearance Documentation 11. Government Schemes Entrepreneurship Schemes Subsidies Government Programs & Welfare Plans What We’re Building Our project spans multiple industries, aiming to develop solutions that integrate technology, agriculture, business, wellness, and more. Each contributor will play a key role in their area of expertise...

I’m looking for someone to search for products on Amazon and list them in an Excel or Google Sheet. What you’ll do: Search for products in specific categories that I will provide. Record the product title and the link to the product page. Requirements: Basic knowledge of Excel or Google Sheets.

...Regularly report on the effectiveness of demand generation efforts to stakeholders. Preferred candidate profile • Bachelor's degree in IT, Computer Science, or related field, • Master's degree in Marketing or related field (preferred), • At least 3 years with minimum 2 years of experience in B2B demand/lead generation or related roles for an IT Services company, • Proven track record of meeting MQL/SQL targets from India and ANZ US/Europe geographies, • Previous experience in driving deals to closure, especially in an IT services set-up, • Sound understanding of digital technologies like IoT, AI/ML, Cloud, Digital twin and their applications, • Proficiency in marketing automation platforms and CRM systems. • Exceptional commun...

I need a Database expert who can just make me .sql dump from a database folder. I had a MySQL Docker backup which also contains database (each database has a folder) I have complete folder of a database. I need to extract the table structure and the data as .sql dump

I need a professional to set up an email notification system for my staff, using Excel and Outlook. Key requirements: - The system should send an email to each staff member whenever a cell related to them changes value. - The cells are populated with dropdown list values. - The emails should be simple text, not HTML or pre-designed templates. Ideal skills for this project include: - Advanced Excel skills - Proficiency with Outlook - Experience with setting up automated email systems - Good understanding of drop down lists in Excel This is an opportunity to help me streamline communication with my staff and ensure they are updated in real time.

I require assistance with cleaning up my Excel files. I have three Excel files, and I need duplicates in one specific column of the first file removed from all 2 files. The structure of all files is the same, with identical columns. Ideal skills for this project include: - Proficient with Excel - Attention to detail - Experience with data cleaning Please be prepared to delete identified duplicates from all files. Budget $5

My WordPress e-shop has encountered a critical issue, displaying an HTTP ERROR 500. This occurred suddenly and without any forewarning. I can still access the site via cPanel, but attempts to log into the WordPress admin panel result in a troubling error message regarding the file. The website was functioning properly until this morning. Recent changes include: - An update to WordPress and some plugins. I have a detailed list of these updates available. Fortunately, a backup was created prior to these changes. I urgently require the expertise of a WordPress/PHP specialist to diagnose and resolve this issue.

...action items. Goals & Objectives Provide a structured template where I can easily add, categorize, and prioritize keywords. Include columns/tabs for capturing key SEO metrics (search volume, CPC, competition/difficulty, intent, etc.). Offer a clear workflow: from brainstorming seed keywords to final content mapping. Maintain consistent formatting that remains stable when exporting to or opening in Excel (if using Google Sheets) and/or in platforms like AppSheet. Make it intuitive and visually organized, with instructions or user notes so anyone on the team can use it easily. Key Features / Requirements Data Collection Tab Columns for keyword metrics (search volume, CPC, keyword difficulty, search intent, etc.). Ability to easily sort/filter based on priority or relevance. B...

I'm looking for a PHP web application function that can compare two Excel sheets. - The function should highlight the differences between the two sheets. the web app should provide the output excel as coded. Ideal candidates for this project should have: - Strong skills in PHP and web app development. - Experience with Excel sheet manipulation and comparison. - Ability to implement a user-friendly interface that highlights differences clearly.

Data from pdf or word files to system software

...am looking for a skilled developer to help deploy an existing solution that automates Word document text replacement using VBA and outputs a PDF file. I already have a fully functional VBA code and an HTML interface to generate the code. The project involves using this existing logic and expanding it to work seamlessly on a server-based environment. Key Requirements: PDF Output: The system should take user inputs through the existing interface (or an upgraded version) and automatically replace the specified keywords in a Word document. Once the replacement is complete, the system should generate and provide the user with a downloadable PDF file. Database Integration: Create a database to store keywords used for replacement. Provide an option to select previously stored...

I need a skilled Python developer to resolve import errors for a project built in 3.9 to 3.13. The application uses a few external libraries. There are issues with hierarchial imports. I am trying to run this Project in Python 3.13: Key Requirements: - Expertise in Python, particularly versions 3.9 and 3.13 - Experience with command-line tool development - Ability to troubleshoot and resolve library compatibility issues - Knowledge of external libraries commonly used with Python Your Role: - Upgrade the tool to Python 3.13 - Ensure all functionalities are preserved post-upgrade - Identify and resolve any compatibility issues with external libraries - Provide recommendations for any necessary library updates or replacements When

I have a task that requires converting a small set (1-10) of scanned documents into an Excel sheet. The documents contain mixed data (text and numbers) and some handwritten elements. Ideal Skills and Experience: - Proficient in Microsoft Excel - Excellent attention to detail - Capable of deciphering and transcribing handwritten content - Experience in data entry and document conversion - High level of accuracy and efficiency in handling mixed data types

I'm seeking assistance with customer analytics specifically tailored for a real estate operator. I've provided four recordings detailing the three deliverables needed: overview https://w...a165a96621c deliverable 2 - identify highest CLV attributes deliverable 3 - prospect velocity thru 5 deal stages All three deliverables are of interest to me, but if you can solve 1 or 2 that is fine. I don't have a specific tool or software preference. I'm open to using Excel, data analytics platforms - whatever can solve the job accurately and that you're comfortable with. As for the format of the final deliverables, I'm flexible, whatever can present the deliverable accurately.

I'm looking for a detail-oriented professional to help with spreadsheet data entry. The task involves transcribing product information from PDF files into a spreadsheet. Ideal Skills: - Proficiency in using spreadsheets (Excel, Google Sheets) - Attention to detail - Ability to transcribe data accurately from PDF files - Understanding of product inventory management (preferred but not essential)

...while maintaining design integrity, consistency, and usability. The final Canva version should allow for easy edits and updates by non-designers while retaining the professional look and feel of the original InDesign file. Project Objectives - Accurately replicate the design, layout, typography, and branding from InDesign to Canva. - Ensure all text, images, and graphical elements are editable in Canva. - Maintain consistency in styles, fonts, and colors. - Optimize for easy future edits by non-designers within Canva. Scope of Work 1. Review & Analyze - Assess the InDesign file to understand the structure, layers, typography, and graphic elements. - Identify any complex elements (e.g., advanced typography, effects, or linked assets) that may require adjustment in Can...

I'm seeking a diligent data entry expert to assist with transferring information from an online database into MS Excel. Key Requirements: - Proficient in MS Excel; familiarity with data manipulation tools within Excel is a plus. - Attention to detail to ensure accuracy of data entry. - Ability to work independently and manage time efficiently. - Prior experience with data entry from online databases preferred. Please note, the data type is mixed (both numeric and textual), so a good command over both types is essential.

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection and pressing o...

I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered shoul...and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Lookin...

...Closing Skills Ability to proactively communicate, engage, and influence proper decision makers Ability to execute sales strategies, think clearly and overcome objections Strong personal accountability with track record for delivering on expectations/commitments with focus, perseverance, and tenacity Requires knowledge of and the ability to use computer software such as MS Office Suite (Word, Excel, PowerPoint, Salesforce, and Outlook)...

Please Sign Up or Login to see details.

I want to create a remote start system for my BMW E60. The system will use an esp32 c3 to communicate with my phone, and a arduino mega to handle the sensors,and everything else ( esp is only for comunication ). Once close, it should start the car. As a backup, it will use an R503 fingerprint sensor for authentication. The app is already made by me in thunkable Key components of the project: - mcp2515 to detect engine RPM and door status via bmw K-kan bus. - Arduino to check shifter position using a Hall sensor, engine RPM and handbrake signal to permit remote start. Communication: - The primary communication method will be Bluetooth Low Energy (BLE) to interact with my phone. I need someone who is: - Very active on freelancer or platforms like WhatsApp, Facebook, etc. - Willing...

Project Title: Build a Chatbot on Azure SQL with LangChain and Chainlit Project Description: We are looking for an experienced developer to build a chatbot that integrates with our existing Azure SQL database, leveraging LangChain for LLM-based query orchestration and Chainlit for the frontend chat interface. The chatbot will enable users to interact with and retrieve insights from data stored in our database using AI. The project involves: Setting up Azure SQL with vector support for embedding and similarity search. Developing Python scripts using LangChain to handle data retrieval, embedding generation, and prompt orchestration. Integrating the backend with Chainlit to create a user-friendly, scalable chat interface. Key Deliverables: A functional chatbot that ca...

I'm a complete beginner in databases and I'm in search of a knowledgeable instructor who can teach me about various aspects of databases such as data modeling, logical design, SQL database design, query optimization, and transaction processing. - Ideal Skills: - Strong understanding of database concepts and design - Proficiency in SQL - Experience in teaching or training - Ability to create engaging and practical hands-on exercises I prefer to learn through hands-on exercises rather than video tutorials or reading materials. Therefore, the instructor should be able to provide practical, real-world examples and exercises that can help me understand and apply the concepts being taught.

I need a skilled web scraper who can extract data from a members area of a website. The data should be compiled and delivered in an Excel file. Website Scraping of Members Area Ideal Skills: - Web scraping expertise - Proficiency in Excel - Attention to detail

I need an expert in Excel to help me with an Index Match formula. It's intended to locate numeric data from a single table based on 2 criteria. Key Requirements: - Proficiency in Excel, particularly with Index Match formulas - Experience working with numeric data - Ability to match data based on multiple criteria If you have the requisite skills and experience, I would greatly appreciate your assistance.

We're seeking a seasoned software developer with expertise in C# and experience in migrating systems, to help us modernize our small retail business accounting system and POS currently written in VFP9. The project involves: - Migrating approximately 172,000 lines of code. - Handling 414 dbf files, 134 scx files, 58 fmt files, and 268 frx files. - Identifying and excluding non-essential backup files. As the CEO of BSS Inc., I am particularly interested in a developer who can provide an accurate approximation for the conversion time and cost, as well as a proposal for the migration process. Ideal skills: - Proficiency in C# - Extensive experience with .NET framework - Solid understanding of MySQL - Proven history of system migrations - Ability to estimate project timelines a...

Hi. I would like to scrape oddsportal for game results,closing and opening all odds import them into excel. I am interested in soccer matches. The scraper should be able to scrape data according to date i.e. I would like to input a date range and sport (soccer) and get the match details for those matches. Further details will be discussed with bidder. I should also mention that date range for scrapping data could be quite long (i.e. months) so the output xls could be quite big. It is very important to me that scraping is done as quickly as possible (seconds) with as less clicks as possible and without hanging-up or crippling my PC while scraping. PROJECT DETAILS: Sport:----------------------Football Bookmaker:------------------Bet365, BWIN, Pame Stoixima, Stoiximan, Int...

I'm looking for an expert in AI tools to scrape a website for me. The goal is to extract specific contact information and organise it neatly in an Excel sheet. Data to be Scraped: - Email addresses - Phone numbers - Names - Zip Codes The ideal candidate should have prior experience in web scraping and data management. Proficiency in using AI tools for this task is crucial. Data Formatting: - I need the data to be sorted into separate sheets for each type of information. Please provide examples of previous similar tasks you have completed successfully.

I'm looking for a freelancer who can create an Excel spreadsheet containing names and verified email addresses of businesses located in specified postcodes in Sydney, Australia. The project entails: - Collecting data on approximately 1500-2000 businesses - Including business names and email addresses in the spreadsheet - Ensuring that all email addresses are verified The ideal freelancer for this project should have experience in data collection and spreadsheet creation, with a keen attention to detail. Prior experience in sourcing business data will be an added advantage. Please note that the types of businesses and additional data points (like physical address, phone number, or website URL) are yet to be determined. The primary focus at this stage is just on business names ...

I'm looking for a script or batch file or any other suitable automation method to permanently remove the following elements in Windows 11 23h2: - Address bar - Search bar - Navigation pane The automation needs to be applied in two modes: - Automatic at startup - Manual script that runs on demand Please note, I require these elements to be permanently removed, with no option to restore them. This should be applied to all local accounts created in the group (users). For existing and future accounts . Attached is a picture of what needs to be removed . The script or the automation method will be tested through MDT. Ideal skills for this project include proficiency in scripting and batch file creation, with a strong understanding of Windows 11 file explore...

I'm looking for a skilled Excel expert to create a comprehensive Excel sheet for managing our swag items. The sheet should include the following columns: - Brand - Category - Campus - Item - Cost per item - Quantity - Item link - Dropbox link to the design The sheet will primarily be used for order planning and will need to be updated weekly. It should contain calculations for the total cost and a summary of quantities. Pricing details for various items are provided, and the Excel sheet should accurately reflect these costs. Ideal Skills: - Proficiency in Excel - Experience with inventory management - Ability to create complex formulas Key Features: - Order planning focus - Weekly updates - Total cost calculation and Quantity summary Please note, th...

I need a proficient Excel professional to assist me with some office work. My data is currently organized in a single spreadsheet with multiple tabs. The tasks I need help with involve: - Formula creation and calculations - Data analysis and reporting - Organizing my data according to specific requirements It's worth noting that I have a combination of prepared data and data that needs to be gathered. The ideal freelancer for this project should be well-versed in Excel, with a strong understanding of data organization, formula creation, and data analysis. Good communication skills are essential, as well as the ability to follow specific instructions for data arrangement.

I am facing an issue with my Node.js/Javascript web application. I've created a multivalue field to store a string of days, but the code is populating the field with null instead of the selected data. - The application is deployed on a local machine - The data is being stored in a SQL database - I'm using an SQL database, like MySQL or PostgreSQL I need an experienced Node.js and Javascript developer who is also familiar with SQL databases to fix this issue for me.

I'm seeking a financial expert to create an Excel spreadsheet that projects the financial trajectory of an investment portfolio as it transitions from an operating company to three holding companies. These holding companies will serve the purpose of funding life insurance premiums. Key components of the project include: - Annual funding of a life insurance policy from the investment portfolio, coupled with a life insurance premium loan each year. This should detail the interest rate, annual deductions, and the net cost of the loan. - Retirement amounts for each of the three holding companies, sourced from both the insurance and investments, from ages 71 to 90. - Demonstrating the accumulated growth of the portfolio, with $3.9M in each holding company, and life insurance death ...

...a HIGHLY skilled professional to calculate existing numerical entries and add formulas for additional numerical entries to automatically calculate. Currently doc is in Word, but not opposed to Excel if it is faster and easier. Doc also needs page numbering (no page number on first page). Will need a grand total at end of doc. Deadline is Saturday, 01/25/25 or Sunday, 01/26/25. Key Requirements: - Add formulas to calculate the sum and averages of current and future entries. - Ensure calculations update automatically when new entries are added. Ideal Skills: - Proficiency in Microsoft Word and Excel. - Experience in creating automated calculations in documents. - Ability to translate numerical data into meaningful insights. Your expertise will ensure I can easily track a...

I'm seeking help with web research and data entry in Excel, specifically focused on finding contact details for dentists in Kuala Lumpur. Key responsibilities: - Conduct web research to find business contact details of dentists in Kuala Lumpur - Email out scope to professional dentists in Kuala Lumpur - Data entry results into an Excel spreadsheet Important skills and experience: - Proficiency in Excel - Strong web research skills - Previous experience with data collection preferred I am particularly interested in collecting the following contact details: - Email addresses - Phone numbers - Physical addresses Deliverables: - An Excel spreadsheet with the collected data Please note: I am looking for prices and the ability of the dentist to perform cer...

here are the files I have created describing each page how I want it to be created and implemented I have proposed sitemaps and file structure for all and have created these pages with AI I need everything to be messed together now please use the latest and greatest AI tools to speed up your development like: windsurf by Codium cursor ai cline roo cline and any other tool you might need the files have been created, and everything needs to be meshed together in a coherent cohesive manner help me create a better explained and elaborated detailed plan for a project proposal to Upwork for developers

I need a comprehensive Excel sheet designed for cabinet selection geared towards order processing. The Excel sheet should have dropdown menus facilitating the selection of different categories, automated calculations for cost and dimensions, and conditional formatting to visually represent data variations or thresholds. Key Features: - Dropdown menus for selecting material types, color options and various construction components (like doors, drawer fronts, hardware etc.) - Automated calculations to keep track of totals, dimensions, and other necessary metrics - Conditional formatting to help easily identify key data points or anomalies I will provide you with a detailed list of all the necessary construction options, which will encompass standard, custom, and semi-cu...

I need help with an Excel form that involves mathematical calculations, specifically sum and averages. The calculations need to consider certain specific conditions or criteria. Ideal Skills: - Proficient in Excel, particularly in creating and troubleshooting formulas. - Strong understanding of mathematical calculations. - Experience with conditional calculations, such as IF statements. Please provide your experience with similar projects in your bid.

I am looking for a talented graphic designer to revamp the annual catalog of Enocratico, a company specializing in the import and distribution of premium wines, with a focus on Burgundy wines. The catalog is aimed at high-end restaurants and must strike the perfect balance between elegance and professionalism, while showcasing a creative, modern, and fresh design that captivates without being overwhelming. Project Details: Format: Digital and printable catalog (technical specifications to be discussed). Pages: Approximately 25. Required Style: Elegant, creative, and modern, with a fresh and clean aesthetic. The design should reflect the premium quality of the wines and convey a sense of exclusivity. Content: I will provide the main text and images. The designer wil...

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and sorting d...

I'm looking for a skilled Visual Basic programmer to assist in automating my reporting process through Excel. Key Responsibilities: - Utilize Visual Basic to streamline the reporting process - Source data exclusively from Excel spreadsheets - Generate detailed reports Ideal Candidate: - Proficient in Visual Basic and Excel - Experienced in creating and automating detailed reports - Capable of understanding and executing complex data manipulation tasks.

I'm seeking an experienced Excel specialist to create a software-based Gantt chart for me. This chart should incorporate task dependencies, progress tracking, and resource allocation capabilities. Key Requirements: - Proficiency in Excel with a strong understanding of its advanced features. - Experience in creating interactive, software-based Gantt charts within Excel. - Ability to incorporate task dependencies, progress tracking, and resource allocation into the Gantt chart. Ideal Skills: - Advanced Excel skills - Project management software experience - Strong attention to detail - Excellent communication skills

I need an Excel sheet that encompasses tracking for staff attendance, leave, and performance. Key Requirements: - Attendance Tracker: Should facilitate daily attendance logging. - Leave Tracker: Must include leave balance tracking. - Performance Tracker: Primarily focused on monitoring task completion rates. Ideal Skills: - Proficient in Microsoft Excel. - Experience in creating tracking systems in Excel. - Understanding of HR metrics and performance tracking. The freelancer should be capable of producing a comprehensive yet easy-to-use Excel sheet tailored to these requirements.

I'm seeking a professional who can integrate Power App with Power BI primarily for automation purposes. This integration should streamline data entry, facilitate report generation, and improve workflow management. Key requirements: - Proficiency in Power App and Power BI - Experience in automating data entry, report generation, and workflow management - Ability to work with Excel spreadsheets as the primary data source Please provide examples of similar projects you've completed.