Microsoft Office Forums Define project for specific product(changed quantity)

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2017, 11:53 PM
caplja caplja is offline Define project for specific product(changed quantity) Windows 10 Define project for specific product(changed quantity) Office 2007
Novice
Define project for specific product(changed quantity)
 
Join Date: Mar 2017
Posts: 3
caplja is on a distinguished road
Default Define project for specific product(changed quantity)

Hi there,



I'm new to ms project but have been googling for few hours to find solution and I ended up here. Need your help guys.

I have create Project that has around 40 process(tasks) in it. Now, I want to insert this project into one I'm currently working on but in larger quantity.

For example. Project "bicycle":
Task 1. Mount wheels. Duration 1h
Task 2. Mount frame. Duration 3h

Now. I want to insert project "bicycle" in quantity 10pcs. And want to get:
Task 1. Mount wheels. Duration 10h
Task 2. Mount frame. Duration 30h

Is this possible?
Reply With Quote
  #2  
Old 03-09-2017, 01:04 AM
caplja caplja is offline Define project for specific product(changed quantity) Windows 10 Define project for specific product(changed quantity) Office 2007
Novice
Define project for specific product(changed quantity)
 
Join Date: Mar 2017
Posts: 3
caplja is on a distinguished road
Default

maybe I have interpreted it wrong.

I have a production of apparatus that includes around 40 proccess(tasks). And now, when my customer order wanted quantity I want to star that "customer project" and just insert project for that apparatus. But every task in that inserted project should be multiplied by wanted quantity.
Reply With Quote
  #3  
Old 03-09-2017, 09:45 AM
JulieS JulieS is offline Define project for specific product(changed quantity) Windows 10 Define project for specific product(changed quantity) Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm afraid this capability does not exist. You can insert projects inside new projects with the "Insert Subproject" command - however the "every task in that inserted project should be multiplied by wanted quantity" doesn't exist. If you have some skills with VBA, I support you could develop a bit of code that allows you to select tasks and multiple the duration or work by a value you specify - but it doesn't exist out of the box.
Reply With Quote
  #4  
Old 03-11-2017, 09:03 AM
Guloluseus Guloluseus is offline Define project for specific product(changed quantity) Windows 7 64bit Define project for specific product(changed quantity) Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 160
Guloluseus is on a distinguished road
Default

as workarounds, there might be a couple of solutions
you could export the durations to excel, multiply by the number of units required, then paste back into project (taking out any summary durations- they could make a mess otherwise.)
the other would be to put a resource against each task (use the same one, doesn't matter what it is) then reduce to 10% for 10 units. this would multiply the time required by 10 for each activity.

As Julie said, Project doesnt do it- it works with what you give it.
Reply With Quote
  #5  
Old 03-13-2017, 02:58 AM
caplja caplja is offline Define project for specific product(changed quantity) Windows 10 Define project for specific product(changed quantity) Office 2007
Novice
Define project for specific product(changed quantity)
 
Join Date: Mar 2017
Posts: 3
caplja is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
I'm afraid this capability does not exist. You can insert projects inside new projects with the "Insert Subproject" command - however the "every task in that inserted project should be multiplied by wanted quantity" doesn't exist. If you have some skills with VBA, I support you could develop a bit of code that allows you to select tasks and multiple the duration or work by a value you specify - but it doesn't exist out of the box.
At this moment I would like to avoid VBA because I don't have skills for that yet. Will try with two solution mentioned below.
thank you

Quote:
Originally Posted by Guloluseus View Post
as workarounds, there might be a couple of solutions
you could export the durations to excel, multiply by the number of units required, then paste back into project (taking out any summary durations- they could make a mess otherwise.)
the other would be to put a resource against each task (use the same one, doesn't matter what it is) then reduce to 10% for 10 units. this would multiply the time required by 10 for each activity.

As Julie said, Project doesnt do it- it works with what you give it.
Thank you . Will leave excel as backup plan and try with limited resource. I guess that if I put same resource under every task and by limiting it it is should reflect on every task simultaneously. Hope it will work.
Reply With Quote
  #6  
Old 03-16-2017, 10:27 PM
JulieS JulieS is offline Define project for specific product(changed quantity) Windows 10 Define project for specific product(changed quantity) Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Good luck and feel free to post back with if you have additional questions.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need formula to determine minimum quantity needed per price mbking Excel 2 02-10-2015 01:46 PM
Adding quantity if statement ImAhNoBoDy Excel 4 06-23-2014 01:16 PM
How can I print a different quantity of each page? A macro maybe? unittwentyfive Word 2 04-05-2014 07:47 PM
Define project for specific product(changed quantity) Hours in MS Project Changed ayeh Project 14 02-12-2014 10:41 AM
Define project for specific product(changed quantity) How to help - Project 2007 - Scheduling tasks during specific windows of opportunity apexian Project 1 07-12-2013 05:16 AM


All times are GMT -7. The time now is 08:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft