Scale Model Shop

Collapse

Its all a bit of a bind - one done, 50 to go ...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Airborne01
    • Mar 2021
    • 3976
    • Steve
    • Essex

    #31
    Excellent Peter! And with your skill set you were bound to succeed!
    Steve

    Comment

    • Jim R
      SMF Supporters
      • Apr 2018
      • 15704
      • Jim
      • Shropshire

      #32
      That index sounds amazing.

      Comment

      • JR
        • May 2015
        • 18273

        #33
        A work of distinction Peter. You must be chuffed at the outcome .

        Comment

        • Steven000
          SMF Supporters
          • Aug 2018
          • 2828
          • Steven
          • Belgium

          #34
          Amazing project Peter, well done! :thumb2:

          Comment

          • Peter Gillson
            SMF Supporters
            • Apr 2018
            • 2594

            #35
            Originally posted by Peter Gillson
            Hi Guys

            Jim - professional if you don't look too closely, especially the earlier ones which were a bit of a learning curve.
            Allen - no party, just modelling .

            I do already have an index. Something I started working on around the millennium - a large Excel spreadsheet; over 5,851 lines of data!

            Each line is an article in MM, the columns are for different characteristics of the article. Column 1 is the year; 2 the issue, 3 the title, and things like subject, unit century, year etc etc. the spreadsheet is storable by the columns, so I I want to find articles about the Crimean war I can sort by column H, the conflict which will show me the appropriate lines/issues.

            [ATTACH]464014[/ATTACH]


            Using multiple columns can refine things further, for instance using columns H (Nationality) + K (arm of service) + J (Nationality). I could see all of the articles relating to the German airforce in WW1, or WW2, British airforce in either war.

            [ATTACH]464015[/ATTACH]

            I doubt if it will ever be truly finished, about 2/3rd of the way through the process I added column O so that is not filled for the earlier years.

            Peter
            I just realised that I forgot to mention - if anybody would like a copy of this index spreadsheet, send me a pm and I will email a copy to you.

            Petrt

            Comment

            • Peter Gillson
              SMF Supporters
              • Apr 2018
              • 2594

              #36
              Cheers guys - I am quite pleased; both with the results and to have finished it!

              Peter

              Comment

              Working...