Sky, Sea, Limbus, Einherjar, Salvage & Assault Excel Sheets

[Nekonaruto]

I'm not quite sure if this fits in here, might be better in Event section...either way:
I like spending my time with useless stuff like creating stupid Excel spreadsheets that have virtually no purpose, like a merit calculator or one that summarized all the gear from my previous LS and so on.

Yesterday a friend asked me if I could make him one for his sea and limbus stuff, for him to keep track of who has which pop items and so on. Since I liked the result, I figured I should just go ahead and post it...so please download it here.

Due to lazyness it can only keep track of up to 10 pop sets but either way I doubt that many Linkshells have that many anyways. If you happen to find a bug or anything, feel free to post/PM me and I will try my best to fix it. Hope you find it as useful as he did.


PS: If people are interested I can post the other spreadsheets too, some time.

[Meian]

Bit afraid to try it out before someone else does XD

[Gilanth]

Perfectly safe, Looks like it will do the job quite nicely.

[LakshmiToralyn]

does anyone know a public site that can hold XLS type forms and allow people to edit them, then be viewed by public?

[solsovly]

Try Google Docs, should fit your requirements.

[Nekonaruto]

Bump.

That same friend asked me for a similar spreadsheet for Salvage and since I didn't feel like studying I gave it a go and here is the result.

There might be some bugs or whatever, if you happen to find any (or typos) please let me know...explanations on how to use its functions are in the spreadsheet itself. Enjoy!


PS: Not going to put virusses into spreadsheets (not even if I had a clue on how to do that >.>)

[Starr]

Aww I thought this was gonna be a % drop rate on seperate pieces of Homam and Nashira so we could see how they drop clearer, anyone done a shit load of Omega that can show what % they got on pieces?

[aurik]

Someone posted some statistics a while ago, can't remember where, but it was about 25% per piece per slot.

[jibini]

Someone posted some statistics a while ago, can't remember where, but it was about 25% per piece per slot.

/grumblegrumbleNohomamlegssinceMaylastyeargrumble

[Meian]

Someone posted some statistics a while ago, can't remember where, but it was about 25% per piece per slot.

/grumblegrumbleNohomamlegssinceMaylastyeargrumble

lol poor Starr, we haven't had a homam body in like that long

[Aragon of Odin]

Maybe i'm doing something wrong, but for some odd reason when you put 108 Grah.M.Chips it puts 91 as the total number of pop sets, and any number greater then 108 will keep the pop sets at 91.

[Nekonaruto]

Ugh, corrected that...I wrote 91 instead of 9 in the formula, my bad. You can use the above link, it's the updated version.

Sorry for the inconvienence and thanks for telling me

[Nekonaruto]

Bumpedy-bump.

Updated a spreadsheet I made a while ago for my Assault static, feel free to download it here.

Since I'm in the mood I'll make an Einherjar one aswell, also considering adding sky pop items to the "Pop Items" spreadsheet...also revising my "Obtained Items" spreadsheet. So be prepared for a few more bumps.

[Dense]

does anyone know a public site that can hold XLS type forms and allow people to edit them, then be viewed by public?

I've been using http://www.editgrid.com/ for that purpose. It's free for non-commercial use, and you can set the ability for anyone to make changes, specific registered users, etc. It's very nice for keeping track of Assaults completed, drops from certain events (like Salvage), etc, since each member can update his/her own parts by themselves...

[Nekonaruto]

Two bumps in a day...don't accuse me of trolling prease.

Anyways, I did the Einherjar (found here) one and added the Sky thingy to the "Pop Items" one. Have fun!

PS: Updated versions (even though I doubt I will update these again, unless there's a mistake) can always be found in my sig.

[azagarth]

Wow ty i have been looking for a way to keep track of salvage stuff, btw can these be linked to websites by chance? I really dont know much about computers let alone all this lol, i just play on them.

[Nekonaruto]

As some previous posters mentionned: Google Docs offers a way to host Excel files for several people to edit them, but you have to register (not that it takes a long time but yeah).

[Moridox]

This is the format Excel sheets take when used w/ Google Docs. http://spreadsheets.google.com/pub?key= ... TuHQ&gid=1 You can create a list of individuals capable of editing any item (requires them to have a Gmail email account to use as their login). I just have separate sheets within one single masterfile that track each category: schedule, roster, limbus, salvage, einherjar, the various equipment sets, and our triggers. With Excel files Google Docs provides a 1-click update, this allows me just maintain the file daily on my laptop and upload each night. The tab for Einherjar might provide some help for those trying to track all their members.

[Nekonaruto]

One of the earlier spreadsheets I've created was to keep track of total merits, nothing too fancy but useful nonetheless, it can be found here.

Have fun, and only one last following in the next few days then I'll stop.

[avelle]

One of the earlier spreadsheets I've created was to keep track of total merits, nothing too fancy but useful nonetheless, it can be found here.

Have fun, and only one last following in the next few days then I'll stop.

Any idea why the HP and MP merit calculation ends up in 0 when trying to go passed the 3rd upgrade? Having 3 merits in HP results in 6, but going to 4 is 0.