tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9808

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-08-01 00:00:00
IFGMR (TRKL/TX) |  |  | 1.83 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 1.84
IFGMR (PEPL/TX/OK) |  |  | 1.84
IFGMR (ANR/LA) |  |  | 1.83
IFGMR (HENRY HUB) |  |  | 1.93
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 846049d1697346392-how-can-i-remove-blanks-from-a-table-pivot4
Sheet: Sheet1

 |  |  |  | DownLoad |  |  |  |  |  | Pivot
 |  |  |  |  |  |  |  |  |  | [NAME] <>0
 |  |  |  | ProdRef | InvNo |  |  |  |  | RodRef | Inv No |  | ProdRef | InvNo
 |  |  |  |  | 100004 |  |  |  |  | 200729 | 100004 |  | 200729 | 100004
 |  |  |  | 200729 | 100004 |  |  |  |  | 200819 | 100005 |  | 200819 | 100005
 |  |  |  |  | 100005 |  |  |  |  | 200878 | 100006 |  | 200878 | 100006
 |  |  |  | 200819 | 100005 |  |  |  |  | 200842 | 100007 |  | 200842 | 100007
 |  |  |  |  | 100006 |  |  |  |  | 200931 | 100008 |  | 200931 | 100008
 |  |  |  | 200878 | 100006 |  |  |  |  | 200807 | 100009 |  | 200807 | 100009
 |  |  |  |  | 100007 |  |  |  |  | 200806 | 100009 |  | 200806 | 100009
 |  |  |  | 200842 | 100007 |  |  |  |  | 200524 | 100010 |  | 200524 | 100010
 |  |  |  |  | 100008 |  |  |  |  | 200823 | 100011 |  | 200823 | 100011
 |  |  |  | 200931 | 100008 |  |  |  |  | 200823 | 100011 |  | 200823 | 100011
 |  |  |  |  | 100009 |  |  |  |  | 200753 | 100013 |  | 200753 | 100013
 |  |  |  | 200807 | 100009 |  |  |  |  | 200797 | 100014 |  | 200797 | 100014
 |  |  |  |  | 100009 |  |  |  |  | 200660 | 100015 |  | 200660 | 100015
 |  |  |  | 200806 | 100009
 |  |  |  |  | 100009
 |  |  |  |  | 100009
 |  |  |  |  | 100009
 |  |  |  |  | 100010
 |  |  |  | 200524 | 100010
 |  |  |  |  | 100011
 |  |  |  | 200823 | 100011
 |  |  |  |  | 100012
 |  |  |  | 200823 | 100011
 |  |  |  |  | 100013
 |  |  |  | 200753 | 100013
 |  |  |  |  | 100014
 |  |  |  | 200797 | 100014
 |  |  |  |  | 100015
 |  |  |  | 200660 | 100015
 |  |  |  |  | 100015
 |  |  |  |  | 100015
 |  |  |  |  | 100015
Spreadsheet: 741646d1627230623-inserting-additional-criteria-to-an-if-statement-efproblem2ofwrkswipesedit
Sheet: C

Original
 |  |  | FROM | TO | WORK | REPORT | COMMUTE | STRAIGHT | OVERTIME
 |  |  | 08:30:00 | 13:38:00
 |  |  | 15:49:00 | 19:56:00 |  | 0:20:00 | 0:10:00
 |  | 11:40:00 |  |  |  | 0:10:00 | 0:10:00
 |  | 16:30:00 |  |  |  | 0:10:00 | 0:10:00
 |  |  |  |  |  | 0:10:00 | 0:10:00
Spreadsheet: eric_saibi__9847__Market briefs
Sheet: Sheet1

Market Brief | Monday, October 8
Stocks | Close | Change | % Change
DJIA | 9067.94 | -51.82999999999993 | -0.005683257362850152
DJ 15 Util. | 320.35 | -2.12 | -0.006574254969454536
NASDAQ | 1605.95 | 0.650000000000091 | 0.0004049087397994711
S&P 500 | 1061.66 | -8.939999999999827 | -0.008350457687278
Market Vols | Close | Change | % Change
AMEX (000) | 125993 | -43850 | -0.2581796129366533
NASDAQ (000) | 1415056 | -419839 | -0.2288081879344595
NYSE (000) | 976631 | -333985 | -0.2548305529613556
Commodities | Close | Change | % Change
Crude Oil (Nov) | 22.21 | -0.18 | -0.008039303260384087
Heating Oil (Nov) | 0.641 | 0.0008000000000000229 | 0.001249609497032213
Nat. Gas (Henry) | 2.283 | 0.05600000000000005 | 0.02514593623709028
Propane (Nov) | 39.5 | -0.5 | -0.0125
Palo Verde (Nov) | 34 | 0 | 0
COB (Nov) | 31.5 | 0 | 0
PJM (Nov) | 28.9 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 1.971 | 0.001000000000000112 | 0.0005076142131980264
Canada $ | 1.562 | -0.0009999999999998899 | -0.0006397952655149648
Germany Dmark | 2.128 | -0.00299999999999967 | -0.001407789770060849
Euro | 0.921 | 0.002500000000000058 | 0.002721829069134521
Japan ¥en | 119.8 | -0.6000000000000085 | -0.004983388704319008
Mexico NP | 9.56 | 0.009999999999999787 | 0.001047120418848145
[NAME] | 0.6783 | 0.002500000000000058 | 0.003699319325244241
Foreign Indices | Close | Change | % Change
Arg MerVal | 214.87 | 0 | 0
[NAME]. | 3075.8 | -38.39999999999964 | -0.01233061460407156
[NAME] | 10094.56 | -102.51 | -0.01005288774128257
Can TSE 300 | 6894.24 | 0.03999999999996362 | 5.801978474654582e-06
Germany DAX | 4495.15 | 7.460000000000036 | 0.001662325160606022
[NAME] | 9967.83 | -309.5499999999993 | -0.03011954408613862
Japan Nikkei 225 | 10205.87 | 0 | 0
[NAME] | 5527.11 | -1.440000000000509 | -0.0002604661258377892
UK FTSE 100 | 5032.7 | -3.300000000000182 | -0.0006552819698173515
Source:  Yahoo! & TradingDay.com
Spreadsheet: 114743d1310474571-compare-values-multiple-columns-example-data-compare-highest-v1
Sheet: Expected results

Results
name | visits mar | visits apr | visits may | visits jun
A | 7 | 8 | 1 | 2
C | 6 | 15 | 8 | 1
F | 3 | 0 | 6 | 0
D | 2 | 12 | 0 | 0
E | 1 | 0 | 0 | 0
G | 1 | 9 | 0 | 2
Spreadsheet: 67650d1268227440-vlookup-for-range-vlookup-1
Sheet: Sheet1

Raw Data | Current Vlookup | [NAME] result | Category list
208501 | 0 | 0 | 200000 | 0
209388 | 0 | 0 | 300000 | 0.5
209489 | 0 | 0 | 891578 | 1
891578 | 1 | 1 | 895247 | 2
904601 | 3 | 23 | 900934 | 3
891578 | 1 | 1 | 904652 | 4
904600 | 3 | 22 | 905026 | 5
904605 | 3 | 27 | 930596 | 6
204880 | 0 | 0 | 930755 | 7
205447 | 0 | 0 | 930797 | 8
208501 | 0 | 0 | 931140 | 9
208502 | 0 | 0 | 909546 | 10
208503 | 0 | 0 | 891579 | 11
208504 | 0 | 0 | 931169 | 12
891578 | 1 | 1 | 904637 | 13
207628 | 0 | 0 | 904638 | 14
207629 | 0 | 0 | 904639 | 15
208994 | 0 | 0 | 904640 | 16
209523 | 0 | 0 | 931662 | 17
891578 | 1 | 1 | 904596 | 18
904597 | 3 | 19 | 904597 | 19
904637 | 33 | 13 | 904598 | 20
904638 | 33 | 14 | 904599 | 21
 |  |  | 904600 | 22
 |  |  | 904601 | 23
 |  |  | 904602 | 24
 |  |  | 904603 | 25
 |  |  | 904604 | 26
 |  |  | 904605 | 27
 |  |  | 904606 | 28
 |  |  | 904607 | 29
 |  |  | 904608 | 30
 |  |  | 904609 | 31
 |  |  | 904610 | 32
 |  |  | 904611 | 33
 |  |  | 905401 | 34
 |  |  | 909502 | 35
 |  |  | 909503 | 36
 |  |  | 931701 | 37
 |  |  | 931885 | 38
 |  |  | 931940 | 39
 |  |  | 932186 | 40
 |  |  | 932182 | 41
 |  |  | 932240 | 42
