BMW M5 Forum

Post Reply
 
Thread Tools Search this Thread
      11-14-2006, 07:26 PM   #1
BMW F22
Major General
BMW F22's Avatar
United_States
3659
Rep
9,783
Posts

Drives: ///M235i
Join Date: Nov 2005
Location: Bay Area

iTrader: (8)

Need help with HW!!!

does anyone know how to do forecasting???
Or at least unprotect my excel worksheet???
Please let me know ASAP so I can send you the sheet.
Appreciate 0
      11-14-2006, 07:38 PM   #2
ScBlacksunshine
YUGO is my dream car
ScBlacksunshine's Avatar
148
Rep
1,564
Posts

Drives: Bayerische Motoren Werke
Join Date: Mar 2006
Location: LBC

iTrader: (2)

To unprotect a sheet, do this...

Switch to the protected worksheet.
On the Tools menu, point to Protection, and then click Unprotect Sheet.
If prompted, enter the protection password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for the worksheet.


Forecast is pretty simple too, two rolls of data , X and Y, depends on the predict value of X, it will calculate base on the two column and predict the Y value base on the X input
__________________
Appreciate 0
      11-14-2006, 09:07 PM   #3
BMW F22
Major General
BMW F22's Avatar
United_States
3659
Rep
9,783
Posts

Drives: ///M235i
Join Date: Nov 2005
Location: Bay Area

iTrader: (8)

i tried that. It asked for pswd but Im not able to find one. I got this template off the cd that came with the book. Can I send u the file and then see if u can unprotect it?? THanks


Quote:
Originally Posted by ScBlacksunshine
To unprotect a sheet, do this...

Switch to the protected worksheet.
On the Tools menu, point to Protection, and then click Unprotect Sheet.
If prompted, enter the protection password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for the worksheet.


Forecast is pretty simple too, two rolls of data , X and Y, depends on the predict value of X, it will calculate base on the two column and predict the Y value base on the X input
Appreciate 0
      11-14-2006, 09:09 PM   #4
Ninjaneer
Shadow Warrior
Ninjaneer's Avatar
United_States
151
Rep
2,095
Posts

Drives: '07 335i Sedan
Join Date: Aug 2006
Location: Florida

iTrader: (0)

Book doesn't tell you the pw? Or the CD cover? No readme file on the CD that tells either?
__________________
335i E90 / Arctic / Gray / Burl Walnut / Steptronic / ZPP / ZSP / Paddles / CA / Nav / PDC / OEM Spoiler
Mods:
PIAA Angel Eyes, Rear Fog Switch, Escort X50 Blue hardwire, 30% Charcoal Llumar
Installing soon: Rear Power Outlets (Happy Robot mod!)
Appreciate 0
      11-14-2006, 09:15 PM   #5
BMW F22
Major General
BMW F22's Avatar
United_States
3659
Rep
9,783
Posts

Drives: ///M235i
Join Date: Nov 2005
Location: Bay Area

iTrader: (8)

Quote:
Originally Posted by Ninjaneer
Book doesn't tell you the pw? Or the CD cover? No readme file on the CD that tells either?

nope
Appreciate 0
      11-14-2006, 09:16 PM   #6
Ninjaneer
Shadow Warrior
Ninjaneer's Avatar
United_States
151
Rep
2,095
Posts

Drives: '07 335i Sedan
Join Date: Aug 2006
Location: Florida

iTrader: (0)

Dude I was able to find tons of Excel password recovery tools with a simple Google search: http://www.google.com/search?q=how+t...Excel+password

The following result looks good... it recovers the password and lets you know what it is: http://www.rixler.com/excel_password_recovery.htm (click on Download at the bottom of the screen)

And there are free ones, the above is one of them. Just be careful you don't end up on some questionable website that may have viruses etc. Check for viruses on whatever you download.

Also, make sure you have a backup of your work in that Excel sheet before using these tools on it just in case anything messes up.
__________________
335i E90 / Arctic / Gray / Burl Walnut / Steptronic / ZPP / ZSP / Paddles / CA / Nav / PDC / OEM Spoiler
Mods:
PIAA Angel Eyes, Rear Fog Switch, Escort X50 Blue hardwire, 30% Charcoal Llumar
Installing soon: Rear Power Outlets (Happy Robot mod!)
Appreciate 0
      11-14-2006, 09:25 PM   #7
BMW F22
Major General
BMW F22's Avatar
United_States
3659
Rep
9,783
Posts

Drives: ///M235i
Join Date: Nov 2005
Location: Bay Area

iTrader: (8)

none of them works LOL

Quote:
Originally Posted by Ninjaneer
Dude I was able to find tons of Excel password recovery tools with a simple Google search: http://www.google.com/search?q=how+t...Excel+password

The following result looks good... it recovers the password and lets you know what it is: http://www.rixler.com/excel_password_recovery.htm (click on Download at the bottom of the screen)

And there are free ones, the above is one of them. Just be careful you don't end up on some questionable website that may have viruses etc. Check for viruses on whatever you download.

Also, make sure you have a backup of your work in that Excel sheet before using these tools on it just in case anything messes up.
Appreciate 0
      11-14-2006, 09:46 PM   #8
Ninjaneer
Shadow Warrior
Ninjaneer's Avatar
United_States
151
Rep
2,095
Posts

Drives: '07 335i Sedan
Join Date: Aug 2006
Location: Florida

iTrader: (0)

Quote:
Originally Posted by BMWE90
none of them works LOL
oh bummer... looked promising hehe
__________________
335i E90 / Arctic / Gray / Burl Walnut / Steptronic / ZPP / ZSP / Paddles / CA / Nav / PDC / OEM Spoiler
Mods:
PIAA Angel Eyes, Rear Fog Switch, Escort X50 Blue hardwire, 30% Charcoal Llumar
Installing soon: Rear Power Outlets (Happy Robot mod!)
Appreciate 0
      11-14-2006, 09:52 PM   #9
Ninjaneer
Shadow Warrior
Ninjaneer's Avatar
United_States
151
Rep
2,095
Posts

Drives: '07 335i Sedan
Join Date: Aug 2006
Location: Florida

iTrader: (0)

Oh those cheap @%#@^# ... yea I just tried that one I suggested... it shows this lame notice saying it will display "evaluation copy" if the p/w is longer than 3 characters.

Lame. I'll see if there's something else...
__________________
335i E90 / Arctic / Gray / Burl Walnut / Steptronic / ZPP / ZSP / Paddles / CA / Nav / PDC / OEM Spoiler
Mods:
PIAA Angel Eyes, Rear Fog Switch, Escort X50 Blue hardwire, 30% Charcoal Llumar
Installing soon: Rear Power Outlets (Happy Robot mod!)
Appreciate 0
      11-15-2006, 12:53 AM   #10
BMW F22
Major General
BMW F22's Avatar
United_States
3659
Rep
9,783
Posts

Drives: ///M235i
Join Date: Nov 2005
Location: Bay Area

iTrader: (8)

haha I finally got it. My friend gave me this program that cracks the code. THanks all the help!!
Appreciate 0
      11-15-2006, 06:40 AM   #11
Ninjaneer
Shadow Warrior
Ninjaneer's Avatar
United_States
151
Rep
2,095
Posts

Drives: '07 335i Sedan
Join Date: Aug 2006
Location: Florida

iTrader: (0)

Quote:
Originally Posted by BMWE90
haha I finally got it. My friend gave me this program that cracks the code. THanks all the help!!
Congrats. The new one I found worked in the end, but it seemed to get in there and change the p/w to something generic then save the whole file to a new filename... rather than just give me the original p/w. Oh well.
__________________
335i E90 / Arctic / Gray / Burl Walnut / Steptronic / ZPP / ZSP / Paddles / CA / Nav / PDC / OEM Spoiler
Mods:
PIAA Angel Eyes, Rear Fog Switch, Escort X50 Blue hardwire, 30% Charcoal Llumar
Installing soon: Rear Power Outlets (Happy Robot mod!)
Appreciate 0
Post Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -5. The time now is 04:47 PM.




m5:
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST