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

{"sheet":"الرئيسية","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الموردين","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
["م","اسم المورد","رقم الجزال","العنوان","الرصيد"]
[{"$f":"IF(B3=\"\",\"\",1)","v":1},"مكتبة الزهراء"]
[{"$f":"IF(B4=\"\",\"\",A3+1)","v":2},"مكتبة رؤى - شراب"]
[{"$f":"IF(B5=\"\",\"\",A4+1)","v":3},"مكتبة انعيم"]
[4,"شركة حسام الحتو"]
[5,"شركة البورنو"]
[6,"شركة علم الدين ابو عاصي"]
[7,"محلات أبو صبحي والعبادلة"]
[8,"محلات أحمد أبو خضير"]
[9,"جودت أبو عاصي"]
[10,"من السوق"]
[11,"محلات أبو جهاد شراب"]
[12,"محلات أبو مصطفى"]
[13,"محلات الرخاء"]
[14,"محلات النعيزي"]
[15,"مطبعة التقوى"]
[16,"شركة محمود صالحية"]
[17,"مطبعة القدس"]
[18,"مكتبة العودة المركزية"]
[19,"شركة حلاوة أبناء عم"]
[20,"شركة الحلبي"]
[21,"محل فرح وزينة"]
[22,"محل القلعة للألعاب"]
[23,"محلات شبلاق"]
[24,"البرقوني لمستلزمات الطباعة"]
[25,"شركة الشامل والاندلس"]
[26,"الغفاري للشنط"]
[27,"الجزيرة للتحف والهدايا"]
[28,"أبو حلمي بربخ"]
[29,"مكتبة نون"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"فاتورة مشتريات","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4]]}
[]
["رقم الفاتورة:"]
["اسم المورد:"]
["تاريخ الفاتورة"]
[]
["م","البيـــــــــــــــــان","الوحدة","الكمية","السعر","المبلغ"]
[{"$f":"IF(B7=\"\",\"\",1)","v":""},null,null,null,null,{"$f":"IF(E7=\"\",\"\",D7*E7)","v":""}]
[{"$f":"IF(B8=\"\",\"\",A7+1)","v":""},null,null,null,null,{"$f":"IF(E8=\"\",\"\",D8*E8)","v":""}]
[{"$f":"IF(B9=\"\",\"\",A8+1)","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,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,{"$f":"SUM(F7:F27)","v":0}]
[null,null,null,"الخصــــــــــــم:"]
[null,null,null,"بعد الخصــــــم:",null,{"$f":"SUM(F29-F30)","v":0}]
[null,null,null,"الدفعـــــــــــــــة:"]
[null,null,null,"المبلــغ المتبقي:",null,{"$f":"SUM(F31-F32)","v":0}]

{"sheet":"المشتريات","index":4,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["رقم الفاتورة","اسم المورد","تاريخ الفاتورة","البيان","الوحدة","الكمية","السعر","المبلغ","عمود1"]
[456,null,"2023-09-13","سجيد",6,6,6666,39996]
[456,null,"2023-09-13","سجيد",6,6,6666,39996]
[456,null,"2023-09-13","سجيد",6,6,6666,39996]
[15,null,"2023-09-14","سجاد 2.5*3.5",6,55,55,3025]
[123321,null,"2023-09-14","س1",123,88,123,10824]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,""]

{"sheet":"إجمالي حسابات الموردين","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["رقم الفاتورة","اسم المورد","تاريخ الفاتورة","البيان","إجمالي الفاتورة","الخصم","بعد الخصم","الدفعة","المتبقي"]
[18,null,"2023-09-13","إجمالي الفاتورة:",25000,null,25000,null,25000]
[12,null,"2023-09-13","إجمالي الفاتورة:",2775,null,2775,null,2775]
[22,null,"2023-09-13","إجمالي الفاتورة:",3025,null,3025,null,3025]
[12,null,"2023-09-13","إجمالي الفاتورة:",3025,null,3025,null,3025]
[123,null,"2023-09-13","إجمالي الفاتورة:",30525,null,30525,null,30525]
[456,null,"2023-09-13","إجمالي الفاتورة:",39996,null,39996,null,39996]
[15,null,"2023-09-14","إجمالي الفاتورة:",3025,null,3025,null,3025]
[123321,null,"2023-09-14","إجمالي الفاتورة:",10824,null,10824,null,10824]

{"sheet":"كسف حساب المورد","index":6,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[]
[null,"اسم المورد:",null,null,null,null,null,"الرصيد:"]
[null,"رقم الجوال:"]
[]
[null,"التاريخ","رقم الفاتورة","البيــــــــــــــــان","إجمالي الفاتورة","الخصم","بعد الخصم","الدفعة","المتبقي"]

{"sheet":"سند دفع","index":7,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"رقم السند"]
[null,null,null,null,null,"No"]
[]
[]
[null,null,"اسم المورد:",null,null,null,null,"المبلغ:"]
[null,null,"وذلك عن:",null,null,null,null,"التاريخ:"]

{"sheet":"العملاء","index":8,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["م","الاسم","رقم الجوال","العنوان","الرصيد"]
[{"$f":"IF(B3<>\"\",1,\"\")","v":""}]
[{"$f":"IF(B4<>\"\",A3+1,\"\")","v":""}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"فاتورة مبيعات","index":9,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,3,3,4],[27,2,27,3],[28,2,28,3],[29,2,29,3]]}
[]
["رقم الفاتورة:",10]
["اسم العميل:"]
["اليــــــــوم:",{"$f":"TEXT(D4,\"dddd\")","v":"الخميس"},"التاريخ:",{"$f":"TODAY()","v":"2023-09-14"}]
[]
["م","البيــــــــــــــــــــــــــــــــــــان","الكمية","السعر","المبلغ"]
[{"$f":"IF(B7<>\"\",1,\"\")","v":""},null,null,null,{"$f":"IF(C7=\"\",\"\",C7*D7)","v":""}]
[{"$f":"IF(B8<>\"\",A7+1,\"\")","v":""},null,null,null,""]
[{"$f":"IF(B9<>\"\",A8+1,\"\")","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,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,{"$f":"SUM(E7:E26)","v":0}]
[null,null,"الدفعـــــــــــة:"]
[null,null,"المتبقــــــــــي:",null,{"$f":"SUM(E28-E29)","v":0}]

{"sheet":"المبيعات","index":10,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["اليوم","التاريخ ","رقم الفاتورة","اسم العميل","البيان","الكمية","السعر","المبلغ","الدفعة"]

{"sheet":"كشف حساب العملاء","index":11,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
[]
[]
[null,null,"اسم العميل:",null,null,null,"إجمالي المبلغ","إجمالي الدفعات","إجمالي الرصيد"]
[]
[]
["اليوم","التاريخ ","رقم الفاتورة","البيان","الكمية","السعر","المبلغ","الدفعة","الرصيد"]

{"sheet":"سند قبض","index":12,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"رقم السند"]
[null,null,null,null,null,"No"]
[]
[]
[null,null,"اسم العميل:",null,null,null,null,"المبلغ:"]
[null,null,"وذلك عن:",null,null,null,null,"التاريخ:"]