{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","ISAAF2.0 ALC","Lookups"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"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":"Instructions","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2],[9,0,9,1],[31,0,31,1],[7,0,7,1],[6,0,6,1],[5,0,5,1],[4,0,4,1],[3,0,3,1],[26,3,26,4],[27,3,27,4],[28,3,28,4],[25,3,25,4],[24,3,24,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4]]}
["Instructions for Use - ISA Assurance Level Calculator",null,null,"<<<<Click to go to calculator"]
[]
["Legend"]
["Yellow Cells - Agency Input"]
["Light Blue Cells - Calculated and locked cells"]
["Red Cells - Calculated cell - Level 1 Project"]
["Amber Cells - Calculated cell - Level 2 Project"]
["Medium Green Cells - Calculated cell - Level 3 Project"]
[]
["Instructions for Risk Profiling Tool Tab"]
["Cell Ref.","Instruction","Example","Notes"]
["Cell B2","Enter the Project or Initiative Name","Project 123"]
["Cell B3","Enter State Government Investment / Impact as an integer of 'millions'","For $80.3m, enter \"80.3\"","The cell is pre-formatted"]
["Cell B4","Non State Government Investment as an integer of 'millions'","For $20.7m, enter \"20.7\"","The cell is pre-formatted"]
["Cell B5","This is the sum of cells C4 & C5 and is precalculated"]
["Cell B6","This cell Calculates the percentage of State GovernmentInvestment as a proiportion of the total"]
["Cell B7","Please enter the date in dd/mm/yy format","26/06/21","This cell is preformatted and will indicate \"Long Date\" format"]
["Cell C11","Select an item from the dropdown menu within Cell D11 which indicates the Level of Government Priority (KFA 1).  The corresponding Characteristic in E11 will automatically adjust to provide the description."]
["Cell C12","Select an item from the dropdown menu within the cell which indicates the Level of Service Criticality.  The corresponding Characteristic in E12 will automatically adjust to provide the description."]
["Cell C13","Select an item from the dropdown menu within the cell which indicates the Level of Interface Complexity (KFA 1).  The corresponding Characteristic in E13 will automatically adjust to provide the description."]
["Cell C14","Select an item from the dropdown menu within the cell which indicates the Level of Stakeholders and Approvals Complexity (KFA 2).  The corresponding Characteristic in E14 will automatically adjust to provide the description."]
["Cell C15","Select an item from the dropdown menu within the cell which indicates the Level of Environmental & Sustainability Complexity (KFA 3).  The corresponding Characteristic in E15 will automatically adjust to provide the description."]
["Cell C16","Select an item from the dropdown menu within the cell which indicates the Level of Funding & Procurement Complexity.  The corresponding Characteristic in E16 will automatically adjust to provide the description."]
["Cell C17","Select an item from the dropdown menu within the cell which indicates the Level of Delivery Complexity (KFA 5).  The corresponding Characteristic in E17 will automatically adjust to provide the description."]
["Cell C18","Select an item from the dropdown menu within the cell which indicates the Level of Agency Capability (KFA 5).  The corresponding Characteristic in E18 will automatically adjust to provide the description."]
["Cell D2","This is a calculated Cell to show the Risk Weighted Score.",0.85,"This cell will indicate if you have not fully completed the selections in Cells D11 to D18."]
["Cell D3","This is a calculated cell to indicate Project Level.","Level 1","The assurance level assessment is based upon ISA’s ‘High Value High Risk’ (HVHR) methodology, which combines qualitative criteria and the estimated total State Government financial investment to calculate an assurance level. As the combined risk profile increases and expenditure from the State Government\nincreases, the level of assurance that is applied increases. Level 1 is the highest level of assurance that can be applied to a project/program."]
["Cell D4","This is a calculated cell to indicate Project Level  Description.","High Value, High Risk.","This cell will indicate if you have not fully completed the selections in Cells D11 to D18."]
["Cell D5","This is a calculated cell to indicate Minimum Assurance Required. ","Gates 1-5"]
[]
[]
["Instructions for Submission",null,"Level","Project Level Description","Assurance Application"]
[1,"Save the file as an Excel file (*.xlsx) with the name convention of \"yyyymmdd Project Name Risk Calculator\", where yyyy is the year, mm is the month and dd is the day of the month.",1,"High Value, High Risk.","Gates 1-5 + monthly reporting"]
[2,"Save or print the File to a PDF format.",2,"Medium Value, Medium Risk.","Gates 1, 2 & 5 + monthly reporting"]
[3,"Email both the Excel and PDF files to ISAAssurance@sa.gov.au with the File name as the Subject Line",3,"Low Value, Low Risk. Reporting Only","Monthly reporting only"]
[null,null,4,"No action","No action"]

