{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ورقة6","الاكواد","فاتورة_مبيعات","المبيعات","سداد_ العملاء","كشف حساب عميل ","المشتريات","الخزينة","ورقة4","ورقة5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"ورقة6","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الاكواد","index":1,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"اسم الصنف","الوحدة",null,"رقم العميل","اسم العميل","تصنيف العميل","العنوان","التليفون","اجمالى المديونية"]
[null,"خوخ فلوردا","بالكيلو",null,{"$f":"IF(F2<>\"\",1,\"\")","v":1},"رضا محمد بسيونى الخطيب","A","خربتا","01273263994",100]
[null,"خوخ ديزرت","بالكيلو",null,{"$f":"IF(F3<>\"\",1+E2,\"\")","v":2},"محمد مسموع","AA","وادى","0120000000",200]
[null,"موز بلدى","سباطة"]
[null,"بطيخ","بالحبة"]
[null,"اناناس","بالحبة"]

{"sheet":"فاتورة_مبيعات","index":2,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,4,28,12],[25,4,25,8],[4,5,4,11],[6,4,6,5],[6,8,6,9],[12,4,12,5],[10,4,10,5],[9,4,9,5],[11,4,11,5],[9,6,9,12],[10,6,10,12],[11,6,11,12],[12,6,12,12],[1,4,1,5],[8,4,8,5],[2,9,2,10],[2,11,2,12],[0,4,0,12],[1,6,1,12],[2,4,2,8],[8,6,8,12]]}
[null,null,null,null,"مــحــــلات الامـــــــــــــــــــــــــــــــــل"]
[null,null,null,null,"العنوان ",null,"وادى النطرون  بوار لفظ الجلالة"]
[null,null,null,null,"تليفون المحل",null,null,null,null,"01090596181",null,"01273263990"]
[]
[null,null,null,null,null,"فــــــاتــــــــــــــورة مــــبــــــــيـــــــــــــــــعــــــات  "]
[]
[null,null,null,null,"رقم الفاتورة ",null,null,"نوع الفاتورة ",null,null,null,"التاريخ","2020-04-30"]
[]
[null,null,null,null,"رقــــم  العميل",null,{"$f":"IF(G10=\"\",\"\",INDEX(الاكواد!$E:$E,MATCH($G10,الاكواد!$F:$F,0)))","v":1}]
[null,null,null,null,"اســــم العميل",null,"رضا محمد بسيونى الخطيب"]
[null,null,null,null,"تصنيف العميل",null,{"$f":"IF(G10=\"\",\"\",INDEX(الاكواد!$G:$G,MATCH($G10,الاكواد!$F:$F,0)))","v":"A"}]
[null,null,null,null,"تليفون العميل",null,{"$f":"IF(G10=\"\",\"\",INDEX(الاكواد!$I:$I,MATCH($G10,الاكواد!$F:$F,0)))","v":"01273263994"}]
[null,null,null,null,"عـنوان العميل",null,{"$f":"IF(G10=\"\",\"\",INDEX(الاكواد!$H:$H,MATCH($G10,الاكواد!$F:$F,0)))","v":"خربتا"}]
[]
[null,"رقــــم  العميل","اســــم العميل","التاريخ","م","الصنف","الوحدة","الكمية","السعر","القيمة","خصم الفاتورة","رهن بالفاتورة","صافى الفاتورة "]
[null,{"$f":"IF(F16<>\"\",$G$9,\"\")","v":""},{"$f":"IF(F16<>\"\",$G$10,\"\")","v":""},{"$f":"IF(F16<>\"\",$M$7,\"\")","v":""},{"$f":"IF(F16=\"\",\"\",MAX($D$15:D15)+1)","v":""},null,{"$f":"IF($F16=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F16,[1]الاكواد!$B:$B,0)))","v":""},null,null,{"$f":"IF(F16<>\"\",I16*H16,\"\")","v":""},null,null,{"$f":"IF(F16<>\"\",J16-K16+L16,\"\")","v":""}]
[null,{"$f":"IF(F17<>\"\",$G$9,\"\")","v":""},{"$f":"IF(G17<>\"\",$G$10,\"\")","v":""},{"$f":"IF(F17<>\"\",$M$7,\"\")","v":""},{"$f":"IF(F17=\"\",\"\",MAX($E$15:E16)+1)","v":""},null,{"$f":"IF($F17=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F17,[1]الاكواد!$B:$B,0)))","v":""},null,null,{"$f":"IF(F17<>\"\",I17*H17,\"\")","v":""},null,null,{"$f":"IF(F17<>\"\",J17-K17+L17,\"\")","v":""}]
[null,"","","",{"$f":"IF(F18=\"\",\"\",MAX($E$15:E17)+1)","v":""},null,{"$f":"IF($F18=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F18,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,"","","",{"$f":"IF(F19=\"\",\"\",MAX($E$15:E18)+1)","v":""},null,{"$f":"IF($F19=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F19,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,"","","",{"$f":"IF(F20=\"\",\"\",MAX($E$15:E19)+1)","v":""},null,{"$f":"IF($F20=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F20,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,"","","",{"$f":"IF(F21=\"\",\"\",MAX($E$15:E20)+1)","v":""},null,{"$f":"IF($F21=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F21,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,"","","",{"$f":"IF(F22=\"\",\"\",MAX($E$15:E21)+1)","v":""},null,{"$f":"IF($F22=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F22,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,"","","",{"$f":"IF(F23=\"\",\"\",MAX($E$15:E22)+1)","v":""},null,{"$f":"IF($F23=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F23,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,"","","",{"$f":"IF(F24=\"\",\"\",MAX($E$15:E23)+1)","v":""},null,{"$f":"IF($F24=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F24,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,"","","",{"$f":"IF(F25=\"\",\"\",MAX($E$15:E24)+1)","v":""},null,{"$f":"IF($F25=\"\",\"\",INDEX([1]الاكواد!$C:$C,MATCH($F25,[1]الاكواد!$B:$B,0)))","v":""},null,null,"",null,null,""]
[null,null,null,null,"اجمالى الفاتورة",null,null,null,null,{"$f":"SUM(J16:J25)","v":0},{"$f":"SUM(K16:K25)","v":0},0,0]
[null,null,null,null,"استلمت جميع الاصناف بالفاتورة الموضحة أعلاه واصبحت قيمتها فى ذمتى وأمانتى لحين انتهاء السداد لها "]
[]
[]
[]
[null,null,null,null,null,"المستلم ",null,null,"المحاسب",null,null,"مدير المحل"]

{"sheet":"المبيعات","index":3,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[1,"رقــــم  العميل","اســــم العميل","التاريخ","م","الصنف","الوحدة","الكمية","السعر","القيمة","خصم الفاتورة","رهن بالفاتورة","صافى الفاتورة "]
[null,1,"رضا محمد بسيونى الخطيب","2020-04-30",1,"خوخ ديزرت","بالكيلو",null,null,0,null,null,0]
[null,1,"رضا محمد بسيونى الخطيب","2020-04-30",2,"خوخ ديزرت","بالكيلو",null,null,0,null,null,0]
[null,1,"رضا محمد بسيونى الخطيب","2020-04-30",3,"خوخ ديزرت","بالكيلو",null,null,0,null,null,0]
[null,1,"رضا محمد بسيونى الخطيب","2020-04-30",4,"خوخ ديزرت","بالكيلو",null,null,0,null,null,0]
[null,1,"رضا محمد بسيونى الخطيب","2020-04-30",5,"خوخ ديزرت","بالكيلو",null,null,0,null,null,0]
[null,1,"رضا محمد بسيونى الخطيب","2020-04-30",6,"خوخ ديزرت","بالكيلو",null,null,0,null,null,0]

{"sheet":"سداد_ العملاء","index":4,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,3,10,4],[10,5,10,6],[12,7,12,8],[13,7,13,8],[9,3,9,4],[9,5,9,6],[18,3,18,5],[18,7,18,8],[19,3,19,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[5,3,5,5],[5,6,5,7],[7,3,7,4],[8,3,8,4],[7,5,7,6],[8,5,8,6],[7,7,7,8],[1,3,1,8],[2,3,2,4],[2,5,2,8],[3,3,3,5],[3,6,3,8]]}
[]
[null,null,null,"مــحــــلات الامـــــــــــــــــــــــــــــــــل"]
[null,null,null,"العنوان ",null,"وادى النطرون  بجوار لفظ الجلالة"]
[null,null,null,"تليفون المحل",null,null,"01273263990"]
[]
[null,null,null,"فاتورة مبيعات  ",null,null,"التاريخ"]
[]
[null,null,null,"رقــــم  العميل",null,{"$f":"IF($F9=\"\",\"\",INDEX(الاكواد!$E:$E,MATCH($F9,الاكواد!$F:$F,0)))","v":2},null,"مديونية العميل "]
[null,null,null,"اســــم العميل",null,"محمد مسموع",null,"اجمالى فواتير "]
[null,null,null,"تصنيف العميل",null,{"$f":"IF(F9=\"\",\"\",INDEX(الاكواد!$G:$G,MATCH($F9,الاكواد!$F:$F,0)))","v":"AA"},null,"اجمالى المسدد"]
[null,null,null,"تليفون العميل",null,{"$f":"IF(F9=\"\",\"\",INDEX(الاكواد!$I:$I,MATCH($F9,الاكواد!$F:$F,0)))","v":"0120000000"},null,"المتبقى عليه"]
[]
[{"$f":"+D8","v":"رقــــم  العميل"},{"$f":"+D9","v":"اســــم العميل"},{"$f":"+G6","v":"التاريخ"},"م","طريقة الدفع","رقم الاذن","المبلغ","الملاحظات"]
[{"$f":"+$F$8","v":2},{"$f":"+$F$9","v":"محمد مسموع"},{"$f":"+$I$6","v":0},1]
[{"$f":"+$F$8","v":2},{"$f":"+$F$9","v":"محمد مسموع"},{"$f":"+$I$6","v":0},2]
[2,"محمد مسموع",0,3]
[2,"محمد مسموع",0,4]
[2,"محمد مسموع",0,5]
[null,null,null,"الاجمالى المسدد",null,null,{"$f":"SUM(G14:G18)","v":0}]
[null,null,null,"تم استلام المبلغ الموضح اعلاه "]
[]
[null,null,null,null,"المستلم ",null,"المحاسب",null,"يعتمد"]

{"sheet":"كشف حساب عميل ","index":5,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,3,5,4],[3,1,3,2],[4,1,4,2],[5,1,5,2],[2,6,2,7],[2,1,2,5],[3,3,3,4],[4,3,4,4]]}
[]
[]
[null,"كشف حساب عميل ومورد ",null,null,null,null,"مديونية العميل "]
[null,"اســــم العميل",null,"رضا محمد بسيونى الخطيب",null,null,"اجمالى فواتير "]
[null,"تصنيف العميل",null,{"$f":"IF(D4=\"\",\"\",INDEX(الاكواد!$G:$G,MATCH($D4,الاكواد!$F:$F,0)))","v":"A"},null,null,"اجمالى المسدد"]
[null,"تليفون العميل",null,{"$f":"IF(D4=\"\",\"\",INDEX(الاكواد!$I:$I,MATCH($D4,الاكواد!$F:$F,0)))","v":"01273263994"},null,null,"المتبقى عليه"]
[]
[]
[]
[]
[]
[]
[null,"التاريخ","رقم الاذن ","الصنف","الكمية","السعر","مدين","دائن","رصيد"]

{"sheet":"المشتريات","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الخزينة","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ال"]

{"sheet":"ورقة4","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"ورقة5","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}