{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["data","min","حساب"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":79,"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":"data","index":0,"n_rows":112,"n_cols":11,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,1,0,10],[60,0,60,4],[69,0,69,2]]}
["الايراد",2012]
[null,"نقل","نقل ثقيل","اجره","رحلات","توكتك","مقطوره","جرار","معدات ثقيله","تروسيكيل","جرار ومقطوره"]
[null,2,3,4,5,6,7,8,9,10,11]
[0,85,"غير موجود",80,"غير موجود",91,85,85,85,91,85]
[1,90,"غير موجود",80,"غير موجود",91,90,90,90,91,90]
[2,95,"غير موجود",80,"غير موجود",91,95,95,95,91,95]
[3,100,"غير موجود",80,"غير موجود",91,100,100,100,91,100]
[4,110,"غير موجود",80,"غير موجود",91,110,110,110,91,110]
[5,150,"غير موجود",80,"غير موجود",91,150,150,150,91,150]
[6,"غير موجود",150,85,"غير موجود",91,150,150,150,91,150]
[7,"غير موجود",150,85,"غير موجود",91,150,150,150,91,150]
[8,"غير موجود",150,95,"غير موجود",91,150,150,150,91,150]
[9,"غير موجود",150,95,"غير موجود",91,150,150,150,91,150]
[10,"غير موجود",150,95,"غير موجود",91,150,150,150,91,150]
[11,"غير موجود",154,95,"غير موجود",91,154,154,154,91,154]
[12,"غير موجود",168,105,"غير موجود",91,168,168,168,91,168]
[13,"غير موجود",182,105,"غير موجود",91,182,182,182,91,182]
[14,"غير موجود",196,105,"غير موجود",91,196,196,196,91,196]
[15,"غير موجود",210,105,"غير موجود",91,210,210,210,91,210]
[16,"غير موجود",224,"غير موجود",105,91,224,224,224,91,224]
[17,"غير موجود",238,"غير موجود",105,91,238,238,238,91,238]
[18,"غير موجود",252,"غير موجود",105,91,252,252,252,91,252]
[19,"غير موجود",266,"غير موجود",105,91,266,266,266,91,266]
[20,"غير موجود",280,"غير موجود",{"$f":"A24*$C$59","v":110},91,280,280,280,91,280]
[21,"غير موجود",294,"غير موجود",{"$f":"A25*$C$59","v":115.5},91,294,294,294,91,294]
[22,"غير موجود",308,"غير موجود",121,91,308,308,308,91,308]
[23,"غير موجود",322,"غير موجود",126.5,91,322,322,322,91,322]
[24,"غير موجود",336,"غير موجود",132,91,336,336,336,91,336]
[25,"غير موجود",350,"غير موجود",137.5,91,350,350,350,91,350]
[26,"غير موجود",364,"غير موجود",143,91,364,364,364,91,364]
[27,"غير موجود",378,"غير موجود",148.5,91,378,378,378,91,378]
[28,"غير موجود",392,"غير موجود",154,91,392,392,392,91,392]
[29,"غير موجود",406,"غير موجود",159.5,91,406,406,406,91,406]
[30,"غير موجود",420,"غير موجود",165,91,420,420,420,91,420]
[31,"غير موجود",434,"غير موجود",170.5,91,434,434,434,91,434]
[32,"غير موجود",448,"غير موجود",176,91,448,448,448,91,448]
[33,"غير موجود",462,"غير موجود",181.5,91,462,462,462,91,462]
[34,"غير موجود",476,"غير موجود",187,91,476,476,476,91,476]
[35,"غير موجود",490,"غير موجود",192.5,91,490,490,490,91,490]
[36,"غير موجود",504,"غير موجود",198,91,504,504,504,91,504]
[37,"غير موجود",518,"غير موجود",203.5,91,518,518,518,91,518]
[38,"غير موجود",532,"غير موجود",209,91,532,532,532,91,532]
[39,"غير موجود",546,"غير موجود",214.5,91,546,546,546,91,546]
[40,"غير موجود",560,"غير موجود",220,91,560,560,560,91,560]
[41,"غير موجود",574,"غير موجود",225.5,91,574,574,574,91,574]
[42,"غير موجود",588,"غير موجود",231,91,588,588,588,91,588]
[43,"غير موجود",602,"غير موجود",236.5,91,602,602,602,91,602]
[44,"غير موجود",616,"غير موجود",242,91,616,616,616,91,616]
[45,"غير موجود",630,"غير موجود",247.5,91,630,630,630,91,630]
[46,"غير موجود",644,"غير موجود",253,91,644,644,644,91,644]
[47,"غير موجود",658,"غير موجود",258.5,91,658,658,658,91,658]
[48,"غير موجود",672,"غير موجود",264,91,672,672,672,91,672]
[49,"غير موجود",686,"غير موجود",269.5,91,686,686,686,91,686]
[50,"غير موجود",700,"غير موجود",275,91,700,700,700,91,700]
[51,"غير موجود",714,"غير موجود",280.5,91,714,714,714,91,714]
[52,"غير موجود",728,"غير موجود",286,91,728,728,728,91,728]
[53,"غير موجود",742,"غير موجود",291.5,91,742,742,742,91,742]
[]
["سعر",14,5.5]
[]
["عدد الايام"]
[null,"نقل","نقل ثقيل","اجره","رحلات","توكتك","مقطوره","جرار","معدات ثقيله","تروسيكيل","جرار ومقطوره"]
[null,2,3,4,5,6,7,8,9,10,11]
[0,280,270,300,300,300,140,270,280,300,270]
[6,250,230,250,250,230,140,230,250,230,230]
[10,230,190,230,230,190,140,190,230,190,190]
[15,190,190,190,190,190,140,190,190,190,190]
[100,190,190,190,190,190,140,190,190,190,190]
[]
["نسبة\nصافي\nالربح"]
[null,"مؤمن","غير مؤمن"]
[null,2,3]
["سولار",0.3,0.35]
["غاز",0.3,0.35]
["بنزين",0.25,0.3]
["نقل ثقيل",0.25,0.25]
["توكتك",0.25,0.3]
["اجره رحلات",0.25,0.25]
["مقطوره",0.35,0.35]
["جرار ومقطوره",0.25,0.25]
[]
[]
["نقل","سولار","مؤمن"]
["نقل ثقيل","غاز","غير مؤمن"]
["اجره","بنزين"]
["رحلات","نقل ثقيل"]
["توكتك"]
["مقطوره"]
["جرار"]
["معدات ثقيله"]
["تروسيكيل"]
["جرار ومقطوره"]
[]
[2005]
[2006]
[2007]
[2008]
[2009]
[2010]
[2011]
[2012]
[2013]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]

{"sheet":"min","index":1,"n_rows":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":false,"merged":[[14,0,29,0],[13,0,13,1],[0,2,0,7],[1,2,1,7],[6,2,6,3],[10,2,10,7],[30,0,40,0],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,0,51,0],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2]]}
["الممول",":"]
["الملف",":"]
["الشياخه",":"]
["كود النشاط",":"]
["مسلسل",":"]
["النشاط",":"]
["رقم التسجيل",":"]
["الكيان",":"]
["الوظيفه",":"]
["بدء النشاط",":"]
["العنوان",":"]
["سنوات الفحص",":"]
[]
["السنه",null,2012]
[" نشاط سيارات ","م","نوع السياره","رقم السياره","الوقود","الحموله","السائق","الشاسيه","الموتور","الموديل","بداية النشاط","نهاية النشاط",null,"طن/كرسي","سعر","ايراد يومى","عدد الأيام","شهور العمل","رقم الأعمال","نسبة الربح","ارباح السيارة"]
[null,1,"رحلات",56232,"اجره رحلات",25,"مؤمن",null,0,2021,"2021-07-11","2022-05-31",null,null,null,{"$f":"IFERROR(VLOOKUP(F16,data!$A$4:$K$57,MATCH(C16,data!$A$2:$K$2,0))*1.05^($C$14-2012),\"\")","v":137.5},{"$f":"IFERROR(VLOOKUP(($C$14-J16),data!$A$64:$K$68,HLOOKUP(C16,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(AND(K16=\"\",L16=\"\"),\"\",IF(OR(DATE($C$14,12,31)<K16,DATE($C$14,1,1)>IF(L16=\"\",TODAY(),L16)),0,IF(AND(DATE($C$14,1,1)<=K16,DATE($C$14,12,31)>=IF(L16=\"\",TODAY(),L16)),DATEDIF(K16,IF(L16=\"\",TODAY(),L16),\"d\")/30,IF(AND(DATE($C$14,1,1)<=K16,DATE($C$14,12,31)<=IF(L16=\"\",TODAY(),L16)),DATEDIF(K16,DATE($C$14,12,31),\"d\")/30,IF(AND(DATE($C$14,1,1)>=K16,DATE($C$14,12,31)>=IF(L16=\"\",TODAY(),L16)),DATEDIF(DATE($C$14,1,1),IF(L16=\"\",TODAY(),L16),\"d\")/30,12)))))","v":0},{"$f":"IFERROR((P16*Q16)*(R16/12),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E16,data!$A$73:$C$80,HLOOKUP(G16,data!$A$71:$C$72,2,),),\"\")","v":0.25},{"$f":"IFERROR((S16*T16),\"\")","v":""}]
[null,2,"رحلات",6135,"اجره رحلات",26,"مؤمن",null,null,2014,"2014-08-06","2020-03-15",null,null,null,{"$f":"IFERROR(VLOOKUP(F17,data!$A$4:$K$57,MATCH(C17,data!$A$2:$K$2,0))*1.05^($C$14-2012),\"\")","v":143},{"$f":"IFERROR(VLOOKUP(($C$14-J17),data!$A$64:$K$68,HLOOKUP(C17,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(AND(K17=\"\",L17=\"\"),\"\",IF(OR(DATE($C$14,12,31)<K17,DATE($C$14,1,1)>IF(L17=\"\",TODAY(),L17)),0,IF(AND(DATE($C$14,1,1)<=K17,DATE($C$14,12,31)>=IF(L17=\"\",TODAY(),L17)),DATEDIF(K17,IF(L17=\"\",TODAY(),L17),\"d\")/30,IF(AND(DATE($C$14,1,1)<=K17,DATE($C$14,12,31)<=IF(L17=\"\",TODAY(),L17)),DATEDIF(K17,DATE($C$14,12,31),\"d\")/30,IF(AND(DATE($C$14,1,1)>=K17,DATE($C$14,12,31)>=IF(L17=\"\",TODAY(),L17)),DATEDIF(DATE($C$14,1,1),IF(L17=\"\",TODAY(),L17),\"d\")/30,12)))))","v":0},{"$f":"IFERROR((P17*Q17)*(R17/12),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E17,data!$A$73:$C$80,HLOOKUP(G17,data!$A$71:$C$72,2,),),\"\")","v":0.25},""]
[null,3,"رحلات",7146,"اجره رحلات",26,"مؤمن",null,null,2012,"2012-01-01","2020-12-28",null,null,null,{"$f":"IFERROR(VLOOKUP(F18,data!$A$4:$K$57,MATCH(C18,data!$A$2:$K$2,0))*1.05^($C$14-2012),\"\")","v":143},{"$f":"IFERROR(VLOOKUP(($C$14-J18),data!$A$64:$K$68,HLOOKUP(C18,data!$A$62:$K$63,2,0),2),\"\")","v":300},12.166666666666666,43495.833333333328,{"$f":"IFERROR(VLOOKUP(E18,data!$A$73:$C$80,HLOOKUP(G18,data!$A$71:$C$72,2,),),\"\")","v":0.25},10873.958333333332]
[null,4,"رحلات",8654,"اجره رحلات",26,"مؤمن",null,null,1984,"2013-05-01","2018-07-01",null,null,null,{"$f":"IFERROR(VLOOKUP(F19,data!$A$4:$K$57,MATCH(C19,data!$A$2:$K$2,0))*1.05^($C$14-2012),\"\")","v":143},{"$f":"IFERROR(VLOOKUP(($C$14-J19),data!$A$64:$K$68,HLOOKUP(C19,data!$A$62:$K$63,2,0),2),\"\")","v":190},0,0,{"$f":"IFERROR(VLOOKUP(E19,data!$A$73:$C$80,HLOOKUP(G19,data!$A$71:$C$72,2,),),\"\")","v":0.25},0]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F20,data!$A$4:$K$57,MATCH(C20,data!$A$2:$K$2,0))*1.05^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J20),data!$A$64:$K$68,HLOOKUP(C20,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E20,data!$A$73:$C$80,HLOOKUP(G20,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F21,data!$A$4:$K$57,MATCH(C21,data!$A$2:$K$2,0))*1.05^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J21),data!$A$64:$K$68,HLOOKUP(C21,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E21,data!$A$73:$C$80,HLOOKUP(G21,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F22,data!$A$4:$K$57,HLOOKUP(C22,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J22),data!$A$64:$K$68,HLOOKUP(C22,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E22,data!$A$73:$C$80,HLOOKUP(G22,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F23,data!$A$4:$K$57,HLOOKUP(C23,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J23),data!$A$64:$K$68,HLOOKUP(C23,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E23,data!$A$73:$C$80,HLOOKUP(G23,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F24,data!$A$4:$K$57,HLOOKUP(C24,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J24),data!$A$64:$K$68,HLOOKUP(C24,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E24,data!$A$73:$C$80,HLOOKUP(G24,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F25,data!$A$4:$K$57,HLOOKUP(C25,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J25),data!$A$64:$K$68,HLOOKUP(C25,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E25,data!$A$73:$C$80,HLOOKUP(G25,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F26,data!$A$4:$K$57,HLOOKUP(C26,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J26),data!$A$64:$K$68,HLOOKUP(C26,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E26,data!$A$73:$C$80,HLOOKUP(G26,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F27,data!$A$4:$K$57,HLOOKUP(C27,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J27),data!$A$64:$K$68,HLOOKUP(C27,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E27,data!$A$73:$C$80,HLOOKUP(G27,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F28,data!$A$4:$K$57,HLOOKUP(C28,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J28),data!$A$64:$K$68,HLOOKUP(C28,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E28,data!$A$73:$C$80,HLOOKUP(G28,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F29,data!$A$4:$K$57,HLOOKUP(C29,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J29),data!$A$64:$K$68,HLOOKUP(C29,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E29,data!$A$73:$C$80,HLOOKUP(G29,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F30,data!$A$4:$K$57,HLOOKUP(C30,data!$A$2:$K$3,2,1),2)*(1+5%)^($C$14-2012),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J30),data!$A$64:$K$68,HLOOKUP(C30,data!$A$62:$K$63,2,0),2),\"\")","v":""},"","",{"$f":"IFERROR(VLOOKUP(E30,data!$A$73:$C$80,HLOOKUP(G30,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[" نشاط تجارى ","البند",null,"نسبة الزياده",null,"ايراد سنة الاساس",null,null,null,null,"بداية النشاط","نهاية النشاط",null,null,null,"الإيراد اليومى","عدد الأيام","شهور العمل","رقم الأعمال","نسبة الربح","أرباح البند"]
[null,"تصنيع اكياس بلاستيك",null,0.05,null,85,null,null,null,null,"2012-01-01",null,null,null,null,{"$f":"IF(YEAR($K32)=$C$14,$F32,$F32*(1+$D32)^($C$14-YEAR($K32)))","v":85},250,{"$f":"IF(OR(DATE($C$14,12,31)<K32,DATE($C$14,1,1)>L32),0,IF(AND(DATE($C$14,1,1)>=K32,DATE($C$14,12,31)<=L32),12,IF(AND(DATE($C$14,1,1)<=K32,DATE($C$14,12,31)>=L32),DATEDIF(K32,L32,\"d\")/30,IF(AND(DATE($C$14,1,1)<=K32,DATE($C$14,12,31)<=L32),DATEDIF(K32,DATE($C$14,12,31),\"d\")/30,IF(AND(DATE($C$14,1,1)>=K32,DATE($C$14,12,31)>=L32),DATEDIF(DATE($C$14,1,1),L32,\"d\")/30,\"??\")))))","v":0},{"$f":"IFERROR((P32*Q32)*(R32/12),\"\")","v":0},0.15,{"$f":"IFERROR((S32*T32),\"\")","v":0}]
[null,"كافتيريا",null,0.04,null,115,null,null,null,null,"2013-08-02","2014-08-07",null,null,null,{"$f":"IF(YEAR($K33)=$C$14,$F33,$F33*(1+$D33)^($C$14-YEAR($K33)))","v":110.57692307692307},240,0,0,0.2,0]
[null,"مقاولات",null,0.05,null,null,null,null,null,null,"2014-08-07",null,null,null,null,0,200,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0]
[" نشاط ثروه عقاريه ","العنوان",null,"نسبة الزياده",null,"ايجار سنة الاساس",null,null,null,null,"بداية النشاط","نهاية النشاط",null,null,null,"الايجار الشهري","عدد الشهور","شهور العمل","رقم الأعمال","نسبة الربح","أرباح الثروة العقاريه"]
[null,"دور ارضي قطعة 18 مج 24",null,0.1,null,1150,null,null,null,null,"2016-04-12",null,null,null,null,{"$f":"IF(YEAR($K43)=$C$14,$F43,$F43*(1+$D43)^($C$14-YEAR($K43)))","v":785.46547366983111},12,{"$f":"IF(AND(K43=\"\",L43=\"\"),\"\",IF(OR(DATE($C$14,12,31)<K43,DATE($C$14,1,1)>IF(L43=\"\",TODAY(),L43)),0,IF(AND(DATE($C$14,1,1)<=K43,DATE($C$14,12,31)>=IF(L43=\"\",TODAY(),L43)),DATEDIF(K43,IF(L43=\"\",TODAY(),L43),\"d\")/30,IF(AND(DATE($C$14,1,1)<=K43,DATE($C$14,12,31)<=IF(L43=\"\",TODAY(),L43)),DATEDIF(K43,DATE($C$14,12,31),\"d\")/30,IF(AND(DATE($C$14,1,1)>=K43,DATE($C$14,12,31)>=IF(L43=\"\",TODAY(),L43)),DATEDIF(DATE($C$14,1,1),IF(L43=\"\",TODAY(),L43),\"d\")/30,12)))))","v":0},0,0.5,{"$f":"IFERROR((S43*T43),\"\")","v":0}]
[null,"شقة 1 عمارة 193 مج 19",null,0.1,null,1250,null,null,null,null,"2013-08-15",null,null,null,null,{"$f":"IF(YEAR($K44)=$C$14,$F44,$F44*(1+$D44)^($C$14-YEAR($K44)))","v":1136.3636363636363},12,{"$f":"IF(AND(K44=\"\",L44=\"\"),\"\",IF(OR(DATE($C$14,12,31)<K44,DATE($C$14,1,1)>IF(L44=\"\",TODAY(),L44)),0,IF(AND(DATE($C$14,1,1)<=K44,DATE($C$14,12,31)>=IF(L44=\"\",TODAY(),L44)),DATEDIF(K44,IF(L44=\"\",TODAY(),L44),\"d\")/30,IF(AND(DATE($C$14,1,1)<=K44,DATE($C$14,12,31)<=IF(L44=\"\",TODAY(),L44)),DATEDIF(K44,DATE($C$14,12,31),\"d\")/30,IF(AND(DATE($C$14,1,1)>=K44,DATE($C$14,12,31)>=IF(L44=\"\",TODAY(),L44)),DATEDIF(DATE($C$14,1,1),IF(L44=\"\",TODAY(),L44),\"d\")/30,12)))))","v":0},0,0.5,0]
[null,"شقة 2 قطعة 193 مج 19",null,0.1,null,700,null,null,null,null,"2011-10-17",null,null,null,null,770.00000000000011,12,12,9240.0000000000018,0.5,{"$f":"IFERROR((S45*T45),\"\")","v":4620.0000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,"","",0.5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,"","",0.5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,"","",0.5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,"","",0.5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,"","",0.5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,"","",0.5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,"","",0.5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(S16:S52),\"\")","v":52735.833333333328},null,{"$f":"IFERROR(SUM(U16:U52),\"\")","v":15493.958333333332}]

{"sheet":"حساب","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[2012]
[null,"رقم السياره","ايراد يومى","عدد الأيام","شهور العمل","رقم الأعمال","نسبة الربح","ارباح السيارة"]
[null,7146,143,300,12.166666666666666,43495.833333333328,0.25,10873.958333333332]
[]
[null,"العنوان","الايجار الشهري","عدد الشهور","شهور العمل","رقم الأعمال","نسبة الربح","أرباح الثروة العقاريه"]
[null,"شقة 2 قطعة 193 مج 19",770.00000000000011,12,12,9240.0000000000018,0.5,4620.0000000000009]
[]
[null,"الاجمــــــــــــــــــــــــــــالي",null,null,null,52735.833333333328,null,15493.958333333332]
[2013]
[null,"رقم السياره","ايراد يومى","عدد الأيام","شهور العمل","رقم الأعمال","نسبة الربح","ارباح السيارة"]
[null,7146,150.15,300,12,45045,0.25,11261.25]
[null,8654,150.15,190,8.1333333333333329,19335.98333333333,0.25,4833.9958333333325]
[]
[null,"البند","الإيراد اليومى","عدد الأيام","شهور العمل","رقم الأعمال","نسبة الربح","أرباح البند"]
[null,"كافتريا",115,240,5.0333333333333332,11576.666666666666,0.2,2315.3333333333335]
[]
[null,"العنوان","الايجار الشهري","عدد الشهور","شهور العمل","رقم الأعمال","نسبة الربح","أرباح الثروة العقاريه"]
[null,"شقة 1 عمارة 193 مج 19",1250,12,4.5999999999999996,5750,0.5,2875]
[null,"شقة 2 قطعة 193 مج 19",847.00000000000011,12,12,10164.000000000002,0.5,5082.0000000000009]
[]
[null,"الاجمــــــــــــــــــــــــــــالي",null,null,null,91871.65,null,26367.579166666666]