Using a CSV to Import Quantitative Wildfire Risk Assessment (QWRA) Inputs

When conducting a Quantitative Wildfire Risk Assessment (QWRA), you may download a spreadsheet (.csv file) form IFTDSS, fill it out, and upload it to populate the Response Function (RF) and Relative Importance (RI) input values. This can be useful when you have several Primary HVRA and sub-HVRAs to populate or want to copy/paste values. Instructions for this are outlined below.

Download and Populate the Spreadsheet

1. When on the QWRA model input page, select your Exposure Analysis (EA) output from the drop-down menu.

   

2. Select Download/Upload RI/RF Spreadsheet, located in the bottom of the Select an Exposure Analysis panel.

   

3. The spreadhseet name is pre-populated with that of your EA, but you may rename it if needed. Click Download RF/RI Template to download a template to your local computer. This template comes pre-populated with the Primary HVRA and sub-HVRA names used in your EA.

   

4. Open the spreadsheet on your local computer and populate the RF and RI values for each row.

   Tip: If you used HVRA National data in your EA, the RFs for those are also pre-populated in the spreadsheet. You may edit any of these values.

   Important! Columns D and G-M need to be populated.

   Do Not edit or delete other columns, this will cause the upload back to IFTDSS to fail.

   As you fill in the spreadsheet, note that:

   • You may find it helpful to expand the columns to view the full header titles (Excel instructions are linked here ).
   • The most important Primary HVRA should be assigned an RI of 100, the rest assigned a value between 1-100. At least one primary needs to be assigned 100

   • The “Primary RI” column only requires the first row of each Sub-HVRA to be populated. For example in the image below, the Primary RI of “10” entered in the first row for the Air Quality Sub-HVRA applies to all the Air Quality Sub-HVRAs.

     

   • Every Primary HVRA should include at least one sub-HVRA with a value of 100.

   • Response functions must be a value ranging from –100 (strong loss) to 100 (strong benefit).

     

5. Save the spreadsheet when finished and close. Uploaded values can be blank. You will have the opportunity to edit uploaded values before saving a final version.

Upload the spreadsheet

Prior to uploading the spreadsheet, make sure the following criteria are met to ensure a successful upload:

• No columns were deleted, and no columns were edited except for columns D and G-M.
• All values are whole numbers, no decimals or characters are used.
• No Identification names from the original template were changed.
• The file remains in CSV format (not .xls or .xlsx).

To upload the CSV to IFTDSS:

1. On the QWRA model input page, select your Exposure Analysis (EA) Output from the drop-down menu.

2. Select Download/Upload RI/RF Spreadsheet, located below the Select an Exposure Analysis panel.

   

3. Click the Upload Populated RF/RI Spreadsheet option.

   

4. Click Upload in the box that opens in order to select your spreadsheet file. When you see a green confirmation box stating the spreadsheet successfully uploaded, click Close.

   Important! If you see a red error message, refer to the red call about box above (we’ll put a link in the Help) to ensure all upload requirements have been met.

   

5. Your RI/RF values are now populated in IFTDSS. You may still adjust these values in the IFTDSS interface if needed, but those changes are not saved to your .csv. You may now finish the QWRA run as you would normally, giving the run a name and either selecting Run, or Save to return and run later.