Banner Ad 1

Collapse

Announcement

Collapse
No announcement yet.

Inputting “age band” rate tables to excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Towanda
    replied
    Originally posted by camel61 View Post
    �Age band� rate tables can be input �longhand� to excel spreadsheets as lookup tables. For example, the rate table;

    Age rate
    <50 0
    51 to 55 0.1
    56 to 60 0.2
    61 to 65 0.3

    can be input as

    Age rate
    16 0
    17 0
    18 0
    19 0
    20 0
    21 0
    22 0
    23 0
    24 0
    25 0
    26 0
    27 0
    28 0
    29 0
    30 0
    31 0
    32 0
    33 0
    34 0
    35 0
    36 0
    37 0
    38 0
    39 0
    40 0
    41 0
    42 0
    43 0
    44 0
    45 0
    46 0
    47 0
    48 0
    49 0
    50 0
    51 0.1
    52 0.1
    53 0.1
    54 0.1
    55 0.1
    56 0.2
    57 0.2
    58 0.2
    59 0.2
    60 0.2
    61 0.3
    62 0.3
    63 0.3
    64 0.3
    65 0.3
    Okay,this is interesting here!

    Leave a comment:


  • camel61
    started a topic Inputting “age band” rate tables to excel

    Inputting “age band” rate tables to excel

    “Age band” rate tables can be input “longhand” to excel spreadsheets as lookup tables. For example, the rate table;

    Age rate
    <50 0
    51 to 55 0.1
    56 to 60 0.2
    61 to 65 0.3

    can be input as

    Age rate
    16 0
    17 0
    18 0
    19 0
    20 0
    21 0
    22 0
    23 0
    24 0
    25 0
    26 0
    27 0
    28 0
    29 0
    30 0
    31 0
    32 0
    33 0
    34 0
    35 0
    36 0
    37 0
    38 0
    39 0
    40 0
    41 0
    42 0
    43 0
    44 0
    45 0
    46 0
    47 0
    48 0
    49 0
    50 0
    51 0.1
    52 0.1
    53 0.1
    54 0.1
    55 0.1
    56 0.2
    57 0.2
    58 0.2
    59 0.2
    60 0.2
    61 0.3
    62 0.3
    63 0.3
    64 0.3
    65 0.3
Working...
X