Devam Ediyor

Google Doc script to make auto calculation

Here is a sample google sheet.

[url removed, login to view]

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)

Beceriler: Excel, Google App Motoru

Daha fazlasını görün: one stop app, function sheet sample, calculation logic, work google docs, google docs works, google sheet script, google excel docs, google docs sharing, excel sheet formula, excel google docs, google spreadsheets, google sheet, google doc, fill spreadsheets excel, custom formula, auto sharing script, app auto click, engine google, excel timestamp, excel sheet app, sample auto, formula sheet, sheet app, excel open formula, find sum excel

İşveren Hakkında:
( 16 değerlendirme ) Los Angeles, United States

Proje NO: #6507535

Seçilen:

amrboghdadysl

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 cou Daha fazlası

1 gün içinde 10$ USD
(0 Değerlendirme)
0.0

7 freelancer bu iş için ortalamada 23$ teklif veriyor

Viqtor

Hi, can help. Have done plenty of google doc scripts. Pls check screenshoot if this fit your hours number format or it must be rounded within 2 number after decimal point, ie smth like 1.30. https://docs.googl Daha fazlası

in 0 gün içinde25$ USD
(12 Değerlendirme)
4.8
dragos1910d

Hello, I am an excel and data entry expert. Contact me for more informations. Kind regards, Dragos !

in 2 gün içinde30$ USD
(30 Değerlendirme)
4.4
GeorgeKazi

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 Daha fazlası

in 2 gün içinde30$ USD
(3 Değerlendirme)
4.2
shaikaru

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

in 2 gün içinde25$ USD
(1 Değerlendirme)
0.8
developerhub1

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 sa Daha fazlası

in 4 gün içinde30$ USD
(0 Değerlendirme)
0.0
MKL7

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 wil Daha fazlası

1 gün içinde 10$ USD
(0 Değerlendirme)
0.0