{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Report","Details","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Report","index":0,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,10,3,12],[3,0,3,3],[3,5,3,8],[0,14,0,15],[1,0,1,1],[1,2,1,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Balance"]
["Project Name",null,"مشروع xxxx",null,null,null,null,null,null,null,null,null,null,null,"Profit",{"$f":"$M$34","v":1900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loses",{"$f":"$L$34","v":""}]
["Cost , Expenses",null,null,null,null,"Receiving , Revenue",null,null,null,null,"Profit and Lost Report"]
["S.No","Date","Type","Amount",null,"S.No","Date","Type","Amount",null,"Description","Issue","Received"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,B$6:B6))","v":1},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(1:1)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":"2019-05-01"},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(1:1)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":"مصاريف رواتب واجور"},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(1:1)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":500},null,{"$f":"IF(G6=\"\",\"\",SUBTOTAL(3,G$6:G6))","v":1},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(1:1)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":"2019-05-20"},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(1:1)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":"ايراد من عميل"},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(1:1)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":2500},null,{"$f":"IFERROR(IF(Data!B4=\"\",\"\",Data!B4),\"\")","v":"مصاريف رواتب واجور"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K6),\"\")","v":500}]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,B$6:B7))","v":2},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(2:2)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":"2019-05-01"},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(2:2)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":"مصاريف بنزين"},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(2:2)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":100},null,{"$f":"IF(G7=\"\",\"\",SUBTOTAL(3,G$6:G7))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(2:2)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(2:2)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(2:2)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B5=\"\",\"\",Data!B5),\"\")","v":"مصاريف سيارات"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K7),\"\")","v":0}]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,B$6:B8))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(3:3)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(3:3)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(3:3)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G8=\"\",\"\",SUBTOTAL(3,G$6:G8))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(3:3)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(3:3)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(3:3)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B6=\"\",\"\",Data!B6),\"\")","v":"مصاريف نقل"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K8),\"\")","v":0}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,B$6:B9))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(4:4)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(4:4)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(4:4)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G9=\"\",\"\",SUBTOTAL(3,G$6:G9))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(4:4)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(4:4)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(4:4)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B7=\"\",\"\",Data!B7),\"\")","v":"مصاريف بنزين"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K9),\"\")","v":100}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,B$6:B10))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(5:5)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(5:5)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(5:5)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G10=\"\",\"\",SUBTOTAL(3,G$6:G10))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(5:5)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(5:5)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(5:5)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B8=\"\",\"\",Data!B8),\"\")","v":"مصاريف طعام"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K10),\"\")","v":0}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,B$6:B11))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(6:6)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(6:6)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(6:6)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G11=\"\",\"\",SUBTOTAL(3,G$6:G11))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(6:6)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(6:6)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(6:6)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B9=\"\",\"\",Data!B9),\"\")","v":"مصاريف مواد"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K11),\"\")","v":0}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,B$6:B12))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(7:7)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(7:7)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(7:7)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G12=\"\",\"\",SUBTOTAL(3,G$6:G12))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(7:7)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(7:7)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(7:7)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B10=\"\",\"\",Data!B10),\"\")","v":"مصاريف نثرية"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K12),\"\")","v":0}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,B$6:B13))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(8:8)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(8:8)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(8:8)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G13=\"\",\"\",SUBTOTAL(3,G$6:G13))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(8:8)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(8:8)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(8:8)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B11=\"\",\"\",Data!B11),\"\")","v":"مصاريف حكومية"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K13),\"\")","v":0}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,B$6:B14))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(9:9)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(9:9)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(9:9)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G14=\"\",\"\",SUBTOTAL(3,G$6:G14))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(9:9)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(9:9)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(9:9)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B12=\"\",\"\",Data!B12),\"\")","v":"دفعة لمقاول"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K14),\"\")","v":0}]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,B$6:B15))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(10:10)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(10:10)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(10:10)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G15=\"\",\"\",SUBTOTAL(3,G$6:G15))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(10:10)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(10:10)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(10:10)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B13=\"\",\"\",Data!B13),\"\")","v":"دفعة تحت الحساب"},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K15),\"\")","v":0}]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(3,B$6:B16))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(11:11)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(11:11)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(11:11)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G16=\"\",\"\",SUBTOTAL(3,G$6:G16))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(11:11)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(11:11)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(11:11)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B14=\"\",\"\",Data!B14),\"\")","v":""},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K16),\"\")","v":0}]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,B$6:B17))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(12:12)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(12:12)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(12:12)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G17=\"\",\"\",SUBTOTAL(3,G$6:G17))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(12:12)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(12:12)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(12:12)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B15=\"\",\"\",Data!B15),\"\")","v":""},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K17),\"\")","v":0}]
[{"$f":"IF(B18=\"\",\"\",SUBTOTAL(3,B$6:B18))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(13:13)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(13:13)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(13:13)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G18=\"\",\"\",SUBTOTAL(3,G$6:G18))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(13:13)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(13:13)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(13:13)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B16=\"\",\"\",Data!B16),\"\")","v":""},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K18),\"\")","v":0}]
[{"$f":"IF(B19=\"\",\"\",SUBTOTAL(3,B$6:B19))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(14:14)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(14:14)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(14:14)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G19=\"\",\"\",SUBTOTAL(3,G$6:G19))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(14:14)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(14:14)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(14:14)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B17=\"\",\"\",Data!B17),\"\")","v":""},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K19),\"\")","v":0}]
[{"$f":"IF(B20=\"\",\"\",SUBTOTAL(3,B$6:B20))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(15:15)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(15:15)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(15:15)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G20=\"\",\"\",SUBTOTAL(3,G$6:G20))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(15:15)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(15:15)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(15:15)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B18=\"\",\"\",Data!B18),\"\")","v":""},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K20),\"\")","v":0}]
[{"$f":"IF(B21=\"\",\"\",SUBTOTAL(3,B$6:B21))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(16:16)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(16:16)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(16:16)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G21=\"\",\"\",SUBTOTAL(3,G$6:G21))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(16:16)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(16:16)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(16:16)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!B19=\"\",\"\",Data!B19),\"\")","v":""},{"$f":"IFERROR(SUMIFS(Cost_Report[Amount],Cost_Report[Type],K21),\"\")","v":0}]
[{"$f":"IF(B22=\"\",\"\",SUBTOTAL(3,B$6:B22))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(17:17)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(17:17)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(17:17)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G22=\"\",\"\",SUBTOTAL(3,G$6:G22))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(17:17)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(17:17)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(17:17)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,"Total Expensis",{"$f":"SUM(L6:L21)","v":600},{"$f":"SUM(M6:M21)","v":0}]
[{"$f":"IF(B23=\"\",\"\",SUBTOTAL(3,B$6:B23))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(18:18)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(18:18)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(18:18)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G23=\"\",\"\",SUBTOTAL(3,G$6:G23))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(18:18)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(18:18)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(18:18)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H4=\"\",\"\",Data!H4),\"\")","v":"دفعة مستلمة تحت الحساب"},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K23),\"\")","v":0}]
[{"$f":"IF(B24=\"\",\"\",SUBTOTAL(3,B$6:B24))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(19:19)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(19:19)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(19:19)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G24=\"\",\"\",SUBTOTAL(3,G$6:G24))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(19:19)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(19:19)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(19:19)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H5=\"\",\"\",Data!H5),\"\")","v":"ايراد من عميل"},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K24),\"\")","v":2500}]
[{"$f":"IF(B25=\"\",\"\",SUBTOTAL(3,B$6:B25))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(20:20)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(20:20)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(20:20)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G25=\"\",\"\",SUBTOTAL(3,G$6:G25))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(20:20)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(20:20)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(20:20)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H6=\"\",\"\",Data!H6),\"\")","v":""},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K25),\"\")","v":0}]
[{"$f":"IF(B26=\"\",\"\",SUBTOTAL(3,B$6:B26))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(21:21)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(21:21)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(21:21)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G26=\"\",\"\",SUBTOTAL(3,G$6:G26))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(21:21)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(21:21)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(21:21)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H7=\"\",\"\",Data!H7),\"\")","v":""},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K26),\"\")","v":0}]
[{"$f":"IF(B27=\"\",\"\",SUBTOTAL(3,B$6:B27))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(22:22)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(22:22)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(22:22)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G27=\"\",\"\",SUBTOTAL(3,G$6:G27))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(22:22)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(22:22)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(22:22)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H8=\"\",\"\",Data!H8),\"\")","v":""},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K27),\"\")","v":0}]
[{"$f":"IF(B28=\"\",\"\",SUBTOTAL(3,B$6:B28))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(23:23)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(23:23)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(23:23)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G28=\"\",\"\",SUBTOTAL(3,G$6:G28))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(23:23)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(23:23)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(23:23)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H9=\"\",\"\",Data!H9),\"\")","v":""},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K28),\"\")","v":0}]
[{"$f":"IF(B29=\"\",\"\",SUBTOTAL(3,B$6:B29))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(24:24)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(24:24)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(24:24)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G29=\"\",\"\",SUBTOTAL(3,G$6:G29))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(24:24)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(24:24)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(24:24)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H10=\"\",\"\",Data!H10),\"\")","v":""},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K29),\"\")","v":0}]
[{"$f":"IF(B30=\"\",\"\",SUBTOTAL(3,B$6:B30))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(25:25)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(25:25)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(25:25)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G30=\"\",\"\",SUBTOTAL(3,G$6:G30))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(25:25)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(25:25)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(25:25)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H11=\"\",\"\",Data!H11),\"\")","v":""},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K30),\"\")","v":0}]
[{"$f":"IF(B31=\"\",\"\",SUBTOTAL(3,B$6:B31))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(26:26)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(26:26)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(26:26)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G31=\"\",\"\",SUBTOTAL(3,G$6:G31))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(26:26)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(26:26)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(26:26)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(IF(Data!H12=\"\",\"\",Data!H12),\"\")","v":""},null,{"$f":"IFERROR(SUMIFS(Rev_Report[Amount],Rev_Report[Type],K31),\"\")","v":0}]
[{"$f":"IF(B32=\"\",\"\",SUBTOTAL(3,B$6:B32))","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(27:27)),MATCH($B$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(27:27)),MATCH($C$5,Cost_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Cost_Details[[S.No]:[Amount]],SMALL(IF(Cost_Details[[Project]:[Amount]]=$C$2,ROW(Cost_Details[[S.No]:[Amount]])-ROW(Cost_Details[#Headers])),ROW(27:27)),MATCH($D$5,Cost_Details[#Headers],0)),\"\")","v":""},null,{"$f":"IF(G32=\"\",\"\",SUBTOTAL(3,G$6:G32))","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(27:27)),MATCH($G$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(27:27)),MATCH($H$5,Revenue_Details[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Revenue_Details[[S.No]:[Amount]],SMALL(IF(Revenue_Details[[Project]:[Amount]]=$C$2,ROW(Revenue_Details[[S.No]:[Amount]])-ROW(Revenue_Details[#Headers])),ROW(27:27)),MATCH($I$5,Revenue_Details[#Headers],0)),\"\")","v":""},null,"Total Revenue",{"$f":"SUM(L23:L31)","v":0},{"$f":"SUM(M23:M31)","v":2500}]
["Total",null,null,{"$f":"SUBTOTAL(109,Cost_Report[Amount])","v":600},null,"Total",null,null,{"$f":"SUBTOTAL(109,Rev_Report[Amount])","v":2500}]
[null,null,null,null,null,null,null,null,null,null,"Gross Profit & Los",{"$f":"IFERROR(IF(($L$22-$M$32)>0,$L$22-$M$32,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(($L$22-$M$32)<0,$M$32-$L$22,\"\"),\"\")","v":1900}]

{"sheet":"Details","index":1,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,6],[0,8,1,13]]}
["Transaction ( Issue & Expenses )",null,null,null,null,null,null,null,"Transaction ( Receiving & Revenue )"]
[]
["S.No","Project","Date","Column1","Type","Description","Amount",null,"S.No","Project","Date","Type","Descriptions","Amount"]
[{"$f":"IF(C4=\"\",\"\",SUBTOTAL(3,C$4:C4))","v":1},"مشروع xxxx","2019-05-01",null,"مصاريف رواتب واجور","يوميات عدد 3 عمال + 2 فني",500,null,{"$f":"IF(J4=\"\",\"\",SUBTOTAL(3,J$4:J4))","v":1},"مشروع xxxx","2019-05-20","ايراد من عميل","ايراد اعمال تركيب سيراميك بمشروع xxxx نقدا",2500]
[{"$f":"IF(C5=\"\",\"\",SUBTOTAL(3,C$4:C5))","v":2},"مشروع xxxx","2019-05-01",null,"مصاريف بنزين","فاتورة بنزين",100,null,{"$f":"IF(J5=\"\",\"\",SUBTOTAL(3,J$4:J5))","v":2},"مشروع x","2019-05-05","ايراد من عميل","ايراد اعمال تركيب سيراميك بمشروع xxxx نقدا",6000]
[{"$f":"IF(C6=\"\",\"\",SUBTOTAL(3,C$4:C6))","v":3},"مشروع x","2019-05-02",null,"دفعة لمقاول","دفعة عن 500 متر سيراميك",5400,null,{"$f":"IF(J6=\"\",\"\",SUBTOTAL(3,J$4:J6))","v":""}]
[{"$f":"IF(C7=\"\",\"\",SUBTOTAL(3,C$4:C7))","v":4},"مشروع x","2019-05-02",null,"دفعة لمقاول","مصاريف نقل مواد للموقع",1000,null,{"$f":"IF(J7=\"\",\"\",SUBTOTAL(3,J$4:J7))","v":""}]
[{"$f":"IF(C8=\"\",\"\",SUBTOTAL(3,C$4:C8))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",SUBTOTAL(3,J$4:J8))","v":""}]
[{"$f":"IF(C9=\"\",\"\",SUBTOTAL(3,C$4:C9))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",SUBTOTAL(3,J$4:J9))","v":""}]
[{"$f":"IF(C10=\"\",\"\",SUBTOTAL(3,C$4:C10))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",SUBTOTAL(3,J$4:J10))","v":""}]
[{"$f":"IF(C11=\"\",\"\",SUBTOTAL(3,C$4:C11))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J11=\"\",\"\",SUBTOTAL(3,J$4:J11))","v":""}]
[{"$f":"IF(C12=\"\",\"\",SUBTOTAL(3,C$4:C12))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J12=\"\",\"\",SUBTOTAL(3,J$4:J12))","v":""}]
[{"$f":"IF(C13=\"\",\"\",SUBTOTAL(3,C$4:C13))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J13=\"\",\"\",SUBTOTAL(3,J$4:J13))","v":""}]
[{"$f":"IF(C14=\"\",\"\",SUBTOTAL(3,C$4:C14))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J14=\"\",\"\",SUBTOTAL(3,J$4:J14))","v":""}]
[{"$f":"IF(C15=\"\",\"\",SUBTOTAL(3,C$4:C15))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J15=\"\",\"\",SUBTOTAL(3,J$4:J15))","v":""}]
[{"$f":"IF(C16=\"\",\"\",SUBTOTAL(3,C$4:C16))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",SUBTOTAL(3,J$4:J16))","v":""}]
[{"$f":"IF(C17=\"\",\"\",SUBTOTAL(3,C$4:C17))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J17=\"\",\"\",SUBTOTAL(3,J$4:J17))","v":""}]
[{"$f":"IF(C18=\"\",\"\",SUBTOTAL(3,C$4:C18))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J18=\"\",\"\",SUBTOTAL(3,J$4:J18))","v":""}]
[{"$f":"IF(C19=\"\",\"\",SUBTOTAL(3,C$4:C19))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J19=\"\",\"\",SUBTOTAL(3,J$4:J19))","v":""}]
[{"$f":"IF(C20=\"\",\"\",SUBTOTAL(3,C$4:C20))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J20=\"\",\"\",SUBTOTAL(3,J$4:J20))","v":""}]
[{"$f":"IF(C21=\"\",\"\",SUBTOTAL(3,C$4:C21))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J21=\"\",\"\",SUBTOTAL(3,J$4:J21))","v":""}]
[{"$f":"IF(C22=\"\",\"\",SUBTOTAL(3,C$4:C22))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J22=\"\",\"\",SUBTOTAL(3,J$4:J22))","v":""}]
[{"$f":"IF(C23=\"\",\"\",SUBTOTAL(3,C$4:C23))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J23=\"\",\"\",SUBTOTAL(3,J$4:J23))","v":""}]
[{"$f":"IF(C24=\"\",\"\",SUBTOTAL(3,C$4:C24))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J24=\"\",\"\",SUBTOTAL(3,J$4:J24))","v":""}]
[{"$f":"IF(C25=\"\",\"\",SUBTOTAL(3,C$4:C25))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J25=\"\",\"\",SUBTOTAL(3,J$4:J25))","v":""}]
[{"$f":"IF(C26=\"\",\"\",SUBTOTAL(3,C$4:C26))","v":""},null,null,null,null,null,null,null,{"$f":"IF(J26=\"\",\"\",SUBTOTAL(3,J$4:J26))","v":""}]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Cost_Details[Amount])","v":7000},null,null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Revenue_Details[Amount])","v":8500}]

{"sheet":"Data","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
["S.No","Cost.Type",null,"S.No","Project Name",null,"S.No","Receiving Type"]
[{"$f":"IF(B4=\"\",\"\",SUBTOTAL(3,B$4:B4))","v":1},"مصاريف رواتب واجور",null,{"$f":"IF(E4=\"\",\"\",SUBTOTAL(3,E$4:E4))","v":1},"مشروع x",null,{"$f":"IF(H4=\"\",\"\",SUBTOTAL(3,H$4:H4))","v":1},"دفعة مستلمة تحت الحساب"]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(3,B$4:B5))","v":2},"مصاريف سيارات",null,{"$f":"IF(E5=\"\",\"\",SUBTOTAL(3,E$4:E5))","v":2},"مشروع xx",null,{"$f":"IF(H5=\"\",\"\",SUBTOTAL(3,H$4:H5))","v":2},"ايراد من عميل"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,B$4:B6))","v":3},"مصاريف نقل",null,{"$f":"IF(E6=\"\",\"\",SUBTOTAL(3,E$4:E6))","v":3},"مشروع xxx",null,{"$f":"IF(H6=\"\",\"\",SUBTOTAL(3,H$4:H6))","v":""}]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,B$4:B7))","v":4},"مصاريف بنزين",null,{"$f":"IF(E7=\"\",\"\",SUBTOTAL(3,E$4:E7))","v":4},"مشروع xxxx",null,{"$f":"IF(H7=\"\",\"\",SUBTOTAL(3,H$4:H7))","v":""}]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,B$4:B8))","v":5},"مصاريف طعام",null,{"$f":"IF(E8=\"\",\"\",SUBTOTAL(3,E$4:E8))","v":5},"مشروع xxxxx",null,{"$f":"IF(H8=\"\",\"\",SUBTOTAL(3,H$4:H8))","v":""}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,B$4:B9))","v":6},"مصاريف مواد",null,{"$f":"IF(E9=\"\",\"\",SUBTOTAL(3,E$4:E9))","v":6},"مشروع xxxxxx",null,{"$f":"IF(H9=\"\",\"\",SUBTOTAL(3,H$4:H9))","v":""}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,B$4:B10))","v":7},"مصاريف نثرية",null,{"$f":"IF(E10=\"\",\"\",SUBTOTAL(3,E$4:E10))","v":7},"مشروع xxxxxxx",null,{"$f":"IF(H10=\"\",\"\",SUBTOTAL(3,H$4:H10))","v":""}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,B$4:B11))","v":8},"مصاريف حكومية",null,{"$f":"IF(E11=\"\",\"\",SUBTOTAL(3,E$4:E11))","v":8},"مشروع xxxxxxxx",null,{"$f":"IF(H11=\"\",\"\",SUBTOTAL(3,H$4:H11))","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,B$4:B12))","v":9},"دفعة لمقاول",null,{"$f":"IF(E12=\"\",\"\",SUBTOTAL(3,E$4:E12))","v":""},null,null,{"$f":"IF(H12=\"\",\"\",SUBTOTAL(3,H$4:H12))","v":""}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,B$4:B13))","v":10},"دفعة تحت الحساب",null,{"$f":"IF(E13=\"\",\"\",SUBTOTAL(3,E$4:E13))","v":""},null,null,{"$f":"IF(H13=\"\",\"\",SUBTOTAL(3,H$4:H13))","v":""}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,B$4:B14))","v":""},null,null,{"$f":"IF(E14=\"\",\"\",SUBTOTAL(3,E$4:E14))","v":""},null,null,{"$f":"IF(H14=\"\",\"\",SUBTOTAL(3,H$4:H14))","v":""}]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,B$4:B15))","v":""},null,null,{"$f":"IF(E15=\"\",\"\",SUBTOTAL(3,E$4:E15))","v":""},null,null,{"$f":"IF(H15=\"\",\"\",SUBTOTAL(3,H$4:H15))","v":""}]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(3,B$4:B16))","v":""},null,null,{"$f":"IF(E16=\"\",\"\",SUBTOTAL(3,E$4:E16))","v":""},null,null,{"$f":"IF(H16=\"\",\"\",SUBTOTAL(3,H$4:H16))","v":""}]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,B$4:B17))","v":""},null,null,{"$f":"IF(E17=\"\",\"\",SUBTOTAL(3,E$4:E17))","v":""},null,null,{"$f":"IF(H17=\"\",\"\",SUBTOTAL(3,H$4:H17))","v":""}]
[{"$f":"IF(B18=\"\",\"\",SUBTOTAL(3,B$4:B18))","v":""},null,null,{"$f":"IF(E18=\"\",\"\",SUBTOTAL(3,E$4:E18))","v":""},null,null,{"$f":"IF(H18=\"\",\"\",SUBTOTAL(3,H$4:H18))","v":""}]
[{"$f":"IF(B19=\"\",\"\",SUBTOTAL(3,B$4:B19))","v":""},null,null,{"$f":"IF(E19=\"\",\"\",SUBTOTAL(3,E$4:E19))","v":""},null,null,{"$f":"IF(H19=\"\",\"\",SUBTOTAL(3,H$4:H19))","v":""}]
[{"$f":"IF(B20=\"\",\"\",SUBTOTAL(3,B$4:B20))","v":""},null,null,{"$f":"IF(E20=\"\",\"\",SUBTOTAL(3,E$4:E20))","v":""},null,null,{"$f":"IF(H20=\"\",\"\",SUBTOTAL(3,H$4:H20))","v":""}]
[{"$f":"IF(B21=\"\",\"\",SUBTOTAL(3,B$4:B21))","v":""},null,null,{"$f":"IF(E21=\"\",\"\",SUBTOTAL(3,E$4:E21))","v":""},null,null,{"$f":"IF(H21=\"\",\"\",SUBTOTAL(3,H$4:H21))","v":""}]
[{"$f":"IF(B22=\"\",\"\",SUBTOTAL(3,B$4:B22))","v":""},null,null,{"$f":"IF(E22=\"\",\"\",SUBTOTAL(3,E$4:E22))","v":""},null,null,{"$f":"IF(H22=\"\",\"\",SUBTOTAL(3,H$4:H22))","v":""}]
[{"$f":"IF(B23=\"\",\"\",SUBTOTAL(3,B$4:B23))","v":""},null,null,{"$f":"IF(E23=\"\",\"\",SUBTOTAL(3,E$4:E23))","v":""},null,null,{"$f":"IF(H23=\"\",\"\",SUBTOTAL(3,H$4:H23))","v":""}]
[{"$f":"IF(B24=\"\",\"\",SUBTOTAL(3,B$4:B24))","v":""},null,null,{"$f":"IF(E24=\"\",\"\",SUBTOTAL(3,E$4:E24))","v":""},null,null,{"$f":"IF(H24=\"\",\"\",SUBTOTAL(3,H$4:H24))","v":""}]
[{"$f":"IF(B25=\"\",\"\",SUBTOTAL(3,B$4:B25))","v":""},null,null,{"$f":"IF(E25=\"\",\"\",SUBTOTAL(3,E$4:E25))","v":""},null,null,{"$f":"IF(H25=\"\",\"\",SUBTOTAL(3,H$4:H25))","v":""}]
[{"$f":"IF(B26=\"\",\"\",SUBTOTAL(3,B$4:B26))","v":""},null,null,{"$f":"IF(E26=\"\",\"\",SUBTOTAL(3,E$4:E26))","v":""},null,null,{"$f":"IF(H26=\"\",\"\",SUBTOTAL(3,H$4:H26))","v":""}]
[{"$f":"IF(B27=\"\",\"\",SUBTOTAL(3,B$4:B27))","v":""},null,null,{"$f":"IF(E27=\"\",\"\",SUBTOTAL(3,E$4:E27))","v":""},null,null,{"$f":"IF(H27=\"\",\"\",SUBTOTAL(3,H$4:H27))","v":""}]