For loop in excel formula jobs
I'm looking for a web-based script for managing a domain portfolio. The script should enable me to: - Track domain renewal dates - Add and remove domains in bulk - Move domains between different portfolios - Name portfolios (e.g., Generics, traffic, jamesdomains, etc.) - Import domain name revenue for cost comparison - Add domain name costs per extension (e.g., .com, .net, .xyz, etc.) to monitor yearly costs of each portfolio - Export files per portfolio, as well as a global export - Backup daily and send via email The script should use a simple Username & Password authentication method. The ideal freelancer for this project should have prior experience in domain management and web script development. Knowledge of domain valuation and ...
Description: We need a creative, high-quality logo for Vocabble, a vocabulary-building board game for kids (same as Scrabble game - image attached). The logo should reflect the educational and fun nature of the game, appealing to both children and their parents. Requirements: Game Name: The logo must prominently feature Vocabble. Slogan: Include a slogan like below: "Play, Learn, Master English" "Building Brighter Minds!" "Unlock the Power of Words!" "Play, Learn, Excel!" ..... or you can suggest one. Design Style: Clean, modern, and colorful, appealing to families. Avoid overly complex elements. Format: Deliver in vector format (illustrator/corel draw format )and high-resolution PNG/JPEG for print and digit...
I'm in need of a seasoned full stack developer specialized in Laravel and Vue for creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Implement user management features - Integrate data analytics and reporting functionalities - Ensure seamless integration with various data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external da...
...transform multiple Excel sheets into an interactive Power Apps platform for various users. The project also includes the creation of a comprehensive dashboard. Key Requirements: - Transforming Excel sheets into a user-friendly Power Apps - Developing a dashboard tracking performance metrics, operational statistics, and assisting with actions and decisions Dashboard Visualizations: - Bar charts and line graphs - Pie charts and donut charts - Tables and matrices - Conditional formatted tables Additional Considerations: - Power App must support multiple clients in an Active Directory format Ideal Skills and Experience: - Proficiency in Power BI and Power Apps - Experience in creating interactive dashboards - Knowledge of Active Directory confi...
I'm in need of a Python script that can extract numerical data from an Excel/CSV file. The ideal freelancer for this project should: - Have extensive experience with Python, particularly in data extraction. - Be proficient with handling Excel and CSV files. - Be able to write clean, efficient code. Please note, the data will be purely numerical. The script will need to be able to handle large datasets with ease.
Build quote template as below - 1. Polish quote template 2. Macro to create new tab 3. Macro to add new slot in existing quote 4. PDF generation with Inclusion and Exclusion List 5. Push quote info to CRM (if API exists)
I need to create 1 or 2 shortcut keys with macros in Excel for automating the formatting and reporting of my data. Ideal skills for this job: - Proficiency in Excel - Experience in creating and implementing macros - Ability to automate tasks efficiently
Hi, we need the attached PDF document to be translated from Italian to German, destination: Switzerland. We don't have the OCR for this, but I send you both the Word editable document of the first part, and the Excel that contains the following part (table). Please, use the Word and the Excel documents to create one only final document, like the PDF. I kindly ask you to add [unleserliche Unterschrift] wherever a signature appears. We don't have any specific deadline for that.
I'm in need of a detail-oriented, experienced professional to assist with various bookkeeping tasks. Key Responsibilities: - Recording transactions: Timely and accurately inputting all financial data - Reconciling accounts: Ensuring all accounts are balanced and discrepancies are addressed - Generating financial reports: Preparing clear and concise financial statements - Budgeting: Assisting in the preparation of budgets - Auditing: Conducting internal audits to ensure financial accuracy - Forecasting: Providing financial forecasts to aid in strategic planning - Invoicing: Preparing and sending out invoices - Project bookkeeping: Keeping track of finances for specific projects - Must know QuickBooks, NetSuite and Excel Ideal Candidates Should Have...
...Audience: 5,000 recipients. Data provided in Excel format (includes recipient email addresses and other necessary details). Email Content: Email 1: Includes a dynamic, clickable banner and text for sports bettors. (both provided by me. Naturally I want your input). Email 2: Sent three days after the first email, includes new text aimed at casino and slots players (provided by me). Sending Details: Emails should be sent from a professional-looking sender name such as: "Mike Spencer – Your V.I.P. Host". The sender email address must be configured to forward any replies directly to my email. Testing and Approval: A test email must be sent to my email for review and approval before the mass email is sent. Delivery Requirements: Emails must be deli...
I'm looking to create a mobile application and website specifically for my cloud kitchen. The primary purpose of this project is to develop a robust order management system. Key Features: - Real-time order tracking: Customers should be able to see the status of their order in real-time. - Order history: The app should keep track of past orders for customer convenience. - Push notifications for updates: Customers need to be kept in the loop with timely updates on their order status. Platform: - The mobile application should be designed exclusively for Android at this stage. Ideal Skills: - Proficiency in Android app development is crucial. - Experience in building eCommerce or order management systems is a plus. - Skills...
I need an existing Excel spreadsheet, which tracks employee data, to be transformed into a secure, user-friendly system. Key Requirements: - The system should provide view-only access to certain users, while others can edit designated sections. - It should automate calculations and formulas, as well as validate data entries to ensure accuracy. Ideal Skills: - Proficient in Excel with experience in spreadsheet security and access control. - Capable of creating automated systems within Excel. - Previous experience with HR-related spreadsheets is a plus.
In my company the arrival of the inventory to the warehouse is recorded manually in the attached excel file, in the tab "ARRIVO PRODOTTI". Each product is assigned a specific row. For each row the following columns are filled in: ARTICOLO (item code) DESCRIZIONE (item description) DATA PREVISTA (estimated availability date) I° REVISIONE DATA (first revised availability date) II° REVISIONE DATA (second revised availability date) III° REVISIONE DATA (third revised availability date) QTY (quantity) STATO (status) I would need a button for each row, next to the column STATO. The button, powered by a macro, when pushed should trigger an email to be sent to a list of internal recipients, with subject and text filled ...
Job Title: Power Query Expert - Tailor-Made PDF Bill Automation & Visualization Project: I need a skilled Power Query specialist to build a customized solution for automating the extraction and organization of electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs. Data Points (extracted from PDFs): Company Name Flat/Shop Number Account Number Disconnection Notices (flag/status) Electricity, Water Consumption Municipality Period Start Date, End Date Previous Balance, Total Amount Due Key Requirements & Deliverables: Automated Extractio...
I'm looking for a WordPress professional to assist with the installation and configuration of SEO and OTP plugins on my site. 1. I want to add data by one person or by team or upload contacts in bulk, I want to have the facility to get contacts approval? When a new listing is added in my website a. From link posting advertisement- , the advertiser should get whats app or mail or SMS for confirming or declining the advertisement. or b. Upload bulk listings available in excel file containing listings data from admin panel using plugin wpallimport plugin, all numbers should get whats app or mail or SMS for confirming or declining the advertisement. 2. Need to disable the mail id as mandatory field and would like to h...
I'm looking for an expert who can gather 5000 verified email IDs of researchers in the fields of agri-business, food, and retail from global sources, particularly focusing on academic journals, google scholar, and university directories. The email list should be delivered in an Excel spreadsheet. Key Requirements: - Expertise in data collection and verification - Familiarity with academic journals and university directories - Proficiency in creating and delivering data in Excel Ideal Skills and Experience: - Previous experience in similar data collection projects - Strong attention to detail for email verification - Excellent understanding of agri-business and related fields
I'm in need of professional Excel templates tailored for the construction industry. These will be specifically for quotations and invoices. Key Requirements: - The templates must include: - Client details and project scope - A breakdown of material and labor costs - Payment terms and due dates - The templates should be visually appealing and aligned with our brand: - Incorporating our company logo and branding colors - Special layout and design elements Ideal Skills and Experience: - Proficient in Microsoft Excel with a strong understanding of template design - Previous experience in the construction industry is a plus - Graphic design skills to ensure a professional and appealing layout - Attention to detail to ensure all ...
Excel Spreadsheet & Invoice Creation Assistance Excel Spreadsheet & Invoice Creation Assistance
Copywriting, pdf, data entry, excel, word
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I need assistance with managing hospital paperwork and invoicing using Microsoft Excel. Requirements: - Managing patient records and billing/invoices in Excel - Utilizing an existing template for patient records - Following a specific format for billing and invoices Ideal Skills: - Proficient in Microsoft Excel - Detail-oriented with ability to follow specific formats and templates - Experience with hospital paperwork and invoicing preferred.
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
We’re looking for a company or an individual who can develop a Saas product for event organisers. It would include a CRM for businesses and a customer portal. It will have 30 pages with different functions and all pages should be responsive. Pages will include but won’t be limited to: Business portal/CRM - Registration. - Settings (with business info.) - Login. - Events (where businesses can see all there events) - Create an event. - Edit event. - Create a menu. - Event summary and food order. - Individual food order. - Exports to excel - Food orders(sorted by course and table). - seating management Customer portal - Register. - Login. - Register and create an event. - Login and create an event. - Customer profile page. - Future events. - ...
...skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in 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 b...
I need a macro or script for my Google Sheets and Excel to automate data entry. Specifically, I want it to automatically pull bold information from a specified source into designated columns, as demonstrated in a provided video. Ideal Skills: - Proficient in creating macros in Excel and scripts in Google Sheets. - Strong understanding of data entry processes. - Able to follow visual instructions precisely. Please note, the exact source of the bold information will be provided in the video.
...to create a custom application for our logistics company. This app will automate the process of downloading quotations from shipping lines and airlines, displaying the data in a user-friendly format, and allowing for edits to create customer quotations. Key features of the web app include: - Advanced data processing: The app needs to handle complex tasks such as data extraction, transformation, formatting, and validation. - Manual upload function: This should allow users to upload rate templates from shipping lines via Excel or CSV files. - Format standardization: The app should assist in converting inconsistent rate formats from different shipping lines into a specific Excel template before upload. - Compatibility: The app needs to process an...
I'm looking for a data analyst who can help me assess the performance of various projects based on Excel spreadsheet data. Your primary focus will be determining actual run rates, based on project entries and forecast dates, as well as identifying whether projects are ahead or behind schedule. Additionally, I would like you to provide both a written report and visual aids (charts and graphs) as part of your deliverables. Ideally, you should have a strong background in data analysis and visualization, with a good understanding of Excel. Experience with project performance analysis would be a plus. Please note that there are no set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm looking for a freelancer to source and add leads to an excel sheet based on specific criteria. Key Responsibilities: - Use LinkedIn to source leads based on current Job Title and Company Name - Include Name, Job Title, Company Name, and Email in the Excel sheet - Ensure that the leads apply to the industry and job function Ideal Skills and Experience: - Proficient in using LinkedIn/ search for lead generation - Detail-oriented with strong data entry skills - Familiarity with different levels of job titles within companies - Excellent communication and organizational skills - Proven experience in lead sourcing would be a plus The leads should involve the highest-level manager for that particular company within Drug Supply-S...
I'm in need of a skilled Motion Graphics animator for an engaging product promotion reel to be shared on Meta. The animation should compellingly showcase my product and drive viewer interest, ideally leading to potential purchases. Key requirements: - Proficiency in creating Motion Graphics - 3D animate - Experience with product promotion animations - Ability to incorporate specified branding elements It will be for an Australian underwear brand - 10 sec loop I have some elements of my branding that need to be integrated into the animation, so attention to detail and adherence to brand consistency is crucial. Please provide examples of previous similar work you have completed.
I'm looking for a proficient freelancer who can convert a PDF containing text only into a neatly organized Excel file. The main purpose of this conversion is for data manipulation, so the data will need to be structured in a way that facilitates this. Ideal skills for this job include: - Proficiency in Excel - Experience with data manipulation - Attention to detail The data should be organized in a single sheet. Freelancers with experience in similar projects would be preferred.
I need assistance with extracting data from a PDF and placing it into an Excel format I will provide. Key Requirements: - Data extraction from the PDF should be done according to specific column headers in the provided Excel format. - Minor data cleaning is needed during the extraction process. Ideal Skills: - Experience in data scraping. - Proficient in Excel. - Attention to detail for data cleaning.
...consists of a few thousand line items in an Excel spreadsheet. Key Aspects of the Audit: - Return on Investment: Assess the profitability of my trades. - Accuracy of Trades: Determine if there were any errors or discrepancies in trade execution. - Transaction Costs: Evaluate the expenses incurred during trading and their impact on overall performance. Requirements: - The auditor must be an official auditing firm, ideally with relevant past experience. - Preference for firms based in the EU or US. - The auditor must be able to work with a specific report format that I will provide. Ideal Skills and Experience: - Extensive experience in conducting performance audits. - Proficiency in analyzing stock trading data. - Familiarity with audit...
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm looking for a skilled web developer to create a comprehensive and modern website/database platform for high school football teams, complete with individual player profiles. Key Features: - **Sleek Design**: The landing page should embody a modern and sleek design style. - **Player Profiles**: Develop profiles for individual players that include contact, academic, and athletic information. - **Media Uploads**: Implement functionality to upload unique pictures, videos, and documents for each player. - **User-friendly Filtering**: Enable robust filtering and sorting options for user convenience. - **Data Export**: Provide functionality to export data in CV or Excel format. - **Public and Secured Access**: Create a combinat...
...foundation for our business strategy, focusing on the following categories: Loans Credit Cards Insurance Taxation Stock Market and Trading Investments Wealth Management Since our website and platform are still in development, this project will operate from a blank slate perspective and guide our strategic direction. The emphasis is on industry-wide trends and competitor insights, rather than direct comparisons. Scope of Work The freelancer will: 1. Conduct Market Gap Analysis Identify major consumer pain points across each category. Highlight underserved demographics or regions (e.g., Tier-2 and Tier-3 cities, gig workers, students). Determine areas where existing platforms lack innovation, accessibility, or transparency. Provide actionable insights into potential value...
I'm looking for an expert in Excel or Win Calendar to help me organise multiple spreadsheets into a cohesive and easy to understand monthly calendar. The calendar needs to include: - Meetings and conferences - Promotional campaigns - Events - Program invitations - Media releases - Communication releases (both internal and external) Final deliverable: An Excel file that organizes all these activities by date per month and catergory. This calendar will be shared via Outlook and uploaded to our Teams folder. We have existing mulitple Excel spreadsheets that need to combined in one comprehensice Attention to detail and accuracy is extremely important. Ideal skills and experience for this job: - Proficiency in Excel, incl...
...looking for a freelancer to compile a comprehensive list of restaurants in specified areas that utilize GrubHub and DoorDash for food delivery. Key Requirements: - Gather information about each restaurant, including: - Name - Address - Phone Number - Email Address - Owner's Name (if available) - Delivery Platform - POS System - Whether they offer online ordering with delivery on their own website - The specific areas will be explained in detail with the chosen applicant. - Organize the information in a spreadsheet with separate columns for each piece of information. Ideal candidates should have experience in data collection, familiarity with food delivery platforms is a plus. Attention to detail is crucial as the a...
Please Sign Up or Login to see details.
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
I'm encountering 404 web page errors when attempting to email an Excel worksheet from a network share drive. This issue is hindering my ability to send important reports and needs to be resolved as soon as possible. Ideal Skills and Experience: - Proficiency in troubleshooting network issues - Expertise in Excel and email systems - Understanding of web server error codes - Experience with resolving 404 errors - Familiarity with network share drives error: Failed to load resource: the server responded with a status of 404 ()Understand this errorAI Failed to load resource: the server responded with a status of 404 ()Understand this errorAI Failed to load resource: the server responded with a status
We’re a thriving, high-end boudoir photography business that emphasizes body positivity and authenticity. We celebrate real bodies, believing self-confidence should be at the forefront of every client experience. We have a few special projects, specialized sessions, and an upcoming giveaway on the horizon. We’re looking for an organized, proactive professional to work directly with the owner and help manage the behind-the-scenes work. What We’re Looking For: Brand & Mission Alignment: You appreciate our focus on self-love, inclusivity, and real beauty. AI-Savvy: Hands-on experience using ChatGPT (or other AI tools) to optimize marketing, content creation, research, or brainstorming. Self-Starter Mentality: You’re someone who can take initiative, b...
...designs for virtual try-on, with the end goal of 3D printing the pieces in gold. This is for a one eye'd cat pendant. It could be just the head. Include appropriate loop for pendant chain attachment. Key Requirements: - Design for Virtual Try-On: The designs should be suitable for a virtual try-on platform, allowing users to experience the jewelry in a virtual setting before it is physically made. - 3D Print Ready: The final designs should be optimized for high-quality 3D printing, ensuring every detail is captured in the print. - Gold Design: As the jewelry will be printed in gold, the designs should reflect the luxurious nature of this material, incorporating elements that would enhance its appeal. - W...
...task involving two Excel files. The project involves copying data from the L Block excel schedule into the 2-week look ahead file. Key Responsibilities: - Accurately copy and paste information up until approximately 12/27/25. - Ensure that dates match in both documents. - Retrieve necessary vendor information from column F in the scheduler file. Important Notes: - Both files already contain the required dates, so no additional dates need to be added. - It is crucial to maintain the same formatting as in the L Block file; do not alter the format of the dates in the 2-week look ahead file. - Rows 6 to 18 in the 2-week look ahead file are hidden; do not unhide them during the copying process. Ideal Skills and Experience: - Proficiency ...
I am encountering a problem with my thermal printer not being detected by Odoo 17. This issue is hampering my operations and needs to be resolved promptly. You should be able to fix issues during live call/zoom. You also help with excel file import to Odoo for accounting. Ideal Skills: - Odoo 17 expertise - Thermal printer troubleshooting - System connectivity solutions Please reach out with proposal starting word Import, so I know you read it correctly and if you can help resolve this issue.
I need an Excel template to catalog my extensive stunt equipment inventory. The template should be able to accommodate different categories of equipment, track multiple details for each piece, and provide a summary page with totals for each category. Key Requirements: - Listing of equipment across approximately 100 categories, each with its own page. - Individual listing of items (e.g. 500 carabiners). - Summary page detailing total quantity and value of each type of equipment. Details to Track for Each Piece: - Quantity and value - Condition and location - Size - Inspection date - Description Ideal Skills and Experience: - Proficiency in Excel - Prior experience with inventory management templates - Strong attention to detail - Ability to crea...
I'm looking for an experienced Python programmer to develop a script that trains a Lora model focused on human faces using the SDXL framework. The training must prioritize accuracy and should be done without any graphical user interface (GUI). All parameters must be defined within the Python script. Key Requirements: - The script should handle a dataset consisting of 20 photos for each individual, along with multiple sets of individuals in a loop. - The script must handle the training of the Lora, saving the Lora model, and performing inference using the Lora before proceeding with the training for the next individual. - The script needs to load data per individual. - You need to have a PC with RTX 3090 or higher. Ideal Skills: - Proficiency in...
I'm looking for a professional Excel expert to create a custom PPM maintenance schedule spreadsheet for me. Key Features Required: - Custom frequency: Inspections will not follow a standard 6 or 12 month schedule, but will be tailored to specific needs. - Contractor details: All contractor names, contact details, and yearly or six-monthly costs must be included in the same sheet. - Inspection dates: The sheet should track the date of inspection and the next scheduled inspection. - Automatic scheduling: If I select a 365-day frequency, the spreadsheet should automatically schedule the next inspection one year from the first. - Conditional formatting: Inspections due in a month should be highlighted in amber, while overdue inspections turn red...
I'm seeking an Excel expert to create an intricate report for monitoring headcount targets across seven business leaders within our organization. The report should consist of three tabs: 1. Open/Approved Reqs 2. Filled Reqs 3. Pending Review Ideal Skills: - Proficient in advanced Excel functions - Experience in creating complex formulas or macros - Ability to integrate visual aids such as charts into the report The report will necessitate the incorporation of complex formulas or macros, so a freelancer with advanced Excel capabilities is a must. Additionally, the report should feature charts to visually represent the data, making it easier to digest and interpret. If you have a strong background in data analysis and visualization, an...
...expertise in Lead Generation, someone that uses Zoominfo and/or Salesgenie (Data Axle). Target Audience: Private Businesses within these counties of TX: Nueces, Cameron, Hidalgo, and Willacy counties. - Revenue between $500,000 and $1,000,000 - Private entity (Not publicly traded) - Construction, manufacturing operations industries. Data Requirements: - Owner Name and Title - Company Name - Valid E-mail address - URL if available - Location - Revenue - # of employees - Industry Timeline: Please share anticipated timeframe to complete this request. Proof of concept: Must provide valid information and confirm access to tools to retrieve data. Skills and Experience: - Proven experience in Lead Generation. - Access to data tools needed. - Capable of retrieving and f...
