tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 70334d1271116435-if-formula-config-sheet-budget-2011
Sheet: Jul

1st |  |  |  | 8th |  |  |  | 15th |  |  |  | 22nd |  |  |  |  |  |  |  |  |  |  |  | Income
Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Transfer
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Birthday
Savings Balance |  | 0 |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Clothing
Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Entertainment
Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Fast Food
 |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  | Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Insurance
Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Loan
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Misc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smokes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over
Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings
Spreadsheet: 730033d1619508770-find-record-on-2-criteria-with-nearest-lowest-date-27042021-sample-file-for-excel-forum
Sheet: Sheet1

Fees Slabs | Charges | Date
500000 | 2500 | 2018-09-24 00:00:00 |  |  | Question 1 :
1000000 | 3000 | 2018-09-24 00:00:00
2500000 | 5000 | 2018-09-24 00:00:00 |  |  | Current Date | 2021-03-30 00:00:00 | << [NAME] |  | Nearest lowest date of the current date is 05/07/2020
5000000 | 7500 | 2018-09-24 00:00:00 |  |  | Fees | 1127000 | << [NAME]
100000000 | 9000 | 2018-09-24 00:00:00 |  |  | Charges | 5400 | <<<<< RESULT |  | Charges on fees slabs above 10.00 lakh but minimum 25.00 lakh
500000 | 3100 | 2020-07-05 00:00:00
1000000 | 3500 | 2020-07-05 00:00:00 |  |  | I want Charges amount by seeking nearest lowest date record & fees amount must be between the range
2500000 | 5400 | 2020-07-05 00:00:00
5000000 | 7900 | 2020-07-05 00:00:00
100000000 | 11000 | 2020-07-05 00:00:00
500000 | 3500 | 2021-04-04 00:00:00
1000000 | 4000 | 2021-04-04 00:00:00
2500000 | 6000 | 2021-04-04 00:00:00
5000000 | 8000 | 2021-04-04 00:00:00
100000000 | 15000 | 2021-04-04 00:00:00
Service Charges Amt. | Service Chg % | Sanction limit | Date |  | Question 2 :
0 | 0.01 | 2500000 | 2018-09-24 00:00:00
25000 | 0.005 | 5000000 | 2018-09-24 00:00:00 |  | Current Date | 2021-03-30 00:00:00 | << [NAME] |  | Nearest lowest date of the current date is 05/07/2020
37500 | 0.0025 | 10000000 | 2018-09-24 00:00:00 |  | Fees | 11127000 | << [NAME]
50000 | 0.002 | 1000000000 | 2018-09-24 00:00:00 |  | Service Charges Amt |  | <<<<< RESULT |  | Service Charges on slabs above 1.00 crore
0 | 0.01 | 2500000 | 2020-07-05 00:00:00
25000 | 0.005 | 5000000 | 2020-07-05 00:00:00 |  | For 25.00 lakh
37500 | 0.0025 | 10000000 | 2020-07-05 00:00:00 |  | Upto 50.00 lakh |  | =(C25-C24)*B25+G25
50000 | 0.002 | 1000000000 | 2020-07-05 00:00:00 |  | upto 1.00 Crore |  | =(C26-C25)*B26+G26
0 | 0.03 | 2500000 | 2021-04-04 00:00:00 |  | above 1.00 Crore |  | =(C27-C26)*B27+G27
25000 | 0.02 | 5000000 | 2021-04-04 00:00:00
37500 | 0.01 | 10000000 | 2021-04-04 00:00:00 |  | I want Service Charges amount by seeking nearest lowest date record & sanction limit amount must be between the date range * Servic charges %
50000 | 0.005 | 1000000000 | 2021-04-04 00:00:00
Spreadsheet: 853904d1703856889-material-run-out-plan-plan-materialv3
Sheet: Sheet1

 |  | material stock type 1 kg | 800
 |  | Material On Order | 0
 |  | Material Deficit | -200
 |  | part | 1358 |  |  | 1356 |  |  | 1360
 |  | run qty | 600 |  |  | 200 |  |  | 600
 |  | Weight kg each | 0.8 | 480 |  | 0.5 | 100 |  | 0.7 | 420
 |  | rate per 16hr day | 50 |  |  | 20 |  |  | 60
 |  | date start | 2023-10-31 08:00:00 |  |  | 2023-11-04 08:00:00 |  |  | 2023-11-08 08:00:00
 |  | Date | Qty/Day | [NAME] |  | Qty/Day | [NAME] |  | Qty/Day | [NAME]
 |  | 2023-10-30 08:00:00
 |  | 2023-10-31 08:00:00 | 50 | 40
 |  | 2023-11-01 08:00:00 | 50 | 40
 |  | 2023-11-02 08:00:00 | 50 | 40
 |  | 2023-11-03 08:00:00 | 50 | 40
 |  | 2023-11-04 08:00:00 | 50 | 40 |  | 20 | 10
 |  | 2023-11-05 08:00:00 | 50 | 40 |  | 20 | 10
 |  | 2023-11-06 08:00:00 | 50 | 40 |  | 20 | 10
 |  | 2023-11-07 08:00:00 | 50 | 40 |  | 20 | 10
 |  | 2023-11-08 08:00:00 | 50 | 40 |  | 20 | 10 |  | 60 | 42
 |  | 2023-11-09 08:00:00 | 50 | 40 |  | 20 | 10 |  | 60 | 42
 |  | 2023-11-10 08:00:00 | 50 | 40 |  | 20 | 10 |  | 60 | 42
 |  | 2023-11-11 08:00:00 | 50 | 40 |  | 20 | 10 |  | 60 | 42
 |  | 2023-11-12 08:00:00 | 0 | 0 |  | 20 | 10 |  | 60 | 42
 |  | 2023-11-13 08:00:00 |  |  |  | 20 | 10 |  | 60 | 42
 |  | 2023-11-14 08:00:00 |  |  |  | 0 | 0 |  | 60 | 42
 |  | 2023-11-15 08:00:00 |  |  |  |  |  |  | 60 | 42
 |  | 2023-11-16 08:00:00 |  |  |  |  |  |  | 60 | 42
 |  | 2023-11-17 08:00:00 |  |  |  |  |  |  | 60 | 42
 |  | 2023-11-18 08:00:00 |  |  |  |  |  |  | 0 | 0
 |  | 2023-11-19 08:00:00
 |  | 2023-11-20 08:00:00
 |  | 2023-11-21 08:00:00
 |  | 2023-11-22 08:00:00
 |  | 2023-11-23 08:00:00
 |  | 2023-11-24 08:00:00
 |  | 2023-11-25 08:00:00
 |  | 2023-11-26 08:00:00
 |  | 2023-11-27 08:00:00
 |  | 2023-11-28 08:00:00
 |  | 2023-11-29 08:00:00
 |  |  |  | 480 |  |  | 100 |  |  | 420
