Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 117

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/edifast0/public_html/corp/libraries/joomla/utilities/date.php on line 169
Artigos Construção e Engenharia Corp.eng.br - Site pessoal compartilhado para diversos assuntos: linux, fotos, arquivos, dicas, etc... http://corp.eng.br/index.php?option=com_content&view=section&id=12&Itemid=134 Sun, 19 Nov 2017 19:29:41 +0000 Joomla! 1.5 - Open Source Content Management pt-br Investimento Imobiliário - Alguns Links http://corp.eng.br/index.php?option=com_content&view=article&id=348:investimento-imobiliario-alguns-links&catid=159:investimento-imobiliario&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=348:investimento-imobiliario-alguns-links&catid=159:investimento-imobiliario&Itemid=134 Primeiros artigos visualizados:

http://www.guiadeinvestimento.com.br/investimento-imobiliario/

http://www.imovelcompra.com.br/

http://www.aditnordeste.org.br/brasil/mercado_imobiliario/?idioma=pt

]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Investimento Imobiliário Wed, 15 Sep 2010 02:57:34 +0000
Alternativas ao MS Project http://corp.eng.br/index.php?option=com_content&view=article&id=322:alternativas-ao-ms-project&catid=127:gerenciamento-de-projetos&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=322:alternativas-ao-ms-project&catid=127:gerenciamento-de-projetos&Itemid=134 link: http://microsoft-project-freeware.qarchive.org/

 

]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Gerenciamento de Projetos Thu, 13 May 2010 17:06:45 +0000
Project Management Tools http://corp.eng.br/index.php?option=com_content&view=article&id=321:project-tools&catid=127:gerenciamento-de-projetos&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=321:project-tools&catid=127:gerenciamento-de-projetos&Itemid=134 Se procura ferramentas para gerenciamento de projetos veja este link: http://project.mvps.org/comprods.htm

]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Gerenciamento de Projetos Thu, 13 May 2010 00:07:48 +0000
Como utilizar a Macro de Montecarlo para MS Project do sourceforge http://corp.eng.br/index.php?option=com_content&view=article&id=320:como-utilizar-a-macro-de-montecarlo-para-ms-project-do-sourceforge&catid=127:gerenciamento-de-projetos&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=320:como-utilizar-a-macro-de-montecarlo-para-ms-project-do-sourceforge&catid=127:gerenciamento-de-projetos&Itemid=134 Link Original: http://rule-of-thumb.net/monte-carlo-simulation-for-ms-project/

Monte Carlo Simulation for MS Project

Inspired by the work of Jack Dahlgren on Free Monte Carlo Simulator for Microsoft Project and with a help of insightfull posts from Glen Alleman on Herding Cats as well as a lot of Googling around I started an open source project Monte Carlo Simulation for MS Project on SourceForge.net.

The purpose of the project is to explore the possibilities of Monte Carlo simulation in the area of project management.

It is not the purpose of the project to compete with professional quantitative risk assesment tools like @Risk (by Palisade), Risk+ (by Deltek) or Crystall Ball (by Oracle, formerly by Decisioneering).

What can Monte Carlo Simulation for MS Project (MCS) do for you?

There are many risks on projects and one of the obvious is that tasks will take more or less time than planned. As theory goes, duration/work on tasks is a random variable with certain probability distribution.

As there are extremely rare cases where we can actually measure cumulative distribution function, which would completely describe probability distribution and even more rare cases where we simply know which probability distribution is the right one and what are its parameters, we have to assume certain distribution. Since triangular distribution looks just as good as any other skewed distribution (beta, betapert, lognormal) from far enough distance and due to practical and performance reasons I started with triangular distribution, which is defined with minimum, maximum and most likely (mode) values.

Since it is very unrealistic to actually define a minimum and a maximum value, MCS offers you an option to enter which percentiles are you estimating. I suggest to use 10th and 90th percentile, which means that 9 out of 10 tasks will complete inside min-max range and one will complete outside of its min-max range, which is much more realistic than saying all my tasks will complete inside estimated range.

MCS uses Duration1 and Duration3 fields to store minimum and maximum estimates plus Duration or Work for most likely estimate. If task type is set to Fixed Duration, then Work field is used as most likely value and during simulation run, Work field is substituted with a random value. If task type is set to a value, other than Fixed Duration, then Duration field is used as most likley value and during simulation run, Work field is substituted with a random value.

There may be other sources of variance on the project, but currently, they’re not taken into account during simulation. Such sources of variance might be:

  • resource availability
  • resource rates (for cost simulations)
  • lag times
  • time constraints
  • etc.

