{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet3","ezn"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":7,"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":"Sheet1","index":0,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,4,4,6]]}
[null,null,null,null,{"$f":"C6","v":"اسم العميل "}]
[null,null,null,null,"رومانى جمله"]
[]
[null,null,null,null,null,null,{"$f":"IF(E2=\"\",SUM(G7:G15000),SUMIF(C7:H15000,E2,G7:G15000))","v":2500},{"$f":"IF(E2=\"\",SUM(H7:H15000),SUMIF(C7:H15000,E2,H7:H15000))","v":1100},{"$f":"G4-H4","v":1400}]
[null,null,null,null,"شـراء",null,null,"سـداد"]
["م","التاريخ","اسم العميل ","بيان","وحده","سعر","قيمه","دائن","رصيد"]
[1,"2018-03-14T15:40:56","رومانى جمله",45,1,2500,2500,500,{"$f":"G7-H7","v":2000}]
[2,"2018-03-16T15:42:41","شيبسى","دفعه",null,null,null,1000,{"$f":"IF($E$2=\"\",SUM($G$7:G8)-SUM($H$7:H8),SUMIF($C$7:H8,E2,$G$7:G8)-SUMIF($C$7:H8,E2,$H$7:H8))","v":2000}]
[3,"2018-03-14T15:43:39","رومانى جمله","دفعه",null,null,null,300,{"$f":"IF($E$2=\"\",SUM($G$7:G9)-SUM($H$7:H9),SUMIF($C$7:H9,E3,$G$7:G9)-SUMIF($C$7:H9,E3,$H$7:H9))","v":0}]
[3,"2018-03-14T15:43:39","رومانى جمله","دفعه",null,null,null,300,{"$f":"IF($E$2=\"\",SUM($G$7:G10)-SUM($H$7:H10),SUMIF($C$7:H10,E4,$G$7:G10)-SUMIF($C$7:H10,E4,$H$7:H10))","v":0}]
[4,"2018-03-19T14:26:50","شيبسى",141,1,2500,2500,null,{"$f":"IF($E$2=\"\",SUM($G$7:G11)-SUM($H$7:H11),SUMIF($C$7:H11,E5,$G$7:G11)-SUMIF($C$7:H11,E5,$H$7:H11))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G12)-SUM($H$7:H12),SUMIF($C$7:H12,E6,$G$7:G12)-SUMIF($C$7:H12,E6,$H$7:H12))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G13)-SUM($H$7:H13),SUMIF($C$7:H13,E7,$G$7:G13)-SUMIF($C$7:H13,E7,$H$7:H13))","v":2000}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G14)-SUM($H$7:H14),SUMIF($C$7:H14,E8,$G$7:G14)-SUMIF($C$7:H14,E8,$H$7:H14))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G15)-SUM($H$7:H15),SUMIF($C$7:H15,E9,$G$7:G15)-SUMIF($C$7:H15,E9,$H$7:H15))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G16)-SUM($H$7:H16),SUMIF($C$7:H16,E10,$G$7:G16)-SUMIF($C$7:H16,E10,$H$7:H16))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G17)-SUM($H$7:H17),SUMIF($C$7:H17,E11,$G$7:G17)-SUMIF($C$7:H17,E11,$H$7:H17))","v":2000}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G18)-SUM($H$7:H18),SUMIF($C$7:H18,E12,$G$7:G18)-SUMIF($C$7:H18,E12,$H$7:H18))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G19)-SUM($H$7:H19),SUMIF($C$7:H19,E13,$G$7:G19)-SUMIF($C$7:H19,E13,$H$7:H19))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G20)-SUM($H$7:H20),SUMIF($C$7:H20,E14,$G$7:G20)-SUMIF($C$7:H20,E14,$H$7:H20))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G21)-SUM($H$7:H21),SUMIF($C$7:H21,E15,$G$7:G21)-SUMIF($C$7:H21,E15,$H$7:H21))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G22)-SUM($H$7:H22),SUMIF($C$7:H22,E16,$G$7:G22)-SUMIF($C$7:H22,E16,$H$7:H22))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G23)-SUM($H$7:H23),SUMIF($C$7:H23,E17,$G$7:G23)-SUMIF($C$7:H23,E17,$H$7:H23))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G24)-SUM($H$7:H24),SUMIF($C$7:H24,E18,$G$7:G24)-SUMIF($C$7:H24,E18,$H$7:H24))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G25)-SUM($H$7:H25),SUMIF($C$7:H25,E19,$G$7:G25)-SUMIF($C$7:H25,E19,$H$7:H25))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G26)-SUM($H$7:H26),SUMIF($C$7:H26,E20,$G$7:G26)-SUMIF($C$7:H26,E20,$H$7:H26))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G27)-SUM($H$7:H27),SUMIF($C$7:H27,E21,$G$7:G27)-SUMIF($C$7:H27,E21,$H$7:H27))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$2=\"\",SUM($G$7:G28)-SUM($H$7:H28),SUMIF($C$7:H28,E22,$G$7:G28)-SUMIF($C$7:H28,E22,$H$7:H28))","v":0}]

{"sheet":"Sheet3","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["م","اسم العميل","العنوان","رقم التليفون"]
[1,"رومانى جمله"]
[2,"شيبسى"]

{"sheet":"ezn","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,2,29,3],[30,2,30,3],[31,2,31,3],[29,4,29,5],[30,4,30,5],[31,4,31,5]]}
[null,null,null,null,{"$f":"NOW()","v":"2018-03-19T14:33:29.280"}]
[null,"أسم الـمـورد","رومانى جمله"]
[]
["الصنف","الكرتونه","الوحده","سعر الكرتونه","القيمه","سعر الوحده"]
[null,null,null,null,{"$f":"IF(AND(B5>0,D5>0),B5*D5,\" \")","v":" "},{"$f":"IFERROR(D5/(C5),\" \")","v":" "}]
[null,null,null,null,{"$f":"IF(AND(B6>0,D6>0),B6*D6,\" \")","v":" "},{"$f":"IFERROR(D6/(C6),\" \")","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," "," "]
["ليسل",1,25,10,10,0.4]
[]
[null,null,"عــدد الأصــنــاف",null,{"$f":"COUNTA(A5:A28)","v":1}]
[null,null,"عــدد الــكـراتـيـن",null,{"$f":"SUM(B5:B28)","v":1}]
[null,null,"الأجــمــالـى",null,{"$f":"SUM(E5:E28)","v":10}]