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.
cspline routine
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.
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.
-
- Posts: 6
- Joined: Fri Feb 22, 2013 5:24 am
cspline routine
OpenOffice.org 3.4.1 on Windows 7
Re: cspline routine
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.
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
-
- Posts: 6
- Joined: Fri Feb 22, 2013 5:24 am
Re: cspline routine
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
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 577 times
OpenOffice.org 3.4.1 on Windows 7
Re: cspline routine
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 6
- Joined: Fri Feb 22, 2013 5:24 am
Re: cspline routine
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
Thank you for your help though.
Bruce Williams
OpenOffice.org 3.4.1 on Windows 7
Re: cspline routine
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.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- MrProgrammer
- Moderator
- Posts: 4908
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: cspline routine
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.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.
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 580 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).
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).
Re: cspline routine
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
Thank you for your time
Bruce Williams
Open Office 3.4.1 on Windows 7 Pro