MCS works by going through all non summary tasks and assigning random triangularly distributed value to Work or Duration, depending on its Type and taking Duration1 and Duration3 as input parameters for triangular distribution. At the end of each run, project is recalculated and these tasks variables are stored for all project’s tasks:

  • finish time
  • duration
  • work
  • cost

Same variables are stored for the entire project as well.

At the end of the simulation, various reports are produced in Microsoft Excel:

  • sensitivity analysis for duration, work and cost, based on Spearman’s rank correlation between tasks value and project’s value,
  • criticality analysis based on calculating the percentage of runs where certain task was on a critical path,
  • project finish, duration, work and cost distribution charts with relevant descriptive statistics and calculated percentiles.
  • milestones finish dates distribution charts with relevant descriptive statistics and calculated percentiles.
  • resources workload distribution charts with relevant descriptive statistics and calculated percentiles.

Installation

  • Download the package from SourceForge,
  • Unzip it to some folder.
  • Run Microsoft Project.
  • Press Alt-F11 to run Visual Basic Editor.
  • Import all .bas and .cls files from the package into Global.MPT project, so that the application is available to all projects. Warning: Some files in ALGLIB libraries are duplicates. Import them only once!
  • Select Tools and References and check Microsoft Excel Object Library.
Running Monte Carlo Simulation
  • From Microsoft Project select Tools, Macros and run MCS macro.
  • Type in the number of iterations to perform. You might want to experiment with 100 and going beyond 1000 doesn’t make much sense.
  • Type in percentile at which you’ve estimated lower and upper bounds. 0,1 means 10th and 90th percentile.
  • Kaboom.

]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Gerenciamento de Projetos Wed, 12 May 2010 22:39:10 +0000
Macro do Project para análise de Montecarlo http://corp.eng.br/index.php?option=com_content&view=article&id=319:macro-do-project-para-analise-de-montecarlo&catid=127:gerenciamento-de-projetos&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=319:macro-do-project-para-analise-de-montecarlo&catid=127:gerenciamento-de-projetos&Itemid=134 link original: http://masamiki.com/project/blackjack.htm

 

Blackjack Simple Monte Carlo Simulator for Microsoft Project

Monte Carlo simulation is a method of determining a probability distribution for the dates within your project. By using this technique you can determine the statistical probability of meeting a certain date. This solution uses Project and Excel together to generate the results needed to calculate probability.

What is Monte Carlo Simulation?

Monte Carlo Simulation is so named because it is based on a large number of random outcomes, just like you would find at a casino in Monte Carlo. In Monte Carlo one can never be certain if a particular gambler will win or lose, but one can be certain that the casino, overall, will never lose. This is because the games played in casinos have a slight advantage to the Casino so given a large number of gamblers - some winning and some losing - the average result will be in the Casino's favor. Monte Carlo Simulation depends on the fact that the results of a large number of individual random events will accurately describe the probability distribution of the individual event.

To illustrate this let's use a simple example from a casino. A pair of dice has a 36 possible combinations that can occur. The sum can be anywhere from 2 (1+1) to 12 (6+6) and 7 (1+6 or 2+5 or 3+4 or 4+3 or 5+2 or 6+1), is the most likely outcome. The following chart shows the probability distribution:

If we roll the dice one time we will get a result somewhere within here, maybe a seven, or maybe a two. However, if we roll the dice a couple of hundred times we will get a large number of results. If we plot those results they will closely match the outcome that is predicted by the probability distribution.

Calculating the probability distribution for two dice is very simple. It takes less time to calculate the probability distribution than it does to roll the dice a hundred times.  However if we have a schedule with a number of different tasks which are related through a series of dependencies, calculating the probability distribution is very very difficult. This is where the simulation comes in. Instead of constructing and doing the mathematics to determine the probability distribution for the schedule, we use the power of the computer to "roll the dice" for us a large number of times. We know that the results of a large enough number of tries will match the true probability.

What the simulator does:

The user enters values for the optimistic duration for each activity in the duration2 field and the pessimistic duration in the duration3 field. This sets a triangular probability distribution with the optimistic duration being the lower bound, pessimistic being the upper and the duration being the most likely value.

The user then marks the tasks that they wish to export results for by setting the Flag10 field to yes.

Once this is complete, the user runs the macro titled "Blackjack" and follows the prompts.

The output of the macro is a series of dates in an excel file. Using a simple pivot table the results can be charted showing the probability distribution. A sample excel file with calculations can be downloaded (here when I finish it).

Here is the code. Please read the instructions for installing below paying particular attention to setting the excel references correctly.

'set some global variables
Dim iter As Integer
Dim exportedTasks, monteCarloTasks As Tasks
Dim myCancel As Boolean

Sub Blackjack()
'A simple monte carlo simulation macro for Microsoft Project
'User marks tasks to export data for by entering yes in the flag10 field
'User enters an optimistic duration in the duration2 field
'and a pessimistic duration in the duration3 field
'The macro uses those durations along with the standard duration
'as the points of a triangular distribution
'It then iterates through all the tasks a number of times up to 3000
'The data is then exported to Excel where through the data tool
'(pivot tables etc.) the user can analyze and graph the results.
'Copyright 2004 - Jack Dahlgren
'version 1.0

Dim i As Integer
Dim dates As String
Dim xlRow As Excel.Range
Dim t As Task
Dim ts As Integer
myCancel = False
'Prompt for number of iterations
getIter
'get collection of tasks to export
setExportedTasks
'get collection of tasks to perform simulation on
setMonteCarloTasks
'set the random seed
Randomize
'If the user cancels out of earlier subprocedure
'or if they have an error (no tasks for example) then
'myCancel is set to true and is passed to exit this subprocedure
If myCancel = True Then Exit Sub
'create a new instance of excel
'and set it up
Set xlapp = New Excel.Application
xlapp.Visible = False
Set xlBook = xlapp.Workbooks.Add
Set xlSheet = xlBook.Worksheets.Add
xlSheet.Name = ActiveProject.Name
Set xlRow = xlapp.ActiveCell
'turn off screenupdating to reduce the time spent updating the screen
'I'm not sure this has too much of an effect on this code.
xlapp.ScreenUpdating = False
MSProject.ScreenUpdating = False
ts = 0
'write out the task names for exported tasks in the first row
For Each t In exportedTasks
xlRow = t.Name
Set xlRow = xlRow.Offset(0, 1)
ts = ts + 1
Next t
'iter is the number of iterations chosen by the user
'this loop sets the duration to a random but representative
'value within the triangular distribution, recalcs the project and then
'writes the results to excel one time for each iteration
For i = 0 To iter
Set xlRow = xlRow.Offset(1, 0)
Set xlRow = xlRow.Offset(0, -ts)
'Here we call the TriDist function which returns a value we will use for
'the duration. We do this for all valid tasks
For Each t In monteCarloTasks
t.Duration = TriDist(Rnd(), t.Duration2, t.Duration, t.Duration3)
Next t
'once the new duration is set we recalculate the schedule
Application.CalculateProject
'then write to excel
For Each t In exportedTasks
xlRow = t.Finish
Set xlRow = xlRow.Offset(0, 1)
Next t
Next i
'When we are done we reset the duration to what it was at the beginning
'this value has been store in the setMonteCarloTasks subprocedure
For Each Task In ActiveProject.Tasks
Task.Duration = Task.Duration1
Next Task
'turn the screen updating back on so we can see the results
xlapp.ScreenUpdating = True
MSProject.ScreenUpdating = True
'and finally display a message that we are finished
AppActivate "Microsoft Project"
MsgBox "Done"
xlapp.Visible = True
AppActivate "Microsoft Excel"
End Sub

Sub getIter()
'prompts user for number of iterations
'recurses if value is not numeric or
'is out of range
Dim Viter As Variant
'ask the user for a value. Default is 500, so clicking OK
'should be the easiest/best choice
Viter = InputBox("Enter Number of Iterations" & Chr(13) & "Must be between 0 and 3000", "Jack's Free Monte Carlo Simulator", 500)
'check to see if what the user entered is a number
If Not IsNumeric(Viter) Then
'if it isn't tell them
MsgBox "the value you have entered is not a number"
'and ask again
getIter
Else
'check to see if the number is a decent number.
'good results probably need at least a hundred iterations and
'more than a thousand or so usually will add little
If ((0 Viter)) Then
'convert the user's answer to an integer
'and set our variable to the integer
iter = CInt(Viter)
Else
MsgBox "You must enter a value less than 3000"
'once again a bad answer here means we ask the
'question again by recursively calling getIter
getIter
End If
End If
End Sub

Sub setExportedTasks()
'filters to get collection of tasks for export
'with flag10 set to yes
'warn if export is more than 20 tasks
'Tasks are filtered for a positive value in flag10
FilterEdit Name:="_MCexportedTasks", TaskFilter:=True, Create:=True, OverwriteExisting:=True, FieldName:="Flag10", Test:="equals", Value:="yes", ShowInMenu:=False, ShowSummaryTasks:=False
FilterApply Name:="_MCexportedTasks"
'then the tasks are selected
SelectAll
'if there are no tasks that meet the criteria we display a warning and quit
If ActiveSelection = 0 Then
'this line is needed to tell the "monte" subprocedure to exit too.
myCancel = True
MsgBox "You have no tasks to export data for" & Chr(13) _
& "Please check the flag10 field to be sure that some tasks are marked YES"
Exit Sub
End If
'take the selection and turn it into a collection of tasks
Set exportedTasks = ActiveSelection.Tasks
exportcount = exportedTasks.Count
'we don't want to operate on more than 25
'and even that is a large number. 5 or so would make sense
If exportcount > 25 Then
'this asks if it is ok and if it is not OK then we exit as before
If MsgBox("You are exporting " & exportcount & " tasks" & Chr(13) & "Are you sure you want to continue?", vbOKCancel, "Large Export Warning") = vbCancel Then
myCancel = True
Exit Sub
End If
End If
End Sub
Sub setMonteCarloTasks()
Dim t As Task
'filters to get collection of tasks for export
'with flag11 set to yes
For Each t In ActiveProject.Tasks
'this part does two things
If Not t Is Nothing Then
'first it stores the duration into duration1 so we can restore it
'back to what it was when we finish calculating
t.Duration1 = t.Duration
t.Flag11 = "No"
If Not t.Summary Then
'second it checks to see if optimistic and pessimistic durations
'are entered for tasks. If they are then flag11 is set to indicate
'that it is a task that should be calculated. If there is missing data or
'bad data we ignore the task
'Probably a good idea to have a routine that helps users enter
'and check these before starting
If (t.Duration >= t.Duration2) And (t.Duration <= t.Duration3) Then
t.Flag11 = "Yes"
End If
End If
End If
Next t
'now we filter for valid tasks
FilterEdit Name:="_MCTasks", TaskFilter:=True, Create:=True, OverwriteExisting:=True, FieldName:="Flag11", Test:="equals", Value:="yes", ShowInMenu:=False, ShowSummaryTasks:=False
FilterApply Name:="_MCTasks"
SelectAll
'check to make sure there is at least one
If ActiveSelection = 0 Then
MsgBox "You have no valid tasks for the macro to work on"
myCancel = True
Exit Sub
End If
'and finally set them as the tasks we will recalculate
Set monteCarloTasks = ActiveSelection.Tasks
End Sub

Function TriDist(ByVal prob As Single, ByVal opt As Single, ByVal expect As Single, ByVal pess As Single)
'this function returns a value from within the triangularity probablility
Dim x, d As Single
d = pess - opt
x = (expect - opt) / d
If prob <= x Then TriDist = opt + (((prob * x) ^ 0.5) * d)
If prob > x Then TriDist = pess - ((((1 - prob) * (1 - x)) ^ 0.5) * d)
End Function

]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Gerenciamento de Projetos Wed, 12 May 2010 22:28:05 +0000
What is a carbon FootPrint? http://corp.eng.br/index.php?option=com_content&view=article&id=212:what-is-a-carbon-footprint&catid=126:sustentabilidade&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=212:what-is-a-carbon-footprint&catid=126:sustentabilidade&Itemid=134 Link: http://www.carbonfootprint.com/carbonfootprint.html

A carbon footprint is a measure of the impact our activities have on the environment, and in particular climate change. It relates to the amount of greenhouse gases produced in our day-to-day lives through burning fossil fuels for electricity, heating and transportation etc.

The carbon footprint is a measurement of all greenhouse gases we individually produce and has units of tonnes (or kg) of carbon dioxide equivalent.

A carbon footprint is made up of the sum of two parts, the primary footprint (shown by the green slices of the pie chart) and the secondary footprint (shown as the yellow slices).

1. The primary footprint is a measure of our direct emissions of CO2 from the burning of fossil fuels including domestic energy consumption and transportation (e.g. car and plane). We have direct control of these.

2. The secondary footprint is a measure of the indirect CO2 emissions from the whole lifecycle of products we use - those associated with their manufacture and eventual breakdown. To put it very simply – the more we buy the more emissions will be caused on our behalf.

Carbon Footprint Calculator: http://www.carbonfootprint.com/calculator.aspx

]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Sustentabilidade Wed, 22 Apr 2009 14:27:52 +0000
Video How to reduce your carbon footprint at home http://corp.eng.br/index.php?option=com_content&view=article&id=211:video-how-to-reduce-your-carbon-footprint-at-home&catid=126:sustentabilidade&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=211:video-how-to-reduce-your-carbon-footprint-at-home&catid=126:sustentabilidade&Itemid=134 http://www.youtube.com/watch?v=HJwt9nwCElA]]> aarvati@corp.eng.br (Ademar Arvati Filho) Sustentabilidade Wed, 22 Apr 2009 14:17:14 +0000 Video Green Building & Remodeling For Dummies http://corp.eng.br/index.php?option=com_content&view=article&id=210:video-green-building-a-remodeling-for-dummies&catid=126:sustentabilidade&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=210:video-green-building-a-remodeling-for-dummies&catid=126:sustentabilidade&Itemid=134 http://www.youtube.com/watch?v=igoT_vTGDkI]]> aarvati@corp.eng.br (Ademar Arvati Filho) Sustentabilidade Wed, 22 Apr 2009 14:12:54 +0000 Video How to remodel for a green home http://corp.eng.br/index.php?option=com_content&view=article&id=209:video-how-to-remodel-for-a-green-home&catid=126:sustentabilidade&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=209:video-how-to-remodel-for-a-green-home&catid=126:sustentabilidade&Itemid=134 http://www.youtube.com/watch?v=-Q6ou6-F9dg]]> aarvati@corp.eng.br (Ademar Arvati Filho) Sustentabilidade Wed, 22 Apr 2009 14:10:53 +0000 Video Reuse Everyday Itens http://corp.eng.br/index.php?option=com_content&view=article&id=208:video-reuse-everyday-itens&catid=126:sustentabilidade&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=208:video-reuse-everyday-itens&catid=126:sustentabilidade&Itemid=134 http://www.youtube.com/watch?v=XCmQhwoKb3A]]> aarvati@corp.eng.br (Ademar Arvati Filho) Sustentabilidade Wed, 22 Apr 2009 14:02:26 +0000 Video House Net Zero http://corp.eng.br/index.php?option=com_content&view=article&id=207:video-house-net-zero&catid=126:sustentabilidade&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=207:video-house-net-zero&catid=126:sustentabilidade&Itemid=134 http://www.youtube.com/watch?v=SV3euyl8mlw]]> aarvati@corp.eng.br (Ademar Arvati Filho) Sustentabilidade Wed, 22 Apr 2009 13:57:18 +0000 Vídeo Sustainable Skyscraper http://corp.eng.br/index.php?option=com_content&view=article&id=206:video-sustainable-skyscraper&catid=131:grandes-construcoes&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=206:video-sustainable-skyscraper&catid=131:grandes-construcoes&Itemid=134
Link: http://www.youtube.com/watch?v=ySeBgt64NEI
]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Grandes Construções Wed, 22 Apr 2009 13:09:39 +0000
Seis passos para a seleção de Insumos e Fornecedores com Critérios de Sustentabilidaade http://corp.eng.br/index.php?option=com_content&view=article&id=196:criterio-sustentabilidade&catid=126:sustentabilidade&Itemid=134 http://corp.eng.br/index.php?option=com_content&view=article&id=196:criterio-sustentabilidade&catid=126:sustentabilidade&Itemid=134 Não existe sustentabilidade sem formalidade, legalidade e qualidade. A informalidade tem muitas facetas: (a) sonegação de impostos; (b) desrespeito a legislação ambiental; (c) desrespeito a legislação trabalhista. O Comitê de Materiais desenvolveu uma ferramenta para auxiliar os projetistas, empreendedores e usuários na seleção dos fornecedores e dos materiais que serão utilizados nas obras. Esse sistema não esgota o assunto, mas é uma estratégia viável para abordar práticas acessíveis a todos os compradores e especificadores de materiais e fornecedores.

Link com os seis passos: http://www.cbcs.org.br/hotsite/index.php?NO_LAYOUT=true

  1. Verificação da formalidade das empresas fornecedoras
  2. Verificação da formalidade da empresa: licença ambiental da unidade fabril
  3. Qualidade do Produto: Respeito às normas técnicas
  4. Analisar o perfil de responsabilidade socioambiental da empresa
  5. Cuidado com “verniz verde” (Green washing)
  6. Analise a durabilidade do produto nas condições do seu projeto

Elaboração

Claudia Martins (Interface Flooring Systems)
Diana Csillag (CBCS)
Vanderley M. John (Poli USP) – coordenador CT materiais CBCS
Vera F. Hachich (Tesis Eng.)

]]>
aarvati@corp.eng.br (Ademar Arvati Filho) Sustentabilidade Wed, 15 Apr 2009 18:26:13 +0000