Message:

<p>[QUOTE=&quot;Jaelus, post: 2981728, member: 46237&quot;]This is really great work, thanks.</p><p><br /></p><p>Some suggestions for future improvements:</p><p><br /></p><p>It would be nice if you added order data in a <i>row</i> instead of in those 2 columns, with the ability to add additional rows. You could get an automatic total for the cost of the order in that row, the per coin cost for the order in that row, and a columnar grand total for the entire submission and perhaps average cost per coin. It could be something like a block of say 10 rows to allow for up to 10 orders on the same submission to be calculated together. </p><p><br /></p><p>This would be handy, since they make you break up your submission by service type etc. I can count the number of times I&#039;ve only had <i>one </i>order on a submission by itself on zero hands. Most of the time I have <i>at least 5</i> (US, world, world gold, crossover, designation review, tokens/medals, etc.) all submitted together on one submission but broken up into different orders.</p><p><br /></p><p>The other reason for doing this is to support <i>ship with</i> submissions, where you have multiple orders with an instruction for them to wait to ship out together to save on shipping costs. This impacts the total cost, the actual shipping cost per order, and therefore also the cost per coin. It doesn&#039;t let you get an accurate picture of the costs if you&#039;re only looking at a single order in a vacuum.</p><p><br /></p><p>For example, if I&#039;m creating a submission to NGC consisting of an order with 9 coins and a total value of $1500 along with a second order with 11 coins and a total value of $500, and I do a <i>ship with</i> instruction on the entire submission, the total shipping cost will be $38, but your spreadsheet would tell me it is $61 since I have to enter them independently of each other, which throws off the total cost and cost per coin. I could enter the aggregate info of 20 coins worth $2000 to get the correct shipping, but since they will necessarily be different services, the fees will be different and it would still be incorrect.[/QUOTE]</p><p><br /></p>

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