tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 03267c30-a723-494d-8a6f-8cacfcb16e13
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Candidate Name | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Check box for EVERY candidate  you would like to elect into The Order of the Arrow | Unnamed: 10 | Unnamed: 11
1
2
 |  |  |  |  |  |  |  |  |  |  | OA Election Ballot
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 |  |  |  |  |  |  |  |  |  |  | OA Election Ballot
25
Spreadsheet: michael_maggi__26471__NYMEXWEEKLYSTATS
Sheet: ho

Week Ending: | 2001-01-14 00:00:00
 | Futures Settlement Prices
 | HEATING OIL |  |  |  |  | Contract Symbol:  HO
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-14 00:00:00 | 2001-01-15 00:00:00 | 2001-01-16 00:00:00 | 2001-01-17 00:00:00 | 2001-01-18 00:00:00 | Interest
 | 2002-02-01 00:00:00 | 0.5141 | 0.5145 | 0.5321 | 0.5145 | 0.5141 | 33603
 | 2002-03-01 00:00:00 | 0.5166 | 0.518 | 0.5356 | 0.518 | 0.5166 | 42831
 | 2002-04-01 00:00:00 | 0.5181 | 0.52 | 0.5366 | 0.52 | 0.5181 | 24625
 | 2002-05-01 00:00:00 | 0.5196 | 0.5215 | 0.5366 | 0.5215 | 0.5196 | 9570
 | 2002-06-01 00:00:00 | 0.5236 | 0.5265 | 0.5411 | 0.5265 | 0.5236 | 16443
 | 2002-07-01 00:00:00 | 0.5291 | 0.5325 | 0.5466 | 0.5325 | 0.5291 | 7154
 | 2002-08-01 00:00:00 | 0.5366 | 0.54 | 0.5536 | 0.54 | 0.5366 | 6907
 | 2002-09-01 00:00:00 | 0.5456 | 0.549 | 0.5621 | 0.549 | 0.5456 | 6317
 | 2002-10-01 00:00:00 | 0.5546 | 0.558 | 0.5711 | 0.558 | 0.5546 | 3521
 | 2002-11-01 00:00:00 | 0.5626 | 0.566 | 0.5791 | 0.566 | 0.5626 | 3594
 | 2002-12-01 00:00:00 | 0.5701 | 0.5735 | 0.5866 | 0.5735 | 0.5701 | 9080
 | 2003-01-01 00:00:00 | 0.5756 | 0.579 | 0.5921 | 0.579 | 0.5756 | 4811
 | Total Weekly Volume |  |  |  | Total Open Interest |  | 173372
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | Heating Oil
 | 5 Day Hist. Vol. |  |  | 0.379
 | 20 Day Hist. Vol. |  |  | 0.5788
 | Implied Volatility-Options |  |  | Heating Oil
 | At the Money Call & Put |  |  | 0.547
 | MON | TUE | WED | THUR | FRI | Total
Volume | 56067 | 40938 | 44605 | 52710 | 39073
Spreadsheet: 159727d1338827839-excel-2007-i-need-a-formula-which-when-dates-match-transfer-the-data-from-the-entire-row-dates-and-data1
Sheet: Aug.

 |  | 2012-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays11
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00 | Fixed Date | 2
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00 | Non Fixed Date | 3
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-25 00:00:00 | Fixed Date | 4
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00 | Non Fixed Date | 5
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00 | Non Fixed Date | 6
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | Fixed Date | 7
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-04 00:00:00 | Non Fixed Date | 8
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00 | Fixed Date | 9
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00 | Fixed Date | 10
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-24 00:00:00 | Fixed Date | 11
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00 | Fixed Date | 12
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00 | Fixed Date | 13
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
Spreadsheet: 730233d1619611846-buying-and-selling-in-multiple-currencies-test-calcs
Sheet: Sheet1

 |  |  |  | GBP-EUR | 1.15 | 20 |  |  | USD | GBP | EUR
 |  |  |  | USD-EUR | 0.83 | 20
 |  |  |  |  |  | 20
 |  |  |  | EUR-GBP | 0.87 | 20
 |  |  |  | USD-GBP | 0.72 | 20
 |  |  |  |  |  | 20
 |  |  |  | EUR-USD | 1.21 | 20
 |  |  |  | GBP-USD | 1.39 | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR UNIT | GBP UNIT | USD UNIT | USD | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR UNIT | GBP UNIT | USD UNIT | EUR | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR UNIT | GBP UNIT | USD UNIT | GBP | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
# | [NAME] | QTY EACH | SUPPLIER | EUR UNIT | GBP UNIT | USD UNIT | EUR | LINE COST
1 | Product 1 | 5 |  | 20
2 | Product 2 | 5 |  |  | 20
3 | Product 3 | 5 |  |  |  | 20
Spreadsheet: 720265d1614092094-large-array-for-top-5-completes-test-book
Sheet: Sheet1

Array to pull top 5 contracts by Company Number that are over $1M in Revenue (Column E), Greater than or equal 80% complete (H), but less than 100% complete (column H)
Company 10 |  |  |  | Company 13
# | Contract # | [NAME] | % Complete | # | Contract # | [NAME] | % Complete
1 |  |  |  | 1 |  |  |  |  | Only looks at projects >= $1,000,000
2 |  |  |  | 2 |  |  |  |  | Only projects with greater than or equal to 80%
3 |  |  |  | 3
4 |  |  |  | 4
5 |  |  |  | 5
Company | Contract | [NAME] | Job Cost Department | Estimated Revenue  at Completion | Estimated Cost  at Completion | Estimated Gross Profit  at Completion | Percent Complete  To Date
10 | 1000001 | Contract 1 | Plan | 500000 | 450000 |  | 0.835
10 | 1000002 | Contract 2 | Plan | 1350000 | 1215000 |  | 0.923
10 | 1000003 | Contract 3 | Plan | 435000 | 391500 |  | 0.99
10 | 1000004 | Contract 4 | Plan | 8951000 | 8055900 |  | 0.81
10 | 1000005 | Contract 5 | Plan | 4152321 | 3737088.9 |  | 0.845
10 | 1000006 | Contract 6 | Plan | 850219 | 765197.1 |  | 0.12
10 | 1000007 | Contract 7 | Plan | 2253221 | 2027898.9 |  | 0.95
13 | 1300001 | Contract 8 | Plan | 6950000 | 6255000 |  | 0.99
13 | 1300002 | Contract 9 | Plan | 2035000 | 1831500 |  | 1
13 | 1300003 | Contract 10 | Plan | 450690 | 405621 |  | 0.05
13 | 1300004 | Contract 11 | Plan | 470555 | 423499.5 |  | 0.1
13 | 1300005 | Contract 12 | Plan | 1780500 | 1602450 |  | 0.75
13 | 1300006 | Contract 13 | Plan | 675221 | 607698.9 |  | 0.3
13 | 1300007 | Contract 14 | Plan | 1350000 | 1215000 |  | 0.86
13 | 1300008 | Contract 15 | Plan | 435000 | 391500 |  | 1
15 | 1500001 | Contract 16 | Plan | 8951000 | 8055900 |  | 1
15 | 1500002 | Contract 17 | Plan | 4152321 | 3737088.9 |  | 0.89
15 | 1500003 | Contract 18 | Plan | 358100 | 322290 |  | 0.559
15 | 1500004 | Contract 19 | Plan | 396000 | 356400 |  | 0.45
15 | 1500005 | Contract 20 | Plan | 4800000 | 4320000 |  | 0.9
15 | 1500006 | Contract 21 | Plan | 61000000 | 54900000 |  | 0.81
15 | 1500007 | Contract 22 | Plan | 2035000 | 1831500 |  | 0.8269
15 | 1500008 | Contract 23 | Plan | 450690 | 405621 |  | 0.02
15 | 1500009 | Contract 24 | Plan | 470555 | 423499.5 |  | 0.68
15 | 1500010 | Contract 25 | Plan | 1780500 | 1602450 |  | 0.45
15 | 1500011 | Contract 26 | Plan | 675221 | 607698.9 |  | 0.9
15 | 1500012 | Contract 27 | Plan | 965000 | 868500 |  | 0.368
15 | 1500013 | Contract 28 | Plan | 10000000 | 9000000 |  | 1
Spreadsheet: 196675d1354068965-excel-cell-unlocked-cell-locks-when-copying-text-from-a-website-book1
Sheet: ObjA

OBJ#1 | 1
OBJ#2 | 2
OBJ#3 | 3
OBJ#4 | 4
OBJ#5 | 5
OBJ#6 | 6
OBJ#7 | 7
OBJ#8 | 8
OBJ#9 | 9
OBJ#10 | 10
OBJ#11 | 11
OBJ#12 | 12
[NAME] | 13
OBJ#14 | 14
OBJ#15 | 15
OBJ#16 | 16
Spreadsheet: 789693d1659291847-search-each-cell-from-the-whole-column-and-if-matched-return-some-value-true-false-example-1
Sheet: Sheet1

Categories |  |  |  |  |  |  | Keywords
[NAME] |  |  |  |  |  |  | Chicken
[NAME] |  |  |  |  |  |  | Paneer
Punjabi Lassi paneer |  |  |  |  |  |  | Capsicum
Pyaaz Paneer |  |  |  |  |  |  | Bread
Paalak paneer |  |  |  |  |  |  | [NAME]
Shaahi paneer
[NAME], grilled paneer
[NAME], [NAME] paneer
[NAME], ridged gourd with paneer
Dhana capsicum nu shaak (dry coriander, capsicum and chickpea curry )
Dudhi chana ni daal nu shaak (bottle gourd and split black chickpea curry )
[NAME] (a Surti variety made from chickpea flour)
Pani puri (a round hollow flatbread that is fried crisp and filled with potato, and black chickpeas and topped with water seasoned with mint and green chili pepper, and tamarind chutney)
Malvani chicken
chicken karahi
tandoori chicken
[NAME]
chicken tikka
Chicken tandoori
[NAME], chicken kebab
[NAME] [NAME], chicken kebabs
Spreadsheet: 177524d1346338430-drop-down-box-to-select-data-jdk789-problem
Sheet: Data

Order numbers | Name | Post Code | Date | Number of HBDIs | Number of Pair Reports | Number of Team Reports | Blank Reports | Extra 1 | Extra 2 | Extra 3 | Extra 4 | Extra 5 | Extra 6 | Delivery Details | Tracking Information | Date of Dispatch
123 | [NAME] | NR33 7NH | 2012-07-25 00:00:00 | 5 | 1 | 0 | 0 | [NAME] | Bears | 0 | 0 | 0 | 0 | UK Mail Next Day Standard | 40415360000123 | 2012-07-25 00:00:00
456 | [NAME] | NR32 7YH | 2012-07-26 00:00:00 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Royal Mail 1st Class | No Tracking | 2012-07-26 00:00:00
789 | [NAME] | [NAME] 8UA | 2012-07-27 00:00:00 | 6 | 1 | 1 | 5 | Bears | [NAME] Set | 0 | 0 | 0 | 0 | UK Mail Next Day Standard | 40415360000789 | 2012-07-27 00:00:00
Spreadsheet: 275739d1383630605-automatic-data-fetching-row-wise-in-main-sheet-if-cells-are-non-blank-in-linked-sheet-test
Sheet: 13716

 |  |  | Reconcilation Sheet |  |  |  |  | Job oder : | 576JO-13716
 |  |  |  |  |  |  |  | Plant : | FC 2
 | Sr.no | Item description | MOC | Size in mm | New issued from store in RM | Old taken from plant/ existing in RM | Total Issue Qty in RM | Used Pipe in RM |  | Total used Qty in RM | Balance |  | Scrap in Kg | Remarks If any | Plants
 | 576JO-13716 | Pipe | SS | 25 |  | 1 | 2.5 |  | 2.5 | 2.5
 | 576JO-13716 | Pipe | MS | 40 |  | 6.1 | 24.4 |  | 24.4 | 24.4
 |  | Pipe
 |  | Pipe
 | 576JO-13716 | Ready bends |  | 50 | 3 |  | 12 | 12 |  | 12
 |  | Ready bends
 |  | Ready bends
 | 576JO-13716 | TEE | SS | 50 |  | 1 | 5 |  | 5 | 5
 |  | TEE
 |  | TEE
 |  | TEE
 |  | TEE
 |  | TEE
 | 576JO-13716 | Nipple | SS | 50 |  | 1 | 5 |  | 5 | 5
 |  | Nipple
 |  | Nipple
 |  | Nipple
 |  | Nipple
 |  | Valve
 |  | Valve
 | 576JO-13716 | [NAME] | SS | 250 |  | 4 | 100 |  | 100 | 100
 | 576JO-13716 | [NAME] | MS | 50 |  | 2 | 10 |  | 10 | 10
 | 576JO-13716 | Clamps | MS | 80 |  | 1 | 8 |  | 8 | 8
 | 576JO-13716 | Clamps | MS | 65 |  | 1 | 6.5 |  | 6.5 | 6.5
 | 576JO-13716 | Clamps | MS | 50 |  | 2 | 10 |  | 10 | 10
 | 576JO-13716 | Blind/CW | SS | 25 |  | 11 | 27.5 |  | 27.5 | 27.5
 | 576JO-13716 | Blind/CW | SS | 50 |  | 5 | 25 |  | 25 | 25
Spreadsheet: 1167ed33-d906-4174-9a8d-509d0f34e754
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
KENTUCKY TRANSPORTATION CABINET
DEPARTMENT OF HIGHWAYS
DIVISION OF CONSTRUCTION
SUBCONTRACT REQUEST
 |  | Supplemental  Change Order Items
CONT_ID
SUBCONTRACT NO: |  |  | Tier Y/N
TO: | [NAME], P.E.
 | Director, Division of Construction
FROM:
 | Prime Contractor |  |  |  |  | KYTC Vendor Number
SUBJECT:
 | County |  | Fed/State Project Number |  |  |  |  |  |  | 2
I hereby request to subcontract a portion of the subject project to:
 |  |  | KYTC Vendor Number
The amount to be subcontracted by this request is               $
I have previously subcontracted as follows:
NAME OF SUBCONTRACTOR |  |  | AMOUNT
The total amount to be subcontracted including this request is $
This subcontractor has been furnished a copy of Appendix B of 49 CFR Part 29 and advised to include the Certification in all lower tier covered transactions and in all solicitations for lower tier transactions (Federal Aid Contracts only).
The proposed subcontractor is on the Department's list of qualified contractors to perform work requested and a copy of current insurance coverage will be available at the prime contractor's office before the subcontractor begins work on project.
Prime Contractor |  |  |  |  | Date
CC District TEBM for Construction
 |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 864508d1711645980-random-nonrepeating-questions-and-answers-for-quiz-show-example
Sheet: Quiz show

 |  |  |  |  | [NAME] | ANSWER
Spreadsheet: 691759d1597857211-optimization-problem-kema
Sheet: Sheet1

Batch | Comp | SOH | Used
10-001 | Component A | 10000
10-001 | Component B | 32000
10-001 | Component C | 54000
20-001 | Component B | 15000
20-001 | Component C | 23000
 | Product A recipe 1 |  | Amount | 10000
 | Component A | 1
 | Component C | 2
 |  |  |  |  |  | Total 10-001:
 | Product A recipe 2 |  | Amount | 21333.33333333334
 | Component B | 1.5
 | Component C | 1.5
Determine [NAME] number of product A that can be produced for each batch, based on components availability
Spreadsheet: dutch_quigley__9203__enron breakdown  12-07 BOD
Sheet: Sheet1

ENRON position breakdown (12-07-01) BOD
 | Option Contracts |  |  | Futures Contracts |  |  | Options | Overall
Month | Bod | Activity | Eod | Bod | Activity | Eod | Delta | Delta | Gamma | Vega | Theta | Month
F02 | 7763 |  |  | -1389 |  |  | 1358 |  | 0 | -2829 | 2222 | F02
G02 | 2268 |  |  | 396 |  |  | -405 |  | 2 | 18240 | -13816 | G02
H02 | 4125 |  |  | 591 |  |  | -676 |  | 3.5 | 44600 | -20607 | H02
[NAME] | 400 |  |  | 61 |  |  | 14 |  | -0.66 | -9249 | 2765 | [NAME]
K02 | 1360 |  |  | -317 |  |  | 306 |  | -4.2 | -68201 | 13236 | K02
M02 | 802 |  |  | 92 |  |  | -62 |  | 1.3 | 27306 | -4285 | M02
N02 | 400 |  |  | -54 |  |  | 42 |  | -1.3 | -30962 | 3888 | N02
Q02 | 600 |  |  | -63 |  |  | 89 |  | -1.5 | -42179 | 4632 | Q02
U02 | 355 |  |  | 39 |  |  | -67 |  | -0.6 | -20677 | 2035 | U02
X02 | 0 |  |  | 8 |  |  |  |  | 0 | 0 | 0 | X02
[NAME] | 600 |  |  | 65 |  |  | -29 |  | -0.9 | -48883 | 3349 | [NAME]
H03 | 200 |  |  | -15 |  |  | 13 |  | 0.4 | 25237 | -1221 | H03
M03 | 300 |  |  | 18 |  |  | -22 |  | 0.7 | 39532 | -1204 | M03
U03 | 50 |  |  | -6 |  |  | 4 |  | 0.1 | 7096 | -168 | U03
Z03 | 200 |  |  | -29 |  |  | 16 |  | 0.4 | 32913 | -685 | Z03
H04 | 500 |  |  | 125 |  |  | -136 |  | 0.6 | 45577 | -784 | H04
 |  |  |  | 3114 |  | 3268 | Overall:
Spreadsheet: 769083d1645282774-yearly-change-formula-function-sample
Sheet: Data

hospital_DB | type | drug_bug | drug | bug | isolates_hospital_n | isolates_tested | susceptibility | isolates_susceptible | year
ABC MEDICAL CENTER | gram_negative | Amikacin-Citrobacter freundii | Amikacin | Citrobacter freundii | 13 | 12 | 1 |  | 2018
ABC MEDICAL CENTER | gram_negative | [NAME] cloacae complex | Ampicillin | Enterobacter cloacae complex | 44 | 33 | 1 |  | 2019
ABC MEDICAL CENTER | gram_negative | [NAME] coli | Citroxene | E. coli | 10 | 10 | 0.3 |  | 2020
ABC MEDICAL CENTER | gram_positive | Group A Strep-Penicillin | Penicillin | Group A Strep | 53 | 50 | 1 |  | 2019
ABC MEDICAL CENTER | gram_positive | Linezolid-MRSA | Linezolid | MRSA | 33 | 24 | 1 |  | 2019
Care MEDICAL CENTER | gram_positive | Linezolid-MSSA | Linezolid | MSSA | 66 | 34 | 0.89 |  | 2020
Care MEDICAL CENTER | gram_positive | Penicillin-MRSA | Penicillin | MRSA | 333 | 89 | 0.98 |  | 2020
MedicineHOSPITAL | gram_negative | Ertapenem-Acinetobacter baumannii | Ertapenem | Acinetobacter baumannii | 8 | 7 | 0.77 |  | 2018
MedicineHOSPITAL | gram_negative | Ertapenem-E. coli | Ertapenem | E. coli | 4 | 3 | 0.33 |  | 2020
MedicineHOSPITAL | gram_positive | Group B Strep-Penicillin | Penicillin | Group B Strep | 459 | 457 | 1 |  | 2018
MedicineHOSPITAL | gram_positive | Penicillin-Staphylococcus aureus | Penicillin | Staphylococcus aureus | 32 | 32 | 0.5 |  | 2019
MedicineHOSPITAL | gram_negative | Tobramycin-Klebsiella aerogenes | Tobramycin | Klebsiella aerogenes | 10 | 10 | 1 |  | 2020
XYZ MEDICAL CENTER | gram_negative | Amikacin-Klebsiella pneumoniae | Amikacin | Klebsiella pneumoniae | 5 | 5 | 0.98 |  | 2018
XYZ MEDICAL CENTER | gram_negative | Amikacin-Proteus mirabilis | Amikacin | Proteus mirabilis | 33 | 24 | 1 |  | 2019
XYZ MEDICAL CENTER | gram_negative | [NAME] cloacae complex | Ampicillin | Enterobacter cloacae complex | 213 | 211 | 1 |  | 2019
XYZ MEDICAL CENTER | gram_negative | [NAME] morganii | Ciprofloxacin | Morganella morganii | 53 | 54 | 0.45 |  | 2019
XYZ MEDICAL CENTER | gram_positive | Group A Strep-Penicillin | Penicillin | Group A Strep | 14 | 14 | 1 |  | 2018
XYZ MEDICAL CENTER | gram_positive | Linezolid-MSSA | Linezolid | MSSA | 6 | 5 | 1 |  | 2020
Care MEDICAL CENTER | gram_negative | Amikacin-Proteus mirabilis | Amikacin | Proteus mirabilis | 663 | 662 | 0.89 |  | 2018
Care MEDICAL CENTER | gram_negative | [NAME] cloacae complex | Ampicillin | Enterobacter cloacae complex | 112 | 101 | 0.98 |  | 2019
Spreadsheet: 180094d1347474888-convert-2-column-spreadsheet-to-multi-columns-based-on-1-column-book8
Sheet: Sheet1

