What controls to use to calculate when scrolling the slider?

Hello, @mkud

We have build a prototype calculator, the link to which you sent:

Link

The calculator uses elements: Range slider, Quantity Field and Total (formula)

However, without the formulas on which the calculator is built, we cannot assemble the calculations exactly.

If you have formulas for which the calculator should work, please provide us and we will help you to construct the necessary calculator for you.

Best regards.

I don’t know the formula according to which they calculate, but I need exactly the same calculation as I sent with the supplier’s calculator. We are in the same business and need the same calculations. Example: https://solarplant.lt/skaiciuokle/

1.This data must be set as a slider to the lowest number of 100 kWh. The slider must increase every 10 numbers. From minimum 100 to maximum 3000 kWh.

https://pasteboard.co/jY1esmA792Ao.png

I don’t need the quantity field.

2. Rekomenduojama elektrin?s galia: (100KW -> 1.20), (110KW -> 1.32), (120KW -> 1,44) —-> If the sliders change every 10 on the scale, then here they must change by 0.12. The maximum must reach 36 KW.

3. Elektrin?s ?rengimo kaina -> (100KW -> 1260.00 €), (110KW -> 1386.00 €), (120KW -> 1512.00 €) —-> If the sliders change every 10 on the scale, then here they must change by 126 €. The maximum must reach 37800.00 €.

4. APVA parama -> (100KW -> 378.00 €), (110KW -> 415.80 €), (120KW -> 453.60 €) —-> If the sliders change every 10 on the scale, then here they must change by 37.80 €. After reaching 840kWh and this amount 3,150.00€ more, it does not change from higher kWh.

5. Atsiperkamumas su APVA parama -> If you can, see how this formula changes, because from 840kWh this number increases by 0.1 number. After reaching 2950kWh, this scale stops and remains (3.7 year). Please you check this example website: https://solarplant.lt/skaiciuokle/

6. Atsiperkamumas be paramos -> Nothing changes when changing the slider, it must always be the same number (4.04 year)

Thanks.

• This reply was modified 1 year, 9 months ago by mkud.

Have you seen this message from us?

Hello @mkud,

Sorry for keeping you waiting I took some time to review the logic that you described.

I created a sample calculator by following your steps and making some corrections. In my calculator, the first three Formula elements are giving the same results: https://joxi.ru/MAj5v6qsY7VV52

The latest two filed are changing depending on the value of Quantity fields: https://joxi.ru/DmBYV9PH61ddgr

Also, the value of “Atsiperkamumas Su APVA Parama” from 100kWh to 830khw is 3.28: https://joxi.ru/brRx3wZC8dyyP2. From 840kWh to 3000kWh dynamically changing depending on Quantity filed. Unfortunately, it is difficult to get logic in this field.

You can get my sample calculator from the link below:

https://www.transfernow.net/dl/202305297HKVCv5K

You can use if/else statements and manually set the price for Atsiperkamumas Su APVA Parama to get the same results in the free version of the calculator and there is a sample code:

if ( range_field_id_0 <= 83) {
3.28
} else if ( range_field_id_0 == 84) {
2.84
}else if ( range_field_id_0 == 85) {
2.85
} else {
range_field_id_0 *0.1
}

I hope it helps.

Kind regards

The first three boxes work very well.

The latest two filed are changing depending on the value of Quantity fields:?https://joxi.ru/DmBYV9PH61ddgr

can we make this field in our spreadsheet? Because according to the rules, we should have the same calculation as in their table.

If you can, then add this field where it is in the photo.

Thanks.

I see that the year changes to this number on this scale. Can you imagine what formula they use from 0.01 to 4.01?

https://ibb.co/ph25Qbb

Because these two profitability sections are very important to us. If you can, try to upload this box for us to write the price of electricity and, based on that, describe the formula in which we would change the price of electricity and change according to this table: solarplant.lt/skaiciuokle/

We need the same table and I don’t know how I can help you to get the same calculation picture.

Hello @mkud,

Unfortunately it is difficult to imagine how they calculate the value. Since the calculator is created with our plugin, there can be additional formula elements that was hidden.

I can recommend you contact site owners to get the calculator, if you are not business competitors.

Kind regards