Tribes:Ascend Forums

FAQ • Login • Register

Management tools for the community
Author	Message
Trilandian Joined: Mon Mar 19, 2012 2:28 pm Posts: 485	Management tools for the community In the relatively short time I've been a part of this community, I've seen many contributions to the community from players in the form of advice, instructional videos, proliferation of information and more. It is in this spirit that I provide to you, T:A community members, tools that may assist you in ways that aren't related to learning to play better (seeing as how, even if I wanted to provide such help, my relative inexperience would render me unqualified): Attachment: TA Management Tools.rar Within this rar file are two Microsoft Excel worksheets, the "Tribes Ascend Unlock Tracker" and the "Tribes Ascend XP Converter". The Unlock Tracker is a little something I made to help me keep track of the items I've unlocked and have yet to unlock, and help me plan what to unlock or upgrade next. The XP Converter is a tool I've created a few minutes prior to writing this thread for the purpose of gifting it to you (though now that it's done, I'll be using it too). WARNING: MICROSOFT EXCEL 2007 OR 2010 ARE REQUIRED TO OPEN THE WORKSHEETS Introductions and instructions of use: The Unlock Tracker This is used to track how much XP you've invested into the different classes and perks, and how much you have left to invest to reach your desired goal. It contains the following: A by-class breakdown table with the following columns: Current = The amount of XP invested into the class. Minimal = The amount of XP still required to make the class barely playable (any less and it would be functionally useless). Reasonable = The amount of XP still required to make the class reasonably playable. Optimal 1 = The amount of XP still required to make the class optimally playable without unlocking any of the items that aren't unlocked by default. Optimal 2 = The amount of XP still required to make the class optimally playable with all necessary features unlocked. Full = The amount of XP still required to unlock the class completely. % = The relative amount of XP you've unlocked within the class (does not correspond to the in-game percentage). Two tables of the available perks (divided by primary and secondary) with the following columns: Current = The amount of XP invested into the perk. Ideal = The amount of XP still required to have the perk ideally unlocked. Full = The amount of XP still required to have the perk fully unlocked. Note that the tiers described above are adjustment to suit my tastes (although I did reset the ideal perk counters to 24,000 [18,000+2,000+4,000]). To alter the values according to your personal preferences, please consult the advanced use section. Basic Use (for people with no understanding of Excel): Type in the sum total amount of XP you've invested into each class/perk (for gold unlocks, type in an XP value as if you've unlocked it with XP), all values will update accordingly. Advanced use: WARNING: AT LEAST A BASIC UNDERSTANDING AND HANDLING CAPABILITY OF MICROSOFT EXCEL IS REQUIRED FOR MAKING ANY ALTERATIONS WITHIN THE TRACKER. IF YOU "BROKE" IT, RELOAD THE ORIGINAL AND START FROM SCRATCH 1. Altering the "current" values in the class table - Go into the class's individual sheet. In the cell beside the word "Current", type in a sum function that encompasses all the items and upgrades you have unlocked. [recommendation: mark items you have unlocked (e.g color them) so as not to forget them at a later date] 2. Altering the "current" values in the perk tables - Simply input the amount of XP you've invested in the perk. 3. Altering the "tier" values in the class table - Go into the class's individual sheet. In the cell beside the tier's name, change the sum function to suit your preferences. 4. Altering the "ideal" values in the perk tables - Go to the individual cell in the "Ideal" column of the perk you wish to adjust. For perks you wish to fully unlock, change the value from 24000 to 35200. For perks you have no desire to unlock at all, erase the function or replace the 24000 with 0. The XP Converter A basic calculator that converts play time to earned XP and vise-versa. Instructions: Input your win rate, your average place on the scoreboard (1-16, leave it at 8 if you're unsure), whether or not you're a VIP (1=yes, 0=no) and whether or not you have an active boost (1=yes, 0=no). Once that's done, use the left column to covert XP to the time needed to earn it, and use the right column to convert net play time to yielded XP. Well, that's it. I sincerely hope many of you will find these useful. If I have updates, fixes or additions in the future, I'll put them into the attachment and bump the thread. GG You do not have the required permissions to view the files attached to this post. _________________ Thump... BOOM --- My Contributions Intelligent Turret Placement Management tools --- Important Topics Missing/Broken Features - tinyurl.com/TA-MaBF Tactics tutorial - tinyurl.com/TA-HRMaTATT Call down turrets - tinyurl.com/TA-CDT Varying unlock costs - tinyurl.com/TA-HRWTVUC Last edited by Trilandian on Tue May 08, 2012 12:24 pm, edited 2 times in total.
Thu Apr 19, 2012 5:43 pm

Trilandian Joined: Mon Mar 19, 2012 2:28 pm Posts: 485	Re: Management tools for the community EDIT 1: Updated the tracker for the latest patch. Note to mods: Please move this to the general forum, thank you. _________________ Thump... BOOM --- My Contributions Intelligent Turret Placement Management tools --- Important Topics Missing/Broken Features - tinyurl.com/TA-MaBF Tactics tutorial - tinyurl.com/TA-HRMaTATT Call down turrets - tinyurl.com/TA-CDT Varying unlock costs - tinyurl.com/TA-HRWTVUC
Tue Apr 24, 2012 10:05 am

Armoredphoenix Joined: Wed Dec 29, 2010 11:59 pm Posts: 844 Location: Kansas Steam Gamer Name: Armoredphoenix	Re: Management tools for the community I think we need a subforum _________________ Armoredphoenix http://www.generhaters.com
Tue Apr 24, 2012 10:30 am

Rimoha Joined: Fri Jun 25, 2010 10:07 am Posts: 291 Location: near Venice	Re: Management tools for the community Downloadan, I hope openoffice/libreoffice excel equivalents will suffice. _________________ Please support the cause for better CTF PUB games! IGN: h4ppyj3d1 \| EU servers \| I'll gladly switch nickname with something better if it'll be possible but, I can't stand spending gold for something like this.
Tue Apr 24, 2012 10:59 am

Trilandian Joined: Mon Mar 19, 2012 2:28 pm Posts: 485	Re: Management tools for the community Edit 2: Updated the Tracker for the latest patch. Tweaked some of the Tracker's pre-set values. Polished the Tracker and the Converter to make them more visually appealing. I again request that this thread be moved to the general forum, thank you. _________________ Thump... BOOM --- My Contributions Intelligent Turret Placement Management tools --- Important Topics Missing/Broken Features - tinyurl.com/TA-MaBF Tactics tutorial - tinyurl.com/TA-HRMaTATT Call down turrets - tinyurl.com/TA-CDT Varying unlock costs - tinyurl.com/TA-HRWTVUC
Tue May 08, 2012 12:27 pm

Display posts from previous: Sort by

Management tools for the community

Author

Message

Trilandian

Joined: Mon Mar 19, 2012 2:28 pm
Posts: 485

Management tools for the community

In the relatively short time I've been a part of this community, I've seen many contributions to the community from players in the form of advice, instructional videos, proliferation of information and more.
It is in this spirit that I provide to you, T:A community members, tools that may assist you in ways that aren't related to learning to play better (seeing as how, even if I wanted to provide such help, my relative inexperience would render me unqualified):

Attachment:

TA Management Tools.rar

Within this rar file are two Microsoft Excel worksheets, the "Tribes Ascend Unlock Tracker" and the "Tribes Ascend XP Converter".

The Unlock Tracker is a little something I made to help me keep track of the items I've unlocked and have yet to unlock, and help me plan what to unlock or upgrade next.

The XP Converter is a tool I've created a few minutes prior to writing this thread for the purpose of gifting it to you (though now that it's done, I'll be using it too).

*WARNING: MICROSOFT EXCEL 2007 OR 2010 ARE REQUIRED TO OPEN THE WORKSHEETS*

Introductions and instructions of use:

The Unlock Tracker

This is used to track how much XP you've invested into the different classes and perks, and how much you have left to invest to reach your desired goal.
It contains the following:
A by-class breakdown table with the following columns:
Current = The amount of XP invested into the class.
Minimal = The amount of XP still required to make the class barely playable (any less and it would be functionally useless).
Reasonable = The amount of XP still required to make the class reasonably playable.
Optimal 1 = The amount of XP still required to make the class optimally playable without unlocking any of the items that aren't unlocked by default.
Optimal 2 = The amount of XP still required to make the class optimally playable with all necessary features unlocked.
Full = The amount of XP still required to unlock the class completely.
% = The relative amount of XP you've unlocked within the class (does not correspond to the in-game percentage).

Two tables of the available perks (divided by primary and secondary) with the following columns:
Current = The amount of XP invested into the perk.
Ideal = The amount of XP still required to have the perk ideally unlocked.
Full = The amount of XP still required to have the perk fully unlocked.

Note that the tiers described above are adjustment to suit my tastes (although I did reset the ideal perk counters to 24,000 [18,000+2,000+4,000]). To alter the values according to your personal preferences, please consult the advanced use section.

Basic Use (for people with no understanding of Excel):

Type in the sum total amount of XP you've invested into each class/perk (for gold unlocks, type in an XP value as if you've unlocked it with XP), all values will update accordingly.

