Hi All,
I have been trying to work out how the following calculations have been created? How did they get to the value shown in the column with the circle?
Any maths pro's out there that can work it out?
how.jpg
My guess was it was it was this but it isn't right???
Screen Shot 2016-05-18 at 22.19.01.png
Can anyone workout the formula?
without a excel file it is hard to tell.
please also change the title of your question to a more usefull one (according to the forumrules).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
So the 1st one isn't 8.169 - 2.413 = 5.756?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
It is But I don't have any of those values, so if you can tell me how to get 2413 or 5756 then I can do the rest...So the 1st one isn't 8.169 - 2.413 = 5.756?
It just doesn't seem to add up to me???
Sorry, I can't find a way to edit the Title?
As oeldere stated in their post, "without a excel file it is hard to tell."
Can you attach the file you are working with?
Here is the file I am trying to get to calculate the same values as shown in the initial image!
https://www.dropbox.com/s/9mupsr19j1...ator.xlsx?dl=0
Hope you can help!
I find that I need to try to understand the underlying "real world problem" as part of trying to come up with something like this. I cannot read the text. Google translate suggests that we are trying to look at the relationship between solar electricity production and consumption. Does that sound right? If so, do you believe that there should be some kind of correlation between production and consumption? The data in your picture suggests and "inverse" relationship (if one exists) between consumption and production. Does that seem reasonable?
Originally Posted by shg
Welcome to the board, myatix.
Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.
This request is not optional.
Thanks.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks