Correction: I changed the spreadsheet to account for leap year! So February now goes to 29 instead of 28 in the dates section.
@timsiepker5382
8 ай бұрын
Just a quick update for your formulas you could use that would eliminate the need for the dates tab. This will also allow you to use this for any year without need to change anything, no matter how many days are in the month (Ex: Leap years having 29 days instead of 28 in February). This is the updated formula I used in cell B2 on the Acquisition Analysis tab. ARRAYFORMULA(countifs(Purchases!$E:$E,$A$21,MONTH(Purchases!$A:$A),1)) You would just need to change the 1 at the end of the formula to reflect the month you want to look at. This also locks the cell references (with the $), as mentioned in another comment below, so that when you copy them to new cells you don't need to update anything.
@freebread_
8 ай бұрын
You know you're in for a good video when Emily opens up Google Docs
@kevinmccartney4906
8 ай бұрын
Alright, I'll be _that_ guy. Sheets! 😂
@MissBubbles
8 ай бұрын
You are doing God's work on this channel. The transparency is so helpful especially for people like me who freak out when the sales are around lmao
@orbalology
8 ай бұрын
Thanks Bubbs 🥰 hope something like this tracking sheet can help you & others with bringing some perspective on our buying habits 😁
@MiamiSunrise
8 ай бұрын
I feel like I've just taken a relaxing Google Spreadsheets business class and I'm absolutely here for it. Excellent work on putting in the work for this video as well as the strength of organization and attention you pay to your own finances. I do not know but this may be the only video for this purpose like this on KZitem. Well done Emily, I got my copy of this!
@orbalology
8 ай бұрын
I don't think I've seen something like this in the gaming space yet, but I'm glad to contribute (& hopefully spur on some more about thoughtful collecting) ☺️
@MichaelH-1
8 ай бұрын
Hi Dr. Emily! You are truly the gaming focused spreadsheet Queen.
@qualitea_individual
8 ай бұрын
Ohhhhhhhh this spreadsheet makes my brain so happy wow. Phenomenal work, Emily-This is a work of art😭
@orbalology
8 ай бұрын
Thanks Alex! I have another one I'll be releasing soon for tackling the backlog :)
@jomolito
8 ай бұрын
You're recent videos about budgeting and recording costs with your collecting hobby have been super helpful and insightful. Thanks for tackling this topic as it's one not covered too frequently, but one that is relevant to game collecting or any hobby. Keep up the great work!
@orbalology
8 ай бұрын
Glad to hear these videos have offered some valuable insight :)
@jarathen1625
8 ай бұрын
GOTY 2024 is organizing your library and purchases. These are great ideas to enhance my own Excel doc. Great project.
@mrbinxkitty
8 ай бұрын
I was trying to make my own spread sheet to keep a better eye on my game purchasing habits for this year but really struggled as ive never made one before. This is so crazy helpful thanks SO much Emily! I definitely will be using the template youve made! I really want to keep under a strict $ amount monthly, especially since i got a little carried away this past holiday season with all the sales 😅
@orbalology
8 ай бұрын
Happy to help! Best of luck with your strict budgeting this year :)
@danbe6280
8 ай бұрын
I enjoyed this video more than some tops, reviews, or other videos from KZitem, which focused more on the videogames themselves. It was really fun to watch.
@alondite8
8 ай бұрын
Your personally-crafted resources are always much appreciated. Thank you for the hard work. The "Double Dip" column is hilarious; I think that's 70% of my games.
@PaisenNoticedYou
8 ай бұрын
This is a great idea, but it would give me such anxiety 😅 I’m sure this’ll help out a lot of people though, so thanks for sharing!!
@fern4real733
8 ай бұрын
It's always a great day when Emily uploads 😊
@davidhall2018
8 ай бұрын
I love this video! Not only am I a videogame nerd, I am also a self-professed Excel geek! Yeah, I know you’re using Sheets but they are 99% the same. I am planning on diving into your spreadsheet and seeing what I can learn from how you approach things. It looks very organized which will undoubtedly be a huge plus for me! Thank you!
@orbalology
8 ай бұрын
I'm not that advanced when it comes to working with Excel, but it was fun looking up some functions and making this spreadsheet aesthetically pleasing & easy to navigate :)
@stephengoodman9058
8 ай бұрын
This isn't something you'd see on many gaming channels, but it's good to see you doing something different to the others. I have a strict policy of not using spreadsheets unless someone's paying me to but its a great idea for the more organised among us 😄. It's so easy for hobby spending to go kaka if you take your eye off of it. One of my other hobbies is scale modelling and I often look at the triple wardrobe* full of unbuilt kits and wonder how much they add up to, then I decide I'd rather not know. *plus some boxes in the garage 😔
@axe1ruleZ
8 ай бұрын
Thanks for sharing the Google Doc file. I'm thinking of using this to keep track of video games, Blu-rays, and figures I purchase this year.
@orbalology
8 ай бұрын
These trackers are great for all sorts of hobbies! Hope this template helps with customizing yours 😁
@jean-lucclark7598
8 ай бұрын
Great video @Orbalology ! Thank you for making a copy of this document. I’m excited to do my own future audits now. Hope you’re having a good day!
@orbalology
8 ай бұрын
Hope your audit goes well for this year :)
@DrGamingPlays
8 ай бұрын
That is really cool that you are providing this to people. I should start keeping track as I haven't gotten much this year to cut down on the "why did I get this again?" I may add a Y/N FOMO purchase column as it is probably good to keep track of that (internally, I think we know when it is a FOMO purchase). Many bonus points for that Sky SC music playing in the background.
@brees3392
8 ай бұрын
Thank you for your hard work! I've already started mine, and I edited a version for my books purchases. :)
@90shandheldgamer
8 ай бұрын
This video came at the perfect time because I'm definitely planning on buying/ spending less on video games this year. I maybe should stay off twitter though because seeing pics of those beautiful analouge pocket screens is tempting me.
@orbalology
8 ай бұрын
The Twitter deals & fomo is real! May be best to limit your time over there (something I've been considering as well 😅)
@MegamanNG
8 ай бұрын
I'm going to have to take full advantage of this.
@tonyp9313
8 ай бұрын
Hi Emily. I'm really happy that your eyes are alright & better. I really love your spreadsheet. I'll be honest with you, I've never seen any gaming channels I watch do a spreadsheet. I am more connected with you now watching this spreadsheet of yours because I want to minimize my spending & also I am curious now on what you will be buying & spending throughout the year.
@orbalology
8 ай бұрын
I'm feeling much better, thanks! And I'm glad to hear the spreadsheets look useful for you. I'm looking forward to sharing how my year goes with this tracking too 😄
@chocomatt12
7 ай бұрын
I've just discovered your channel today. Not only are you a gaming nerd but a spreadsheet nerd. I love it. Keep up the great work 👏👏
@orbalology
7 ай бұрын
Thanks! haha
@klarci9464
8 ай бұрын
Thank you so much, Emily. I was just about to make my own google spreadsheets. Saved me a lot of work 😅
@orbalology
8 ай бұрын
Glad I could save you a bit of extra leg work :)
@flippingtheswitch
8 ай бұрын
Honestly Terrified to do this after my Doordash Audit. But now you have me Curious! Gonna have to do it!
@orbalology
8 ай бұрын
Yay! Hope you find tracking this useful (& insightful) 😊
@angietrif
8 ай бұрын
Super helpful video! I just made a spread sheet, with my backlog as well as one with all my purchases I make! It helps to be organized!
@orbalology
8 ай бұрын
It does! Spreadsheets can be great tools especially in the hobby space.
@shawngoral3987
8 ай бұрын
Do you really collect for the Sega Pico🤩? My first thought was "That is a name I haven't heard in long time." Then Trash! 🤣 LOL! Good job on the spreadsheets and thanks for the personal finance video a few months back. People under utilize the real power of spreadsheets. I've only seen a few people really use a spreadsheet like a pro in the past at my organization.
@saddack
8 ай бұрын
Thank you for the Purchase Tracking Spreadsheet template. This will certainly help with my video game spending.
@j2daoeGaming
8 ай бұрын
Thanks to you, this is the first year I’m keeping track of my purchases. It’s so helpful
@orbalology
8 ай бұрын
Best of luck with all your tracking this year!
@maths34
8 ай бұрын
Definitely going to use this this year. It’ll be fun to see the numbers at the end of the year but hopefully it’ll also slow me down during the year if I go a little overboard, great idea
@cozyfeji
8 ай бұрын
This is PHENOMENAL! I’ll definitely be using this spreadsheet!
@orbalology
8 ай бұрын
Aww yay! Would love to hear how your year goes if you would like to share 🥰
@Kiara.step-daughter
8 ай бұрын
you know, spread sheets always overwhelm me, but this one is very interesting and easy to follow.
@orbalology
8 ай бұрын
Glad to hear this was easy to follow!
@Kiara.step-daughter
8 ай бұрын
@@orbalology 🤍
@joeynolan304
5 ай бұрын
Lol you're so organized. I'm like obsessively organized myself. I get such "teacher" vibes from you lol. Were you a teacher ever?
@Skuttzor
8 ай бұрын
Thank you for sharing! I am going to do my best to keep track of my spending habits for the next year, and see if it can temper my self control a little. I hope you have a happy year of gaming :)
@orbalology
8 ай бұрын
Thank you! And happy tracking to you too :)
@statesminds
8 ай бұрын
I will be making half the money almost this year so I gotta cut back for sure lol
@JustinCardiff
8 ай бұрын
I use an app on my phone to track all spending, have about 10 years of data. If I look at the total spent on things like games or technology over that time, it’s scary numbers!
@SuperSaiyan2NahumKai
8 ай бұрын
Having a Spreadsheet to track the games that you buy is a brilliant idea which is also a good way to learn to organize. I think i might implement that idea into future purchases.
@bobbymoss6160
8 ай бұрын
Amazing video Emily! Thank you.
@MrNineties
8 ай бұрын
29 days in feb this year, Emily! Love the vid take care
@orbalology
8 ай бұрын
Great catch! Thank you.
@infernofoxgaming10
8 ай бұрын
EXCELLENT topic, and great tools to help us spenders of video games! Also appreciate the detail you had in explaining the concepts.
@orbalology
8 ай бұрын
The devil's in the details as they like to say 😂 I hope lots of folks find this spreadsheet helpful ☺️
@daviddonnell2153
8 ай бұрын
I can’t really keep track of what I spend on games because I don’t spend much when I have two kids and most of the games I get are from yard sales. They are cheap cheap cheap 😊
@thompsonpatrick79
8 ай бұрын
Number 2! 😂
@two-nichegaming4482
8 ай бұрын
I hate to be a negative Nancy but I am curious about your: total shipping and duties paid, total expired Nintendo gold points from not opening sealed games, and purchase periods comparing when the game was released to when you acquired it. Knowing how important the information in this spreadsheet must be to you: how many backups of it do you have, and how do you store your master copy? External Hard Drive or Micro SD?
@FullMetalB
8 ай бұрын
Please save me from the Unicorn Overlord collectors edition lol. The dang card game included is gonna get me!
@orbalology
8 ай бұрын
I have a few friends who are always tempted by limited editions that include card games inside. I on the other hand usually avoid them because I know I'll unlikely ever play them 😅 Unicorn Overlord looks like a really neat game nevertheless.
@PostModernCereal
8 ай бұрын
I feel like I don't need a spreadsheet to know that I overspent by a lot, but I can always use them in the future to avoid it. Thank you for providing a copy and template!
@orbalology
8 ай бұрын
Hope this spreadsheet can help curb some of your spending if that's one of your goals this year 😄
@robinsegers7985
3 ай бұрын
I'm scared 😢 but since I think I beat your 2024 update video just in last month... 😅
@vlogginggamingandcoding
8 ай бұрын
You must be popular at work for all that exceling. My next buy will be Final Fantasy Rebirth because it's only next month away and I like Honkai: Star Rail and FF Pixel R.M. Collection so no need to start spending more.
@kupomogli
8 ай бұрын
Charts and statistics, an RPG fans best friend. It's a good video, I just wanted to make a joke.
@ChuckieT266
8 ай бұрын
I went on a spending spree.. I am being super strict this year.. except Tekken 8.. and FF14 Dawntrail 💀💀
@orbalology
8 ай бұрын
Best of luck with your buying for the rest of the year!
@mikewhite8663
8 ай бұрын
Hello Emily
@michaellacunza6567
Ай бұрын
❤❤❤
@AlexanderShelestov
8 ай бұрын
Do you use any web. services or applications to track your collections?
@orbalology
8 ай бұрын
I prefer entering things by hand than using apps. It helps make me a bit more conscious about which games I add to my collection.
@AlexanderShelestov
8 ай бұрын
@@orbalology Feel the same. But I've just started and my collection has more than 1,000 games. So I'm seeking a way to automate it somehow :)
@Salazarnaruto52
8 ай бұрын
If I preordered something from PlayAsia in December and it arrives in January, would that be a 2023 purchase or a 2024 purchase? Just curious
@orbalology
8 ай бұрын
I would mark it for whenever your payment went through! So if you paid for the items in December, that's part of last year's budget (imo).
@jordanshannon8830
8 ай бұрын
I already have 14 games pre ordered in the first 3 months I failed already at cutting back 😭
@orbalology
8 ай бұрын
There's still 11 more months! Don't count it as a failure just yet :)
@jordanshannon8830
8 ай бұрын
@orbalology thank you 😊
@calex9398
8 ай бұрын
☺✌
@pstalcup117
8 ай бұрын
Just a tip for the future - if you want to be able to drag cells and have them point to specific cells, you can use the $ notation like this: A$22. (With $A$22, it will always point to the same cell no matter where you move the cell. With $A22, it will always point to the same column. With A$22, it will always point to the same row)
@alondite8
8 ай бұрын
I read all that in an Indian accent.
@orbalology
8 ай бұрын
I don't use Google sheets too often, thanks for the tip!
@kevinmccartney4906
8 ай бұрын
Thanks for noting this
@PatChatGC
8 ай бұрын
Im a big fan of turning your hobbies into over detailed spreadsheets, and so I am looking forward to the end of 2024 / beginning of 2025 when you review your "completed" spreadsheet 😅
@eliotwildermann
8 ай бұрын
Damn u are super technical this is very kool me i would just meh it when it comes to spreadsheets and documents I'm way to lazy for that 😅
@Multipurpose_Bagel
8 ай бұрын
Wow, way more in depth than mine. I just have separate Google documents for each console's digital purchases, and one document for all physical purchases, grouped by console, all in alphabetical order.
@Xx_Azura_xX
8 ай бұрын
Thanks for sharing this Emily! I’m sure this will help me a lot to track everything. I’m excited to test it this year 😊
@orbalology
8 ай бұрын
My pleasure! Best of luck with all your tracking this year :)
@rhythmandblues9302
8 ай бұрын
I sat down shortly before my daughter was born - knowing that I would soon have **no time whatsoever** - and made a spreadsheet of all my digital download purchases. I gathered all sorts of interesting insights - for instance, that on average I buy a game 1.7 times (across a total of six formats). I knew that I’d bought duplicates in the past, but I didn’t realise before exactly how much of a weakness I had for it. And I’ve not bought a duplicate since…
@sojannedos
8 ай бұрын
Thank you so much for this informative Video! It definitely inspires me to keep track of every game purchase I make this year. Love it!
@adamdam
8 ай бұрын
I applaud this overlooked part of collection, because its the darkside of compulsive behaviors linked to collecting.
@Bowflex2480
8 ай бұрын
thanks for this Emily. bubbz took the words out of my mouth, these videos' have been really helpful in helping me keep track of all my stuff. god's work indeed.🙂🙂
@orbalology
8 ай бұрын
I'm glad to hear that the videos in this topic have been helpful! ☺️
@n3r0n3
8 ай бұрын
all right I think it is pretty clear u come from a scientific background and I don't even know what I bought yesterday ;) I download it tho thank you looks super!
@dsage2507
8 ай бұрын
It won’t last forever. Even if you spend at least $10k-20k or so building up your collection (like I think I did), things will level off, and you’ll have what you want and will just be adding new stuff as it releases or maybe the occasional grail here and there. Budget accordingly and enjoy!
@XeikZone
5 ай бұрын
I buy games as the fitness way of life. When I want volume I bulk then I cut. Same for the gaimz...I bought them all then I have a cutting season where I don't buy anything at all. That's it, keep grinding.
@WolfBitOdyssey
8 ай бұрын
Definitely appreciate the better mic you use here. You are helpful. You have a real calming voice. I like you’re organizing systems
@NCSUWolfpacker2010
8 ай бұрын
Nice spreadsheet. Will use it to keep track of my game purchases this year. Although I had to tweak the list to go up to like 150 games lolol. Considering I only beat 26 games last year. Maybe I shouldn’t buy so much? Nah I still will.
@chocolocojames213
8 ай бұрын
Wow, this is impressive. I've learned there is something very zen about fighting FOMO 😊😊😊
@damikki
8 ай бұрын
If someone told me I would be enjoying a video on google sheets I would laugh at them but I really did enjoy this :)
@omyguzman1796
8 ай бұрын
Thank you!! I start using it you made it fun and easy. Very helpful!! 😉
@MichaelH-1
8 ай бұрын
My annual gaming budget plan: act like I'm not buying as much stuff as I am :)
@_bring2light
6 ай бұрын
Love it. now im going to be down a rabbit hole customizing it.
@christophermonzon8883
8 ай бұрын
These comments are great. Emily is amazing.
@limitlesschoices
5 ай бұрын
You should go on Caleb Hammers show.
@jasonsumma1530
8 ай бұрын
How do you sell a DLC? I suspect anything digital can't be sold. Do you buy from places like Walmart, Target, or Vintage Stock? I don't know if you have a Vintage Stock\Entertainment Mart in your area. Vintage Stock\Entertainment Mart are usually more for used games including the older systems. They also take the hardware. I suspect you got at least one Walmart and\or Target in the area. I really enjoyed this video and learned a few things that I may have forgotten. How did you get so efficient in Excel?
@orbalology
8 ай бұрын
You probably can't sell dlc easily unless you get it on steam during the return window. I sometimes buy from those stores but I almost always have to shop online because I don't have many local options near me. And the ones I do have a very limited gaming selection. Excel I use a little in my work, but I looked up a few things on Google while putting this spreadsheet together.
@JoelCaraway-w7g
7 ай бұрын
This content was made for me.
@OneUpWill
8 ай бұрын
Holy sheet, this is outstanding! ...got any more? You know, for backlog management, collection tracking, etc.
@orbalology
8 ай бұрын
I may have a backlog spreadsheet coming later this month :)
@234trhbgfdert
8 ай бұрын
Fev in this year go until 29
@christianallen3832
8 ай бұрын
Love these budget videos!!
@coletrondeluxe
8 ай бұрын
another great video emily, as someone who needs to control his spending this will help lol would you ever be open to doing another switch collection video showing us you undated library?
@orbalology
8 ай бұрын
I've been thinking of sharing some updates on certain collection videos - my Switch collection has greatly changed since my last video :)
@Sarothias
8 ай бұрын
This is awesome and thank you so much for sharing :) Personally I don't use Google docs. Do you (or anyone really) know how to make it keep formatting in excel? I go to File / Download / excel to download a copy and convert it to an excel spreadsheet. The problem is it just leaves each page as the straight text currently shown on the Google doc. All drop down menus are gone completely. Is their a way to work around this or would I basically just need to recreate it? Admittedly I might be jumping ahead lol. I'm about 6 minutes into the video so far :)
@orbalology
8 ай бұрын
I looked into it and it looks like some functions on Sheets do not convert to Excel sadly. But you can use similar code if you reference sheets to recreate in Excel if that's your preferred platform. What I like about Sheets is that it automatically is saved to the cloud so I can pull it up on my phone or computer anytime.
@Sarothias
8 ай бұрын
@@orbalology Wow, thank you so much for taking the time to look into this! Same results I found but was hoping I was just overlooking something haha. Yeah, I prefer excel but could make an exception in this case. Thank you again! You're awesome
@garrettlee8206
8 ай бұрын
I love you
@MichaelH-1
8 ай бұрын
What games are you looking the most forward to in the coming months?
@orbalology
8 ай бұрын
I just have a few preorders I'm committed to this year that I covered in my last video. Hoping I won't be too tempted and wait for the rest I'm interested in to go on sale before picking them up 😅
@aqlandmirrorvideogamerandc2983
8 ай бұрын
I've been waiting for you to upload today as soon as I saw your announcement. Your videos on these are very informative and also entertaining and very useful. I know I spend a lot of games for sure 😮😊.
@orbalology
8 ай бұрын
I hope you find this spreadsheet helpful! 😄
@nichifix
8 ай бұрын
Thanks so much for this. Collecting games has always been a fun, but pricey pastime. Its nice to have an easy tool to help put into perspetive how much money I annually spent on this hobby.
@orbalology
8 ай бұрын
There's always a fine line to walk with expensive hobbies like this! Glad to hear this is an easy tool to help put some things into perspective :)
@Zaxtur
8 ай бұрын
Now in glorious 4K! Lookin' great!
@disappearingrich6968
8 ай бұрын
I usually never comment on videos but thank you! I'm someone who budgets, but just puts video games under my "fun budget". I realized at the end of last year I have no idea how much gaming took from my fun budget so this will help a lot.
@orbalology
8 ай бұрын
Thanks for commenting! Last year I only made a 'gaming' category in my monthly budget sheets so I'm looking forward to seeing how these added categories may influence my buying habits.
@sonoftheredfox
8 ай бұрын
Emily, you just helped me take things up a couple of notches. Thanks for taking the time to share this with al of us, but especailly for doing the legwork on the backend to set this whole thing up. It's much nicer looking than the thing I had cobbled together. Thankfully it's the first of the year, and the perfect time to start using it!
@orbalology
8 ай бұрын
Glad I could offer some cool tips! Best of luck with this year's tracking 😄
@JackieFuckingChan
8 ай бұрын
Hi Emily. Hope you're doing well. You look amazing in this video. Not sure if you've done something different with the lighting, but it looks great. Keep up the great work. Love your videos and friendly demeanor
Пікірлер: 145