SeeAMoose wrote:Hey, I got your message L&S. The answer isn't macros but instead mail merges with Word and excel together. I'll be happy to do a tutorial on those as well, but I'll need a better idea of what you need from it first.
I will post an example here so the others would see it too, It won't spoil anything.
I want to turn this (cropped Excel table):
Into this:
Code: Select all
Character Sheets:
[tabs][tabs:Bada Boom]
[color=#004000]Bada Boom[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Bouncing Burt]
[color=#BF0080]Bouncing Burt[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Dies-to-a-Mine]
[color=#3366cc]Dies-to-a-Mine[/color] Level 0, XP: 1.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Finds Mines]
[color=#BF00FF]Finds Mines[/color] Level 0, XP: 2.
Inventory: 9 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Flags Mines]
Flags Mines Level 0, XP: 3.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment[/tabs]
[tabs][tabs:Goska Bluey]
[color=#FF0000]Goska Bluey[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:No-Legs]
[color=#990066]No-Legs[/color] Level 0, XP: 1.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Oh See That Shiny]
[color=#8040FF]Oh See That Shiny[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Peg-leg Sue]
[color=#008080]Peg-leg Sue[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment[/tabs]
[tabs][tabs:See Four]
[color=#FF9600]See Four[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Step-and-Boom]
Step-and-Boom ([color=#FFFF00]yellow[/color]) Level 0, XP: 1.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Stumbles around]
[color=#00BFFF]Stumbles around[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment
[tabs:Tries-and-Dies]
[color=#A0A0A0]Tries-and-Dies[/color] Level 0, XP: 2.
Inventory: 10 / 10 flags
Hammerspace: 0 coins, no equipment[/tabs][/quote]
So when I copy-paste it into the forum, when creating an update, the players would see:
And so I don't have to update posts and database twice, only once and could rely on that merging thingy you are saying.
It need not to be complex, a simple 1 cell into 1 data field would work, it costs me nothing to create the appropiate columns in my Excel sheet. I said macros because I remember filling templates with macros, although dont know how it goes in Word/Excel. Sorry if it confused you.
It would go something like this in pseudo code (in my mind):
► Show Spoiler
Code: Select all
>PRINT "[tabs]"
>FOR i=1 TO i= NUMBER_OF_PLAYERS DO LOOP
> PRINT "[tabs: $DATA (Column 1: Row i) ] \n"
> PRINT "Level: $DATA (Column 2: Row i), XP : $DATA (Column 3 : Row i) \n"
> // ... and so on for every field ...
> END LOOP
>PRINT "[/tabs]"
It's a good idea and it will be possible for people to pick up and run through the old lessons as they go, but a lot of the fun was doing it as a group and seeing what everyone came up with for each lesson. There was some really creative stuff in there that came out that I think we'd miss if people just did it on their own...
