{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["فاتورة","أرشيف","بضائع","الزبائن"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[0,0,0,4],[9,0,9,2],[4,2,4,4],[5,2,5,4],[7,2,7,4],[8,2,8,4],[1,0,1,4]]}
["الفاتورة",null,null,null,null,2]
["شركة السلام "]
[]
[null,null,"مؤسسة الفردوس"]
[null,null,{"$f":"IFERROR(IF(VLOOKUP($C$4,Clients,2,0)=0,\"\",VLOOKUP($C$4,Clients,2,0)),\"\")","v":"وهرن"}]
[null,null,{"$f":"IFERROR(IF(VLOOKUP($C$4,Clients,3,0)=0,\"\",VLOOKUP($C$4,Clients,3,0)),\"\")","v":""}]
[{"$f":"IFERROR(IF(VLOOKUP($A$4,Clients,7,0)=0,\"\",VLOOKUP($A$4,Clients,7,0)),\"\")","v":""},null,{"$f":"IFERROR(IF(VLOOKUP($C$4,Clients,4,0)=0,\"\",VLOOKUP($C$4,Clients,4,0)),\"\")","v":""}]
[{"$f":"IFERROR(IF(VLOOKUP($A$4,Clients,8,0)=0,\"\",VLOOKUP($A$4,Clients,8,0)),\"\")","v":""},null,{"$f":"IFERROR(IF(VLOOKUP($C$4,Clients,5,0)=0,\"\",VLOOKUP($C$4,Clients,5,0)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(VLOOKUP($C$4,Clients,6,0)=0,\"\",VLOOKUP($C$4,Clients,6,0)),\"\")","v":""}]
[{"$f":"IFERROR(\"فاتورة رقم : \" & TEXT(TODAY(),\"aaaa\")& \"/\" & F1,\"\")","v":"فاتورة رقم : 2020/2"}]
[null,null,null,"التاريخ :","2020-01-27"]
["رقم","التعيين","الكمية","سعر الوحدة","المجموع"]
[{"$f":"IFERROR(IF(B13=\"\",\"\",ROW()-12),\"\")","v":1},"شاشة 18\"",3,9000,{"$f":"IF(C13<>\"\",C13*D13,\"\")","v":27000}]
[2,"قرص الصلب 1 تيرا",4,10000,40000]
["",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,null,""]
["",null,null,null,""]
["",null,null,null,""]
[null,null,"المجموع باستثناء الضرائب",null,{"$f":"SUM(E13:E43)","v":67000}]
[null,"توقف هذه الفاتورة بمبلغ :","مجموع الضريبة على القيمة المضافة",null,{"$f":"E44*19%","v":12730}]
[null,{"$f":"NombresEnLettres(E48)","v":"تسعة و سبعون الف و  سبعة مائة  و ثلاثون دينار "},"ضريبة القيمة المضافة الإجمالية",null,{"$f":"SUM(E44:E45)","v":79730}]
[null,null,"الطابع"]
[null,null,"المجموع",null,{"$f":"SUM(E46:E47)","v":79730}]

{"sheet":"أرشيف","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["قاعدة البيانات",null,null,null,null,null,null,null,null,3]
["رقم الفاتورة ","تاريخ","الزبون","التعيين","الكمية","سعر الوحدة"]
[1,"2020-01-27","مؤسسة الفردوس","لوحة المفاتيح",10,450]
[1,"2020-01-27","مؤسسة الفردوس","قرص الصلب 500 جيجا",4,8000]
[1,"2020-01-27","مؤسسة الفردوس","شاشة 18\"",4,9000]
[1,"2020-01-27","مؤسسة الفردوس","فأرة",30,300]
[2,"2020-01-27","مؤسسة الفردوس","شاشة 18\"",3,9000]
[2,"2020-01-27","مؤسسة الفردوس","قرص الصلب 1 تيرا",4,10000]
[3,"2020-01-27","مؤسسة النور","لوحة المفاتيح",100,450]
[3,"2020-01-27","مؤسسة النور","لوحة المفاتيح",200,450]

{"sheet":"بضائع","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["بضائع"]
["التعيين","سعر الوحدة"]
["لوحة المفاتيح",450]
["فأرة",300]
["شاشة 18\"",9000]
["قرص الصلب 250 جيجا",5000]
["قرص الصلب 500 جيجا",8000]
["قرص الصلب 1 تيرا",10000]
["راما 1 جيجا",2500]
["راما 2 جيجا",3800]

{"sheet":"الزبائن","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["الزبائن"]
["الزبون","العنوان"]
["مؤسسة الفردوس","وهرن"]
["مؤسسة النور","مستغانم"]
["مؤسسة السعادة","قسنطينة"]