tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677014d1589149320-splitting-costs-and-dues-on-a-montly-spending-chart-isnt-adding-up-book1
Sheet: April

 | Shared | Tor | [NAME] |  | "+/-" |  |  |  |  |  | "+/-"
Dairy |  |  |  |  |  | Beverage |  |  |  |  |  | House
Butter M | 1 |  |  |  |  | [NAME] |  |  |  |  |  | Chef Knife
Butter T | 2 |  |  |  |  | Coffee T |  |  |  |  |  | HP Ink
Eggs | 3 |  |  |  |  | Coffee M
Ice cream | 6 |  |  |  |  | [NAME]
Milk 0% | 5 |  |  |  |  | Tea
milk 1% | 5 |  |  |  |  | Pop T
milk 2% | 6 |  |  |  |  | Pop M
Chop Sticks | 3 |  |  |  |  | Water
Total
Shared |  |  |  |  |  | Paid By [NAME] |  |  |  |  | Paid To Mary
Tor |  |  |  |  |  | Paid By Tor |  |  |  |  | Paid To Tor
[NAME] |  |  |  |  |  | Owed to Mary
Total Tor |  |  |  |  |  | Owed to Tor
Total Mary
Grand total
Difference
Spreadsheet: 267053d1379924028-using-hlookup-for-deriving-a-value-grid-sample
Sheet: Example2

Input Grid |  |  |  | Output Grid
mth | base_channel | Grid |  | Grid | 2013-04 | 2013-06 | 2013-07 | 2013-08
2013-08 | Channel A | 1-500 |  | 0 | 3 | 1 | 3 | 0 | [NAME] needed to produce this result
2013-08 | Channel A | 501-1000 |  | 1-500 | 1 | 4 | 1 | 4
2013-08 | Channel A | 2001-3000 |  | 501-1000 | 0 | 3 | 1 | 2
2013-08 | Channel A | 1-500 |  | 1001-2000 | 0 | 3 | 2 | 3
2013-08 | Channel A | 3001-4000 |  | 2001-3000 | 1 | 0 | 3 | 1
2013-08 | Channel A | 1001-2000 |  | 3001-4000 | 0 | 0 | 0 | 1
2013-08 | Channel A | 1-500
2013-08 | Channel A | 1-500
2013-08 | Channel A | 501-1000
2013-08 | Channel A | 1001-2000
2013-08 | Channel A | 1001-2000
2013-07 | Channel A | 0
2013-07 | Channel A | 1-500
2013-07 | Channel A | 2001-3000
2013-07 | Channel A | 501-1000
2013-07 | Channel A | 2001-3000
2013-07 | Channel A | 2001-3000
2013-07 | Channel A | 0
2013-07 | Channel A | 1001-2000
2013-07 | Channel A | 0
2013-07 | Channel A | 1001-2000
2013-06 | Channel A | 1-500
2013-06 | Channel A | 501-1000
2013-06 | Channel A | 1-500
2013-06 | Channel A | 0
2013-06 | Channel A | 1001-2000
2013-06 | Channel A | 1001-2000
2013-06 | Channel A | 1001-2000
2013-06 | Channel A | 501-1000
2013-06 | Channel A | 1-500
2013-06 | Channel A | 501-1000
2013-06 | Channel A | 1-500
2013-05 | Channel B | 1001-2000
2013-05 | Channel B | 501-1000
2013-05 | Channel B | 0
2013-05 | Channel B | 1-500
2013-05 | Channel B | 501-1000
2013-05 | Channel B | 1-500
2013-05 | Channel C | 501-1000
2013-05 | Channel C | 501-1000
2013-05 | Channel C | 501-1000
2013-05 | Channel C | 501-1000
2013-04 | Channel A | 2001-3000
2013-04 | Channel A | 1-500
2013-04 | Channel A | 0
2013-04 | Channel A | 0
2013-04 | Channel C | 1-500
2013-04 | Channel A | 0
2013-04 | Channel B | 1001-2000
2013-04 | Channel D | 2001-3000
Spreadsheet: 715577d1611768866-year-to-date-comparison-formula-excel-1
Sheet: Sheet1

 | Es | OM | NV | OV | TM | 2020 Total | Average | Year to Date Average
2020-01-01 00:00:00 | 38 | 59 | 11 | 922 | 0
2020-02-01 00:00:00 | 69 | 41 | 10 | 1026 | 0
2020-03-01 00:00:00 | 52 | 22 | 12 | 796 | 7
2020-04-01 00:00:00 | 33 | 22 | 9 | 347 | 29
2020-05-01 00:00:00 | 94 | 44 | 83 | 409 | 32
2020-06-01 00:00:00 | 48 | 23 | 198 | 1060 | 138
2020-07-01 00:00:00 | 86 | 22 | 243 | 1550 | 97
2020-08-01 00:00:00 | 53 | 28 | 24 | 785 | 72
2020-09-01 00:00:00 | 81 | 25 | 48 | 665 | 43
2020-10-01 00:00:00 | 70 | 21 | 142 | 796 | 24
2020-11-01 00:00:00 | 33 | 23 | 112 | 781 | 37
2020-12-01 00:00:00 | 44 | 17 | 142 | 1147 | 111
Spreadsheet: 867991d1714718623-excel-formula-to-lookup-multiple-lookups-rows-and-column-value-book1-1-
Sheet: Summary

Out-Patient | CONSULTATION
 |  |  | Provider Class | VVIP | VIP | A+ | A | A3 | B | B3 | MB1 | MB2 | MB3 | MB4 | InterNational | Reimb | Referral | Grand Total
 | Out-Patient | CONSULTATION | Amount | 5567462.559999999 | 7726737.96 | 600 | 9244296.68000001 | 3208857.7 | 11028993.31999713 | 1186822.74 | 2345803.12 | 3032813.57 | 2777633.55 | 10689546.48 | 38.01 | 246944.76 | 12690 | 57069240.44999713 | 4076374.317856938
 | Out-Patient | CONSULTATION | Counts | 18451 | 37579 | 4 | 58954 | 21504 | 85570 | 15809 | 28697 | 43546 | 48450 | 252519 | 1 | 1355 | 62 | 612501 | 43750.07142857143
 | Out-Patient | CONSULTATION | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 131.6707142857143
 | Out-Patient | CONSULTATION | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93.1741180014353
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-27

Thur
Deal #s | 791654 |  | 791656 | 791672
2001-09-27 00:00:00 |  |  | Sale | Sale
Delivery Pt. | EPMI CA Pool |  | EES | EES
Counterparty | NP | SP | NP | SP
Totals | -1800 | 1800 | -4352 | -2624
1 | 37 | -37 | -250 | -120
2 | 37 | -37 | -250 | -120
3 | 37 | -37 | -250 | -120
4 | 37 | -37 | -250 | -120
5 | 37 | -37 | -250 | -120
6 | 37 | -37 | -250 | -120
7 | -131 | 131 | -147 | -104
8 | -131 | 131 | -147 | -104
9 | -131 | 131 | -147 | -104
10 | -131 | 131 | -147 | -104
11 | -131 | 131 | -147 | -104
12 | -131 | 131 | -147 | -104
13 | -131 | 131 | -147 | -104
14 | -131 | 131 | -147 | -104
15 | -131 | 131 | -147 | -104
16 | -131 | 131 | -147 | -104
17 | -131 | 131 | -147 | -104
18 | -131 | 131 | -147 | -104
19 | -131 | 131 | -147 | -104
20 | -131 | 131 | -147 | -104
21 | -131 | 131 | -147 | -104
22 | -131 | 131 | -147 | -104
23 | 37 | -37 | -250 | -120
24 | 37 | -37 | -250 | -120
TIE POINTS
Spreadsheet: 77914d1278413142-cut-and-pasted-cells-still-leave-results-in-original-line-of-absolute-formulae-cut-and-paste-prob
Sheet: Cabinet CP data

EXAMPLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cabinet | Position
Exposure Date | Room | Cabinet | Session | Position | CFU | Reading Date | Read By | Identification | [NAME] | [NAME] if CFU/plate > 0 | Pass rate | Date | Week | Month | Month No | Year |  | BSC 1200 2 | Cabinet
2005-08-16 00:00:00 | 1 | HLFC 1500 1 | 1 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW |  |  |  |  |  |  |  |  |  |  | BSC 1200 3 | Baxa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BSC 1800 1 | Balance
If sampling position is not determinable record as ND. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BSC 1800 2 | Roller
Where results are not received enter NR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BSC 1800 3 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BSC 1800 4 | [NAME]
Exposure Date | Room | Cabinet | Session | Position | CFU | Reading Date | Read By | Identification | [NAME] | [NAME] if CFU/plate > 0 | Pass rate | Date | Week | Month | Month No | Year |  | BSC 1800 5 | Trolley
 |  |  |  |  |  | 2005-08-12 00:00:00 | RLW |  |  |  |  |  |  |  |  |  |  | BSC 1800 6 | NR
2005-08-09 00:00:00 | 1 | HLFC 1800 1 | 1 | Balance | 0 | 2005-08-12 00:00:00 | RLW |  |  |  |  |  |  |  |  |  |  | HLFC 1500 1
2005-08-09 00:00:00 | 1 | HLFC 1800 1 | 2 | NR | 0 | 2005-08-12 00:00:00 | RLW |  |  |  |  |  |  |  |  |  |  | HLFC 1800 1
2005-08-09 00:00:00 | 1 | HLFC 1500 1 | 2 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW |  |  |  |  |  |  |  |  |  |  | HLFC 1800 2
2005-08-09 00:00:00 | 2 | BSC 1800 1 | 1 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW |  |  |  |  |  |  |  |  |  |  | HLFC 1800 3
2005-08-09 00:00:00 | 2 | BSC 1200 2 | 1 | Trolley | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 2 | BSC 1800 1 | 2 | Baxa | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 2 | BSC 1200 2 | 2 | Balance | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 2 | BSC 1800 1 | 3 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 2 | BSC 1200 2 | 3 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 4 | BSC 1800 4 | 2 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 4 | BSC 1800 6 | 2 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 4 | BSC 1800 4 | 3 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 4 | BSC 1800 6 | 3 | Cabinet | 0 | 2005-08-12 00:00:00 | RLW
2005-08-09 00:00:00 | 1 | BSC 1800 5 | 1 | Cabinet | 0
Spreadsheet: 800543d1665734020-lookup-with-multiple-criteria-example5
Sheet: Sheet1

Position | Player | Daily H'cap | GA Handicap | Gross | Nett | Gender |  | Daily H'cap |  | Male
1 | Carol | 26 | 23.1 | 93 | 67 | Female | A Grade (M) | <= | 12 | [NAME]
2 | Garry | 30 | 29.2 | 98 | 68 | Male | B Grade (M) | 13 | 18 | Trevor
3 | Trevor | 14 | 14.5 | 83 | 69 | Male | C Grade (M) | 19 | 36 | Garry
4 | [NAME] | 5 | 3.6 | 76 | 71 | Male
5 | [NAME] | 3 | 1.7 | 74 | 71 | Male |  | Daily H'cap |  | Female
6 | [NAME] | 13 | 10.7 | 84 | 71 | Male | A Grade (F) | <= | 20 | Martina
7 | [NAME] | 18 | 18.0 | 89 | 71 | Male | B Grade (F) | > | 20 | Carol
8 | Billy | 14 | 11.5 | 86^^ | 72^^ | Male
9 | Martina | 16 | 14.1 | 88 | 72 | Female
10 | [NAME] | 5 | 3.2 | 77 | 72 | Male
11 | [NAME] | 13 | 13.6 | 86 | 73 | Male
12 | [NAME] | 9 | 7.6 | 82 | 73 | Male
13 | [NAME] | 12 | 9.6 | 85 | 73 | Male
14 | [NAME] | 13 | 11.0 | 86 | 73 | Male
15 | [NAME] | 18 | 18.2 | 91 | 73 | Male
Spreadsheet: 30166d1225478321-rearranging-table-copy-of-rotabw
Sheet: Sheet1

 | Main Entrance 1 | Main Entrance 2 | Main Entrance 3 | Hall-Main Door | Hall - Side Door | [NAME] | Chapel | VIP Escorts
