Warrior General Games

Sumatra too low

Originally posted by Wrath Of Conor
These rankings are very fluid. I trained and boosted one player on the Dynamo and didn't even spend his points and we're up 2 points since the OP.

I'll update the OP the morning of Game 1 to see how teams change.

***Script Idea*** for those that can write them. How hard would it be to write a script that puts a button on the league page that when clicked creates a text report at the bottom in the same format as the OP. Then that report can easily be copy/pasted into a forum post.

that would be a kick ass script

Originally posted by w_alloy
The biggest surprises for me on the list:

975.39 - 67 - Alpha - Halifax VROOM VROOM AEROPWANEs
973.78 - 65 - Alpha - East St. Louis Tire Fires
919.00 - 68 - Alpha - Boston Dogs

I thought Hali would be higher, I'm surprised to see ESL as high as they are with that average level, and lol Boston Dogs.

we have some nice builds on ESL. but i agree with your overall assessment

Originally posted by Wrath Of Conor
FYI, pabst wrote a script to generate a report at the bottom of league pages when you press a button.

http://userscripts.org/scripts/show/67651



wow you guys are fucking fast....

any way to make it more c&p friendly for when pasting it into a forum and the way it comes out? meaning like look here. http://goallineblitz.com/game/forum_thread.pl?thread_id=3734367

lol...tried to see if it'd paste in a happy manner...not c/p friendly. though, it fits into excel nicely.

Rank Team Players Avg Level Avg Value Eff Level
1 Chocolate Blaze 55 70 1052.15 74
2 Machu Picchu Hidden Dragons 55 73 1036.7 74
3 Ministry of Dotball 55 71 1030.9 74
4 Bonn Dynamo 55 70 1020.95 74
5 Valhalla . 54 68 1012.84 74
6 Lincoln Navigators 52 70 998.44 74
7 Dakar Dragons 54 70 996.65 74
8 Kansas City Rams 52 70 993.7 74
9 Warsaw Wrath 55 69 993.4 74
10 Providence Radicals 55 68 991.31 74
11 Halifax VROOM VROOOM AEROPWANEs 55 69 990.44 74
12 Three Kingdom Warriors 53 70 989.74 74
13 Marblehead Longhorns 52 70 988.18 74
14 Honolulu Hurricane Warriors 54 69 985.97 74
15 Santiago Benitos 55 70 981.95 74
16 East St Louis Tire Fires 55 66 980.78 74
17 Sparta Battle Chickens 53 69 978.31 74
18 Chicago Hedgehogs 54 69 977.85 74
19 The Drunken Addicts of Omertà 55 68 975.52 74
20 Estonian Wife Carriers 55 70 971.14 74
21 So Cal BDC 55 70 963.17 74
22 Tampa Bay Krakens 55 67 959.74 74
23 Queen City Black Cats 55 68 959.01 74
24 Surrey Fighting Stanleys 55 69 958.63 74
25 South Otto Fragile Porcelain Mice 55 70 953.86 74
26 Manila Warlords 55 68 952.3 74
27 Nashville Hounds 55 65 951.5 74
28 Sumatra Sea Hawks 55 69 949.2 73
29 Port Harcourt Playmakers 55 70 948.61 73
30 Korb Destroyers 54 69 944.34 73
31 Boston Dogs 55 70 937.33 73
32 Rosarica Titans of Fire 55 67 926.84 73

is that a glb forum non happy thing or can he somehow... fix that?

Nothing formats when you post it into GLB afaik

He could probably do something weird like add X amount of ---'s between each piece of data, calculated based on team name length to make all of them match up.(can he?)

Originally posted by r87
Nothing formats when you post it into GLB afaik

He could probably do something weird like add X amount of ---'s between each piece of data, calculated based on team name length to make all of them match up.(can he?)

You         just      need              awesome      forum      s          k         i           l         l      s

Originally posted by RandomBeast


lawl

Originally posted by r87
lol...tried to see if it'd paste in a happy manner...not c/p friendly. though, it fits into excel nicely.


That's what I've do with it. I created an Excel Macro to chop it up and format it the way I want.

Originally posted by Wrath Of Conor
That's what I've do with it. I created an Excel Macro to chop it up and format it the way I want.

any possible way of sharing said macro? lol

Originally posted by Whatsdafus
any possible way of sharing said macro? lol

Sub effectivelevel()
Cells.Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Cells.EntireColumn.AutoFit
Columns("B:B").Select
Selection.Cut
Columns("G:G").Select
Selection.Insert Shift:=xlToRight
Columns("D").Select
Selection.Cut
Columns("B:B").Select
Selection.Insert Shift:=xlToRight
Columns("C:C").Select
Selection.Cut
Columns("F:F").Select
Selection.Insert Shift:=xlToRight
Range("A1").Select
ActiveCell.FormulaR1C1 = "#"
Range("B1").Select
ActiveCell.FormulaR1C1 = "AvVal"
Range("C1").Select
ActiveCell.FormulaR1C1 = "AvLv"
Range("D1").Select
ActiveCell.FormulaR1C1 = "EfLv"
Range("E1").Select
ActiveCell.FormulaR1C1 = "Ct"
Columns("B:B").Select
Selection.Insert Shift:=xlToRight
Columns("D").Select
Selection.Insert Shift:=xlToRight
Columns("F:F").Select
Selection.Insert Shift:=xlToRight
Columns("H:H").Select
Selection.Insert Shift:=xlToRight
Columns("J:J").Select
Selection.Insert Shift:=xlToRight
Range("B1").Select
ActiveCell.FormulaR1C1 = "-"
Range("B1").Select
Selection.AutoFill Destination:=Range("B1:B33"), Type:=xlFillDefault
Range("B1:B33").Select
Selection.Copy
Range("D1").Select
ActiveSheet.Paste
Range("F1").Select
ActiveSheet.Paste
Range("H1").Select
ActiveSheet.Paste
Range("J1").Select
ActiveSheet.Paste
Cells.Select
Cells.EntireColumn.AutoFit
Range("A1:K33").Select
Application.CutCopyMode = False
Selection.Copy
Range("C2:K33").Select
Application.CutCopyMode = False
Selection.Sort Key1:=Range("C2"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Columns("C:C").Select
Selection.NumberFormat = "0.00"
Range("A1:K33").Select
Selection.Copy
End Sub

Don't know how to really share macros, but I went to edit it and just copy and pasted the text. This works for me if I copy the report (including header row) from the league page and paste as text into A1. then I run the macro.