Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Coin software Vs. Excel
>
Reply to Thread
Message:
<p>[QUOTE="EyeEatWheaties, post: 987408, member: 26972"]I am not familiar with your software. I would imagine you can export to CSV and then import into excel. whether or not it saves all the formulas would be a guess on my part. CSV typically puts all your data into Comma Separated Values at which point you can then import and then format, create new formulas and label..</p><p><br /></p><p>I use excel for tracking all my purchases. I am also adding coins that are in my collections that were handed down to me, mostly pictures. Its nice because I can create hyperlinks in the spreadsheet to the specific coin image in another folder. I also use the PCGS registry spreadsheet for certified coins which I am just now starting to load.</p><p><br /></p><p>Since I buy mostly from eBay, I copy info from my "won" page and paste it into excel and add other information and worksheets as needed. Excel offers a tremendous amount of flexibility and is relatively intuitive to repetitive formulas and functions. It allows me to have hyperlinks to the individual sellers. The only draw back comes from the fact eBay only stores completed listing for 60 days - so the hyper link to the actual listing only works for 2 months.</p><p><br /></p><p>Here is a section from my PCGS certified worksheet. Amongst the specific seller info. Accounting wise, I track what the item closed at, Quantity, shipping cost, total cost, and net gain from total cost to PCGS value.</p><p><br /></p><p><img src="http://i191.photobucket.com/albums/z242/papasteeze/Coins/ExampleofPennyAccountingSpreadSheet.jpg" class="bbCodeImage wysiwygImage" alt="" unselectable="on" /></p><p><br /></p><p>Hopefully this will give you some ideas and is helpful.[/QUOTE]</p><p><br /></p>
[QUOTE="EyeEatWheaties, post: 987408, member: 26972"]I am not familiar with your software. I would imagine you can export to CSV and then import into excel. whether or not it saves all the formulas would be a guess on my part. CSV typically puts all your data into Comma Separated Values at which point you can then import and then format, create new formulas and label.. I use excel for tracking all my purchases. I am also adding coins that are in my collections that were handed down to me, mostly pictures. Its nice because I can create hyperlinks in the spreadsheet to the specific coin image in another folder. I also use the PCGS registry spreadsheet for certified coins which I am just now starting to load. Since I buy mostly from eBay, I copy info from my "won" page and paste it into excel and add other information and worksheets as needed. Excel offers a tremendous amount of flexibility and is relatively intuitive to repetitive formulas and functions. It allows me to have hyperlinks to the individual sellers. The only draw back comes from the fact eBay only stores completed listing for 60 days - so the hyper link to the actual listing only works for 2 months. Here is a section from my PCGS certified worksheet. Amongst the specific seller info. Accounting wise, I track what the item closed at, Quantity, shipping cost, total cost, and net gain from total cost to PCGS value. [IMG]http://i191.photobucket.com/albums/z242/papasteeze/Coins/ExampleofPennyAccountingSpreadSheet.jpg[/IMG] Hopefully this will give you some ideas and is helpful.[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Coin software Vs. Excel
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...