1.30pm | Bern | [NAME] | [NAME] | [NAME] | [NAME] | Karin Woollard | [NAME]
3.00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Karin Woollard | [NAME] | [NAME]
4.00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Karin Woollard | [NAME] | [NAME]
5.00pm | Bern | [NAME] | [NAME] | [NAME] | [NAME] | Karin Woollard |  | [NAME]
6.00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Karin Woollard |  | [NAME]
7.00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME]
8.00pm |  | [NAME] | [NAME] |  | [NAME]
9.00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
10.00pm | [NAME] |  | [NAME] | [NAME] | [NAME]
11.00pm | [NAME] | [NAME] | [NAME] |  | [NAME]
 | 1.30pm | 3.00pm | 4.00pm | 5.00pm | 6.00pm | 7.00pm | 8.00pm | 9.00pm | 10.00pm | 11.00pm
Main Entrance 1 | Bern | [NAME] | [NAME] | Bern | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
Main Entrance 2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
Main Entrance 3 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Hall-Main Door | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME]
Hall - Side Door | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | Karin Woollard | Karin Woollard | Karin Woollard | Karin Woollard | Karin Woollard
Chapel | [NAME] | [NAME] | [NAME]
VIP Escorts |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 454899d1460023450-formula-for-lookup-for-left-side-lookup-flat-details
Sheet: Sheet1

Flat | Value | Booking Date
A701 | 100000 | FORMULA REQUIRED
B401 | 20000
B601 | 40000
B701 | 60000
A801 | 80000
A601 | 100000
B501 | 120000
B801 | 140000
A401 | 160000
A501 | 180000
A901 | 200000
B1001 | 220000
B901 | 240000
A301 | 260000
A1001 | 280000
Spreadsheet: edea0c63-0361-49d9-b6ea-8759abf9abb6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43540411 | 2014-10-11 23:38:33 | AXIS | 0 | 2 | 6 | 767699 | nap1815 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
43540581 | 2014-10-11 23:55:02 | ALLIES | 1 | 6 | 5 | 767699 | nap1815 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
43540802 | 2014-10-12 00:19:06 | ALLIES | 0 | 2 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43541049 | 2014-10-12 00:45:20 | AXIS | 0 | 4 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43595196 | 2014-10-15 20:28:56 | ALLIES | 0 | 4 | 6 | 1654906 | Capt Fantastic1 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
43595481 | 2014-10-15 20:51:58 | AXIS | 0 | 5 | 6 | 1654906 | Capt Fantastic1 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
43643587 | 2014-10-19 08:12:45 | AXIS | 0 | 3 | 7 | 1658082 | safavid | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43643737 | 2014-10-19 08:40:28 | ALLIES | 1 | 7 | 4 | 1658082 | safavid | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43643977 | 2014-10-19 09:01:50 | AXIS | 0 | 2 | 5 | 1658082 | safavid | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43644159 | 2014-10-19 09:24:35 | ALLIES | 0 | 3 | 5 | 1658082 | safavid | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43651985 | 2014-10-19 21:27:27 | ALLIES | 1 | 6 | 3 | 439574 | creetingdragons | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43652487 | 2014-10-19 21:45:06 | AXIS | 1 | 6 | 3 | 439574 | creetingdragons | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43652804 | 2014-10-19 22:01:54 | ALLIES | 1 | 4 | 3 | 1647107 | Akton3000 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
43653034 | 2014-10-19 22:17:12 | AXIS | 0 | 3 | 4 | 1647107 | Akton3000 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
43692466 | 2014-10-22 18:27:02 | AXIS | 1 | 6 | 5 | 590115 | SgtBob49 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43692615 | 2014-10-22 18:37:09 | ALLIES | 0 | 3 | 6 | 590115 | SgtBob49 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43692801 | 2014-10-22 18:56:32 | AXIS | 1 | 5 | 4 | 1657989 | rafael-r.94 | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
43693031 | 2014-10-22 19:22:47 | ALLIES | 1 | 6 | 2 | 1655619 | Madana | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43693324 | 2014-10-22 19:45:30 | AXIS | 0 | 5 | 6 | 1655619 | Madana | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
Spreadsheet: 27f9d59e-1219-4a4e-bf7e-ecbc23d28b28
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Regional contributions of Finnish official development assistance (ODA) for the implementation of climate change related bilateral projects and programmes in 2004–2008 (EUR million)
 | 2004 | 2005 | 2006 | 2007 | 2008
