Results 1 to 4 of 4

Thread: Suggestion to enhance MM Table

  1. #1
    Senior Member MarkRBright's Avatar
    Join Date
    Oct 2011
    Location
    West Yorkshire, UK
    Posts
    238

    Lightbulb Suggestion to enhance MM Table

    Just a thought but how about this for an idea.

    In the Mega Milestones table (in Main Stats and User Milestones - but also in SubProjects if you felt the need) you could colour code the "Many" figure in any row where it constitutes a Maxwell, and used a paler shade of the same colour where it is within a few (I suggest 2) of a Maxwell. This would help explain to people why they have a Maxwell, as well as encourage them to go for more. Currently in order to find out if a Maxwell is acheivable you need to go through each MM in the table and select it to see the highest acheivers. I little bit of help with this would I think be a great idea, as many people may not realise they are close to a Maxwell otherwise.

    You could take this further with the MiRB/TeraMiRB column by colour codeing the RankP figure where it constitutes a TeraMiRB, and use a paler colour for a MiRB.
    I would suggest using a strong and pale colour for TeraMiRB and MRB respectively as when you have a TeraMiRB you also have a MiRB for that MM. You could also do the same for TMiRBs and CMiRBs (and their Teras) by colour coding the RankT and RankC columns if you ever decide to implement that earlier suggestion.

    You could colour the Maxwell, MiRB and TeraMiRB (CMRB and TMiRB too!) figures somehow to link the two and make it more obvious what the shading represents.
    Like I said, just a thought but I think it could look good too.

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,469
    Blog Entries
    13
    I can see the value in it, but it's a LOT more work that it actually sounds. I would mean database changes to store the limits for each and such, then perl script changes to populate those and then the PHP/HTML changes.

    My design skills aren't my forte either I'm afraid.

  3. #3
    Senior Member MarkRBright's Avatar
    Join Date
    Oct 2011
    Location
    West Yorkshire, UK
    Posts
    238
    Forgive me if I am oversimplifying - or just completely wrong - but for the Maxwells, you would only to need to establish what the current highest value was for each MM once per day, and keep that number, perhaps alongside another that was 10% less (just for convenience). This seems like a fairly simple and very finite array rather than a database change, but then I haven't programmed for years now. Once you have these for the day, then all you would need to do when drawing the table would be to compare each RankP number with the corrosponding Maxwell value and highlight one way if it's bigger, ELSE if it's greater than the 90% value then highlight another way. In other words it is not a change that needs to be done for each user as such, just build an array and compare values against it.
    For the MiRB and TeraMiRB, you would need to compare the RankP with 100, and failing that 1000, to decide if or how to highlight the Many field in a similar way. You already have that information to hand for each row.
    Now I know I am being flippant when I just say "Highlight" like it's the easiest thing in the world, but I am half hoping that someone else out there reading this will offer to help you do it

  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,469
    Blog Entries
    13
    Quote Originally Posted by MarkRBright View Post
    Forgive me if I am oversimplifying - or just completely wrong - but for the Maxwells, you would only to need to establish what the current highest value was for each MM once per day, and keep that number, perhaps alongside another that was 10% less (just for convenience).
    ^ is a database change. I do of course calculate this number overnight and use it to calculate the maxwells, but I don't store it anyway, it would have to be in the table that I hold the mm's in which therefore requires a database change

    Not that it's that difficult, and I'll try to keep it in mind, but very little time to do this right now. Full blown migration of my companies SAP Financial systems to a cloud based SAP system is taking up way too much time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •