{"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":[[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],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3]]}
["الفاتورة",null,null,null,null,5]
["شركة السلام "]
[]
[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/5"}]
[null,null,null,"التاريخ :","2020-01-29"]
["رقم","التعيين","الكمية","سعر الوحدة","المجموع"]
[{"$f":"IFERROR(IF(B13=\"\",\"\",ROW()-12),\"\")","v":1},"شاشة 18\"",10,9000,{"$f":"IF(C13<>\"\",C13*D13,\"\")","v":90000}]
[{"$f":"IFERROR(IF(B14=\"\",\"\",ROW()-12),\"\")","v":2},"قرص الصلب 500 جيجا",10,8000,{"$f":"IF(C14<>\"\",C14*D14,\"\")","v":80000}]
[{"$f":"IFERROR(IF(B15=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C15<>\"\",C15*D15,\"\")","v":""}]
[{"$f":"IFERROR(IF(B16=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C16<>\"\",C16*D16,\"\")","v":""}]
[{"$f":"IFERROR(IF(B17=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C17<>\"\",C17*D17,\"\")","v":""}]
[{"$f":"IFERROR(IF(B18=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C18<>\"\",C18*D18,\"\")","v":""}]
[{"$f":"IFERROR(IF(B19=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C19<>\"\",C19*D19,\"\")","v":""}]
[{"$f":"IFERROR(IF(B20=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C20<>\"\",C20*D20,\"\")","v":""}]
[{"$f":"IFERROR(IF(B21=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C21<>\"\",C21*D21,\"\")","v":""}]
[{"$f":"IFERROR(IF(B22=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C22<>\"\",C22*D22,\"\")","v":""}]
[{"$f":"IFERROR(IF(B23=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C23<>\"\",C23*D23,\"\")","v":""}]
[{"$f":"IFERROR(IF(B24=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C24<>\"\",C24*D24,\"\")","v":""}]
[{"$f":"IFERROR(IF(B25=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C25<>\"\",C25*D25,\"\")","v":""}]
[{"$f":"IFERROR(IF(B26=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C26<>\"\",C26*D26,\"\")","v":""}]
[{"$f":"IFERROR(IF(B27=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C27<>\"\",C27*D27,\"\")","v":""}]
[{"$f":"IFERROR(IF(B28=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C28<>\"\",C28*D28,\"\")","v":""}]
[{"$f":"IFERROR(IF(B29=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C29<>\"\",C29*D29,\"\")","v":""}]
[{"$f":"IFERROR(IF(B30=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C30<>\"\",C30*D30,\"\")","v":""}]
[{"$f":"IFERROR(IF(B31=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C31<>\"\",C31*D31,\"\")","v":""}]
[{"$f":"IFERROR(IF(B32=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C32<>\"\",C32*D32,\"\")","v":""}]
[{"$f":"IFERROR(IF(B33=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C33<>\"\",C33*D33,\"\")","v":""}]
[{"$f":"IFERROR(IF(B34=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C34<>\"\",C34*D34,\"\")","v":""}]
[{"$f":"IFERROR(IF(B35=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C35<>\"\",C35*D35,\"\")","v":""}]
[{"$f":"IFERROR(IF(B36=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C36<>\"\",C36*D36,\"\")","v":""}]
[{"$f":"IFERROR(IF(B37=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C37<>\"\",C37*D37,\"\")","v":""}]
[{"$f":"IFERROR(IF(B38=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C38<>\"\",C38*D38,\"\")","v":""}]
[{"$f":"IFERROR(IF(B39=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C39<>\"\",C39*D39,\"\")","v":""}]
[{"$f":"IFERROR(IF(B40=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C40<>\"\",C40*D40,\"\")","v":""}]
[{"$f":"IFERROR(IF(B41=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C41<>\"\",C41*D41,\"\")","v":""}]
[{"$f":"IFERROR(IF(B42=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C42<>\"\",C42*D42,\"\")","v":""}]
[{"$f":"IFERROR(IF(B43=\"\",\"\",ROW()-12),\"\")","v":""},null,null,null,{"$f":"IF(C43<>\"\",C43*D43,\"\")","v":""}]
[null,null,"المجموع باستثناء الضرائب",null,{"$f":"SUM(E13:E43)","v":170000}]
[null,"توقف هذه الفاتورة بمبلغ :","مجموع الضريبة على القيمة المضافة",null,{"$f":"E44*19%","v":32300}]
[null,{"$f":"NombresEnLettres(E48)","v":" مائتان و اثنان الف و  ثلاثة مائة  دينار "},"ضريبة القيمة المضافة الإجمالية",null,{"$f":"SUM(E44:E45)","v":202300}]
[null,null,"الطابع"]
[null,null,"المجموع",null,{"$f":"SUM(E46:E47)","v":202300}]

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

{"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]]}
["الزبائن"]
["الزبون","العنوان"]
["مؤسسة الفردوس","وهرن"]
["مؤسسة النور","مستغانم"]
["مؤسسة السعادة","قسنطينة"]