Tamamlanmış

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: one stop app, how excel works, google-docs.com, google docs.com, function sheet sample, docs google com, docs. google, calculation logic, how to work google docs, how to google docs, how to find google docs, how to auto click, how google docs works, Google Sheet Script, google excel docs, google docs sharing, google docs is, google docs how to, excel sheet formula, excel in google docs, excel google docs, docs.google.docs, google spreadsheets, google sheet, google doc

İş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 Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(0 Değerlendirme)
0.0

Bu iş için 7 freelancer 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. [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
4.8
dragos1910d

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
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 Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0