1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Optimus and Primus Hyperlinked Documents

Discussion in 'Stove Forum' started by shagratork, May 11, 2016.

  1. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    8,053
    Location:
    Durham City, England
    Do you spend a lot of time trying to find a particular stove in the Catalogues Forum?
    Do you also continue searching in the 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?

    I set out on a project to make this easier for me and would now like to offer it to you.

    I constructed a hyperlinked spreadsheet of Optimus and Primus stoves contained in all the documents currently on CCS.
    The double-spreadsheet is easy to use. Click on a date at the top of a column and you will go to the document. Click on a stove in the column and you will be taken to that stove within the document.

    I used the free 'OpenOffice' spreadsheet (Apache version can be downloaded here).
    If you use the free 'LibreOffice', the OpenOffice file works OK but the links may be highlighted in grey. To get rid of the highlighting go into the Office Preferences, Application Colors and change the 'Field Settings' to white.

    Note: for non-subscribing members the Catalogues entries will be unavailable.

    The spreadsheets are not perfect but they do allow individual users to personalise them.
    I hope you will find them useful.

    The OpenOffice spreadsheet:

    http://classiccampstoves.com/ccs_files/optimus_primus_catalogues_100516.ods


    How it should look and how it works is explained later in this thread here.

    Trevor
     
  2. Tony Press

    Tony Press Australia Subscriber

    Offline
    Joined:
    Jun 8, 2013
    Messages:
    2,580
    @shagratork

    :thumbup:! I won't ask how long that took!!!

    Cheers

    Tony
     
  3. Doug L

    Doug L United States Subscriber

    Offline
    Joined:
    Oct 1, 2010
    Messages:
    958
    Location:
    New York
    wow this sounds great
    I often thought the catalog pages should be in chronological order to make it easy to find production years on a particular stove, rather then going through all the pages.
    I realize this takes time and might be more work then its worth.
     
  4. Doug L

    Doug L United States Subscriber

    Offline
    Joined:
    Oct 1, 2010
    Messages:
    958
    Location:
    New York
    What is the best way to open these for those of us that don't have Office or Excel.
    I'm asked to download an app to get those documents.
    thanks
     
  5. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    8,053
    Location:
    Durham City, England
    Hi Doug

    They are too large to publish in PDF format and so the only way to display them is to have on your computer 'OpenOffice' or 'LibreOffice' (which are totally free and advert-free) or Microsoft Excel.

    The Apache 'OpenOffice' can be found here.
     
  6. Go Scout

    Go Scout United Kingdom Subscriber

    Offline
    Joined:
    Feb 15, 2016
    Messages:
    231
    Location:
    Bromley, England
    Trevor - have you been watching me or something? The first three lines of your post are exactly what I do.

    Can't wait to try it out later :content:

    So now it's finished, I could really do with a similar one entitled "How to fix ...."

    then you could link to all the sucessful fix it bits that aren't in the Fettlers Masterclass!

    Only joking of course! Great job and thanks for sharing - you're a star!

    Best regards

    Baz
     
  7. Caveman

    Caveman New Zealand Subscriber

    Offline
    Joined:
    Jun 21, 2014
    Messages:
    177
    Location:
    Tauranga, NZ.
    Awesome effort!

    Hi Doug, tablet or touch screen device? Try the Polaris Office app from the playstore if you are samsung/android.
    If you are iPlod then good luck, I know as little as possible about those introverted devices.
    Cheers
    B
     
  8. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    8,053
    Location:
    Durham City, England
    @Doug L
    Hi Doug, have a look here.

    Regards
     
  9. snwcmpr United States

    Offline
    Joined:
    Nov 16, 2011
    Messages:
    6,442
    Location:
    USA
    Trevor, I assumed that Doug meant the date of the catalog, not the date of the thread.
    @shagratork @Doug L
     
  10. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    8,053
    Location:
    Durham City, England
    @snwcmpr
    Hi Ken, yes I know what Doug meant.
    When a new catalogue is posted it creates a new thread.
    As long as the catalogue title starts with a date (i.e. numbers), then by ordering the threads on the title name (not the date) means also that the catalogues are put in order.
    I thought my tutorial made that clear.

    When sorting things alphabetically, computers put numbers in order before before the letters.
     
  11. OMC

    OMC United States Subscriber

    Offline
    Joined:
    Sep 13, 2013
    Messages:
    1,635
    Location:
    Illinois, the Land of lincoln
    Trevor,
    thank you thank you thank you very much

    The tip to sort catalogs by year is a good one, I'll be sure to check that out.

    I think my Open Office program was installed w/o spreadsheet capability. I'm on windows 7, I ended up reinstalling open office. It then opened your file, my 1st open office spreadsheet, no problem, it looks fantastic, thank you.

    That is a totally awesome spreadsheet you have created.
    I appreciate your efforts it had to have taken you quite a while.
    Great idea too, I have NO DOUBT it will be referred to regularly.

    I've been content w/the modest sized screens of my laptops & monitors but w/big spreadsheets like that (and wonderful big new CCS images) I think I'll be getting a bigger monitor !!!
    thx omc
     
  12. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    8,053
    Location:
    Durham City, England
    Hi OMC @OMC

    You have answered a question I asked elsewhere.
    With the spreadsheets, remember that you can change the size of what you see onscreen by going into the 'View' settings.

    Kind regards,
    Trevor
     
  13. gieorgijewski

    gieorgijewski Poland Subscriber

    Online
    Joined:
    Apr 19, 2013
    Messages:
    1,098
    nice work - for me very useful
    thanks for *.xls format
     
  14. The Bird

    The Bird New Zealand Subscriber

    Offline
    Joined:
    Oct 28, 2009
    Messages:
    527
    @shagratork,

    Hello Trevor,
    I opened the Excel Spreadsheet, and it came up as a Read-Only document. None of the hyperlinks work for me. In Open Office, I have nothing with which to open anything, as I don't have this program.

    Looks like a huge mission though, thank you for pulling it together, even with no links, it gives reference of where to go looking. That in and of itself is no mean feat!!!

    Best regards,

    Mike.
     
  15. snwcmpr United States

    Offline
    Joined:
    Nov 16, 2011
    Messages:
    6,442
    Location:
    USA
    @shagratork
    Yes, you did. But I did not read into it as you said. "IF" they are listed with the date/year as the first words in the title then the ascending order by title will result in a chronological ordering.
    Thanks for all the hard work.
     
  16. Spiritburner

    Spiritburner United Kingdom Admin Subscriber

    Offline
    Joined:
    Jul 23, 2004
    Messages:
    9,382
    Location:
    N.E. England
    It seems posts/files that require login won't allow excel to open.
     
  17. igh371

    igh371 United Kingdom Subscriber

    Online
    Joined:
    Jun 23, 2013
    Messages:
    579
    Location:
    North-East England
    @shagratork Hi Trevor, got the Excel version to load up fine; now knowing what you know about my computer skills I maybe should have asked you to sit down first before reading that:oops:.
    But the main point is WHAT AN ABSOLUTELY FABULOUS REFERENCE RESOURCE - phenomenal!:D
    (Hope you won't regret having to keep it up to date in future - thinks: 'rods' and 'backs':whistle:)
    Ian:clap:
     
  18. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    8,053
    Location:
    Durham City, England
    @igh371 Ian, I am pleased that you got the Excel spreadsheet to open, but other members have said that the hyperlinks within the spreadsheet won't work.

    It seems that members are having success with the OpenOffice version of the spreadsheet.
    I would advise all interested members to download 'OpenOffice' from here.
    If you want to know what OpenOffice is, then read here. It is a wonderful, free piece of software.


    For those who wonder what things should look like I have taken a few screen shots.

    Once the spreadsheet is loaded the window will have the stove numbers in rows on the left and dates of documents at the tops of the columns.
    All dates and all '' are hyperlinks.

    So you can click on a year at the top of a column.

    Spread1.jpg



    The whole document will then open in your browser.

    Spread2.jpg



    You can click on a in a column for a stove.

    Spread3.jpg



    That individual stove will then appear in your browser.

    Spread4.jpg


    That is all there is to it.

    Just in case you had not noticed it, the one document has two spreadsheets. One for Optimus and one for Primus.

    Spread5.jpg
     
  19. patatwin

    patatwin France Subscriber

    Offline
    Joined:
    May 11, 2015
    Messages:
    229
    Location:
    Metz, Fr
    it works fine for me, thank you for the informations gathering !
     
  20. shagratork

    shagratork United Kingdom Moderator Subscriber

    Offline
    Joined:
    Aug 9, 2005
    Messages:
    8,053
    Location:
    Durham City, England
    Hi @patatwin

    Are you using Excel or are you using OpenOffice?
     

Share This Page