tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: harry_arora__12174__Vol Book Daily Market
Sheet: Summary Cinergy

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250
Daily Option Payoff |  |  |  | 1998 | 1998 |  |  |  | 1999 | 1999 |  |  |  | 2000 | 2000 |  |  |  | 2001 | 2001 |  |  | Trade_day
 |  |  |  | C | P |  |  |  | C | P |  |  |  | C | P |  |  |  | C | P
35 |  | 2001-01-01 00:00:00
35 |  | 2001-02-01 00:00:00
30 |  | 2001-01-01 00:00:00
30 |  | 2001-02-01 00:00:00
25 |  | 2001-01-01 00:00:00
25 |  | 2001-02-01 00:00:00
100 |  | 2001-07-01 00:00:00
100 |  | 2001-08-01 00:00:00
50 |  | 2001-07-01 00:00:00
50 |  | 2001-08-01 00:00:00
40 |  | 2001-07-01 00:00:00
40 |  | 2001-08-01 00:00:00
30 |  | 2001-09-01 00:00:00
25 |  | 2001-09-01 00:00:00
20 |  | 2001-09-01 00:00:00
30 |  | 2001-10-01 00:00:00
30 |  | 2001-11-01 00:00:00
30 |  | 2001-12-01 00:00:00
30 |  | Q4
25 |  | 2001-10-01 00:00:00
25 |  | 2001-11-01 00:00:00
25 |  | 2001-12-01 00:00:00
25 |  | Q4
20 |  | 2001-10-01 00:00:00
20 |  | 2001-11-01 00:00:00
20 |  | 2001-12-01 00:00:00
20 |  | Q4
Cash Market |  |  |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME]
 |  |  |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over
 |  |  |  | Cinergy | HH | Rate | Capacity |  | Cinergy | HH | Rate | Capacity |  | Cinergy | HH | Rate | Capacity |  | Cinergy | HH | Rate | Capacity
 |  |  |  | 1998 | 1998 | 1998 | 1998 |  | 1999 | 1999 | 1999 | 1999 |  | 2000 | 2000 | 2000 | 2000 |  | 2001 | 2001 | 2001 | 2001
 |  | Price
 |  | 2001-01-01 00:00:00
 |  | 2001-02-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 22
 |  | 2001-11-01 00:00:00 | 20 |  |  |  |  | 20 |  |  |  |  | 20
 |  | 2001-12-01 00:00:00 | 22 |  |  |  |  | 22 |  |  |  |  | 20
 |  | Q4
 |  | Actualized Vol
 |  | 2001-01-01 00:00:00
 |  | 2001-02-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 22
 |  | 2001-11-01 00:00:00 | 20 |  |  |  |  | 20 |  |  |  |  | 20
 |  | 2001-12-01 00:00:00 | 22 |  |  |  |  | 22 |  |  |  |  | 20
 |  | Q4
Spreadsheet: 128821d1321296583-help-with-vlookup-formula-issues
Sheet: Sheet1

Issue | Internal\External |  |  |  |  | ROOT CAUSE | Int\Ext
issue #4 |  |  |  |  |  | issue #1 | Internal
issue #15 |  |  |  |  |  | issue #2 | Internal
issue #15 |  |  |  |  |  | issue #3 | External
issue #6 |  |  |  |  |  | issue #4 | Internal
issue #2 |  |  |  |  |  | issue #5 | Internal
issue #3 |  |  |  |  |  | issue #6 | External
issue #5 |  |  |  |  |  | issue #7 | Internal
issue #12 |  |  |  |  |  | issue #8 | External
issue #7 |  |  |  |  |  | issue #9 | Internal
 |  |  |  |  |  | issue #10 | issue #10
issue #2 |  |  |  |  |  | issue #11 | Internal
issue #13 |  |  |  |  |  | issue #12 | Internal
issue #15 |  |  |  |  |  | issue #13 | External
issue #1 |  |  |  |  |  | issue #14 | issue #14
issue #8 |  |  |  |  |  | issue #15 | External
issue #10
issue #12
issue #5
issue #13
issue #3
issue #7
issue #12
issue #8
issue #12
issue #13
issue #13
issue #13
issue #4
issue #12
issue #3
issue #12
issue #3
issue #14
issue #3
issue #13
issue #12
issue #12
issue #4
issue #13
issue #3
issue #3
issue #5
issue #10
issue #6
issue #6
issue #13
issue #10
issue #6
issue #3
issue #3
issue #13
issue #13
issue #3
issue #10
issue #12
issue #6
issue #3
issue #6
issue #3
issue #12
issue #10
issue #10
issue #3
issue #3
issue #10
issue #6
issue #12
issue #15
issue #3
issue #7
issue #7
issue #1
issue #12
issue #3
issue #1
issue #1
issue #6
issue #15
issue #8
issue #12
issue #11
issue #3
issue #12
issue #15
issue #3
issue #13
issue #6
issue #6
issue #11
issue #4
issue #12
issue #4
issue #6
issue #5
issue #5
issue #12
issue #5
issue #5
issue #15
issue #12
issue #5
issue #3
issue #12
issue #12
issue #6
issue #4
issue #3
issue #12
issue #10
issue #12
issue #7
issue #5
issue #5
issue #13
issue #6
issue #5
issue #12
issue #12
issue #3
issue #7
issue #10
issue #8
issue #3
issue #3
issue #3
issue #11
issue #12
issue #4
issue #10
issue #4
issue #12
issue #15
issue #12
issue #13
issue #12
issue #3
issue #5
issue #5
issue #13
issue #13
issue #12
issue #15
issue #12
issue #15
issue #12
issue #2
issue #3
issue #12
issue #12
issue #15
issue #6
issue #10
issue #14
issue #6
issue #15
issue #12
issue #12
issue #6
issue #10
issue #12
issue #13
issue #10
issue #12
issue #12
issue #12
issue #12
issue #3
issue #12
issue #2
issue #6
issue #8
issue #3
issue #13
issue #12
issue #6
issue #3
issue #3
issue #6
issue #5
issue #13
issue #14
issue #12
issue #5
issue #12
Spreadsheet: 219180d1362678637-count-between-two-time-and-date-ranges-february-analysis
Sheet: List

19:44:59 |  |  | 19:45:00
 |  |  |  |  | Feb | 1
 |  |  |  |  | Feb L | 1
 |  |  |  |  | 30 | 1
 |  |  |  |  | 31 | 1
Spreadsheet: 167049d1341880938-summing-figures-based-on-date-and-offset-formula-problem
Sheet: Sheet1

 | PART 1 |  | 1ST DAT OF THIS MONTH | AMOUNT OF MONTHS TO OFFSET FROM TODAYS DATE
IMMEDIATE FORWARD SCHEDULE | NEED FORMULA HERE TO SUM JUL, AUG,SEP 2012 FIGURES USING TODAYS DATE AS A REFERENCE AND OFFSET AMOUNT |  |  | 3
2011-11-01 00:00:00 | 4
 | 5
 | 3
 | 6
 | 2
 | 8
 | 10
 | 4
 | 4
 | 4
 | 3
 | 1
 | 0
 | 0
Spreadsheet: 168194d1342289474-excel-2007-make-multiple-rows-into-one-row-of-data-test-file
Sheet: Sheet1

25 | Test, Account | 1901-01-01 00:00:00 | 0
 | 123 Main Street | 000-00-0000
 | Houston, TX 77627 | [PHONE]
15 | Test, [NAME] | 1901-01-01 00:00:00 | 0
 | 555 Main Street | 000-00-0000
 | Houston, TX 77627 | [PHONE]
32 | Test, Boy Account | 1901-01-01 00:00:00 | 0
 | 333 Main Street | 000-00-0000
 | Houston, TX 77627 | [PHONE]
Need it to look like this
25 | Test, Account | 1901-01-01 00:00:00 | 0 | 123 Main Street | 000-00-0000 | Houston, TX 77627 | [PHONE]
15 | Test, [NAME] | 1901-01-01 00:00:00 | 0 | 555 Main Street | 111-11-1111 | Houston, TX 77627 | [PHONE]
32 | Test, Boy Account | 1901-01-01 00:00:00 | 0 | 333 Main Street | 222-22-2222 | Houston, TX 77627 | [PHONE]
Spreadsheet: 217552d1362100834-automatically-copying-info-from-one-sheet-to-another-excel-help
Sheet: June 11

10:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
11:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
11:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
12:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
12:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
05:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
06:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
06:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
07:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
07:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
08:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Spreadsheet: 90005d1289766029-formula-getting-first-two-numbers-in-another-cell-date-first
Sheet: Sheet1

 | Loan
 |  | Duration |  | Monthly
 | Starting date | # monhts | Period of grace | Instalment
 | 2010-02-01 00:00:00 | 12 | 1 | 1000
2010-08-01 00:00:00 | Instalment
2010-03-01 00:00:00 |  |  | Note: I need formula giving "1" from cell b4 and replacing it in formula b8:b91 right at DAY(A8)="1"
2010-03-02 00:00:00 | 1
2010-03-03 00:00:00 | 1
2010-03-04 00:00:00 | 1
2010-03-05 00:00:00 | 1
2010-03-06 00:00:00 | 1
2010-03-07 00:00:00 | 1
2010-03-08 00:00:00 | 1
2010-03-09 00:00:00 | 1
2010-03-10 00:00:00 | 1
2010-03-11 00:00:00 | 1
2010-03-12 00:00:00 | 1
2010-03-13 00:00:00 | 1
2010-03-14 00:00:00 | 1
2010-03-15 00:00:00 | 1
2010-03-16 00:00:00 | 1
2010-03-17 00:00:00 | 1
2010-03-18 00:00:00 | 1
2010-03-19 00:00:00 | 1
2010-03-20 00:00:00 | 1
2010-03-21 00:00:00 | 1
2010-03-22 00:00:00 | 1
2010-03-23 00:00:00 | 1
2010-03-24 00:00:00 | 1
2010-03-25 00:00:00 | 1
2010-03-26 00:00:00 | 1
2010-03-27 00:00:00 | 1
2010-03-28 00:00:00 | 1
2010-03-29 00:00:00 | 1
2010-03-30 00:00:00 | 1
2010-03-31 00:00:00 | 1
2010-04-01 00:00:00 | 1
2010-04-02 00:00:00 | 1
2010-04-03 00:00:00 | 1
2010-04-04 00:00:00 | 1
2010-04-05 00:00:00 | 1
2010-04-06 00:00:00 | 1
2010-04-07 00:00:00 | 1
2010-04-08 00:00:00 | 1
2010-04-09 00:00:00 | 1
2010-04-10 00:00:00 | 1
2010-04-11 00:00:00 | 1
2010-04-12 00:00:00 | 1
2010-04-13 00:00:00 | 1
2010-04-14 00:00:00 | 1
2010-04-15 00:00:00 | 1
2010-04-16 00:00:00 | 1
2010-04-17 00:00:00 | 1
2010-04-18 00:00:00 | 1
2010-04-19 00:00:00 | 1
2010-04-20 00:00:00 | 1
2010-04-21 00:00:00 | 1
2010-04-22 00:00:00 | 1
2010-04-23 00:00:00 | 1
2010-04-24 00:00:00 | 1
2010-04-25 00:00:00 | 1
2010-04-26 00:00:00 | 1
2010-04-27 00:00:00 | 1
2010-04-28 00:00:00 | 1
2010-04-29 00:00:00 | 1
2010-04-30 00:00:00 | 1
2010-05-01 00:00:00 | 1
2010-05-02 00:00:00 | 1
2010-05-03 00:00:00 | 1
2010-05-04 00:00:00 | 1
2010-05-05 00:00:00 | 1
2010-05-06 00:00:00 | 1
2010-05-07 00:00:00 | 1
2010-05-08 00:00:00 | 1
2010-05-09 00:00:00 | 1
2010-05-10 00:00:00 | 1
2010-05-11 00:00:00 | 1
2010-05-12 00:00:00 | 1
2010-05-13 00:00:00 | 1
2010-05-14 00:00:00 | 1
2010-05-15 00:00:00 | 1
2010-05-16 00:00:00 | 1
2010-05-17 00:00:00 | 1
2010-05-18 00:00:00 | 1
2010-05-19 00:00:00 | 1
2010-05-20 00:00:00 | 1
2010-05-21 00:00:00 | 1
2010-05-22 00:00:00 | 1
2010-05-23 00:00:00 | 1
Spreadsheet: 275623d1383590735-calculating-commissions-with-varying-percentages-based-on-running-total-commission-tracker
Sheet: Sheet1

Name | Address | Commision AmtAmount | Running Total | Employee Split | Co split (commission - emp split) |  |  |  |  |  |  | Threshold | pct
ABC CO. | 123 Main St. | 3100 |  |  |  |  | Threshold | Pct |  |  |  | 0 | 0.5
ABC CO. | 124 Main St. | 125.1 |  |  |  |  | 0 | 0.5 |  |  |  | 100000 | 0.65
ABC CO. | 125 Main St. | 1500 |  |  |  |  | 100000 | 0.65 |  |  |  | 199999 | 0.75
ABC CO. | 126 Main St. | 7500 |  |  |  |  | 199999 | 0.75
ABC CO. | 127 Main St. | 360
ABC CO. | 128 Main St. | 2717.57
ABC CO. | 129 Main St. | 18000 |  |  |  |  | Enter data in ORANGE cells only
ABC CO. | 130 Main St. | 34925
ABC CO. | 131 Main St. | 211.68
ABC CO. | 132 Main St. | 548.1
ABC CO. | 133 Main St. | 36300
ABC CO. | 134 Main St. | 10000
ABC CO. | 135 Main St. | 1900
ABC CO. | 136 Main St. | 1900
ABC CO. | 137 Main St. | 960
Spreadsheet: 90227d1289989506-automatically-filled-in-form-booking-template1
Sheet: Sheet1

SïEïB
 |  | DEBET/CREDIT VOUCHER
Handling officer |  | User ID | Profit center | Date
Department |  | Telephone
Reason for booking
 | DEBIT | CREDIT
Account number | Account holder | Account number | Account holder
Profit center | Textcode | Profit center | Textcode
Value date |  | Value date
Amount SEK |  | Amount SEK
Amount/foreign ccy | Exchange rate | Amount/foreign ccy | Exchange rate
Reference |  | Reference
Signature Handling officer |  | Approval signature | Approval Signature clarification
Spreadsheet: 330469d1404757279-populate-data-in-a-table-based-on-dropdown-criteria-test1
Sheet: Data

ACCOUNT_NAME | INVOICE_START_DATE | PRODUCT | ITEM_UNITS | ITEM_UNIT_PRICE | ITEM_TOTAL | ORDER_ID | EFFECTIVE_END_DATE
Account A | 2014-03-01 00:00:00 | Product A | 1 | 1 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-03-01 00:00:00 | Product B | 2 | 2 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-03-01 00:00:00 | Product C | 3 | 3 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-03-01 00:00:00 | Product D | 4 | 4 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-03-01 00:00:00 | Product A | 10 | 1 |  | AA-12 | 2014-12-31 00:00:00
Account A | 2014-03-01 00:00:00 | Product B | 20 | 2 |  | AA-12 | 2014-12-31 00:00:00
Account A | 2014-03-01 00:00:00 | Product C | 30 | 3 |  | AA-12 | 2014-12-31 00:00:00
Account A | 2014-03-01 00:00:00 | Product D | 40 | 4 |  | AA-12 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product A | 100 | 1 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product B | 200 | 2 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product C | 300 | 3 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product D | 400 | 4 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product A | 1000 | 1 |  | AB-12 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product B | 2000 | 2 |  | AB-12 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product C | 3000 | 3 |  | AB-12 | 2014-12-31 00:00:00
Account B | 2014-03-01 00:00:00 | Product D | 4000 | 4 |  | AB-12 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product A | 11 | 1 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product B | 22 | 2 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product C | 33 | 3 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product D | 44 | 4 |  | AA-11 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product A | 111 | 1 |  | AA-12 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product B | 222 | 2 |  | AA-12 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product C | 333 | 3 |  | AA-12 | 2014-12-31 00:00:00
Account A | 2014-04-01 00:00:00 | Product D | 444 | 4 |  | AA-12 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product A | 1111 | 1 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product B | 2222 | 2 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product C | 3333 | 3 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product D | 4444 | 4 |  | AB-11 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product A | 11111 | 1 |  | AB-12 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product B | 22222 | 2 |  | AB-12 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product C | 33333 | 3 |  | AB-12 | 2014-12-31 00:00:00
Account B | 2014-04-01 00:00:00 | Product D | 44444 | 4 |  | AB-12 | 2014-12-31 00:00:00
Spreadsheet: 137052d1326925953-using-countif-and-dates-of-different-formats-excel-dates-problem
Sheet: Sheet1

 | Start Time | Visitor Name |  |  | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00
 | 2012-01-16 17:33:00 | Adam |  | Visitor Count
 | 2012-01-16 15:02:00 | [NAME]
 | 2012-01-16 15:09:00 | [NAME] |  |  |  | These zeros should be values!!
 | 2012-01-10 16:25:00 | [NAME]
 | 2012-01-16 20:28:00 | [NAME]
 | 2012-01-10 22:25:00 | [NAME]
 | 2012-01-10 22:22:00 | [NAME]
 | 2012-01-10 19:34:00 | [NAME]
 | 2012-01-07 20:50:00 | [NAME]
 | 2012-01-11 18:34:00 | [NAME]
 | 2012-01-11 21:57:00 | [NAME]
 | 2012-01-13 15:33:00 | [NAME]
 | 2012-01-04 17:19:00 | Corban
 | 2012-01-06 12:35:00 | Curtis Pugsley
 | 2012-01-16 12:32:00 | [NAME]
 | 2012-01-18 15:42:00 | [NAME]
Spreadsheet: d1ecfec1-4910-4725-92c0-65d79648e594
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
JACK | Test | JACK | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
JACK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
JACK | Result | JACK | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 19744-2 | Artocarpus heterophyllus Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 134761d1325617727-commission-formula-based-on-cumulative-percentages-commission-sales-tracker
Sheet: Q1 Commission Tracker

 |  | January | February | March | April | Total
 | QUOTA | 14000 | 18000 | 25000 | 22000 | 79000
 | Cumulative | 14000 | 32000 | 57000 | 79000
 | Total Monthly GP | 13000 | 18000 | 23000 | 18000 | 72000
 | Cumulative Total | 13000 | 31000 | 54000 | 72000
 | % ACHIEVED | 0.9285714285714286 | 1 | 0.92 | 0.8181818181818182 | 0.9113924050632911
 | [NAME] ACHIEVED | 0.9285714285714286 | 0.96875 | 0.9473684210526315 | 0.9113924050632911
PAYOUT | Actual Paid | January | February | March | April | Total
Level 1 | 0 - 84.99% | 0 | 0 | 0 | 0 | 0
Level 2 | 85% - 99.99% | 929 |  | 920 | 0 | 1849
Level 3 | 100% to 125% | 0 | 1000 | 0 | 0 | 1000
 |  |  |  |  | TOTAL PAID | 2849
 |  | Adjusted Commission
Level 1 | 0 - 84.99% | 0 | 0 | 0 | 0 | 0
Level 2 | 85% - 99.99% | 929 | 969 | 947 | 911 | 3756
Level 3 | 100% to 125% | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | TOTAL OWED | 3756
 | Annual Bonus Earned | 929 | 1000 | 0 | 0 |  | Balance Owed to staff Q1
 | Monthly Bonus Paid | 929 | 71 | 0 | 0 | 1000 |  | 907
 | [NAME]
Cumulative POT | 4000 | 1000 | 1000 | 1000 | 1000
Spreadsheet: 123011d1317294157-workday-and-vlookup-to-select-a-range-of-holiday-dates-workday_rangeofholiday
Sheet: Sheet1

Country | Holiday dates
BR | Holiday 1 | Holiday 2 | Holiday 3 | Holiday 4 | Holiday 5 | Holiday 6 | Holiday 7 | Holiday 8 | Holiday 9 | Holiday 10 | Holiday 11
PA
DE | 2011-01-01 00:00:00 | 2011-04-22 00:00:00 | 2011-04-25 00:00:00 | 2011-05-01 00:00:00 | 2011-05-08 00:00:00 | 2011-06-13 00:00:00 | 2011-07-14 00:00:00 | 2011-08-15 00:00:00 | 2011-11-01 00:00:00 | 2011-11-11 00:00:00 | 2011-12-25 00:00:00
MC | 2011-01-01 00:00:00 | 2011-04-22 00:00:00 | 2011-04-25 00:00:00 | 2011-05-01 00:00:00 | 2011-12-25 00:00:00 | 2011-12-26 00:00:00
MI
HE
I
L
OL
AS | 2011-10-01 00:00:00 | 2011-10-04 00:00:00 | 2011-10-10 00:00:00
Today | Settlement
2011-09-29 00:00:00 | 30
Workday Function | AS | 2011-11-14 00:00:00
How to select a range of holiday dates with respect to country name ? (ex range(B12:D12) for country "AS" etc…)
Spreadsheet: 89131d1288888095-sorting-list-without-formulas-changing-campus-students-weekly-report-2011fa1-2-example
Sheet: Sheet1

AK | ALASKA | 1
AL | ALABAMA | 2
AR | ARKANSAS | 0
AZ | ARIZONA | 0
CA | CALIFORNIA | 1
CO | COLORADO | 1
CT | CONNECTICUT | 3
DE | DELAWARE | 1
FL | FLORIDA | 397
GA | GEORGIA | 3
HI | HAWAII | 0
IA | IOWA | 0
ID | IDAHO | 0
IL | ILLINOIS | 6
IN | INDIANA | 0
KS | KANSAS | 0
KY | KENTUCKY | 2
LA | LOUISIANA | 1
MA | MASSACHUSETTS | 5
MD | MARYLAND | 0
ME | MAINE | 0
MI | MICHIGAN | 2
MN | MINNESOTA | 1
MO | MISSOURI | 1
MS | MISSISSIPPI | 0
MT | MONTANA | 0
NC | NORTH CAROLINA | 0
ND | NORTH DAKOTA | 0
NE | NEBRASKA | 0
NH | NEW HAMPSHIRE | 0
NJ | NEW JERSEY | 11
NM | NEW MEXICO | 0
NV | NEVADA | 0
NY | NEW YORK | 14
OH | OHIO | 5
OK | OKLAHOMA | 0
OR | OREGON | 0
PA | PENNSYLVANIA | 3
RI | RHODE ISLAND | 1
SC | SOUTH CAROLINA | 1
SD | SOUTH DAKOTA | 0
TN | TENNESSEE | 1
TX | TEXAS | 1
UT | UTAH | 0
VA | VIRGINIA | 4
VT | [NAME] | 2
WA | WASHINGTON | 0
WI | WISCONSIN | 2
WV | WEST VIRGINIA | 0
WY | WYOMING | 0
Spreadsheet: 178518d1346826596-trying-to-add-2-formulas-together-in-a-cell-sample1
Sheet: Monday

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59
61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69
71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79
81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89
91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99
101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109
111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119
Spreadsheet: 109111d1306029256-dependant-custom-sort-tracking-spreadhseet-for-future
Sheet: Data

 | Planning Data for Future South Louisiana Wells
Well Phase | Stage | Subject
Construction | Dredging | Dredging
Construction | Other | Wellsite
MOB | Shipyard | [NAME]
MOB | Shipyard | [NAME]
MOB | Shipyard | 2nd Koomey Unit
MOB | Staging | [NAME]
MOB | Staging | 20" Casing
MOB | Staging | Tug
MOB | Towing | Tugs
MOB | Towing | [NAME]
MOB | Towing | Towing Time
MOB | Towing | [NAME]
Surfcae Casing 20in | Cementing | [NAME]
Surfcae Casing 20in | Drilling/Tripping | 6-5/8" DP
Surfcae Casing 20in | Drilling/Tripping | 6-5/8" DP
Surfcae Casing 20in | Nipple Up | Diverter
Pre Planning | Vendors | Contact List
Pre Planning | Vendors | Notification
Drive Pipe 30in | Delivery | Diverter
Surface Casing 20in | Nipple Up | BOP Weight