Excel VBA Data Validation Functions -- 2
Budget: $30 – $250 USD
I have an excel macro that is a special kind of calculator we use for labor entries into our system.
One condition currently produces an error we need fixing
Where
Labor Type = Cleanroom
Error is in ‘Working Document’. This is currently calculating incorrectly.
Its correct calculation should be:
Calculation = (time to form Sterilizer Box [variable default tab, MFG-03 Cleanroom Defaulted Variables] * Secondary output[user input, Secondary Output Number]) + (Bag Drop*(qty per FG Box[user input, Qty Per Product BOM]) /Bag Per Sterilizer Box[variable default tab, MFG-03 Cleanroom Defaulted Variables]))
As for the rest of this macro, I think it could use some general polishing and improvements. The way it calculates/outputs is correct. I just think it could maybe use some re-configuring as far as making it more user friendly.
One condition currently produces an error we need fixing
Where
Labor Type = Cleanroom
Error is in ‘Working Document’. This is currently calculating incorrectly.
Its correct calculation should be:
Calculation = (time to form Sterilizer Box [variable default tab, MFG-03 Cleanroom Defaulted Variables] * Secondary output[user input, Secondary Output Number]) + (Bag Drop*(qty per FG Box[user input, Qty Per Product BOM]) /Bag Per Sterilizer Box[variable default tab, MFG-03 Cleanroom Defaulted Variables]))
As for the rest of this macro, I think it could use some general polishing and improvements. The way it calculates/outputs is correct. I just think it could maybe use some re-configuring as far as making it more user friendly.
Related categories:
PHP
Visual Basic
Excel
Software Architecture
Excel VBA
Excel Macros
Data Analysis