Rating Worksheets - Instructions

This site contains Microsoft Excel based rating worksheets for residual market autos.  There are separate rating worksheets for the following residual market mechanisms and vehicle types:

    Experience Rating
    Hired Auto
    Miscellaneous Nonfleet Autos
    Nonowned Auto
    Private Passenger Auto
    Public Transportation Auto (Other Than Zone Rated)
    Public Transportation Auto (Zone Rated)
    Truck, Tractor, Trailer (Other Than Zone Rated)
    Truck, Tractor, Trailer (Zone Rated)
    Special Types

Click on the link for the appropriate rating worksheet below. Determine the appropriate worksheet based on the risks to be included in the application (if there are multiple versions of the worksheet(s), use the worksheet(s) with an Effective Date prior to the application's requested effective date and not after another worksheet’s Effective Date).  To find the appropriate rating worksheet, use the search feature.  Select the column and the text for which you want to search.  For example, Browse records in State that contain Florida.  Click Search and all rating worksheets for Florida will appear..

Note that several of the worksheets have multiple tabs.  Complete worksheets for all risk types to be included in the application.  To complete the worksheet, fill in all the variable fields, which are indicated with green text.  Some questions will appear/disappear based on vehicle specific criteria.  Be sure to answer all questions and delete any variable fields that don’t display a corresponding question..

Problems opening or using the rating worksheets

Rating Worksheets

StateRating WorksheetLine Of BusinessEffective DateSorted By Effective Date In Descending Order
FloridaFLRatingWorksheetAutoDealers05-01-2024.xlsxCommercial5/1/2024
FloridaFLRatingWorksheetMiscNonFleet05-01-2024.xlsxPrivate Passenger5/1/2024
FloridaFLRatingWorksheetNamedNonowner05-01-2024.xlsxPrivate Passenger5/1/2024
FloridaFLRatingWorksheetNonownedAuto05-01-2024.xlsxCommercial5/1/2024
FloridaFLRatingWorksheetPrivatePassengerAuto05-01-2024.xlsxPrivate Passenger5/1/2024
FloridaFLRatingWorksheetSpecTypes05-01-2024.xlsxCommercial5/1/2024
FloridaFLRatingWorksheetAutoDealers04-01-2024.xlsxCommercial4/1/2024
FloridaFLRatingWorksheetHiredAuto04-01-2024.xlsxCommercial4/1/2024
FloridaFLRatingWorksheetMiscNonFleet04-01-2024.xlsxPrivate Passenger4/1/2024
FloridaFLRatingWorksheetNonownedAuto04-01-2024.xlsxCommercial4/1/2024
FloridaFLRatingWorksheetPublicNotZone04-01-2024.xlsxCommercial4/1/2024
FloridaFLRatingWorksheetPublicZone04-01-2024.xlsxCommercial4/1/2024
FloridaFLRatingWorksheetSpecTypes04-01-2024.xlsxCommercial4/1/2024
FloridaFLRatingWorksheetTruckNotZone04-01-2024.xlsxCommercial4/1/2024
FloridaFLRatingWorksheetTruckZone04-01-2024.xlsxCommercial4/1/2024
Page 1 of 6First   Previous   [1]  2  3  4  5  6  Next   Last