Africa | 2.09 | 1.37 | 1.28 | 0.52 | 1.6
Asia | 1.67 | 1.95 | 1.96 | 3.75 | 5.16
Central America | 1.09 | 1.02 | 1.45 | 1.32 | 1.65
South America | 0.09 | 0.12 | 0.07 | 0.04 | 0.33
West Balkans | 0.08 | 0.08
Unlocated funding (i.e. not earmarked geographically) | 0.26 | 2.27 | 4.61 | 3.12 | 6.02
Total (bilateral, UNFCCC focal area) | 5.28 | 6.81 | 9.37 | 8.75 | 14.76
Spreadsheet: 704052d1605316846-nested-if-function-formula-issue-is-this-the-best-way-to-solve-this-problem-profitcalc2
Sheet: Sheet1

Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Average | Profit % | Price | Executed QTY | Amount | Pos Size % | [NAME] | Status | Profit USD | POS Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 | 2020-09-03 00:00:00 | limit | buy | 10300.08 |  | 10308 | 0.3
Entry pos 2 | 2020-09-07 00:00:00 | limit | buy | 10500.91 |  | 10500.91 | 0.2
Entry pos 3 | 2020-09-10 00:00:00 | limit | buy | 10650.17 |  | 10650.17 | 0.4
Entry pos 4 |  |  |  | 10700 |  | 10700 | 0.5 |  |  |  |  |  |  |  |  | Service Fee Total
Exit pos 1 | 2020-10-12 00:00:00 | limit | sell | 11500 |  | 11500 | 0.5
Exit pos 2 | 2020-10-22 00:00:00 | limit | sell | 13780.9 |  | 11780.9 | 0.4
Exit pos 3 | 2020-11-05 00:00:00 | limit | sell | 15890.3 |  | 11800 | 0.3
Exit pos 4 |  |  |  |  |  | 12000 | 0.2
Spreadsheet: 587263d1534934676-random-assign-with-equal-count-zeszyt2
Sheet: Sheet3 (3)

No | Name | Number Task | RAND formula | Assigned validator nr | Validator |  | Validator A
1 | Person A | 2 |  | 3 |  |  | Validator B
2 | Person B | 2 |  | 3 |  |  | Validator C
3 | Person C | 2 |  | 2
4 | Person D | 2 |  | 2 |  |  | [NAME]
5 | Person E | 2 |  | 2
6 | Person F | 2 |  | 1
7 | Person G | 2 |  | 3
8 | Person H | 2 |  | 1
9 | Person I | 2 |  | 1
10 | Person J | 2 |  | 2
11 | Person k | 2 |  | 2
12 | Person l | 5 |  | 2
13 | Person M | 2 |  | 1
14 | Person N | 2 |  | 3
15 | Person O | 2 |  | 3
16 | Person P | 2 |  | 1
17 | Person Q | 2 |  | 2
18 | Person R | 2 |  | 3
19 | Person S | 2 |  | 1
20 | Person T | 2 |  | 2
21 | Person U | 2 |  | 2
22 | Person V | 2 |  | 3
23 | Person w | 2 |  | 2
24 | Person X | 5 |  | 1
25 | Person Y | 2 |  | 1
26 | Person Z | 2 |  | 3
27 | Person AA | 2 |  | 3
28 | Person BB | 5 |  | 3
29 | Person CC | 2 |  | 3
30 | Person DD | 2 |  | 2
31 | Person EE | 0 |  | 1
32 | Person FF | 5 |  | 1
33 | Person FG | 0 |  | 2
Spreadsheet: 67936d1268426614-shade-row-without-conditional-formatting-example1
Sheet: Example

66127 |  | test |  |  |  |  | True
66089 |  |  |  |  |  |  | False
66376 |  |  |  |  |  |  | False
66177 |  |  |  |  |  |  | False
66343 |  |  |  |  |  |  | False
66127 |  |  |  |  |  |  | True
66089 |  |  |  |  |  |  | False
66376 |  |  |  |  |  |  | False
66177 |  |  |  |  |  |  | False
66343 |  |  |  |  |  |  | False
Spreadsheet: 1ae0a44b-da6b-4c0d-b503-5b2d4351fb6e
Sheet: Sheet1

Vice President | Designated | Second
 | Supervisor | Designated
 |  | Supervisor
Braymer, Meta | Braymer, Meta
Cox, Leah | Cox, Leah
Harper, [NAME] | [NAME], [NAME]
 | [NAME], [NAME]
 | Gendernalik-Cooper, Mary
 | Morello, [NAME]
 | Pierce, [NAME]
 | Richardson, Lynne
Searcy, [NAME] | Riley, [NAME]
 | Hegmann, [NAME]
 | Rucker, [NAME]
 | Surething, [NAME]
Wilder, [NAME] | Wilder, [NAME] | Worrell, [NAME]
Pearce, [NAME] | [NAME], [NAME]
 | [NAME], [NAME]
 | Messplay, [NAME]
 | Moerman, [NAME]
 | Knick, [NAME]
 | Wiltenmuth, [NAME] | [NAME], [NAME]
 | Wiltenmuth, [NAME] | [NAME], [NAME]
 | Wiltenmuth, [NAME] | Wilson, [NAME]
 | Wiltenmuth, [NAME] | [NAME], [NAME]
Webb, Justin | Webb, Justin
 | Cheshire, Hall
 | Slezak, Jerry
Meringolo, [NAME] | Billingsley, [NAME]
 | Thompson, Nina
Rountree, [NAME] | Rountree, [NAME]
 | Branner, Greg
Spreadsheet: 164199d1340687152-vlookup-and-count-unique-records-in-adjacent-column-book1
Sheet: Sheet1

Name | Date | Mins
[NAME] | 2012-06-10 00:00:00 | 22
[NAME] | 2012-06-10 00:00:00 | 24
[NAME] | 2012-06-10 00:00:00 | 20
[NAME] | 2012-06-11 00:00:00 | 25
[NAME] | 2012-06-12 00:00:00 | 14
[NAME] | 2012-06-13 00:00:00 | 19
[NAME] | 2012-06-13 00:00:00 | 20
[NAME] | 2012-06-09 00:00:00 | 30
[NAME] | 2012-06-09 00:00:00 | 26
[NAME] | 2012-06-10 00:00:00 | 15
[NAME] | 2012-06-11 00:00:00 | 20
[NAME] | 2012-06-12 00:00:00 | 14
[NAME] | 2012-06-13 00:00:00 | 20
[NAME] | 2012-06-14 00:00:00 | 12
[NAME] | 2012-06-10 00:00:00 | 13
[NAME] | 2012-06-10 00:00:00 | 14
[NAME] | 2012-06-10 00:00:00 | 30
[NAME] | 2012-06-10 00:00:00 | 20
[NAME] | 2012-06-10 00:00:00 | 23
Name | Days Worked
[NAME] | 4 | Need these to be a formula
[NAME] | 6 | Need these to be a formula
[NAME] | 1 | Need these to be a formula
Spreadsheet: 328784d1404077397-bonus-disqualifiers-for-excess-vacation-days-bonus-disqualifiers-ans-deduction-
Sheet: Sample & Result

