Yeah, I'll attach the Excel sheet. The biggest reason for the spreadsheet is I wanted my YTD rain to increment every day. I used to have it do it just on the first of the month, add the whole month. But being an anal retentive person, I wanted to compare my actual YTD rain compared to normal. So using the data from the NWS NOW data section, I added in what is typical rain for each day of the year. I then added it all up to get my normal monthly rain. Then normal yearly rain.
The other fields for normal high/low and record high/low are regular text fields I can maintain. Lastly, I had some Excel macro help in exporting those out into files with the month/day in them. Since I left total for the month as just 12 monthly files, I had one file for each of the 5 stats, for each day of the year.
So then here is the code I added to my ajaxdashboard file. Down in the empty area of line 982.
<table width="630" border="0" cellpadding="0" cellspacing="0" style = "font-weight: normal";>
<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>
<tr style="text-align:center">
<td>Normal High: <?php $mydate = date('md'); $filename = "./history/".$mydate."nh.txt"; include($filename);?>°</td>
<td>Normal Low: <?php $mydate = date('md'); $filename = "./history/".$mydate."nl.txt"; include($filename);?>°</td>
</tr>
<tr style="text-align:center">
<td>Record High: <?php $mydate = date('md'); $filename = "./history/".$mydate."rh.txt"; include($filename);?></td>
<td>Record Low: <?php $mydate = date('md'); $filename = "./history/".$mydate."rl.txt"; include($filename);?></td>
</tr>
</table>
So basically all the files are in my /history folder. The files are generated by 5 Excel macros. But this way I can update the spreadsheet. Run the macro. Files relative to the Excel file are created. Upload the updated files.
Oh, and the first two columns in the Excel sheet decide what the beginning of the files are named. Followed by nh for Normal high, nl for Normal low, rh for Record high, rl for Record low, and YTD for YTD rainfall. The other 12 files are normal rain for the month, rain01mo.txt, etc..