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
Android Volume Button Secret Tricks Change Android Volume keys settings to control your Torch Light and also use volume keys android as to lock your apps.. Android Secret Code to Increase
2 Ways to Block the Volume Buttons on Android
Include your watchOS version, iOS version, a clear explanation of the issue, and Steps taken to resolve so far. Contact Apple Support for assistance. Posts must be relevant to the subreddit. Submissions must be about Apple Watch or Apple Watch related accessories/topics. No "six degrees of Apple Watch" Non-question posts must foster discussion.
Apple Watch - Close Your Rings
SoundCloud is a great platform for budding artists, but it can be pretty hard to discover new music and underground artists. We show you how to do that.
Free-Music-Download.net Online Music
If you want Install custom ROM on your HTC Hero, remove pre-installed apps from your HTC Hero, Install and use ROOT apps, Install Custom recovery on your HTC Hero, Change the IP of your device, Change the font of Android… In this article, we offer you the easiest way to HTC Hero.
How to Install A Custom ROM On Any Android Device (2019
Here are some typical problems you may encounter on your Android tablet and some suggestions for a solution: General trouble: For just about any problem or minor quirk, consider restarting the tablet by turning it off and then turning it on again. This procedure will most likely fix a majority of the annoying problems you encounter.
How to Fix the Most Annoying Things in Windows 10. (Windows 10 may also change this setting back; you'll still get a dialog box confirmation with a yes/no option when you install things. 4.
How to reset the Photos App Delete option in Windows 10
My Samsung Galaxy s8 has 32gb of Internal memory. How did you get 52gb of internal storage or is that a mis key ? The phone itself will tell you what is taking up its internal storage and offers ways of cleaning it. Settings > Device Maintenance > Storage. Your phone allows the movement of certain apps from internal storage to Sd card.
How to move apps to SD card on Galaxy S8 and Galaxy Note 8
It seems obvious that the two services should work together — at least, that appears to be the frame of thought behind Netflix Rate: a Chrome extension which adds IMDB and Rotten Tomato ratings
What Is On Netflix? Uses Rotten Tomatoes and IMDB to Help
Online store
Live Snap Love | Photography Tips | Take better pictures of your family, their children, and the world around you. Grab the 90 day Learning blueprint! www
How to make a homemade battery with stuff you find around your house: lemon juice, copper wire, nails and light a LED with your vinegar battery!
How to make a Vinegar Battery - YouTube
The famous Flappy Bird (technically Flappy Droid) game is still around in Android 9.0 Pie. First introduced in 5.0 Lollipop, the game was originally the version number easter egg for the new Android update. But after Android Marshmallow, Google began to hide it from its usual location, and Pie continues this tradition.
Brian Lang's Profile « Wonder How To
0 comments:
Post a Comment