{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["صفحه التسجيل","INVOICEEE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":7,"n_cols":19,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,5,0,6]]}
[" رقم الفاتوره "," المجموع غير شامل الضريبه\n",null," الضريبه\n",null," اجمالى الفاتوره شامل الضريبه\n",null," تاريخ الفاتوره\n","رقم الفاتوره","اسم العمــــــيل"]
["رقم :NO.000000",null,null,null,null,null,null,"تحريرا  فى:-  2018/0/0","INVOICEEE","المطلوب من السيد: شركه "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1250]

{"sheet":"INVOICEEE","index":1,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":false,"merged":[[47,0,47,10],[24,5,24,10],[26,14,29,14],[42,0,43,0],[42,1,43,1],[42,2,43,10],[44,0,46,0],[44,1,46,1],[36,5,36,10],[38,5,38,10],[39,5,39,10],[40,0,41,0],[40,1,41,1],[40,2,41,10],[30,17,37,17],[31,5,31,10],[32,5,32,10],[33,5,33,10],[34,5,34,10],[35,5,35,10],[30,5,30,10],[21,5,21,10],[22,5,22,10],[23,5,23,10],[37,5,37,10],[25,5,25,10],[26,5,26,10],[27,5,27,10],[28,5,28,10],[29,5,29,10],[16,5,16,10],[17,5,17,10],[18,5,18,10],[19,5,19,10],[20,5,20,10],[11,5,11,10],[12,5,12,10],[13,5,13,10],[14,5,14,10],[15,5,15,10],[7,2,7,3],[7,4,8,4],[7,5,8,10],[9,5,9,10],[10,5,10,10],[44,2,46,4],[44,5,46,10],[30,14,32,14],[0,0,0,3],[0,8,0,10],[1,0,1,3],[1,8,1,10],[2,4,2,5],[2,6,2,7],[2,8,2,10],[3,8,3,10],[4,8,4,10],[5,0,5,2],[5,8,5,10],[6,0,6,10],[7,0,7,1]]}
[]
[]
[null,null,null,null,"فـــــــــــاتوره",null,"رقم :NO.000000"]
[]
[]
["تحريرا  فى:-  2018/0/0",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":"Q7*P7","v":10526.315789473685},8,{"$f":"R7","v":1315.7894736842106},{"$f":"S7/1.14","v":1315.7894736842106},1500]
["سعر اجمالى",null,"سعر الوحدة",null,"الكميه","الـــــــــــــــــــــــــــــــــبــــــــــــــــــــــــــيــــــــــــــان",null,null,null,null,null,null,null,null,8771.9298245614045,5,1754.3859649122808,1754.3859649122808,2000]
["قرش","جنيه","قرش","جنيه",null,null,null,null,null,null,null,null,null,null,15815.78947368421,6,2635.9649122807018,2635.9649122807018,3005]
[32,10526,79,1315,{"$f":"P7","v":8},null,null,null,null,null,null," ",null,null,1304.0438596491229,1,1304.0438596491229,1304.0438596491229,1486.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[93,8771,39,1754,{"$f":"P8","v":5},null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,6,0,0]
[79,15815,96,2635,{"$f":"P9","v":6},null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[4,1304,4,1304,1,null,null,null,null,null,null,null,null,"الاجمــــــــالى",{"$f":"SUM(O7:O17)","v":36418.07894736842}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"الضريبه",{"$f":"O19*14/100","v":5098.5310526315789}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"الاجمالى بعد الضريبه",{"$f":"O19+O20","v":41516.61}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"خصم 1 % ان وجد",{"$f":"O19*1/100","v":364.18078947368417}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"الاجمالى  بعد الضريبه و بعد الخصم",{"$f":"O21-O22","v":41152.429210526316}]
[]
[]
[]
[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,"مش عايزه بداله INT لانها بتعمل علامه عشريه وانا محتاجه بنفس الشكل بظبط"]
[]
[]
[]
[]
[]
[]
[14,351,null,null,null,"خصم 1%"]
[]
[]
[{"$f":"($O$19-INT($O$19))*100","v":7.8947368419903796},{"$f":"QUOTIENT($O$19,1)","v":36418},"المجمــــــــــــــــــــــــوع:"]
[]
[{"$f":"($O$20-INT($O$20))*100","v":53.105263157885929},{"$f":"QUOTIENT($O$20,1)","v":5098}," 14% ضريبه المبيعات"]
[]
[{"$f":"($O$23-INT($O$23))*100","v":42.92105263157282},{"$f":"QUOTIENT($O$23,1)","v":41152},"الاجـــــــــــــمــــــالى :-",null,null,{"$f":"IFERROR( \"فقط\" & \"  \" & Ar_WriteDownNumber(B45,\" جنيهاً\",)&Ar_WriteDownNumber(A45,\"قرشاً\") &\"\"  & \"لاغير\",\"\")","v":"فقط  واحد وأربعون الف و مائة و أثنان و خمسون  جنيهاًأثنان و أربعون قرشاً و أثنان و تسعون  جزء من مائةلاغير"}]