Find Jobs
Hire Freelancers

Compile Spreadsheet With Formulas

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 18332650

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 2 días
4,9 (4 comentarios)
3,2
3,2
11 freelancers están ofertando un promedio de $91 USD por este trabajo
Avatar del usuario
Hi, I am master in numbers and excel, so consider the job done with perfection. Thanks
$39 USD en 1 día
4,8 (62 comentarios)
6,3
6,3
Avatar del usuario
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 en 3 días
4,8 (91 comentarios)
5,9
5,9
Avatar del usuario
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 en 2 días
5,0 (29 comentarios)
5,6
5,6
Avatar del usuario
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 en 7 días
5,0 (30 comentarios)
4,6
4,6
Avatar del usuario
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 en 3 días
5,0 (27 comentarios)
4,3
4,3
Avatar del usuario
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 en 3 días
5,0 (11 comentarios)
3,9
3,9
Avatar del usuario
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 en 4 días
4,7 (6 comentarios)
2,7
2,7
Avatar del usuario
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 en 1 día
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
Hi, I'm electrical engineer that works with spreadsheet all day, calculating some metrics of a time all week.
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
ATLANTA, United States
5,0
201
Forma de pago verificada
Miembro desde ago 12, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.