{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Invoice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Invoice","index":0,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,15,18,18],[41,4,41,7],[41,8,41,10],[9,1,10,1],[9,2,11,2],[9,3,10,4],[9,5,9,11],[10,5,10,6],[10,7,10,8],[10,9,11,9],[10,10,11,10],[11,3,11,4],[29,6,29,7],[30,6,30,7],[35,4,35,9],[40,4,40,7],[40,8,40,10],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,3,5,7],[7,2,7,3],[7,8,7,10]]}
[]
[]
[]
[]
[]
[null,null,null,"فاتــــــــــورة رقم",null,null,null,null,1]
[]
[null,"الاســــم:",{"$f":"VLOOKUP(#REF!,data00,2,0)","v":{"$error":"#REF!"}},null,null,null,null,"التاريخ:",{"$f":"VLOOKUP(C8,data,2,FALSE)","v":{"$error":"#REF!"}}]
[]
[null,"رقم","اســــــم الصنف","الكمية",null,"السعـــــــر"]
[null,null,null,null,null,"بيع الجمهور",null,"شراء المناقصة",null,0.05,0.02,"الاجمالى",null,null,null,"أريد تغيير هذا الرقم تلقائى بتسلسل بدون الضغط\nعلى Run -وبمجرد الإنتهاء من الفاتورة وطباعتها\nثم مسح مافيها لعمل فاتورة اخرى اريد تغير هذا الرقم\nللرقم التالى بحيث لا يحدث خطأ فى تسلسل رقم الفاتورة\nاذا تغير يدويا"]
[null,"الصنف",null,"المنصرفة",null,"وحدة","مجموع","وحدة","مجموع",null,null,"بعد زيادة النسبة"]
[null,{"$f":"VLOOKUP(#REF!,data00,4,0)","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(B13,datahosam,2,0),\"\")","v":""},{"$f":"VLOOKUP(#REF!,data00,5,0)","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(B13,datahosam,3,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B13,datahosam,4,0),\"\")","v":""},{"$f":"IFERROR(H13*D13,\"\")","v":""}]
[null,{"$f":"VLOOKUP(C8,data,5,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,6,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IFERROR(H14*D14,\"\")","v":""}]
[null,{"$f":"VLOOKUP(C8,data,7,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,8,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,9,FALSE)","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(B16,datahosam,2,0),\"\")","v":""},{"$f":"VLOOKUP(C8,data,10,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,11,FALSE)","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(B17,datahosam,2,0),\"\")","v":""},{"$f":"VLOOKUP(C8,data,12,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,13,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,14,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,15,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,16,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,17,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,18,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,19,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,20,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,21,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,22,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,23,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,24,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"IFERROR(VLOOKUP(B23,datahosam,5,0),\"\")","v":""},{"$f":"IFERROR(D23*F23,\"\")","v":""},"",""]
[null,{"$f":"VLOOKUP(C8,data,25,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,26,FALSE)","v":{"$error":"#REF!"}},"","","","",""]
[null,{"$f":"VLOOKUP(C8,data,27,FALSE)","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(B25,datahosam,2,0),\"\")","v":""},{"$f":"VLOOKUP(C8,data,28,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,29,FALSE)","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(B26,datahosam,2,0),\"\")","v":""},{"$f":"VLOOKUP(C8,data,30,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,31,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,32,FALSE)","v":{"$error":"#REF!"}},"",null,null,"",""]
[null,{"$f":"VLOOKUP(C8,data,33,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,34,FALSE)","v":{"$error":"#REF!"}},null,null,null,"",{"$f":"SUM(I13:I27)","v":0},null,null,{"$f":"I28+I30+I31","v":0}]
[null,{"$f":"VLOOKUP(C8,data,35,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,36,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,37,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,38,FALSE)","v":{"$error":"#REF!"}},null,0.05,"للمستشفى وقيمتها",null,{"$f":"I28*5/100","v":0}]
[null,{"$f":"VLOOKUP(C8,data,39,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,40,FALSE)","v":{"$error":"#REF!"}},null,0.02,"للمديرية والوزارة",null,{"$f":"I28*2/100","v":0}]
[null,{"$f":"VLOOKUP(C8,data,41,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,42,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,43,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,44,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,45,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,46,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,47,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,48,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,49,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,50,FALSE)","v":{"$error":"#REF!"}},{"$f":"NumtoTxt(L28,\"جنيها\",\"قرشا\")","v":{"$error":"#NAME?"}}]
[null,{"$f":"VLOOKUP(C8,data,51,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,52,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,53,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,54,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,55,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,56,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(C8,data,57,FALSE)","v":{"$error":"#REF!"}},"",{"$f":"VLOOKUP(C8,data,58,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,1]