tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35164__MgmtSum-Q3-0921_Global
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  | 3RD QTR 2000 EARNINGS ESTIMATE
 |  |  |  |  |  |  |  |  |  |  |  | Results based on activity through September 21, 2000
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME]
Liquids |  | 3959 | 20000 | -16041 |  | 15921 | 14096 | -1825 |  | -11962 | 5904 | -17866
Coal |  | -4439.766000000001 | 12747 | -17186.766 |  | 6632.291999999999 | 4881.7 | -1750.591999999999 |  | -11072.058 | 7865.3 | -18937.358
Emissions |  | 2458 | 750 | 1708 |  | 415.01 | 340.5 | -74.51 |  | 2042.99 | 409.5 | 1633.49
Weather |  | 3238.305 | 3215 | 23.30499999999984 |  | 1655.8 | 1655.8 | 0 |  | 1582.505 | 1559.2 | 23.30499999999984
Global Risk Markets |  | 0 | 7712 | -7712 |  | 2028.2 | 1618.2 | -410 |  | -2028.2 | 6093.8 | -8122
Financial Trading |  | 15098.221 | 8947 | 6151.221000000001 |  | 3693.043 | 3377.4 | -315.6429999999996 |  | 11405.178 | 5569.6 | 5835.578000000001
Overview |  | 0 | 6786 | -6786 |  | 0 | 0 | 0 |  | 0 | 6786 | -6786
Office of the Chairman |  | 0 | 0 | 0 |  | 350 | 0 | -350 |  | -350 | 0 | -350
Total Commercial |  | 20313.76 | 60157 | -39843.24 | 0 | 30695.345 | 25969.6 | -4725.744999999999 |  | -10381.585 | 34187.4 | -44568.985
Other Interest Related Charges |  | -516.832 | -538.419 | 21.58699999999999 |  | 0 | 0 | 0 |  | -516.832 | -538.419 | 21.58699999999999
Capital Charge Offset |  | 0 | 0 | 0 |  | -665 | -783 | -118 |  | 665 | 783 | -118
Global Markets EBIT |  | 19796.928 | 59618.581 | -39821.65300000001 |  | 30030.345 | 25186.6 | -4843.744999999999 |  | -10233.417 | 34431.981 | -44665.398
Interest Expense/(Income) |  | 0 | 0 | 0 |  | -1336 | -1336 | 0 |  | 1336 | 1336 | 0
Global Markets Pre-tax Income |  | 19796.928 | 59618.581 | -39821.65300000001 |  | 28694.345 | 23850.6 | -4843.744999999999 |  | -8897.416999999998 | 35767.981 | -44665.398
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 22796d1211956751-high-column-a-and-low-column-b-output-name-column-c-value-column-d-to-column-e-and-f-example1
Sheet: Sheet1

Company | Current Value | Potential Additional Value | Diff | Quadrent | QuadID |  | Company | Potential Added $
Burswood | 0 | 3100 | 3100 | Light Gray | 4 |  | InfoHealth System P | 115904
DET | 0 | 17333.33 | 17333.33 | Orange | 1 |  | InfoHealth Storage | 127500
CBH Group | 6600 | 6250 | -350 | BLUE | 2 |  | ICWA | 50383
Curtin Uni | 15000 | 1850 | -13150 | [NAME] | 3 |  | InfoHealth TSM HW | 39923
Total Eden (CSG) MS | 0 | 4800 | 4800 | Light Gray | 4 |  | V | 20000
ICWA | 0 | 50383 | 50383 | Orange | 1 |  | W | 19000
Uni Notre Dame | 0 | 10000 | 10000 | Orange | 1 |  | C | 18000
AFG | 0 | 2868 | 2868 | Light Gray | 4 |  | X | 18000
Fleetwood | 0 | 10000 | 10000 | Orange | 1 |  | DET | 17333.33
InfoHealth Storage | 0 | 127500 | 127500 | Orange | 1
InfoHealth System P | 0 | 115904 | 115904 | Orange | 1
InfoHealth SAN Switch | 0 | 21007 | 21007 | Orange | 1
InfoHealth TSM HW | 0 | 39923 | 39923 | Orange | 1
C | 2000 | 18000 | 16000 | Orange | 1
D | 3000 | 17000 | 14000 | Orange | 1
E | 4000 | 16000 | 12000 | Orange | 1
F | 5000 | 15000 | 10000 | Orange | 1
G | 6000 | 14000 | 8000 | BLUE | 2
H | 7000 | 13000 | 6000 | BLUE | 2
I | 8000 | 12000 | 4000 | BLUE | 2
J | 9000 | 11000 | 2000 | BLUE | 2
K | 10000 | 10000 | 0 | BLUE | 2
L | 11000 | 9000 | -2000 | BLUE | 2
M | 12000 | 8000 | -4000 | BLUE | 2
N | 13000 | 7000 | -6000 | BLUE | 2
O | 14000 | 6000 | -8000 | BLUE | 2
P | 15000 | 5000 | -10000 | BLUE | 2
Q | 16000 | 4000 | -12000 | [NAME] | 3
R | 17000 | 3000 | -14000 | [NAME] | 3
S | 18000 | 2000 | -16000 | [NAME] | 3
T | 19000 | 1000 | -18000 | [NAME] | 3
U | 20000 | 16000 | -4000 | BLUE | 2
V | 1000 | 20000 | 19000 | Orange | 1
W | 2000 | 19000 | 17000 | Orange | 1
X | 3000 | 18000 | 15000 | Orange | 1
Spreadsheet: richard_shapiro__32619__Attachment A
Sheet: Sheet1

Month | OR | WA
2000-01-01 00:00:00 | -96068.88 | -206830.86
2000-02-01 00:00:00 | -843804.64 | -173087.26
2000-03-01 00:00:00 | 507482.96 | -159180.46
2000-04-01 00:00:00 | -604307.48 | 163728.29
2000-05-01 00:00:00 | -305739.71 | 58102.57
2000-06-01 00:00:00 | -170969.89 | -28667.51
2000-07-01 00:00:00 | -98660 | 4188
2000-08-01 00:00:00 | -456236 | 325611
2000-09-01 00:00:00 | 399114 | 401223
2000-10-01 00:00:00 | -232875.22 | 215955
2000-11-01 00:00:00 | -1524889 | -376936
2000-12-01 00:00:00
Total
Spreadsheet: 297378d1392376538-incrementing-dates-and-then-pasting-date-as-value-dates
Sheet: Sheet1

 |  | Date | actual real date
So as real date increases, the date in column C is populated. The problem is that I don't know how many rows of todays date I am going to have in column D -->
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-15 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
 |  | 2014-02-16 00:00:00 | 2014-02-16 00:00:00
Spreadsheet: 542268d1507778243-lookup-many-not-standard-data-test-1-
Sheet: Sheet2

Lookup table | Rating | Master Table | Rating | Similarity
binus elektro | -2146826259 | Binus teknik elektro | A | 0.95
STIE BINA BANGSA BANTEN | -2146826259 | stie bina bangsa | B | 0.888888888888889
Bina bangsa elektro | -2146826259 | [NAME] | C | 0.9852216748768474
Lookup table | Master Table | Rating | Similarity
binus elektro | Binus teknik elektro | A | 0.92
STIE BINA BANGSA BANTEN |  |  | 0
Bina bangsa elektro | [NAME] | C | 0.935960591133005
Spreadsheet: 105655d1302953373-multiple-rows-into-one-column-excel2
Sheet: Arkusz1

 | IS RIGHT NOW
 | 1998 | 1999 | 2000 | 2001 | 1998 | 1999 | 2000 | 2001
Goldbach Media AG | 8.259465047163717 | 9.487291849255039 | 10.62194901464473 | 13.32553606237817 | 0.2350998844312366 | 0.5904202101050525 | 0.0001732482972940782 | 0.000140181675451385
 | SHOULD BE
Year | Company | EBIT | Leverage
1998 | Goldbach Media AG | 8.259465047163717 | 0.2350998844312366
1999 | Goldbach Media AG | 9.487291849255039 | 0.5904202101050525
2000 | Goldbach Media AG | 10.62194901464473 | 0.0001732482972940782
2001 | Goldbach Media AG | 13.32553606237817 | 0.000140181675451385
Spreadsheet: 876692d1723432402-xlookup-formula-or-alternative-to-look-the-data-by-its-occurence-xlookup
Sheet: Sheet1

 |  |  |  |  | [NAME]
CAT | Name | Salary |  | CAT | Name
Engineer | Raju | 10000 |  | Engineer | Raju
Senior Engineer | Ramu | 20000 |  | Engineer | Vijay
Senior Engineer | Ravi | 18000 |  | Senior Engineer | Ramu
Engineer | Vijay | 8000 |  | Senior Engineer | Ravi
Spreadsheet: 4de2faf1-9b1b-4320-a9cb-f249fdf5c393
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PAMY | Test | PAMY | Amylase, Pancreatic, Serum | Amylase, Pancreatic, S | Monoclonal Antibody Technique | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | 0-<24 months: 0-20 U/L 2-<18 years: 9-35 U/L > or =18 years: 11-54 U/L | Monday through Friday | 1 day (not reported on Saturday or Sunday) | 4 days | 1 | 82150 |  |  |  |  | Rochester
PAMY | [NAME] | SERUM | Serum |  |  |  | Refrigerated
PAMY | Result | PAMY | Amylase, Pancreatic, S | Amylase, Pancreatic, S | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 1805-1
Spreadsheet: 35065d1232572477-adding-data-with-multiple-conditions-test
Sheet: Outputs

Hours | Weeks
 | 2009-02-08 00:00:00 | 2009-03-08 00:00:00 | 2009-04-05 00:00:00 | 2009-05-03 00:00:00 | 2009-05-31 00:00:00 | 2009-06-28 00:00:00 | 2009-07-26 00:00:00 | 2009-08-23 00:00:00 | 2009-09-20 00:00:00 | 2009-10-18 00:00:00 | 2009-11-15 00:00:00 | 2009-12-13 00:00:00 | 2010-01-10 00:00:00 | 2010-02-07 00:00:00 | 2010-03-07 00:00:00 | 2010-04-04 00:00:00 | 2010-05-02 00:00:00
ResourceID | 2009-03-07 00:00:00 | 2009-04-04 00:00:00 | 2009-05-02 00:00:00 | 2009-05-30 00:00:00 | 2009-06-27 00:00:00 | 2009-07-25 00:00:00 | 2009-08-22 00:00:00 | 2009-09-19 00:00:00 | 2009-10-17 00:00:00 | 2009-11-14 00:00:00 | 2009-12-12 00:00:00 | 2010-01-09 00:00:00 | 2010-02-06 00:00:00 | 2010-03-06 00:00:00 | 2010-04-03 00:00:00 | 2010-05-01 00:00:00 | 2010-05-29 00:00:00
1 | 6 | 8 | 8 | 8 | 8 | 8 | 8 | 6
2 | 12 | 16 | 16 | 16 | 16 | 16 | 16 | 12
3 | 45 | 36 | 12 | 12 | 12 | 12 | 12 | 9
4 | 0 | 20 | 20 | 20 | 20 | 20 | 15 | 0
5 | 12 | 16 | 16 | 16 | 16 | 16 | 16 | 12
6 | 24 | 32 | 32 | 32 | 32 | 32 | 32 | 24
7 | 30 | 30 | 20 | 20 | 20 | 20 | 20 | 15
8 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 3
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 10 | 20 | 15 | 0 | 0 | 0 | 0 | 0
12 | 0 | 20 | 15 | 0 | 0 | 0 | 0 | 0
13 | 0 | 20 | 15 | 0 | 0 | 0 | 0 | 0
14 | 0 | 8 | 12 | 0 | 0 | 0 | 0 | 0
15 | 6 | 12 | 9 | 0 | 0 | 0 | 0 | 0
16 | 6 | 12 | 9 | 0 | 0 | 0 | 0 | 0
17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | 0 | 0 | 5 | 20 | 20 | 20 | 20 | 15
20 | 0 | 0 | 4 | 16 | 16 | 16 | 16 | 12
21 | 0 | 0 | 5 | 15 | 0 | 0 | 0 | 0
22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 101513d1299620847-combining-tasks-khank
Sheet: Sheet1

284 |  | <<Do this formula in B1 and copy down
884
182 |  | <<Then create an auto filter and don't show blanks
058
711
119
699
452
805
345
290
215
200
542
432
551
398
423
287
966
Spreadsheet: 10497c8a-fba8-4944-97dc-243d1f1fd023
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
NETT | Test | NETT | Nettle, IgE | Nettle, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
NETT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
NETT | Result | NETT | Nettle, IgE | Nettle, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6186-1 | Urtica [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 4237bc20-b192-4da8-9b9d-102a3d6ecfa3
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ARSAW | Test | ARSAW | Arylsulfatase A, Leukocytes | Arylsulfatase A, Leukocytes | Colorimetric Enzyme Assay | Yellow-Top (ACD) Tube: ACD |  |  | 7 | mL | [NAME] must arrive within 48 hours of draw to be stabilized. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: Yellow top (ACD solution A) [NAME]: 7 mL Collection Instructions: Do not transfer blood to other containers.  Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 5 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	Specimen >48 hours old | > or =62 nmol/h/mg Note: Results from this assay may not reflect carrier status because of individual variation of arylsulfatase A enzyme levels. Low normal values may be due to the presence of pseudodeficiency gene or carrier gene. Patients with these depressed levels may be phenotypically normal. | Specimens are processed Monday through Sunday.  Assay is performed Thursday; 8 a | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
ARSAW | [NAME] | ACDZ | [NAME] ACD |  |  |  | Refrigerated | 48 hours
ARSAW | Result | 8779 | Arylsulfatase A, Leukocytes | Arylsulfatase A, Leukocytes | Numeric |  |  |  |  | nmol/h/mg |  |  |  |  |  |  |  |  |  | 24078-8 | Cerebroside sulfatase:CCnt:Pt:WBC:Qn:
ARSAW | Result | 32437 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
ARSAW | Result | 32438 | Reason for referral | Reason for referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
ARSAW | Result | 32439 | Reviewed by | Reviewed by | Numeric
Spreadsheet: 03c35933-326e-4af4-bff9-47d725caf011
Sheet: 1-Cover Page

 | 1-Cover Page
 | Colorado Department of Education/Office of Grants Fiscal
 |  | CFDA #:   84.002                  GRANT CODE:  5002
 | Program | Adult Education and Literacy Budget Form
1 | AGENCY NAME: |  | Do not enter a program name.
2 | 9- DIGIT DUNS #:
3 | REGISTERED WITH SYSTEM OF AWARD MANAGEMENT (SAM):
4 | select Original or Revised Budget Report:
5 | Revision number:
6 | Date:
 | Person completing this information | Program Manager/Program Name | Fiscal Manager
7 | Name: |  |  |  |  | 5
8 | Phone No.: |  |  |  |  | 6
9 | E-mail: |  |  |  |  | 7
10 | Electronic file to this e-mail address: | [EMAIL]
 | Grants Fiscal Staff Contact | Phone No.      E-mail Address
 | [NAME] | [PHONE]       [EMAIL]
 | Version: | 14-15v9
Spreadsheet: 147250d1332654710-split-a-dollar-figure-into-the-minimum-pieces-of-currency-for-refund-in-the-wallet-bvj-
Sheet: Sheet1

my Wallet | Denomiinations | Breakdown | workspace
48119.19 | 100 | 481 Hundreds | 19.19
 | 50 | 0 Fifties | 19.19
 | 20 | 0 Twenties | 19.19
 | 10 | 1 Ten | 9.19
 | 5 | 1 Five | 4.19
 | 1 | 4 Ones | 0.19
 | 0.25 | 0  Quarters | 0.19
 | 0.1 | 1  Dime | 0.09
 | 0.05 | 1  Nickel | 0.04
 | 0.01 | 4  Pennies
Spreadsheet: 724584d1616249103-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - Aterro Sanitario

 |  | CENTROS DE CUSTOS
 |  | ATERRO SANITARIO
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-09-27 00:00:00 | Combustivel | 54703 | 2169.85 | Logistica
 |  | 2020-10-12 00:00:00 | Combustivel | 54788 | 5568.8 | Gerador
 |  | 2020-10-17 00:00:00 | Combustivel | 54815 | 2784.4 | Gerador
 |  | 2020-10-23 00:00:00 | Combustivel | 54848 | 1789.95 | Compressor
 |  | 2020-11-02 00:00:00 | Combustivel | 54917 | 2151.2 | Logistica
 |  | 2020-11-10 00:00:00 | Combustivel | 54972 | 3860.4 | Compressor
 |  | 2020-11-10 00:00:00 | Combustivel | 54972 | 696.1 | Cut Machine
 |  | 2020-11-18 00:00:00 | Combustivel | 55023 | 1679.7 | Logistica
 |  | 2020-11-20 00:00:00 | Combustivel | 55038 | 1258.1 | Logistica
 |  | 2020-12-08 00:00:00 | Combustivel | 55151 | 1365.76 | TLB 315 SL
 |  | 2020-12-16 00:00:00 | Combustivel | 55224 | 678.9 | Saltitao
 |  | 2020-12-16 00:00:00 | Combustivel | 55224 | 678.9 | [NAME]
 |  | 2021-02-09 00:00:00 | Combustivel | 55568 | 1018.35 | Compressor
 |  | 2021-02-15 00:00:00 | Combustivel | 55612 | 339.45 | Saltitao
Spreadsheet: 593397d1539121048-pulling-previous-averages-based-on-combo-box-example-1
Sheet: Overview

 |  |  |  |  |  | 2018-11-01 00:00:00
Element | Question | Plant1 | Plant2 | Plant3 | Current Average | Previous Average | 6 Month Average | YTD Average
Element1 | Question1
Element2 | Question1
 | Question2
Element3 | Question1
Spreadsheet: 731569d1620413700-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: AURA

S.N. | Particulars | Bought Units | Unit or  AURA Price | Bought/ Sold Price ($US) | Bought/ Sold Price (ETH) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated Price ($US) | Status | Notes
1 | [NAME] |  |  |  | -1.001389 | 843 | 2018-02-13 00:00:00 | 2018-02-13 00:00:00
2 | Fees for transferring [NAME] from Idex to [NAME] (MEW) | -6.554707833 |  |  |  |  | 2018-02-13 00:00:00
3 | [NAME] | -2630.98852576 | 0.00029999 |  |  | 979.05 | 2018-02-17 00:00:00
 |  | -660 | 0.00029 |  |  | 979.05 | 2018-02-17 00:00:00
 |  | -200 | 0.0002800400001 |  |  | 979.05 | 2018-02-17 00:00:00
4 |  |  |  |  |  |  | 2018-02-26 00:00:00
5 | [NAME] | -192.593438136 | 0.000261 |  |  | 632.58 | 2018-04-22 00:00:00
 | Next Buy
 | [NAME] in [NAME] (MEW) | 0
 | [NAME] in Idex | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://www.auroradao.com
 | Contract address: 	0xcdcfc0f66c522fd086a1b725ea3c0eeb9f9e8814
 | Symbol: AURA
 | Decimals: 18
 | About/Idea
 | The team also locks their tokens for 3 years (which should be a standard for all ICOs so that its ecosystem can evolve). This gives me the security of knowing that they are not in it for quick gains and it is also gives them great motivation to work 24/7 so that they can reap the benefits in 3 years.
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 466859d1466483516-vlookup-of-multiple-criteria-cse-double-lookup-for-names
Sheet: Sheet1

First | Last | Value
[NAME] | Smith | 5 |  | [NAME] | White |  | << Try this formula
[NAME] | Thompson | 7 |  |  |  |  | It is a CSE or Array formula and needs to be entered using a Control+Shift+Enter keystroke
[NAME] | Jones | 9
[NAME] | Jones | 22
Betty | White | 48
[NAME] | White | 6
Spreadsheet: 708058d1607602973-average-age-of-a-group-of-years-to-2020-copy-of-cd-collection-1
Sheet: Sheet1

CD Collection
Artist | Album Name | [NAME] | no of tracks | price | release year | PPT
[NAME] | The Legend | Reggae | 12 | 9.99 | 1984
Public Enemy | Nation of Millions | [NAME] | 16 | 8.99 | 1988
The Doors | Strange Days | Rock | 10 | 12.99 | 1967
[NAME] | Club Classics | Dance | 20 | 11.99 | 2016
The Prodigy | Fat of the Land | Dance | 10 | 12.45 | 1997
Cheech and Chong | The Big Bambu | [NAME] | 10 | 5.99 | 1972
Grand Master [NAME] | The Message | [NAME] | 14 | 7 | 1982
Run DMC | Tougher Than Leather | [NAME] | 12 | 9.99 | 1988
The KLF | White Room | House | 9 | 8.99 | 1991
[NAME] | Classic House | House | 17 | 7.99 | 2016
Total money spent
Maximum number of tracks on a CD
Minimum number of tracks on CD
Average price of CD
Number of CDs
Average age of album in years
Spreadsheet: 09435dd2-c913-4822-b863-7bcbe1a1ada6
Sheet: 1994

RANK | NAME OF EMPLOYER | NATURE OF BUSINESS | EMPLOYEES(1)
1 | HARVARD UNIVERSITY | Education | 8981
2 | MASSACHUSETTS INSTITUTE OF TECHNOLOGY | Education | 8540
3 | CITY OF CAMBRIDGE | Government | 5072
4 | POLAROID | Photo and Optic Equipment | 2062
5 | MT AUBURN HOSPITAL | Medical | 2056
6 | LOTUS DEVELOPMENT CORPORATION | Computer Software | 1552
7 | DRAPER LABORATORY | Research and Development | 1439
8 | ARTHUR D. LITTLE, INC. | Research and Development | 1377
9 | BOLT, BERANEK and NEWMAN | Research and Development | 1185
10 | YOUVILLE HOSPITAL | Medical | 850
11 | STAR MARKET | Retail | 846
12 | CRIMSON TRAVEL/THOMAS COOK | Travel Services | 771
13 | BADGER ENGINEERING | Construction | 748
14 | U. S. DEPT. OF TRANSPORTATION | Government | 700
15 | CAMP, DRESSER and MCKEE | Engineering | 700
16 | GENETICS INSTITUTE | Research and Development | 500
17 | BAYSTATE HEALTH CARE | Medical | 470
18 | STRIDE RITE | Footware | 466
19 | GENZYME | Biotechnology | 459
20 | BIORAN | Clinical Testing Services | 450
21 | HARVARD COOPERATIVE SOCIETY | Retail | 440
22 | WHITEHEAD INSTITUTE | Research and Development | 428
23 | LESLEY COLLEGE | Education | 401
24 | BIOGEN | Biotechnology | 370
25 | ABT ASSOCIATES | Research and Development | 364
Spreadsheet: 01fb1f93-59a2-475e-b90a-a338338b72df
Sheet: K-12; 4 day week

Grade Group - K-12 |  |  | Menu Name:
 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  |  |  |  |  |  | Weekly Requirement Met True/False or Yes/No |  |  | Decimal Equivalents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/8 Cup | 0.125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4 Cup | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/8 Cup | 0.375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/2 Cup | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/8 Cup | 0.625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/4 Cup | 0.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7/8 Cup | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Cup | 1
Grains (1 Oz Eq per day)  (5.5-8 Oz Eq per week) |  | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq Grain | Total OzEq WGR | % WGR | ≥ 50% Yes/ No | Wkly Grain Total (Grain + M/MA)
Daily Req Met Y/N
M/MA (NOT required) (Counts toward weekly grain total) |  | OzEq M/MA |  | OzEq M/MA |  | OzEq M/MA |  | OzEq M/MA |  | Total OzEq M/MA
Fruit & Veg (1/2 cup per day) (2 cups per week) |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Total Cups F&V
Daily Req Met Y/N
[NAME] (1 Cup per day) (4 cups per week) (White Skim or 1%; [NAME]) |  | Cups of Milk |  | Cups of Milk |  | Cups of Milk |  | Cups of Milk |  | Total Cups of Milk
Daily Req Met Y/N
Spreadsheet: 49539d1248890469-rank-then-fill-value-in-new-cell-rank-value-formula
Sheet: Sheet1

 | Ons | Deal | Turn | Lap | Total | Rank | Profile  WATCH
[NAME] | 1 | 0 | 0 | 8 | 9 | 1 | Rank name1 | Total from Rank 1
Bean | 0 | 1 | 6 | 0 | 7 | 2 | Rank name 2 | Total from Rank 1
[NAME] | 0 | 0 | 1 | 0 | 1 | 11 | Rank name 3 | Total from Rank 1
Garrett | 0 | 5 | 0 | 1 | 6 | 3 | Rank name 4 | Total from Rank 1
Gowings | 0 | 0 | 2 | 1 | 3 | 6
Helpher | 0 | 4 | 1 | 0 | 5 | 4
[NAME] | 1 | 1 | 2 | 0 | 4 | 5
Link | 1 | 0 | 0 | 0 | 1 | 11
Manning | 0 | 1 | 0 | 2 | 3 | 6
Moore | 1 | 0 | 1 | 0 | 2 | 9
[NAME] | 0 | 0 | 0 | 3 | 3 | 6
Young | 0 | 0 | 2 | 0 | 2 | 9