{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Project Management Dashboard","Project Data"],"not_rendered":{"charts":8,"images":1,"macros":0,"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":"Project Management Dashboard","index":0,"n_rows":172,"n_cols":11,"rows_kept":172,"cut":false,"hidden":false,"merged":[[154,1,154,3],[0,1,0,9],[1,1,1,14],[46,1,46,14],[72,1,72,14],[152,1,152,14],[112,1,112,14],[154,10,154,14],[155,1,155,3],[156,1,156,3],[157,1,157,3],[158,1,158,3],[168,1,168,3],[164,1,164,3],[165,1,165,3],[166,1,166,3],[167,1,167,3],[159,1,159,3],[160,1,160,3],[161,1,161,3],[162,1,162,3],[163,1,163,3],[155,10,155,14],[156,10,156,14],[157,10,157,14],[158,10,158,14],[159,10,159,14],[160,10,160,14],[161,10,161,14],[162,10,162,14],[163,10,163,14],[171,4,171,11],[164,10,164,14],[165,10,165,14],[166,10,166,14],[167,10,167,14],[168,10,168,14]]}
[null,"PROJECT MANAGEMENT DASHBOARD"]
[null,"TASK TIMELINE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PROJECT FINANCIALS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"RISK ANALYSIS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OPEN and PENDING ACTIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PROJECT REPORT"]
[]
[null,"TASK",null,null,"OWNER","SCHEDULE","BUDGET","RESOURCES","RISKS","ISSUES","COMMENTS"]
[null,"Kickoff",null,null,"Anna"]
[null,"Set Objectives",null,null,"Ken"]
[null,"Project Requirements",null,null,"Sara"]
[null,"Hardware Requirements",null,null,"James"]
[null,"Finalize Resource Plan",null,null,"Anna"]
[null,"Investor Presentation",null,null,"Ken"]
[null,"Staffing",null,null,"Sara"]
[null,"Construction",null,null,"James"]
[null,"Alpha Out",null,null,"Pete"]
[null,"Alpha Testing",null,null,"Jason"]
[null,"Beta Out",null,null,"Pete"]
[null,"Beta Testing",null,null,"Jason"]
[null,"Launch",null,null,"Pete"]
[null,"Future Planning",null,null,"Anna"]
[]
[]
[null,null,null,null,"CLICK HERE TO CONTACT SMARTSHEET AND LEARN MORE ABOUT SIGHTS"]

{"sheet":"Project Data","index":1,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,8,1,10],[9,8,10,10],[19,1,19,7],[20,2,20,4],[20,5,20,6],[20,7,21,7],[20,1,21,1],[1,1,1,6]]}
[null,"PROJECT MANAGEMENT DATA"]
[null,"TASK TABLE and TIMELINE",null,null,null,null,null,null,"TASK STATUS TRACKING"]
[null,"TASK","OWNER","BEGIN","FINISH","# of DAYS","STATUS",null,"STATUS","AMOUNT","%"]
[null,"Kickoff","Anna","2018-05-05","2018-05-06",{"$f":"E4-D4","v":1},"COMPLETE",null,"COMPLETE",4,{"$f":"J4/SUM(J4:J7)","v":0.2857142857142857}]
[null,"Set Objectives","Ken","2018-05-07","2018-05-12",{"$f":"E5-D5","v":5},"COMPLETE",null,"OVERDUE",2,{"$f":"J5/SUM(J4:J7)","v":0.14285714285714285}]
[null,"Project Requirements","Sara","2018-05-13","2018-05-20",7,"COMPLETE",null,"IN PROGRESS",2,{"$f":"J6/SUM(J4:J7)","v":0.14285714285714285}]
[null,"Hardware Requirements","James","2018-05-17","2018-05-22",5,"COMPLETE",null,"NOT STARTED",6,{"$f":"J7/SUM(J4:J7)","v":0.42857142857142855}]
[null,"Finalize Resource Plan","Anna","2018-05-23","2018-05-27",4,"OVERDUE"]
[null,"Investor Presentation","Ken","2018-06-04","2018-06-05",1,"OVERDUE"]
[null,"Staffing","Sara","2018-06-01","2018-06-05",4,"IN PROGRESS",null,"BUDGET"]
[null,"Construction","James","2018-06-06","2018-06-27",21,"IN PROGRESS"]
[null,"Alpha Out","Pete","2018-06-28","2018-06-29",1,"NOT STARTED",null,"PROJECTED","ACTUAL","REMAINDER"]
[null,"Alpha Testing","Jason","2018-06-29","2018-07-15",16,"NOT STARTED",null,1000000,880000,{"$f":"(I13-J13)","v":120000}]
[null,"Beta Out","Pete","2018-07-16","2018-07-17",1,"NOT STARTED"]
[null,"Beta Testing","Jason","2018-07-17","2018-07-30",13,"NOT STARTED"]
[null,"Launch","Pete","2018-08-01","2018-08-02",1,"NOT STARTED"]
[null,"Future Planning","Anna","2018-08-02","2018-08-04",2,"NOT STARTED"]
[]
[]
[null,"RISKS and PENDING ACTIONS"]
[null,"TASK","RISKS",null,null,"OPEN",null,"PENDING ACTIONS"]
[null,null,"HIGH","MEDIUM","LOW","ISSUES","REVISIONS"]
[null,"Kickoff",1,0,4,2,0,4]
[null,"Set Objectives",2,3,5,1,2,3]
[null,"Project Requirements",3,4,3,2,1,2]
[null,"Hardware Requirements",5,8,1,1,0,0]
[null,"Finalize Resource Plan",8,6,4,0,3,1]
[null,"Investor Presentation",5,0,0,2,0,2]
[null,"Staffing",6,4,0,1,2,3]
[null,"Construction",7,3,3,0,1,4]
[null,"Alpha Out",0,2,4,1,3,2]
[null,"Alpha Testing",4,4,5,2,0,0]
[null,"Beta Out",3,6,4,3,2,0]
[null,"Beta Testing",2,3,6,0,1,1]
[null,"Launch",1,1,7,1,0,2]
[null,"Future Planning",5,0,2,2,1,3]
[null,null,{"$f":"SUM(C23:C36)","v":52},44,48,18,16,27]