{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["إجمالى","مقاولة 1","مقاولة 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["اسم المقاول","نوع الاعمال","رقم المشروع","رقم المستخلص","فترة المشروع","صافي أعمال الفترة  6","خصم ضمان اعمال نهائي   7","خصم ضرائب منبع  8","خصومات تمت بالموقع  9","خصم ما سبق صرفه من المكتب  10","اضافة مقطوعية","صافى المستخلص الحالي   11"]
["اسم المقاول : حسن   ","نوع الاعمال: أعمــال البيــاض  ","مشروع 1  ","مستخلص رقم : جاري (1)  ","المـــدة : من 2019/09/01  حتى 2019/09/15   ",21600,-1080,-648,0,0,null,19872]
["اسم المقاول : حسن","نوع الاعمال: أعمــال البيــاض","مشروع 1","مستخلص رقم : جاري (2)","المـــدة : من 2019/09/16  حتى 2019/09/25",51200,-2560,-1536,0,0,null,47104]
["اسم المقاول : حسن","نوع الاعمال: أعمــال البيــاض","مشروع 1","مستخلص رقم : جاري (3)","المـــدة : من 2019/09/25  حتى 2019/10/10",38656,-1932.8000000000002,-1159.7,-1025,0,5850,40388.5]
["اسم المقاول : حسن","نوع الاعمال: أعمــال البيــاض","مشروع 1","مستخلص رقم : جاري (4)","المـــدة : من 2019/10/10  حتى 2019/10/24",77676,-3883.8,-2330.2999999999997,-1125,0,3601,73937.899999999994]
["اسم المقاول : حسن","نوع الاعمال: أعمــال البيــاض","مشروع 1","مستخلص رقم : جاري (5)","المـــدة : من 2019/10/24  حتى 2019/11/07",73674.159975000017,-3683.707998750001,-2210.2047992500006,-500,null,-73936.899999999994,-6656.6528229999822]
["اسم المقاول : حسن","نوع الاعمال: أعمــال البيــاض","مشروع 1","مستخلص رقم : جاري ( 6 )","المـــدة : من 2019/11/07  حتى 2019/11/23",59306.329183749971,-2965.3164591874988,-1779.1598755124992,0,0,0,54561.852849049974]
["اسم المقاول: عصام ","نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )","مشروع 2","مستخلص رقم : جاري ( 1 )","المدة: من 2019/11/01  حتى 2020/01/01",11250,-562.5,-337.5,0,0,0,10350]
["اسم المقاول: عصام ","نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )","مشروع 2","مستخلص رقم : جاري ( 2 )","المدة: من 2020/01/02  حتى 2020/01/30",20250,-1012.5,-607.5,0,0,0,18630]
["اسم المقاول: عصام ","نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )","مشروع 2","مستخلص رقم : جاري ( 3 )","المدة: من 2020/01/31  حتى 2020/02/27",13900,-695,-417,0,0,0,12788]
["اسم المقاول: عصام ","نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )","مشروع 2","مستخلص رقم : جاري ( 4 )","المدة: من 2020/02/27  حتى 2020/03/12",14812,-740.6,-444.34999999999997,0,0,0,13627.05]

{"sheet":"مقاولة 1","index":1,"n_rows":202,"n_cols":17,"rows_kept":202,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["اسم المقاول : حسن   ",null,"مشروع 1  "]
["نوع الاعمال: أعمــال البيــاض  ",null,"مستخلص رقم : جاري (1)  ",null,null,null,"المـــدة : من 2019/09/01  حتى 2019/09/15   "]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمترالمسطح مصنعيات بياض داخلي لزوم الحوائط والاسقف والمداخل والسلالم                                ","م2",15500,32,null,0,{"$f":"I5-G5","v":900},900,null,{"$f":"H5*E5","v":28800},{"$f":"I5*E5","v":28800},null,0.75,{"$f":"L5*(1-N5)","v":7200},{"$f":"L5-O5","v":21600}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K22)","v":28800},{"$f":"SUM(L5:L22)","v":28800},null,null,{"$f":"SUM(O1:O22)","v":7200},{"$f":"SUM(P5:P22)","v":21600},{"$f":"P23-#REF!","v":{"$error":"#REF!"}}]
[null,"صافي أعمال الفترة  6",null,{"$f":"P23","v":21600}]
[1,"خصم ضمان اعمال نهائي   7",0.05,{"$f":"-D24*C25","v":-1080},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P23*C25","v":-1080}]
[2,"خصم ضرائب منبع  8",0.03,{"$f":"-D24*C26","v":-648},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P23*C26","v":-648}]
[3,"خصومات تمت بالموقع  9",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"خصم ما سبق صرفه من المكتب  10",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"صافى المستخلص الحالي   11",null,{"$f":"SUM(D24:E28)","v":19872},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P23:P28)","v":19872}]
[]
[null,"المقـــــــــاول","        المحـــاسب",null,null,null,"       مراجع الحســـابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطــاع المالى"]
[]
[null,"....................................................................",".................................................",null,null,null,".................................................",null,null,"....................................................",null,null,null,"............................................................"]
["اسم المقاول : حسن",null,"مشروع 1"]
["نوع الاعمال: أعمــال البيــاض",null,"مستخلص رقم : جاري (2)",null,null,null,"المـــدة : من 2019/09/16  حتى 2019/09/25"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمترالمسطح مصنعيات بياض داخلي لزوم الحوائط والاسقف والمداخل والسلالم                                ","م2",15500,32,null,900,{"$f":"I38-G38","v":2600},3500,null,{"$f":"H38*E38","v":83200},{"$f":"I38*E38","v":112000},null,0.65,{"$f":"L38*(1-N38)","v":39200},{"$f":"L38-O38","v":72800}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K38:K55)","v":83200},{"$f":"SUM(L38:L55)","v":112000},null,null,{"$f":"SUM(O34:O55)","v":39200},{"$f":"SUM(P38:P55)","v":72800},{"$f":"P56-P23","v":51200}]
[null,"صافي أعمال الفترة",null,{"$f":"Q56","v":51200}]
[1,"خصم ضمان اعمال نهائي",0.05,{"$f":"-D57*C58","v":-2560},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P56*C58","v":-3640}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D57*C59","v":-1536},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P26+D59","v":-2184}]
[3,"خصومات تمت بالموقع",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-19872","v":-19872}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D57:E61)","v":47104},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P56:P61)","v":47104}]
[]
[null,"المقـــــــــاول","        المحـــاسب",null,null,null,"       مراجع الحســـابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطــاع المالى"]
[]
[null,"....................................................................",".................................................",null,null,null,".................................................",null,null,"....................................................",null,null,null,"............................................................"]
["اسم المقاول : حسن",null,"مشروع 1"]
["نوع الاعمال: أعمــال البيــاض",null,"مستخلص رقم : جاري (3)",null,null,null,"المـــدة : من 2019/09/25  حتى 2019/10/10"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمترالمسطح مصنعيات بياض داخلي لزوم الحوائط والاسقف والمداخل والسلالم                                ","م2",15500,32,null,3500,{"$f":"I71-G71","v":1900},5400,null,{"$f":"H71*E71","v":60800},{"$f":"I71*E71","v":172800},null,0.64500000000000002,{"$f":"L71*(1-N71)","v":61344},{"$f":"L71-O71","v":111456}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K71:K88)","v":60800},{"$f":"SUM(L71:L88)","v":172800},null,null,{"$f":"SUM(O67:O88)","v":61344},{"$f":"SUM(P71:P88)","v":111456},{"$f":"P89-P56","v":38656}]
[null,"صافي أعمال الفترة",null,{"$f":"Q89","v":38656}]
[1,"خصم ضمان اعمال نهائي",0.05,{"$f":"-D90*C91","v":-1932.8000000000002},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P89*C91","v":-5572.8}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D90*C92-0.02","v":-1159.7},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P59+D92","v":-3343.7}]
[3,"خصم قيمة استلام مهمات امان صناعي بالموقع ",null,{"$f":"-1025","v":-1025},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-1025","v":-1025}]
[4,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,5850]
[5,"اضافة مقطوعية اعمال التلبيش بالخصم على مقاولي الباطن عصام خيري",null,5850,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-66976","v":-66976}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D90:E95)","v":40388.5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P89:P95)","v":40388.5}]
[]
[null,"المقـــــــــاول","        المحـــاسب",null,null,null,"       مراجع الحســـابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطــاع المالى"]
[]
[null,"....................................................................",".................................................",null,null,null,".................................................",null,null,"....................................................",null,null,null,"............................................................"]
["اسم المقاول : حسن",null,"مشروع 1"]
["نوع الاعمال: أعمــال البيــاض",null,"مستخلص رقم : جاري (4)",null,null,null,"المـــدة : من 2019/10/10  حتى 2019/10/24"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمترالمسطح مصنعيات بياض داخلي لزوم الحوائط والاسقف والمداخل والسلالم                                ","م2",15500,32,null,5400,{"$f":"I105-G105","v":6500},11900,null,{"$f":"H105*E105","v":208000},{"$f":"I105*E105","v":380800},null,0.39,{"$f":"L105*(1-N105)","v":232288},{"$f":"L105-O105","v":148512}]
[2,"بالمترالمسطح مصنعيات بياض داخلي لزوم الواجهات                                ","م2",2220,40,null,0,{"$f":"I106-G106","v":1500},1500,null,{"$f":"H106*E106","v":60000},{"$f":"I106*E106","v":60000},null,0.38,{"$f":"L106*(1-N106)","v":37200},{"$f":"L106-O106","v":22800}]
[3,"بالمتر المسطح اعمال مصنعيات طرطشة اسفل حجر الهاشمة","م2",0,10,null,0,{"$f":"I107-G107","v":4050},4050,null,{"$f":"I107*E107","v":40500},{"$f":"I107*E107","v":40500},null,0.44,{"$f":"L107*(1-N107)","v":22680.000000000004},{"$f":"L107-O107","v":17819.999999999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K105:K122)","v":308500},{"$f":"SUM(L105:L122)","v":481300},null,null,{"$f":"SUM(O101:O122)","v":292168},{"$f":"SUM(P105:P122)","v":189132},{"$f":"P123-P89","v":77676}]
[null,"صافي أعمال الفترة",null,{"$f":"Q123","v":77676}]
[1,"خصم ضمان اعمال نهائي",0.05,{"$f":"-D124*C125","v":-3883.8},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P123*C125","v":-9456.6}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D124*C126-0.02","v":-2330.2999999999997},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P92+D126","v":-5674}]
[3,"خصم قيمة استلام مهمات امان صناعي بالموقع ",null,-1125,null,null,null,null,null,null,null,null,null,null,null,-2150]
[4,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,9450]
[5,"اضافة مقطوعية اعمال التلبيش بالخصم على مقاولي الباطن ",null,3601,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-19872-47104-40388.5","v":-107364.5}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D124:E129)","v":73937.899999999994},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P123:P129)","v":73936.899999999994}]
[]
[null,"المقـــــــــاول","        المحـــاسب",null,null,null,"       مراجع الحســـابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطــاع المالى"]
[]
[null,"....................................................................",".................................................",null,null,null,".................................................",null,null,"....................................................",null,null,null,"............................................................"]
["اسم المقاول : حسن",null,"مشروع 1"]
["نوع الاعمال: أعمــال البيــاض",null,"مستخلص رقم : جاري (5)",null,null,null,"المـــدة : من 2019/10/24  حتى 2019/11/07"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمترالمسطح مصنعيات بياض داخلي لزوم الحوائط والاسقف والمداخل والسلالم                                ","م2",15500,32,null,11900,{"$f":"I139-G139","v":0},11900,null,{"$f":"H139*E139","v":0},{"$f":"I139*E139","v":380800},null,0.438612,{"$f":"L139*(1-N139)","v":213776.55040000001},{"$f":"L139-O139","v":167023.44959999999}]
[2,"بالمترالمسطح مصنعيات بياض خارجي  لزوم الواجهات                                ","م2",2220,40,null,1500,{"$f":"I140-G140","v":1125},2625,null,{"$f":"H140*E140","v":45000},{"$f":"I140*E140","v":105000},null,0.59904999999999997,{"$f":"L140*(1-N140)","v":42099.75},{"$f":"L140-O140","v":62900.25}]
[3,"بالمتر المسطح اعمال مصنعيات طرطشة اسفل حجر الهاشمة","م2",0,10,null,4050,{"$f":"I141-G141","v":0},4050,null,{"$f":"H141*E141","v":0},{"$f":"I141*E141","v":40500},null,0.61777700000000002,{"$f":"L141*(1-N141)","v":15480.031499999999},{"$f":"L141-O141","v":25019.968500000003}]
[4,"علاوة مصنعيات بياض خارجي  لزوم الواجهات                                ","م2",2220,5,null,0,{"$f":"I142-G142","v":2625},2625,null,{"$f":"H142*E142","v":13125},{"$f":"I142*E142","v":13125},null,0.599047,{"$f":"L142*(1-N142)","v":5262.5081250000003},{"$f":"L142-O142","v":7862.4918749999997}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K139:K156)","v":58125},{"$f":"SUM(L139:L156)","v":539425},null,null,{"$f":"SUM(O135:O156)","v":276618.84002499998},{"$f":"SUM(P139:P156)","v":262806.15997500002},{"$f":"P157-P123","v":73674.159975000017}]
[null,"صافي أعمال الفترة",null,{"$f":"Q157","v":73674.159975000017}]
[1,"خصم ضمان اعمال نهائي",0.05,{"$f":"-D158*C159","v":-3683.707998750001},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P157*C159","v":-13140.307998750002}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D158*C160+0.02","v":-2210.2047992500006},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P126+D160","v":-7884.2047992500011}]
[3,"خصم قيمة استلام مهمات امان صناعي بالموقع ",null,{"$f":"P161-P127","v":-500},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-2150-500","v":-2650}]
[4,"خصم ما سبق صرفه من المكتب",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"9450+10200","v":19650}]
[5,"اضافة مقطوعية اعمال التلبيش بالخصم على مقاولي الباطن ",null,{"$f":"P163-P129","v":-73936.899999999994},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-19872-47104-40388.5-73936.9","v":-181301.4}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D158:E163)","v":-6656.6528229999822},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P157:P163)","v":77480.247177000012}]
[]
[null,"المقـــــــــاول","        المحـــاسب",null,null,null,"       مراجع الحســـابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطــاع المالى"]
[]
[null,"....................................................................",".................................................",null,null,null,".................................................",null,null,"....................................................",null,null,null,"............................................................"]
["اسم المقاول : حسن",null,"مشروع 1"]
["نوع الاعمال: أعمــال البيــاض",null,"مستخلص رقم : جاري ( 6 )",null,null,null,"المـــدة : من 2019/11/07  حتى 2019/11/23"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمترالمسطح مصنعيات بياض داخلي لزوم الحوائط والاسقف والمداخل والسلالم                                ","م2",15500,32,null,11900,{"$f":"I173-G173","v":0},11900,null,{"$f":"H173*E173","v":0},{"$f":"I173*E173","v":380800},null,0.49264704999999998,{"$f":"L173*(1-N173)","v":193200.00336},{"$f":"L173-O173","v":187599.99664}]
[2,"بالمترالمسطح مصنعيات بياض خارجي  لزوم الواجهات                                ","م2",2220,40,null,2625,{"$f":"I174-G174","v":0},2625,null,{"$f":"H174*E174","v":0},{"$f":"I174*E174","v":105000},null,0.84285710000000003,{"$f":"L174*(1-N174)","v":16500.004499999999},{"$f":"L174-O174","v":88499.995500000005}]
[3,"بالمتر المسطح اعمال مصنعيات طرطشة اسفل حجر الهاشمة","م2",0,10,null,4050,{"$f":"I175-G175","v":0},4050,null,{"$f":"H175*E175","v":0},{"$f":"I175*E175","v":40500},null,0.86296289999999998,{"$f":"L175*(1-N175)","v":5550.0025500000011},{"$f":"L175-O175","v":34949.997449999995}]
[4,"علاوة مصنعيات بياض خارجي  لزوم الواجهات                                ","م2",2220,5,null,2625,{"$f":"I176-G176","v":0},2625,null,{"$f":"H176*E176","v":0},{"$f":"I176*E176","v":13125},null,0.84285710999999996,{"$f":"L176*(1-N176)","v":2062.5004312500005},{"$f":"L176-O176","v":11062.49956875}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K173:K190)","v":0},{"$f":"SUM(L173:L190)","v":539425},null,null,{"$f":"SUM(O169:O190)","v":217312.51084125001},{"$f":"SUM(P173:P190)","v":322112.48915874999},{"$f":"P191-P157","v":59306.329183749971}]
[null,"صافي أعمال الفترة",null,{"$f":"Q191","v":59306.329183749971}]
[1,"خصم ضمان اعمال نهائي",0.05,{"$f":"-D192*C193","v":-2965.3164591874988},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P191*C193","v":-16105.6244579375}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D192*C194+0.03","v":-1779.1598755124992},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P160+D194","v":-9663.3646747625007}]
[3,"خصم قيمة استلام مهمات امان صناعي بالموقع ",null,{"$f":"P195-P161","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-2150-500","v":-2650}]
[4,"اضافة مقطوعية اعمال التلبيش بالخصم على مقاولي الباطن ",null,{"$f":"P196-P162","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"9450+10200","v":19650}]
[5,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-19872-47104-40388.5-73936.9-77480.25","v":-258781.65}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D192:E197)","v":54561.852849049974},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P191:P197)","v":54561.85002605003}]
[]
[null,"المقـــــــــاول","        المحـــاسب",null,null,null,"       مراجع الحســـابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطــاع المالى"]
[]
[null,"....................................................................",".................................................",null,null,null,".................................................",null,null,"....................................................",null,null,null,"............................................................"]

{"sheet":"مقاولة 2","index":2,"n_rows":137,"n_cols":17,"rows_kept":137,"cut":false,"hidden":false,"merged":[[103,0,103,1],[104,0,104,1]]}
["اسم المقاول: عصام ",null,"مشروع 2"]
["نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )",null,"مستخلص رقم : جاري ( 1 )",null,null,null,"المدة: من 2019/11/01  حتى 2020/01/01"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمتر المسطح : مصنعيات  محارة لزوم الواجهات الخارجية","م2",2000,45,null,0,{"$f":"I5-G5","v":1000},1000,null,{"$f":"E5*H5","v":45000},{"$f":"E5*I5","v":45000},null,0.25,{"$f":"L5*(1-N5)","v":33750},{"$f":"L5-O5","v":11250}]
[2,"بالمتر الطولي  : مصنعيات عراميس لزوم الواجهات الخارجية","م . ط",null,10,null,0,{"$f":"I6-G6","v":0},0,null,{"$f":"E6*H6","v":0},{"$f":"E6*I6","v":0},null,1,{"$f":"L6*(1-N6)","v":0},{"$f":"L6-O6","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K22)","v":45000},{"$f":"SUM(L5:L22)","v":45000},null,null,{"$f":"SUM(O5:O22)","v":33750},{"$f":"SUM(P5:P22)","v":11250}]
[null,"صافي أعمال الفترة",null,{"$f":"P23","v":11250}]
[1,"خصم تأمين اعمال نهائى",0.05,{"$f":"-D24*C25","v":-562.5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P23*C25","v":-562.5}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D24*C26","v":-337.5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P23*C26","v":-337.5}]
[3,"خصم قيمة استلام مهمات أمان صناعي بالموقع",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"خصم عدم التزام بتعليمات الامان الصناعي ",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[5,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D24:E29)","v":10350},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P23:P29)","v":10350}]
[]
[null,"المقاول","المحاسب",null,null,null,"مراجع الحسابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطاع المالى"]
[]
[null,"………………………………………………………","…………………………………………….",null,null,null,"…………………………………………..",null,null,"…………………………………….",null,null,null,"……………………………………………….."]
["اسم المقاول: عصام ",null,"مشروع 2"]
["نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )",null,"مستخلص رقم : جاري ( 2 )",null,null,null,"المدة: من 2020/01/02  حتى 2020/01/30"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمتر المسطح : مصنعيات  محارة لزوم الواجهات الخارجية","م2",2000,45,null,1000,{"$f":"I39-G39","v":0},1000,null,{"$f":"E39*H39","v":0},{"$f":"E39*I39","v":45000},null,0.7,{"$f":"L39*(1-N39)","v":13500.000000000002},{"$f":"L39-O39","v":31500}]
[2,"بالمتر الطولي  : مصنعيات عراميس لزوم الواجهات الخارجية","م . ط",null,10,null,0,{"$f":"I40-G40","v":0},0,null,{"$f":"E40*H40","v":0},{"$f":"E40*I40","v":0},null,1,{"$f":"L40*(1-N40)","v":0},{"$f":"L40-O40","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K39:K56)","v":0},{"$f":"SUM(L39:L56)","v":45000},null,null,{"$f":"SUM(O39:O56)","v":13500.000000000002},{"$f":"SUM(P39:P56)","v":31500},{"$f":"P57-P23","v":20250}]
[null,"صافي أعمال الفترة",null,{"$f":"Q57","v":20250}]
[1,"خصم تأمين اعمال نهائى",0.05,{"$f":"-D58*C59","v":-1012.5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P57*C59","v":-1575}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D58*C60","v":-607.5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P26+D60","v":-945}]
[3,"خصم قيمة استلام مهمات أمان صناعي بالموقع",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"خصم عدم التزام بتعليمات الامان الصناعي ",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[5,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-10350","v":-10350}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D58:E63)","v":18630},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P57:P63)","v":18630}]
[]
[null,"المقاول","المحاسب",null,null,null,"مراجع الحسابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطاع المالى"]
[]
[null,"………………………………………………………","…………………………………………….",null,null,null,"…………………………………………..",null,null,"…………………………………….",null,null,null,"……………………………………………….."]
["اسم المقاول: عصام ",null,"مشروع 2"]
["نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )",null,"مستخلص رقم : جاري ( 3 )",null,null,null,"المدة: من 2020/01/31  حتى 2020/02/27"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"بالمتر المسطح : مصنعيات  محارة لزوم الواجهات الخارجية","م2",2000,45,null,1000,{"$f":"I73-G73","v":0},1000,null,{"$f":"E73*H73","v":0},{"$f":"E73*I73","v":45000},null,0.9,{"$f":"L73*(1-N73)","v":4499.9999999999991},{"$f":"L73-O73","v":40500}]
[2,"بالمتر الطولي  : مصنعيات عراميس لزوم الواجهات الخارجية","م . ط",null,10,null,0,{"$f":"I74-G74","v":700},700,null,{"$f":"E74*H74","v":7000},{"$f":"E74*I74","v":7000},null,0.7,{"$f":"L74*(1-N74)","v":2100.0000000000005},{"$f":"L74-O74","v":4900}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K73:K90)","v":7000},{"$f":"SUM(L73:L90)","v":52000},null,null,{"$f":"SUM(O73:O90)","v":6600},{"$f":"SUM(P73:P90)","v":45400},{"$f":"P91-P57","v":13900}]
[null,"صافي أعمال الفترة",null,{"$f":"Q91","v":13900}]
[1,"خصم تأمين اعمال نهائى",0.05,{"$f":"-D92*C93","v":-695},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P91*C93","v":-2270}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D92*C94","v":-417},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P60+D94","v":-1362}]
[3,"خصم قيمة استلام مهمات أمان صناعي بالموقع",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"خصم عدم التزام بتعليمات الامان الصناعي ",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[5,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-10350-18630","v":-28980}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D92:E97)","v":12788},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P91:P97)","v":12788}]
[]
[null,"المقاول","المحاسب",null,null,null,"مراجع الحسابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطاع المالى"]
[]
[null,"………………………………………………………","…………………………………………….",null,null,null,"…………………………………………..",null,null,"…………………………………….",null,null,null,"……………………………………………….."]
[]
["اسم المقاول: عصام ",null,"مشروع 2"]
["نوع الاعمال:  اعمال بياض محارة عمارة رقم ( 12 )",null,"مستخلص رقم : جاري ( 4 )",null,null,null,"المدة: من 2020/02/27  حتى 2020/03/12"]
["بيانات الاعمال بالعقد",null,null,null,null,null,"كميات الاعمال المنفذة",null,null,null,"قيمة الاعمال المنفذة",null,null,"المبالغ المستحقة الصرف"]
["م","البند","الوحدة","الكمية","الفئة",null,"السابقة","الحالية","الاجمالى",null,"الحالية","الاجمالى",null,"نسبة الاتمام","المتبقي للاتمام","الصافى"]
[1,"مصنعيات  محارة لزوم الواجهات الخارجية ( الجزء الأيمن - واجهة جانبية شرقية )","م2",2000,45,null,1000,{"$f":"I108-G108","v":0},1000,null,{"$f":"E108*H108","v":0},{"$f":"E108*I108","v":45000},null,0.9,{"$f":"L108*(1-N108)","v":4499.9999999999991},{"$f":"L108-O108","v":40500}]
[2,"مصنعيات عراميس لزوم الواجهات الخارجية ( الجزء الأيمن - واجهة جانبية شرقية )","م . ط",1000,10,null,700,0,700,null,0,7000,null,0.9,699.99999999999989,6300]
[3,"مصنعيات  محارة لزوم الواجهات الخارجية ( الجزء الايمن - واجهة خلفية بين محوري M , G )","م2","-",45,null,0,285,285,null,12825,12825,null,0.8,2564.9999999999995,10260]
[4,"مصنعيات عراميس لزوم الواجهات الخارجية ( الجزء الايمن - واجهة خلفية بين محوري M , G )","م . ط","-",10,null,0,44,44,null,440,440,null,0.8,87.999999999999986,352]
[5,"مقطوعية عتب شباك الدور الخامس بين محوري ( 25 و 31 ) - تزريع - تركيب - سلك - تسليخ - محارة )","مقط","-",2000,null,0,1,1,null,2000,2000,null,0.8,399.99999999999989,1600]
[6,"يوميات تلبيش","يومية","-",400,null,0,3,3,null,1200,1200,null,1,0,1200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"الاجمالى",null,null,null,null,null,null,null,null,{"$f":"SUM(K108:K125)","v":16465},{"$f":"SUM(L108:L125)","v":68465},null,null,{"$f":"SUM(O108:O125)","v":8252.9999999999982},{"$f":"SUM(P108:P125)","v":60212},{"$f":"P126-P91","v":14812}]
[null,"صافي أعمال الفترة",null,{"$f":"Q126","v":14812}]
[1,"خصم تأمين اعمال نهائى",0.05,{"$f":"-D127*C128","v":-740.6},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-P126*C128","v":-3010.6000000000004}]
[2,"خصم ضرائب منبع",0.03,{"$f":"-D127*C129+0.01","v":-444.34999999999997},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P94+D129","v":-1806.35}]
[3,"خصم قيمة استلام مهمات أمان صناعي بالموقع",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"خصم عدم التزام بتعليمات الامان الصناعي ",null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[5,"خصم ما سبق صرفه من المكتب",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-10350-18630-12788","v":-41768}]
[null,"صافى المستخلص الحالى",null,{"$f":"SUM(D127:E132)","v":13627.05},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P126:P132)","v":13627.050000000003}]
[]
[null,"المقاول","المحاسب",null,null,null,"مراجع الحسابات",null,null,null,"مدير عام المشروعات",null,null,"رئيس القطاع المالى"]
[]
[null,"………………………………………………………","…………………………………………….",null,null,null,"…………………………………………..",null,null,"…………………………………….",null,null,null,"……………………………………………….."]