tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (5)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
5.01
5.02
5.03
5.04 |  |  |  |  |  |  |  |  |  | 0
5.05 |  |  |  |  |  |  |  |  |  | 0
5.06 |  |  |  |  |  |  |  |  |  | 0
5.07 |  |  |  |  |  |  |  |  |  | 0
5.08 |  |  |  |  |  |  |  |  |  | 0
5.09 |  |  |  |  |  |  |  |  |  | 0
5.1 |  |  |  |  |  |  |  |  |  | 0
5.11 |  |  |  |  |  |  |  |  |  | 0
5.12 |  |  |  |  |  |  |  |  |  | 0
5.13 |  |  |  |  |  |  |  |  |  | 0
5.14 |  |  |  |  |  |  |  |  |  | 0
5.15 |  |  |  |  |  |  |  |  |  | 0
5.16 |  |  |  |  |  |  |  |  |  | 0
5.17 |  |  |  |  |  |  |  |  |  | 0
5.18 |  |  |  |  |  |  |  |  |  | 0
5.19 |  |  |  |  |  |  |  |  |  | 0
5.2 |  |  |  |  |  |  |  |  |  | 0
5.21 |  |  |  |  |  |  |  |  |  | 0
5.22 |  |  |  |  |  |  |  |  |  | 0
5.23 |  |  |  |  |  |  |  |  |  | 0
5.23999999999999 |  |  |  |  |  |  |  |  |  | 0
5.24999999999999 |  |  |  |  |  |  |  |  |  | 0
5.25999999999999 |  |  |  |  |  |  |  |  |  | 0
5.26999999999999 |  |  |  |  |  |  |  |  |  | 0
5.27999999999999 |  |  |  |  |  |  |  |  |  | 0
5.28999999999999 |  |  |  |  |  |  |  |  |  | 0
5.29999999999999 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 757579d1638348385-looking-for-a-formula-that-will-display-the-name-of-the-employee-available-shift-schedule-project
Sheet: Sheet2

 | Date
Spreadsheet: 76603d1277151043-sort-by-value-example-101-
Sheet: Sheet1

Actual Data |  |  |  | Pasted links
Contact Name | Phone number | Region |  | Contact Name | Phone number | Region
[NAME] | 5125555555 | 1 |  | [NAME] | 5125555555 | 1 | I want this table to remain as links, and be able to sort this table by the Contact Name, and have any updates I make to the Actual Data change the pasted links data.
[NAME] | 5125555565 | 2 |  | [NAME] | 5125555565 | 2
[NAME] | 5125555755 | 3 |  | [NAME] | 5125555755 | 3
Homer | 5125558555 | 4 |  | Homer | 5125558555 | 4
Jethro | 5125595555 | 5 |  | Jethro | 5125595555 | 5
martin | 5125101111 | 6 |  | martin | 5125101111 | 6
[NAME] | 5121155555 | 7 |  | [NAME] | 5121155555 | 7
Lester | 5125555512 | 8 |  | Lester | 5125555512 | 8
[NAME] | 5125555135 | 9 |  | [NAME] | 5125555135 | 9
Prudence | 5125551455 | 10 |  | Prudence | 5125551455 | 10
Lilly | 5125515555 | 11 |  | Lilly | 5125515555 | 11
Biff | 5125165555 | 12 |  | Biff | 5125165555 | 12
Spreadsheet: 697854d1601570724-find-count-last-number-whitout-zero-value
Sheet: Sheet1

A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | Result
2 | 0 | 4 | 8 | 0 | 0 | 0 | 0 | 4
6 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 3
77 | 0 | 0 | 0 | 9 | 9 | 0 | 0 | 6
0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
66 | 7 | 0 | 1 | 0 | 7 | 7 | 0 | 7
5 | 6 | 7 | 0 | 4 | 0 | 0 | 1 | 8
Spreadsheet: 811964d1672894809-conditional-format-with-conditons-sample-376
Sheet: Sheet1

ID | Code | Value 1 | Value 2
1177 | 2022-102 | 1 |  |  | 1177
1178 | 2022-103 | 1 |  |  | 1178
1179 | 2022-104 | 1 |  |  | 1179
1180 | 2022-106 |  | 75 |  | 1180
1180 | 2022-PZ-07 | 336 |  |  | 1181
1181 | 2022-114 |  | 8 |  | 1182
1182 | 2022-116 | 150 |  |  | 1183
1183 | 2022-117 |  | 15 |  | 1184
1184 | 2022-118 | 270 |  |  | 1185
1184 | 2022-PZ-12 | 240 |  |  | 1186
1185 | 2022-119 | 112 | 135 |  | 1187
1186 | 2022-120 | 30
1187 | 2022-124 | 210
Spreadsheet: 780395d1652433204-formula-that-provides-a-daily-amount-settlement-delay-according-to-options-in-the-drop-d-progression
Sheet: Sheet1

 |  |  | Yearly Processing Amount € | 100000
 |  |  |  | Amount €
 |  | Settlement day | T1 |  |  |  |  |  |  |  |  | T1
 |  |  |  |  |  |  |  |  |  |  |  | T2
 |  |  |  |  |  |  |  |  |  |  |  | T3
 |  |  |  |  |  |  |  |  |  |  |  | T4
 |  |  |  |  |  |  |  |  |  |  |  | T5
 | 1 | I need a formula that show the settlement delay amount according to the different T selections. |  |  |  |  |  |  |  |  |  | T6
 | 2 | Such delay amount is calculate daily and varies according to T variance. |  |  |  |  |  |  |  |  |  | T7
 | 3 | Each T is followed by a number meaning the settlement delay days and the relating amount |  |  |  |  |  |  |  |  |  | T8
 |  | e.g. T5 should give 1,369.86 |  |  |  |  |  |  |  |  |  | T9
 |  |  |  |  |  |  |  |  |  |  |  | T10
Spreadsheet: 142503d1329879616-sumifs-dummysheet
Sheet: Main Data

State | Apple Total
Georgia | 45
Georgia | 654
Georgia | 4
Georgia | 33
Georgia | 464
Georgia | 234
Alabama | 76
Alabama | 324
Alabama | 764
Alabama | 345
Alabama | 98
Alabama | 675
Louisiana | 23
Louisiana | 465
Louisiana | 65
Florida | 7
Florida | 987
Florida | 54
Florida | 333
Spreadsheet: 806026d1669056442-check-qualification-based-on-multiple-criteria-using-a-table-with-logic-operators-qualification-test
Sheet: Sheet1

Tier 1 - Must have at least $1m in current business
-AND
--1. - At least 10 new client sales worth at least $250,000 in new sales
--OR
--2. - At least $500,000 in new sales
[NAME] have less than $1m in current business
-AND
--1. - At least 10 new client sales worth at least $100,000 in new sales
--OR
--2. - At least $250,000 in new sales
Current Amounts (Input) |  |  |  |  |  |  |  | Output
Current Business | New Clients | New Sales $ |  |  |  |  |  | Tier | Sub-Tier
1000000 | 10 | 250000
Table of Rules
Symb.1 | Current Business $ | Operator1 | Symb.2 | New Clients | Operator2 | [NAME] | New Sales $ | Tier | Sub-Tier
>= | 1000000 | AND | >= | 10 | AND | > | 250000 | Tier 1 | 1
>= | 1000000 | AND | >= | N/A | AND | > | 500000 | Tier 1 | 2
< | 1000000 | AND | >= | 10 | AND | > | 100000 | [NAME] | 1
< | 1000000 | AND | >= | N/A | AND | > | 250000 | [NAME] | 2
Potential Future Scenerio
Table of Rules
Symb.1 | Current Business $ | Operator1 | Symb.2 | New Clients | Operator2 | [NAME] | New Sales $ | Tier | Sub-Tier
>= | 5000000 | AND | >= | 20 | OR | > | 400000 | Tier 1 | 1
>= | 5000000 | AND | >= | N/A | AND | > | 600000 | Tier 1 | 2
>= | 5000000 | AND | >= | 15 | AND | > | 300000 | Tier 1 | 3
>= | 3000000 | AND | >= | 15 | OR | > | 250000 | [NAME] | 1
>= | 3000000 | AND | >= | N/A | AND | > | 500000 | [NAME] | 2
< | 1000000 | AND | >= | 10 | AND | > | 100000 | Tier 3 | 1
< | 1000000 | AND | >= | N/A | AND | > | 250000 | Tier 3 | 2
< | 1000000 | OR | >= | 30 | OR |  | 500000 | [NAME] | 1
Spreadsheet: 844231d1695983178-create-one-list-from-two-dymanic-columns-combining-2-columns-of-data-without-blank-results
Sheet: Sheet1

 | Example 1 |  |  |  |  |  |  |  | Example 2
 | Range A | Range B |  | Desired Result: | Result |  |  |  | Range A | Range B |  | Desired Result: | Result
 | Cat | Turtle |  | Cat |  |  |  |  | Cat | Turtle |  | Cat
 | Dog | Fish |  | Dog |  |  |  |  | Dog | Fish |  | Dog
 | Monkey | Shark |  | Monkey |  |  |  |  | Monkey | Shark |  | Monkey
 | Donkey | Whale |  | Donkey |  |  |  |  |  | Whale |  | Turtle
 | Tiger |  |  | Tiger |  |  |  |  |  | Crab |  | Fish
 | Giraffe |  |  | Giraffe |  |  |  |  |  | Dolphin |  | Shark
 |  |  |  | Turtle |  |  |  |  |  |  |  | Whale
 |  |  |  | Fish |  |  |  |  |  |  |  | Crab
 |  |  |  | Shark |  |  |  |  |  |  |  | Dolphin
 |  |  |  | Whale
Spreadsheet: mary_fischer__25615__32L
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032L
COMPANY NAME   Jovinole Associates
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Deferred royalty |  | 88316 |  |  |  |  |  | 34986
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 42133d1240685050-low-single-value-in-a-column-book1
Sheet: WK 1

 |  |  | 2009-04-23 00:00:00 | Week 1
 |  |  |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Gross | Net
 |  | Net |  | Front Par | 4 | 4 | 5 | 3 | 4 | 3 | 5 | 3 | 4 | 35
 |  | Rank | Name | HCP | 10 | 4 | 5 | 12 | 16 | 14 | 6 | 2 | 1
 |  |  |  | Low Score for [NAME] (MIN) | 0 | 8 | 7 | 0 | 8 | 0 | 8 | 0 | 6
 |  | 1 | [NAME] | 5 | 6 | 4 | 5 | 3 | 5 | 4 | 5 | 6 | 6 | 44 | 39
 |  | 6 | [NAME] | 12 | 6 | 6 | 5 | 3 | 6 | 6 | 9 | 5 | 7 | 53 | 41
 |  | 11 | [NAME] | 13 | 6 | 9 | 10 | 5 | 5 | 3 | 7 | 5 | 9 | 59 | 46
 |  | 3 | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 3 | 6 | 4 | 7 | 45 | 40
 |  | 3 | [NAME] | 9 | 5 | 6 | 6 | 5 | 6 | 5 | 6 | 5 | 5 | 49 | 40
 |  | 10 | [NAME] | 10 | 6 | 6 | 10 | 4 | 4 | 3 | 7 | 5 | 7 | 52 | 42
 |  | 1 | [NAME] | 3 | 4 | 4 | 6 | 5 | 4 | 4 | 5 | 5 | 5 | 42 | 39
 |  | 6 | [NAME] | 14 | 6 | 8 | 6 | 4 | 7 | 5 | 7 | 5 | 7 | 55 | 41
 |  | 6 | [NAME] | 14 | 6 | 5 | 7 | 5 | 7 | 6 | 6 | 5 | 8 | 55 | 41
 |  | 6 | [NAME] | 14 | 6 | 7 | 6 | 5 | 8 | 6 | 6 | 6 | 5 | 55 | 41
 |  | 3 | Stevie | 9 | 4 | 7 | 6 | 4 | 6 | 5 | 8 | 4 | 5 | 49 | 40
Spreadsheet: 850995d1701271988-formula-to-pull-filtered-list-from-another-sheet-based-on-search-box-calculetor-2-jacc
Sheet: Search

 |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1415736-excel-formula.html
 |  |  |  | [NAME]
 |  |  | Item Name | Brand | Company1 | Price1 | Company2 | Price2 | Company3 | Price3
False
True
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
Spreadsheet: 239907d1370067176-repetitive-columns-to-simple-horizontal-table-table
Sheet: Sheet1

Table | apples | oranges | pears | bananas | [NAME] | sapparot
Bec | 1 | 2 | 3 | 4 | 5 | 6
[NAME] | 7 | 8 | 9 | 10 | 11 | 12
Bec2 | 13 | 14 | 15 | 16 | 17 | 18
David2 | 19 | 20 | 21 | 22 | 23 | 24
Spreadsheet: 93341d1292943369-copy-to-invoice-excel-invoices-2
Sheet: Products

 |  |  |  |  |  |  |  | WORLD OF WOOD CABINET MAKERS LTD
 | [NAME] |  |  |  | PRICE | QUANTITY | TOTAL
PRODUCT
ALEG | ADJUSTABLE LEGS P/SET |  |  |  | 3.15 | 1 | 3.15
CWV7 | CORNER WALL VEN 750H |  |  |  | 64.97 | 2 | 129.94
DWC6 | D/WALL CARCASE 600H |  |  |  | 32.55 | 2 | 65.1
BUOH | BUILT UNDER OVEN HSG |  |  |  | 32.43 | 1 | 32.43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER ACKNOWLEDGEMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOORMAKER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MR & MRS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MRS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MISS
ADDITIONAL ITEMS |  |  |  |  | PRICE | QUANTITY | TOTAL
Corner Shaker Door |  | 1 |  |  | 50 | 1 | 50
 |  |  |  |  | SUBTOTAL |  | 280.62
 |  |  |  |  | VAT @ 15% |  | 42.093
 |  |  |  |  | DISCOUNT
 |  |  |  |  | TOTAL |  | 322.713
 |  |  |  |  | TOTAL |  | -280.62
 |  |  |  |  |  |  |  | WORLD OF WOOD CABINET MAKERS LTD
 |  |  |  |  |  |  |  | DECORS | Description |  | Height | [NAME] | QUANTITY | PRICE | TOTAL
 |  |  |  |  |  |  |  | 18mm | #N/A |  | 600 | 400 | 0.24 | #N/A | #N/A
 |  |  |  |  |  |  |  | 4mmSS | #N/A |  | 900 | 300 | 0.27 | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | SUBTOTAL     PRODUCTS |  |  | 280.62
 |  |  |  |  |  |  |  |  |  |  |  | SUBTOTAL     DOORS |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | SUBTOTAL |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | VAT @ 17.5% |  |  | #N/A
 |  |  |  |  |  |  |  |  | Company Reg.No 2349301 |  |  | DISCOUNT
 |  |  |  |  |  |  |  |  | [NAME].No. 518 2077 54 |  |  | GRAND TOTAL |  |  | #N/A
Spreadsheet: 763745d1642361643-attendance-calculation-shiva_attendance
Sheet: Sheet1

Location |  | Shifts |  |  | Name1 | Amount1 | [NAME] | Amount2 | Name3 | Amount3 | Name4 | Amount4 | Name5 | Amount5
[NAME] | 2021-12-01 00:00:00 | Shift-1 | 50 | 22 | M | 100 | N | 600 | O | 600 | P | 600 | Q | 400
[NAME] |  | Shift-2 | 45 | 17 | M | 200 | N | 400 | O | 400 | P | 200 | Q | 100
XYZ-02 | 2021-12-01 00:00:00 | Shift-1 | 0 | 1 | M | 100 | N | 600 | O | 600 | P | 600 | Q | 400
XYZ-02 |  | Shift-2 | 0 | 1 | M | 200 | N | 400 | O | 400 | P | 200 | Q | 100
XYZ-02 | 2021-12-02 00:00:00 | Shift-1 | 0 | 1 | M | 100 | N | 600 | O | 600 | P | 600 | Q | 400
XYZ-02 |  | Shift-2 | 0 | 1 |  | 200 |  | 400 |  | 400 |  | 200 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attendance | Total Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 2 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | 2 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | 2 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 2 | 500
Spreadsheet: 136137d1326427571-readign-from-other-worksheets-multi-year-testing-data-sheets2
Sheet: class 2

class | 2
ID no. | name | spelling | maths | reading
Spreadsheet: 79048d1279278827-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-system-forumex
Sheet: Q1314

Cost Centre
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1314 | 1401 | 555 | Gimli | 2010-01-04 00:00:00 | 2011-12-04 00:00:00 | 3 | 10 | Pizza  Hut | B |  |  |  |  |  |  | 1401 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1402 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1403
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1314 | 1401 | 555 | Gimli | 2010-01-04 00:00:00 | 2011-12-04 00:00:00 | 3 | 10 | Pizza  Hut | B
Spreadsheet: 329028d1404166390-timesheet-timesheet-test
Sheet: Sheet1

2013-12-22 00:00:00
Date | Day | Type | In | Out | In | Out | Regular Hours | Overtime Hours | Dbltime Hours | Vacation | Holiday | Sick | Jury
 | Sunday | Regular
 | Monday | Regular | 07:00:00 | 11:30:00 | 12:00:00 | 13:00:00
 | Tuesday | Regular | 07:00:00 | 11:30:00 | 12:00:00 | 13:00:00
 | Wednesday | Regular | 07:00:00 | 11:30:00 | 12:00:00 | 18:00:00
 | Thursday | Regular | 07:00:00 | 11:30:00 | 12:00:00 | 18:00:00
 | Friday | Regular | 07:00:00 | 11:30:00 | 12:00:00 | 15:30:00
 | Saturday | Regular
 |  |  | Morning Hours | Afternoon Hours | RT | OT | DT
 |  |  |  | Total Hours
 |  |  |  | OT Hours |  | This cell should read 5, however, if I enter more hours on another day it should read + those hours.
 |  |  |  | Reg Hours |  | This cell should read 35, however, if the person works an additional day it needs to + those hours to the total.
 |  |  |  |  | I need F24 to be able to show regular hours.
 |  |  |  |  | The problem I am having is this.  I have an employee that works less than 8 hours on one or two days.
 |  |  |  |  | On other days he/she can work over 8.  In California, I must pay them if they work over 8 in a day.
 |  |  |  |  | My formulas don't take into account if they have not worked a full 8 hour day and the OT they work on
 |  |  |  |  | other days can't be combined in the Reg hours field.
 |  |  |  |  | Any suggestions would be great.
Spreadsheet: 687614d1595314697-formula-to-extract-data-to-the-left-extract-names
Sheet: Sheet1

BR1 Sales A21 |  | BR1 Sales
BR2 A21 |  | BR2
BR2 A41 |  | BR2
BR3 Debtors A46 |  | BR3 Debtors
Column1 | Column1
BR1 Sales A21 | BR1 Sales
BR2 A21 | BR2
BR2 A41 | BR2
BR3 Debtors A46 | BR3 Debtors
Spreadsheet: 163202d1340220643-excel-2007-specify-chart-data-range-using-an-if-formula-dynamic-chart-range
Sheet: Dynamic Data

 | Calculations
 | Selected Chart Option | Region
 | Data for the chart
 | Year | London | Midlands | North | South | London | East Midlands | East of England | West Midlands | North East | North West | Yorkshire | South Central | South East Coast | South West
 | 2010/2011 | 46704307.29212753 | 50142351.29886874 | 49619394.79394341 | 55403361.00466315 | 46704307.29212753 | 12845499.70187608 | 14990824.85 | 22306026.74699266 | 7688393.465270543 | 26133402.7890979 | 15797598.53957497 | 21001351.99 | 15324286.45 | 19077722.56466315
 | 2011/2012 | 48800844.15600471 | 57315497.70278163 | 50751672.59733258 | 62151668.135717 | 48800844.15600471 | 16532260.47882961 | 18576811.47395201 | 22206425.75 | 8423577.889591439 | 25827768.25774114 | 16500326.45 | 20761504.23571699 | 18373706.9 | 23016457
Spreadsheet: 45537d1244269748-password-protection-and-vlookup-overtimeslots-worksheetchangemacro
Sheet: OT LIST

[NAME]
WEEK OF: |  |  |  |  |  |  |  |  | 2009-06-07 00:00:00
 |  | 2009-06-07 00:00:00 | 2009-06-08 00:00:00 | 2009-06-09 00:00:00 | 2009-06-10 00:00:00 | 2009-06-11 00:00:00 | 2009-06-12 00:00:00 | 2009-06-13 00:00:00 |  |  |  | 2009-06-07 00:00:00 | 2009-06-08 00:00:00 | 2009-06-09 00:00:00 | 2009-06-10 00:00:00 | 2009-06-11 00:00:00 | 2009-06-12 00:00:00 | 2009-06-13 00:00:00
 |  | SUN | MON | TUE | WED | THU | FRI | SAT |  |  |  | SUN | MON | TUE | WED | THU | FRI | SAT
1 | CALIS |  |  |  |  |  |  |  |  | 26 | [NAME]
2 | LAMANTIA |  |  |  |  |  |  |  |  | 27 | MAY, R.
3 | MACK |  |  |  |  |  |  |  |  | 28 | GROVER
4 | SUMOGE |  |  |  |  |  |  |  |  | 29 | WEAVER
5 | BURKE |  |  |  |  |  |  |  |  | 30 | EKMAN
6 | PLUMONDORE |  |  |  |  |  |  |  |  | 31 | DAVIS, V.
7 | MAY, B. |  |  |  |  |  |  |  |  | 32 | CRANDALL
8 | LUCERO |  |  |  |  |  |  |  |  | 33 | ABABIYA
9 | BETTS |  |  |  |  |  |  |  |  | 34 | PARKER
10 | ELDRIDGE |  |  |  |  |  |  |  |  | 35 | NEU
11 | CARUSO |  |  |  |  |  |  |  |  | 36 | LAND
12 | MOON |  |  |  |  |  |  |  |  | 37 | CASLER
13 | BOHANNON |  |  |  |  |  |  |  |  | 38 | ZHIRONKIN
14 | ASHKER |  |  |  |  |  |  |  |  | 39 | GARIFALAKIS, B.
15 | MCKIMSON |  |  |  |  |  |  |  |  | 40 | MCDONALD
16 | DAVIS, B. |  |  |  |  |  |  |  |  | 41 | PERAZA
17 | BECKER |  |  |  |  |  |  |  |  | 42 | GARIFALAKIS, P.
18 | NICKELS |  |  |  |  |  |  |  |  | 43 | HOLM
19 | VACHTER |  |  |  |  |  |  |  |  | 44 | EASTWOOD JR.
20 | SAMPSON |  |  |  |  |  |  |  |  | 45 | PIERCE
21 | BRAY |  |  |  |  |  |  |  |  | 46 | HERSHEL
22 | [NAME] |  |  |  |  |  |  |  |  | 47
23 | GONZALEZ |  |  |  |  |  |  |  |  | 48
24 | MAYER |  |  |  |  |  |  |  |  | 49
25 | PALMER |  |  |  |  |  |  |  |  | 50 | ERICKSON
Spreadsheet: 473089d1470045196-vlookup-partial-text-example
Sheet: Amnesty

Student Ref (five digit) | Student Name | Preferred Name | Gender | Age (1/9/15) | Nationality | Residence |  | 2015-09-07 00:00:00 | 2015-09-14 00:00:00 | 2015-09-21 00:00:00 | 2015-09-28 00:00:00 | 2015-10-05 00:00:00 | 2015-10-12 00:00:00 | 2015-10-19 00:00:00 | 2015-10-26 00:00:00 | 2015-11-02 00:00:00 | 2015-11-09 00:00:00 | 2015-11-16 00:00:00 | 2015-11-23 00:00:00 | 2015-11-30 00:00:00 | 2015-12-07 00:00:00 | 2015-12-14 00:00:00 | 2015-12-21 00:00:00 | 2015-12-28 00:00:00 | 2016-01-04 00:00:00 | 2016-01-11 00:00:00 | 2016-01-18 00:00:00 | 2016-01-25 00:00:00 | 2016-02-01 00:00:00 | 2016-02-08 00:00:00 | 2016-02-15 00:00:00 | 2016-02-22 00:00:00 | 2016-02-29 00:00:00 | 2016-03-07 00:00:00 | 2016-03-14 00:00:00 | 2016-03-21 00:00:00 | 2016-03-28 00:00:00 | 2016-04-04 00:00:00 | 2016-04-11 00:00:00 | 2016-04-18 00:00:00 | 2016-04-25 00:00:00 | 2016-05-02 00:00:00 | 2016-05-09 00:00:00 | 2016-05-16 00:00:00 | 2016-05-23 00:00:00 | 2016-05-30 00:00:00 | 2016-06-06 00:00:00 | 2016-06-13 00:00:00 | 2016-06-20 00:00:00 | 2016-06-27 00:00:00
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 16a

Product |  | TOTAL
Single - Name* | Corporate
 | Loans
 | Municipal
 | Recovery
 | Sovereign
Index Tranche | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A**
Estimated swap dollar volumes, week ending January 11, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].