tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 29477d1224516538-question-on-returning-value-from-a-chart-copy-of-example-3
Sheet: Sheet1

 | column #>>>>>1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
row # |  |  |  | AVERAGE |  |  |  |  |  |  |  |  |  |  | Average | Increase | Value
 | Increase |  | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 |  | 65 | 0.1
1 | 0 |  | 0 | 200 | 400 | 800 | 1200 | 1600 | 2000 | 2400 | 2800 | 3400 | 4000 |  | column # | row #
2 | 0.015 |  | 200 | 400 | 600 | 1000 | 1400 | 1800 | 2200 | 2600 | 3000 | 3600 | 4200 |  | 4 | 7 | 1400
3 | 0.03 |  | 400 | 600 | 800 | 1200 | 1600 | 2000 | 2400 | 2800 | 3200 | 3800 | 4400
4 | 0.045 |  | 600 | 800 | 1000 | 1400 | 1800 | 2200 | 2600 | 3000 | 3400 | 4000 | 4600
5 | 0.06 |  | 800 | 1000 | 1200 | 1600 | 2000 | 2400 | 2800 | 3200 | 3600 | 4200 | 4800
6 | 0.075 |  | 1000 | 1200 | 1400 | 1800 | 2200 | 2600 | 3000 | 3400 | 3800 | 4400 | 5000
7 | 0.09 |  | 1200 | 1400 | 1600 | 2000 | 2400 | 2800 | 3200 | 3600 | 4000 | 4600 | 5200
8 | 0.105 |  | 1400 | 1600 | 1800 | 2200 | 2600 | 3000 | 3400 | 3800 | 4200 | 4800 | 5400
9 | 0.12 |  | 1600 | 1800 | 2000 | 2400 | 2800 | 3200 | 3600 | 4000 | 4400 | 5000 | 5600
10 | 0.135 |  | 1800 | 2000 | 2200 | 2600 | 3000 | 3400 | 3800 | 4200 | 4600 | 5200 | 5800
11 | 0.15 |  | 2000 | 2200 | 2400 | 2800 | 3200 | 3600 | 4000 | 4400 | 4800 | 5400 | 6000
12 | 0.165 |  | 2200 | 2400 | 2600 | 3000 | 3400 | 3800 | 4200 | 4600 | 5000 | 5600 | 6200
13 | 0.18 |  | 2400 | 2600 | 2800 | 3200 | 3600 | 4000 | 4400 | 4800 | 5200 | 5800 | 6400
14 | 0.1950000000000001 |  | 2600 | 2800 | 3000 | 3400 | 3800 | 4200 | 4600 | 5000 | 5400 | 6000 | 6600
15 | 0.2100000000000001 |  | 2800 | 3000 | 3200 | 3600 | 4000 | 4400 | 4800 | 5200 | 5600 | 6200 | 6800
16 | 0.2250000000000001 |  | 3000 | 3200 | 3400 | 3800 | 4200 | 4600 | 5000 | 5400 | 5800 | 6400 | 7000
17 | 0.2400000000000001 |  | 3200 | 3400 | 3600 | 4000 | 4400 | 4800 | 5200 | 5600 | 6000 | 6600 | 7200
18 | 0.2550000000000001 |  | 3400 | 3600 | 3800 | 4200 | 4600 | 5000 | 5400 | 5800 | 6200 | 6800 | 7400
19 | 0.2700000000000001 |  | 3600 | 3800 | 4000 | 4400 | 4800 | 5200 | 5600 | 6000 | 6400 | 7000 | 7600
20 | 0.2850000000000001 |  | 3800 | 4000 | 4200 | 4600 | 5000 | 5400 | 5800 | 6200 | 6600 | 7200 | 7800
21 | 0.3000000000000002 |  | 4000 | 4200 | 4400 | 4800 | 5200 | 5600 | 6000 | 6400 | 6800 | 7400 | 8000
Spreadsheet: 0a9ba8d5-3b1f-4658-88fa-c6312ef7e099
Sheet: Sheet1

1999 - 43rd Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | [NAME], Albuquerque, New Mexico, USA |  |  |  |  | 1999-10-02 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | BEL | Cocke | Phillipe de | Havere | [NAME] | D-OCOX | Amory/Mississippi | 1666.54 | 1900-01-01 16:09:00
2 | CAN | Francoeur | Danielle | Burman | Leo |  | Goodman Mississippi | 1562.75 | 1900-01-01 19:28:00
3 | AUT | Fürstner | [NAME] | Stürzlinger | [NAME] | G-BSRJ | Avery Island Louisiana | 1495.88 | 1900-01-02 13:22:00
4 | NET | [NAME] | Rien | Houten | [NAME] | PH-KTS Festo | [NAME] | 1482.65 | 1900-01-02 11:07:00
5 | GER | [NAME] | Heinz | Hutmacher | [NAME] |  | [NAME] | 1451.52 | 1900-01-01 18:38:00
6 | USA | Bradley | Troy | Hale | [NAME] |  | Mamouth Springs Arkansas | 1365.91 | 1900-01-01 02:46:00
7 | USA | [NAME] | Mark | [NAME] | [NAME] | D-OABQ Warsteiner | Spearsville Louisiana | 1326.51 | 1900-01-01 19:23:00
8 | GBR | Forse | [NAME] | Folket | [NAME] |  | McAlister Oklahoma | 988.63 | 1900-01-01 04:38:00
9 | GER | Eimers | Wilhelm | Landsmann | Bernd | D-OOWE Warsteiner | Fredricksburg Texas | 906.55 | 1900-01-01 19:09:00
10 | GER | Höhl | [NAME] | Fink | [NAME] | D-OCOL Isenbeck | Minco/Oklahoma | 778.57 | 19:54:00
11 | USA | Abruzzo | [NAME] | Rymer-Davis | Carol |  | Seymour/Texas | 700.75 | 1900-01-01 01:07:00
12 | SWE | Akerstedt | Hans | Balkedal | Jan |  | Hobart/Oklahoma | 693.94 | 20:13:00
13 | AUS | Vizzard | [NAME] | [NAME] | [NAME] |  | Magnum Oklahoma | 650.46 | 18:26:00
14 | SUI | Fröhlin | Hansjörg | Vollenweider | Walter |  | Magnum Oklahoma | 647.64 | 19:57:00
15 | AUS | Wilson | [NAME] | Houghton | [NAME] |  | Durham Oklahoma | 602.88 | 13:24:00
16 | JAP | Ichyoshi | [NAME] | Oiwa | Maico |  | Skellytown/Texas | 494.86 | 1900-01-01 09:55:00
17 | SUI | Stoll | Christian | Najer | [NAME] | D-OCFT | Panhandle/Texas | 477.28 | 21:55:00
18 | CAN | Wereschuk | [NAME] | Martin | [NAME] |  | Muleshoe/Texas | 374.75 | 1900-01-01 09:03:00
19 | GBR | Donnelly | [NAME] | Sutcliffe | [NAME] |  | Friona/Texas | 366.89 | 15:12:00
20 | FRA | Villey | [NAME] | Buron-Pilatre | Phillipe |  | Stanley/New Mexico | 48.28 | 02:32:00
Spreadsheet: 707859d1607513610-simplifying-a-very-old-worksheet-midshires-master
Sheet: master

1 | PLAYER | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Par 3 | Adjusted stableford points | Official [NAME] points | Handicap Alteration (Official) | Handicap Alteration (Unofficial) |  |  |  |  |  | Stroke Index
1 |  | PAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Playing H'Cap |  |  | Official H'Cap
1 |  | S/I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New H'Cap |  |  |  |  | S/I 1 | S/I 2 | S/I 3 | S/I 1 | S/1 2 | S/1 3
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | Neville Ankers
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
 |  | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
 |  | PAR
 |  | S/I
 | Number of Players
 | Average Score
 | PARS
 | BIRDIES
 | Total Score
Spreadsheet: mark_taylor__24732__USlegalproductsspreadsheet
Sheet: volumetric_measures

Price Units Field
 | Characters
Price Units Field | Field Abbreviation | Product Group | ID | Long Description Sentences
therm | TH |  | 1 | The unit of measure for which the price is quoted against is therms.
Btu | Btu |  | 2 | The unit of measure for which the price is quoted against is British thermal units, which are equal to the amount of heat required to raise the temperature of 1lb of water by 1 degree Fahrenheit.
MMBtu per Day | MMBtu/d |  | 3 | The unit of measure in which the price is quoted is in millions of British thermal units per day. With respect to a financial Transaction, the Notional Quantity per Determination Period is the Volume submitted to Enron multiplied by the number of days in the relevant Determination Period.  With respect to a Transaction which calls for physical delivery, the DCQ is the volume submitted.
MMBtu per Month | MMBtu/mth |  |  | The unit of measure for which the price is quoted against is in millions of British thermal units per month.
GJ per Day | GJ/d |  | 3 | The unit of measure in which the price is quoted is in gigajoules per day. With respect to a financial Transaction, the Notional Quantity per Determination Period is the Volume submitted to Enron multiplied by the number of days in the relevant Determination Period.  With respect to a Transaction which calls for physical delivery, the DCQ is the volume submitted.
GJ per Month | GJ/mth |  |  | The unit of measure for which the price is quoted against is in gigajoules per month.
kWh | kWh |  | 4 | The unit of measure for which the price is quoted against is stated in kilowatts per hour.
GJ | GJ |  | 5 | The unit of measure for which the price is quoted against is in gigajoules.
MWh | MWh |  | 6 | The unit of measure for which the price is quoted against is stated in Megawatts.
MW | MW |  | 7 | The unit of measure for which the price is quoted against is stated in Megawatts per hour.
mt | mt |  | 8 | The unit of measure for which the price is quoted against is in metric tonnes.
cm | cm |  | 9 | The unit of measure for which the price is one centimetre.
Heating Degree Day | HDD |  | 10 | Heating Degree Day | HDD will be defined in the GTC
[NAME] | CDD |  | 11 | [NAME] | CDD will be defined in the GTC
[NAME] | [NAME] |  | 12 | The unit of measure for which the price is one millimetre.
Barrel | bbl |  | 13 | The unit of measure for which the price is quoted against is stated in Barrels.
Emission allowance | EA |  | 14 | The unit of measure for which the price is quoted against is the standard Emission Allowance.
[NAME] | GAL |  | 15 | The unit of measure for which the price is quoted against is stated in Gallons.
Pound | LB |  | 16 | The unit of measure for which the price is quoted against is stated in pounds.
1/10 inch | 1/10" |  | 17 | The unit of measure for which the price is one tenth of an inch.
Short ton | ST |  | 18 | The unit of measure for which the price is quoted against is in short tons (2000 lbs).
Spreadsheet: 722942d1615462068-is-there-a-way-to-make-the-cells-formulas-select-dynamic-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Average | Average | Count | SD | CI
 |  |  |  |  |  |  |  |  |  |  | Above 8
 |  |  |  |  |  |  |  |  |  |  | Above 9
 |  |  |  |  |  |  |  |  |  |  | Above 10
 |  |  |  |  |  |  |  |  |  |  |  | Above 8 | Above 9 | Above 10 | Year
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2015
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2015
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 2018
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2019
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 2018
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 2015
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 2016
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 2016
Spreadsheet: 841694d1693863559-work-out-how-many-pallets-required-for-order-sso-form-example
Sheet: 1. No. Cartons

TQ | SKU Qty | [NAME] | [NAME] | No of CARTONS | No of Layers | No of Pallets |  | Macro
100 | 12 | 2736 |  |  |  |  |  | Ctrl+Shift+S
50 | 18 | 3456
10 | 250 |  |  |  |  |  |  | to sort by Boxes
100 | 40
10 | 80 |  |  |  |  |  |  | Copy and Paste Values (123)
100 | 26
10 | 150
10 | 100
10 | 250
10 | 150
10 | 120
100 | 24
10 | 120
25 | 60
100 | 20
20 | 100
100 | 60
1 | 200
50 | 28
10 | 100
10 | 65
20 | 100
10 | 150
1 | 150
1 | 200
20 | 100
1 | 15
20 | 50
10 | 84
20 | 200
20 | 100
50 | 20
25 | 50
50 | 10
1 | 150
1 | 200
100 | 12
20 | 100
100 | 24
100 | 12
50 | 20
100 | 24
100 | 40
1 | 200
20 | 50
10 | 84
20 | 100
1 | 50
100 | 24
1 | 60
20 | 200
20 | 50
1 | 60
 |  |  |  |  |  |  |  | I HAVE JUST ADDED THIS FORMULA
Spreadsheet: 275055d1383319671-daily-tracking-weekkeys
Sheet: Week2

DUPLEXES, TRIPLEXES, 4-PLEXES & TOWNHOMES
# | Address | CITY | Unit |  | Tenant | Lease Start | Lease Ends | TAA | Owner | Monday | [NAME] | Wednesday | Thursday | Friday | Saturday | Weekly | Monthly
612 | [NAME] | K |  |  |  |  |  |  |  | 1
614 | [NAME] | K
625 | Brook | K | B
625 | Brook | K | C
1220 | [NAME] | CC
805 | Sissom | K | 1
1609 | Poage | K | B
1611 | Poage | K
512 | Blake | K
103 | White Wing | CC | A
722 | Sutton | K | A
301 | North Dr | CC | B
917 | [NAME] | CC | B
917 | [NAME] | CC | C
917 | [NAME] | CC | D
211 | Erby | CC | D
1904 | [NAME] | K | D
1906 | [NAME] | K | C
1102 | Eastside Dr | K | A
1006 | Eastside Dr | K | B
1006 | Eastside Dr | K | D
133 | [NAME] | CC | B
5808 | Greengate | K | A
3403 | Toledo | K | B
3403 | Toledo | K | C
3008 | Chaucer | K | A
3008 | Chaucer | K | B
4505 | Westcliff | K | C
3802 | Charolais | K | C
3414 | [NAME] | K | C
1103 | Covey | K | A
3207 | Toledo | K | A
1007 | Circle M | K | B
1007 | Circle M | K | C
1218 | Royal Crest | K
3402 | [NAME] | K | D
3408 | [NAME] | K | C
4404 | [NAME] | K | B
4410 | [NAME] | K | B
3802 | [NAME] | K | A
3802 | [NAME] | K | B
3301 | Toledo | K | C
2404 | Skylark | K
1408 | Dugger Circle | K | B
3406 | Toledo | K | A
3407 | [NAME] | K | A
927 | [NAME] | K
2911 | Cantabrian | K | D
4408 | [NAME] Dr | K | A
3408 | [NAME] | K | A
3408 | [NAME] | K | D
4300 | [NAME] | K | D
2600 | Edfield | K | B
1312 | Saddle | K
BR = # [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | W/D = Washer/Dryer Connection
BA = # Bathrooms |  |  |  |  |  |  |  |  |  |  |  |  | Pets = Y - Pets Allowed with Pet Deposit, N - Pets Not Allowed
GAR = Garage, CP = Carport |  |  |  |  |  |  |  |  |  |  |  |  | HUD = Y- HUD Accepted, N - HUD Not accepted
UTIL = Utilities Paid (W = Water, N = None) |  |  |  |  |  |  |  |  |  |  |  |  | MW = Y - Military Deposit Waiver Accepted
CH = Central Heat |  |  |  |  |  |  |  |  |  |  |  |  | CA = Central Air
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 36395 | 35310 | 30665 | 30355
2 | 36109 | 35970 | 30760 | 30926
3 | 34935 | 35968 | 31613 | 30922
4 | 35129 | 38500 | 32705 | 33450
5 | 36991 | 38491 | 29785 | 33441
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  | 2477990.65 |  | -1865308.61
2001-08-05 00:00:00
CBS Volume
 |  |  | 95132
Spreadsheet: 838193d1690812034-group-first-5-column-values-and-transpose-them-using-functions-and-formulas-sample
Sheet: Аркуш1

