Excel macros log web query jobs

I'm seeking a proficient Excel expert to design a spreadsheet for tracking and calculating salesman commissions. Key Features: - Data Tracking: The spreadsheet must track sales amounts and the dates of each sale. - Commission Calculation: The commission should be calculated as a flat rate per sale. - User-Friendly Design: The spreadsheet should be easy to navigate and use, with clear labels and instructions. Ideal Skills: - Advanced Excel Skills: Including but not limited to, knowledge of formulas, functions, and data organization techniques. - Experience with Commission Calculations: Familiarity with creating spreadsheets for tracking sales commissions is a plus. - Attention to Detail: The ability to create an accurate and reliable tracking tool.

I'm seeking an Excel expert to automate a variety of tasks. These include: - Data Entry: Streamlining the process of inputting information into Excel. - Data Analysis: Implementing functions or scripts to process and analyze the data automatically. - Reporting: Generating regular reports based on the analyzed data. The automation will need to interact with Google Sheets. It will have to both read from and write to the Sheets. The ideal freelancer for this project would be someone with a deep understanding of Excel, experience with Google Sheets, and a knack for data automation. Python or similar programming skills would be a plus.

I am looking for a freelancer to develop a well-structured, automated, and professionally designed Excel sheet for Portfolio, Program, and Project Management, aligned with PMI standards and requirements. 1. Excel Sheet Development The Excel file should be designed for comprehensive project tracking and management, incorporating the following: A. Portfolio, Program, and Project Structure • A structured Portfolio Management sheet to oversee multiple programs and projects. • A Program Management sheet to consolidate and track multiple related projects. • A Project Management sheet for individual project tracking, execution, and control. B. Core Project Management Features (Aligned with PMI Standards) • Project Overview Dashboard: Summary of por...

I need assistance with manual data input into an Excel spreadsheet and potentially creating a format or template for the data. Key Tasks: - Manual data entry into Excel - Potential assistance with creating a suitable format/template for the data Ideal Skills: - Proficient in Excel - Experience with data entry - Ability to create and set up Excel templates Please note that I'm not entirely sure what the final format will look like, so flexibility and creativity will be key.

I'm in need of a skilled Python developer to create a cost-effective Google search crawler for me. The crawler should: - Use specified dorks, such as site:*., to find site links. - Extract all hyperlinks from the search results, including those with and without query parameters. The extracted hyperlinks should be stored in a PostgreSQL database. I'm looking for a freelancer who can deliver a robust and efficient solution without relying on third-party services. Experience with web crawling, Python, and PostgreSQL is essential for this project.

I'm looking for an Excel Macro expert to create a macro for me that will automate reporting from local Excel files on my Mac. I need this to enhance efficiency and accuracy in my data handling.

More details: What specific functionalities do you need in the inventory management sheet? Track stock levels, Automate ordering, Generate usage reports How will the initial data be entered into the inventory sheet? Manually What type of items will be tracked in the inventory sheet? Finished goods, Cleaning supplies

I'm seeking a skilled PHP developer who can seamlessly publish real-time Excel data from my PC or OneDrive onto my WordPress website. This Excel file, which contains some external links, needs to be displayed in a customized table format. Key Requirements: - Expertise in PHP and WordPress - Proficient in handling Excel data and creating table formats - Capable of implementing real-time data updates - Experience with integrating external links into Excel Ideal Candidate: - A PHP developer with a strong background in WordPress and real-time data publishing - Able to customize Excel data into a table format - Quick and efficient in delivering high-quality work

I'm looking for an Excel sheet that can help me track my daily body vitals. The metrics I need to monitor are heart rate, blood pressure, and body temperature. I will be inputting the data manually, but I also want the sheet to be compatible with data from my smartwatch. Ideal Skills: - Excel expertise - Understanding of health metrics - Experience with data tracking sheets Key Features: - Manual data input fields - Compatibility with smartwatch data - User-friendly design

