I just thought I would put an update to this thread I created in case anyone was ever wanting to do something similar.
Awhile ago, I had figured how how to use PHP to get today's month number in a 2 digit format. I then would "open" the contents of that file and print to the screen it's contents. What I did was had the screen report normal rain for the month, and normal rain YTD. Just on a personal level, I always like to know where I stand for rain for those 2 periods.
I also used to have the WU script for the almanac that reported back Record/Normal High/Low. With the demise of that service, I started a trail of looking for a solution I can control a bit.
Using the local NWS data, I created a spreadsheet that had all the data. I basically used the daily normal average rainfalls to tabulate the normal rain for month, and the YTD rain. Then the Record/Normal High/Low as well.
Since I couldn't get my above PHP to open the CSV in question, AND post it in a meaningful format, I reverted back to using my previous PHP code to open 6 files that I create. With the help of some Excel VBA experts, they created me 5 macro's to create 5 files for each day of the year. The last file for each month, I manually create.
So now I have it such that I can update my spreadsheet, export out to 1830 TXT files, and upload those, and have my data updated. About the only downside is having to dig through the NWS data for Bismarck to update the record High/Low data if that should change.
If anyone is interested, I'd be willing to give anyone my Excel file and help with getting to work on their site. If you go to
https://www.bismarckweather.net and look above the forecast, you'll see the 6 fields I'm updating. The bonus for me is now my YTD rain increases each day and I can compare it to my actual YTD rain. Before, I had the YTD amount only jump on the 1st of the month.