As is
 | Company | Name | State | Site | Country | Users |  |  |  |  |  |  | Company | Name | State | Site | Country | Users
 | Alphabet Inc. | Google | CA | www.google.com | US | 48 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 48
 | Alphabet Inc. | Google | CA | www.google.com | US | 12 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 12
 | Alphabet Inc. | Google | CA | www.google.com | US | 97 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 97
 | Alphabet Inc. | Google | CA | www.google.com | US | 34 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 34
 | Alphabet Inc. | Google | CA | www.google.com | US | 81 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 81
 | Microsoft Inc. | Bing | WA | www.bing.com | US | 46 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 54
 | Microsoft Inc. | Bing | WA | www.bing.com | US | 54 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 46
 | Microsoft Inc. | Bing | WA | www.bing.com | US | 24 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 21
 | Microsoft Inc. | Bing | WA | www.bing.com | US | 62 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 62
 | Microsoft Inc. | Bing | WA | www.bing.com | US | 23 |  |  |  |  |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 28
To be
 | Alphabet Inc. | Google | CA | www.google.com | US | 48 | 12 | 97 | 34 | 81 |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 48 | 12 | 97 | 34 | 81
 | Microsoft Inc. | Bing | WA | www.bing.com | US | 46 | 54 | 24 | 62 | 23 |  |  | Alphabet Inc. | Google | CA | www.google.com | US | 54 | 46 | 21 | 62 | 28
Spreadsheet: 776950d1650016271-look-up-formula-lg-enhancement-team-tracking-sheet
Sheet: Scott Bid Details

JOB # | EXCEPTION FORM DATE | SO # | BRANCH NAME | BRANCH | MARKET | CONTRACTOR | TYPE | PROPERTY NAME | JOBS | PROPERTY ADDRESS | BID BY | BID DUE DATE | BID SENT DATE | AWARDED DATE | REVISED DATE | BID $ | SOLD $ | Date of install | DAYS TO CLOSE | HRS | NOTES | DATE OF INSTALL NOTES
C1 |  |  |  |  |  |  |  |  |  |  | SC
C2 |  |  |  |  |  |  |  |  |  |  | SC
Spreadsheet: 85110d1285170593-combining-two-formulas-sample
Sheet: DATA

 | VISUAL ASSET MANAGEMENT DOCUMENT
 | UNIT: | [NAME]
 | Level Gauge
EQUIP. NUMBER: | P8050012 | GAUGE GLASSES: |  | glasses | GUAGE VISIBLE LENGTH: | length
 |  | TYPE: |  | type | VESSEL CENTERS LENGTH: | centers
P & ID NUMBER | pid | CONNECTIONS NPT: |  | npt | OPERATING PRESS.: | press
[NAME] | desc | CONNECTIONS LOC.: |  | loc | OPERATING TEMP.: | temp
PLANT ZONE | Zone1 | MATERIAL: |  | matl | SERVICE: | service
LOCATION/ELEV. |  | RATING: |  | rating
VENDOR |  | GAUGE COCKS: |  | gauge cocks
MFG: | mfg | TYPE: |  | type
STATUS |  | VESSEL CONNECTION: |  | vessel connection
MODEL #: | MODEL | GAUGE CONNECTION: |  | gauge connection
SERIAL #: | serial | DRAIN CONNECTION: |  | drain connection
COST CENTER | 602000 | MFR MODEL #: |  | [NAME]
CRITICALITY
PROCESS SYSTEM | process
Notes
Spreadsheet: 77117d1277574718-formula-calculation-based-on-yes-no-list-quote_analyser-1-
Sheet: Overview

Week Commening | # of Jobs Quoted | Jobs Quoted Value | Average Value/Job | # of Jobs Attained | Jobs Attained Value | Average Value/Job | # of Jobs Success Rate | Job Value Success Rate
2010-06-28 00:00:00
Spreadsheet: 181fd2d5-b923-45f2-ba3d-dbbd79badfa3
Sheet: 2011-12

