Results 1 to 5 of 5

Thread: Multiple Account Spreadsheet + Mini-Guide

  1. #1
    Stardew's Avatar
    Joined
    Aug 2015
    Posts
    510
    Pronouns
    they/them
    Userbars
    26
    Thanks
    1,723
    Thanked
    1,635/402
    DL/UL
    25/0
    Mentioned
    138 times
    Time Online
    59d 8h 56m
    Avg. Time Online
    27m

    Multiple Account Spreadsheet + Mini-Guide

    I made a neat little spreadsheet for my accounts for personal use and figured that others may have some use for it! I assume most people already have their own ways of logging their accounts & details but mine has checkboxes so

    This spreadsheet can be used to log accounts, account valuables, and make transfer logs to track what you send to and from which accounts on which dates so you don't accidentally send too many items! You can also use the checklist to check off dailies, Trudy's & food club for specific accounts!

    What you'll need:
    - Excel (lol)
    - Some very basic knowledge of Excel sheets

    Once you open the .xlsm file, allow macros for a easy reset of all the checkboxes using ctrl+r!

    Features:
    - Trudy's, Food Club & Dailies checklist
    - Account basics
    - List of valuables
    - Gifting / transfer logs

    1. Account basics + checklists: (click the image)
    (you need an account to see links)
    Fairly straightforward list. You can check off the boxes with a simple click and uncheck all checkboxes with ctrl+r if you've allowed macros!

    2. List of valuables:
    (you need an account to see links)
    Handy list of valuables with a counter for the total worth! You simply input the number and it automatically adds 'NP' at the end. Also has a neat link to the Jellyneo SDB pricer that'll help you estimate the worth of your valuables!

    3. Transfer Log:
    (you need an account to see links)
    Just a list to help you track when you sent what item! Includes a link to the guide by our very own |2eap in case you need it!


    The spreadsheet is in the attachments! It's a .zip file with 2 files in it: one blank sheet and one filled out with some examples for those who need it!
    Attached Files Attached Files

    (you need an account to see links)



    🌜 ALL YOUR STARDROP ARE BELONG TO ME ⭐✨
    hatched as drake: 01.11.2021


    Guides by me: (you need an account to see links) | (you need an account to see links)


    ty Dita ♥

  2. The Following 8 Users Say Thank You to Stardew For This Useful Post:

    Cookie Tray (03-26-2019),Daviid (03-08-2019),j03 (03-08-2019),Kaguya (12-26-2023),Mama Bear (03-08-2019),Menine (03-08-2019),♥ PrettySarcastic ♥ (03-08-2019),Stocking Anarchy (03-15-2019)

  3. #2
    Crazy Cat Lady PrettySarcastic's Avatar
    Joined
    Jun 2015
    Posts
    2,203
    Pronouns
    she/her
    Userbars
    56
    Thanks
    4,482
    Thanked
    6,589/1,483
    DL/UL
    47/0
    Mentioned
    392 times
    Time Online
    163d 17h 35m
    Avg. Time Online
    1h 13m
    This could probably be tweaked to work with Google Sheets, which is free v. paid Excel. I'll have to look at it. Thank you for this!! <3 How lovely.




    graphics by Flordibel & Menine <3

  4. The Following User Says Thank You to PrettySarcastic For This Useful Post:

    Stardew (03-08-2019)

  5. #3
    Stardew's Avatar
    Joined
    Aug 2015
    Posts
    510
    Pronouns
    they/them
    Userbars
    26
    Thanks
    1,723
    Thanked
    1,635/402
    DL/UL
    25/0
    Mentioned
    138 times
    Time Online
    59d 8h 56m
    Avg. Time Online
    27m
    Quote Originally Posted by PrettySarcastic View Post
    This could probably be tweaked to work with Google Sheets, which is free v. paid Excel. I'll have to look at it. Thank you for this!! <3 How lovely.
    Yeah I definitely considered Google Sheets but I'm not sure if the macros + checklist thing would work the same!
    I'm definitely more familiar with just Excel but I might look into it myself as well cause that's a really good idea

    Sent from my Nexus 6P using Tapatalk

    (you need an account to see links)



    🌜 ALL YOUR STARDROP ARE BELONG TO ME ⭐✨
    hatched as drake: 01.11.2021


    Guides by me: (you need an account to see links) | (you need an account to see links)


    ty Dita ♥

  6. The Following User Says Thank You to Stardew For This Useful Post:


  7. #4
    Saiyan Race
    j03's Avatar
    Joined
    Dec 2011
    Posts
    13,722
    Userbars
    166
    Thanks
    5,906
    Thanked
    33,077/6,608
    DL/UL
    23/36
    Mentioned
    3,867 times
    Time Online
    563d 5h 25m
    Avg. Time Online
    3h 13m
    Fantastic guide!

    Kinda off-topic from your guide, but after learning how to code in VBA, I found that it's very much possible to write a Neopets bot in Excel. It might be more useful as you can basically write to the sheet your dailies/AB/whatever results you get, appending to your stats/data. Kinda neat...
    (you need an account to see links)
    (you need an account to see links)(you need an account to see links)

    ------------------------
    [02/24/2013] Stealth CORE is made into the first standalone Neopets auto-player.
    ------------------------


  8. The Following 2 Users Say Thank You to j03 For This Useful Post:

    ♥ PrettySarcastic ♥ (03-08-2019),Stardew (03-08-2019)

  9. #5
    Stardew's Avatar
    Joined
    Aug 2015
    Posts
    510
    Pronouns
    they/them
    Userbars
    26
    Thanks
    1,723
    Thanked
    1,635/402
    DL/UL
    25/0
    Mentioned
    138 times
    Time Online
    59d 8h 56m
    Avg. Time Online
    27m
    Quote Originally Posted by Infamous Joe View Post
    Fantastic guide!

    Kinda off-topic from your guide, but after learning how to code in VBA, I found that it's very much possible to write a Neopets bot in Excel. It might be more useful as you can basically write to the sheet your dailies/AB/whatever results you get, appending to your stats/data. Kinda neat...
    Thank you! I was worried it was too simple to share.

    & That sounds like something I definitely need to look into, could make some fun stats and overviews with that
    I love tracking all the stats so that's a great suggestion Joe, thank you!

    Sent from my Nexus 6P using Tapatalk

    (you need an account to see links)



    🌜 ALL YOUR STARDROP ARE BELONG TO ME ⭐✨
    hatched as drake: 01.11.2021


    Guides by me: (you need an account to see links) | (you need an account to see links)


    ty Dita ♥

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •