Replies

I have a similar problem (although without the error messages). Office Upgrade goes through the motions, reads stuff from the CD, then hangs and tells me the install was unsuccessful – without any other explanation. One thought I had was that the machine has Office 2000 installed from it’s CD, but the version of Outlook 2K was installed from a separate CD, installed before the Office 2K install. Is this the problem? I did a similar update on my other PC, which was also set up the same way, and recall that Update asked for the Outlook CD separately during the process. Should I try unloading Outlook and reloading from the Office 2K CD??

It seems to me, after a lot of experimentation and digging, that there is only one way to define a “DAY” in project. The working day defined by the resource calendars have no effect on the time allocated to a task. So, if I define the default day in the project calendar to be 10hrs, 6 days a week, a resource such as a manager who only works 8hr days CANNOT have time assigned to a task in multiple of “days” since this will be the 10 hr “day” from the master calendar, not his 8hr day from his resource calendar. Now, if I assign him to a 3 “day” task by entering his time as 24hrs (3x8hrs) he appears to finish the task in 2.4 days (2.4x10hrs).

How do other project managers deal with this? There must be cases (in construction for example) where there are resources working with different length days. I would like to have correct allocation of “days” per resource since I’d like to assign pay rates to the resources and get a budgetary figure for the project when I set it up.

HELP!!

It seems to me, after a lot of experimentation and digging, that there is only one way to define a “DAY” in project. The working day defined by the resource calendars have no effect on the time allocated to a task. So, if I define the default day in the project calendar to be 10hrs, 6 days a week, a resource such as a manager who only works 8hr days CANNOT have time assigned to a task in multiple of “days” since this will be the 10 hr “day” from the master calendar, not his 8hr day from his resource calendar. Now, if I assign him to a 3 “day” task by entering his time as 24hrs (3x8hrs) he appears to finish the task in 2.4 days (2.4x10hrs).

How do other project managers deal with this? There must be cases (in construction for example) where there are resources working with different length days. I would like to have correct allocation of “days” per resource since I’d like to assign pay rates to the resources and get a budgetary figure for the project when I set it up.

HELP!!

Jefferson

So it seems, having read through the various other posts you pointed me to ( When is the SEARCH function coming back? ) that I could disable the ASP.NET user without too many problems. I’ll give it a go.

Jefferson

So it seems, having read through the various other posts you pointed me to ( When is the SEARCH function coming back? ) that I could disable the ASP.NET user without too many problems. I’ll give it a go.

Hum… That didn’t seem to have any effect. The “Effort Driven” box was already checked. I also tried assigning the correct (i.e. 50hr week) calendar to the task on that advanced tab, but still no joy.

See attached sample for a single 1-day task with a resource assigned who is working on a 50hr week calendar.

Hum… That didn’t seem to have any effect. The “Effort Driven” box was already checked. I also tried assigning the correct (i.e. 50hr week) calendar to the task on that advanced tab, but still no joy.

See attached sample for a single 1-day task with a resource assigned who is working on a 50hr week calendar.

Jefferson – Yes, I have PC-Cillin, which has just recently started doing goofy things on start-up (looking for files on a non-existant drive – but that’s another problem that’s unrelated to this board). Previously, when it was loading correctly, I was getting a banner flash from PC-Cillin when I started downloading mail. It all becomes clear now. Next problem – fix PC-Cillin!

Many thanks. Go Sharks (again).

You Rock!! In fact the “Mergeformat” does funky things with boldening part of the text so I didn’t need it. I also looked at the Word help file for STYLEREF. Under the “Print Dictionary Style headers and footers” it gives the same answer. There is an error (Surprise, Surprise) where they don’t include quote marks for the Style to search for. Results in a “Style not found” error.

Go Sharks!!

I agree with you sir. I get an email with what looks like contact information, I double click and it opens in the contacts style, it even has the “Save and Close” tab at the top, so, to me, humble user that I am, it looks like a duck, it sounds like a duck, it even SMELLS like a duck, but in reality, it’s another Microsoft Turkey !!

Well duhhhh.

Ok that worked – chalk it up to yet another Microsoft “feature”?

Problem Solved! Finally discovered some hidden columns off to the right on the sheet (It stopped at BN and I couldn’t work out how to unhide the rest – but now I have – “Format/Columns/Unhide”) Guess what? there was some additional data with comments. Deleted that and all is now working as expected.

Question is? Will Micro$oft fix the Excel bug in later versions? How do you force Excel to insert comments that can scale and move with the cells?

Thanks for the help.

Well – it seems to work, but very inconsistantly. I have removed all comments from the sheet. Lets say I want to hide columns N-U. If I select them all I still get the error message. If I start hiding individual columns, starting at N I can get as far as S before I get the error. Starting at the other end, I can again hide 5 columns U,T,S,R,Q, but on the 6th one (P this time) I get the error again. If I select a block of columns to hide I can only hide 4 together before I get the error.

This is too weird!

Hans

Thanks. This is a form as part of a worksheet. Objects on the form are placed from the “tools” toolbar. Not being a VB wiz, I might have to look at a different way to get my conditional input.

Keith

Having looked closely at the revised sheet, I find that I can now get the formula to work in a single line, which was my original goal. I named $A$2 as “budget” and $C$4 as “month1” just for clarification and modified the formula in all but the first cell to be

=IF(ISNUMBER(C4),Budget/12+(Budget*MONTH(C3)/12-SUM(month1:C4))/(12-MONTH(C3)),C4)

This avoids the circular reference by building the sum spent each month throughout the chart. As real $$ are known, I just overwrite the formula with the hard number. Incidentally, the final sum in O5 now works and always shows $12,000.

I guess I could also make this work on a weekly budget, I’d just have to have a hidden row with week numbers in it as there’s no Excel formula for getting week numbers like the “MONTH” formula we use here. Easy enough to do once you work out the logic.

Again – many thanks to all loungers for the assistance.