Spreadsheets Projects

Excel spreadsheet entry and other minor admin tasks

This is an opportunity for data entry and administrative support tasks on a contract basis. The primary responsibility will be populating a property analysis Excel spreadsheet with numerical details for several listings. Minor tasks may also include document updating such as legal wills, resumes, or similar typing work. While the initial workload is expected to be light, consisting of a few hours per week, there is potential for additional responsibilities and greater time commitment moving forward depending on client satisfaction and collaboration. The ideal candidate will have intermediate Excel skills, strong attention to detail, and the ability to work independently with minimal supervision on routine office support duties. Communication will be virtual and work can be completed remotely on a flexible schedule.

BetAngel - Excel Spreadsheet Required

I require a spreadsheet that halts betting when a specified profit threshold is reached or ceases betting after, for instance, achieving five consecutive wins. All targets would need to be user defined figures.

Global Export Sales Expansion Excel Spreadsheet

Hello there, pI am seeking an experienced Excel and data modelling expert to create a comprehensive global export sales template for our premium spirits brand. This project is crucial to our international expansion strategy and requires expertise in advanced Excel formulas, market-specific cost analysis, and a deep understanding of COGS (Cost of Goods Sold) and pricing structures across multiple territories. Key Deliverables: 1. Global Template Framework: • A functional and dynamic Excel template tailored for global export sales, including editable fields and automated calculations. • Consolidated summary tab providing a dynamic overview of all markets. 2. Market-Specific Tabs: • Include dedicated tabs for Australia, China (Hong Kong and Beijing), the US, and South America. • Market research data integrated into the model to calculate COGS, duties, shipping costs, and RRP (Recommended Retail Price) per SKU. 3. Product SKU Calculations: • Accurately calculate excise and duties for spirits with 40% ABV (applying Australian regulations as an example). • Incorporate formulas to reflect costs for London Dry Gin, Pink Gin, Barrel-Aged Gin, Botanical Rum, Aged Rum, and Vodka. 4. Automated Features: • Dynamic fields and formulas for profit margins and other key metrics. • Editable fields for local tax rates, shipping, and market-specific costs. Step-by-Step Guide: Global Expansion Pricing Spreadsheet 1. Structure of the Spreadsheet The spreadsheet includes: • Tabs for each market: Australia, China, US, South America. • A Global Summary Tab: Consolidated view of costs, margins, and profitability across markets. 2. Columns in Each Market Tab Each market tab includes the following columns: 1. SKU: Product name (e.g., London Dry Gin, Pink Gin, etc.). 2. Base COGS (GBP): Fixed production costs in GBP. 3. Shipping (Local Currency): Editable field for shipping costs in the market’s currency. 4. Freight (Local Currency): Editable field for freight costs in the market’s currency. 5. Duty (Local Currency, per bottle): Editable field for excise or duty costs, based on the market’s regulations. 6. Total COGS (GBP): • Formula: = [Base COGS] + ([Shipping] × Exchange Rate) + ([Freight] × Exchange Rate) + ([Duty] × Exchange Rate) 7. UK RRP (GBP): Fixed recommended retail price in GBP. 8. Adjusted RRP (Local Currency): Editable field for suggested RRP in the market. 9. Margin (%): • Formula: = ((Adjusted RRP - Total COGS) / Adjusted RRP) × 100 10. Profit (100 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 100 11. Profit (1000 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 1000 3. Market-Specific Adjustments 1. Australia: • Excise duty per bottle based on 40% ABV (current rate: AUD 28.52, converted to GBP). • Exchange rate: 1 AUD = 0.54 GBP. 2. China (Hong Kong & Beijing): • Unique excise and duty rates for each region, editable fields. • Exchange rate: 1 CNY = 0.11 GBP. 3. US: • Include local taxes and tariffs. • Exchange rate: 1 USD = 0.74 GBP. 4. South America: • Account for import tariffs and duties (e.g., Brazil-specific rates). • Exchange rate: 1 BRL = 0.18 GBP. 4. Global Summary Tab 1. Pulls data dynamically from all market tabs: • Total COGS by SKU. • Average margins across markets. • Consolidated profit projections for 100 and 1,000 cases. 2. Formulas reference each market tab using =SUM(Australia!Cell, China!Cell, US!Cell, SouthAmerica!Cell). 5. Editable Fields • Ensure all shipping, freight, and duty costs are editable for flexibility. • Adjust exchange rates dynamically for real-time updates. 6. Tools for Collaboration • Conditional Formatting: • Highlight margins below 30% in red for easy visibility. • Data Validation: • Add dropdown menus for currency selection or pre-set SKUs. Candidate Requirements: • Proven expertise in creating complex Excel templates. • Strong understanding of international trade costs and pricing strategies. • Ability to incorporate multiple data points into clear and concise spreadsheets. • Experience working in FMCG, particularly in spirits or beverages, is a plus. If you are passionate about crafting game-changing tools and have the expertise to deliver on this high-stakes project, I’d love to hear from you! Please include examples of similar work or projects when applying. Looking forward to your proposals!

I want to mail merge a PDF form to many people at the same time

I have a PDF form that I want to mail merge out to various people at the same time. I also have a sample data spreadsheet with the data on that I need mail merging into the document, and then the PDF form being emailed out to each person. The idea was to convert the PDF to word, then from word mail merge this out (so each person got a PDF with their own details on), each month the data will change, so I need someone to set this up and I can do mail merge each month going forward, the same data spreadsheet details which sections of the form I want to mail merge information into. I have attached the PDF and also a sample spreadsheet - I tried converting to word and doing a mail merge from there, but I was struggling to get the information I needed into the relevant boxes Please have a look at the form and see if this can be done before bidding as it isn't a quick 5 minute job to do this! Thanks!

A4 FLYER (AMENDABLE) AND SMALL EXCEL SPREADSHEET TIDY UP

I require the design of a professional looking A4 flyer that allows for easy editing of logos and details before saving as a PDF. The initial flyer design has already been created, however it needs refinement and formatting to allow for flexible updates. In addition, an Excel checklist needs organization and styling to appear polished. For the flyer component, the ideal file format would be a PowerPoint or Word document to permit adjustment of branding elements and specifics prior to finalizing the PDF version. Clean and customizable layouts are essential. Regarding the spreadsheet, the current checklist lacks a coherent structure and formatting. It necessitates rearrangement and standardization of cells, rows, columns as well as consistent styling like font, alignment, borders to advance its professional look and usability. Both projects involve creatively enhancing provided initial drafts to build out polished and user-friendly end products. The flyer requires a dynamic template while the spreadsheet needs thorough organizing and beautifying. Strong attention to detail and design-minded solutions will be important to effectively meet these dual presentation and organization objectives. Collaboration is welcomed to clarify any aspect of the brief. Concise, high quality work delivered within the agreed upon timeframe will be appreciated. Please provide relevant experience and examples of similar projects in your response if interested. I look forward to reviewing proposals from qualified designers.

Need someone to send emails to book a client on podcasts

You will take a spreadsheet of leads, find email addresses and send pre-written emails. You will have to slightly customize each email. We are pitching a client to be on podcasts about health and business.

opportunity

Excel Lead tracking Managment

Hello, I am looking for a Excel spreadsheet that will track incoming leads, allocate the lead to a sales person on a seperate google sheets/shares spreadsheet, for them to update with status of lead. All controlled by central spreadsheet 1 Sheet - Lead Entry, Name, Address, Tel, e-mail 2nd Sheet, central spreadsheet for all leads - Data from above with the date entered. Plus a drop down of sales person, when drop down activated, it is then auto entered to the spreadsheet of the sales person, Lead status, (which can be updated from Sales persons Spreadshet when lead is actioned and date updated and a 2 notes column (one for notes on main spreadsheet only, another for notes on Salespersons spreadsheet Sheet 3-12 - 9 Spreadsheets for the sales person with, Date of lead, Name, Phone and E-mail, all not editable on this spreadsheet. The lead status (selected from a drop down) and Notes Final sheet, a reporting sheet, Date Range selection Total leads, Lead per status, % of leads in the lead stats, lead per salesperson, etc Want to start straight away Thanks

Custom excel spreadsheets linked to Sage 50 accounts package

Need someone that has experience compiling spreadsheets using queries and connections to Sage 50 accounts.

Analyze Excell Spreadsheet Dataset - Answer only 7 questions

You will look over the data set and answer all the questions I've attached. You can use chat GPT to verify your answers, but they must be accurate.

Looking for an EA on a Ad-hoc Basis

Hello! I am looking for someone that can help me on very much an Ad-hoc basis do a range of various tasks from updating notes on to our CRM, drafting emails, Researching information, creating spreadsheets, and a range of other things, however wouldn't be able to advise a set amount of time each week. some days it could be a lot of work needed at short notice, or maybe just 1 task done very quickly, then sometimes a research project which can be done with a longer deadline. however I couldnt commit to a retainer or anything like that as some weeks I would have no work for you. I am a young business owner, and have a lot on my plate, so need admin support but as I say, sometimes you could be busy, other times not much work at all!

API Automations

We use - Pipedrive as our CRM The following feed into it - Quotient - Magento - Xero - Klaviyo Task 1 - Make the most of API - for example Zapier to move as much as we can into the CRM Task 2 - Automate Business Activity into Monthly Reports See spreadsheet attached.

opportunity

Adwords account issues

An AdWords consultant is needed to optimize two Google Ads accounts across two websites. One account promotes cocktails and stag events in the UK and has seen declining impressions and conversions over the past few months. The other account based in Australia recently suffered from restricted impressions that need resolution. The consultant will review monthly performance reports, ad campaigns, and landing pages to identify issues limiting visibility and recommend improved strategies. They will submit a proposal outlining fixes for restrictions, underperforming ads and campaigns, and ways to boost future clicks and conversions. Access to the advertising spreadsheets and website will be provided upon project hiring through the freelancing platform.

opportunitypre-funded

Find Two Reporting Solutions in Xero

Hello, I am looking for a solution to two apparent reporting limitations in Xero. We issue clients a single invoice each year which they have the option to pay in 12 monthly instalments. We don’t currently use a direct debit payment platform, and the clients pay directly into our bank. Each month one or two of them fail to pay. We have not been able to find a way in Xero to create monthly reporting on whether any of the payments due that month are missing. We have also not been able to find a way to create a report of accrued income – a forward view of monthly payments that are coming due each month for the next year. This currently creates a substantial bookkeeping burden of keeping a manual spreadsheet of monthly payments made and due outside of Xero. I would like to find a solution to automating these reporting needs, and I don’t imagine that I’m the only person that has this need. I would welcome offers to solve this problem. I am open to using 3rd party software if that is necessary. Many thanks and best wishes Caroline Ward

Creating Master HS table

I need support to Create a master HS table ( template fields structure will be given which includes tariff description , third country duty rates, vat rate , prohibited , restricted ,etc ) which includes the following countries UK, GCC , EU in a excel spreadsheet . Ensuring there is no duplicate d HS codes for countries and correctly capture all details above

Excel Queue management of moulds

A manufacturing company requires an automated queue management system to efficiently allocate moulds for their production process. Currently, the company uses a basic spreadsheet to plan finished product orders by customer. However, there is no functionality to optimize mould utilization across jobs. The proposed project aims to develop a supplementary worksheet within the existing spreadsheet template. This new sheet should provide dynamic visualization of moulds currently in use, as well as a prioritized waiting list for upcoming productions. Mould assignments must be automatically updated in real-time as jobs are completed, to seamlessly transition resources to the next highest priority order. Key requirements for the queue include reversible allocation of moulds to open job slots based on priority rules. Statistical data on mould lifecycles and typical process durations can help estimate theoretical throughput. Conditional formatting should highlight moulds approaching replacement thresholds or impending bottlenecks. Well-designed interfaces will facilitate intuitive management of the schedule by production planners. By centralizing mould queue logic within their existing production planning framework, the company hopes to minimize disruptions from unpredictable tooling failures. Transparent scheduling aims to reduce overtime costs and expedite customer deliveries through optimized resource utilization across all manufacturing jobs.

opportunitypre-funded

Daily scrape of jobs into Google Sheet from employer websites

This project seeks to streamline daily job posting efforts for a large jobs website. At present, we keep it busy we manually finding and posting jobs to the site daily. It's a lot of effort to maintain and I'm looking to streamline and automate it. The 13 organisations I'd like to start with - including links to their pages where jobs are listed/linked out from - are shown in the attached spreadsheet. We'll likely want to expand this list over time. I'm looking to set up a process to monitor for new jobs each day, and to scrape key information into a Google sheet I already have set up. It needs to be a robust process that can run in the longer term to autopilot. The information we'd need to capture for each new job into the Google sheet is as follows: 1 - Job title 2 - HTML of the role description 3 - Employer name 4 - URL of the role 5 - Country 6 - State (if in the USA) Once in the Google Sheet I can then categorise them and import them to the site in batches. Please outline how you'd approach the task. I hope you can help with this task.

Shopify Developer needed for d2c ecommerce website

I'm looking for a shopify development partner with good development and QA practices to work on a client's website to improve conversion on the product pages. Summary of improvement contained in the google sheets - please confirm your understanding and explain your proposed solution for each item in your reply. I will need a time/cost estimation for each item before proceeding and if solution requires a new app i will install it first to explore its functionality. https://docs.google.com/spreadsheets/d/1e4GHPLihihfaqGCCLra5y-XcuUJGDbHcdxhiG0safRo/edit?gid=0#gid=0

opportunity

I need a admin assistant

I have developed a new product and am seeking an admin assistant for a full month. You will have two main tasks: Every day, you will receive alerts from two companies, TES and eTeach. Your task will be to review the job advertisements, locate the hiring manager's email address, and enter it into a spreadsheet. This should take approximately one hour per day. For the remainder of the day, you will be asked to visit specific websites and extract data. While the data may not include email addresses, we will provide you with the necessary format to input them. You will be required to work 6 hours a day Monday to Friday so that means you'll be earning a total if £8.33 per hour We will give you full training but you will have a target. Your first day I will do 3 hours while you shadow me to show you how quickly it can be done and I'd expect you to do 80% of what I can do

Telesales for real estate in London

calls to homeowners to obtain a valuation on their house Project overview Seeking a telesales expert to engage homeowners in London for property listing appointments, leveraging sales and real estate expertise. Objectives To secure appointments with homeowners for property listing sessions, enhancing property sales opportunities in London, uk. Scope of Services - Making outbound calls to homeowners - Gaining appointments for property listing visits - Utilising sales techniques to effectively engage potential clients - Applying knowledge of London's housing market for tailored communication Additional information - will be possible looking for initial 1 day or 2 days per week making calls to book appointments, whihc can be an ongoing contract and flexible. - Send me your quote and experience details. - I will provide Excel spreadsheet of contacts to call and a lot of these I have dealt with before and had previously requested to sell their property. Call center language English Service type Appointment setting, Cold calling

Prepare UK Ltd Company Accounts, Micro-entity & CT Return

I have very simple UK company accounts - about 20 ish expenses receipts, all tallied up in an Excel spreadsheet. No invoices. Everything is tallied up already in Excel and I will send you the Excel files. What I need are: - Set of Company accounts for the tax year - CT600 for HMRC - Micro-entity Accounts for Companies House. I will submit the Micro-entity Accounts to Companies House myself. I want you to submit the CT600 when I have checked and approved the accounts. I will clearly tell you when I am happy for the CT600 to be submitted. Please note these accounts are simple and data will all be provided to you in clear, organised digital format and it will not take much time to do the work. Accurate work and attention to detail is important. I will want to see how you arrived at your figures to ensure they are correct. So I want all calculations done in a digital format that can be sent to me for checking. Timeframe The work needs to be done within about one week of the project being awarded. Due to a bad experience on pph in previous years, if you delay the project and take a very long time to respond to messages in the workstream (longer than 48 hours) I will cancel the project and get someone else to do it. If you have a full time job and think you can fit this project in over multiple weekends, *do not* contact me about this project. I need the work done promptly with someone who can work on it normal weekday office hours. Please only respond to this project if you have time to do the work within the timeframe provided.