Excel Taxes and Totals Calculator

All Site Suggestions or General Black Friday Tips

Moderators: Tony, cematra173, killasnake, Huy

petersmejia

Excel Taxes and Totals Calculator

Postby petersmejia » Fri Nov 16, 2012 1:58 am

Hello Everyone,

Download link: https://www.dropbox.com/s/jbkazfhm1azsk ... lator.xlsx

this is my first post, I hope people will get some good use out of it.

I created a simple excel sheet to help calculate your totals with tax and electronic waste fees.
I believe the electronic waste fee is only in use in California, but since I live here, it's included.
The item slots are limited, but I will change it and make more item slots this weekend and release an updated version.

You basically put in the item price, adjust for your sales tax and input the screen size if applicable for the electronic waste fee.
You will then get the different totals, to help make sure you have enough money on BF to get everything you want.

Anyways, I hope this helps! If it does help please comment to let me know you guys like it and to provide feedback.


Directions:

1) Type Product Name
2) Input Product Price
3) Input Screen Size for Product if Applicible
4) Correct Sales Tax in J5 for Local County
--------------------------------------------------------
B18=Subtotal for items
C18=Total Tax Amount
E18=Total Electronic Waste Fee Tax
B19=Absolute Total

Example on Sheet 2

Created By: BFADS.NET: petersmejia
Ver:1.0



Thanks,

Matt

Return to “Suggestions and Tips”

Who is online

Users browsing this forum: No registered users and 1 guest