The forum doesn't allow Excel files to be posted. You just need to remove the .txt extension so it's a .xlsm file.
Your almanac has pretty much what I have. My main 2 goals with the rain data, was to see what's normal rain for the month. And see what normal rain is year to date. I didn't want to use my rain data as it's been spread from VWS, Cumulus, and WD. I decided to make it an "official" comparison to the National Weather Service.
But in my Excel file, if all you want to do is rain, then column D is all you'd enter. If you go to your local weather city on NWS, look for the NOW Data section. Pick your city. Change the dot to "Daily/monthly normals". Change options to daily. Change Variable to Precipitation. that'll return a graph and table. I basically copy each month column into my spreadsheet. For February 29th, I manually added 0.00. Once the year is filled out, it calculates normal month rain and a daily YTD rain total.
The macro RainMonth makes 12 txt files for normal rain for month. The YTD_Files macro makes 366 for each YTD rain.
Then make a history folder on your website. Deposit the TXT files in that folder. This extra TR reads today's date and/or month and pulls the prints the TXT files on the page.
<th style="text-align:center" colspan="2">National Weather Service History</th>
<tr style="text-align:center">
<td>Normal Rain Month: <?php $mydate = date('m'); $filename = "./history/rain".$mydate."mo.txt"; include($filename);?> in.</td>
<td>Normal Rain YTD: <?php $mydate = date('md'); $filename = "./history/".$mydate."ytd.txt"; include($filename);?> in.</td>
</tr>
The rest of the Excel I had developed before the NOAAREC.php file was developed. I started on my own solution, but the new PHP worked better as I didn't have to do upkeep for new records for the year.