Column for Task Calendar

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Export out a project to Excel from MS Project I am a newbie of MS project and was asked to make a report and export i to Excel, The reports contain each person's name & project assignment o the left columns and the month in the first row, and the workload in th table .The attached is part of the report I made. However, I discovere that I can't export it out to Excel. So, I have been trying to expor the project to Excel through "Save As". I can export the project ou and have the required columns, however, I can't summaise the workloar (in hour) for each task of each person by month. And also, I need t have total workload of each person by month. Here is my question, Since we can produce a report in MS. Is there any way to export th report out to Excel (raw data) and we then can edit it. Or, we ca export the data to Excel and we can modify it to meet our requirement Thanks -- VitaminB ----------------------------------------------------------------------- VitaminB6's Profile: http://forums.techarena.in/member.php?userid=3711 View this thread: http://forums.techarena.in/showthread.php?t=86999 http://forums.techarena.i Tag: Column for Task Calendar Tag: 131219
  - 2
    - Cadence Offering : VLSI Job oriented Training & Final year Live HI Friends, Cadence And University of California offering.... Certificate Program in VLSI Logic Design and Layout Design Engineering. TIIT (TTM Institute of Information Technology) in collaboration with the University Of California at Santa Cruz Extension in the Silicon Valley and Cadence Design Systems offers a certificate program in VLSI design engineering. Students who complete the required courses with minimum grade point average (GPA) will be awarded a certificate in VLSI design engineering (Physical Design or Logic Design) from the University Of California Santa Cruz extension in Silicon Valley. Duration: Will be for 20 weeks. Class Timings: Classes will be during the weekends; 6 days Lab will be open to work on Tools (morning 6am to 12 in the midnight). Fees: 90k for Layout Design Course. 70k for Logic Design Course. Payment Flexibility: Can pay it in 3 Installments. Placement Statistics: 90% of the people got employed in VLSI Industry so far. Batch Start Date: Week-end Batch: 22nd December 2007. If you are looking for Final year M.Tech VLSI Live Project mail to shashi@tiit.in Registration: www.tiit.in Or send mail to blrtraining@tiit.in Hurry-up, We have limited seats for December Week-end batch TIIT Pvt Ltd. #18, 1st floor, Palavalli plaza 100 feet Ring road. 2nd stage BTM Layout, Bangalore.-560076 Karnataka,India.' www.tiit.in & www.time2mkt.com Tel: +91-80-26789654. +91-9845261676 Tag: Column for Task Calendar Tag: 131218
  - 3
    - differential sync to actual Is it possible to have REAL resources in MSProject 2003 SP3 synced to actual and the GENERIC resources NOT sync to actual after having set %-complete on tasks with Generic-ONLY sources. In other words ... we'd like to track technical progress on tasks that only have GENERIC resources assigned ... thus, if we set a %-complete, it will estimate the remaining work on that task for that generic resource. If I do this now, it resets that task back to 0% as the GENERICS don't report time via PWA. Tag: Column for Task Calendar Tag: 131214
  - 4
    - Gantt Chart to include task name Is it possible to add the task name instead of/or in addtion to the resource name in the gantt chart view? Tag: Column for Task Calendar Tag: 131213
  - 5
    - Project 2007 SP1 crashes To overcome the problem of our business having version Project 2007 (12.0.4518.1014) MSO (12.0.4518.1014) and our training partner having Project 2007 education version with a version number of Project 2007 (12.0.4518.1014) MSO (12.0.6017.5000) with the accompanying problem of these 2 versions having different features, we downloaded SP1. After installing SP1 we created some macros and made other changes and every time we tried to save to the global.mpt file, the program crashes. Also, it still has the 'creating calendars' problem (we can only choose 'Gregorian calendar') whereas our training partner has many calendars to choose from and the problem of different 'tools/options'. Ideas? Tag: Column for Task Calendar Tag: 131212
  - 6
    - Displaying Individual Work for Multi Resourced Task Is there anyway that I can create a table that combines fields from task and resource tables? I want to be able to display task IDs, task name, various custom task fields, and the individual work for a specific resource if the task has multiple resources assigned to it? I want to create single line report that I can develop a filter that selects only for the specific resource. Similar to the example below with additional information. Task #1, Start, End, Baseline Work for Resource #1, Resource #1 Tag: Column for Task Calendar Tag: 131209
  - 7
    - Creating a timeline schedule without calendar dates I need to input a generic schedule that depicts timeline milestones after receipt of an order. I have been unable to find a way to do this without using a normal calendar. For instance, I could have the following: Receipt of order - day 0 Receipt of components - day 50 Complete Manufacturing - Day 100 Customer acceptance testing - Day 110 Shipment - Day 120 ETC. Can project do this? Or is this a Visio or other program task? Thanks. Tag: Column for Task Calendar Tag: 131206
  - 8
    - Different Timescales Each Custom View? PWA Timescale I need help! 1. I've created several PWA Project Center custom views. Is there a way to have a different timescale for these custom views. 2. Also, my enterprise global settings are middle tier= years, bottom tier= weeks. This timescale appears correctly in Project Pro, but not PWA. In PWA, I get middle tier in weeks and bottom tier in days! Also weekends and holidays are not showing as non working time. Help Tag: Column for Task Calendar Tag: 131201
  - 9
    - project 2007 versions We have a volume license for Project 2007 with a version number of Project 2007 (12.0.4518.1014) MSO (12.0.4518.1014) and our training partner has purchased a Project 2007 education version with a version number of Project 2007 (12.0.4518.1014) MSO (12.0.6017.5000). There are differences in these 2 versions including 'change working time/creating calendars' and 'tools/options'. I cannot find on the Microdsoft website any refence to differnet versions and functionality. I downloaded the current trial version but it has the same (12.0.4518.1014) version number. The first service pack is not due till next year. How can we get hold of a MSO (12.0.6017.5000) version so our version is the same as our trainers? Tag: Column for Task Calendar Tag: 131195
  - 10
    - Resource Assignment Help! Hi, I'm new the forums, but it looks like a great place to get help. :) Here's my question... I have an MS Project Plan created with tasks, dependencies, and effort (broken down by each project phase). I know which resources should be assigned to each task. Seperately, I created a detailed Resource Plan with a list of all resources, hours per resource, and which tasks they should be involved with. The project is complex, with approximately 15k workdays over 100 tasks, and around 40-50 FTEs. What is the easiest way to load my MPP with resources, while maintaining the right number of hours per resources per phase? Is there any way to do this (add-in tool perhaps?) besides manually adding resources to tasks, leveling, hoping the hours match what my Resource Plan says, and then reallocating? Thanks in advance for your help!! Sanjay. Tag: Column for Task Calendar Tag: 131193
  - 11
    - resource scheduled not correctly Hello, I have a problem with one resource of my project. I create a task with a duration of 1 day and assign it to this resource. The task is scheduled automaticaly to begin today . I create another task and assign it to the same resource. Project instead of apply a delay of 1 day, schedul the task today and then the resource is overallocated. If I launch a reallocate resources it not resolve the problem. thanks. Tag: Column for Task Calendar Tag: 131190
  - 12
    - Project 2007 Upgrade My boss wants to "upgrade" his new laptop with Project 2007. His old laptop has Project 2003. I'm wondering what is the installation process for a purchased "upgrade package". Does the previous version have to be installed to upgrade, or do I just need to have the previous version's serial number available. What is the difference between an upgrade package and a new purchase package? Any help would be appreciated. Tag: Column for Task Calendar Tag: 131185
  - 13
    - Problem with setting Resource Availability I have resources that I need to set for particular availability on a project, but don't want them to show as having any other remaining availability other than for that project. I'm using the Resource Availability box under Resource Information, and setting the start/end dates and available units. But the units are not setting; it either wants 1 or 0. It was working last week! I could set availability to be any percentage I wanted for a set range of dates. Not sure what's happened, but this is very important so that these resources are not counted as overall available when I run monthly reports. But I still want to show who's working on a project. Can anyone tell me what's happened here and how to be able to reset specific availability? Thanks! Tag: Column for Task Calendar Tag: 131164
  - 14
    - date format in table Yesterday I noticed that a co-worker has her dates listed Year-Month-Day. On my computer it's standard American, M-D-Y. How is that changed? She didn't know. thanks. Tag: Column for Task Calendar Tag: 131161
  - 15
    - Where's the Project Guide Under Options, Interface, it says I can use my own Project Guide instead of MS's. Where is that? thanks. Tag: Column for Task Calendar Tag: 131159
  - 16
    - MS Project Server 2003 error code:9573 A couple of users are getting error code: 9573 when trying to Build Team from Enterprise Resource Pool. Has anyone seen this error before? If so, how can we correct the error? Tag: Column for Task Calendar Tag: 131155
  - 17
    - ms project , planned % column , is there one ? pls advise if ms project has a planned % column, % actual progress is logged, but to compare against. The planned period is devined so should be able to be tracked, but no option i can find in new columns?? Pls assist Tag: Column for Task Calendar Tag: 131153
  - 18
    - Physical % complete field Hi Guys, Want to know whether Physical % Complete values (entered manually) for activities would get rolled up to summary tasks are not. We want to use this field for projecting the actual % if work complete and thus want to have these values rolled up to summary tasks ultimately to the overall project summary. Trivikram. Tag: Column for Task Calendar Tag: 131145
  - 19
    - The Project Application Service doesn't exist or is stopped. Start Hi All, Tried creating a Project Web Access Site via-MOSS 2007 and got this error (below): "The Project Application Service doesn't exist or is stopped. Start the Project Application Service." Had a look in Central Administration and just could not find an avenue for starting the above mentioned service (Project Application Service). Please advice as to what can be done and how would I go about it? Your help is greatly appreciated. -- Kind Regards, Harish Tag: Column for Task Calendar Tag: 131141
  - 20
    - Entering start/end date with time Is there a way to enter the start or end date with time other that manually editing the time portion? The pop-up calendar only shows days....so not see a way to specify time. We are currently using P3 and I am reviewing Project 2003 to see if it meet our requirements. Projects are scheduled in hours. P3 calendar allows picking a date and specifying the time. If not available in Project 2003, how about 2007? Thanks David Tag: Column for Task Calendar Tag: 131138
  - 21
    - Inflation in Cost Model I am using MS Project to build the cost model for a project over a number of years. To allow for inflation, I would like different cost rates to be applied to resources depending upon when the work is undertaken. For example, resource A is charged at £1000 in year 1, £1000+a% in year 2, £1000+a%+b% in year 3, etc. Is there a way to calculate on this basis automatically and apply inflation across all resources within MS Project? Thanks in advance. Tag: Column for Task Calendar Tag: 131133
  - 22
    - Cost Rate Table with VBA I would like to create a macro to loop thru all resources and provide new cost (in cost rate table A) that would become effective on 1/1/08 Is there a way to do this with VBA? I tried recording a macro, but when I do so I get only: Sub Macro1() SelectResourceField Row:=0, Column:="Standard Rate" End Sub Ie, no actual updating of entries is recorded by the macro. Any suggestions would be appreciated. Thanks, Bo -- BF2 ----------------------------------------------------------------------- BF2K's Profile: http://forums.techarena.in/member.php?userid=3698 View this thread: http://forums.techarena.in/showthread.php?t=86884 http://forums.techarena.i Tag: Column for Task Calendar Tag: 131122
  - 23
    - Why can't I print? Keeps saying Microsoft 8 not working Have a new HP computor with Micrsoft Vista. I cannot print, each time I try I get a message the Micrsoft 8 is not working. I can print from web sights. Also, I had my floppy discs transferred to writeable CDs but when I try to use them, I'm told they are read only. I have to admit I am not very computor savey but this is ridiculous Tag: Column for Task Calendar Tag: 131119
  - 24
    - Copy Picture to Office Wizard Not Working Hi, I'm having a problem using the Copy Picture of Office Wizard. I've got the Analysis Toolbar up and have the icon for the CPOW. However, when I click on it nothing happens. In other words, the wizard does not start. Did I miss something that needs to be set up in order to activate that feature? I haven't yet uninstalled and re-installed MSP 07. Any suggestions will be greatly appreciated. Thanks -- Michelle Colodzin, PMP Tag: Column for Task Calendar Tag: 131110
  - 25
    - Difference between Custom Field and Custom Outline code Hi, The question here is, i have a enterprise outline code named 'Accountable Resource' already used in the server. I want to add one Enterprise Custom Field with same name. Will this be a conflict as they will have same names. Or will it not affect as both of them belong to different category (Custom Text field and Custom Outline code). Thanks in advance. Tag: Column for Task Calendar Tag: 131108
