Evaluating locations based on data?
Hello, I'm supposed to program a tool that calculates and evaluates certain locations based on certain data (distance, water price, gas price). I have no idea how to write the formula for it, though.
My current approach looks something like this
Rating = (WeightingDistance * Distance) / (WeightingPriceWater * PriceWater) / etc….
Is there a better way to do this? What if I have a value that's better when it's higher?
e.g.
Price = Better if lower
Area = Better if higher
Using my current formula, I get a score and I suspect the lower it is, the better the location.
(1 votes)
Loading...
Libre Office –> spreadsheet
Enter the values, set the formulas and already have the result.
Conditions , Rules,etc can also be defined per cell as per column. With this experience you can also get to the shapes you need to create.
For me, this would be done in 10 minutes. I could make such a thing you don’t ask, but I don’t do that for free.