Hyperlinked Documents of Swedish Manufacturers

Discussion in 'Stove Forum' started by shagratork, Mar 20, 2018.

  1. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    9,198
    Location:
    Durham, N.E. England
    * Do you spend a lot of time trying to find a particular stove in the 'Catalogues & Parts' section of the SRL (Stove Reference Library)?
    * Do you also continue your stove searching in Instructions, Advertising, Labels & Packaging and Documents & other ephemera?
    * Do you sometimes try and find the timeline of a stove, the date it is first mentioned in print and when it disappears from our documents?
    * Do you want to see how the features of a stove changed over time?

    I have constructed a spreadsheet document with hyperlinks to the stoves of all the Swedish manufacturers posted in the SRL on CCS.

    The spreadsheet was constructed using 'OpenOffice'. It will also work in 'LibreOffice'
    Both Office suites are Free, Open Source Software for PCs, Macs and Linux.
    Information and download of OpenOffice is here.
    Information and download of LibreOffice is here.

    Recently 'Google Sheets' has made an impact on Microsoft Excel dominance.

    The spreadsheet document can be opened in 'Sheets' on Android devices and there is a version for the iPad and iPhone.

    My computer is an iMac and I can use the spreadsheet successfully in the online version of Google Sheets.


    (Note: Excel will not allow hyperlinks to sites that require a login and so the hyperlinks will not work in Excel)


    The spreadsheet is not perfect. It was originally created for my personal use.
    You are welcome to use it, edit and personalise it.


    Restrictions: subscribing members will be able to use all hyperlinks in the spreadsheets.
    Non-subscribing members will be able to use all hyperlinks except those linking to 'Catalogues & Parts'.


    Updates: I will post further copies of the spreadsheet when new Swedish documents are posted in the SRL. Just look further down this thread and the updates will be clearly marked.


    Download the spreadsheet then open it in OpenOffice or LibreOffice or Google Sheets.

    https://classiccampstoves.com/ccs_files/swedish_companies.ods


    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -


    Using the Spreadsheets


    You must be logged into CCS.

    The spreadsheet document is composed of seven sheets covering all the Swedish Manufacturers in the 'Stove Reference Library'.


    Hyperlink_1.jpg


    The codes underneath the dates are:

    Cat – Catalogue & Parts
    Ins – Instructions
    Ad – Advertising
    L&P – Labels and Packaging
    D&o – Documents & other ephemera



    Clicking on a Date

    All dates are hyperlinks.


    Hyperlink_2.jpg



    Clicking on a date takes you to a page showing the whole Catalogue, Instructions, etc.

    Hyperlink_3.jpg



    Clicking on a Stove tick ()

    All 'ticks' are hyperlinks.

    Hyperlink_4.jpg



    When a stove tick () is clicked you are taken to the page that shows or mentions the individual stove.

    Hyperlink_5.jpg



    I hope you find this spreadsheet useful.
     
  2. Spiritburner

    Spiritburner Admin Subscriber

    Offline
    Joined:
    Jul 23, 2004
    Messages:
    9,996
    Location:
    N.E. England
    That must of taken many long hours Trevor! You are to be congratulated on the time & effort you put into that. I made a start on a similar spreadsheet about 10-12 years ago & it defeated me!

    Thanks for posting the tutorial - it will certainly help people get the most from it.
     
  3. OMC

    OMC Subscriber

    Offline
    Joined:
    Sep 13, 2013
    Messages:
    2,463
    Location:
    ILLINOIS
    Trevor, Congrats on an enormous job well done !
    WOW ! just WOW !
    An amazing research tool just got 5 times better.
    I've used it's predecessor and in coming days & weeks I'll dive into this latest release (much much bigger i see).

    It is a tremendously valuable time saving tool to streamline access to the site's complex content.
    If I compare researching without a spreadsheet
    to
    using your spreadsheet
    ...this is nothing short of an absolutely amazing breakthrough.

    The scope... it is enormous!!! There's no list (just a list) even close to how comprehensive your interactive spreadsheet is, anywhere.
    very much appreciated
    best regards
    mark
     
  4. Spiritburner

    Spiritburner Admin Subscriber

    Offline
    Joined:
    Jul 23, 2004
    Messages:
    9,996
    Location:
    N.E. England
    I've also placed a link at the top of the Stove Reference Gallery & am adding to all the Swedish sections.

    Capture.JPG
     
  5. Tony Press

    Tony Press Australia Subscriber

    Offline
    Joined:
    Jun 8, 2013
    Messages:
    4,399
    Location:
    Stinkpot Bay, Howden, Tasmania, Australia
    Excellent!

    Cheers

    Tony
     
  6. Trojandog

    Trojandog United Kingdom Subscriber

    Offline
    Joined:
    Feb 7, 2011
    Messages:
    2,276
    Location:
    East Sussex
    I raise my hat to you Trevor - Chapeau!
     
  7. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    9,198
    Location:
    Durham, N.E. England
    Google Sheets

    For members who want to use Google Sheets, here is some extra information.

    In the Open Office version I have used the 'Freeze Rows & Columns' so that the stove names, the dates and the type of publication always stay in view in the window when scroll is used. If this is not done the spreadsheet becomes very hard to use.

    When loaded into Google Sheets, the freezing disappears.
    However, Google Sheets lets you freeze rows and columns in the 'View' menu.
    If more information of this is needed I could create a small tutorial.
     
  8. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    9,198
    Location:
    Durham, N.E. England
  9. redspeedster

    redspeedster Subscriber

    Offline
    Joined:
    Jan 1, 2006
    Messages:
    2,368
    Location:
    County Durham
  10. IvanN

    IvanN United States Subscriber

    Offline
    Joined:
    Jan 10, 2016
    Messages:
    737
    Location:
    N.E. Oregon
  11. phaedrus42

    phaedrus42 Subscriber

    Offline
    Joined:
    Sep 5, 2014
    Messages:
    158
  12. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    9,198
    Location:
    Durham, N.E. England
    @phaedrus42

    Hi Phil, yours is a very interesting project. I hope you keep regular backups in case someone accidentally makes mistakes or wipes it!
    Your spreadsheet at the moment shows raw data. Do you intend to analyse the raw data and present it in a form that is easy to understand?
     
  13. phaedrus42

    phaedrus42 Subscriber

    Offline
    Joined:
    Sep 5, 2014
    Messages:
    158
    @shagratork , yes, I would eventually like to be able to statistically analyze the data to get an idea of how the features changed over time, what the geographical distribution is, etc.
    With Google sheets, one can fortunately roll back and revert to any point in the past if anyone does something nasty.
    I think we could learn a lot using the same system to gather data on other lamps and stoves.
    Even though I put up the template, the data belongs to the community and anyone is welcome to use it for their research.
    It could use the help of a spreadsheet wizard with the analysis and presentation in graphic form.
    I think we still need many more entries before we can draw accurate conclusions about this model.
     
  14. kerophile

    kerophile United Kingdom Subscriber

    Online
    Joined:
    Sep 23, 2004
    Messages:
    9,940
    Hi Trevor, I have just been using your Magnum Opus Speadsheet for some current research. It is a very impressive and useful tool.
    You certainly deserve a medal for this endeavour.

    I was able to use the spreadsheet to cross-check the availability of certain Optimus stoves, with my old-fashioned eyeball check of dated Catalogues etc. that I undertook earlier this week. So far we are in agreement.

    I will certainly be a regular user of your spreadsheets for my future stove research.
    Very well done!
    Best Regards,
    Kerophile.
     
  15. gieorgijewski

    gieorgijewski Subscriber

    Online
    Joined:
    Apr 19, 2013
    Messages:
    1,626
    Yeah...
    What about stoves not existed in reference library?
     
  16. Spiritburner

    Spiritburner Admin Subscriber

    Offline
    Joined:
    Jul 23, 2004
    Messages:
    9,996
    Location:
    N.E. England
    Capture.JPG
     
  17. ROBBO55

    ROBBO55 Subscriber

    Offline
    Joined:
    Oct 27, 2014
    Messages:
    605
    Location:
    Somersby, New South Wales, Australia
    @shagratork

    Bloody marvellous Trevor.
    Just been using your spreadsheet to date a Optimus 96.
    It made it too easy.:lol:
    Thanks
     
  18. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    9,198
    Location:
    Durham, N.E. England
    Update 2

    Here is the latest version of the spreadsheets.

    It includes Bo's 1931 Primus 70/71 catalogue, which meant adding extra No.71 models.
    There are also links to two sets of instructions for the Optimus No.5R, which were spotted by 'eagle eye' kerophile.

    https://classiccampstoves.com/ccs_files/swedish_companies.ods
     
  19. gieorgijewski

    gieorgijewski Subscriber

    Online
    Joined:
    Apr 19, 2013
    Messages:
    1,626
    o.k.
    @Spiritburner - You give me the answer...
    Today i found it:
    o15.jpg
    No 1I and 15 - We can ignore this information, or store them.
    If store - then thats ephemeric model need to be placed in the "any time line" near other - from the same time.
    IMO - We need "full list" of known types with "year" of productions.
    thats Hyperlinked doc... could realise thats.
     
  20. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    9,198
    Location:
    Durham, N.E. England