tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 712087d1610044889-2-formulas-in-one-cell-estimate-example
Sheet: Sheet1

 | Codes | Description | Units | Discount | Fee
 |  | PREMLIMINARY CONSULTS AND WORKUPS
 | D0150 | Pre-operative Examination/ Consult | 0 | 0 | No Charge
 | 70355 / D0330 | Orthopantogram, pre-op | 0 | 0
 | 70486 / D0330 | Maxillofacial CBCT (3-D cone-beam) | 1 | 0
 | D0470 | Treatment planning w/ Diagnostic Casts/Photos | 0 | 0
 | D9999 | Laboratory consult w/ computerized planning | 0
 | D6190 | Computerized Lab Stents | 0
 | D6190 | Custom Stents | 0
 | D5820 / 21 | Temporary Upper and Lower Dentures | 0
 |  | PHASE I SURGERY IMPLANT INSERTATION +/- GRAFTING
 | D9223 | General Anesthesia | 0 |  | None
 | D7140 | Simple Extractions | 0
 | D7210 | Surgical Extractions | 0
 | D6010 | [NAME] | 0
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: NE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 10759654 |  |  |  | -4527896
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 59201d1259691032-match-formula-pick4matchformula09
Sheet: Sheet2

 |  |  | 8415
6413 | 1913 | 1463 | 1408
6414 | 1914 | 1464 | 1409
6415 | 1915 | 1465 | 1410
6415 | 1915 | 1465 | 1410
6416 | 1916 | 1466 | 1411
6417 | 1917 | 1467 | 1412
8213 | 3713 | 3263 | 3208
8214 | 3714 | 3264 | 3209
8215 | 3715 | 3265 | 3210
8215 | 3715 | 3265 | 3210
8216 | 3716 | 3266 | 3211
8217 | 3717 | 3267 | 3212
8411 | 3911 | 3443 | 3416
8412 | 3912 | 3444 | 3417
8413 | 3913 | 3445 | 3418
8413 | 3913 | 3445 | 3418
8414 | 3914 | 3446 | 3419
8415 | 3915 | 3447 | 3420
8493 | 3993 | 3461 | 3488
8494 | 3994 | 3462 | 3489
8495 | 3995 | 3463 | 3490
8495 | 3995 | 3463 | 3490
8496 | 3996 | 3464 | 3491
8497 | 3997 | 3465 | 3492
Spreadsheet: 678514a6-38bf-4ee9-aa81-48e4001b6440
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (6 Entries):
 | 2 Analysis 2.4 Spectroscopes 2.4.12 Nuclear magnetic resonance spectrometers (NMR)
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Agilent Technologies Sales & Services GmbH & Co. [NAME] | Germany | Waldbronn | 76337 | A2.105/206
2 | Bruker Biospin GmbH | Germany | Rheinstetten | 76287 | A2.331/432
3 | Bruker Corporation | USA | Billerica | MA 01821 | A2.331/432
4 | Jeol (Germany) GmbH | Germany | Eching | 85386 | A2.324
5 | Oxford Instruments | United Kingdom | Abingdon, Oxfordshire | OX13 5QX | A2.133/232
6 | Spectral Service AG | Germany | Köln | 50996 | A2.430
Spreadsheet: louise_kitchen__24243__SepYTD Orig w notes Revised
Sheet: Southeast Power

Southeast Power
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Kroll |  | Power |  | Southeast Orig |  | 8979408
Pagan |  | Power |  | Southeast Orig |  | 313600
Rorschach |  | Power |  | Southeast Orig |  | 234600
Braddock |  | Power |  | Southeast Orig |  | 191700
Schultz |  | Power |  | Southeast Orig |  | 50000
[NAME]. |  | Power |  | Southeast Orig |  | 24247
Acevedo |  | Power |  | Southeast Orig |  | 9700
[NAME] |  | Power |  | Southeast Orig |  | -54615
Total
Spreadsheet: 134470d1325314022-find-the-closest-match-to-a-cell-but-with-a-condition-book1
Sheet: Sheet1

 |  |  |  |  | 4626
