tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 267014d1379912169-count-how-many-times-a-cell-that-represent-other-cell-is-higher-equal-lower-than-another-pramuajiajay
Sheet: Sheet1

# | Home |  |  | Away
1 | Country5 | 3 | 2 | Country1
2 | Country4 | 0 | 3 | Country1 |  |  | Won |  |  |  | Draw |  |  |  | Lost
3 | Country1 | 2 | 1 | Country3 |  |  | Country | Home | Away |  | Country | Home | Away |  | Country | Home | Away
4 | Country4 | 4 | 4 | Country5 |  |  | Country1 |  |  |  | Country1 |  |  |  | Country1
5 | Country2 | 3 | 1 | Country3 |  |  | Country2 |  |  |  | Country2 |  |  |  | Country2
6 | Country4 | 5 | 0 | Country5 |  |  | Country3 |  |  |  | Country3 |  |  |  | Country3
7 | Country2 | 3 | 0 | Country5 |  |  | Country4 |  |  |  | Country4 |  |  |  | Country4
8 | Country3 | 1 | 3 | Country4 |  |  | Country5 |  |  |  | Country5 |  |  |  | Country5
9 | Country3 | 6 | 3 | Country5
10 | Country2 | 3 | 1 | Country1
11 | Country2 | 2 | 2 | Country2
12 | Country3 | 0 | 3 | Country2
13 | Country2 | 3 | 1 | Country1
14 | Country1 | 0 | 1 | Country4
Spreadsheet: 688911d1596018609-array-formula-suddenly-stops-working-vat-statement
Sheet: VAT

PLEASE NOTE | This formula is working but when I adjust the figures in sales journal using Vlookup and Index match it just give me blank rows and if I click on the rows the formula appear on the
 | formula bar. How do I correct this or improve this formula? [NAME] is a drop list
Fiscal Month: |  | 2020-01-01 00:00:00
Output Tax: |  | Total Purchases | VAT
Sales
Less Input:
Purchases
 |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00
Date | Invoice | Name | VAT Number | Amount | VAT | Amount incl [NAME] |  |  | 2020-02-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
Spreadsheet: 888584d1739126956-grouping-rows-book1
Sheet: DCC ID's

 | Identifier | DCC ID No. | Description | Manufacturer | Part No | Date Purchased | Purchased from | Serial No.
TURNOUTS
 | T01 | 1 | Double slip on exit from Station | Marklin
 | T02 | 2 | Double Slip at loops | Marklin
 | [NAME] | 3 | Left TO at right of loop | Marklin
 | T04 | 4 | Left on bottom loop | Marklin
 | T05 | 5 | Branch off to upper station/sidings | Marklin
 | T06 | 6 | Top West on station exit | Marklin
 | T07 | 7 | [NAME] exit of station | Marklin
 | T08 | 8 | Junction West exit of station | Marklin
 | T09 | 9 | Right branch off to mountain route | Marklin
 | T10 | 10 | Top left turnout | Marklin
 | T11 | 11 | Right turnout to cross layout track | Marklin
 | T12 | 12 | Station 2 to sidings | Marklin
 | T13 | 13 | Station 2 Siding 1 | Marklin
 | T14 | 14 | Station 2 Siding 1 | Marklin
 | T15 | 15 | [NAME] | Marklin
 | T16 | 16 | Platform 3/4 Station 2 | Marklin
 | T17 | 17 | Double Slip East Side | Marklin
 | T18 | 18 | ByPass TO South | Marklin
 | T19 | 19 | ByPass TO South | Marklin
 | T20 | 20 | TO into Sidings | Marklin
 | T21 | 21 | Left TO Programming | Marklin
 | T22 | 22 | Left TO Train Shed | Marklin
