Please login or register.

Login with username, password and session length
Advanced search  

News:

[2014/08/29] New steam profile field added. Add your steam ID now. Join the FFHacktics steam group.

Team Design Tool  (Read 2814 times)
Pages: [1] 2
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [December 21, 2011, 03:42:12 AM]
Team Design Tool
« on: December 21, 2011, 03:42:12 AM »
Greetings,

I would like to share a spreadsheet I wrote to assist the team design process.  The spreadsheet streamlines calculations I make when putting a team together, such as damage output, success rate of support skills between party members, and so on.

Information is taken directly from the FFT Arena master's guide, so any errors in that guide will be reproduced in this spreadsheet. 

Let me know of the errors you spot (that are not consistent with the master's guide) or any changes you'd like to see.  The spreadsheet uses some formatting rules that are not compatible with versions of Microsoft Excel earlier than 2007.

Current version: 1.03
Compatible with FFT Arena v1.38d
Required software: Microsoft Excel 2007 or later

Changelog
« Last Edit: October 04, 2012, 10:33:06 AM by Gaignun »
☯☯☯☯
FFMaster [Posts: 2459] Logged
  • View Profile
  • share
  • [December 21, 2011, 04:17:22 AM]
Re: Team Design Tool
« Reply #1 on: December 21, 2011, 04:17:22 AM »
Just started messing with this, and it looks really cool and useful. Everyone should check this spreadsheet out.

Is there a way to make it check for any target Brave/Faith? What about enemy Supports and Statii like Protect/Defense Up?

☢ CAUTION CAUTION ☢ CAUTION CAUTION ☢
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [December 21, 2011, 04:49:29 AM]
Re: Team Design Tool
« Reply #2 on: December 21, 2011, 04:49:29 AM »
At the moment, it only considers fellow team members' brave, faith, support skills, and status.  It's possible to obtain data for every scenario, but it must be done by configuring two separate Unit worksheets, which is a little cumbersome.  I suppose I could create a "battle simulation" worksheet in the next version for in-depth skill analysis.
Mediator
Eternal [Posts: 2555] Logged
  • View Profile
  • share
  • [December 21, 2011, 05:30:58 AM]
Re: Team Design Tool
« Reply #3 on: December 21, 2011, 05:30:58 AM »
Wow, very nice. Going to check this out now!

Here dying, join my legion of undeath. Your blood, the roses on unhallow'd graves!
☯☯☯☯
FFMaster [Posts: 2459] Logged
  • View Profile
  • share
  • [December 21, 2011, 05:35:18 AM]
Re: Team Design Tool
« Reply #4 on: December 21, 2011, 05:35:18 AM »
Alright, thanks for that.

Forgot to sticky the topic, so I just did it now.

☢ CAUTION CAUTION ☢ CAUTION CAUTION ☢
Dol [Posts: 309] Logged
  • View Profile
  • share
  • [December 22, 2011, 08:45:49 PM]
Re: Team Design Tool
« Reply #5 on: December 22, 2011, 08:45:49 PM »
This is quite excellent.  Playing around with expected damage output of builds has been quite entertaining.
Point, Shoot, Reload, Repeat
Barren [Posts: 1705] Logged
  • View Profile
  • share
  • [December 22, 2011, 09:21:21 PM]
Re: Team Design Tool
« Reply #6 on: December 22, 2011, 09:21:21 PM »
Very nice! This looks incredibly useful, though quick tweak you should make, diamond helmet has initial reraise and float

And in the dancer class PA save is read as 40 JP not 400
« Last Edit: December 22, 2011, 10:12:16 PM by Barren »
He who fears being conquered is sure of defeat
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [December 23, 2011, 04:05:07 AM]
Re: Team Design Tool
« Reply #7 on: December 23, 2011, 04:05:07 AM »
Thanks for pointing those out.  Their correct properties will appear in the next version. 
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [December 28, 2011, 06:13:38 PM]
Re: Team Design Tool
« Reply #8 on: December 28, 2011, 06:13:38 PM »
Version 1.00 is released.
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [April 13, 2012, 11:48:30 PM]
Re: Team Design Tool
« Reply #9 on: April 13, 2012, 11:48:30 PM »
Version 1.01 is released.  I can't manage to embed lists in spoilers for some reason.  I must be going crazy.
Shintroy [Posts: 39] Logged
  • View Profile
  • Best Dudley on XBL
  • share
  • [May 05, 2012, 03:42:17 AM]
Re: Team Design Tool
« Reply #10 on: May 05, 2012, 03:42:17 AM »
Just to make sure it's just my inexperience with Excel, EVERYTHING I need to make a tream is in this tool?
If not I'm basicaly just copy pasting everything from the guide?
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [May 05, 2012, 05:29:35 AM]
Re: Team Design Tool
« Reply #11 on: May 05, 2012, 05:29:35 AM »
I'm not sure what you mean by copy-pasting, but yeah, it presents you with all the choices you need to make when designing a team.  Rainbow Staff doesn't work properly, as I am too lazy to code its functionality, but everything else should be true to form.
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [September 06, 2012, 07:50:57 AM]
Re: Team Design Tool
« Reply #12 on: September 06, 2012, 07:50:57 AM »
Version 1.02 is released.  I don't have time to perform in-depth troubleshooting, so there are bound to be a few bugs in light of all the changes 1.38 brought.
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [October 03, 2012, 11:58:14 PM]
Re: Team Design Tool
« Reply #13 on: October 03, 2012, 11:58:14 PM »
Version 1.03 is released.
Vampire Count - LIVE.EVIL
Taichii [Posts: 809] Logged
  • View Profile
  • share
  • [November 21, 2012, 04:44:25 AM]
Re: Team Design Tool
« Reply #14 on: November 21, 2012, 04:44:25 AM »
thanks gaignun! XD

Please do share your ideas and suggestion for my project:
FINAL FANTASY TACTICS : LEGEND OF MANA

Join our RP :)
"Desperation"

