PDA

View Full Version : Multiple Account Spreadsheet + Mini-Guide



Stardew
03-08-2019, 02:30 PM
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 :rolleyes:

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! :D 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)
31424
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:
31425
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:
31426
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! :)

PrettySarcastic
03-08-2019, 04:43 PM
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.

Stardew
03-08-2019, 05:16 PM
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

j03
03-08-2019, 05:54 PM
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...

Stardew
03-08-2019, 06:33 PM
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