tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 701314d1603706035-subtract-1-from-last-5-records-manualexample
Sheet: Manual -what i would like

A | B
0 | 0
0 | -1
0 | -1
0 | -1
0 | -2
-1 | -2
0 | -1
0 | -1
-1 | -1
0 | 0
0 | 0
Spreadsheet: 850627d1701018206-find-all-the-rows-in-a-sheet-that-have-a-number-from-a-list-in-a-different-excel-sheet-invoice-list
Sheet: Sheet1

100006 |  | 688D8-[PHONE] | 100006 | 12-18-2022 | 12-18-2022 | 02-27-2023 | 688D8-[PHONE]
100039 | 5223 | 69D49-[PHONE] | 100039 | 01-23-2023 | 01-24-2023 | 03-26-2023 | 69D49-[PHONE]
100040 | 5215 | 69C91-[PHONE] | 100040 | 01-23-2023 | 01-24-2023 | 05-23-2023 | 69C91-[PHONE]
100041 | 5224 | 69D4D-[PHONE] | 100041 | 01-23-2023 | 01-24-2023 | 01-24-2023 | 69D4D-[PHONE]
100042 | 5225 | 69D51-[PHONE] | 100042 | 01-23-2023 | 01-24-2023 | 05-09-2023 | 69D51-[PHONE]
100043 | 5216 | 69C95-[PHONE] | 100043 | 01-23-2023 | 01-24-2023 | 01-26-2023 | 69C95-[PHONE]
100044 | 5217 | 69C99-[PHONE] | 100044 | 01-23-2023 | 01-24-2023 | 02-23-2023 | 69C99-[PHONE]
100045 | 4839 | 6A6EC-[PHONE] | 100045 | 02-01-2023 | 02-05-2023 | 04-17-2023 | 6A6EC-[PHONE]
Spreadsheet: 329129d1404210983-filling-a-cell-with-yes-based-on-data-from-another-sheet-excelsheet
Sheet: Contract

CustomerNumber | ProductSubType
0
1 | Product A
1 | Product C
2 | Product C
3 | Product C
4 | Product B
6 | Product A
6 | Product B
6 | Product C
7 | Product B
7 | Product C
8 | Product B
8 | Product C
8 | Product A
11 | Product B
11 | Product C
11 | Product A
12 | Product B
12 | Product C
12 | Product A
16 | Product B
16 | Product C
18 | Product B
19 | Product C
19 | Product A
20 | Product C
20 | Product A
26 | Product C
26 | Product A
27 | Product C
27 | Product A
27 | Product B
28 | Product B
29 | Product B
30 | Product B
31 | Product C
31 | Product B
31 | Product A
32 | Product A
32 | Product B
33 | Product B
34 | Product B
36 | Product C
37 | Product C
38 | Product B
39 | Product B
41 | Product B
42 | Product C
42 | Product B
43 | Product A
Spreadsheet: mike_carson__27517__BrokerQuote(SouthEast)
Sheet: Sheet1

ONPEAK |  |  |  |  |  |  |  | [NAME]
PRICE | SOUTHEAST |  |  |  |  |  |  | PRICE | SOUTHEAST
 | SOCO |  | Entergy |  |  |  |  |  | SOCO |  | Entergy
 | Bid | Offer | Bid | Offer |  |  |  |  | Bid | Offer | Bid | Offer
