Twilightpeaks.net
TP.net => The Great Beyond (OOC) => : DM B May 04, 2009, 08:02:57 PM
-
I'm announcing a DO template competition.
The goal is for one of you players to create a new and updated DO template that we'll begin using as soon as its approved and ready.
The winner gets 20RP, while any honorable mentions will get 5RP each.
The template should ideally be based upon the old and be aimed at making things easy for the DM...it must also be in Word format (I'll also accept an Excel version of the same template is one is made), but other than that you have a free run of the place.
-
What is the most time-consuming procedure for DM when working with the current DO?
-
My guess is having to look things up.
-
Where do we send our proposals? Do we upload it in the forums, or send an email with the DO attached to the DMs? Also is there any deadline?
-
Where do we send our proposals? Do we upload it in the forums, or send an email with the DO attached to the DMs? Also is there any deadline?
E-mail.
No deadline set yet, but do try to hand them in within a few weeks.
-
Any news on this front? I'd like to implement a winning template on my turn as quickly as possible, so for now, I've just been jutting down my notes on a pad next to my computer, ready to fill in.
Should I expect a template, or should I deliver this turns DO in the old style?
-
Old style; I've yet to receive very many entries into the competition.
-
I am going to send one submission by Friday. Most of it is already done, but it needs some changes.
-
Cool
-
As Bjorn and Jon are busy, I don't know if anyone else has sent them an alternate template, and I'm bored, I thought I'd post the alternate template I did to see what people thought.
In retrospect it would work (much) better as excel but I kept it in word as I was modifying the existing DO template... If the layout, etc work then I'll try converting it to an excel version.
Let me know what you think about the layout and approach.
hopefully the file zipped properly...
-
It's seems quite user-friendly to me
-
It's seems quite user-friendly to me
Mine? If other people like it and its easier for Bjorn/ Jon I'll make an excel version which adds stuff up and think up some user notes.
I'm wondering about building something for the DC - anyone know a good dice roller that can be built into excel?
-
I'm wondering about building something for the DC - anyone know a good dice roller that can be built into excel?
"RANDBETWEEN(1,20)" + MODIFIERS. The functionality is obvious.
-
You can create a macro to do it.
The problem with RANDBETWEEN is that it evaluates everytime any cell evaluates, unless you turn Auto-Calculation off. Auto-Calculation off though is not particularly useful for an excel DO since you really want to see things auto update.
-
Try this VB code:
Just hit "ALT+F11"
On the left, create a new module and past this into the new module.
Function RollDice(DieFace)
Randomize
Dim NextRow As Long
RollDice = Int(Rnd() * DieFace) + 1
End Function
-
It's seems quite user-friendly to me
Mine?
yours
-
Ok, I've tried an excel version of the template I built.
The DC calculator and dice roller aren't done yet - I'm not sure how to mechanically go about building them and will probably need help from one of the excel guru's (assuming that Bjorn/Jon like the sheet anyway). I'm thinking that we'll need the DM to say 'yes/no' to advantage and hardiness, but otherwise the sheet should be able to link into the P&H for much of the info - one problem will be it knowing what holding to look at - we may need to split out each holding type as a separate action for rule/contest actions.
Let me know if anything is missing / unclear.
The idea in the column width and merged cells btw is so that you can copy the P&H info on your action directly underneath your action fluff to reduce the need for Bjorn/Jon to have to check between the spreadsheets.
-
just gave a quick glance...
seems quite useful to me...e.g. the excel can help Bjorn and Jon to more easily calculate GB and RP remaining
-
I had hoped to build in at least a DDC calculator, but I think that it will need Bjorn/Jon to at least tick advantage and hardiness boxes - and someone to build look-up tables and so on.
Plus some stuff affects the die-roll, and some the DDC - mathematically there is no difference to the chance of success, but it complicates the layout of the roll.
Basically I tried to recreate the DO on page 1, build the action table on page 2 to identify all modifiers for any action chosen, and the look-up table info on the the other pages was lifted from the P&H.
One obvious flaw is that you'd have to put your own holdings in the top row of the rows pasted from the P&H when copying the rows from the P&H below your action.
Also I don't know the look-up for the admin action success - it should be doable to make that a tick box and auto-calculate formula, although I'd probably need to split out a column in the minion table for admin skill (including feat, ability score, etc bonuses).
-
Something that is notoriously difficult is getting a random engine thats actually random. Add to the fact that most d20's are somewhat low quality and trend towards the values 11 and 12 and its impossible to match the die roll with a randomizer thats electronic.
Also, if you kill off Bjørn's dice rolls, are you sure you are doing him a favor? ;D
I mean, rolling dice is fun. 8)
-
Something that is notoriously difficult is getting a random engine thats actually random. Add to the fact that most d20's are somewhat low quality and trend towards the values 11 and 12 and its impossible to match the die roll with a randomizer thats electronic.
Also, if you kill off Bjørn's dice rolls, are you sure you are doing him a favor? ;D
I mean, rolling dice is fun. 8)
One of the things I love more, as DM