Content
# #solvang-water — 2025-10-22
**08:21 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761146502032439):** working on the database and ignition portion of this.. its calculating 179k from yesterday.. which may be right since we were messing with scaling.. but want to make sure the daily readings are accurate.
**08:21 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761146512742709):** are you doing zone 2 today?
**08:29 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761146959565379):** do they use these values for reporting? i dont think the way its being done is accurate
**08:31 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761147091540199):** cool thanks. I am not doing Zone 2 today. It will be a little bit until we can finish that one. They have to exchange the meter.
**08:32 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761147120807289):** Yes the report their production with all these meters (all the ones you see on the production report)
**08:32 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147178543239):** ok, should i spend the time to do this right? i think the PLC should be calculating a total.
**08:33 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147191530729):** im still trying to get their SQL query to return a valid value
**08:34 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761147278917079):** So all the flow totalizers should be modified? How inaccurate do you think they are
**08:34 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147299580129):** ive only looked into the data for this new meter.
**08:35 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147308983029):** im still running some calcs manually to see if i can make sense of it all
**08:35 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147335685309):** its adding up 179,000 gallons from the little time we had flow yesterday.
**08:35 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147349743029):** will have more info son
**08:37 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761147471946459):** well we were flowing a max of 1200gpm. We didn't run that for 149 minutes straight
**08:38 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147533866549):** during scaling, we had 3900gpm for a while. but the math still isnt adding up.. i see one problem already.
**08:39 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761147552387359):** oh right
**08:39 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147558948199):** it recorded 3900gpm and then the next record in the database is 20 minutes later
**08:39 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147572901019):** so their sql query adds up over 80,000 gallons for those two records alone
**08:39 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147589522319):** we need a proper totalizer in the PLC....
**08:40 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147601930139):** but maybe after a day or two the historical records will make more sense?
**08:41 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761147673355759):** I'm all for making the PLC be the totalizer. What's your time estimate for making the changes?
**08:41 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147685274569):** we may have had it pegged at 3900 for 20+ minutes while the meter was off and it was "stuck" at 20ma
**08:41 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147704379839):** but in their sql query i also dont see any code to time weight the entries.
**08:42 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147731912939):** which would work if they interpolated the data at 1 minute intervals..
**08:43 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147796805639):** i think 2 hours to get a totalizer working and added to historian and then i can update that report to pull the totalized value instead of calculating it.. they may have other reports that need to be updated as well though.. let me look
**08:46 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761147966655099):** Mike says he wants it to be accurate. He uses the SCADA numbers in his report to the State.
**08:46 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761147996891339):** PLC totalizer is gonna be the way to go
**08:47 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761148045096199):** We just need to be careful when downloading a new program to make sure it doesn't set the totalizer back
**08:47 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761148048927219):** curious about our scaling "issue" on the flow meter. what are your thoughts? you see that its 0-3900 but we get 20ma around 3250gpm
**08:48 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761148080932469):** *true... the total will be logged in the database.. we could aways look it up and plug it back in
**08:48 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761148121075159):** I think we have it calibrated to read what the meter reads locally, so I'm not worried about it. It is odd though
**08:49 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761148158703229):** ok.. im going to spend a little more time to see if we can do this accurately from the database
**08:50 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761148202713929):** I like the PLC option. Mostly for when there are comm issues.
**08:50 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761148219347279):** ok.. i do too.
**08:51 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761148266819379):** I say proceed with making a totalizer in the Z1 plc, and see how that goes.
**08:51 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761148276102199):** copy that.
**09:30 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761150617162719):** looks like they will need to run this turnout starting around noon today
**09:30 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761150642597879):** what does that mean? they are opening the valve?
**09:32 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761150748694529):** they will need to refill the reservoirs after dropping them to their low point. they will want to turn it on likely around noon. think you can have the totalizer working by then?
**09:33 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761150830061319):** they would also like to have this work off of setpoints like the wells do. but not necessary right away. the totalizer is priority
> **09:35 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761150934700329):** Task has been added
**09:34 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761150876999749):** yes i think the totalizer should be working by noon.
**09:34 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761150887087369):** they plan on opening the valve manually? how do they do that do you know?
**09:36 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761151019242839):** they would like to open via SCADA if possible, but they can open manually if needed
**09:37 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761151046372689):** ok, ill try to have a scada command working by noon
**09:38 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761151110973359):** they said we can test as needed, just try to keep the length of runtime to a minimum.
**09:38 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761151125499609):** excellent. thank you
**09:51 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761151898708369):** I'm getting you a license for CCW Dev so you can do online edits
**09:52 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761151947984609):** you can hold off if you want.. until i hand in this laptop.. im online with the DEV version and can do online edits.
**09:52 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761151963388079):** but will only have it for another few weeks
**11:11 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156701166229):** CCW crashed and the PLC needs a power cycle to release the user lock.
**11:12 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156721383309):**
```
• The lock is stored in the controller's runtime memory, not in your CCW project — a reboot always clears it.
• CCW has no manual "force unlock" command like Logix platforms.
```
**11:12 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761156728571649):** let me see if I can get them to power cycle it
**11:12 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156736249159):** thank you!
**11:12 [Reno Hiltermann](https://slack.com/archives/C093T9M10EQ/p1761156779818889):** Main reason I hate CCW.
**11:13 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156789693539):** not a convenient feature
**11:13 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156790661489):** for sure
**11:13 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156828248069):** @Kevin the valve automation is working. the setpoints on scada will control the valve call.
**11:13 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156839028729):** i havent looked into the soft HOA controls yet.
**11:14 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761156858643859):** sweet!
**11:14 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761156869672549):** Andrew says he'll be on site in 10 min
**11:14 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761156883444069):** awesome, this is very helpful. thank you
**11:38 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761158298790119):** power cyclingn ow
**11:38 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761158336520329):** k
**11:42 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761158561306089):** still working on it? i havent seen a power cycle yet
**11:43 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761158591567759):** he says he just restarted
**11:43 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761158606160919):** i have a ping going, it never dropped.
**11:43 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761158610579269):** and its still locked
**11:44 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761158662483529):** having him try again
**11:48 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761158928583469):** there we go
**11:48 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761158932265219):** i see it dropped
**11:50 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159000666739):** copy
**11:50 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761159015610419):** not back yet
**11:53 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159180017519):** now?
**11:53 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761159186210719):** yes
**11:53 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761159188832069):** its back.
**11:53 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761159192628739):** thank you for your help
**11:55 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159356400509):** You're welcome.
**11:56 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159378063239):** I told Andrew the HOA in scada doesn't work yet, but the valve will open and close on setpoint
**12:00 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159650085629):** are you RUT into the dev machine?
**12:01 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761159696726449):** no. I'm RDPd into it
**12:01 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159713572519):** you setup vpn?
**12:02 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761159744356259):** yeah using a tailscale tunnel to the machine.
**12:02 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159768332359):** copy
**12:02 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761159776977129):** is that our tailscale account?
**12:03 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761159787253269):** yes
**12:08 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761160133522679):** you are keeping an eye on the Res 1 level to make sure the valve comes on?
**12:09 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761160154123889):**
![[F09MKT8DV7Z_image.png]]
**12:09 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761160198580839):** modbus issues trying to get the new totalizer tag into ignition. i think its an 820 issue..
**12:28 [Mason Radke](https://slack.com/archives/C093T9M10EQ/p1761161310188129):** ok, we're looking better
**12:31 [Kevin](https://slack.com/archives/C093T9M10EQ/p1761161490407619):** sweet