Find Jobs
Hire Freelancers

Compile Spreadsheet With Formulas

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
I need to create a spreadsheet with the following formulas created. Each day an online writer writes 3-5 articles each day. I need to be able to track the following data for each article -name of article (manual input) -number of sessions (manually input) -number of pages per session (manually input) Calculation #1 - track each article's data for each day Calculation #2 - track all article's data for the work week, which runs from Saturday - Friday. Calculation #3 - if a writer has written an article in the middle of the week, we need to calculate the data for each day, for the work week, but also for a total of 7 days. So if the writer wrote an article on Thursday, we would track for Thursday and friday to complete the week. But we still need to track for addition 5 days. Calculation #4 - based on the number of sessions on the form, for the work week, we need to calculate the pay and any bonus, which is on the example, sheet#2. I've included the sample data.
Project ID: 18332650

About the project

11 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello I will edit the provided spreadsheet to automatically calculate desired output based on conditions. At our company, we have tracking of similar author activities for our clients' blogs. So it will become easy for me to review your calculations and make the spreadsheet calculate stuff for you. Let me know any additional details or any questions you may have. I think this will be done in 24 hours at max. Thanks!
$100 USD in 2 days
4.9 (4 reviews)
3.2
3.2
11 freelancers are bidding on average $91 USD for this job
User Avatar
Hi, I am master in numbers and excel, so consider the job done with perfection. Thanks
$39 USD in 1 day
4.8 (62 reviews)
6.3
6.3
User Avatar
Hello How are you? I have reviewed "Compile Spreadsheet With Formulas". I have good skills for these (Data Entry, Data Processing, Excel). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. I hope to work with you. Thank you.
$140 USD in 3 days
4.8 (91 reviews)
5.9
5.9
User Avatar
Can be created as your requirement within the given time frame. Will be an easy task for me since i am really good with formulas in excel. Thanks !
$80 USD in 2 days
5.0 (29 reviews)
5.6
5.6
User Avatar
hello! I can do it for you. I can create tracker and pay generator for you. Please see reviews on my previous projects to better assess my capability and the quality of service I gave to my clients. thanks
$45 USD in 7 days
5.0 (30 reviews)
4.6
4.6
User Avatar
Experienced project professional, US based, MBA, EXCEL and MS Project expert; strong estimating background, experienced with complex formulas, LOOKUPS, PIVOTS, and charts towards the delivery financial analytics. I would be glad to assist with your tracking model.
$50 USD in 3 days
5.0 (27 reviews)
4.3
4.3
User Avatar
Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I will share my firm profile when you contact me. Thanks Regards Muhammad Zaman
$50 USD in 3 days
5.0 (11 reviews)
3.9
3.9
User Avatar
Hi, hope you are well. Please refer the comments we have received from our previous clients for similar excel spreadsheet solutions. I am confident that I can add value to your requirement. But need some clarity on certain areas. 1. What is referred to as 'data'? Which fields of the sample data set? 2. How do we identify the writer? Is it available in the data table? (I can do the tracking for 7 days even if the work started during the middle of the week) 3. Bonus calculation is clear. Happy to discuss through chat and accept the project. I have done a time span calculation sheet similar to this where when the user input work start date & time start & time end, sheet automatically calculate hours work during day/night/SAT/SUN/Public holiday and identify weekly OT hours as well. A little bit about us..., We are two management accountants (CPA, ACMA, CGMA), full time employed in Australia. Our service priorities are; 1. Complete information security - We value your information as you do. 2. Highest Quality - Professional service is guaranteed. 3. 100% Accuracy - We apply only if we are capable to do it. 4. On time delivery - We value your time. 5. Flexibility - We are open for modifications, changes and improvements. We are new to this website, therefore we provide services for a competitive price as we need your feedback and reviews to grow our business. Please refer our LinkedIn profiles for more information. Yours faithfully, Sachith J. informatikz
$110 USD in 4 days
4.7 (6 reviews)
2.7
2.7
User Avatar
My name is Nicholas Dieg and I graduated Valedictorian of my class. I received a 98.6 overall GPA, received a 1520/1600 on my SATS, a 100 on the NYS English Regents Exam. I have experience with spelling, grammar, proofreading, editing, data entry, MS Word, MS PowerPoint and MS Excel. I'm interested in this offer and would be honored to do this work for you.
$133 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Hi, I'm electrical engineer that works with spreadsheet all day, calculating some metrics of a time all week.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I go through in detail from your requirement and i'm able provide you service on mentioned task. It is a basic work i just need one meeting with you to understand the work process. I can assure my full dedication and error free work for this project. Best, Hamza
$222 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
ATLANTA, United States
5.0
201
Payment method verified
Member since Aug 12, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.