LOCOMOTIVES
 | BR V160 | 101 | Diesel, H0, BR 216, V160 130 DB with Sound and Smoke | ESU | 31000 | 2021-04-16 00:00:00 | CASISOFT MindWare GmbH
 | 75407 | 102 | Steam Engine and [NAME] 407 DB with Sound and Smoke | Marklin | 39754 | 2023-03-03 00:00:00 | Oberhessen
 | Flying Scotsman | 103 | Class A3 Flying Scotsman 100 year edition with Sound and Smoke | Marklin | 39968 | 2023-10-16 00:00:00 | Modellbahm Kramm
 | BR24-044 | 104 | Class 24 Steam Locomotive with Tender | Marklin | 36244 | 2023-03-20 00:00:00 | Amazon
 | BR360-204 | 105 | Class 360 Diesel Locomotive with Sound and Telex Couplers | Marklin | 37896 | 2023-12-15 00:00:00 | Modellbahm Kramm
 | BR VT98 | 106 | Class 798 Railcar with sound
 | BR VT98 | 107 | Class 98 Railcar with Sound
SWITCHES
8116-1
 | 1+2 | 201 | S1 - Signal 1 Goods Yard | YaMoRc | YD8116 | 2024-02-20 00:00:00 | Coastal DCC | YD8116A0002144 (1.1.8)
 | 3+4 | 202 | S2 - Signal 2 Goods Yard
 | 5+6 | 203 | S3 - Signal 3 Goods Yard
 | 7+8 | 204 | S4 - Signal 4 Goods Yard
 | 9+10 | 205 | S5 - Signal Loop Eastbound
 | 11+12 | 206 | S6 - Brewery Junction East
 | 13+14 | 207 | S7 - Signal Loop Westbound
 | 15+16
8116-2
 | 1 | 251 | [NAME] | YaMoRc | YD8116 | 2024-04-24 00:00:00 | DCC Train Automation
 | 2 | 252 | Engine Shed Lights Goods Yard
 | 3 | 253 | [NAME]
 | 4 | 254 | Street Lights
 | 5 | 255 | [NAME]
 | 6 | 256 | Car Lights
 | 7 | 257 | Signal Box Lights
 | 8 | 258 | [NAME] wheel Lights
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
8116-3 |  |  |  | YaMoRc | YD8116 | 2024-04-24 00:00:00 | DCC Train Automation
8116-4 |  |  |  | YaMoRc | YD8116 | 2024-07-30 00:00:00 | Coastal DCC
Spreadsheet: 754384d1636129807-excel-not-calculating-average-correctly-average-issue
Sheet: Sheet1

Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 500
60 | 60
 |  |  |  |  | Average should be 50% ????
Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 0
60 | 60
 |  |  |  |  | Works OK
Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 100
60 | 60
 |  |  |  |  | Works OK
Target | Actual | [NAME] | Variance to 100% | Required Accuracy
60 | 20
60 | 60
 |  |  |  |  | Works OK
Spreadsheet: 144018d1330682300-lookup-formula-lookup
Sheet: Sheet1

Simple look up formula
 |  | USD
 |  | March | Category
 |  | 10 | SP
 |  | 30 | TP
 |  | 20 | SP
 |  | 10
 |  | 5 | SP
 |  | 15 | TP
 |  | 5 | DI
 |  | 7 | DI
 |  | 5
 |  | 5
 |  | 8 | SP
 |  | 10 | TP
 |  | 15 | DI
SUM
 | SUM SP
 | SUM TP
 | SUM DI
Spreadsheet: 750873d1633704889-how-to-calculate-a-date-when-its-involving-a-text-book1
Sheet: Sheet3

 |  | [NAME]. 1 | [NAME]. 2 | [NAME]. 3 | [NAME]. 4 | [NAME]. 5 | [NAME]. 6 | [NAME]. 7 | [NAME]. 8 | [NAME]. 9 | [NAME]. 10 | [NAME]. 11 | [NAME]. 12 | [NAME]. 13 | [NAME]. 14 | [NAME]. 15 | [NAME]. 16 | [NAME]. 17 | [NAME]. 18 | [NAME]. 19 | [NAME]. 20
Percentage Surveyed
1 | 1
 | 2
 | 3
 | 4
 | 5
2 | 1
 | 2
 | 3
 | 4
 | 5
3 | 1
 | 2
 | 3
 | 4
 | 5
4 | 1
 | 2
 | 3
 | 4
 | 5
5 | 1
 | 2
 | 3
 | 4
 | 5
6 | 1
 | 2
 | 3
 | 4
 | 5
7 | 1
 | 2
 | 3
 | 4
 | 5
8 | 1
 | 2
 | 3
 | 4
 | 5
9 | 1
 | 2
 | 3
 | 4
 | 5
10 | 1
 | 2
 | 3
 | 4
 | 5
11 | 1
 | 2
 | 3
 | 4
 | 5
12 | 1
 | 2
 | 3
 | 4
 | 5
13 | 1
 | 2
 | 3
 | 4
 | 5
14 | 1
 | 2
 | 3
 | 4
 | 5
15 | 1
 | 2
 | 3
 | 4
 | 5
16 | 1
 | 2
 | 3
 | 4
 | 5
17 | 1
 | 2
 | 3
 | 4
 | 5
18 | 1
 | 2
 | 3
 | 4
 | 5
19 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 49ffed7d-58c1-4576-863f-207dae09bf6a
Sheet: Id_VG_20X20

VG |  | Nanomos-DD | Nanomos-Balance | PADRE |  | PROPHET
0 |  |  |  | 1.03170867e-07 |  | 1.816299e-07 |  |  | 64.3269 | 0.0158802
0.1 |  |  |  | 4.90432855e-07 |  | 7.744308e-07 |  |  | 119.12 | 0.0158802
0.2 |  |  |  | 2.10242569e-06 |  | 2.980856e-06 |  |  | 276.478 | 0.447303
0.3 |  |  |  | 7.61785338e-06 |  | 9.917154e-06 |  |  | 495.526 | 2.49752
0.4 |  |  |  | 2.32582118e-05 |  | 2.707e-05 |  |  | 891.716 | 10.9392
0.5 |  |  |  | 5.86750823e-05 |  | 5.940169e-05 |  |  | 1307 | 33.7343
0.6 |  |  |  | 0.000121783392 |  | 0.0001074701 |  |  | 1551.51 | 72.8095
0.7 |  |  |  | 0.000210020929 |  | 0.000166089 |  |  | 1590.73 | 128.914
0.8 |  |  |  | 0.00028066642 |  | 0.0002235119 |  |  | 2090.18 | 197.501
0.9 |  |  |  | 0.000317647648 |  | 0.0002689162 |  |  | 2096.61 | 256.273
1 |  |  |  | 0.000338864048 |  | 0.0002993916 |  |  | 2448.15 | 296.85
Spreadsheet: 858040d1706823615-equal-or-even-distribution-division-excelforum-1-
Sheet: Sheet1

 |  | Total Students | 37
 |  | Students per group | 2 |  | Students per group | 3 |  | Students per group | 4 |  | Students per group | 5
 |  | Total Groups |  |  | Total Groups |  |  | Total Groups |  |  | Total Groups
 |  | Remaining Students |  |  | Remaining Students |  |  | Remaining Students |  |  | Remaining Students
 |  | Group 1 |  |  | Group 1 |  |  | Group 1 |  |  | Group 1
 |  | Group 2 |  |  | Group 2 |  |  | Group 2 |  |  | Group 2
 |  | Group 3 |  |  | Group 3 |  |  | Group 3 |  |  | Group 3
 |  | Group 4 |  |  | Group 4 |  |  | Group 4 |  |  | Group 4
 |  | Group 5 |  |  | Group 5 |  |  | Group 5 |  |  | Group 5
 |  | Group 6 |  |  | Group 6 |  |  | Group 6 |  |  | Group 6
 |  | Group 7 |  |  | Group 7 |  |  | Group 7 |  |  | Group 7
 |  | Group 8 |  |  | Group 8 |  |  | Group 8 |  |  | Group 8
 |  | Group 9 |  |  | Group 9 |  |  | Group 9 |  |  | Group 9
 |  | Group 10 |  |  | Group 10 |  |  | Group 10 |  |  | Group 10
 |  | Group 11 |  |  | Group 11 |  |  | Group 11 |  |  | Group 11
 |  | Group 12 |  |  | Group 12 |  |  | Group 12 |  |  | Group 12
 |  | Group 13 |  |  | Group 13 |  |  | Group 13 |  |  | Group 13
 |  | Group 14 |  |  | Group 14 |  |  | Group 14 |  |  | Group 14
 |  | Group 15 |  |  | Group 15 |  |  | Group 15 |  |  | Group 15
 |  | Group 16 |  |  | Group 16 |  |  | Group 16 |  |  | Group 16
 |  | Group 17 |  |  | Group 17 |  |  | Group 17 |  |  | Group 17
 |  | Group 18 |  |  | Group 18 |  |  | Group 18 |  |  | Group 18
 |  | Group 19 |  |  | Group 19 |  |  | Group 19 |  |  | Group 19
 |  | Group 20 |  |  | Group 20 |  |  | Group 20 |  |  | Group 20
 |  | Group 21 |  |  | Group 21 |  |  | Group 21 |  |  | Group 21
Spreadsheet: 889081d1739788404-power-query-conditional-lookup-choosing-source-file-by-fund-code
Sheet: Sheet1

ProductCode |  | ProductCode | QueryCode |  | ProductCode | Sales | Cost |  | ProductCode | Sales | Cost |  | ProductCode | Sales | Cost
AAA |  | AAA | QueryA |  | AAA | 100 | 80 |  | AAA | 200 | 160 |  | AAA | 300 | 240
BBB |  | BBB | QueryB |  | BBB | 100 | 70 |  | BBB | 200 | 140 |  | BBB | 300 | 210
CCC |  | CCC | QueryC |  | CCC | 100 | 60 |  | CCC | 200 | 120 |  | CCC | 300 | 180
ProductCode | Sales | Cost
AAA | 100 | 80
BBB | 200 | 140
CCC | 300 | 180
Spreadsheet: 233419d1367792643-identify-duplicates-values-conditional-formatting
Sheet: Sheet1

2 | 2 | 4 | 5 | 2
2 | 3 | 4 | 5 | 6
5 | 5 | 5 | 5 | 5
6 | 6 | 7 | 7 | 6
 |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 3c92a895-bf77-47a0-afa5-686e4391535d
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
40863251 | 2014-04-06 04:19:21 | AXIS | 0 | 5 | 10 | 465599 | Timor | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40880682 | 2014-04-07 04:36:32 | AXIS | 1 | 6 | 3 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40880855 | 2014-04-07 04:49:28 | ALLIES | 1 | 6 | 4 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40881053 | 2014-04-07 05:21:11 | AXIS | 1 | 7 | 5 | 1531424 | djarv | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40881265 | 2014-04-07 05:39:51 | ALLIES | 1 | 7 | 5 | 1531424 | djarv | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40895777 | 2014-04-08 05:28:56 | AXIS | 1 | 7 | 4 | 67493 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40910419 | 2014-04-09 06:22:40 | AXIS | 0 | 5 | 7 | 384175 | ssegrubnad | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40910566 | 2014-04-09 06:35:53 | ALLIES | 0 | 0 | 7 | 384175 | ssegrubnad | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40910651 | 2014-04-09 06:49:53 | AXIS | 1 | 7 | 4 | 384175 | ssegrubnad | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40910744 | 2014-04-09 07:10:05 | ALLIES | 1 | 7 | 6 | 384175 | ssegrubnad | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40924095 | 2014-04-10 06:17:14 | ALLIES | 1 | 6 | 3 | 1007284 | Temple58 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
40924270 | 2014-04-10 06:47:44 | AXIS | 0 | 5 | 6 | 1007284 | Temple58 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
40965882 | 2014-04-13 06:17:05 | AXIS | 1 | 10 | 6 | 1556299 | masontmusso | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
41010389 | 2014-04-16 03:48:54 | AXIS | 1 | 10 | 8 | 424968 | CoffeeDrinker | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
41010783 | 2014-04-16 04:27:50 | ALLIES | 0 | 7 | 10 | 424968 | CoffeeDrinker | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
41011193 | 2014-04-16 04:55:27 | AXIS | 1 | 10 | 4 | 1520724 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
41011410 | 2014-04-16 05:25:47 | ALLIES | 1 | 10 | 7 | 1520724 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
41024256 | 2014-04-17 02:31:22 | AXIS | 1 | 7 | 2 | 385172 | Brode Warrior | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 700461d1603201058-summary-creation-from-source-data-skills-by-day-lates-v3-zainmerchant-
Sheet: No. of Workers

 | Day of the Week | Decant | E.Receive | Prep | Coral 1 | Coral 2 | Coral 3 | WaterSpider | PumpTruck | Instructors | Stow | Problem solve | Cubi Scan | Pack | Receive | Pick | Other 1 | Other 2 | Other 3 | Total
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday
 | Grand Total
 | Particular | Decant | E.Receive | Prep | Coral 1 | Coral 2 | Coral 3 | WaterSpider | PumpTruck | Instructors | Stow | Problem solve | Cubi Scan | Pack | Receive | Pick | Other 1 | Other 2 | Other 3 | Total
 | Percentage
Spreadsheet: 229308d1366364530-dependent-drop-down-lists-based-on-dynamic-data-range-book1-2-
Sheet: Data

Year | Quarter | Month | Product Code | BB % | USP % | LookupRef
2013 | Qtr 1 | Jan | SD-21 | 0.13 | 0.0005
2013 | Qtr 2 | Apr | NV-12 | 0.07 | 0.002
2013 | Qtr 2 | May | NV-13 | 0.1 | 0.03
2012 | Qtr 2 | Jun | QV-14 | 0.23 | 0.0003
2012 | Qtr 3 | Jul | RT-15 | 0.14 | 0.0004
2011 | Qtr 3 | Aug | [NAME] | 0.15 | 0.0015
Spreadsheet: mary_fischer__25627__1292
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292
COMPANY NAME    Marlin Fair Value Co.
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 468364d1467255115-return-data-based-on-matching-2-criteria-category_examples
Sheet: Sheet1

Group | Level | Category
ABC | 1 | Active
ABC | 2 | Active
ABC | 3 | Inactive
ABC | 4 | Inactive
DEF | 1 | Inactive
DEF | 2 | Active
DEF | 3 | Active
DEF | 4 | Active
GHI | 1 | Active
GHI | 2 | Inactive
GHI | 3 | Inactive
GHI | 4 | Inactive
JKL | 1 | Inactive
JKL | 2 | Inactive
JKL | 3 | Active
JKL | 4 | Active
Spreadsheet: 75121d1275649992-changing-the-value-of-a-dropdown-list-automatically-mocksheet
Sheet: Sheet1

A | B | C | D | E | F | G |  |  | Sample | Yes
 |  |  |  |  |  |  |  |  | Supplier | N/A
Sample | Yes | N/A | Yes | N/A | Yes | Yes |  |  | Existing
Sample |  |  |  |  |  |  |  |  | Other
Sample |  |  |  |  |  |  |  |  | Deleted
Supplier
Deleted
Spreadsheet: benjamin_rogers__1098__ENA Peaker Plant Summaries
Sheet: New Albany

 | PLANT LOCATION: |  | New Albany, MS
 | Pipeline: |  | Columbia Gulf
 | Delivery Point: |  | Columbia Gulf Mainline
 | MW Output: |  | 386 MW
 | Heat Rate: |  | 12149
 | 16 Hour Gas Flow: |  | 75,032 [NAME]
 | Facility Costs: |  | $854,000 (Col. Gulf Pays)
 | Start Date: |  | June, 1999
 | Transportation Arrangement:
 |  | Service: | FT
 |  | Term: | 10 years (May - Sept)
 |  | Volume: | 75,032 [NAME]/d
 |  | Rate: | $[NAME] | Demand on 75,032/d
 |  |  | $.0022 plus fuel | Commodity
 |  | Fuel: | 0.0% on Backhaul; 2.988% on forward haul
 |  | Receipt Points: | Leach | Primary
 |  |  | Rayne (et al) | Secondary
 |  | Option: | ECT has option within the first 24 months of
 |  |  | the agreement to double the volumes for the
 |  |  | remaining term at existing rates
 |  |  | Right to convert to Volumetric FT beginning in year six
 |  |  | Rate: tiered based on volume (average $0.056 Dth/day)
 |  |  | Cost to convert is unamortized facility costs:
 |  |  | YR7=$340,000; YR8=$226,813, YR9=$113,407
 |  | Start Up: | Interconnect will be operational within 25 weeks after
 |  |  | ECT notification.  At such time ECT will test the plant
 |  |  | and initiate FT contract thereafter
 | BALANCING:
 |  | Balancing rights in Construction agreement
 |  | Balancing in-kind within 48 hours of written notice to ECT (non-OFO time)
 |  | Balancing in-kind within 24 hours of written notice to ECT (OFO/critical periods)
 |  | Allows for uneven hourly flow at plant delivery point with even 24 hour supply flow
Spreadsheet: 89757d1289496921-excel-2007-combobox-works-with-on-sheet-data-validation-list-but-not-off-sheet-list-datavalcomboboxclick
Sheet: Original-Works withOnsheet list

 | Weekday | Month
 | Sunday | March |  |  |  |  |  |  | Sunday |  | January
 | Tuesday |  |  |  |  |  |  |  | Monday |  | February
 |  | December |  |  |  |  |  |  | Tuesday |  | March
 |  |  |  |  |  |  |  |  | Wednesday |  | April
 |  | February |  |  |  |  |  |  | Thursday |  | May
 | Sunday | December |  |  |  |  |  |  | Friday |  | June
 |  | April |  |  |  |  |  |  | Saturday |  | July
 |  |  |  |  |  |  |  |  |  |  | August
 |  | January |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  | December
 | Uses Named Range | Uses List on Sheet
 | of List on Sheet
Spreadsheet: 691357d1597659576-count-total-sales-under-multiple-conditions-formula-or-code-example1831
Sheet: Sheet2

Product Name | Country Origin | January | February | March | April | May | June | July | August | September | October | November | December |  |  | Conditions
Red apple | United States | 3679 | 3680 | 3681 | 3682 | 3683 | 3684 | 3685 |  |  |  |  |  |  |  | Product
Big banana | United States | 3680 | 3681 | 3682 | 3683 | 3684 | 3685 | 3686 |  |  |  |  |  |  | 1 | [NAME]Including small & Big)
orange | United States | 3681 | 3682 | 3683 | 3684 | 3685 | 3686 | 3687 |  |  |  |  |  |  | 2 | Apple (including Red & Green) |  |  | [NAME] (1+2+3+4+5+67+8+9)
chestnut | United States | 3682 | 3683 | 3684 | 3685 | 3686 | 3687 | 3688
cucumber | United States | 3683 | 3684 | 3685 | 3686 | 3687 | 3688 | 3689 |  |  |  |  |  |  |  | Country Origin
cabbage | United States | 3684 | 3685 | 3686 | 3687 | 3688 | 3689 | 3690 |  |  |  |  |  |  | 3 | Australia
Durian | United States | 3685 | 3686 | 3687 | 3688 | 3689 | 3690 | 3691 |  |  |  |  |  |  | 4 | United States
Green apple | Australia | 3686 | 3687 | 3688 | 3689 | 3690 | 3691 | 3692 |  |  |  |  |  |  | 5 | Chile
Small banana | Australia | 3687 | 3688 | 3689 | 3690 | 3691 | 3692 | 3693 |  |  |  |  |  |  | 6 | Japan
orange | Australia | 3688 | 3689 | 3690 | 3691 | 3692 | 3693 | 3694
chestnut | Australia | 3689 | 3690 | 3691 | 3692 | 3693 | 3694 | 3695 |  |  |  |  |  |  |  | Month
cucumber | Australia | 3690 | 3691 | 3692 | 3693 | 3694 | 3695 | 3696 |  |  |  |  |  |  | 7 | February
cabbage | Australia | 3691 | 3692 | 3693 | 3694 | 3695 | 3696 | 3697 |  |  |  |  |  |  | 8 | April
Durian | Australia | 3692 | 3693 | 3694 | 3695 | 3696 | 3697 | 3698 |  |  |  |  |  |  | 9 | June
Green apple | Chile | 3693 | 3694 | 3695 | 3696 | 3697 | 3698 | 3699
Small banana | Chile | 3694 | 3695 | 3696 | 3697 | 3698 | 3699 | 3700
orange | Chile | 3695 | 3696 | 3697 | 3698 | 3699 | 3700 | 3701
chestnut | Chile | 3696 | 3697 | 3698 | 3699 | 3700 | 3701 | 3702
cucumber | Chile | 3697 | 3698 | 3699 | 3700 | 3701 | 3702 | 3703
cabbage | Chile | 3698 | 3699 | 3700 | 3701 | 3702 | 3703 | 3704
Durian | Chile | 3699 | 3700 | 3701 | 3702 | 3703 | 3704 | 3705
Apple | Japan | 3693 | 3694 | 3695 | 3696 | 3697 | 3698 | 3699
banana | Japan | 3694 | 3695 | 3696 | 3697 | 3698 | 3699 | 3700
orange | Japan | 3695 | 3696 | 3697 | 3698 | 3699 | 3700 | 3701
chestnut | Japan | 3696 | 3697 | 3698 | 3699 | 3700 | 3701 | 3702
cucumber | Japan | 3697 | 3698 | 3699 | 3700 | 3701 | 3702 | 3703
cabbage | Japan | 3698 | 3699 | 3700 | 3701 | 3702 | 3703 | 3704
Durian | Japan | 3699 | 3700 | 3701 | 3702 | 3703 | 3704 | 3705
REMARKS　：　The product category does not represent the original country, it is just an example
Spreadsheet: 829892d1684511840-return-item-description-if-value-greater-than-zero-sample-data-set
Sheet: sheet1

[NAME] to only pull back items with value greater than zero and =C1 | Value Formula | 2022 | Enter year
SHRIMP, 37/40 PRE-BRD RND | 1.85054
SHRIMP, 16/18 RANGOON | 2737.22425
SHRIMP, 14/16 PRE-BRD CCNT | 7633.734304
SHRIMP, 36/40 PD TAIL-OFF | 3506.85314
SHRIMP, 26/30 WHT SKEWER | 888.608685
SHRIMP, 16/20 RAW | 1037.71769
SHRIMP, 31/35 RAW IQF | 7937.246480000001
CRAB, JUMBO LUMP RED CRAB MEAT | 250.518
Spreadsheet: 92964363-7a50-4850-a46d-512612064a78
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
42407749 | 2014-07-22 14:13:14 | ALLIES | 1 | 6 | 4 | 1523772 | rice dolar | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42407991 | 2014-07-22 14:41:31 | AXIS | 0 | 2 | 6 | 1523772 | rice dolar | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise