|
|
You know... maybe ...
a.) In Excel you can Show a function y=f(x) easily, based on a table x,y.
b.) You can also select then for a function "smooth lines".
Everything ok so far and Excel does really Show a nice "smoothed" graph which seems to contains all the original Points of my "non smooth" value table.
Does anybody has an idea how Excel does calculate the "smooth" function?
I googled, but missed the relevant Information until now.
Thanks in advance.
|
|
|
|
|
Take a look here: Interpolation methods[^]
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
That Looks great! Thank you very much 
|
|
|
|
|
|
If only there was a C# library for each of those curve-fitting methods 
«While I complain of being able to see only a shadow of the past, I may be insensitive to reality as it is now, since I'm not at a stage of development where I'm capable of seeing it.» Claude Levi-Strauss (Tristes Tropiques, 1955)
|
|
|
|
|
Sorry, not everybody is on c#, still on c++
|
|
|
|
|
JustWatchLittle wrote: still on c++
Be happy... it could be VB  
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
|
|
Actually... I don't have a problem with it, but it was a mandatory joke :P
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
VB certainly earned me a lot of money when I was contracting.
|
|
|
|
|
Only because something is profitable doesn't imply that is good
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
|
Yes true, and thanks for blaming me. I find all this also, but _what exactly _ Excel is using?
And in case you think you know everything, than please explain which algo I have to use that my original Points are in the smooth function....
Google I can do by myself, but get the real Background is sometimes more than just a Little bit googling and copy&paste...
modified 11-Nov-17 15:43pm.
|
|
|
|
|
JustWatchLittle wrote: thanks for blaming me
Nobody "blamed" you ! If anyone is to blame here, it should be this lazy flea, who didn't go a-googlin' before he oped his yap JustWatchLittle wrote: And in case you think you know everything, than please explain which algo I have to use that my original Points are in the smooth function....
So, we should read your mind, figure out what type of spline function you want ?
«While I complain of being able to see only a shadow of the past, I may be insensitive to reality as it is now, since I'm not at a stage of development where I'm capable of seeing it.» Claude Levi-Strauss (Tristes Tropiques, 1955)
|
|
|
|
|
You should reread and rethink this post.
It comes off in a pretty bad way, Marc is really trying to be helpful, and there's not enough info in the thread to conclude that he is "blaming" you.
|
|
|
|
|
I'm aware that Mr. Marc Clifton is an authority and that his information/tips are very helpful! I read most of his articles and enjoy them and are thankful for them.
For this question I simply feeled pissed off, could be I'm wrong. Sorry. Sorry especally to @Marc-Clifton
|
|
|
|
|
JustWatchLittle wrote: Yes true, and thanks for blaming me.
I'm LMAO reading the replies. My reply to Bill was specifically meant for Bill as he was wishing there were some C# implementations. I was actually surprised how little how I found googling around.
JustWatchLittle wrote: Google I can do by myself, but get the real Background is sometimes more than just a Little bit googling and copy&paste...
Well duh, I wasn't googling for what algo Excel was specifically using, just trying to find if someone, say on github, had done a broad implementation of several algorithms. Never came up with anything, though I imagine in Python/Numpy they exist.
JustWatchLittle wrote: And in case you think you know everything, than please explain which algo I have to use that my original Points are in the smooth function....
Everything but that.
|
|
|
|
|
First of all, thank you very much for your answer. Need some time to translate and understand it.
Thanks again.
Bruno
|
|
|
|
|
As ever, thanks !
«While I complain of being able to see only a shadow of the past, I may be insensitive to reality as it is now, since I'm not at a stage of development where I'm capable of seeing it.\» Claude Levi-Strauss (Tristes Tropiques, 1955)
|
|
|
|
|
God it is dreadful.
On XP it used to work, now, it is a pile of crap.
|
|
|
|
|
Tell us WHY it's dreadful and a pile of crap. Everything else is just an opinion.
|
|
|
|
|
because it steams and is brown
|
|
|
|
|
Sounds like coffee. Mmmm... coffee...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
