How To: See Your Lifetime Amazon Tab (& Wallow in Your Painful Consumeristic Guilt)
How much you've actually spent and how much you think you've spent are usually two completely different results, and is especially true on Amazon when it's so easy to click and buy. You might think you've given Amazon a couple thousand over your lifetime, when the fact is that it's three or four times that amount.Well, thanks to a tip from Business Insider, there's a way to quickly and easily check your entire purchase history, for better or for worse.
Step 1: Request Order HistoryFirst, go to Amazon.com, hover your mouse over Your Account on the top right of the page, and then click "Your Account" on the drop-down menu. Then, under Order History, you should see "Download Order Reports"—click on that. You'll be taken to a page where you can request order history reports.Set the Start Date to January 1 and the year that you opened your account (it will be the earliest year listed in the drop-down). Then you can press the link next to End Date that says "Use today" to fill out today's date automatically. You can add a name to the report if you'd like, but it's optional. Click on the "Request Report" button to have Amazon begin amassing your history. It may take a little while to process, and Amazon will email you the report so you don't have to stick around.
Step 2: Download ReportOnce your report is done, you can download it on the Order History Reports page on Amazon, or through the link sent to your email. Save the file to your computer (it may automatically download as a CSV spreadsheet after the report has finished loading), then open it up your preferred spreadsheet software. I'll be using Google Sheets, but it'll work the same in Excel and Numbers.
Step 3: Calculate Amount SpentStart a new blank document, and then go to File -> Open. On the Open a file screen, click the "Upload" tab, then drag the Amazon report file into the dashed box, or click "Select a file from your computer" and choose the Amazon file in your directory. You'll now see a list of everything that you've purchased on Amazon, but we still need to pop in a quick formula to tabulate your total amount spent. Look for the column that says Purchase Price Per Unit (M). Now, highlight the cell directly under the last item on the list (or maybe two rows below, if you'd like some breathing room). Type in the phrase =SUM( in that cell and press enter/return, which will add up the values of the cells you select. Next, you'll need to choose the cells in the Purchase Price Per Unit column. Click on the first price in the list, and it will highlight in pale orange. Then, go down to the last price in the list and shift-click on that item. You should see the entire column range highlighted if you did it right. After that, just hit enter/return again, and there you'll have it—the total amount of money you've spent on Amazon.Example: =SUM(M2:M16) Of course, this total only applies to purchases as a single quantity. If you ordered more of the same item in the same order, you'd want to use a =SUMPRODUCT formula instead of the regular =SUM formula. This will multiple the price and quantity before adding them all up together.Type in =SUMPRODUCT( then shift-click to select the amount ranges in the Purchase Price Per Unit (M) column. Add a comma (,) then shift-click the same range in the Quantity column (N) and press enter/return to finish the calculation.Example: =SUMPRODUCT(M2:M16,N2:N16) There's plenty of stuff you can do with this data besides seeing your total amount spent. Like, you could go through your purchase history and ask yourself if it was worth spending $10 on a poster for a Nicolas Cage movie that maybe 14 or 15 people have seen.Who am I kidding? Of course it was worth it. Try downloading your own Amazon report, and let us know in the comments about the most ridiculous item you've purchased in your Amazon history.
Cover image via Shutterstock
CES 2015: Linx Headbands Can Keep You Safe from Permanent Head Injuries How To: Use lumbar support for sports injuries How To: Treat a pulled quad muscles in sports medicine How To: Give a sports massage How To: Give a lower-body sports massage
How to Make Barbie Headbands « Kids Activities :: WonderHowTo
Your OnePlus 5 or 5T will now automatically boot up into fastboot mode, and you can now plug it into your Mac or PC to input fastboot commands like unlocking its bootloader. Don't Miss: 4 Reasons the OnePlus 5T Is the Best Phone for Rooting & Modding in 2018
4 Reasons the OnePlus 5T Is the Best Phone for Rooting
TrueCaller is sharing your phone activity by revealing the last time your phone was and allows it to sync their contacts, their "Last Seen" time is visible in the application. This means your status would only update when you use the app. Charge: PSA Peugeot-Citroen to Offer Level 3
Just So You Know, TrueCaller Is Sharing Your Phone's Activity.
How to Reorder Profiles & Reset Matches in Tinder
In this video tutorial, viewers learn how to control which games can be played with Net Nanny. Begin by opening the program and select Manage Games under Games. Users will have 3 options on how to block or allowing the games.
Parental Controls: Can I enter *.* to block all websites
Most of us know how to add homescreen shortcuts to apps that already exist on our phones - just open up the app drawer, hold down on an app icon until you grab it, then drag it over to the homescreen of your choice. But maybe you want to create app-like shortcuts to specific folders, web pages, or
How to Create App Shortcuts on Android - Gadget Hacks
Make Apps Use the Entire Screen on Your Essential Phone
15 Best Hidden Google Easter Eggs and Games You Should Know 1. Starcraft . A game that will keep you entertained is Starcraft. To enjoy this game you only have to type in Zerg Rush and you will see how small Os will attack your search results.
How to play the latest Easter egg game hidden inside Google
There are plenty of tweaks, including a brand-new way to unlock the browser's hidden "dark mode" that pairs well with your application preferences in Windows itself.
Your iPhone 8 or iPhone X battery could wear out in 18 months. Wireless charging and fast charging might be a great solution to the pressures that more power-thirsty devices are placing on
How To: Tell if Your Android Has Been Hacked (& What You Can Do About It) News: Android Malware Disguised as Super Mario Run Targets Your Bank Account News: New Android Malware Is Emptying People's Bank Accounts—Here's How to Protect Yourself
Super Mario Run for Android Available for Download… as Malware
Make an App for Radio Stations Stream your playlist and take requests Design custom DJ profiles Make it easy for your listeners to engage with your radio station wherever they are. Easily stream your playlist via Apple and Android Streaming by entering your URLs. Improve your song list by taking requests via a mobile friendly online form.
FREE App Creator. Create Apps for Android without Coding.
You can add your texting Words & Phrases in left or right side of the clock, you can also you can also add custom words & phrases your status bar Samsung galaxy note 3, so many various cool things in your device with simple device. This app is 100% Working fine in many android devices without any issues.
Customize Your Status Bar to the Fullest - Samsung Galaxy
There seems to be no possible way to control the music player app in Android when the screen is locked. Although latest Android's Google Play Music app allows people to change or pause the song right from lock screen, this tutorial might be useful if you are having an old Android mobile.
0 comments:
Post a Comment