Expected Primary Losses
Your expected losses are calculated by dividing your payroll by 100 and then multiplying it by the ELR. In the above example, expected losses for code 8810 are calculated as follows:
.10 x (3,750,000 / 100) = 3,750
Here's the calculation for code 8742:
.25 x (1,925,000 / 100) = 4,812.50
Suppose your business is hit with a huge loss after it has been loss-free for many years. One large claim could severely impact your experience modifier. To prevent that from happening, losses are divided into two parts: primary losses and excess losses.
Most states have established a threshold (such as $17,000) that separates primary losses from excess losses. Any loss amount up to the specified threshold is the primary loss while the remaining loss is the excess loss . For many claims, all of the primary loss is included for experience rating but only a portion of the excess loss is used.
The NCCI uses an actuarial factor called the Discount Ratio (D-Ratio) to determine the primary portion of your expected losses. It calculates your primary expected losses by multiplying your expected losses times the discount rate. Your excess expected losses are determined by subtracting your primary expected losses from your total expected losses.
Here are the calculations of expected primary losses for the two class codes shown above:
Code 8842: 3,750 x .38 = 1,425
Code 8742: 4,812.50 x .32 = 1,540
Your experience modifier is calculated by comparing your actual losses to your expected losses.
The last five columns of the worksheet reflect your claims and actual incurred losses, meaning losses you have actually sustained. Here's an example:
Claims and Loss Data | ||||
---|---|---|---|---|
123456 | 05 | F | 20,000 | 17,000 |
654321 | 05 | O | 12,000 | 12,000 |
NO.6 | 06 | F | 13,000 | 13,000 |
Claims are listed under the heading Claims Data. In the above example, the first two claims are listed by their claim number but the third shows NO.6. The letters NO indicate a group of small claims that have been combined while the number shows how many claims have been included. "NO.6" means that six small claims have been lumped together. Small claims (typically those under $2,000) are combined only if they involve the same type of injury.
To the right of the Claims Data is a column with the heading IJ, meaning injury code. This code designates the type of claim. For instance, "5" indicates a medical-only claim while "6" means a temporary disability claim. Next is a column with the heading OF. The letters "O" and "F" designate the claim status. "O" means the claim is still open while "F" means it is final (closed).
The table shown above contains data for eight claims: a group of six medical-only claims and two temporary disability claims. For the purposes of this example, the threshold for primary losses is assumed to be $17,000.
The last two columns contain data applicable to your incurred losses. These are the workers' compensation benefits (medical expenses and disability payments) your insurer has paid to injured workers on your behalf. For claims that remain open, the loss amount may include a reserve (money your insurer has set aside for future payments).
Actual incurred losses means the amount that has been paid for the claim (or group of claims) indicated. Actual primary losses represents that portion of your total losses that's considered primary losses. When actual primary losses are subtracted from actual incurred losses, the result is actual excess losses. Only a portion of excess losses is used for experience rating.
In many states, medical-only claims are subject to an experience rating adjustment (ERA). When the ERA applies, only 30% of the claim amount is used for experience rating. The remaining 70% is ignored. The ERA does not apply to claims that result in disability payments.
The last part of the worksheet shows the experience rating formula and the values used to calculate your modifier.
The formula includes two actuarial factors:
Your experience modifier is calculated by dividing your actual losses by your expected losses. Before that calculation is made, your actual losses and your expected losses are adjusted.
First, your actual losses are determined by calculating the sum of the following three items:
Next, your expected losses are determined by calculating the sum of the following:
Finally, your actual losses are divided by your expected losses. For example, suppose your actual losses (based on the formula) were $45,000 and expected losses were $50,000. Your experience modifier would be $45,000 / $50,000 or .90.
An NCCI experience rating worksheet is given to companies in NCCI states to show them how their experience modifiers were calculated. This information shows how a company's annual premium is either increased or decreased. The worksheet shows information like the last three years of payroll and loss data, expected losses, and more.
The NCCI is the National Council on Compensation Insurance. The NCCI collects data and information to provide insurance rate and loss cost recommendations. States that use the NCCI as their licensed rating and statistical organization and plan administrator include Maine, Maryland, Florida, Kentucky, Louisiana, Missouri, Oklahoma, Texas, Nebraska, Colorado, Utah, Hawaii, and Montana.
NCCI. " ABCs of Experience Rating ."
NCCI. " About Us ."
NCCI. " NCCI State Map ."
By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.
Learn about worksheets and spreadsheets in Excel and Google Sheets
A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Microsoft Excel or Google Sheets . A workbook is the name given to an Excel file and contains one or more worksheets. When you open an electronic spreadsheet program, it loads an empty workbook file consisting of one or more blank worksheets for you to use.
Instructions in this article apply to Excel for Microsoft 365, Excel 2019, 2016, 2013, and 2010; Excel for Mac, Excel Online, and Google Sheets.
You use worksheets to store, manipulate, and display data .
The primary storage unit for data in a worksheet is a rectangular-shaped cell arranged in a grid pattern in every sheet. Individual cells of data are identified and organized using the vertical column letters and horizontal row numbers of a worksheet , which create a cell reference, such as A1, D15, or Z467.
Worksheet specifications for current versions of Excel include:
For Google Sheets:
In both Microsoft Excel and Google Sheets, each worksheet has a name. By default, the worksheets are named Sheet1, Sheet2, Sheet3, and so on, but you can change these names.
In Excel, use the following shortcut key combinations to switch between worksheets :
In Google Sheets, the shortcut key combinations to switch between worksheets are:
Get the Latest Tech News Delivered Every Day
By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Represents a worksheet.
The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook.
The Worksheet object is also a member of the Sheets collection. The Sheets collection contains all the sheets in the workbook (both chart sheets and worksheets).
Use Worksheets ( index ), where index is the worksheet index number or name, to return a single Worksheet object. The following example hides worksheet one in the active workbook.
The worksheet index number denotes the position of the worksheet on the workbook's tab bar. Worksheets(1) is the first (leftmost) worksheet in the workbook, and Worksheets(Worksheets.Count) is the last one. All worksheets are included in the index count, even if they are hidden.
The worksheet name is shown on the tab for the worksheet. Use the Name property to set or return the worksheet name. The following example protects the scenarios on Sheet1.
When a worksheet is the active sheet, you can use the ActiveSheet property to refer to it. The following example uses the Activate method to activate Sheet1, sets the page orientation to landscape mode, and then prints the worksheet.
This example uses the BeforeDoubleClick event to open a specified set of files in Notepad. To use this example, your worksheet must contain the following data:
When you double-click cell A1, the files specified in cell A1 are opened in Notepad.
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Reading & Math for K-5
Breadcrumbs
Download & Print Only $4.99
Vocabulary worksheets: correct definition.
At its most basic, students learn the meaning of words by their definitions. In these worksheets, students are given a choice of four words to match to each definition.
These worksheets are available to members only.
Join K5 to save time, skip ads and access more content. Learn More
What is K5?
K5 Learning offers free worksheets , flashcards and inexpensive workbooks for kids in kindergarten to grade 5. Become a member to access additional content and skip ads.
Our members helped us give away millions of worksheets last year.
We provide free educational materials to parents and teachers in over 100 countries. If you can, please consider purchasing a membership ($24/year) to support our efforts.
Members skip ads and access exclusive features.
Learn about member benefits
This content is available to members only.
IMAGES
VIDEO
COMMENTS
noun work· sheet ˈwərk-ˌshēt plural worksheets 1 a : a sheet that is used in making preliminary plans, auxiliary computations, notes, or comments as a guide in doing some piece of work An electricity worksheet is simply a piece of paper listing all of your household appliances with their wattage. George Johnson b
worksheet noun [ C ] WORKPLACE uk / ˈwɜːkˌʃiːt / us a document showing work that needs to be done or that has been done: The project worksheet spells out the scope of work to be done and how it will be financed. (Definition of worksheet from the Cambridge Business English Dictionary © Cambridge University Press) Examples of worksheet worksheet
worksheet / ( ˈwɜːkˌʃiːt) / noun a sheet of paper used for the preliminary or rough draft of a problem, design, etc a piece of paper recording work being planned or already in progress a sheet of paper containing exercises to be completed by a pupil or student
work·sheet (wûrk′shēt′) n. 1. A form used for calculating, comparing, or analyzing data. 2. A form with questions or exercises for students. 3. A spreadsheet. 4. A sheet of paper used for preliminary notes or computations. American Heritage® Dictionary of the English Language, Fifth Edition.
noun A sheet of paper on which a record of work, working time, etc. is kept. Webster's New World A form used for calculating, comparing, or analyzing data. American Heritage A sheet of paper printed with practice exercises, problems, etc., to be worked on directly by students. Webster's New World Similar definitions A spreadsheet. American Heritage
worksheet noun. a sheet of paper with multiple columns; used by an accountant to assemble figures for financial statements. worksheet noun. a piece of paper recording work planned or done on a project.
The worksheet lists the policy number and effective dates for each policy period. It also shows the five-digit carrier code, a number assigned by the NCCI that identifies the insurer that issued the policy. 1 Class Codes, Payroll, and Expected Losses
A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Microsoft Excel or Google Sheets. A workbook is the name given to an Excel file and contains one or more worksheets.
The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook. The Worksheet object is also a member of the Sheets collection. The Sheets collection contains all the sheets in the workbook (both chart sheets and worksheets). Example
Vocabulary worksheets: correct definition. At its most basic, students learn the meaning of words by their definitions. In these worksheets, students are given a choice of four words to match to each definition. Worksheet #1 Worksheet #2 Worksheet #3 Worksheet #4. 2 More.