{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Burndown Chart","Input","Final Data"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Burndown Chart","index":0,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,3,1,9]]}
[null,null,null,"Burndown Chart",null,null,null,null,null,null,null,"Customize the Legend"]
[null,null,null,null,null,null,null,null,null,null,null,"Planned Effort"]
[null,null,null,null,null,null,null,null,null,null,null,"Hours Remaining"]

{"sheet":"Input","index":1,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,2,0,12],[0,13,0,19]]}
[null,null,"Dates can be entered till column BJ, hence it supports upto 60 days (time duration).\nTasks can be entered till row 202, hence upto 200 tasks can be entered.\nEnter Remaining Effort to complete the task at the end of that day only - 0 would mean that the task is completed",null,null,null,null,null,null,null,null,null,null,"Validations - Remaining Efforts can not be > Planned Effort, Next Day's Remaining Effort should be <= Previous Day's Remaining Effort, Negative entry is not allowed, Planned Effort, if Entered, should be >=0, \nWeekend date will be highlighted in Orange."]
["Task / Story / Sprints",{"$f":"IF('Burndown Chart'!$L$2=\"\",\"Planned Effort\",'Burndown Chart'!$L$2)","v":"Planned Effort"},"2016-01-01","2016-01-02","2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","2016-01-16","2016-01-17"]
["Task 1",20,15,5,0]
["Task 2",60,60,60,0,0,0,60,60,60,50,30,20,0]
["Task 3",80,80,80,80,80,80,80,80,80,80,80,80,50,50,50,50,20,0]
["Task 4",10,10,10,10,10,10,10,10,10,10,10,10,10,0]
["Task 5",40,30,30,30,30,30,30,30,30,30,30,10,5,0]
["Task 6",30,10,0]
["Task 7",40,10,0,0,0]
["Task 8",40,40,40,40,40,40,0]
["Task 9",100,90,70,50,40,20,10,0]
["Task 10",90,90,90,90,20,0]
["Task 11",100,100,100,100,100,100,100,100,100,100,60,30,0]
["Task 12",40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,0]
["Task 13",100,100,100,100,100,70,70,70,70,70,50,20,20,20,20,20,0]
["Task 14",30,30,30,30,30,30,30,30,30,5,5,5,5,0]
["Task 15",70,70,70,70,70,70,70,70,70,70,70,70,70,50,40,30,0]

