Find Jobs
Hire Freelancers

Google Doc script to make auto calculation

$10-30 USD

Completato
Pubblicato più di 9 anni fa

$10-30 USD

Pagato al completamento
Here is a sample google sheet. [login to view URL] Please Make a script to do this How it works. 1. Timestamp & Data fields are filled up already. 2. Data "A" have to be calculate like this. 1) row #2: first of A's Hours is 0 2) find next A 3) row #9: second A is calculated by first row of A and this row. formula is (row#2:Timestamp - row#9:Timestamp)*24. fill up Hours field 4) find next A 5) row #12: fill up Hours field with 0 6) find next A 7) row #13: same logic with 3: fill up hours field 8) stop to find at the end of A 3. Do same with "B", "C", "D" 4. row #6: if that data(In this sample "B" - one of A,B,C,D) is already is processed. stop to calculate 5. open Result Sheet 6. Write "A", "B", "C", "D" at any position 7. Write total hours by each data. (sum of Hours field by data) 8. this function have to work with custom button (add click button or menu)
Rif. progetto: 6507535

Info sul progetto

7 proposte
Progetto a distanza
Attivo 10 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hello, I've already done the formula, and validated it against 300 rows of data. Formula works perfectly fine :) I'm not sure of how I could share the spreadsheet before you could accept my bid. But I think you could message me and we could talk it. I've placed a very low bid because I really need to get some positive reviews to get my profile started. Feel free to message me so I could show you the logic of my formula before accepting/declining my bid. Regards, Amr
$10 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
7 freelance hanno fatto un'offerta media di $23 USD
Avatar dell'utente
Hello, I am an excel and data entry expert. Contact me for more informations. Kind regards, Dragos !
$30 USD in 2 giorni
5,0 (30 valutazioni)
4,4
4,4
Avatar dell'utente
Hi! I have 3 years of experience developing apps and solutions using the Google platform. I've gone through your project requirements and I know what needs to be done. I'd love the opportunity to work on your project and I'm ready to begin right away. Regards, Georg
$30 USD in 2 giorni
4,4 (3 valutazioni)
4,2
4,2
Avatar dell'utente
I read the instructions, I can do this. I have done this kind of work earlier but not with freelancer. If you are interested we can have a quick discussion now. Waiting your response - Thanks, Shailaja
$25 USD in 2 giorni
5,0 (1 valutazione)
0,8
0,8
Avatar dell'utente
hi, we have done a lots of project on Google script latest project we have completed is automatic sending emails to id in sheet based on data change.(something like mail chimp). we assure you if 100%accuracy and satisfaction. we will provide support even after completion of project. with regards, Team, DEVELOPER HUB
$30 USD in 4 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Dear, I can easily do this in 15 minutes. The most time will go to the preparation: I will have a couple of questions on how you want this working exactly. There are various ways to do this and the best solution will be the one that fits your handling best. Not only do I have the right hard-skills to do the job, but I also have the soft-skills to communicate about it with you, understand your needs and deliver the best solution on time. My first question would be: do you want to have this working in Google Sheets or in Excel? About the handling: - File is open and closed from time to time - How do you want to feed the sheet? I.e. what do you want to do step by step? E.g. Person clicks on button: this will add a line with 1. Timestamp, 2. A/B/C/D (do you want four buttons or do you want a box popping up where you can enter this value or will you enter it manually in the cell itself after the timestamp is added?) and 3. hours for this value (0 if start, count hours if end) - On second sheet, the total hours are counted automatically As you can see I am new to Freelancer.com, this is my first bid and I look forward to receiving your feedback and hopefully getting this first opportunity from you. Do not hesitate to contact me to discuss further details. Best regards, Michael
$10 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
Los Angeles, United States
5,0
16
Metodo di pagamento verificato
Membro dal gen 15, 2009

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.