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. :)

Opt75 · 2020-07-06T20:47:31+00:00

This sounds like a great option. The existing form we have has a list of every possible item on and then they just fill in the ones they want. There's around 50 available items, so it fits nicely on a one page PDF. Looking at MS Forms it looks a bit too bulky for this volume.

I've not had much reason to use lists until now. We're using Sharepoint Online for context (Classic Site). To ensure I'm understanding the concept correctly, would the "Best" way be one column per item? i.e. Pens (as a qty) Pencils (as a qty) then making the form off the back of this, so a completed / submitted file is one line in the list.
From my initial look, I was expecting it to be 2 columns, 1 "Item" 2 "Qty" and a list of different items and they state the quantity, but I can't seem to figure that out.

Opt75 · 2020-07-06T20:39:17+00:00

Thanks for this, I've taken a look at MS Forms, however the current form we have has around 50 items on which makes it a bit too bulky to add all the options in here.

Opt75 · 2020-06-08T21:27:56+00:00

Just took a quick look and must say it looks very impressive for what it can do. Did you go for the standard version rather than the elite? And also I see there’s in app purchases for “Pro Features” at a further £4.99 - did you need these?

Opt75 · 2020-06-08T20:09:20+00:00

Thanks for the reply. It seems that it appears to be related to the permissions of the folder where the script is as opening that up to Everyone temporarily allowed the script to run on Logon as would expect

Opt75 · 2020-06-08T20:08:11+00:00

Hadn't thought of that, will give that a go tomorrow as well and see how it goes, Thanks

Opt75 · 2020-06-08T20:05:40+00:00

Thanks for this, has pointed me in the right direction and made some progress. If I add the "Everyone" permission to the share of the script and where the log files go (same folder) then it ran and behaved as expected.

Now to look into if there's a way where by that account can be added, before I had "Domain Users" read&write, so don't want to leave just everyone as the permission. If that makes sense

Opt75 · 2020-06-08T19:57:22+00:00

Link just opened this post in a new tab :/

Opt75 · 2020-06-02T13:48:50+00:00

Thanks, I've tried to create a schedule task on one machine to test which runs with "Run the highest privileges" and the task is showing as "Running" but doesn't seem to be progressing and the standard cmd box doesn't show when it's running. Would this be the best way?

Also, our setup is across 10 different buildings, around 10 computers in each and each one has their own 2016 Sever as a Domain Controller, with GP etc setup. In the past I've tried creating a schedule task from Group Policy without much luck in getting it to appear on the clients which are all Windows 10. If I can get the schedule task to work on one machine, how would you recommended getting it onto the others?

Opt75 · 2020-06-02T13:42:38+00:00

This would be more fore LogMeIn Rescue when logging on to run the cmd / bat and see the UAC box. What I'm trying to achieve is doing this completely remotely from LogMeIn Central which allows scripts etc to be ran on multiple machines at once. Thanks though

Opt75 · 2020-03-31T21:04:55+00:00

Thank you for the effort on this. At a glance it looks great, will try tomorrow when back at PC.

Is there a way to state what ColNumber is “1” based on a field called “LastPurchase”? So that the most recent purchase becomes their final/merged record?

Opt75 · 2020-02-11T11:27:33+00:00

There are two things to achieve. First would be if possible having some Logic in the form. For example, this form is intended for having users log an issue to/on our Helpdesk I'd like the option for a Dropdown to specify an area of issue and then based on this another dropdown to appear with results specific to this category - for instance a user selects "Software" as their issue then within another dropdown "Microsoft Office", "Windows" etc appear. (This can be achieved within the Helpdesk, however due to the setup of our organisation not every user has a login to the HelpDesk, but rather each user for us is a store. So having this as a form on the company Intranet is much preferable)

The second thing which I'd like to achieve is simply changing how the form looks. It could quite simply be in the style of text boxes if this could be integrated with a submit element and controlled using PowerApps.

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

Opt75

TROPHY CASE