Twilightpeaks.net
RoE General => The Herald (DM announcements) => : DM B March 11, 2010, 11:56:36 AM
-
Hi,
I'm nearly done with the new spreadsheet DO - it will be available for download later today. Stay tuned to this thread.
The Excel sheet has a bit of automation to make your life easier (and mine!!!); more features will be added later.
Turn 66 is to be handed in the new format.
-
DM response to mails/posts is postponed until the DO template is ready.
-
New template added to this thread (top post).
Please use this thread for feedback. More functions will be added later, so focus on finding any glaring errors.
Note that from Turn #67 there will be NO MORE SECRETS UPDATES. Instead everything will be incorporated in the DO. Easier for me, easier for you.
-
New feature:
- GB cost from Army mustering etc. will now be subject to Admin by the character whose specialty this is, instead of just lumping everything with the chancellor.
- This should make the other Admin posts more attractive.
-
- Skill Mastery of Unskilled has now been split into; Untrained and Proficient.
-
Any chance of uploading it in a zip-file? The hospital is not exactly fond of applications such as unrar etc.
-
That looks really sweet. It certainly makes stuff easier for someone as bad with numbers as myself. And I love how you've made it so that when I change the turn number, it automatically updates season and year! Awesome!
-
Oh and all the actions are already listed in the drag-able boxes. Schweet! :D
-
That looks really sweet. It certainly makes stuff easier for someone as bad with numbers as myself. And I love how you've made it so that when I change the turn number, it automatically updates season and year! Awesome!
I know. No more confusing which Season it is.
I think the army upkeep part is especially time-saving.
-
Oh and all the actions are already listed in the drag-able boxes. Schweet! :D
I'll expand more on that later to automatically fill out things like base cost etc. And limit AAs to Character actions etc.
-
Problem with assets, P&H etc: Can't choose blank as a unit, so not able to remove the Alamier upkeep for army and such.
-
Easy fix; but I can't access the ftp right now, so attachments won't upload.
-
What's your intention with the magic-portion of the DO?
-
List for spells; allow magic-users to select spells known/prepared from drop-down menus etc.
Allow tracking of ley lines (maybe a map-overlay-type-thingy)
-
There will also be a War-sheet.
Here you can drag-and-drop your units into armies/fleet, even arrange them into echelons etc.
But that is for the future.
-
Ruornil approves all of the above. ;D
You think it would be possible to throw a map into the mix, or would that make it too grand?
EDIT:
Perhaps just a direct link to the maps?
-
OK, time for Diem to be the interwebs newb... where's the download link? I can't find it. :(
-
It's down; cuz my server is screwed. Can't upload right now. Will fix...
- Navy formula corrected
- XP/Status error corrected
-
Added to top post.
Also available here:
http://roe.twilightpeaks.net/downloads/
-
What is the levelranges of AAs (Low Med & High level)?
-
What is the levelranges of AAs (Low Med & High level)?
OoC:
Characters and skills (http://www.twilightpeaks.net/forum/index.php?topic=157.0)
-
super thanks Brandon.
The sheet looks great although it is trying to swindle a few GB from me.
End of turn status in treasury ignores any imput in extra income & RP to GB.
Perhaps the cell G56 in MAIN should be changed from "=D46-D57" to "=J46-D57" That seems to correct the issue.
-
super thanks Brandon.
The sheet looks great although it is trying to swindle a few GB from me.
End of turn status in treasury ignores any imput in extra income & RP to GB.
Perhaps the cell G56 in MAIN should be changed from "=D46-D57" to "=J46-D57" That seems to correct the issue.
That's correct; I guess the reference was there before I added cells for extra income.
-
CELL D57 (from Brandon)
Doesn't add all expenses; edited to:
=SUM(D51:N55)
-
I might be blind, but I see no place under assets to list my Ley Lines
-
I might be blind, but I see no place under assets to list my Ley Lines
Because the current version has no support for it - you just enter it manually into the Magic sheet.
(RP cost to maintain go under Maintain Ley Lines action).
-
Under the Assets Tab in the Army section, the drop down tabs in column C "Units" don't have entries for Swordsmen or Marines which I have in my current DO as army units.
I also can't manually put this in. What would be a good fix in the meantime
-
Under the Assets Tab in the Army section, the drop down tabs in column C "Units" don't have entries for Swordsmen or Marines which I have in my current DO as army units.
I also can't manually put this in. What would be a good fix in the meantime
Swordsmen are Regulars now.
Marines can be listed as Regulars (with a note)
-
How do I enter Mounted units like Mounted Armsmen?
-
How do I enter Mounted units like Mounted Armsmen?
Not supported yet (in v2.4)
You have to manually add a line to the 'Units' sheet (make sure its alphabetized) incl. unit name and upkeep cost.
Then you can select it from the drop-down menu in Assets.
-
If you dont mind I will just make a note with the unit(s) in question that they are mounted and then fix it when it gets to be supported in later versions. As it is my head is nearly ready to explode :-[
-
If you dont mind I will just make a note with the unit(s) in question that they are mounted and then fix it when it gets to be supported in later versions. As it is my head is nearly ready to explode :-[
OK
-
the custom number format for RP & GB should probably be:
0" "\RP & 0" "\GB
It is easier to read when it looks like "0 GB" rather than "0GB" (which it currently looks like)
-
AA's say they are tired of being sent adventuring every single month where they don't have actual work planned. They would like to be able to have "non-scheduled" time on their... schedule.
(You are forced to pick an action for each line of AA stuff, even when they sometimes do not have anything to do that particular month.)
-
I complained about this when discussing the last template, and feel I'll have to do so again. Could we format the section on holdings in the Do to match the P&H, so one can cut and paste rather than try constantly update these parts? Alternatively are there are clever people out there who can make one spreadsheet talk to the other, and have it automatically updated?
-
I complained about this when discussing the last template, and feel I'll have to do so again. Could we format the section on holdings in the Do to match the P&H, so one can cut and paste rather than try constantly update these parts? Alternatively are there are clever people out there who can make one spreadsheet talk to the other, and have it automatically updated?
I can make them talk...but I'm not yet sure how to make the DO pick up all the relevant entries...that is not so easy.
In the meantime; why bother at all? It's all there in the P&H, so really no need to put it int the DO.
-
Just dreaming here... But if there was a "target province" and next to it, "target holding" thing, pr. action, then it could show local prosperity, size of province, and on the "target holding" you would be able to see level and owner of all holdings in that province.
Using those values, combined with the action type, would then fill out the formula on its own.
On your Domain page, in the DO, you'd specify which is your own domain and what other domains you have "holding advantage" deals with.
Of course, then we are almost building a game engine... :-)
Some elements could probably be driven by volunteer work.
-
These kinds of functions are outside the scope of my current DO template project...
-
Having been messing around with Openoffice a little bit, I think the simple thing to do, even though it does not sound simple, is to transfer the P&H into a database (openoffice's one will do). Then make sure there are the right relationships between the data and then simply pull the data or insert data when you need to change or retrieve things. Making openoffice calc talk to the openoffice database is very easy, so that could work.
That is, of course, the theory. How to do it in practice... it would take time :P
-
No, no, no. What you need to do, is to set up the values you are interested in porting over, on a different page in the DO document.
Then you set up this page to link to the value locations in the Other file and have an update button. Mapping the first one will be a little painful, but this will work. If the format of the P&H is absolutely static in number of lines etc... :-)
-
I think I would go for the database solution myself ;)
And just now I got a vision in my head where the P&H is in an online MySQL DB, with an online DO order done with PHP :D
-
Some kind of ROE BirMail project?
-
Please keep to the subject; or make a new OOC topic.
No DBs or BirMail clones are going to appear.
-
Comments:
- Chapel of the Saints missing from Structures drop down list.
- SHould LTs be listed at the top of able assistance, with the rest in order of decreasing importance?
- Make the province level/ruler in the holding list refer to the already included province list.
- Prepare Realm Spell missing from action list. Quite key for some domains.
- Add a Not USed action to the list
- Loose the header to each individual action. One header line per action type should be sufficient
- Grants appear to be counted twice in the budget
- Should the 'off book' summation of the various construction categories be added automatically to these cells. Easy to miss some if manual.
More to come as my headache grows. >:(
BTW, I hate it, and don't look forward to moving it all into some new template next turn :-X :-X :-X
-
v2.7 uploaded.
There will be a new version before deadline; but you can use 2.7 to comment on.
-
Things to do:
Add support for mounted units
-
OoC:
Edit: Feel free to delete this post.
-
OoC:
MAIN worksheet of DO Template #65 v2.7:
In Cell D25, "=K111+M111+F131+H131+F151+H151+F179+H179" could be changed to "=K111+M111+K131+M131+K151+M151+K179+M179".
-
Assets worksheet: Regarding total expenses for fortifications, Army and navy. Cell(M87) should be changed from "=SUM(M74:M86)" to "=SUM(N74:N86)" Similar change is needed in cells (M110) and (M133).
-
Some comments:
- Formatting of 'Effort GB' in column L list them as RP.
- Total of offensive pool is incorrect in cell G30. Currently adding up the effort RP already accounted for in D25. Should read "=O111+O131+O151+O179"
- RP to GB in J28 is not accounted for in the end of turn RP sum. (Think I'll put in as many RP as possible here before it gets fixed ;))
- Chapel of the Saints missing from Structures drop down list.
- Could a 'Not Complete' status be added for structures, so they don't mess up the upkeep formula?
More later.
E
-
Keep up the good work.
I'll try and have a new template ready this week, but it looks tight. We may have to push the Deadline though, so maybe it won't be a problem. More later.
-
It might be handy to have 'special - .25 GB'; 'special - .5 GB'; etc added to the structures table to account for any weird stuff that people may have that doesn't really fit in the standard categories.
The 'cast realm spell' action could be cut to just 'realm spell' - I've been spending actions on memorising I think, although since I've done it every turn if I've nerfed it up (again) it won't matter.
Realm spells - would it be easier just to type them in rather than have a look up table? Its a long table but most people probably don't have all that many of the possibilities.
-
Anyone wants to put in some work in the DO template?
I find myself with less time right now, and it looks like the rest May will be quite hectic too.
-
I've started by adding the name list for the Realm Spells. I'll try add the respective info as well.
-
Template 2.7
MAIN list, column AS
description says "MoS = DDC - DAC", but the formula is ARx - Sx, which is DAC - DDC
-
So what template version shall we use for our DOs this turn?
-
So what template version shall we use for our DOs this turn?
If you've found out please drop me a mail with the answer to the above question ???
-
Since no newer is out, I assume it's the latest released version (2.7).
-
Either use 2.7 or the one you used for last turn. Either is OK. Sorry about the delay in providing a new and fully updated template.
-
I'd find it handy to include the prosperity levels in the list of prosperity modifiers, eg. 1 (Steady). I can never remember what they are and have to keep going back to the end of the P&H to check.
-
I managed to send in some sort of DO, but would it be controversial to extend the turn by another week? Seeing as a lot of people have been busy lately. :-[
-
I managed to send in some sort of DO, but would it be controversial to extend the turn by another week? Seeing as a lot of people have been busy lately. :-[
Yes please. As I already informed Bjørn about, I was unable to submit my DO yesterday. It should be ready within a few days, unless life decides to heap up more stuff that needs to be solved.
-
I managed to send in some sort of DO, but would it be controversial to extend the turn by another week? Seeing as a lot of people have been busy lately. :-[
Hear hear! I for one second that :-[
-
Anyone know if the Player's Secrets file is gone for good? I haven't received it with my last DO results. Waiting for a response before writing up my DO, so an extension would be great.
-
New template added to this thread (top post).
Please use this thread for feedback. More functions will be added later, so focus on finding any glaring errors.
Note that from Turn #67 there will be NO MORE SECRETS UPDATES. Instead everything will be incorporated in the DO. Easier for me, easier for you.
Quoting to remind Milos
-
It is indeed gone. It will be just the DO from now on. Once the DO template is finsihed the intention is to have a separate sheet for secret info incorporated into it.
-
OoC:
Regarding DO Template #68:
Cell B195 of the ASSETS worksheet could be edited; and some editing, related to selection lists in Column AK of the MAIN worksheet, could be performed.