tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1f969211-be22-4d0c-a640-be650616567f
Sheet: Sheet1

1201 Balatonfüred–Veszprém/Balatonakarattya–Budapest | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | BALATON VOLÁN Zrt. | 222 | 224
 |  |  |  |  | V | _
0 | 0 | .. | .. | Balatonfüred, aut. áll. | 13:30:00 | 13:30:00
0.8 | 0.8 | .. | .. | Balatonfüred, [NAME]. | 13:32:00 | 13:32:00
1.5 | 1.5 | .. | .. | [NAME], [NAME]. [NAME]. út | 13:33:00 | 13:33:00
4.8 | S | .. | .. | Csopak, kh. | S | S
18.5 | S | .. | .. | Veszprém, kórház | S | S
19.3 | S | .. | .. | Veszprém, aut. áll. | S | S
19.3 | S | .. | .. | Veszprém, aut. áll. | S | S
24.2 | S | .. | .. | Geleméri elág. | S | S
29.7 | S | .. | .. | Hajmáskéri elág. | S | S
35 | S | .. | .. | Öskü, bej. út | S | S
42.4 | S | 0 | .. | Várpalota, aut. áll. [NAME]. út | S | S
S | S | 0.4 | .. | Várpalota, aut. áll. | S | S
S | S | 0.4 | .. | Várpalota, aut. áll. | S | S
42.4 | S | 0 | .. | Várpalota, aut. áll. [NAME]. út | S | S
47.4 | S | .. | .. | Várpalota, [NAME]. út | S | S
51.3 | S | .. | .. | [NAME], szöv. [NAME] | S | S
S | 4.7 | .. | .. | Csopak, v. mh. [NAME]. út | 13:37:00 | 13:37:00
S | 5.9 | .. | .. | Paloznak, bej. út |  | 13:39:00
S | 8.6 | .. | .. | [NAME], aut. áll. |  | 13:42:00
S | 12.7 | .. | .. | Káptalanfüred, v. mh. [NAME]. út |  | 13:47:00
S | 15.1 | .. | .. | Balatonalmádi, aut. áll. | 13:48:00 | 13:50:00
S | 15.1 | .. | .. | Balatonalmádi, aut. áll. | 13:50:00 | 13:51:00
S | 17.1 | .. | .. | [NAME]. út |  | 13:54:00
S | 19.9 | .. | .. | [NAME], Csebere, 71. sz. út |  | 13:57:00
S | 22.5 | .. | .. | [NAME], vá. |  | 14:01:00
S | 28.5 | .. | .. | Balatonkenese, vá. |  | 14:08:00
S | 31 | .. | .. | Balatonakarattya, üdülő |  | 14:11:00
S | 33.5 | 0 | .. | Balatonakarattya, vá. lejáró út |  | 14:14:00
64 | 69 | S | .. | Székesfehérvár, aut. áll. | S | S
64 | 69 | S | .. | Székesfehérvár, aut. áll. | S | S
65.9 | 70.9 | S | .. | Székesfehérvár, Király sor | S | S
68.1 | 73.1 | S | .. | Székesfehérvár, [NAME] u. | S | S
123.8 | 128.8 | 8.8 | .. | Budapest, [NAME] út | L 15:14 | L 15:24
126.1 | 131.1 | 11.1 | .. | Budapest, Bocskai út | L 15:17 | L 15:27
127.7 | 132.7 | 12.7 | .. | Budapest, Petőfi híd, budai hídfő | L 15:21 | L 15:31
132.4 | 137.4 | 17.4 | .. | Budapest, Népliget aut. pu. | 15:30:00 | 15:40:00
[NAME]:
A járatok az [NAME], de a mezőben
fel [NAME] megállóhelyeknél [NAME] állnak meg.
0 csomagkezelést nem igénylő utasok részére
V | [NAME]
_ | Minden nap
 | a járat érinti a megállóhelyet, de nem áll meg
S | a járat nem érinti a megállóhelyet, [NAME]
L | megállás csak leszálló utasok részére
Spreadsheet: 0cabd3ec-3f9c-4130-96ec-2caef4ed56ab
Sheet: Example Funding Source Schedule

Funding Source:
Annual sale of livestock (budget AAA000).
Requested loan repayment dates (annual):
2015-07-01 00:00:00
2016-07-01 00:00:00
2017-07-01 00:00:00
Funding Source Schedule:
 | Actual Revenue | Estimated Revenue | Existing Commitments | Amount committed to loan repayment *