Spreadsheet: 136532d1326712044-excel-2007-help-linking-to-spreadsheets-by-adding-a-update-option-example-raw-data-cost-update
Sheet: Sheet1

Stock Code | Description | Cost Price | Unit of Sale | equivelents | Order Quantity | Date updated | Supplier A/C Ref | Lead times | Company |  | contact name | email | Phone | website
 | Please Enter Raw Material Code |  |  | cp1624
 | Description
 | qty ordered |  |  | 500
 | total price inc delivery |  |  | 985
 | Date ordered
 | cost per kg
 | update Raw Material Price Sheet
Spreadsheet: 1e105e0a-3d86-44af-9620-6dfe6521a3ab
Sheet: Options

 |  |  | AVAILABLE PROGRAMS | SELECTED PROGRAM |  |  |  | AVAILABLE YEARS | SELECTED YEAR |  |  |  | AVAILABLE CAMPUSES | SELECTED CAMPUS |  |  |  |  | CHART DATA
 |  |  | Accounting | 6 |  |  |  | 2007 | 1 |  |  |  | Boulder County Campus | 4 |  |  |  |  | COMPLETES | RESPONDENTS | RESPONSE RATE | EMPLOYED | EMPLOYED % | MEDIAN SALARY | MILITARY | MILITARY% | CONTINUING ED | CONTIN ED % | APPRENTICESHIPS | APPRENTICESHIP % | TOOK STATE LICENSING EXAM | TOOK EXAM % | PASSED LICENSING EXAM | PASSED EXAM % | INSTRUCTIONAL GOALS | INSTRUCTIONALGOALS MET % |  | Completers Chart Title
 |  |  | Automotive Technology |  |  |  |  | 2008 |  |  |  |  | [NAME]
 |  |  | Business |  |  |  |  | 2009 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Response Rate Chart Title
 |  |  | Computer Information Systems |  |  |  |  | 2010 |  |  |  |  | [NAME]
 |  |  | Emergency Medical Services |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employed  Chart Title
 |  |  | Nurse Aide |  |  |  |  | 2012
 |  |  | Practical Nursing |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Hourly Wage Chart Title
 |  |  | Registered Nursing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Military Chart Title
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Continuing Education
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apprenticeships
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Passed Exam
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructional Goals Met
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | State Licensing Exam
Spreadsheet: tracy_geaccone__40145__03_09_EXECSUMM
Sheet: SHarrisreportNew

Transwestern Pipeline Company
($[NAME])
 |  | March, 2001
 |  | Plan | Estimate | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | Sempra (.762)  for 7 days, Richardson($.467) for 5 days, [NAME] ($.058) 5 days
West Commodity Revenues
East Demand Revenues
East Commodity Revenues
[NAME]
[NAME] Revenues
Revenue Variance
Fuel Price [NAME] |  |  |  |  |  | MTD index price of $5.00 vs. Plan index price of $3.60
 |  |  |  |  |  | Unhedged Plan volume (722-620) 102
Fuel Volume Variance-Unhedged |  |  |  |  |  | Higher retained volumes than Plan volumes(807-722=85) @ MTD index price of $5.00
Sales Margin Variance on Unhedged
Hedging Adjustment |  |  |  |  |  | Add'l price on physical sales of HEDGED volumes
 |  |  |  |  |  | ($.005 on 10,000/day, $.02 on 10,000/day)
