I use a cs-cart shopping cart website.? PHP/MYSQL knowledge is required for this project.? the website software? has been modified multiple times.
Currently I have a price filter setup, so that you can choose from certain ranges to refine the search of products in a particular category.
Currently the ranges are created by taking the highest price of the products in that category and the lowest price, and making? 10 ranges from them.
for example if the lowest price of a product in a particular category was 13 dollars and the most expensive was 1600, the ranges would be ever 160 dollars.
$1 - $160,? $161 - $320,? $321 - $480 and so on..
I would like to revise the range creation parameters, so that it takes into account the medians of the price ranges.
I have come up with a much more detailed way for the site to calcuate the ranges.? Please see the attached spreadsheet for details.
EDITED -- NEW MUCH SIMPLIER METHOD THAT I WANT USE INSTEAD.? FORGET THE ATTACHED EXCEL FILE.
i realize now a much better way than the complex excel file.
you can make it easier. for example if there are 100 prices, just take the 100 prices, and sort them from lowest to highest, and Range 1 would be from the 1st member to the 10th member, Range 2 woudl be from the 11th to 20th, Range 3 would be from the 21st to 30th. and so on. much simplier.
if there are 500 prices, just take the 500 prices, and sort them from lowest to highest, and Range 1 would be from the 1st member to the 50th member, Range 2 woudl be from the 51st to 100th, Range 3 would be from the? 101st to 150th. and so on.
please revise your quote if you need to.
## Deliverables
It is simple, but may seem complex at first soI have created a spreadsheet which shows the calculations better.
Coumn A shows the prices that are in the example range.
Columns C & D show the actual price ranges that would result from the new solution of using the medians. (if you click on the cell you will see the excel formula used to calcuate the numbers)
Columns G & H, explain how to get the results in c & d
Columns J & K explain how to get the results in c & d in a different way