{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["المقايسة واولوية العطاءات","الدفتر","مستخلص 2"],"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":203,"n_cols":7,"rows_kept":203,"cut":false,"hidden":false,"merged":[[7,1,7,4],[7,5,7,6],[201,1,201,3],[202,1,202,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,"الصفا",null,null,null,"السعداء"]
[null,"البند","الفئة","الكمية","القيمة","الفئة","القيمة"]
[null,null,null,null,{"$f":"+D10*C10","v":0},null,{"$f":"+F10*D10","v":0}]
[null,null,null,null,{"$f":"+D11*C11","v":0},null,{"$f":"+F11*D11","v":0}]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,{"$f":"+D75*C75","v":0},null,{"$f":"+F75*D75","v":0}]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,{"$f":"+D139*C139","v":0},null,{"$f":"+F139*D139","v":0}]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E10:E201)","v":0},null,{"$f":"SUM(G10:G201)","v":0}]
[null,"الإجمالي بعد خصم نص العقد 2.5%",null,null,{"$f":"+E202*0.975","v":0}]

{"sheet":"الدفتر","index":1,"n_rows":41,"n_cols":44,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,1,14,2],[14,3,14,4],[15,1,15,2],[15,3,15,4],[17,23,17,37],[17,38,19,38],[17,39,17,42],[18,39,19,39],[18,40,19,40],[18,41,19,41],[18,42,19,42],[18,23,18,32],[18,34,18,36],[18,37,19,37],[18,9,19,9],[18,11,19,11],[18,12,19,12],[17,10,19,10],[17,11,17,22],[18,20,19,20],[18,21,19,21],[18,22,19,22],[18,16,19,16],[18,17,19,17],[18,18,19,18],[18,19,19,19],[13,1,13,2],[13,3,13,4],[16,1,16,43],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,19,4],[17,5,19,5],[17,43,19,43],[18,6,19,6],[18,13,19,13],[18,14,19,14],[18,15,19,15],[17,6,17,9],[18,7,19,7],[18,8,19,8],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[8,1,8,2],[8,3,8,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[1,1,3,3],[1,5,1,7],[4,1,4,4],[5,1,5,2],[5,3,5,4]]}
[]
[null,"إحلال وتجديد عدد 2 كوبري علي ترعة النوبارية بمركز أبو المطامير",null,null,null,"متحفظ ( حديد بانواعه - اسمنت - بتومين - سولار )"]
[null,null,null,null,null,null,null,"تاريخ الفتح الفني","2017-02-14"]
[null,null,null,null,null,"نسبة التأمينات",null,"محملات","كمبيوتر + طابعة + كراسي + استبلايزر+ مشترك +UPS",null,"او خصم 30000ج"]
["تاريخ العقد",null,null,null,null,"غرامات"]
["2018-06-04","رقم العقد",null,"111 / 2017 / 2018",null,"المهندس","500 ج يوميا"]
[null,"قيمة العقد",null,44934600,null,"المراقب","250 ج يوميا"]
[null,"مدة العملية",null,"12 شهر",null,"مكتب اشراف","400 ج يوميا"]
[null,"تاريخ استلام الموقع",null,"2018-11-22",null,"وجبات ","250 ج يوميا"]
[null,"تاريخ النهو",null,"2019-11-21",null,"العلامات الارشادية والتحذيرية والسور","500 ج يوميا"]
[null,"قيمة اخر مقايسة",null,null,null,"نقل العينات","600 ج يوميا"]
[null,"قيمة اخر مقايسة",null,null,null,"التقارير","9000 ج شهريا"]
[null,"قيمة اخر مقايسة",null,null,null,"المهندس استشاري","500 ج يوميا"]
[]
[null,"تاريخ النهو"]
[]
[null,"انشاء كوبري وادي حجول 2"]
[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,null,"ملاحظات"]
[null,null,null,null,null,null,"دمغات","ض م 10% الخاصة بالمعامل","اتساع وتنمية","أ ت ص",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,null,null,null,null,null,"غرامة تأخير","مهندس","مدير المشروع","علامات ارشادية","مكتب الاشراف","وجبات","استراحة","تقارير","تعليمات الامن الصناعي","المعدات","مصاريف ادارية","رسوم معمل","مصاريف معمل","تصنيع علامات"]
[null,{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"الاجمالي",{"$f":"SUM(D21:D40)","v":{"$error":"#REF!"}},0,{"$f":"SUM(F21:F40)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"مستخلص 2","index":2,"n_rows":159,"n_cols":72,"rows_kept":159,"cut":false,"hidden":false,"merged":[[6,2,6,3],[6,4,6,5],[44,5,44,6],[44,7,44,8],[1,2,3,4],[1,6,1,8],[4,2,4,5],[5,2,5,3],[5,4,5,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[9,2,9,3],[9,4,9,5],[10,2,10,3],[10,4,10,5],[11,2,11,3],[11,4,11,5],[12,2,12,3],[12,4,12,5],[41,13,41,14],[13,2,13,3],[13,4,13,5],[14,2,14,3],[14,4,14,5],[15,2,15,3],[15,4,15,5],[19,3,19,8],[27,1,28,1],[30,0,31,0],[37,0,39,0],[40,2,40,5],[42,3,42,7],[42,58,42,61],[43,59,44,59],[43,60,44,60],[43,61,44,61],[44,13,44,14],[43,38,44,38],[43,39,44,39],[43,40,44,40],[43,41,44,41],[43,42,43,51],[43,53,43,55],[42,24,44,24],[42,62,44,62],[43,25,44,25],[43,26,44,26],[43,27,44,27],[43,28,44,28],[43,30,44,30],[43,31,44,31],[43,32,44,32],[43,33,44,33],[42,25,42,28],[42,29,44,29],[42,30,42,41],[42,42,42,56],[42,57,44,57],[43,34,44,34],[43,58,44,58],[97,2,97,3],[97,5,98,5],[97,6,98,7],[98,2,98,3],[58,12,58,13],[43,56,44,56],[45,13,45,14],[46,13,46,14],[51,12,51,13],[52,2,52,3],[43,35,44,35],[43,36,44,36],[43,37,44,37],[42,23,44,23],[42,12,43,12],[42,20,44,20],[42,21,44,21],[42,22,44,22],[99,2,99,3],[99,6,99,7],[100,2,100,7],[101,2,101,7],[102,2,103,3],[102,4,102,5],[102,6,102,7],[117,2,117,3],[149,2,149,3],[156,2,156,7],[157,6,157,7],[104,2,104,3],[105,2,105,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[115,2,115,3]]}
[]
[null,null,"م (   ) أعمال ",null,null,null,null,null,null,null,"\n شركة "]
[null,null,null,null,null,null,null,null,"تاريخ الفتح الفني"]
[null,null,null,null,null,null,"نسبة التأمينات",null,"محملات","لا يوجد"]
[null,"تاريخ العقد",null,null,null,null,"غرامات"]
[null,"2022-02-24","رقم العقد",null,"440/2022/2023",null,"المهندس","500 ج يوميا"]
[null,null,"قيمة العقد",null,18870370,null,"مساعد المهندس"]
[null,null,"مدة العملية",null,"6 شهور",null,"مكتب اشراف"]
[null,null,"تاريخ استلام الموقع",null,"2022-10-05",null,"وجبات "]
[null,null,"تاريخ النهو",null,"2023-04-04",null,"العلامات الارشادية والتحذيرية والسور"]
[null,null,"قيمة اخر مقايسة",null,null,null,"تجهيزات موقع العمل"]
[null,null,"قيمة اخر مقايسة"]
[null,null,"قيمة اخر مقايسة"]
[]
[null,null,"تاريخ النهو"]
[]
[]
[]
[null,null,"من",null,null,null,{"$f":"G31+G32","v":0},{"$f":"G22+G23+G24+G25+G26+G27+G28+G29+G30","v":8922726.25},null,"حتي"]
[null,null,{"$f":"E9","v":"2022-10-05"},null,null,null,null,null,null,"2022-10-13"]
[null,"مقايسة","السعر","السابق","الحالي","الاجمالي","قيمة اجمالي الاعمال","الاستقطاع","الصافي","التحقيق",null,null,null,null,"الاسعار","كميات المستخلص","كميات المقايسة","الفرق"]
[null,null,27.75,17939,null,{"$f":"+E22+D22","v":17939},{"$f":"+F22*C22","v":497807.25},null,{"$f":"+G22-H22","v":497807.25},{"$f":"+E22*C22","v":0},{"$f":"B22*C22","v":0}]
[null,null,143,17939,null,17939,2565277,null,2565277,0,0]
[null,null,9.25,0,38900,38900,359825,null,359825,359825,0]
[null,null,137,0,38900,38900,5329300,null,5329300,5329300,0]
[null,null,null,0,null,0,0,null,0,0,0]
[null,null,null,0,null,0,{"$f":"C27*F27","v":0},null,0,0,0]
[null,"كارتات",3,17939,null,17939,53817,null,53817,0,{"$error":"#VALUE!"}]
[null,null,3,null,38900,38900,116700,null,116700,116700,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,{"$f":"G33*0.25","v":0},0,0,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,{"$f":"G37*0.25","v":0},0,0,0]
["كارتات",null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,null,null,null,0,0,null,0,0,0]
[null,null,"اجمالي الاعمال",null,null,null,{"$f":"SUM(G22:G40)","v":8922726.25},null,{"$f":"G41-H41","v":8922726.25},{"$f":"SUM(J22:J40)","v":5805825},{"$f":"SUM(K22:K40)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"تخفيض 1%",{"$f":"I41*1%","v":89227.262499999997},null,null,null,null,{"$f":"+J41","v":5805825},"التحقيق"]
[null,null,null,"اجمالي الاعمال",null,null,null,null,{"$f":"I41-H42","v":8833498.9875000007},null,null,null,null,0,"الاستقطاعات السابقة",null,null,null,null,null,"م","قيمة الاعمال التي تمت","قيمة المستخلص","تاريخ الصرف","ضمان اعمال","مصلحة الضرائب",null,null,null,{"$f":"+D60","v":"دفعة مقدمة"},"ارصدة متنوعة دائنة متنوعة",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,null,null," تعلية 5% لحين الاستلام",{"$f":"ROUND(I43*5%,1)","v":441674.9},null,null,null,null,null,null,{"$f":"+H41","v":0},"الاستقطاعات الحالية",null,null,null,null,null,null,null,null,null,null,"دمغات","ض م 10% الخاصة بالمعامل","اتساع وتنمية","أ ت ص",null,{"$f":"+D61","v":"محاجر"},{"$f":"+D62","v":"مهن هندسية"},{"$f":"+D63","v":"تعليه التأمينات"},{"$f":"+D64","v":"تعلي لحين ورود نتائج الاختبارات"},{"$f":"+D65","v":"تعلية 5 % لحين الاستلام"},{"$f":"+D66","v":"تعلية توريد ماسح ضوئي"},{"$f":"+D67","v":"تعلية "},{"$f":"+D68","v":"تعليه لحين انهاء الاختبارات"},{"$f":"+D69","v":"تأمينات للغيرتأمين نهائي\nعملية القطار السريع اتجاه العاصمة الإدارية"},{"$f":"+D70","v":"تعلي"},{"$f":"+D71","v":"تعلي"},{"$f":"+D72","v":"تعلي"},"غرامات وتعويضات",null,null,null,null,null,null,null,null,null,"ايرادات متنوعة","موارد ذاتية",null,null,{"$f":"+D87","v":"اخري"},null,"الضرائب","تأمينات","وحدة العمالة","المستحق للمقاول"]
[null,null,null,null,null,"الأعمال",null,{"$f":"MROUND(I43-G44,1)","v":8391824},null,null,null,null,{"$f":"+N43-N44","v":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":"+D73","v":"غرامة تأخير"},{"$f":"+D74","v":"مهندس"},{"$f":"+D75","v":"مدير المشروع"},{"$f":"+D76","v":"علامات ارشادية وتحذيرية"},{"$f":"+D77","v":"خصم سيارة"},{"$f":"+D78","v":"خصم بوليصة تأمين"},{"$f":"+D79","v":"استراحة"},{"$f":"+D80","v":"تقارير"},{"$f":"+D81","v":"تعليمات الامن الصناعي"},{"$f":"+D82","v":"معدات"},{"$f":"+D83","v":"م . أ معامل"},{"$f":"+D84","v":"رسوم معمل"},{"$f":"+D85","v":"مصاريف معمل"},{"$f":"+D86","v":"تصنيع علامات"}]
[null,null,{"$f":"H45","v":8391824},"اجمالي الاعمال",null,null,null,null,null,null,null,null,{"$f":"+M42+M45","v":5805825},"الاجمالي",null,null,null,null,null,null,1,{"$f":"+C46","v":8391824},{"$f":"+C48","v":0},"2019-02-17",{"$f":"+C54","v":273018.90000000002},{"$f":"+C55","v":125205},{"$f":"+C56","v":0},{"$f":"+C58","v":0},{"$f":"+C59","v":52004},{"$f":"+C60","v":0},{"$f":"+C61","v":0},{"$f":"+C62","v":0},{"$f":"+C63","v":142359.9},{"$f":"+C64","v":0},{"$f":"+C65","v":0},{"$f":"+C66","v":0},{"$f":"+C67","v":0},{"$f":"+C68","v":0},{"$f":"+C69","v":0},{"$f":"+C70","v":0},{"$f":"+C71","v":0},{"$f":"+C72","v":0},{"$f":"+E73","v":0},{"$f":"+C74","v":0},{"$f":"+C75","v":0},{"$f":"+C76","v":0},{"$f":"+C77","v":0},{"$f":"+C78","v":0},{"$f":"+C79","v":0},{"$f":"+C80","v":0},{"$f":"+C81","v":0},{"$f":"+C82","v":0},{"$f":"+C83","v":0},{"$f":"+C84","v":0},{"$f":"+C85","v":0},{"$f":"+C86","v":0},{"$f":"+C87","v":0},{"$f":"SUM(Y46:BE46)","v":592587.80000000005},{"$f":"+C92","v":260018},{"$f":"+C93","v":0},{"$f":"+C94","v":0},{"$f":"+C95","v":4607772.2}]
[null,null,2931446,"الاعمال السابقة",null,null,null,null,null,null,null,null,{"$f":"+M46-C48","v":5805825},"نتيجة التحقيق"]
[]
[]
[]
[null,2665807,{"$f":"C46-C47","v":5460378},"قيمة المستخلص"]
[null,null,null,null,null,null,null,null,null,null,null,"قيمة المستخلص","التأمينات",null,"القيمة الفعلية"]
[null,null,"الاستقطاعات",null,null,null,null,null,null,{"$f":"+K53-O53","v":0},{"$f":"+L53/1.05*2.16%","v":0},{"$f":"+C48","v":0},2.16,null,null,{"$f":"+O53-K53","v":0}]
[null,null,{"$f":"ROUND((C51*0.05),1)","v":273018.90000000002},"ضمان اعمال",null,null,null,null,null,{"$f":"+K54-O54","v":0},{"$f":"+L54/1.05*3.6%","v":0},null,null,null,null,{"$f":"+O54-K54","v":0}]
[null,null,{"$f":"ROUND((((C51-10050-C92)*2.4%)+638),0)","v":125205},"دمغات",null,null,null,null,null,{"$f":"+K55-O55","v":0},{"$f":"+L55/1.05*4.5%","v":0},null,null,null,null,0]
[null,null,null,"ض م 14% معامل",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"اتساع "]
[null,null,null,"تنمية"]
[null,{"$f":"ROUND(((C51-C92)*1%),0)","v":52004},{"$f":"B59","v":52004},"ا ت ص 1%",null,null,null,null,null,null,null,{"$f":"SUM(L53:L58)","v":0},null,null,{"$f":"SUM(O53:O58)","v":0}]
[null,null,null,"دفعة مقدمة",null,null,null,null,null,null,null,{"$f":"+L59-C48","v":0}]
[null,null,null,"محاجر"]
[null,null,null,"مهن هندسية"]
[null,null,{"$f":"ROUND((C51*2.7375%/1.05),1)","v":142359.9},"تعليه التأمينات"]
[null,null,null,"تعلي لحين ورود نتائج الاختبارات"]
[null,null,null,"تعلية 5 % لحين الاستلام"]
[null,null,null,"تعلية توريد ماسح ضوئي"]
[null,null,null,"تعلية "]
[null,null,null,"تعليه لحين انهاء الاختبارات"]
[null,null,null,"تأمينات للغيرتأمين نهائي\nعملية القطار السريع اتجاه العاصمة الإدارية"]
[null,null,null,"تعلي"]
[null,null,null,"تعلي"]
[null,null,null,"تعلي"]
[null,null,0,"غرامة تأخير",{"$f":"ROUND((+C48*0.02),0)","v":0}]
[null,null,null,"مهندس"]
[null,null,null,"مدير المشروع"]
[null,null,null,"علامات ارشادية وتحذيرية",null,"عدد ايام المستخلص",{"$f":"(J20-C20)+1","v":9}]
[null,{"$f":"G76*G77","v":4500},null,"خصم سيارة",null,"غرامة السيارة يوميا",500]
[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,"اخري"]
[null,null,{"$f":"SUM(C54:C87)","v":592587.80000000005},"الاجمالي",null,254854.6,{"$f":"C88-F88","v":337733.20000000007}]
[]
[]
[null,null,{"$f":"C51-C88","v":4867790.2},"صافي المستخلص"]
[null,null,{"$f":"ROUND((+C51/1.05*5%),1)","v":260018},"مصلحة الضرائب"]
[null,null,null,"تأمينات السويس"]
["تفجير",null,null,"ابوزعبل للكيماويات المتخصصة",{"$f":"+(C48-C92)*0.45%","v":-1170.0810000000001}]
[null,null,{"$f":"+C91-C92-C93-C94","v":4607772.2},"بنك المصرف المتحد"]
[]
[]
[null,null,null,null,null,"الموضوع  :",{"$f":"C2","v":"م (   ) أعمال "}]
[]
[null,null,"الإدارة العامة للشئون المالية",null,null,"المستحق له  :",{"$f":"K2","v":"\n شركة "}]
[null,null,"قيد بدفتر الصرفيات / تسويات (224) رقم                                                                              بتاريخ      /   /      "]
[null,null,"الجهة الوارد منها :                                                                                                                    رقم 55 ع ح :                  تاريخ   "]
[null,null,"البيان",null,"منه",null,"له"]
[null,null,null,null,"جزئي","كلي","جزئي","كلي"]
[]
[null,null,"                من   ح /الدائنين",null,{"$f":"+C51","v":5460378}]
[null,null,null,"حياة كريمة",null,{"$f":"+E106","v":5460378}]
[null,null,"الي مذكورين"]
[null,null,"ح / الدائنين"]
[null,null,"مصلحة الضرائب",null,null,null,{"$f":"+C111+C112+C113+C114+C115","v":177209}]
[null,null,{"$f":"+C55","v":125205},{"$f":"+D55","v":"دمغات"}]
[null,null,{"$f":"+C56","v":0},{"$f":"+D56","v":"ض م 14% معامل"}]
[null,null,{"$f":"+C59","v":52004},{"$f":"+D59","v":"ا ت ص 1%"}]
[null,null,{"$f":"C57","v":0},"اتساع"]
[null,null,{"$f":"C58","v":0},"تنمية"]
[null,null,{"$f":"+D54","v":"ضمان اعمال"},null,null,null,{"$f":"+C54","v":273018.90000000002}]
[null,null,{"$f":"C69","v":0},{"$f":"D69","v":"تأمينات للغيرتأمين نهائي\nعملية القطار السريع اتجاه العاصمة الإدارية"},null,null,{"$f":"C117","v":0}]
[null,null,"ارصدة دائنة متنوعة",null,null,null,{"$f":"SUM(C119:C132)","v":142359.9}]
[null,null,{"$f":"+C61","v":0},"محاجر"]
[null,null,{"$f":"+C62","v":0},"مهن هندسية"]
[null,null,142359.9,"تعليه التأمينات"]
[null,null,0,"تعلي لحين ورود نتائج الاختبارات"]
[null,null,0,"تعلية 5 % لحين الاستلام"]
[null,null,0,"تعلية توريد ماسح ضوئي"]
[null,null,0,"تعلية "]
[null,null,0,"تعليه لحين انهاء الاختبارات"]
[null,null,{"$f":"+C70","v":0},"تعلي"]
[null,null,0,"تعلي"]
[null,null,0,"تعلي"]
[null,null,{"$f":"+C84","v":0},"رسوم معمل"]
[null,null,0,"مصاريف معمل"]
[null,null,0,"تصنيع علامات"]
[null,null,null,null,null,null,null,{"$f":"SUM(G110:G132)","v":592587.80000000005}]
[null,null,null,"ح / الإيرادات"]
[null,null,null,"غرامات وتعويضات",null,null,{"$f":"SUM(C136:C145)","v":0}]
[null,null,{"$f":"+C73","v":0},{"$f":"+D73","v":"غرامة تأخير"}]
[null,null,0,"مهندس"]
[null,null,0,"مدير المشروع"]
[null,null,0,"علامات ارشادية وتحذيرية"]
[null,null,0,"خصم سيارة"]
[null,null,0,"خصم بوليصة تأمين"]
[null,null,0,"استراحة"]
[null,null,0,"تقارير"]
[null,null,0,"تعليمات الامن الصناعي"]
[null,null,0,"معدات"]
[null,null,0,"إيرادات متنوعة",null,null,{"$f":"SUM(C147:C148)","v":0}]
[null,null,{"$f":"+C83","v":0},{"$f":"+D83","v":"م . أ معامل"}]
[null,null,{"$f":"+C87","v":0},{"$f":"+D87","v":"اخري"}]
[null,null,null,null,null,null,null,{"$f":"SUM(G135:G148)","v":0}]
[null,null,"ح / امر الدفع"]
[null,null,{"$f":"+C92","v":260018},"مصلحة الضرائب",null,null,{"$f":"SUM(C151:C154)","v":4867790.2}]
[null,null,0,"تأمينات السويس"]
[null,null,0,"ابوزعبل للكيماويات المتخصصة"]
[null,null,{"$f":"+C95","v":4607772.2},"بنك المصرف المتحد"]
[null,null,null,null,null,null,null,{"$f":"SUM(G151:G154)","v":4867790.2}]
[null,null,null,null,null,{"$f":"SUM(F107:F155)","v":5460378},null,{"$f":"SUM(H107:H155)","v":5460378}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F156-H156","v":0}]