{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet2"],"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":"Sheet2","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Task Start "," TaskEnd","Leaves days","Leave Start","Leave End",null,null,null,"Start day","End Date",null,"Leaves"," Hr",null,"total Hr"]
[{"$f":"IF(I2=0,\"\",I2)","v":"2015-10-10"},"2015-10-15",{"$f":"IF(A2=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A2+ROW($A$1:INDEX($A:$A,$B2-$A2+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A2+ROW($A$1:INDEX($A:$A,$B2-$A2+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A2+ROW($A$1:INDEX($A:$A,$B2-$A2+1))-1),2)<6)))","v":4},"2015-10-04","2015-10-15",null,null,"Task 1","2015-10-10","2015-10-15",null,{"$f":"C2","v":4},8,"=",{"$f":"L2*M2","v":32}]
["2015-11-27","2015-12-27",{"$f":"IF(A3=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A3+ROW($A$1:INDEX($A:$A,$B3-$A3+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A3+ROW($A$1:INDEX($A:$A,$B3-$A3+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A3+ROW($A$1:INDEX($A:$A,$B3-$A3+1))-1),2)<6)))","v":7},"2015-10-22","2015-10-28",null,null,"Task 2","2015-11-27","2015-12-27",null,{"$f":"C3","v":7},8,"=",{"$f":"L3*M3","v":56}]
["2015-12-24","2016-01-10",{"$f":"IF(A4=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A4+ROW($A$1:INDEX($A:$A,$B4-$A4+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A4+ROW($A$1:INDEX($A:$A,$B4-$A4+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A4+ROW($A$1:INDEX($A:$A,$B4-$A4+1))-1),2)<6)))","v":9},"2015-11-10","2015-11-13",null,null,"Task 3","2015-12-24","2016-01-10",null,9,8,"=",72]
[{"$f":"IF(I5=0,\"\",I5)","v":""},{"$f":"IF(J5=0,\"\",J5)","v":""},{"$f":"IF(A5=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A5+ROW($A$1:INDEX($A:$A,$B5-$A5+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A5+ROW($A$1:INDEX($A:$A,$B5-$A5+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A5+ROW($A$1:INDEX($A:$A,$B5-$A5+1))-1),2)<6)))","v":""},"2015-12-02","2015-12-08",null,null,"Task 4",null,null,null,"","from column C5",null,{"$f":"L5*M5","v":{"$error":"#VALUE!"}}]
["","",{"$f":"IF(A6=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A6+ROW($A$1:INDEX($A:$A,$B6-$A6+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A6+ROW($A$1:INDEX($A:$A,$B6-$A6+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A6+ROW($A$1:INDEX($A:$A,$B6-$A6+1))-1),2)<6)))","v":""},"2015-12-24","2016-01-01",null,null,"Task 5",null,null,null,"","from column C6",null,{"$error":"#VALUE!"}]
["","",{"$f":"IF(A7=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A7+ROW($A$1:INDEX($A:$A,$B7-$A7+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A7+ROW($A$1:INDEX($A:$A,$B7-$A7+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A7+ROW($A$1:INDEX($A:$A,$B7-$A7+1))-1),2)<6)))","v":""},"2016-01-05","2016-01-06",null,null,"task 6",null,null,null,"",null,null,{"$error":"#VALUE!"}]
["","",{"$f":"IF(A8=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A8+ROW($A$1:INDEX($A:$A,$B8-$A8+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A8+ROW($A$1:INDEX($A:$A,$B8-$A8+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A8+ROW($A$1:INDEX($A:$A,$B8-$A8+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01",null,null,"and so on"]
["","",{"$f":"IF(A9=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A9+ROW($A$1:INDEX($A:$A,$B9-$A9+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A9+ROW($A$1:INDEX($A:$A,$B9-$A9+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A9+ROW($A$1:INDEX($A:$A,$B9-$A9+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01",null,null,"till 300 task"]
["","",{"$f":"IF(A10=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A10+ROW($A$1:INDEX($A:$A,$B10-$A10+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A10+ROW($A$1:INDEX($A:$A,$B10-$A10+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A10+ROW($A$1:INDEX($A:$A,$B10-$A10+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01"]
["","",{"$f":"IF(A11=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A11+ROW($A$1:INDEX($A:$A,$B11-$A11+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A11+ROW($A$1:INDEX($A:$A,$B11-$A11+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A11+ROW($A$1:INDEX($A:$A,$B11-$A11+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01",null,null,"data in different sheet"]
["","",{"$f":"IF(A12=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A12+ROW($A$1:INDEX($A:$A,$B12-$A12+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A12+ROW($A$1:INDEX($A:$A,$B12-$A12+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A12+ROW($A$1:INDEX($A:$A,$B12-$A12+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01"]
["","",{"$f":"IF(A13=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A13+ROW($A$1:INDEX($A:$A,$B13-$A13+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A13+ROW($A$1:INDEX($A:$A,$B13-$A13+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A13+ROW($A$1:INDEX($A:$A,$B13-$A13+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01"]
["","",{"$f":"IF(A14=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A14+ROW($A$1:INDEX($A:$A,$B14-$A14+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A14+ROW($A$1:INDEX($A:$A,$B14-$A14+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A14+ROW($A$1:INDEX($A:$A,$B14-$A14+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01"]
[null,null,{"$f":"IF(A15=\"\",\"\",SUMPRODUCT((IFERROR((MMULT(TRANSPOSE($E$2:$E$15^0),(TRANSPOSE($A15+ROW($A$1:INDEX($A:$A,$B15-$A15+1))-1)>=$D$2:$D$15)*(TRANSPOSE($A15+ROW($A$1:INDEX($A:$A,$B15-$A15+1))-1)<=$E$2:$E$15)))^0,0))*(WEEKDAY(TRANSPOSE($A15+ROW($A$1:INDEX($A:$A,$B15-$A15+1))-1),2)<6)))","v":""},"1900-01-01","1900-01-01"]