Kenny537
asked on
How can I organize this data [lots of variables and outcomes]
Hello,
I have a algorithms for 13 different states on how to calculate insurance premiums.
For example, part of an algorithm for Nevada could be:
------------------
MANUAL PREMIUM [(Payroll / 100) * RATE]
+ Supplementary Disease [(SUBJECT PAYROLL / 100) * DISEASE RATE]
TOTAL MANUAL PREMIUM
+Waiver of Subrogation factor [% applied to the portion of Total Manual Premium where waiver is applicable]
-----------------
That is just a small portion of an algorithm for a particular state. Each line can be considered a "Premium Element". The issue is that different states have differences in Premium Elements (i.e. TN will not have a Waiver of Subrogation factor).
The first thing I want to do, before even figuring out the best way to configure it, is compare the differences in premium elements for the various states.
Right now, I can manually look over the data for all 13 states and create 3 columns: Premium Elements, States that have it, and States that don't have it. However, this seems very tedious and inefficient - there has to be a better way to at least present this data.
Any tips/suggestions would be appreciated!
I have a algorithms for 13 different states on how to calculate insurance premiums.
For example, part of an algorithm for Nevada could be:
------------------
MANUAL PREMIUM [(Payroll / 100) * RATE]
+ Supplementary Disease [(SUBJECT PAYROLL / 100) * DISEASE RATE]
TOTAL MANUAL PREMIUM
+Waiver of Subrogation factor [% applied to the portion of Total Manual Premium where waiver is applicable]
-----------------
That is just a small portion of an algorithm for a particular state. Each line can be considered a "Premium Element". The issue is that different states have differences in Premium Elements (i.e. TN will not have a Waiver of Subrogation factor).
The first thing I want to do, before even figuring out the best way to configure it, is compare the differences in premium elements for the various states.
Right now, I can manually look over the data for all 13 states and create 3 columns: Premium Elements, States that have it, and States that don't have it. However, this seems very tedious and inefficient - there has to be a better way to at least present this data.
Any tips/suggestions would be appreciated!
ASKER
Well I didn't mean to necessarily combine the code. It's more for analysis reasons at this point.
For this type of insurance (worker's compensation), if the customer has employees in multiple states, the policy would still be applicable, however, the algorithms would be calculated differently based on the respective states (as I understand it).
But to consider combining the code or not combining the code is jumping ahead - right now I simply want to present the differences in the algorithms.
Does that make sense?
For this type of insurance (worker's compensation), if the customer has employees in multiple states, the policy would still be applicable, however, the algorithms would be calculated differently based on the respective states (as I understand it).
But to consider combining the code or not combining the code is jumping ahead - right now I simply want to present the differences in the algorithms.
Does that make sense?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Delete the question.
Or not ;-)
No worries - glad to help.
No worries - glad to help.
If you have a compelling reason to share code between the states, I'd like to hear it.