FY11 | 23000
FY12 | 24000
FY13 | 25000
FY14 |  | 26000 |  | 15000
FY15 |  | 27000 |  | 15000
FY16 |  | 28000 |  | 15000
FY17 |  | 29000
* Amount committed to repayment cannot exceed estimated revenue less existing commitments.
Existing Commitments Notes:
$2,500 of livestock manager salary is paid out of livestock sales plus 10% of revenue is used to cover G&A assessment.
Spreadsheet: 4baef63d-5642-4223-b5d9-eacc836f06fa
Sheet: Page 6

Permit No.: |  |  | WQ0013398 |  |  | Facility Name: |  | Sandpiper Bay WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | S-6 |  | Field Name: |  | S-7 |  | Field Name: |  | S-8 |  | Field Name: |  | [NAME]
 |  |  |  |  |  | Area (acres): |  | 2.23 |  | Area (acres): |  | 4.34 |  | Area (acres): |  | 1.71 |  | Area (acres): |  | 4.83
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 1 |  | [NAME] (in): |  | 1 |  | [NAME] (in): |  | 1 |  | [NAME] (in): |  | 1
 |  |  |  |  |  | Annual Rate (in): |  | 51 |  | Annual Rate (in): |  | 51 |  | Annual Rate (in): |  | 51 |  | Annual Rate (in): |  | 51
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 704701d1605708437-vlookup-and-if-statement-combination-for-a-date-test-formulas-v3
Sheet: ROSTER

 | POST | FLIGHT | NAME | PHONE NUMBER | TRIP # | W | E | [NAME] | CERT
1 | Guardian - 2 |  |  |  |  |  | R/B/S
2 | Guardian - 2A |  |  |  |  |  | R/B
3 | Guardian - 2B |  |  |  |  |  | R/B
4 | Guardian - 4 |  |  |  |  |  | R/B/S
5 | Guardian - 4A |  |  |  |  |  | R/B
6 | Guardian - 4B |  |  |  |  |  | R/B
7 | Guardian - 6 |  |  |  |  |  | R/B/S
8 | Guardian - 6A |  |  |  |  |  | R/B
9 | Guardian - 6B |  |  |  |  |  | R/B
10 | Guardian - 8 |  |  |  |  |  | R/B/S
11 | Guardian - 8A |  |  |  |  |  | R/B
12 | Guardian - 8B |  |  |  |  |  | R/B
Spreadsheet: 815528d1675011020-vlookup-formula-is-not-working-please-look-at-this-issue-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 1.2096 | 1.2096 | 1.20958 | 1.20958 |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:01:00 | 1.20966 | 1.20972 | 1.20952 | 1.20952 |  | 00:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:02:00 | 1.20955 | 1.20958 | 1.20955 | 1.20958 |  | 00:02:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:03:00 | 1.20961 | 1.20961 | 1.20961 | 1.20961 |  | 00:03:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:04:00 | 1.20958 | 1.20958 | 1.20958 | 1.20958 |  | 00:04:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:05:00 | 1.20954 | 1.20954 | 1.20954 | 1.20954 |  | 00:05:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:07:00 | 1.20957 | 1.20957 | 1.20957 | 1.20957 |  | 00:06:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:08:00 | 1.20945 | 1.20955 | 1.20945 | 1.20955 |  | 00:07:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:10:00 | 1.20935 | 1.20935 | 1.20935 | 1.20935 |  | 00:08:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:11:00 | 1.2095 | 1.2095 | 1.20945 | 1.20945 |  | 00:09:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:12:00 | 1.20947 | 1.20947 | 1.20947 | 1.20947 |  | 00:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:14:00 | 1.20946 | 1.20948 | 1.20946 | 1.20948 |  | 00:11:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:15:00 | 1.20947 | 1.2095 | 1.20937 | 1.20947 |  | 00:12:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:17:00 | 1.20933 | 1.20974 | 1.20933 | 1.20974 |  | 00:13:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:18:00 | 1.20972 | 1.20972 | 1.20931 | 1.20937 |  | 00:14:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:19:00 | 1.20934 | 1.20936 | 1.20932 | 1.20932 |  | 00:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:20:00 | 1.20933 | 1.20933 | 1.20933 | 1.20933 |  | 00:16:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:21:00 | 1.20936 | 1.20941 | 1.20933 | 1.20933 |  | 00:17:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:24:00 | 1.2094 | 1.20942 | 1.2094 | 1.20942 |  | 00:18:00
Spreadsheet: 192098d1352307318-calculating-value-between-two-points-solar110712
Sheet: Yr End

