How to stop recording coordiantes to Spreadsheet

tphanyamada shared this idea 9 years ago
Answered

Dear all,

I have two graphic screens. Each screen has a point.

I follow the direction on this link http://wiki.geogebra.org/en...

to record the coordinates of one point to the spreadsheet.


After that, I want to record the coordinate of the other point. But it seems only the first point is recorded. I couldn't stop recording either.


Could you please help me?


TPY

Comments (7)

photo
1

Hi,


Could you please help me?


please send your ggb-file


Raymond

photo
1

Hi Raymond,

Thank you for helping me.

In this file, I first record the coordinates of point A. Then I erase its data and try to record point B.

However, it keeps on recording point A in the row below the previous data.

I want to the file to record the coordinates of a point on the second row whenever I start to record it.

I hope you can help me.


A big "thank" to you.

TPY


P.S. It seems I don't have a privilege to post a file.

Please download the file from here.

http://www.geogebratube.org...

photo
1

Hi,


What you want is exactly in this way is not possible.

- It is not possible to change Recording dynamical (also no script-commands, no start/stop etc)

- The synchronization of three or more dependent values ​​(in the same row) is only partially possible


In attachment is a proposal that show how (perhaps) you can solve the problem:


There is a third point defines (RecordingPoint = If[AorB ≟ 1, A, B]).

A slider (AorB (min=1, max=2, step=1)) controls whether the 3rd point is to follow the point A or point B.

Recorded are not the individual values ​​but a list: RecordList= {RecordingPoint, AorB, a, b}

Record List will cause the values are synchronous in a table row


But:

depending on the purpose of the worksheet other solutions can be much better.

Maybe you can explain WHY / FOR-WHAT you need this application.


Raymond

https://ggbm.at/567535

photo
1

Hi Raymond,

Thank you so much for your help.

Now I can record whatever I want to.

However, I cannot reuse the rows and columns once I record the data.

GGB keeps recording further down.


Do you know how work around this problem?


Thank you,


tpy

photo
1

However, I cannot reuse the rows and columns once I record the data.

GGB keeps recording further down.

Do you know how work around this problem?

Work with lists and the commands: Zip[], Sequence[], Element[], etc. see here


First change the Record Windows: set also the Bolean "Trace to List"

Now A1, B1... E1 are list. This list you can use in the Algeba-Windows.


Alist = Reverse[RemoveUndefined[Zip[If[AorB ≟ 1, (X, Y)], X, A1, Y, B1, AorB, C1]]]

This make a copy of all Points (A1 and B1) depending from AorB (C1) ==1 into "Alist". The result is cleared from undefined values and the order is reverse . That mean the first in the list is the last recorded point. Only the points A (AorB==1) are in this list.


abAList = Reverse[RemoveUndefined[Zip[If[AorB ≟ 1, (a_L, b_L)], a_L, D1, b_L, E1, AorB, C1]]]

By analogy the same ​​for the values a and b. But only if they are associated with the point A.


Klick on the left table in the grafik-Windows and press F3. In the input-line yo see the command:

Atabtxt = TableText[{Append["A", First[Alist, Min[Length[Alist], 20]]], Append["a", First[x(abAList), Min[Length[Alist], 20]]], Append["b", First[y(abAList), Min[Length[Alist], 20]]]}, "vr"]

This command bring 3 lists together. And bring there in a vertical, right aligned order (last parameter "vr")

The first of the 3 lists is: Append["A", First[Alist, Min[Length[Alist], 20]]]

That mean: the first elements from Alist in the length from Alist but not more then 20 elements. The first Element is append and has the Value "A"


The commands in the button "Reset" set all list in A1...E1 to empty (={}). All depending list are automatically also empty.


Raymond

https://ggbm.at/567547

photo
1

Hi Raymond,

Thank you for all your codes.


I found a way (not the best way) to do it.

After set up everything, export it to GGBtube. Then record from there.

Whenever we close the site, the data is gone.

Open the site again if you want to record another data set.

I post your file on GGBtube. I hope you don't mind.

Check here to see http://www.geogebratube.org...


Hope it works for you.


tpy

photo
1

Simple solutions are the best. Your Idee is good.


But if you must do this with a ggb-file, then you can do this like the sample in the attachment. (a little bit less simple but the reverse list is included).


Raymond

https://ggbm.at/567555

© 2023 International GeoGebra Institute