PST Time 00:00:00GMT-8
Local Server Time 00:00:00GMT+8
ID
Password
FlashGuide
FlashGuide
HA Infomation

Tip and Tactics
Forum Quick Menu

  Index

  • NFbuilder - ship/crew/sailors calculator by sk_bismarck

    06. 22. 2011 12:52

Recommend : 13

SK_Bismarck
Repost on new site:

Hi I would like to share with you my xls file for some basic navyfield calculations:

NFbuilder v2.20EN

 
Download link:

https://uploading.com/files/11643f85/NFbuilder_v220EN.xls/ 
 
Description:

NFbuilder contain sheets:

1. MySailor - list of all sailors which you have...you can add to thi list your sailors with
their abilities. This sailor you can choose in Crewbuilder

2. CrewBuilder - sheet for calculation for ship crew for ship what you choose from the
list. There is some basic calculation like SD, OH time, Repair rate, burn rate, Sonar
range etc.

3. SailorBulder - this sheet is for simulation classing sailors...you can simulate sailor
classing with variable vets, experts, rookies, boosted or non boosted, with different
bases etc...

4. Ship level and sailor - sheet where you can find how many experience get your
sailor on ship with different level...you can compare 5 ships and find ship where
leveling your sailors is most effectively (e.g. sometime is better to use ship with less
% but with more slots for sailors)

5. ShipsCompare - you can compare basic characteristic for 8 ships

6. AircraftCompare - datas for aircraft

7. BombCompare - datas for bomb

I dont have full (or some data could be old one) data for ships/planes but I hope that
you could enjoy it and will be helpfull for you. If you find some mistakes or have idea
for improvement you can PM me.

Thanks for your feedback and ideas for improvement
 
sk_bismarck

some screens:

 

 

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    08. 07. 2011 19:31


aingeal
Originally Posted by SK_Bismarck

Originally Posted by Gjs3122

Bumped for a very useful chart.

I can't seem to get the accuracy cap numbers to work on the crew builder page though, any suggestions?
Some caps were changed in the last year (reload, accuracy and soome other value too). unfortunately I dont have many time to update this...

Maybe I update aircraft and ships datas in few moths but there is still some changes (e.g. after last MN/SN patch)...

About accuracy cap there is use old Adalbert formula...

(4706x gunner level) + 1000 000

for example level 100 gunner:

4706x 100 + 1000 000 = 470600 + 1000 000 = 1470600

As I said...it is old Adalbert formula, actual cap is little bit higher i think...

But it will be good if someone has exact formulas/caps. I can improve this file and post it for all again...

And thanks for any ideas for improvement


I think richardphat has calculated the new cap values for gunners. Try and check with him. If he didnt, I'm sure he'll know how to do it.

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    08. 17. 2011 18:14


Invinciblor
Speaking of gunners, any thoughts on using the sailor builder to plan out USN gunners' different class possibilities? Things like acc/rld/rld or rld/acc/rld, etc.

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    08. 30. 2011 11:13


dercomandan
looks good thanks

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    09. 11. 2011 21:01


adams67s
anyone with excel 2007 having problems opening it ?

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    09. 12. 2011 11:59


SK_Bismarck
Originally Posted by adams67s

anyone with excel 2007 having problems opening it ?

For me is ok in Excel 2007. But I didnt check if all formulas works in Excel 2007 too.

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    09. 21. 2011 10:37


Invinciblor
Thanks a bunch for the spreadsheet.

I still use it frequently, especially the sailor builder and ship level chart.

The sailor builder page wasn't really designed to easily test delay-classing (it seems more base-growth/veteran count oriented), but it still really helps to find those sweet spots where you get the most out of your sailors without crippling them in their primary skills.

Delay-classed torpedo men here I come!

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    09. 21. 2011 11:45


SK_Bismarck
Originally Posted by Invinciblor

Thanks a bunch for the spreadsheet.

I still use it frequently, especially the sailor builder and ship level chart.

The sailor builder page wasn't really designed to easily test delay-classing (it seems more base-growth/veteran count oriented), but it still really helps to find those sweet spots where you get the most out of your sailors without crippling them in their primary skills.

Delay-classed torpedo men here I come!
You can easy simulate delaying in SailorBuilder sheet. You just need put your level to green fields right beside the "min level"..."min level" means level of classing on time for this sailor class...but you can use what you want higher then minimal classing level to simulate delaying =)

For example you can see simulation for KM Heavy Torpedo on this picture:

http://navyfield4fun.com/images/articles/torpdelay.png


SAILOR 1: classing on time
SAILOR 2: delayed classing from KM sailor to Heavy Torpedo for level 60
SAILOR 3: delayed classin from KM sailor to Heavy Torpedo for level 120

You can after easy check result for different abilities (torp 12 or 13, rep/rest 9 or 11) and compare with same number of vets for example. All it is 120lvl sailors =)
This sheet I used mostly too. ;-)

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    09. 30. 2011 18:35


snoweman
Love it, feeds my obsession with keeping track of stats.

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    11. 09. 2011 22:31


LiquidQuartz
It's not working for me, says there's some unreadable parts in it or something.

  • Re : NFbuilder - ship/crew/sailors calculator by sk_bismarck

    12. 06. 2011 16:04


KINGS11
I can't get it to work, says I'm missing some components as well.

Why don't you re-sticky NF calc SK. That worked fine and dandy.

1 2 3 4