{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["الفاتورة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":181,"n_cols":18,"rows_kept":181,"cut":false,"hidden":false,"merged":[[2,9,6,9],[0,6,0,7],[36,0,36,7],[2,5,2,6],[7,5,7,6],[8,5,8,6],[7,0,7,2],[29,0,29,4],[35,0,35,7],[3,5,3,6],[30,0,30,4],[13,0,13,4],[4,0,4,1],[6,0,6,1],[5,4,5,7],[6,4,6,7],[37,6,37,7],[39,5,39,6],[40,5,40,6],[41,0,41,1],[42,4,42,7],[43,0,43,1],[43,4,43,7],[44,0,44,2],[44,5,44,6],[45,5,45,6],[50,0,50,4],[66,0,66,4],[67,0,67,4],[74,6,74,7],[76,5,76,6],[77,5,77,6],[78,0,78,1],[79,4,79,7],[80,0,80,1],[80,4,80,7],[81,0,81,2],[81,5,81,6],[82,5,82,6],[87,0,87,4],[103,0,103,4],[104,0,104,4],[111,6,111,7],[113,5,113,6],[114,5,114,6],[115,0,115,1],[116,4,116,7],[117,0,117,1],[117,4,117,7],[118,0,118,2],[118,5,118,6],[119,5,119,6],[124,0,124,4],[140,0,140,4],[141,0,141,4],[148,6,148,7],[150,5,150,6],[151,5,151,6],[152,0,152,1],[153,4,153,7],[154,0,154,1],[154,4,154,7],[178,0,178,4],[155,0,155,2],[155,5,155,6],[156,5,156,6],[161,0,161,4],[177,0,177,4]]}
["المقر",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,103,"2020-12-19",307.8,null,101,"18/12/202",22.8]
["تليفــــــــــون  :",null,null,null,null,103,null,"2020-12-19",null,null,null,100,"2020-12-18",22.8,null,102,"2020-12-19",273.60000000000002]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:",null,null,null,103,"2020-12-19",307.8]
["ملف ضــريبي :",null,null,null,"mobile: ",null,null,null,null,null,null,"اجمالي جميع الفواتير",null,638.40000000000009]
["القيمة المضافة :",null,null,null,"Date:……10…/12/2018………………….."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","العربى",null,null,null,null,null,null,null,"وهذه نماذج للعمل متنمنين لكم دوام الصحة والعافية"]
["اسم الشركة /"]
["عنوانة /"]
["تليفون /"]
[]
["البيان",null,null,null,null,"الكمية","سعر الوحدة","المبلغ"]
["ثلاجة 14 قدم",null,null,null,null,2,120,{"$f":"IF(F15=\"\",ROUND(1*G15,2),ROUND(F15*G15,2))","v":240}]
["فريزر",null,null,null,null,5,6,{"$f":"IF(F16=\"\",ROUND(1*G16,2),ROUND(F16*G16,2))","v":30}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(F24=\"\",ROUND(1*G24,2),ROUND(F24*G24,2))","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H15:H29)","v":270}]
[{"$f":"NoToTxt(H33,\"جنيه\",\" قرش\")","v":" ثلاثمائة وسبعة جنيه وثمانون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H30*H31","v":37.800000000000004}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H30+H32","v":307.8}]
[]
[]
[]
[]
["المقر",null,null,null,null,null,"خاص"]
["العنوان"]
["البريد الاكترونى",null,null,null,null,"الفاتورة #",null,"التاريخ"]
["تليفــــــــــون  :",null,null,null,null,100,null,"2020-12-18"]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:"]
["ملف ضــريبي :",null,null,null,"mobile: "]
["القيمة المضافة :",null,null,null,"Date:……10…/12/2018………………….."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","العربى"]
["اسم الشركة /"]
["عنوانة /"]
["تليفون /"]
[]
["البيان",null,null,null,null,"الكمية","سعر الوحدة","المبلغ"]
["غسالة  توشيبا",null,null,null,null,5,4,{"$f":"IF(F52=\"\",ROUND(1*G52,2),ROUND(F52*G52,2))","v":20}]
[null,null,null,null,null,null,null,{"$f":"IF(F53=\"\",ROUND(1*G53,2),ROUND(F53*G53,2))","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H52:H66)","v":20}]
[{"$f":"NoToTxt(H70,\"جنيه\",\" قرش\")","v":" اثنان وعشرون جنيه وثمانون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H67*H68","v":2.8000000000000003}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H67+H69","v":22.8}]
[]
[]
[]
[]
["المقر",null,null,null,null,null,"خاص"]
["العنوان"]
["البريد الاكترونى",null,null,null,null,"الفاتورة #",null,"التاريخ"]
["تليفــــــــــون  :",null,null,null,null,101,null,"2020-12-18"]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:"]
["ملف ضــريبي :",null,null,null,"mobile: "]
["القيمة المضافة :",null,null,null,"Date:……10…/12/2018………………….."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","يونفرسال"]
["اسم الشركة /"]
["عنوانة /"]
["تليفون /"]
[]
["البيان",null,null,null,null,"الكمية","سعر الوحدة","المبلغ"]
["غسالة   نص ك",null,null,null,null,9,7,{"$f":"IF(F89=\"\",ROUND(1*G89,2),ROUND(F89*G89,2))","v":63}]
[null,null,null,null,null,null,null,{"$f":"IF(F90=\"\",ROUND(1*G90,2),ROUND(F90*G90,2))","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H89:H103)","v":63}]
[{"$f":"NoToTxt(H107,\"جنيه\",\" قرش\")","v":" واحد وسبعون جنيه واثنان وثمانون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H104*H105","v":8.82}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H104+H106","v":71.819999999999993}]
[]
[]
[]
[]
["المقر",null,null,null,null,null,"خاص"]
["العنوان"]
["البريد الاكترونى",null,null,null,null,"الفاتورة #",null,"التاريخ"]
["تليفــــــــــون  :",null,null,null,null,102,null,"2020-12-19"]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:"]
["ملف ضــريبي :",null,null,null,"mobile: "]
["القيمة المضافة :",null,null,null,"Date:……10…/12/2018………………….."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","يونفرسال"]
["اسم الشركة /"]
["عنوانة /"]
["تليفون /"]
[]
["البيان",null,null,null,null,"الكمية","سعر الوحدة","المبلغ"]
["ثلاجة 14 قدم",null,null,null,null,2,120,{"$f":"IF(F126=\"\",ROUND(1*G126,2),ROUND(F126*G126,2))","v":240}]
[null,null,null,null,null,null,null,{"$f":"IF(F127=\"\",ROUND(1*G127,2),ROUND(F127*G127,2))","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H126:H140)","v":240}]
[{"$f":"NoToTxt(H144,\"جنيه\",\" قرش\")","v":" مائتان وثلاثة وسبعون جنيه وستون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H141*H142","v":33.6}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H141+H143","v":273.60000000000002}]
[]
[]
[]
[]
["المقر",null,null,null,null,null,"خاص"]
["العنوان"]
["البريد الاكترونى",null,null,null,null,"الفاتورة #",null,"التاريخ"]
["تليفــــــــــون  :",null,null,null,null,103,null,"2020-12-19"]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:"]
["ملف ضــريبي :",null,null,null,"mobile: "]
["القيمة المضافة :",null,null,null,"Date:……10…/12/2018………………….."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","العربى"]
["اسم الشركة /"]
["عنوانة /"]
["تليفون /"]
[]
["البيان",null,null,null,null,"الكمية","سعر الوحدة","المبلغ"]
["ثلاجة 14 قدم",null,null,null,null,2,120,{"$f":"IF(F163=\"\",ROUND(1*G163,2),ROUND(F163*G163,2))","v":240}]
["فريزر",null,null,null,null,5,6,{"$f":"IF(F164=\"\",ROUND(1*G164,2),ROUND(F164*G164,2))","v":30}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H163:H177)","v":270}]
[{"$f":"NoToTxt(H181,\"جنيه\",\" قرش\")","v":" ثلاثمائة وسبعة جنيه وثمانون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H178*H179","v":37.800000000000004}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H178+H180","v":307.8}]