Computation |  |  |  |  |  |  |  |  |  |  | This is how it should look like (gray shaded cells not shown)
base bonus amount | 2427.043 | (can be any amount) |  |  |  |  |  |  |  |  | base bonus amount | 2427.043
# of work days | 21 | (can be any # of days from 19, 20, 21, 22, 23) |  |  |  |  |  |  |  |  | # of work days | 21
% over allowed leaves | 0.1 | (can be any % of # of work days) |  |  |  |  |  |  |  |  | % over allowed leaves | 0.1
excess days | deduction | amount | this table is shown so i can in the future change excess days with corresponding % deduction |  |  |  |  |  |  |  | excess days | deduction
1 | -0.25 |  |  |  |  |  |  |  |  |  | 1 | -0.25
2 | -0.5 |  |  |  |  |  |  |  |  |  | 2 | -0.5
3 | -0.75 |  |  |  |  |  |  |  |  |  | 3 | -0.75
4 | -1 |  |  |  |  |  |  |  |  |  | 4 | -1
 |  |  | to show deduction instead (negative) instead of bonus
Agent | Leave(s) | Excess | Deduction | Bonus |  |  |  |  |  |  | Agent | Leave(s) | Excess | Deduction
Agent 01 | 0 |  | 0 | 2427.043 |  |  |  |  |  |  | Agent 01 | 0 | -2.1 | 0
Agent 02 | 0.5 |  | 0 | 2427.043 |  |  |  |  |  |  | Agent 02 | 0.5 | -1.6 | 0
Agent 03 | 1 |  | 0 | 2427.043 |  |  |  |  |  |  | Agent 03 | 1 | -1.1 | 0
Agent 04 | 1.1 |  | 0 | 2427.043 |  |  |  |  |  |  | Agent 04 | 1.1 | -1 | 0
Agent 05 | 1.5 |  | 0 | 2427.043 |  |  |  |  |  |  | Agent 05 | 1.5 | -0.6000000000000001 | 0
Agent 06 | 2 |  | 0 | 2427.043 |  |  |  |  |  |  | Agent 06 | 2 | -0.1000000000000001 | 0
Agent 07 | 2.1 |  | 0 | 2427.043 |  |  |  |  |  |  | Agent 07 | 2.1 | 0 | 0
Agent 08 | 2.25 |  | -606.761 | 1820.28225 |  |  |  |  |  |  | Agent 08 | 2.25 | 0.1499999999999999 | -606.761
Agent 09 | 3 |  | -606.761 | 1820.28225 |  |  |  |  |  |  | Agent 09 | 3 | 0.8999999999999999 | -606.761
Agent 10 | 3.1 |  | -606.761 | 1820.28225 |  |  |  |  |  |  | Agent 10 | 3.1 | 1 | -606.761
Agent 11 | 3.5 |  | -1213.522 | 1213.5215 |  |  |  |  |  |  | Agent 11 | 3.5 | 1.4 | -1213.522
Agent 12 | 4 |  | -1213.522 | 1213.5215 |  |  |  |  |  |  | Agent 12 | 4 | 1.9 | -1213.522
Agent 13 | 4.1 |  | -1213.522 | 1213.5215 |  |  |  |  |  |  | Agent 13 | 4.1 | 2 | -1213.522
Agent 14 | 4.5 |  | -1820.282 | 606.76075 |  |  |  |  |  |  | Agent 14 | 4.5 | 2.4 | -1820.282
Agent 15 | 5 |  | -1820.282 | 606.76075 |  |  |  |  |  |  | Agent 15 | 5 | 2.9 | -1820.282
Agent 16 | 5.1 |  | -1820.282 | 606.76075 |  |  |  |  |  |  | Agent 16 | 5.1 | 3 | -1820.282
Agent 17 | 5.5 |  | -2427.043 | 0 |  |  |  |  |  |  | Agent 17 | 5.5 | 3.4 | -2427.043
Agent 18 | 6 |  | -2427.043 | 0 |  |  |  |  |  |  | Agent 18 | 6 | 3.9 | -2427.043
Agent 19 | 6.1 |  | -2427.043 | 0 |  |  |  |  |  |  | Agent 19 | 6.1 | 4 | -2427.043
Agent 20 | 6.6 |  | -2427.043 | 0 |  |  |  |  |  |  | Agent 20 | 6.6 | 4.5 | -2427.043