Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

For output units:

  • US: F, mph, in
  • Metric: C, kph, cm
  • Mixed: C, mph, in

Current weather data live provided by KNYBROOK54 and forecast weather provided by DarkSky

Run with a user form and parameters
autoRuntrue
requestPrefixpq_
replaceunits:uk2:Output Units:select:1:us:US:si:Metric:uk2:Mixed
titleRunUpdate Weather Data


DarkSkyWeatherunits=uk2true

HTML
<script src='https://darksky.net/map-embed/@radar,40.774,-73.922,10.js?embed=true&timeControl=true&fieldControl=true&defaultField=radar'></script>





Run without a user form
dateFormatMMMM d Y
requestPrefixpq_
replaceinYear:$current_time:Year,inMonth::Month,inDay::Day
keepRequestIdsinYear
^(?!\s*$).+:$inYear,^(?!\s*$).+:$inMonth,^(?!\s*$).+:$inDayINLINEfalse

Day Weather Conditions for $inMonth $inDay $inYear

Outside temperature

PocketQuery
nameoutsideTemperatureFromArchive
includereloadbuttontrue
parametersinYear=&inMonth=&inDay=&outTempUnits=
allowgetparamstrue

Wind data

PocketQuery
namewindData
includereloadbuttontrue
parametersinYear=&inMonth=&inDay=&outWindUnits=
allowgetparamstrue

Outside temperature stats 

PocketQuery
nameoutsideTemperatureTable
includereloadbuttontrue
parametersinYear=&inMonth=&inDay=&outTempUnits=
allowgetparamstrue

Barometer

PocketQuery
namebarometerTrend3h
parameterspws_name=

Min/Max temperature for day

PocketQuery
nameminMaxAvgTemp
includereloadbuttontrue
parametersinYear=&inMonth=&inDay=&outTempUnits=
allowgetparamstrue

Min/Max heat index temperature for day

PocketQuery
nameminMaxAvgHeatIndex
includereloadbuttontrue
parametersinYear=&inMonth=&inDay=&outTempUnits=
allowgetparamstrue

Min/Max windchill for day

PocketQuery
nameminMaxAvgWindChill
parametersinYear=&inMonth=&inDay=&outTempUnits=
allowgetparamstrue


Rain Statistics

Total rain for day

PocketQuery
namegetSumOfRainForDay
includereloadbuttontrue
parametersinYear=&inMonth=&inDay=&outUnits=
allowgetparamstrue


Rain throughout the day

Pivot Table
showrawdatatrue
hidePanetrue
decimalseparatorPoint (.)
aggregationrain
id1553890653864_-342461285
sortfalse
typeSum
version2
vvpatternv

PocketQuery
namegetRainForDay
includereloadbuttontrue
parametersinYear=&inMonth=&inDay=&outUnits=
allowgetparamstrue