Home

Daily Weather Almanac calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-837098%22%20slang%3D%22en-US%22%3EDaily%20Weather%20Almanac%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837098%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20some%20help.%20I%20have%20a%20set%20of%20records%20of%20daily%20weather%20records%20for%20every%20day%20since%201983.%20See%20below%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EYear%3C%2FTD%3E%3CTD%3EMonth%3C%2FTD%3E%3CTD%3EDay%3C%2FTD%3E%3CTD%3EHigh%26nbsp%3B%3C%2FTD%3E%3CTD%3ELow%26nbsp%3B%3C%2FTD%3E%3CTD%3ERain%3C%2FTD%3E%3CTD%3ESnow%3C%2FTD%3E%3CTD%3ECover%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E37.0%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E43.0%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E42.0%3C%2FTD%3E%3CTD%3E32%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E39.0%3C%2FTD%3E%3CTD%3E17%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E35.0%3C%2FTD%3E%3CTD%3E17%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E39.0%3C%2FTD%3E%3CTD%3E30%3C%2FTD%3E%3CTD%3E0.18%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E42.0%3C%2FTD%3E%3CTD%3E28%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E50.0%3C%2FTD%3E%3CTD%3E33%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E43.0%3C%2FTD%3E%3CTD%3E27%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E35.0%3C%2FTD%3E%3CTD%3E29%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3E50.0%3C%2FTD%3E%3CTD%3E34%3C%2FTD%3E%3CTD%3E0.17%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3E46.0%3C%2FTD%3E%3CTD%3E28%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E13%3C%2FTD%3E%3CTD%3E38.0%3C%2FTD%3E%3CTD%3E19%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E14%3C%2FTD%3E%3CTD%3E32.0%3C%2FTD%3E%3CTD%3E19%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E36.0%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3E0.50%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3E35.0%3C%2FTD%3E%3CTD%3E28%3C%2FTD%3E%3CTD%3E0.06%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E17%3C%2FTD%3E%3CTD%3E30.0%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E18%3C%2FTD%3E%3CTD%3E28.0%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E19%3C%2FTD%3E%3CTD%3E24.0%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1983%3C%2FTD%3E%3CTD%3EJanuary%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E22.0%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E0.00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20put%20this%20data%20into%20pivot%20tables%20and%20have%20been%20able%20to%20come%20up%20with%20daily%20records%20(Highs%2FLows%2FAverages%20etc.)%20But%20would%20like%20to%20find%20a%20way%20to%20automate%20a%20system%20to%20capture%20all%20of%20the%20data%20points%20I%20need%20and%20automatically%20populate%20a%20dashboard%20(see%20below).%20I%20am%20not%20sure%20this%20is%20possible%20but%20any%20advice%20or%20help%20pointing%20me%20toward%20a%20helpful%20resource%20would%20be%20most%20appreciated.%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDaily%20Weather%20Almanac%20for%20Western%20Chester%20County%2C%20PA%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWednesday%2C%20September%204%2C%202019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDaily%20Data%3C%2FTD%3E%3CTD%3EObserved%3C%2FTD%3E%3CTD%3ENormal%3C%2FTD%3E%3CTD%3ERecord%20Highest%3C%2FTD%3E%3CTD%3ERecord%20Lowest%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMax%20Temperature%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E76.9%3C%2FTD%3E%3CTD%3E90%20in%201985%3C%2FTD%3E%3CTD%3E67%20in%201984%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMin%20Temperature%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E58.1%3C%2FTD%3E%3CTD%3E66%20in%201996%3C%2FTD%3E%3CTD%3E44%20in%201987%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAvg%20Temperature%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E67.5%3C%2FTD%3E%3CTD%3E77.5%20in%201985%3C%2FTD%3E%3CTD%3E58.0%20in%201997%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EPrecipitation%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E0.05%3C%2FTD%3E%3CTD%3E1.60%20in%201988%3C%2FTD%3E%3CTD%3E0.00%20in%202007%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESnowfall%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0.0%20in%202018%3C%2FTD%3E%3CTD%3E0.0%20in%202018%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESnow%20Depth%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E0%20in%202018%3C%2FTD%3E%3CTD%3E0%20in%202018%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMonth-to-Date%20Summary%3C%2FTD%3E%3CTD%3EObserved%3C%2FTD%3E%3CTD%3ENormal%3C%2FTD%3E%3CTD%3ERecord%20Highest%3C%2FTD%3E%3CTD%3ERecord%20Lowest%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAvg%20Max%20Temperature%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E80.3%3C%2FTD%3E%3CTD%3E86.3%20in%201993%3C%2FTD%3E%3CTD%3E71.8%20in%202006%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAvg%20Min%20Temperature%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E58.7%3C%2FTD%3E%3CTD%3E69.0%20in%202000%3C%2FTD%3E%3CTD%3E47.0%20in%201987%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20Precipitation%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E0.54%3C%2FTD%3E%3CTD%3E2.37%20in%202006%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20Snowfall%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0.0%20in%202018%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMax%20Snow%20Depth%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E0%20in%202007%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20HDD%20(base%2065)%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E14%20in%201987%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20CDD%20(base%2065)%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E21%3C%2FTD%3E%3CTD%3E50%20in%202000%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EYear-to-Date%20Summary%3C%2FTD%3E%3CTD%3EObserved%3C%2FTD%3E%3CTD%3ENormal%3C%2FTD%3E%3CTD%3ERecord%20Highest%3C%2FTD%3E%3CTD%3ERecord%20Lowest%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20Precipitation%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E33.48%3C%2FTD%3E%3CTD%3E46.43%20in%201996%3C%2FTD%3E%3CTD%3E23.55%20in%202002%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20Snowfall%20(since%20July%201)%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMax%20Snow%20Depth%20(since%20July%201)%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20HDD%20(since%20July%201)%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E58%20in%201986%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETotal%20CDD%20(since%20Jan%201)%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3E749%3C%2FTD%3E%3CTD%3E989%20in%202002%3C%2FTD%3E%3CTD%3E476%20in%201992%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-837098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
chescopawxman
Occasional Visitor