Advanced use:

*WARNING: AT LEAST A BASIC UNDERSTANDING AND HANDLING CAPABILITY OF MICROSOFT EXCEL IS REQUIRED FOR MAKING ANY ALTERATIONS WITHIN THE TRACKER. IF YOU "BROKE" IT, RELOAD THE ORIGINAL AND START FROM SCRATCH*

1. Altering the "current" values in the class table - Go into the class's individual sheet. In the cell beside the word "Current", type in a sum function that encompasses all the items and upgrades you have unlocked. [recommendation: mark items you have unlocked (e.g color them) so as not to forget them at a later date]
2. Altering the "current" values in the perk tables - Simply input the amount of XP you've invested in the perk.
3. Altering the "tier" values in the class table - Go into the class's individual sheet. In the cell beside the tier's name, change the sum function to suit your preferences.
4. Altering the "ideal" values in the perk tables - Go to the individual cell in the "Ideal" column of the perk you wish to adjust. For perks you wish to fully unlock, change the value from 24000 to 35200. For perks you have no desire to unlock at all, erase the function or replace the 24000 with 0.

The XP Converter

A basic calculator that converts play time to earned XP and vise-versa.

Instructions:

Input your win rate, your average place on the scoreboard (1-16, leave it at 8 if you're unsure), whether or not you're a VIP (1=yes, 0=no) and whether or not you have an active boost (1=yes, 0=no).

Once that's done, use the left column to covert XP to the time needed to earn it, and use the right column to convert net play time to yielded XP.

Well, that's it.
I sincerely hope many of you will find these useful.
If I have updates, fixes or additions in the future, I'll put them into the attachment and bump the thread.

GG

You do not have the required permissions to view the files attached to this post.

_________________
Thump... BOOM
---
My Contributions
Intelligent Turret Placement
Management tools
---
Important Topics
Missing/Broken Features - tinyurl.com/TA-MaBF
Tactics tutorial - tinyurl.com/TA-HRMaTATT
Call down turrets - tinyurl.com/TA-CDT
Varying unlock costs - tinyurl.com/TA-HRWTVUC

Last edited by Trilandian on Tue May 08, 2012 12:24 pm, edited 2 times in total.

Thu Apr 19, 2012 5:43 pm