Fort materials calculator

  • Thread starter DeletedUser29580
  • Start date

DeletedUser29580

Hi Guys!
Not sure if it is right to post it here, if not: you are free to delete, just send me a message you did it, thanks!

I am a builder on several worlds and missed a calculator for fort materials.
Since someone made me master builder of 5 different forts, I really needed one in order to manage all materials going to the right forts.
That is why I made one myself in excel, though not 100% accurate, i find it a very use full guideline.
If some one is interested to try, just leave me a message with e-mail address.
Or let me know how to upload it here, as i can not add an excel attachment.

In case someone else has made one to, just let me know where to find it, thanks!
** Sorry, there was still a mistake in it, will put new link when repaired.
 
Last edited by a moderator:

DeletedUser29580

Thanks Duduie!
I uploaded the file, so anyone can down load it from there.
Could not get it viewed before downloading, but it is there, have fun with it.
:)
(I thought it was deleted, but had to confirm e-mail first)
 
Last edited by a moderator:

Deleted User - 1278415

You would need to discuss any issues you have with Google Docs with Google Docs support department.

We do not support that site or know why your files get deleted on there.
 

DeletedUser17612

i get this notice

Sorry, the page (or document) you have requested is not available.
Please check the address and try again.
​
 

DeletedUser

At first I thought is more of a guide, but looking at it, is an actual "tool" to calculate. So fits in the External sites discussion.
Thread moved!
 

DeletedUser17612

thank you for sending me file by email

i have tested it a little
i like what you started; it sure looks promising

some (most) formulas are not correct though!
just fill the fort size and the bilder points in 1h and you will see, which ones are not working

for toolbox it is correct
=IF($C$5=0;0;IF(C92-SUM(C24:I24)<=0;0;C92-SUM(C24:I24)))

for saws
=IF($C$5=0;0;IF(C93-SUM(C25:I25)<=0;0;C93-SUM(C25:I25)))

you should not have compared the C93, but D92 as there you have the total; same for maps (E92)

cloth: =IF($C$5=0;0;IF(C95-SUM(C27:I27)<=0;0;C95-SUM(C27:I27)))
for cloth it is C126, cotton D126 and hammer E126 instead of C95 (C96 and C97)

similar is for all products that are used for framing the building


a hope you will fix them
if i notice something else, i will write here

good job!!
 

DeletedUser

This was something I was thinking some time ago to add to twdb. It was also calculate character type, skills used and motivation, so you could possibly get exact values. Of course this depends on many factors but it sounded interesting. :) Good luck guys with this ;)
 

DeletedUser29580

Thanks Fricfrack for helping me test it, I have tested many times and uploaded a wrong file.
I will double check your remarks, please let me know if you find more mistakes.
It will take me through the weekend, but the weather is bad anyway.
I will send a new one when it is ready for second opinion before I post it again, if you dont mind :)
 
You must log in or register to reply here.
Top