Aug 28 2023 07:02 AM
Aug 28 2023 07:32 AM
@Jan Karel Pieterse The project below was scored on 120 points. I need to convert 59/120 to a 100 point scale. Some projects were scored out of 95 points, etc. I'm thinking a data table would do this for me (I did the below conversion manually) but haven't figured it out yet. Thank you for any assistance you can provide!
Aug 28 2023 07:42 AM
I'm trying to convert various scoring scales to a common 100 point scale. I can do it manually, line by line, but can't find a formula to do it for me. Ideas? Thank you!
Your question is intriguing, in part because there are so many different scales, to begin with, but also various scenarios when, for example, there's a tie when you reach the normal max. One would need to know the rules for this conversion under all circumstances. Here are some scenarios I came up with right off the bat in trying to do this.
A single formula could be written to take account of the nature of the game, some sexy IF/THEN conditional, but let's begin with your responses to what I've written already.
Can I ask why you're asking for this to begin with? As I noted above, it's an intriguing question, but part of the intrigue is that games aren't scored within a consistent conceptual framework. And as I write that, it occurs to me that you may not be talking of scores in games, per se (!!!), so maybe I've taken an assumption that isn't applicable to begin with. So please DO tell us what kinds of scores you're talking an about.
And, once that question has been answered, since you are able to do it manually, line by line, give us the examples. I've written some from my hypothetical trying to standardize ping pong and scrabble, but that's what raised the questions above. Your actuals--since you've done them--may just need to to translated to Excel.
Aug 28 2023 07:45 AM
Aug 28 2023 07:49 AM
Aug 28 2023 09:00 AM - edited Aug 28 2023 09:02 AMSolution
I was hoping I could find a way to do this more quickly given that I have multiple projects with various totals to convert.
Easily done: I suggest a table that shows the max available for each project, e.g.,
and then a lookup formula that accesses the table
See the attached example