{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SALIM","Correction ","vba_sh"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"SALIM","index":0,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["date1","dat2","Price",2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,null,null,"sum"]
["2017-03-01","2020-10-05",10,{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=D$1,(13-MONTH($A2))*$C2,IF(OR(D$1>MAX(YEAR($A2),YEAR($B2)),D$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=D$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=E$1,(13-MONTH($A2))*$C2,IF(OR(E$1>MAX(YEAR($A2),YEAR($B2)),E$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=E$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=F$1,(13-MONTH($A2))*$C2,IF(OR(F$1>MAX(YEAR($A2),YEAR($B2)),F$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=F$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":100},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=G$1,(13-MONTH($A2))*$C2,IF(OR(G$1>MAX(YEAR($A2),YEAR($B2)),G$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=G$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":120},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=H$1,(13-MONTH($A2))*$C2,IF(OR(H$1>MAX(YEAR($A2),YEAR($B2)),H$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=H$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":120},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=I$1,(13-MONTH($A2))*$C2,IF(OR(I$1>MAX(YEAR($A2),YEAR($B2)),I$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=I$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":90},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=J$1,(13-MONTH($A2))*$C2,IF(OR(J$1>MAX(YEAR($A2),YEAR($B2)),J$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=J$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=K$1,(13-MONTH($A2))*$C2,IF(OR(K$1>MAX(YEAR($A2),YEAR($B2)),K$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=K$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=L$1,(13-MONTH($A2))*$C2,IF(OR(L$1>MAX(YEAR($A2),YEAR($B2)),L$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=L$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=M$1,(13-MONTH($A2))*$C2,IF(OR(M$1>MAX(YEAR($A2),YEAR($B2)),M$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=M$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=N$1,(13-MONTH($A2))*$C2,IF(OR(N$1>MAX(YEAR($A2),YEAR($B2)),N$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=N$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=O$1,(13-MONTH($A2))*$C2,IF(OR(O$1>MAX(YEAR($A2),YEAR($B2)),O$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=O$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=P$1,(13-MONTH($A2))*$C2,IF(OR(P$1>MAX(YEAR($A2),YEAR($B2)),P$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=P$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},{"$f":"IF(OR($A2=\"\",$B2=\"\",$C2=\"\"),\"\",IF(YEAR($A2)=Q$1,(13-MONTH($A2))*$C2,IF(OR(Q$1>MAX(YEAR($A2),YEAR($B2)),Q$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=Q$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")))*$C2))","v":0},null,null,{"$f":"SUM($D2:$S2)","v":430}]
["2015-05-17","2021-07-20",5,{"$f":"IF(YEAR($A3)=D$1,(13-MONTH($A3))*$C3,IF(OR(D$1>MAX(YEAR($A3),YEAR($B3)),D$1<MIN(YEAR($A3),YEAR($B3))),0,IF(YEAR($B3)>=D$1+1,12,DATEDIF(DATE(YEAR($B3),1,1),$B3,\"m\")))*$C3)","v":40},{"$f":"IF(YEAR($A3)=E$1,(13-MONTH($A3))*$C3,IF(OR(E$1>MAX(YEAR($A3),YEAR($B3)),E$1<MIN(YEAR($A3),YEAR($B3))),0,IF(YEAR($B3)>=E$1+1,12,DATEDIF(DATE(YEAR($B3),1,1),$B3,\"m\")))*$C3)","v":60},60,60,60,60,30,0,0,0,0,0,0,0,null,null,{"$f":"SUM($D3:$S3)","v":370}]
[null,null,null,{"$f":"IF(OR($A4=\"\",$B4=\"\",$C4=\"\"),\"\",IF(YEAR($A4)>D$1,0,IF(D$1>MAX(YEAR($A4),YEAR($B4)),0,IF(YEAR($B4)>=D$1+1,12,DATEDIF(DATE(YEAR($B4),1,1),$B4,\"m\"))))*$C4)","v":""},{"$f":"IF(OR($A4=\"\",$B4=\"\",$C4=\"\"),\"\",IF(YEAR($A4)>E$1,0,IF(E$1>MAX(YEAR($A4),YEAR($B4)),0,IF(YEAR($B4)>=E$1+1,12,DATEDIF(DATE(YEAR($B4),1,1),$B4,\"m\"))))*$C4)","v":""},"","","","","","","","","","","",""]
[]
[null,null,null,{"$f":"SUM(D$2:D$5)","v":40},{"$f":"SUM(E$2:E$5)","v":60},160,180,180,150,30,0,0,0,0,0,0,0,"sum",{"$f":"SUM(D6:R6)","v":800},{"$f":"SUM(T2:T5)","v":800}]
[]
[null,"الأشهر في 2017"]
[null,"5و6و7و8و9و10و11و12",8]

{"sheet":"Correction ","index":1,"n_rows":6,"n_cols":20,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["date1","dat2","Price",2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,null,null,"sum"]
["2017-03-20","2017-04-03",1,{"$f":"IF(OR(N($A2)=0,N($B2)=0,N($C2)=0),\"\",IF(AND(YEAR($A2)=YEAR($B2),YEAR($A2)=D$1),ABS((MONTH($B2)-MONTH($A2)-IF(DAY($B2)<15,0.5,0))*$C2),IF(YEAR($A2)=D$1,((13-MONTH($A2)-IF(DAY($A2)<15,0,0.5)))*$C2,IF(OR(D$1>MAX(YEAR($A2),YEAR($B2)),D$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=D$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")+IF(DAY($B2)>=15,1,0.5)))*$C2)))","v":0},{"$f":"IF(OR(N($A2)=0,N($B2)=0,N($C2)=0),\"\",IF(AND(YEAR($A2)=YEAR($B2),YEAR($A2)=E$1),ABS((MONTH($B2)-MONTH($A2)-IF(DAY($B2)<15,0.5,0))*$C2),IF(YEAR($A2)=E$1,((13-MONTH($A2)-IF(DAY($A2)<15,0,0.5)))*$C2,IF(OR(E$1>MAX(YEAR($A2),YEAR($B2)),E$1<MIN(YEAR($A2),YEAR($B2))),0,IF(YEAR($B2)>=E$1+1,12,DATEDIF(DATE(YEAR($B2),1,1),$B2,\"m\")+IF(DAY($B2)>=15,1,0.5)))*$C2)))","v":0},0.5,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM($D2:$S2)","v":0.5}]
["2016-05-25","2021-07-10",1,{"$f":"IF(OR(N($A3)=0,N($B3)=0,N($C3)=0),\"\",IF(AND(YEAR($A3)=YEAR($B3),YEAR($A3)=D$1),ABS((MONTH($B3)-MONTH($A3)-IF(DAY($B3)<15,0.5,0))*$C3),IF(YEAR($A3)=D$1,((13-MONTH($A3)-IF(DAY($A3)<15,0,0.5)))*$C3,IF(OR(D$1>MAX(YEAR($A3),YEAR($B3)),D$1<MIN(YEAR($A3),YEAR($B3))),0,IF(YEAR($B3)>=D$1+1,12,DATEDIF(DATE(YEAR($B3),1,1),$B3,\"m\")+IF(DAY($B3)>=15,1,0.5)))*$C3)))","v":0},7.5,12,12,12,12,6.5,0,0,0,0,0,0,0,null,null,{"$f":"SUM($D3:$S3)","v":62}]
["2015-05-01","2015-05-05",1,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2016-07-25","2018-03-20",1,0,5.5,12,3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D$2:D$5)","v":0.5},{"$f":"SUM(E$2:E$5)","v":13},24.5,15,12,12,6.5,0,0,0,0,0,0,0,"sum",{"$f":"SUM(D6:R6)","v":83.5},{"$f":"SUM(T2:T5)","v":62.5}]

{"sheet":"vba_sh","index":2,"n_rows":6,"n_cols":20,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["date1","date2","Price",2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,null,null,"sum"]
["2015-01-20","2015-01-25",10,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($D2:$S2)","v":5}]
["2016-05-25","2027-07-16",15,null,112.5,180,180,180,180,180,180,180,180,180,180,105,null,null,null,{"$f":"SUM($D3:$S3)","v":2017.5}]
["2015-05-05","2016-05-08",10,80,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125]
["2016-07-25","2018-03-10",1,null,5.5,12,2.5,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,{"$f":"IF(SUM(D2:D5)=0,\"\",SUM(D2:D5))","v":85},{"$f":"IF(SUM(E2:E5)=0,\"\",SUM(E2:E5))","v":163},192,182.5,180,180,180,180,180,180,180,180,105,"","sum",{"$f":"SUM(D6:Q6)","v":2167.5},{"$f":"SUM(T2:T5)","v":2167.5}]