2012 Report
Monthly Totals
 | Consumption / KW |  |  | Charges |  |  | Efficiency
 | Used | PG&E | Solar | Charges | Billed | Solar | Est | Actual
Jan | 693.39 | 326.01 | 367.38 | 84.8223987 | 46.29 | 38.53239869999999 | 302.307603686636 | 367.38
Feb | 784.43 | 236 | 548.43 | 100.7600335 | 35.17 | 65.5900335 | 449.3748609566185 | 548.43
Mar | 694.9399999999998 | 113 | 581.9399999999998 | 89.26504299999998 | 18.87 | 70.39504299999997 | 484.0021505376344 | 581.9399999999998
Apr | 724.7099999999999 | 121 | 603.7099999999999 | 93.0889995 | 20 | 73.0889995 | 300.5806451612903 | 603.7099999999999
May | 749.0400000000001 | 66 | 683.0400000000001 | 96.21418800000002 | 13.28 | 82.93418800000002 | 646.141935483871 | 683.0400000000001
Jun | 615.19 | 0 | 615.19 | 79.0211555 | -7.9 | 86.9211555 | 602.5032258064516 | 615.19
Jul | 1029.71 | 448 | 581.71 | 132.2662495 | 62.16 | 70.1062495 | 613.4516129032259 | 581.71
Aug | 2589.7 | 2010 | 579.7 | 563.03355582 | 376.99 | 186.04355582 | 631 | 579.7
Sep | 2004.22 | 1462 | 542.6600000000001 | 234.018613612 | 207.53 | 26.48861361200001 | 590.0967741935484 | 542.6600000000001
Oct | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Nov | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals | 9885.33 | 4782.01 | 5103.759999999999 | 1472.490237132 | 772.39 | 700.100237132 | 4619.458808729276 | 5103.759999999999
% Consumed |  | 0.4837481399204681 | 0.5162963704802975 | [NAME] | 0.5245467715320138 | 0.4754532284679862 | 1.104839378663914 | Efficient
Spreadsheet: 804624d1668186302-complex-algebraic-formulas-values
Sheet: Sheet1

AP0 | 12.5
PSF | 0.25
g | 4.2
[NAME] | 2
G2 | 4
G3 | 6
G4 | 6
G5 | 4
G6 | 2
G7 | 0
G8 | 0
G9 | 0
G10 | 0
G11 | 0
G12 | 0
G13 | 0
G14 | 0
[NAME] | 0
[NAME] | 0
G17 | 0
G18 | 0
G19 | 0
G20 | 0
K | 5 | K is number of years and we want to calculate for 5, 10, 15 and 20
K | 10
K | 15
K | 20
R1, [NAME]… | The formula is defined on the handwritten instructions
Spreadsheet: 753252d1635328225-select-data-on-basis-multiple-vertical-criteria-27102021-sample-file-for-excel-forum
Sheet: Sheet1

 | DATA Table
Emp Code | Allowance | 31-03-2021 | 30-04-2021 | 31-05-2021 | 30-06-2021 | 31-07-2021 | 31-08-2021 | 30-09-2021
9 | CASH | 1500 | 1500 | 1500 | 2200 | 2200 | 2100 | 1600
9 | DRIVER | 2100 | 2100 | 2100 | 2800 | 2800 | 2700 | 2200
16 | TRAVEL | 3000 | 3000 | 3000 | 3700 | 3700 | 3600 | 3100
33 | CASH | 1500 | 1500 | 1500 | 2200 | 2200 | 2100 | 1600
42 | SYSTEM | 750 | 750 | 750 | 900 | 900 | 1200 | 1200
42 | CASH | 1500 | 1500 | 1500 | 2200 | 2200 | 2100 | 1600
43 | SYSTEM | 750 | 750 | 750 | 900 | 900 | 1200 | 1200
126 | VEH | 140 | 180 | 180 | 210 | 105 | 440 | 120
152 | MISC | 300 | 450 | 300 | 550 | 440 | 150 | 220
255 | VEH | 140 | 180 | 180 | 210 | 105 | 440 | 120
 |  | For the Date | 2021-04-30 00:00:00
RESULT | This is on different sheet
Emp code | CASH | DRIVER | TRAVEL | SYSTEM | VEH | MISC | Total
9
16
33
42
43
126
152
255
Total
Spreadsheet: 355563d1414710480-how-to-combine-two-results-into-one-celll-after-index-match-combine-two-results-into-one-cell-by-index-match-v2
Sheet: Sheet1

 |  | 1953 | 2014-10-30 00:00:00 | bill |  |  |  |  |  |  |  |  |  | 2014-10-30 00:00:00 | 06:30:00
 |  | 2563 | 2014-10-30 00:00:00 | bill |  |  |  |  |  | TECHNICIAN | bill
 |  | 1852 | 2014-10-30 00:00:00 | bill |  |  |  |  |  | Part # | PLAN | ACTUAL | ISSUE
 |  | 1125 | 2014-10-30 00:00:00 | bill |  |  |  |  |  |  | grinding
 |  |  |  |  |  |  |  |  |  | question: formula in cell k8 only show 1953 which is first result found by formula, how to combine all other results with same criteria(bill & 10/30/2014) into cell k8 with "/". It will ends like | 1953/2563/1852/1125
Spreadsheet: 65023d1265803162-selecting-multiple-items-from-a-list-in-one-cell-djt-help-requied
Sheet: 2010 Data

Company Name | SoW Number | Invoke Date | End Date | Days Invoked | Platforms | Site | Seats Invoked | Reason Code | Full Reason | Equipment Provided | Charges ?
Customer One | ABCD1 | 2010-01-10 00:00:00 | 2010-02-05 00:00:00 | 27 | pSeries | Customer Site | 0 | System | Problems with server spec.2 DPBXCH001 - actual fault/reason not specified | IBM Server Case 10
Customer Two | [NAME] | 2010-01-15 00:00:00 | 2010-01-19 00:00:00 | 5 | Network | Sampson House | 0 | Comms | [NAME] down | none
Customer Three | WXYZ3 | 2010-01-25 00:00:00 | 2010-02-09 00:00:00 | 16 | WAR | [NAME] | 10 | Flood | Office Flooded | Grfd - DR2
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 9

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
1 7 |  | 22:00     6:00 |  | 10:01    19:49 |  | 10:00    20:00 | 20:47     7:09
 | 23:47     8:41 |  | 22:47     6:09 | 23:10     7:02
 |  |  | 15:01    22:23 | 20:47     7:09 | 22:47     8:09 |  | 14:15    22:09
 | 13:25    20:54 | 13:55    23:49 | 14:33    23:47 | 14:00    22:24
 |  |  | 13:15    22:09 | 13:00    23:00 | 14:00    24:00 | 13:00    23:00 | 23:25     6:37
 | 22:47     6:09 |  | 19:31     7:09 | 23:00     7:21
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
1 8 |  |  | 14:00    22:24 | 23:39     6:37 | 20:47     7:09 |  | 14:47    22:25
 | 13:15    22:09 | 14:33    23:47 | 22:55     5:47 | 22:00     6:00
 |  | 23:39     6:37 | 23:47     8:41 |  |  | 11:15    19:09 | 10:15    19:53
 | 23:47     6:31 | 23:47     8:41 |  | 17:40     0:17
 |  | 9:47     19:53 | 7:19     14:25 | 9:47     17:41 |  | 7:47     17:09 | 6:52     12:09
 | 5:47     15:09 | 7:51     17:19 | 6:15     13:09 | 6:00     16:00 | 7:55     16:14
Spreadsheet: 146089d1331896526-vlook-up-duplicate-data-part-master-example
Sheet: MATERIAL PRICE

[NAME] | PRICE
5118 bulk
5122 bulk
5635 bulk
5130 bulk
5160 bulk
5122 Bags
5635 Bags
5118 [NAME]
5155 [NAME]
5160 [NAME]
5195 Bags
5130 [NAME]
5126 Bulk
5142 [NAME]
5150 [NAME]
5126 [NAME]
5155 Bulk
3122 WHITE
PEPP 4025
ORANGE
GREEN
PINK
BLUE
EPS
Spreadsheet: louise_kitchen__23977__3Q01 Rolling Schedule C
Sheet: Prudency (2)

Prudency Report |  | As of:
Schedule C: |  | Total | Required | Excess
General Gas (Transport book) | Executive | 20 | 20
Credit Reserve - Socal counterparties | West Gas
Socal counterparties - Thursday | Executive
PGT Transport (toll risk) | Executive
[NAME] | Executive | 20 | 20
Chicago index risk | Executive
[NAME] | Executive
TBG - LILCO electricity tariff risk | Executive
Entex - volumetric exposure | Texas |  | 3.2
APEA Prepay Reserve | Prepay |  | 1.1
Entex - swap fixed price for index | Texas |  | 0.9
Changes in Canada Toll Rates | Canada |  | 0.5
Six items less than $0.5MM | Originations |  | 0.9
Total - Gas
East Power Accrual |  | 90.9 | 90.9
FP&L / JEA Hedge Gain |  |  | 2.1
[NAME] |  |  | 1.2
Engage Energy |  |  | 0.7
Total - East Power
BPA - litigation
FERC Refund Reserve
Political Risk  (Wednesday)
Release Credit - Sept 1 |  | -37.5
Colorado Springs - firm sale backed by non-firm purchase
Silver Peak - litigation |  |  | 2
Welded Tube - MTM value over swaptions |  |  | 0.6
Total - West Power
General Prudency |  |  | 56
Total Schedule C
Other Items:
Expected Bonus Accrual - YTD 3Q |  |  | 103
ICAP Curves |  |  | 15
Cinergy hedges of 2000 peakers |  | 71 | 0
Onandaga |  | 17 | 17
Credit Reserve
Gas Assets |  | 20.7 | 20.7
6Bs |  | 9.5 | 9.5
Doyle |  | 3 | 3
Total Other Items
Total Reserves
Less: Reserves Committed to Corporate |  | -149
Net Reserves
Spreadsheet: 169134d1342709327-lookup-values-accross-several-sheets-to-create-summary-sheet-example-workbook
Sheet: Season2

 | Division | Standing | Cup | Playoffs | Goals | Cup goals | [NAME] |  |  |  | Count |  | Playoffs | Goals
Team 1 |  | 1 | 1 | 0
Player1
Player32
Player3 |  |  |  |  | 1
Team 2 |  | 2 | 1 | 2
Player4 |  |  |  |  | 2
Player5
Player10 |  |  |  |  | 3
Team 3 |  | 3 | 1 | 0
Player7 |  |  |  |  | 3
Player8 |  |  |  |  | 3
Player9 |  |  |  |  | 3
Team 4 |  | 4 | 1 | 0
Player10 |  |  |  |  | 1
Player11
Player12
Team 5 |  | 5 | 1 | 0
Player10 |  |  |  |  | 1
Player11
Player12 |  |  |  |  | 4
Team 6 |  | 6 | 1 | 2
Player6 |  |  |  |  | 1 | 1
Player11 |  |  |  |  | 1
Player12
Team 7 |  | 7 | 1 | 1
Player10 |  |  |  |  | 1
Player11 |  |  |  |  | 1
Player12 |  |  |  |  | 2
Team 8 |  | 8 | 1 | 5
Player10 |  |  |  |  | 1 |  | 3
Player11 |  |  |  |  | 2 | 1
Player12 |  |  |  |  | 1
Team 9 |  | 12 | 2 | 0
Player13
Player14
Player15 |  |  |  |  | 1 | 1
Team 10 |  | 11 | 2 | 3
Player16 |  |  |  |  | 3
Player17 |  |  |  |  | 2
Player26 |  |  |  |  | 1
Team 11 |  | 10 | 2 | 4
Player19 |  |  |  |  | 1
Player222
Player18
Team 12 |  | 9 | 2 | 2
Player22 |  |  |  |  | 1
Player23
Player24
Team 13 |  | 13 | 1 | 3
Player25 |  |  |  |  |  | 1
Player18 |  |  |  |  | 1
Player27 |  |  |  |  | 1
Team 14 |  | 14 | 2 | 3
Radiscal
Player28 |  |  |  |  |  | 3
Player29 |  |  |  |  | 2
Player30 |  |  |  |  | 1
Team 15 |  | 16 | 1 | 4
Player31 |  |  |  |  | 1
Player2 |  |  |  |  | 2
Player33 |  |  |  |  | 1
Team 16 |  | 15 | 1 | 5
Player34 |  |  |  |  | 2 |  | 1
Player35 |  |  |  |  | 1 | 1 | 1
Player39 |  |  |  |  | 2 |  | 1
Spreadsheet: kate_symes__18645__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 869977d1716492847-formula-for-one-name-only-2024-test
Sheet: Order Entry

