Gaming [Excel-Tool] Zelda TriForce Heroes/Ocarina/Majora Manager

soaresden

Well-Known Member
Member
Joined
Dec 16, 2013
Messages
297
Trophies
0
XP
1,401
Country
France
Hi everyone :) !

Since 1 month now, I decided to develop excel files to be able to manage these 3 games.

Ocarina of Time & Majora : Skulltulas/Piece of hearts/Quests/Masks/Upgraded equipment etc...
Triforce Heroes : Outfits/Materials ...etc

Here are 3 screenshots from the 3 files :

Feel free to comment and enjoy ;)


http://tinyurl.com/ZeldaTFHManager (TriForce Heroes Manager)


http://tinyurl.com/ootmanager (Ocarina of Time Manager)


http://tinyurl.com/majoramanager (Majora's Mask Manager)





_____________________________________
 
Last edited by soaresden,

soaresden

Well-Known Member
Member
Joined
Dec 16, 2013
Messages
297
Trophies
0
XP
1,401
Country
France
Pretty simple :

- accessibility, everyone has excel
- no virus hidden in .Exe
- it's only numbers and data to manage
- from theses inputs, you can setup lot of indicators to help yourself

I have simply automatised the work and use the input to do some statistics.

It's really useful for the outfits in TriForceHeroes
 
D

Deleted-236924

Guest
Pretty simple :

- accessibility, everyone has excel
- no virus hidden in .Exe
- it's only numbers and data to manage
- from theses inputs, you can setup lot of indicators to help yourself

I have simply automatised the work and use the input to do some statistics.

It's really useful for the outfits in TriForceHeroes
Microsoft Office is paid programs and it costs quite a bit, so not everyone has it unless they pirated it.
Granted, I think it might work with OpenOffice or LibreOffice, but compatibility issues might happen there.
 

MichiS97

"Leftist snowflake milennial"
Member
Joined
Jun 14, 2011
Messages
1,749
Trophies
1
Age
23
Location
Munich
XP
2,680
Country
Germany
This looks awesome, thank you very much! I actually did the same for every single player Zelda game but my tables don't look even halfway as nice :D
 
  • Like
Reactions: soaresden

soaresden

Well-Known Member
Member
Joined
Dec 16, 2013
Messages
297
Trophies
0
XP
1,401
Country
France
Microsoft Office is paid programs and it costs quite a bit, so not everyone has it unless they pirated it.
Granted, I think it might work with OpenOffice or LibreOffice, but compatibility issues might happen there.

I agree:
I use MS Office so some formulas may not work well..
I Even I tried to put it in Google Sheets.... and it was an Epic Fail (#REF...#N/A) ... ^^

But I disagree, I didn't paid MS Office
When I was in my university and with the cooperation program called "MSDNAA"
I use to download MS Office and have a full license for free (thanks studies ;)).

By the way, they released a "Starter" free Edition to be concurrent as OpenOffice.
So it may work as well as a Full/Pirated version
 
Last edited by soaresden,
Joined
Mar 17, 2010
Messages
21,220
Trophies
3
Location
Space
XP
10,020
Country
Norway
I spot a lot of incorrect translations (names not matching their english counterparts), typos ( 3) is used twice for example) and spelling/grammar errors though most of it is perfectly understandable.
I'm just not sure I see the point in this. It's not like it's needed to keep track of progress, as you will know when you have everything without needing something like this.
 

MichiS97

"Leftist snowflake milennial"
Member
Joined
Jun 14, 2011
Messages
1,749
Trophies
1
Age
23
Location
Munich
XP
2,680
Country
Germany
I spot a lot of incorrect translations (names not matching their english counterparts), typos ( 3) is used twice for example) and spelling/grammar errors though most of it is perfectly understandable.
I'm just not sure I see the point in this. It's not like it's needed to keep track of progress, as you will know when you have everything without needing something like this.

Of course you know when you've got everything but it's rather annoying when you notice that you're missing one Skultulla at the end and you don't remember which one it was and you have to check all the locations. Same goes for Heart Pieces ;) I always complete Zelda games 100% and I want to make absolutely sure that I don't miss anything so I like to plan ahead and think about what I want to collect in my next playing session, so checklists like the ones I made or this tool by @soaresden are really helpful because they make it easier to determine which items you may have missed.
 

soaresden

Well-Known Member
Member
Joined
Dec 16, 2013
Messages
297
Trophies
0
XP
1,401
Country
France
I spot a lot of incorrect translations (names not matching their english counterparts), typos ( 3) is used twice for example) and spelling/grammar errors though most of it is perfectly understandable.
I'm just not sure I see the point in this. It's not like it's needed to keep track of progress, as you will know when you have everything without needing something like this.

Sorry, I'm French-native, I didn't use Google Translation because I know it's ****ty :)
It's only screenshots, I didn't update it everytime on the website, but the Excel file is updated

It was really difficult to put 2 languages in 1 file, thanks for pointing this out, I actually like it when someone help me, I will correct it asap ;)

The point of that kind of tool is simple :

How are you supposed to know exactly if you killed 100 skulltulas without noting it on a paper ? Can you manage all these datas in mind ? Even after 2 months not playing :) ?

How many skulltulas do you have to kill as a Child/Adult ?

With theses files you can know it in a second :) !

Yes everybody as access to these informations, but the point was to put it in a unique file, and interact directly to transform a "game-tip" into a "dynamic assistant" for the game where you actually input your progression

EDIT: exactly @MichiS97 :) I like to explore whole Hyrule, Termina or ... whatever the world :) Zelda's universe is rich and tracking every thing is a real pain for a lover fan like us :) (even if we start to know the locations by heart)
 
Last edited by soaresden,
  • Like
Reactions: Deleted-236924
Joined
Mar 17, 2010
Messages
21,220
Trophies
3
Location
Space
XP
10,020
Country
Norway
Of course you know when you've got everything but it's rather annoying when you notice that you're missing one Skultulla at the end and you don't remember which one it was and you have to check all the locations. Same goes for Heart Pieces ;) I always complete Zelda games 100% and I want to make absolutely sure that I don't miss anything so I like to plan ahead and think about what I want to collect in my next playing session, so checklists like the ones I made or this tool by @soaresden are really helpful because they make it easier to determine which items you may have missed.
Oh, it tracks the locations too? That could actually come in handy :)
 
General chit-chat
Help Users
    kenenthk @ kenenthk: 🤢