cRPG
Strategus => Strategus General Discussion => Topic started by: Slamz on November 23, 2011, 03:16:56 pm
-
Attention clan leaders, officers, organizers and people who have a fetish for fiddling with data. Here is a handy method for helping get your clan crafting in order for Strategus. These are elite Norse Horde secrets which I share with you because I hope to see Strategus succeed.
I will tell you how to very easily make a complicated looking spreadsheet to help you track all your clan's crafting info. It looks harder than it is and you can have it setup and loaded with your own data in about 2 minutes.
https://docs.google.com
Create --> Spreadsheet
In the spreadsheet, click "Share". I advise changing it to "anyone with a link" but you can also keep it private and add specific people who can access it.
Here's a snippet of the Norse Horde spreadsheet:
So:
1) Create your column headings, exactly like ours ("Merchant cost" is optional, but helpful)
2) Have people go into strategus and highlight their crafting and copy it (Ctrl-C on Windows), like so:
3) Have them go to the Google spreadsheet, find the bottom of your data, highlight the 4 main columns, like so:
(If they have previously entered data, they should sort by name and delete all of their existing entries, then re-sort and continue with step 3.)
(See at the bottom where I have columns 2-5 selected)
4) Hit "Paste". This will correctly paste in all your data.
5) Have them fill in column #1 with their name. The easy way to do this is to type it once, then grab the lower right corner of that box and drag it down the row. This will copy the name for the rows you select.
Done!
Some general tips:
* Click the upper left box to select all data
* The best way to sort your data is to select all of it, then go to Data --> Sort Range --> check "data has header column" and pick the column you want to sort. This will guarantee you sort the whole spreadsheet properly.
* If you want to do "Merchant Cost" like I'm doing it, here is the formula: =round(-(E2/(D2-1))) Type it into the top column then copy it down the row the same way I said to do the name in step 5 above. Note that this is a calculated value and will be a little off from the real merchant value. (This is due to "cost" being a rounded value. So it's a little off but it sure beats typing all those numbers in by hand.)
* If you don't want members accessing your spreadsheet directly, perhaps because your clan is full of douchebags, then note that copying from a forum doesn't seem to work -- the forum loses the tabstops that tell the spreadsheet where the columns are. Two ways around this:
a) Have them paste it into a forum that you have moderator access to, then go in and edit their message and copy-paste from there. This works for phpBB forums, anyway
b) Have them paste it into a text document, like notepad, then upload that as an attachment. That should work.
Note that I'm pretty new to this myself and am not an expert and might even be doing some things wrong/dumb, but this has been very helpful for us. Let me know if you have any questions.
-
Thank you Slamz, this is really helpful! We are using Google spreadsheets ourselves to stay somewhat organized, but most members can't be bothered with typing in their values and keeping the documents updated. This is why I like your easy copy&past solution - the less effort, the more likely people are to fill in their info.
-
hehe nice
-
DRZ didn't already have such tool?
Otherwise you are fucking good at organization and discipline ;)
-
If you want to go more in depth, organize your clans crafting by item type, such as head armor, body armor, polearms, etc... Then you can add a new parameter which I have called Production efficiency.
To calculate production efficiency you need to find the max cost of that item type so you do a MAX(E$1:E$15) (assuming your price is in column E and your first item type goes from 1 to 15 in the columns) then you divide that by each items individual cost and then multiply by each items skill. This gives you a good estimate on what is the most cost effective and fastest item to craft. It is a little skewed to the cheaper items but you can get a good idea of what you want to craft from it.
The final formula should look something like this; =(MAX(E$6:E$26)/E6)*C6.
If you copy and paste this down the row, the cell reference without the $ should change but the ones with $ should stay the same. You will need to change the formula for each group of item types.
Hope someone finds this useful.
-
Wow, data entry is so much easier with your spreadsheet. The one we use has a crapload of formulas. Any time a new row is needed, you have to copy an existed row to keep the formulas and then go back and overwrite all the data cells. I'm jealous of copy and paste. However, the formulas do end up making it more useful
-
I feel the same Dynamike. I made a spreadsheet for the clan and none of them use it. They are a bunch of useless n00bs who don't have the brain power to put in two numbers every couple of days. :evil:
-
DRZ didn't already have such tool?
Sort of. But we store data only for valuable crafting such as champ rounceys, cs, mw arbalests etc. I hope we will have mostly mw items on our first castle siege.
I don't see any point in crafting items which have less discount than from crafting goods. For example:
you can craft goods from 3 to 13 g\h & sell it for 100-120(shariz area-kulum, kulum-Bariyye with 5 & 25 good prise gives 153g per good)
so you need to have about 25 skill in pitch fork to have 100g(25*4) discount per hour.
-
a lot of people have already that kinds of tools ! some people are slow hehe
-
a lot of people have already that kinds of tools ! some people are slow hehe
The nice thing about this method is the easy sharing. Lots of people use spreadsheets but sharing one between several people isn't convenient. This is one thing that Google Docs has made a whole lot easier.
-
Spreadsheets are for nubs.
Use a DB and a few lines of SQL later you have that fully automatized. Maybe a little additionnal messing with Perl to import the data in easy formats.
-
Yeah, someone should make a guide for that. ^^^
:rolleyes:
-
Spreadsheets are for nubs.
Use a DB and a few lines of SQL later you have that fully automatized. Maybe a little additionnal messing with Perl to import the data in easy formats.
Or you could cast "portal: realm of reality" and walk thru it to join the rest of us
-
I don't see any point in crafting items which have less discount than from crafting goods. For example:
you can craft goods from 3 to 13
Because you can make 30 of them in an hour. That keeps it well worthwhile.
-
a lot of people have already that kinds of tools ! some people are slow hehe
HUEHUEHUE of course Arowaine already knows. Jesus people, you're all slow.
-
If you want to make it database style, use the "Form" Option in google spreadsheats, that way your faction members can fill out the data themselves, but i am not sure about updating. As i see this as a really important information about my clan friends, this information is collected in our forums but then transfered by a few, which then have a good overview. I wouldn't want to have this information out of anybody i am a bit conservative that way :rolleyes:
If you want to go a step further try to combine this with your actual equipment list you would use to equip for battles.
For that you perhaps would need to read into the sql statements which can be used by google spreadsheats.
-
Useful formulas I've added recently:
Personal troop upkeep:
=roundup((((F2^1.03) * 1.8) - 100) / 24)
(input the number of troops you have into "F2", in this case, and the formula tells you how much it costs per turn)
Fief troop upkeep:
=roundup((((F2^ 1.02) * 1) - 100)/24)
Number of troops per upkeep (input the upkeep you want to pay and it calculates max number of troops you should have)
Personal:
=rounddown((((J2 * 24) + 100) / 1.8)^(1/1.03))
Fief:
=rounddown(((J2 * 24) + 100)^(1/1.02))
Replace columns with whatever works for you, of course.
I recommend creating a separate tab for this stuff.
I *think* these are all correct. That is, the formulas are from chadz post but the rounding is sort of an assumption. 50 troops actually comes out to like .05 upkeep or something but I think chadz rounds it up, so 50 troops = 1 upkeep (but you can actually have up to 60 troops and still only pay 1 upkeep. At 61, it becomes 2 upkeep.)
-
traitor.
-
wait what is this goo-gul you speak of?
-
HUEHUEHUE of course Arowaine already knows. Jesus people, you're all slow.
troll
ofcorse i know already and i have been using the google tool document 2 week afther strat 3 came out