Area | Month | [NAME] | [NAME] | Order Entry (LC)
Coast | May | [NAME] | 33 | 2136
USA | May | [NAME] | 34 | 1174.2
USA | May | [NAME] | 35 | 2223.04
USA | May | [NAME] | 36 | 47.4
Coast | May | [NAME] | 37 | 791.58
Mexico | May | [NAME] | 38 | 440.1
RoUSA | May | [NAME] | 39 | 753.3
Mexico | May | [NAME] | 40 | 3534.94
Mexico | May | [NAME] | 41 | 4030.94
USA | May | [NAME] | 42 | 610.78
USA | May | [NAME] | 43 | 1349.18
USA | May | [NAME] | 44 | 5368.84
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5471 | 5741 | 1041 | 1125 | 1062 | 872 | 1490 | 1123
2 | 5369 | 5741 | 815 | 1125 | 1031 | 872 | 1504 | 1123
3 | 5302 | 5741 | 762 | 1125 | 986 | 872 | 1644 | 1123
4 | 3429 | 5741 | 400 | 1125 | 953 | 872 | 1516 | 1123
5 | 5207 | 5741 |  | 1125 | 927 | 872 | 1465 | 1123
6 | 5669 | 5741 | 358 | 1125 | 921 | 872 | 1438 | 1123
7 | 6151 | 5741 |  | 1125 | 821 | 872 | 1413 | 1123
8 | 6148 | 5741 | 678 | 1125 | 1002 | 872 | 1398 | 1123
9 | 5873 | 5741 | 803 | 1125 | 979 | 872 | 1695 | 1123
10 | 5548 | 5741 | 1069 | 1124 | 985 | 872 | 1531 | 1123
11 | 5525 | 5741 | 1322 | 125 | 994 | 872 | 1481 | 1123
12 | 5676 | 5741 | 1071 | 125 | 969 | 872 | 1439 | 1123
13 | 5786 | 5741 | 746 | 125 | 983 | 872 | 1427 | 1123
14 | 6090 | 5741 | 962 | 125 | 617 | 872 | 1418 | 1123
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 406899.92
2002-01-14 00:00:00
CBS Volume
 |  |  | 166968
Spreadsheet: 712652d1610360073-countifs-2-conditions-sample-countifs-file
Sheet: Tracker

Project Number | Total | Closed
LSS0001 | 5 | 1
CI0001 | 1
CI0002 | 1
CI0003 | 1
LSS0002 | 1 | 1
LSS0002
LSS0003 | 7 | 3
1. Getting the total count of the Action Items (on LSS Action Items sheet) based on the Project Number on Column B
2. If Column A has duplicate it will only populate the total count on the first ID.
2. Getting the total count of the CLOSED Action Items (on LSS Action Items sheet) based on the Project Number on Column C
3. If the project number has a prefix CI it will by default populate 1 on the Column B
4. If Column A is blank hence Column B & C are blanks too.
Spreadsheet: 718599d1613229224-conditional-format-if-multiple-criteria-met-project-tracking-experimental
Sheet: Data Field

 | LOCATION DATA |  |  |  |  |  | Customer Project Managers |  |  |  |  | Bennett Project Managers |  |  |  |  | Contract | Validation |  | Sub Contractors |  |  |  |  |  |  |  |  |  |  |  | Vendors | Validation | Duration Reason | [NAME]
 | [NAME] | STREET ADDRESS | CITY | STATE | ZIP |  | Project Manager | E-Mail | Phone Main | Phone Cell |  | BMS Project Manager | E-Mail | Phone Main | Phone Cell |  |  |  |  | Engineering & Testing | Electric | Sheet Metal | Mechanical | Pipe Fitting | Controls | Rigging | Plumbing | Balancing | Insulation | Cleaning & Misc | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proposal | [NAME]. | CO 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  | ABC |  | DEF | 123 |  |  | GHI |  |  |  | JKL |  | Estimate | [NAME] | CO 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WAG | Long Lead
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permitting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weather
Spreadsheet: 116279d1311713184-if-then-help-2011-day-ride-saddle-and-paddle-summary
Sheet: Day Rides 2011

DAY RIDES 2011
DATE | Party Name | # of Riders |  | Hours | Total Amt. | Pd Cash | Pd Charge | CC Fee | Bkd By | Chg By | (YRC 15%) | Net | How Heard | First Name | Last Name | Address | City | Sate | Zip | phone # | email | Notes
 |  | Adults | Kids
2011-05-31 00:00:00 | [NAME] | 2 | 1 | 2 | 160 | 160 | 0 |  | ABO |  | 0 |  | [NAME] | [NAME] | [NAME]
2011-07-24 00:00:00 | Leonard | 2 | 0 | 2 | 110 |  | 110 |  | ABO |  | 0 |  |  | [NAME] | Leonard