E2 fx 7.00
A
B
C
D
E
F
G
H
Case Variables
Value
Damages Start Date
01/01/22
Damages End Date
12/31/25
Off the Clock hours
7.00
Chance of Success
Full Value
%
Discounted
Unpaid Straight Time Up to 40H
$2,046,543
0%
$2,046,543
Unpaid Straight Time Over 40H
$4,153,122
0%
$4,153,122
Unpaid Overtime Premium
$6,199,665
0%
$6,199,665
Liquidated Damages
$12,399,330
0%
$12,399,330
Global Discounts
%
Amount
Global Discount 1
0%
$0
Global Discount 2
0%
$0
Global Discount 3
0%
$0
Extrapolations
Full Value
%
Discounted
Before Data Period
$683,217
0%
$683,217
Within Data Period
$231,594
0%
$231,594
After Data Period
$1,387,452
0%
$1,387,452
Damage Total After Discount $27,100,922
Settlement Authority
Damages
Walker, Jordan
$17,214
Romero, Sofia
$14,044
Front End
Weekly Damages
Extrapolations
Allocations
Click anywhere to advance
Extrapolations Automatically Respond To Your Discounts
From The Front End
Chance of Success
Full Value
%
Discounted
Unpaid Straight Time Up to 40H
$4,093,086
0%
$4,093,086
Unpaid Straight Time Over 40H
$8,306,243
0%
$8,306,243
Unpaid Overtime Premium
$12,399,330
0%
$12,399,330
Extrapolations
Full Value
%
Discounted
Before Data Period
$683,217
0%
$683,217
Within Data Period
$231,594
0%
$231,594
After Data Period
$1,387,452
0%
$1,387,452
Final Allocation Builder
Gross Settlement Amount
$20,000,000
Attorney Fees
$6,600,000
Litigation Costs
$195,000
Plaintiff Service Awards
$30,000
Net Settlement Fund
$13,175,000
From The Front End
E4 fx 7.00
A
B
C
D
E
F
G
H
Case Variables
Value
Damages Start Date
01/01/22
Damages End Date
12/31/25
Off the Clock hours
7.00
Chance of Success
Full Value
%
Discounted
Unpaid Straight Time Up to 40H
$4,093,086
0%
$4,093,086
Unpaid Straight Time Over 40H
$8,306,243
0%
$8,306,243
Unpaid Overtime Premium
$12,399,330
0%
$12,399,330
Global Discounts
%
Amount
Global Discount 1
0%
$0
Global Discount 2
0%
$0
Extrapolations
Full Value
%
Discounted
Before Data Period
$683,217
0%
$683,217

Part 1: Count Missing Weeks

Identify, categorize, and count every week of the damages window not covered by the records.

Part 2: Value Missing Weeks

Calculate a per-week value, then multiply by the missing week count to produce damages.

01
Overall

Overall Weekly Average

All six case members pool together. One per-week number applies to everyone.

#
Name
Job Title
Weeks Worked
Damages
1
Diaz
Driver
100
$40,000
2
Patel
Driver
100
$44,000
3
Nguyen
Manager
100
$44,000
4
Brooks
Manager
100
$48,000
5
Romero
Office
100
$25,000
6
Lopez
Office
100
$30,000
Diaz
$385
Patel
$385
Nguyen
$385
Brooks
$385
Romero
$385
Lopez
$385
02
By Role

Job Title Weekly Average

Damages pool by role. Each role shares one per-week number.

#
Name
Job Title
Weeks Worked
Damages
1
Diaz
Driver
100
$40,000
2
Patel
Driver
100
$44,000
3
Nguyen
Manager
100
$44,000
4
Brooks
Manager
100
$48,000
5
Romero
Office
100
$25,000
6
Lopez
Office
100
$30,000
Diaz
$400
Patel
$440
Nguyen
$440
Brooks
$480
Romero
$250
Lopez
$300
03
Individual

Individual Case Member Average

Each case member's own damages and own weeks drive their own per-week number.

#
Name
Job Title
Weeks Worked
Damages
1
Diaz
Driver
100
$40,000
2
Patel
Driver
100
$44,000
3
Nguyen
Manager
100
$44,000
4
Brooks
Manager
100
$48,000
5
Romero
Office
100
$25,000
6
Lopez
Office
100
$30,000
Diaz
$400
Patel
$440
Nguyen
$440
Brooks
$480
Romero
$250
Lopez
$300
Counting Missing Weeks

Define What Weeks Are Missing

The data pull anchors the timeline. Three categories of missing weeks fall before, after, or inside the records.

Anchor

Data Pull

The recorded weeks the case has on file. The model uses these directly as the timeline anchor.

Data Pull
03/01/22Data Start 09/30/25Data End
After-Data

Past The Records

Damages keep accruing past the records for current employees still on payroll.

Data Pull
Post Data
Extraps
03/01/22Data Start 09/30/25Data End 12/31/26Damages End
Before-Data

Before The Records

Damages accrued before the records begin, for employees hired earlier.

Pre Data
Extraps
Data Pull
01/01/22Damages Start 03/01/22Data Start 09/30/25Data End
Within-Data

Gaps Inside The Records

Unexplained gaps inside the records the data pull does not cover.

Data Pull
03/01/22Data Start 09/30/25Data End
0px
Step --
--
--
--