Mysql backup excel jobs
I have a Python code that processes an input form. I need a Python expert to help me integrate multiple Excel files into the code, perform sorting and filtering, and provide the output. This task is expected to take no more than one hour. The ideal candidate should be available to start immediately and work remotely on my system. Key Responsibilities: - Insert 1 to 5 Excel files into the Python code. - Perform sorting and filtering calculations on the Excel files. - Provide the output after processing. Requirements: - Proficiency in Python. - Experience with Excel data handling. - Ability to work with inconsistent data structures. - Immediate availability for a remote session.
I'm seeking an Excel expert to create a macro that automates data entry for daily inventory updates. Key Requirements: - Proficiency in Excel, specifically in developing macros. - Experience with Visual Basic for Applications (VBA). - Ability to streamline repetitive tasks and ensure data accuracy. Task: - Automate the entry of inventory details into Excel on a daily basis. The goal is to save time and reduce errors in our inventory tracking process. Your expertise in data processing and problem-solving will be crucial in delivering a tailored solution that meets our needs.
I'm looking for an expert to set up a self-hosted Passbolt on a VPS created on our OVH Cloud account for my team of 5. Key Responsibilities: 1. Create and configure a VPS on our OVH Cloud account. 2. Install, set up, and secure Openbolt. 3. Provide basic training for my team. Se...Enforcing user roles and permissions. - Keeping Passbolt and system software updated. - Enabling logging for security audits. Furthermore, I would appreciate your guidance on the following: - Monitoring server performance, uptime, and logs. - Quick training for one user on secure usage. - Creating a recovery plan for lost 2FA devices. - Steps to take in case of a crash and how to recover from backup. Please note, we are working with a limited budget. I have a background in IT, so communication sh...
...performance Client activity reporting Revenue tracking Outstanding payment monitoring Filtering by date ranges, brokers, charterers, etc. 7. Security Requirements Role-based access controls Data protection measures Audit trails for changes to critical fields Technical Requirements MS Access 2016 or later compatibility Option for multi-user access on network Scalable design to accommodate growth Backup functionality Data import/export capabilities Deliverables Fully functional MS Access database application User documentation and training materials Technical documentation of database structure Installation guide 30 days of post-deployment support Timeline Initial consultation and requirements confirmation: _______ Database design approval: _______ Development and initial te...
I'm seeking a seasoned Excel expert to develop a macro aimed at automating repetitive tasks in my spreadsheets. Key Responsibilities: - Create an efficient macro that streamlines routine operations in Excel. Ideal Skills and Experience: - Deep understanding of Microsoft Excel. - Proven track record of developing effective macros. - Excellent problem-solving skills. - Ability to simplify complex tasks into automated processes. The specific tasks to be automated haven't been defined yet, so flexibility and creativity in finding opportunities for automation will be highly valued.
My website/web application is experiencing several urgent issues that need immediate attention. Key Problems: - UI/UX Issues: Misaligned elements, broken buttons, and inconsistent styling. - Functionality Errors: Features not working as expect...responsiveness problems, or crashes. - Backend Bugs: API failures, database errors, or server-side issues. Requirements: - Diagnose and resolve all reported bugs. - Ensure cross-browser and mobile compatibility. - Optimize performance for better speed and efficiency. - Conduct thorough testing before deployment. Preferred Skills: - Proficiency in my tech stack: JavaScript, React, Python, Django, PHP, MySQL. - Experience in debugging and troubleshooting complex issues. - Looking for a skilled developer to quickly and efficiently resolve t...
...each completed tab. Key Features: - User Authentication: The portal should require two-factor authentication in addition to a username and password for enhanced security. - Text and File Inputs: Customers will need to submit both text and file uploads. The portal should have designated fields for each. - File Uploads: The portal should support file uploads in three formats: PDF, JPEG/PNG, and Excel/CSV. - Progress Tracking: Each portal tab should display a checkmark when the corresponding section has been completed. - Administrator Access: We need to have constant access to the portal, enabling us to monitor customer progress and view submitted information in real-time. Ideal skills include: - Proficiency in web development and security protocols. - Experience in creating user...
...for the Prototype: ✅ Web Scraping: Extract structured data (e.g., cost, location, schedule, description, age range) from targeted websites ✅ Data Storage: Save scraped data in a database (PostgreSQL, MySQL, or another recommended option) ✅ Search & Filtering: Users should be able to search by categories (e.g., location, cost, type, age group) ✅ Simple Web UI: A basic, user-friendly web interface to display and interact with the data Ideal Skills & Experience: ? Web Scraping – Experience with Python (BeautifulSoup, Scrapy, Selenium) or other scraping tools ? Database Management – PostgreSQL, MySQL, MongoDB, or other scalable solutions ? Frontend Development – Basic HTML, CSS, JavaScript, or a simple frontend framework (React, Vue, or Bootstrap) ? ...
We're looking for an experienced freelancer to update our sales data in Excel. This is a one-time update that needs to be completed within 7 days. The work involves updating and ensuring the accuracy of our sales figures. Familiarity with Excel functions and data management is essential. • Task: Update existing sales data in Excel • Timeline: 7 days • Skills Needed: Excel, Data Management, Attention to Detail Budget: INR 140 to 220 per hour
...This is an intensive, manual work project that will take at least 2 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote 2 hours now. It cannot be automated or run via a script. It cannot be "done using AI". Please do not waste your valuable time trying to do these. The task: We have multiple schools for which student data needs to be cleaned up one by one. This task is for the first school. You will be evaluated based on your performance for this first school. There are approximately 1000 records for the first school. These are student data for a school in India. Your task is to neatly organise and paste the student data into an Excel worksheet (upload format worksheet is attached). Th...
...collect structured data from the search results and provider profiles. Scope of Work: Estimated 4000 data lines with multiple fields. Extract provider details, including (but not limited to): Name License Number License Type & Status Specialty Practice Address & Contact Information Board Certifications Handle pagination and ensure the entire dataset is captured. The data should be exported in CSV or Excel format. The script should be repeatable (i.e., I should be able to run it again if needed). Compliance check: Ensure scraping adheres to the website's terms of service. Preferred Tools & Skills: Python (Selenium, BeautifulSoup, Scrapy) Experience with handling JavaScript-rendered sites Data cleaning & structuring Deliver a working script or API if needed Bu...
I'm seeking a seasoned Excel expert to develop a macro aimed at automating repetitive tasks in my spreadsheets. Key Responsibilities: - Create an efficient macro that streamlines routine operations in Excel. Ideal Skills and Experience: - Deep understanding of Microsoft Excel. - Proven track record of developing effective macros. - Excellent problem-solving skills. - Ability to simplify complex tasks into automated processes. The specific tasks to be automated haven't been defined yet, so flexibility and creativity in finding opportunities for automation will be highly valued.
I'm looking for a spreadsheet template that can efficiently track employee actions with customers, specifically focusing on sales outreach. This will help us monitor and improve our customer interaction strategies. Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in creating tracking templates - Understanding of sales processes Key Features of the Spreadsheet: - Sections to log, monitor and analyze employee's sales outreach activities - User-friendly design for ease of use - Ability to generate insights from the data Your expertise will help us streamline our sales tracking process and enhance our customer interaction efforts.
I'm a private contractor seeking help with my weekly payroll for truck drivers using Microsoft Excel. Key Tasks: - Calculating wages based on a percentage of the load pay - Generating pay stubs - Tracking deductions and benefits - Running year to date totals Pay Stubs should include: - Load pay percentage calculations - Year-to-date totals Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in payroll processing - Able to calculate percentages and track benefits accurately
I'm in need of a...Add and manage product listings in WooCommerce on a monthly basis - Adjust pricing in line with competitor strategies and product features - Optimize product descriptions with SEO-friendly content - Utilize Google Sheet for data management and price calculations Qualifications: - Proven experience with WordPress & WooCommerce - Exceptional SEO content writing skills for product descriptions - Excel proficiency for managing and analyzing pricing data - Strong analytical and research skills for competitor price tracking - Ability to work independently and meet deadlines Preferred: - Experience in e-commerce product management - Familiarity with market research tools If you have the required skills, experience and a keen interest in e-commerce, I look f...
I'm seeking a freelancer to help with a simple yet crucial spreadsheet project. The primary purpose of the spreadsheet is to check calculations. Key Responsibilities: - Design a spreadsheet capable of performing basic arithmetic calculations (addition, subtraction, etc.) - Make the spreadsheet user-friendly for manual data entry Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets, etc.) - Strong attention to detail - Excellent organizational skills Experience with basic arithmetic and creating easy-to-use spreadsheets is a must. Your role is pivotal in ensuring all calculations are checked accurately.
I'm in urgent need of a MySQL database expert to recover data from corrupted .frm and .ibd files. The issue at hand is that all tables within these files are impacted. I'm looking for someone with the following skills and experience: - Extensive knowledge of MySQL database structure and .frm and .ibd file functionality - Proven track record in data recovery from corrupted database files - Ability to recover all types of tables, including user information, transaction, and product tables - Quick turnaround time for urgent requests Time is of the essence, and I would appreciate a prompt response from qualified professionals. Thank you.
I'm seeking a seasoned PHP MySQL professional who can help with query optimization. My main goal is to enhance the speed of query processing, ensuring a quicker overall performance of my application. Ideal Skills: - Extensive experience with PHP MySQL - Proficient in query optimization techniques - Able to identify and rectify performance bottlenecks Expected Outcome: - Noticeably faster application performance
I need assistance converting a PDF file into Excel. The primary content involves tables and data entries. Key details: - The PDF contains several tables with varying structures. - The Excel file should only contain the raw data from the PDF, without any calculations or additional features. - Attention to detail is crucial to ensure data is transcribed accurately. The Excel Table needs to include: Part Number, Description Tiered Pricing with Quantity Breaks. Thants it. Attached is the PDF Ideal skills and experience for the job include: - Proficiency in data entry and Excel - Experience with PDF to Excel conversions - Ability to handle mixed table structures with precision
I am looking for a seasoned VBA expert to help automate repetitive tasks across Excel, Access, and Outlook. Key responsibilities: - Automate data entry and updates in Excel - Streamline report generation processes Ideal candidate will have: - Extensive experience with VBA programming - In-depth knowledge of Microsoft Office suite - Proven track record in automating tasks and improving efficiency. Please contact me if you have respective knowledge ayazkhan983 gmail Fresher also welcome to showcase the talent
I'm seeking assistance in creating a comprehensive product catalogue spreadsheet. This will involve listing various products and detailing their specifications. Key Responsibilities: - Organising the products in the spreadsheet alphabetically - Including specific details for each product: Product Name and SKU, Price and Quantity, Category and Description Ideal Skills: - Proficiency in Excel or similar spreadsheet software - Attention to detail - Ability to organise information systematically Experience in product listing or catalogue creation will be highly advantageous. Thank you!
We are looking for a Laravel backend developer and a Vue.js frontend developer to take over and complete our custom-built ...matching. • Implement features like wallet system, loyalty points, and membership levels. • Integrate payment gateways dynamically based on user location and currency (Tap, Ziina, Paymob, etc.). • Ensure secure and optimized database queries (MySQL, Redis). Dashboard Frontend (Vue.js 3) • Convert Figma designs into a functional Vue.js dashboard. • Build modules for order tracking, user management, and transaction history. • Ensure smooth RTL support for Arabic. • Optimize performance and improve UX. ✅ Laravel 10+ (PHP, API development, MySQL, Redis) ✅ Vue.js 3 for dashboard UI ✅ RESTful API integrations ✅ Expe...
I need an Excel VBA expert to help fix an issue with my workbook. The setup includes: • A data entry sheet where users can input information. • A second sheet that should automatically convert to a PDF. • The PDF must be dynamically saved using the value in cell C3 as its file name. • Only the data entry sheet should be visible to users. Currently, I'm facing Error 1004 and the generated PDF always ends up with the same file name. I need the macro updated or rewritten to resolve these issues. Deliverables: • A working VBA solution that converts the specified sheet to PDF with the correct, dynamic file name taken from cell C3. • Implementation of a button on the data entry sheet to trigger this process. • Appropriate error handling to resolv...
I'm seeking assistance for a data entry project. The task involves working with CSV files containing mixed data (both numeric and text). Key Details: - Primary source of data: Digital files, specifically CSV files - Nature of data: Mixed data comprising both numeric and text Ideal Skills: - Proficient in Excel and data handling - Attention to detail to ensure accurate data entry - Ability to comprehend and work with mixed data types in CSV files.
We are seeking an experienced freelancer to help us extract, organize, and analyze web data using Excel. The ideal candidate will have a proven track record in web scraping and be proficient in automating data collection processes. Below are the details of the project: Project Overview Objective: Extract relevant data from designated websites and import it into Excel spreadsheets. Data Sources: Multiple public websites (specific URLs provided upon hire). Output: Clean, organized, and structured Excel files with all required fields. Key Responsibilities Develop and implement web scraping solutions tailored for Excel. Automate data extraction using appropriate tools and programming languages (e.g., VBA, Python, or other relevant tools). Ensure data accuracy and i...
I'm seeking an experienced PowerPoint editor to assist with refining a 200-page presentation primarily composed of survey results graphs. This task is time-sensitive, with a deadline on March 7th at 12PM. Key tasks include: - Editing slides according to a specific style guide, which will be provided. - Adapting graphs from an accompanying Excel file into the PowerPoint format. Most slides will be provided by March 3rd, with a few additional ones on March 5th. The ideal candidate will: - Demonstrate exceptional PowerPoint skills. - Have a keen eye for detail to ensure clear and informative data representation. - Be able to incorporate specific branding elements, such as our company logo and colors, font styles and sizes, and consistent slide layouts. Please provide an esti...
I'm seeking the verified contact details (email addresses, phone numbers, LinkedIn profiles) of the CEOs and directors from 10 specific Brazilian private security companies I will provide. The information should be delivered in an Excel spreadsheet.
I require a Python script that can seamlessly transfer product details from an Excel sheet into my e-commerce site. The script should be able to handle the import of various product details such as: - Product names and descriptions - Prices and stock levels - Images and categories Ideal candidates for this project should have: - Extensive experience in Python programming - Familiarity with e-commerce platforms - Proficiency in handling data import from Excel - Understanding of product data structures
Project Description We are looking for a professional with experience in data analysis and LinkedIn research to conduct a detailed study of a list of target companies. The goal is to gain key insights into their organizational structure, leaders, employees, and collaborations with other companies. Project Objectives Identify and collect information...- List of Companies Analyzed: Identification and general data. - CEO and Director Profiles: Names, positions, experience and contact networks. - Template Information: Data on key employees, roles, background and activity on the platform. - Collaboration Map: Associated companies, type of relationship and contact information. - Final Report: Document with all the findings in a structured format (Excel, PDF or interactive dashboard if ...
I have an Excel spreadsheet with a single sheet containing my email list. I need assistance in merging this data with a MS Word email draft. The project involves: - remote access to my computer - Using mail merge to customize a MS Word email draft with contacts from an Excel file - Sending out personalized emails Ideal skills for this job include proficiency in Microsoft Word and Excel, experience with mail merge, and good attention to detail to ensure all emails are sent correctly.
I'm looking for a detail-oriented professional to assist with data entry into an Excel workbook. The task involves manually inputting contact details for a total of 1125 entries. Specifics: - Each entry will contain a contact's Name, Email, Company, and Job Title. - The data will be provided and needs to be entered accurately. Ideal skills and experience for this job include: - Proficiency in Excel - Attention to detail - Prior experience in data entry - Ability to work independently and follow instructions Please only apply if you can commit to completing the task in a timely manner. Thank you.
I'm in need of a proficient Excel expert to help me create a custom calculator based on my specific instructions. Key Features: - Basic arithmetic calculations - Custom formatting for results Data Input: - The calculator will need to handle both text and numbers. Ideal Skills: - Advanced Excel skills - Experience with creating custom calculators - Good understanding of basic arithmetic operations - Ability to implement custom formatting in Excel - Proficient in handling and processing text and numbers in Excel
...(both front-end and back-end). Security, scalability, and user experience best practices. Proposal Submission Requirements Please include the following in your proposal: A brief profile and relevant experience in similar projects. Proposed approach, technology stack, and development timeline. Estimated budget and pricing model. Details of previous relevant projects (if applicable). See attached excel for more details....
I'm looking for a skilled CodeIgniter developer to enhance my website's PayPal subscription integration. The task involves fetching transaction IDs after payment verifications for recurring subscriptions and storing them in a MySQL database. Key Requirements: - Proficient in CodeIgniter framework - Extensive experience with PayPal REST API - Strong skills in MySQL database management - Familiarity with handling recurring subscription transactions Please note, I only need the transaction ID after the payment has been verified, so experience with payment verification processes is essential.
I need an Excel specialist to help me with conditional formatting of future dates. Specifically, I want to highlight cells containing expiry dates within the next 60 days. Ideal Skills: - Proficiency in Excel - Experience with formula creation - Knowledge of conditional formatting Please note that this project requires a keen eye for detail and the ability to understand and implement specific formatting requests.
I'm having some urgent issues with my MySQL database in Laravel - Connection Errors: My database is having connection errors which may hinder the performance of my application. - Data Retrieval: There are instances where no data is returned when I attempt to query the database. I need a skilled MySQL database expert who can troubleshoot and resolve these issues quickly.
I need a freelancer who can help me extract contact information from a company search website that I subscribe to. I have detailed instructions on how to do this below. Please see the excel sheet to enter info into. There are 5 tabs for the different Saved Searches listed below in the instructions. I will need this done each month for the next couple months (probably). Website: ( I will provide credentials ) > Search Companies >Open a Saved Search Search saved searches in this order: 1. Houston Roofers 2. San Antonio Roofers 3. Dallas Roofers 4. Fort Worth Roofers 5. Austin Roofers Steps: On each company in list: 1. Click on the company (ONLY as long as the company name has the word “roof” in it). 2. >Find Contacts: Search for first 3 in this list, in or...
I need a comprehensive list of all Compass Realtors in Minnesota. The data should be compiled into an Excel spreadsheet, following the format provided in the attached document. Key Requirements: - The spreadsheet must include the name, office location, email address, phone number, and social media links for each realtor. - Social media links should be organized in separate cells for each platform. - Duplicates must be eliminated, as some realtors work in multiple offices. Ideal Skills and Experience: - Proficiency in Excel - Data entry experience - Attention to detail - Ability to eliminate duplicates effectively - Familiarity with social media platforms Please refer to the attachments for the source of the information and the required format.
I need a Shopify store for my poster frame manufacturing business. The store should mirror my marketplace listings and include around 100 products with variants. The products should be categorized...marketplace listings and include around 100 products with variants. The products should be categorized by material (Wood, Metal, Plastic), size, and color, with 'passe partout' as a separate category. Key Requirements: - Set up necessary plugins for optimal store functionality - Implement search by criteria feature - Use Excel tables I will provide for sizing / color variants Ideal Skills and Experience: - Shopify store setup and management - E-commerce product categorization - Excel for product size input - Plugin integration experience - knowledge of shopify seo and...
I'm seeking a professional with robust Excel and Power Automate skills. Key requirements: - Handling of complex financial data - Utilization of Excel macros for automated calculations - Performing intricate financial projections and forecasting The ideal freelancer for this project should have a strong background in finance and data analysis. Your expertise will enable me to streamline my data processing and projections, ultimately enhancing my financial decision-making.
I'm looking for an experienced Excel VBA developer to add additional VBA code to my macro-enabled Excel workbook. The goal is to improve the performance of existing macros/ VBA. Key Responsibilities: - Add new VBA code to enhance the workbook's functionality - Optimize existing macros for better performance Ideal Skills: - Proficient in Excel and VBA - Experience in developing and optimizing macros - Problem-solving skills to identify and fix performance issues
I'm looking for a freelancer who can create a tailored Excel spreadsheet for my small business. This should include charts to visually represent my budget data, as well as tracking for expenses, income, savings, and VAT. The budget data will need to be updated on a daily basis, so the spreadsheet should be designed with this frequency in mind. Ideal skills for this job include: - Advanced Excel proficiency - Experience with data visualization - Understanding of small business budgeting The freelancer should be able to present the data in a clear and accessible manner, making it easy for me to monitor my budget on a day-to-day basis.
I am facing a serious issue with my MariaDB. The database has been corrupted, and I do not have any recent backups available to restore from. I need an expert who can help recover the data. Ideal skills and experience for the job: - Extensive experience with MariaDB - Proficiency in data recovery techniques - Knowledge of backup restore process - Ability to work under pressure - Strong problem-solving skills
I am in need of an editable feasibility study template, compatible with Word and Excel, specifically tailored for the retail industry. This comprehensive template should encompass a wide range of sections, including but not limited to: - Market Analysis & Study - Financial Projections - Risk Assessment - Executive Summary - Financial Executive Summary - Geographical and Population Study - Spending & Inflation study - SWOT Analysis - Competitor Study - Project Timeline - Growth Rate - CAPEX Calculation and Explanation - Working Capital Calculation - Direct and Indirect Cost Calculations - Detailed Financial Study (P&L, B/S & Cashflow) as per IFRS with formulas and explanations on where data has to be entered - IRR, ROI, NPV and Payback period calculations - Sensitivi...
I'm seeking a skilled Sales & Operations Planner to enhance our manufacturing processes. Your expertise will be pivotal in: - Inventory Management: Optim... Your expertise will be pivotal in: - Inventory Management: Optimizing our stock levels to meet production and sales demands without overcommitting resources. - Production Scheduling: Coordinating our manufacturing timeline to maximize efficiency and minimize downtime. - Demand Forecasting: Anticipating market trends and consumer needs to guide our production efforts. Currently, we are using Excel/Spreadsheets for our planning processes. Proficiency in these tools is essential, and any experience with advanced planning software or ERP systems would be a plus. Your role will be crucial in supporting our growth and oper...
Excel dashboard development for performance
I'm seeking a comprehensive manual tracking system for ICU nurses. Key Requirements: - Design a user-friendly spreadsheet system for tracking nurses' shifts. - The system should be capable of recording when nurses are tripled, floated, or put on call. - Must be suitable for manual entry, with clear instructions for use. Ideal Skills: - Proficiency in Excel or similar spreadsheet software. - Experience in developing tracking systems. - Understanding of nursing shifts and ICU operations will be a plus.
I need a skilled develo...5 CSVs, going back approximately 15 years. Key Project Requirements: - The API should take a phone number as a request and return an array of all the month/year instances where this number was found. - The CSVs can be stored in a MySQL database. - The API should use an API Key Header for authentication, making it easy to provide access to clients. - The API should be able to return results in JSON format. - It should be designed for hosting on AWS or GCP, or both. Ideal Skills and Experience: - Proficiency in RESTful API development. - Strong knowledge of MySQL. - Experience with AWS and GCP. - Familiarity with API authentication methods. - Ability to format data in JSON. Please let me know if you have the necessary skills and experience to compl...
...administrators with a backend management interface that facilitates the management of performance, user, order, and other information. -* * Function * *: -Performance release and editing -User management and permission control -Order Management and Financial Statistics ###Technical requirements -* * Backend Framework * *: Node.js+ExpressJS/Django/Ruby on Rails/Spring Boot (choose one) database MySQL / PostgreSQL / MongoDB -* * Identity verification * *: JWT(JSON Web Tokens) -* * Payment system * *: Alipay, WeChat payment API integration -Front end interface: Following RESTful API standards -* * Server * *: Supports automated deployment ###Project requirements 1. * * Team experience * *: At least 2-3 years of backend development experience, able to independently complete tasks...
Extract 405 company data (name, website, address, email, telephone) from a public link available online . Then I need you to match those results with our existing excel file that contains 641 records, to see for duplicates.