Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined function
I am searching for a User defined function that works in Hierarquical
structures. Hierarquical structures contents elements at a level (father) that are divided in different elements at the next level (sons). The Work Break Down Structure used in Project management is one of them, usually each element has a identifying code like this: CODE MH 1 1.1 1.1.1 30 1.1.1.1 10 1.1.1.2 20 1.1.2 1.1.3 1.2 1.3 1.4 If an element has an assigned value (for example man hours MH), the "father" has value of the summation of its "sons" (30=10+20). Calculation is made this way up to the top of the structure. Is it possible to develop a function to calculate the sum of the variable (MH) at any level? (provided that values at the lowest level are known) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined function
Carlos,
The Pivot Table will give you group totals. It won't put them into your existing structure. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Carlos Paez" wrote in message ... I am searching for a User defined function that works in Hierarquical structures. Hierarquical structures contents elements at a level (father) that are divided in different elements at the next level (sons). The Work Break Down Structure used in Project management is one of them, usually each element has a identifying code like this: CODE MH 1 1.1 1.1.1 30 1.1.1.1 10 1.1.1.2 20 1.1.2 1.1.3 1.2 1.3 1.4 If an element has an assigned value (for example man hours MH), the "father" has value of the summation of its "sons" (30=10+20). Calculation is made this way up to the top of the structure. Is it possible to develop a function to calculate the sum of the variable (MH) at any level? (provided that values at the lowest level are known) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined function - Help | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions | |||
USer Defined Function | Excel Programming | |||
Help within user defined function | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |