Feanor23x wrote:And while we're on the subject, is there any way that we could get these various collection files/tools hosted on the Acaeum?
Feanor23x wrote:I'm working on an Excel file too, with separate pages for OD&D (1974), D&D (1977), AD&D (1977), D&D (1981), D&D (1983), AD&D (1989), D&D (1991), AD&D (1995), AD&D (2000), and AD&D (2003). I'm grabbing data from a copy of the TSR Average Auction Price Guide, the Acaeum, the TSR Archive, and the Complete Dungeons & Dragons Product List.And while we're on the subject, is there any way that we could get these various collection files/tools hosted on the Acaeum?
bclarkie wrote:Feanor23x wrote:I'm working on an Excel file too, with separate pages for OD&D (1974), D&D (1977), AD&D (1977), D&D (1981), D&D (1983), AD&D (1989), D&D (1991), AD&D (1995), AD&D (2000), and AD&D (2003). I'm grabbing data from a copy of the TSR Average Auction Price Guide, the Acaeum, the TSR Archive, and the Complete Dungeons & Dragons Product List.And while we're on the subject, is there any way that we could get these various collection files/tools hosted on the Acaeum?Foul actually already has those links on the links page from the site as well as several others :http://www.acaeum.com/Links/Resources.html
deimos3428 wrote:beyondthebreach wrote:This reminds me of a question I have. I use excel to track all my sales, however, I have been wondering for some time how you can add a "drop down arrow" feature to a cell so that it can be used for multiple formulas (i.e. you click the drop down which lists two or more possible formulas and select which one you want to the cell to use).Every time I think of it, I get bored trying to navigate through the miasma of Excel "help". This would aid me greatly in computing the cost for Paypal fees (domestic vs. international) and ebay fees when the sale goes above $25. For years I've been manually changing the equations when these situations come up.thanks!!!Well, depending on the complexity you're looking for, you might be able to accomplish this with the "IF(<test>, <true>, <false>") function, something like:+IF(A1 < 25, A1*0.1, A1*0.3)In other words, if the value in cell A1 is less than 25, place 10% of the value of A1 in this cell, otherwise put 30% of the value of A1 in this cell. (I'm not recommending those numbers, it's just an example. You could use constants as well, depending on how you want to charge shipping, I leave that for you:+IF(A1 < 25, 5.5, 8.5)
beyondthebreach wrote:This reminds me of a question I have. I use excel to track all my sales, however, I have been wondering for some time how you can add a "drop down arrow" feature to a cell so that it can be used for multiple formulas (i.e. you click the drop down which lists two or more possible formulas and select which one you want to the cell to use).Every time I think of it, I get bored trying to navigate through the miasma of Excel "help". This would aid me greatly in computing the cost for Paypal fees (domestic vs. international) and ebay fees when the sale goes above $25. For years I've been manually changing the equations when these situations come up.thanks!!!