tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103213d1300990747-excel-2007-how-to-convert-ex-8-4-30-into-total-hours-time-sheet-2011
Sheet: Payroll Codes

Palm Tran Inc.
Proposed Payroll  Codes
Payroll Code Description |  |  | [NAME] |  | Location item is placed on Admin Timesheet
Bonus- Certification |  |  | - |  | N/A
Grievance Adjustment |  |  | - |  | N/A
Holiday  No Pay |  |  | HNP |  | Holiday - Bank column ( Whole hours only )
Holiday Pay |  |  | HPR |  | Holiday - Pay column ( Whole Hours only )
Incident Accident Report |  |  | - |  | N/A
[NAME] |  |  | LEA |  | LEA columns - list hours and minutes
On Call- Non Bargaining Unit |  |  | O/C |  | List "On Call" and the total number of days the employee
 |  |  |  |  | was on call in the remarks section
Overtime Pay (1.5) |  |  | OTP |  | Overtime columns - list hours and minutes
Physical Pay |  |  | - |  | N/A
Regular Pay |  |  | REG |  | Time Worked columns - list hours and minutes
Shift Differential |  |  | SDI |  | S.D.I. columns - list hours and minutes
Student Overtime Pay |  |  | - |  | N/A
Student Regular Pay |  |  | - |  | N/A
Training  Additional Pay @ .60 HR |  |  | - |  | N/A
Training Pay @ reg amount |  |  | TRA |  | TRA in "Time worked - Hours" column, Hours and minutes in
 |  |  |  |  | the "OTHER" column
Payroll Code Description |  |  | Union
Bonus- Certification |  |  | BNS
Grievance Adjustment |  |  | GRE
Holiday  No Pay |  |  | HNP
Holiday Pay |  |  | HPR
Incident Accident Report |  |  | IAR
[NAME] |  |  | LEA
On Call- Non Bargaining Unit |  |  | -
Overtime Pay (1.5) |  |  | OTP
Physical Pay |  |  | PHY
Regular Pay |  |  | REG
Shift Differential |  |  | SDI
Student Overtime Pay |  |  | STO
Student Regular Pay |  |  | STU
Training  Additional Pay @ .60 HR |  |  | TAP
Training Pay @ reg amount |  |  | TRA
Note: the above items deal strictly with the payment of employees for time worked and are not tracked
for attendance purposes.
Spreadsheet: 132065d1323462049-conditional-sumif-across-multiple-pages-with-page-list-season-stats-with-leaders-vcdd-2011-test
Sheet: Roster

SEASON STATS 2011
Skater | Travel Team | Intra Team
2nadi4u | Hellion | Bombsquad
[NAME] | Hellion | Sucker Punch Sallies
Anti-Social Dee | Vendolls | Brass Knuckle Betties
[NAME] | Vendolls | Sucker Punch Sallies
[NAME] | Hellion | Brass Knuckle Betties
Chronic Speed | Vendolls | Brass Knuckle Betties
Clobberella | BOS | Brass Knuckle Betties
Crabbie Panties | Hellion | Brass Knuckle Betties
Das Booty | BOS | Brass Knuckle Betties
Dazee Jukes | Hellion | Bombsquad
[NAME] | Hellion | Bombsquad
[NAME] | Vendolls | Sucker Punch Sallies
Fatal Traction | BOS | Sucker Punch Sallies
[NAME] | Hellion | Bombsquad
H-Bomb | BOS | Brass Knuckle Betties
Kat Von DV8er | BOS | Sucker Punch Sallies
[NAME] | Hellion | Brass Knuckle Betties
La Jefa | Hellion | Bombsquad
Luscious DoBoys | BOS | Sucker Punch Sallies
[NAME] | BOS | Sucker Punch Sallies
Miss [NAME] | Vendolls | Sucker Punch Sallies
Miss [NAME] | BOS | Sucker Punch Sallies
Pabst Smear Ribbon | Vendolls | Bombsquad
Payne KillHer | Hellion | Brass Knuckle Betties
Pepper Poots | Hellion | Sucker Punch Sallies
PocaHottness | BOS | Sucker Punch Sallies
Potti [NAME] | Vendolls | Bombsquad
Pottsie Cline | Hellion | Bombsquad
[NAME] | Vendolls | Bombsquad
[NAME] | BOS | Bombsquad
Ravage Savage | Hellion | Brass Knuckle Betties
[NAME] | Hellion | Brass Knuckle Betties
[NAME] | BOS | Brass Knuckle Betties
[NAME] | Vendolls | Bombsquad
[NAME] U | Hellion | Sucker Punch Sallies
[NAME] | Vendolls | Brass Knuckle Betties
Shootz ‘n Splatterz | Hellion | Bombsquad
Shortney Love | Vendolls | Brass Knuckle Betties
Slambrosia | Hellion | Bombsquad
The Shelbeast | BOS | Sucker Punch Sallies
Thunder Thighs | BOS | Brass Knuckle Betties
Tiggz | Hellion | Sucker Punch Sallies
Titty Kitty O'Leary | Vendolls | Sucker Punch Sallies
Tuesday Welts | Vendolls | Bombsquad
Vendetta Vixen | Vendolls | Brass Knuckle Betties
Venus Envy | Hellion | Bombsquad
[NAME] | Hellion | Sucker Punch Sallies
Violet Brewzizi | BOS | Bombsquad
Antonina | Fresh Meat
Autumn | Fresh Meat
Christine | Fresh Meat
El Pollo Loakley | Fresh Meat
Elvira | Fresh Meat
Paloma de Muerte | Fresh Meat
Holly Mad-as-Sin | Fresh Meat
Khaira | Fresh Meat
Kimmie | Fresh Meat
Monique | Fresh Meat
Rogue [NAME] | Fresh Meat
Low Down Lola | Fresh Meat
[NAME] | Fresh Meat
Val | Fresh Meat
Yesenia | Fresh Meat
injured or no longer with the league
Spreadsheet: 69209d1269726588-selectively-sum-values-in-a-table-based-on-a-value-in-a-second-table-book1
Sheet: Sheet1

Date | Person | Hours | Cost
2009-05-04 00:00:00 | [NAME] | 3 | 750 |  |  |  |  | Person | Role
2009-05-05 00:00:00 | [NAME] | 4 | 1000 |  |  |  |  | [NAME] | PA
2009-05-06 00:00:00 | [NAME] | 3 | 750 |  |  |  |  | [NAME] | TA
2009-05-07 00:00:00 | [NAME] | 8 | 1600 |  |  |  |  | [NAME] | PM
2009-05-08 00:00:00 | [NAME] | 8 | 2000 |  |  |  |  | [NAME] | TA
2009-05-09 00:00:00 | [NAME] | 5 | 1200
Goal: Sum all hours associated with a person who's role is a TA without adding another column
Tried |  |  | {=SUMPRODUCT((C2:C7)*(VLOOKUP(B2:B7,I3:J6,2,FALSE)="TA"))}
Tried |  |  | {=SUM(IF(VLOOKUP(B2:B7,I3:[NAME]:C7,0))}
Tried |  |  | {=SUMPRODUCT((C2:C7)*(INDEX(I3:J6,MATCH(B2:B7,I3:I6,0),2)="PM"))}
Spreadsheet: 838536d1691115883-formula-to-determine-if-the-data-is-in-the-1st-half-or-2nd-half-of-the-data-set-access-example
Sheet: Part 1

F1 | F2 | Count # | Count Total | F3
2022-10-12 00:00:00 | Yellow
2022-10-15 00:00:00 | Red
2022-10-17 00:00:00 | Blue
2022-10-18 00:00:00 | Green
2022-10-20 00:00:00 | Blue
2022-10-23 00:00:00 | Green
2022-10-26 00:00:00 | Red
2022-10-28 00:00:00 | Yellow
2022-10-30 00:00:00 | Green
2022-11-01 00:00:00 | Blue
2022-11-03 00:00:00 | Red
2022-11-05 00:00:00 | Yellow
2022-11-06 00:00:00 | Green
2022-11-09 00:00:00 | Blue
2022-11-12 00:00:00 | Yellow
2022-11-15 00:00:00 | Red
2022-11-17 00:00:00 | Red
2022-11-19 00:00:00 | Blue
2022-11-21 00:00:00 | Green
2022-11-23 00:00:00 | Red
Spreadsheet: 738137d1624869332-match-function-that-returns-multiple-results-beer-example
Sheet: Component List

SKU # | SKU Desc | Component Category | Component Code | Qty
1111 | Pale Ale | Bottle | B1457 | 1
1111 | Pale Ale | [NAME] | C9420 | 1
1111 | Pale Ale | Label | Pale Ale Neck | 1
1111 | Pale Ale | Label | Pale Ale Front | 1
1111 | Pale Ale | Label | Pale Ale Back | 1
2222 | Stout | Bottle | B1234 | 1
2222 | Stout | [NAME] | C9465 | 1
2222 | Stout | Label | Stout Neck | 1
2222 | Stout | Label | Stout Front | 1
2222 | Stout | Label | Stout Back | 1
3333 | Lager | Bottle | B1934 | 1
3333 | Lager | [NAME] | C9947 | 1
3333 | Lager | Label | Lager Neck | 1
3333 | Lager | Label | Lager Front | 1
3333 | Lager | Label | Lager Back | 1
4444 | Sour | Bottle | B1995 | 1
4444 | Sour | [NAME] | C9434 | 1
4444 | Sour | Label | [NAME] | 1
4444 | Sour | Label | [NAME] | 1
4444 | Sour | Label | [NAME] | 1
Spreadsheet: 78774d1279096035-counting-time-may-help-but-prob-not-
Sheet: Sheet1

54 | 54
55 | 55
58 | 58
59 | 59
0 | 0
1 | 1
2 | 2
3 | 3
34 | 0
4 | 4
7 | 7
9 | 9
17 | 17
0 | 0
12 | 12
27 | 0
18 | 18
0 | 0
0 | 0
18 | 18
Spreadsheet: 272237d1382296791-if-and-fill-in-one-table-2nd-table-will-be-filled-in-automatically-example-expenses
Sheet: Expenses

Category | Date | Person | Supplier | Item | PO nr | [NAME] | Tin | Amount | VAT (18%) | Net | Total Amount |  |  |  | rank
Food1 |  |  |  |  |  |  |  |  |  |  | Total VAT
 |  |  |  |  |  |  |  |  |  |  | Total Net
Food2 | 2013-01-11 00:00:00 | [NAME] | [NAME] | [NAME] | 233 | september | 12 | 300
Food3
Food4
Food5
Shopping
shop1 | 2013-01-11 00:00:00 | [NAME] | unknown | clothes | 27 | non
Cigarettes
cig 1 | 2013-01-12 00:00:00 | you | me | cigar | 48 | unhealth
Sheesha
Office
Salaries
Advertising
Other staff
Monthly expenses
Donation
Utilities
Staff
Décor
Transport
Other
Date | Category | Person | Supplier | Item | PO nr | [NAME] | Tin | Amount | VAT (18%) | Net
Spreadsheet: 35339d1232965775-using-the-isna-match-formula-spreadsheet1
Sheet: Sheet1

Part
589-751
103-665
103-666
103-667
103-668
103-751
103-751M
110-608
150-005
150-006
150-007
150-011
203-091
210-601
215-302
4050-0270
500-150
550-003F
550-004A
550-006
550-006A
550-006AM
550-006AMV
550-006B
550-006C
550-006D
550-006H
550-006H1
550-006HL
550-006HM
550-007
550-008A
550-009
560-004
560-007-008
560-007/AA
560-007/AB
560-007/AC
560-007/AD
560-007/AF
560-007/AG
560-007/AH
560-007/AI
560-007/AJ
560-0072+
560-0072++HD
560-0079800P
560-007HG
560-007MDI
560-007P-DEP
560-007PS01
560-007SABOR
560-007XD4
560-007XD4A
560-007XH72
560-007XH72A
560-007XR5
560-007XR5A
560-008
560-008V
560-009
560-010
560-013
560-017XD4
560-017XD4-2
560-017XR5A
575-221
575-223
575-224
575-226
575-227
583-340
589-100/AA
589-100/AB
589-100XD4
589-100XR5
589-100XR5A
589-100XR5AG
103-252
589-759
589-759/XX
589-759KIT2
589-759SKIT1
589-759W
589-759WA
589-761
589-764
589-764AA
589-764S
589-764S/991
589-764W
589-766
589-766/XX
589-766STAB
589-766W
589-769/42
589-769/43
589-840-005
589-840-008
589-840-017
589-840-025
589-840-030L
589-840-034
589-840-035
589-840-036
589-840-040
589-840-041
589-840-042
589-840-043
589-840-045
589-840-046
589-840-050
589-840-055
589-840-058
589-840-058A
589-840-062
589-840-067
589-840-072
589-840-077
589-840-250
589-840-300
589-840-305
589-840-NIK
589-841
589-841LXD4
589-841LXD4H
589-841LXH72
589-841LXR5
589-842
589-842L
589-842L4X
589-843
589-843/LENS
589-850
589-851
589-851/POL
589-851W
589-852
589-855
589-970
589-991
589-993
589-995
589-996
589-996/D
589-997
589-997M
F9800P
FBS-023
FBS-034
FBS-037
FBS-037/A
FBS-037/AA
FBS-037/AB
LC63
NVS5148
PFZ4177
120671
120621
120601
120976
120941
120931
120971
112320
112120
120401
120101
160501
130201
130601
140802
140801
140601
140301
150601
140701
Spreadsheet: 807983d1670222867-return-last-5-rows-from-table1-sample-6-
Sheet: Sheet1

 | Table 1
 | Customer | [NAME] | Rate | Destination
 | [NAME] | 500 | 850 | Phoenix
 | [NAME] | 631 | 998 | San Diego
 | Wilson | 454 | 612 | Seattle
 | Nick | 912 | 1121 | New York
 | Olivia | 313 | 565 | Palm Beach
 | Cameron | 810 | 1201 | Chicago
 | [NAME] | 717 | 981 | Las Vegas
Spreadsheet: 294175d1391222046-move-data-from-tab-to-different-named-tab-based-on-value-in-k-master-view
Sheet: NLV

Serial Number | Model | Building | Total [NAME] | Total [NAME] | Room | Campus
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  |  |  |  | NLV
 |  |  | 0 | 0
`
Spreadsheet: 683873d1593016252-formula-to-pull-data-from-one-sheet-to-another-where-multiple-values-match-formula-for-looking-up-data
Sheet: Sheet2

Idenitifier | Forename | Surname | Date | Basic Rate | Holiday Pay | Basic earnings total | paid pension at %
603624 | [NAME] | Smith | 2020-06-01 00:00:00 | 700 | 800 | 1500 | 5.8
603625 | [NAME] | Smith | 2020-04-01 00:00:00 | 600 | 200 | 800 | 5.6
603626 | [NAME] | Smith | 2020-02-01 00:00:00 | 450 | 200 | 650 | 5.6
603627 | [NAME] | Smith | 2019-12-01 00:00:00 | 800 | 200 | 1000 | 5.3
Spreadsheet: lisa_gang__22274__ENA_PGE_APRIL_26_27_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 4/26-27/2002
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  | Total In To PGE Trans
0100 |  | 0 | 0
0200 | 0 | 0 | 0
0300 | 0 | 0 | 0
0400 | 0 | 0 | 0
0500 | 0 | 0 | 0
0600 | 0 | 0 | 0
0700 | 125 | 25 | 25
0800 | 125 | 25 | 25
0900 | 125 | 25 | 25
1000 | 125 | 25 | 25
1100 | 125 | 25 | 25
1200 | 125 | 25 | 25
1300 | 125 | 25 | 25
1400 | 125 | 25 | 25
1500 | 125 | 25 | 25
1600 | 125 | 25 | 25
1700 | 125 | 25 | 25
1800 | 125 | 25 | 25
1900 | 125 | 25 | 25
2000 | 125 | 25 | 25
2100 | 125 | 25 | 25
2200 | 125 | 25 | 25
2300 | 0 | 0 | 0
2400 | 0 | 0 | 0
 | BPA(G) | BPA(G) | EWEB(G)
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AVISTA(PSE) | AVISTA(PSE) | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AVISTA(PSE) | AVISTA(PSE) | AEP
 | PGE | TEMU | PPM
 | MORGAN | SNCL | CERS
 | APX | ISO(T)MALIN/SNCLSYS | LDWP
 | ISO(T)MALIN/NP15 | SNCL(L,FS) SYS (CA) | LDWP(T)MALIN/SYLMAR/SYS
 | APX(L,FS) CISO (CA) |  | LDWP(L,FS) SYS (CA)
Spreadsheet: 121093d1315842296-populating-a-new-grid-matrix-from-multiple-min-max-numbers-identifying-missing-values
Sheet: Sheet3

 | A | B | C | D | E | F | G
From - To:
Missing
Spreadsheet: 90073d1289831873-auto-populate-grid-sample
Sheet: Calendar

 | DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY
 | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
LES ALPES
 |  |  | HARRY - 1234 - COACH |  |  |  |  | HARRY - 1234 - COACH
 |  |  | [NAME] - 1235 - COACH |  |  |  |  | [NAME] - 1235 - COACH
 |  |  | BOB - 1236 - COACH |  |  |  |  | BOB - 1236 - COACH
 |  |  |  |  |  |  |  | BEN - 1237 - COACH |  |  | BEN - 1237 - COACH
Spreadsheet: 456615d1460974973-invert-list-of-ip-addresses-oeldere-456610d1460973173-invert-list-of-ip-addresses-ip-invert-1-
Sheet: BEFORE

value | helpcol. | new
192.168.1.0
192.168.1.1
192.168.1.3
192.168.1.4
192.168.1.5
192.168.1.6
192.168.1.7
192.168.1.8
192.168.1.9
192.168.1.10
192.168.1.12
192.168.1.13
192.168.1.14
192.168.1.15
192.168.1.16
192.168.1.17
192.168.1.18
192.168.1.19
192.168.1.20
192.168.1.22
192.168.1.24
192.168.1.25
192.168.1.26
192.168.1.27
192.168.1.28
192.168.1.29
192.168.1.30
192.168.1.31
192.168.1.32
192.168.1.33
192.168.1.34
192.168.1.35
192.168.1.36
192.168.1.37
192.168.1.38
192.168.1.39
192.168.1.40
192.168.1.41
192.168.1.42
192.168.1.43
192.168.1.44
192.168.1.45
192.168.1.46
192.168.1.47
192.168.1.48
192.168.1.50
192.168.1.51
192.168.1.52
192.168.1.53
192.168.1.55
192.168.1.56
192.168.1.57
192.168.1.58
192.168.1.61
192.168.1.62
192.168.1.63
192.168.1.64
192.168.1.65
192.168.1.68
192.168.1.69
192.168.1.70
192.168.1.71
192.168.1.72
192.168.1.73
192.168.1.74
192.168.1.75
192.168.1.77
192.168.1.78
192.168.1.79
192.168.1.80
192.168.1.81
192.168.1.82
192.168.1.83
192.168.1.84
192.168.1.85
192.168.1.86
192.168.1.87
192.168.1.89
192.168.1.92
192.168.1.94
192.168.1.96
192.168.1.97
192.168.1.98
192.168.1.99
192.168.1.101
192.168.1.102
192.168.1.103
192.168.1.104
192.168.1.105
192.168.1.106
192.168.1.107
192.168.1.108
192.168.1.109
192.168.1.110
192.168.1.112
192.168.1.113
192.168.1.114
192.168.1.118
192.168.1.119
192.168.1.120
192.168.1.121
192.168.1.122
192.168.1.123
192.168.1.124
192.168.1.125
192.168.1.126
192.168.1.127
192.168.1.128
192.168.1.160
192.168.1.192
192.168.1.193
192.168.1.195
192.168.1.196
192.168.1.197
192.168.1.198
192.168.1.200
192.168.1.201
192.168.1.202
192.168.1.203
192.168.1.204
192.168.1.205
192.168.1.206
192.168.1.209
192.168.1.210
192.168.1.211
192.168.1.212
192.168.1.213
192.168.1.214
192.168.1.215
192.168.1.216
192.168.1.217
192.168.1.218
192.168.1.219
192.168.1.220
192.168.1.223
192.168.1.225
192.168.1.226
192.168.1.227
192.168.1.228
192.168.1.230
192.168.1.231
192.168.1.232
192.168.1.233
192.168.1.234
192.168.1.238
192.168.1.239
192.168.1.243
192.168.1.244
192.168.1.245
192.168.1.246
192.168.1.247
192.168.1.248
192.168.1.251
192.168.1.252
192.168.1.253
192.168.1.254
Spreadsheet: 884342d1733447378-blended-rate-tiered-commission-tiers-bvj-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  | From | To | Realtor
 |  |  |  |  |  |  |  |  |  |  | 0 | 2000000 | 0.5 |  | This is the sales tier/split
 |  |  |  |  |  |  |  |  |  |  | 2000000.01 | 3000000 | 0.6 |  | As YTD sales grow, the % is split changes
 |  |  |  |  |  |  |  |  |  |  | 3000000.01 | 5000000 | 0.7
 |  |  |  |  |  |  |  |  |  |  | 5000000.01 | 10000000 | 0.8
 |  |  |  |  |  |  |  |  |  |  | 10000000 | 100000000 | 0.9
 |  |  |  |  | Client Name | Location | [NAME] OR Buyer | Quarter | Sales Price | YTD Sales | Commission | GCI | Fixed | 0.06 | 0.1 | Commission Check | [NAME]'s | FORMULA?
 |  |  |  |  | Sale 1 |  |  |  | 1200000 |  | 0.025 |  | 250
 | I would like to show full sale price of These two at 1.1MM rather than split |  |  |  | Sale 2 |  |  |  | 800000 |  | 0.0275 |  | 250
 |  |  |  |  | Sale 2 |  |  |  | 300000 |  | 0.0275 |  | 250
 |  |  |  |  | Sale 3 |  |  |  | 1100000 |  | 0.0275 |  | 250
 |  |  |  |  | Sale 4 |  |  |  | 1800000 |  | 0.03 |  | 250
 |  |  |  |  | Sale 5 |  |  |  | 2900000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 6 |  |  |  | 5000000 |  | 0.03 |  | 250
 |  |  |  |  | Sale 7 |  |  |  | 1000000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 8 |  |  |  | 1800000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 9 |  |  |  | 1250000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 10 |  |  |  | 500000 |  | 0.025 |  | 250
Spreadsheet: 836095d1689087385-depreciation-calculator-depreciation
Sheet: Sheet1

 | 2023-12-31 00:00:00
 | Purchase Date | Amount | Rate | Days | Depreciation | 2023-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 2023-03-31 00:00:00 | 49000 | 0.31
 | 2009-12-06 00:00:00 | 49000 | 0.31 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-02-28 00:00:00 | 49000 | 0.31
 | 2023-04-20 00:00:00 | 49000 | 0.31
 | 2024-01-31 00:00:00 | 49000 | 0.31
Spreadsheet: 698581d1602065733-two-dimensional-dynamic-range-mock-up_v2
Sheet: Drivers

 | Parcel Size 1 | Parcel Size 2 | Parcel Size 3 | Parcel Size 4 | Parcel Size 5 | Parcel Size 6 | Parcel Size 7 | Parcel Size 8 | Parcel Size 9 | Parcel Size 10
Driver 1 | 1 | 5 | 1 | 13 | 2 | 10 | 10 | 0 | 6 | 0
Driver 2 | 9 | 1 | 1 | 1 | 16 | 0 | 3 | 1 | 0 | 18
Driver 3 | 2 | 1 | 8 | 11 | 19 | 0 | 10 | 19 | 1 | 0
Driver 4 | 7 | 11 | 3 | 7 | 2 | 10 | 7 | 0 | 17 | 0
Driver 5 | 7 | 13 | 8 | 11 | 15 | 5 | 0 | 0 | 0 | 9
Driver 6 | 11 | 17 | 4 | 6 | 7 | 11 | 0 | 0 | 0 | 0
Driver 7 | 20 | 17 | 4 | 14 | 1 | 2 | 0 | 17 | 16 | 5
Driver 8 | 13 | 6 | 21 | 11 | 12 | 19 | 0 | 4 | 0 | 0
Driver 9 | 1 | 3 | 2 | 17 | 1 | 0 | 0 | 0 | 19 | 0
Driver 10 | 8 | 15 | 8 | 14 | 1 | 7 | 13 | 18 | 13 | 0
Driver 11 | 3 | 7 | 13 | 1 | 18 | 20 | 0 | 6 | 0 | 0
Driver 12 | 17 | 1 | 14 | 15 | 1 | 0 | 12 | 0 | 0 | 5
Driver 13 | 12 | 3 | 17 | 5 | 1 | 17 | 13 | 0 | 0 | 4
Driver 14 | 20 | 17 | 13 | 21 | 7 | 0 | 6 | 5 | 0 | 0
Driver 15 | 5 | 11 | 11 | 1 | 14 | 7 | 14 | 0 | 11 | 0
Driver 16 | 1 | 14 | 16 | 16 | 16 | 16 | 15 | 12 | 0 | 9
Driver 17 | 7 | 9 | 18 | 9 | 2 | 0 | 4 | 1 | 0 | 14
Driver 18 | 4 | 14 | 17 | 11 | 1 | 0 | 0 | 1 | 15 | 0
Driver 19 | 9 | 1 | 11 | 3 | 1 | 12 | 0 | 18 | 0 | 15
Driver 20 | 1 | 13 | 4 | 5 | 1 | 4 | 6 | 13 | 9 | 0
Spreadsheet: 261ec12c-0467-4291-9076-f27043865dbf
Sheet: EPR 1X PQY

 | Product Sales Revenue | Cost of Gaming Operations | Cost of Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
Six Months Ended March 31, 2014
GAAP measures | 446.1999999999999 | 176.8 | 59.3 | 426.9 | 175.7 | 105.0000000000001 | 0.42
% of revenue |  |  |  | 0.4050284629981025 | 0.1666982922201139
Acquisition-related charges: (b)
Contingent retention & earn-out | 0 | 0 | 0 | -15 | 15 | 10 | 0.04
Amortization of intangibles | 0 | 0 | -5.4 | -6.8 | 12.2 | 8.100000000000001 | 0.03
Business realignment | 0 | 0 | 0 | -16.5 | 16.5 | 11 | 0.05
Alabama note impairment | 0 | 0 | 0 | -1.3 | 1.3 | 0.9 | 0
Litigation accrual | 0 | 0 | 0 | -7.8 | 7.8 | 5.199999999999999 | 0.02
Severance | 0 | -0.6 | 0 | -2.1 | 2.7 | 1.8 | 0.01
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | 0 | -29.6 | -0.12
Total non-GAAP adjustments | 0 | -0.6 | -5.4 | -49.49999999999999 | 55.5 | 7.399999999999999 | 0.03000000000000003
Adjusted measures | 446.1999999999999 | 176.2 | 53.9 | 377.4 | 231.2 | 112.4000000000001 | 0.45
% of revenue |  |  |  | 0.3580645161290323 | 0.2193548387096775
 | (a) Adjustments tax effected at 33%;  (b) Primarily DoubleDown
 | Product Sales Revenue | Cost of Gaming Operations | Cost of Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
Six Months Ended March 31, 2013
GAAP measures | 513.7 | 187.1 | 48.2 | 403 | 247.6999999999999 | 143.4999999999999 | 0.54
% of revenue |  |  |  | 0.3565740576889046 | 0.2191647496018403
Acquisition-related charges: (b)
Contingent retention & earn-out | 0 | 0 | 0 | -39.3 | 39.3 | 26.2 | 0.1
Amortization of intangibles | 0 | 0 | -4.6 | -8.9 | 13.5 | 9 | 0.03
Proxy Fees | 0 | 0 | 0 | -3.9 | 3.9 | 2.6 | 0.01
Alabama note impairment | 0 | 0 | 0 | -1.6 | 1.6 | 1.1 | 0
Royalty settlement | -5 | 0 | 0 | 0 | -5 | -5 | -0.02
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | 0 | -5.9 | -0.02
Total non-GAAP adjustments | -5 | 0 | -4.6 | -53.7 | 53.3 | 28.00000000000001 | 0.1
Adjusted measures | 508.7 | 187.1 | 43.59999999999999 | 349.3 | 300.9999999999999 | 171.4999999999999 | 0.64
% of revenue |  |  |  | 0.3090603433020704 | 0.2663245443284374
 | (a) Adjustments tax effected at 34%, except no tax effect on royalty settlement; (b) Primarily DoubleDown
Spreadsheet: 859201d1707665644-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-sample-62-ans
Sheet: 9

Rep
Nathan
Penelope
[NAME]
[NAME]
[NAME]
Tom5
[NAME]
[NAME]
Bob2
Savannah
[NAME]
Maya
[NAME]
Anna
Mark4
Elena
[NAME]
Julia
Carmen3
Abigail1
Spreadsheet: 840874d1693087738-return-split-values-in-a-dynamic-range-and-include-blanks-split-text-example
Sheet: Sheet1

Name |  | Current Result |  |  |  |  |  | Expected Result
[NAME] |  |  | [NAME] |  |  |  |  | [NAME] | [NAME]
Hortensia Gaius Aurelia Valentina Maximilla |  | Hortensia | Gaius | Aurelia | Valentina | [NAME] |  | Hortensia | Gaius | Aurelia | Valentina | [NAME]
 |  | Olivia | [NAME]
[NAME] |  | [NAME] | de | la | Cruz |  |  | Olivia | [NAME]
[NAME] |  | Juan | Martin | Hernandez |  |  |  | [NAME] | de | la | Cruz
 |  | Ava | [NAME]
[NAME] |  | [NAME] | White |  |  |  |  | Juan | Martin | Hernandez
[NAME] |  | Charlotte | [NAME] |  |  |  |  | Ava | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME] | White
[NAME] |  |  |  |  |  |  |  | Charlotte | [NAME]