Spreadsheet: 789809d1659375406-autocount-downward-insteasd-of-upward-sample
Sheet: Sheet1

Account A Total
Account A | 5
Account A | 10
Account A | 15
Account A | 20
Account A | 15
Account A | 20
Account A | 25
Account A | 5
Account A | 10
Account A | 20
Account B Total
Account B | 15
Account B | 20
Account B | 25
Account B | 10
Account B | 10
Account B | 15
Account B | 25
Account B | 25
Account B | 30
Account B | 10
Spreadsheet: 79841d1280076890-variable-pay-rates-depending-on-what-time-of-day-variable-pay-rates
Sheet: Sheet1

Doctor's Name:
Week's Starting Date:
 |  |  | Start Time | Time End | Regular Hrs Worked | Regular Pay | After Hrs  Pay | After [NAME] | On Call  Hrs Worked | On Call  Pay
 | Monday |  | 12:00:00 | 18:00:00
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday
 | Regular Rates |  | $250/Hour
 | After Hours Rates |  | $400/Hour
 | On Call Rates |  | $350/Hour
Spreadsheet: 486766d1477656812-when-i-drag-the-numer-like-1555-1-decimal
Sheet: Sheet1

Number | Point | Decimal | Result
15544 | . | 1
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
15544 | .
Spreadsheet: 52688d1252520737-how-to-do-vlookup-with-multiple-cells-book3
Sheet: Sheet1

Setup Information
City | State | Rate
Philadelphia | PA | 0.07
Pittsburgh | PA | 0.07
 | PA | 0.06
 | NJ | 0.07
 | DE | 0
New York City | NY | 0.08875
 | NY | 0.085
Other |  | 0
Sales receipt information
Customer name | [NAME]
Customer Address | 123 Main Street
City | Philadelphia
State | PA
Zip | 19107
 | Item # | Desciption | Qty | Price | Ext price
 | 3456 | Widget | 2 | 100 | 200
 | 3457 | Whatsit | 4 | 60 | 240
 |  |  |  | Subtotal | 440
 |  | (result of [NAME] or sumproduct statement) | 0.07 | Sales tax | 30.8
 |  |  |  | TOTALS | 470.8
Spreadsheet: 219820d1362977685-creating-list-from-text-in-another-sheet-baby-inventory-room-2-2012
Sheet: Totals 

TOTALS
[NAME] |  |  | M Albino
F Albino Cinnamon |  |  | M Albino Cinnamon
F Albino Spider |  |  | M Albino Spider
F Axanthic |  |  | M Axanthic
F Axanthic Pin |  |  | M Axanthic Pin
[NAME] |  |  | M Bee
F Bel |  |  | M Bel
F Black Pastel |  |  | M Black Pastel
[NAME] |  |  | M Butter
[NAME] |  |  | M Butter Bee
F Butter Yellow Belly |  |  | M Butter Yellow Belly
F Calico |  |  | M Calico
F Caramel |  |  | M Caramel
F Champagne |  |  | M Champagne
F Cinnamon |  |  | M Cinnamon
[NAME] |  |  | M Cinnamon Fire
F Cinnamon Pin |  |  | M Cinnamon Pin
[NAME] |  |  | M Desert
F Enchi |  |  | M Enchi
F Enchi Lesser |  |  | M Enchi Lesser
[NAME] |  |  | M Fire
[NAME] |  |  | M Fire Fly
F Genetic Stripe |  |  | M Genetic Stripe
F Ghost |  |  | M Ghost
F Het albino |  |  | M Het Albino
F Het Ax S |  |  | M Het Ax S
F Het Axanthic |  |  | M Het Axanthic
F Het Clown |  |  | M Het Clown
F Het Ghost |  |  | M Het Ghost
F Het Pied |  |  | M Het Pied
F Het Red Ax |  |  | M Het red ax
F Het Russo |  |  | M Het russo
[NAME] |  |  | M Honey Bee
F Hypo Mojave |  |  | M Hypo Mojave
[NAME] |  |  | M Ivory
F Jigsaw |  |  | M Jigsaw
[NAME] |  |  | M Killer Bee
[NAME] |  |  | M Lemonblast
[NAME] |  |  | M Lesser
[NAME] |  |  | M Lesser Bee
 |  |  | M Lesser Woma