ADD | [NAME] |  |  | ADD
ADD | [NAME] |  |  | ADD | [NAME]
ADD | [NAME] |  |  | ADD | [NAME]
ADD | [NAME] |  |  | ADD | [NAME]
ADD | [NAME] |  |  | ADD | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME]
CAD | [NAME] |  |  | CAD | [NAME]
CAD | [NAME] |  |  | CAD | [NAME]
CAD | [NAME] |  |  | CAD | [NAME]
CAD | [NAME] |  |  | CAD | [NAME]
 |  |  |  |  | [NAME]
Step 1: Copy Col A to E1, Copy Col B to F2
Step 2: Data tab> Remove Duplicates on E and then on F
 | [NAME] values from E to G1:?1 using Paste Special > transpose
 | (See Sheet 2)
Spreadsheet: ac75b0dc-28cc-4ee2-8248-356b2ee460e0
Sheet: Sheet1

Economic Indicators | Unnamed: 1 | Unnamed: 2
Chart II-1
Economic growth and national expenditure
Quarterly data
Percentage change on a year earlier
 | GDP | National expenditure
1Q 1998 | -0.5 | 15.5
2Q 1998 | 8.6 | 13.5
3Q 1998 | 7.9 | 13.1
4Q 1998 | 8.9 | 13.5
1Q 1999 | 13.7 | 5.9
2Q 1999 | 0.2 | 4.8
3Q 1999 | 1.5 | 3.9
4Q 1999 | 2.3 | 2.6
1Q 2000 | 1.1 | 4.7
2Q 2000 | 4.8 | 6.5
3Q 2000 | 8 | 6.2
4Q 2000 | 3.3 | 6.3
1Q 2001 | 2.4 | 1.9
2Q 2001 | 6.3 | -1.7
3Q 2001 | 0.8 | -2.8
4Q 2001 | 6.2 | -5.5
1Q 2002 | 1.3 | -5.4
2Q 2002 | -0.4 | -3.7
3Q 2002 | 1.7 | -0.8
4Q 2002 | -2 | 0.5
1Q 2003 | 9.5 | 7.9
2Q 2003 | 0.6 | 6.1
3Q 2003 | 0.5 | 5.2
4Q 2003 | -0.5 | 4
1Q 2004 | 4.9 | 9
2Q 2004 | 7.1 | 9.9
3Q 2004 | 7.5 | 6.6
4Q 2004 | 11.1 | 14
1Q 2005 | 3.7 | 11.3
2Q 2005 | 10.4 | 13.5
3Q 2005 | 10.2 | 22.3
4Q 2005 | 5.5 | 15.8
1Q 2006 | 6.8 | 15.9
2Q 2006 | 4.8 | 11.6
3Q 2006 | 2.5 | 4.1
4Q 2006 | 3.8 | 6.9
1Q 2007 | 2.1 | -6.3
2Q 2007 | 4.6 | 1.5
3Q 2007 | 6.3 | 3.6
4Q 2007 | 6.3 | -4.3
1Q 2008 | 3.3 | 3.3
2Q 2008 | 5 | -8
Spreadsheet: 772730d1647445893-excel-formula-consolidate-data-in-columns-and-create-new-rows-two-criteria-test-workbook
Sheet: Sheet1

Sequence # | Value | Amount | Type | Type C? |  | Distinct Values | Sum Of |  | "Distinct" Values | Sum Of |  | Option 1 (using helper in D) |  |  | Option 2 (helper in P) |  |  |  |  |  | Sequence # | Value | Amount | Type
1 |  |  |  |  |  |  |  |  | 1 | 123.5 |  |  | 123.5 |  |  | 0 |  |  |  |  | 1 | 1 | 12 | A9014
2 |  |  |  |  |  |  |  |  | 2 | 85 |  | 2 | 85 |  | 2 | 0 |  |  |  |  | 2 | 1 | 44.5 | B2435
3 |  |  |  |  |  |  |  |  | 3 | 82.25 |  | 3 | 82.25 |  | 3 | 0 |  |  |  |  | 3 | 1 | 45 | A1012
4 |  |  |  |  |  |  |  |  | 4 | 134.75 |  | 4 | 134.75 |  | 4 | 0 |  |  |  |  | 4 | 1 | 17 | A
5 |  |  |  |  |  |  |  |  | 1 | 72.5 |  | 1 | 72.5 |  | 1 | 1 |  |  |  |  | 5 | 2 | 21 | A
6 |  |  |  |  |  |  |  |  | 3 | 32.5 |  | 3 | 32.5 |  | 3 | 1 |  |  |  |  | 6 | 2 | 1 | A
7 |  |  |  |  |  |  |  |  | 4 | 3 |  | 4 | 3 |  | 4 | 1 |  |  |  |  | 7 | 1 | 13 | C127
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 1 | 15.5 | C3453
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1 | 17 | C
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 3 | 82.25 | A
11 |  |  |  |  |  | Currently ^ |  |  | What I want ^ |  |  |  |  |  |  |  |  |  |  |  | 11 | 3 | 0.5 | C
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1 | 27 | C
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 3 | 13 | C
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 3 | 19 | C
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 4 | 3 | C
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 1 | 5 | A
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 4 | 55 | A
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 2 | 63 | A
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 4 | 79.75 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 12 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 3 | 14 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 4 | 13.5 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 2 | 12 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 1 | 44 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 1 | 17 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 2 | 19 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 2 | 0.25 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 3 | 18 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 3 | 22 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 5 | 34 | C
Spreadsheet: 851238d1701453269-count-staff-attendance-and-provide-date-attended-training-dates-2023-sweettalkinwoman-
Sheet: COURSE 2

Training Schedule
Date | Event | Time | Venue | Status | Attendee | Attended
2023-06-14 00:00:00 | COURSE 2 |  | Seminar Room |  |  | Yes
 |  |  |  |  |  | Yes
Spreadsheet: 54636d1254683036-displaying-names-across-different-spreadsheets-and-sorting-freshmen-205-1-
Sheet: Sheet3

Count of Check | Column Labels
Row Labels | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Lucas O’Bryen | [NAME] | [NAME] | [NAME] | [NAME] | No tutor | [NAME] | [NAME] | [NAME] | [NAME] | (blank) | Grand Total
Cox, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  | 2
[NAME], [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 | 4
Harris, Dayona |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  | 2
[NAME], [NAME] |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 3
Jones, Lakesha |  |  | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
[NAME], Ulysses |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 3
[NAME], [NAME] |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 | 4
Omoghibo, Eseh |  |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Payne, [NAME] | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 4
Rojo, Enya |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 3
Shoaf, [NAME] |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2
[NAME], Jovan |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 3
Walsh, [NAME] |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 2
Yarbrough, [NAME] |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 2
(blank) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
Grand Total | 2 | 3 | 3 | 1 | 2 | 3 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 2 | 3 | 1 | 3 | 41