Table Q
Full Time Affiliate Student numbers
Department | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Anthropology | 4 | 29 |  | 4 | 1
Institute of Archaeology | 4 | 5 |  | 4 | 1
Bartlett School of Architecture | 0 | 0 |  | 0 | 1
Bartlett School of Planning | 3 | 6 |  | 1 | 0
Biochemical Engineering | 3 | 0 |  | 1 | 0
Division of Biosciences | 0 | 30 |  | 0 | 0
Institute of Child Health | 0 | 13 |  | 0 | 1
Chemical Engineering | 4 | 1 |  | 0 | 0
Chemistry | 4 | 3 |  | 0 | 0
Civil, Environmental and Geomatic Eng. | 3 | 3 |  | 2 | 2
Computer Science | 3 | 11 |  | 2 | 0
[NAME] and Literature | 8 | 0 |  | 0 | 0
Earth Sciences | 2 | 0 |  | 0 | 0
Eastman Dental Institute | 0 | 0 |  | 4 | 0
Economics | 0 | 46 |  | 3 | 1
Electronic and Electrical Engineering | 2 | 10 |  | 1 | 0
English Language and Literature | 0 | 37 |  |  | 0
European Social and Political Studies | 11 | 3 |  |  | 0
Slade School of Fine Art | 2 | 7 |  |  | 0
French | 22 | 8 |  | 1 | 0
Geography | 8 | 8 |  |  | 2
German | 23 | 1 |  | 2 | 0
Greek and Latin | 6 | 5 |  | 1 | 0
Hebrew and Jewish Studies | 0 | 2 |  |  | 0
History | 10 | 37 |  | 3 | 0
History of Art | 3 | 10 |  | 1 | 0
Italian | 32 | 0 |  | 1 | 0
Language Centre (Affiliates) | 10 | 203 |  | 0 | 0
Laws | 43 | 7 |  |  | 25
Management Science and Innovation | 1 | 8 |  |  | 0
Mathematics | 0 | 9 |  | 0 | 0
Mechanical Engineering | 1 | 8 |  | 0 | 0
UCL Medical School | 1 | 0 |  | 0 | 0
Philosophy | 0 | 12 |  | 1 | 0
Physics and Astronomy | 5 | 5 |  | 0 | 0
Political Science | 0 | 51 |  | 0 | 0
Division of Population Health | 0 | 0 |  | 1 | 0
Division of Psychology and Language Sciences | 4 | 56 |  | 5 | 0
Scandinavian Studies | 10 | 2 |  | 0 | 0
School of Slavonic and E. European Stds | 26 | 12 |  | 0 | 0
Science and Technology Studies | 0 | 7 |  | 0 | 0
Spanish and Latin American Studies | 13 | 6 |  | 0 | 0
Statistical Science | 2 | 0 |  | 0 | 0
Total
Faculty | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Arts and Humanities | 137 | 286 |  | 6 | 0
Brain Sciences | 4 | 56 |  | 5 | 0
Built Environment | 3 | 6 |  | 1 | 1
Engineering Sciences | 17 | 41 |  | 6 | 2
Laws | 43 | 7 |  | 0 | 25
Life Sciences |  | 30 |  | 0 | 0
Mathematical and Physical Sciences | 13 | 24 |  | 0 | 0
Medical Sciences | 1 | 0 |  | 4 | 0
Population Health Sciences | 0 | 13 |  | 1 | 1
Social and Historical Sciences | 55 | 198 |  | 15 | 5
Total
As figures relate to the official HEFCE census date, 1 December, affiliate students who start in January are not included.
Spreadsheet: 821157d1678470492-conditional-format-fill-colour-with-criteria-conditional-format-fill-colour-with-criteria
Sheet: Sheet1

CSO NO. | Job | [NAME]. | Phase | Plan | Actual
G0001A12 |  |  |  | 20 | 19.5
G0001B12 |  |  |  | 10 | 11
G0002A11 |  |  |  | 10 | 10
G0002A12 |  |  |  | 5 | 4
G0002B11 |  |  |  | 22 | 19
G0005A150 |  |  |  |  | 2
G0006A160 |  |  |  |  | 2
G0006A155 |  |  |  |  | 2
Need conditional formating which will highlight with red colour fill where:
1. The value in Col.F is more than E (Actual is more than Plan).
2. If the Phase number is 1 or between 50 and 59, it should not highlight with red colour even though the Actual is more than Plan.
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: LexisNexis