[NAME] |  |  | M Lesser Woma Spider
F Mojave |  |  | M Mojave
F Mojave Vanilla |  |  | M Mojave Vanilla
F Moochie Bee |  |  | M Moochie Bee
F Odd |  |  | M Odd
F Pastel |  |  | M Pastel
F Pastel Butter |  |  | M Pastel Butter
F Pastel Calico |  |  | M Pastel Calico
F Pastel Champagne |  |  | M Pastel Champagne
F Pastel Enchi |  |  | M Pastel Enchi
F Pastel Lesser |  |  | M Pastel Lesser
F Pastel Poss Het Pied |  |  | M Pastel Poss Het Pied
F Pastel Spotnose |  |  | M Pastel Spotnose
F Pastel Woma |  |  | M Pastel Woma
F Pastel YB |  |  | M Pastel YB
F Pastel Yellow Belly? |  |  | M Pastel Yellow Belly?
[NAME] |  |  | M Pewter
[NAME] |  |  | M Pewter Blast
F Pied |  |  | M Pied
F Pin |  |  | M Pin
F Pin het albino |  |  | M Pin het albino
F Pin Het Axanthic |  |  | M Pin Het Axanthic
F Spector |  |  | M Spector
F Spider |  |  | M Spider
F Spider het ghost |  |  | M Spider het ghost
F Spider Leopard |  |  | M Spider Leopard
[NAME] |  |  | M Spider Poss Het Pied
F Spider? |  |  | M Spider?
F Spied |  |  | M Spied
[NAME] |  |  | M Spinner
[NAME] |  |  | M Spinner Blast
F Spotnose |  |  | M Spotnose
F Spotnose Calico |  |  | M Spotnose Calico
F Sterling |  |  | M Sterling
F Stinger Bee |  |  | M [NAME]
F Stinger Bee? |  |  | M [NAME]?
F Super Blast |  |  | M Super Blast
F Super Mojave |  |  | M Super Mojave
F Super Pastel |  |  | M Super Pastel
F Super Pastel Calico |  |  | M Super Pastel Calico
F Tiger |  |  | M Tiger
F Vanilla |  |  | M Vanilla
F Woma |  |  | M Woma
F Yellow Belly |  |  | M Yellow Belly
 |  |  |  |  |  | Total
Spreadsheet: 701208d1603623880-how-to-divide-some-value-specific-number-of-times-in-different-number-of-cells-excel
Sheet: Sheet1

COMPANY |  |  |  |  |  |  |  |  |  |  |  |  |  | BUYER
2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | total kupovina |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | rate
 |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  | 200
 |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
200
 |  |  |  |  |  |  |  |  | 300
Spreadsheet: 484134d1476128349-sumif-question-tavwtby
Sheet: tavwtby

 |  |  |  | PART # |  |  | QTY |  | DIFF P/N | QTY | DIFFERENCE
 |  |  |  | 554842 |  |  | 37 |  | 554842 | 488
 |  |  |  | 537300 |  |  | -243 |  | 546361 | 2207
 |  |  |  | 546361 |  |  | 183 |  | 514795-2 | 38
 |  |  |  | 557928 |  |  | 17 |  | 557928 | 30
Spreadsheet: 677886d1589566237-replace-zero-value-to-a-replaced-number-refernce
Sheet: Blad1

 |  |  |  |  |  | Want this
1 | BRAVO |  |  | IF ZERO IN B2 THEN A2 |  | ALFA
2 | BRAVO |  |  | IF ZERO IN B3 THEN A3 |  | BRAVO
4 | 0 |  |  | IF ZERO IN B4 THEN A4 |  | 4
5 | 0 |  |  | IF ZERO IN B5 THEN A5 |  | 5
6 | CESAR |  |  | IF ZERO IN B6 THEN A6 |  | CESAR
7 | GLOB0 |  |  | IF ZERO IN B7 THEN A7 |  | BGLOBO
8 | 0 |  |  | IF ZERO IN B8 THEN A8 |  | 8
Spreadsheet: 144055d1330697725-compare-disparute-lists-and-lookup-matched-values-0176
Sheet: Sheet1

[NAME] | u152 | 150
er558 | er559 | 20 | Duplicates
kl525 | [NAME] | 250 | Duplicates
as522 | as523 | 240 | Duplicates
er559 | e8 | 290
[NAME] | jk25 | 340
as523 | [NAME] | 390
er560 | g255 | 440
kl527 | ffdg2 | 490
as524 | 5gg | 540
Spreadsheet: 47104d1246016894-sum-of-income-by-month-summonths-and-years
Sheet: Sheet1

 |  |  |  |  |  |  |  | Sum of each month only if there is a complete date.
 |  |  | Order No. | Order Amount £ | Date Ordered | Date Complete |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00
 |  |  | 1 | 50 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 |  | 0 | 162 | 80 | 222
 |  |  | 2 | 60 | 2009-01-03 00:00:00 |  | REVISED FORMULA | 0 | 162 | 80 | 222
 |  |  | 3 | 112 | 2009-01-22 00:00:00 | 2009-02-22 00:00:00 |  | 0 | 162 | 80 | 222
 |  |  | 4 | 35 | 2009-02-02 00:00:00 | 2009-03-02 00:00:00
 |  |  | 5 | 45 | 2009-02-13 00:00:00 | 2009-03-13 00:00:00
 |  |  | 6 | 50 | 2009-03-03 00:00:00 | 2009-04-03 00:00:00 |  | YEAR | 2009-01-01 00:00:00 | 2008-01-01 00:00:00
 |  |  | 7 | 60 | 2009-03-05 00:00:00 | 2009-04-05 00:00:00
 |  |  | 8 | 112 | 2009-03-12 00:00:00 | 2009-04-12 00:00:00 |  | YEAR FORMULA | 464 | 0
 |  |  | 9 | 35 | 2009-03-25 00:00:00
 |  |  | 10 | 45 | 2009-03-27 00:00:00
 |  |  |  |  |  |  |  |  | 2009
Spreadsheet: 124776d1318604571-help-on-formulas-to-refer-to-previous-sheet-when-i-copy-it-example
Sheet: Day 1

MORNING REPORT
COMPLETION / WORKOVER/ WELL SERVICE
Field |  |  | PERFORATIONS |  |  |  | WELL NAME:
CTY / ST |  |  | _________________________ |  |  |  | AFE
TD |  |  | _________________________
PBTD |  |  | _________________________
RIG |  |  | _________________________
 |  |  |  |  |  | REPORT BY |  |  |  | DATE
OBJECTIVE |  |  | NUM. OF DAYS |  | 1
TIME LOG |  | DETAILS OF OPERATIONS
FROM | TO
DAILY COST RECORD
VENDOR |  |  | ITEM/GL CODE |  | Daily Cost |  | CUM COST | REMARKS
XYZ |  |  | 00120 |  | 65 |  | 65
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
Total Daily Cost |  |  |  |  | 65
Previous Day Total |  |  |  |  | 0
Total Cumulative Cost |  |  |  |  | 65 |  | 65
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Mkt Risk

Market Risk & Research
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90005736 | ANDREWS, NAVEEN C | Dir Market Risk Mgmt | DIR-ST
90012951 | BUY, RICHARD B | EVP Chief Risk Officer | MC-ST
90011146 | GORNY, VLADIMIR | Dir Consumption Risk | DIR-C
90011905 | HAGELMANN, BJORN | Dir Market Risk Mgmt | DIR-ST
90123664 | HAYDEN, FRANK | Dir Market Risk Mgmt | DIR-ST
90006729 | HEATHMAN, [NAME] | [NAME] | ASSTEX-CS
90142029 | NORDSTROM, [NAME] | Dir Market Risk Mgmt | DIR-ST
90139856 | PORT, [NAME] | Dir Sr Market Risk Mgmt | DIRSR-ST
90140235 | PRESLEY, MICHAEL E | Spec Sr Market Risk Mgmt | SPECSR-CS
90125424 | SCHNEIDER, [NAME] | VP Underwriting | VP-ST
90139428 | THOMAS, MARK E | Mgr Market Risk Mgmt | MGR-ST
 |  | Employees
Spreadsheet: 20edd15b-427e-4887-87ac-d527ff52b0da
Sheet: Exhibit XV, Page 5

Owners Forms
[NAME]
Pennsylvania
Rate Change History
Effective Date | Percent Effect | Dollar Effect (nearest thousand) |  | Description of Changes
2007-02-01 00:00:00 | -0.04 | 0 |  | Expand the Homeowners Pricing Program from 5 levels
 |  |  |  | to 7 levels, implement new territory boundaries and
 |  |  |  | relativities, revise endorsment costs and unity premiums.
2008-03-01 00:00:00 | 0 | 0 |  | Revise Price Level Factors for Owners and Unit-Owners
 |  |  |  | forms, New Home Discount credits & caps for Owners
 |  |  |  | forms, and Base Rates for Owners & Unit-Owners forms.
NB*: November 30, 2009 | 0.108 | 51000 |  | Introduce HO2008 program for Owners and Unit-Owners,
RB**: January 30, 2010 |  |  |  | Introduce Renewal Rate Capping.
NB*: August 14, 2010 | 0 | 0 |  | Introduce the use of Military Status in Pricing Level calculation
RB**: November 1, 2010 |  |  |  | for USAA-GIC.
2011-01-30 00:00:00 | 0 | 0 |  | Introduce new limit options for Coverage B.
2011-08-15 00:00:00 | 0.073 | 116000 |  | Introduce additionally rated catastrophic perils.
 |  |  |  | Introduce a new rating structure for the Earthquake Endorsement.
2012-08-15 00:00:00 | 0.162 | 363000 |  | Introduce new territory boundaries.
* "NB" = "New Business"
** "RB" = "Renewal Business"
Spreadsheet: 456296d1460736157-sum-values-on-a-summary-page-based-on-two-columns-testing
Sheet: Individual

Red | A | 1
Red | A | 3
Red | A | 5
Red | B | 8
Red | B | 2
Red | B | 14
Red | C | 1
Red | C | 15
Red | C | 2
Red | D | 20
Blue | A | 32
Blue | A | 5
Blue | B | 8
Blue | B | 14
Blue | C | 19
Blue | C | 10
Blue | D | 30
Blue | D | 25
Blue | D | 27
Green | A | 29
Green | A | 31
Green | A | 7
Green | B | 9
Green | C | 4
Green | D | 10
Green | D | 5
Green | D | 6
Spreadsheet: 136138d1326429277-reading-from-other-files-multi-year-testing-data-sheets
Sheet: 2011

year | 2011
ID | Name | spelling | maths | reading
 |  | 12 | 60 | 4
 |  | 13 | 65 | 5
 |  | 14 | 75 | 6
 |  | 15 | 80 | 7
 |  | 16 | 85 | 8
 |  | 17 | *0 | 9
Spreadsheet: eed157be-7d83-42f0-b30d-c473d7601b8e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
260695 | 12535 | [NAME] | Girand | USA |  | 00:59:27 | 00:02:17 | 01:23:09 | 00:02:07 | 00:32:19 | 1 | 02:59:15
260695 | 74731 | [NAME] | Moore | USA |  | 00:58:59 | 00:01:26 | 01:28:42 | [NAME] | [NAME] | 2 | 03:05:47
260695 | 12333 | [NAME] | Mounsey | CAN |  | 00:58:28 | 00:02:03 | 01:32:24 | 00:02:27 | [NAME] | 3 | 03:06:57
Spreadsheet: 96688d1296018656-managing-and-syncing-three-different-excel-files-therapyschedule
Sheet: Sheet2

