Results 1 to 39 of 39

Thread: There is no reward for doing well in SubProjects

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    It does have a Bigint column sequence that it orders on so I can control the sequence and I already ran it manually. May need a little tweaking potentially.

  2. #2
    Senior Member MarkRBright's Avatar
    Join Date
    Oct 2011
    Location
    West Yorkshire, UK
    Posts
    238
    OK that's not quite what I was expecting but it's a lot better and a lot less random. If you are going to mix up the Projects with the Sub-projects though could you easily force it so that the Projects values always came before the Sub Projects?
    e.g. Always make the 50k's come before the Sub50k's etc. It would just be a lot neater.

  3. #3
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    Not sure what you mean? I didn't think there was anywhere where I display project mm's and subproj mm's together?? I break them down into 4 categories

    I - Individual
    O - Other (I could now lump these with the I's easily enough)
    S - Subproj
    T - Team

  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    Not sure what you mean? I didn't think there was anywhere where I display project mm's and subproj mm's together?? I break them down into 4 categories

    I - Individual
    O - Other (I could now lump these with the I's easily enough)
    S - Subproj
    T - Team

  5. #5
    Senior Member MarkRBright's Avatar
    Join Date
    Oct 2011
    Location
    West Yorkshire, UK
    Posts
    238
    Sorry for not being clearer, and I am now worried that we have been talking at cross purposes.
    I was referring to the display on Userbycpidmilestones.
    You tend to mix up the Subproject level MMs with the Project level ones (e.g. 100ks, then sub100ks, then 50ks then sub50ks - though not always that way round).
    I would favour showing all the Project ones, then all the Subproject ones. Preferably in descending order as now.
    The list I provided earlier goes slightly further by listing all the Project related Level MMs first, followed by the Bok type ones, then the Top ranks, this is then followed by all the Subproject related MMs, Subbok related level MMs, SubBok type ones, then SubTops, and all of that is then followed by general ones and then finally the sometimes-you-have-them-sometimes-you-don't Clanks and SubClanks. Och! It's easier to show you the list again. Note that I have put in some blank lines for clarity only.

    Projects
    1B's
    500M's
    250M's
    100M's
    50M's
    25M's
    10M's
    5M's
    2.5M's
    1M's
    750k's
    500k's
    250k's
    100k's
    50k's
    25k's
    10k's
    1k's

    Bozos
    Gibsons
    TeraBoks
    Boks
    Trigggls

    #1 Ranks
    Top10 Ranks
    Top100 Ranks
    Top1000 Ranks

    Subprojects
    sub1B's
    sub500M's
    sub250M's
    sub100M's
    sub50M's
    sub25M's
    sub10M's
    sub5M's
    sub2.5M's
    sub1M's
    sub750k's
    sub500k's
    sub250k's
    sub100k's
    sub50k's
    sub25k's
    sub10k's
    sub1k's

    SubBozos
    subGibsons
    subTeraBoks
    subBoks
    subTrigggls

    SubTop10's
    SubTop100's

    SquarePants
    Vaios
    Maxwells
    TeraMiRB's
    MiRB's
    Clanks
    subClanks

    That seems most logical to me but it's only one opinion amongst many, and I'll happily deal with whatever appears.

  6. #6
    Senior Member MarkRBright's Avatar
    Join Date
    Oct 2011
    Location
    West Yorkshire, UK
    Posts
    238
    Sorry for not being clearer, and I am now worried that we have been talking at cross purposes.
    I was referring to the display on Userbycpidmilestones.
    You tend to mix up the Subproject level MMs with the Project level ones (e.g. 100ks, then sub100ks, then 50ks then sub50ks - though not always that way round).
    I would favour showing all the Project ones, then all the Subproject ones. Preferably in descending order as now.
    The list I provided earlier goes slightly further by listing all the Project related Level MMs first, followed by the Bok type ones, then the Top ranks, this is then followed by all the Subproject related MMs, Subbok related level MMs, SubBok type ones, then SubTops, and all of that is then followed by general ones and then finally the sometimes-you-have-them-sometimes-you-don't Clanks and SubClanks. Och! It's easier to show you the list again. Note that I have put in some blank lines for clarity only.

    Projects
    1B's
    500M's
    250M's
    100M's
    50M's
    25M's
    10M's
    5M's
    2.5M's
    1M's
    750k's
    500k's
    250k's
    100k's
    50k's
    25k's
    10k's
    1k's

    Bozos
    Gibsons
    TeraBoks
    Boks
    Trigggls

    #1 Ranks
    Top10 Ranks
    Top100 Ranks
    Top1000 Ranks

    Subprojects
    sub1B's
    sub500M's
    sub250M's
    sub100M's
    sub50M's
    sub25M's
    sub10M's
    sub5M's
    sub2.5M's
    sub1M's
    sub750k's
    sub500k's
    sub250k's
    sub100k's
    sub50k's
    sub25k's
    sub10k's
    sub1k's

    SubBozos
    subGibsons
    subTeraBoks
    subBoks
    subTrigggls

    SubTop10's
    SubTop100's

    SquarePants
    Vaios
    Maxwells
    TeraMiRB's
    MiRB's
    Clanks
    subClanks

    That seems most logical to me but it's only one opinion amongst many, and I'll happily deal with whatever appears.

  7. #7
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    ah, it's wrong on that page. I'll look into fixing that.

    Each project mm basically has the weighting in that bigint as the same as the mm # it needs to be greater than. i.e. 99999 for the 100k's and the subprojects are the same.

    But I never meant to mix them up on any one page

  8. #8
    Senior Member MarkRBright's Avatar
    Join Date
    Oct 2011
    Location
    West Yorkshire, UK
    Posts
    238
    That page is probably the most important for MM spreadsheeters as it's the only place where you can easily extract them all. I don't really mind as I said, as I can work with whatever with a bit of sorting, as long as that page remains! But if you ever get round to updating it, please bear this conversation in mind.
    Thanks again.

  9. #9
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,596
    Blog Entries
    13
    How about I create a new page just for the full list of MM's ?

Posting Permissions

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