I was wondering the same thing. I put one together but it's terrible. (I have next to zero skill with Excel.)
Any chance someone has cooked up a handy dandy spreadsheet for dealing with Caravans?
Thanks!
Well, I put together a new one that I like a good bit more. It still has some problems (I couldn't get the consumption formula to calculate the effect of cooks and guides), but will do in a pinch. Happy to share it and open it up for editing and refinement if folks would like.
|
Well, I put together a new one that I like a good bit more. It still has some problems (I couldn't get the consumption formula to calculate the effect of cooks and guides), but will do in a pinch. Happy to share it and open it up for editing and refinement if folks would like.Any chance someone has cooked up a handy dandy spreadsheet for dealing with Caravans?
Thanks!
I'd be down with that.
| 1 person marked this as a favorite. |
Well, hopefully this will work. I uploaded an editable copy to Google Docs. As I said, there are a couple issues I have with it. First, the Consumption total on the first sheet does not take into account Travelers' jobs. There may also be a better way to organize some things. Hopefully if anyone makes improvements/refinements to it, they'll post a link to the new version here.
|
|
| 1 person marked this as a favorite. |
Well, I put together a new one that I like a good bit more. It still has some problems (I couldn't get the consumption formula to calculate the effect of cooks and guides), but will do in a pinch. Happy to share it and open it up for editing and refinement if folks would like.I'd be down with that.
Well, hopefully this will work. I uploaded an editable copy to Google Docs. As I said, there are a couple issues I have with it. First, the Consumption total on the first sheet does not take into account Travelers' jobs. There may also be a better way to organize some things. Hopefully if anyone makes improvements/refinements to it, they'll post a link to the new version here.
That's a great start, much better than mine where I attempted to cram it all onto one sheet.
One thing I added was a Consumption column on the Traveler's tab. Each traveler (not counting a certain NPC) counts as 1 consumption, further, it allows you to put in negative numbers of consumption for the cooks.
Ah, that's a good and simple solution. I was trying to make it overly complicated with a long formula. Thanks!
|
|
Ah, that's a good and simple solution. I was trying to make it overly complicated with a long formula. Thanks!
Man, Google Sheets do not like negatives in formulas, but I was able to c/p it in from normal excell, so now it automatically calculates in the consumption bonus for Cooks.
Next question, do one for Scouts as well? or have an optional column for'em?
I was wondering about that the other day and was leaning towards a separate row. They have two potential roles they can fill, with two different effects on consumption rates.
| 1 person marked this as a favorite. |
Here is a rough one I've been working out for my group. Don't have all the equations in it, but it's formatted like the official sheet. Have at it!
I took one of the caravan sheets someone started and fleshed it out. let me know what you think. or if you see any errors.
The Complete Caravan Sheet v1.1.
I am working on a version with the 3rd party Trade Roots Expanded Caravan rules also.
I took one of the caravan sheets someone started and fleshed it out. let me know what you think. or if you see any errors.
The Complete Caravan Sheet v1.1.
I am working on a version with the 3rd party Trade Roots Expanded Caravan rules also.
Very cool. I'm planning on using the expanded rules and that was the first question I had about the spreadsheet. That being said, could it be made flexible enough to accommodate additional items such as other wagon types, more feats, additional caravan jobs?
Thanks and look forward to the results of your work.
I took one of the caravan sheets someone started and fleshed it out. let me know what you think. or if you see any errors.
The Complete Caravan Sheet v1.1.
I am working on a version with the 3rd party Trade Roots Expanded Caravan rules also.
Very cool. I'm planning on using the expanded rules and that was the first question I had about the spreadsheet. That being said, could it be made flexible enough to accommodate additional items such as other wagon types, more feats, additional caravan jobs?
Thanks and look forward to the results of your work.
just working on getting all the bugs out now. :) I will try and add a page you can enter other bonuses on later.
I always keep a link to my most current version in my profile.
| 1 person marked this as a favorite. |
Thanks so much for this! It might be what actually convinces my players to use the Caravan rules!
one thing i do to help keep all players involved in caravan combat, and to help keep it balanced at higher levels is to have one player act as the commander. he makes all the roles for the caravan during combat. the other PCs are able to attack but only do half damage. this goes for spells too. any ability like a bards song work like normal.