4000 |  |  |  |  |  |  |  |  |  |  |  | 4000
4100 |  |  |  |  |  |  |  |  |  |  |  | 4100
4200 |  |  |  |  |  |  |  |  |  |  |  | 4200 | 500
4300 |  |  |  |  |  |  |  |  |  |  |  | 4300 | 300
4400 |  |  |  |  |  |  |  |  |  |  |  | 4400
4500 |  |  |  |  |  |  |  |  |  |  |  | 4500 | 200
4600 |  |  |  |  |  |  |  |  |  |  |  | 4600
4700 |  |  |  |  |  |  |  |  |  |  |  | 4700
4800 | 300 |  |  |  |  |  |  |  |  |  |  | 4800
4900 |  |  |  |  |  |  |  |  |  |  |  | 4900 | -400
5000 | -1200 |  |  |  |  |  |  |  |  |  |  | 5000
5100 |  |  |  |  |  |  |  |  |  |  |  | 5100 | 400
5200 | 700 |  |  |  |  |  |  |  |  |  |  | 5200 | 700
5300 | 450 |  |  |  |  |  |  |  |  |  |  | 5300
5400 |  |  |  |  |  |  |  |  |  |  |  | 5400
5500 | 300 |  |  |  |  |  |  |  |  |  |  | 5500 | 750
5600 |  |  |  |  |  |  |  |  |  |  |  | 5600 | 600
5700 | 600 |  |  |  |  |  |  |  |  |  |  | 5700
5800 |  |  |  |  |  |  |  |  |  |  |  | 5800
5900 |  |  |  |  |  |  |  |  |  |  |  | 5900
6000 |  |  |  |  |  |  |  |  |  |  |  | 6000
Spreadsheet: 667315d1584176491-help-to-create-a-new-sum-if-formula-spread
Sheet: Test

Vessel : |  |  |  |  |  |  | Total
Date: |  |  |  |  | Boxes |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULTS
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg) |  |  |  |  |  |  | species | Presentation | boxes | Total (Kg) |  | species | Presentation | boxes | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
 |  |  |  |  |  |  |  |  |  |  | Helper column | unique list
HD | COD | GH | 1 | 4 | 35 | 96
HD | COD | GH | 1 | 10 | 35 | 96
WC | COD | GH | 2 | 25 | 35 | 100
WC | COD | GH | 2 | 24 | 35 | 98
WC | COD | GH | 2 | 1 | 35 | 98
WT | HAD | GH | 1 | 1 | 40 | 100
HD | HAD | GH | 2 | 4 | 40 | 96
HD | HAD | GH | 4 | 24 | 40 | 92
HD | HAD | WF | 4 | 24 | 40 | 42
WT | WHG | GH | 2 | 12 | 45 | 96
WT | WHG | WF | 4 | 12 | 45 | 80
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
Spreadsheet: 684073d1593126684-trying-to-apply-multiple-formula-to-a-cell-works-great-but-how-on-earth-do-i-fill-down-reverse-engineering-logic-changed
Sheet: Sheet2 new

 | [NAME] |  | Category |  |  |  | sum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | former column T formulas
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Line checks to see if there are 2 numbers next to each other the same, so therefore checking for a double or more
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting up in sequence but ignoring the first 4 digits to avoid "0845"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting down in sequence but ignoring the first 4 digits to avoid "0845"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting up in 2's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting down in 2's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checking for alternate zero's ie 101010 or 707070
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (N15) Checks for alternate match at the end of the number, ie 5050 or 1010 or 8585, The 5's, the 1's and the 8's all match in these examples (O15) does the same but for the next number along, ie 0,0 and 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (M16 totals S13,14 and 15), as its lookingfor a 3, its therefore looking for 3 doubles)                                                                                                        (N16 is looking for patterns like 2010,3020,9080 etc, where the 3rd number is 1 more than the 1st numbers)                                                     (O16 is doing the same other than for the next set of digits, ie 0102, 0809,0506, so the 1+1 is 2, the 8+1=8, the 5+1 is 6.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N17 and O17 are looking for the same logic other than instead of +1, its -1, so 1020,2030,8090 for N and 0201,0908,0605 for O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If R18 is less than 10 Standard
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-13 Bronze
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14-15 Silver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16-20 Gold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 and over Platinum
Spreadsheet: a2a95124-e8f4-461a-9538-75cb9a6f11a3
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
PDSU | Test | PDSU | Drug Screen, Prescription/OTC, [NAME] | Drug Screen, Prescription/OTC, U | Gas Chromatography-Mass Spectrometry (GC-MS) Qualitative results will be reported. |  |  |  | 30 | mL | Container/Tube: Plastic, 60-mL urine bottle [NAME]: 30 mL  Collection Instructions:  1. Collect a random urine specimen. 2. No preservative. Additional Information: 1. See Table 1 in Prescription and Over-the-Counter (OTC) Drug Screens in Special Instructions.  2. For situations where chain-of-custody is required, a Chain-of-Custody Kit (Supply T282) is available. For chain-of-custody information, see COCH/9426 Chain-of-Custody Processing. 3. Not intended for use in employment-related testing. | 2.1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Identification | Monday through Sunday; Varies | 3 days | 5 days | 1 | 80100 |  |  |  |  | Rochester
PDSU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
PDSU | Result | 31260 | Drugs detected: | Drugs detected: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41270-0
PDSU | Result | 45529 | Suspect Drug | Suspect Drug | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PDSU | Result | 31262 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 11b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | <100 | 108 | 102 | 294 | 504
FRA | 8610 | 2388 |  | 3854 | 14852
IRS- [NAME] | 9110 | 4864 | 2854 | 8733 | 25561
OIS | 872 | 286 |  | 400 | 1558
VNS | <100 |  |  |  | <100
Zero Coupon | <100 | <100 |  | <100 | <100
TOTAL | 18592 | 7646 | 2956 | 13281 | 42475
Estimated swap transaction volumes, week ending February 15, by product type and supermajor currency (millions of USD), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for supermajor currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 149477d1333986135-how-to-move-x-axis-on-chart-s-and-p500-earnings-and-values-yr
Sheet: Sheet1

Year | Earnings Yield | Dividend Yield | S&P 500 | S&P500 Growth (YR) | Earnings | Earnings Growth (YR) | Dividends
1960 | 0.0534 | 0.0341 | 58.11 |  | 3.1 |  | 1.98 |  | AVG Earnings Growth | AVG S&P Growth
1961 | 0.0471 | 0.0285 | 71.55 |  | 3.37 |  | 2.04
1962 | 0.0581 | 0.034 | 63.1 |  | 3.67 |  | 2.15
1963 | 0.0551 | 0.0313 | 75.02 |  | 4.13 |  | 2.35
1964 | 0.0562 | 0.0305 | 84.75 |  | 4.76 |  | 2.58
1965 | 0.0573 | 0.0306 | 92.43 |  | 5.3 |  | 2.83
1966 | 0.0674 | 0.0359 | 80.33 |  | 5.41 |  | 2.88
1967 | 0.0566 | 0.0309 | 96.47 |  | 5.46 |  | 2.98
1968 | 0.0551 | 0.0293 | 103.86 |  | 5.72 |  | 3.04
1969 | 0.0663 | 0.0352 | 92.06 |  | 6.1 |  | 3.24
1970 | 0.0598 | 0.0346 | 92.15 |  | 5.51 |  | 3.19
1971 | 0.0546 | 0.031 | 102.09 |  | 5.57 |  | 3.16
1972 | 0.0523 | 0.027 | 118.05 |  | 6.17 |  | 3.19
1973 | 0.0816 | 0.037 | 97.55 |  | 7.96 |  | 3.61
1974 | 0.1364 | 0.0543 | 68.56 |  | 9.35 |  | 3.72
1975 | 0.0855 | 0.0414 | 90.19 |  | 7.71 |  | 3.73
1976 | 0.0907 | 0.0393 | 107.46 |  | 9.75 |  | 4.22
1977 | 0.1143 | 0.0511 | 95.1 |  | 10.87 |  | 4.86
1978 | 0.1211 | 0.0539 | 96.11 |  | 11.64 |  | 5.18
1979 | 0.1348 | 0.0553 | 107.94 |  | 14.55 |  | 5.97
1980 | 0.1104 | 0.0474 | 135.76 |  | 14.99 |  | 6.44
1981 | 0.1239 | 0.0557 | 122.55 |  | 15.18 |  | 6.83
1982 | 0.0983 | 0.0493 | 140.64 |  | 13.82 |  | 6.93
1983 | 0.0806 | 0.0432 | 164.93 |  | 13.29 |  | 7.12
1984 | 0.1007 | 0.0468 | 167.24 |  | 16.84 |  | 7.83
1985 | 0.0742 | 0.0388 | 211.28 |  | 15.68 |  | 8.2
1986 | 0.0596 | 0.0338 | 242.17 |  | 14.43 |  | 8.19
1987 | 0.0649 | 0.0371 | 247.08 |  | 16.04 |  | 9.17
1988 | 0.0869 | 0.0368 | 277.72 |  | 24.12 |  | 10.22
1989 | 0.0688 | 0.0332 | 353.4 |  | 24.32 |  | 11.73
1990 | 0.0686 | 0.0374 | 330.22 |  | 22.65 |  | 12.35
1991 | 0.0463 | 0.0311 | 417.09 |  | 19.3 |  | 12.97
1992 | 0.0479 | 0.029 | 435.71 |  | 20.87 |  | 12.64
1993 | 0.0577 | 0.0272 | 466.45 |  | 26.9 |  | 12.69
1994 | 0.0691 | 0.0291 | 459.27 |  | 31.75 |  | 13.36
1995 | 0.0612 | 0.023 | 615.93 |  | 37.7 |  | 14.17
1996 | 0.0549 | 0.0201 | 740.74 |  | 40.63 |  | 14.89
1997 | 0.0454 | 0.016 | 970.43 |  | 44.09 |  | 15.52
1998 | 0.036 | 0.0132 | 1229.23 |  | 44.27 |  | 16.2
1999 | 0.0352 | 0.0114 | 1469.25 |  | 51.68 |  | 16.71
2000 | 0.0425 | 0.0123 | 1320.28 |  | 56.13 |  | 16.27
2001 | 0.0338 | 0.0137 | 1148.09 |  | 38.85 |  | 15.74
2002 | 0.0523 | 0.0183 | 879.82 |  | 46.04 |  | 16.08
2003 | 0.0492 | 0.0161 | 1111.91 |  | 54.69 |  | 17.88
2004 | 0.0558 | 0.016 | 1211.92 |  | 67.68 |  | 19.407
2005 | 0.0612 | 0.0179 | 1248.29 |  | 76.45 |  | 22.38
2006 | 0.0618 | 0.0177 | 1418.3 |  | 87.72 |  | 25.05
2007 | 0.0562 | 0.0189 | 1468.36 |  | 82.54 |  | 27.73
2008 | 0.0724 | 0.0311 | 903.25 |  | 65.39 |  | 28.05
2009 | 0.0545 | 0.02 | 1115.1 |  | 60.8 |  | 22.31
2010 | 0.0665 | 0.0184 | 1257.64 |  | 83.66 |  | 23.12
2011 | 0.0772 | 0.0207 | 1257.6 |  | 97.05 |  | 26.02
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Dec2-Dec8p

Pavilion
 | 2012-12-02 00:00:00 |  |  | Thru | 2012-12-08 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-12-02 00:00:00 | 2012-12-03 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 2012-12-07 00:00:00 | 2012-12-08 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 104353d1302005775-sumproduct-formula-help-copy-of-dummy
Sheet: Sheet1

Emp No | Name | Department | Grade | Salary | Qualification |  |  |  | Graduate | Masters | Bcom | BBA | MBA
121 | [NAME] | Finance | M | 1000 | Graduate |  |  |  | BBA | MBA
114 | [NAME] | HR | M | 1100 | BBA |  |  |  | Bcom
125 | [NAME] | Finance | S | 1400 | Masters
150 | [NAME] | Sales | E | 1200 | Graduate
152 | [NAME] | Finance | S | 1100 | MBA
155 | Anand | Finance | M | 1150 | Graduate
158 | George | HR | S | 1200 | Graduate
165 | Rishan | Finance | M | 1250 | Bcom
167 | Rohan | HR | M | 950 | Graduate
168 | [NAME] | Sales | E | 1000 | Masters
170 | Arjun | Sales | E | 1050 | Graduate
 | What I'm trying to do is a comparison study for a particular employee from the above list
 | Therefore I selected Emp No: 121 as an example
Emp No | Name | Department | Grade | Salary | Qualification |  | What I need
121 | [NAME] | Finance | M | 1000 | Graduate | In "Qualification" part need to consider relevant degrees, example for [NAME], then "BBA,Bcom" also shall be considered(from "Department & Grade" criteria). Apparently for masters degree "MBA" & other related degrees also should be considered.
 | Maximum Salary (in his dept with same grade) |  |  |  | 1250 | 1100
 | Minimum [NAME] (in his dept with same grade) |  |  |  | 1000
 |  | Mid Point |  |  | 1125 | 1050
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: PSYC

Old course number | New course number
PSYC-305 | PSYC-3605
PSYC-306 | PSYC-3606
PSYC-310 | PSYC-3101
PSYC-340 | PSYC-3840
PSYC-400 | PSYC-3102
PSYC-410 | PSYC-3310
PSYC-412 | PSYC-3201
PSYC-422 | PSYC-3520
PSYC-430 | PSYC-3430
PSYC-440 | PSYC-4840
PSYC-445 | PSYC-3345
PSYC-470 | PSYC-4770
PSYC-480 | PSYC-4880
PSYC-502 | PSYC-3602
PSYC-506 | PSYC-5610
PSYC-508 | PSYC-3650
PSYC-509 | PSYC-5690
PSYC-510 | PSYC-5210 and PSYC-3202
PSYC-514 | PSYC-5828
PSYC-515 | PSYC-3203
PSYC-519 | PSYC-5219 and PSYC-3204
PSYC-523 | PSYC-5523 and PSYC-4520
PSYC-524 | PSYC-4524
PSYC-527 | PSYC-5620
PSYC-529 | PSYC-5829
PSYC-530 | PSYC-4130
PSYC-531 | PSYC-5630
PSYC-544 | PSYC-5444 and PSYC-3470
PSYC-546 | PSYC-4950
PSYC-550 | PSYC-3675
PSYC-560 | PSYC-4750
PSYC-573 | PSYC-4070
PSYC-580 | PSYC-4780
PSYC-610 | PSYC-6110
[NAME] | PSYC-6070
PSYC-700 | PSYC-7325
PSYC-740 | PSYC-7240
PSYC-760 | PSYC-6160
PSYC-801 | PSYC-8501
PSYC-806 | PSYC-6606
PSYC-814 | PSYC-8414
PSYC-820 | PSYC-7320
PSYC-821 | PSYC-6221
PSYC-828 | PSYC-7528
PSYC-829 | PSYC-6229
PSYC-830 | PSYC-7430
PSYC-831 | PSYC-7431
PSYC-835 | PSYC-6635
PSYC-840 | [NAME]
PSYC-846 | [NAME]
PSYC-848 | PSYC-7645
PSYC-849 | PSYC-8549
PSYC-850 | PSYC-8500
PSYC-852 | PSYC-7650
PSYC-853 | PSYC-8653
PSYC-854 | PSYC-8654
PSYC-857 | PSYC-8757
PSYC-858 | PSYC-8858
PSYC-863 | PSYC-8463
PSYC-865 | PSYC-8965
PSYC-870 | PSYC-7570
PSYC-880 | PSYC-8590
PSYC-890 | PSYC-8950
PSYC-891 | PSYC-8920
PSYC-892 | PSYC-8921
PSYC-898 | PSYC-8999
PSYC-920 | PSYC-8960
PSYC-921 | PSYC-8961
Spreadsheet: 172651d1344281932-populating-a-list-based-on-two-variables-excluding-entries-which-are-blank-ncl-example-modified-by-tigeravatar-
Sheet: Main

 | Title
 | Type of Installation: | Standard +
 | Application List:
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -23046 | -20000 |  |  |  |  |  |  |  | San Juan
2 | -75534 | -75068 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -84183 | -75300 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 |  |  |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 |  |  |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 |  |  |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 |  |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 51989
2001-12-03 00:00:00
CBS Volume
 |  |  | 116707
Spreadsheet: 116020d1311503570-handling-time-between-two-dates-varying-day-offs-book1
Sheet: Sheet1

REPORT START/END TIMES |  |  | EMPLOYEE SHIFT DETAILS |  |  |  |  | CALCULATIONS
Start | End |  | Shift Start | Shift End | Holiday Day 1 | Holiday Day 2 |  | Shift Hours | Hours worked on first day | Hours worked on last day | Hours on other days | Total Hours
2011-06-10 00:00:00 | 2011-06-17 04:35:00 |  | 21:00:00 | 06:00:00 | 1 | 2
Spreadsheet: 13e17967-15db-427b-a9c6-1e8a8ade9503
Sheet: Sheet1

CFDA 84.388 | Unnamed: 1 | School Improvement Grant
13036 |  | Award Date 7/14/2010
USD Name | USD Number | Allocation
Cherokee | [NAME] | 1463750
Wichita | DO259 | 5996505
Liberal | DO480 | 423339
Kansas City | DO500 | 7755193
Topeka | [NAME] | 5867658
 |  | 21506445
Spreadsheet: 873081d1719504553-formulas-required-for-football-prediction-game-axdby-bsb-
Sheet: Sheet1

 |  |  |  |  |  | Prediction |  | Actual |  |  | Home Goals | Away Goals | Correct Result | Exact Score
 |  |  |  |  |  | H | A | H | A
 |  |  |  |  |  | 3 | 1 | 5 | 1
 |  |  |  |  |  | 2 | 0 | 2 | 1
 |  |  |  |  |  | 2 | 1 | 2 | 1
 |  |  |  |  |  | 3 | 1 | 2 | 0
 |  |  |  |  |  | 1 | 2 | 1 | 3
 |  |  |  |  |  | 1 | 0
 |  |  |  |  |  | 0 | 1
 |  |  |  |  |  | 1 | 1
 |  |  |  |  |  | 2 | 2
 |  |  |  |  |  | 0 | 0