Figure out my suppliers formula for

Status: Closed
Prize: $50
Entries Received: 13
Winner: cugamelover

Winner

Contest Brief

I need someone to provide me with the formula my supplier uses to calculate PRICE from SPEED A, SPEED B and TERM. It does not need to be EXACT, a margin of 50 in either direction is acceptable.

Here is the pricing spreadsheet: (also attached)
https://docs.google.com/spreadsheets/d/1pQbFoKOA02maJGFghiTz9X40ErprGsnI_o9ogpF-cNU/edit?usp=sharing

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“AMAZING freelancer, extremely skilled in what he does, delivers extremely accurate work and a real pleasure to hire”

nkukard, South Africa.

Public Clarification Board

wwhitty987
- 9 years ago
HOW did you chose the winner
- 9 years ago
vw1249172vw
- 9 years ago
I don't understand, I use one formula and the error is in the range [-25.68, 33.70].
- 9 years ago
Kimon2164
- 9 years ago
Test results with the second attempt:

10 5 5 12 10334,90323
10 5 5 24 9656,537147
10 5 5 36 8978,171066
10 5 5 48 8299,804986
10 5 5 60 7621,438905
- 9 years ago
Kimon2164
- 9 years ago
It was too good to be true. I assumed the independent variables could only take the values shown in the data. I apologize if I misled anybody.
- 9 years ago
Kimon2164
- 9 years ago
Hello. I just submitted an entry which seems to be exact. I believe the 8 cases with non-zero errors (max absolute error below 33) are due to the precision I used in the coefficients in the calculations. I think there is no noise here, i.e. this is not a machine learning task.
- 9 years ago
cugamelover
- 9 years ago
I've submitted another entry with the update spreadsheet.
- 9 years ago
cugamelover
- 9 years ago
I added the Difference column but I'm not sure how to update that picture.
- 9 years ago
cugamelover
- 9 years ago
Sure, here they are:

10 5 5 12 10328
10 5 5 24 9688
10 5 5 36 8965
10 5 5 48 8335
10 5 5 60 7705
- 9 years ago
cugamelover
- 9 years ago
I wonder if the results by sambestsolutions are obtained by a universal formula or a number of specific if-else clauses. They are SO good that they could be either given by the EXACT formula used originally, or else they can't be used to predict the price for any parameters not already in this data set. Just a thought...
- 9 years ago
cugamelover
- 9 years ago
shebrien is right, your supplier must have some other factors involved in his formula. For this reason one cannot reverse engineer it exactly, but my formula gives a good approximation. If you have more data like those you supplied, my formula could be made more accurate, or it could be optimize to have the highest accuracy for a certain range of Speed or Term, whichever you prefer.
- 9 years ago
cugamelover
- 9 years ago
almost done
- 9 years ago
shebrien
- 9 years ago
There might be more factors involved, I say this because of these two lines:
10 0 10 12 11388.23
10 0 10 12 11437.67
- 9 years ago
gauravkumar9650
- 9 years ago
Innovating new Question is my passion.
3 Years of Experience in the field of Teaching Mathematics.6 Month of experience in the field of mechanical design & drafting with
excellent knowledge of cad tools like Solidworks (Certified Solidworks
Professional), etc.
I am addictive to applied knowledge and don't hesitate to enter any field because I have bachelored in Mechanical Engineering.
Expertise in 3D modeling, Reverse Engineering, sheetmetal and castings.
- 9 years ago
itachi23
- 9 years ago
hi is the total always like 5 10 15 20 25 ..
- 9 years ago