Jason's Weather Modeler Dark Sky
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNO
1
API Key
PUT API KEY HERE
DO NOT REQUEST TO EDIT, GOTO FILE -> make a copy.
2
Latitude (decimal degrees)
PUT DECIMAL LAT HERE
Get your free API Key at https://darksky.net and instert key into cell b1, go to google maps and right click on your location, select what is here and copy lat and long into sheet
3
Longitude (decimal degrees)
PUT DECIMAL LON HERE
Goto Tools - > Script editor and click on the clock icon to schedule the script daily each night from 1-2am for example. Run Script to test it and allow permissions. Make sure script AND spreadsheet time zones are set up
4
Crop Coefficient0.8Spreadsheet and script made by: Jason Haines @pendersuper www.turfhacker.comIdeal Cool GrowthIdeal Warm Growth
5
1st day of year1/1/2018
Powered by Dark Sky
Hargraves ETo ModelPace Turf Growth PotentialSmith Kerns Dollar Spot
Max Monthly ml/m^2
Max Monthly ml/m^2
6
DateMean TempMax TempMin TempHumidityET (mm)Forecast ET (mm)Cool GPOptimum GPWarm GPProbabilityForecast ProbabilityAction Threshold400.00400.00
7
11/16/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
8
11/17/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
9
11/18/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
10
11/19/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
11
11/20/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
12
11/21/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
13
11/22/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
14
11/23/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
15
11/24/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
16
11/25/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
17
11/26/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
18
11/27/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
19
11/28/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
20
11/29/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
21
11/30/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
22
12/1/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
23
12/2/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
24
12/3/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
25
12/4/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
26
12/5/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
27
12/6/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
28
12/7/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
29
12/8/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
30
12/9/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
31
12/10/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
32
12/11/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
33
12/12/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
34
12/13/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
35
12/14/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
36
12/15/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
37
12/16/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
38
12/17/2018#VALUE!#VALUE!0.13%60.00%0.01%20.00%0.020.00
39
12/18/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
40
12/19/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
41
12/20/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
42
12/21/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
43
12/22/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
44
12/23/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
45
12/24/2018#VALUE!0.13%60.00%0.01%20.00%0.020.00
46
0.01%
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...