{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الاكواد","INV","SLS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"اسم الصنف","الوحدة","السعر","رقم العميل","اسم العميل","تصنيف العميل","العنوان","التليفون","اجمالى المديونية"]
[null,"خوخ فلوردا","بالكيلو",20,{"$f":"IF(F2<>\"\",1,\"\")","v":1},"رضا محمد بسيونى الخطيب","A","خربتا","01273263994",100]
[null,"خوخ ديزرت","بالكيلو",21,{"$f":"IF(F3<>\"\",1+E2,\"\")","v":2},"محمد مسموع","AA","وادى","0120000000",200]
[null,"موز بلدى","سباطة",40]
[null,"بطيخ","بالحبة",25]
[null,"اناناس","بالحبة",45]

{"sheet":"INV","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,1],[2,0,2,1],[6,0,6,1],[1,2,1,5],[2,2,2,3],[2,4,2,5],[6,2,6,5],[28,0,28,1],[10,0,10,1],[8,0,8,1],[7,0,7,1],[7,2,7,5],[23,0,26,3],[10,2,10,5],[8,2,8,5],[9,2,9,5],[9,0,9,1]]}
["فاتورة مبيعات  مــحــــلات الامـــــــــــــــــــــــــــــــــل",null,null,null,null,null,{"$f":"MAX(SLS!$C:$C)+1","v":2}]
["العنوان ",null,"وادى النطرون  بوار لفظ الجلالة"]
["تليفون المحل",null,"01090596181",null,"01273263990"]
[]
["رقم الفاتورة ",2,null,null,null,"2020-11-01"]
[]
["رقــــم  العميل",null,{"$f":"IFERROR(INDEX(الاكواد!$E$2:$E$300,MATCH($C8,الاكواد!$F$2:$F$300,0)),\"\")","v":2}]
["اســــم العميل",null,"محمد مسموع"]
["تصنيف العميل",null,{"$f":"IF(C8=\"\",\"\",INDEX(الاكواد!$G:$G,MATCH($C8,الاكواد!$F:$F,0)))","v":"AA"}]
["تليفون العميل",null,{"$f":"IF(C8=\"\",\"\",INDEX(الاكواد!$I:$I,MATCH($C8,الاكواد!$F:$F,0)))","v":"0120000000"}]
["عـنوان العميل",null,{"$f":"IF(C8=\"\",\"\",INDEX(الاكواد!$H:$H,MATCH($C8,الاكواد!$F:$F,0)))","v":"وادى"}]
[]
["م","الصنف","الوحدة","الكمية","السعر","القيمة"]
[1,null,{"$f":"IFERROR(VLOOKUP($B14,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B14,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},{"$f":"IFERROR(D14*E14,\"\")","v":""}]
[2,null,{"$f":"IFERROR(VLOOKUP($B15,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B15,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},{"$f":"IFERROR(D15*E15,\"\")","v":""}]
[3,null,{"$f":"IFERROR(VLOOKUP($B16,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B16,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
[4,null,{"$f":"IFERROR(VLOOKUP($B17,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B17,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
[5,null,{"$f":"IFERROR(VLOOKUP($B18,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B18,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
[6,null,{"$f":"IFERROR(VLOOKUP($B19,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B19,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
[7,null,{"$f":"IFERROR(VLOOKUP($B20,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B20,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
[8,null,{"$f":"IFERROR(VLOOKUP($B21,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B21,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
[9,null,{"$f":"IFERROR(VLOOKUP($B22,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B22,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
[10,null,{"$f":"IFERROR(VLOOKUP($B23,الاكواد!$B$2:$C$600,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP($B23,الاكواد!$B$2:$D$600,3,0),\"\")","v":""},""]
["استلمت جميع الاصناف بالفاتورة الموضحة أعلاه واصبحت قيمتها فى ذمتى وأمانتى لحين انتهاء السداد لها ",null,null,null,"اجمالى الفاتورة",{"$f":"SUM(F14:F23)","v":0}]
[null,null,null,null,"خصم الفاتورة"]
[null,null,null,null,"رهن بالفاتورة"]
[null,null,null,null,"صافى الفاتورة ",{"$f":"+F24-F25-F26","v":0}]
[]
["المستلم ",null,null,null,"المحاسب","مدير المحل"]

{"sheet":"SLS","index":2,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","تاريخ الفاتورة","رقــــم  العميل","اســــم العميل","مسلسل","الصنف","الوحدة","الكمية","السعر","القيمة"]
[1,"2020-11-01",1,"رضا محمد بسيونى الخطيب",1,"خوخ فلوردا","بالكيلو",10,20,200]
[1,"2020-11-01",1,"رضا محمد بسيونى الخطيب",2,"موز بلدى","سباطة",10,40,400]
[1,"2020-11-01",1,"رضا محمد بسيونى الخطيب",3,"بطيخ","بالحبة",20,25,500]