...`registrationForm1` to their custom dashboard 4. Concatenating multiple input values into a single collection field where necessary (for RoomService and MenyewaDanMengoperasikan members). 5. Assigning roles to members based on `registrationForm1` input and storing it in the `memberRoles` collection field. 6. Ensuring logged-in members are directed to their dashboard immediately when they visit or log in. 7. Handling validation rules: - registrationForm1`: Code will validate only visible fields (since Wix conditions are already in place). - Second input forms: No conditions except for Drivers; required fields will be validated via Velo code. 8. Redirecting members after booking confirmation: - Upon confirming their booking, each member will be directed to ...

I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.

Looking for a freelancer to assist with data entry and creation of documents in Excel. The ideal candidate should have experience with both numerical and textual data entry, and be proficient in Excel. The project involves creating and entering less than 50 documents, and we are open to suggestions on format and templates.

The project requires an expert in MySQL to assist with complex queries and joins. I will provide the specific details of the data and the requirements. we cando over screenshare i might also make into an php script but for now lets get the correct mysql queries setup

I am looking for a skilled SQL expert who can write complex queries for my office work. The ideal freelancer should have extensive experience with MySQL and the ability to deliver difficult queries quickly. **Main Requirements:** - Strong proficiency in SQL - Experience with complex query writing - Able to deliver results by 5-6 PM today Please be ready to demonstrate your expertise during our discussions.

I'm looking for a skilled business analyst who can write complex SQL queries for my MySQL database. Your primary role will be to analyze data for various business purposes. Ideal Skills: - Proficiency in SQL - Extensive experience with MySQL - Strong background in business analysis Main Objectives: - Utilize data for customer segmentation - Aid in sales forecasting - Assist in fraud detection Your ability to write difficult queries and translate data into actionable business insights will be crucial to the success of this project.

...implement CI/CD pipelines for automated deployments. Manage cloud infrastructure (AWS, GCP, Azure) using Terraform, Kubernetes. Ensure high availability, security, and performance of applications. Work with Docker, Kubernetes, Helm, Ansible, Jenkins, GitOps. Develop RESTful APIs, microservices, GraphQL. Write efficient, high-performance code with best practices. Optimize database performance, query tuning, caching (PostgreSQL, MySQL, Redis). Troubleshoot production issues, improve system reliability. Collaborate with teams for agile development, fast iterations. Skills & Requirements Python, Django, Flask, FastAPI, React, Node.js, TypeScript, REST, GraphQL, Microservices, Docker, Kubernetes,AWS, GCP, Azure, CI/CD, Jenkins, GitOps, Ansible, PostgreSQL, MySQL, NoSQL, W...

need someone to log in right now and communicate with landlord and re agents in cebu city with me right now send me vocaroo audio message explaining any experience and how good your english is

I am looking for a Wix developer to create a reward points system on my existing Wix website. The system should allow students to log in to personal accounts, view their reward points balance, and use these points to purchase physical items in an online store. Key Requirements: - Setting up a store on Wix where students can use their points to 'shop.' - Implementing a personal account system where each user has a unique profile and a reward points balance. - Developing an admin interface for me to add or deduct points from each user's account manually. - Integrating the points system with the store so users can redeem their balance for products. - Ensuring everything is functional, user-friendly, and secure. Important Note: The most critical aspect of this proje...

I need someone who can accurately and efficiently copy 100+ recipes from MyFitnessPal into the Kahunas app. Each recipe needs to includes calories and macros (Protein, Carbs, Fat and Fibre). The recipes must be entered as "SERVES 1" and you must check the entries prior to saving to ensure the app has not automatically changed the numbers. Requirements: - Transferring data from MyFitnessPal to Kahunas app - Accurate data entry for 100 recipes - Completion within 24 hours Ideal Skills: - Familiarity with MyFitnessPal essential - Familiarity with Kahunas app preferred - Excellent data entry skills - Ability to work under tight deadlines

Experienced App Developer Needed for Medical Transportation Service (iOS, Android, Web-Based Admin Panel) Description: I am looking for a highly skilled app development team or individual to create a medical transportation service app that functions similarly to Uber but is specifically designed for Medicaid-approved patient transport services. This app will have two components: 1. A mobile app for drivers (iOS & Android) to accept trips, navigate routes, and track earnings. 2. A web-based admin panel for dispatchers to schedule, monitor, and optimize trips. The app must integrate real-time GPS tracking, automated route optimization, and Medicaid billing compliance while ensuring a seamless and user-friendly experience for drivers and administrators. Hybrid Pay Mod...

I need assistance in arranging data related to gemstone manufacturing on a single spreadsheet. The ideal candidate should be proficient in Excel and experienced in data organization. Key requirements include: - Proficient in Excel - Ability to manipulate and analyze data - Experience relevant to gemstone or manufacturing processes Deliverables: A well-organized and clearly presented sheet containing all relevant data for gemstone manufacturing, ready for analysis.

...booking websites. The specific websites to target include: - Marriott - Booking - Agoda - - Ctrip - IHG - Hilton Ideal skills and experience for this project include: - Proficiency in Python, particularly in web scraping libraries such as BeautifulSoup or Scrapy, selenium. - Knowledge of data extraction techniques and tools. - Experience with manipulating and structuring data for easy interpretation and usage. Please note that the format for the extracted data has not been specified yet, so flexibility in your coding to allow for various output formats (CSV, JSON, Excel) would be beneficial. Additionally, while the primary focus is on hotel names and page links, potential to expand the data set to include hotel addresses, ratings, and room prices would be appreciat...

I need someone who can accurately and efficiently copy 100+ recipes from MyFitnessPal into the Kahunas app. Each recipe needs to includes calories and macros (Protein, Carbs, Fat and Fibre). The recipes must be entered as "SERVES 1" and you must check the entries prior to saving to ensure the app has not automatically changed the numbers. Requirements: - Transferring data from MyFitnessPal to Kahunas app - Accurate data entry for 100 recipes - Completion within 24 hours Ideal Skills: - Familiarity with MyFitnessPal essential - Familiarity with Kahunas app preferred - Excellent data entry skills - Ability to work under tight deadlines

...overview transcoding server, change ports for streaming, rtmp/hls/http etc), see if reverseproxy is installed, show reverseproxy ip adres, possible change main server ip adress, reinstall reverseproxy - nginx settings / possible restart nginx/ change streaming ports /rtmp ports/ etc / admin pass change - firewall block, maxmind api, geo block, country block, lock user to X country connect, user log activity (invalid creds, blocked logs, bruteforce attacks, block single ip, block subnet) - Overview blocked ips, Overview Whitelisted ip adresses/add/delete Stream Checkker, Connection Checker in C++ communicate realtime with frontend dashboard - means check, if user restreamer, check user max allowed logins (open connections at same time) - means (check user realtime, connectio...

Looking for assistance with Excel sheets and real estate tasks for my building and real estate projects. Let me know if you're interested!

We are currently seeking a skilled professional for a virtual data entry role. Below are the job requirements and expectations: Primary Responsibilities: • Enter data from PDF files into Excel spreadsheets. • Ensure accuracy and attention to detail. Job Requirements: • Proficiency in Excel. • Typing speed of at least 30 words per minute (to be verified via a typing test on ). • Ability to work virtually with high-speed wired internet (minimum 25 Mbps). • Access to a desktop computer in a professional setting. • Familiarity with remote access software such as AnyDesk or TeamViewer, as the work will be done on our computer. • Availability to work between 10:00–11:00 AM Vancouver time (Pacific Daylight Time). Additional Real ...

...Collaboration tools for event approvals and workflow management - Weather-based contingency tools for outdoor events - Employee-Specific Chatbot Features - Knowledge base integration for quick access to policies and guidelines - Searchable database for staff queries - Direct Communication Tools - Quick access to emergency contacts and direct supervisor call button - Lost & Found log and inventory tracking Revenue-Generating Features - Food & Catering Services - In-app ordering and event catering options - Event Space Reservations - Venue rentals with bundled services - Event Ticket Sales - Direct ticket sales and multi-event packages - Membership Subscriptions - Tiered membership levels with exclusive perks - Merc...

...looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using ...

Enhance an Excel file about real estate investment. I'll highlight entry values in green, correct and insert formulas when needed.

I'm looking for a custom Excel template to organize my extensive sports memorabilia collection. The collection includes various types of items, such as: - Autographed items - Trading cards - Game-used items - Pop figures - Jerseys - Balls - Movie memorabilia The template should be user-friendly, allowing for easy input and tracking of each item. Ideal candidates should have experience in creating digital templates, preferably for memorabilia or similar collections. Skills needed: - Advanced proficiency in spreadsheet software - Experience in template creation - Knowledge of sports memorabilia is a plus. Please submit your proposal if you have the required skills and experience. I am not looking to create a logo or websitr

I need an Excel dashboard created from our data that we currently track in Excel across multiple locations. The dashboard should display a variety of key metrics including: - Sales data - YOY Data - Membership Sales - Membership Conversions - Labor as a percentage of revenue - Birthday party revenue and YOY data for same week LY - Concessions Revenue and YOY data for same week LY The ideal freelancer should have: - Expert proficiency in Excel - Experience in creating dynamic dashboards - Ability to visualize data using bar charts and line graphs - Understanding of sales and revenue tracking The dashboard should be able to visualize data using bar charts and line graphs, as well as dynamic dashboard visuals. The dashboard will need to refresh data on a weekly basis. ...

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic ...

...OAuth 2.0 authentication for APIs. LGPD compliance. Proposed Architecture: Frontend: WhatsApp Business API (receives/processes messages). NLP Layer: Processes the query and extracts intent/parameters. Backend: Query external APIs (Google Ads, Meta Ads). Runs ML models (e.g.: ROI prediction). Generates structured responses. Data Lake: Stores historical data for continuous training. (Example: User → WhatsApp → NLP → Backend → External APIs → Response) Data Flow User Input: Message received via WhatsApp (e.g.: "What is the average CPC of Google Ads?"). NLP Processing: Identifies intent ("fetch CPC") and parameters ("Google Ads"). API Query: Backend searches for real-time data from integrated platforms. Analysis a...

Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.

I'm currently developing an iOS app that leverages the Screentime API and Family Controls. This app involves tracking usage, implementing parental controls, and setting up app restrictions. I'm seeking a seasoned Swift developer who can help troubleshoot coding issues and assist with the setup of specific code segments on a pay-per-query basis. Key Areas of Focus: - Usage tracking: I need guidance on how to implement this feature and help troubleshooting any issues that arise. - Parental controls: I require assistance with feature implementation and bug fixing. - App restrictions: I'm looking for an expert to help optimize performance and address any potential coding issues. Ideal Candidate: - You must be an expert in Swift, with extensive experience in Xcode and iO...

...setup, account management, and seamless customer service to facilitate smooth operations and guest bookings. Scope of Work ​ Mobile app setup Download and install the Airbnb App on a mobile device. Access property information Retrieve essential property information from the Notepad (.txt) file provided, and download the property images from the linked Google Drive folder. Platform registration Log in your Airbnb account. Use the “Airbnb your home” feature. Verifying your account (if required) Verify your account by signing in with Google or your phone number. Property listings creation Publish the property on Airbnb by following platform guidelines. On Airbnb, enable Approve all bookings to manage reservation approvals. Note that you are not allowed to accept or dec...

I'm experiencing a critical login issue on my Magento website. Users are unable to log in from the initial login screen. This problem has arisen without any recent changes to the website or server configuration. I need a developer who can liaise with both Magento and Knownhost to troubleshoot this problem. Ideal candidates should have: - Extensive experience with Magento and Knownhost - Proven track record in resolving login issues - Excellent communication skills for liaising with service providers - Ability to troubleshoot without any recent changes as a reference point.

...compatible with Quotex and Pocket Option. The bot will utilize technical indicators for trading signals and should encompass various essential features. Key Features: - Automated Trading: The bot should execute trades based on signals derived from technical indicators. - Risk Management: Incorporate robust risk management features to protect investments. - Trade History Logging: Maintain a comprehensive log of all trades for analysis and review. - Automatic Compound: The bot should automatically reinvest profits for compound growth. Ideal Skills and Experience: - Proficiency in API integration with Quotex and Pocket Option. - Extensive knowledge of binary options trading and technical indicators. - Experience in developing risk management features within trading bots. - Ability...

Scope of Project: Multi-Tenant NFC-Based Authentication System Project Overview We are seeking a developer to build a secure, multi-tenant NFC-based authentication system. This platform will allow businesses to encode NFC tags onto products, enabling end users to scan the tags and verify authenticity via a web-based interface. Each business (tenant) will have its own dashboard, branded verification page, and isolated data storage. Key Requirements 1. Multi-Tenant Functionality • Ability to register multiple businesses/organizations as tenants. • Each tenant has its own admin dashboard to manage NFC-authenticated items. • Data isolation: Tenants can only access their own records. • Role-based access control (e.g., Tenant Admin, Staff Users). • Custom...

...Scientific research labs • Medical and clinical labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • All data must be acc...

I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly

I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.

I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable

...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...

I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.

I'm looking for an Excel expert to help me create a comprehensive spreadsheet for an educational charity. Key Responsibilities: - The main purpose of the Excel Spreadsheet will be to compare various metrics of specific areas (London Boroughs) within the Region. - We need to compare a variety of metrics. The specific metrics will be populated later, but they could include population statistics, crime rates, and educational outcomes. - The level of detail in the comparison needs to cater for both high-level overviews and detailed analyses. Ideal Skills and Experience: - Proficiency in Excel is a must, with experience in data analysis and spreadsheet creation. - Understanding of educational metrics and social statistics would be a plus. - Ability to create user-f...

I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.

I'm looking for an Excel expert who can help me automate my spreadsheets to reduce manual data entry, specifically dealing with financial data. The ideal freelancer for this job should have extensive experience in Excel, particularly in spreadsheet automation. Skills in handling financial data and creating efficient solutions to streamline processes are a plus. Please include your relevant experience in your bid.

...Responsibilities: - Implement and integrate Zoho CRM, Zoho Books, and Zoho Projects into our operations via Zoho One. - Ensure the systems work seamlessly together to enhance efficiency and productivity. - Facilitate improved tracking and reporting of our financials through Zoho Books. - Optimize our project management processes through Zoho Projects. Data Migration: - I have existing data from excel on customers and past histrorical data that needs to be migrated from another accounting software to Zoho Books. This includes financial records, customer data, and project history. Ideal Skills: - Proven experience in Zoho One implementation and integration. - Proficiency in Zoho CRM, Zoho Books, and Zoho Projects. - Strong understanding of financial tracking and reporting. - Exp...

I'm looking for an experienced data analyst who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and formatted correctly in Excel. - Data analysis: Once the data is properly formatted, you'll be responsible for analyzing it in Excel. The ideal candidate will have: - Proficiency in Excel, including advanced functions and formulas - Strong skills in statistical analysis - Attention to detail to ensure data accuracy - Ability to meet deadlines If you're up for the challenge, I'd love to hear from you!