Microsoft Programmer is a externalize management software programmer formulated and sold by Microsoft which is premeditated to assistance a send manager in processing a organization distribution resources to tasks chase procession managing the budget and analyzing workloads 70-668 Dumps
Member for
13 years 2 months
Member for13 years2 months
Submitted by bogdanleonte on Mon, 2013-03-04 11:03
In MS Project 2010 this can be done by right click-ing the respective column->custom fields, in the menu select formula, insert the formula of the resource hourly cost, which depends on your parameters. Let's take an example:
1. Create Another Number Column with the title Variable Wages (use the custom fields options to create the formula);
2. Create Columns for Parameters that influence the wages:
Parameter 1: Curency - Create a Number Column and enter the name of the colmun and the value of the currency (euro/dolar = 1.23)
Parameter 2: Inside/Outside the Country - Create a Text Column and enter the previous mention Parameters Inside/Outside
Project-level custom fields are only available if you are working with MS Project Server (EPM); they are not if you are working with a stand-alone MS Project, either Professional or Standard
however, you could obtain what you are looking for with task-level custom fields
Alexandre
Member for
24 years 9 months
Member for24 years9 months
Submitted by Vladimir Liberzon on Thu, 2012-06-21 10:25
in Spider Project you can create formulas that link not only fields but also cells, or fields with cells.
And I expect that you will not need formulas for your task. Spider cost components may include expenses in different currencies with different exchange rates that are entered in Cost Components table and you will get total cost selecting what currency to use for total cost (and change this selection at any moment). Exchange rate (cost component unit cost) may be changed in this table and everything will be recalculated.
Since Spider keeps archives you will have a history of exchange rates changes.
If you manage many projects all exchange rates may be set and changed in Cost Components reference-book. In this case all projects that are linked with this reference-book will use the same exchange rates and you can change them in only one place.
do you have in Spider customizable Project - level taks (e.g. USD/Euro echange rate etc), which other field could fere to in formular? (This is opposite to task-level custom fields, which one has in Ms Project).
Member for
24 years 9 months
Member for24 years9 months
Submitted by Vladimir Liberzon on Wed, 2012-06-20 18:02
This would require Project-level custom fields. E.g, I would have single project-level exchange USD/Euro exchange rate field, and 20 resources, whose hourly rate depends on this single custom field.
However in my MS Project project-level custom fields are grayed out
Member for
13 years 10 months
Member for13 years10 months
Submitted by AMAR SOOGRIM on Thu, 2012-05-31 20:16
Member for
12 years 8 monthsMicrosoft Programmer is a
Microsoft Programmer is a externalize management software programmer formulated and sold by Microsoft which is premeditated to assistance a send manager in processing a organization distribution resources to tasks chase procession managing the budget and analyzing workloads 70-668 Dumps
Member for
13 years 2 monthsGreetings,In MS Project 2010
Greetings,
In MS Project 2010 this can be done by right click-ing the respective column->custom fields, in the menu select formula, insert the formula of the resource hourly cost, which depends on your parameters. Let's take an example:
1. Create Another Number Column with the title Variable Wages (use the custom fields options to create the formula);
2. Create Columns for Parameters that influence the wages:
Parameter 1: Curency - Create a Number Column and enter the name of the colmun and the value of the currency (euro/dolar = 1.23)
Parameter 2: Inside/Outside the Country - Create a Text Column and enter the previous mention Parameters Inside/Outside
Parameter 3: Risks (Let's consider Weather Conditions) - Fine Weather, Rain, Snow
3. Insert Formula in step 1:
= if (parameter 2 = option 1 if (parameter 3 = option 2 -> parameter 1 * standar rate * factor 1 * factor 2) else....else...)
and so on.
You might want to use 2 columns for the rates so that you don't end up with a loop.
What you want can be done but it is a little tricky since MS Project.
Hope I was fearly clear about my ideea
Best Regards,
Bogdan
Member for
22 years 9 monthsEvgeny,Project-level custom
Evgeny,
Project-level custom fields are only available if you are working with MS Project Server (EPM); they are not if you are working with a stand-alone MS Project, either Professional or Standard
however, you could obtain what you are looking for with task-level custom fields
Alexandre
Member for
24 years 9 monthsEvgeny,in Spider Project you
Evgeny,
in Spider Project you can create formulas that link not only fields but also cells, or fields with cells.
And I expect that you will not need formulas for your task. Spider cost components may include expenses in different currencies with different exchange rates that are entered in Cost Components table and you will get total cost selecting what currency to use for total cost (and change this selection at any moment). Exchange rate (cost component unit cost) may be changed in this table and everything will be recalculated.
Since Spider keeps archives you will have a history of exchange rates changes.
If you manage many projects all exchange rates may be set and changed in Cost Components reference-book. In this case all projects that are linked with this reference-book will use the same exchange rates and you can change them in only one place.
Member for
17 years 9 monthsVladimir,do you have in
Vladimir,
do you have in Spider customizable Project - level taks (e.g. USD/Euro echange rate etc), which other field could fere to in formular? (This is opposite to task-level custom fields, which one has in Ms Project).
Member for
24 years 9 monthsEvgeny,in Spider Project you
Evgeny,
in Spider Project you would just create a formula.
Amazing that such easy things are so complicated.
Member for
17 years 9 monthsI just found one way to do
I just found one way to do this: By making a link from MS Project to Excel file.
Edit=>Paste Special = Paste link.
The disadvantage is that I have to maintain this link betweem Ms Project and Excel.
Member for
17 years 9 monthsThis would require
This would require Project-level custom fields. E.g, I would have single project-level exchange USD/Euro exchange rate field, and 20 resources, whose hourly rate depends on this single custom field.
However in my MS Project project-level custom fields are grayed out
Member for
13 years 10 monthscheck in the custom feilds.
check in the custom feilds. you should be able to do it there
Member for
17 years 9 monthsSorry for coming back on
Sorry for coming back on this.
Is there really nothing like this, which MS Project has?