L1 Create,Define Activities and WBS from Bill of Quantities BOQ

hi this is the first lesson in our course step by step how to create time schedule using cavero p6 and Excel 2010 now we have a sample p oq' bill of quantities will go through this bill of quantities to create our work breakdown structure WBS the very thing I will do I will create our W s fine and I hold it up to be s - activity list I put some cones here which I'll start filling it all my favorite thing would be that the auto front and the the division of all then activity ID then the activity moon and the B or Q description and the quantity binocular quantity and they are not the way it distribution percentage will know about the use of each column now and the amount before I go to the bill Q I should go to the drawing fairy so check how many Flores appending and what is contents of the building now our project our sample project here it is a free floor holding with holes log so we will try to move now our work with down structure but in the same time we're going to use the data to meet the cost version later on so now we will define our work breakdown structure and the cost associated with each activity I'll make this one like a table and center everything from whoa okay before I go to both the activity a name and Peele clue description from the bill of quantity I will create my WPS so in the water breakdown structure we have sub structure the sub structure will mean everything under the ground so we have sub structure then we have super structure we will complete adding after the super structure will add the provinces then we'll add final finishes and we add electrical or mechanical works firefighting this would be our type TPS work breakdown structure and of course it is varied from project to project so you have to check what is the contents of your projects what is the elements you have the unity of the conveying system which is elevated on this committee moving system they will have here closeout this is the main elements of our WPS now we can change the header and start filling this to create the levels underneath each level of this one we'll add another level so here and sub under sub structure we will add another level give a different color let's say F work which include excavation and peck filling and after air for we'll both concrete Wars and we have as will water Provo and the superstructure we'll make it bit float you can add float like round 4 and first floor second floor as we said our project here or some project three floors on both who just should be third floor and the last thing is go slow and I repeat the same WPS and there are finishes and final finishes as well and get the written words make em even worse fire fighting conveying system usually are putting it for all floors so this one we can name it or floors and the flows how it will be for the rough finishes final finishes electrical work in chemical war so I are fighting conveying system I can copy insert ourselves then I change the color for the label to match with properly so if I miss this one now we'll go to the BOQ to start picking up each activity and putting the quantities and the items under each individual WPS let's see how to do a this is our Sam with p oq' usually the p oq' it's divided into several divisions standard the division to inside construction division 3 is concrete works division for masonry and so on this is standard division you should find in each pill of quantity we will start from the division - one by one until we finish all the division in the PQ and once we finish an ITIN we'll fill it by a color to know that we finish this item and to check double check at the end of this process that we didn't forget any item in the link so the very thing I will make the excavation I have excavation and I have three times of the excavation for the mat foundation is rooted footing and repealed so I am created spacing and my WBS activity under earth work I'll create an activity and I call the activity excavation work and I will give this activity some type of different color so to be identified as activity I have three different type from the excavation so I'll copy Cerrito hose I will save the three rows here and I'll go back to the sample fuel I just delete the spaces and I could be up to here are good on my activity list I'll be a suspicion here okay the use of the percentage : we have if this item repeated in addition of flows so we'll put a percentage for each fluorine but once the active is a excavation only under earth water and substructure so the percentage will be hundred percent first of all you have to modify this one to make it as a percentage then we type 100 percent hundred percent under person and we create our finola to multiply this by the rate by the quantity and we can drag the same and we make this submission so some the activity budget cost and here for my DeSales to show numbers separate off for easy I'll save the sheet it's just age then I'll go to again to my bill of quantity I'll fill this one by some color so I know I finish this item now I'll go to the back filling I'll create a new activity for the back filling I'll copy this one instead coffee sales I'll take one from here straight cold sales and I will call this back filling oops and I will go to the sample p oq' I'll copy this three and I put it here and figure the formula and now save I'm fill this one by our color so we finish now we finish this division of work on site construction before we should body to the division of war put it to 202 this will be easy later on to monitor different divisions okay I'll go to the division three the concrete world I have here the concrete work the blinding which is related to the footings I have three types of blinding so I create an activity or the concrete wall is sorry type concrete work and I'm holy planting concrete again Oh business blind ain't concrete and I'll copy the values and I have to just lead this rose then I'll copy this one to my sample here and this one should be working perfectly the pest is a hundred percent it was the whole amount of our quantity of the binding is belong to the final concrete unsafe put the color here after the blinding we have a this level grade so we'll create a new activity or slovenly I'll take this one once it is one activity only the if I copy and insert copied cells the formulas and everything will be fine so this one will be snap oh great and I'm coming from here the items say and I fill this by color properly confused okay now we go to the isolated 14 go to the Ice Arena for app isolated food we have a great theme have matte foundation so the grid beam usually off Tom sighs wistfully so the very thing I'll make footings in my this ramp I'll send more than three I call this one I put it before trying to make the sequence this all should be three pass away this is Division three so again I'll call it Oh c14 and delete this one the very thing I have isolated 14 copy and paste it here then I'll give it a color grading all passive then I have matte foundation in it then I have after doing these two then I have to do the great beam and water tank so I'm go to this one and I'll get check those formulas won Game five so this is our CVT I'll copy RC footing again and I make a new activity for great beam and water tank holes it's depend on the sequence of you work should go to the drone and the ship what is s equals eleven state so this will be great beam and water tank phones okay this is a great beams and here for me to fill it water tank holes and I feel it water tank top slab but to check how it is now if I'm going to that after grading we'll have another stage which could be the Colo mix so I'll create a new one i watch it : worse then here I'll copy the : I am in that case I'll give it percentage 10% only 10% for the columns and here I have to give it another color between I took a portion of it but the remaining portion I'm not yet finished and then take the course as well I'll give it 10 percent are chickens formulas working things okay I'll save again so this is a columnist I give it the same color now we'll distribute the column and course in the remaining floor to close this item and to the distribution from the column mix will copy and the ground floor and cool it ground floor colons and we change the percentage into 25% 25% then we'll copy it again then we will copy it again and the first of your second floor third the floor and the roof law when we change the person to 10 to 20 from the fairest of law this percentage distribution could be done by the quantity surveil then 15 15 15 15 15 15 to check the then percentage distribution Omega check just equal to 10% here plus 25 plus 20 plus 15 plus 15 plus 15 equal to 100% so now we distributed the coolant into the floors he will change this one to a first floor hold on second floor third floor color and roof slope will do the same concept for everything in the bukey once we finish this one we will go to the p oq' and change this color until the yellow jeans we finish will completely the distribution now we have to make a distribution for the slabs drop beams and the stage the same so you can download now is a file completed file as a distribution I just give you the concept of distributing the items and creating activities with the WVS now from down this video window you will found a download link for the p oq' sample and for the file complete file for the distribution will be used for our next lessons thank you very much you

Channel: undefined

Views: 25,668

Rating: 4.8666668 out of 5

Keywords: L1-Create, Define, Activities, and, WBS, from, Bill, of, Quantities, BOQ, primavera, excel, Microsoft Excel (Software), Management, Technology, Office, time schedule, Data

Id: TXF3aexI_tY

Length: 23min 24sec (1404 seconds)

Published: Tue Nov 20 2012