Topic

Anyone Got a Google Docs or OpenOffice Spreadsheet Template?


Forum Posting

A Membership is required to post in the forums. Login or become a member to post in the member forums!

Home Forums Gear Forums Gear Lists Anyone Got a Google Docs or OpenOffice Spreadsheet Template?

  • This topic is empty.
Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • #1288662
    Jack Elliott
    Member

    @jackelliott

    Locale: Bend, Oregon, USA

    Back in 2003 I hung up my backpack for what I thought was gonna be for good. But recent weight loss and a painful ankle fixed by fusing got me back into the activity.

    It's time to start a new gear list.

    Online services, such as geargrams and WeighMyGear are less attractive to me for the reason that the online service back in '02, '03 has vanished, taking all my inputted weights with it, and I have no confidence that any of today's services won't do the same thing.

    I'd like to find a Google Spreadsheet template to use for calc'ing weights, etc. Google Docs can be accessed anywhere there's an Internet connection.

    If there isn't a good Google Spreadsheet template then OpenOffice would be my next choice as my Linux computer doesn't run Excel.

    #1866864
    Steofan M
    BPL Member

    @simaulius

    Locale: Bohemian Alps

    Geargrams.com is a great site. I'll look through my google docs tonight if you still need one… the boss says that google is an unauthorized site here at the office!!

    #1866884
    Aaron Spjut
    BPL Member

    @aspjut

    Locale: Southern Oregon

    Hi,
    I'm the creator of GearGrams. I totally understand not wanting to trust your data with GearGrams or any other site. I just wanted to let you know that in GearGrams you can export your gear lists to a CSV file which can be imported into excel or any other spreadsheet program (or back into GearGrams). This is basically GearGram's version of a back up.

    #1866905
    Jack Elliott
    Member

    @jackelliott

    Locale: Bend, Oregon, USA

    "[…] in GearGrams you can export your gear lists to a CSV file […]"

    Oh. Well. That's a whole 'nuther story. I'll check it out!

    #1866995
    Jack Elliott
    Member

    @jackelliott

    Locale: Bend, Oregon, USA

    Aw, shoot, I thought that geargrams would be the cat's pajamas, but it seems optimized for a larger screen than my little Netbook has. I'm running Google Chrome under Ubuntu Linux on this little 'pooter, and the usual way to shrink a large page or image under Chrome is with Ctrl -, but the geargrams page refuses to shrink to make anything viewable except what appears to the the uppermost left corner of the app.

    Also, clicking on the fields to make entries results in no response.

    Phooey.

    Here's the screenshot of what I see — the whole thing, it's not cut off — and you'll note that there are no scrollbars or any other way to bring offscreen stuff onscreen.geargrams screen shot in Google Chrome browser on Netbook

    #1866997
    Nick Gatel
    BPL Member

    @ngatel

    Locale: Southern California

    I think you need the latest version of Adobe Flash installed in your browser.

    #1867017
    Jack Elliott
    Member

    @jackelliott

    Locale: Bend, Oregon, USA

    I think that the "help" video munged up my browser. Closing the site and re-opening it gives me a sensible page.

    I'm gonna start plugging in my gear's stats.

    #1867044
    John S.
    BPL Member

    @jshann

    #1867283
    Christopher Gilmore
    BPL Member

    @chrisjgilmore

    Locale: Eureka

    Spreadsheets are pretty easy to create if you tell me what you need I can work something up and email it to you.

    #1867285
    Chad “Stick” Poindexter
    BPL Member

    @stick

    Locale: Southeast USA

    Here is the gear list that I use. I have a few of these that I work from. For a particular trip I just make a copy of a summer or a winter gear list and make tweaks to it, this way I can keep a gear list from certain trips if I want rather than having once certain list. Anyway, if you would like, you are more than welcome to copy mine and just put in your information. Here is one of them:

    https://docs.google.com/spreadsheet/ccc?key=0Aqh886ycFM9kdGowcXlydXNQcmJYS0E3LW40SGxMUnc#gid=0

    As you can see, I like using some color and I feel like it is pretty dang detailed.

    Hope it helps!

    Stick

    #1868032
    Arlyn Janssen
    Member

    @arlynjj

    Other Jack,

    I, too, am re-entering the world of backpacking with newly-found ultralight aspiration. I have an OpenOffice template I'm working on that you'd be welcome to use/view/enjoy. It's a work in progress, for sure, but it's available if you want it. It's just a blank template with just basic formulas for consumables (just enter the length of your trip – in days – and it outputs your target food and fuel weights) and the standard fields for Base Weight/Pack Weight/TOOS Weight totals. Nothing fancy.

    I'm happy to import it into docs.google if you prefer or I can email it to you as an attachment (just PM me with your email address).

    Cheers,
    aj

    #1868076
    Jack Elliott
    Member

    @jackelliott

    Locale: Bend, Oregon, USA

    Arlyn, Chad, John, and Christopher — many thanks for the offers! I've been plugging my gear into geargrams for the past two, three days (lots of weighing!) and I waited to respond to your offers to help to make sure that gg does what I need, and it does.

    OTOH, maybe one-a you spreadsheet wizards has an awesomely nifty setup. What if I used gg's .csv export function to extract the data, and emailed the file to you, you could see how to set up an import filter for gg and populate your Open/LibreOffice template with the info.

    It's probably nowhere near as exciting as it sounds.

    #1868088
    John S.
    BPL Member

    @jshann

Viewing 13 posts - 1 through 13 (of 13 total)
  • You must be logged in to reply to this topic.
Forum Posting

A Membership is required to post in the forums. Login or become a member to post in the member forums!

Get the Newsletter

Get our free Handbook and Receive our weekly newsletter to see what's new at Backpacking Light!

Gear Research & Discovery Tools


Loading...