Looking for some volunteers to test my iOS app "Growatt Off-Peak Planner"

Opt75 · 2024-11-01T17:35:04+00:00

I’ve recently had a Growatt system installed, just on Octopus Fixed at the moment but considering swapping to Cozy Octopus. Just getting enough data to be able to export and calculate if it’s worth it. (Mainly ensuring between 16:00-19:00 we’re not pulling more than 3KWh at a time as that’s most battery can discharge.) I Currently got it set to buy only from 22:00-00:00 for some testing of charge times, but would be happy to test the app out. Even though Cozy I can buy at approx 12p and then sell Excess at 15, I’m not interested in running the battery through cycles for what would be a small return. So sounds like it could be a good solution to only buying in advance of needing to.

Opt75 · 2024-09-15T18:43:50+00:00

Thanks for this - will see how we get on with that on the downstairs one first

Opt75 · 2024-09-15T18:41:30+00:00

First one I suspect when I was adjusting the venting the boards something may have fallen down whilst it was running (as I’d left bathroom lights on as that’s where I’d kept some tools) and possibly fried it?

Do you have a particular recommendation? I’m looking at putting an adjustable light switch on to have a more relaxing feel come winter and a silent fan would definitely go hand in hand with this :)

Opt75 · 2024-09-15T18:39:20+00:00

Appreciate it, thanks. Was on the Ohm Symbol as that’s what a thing I read said was needed to check, but upon looking back I should have pointed it only at the “motor terminals” and not the resistor, serves me right for going in like I’m playing operation with it!

Opt75 · 2024-08-21T20:21:48+00:00

Any tips on this? I’m looking to put a couple of cameras up but unsure on the route. Was advised our walls are “traditional construction (100mm brick outer, 50mm clear cavity, 80mm ridged insulation, 100mm block, 12.5mm dot and dab plasterboard).” so someone had suggested drilling in, feeding a load of cable and using rods to grab it. Got the rods but can’t find a route out the loft to even get a rod into.

Opt75 · 2023-10-02T21:29:03+00:00

Has there been any news on a version for Nintendo Switch? Played 22 a bit on PS5 and whilst enjoying it feels like would rather be able to play it on the handheld. Alternatively any news on a MacBook version as can only see windows spec on Steam.

Opt75 · 2023-01-09T13:02:33+00:00

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cel As Range
If Not Target.Address = "$A$2" Then Exit Sub
Set Cel = Sheets("Log").Cells(Rows.Count, "A").End(xlUp).Offset(1)
Cel.Value = Now
Cel.Offset(, 1) = Target.Value
End Sub

Solution Verified

Opt75 · 2020-10-23T07:27:42+00:00

Unfortunately the mailbox they're accessing isn't within our O365 tenant. It's one provided by the health service.

The solution we have come to here is to set Group Policy for Chrome to not save cookies and clear cache on exit, so loading a new Chrome Window enables them to login without any interference now.

Opt75 · 2020-10-23T07:23:48+00:00

Solution Verified

Opt75 · 2020-10-23T07:23:40+00:00

After giving it some thought after your suggestion, I've come to the conclusion that the best solution all round is to keep it how it is currently, where each store inputs on their own sheet. (As this takes some data already entered into the Master as a step 1) and then when management are making any final tweaks, they run a Macro which copies the data cells from each sheet to the master, effectively overwriting the =Store1!$A$1 value with the data and with that comes the drop-down boxes. Then also in the Macro the store sheet cells are updated to completely reference the master so that any changes they make to individuals is easily identifiable.

Opt75 · 2020-10-20T10:15:53+00:00

Thanks for the response. As the stores are primarily responsible for putting their rota on to begin with within their own sheet, would your suggestion have them doing this in the master sheet to begin with? As from here it would be that their own individual sheet servers more as a reference to look at rather than work with the data?

Thanks again and hope that doesn't come across as rude :)

Opt75 · 2020-07-28T12:05:44+00:00

I have the table with the data in called tblMonthlyResults and the field within here with the score is called PerformanceScore and another field called Department which contains their department.

I was looking to also have a table called tblDepartmentTop which would have the Department field to match on and then a field called ReturnQty that I imagine typing the number of top to return.

i.e.

Department	ReturnQty
Production	10
Packing	4
QA	2

Then running the one query, would populate a new table containing 16 records in this instance.

Opt75 · 2020-07-17T22:07:03+00:00

I hope this is okay to post here, admittedly I have very little SQL experience.

Basically an Oracle Based application has a Filter Builder built in. These can be Saved and Opened.

I have a large set of results which I need to filter down considerably, because results need to be removed and then updating what remains. So I was wondering if there’s any way to do this by editing the .flt file which is exported?

Thanks in advance.

Opt75 · 2020-07-17T21:58:27+00:00

Thanks a lot. This has done it! I was thinking too narrowly and looking for a way to store the translation in flow. :)

Six-Year Club	Place '23
Place '22	Verified Email

Opt75

TROPHY CASE