Item Search
     
BG-Wiki Search
Page 1 of 2 1 2 LastLast
Results 1 to 20 of 22
  1. #1
    Salvage Bans
    Join Date
    Jun 2007
    Posts
    931
    BG Level
    5

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

    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.

  2. #2
    A. Body
    Join Date
    Oct 2006
    Posts
    4,003
    BG Level
    7
    FFXI Server
    Cerberus

    Re: Sea & Limbus Spreadsheet

    Bit afraid to try it out before someone else does XD

  3. #3
    Sea Torques
    Join Date
    Nov 2005
    Posts
    586
    BG Level
    5

    Re: Sea & Limbus Spreadsheet

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

  4. #4
    Hydra
    Join Date
    Jan 2007
    Posts
    144
    BG Level
    3
    FFXI Server
    Lakshmi

    Re: Sea & Limbus Spreadsheet

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

  5. #5
    Old Merits
    Join Date
    May 2005
    Posts
    1,210
    BG Level
    6
    FFXI Server
    Asura

    Re: Sea & Limbus Spreadsheet

    Try Google Docs, should fit your requirements.

  6. #6
    Salvage Bans
    Join Date
    Jun 2007
    Posts
    931
    BG Level
    5

    Re: Sea & Limbus Spreadsheet

    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 >.>)

  7. #7
    Banned.

    Join Date
    May 2006
    Posts
    4,533
    BG Level
    7

    Re: Sea & Limbus Spreadsheet

    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?

  8. #8
    Ridill
    Join Date
    May 2005
    Posts
    13,568
    BG Level
    9

    Re: Sea & Limbus Spreadsheet

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

  9. #9
    CoP Dynamis
    Join Date
    Apr 2005
    Posts
    266
    BG Level
    4
    FFXIV Character
    Ibi Risasi
    FFXIV Server
    Hyperion
    FFXI Server
    Asura

    Re: Sea & Limbus Spreadsheet

    Quote Originally Posted by aurik
    Someone posted some statistics a while ago, can't remember where, but it was about 25% per piece per slot.
    /grumblegrumbleNohomamlegssinceMaylastyeargrumble

  10. #10
    A. Body
    Join Date
    Oct 2006
    Posts
    4,003
    BG Level
    7
    FFXI Server
    Cerberus

    Re: Sea & Limbus Spreadsheet

    Quote Originally Posted by jibini
    Quote Originally Posted by aurik
    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

  11. #11
    Pens win! Pens Win!!! PENS WIN!!!!!
    Sweaty Dick Punching Enthusiast

    Join Date
    Oct 2007
    Posts
    2,187
    BG Level
    7

    Re: Sea & Limbus Spreadsheet

    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.

  12. #12
    Salvage Bans
    Join Date
    Jun 2007
    Posts
    931
    BG Level
    5

    Re: Sea & Limbus Spreadsheet

    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

  13. #13
    Salvage Bans
    Join Date
    Jun 2007
    Posts
    931
    BG Level
    5

    Re: Sea & Limbus, Salvage and Assault Spreadsheets

    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.

  14. #14
    Sea Torques
    Join Date
    Dec 2006
    Posts
    586
    BG Level
    5
    FFXIV Character
    Dense Fever
    FFXIV Server
    Ragnarok
    FFXI Server
    Bahamut

    Re: Sea & Limbus Spreadsheet

    Quote Originally Posted by LakshmiToralyn
    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...

  15. #15
    Salvage Bans
    Join Date
    Jun 2007
    Posts
    931
    BG Level
    5

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

    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.

  16. #16
    Cerberus
    Join Date
    Feb 2008
    Posts
    458
    BG Level
    4

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

    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.

  17. #17
    Salvage Bans
    Join Date
    Jun 2007
    Posts
    931
    BG Level
    5

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

    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).

  18. #18
    RIDE ARMOR
    Join Date
    Aug 2006
    Posts
    24
    BG Level
    1

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

    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.

  19. #19
    Salvage Bans
    Join Date
    Jun 2007
    Posts
    931
    BG Level
    5

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

    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.

  20. #20
    Chram
    Join Date
    Nov 2007
    Posts
    2,662
    BG Level
    7
    FFXIV Character
    Avelle Asteria
    FFXIV Server
    Hyperion
    FFXI Server
    Phoenix
    WoW Realm
    Alleria

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

    Quote Originally Posted by 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.
    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.

Page 1 of 2 1 2 LastLast

Similar Threads

  1. Dynamis vs. Limbus vs. Salvage vs. Einherjar
    By Sagacious Sundi in forum FFXI: Everything
    Replies: 61
    Last Post: 2007-07-17, 21:56