BNW 1.5 Character Planner in Excel

3 Pages
1
2
3
→

You cannot start a new topic
You cannot reply to this topic

#1 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

06 October 2014 - 10:44 AM

Independent of Advent's project, BTB and I have been developing a character planner for BNW with the idea that it's widely useable and accessible to anyone. I started it as a method of simply tracking Esper stat growths as an addition to the printme file, but it has since grown into a standalone file that includes equipment and weapons.

Update 10/14/2014: A 'Final' public version of the planner is released. The public version has none of the hidden items. There will be another version bundled with the Unlockme that includes the hidden items.

Update 10/7/2014: A more finalized release is linked below. I have bumped the version number up to 2.0 to avoid any confusion with BNW's own version. The data has been completely brought up to date to be in line with changes to 1.5. Let me know if there are any bugs or issues.

Quote

Public version of the BNWCP for 1.6, if anyone wants it: http://btb2.free.fr/temp/BNWCP.xls

~~BNWCP 2.3 Public~~

Original Post/Dated info

Spoiler

#2 thzfunnymzn

Game Breaker

Job: Member
Posts: 2,117

06 October 2014 - 11:16 AM

Works fine on Open Office for me. Definitely very neat. (And all ready playing around with a Terra that gets 10 Unicorn and 10 Carbunkl). : )

This post has been edited by thzfunnymzn: 06 October 2014 - 11:20 AM

#3 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

06 October 2014 - 11:20 AM

I've updated the link. Right as I posted it, BTB sent me a major graphical revision.

#4 thzfunnymzn

Game Breaker

Job: Member
Posts: 2,117

06 October 2014 - 11:23 AM

Update works.

Edit: Gogo, even though he is listed as having 30 speed under the Char_Data sheet, starts with 36 speed on the calculator.

This post has been edited by thzfunnymzn: 06 October 2014 - 11:30 AM

#5 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

06 October 2014 - 12:02 PM

Updated another major graphics change per BTB. Now it's just down to fixing the compatability bugs.

#6 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

06 October 2014 - 12:11 PM

thzfunnymzn, on 06 October 2014 - 11:23 AM, said:

Update works.

Edit: Gogo, even though he is listed as having 30 speed under the Char_Data sheet, starts with 36 speed on the calculator.

Fixed that. Still had 1.4's numbers in there.

#7 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

06 October 2014 - 12:17 PM

Mog can now wear the correct helmets.
Deleted redundant stat tables.

Make sure to refresh the link.

Edit: Probably missing some more equipment, so we'll release an update once it's totally sorted.

#8 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

06 October 2014 - 01:11 PM

1.3 released and the link is updated. BTB found and fixed a number of missing equipment and table errors. Still sorting conditional formatting errors but the planner is more than useable right now. Leaving all the hidden stuff unhidden for the time being until we're done with it.

I think most of the formatting errors are due to converting between excel and OO/Libre office. Let me know if y'all run into any issues.

Edit:

Shadow has relics again.

Umaro gets his Snow Muffler.

#9 BTB

Co-Creator of BNW

Job: Modder
Posts: 4,548

06 October 2014 - 01:56 PM

Ok, here's what I have: http://btb2.free.fr/temp/BNWCP.xls

I was able to save it without breaking the validation, and it works fine for both Stann and Abbadon. If everything looks fine to you when you open it up, then we can go with this.

#10 Nakar

Improbability Breaker

Job: Wiki Guardian
Posts: 1,461

06 October 2014 - 03:37 PM

Yours doesn't seem to let gear be selected (in Excel 2013), BTB. Not sure what changed, it works in the link up top.

This is a lot better than mine, although it only allows for one character at a time. Much better equipment filtering.

#11 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

06 October 2014 - 04:53 PM

The one in the OP is actually a proper excel file. The data validation breaks when you save it with open office or libre office and then try to open it again in excel, which is what BTB's file is. I'll fix it tomorrow when I have access to a computer with excel. It works fine when opening it in OO/Libre if it was originally an excel file.

I'll look into adding support for multiple characters. I was considering that earlier anyway.

#12 BTB

Co-Creator of BNW

Job: Modder
Posts: 4,548

06 October 2014 - 05:00 PM

I'm actually going through right now and filling out the effects (quite a few are missing), so I'll provide an updated one when I'm finished.

#13 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

07 October 2014 - 11:05 AM

Version 2.0 uploaded, see OP for details.

#14 ronlyn

Gaming Addict

Job: Member
Posts: 406

08 October 2014 - 04:47 PM

carbunkle and maduin have their stats growths ups mixed between them

#15 BTB

Co-Creator of BNW

Job: Modder
Posts: 4,548

08 October 2014 - 04:56 PM

ronlyn, on 08 October 2014 - 04:47 PM, said:

carbunkle and maduin have their stats growths ups mixed between them

The BNWCP is updated for the upcoming 1.5 release of Brave New World, which includes changes to several esper bonuses.

#16 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

09 October 2014 - 09:12 AM

Updated the title and the OP to reflect that more clearly.

#17 BTB

Co-Creator of BNW

Job: Modder
Posts: 4,548

09 October 2014 - 03:08 PM

http://btb2.free.fr/temp/BNWCP.xls

Now with equipment! Mish will convert it to Excel proper and update the OP when he has a chance.

#18 Mishrak

Improbability Breaker

Job: Regulator
Posts: 1,581

10 October 2014 - 05:42 AM

Converted and updated the link. Thanks for your efforts!

#19 BTB

Co-Creator of BNW

Job: Modder
Posts: 4,548

10 October 2014 - 08:38 AM

No worries. I'm actually looking at the file I uploaded in Excel right now (since I'm at work), and it works just fine with no conversion issues. I have no idea what the problems that some people are seeing might be.

In any case, I'll be sending you another update later because seeing it in Excel made me realize that I still need to minimize the zeros that appear in the equipment tables there (but not in OO) and make a few other visual tweaks. Also, I intend to nerf the Magic Bone a little bit, so there'll be that one equipment change, as well.

For all intents and purposes, though, this is the final planner that I intend to include in the Unlockme of the mod itself. That's my basic idea, anyhow - I won't object to it being posted here, but I'd like to make it part of the official "package", so to speak. Does anyone have any thoughts/input on that?

#20 thzfunnymzn

Game Breaker

Job: Member
Posts: 2,117

10 October 2014 - 03:24 PM

Personally think it's a good idea to put it into the Unlockme. Something like this is definitely something that is of better service to people who have played the game at least once, and it helps the replay value by helping people better figure out what they can and can't do with builds and equipment set-ups and whatnot.

Share this topic:

3 Pages
1
2
3
→

You cannot start a new topic
You cannot reply to this topic

Insane Difficulty: BNW 1.5 Character Planner in Excel - Insane Difficulty