tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 690989d1597408160-countifs-with-2-and-criteria-and-3-or-criteria-double-counting-multiple-criteria-countifs-example
Sheet: Sheet1

 |  | Date | 2020-08-01 00:00:00 |  |  | 2020-08-02 00:00:00 |  |  | 2020-08-03 00:00:00
Client No. | Client type | Area | Phone call | Meeting in person | Training session | Phone call | Meeting in person | Training session | Phone call | Meeting in person | Training session
1 | Space use | 1 | Yes | 1 | 1 | No | 1 | 0 | No | 0 | 0
2 | Space use | 2 | No | 4 | 1 | Yes | 2 | 1 | No | 0 | 0
3 | Respite | 2 | Yes | 2 | 1 | Yes | 1 | 2 | Yes | 0 | 0
4 | Full time | 2 | Yes | 2 | 1 | Yes | 0 | 1 | Yes | 0 | 0
5 | Space use | 1 | No | 1 | 1 | No | 1 | 1 | Yes | 0 | 0
6 | Full time | 1 | Yes | 1 | 1 | No | 2 | 1 | Yes | 0 | 0
7 | Respite | 2 | Yes | 0 | 1 | No | 1 | 2 | Yes | 0 | 0
8 | Respite | 1 | No | 1 | 1 | Yes | 1 | 1 | Yes | 0 | 0
9 | Space use | 1 | Yes | 0 | 0 | Yes | 1 | 1 | Yes | 0 | 0
10 | Space use | 2 | No | 0 | 0 | Yes | 1 | 2 | Yes | 0 | 0
Counts | 2020-08-01 00:00:00 |  | 2020-08-02 00:00:00 |  | 2020-08-03 00:00:00
 | Area 1 | Area 2 | Area 1 | Area 2 | Area 1 | Area 2
Space use
Respite
Comments
Cell O3 - Answer I want is 2. Only clients 1 & 9 have received contact & contain Space use AND Area 1.
Cell O4 - Answer I want is 1. Only client 8 has received contact & contains Respite AND Area 1.
Cell P3 - Answer I want is 1. Only client 2 has received catanct & contains Space use AND Area 2.
Cell P4 - Answer I want is 2. Only clients 3 & 7 have received contact & contain respite AND Area 2.
Spreadsheet: 165550d1341262645-timesheet-with-multiple-jobs-how-to-display-time-per-job-timesheet
Sheet: Sheet1

Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours |  |  | Job# | IN | OUT | Time | Hours
 |  |  |  |  | Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  |  | Friday
 |  |  |  |  | 2012-07-02 00:00:00 |  |  |  |  |  |  | 2012-07-03 00:00:00 |  |  |  |  |  |  | 2012-07-04 00:00:00 |  |  |  |  |  |  | 2012-07-05 00:00:00 |  |  |  |  |  |  | 2012-07-06 00:00:00
A | 08:00:00 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly | Totals
B | 09:00:00 | 10:00:00
A | 10:00:00 | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday :
C | 10:30:00 | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesady :
B | 11:00:00 | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday :
A | 13:00:00 | 16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday :
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday | 08:00:00 | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 16:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Still Need :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | just some math:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5x5= | 37.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37.5-5= | 32.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5/4=
 |  |  | Total Hours: |  |  |  |  |  |  | Total Hours: |  |  |  |  |  |  | Total Hours: |  |  |  |  |  |  | Total Hours: |  |  |  |  |  |  | Total Hours:
JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job |  | JOB# | Session 1 | Session 2 | Session 3 | Session 4 | Hours per Job
A | 1 | 0.5 | 3.5
B | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | Holdiay | 4 | 3.5
C | 0.5
 |  |  |  | Total Hours: |  |  |  |  |  |  | Total Hours: |  |  |  |  |  |  | Total Hours: |  |  |  |  |  |  | Total Hours: |  |  |  |  |  |  | Total Hours:
Spreadsheet: 717136d1612502129-separation-of-unsold-products-from-all-duplicate-products-kkk
Sheet: Sheet1

Row | Product
1 | A |  | Result
2 | D |  | Unsalled |  | Salled |  | Please, without VBA & Helper column
3 | A |  |  |  | A
4 | E |  |  |  | H
5 | H |  |  |  | R
6 | D
7 | F
8 | R
9 | K
10 | A
11 | M
12 | F
Spreadsheet: 128639d1321139886-unhide-column-s-and-p-expanded-pivot
Sheet: Daily

TC | (PIVOT - BC) + PIVOT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | VAH | VaL | VA Range | mean CPR | std CPR | mean +1 | mean     -1/2
Pivot | (H+L+C)/3 | Date | H | L | C | Range | Close | Open #F=2 | PIVOT | BC | TC | Prange | R1 | R2 | R3 | R4 | S1 | S2 | S3 | [NAME]
BC | (H+L)/2 | 2011-10-27 00:00:00 | 1289.25 | 1237.5 | 1282.5
 |  | 2011-10-28 00:00:00 | 1284.25 | 1272.75 | 1281
R4 | R3 + (R2-R1) | 2011-10-31 00:00:00 | 1280.75 | 1245.25 | 1249.25
R3 | R1+(H-L) | 2011-11-01 00:00:00 | 1248 | 1209 | 1225
R2 | PIVOT + (H-L) | 2011-11-02 00:00:00 | 1248 | 1226 | 1228
R1 | 2 X PIVOT - LOW | 2011-11-08 00:00:00 | 1275 | 1249 | 1273
 |  | 2011-11-09 00:00:00 | 1274 | 1223 | 1226 |  | 1226 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1249 | 1229
S1 | 2 X PIVOT - HIGH | 2011-11-10 00:00:00 | 1245 | 1218 | 1238 |  | 1238 | 1242.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1240 | 1231
S2 | PIVOT - (HIGH - LOW) | 2011-11-11 00:00:00 | 1264.75 | 1233.75 | 1261.5 |  | 1261.5 | 1243
S3 | S1 - (HIGH - LOW)
[NAME] | S3 - (S1 - S2)
Spreadsheet: 231269d1366990967-populating-an-excel-purchase-order-master-po
Sheet: WHITE

 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Date:
 | TO: |  |  |  |  |  |  |  | SHIP TO:
 |  | Ph. |  |  | Fax |  |  |  | Receiver | [NAME]
 |  | Contact. |  |  | [NAME] |  |  |  | Purchaser | [NAME]
 | SHIP VIA: |  |  |  | P.P.D | COLL. | SHIPPING DATE |  | TERMS:
 | ITEM | ORDER | QTY | BACK | SUPPLIER |  | SUPPLY THE FOLLOWING SUBJECT TO CONDITIONS BELOW |  |  |  |  | UNIT | TOTAL
 |  | QTY | REC | ORDER |  |  |  |  |  |  |  | PRICE
 | GST# R100241819 |  |  |  |  |  |  |  |  |  | CONFIRMATION OF CALL
 | TERMS & CONDITIONS OF THIS ORDER
 |  |  |  |  |  |  |  |  |  |  | TO:
 | 1. OUR P.0. NUMBER MUST APPEAR ON ALL INVOICES |  |  |  |  |  |  |  |  |  | DATE: | CON'T TO PO:
 | 2. YOUR INVOICE TO BE IN ACCORDANCE WITH PRICE, DELIVERY & SPECS ABOVE |  |  |  |  |  |  |  |  |  | NEW ORDER
 | 3. NOTIFY US IMMEDIATELY IF YOU ARE UNABLE TO SHIP AS SPECIFIED |  |  |  |  |  |  |  |  |  | APPROVED BY:
 | 4. [NAME] TO BE SHIPPED PREPAID |  |  |  |  |  |  |  |  |  | PURCHASE ACCT #:
 | 5. WE RESERVE THE RIGHT TO CANCEL THIS ORDER IF SHIPMENT NOT MADE AS PROMISED |  |  |  |  |  |  |  |  |  | AQUA-TECH POOLS LTD.
 |  |  |  |  |  |  |  |  |  |  | GREG L
 |  | CANCEL ALL BACKORDERS IF BOX CHECKED
 |  |  |  |  |  | PO 2032
 |  |  |  |  |  |  |  |  | WHITE | CANARY | PINK
 |  |  |  |  |  |  |  |  | SUPPLIER | RECEIVING | BACK ORDER
Spreadsheet: 4041bab7-56f2-497e-b862-50bb973ccdd1
Sheet: Sheet1

 |  |  |  |  |  | DISCOUNT PROPOSAL SPREADSHEET
This document must be completed and submitted with your offer.
Choose the applicable spreadsheet(s) templates below for your offerings.
Products
SIN | MANUFACTURER NAME | MFR PART NO | DEALER PART NUMBER (if applicable) | PRODUCT NAME | PRODUCT DESCRIPTION | UOI | GREEN CERTIFICATION (ENERGY STAR, FEMP, or BIOPREFERRED) (as applicable to schedules 51V, 56 and 73) | RECYCLED AND/OR POST-CONSUMER MATERIAL CONTENT % (Schedule 75 only) | COMMERCIAL LIST PRICE | MOST FAVORED CUSTOMER (MFC) | DISCOUNT OFFERED TO MFC (%) | MFC PRICE | GSA (%) DISCOUNT (exclusive of the .75% IFF) | GSA OFFER PRICE (exclusive of the .75% IFF) | GSA OFFER PRICE (inclusive of the .75% IFF) | QUANTITY/VOLUME DISCOUNT | COO
Most Favored Customer’s Discount or Discount Range (MFC) __________.
GSA’s Discount or Discount Range W/O IFF __________.
Labor Categories
SIN(s) PROPOSED | SERVICE PROPOSED (e.g. Job Title/Task) | MINIMUM EDUCATION/ CERTIFICATION LEVEL |  |  | MINIMUM YEARS OF EXPERIENCE | COMMERCIAL LIST PRICE (CPL)   OR MARKET  PRICES |  | UNIT OF ISSUE (e.g. Hour, Task, Sq ft) | MOST FAVORED CUSTOMER (MFC) | DISCOUNT OFFERED TO MFC (%) | MFC PRICE | GSA(%) DISCOUNT (exclusive of the .75% IFF) | PRICE OFFERED TO GSA (excluding IFF) | PRICE OFFERED TO GSA (including IFF) | QUANTITY/VOLUME DISCOUNT
Courses
SIN(s) PROPOSED | Course Title | Course Length |  |  | Minimum Participants | Maximum Participants |  | COMMERCIAL PRICE (CPL) | Price Per Course or Per Person | MOST FAVORED CUSTOMER (MFC) | DISCOUNT OFFERED TO MFC (%) | MFC PRICE | GSA(%) DISCOUNT (exclusive of the .75% IFF) | PRICE OFFERED TO GSA (excluding IFF) | PRICE OFFERED TO GSA (including IFF) | QUANTITY/VOLUME DISCOUNT
Acronyms
UOI:  Unit of Issue
COO:  Country of Origin
SIN:  Special Item Number
[NAME]:  Most Favored Customer
IFF:  Industrial Funding Fee (Clause 552.238-74): Fee is 0.75% (less than 1%)
 | IFF Calculation Example: List Price = $100.00 |  | List Price: $100.00
 |  |  | GSA % Discount: 10%
 |  |  | GSA Price excluding IFF: $90.00
 |  |  | GSA Price including IFF: $90.00/0.9925 = $90.68
Re:  Recycled and/or Postconsumer Material Content Column – Refer to the Basic Proposal Checklist under EPA Comprehensive Procurement Guidelines (CPG) for instructions.
Spreadsheet: 80548d1280775982-excel-2007-revenue-recognition-model-sample-model
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Revenue Recognition
Unit | Lease Start Date | Lease  End Date | Lease Months | Status | Type | Annual Rent | Month | Days in Month | Balance days-start month | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
1 | 2009-09-30 00:00:00 | 2010-09-29 00:00:00 |  | Active | Nil | 200000
2 | 2008-06-28 00:00:00 | 2009-06-27 00:00:00 |  | Active | Renewed | 400000
3 | 2008-10-29 00:00:00 | 2009-10-28 00:00:00 |  | Active | Renewed | 100000
4 | 2008-10-29 00:00:00 | 2009-10-28 00:00:00 |  | Cancelled | Nil | 100000
5 | 2008-10-29 00:00:00 | 2009-10-28 00:00:00 |  | Active | Renewed | 100000
6 | 2008-10-29 00:00:00 | 2009-10-28 00:00:00 |  | Active | Renewed | 100000
7 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 |  | Active | Renewed | 550000
8 | 2008-03-31 00:00:00 | 2009-03-30 00:00:00 |  | Active | Renewed | 550000
9 | 2008-03-31 00:00:00 | 2009-03-30 00:00:00 |  | Active | Renewed | 550000
23 | 2009-11-04 00:00:00 | 2010-11-03 00:00:00 |  | Active | Renewed | 550000
4 | 2009-06-12 00:00:00 | 2010-06-11 00:00:00 |  | Active | Renewed | 550000
5 | 2008-08-15 00:00:00 | 2009-08-14 00:00:00 |  | Active | Renewed | 550000
56 | 2008-04-30 00:00:00 | 2009-04-29 00:00:00 |  | Active | Renewed | 550000
78 | 2008-08-30 00:00:00 | 2009-08-29 00:00:00 |  | Active | Renewed | 550000
Spreadsheet: chris_germany__2076__TW Compressor Gas 1_02
Sheet: February 2002

ECT - Enron Compressor Gas Sold to Richardson |  |  |  |  |  | contract 27789
Date | Nomed | Flowed
2002-02-01 00:00:00 | 13041 | 13041
2002-02-02 00:00:00 | 13041 | 13041
2002-02-03 00:00:00 | 13041 | 12956
2002-02-04 00:00:00 | 13041 | 13041
2002-02-05 00:00:00 | 13041 | 13040
2002-02-06 00:00:00 | 13041 | 12974
2002-02-07 00:00:00 | 13041 | 13041
2002-02-08 00:00:00 | 13041 | 13041
2002-02-09 00:00:00 | 13041 | 13041
2002-02-10 00:00:00 | 13041 | 13041
2002-02-11 00:00:00 | 13041 | 13041
2002-02-12 00:00:00 | 13041 | 13041
2002-02-13 00:00:00 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13041
 | 13041 | 13040
 | 13041 | 13040
 | 13041 | 13040
 | 13041 | 13041 | UA4
total |  |  |  | Due to pipeline cuts
Spreadsheet: a98b608d-7138-4085-8006-49cac0709522
Sheet: Balance Sheet

The NASDAQ OMX Group, Inc.
Consolidated Balance Sheets
(in millions)
 |  |  |  | June 30, |  | December 31,
 |  |  |  | 2012 |  | 2011
 | Assets |  |  | (unaudited)
 | Current assets:
 |  | Cash and cash equivalents |  | 491 |  | 506
 |  | Restricted cash |  | 36 |  | 34
 |  | Financial investments, at fair value |  | 196 |  | 279
 |  | Receivables, net |  | 341 |  | 308
 |  | Deferred tax assets |  | 16 |  | 16
 |  | Default funds and margin deposits |  | 204 |  | 17
 |  | Open clearing contracts:
 |  | Derivative positions, at fair value |  | 0 |  | 1566
 |  | Resale agreements, at contract value |  | 0 |  | 3745
 |  | Other current assets |  | 126 |  | 110
 | Total current assets
 | Non-current restricted cash |  |  | 105 |  | 97
 | Property and equipment, net |  |  | 198 |  | 193
 | Non-current deferred tax assets |  |  | 392 |  | 392
 | Goodwill |  |  | 5103 |  | 5061
 | Intangible assets, net |  |  | 1625 |  | 1648
 | Other non-current assets |  |  | 94 |  | 119
 | Total assets
 | Liabilities
 | Current liabilities:
 |  | Accounts payable and accrued expenses |  | 160 |  | 164
 |  | Section 31 fees payable to SEC |  | 156 |  | 106
 |  | Accrued personnel costs |  | 74 |  | 132
 |  | Deferred revenue |  | 201 |  | 124
 |  | Other current liabilities |  | 120 |  | 112
 |  | Deferred tax liabilities |  | 27 |  | 27
 |  | Default funds and margin deposits |  | 204 |  | 17
 |  | Open clearing contracts:
 |  | Derivative positions, at fair value |  | 0 |  | 1566
 |  | Repurchase agreements, at contract value |  | 0 |  | 3745
 |  | Current portion of debt obligations |  | 45 |  | 45
 | Total current liabilities
 | Debt obligations |  |  | 1951 |  | 2072
 | Non-current deferred tax liabilities |  |  | 661 |  | 670
 | Non-current deferred revenue |  |  | 160 |  | 154
 | Other non-current liabilities |  |  | 198 |  | 171
 | Total liabilities
 | Commitments and contingencies
 | Equity
 | NASDAQ OMX stockholders' equity:
 | Common stock |  |  | 2 |  | 2
 | Additional paid-in capital |  |  | 3797 |  | 3793
 | Common stock in treasury, at cost |  |  | -1017 |  | -860
 | Accumulated other comprehensive loss |  |  | -368 |  | -350
 | Retained earnings |  |  | 2547 |  | 2391
 | Total [NAME] stockholders' equity
 | Noncontrolling interests |  |  | 9 |  | 10
 | Total equity
 | Total liabilities and equity
Spreadsheet: 594867d1540041907-restrict-entry-book1
Sheet: Sheet1

SL | Ad.No | Name
1 | 7069 | THAHLIYA YASMIN K |  | It’s a list of students….
2 | 6624 | ABHIJITH E
3 | 7322 | ARSHAD NAFIH.M |  | I want to get the serial number and name of studens as
4 | 6393 | MUHAMMED ASLAM KP
5 | 6806 | MUHAMMED JABIR KP
6 | 7424 | RISHAN ASHIF. P
7 | 6610 | VAISHNAV K
8 | 6599 | [NAME]
9 | 6623 | AYISHA BINSIYA VT
10 | 6807 | FATHIMA HIBA M
11 | 6567 | JUVAIRIYATHUL ASLAMIYA KP
12 | 6617 | RASITHA RAJAN K
13 | 7063 | SHAHARBAN. K
14 | 7428 | ABDU RAHEEM P
15 | 7307 | AMEER SUHAIL.P
16 | 6571 | MUHAMMED FARIS MP
17 | 6577 | MUHAMMED SHANOOF P
18 | 7333 | SALMANUL FARIS.M V
19 | 6611 | VAISHAK.P
20 | 6572 | ASWANI P
21 | 6628 | AYISHA SHABANA N P
22 | 6620 | FATHIMA NASRIN P
23 | 7064 | NAJA SHERIN. K
24 | 7061 | RUFNA. M.V
25 | 6622 | SHAHLA THASNI K
26 | 6952 | AMANUDHEEN  P
27 | 6612 | ANUJITH K
28 | 6615 | MUHAMMED RASHID M
29 | 6597 | RAJIL A
30 | 6566 | SHAHEEN K
31 | 6570 | ATHIRA P
32 | 6588 | FATHIMA FARSANA TP
33 | 6608 | JASLA BEEGAM M
34 | 6587 | NISHANA KK
35 | 6600 | SHAHANA SHERIN KT
36 | 6520 | AMEEN [NAME] T
37 | 6598 | BIBIN RAJ PK
38 | 7275 | MUHAMMED SHAFEEL.K
39 | 6613 | ROSHITH N
40 | 7067 | SHYAMRAJ. P
Spreadsheet: 758586d1638961595-rand-names-on-exact-date-list-of-unique-names
Sheet: Sheet1

Number: | 5
Date: | 2021-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-12-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2021-12-03 00:00:00
Name: | Date: |  | Results: |  | Unique names:
[NAME] | 2021-12-01 00:00:00
Anne | 2021-12-01 00:00:00
[NAME] | 2021-12-01 00:00:00
Mark | 2021-12-01 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
Spreadsheet: 92714d1292270774-combine-counts-from-multiple-sheets-to-one-sheet-van1
Sheet: Sheet1

KEY | IC | DISC | VAN1
39821 | M-005603 | WASCOMAT NIPPLE | 0
39822 | M-005604 | NIPPLE FILL WASC GEN | 0
39823 | M-00-6189 | SWITCH WASCO MECH | 0
39824 | M-00-6190 | SWITCH W/LEVER WASCO MECH | 0
39825 | M-006824 | ELECTRODE | 0
39826 | M-00-7225 | SCREW, 3 SIDE | 0
39827 | M-00-7279 | [NAME] | 0
39828 | M-007901 | SOAP BOX LID | 0
39829 | M-00-8040 | SPRING, WASCO | 0
39830 | M-00-8043 | SPRING G COIL | 0
39831 | M-00-8067 | SPRING G COIL | 0
39832 | M-00-8098 | SPRING G DROP .25 | 0
39833 | M-00-8114 | SPRING G CARRIER | 0
39834 | M-00-8123 | SPRING,RATCHET DOG U4 | 0
39835 | M-00-8140 | SPRING, WASCO | 0
39836 | M-00-8148 | SPRING V8 | 0
39837 | M-00-8159 | SPRING V5 FLAT | 0
39838 | M-00-9061 | SCREWDRIVER, 3 SIDE | 0
39839 | M-00-9218 | CARD,NUMBERS 1-16 DECALS | 0
39840 | [NAME] | DRAIN | 0
Spreadsheet: 298308d1392755557-find-a-value-in-a-table-with-multiple-values-test-excel-data-search-sheet
Sheet: ON-5

Date | PO # | Buyer | Division Line | Model | Trailer Description | Serial # | Build Location | Line # | Est. Delivery Date | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Spreadsheet: 827317d1682606357-repeat-certain-numbers-2-times-and-sort-everything-ascending-numbers-i-want-repeated-and-sorted
Sheet: Sheet1

 | 0
0.1 | 0.1
0.2 | 0.2
0.3 | 0.3
0.4 | 0.4
0.5 | 0.5
0.6 | 0.6
0.7 | 0.7
0.7999999999999999 | 0.8
0.8999999999999999 | 0.9
0.9999999999999999 | 1
1.1 | 1.1
1.2 | 1.2
1.3 | 1.3
1.4 | 1.4
1.5 | 1.5
1.6 | 1.6
1.7 | 1.7
1.8 | 1.8
1.900000000000001 | 1.9
2 | 2
2.100000000000001 | 2.1
2.200000000000001 | 2.2
2.300000000000001 | 2.3
2.400000000000001 | 2.4
2.500000000000001 | 2.5
2.600000000000001 | 2.6
2.700000000000001 | 2.7
2.800000000000001 | 2.8
2.900000000000001 | 2.9
3.000000000000001 | 3
3.100000000000001 | 3.1
3.200000000000002 | 3.2
3.300000000000002 | 3.3
3.400000000000002 | 3.4
3.500000000000002 | 3.5
3.600000000000002 | 3.6
3.700000000000002 | 3.7
3.800000000000002 | 3.8
3.900000000000002 | 3.9
4.000000000000002 | 4
4.100000000000001 | 4.1
4.200000000000001 | 4.2
4.300000000000001 | 4.3
4.4 | 4.4
4.5 | 4.5
4.6 | 4.6
4.699999999999999 | 4.7
4.799999999999999 | 4.8
4.899999999999999 | 4.9
4.999999999999998 | 5
5.099999999999998 | 5.1
5.199999999999998 | 5.2
5.299999999999997 | 5.3
5.399999999999997 | 5.4
5.499999999999996 | 5.5
5.599999999999996 | 5.6
5.699999999999996 | 5.7
5.799999999999995 | 5.8
5.899999999999995 | 5.9
5.999999999999995 | 6
Spreadsheet: 715471d1611724751-create-table-that-returns-maximum-date-for-multiple-rows-of-matching-data-except-date-mini-data-set-example
Sheet: Final tbl should look like

Site | UTM Zone | UTM Easting | UTM Northing | Species | Survey Year
117357 | 9 | 319620 | 5888268 | Canada thistle (CIRS ARV) | 2019-09-11 00:00:00
209012 | 9 | 305579 | 5939964 | Canada thistle (CIRS ARV) | 2019-05-16 00:00:00
246515 | 9 | 305464 | 5940283 | Canada thistle (CIRS ARV) | 2018-05-28 00:00:00
312115 | 9 | 318845 | 5889987 | Canada thistle (CIRS ARV) | 2019-09-11 00:00:00
202963 | 9 | 424042 | 6009368 | Common tansy (TANA VUL) | 2020-09-06 00:00:00
293246 | 9 | 424065 | 6008897 | Common tansy (TANA VUL) | 2020-09-06 00:00:00
350834 | 9 | 424033 | 6009053 | Common tansy (TANA VUL) | 2020-09-06 00:00:00
Spreadsheet: 124317d1318333986-excel-2007-5-years-on-help
Sheet: Sheet1

First Aid Cert. | Status | Lantra CS30 | Status
 |  | 2010-05-07 00:00:00
2012-08-15 00:00:00 |  | 2006-01-25 00:00:00
2012-06-27 00:00:00 |  | 2006-02-22 00:00:00
2014-01-08 00:00:00 |  | 2005-05-24 00:00:00
 |  | 2010-11-01 00:00:00
 |  | 2011-03-31 00:00:00
 |  | 2008-07-25 00:00:00
2012-07-04 00:00:00 |  | 2006-06-21 00:00:00
2012-08-15 00:00:00 |  | 2009-08-06 00:00:00
2012-07-04 00:00:00 |  | 2005-01-13 00:00:00
2012-07-04 00:00:00
2012-09-05 00:00:00
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, January 18 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****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: 117638d1312925953-consolidated-statistics-formulas-to-get-a-consolidated-statistics
Sheet: Sheet1

 |  | The Table:
 |  | No | Qty | Value | Date
 |  | 3100019039 | 81 | 1143.3 | 2011-04-25 00:00:00 |  | In the Table, there are only 3 unique Nos in Col.C are repeating.
 |  | 3100019501 | 38 | 1699.5 | 2011-05-06 00:00:00 |  |  |  | (Col D) | (Col E) | (Col F) | (Col F)
 |  | 3100019039 | 27 | 1391 | 2011-05-18 00:00:00 |  |  | No. | Qty total | Value Total | Date Min | Date Max
 |  | 3100019400 | 11 | 8392 | 2011-05-06 00:00:00 |  | i.e.
 |  | 3100019039 | 183 | 1884.9 | 2011-05-17 00:00:00
 |  | 3100019400 | 27 | 2155.79 | 2011-05-17 00:00:00
 |  | 3100019400 | 3 | 18181 | 2011-05-28 00:00:00
 |  | 3100019039 | 1 | 28737 | 2011-07-28 00:00:00 | (Max of C11)
 |  | 3100019501 | 37 | 30333.66 | 2011-06-03 00:00:00
 |  | 3100019400 | 22 | 8742.64 | 2011-06-17 00:00:00
 |  | 3100019501 | 80 | 9939.5 | 2011-05-17 00:00:00 |  |  | Friends,
 |  | 3100019039 | 27 | 15172 | 2011-02-28 00:00:00 | (Min of C11) |  | I want to get the consolidated result as mentioned in  Cols. J7 - M7 for all [NAME]. mentioned in Col.I. Please help me to find the formulas.
 |  | 3100019400 | 11 | 9534 | 2011-05-28 00:00:00
 |  | 3100019039 | 78 | 11917.1 | 2011-03-06 00:00:00
 |  | 3100019501 | 54 | 16152 | 2011-05-06 00:00:00
 |  | 3100019039 | 22 | 21815.4 | 2011-05-06 00:00:00
Spreadsheet: 750243d1633356323-replacing-nested-if-stetements-example
Sheet: Sheet1

 | Item | Plant | [NAME]. | Request |  | 1026 | 1002 | 1023 | 1040
 | C111 | 1002 | 10 | Can I allocate in 1002? |  | 0 | 10 | 0 | 0
 | E444 | 1002 | 10 | Can I move to 1026? |  | 30 | 5 | 20 | 5
 | C112 | 1002 | 10 | Can I move to 1040? |  | 0 | 0 | 10 | 20
 | C113 | 1002 | 10 | Can I move to 1023? |  | 3 | 3 | 6 | 0
 | E445 | 1002 | 10 | Can I allocate in 1002? |  | 5 | 5 | 5 | 5
 | D333 | 1023 | 10 | Can I move to 1002? |  | 0 | 10 | 0 | 0
 | D334 | 1023 | 10 | Can I allocate in 1023? |  | 30 | 5 | 20 | 5
 | F555 | 1026 | 10 | Can I move to 1040? |  | 0 | 0 | 10 | 20
 | F556 | 1026 | 10 | Out of stock |  | 2 | 2 | 2 | 2
 | B222 | 1040 | 10 | Can I move to 1002? |  | 0 | 10 | 0 | 0
 | B223 | 1040 | 10 | Can I move to 1026? |  | 30 | 5 | 20 | 5
 | B224 | 1040 | 10 | Can I allocate in 1040? |  | 0 | 0 | 10 | 20