{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["منه","له","تقرير ضبط"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"منه","index":0,"n_rows":13,"n_cols":29,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["التاريخ","الاسم","رقم",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,18,19,20,21,22,23,24,25]
["2020-05-15","اسر السيد",100,null,null,null,500.05,400.95]
["2020-05-18","مدحت صالح",200,null,null,null,null,null,null,100,null,100,100,100]
["2020-05-22","MEHWO1"]
["2020-06-02","MEHWO2"]
["2020-05-28","MEHWO3"]
["2020-05-31","MEHWO4"]
["2020-06-06","MEHWO5"]
["2020-06-04","MEHWO6"]
["2020-06-07","MEHWO7"]
["2020-05-17","MEHWO8"]
["2020-07-05","MEHWO9"]
["2020-07-02","MEHWO10"]

{"sheet":"له","index":1,"n_rows":13,"n_cols":29,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["التاريخ","الاسم","رقم",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,18,19,20,21,22,23,24,25]
["2020-05-15","اسر السيد",100,400,200,null,null,null,101,null,null,100]
["2020-05-21","مدحت صالح",200,null,null,null,null,null,100,200,50,1,40,9]
["2020-05-13","LAHO1"]
["2020-05-19","LAHO2"]
["2020-05-27","LAHO3"]
["2020-06-01","LAHO4"]
["2020-06-01","LAHO5"]
["2020-06-17","LAHO6"]
["2020-06-15","LAHO7"]
["2020-06-25","LAHO8"]
["2020-07-13","LAHO9"]
["2020-07-21","LAHO10"]

{"sheet":"تقرير ضبط","index":2,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,3,26,4]]}
["بيان","منه","له","التاريخ من","حتى تاريخ"]
[{"$f":"IF(OR($B2<>\"\",$C2<>\"\"),MAX($A$1:A1)+1,\"\")","v":1},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A1))),\"\")","v":"اسر السيد"},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B2))),\"\")","v":"مدحت صالح"},"2020-05-15","2020-05-22"]
[{"$f":"IF(OR($B3<>\"\",$C3<>\"\"),MAX($A$1:A2)+1,\"\")","v":2},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A2))),\"\")","v":"مدحت صالح"},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B3))),\"\")","v":"LAHO2"}]
[{"$f":"IF(OR($B4<>\"\",$C4<>\"\"),MAX($A$1:A3)+1,\"\")","v":3},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A3))),\"\")","v":"MEHWO1"},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B4))),\"\")","v":""}]
[{"$f":"IF(OR($B5<>\"\",$C5<>\"\"),MAX($A$1:A4)+1,\"\")","v":4},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A4))),\"\")","v":"MEHWO8"},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B5))),\"\")","v":""}]
[{"$f":"IF(OR($B6<>\"\",$C6<>\"\"),MAX($A$1:A5)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B6))),\"\")","v":""}]
[{"$f":"IF(OR($B7<>\"\",$C7<>\"\"),MAX($A$1:A6)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B7))),\"\")","v":""}]
[{"$f":"IF(OR($B8<>\"\",$C8<>\"\"),MAX($A$1:A7)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B8))),\"\")","v":""}]
[{"$f":"IF(OR($B9<>\"\",$C9<>\"\"),MAX($A$1:A8)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B9))),\"\")","v":""}]
[{"$f":"IF(OR($B10<>\"\",$C10<>\"\"),MAX($A$1:A9)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B10))),\"\")","v":""}]
[{"$f":"IF(OR($B11<>\"\",$C11<>\"\"),MAX($A$1:A10)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B11))),\"\")","v":""}]
[{"$f":"IF(OR($B12<>\"\",$C12<>\"\"),MAX($A$1:A11)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B12))),\"\")","v":""}]
[{"$f":"IF(OR($B13<>\"\",$C13<>\"\"),MAX($A$1:A12)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B13))),\"\")","v":""}]
[{"$f":"IF(OR($B14<>\"\",$C14<>\"\"),MAX($A$1:A13)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B14))),\"\")","v":""}]
[{"$f":"IF(OR($B15<>\"\",$C15<>\"\"),MAX($A$1:A14)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B15))),\"\")","v":""}]
[{"$f":"IF(OR($B16<>\"\",$C16<>\"\"),MAX($A$1:A15)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B16))),\"\")","v":""}]
[{"$f":"IF(OR($B17<>\"\",$C17<>\"\"),MAX($A$1:A16)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B17))),\"\")","v":""}]
[{"$f":"IF(OR($B18<>\"\",$C18<>\"\"),MAX($A$1:A17)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A17))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B18))),\"\")","v":""}]
[{"$f":"IF(OR($B19<>\"\",$C19<>\"\"),MAX($A$1:A18)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A18))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B19))),\"\")","v":""}]
[{"$f":"IF(OR($B20<>\"\",$C20<>\"\"),MAX($A$1:A19)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A19))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B20))),\"\")","v":""}]
[{"$f":"IF(OR($B21<>\"\",$C21<>\"\"),MAX($A$1:A20)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A20))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B21))),\"\")","v":""}]
[{"$f":"IF(OR($B22<>\"\",$C22<>\"\"),MAX($A$1:A21)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A21))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B22))),\"\")","v":""}]
[{"$f":"IF(OR($B23<>\"\",$C23<>\"\"),MAX($A$1:A22)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A22))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B23))),\"\")","v":""}]
[{"$f":"IF(OR($B24<>\"\",$C24<>\"\"),MAX($A$1:A23)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A23))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B24))),\"\")","v":""}]
[{"$f":"IF(OR($B25<>\"\",$C25<>\"\"),MAX($A$1:A24)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A24))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B25))),\"\")","v":""}]
[{"$f":"IF(OR($B26<>\"\",$C26<>\"\"),MAX($A$1:A25)+1,\"\")","v":""},{"$f":"IFERROR(INDEX(منه!$B$2:$B$13,SMALL(IF(منه!$A$2:$A$13<>\"\",IF(منه!$A$2:$A$13<=$E$2,IF(منه!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:A25))),\"\")","v":""},{"$f":"IFERROR(INDEX(له!$B$2:$B$13,SMALL(IF(له!$A$2:$A$13<>\"\",IF(له!$A$2:$A$13<=$E$2,IF(له!$A$2:$A$13>=$D$2,ROW($A$2:$A$13)-ROW($A$2)+1))),ROWS($A$1:B26))),\"\")","v":""}]
["الاجمالى",{"$f":"SUM(B2:B25)","v":0},{"$f":"SUM(C2:C25)","v":0},{"$f":"C27-B27","v":0}]