Ebay Cost Spreadsheet (Download)

ukulele_ninja · 01-30-2008, 08:36 PM

Hey all, here is a link to download the Ebay Spreadseet Ive mentioned in a few threads. I began using it yesterday on my Palm T|X and it works fantastic! Basically, this well allow you to determine what your actual earnings are from seling an item on ebay after all ebay fees, actual shipping cost, and paypal fees are factored in. A few notes:

+Enter all numbers as whole numbers, not as negatives. excel will automatically subtract and add appropriate cells together.
+Leave the 'Actual Cost' cell blank if you dont know what you paid for the item originally. This space is more for people who purchase something with the intent of reselling it and want to see what their gain would be.

*Special thanks to Cosine who helped write the script that figures the appropriate ebay charges.

Heres the link to download from: http://www.megaupload.com/?d=GCTZO6ZL

Trizoy · 01-30-2008, 08:55 PM

When an item is not entered it doesnt cot $.20 .. It says it does.

I tried to enter another if statement, but it exceeds the max # of calculations..

ukulele_ninja · 01-30-2008, 09:08 PM

Well, regardless if you post something your out the cost of posting the item even if doesnt sell. I just sort of overlooked that as a minor issue, it does not add the unused amounts to your monthly totals.

Trizoy · 01-30-2008, 10:16 PM

If there is not item listed in a row, there should be no $.20 charge. and the totaled column is off by as many rows there are on that page *.20

ukulele_ninja · 01-30-2008, 10:30 PM

what about an IF statement that would say if the amount is less than .05, not to count it in the totals column? Apparently, just today ebay changed the pricing table, so version 1.2 is on its way anyway

Trizoy · 01-30-2008, 10:32 PM

Yeah you could do that, but you could not do it in the original function..

ukulele_ninja · 01-30-2008, 10:43 PM

Thats fine, it could be a part of the 'total' function. I guess ill have the revamped version out once i get the price tiers updated. I may add cells that reflect the listing options so you could put a 'y' or just leave blank to auto add the cost of different listing options.

01-30-2008, 08:36 PM	#1 (permalink)
ukulele_ninja Diamond Member Join Date: Jul 2007 Location: Ohio Age: 21 Posts: 2,160	Ebay Cost Spreadsheet (Download) Hey all, here is a link to download the Ebay Spreadseet Ive mentioned in a few threads. I began using it yesterday on my Palm T\|X and it works fantastic! Basically, this well allow you to determine what your actual earnings are from seling an item on ebay after all ebay fees, actual shipping cost, and paypal fees are factored in. A few notes: +Enter all numbers as whole numbers, not as negatives. excel will automatically subtract and add appropriate cells together. +Leave the 'Actual Cost' cell blank if you dont know what you paid for the item originally. This space is more for people who purchase something with the intent of reselling it and want to see what their gain would be. Special thanks to Cosine who helped write the script that figures the appropriate ebay charges. Heres the link to download from: http://www.megaupload.com/?d=GCTZO6ZL __________________ Do you remember when the tigers broke free? CF COD4: CF\|UkuleleNinja Last edited by ukulele_ninja; 01-30-2008 at 09:08 PM.*

01-30-2008, 08:55 PM	#2 (permalink)
Trizoy VIP Member Join Date: Apr 2005 Location: Campbell, Ca Posts: 4,647	When an item is not entered it doesnt cot $.20 .. It says it does. I tried to enter another if statement, but it exceeds the max # of calculations.. __________________ 01100110 01100001 01110010 01110100

01-30-2008, 09:08 PM	#3 (permalink)
ukulele_ninja Diamond Member Join Date: Jul 2007 Location: Ohio Age: 21 Posts: 2,160	Well, regardless if you post something your out the cost of posting the item even if doesnt sell. I just sort of overlooked that as a minor issue, it does not add the unused amounts to your monthly totals. __________________ Do you remember when the tigers broke free? CF COD4: CF\|UkuleleNinja

01-30-2008, 10:16 PM	#4 (permalink)
Trizoy VIP Member Join Date: Apr 2005 Location: Campbell, Ca Posts: 4,647	If there is not item listed in a row, there should be no $.20 charge. and the totaled column is off by as many rows there are on that page *.20 __________________ 01100110 01100001 01110010 01110100

01-30-2008, 10:30 PM	#5 (permalink)
ukulele_ninja Diamond Member Join Date: Jul 2007 Location: Ohio Age: 21 Posts: 2,160	what about an IF statement that would say if the amount is less than .05, not to count it in the totals column? Apparently, just today ebay changed the pricing table, so version 1.2 is on its way anyway __________________ Do you remember when the tigers broke free? CF COD4: CF\|UkuleleNinja

01-30-2008, 10:32 PM	#6 (permalink)
Trizoy VIP Member Join Date: Apr 2005 Location: Campbell, Ca Posts: 4,647	Yeah you could do that, but you could not do it in the original function.. __________________ 01100110 01100001 01110010 01110100

01-30-2008, 10:43 PM	#7 (permalink)
ukulele_ninja Diamond Member Join Date: Jul 2007 Location: Ohio Age: 21 Posts: 2,160	Thats fine, it could be a part of the 'total' function. I guess ill have the revamped version out once i get the price tiers updated. I may add cells that reflect the listing options so you could put a 'y' or just leave blank to auto add the cost of different listing options. __________________ Do you remember when the tigers broke free? CF COD4: CF\|UkuleleNinja

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to download files in web requiring input number array?	tinhochk	Internet Discussion	0	12-26-2007 10:07 AM
Selling Items on Ebay, never again!	Trizoy	Internet Discussion	15	09-08-2006 02:04 AM
PSU 101	Praetor	Computer Cases, Power Supplies and Cooling	6	07-14-2006 02:14 AM
eBay laptop purchasing	4W4K3	Laptop and Handheld Computers	13	05-31-2005 11:10 PM