{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Instructions","Project Request Form","PIJ-EZ Assessment Form","PIJ Questions & Workflow","Full PIJ","PIJ Financials","Areas of Impact","Deliverables & Milestones","Invite Checklist","Conditions List","Approved Vendors","Section Titles","Popups","Invite Checklist Help Popups","Question Type Decoder","Tracking Data","Agency Names and Info","For ADOA-ASET Use Only","Version Notes","Printable PIJ Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":40,"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":213,"n_cols":18,"rows_kept":213,"cut":false,"hidden":false,"merged":[[1,17,6,23],[78,17,80,19],[167,3,173,11],[97,3,101,11],[93,3,95,11],[105,3,111,11],[81,3,84,11],[86,3,91,11],[113,3,123,11],[125,3,135,11],[137,3,145,11],[147,3,153,11],[155,3,164,11],[78,2,79,12],[1,1,2,13],[21,3,23,11],[199,3,206,11],[208,3,210,11],[212,3,218,11],[175,3,184,11],[186,3,197,11],[25,3,27,11],[29,3,31,11],[33,3,36,11],[4,2,5,12],[7,3,8,11],[10,3,16,11],[18,2,19,12],[73,3,76,11],[46,2,47,12],[49,3,51,11],[41,3,43,11],[38,3,39,11],[53,3,55,11],[57,3,60,11],[62,3,65,11],[67,3,71,11]]}
[]
[null,"Instructions*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*  The instructions regarding the PIJ process are written in a general manner for any Agency to follow. If there are specific rules regarding the PIJ process that have been established by your Agency, please follow your own internal processes, prior to setting up the collaborative approval meeting, or submitting a PIJ or PIJ-EZ."]
[]
[]
[null,null,"A. Prior to filling out the Sheet"]
[]
[]
[null,null,null,"Save the file to a location of your choosing. The file must be saved, it cannot be opened and used from an email, or used directly from the website without being saved first."]
[]
[]
[null,null,null,"Ensure that any prompts to enable macros and content are accepted. If you receive a MACRO error,  please ensure that your security setting for EXCEL is set to “medium” in order for the macros within this Form to work.  This can be accomplished by re-opening the Form in MS Excel 2010 or later, and selecting the “Enable Content” when the Security Warning appears at the top of the screen.  If you are using MS Excel 2007, go to Tools/Macro/Security/select “medium” radio button/hit OK, and then re-open the Form and select “Enable Macro” when asked."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"B. Project Request Form"]
[]
[]
[null,null,null,"Complete each section of the Project Request form. The top half of the form consists of basic Agency information, project sponsor, and contact information, etc."]
[]
[]
[]
[null,null,null,"The bottom half of the form should be used to describe the business problem, benefits to the State and/or Agency, as well as any preferred solution that may be selected. (The specific solution is optional for this form)"]
[]
[]
[]
[null,null,null,"If additional Contacts are required, use the \"Click to Add Contacts\" button at the bottom of the sheet. Choose how many additional contacts you would like added, and a section for additional contacts will be created to be filled out."]
[]
[]
[]
[null,null,null,"Once the Project Request has been completed, the Agency Sponsor or other project contact will need to email the form to the Agency CIO or IT Support group responsible for technology related projects using the button provided at the bottom of the form, if MS Outlook is available."]
[]
[]
[]
[]
[null,null,null,"If MS Outlook is not available and you need to create the email manually, please copy ITProjects@azdoa.gov which will allow metrics on the PIJ-EZ process to be collected."]
[]
[]
[null,null,null,"If the Agency does not have dedicated IT personnel, or would like assistance in completing the Project Request form, please send the form directly to Strategic_Oversight@azdoa.gov."]
[]
[]
[]
[]
[null,null,"C. PIJ-EZ Assessment Form"]
[]
[]
[null,null,null,"The PIJ-EZ form is progressive. Once you answer the first question, subsequent questions will appear for you to answer. "]
[]
[]
[]
[null,null,null,"As each question is answered, you will proceed to the next question, or an advisory pop-up may appear that a full PIJ must be completed. "]
[]
[]
[]
[null,null,null,"If a full PIJ is required, you may submit the partially completed form to Strategic_Oversight@azdoa.gov and someone from ADOA-ASET will contact you to discuss next steps, or you may start the full PIJ process by selecting the Launch Full PIJ button at the top right of the PIJ-EZ Assessment Form tab ."]
[]
[]
[]
[]
[null,null,null,"If all questions are answered and a PIJ-EZ is appropriate, you will get a message stating that the form qualifies for a PIJ-EZ. Information from the Project Request tab will be automatically copied to the PIJ-EZ Assessment tab to be edited as needed by the Agency CIO."]
[]
[]
[]
[]
[null,null,null,"Once all of the information has been reviewed and edited, the completed MS Excel file can be uploaded to ProcureAZ to support the associated Purchase Order (P.O.). If your process is to print a paper copy or PDF as supporting documentation for the P.O, then the entire workbook, including both the Project Request Form and PIJ-EZ Assessment Form tabs, can be printed either as paper or a PDF, and attached to the associated P.O."]
[]
[]
[]
[]
[]
[null,null,null,"Using the button provided on the PIJ-EZ form, email a copy of the fully completed MS Excel file to ITProjects@azdoa.gov, or you can email it via your preferred method, if MS Outlook is not available. Unless the proposed acquisition could result in serious risk exposure to the State, no action will be taken by ADOA-ASET regarding the PIJ-EZ submission.  "]
[]
[]
[]
[]
[null,null,"D. Full PIJ Form"]
[]
[]
[null,null,null,"The Full PIJ form will be accessed one of two ways. During the PIJ-EZ questionnaire, the form may have prompted that a full PIJ is necessary, or if it is known that a full PIJ would be needed, click the Launch Full PIJ button at the top right on the PIJ-EZ Assessment Form tab. The following instructions are based upon when either of those two options occur."]
[]
[]
[]
[]
[null,null,null,"Upon pressing the Launch Full PIJ button, or selecting Yes to the prompt to start the Full PIJ from the PIJ-EZ questionnaire, additional tabs will appear at the bottom of the spreadsheet, which are used to capture data for the full PIJ. The new PIJ process is designed to present the user with a series of questions, tailored to the solution being proposed, in an easy-to-use “Turbo Tax™”-like format.  After clicking the Full PIJ tab at the bottom of the form, the user can click the PIJ Main Menu button to start the process.  "]
[]
[]
[]
[]
[]
[]
[null,null,null,"The Main Menu will appear as a pop-up, with a Start button that will allow the user to begin answering a series of questions regarding the PIJ, and with other buttons available to access the various features that have been built into the form."]
[]
[]
[]
[null,null,null,"Answer as many or as few of the questions as desired, or the Agency IT group is able to answer with the information available, before clicking Save and Exit, going back to the Full PIJ tab, and using the button provided to send the PIJ “as is” to the ITProjects@azdoa.gov mailbox. Any questions that are not answered, or will require further discussion, can be addressed as part of the collaborative process."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The short set of questions that make up the Meeting Pre-Work section of the PIJ are intended to set the stage for the initial collaborative meeting, which will be used to ensure that any and every potential opportunity or risk associated with the IT project can be brought to light, and that nothing is forgotten that might result in re-work. For some projects, this may be a one-time proposal that will result in a PIJ approval, or for others, it could function as more of an exploratory session, where representatives from Security, Procurement, ADOA-ASET, and others, can provide input and assistance. "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The Problem Description, Benefit, and Proposed Solution from the Project Request Form tab will be automatically brought into the new PIJ form, where adjustments can be made as needed. The remaining questions in the Meeting Pre-Work section are intended to capture basic information regarding the IT project, which may be sent under separate cover, or to indicate what level of support ADOA-ASET may need to provide in order for the project to move forward. If the Agency is ready to schedule the meeting after this initial set of questions is addressed, the user can go back to the Main Menu to select the Meeting Invite Checklist button, or can continue to address any/all remaining questions by clicking the Next button at the bottom right of the question box. If you do leave the Main Menu and come back at a later point, the main button on that menu will now show Resume, instead of Start, to indicate that you are continuing to fill out a PIJ that has already been started. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Clicking the Meeting Invite Checklist button on the Main Menu will display another pop-up, which can be used as a tool to help the meeting scheduler identify the stakeholders to invite, and also capture contact information as well as if/when the individual has had an opportunity to review the PIJ. By clicking the ? button next to each role, the user will see that the Project Sponsor, the Agency CIO and ISO, and the ADOA-ASET Strategic Program Manager must be invited, if the intent is for the PIJ to be approved in the meeting. Other individuals should be invited depending on the nature and scope of the IT project. The list can be updated at any time by clicking the Meeting Invite Checklist button again. To view or print the completed checklist, go to the Invite Checklist tab at the bottom of the form, after clicking the Save and Exit button on the Main Menu. The PIJ and any supporting materials should be sent to all attendees prior to the meeting."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"To continue filling out the PIJ, clicking Resume from the Main Menu, or Next after completing the Meeting Pre-Work section, will present the user with additional questions regarding the PIJ.  These questions are also broken into categories, which can be found by clicking the View PIJ Sections button, with each section/category designed to address specific risks. Only the questions that are applicable to the project will be asked, the sections do not have to be completed in the order listed, nor do the questions in a section need to be answered in a particular order. Any question can be skipped by clicking Next, and can be re-addressed at a later point by clicking the Previous button as needed, or going directly to the applicable section."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Most questions can be answered by clicking on either a Yes or No box, or selecting from a list of options by checking one box and specifying an ‘other’ selection, if required. Any checked box can be switched by simply checking an alternate box. Responses to certain questions will determine the following question in some cases, and some responses will need to be manually entered. All Yes/No questions provide an option for entering additional comments, if desired, by clicking on the Add/Expand Notes button at the bottom of the question box.  "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"At any time, the user may stop the process by clicking the Main Menu button, where you can Save and Exit the questions, at which point the MS EXCEL file will be saved in an accessible file folder, and can be closed. When ready to continue working through the questions, simply open the saved file, click PIJ Main Menu and click the Resume button on the Main Menu pop-up. This will take the user to the exact spot in the form where the last question was answered, making scrolling through the previous information unnecessary. The Main Menu also provides the option to jump to a specific category of questions by selecting the View PIJ Sections button. This view allows the user to track the progress that has been made in completing each section, based on the number of questions already answered and how many are left to complete."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Other buttons on the Main Menu allow the user to Reset Project, which will clear out any information previously entered into the PIJ, as well as Generate Printable PIJ, which can then be viewed and printed out by clicking on the Printable PIJ Version tab at the bottom of the form. Resource information is also available, including the Instructions, Available Statewide Enterprise Solutions and ADOA-ASET Approved Hosted/Cloud Environments, along with a Spell Check option for checking/correcting any text boxes that may have been entered in the PIJ.    "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"A Question Wrap-up screen will appear at the end of the main PIJ questions section. If not enough information is available to complete the PIJ Financials section at this time, the user may skip that section, however it will need to be completed before the PIJ can be approved. By clicking the Save & go to next section button on this screen, the user will be presented with another series of pop-ups, as part of the Areas of Impact section. This section has been designed to make it easier to specify the technology areas that the project may involve. The Areas of Impact was a separate tab in the embedded MS EXCEL spreadsheet in prior versions of the MS WORD PIJ form. For each applicable area, the user can select all that apply from a list of options, by checking each applicable box and specifying an ‘other’ selection, if required."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"If sufficient information has been gathered regarding both the development (implementation) and operational (ongoing) costs associated with the project, the user will be prompted to complete the PIJ Financials tab. The format of this worksheet is similar to the embedded MS EXCEL spreadsheet in prior versions of the MS WORD PIJ form, but has been enhanced to allow additional detail rows to be added, and to automatically calculate and pre-populate the Cost Summary table. Financial information regarding the project, including cost by category and fiscal year, and Funding Source by category (Fund Name is no longer required) should be entered directly into this worksheet, which can also be accessed at any point by clicking Save and Exit from the Main Menu, and clicking on the PIJ Financials tab. If you would like to go back and view the questions that were previously answered at this point, click the Return to PIJ Main Menu button at the top of this worksheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"While the PIJ can be sent as an attachment, along with the supporting materials, to all attendees prior to the meeting, you can also use the Generate Printable PIJ button on the Main Menu at any time to print a hard-copy or PDF of the PIJ responses that have been entered. A pop-up will ask whether you would like to run Spell Check on the form prior to generating the printed report. This printed version can be accessed from the Printable PIJ Version tab, after clicking Save and Exit on the Main Menu. The PIJ Financials, Areas of Impact (which will now be visible), Deliverables & Milestones, and Invite Checklist tabs can also be printed at this time as well."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"At any point in this process, the PIJ can be submitted to ADOA-ASET or sent “as is” by clicking the Save and Exit button on the Main Menu, going to the Full PIJ tab, and using the button provided to send the PIJ to the ITProjects@azdoa.gov mailbox. "]
[]
[]
[]
[null,null,null,"The Official ADOA-ASET Use Only worksheet is intended for use by the ADOA-ASET Strategic Program Manager as a final checklist, to ensure that all items required for PIJ approval have been addressed. Depending on whether the PIJ is Approved, Approved with Conditions, or Not Approved in the meeting, applicable information will be captured in this section. If the PIJ is approved, the ADOA-ASET Strategic Program Manager will send an email shortly after the meeting, notifying the Agency Director and all stakeholders regarding the approval, including any Conditions, and with the final PIJ form attached."]

{"sheet":"Project Request Form","index":1,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[22,2,22,8],[23,2,23,8],[25,1,26,9],[10,2,10,8],[1,1,2,9],[4,2,5,8],[7,2,7,8],[8,2,8,8],[9,3,9,5],[21,3,21,5],[11,2,11,8],[13,2,13,8],[14,2,14,8],[15,3,15,5],[16,2,16,8],[17,2,17,8],[18,3,18,5],[19,2,19,6],[19,7,19,8],[20,2,20,6],[20,7,20,8],[27,1,32,9],[34,1,35,9],[65,3,67,7],[68,3,68,7],[43,1,44,9],[45,1,50,9],[53,1,54,9],[55,1,55,9],[59,3,60,7],[62,3,63,7],[36,1,41,9]]}
[]
[null,"Project Request"]
[]
[]
[null,null,"[- Please Enter the Project Title Here -]"]
[]
[]
[null,null,"Agency Requesting The Project:"]
[]
[]
[null,null,"Business Unit Requesting The Project:"]
[]
[]
[null,null,"Sponsor Of the Project:"]
[]
[]
[null,null,"Sponsor Title:"]
[]
[]
[null,null,"Sponsor Phone Number:",null,null,null,null,"Extension:"]
[]
[]
[null,null,"Sponsor Email Address:"]
[]
[]
[null,"What is the operational issue or business need that the Agency is trying to solve?                                                              Explain Below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"How will this solution benefit the State or the Agency?"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do you have a specific solution in mind? If so, please describe the solution, including brand names of products, technologies, and vendors where appropriate. (Optional)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once the above is completed, email the file to your CIO or IT Support Group using the button below. If you do not have dedicated IT personnel, please send this file to ADOA-ASET directly at:"]
[]
[null,"Strategic_Oversight@azdoa.gov"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"* MS Outlook required. If you are using an alternate mail application please send this file to your Agency CIO or IT Group and cc:"]
[]
[]
[null,null,null," ITProjects@azdoa.gov"]

{"sheet":"PIJ-EZ Assessment Form","index":2,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[21,4,23,11],[25,4,26,11],[27,4,27,11],[0,1,1,13],[3,2,4,12],[6,2,7,12],[6,16,7,21],[0,17,2,21],[3,17,4,21],[5,17,5,21],[17,4,19,11]]}
[null,"PIJ-EZ Assessment Form"]
[]
[]
[null,null,"↓  Below to be filled out by an authorized Agency IT professional or in consultation with ADOA-ASET:  ↓",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For APF & ITAC please download the older PIJ form Here: "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://aset.az.gov/pij-information-and-documentation"]
[null,null,"Does this IT acquisition involve funding from the Automation Projects Fund (APF), or other legislative funding source that requires special attention from JLBC or OSPB?*",null,null,null,null,null,null,null,null,null,null,null,null,null,"*If a funding source has not been identified, select \"No\", however, one will be needed before you can proceed with the acquisition. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"If you are directed to the full PIJ anywhere in this form, the proposed project does not meet the criteria established for a PIJ-EZ.  If a disqualifying response was checked inadvertently, you may uncheck the selected box, and check the alternate option."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"*   MS Outlook required. If you are using an alternate mail application please send your completed file to:"]
[]
[null,null,null,null," ITProjects@azdoa.gov"]

{"sheet":"PIJ Questions & Workflow","index":3,"n_rows":97,"n_cols":17,"rows_kept":97,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,"Resume Point","Section","Parent or Child","Sub Question Trigger","Type of Question","Question","Answer","Comments","Costs","Estimated Start Date","Estimated Finish Date","Risk (H,M,L)","Popup/Disclaimer Needed and Qualifier (Y)","Popup/Disclaimer Reference (Y,N)","Not Sure Prompt","Count Question"]
[null,null,"Meeting Pre-Work","P",null,"C","Has a Project Request been completed for this PIJ?","Y",null,null,null,null,null,null,null,null,{"$f":"IF(D4 = \"P\",\"X\",IF(E4 =H3,\"X\",\"\"))","v":"X"}]
[null,"X","Meeting Pre-Work","P",null,"F","What is the operational issue or business need that the Agency is trying to solve? (i.e. …current process is manual, which increases resource time/costs to the State/Agency, and leads to errors...)","",null,null,null,null,null,null,null,null,"X"]
[null,null,"Meeting Pre-Work","P",null,"F","How will solving this issue or addressing this need benefit the State or the Agency?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Meeting Pre-Work","P",null,"F","Describe the proposed solution to this business need:",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Meeting Pre-Work","P",null,"C","Has the existing technology environment, into which the proposed solution will be implemented, been documented?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Meeting Pre-Work","C","Y","F","Indicate where that documentation can be found, or provide the information under separate cover before the meeting, otherwise describe below:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Meeting Pre-Work","C","N","F","Please describe the existing technology environment into which the proposed solution will be implemented. ",null,null,null,null,null,null,null,null,null,{"$f":"IF(D10 = \"P\",\"X\",IF(E10 =H8,\"X\",\"\"))","v":""}]
[null,null,"Meeting Pre-Work","P",null,"C","Have the business requirements been gathered, along with any technology requirements that have been identified?  ",null,null,null,null,null,null,"Y","1,0",null,{"$f":"IF(D11 = \"P\",\"X\",IF(E11 =H9,\"X\",\"\"))","v":"X"}]
[null,null,"Meeting Pre-Work","C","N","F","Please explain below why the requirements are not available:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Prior to Proceeding","P",null,"B","If the existing technology environment has been documented and all of the requirements gathered, you can proceed to schedule a meeting to discuss the PIJ. To assist in organizing the meeting, please use the \"Meeting Checklist\" on the main menu to help determine who will be required at the meeting, and document the meeting attendees.   You may complete as many of the following questions as possible, or can submit the PIJ \"as is\" by using the button located on the \"Full PIJ\" tab where you launched the Main Menu, and will be contacted by an ADOA-ASET representative to assist.  Prior to the meeting, please send the PIJ along with any supporting documents to all attendees."]
[null,null,"Pre-PIJ/Assessment","P",null,"C","Are you submitting this as a Pre-PIJ in order to issue a Request for Proposal (RFP) to evaluate options and select a solution that meets the project requirements?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Pre-PIJ/Assessment","C","Y","C","Is the final Statement of Work (SOW) for the RFP available for review?    ",null,null,null,null,null,null,"Y","1,2",null,""]
[null,null,"Pre-PIJ/Assessment","P",null,"C","Will you be completing an assessment/Pilot/RFP phase, i.e., an evaluation by a vendor, third party or your agency, of the current state, needs, and desired future state, in order to determine the cost, effort, approach (RFP or otherwise) and/or feasibility of a project before submitting the full PIJ?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Pre-PIJ/Assessment","C","Y","F","Describe the reason for completing the assessment/Pilot/RFP and the expected deliverable(s) below:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Pre-PIJ/Assessment","C",{"$f":"IF($H$14 =\"Y\",\"Y\",IF($H$16 = \"Y\",\"Y\",\"X\"))","v":"X"},"V","Provide the estimated cost, if any, to conduct the assessment phase and/or Pilot and/or RFP/solicitation process:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D18 = \"P\",\"X\",IF(E18 =H16,\"X\",\"\"))","v":""}]
[null,null,"Pre-PIJ/Assessment","C",{"$f":"IF($H$14 =\"Y\",\"Y\",IF($H$16 = \"Y\",\"Y\",\"X\"))","v":"X"},"D","Provide the estimated start and finish date for conducting the assessment/Pilot/RFP solicitation:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D19 = \"P\",\"X\",IF(E19 =H16,\"X\",\"\"))","v":""}]
[null,null,"Pre-PIJ/Assessment","C",{"$f":"IF($H$14 =\"Y\",\"Y\",IF($H$16 = \"Y\",\"Y\",\"X\"))","v":"X"},"D","Provide a projected start and finish date for implementing the final solution.",null,null,null,null,null,null,null,null,null,{"$f":"IF(D20 = \"P\",\"X\",IF(E20 =H16,\"X\",\"\"))","v":""}]
[null,null,"Pre-PIJ/Assessment","C",{"$f":"IF($H$14 =\"Y\",\"Y\",IF($H$16 = \"Y\",\"Y\",\"X\"))","v":"X"},"V","Based on research to date, provide a high-level cost estimate to implement the final solution below:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D21 = \"P\",\"X\",IF(E21 =H16,\"X\",\"\"))","v":""}]
[null,null,"Process","P",null,"C","Does the project fall into one of the following categories:\n\n- hardware technology refresh/expansion, e.g., replacement/more laptops, radios, peripherals, etc.? \n\n- software version refresh/additional licenses, e.g., MS Office 2013 replacing 2010, extra software licenses needed for additional PCs?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Process","C","Y","C","Is there any possibility that project implementation costs could reach $1 million or more?",null,null,null,null,null,null,"Y","0,4",null,""]
[null,null,"Process","P",null,"C","Is the proposed procurement the result of an RFP solicitation process?",null,null,null,null,null,null,"Y","3,0",null,"X"]
[null,null,"Process","P",null,"C","Is this project referenced in your agency’s Strategic IT Plan? ",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Project","P",null,"C","Does your agency have a formal project methodology in place?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Project","P",null,"F","Describe the high level make-up and roles/responsibilities of the Agency, Vendor(s), and other third parties below: (i.e. …agency will do…vendor wil do…other third parties will do..)",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Project","P",null,"C","Will a PM be assigned to manage the project, regardless of whether internal or vendor provided?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Project","C","Y","F"," If the PM is credentialed, e.g., PMP, CPM, State certification etc., please provide certification information below:  ",null,null,null,null,null,null,null,null,null,""]
[null,null,"Schedule","P",null,"C","Is a project plan available that reflects the estimated start date and end date of the project, and the supporting milestones for the project?",null,null,null,null,null,null,"Y","5,0",null,"X"]
[null,null,"Schedule","C","N","D","Provide an estimated start and finish date for implementing the proposed solution:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Schedule","C","N","DS","How were the start and end dates determined:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D32 = \"P\",\"X\",IF(E32 =H30,\"X\",\"\"))","v":""}]
[null,null,"Schedule","C","N","M","List the expected high level project tasks/milestones of the project, e.g., acquire new web server, develop software interfaces, deploy new application, production go live, and estimated start/finish dates for each, if known.",null,null,null,null,null,null,null,null,null,{"$f":"IF(D33 = \"P\",\"X\",IF(E33 =H30,\"X\",\"\"))","v":""}]
[null,null,"Schedule","P",null,"C","Have steps needed to roll-out to all impacted parties been incorporated, e.g. communications, planned outages, deployment plan?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D34 = \"P\",\"X\",IF(E34 =#REF!,\"X\",\"\"))","v":"X"}]
[null,null,"Schedule","P",null,"C","Will any phyciscal infrastructure improvements be required prior to the implementation of the proposed solution. e.g., building reconstruction, cabling, etc.?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Schedule","C","Y","C","Does the PIJ include the facilities costs associated with construction? ",null,null,null,null,null,null,null,null,null,""]
[null,null,"Schedule","C","Y","C","Does the project plan reflect the timeline associated with completing the construction? ",null,null,null,null,null,null,null,null,null,{"$f":"IF(D37 = \"P\",\"X\",IF(E37 =H35,\"X\",\"\"))","v":""}]
[null,null,"Dependencies","P",null,"C","Are there any known resource availability conflicts that could impact the project?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Dependencies","C","Y","C","Have the identified conflicts been taken into account in the project plan?",null,null,null,null,null,null,null,null,null,""]
[null,null,"Dependencies","P",null,"C","Does your schedule have dependencies on any other projects or procurements?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"User Impact","P",null,"C","Will the implementation involve major end user view or functionality changes?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"User Impact","P",null,"C","Will the proposed solution result in a change to a public-facing application or system?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Budget","P",null,"C","Is a detailed project budget reflecting all of the up-front/startup costs to implement the project available, e.g., hardware, initial software licenses, training, taxes, P&OS, etc.?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Budget","P",null,"C","Have the ongoing support costs for sustaining the proposed solution over a 5-year lifecycle, once the project is complete, been determined, e.g., ongoing vendor hosting costs, annual maintenance and support not acquired upfront, etc.?",null,null,null,null,null,null,{"$f":"IF(H43 = \"Y\",\"Y\",\"\")","v":""},"6,0",null,"X"]
[null,null,"Budget","P",null,"C","Have all required funding sources for the project and ongoing support costs been identified?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Budget","P",null,"C","Will the funding for this project expire on a specific date, regardless of project timelines?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Budget","C","Y","D","Provide the dates for the funding availability below:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Budget","P",null,"C","Will the funding allocated for this project include any contingency, in the event of cost over-runs or potential changes in scope?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"ES","Please indicate whether a statewide enterprise solution will be used or select the primary reason for not choosing an enterprise solution:",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Will the technology and all required services be acquired off existing State contract(s)? ",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Will any software be acquired through the current State value-added reseller contract?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","C","Y","F","Describe how the software was selected below:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Technology","P",null,"C","Does the project involve any technology that is new and/or unfamiliar to your agency, e.g., software tool never used before, virtualized server environment?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Does your agency have experience with the vendor (if known)?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Does the vendor (if known) have professional experience with similar projects?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Does the project involve any coordination across multiple vendors? ",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Does this project require multiple system interfaces, e.g., APIs, data exchange with other external application systems/agencies or other internal systems/divisions?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Have any compatibility issues been identified between the proposed solution and the existing environment, e.g., upgrade to server needed before new COTS solution can be installed?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","C","Y","F","Describe below the issues that were identified and how they have been/will be resolved, or whether an ADOA-ASET representative should contact you:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Technology","P",null,"C","Will a migration/conversion step be required, i.e., data extract, transformation and load?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Is this replacing an existing solution?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","C","Y","F","Indicate below when the solution being replaced was originally acquired?",null,null,null,null,null,null,null,null,null,""]
[null,null,"Technology","C","Y","F","Describe the planned disposition of the existing technology below, e.g., surplused, retired, used as backup, used for another purpose:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D63 = \"P\",\"X\",IF(E63 =H61,\"X\",\"\"))","v":""}]
[null,null,"Technology","P",null,"F","Describe how the agency determined the quantities reflected in the PIJ, e.g., number of hours of P&OS, disk capacity required, number of licenses, etc. for the proposed solution?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Does the proposed solution and associated costs reflect any assumptions regarding projected growth, e.g., more users over time, increases in the amount of data to be stored over 5 years?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","P",null,"C","Does the proposed solution and associated costs include failover and disaster recovery contingencies?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","C","N","DR","Please select why failover and disaster recovery is not included in the proposed solution.",null,null,null,null,null,null,null,null,null,""]
[null,null,"Technology","P",null,"C","Will the vendor need to configure the proposed solution for use by your agency?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D68 = \"P\",\"X\",IF(E68 =H67,\"X\",\"\"))","v":"X"}]
[null,null,"Technology","C","Y","C","Are the costs associated with that configuration included in the PIJ financials?",null,null,null,null,null,null,null,null,null,""]
[null,null,"Technology","P",null,"C","Will any application development or customization of the proposed solution be required for the agency to use the product in the current/planned technology environment, e.g., a COTS application that will require custom programming, an agency application that will be entirely custom developed?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","C","Y","C","Will the customizations inhibit the ability to implement regular product updates, or to move to future versions?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D71 = \"P\",\"X\",IF(E71 =H70,\"X\",\"\"))","v":""}]
[null,null,"Technology","C","Y","F","Describe who will be customizing the solution below:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D72 = \"P\",\"X\",IF(E72 =H70,\"X\",\"\"))","v":""}]
[null,null,"Technology","C","Y","C","Do the resources that will be customizing the application have experience with the technology platform being used, e.g., .NET, Java, Drupal?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D73 = \"P\",\"X\",IF(E73 =H70,\"X\",\"\"))","v":""}]
[null,null,"Technology","C","Y","PM","Please select the application development methodology that will be used:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D74 = \"P\",\"X\",IF(E74 =H70,\"X\",\"\"))","v":""}]
[null,null,"Technology","C","Y","F","Provide an estimate of the amount of customized development required, e.g., 25% for a COTS application, 100% for pure custom development,  and describe how that estimate was determined below:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D75 = \"P\",\"X\",IF(E75 =H70,\"X\",\"\"))","v":""}]
[null,null,"Technology","C","Y","C","Are any/all Professional & Outside Services costs associated with the customized development included in the PIJ financials?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D76 = \"P\",\"X\",IF(E76 =H70,\"X\",\"\"))","v":""}]
[null,null,"Technology","P",null,"C","Have you determined that this project is in compliance with all applicable statutes, regulations, policies, standards, and procedures, including those for network, security, platform, software/application, and/or data/information found at https://aset.az.gov/resources/psp?",null,null,null,null,null,null,null,null,"Y","X"]
[null,null,"Technology","C","N","F","Describe below the compliance issues that were identified and how they have been/will be resolved, or whether an ADOA-ASET representative should contact you:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Technology","P",null,"C","Are there other high risk project issues that have not been identified as part of this PIJ?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Technology","C","Y","F","Please explain all unidentified high risk project issues below:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Security","P",null,"C","Will the proposed solution be vendor-hosted?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Security","C","Y","VH","Please select from the following vendor-hosted options:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Security","C","Y","F","Describe the rationale for selecting the vendor-hosted option below:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D83 = \"P\",\"X\",IF(E83 =H81,\"X\",\"\"))","v":""}]
[null,null,"Security","C","Y","C","Has the agency been able to confirm the long-term viability of the vendor-hosted environment?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D84 = \"P\",\"X\",IF(E84 =H81,\"X\",\"\"))","v":""}]
[null,null,"Security","C","Y","C","Has the agency addressed contract termination contingencies, e.g., solution ownership, data ownership,  application portability, migration plans upon contract/support termination?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D85 = \"P\",\"X\",IF(E85 =H81,\"X\",\"\"))","v":""}]
[null,null,"Security","C","Y","C","Has a Conceptual Design / Network Diagram been provided and reviewed by ASET-SPR?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D86 = \"P\",\"X\",IF(E86 =H81,\"X\",\"\"))","v":""}]
[null,null,"Security","C","Y","C","Has the spreadsheet located at https://aset.az.gov/arizona-baseline-security-controls-excel already been completed by the vendor and approved by ASET-SPR?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D87 = \"P\",\"X\",IF(E87 =H81,\"X\",\"\"))","v":""}]
[null,null,"Security","P",null,"C","Will the proposed solution be hosted on-premise in a state agency?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Security","C","Y","IH","Where will the on-premise solution be located:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Security","C","Y","C","Were vendor-hosted options available and reviewed?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D90 = \"P\",\"X\",IF(E90 =H88,\"X\",\"\"))","v":""}]
[null,null,"Security","C","Y","F","Describe the rationale for selecting an on-premise option below:",null,null,null,null,null,null,null,null,null,{"$f":"IF(D91 = \"P\",\"X\",IF(E91 =H88,\"X\",\"\"))","v":""}]
[null,null,"Security","C","Y","C","Will any data be transmitted into or out of the agency's on-premise environment or the State Data Center?",null,null,null,null,null,null,null,null,null,{"$f":"IF(D92 = \"P\",\"X\",IF(E92 =H88,\"X\",\"\"))","v":""}]
[null,null,"Security","P",null,"C","Will any PII, PHI, or other Protected Information as defined in the 8110 Statewide Data Classification Policy be transmitted, stored, or processed with this project?  ",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Security","C","Y","F","Describe below what security infrastructure/controls are/will be put in place to safeguard this data:",null,null,null,null,null,null,null,null,null,""]
[null,null,"Question Wrap-Up","P",null,"F","What help could ASET offer to increase the probability of project success?",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Question Wrap-Up","P",null,"B","This is the end of the main PIJ questions section.  You may proceed to the following sections or review the previous answers at this time.  The next section, identifying Areas of Impact, is designed to capture structured data around the solution being proposed – you may complete this section, or ADOA-ASET will work through the checkboxes with you.  If you are not prepared to complete the PIJ Financials section at this time, you may also skip that section, however, it will need to be completed before the PIJ can be approved."]
[null,null,"End","End","End","End","End",null,null,null,null,null,"End","End","End","End",{"$f":"IF(D97 = \"P\",\"X\",IF(E97 =H96,\"X\",\"\"))","v":""}]

{"sheet":"Full PIJ","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,13,3,14],[16,10,18,17],[20,10,21,17],[22,10,22,17],[9,10,14,17],[5,12,6,15],[7,12,7,15]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"*If the proposed project will utilize APF monies or require ITAC approval please download the older PIJ form Here: "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"https://aset.az.gov/pij-information-and-documentation"]
[]
[null,null,null,null,null,null,null,null,null,null,"Proceed to the PIJ Main Menu by clicking the button above and select \"Start\" which will begin the PIJ questions. Upon completion of the Meeting Pre-work section (which is the first section of questions), feel free to answer as many questions within the PIJ as you feel comfortable, and use the button below to send the file to your dedicated ADOA-ASET Strategic Program Manager, or to the ITProjects@azdoa.gov mailbox if unsure."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"**   MS Outlook required. If you are using an alternate mail application please send a copy of the full PIJ to:"]
[]
[null,null,null,null,null,null,null,null,null,null," ITProjects@azdoa.gov"]

{"sheet":"PIJ Financials","index":5,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,13,14,14],[13,15,13,16],[14,15,14,16],[0,1,1,2],[11,0,11,9],[11,14,11,22],[12,13,12,14],[12,15,12,16],[2,7,4,8],[3,14,3,16],[4,14,4,16],[6,14,6,16],[7,14,7,16],[2,14,2,16],[2,18,2,19],[6,18,6,19],[15,13,16,14],[15,15,15,16],[16,15,16,16],[17,13,18,14],[17,15,17,16],[18,15,18,16],[19,13,20,14],[19,15,19,16],[20,15,20,16],[21,13,22,14],[21,15,21,16],[22,15,22,16],[23,13,24,14],[23,15,23,16],[24,15,24,16],[25,13,26,14],[25,15,25,16],[26,15,26,16],[36,8,36,9],[30,8,30,9],[27,13,27,14],[27,15,27,16],[31,8,31,9],[28,13,28,14],[28,15,28,16],[32,8,32,9],[29,15,29,16],[33,8,33,9],[34,8,34,9],[35,8,35,9],[57,8,57,9],[58,8,58,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[54,8,54,9],[55,8,55,9],[56,8,56,9],[48,8,48,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[7,18,7,19],[0,24,1,25],[2,24,2,25],[5,14,5,16],[3,18,3,19],[4,18,4,19],[5,18,5,19],[0,14,1,21],[2,20,2,21],[3,20,3,21],[4,20,4,21],[5,20,5,21],[6,20,6,21],[7,20,7,21]]}
[null,"Summary of PIJ Financials",null,null,null,null,null,null,null,null,null,null,null,null,"Summary of Funding Sources",null,null,null,null,null,null,null,null,null,"Total costs available to distribute between funding sources"]
[]
[null,"Total of Development Cost:",{"$f":"IF(K31=W28,W28,\"Please Verify Sheet\")","v":0},null,null,null,null,null,null,null,null,null,null,null,"Fund Type",null,null,"% of Project","$ of Project (Available)",null,"$ of Project (To Be Requested)",null,null,null,{"$f":"IF(C5 = 0,\"\",$C$5-$S$4-$U$4-$S$5-$U$5-$S$6-$U$6-$S$7-$U$7-$S$8-$U$8)","v":""}]
[null,"Total of Operational Cost:",{"$f":"IF(K32=W29,W29,\"Please Verify Sheet\")","v":0},null,null,null,null,null,null,null,null,null,null,null,"Base Budget",null,null,{"$f":"IF(S4+U4 = 0,\"\",(S4+U4)/$C$5)","v":""}]
[null,"Total  Costs:",{"$f":"IF(K33=W30,W30,\"Please Verify Sheet\")","v":0},null,null,null,null,null,null,null,null,null,null,null,"APF",null,null,{"$f":"IF(S5+U5 = 0,\"\",(S5+U5)/$C$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Appropriated",null,null,{"$f":"IF(S6+U6 = 0,\"\",(S6+U6)/$C$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal",null,null,{"$f":"IF(S7 + U7 =0,\"\",(S7+U7)/$C$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Non-Appropriated",null,null,{"$f":"IF(S8 +U8 = 0,\"\",(S8+U8)/$C$5)","v":""}]
[]
[]
[]
["Project Cost - Itemized",null,null,null,null,null,null,null,null,null,null,null,null,null,"PIJ Development & Operational Cost Summary"]
["Item","Description","Category","Development (Implementation) or Operational (Ongoing)","Fiscal Year Spend","Qty or Hours","Unit Cost","Extended Cost","Enter Tax Rate if Applicable (Generally 8.6% for PHX)","Tax","Total Cost",null,null,"Description",null,"Type",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Extended Cost"]
[1,null,"[--Select--]","[--Select--]","[--Select--]",null,null,{"$f":"IF(G14=FALSE,\"\",IF(F14=FALSE,1*G14,F14*G14))","v":""},null,{"$f":"IF(G14=FALSE,\"\",H14*I14)","v":""},{"$f":"IF(G14=FALSE,\"\",IF(E14  = \"FY2-5\",(J14+H14)*4,J14+H14))","v":""},null,null,"Professional  & Outside Services",null,"Development",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUM(R14:V14)","v":0}]
[2,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Prof & Outside Services\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUM(R15:V15)","v":0}]
[3,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,"Hardware",null,"Development",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[4,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Hardware\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[5,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,"Software",null,"Development",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[6,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Software\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[7,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,"Communications",null,"Development",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[8,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Communications\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[9,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,"Facilities",null,"Development",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[10,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Facilities\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[11,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,"Licensing & Maintenance Fees",null,"Development",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[12,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"License & Maint Fees\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[13,null,"[--Select--]","[--Select--]","[--Select--]",null,null,{"$f":"IF(G26=FALSE,\"\",IF(F26=FALSE,1*G26,F26*G26))","v":""},null,{"$f":"IF(G26=FALSE,\"\",H26*I26)","v":""},{"$f":"IF(G26=FALSE,\"\",IF(E26  = \"FY2-5\",(J26+H26)*4,J26+H26))","v":""},null,null,"Other",null,"Development",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Development\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[14,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational",null,{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,1)","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,2)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,3)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,4)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},{"$f":"SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,5)+  SUMIFS(K14:K30,C14:C30,\"Other\",D14:D30,\"Operational\",E14:E30,\"FY2-5\")*0.25","v":0},0]
[15,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Development Cost:",null,{"$f":"SUMIF($P$14:$Q$27,\"Development\",R14:R27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Development\",S14:S27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Development\",T14:T27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Development\",U14:U27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Development\",V14:V27)","v":0},{"$f":"SUMIF(P14:Q27,\"Development\",W14:W27)","v":0}]
[16,null,"[--Select--]","[--Select--]","[--Select--]",null,null,"",null,"","",null,null,null,null,"Operational Cost:",null,{"$f":"SUMIF($P$14:$Q$27,\"Operational\",R14:R27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Operational\",S14:S27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Operational\",T14:T27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Operational\",U14:U27)","v":0},{"$f":"SUMIF($P$14:$Q$27,\"Operational\",V14:V27)","v":0},{"$f":"SUMIF(P14:Q27,\"Operational\",W14:W27)","v":0}]
[17,null,"[--Select--]","[--Select--]","[--Select--]",null,null,{"$f":"IF(G30=FALSE,\"\",IF(F30=FALSE,1*G30,F30*G30))","v":""},null,{"$f":"IF(G30=FALSE,\"\",H30*I30)","v":""},{"$f":"IF(G30=FALSE,\"\",IF(E30  = \"FY2-5\",(J30+H30)*4,J30+H30))","v":""},null,null,null,null,"Total Cost:",null,null,null,null,null,null,{"$f":"SUM(W28:W29)","v":0}]
[null,null,null,null,null,null,null,null,"Total Development Cost",null,{"$f":"SUMIF(D14:D30,\"Development\",K14:K30)","v":0}]
[null,null,null,null,null,null,null,null,"Total Operational Cost",null,{"$f":"SUMIF(D14:D30,\"Operational\",K14:K30)","v":0}]
[null,null,null,null,null,null,null,null,"Total Itemization of Costs:",null,{"$f":"SUM(K31:K32)","v":0}]

{"sheet":"Areas of Impact","index":6,"n_rows":91,"n_cols":6,"rows_kept":91,"cut":false,"hidden":false,"merged":[[70,7,71,12],[81,7,82,12],[90,7,91,12],[11,7,12,12],[60,7,61,12],[1,1,3,9],[0,13,2,14],[21,7,22,12],[40,7,41,12],[50,7,51,12],[30,7,31,12]]}
[]
[null,"Areas of Impact"]
[]
[]
[null,1,"Application Systems"]
[null,null,null,null,"Application Enhancements"]
[null,null,null,null,"Internal Use Web Application"]
[null,null,null,null,"Mobile Application Development"]
[null,null,null,null,"Arizona Enterprise Solution Platform (AESP) based Application"]
[null,null,null,null,"New Application Development"]
[null,null,null,null,"az.gov Web Portal Application"]
[null,null,null,null,"Other: (Please specify below)"]
[]
[null,2,"Database Systems"]
[null,null,null,null,"Data Warehouse/Mart"]
[null,null,null,null,"Database Consolidation/Migration/Extract Transform and Load Data"]
[null,null,null,null,"Database Products and Tools:"]
[null,null,null,null,null,"Oracle"]
[null,null,null,null,null,"MySQL"]
[null,null,null,null,null,"DB2"]
[null,null,null,null,null,"MS SQL Server"]
[null,null,null,null,"Other: (Please specify below)"]
[]
[null,3,"Software"]
[null,null,null,null,"COTS Application Customization"]
[null,null,null,null,"COTS Application Acquisition"]
[null,null,null,null,"Mainframe Systems Software"]
[null,null,null,null,"Open Source"]
[null,null,null,null,"PC/LAN Systems Software"]
[null,null,null,null,"Virtualization"]
[null,null,null,null,"Other: (Please specify below)"]
[]
[null,4,"Hardware"]
[null,null,null,null,"LAN/WAN Infrastructure"]
[null,null,null,null,"Mainframe Infrastructure"]
[null,null,null,null,"Storage Area Network Devices"]
[null,null,null,null,"Public Safety Radios, Systems"]
[null,null,null,null,"PC Purchases, Peripherals"]
[null,null,null,null,"Tape Libraries/Silos"]
[null,null,null,null,"UPS Devices"]
[null,null,null,null,"Other: (Please specify below)"]
[]
[null,5,"Hosted Solution (Cloud Implementation)"]
[null,null,null,null,"State Data Center"]
[null,null,null,null,"Commercially Hosted:"]
[null,null,null,null,null,"Amazon (AWS) GovCloud"]
[null,null,null,null,null,"Century Link - I/O Data Center"]
[null,null,null,null,null,"AWS (non-government) cloud"]
[null,null,null,null,null,"Microsoft Azure"]
[null,null,null,null,"Vendor Hosted "]
[null,null,null,null,"Other: (Please explain below)"]
[]
[null,6,"Security"]
[null,null,null,null,"Encryption"]
[null,null,null,null,"Security Appliances:"]
[null,null,null,null,null,"Firewall"]
[null,null,null,null,null,"Intrusion Detection System (IDS)"]
[null,null,null,null,null,"Intrusion Prevention System (IPS)"]
[null,null,null,null,"SecurityControls/Systems - Other: (Please specify below)"]
[null,null,null,null,"Physical Controls (Badging Systems, Iris Scanners, Other: (Please specify below)"]
[null,null,null,null,"Other: (Please specify below)"]
[]
[null,7,"Telecommunications"]
[null,null,null,null,"Network Communications Infrastructure"]
[null,null,null,null,"Telephone Upgrade-Business-Specific"]
[null,null,null,null,"Cabling"]
[null,null,null,null,"Wireless Access Points"]
[null,null,null,null,"Telephony Upgrade-EIC Solution"]
[null,null,null,null,"Trenching"]
[null,null,null,null,"Videoconferencing"]
[null,null,null,null,"Other: (Please specify below)"]
[]
[null,8,"Enterprise Solutions"]
[null,null,null,null,"Business Intelligence System"]
[null,null,null,null,"E-Signatures"]
[null,null,null,null,"Geographic Information Systems"]
[null,null,null,null,"Other Imaging - Photos, Fingerprints, etc."]
[null,null,null,null,"Document Management/Imaging"]
[null,null,null,null,"eLicensing"]
[null,null,null,null,"Management Systems - Financial, Grants, Asset"]
[null,null,null,null,"Disaster Recovery/Business Continuity"]
[null,null,null,null,"Other: (Please specify below)"]
[]
[null,9,"Contract Services/Procurement"]
[null,null,null,null,"Contracted Project Management"]
[null,null,null,null,"Contractor Support Services"]
[null,null,null,null,"Install/Configuration Contract Services"]
[null,null,null,null,"State Contract"]
[null,null,null,null,"Vendor provided"]
[null,null,null,null,"Procurement (RFP, IFB, DPR, etc.)"]
[null,null,null,null,"Other: (Please specify below)"]

{"sheet":"Deliverables & Milestones","index":7,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":true,"merged":[[1,2,3,11],[5,2,6,7],[5,8,6,9],[5,10,6,11],[7,2,8,7],[7,8,8,9],[7,10,8,11],[9,2,10,7],[9,8,10,9],[9,10,10,11],[11,2,12,7],[11,8,12,9],[11,10,12,11],[13,2,14,7],[13,8,14,9],[13,10,14,11],[15,2,16,7],[15,8,16,9],[15,10,16,11],[17,2,18,7],[17,8,18,9],[17,10,18,11],[19,2,20,7],[19,8,20,9],[19,10,20,11],[21,2,22,7],[21,8,22,9],[21,10,22,11],[23,2,24,7],[23,8,24,9],[23,10,24,11],[29,2,30,7],[29,8,30,9],[29,10,30,11],[25,2,26,7],[25,8,26,9],[25,10,26,11],[27,2,28,7],[27,8,28,9],[27,10,28,11]]}
[]
[null,null,"Project Milestones/Deliverables"]
[]
[]
[]
[null,null,"Major Milestones/Deliverables",null,null,null,null,null,"Estimated Start Date",null,"Estimated Finish Date"]

{"sheet":"Invite Checklist","index":8,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,17,27,18],[13,12,13,17],[11,1,11,7],[11,8,11,11],[11,12,11,17],[14,8,14,11],[12,8,12,11],[16,1,16,7],[17,1,17,7],[13,1,13,7],[13,8,13,11],[25,1,25,7],[16,8,16,11],[16,12,16,17],[17,8,17,11],[17,12,17,17],[5,1,5,7],[5,8,5,11],[5,12,5,17],[6,8,6,11],[7,8,7,11],[6,12,6,17],[7,12,7,17],[9,1,9,7],[7,1,7,7],[8,1,8,7],[6,1,6,7],[10,8,10,11],[10,1,10,7],[18,8,18,11],[18,12,18,17],[19,8,19,11],[19,12,19,17],[18,1,18,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[23,1,23,7],[25,8,25,11],[25,12,25,17],[20,8,20,11],[20,12,20,17],[21,8,21,11],[21,12,21,17],[22,8,22,11],[22,12,22,17],[1,1,3,18],[15,1,15,18],[23,8,23,11],[23,12,23,17],[24,8,24,11],[24,12,24,17],[24,1,24,7],[14,1,14,7],[12,1,12,7],[8,12,8,17],[9,12,9,17],[10,12,10,17],[14,12,14,17],[12,12,12,17],[8,8,8,11],[9,8,9,11]]}
[]
[null,"PIJ Review Checklist"]
[]
[]
[]
[null,"Role",null,null,null,null,null,null,"Name",null,null,null,"Email Address",null,null,null,null,null,"Date Reviewed"]
[null,"Agency Project Sponsor*"]
[null,"Agency Chief Information Officer (CIO) (or designee)*"]
[null,"Agency Information Security Officer (ISO) (or designee)*"]
[]
[]
[null,"ADOA-ASET Engagement Manager *"]
[null,"ADOA-ASET Security, Privacy & Risk (ASET-SPR) representative"]
[null,"Agency CPO or State Procurement Office (SPO) representative"]
[null,"Agency CFO or Finance representative (if different from CPO)"]
[null,"Others to Review (if applicable):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Required Attendee"]

{"sheet":"Conditions List","index":9,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["PIJ Review Status","Condition","Category","As of Date"]
["PIJ Conditional","The Arizona State Library, Archives and Public Records (ASLAPR) Division of the Secretary of State’s Office is the authority governing all document imaging implementations within the State. The Agency must secure an approval or exemption from ASLAPR prior to commencement of the project.","ASLAPR"]
["PIJ Conditional","Should the final costs exceed the estimated costs by 10% or more, or should there be significant changes to the proposed technology, scope of work or implementation schedule, the Agency must amend the PIJ to reflect the changes and submit it to ADOA-ASET for review and approval prior to further expenditure of funds.","Changes - 10% cost only"]
["PIJ Conditional","Prior to the planned purchase, the Agency will work with ADOA-ASET to determine whether enterprise-level pricing or other alternative options may be available.","Enterprise Pricing","Added 4/16/15"]
["PIJ Conditional","The Agency must ensure that a viable plan exists to transition to another vendor and/or in-house platform in the event the contract with the selected vendor terminates.","Exit Strategy - hosted solution"]
["PIJ Provisional","Should the final cost of the project exceed $1 million, review and approval of the full PIJ by the Information Technology Authorization Committee (ITAC), in Executive Session if applicable, will be required before the project can proceed.","ITAC Approval Required - Pre-PIJ"]
["PIJ Conditional","The Agency shall provide an informational update to the Information Technology Authorization Committee (ITAC) regarding the status of the project on an annual basis, or as otherwise requested.","ITAC - Update"]
["PIJ Conditional","The Agency must establish a policy and mechanism to ensure that a Project Investment Justification (PIJ) is submitted for review and approval prior to any and all expenditures in the amount of $25,000 or more, on IT or telecommunications-related hardware, software, or services, in accordance with A.R.S. 41-3504 and A.R.S. 41-3521.  ","PIJ Statutes - Violations"]
["PIJ Provisional","The Agency may proceed with the assessment phase of this project, not to exceed the cost identified in the Pre-PIJ.  However, the Agency may not award a contract or proceed with further development efforts until a full PIJ reflecting the final costs, scope of work, technology, and implementation schedule for the proposed solution, has been submitted to ADOA-ASET for review and approval.","Pre-PIJ Assessment"]
["PIJ Provisional","While a Request for Proposal (RFP) can be issued for the proposed solution, the Agency may not award a contract or proceed with further development efforts until a full PIJ reflecting the final costs, scope of work, technology, and implementation schedule for the proposed solution has been submitted to ADOA-ASET for review and approval.","Pre-PIJ - RFP"]
["PIJ Conditional","As part of its final deployment plan, in order to standardize and increase interoperable communications throughout the State, the Agency must ensure that subscriber units are programmed in accordance with Arizona’s Statewide Interoperable Channel Plan – Priority Programming Guides, which are available at: www.publicsafetytools.info.","Radios"]
["PIJ Conditional","The Arizona Baseline Security Controls document must be completed in order to ensure that the selected solution will provide an appropriate level of protection for State data.","Security - Baseline Controls"]
["PIJ Conditional","The Agency will continue to work in collaboration with ADOA-ASET to help ensure that appropriate security controls are in place to protect State data.","Security - Collaboration"]
["PIJ Conditional","In order to ensure an appropriate level of security is in place, the Agency will encrypt the laptops prior to distribution.","Security - Laptops"]
["PIJ Conditional","The Request for Proposal (RFP) for the proposed solution shall only be issued upon agreement between the Agency and ADOA-ASET regarding the technology requirements, including security controls and specific deliverables, to be identified in the Statement of Work (SOW).","SOW"]
["PIJ Conditional","The Agency will consider using the State Data Center (SDC) facility to host the proposed solution.","State Data Center","Added 4/16/15"]
["PIJ Conditional","The Agency will provide regular status reporting regarding project progress and expenditures to date on a quarterly basis, unless otherwise requested by ADOA-ASET.","Status Reporting","Added 9/2/15"]

{"sheet":"Approved Vendors","index":10,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":true,"merged":[[1,1,2,10],[1,12,2,13],[1,14,2,14]]}
[]
[null,"Available Enterprise Standards & Approved Hosted/Cloud Environments",null,null,null,null,null,null,null,null,null,null,"Date Last Updated",null,"2015-12-31"]
[]
[null,null,"Standards:",null,null,null,null,"Security Approved Vendors:","Dated Approved"]
[null,null,"Core Networking","HP",null,null,null,"CA","2015-02-17"]
[null,null,"Next Generation Firewalls","Palo Alto",null,null,null,"IO","2015-03-31"]
[null,null,"Web Applications Firewall","Cloud Flare",null,null,null,"ICM","2014-05-29"]
[null,null,"Desktop Encryption","Bitlocker",null,null,null,"OSAM","2015-12-28"]
[null,null,"Multi Factor Authentication","Azure",null,null,null,"Accela","2015-12-04"]
[null,null,"Anti Virus Desktops","Forefront",null,null,null,"Hyland","2014-02-03"]
[null,null,"Anti Virus Servers","McAfee",null,null,null,"Netsmart","2015-02-09"]
[null,null,"Vulnerability Testing","Nessus",null,null,null,"Pantheon","2015-04-27"]
[null,null,"Apps Testing","Burp Suite, Acunetix",null,null,null,"GL Solutions","2015-05-01"]
[null,null,"Authentication","Active Directory",null,null,null,"Infor Talent ",42074]
[null,null,"Server Config Management","Tripwire",null,null,null,"Legatus Solutions",42052]
[null,null,"Central Log Server","Tripwire",null,null,null,"Amazon Web Service (AWS)"]
[null,null,"Spam Filter","Ironport",null,null,null,"Microsoft  Azure Government Cloud"]
[null,null,"Mainframe Security","RACF"]
[null,null,"Mainframe Access","BlueZone"]
[null,null,"Security Awareness Training","SANs"]
[null,null,"Patch Management","SCCM"]
[null,null,"Intrusion Detection","SNORT"]
[null,null,"Compliance Software","Risk Sense"]
[null,null,"Forensics Analysis","Encase"]
[null,null,"Load Balancer","Netscaler"]
[null,null,"Email","Office 365"]
[null,null,"Remote Access","VPN (Cisco), Citrix"]
[null,null,"Background Checks","DPS"]
[null,null,"               "]
[null,null,"Cloud Security Standards:"]
[null,null,"Anti Virus","Clam"]
[null,null,"Cloud Firewall","Dome 9"]
[null,null,"Cloud WAF","Cloud Flare"]
[null,null,"Intrusion Detection","SNORT"]
[null,null,"Vulnerability Testing","Nessus"]
[null,null,"Multi Factor Authentication","Azure"]
[null,null,"Patch Management","SCCM"]
[]
[null,null,"Policy’s"]
[null,null,"N.I.S.T"]
[]
[null,null,"Security Framework"]
[null,null,"N.I.S.T"]
[null,null,"FedRamp"]
[]
[null,null,"Standards in Procurement to be set:"]
[null,null,"Web Content Filtering"]
[null,null,"Data Loss Prevention"]
[]
[null,null,"New Technology Research (potential future standards):"]
[null,null,"Virtual Server Hypervisor Protection"]
[null,null,"Network Access Control"]
[null,null,"Directory Auditing Tool"]
[null,null,"Server Hardening Tool"]
[null,null,"SIEM (Security Information Event Management)"]

{"sheet":"Section Titles","index":11,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"Meeting Pre-Work"]
[null,"Pre-PIJ/Assessment"]
[null,"Process"]
[null,"Project"]
[null,"Schedule"]
[null,"Dependencies"]
[null,"User Impact"]
[null,"Budget"]
[null,"Technology"]
[null,"Security"]

{"sheet":"Popups","index":12,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,0,2,6]]}
["Popup/Disclaimers for Full PIJ"]
[]
[]
["Popup/Disclaimer Number","Popup/Disclaimer Notification"]
[1,"Please provide a copy under separate cover before the meeting."]
[2,"Be prepared to discuss in the meeting how the RFP SOW will be completed."]
[3,"While previously entered information is still available, please adjust as necessary based upon the RFP results."]
[4,"This project may qualify for the PIJ-EZ - if you would like to try the PIJ-EZ form instead, please exit through the main menu and go to the \"PIJ-EZ Assessment Form\" tab."]
[5,"Please provide a copy of the project plan under separate cover before the meeting."]
[6,"Based upon the given information, please complete the PIJ Financials section before the meeting."]

{"sheet":"Invite Checklist Help Popups","index":13,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Invite List Title","Prompt","Title"]
["Agency Project Sponsor","The Project Sponsor is required for all projects.","Project Sponsor"]
["Agency Chief Information Officer (CIO) (or designee)","The Agency CIO (or designee) is required for all projects.  If there is no designated CIO, the person fulfilling the CIO role should be invited.","Project CIO (or designee)"]
["Agency Information Security Officer (ISO) (or designee)","The Agency ISO (or designee) is required for all projects.  If there is no designated ISO, the person fulfilling the CIO role should be invited.","Project ISO (or designee)"]
["Joint Legislative Budget Committee (JLBC) representative","A representative from JLBC is required for any project that will utilize a legislative funding source.  ","JLBC Representative"]
["Office of Strategic Planning & Budgeting (OSPB) representative","A representative from OSPB is required for any project that has been or will be submitted to the Governor’s Office as part of a Budget Decision Package.  ","OSPB Representative"]
["ADOA-ASET Strategic Program Manager","The Strategic Program Manager assigned to your Agency is required for all projects. If unsure who that may be, please email Strategic_Oversight@azdoa.gov and someone will contact you regarding the project.","ASET Strategic Program Manager"]
["ADOA-ASET Security, Privacy & Risk (ASET-SPR) representative","A representative from ASET-SPR is required for any project or proposed solution that involves the following:\n\n-Specific security-related items, e.g., a firewall appliance\n\n-Migrating, transmitting, or storing any data outside of the Agency’s or the State Data Center\n\n-PII, PHI, or other Protected Information as defined in the 8110 Statewide Data Classification Policy","ASET-SPR Representative"]
["Agency CPO or State Procurement Office (SPO) representative","The Chief Procurement Officer (CPO) for the Agency is to be invited to the meeting, unless not applicable for this project, or the Agency does not have a dedicated CPO, in which case this can remain blank.","Agency CPO/SPO Representative"]
["Agency CFO or Finance representative (if different from CPO)","The Chief Financial Officer (CFO) for the Agency, or the designated representative responsible for funding and financial reporting for the Agency, is to be invited to the meeting, if different from the CPO.","Agency CFO/Finance Representative"]
["Others to Invite (if applicable):","Additional invitees that may be needed if the project or proposed solution involves the following:\n\n-Integration or collaboration with any other agency, e.g., data exchange, system setup, project dependencies\n\n-Possible impacts to the data or functionality provided/required by any system that may be used by other divisions within the Agency\n\n-Any other stakeholders or groups within or outside of the Agency that could stop the project at a later point, should there not be agreement to proceed","Additional Invitees"]

{"sheet":"Question Type Decoder","index":14,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["B","Blank (Question and forward/reverse)"]
["C","CheckBoxes"]
["F","FreeText"]
["D","Start/Finish Dates"]
["V","Cost Entry"]
["M","Major Milestones List"]
["PM","Project Methodolgy"]
["IH","In House Hosted"]
["VH","Vendor Hosted"]
["ES","Enterprise Solutions"]
["DS","Dates Determined"]
["DR","Disaster Recovery "]

{"sheet":"Tracking Data","index":15,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Agency Name",{"$f":"'Project Request Form'!C9","v":0}]
[]
["Agency Acronym",{"$f":"VLOOKUP('Tracking Data'!B3,'Agency Names and Info'!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[]
["Date of BU Request"]
[]
["Name if ASET assisted"]
[]
["Date PIJ-EZ Provided to ASET"]
[]
["Date Full-PIJ Provided to ASET"]

{"sheet":"Agency Names and Info","index":16,"n_rows":103,"n_cols":2,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["Agency Name","Agency Code"]
["[-Please Select Agency-]","XX"]
["Accountancy Board","AB"]
["Acupuncture Examiners Board","AN"]
["Administration Department","AD"]
["Agricultural Employment Relations Board","AR"]
["Agriculture Department","AH"]
["Appraisal Board","AP"]
["Arizona Exposition and State Fair","CL"]
["Arizona Health Care Cost Containment System","HC"]
["Arizona State Retirement System","RT"]
["Arts Commission","HU"]
["Attorney General's Office","AG"]
["Auto Theft Authority","AT"]
["Barbers Board","BB"]
["Behavioral Health Examiners","BH"]
["Biomedical Research Commission","DI"]
["Charter Schools Board","CS"]
["Child Safety Department","CH"]
["Chiropractic Examiners Board","CE"]
["Citizens Clean Elections Commission","EC"]
["Commerce Authority","EP"]
["Corporation Commission","CC"]
["Corrections Department","DC"]
["Cosmetology Board","CB"]
["Criminal Justice Commission","JC"]
["Deaf and the Hard of Hearing Commission ","DF"]
["Dental Examiners Board","DX"]
["Dispensing Opticians Board","DO"]
["Economic Security Department","DE"]
["Education Department","ED"]
["Emergency and Military Affairs Department","MA"]
["Enviromental Quality Department","EV"]
["Equalization Board ","EQ"]
["Executive Clemency Board","PP"]
["Financial Institutions Department","BD"]
["Fire, Building and Life Safety Department","MM"]
["First Things First","CD"]
["Funeral Directors and Embalmers Board","FD"]
["Game and Fish Department","GF"]
["Gaming Department","GM"]
["Geological Survey","GS"]
["Governor's Office of Highway Safety","GH"]
["Health Services Department","HS"]
["Historical Society","HI"]
["Homeland Security Department","HL"]
["Homeopathic/Integrated Medical Examiners Board","HE"]
["Housing Department","HD"]
["Indian Affairs Commission","IA"]
["Industrial Commission","IC"]
["Insurance Department","ID"]
["Juvenile Corrections Department","DJ"]
["Land Department","LD"]
["Law Enforcement Merit System Council","LW"]
["Legislative Council","LC"]
["Liquor Licenses & Control Department","LL"]
["Lottery","LO"]
["Massage Therapy Board","MT"]
["Medical Board","ME"]
["Mine Inspector's Office","MI"]
["Naturopathic Physicians Medical Board","NB"]
["Navigable Stream Adjudication Commission","NS"]
["Nursing Board","BN"]
["Nursing Care Institution Administrators","NC"]
["Occupational Therapy Examiners Board","OT"]
["Office of Administrative Hearings","HG"]
["Office of the Governor","GV"]
["Optometry Board","OB"]
["Osteopathic Examiners Board","OS"]
["Personnel Board","PB"]
["Pharmacy Board","PM"]
["Physical Therapy Examiners Board","PT"]
["Pioneers' Home","PI"]
["Podiatry Examiners Board","PO"]
["Postsecondary Education Commission","PE"]
["Power Authority","PA"]
["Prescott Historical Society","PH"]
["Private Postsecondary Education","PV"]
["Psychologist Examiners Board","SY"]
["Public Safety Department","PS"]
["Radiation Regulatory Agency","AE"]
["Real Estate Department","RE"]
["Regents Board","BR"]
["Registrar of Contractors","RG"]
["Residential Utility Consumers Office","UO"]
["Respiratory Care Examiners Board","RB"]
["Revenue Department","RV"]
["School Facilities Board","SF"]
["School for the Deaf and Blind","SD"]
["Secretary of State","ST"]
["State Forestry Division","FO"]
["State Parks","PR"]
["Tax Appeals Board","TX"]
["Technical Registration Board","TE"]
["Tourism Office","TO"]
["Transportation Department","DT"]
["Treasurer's Office","TR"]
["Uniform State Laws Commission","UL"]
["Veterans' Services","VS"]
["Veterinary Medical Examiners Board","VT"]
["Water Infrastructure Finance Authority ","WF"]
["Water Resources Department","WC"]
["Weights and Measures Department ","WM"]

{"sheet":"For ADOA-ASET Use Only","index":17,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,15,44,18],[45,3,45,12],[47,3,47,12],[48,3,48,12],[49,3,49,12],[42,3,42,5],[43,3,44,12],[46,3,46,12],[1,1,2,12],[4,3,4,12],[5,3,5,12],[6,3,6,12],[7,3,7,12],[21,3,21,12],[8,3,8,12],[20,3,20,12],[9,3,9,12],[10,3,10,12],[11,3,11,12],[12,3,12,12],[13,3,13,12],[34,3,34,12],[35,3,35,12],[36,3,40,12],[41,3,41,5],[41,6,41,8],[41,9,41,10],[41,11,41,12],[33,3,33,12],[1,17,3,20],[22,3,26,12],[28,3,28,12],[30,3,31,12],[32,3,32,12],[14,3,14,12],[15,3,15,12],[16,3,16,12],[17,3,17,12],[18,3,18,12],[19,3,19,12]]}
[]
[null,"Official ADOA-ASET Use Only"]
[]
[]
[null,null,null,"Has the value of the IT project to the public and the State been identified?"]
[null,null,null,"Does the proposed solution address the stated problem or situation?"]
[null,null,null,"Has the budget unit demonstrated competency to carry out the project successfully?"]
[null,null,null,"Have all applicable questions in the PIJ been addressed?"]
[null,null,null,"Have the Areas of Impact associated with the project been identified?"]
[null,null,null,"Is sufficient sponsorship and support by budget unit leadership evidenced in the meeting?"]
[null,null,null,"Has the compatibility of the proposed solution with other budget unit solutions been addressed?"]
[null,null,null,"Has a reasonable Project Plan been provided?"]
[null,null,null,"Has the compliance of the proposed solution with all applicable statewide standards been confirmed?"]
[null,null,null,"Have any potential risks or issues associated with the project or the proposed solution been identified and appropriately addressed to minimize unintended consequences?"]
[null,null,null,"Have the cost estimates for the project been vetted for accuracy?"]
[null,null,null,"Have the PIJ Financials been completed?"]
[null,null,null,"Have any/all of the following startup costs to implement the project been included under Development in the financial tables, if applicable  - tax; shipping; upfront maintenance and support; professional services (P&OS); ancillary software to run on equipment; ancillary hardware to install equipment, e.g., cables; other associated costs, e.g., training, travel, documentation, etc.?"]
[null,null,null,"Have any/all of the following ongoing/5-year support costs, once the project is implemented, been included under Operational in the financial tables, if applicable - ongoing vendor hosting costs, including any projected increase over time; annual maintenance and support not acquired upfront; extended costs after warranty expiration; P&OS commitments beyond implementation? "]
[null,null,null,"Have you confirmed that no Full Time Employee (FTE) related costs have been included in the project costs?"]
[null,null,null,"Have quotes been provided for all itemized costs in the PIJ, e.g., professional services, hardware, software, licensing, etc.?"]
[null,null,null,"Do the quotes match the itemized list and only reflect those items and costs (within 5%) associated with this project?"]
[null,null,null,"If not, describe below how the costs in the PIJ differ from the quotes, e.g., if quantities are different, costs are comprised of portions of multiple quotes provided, etc.:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"If any of the above are not complete, the PIJ cannot be approved at this time….."]
[]
[null,null,null,"PIJ Disposition"]
[]
[null,null,null,"Approved"]
[null,null,null,"Approved with conditions"]
[null,null,null,"Not Approved"]
[null,null,null,"Strategic Program Manager Analysis"]
[]
[]
[]
[]
[]
[null,null,null,"Authorized Approver:",null,null,null,null,null,"Approval Date:"]
[]
[null,null,null,"Condition (If Applicable)"]

{"sheet":"Version Notes","index":18,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Version","Notes"]
[1]
["●","Initial Launch"]
[]
[1.1000000000000001]
["●","Locked Financials Tab for areas which are auto calculated"]
["●","Locked Full PIJ Tab areas that should not be changed"]
["●","Changed the Final email from an auto send to a display box to allow for editing and additional emails to be added"]
["●","Fixed issue when accessing the \"View PIJ Sections\" button that the PIJ Sections starts half scrolled"]
["●","Workaround in place for issue where accessing PIJ Financials from the PIJ Sections Menu requiring user to click off financials tab then back in order to ender data correctly"]
["●","Removed excessive spacing on Printable PIJ output to save space"]
["●","Added a direct link to the old PIJ form for APF/ITAC Projects"]
[]
[1.2]
["●","Improved code"]
["●","Fixed issue where the \"Invite Checklist\" was not visible if the Full PIJ was launched from the popup instead of the button"]
["●","Removed erroneous comment on Project request regarding 400 character limit since the limit has been removed"]
["●","Adjusted \"Other\" areas of impact section to provide more room for manual input"]
["●","Updated Invite Checklist to more clearly state required attendees for the meeting"]
["●","Updated full PIJ email to send to Strategic_Oversight@azdoa.gov"]
["●","Improved conditional formatting on financials"]
["●","Comments that were added for any \"yes/No\" Questions are now shown on the Printable PIJ Version (outside of the print area)"]
["●","Fixed bug where comments were not properly being saved"]
["●","If A Comment has been added to a question, when the question is shown, the comment is automatically expanded and shows the comment"]
["●","Removed the \"Range\" Option for estimated costs in the Pre PIJ due to incompatibility with multiple numbers. Range can be placed in the PIJ Financials Sheet"]
["●","Added message box after Printable PIJ button is selected to notify user that it has been created and how to view "]
["●","Created Zoom in and Zoom out capabilities for the forms to allow for easier viewing from projectors"]
["●","Updated error check button"]
["●","Updated amount of lines created based upon how much was written on Printable PIJ Version tab"]
[]
[1.3]
[null,"Updated the PhX Tax number in the \"PIJ Financials\" tab due to the calendar year 2016 tax increase from 8.3% to 8.6%"]
[null,"Fixed Bug that crashed the project if \"other\" was selected for Program Methodology"]
[null,"Fixed Bug where the Milestones and Deliverables sheet doesn't unhide when \"N\" is selected for project plan"]
[null,"Corrected an issue that may not allow all questions to transferred to the \"Printable PIJ Version\" tab"]
[1.43]
[null,"Added tab titled \"Printable PIJ Version\" to fix error related to it's function"]
[1.44]
[null,"Formatted tab titled \"Printable PIJ Version\" for to replicate original"]
[null,"There's no clear sign as to why the \"Printable PIJ Version\" was no longer present or generated by a function"]

{"sheet":"Printable PIJ Version","index":19,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,6,18,10],[18,11,18,12],[19,7,19,9],[21,6,21,12],[17,6,17,10],[17,11,17,12],[20,6,20,12],[2,6,3,12],[6,6,6,12],[7,7,7,9],[9,6,9,12],[12,6,12,12],[11,6,11,12],[14,6,14,12],[13,7,13,9],[15,6,15,12],[16,7,16,9],[5,6,5,12],[8,6,8,12]]}
[]
[]
[null,null,null,null,null,null,"[- Please Enter the Project Title Here -]"]
[]
[]
[null,null,null,null,null,null,"Agency Requesting The Project:"]
[]
[]
[null,null,null,null,null,null,"Business Unit Requesting The Project:"]
[]
[]
[null,null,null,null,null,null,"Sponsor Of the Project:"]
[]
[]
[null,null,null,null,null,null,"Sponsor Title:"]
[]
[]
[null,null,null,null,null,null,"Sponsor Phone Number:",null,null,null,null,"Extension:"]
[]
[]
[null,null,null,null,null,null,"Sponsor Email Address:"]