Main Site

Forum Index

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to FFH, where all your dreams come true!

Team Design Tool  (Read 1512 times)
Pages: [1]
Gaignun [Posts: 234] Logged
  • View Profile
  • share
  • [December 21, 2011, 04:42:12 AM]
Team Design Tool
« on: December 21, 2011, 04: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 »
4v4, Squire only, no swords, map 116
FFMaster [Posts: 2408] Logged
  • View Profile
  • share
  • [December 21, 2011, 05:17:22 AM]
Re: Team Design Tool
« Reply #1 on: December 21, 2011, 05: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 ☢
Need a Dota 2 invite? PM me your Steam account and play with me, PX and others and we shall aim for the top!
Gaignun [Posts: 234] Logged
  • View Profile
  • share
  • [December 21, 2011, 05:49:29 AM]
Re: Team Design Tool
« Reply #2 on: December 21, 2011, 05: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: 2417] Logged
  • View Profile
  • share
  • [December 21, 2011, 06:30:58 AM]
Re: Team Design Tool
« Reply #3 on: December 21, 2011, 06: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!
4v4, Squire only, no swords, map 116
FFMaster [Posts: 2408] Logged
  • View Profile
  • share
  • [December 21, 2011, 06:35:18 AM]
Re: Team Design Tool
« Reply #4 on: December 21, 2011, 06:35:18 AM »
Alright, thanks for that.

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

☢ CAUTION CAUTION ☢ CAUTION CAUTION ☢
Need a Dota 2 invite? PM me your Steam account and play with me, PX and others and we shall aim for the top!
Dol [Posts: 300] Logged
  • View Profile
  • share
  • [December 22, 2011, 09:45:49 PM]
Re: Team Design Tool
« Reply #5 on: December 22, 2011, 09:45:49 PM »
This is quite excellent.  Playing around with expected damage output of builds has been quite entertaining.
Fighting Spirit
Barren [Posts: 1297] Logged
  • View Profile
  • share
  • [December 22, 2011, 10:21:21 PM]
Re: Team Design Tool
« Reply #6 on: December 22, 2011, 10: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, 11:12:16 PM by Barren »
He who fears being conquered is sure of defeat
Gaignun [Posts: 234] Logged
  • View Profile
  • share
  • [December 23, 2011, 05:05:07 AM]
Re: Team Design Tool
« Reply #7 on: December 23, 2011, 05:05:07 AM »
Thanks for pointing those out.  Their correct properties will appear in the next version. 
Gaignun [Posts: 234] Logged
  • View Profile
  • share
  • [December 28, 2011, 07:13:38 PM]
Re: Team Design Tool
« Reply #8 on: December 28, 2011, 07:13:38 PM »
Version 1.00 is released.
Gaignun [Posts: 234] 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: 36] 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: 234] 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: 234] 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: 234] 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: 802] Logged
  • View Profile
  • share
  • [November 21, 2012, 05:44:25 AM]
Re: Team Design Tool
« Reply #14 on: November 21, 2012, 05:44:25 AM »
thanks gaignun! XD

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

Currently Working on
[FFT: Journey of The Five]


Join our RP :)
"Desperation"

"PAIN. THAT'S WHAT KEEPS YOU HUMAN"
reinoe [Posts: 165] Logged
  • View Profile
  • share
  • [January 20, 2013, 12:01:40 AM]
Re: Team Design Tool
« Reply #15 on: January 20, 2013, 12:01:40 AM »
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, 01:41:42 AM by reinoe »
My dreams can come true!
Unlucky NPC
Reks [Posts: 215] Logged
  • View Profile
  • share
  • [January 20, 2013, 12:10:30 AM]
Re: Team Design Tool
« Reply #16 on: January 20, 2013, 12:10:30 AM »
Quote from: reinoe on January 20, 2013, 12:01:40 AM
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.
Pages: [1]