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

{"sheet":"min","index":1,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,17,14,17],[13,20,14,20],[13,18,14,18],[13,13,13,14],[13,0,13,1],[13,15,14,15],[13,16,14,16],[13,19,14,19],[1,2,1,7],[0,2,0,7],[6,2,6,3],[10,2,10,7],[14,0,29,0]]}
["الممول",":"]
["الملف",":",{"$f":"35&-C3&-C4&-C5&-165","v":"35-2-552-723-165"}]
["الشياخه",":",2]
["كود النشاط",":",552]
["مسلسل",":",723]
["النشاط",":"]
["رقم التسجيل",":"]
["الكيان",":"]
["الوظيفه",":"]
["بدء النشاط",":"]
["العنوان",":"]
["سنوات الفحص",":"]
[]
["سنة المحاسبة",null,2012,null,null,null,null,null,null,null,null,null,null,"ايراد يومي",null,"ايراد يومى","عدد الأيام","شهور العمل","رقم الأعمال","نسبة الربح","ارباح السيارة"]
[" نشاط سيارات ","م","النوع","رقم السياره","الوقود","حموله/ركاب","السائق","الشاسيه","الموتور","الموديل","بداية النشاط","نهاية النشاط",null,"طن/كرسي","سعر"]
[null,1,"نقل ثقيل",53489,"سولار",6,"مؤمن",null,0,2006,"2010-06-15","2016-11-05",null,null,null,{"$f":"IFERROR(VLOOKUP(F16,data!$A$4:$K$57,HLOOKUP(C16,data!$A$2:$K$3,2,0),2),\"\")","v":150},{"$f":"IFERROR(VLOOKUP(($C$14-J16),data!$A$64:$K$68,HLOOKUP(C16,data!$A$62:$K$63,2,0),2),\"\")","v":250},{"$f":"IF(ROWS($A$1:A1)-1>YEAR(L16)-YEAR(K16),\"\",IF(MAX(YEAR(K16),YEAR(L16))=$C$14,ROUND((L16-DATE(YEAR(L16),1,1))/30.45,1),IF(MIN(YEAR(K16),YEAR(L16))=$C$14,ROUND((DATE($C$14,12,31)-K16)/30.45,1),12)))","v":12},{"$f":"IFERROR((P16*Q16)*(R16/12),\"\")","v":37500},{"$f":"IFERROR(VLOOKUP(E16,data!$A$73:$C$80,HLOOKUP(G16,data!$A$71:$C$72,2,),),\"\")","v":0.3},{"$f":"IFERROR((S16*T16),\"\")","v":11250}]
[null,2,"رحلات",50253,"سولار",22,"غير مؤمن",null,null,2010,"2015-06-01","2020-12-31",null,null,null,{"$f":"IFERROR(VLOOKUP(F17,data!$A$4:$K$57,HLOOKUP(C17,data!$A$2:$K$3,2,0),2),\"\")","v":121},{"$f":"IFERROR(VLOOKUP(($C$14-J17),data!$A$64:$K$68,HLOOKUP(C17,data!$A$62:$K$63,2,0),2),\"\")","v":140},{"$f":"IF(ROWS($A$1:A2)-1>YEAR(L17)-YEAR(K17),\"\",IF(MAX(YEAR(K17),YEAR(L17))=$C$14,ROUND((L17-DATE(YEAR(L17),1,1))/30.45,1),IF(MIN(YEAR(K17),YEAR(L17))=$C$14,ROUND((DATE($C$14,12,31)-K17)/30.45,1),12)))","v":12},{"$f":"IFERROR((P17*Q17)*(R17/12),\"\")","v":16940},{"$f":"IFERROR(VLOOKUP(E17,data!$A$73:$C$80,HLOOKUP(G17,data!$A$71:$C$72,2,),),\"\")","v":0.35},{"$f":"IFERROR((S17*T17),\"\")","v":5929}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F18,data!$A$4:$K$57,HLOOKUP(C18,data!$A$2:$K$3,2,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J18),data!$A$64:$K$68,HLOOKUP(C18,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A3)-1>YEAR(L18)-YEAR(K18),\"\",IF(MAX(YEAR(K18),YEAR(L18))=$C$14,ROUND((L18-DATE(YEAR(L18),1,1))/30.45,1),IF(MIN(YEAR(K18),YEAR(L18))=$C$14,ROUND((DATE($C$14,12,31)-K18)/30.45,1),12)))","v":""},"",{"$f":"IFERROR(VLOOKUP(E18,data!$A$73:$C$80,HLOOKUP(G18,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F19,data!$A$4:$K$57,HLOOKUP(C19,data!$A$2:$K$3,2,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J19),data!$A$64:$K$68,HLOOKUP(C19,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A4)-1>YEAR(L19)-YEAR(K19),\"\",IF(MAX(YEAR(K19),YEAR(L19))=$C$14,ROUND((L19-DATE(YEAR(L19),1,1))/30.45,1),IF(MIN(YEAR(K19),YEAR(L19))=$C$14,ROUND((DATE($C$14,12,31)-K19)/30.45,1),12)))","v":""},"",{"$f":"IFERROR(VLOOKUP(E19,data!$A$73:$C$80,HLOOKUP(G19,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F20,data!$A$4:$K$57,HLOOKUP(C20,data!$A$2:$K$3,2,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J20),data!$A$64:$K$68,HLOOKUP(C20,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A5)-1>YEAR(L20)-YEAR(K20),\"\",IF(MAX(YEAR(K20),YEAR(L20))=$C$14,ROUND((L20-DATE(YEAR(L20),1,1))/30.45,1),IF(MIN(YEAR(K20),YEAR(L20))=$C$14,ROUND((DATE($C$14,12,31)-K20)/30.45,1),12)))","v":""},"",{"$f":"IFERROR(VLOOKUP(E20,data!$A$73:$C$80,HLOOKUP(G20,data!$A$71:$C$72,2,),),\"\")","v":""},""]
[null,6,"تروسيكيل",null,"غاز",1,"غير مؤمن",null,null,2000,"2012-07-01","2020-12-31",null,null,null,{"$f":"IFERROR(VLOOKUP(F21,data!$A$4:$K$57,HLOOKUP(C21,data!$A$2:$K$3,2,0),2),\"\")","v":84},{"$f":"IFERROR(VLOOKUP(($C$14-J21),data!$A$64:$K$68,HLOOKUP(C21,data!$A$62:$K$63,2,0),2),\"\")","v":190},{"$f":"IF(ROWS($A$1:A6)-1>YEAR(L21)-YEAR(K21),\"\",IF(MAX(YEAR(K21),YEAR(L21))=$C$14,ROUND((L21-DATE(YEAR(L21),1,1))/30.45,1),IF(MIN(YEAR(K21),YEAR(L21))=$C$14,ROUND((DATE($C$14,12,31)-K21)/30.45,1),12)))","v":6},7980,{"$f":"IFERROR(VLOOKUP(E21,data!$A$73:$C$80,HLOOKUP(G21,data!$A$71:$C$72,2,),),\"\")","v":0.35},2793]
[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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J22),data!$A$64:$K$68,HLOOKUP(C22,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A7)-1>YEAR(L22)-YEAR(K22),\"\",IF(MAX(YEAR(K22),YEAR(L22))=$C$14,ROUND((L22-DATE(YEAR(L22),1,1))/30.45,1),IF(MIN(YEAR(K22),YEAR(L22))=$C$14,ROUND((DATE($C$14,12,31)-K22)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J23),data!$A$64:$K$68,HLOOKUP(C23,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A8)-1>YEAR(L23)-YEAR(K23),\"\",IF(MAX(YEAR(K23),YEAR(L23))=$C$14,ROUND((L23-DATE(YEAR(L23),1,1))/30.45,1),IF(MIN(YEAR(K23),YEAR(L23))=$C$14,ROUND((DATE($C$14,12,31)-K23)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J24),data!$A$64:$K$68,HLOOKUP(C24,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A9)-1>YEAR(L24)-YEAR(K24),\"\",IF(MAX(YEAR(K24),YEAR(L24))=$C$14,ROUND((L24-DATE(YEAR(L24),1,1))/30.45,1),IF(MIN(YEAR(K24),YEAR(L24))=$C$14,ROUND((DATE($C$14,12,31)-K24)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J25),data!$A$64:$K$68,HLOOKUP(C25,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A10)-1>YEAR(L25)-YEAR(K25),\"\",IF(MAX(YEAR(K25),YEAR(L25))=$C$14,ROUND((L25-DATE(YEAR(L25),1,1))/30.45,1),IF(MIN(YEAR(K25),YEAR(L25))=$C$14,ROUND((DATE($C$14,12,31)-K25)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J26),data!$A$64:$K$68,HLOOKUP(C26,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A11)-1>YEAR(L26)-YEAR(K26),\"\",IF(MAX(YEAR(K26),YEAR(L26))=$C$14,ROUND((L26-DATE(YEAR(L26),1,1))/30.45,1),IF(MIN(YEAR(K26),YEAR(L26))=$C$14,ROUND((DATE($C$14,12,31)-K26)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J27),data!$A$64:$K$68,HLOOKUP(C27,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A12)-1>YEAR(L27)-YEAR(K27),\"\",IF(MAX(YEAR(K27),YEAR(L27))=$C$14,ROUND((L27-DATE(YEAR(L27),1,1))/30.45,1),IF(MIN(YEAR(K27),YEAR(L27))=$C$14,ROUND((DATE($C$14,12,31)-K27)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J28),data!$A$64:$K$68,HLOOKUP(C28,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A13)-1>YEAR(L28)-YEAR(K28),\"\",IF(MAX(YEAR(K28),YEAR(L28))=$C$14,ROUND((L28-DATE(YEAR(L28),1,1))/30.45,1),IF(MIN(YEAR(K28),YEAR(L28))=$C$14,ROUND((DATE($C$14,12,31)-K28)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J29),data!$A$64:$K$68,HLOOKUP(C29,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A14)-1>YEAR(L29)-YEAR(K29),\"\",IF(MAX(YEAR(K29),YEAR(L29))=$C$14,ROUND((L29-DATE(YEAR(L29),1,1))/30.45,1),IF(MIN(YEAR(K29),YEAR(L29))=$C$14,ROUND((DATE($C$14,12,31)-K29)/30.45,1),12)))","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,0),2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(($C$14-J30),data!$A$64:$K$68,HLOOKUP(C30,data!$A$62:$K$63,2,0),2),\"\")","v":""},{"$f":"IF(ROWS($A$1:A15)-1>YEAR(L30)-YEAR(K30),\"\",IF(MAX(YEAR(K30),YEAR(L30))=$C$14,ROUND((L30-DATE(YEAR(L30),1,1))/30.45,1),IF(MIN(YEAR(K30),YEAR(L30))=$C$14,ROUND((DATE($C$14,12,31)-K30)/30.45,1),12)))","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,null,null,null,null,null,null,null,{"$f":"SUM(S16:S30)","v":62420},null,{"$f":"SUM(U16:U30)","v":19972}]