Time | PT/Tim | OT/Bel |  |  | Patients | 07:00:00 | 07:00:00 | 08:00:00 | 08:00:00 | 09:00:00 | 09:00:00 | 10:00:00 | 10:00:00 | 11:00:00 | 11:00:00
07:00:00 | Apple | [NAME] |  |  | Apple | PT/Tim | PT/Tim |  |  | OT/Bel | OT/Bel | PT/Tim | PT/Tim
07:00:00 | [NAME] |  |  |  | [NAME] |  |  | Apple | Apple
08:00:00 | [NAME] | Doodle |  |  | [NAME] | 0 | 0 |  |  | [NAME] | [NAME] |  |  | 0 | 0
08:00:00 |  |  |  |  | Doodle |  |  | Doodle | Doodle |  |  | Doodle | Doodle | [NAME] | [NAME]
09:00:00 | [NAME] | Apple
09:00:00 |  | [NAME] |  |  | Above I |  | Then there is an Ugly formula in the above table to make the Sheet 1 Schedule.
10:00:00 | Apple | Doodle |  |  | Copied all
10:00:00 |  |  |  |  | Patients for
11:00:00 | Doodle | [NAME] |  |  | the day and
11:00:00 |  |  |  |  | deleted duplicates
Spreadsheet: 677072d1589186929-power-query-extraction-of-field-in-duplicated-record-leave-fte-example
Sheet: Sheet2

ID | Surname | Preferred | JobPositionsSeq | AwardCode | JobPositionCode | JobPositionDescription | AwardLevelCode | JobPositionCategoryCode | JobPositionActiveFlag | ReportsToJobPositionsSeq | SchoolStaffCode | CurrentJobPositionFlag | FutureJobPositionFlag | JobLevel | JobLevelNextIncrementDate | StartDate | EndDate | FTE | JobLevelNextIncrementYears | NextReviewDate
18092 | Hark | Emma | 17 | TEACHING | TEACHER | Teacher | PARENTAL | TEACHER | True | 18 | HarE | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-27 00:00:00 | 0 | 1
18144 | Liver | [NAME] | 28 | ES | COUNSELLORS | Counsellor | PARENTAL | COUNSELLOR | True | 18 | LivJ | True | False | 0 |  | 2019-02-23 00:00:00 |  | 0 | 1
18279 | Viccar | [NAME] | 17 | TEACHING | TEACHER | Teacher | LONG_TERM_CARER | TEACHER | True | 18 | VicM | True | False | 0 |  | 2020-01-28 00:00:00 | 2021-01-26 00:00:00 | 0 | 1
18443 | [NAME] | [NAME] | 17 | TEACHING | TEACHER | Teacher | LSL | TEACHER | True | 18 | BonJ | True | False | 0 |  | 2020-01-28 00:00:00 | 2020-06-23 00:00:00 | 0 | 1
26018 | Keen | [NAME] | 17 | TEACHING | TEACHER | Teacher | LSL | TEACHER | True | 18 | KeeN | True | False | 0 |  | 2020-02-26 00:00:00 | 2020-06-19 00:00:00 | 0 | 1
Spreadsheet: 141514d1329310290-excel-2007-solved-set-a-text-in-a-cell-base-on-another-text-in-another-cell-monthly-expenses
Sheet: Jan-12

 | Date | Expenses | RM | Category
 | 2012-01-19 00:00:00 | Lunch | 15.5 | Food
 |  | Dinner | 35.7 | Food
 | 2012-01-20 00:00:00 | Lunch | 7 | Food
 |  | Dinner | 6 | Food
 |  | Household | 4.2 | Household
 |  | Petrol | 7 | Petrol
 | 2012-01-21 00:00:00 | Breakfast | 1.5 | Food
 |  | Lunch | 9.5 | Food
 |  | Dinner | 11 | Food
 |  | Petrol | 52 | Petrol
 |  | Food | 13.5 | Food
 |  | Toll | 4.7 | Travel
 | 2012-01-22 00:00:00 | Newspaper | 2 | Miscellaneous
 |  | Dustbin | 23 | Home Appliance
 |  | Food | 29 | Food
 |  | Household | 19.9 | Household
 |  | Family | 200 | Family