I am having issues trying to create a field calculator function based on a coded domain string parameter combined with a numeric field to obtain a percentage output.
The example in question is as follows:
Coded condition attribute of "Good,Poor, Excellent", these are based on install date, material and ground surface.
I want a way to automate a field of 'Depreciation' to illustrate that without simply having a static percentage based on the coded field, but the ability to have different permutations within that range based on other factors.
Poor would for example have a range of 1-30% remaining on the expected life (function of install date)
The question: Could I randomize the value between 1-30 based on the factors and have them 'modify' the output? For example Poor condition Asbestos Concrete Pipe would have a higher depreciated value compared to Ductile Iron.
How would I go about modeling this in a manageable way?
أكثر...
The example in question is as follows:
Coded condition attribute of "Good,Poor, Excellent", these are based on install date, material and ground surface.
I want a way to automate a field of 'Depreciation' to illustrate that without simply having a static percentage based on the coded field, but the ability to have different permutations within that range based on other factors.
Poor would for example have a range of 1-30% remaining on the expected life (function of install date)
The question: Could I randomize the value between 1-30 based on the factors and have them 'modify' the output? For example Poor condition Asbestos Concrete Pipe would have a higher depreciated value compared to Ductile Iron.
How would I go about modeling this in a manageable way?
أكثر...