To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.lego.directOpen lugnet.lego.direct in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 LEGO Company / LEGO Direct / 397
396  |  398
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
    

Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR