Hi :) Sorry for the lack of replies so far!! The best documentation is on our wiki at https://wiki.documentfoundation.org/Documentation/Publications as well as being available for purchase from various online stores and even as properly published guides. Regards from Tom :)
On 26 January 2014 19:02, Dominique Michel <[email protected]> wrote: > Hi, > > This is my first message to that list, and I am a newbie with calc. > > What I want to do is to extrapolate a sheet from an existing sheet, and > later do some calculation on the new sheet. The existing sheet is a > simple x/y graph with x on the A1, some values in A2 to An, and the > other rows, the value of x in the first cell, and the value of y for > the value corresponding to A2 to An in the following cells. This > give a chart with one x/y curve for each cell between A2 to An. This > work fine. The sheet look like: > > x -20 -10 0 10 20 > 0 0 0 0 0 0 > 1 0.1 > 2 0.2 > 3 0.23 > 4 0.34 0.15 > 5 0.4 0.3 > ... > > The new sheet will represent the values of x at A2 to An, that for > different values of y. In other words, the first sheet is y=f(x) for > different and constant n, the new sheet will be x=f(n) for different > and constant y. > > n 0.1 0.2 0.3 0.4 0.5 > 20 1 > 10 2 > 0 5 > ... > > First I must have a way to search for the nearest 2 values of y in the > table, and from them do a calculation to extrapolate the value of x for > y. It must also know the value of n. > > It is 2 cases, if the value of y = y_new sheet, no calculation is > needed, is the value of y != y_new sheet, I must make a simple > calculation to determine the value of x from the 2 nearest values of y. > (I have enough points, so I can assume it is a straight line between > the 2 values). > > What I cannot figure out, is how to go trough the existing sheet with a > formula that will find the 2 nearest values of y and apply a function > on these values, or output directly the value if an exact match is > found. And from that build a new sheet. > > Another issue is the original data comes from a csv file, that is > synchronized to the original sheet. The csv file is generated by > engauge, and between 2 runs, the numbers of rows and columns in that > file will change. That imply the new sheet must also be able to be > synchronized with the old one, and that even if the numbers of rows and > columns are changing. Is it possible to do that? > > > Can you explain me how to do this, or provide me a link to some > documentation describing a similar issue? > > Cheers, > Dominique > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
