{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["فاتورة مبيعات","المشتريات","مردوات مشتريات","العملاء","الموردين","المبيعات","مردوات مبيعات","تكويد العملاء والموردين","تكويد الاصناف","الاصناف"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,8,34,13],[4,12,4,13],[4,8,4,10],[1,7,1,8],[2,7,2,8],[0,7,0,8],[0,9,0,13],[1,9,1,13],[2,9,2,13],[32,8,32,9],[5,8,5,10],[5,12,5,13],[6,8,6,10],[6,12,6,13],[31,8,31,9],[30,8,30,13]]}
[null,null,null,null,null,null,"المبيعات","اسم الشركة :",null,"مصنع دهب الحداد"]
[null,null,null,null,null,null,"المشتريات","العنوان :",null,"منشاة فاضل "]
[null,null,null,null,null,null,"مردوات مبيعات","التليفون :",null,1009070022]
[null,null,null,null,null,null,"مردوات مشتريات"]
[null,null,null,null,null,null,null,{"$f":"IF($M$5=\"مردوات مبيعات\",\"العميل\",IF($M$5=\"مردوات مشتريات\",\"المورد\",IF($M$5=\"المشتريات\",\"المورد\",IF($M$5=\"المبيعات\",\"العميل\",\"\"))))","v":""},null,null,null,"فاتورة /"]
[null,null,null,null,null,null,null,"التاريخ/",{"$f":"TODAY()","v":"2020-07-12"},null,null,"رقم الفاتورة",{"$f":"IF($M$5=\"المبيعات\",MAX(المبيعات!$A$2:$A$1890)+1,IF($M$5=(\"المشتريات\"),MAX(المشتريات!$A$2:$A$1500)+1,IF($M$5=(\"مردوات مبيعات\"),MAX('مردوات مبيعات'!$A$2:$A$1000)+1,MAX('مردوات مشتريات'!$A$2:$A$1500)+1)))","v":2}]
[null,null,null,null,null,null,null,"اليوم /",{"$f":"TEXT(I6,\"dddd\")","v":"الأحد"},null,null,"مدخل البيانات","hh"]
[]
[null,null,"رقم","اسم المورد","اليوم","التاريخ","مدخل البيانات","البيان","الكمية","السعر","الإجمالي","الوحدة","الخصم","المدفوع","سعر الشراء","مج الشراء"]
[null,null,{"$f":"IFERROR(IF(H10=\"\",\"\",$M$6),\"\")","v":""},{"$f":"IFERROR(IF(H10=\"\",\"\",$I$5),\"\")","v":""},{"$f":"IFERROR(IF(H10=\"\",\"\",$I$7),\"\")","v":""},{"$f":"IFERROR(IF(H10=\"\",\"\",$I$6),\"\")","v":""},{"$f":"IFERROR(IF(H10=\"\",\"\",$M$7),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H10,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H10,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},{"$f":"IFERROR(I10*J10,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H10,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H10,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H10,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(I10*O10,\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(H11=\"\",\"\",$M$6),\"\")","v":""},{"$f":"IFERROR(IF(H11=\"\",\"\",$I$5),\"\")","v":""},{"$f":"IFERROR(IF(H11=\"\",\"\",$I$7),\"\")","v":""},{"$f":"IFERROR(IF(H11=\"\",\"\",$I$6),\"\")","v":""},{"$f":"IFERROR(IF(H11=\"\",\"\",$M$7),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H11,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H11,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},{"$f":"IFERROR(I11*J11,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H11,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H11,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H11,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H12,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H12,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H12,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H12,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H12,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H13,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H13,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H13,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H13,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H13,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H14,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H14,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H14,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H14,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H14,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H15,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H15,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H15,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H15,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H15,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H16,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H16,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H16,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H16,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H16,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H17,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H17,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H17,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H17,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H17,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H18,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H18,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H18,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H18,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H18,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H19,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H19,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H19,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H19,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H19,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H20,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H20,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H20,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H20,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H20,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H21,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H21,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H21,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H21,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H21,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H22,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H22,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H22,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H22,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H22,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H23,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H23,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H23,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H23,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H23,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H24,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H24,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H24,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H24,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H24,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H25,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H25,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H25,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H25,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H25,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H26,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H26,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H26,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H26,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H26,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H27,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H27,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H27,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H27,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H27,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H28,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H28,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H28,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H28,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H28,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H29,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H29,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H29,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H29,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H29,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[null,null,"","","","","",null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H30,الاصناف!$B$2:$E$2000,3,FALSE),VLOOKUP(H30,الاصناف!$B$2:$E$2000,4,FALSE)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(H30,الاصناف!$B$2:$E$3000,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF($H$5=\"المورد\",VLOOKUP(H30,الاصناف!$B$2:$E$2000,4,FALSE),VLOOKUP(H30,الاصناف!$B$2:$E$2000,3,FALSE)),\"\")","v":""},""]
[]
[null,null,null,null,null,null,null,null,"قيمة الفاتورة",null,"قيمة الخصم","اجمالي الفاتورة","المدفوع","الرصيد"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(K10:K30)","v":0},null,{"$f":"SUM(M10:M30)","v":0},{"$f":"I33-K33","v":0},{"$f":"SUM(N10:N30)","v":0},{"$f":"L33-M33","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"NoToTxt2(N33,\"جنيه\",\"قرش\")","v":"صفر"}]

{"sheet":"المشتريات","index":1,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["رقم","اسم المورد","اليوم","التاريخ","مدخل البيانات","البيان","الكمية مشتريات","السعر","مج المشتريات","الوحدة","الخصم","المدفوع","سعر الشراء","مج الشراء"]
[1,"يوسف خالد","الجمعة","2020-07-10","hh","طوب طفلي 20*10*6",10,400,4000,1000,200,800,430,4300]
[2,"يوسف خالد","الأحد","2020-07-12","hh","طوب طفلي 20*10*6",1,400,400,1000,null,null,430,430]

{"sheet":"مردوات مشتريات","index":2,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["رقم","اسم العميل","اليوم","التاريخ","مدخل البيانات","البيان","الكمية مرودات مشتريات","السعر","مج مردوات مشتريات","الوحدة","الخصم","المدفوع"]
[1,"يوسف خالد","الجمعة","2020-07-10","hh","طوب طفلي 20*10*6",2,400,800,1000,null,null,430,860]

{"sheet":"العملاء","index":3,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["م","العميل ","العنوان ","التليفون "]
[null,"محمداحمد "]
[null,"إبراهيم عدنان"]
[null,"السيد محمود"]

{"sheet":"الموردين","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["م"," المورد ","العنوان ","التليفون "]
[null,"يوسف خالد"]
[null,"زكريا احمد"]
[null,"يحيي الصاوي"]

{"sheet":"المبيعات","index":5,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["رقم","اسم العميل","اليوم","التاريخ","مدخل البيانات","البيان","الكمية مبيعات","السعر","مج المبيعات","الوحدة","الخصم","المدفوع","سعر الشراء","مج المشتريات 1"]
[1,"محمداحمد ","الجمعة","2020-07-10","hh","طوب طفلي 20*10*6",2,430,860,1000,60,100,400,800]
[2,"إبراهيم عدنان","الجمعة","2020-07-10","hh","طوب طفلي 20*10*6",3,430,1290,1000,90,100,400,1200]

{"sheet":"مردوات مبيعات","index":6,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["رقم","اسم العميل","اليوم","التاريخ","مدخل البيانات","البيان","الكمية مرودات مبيعات","السعر","مج المبيعات مردوات مبيعات","الوحدة","الخصم","المدفوع","سعر الشراء","مج الشراء"]
[1,"محمداحمد ","الجمعة","2020-07-10","hh","طوب طفلي 20*10*6",1,430,430,1000,null,null,400,400]
[2,"إبراهيم عدنان","الجمعة","2020-07-10","hh","طوب طفلي 20*10*6",1,430,430,1000,null,null,400,400]

{"sheet":"تكويد العملاء والموردين","index":7,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
["العملاء"]
["الموردين"]
[null,"الموردين"]
[]
["اسم العميل ","العنوان ","التليفون "]

{"sheet":"تكويد الاصناف","index":8,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["اسم الصنف","الوحدة","سعر الشراء","سعر البيع","ملاحظات"]

{"sheet":"الاصناف","index":9,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,"اسم الصنف","الوحدة","سعر الشراء","سعر البيع","ملاحظات"]
[null,"طوب طفلي 20*10*6",1000,400,430]