{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["الرئيسية","الاصناف","العملاء","المورين","المبيعات","المشتريات","الفاتورة","فاتورة مشتريات","كشف الحساب","الصندوق","سند صرف","سند قبض","حركة الصنف"],"not_rendered":{"charts":0,"images":1,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الاصناف","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"رقم الصنف","اسم الصنف","الوحدة","سعر التكلفة","سعر البيع","رصيد اول المدة","وارد","منصرف ","الرصيد"]
[null,null,null,null,null,null,null,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":0}]
[null,1,"كتاب","حبه",10,20,50,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":50}]
[null,2,"دفتر","حبه",5,10,100,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":100}]
[null,3,"قلم","حبة",2,5,50,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":50}]
[null,4,"الوان","حبة",20,50,80,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":80},null,null,null,{"$f":"SUM(J:J)","v":320}]
[null,5,"مسطرة","حبة",5,15,10,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":10}]
[null,6,"كراسة","درزن",10,20,10,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":10}]
[null,7,"سبورة","حبة",20,50,20,{"$f":"SUMIF(المشتريات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المشتريات!$G:$G)","v":0},{"$f":"SUMIF(المبيعات!$E:$E,الجدول1[[#This Row],[اسم الصنف]],المبيعات!$G:$G)","v":0},{"$f":"الجدول1[[#This Row],[رصيد اول المدة]]+الجدول1[[#This Row],[وارد]]-الجدول1[[#This Row],[منصرف ]]","v":20}]

{"sheet":"العملاء","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"رقم العميل","اسم العميل","العنوان","رقم الجوال ","رقم الهاتف","رصيد اول المدة","مدين ","دائن","الرصيد"]
[null,1,"احمد غالب",null,553662621,null,1000,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,2,"محمد حسن",null,5654115,null,1500,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,3,"علي سالم",null,24541,null,2000,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,4,"خالد محمد",null,24464,null,3000,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,5,"محسن يوسف",null,2211545,null,2500,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,null," ",null,null,null,null,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIF(المبيعات!$D:$D,Table4[[#This Row],[اسم العميل]],المبيعات!$H:$H)","v":0}]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"المورين","index":3,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"رقم المورد","اسم المورد","العنوان","رقم الجوال ","رقم الهاتف","رصيد اول المدة","مدين ","دائن","الرصيد"]
[null,1,"سالم",null,null,null,500]
[null,2,"علي",null,null,null,1500]
[null,3,"محمد",null,null,null,2000]
[null,4,"احمد",null,null,null,3000]
[null,5,"خالد",null,null,null,1000]
[null,7]
[]
[]
[null,null," "]

{"sheet":"المبيعات","index":4,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,2,0,3],[1,2,1,3]]}
[]
[]
[null,"التاريخ","رقم الفاتورة","اسم العميل","الصنف","السعر","الكمية","الاجمالي"]

{"sheet":"المشتريات","index":5,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"التاريخ","رقم الفاتورة","اسم المورد","الصنف","سعر التكلفة","الكمية","الاجمالي"]

{"sheet":"الفاتورة","index":6,"n_rows":28,"n_cols":29,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,7,25,8],[26,7,26,8],[27,7,27,8],[1,1,1,3],[1,6,1,8],[7,7,7,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[24,2,24,3],[25,5,25,6],[26,5,26,6],[27,5,27,6],[0,1,0,3],[2,1,2,3],[3,1,3,3],[0,6,0,8],[2,6,2,8],[3,6,3,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[0,4,3,5],[4,4,4,5],[16,2,16,3],[17,2,17,3],[18,2,18,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[9,2,9,3],[6,2,6,3],[7,2,7,4],[10,2,10,3]]}
[]
[null,"اسم الشركة /المؤسسة",null,null,null,null,"combany name"]
[null,"العنوان",null,null,null,null,"address"]
[null,"رقم الهاتف",null,null,null,null,"phone"]
[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]
[null,"اسم العميل :",{"$f":"IFERROR(VLOOKUP($C$7,العملاء!$B$4:$C$2000,2,0),\"\")","v":""},null,null,null,"التاريخ",{"$f":"TODAY()","v":"2019-07-25"}]
[]
[null,"م","رقم الصنف",null,"اسم الصنف","السعر","الكمية ","المجموع"]
[null,{"$f":"IF(C11=\"\",\"\",1)","v":""},null,null,{"$f":"IFERROR(VLOOKUP($C11,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C11,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,{"$f":"IFERROR(F11*G11,\"\")","v":""}]
[null,{"$f":"IF(C12=\"\",\"\",B11+1)","v":""},null,null,{"$f":"IFERROR(VLOOKUP($C12,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C12,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,{"$f":"IFERROR(F12*G12,\"\")","v":""}]
[null,{"$f":"IF(C13=\"\",\"\",B12+1)","v":""},null,null,{"$f":"IFERROR(VLOOKUP($C13,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C13,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C14,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C14,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C15,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C15,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C16,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C16,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C17,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C17,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C18,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C18,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C19,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C19,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C20,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C20,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C21,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C21,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C22,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C22,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C23,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C23,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C24,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C24,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,"",null,null,{"$f":"IFERROR(VLOOKUP($C25,الاصناف!$B$4:$F$1927,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($C25,الاصناف!$B$4:$F$1927,5,0),\"\")","v":""},null,""]
[null,null,null,null,null,"الاجمالي",null,{"$f":"SUM(H11:I25)","v":0}]
[null,null,null,null,null,"الخصم"]
[null,null,null,null,null,"الصافي",null,{"$f":"H26-H27","v":0}]

{"sheet":"فاتورة مشتريات","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"كشف الحساب","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الصندوق","index":9,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"التاريخ","رقم السند","البيان","مدين","دائن","الرصيد"]

{"sheet":"سند صرف","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"سند قبض","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"حركة الصنف","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}