- Next
  - 1
    - MEET NEW ADULTS! 5000+ NEW MEMBERS PER WEEK! FREE! MEET NEW ADULTS READY FOR FUN IN YOUR AREA FOR FREE! http://www.meetnewadults.com 100% FREE PROFILE AND MEMBERSHIP ON THE NEWEST SITE! http://www.meetnewadults.com - MEET NEW ADULTS NOW! - http://www.meetnewadults.com AGE VERIFICATION REQUIRED! http://www.meetnewadults.com 18+ ONLY!PRIVATE MESSAGES! CHATROOMS AND CHATBOARDS! PICTURES VIDEOS & SO MUCH MORE! FREE! Tag: Column for Task Calendar Tag: 131107
  - 2
    - Recurrng Task - wrong inital start day When I set up a recurring task to occur every Wednesday, the first one always starts on Monday and then the rest are on Wed. How can I fix this so that all of them are on Wed? Tag: Column for Task Calendar Tag: 131104
  - 3
    - Long Indent Good morning everyone. I posted this question before, received and tried a few of suggestions including re-installing the software with no success. I was hoping someone might have come across a solution in the mean time. Problem: All tasks indent way too far. They indent so far that I have to expand the task name colunm past the edge of my screen and scroll over to see every task...very annoying and impossible to view the project as a whole. This problem is isolated to a particular machine and does not appear this way on any other machines or any other users in the office using the same Project file. If I log in as different user to this machine, the problem still exists. On this machine, all Project files appear this way for new or exisiting tasks. This problem started when I got this user a new computer which is a Micron using XP. I loaded Project 2007 Standard using a volume license key after receiving the new computer. I also used this same CD and key to load it on his old computer which was fine and which is now no longer in use. I sincerely appreciate any suggestions anyone has! Thanks! Tina Tag: Column for Task Calendar Tag: 131103
  - 4
    - Reporting Custom fields in MS Project I would like to create a crosstab report containing the values in custom field Cost1 against each task in my project. The choice of fields available in custom crosstab reporting seems quite limited - Are the custom fields available? Does anyone know how to create a report using custom cost fields? Tag: Column for Task Calendar Tag: 131101
  - 5
    - BCWP is always zero when using Physical % Complete for EVA Hi folks, I've seen similar posts to this in the past and the problem has always been down to lack of a baseline, wrong status date, that kind of thing. Well I'm relatively earned value savvy and and believe I have done all the right things but I'm still getting zero BCWP when I use Physical % Complete rather than % Complete as the basis for my EV calculations. If I swap a task back to use % Complete then BCWP is fine. Swap it back to use Physical % Complete and it zeroes again. I've checked and re-checked the data but really have run out of ideas. So; any help would be appreciated. Thanks in advance. Doc. Tag: Column for Task Calendar Tag: 131100
  - 6
    - Resource Pool - MS Project 2003 I have set up a resource pool for use by PM's. It is sorted and saved by the name of the resoure, however, when a PM selects a name from the resource pool the resource is listed by when the resource was added to the pool rather than by the sorted name. The issue is that when a PM assigns a name to a task it is difficult to locate the name form the resource list. Any suggestions would be much appreciated thank you -- Bob Kulin Manager Moneris PMO Tag: Column for Task Calendar Tag: 131099
  - 7
    - Adjusting Timescale Help! and thank you. I have adjusted the print date range to accomodate the durartion of the project but I continue to get two additional years after project completion. Any advise as to how to get rid of this? -- Elaine Tag: Column for Task Calendar Tag: 131098
  - 8
    - Resources counted multiple times For some reason, Project has decided to count one task multiple times in each of the resources assigned to it. I assigned up to five people to several tasks in the Gantt chart view, and then when I went to level the resources in the 'resource usage' view I noticed that some (but not all) of the tasks were counted multiple times. This leads to serious overbooking of the resources. Any thoughts on why this is happening, and what I can do to fix it? I also noticed that the dependencies in some of the duplicated tasks got replicated by the same number of times the tasks repeated for the resource. That is, the dependency of one task (which was duplicated four times in a particular resource) was shown as '12,12,12,12' - instead of the '12' I had initially put there. Thoughts, anyone? TIA... Tag: Column for Task Calendar Tag: 131096
  - 9
    - resource sheet initial for second name In project resource sheet, the initial is automatically the first character of the first name, can this be changed to become the first character of the second name Tag: Column for Task Calendar Tag: 131090
  - 10
    - Reflecting a new Hours per day in MS Project plan I have changed my "Change Working Time" settings to 5 hours per day and set this as the default, however, my project and the reports show resources available for 8 hours a day. (using the standard reports, assignments ). What am I doing wrong ? Tag: Column for Task Calendar Tag: 131089
  - 11
    - go to the next overallocation Hi I,ve got a project expanded over several years. I know there is overallocation in 2008 and in 2011. In the resource allocation view, when I click on the "go to the next overallocation" button the overallacotion in 2008 is shown, but not the one in 2011. I get a message that there is no overallocation after "date of the first overallocation". The project was created with MSP XP, but I have the same problem in 2003 and 2007. Is there a limit in time that overallocation is shown. Or could there be another reason for this problem. Thanks Tag: Column for Task Calendar Tag: 131088
  - 12
    - Duration, ES, EF, LS, LF & Slack inconsistent calculation My project settings in Project 2003: Calendar- I modified calendar "nigh shift"; working hours 7-10pm M-F and 5-10pm Sat-Sun Task type- globally assigned "Work Fixed" Logic- summary tasks are shells with no logic attached to them. Ensured there are no constraints or resources assigned to the summary tasks. Linked everything, assigned resources and globally assigned "As Soon As Possible" constraints all at the sub-task level. Problem: I'm not confident with LS & LF dates calculated by Project. Nor am I confident with the slack calculations. "Free Slack" is the attribute in Project which seems to be the closest to the idea of "float" we use in a course I'm taking. Here are several examples of where I get conflicting slack (float) calculations: WBS ID 20= Pack Living Room- first issue, I manually calculate a float of (ES-LS) 15dys, and (EF-LF) 16dys? No agreement. Second issue, Project returns slack of 6.12dys? Totally different? (ES-LS) 15dys, and (EF-LF) ES 2/27/2008 EF 2/28/2008 98.00dys LS 6/4/2008 LF 6/4/2008 97.00dys WBS ID 66= Test new property keys- first issue; I manually calculate a float of (ES-LS) 98dys, and (EF-LF) 97dys. No agreement. Second issue Project returns a slack of 6.19dys. Totally different? ES 2/16/2008 EF 2/18/2008 15.00dys LS 3/2/2008 LF 3/5/2008 16.00dys Note:Excel used calculate the days manually. Any help appreciated. -kw Tag: Column for Task Calendar Tag: 131085
  - 13
    - Project 2007 email how do I email task to staff in project 2007? and then update project from responses? Tag: Column for Task Calendar Tag: 131081
  - 14
    - how to set up a default company Is there a way to have the author and company (under 'Properties') automatically populate? I guess I'm asking if there is a Project template, similar to a Word "dot" template. Thank you. Tag: Column for Task Calendar Tag: 131079
  - 15
    - best way to enter data When using fixed units tasks, is their a preferred way to enter data, data being work, resources. Is it better to enter work first then resources or resources then work, ideally what I want to end up with is having every task have it's resource allocated at 100% unless max units in resource sheet is set to a lower figure. so that all task are completed in the shortest possible time. Thanks Mark Tag: Column for Task Calendar Tag: 131074
  - 16
    - Setting a default data template for network diagrams Hi, I am creating a simple network diagram and simply want the name of the task to be shown. I have been able to customise the data template box to do this, but I am struggling to get this customise template to be saved as the default. How do i go about this? i.e. setting a default data template for network diagrams. Thanks Tag: Column for Task Calendar Tag: 131051
  - 17
    - do you have templates for designing a school project? we want to build a 3 storeys school but our time is very limited. Tag: Column for Task Calendar Tag: 131050
  - 18
    - is their any syntax training on MS Project formulas? I am looking for syntax information or training on MS Project formulas for using on custom fields. I know of the iif statement, etc. but there doesn't seem to be any documentation on the syntax constructs for formulas. Is this located on Microsoft somewhere or in a recommended book? Thanks Tag: Column for Task Calendar Tag: 131049
  - 19
    - Cost Rate Table Does anyone know if Project 2007 has the same 5-tab cost rate table limitation as is build into Project 2003? Thanks for your help. Johnnie Tag: Column for Task Calendar Tag: 131035
  - 20
    - Project Management discussions? Does anyone know where there are any good discussions about Project Managment in general--not necessarily Microsoft Project? All the ones I've found are crappy and outdated. --Marcus Tag: Column for Task Calendar Tag: 131033
  - 21
    - MSP 2007 Crashes when applying Group with Custom Field with Formula Hello, I was just "upgraded" to MSP 2007 from 2003. Project crashes everytime I apply a group to a view that shows a custom field with a formula. I have tried a number of things to prevent this including defining a field with a very simple formula that just sets a text field to the value "test". I can view the field fine, but when I apply a group (even a standard group like "Critical"), it crashes Project. This seems to only happen in the projects I created in 2003 originally. Moving the same fields, groups, and views to a new project (using Organizer) seems to work OK without crashing. I certainly do not want to recreate my whole MPP files again. Help! Any ideas on how to correct this? Has anybody else experienced this? Thanks for any help. -- sjweisser ------------------------------------------------------------------------ sjweisser's Profile: http://forums.techarena.in/member.php?userid=36792 View this thread: http://forums.techarena.in/showthread.php?t=867219 http://forums.techarena.in Tag: Column for Task Calendar Tag: 131032
  - 22
    - XML import Using 2003 SP3 - I need to import an XML file into Project. When I do, I get the correct number of tasks, but there is no data - all the tasks are blank. Anybody have a clue? meg99 Tag: Column for Task Calendar Tag: 131031
  - 23
    - Old Alert Mgr - Message I'm experiencing missing data from MS Project. There are task that I updated last night and this morning and saved, but the task appear as if they weren't saved. Just a moment ago, I recieved a pop up box that reads: OLD ALERT MGR: Microsoft Project Do you want to save the changes to (project name).mpp? Yes / No The application has locked up. Does this make any sense to anybody? Thanks, Joe Tag: Column for Task Calendar Tag: 131028
  - 24
    - view shifting left Hello, this is more of an annoyance than issue with Project. In some schedules when I type in the Predecessors column it stays where it's at. But, in other schedules when I type in Predecessors column it shifts the view to left. I guess it's so that I can see the column better, but than I can't see the task names. Is there a way to make it stop? Thanks :) Tag: Column for Task Calendar Tag: 131025
  - 25
    - Printing When printing a project sheet, I frequently have a line that fails to print completely. Never more than one, and sometimes one of the date cells will print, but nothing else. The Gantt chart prints, but the task name does not. Occasionally, the line will print if I increase the line height, but not every time. Sometimes you can see the top of the words, or maybe even half, but not the entire wording. I've uninstalled & reinstalled my printer driver numerous times. No other MS Office program has print issues, nor does any other program (e.g., Adobe Reader). Anyone have any ideas? Tag: Column for Task Calendar Tag: 131020

Is there a way to add a column in the Gantt views the Calendar being used for
each task? I don't have resources of any kind. I would like to use the
'fill down' feature or 'copy cell and paste' to change the calendars of the
tasks several at a time.

Top

RE: Column for Task Calendar by Neill

Neill
Wed Dec 12 05:58:02 PST 2007

Never mind, I found what I was looking for. It's Task Calendar field!

"Neill" wrote:

> Is there a way to add a column in the Gantt views the Calendar being used for
> each task? I don't have resources of any kind. I would like to use the
> 'fill down' feature or 'copy cell and paste' to change the calendars of the
> tasks several at a time.

Top