{"sheet":"ISAAF2.0 ALC","index":1,"n_rows":131,"n_cols":28,"rows_kept":131,"cut":false,"hidden":false,"merged":[[124,22,124,27],[24,1,24,6],[23,1,23,6]]}
["ISA Assurance Level Calculator","Please ensure all yellow highlighted cells are completed appropriately",null,{"$f":"IF(OR(D2=0,B5=0,C11=\"\",C12=\"\",C13=\"\",C14=\"\",C15=\"\",C16=\"\",C17=\"\",C18=\"\",B2=\"\",B8=\"\",B4=\"\"),\"Please complete all required fields\",\"\")","v":"Please complete all required fields"}]
["Project Name:",null,"Risk Weighted Score",{"$f":"H19*100","v":0}]
["State Government Investment / Impact",0,"Project Level  ",{"$f":"IFERROR(INDEX($C$27:$G$31,MATCH(D2,$B$27:$B$31),MATCH(B5,$C$26:$G$26)),\"Please complete all required cells\")","v":3}]
["Non State Government Investment",0,"Project Level  Description",{"$f":"IFERROR(IF(D3=\"\",\"\",VLOOKUP($D$3,$C$42:$E$44,2,1)),\"\")","v":"Low Value, Low Risk. Monthly Reporting Only"}]
["Project Capital Investment Value (whole $m's)",{"$f":"B3+B4","v":0},"Minimum Assurance Required:  ",{"$f":"IFERROR(IF(VLOOKUP($D$3,$C$42:$E$44,3)=0,\"\",VLOOKUP($D$3,$C$42:$E$44,3)),\"\")","v":"Monthly reporting only"}]
["State Government Investment Percentage",{"$f":"IFERROR(IF(B5>=B3,B3/B5,\"N/A\"),\"\")","v":""}]
[]
["Date:","2021-11-18"]
[]
["Criteria","Description","Risk or Requirement\n(Select from dropdown menu)","Characteristic","Score","Risk","Nominal Score","Weighting"]
["Government Priority \n(KFA 1)","The extent to which a Project or Program is a prioritised and forecast to occur, where:\n- The priority is mandated in a strategic government document, such as the 20-year ISA Infrastructure Plan, Election Commitment, SA Budget or as result of a legislative change.",null,{"$f":"IFERROR(VLOOKUP(C11,Govt,2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C11,$C$34:$D$38,2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E11,$F$34:$G$38,2),\"\")","v":""},{"$f":"(IFERROR(VLOOKUP(F11,$C$34:$E$38,3),\"\"))","v":""},0.1]
["Service Criticality","The extent to which a project / program is deemed to be crucial to meet a service or asset deficiency that, if not addressed, may have major adverse consequences on the provision of services",null,{"$f":"IFERROR(VLOOKUP(C12,Service,2),\"\")","v":""},"","","",0.1]
["Interface Complexity \n(KFA 1)","The extent to which successful delivery of the project/Program relies on other:\n - Organisations, where other organisations are involved in project funding or have operational responsibilities; and/or\n - Projects/ Programs, where delivery of the proposed project has an interdependency with other projects that may impact the project scope or cost.",null,{"$f":"IFERROR(VLOOKUP(C13,Interface,2),\"\")","v":""},"","","",0.05]
["Stakeholders and Approvals Complexity (KFA 2)","•  The extent to which the project will require extensive management of stakeholders including:\n   - Organisations: where the organisations are involved in project funding or have operational responsibilities; and/or\n   - Planning agencies: where rigorous management is required to obtain necessary approvals for the project\n•  Political – where there is a potential political interface and the outcomes of Projects / Programs may be impacted from this.",null,{"$f":"IFERROR(VLOOKUP(C14,Stakeholder,2),\"\")","v":""},"","","",0.1]
["Environmental & Sustainability Complexity (KFA 3)","The extent to which successful delivery may be impacted due to issues related to heritage, climate change and/ or sustainability.",null,{"$f":"IFERROR(VLOOKUP(C15,Enviro,2),\"\")","v":""},"","","",0.1]
["Funding & Procurement Complexity","The degree of certainty or complexity in funding or required procurement method required for the successful delivery of the Project. This could include complex mechanisms for funding such as Commonwealth, private or multiple funders, or sophisticated procurements such as PPP or (Agency) non-traditional methods. ",null,{"$f":"IFERROR(VLOOKUP(C16,Funding,2),\"\")","v":""},"","","",0.15]
["Delivery Complexity \n(KFA 5)","The degree of potential complexity a Project may face during project delivery, such as coordinating multiple project stages, relying on new or untested technologies which are difficult to forecast and complex terrain or geography, and the extent to which the project includes information and communications technology (ICT) elements",null,{"$f":"IFERROR(VLOOKUP(C17,Complexity,2),\"\")","v":""},"","","",0.25]
["Agency Capability \n(KFA 5)","The track record, level of skills and experience a Delivery Agency has demonstrated in Project / Program delivery, including the skills and expertise that may be recruited or procured for the development and/or delivery of the proposed Project / Program.",null,{"$f":"IFERROR(VLOOKUP(C18,Agency,2),\"\")","v":""},"","","",0.15]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($G$11:$G$18,$H$11:$H$18)","v":0}]
[]
[]
[]
[]
[null,"Do NOT change or delete these tables "]
[null,"Capital Investment Value"]
[null,"Weighted Score ",0,50,75,100,150]
[null,0,3,2,2,2,2]
[null,30.099999999999998,3,2,2,2,1]
[null,40.1,3,2,2,1,1]
[null,50.1,3,2,1,1,1]
[null,75.099999999999994,3,1,1,1,1]
[null,"The above are number format to allow for Matching (%'s don’t work)"]
[]
[null,null,"High",3,{"$f":"D34/4","v":0.75},0,"Very Low"]
[null,null,"Low",1,0.3,1,"Low"]
[null,null,"Medium",2,{"$f":"D36/4","v":0.5},2,"Medium"]
[null,null,"Very High",4,{"$f":"D37/4","v":1},3,"High"]
[null,null,"Very Low",0,{"$f":"D38/4","v":0},4,"Very High"]
[]
[]
[null,null,"Level","Value & Risk","Action"]
[null,null,1,"High Value, High Risk.","Gates 1-5 + monthly reporting"]
[null,null,2,"Medium Value, Medium Risk.","Gates 1, 2 & 5 + monthly reporting"]
[null,null,3,"Low Value, Low Risk. Monthly Reporting Only","Monthly reporting only"]
[]
[]
[]
[null,null,1,"High Value, High Risk.","Gates 1-5 + monthly reporting"]
[null,null,3,"Low Value, Low Risk. Monthly Reporting Only","Monthly reporting only"]
[null,null,2,"Medium Value, Medium Risk.","Gates 1, 2 & 5 + monthly reporting"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Government Investment "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Score ","0-$15m","$15m-$30m","$30m-$50m","$50m-$75m","$75m-$100m",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4,4,3,2,2,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,4,3,3,2,2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,4,3,3,2,2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.501,4,3,2,2,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.751,4,2,2,1,1,1]

{"sheet":"Lookups","index":2,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Lookups"]
["v1.1"]
["Agency capability: 15%"]
["High agency capability risk","Few number of similar projects delivered in the last 10 years.","Very high agency capability risk","Very high agency capability risk","Very High"]
["Low agency capability risk","Multiple, recurring projects of this type.","High agency capability risk","High agency capability risk","High Agency"]
["Medium agency capability risk","At least five projects of this type over the previous 5 years.","Medium agency capability risk","Medium agency capability risk","Medium"]
["Very high agency capability risk","No projects of this type delivered within the previous 10 years.","Low agency capability risk","Low agency capability risk","Low"]
["Very low agency capability risk","‘Business as usual’ type projects.","Very low agency capability risk","Very low agency capability risk","Very Low"]
[]
["Delivery complexity: 25%"]
["High delivery complexity","Project involves few stages and faces some complex deliverability issues.","Very high delivery complexity","Very High"]
["Low delivery complexity","Project type is fairly common and has been delivered within the previous 5 years.","High delivery complexity","High Agency"]
["Medium delivery complexity","Project faces few complex deliverability issues.","Medium delivery complexity","Medium"]
["Very high delivery complexity","Project involves multiple stages, new or untested technologies and face very complex deliverability issues e.g. complex terrain or environmental restrictions.","Low delivery complexity","Low"]
["Very low delivery complexity","Project type is common and recurring within the previous 5 years.","Very low delivery complexity","Very Low"]
[]
["Government priority: 10%"]
["High Government priority","Mandated priority project, and business case or construction to commence within projected estimates.","Very high Government priority","Very High"]
["Low Government priority","Mandated priority project, and business case and construction to commence outside forward estimates but within the next 3-6 years beyond forward projections.","High Government priority","High Agency"]
["Medium Government priority","Mandated priority project, and business case or construction to be completed outside projected estimates but within the next 1-2 years beyond forward projections.","Medium Government priority","Medium"]
["Very high Government priority","Mandated priority project, and business case or construction to be completed within projected estimates.","Low Government priority","Low"]
["Very low Government priority","Agency priority in strategic planning document over the next 10 years.","Very low Government priority","Very Low"]
[]
["Service Criticality: 10%"]
["High project need","Addresses a serious deficiency that could have a high impact upon service delivery for an existing community or the growth of a new community.","Very high project need","Very High"]
["Low project need","Addresses some deficiency that could have a low impact upon service delivery for an existing community or the growth of a new community.","High project need","High Agency"]
["Medium project need","Addresses an important deficiency that could have a medium impact upon service delivery for an existing community or the growth of a new community.","Medium project need","Medium"]
["Very high project need","Addresses an urgent and critical deficiency that could adversely impact service delivery for:\n - an existing community e.g. provision of water or energy security or the growth of a new community; \n - or an accelerated and unexpected demand for services e.g. meeting rising demand for correctional facilities or provide critical transport access.","Low project need","Low"]
["Very low project need","Addresses minor deficiency that could have a very low impact upon service delivery for an existing community or the growth of a new community e.g. provision of cultural projects.","Very low project need","Very Low"]
[]
["Funding & procurement complexity: 10%"]
["High funding & procurement complexity","- Funding arrangements are fairly complex and include multiple parties (Federal, local and private entities)\n- Unconventional complex procurement e.g. an Alliance or hybrid Alliance not normally undertaken by the agency.","Very high funding & procurement complexity","Very High"]
["Low funding & procurement complexity","- Funding arrangements are not complex and include no more than 2 entities (Federal, local or private entities).\n- Minor procurement complexity e.g. Directly Managed Contract or Design and Construct.","High funding & procurement complexity","High Agency"]
["Medium funding & procurement complexity","- Funding arrangements are not complex and include multiple parties (Federal, local and private entities)\n- Limited procurement complexity e.g. Early Contractor Involvement.","Medium funding & procurement complexity","Medium"]
["Very high funding & procurement complexity","- Funding arrangements are highly complex and include multiple parties (Federal, local and private entities)\n- Procurement Highly complex procurement e.g. Public Private Partnership (PPP), or a Hybrid that includes a PPP.","Low funding & procurement complexity","Low"]
["Very low funding & procurement complexity","Funding or procurement is straight forward and provided by a single party.","Very low funding & procurement complexity","Very Low"]
[]
["Stakeholders and approvals complexity: 10% "]
["High complexity","Project requires high amounts of management of stakeholders and/or approvals.","Very high complexity","Very High"]
["Low complexity","Project requires minimal amounts of management of stakeholders and/or approvals.","High complexity","High Agency"]
["Medium complexity","Project requires minor amounts of management of stakeholders and/or approvals.","Medium complexity","Medium"]
["Very high complexity","Project requires extensive management of stakeholders and/or approvals.","Low complexity","Low"]
["Very low complexity","Project requires no amounts of management of stakeholders and/or approvals.","Very low complexity","Very Low"]
[]
["Environmental and Sustainability complexity: 7.5%"]
["High complexity","Project has high complexity in relation to heritage, climate change and/or sustainability to issues.","Very high complexity","Very High"]
["Low complexity","Project has minimal complexity in relation to heritage, climate change and/or sustainability issues.","High complexity","High Agency"]
["Medium complexity","Project has a minor amount of complexity in relation to heritage, climate change and/or sustainability issues.","Medium complexity","Medium"]
["Very high complexity","Project has very high complexity in relation to heritage, climate change and/or sustainability issues.","Low complexity","Low"]
["Very low complexity","Project has no complexity in relation to heritage, climate change and/or sustainability issues","Very low complexity","Very Low"]
[]
["Project Interface complexity: 7.5%"]
["High interface complexity","Important interdependencies with other projects or services.","Very high interface complexity","Very High"]
["Low interface complexity","Minor Minimal interdependence with other projects or services.","High interface complexity","High Agency"]
["Medium interface complexity","Some Minor interdependencies with other projects or services.","Medium interface complexity","Medium"]
["Very high interface complexity","Fully interdependent on other projects or services.","Low interface complexity","Low"]
["Very low interface complexity","Very little or no interdependence on other projects or services.","Very low interface complexity","Very Low"]