{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Control","Record","Change_Log","Info","No_Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":31,"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":"Control","index":0,"n_rows":30,"n_cols":87,"rows_kept":30,"cut":false,"hidden":true,"merged":[[7,20,7,21],[21,3,21,13],[28,2,28,13],[22,4,22,13],[23,4,23,13],[7,1,7,13],[24,3,24,13]]}
[null,"STOP!       Read This:"]
[null,"DDPP PatchTo v 3.1.  This is the page from which the patch is installed. It will patch any sub-version of  version 2 of the database to v3.1.1 It will patch both the user and training files"]
[]
[null,"You do not need to run this if you have NOT populated the database"]
[null,"with your own data"]
[null,"- just start your database using the latest \"User\" version"]
[]
[null,"You may print out these instructions or those in the ReadMe_DDPP.txt file if you wish, but it is not necessary to do so.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(\"You have not chosen a valid option\",$CG:$CG,1,FALSE)),\"\",\"You MUST update your options\")","v":""}]
[]
[null,"Step 1:","Close Word, Access, PowerPoint and all other  MS Office applications (except Excel)"]
[]
[null,"Step 2:","Close all Excel files except this one and your User file / deficiency database"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CG13=\"\",\"\",IF($CG13=AS13,AX13,IF($CG13=BE13,BJ13,IF($CG13=BQ13,BV13,\"\"))))","v":""},{"$f":"IF($CG13=\"\",\"\",IF($CG13=AS13,BC13,IF($CG13=BE13,BO13,IF($CG13=BQ13,CA13,\"\"))))","v":""}]
[null,"Step 3:","Note that",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"‡","The file to be updated CANNOT BE ON A CD, it must be on a writeable drive."]
[null,null,"‡","The update can only run once on each file, unless no procedures were activated (see the Change_Log)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"‡","The database name is unchanged by the update, but one change is made to its \"properties\" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"‡","The update process backs up and saves your file on commencement, in the same directory as it was opened / last saved in, as Backup_yymmdd_original name.xls, where yymmdd are the current year month and date in two-digit numerical format, e.g. 1 Dec 2007 is 07121.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,"as Backup_yymmdd_original name.xls, where yymmdd are the current year month and date in two-digit numerical format,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null," e.g. 1 Dec 2007 is 07121.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,"You may re-name the file before you start, as you wish. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"‡","If the update stops part-way through with a message that your system is not configured to allow the update to continue: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,"•","YOU MUST exit the warning screen by clicking on the ??? Button before retrieving the file with the remediation instructions. The whole updater programme will close; restart it when you are ready. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,"•","The remediation instructions are only prepared when they are needed. When prepared they are to be found in the directory/folder the updater was opened from. The file is called DDPP_fix_VBA.xls. Alternatively the same information is in the file called ReadMe_DDPP.txt which should be in the same directory as this updater.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"‡","The updater has been tested and runs successfully on and over networks, although when running on remote servers it may take some time to save files. A difficulty has been found on networks with very high security that employ non-Microsoft software that controls Excel's access to network drives. If you are having difficulty running the update and you have this type of software on your network consult you network administrator. Alternatively, try transferring all the files to your \"C\" drive or another local drive (even a flash drive), and running it from there. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"Just a few more points before you run the update -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"After updating the database will close and this updater will remain open. Re-open the database whenever you wish to continue using it.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"After upgrading you may mark any duplicate sites as acceptable, when all duplicate site have been so marked the warning in row 8 will disappear, only to reappear when a new potentially duplicate site is entered. Duplicated treatments for a single deficiency will still unacceptable, will still produce errors and are still highlighted in the database.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Record","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Change_Log","index":2,"n_rows":96,"n_cols":89,"rows_kept":96,"cut":false,"hidden":true,"merged":[[47,22,47,23]]}
["Change Log"]
["v3.0 to v 3.1"]
[1,"Fixed issue where the worksheet was saving on exit after the user had answered \"Do not save\""]
[2,"Deficiencies with a chosen option of \"Accept\" are no-longer ranked. Previously they were ranked and confused the listing."]
[]
["v2.1.0 to v3.0.0"]
[1,"Fixed an error in the ranking logic that was picking up and incorrect column thus permitting duplicate priorities"]
[2,"Fix the error in the formula in column CM that causes the option \"accept\" to produce an error when entered against treatments 2 or 3"]
[3,"This sub-routine partially fixes a problem caused when the top row of the database (DD_Main) is deleted by a user. It places a warning in the row and adjusts \"offset\" formulae to reduce the chance of a problem."]
[4,"This sub fixes an issue with project prioritization that produces an error in preventing any deficiency being prioritized if there is no treatment against one row"]
[5,"The prompt to save when exiting the DDPP now works properly, allowing you to save or otherwise the changes you have made. previously they were saved regardless - due to a quirk of Excel  which has now been \"worked around\"."]
[6,"The prioritization process has change slightly, it no-longer uses \"Risk Reduction %\" but \"Risk Reduction\". This provides greater differentiation between similar works on different sites and will result in altered priorities on already-recorded projects."]
[]
["v2.0.1 to v2.1.0"]
[1,"Change Log updated"]
[2,"Corrected display of incorrect name when user identified as other than the log-in name"]
[3,"Fixed gap in grey shading in column F of the Deficiency Table"]
[4,"Allocated named range for default crash date start to the correct cell in the Lookups tab"]
[5,"Fixed macro that adds new rows to DD_Main to include the default crash start date"]
[6,"Removed data validation check being incorrectly applied to the \"Link to Estimate\" cells for Treatment Option 1 in DD_Main"]
[7,"Add hyperlink to \"Show Default Crash Date\" icon"]
[8,"Fixed incorrect link imported on \"Recommendations\" icon when opened from CD etc"]
[9,"Fixed \"Ref#\" error in conditional formatting formulae in cols AL to AN"]
[10,"Formatting in Treatment Table improved to make it clear when all essential data is not entered"]
[11,"New functionality added to make it easier to determine what columns have auto-filter applied to them."]
[12,"Setting for \"options\" such as auto calc now all contained in the \"User …\" module"]
[]
["V2.0 to v2.0.1"]
[1,"Change log updated"]
[2,"Errors in the title of the columns containing data about \"Work Cat of Choice\", \"Work Category of Chosen Option\", \"Recommended Overall Ranking\" corrected "]
[null,"and the columns re-arranged to a more user-friendly order."]
[3,"The cells for Treatment 2 Estimate Date now display correctly (pink) when a data entry is required."]
[4,"Likelihood Description for \"This Deficiency\" is now shown by default in detailed view"]
[5,"Cells in the treatment table that were pink are now grey to conform with the conventions used elsewhere in the workbook"]
[6,"New detail added to the Info sheet detailing the earliest useable estimate date."]
[7,"The \"Year Work is Programmed\" column (DH) formerly only gave a warning when a too-early start date is first entered. It now also displays orange backgrounds if the earliest start is later changed to a later date than the currently programmed one."]
[null,"'when a too-early start date is first entered but not if the earliest start is later changed."]
[8,"All instances of the formula \"=today()\" in all the estimate date columns are now converted to fixed dates, the current displayed date is used. Presence of the formula causes auto-update of dates which is not what is required"]
[9,"It is now possible to \"flag\" possible duplicates as acceptable, thus clearing the warnings and allowing them to work when a \"real\" duplicates are encountered"]
[10,"Formatting in the \"Record\" altered sheet to allow update data to be entered efficiently and displayed correctly."]
[11,"Changes made to some of the permanent VBA scripts to resolve compatibility problems encountered when adding rows to the main sheet under Excel 2000 "]
[]
["V1.1  to v 2"]
[1,"Interface now consistently identifies required fields as pink.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CI44=\"\",\"\",IF($CI44=AU44,AZ44,IF($CI44=BG44,BL44,IF($CI44=BS44,BX44,\"\"))))","v":""},{"$f":"IF($CI44=\"\",\"\",IF($CI44=AU44,BE44,IF($CI44=BG44,BQ44,IF($CI44=BS44,CC44,\"\"))))","v":""}]
[2,"Potentially Duplicate Sites produce and alert. Duplicate sites are permitted.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detail"]
[3,"Duplicate treatments for an individual deficiency produce a warning and \"break\" the calculations. Removing the duplication restores the calculation"]
[4,"Drop-down boxes now working consistently"]
[5,"Behaviour of “Cost/vehicle over 1 year” data is no-longer erratic  when weightings are changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(\"You have not chosen a valid option\",$CI:$CI,1,FALSE)),\"\",\"You MUST update your options\")","v":""}]
[6,"Non-negative weightings for ranking prioritization factors have been blocked"]
[7,"Data collection sheets produced and are available separately"]
[8,"In the Deficiency Types Table a copy of type ID is now automatically created in Column F \"Copy of DfcyType_ID\""]
[9,"The “Take me to the start of the row” button now available in the “Treatments” table"]
[10,"The  “green”, Chosen Option, cells of DD_Main now details of the chosen option's  work category",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CI53=\"\",\"\",IF($CI53=AU53,AZ53,IF($CI53=BG53,BL53,IF($CI53=BS53,BX53,\"\"))))","v":""},{"$f":"IF($CI53=\"\",\"\",IF($CI53=AU53,BE53,IF($CI53=BG53,BQ53,IF($CI53=BS53,CC53,\"\"))))","v":""}]
[11,"An Information sheet has been provided. It contains Tips and Hints but is not a proper \"Help\" file.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[12,"This change log is included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,"Programmed Year and Completed fields now interact appropriately and automatic formatting has been adjusted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,"Earliest Available Programme Year added, and a warning is given if this is before a higher priority project's dates.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,"Auto-filter added to the treatments table, using Excel functionality",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,"Lookup values that can be changed by users are now all in the \"Lookups\" Table. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[17,"Some Data validation lists are included in the validations themselves, where customisation is not appropriate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[18,"The \"Treatable\" column is now visible in the Simplified layout, resolving a problem that could occur with contradictory data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[19,"All data validation now working correctly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,"\"Drag and Drop\" copying is disabled in the spreadsheet but your settings are restored on exit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[21,"Made obvious those fields in the Likelihood and consequence tables can be changed to suit local risk management definitions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[22,"Work Category can now be sorted and then restored to its original order",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,"When a project is marked as completed it is no longer prioritised ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,"When a  deficiency has been actioned / remedied the cells columns D to G for that entry are greyed and struck-through",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,"It is more obvious in the \"Option Choice\" area of the spreadsheet which projects are complete",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,"A  “Links to other data” column has been provided next to each estimate column",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,"Speed of Print Layout improved significantly. Feedback given in status bar. Reverting to other layouts also sped up significantly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,"Automated population of “Who entered this deficiency” data, but not of \"Who changed\" data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,"Provided a “Go to the recommendations” box, similar in functionality to the “Take me to the start of the row” arrow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,"Spreadsheet checks for availability of macro permissions on loading. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[31,"A box has been provided to record the reasons why you did not go with the recommended option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[32,"The Print layout now provides for a title to be printed on each page. The First Time you use it you will need to put in a title of your choice. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"The title can be changed as you wish, at any time.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"Following discussion with, and decisions from, Land Transport NZ The following requested enhancements have not been included in this update",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"a.","The “Treatments” table should include columns for source of information and confidence/reliability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"An un-necessary complication at this stage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"b.","Include a Column with “Social Cost of Crashes” and use for prioritization.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"An un-necessary complication at this stage. Would be very generic and require population of crash data for each site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"c.","Hazards are recorded but how they are to be managed is not.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"Land Transport NZ are happy with the current situation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"d.","Could the Transit NZ Risk matrix also be included?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"Land Transport NZ are happy with the current matrix. Will reconsider this before the next update",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"e.","People in appointments change with time,  can a list of “authorised names” be included as a lookup to allow tracking of  these?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"An un-necessary complication at this stage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"f.","Extend automatic population of “who did this” type data to editing of existing data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"Reconsider for next update",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"g.","Can RAMM traffic count and crash-data  tables be included so that this data can be populated automatically?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"No, this is an \"interim\" system. Leave for RAMM. Quite complex to do in a spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"The following requested change was not included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"It  would be helpful if a data field could be selected on one of the “lookup tables” and automatically added to the correct cell in DD_Main"]
[null,null,"Very complicated to do this. Excel copying functionality is a simpler and as effective method to use. This functionality is explained in the \"Info\" sheet."]

{"sheet":"Info","index":3,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Deficiency Database and Prioritization Process Spreadsheet"]
[]
["Instructions, Hints and Useful Information"]
[]
[]
[]
[null,"Pink Cells must have data in them. Some of these may also have pull-downs"]
[]
[null,"Light Yellow Cells may have data"]
[]
[null,"Do Not write below the Red Lines"]
[]
[]
[null,"Do NOT write in the grey cells."]
[]
[null,"Do Not write in Green Cells"]
[]
[null,"You select your Chosen option in the Tan Cell by using the pull-down"]
[]
[null,"Sky Blue Cells in the Treatments Table indicate the data in that row comes from  Austroads March 2007 data"]
[]
[null,"Appears in Row 1 of all columns that have been \"Auto-filtered\""]
[]
["Warnings!","There are a number of error-checking routines that produce warnings in Red cells with yellow text. Most should be self-explanatory - the warning elated to start date is when the programmed date is before the earliest start date."]
[]
["Cautions!","There is a duplicate-checking routine, that looks for duplicated sites. While these are permitted they may be accidental and a warning is produced.\nEach duplicate site can be \"accepted\" which clears the individual warning for that row. When all individual warnings have been cleared the \"master warning in Row 8 is also cleared."]
[]
["PullDowns","Data \"pulldowns\" are at the bottom right of the active cell - do not confuse them with the auto filter pull-downs in row 12."]
[]
["Copying data","Drag and Drop is disabled in this spreadsheet.\nTo avoid scrolling through the pull-down lists after adding data to one of the \"Lookup Tabs\",\n     either Right Click>Copy then go to the destination and Right Click>Paste\n     or Edit>Copy then go to the destination and Edit>Paste\n     or Ctrl-C then go to the destination and Ctrl V"]
[]
["Navigate / Go Back","If you wish to return from a tabbed sheet to the one from which you came just click the tab of that sheet.\nAlternatively, to get a navigation bar with \"back arrows\" activate the Web toolbar at Tools>Customise>Toolbars and \"ticking\" the box next to \"Web\""]
[]
["Duplicate Sites","The Duplicate site test works on start and end RPs.\nIf two start distances on a road are within the \"Tolerance\" [see Lookups] the one with the \"shortest\" end distance will show as a duplicate site.\nA similar effect occurs with the end distances"]
[null,"If both start and end distances are within tolerances at start and end then both sites will show as duplicates"]
[]
["Project Ranking","Projects are ranked by the values of the chosen option. In version 1 the Risk component of this analysis was based on the values of the Recommended Option."]
[]
["Earliest Programme Year","This is calculated from the ranking of the project. IT HAS NO \"BUDGETARY\" INTELLIGENCE. It is the year that a higher priority project in the same work category is \"Programmed\", and has been included to assist in programming interventions in the order of their prioritization within work categories.\nThe first available programme year is always \"next year\""]
[]
["Work Category Sorting","Work Categories can be sorted alphabetically id required. There is an \"Original Order\" column to allow them to be restored to their \"default\" order if required."]
[]
["CCI","CCIs are updated sepertaely, using the \"CCI Updater\" spreadsheet and macros available from the NZTA website"]
[null,"From v 2-0-1 there is a column in the CCI table, against each index, this may periodically contain an \"R\" indicating that a base index from which it was derived was revised since during the preceding quarter by the Dept of Statistics.  There were some of these variations in the March Quarter by they were locked in by the June quarter and hence are not flagged in this update."]

{"sheet":"No_Macro","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"NZ Transport Agency Deficiency Database and Prioritization Process"]
[]
[null,"This spreadsheet uses Excel ® macros"]
[]
[null,"Macros are not enabled on this computer"]
[]
[null,"The Menu item: Tools> Macro> Security  should be set to Medium or Low"]
[null,null,"\"Medium\" will make use of the system frustrating, so \"Low\" is better"]
[]
[null,"You may need to get your network administrator's approval for this change"]
[]
[null,"Close this window and re-open the spreadsheet when the change has been made"]
[]
[null,"You should ignore these messages when closing the workbook"]
[]
[null,"If you think that macros should run please click on the shape. If this screen then remains in place you need to follow its instructions"]