{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1","2","3","4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"1","index":0,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[[1,10,11,10],[12,14,13,15],[0,14,1,15],[2,14,3,15],[5,14,6,15],[7,14,8,15],[10,14,11,15]]}
[45042,"שעת התחלה","שעת סיום","סה\"כ","לתשלום",null,"יום","הזן תאריך","סיכום",null,"מידע:",null,null,null,"תעריף"]
[null,null,null,{"$f":"IF(C2=\"\",\"\",(SUM(C2-B2)))","v":""},{"$f":"IF(D2=\"\",\"\",SUM(D2*($O$3*24)))","v":""},null,{"$f":"IF(H2=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H2,1)),\"\")))","v":""},null,{"$f":"IF(H2=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H2,A:A,\"<\"&H3)))","v":""},null,"לקבלת סיכום השעות היומיות יש להוסיף את התאריך הלועזי לעמודה 'תאריך'. מספיק לרשום יום וחודש בתבנית 1/12. יש לשים לב שנוסף רק התאריך בלי השעה. הסיכום יעבוד רק לאחר שיהיו כבר 2 שורות של תאריכים."]
[null,null,null,{"$f":"IF(C3=\"\",\"\",(SUM(C3-B3)))","v":""},"",null,{"$f":"IF(H3=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H3,1)),\"\")))","v":""},null,{"$f":"IF(H3=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H3,A:A,\"<\"&H4)))","v":""},null,null,null,null,null,50]
[null,null,null,"","",null,{"$f":"IF(H4=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H4,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H5=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H5,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H6=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H6,1)),\"\")))","v":""},null,"",null,null,null,null,null,"סה\"כ"]
[null,null,null,"","",null,{"$f":"IF(H7=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H7,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H8=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H8,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(D2:D97)","v":0}]
[null,null,null,"","",null,{"$f":"IF(H9=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H9,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H10=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H10,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H11=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H11,1)),\"\")))","v":""},null,"",null,null,null,null,null,"לתשלום"]
[null,null,null,"","",null,{"$f":"IF(H12=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H12,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C13=\"\",\"\",(SUM(C13-B13)))","v":""},"",null,{"$f":"IF(H13=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H13,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(O8*(O3*24))","v":0}]
[null,null,null,"","",null,{"$f":"IF(H14=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H14,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H15=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H15,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C16=\"\",\"\",(SUM(C16-B16)))","v":""},"",null,{"$f":"IF(H16=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H16,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H17=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H17,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H18=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H18,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H19=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H19,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H20=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H20,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(H21=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H21,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D22=\"\",\"\",SUM(D22*($O$3*24)))","v":""},null,{"$f":"IF(H22=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H22,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H23=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H23,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H24=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H24,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H25=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H25,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H26=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H26,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H27=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H27,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H28=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H28,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H29=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H29,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H30=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H30,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H31=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H31,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H32=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H32,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H33=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H33,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H34=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H34,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H35=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H35,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H36=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H36,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H37=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H37,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H38=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H38,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H39=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H39,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H40=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H40,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H41=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H41,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H42=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H42,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H43=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H43,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H44=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H44,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H45=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H45,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H46=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H46,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H47=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H47,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H48=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H48,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H49=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H49,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H50=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H50,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H51=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H51,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H52=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H52,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H53=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H53,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D54=\"\",\"\",SUM(D54*($O$3*24)))","v":""},null,{"$f":"IF(H54=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H54,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H55=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H55,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H56=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H56,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H57=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H57,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H58=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H58,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H59=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H59,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H60=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H60,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H61=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H61,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H62=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H62,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H63=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H63,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H64=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H64,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C65=\"\",\"\",(SUM(C65-B65)))","v":""},"",null,{"$f":"IF(H65=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H65,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H66=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H66,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H67=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H67,1)),\"\")))","v":""},null,{"$f":"IF(H67=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H67,A:A,\"<\"&H68)))","v":""}]
[null,null,null,"","",null,{"$f":"IF(H68=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H68,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H69=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H69,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H70=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H70,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H71=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H71,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H72=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H72,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H73=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H73,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H74=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H74,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H75=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H75,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H76=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H76,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H77=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H77,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H78=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H78,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H79=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H79,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H80=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H80,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H81=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H81,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H82=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H82,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H83=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H83,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H84=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H84,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H85=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H85,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D86=\"\",\"\",SUM(D86*($O$3*24)))","v":""},null,{"$f":"IF(H86=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H86,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H87=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H87,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H88=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H88,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H89=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H89,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H90=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H90,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H91=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H91,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H92=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H92,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H93=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H93,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H94=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H94,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H95=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H95,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H96=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H96,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H97=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H97,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-06-09",null,{"$f":"IF(H98=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H98,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-09-08",null,{"$f":"IF(H99=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H99,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,null,null,null,"2014-06-09T14:23:32.370"]
[null,null,null,null,null,null,null,null,null,"2014-09-08T15:19:39.570"]

{"sheet":"2","index":1,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[[12,14,13,15],[0,14,1,15],[1,10,11,10],[2,14,3,15],[5,14,6,15],[7,14,8,15],[10,14,11,15]]}
[45042,"שעת התחלה","שעת סיום","סה\"כ","לתשלום",null,"יום","הזן תאריך","סיכום",null,"מידע:",null,null,null,"תעריף"]
[null,null,null,{"$f":"IF(C2=\"\",\"\",(SUM(C2-B2)))","v":""},{"$f":"IF(D2=\"\",\"\",SUM(D2*($O$3*24)))","v":""},null,{"$f":"IF(H2=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H2,1)),\"\")))","v":""},null,{"$f":"IF(H2=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H2,A:A,\"<\"&H3)))","v":""},null,"לקבלת סיכום השעות היומיות יש להוסיף את התאריך הלועזי לעמודה 'תאריך'. מספיק לרשום יום וחודש בתבנית 1/12. יש לשים לב שנוסף רק התאריך בלי השעה. הסיכום יעבוד רק לאחר שיהיו כבר 2 שורות של תאריכים."]
[null,null,null,{"$f":"IF(C3=\"\",\"\",(SUM(C3-B3)))","v":""},"",null,{"$f":"IF(H3=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H3,1)),\"\")))","v":""},null,{"$f":"IF(H3=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H3,A:A,\"<\"&H4)))","v":""},null,null,null,null,null,50]
[null,null,null,"","",null,{"$f":"IF(H4=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H4,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H5=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H5,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H6=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H6,1)),\"\")))","v":""},null,"",null,null,null,null,null,"סה\"כ"]
[null,null,null,"","",null,{"$f":"IF(H7=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H7,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H8=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H8,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(D2:D97)","v":0}]
[null,null,null,"","",null,{"$f":"IF(H9=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H9,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H10=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H10,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H11=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H11,1)),\"\")))","v":""},null,"",null,null,null,null,null,"לתשלום"]
[null,null,null,"","",null,{"$f":"IF(H12=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H12,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C13=\"\",\"\",(SUM(C13-B13)))","v":""},"",null,{"$f":"IF(H13=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H13,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(O8*(O3*24))","v":0}]
[null,null,null,{"$f":"IF(C14=\"\",\"\",(SUM(C14-B14)))","v":""},"",null,{"$f":"IF(H14=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H14,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H15=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H15,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C16=\"\",\"\",(SUM(C16-B16)))","v":""},"",null,{"$f":"IF(H16=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H16,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C17=\"\",\"\",(SUM(C17-B17)))","v":""},"",null,{"$f":"IF(H17=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H17,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H18=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H18,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H19=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H19,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H20=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H20,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(H21=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H21,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C22=\"\",\"\",(SUM(C22-B22)))","v":""},{"$f":"IF(D22=\"\",\"\",SUM(D22*($O$3*24)))","v":""},null,{"$f":"IF(H22=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H22,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H23=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H23,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H24=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H24,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H25=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H25,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H26=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H26,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H27=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H27,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H28=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H28,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H29=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H29,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H30=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H30,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H31=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H31,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H32=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H32,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H33=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H33,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H34=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H34,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H35=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H35,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H36=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H36,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H37=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H37,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H38=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H38,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H39=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H39,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H40=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H40,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H41=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H41,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H42=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H42,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H43=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H43,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H44=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H44,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H45=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H45,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H46=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H46,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H47=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H47,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H48=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H48,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H49=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H49,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H50=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H50,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H51=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H51,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H52=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H52,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H53=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H53,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D54=\"\",\"\",SUM(D54*($O$3*24)))","v":""},null,{"$f":"IF(H54=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H54,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H55=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H55,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H56=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H56,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H57=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H57,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H58=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H58,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H59=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H59,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H60=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H60,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H61=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H61,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H62=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H62,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H63=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H63,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H64=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H64,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C65=\"\",\"\",(SUM(C65-B65)))","v":""},"",null,{"$f":"IF(H65=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H65,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H66=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H66,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H67=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H67,1)),\"\")))","v":""},null,{"$f":"IF(H67=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H67,A:A,\"<\"&H68)))","v":""}]
[null,null,null,"","",null,{"$f":"IF(H68=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H68,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H69=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H69,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H70=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H70,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H71=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H71,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H72=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H72,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H73=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H73,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H74=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H74,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H75=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H75,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H76=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H76,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H77=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H77,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H78=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H78,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H79=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H79,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H80=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H80,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H81=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H81,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H82=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H82,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H83=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H83,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H84=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H84,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H85=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H85,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D86=\"\",\"\",SUM(D86*($O$3*24)))","v":""},null,{"$f":"IF(H86=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H86,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H87=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H87,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H88=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H88,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H89=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H89,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H90=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H90,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H91=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H91,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H92=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H92,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H93=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H93,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H94=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H94,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H95=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H95,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H96=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H96,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H97=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H97,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-06-09",null,{"$f":"IF(H98=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H98,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-09-08",null,{"$f":"IF(H99=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H99,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,null,null,null,"2014-06-09T14:23:32.370"]
[null,null,null,null,null,null,null,null,null,"2014-09-08T15:19:39.570"]

{"sheet":"3","index":2,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[[12,14,13,15],[0,14,1,15],[1,10,11,10],[2,14,3,15],[5,14,6,15],[7,14,8,15],[10,14,11,15]]}
[45042,"שעת התחלה","שעת סיום","סה\"כ","לתשלום",null,"יום","הזן תאריך","סיכום",null,"מידע:",null,null,null,"תעריף"]
[null,null,null,{"$f":"IF(C2=\"\",\"\",(SUM(C2-B2)))","v":""},{"$f":"IF(D2=\"\",\"\",SUM(D2*($O$3*24)))","v":""},null,{"$f":"IF(H2=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H2,1)),\"\")))","v":""},null,{"$f":"IF(H2=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H2,A:A,\"<\"&H3)))","v":""},null,"לקבלת סיכום השעות היומיות יש להוסיף את התאריך הלועזי לעמודה 'תאריך'. מספיק לרשום יום וחודש בתבנית 1/12. יש לשים לב שנוסף רק התאריך בלי השעה. הסיכום יעבוד רק לאחר שיהיו כבר 2 שורות של תאריכים."]
[null,null,null,{"$f":"IF(C3=\"\",\"\",(SUM(C3-B3)))","v":""},"",null,{"$f":"IF(H3=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H3,1)),\"\")))","v":""},null,{"$f":"IF(H3=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H3,A:A,\"<\"&H4)))","v":""},null,null,null,null,null,50]
[null,null,null,"","",null,{"$f":"IF(H4=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H4,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H5=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H5,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H6=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H6,1)),\"\")))","v":""},null,"",null,null,null,null,null,"סה\"כ"]
[null,null,null,"","",null,{"$f":"IF(H7=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H7,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H8=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H8,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(D2:D97)","v":0}]
[null,null,null,"","",null,{"$f":"IF(H9=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H9,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H10=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H10,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H11=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H11,1)),\"\")))","v":""},null,"",null,null,null,null,null,"לתשלום"]
[null,null,null,"","",null,{"$f":"IF(H12=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H12,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C13=\"\",\"\",(SUM(C13-B13)))","v":""},"",null,{"$f":"IF(H13=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H13,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(O8*(O3*24))","v":0}]
[null,null,null,{"$f":"IF(C14=\"\",\"\",(SUM(C14-B14)))","v":""},"",null,{"$f":"IF(H14=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H14,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H15=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H15,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C16=\"\",\"\",(SUM(C16-B16)))","v":""},"",null,{"$f":"IF(H16=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H16,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C17=\"\",\"\",(SUM(C17-B17)))","v":""},"",null,{"$f":"IF(H17=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H17,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H18=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H18,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H19=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H19,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H20=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H20,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(H21=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H21,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C22=\"\",\"\",(SUM(C22-B22)))","v":""},{"$f":"IF(D22=\"\",\"\",SUM(D22*($O$3*24)))","v":""},null,{"$f":"IF(H22=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H22,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H23=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H23,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H24=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H24,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H25=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H25,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H26=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H26,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H27=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H27,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H28=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H28,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H29=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H29,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H30=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H30,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H31=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H31,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H32=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H32,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H33=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H33,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H34=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H34,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H35=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H35,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H36=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H36,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H37=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H37,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H38=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H38,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H39=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H39,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H40=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H40,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H41=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H41,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H42=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H42,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H43=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H43,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H44=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H44,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H45=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H45,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H46=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H46,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H47=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H47,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H48=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H48,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H49=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H49,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H50=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H50,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H51=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H51,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H52=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H52,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H53=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H53,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D54=\"\",\"\",SUM(D54*($O$3*24)))","v":""},null,{"$f":"IF(H54=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H54,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H55=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H55,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H56=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H56,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H57=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H57,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H58=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H58,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H59=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H59,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H60=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H60,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H61=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H61,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H62=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H62,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H63=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H63,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H64=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H64,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C65=\"\",\"\",(SUM(C65-B65)))","v":""},"",null,{"$f":"IF(H65=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H65,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H66=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H66,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H67=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H67,1)),\"\")))","v":""},null,{"$f":"IF(H67=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H67,A:A,\"<\"&H68)))","v":""}]
[null,null,null,"","",null,{"$f":"IF(H68=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H68,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H69=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H69,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H70=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H70,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H71=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H71,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H72=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H72,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H73=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H73,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H74=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H74,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H75=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H75,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H76=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H76,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H77=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H77,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H78=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H78,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H79=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H79,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H80=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H80,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H81=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H81,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H82=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H82,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H83=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H83,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H84=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H84,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H85=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H85,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D86=\"\",\"\",SUM(D86*($O$3*24)))","v":""},null,{"$f":"IF(H86=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H86,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H87=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H87,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H88=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H88,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H89=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H89,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H90=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H90,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H91=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H91,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H92=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H92,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H93=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H93,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H94=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H94,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H95=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H95,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H96=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H96,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H97=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H97,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-06-09",null,{"$f":"IF(H98=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H98,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-09-08",null,{"$f":"IF(H99=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H99,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,null,null,null,"2014-06-09T14:23:32.370"]
[null,null,null,null,null,null,null,null,null,"2014-09-08T15:19:39.570"]

{"sheet":"4","index":3,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[[12,14,13,15],[0,14,1,15],[1,10,11,10],[2,14,3,15],[5,14,6,15],[7,14,8,15],[10,14,11,15]]}
[45042,"שעת התחלה","שעת סיום","סה\"כ","לתשלום",null,"יום","הזן תאריך","סיכום",null,"מידע:",null,null,null,"תעריף"]
["2023-06-09T14:25:32",45086.601064814815,45086.601076388892,{"$f":"IF(C2=\"\",\"\",(SUM(C2-B2)))","v":1.1574076779652387E-5},{"$f":"IF(D2=\"\",\"\",SUM(D2*($O$3*24)))","v":1.3888892135582864E-2},null,{"$f":"IF(H2=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H2,1)),\"\")))","v":""},null,{"$f":"IF(H2=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H2,A:A,\"<\"&H3)))","v":""},null,"לקבלת סיכום השעות היומיות יש להוסיף את התאריך הלועזי לעמודה 'תאריך'. מספיק לרשום יום וחודש בתבנית 1/12. יש לשים לב שנוסף רק התאריך בלי השעה. הסיכום יעבוד רק לאחר שיהיו כבר 2 שורות של תאריכים."]
[null,null,null,{"$f":"IF(C3=\"\",\"\",(SUM(C3-B3)))","v":""},"",null,{"$f":"IF(H3=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H3,1)),\"\")))","v":""},null,{"$f":"IF(H3=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H3,A:A,\"<\"&H4)))","v":""},null,null,null,null,null,50]
[null,null,null,"","",null,{"$f":"IF(H4=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H4,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H5=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H5,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H6=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H6,1)),\"\")))","v":""},null,"",null,null,null,null,null,"סה\"כ"]
[null,null,null,"","",null,{"$f":"IF(H7=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H7,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H8=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H8,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(D2:D97)","v":1.1574076779652387E-5}]
[null,null,null,"","",null,{"$f":"IF(H9=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H9,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H10=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H10,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H11=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H11,1)),\"\")))","v":""},null,"",null,null,null,null,null,"לתשלום"]
[null,null,null,"","",null,{"$f":"IF(H12=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H12,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C13=\"\",\"\",(SUM(C13-B13)))","v":""},"",null,{"$f":"IF(H13=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H13,1)),\"\")))","v":""},null,"",null,null,null,null,null,{"$f":"SUM(O8*(O3*24))","v":1.3888892135582864E-2}]
[null,null,null,{"$f":"IF(C14=\"\",\"\",(SUM(C14-B14)))","v":""},"",null,{"$f":"IF(H14=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H14,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H15=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H15,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C16=\"\",\"\",(SUM(C16-B16)))","v":""},"",null,{"$f":"IF(H16=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H16,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C17=\"\",\"\",(SUM(C17-B17)))","v":""},"",null,{"$f":"IF(H17=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H17,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H18=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H18,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H19=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H19,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H20=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H20,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(H21=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H21,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C22=\"\",\"\",(SUM(C22-B22)))","v":""},{"$f":"IF(D22=\"\",\"\",SUM(D22*($O$3*24)))","v":""},null,{"$f":"IF(H22=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H22,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H23=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H23,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H24=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H24,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H25=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H25,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H26=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H26,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H27=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H27,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H28=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H28,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H29=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H29,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H30=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H30,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H31=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H31,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H32=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H32,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H33=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H33,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H34=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H34,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H35=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H35,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H36=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H36,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H37=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H37,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H38=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H38,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H39=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H39,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H40=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H40,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H41=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H41,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H42=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H42,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H43=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H43,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H44=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H44,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H45=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H45,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H46=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H46,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H47=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H47,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H48=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H48,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H49=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H49,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H50=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H50,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H51=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H51,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H52=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H52,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H53=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H53,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D54=\"\",\"\",SUM(D54*($O$3*24)))","v":""},null,{"$f":"IF(H54=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H54,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H55=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H55,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H56=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H56,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H57=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H57,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H58=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H58,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H59=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H59,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H60=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H60,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H61=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H61,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H62=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H62,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H63=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H63,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H64=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H64,1)),\"\")))","v":""},null,""]
[null,null,null,{"$f":"IF(C65=\"\",\"\",(SUM(C65-B65)))","v":""},"",null,{"$f":"IF(H65=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H65,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H66=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H66,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H67=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H67,1)),\"\")))","v":""},null,{"$f":"IF(H67=\"\",\"\",(SUMIFS(D:D,A:A,\">=\"&H67,A:A,\"<\"&H68)))","v":""}]
[null,null,null,"","",null,{"$f":"IF(H68=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H68,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H69=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H69,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H70=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H70,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H71=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H71,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H72=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H72,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H73=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H73,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H74=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H74,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H75=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H75,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H76=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H76,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H77=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H77,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H78=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H78,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H79=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H79,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H80=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H80,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H81=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H81,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H82=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H82,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H83=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H83,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H84=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H84,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H85=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H85,1)),\"\")))","v":""},null,""]
[null,null,null,"",{"$f":"IF(D86=\"\",\"\",SUM(D86*($O$3*24)))","v":""},null,{"$f":"IF(H86=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H86,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H87=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H87,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H88=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H88,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H89=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H89,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H90=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H90,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H91=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H91,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H92=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H92,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H93=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H93,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H94=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H94,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H95=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H95,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H96=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H96,1)),\"\")))","v":""},null,""]
[null,null,null,"","",null,{"$f":"IF(H97=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H97,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-06-09",null,{"$f":"IF(H98=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H98,1)),\"\")))","v":""},null,""]
[null,null,null,null,"2014-09-08",null,{"$f":"IF(H99=\"\",\"\",(IFERROR(INDEX({\"א\",\"ב\",\"ג\",\"ד\",\"ה\",\"ו\",\"ז\"},WEEKDAY(H99,1)),\"\")))","v":""},null,""]
[null,null,null,null,null,null,null,null,null,"2014-06-09T14:23:32.370"]
[null,null,null,null,null,null,null,null,null,"2014-09-08T15:19:39.570"]