tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 751521d1634150371-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test
Sheet: SHOP DRINKS

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes |  | PRODUCT | SUPPLIER | PRICE |  | CHEAPEST PRICE | FROM
Coke | BOOKER | 10.99 | 24 |  |  |  |  |  | Cawston Cloudy Apple Juice & Rhubarb |  |  |  |  |  |  | 1st Price |  |  | Cawston Cloudy Apple Juice |  |  |  |  | Penningtons
Diet Coke | BOOKER | 8.99 | 24 |  |  |  |  |  |  | Penningtons |  |  |  |  |  |  |  |  | Cawston Cloudy Apple Juice & Rhubarb |  |  |  |  | SUMA
Volvic | BOOKER | 3.89 | 24 |  |  |  |  |  |  | SUMA |  |  |  |  |  |  |  |  | Coke |  |  |  |  | 0
[NAME] | BOOKER | 9.99 | 24 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | Diet Coke
San Pellegrino Orange | BOOKER | 9.99 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
San Pellegrino Sparkling | BOOKER | 4.49 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kombucha Original
Kombucha Original | SUMA | 12.75 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Penningtons Fine Lakeland Tea 250g
[NAME] | SUMA | 12.75 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Cawston Cloudy Apple Juice | SUMA | 16.97 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | San Pellegrino Orange
Cawston Cloudy Apple Juice & Rhubarb | SUMA | 16.97 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | San Pellegrino Sparkling
Cawston Cloudy Apple & Elderflower | SUMA | 16.97 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volvic
Penningtons Fine Lakeland Tea 250g | Penningtons | 5.35 | 250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | PRODUCT | SUPPLIER | PRICE | DATE CHECK | Difference | NOTES
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -41811 | -40000
2 | -75942 | -40000
3 | -74085 | -50000
4 | -68369 | -65300
5 | -74959 | -64624
6 | -25915 | -25000
7 | -77538 | -65300
8 | -77369 | -65294
9 | -75135 | -65300
10 | -74053 | -65300
11 | -59911 | -65300
12 | -39861 | -65300
13 | -40819 | -50000
14 | -40813 | -48975
15 | -66606 | -30000
16 | -67806 | -53655
17 | -73222 | -50000
18 | -62022 | -68300
19 | -68517 | -69300
20 | -66144 | -67936
21 | -75765 | -75000
22 | -79070 | -73105
23 | -79981 | -79408
24 | -55032 | -45000
25 | -68673 | -68300
26 | -79858 | -65300
27 | -76479 | -83874
28 | -75348 | -84300
29
30
31
2001-06-30 00:00:00 |  |  | -372693.65
2001-07-28 00:00:00
Spreadsheet: 118489d1313726935-group-picker-improvement-fix-needed-grouppicker-jvr-4-and-5-4-and-3
Sheet: Class

Present | ID# | Student List
 | 1 | AMY-LEE A
 | 2 | NIKLAUS B
 | 3 | GEMMA C
 | 4 | TYSON C
 | 5 | KIOLA F
 | 6 | CALEB H
 | 7 | NALIA K
 | 8 | BIANCA K
 | 9 | JOSHUA L
 | 10 | PAENUI L
 | 11 | [NAME]
 | 12 | [NAME]
 | 13 | JOSEPHINE
 | 14 | ROSS M
 | 15 | SHAUN N
 | 16 | SHAE N
 | 17 | KONI O
 | 18 | KEISHA P
 | 19 | ARAHINA P
 | 20 | ZIVANA P
 | 21 | SHARUQ R
 | 22 | WHITNEY R
 | 23 | MAHONRI S
 | 24 | TUTEPAOA T
 | 25 | MICHELE T
 | 26 | MANSHIK V
 | 27 | TAYLOR W
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
Spreadsheet: 99589d1298207748-sum-if-multiple-criteria-is-true-1ret
Sheet: Sheet1

