tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 202269d1356458216-automatic-updating-score-table-pokerstand-oeldere-
Sheet: Blad1

name | date1 | date2 | 5-dec4 | 16-jan | 6-feb | 6-mrt | 3-apr | Total
arne vsk | 0 | 2 | 9 |  |  |  |  | 11 |  |  | [NAME]
attika delaere | 0 | 0 |  |  |  |  |  | 0 |  |  | name | Totaal
[NAME] | 13 | 0 | 3 |  |  |  |  | 16 |  |  | brecht deweerdt | 32
bjorn vansteenkiste | 2 | 15 | 10 |  |  |  |  | 27 |  |  | niels verbauwhede | 31
brecht deweerdt | 15 | 4 | 13 |  |  |  |  | 32 |  |  | hannes vkb | 27
brecht vdv | 0 | 0 |  |  |  |  |  | 0 |  |  | bjorn vansteenkiste | 27
[NAME] | 14 | 0 |  |  |  |  |  | 14 |  |  | [NAME] | 25
dempsey voet | 3 | 0 |  |  |  |  |  | 3 |  |  | rudger kerckhove | 23
[NAME] | 0 | 5 |  |  |  |  |  | 5 |  |  | [NAME] | 18
dieter geldhof | 9 | 0 | 2 |  |  |  |  | 11 |  |  | [NAME] | 16
dieter vdh | 5 | 0 |  |  |  |  |  | 5 |  |  | reza barikro | 15
eline bossuyt | 0 | 0 |  |  |  |  |  | 0 |  |  | [NAME] | 14
fre vandecasteele | 0 | 9 |  |  |  |  |  | 9 |  |  | [NAME] | 13
hannes vkb | 10 | 3 | 14 |  |  |  |  | 27 |  |  | [NAME] | 12
[NAME] | 0 | 0 |  |  |  |  |  | 0 |  |  | dieter geldhof | 11
inge samyn | 0 | 0 | 8 |  |  |  |  | 8 |  |  | [NAME] | 11
[NAME] | 4 | 0 |  |  |  |  |  | 4 |  |  | arne vsk | 11
[NAME] | 0 | 6 |  |  |  |  |  | 6 |  |  | fre vandecasteele | 9
jeroen deblock | 8 | 0 |  |  |  |  |  | 8 |  |  | jeroen deblock | 8
[NAME] | 0 | 1 |  |  |  |  |  | 1 |  |  | inge samyn | 8
[NAME] | 0 | 7 |  |  |  |  |  | 7 |  |  | peanut | 7
[NAME] | 0 | 0 | 6 |  |  |  |  | 6 |  |  | [NAME] | 7
[NAME] | 0 | 0 |  |  |  |  |  | 0 |  |  | [NAME] | 6
[NAME] | 0 | 0 |  |  |  |  |  | 0 |  |  | [NAME] | 6
leen deweerdt | 0 | 0 |  |  |  |  |  | 0 |  |  | [NAME] | 5
[NAME] | 11 | 0 | 1 |  |  |  |  | 12 |  |  | dieter vdh | 5
mathieu bruyneel | 0 | 0 |  |  |  |  |  | 0 |  |  | [NAME] | 4
mathieu ryckebosch | 0 | 0 |  |  |  |  |  | 0 |  |  | pedro destadsbader | 4
matthieu blomme | 0 | 0 |  |  |  |  |  | 0 |  |  | dempsey voet | 3
[NAME] | 0 | 10 | 15 |  |  |  |  | 25 |  |  | phillipe nottebaert | 1
[NAME] | 6 | 0 | 12 |  |  |  |  | 18 |  |  | [NAME] | 1
niels verbauwhede | 12 | 14 | 5 |  |  |  |  | 31 |  |  | eline bossuyt | 0
peanut | 0 | 0 | 7 |  |  |  |  | 7 |  |  | tijs naert | 0
pedro destadsbader | 0 | 0 | 4 |  |  |  |  | 4 |  |  | matthieu blomme | 0
phillipe nottebaert | 1 | 0 |  |  |  |  |  | 1 |  |  | [NAME] | 0
[NAME] | 0 | 13 |  |  |  |  |  | 13 |  |  | steven dekocker | 0
reza barikro | 7 | 8 |  |  |  |  |  | 15 |  |  | mathieu bruyneel | 0
rudger kerckhove | 0 | 12 | 11 |  |  |  |  | 23 |  |  | mathieu ryckebosch | 0
[NAME] | 0 | 0 |  |  |  |  |  | 0 |  |  | brecht vdv | 0
steven dekocker | 0 | 0 |  |  |  |  |  | 0 |  |  | [NAME] | 0
[NAME] | 0 | 11 |  |  |  |  |  | 11 |  |  | [NAME] | 0
tijs naert | 0 | 0 |  |  |  |  |  | 0 |  |  | leen deweerdt | 0
[NAME] | 0 | 0 |  |  |  |  |  | 0 |  |  | attika delaere | 0
wouter samyn | 0 | 0 |  |  |  |  |  | 0 |  |  | [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | wouter samyn | 0
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | Endtotaal | 360
Spreadsheet: 96843d1296120473-vlookup-help-needed-order-book
Sheet: TOTALS

WEEK ENDING | AMOUNT |  | JOB NAME | TOTAL AMOUNT | AMOUNT DUE | COMPLETION DATE | DAYS TO COMPLETION
TOTAL |  |  | TOTAL
MATCH?
Spreadsheet: 294873d1391530785-how-to-create-a-drop-list-that-populates-the-cell-with-some-other-data-example
Sheet: Sheet1

 | a
 | a |  |  |  |  | •
 | b
 | a |  |  |  |  |  |  |  |  | •
 | a
 | c
 | a
 | a
 | a
Spreadsheet: kimberly_watson__20582__Big Sandy Attachment A Cost Estimate
Sheet: Sheet1

 |  |  |  |  |  |  | Exhibit A
 |  |  |  |  |  |  | Big Sandy Tie In Cost Estimate
 |  |  |  |  |  |  | Estimate Totals
 |  |  | Labor |  | 119707
 |  |  | Materials |  | 142969
 |  |  | Subcontract |  | 252
 |  |  |  |  |  |  | 262928
 |  |  | Freight  (%) |  | 7148 |  |  |  | 0.05
 |  |  |  |  |  |  |  |  | 0.075
 |  |  | Tax  (%) |  | 10723
 |  |  | Pipeline Right of Way  (LS) |  | 2500
 |  |  | Environmental  (LS) |  | 2000
 |  |  | CSUP - Survey (LS) |  | 10000
 |  |  | CSUP - Inspection (LS) |  | 25000
 |  |  | DLAB - District Labor (LS) |  | 2500
 |  |  | Engineering - Enron  (LS) |  | 5000
 |  |  | Engineering - Contract  (LS) |  | 10000
 |  |  | Engineering - AsBuiltDwg  (LS) |  | 13000
 |  |  | PROJECT MANAGEMENT  (LS) |  | 1500
 |  |  | CONTINGENCY  (%) |  |  |  |  |  | 0.1
 |  |  | OVERHEAD  (%) |  |  |  |  |  | 0.105
 |  |  | AFUDC (% of Current Total) |  |  |  |  |  | 0.0496
 |  |  | Tax Gross Up (% of Sub Total) |  |  |  |  |  | 0.3016
 |  |  |  |  | Total
 | Note:  This is a + 30% cost estimate.
Spreadsheet: 539615d1506302761-trying-to-use-conditional-formatting-to-color-the-space-between-two-data-entries-home-owner-schedule-example
Sheet: Sheet1

Home Owner | 123 calle west
 | Check in |  | Check out
2017-09-19 00:00:00 | 07:30:00
2017-09-20 00:00:00
2017-09-21 00:00:00 |  |  | 01:00:00
2017-09-22 00:00:00
2017-09-23 00:00:00
2017-09-24 00:00:00
2017-09-25 00:00:00
2017-09-26 00:00:00
2017-09-27 00:00:00 | 07:30:00
2017-09-28 00:00:00
2017-09-29 00:00:00
2017-09-30 00:00:00
2017-10-01 00:00:00
2017-10-02 00:00:00 |  |  | 04:00:00
2017-10-03 00:00:00
2017-10-04 00:00:00
2017-10-05 00:00:00 | 07:30:00
2017-10-06 00:00:00
2017-10-07 00:00:00
2017-10-08 00:00:00
2017-10-09 00:00:00
2017-10-10 00:00:00 |  |  | 04:00:00
2017-10-11 00:00:00
2017-10-12 00:00:00
2017-10-13 00:00:00
2017-10-14 00:00:00
Spreadsheet: sally_beck__35759__MgmtSum-Q1-0331-PRELIM-C
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON NORTH AMERICA
2000-03-01 00:00:00 | 1ST QUARTER 2000 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
[NAME] | Gas Trading |  |  |  |  |  | Compensation increases related to promotions; Headcount over plan;AA allocations
[NAME] | Power Trading |  |  |  |  |  | Compensation increases, Employee expenses over plan, and Peace consulting fees
IR_FX | Financial Drift |  | 872 |  |  |  | London expenses deferred from 4Q99;Unplanned for relocation,consulting,computer costs
ECT_INV_IRFX | Financial Trading
CANADA | Canada |  | 3306
COAL | Coal |  | 5480 |  |  |  | London expenses deferred from 4Q99; 2 Directors promoted to VP; Current qtr FX loss
WEATHER | GRM -  Weather |  | 2233 |  |  |  | London expenses deferred from 4Q99 & current quarter FX loss;$1MM for consulting fees
SO2 | Emissions |  | 104
INSURANCE | GRM - New Products |  | 1099
EXEC_TRD | Executive Trading
 | Total Trading & Risk Management
E_ORG | East Midstream |  | 2700
W_ORIG | West Midstream |  | 3000
PAPER | Industrial Downstream - Paper
CHEMICALS | Industrial Downstream - Chemicals |  |  |  |  |  | Headcount under plan
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico |  | 1466
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments |  | 1019 |  |  |  | Special pay in January
ASST_ORIG | Gas Assets |  | 4176
ASST_TRD | Gas Assets - Trading |  | 598
 | Total Assets
EQUITY | Principal Investing |  | 783
PROD_FIN | Energy Investments |  | 1740 |  |  |  | Special pay
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group |  | 5988
OF_CHAIR | Office of the Chairman |  | 3698 |  |  |  | RC 2948 - Enron Online related expenses; RC 1708 BtoB expenses w/o plan
 | Total Commercial
GROUP | Group |  |  |  |  |  | Compensation issues
TREASURY_INT | Other Interest Related Charges
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Genco |  | 6640 | 6605
 | Gas Assets |  | 43726
Spreadsheet: 437385d1451318657-conditional-formatting-text-aligment-fill-formatting
Sheet: Sheet1

Date |  |  |  |  |  |  |  |  |  |  |  |  | Reasoning | Review
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | import 2015-12-24 21:02:34
2015-12-28 17:45:45 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa | bbbbbbbbbbbbbbbbbbbbbbbbb
2015-12-28 17:45:45 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
2015-12-28 17:45:53 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
2015-12-28 17:45:55 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | import 2015-12-24 21:02:35
2015-12-28 17:45:58 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaa | bbbbbbbbbbbbbbb
2015-12-28 17:45:58 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaa
2015-12-28 17:46:22 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaa
 |  |  |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaaaaaaaaaaaaaaaaaa
Spreadsheet: 542050d1507697392-vlookup-with-if-statement-report
Sheet: Sheet2

Job | Client | Contact | Product | Staff | [NAME] | Site Start | Base | Frame | [NAME] | Fix | PCI QA | Handover | Sett'ment | Revised | Constr. | Recent Comments
24161 | Villareal |  |  |  | 2016-12-07 00:00:00 | 2017-01-09 00:00:00 | 2017-01-24 00:00:00 | 2017-02-20 00:00:00 | 2017-08-18 00:00:00 | 2017-09-04 00:00:00 | 2017-10-26 00:00:00 | 2017-11-03 00:00:00 | 2017-10-15 00:00:00 | 2017-11-17 00:00:00
PCI |  |  |  |  |  | 2017-01-23 00:00:00 | 2017-01-24 00:00:00 | 2017-02-20 00:00:00 | 2017-08-28 00:00:00 | 2017-09-06 00:00:00
Active |  |  |  |  |  | 2017-01-23 00:00:00
Normal
24163 | Prado |  |  |  | 2017-01-10 00:00:00 | 2017-01-11 00:00:00 | 2017-02-07 00:00:00 | 2017-03-10 00:00:00 | 2017-09-11 00:00:00 | 2017-09-11 00:00:00 | 2017-10-27 00:00:00 | 2017-11-10 00:00:00 | 2017-11-10 00:00:00 | 2017-10-29 00:00:00 | 2017-11-24 00:00:00
PCI |  |  |  |  |  | 2017-02-06 00:00:00 | 2017-02-07 00:00:00 | 2017-03-10 00:00:00 | 2017-09-11 00:00:00 | 2017-09-13 00:00:00
Active |  |  |  |  |  | 2017-02-06 00:00:00
Normal
24250 | Suñiga |  |  |  | 2017-07-27 00:00:00 | 2017-07-27 00:00:00 | 2017-09-19 00:00:00 | 2017-10-06 00:00:00 |  |  |  |  |  | 2018-04-24 00:00:00
[NAME] |  |  |  |  |  | 2017-08-24 00:00:00 | 2017-09-18 00:00:00 | 2017-10-05 00:00:00
Active |  |  |  |  |  | 2017-08-10 00:00:00
Normal
24162 | Galang
Site Start
Active
Normal
Spreadsheet: errol_mclaughlin_jr__10001__DKR_400bp_11-19-01
Sheet: GasDailyVal

Deal Date | Deal # | Code |  | Term Start | Term End | Volume | Price | Nov 1-9 Price | MTM |  | DATE | GDP-KERN/RIVER |  | DATE | GDP-HEHUB
2001-10-23 00:00:00 | YD6643 | Kern | [NAME] | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | -10000 | 2.37 | 2.246 |  |  | 2001-11-01 00:00:00 | 2.725 |  | 2001-11-01 00:00:00 | 3.07
2001-10-24 00:00:00 | YD7298 | Kern | [NAME] | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | -10000 | 2.39 | 2.246 |  |  | 2001-11-02 00:00:00 | 2.45 |  | 2001-11-02 00:00:00 | 3.005
 |  |  |  |  |  |  |  |  |  |  | 2001-11-03 00:00:00 | 2.115 |  | 2001-11-03 00:00:00 | 2.96
2001-10-30 00:00:00 | YF6408 | Kern | [NAME] | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 10000 | 2.605 | 2.246 |  |  | 2001-11-04 00:00:00 | 2.115 |  | 2001-11-04 00:00:00 | 2.96
2001-11-08 00:00:00 | YI5216 | Kern | [NAME] | 2001-11-10 00:00:00 | 2001-11-30 00:00:00 | 10000 | 2.08 |  |  |  | 2001-11-05 00:00:00 | 2.115 |  | 2001-11-05 00:00:00 | 2.96
 |  |  |  |  |  |  |  |  |  |  | 2001-11-06 00:00:00 | 2.22 |  | 2001-11-06 00:00:00 | 2.885
 |  |  |  |  |  |  |  |  |  |  | 2001-11-07 00:00:00 | 2.22 |  | 2001-11-07 00:00:00 | 2.75
 |  |  |  |  |  |  |  |  |  |  | 2001-11-08 00:00:00 | 2.255 |  | 2001-11-08 00:00:00 | 2.735
 |  |  |  |  |  |  |  |  |  |  | 2001-11-09 00:00:00 | 2 |  | 2001-11-09 00:00:00 | 2.725
 |  |  |  |  |  |  |  | Nov 1-9 Price | MTM
2001-10-23 00:00:00 | YD6643 | HH | [NAME] | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 10000 | 2.66 | 2.894
2001-10-24 00:00:00 | YD7298 | HH | [NAME] | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | 10000 | 2.67 | 2.894
 |  |  |  |  |  | 20000
2001-10-30 00:00:00 | YF6408 | HH | [NAME] | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | -10000 | 3.08 | 2.894
2001-11-08 00:00:00 | YI5216 | HH | [NAME] | 2001-11-10 00:00:00 | 2001-11-30 00:00:00 | -10000 | 2.78
 |  |  |  |  |  | -20000
Kern MTM, 10-30 Nov |  | DKR Sells 20,000 per day for 20 days at avg. Price of 2.38 and buys same vol. Back at avg. Price of 2.343
HH MTM, 10-30 Nov |  | DKR Buys 20,000 per day for 20 days at avg. Price of 2.665 and sells same vol. Back at avg. Price of 2.93
Kern MTM 1-9 |  | DKR Sells 20,000 per day for 9 days at average price of 2.665 which settles against 2.246;buys 10,000 per day for 9 days at 2.605 which settles agains 2.246
HH MTM 1-9 |  | DKR Buys 20,000 per day for 9 days at average price of 2.665 which settles against 2.894;sells 10,000 per day for 9 days at 3.08 which settles against 2.894
Total
Libor +400 bp total
Spreadsheet: 710017d1608666443-array-lookup-from-columns-to-rows-stock-report-example
Sheet: Availability

 | RRD COB:
 | SKU # | B-Stock  Available | B1 | B2 | B3 | SHOW
 | ZD-AA87
 | ZD-KL-12 |  | 2 | 1 | 3 | 12 | Notes
 | ZD-KL-12-Q19 |  |  | 1 | 1 | 2 | Example of how it should look.
 | ZD-KL5499 |  |  | 1 |  |  | zeros should be blank
 | ZD-ZD10544 |  |  | 3 | 2 |  | the B1, B2, B3, and SHOW quantities are in the Available DS column on the Inventory Sheet
 | ZD-ZD10545 |  | 1 | 2 | 3 | 77
 | ZD-ZD10546 |  | 3 | 2
 | ZD-ZD10547 |  |  | 2
 | ZD-ZD7000 |  |  | 3
 | ZD-ZD8721 |  |  | 5
 | ZD-ZD8721-100 |  | 6
 | ZD-ZK-64 |  | 7 | 8 | 9
 | ZD-ZK-64-Q |  |  |  | 55
Spreadsheet: 814607d1674506293-return-column-header-based-off-closest-value-test
Sheet: TEST

 |  |  |  |  |  |  |  |  | Class
 |  | H-6 | H-5 | H-4 | H-3 | H-2 | H-1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  | circumference
 | 20 |  |  |  |  |  |  | 80.2 | 75.11 | 70.03 | 64.95 | 59.87 | 54.79 | 51.16
 | 25 |  |  |  |  |  |  | 85.96 | 80.88 | 75.8 | 70.72 | 65.65 | 59.22 | 55.48
 | 30 |  |  |  |  |  |  | 93.72 | 87.31 | 82.23 | 75.83 | 70.75 | 64.35 | 60.59
 | 35 |  |  |  |  | 111.04 | 105.96 | 99.59 | 93.21 | 86.84 | 80.47 | 74.1 | 69.02 | 63.94
 | 40 |  |  | 129.54 | 123.19 | 116.84 | 110.49 | 104.14 | 97.79 | 91.44 | 85.09 | 78.74 | 72.39 | 67.31
Length (ft.) | 45 | 157.95 | 149.64 | 135.29 | 128.95 | 122.62 | 115.03 | 108.7 | 102.37 | 94.78 | 88.44 | 82.11 | 75.78 | 70.7
 | 50 | 153.67 | 147.35 | 139.79 | 133.47 | 127.14 | 119.58 | 113.26 | 105.7 | 98.14 | 91.82 | 85.49 | 79.1 | 72.85
 | 55 | 159.7 | 151.6 | 145.8 | 138 | 130.3 | 124.1 | 116.7 | 109 | 101.6 | 95.4
 | 60 | 163.8 | 156.2 | 148.7 | 142.3 | 135.2 | 127.6 | 97.3 | 107.4 | 112.5 | 120
 | 65 | 168.5 | 160.7 | 153.4 | 146 | 138.3 | 130.9 | 123.1 | 115.8 | 108.5 | 100.7
 | 70 | 171.6 | 165.5 | 158 | 150.5 | 141.5 | 134 | 126.5 | 119 | 111.5 | 103
 | 75 | 176.4 | 168.7 | 161 | 153.9 | 146.2 | 137.4 | 130.3 | 121.5 | 113.8
 | 80 | 179.5 | 172.3 | 164.3 | 157 | 148.6 | 140.7 | 133.4 | 124.9 | 116
 | 85 | 184.1 | 176.6 | 168 | 160.5 | 151.9 | 144.4 | 135.8 | 127.1 | 118.5
 | 90 | 187.3 | 179.7 | 171.5 | 163.9 | 155 | 146.8 | 137.9 | 130.3 | 120.8
 | 95 | 191.6 | 183.8 | 175.4 | 166.3 | 159.2 | 150.1 | 140.3 | 133.2
 | 100 | 195.6 | 187.7 | 179.1 | 170.5 | 161.8 | 153.2 | 144.6 | 135.9
 | 105 | 197.8 | 189.7 | 181.7 | 173.6 | 164.8 | 154.5 | 145.8 | 137.7
 | 110 | 202.3 | 193.3 | 184.3 | 176.1 | 167.1 | 158.9 | 149.1 | 140.1
 | 115 | 205.9 | 197.5 | 188.4 | 178.3 | 170 | 161.6 | 151.6 | 142.4
 | 120 | 210.2 | 200 | 191.5 | 182.9 | 172.7 | 164.1 | 153.9 | 145.4
 | 125 | 212.7 | 204 | 193.5 | 184.8 | 175.2 | 166.5 | 156.9 | 146.5
 |  |  |  |  |  |  |  | Height (m): | 45 | <--Enter in a value from Colum B (20-125) |  |  |  | Class: |  | <--With the values entered as length of 45' and circumference of 103, I would like the formula to return value of the column header to be the closest value displayed based off of the 2 values entered. As of now, It's giving the higher value (108.7) Class 1 when it should be showing (102.37)Class 2.
 |  |  |  |  |  |  |  | Circumference (m): | 106 | <--Enter in any value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <--With the values entered as length of 45' and circumference of 103, I would like the return value of the column header to be the lower value displayed. It should be showing Class 2 (102.37).
Spreadsheet: 140272d1328674556-filling-individual-answers-in-their-groups-fillingindanswerstogroup
Sheet: Sheet1

Group | Answer
1
1
1 | yes
2
2 | no
2
3
3
3 | yes
3
4
4
5
5 | yes
5
5
5
6
6
7
7
7
7
8
8 | no
Spreadsheet: 14756f7a-a414-438a-b6cb-770666ed2553
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | FORM A
INTERNATIONAL CIVIL AVIATION ORGANIZATION
AIR TRANSPORT REPORTING FORM
TRAFFIC - COMMERCIAL AIR CARRIERS
Contact person: |  |  | State:
Organization: |  |  | Air carrier:
Tel:
Fax: |  |  | Month (s) :
E-mail: |  |  | Year:
 |  |  |  | TOTAL ALL SERVICES
 |  |  |  | (passenger, mail and freight |  |  |  | ALL-FREIGHT SERVICES ONLY
 |  |  |  | including all-freight) |  |  |  | (included in columns c and d data)
ICAO | Description | Unit |  | Classified by flight stage |  |  |  | Classified by flight stage
code |  |  | International |  | Domestic |  | International |  | Domestic
 | a | b | c |  | d |  | e |  | f
 | SCHEDULED REVENUE FLIGHTS
1010 | 1.   Aircraft kilometres | 000
1020 | 2.   Aircraft departures | number
1030 | 3.   Aircraft hours | number
1040 | 4.   Passengers carried | number |  |  |  |  | - - |  | - -
1050 | 5.   Freight tonnes carried | number
1060 | 6.   Passenger-kilometres performed | 000 |  |  |  |  | - - |  | - -
1070 | 7.   Seat-kilometres available | 000 |  |  |  |  | - - |  | - -
1080 | 8.   Passenger load factor | % |  |  |  |  | - - |  | - -
1091 | 9.   [NAME] performed                                       .     a)  passengers (incl. baggage) | 000 |  |  |  |  | - - |  | - -
1092 | b)  freight (incl. express) | 000
1093 | c)  mail | 000
1094 | d) total (9a to 9c) | 000
1100 | 10.  [NAME] available | 000
1110 | 11.  Weight load factor | %
2010 | NON-SCHEDULED REVENUE FLIGHTS                12.   Aircraft kilometres | 000
2020 | 13.   Aircraft departures | number
2030 | 14.   Aircraft hours | number
2040 | 15.   Passengers carried | number |  |  |  |  | - - |  | - -
2050 | 16.   Freight tonnes carried | number
2060 | 17.   Passenger-kilometres performed | 000 |  |  |  |  | - - |  | - -
2070 | 18.   Seat-kilometres available | 000 |  |  |  |  | - - |  | - -
2091 | 19.   [NAME] performed                                       .     a)  passengers (incl. baggage) | 000 |  |  |  |  | - - |  | - -
2092 | b)  freight (incl. express) | 000
2093 | c)  mail | 000
2094 | d)  total (19a to 19c) | 000
2100 | 20.   [NAME] available | 000
2330 | NON REVENUE FLIGHTS 21. Aircraft hours | number
Remarks (including a description of any unavoidable deviation (s) from reporting instructions):
Spreadsheet: 120897d1315610296-complex-data-reorganization-question-extract-header-pairs-from-2d-table
Sheet: Sheet1

What I have now: |  |  |  |  |  | [NAME]
 | z | y | w | v | u | 0
a |  | x | x |  | x
b | x |  |  | x
c |  |  | x
d |  |  |  | x
e |  | x
f | x |  |  | x
g |  | x | x
h |  |  |  |  | x
What I want to automate: the header of every 'x' cell in a column ends up next to the leader of the appropriate row.
Each row header would end up on a separate line with its row leader mate. See below:
Is it possible to extract the data this way?
Spreadsheet: 271131d1381839613-need-a-lookup-formula-to-return-a-specific-result-speedtracker
Sheet: Sheet1

 |  |  |  |  |  | [NAME] | 0.1 | 17
Speed |  |  |  |  |  | 21
19 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
18 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
17 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
16 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
14 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
13 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
12 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
11 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
10 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
9 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
8 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
7 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
6 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
5 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | 0.02 | 0.025 | 0.05 | 0.075 | 0.1 | 0.125 | 0.15 | 0.175 | 0.2 | 0.225 | 0.25 | 0.275 | 0.3
Est Speed |  | Reps | Elevation | Type | Time | % | Rest
 |  | 3 | 0.2 | R | 10s | 0.8
I need to look up the % under elevation (yellow), find the [NAME] speed at the top, then return the number under A column (speed). For example, if elevation is 20% and [NAME] speed is 21, I need to return 13 in the blue box.
Spreadsheet: 738335d1624977633-formula-words-from-one-cell-appear-in-another-returns-result-sample-of-data-need-formula
Sheet: Sheet1

Full Title | [NAME] value of Column E based on all words in Column D appearing in Column A |  | Title | Persona
Recruiting Director |  |  | Director Recruiting | Talent Acquistion Leader
SVP, Talent |  |  | VP Talent | Talent Acquistion Leader
Tech Recruiter |  |  | Recruiter Technical | Front Line Recruiter
Recruiting Director |  |  | Director Recruiting | Talent Acquistion Leader
Senior Technical Recruiter |  |  | Director Talent Acquisition | Talent Acquistion Leader
Recruiting Director |  |  | Director [NAME] | Hiring Manager
Director of Talent Acquisition |  |  | VP Recruitment | Talent Acquistion Leader
Senior Director of Engineering |  |  | Manager Talent Acquisition | Recruiting Player-Coach
Director [NAME] |  |  | Director Talent Acquisition | Talent Acquistion Leader
Director, Recruiting & Workforce Development |  |  | Head of  Talent Acquisition | Talent Acquistion Leader
Talent Acquisition, Connections Director
VP Talent Acquisition
Head of Talent Acquisition
Technical Recruiter
Manager, Talent Acquisition
Assistant VP, Recruitment
RESULT
Full Title | Persona
Recruiting Director | Talent Acquistion Leader
SVP, Talent | Talent Acquistion Leader
Tech Recruiter | Front Line Recruiter
Recruiting Director | Talent Acquistion Leader
Senior Technical Recruiter | Front Line Recruiter
Recruiting Director | Talent Acquistion Leader
Director of Talent Acquisition | Talent Acquistion Leader
Senior Director of Engineering | Hiring Manager
Director [NAME] | Hiring Manager
Director, Recruiting & Workforce Development | Talent Acquistion Leader
Talent Acquisition, Connections Director | Talent Acquistion Leader
VP Talent Acquisition | Talent Acquistion Leader
Head of Talent Acquisition | Talent Acquistion Leader
Manager, Talent Acquisition | Recruiting Player-Coach
Assistant VP, Recruitment | Talent Acquistion Leader
Recruiting Director | Talent Acquisition Leader
SVP, Talent | Talent Acquisition Leader
Tech Recruiter
Recruiting Director | Talent Acquisition Leader
Junior Recruiter | Default
Senior Technical Recruiter
Recruiting Director | Talent Acquisition Leader
Recruiting Director | Talent Acquisition Leader
Recruiting Director | Talent Acquisition Leader
Director of Talent Acquisition
Senior Director of Engineering | Default
Global Manager, TA
Talent Acquisition, Connections Director
Product Manager
Product Manager
VP Talent Acquisition
Head of Talent Acquisition | India Talent Acquisition and [NAME]
Technical Recruiter