sorry just a bit fustrated.
OK there is no database, I have a min and a max price. We need to find what the min reserve is.
products can be from $10-1 billion. Everything works great until we hit the really high numbers like over 2 million.
here is my code
<?
// Test makeanoffer range script.
if ($_POST["button"] == "Submit") {
//get reserve
if ($_POST["min"] < 99999) {
$range_calc = $_POST["min"] * (0.6 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 99999 && $_POST["min"] < 149999) {
$range_calc = $_POST["min"] * (0.6 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 149999 && $_POST["min"] < 199999) {
$range_calc = $_POST["min"] * (0.62 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 199999 && $_POST["min"] < 249999) {
$range_calc = $_POST["min"] * (0.62 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 249999 && $_POST["min"] < 299999) {
$range_calc = $_POST["min"] * (0.64 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 299999 && $_POST["min"] < 349999) {
$range_calc = $_POST["min"] * (0.64 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 349999 && $_POST["min"] < 399999) {
$range_calc = $_POST["min"] * (0.66 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 399999 && $_POST["min"] < 449999) {
$range_calc = $_POST["min"] * (0.66 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 449999 && $_POST["min"] < 499999) {
$range_calc = $_POST["min"] * (0.68 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 499999 && $_POST["min"] < 549999) {
$range_calc = $_POST["min"] * (0.68 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 549999 && $_POST["min"] < 599999) {
$range_calc = $_POST["min"] * (0.7 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 599999 && $_POST["min"] < 649999) {
$range_calc = $_POST["min"] * (0.7 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 649999 && $_POST["min"] < 699999) {
$range_calc = $_POST["min"] * (0.72 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 699999 && $_POST["min"] < 749999) {
$range_calc = $_POST["min"] * (0.72 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 749999 && $_POST["min"] < 799999) {
$range_calc = $_POST["min"] * (0.74 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 799999 && $_POST["min"] < 849999) {
$range_calc = $_POST["min"] * (0.72 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 849999 && $_POST["min"] < 899999) {
$range_calc = $_POST["min"] * (0.72 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 899999 && $_POST["min"] < 949999) {
$range_calc = $_POST["min"] * (0.7 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 949999 && $_POST["min"] < 999999) {
$range_calc = $_POST["min"] * (0.7 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 999999 && $_POST["min"] < 1049999) {
$range_calc = $_POST["min"] * (0.68 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 1049999 && $_POST["min"] < 1099999) {
$range_calc = $_POST["min"] * (0.68 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 1099999 && $_POST["min"] < 1149999) {
$range_calc = $_POST["min"] * (0.66 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 1149999 && $_POST["min"] < 1199999) {
$range_calc = $_POST["min"] * (0.66 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 1199999 && $_POST["min"] < 1249999) {
$range_calc = $_POST["min"] * (0.64 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 1249999 && $_POST["min"] < 1299999) {
$range_calc = $_POST["min"] * (0.64 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 1299999 && $_POST["min"] < 1349999) {
$range_calc = $_POST["min"] * (0.62 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
} elseif ($_POST["min"] > 1349999 && $_POST["min"] < 1499999) {
$range_calc = $_POST["min"] * (0.62 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
}
/*if ($_POST["min"] < 200000) {
$range_calc = $_POST["min"] * 0.6;
} else {
$range_calc = $_POST["min"] * (0.6 + 0.02 * ((int)($_POST["min"] / 100000) - 1));
}*/
echo $range_calc;
exit;
}
?>
<form name="testform" action="<? echo $PHP_SELF; ?>" method="post">
<input type="text" name="min" id="min">
<input type="submit" name="button" id="button" value="Submit">
</form>
basic math we use is...
$min+$max/2*.6
problem with this is that the higher the min is the output comes out wrong, wither to low or to high. Here is some sample data from the spreedsheet.
Min Price Percent Output Diffrence
$100,000 0.6 $60,000.0 $40,000.0
$150,000 0.62 $93,000.0 $57,000.0
$200,000 0.64 $128,000.0 $72,000.0
$250,000 0.66 $165,000.0 $85,000.0
$300,000 0.68 $204,000.0 $96,000.0
$350,000 0.7 $245,000.0 $105,000.0
$400,000 0.72 $288,000.0 $112,000.0
$450,000 0.74 $333,000.0 $117,000.0
$500,000 0.76 $380,000.0 $120,000.0
$550,000 0.78 $429,000.0 $121,000.0
$600,000 0.8 $480,000.0 $120,000.0
$650,000 0.82 $533,000.0 $117,000.0
$700,000 0.84 $588,000.0 $112,000.0
$750,000 0.86 $645,000.0 $105,000.0
$800,000 0.8601 $688,080.0 $111,920.0
$850,000 0.8602 $731,170.0 $118,830.0
$900,000 0.8603 $774,270.0 $125,730.0
$950,000 0.8604 $817,380.0 $132,620.0
$1,000,000 0.8605 $860,500.0 $139,500.0
$1,050,000 0.8606 $903,630.0 $146,370.0
$1,100,000 0.8607 $946,770.0 $153,230.0
$1,150,000 0.8608 $989,920.0 $160,080.0
$1,200,000 0.8609 $1,033,080.0 $166,920.0
$1,250,000 0.861 $1,076,250.0 $173,750.0
$1,300,000 0.8611 $1,119,430.0 $180,570.0
$1,350,000 0.8612 $1,162,620.0 $187,380.0
$1,400,000 0.8613 $1,205,820.0 $194,180.0
$1,450,000 0.8614 $1,249,030.0 $200,970.0
$1,500,000 0.8615 $1,292,250.0 $207,750.0
$1,550,000 0.8616 $1,335,480.0 $214,520.0
$1,600,000 0.8617 $1,378,720.0 $221,280.0
$1,650,000 0.8618 $1,421,970.0 $228,030.0
$1,700,000 0.8619 $1,465,230.0 $234,770.0
$1,750,000 0.862 $1,508,500.0 $241,500.0
$1,800,000 0.8621 $1,551,780.0 $248,220.0
$1,850,000 0.8622 $1,595,070.0 $254,930.0
$1,900,000 0.8623 $1,638,370.0 $261,630.0
$1,950,000 0.8624 $1,681,680.0 $268,320.0
$2,000,000 0.85 $1,700,000.0 $300,000.0
$2,050,000 0.8501 $1,742,705.0 $307,295.0
$2,100,000 0.8502 $1,785,420.0 $314,580.0
$2,150,000 0.8503 $1,828,145.0 $321,855.0
$2,200,000 0.8504 $1,870,880.0 $329,120.0
$2,250,000 0.8505 $1,913,625.0 $336,375.0
$2,300,000 0.8506 $1,956,380.0 $343,620.0
$2,350,000 0.8507 $1,999,145.0 $350,855.0
$2,400,000 0.8508 $2,041,920.0 $358,080.0
$2,450,000 0.8509 $2,084,705.0 $365,295.0
$2,500,000 0.851 $2,127,500.0 $372,500.0
$2,550,000 0.8511 $2,170,305.0 $379,695.0
$2,600,000 0.8512 $2,213,120.0 $386,880.0
$2,650,000 0.8513 $2,255,945.0 $394,055.0
$2,700,000 0.8514 $2,298,780.0 $401,220.0
$2,750,000 0.8515 $2,341,625.0 $408,375.0
$2,800,000 0.8516 $2,384,480.0 $415,520.0
$2,850,000 0.8517 $2,427,345.0 $422,655.0
$2,900,000 0.8518 $2,470,220.0 $429,780.0
$2,950,000 0.8519 $2,513,105.0 $436,895.0
$3,000,000 0.852 $2,556,000.0 $444,000.0
$3,050,000 0.8521 $2,598,905.0 $451,095.0
$3,100,000 0.8522 $2,641,820.0 $458,180.0
$3,150,000 0.8523 $2,684,745.0 $465,255.0
$3,200,000 0.8524 $2,727,680.0 $472,320.0
$3,250,000 0.8525 $2,770,625.0 $479,375.0
$3,300,000 0.8526 $2,813,580.0 $486,420.0
$3,350,000 0.8527 $2,856,545.0 $493,455.0
$3,400,000 0.8528 $2,899,520.0 $500,480.0
$3,450,000 0.8529 $2,942,505.0 $507,495.0
$3,500,000 0.853 $2,985,500.0 $514,500.0
$3,550,000 0.8531 $3,028,505.0 $521,495.0
$3,600,000 0.8532 $3,071,520.0 $528,480.0
$3,650,000 0.8533 $3,114,545.0 $535,455.0
$3,700,000 0.8534 $3,157,580.0 $542,420.0