![]() |
Specialized Spreadsheet
Anybody want to tackle a special request for a specialized spreadsheet
function? I need a way to track persons progress on a project. for example, they have 2080 hours in a work year. I need to account for holidays and weekends then if they are what ever project they can charge to. For example if they have 500 hrs on one project, 300 on another etc, planned days off and vacation it should project their time etc. My office e-mail is -- Michael Gomien |
Specialized Spreadsheet
Do you use MS Project. You can write macros in MS project that wil export the data into an excel worksheet. the do your tracking from excel. Let project count the days and holidays which will simplifiy the work in excel. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=196709 http://www.thecodecage.com/forumz |
All times are GMT +1. The time now is 12:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com