Date | Line | Zone | Shift | Units | Units per Line
2011-01-01 00:00:00 | 1 | 1 | 1 | 5 | 15 |  |  | 1 | 1 | 1
2011-01-01 00:00:00 | 1 | 2 | 1 | 10 | 15 | 30 |  | sumif((a2:$A$2=a2)*(b2:$B$2=b2)*(d2:$D$2=d2))
2011-01-01 00:00:00 | 1 | 1 | 2 | 20 | 50
2011-01-01 00:00:00 | 1 | 2 | 2 | 30 | 50 | 100
2011-01-01 00:00:00 | 2 | 1 | 1 | 15 | 15 | 15
2011-01-01 00:00:00 | 2 | 1 | 2 | 15 | 30
2011-01-01 00:00:00 | 2 | 2 | 2 | 15 | 30 | 60
2011-01-01 00:00:00 | 3 | 1 | 1 | 25 | 25 | 25
2011-01-02 00:00:00 | 1 | 1 | 1 | 10 | 40
2011-01-02 00:00:00 | 1 | 2 | 1 | 10 | 30 | 70
2011-01-02 00:00:00 | 1 | 3 | 2 | 10 | 25 | 25
2011-01-02 00:00:00 | 2 | 1 | 1 | 1 | 14
2011-01-02 00:00:00 | 2 | 2 | 1 | 1 | 66 | 80
2011-01-02 00:00:00 | 2 | 3 | 2 | 1 | 12 | 12
2011-01-02 00:00:00 | 3 | 1 | 1 | 5 | 66
2011-01-02 00:00:00 | 3 | 2 | 1 | 5 | 44 | 110
2011-01-02 00:00:00 | 3 | 3 | 2 | 5 | 14 | 14
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -93171 | -50640
9238 | -18207 | -25000
56422 | -1923338 | -1833999
58710 | -4947 | -32282
60921 | -1366847 | -1421352
78026 |  | 13750
500084 | -54680 | -75000
500085 | -3597
500097 | -68130 | -102961
INDEX
2002-01-31 00:00:00 |  |  | 835344.24
2002-02-25 00:00:00
CBS Volume
 |  |  | 340221
Spreadsheet: 34253d1231415375-consolidate-data-from-multiple-worksheets-example_2-1-
Sheet: Complete Site List

Alphanumeric Index | License Holder / Site Operator Name | Site Name | District | OPRA Code | Site Type | Throughput | [NAME]
C1 | EQ Waste Management Ltd | [NAME], Potters Crouch | St Albans | A22 | C
C2 | Reviva Composting Ltd | Woodcock Hill Farm, Elstree | Hertsmere | A22 | C
V1 | Cumberlow Compost Services Ltd | Cumberlow Green Farm | North Hertfordshire | A23 | V
I1 | Glaxo Smith Kleine | Stevenage | Stevenage | A18 | I
T1 | R Beach | [NAME], Bedmond | Three Rivers | A11 | T
Spreadsheet: 817621d1676363495-how-do-i-make-the-criteria-of-this-part-of-the-formula-case-sensitive-book1
Sheet: Inv

Variant | Sales Type
 | trade
 | trade
 | trade
 | trade
 | trade
 | trade
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - TIG ( 2.0 -Eleg ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -TL ) | RETAIL
2023 - T Roc ( 1.4-Sty-Leather ) | RETAIL
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TERA ( 3.6 - HL-R Line ) | RETAIL
2023 - NTOR ( 3.0 -AM ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -TL ) | RETAIL
2023 - TIG ( 1.4 -TL ) | RETAIL
2023 - TERA ( 3.6 - CL ) | FLEET
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - T Roc ( 1.4-Life-Cloth ) | RETAIL
 | trade
 | trade
