My Excel, "Cameras at a Glance", and "My Lens Guide", have over 1000 individual formulas (each), to make them work properly. Those of you that know Excel and Access will know what I am talking about. These two sheets cross reference and check to see what cameras and types I have, and the Lenses sheet cross reference what lenses I have, what MM they are, and who made them. I actually have more lenses than cameras, but I haven't had the time to log them all in. All input goes into the Access input file first, and then is automatically transferred to the Excel spreadsheets. I probably could have done it all in Access, but I know a little more about Excel, and to me Excel is better for all the major calculations. If you have any questions, just post to me directly, if you like. It took me about a year all told to put together, but it was allot of fun to do! Let me know what you think.
