{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["חישוב שעות"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":155,"n_cols":9,"rows_kept":155,"cut":false,"hidden":false,"merged":[[40,7,41,8],[22,7,23,8],[26,7,27,8],[28,7,29,8],[0,6,0,8],[0,0,0,4],[32,7,33,8],[34,7,35,8],[38,7,39,8],[10,7,11,8],[14,7,15,8],[16,7,17,8],[20,7,21,8],[8,7,9,8]]}
["כמות שעות",null,null,null,null,null,"סכום שלא נקלט"]
["תאריך","שעת התחלה","שעת סיום","סה\"כ","לתשלום",null,"תאריך","סך שעות","לתשלום"]
[null,null,null,{"$f":"IF(C3=\"\",\"\",(SUM(C3-B3)))","v":""},{"$f":"IF(D3=\"\",\"\",SUM(D3*($H$11*24)))","v":""},null,"2017-05-14",0,{"$f":"IF(H3=\"\",\"\",SUM(H3*($H$11*24)))","v":0}]
[null,null,null,{"$f":"IF(C4=\"\",\"\",(SUM(C4-B4)))","v":""},{"$f":"IF(D4=\"\",\"\",SUM(D4*($H$11*24)))","v":""},null,"2017-05-17",0,{"$f":"IF(H4=\"\",\"\",SUM(H4*($H$11*24)))","v":0}]
[null,null,null,"",{"$f":"IF(D5=\"\",\"\",SUM(D5*($H$11*24)))","v":""},null,"2017-05-23",0,{"$f":"IF(H5=\"\",\"\",SUM(H5*($H$11*24)))","v":0}]
[null,null,null,"",{"$f":"IF(D6=\"\",\"\",SUM(D6*($H$11*24)))","v":""}]
[null,null,null,{"$f":"IF(C7=\"\",\"\",(SUM(C7-B7)))","v":""},{"$f":"IF(D7=\"\",\"\",SUM(D7*($H$11*24)))","v":""}]
[null,null,null,"",""]
[null,null,null,"","",null,null,"תעריף"]
[null,null,null,"",""]
[null,null,null,"","",null,null,80]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",{"$f":"IF(D15=\"\",\"\",SUM(D15*($H$11*24)))","v":""},null,null,"סה\"כ שעות"]
[null,null,null,"",""]
[null,null,null,"","",null,null,{"$f":"SUM(D3:D200,H3)","v":0}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"","",null,null,"סכום ביניים"]
[null,null,null,"",""]
[null,null,null,"","",null,null,{"$f":"SUM(H17*(H11*24))","v":0}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"","",null,null,"סה\"כ סכום שלא נקלט"]
[null,null,null,"",""]
[null,null,null,"","",null,null,{"$f":"SUM(I3:I5)","v":0}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"","",null,null,"זכות\\חובה ישנה"]
[null,null,null,"",""]
[null,null,null,"","",null,null,0]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"","",null,null,"סך הכל לתשלום"]
[null,null,null,"",""]
[null,null,null,"","",null,null,{"$f":"SUM(H23:H35,I3)","v":0}]
[null,null,null,{"$f":"IF(C42=\"\",\"\",(SUM(C42-B42)))","v":""},{"$f":"IF(D42=\"\",\"\",SUM(D42*($H$11*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,"",{"$f":"IF(D58=\"\",\"\",SUM(D58*($H$11*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,"",{"$f":"IF(D67=\"\",\"\",SUM(D67*($H$11*24)))","v":""}]
[null,null,null,{"$f":"IF(C68=\"\",\"\",(SUM(C68-B68)))","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,"",{"$f":"IF(D99=\"\",\"\",SUM(D99*($H$11*24)))","v":""}]
[null,null,null,{"$f":"IF(C100=\"\",\"\",(SUM(C100-B100)))","v":""},{"$f":"IF(D100=\"\",\"\",SUM(D100*($H$11*24)))","v":""}]
[null,null,null,{"$f":"IF(C101=\"\",\"\",(SUM(C101-B101)))","v":""},{"$f":"IF(D101=\"\",\"\",SUM(D101*($H$11*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,{"$f":"IF(C119=\"\",\"\",(SUM(C119-B119)))","v":""},{"$f":"IF(D119=\"\",\"\",SUM(D119*($H$11*24)))","v":""}]
[null,null,null,{"$f":"IF(C120=\"\",\"\",(SUM(C120-B120)))","v":""},{"$f":"IF(D120=\"\",\"\",SUM(D120*($H$11*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,{"$f":"IF(C146=\"\",\"\",(SUM(C146-B146)))","v":""},{"$f":"IF(D146=\"\",\"\",SUM(D146*($H$11*24)))","v":""}]
[null,null,null,{"$f":"IF(C147=\"\",\"\",(SUM(C147-B147)))","v":""},{"$f":"IF(D147=\"\",\"\",SUM(D147*($H$11*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,"",""]