2021 - PASS ( 2.5 -TL ) | retail
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - GTI - P1 ( Cloth ) | RETAIL
2023 - TERA ( 3.6 - HL-R Line ) | RETAIL
2023 - TIG ( 1.4 -TL ) | RETAIL
2018-PASS (  F-S ) | retail
2020 - PASS ( 2.5 -TL ) | retail
2020 - PASS ( 2.5 -TL ) | retail
2020 - PASS ( 2.5 -TL ) | retail
2023 - TIG ( 2.0 -Eleg ) | INTERNAL
2022 - GTI - P2 ( Leather ) | RETAIL
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - T Roc ( 1.4-Sty-Leather ) | RETAIL
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -TL ) | RETAIL
2023 - TIG ( 1.4 -TL ) | RETAIL
2023 - TERA ( 3.6 - CL ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
2023 - TIG ( 1.4 -Life ) | RETAIL
Spreadsheet: 274917d1383259798-need-to-merege-duplicate-row-values-with-varying-column-values-into-one-row-book2-solution
Sheet: Sheet2

Unit Number | Description | Annual Lift | DOT Inspection | Crane Inspection | Dielectric Test | Manufacture Major Inspection | Location | Service Days | Equipment Status
2510087 | 67 Pole Trailer |  | 2/18/2012 |  |  |  | 25170710 | 365 | AV - Available
2510133 | 68 Assmbl Dualtand Pl Trl |  | 9/20/2012 |  |  |  | [PHONE] | 365 | AV - Available
2510448 | 77 Truco Reel Trailr |  | 7/11/2013 |  |  |  | 25180710 | 365 | DN - Down
2510565 | [NAME] |  | 11/27/2006 |  |  |  | 25180710 | 365 | AV - Available
2510579 | 74 Bomb. W/Crane |  |  | 2/15/2012 | 9/1/2012 |  | 25190710 | 365 | DN - Down
2510581 | 2 Reel Wire Trlr |  | 5/17/2013 |  |  |  | [PHONE] | 365 | AV - Available
Spreadsheet: cc611342-9db1-49da-b353-e04add6c0b01
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40181941 | 2014-02-22 17:34:06 | ALLIES | 1 | 4 | 3 | 1479663 | [NAME] Pede | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
40182155 | 2014-02-22 17:48:35 | AXIS | 0 | 1 | 4 | 1479663 | [NAME] Pede | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
40203359 | 2014-02-23 20:37:44 | ALLIES | 0 | 4 | 6 | 222010 | dvogrig | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
40203793 | 2014-02-23 20:53:30 | AXIS | 0 | 3 | 6 | 222010 | dvogrig | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
40218756 | 2014-02-24 18:13:27 | ALLIES | 1 | 6 | 3 | 812702 | jeannotmenet | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40388563 | 2014-03-06 22:29:39 | ALLIES | 1 | 6 | 3 | 1007618 | SFtredo | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
40402807 | 2014-03-07 21:20:06 | AXIS | 1 | 6 | 4 | 418850 | SIR B LAW | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
40403019 | 2014-03-07 21:33:20 | ALLIES | 1 | 6 | 3 | 418850 | SIR B LAW | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 12b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending February 15, by product type and supermajor currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 784155d1655473390-powerpivot-measure-multiplication-2-tables-example
Sheet: Data

ID | Product |  |  | Type | Date | ID | ReportCode | Value |  |  | ID | Region | Region%
001 | Product A |  |  | ACT | 2022-01-31 00:00:00 | 001 | 3821000 | 39.59 |  |  | 001 | A | 0.25
002 | Product B |  |  | ACT | 2022-01-31 00:00:00 | 002 | 3610000 |  |  |  | 002 | A | 0.3
003 | Product C |  |  | ACT | 2022-01-31 00:00:00 | 003 | 3700000 | 315.36 |  |  | 003 | A | 0.3
 |  |  |  | ACT | 2022-01-31 00:00:00 | 001 | 3820200 | 4582.09 |  |  | 001 | B | 0.4
 |  |  |  | ACT | 2022-01-31 00:00:00 | 002 | 3821100 | 139.9 |  |  | 002 | B | 0.2
 |  |  |  | ACT | 2022-01-31 00:00:00 | 003 | 3821200 | 7513.95 |  |  | 003 | B | 0.25
 |  |  |  | ACT | 2022-01-31 00:00:00 | 001 | 3821401 | 5416.67 |  |  | 001 | C | 0.1
 |  |  |  | ACT | 2022-01-31 00:00:00 | 002 | 3821402 | 540 |  |  | 002 | C | 0.1
 |  |  |  | ACT | 2022-01-31 00:00:00 | 003 | 3821500 | 2500 |  |  | 003 | C | 0.35
 |  |  |  | ACT | 2022-02-28 00:00:00 | 001 | 3821000 | 748.66 |  |  | 001 | D | 0.25
 |  |  |  | ACT | 2022-02-28 00:00:00 | 002 | 3610000 | 2584 |  |  | 002 | D | 0.4
 |  |  |  | ACT | 2022-02-28 00:00:00 | 003 | 3700000 | 369.41 |  |  | 003 | D | 0.1
 |  |  |  | ACT | 2022-02-28 00:00:00 | 001 | 3820200 | 8260
 |  |  |  | ACT | 2022-02-28 00:00:00 | 002 | 3821100 | 442.5
 |  |  |  | ACT | 2022-03-31 00:00:00 | 003 | 3821200 | 458.57
 |  |  |  | ACT | 2022-03-31 00:00:00 | 001 | 3821401
 |  |  |  | ACT | 2022-03-31 00:00:00 | 002 | 3821402 | 483.4
 |  |  |  | ACT | 2022-03-31 00:00:00 | 003 | 3821500 | 255.46
 |  |  |  | ACT | 2022-03-31 00:00:00 | 001 | 3821000 | 483.4
 |  |  |  | ACT | 2022-02-28 00:00:00 | 002 | 3820200 | 2500
Sum of Value | Column Labels |  |  |  |  |  | measure 1 | Column Labels
Row Labels | 001 | 002 | 003 | Grand Total |  |  |  | A | A | A | B | B | B | C | C | C | D | D | D | Grand Total
3610000 |  | 3046.29948 |  | 3046.29948 |  |  | Row Labels | 001 | 002 | 003 | 001 | 002 | 003 | 001 | 002 | 003 | 001 | 002 | 003
3700000 |  |  | 684.77 | 684.77 |  |  | 3610000
3820200 | 12842.09 | 2500 |  | 15342.09 |  |  | 3700000
3821000 | 1271.65 |  |  | 1271.65 |  |  | 3820200
3821100 |  | 582.4 |  | 582.4 |  |  | 3821000
3821200 |  |  | 7972.52 | 7972.52 |  |  | 3821100
3821401 | 5462.76704 |  |  | 5462.76704 |  |  | 3821200
3821402 |  | 1023.4 |  | 1023.4 |  |  | 3821401
3821500 |  |  | 2755.46 | 2755.46 |  |  | 3821402
Grand Total | 19576.50704 | 7152.09948 | 11412.75 | 38141.35652 |  |  | 3821500
 |  |  |  |  |  |  | 3822200
 |  |  |  |  |  |  | Grand Total
Spreadsheet: 748486d1632164013-how-to-create-a-new-column-which-includes-the-last-value-in-rows-that-have-missing-values-my-data
Sheet: Sheet1

_bmi
24.1 | 23.7 | 24.3 | 24.9 | 24.9 | 26.5 | 26.1 | 25.7 | 23.7 | 23.3 | 23.3 | 23.3 | 23.7 | 23.7 | 24.9 | 25.3 | 24.3 | 24.5 | 25.3 | 24.9 | 26.1 | 23.3 | 24.9 | 24.9
22.2 | 21.2 | 22.8 | 22.8 | 22.8 | 22.8 | 22.8 | 22.9 | 22.86 | 22.6 | 22.6 | 21.5 | 21.5 | 21.2 | 21.2 | 21.2 | 21.2 | 21.5 | 21.5 | 21.3 | 21.2 | 21.2 | 21.5 | 21.5 | 21.5 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 22.2 | 22.2 | 22.2 | 22.6 | 22.2 | 22.2 | 22.2 | 22.2 | 32.4 | 21.8 | 21.8 | 22.6 | 22.8 | 21.5 | 22.2
20.2 | 19.4 | 19.4 | 21.4 | 21.4 | 21.8 | 22.2 | 21 | 21 | 20.4 | 20.2 | 20.4 | 20.6 | 21.4 | 21 | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 | 20.2 | 20.4 | 19.4 | 19.4 | 20.6 | 22.5 | 22.5 | 22.9 | 22.9 | 20.3 | 19.8 | 19.6
33.3 | 36.8 | 33 | 33.9 | 33.9 | 33.6 | 33.9 | 33.9 | 36.9 | 36.93 | 33 | 33.3 | 33.3 | 33.6 | 34 | 33.9 | 33.9 | 34.3 | 34.3 | 33.9 | 33.9 | 33.9 | 33.9 | 34.6 | 34.9 | 34.9 | 34.9 | 33.3 | 34.9
35.5 | 24.4 | 32.4 | 37.1 | 34.4 | 34.8 | 34.8 | 34.8 | 34.8 | 35.2 | 35.2 | 35.2 | 35.2 | 35.2 | 35.2 | 35.2 | 33.2 | 33.2 | 37.1 | 37.1 | 37.1 | 36.7 | 36.9 | 36.9 | 36.9 | 36.9 | 32.42 | 32.4 | 33.2
44.7 | 45.7 | 45.2 | 45.7 | 45.7 | 46.1 | 45.7 | 47.02 | 47 | 42.5 | 42.5 | 42.5 | 45.7 | 45.7 | 45.7 | 45.7 | 45.7 | 45.7 | 45.2 | 45.7 | 44.7 | 42.5 | 45.7 | 45.7 | 45.7 | 45.7 | 45.2 | 45.7
22.5 | 22.51 | 24.9 | 24.7 | 24.7 | 24.7 | 22.3 | 22.9 | 23.2 | 22.5 | 22.4 | 22.5
25.3 | 26.8 | 26 | 26 | 26.7 | 25.1 | 24.9 | 26.4 | 26.4 | 26.4 | 25.1 | 25.3 | 25.5 | 26 | 26.4 | 26.4 | 27.3 | 27.3 | 26.8 | 26.84 | 27.1 | 26 | 26 | 26 | 26 | 26.2 | 25.3 | 25.3
24.3 | 23.1 | 24.3 | 23.9 | 24.8 | 24.8 | 26.5 | 26.1 | 26.1 | 26.1 | 26.1 | 24.3 | 24.3 | 25.6 | 25.6 | 24.8 | 26.5 | 24.8
21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 21.3 | 22 | 21.9 | 21.9 | 22.2 | 21.9 | 21.9 | 21.9 | 21.9
34.2 | 34.2 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 31.1 | 34.2 | 34.2 | 34.2 | 31.1 | 31.1 | 31.11 | 31.1
16.6 | 15.1 | 14.6 | 16 | 14.3 | 14.64 | 15.1
35.6 | 35.6 | 34.2 | 35.7 | 36.23 | 36.2 | 35.8 | 35.6 | 34.8 | 34.8 | 34.7 | 34.7 | 35.9 | 34.8 | 35.1 | 35.6 | 36 | 35.6 | 35.9 | 35.9 | 36.6 | 36.2 | 35.9 | 36.1 | 35.4 | 35.6 | 35.6 | 36.1 | 35.9 | 35.9 | 36.1 | 36.1 | 35.2 | 35.6 | 35.4 | 35.4 | 35.4 | 35.6 | 34.5 | 34.5
22.6 | 22.6 | 22.6 | 26.1 | 22.2 | 22.2 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 21.8 | 22.6 | 22.6 | 21.8
Spreadsheet: c149a662-0ccf-4ab5-9e72-2c5084ee063e
Sheet: RWC Caltrain

Site ID | Priority Ranking1 | Readiness | Street Name | Side of Street | Nearest Cross-street | Closest Property | Station Length2 | Sidewalk | Parking Lane | Private Property | Historical Site | Environmental Issues | Construction Needed | Comments (If applicable, explain construction/ environmental issues)
CRC001 | 1 | 1 | Southbound Platform | N | near Transit Center | Caltrain Station | 9 docks | N | N | N | N | N | N | no upgrades required (if solar utilized)
CRC002 | 1 | 2 | Southbound Platform | N | North end near Broadway | Caltrain Station | 9 docks | N | N | N | N | N | Y | May need to add concrete footing for securing a bicycle station.  No other upgrades required if solar utilized.
1. Only priority ranking 1 sites are being considered for the pilot program.
2. Assumes a kiosk at the station
CITY OF REDWOOD CITY OWNERSHIP
CRC003 | 1 | 1 | Winslow Street | W | Plaza next to City Parking Lot and Northbound Platform | Caltrain Station | 5 docks | N | N | N | N | N | N | As of 2/12 location will likely be under construction and not available during project launch. no upgrades required (if solar utilized)
CRC004 | 1 | 1 | Winslow Street | W | near Northbound Platform Entrance | Caltrain Station | 13 docks | N | N | N | N | N | N | no upgrades required (if solar utilized)
Spreadsheet: 93154d1292693906-productivity-ranking-sample
Sheet: Sheet2

Type | Overall Completed |  | Type | Top??? | Result
Veterans | 100 |  | veterans | 1 |  | <<< result should show the Overall completed of the Top 2 veteran which is 300
Trainee | 150
Veterans | 200
Trainee | 250
Veterans | 300
Trainee | 350
Veterans | 400
Spreadsheet: 209651d1359149167-worksheet-doesnt-cover-entire-page-ck-nursery-and-finish-inventories
Sheet: Circle K 1  - CD Farms Nursery

CIRCLE K FAMILY FARMS, LLC
CD FARMS NURSERY
Weekly Mortality Worksheet
 |  |  |  |  | WEEK ENDING:
NURSERY |  | START | SUBJECTS | START | PRIOR | TRANSFERS | WEEKLY | MORTALITY | ENDING | % LIVABILITY | FINISH | % LIVABILITY
ROOM # | LOT # | DATE | IN | COUNT | WEEK | IN/OUT | MORTALITY | LOT-TO-DATE | LIVE COUNT | (CURRENT) | CULLS | (FINAL)
CD [NAME]
Nursery Room 01 | 201052 | 2012-12-12 00:00:00 |  | 515 | 513 | 0 | -4 |  |  |  | 0
CD [NAME]
Nursery Room 02 | 202052 | 2012-12-19 00:00:00 |  | 529 | 528 | 0 | -2 |  |  |  | 0
CD [NAME]
Nursery Room 03 | 203052 | 2012-12-28 00:00:00 |  | 519 | 519 | 0 | 0 |  |  |  | 0
CD [NAME] |  |  |  |  |  |  |  |  | CLOSED
Nursery Room 04 | 204051 | 2012-11-05 00:00:00 |  | 531 | 491 | -490 | -1 | -19 |  |  | 0
 |  |  |  |  |  |  |  |  | 12-31-12
CD [NAME] |  |  |  |  |  |  |  |  | CLOSED
Nursery Room 05 | 205051 | 2012-11-12 00:00:00 |  | 526 | 514 | -511 | -3 | -15 |  |  | 0
 |  |  |  |  |  |  |  |  | 01-04-13
CD [NAME]
Nursery Room 06 | 206051 | 2012-11-25 00:00:00 |  | 524 | 518 | -29 | -7 | -13 |  |  | 0
CD [NAME]
Nursery Room 07 | 207051 | 2012-12-03 00:00:00 |  | 551 | 548 | 0 | -2 |  |  |  | 0
CD [NAME]
Nursery Room 04 | 204052 | 2013-01-04 00:00:00 |  | 440 | 0 | 440 | 0
 |  |  |  |  |  | NEW
 |  |  |  |  | PRIOR WEEK | NET TRANSFERS | TOTAL WEEKLY | TOTAL LTD | TOTAL LIVE | AVE. % | AVE. LIVABILITY | % LIVABILITY
 |  |  |  |  | TOTAL HEAD | IN/OUT | MORTALITY | MORTALITY | HEAD | LIVABILITY | AT FINISH | (FINAL)
sb
Spreadsheet: 878749d1726035258-referencing-multiple-sheet-inorder-to-create-pt-ekac-pl2-spill-indirect-365-aligw
Sheet: Pivot Table

Sheet Name > | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheets | Subjects
Subject > | Science |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lux | Math
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Science
 |  |  |  |  |  |  | Another way:
 |  |  |  |  |  |  | First convert the data into tables, naming the tables "Lux" and "[NAME]" respectively
 | Joshep |  |  |  |  |  | Then apply these formulas:
 | Aline |  |  |  |  |  | Name: =UNIQUE(INDIRECT(B1&"[Name]"))
 | [NAME] |  |  |  |  |  | Marks: =SUMIFS(INDIRECT(B1&"[Marks]"),INDIRECT(B1&"[Name]"),E5#,INDIRECT(B1&"[Subject]"),B2)
 |  |  |  |  |  |  | Name: =UNIQUE(FILTER(INDIRECT(B1&"[Name]"),INDIRECT(B1&"[Subject]")=B2))
 |  |  |  |  | Adding unique |  | filtering >1000
 |  |  |  | Name | Marks |  | Name | Marks
 |  |  |  | Shweta |  |  | Shweta
 |  |  | >>>>> | Check | 192 | >>>>>
Spreadsheet: 773664d1647982884-help-with-vlookup-with-dates-sample
Sheet: Sheet30

 | Team 1 | Team 2 | Score
2022-01-10 00:00:00 | Vasileios | Xristina | 5 | 1
2022-01-10 00:00:00 | Ntina | Giorgos | 3 | 0
2022-01-15 00:00:00 | Giorgos | Xristina | 5 | 0
2022-01-15 00:00:00 | Ntina | Vasileios | 2 | 4
2022-01-20 00:00:00 | Vasileios | Giorgos | 1 | 3
2022-01-20 00:00:00 | Xristina | Ntina | 2 | 2
2022-03-22 00:00:00 | Vasileios | Xristina |  |  | 1 | 3 | 4 | 2 | 5 | 1 |  | 2 | 2 | 0 | 5 | 1 | 5
 |  |  |  |  | So if our score is like this (D home score - E away score) and the yellow is the last match (1) before date, green the last match before the last match (2) and the blue the 3d last match in 15 days (3), how I would apply the formula to take the scores. So if Vasileios vs Xristina playing i want to see their last three scores for the previous match they played (not between them)
Spreadsheet: 72572bf0-04dd-4515-9b7b-810bcd5b5065
Sheet: Worksheet

Título | Autor | ISBN | Precio € | Materia | Colección | Descripción | URL | Peso | Páginas | Publicación | Formato
[NAME] a las letras de Hispanoamérica | Selena Millares | 9788489756311 | 17.000048 | Cultura y civilización | Cuadernos de cultura hispánica | [NAME] y civilización españolas. | http://www.edinumen.es/index.php?option=com_virtuemart&amp;page=shop.product_details&amp;flypage=shop.flypage&amp;product_id=156&amp;category_id=45 | 370 gr | 186 | 2000 | Rústica
Literatura española contemporánea | [NAME] | 9788489756854 | 17.000048 | Cultura y civilización | Cuadernos de cultura hispánica | [NAME] por la Literatura Española Contemporánea. | http://www.edinumen.es/index.php?option=com_virtuemart&amp;page=shop.product_details&amp;flypage=shop.flypage&amp;product_id=155&amp;category_id=45 | 347 gr | 176 | 1997 | Rústica
Historia del arte contemporaneo en España e Iberoamérica | [NAME] | 9788489756908 | 17.000048 | Cultura y civilización | Cuadernos de cultura hispánica | [NAME] por España e Hispanoamérica. | http://www.edinumen.es/index.php?option=com_virtuemart&amp;page=shop.product_details&amp;flypage=shop.flypage&amp;product_id=154&amp;category_id=45 | 379 gr | 184 | 1998 | Rústica
[NAME] latina | Mercedes Quintana | 9788489756083 | 17.000048 | Cultura y civilización | Cuadernos de cultura hispánica | [NAME] por [NAME]. | http://www.edinumen.es/index.php?option=com_virtuemart&amp;page=shop.product_details&amp;flypage=shop.flypage&amp;product_id=153&amp;category_id=45 | 436 gr | 220 | 2007 | Rústica
España en el siglo XX | Sergio Millares | 9788489756892 | 17.000048 | Cultura y civilización | Cuadernos de cultura hispánica | [NAME] por [NAME] XX español. | http://www.edinumen.es/index.php?option=com_virtuemart&amp;page=shop.product_details&amp;flypage=shop.flypage&amp;product_id=152&amp;category_id=45 | 303 gr | 134 | 1998 | Rústica
Spreadsheet: 702177d1604136758-need-formula-to-merge-data-table-data-table-merge
Sheet: Sheet2

SIZE |  | AA | BB | CC | DD | EE
COLOUR | QUALITY
1 | A | 10 | 11 | 40 | 9 | 8
2 | B | 8 | 15 | 45 | 6 | 7
5 | E | 5 | 30 | 60 | 3 | 44
6 | F | 4 | 35 | 65 | 2 | 36
7 | G | 3 | 40 | 70 | 1 | 11
Spreadsheet: 275513d1383557589-change-value-of-a-cell-from-another-cell-excelforum1
Sheet: Sheet2

 |  |  |  |  | A formula there changes e.g. [NAME]'s value to B1's value, in this cell
Spreadsheet: 1fb02685-53eb-4d2c-b6c9-00c0726e1d9c
Sheet: Sheet1

Sex Offenses | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Drugs/Narcotics and Alcohol Involvement
by Offense Type, 2011
Offense Type | Total Offenses1 | Drugs/Narcotics and Alcohol Involvement
 |  | Drugs/ Narcotics | Percentage2 | Alcohol | Percentage2
Total | 76121 | 1734 | 0.02277952207669369 | 5890 | 0.07737680797677382
Sex Offenses, Forcible: | 69356 | 1608 | 0.02318472806966953 | 5657 | 0.08156468077743814
Forcible Rape | 27023 | 1062 | 0.03929985567849609 | 3368 | 0.1246345705510121
Forcible Sodomy | 7227 | 155 | 0.0214473502144735 | 429 | 0.0593607305936073
Sexual Assault with an Object | 2951 | 53 | 0.01796001355472721 | 207 | 0.07014571331751948
Forcible Fondling | 32155 | 338 | 0.01051158451251749 | 1653 | 0.05140724615145389
Sex Offenses, Nonforcible: | 6765 | 126 | 0.01862527716186253 | 233 | 0.0344419807834442
Incest | 1152 | 13 | 0.01128472222222222 | 30 | 0.02604166666666667
Statutory Rape | 5613 | 113 | 0.02013183680741137 | 203 | 0.03616604311419918
1Drugs/Narcotics and Alcohol Involvement will not add to Total Offenses because this table shows only two aspects of Data Element 8, [NAME].
2Percentage is derived from Drugs/Narcotics and Alcohol Involvement as they relate to Data Element 8, [NAME].