{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Supplemental Pay August","Input","Example - Supplemental "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Supplemental Pay August","index":0,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[[7,3,7,4],[5,3,5,4],[10,12,10,13],[10,3,10,5],[10,6,10,8],[10,9,10,11]]}
[]
[]
[]
[]
[]
[null,null,"  Engineer Name:",null,null,null,null,"High Avalability :","No","Yes/No","Region","TI"]
[]
[null,null,"  Manager: ",null,null,"Approved date: ",null,null,null,null,"DS Deutsche Shweiz / SR Suisse Romande / TI Tessin"]
[]
[]
[null,null,null,"Supplement hours pay ",null,null,"Standby ",null,null,"Standby call-out ",null,null,"call-out "]
[null,null,"Date","Night work 25% wage supplement \n23:00 - 06:00","Saturday work 25% wage supplement\n00:00 - 24:00 ","Sunday work 50% wage supplement \n00:00 - 24:00","Hours ","CHF / hour  ","Total amount Standby/day \nin CHF ","Call out 1","Call out 2","Call out 3","Emergency Assignement ","Ordered Assignment ","Total Assignments","Comments / Casenr. "]
[null,null,null,null,"insert hours in decimal format",null,null,null,"CHF",75,50,30,150,150,"CHF"]
[null,{"$f":"IF(ISNA(VLOOKUP(C14,Region,2,FALSE)),\"\",VLOOKUP(C14,Region,2,FALSE))","v":"Nationalfeiertag"},"2019-08-01","Nationalfeiertag",null,null,null,{"$f":"IF(OR(WEEKDAY($C14,2)>5,D14>=\"\"\"a\"),$G$57,$H$57)","v":6.6},{"$f":"SUM(G14*H14)","v":0},null,null,null,null,null,{"$f":"SUM($J$13*J14)+($K$13*K14)+($L$13*L14)+($M$13*M14)+($N$13*N14)","v":0}]
[null,"",{"$f":"C14+1","v":"2019-08-02"},"",null,null,null,{"$f":"IF(OR(WEEKDAY($C15,2)>5,D15>=\"\"\"a\"),$G$57,$H$57)","v":4.4000000000000004},0,null,null,null,null,null,{"$f":"SUM($J$13*J15)+($K$13*K15)+($L$13*L15)+($M$13*M15)+($N$13*N15)","v":0}]
[null,"",{"$f":"C15+1","v":"2019-08-03"},"",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-04","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-05","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-06","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-07","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-08","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-09","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-10","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-11","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-12","",null,null,null,4.4000000000000004,0,null,null,null,null,null,{"$f":"SUM($J$13*J25)+($K$13*K25)+($L$13*L25)+($M$13*M25)+($N$13*N25)","v":0}]
[null,"","2019-08-13","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-14","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Maria Himmelfahrt","2019-08-15","Maria Himmelfahrt",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-16","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-17","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-18","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-19","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-20","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-21","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-22","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-23","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-24","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-25","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"","2019-08-26","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-27","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-28","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-29","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-30","",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"","2019-08-31","",null,null,null,6.6,0,null,null,null,null,null,0]
[null,null,null,""]
[]
[null,"Total amount ",null,{"$f":"SUM(D14:D44)","v":0},{"$f":"SUM(E14:E44)","v":0},{"$f":"SUM(F14:F44)","v":0},{"$f":"SUM(G14:G44)","v":0},null,null,{"$f":"SUM(J14:J44)","v":0},0,0,0,0]
[null,null,null,null,0.25,0.5,null,null,"Standby ",null,null,null,null,null,"Call-out "]
[null,null,null,null,{"$f":"SUM(D47:E47)*E48","v":0},{"$f":"F47*F48","v":0},null,"Paid out CHF",{"$f":"SUM(I14:I44)","v":0},null,null,null,null,"Paid out CHF",{"$f":"SUM(O14:O44)","v":0}]
[null,null,null,null,"Total Supplemental Hours Paid Out",{"$f":"E49+F49","v":0}]
[]
[]
[]
[null,null,"1. Tag des Monazts eingeben: Alle Wochentage und Feiertage werden angepasst"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region Abfrage"]
[null,null,null,"Monat",null,null,{"$f":"IF($I$6=\"yes\",G58,G59)","v":6.6},{"$f":"IF($I$6=\"Yes\",H58,H59)","v":4.4000000000000004},null,null,null,null,null,null,null,"DS"]
[null,null,"Supplemental Pay",{"$f":"TEXT(C14,\" MMMM\")","v":" August"},null,"High availability",9,6.3,null,null,null,null,null,null,null,"SR"]
[null,null,null,"Supplemental Pay",null,"Basic stand by",6.6,4.4000000000000004,null,null,null,null,null,null,null,"TI"]
[]
[null,null,null,{"$f":"CONCATENATE(C58,D58)","v":"Supplemental Pay August"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hight Abfrage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]

{"sheet":"Input","index":1,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,2],[26,1,26,2]]}
[]
[]
[null,"B4 :C23","DS Holidy for additional payout",null,null,null,null,"H4 :I23","SR Holidy for additional payout",null,null,null,"M4 :N23","SR Holidy for additional payout"]
[]
[null,"2018-12-25","Weihnachten",null,null,null,null,"2018-12-25","Weihnachten",null,null,null,"2018-12-25","Weihnachten"]
[null,"2018-12-26","Stefanstag",null,null,null,null,"2018-12-31","Republik Genf",null,null,null,"2018-12-26","Stefanstag"]
[]
[null,"2019-01-01","Neujahr",null,null,null,null,"2019-01-01","Neujahr",null,null,null,"2019-01-01","Neujahr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-06","Drei Könige"]
[]
[null,"2019-04-19","Karfreitag",null,null,null,null,"2019-04-19","Karfreitag"]
[]
[null,"2019-04-22","Oster Montag",null,null,null,null,"2019-04-22","Oster Montag",null,null,null,"2019-04-22","Oster Montag"]
[null,"2019-05-01","Tag der Arbeit",null,null,null,null,"2019-05-01","Tag der Arbeit"]
[null,"2019-05-30","Auffahrt",null,null,null,null,"2019-05-30","Auffahrt",null,null,null,"2019-05-30","Auffahrt"]
[]
[null,"2019-06-10","Pfingstmontag",null,null,null,null,"2019-06-10","Pfingstmontag"]
[null,"2019-08-01","Nationalfeiertag",null,null,null,null,"2019-08-01","Nationalfeiertag",null,null,null,"2019-08-01","Nationalfeiertag"]
[null,null,null,null,null,null,null,"2019-09-05","Genfer Bettag",null,null,null,"2019-08-15","Maria Himmelfahrt"]
[]
[null,"2019-12-25","Weihnachten",null,null,null,null,"2019-12-25","Weihnachten",null,null,null,"2019-12-25","Weihnachten"]
[null,"2019-12-26","Stefanstag",null,null,null,null,"2019-12-31","Republik Genf ",null,null,null,"2019-12-26","Stefanstag"]
[]
[]
[null,"To get additional payment use the column B4 to C23 DS and H4 to I23 SR to add or remove public or official state holiday."]

{"sheet":"Example - Supplemental ","index":2,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[10,9,10,11],[10,12,10,13],[11,1,11,2],[5,2,5,3],[7,2,7,3],[10,3,10,5],[10,6,10,8]]}
[]
[]
[]
[]
[]
[null,"Engineer Name "]
[]
[null,"Manager: ",null,null,"Approved date: "]
[]
[]
[null,null,null,"Supplement hours pay ",null,null,"Standby ",null,null,"Standby call-out ",null,null,"call-out "]
[null,"Date ",null,"Night work 25% wage supplement \n23:00 - 06:00","Saturday work 25% wage supplement\n00:00 - 24:00 ","Sunday work 50% wage supplement \n00:00 - 24:00","Hours ","CHF / hour ","Total amount Standby/day \nin CHF ","Call out 1","Call out 2","Call out 3","Emergency Assignement ","Ordered Assignment ","Total Assignments","Comments / Casenr. "]
[null,null,null,null,"insert hours in decimal format",null,null,null,null,75,50,30,150,150,"CHF"]
[null,"Thursday","2018-11-01","Thursday",null,null,null,4.4000000000000004,{"$f":"SUM(G14*H14)","v":0},null,null,null,null,null,{"$f":"SUM($J$13*J14)+($K$13*K14)+($L$13*L14)+($M$13*M14)+($N$13*N14)","v":0}]
[null,"Friday","2018-11-02","Friday",null,null,7,4.4000000000000004,{"$f":"SUM(G15*H15)","v":30.800000000000004},null,null,null,null,null,{"$f":"SUM($J$13*J15)+($K$13*K15)+($L$13*L15)+($M$13*M15)+($N$13*N15)","v":0}]
[null,"Saturday","2018-11-03","Saturday",3,null,24,6.6,158.39999999999998,"1900-01-01",null,null,null,null,75,"Case 29932 / SIX "]
[null,"Sunday","2018-11-04","Sunday",null,null,24,6.6,158.39999999999998,null,null,null,null,null,0]
[null,"Monday","2018-11-05","Monday",null,null,15,4.4000000000000004,66,null,null,null,null,null,0]
[null,"Tuesday","2018-11-06","Tuesday",null,null,15,4.4000000000000004,66,"1900-01-01",null,null,null,null,75,"Case 29935 / Swisscom"]
[null,"Wednesday","2018-11-07","Wednesday",null,null,15,4.4000000000000004,66,null,null,null,null,null,0]
[null,"Thursday","2018-11-08","Thursday",null,null,15,4.4000000000000004,66,null,null,null,null,null,0]
[null,"Friday","2018-11-09","Friday",null,null,8,4.4000000000000004,35.200000000000003,null,null,null,null,null,0]
[null,"Saturday","2018-11-10","Saturday",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"Sunday","2018-11-11","Sunday",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"Monday","2018-11-12","Monday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Tuesday","2018-11-13","Tuesday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Wednesday","2018-11-14","Wednesday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Thursday","2018-11-15","Thursday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Friday","2018-11-16","Friday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Saturday","2018-11-17","Saturday",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"Sunday","2018-11-18","Sunday",null,9,null,6.6,0,null,null,null,null,"1900-01-01",150,"Case 29942/ Move UBS "]
[null,"Monday","2018-11-19","Monday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Tuesday","2018-11-20","Tuesday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Wednesday","2018-11-21","Wednesday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Thursday","2018-11-22","Thursday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Friday","2018-11-23","Friday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Saturday","2018-11-24","Saturday",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"Sunday","2018-11-25","Sunday",null,null,null,6.6,0,null,null,null,null,null,0]
[null,"Monday","2018-11-26","Monday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Tuesday","2018-11-27","Tuesday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Wednesday","2018-11-28","Wednesday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Thursday","2018-11-29","Thursday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[null,"Friday","2018-11-30","Friday",null,null,null,4.4000000000000004,0,null,null,null,null,null,0]
[]
[]
[null,"Total amount ",null,{"$f":"SUM(D14:D43)","v":0},{"$f":"SUM(E14:E43)","v":3},{"$f":"SUM(F14:F43)","v":9},{"$f":"SUM(G14:G43)","v":123},null,null,{"$f":"SUM(J14:J43)","v":2},0,0,0,1]
[null,null,null,null,0.25,0.5,null,null,"Standby ",null,null,null,null,null,"Call-out "]
[null,null,null,null,{"$f":"SUM(D46:E46)","v":3},{"$f":"SUM(F14:F43)","v":9},null,null,{"$f":"SUM(I14:I43)","v":646.79999999999995},null,null,null,null,null,{"$f":"SUM(O14:O43)","v":300}]