-
Administrator
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.
-
Senior Member
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.
-
Administrator
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
-
Administrator
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
-
Senior Member
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.
-
Senior Member
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.
-
Administrator
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
-
Senior Member
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.
-
Administrator
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
-
Forum Rules