Subscribe Contribute Advertise Facebook Twitter Instagram Forums Newsletter
2005 Backpacking Light Trip Planning Spreadsheet Contest Entries
Display Avatars Sort By:
Nick Gatel
(ngatel) - MLife

Locale: Southern California
Analysis Toolpack on 03/04/2009 03:59:27 MST Print View

Colin,

Similar issues with earlier versions of Excel. This should work.

First of all make sure you have the 'Analysis Toolpack' Add-in installed. Thes instructions work on 2000 and 2003, and probably on 2007.

Click the Tools Menu, Click Add-ins... and then Check 'Analysis Toolpack.'

If the Add-in is not installed, then Excel will ask you to insert the CD, and install it. Once installed, make sure the Analysis Toolpack is checked in the Add-in menu.

If it is still not working, go to the Options page and change the Primary weight units cell to the other choice. From here it should work and switch back and forth.

I had expected to see some program in VBA (Visual Basic for Applications), when was playing with this. But the author didn't. He has put together some very complex formulas to do some of this stuff. Very impressive advanced use of formulas!

Roger Caffin
(rcaffin) - BPL Staff - MLife

Locale: Wollemi & Kosciusko NPs, Europe
Re: Analysis Toolpack on 03/04/2009 14:01:47 MST Print View

Excel 2007, Tools menu - what tools menu?
They screwed the entire layout in 2007!

Cheers

James Dubendorf
(dubendorf) - M

Locale: CO, UT, MA, ME, NH, VT
Excel Tools Menu on 03/04/2009 14:04:03 MST Print View

Roger,

Turns out you click on the circular logo, top left, then select "Excel Options" at the bottom right of the window that appears. Should be pretty clear from there.

James

Colin D.
(colbeans) - F

Locale: Northern British Columbia
Thankyou :) on 03/04/2009 19:08:23 MST Print View

Thankyou for the replies guys
I found the excel options menu and added the Analysis Tookpack; however, the conversion still isn't working for me for some reason :(

Edited by colbeans on 03/04/2009 20:16:42 MST.

Nick Gatel
(ngatel) - MLife

Locale: Southern California
Change the option on 03/05/2009 01:35:11 MST Print View

Colin,

Go to the Option page in the workbook and change to the weight option from whatever it is set at. I found that after I added the toolpack, it would not work until I changed the weight option. After that, it kept working when I made subsequent changes to the weight option.

I am using Excel 2000. I buils a lot of Excel-VBA applications for my company using 2000, which is our corporate load. Many of these applications are faily sophisticated. We are migrating to Office 2007, and I have no reported compatililty issues with 2007 from our users.

Colin D.
(colbeans) - F

Locale: Northern British Columbia
hmm on 03/05/2009 15:23:49 MST Print View

So I gather previously added weights wont convert properly when the option is changed... but all new additions will?
Or was the spreadsheet designed to go back and forth between the two options converting them each time it's changed?

Nick Gatel
(ngatel) - MLife

Locale: Southern California
Back and forth on 03/05/2009 18:57:38 MST Print View

Colin,

I only looked at it for a couple minutes, just to help out. It appears the the purpose of the option is to let you calculate base, consumables, FSO, etc at the bottom of the sheet. I would imagine there is no need to re-input data.

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/09/2012 08:05:28 MDT Print View

What do people like to use these days? I'm still on paper. 7 years of technology has offered up other choices. Geargrams and what not. Me, I still like having it all on my own computer. Not so sure about posting it.

Eric Lundquist
(cobberman) - F - M

Locale: Northern Colorado
Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/17/2012 21:39:23 MDT Print View

I've made my own Excel document that has gone through more iterations than my gear closet has. Google Doc's has an online spreadsheet which has many of the same features.

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/17/2012 22:02:19 MDT Print View

I see no need or reason to have it online. Just remembered that I have Gram Weenie on Renee's computer. Man I need to upgrade this classic Emac.


You guys aren't going to talk tech all night again are you?

Matthew Black
(mtblack) - F
Re: Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/17/2012 22:04:23 MDT Print View

Mmmmmmmmmmm. Maybe.

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Re:Fortran on 09/17/2012 22:16:51 MDT Print View

Well you can build and maintain your own fire this time.

Matthew Black
(mtblack) - F
Re: Re:Fortran on 09/17/2012 22:31:51 MDT Print View

Ugh. OK, no talk about computers or anything related to them.

Bob Gross
(--B.G.--) - F

Locale: Silicon Valley
Re: Re: Re:Fortran on 09/17/2012 22:41:40 MDT Print View

Geez, the last time that I ran a Fortran program it was on an IBM System 360 mainframe.

There is probably a new model by now.

--B.G.--

Mary D
(hikinggranny) - MLife

Locale: Gateway to Columbia River Gorge
Fortran? on 09/17/2012 22:51:32 MDT Print View

I learned Fortran back in the 1980's; had to punch my own cards! Who in the world uses that now?

Nick Gatel
(ngatel) - MLife

Locale: Southern California
Re: Fortran? on 09/17/2012 23:34:36 MDT Print View

"I learned Fortran back in the 1980's; had to punch my own cards! Who in the world uses that now?"

People used punch cards in the 80's? Geez the PC was available in 81. We were using mini-main frames in the 80s and could write code on terminals.

I learned my first computer language in the late 60's (ALGOL) and used punch cards on a Borroughs B5500. I re-wrote some of the programs in BASIC and ran them faster on an Apple ii in the late 70's :)

I thought everyone uses Excel (except Apple geeks). Maybe I'm mistaken. Spreadsheets have been the mainstay of PCs since the late 70's. Some I have used include VisiCalc, MS MultiPlan, AppleWorks, Lotus 123, Excel, and the new horrid Apple Numbers.

Bob Gross
(--B.G.--) - F

Locale: Silicon Valley
Re: Re: Fortran? on 09/17/2012 23:44:21 MDT Print View

"People used punch cards in the 80's?"

1968 maybe.

--B.G.--

Tad Englund
(bestbuilder) - F - MLife

Locale: Pacific Northwest
Re: Re: Re: Fortran? on 09/18/2012 00:43:09 MDT Print View

Hey, my first computer science class in '75 had me punching cards for a IBM 360. I was a terrible typist so I couldn't get the stupid thing to ever run right.

How come nobody has mentioned cobalt (should be Cobol) yet? Or the early 80's CPM ( I wish that would have been IMB's pick instead of DOS- we'd all be way further ahead of things then we are now)

Edited by bestbuilder on 09/18/2012 09:46:02 MDT.

Rex Sanders
(Rex) - M

Locale: Central California Coast
Re: Re: Re: Fortran? on 09/18/2012 00:48:49 MDT Print View

I was still shoveling a few punch cards around for mainframes in the early 1980s. Some stuff takes a long time to die.

Including Fortran. We still have some Fortran code from the 1970s in production at work. I wrote some of it. Luckily, it's someone else's job to deal with that problem!

Mary D
(hikinggranny) - MLife

Locale: Gateway to Columbia River Gorge
Fortran? on 09/18/2012 00:50:37 MDT Print View

Sorry, senior moment, that was the late 1970's when I was working on my accounting degree (kind of hard to make a living for a single mother with a degree in French and English literature and several kids to support). The firm I worked for in the 1980's was still using punch cards for their time cards and a couple of subordinate systems when I left in 1988, though. Not exactly cutting edge! I did get in on the cutting edge when our firm started using PC's in early 1981, though! We started with the Apple II and soon switched to the IBM PC. It took a long time, though, before most firms finally decided that desktop computers are not really capital equipment and should be upgraded if not replaced yearly. The firm I retired from (a different one) went to leasing, which turned out to be cheaper than buying and gave us new machines yearly.

I have Microsoft Office for Mac and make up my own Excel spreadsheets. I still tweak my gear list occasionally. Unfortunately, I can't afford to replace my own computer as often as I should, so mine is currently 6 years old--still holding up, though, although I can't use the latest operating systems on it. At least my O/S is now old enough that makers of computer viruses don't bother with it!

Edited by hikinggranny on 09/18/2012 00:56:25 MDT.