LexisNexis
2010-2011
COUNTER-Compliant?: | Yes
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Academic
Sessions | 1379 | 620 | 1680 | 2891 | 2891 | 1893 | 810 | 1834 | 4160 | 4868 | 1222 | 539
Searches | 1116 | 539 | 1538 | 2521 | 2476 | 1770 | 778 | 1426 | 3634 | 4394 | 1058 | 560 |  | 0
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Congressional
Sessions | 6 | 5 | 13 | 16 | 35 | 19 | 4 | 17 | 48 | 36 | 21 | 2
Searches | 13 | 6 | 18 | 33 | 57 | 43 | 7 | 41 | 165 | 87 | 74 | 2 |  | 0
Spreadsheet: 58396d1258643932-sports-stats-707915_chaddsines
Sheet: Sheet4

Sum of W % | Opponent
Team A | A | B | C | D | E | F | G | K | L
A |  | 0.4 | 0.4 | 0 | 0.6666666666666666 | 0.5 | 0.6666666666666666 | 1 | 0
B | 0 |  | 0.4 | 0 | 0.6666666666666666 | 0.5 | 0 | 1 | 0
Spreadsheet: 801487d1666220137-how-can-this-be-done-multiple-sku-lookup-and-parts-s666-pq-hls-parts-and-quantity-final-w-50-slots
Sheet: Extracted_SKU (2)

Product_Index | Product | SKU | PART NO | QTY
1 | HLS, 0.945, ,5025-000331,, 5031-000228, 5031-000047, 42.4W, 0.945A, 5031-000247, 5031-000239, 5031-000069 | 5031-000228 | 5001-000049 | 1
1 |  | 5031-000228 | 5010-000036 | 14
1 |  | 5031-000228 | 5009-000212 | 2
1 |  | 5031-000228 | 5018-000067 | 2
1 |  | 5031-000228 | 5098-000073 | 2
1 |  | 5031-000047 | 5013-000025 | 1
1 |  | 5031-000047 | 5009-000098 | 4
1 |  | 5025-000331 | 5025-000331 | 1
1 |  | 5031-000239 | 5008-000134 | 1
1 |  | 5031-000239 | 5008-000157 | 1
1 |  | 5031-000239 | 5009-000003 | 2
1 |  | 5031-000239 | 5009-000141 | 2
1 |  | 5031-000239 | 5009-000176 | 2
1 |  | 5031-000239 | 5009-000206 | 4
1 |  | 5031-000239 | 5009-000212 | 5
1 |  | 5031-000239 | 5009-000218 | 2
1 |  | 5031-000239 | 5010-000003 | 1
1 |  | 5031-000239 | 5014-000008 | 1
1 |  | 5031-000239 | 5013-000026 | 1
1 |  | 5031-000239 | 5017-000006 | 1
1 |  | 5031-000239 | 5017-000003 | 1
1 |  | 5031-000239 | 5018-000002 | 1
1 |  | 5031-000239 | 5018-000004 | 1
1 |  | 5031-000239 | 5018-000006 | 1
1 |  | 5031-000239 | 5018-000023 | 1
1 |  | 5031-000239 | 5022-000001 | 1
1 |  | 5031-000239 | 5022-000004 | 1
1 |  | 5031-000239 | 5024-000017 | 1
1 |  | 5031-000239 | 5024-000018 | 1
1 |  | 5031-000239 | 5024-000019 | 1
1 |  | 5031-000239 | 5024-000012 | 1
1 |  | 5031-000069 | 5013-000023 | 2
1 |  | 5031-000069 | 5009-000185 | 2
1 |  | 5031-000069 | 5010-000019 | 2
1 |  | 5031-000047 | [PHONE] | 1
1 |  | 5031-000228 | 5001-000049 | 1
1 |  | 5031-000247