Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024
Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024
Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
0.01" vs. 0.3 mm Rain Gauge Bucket Tips
- steve
- Cumulus Author
- Posts: 26702
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: 0.01" vs. 0.3 mm Rain Gauge Bucket Tips
It doesn't matter to Cumulus what you have the console set to, the console always supplies the data in metric and Cumulus converts as required.
Steve
- Buford T. Justice
- Posts: 423
- Joined: Fri 17 Aug 2012 9:21 pm
- Weather Station: Ecowitt GW1002
- Operating System: Windows 11 Pro
- Location: USA
- Buford T. Justice
- Posts: 423
- Joined: Fri 17 Aug 2012 9:21 pm
- Weather Station: Ecowitt GW1002
- Operating System: Windows 11 Pro
- Location: USA
Re: 0.01" vs. 0.3 mm Rain Gauge Bucket Tips
I am not sure how to use this properly in a spreadsheet. I figured I could copy/paste a column from a log file into a new spreadsheet in Column A then do MROUND in Column B.mcrossley wrote:Still think mround() will do it...Code: Select all
mm inches mm round(mm) mround(mm,0.3) 0.0 0.00 0.0000 0.0 0.0 0.3 0.01 7.6200 0.3 0.3 0.6 0.02 15.2400 0.5 0.6 0.9 0.04 22.8600 1.0 0.9 1.2 0.05 30.4800 1.3 1.2 1.5 0.06 38.1000 1.5 1.5 1.8 0.07 45.7200 1.8 1.8 2.1 0.08 53.3400 2.0 2.1 2.4 0.09 60.9600 2.3 2.4 2.7 0.11 68.5800 2.8 2.7 3.0 0.12 76.2000 3.0 3.0 3.3 0.13 83.8200 3.3 3.3
B1
=MROUND(A1;0.3)
B2
=MROUND(A2;0.3)
B3
=MROUND(A3;0.3)
And so forth. I am trying this with the rainfall rates and it doesn't like 0.05, 0.09, 0.12, or similar. Maybe I need to convert Column B to bucket tips to determine mm by taking A * 100 then * 0.3.
B1
=((A1*100)*0.3)
B2
=((A2*100)*0.3)
B3
=((A3*100)*0.3)
These seem to work for converting in to bucket tips to mm.
I am not sure yet how to convert in/hr to mm/hr.
EDIT:
No I cannot do it that way as the in values are calculated so perhaps 3.54" is not really 354 bucket tips.
Last edited by Buford T. Justice on Mon 01 Jul 2013 3:07 pm, edited 2 times in total.
- mcrossley
- Posts: 12692
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: 0.01" vs. 0.3 mm Rain Gauge Bucket Tips
Yes, you need to convert from inches to mm first, then mround.
So if you had inches in column A, in column B you would have (in Excel)
So if you had inches in column A, in column B you would have (in Excel)
Code: Select all
A B
1 inch mm
2 0.09 =mround(A2*25.4, 0.3)
3 0.12 =mround(A3*25.4, 0.3)
- Buford T. Justice
- Posts: 423
- Joined: Fri 17 Aug 2012 9:21 pm
- Weather Station: Ecowitt GW1002
- Operating System: Windows 11 Pro
- Location: USA
Re: 0.01" vs. 0.3 mm Rain Gauge Bucket Tips
Would this also work correctly for converting in/hr to mm/hr?mcrossley wrote:Yes, you need to convert from inches to mm first, then mround.
So if you had inches in column A, in column B you would have (in Excel)
Code: Select all
A B 1 inch mm 2 0.09 =mround(A2*25.4, 0.3) 3 0.12 =mround(A3*25.4, 0.3)