Web query excel macro jobs
...commercial directors, etc.). • Organized and capable of delivering detailed reports with the gathered information, including names, positions, companies, emails, and phone numbers when available. Tasks to Perform: • Identify relevant companies in Canada, Poland, and France interested in olives, pickles, or gourmet products. • Locate and verify key contacts within these companies. • Create a database in Excel or Google Sheets format with the collected information. Deliverables: • A database with at least 200 qualified contacts per country (total minimum of 600 contacts). • A report detailing the methodology used for prospecting. How We Will Evaluate Your Proposal: • A brief description of your experience in client prospecting. • Tools you us...
DONT USE AI TO WRITE COVER LETTER. I WILL NOT HIRE BOTS. Write briefly if you can work under budget and can start immediately. Enter Excel file with recent projects I have completed, well organized, and categorised for future use and portfolio reference. My profile: https://www.freelancer.in/u/Ansaf1
I'm in need of a web scraping expert who can help me extract text data from a specific website. The project involves scraping user data and compiling it into an Excel file. Key Requirements: - Proficient in web scraping techniques, with a focus on extracting text data. - Able to deliver the scraped data in Excel format. - Prior experience in scraping user data is a plus. Please note: The data to be scraped from the website is exclusively text, with a focus on user data.
I'm looking for an Excel macro that validates IPv4 addresses, subnets, ranges, and TCP/UDP ports. Requirements: - The macro should validate only IPv4 addresses. - Upon detecting an invalid IP address or port, the macro should both show a warning message and highlight the cell. - The macro needs to validate IP address, subnet, range, and port. Ideal Skills: - Extensive experience in Excel and its macro programming. - Understanding of IPv4 addressing. - Ability to implement user-friendly error handling. PAYMENT WILL BE MADE VIA 25$ GIFT CARD.
DONT USE AI TO WRITE COVER LETTER. I WILL NOT HIRE BOTS. Write briefly if you can work under budget and can start immediately. Enter Excel file with recent projects I have completed, well organized, and categorised for future use and portfolio reference. My profile: https://www.freelancer.in/u/Ansaf1
...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skills: - P...
I'm seeking an experienced Excel professional to customize a workbook for tracking sales leads. The workbook should be user-friendly, as leads will be entered manually. Key Requirements: - Create a comprehensive and intuitive workbook for logging sales leads. - Incorporate advanced Excel functions to enhance tracking and lead management. Skills & Experience: - Proficient in Microsoft Excel with a strong understanding of its advanced functions. - Experience in developing and customizing Excel workbooks for lead tracking. - Previous experience in sales or lead management is a plus. Please note, the project does not require automating follow-ups or importing leads from other systems. The focus is on creating a tailored workbook for manual data entry.
...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skills: -...
...a country's sustainability indicators. Key Requirements: - Proficiency in Tableau with experience in creating interactive dashboards. - Ability to visualize economic data in an understandable manner. Please note that while I have not specified the primary indicators to visualize, All of the data, how I want it to be visualized and structured on the page will be given. I will send the expert excel sheets, data and instructions on where each data set should be inserted and how different data sets might link to each other. All I need is a somebody who can do the visualization part of the project and provide with a clean looking and presentable interactive dashboard ideally on Tableau, but any other tool would do for the sake of a better result. The primary purpose of this ...
I'm looking for a freelancer who can assist me with data entry. The specifics of the data entry tasks are not yet defined. I may need help with manual data entry, data extraction, and data cleaning. Ideal candidates should have: - Experience with different types of data entry - Proficient in using Excel and other data management tools - Attention to detail for data cleaning tasks Please note, the source of the data and the final format are yet to be determined. Therefore, flexibility and willingness to adapt to changing requirements are essential.
I require assistance with manual data entry from my digital files, predominantly Excel and Word. The data is mixed, encompassing both text and numeric components. Ideal Skills and Experience: - Proficiency in Excel and Word - Excellent attention to detail - Prior experience in manual data entry - Ability to handle mixed data (text and numeric) - Strong organizational skills
I need my sales data cleaned and sorted. The data is currently stored in Excel/CSV files and contains duplicates, inconsistent formats, and missing values. Ideal skills and experience: - Proficiency in Excel and data management - Experience with data cleaning and sorting - Attention to detail to identify and rectify data issues - Ability to work with large datasets
...will extract a specific dataset, compile the results, and deliver them via email on a daily schedule. Key Responsibilities: • Design and develop a custom script or tool to connect with public APIs of multiple platforms (Meta, TikTok, Craigslist, etc.). • Implement webhooks or scheduled tasks to fetch data once daily. • Process and compile the collected data into a structured format (e.g., CSV, Excel, or PDF). • Automate email delivery of the dataset to a specified email address. • Provide clear documentation for the tool, including setup and maintenance instructions. • Ensure data accuracy, error handling, and logging for troubleshooting purposes. Requirements: • Proven experience working with RESTful APIs and webhooks. • Proficiency in s...
...Easy for Techs who work remotely to access • We can design excel template for the timesheets which can then easily be cut and pasted into Xero (our accounting package which also does our payroll). • The documents are live However, we are unsure as to whether Google Docs will allow us to do the following: • Have 1 x Google Doc with individual tabs which can be quarantined/separated so that Techs can only view their own (and not other Techs) time sheets/tabs? • Allow 2 x payroll staff working at separate locations to edit the time sheets (individual tabs?) submitted by Techs and also make comments that are visible to payroll staff only and not to Techs. Please advise if you think you can assist and set up something for us with an excel template that we...
I'm looking for a skilled freelancer to assist in compiling and organising a customer information database. This database will primarily be used for data analysis. The ideal layout for this database will be in a spreadsheet format. Key requirements: - Experience in data compilation and analysis - Proficiency in spreadsheet software (google sheets / excel) - Attention to detail - Ability to maintain data confidentiality Your role will involve: - Compiling customer information into a spreadsheet - Organising data for easy analysis - Ensuring data accuracy and confidentiality This project is ideal for someone with a keen eye for detail and a passion for data.
I'm looking for a meticulous and dedicated freelancer to assist with manual data transcription. Tasks Include: - Transcribing handwritten notes into Excel and text databases. - Transcribing printed documents with precision and care. Ideal Skills and Experience: - Proficiency in Excel and text databases. - Previous experience in manual data transcription. - Exceptional attention to detail and accuracy. - Strong work ethic and commitment to maintaining high-quality standards. If you're able to provide timely and accurate data management solutions, I look forward to your proposal.
...our business needs. Key Responsibilities: - Develop a Tableau dashboard from Excel file (refer Google drive link) that shows the correlation between different sales and revenue influencing factors. - Create relevant new columns as needed. - Ensure the dashboard is interactive and dynamic. Business Analysis: - Interpret the results to derive at least 3-5 compelling business stories that could benefit our operations. Please note, you can find the specific factors influencing sales and revenue at the following link: Ideal Skills: - Proficient in Tableau - Strong analytical skills - Excellent storytelling capabilities - Experience with Excel/CSV data sources - Ability to create dynamic and interactive dashboards. You
...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...
I'm seeking a seasoned data analyst with over 5 years of experience, particularly in SQL Server and Tableau. The task involves joining two tables using an Inner Join, wit...Inner Join, with a focus on displaying how many employees each supervisor has, as well as the supervisor's supervisor. Key requirements: - Proficiency in SQL Server and Tableau - Over 5 years of relevant experience - Ability to clean and prepare CSV data for analysis The initial data source is CSV files. Prior to joining the tables, some data transformation and cleaning will be necessary using Excel. While the specific visualization for the supervisors and their employees has yet to be determined, I am open to suggestions based on your expertise. Please include examples of your previous work with ...
...convert an Excel CSV file into an XML file based on a given XSD schema. The primary use of the generated XML file will be for data interchange. Key details: - The source of the CSV file is exported from a system, not manually created. - The XSD schema provided includes strict data validation rules, so attention to detail and adherence to these rules is crucial. - The XML needs to be created to facilitate smooth and accurate data interchange. Ideal skills for this job: - Proficiency in XML and XSD - Strong experience in data conversion - Excellent attention to detail and adherence to strict rules. Deliverables: - Define the fields I will require in the CSV file (based on the XSD schema information) - I will then deliver a CSV file with the required fields and data - deliver a ...
...seeking assistance to update an Excel sheet with shift details based on my handwritten notes. The task involves searching for the employee code in the Excel sheet as mentioned in the handwritten notes and updating the corresponding shift (A/B/C) for the specified date. If an employee worked multiple shifts on the same date, a new column should be added to record the additional shift. If the employee code from the notes is not found in the Excel sheet, a new row must be created to include the employee code, name, and the shift details for the specified date. Key details: - The handwritten notes are in photographs - The employee codes and names are consistent between the notes and the Excel sheet - The dates are formatted as DD/MM/YYYY in both the notes and th...
Our business currently uses the following applications: 1) Microsoft 365 (Outlook, Teams, Word, Excel, Power Automate, etc.) 2) Egnyte Cloud Server 3) 4) ChatGPT for Teams 5) Zapier Using Power Automate and/or Zapier, we want to create various cloud flows that directly integrate our different applications with ChatGPT. For example, when an e-mail is received to a shared mailbox, have ChatGPT analyze the e-mail and then automatically perform the following actions based on ChatGPT's analysis: 1) Move the e-mail to the appropriate Outlook folder 2) If there are attachments, then save each attachment to the appropriate subfolder located in Egnyte, using our file naming protocol 3) Add all relevant tasks and/or events to 4) Sync the MyCase events with Outlook Calendar
I need assistance with entering mixed data (both text and numerical) into Excel. This data will need to be input manually, so attention to detail and accuracy are crucial. If you have experience with data entry and are proficient with Excel, I'd love to hear from you.
...Business Name Owner’s Full Name Address Phone Number Email Address Price Level (Average Ticket) Business Category Reviews and Ratings (optional) Workflow Stages: User Inputs: Use a Google Form to collect search parameters (category, zip code, radius). Data Collection: Query APIs and scrape directories for business details. Data Enrichment: Validate and fill missing fields using Google Gemini AI. Data Storage: Use Google Sheets and BigQuery to organize the data. Sales Query System: Build a Gemini AI-powered natural language query tool for accessing leads....
I'm in need of an Excel expert to create a detailed spreadsheet for auditing my payslips. The spreadsheet should focus on: - Comparing hours worked versus money paid under incorrect penalty rates (as per pay award) - Identifying discrepancies against the amount paid versus the hourly rate with the correct penalty rate applied (As per pay award) - Tracking standard hours worked and the corresponding rate - Provide a total for the entire amount underpaid due to the incorrect penalty rates being applied In terms of functionalities, the spreadsheet should include: - Automated alerts for any incorrect payments - Colour coding with key Ideal skills for this job include advanced proficiency in Excel, experience in payroll auditing, and a strong understanding of penalty rat...
I need assistance with data entry from digital files into an Excel spreadsheet. The data is purely text-based and is sourced from digital files. The ideal freelancer for this project should have: - Excellent attention to detail to ensure accurate data entry - Proficiency in Excel to handle the data effectively - Experience with data entry from digital files to maintain confidentiality and data integrity.
I need an experienced developer to convert an Excel workbook, used for financial modeling in the renewable energy sector, into a web-based SaaS tool. The tool should have: - A framework for user maintenance and fees - A form-based graphical user interface (GUI) - Capabilities for new and modified projects - Tabular output - AI 'coaching' The tool is intended for two user roles: Admin and Basic User. I have started using AWS and Python for this project, but it's proving too challenging. I'm looking for a professional with: - Strong experience in web-based SaaS development - Understanding of financial modeling - Familiarity with the renewable energy industry - Proficiency in AWS and Python Please refer to my site for context.
My Selenium-based Excel tool is giving an error message upon starting it, asking to retry. I am looking for someone who can fix this for me. Runtime error 91 object varialbe or with block variable not set. I would also like this person to be the one to make future updates to the tool. - Error Message: The user did not specify what the error message is, as they skipped the first question. Therefore, the freelancer would need to investigate the error upon accessing the tool. - Selenium Version: The user is not sure which version of Selenium they are using. - Browser: The tool is configured to work with Chrome. Ideal skills for the job include: - Proficiency in Python and Selenium - Experience with Excel automation - Strong problem-solving skills - Familiarity with Chrome an...
I need help with data entry from various online databases. The data is a mix of text and numeric, and should be compiled into an Excel spreadsheet. Ideal Skills: - Proficient in Excel - Attention to detail - Experience with data entry - Ability to work with both text and numeric data - Familiarity with online databases
I'm seeking an Excel whiz to assist with moving and reorganizing data on a spreadsheet. Key Responsibilities: - Copying and pasting data from one spreadsheet to another - Reorganizing data according to specific categories or columns, with a focus on financial data Ideal Skills: - Proficiency in Excel - Strong data entry and organizational skills - Experience working with financial data
I'm in need of a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to handle: - Mixed data: The spreadsheets will contain both numeric and text data. The bot should notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should be able to trigger the calculations whenever needed. Ideal skills for the job include: - Proficiency in Excel and understanding of spreadsheet functions. - Experience in creating automation bots for Excel. - Programming skills, preferably in Python or VBA.
Hiring Work-Nix Solutions to add reporting options to existing system.
I'm seeking an Excel expert who can create a comprehensive spreadsheet for tracking employee utilization and project projections for 2025. This spreadsheet needs to accommodate various employee details and provide quarterly projections. Key Requirements: - Include specific employee details: Name and ID, Department and Role, Experience Level - Track utilization on an individual employee basis - Input employee rates and hours on projects - Incorporate fringe benefits and PTO - Provide functionality for quarterly projections Ideal Skills and Experience: - Proficient in Excel with advanced spreadsheet skills - Experience in creating utilization and projection spreadsheets - Strong understanding of employee management metrics - Ability to deliver a clear, user-friendly spre...
My Selenium-based Excel tool is giving an error message upon starting it, asking to retry. I am looking for someone who can fix this for me. Runtime error 91 object varialbe or with block variable not set. I would also like this person to be the one to make future updates to the tool. - Error Message: The user did not specify what the error message is, as they skipped the first question. Therefore, the freelancer would need to investigate the error upon accessing the tool. - Selenium Version: The user is not sure which version of Selenium they are using. - Browser: The tool is configured to work with Chrome. Ideal skills for the job include: - Proficiency in Python and Selenium - Experience with Excel automation - Strong problem-solving skills - Familiarity with Chrome an...
Executive Assistant Role Flexible schedule Need 2-3 days a week during pacific time to work on live task - from 10am till 1 pm PT Time Other tasks can be worked at your own time efficiently Required: Someone who can talk on the phone confidently and clearly Efficient Organized Honest Able to work on task with a quick turnaround High attention to detail an...independently with minimal supervision. Strong communication and interpersonal skills; making calls, getting quotes, making appointments STRONG follow up skills Job detail: Executive Assistant Varies from talking to vendors to researching Calling for quotes Coordinating with other parties complete tasks given in timely manner Paying for material cost Organize the expenses for materials on excel Organize to do l...
I'm having a problem with my Laravel application where the system is not saving certain order details during the create process. This issue is hampering the functionality of the application, and I need a professional who can debug the create functionality in the application and rectify the problem. Ideal Skills and Experience: - Extensive experience with Laravel framework - Proven track record in debugging and fixing Laravel applications - Proficient in working with order records and e-commerce systems - Strong problem-solving skills - Ability to work under tight deadlines
...interface that allows a user to upload a PDF file. Key Features: - The PDF file uploaded by the user should be marked as private within the DrapCode environment. - Once a user uploads a file, upon clicking 'submit' or 'next', the platform will trigger an API call to NodeJS. This call will send the uploaded file to GPT along with a query. The response from GPT will then be stored in a separate field within the same collection. For this POC, we can keep the API query simple. For instance, we could ask GPT to return the number of pages in the PDF. Ideal Skills and Experience: - Proficiency in working with the DrapCode platform. - Extensive experience in NodeJS. - Familiarity with API integration. - Prior work with GPT or similar AI models is a plus. ...
need multi sheets that have a list of materials per phase( lighting, branch power, fire alarm, risers ,telecom, site) into one master material list tat can be added to if phase list changes.
I need assistance with fixing a nested IF(OR) function in Microsoft Excel. My current formula works for applying two IF(OR) conditions, but I am encountering an error when trying to add a third condition. - The formula is designed to check if a variable matches one of a set of names, returning one value, and if it matches another set of names, returning a different value. - The third condition involves matching the variable against specific text or names. - I have the specific names for the third condition ready to provide. I believe the issue is a syntax error, and with your expertise, it should be a quick fix. Your proficiency in Excel and experience with complex formulas will be key to resolving this issue swiftly. Here is the part that works: IF(OR(M2="CHINA&quo...
I need a skilled developer to create a WebADI solution for uploading quality collection records from an Excel spreadsheet into Oracle EBS tables. This will specifically involve inspection results. Ideal skills and experience: - Proficient in Oracle EBS and WebADI - Experienced in handling Excel spreadsheets - Familiar with quality control data - Able to create efficient data upload solutions - Experience in developing and using APIs for data integration
...page , checkout page., thank you page, ( some mechanism for admin to see orders and assign delivery partner against delivery .) 1 .While placing the orders , we have some constraints like delivery distance, order value and timings Admin should be able to change them accordingly, ie these parameters should be changeable 2. Data should be logged into some buckets or dbms such that if we want to query or make dashboards we should be able to do easily 3. Manually we will monitor the orders placed and finally we only assign the delivery partner details and that should be displayed to customers no need for delivery tracking feature Key Features: - Primarily focuses on seamless order placement - Supports both user accounts and guest checkout options Payment System: - Incorporate Cr...
I need assistance with data entry from my handwritten notes into an Excel spreadsheet. The task involves transcribing text data from these notes into the spreadsheet. Ideal Skills: - Proficient in Excel - Excellent typing skills - Attention to detail - Experience with data entry from handwritten notes Please ensure to maintain the confidentiality of the content of the notes.
I'm looking for a professional who can create an engaging and comprehensive sales dashboard in Excel (or Power BI). The dashboard should feature: - Key Metrics: Total Sales, Sales by Region, Monthly Growth Rate, Sales by SKU, Conversion Rate, Average Deal Size, Sales Cycle Length, Sales by Channel Partner, Sales Forecast Accuracy, and AR (Cash Billed/Collected). - Features: Interactive charts, Automated updates, and an aesthetically pleasing design. Ideal candidates should have extensive experience with Excel and/or Power BI, and a good understanding of sales metrics. Proficiency in creating interactive, automated dashboards is crucial. A keen eye for design and the ability to present data in an engaging way is a must.
I need an experienced Excel professional to make some adjustments to my existing budget proforma. Key Tasks: - Update existing formulas to incorporate new data - Create complex formulas for advanced analysis - Add new sections for revenue projections, expense breakdown, and cash flow analysis Ideal Skills and Experience: - Proficient in Excel with advanced formula creation skills - Experience in budget planning and financial analysis - Able to work with and incorporate new data into existing frameworks
I need two of my financial spreadsheets re-created in an editable Excel format. Key Requirements: - Both formulas and text need to be editable. - The recreated spreadsheets should visually match the originals. - No charts or graphs are included, which simplifies the project. Ideal Skills: - Proficiency in Excel is a must. - Attention to detail is crucial to ensure the recreated spreadsheets match the originals visually. - Experience with financial spreadsheets will be a plus.
I'm see...conversation flow to make it more engaging and intuitive for users - add libraries to support conversation flow - create an external area where to collect the unknown information so that we can train the bot how to answer - create a form based input to add new information to the db The primary objective of these enhancements is to enable the bot to collect more detailed user information. To query the db Ideal Skills & Experience: - Proficient in AWS Lex and its features. - Experience with integrating bots with external APIs. - Strong skills in developing and refining conversation flows. - Prior experience in creating bots that gather user data is a plus. This project is perfect for someone who is passionate about improving user interaction through advance...
I'm seeking a financial analyst or Excel expert who can develop a comprehensive Excel-based model. The model should project profit and loss and balance sheet accounts, with the ability to link to ratio analysis. The model should utilize my historical financial statements, which include: - Income Statements - Balance Sheets - Cash Flow Statements These statements cover a time period of 5 years or more. Ideal candidates for this project should have extensive experience in financial modeling, particularly with Excel, and a strong background in finance or accounting. Excellent attention to detail is crucial, as is the ability to present complex financial data in a clear and understandable way. I have an excel model for financial analysis and ratios, so ideall...
...comparable open-source LLM) with a retrieval system, or a fine-tuned local model—whichever is most appropriate for ensuring reliable and accurate answers from the PDFs. Implement retrieval-augmented generation (RAG) or a similar approach (vector embeddings + a search database) to query the documents effectively. The AI’s responses must be sourced only from the pharma guidelines provided—no “hallucinated” answers outside of that scope. Web Integration Embed the chatbot into my existing website (or create a simple standalone web interface if needed). Chat-like interface where users can type queries and receive answers. Options for branding and basic styling to align with the rest of the site. Must be user-friendly and responsive. Post h...