"PAIN. THAT'S WHAT KEEPS YOU HUMAN"
reinoe [Posts: 383] Logged
  • View Profile
  • share
  • [January 19, 2013, 11:01:40 PM]
Re: Team Design Tool
« Reply #15 on: January 19, 2013, 11:01:40 PM »
In the FFT Arena master Guide it says that Coral Sword is water elemental AND strengthens water.  In the TEAM DESIGN TOOL I'm trying to equip the Coral Sword and there's no indication that Water is strengthened.  Nobody probably noticed because Coral Sword is so underwhelming.


EDIT: FIXED KEY PHRASE and placed in bold.
« Last Edit: January 20, 2013, 12:41:42 AM by reinoe »
My dreams can come true!
Melancholy Artist
Reks [Posts: 316] Logged
  • View Profile
  • http://steamcommunity.com/id/ReksandenWyman/
  • share
  • [January 19, 2013, 11:10:30 PM]
Re: Team Design Tool
« Reply #16 on: January 19, 2013, 11:10:30 PM »
In the FFT Arena master Guide it says that Coral Sword is water elemental AND strengthens water.  In the master guide I'm trying to equip the Coral Sword and there's no indication that Water is strengthened.  Nobody probably noticed because Coral Sword is so underwhelming.

The Coral Sword does strengthen Water, though. If it's selected in the memcard generator, an S appears under water, which means it's strengthened.

It IS, at first glance, underwhelming. But that's compared to the others, as it has it's uses.

"Nothing good ever came out of the past, except history." -Rucks, Bastion
Mudvayne [Posts: 20] Logged
  • View Profile
  • share
  • [June 06, 2013, 01:36:56 PM]
Re: Team Design Tool
« Reply #17 on: June 06, 2013, 01:36:56 PM »
Anyone know why I can't open this?
I've been into watching arena videos for a while and want to finally make a team but I'm unable to open the file.
Is it because I'm running excel 2013? Shouldn't make a difference I wouldn't think.
Gaignun [Posts: 325] Logged
  • View Profile
  • share
  • [June 07, 2013, 02:29:39 PM]
Re: Team Design Tool
« Reply #18 on: June 07, 2013, 02:29:39 PM »
That's odd.  I don't think it would make a difference either.  What error message is it giving you?
Mudvayne [Posts: 20] Logged
  • View Profile
  • share
  • [June 07, 2013, 08:28:42 PM]
Re: Team Design Tool
« Reply #19 on: June 07, 2013, 08:28:42 PM »
I can't copy/pasta the message but this is basically what it's telling me:

Excel cannot open or save any more documents because there is not enough available memory or disk space.
To make more memory available, close workbooks or programs you no longer need.
To free disk space, delete files you no longer need from the disk you are saving to.

Now obviously the disk space error is not my problem as my hard drive has over 800 gb of free space left on it AND this is the only excel file I have downloaded on my computer. I use it very in-frequently for school but that's saved on my external hd, which is 1 tb (same as my computer HD).
Even when I save the file on there and attempt to open it I get the same message,
I also don't have any other excel files open etc etc so I'm not sure why I'd get this error as between my laptop hd and my external hd I have ~1.6 TB free space so that's obviously not the issue...
Pages: [1] 2