Unaccounted for Variance
Fuel Variance
MONTH-TO-DATE VARIANCE
2001 Stretch |  | 0.85 | 0
ADJUSTED MONTH-TO-DATE VARIANCE
Unaccounted For |  | Plan Index
(as of January Actuals) | Volume | Price | Amount
Actual UAF Volume - December | -7240 | 8.41
Actual UAF Volume - PPAs | 1710 |  | 9199.5
2001 Plan : [NAME]'s .04% |  | 4.5 | -103333
2001 Plan : Accounting's  .02% |  | 4.5 | -52000
UAF Gain/(loss) [NAME]
Spreadsheet: a5209712-5411-4215-95f3-e4b60c80fac2
Sheet: Sheet1

Resistance to antifungals among A. fumigatus clinical isolates. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Strains | Amphotericin B | MFC | Itraconazole | MFC | Voriconazole | MFC | [NAME] | MFC
Af293 | 0.25 | 8 | 1 | 8 | 0.25 | 4 | 0.5 | 8
A1163 | 0.5 | 2 | 0.5 | 0.5 | 0.25 | 2 | 2 | 8
Af71 | 0.25 | 1 | 0.12 | 8 | 0.5 | 2 | 0.5 | ND
Af294 | 0.5 | 2 | 0.25 | 8 | 0.25 | 2 | 0.5 | ND
MIC, minimal inhibitory concentration
MFC, minimal fungicidal concentraqtion
Spreadsheet: 02917e8d-9599-4b8c-9732-80cd146fdac7
Sheet: Sheet1

[NAME] | School Number | SSID | Student Last Name | Student First Name | Student Middle Name or Initial | Date of Birth | Gender | On grade level
03 | 104 | 1234569709 | Boering | [NAME] | [NAME] | 2003-03-20 00:00:00 | M | N
03 | 104 | 73098470 | Mayhem | Pricilla | Missy | 2002-11-20 00:00:00 | F | Y
12 | 108 | 8477128904 | [NAME] | Ricky | G | 2003-01-01 00:00:00 | M | U
12 | 112 | 880407349 | Haybaker | [NAME] |  | 2002-10-14 00:00:00 | M | Y
B1 | 123 | 1137744987 | Pitcher | Molly | Millard | 2003-02-25 00:00:00 | F | N
B1 | 123 | 384730987 | Packard | Billy | Bean | 2002-12-27 00:00:00 | M | Y
B1 | 123 | 1419118374 | Prada | Dominica | [NAME] | 2002-08-20 00:00:00 | F | Y
41 | 145 | 2880407849 | Bobo | Janica | Z | 2003-01-01 00:00:00 | F | U
41 | 145 | 459776987 | [NAME] | Wayne | Higbee | 2002-09-14 00:00:00 | M | Y
41 | 100 | 9084730987 | Doolittle | Mercedes | Picard | 2002-12-02 00:00:00 | F | N
Spreadsheet: 755237d1636729396-nearest-coordinates-3d-distance-surveyor-closest-points-in-space
Sheet: Sheet1

DESIGN |  |  |  |  | SURVEY
Id | X | Y | Z |  | ID | X | Y | Z |  |  | PT001.1 | PT001.2 | PT001.3 | PT001.4 | PT001.5 | PT001.6 | PT001.7 | PT001.8 | PT001.9 | PT001.10 | PT001.11 | PT001.12 | PT001.13 | PT001.14 | PT001.15 | PT001.16
V4 | 1997.082 | 6023.74 | 19.646 |  | PT001.1 | 1976.647116 | 6005.177557 | 19.652581 |  | V4
V7 | 1994.621 | 6023.299 | 19.64 |  | PT001.2 | 1977.0646 | 6006.7925 | 16.9092 |  | V7
V9 | 1993.015 | 6022.864 | 19.648 |  | PT001.3 | 1977.0646 | 6006.7925 | 19.6542 |  | V9
V15 | 1988.403 | 6020.92 | 19.638 |  | PT001.4 | 1977.4528 | 6007.9881 | 16.9091 |  | V15
V17 | 1986.792 | 6019.954 | 19.636 |  | PT001.5 | 1977.4528 | 6007.9881 | 19.6541 |  | V17
V21 | 1984.151 | 6017.914 | 18.779 |  | PT001.6 | 1977.980703 | 6009.342911 | 19.654937 |  | V21
V22 | 1984.143 | 6017.912 | 19.637 |  | PT001.7 | 1978.687 | 6010.858811 | 19.655 |  | V22
V27 | 1980.8906 | 6014.3947 | 19.6454 |  | PT001.8 | 1979.93911 | 6013.027871 | 19.655 |  | V27
V29 | 1979.9293 | 6013.0326 | 19.6391 |  | PT001.9 | 1980.897 | 6014.394811 | 19.655 |  | V29
V32 | 1978.685 | 6010.863 | 24.046 |  | PT001.10 | 1984.1534 | 6017.9178 | 19.6533 |  | V32
V34 | 1977.977 | 6009.343 | 24.046 |  | PT001.11 | 1984.1539 | 6017.9181 | 18.7983 |  | V34
V36 | 1977.452 | 6007.993 | 24.067 |  | PT001.12 | 1986.794792 | 6019.944708 | 19.652556 |  | V36
V36 | 1977.4381 | 6007.9841 | 19.6625 |  | PT001.13 | 1988.399492 | 6020.918273 | 19.654615 |  | V36
V37 | 1977.064 | 6006.796 | 24.034 |  | PT001.14 | 1993.006818 | 6022.874324 | 19.655404 |  | V37
V38 | 1977.065 | 6006.793 | 19.633 |  | PT001.15 | 1994.61929 | 6023.307041 | 19.655 |  | V38
V39 | 1976.642 | 6005.181 | 24.028 |  | PT001.16 | 1997.085 | 6023.741811 | 19.655 |  | V39
Spreadsheet: 751398d1634081411-create-combination-of-elements-combin
Sheet: Sample

Input |  | Output
Elements |  | Column-1 | Column-2 | Column-3
a |  | a | b | c
b |  | a | b | d
c |  | a | b | e
d |  | a | c | d
e |  | a | c | e
 |  | a | d | e
 |  | b | c | d
 |  | b | c | e
 |  | b | d | e
 |  | c | d | e
Logic: | Each row has a separate combination of elements, each element is at a different cell. Number of Rows = Combin(5,3) = 10, if one more element is added, total row will be Combin(6,3) = 20
Spreadsheet: 810448d1671776612-cant-make-a-total-from-a-match-formula-repack-supplies-form-2
Sheet: Used Box

 |  |  |  |  | A1 | A3 | C1 | C2 | [NAME] | C4 | E0 | E1 | E3 | E4 | E6 | E7 | E36 | G10 | G20 | G30 | G40 | K20 | K30 | K40 | K50 | K60 | K80 | MP10 | V07 | V40 | V70
 |  |  |  | Match
 |  |  |  | Total
 | [NAME] scanned
 | A3
Spreadsheet: 764563d1642788664-automate-data-validation-logic-cross-validation
Sheet: Associations

Unit | Division |  |  | Root Cause - Who | Remediation Group
Sales | Account Management |  |  | Internal | Team Member
Sales | Executive |  |  | Contractor | Third Party
IT | Corporate |  |  | Vendor | Third Party
IT | Development
Marketing | Internal
Marketing | External
Marketing | PR
Spreadsheet: 291267d1390234019-updating-data-from-one-worksheet-to-another-when-adding-a-new-column-with-data-mockup-ndm
Sheet: Alle

