Step-by-Step Guide for Preparing the Input File for the FDRS Web App

This guide outlines the procedures for pre-processing raw data and transforming it into the required format for the
FDRS web app. The process consists of two main parts:

1. Data Acquisition and Checking

2. Processing Data Using the FDRS Model Spreadsheet

Part 1: Data Acquisition and Checking

This part ensures that the input data is complete, properly formatted, and ready for model ingestion.

Checking for Completeness and Clean Up of Data

1. Open the dataset in a excel spreadsheet application (For this example, we will be using the data set from
Region 2).

2. Identify the required data columns and rearranged to the following order:

1. Date
2. Cumulative Precipitation
3. Maximum Temperature
4. Relative Humidity
5. Wind Speed

3. Check for Completeness of data:

o If a row contains a date but lacks all corresponding data (Cumulative Precipitation; Maximum
Temperature; Relative Humidity; and Wind Speed). Delete the entire row.
o If the dataset has missing days, note that the model will handle gaps automatically.
 o For rows with incomplete information e.g. no cumulative precipitation and relative
humidity; you can input 0 or leave it blank.
4. Check and convert units where necessary. Ensure all other units are consistent with the required format.

1. Date – (Month/Day/Year e.g. 1/21/2022)

2. Cumulative Precipitation (P,mm)
3. Maximum Temperature (Celsius)
4. Relative Humidity (RH,%)
5. Wind Speed (mps)

5. Save the File.

6. Now the data is ready for copying and paste it into the next spreadsheet used for FDRS processing.

Part 2: Processing Data Using the FDRS Model Spreadsheet

1. Open the FDRS model spreadsheet (version 1.52).

The FDRS model spreadsheet (version 1.52) has three spreadsheets within the workbook First one is the Weather
Data input, second is the Output table, and third is the Index Summary.
Image. Weather Data Input
Image. Output Table
 Image. Index Summary

Processing Data in the FDRS Model Spreadsheet

This step involves four key sub-steps:

1. Adding the cleaned raw weather data.

2. Managing inter-year model values using the following tables:
 3. Selecting the appropriate municipality and fire model for export.
4. Reviewing the values generated by the model.

Each sub-step ensures the data is properly processed before final export.

Step 1: Add Cleaned Raw Weather Data

1. Copy and paste (as values) the cleaned weather data from the source file (Region 2 Data in our example) to
the Weather Data Input of FDRS model spreadsheet (version 1.52). Exclude the headers from the
selection.

o Ensure that the parameters are arranged in the correct order before pasting.
o Verify that the pasted values align with the corresponding columns in the model spreadsheet.
Step 2: Manage Inter-Year Model Values

1. The Weather Data Input excel has the following interfaces:

o The weather data rows – this is where you will put the cleaned weather data
o The blue section – this contain data for Fine Moisture Content After, Rain Duff Moisture Index, and
Drought Index. This table automatically provide data upon inputting the weather data in its interface.
o The green section – This is the value of the previous year. What happens here is that the model actually
takes into consideration the value of the previous year in computing the index values for the current year.
This data is manually inputted based on last year. So if we’re processing data for the year 2023, we
need to put the value for 2022.
 Back to our example

2. Upon pasting the cleaned weather data from the source file (Region 2 Data in our example) to the Weather
Data Input of FDRS model spreadsheet (version 1.52); the blue section will be updated. This data is for the
year 2022.

3. The green section already has the value for last year; please note once again, that if you’re calculating
for the following year (2023). Please do note the value of the last year and update it in the green
section.

Step 3: Select Municipality and Fire Index for Export

1. The Output Table excel has the following interfaces:

o Select Province
o Select Index
o Export to CSV
o Output Table (Munic ID and Years)
2. Once, you input the weather data in the Weather Data Input of FDRS model spreadsheet (version 1.52), the
Output table will automatically update. If you put 2022 date; the columns will be in 2022.
3. For the next step, we need to select the province where we need to produce the CSV. Using our example,
Region 2, let’s select Cagayan Province.
4. Once you select the province (in our example, Cagayan Province), the spreadsheet automatically finds the
corresponding municipal ID. So this municipal ID also corresponds to the ID used by the web app.

5. After this, we will now select which index we are interested in producing. Once Selected, the output table
will automatically populated with data of the selected index
6. Next, we are ready to export this to CSV. Export to CSV by selecting all the data (Control + A).

7. Click Export to CSV Tab

8. Click OK on the input window (This window shows the range of cells we selected).

9. Save the File by Typing the File name and desired folder location
10. The files are now ready for importing into the FDRS web app.
Step 4: Review and Finalize Data for Web App Import

1. The fourth step is just an appreciation of the values completed for each index. Review the
computed values for each fire index by clicking on the results section.
Overall Note:

The process is now more efficient, as manual copying and pasting have been automated. However, the
folders and spreadsheets are still accessible, containing all necessary computations. This spreadsheet
manages the transposition and transformation of data into the format required by the web app, converting
individual daily records into summarized weekly values.

Images. Calculations of the Index based on the FDRS Model