{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tarhil","Mab","Moush"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":10,"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":"Tarhil","index":0,"n_rows":214,"n_cols":27,"rows_kept":214,"cut":false,"hidden":false,"merged":[[208,9,208,10],[209,9,209,10],[210,9,210,10],[211,9,211,10],[213,3,213,9],[1,12,5,16],[207,9,207,10],[1,3,1,5],[1,10,1,11],[2,3,2,5],[2,10,2,11],[3,3,3,5],[4,3,4,5],[4,10,4,11],[5,10,5,11],[6,5,6,6],[206,9,206,10]]}
[]
[null,null,null,{"$f":"'[2]البيانات الاساسية'!E5","v":"العروسة للمفروشات "},null,null,null,null,null,"تاريخ الفاتورة ","2020-02-15",null,"اريد عند اختيار نوع العملية يقوم بترحيل البيانات الي الشيت الخاص به مثلا لو نوع العلمية مشتريات يتم الترحيل للمشتريات لو مبيعات يتم الترحيل للمبيعات "]
[null,null,null,{"$f":"'[2]البيانات الاساسية'!E6","v":"بيع بطاطين ومفروشات وأدوات العروسة"},null,null,null,null,null,"كود العميل ",200]
[null,null,null,{"$f":"'[2]البيانات الاساسية'!E8","v":"01022911917"},null,null,null,null,null,"نوع العملية ","المشتريات",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"قائمة نوع العملية "]
[null,null,null,{"$f":"'[2]البيانات الاساسية'!E7","v":"بردين - الزقازيق -شرقية"},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,"المبلغ المقدم ",500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"المشتريات"]
[null,null,null,null,null,"فاتورة  مبيعات رقم ",null,15,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,100,"المبيعات",{"$f":"IFERROR(IF($B10=\"\",\"\",$K$2),\" \")","v":"2020-02-15"},{"$f":"IF($B10=\"\",\"\",$H$7)","v":15},null,{"$f":"IF($B10=\"\",\"\",$K$3)","v":200},{"$f":"IF($B10=\"\",\"\",$K$5)","v":"هشام"},{"$f":"IF($B10=\"\",\"\",$B$10)","v":100},null,null,null,{"$f":"K10*L10","v":0}]
[null,200,null,"2020-02-15",15,null,200,"هشام",{"$f":"IF($B11=\"\",\"\",$B$10)","v":100},null,null,null,{"$f":"K11*L11","v":0}]
[null,300,null,"2020-02-15",15,null,200,"هشام",100,null,null,null,0]
[null,400,null,"2020-02-15",15,null,200,"هشام",100,null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,{"$f":"IFERROR(IF($B74=\"\",\"\",$K$2),\" \")","v":""},{"$f":"IF($B74=\"\",\"\",$H$7)","v":""},null,{"$f":"IF($B74=\"\",\"\",$K$3)","v":""},{"$f":"IF($B74=\"\",\"\",$K$5)","v":""},"",null,null,null,0]
[null,null,null,"","",null,"","",{"$f":"IF($B75=\"\",\"\",$B$10)","v":""},null,null,null,{"$f":"K75*L75","v":0}]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,{"$f":"IFERROR(IF($B138=\"\",\"\",$K$2),\" \")","v":""},{"$f":"IF($B138=\"\",\"\",$H$7)","v":""},null,{"$f":"IF($B138=\"\",\"\",$K$3)","v":""},{"$f":"IF($B138=\"\",\"\",$K$5)","v":""},"",null,null,null,0]
[null,null,null,"","",null,"","",{"$f":"IF($B139=\"\",\"\",$B$10)","v":""},null,null,null,{"$f":"K139*L139","v":0}]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,"","",null,"","","",null,null,null,0]
[null,null,null,{"$f":"IFERROR(IF($B202=\"\",\"\",$K$2),\" \")","v":""},{"$f":"IF($B202=\"\",\"\",$H$7)","v":""},null,{"$f":"IF($B202=\"\",\"\",$K$3)","v":""},{"$f":"IF($B202=\"\",\"\",$K$5)","v":""},"",null,null,null,0]
[null,null,null,"","",null,"","",{"$f":"IF($B203=\"\",\"\",$B$10)","v":""},null,null,null,{"$f":"K203*L203","v":0}]
[null,null,null,"","",null,"","",{"$f":"IF($B204=\"\",\"\",$B$10)","v":""},null,null,null,{"$f":"K204*L204","v":0}]
[null,null,null,"","",null,"","",{"$f":"IF($B205=\"\",\"\",$B$10)","v":""},null,null,null,{"$f":"K205*L205","v":0}]
[null,null,{"$f":"IF($B206=\"\",\"\",$I$4)","v":""},"","",{"$f":"IF(#REF!=\"\",\"\",$I$6)","v":{"$error":"#REF!"}},"",{"$f":"IF(#REF!=\"\",\"\",$K$9)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",$M$9)","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(#REF!,[3]الاكواد!$B$3:$C$55,2,FALSE),\"\")","v":""},null,{"$f":"SUM(N109:N205)","v":0},{"$f":"SUM(M10:M205)","v":0}]
[null,null,1,"",1,null,"",1,1,"جملة الفاتورة ",null,{"$f":"L206","v":0},{"$f":"M206","v":0}]
[null,null,1,"",1,null,"",1,1,"قيمة الخصم %",null,null,0.05]
[null,null,1,"",1,null,"",1,1,"قيمة الخصم ",null,{"$f":"L207*L208","v":0},{"$f":"M208*M207","v":0}]
[null,null,1,"",1,null,"",1,1,"صافي الفاتورة ",null,{"$f":"L207-L209","v":0},{"$f":"M207-M209","v":0}]
[null,null,1,"",1,null,"",1,1,"المدفوع",null,null,1]
[null,null,1,"",1,null,"",1,1,"الباقي ",null,{"$f":"L210-L211","v":0},{"$f":"M210-M211","v":-1}]
[]
[null,null,null,"شكرا لزيارتنا "]

{"sheet":"Mab","index":1,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,8,0,9]]}
[null,"صنف1",null,{"$f":"IF(B1<>\"\",VLOOKUP(B1,[2]المخزون!B3:K309,10,0),\"\")","v":1485},null,null,{"$f":"IF(B1<>\"\",VLOOKUP(B1,[2]المخزون!B3:K309,10,0),\"\")","v":1485},"طه",29]
[]
["كود الصنف","اسم الحساب","التاريخ","رقم الفاتوره","رقم الدفتر","كود العميل","اسم العميل","كود الصنف","اسم الصنف","الكميه","سعر البيع","الجملة"]

{"sheet":"Moush","index":2,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,8,0,9]]}
[{"$f":"SUMIF([2]المخزون!B$1:B$65536,B1,[2]المخزون!A$1:A$65536)","v":{"$error":"#VALUE!"}},"صنف1",null,{"$f":"IF(B1<>\"\",VLOOKUP(B1,[2]المخزون!B3:K309,10,0),\"\")","v":1485},null,null,{"$f":"IF(B1<>\"\",VLOOKUP(B1,[2]المخزون!B3:K309,10,0),\"\")","v":1485},"طه",29]
[]
["كود الصنف","اسم الحساب","التاريخ","رقم الفاتوره","رقم الدفتر","كود العميل","اسم العميل","كود الصنف","اسم الصنف","الكميه","سعر البيع","الجملة"]