Spreadsheet Projects
Looking for freelance Spreadsheet jobs and project work? PeoplePerHour has you covered.
opportunity
Excel analysis and spreadsheet template tracking sheets needed
Excel analysis and spreadsheet template tracking sheets needed for student results data. I require the spreadsheets that I have and some formulas already provided to work how I want them to do that results can be input and student data can be tracked and analysed easily. I need this work done asap.
4 days ago45 proposalsRemoteInvoice extraction spreadsheet
I would like a way that i can set up that information is extracted from invoices and then feeds on to a spreadsheet of all the information i require. im not wanting anything complicated to use, it just takes the three or four things i need from every invoice i have and puts that information in the correct column. it need to work and not need constant adjustment to rules. i will be able to provide the heading from the invoices that needs to always be extracted. Sorry just so you know i need to be able to run this programme my self each day with different invoices as they come in, so this need to be a programme or system that is for myself to use not for me to send you the invoices. thanks
24 days ago24 proposalsRemoteExcel spreadsheet for diminishing temperature in a buffer tank
I need to calculate the diminishing temperature of a buffer tank that is fed with hot water from a boiler and itself feeds radiators or underfloor heating. when the heat requirement is greater than what the boiler can provide, the temperature of the buffer tank will start to decrease and the flow to the radiators will need to increase to compensate...inputs will include flow and temperature from the boiler, delta T from return to boiler and supply from boiler, flow/temperature for the radiators/underfloor heating, Kw in and out, how long the tank will take to cool to a set temperature, what the tank temperature needs to be to last for a set time, and any other things that might be useful...:) I think it's similar to the built-in mortgage calculation in excel?
16 days ago22 proposalsRemoteHelp reproduce a high level project plan in a nice spreadsheet
I am looking for someone to help me with some project management admin. I'm running an outcomes-based programme where the outputs are much more fluid but we still need an overall plan for our first year. it is based around 3 work streams that have responsibility for their own work plans but these need to align with the other workstreams. We've tried using Monday.com but at the moment it is difficult to see and understand the overall plans and how things relate. We are getting a bit stuck in the task 'weeds'. I want to try creating a summarised plan, beautifully designed up in some spreadsheet and the multiple tasks can still be held on Monday.com. The info for one workstream is mostly missing, so we need to be able to easily input when it becomes available. The other two plans are expressed in different ways, that will need alignment but needs to stay in the language that makes sense to each stream as well as 'outsiders'. I want it to look nice and easy to understand at a glance.
13 days ago14 proposalsRemoteI need a spreadsheet for a smal stock control
i would like to knnow if you can do a spread sheet for me is a small stock i can explain you further if you reply to this message thank you
25 days ago41 proposalsRemoteWeb scraping
I am looking at Web scraping software, based on input; to produce a spreadsheet of URL, email address and phone numbers extracted from the contact us pages,using legitimate methods. A URL scrapper will also need to be built into the application. To be able to facilitate the above process.
a day ago26 proposalsRemoteCompany Lookup and Population of Address/Company Reg etc.
This project involves researching and populating key information for 459 companies into a spreadsheet. The starting point is a list containing the legal names of these companies. The key tasks involve using online resources and databases to lookup and retrieve each company's registration number, address details including line 1, line 2, city, region and postcode. The address information will then need to be organized systematically into an excel or google sheet comprising of six columns - Company Legal Name, Company Registration Number, Address Line 1, Address Line 2, City and Postcode. Due diligence must be exercised to ensure the accuracy of data for each field. Resources like company registration portals, annual reports and company websites may need to be referred to gather information. Care should also be taken to standardize the format and populate full addresses avoiding abbreviations or inconsistencies. Partial or unavailable information must be clearly marked as such. Upon completion, the formatted spreadsheet with company details for all the 459 entries must be delivered. The goal is to create a centralized database of key information for these companies in a presentable manner through systematic research and data organization. Interested freelancers possessing strong internet research abilities and experience working with databases and spreadsheets can consider bidding for this project. Familiarity with UK/country specific company information resources will be an asset. Quality and accuracy is paramount as the client would rely on this data for their business needs
19 hours ago27 proposalsRemoteSophisticated Estimate Creator with Email Verification
To build a complex online form for our website, we are searching for a gifted web developer with experience in [login to view URL] platforms. Based on our clients' individual demands, this form will automatically produce rapid service quotations by integrating with an existing Excel spreadsheet. Our Excel spreadsheet provides specific time estimates for each of the several room types that our services cover. Essential prerequisites: Excel Integration & Wix Compatibility: To compute service quotations, seamlessly combine the online form with our Wix website and draw data from an Excel spreadsheet. The spreadsheet contains information on the amount of time needed for various room types, such as 30 classrooms, 10 restrooms, and 4 offices. Quick Quote Creation via Email
19 days ago11 proposalsRemoteNeed 250 Lines Of Copy Writing to excel
I Need A Copy Writer To Copy My Flooring Price List From My suppliers, to a Pre-formatted Excel worksheet, I will Send the different Price list via email and you must transfer to a Pre-Formatted Excel spreadsheet
12 days ago106 proposalsRemoteopportunity
Research for Smartphone stores USA
THE BUDGET IS FIXED I need someone to research and find the names of all independent smartphone/cell/mobile phones in USA. These are phone repair stores or phone accessories stores or just phone stores. Okay so we need all the independent stores. We do not want the stores like Apple Centres or Sony or T Mobile or Orange or Vodafone or 3 etc. We want the smaller stores. So you’ll need to check. We need them all neatly put into an excel spreadsheet We also need the emails to be put into a folder. We need the store name, address, facebook page, website (if they have one) and email address. There are about 170,000 stores in total. All States of the USA required. Data can be found on Google, Facebook, Linkedin and other data resources.
2 days ago26 proposalsRemoteopportunity
Write a year's worth of filler social content
I need to fill 2024's social media calendar with filler content. Sundays - Product Promotions Mondays - Motivation Mondays Tuesdays - Blog Promotions Wednesday - Rewards, Referrals, Newsletter Promos Thursdays - Resource Promotion Fridays - Fun Fact Fridays Saturdays - Product Promotions You can definitely use AI to create them, but want to make sure they're formatted for a US audience and on-brand for us. We're a label printing company. Key highlights are sustainability and eco-friendly, VIP customer service, easy online ordering, etc. If hired, I'll send you all of the links for CTAs, etc and provide a spreadsheet for posts to be logged into. NOTE: You will not need to create any images. This is purely copywriting.
a day ago25 proposalsRemoteResearch for list of smartphone stores in France and Australia
I need someone to research and find the names of all independent smartphone/cell/mobile phones in both France and Australia. These are phone repair stores or phone accessories stores or just phone stores. Okay so we need all the independent stores. We do not want the stores like Apple Centres or Sony or T Mobile or Orange or Vodafone etc. We want the smaller stores. So you’ll need to check. We need them all neatly put into an excel spreadsheet We also need the emails to be put into a folder. We need the store name, address, facebook page, website (if they have one) and email address. There are about 5,000 stores in France. There are about 1,500 stores in Australia. Here are the regions to search. These can be found on Google, Facebook, Linkedin and other data resources. You will be provided with all the areas to search,
3 days ago30 proposalsRemoteGuest Posts Needed
I need guest posts promoting a new crypto DAO/DeFi project on various websites (check the link): https://docs.google.com/spreadsheets/d/1HJwI7zXAJ3KaQz9RNW3fpqnju1PtEH1VibRwgmGvFjo/ - The posts must be PERMANENT with DOFOLLOW links - Work must be accomplished within 4-6 days - I will provide you the content (copy including 500+ words, 1 or 2 anchor texts, banner images, URL, etc.) The budget is fixed. Apply only if you have delivered similar jobs previously. Thank you.
12 days ago33 proposalsRemote20 PAGE ONPAGE SEO OPTIMIZATION KEYWORD
Hello, Straight forward project as i do not have the paid tools such as SEMRUSH / AHREFS / SCREAMING FROG / MOZ / LINKWHISPER / OTHERS 20 url. Need everything from site audit/analysis/ competitor SPYFU/keyword planning/content seo and technical seo. Excel file for job requirements. https://docs.google.com/spreadsheets/d/1lMut4pGMJ8KAPt-sbWF5IQObPDCwMk7LXaGnvq77kYg/edit?usp=sharing For reference only. SEO audit. https://docs.google.com/document/d/13YbdtXqbqEyQlHu_RBd2D16pj1wgja-vep0K2fmy1gs/edit?usp=sharing 7 Days to complete 20 On-Page SEO. Wordpress + Rank Math Pro Please tell me what software you will use to complete these tasks.
8 days ago25 proposalsRemoteLooking for a content updating expert with SEO skills
I have several clients that have out of date content. For example, the content may reference 2022 stats rather than 2024. I'm looking to create a process to keep content updated and gradually update my clients content. For each page, I would like someone to help me with the following process: Requirements: - Assess the existing content rankings - Add bullet point summaries to the top - Identify additional subheadings based on rankings and propose content - Identify and implement EEAT suggestions to improve the quality of the content (I will provide) - Update any out of date stats, data, research and information or add this if there is none currently. - Adapt the language to be more conversational where possible. If possible: - Create a custom image to add to the page (could be made on Canva according to client branding) Notes on process - We will have a joint spreadsheet in which we’ll both work from. I’ll add a list of pages to review (could be between 10-30 pages per month) with a deadline and cost per page. Do let me know if this is something that you can help with!
14 days ago29 proposalsRemoteopportunity
Online research/analytics keywords from 2014 to '23
Am needing help producing a report of the mentions of some healthcare related key phrases over the last 12 years. The phrases are: Patient Centricity and Patients at the Centre (see below other search terms) The analysis of historical data of mentions (going back this far) will be a challenge - but I am open to considering potential proxy analysis instead. Re Social Media - Conducting this research might on X/Twitter is not as easy as it used to be (and involves now a higher cost). But happy to review and agree on joint plan. Country/scope: English speaking countries only (at first) Outputs: I require basic spreadsheets or visual reports to be used in a presentation ( graphic design work will be done via someone else). Assuming some success in producing a picture of usage of these terms, I then have a separate bit of work, regarding COVID 19, and media coverage of 2-3 pharma companies. This is quite a narrow brief, dealing with a 2-3 year time frame only. This separate bit of research is related to the above. KEYWORDS: keywords = [ "Patient centric", "Patient Centric", "Patient First", "Patient at the centre", "Patient at the center", "Patient at the centre of everything we do", "Patient at the center of everything we do", "Patient at the centre of all we do", "Patient at the center of all we do", "Patient Centricity", "Patient centricity"
16 days ago24 proposalsRemoteExecutive Assistant needed for 10-15 hours per week
We are seeking an experienced executive assistant to join our team for a 10-15 hours per week, fully remote role. The ideal candidate will be a self-starter who is comfortable with wearing multiple hats and has a strong interest in supporting the growth and success of our company. Responsibilities: Research, recruit, screen, and negotiate with external suppliers such as marketing or legal firms. Organize company socials, annual dinners, company holidays, birthday presents, and parties. General diary management and book travel arrangements. Research and prepare documents, spreadsheets, and presentations to save the director's time. Order top-quality books for the company's monthly book club. Requirements: Minimum of 5 years of experience as an executive assistant. Strong proficiency in Microsoft Office Suite, particularly Word, Excel, and PowerPoint. Excellent communication and interpersonal skills. Ability to work independently and as part of a team. Strong attention to detail and organizational skills. Flexibility to work occasional evenings and weekends as required. Experience with remote work is preferred. If you are a highly motivated and experienced executive assistant who is ready to take on a challenging and rewarding role, we encourage you to apply by starting your proposal with 'This is 100% me' to show that you've read the full details of the role.
24 days ago63 proposalsRemoteExperienced SEO required (3 years minimum experience)
Our marketing agency is expanding, and we're in need of an SEO Specialist to focus on our flagship e-commerce client. This client has a 20-year old domain and has recently seen a 20% increase in organic traffic over the past three months compared to the same period last year. You'll be working solely with this client, using your SEO skills to keep up and improve this growth. Responsibilities: - Work closely with our Performance Marketing Director to set and meet KPIs for the client. - Create a detailed SEO strategy that includes on-page SEO, content creation, technical SEO, and link building. - Coordinate with our team, including content writers and technical staff, to make sure your strategy is implemented effectively. - Carry out thorough keyword research and analysis. - Conduct detailed SERP analysis. - Decide on the best content strategies for the client, figuring out not just the keywords to target but also the type of content that should be created and how to rank it. - Prepare and share reports with the client, showing progress and plans. We prefer using Data Studio, but we’re open to other tools if you have a better option. - Forecast the work needed and plan resources with the project manager for both current and upcoming client needs. - Be the go-to person for SEO within our team, providing guidance and pushing the client's SEO forward. Requirements: - Proven track record in SEO, showing your ability to develop and execute successful strategies. - Strong skills in keyword research, SERP analysis, and creating SEO strategies. - Experience in creating and presenting SEO reports. - Good at working with spreadsheets for planning and strategy development. - Able to work independently and manage your workload to meet deadlines. - Strong communication skills, comfortable explaining complex ideas in a simple way. Please send your proposals. Price is a placeholder.
14 days ago53 proposalsRemoteLaboratory Test Volume and Client Activity Excel Dashboard
Hello! Not sure if I am in the right category or not, so I don't know how to price this out so its entered as $10, but please specify what the cost would be. Summary: I work for a diagnostic laboratory. Today I don't have the combined data to track our laboratory client activity, provider utilization and testing volume. I have a few different reports I can download, but none of them come together. I was tasked with this project and I am really struggling trying to bring it to life. I am not an excel expert so I thought I would ask around... In an ideal scenario, I could download the reports and plug the data into a template and a dashboard would repopulate via excel spreadsheet. I listed few items I would be interested in starting with and I would look to your expertise at the same time to help us identify growth opportunities and missed opportunities as well on client and provider utilization. I should also state that I may want an NDA signed for this purpose when the data is shared. I could only attach 3 files so I attached only a few screenshots (Report A, B and D to start) Report A: Volume by Test Panel by Client - This is the only main tracking by test/panel volume that we have today besides individually going into each client portal - I would have to pull a report by month for last year so we can compare previous volume by client - Interested in Total Volume by Sales Rep (month over month) Report B: Client List - A list of all clients. - This report is unique because it shows: - CREATED DATE: Date client was entered (meaning closed won account - it doesn’t necessarily mean a test was received on this date though). - LAST ORDERED DATE: Date client last ordered a test Report B2: Facility Type - I’d want to see where largest volume is coming from by industry channel Report C: All Data by Client by Day - This shows detailed volume by provider by day - Data by sales rep - Can we see provider utilization - Total volume by month/week (4 bar charts) - 2 charts (EX: Month of March Bar Chart - with week 1, week 2, week 3, week 4 volume inside chart). Then show month of February and month of January Report D: All Providers by Client - This includes a list all providers in our system. So any provider on this list, but not on the report C, would be considered an inactive provider Other Data Points: - Would love to see total number of accounts in last 3 months - Graph showing the total number of active and inactive accounts (should add up to total # of accounts) - Percent of actives to inactive Thank you and look forward to hearing from you and your feedback! Thank you! Christine
16 days ago20 proposalsRemoteopportunity
Experienced WordPress and Elementor Website Developer
Job Description We are looking for a highly skilled Website Developer with extensive experience in WordPress and Elementor to make updates to our existing website on an ongoing ad-hoc basis. The ideal candidate will be adept at both using Elementor's visual editor and integrating custom-coded elements to achieve unique, user-centric web solutions. Responsibilities General Changes: • Make some amendments to the hero image and text in the hero position on the homepage. • Add a new prominent link on the homepage, to another page on the site. • Add call to action buttons to 6 coded flip-tiles on the website. • Create and integrate new sections within the existing layout. (There are a total of 5 pages which may require a new section to be added here and there, all copy will be provided). • Efficiently reposition existing sections to enhance user experience and site navigation. • Ensure that the website is fully responsive and works beautifully on mobiles, tablets and reduced browser windows. • Ensure that the latest copy - the document of which will be shared with the freelancer, is reflected on the website. • Ensure that there are no 404/broken links on the site. • Ensure that the Wordpress, Elementor and all active plugins are all updated to most current versions. • Work closely with our team to ensure the visual communication of our website aligns with our brand and message. We are also looking for the design and implementation of a Members' Login area to our existing site. The details are: • There will be no payment portal - Members will have already purchased the items offline, before coming to sign in on this page. • The business (us) will provide members with a login that gives them access to a certain subset of our proprietary research or databases, based on what they purchased offline. We should be able to select through tickbox optionality what each login can access from our stored documents on the backend, when we generate this login. • There will need to be a pleasing, branded and easy interface for the clients to see the documents that they have access to, once they’ve signed in. • The members will not be able to download or screenshot or copy any of this proprietary research, so it has to be locked on the backend. • As each client will have a set number of licenses, the sign in will be tied their unique device ID (MAC address), so that there is no password sharing. • The proprietary items will be stored in this website's back end, and they will be in PDF, excel spreadsheet or video formats (if videos are too large, we will host on Vimeo - first option, or Youtube - second option) Requirements: • Proven experience as a WordPress developer with specific skills in Elementor. • Strong portfolio with at least 5 websites that demonstrate the ability to integrate custom-coded elements using Elementor. • Proficiency in HTML, CSS, JavaScript, and PHP—specifically within the context of WordPress and Elementor. • Excellent attention to detail and a commitment to delivering highly effective and visually appealing website designs. • Ability to communicate clearly and collaborate effectively with our team members. • Experience in creating responsive, user-friendly website designs. • Experience with advanced Elementor functionalities, including motion effects and dynamic content. • Previous work on websites that require secure login and personalised user content. Conditions for reviewing your bid: • Please begin your proposal with the code "ELMNTR3" to confirm your understanding of the job requirements. • Include in your application a minimum of 5 portfolio links showcasing your experience with Elementor and custom coding capabilities. Detail your role and contributions for each project submitted. • You will need to provide exact timing for completion of this project - The deadline will be agreed with the freelancer in advance, but will be a strict deadline, as we will have several other key action items that will rely on this. Please don't provide a deadline that you can't meet. Please provide a total cost for completion of this project, we have been detailed in our brief to ensure everything is laid out clearly. We will not be accepting proposals with an hourly rate, or place-holder bids. • We will shortlist only 3 parties to have video calls with, to award the project - we cannot do so for everyone who asks for this. • If you have good questions for clarification, please ask them as part of your bid. We are excited to find a developer who can bring technical skill and creative insight to our team. We look forward to reviewing your proposals and potentially starting a long-term collaboration.
2 days ago52 proposalsRemote