Hello all,

I am looking for some help. I have a set of records of daily weather records for every day since 1983. See below

YearMonthDayHigh Low RainSnowCover
1983January137.0240.0000
1983January243.0260.0000
1983January342.0320.0000
1983January439.0170.0000
1983January535.0170.0000
1983January639.0300.1800
1983January742.0280.0000
1983January850.0330.0000
1983January943.0270.0000
1983January1035.0290.0000
1983January1150.0340.1700
1983January1246.0280.0000
1983January1338.0190.0000
1983January1432.0190.0000
1983January1536.0260.5055
1983January1635.0280.0626
1983January1730.0120.0005
1983January1828.0110.0005
1983January1924.090.0005
1983January2022.050.0004

 

I have put this data into pivot tables and have been able to come up with daily records (Highs/Lows/Averages etc.) But would like to find a way to automate a system to capture all of the data points I need and automatically populate a dashboard (see below). I am not sure this is possible but any advice or help pointing me toward a helpful resource would be most appreciated.

Daily Weather Almanac for Western Chester County, PA
Wednesday, September 4, 2019
Daily DataObservedNormalRecord HighestRecord Lowest
Max TemperatureM76.990 in 198567 in 1984
Min TemperatureM58.166 in 199644 in 1987
Avg TemperatureM67.577.5 in 198558.0 in 1997
PrecipitationM0.051.60 in 19880.00 in 2007
SnowfallM00.0 in 20180.0 in 2018
Snow DepthM-0 in 20180 in 2018
Month-to-Date SummaryObservedNormalRecord HighestRecord Lowest
Avg Max TemperatureM80.386.3 in 199371.8 in 2006
Avg Min TemperatureM58.769.0 in 200047.0 in 1987
Total PrecipitationM0.542.37 in 2006 
Total SnowfallM00.0 in 2018 
Max Snow DepthM-0 in 2007 
Total HDD (base 65)M414 in 1987 
Total CDD (base 65)M2150 in 2000 
Year-to-Date SummaryObservedNormalRecord HighestRecord Lowest
Total PrecipitationM33.4846.43 in 199623.55 in 2002
Total Snowfall (since July 1)M0  
Max Snow Depth (since July 1)M-  
Total HDD (since July 1)M658 in 1986 
Total CDD (since Jan 1)M749989 in 2002476 in 1992

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies