tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Oct14-Oct20m

Main Arena
 | 2012-10-14 00:00:00 |  |  | Thru | 2012-10-20 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-10-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-20 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 168640d1342532443-vlookup-using-multiple-table_array-vlookup
Sheet: Sheet3

plu | old plu | ean | Article Description | $ | Code | Descript | $
10000 | 3033 | 1203598722 | SHANDAR VANILLA CAKE MC-28855 | 1111 | 10000 | SHANDAR VANILLA CAKE MC-28855 | 1111
10001 | 1009 | 9300000000000 | KRAFT SINGLES CHEESE 12S 250G | 2222 | 10001 | KRAFT SINGLES CHEESE 12S 250G | 2222
10002 | 1010 | 1010203687 | KRAFT FREE SINGLES CHEESE 250 PKT | 3333 | 10001 | KRAFT SINGLES CHEESE 12S 250G | 2222
10003 | 10331 | 935555475211 | GOLDEN CHURN SALTED BUTTER 227G | 4444 |  | #N/A | #N/A
10004 | 10774 | 88029361145 | AGORA FRUITS BASKET LARGE | 5555 |  | #N/A | #N/A
10005 | 10785 | 172573214 | AGORA FRESH MANGO JUICE/GLASS | 6666 |  | #N/A | #N/A
10006 | 10788 | 107889985 | AGORA FRESH FRUIT JUICE/GLASS | 7777 |  | #N/A | #N/A
10007 | 10788 A |  | AGORA FRESH LASSI/GLASS | 8888 |  | #N/A | #N/A
10008 | 10856 | 98753256985 | QUALITY FETA CHEESE 1KG | 9999 |  | #N/A | #N/A
10009 | 10916 | 144288444 | AGORA FRUITS BASKET SPECIAL-B | 1010 |  | #N/A | #N/A
10010 | 10917 | 12448632148 | AGORA LOCAL FRUITS BASKET | 1111 |  | #N/A | #N/A
10011 | 10918 | 985211474 | AGORA FRUITS BASKET SMALL | 1212 |  | #N/A | #N/A
10012 | 10919 |  | AGORA FRUITS BASKET MEDIUM | 1313 |  | #N/A | #N/A
10013 | 10920 | 76522147 | AGORA FRUITS BASKET BIG | 1414 |  | #N/A | #N/A
10014 | 11058 | 88884514323 | [NAME] MUSHROOM DRY 50G PKT | 1515 |  | #N/A | #N/A
10015 | 11163 | 787546213 | GHARKONNYA ELE BELE PITHA | 1616 |  | #N/A | #N/A
10016 | 11165 |  | GHARKONNYA BAKUL PHUL PITHA | 1717 |  | #N/A | #N/A
10017 | 11243 | 8162343538 | DRY APRICOT 350G PKT | 1818
Spreadsheet: 87102d1286997836-data-comparison-extraction-indicator_purchases
Sheet: Order planning

Item No. | Description | Needed Quantity | Due Date | Last order date | Delay in days | Cost
BARA 010 | BARA   D12 - S235 JR | 0.29668 | 2010-09-08 00:00:00 | 2010-09-09 00:00:00 | -1
BARA 010 | BARA   D12 - S235 JR | 2.887 | 2010-09-17 00:00:00 | 2010-09-09 00:00:00 | 8
BARA 010 | BARA   D12 - S235 JR | 2.269 | 2010-09-17 00:00:00 | 2010-09-09 00:00:00 | 8
BARA 010 | BARA   D12 - S235 JR | 0.151 | 2010-09-24 00:00:00 | 2010-09-09 00:00:00 | 15
BARA 010 | BARA   D12 - S235 JR | 0.031 | 2010-10-01 00:00:00 | 2010-09-09 00:00:00 | 22
BARA 010 | BARA   D12 - S235 JR | 0.596 | 2010-10-05 00:00:00 | 2010-09-09 00:00:00 | 26
BARA 010 | BARA   D12 - S235 JR | 0.462 | 2010-10-05 00:00:00 | 2010-09-09 00:00:00 | 26
BARA 010 | BARA   D12 - S235 JR | 0.596 | 2010-10-05 00:00:00 | 2010-09-09 00:00:00 | 26
BARA 010 | BARA   D12 - S235 JR | 0.462 | 2010-10-05 00:00:00 | 2010-09-09 00:00:00 | 26
BARA 010 | BARA   D12 - S235 JR | 2.977 | 2010-10-05 00:00:00 | 2010-09-09 00:00:00 | 26
BARA 010 | BARA   D12 - S235 JR | 2.306 | 2010-10-05 00:00:00 | 2010-09-09 00:00:00 | 26
Spreadsheet: 876858d1723571113-skip-cells-with-zero-in-row-numberpatterns1
Sheet: Sheet1

1 | 2 |  |  | # used |  |  | Digit1 | Digit2 | Digit3 | Digit4 | Digit5 | Digit6 |  | Consec 0s | Consec 10s | Consec 20s | Consec 30s | Consec 40s |  | result
2 | 8 |  |  |  |  |  |  | 8 | 12 | 14 | 18
3 | 12 |  |  |  |  |  | 2 | 8 | 12 | 14 | 22
4 | 14 |  |  |  |  |  | 2 | 8 | 12 | 18 | 22
5 | 18 |  |  |  |  |  | 2 | 8 | 14 | 18 | 22
6 | 22 |  |  |  |  |  | 2 | 12 | 14 | 18 | 22
7 | 34 |  |  |  |  |  | 8 | 12 | 14 | 18 | 22
8 | 41 |  |  |  |  |  | 2 | 8 | 12 | 14 | 34
 |  |  |  |  |  |  | 2 | 8 | 12 | 18 | 34
 |  |  |  |  |  |  | 2 | 8 | 14 | 18 | 34
1 | 2 | 3 | 4 | 5 | 6 |  | 2 | 12 | 14 | 18 | 34
1 | 2 | 3 | 4 | 5 | 7 |  | 8 | 12 | 14 | 18 | 34
1 | 2 | 3 | 4 | 5 | 8 |  | 2 | 8 | 12 | 22 | 34
1 | 2 | 3 | 4 | 6 | 7 |  | 2 | 8 | 14 | 22 | 34
1 | 2 | 3 | 4 | 6 | 8 |  | 2 | 12 | 14 | 22 | 34
1 | 2 | 3 | 4 | 7 | 8 |  | 8 | 12 | 14 | 22 | 34
1 | 2 | 3 | 5 | 6 | 7 |  | 2 | 8 | 18 | 22 | 34
1 | 2 | 3 | 5 | 6 | 8 |  | 2 | 12 | 18 | 22 | 34
1 | 2 | 3 | 5 | 7 | 8 |  | 8 | 12 | 18 | 22 | 34
1 | 2 | 3 | 6 | 7 | 8 |  | 2 | 14 | 18 | 22 | 34
1 | 2 | 4 | 5 | 6 | 7 |  | 8 | 14 | 18 | 22 | 34
1 | 2 | 4 | 5 | 6 | 8 |  | 12 | 14 | 18 | 22 | 34
1 | 2 | 4 | 5 | 7 | 8
1 | 2 | 4 | 6 | 7 | 8
1 | 2 | 5 | 6 | 7 | 8
1 | 3 | 4 | 5 | 6 | 7
1 | 3 | 4 | 5 | 6 | 8
1 | 3 | 4 | 5 | 7 | 8
1 | 3 | 4 | 6 | 7 | 8
1 | 3 | 5 | 6 | 7 | 8
1 | 4 | 5 | 6 | 7 | 8
2 | 3 | 4 | 5 | 6 | 7
2 | 3 | 4 | 5 | 6 | 8
2 | 3 | 4 | 5 | 7 | 8
2 | 3 | 4 | 6 | 7 | 8
2 | 3 | 5 | 6 | 7 | 8
2 | 4 | 5 | 6 | 7 | 8
3 | 4 | 5 | 6 | 7 | 8
1 | 2 | 3 | 4 | 5
1 | 2 | 3 | 4 | 6
1 | 2 | 3 | 5 | 6
1 | 2 | 4 | 5 | 6
1 | 3 | 4 | 5 | 6
2 | 3 | 4 | 5 | 6
1 | 2 | 3 | 4 | 7
1 | 2 | 3 | 5 | 7
1 | 2 | 4 | 5 | 7
1 | 3 | 4 | 5 | 7
2 | 3 | 4 | 5 | 7
1 | 2 | 3 | 6 | 7
1 | 2 | 4 | 6 | 7
1 | 3 | 4 | 6 | 7
2 | 3 | 4 | 6 | 7
1 | 2 | 5 | 6 | 7
1 | 3 | 5 | 6 | 7
2 | 3 | 5 | 6 | 7
1 | 4 | 5 | 6 | 7
2 | 4 | 5 | 6 | 7
3 | 4 | 5 | 6 | 7
Spreadsheet: 23100d1212514085-vlookup-comparison-between-tabs-comparisonform
Sheet: Final

[NAME] (www.abc.com/bac.htm) |  |  | Good | 3 |  |  | [NAME] A With Tab B & C, and only displaying results from Tabs B & C, which are not on [NAME]
www.def.com/hij.htm (www.def.com/hij.htm) |  |  | Bad | 2 |  |  | all else leave blank
www.ghi.com/ghi.htm (www.ghi.com/ghi.htm) |  |  | Ok | 1
www.jkl.com (www.jkl.com) |  |  | Good | 3
www.mno.com/por.htm (www.mno.com/por.htm) |  |  | Bad | 2
[NAME] (www.qrs.com/stu.htm) |  |  | Ok | 1
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 16

Product* | November 8 | November 15 | November 22 | November 29 | December 6
Total Equity** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Equity Swaps | N/A | N/A | N/A | N/A | N/A
Portfolio Swaps | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaptions | N/A | N/A | N/A | N/A | N/A
[NAME] | N/A | N/A | N/A | N/A | N/A
TOTAL | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Gross notional amount outstanding, December 6 weekly snapshot, by product type, all tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***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].
Spreadsheet: 526109d1499124011-sumif-with-capital-purchases-10-in-column-b-if-gst-0-in-column-c-testing-capital-purchases
Sheet: Sheet1

Testing SUMIF with Capital Purchases >10 in Column B if GST >0 in column C
Formula 1: Display each "Capital Purchases" formula in column B under each section and then manually sum those sections (eg B15 + [NAME])
 |  |  |  |  | expecting 60
[NAME] (more dynamic): One "Capital Purchases" formula that sums rows B9:B38 but which excludes the Sub Totals and Capital Purchases rows (by filtering the word Sub and Capital???)
 |  |  |  |  | expecting 60
Widgets | Total ex GST | GST | Total inc GST
[NAME] | 5 | 0
[NAME] | 10 | 0
[NAME] | 5 | 0
[NAME] | 5 | 0
Sub Totals
Capital Purchases |  |  |  |  | expecting 0
Didgets | Total ex GST | GST | Total inc GST
[NAME] |  |  | 11
[NAME] | 10 | 0
[NAME] | 10 | 0
[NAME] |  |  | 11
[NAME] | 5 | 0
[NAME] |  |  | 11
Sub Totals
Capital Purchases |  |  |  |  | expecting 30
Gadgets | Total ex GST | GST | Total inc GST
[NAME] |  |  | 11
Sub Totals
Capital Purchases |  |  |  |  | expecting 10
Things | Total ex GST | GST | Total inc GST
[NAME] |  |  | 11
[NAME] |  |  | 11
[NAME] | 10 | 0
[NAME] | 10 | 0
Sub Totals
Capital Purchases |  |  |  |  | expecting 20
Spreadsheet: 60252d1260824154-conditional-formatting-to-find-non-unique-values-conditional2
Sheet: Sheet1

Product ID | Vendor ID | Vendor
J567 | A1 | [NAME]
V365 | A2 | Greg
M292 | A2 | Greg
G497 | A3 | [NAME]
G363 | A3 | [NAME]
V445 | A4 | Daryl
Spreadsheet: 179344d1347193882-generate-random-2alphabet-random-alphabets
Sheet: Sheet1

1 | a
 | b
 | c
 | d
 | e
 | f
 | g
 | h
 | i
 | j
 | k
 | l
 | m
 | n
 | o
 | p
 | q
 | r
 | s
 | t
 | u
 | v
 | w
 | x
 | y
 | z
Spreadsheet: 146978d1332445710-chart-display-axis-values-as-a-time-ever-0-30-minute-chart
Sheet: Sheet1

 |  |  |  | ATM Name | Fail time | fix time
 |  |  |  | UNIT # 1 | 09:25:00 | 10:01:00
 |  |  |  | UNIT # 2 | 10:01:00 | 10:37:00
 |  |  |  | UNIT # 3 | 10:37:00 | 11:13:00
 |  |  |  | UNIT # 4 | 11:13:00 | 11:49:00
 |  |  |  | UNIT # 5 | 11:49:00 | 12:25:00
 |  |  |  | UNIT # 6 | 12:25:00 | 13:01:00
 |  |  |  | UNIT # 7 | 13:01:00 | 13:37:00
 |  |  |  | UNIT # 8 | 13:37:00 | 14:13:00
 |  |  |  | UNIT # 9 | 14:13:00 | 14:49:00
 |  |  |  | UNIT # 10 | 14:49:00 | 15:25:00
 |  |  |  | UNIT # 11 | 15:25:00 | 16:01:00
 |  |  |  | UNIT # 12 | 16:01:00 | 16:37:00
 |  |  |  | UNIT # 13 | 16:37:00 | 17:13:00
 |  |  |  | UNIT # 14 | 17:13:00 | 17:49:00
 |  |  |  | UNIT # 15 | 17:49:00 | 18:25:00
 |  |  |  | UNIT # 16 | 18:25:00 | 19:01:00
Spreadsheet: 690406d1597083073-using-sum-and-count-function-in-a-pivot-table-summary-consolidated-sheet
Sheet: 05082020

 |  | JO/20/144 HRS | JO/20/144 OT | JO/20/193 HRS | JO/20/193 OT | JO/20/186 HRS | JO/20/186 OT | [NAME] | JO/20/204 OT | JO/20/188 HRS | JO/20/188 OT | JO/20/096 HRS | JO/20/096 OT | [NAME] | [NAME] | JO/20/197 HRS | JO/20/197 OT | JO/20/214 HRS | JO/20/214 OT | JO/20/120-B HRS | JO/20/120-B OT | [NAME] | [NAME] | ADMIN WORK HRS | ADMIN WORK OT | CPC HRS | CPC OT | Maintainance / Other works  HRS | Maintainance / Other works  OT
1 | MATHEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
2 | KESHVAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
3 | SIVADAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
4 | ANSARI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4
5 | RAGESH |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
6 | MUKUNDA | 8
7 | ABBASI | 8
8 | UPENDRA
9 | MARTIN
22 | SAMUEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 2
10 | FELIX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
11 | DIPAK | 8
12 | SATHYA
13 | RAJEEV |  |  | 8
16 | [NAME] |  |  | 8
 | [NAME] |  |  |  |  | 4 |  | 4
17 | FLORENCIO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 8
14 | VINOTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
15 | RAJA
19 | [NAME]
24 | SON | 8
 | MANSA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
25 | SIMHA
18 | MALIK |  |  |  |  | 2 |  | 4 |  | 2
20 | SIVA |  |  |  |  | 5 |  | 2 |  |  |  | 1
 | GEORGE |  |  |  |  | 1 |  | 4 |  | 2 |  |  |  | 1
21 | SUDHI |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 4
23 | RAVI |  |  |  |  |  |  |  |  | 8
 | HEMA |  |  |  |  |  |  |  |  | 8
35
COMMENTS :
Spreadsheet: 133786d1324612721-doesnt-seem-right-from-previous-year-p-and-l2010help
Sheet: Jan

Profit and Loss Statement |  | Tax Year: | 2010 | January
[NAME] |  | Monthly Summary | Total Income
 |  |  | Total Expense
Gross margin  [L/J]
Return on sales  [T/J] |  |  | Profit / (Loss)
Net Profit % Change from Prior Period
 | Prior Period | Current Period | Current Period as    % of Sales | % Change from Prior Period
Sales Revenue
Health Insurance
Medicare Advantage
Medicare Supplement
Life Insurance |  | 2400
Investment (Annuity)
Other
Total Sales Revenue  [J]
Cost of Sales
Specify
Total Cost of Sales  [K]
Gross Profit  [L=J-K]
Operating Expenses
Sales and Marketing
Advertising (Radio, TV, Print Media, etc)
Printing
Direct marketing
Seminar
Meals and Entertainment
Total Sales and Marketing Expenses  [M]
Research & Development
Licenses |  | 250
Education
Total Research & Development Expenses  [N]
General and Adminstrative
Rent
Payroll
Utilities
Telephone
Health Insurance
E&O Insurance
Software
Web Hosting and domains
Postage
Office Supplies |  | 160
Equipment
Repairs and maintenance
Other expenses (specify)
Auto (Tires, Fuel, Oil, Tolls, [NAME], etc)
Auto Mileage (IRS standard deduction; averaged) |  | 233
Total General & Adminstrative Expenses  [O]
Total Operating Expenses  [P=M+N+O]
Income from Operations  [Q=L-P]
Other Income (Bonuses) [R]
Taxes
Payroll Taxes
Property Taxes
Total Taxes  [S]
Net Profit  [T=Q+R-S]
Spreadsheet: kate_symes__18476__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 160476d1339090903-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: Claims

Announcement Number | Employee Announcements
Claims1
Claims2
Claims3
Claims4
Claims5
Announcement Number | Manager [NAME]
ClaimsManager1
ClaimsManager2
ClaimsManager3
Spreadsheet: 824187d1680359651-1-data-column-3-text-search-criterias-1-output-column-search-column-with-3-different-criteria
Sheet: Sheet1

Data | [NAME] | Expected Results 1 | Expected Results 2
This is ref az |  | [NAME] | [NAME]
This is ref by | by | by | by
This is ref cx | yb | cx | cx
This is ref dw | za | xc | dw
This is ref ev |  | yb | wd
This is ref fu |  | za | xc
This is ref gt |  |  | yb
This is ref hs |  |  | za
This is ref ir
This is ref jq
This is ref kp
This is ref lo
This is ref mn
This is ref nm
This is ref ol
This is ref pk
This is ref qj
This is ref ri
This is ref sh
This is ref tg
This is ref uf
This is ref ve
This is ref wd
This is ref xc
This is ref yb
This is ref za
Spreadsheet: 720070d1614001723-vlookup-copying-row-formula-not-values-excel_forum
Sheet: Sheet3

Item Code | Description | Height | Hinges |  | Runners |  | Screws |  | Total
 |  |  | Quantity | Price | Quantity | Price | Quantity | Price
F7/3/25
F7/3/45
F8/3/90 |  |  |  |  | 6
Spreadsheet: 715556d1611764839-extract-actual-data-from-pivot-table-but-have-cell-prepopulated-with-projections-miscitems-formula-test-file
Sheet: Raw Data

BFY | Fund | Org | Program | BOC | OC | Period | Fiscal Year | FM | Expense | Encumbrance | Period2
2021 | 11021 | 40CL002 | AE3AX | 2125 | 21 | 2 | 2021 | 2 | 73.57 | 0 | 02-November
2021 | 11021 | 40CL002 | AE3AX | 2145 | 21 | 2 | 2021 | 2 | 11352.08 | 0 | 02-November
2021 | 11021 | 40CL002 | AE3AX | 2145 | 21 | 3 | 2021 | 2 | 12000 | 0 | 03-December
2021 | 11021 | 40CL002 | AE3AX | 2502 | 25 | 3 | 2021 | 2 | 5000 | 0 | 03-December
2021 | 11021 | 40CL002 | AE3AX | 2502 | 21 | 3 | 2021 | 2 | 32000 | 0 | 04-January
Spreadsheet: f55d3fd6-c66f-4f9f-b9ef-0ce58c10db3c
Sheet: LOF

a) MEI loci  (main text Table 1b except for the p-value)
. | Gene | Exon | UTR | CDS
ALU | 1438 | 39 | 32 | 2
L1 | 249 | 7 | 4 | 0
SVA | 31 | 1 | 0 | 1
total | 1718 | 47 | 36 | 3
expected | 2020 | 338 | 105 | 137
supression factor | 1.2 | 7.2 | 2.9 | 45.7
log(p-val) | -11.5 | -87.3 | -14.2 | -53.9
b) SNP loci (based on 1000G low coverage pilot release VCF files)
. | lowcov | CDS | STOPLOSS
SNP | 14894361 | 117523 | 71
expected | - | 459007 | 2995
supression factor | - | 3.9 | 42.2
Notes:
Suppression factor is the ratio of expected insertions to observed
Spreadsheet: 0b3bde31-ac96-4fe8-84b8-3b2d3246b504
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2010-08-01 00:00:00 | 482 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2010-08-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2010-08-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2010-08-01 00:00:00 | 482 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2010-08-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: Oasis

POI  8516
 | Scheduled | Measured | Imbal
1 | 106094 | 103793
2 | 97525 | 95166
3 | 97475 | 95009
4 | 97525 | 96856
5 | 102135 | 101639
6 | 82735 | 82655
7 | 94635 | 94027
8 | 134131 | 136018
9 | 71735 | 72648
10 | 71735 | 86862
11 | 71685 | 71511
12 | 84166 | 84634
13 | 72703 | 73788
14 | 98337 | 98796
15 | 80637 | 80688
16 | 121128 | 120967
17 | 134798 | 134333
18 | 97710 | 97329
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  | 1307
 | 2001-06-18 00:00:00
Spreadsheet: 215412d1361373081-advanced-formula-help-cannot-fill-a-table-from-many-other-tables-per-certain-criteria-workbooksample
Sheet: 9

Date Scheduled | Time Scheduled | WO Number
2/21/2013 | 9:0 | 15562
2/21/2013 | 9:0 | 15572
2/21/2013 | 9:0 | 15573
2/21/2013 | 9:0 | 15574
2/21/2013 | 9:0 | 15575
2/21/2013 | 9:0 | 15576
2/21/2013 | 9:0 | 15577
2/21/2013 | 9:0 | 15578
2/21/2013 | 9:0 | 15579
2/21/2013 | 9:0 | 15580
2/21/2013 | 9:0 | 15581
2/21/2013 | 9:0 | 15582