2001-11-29 00:00:00 |  |  |  |  |  |  |  | 2001-11-29 00:00:00
2001-11-30 00:00:00 |  |  |  |  |  |  |  | 2001-11-30 00:00:00
2001-12-01 00:00:00 |  |  |  |  |  |  |  | 2001-12-01 00:00:00
W 02 |  |  |  |  |  |  |  | W 02
M/A 02 |  |  |  |  |  |  |  | M/A 02
2002-05-01 00:00:00 |  |  |  |  |  |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 |  |  |  |  |  |  |  | 2002-06-01 00:00:00
Sum 02 |  |  |  |  |  |  |  | Sum 02
2002-09-01 00:00:00 |  |  |  |  |  |  |  | 2002-09-01 00:00:00
Q4 02 |  |  |  |  |  |  |  | Q4 02
CAL-02 |  |  |  |  |  |  |  | CAL-02
W 03 |  |  |  |  |  |  |  | W 03
M/A 03 |  |  |  |  |  |  |  | M/A 03
2003-05-01 00:00:00 |  |  |  |  |  |  |  | 2003-05-01 00:00:00
2003-06-01 00:00:00 |  |  |  |  |  |  |  | 2003-06-01 00:00:00
Sum 03 |  |  |  |  |  |  |  | Sum 03
2003-09-01 00:00:00 |  |  |  |  |  |  |  | 2003-09-01 00:00:00
Q4 03 |  |  |  |  |  |  |  | Q4 03
CAL-03 |  |  |  |  |  |  |  | CAL-03
[NAME] |  |  |  |  |  |  |  | [NAME]
Cal-05 |  |  |  |  |  |  |  | Cal-05
Cal-06 |  |  |  |  |  |  |  | Cal-06
Cal-07-10 |  |  |  |  |  |  |  | Cal-07-10
Spreadsheet: 191613d1352155270-trying-to-take-raw-data-on-1-sheet-and-make-a-nice-formatted-table-on-another-excelforumhelp
Sheet: Formatted Table

date | head | headid | item | unique | dealer | dealernumber | dealeremail | name | Title | company | street | city | state | zip | country | email | tel | productorservice | comments
2012-11-02 16:57:00 | SCRAP YARD MACHINERY & EQUIPMENT: SHREDDERS | 16622 | Mercodor GmbH #ZM44 Hard [NAME], new shear shredder, 7 HP motor | 750284 | [NAME] Machinery Corp | 298453 | [EMAIL] | [NAME] |  | R2 Corporation | 1201 [NAME] | Pflugerville | TX | 78726 | United States | [EMAIL] | [PHONE] | HARD DRIVES | looking for a used harddrive Shredder.
2012-10-29 20:15:00 | SCRAP YARD MACHINERY & EQUIPMENT: SHEARS, SCRAP, HYDRAULIC | 16618 | 500 Ton, Sierra #500-T, shear/logger/baler, #25832 | 750283 | [NAME] Machinery Corp | 298453 | [EMAIL] | [NAME] | manager | r & r metal company | p.o. box 471 | georgetown | sc | 29440 | United States | [EMAIL] | 8435465598 | 8435278031 | metal recycling | Please send inforamtion
2012-10-27 00:51:00 | SCRAP YARD MACHINERY & EQUIPMENT: SHREDDERS | 16622 | Vecoplan-Retech #RG42 single shaft shredder, used | 759100 | [NAME] Machinery Corp | 298453 | [EMAIL] | [NAME] | DIRECTOR | PLASTICOS VHP | [NAME], COL. [NAME] PEDRO XALPA | AZCAPOTZALCO | D.F. | 2719 | MEXICO | [EMAIL] | 5553588381 | 5526122235 | RECICLADO | HOLA ESTOY INTERESADO POR ESTA MAQUINA POR FAVOR ENVIEME MAS FOTOS Y EL PRECIO POR FAVOR | metal recycling
Spreadsheet: 824405d1680549387-count-cells-which-match-a-single-criterion-across-an-array-of-cells-weekend-counting
Sheet: Sheet1

Person | Total Weekend Days | 2023-02-01 00:00:00 | 2023-02-02 00:00:00 | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | 2023-02-05 00:00:00 | 2023-02-06 00:00:00 | 2023-02-07 00:00:00 | 2023-02-08 00:00:00 | 2023-02-09 00:00:00 | 2023-02-10 00:00:00 | 2023-02-11 00:00:00 | 2023-02-12 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-15 00:00:00 | 2023-02-16 00:00:00 | 2023-02-17 00:00:00 | 2023-02-18 00:00:00 | 2023-02-19 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-22 00:00:00 | 2023-02-23 00:00:00 | 2023-02-24 00:00:00 | 2023-02-25 00:00:00 | 2023-02-26 00:00:00 | 2023-02-27 00:00:00
Person 1 |  |  |  |  | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD
Person 2 |  |  | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD
Person 3 |  |  |  |  |  |  |  |  |  |  |  |  | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD | OD
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
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 November 23, 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].
Spreadsheet: benjamin_rogers__1173__Wilton_New - GE 7EA
Sheet: Depreciation

