Dynamic filling of a spreadsheet according to the all possible slider values

Diaa shared this question 2 years ago
Answered

For the attached file, I need to

  1. make the first column "Col 1" be filled with all the possible values of the slider (from the its minimum to maximum values) based on the increment value "Step".
  2. make the second column "Col 2" have its cells dynamically filled with the function values

ColTwoFn(x)

where x the corresponding cell index of the first column at the same row.

Best Answer
photo

The roughly sketched solution approach of mathmagic works in GGB5.

Dynamic lengths of lists are in GGB6 very problematic (performance).

As an attachment an alternative with TableText() and slider (see also post from Simona)

Comments (9)

photo
1

What are you trying to do overall?

photo
1

I need to have a spreadsheet with all the possible values of the slider instead of filling it manually. Whenever the slider max/min/increment value changes, the spreadsheet needs to be accordingly updated.

photo
photo
2

Registering the slider values on a spreadsheet can be confusing, because if you move the slider up and down, values keep being updated.

If you need to display the values of the function in a dynamic table, you might try a different approach, maybe using TableText command https://wiki.geogebra.org/e..., like in the attached example (move the slider).

photo
1

I just need to have a spreadsheet with all the possible values of the slider instead of filling it manually. So, the spreadsheet won't be updated by the slider value; it will be affected by the changes in the slider value of min/max/increment only.

photo
photo
1

I just need to have a spreadsheet with all the possible values of the slider instead of filling it manually.

Please explain what you are trying to do overall - ie what are you going to do with that

photo
1

I have a mechanism where the input is given by a slider and I have two outputs: real output that can be measured from the mechanism and a theoretical output that can be deduced by a function of the input variable (slider value). The input and the two outputs are needed to be saved in the spreadsheet.

I managed to do it manually, but changing the slider min/max/increment made me start the process over again.

photo
1

The input and the two outputs are needed to be saved in the spreadsheet.
Why? What will you do then?


Also it would be helpful if you post your full .ggb file

photo
photo
2

try FillColumn(1, Sequence(min,max,inc))

photo
2

The roughly sketched solution approach of mathmagic works in GGB5.

Dynamic lengths of lists are in GGB6 very problematic (performance).

As an attachment an alternative with TableText() and slider (see also post from Simona)

© 2023 International GeoGebra Institute