Resources

[EricStratton]

Dice rolling page:

http://www.rpglibrary.org/software/securedice/index.php

Character creator:

http://www.pathguy.com/cg4.htm

Character modeler:

http://www.ugo.com/channels/comics/heromachine2/heroMachine2.asp

[EricStratton]

Officlal 4e errata site:

http://www.wizards.com/default.asp?x=dnd/updates

[EricStratton]

Another die rolling site, this one better for simple single rolls (thanks, Shiz and Ash):

http://www.wizards.com/dnd/dice/dice.htm

[Shiz]

Ash found it, but I'll take the credit!

[Sagar]

I can't get to that die rolling site from work, but I found one for my Pocket PC that works nicely.

[Shiz]

I cannot get to the character modelling site from my new job, but the dice sites are fine.

[Asharad]

Does anyone have another link to the pdf of the players handbook? I don't have mine with me and don't know what any of my abilities do.

[Sagar]

Young Heros Character Summary

Any corrections or suggestions for improvement would be appreciated.

[Lycos]

Baladir is a .5 Elf. :p

[Sagar]

Baladir is a .5 Elf. :p
And .5 smartsass
:lowrazz:

[Zyzzyx]

I like that summary chart, even just for my use.

Now, its something I should probably figure out, just missing it. What are the B/M/P and B/A/M columns? Is the first one Base/?/Party? I'm not getting the A or M though... I'm sure they're just too easy and I'm overlooking something.

[Lycos]

For those who might not be doing this. Here's a suggestion. I also use a file like this. It has all of Baladir's powers listed on it. It's just a text file. But when I use a power, I just copy directly from the file, and past it into the post. It saves me from typos and leaving out important information.

Just a thought.

[Zyzzyx]

Hmm... that'd be good. And less likely to attract attention when seen compared to the nice colorful D&D character sheets. ;)

[Sagar]

I like that summary chart, even just for my use.

Now, its something I should probably figure out, just missing it. What are the B/M/P and B/A/M columns? Is the first one Base/?/Party? I'm not getting the A or M though... I'm sure they're just too easy and I'm overlooking something.

Base / Magic / Party

Base / Armor / Magic

[EricStratton]

Resticky, please.

[Quervo]

I can provide any reference PDF's anyone would need, Most are between 15-20mb

I dont have a file share location but we can work something out if needed.

[Sagar]

Attached is a spreadsheet for rolling large quantities of random numbers at a time.

[Asharad]

Attached is a spreadsheet for rolling large quantities of random numbers at a time.


That's kinda awesome.

[Greebo]

Random Treasure Parcel Generator:
http://www.asmor.com/scripts/4eMagicItems/randomTreasure.php

[Sagar]

I talked about combat cards earlier today. I have been using the ones in the 4e books but they lack alot.

I made these today at lunch - they contain alot of the stuff I wish was on the "official ones".

I use them to keep track of stuff during battle. I put them in initiative order and just move through them one by one when I resolve combat.

[Greebo]

Awesome cards, Sagar!

[Quervo]

I like that... That would be usefull at a tabletop game as well

[Greebo]

For the DMS

This mocks up a spread sheet by which you can set up a table for tracking hps, surges, etc. The hidden rows are used to construct the final output on row 30. Example of the output:
InitPlayer/NPCDamageEffectsHPSSurgesDailiesHeals31Four-Armed Gargoyle72Mark-Grunther(2); Quarry: Aaron26Tiefon0-857-22Grunther0-11413-19Gerik0-679-18Aaron16-587-13Lyla0-747-10Sather16-5718-2/2

Update the yellow area, copy A30 and paste.

Note you *DO* need a - or something in empty cells or they shift over. Stupid vbulletin.

[Sagar]

Velly nice!

Show off :p

[Greebo]

Velly nice!

Show off :p

You inspired me :D

[EricStratton]

I added a little (well, a lot. I hate Excel) of logic to highlight the word "Bloodied" in red. If you want it do the following:

...thought about posting the steps to do it but forget it. Here's my file. If you want the code check out the (hidden on your spreadsheets) cells F17 thru F27.

[Greebo]

New revision - tracks APs, and if you flag monster = 1 it hides HPs in the output but lets you see HPs in the table

Eventually I plan to have it auto determine bloodied state for us.

[EricStratton]

New revision - tracks APs, and if you flag monster = 1 it hides HPs in the output but lets you see HPs in the table

Eventually I plan to have it auto determine bloodied state for us.
Ooh, good idea (re: auto track bloodied). If you don't work on it tomorrow, maybe I can do that while avoiding yet another terribly though up requirement I was given today.

[EricStratton]

Talking to Greebs, I know he's already made some updates to the spreadsheet but here's my current version. It auto detects Bloodied status and hides all the info for monster NPCs. It also auto inserts the dashes for the Effects, Dailies, and Heals columns so you don't have to. Just leave the cell blank and it'll get done.

InitPlayer/NPCDamageEffectsHPSSurgesDailiesHealsAPs22Cilene0-309--117Jagged13-3711--013Rend0-319--012Greebo0Concealment357--112Maw41Bloodied; ??????????8Mazirith15Grabbed by Zombie 13711Dimensional Thunder-18Zombie Rotters0-??????????3Sagar0-329-2/21

[EricStratton]

TODO:

1. Change Damage and HPS columns to be one column. I'm having too much trouble figuring out how many HPs ppl have left.

2. Auto detect "dead" and put that in the Effects column.

3. (Maybe) Column for "Currently Up in Init Order" so it'll auto Bold the name for me.

[Greebo]

I added 2 columns off site (to the left) to calculate bloodied and hps remaining for me, without showing them in the output.

But alternatively the base hp col could be off screen and the shown HP col would be base - dmg

Autodetect dying wouldn't suck

Auto sort by init order is something i intend to add too in a revamp - something where you fill out the info, its sorted and prepared first in an out of sight tab, then the output is presented for you where you fill it out

[Zyzzyx]

TODO:

1. Change Damage and HPS columns to be one column. I'm having too much trouble figuring out how many HPs ppl have left.
So display both in one column, or display only one of them? I rather like seeing both numbers, especially the HPs.

[EricStratton]

So display both in one column, or display only one of them? I rather like seeing both numbers, especially the HPs.
For me it'll probably be how I used to do it by hand: remaining_hps / total_hps

[Zyzzyx]

That works. I like that format.

Oh, and what about temp HP?

[Greebo]

That works. I like that format.

Oh, and what about temp HP?

You don't get any! So there! ;)

[Greebo]

Output test

InitCombatantDmgTHPA/PSurgesHealsEffectsDailies Used21Urvi4/3541130Bloodied; Stunned (FG1-2); Poison 5(se); Immobilized (se)20Ettercap Fang Guard 10????Mark - Urvi?20Ettercap Fang Guard 20????Mark - Urvi?17Ettercap Webspinner0????-?17Duma25/250180-6Jacoby Intar25/250182-6Rajkelleran Stormclaw24/240170Immobilized (se)3Tor Shere28/280190Immobilized (se)

Ok - Sagar, ES, I think you'll like this one. You fill out one page. You can put the PCs up top and leave them there forever. Current HPS, bloodied, dying are all auto calculated. SORTING is done automatically by the combination of initiative and init modifier.

Fill out the grid and copy the "output copy me" data. All the work is done on the 2nd tab out of sight.

ES I told you this would make you want to have my babies. :)

However, this may require Excel 2007 - let me know if you're using an older version and what results you get. Otherwise I'll test from home.

[EricStratton]

Very nice!

One minor thing that you can fix or not. If I can decipher all the IFs and VLOOKUPs I'll give it a shot. It doesn't correctly add "Dying" to the Effects for an NPC. Change the NPC column from 1 to 0 and "Dying" is added. The 1 in the Dying column is calculated correctly but not the text in the effect.

Maybe you did it on purpose tho. Altho for an NPC I'd rather it just said "Dead".

Either way - your Excel-fu is strong. Your master should be proud.

[Greebo]

I did it on purpose - an NPC at or below 0 hps is dead.

Revised version, compatible with older versions of Excel.

[Sagar]

That is AWESOME!

Now to get excel on my home computer so I can use it either place.

[Zyzzyx]

Cool... playing around a bit with it myself for the helluvit, and come up with a general question, perhaps not so related to this, but mechanics. Do temporary hitpoints bring a character out of bloodied status? Say JoeSchmoe is at 15/40hp, obviously bloodied, but he has 10thp. Would he be at 25/40, and thus not considered bloodied? Or do the THP act more like a ward, and when hit take damage from THP first? So could be bloodied, but with a 'protective shield' of a few THP.

[Greebo]

No, temp hps do not replace hps. THPs act like a ward as you described.

[Greebo]

I did it on purpose - an NPC at or below 0 hps is dead.

Revised version, compatible with older versions of Excel.

Reading back over this thread and realized this wasn't clear.

An NPC below 0 hps is dead, so I delete them from the grid completely, is what I should have said.

Now that said - now that this has gotten some use - what can be done to improve this?

I'm not gonna build in a "short rest/reset" function - that would require a bit too much coding. But that's the main thing I would wish for. ;)

[DinbinFanfoom]

I'll start using this next fight.

[Greebo]

InitCombatantDmgTHPA/PSurgesHealsEffectsDailies Used16Tor Shere40/40409/90-11Jacoby Intar29/35008/80-Song of Courage11Duma33/33005/70-Crown of Retaliation3Urvi39/490010/130-2Rajkelleran Stormclaw30/34006/70-Lightning breath

My latest version, if anyone wants.

[attriel]

InitCombatantDmgTHPA/PSurgesHealsEffectsDailies Used16Tor Shere40/40409/90-11Jacoby Intar29/35008/80-Song of Courage11Duma33/33005/70-Crown of Retaliation3Urvi39/490010/130-2Rajkelleran Stormclaw30/34006/70-Lightning breath

My latest version, if anyone wants.

whjat'd you change?

[Greebo]

I know I made some refinements to the effects column. Not sure what else over time - so figured I'd post the latest.