cspline routine

Just a meeting place for professional offers & requests
Forum rules
Disclaimer: this section of the forum is just a meeting place for professional offers & requests. We do not and cannot insure the liability of the proposal made publicly in the forum or privately after contact has been made in the forum. Therefore, please take up the offers made here at your own risk.
Post Reply
BruceWilliams2010
Posts: 6
Joined: Fri Feb 22, 2013 5:24 am

cspline routine

Post by BruceWilliams2010 »

Need someone to develop a macro that can do a cspline output with the results in the Calc spreadsheet and do it with the same accuracy as the smooth function when graphing XY plots. This is for Open Offcie 3.4.?
Have tried some of the VBA codes listed on this site but none produce results even close to accurate, some are actually reversed in the results or have discontinuities or results way out of range. If you are interested I will send you a spread sheet with 3 sheets. Each one with different values and the associated graph for test purposes.
OpenOffice.org 3.4.1 on Windows 7
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: cspline routine

Post by acknak »

Could I suggest that you attach your sample document to your discussion thread: http://forum.openoffice.org/en/forum/vi ... 65#p264865

And, perhaps, a comment as to why this particular function is important for your analysis? (I'm just curious, but it might help to get someone interested in cobbling something up).

Maybe you want to wait until someone steps up before putting the time in, but a link to some background on the function and some sample data and correct output would all be necessary at some point; again, it could help get someone interested sooner rather than later.

I'd also suggest that any follow-up posts not directly involving paid support should go on the other thread. You can mention your offer there as well and paste a link to this thread, if you like.
AOO4/LO5 • Linux • Fedora 23
BruceWilliams2010
Posts: 6
Joined: Fri Feb 22, 2013 5:24 am

Re: cspline routine

Post by BruceWilliams2010 »

Here is an OO calc sheet that I tested the routines with. If your routine can match the graphs output then I will be willing to pay for it.

I wish to use this routine to check for frequency shifts as light passes through different detectors. In other words, how reproducible are they?

Thank you for your time
Bruce Williams
Attachments
Example_cubic_spline.ods
(57.23 KiB) Downloaded 467 times
OpenOffice.org 3.4.1 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: cspline routine

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
BruceWilliams2010
Posts: 6
Joined: Fri Feb 22, 2013 5:24 am

Re: cspline routine

Post by BruceWilliams2010 »

cspline ver 0.5 has some major problems with OOo 3.4.1 in Windows 7 and a google search only shows Excell spread sheet add ons. No real help sorry to say.

Thank you for your help though.

Bruce Williams
OpenOffice.org 3.4.1 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: cspline routine

Post by Villeroy »

http://forum.openoffice.org/en/forum/vi ... =45&t=4574

there are 19 more search results when you type cubic spline into this forum's search box.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: cspline routine

Post by MrProgrammer »

BruceWilliams2010 wrote:Here is an OO calc sheet that I tested the routines with. If your routine can match the graphs output then I will be willing to pay for it.
Spline Interpolation describes how to interpolate data points using cubic splines. It's not hard to implement in Calc with formulas. I've attached an example of the calculations with your data. You can see that the charts made with the interpolated points match the charts created by requesting Smooth Lines → Properties → Cubic Spline.

If this method satisfies your needs, and you were sincere about paying for the support, simply make a donation, say US$ 100, to the Open Office project. I won't receive any of that money, but it will go to a good cause.

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Attachments
201502092158.ods
(86.06 KiB) Downloaded 450 times
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
haptsurk
Posts: 1
Joined: Wed Feb 18, 2015 12:42 am

Re: cspline routine

Post by haptsurk »

Thank you for taking the time to produce this spread sheet. I just got time to go through my emails today. I will test it against some of my manual results and if it gives me good answers I will be more than happy to donate the $100.

Thank you for your time

Bruce Williams
Open Office 3.4.1 on Windows 7 Pro
Post Reply