Depreciation and Property Taxes
 |  |  | 1
US FEDERAL TAX DEPRECIATION & AMORTIZATION
 | Years
Plant and Equipment - MACRS | 15
Start-up Costs - SL | 5
Debt Iss & Loan Fees - SL
Tax Depr - Plant and Equipment
Amort - Start-up Costs
Amort - Debt Iss & Loan Fees
EI O&M Mobilization | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Annual Depr & Amort
STATE TAX DEPRECIATION & AMORTIZATION
 | Years
Plant and Equipment - MACRS
Start-up Costs - SL | 5
Debt Iss & Loan Fees - SL
Tax Depr - Plant and Equipment
Amort - Start-up Costs
Amort - Debt Iss & Loan Fees
EI O&M Mobilization |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Annual Depr & Amort
BOOK DEPRECIATION & AMORTIZATION
 | Years | Residual | 1
Plant and Equipment - SL | 30
Start-up Costs - SL | 5
Debt Iss & Loan Fees - SL
Book Depr - Plant and Equipment
Amort - Start-up Costs
Amort - Debt Iss & Loan Fees
EI O&M Mobilization |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Beginning Book Value
Ending Book Value of Assets
PROPERTY TAX CALCULATION | Years |  | 1
Assessable Value of Hard Assets |  |  | 1 | 1 | 1 | 1 | 1 | 0.88 | 0.88 | 0.88 | 0.88 | 0.76 | 0.76 | 0.76 | 0.76 | 0.64 | 0.64 | 0.64 | 0.64 | 0.52 | 0.52 | 0.52 | 0.52 | 1 | 1 | 1 | 1
Annual Depreciated Assessable Value
Mileage Rate (Increase 1.5% / Year)
Annual Tax (with abatement)
Annual City Tax (no city taxes) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Property Tax (with Abatement)
15 Year MACRS Table
Half-Year Convention
Year | Depr. %
1 | 0.05
2 | 0.095
3 | 0.0855
4 | 0.077
5 | 0.0693
6 | 0.0623
7 | 0.059
8 | 0.0591
9 | 0.059
10 | 0.0591
11 | 0.059
12 | 0.0591
13 | 0.059
14 | 0.0591
15 | 0.059
16 | 0.0295
20 Year MACRS Table
Half-Year Convention
Year | Depr. %
1 | 0.0375
2 | 0.07219
3 | 0.06677
4 | 0.06177
5 | 0.05713
6 | 0.05285
7 | 0.04888
8 | 0.04522
9 | 0.04462
10 | 0.04461
11 | 0.04462
12 | 0.04461
13 | 0.04462
14 | 0.04461
15 | 0.04462
16 | 0.04461
17 | 0.04462
18 | 0.04461
19 | 0.04462
20 | 0.04461
21 | 0.0225
Spreadsheet: 762008d1641346598-calculated-field-on-time-field-dax-measure-to-count-based-on-condition-warecoth-
Sheet: Sheet1

DURACION
00:22:00
00:22:00 |  |  | DURACION | Count
00:40:00 |  |  | 00:20:00 | 7
00:23:00 |  |  | 00:21:00 | 7
00:28:00 |  |  | 00:26:00 | 7
00:29:00 |  |  | 00:28:00 | 7
00:26:00 |  |  | 00:30:00 | 7
00:22:00 |  |  | 00:31:00 | 7
00:40:00 |  |  | 00:32:00 | 7
00:40:00 |  |  | 00:33:00 | 7
00:30:00 |  |  | 00:36:00 | 7
00:24:00 |  |  | 00:40:00 | 7
00:26:00 |  |  | Grand Total | 7
00:40:00
00:31:00
00:40:00
Spreadsheet: 540706d1506902344-count-unique-values-with-multiple-criteria-ap-test-3
Sheet: Sheet1

Date | Account | Invoice | Name
2017-01-07 00:00:00 | Acct 123 | Inv 001 | Name 1 |  | Date | Name | Distinct Count of Account | Distinct Count of Invoice |  | Name | Date | Account | Invoice
2017-01-07 00:00:00 | Acct 123 | Inv 002 | Name 1 |  | 2017-01-07 00:00:00 | Name 1 | 2 | 12 |  | Name 1 | 2017-01-07 00:00:00
2017-01-07 00:00:00 | Acct 123 | Inv 003 | Name 1 |  |  | Name 2 | 1 | 4 |  | Name 2 | 2017-01-07 00:00:00
2017-01-07 00:00:00 | Acct 123 | Inv 004 | Name 1 |  |  | Name 3 | 1 | 4 |  | Name 3 | 2017-01-07 00:00:00
2017-01-07 00:00:00 | Acct 123 | Inv 005 | Name 2 |  | 1/7/2017 Total |  | 3 | 12 |  | Name 4 | 2017-01-07 00:00:00
2017-01-07 00:00:00 | Acct 123 | Inv 006 | Name 2 |  | 2017-01-08 00:00:00 | Name 2 | 2 | 6 |  | Name 1 | 2017-01-08 00:00:00
2017-01-07 00:00:00 | Acct 123 | Inv 007 | Name 2 |  |  | Name 4 | 2 | 7 |  | Name 2 | 2017-01-08 00:00:00
2017-01-07 00:00:00 | Acct 123 | Inv 008 | Name 2 |  | 1/8/2017 Total |  | 4 | 7 |  | Name 3 | 2017-01-08 00:00:00
2017-01-07 00:00:00 | Acct 124 | Inv 001 | Name 1 |  |  |  |  |  |  | Name 4 | 2017-01-08 00:00:00
2017-01-07 00:00:00 | Acct 124 | Inv 002 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 003 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 004 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 005 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 006 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 007 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 008 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 009 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 010 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 011 | Name 1
2017-01-07 00:00:00 | Acct 124 | Inv 012 | Name 1
2017-01-07 00:00:00 | Acct 125 | Inv 001 | Name 3
2017-01-07 00:00:00 | Acct 125 | Inv 002 | Name 3
2017-01-07 00:00:00 | Acct 125 | Inv 003 | Name 3
2017-01-07 00:00:00 | Acct 125 | Inv 004 | Name 3
2017-01-08 00:00:00 | Acct 126 | Inv 001 | Name 4
2017-01-08 00:00:00 | Acct 126 | Inv 002 | Name 4
2017-01-08 00:00:00 | Acct 126 | Inv 003 | Name 4
2017-01-08 00:00:00 | Acct 126 | Inv 004 | Name 4
2017-01-08 00:00:00 | Acct 126 | Inv 005 | Name 4
2017-01-08 00:00:00 | Acct 127 | Inv 001 | Name 4
2017-01-08 00:00:00 | Acct 127 | Inv 002 | Name 4
2017-01-08 00:00:00 | Acct 127 | Inv 003 | Name 4
2017-01-08 00:00:00 | Acct 127 | Inv 004 | Name 4
2017-01-08 00:00:00 | Acct 127 | Inv 005 | Name 4
2017-01-08 00:00:00 | Acct 127 | Inv 006 | Name 4
2017-01-08 00:00:00 | Acct 127 | Inv 007 | Name 4
2017-01-08 00:00:00 | Acct 128 | Inv 001 | Name 2
2017-01-08 00:00:00 | Acct 128 | Inv 002 | Name 2
2017-01-08 00:00:00 | Acct 128 | Inv 003 | Name 2
2017-01-08 00:00:00 | Acct 128 | Inv 004 | Name 2
2017-01-08 00:00:00 | Acct 128 | Inv 005 | Name 2
2017-01-08 00:00:00 | Acct 128 | Inv 006 | Name 2
2017-01-08 00:00:00 | Acct 129 | Inv 001 | Name 2
2017-01-08 00:00:00 | Acct 129 | Inv 002 | Name 2
Spreadsheet: 265280d1379162718-generation-of-random-numbers-from-a-lognormal-distribution-isitlognormal
Sheet: Sheet1

 | 0 | 0.5
Spreadsheet: 677849d1589553938-group-and-transpose-data-ors-ancestor-id-with-rating-may-15-2020-1-
Sheet: ORS Ancestor ID with Rating

client_id | rev_timein | answer
1040 | 2020-04-08 08:59:00 | 30
1083 | 2020-02-26 10:30:00 | 20 |  | Sum of answer | rev_timein
1083 | 2020-03-04 10:30:00 | 20 |  | client_id | 21-Feb | 25-Feb | 26-Feb | 2-Mar | [NAME] | 5-Mar | 6-Mar | 9-Mar | 11-Mar | 13-Mar | 20-Mar | 25-Mar | 27-Mar | 30-Mar | 31-Mar | 2-Apr | 8-Apr | 14-Apr | 16-Apr | 21-Apr | 22-Apr | 24-Apr | 27-Apr | 29-Apr | 30-Apr | 8-May | 11-May | 12-May
1083 | 2020-03-30 14:00:00 | 19 |  | 1040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
1083 | 2020-04-27 14:00:00 | 21 |  | 1083 |  |  | 20 |  | 20 |  |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  | 21 |  |  |  | 29
1083 | 2020-05-11 13:00:00 | 29 |  | 1089 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  | 28
1089 | 2020-03-30 15:00:00 | 28 |  | 1145 |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  | 14 |  |  |  |  | 15
1089 | 2020-04-30 14:00:00 | 28 |  | 1170 |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  | 32
1145 | 2020-03-11 14:35:00 | 14 |  | 1192 |  |  |  |  |  |  | 31 |  |  |  |  | 35 |  |  |  |  |  |  | 25
1145 | 2020-04-08 14:02:00 | 14 |  | 1235 |  |  |  |  |  |  |  |  |  | 20
1145 | 2020-04-24 13:05:00 | 15 |  | 1244 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  | 17
1170 | 2020-03-27 09:50:00 | 30 |  | 1267 | 20
1170 | 2020-04-22 13:12:00 | 32 |  | 1308 |  |  |  |  |  |  |  |  |  |  | 33
1192 | 2020-03-25 11:00:00 | 35 |  | 1311 |  | 27 |  |  |  | 30 |  | 31 |  | 32 |  |  |  |  |  | 23 |  |  |  |  | 22 |  |  | 24
1192 | 2020-03-06 12:00:00 | 31 |  | 1330 | 34 |  |  | 28 |  |  |  |  |  | 30
1192 | 2020-04-16 12:00:00 | 25 |  | 1339 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
1235 | 2020-03-13 10:01:00 | 20 |  | 1361 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  | 20 |  |  |  |  | 15 |  |  |  |  | 19
1244 | 2020-04-21 13:00:00 | 23
1244 | 2020-05-08 08:30:00 | 17
1267 | 2020-02-21 15:00:00 | 20
1308 | 2020-03-20 15:04:00 | 33
1311 | 2020-02-25 11:15:00 | 27
1311 | 2020-03-05 12:00:00 | 30
1311 | 2020-03-09 14:00:00 | 31
1311 | 2020-03-13 13:00:00 | 32
1311 | 2020-04-02 16:30:00 | 23
1311 | 2020-04-22 14:30:00 | 22
1311 | 2020-04-29 14:30:00 | 24
1330 | 2020-02-21 11:48:00 | 34
1330 | 2020-03-02 11:32:00 | 28
1330 | 2020-03-13 12:26:00 | 30
1339 | 2020-03-30 10:08:00 | 40
1361 | 2020-03-31 14:00:00 | 25
1361 | 2020-04-14 09:30:00 | 20
1361 | 2020-04-27 09:30:00 | 15
1361 | 2020-05-12 09:30:00 | 19
Spreadsheet: 61884d1262793446-finding-subtotal-row-when-it-changes-subtotal-example
Sheet: Begin

A | B | Customer # | Customer Name | Customer Type | Sales person | Invoice# | Col H | Col I | Col J | Col K | Col L | Col M | Col N | Col O | Col P | Col Q | Col R | Col S | Col T | Col U | Col V | Col W | Col X | Col Y | Col Z | Col AA | Col AB
1 | 2 | 123 | Customer 1 | A | 111 | 1111111 | 9 | 1210 | 1036650 | 1 | 1 | A | 0 | 1 | 1490 | 0.4221503 | 1400 |  |  | CD | 9 | 226
1 | 2 | 456 | Customer 2 | A | 111 | 1111112 | 9 | 1210 | 1036650 | 1 | 10 | B | 41.5 | 2 | 1490 | 0.4221503 | 1465 |  |  | CD | 9 | 226
2 | 3 | 789 | Customer 3 | A | 222 | 1111113 | 9 | 1214 | 1043485 | 0 | 6 | C | 118 | 1 | 118 | 0.5710435 | 50.62 |  |  | CD | 9 | 415
2 | 3 | 789 | Customer 3 | A | 222 | 1111114 | 9 | 1229 | 1093668 | 0 | 128 | D | 1333 | 1 | 1333 | 0.4669069 | 710.61 |  |  | CD | 9 | 1229
2 | 3 | 789 | Customer 3 | A | 222 | 1111115 | 9 | 1229 | 1093668 | 0 | 188 | E | 2739 | 1 | 2739 | 0.4669069 | 1460.14 |  |  | CD | 9 | 1229
2 | 3 | 654 | Customer 4 | A | 222 | 1111116 | 9 | 1229 | 1093668 | 0 | 189 | F | 1379 | 1 | 1379 | 0.4669069 | 735.14 |  |  | CD | 9 | 1229
2 | 3 | 654 | Customer 4 | A | 222 | 1111117 | 9 | 1229 | 1093668 | 0 | 190 | G | 2091 | 1 | 2091 | 0.4669069 | 1114.7 |  |  | CD | 9 | 1229
2 | 3 | 654 | Customer 4 | A | 222 | 1111118 | 9 | 1229 | 1093668 | 0 | 191 | H | 110 | 1 | 110 | 0.4669069 | 58.64 |  |  | CD | 9 | 1229
2 | 4 | 987 | Customer 5 | A | 222 | 1111119 | 9 | 1229 | 1093668 | 0 | 192 | I | 1024 | 1 | 1024 | 0.4669069 | 545.89 |  |  | CD | 9 | 1229
2 | 4 | 543 | Customer 6 | A | 333 | 1111120 | 9 | 1201 | 1086452 | 0 | 1 | J | 776.25 | 1 | 1333 | 0 | 1100 |  |  | CD | 9 | 1030
2 | 4 | 543 | Customer 6 | A | 333 | 1111121 | 9 | 1216 | 1092573 | 0 | 1 | K | 776.25 | -1 | 2739 | 0 | 2300 |  |  | CD | 9 | 1216
1 | 5 | 876 | Customer 7 | A | 444 | 1111122 | 9 | 1222 | 1093218 | 0 | 1 | L | 1766 | -1 | 1379 | 0 | 1250 |  |  | CD | 9 | 1222
1 | 5 | 678 | Customer 8 | A | 444 | 1111123 | 9 | 1222 | 1093218 | 0 | 2 | M | 1766 | 1 | 2091 | 0.9999999 | 1820 |  |  | CD | 9 | 1222
Spreadsheet: 34d3f5b7-92f6-4445-9240-4a33d4d51f08
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
 | 5671.0 Lending Finance, Australia
 | TABLE 6. COMMERCIAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($000)
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
Construction finance ; |  |  | Original | A2413488R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Purchase of real property ; |  |  | Original | A2413489T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Wholesale finance ; |  |  | Original | A2413490A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Purchase of plant and equipment ; |  |  | Original | A2413491C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413492F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413493J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413494K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commitments not drawn at end of month ; |  |  | Original | A2413495L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 139614d1328337304-excel-2010-bi-weekly-paycheck-tracker-income-calculator
Sheet: Oct 2012

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Made with [NAME]: | Calendar Maker
 | ◄ September |  |  |  | ~ October 2012 ~ |  |  |  |  |  |  |  | November ► |  |  |  |  |  |  |  |  |  |  |  | 2011 Calendar
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  |  |  |  |  |  |  |  | 2012 Calendar
 |  |  | 2012-10-01 00:00:00 |  | 2012-10-02 00:00:00 |  | 2012-10-03 00:00:00 |  | 2012-10-04 00:00:00 |  | 2012-10-05 00:00:00 |  | 2012-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2012-10-07 00:00:00 |  | 2012-10-08 00:00:00 |  | 2012-10-09 00:00:00 |  | 2012-10-10 00:00:00 |  | 2012-10-11 00:00:00 |  | 2012-10-12 00:00:00 |  | 2012-10-13 00:00:00
 | 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
 | 2012-10-21 00:00:00 |  | 2012-10-22 00:00:00 |  | 2012-10-23 00:00:00 |  | 2012-10-24 00:00:00 |  | 2012-10-25 00:00:00 |  | 2012-10-26 00:00:00 |  | 2012-10-27 00:00:00
 | 2012-10-28 00:00:00 |  | 2012-10-29 00:00:00 |  | 2012-10-30 00:00:00 |  | 2012-10-31 00:00:00 |  | Notes:
Spreadsheet: 732693d1621171985-comparing-unsorted-lists-across-multiple-sheets-fortune-500-problem-example-2
Sheet: 2010

Rank | Company | Revenues ($ millions) | Profits ($ millions) | Ticker symbol
1 | Wal-Mart Stores | 408214 | 14335
2 | #[NAME]! | 284650 | 19280
3 | #[NAME]! | 163527 | 10483
4 | #[NAME]! | 156779 | 11025
5 | #[NAME]! | 150450 | 6276
6 | #[NAME]! | 139515 | 4858
7 | AT&T | 123018 | 12535
8 | #[NAME]! | 118308 | 2717
9 | J.P. Morgan Chase & Co. | 115632 | 11728
10 | Hewlett-Packard | 114552 | 7660
11 | [NAME] | 112493 | 8055
12 | Citigroup | 108785 | -1606
13 | Verizon Communications | 107808 | 3651
14 | #[NAME]! | 106632 | 823
15 | #[NAME]! | 104589 | N.A.
16 | #[NAME]! | 103189 | -10949
17 | #[NAME]! | 99612.9 | 1151.6
18 | CVS Caremark | 98729 | 3696
19 | #[NAME]! | 98636 | 12275
20 | #[NAME]! | 95758 | 13425
Spreadsheet: 81809d1281969398-data-validation-list-with-condition-data_validation
Sheet: Sheet1

 |  |  |  |  |  | List1 | List2
 | AS | Standard Chartered |  |  |  | AF |  |  |  |  |  | AF
 | AS | Tata |  |  |  |  |  |  |  |  |  | AS
 | AS | TNT |  |  |  |  |  |  |  |  |  | DE
 | EU | Toyota |  |  |  |  |  |  |  |  |  | EU
 | AS | UBS
 | AS | Unilever
 | EU | UPS
 | AS | Wipro
 | AS | World Bank
 | DE | A.T. Kearney
 | DE | ABB
 | EU | Accenture
 | DE | adidas Group
 | DE | [NAME]
 | DE | Allianz
 | DE | Arthur D. Little
 | DE | Audi
 | DE | Auswärtiges Amt
 | DE | AXA
 | AF | Bain & Company
 | AF | BASF
 | AF | Bayer
 | AF | BayernLB
 | DE | BCG
 | DE | [NAME]
 | AS | Bertelsmann
 | DE | [NAME]
 | AS | BKW
 | DE | BMW
 | DE | Boehringer Ingelheim
 | DE | Booz & Co.
Spreadsheet: 602190d1544814112-simple-conditional-formatting-wont-highlight-all-cells-conditional-formatting
Sheet: Sheet1

With Conditional Formatting |  |  |  | My Goal |  |  | Test Example
FILE #1 | SERIAL #1 |  |  | FILE #1 | SERIAL #1 |  | FILE #1 | SERIAL #1
[NAME] |  |  |  | [NAME] |  |  | [NAME]
0 |  |  |  | 0 |  |  | 0.323 | x
 |  |  |  |  |  |  | x | x
FILE #2 | SERIAL #2 |  |  | FILE #2 | SERIAL #2 |  | x | x
TITLE2 |  |  |  | TITLE2
0.9990257480862909 |  |  |  | 0.9990257480862909
FILE #3 | SERIAL #3 |  |  | FILE #3 | SERIAL #3
TITLE3 |  |  |  | TITLE3
0 |  |  |  | 0
FILE #4 | SERIAL #4 |  |  | FILE #4 | SERIAL #4
TITLE4 |  |  |  | TITLE4
0.9240655121072017 | X |  |  | 0.9240655121072017
FILE #5 | SERIAL #5 |  |  | FILE #5 | SERIAL #5
TITLE5 |  |  |  | TITLE5
0 | X |  |  | 0