{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","قائمة الأصناف"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,9,6,10],[3,9,4,10],[7,9,8,10],[35,4,35,5],[12,6,31,6],[13,9,14,9],[13,10,14,11],[15,9,16,9],[15,10,16,11],[34,2,34,3],[34,4,34,5],[34,0,34,1],[2,4,2,5],[8,0,8,1],[1,0,1,2],[2,0,2,2],[3,0,3,2],[3,4,3,5],[32,1,32,2]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"    طبـاعة الفاتورة"]
[]
[null,null,null,"001013","                                           No.",null,null,null,null,"    حفــظ الفـاتورة"]
[]
["التـــاريـخ :",null,null,null,null,null,null,null,null,"  خروج من الفـاتورة"]
["المطلـوب مــن الســادة: /"]
[]
["القيمة","سعر الوحده","الكمية","الموديل","البيــــــــــــــــان","مسلسل"]
["Amount","Unit Price","Qty.","Part No.","Description","S.r"]
[{"$f":"IF(B13+C13>0,B13*C13,\"\")","v":1800},{"$f":"IFERROR(VLOOKUP(D13,'قائمة الأصناف'!$B$5:$D$87,3,0),\"\")","v":90},20,51110,{"$f":"IFERROR(VLOOKUP(D13,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":"تى شيرت "},{"$f":"IF(E13<>\"\",1,\"\")","v":1}]
[{"$f":"IF(B14+C14>0,B14*C14,\"\")","v":1875},{"$f":"IFERROR(VLOOKUP(D14,'قائمة الأصناف'!$B$5:$D$87,3,0),\"\")","v":75},25,51111,{"$f":"IFERROR(VLOOKUP(D14,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":"تى شيرت ساده"},{"$f":"IF(E14<>\"\",F13+1,\"\")","v":2},null,null,null,"اجمالى قيمة الفاتورة",{"$f":"A33","v":17825}]
[7500,{"$f":"IFERROR(VLOOKUP(D15,'قائمة الأصناف'!$B$5:$D$87,3,0),\"\")","v":75},100,51111,{"$f":"IFERROR(VLOOKUP(D15,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":"تى شيرت ساده"},{"$f":"IF(E15<>\"\",F14+1,\"\")","v":3}]
[2400,{"$f":"IFERROR(VLOOKUP(D16,'قائمة الأصناف'!$B$5:$D$87,3,0),\"\")","v":80},30,51112,{"$f":"IFERROR(VLOOKUP(D16,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":"تى شيرت مقلم"},4,null,null,null,"اجمالى عدد الأصناف",{"$f":"COUNT(A13:A32)","v":5}]
[{"$f":"IF(B17+C17>0,B17*C17,\"\")","v":4250},{"$f":"IFERROR(VLOOKUP(D17,'قائمة الأصناف'!$B$5:$D$87,3,0),\"\")","v":85},50,51113,{"$f":"IFERROR(VLOOKUP(D17,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":"تى شيرت بكم"},5]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D18,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D19,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D20,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D21,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D22,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D23,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D24,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D25,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D26,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D27,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D28,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D29,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D30,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D31,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
["",null,null,null,{"$f":"IFERROR(VLOOKUP(D32,'قائمة الأصناف'!$B$5:$D$87,2,0),\"\")","v":""},""]
[{"$f":"SUM(A13:A32)","v":17825},"إجمالى القيمة",null,{"$f":"Ashrafabdalla(A33,\"جنيهاً\",\"قرشاً\")","v":"فقط سبعة عشر ألف وثمانمائة وخمسة وعشرون جنيهاً"}]
[]
["الحسابات",null,"                      المراجعة",null,"                  المستلم"]

{"sheet":"قائمة الأصناف","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["بيان بالأصناف وقيمتها"]
[]
["المسلسل","كود الصنف","اسم الصنف","السعر"]
[1,51110,"تى شيرت ",90]
[2,51111,"تى شيرت ساده",75]
[3,51112,"تى شيرت مقلم",80]
[4,51113,"تى شيرت بكم",85]
[5,51114,"تى شيرت ",40]
[6,51115,"تى شيرت ",55]
[7,51116,"تى شيرت ",60]
[8,51117,"تى شيرت ",75]
[9,51118,"تى شيرت ",90]
[10,51119,"تى شيرت ",85]