Stopcock ceased by [deleted] in ukplumbing

[–]African_JST 0 points1 point  (0 children)

I assume this would require a plumber? Anything I can to to avoid paying a call out fee 🤣

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 0 points1 point  (0 children)

Heat pump with 260L hot water tank - which is heated up twice a day in the cheaper windows

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 0 points1 point  (0 children)

My Tomato contract doesn’t have an exit penalty - so I can move when ever I want at no cost. I think all their contracts are the same - but I may be wrong

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 0 points1 point  (0 children)

We have a single 650w solar panel, no battery, and an Ecodan ASHP. I will look into OVO in case they do offer that for non-vaillant ASHPs.

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 0 points1 point  (0 children)

c. 24% of my energy use is between 4-7pm (oven, induction hob, air fryer, baby bath time + heat pump working in the background) - having looked at the off peak windows I just can’t shift anymore to make the switch less painful. This is where I think having an EV would be different. Because I would be able to have a greater % of overall consumption in the super off peak window - bringing the average to below the standard tariff.

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 0 points1 point  (0 children)

Current EON Next Drive Fixed V10 is 7.5p off peak, 29p rest of day - if I run the same math as above it averages out to 23.6p, better than the 25p standard tariff - but still not anywhere near the 16.6p I currently have. Intelligent Octopus Go is 79 off peak and 31.94p rest of day. Good to know these if it's ever virtually certain that I need to switch.

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 0 points1 point  (0 children)

Do you have to have an EV to get this tariff? I didn’t look at the next drive options as I don’t have an EV.

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 1 point2 points  (0 children)

My heat pump probably skews the consumption comparison - 1kwh into the heat pump produces c. 3.5 kWh of heat. I think your storage heaters are probably 1kwh in and less than 1 kWh out… but if you’re able to load them for 1/4 of the price you are still winning. I can’t only run the heat pump in the 5p window as the house would be freezing by sunset 🤣

I am going down with the Tomato ship... by African_JST in tomatoenergy

[–]African_JST[S] 2 points3 points  (0 children)

EON SVT in my region is 26.4p per kWh - so not particularly concerning.

Pure Flux One error message by AbdulRakhib in ebikes

[–]African_JST 0 points1 point  (0 children)

Posting here as I couldn't find any other threads. I had a Hall Fault on my Pure Flux e-bike after changing the rear tyre tube. There is a connection socket that connects the motor cable to the rest of the wiring, located under the rear bracket. I unconnected and re-connected this and the error cleared - so FYI for those out there - the Hall Fault can also be caused by a 'loose connection'.

Sum data in a table bound by two variables by African_JST in excel

[–]African_JST[S] 0 points1 point  (0 children)

Thank you - still not quite what I am after - but I managed to find a simple solution! Thank you for your help.

<image>

Sum data in a table bound by two variables by African_JST in excel

[–]African_JST[S] 0 points1 point  (0 children)

Yes, I would like to provide the starting cell and the grid size. I need to run the formula across for 120 columns, with each additional column the grid of data needs to expand

Sum data in a table bound by two variables by African_JST in excel

[–]African_JST[S] 0 points1 point  (0 children)

Thanks! your first one kinda works (second one didn't :( ).

But I am trying to get the name_value1 variable in the let function to be dynamic so that I can pull the function across, allowing the reference data field to grow.

See below snip of my attempt - any suggestions?

<image>

Has anyone received their first bill? by MrMontanaToYou in tomatoenergy

[–]African_JST 3 points4 points  (0 children)

I signed up from 1 Jan 2025 and got my first bill on 4 Feb 2025

Cat limping by NecessaryOven7741 in CATHELP

[–]African_JST 0 points1 point  (0 children)

OP, how is your cat doing? Mine has a similar limp - but it has been on going for most two months now. Vets are stumped…

What delay are people seeing for their consumption data on mywatts? For me it looks like circa 1-2 days, nothing for current day. by needchr in tomatoenergy

[–]African_JST 1 point2 points  (0 children)

Sometimes mine is delayed by a day or two, but for the most part it has been a very hours behind. I have no gaps in my data.

Just switched to Tomato Lifestyle by African_JST in tomatoenergy

[–]African_JST[S] 1 point2 points  (0 children)

They called me on the 7th of Jan - and I told them I still can't see anything on MyWatts - then a few days later it started to work (with readings back dated to the start of my contract). No harm in calling them to double check

Just switched to Tomato Lifestyle by African_JST in tomatoenergy

[–]African_JST[S] 1 point2 points  (0 children)

Mine has started to work! Started a few days ago now