Subject:
|
Spreadsheet to order from Lego Direct
|
Newsgroups:
|
lugnet.lego.direct
|
Date:
|
Fri, 30 Jun 2000 02:03:09 GMT
|
Highlighted:
|
!
(details)
|
Viewed:
|
784 times
|
| |
| |
I used Jason Catena's very useful table of sets available from Lego Direct and
made an Excel 97 spreadsheet that calculates total cost of an order when you
fill in how many copies you want of each set, including discount and shipping.
It's at
http://www.brickshelf.com/gallery/hpatey/tools/ld_select.xls
It prints nicely on two letter-landscape pages as is, and if you know how to
autofilter, you can select Nonblanks in the "I Want" column to make a shorter
(perhaps!) list to read out into the phone. Hope someone besides me finds this
helpful; feedback appreciated.
Heather Patey
Pirate Wench / Brick Detective
St. John's, Newfoundland, Canada
|
|
Message has 2 Replies: | | Re: Spreadsheet to order from Lego Direct
|
| Heather, That is a really great spreadsheet! I hope you continue to upgrade and share it with the community as Lego Direct expands their product line (with real train doors & windows please!). It's funny... Using your tool, I came to the realization (...) (24 years ago, 30-Jun-00, to lugnet.lego.direct)
| | | Re: Spreadsheet to order from Lego Direct
|
| I've updated the spreadsheet I made to facilitate ordering bulk parts from Lego S@H, to include the new items from the holiday catalog. (URL) ought to work for both Excel 95 and 97 now; please let me know if anyone have trouble with it. Cheers, (...) (24 years ago, 26-Oct-00, to lugnet.lego.direct)
|
5 Messages in This Thread:
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|