{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["الفاتورة","مبيعات","الارشيف","مردود مبيعات","الرصيد"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"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":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,2,7,3],[0,3,0,4],[2,2,2,3],[1,2,1,3],[1,6,9,8]]}
["المقر",null,null,"خاص"]
["سجل تجاري :  ",null,"الفاتورة #",null,"التاريخ",null,"شكر الى منتدى اوفيسنا الذى يساعدنا فى ايجاد الحلول الجميلة والرائعه المطلوب بعد اذنكم عند وضع كود المنتج فى العمود A  يدرج سطر جديد المطلوب إضافة على الكود اللى فى حدث الشيت ان ينسخ الزر الموجود أيضا فى الخلية A11  وهذا الزر به مكرو عند الضغط عليه يظهر الفورم الخاص بشيت الرصيد والطلب الثانى كود يعبئ اليوزر من شيت الرصيد  بياناته نكون عاجزين عن الشكر  وادامكم الله في طاعته"]
["ملف ضــريبي :",null,1,null,"2020-12-18"]
["القيمة المضافة :"]
["فاتورة إلى"]
["اسم العميل /"]
["عنوانة /"]
["تليفون /",null,"معرّف العميل",null,"الشروط"]
[]
["كود المنتج","البيان","الكمية","سعر الوحدة","المبلغ"]
[1]
[]
["شكراً لتعاملك معنا!",null,null,"الإجمالي الفرعي",{"$f":"SUM(H3:H12)","v":0}]
[null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,"الخصم",{"$f":"E13*E14","v":0}]
[null,null,null,"الإجمالي",{"$f":"E13+E15","v":0}]
["كود المنتج"]
[]
[]
[]
[1]

{"sheet":"مبيعات","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الارشيف","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"مردود مبيعات","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الرصيد","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,8,2,10]]}
["الكود","اسم المنتج","  سعر \nالتكلفه","  سعر \nالبيع","رصيد اول","المنصرف","رصيد اخر"]
[1,"ثلاجة 14 قدم",100,120,110,null,{"$f":"E2-F2","v":110},null,"إدخال كميات للمخزون"]
[2,"غسالة 7 ك بطرمبة",50,60,160,null,160]
[3,"فريزر 5 درج",400,450,205,null,205,null,"كود الصنف","إسم الصنف","الكميه المطلوب إضافتها"]
[4,"شاشة سامسونج 32 بوصة",150,175,50,null,0,null,2,{"$f":"VLOOKUP(I5,$A$2:$B$55,2,0)","v":"غسالة 7 ك بطرمبة"}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]