{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["البيانات","الشيت الرئيسي","احمد ","محمد","حسام","علي","خالد"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["رقم العميل ","اسم العميل ","رقم الهاتف","العنوان ","اسم المندوب"]
[1,"احمد ",51613,"الشرقية ","محمود"]
[2,"محمد",131313,"البحيره","حذيفه"]
[3,"حسام",56451565,"قنا","علي"]
[4,"علي",146546515," المنوفية","حذيفه"]
[5,"خالد",1564146,"دمنهور ","علي"]

{"sheet":"الشيت الرئيسي","index":1,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[10,6,10,7],[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($C$9,البيانات!$B$2:$B$320,0)),\"\")","v":5}]
[]
[null,"اسم العميل","خالد",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":1564146}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"دمنهور "},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"علي"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,"2018-06-01",120,570,201,230,541]
[null,2,null,null,null,null,null,0]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,570,null,230]

{"sheet":"احمد ","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,1]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"احمد "},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":51613}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"الشرقية "},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"محمود"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,"2018-01-01",150,5000,100,3500,{"$f":"E15+F15-G15","v":1600}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":5000},null,{"$f":"SUM(G15:G44)","v":3500}]

{"sheet":"محمد","index":3,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,2]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"محمد"},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":131313}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"البحيره"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"حذيفه"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,"00:00:00","JJHHH",500,10,20,{"$f":"E15+F15-G15","v":490}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":500},null,{"$f":"SUM(G15:G44)","v":20}]

{"sheet":"حسام","index":4,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,3]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"حسام"},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":56451565}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"قنا"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"علي"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,null,null,null,null,null,{"$f":"E15+F15-G15","v":0}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":0},null,{"$f":"SUM(G15:G44)","v":0}]

{"sheet":"علي","index":5,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,4]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"علي"},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":146546515}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":" المنوفية"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"حذيفه"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,null,null,null,null,null,{"$f":"E15+F15-G15","v":0}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":0},null,{"$f":"SUM(G15:G44)","v":0}]

{"sheet":"خالد","index":6,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,5]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"خالد"},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":1564146}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"دمنهور "},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"علي"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,"2018-06-01",120,570,201,230,{"$f":"E15+F15-G15","v":541}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":570},null,{"$f":"SUM(G15:G44)","v":230}]