{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Read me","Register","Dashboard","data validation"],"not_rendered":{"charts":4,"images":1,"defined_names":7,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Read me","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"merged":[[0,0,4,11],[8,0,8,11],[11,0,12,11],[15,0,16,11],[19,0,21,11]]}
["Read Me"]
[]
[]
[]
[]
[]
[]
["1)"]
["Dear User, thank you for using my template. Please remove sample entries from the register"]
[]
["2)"]
["Usually only cells on the sheet \"Register\" require data-entry. Cells containing formulas or functions are protected, the password is blank should you wish to modify anything."]
[]
[]
["3)"]
["To avoid typing mistakes resulting in incorrect dashboard results, the entries in some columns are restricted. To modify acceptable values change entries in corresponding tables on the sheet \"data validation\"."]
[]
[]
["4)"]
["To add an entry to the register click the first free cell in column \"Change #\" immediately under the last entry and start typing. Alternativly you can mark a cell in the last row and press \"Tab\" repeatedly until a new line/dataset is added automatically to the table."]

{"sheet":"Register","index":1,"n_rows":7,"n_cols":14,"rows_kept":7,"merged":[[0,0,0,1],[0,2,0,6],[0,11,0,12],[1,0,1,1],[1,2,1,6],[1,11,1,12]]}
["Project Name:",null,"[Project Name]",{"$nulls":8},"Last Updated Date:",null,"[last updated]"]
["Project Manager:",null,"[Project Manager]",{"$nulls":8},"Last Updated by:",null,"[updated by]"]
[]
["Change #","Change Description\n(current situation and desired outcome of change)","Request Date","Requestor","Type of Change  Request","Affected Milestone","Cost Impact (USD)","Time Impact (Workdays)","Change Priority","Change Status","Responsible","Target Date","Closing Date","Solution"]
[{"v":1,"d":"001"},"Scope addition…","2017-08-01","Client","Scope","MILE12345",{"v":10000,"d":"10,000"},30,"critical","approved","Peter","2017-08-02","2017-08-03","Variation order issued to contractor, cost and schedule impact agreed and approved"]
[{"v":2,"d":"002"},"Scope ommission…","2017-09-12","Client","Scope","MILE12346",{"v":-1500,"d":"-1,500 "},{"v":-3,"d":"-3 "},"medium","under review","Paul","2017-10-17"]
[{"v":3,"d":"003"},"Completion of … item is needed 2 days earlier to allow for testing…","2017-10-15","QA/QC Mngr.","Schedule","MILE12347",{"v":1000,"d":"1,000"},{"v":-2,"d":"-2 "},"high","approved","Mary","2017-10-25","2017-10-24","Change of activity sequence agreed, temp. extra resources to be provided, cost and time impact agreed and approved"]

{"sheet":"Dashboard","index":2,"n_rows":24,"n_cols":6,"rows_kept":24}
[{"$f":"Register[[#Headers],[Cost Impact (USD)]]","v":"Cost Impact (USD)"},{"$f":"SUM(Register!G:G)","v":{"v":9500,"d":"9,500"}},null,null,"Total No. Changes",{"$f":"COUNT(Register!A:A)","v":3}]
[{"$f":"Register[[#Headers],[Time Impact (Workdays)]]","v":"Time Impact (Workdays)"},{"$f":"SUM(Register!H:H)","v":25}]
[]
[{"$f":"IF('data validation'!C2=\"\",\"\",'data validation'!C2)","v":"open"},{"$f":"IF(A4=\"\",\"\",COUNTIF(Register!J:J,A4))","v":0},null,null,{"$f":"IF('data validation'!E2=\"\",\"\",'data validation'!E2)","v":"Client"},{"$f":"IF(E4=\"\",\"\",COUNTIF(Register!D:D,E4))","v":2}]
[{"$f":"IF('data validation'!C3=\"\",\"\",'data validation'!C3)","v":"under review"},{"$f":"IF(A5=\"\",\"\",COUNTIF(Register!J:J,A5))","v":1},null,null,{"$f":"IF('data validation'!E3=\"\",\"\",'data validation'!E3)","v":"Contractor"},{"$f":"IF(E5=\"\",\"\",COUNTIF(Register!D:D,E5))","v":0}]
[{"$f":"IF('data validation'!C4=\"\",\"\",'data validation'!C4)","v":"approved"},{"$f":"IF(A6=\"\",\"\",COUNTIF(Register!J:J,A6))","v":2},null,null,{"$f":"IF('data validation'!E4=\"\",\"\",'data validation'!E4)","v":"PM"},{"$f":"IF(E6=\"\",\"\",COUNTIF(Register!D:D,E6))","v":0}]
[{"$f":"IF('data validation'!C5=\"\",\"\",'data validation'!C5)","v":"rejected"},{"$f":"IF(A7=\"\",\"\",COUNTIF(Register!J:J,A7))","v":0},null,null,{"$f":"IF('data validation'!E5=\"\",\"\",'data validation'!E5)","v":"QA/QC Mngr."},{"$f":"IF(E7=\"\",\"\",COUNTIF(Register!D:D,E7))","v":1}]
[{"$f":"IF('data validation'!C6=\"\",\"\",'data validation'!C6)","v":""},{"$f":"IF(A8=\"\",\"\",COUNTIF(Register!J:J,A8))","v":""},null,null,{"$f":"IF('data validation'!E6=\"\",\"\",'data validation'!E6)","v":"Sponsor"},{"$f":"IF(E8=\"\",\"\",COUNTIF(Register!D:D,E8))","v":0}]
[{"$f":"IF('data validation'!C7=\"\",\"\",'data validation'!C7)","v":""},{"$f":"IF(A9=\"\",\"\",COUNTIF(Register!J:J,A9))","v":""},null,null,{"$f":"IF('data validation'!E7=\"\",\"\",'data validation'!E7)","v":""},{"$f":"IF(E9=\"\",\"\",COUNTIF(Register!D:D,E9))","v":""}]
[{"$f":"IF('data validation'!C8=\"\",\"\",'data validation'!C8)","v":""},{"$f":"IF(A10=\"\",\"\",COUNTIF(Register!J:J,A10))","v":""},null,null,{"$f":"IF('data validation'!E8=\"\",\"\",'data validation'!E8)","v":""},{"$f":"IF(E10=\"\",\"\",COUNTIF(Register!D:D,E10))","v":""}]
[{"$f":"IF('data validation'!C9=\"\",\"\",'data validation'!C9)","v":""},{"$f":"IF(A11=\"\",\"\",COUNTIF(Register!J:J,A11))","v":""},null,null,{"$f":"IF('data validation'!E9=\"\",\"\",'data validation'!E9)","v":""},{"$f":"IF(E11=\"\",\"\",COUNTIF(Register!D:D,E11))","v":""}]
[{"$f":"IF('data validation'!C10=\"\",\"\",'data validation'!C10)","v":""},{"$f":"IF(A12=\"\",\"\",COUNTIF(Register!J:J,A12))","v":""},null,null,{"$f":"IF('data validation'!E10=\"\",\"\",'data validation'!E10)","v":""},{"$f":"IF(E12=\"\",\"\",COUNTIF(Register!D:D,E12))","v":""}]
[]
[]
[]
[{"$f":"IF('data validation'!A2=\"\",\"\",'data validation'!A2)","v":"critical"},{"$f":"IF(A16=\"\",\"\",COUNTIF(Register!I:I,A16))","v":1},null,null,{"$f":"IF('data validation'!I2=\"\",\"\",'data validation'!I2)","v":"Cost"},{"$f":"IF(E16=\"\",\"\",COUNTIF(Register!E:E,E16))","v":0}]
[{"$f":"IF('data validation'!A3=\"\",\"\",'data validation'!A3)","v":"high"},{"$f":"IF(A17=\"\",\"\",COUNTIF(Register!I:I,A17))","v":1},null,null,{"$f":"IF('data validation'!I3=\"\",\"\",'data validation'!I3)","v":"Schedule"},{"$f":"IF(E17=\"\",\"\",COUNTIF(Register!E:E,E17))","v":1}]
[{"$f":"IF('data validation'!A4=\"\",\"\",'data validation'!A4)","v":"medium"},{"$f":"IF(A18=\"\",\"\",COUNTIF(Register!I:I,A18))","v":1},null,null,{"$f":"IF('data validation'!I4=\"\",\"\",'data validation'!I4)","v":"Scope"},{"$f":"IF(E18=\"\",\"\",COUNTIF(Register!E:E,E18))","v":2}]
[{"$f":"IF('data validation'!A5=\"\",\"\",'data validation'!A5)","v":"low"},{"$f":"IF(A19=\"\",\"\",COUNTIF(Register!I:I,A19))","v":0},null,null,{"$f":"IF('data validation'!I5=\"\",\"\",'data validation'!I5)","v":""},{"$f":"IF(E19=\"\",\"\",COUNTIF(Register!E:E,E19))","v":""}]
[{"$f":"IF('data validation'!A6=\"\",\"\",'data validation'!A6)","v":""},{"$f":"IF(A20=\"\",\"\",COUNTIF(Register!I:I,A20))","v":""},null,null,{"$f":"IF('data validation'!I6=\"\",\"\",'data validation'!I6)","v":""},{"$f":"IF(E20=\"\",\"\",COUNTIF(Register!E:E,E20))","v":""}]
[{"$f":"IF('data validation'!A7=\"\",\"\",'data validation'!A7)","v":""},{"$f":"IF(A21=\"\",\"\",COUNTIF(Register!I:I,A21))","v":""},null,null,{"$f":"IF('data validation'!I7=\"\",\"\",'data validation'!I7)","v":""},{"$f":"IF(E21=\"\",\"\",COUNTIF(Register!E:E,E21))","v":""}]
[{"$f":"IF('data validation'!A8=\"\",\"\",'data validation'!A8)","v":""},{"$f":"IF(A22=\"\",\"\",COUNTIF(Register!I:I,A22))","v":""},null,null,{"$f":"IF('data validation'!I8=\"\",\"\",'data validation'!I8)","v":""},{"$f":"IF(E22=\"\",\"\",COUNTIF(Register!E:E,E22))","v":""}]
[{"$f":"IF('data validation'!A9=\"\",\"\",'data validation'!A9)","v":""},{"$f":"IF(A23=\"\",\"\",COUNTIF(Register!I:I,A23))","v":""},null,null,{"$f":"IF('data validation'!I9=\"\",\"\",'data validation'!I9)","v":""},{"$f":"IF(E23=\"\",\"\",COUNTIF(Register!E:E,E23))","v":""}]
[{"$f":"IF('data validation'!A10=\"\",\"\",'data validation'!A10)","v":""},{"$f":"IF(A24=\"\",\"\",COUNTIF(Register!I:I,A24))","v":""},null,null,{"$f":"IF('data validation'!I10=\"\",\"\",'data validation'!I10)","v":""},{"$f":"IF(E24=\"\",\"\",COUNTIF(Register!E:E,E24))","v":""}]

{"sheet":"data validation","index":3,"n_rows":6,"n_cols":9,"rows_kept":6}
["Priority",null,"Status",null,"Requestor",null,"Responsible",null,"Change Type"]
["critical",null,"open",null,"Client",null,"Peter",null,"Cost"]
["high",null,"under review",null,"Contractor",null,"Paul",null,"Schedule"]
["medium",null,"approved",null,"PM",null,"Mary",null,"Scope"]
["low",null,"rejected",null,"QA/QC Mngr."]
[{"$nulls":4},"Sponsor"]