{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["חישוב שעות","סיכום חודשי"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"חישוב שעות","index":0,"n_rows":380,"n_cols":16,"rows_kept":380,"cut":false,"hidden":false,"merged":[[0,8,0,9],[0,6,0,7],[1,6,1,7],[3,0,3,4],[3,7,3,9],[6,0,6,5],[6,7,6,9],[1,8,1,9],[4,7,4,9],[4,0,4,4]]}
["הכנס חודש","הכנס תעריף","סה\"כ מונה","סה\"כ לא נקלט","סכום ביניים",null,"זכות\\חובה ישנה",null,"סה\"כ לתשלום"]
["2022-08-01",40,{"$f":"SUM(D9:D280)","v":8.1018515629693866E-5},{"$f":"SUM(I9:I280)","v":0.66666666666666663},{"$f":"SUM(C2*(B2*24),D2*(B2*24))","v":640.07777777500451},null,0,null,{"$f":"SUM(E2,G2,)","v":640.07777777500451}]
[]
["לוח בקרה",null,null,null,null,null,null,"לוח בקרה"]
[]
[]
["מונה שעות עבודה",null,null,null,null,null,null,"הכנס ידני סך שעות שלא נקלט במונה",null,null,null,null,null,null,null,"2019-11-01"]
["תאריך","שעת התחלה","שעת סיום","סה\"כ","לתשלום","מס",null,"תאריך","סך שעות","לתשלום",null,null,null,null,null,"2019-12-01"]
["2022-08-19",44792.530266203707,44792.530277777776,{"$f":"IF(C9=\"\",\"\",(SUM(C9-B9)))","v":"00:00:01"},{"$f":"IF(D9=\"\",\"\",SUM(D9*($B$2*24)))","v":1.1111106723546982E-2},null,null,"2022-08-19","12:00:00"]
["2022-08-19",44792.530300925922,44792.530324074076,"00:00:02",{"$f":"IF(D10=\"\",\"\",SUM(D10*($B$2*24)))","v":2.2222227416932583E-2},{"$f":"IF($A10=$A11,\"\",MAX($F$8:F9)+1)","v":""},null,null,"04:00:00",{"$f":"IF(I10=\"\",\"\",SUM(I10*($B$2*24)))","v":160},null,null,null,null,null,"2020-02-01"]
["2022-08-19",44792.530416666668,44792.530462962961,"00:00:04",4.4444440864026546E-2,{"$f":"IF($A11=$A12,\"\",MAX($F$8:F10)+1)","v":1},null,null,null,"",null,null,null,null,null,"2020-03-01"]
[null,null,null,"","",{"$f":"IF($A12=$A13,\"\",MAX($F$8:F11)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-04-01"]
[null,null,null,"","",{"$f":"IF($A13=$A14,\"\",MAX($F$8:F12)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-05-01"]
[null,null,null,"","",{"$f":"IF($A14=$A15,\"\",MAX($F$8:F13)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-06-01"]
[null,null,null,"","",{"$f":"IF($A15=$A16,\"\",MAX($F$8:F14)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-07-01"]
[null,null,null,"","",{"$f":"IF($A16=$A17,\"\",MAX($F$8:F15)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-08-01"]
[null,null,null,{"$f":"IF(C17=\"\",\"\",(SUM(C17-B17)))","v":""},"",{"$f":"IF($A17=$A18,\"\",MAX($F$8:F16)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-09-01"]
[null,null,null,"","",{"$f":"IF($A18=$A19,\"\",MAX($F$8:F17)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-10-01"]
[null,null,null,"","",{"$f":"IF($A19=$A20,\"\",MAX($F$8:F18)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-11-01"]
[null,null,null,"","",{"$f":"IF($A20=$A21,\"\",MAX($F$8:F19)+1)","v":""},null,null,null,"",null,null,null,null,null,"2020-12-01"]
[null,null,null,"","",{"$f":"IF($A21=$A22,\"\",MAX($F$8:F20)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-01-01"]
[null,null,null,"","",{"$f":"IF($A22=$A23,\"\",MAX($F$8:F21)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-02-01"]
[null,null,null,"","",{"$f":"IF($A23=$A24,\"\",MAX($F$8:F22)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-03-01"]
[null,null,null,"","",{"$f":"IF($A24=$A25,\"\",MAX($F$8:F23)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-04-01"]
[null,null,null,"","",{"$f":"IF($A25=$A26,\"\",MAX($F$8:F24)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-05-01"]
[null,null,null,"","",{"$f":"IF($A26=$A27,\"\",MAX($F$8:F25)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-06-01"]
[null,null,null,"","",{"$f":"IF($A27=$A28,\"\",MAX($F$8:F26)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-07-01"]
[null,null,null,"","",{"$f":"IF($A28=$A29,\"\",MAX($F$8:F27)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-08-01"]
[null,null,null,"","",{"$f":"IF($A29=$A30,\"\",MAX($F$8:F28)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-09-01"]
[null,null,null,"","",{"$f":"IF($A30=$A31,\"\",MAX($F$8:F29)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-10-01"]
[null,null,null,"","",{"$f":"IF($A31=$A32,\"\",MAX($F$8:F30)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-11-01"]
[null,null,null,"","",{"$f":"IF($A32=$A33,\"\",MAX($F$8:F31)+1)","v":""},null,null,null,"",null,null,null,null,null,"2021-12-01"]
[null,null,null,"","",{"$f":"IF($A33=$A34,\"\",MAX($F$8:F32)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-01-01"]
[null,null,null,"","",{"$f":"IF($A34=$A35,\"\",MAX($F$8:F33)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-02-01"]
[null,null,null,"","",{"$f":"IF($A35=$A36,\"\",MAX($F$8:F34)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-03-01"]
[null,null,null,"","",{"$f":"IF($A36=$A37,\"\",MAX($F$8:F35)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-04-01"]
[null,null,null,"","",{"$f":"IF($A37=$A38,\"\",MAX($F$8:F36)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-05-01"]
[null,null,null,"","",{"$f":"IF($A38=$A39,\"\",MAX($F$8:F37)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-06-01"]
[null,null,null,"","",{"$f":"IF($A39=$A40,\"\",MAX($F$8:F38)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-07-01"]
[null,null,null,"","",{"$f":"IF($A40=$A41,\"\",MAX($F$8:F39)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-08-01"]
[null,null,null,"","",{"$f":"IF($A41=$A42,\"\",MAX($F$8:F40)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-09-01"]
[null,null,null,"","",{"$f":"IF($A42=$A43,\"\",MAX($F$8:F41)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-10-01"]
[null,null,null,"","",{"$f":"IF($A43=$A44,\"\",MAX($F$8:F42)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-11-01"]
[null,null,null,"","",{"$f":"IF($A44=$A45,\"\",MAX($F$8:F43)+1)","v":""},null,null,null,"",null,null,null,null,null,"2022-12-01"]
[null,null,null,"","",{"$f":"IF($A45=$A46,\"\",MAX($F$8:F44)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-01-01"]
[null,null,null,"","",{"$f":"IF($A46=$A47,\"\",MAX($F$8:F45)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-02-01"]
[null,null,null,"","",{"$f":"IF($A47=$A48,\"\",MAX($F$8:F46)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-03-01"]
[null,null,null,"","",{"$f":"IF($A48=$A49,\"\",MAX($F$8:F47)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-04-01"]
[null,null,null,"","",{"$f":"IF($A49=$A50,\"\",MAX($F$8:F48)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-05-01"]
[null,null,null,"","",{"$f":"IF($A50=$A51,\"\",MAX($F$8:F49)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-06-01"]
[null,null,null,"","",{"$f":"IF($A51=$A52,\"\",MAX($F$8:F50)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-07-01"]
[null,null,null,"","",{"$f":"IF($A52=$A53,\"\",MAX($F$8:F51)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-08-01"]
[null,null,null,"","",{"$f":"IF($A53=$A54,\"\",MAX($F$8:F52)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-09-01"]
[null,null,null,"","",{"$f":"IF($A54=$A55,\"\",MAX($F$8:F53)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-10-01"]
[null,null,null,"","",{"$f":"IF($A55=$A56,\"\",MAX($F$8:F54)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-11-01"]
[null,null,null,"","",{"$f":"IF($A56=$A57,\"\",MAX($F$8:F55)+1)","v":""},null,null,null,"",null,null,null,null,null,"2023-12-01"]
[null,null,null,"","",{"$f":"IF($A57=$A58,\"\",MAX($F$8:F56)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-01-01"]
[null,null,null,"","",{"$f":"IF($A58=$A59,\"\",MAX($F$8:F57)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-02-01"]
[null,null,null,"","",{"$f":"IF($A59=$A60,\"\",MAX($F$8:F58)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-03-01"]
[null,null,null,"","",{"$f":"IF($A60=$A61,\"\",MAX($F$8:F59)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-04-01"]
[null,null,null,"","",{"$f":"IF($A61=$A62,\"\",MAX($F$8:F60)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-05-01"]
[null,null,null,"","",{"$f":"IF($A62=$A63,\"\",MAX($F$8:F61)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-06-01"]
[null,null,null,"","",{"$f":"IF($A63=$A64,\"\",MAX($F$8:F62)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-07-01"]
[null,null,null,"","",{"$f":"IF($A64=$A65,\"\",MAX($F$8:F63)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-08-01"]
[null,null,null,"","",{"$f":"IF($A65=$A66,\"\",MAX($F$8:F64)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-09-01"]
[null,null,null,"","",{"$f":"IF($A66=$A67,\"\",MAX($F$8:F65)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-10-01"]
[null,null,null,"","",{"$f":"IF($A67=$A68,\"\",MAX($F$8:F66)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-11-01"]
[null,null,null,"","",{"$f":"IF($A68=$A69,\"\",MAX($F$8:F67)+1)","v":""},null,null,null,"",null,null,null,null,null,"2024-12-01"]
[null,null,null,"","",{"$f":"IF($A69=$A70,\"\",MAX($F$8:F68)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-01-01"]
[null,null,null,"","",{"$f":"IF($A70=$A71,\"\",MAX($F$8:F69)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-02-01"]
[null,null,null,"","",{"$f":"IF($A71=$A72,\"\",MAX($F$8:F70)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-03-01"]
[null,null,null,"","",{"$f":"IF($A72=$A73,\"\",MAX($F$8:F71)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-04-01"]
[null,null,null,"",{"$f":"IF(D73=\"\",\"\",SUM(D73*($B$2*24)))","v":""},{"$f":"IF($A73=$A74,\"\",MAX($F$8:F72)+1)","v":""},null,null,null,{"$f":"IF(I73=\"\",\"\",SUM(I73*($B$2*24)))","v":""},null,null,null,null,null,"2025-05-01"]
[null,null,null,"","",{"$f":"IF($A74=$A75,\"\",MAX($F$8:F73)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-06-01"]
[null,null,null,"","",{"$f":"IF($A75=$A76,\"\",MAX($F$8:F74)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-07-01"]
[null,null,null,"","",{"$f":"IF($A76=$A77,\"\",MAX($F$8:F75)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-08-01"]
[null,null,null,"","",{"$f":"IF($A77=$A78,\"\",MAX($F$8:F76)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-09-01"]
[null,null,null,"","",{"$f":"IF($A78=$A79,\"\",MAX($F$8:F77)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-10-01"]
[null,null,null,"","",{"$f":"IF($A79=$A80,\"\",MAX($F$8:F78)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-11-01"]
[null,null,null,"","",{"$f":"IF($A80=$A81,\"\",MAX($F$8:F79)+1)","v":""},null,null,null,"",null,null,null,null,null,"2025-12-01"]
[null,null,null,{"$f":"IF(C81=\"\",\"\",(SUM(C81-B81)))","v":""},"",{"$f":"IF($A81=$A82,\"\",MAX($F$8:F80)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-01-01"]
[null,null,null,"","",{"$f":"IF($A82=$A83,\"\",MAX($F$8:F81)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-02-01"]
[null,null,null,"","",{"$f":"IF($A83=$A84,\"\",MAX($F$8:F82)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-03-01"]
[null,null,null,"","",{"$f":"IF($A84=$A85,\"\",MAX($F$8:F83)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-04-01"]
[null,null,null,"","",{"$f":"IF($A85=$A86,\"\",MAX($F$8:F84)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-05-01"]
[null,null,null,"","",{"$f":"IF($A86=$A87,\"\",MAX($F$8:F85)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-06-01"]
[null,null,null,"","",{"$f":"IF($A87=$A88,\"\",MAX($F$8:F86)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-07-01"]
[null,null,null,"","",{"$f":"IF($A88=$A89,\"\",MAX($F$8:F87)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-08-01"]
[null,null,null,"","",{"$f":"IF($A89=$A90,\"\",MAX($F$8:F88)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-09-01"]
[null,null,null,"","",{"$f":"IF($A90=$A91,\"\",MAX($F$8:F89)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-10-01"]
[null,null,null,{"$f":"IF(C91=\"\",\"\",(SUM(C91-B91)))","v":""},"",{"$f":"IF($A91=$A92,\"\",MAX($F$8:F90)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-11-01"]
[null,null,null,"","",{"$f":"IF($A92=$A93,\"\",MAX($F$8:F91)+1)","v":""},null,null,null,"",null,null,null,null,null,"2026-12-01"]
[null,null,null,"","",{"$f":"IF($A93=$A94,\"\",MAX($F$8:F92)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-01-01"]
[null,null,null,"","",{"$f":"IF($A94=$A95,\"\",MAX($F$8:F93)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-02-01"]
[null,null,null,{"$f":"IF(C95=\"\",\"\",(SUM(C95-B95)))","v":""},"",{"$f":"IF($A95=$A96,\"\",MAX($F$8:F94)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-03-01"]
[null,null,null,"","",{"$f":"IF($A96=$A97,\"\",MAX($F$8:F95)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-04-01"]
[null,null,null,"","",{"$f":"IF($A97=$A98,\"\",MAX($F$8:F96)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-05-01"]
[null,null,null,"","",{"$f":"IF($A98=$A99,\"\",MAX($F$8:F97)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-06-01"]
[null,null,null,"","",{"$f":"IF($A99=$A100,\"\",MAX($F$8:F98)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-07-01"]
[null,null,null,"","",{"$f":"IF($A100=$A101,\"\",MAX($F$8:F99)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-08-01"]
[null,null,null,"","",{"$f":"IF($A101=$A102,\"\",MAX($F$8:F100)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-09-01"]
[null,null,null,"","",{"$f":"IF($A102=$A103,\"\",MAX($F$8:F101)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-10-01"]
[null,null,null,"","",{"$f":"IF($A103=$A104,\"\",MAX($F$8:F102)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-11-01"]
[null,null,null,"","",{"$f":"IF($A104=$A105,\"\",MAX($F$8:F103)+1)","v":""},null,null,null,"",null,null,null,null,null,"2027-12-01"]
[null,null,null,"","",{"$f":"IF($A105=$A106,\"\",MAX($F$8:F104)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-01-01"]
[null,null,null,"","",{"$f":"IF($A106=$A107,\"\",MAX($F$8:F105)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-02-01"]
[null,null,null,"","",{"$f":"IF($A107=$A108,\"\",MAX($F$8:F106)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-03-01"]
[null,null,null,"","",{"$f":"IF($A108=$A109,\"\",MAX($F$8:F107)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-04-01"]
[null,null,null,"","",{"$f":"IF($A109=$A110,\"\",MAX($F$8:F108)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-05-01"]
[null,null,null,"","",{"$f":"IF($A110=$A111,\"\",MAX($F$8:F109)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-06-01"]
[null,null,null,"","",{"$f":"IF($A111=$A112,\"\",MAX($F$8:F110)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-07-01"]
[null,null,null,"","",{"$f":"IF($A112=$A113,\"\",MAX($F$8:F111)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-08-01"]
[null,null,null,"","",{"$f":"IF($A113=$A114,\"\",MAX($F$8:F112)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-09-01"]
[null,null,null,"","",{"$f":"IF($A114=$A115,\"\",MAX($F$8:F113)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-10-01"]
[null,null,null,"","",{"$f":"IF($A115=$A116,\"\",MAX($F$8:F114)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-11-01"]
[null,null,null,"","",{"$f":"IF($A116=$A117,\"\",MAX($F$8:F115)+1)","v":""},null,null,null,"",null,null,null,null,null,"2028-12-01"]
[null,null,null,"","",{"$f":"IF($A117=$A118,\"\",MAX($F$8:F116)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-01-01"]
[null,null,null,"","",{"$f":"IF($A118=$A119,\"\",MAX($F$8:F117)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-02-01"]
[null,null,null,"","",{"$f":"IF($A119=$A120,\"\",MAX($F$8:F118)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-03-01"]
[null,null,null,"","",{"$f":"IF($A120=$A121,\"\",MAX($F$8:F119)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-04-01"]
[null,null,null,"","",{"$f":"IF($A121=$A122,\"\",MAX($F$8:F120)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-05-01"]
[null,null,null,{"$f":"IF(C122=\"\",\"\",(SUM(C122-B122)))","v":""},"",{"$f":"IF($A122=$A123,\"\",MAX($F$8:F121)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-06-01"]
[null,null,null,"","",{"$f":"IF($A123=$A124,\"\",MAX($F$8:F122)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-07-01"]
[null,null,null,"","",{"$f":"IF($A124=$A125,\"\",MAX($F$8:F123)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-08-01"]
[null,null,null,"","",{"$f":"IF($A125=$A126,\"\",MAX($F$8:F124)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-09-01"]
[null,null,null,"","",{"$f":"IF($A126=$A127,\"\",MAX($F$8:F125)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-10-01"]
[null,null,null,"","",{"$f":"IF($A127=$A128,\"\",MAX($F$8:F126)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-11-01"]
[null,null,null,"","",{"$f":"IF($A128=$A129,\"\",MAX($F$8:F127)+1)","v":""},null,null,null,"",null,null,null,null,null,"2029-12-01"]
[null,null,null,"","",{"$f":"IF($A129=$A130,\"\",MAX($F$8:F128)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-01-01"]
[null,null,null,"","",{"$f":"IF($A130=$A131,\"\",MAX($F$8:F129)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-02-01"]
[null,null,null,"","",{"$f":"IF($A131=$A132,\"\",MAX($F$8:F130)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-03-01"]
[null,null,null,"","",{"$f":"IF($A132=$A133,\"\",MAX($F$8:F131)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-04-01"]
[null,null,null,"","",{"$f":"IF($A133=$A134,\"\",MAX($F$8:F132)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-05-01"]
[null,null,null,"","",{"$f":"IF($A134=$A135,\"\",MAX($F$8:F133)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-06-01"]
[null,null,null,"","",{"$f":"IF($A135=$A136,\"\",MAX($F$8:F134)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-07-01"]
[null,null,null,"","",{"$f":"IF($A136=$A137,\"\",MAX($F$8:F135)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-08-01"]
[null,null,null,"",{"$f":"IF(D137=\"\",\"\",SUM(D137*($B$2*24)))","v":""},{"$f":"IF($A137=$A138,\"\",MAX($F$8:F136)+1)","v":""},null,null,null,{"$f":"IF(I137=\"\",\"\",SUM(I137*($B$2*24)))","v":""},null,null,null,null,null,"2030-09-01"]
[null,null,null,"","",{"$f":"IF($A138=$A139,\"\",MAX($F$8:F137)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-10-01"]
[null,null,null,"","",{"$f":"IF($A139=$A140,\"\",MAX($F$8:F138)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-11-01"]
[null,null,null,"","",{"$f":"IF($A140=$A141,\"\",MAX($F$8:F139)+1)","v":""},null,null,null,"",null,null,null,null,null,"2030-12-01"]
[null,null,null,"","",{"$f":"IF($A141=$A142,\"\",MAX($F$8:F140)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A142=$A143,\"\",MAX($F$8:F141)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A143=$A144,\"\",MAX($F$8:F142)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A144=$A145,\"\",MAX($F$8:F143)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A145=$A146,\"\",MAX($F$8:F144)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A146=$A147,\"\",MAX($F$8:F145)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A147=$A148,\"\",MAX($F$8:F146)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C148=\"\",\"\",(SUM(C148-B148)))","v":""},"",{"$f":"IF($A148=$A149,\"\",MAX($F$8:F147)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A149=$A150,\"\",MAX($F$8:F148)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A150=$A151,\"\",MAX($F$8:F149)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A151=$A152,\"\",MAX($F$8:F150)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A152=$A153,\"\",MAX($F$8:F151)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A153=$A154,\"\",MAX($F$8:F152)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A154=$A155,\"\",MAX($F$8:F153)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A155=$A156,\"\",MAX($F$8:F154)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A156=$A157,\"\",MAX($F$8:F155)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A157=$A158,\"\",MAX($F$8:F156)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A158=$A159,\"\",MAX($F$8:F157)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A159=$A160,\"\",MAX($F$8:F158)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A160=$A161,\"\",MAX($F$8:F159)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A161=$A162,\"\",MAX($F$8:F160)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A162=$A163,\"\",MAX($F$8:F161)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A163=$A164,\"\",MAX($F$8:F162)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A164=$A165,\"\",MAX($F$8:F163)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A165=$A166,\"\",MAX($F$8:F164)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A166=$A167,\"\",MAX($F$8:F165)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A167=$A168,\"\",MAX($F$8:F166)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A168=$A169,\"\",MAX($F$8:F167)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A169=$A170,\"\",MAX($F$8:F168)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A170=$A171,\"\",MAX($F$8:F169)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A171=$A172,\"\",MAX($F$8:F170)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A172=$A173,\"\",MAX($F$8:F171)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A173=$A174,\"\",MAX($F$8:F172)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A174=$A175,\"\",MAX($F$8:F173)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A175=$A176,\"\",MAX($F$8:F174)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A176=$A177,\"\",MAX($F$8:F175)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A177=$A178,\"\",MAX($F$8:F176)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A178=$A179,\"\",MAX($F$8:F177)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A179=$A180,\"\",MAX($F$8:F178)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C180=\"\",\"\",(SUM(C180-B180)))","v":""},"",{"$f":"IF($A180=$A181,\"\",MAX($F$8:F179)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C181=\"\",\"\",(SUM(C181-B181)))","v":""},"",{"$f":"IF($A181=$A182,\"\",MAX($F$8:F180)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A182=$A183,\"\",MAX($F$8:F181)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A183=$A184,\"\",MAX($F$8:F182)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A184=$A185,\"\",MAX($F$8:F183)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A185=$A186,\"\",MAX($F$8:F184)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A186=$A187,\"\",MAX($F$8:F185)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A187=$A188,\"\",MAX($F$8:F186)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A188=$A189,\"\",MAX($F$8:F187)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A189=$A190,\"\",MAX($F$8:F188)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A190=$A191,\"\",MAX($F$8:F189)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A191=$A192,\"\",MAX($F$8:F190)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A192=$A193,\"\",MAX($F$8:F191)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A193=$A194,\"\",MAX($F$8:F192)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A194=$A195,\"\",MAX($F$8:F193)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A195=$A196,\"\",MAX($F$8:F194)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A196=$A197,\"\",MAX($F$8:F195)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A197=$A198,\"\",MAX($F$8:F196)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A198=$A199,\"\",MAX($F$8:F197)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C199=\"\",\"\",(SUM(C199-B199)))","v":""},"",{"$f":"IF($A199=$A200,\"\",MAX($F$8:F198)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C200=\"\",\"\",(SUM(C200-B200)))","v":""},"",{"$f":"IF($A200=$A201,\"\",MAX($F$8:F199)+1)","v":""},null,null,null,""]
[null,null,null,"",{"$f":"IF(D201=\"\",\"\",SUM(D201*($B$2*24)))","v":""},{"$f":"IF($A201=$A202,\"\",MAX($F$8:F200)+1)","v":""},null,null,null,{"$f":"IF(I201=\"\",\"\",SUM(I201*($B$2*24)))","v":""}]
[null,null,null,"","",{"$f":"IF($A202=$A203,\"\",MAX($F$8:F201)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A203=$A204,\"\",MAX($F$8:F202)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A204=$A205,\"\",MAX($F$8:F203)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A205=$A206,\"\",MAX($F$8:F204)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A206=$A207,\"\",MAX($F$8:F205)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A207=$A208,\"\",MAX($F$8:F206)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A208=$A209,\"\",MAX($F$8:F207)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A209=$A210,\"\",MAX($F$8:F208)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A210=$A211,\"\",MAX($F$8:F209)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A211=$A212,\"\",MAX($F$8:F210)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A212=$A213,\"\",MAX($F$8:F211)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A213=$A214,\"\",MAX($F$8:F212)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A214=$A215,\"\",MAX($F$8:F213)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A215=$A216,\"\",MAX($F$8:F214)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A216=$A217,\"\",MAX($F$8:F215)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A217=$A218,\"\",MAX($F$8:F216)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A218=$A219,\"\",MAX($F$8:F217)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A219=$A220,\"\",MAX($F$8:F218)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A220=$A221,\"\",MAX($F$8:F219)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A221=$A222,\"\",MAX($F$8:F220)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A222=$A223,\"\",MAX($F$8:F221)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A223=$A224,\"\",MAX($F$8:F222)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A224=$A225,\"\",MAX($F$8:F223)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A225=$A226,\"\",MAX($F$8:F224)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C226=\"\",\"\",(SUM(C226-B226)))","v":""},"",{"$f":"IF($A226=$A227,\"\",MAX($F$8:F225)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C227=\"\",\"\",(SUM(C227-B227)))","v":""},"",{"$f":"IF($A227=$A228,\"\",MAX($F$8:F226)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A228=$A229,\"\",MAX($F$8:F227)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A229=$A230,\"\",MAX($F$8:F228)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A230=$A231,\"\",MAX($F$8:F229)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A231=$A232,\"\",MAX($F$8:F230)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A232=$A233,\"\",MAX($F$8:F231)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A233=$A234,\"\",MAX($F$8:F232)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A234=$A235,\"\",MAX($F$8:F233)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A235=$A236,\"\",MAX($F$8:F234)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C236=\"\",\"\",(SUM(C236-B236)))","v":""},"",{"$f":"IF($A236=$A237,\"\",MAX($F$8:F235)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A237=$A238,\"\",MAX($F$8:F236)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A238=$A239,\"\",MAX($F$8:F237)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A239=$A240,\"\",MAX($F$8:F238)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A240=$A241,\"\",MAX($F$8:F239)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A241=$A242,\"\",MAX($F$8:F240)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A242=$A243,\"\",MAX($F$8:F241)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A243=$A244,\"\",MAX($F$8:F242)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A244=$A245,\"\",MAX($F$8:F243)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A245=$A246,\"\",MAX($F$8:F244)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A246=$A247,\"\",MAX($F$8:F245)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A247=$A248,\"\",MAX($F$8:F246)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A248=$A249,\"\",MAX($F$8:F247)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A249=$A250,\"\",MAX($F$8:F248)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A250=$A251,\"\",MAX($F$8:F249)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A251=$A252,\"\",MAX($F$8:F250)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A252=$A253,\"\",MAX($F$8:F251)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A253=$A254,\"\",MAX($F$8:F252)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A254=$A255,\"\",MAX($F$8:F253)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A255=$A256,\"\",MAX($F$8:F254)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A256=$A257,\"\",MAX($F$8:F255)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A257=$A258,\"\",MAX($F$8:F256)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A258=$A259,\"\",MAX($F$8:F257)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A259=$A260,\"\",MAX($F$8:F258)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A260=$A261,\"\",MAX($F$8:F259)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A261=$A262,\"\",MAX($F$8:F260)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A262=$A263,\"\",MAX($F$8:F261)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A263=$A264,\"\",MAX($F$8:F262)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A264=$A265,\"\",MAX($F$8:F263)+1)","v":""},null,null,null,""]
[null,null,null,"",{"$f":"IF(D265=\"\",\"\",SUM(D265*($B$2*24)))","v":""},{"$f":"IF($A265=$A266,\"\",MAX($F$8:F264)+1)","v":""},null,null,null,{"$f":"IF(I265=\"\",\"\",SUM(I265*($B$2*24)))","v":""}]
[null,null,null,"","",{"$f":"IF($A266=$A267,\"\",MAX($F$8:F265)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A267=$A268,\"\",MAX($F$8:F266)+1)","v":""},null,null,null,""]
[null,null,null,{"$f":"IF(C268=\"\",\"\",(SUM(C268-B268)))","v":""},"",{"$f":"IF($A268=$A269,\"\",MAX($F$8:F267)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A269=$A270,\"\",MAX($F$8:F268)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A270=$A271,\"\",MAX($F$8:F269)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A271=$A272,\"\",MAX($F$8:F270)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A272=$A273,\"\",MAX($F$8:F271)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A273=$A274,\"\",MAX($F$8:F272)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A274=$A275,\"\",MAX($F$8:F273)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A275=$A276,\"\",MAX($F$8:F274)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A276=$A277,\"\",MAX($F$8:F275)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A277=$A278,\"\",MAX($F$8:F276)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A278=$A279,\"\",MAX($F$8:F277)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A279=$A280,\"\",MAX($F$8:F278)+1)","v":""},null,null,null,""]
[null,null,null,"","",{"$f":"IF($A280=$A281,\"\",MAX($F$8:F279)+1)","v":""},null,null,null,""]
[null,null,null,"",{"$f":"IF(D281=\"\",\"\",SUM(D281*($I$17*24)))","v":""}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(C300=\"\",\"\",(SUM(C300-B300)))","v":""},{"$f":"IF(D300=\"\",\"\",SUM(D300*($I$17*24)))","v":""}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(C332=\"\",\"\",(SUM(C332-B332)))","v":""},{"$f":"IF(D332=\"\",\"\",SUM(D332*($I$17*24)))","v":""}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(C364=\"\",\"\",(SUM(C364-B364)))","v":""},{"$f":"IF(D364=\"\",\"\",SUM(D364*($I$17*24)))","v":""}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]

{"sheet":"סיכום חודשי","index":1,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
[" חודש",null,null,null,"הכנס יעד יומי","הכנס יעד חודשי"]
[{"$f":"'חישוב שעות'!A2","v":"2022-08-01"},null,null,null,0.125,2.5]
["תאריך","יום בשבוע","סה\"כ","לתשלום","אחוז מהיעד היומי","אחוז מהיעד החודשי"]
[{"$f":"'חישוב שעות'!A2","v":"2022-08-01"},{"$f":"A4","v":"2022-08-01"},{"$f":"SUMIF(טבלה2[תאריך],A4,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A4,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A4,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A4,טבלה1[לתשלום])","v":0},{"$f":"C4/יעד_יומי","v":0},{"$f":"(SUM($C$4:C4)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
[{"$f":"A4+1","v":"2022-08-02"},{"$f":"A5","v":"2022-08-02"},{"$f":"SUMIF(טבלה2[תאריך],A5,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A5,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A5,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A5,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C5)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-03","2022-08-03",{"$f":"SUMIF(טבלה2[תאריך],A6,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A6,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A6,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A6,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C6)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-04","2022-08-04",{"$f":"SUMIF(טבלה2[תאריך],A7,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A7,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A7,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A7,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C7)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-05","2022-08-05",{"$f":"SUMIF(טבלה2[תאריך],A8,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A8,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A8,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A8,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C8)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-06","2022-08-06",{"$f":"SUMIF(טבלה2[תאריך],A9,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A9,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A9,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A9,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C9)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-07","2022-08-07",{"$f":"SUMIF(טבלה2[תאריך],A10,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A10,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A10,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A10,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C10)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-08","2022-08-08",{"$f":"SUMIF(טבלה2[תאריך],A11,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A11,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A11,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A11,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C11)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-09","2022-08-09",{"$f":"SUMIF(טבלה2[תאריך],A12,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A12,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A12,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A12,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C12)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-10","2022-08-10",{"$f":"SUMIF(טבלה2[תאריך],A13,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A13,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A13,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A13,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C13)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-11","2022-08-11",{"$f":"SUMIF(טבלה2[תאריך],A14,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A14,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A14,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A14,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C14)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-12","2022-08-12",{"$f":"SUMIF(טבלה2[תאריך],A15,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A15,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A15,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A15,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C15)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-13","2022-08-13",{"$f":"SUMIF(טבלה2[תאריך],A16,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A16,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A16,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A16,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C16)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-14","2022-08-14",{"$f":"SUMIF(טבלה2[תאריך],A17,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A17,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A17,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A17,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C17)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-15","2022-08-15",{"$f":"SUMIF(טבלה2[תאריך],A18,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A18,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A18,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A18,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C18)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-16","2022-08-16",{"$f":"SUMIF(טבלה2[תאריך],A19,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A19,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A19,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A19,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C19)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-17","2022-08-17",{"$f":"SUMIF(טבלה2[תאריך],A20,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A20,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A20,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A20,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C20)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-18","2022-08-18",{"$f":"SUMIF(טבלה2[תאריך],A21,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A21,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A21,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A21,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C21)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.26666666666666666}]
["2022-08-19","2022-08-19",{"$f":"SUMIF(טבלה2[תאריך],A22,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A22,טבלה1[סה\"כ])","v":"12:00:07"},{"$f":"SUMIF(טבלה2[תאריך],A22,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A22,טבלה1[לתשלום])","v":7.7777775004506111E-2},4.0006481481250376,{"$f":"(SUM($C$4:C22)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-20","2022-08-20",{"$f":"SUMIF(טבלה2[תאריך],A23,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A23,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A23,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A23,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C23)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-21","2022-08-21",{"$f":"SUMIF(טבלה2[תאריך],A24,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A24,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A24,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A24,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C24)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-22","2022-08-22",{"$f":"SUMIF(טבלה2[תאריך],A25,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A25,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A25,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A25,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C25)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-23","2022-08-23",{"$f":"SUMIF(טבלה2[תאריך],A26,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A26,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A26,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A26,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C26)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-24","2022-08-24",{"$f":"SUMIF(טבלה2[תאריך],A27,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A27,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A27,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A27,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C27)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-25","2022-08-25",{"$f":"SUMIF(טבלה2[תאריך],A28,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A28,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A28,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A28,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C28)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-26","2022-08-26",{"$f":"SUMIF(טבלה2[תאריך],A29,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A29,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A29,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A29,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C29)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-27","2022-08-27",{"$f":"SUMIF(טבלה2[תאריך],A30,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A30,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A30,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A30,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C30)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-28","2022-08-28",{"$f":"SUMIF(טבלה2[תאריך],A31,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A31,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A31,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A31,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C31)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-29","2022-08-29",{"$f":"SUMIF(טבלה2[תאריך],A32,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A32,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A32,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A32,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C32)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-30","2022-08-30",{"$f":"SUMIF(טבלה2[תאריך],A33,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A33,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A33,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A33,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C33)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
["2022-08-31","2022-08-31",{"$f":"SUMIF(טבלה2[תאריך],A34,טבלה2[סך שעות])+SUMIF(טבלה1[תאריך],A34,טבלה1[סה\"כ])","v":"00:00:00"},{"$f":"SUMIF(טבלה2[תאריך],A34,טבלה2[לתשלום])+SUMIF(טבלה1[תאריך],A34,טבלה1[לתשלום])","v":0},0,{"$f":"(SUM($C$4:C34)+SUM('חישוב שעות'!$I$9:$I$11))/הכנס_יעד_חודשי","v":0.4666990740729185}]
[null,null,null,null,"שעות החסרות",{"$f":"1-F34","v":0.53330092592708156}]