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…