{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["أدخال","اليومية"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":41,"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":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Date","Invoice No.","Project Name","Included","Amount","Main Type","Sub Type","Method of Payment","Cheque Date","Remaining Amount","Notes"]
["2019-07-20",null,"حمد","Ok",250,"Operation","مواد","نقدا",0,0]
["2019-07-25",null,"مسعد","Ok",350,"Expenses","نقل وانتقالات","نقدا",0,0,"الرياض"]

{"sheet":"اليومية","index":1,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(اليومية!$J$4:$J$9965)","v":70200},{"$f":"SUM(اليومية!$K$4:$K$9965)","v":3446.1904761904761},{"$f":"SUM(اليومية!$L$4:$L$9965)","v":68923.809523809527}]
[{"$f":"MAX(A4:A8175)","v":{"$error":"#REF!"}},"المشروع الواحد","No.","Date","Invoice No.","Project Name","Contract Value","Contract No.","Included","Amount","Tax","Amount Without Tax","Dr   Cr","Main Type","Sub Type","Method of Payment","Cheque Date","Remaining Amount","Notes"]
[{"$f":"IF(B4=\"\",\"\",COUNTIF(B4:$B$4,B4))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F4=#REF!),1,IF(AND(D4>=#REF!,اليومية!D4<=#REF!)*AND(F4=#REF!),1,\"\"))","v":{"$error":"#REF!"}},1,"2019-04-15",1111,"حمد",null,null,"Ok",15000,{"$f":"IF(اليومية!$N4=\"Salary\",\"\",IF(AND(J4>0,OR(I4=\"ok\")),اليومية!$J4/21,اليومية!$J4*0.05))","v":714.28571428571433},{"$f":"IF(اليومية!$I4=\"Ok\",اليومية!$J4/1.05,اليومية!$J4)","v":14285.714285714284},null,"Income","دفعة مقدمة","نقدا"]
[{"$f":"IF(B5=\"\",\"\",COUNTIF(B$4:$B5,B5))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F5=#REF!),1,IF(AND(D5>=#REF!,اليومية!D5<=#REF!)*AND(F5=#REF!),1,\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(F4=\"<>\",\"\",MAX(C4+1))","v":2},"2019-04-20",2525,"احمد",null,null,null,12000,{"$f":"IF(اليومية!$N5=\"Salary\",\"\",IF(AND(J5>0,OR(I5=\"ok\")),اليومية!$J5/21,اليومية!$J5*0.05))","v":600},{"$f":"IF(اليومية!$I5=\"Ok\",اليومية!$J5/1.05,اليومية!$J5)","v":12000},null,"Income","دفعة مقدمة","شيك نقدا"]
[{"$f":"IF(B6=\"\",\"\",COUNTIF(B$4:$B6,B6))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F6=#REF!),1,IF(AND(D6>=#REF!,اليومية!D6<=#REF!)*AND(F6=#REF!),1,\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(F5=\"<>\",\"\",MAX(C5+1))","v":3},"2019-04-25",7952,"احمد",null,null,"Ok",250,{"$f":"IF(اليومية!$N6=\"Salary\",\"\",IF(AND(J6>0,OR(I6=\"ok\")),اليومية!$J6/21,اليومية!$J6*0.05))","v":11.904761904761905},{"$f":"IF(اليومية!$I6=\"Ok\",اليومية!$J6/1.05,اليومية!$J6)","v":238.09523809523807},null,"Operation","مقاول باطن - محمد","نقدا"]
[{"$f":"IF(B7=\"\",\"\",COUNTIF(B$4:$B7,B7))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F7=#REF!),1,IF(AND(D7>=#REF!,اليومية!D7<=#REF!)*AND(F7=#REF!),1,\"\"))","v":{"$error":"#REF!"}},4,"2019-05-01",8521,"شريف",null,null,null,400,{"$f":"IF(اليومية!$N7=\"Salary\",\"\",IF(AND(J7>0,OR(I7=\"ok\")),اليومية!$J7/21,اليومية!$J7*0.05))","v":20},{"$f":"IF(اليومية!$I7=\"Ok\",اليومية!$J7/1.05,اليومية!$J7)","v":400},null,"Expenses","تليفون وفاكس وبريد","نقدا",null,null," "]
[{"$f":"IF(B8=\"\",\"\",COUNTIF(B$4:$B8,B8))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F8=#REF!),1,IF(AND(D8>=#REF!,اليومية!D8<=#REF!)*AND(F8=#REF!),1,\"\"))","v":{"$error":"#REF!"}},5,"2019-05-15",6521,"ناصر",null,null,"Ok",750,{"$f":"IF(اليومية!$N8=\"Salary\",\"\",IF(AND(J8>0,OR(I8=\"ok\")),اليومية!$J8/21,اليومية!$J8*0.05))","v":35.714285714285715},{"$f":"IF(اليومية!$I8=\"Ok\",اليومية!$J8/1.05,اليومية!$J8)","v":714.28571428571422},null,"Expenses","رسوم عمل وعمال وجوازات ومصالح حكومية","نقدي ومتبقي",null,350,"دلال"]
[{"$f":"IF(B9=\"\",\"\",COUNTIF(B$4:$B9,B9))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F9=#REF!),1,IF(AND(D9>=#REF!,اليومية!D9<=#REF!)*AND(F9=#REF!),1,\"\"))","v":{"$error":"#REF!"}},6,"2019-05-21",1456,"خليفة",null,null,null,5000,{"$f":"IF(اليومية!$N9=\"Salary\",\"\",IF(AND(J9>0,OR(I9=\"ok\")),اليومية!$J9/21,اليومية!$J9*0.05))","v":250},{"$f":"IF(اليومية!$I9=\"Ok\",اليومية!$J9/1.05,اليومية!$J9)","v":5000},null,"Income","دفعة أولى","شيك نقدا"]
[{"$f":"IF(B10=\"\",\"\",COUNTIF(B$4:$B10,B10))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F10=#REF!),1,IF(AND(D10>=#REF!,اليومية!D10<=#REF!)*AND(F10=#REF!),1,\"\"))","v":{"$error":"#REF!"}},7,"2019-06-05",null,"حمد",null,null,null,2500,{"$f":"IF(اليومية!$N10=\"Salary\",\"\",IF(AND(J10>0,OR(I10=\"ok\")),اليومية!$J10/21,اليومية!$J10*0.05))","v":125},{"$f":"IF(اليومية!$I10=\"Ok\",اليومية!$J10/1.05,اليومية!$J10)","v":2500},null,"Income","دفعة أولى","نقدا"]
[{"$f":"IF(B11=\"\",\"\",COUNTIF(B$4:$B11,B11))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F11=#REF!),1,IF(AND(D11>=#REF!,اليومية!D11<=#REF!)*AND(F11=#REF!),1,\"\"))","v":{"$error":"#REF!"}},8,"2019-06-15",123345,"الشرياني",null,null,"Ok",1000,{"$f":"IF(اليومية!$N11=\"Salary\",\"\",IF(AND(J11>0,OR(I11=\"ok\")),اليومية!$J11/21,اليومية!$J11*0.05))","v":47.61904761904762},{"$f":"IF(اليومية!$I11=\"Ok\",اليومية!$J11/1.05,اليومية!$J11)","v":952.38095238095229},null,"Suppliers","شركة النصير","شيك آجل","2019-05-12",1000]
[{"$f":"IF(B12=\"\",\"\",COUNTIF(B$4:$B12,B12))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F12=#REF!),1,IF(AND(D12>=#REF!,اليومية!D12<=#REF!)*AND(F12=#REF!),1,\"\"))","v":{"$error":"#REF!"}},9,"2019-06-20",54545,"يوسف",null,null,"Ok",7700,{"$f":"IF(اليومية!$N12=\"Salary\",\"\",IF(AND(J12>0,OR(I12=\"ok\")),اليومية!$J12/21,اليومية!$J12*0.05))","v":366.66666666666669},{"$f":"IF(اليومية!$I12=\"Ok\",اليومية!$J12/1.05,اليومية!$J12)","v":7333.333333333333},null,"Income","دفعة أولى","نقدا",null,0]
[{"$f":"IF(B13=\"\",\"\",COUNTIF(B$4:$B13,B13))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F13=#REF!),1,IF(AND(D13>=#REF!,اليومية!D13<=#REF!)*AND(F13=#REF!),1,\"\"))","v":{"$error":"#REF!"}},10,"2019-06-20",null,"حسنين",null,null,"Ok",100,{"$f":"IF(اليومية!$N13=\"Salary\",\"\",IF(AND(J13>0,OR(I13=\"ok\")),اليومية!$J13/21,اليومية!$J13*0.05))","v":4.7619047619047619},{"$f":"IF(اليومية!$I13=\"Ok\",اليومية!$J13/1.05,اليومية!$J13)","v":95.238095238095241},null,"Expenses","محروقات","نقدا"]
[{"$f":"IF(B14=\"\",\"\",COUNTIF(B$4:$B14,B14))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F14=#REF!),1,IF(AND(D14>=#REF!,اليومية!D14<=#REF!)*AND(F14=#REF!),1,\"\"))","v":{"$error":"#REF!"}},11,"2019-06-22",null,"ناصر",null,null,"Ok",1500,{"$f":"IF(اليومية!$N14=\"Salary\",\"\",IF(AND(J14>0,OR(I14=\"ok\")),اليومية!$J14/21,اليومية!$J14*0.05))","v":71.428571428571431},{"$f":"IF(اليومية!$I14=\"Ok\",اليومية!$J14/1.05,اليومية!$J14)","v":1428.5714285714284},null,"Operation","مواد","نقدا"]
[{"$f":"IF(B15=\"\",\"\",COUNTIF(B$4:$B15,B15))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F15=#REF!),1,IF(AND(D15>=#REF!,اليومية!D15<=#REF!)*AND(F15=#REF!),1,\"\"))","v":{"$error":"#REF!"}},12,"2019-06-25",null,"يحيى",null,null,"Ok",500,{"$f":"IF(اليومية!$N15=\"Salary\",\"\",IF(AND(J15>0,OR(I15=\"ok\")),اليومية!$J15/21,اليومية!$J15*0.05))","v":23.80952380952381},{"$f":"IF(اليومية!$I15=\"Ok\",اليومية!$J15/1.05,اليومية!$J15)","v":476.19047619047615},null,"Suppliers","شركة النصير","نقدا"]
[{"$f":"IF(B16=\"\",\"\",COUNTIF(B$4:$B16,B16))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F16=#REF!),1,IF(AND(D16>=#REF!,اليومية!D16<=#REF!)*AND(F16=#REF!),1,\"\"))","v":{"$error":"#REF!"}},13,"2019-06-25",null,"ناصر",null,null,null,7500,{"$f":"IF(اليومية!$N16=\"Salary\",\"\",IF(AND(J16>0,OR(I16=\"ok\")),اليومية!$J16/21,اليومية!$J16*0.05))","v":375},{"$f":"IF(اليومية!$I16=\"Ok\",اليومية!$J16/1.05,اليومية!$J16)","v":7500},null,"Income","دفعة مقدمة","نقدا"]
[{"$f":"IF(B17=\"\",\"\",COUNTIF(B$4:$B17,B17))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F17=#REF!),1,IF(AND(D17>=#REF!,اليومية!D17<=#REF!)*AND(F17=#REF!),1,\"\"))","v":{"$error":"#REF!"}},14,"2019-06-25",null,"خليفة",null,null,null,8000,{"$f":"IF(اليومية!$N17=\"Salary\",\"\",IF(AND(J17>0,OR(I17=\"ok\")),اليومية!$J17/21,اليومية!$J17*0.05))","v":400},{"$f":"IF(اليومية!$I17=\"Ok\",اليومية!$J17/1.05,اليومية!$J17)","v":8000},null,"Income","دفعة ثانية","نقدا"]
[{"$f":"IF(B18=\"\",\"\",COUNTIF(B$4:$B18,B18))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F18=#REF!),1,IF(AND(D18>=#REF!,اليومية!D18<=#REF!)*AND(F18=#REF!),1,\"\"))","v":{"$error":"#REF!"}},15,"2019-06-30",null,"ميثاء",null,null,null,500,{"$f":"IF(اليومية!$N18=\"Salary\",\"\",IF(AND(J18>0,OR(I18=\"ok\")),اليومية!$J18/21,اليومية!$J18*0.05))","v":25},{"$f":"IF(اليومية!$I18=\"Ok\",اليومية!$J18/1.05,اليومية!$J18)","v":500},null,"Expenses","نقل وانتقالات","نقدا"]
[{"$f":"IF(B19=\"\",\"\",COUNTIF(B$4:$B19,B19))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F19=#REF!),1,IF(AND(D19>=#REF!,اليومية!D19<=#REF!)*AND(F19=#REF!),1,\"\"))","v":{"$error":"#REF!"}},16,"2019-07-01",null,"حسنين",null,null,null,3500,{"$f":"IF(اليومية!$N19=\"Salary\",\"\",IF(AND(J19>0,OR(I19=\"ok\")),اليومية!$J19/21,اليومية!$J19*0.05))","v":175},{"$f":"IF(اليومية!$I19=\"Ok\",اليومية!$J19/1.05,اليومية!$J19)","v":3500},null,"Income","دفعة مقدمة","شيك نقدا"]
[{"$f":"IF(B20=\"\",\"\",COUNTIF(B$4:$B20,B20))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F20=#REF!),1,IF(AND(D20>=#REF!,اليومية!D20<=#REF!)*AND(F20=#REF!),1,\"\"))","v":{"$error":"#REF!"}},17,"2019-07-05",null,"خليفة",null,null,null,4000,{"$f":"IF(اليومية!$N20=\"Salary\",\"\",IF(AND(J20>0,OR(I20=\"ok\")),اليومية!$J20/21,اليومية!$J20*0.05))","v":200},{"$f":"IF(اليومية!$I20=\"Ok\",اليومية!$J20/1.05,اليومية!$J20)","v":4000},null,"Income","تحت حساب","نقدا"]
[{"$f":"IF(B21=\"\",\"\",COUNTIF(B$4:$B21,B21))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!&#REF!=\"\")*AND(F21=#REF!),1,IF(AND(D21>=#REF!,اليومية!D21<=#REF!)*AND(F21=#REF!),1,\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(F20=\"<>\",\"\",MAX(C20+1))","v":18},null,null,null,null,null,null,null,{"$f":"IF(اليومية!$N21=\"Salary\",\"\",IF(AND(J21>0,OR(I21=\"ok\")),اليومية!$J21/21,اليومية!$J21*0.05))","v":0},{"$f":"IF(اليومية!$I21=\"Ok\",اليومية!$J21/1.05,اليومية!$J21)","v":0}]