Dates: | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00 | 2014-01-10 00:00:00 | 2014-01-11 00:00:00 | 2014-01-12 00:00:00
1. Judge 1 | 71.875 | 78 | 81 | 0 | 90.5 | 81.5 | 63 | 68.5 | 66 | 90.5 | 68.5 | 94
2. Judge 2 | 75 | 72 | 84.5 | 81 | 81.5 | 87.5 | 84.5 | 84.5 | 84.5 | 84.5 | 91 | 0
3. Judge 3 | 81.25 | 93.75 | 81.5 | 84.5 | 84.5 | 69 | 0 | 78 | 75 | 78 | 78 | 0
4. Judge 4 | 78.125 | 81.25 | 0 | 78 | 78 | 0 | 69 | 84.5 | 75 | 69 | 84.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.71
5. Judge 5 | 0 | 0 | 0 | 66 | 47 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6. Judge 6 | 78.125 | 68.75 | 75 | 81 | 66 | 69 | 0 | 0 | 75 | 81.5 | 56.5 | 84.5
7. Judge 7 | 81.25 | 81 | 90.5 | 81.5 | 84.5 | 78 | 91 | 0 | 75 | 84.5 | 69 | 81.5
8. Judge 8 | 87.5 | 81 | 100 | 72 | 84.5 | 84.5 | 87.5 | 84.5 | 78 | 88 | 84.5 | 84.5
9. Judge 9 | 68.75 | 81 | 94
10. Judge 10 | 50
11. Judge 11 | 68.75
Sum
#judges appearing | 10 | 8 | 7 | 11 | 12 | 12 | 11 | 11 | 12 | 10 | 12 | 6
Average score |  |  | 86.7 | 75 | 73.6 | 74.1 | 75.7 | 67.7 | 77.5 | 82.4 | 73 | 83.4
Spreadsheet: 794706d1662232047-extract-unique-values-from-multiple-columns-sample
Sheet: Sheet1

Business Communication I | Business Communication II | Elements of Company Law I | Elements of Company Law II | Corporate Accounting I | Corporate Accounting II | Business Economics (Macro) I | Business Economics (Macro) II | Business Management I | Business Management II | 235B VOC SEM III Advertising, Sales Promotion & Sales Management I | 236B VOC SEM III Advertising, Sales Promotion & Sales Management II | 245B VOC SEM IV Advertising, Sales Promotion & Sales Management III | 246B VOC SEM IV Advertising, Sales Promotion & Sales Management IV | 235A VOC SEM III Computer Application I | 236A VOC SEM III Computer Application II | 245A VOC SEM IV Computer Application III | 246A VOC SEM IV Computer Application IV | Environmental Awareness III | Environmental Awareness IV
Mrs. [NAME] | Mrs. [NAME] | B M | B M | K T | K T | G B | G B | B D | B D | Dr. [NAME] | Dr. [NAME] | Dr. [NAME] | Dr. [NAME] |  |  |  | BP | [NAME] | [NAME]
Ms. [NAME] | Ms. [NAME] | J V | J V | S N | S N | M S.S. | M S.S. | K M | K M | Dr. J P | Dr. J P | Dr. J P | Dr. J P |  |  |  | BL | Ms. [NAME] | Ms. [NAME]
Dr. [NAME] | Dr. [NAME] | S K | S K | K V | K V | W H.P | W H.P | Ms. [NAME] | Ms. [NAME] |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Dr. [NAME] | Dr. [NAME] | K B | K B | P P | P P | D Y | D Y | Mrs. [NAME] | Mrs. [NAME] |  |  |  |  |  |  |  |  | M. S.S. | M. S.S.
Dr.  S.S. | Dr.  S.S. | T R | T R | K A | K A | G B | G B | Mrs. [NAME] R | Mrs. [NAME] R |  |  |  |  |  |  |  |  | Mrs. [NAME] | Mrs. [NAME]
Dr. In | Dr. In | S P | S P | G N | G N | U M | U M | V S | V S |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Dr. [NAME] | Dr. [NAME] |  |  | D P N | D P N | Dr. [NAME] | Dr. [NAME] | M P.V | M P.V |  |  |  |  |  |  |  |  | D Y. | D Y.
Dr. J P | Dr. J P |  |  | D S | D S | Mrs. [NAME] | Mrs. [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  | A S | A S | B P | B P
 |  |  |  | A K | A K
 |  |  |  | G S | G S
 |  | 0
Teacher Count
Rates:
X1 |  | 16
X2 |  | 0.2
X3 |  | 650
X4 |  | 520
X5
X6 |  | 325
X7 |  | 325
X8 |  | 200
X9 |  | 40
X10 |  | 19
Spreadsheet: 233093d1367608834-pasting-3-lines-of-data-example
Sheet: Actual Way

Title | First Name | Surname | Home Phone | Work Phone | Mobile | House Number | Road/ Street | Address 2 | Town | County | Postcode | Date Of Birth | Account Number | Body Style | Registration Date | Vehicle Description | Extended warranty expiry Date | Last Service Date | Engine size | Next service Date | Next service Mileage | Registration Number | Vehile Type | [NAME] | Colour | [NAME]
{{1_TITLE}}  {{1_FIRSTNAM}}  {{1_SURNAME}}  {{1_PHONE_1}}  {{1_PHONE_2}} {{1_PHONE_4}}
{{1_ADDRESS_1}} {{1_ADDRESS_2}}  {{1_ADDRESS_3}}  {{1_ADDRESS_4}}  {{1_ADDRESS_5}}
{{1_POSTCODE}} {{1_DOB}}  {{2_ACCNO}}  {{2_STYLE}}  {{2_REGDATE}}  {{2_DESC}}
{{2_WAREXTDT}}  {{2_LASTSERV}}  {{2_CC}} {{2_NEXTSERV}}  {{2_NEXTSMIL}}  {{2_REGNO}}
{{2_TYPE}}  {{2_VARIANT}} {{2_COLOUR}}  {{1_EMAIL}}
Spreadsheet: 735956d1623277038-index-of-terms-based-on-overlapping-dates-gantt-chart-utilizing-conditional-distinct-values-lilybickel-
Sheet: Sheet1

 | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 6 |  |  | 7 |  |  | 8 |  |  | 9 |  |  | 10
name | variable 1 | start date 1 | end date 1 | variable 2 | start date 2 | end date 2 | variable 3 | start date 3 | end date 3 | variable 4 | start date 4 | end date 4 | variable 5 | start date 5 | end date 5 | variable 6 | start date 6 | end date 6 | variable 7 | start date 7 | end date 7 | variable 8 | start date 8 | end date 8 | variable 9 | start date 9 | end date 9 | variable 10 | start date 10 | end date 10 | 1st variable combination | 2nd variable combination | 3rd variable combination | 4th variable combination | 5th variable combination | 6th variable combination | 7th variable combination | 8th variable combination | 9th variable combination | 10th variable combination
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00 | B | 2014-01-01 00:00:00 |  | C | 2015-01-01 00:00:00 |  | A | 2018-01-01 00:00:00 |  | E | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | A + B | B + C | A + B + C | A + B + C + E
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00 | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | E | 2019-01-01 00:00:00 |  | A | 2019-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B + G | G | A + E
name3
name4
name5
 |  |  | Name 1 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
A |  |  | A | 2010-01-01 00:00:00 |  |  |  |  | 2015-01-01 00:00:00 |  |  | 2018-01-01 00:00:00
B |  |  | B |  |  |  |  | 2014-01-01 00:00:00
C |  |  | C |  |  |  |  |  | 2015-01-01 00:00:00
D |  |  | E |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00
E
F
G
 |  |  | Name 2 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
 |  |  | A |  |  |  |  |  |  |  |  | 2018-01-01 00:00:00
 |  |  | B |  |  |  |  |  | 2015-01-01 00:00:00 | 2016-01-01 00:00:00
 |  |  | E |  |  |  |  |  |  |  |  | 2018-01-01 00:00:00
 |  |  | G |  |  |  |  |  | 2015-01-01 00:00:00 |  |  | 2018-01-01 00:00:00