{"sheet":"Final Data","index":2,"n_rows":5,"n_cols":62,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Date","Day 0",{"$f":"IF(Input!C$2=\"\",\"\",Input!C$2)","v":"2016-01-01"},{"$f":"IF(Input!D$2=\"\",\"\",Input!D$2)","v":"2016-01-02"},{"$f":"IF(Input!E$2=\"\",\"\",Input!E$2)","v":"2016-01-03"},{"$f":"IF(Input!F$2=\"\",\"\",Input!F$2)","v":"2016-01-04"},{"$f":"IF(Input!G$2=\"\",\"\",Input!G$2)","v":"2016-01-05"},{"$f":"IF(Input!H$2=\"\",\"\",Input!H$2)","v":"2016-01-06"},{"$f":"IF(Input!I$2=\"\",\"\",Input!I$2)","v":"2016-01-07"},{"$f":"IF(Input!J$2=\"\",\"\",Input!J$2)","v":"2016-01-08"},{"$f":"IF(Input!K$2=\"\",\"\",Input!K$2)","v":"2016-01-09"},{"$f":"IF(Input!L$2=\"\",\"\",Input!L$2)","v":"2016-01-10"},{"$f":"IF(Input!M$2=\"\",\"\",Input!M$2)","v":"2016-01-11"},{"$f":"IF(Input!N$2=\"\",\"\",Input!N$2)","v":"2016-01-12"},{"$f":"IF(Input!O$2=\"\",\"\",Input!O$2)","v":"2016-01-13"},{"$f":"IF(Input!P$2=\"\",\"\",Input!P$2)","v":"2016-01-14"},{"$f":"IF(Input!Q$2=\"\",\"\",Input!Q$2)","v":"2016-01-15"},{"$f":"IF(Input!R$2=\"\",\"\",Input!R$2)","v":"2016-01-16"},{"$f":"IF(Input!S$2=\"\",\"\",Input!S$2)","v":"2016-01-17"},{"$f":"IF(Input!T$2=\"\",\"\",Input!T$2)","v":""},{"$f":"IF(Input!U$2=\"\",\"\",Input!U$2)","v":""},{"$f":"IF(Input!V$2=\"\",\"\",Input!V$2)","v":""},{"$f":"IF(Input!W$2=\"\",\"\",Input!W$2)","v":""},{"$f":"IF(Input!X$2=\"\",\"\",Input!X$2)","v":""},{"$f":"IF(Input!Y$2=\"\",\"\",Input!Y$2)","v":""},{"$f":"IF(Input!Z$2=\"\",\"\",Input!Z$2)","v":""},{"$f":"IF(Input!AA$2=\"\",\"\",Input!AA$2)","v":""},{"$f":"IF(Input!AB$2=\"\",\"\",Input!AB$2)","v":""},{"$f":"IF(Input!AC$2=\"\",\"\",Input!AC$2)","v":""},{"$f":"IF(Input!AD$2=\"\",\"\",Input!AD$2)","v":""},{"$f":"IF(Input!AE$2=\"\",\"\",Input!AE$2)","v":""},{"$f":"IF(Input!AF$2=\"\",\"\",Input!AF$2)","v":""},{"$f":"IF(Input!AG$2=\"\",\"\",Input!AG$2)","v":""},{"$f":"IF(Input!AH$2=\"\",\"\",Input!AH$2)","v":""},{"$f":"IF(Input!AI$2=\"\",\"\",Input!AI$2)","v":""},{"$f":"IF(Input!AJ$2=\"\",\"\",Input!AJ$2)","v":""},{"$f":"IF(Input!AK$2=\"\",\"\",Input!AK$2)","v":""},{"$f":"IF(Input!AL$2=\"\",\"\",Input!AL$2)","v":""},{"$f":"IF(Input!AM$2=\"\",\"\",Input!AM$2)","v":""},{"$f":"IF(Input!AN$2=\"\",\"\",Input!AN$2)","v":""},{"$f":"IF(Input!AO$2=\"\",\"\",Input!AO$2)","v":""},{"$f":"IF(Input!AP$2=\"\",\"\",Input!AP$2)","v":""},{"$f":"IF(Input!AQ$2=\"\",\"\",Input!AQ$2)","v":""},{"$f":"IF(Input!AR$2=\"\",\"\",Input!AR$2)","v":""},{"$f":"IF(Input!AS$2=\"\",\"\",Input!AS$2)","v":""},{"$f":"IF(Input!AT$2=\"\",\"\",Input!AT$2)","v":""},{"$f":"IF(Input!AU$2=\"\",\"\",Input!AU$2)","v":""},{"$f":"IF(Input!AV$2=\"\",\"\",Input!AV$2)","v":""},{"$f":"IF(Input!AW$2=\"\",\"\",Input!AW$2)","v":""},{"$f":"IF(Input!AX$2=\"\",\"\",Input!AX$2)","v":""},{"$f":"IF(Input!AY$2=\"\",\"\",Input!AY$2)","v":""},{"$f":"IF(Input!AZ$2=\"\",\"\",Input!AZ$2)","v":""},{"$f":"IF(Input!BA$2=\"\",\"\",Input!BA$2)","v":""},{"$f":"IF(Input!BB$2=\"\",\"\",Input!BB$2)","v":""},{"$f":"IF(Input!BC$2=\"\",\"\",Input!BC$2)","v":""},{"$f":"IF(Input!BD$2=\"\",\"\",Input!BD$2)","v":""},{"$f":"IF(Input!BE$2=\"\",\"\",Input!BE$2)","v":""},{"$f":"IF(Input!BF$2=\"\",\"\",Input!BF$2)","v":""},{"$f":"IF(Input!BG$2=\"\",\"\",Input!BG$2)","v":""},{"$f":"IF(Input!BH$2=\"\",\"\",Input!BH$2)","v":""},{"$f":"IF(Input!BI$2=\"\",\"\",Input!BI$2)","v":""},{"$f":"IF(Input!BJ$2=\"\",\"\",Input!BJ$2)","v":""}]
[{"$f":"IF('Burndown Chart'!$L$2=\"\",\"Planned Effort\",'Burndown Chart'!$L$2)","v":"Planned Effort"},{"$f":"SUM(Input!$B$3:$B$202)","v":850},{"$f":"IF(C$1=\"\",\"\",B$2-$B$2/(SUMPRODUCT(--($C$1:$BJ$1<>\"\"))))","v":800},750,700,650,600,550,500,450,400,350,300,250,200,150,100,50,0,"","","","","","","","","","","","","","","",{"$f":"IF(AI$1=\"\",\"\",AH$2-$B$2/(SUMPRODUCT(--($C$1:$BJ$1<>\"\"))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF('Burndown Chart'!$L$3=\"\",\"Hours Remaining\",'Burndown Chart'!$L$3)","v":"Hours Remaining"},{"$f":"SUM(Input!$B$3:$B$202)","v":850},{"$f":"IF(C$1=\"\",\"\",SUM(Input!C$3:C$202))","v":775},{"$f":"IF(D$1=\"\",\"\",SUM(Input!D$3:D$202))","v":725},{"$f":"IF(E$1=\"\",\"\",SUM(Input!E$3:E$202))","v":640},{"$f":"IF(F$1=\"\",\"\",SUM(Input!F$3:F$202))","v":560},{"$f":"IF(G$1=\"\",\"\",SUM(Input!G$3:G$202))","v":490},{"$f":"IF(H$1=\"\",\"\",SUM(Input!H$3:H$202))","v":500},{"$f":"IF(I$1=\"\",\"\",SUM(Input!I$3:I$202))","v":490},{"$f":"IF(J$1=\"\",\"\",SUM(Input!J$3:J$202))","v":490},{"$f":"IF(K$1=\"\",\"\",SUM(Input!K$3:K$202))","v":455},{"$f":"IF(L$1=\"\",\"\",SUM(Input!L$3:L$202))","v":375},{"$f":"IF(M$1=\"\",\"\",SUM(Input!M$3:M$202))","v":285},{"$f":"IF(N$1=\"\",\"\",SUM(Input!N$3:N$202))","v":200},{"$f":"IF(O$1=\"\",\"\",SUM(Input!O$3:O$202))","v":160},{"$f":"IF(P$1=\"\",\"\",SUM(Input!P$3:P$202))","v":150},{"$f":"IF(Q$1=\"\",\"\",SUM(Input!Q$3:Q$202))","v":100},{"$f":"IF(R$1=\"\",\"\",SUM(Input!R$3:R$202))","v":20},{"$f":"IF(S$1=\"\",\"\",SUM(Input!S$3:S$202))","v":0},{"$f":"IF(T$1=\"\",\"\",SUM(Input!T$3:T$202))","v":""},{"$f":"IF(U$1=\"\",\"\",SUM(Input!U$3:U$202))","v":""},{"$f":"IF(V$1=\"\",\"\",SUM(Input!V$3:V$202))","v":""},{"$f":"IF(W$1=\"\",\"\",SUM(Input!W$3:W$202))","v":""},{"$f":"IF(X$1=\"\",\"\",SUM(Input!X$3:X$202))","v":""},{"$f":"IF(Y$1=\"\",\"\",SUM(Input!Y$3:Y$202))","v":""},{"$f":"IF(Z$1=\"\",\"\",SUM(Input!Z$3:Z$202))","v":""},{"$f":"IF(AA$1=\"\",\"\",SUM(Input!AA$3:AA$202))","v":""},{"$f":"IF(AB$1=\"\",\"\",SUM(Input!AB$3:AB$202))","v":""},{"$f":"IF(AC$1=\"\",\"\",SUM(Input!AC$3:AC$202))","v":""},{"$f":"IF(AD$1=\"\",\"\",SUM(Input!AD$3:AD$202))","v":""},{"$f":"IF(AE$1=\"\",\"\",SUM(Input!AE$3:AE$202))","v":""},{"$f":"IF(AF$1=\"\",\"\",SUM(Input!AF$3:AF$202))","v":""},{"$f":"IF(AG$1=\"\",\"\",SUM(Input!AG$3:AG$202))","v":""},{"$f":"IF(AH$1=\"\",\"\",SUM(Input!AH$3:AH$202))","v":""},{"$f":"IF(AI$1=\"\",\"\",SUM(Input!AI$3:AI$202))","v":""},{"$f":"IF(AJ$1=\"\",\"\",SUM(Input!AJ$3:AJ$202))","v":""},{"$f":"IF(AK$1=\"\",\"\",SUM(Input!AK$3:AK$202))","v":""},{"$f":"IF(AL$1=\"\",\"\",SUM(Input!AL$3:AL$202))","v":""},{"$f":"IF(AM$1=\"\",\"\",SUM(Input!AM$3:AM$202))","v":""},{"$f":"IF(AN$1=\"\",\"\",SUM(Input!AN$3:AN$202))","v":""},{"$f":"IF(AO$1=\"\",\"\",SUM(Input!AO$3:AO$202))","v":""},{"$f":"IF(AP$1=\"\",\"\",SUM(Input!AP$3:AP$202))","v":""},{"$f":"IF(AQ$1=\"\",\"\",SUM(Input!AQ$3:AQ$202))","v":""},{"$f":"IF(AR$1=\"\",\"\",SUM(Input!AR$3:AR$202))","v":""},{"$f":"IF(AS$1=\"\",\"\",SUM(Input!AS$3:AS$202))","v":""},{"$f":"IF(AT$1=\"\",\"\",SUM(Input!AT$3:AT$202))","v":""},{"$f":"IF(AU$1=\"\",\"\",SUM(Input!AU$3:AU$202))","v":""},{"$f":"IF(AV$1=\"\",\"\",SUM(Input!AV$3:AV$202))","v":""},{"$f":"IF(AW$1=\"\",\"\",SUM(Input!AW$3:AW$202))","v":""},{"$f":"IF(AX$1=\"\",\"\",SUM(Input!AX$3:AX$202))","v":""},{"$f":"IF(AY$1=\"\",\"\",SUM(Input!AY$3:AY$202))","v":""},{"$f":"IF(AZ$1=\"\",\"\",SUM(Input!AZ$3:AZ$202))","v":""},{"$f":"IF(BA$1=\"\",\"\",SUM(Input!BA$3:BA$202))","v":""},{"$f":"IF(BB$1=\"\",\"\",SUM(Input!BB$3:BB$202))","v":""},{"$f":"IF(BC$1=\"\",\"\",SUM(Input!BC$3:BC$202))","v":""},{"$f":"IF(BD$1=\"\",\"\",SUM(Input!BD$3:BD$202))","v":""},{"$f":"IF(BE$1=\"\",\"\",SUM(Input!BE$3:BE$202))","v":""},{"$f":"IF(BF$1=\"\",\"\",SUM(Input!BF$3:BF$202))","v":""},{"$f":"IF(BG$1=\"\",\"\",SUM(Input!BG$3:BG$202))","v":""},{"$f":"IF(BH$1=\"\",\"\",SUM(Input!BH$3:BH$202))","v":""},{"$f":"IF(BI$1=\"\",\"\",SUM(Input!BI$3:BI$202))","v":""},{"$f":"IF(BJ$1=\"\",\"\",SUM(Input!BJ$3:BJ$202))","v":""}]
["Completed Tasks",0,{"$f":"IF(C$1=\"\",\"\",CountCTs(Input!C$3:C$202))","v":0},{"$f":"IF(D$1=\"\",\"\",CountCTs(Input!D$3:D$202))","v":2},{"$f":"IF(E$1=\"\",\"\",CountCTs(Input!E$3:E$202))","v":2},{"$f":"IF(F$1=\"\",\"\",CountCTs(Input!F$3:F$202))","v":0},{"$f":"IF(G$1=\"\",\"\",CountCTs(Input!G$3:G$202))","v":1},{"$f":"IF(H$1=\"\",\"\",CountCTs(Input!H$3:H$202))","v":1},{"$f":"IF(I$1=\"\",\"\",CountCTs(Input!I$3:I$202))","v":1},{"$f":"IF(J$1=\"\",\"\",CountCTs(Input!J$3:J$202))","v":0},{"$f":"IF(K$1=\"\",\"\",CountCTs(Input!K$3:K$202))","v":0},{"$f":"IF(L$1=\"\",\"\",CountCTs(Input!L$3:L$202))","v":0},{"$f":"IF(M$1=\"\",\"\",CountCTs(Input!M$3:M$202))","v":0},{"$f":"IF(N$1=\"\",\"\",CountCTs(Input!N$3:N$202))","v":1},{"$f":"IF(O$1=\"\",\"\",CountCTs(Input!O$3:O$202))","v":3},{"$f":"IF(P$1=\"\",\"\",CountCTs(Input!P$3:P$202))","v":0},{"$f":"IF(Q$1=\"\",\"\",CountCTs(Input!Q$3:Q$202))","v":1},{"$f":"IF(R$1=\"\",\"\",CountCTs(Input!R$3:R$202))","v":2},{"$f":"IF(S$1=\"\",\"\",CountCTs(Input!S$3:S$202))","v":1},{"$f":"IF(T$1=\"\",\"\",CountCTs(Input!T$3:T$202))","v":""},{"$f":"IF(U$1=\"\",\"\",CountCTs(Input!U$3:U$202))","v":""},{"$f":"IF(V$1=\"\",\"\",CountCTs(Input!V$3:V$202))","v":""},{"$f":"IF(W$1=\"\",\"\",CountCTs(Input!W$3:W$202))","v":""},{"$f":"IF(X$1=\"\",\"\",CountCTs(Input!X$3:X$202))","v":""},{"$f":"IF(Y$1=\"\",\"\",CountCTs(Input!Y$3:Y$202))","v":""},{"$f":"IF(Z$1=\"\",\"\",CountCTs(Input!Z$3:Z$202))","v":""},{"$f":"IF(AA$1=\"\",\"\",CountCTs(Input!AA$3:AA$202))","v":""},{"$f":"IF(AB$1=\"\",\"\",CountCTs(Input!AB$3:AB$202))","v":""},{"$f":"IF(AC$1=\"\",\"\",CountCTs(Input!AC$3:AC$202))","v":""},{"$f":"IF(AD$1=\"\",\"\",CountCTs(Input!AD$3:AD$202))","v":""},{"$f":"IF(AE$1=\"\",\"\",CountCTs(Input!AE$3:AE$202))","v":""},{"$f":"IF(AF$1=\"\",\"\",CountCTs(Input!AF$3:AF$202))","v":""},{"$f":"IF(AG$1=\"\",\"\",CountCTs(Input!AG$3:AG$202))","v":""},{"$f":"IF(AH$1=\"\",\"\",CountCTs(Input!AH$3:AH$202))","v":""},{"$f":"IF(AI$1=\"\",\"\",CountCTs(Input!AI$3:AI$202))","v":""},{"$f":"IF(AJ$1=\"\",\"\",CountCTs(Input!AJ$3:AJ$202))","v":""},{"$f":"IF(AK$1=\"\",\"\",CountCTs(Input!AK$3:AK$202))","v":""},{"$f":"IF(AL$1=\"\",\"\",CountCTs(Input!AL$3:AL$202))","v":""},{"$f":"IF(AM$1=\"\",\"\",CountCTs(Input!AM$3:AM$202))","v":""},{"$f":"IF(AN$1=\"\",\"\",CountCTs(Input!AN$3:AN$202))","v":""},{"$f":"IF(AO$1=\"\",\"\",CountCTs(Input!AO$3:AO$202))","v":""},{"$f":"IF(AP$1=\"\",\"\",CountCTs(Input!AP$3:AP$202))","v":""},{"$f":"IF(AQ$1=\"\",\"\",CountCTs(Input!AQ$3:AQ$202))","v":""},{"$f":"IF(AR$1=\"\",\"\",CountCTs(Input!AR$3:AR$202))","v":""},{"$f":"IF(AS$1=\"\",\"\",CountCTs(Input!AS$3:AS$202))","v":""},{"$f":"IF(AT$1=\"\",\"\",CountCTs(Input!AT$3:AT$202))","v":""},{"$f":"IF(AU$1=\"\",\"\",CountCTs(Input!AU$3:AU$202))","v":""},{"$f":"IF(AV$1=\"\",\"\",CountCTs(Input!AV$3:AV$202))","v":""},{"$f":"IF(AW$1=\"\",\"\",CountCTs(Input!AW$3:AW$202))","v":""},{"$f":"IF(AX$1=\"\",\"\",CountCTs(Input!AX$3:AX$202))","v":""},{"$f":"IF(AY$1=\"\",\"\",CountCTs(Input!AY$3:AY$202))","v":""},{"$f":"IF(AZ$1=\"\",\"\",CountCTs(Input!AZ$3:AZ$202))","v":""},{"$f":"IF(BA$1=\"\",\"\",CountCTs(Input!BA$3:BA$202))","v":""},{"$f":"IF(BB$1=\"\",\"\",CountCTs(Input!BB$3:BB$202))","v":""},{"$f":"IF(BC$1=\"\",\"\",CountCTs(Input!BC$3:BC$202))","v":""},{"$f":"IF(BD$1=\"\",\"\",CountCTs(Input!BD$3:BD$202))","v":""},{"$f":"IF(BE$1=\"\",\"\",CountCTs(Input!BE$3:BE$202))","v":""},{"$f":"IF(BF$1=\"\",\"\",CountCTs(Input!BF$3:BF$202))","v":""},{"$f":"IF(BG$1=\"\",\"\",CountCTs(Input!BG$3:BG$202))","v":""},{"$f":"IF(BH$1=\"\",\"\",CountCTs(Input!BH$3:BH$202))","v":""},{"$f":"IF(BI$1=\"\",\"\",CountCTs(Input!BI$3:BI$202))","v":""},{"$f":"IF(BJ$1=\"\",\"\",CountCTs(Input!BJ$3:BJ$202))","v":""}]
["Remaining Tasks",{"$f":"SUMPRODUCT(--(Input!$A$3:$A$202<>\"\"))","v":15},{"$f":"IF(C$1=\"\",\"\",B$5-C4)","v":15},{"$f":"IF(D$1=\"\",\"\",C$5-D4)","v":13},11,11,10,9,8,8,8,8,8,7,4,4,3,1,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]