Warrior General Games

Originally posted by Wrath Of Conor
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.

what column am i pasting this macro into?

nvm

Originally posted by Whatsdafus
what column am i pasting this macro into?

Its' not as easy as pasting into a column. It might even be easiest if you record your own macro. that way you can make it the way you want to look, etc. It may take some trial and error though. Even if you've never created macros they're very easy in Excel.

1. copy and paste the generated report, make sure to "paste as text" in Excel otherwise it will cram everything into the same cell.
2. click on 'tools', then 'macros', then 'record new macro'
3. You have to give it a name, give a generic name like efflevel (has to be no spaces, etc), you can assign it a shortcut key. I like doing this to make it easier to execute once done. Pick 'e' for effective level, for example. you'll want to store it in your 'Personal macro workbook' so it is accessible in any sheet you edit.
4. Once you click 'OK' you'll a small popup window with a square button (stop button). you can ignore this window for now. So, just go to your data and format it the way you want, cutting and inserting columns, retyping things, sorting or whatever you want to do, etc.
5. When you are all done click the stop button on that small window that popped up previously.
6. Test your macro. Open a whole new sheet and paste as text the report from GLB again. Then do ctl+e (if that is the shortcut you gave it) and it should format it the way you did before.

I would prefer to have a macro button that I can push which electrocutes you into providing us with forum entertainment. All that other stuff seems like work.

Originally posted by RandomBeast
Originally posted by tautology

Edited by tautology on Feb 1, 2010 03:16:52
Edited by tautology on Feb 1, 2010 03:16:16
Edited by tautology on Feb 1, 2010 03:15:01




That does it. You are now officially on my list.

Originally posted by tautology
Originally posted by RandomBeast

Originally posted by tautology


Edited by tautology on Feb 1, 2010 03:16:52
Edited by tautology on Feb 1, 2010 03:16:16
Edited by tautology on Feb 1, 2010 03:15:01




That does it. You are now officially on my list.



The list is constantly getting edited, it would seem

Originally posted by JuniorMcSpiffy
The list is constantly getting edited, it would seem



I snickered.

twas funny

Originally posted by JuniorMcSpiffy
Originally posted by tautology

Originally posted by RandomBeast


Originally posted by tautology



Edited by tautology on Feb 1, 2010 03:16:52
Edited by tautology on Feb 1, 2010 03:16:16
Edited by tautology on Feb 1, 2010 03:15:01




That does it. You are now officially on my list.



The list is constantly getting edited, it would seem



Award yourself some style points, spiffy

Go Korb!

Originally posted by w_alloy
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

my bad

A few hours after game 1...

Rank Team Players Avg Level Avg Value Eff Level
1 Chocolate Blaze 55 71 1062.41 74
2 Machu Picchu Hidden Dragons 55 73 1046.77 74
3 Ministry of Dotball 55 71 1037.58 74
4 Valhalla . 55 69 1021.77 74
5 Bonn Dynamo 55 70 1016.14 74
6 Dakar Dragons 54 70 1007.14 74
7 Providence Radicals 55 69 1006.2 74
8 Halifax VROOM VROOOM AEROPWANEs 54 70 1005.79 74
9 Lincoln Navigators 55 70 1004.07 74
10 Warsaw Wrath 55 70 1003.86 74
11 Honolulu Hurricane Warriors 55 70 997.62 74
12 Three Kingdom Warriors 53 70 995.66 74
13 Kansas City Rams 52 70 995.52 74
14 East St Louis Tire Fires 55 67 994.51 74
15 Sparta Battle Chickens 55 70 992.55 74
16 Marblehead Longhorns 54 70 991.25 74
17 Santiago Benitos 55 70 990.57 74
18 Chicago Hedgehogs 54 70 988.54 74
19 The Drunken Addicts of Omertà 55 69 987.31 74
20 Estonian Wife Carriers 55 71 986.53 74
21 Nashville Hounds 55 67 980.91 74
22 Queen City Black Cats 55 69 972.94 74
23 Tampa Bay Krakens 55 68 967.63 74
24 So Cal BDC 55 70 967.49 74
25 Surrey Fighting Stanleys 55 69 962.57 74
26 South Otto Fragile Porcelain Mice 55 71 961.32 74
27 Manila Warlords 55 69 960.33 74
28 Port Harcourt Playmakers 55 70 958.92 74
29 Korb Destroyers 55 70 957.56 74
30 Sumatra Sea Hawks 55 69 955.06 74
31 Boston Dogs 55 71 948.26 73
32 Rosarica Titans of Fire 55 67 939.36 73

A few hours after game 1...

"Rank" indicates the rank of effective level according to the script. The teams are ordered below in the same order as WoC's original rankings from earlier in the preseason

Alpha
2 Machu Picchu Hidden Dragons 55 73 1046.77 74
12 Three Kingdom Warriors 53 70 995.66 74
9 Lincoln Navigators 55 70 1004.07 74
6 Dakar Dragons 54 70 1007.14 74
8 Halifax VROOM VROOOM AEROPWANEs 54 70 1005.79 74
14 East St Louis Tire Fires 55 67 994.51 74
16 Marblehead Longhorns 54 70 991.25 74
18 Chicago Hedgehogs 54 70 988.54 74
19 The Drunken Addicts of Omertà 55 69 987.31 74
22 Queen City Black Cats 55 69 972.94 74
27 Manila Warlords 55 69 960.33 74
29 Korb Destroyers 55 70 957.56 74
25 Surrey Fighting Stanleys 55 69 962.57 74
30 Sumatra Sea Hawks 55 69 955.06 74
28 Port Harcourt Playmakers 55 70 958.92 74
31 Boston Dogs 55 71 948.26 73

Zeta
1 Chocolate Blaze 55 71 1062.41 74
3 Ministry of Dotball 55 71 1037.58 74
5 Bonn Dynamo 55 70 1016.14 74
4 Valhalla . 55 69 1021.77 74
13 Kansas City Rams 52 70 995.52 74
10 Warsaw Wrath 55 70 1003.86 74
11 Honolulu Hurricane Warriors 55 70 997.62 74
7 Providence Radicals 55 69 1006.2 74
20 Estonian Wife Carriers 55 71 986.53 74
15 Sparta Battle Chickens 55 70 992.55 74
17 Santiago Benitos 55 70 990.57 74
26 South Otto Fragile Porcelain Mice 55 71 961.32 74
21 Nashville Hounds 55 67 980.91 74
23 Tampa Bay Krakens 55 68 967.63 74
24 So Cal BDC 55 70 967.49 74
32 Rosarica Titans of Fire 55 67 939.36 73

Originally posted by TrevJo
4 Valhalla . 55 69 1021.77 74

still got a lot of boosting to do

15 Sparta Battle Chickens 55 70 992.55 74
16 Marblehead Longhorns 54 70 991.25 74

when you look at the scoreline of todays game, you really start to wonder what the difference is!

It's me.

I'm terrible.