| Discussion Forum: Thread 283003 |
|
 |
| | | Author: | bajman  | | Posted: | Jan 31, 2021 18:27 | | Subject: | Wanted List percent formula error | | Viewed: | 83 times | | Topic: | Suggestions | | Status: | Open | | Vote: | [Yes|No] | |
|
| The formula for the Wanted List Percentage does not properly calculate the percentage
of "HAVE" parts compared to the "TOTAL" Parts. Should the % shown be the amount
of "Have" pieces vs the total number of "Wanted" pieces, or is it intended to
provide some other detail? It's not showing the percent of LOTS completed,
and its not showing the percent of Parts with Have qty equaling the Want qty.
The formula seems to be working is a convoluted way, combining the percentage
for Want/Have and the percentage of Lots with any Have parts, and the total number
of lots.
Example #1 to illustrate the issue:
Wanted list with TWO lots.
Lot #1, Want 100, Have 10 (This is 10% of the want value)
Lot #2, Want 900, Have 0 (This is 0% of the want value)
The Percentage bar should show 1% (10 of 1,000), but the formula produces 5%.
Example #2 to illustrate the issue:
Lot #1, Want 100, Have 0 (This is 0% of the want value)
Lot #2, Want 900, Have 900 (This is 100% of the want value)
The percentage bar should show 90% (900 of 1,000), but the formula produces 50%.
Example #3 to illustrate the issue:
Lot #1, Want 100, Have 0 (This is 0% of the want value)
Lot #2, Want 450, Have 900 (This is 50% of the want value)
The percentage bar should show 45% (450 of 1,000), but the formula produces 25%.
In all examples, the percentage shown does not equate to anything tangible, real
or useful, and if very misleading
Unfortunately, this misinformation has led to many, many lost hours and much
frustration.
Please work to correct the formula, so that the percentage bar is a real, actual,
useful representation of the data.
If by some odd situation, the bar is performing as intended, please clarify its
intended function.
Thank you,
Brandon
|
|
|
|
| | | | | |
| | | | | Author: | brickedboi | | Posted: | May 13, 2024 02:28 | | Subject: | Re: Wanted List percent formula error | | Viewed: | 36 times | | Topic: | Suggestions | |
|
| In Suggestions, bajman writes:
| | The formula for the Wanted List Percentage does not properly calculate the percentage
of "HAVE" parts compared to the "TOTAL" Parts. Should the % shown be the amount
of "Have" pieces vs the total number of "Wanted" pieces, or is it intended to
provide some other detail? It's not showing the percent of LOTS completed,
and its not showing the percent of Parts with Have qty equaling the Want qty.
The formula seems to be working is a convoluted way, combining the percentage
for Want/Have and the percentage of Lots with any Have parts, and the total number
of lots.
Example #1 to illustrate the issue:
Wanted list with TWO lots.
Lot #1, Want 100, Have 10 (This is 10% of the want value)
Lot #2, Want 900, Have 0 (This is 0% of the want value)
The Percentage bar should show 1% (10 of 1,000), but the formula produces 5%.
Example #2 to illustrate the issue:
Lot #1, Want 100, Have 0 (This is 0% of the want value)
Lot #2, Want 900, Have 900 (This is 100% of the want value)
The percentage bar should show 90% (900 of 1,000), but the formula produces 50%.
Example #3 to illustrate the issue:
Lot #1, Want 100, Have 0 (This is 0% of the want value)
Lot #2, Want 450, Have 900 (This is 50% of the want value)
The percentage bar should show 45% (450 of 1,000), but the formula produces 25%.
In all examples, the percentage shown does not equate to anything tangible, real
or useful, and if very misleading
Unfortunately, this misinformation has led to many, many lost hours and much
frustration.
Please work to correct the formula, so that the percentage bar is a real, actual,
useful representation of the data.
If by some odd situation, the bar is performing as intended, please clarify its
intended function.
Thank you,
Brandon
|
Hi Brandon, have you been given an answer to your query or have any further info?
I was just thinking about this tonight as I have many partial sets and want to
know which to prioritize to complete but it's hard to tell what the completion
percentage bar indicates in wanted lists. Brickedboi.
|
|
|
| | | | | | | | | |
| | | | | | | Author: | yorbrick | | Posted: | May 13, 2024 03:44 | | Subject: | Re: Wanted List percent formula error | | Viewed: | 28 times | | Topic: | Suggestions | |
|
| | | Hi Brandon, have you been given an answer to your query or have any further info?
I was just thinking about this tonight as I have many partial sets and want to
know which to prioritize to complete but it's hard to tell what the completion
percentage bar indicates in wanted lists. Brickedboi.
|
Bricklink averages things like this in strange ways. They do something similar
for average sales prices too. They do a calculation per lot, then average that
result over all lots irrespective of the size of the lots.
See here:
https://www.bricklink.com/message.asp?ID=1339636
It is often best to do the calculations by hand and ignore BL's statistics.
|
|
| | | | | |
| | | | | Author: | knxguy11340 | | Posted: | May 14, 2024 00:04 | | Subject: | Re: Wanted List percent formula error | | Viewed: | 33 times | | Topic: | Suggestions | |
|
| It appears the formula is taking the total percentage and dividing by the number
of lots.
Example #1: (10 + 0)/2 = 5
Example #2: (0 + 100)/2 = 50
Example #3: (0 + 50)/2 = 25
It IS showing the percentage of LOTS but not PARTS which is basically useless
information as LOTS are not comparable in terms of PARTS quantity.
|
|
|
|
|
|
USA, Washington
Canada, Ontario
United Kingdom, England