tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2f5e26c1-623c-4c45-877e-e89ae1265bbc
Sheet: Sheet1

November 4, 2008             STATE REPRESENTATIVES - BELKNAP COUNTY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Page 1 of 2 | Unnamed: 7 | Unnamed: 8
District No. 1 (1) | Wendelboe, r |  | Others
Center Harbor | 409 |  | 21
New Hampton | 722 |  | 33
TOTALS | 1131 |  | 54
District No. 2 (2) | Scott, r | Fields, r | Merry, d | [NAME], d | Others
Sanbornton | 631 | 934 | 849 | 608 | 4
[NAME] | 645 | 868 | 786 | 718 | 3
TOTALS | 1276 | 1802 | 1635 | 1326 | 7
District No. 3 (2) | Nedeau, r | [NAME], r | Merrill, d | Miller, d | [NAME] (w-in) | Others
Meredith | 1924 | 1027 | 1549 | 1579 | 281 | 5
District No. 4 (5) | [NAME], r | [NAME], r | Brown, [NAME], r | Dewhirst, r | Flanders, r
[NAME] | 730 | 733 | 672 | 685 | 758
[NAME] | 494 | 483 | 467 | 671 | 514
[NAME] 3 | 492 | 486 | 427 | 438 | 532
[NAME] | 465 | 424 | 424 | 415 | 495
[NAME] | 427 | 367 | 369 | 374 | 466
[NAME] 6 | 729 | 674 | 761 | 722 | 746
TOTALS | 3337 | 3167 | 3120 | 3305 | 3511
District No. 4 (5) | Reever, d | Stuart, d | Allard, d | Arsenault, [NAME], d | Arsenault, [NAME], d | Others
[NAME] | 658 | 623 | 517 | 530 | 622 | 7
[NAME] | 607 | 540 | 477 | 503 | 568
[NAME] 3 | 594 | 550 | 452 | 501 | 569 | 18
[NAME] | 604 | 542 | 481 | 490 | 567 | 1
[NAME] | 569 | 516 | 442 | 477 | 547 | 6
[NAME] 6 | 690 | 566 | 510 | 522 | 625 | 12
TOTALS | 3722 | 3337 | 2879 | 3023 | 3498 | 44
 | STATE REPRESENTATIVES - BELKNAP COUNTY |  |  |  |  |  | Page 2 of 2
District No. 5 (7) | [NAME], r | Pilliod, r | St. Cyr, r | Swinford, r | Bolster, r | Boyce, r | Chris-  tiansen, r
Alton | 1422 | 1505 | 1979 | 1338 | 1669 | 1727 | 1389
Barnstead | 812 | 868 | 1070 | 1018 | 827 | 882 | 878
Belmont | 1362 | 1822 | 1374 | 1202 | 1460 | 1460 | 1231
Gilford | 2535 | 2522 | 1965 | 1768 | 1773 | 1975 | 1748
TOTALS | 6131 | 6717 | 6388 | 5326 | 5729 | 6044 | 5246
District No. 5 (7) | [NAME], d | [NAME], d | Bourbeau, d | Condode-   metraky, d | Hammond, d | [NAME], d | Others
Alton | 836 | 955 | 767 | 638 | 800 | 1038 | 11
Barnstead | 867 | 967 | 851 | 710 | 745 | 976 | 19
Belmont | 1115 | 1281 | 1016 | 1047 | 911 | 1334 | 49
Gilford | 1337 | 1531 | 1185 | 1200 | 1052 | 1927 | 15
TOTALS | 4155 | 4734 | 3819 | 3595 | 3508 | 5275 | 94
District No. 6 (1) | [NAME], r |  | [NAME]
Gilmanton | 1396 |  | 9
Spreadsheet: 220571d1363195415-cell-to-assign-values-based-upon-goals-branch-points-copy
Sheet: 3rd Q

July
Acc Gain
$ Profit
% Profit
SF
BD
% LV
Totals Points
August
Acc Gain
$ Profit
% Profit
SF
BD
% LV
Totals Points
September
Acc Gain
$ Profit
% Profit
SF
BD
% LV
Totals Points
Spreadsheet: 802914d1667145376-vlookup-hlookup-match-index-with-countifs-labour-allocation-spreadsheet-example-aligw
Sheet: Name Allocation

Name | Role | 2022-10-31 00:00:00 | 2022-11-01 00:00:00 | 2022-11-02 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00 | 2022-11-05 00:00:00 | 2022-11-06 00:00:00 | 2022-11-07 00:00:00 | 2022-11-08 00:00:00
[NAME] | Joiner | Project 1 | Project 3 | Project 2 | Project 1 | Project 3 | Project 2 | Project 1 | Project 3 | Project 2
[NAME] | Plumber | Project 2 | Project 1 | Project 3 | Project 2 | Project 1 | Project 3 | Project 2 | Project 1 | Project 3
[NAME] | Tiler | Project 3 | Project 2 | Project 1 | Project 3 | Project 2 | Project 1 | Project 3 | Project 2 | Project 1
[NAME] | Electrician | Project 1 | Project 2 | Project 3 | Project 1 | Project 2 | Project 3 | Project 1 | Project 2 | Project 3
[NAME] | Plumber | Project 2 | Project 3 | Project 1 | Project 2 | Project 3 | Project 1 | Project 2 | Project 3 | Project 1
Trevor | Tiler | Project 3 | Project 1 | Project 3 | Project 3 | Project 1 | Project 3 | Project 3 | Project 1 | Project 3
[NAME] | Joiner | Project 1 | Project 3 | Project 2 | Project 1 | Project 3 | Project 2 | Project 1 | Project 3 | Project 2
Spreadsheet: kate_symes__18323__DJ Index 4-22 RTC
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-23 00:00:00
Flow Date: | 4/22/2001 - Sunday Round-the-Clock
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 207.5 | 800
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 207.5 | 400
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 212.1951219512195 | 2624
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 212.1951219512195 | 1312
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 100.5448275862069 | 6960
 | Firm Trades Purchases | 98.75 | 960
[NAME] | Firm Trades Sales | 100.5448275862069 | 3480
 | Firm Trades Purchases | 98.75 | 480
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 108.936170212766 | 752
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 108.936170212766 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 173.0403458213256 | 5552
 | Firm Trades Purchases | 169.1666666666667 | 2400
[NAME] | Firm Trades Sales | 173.0403458213256 | 2776
 | Firm Trades Purchases | 169.1666666666667 | 1200
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 104.6153846153846 | 5200
 | Firm Trades Purchases | 106.3095238095238 | 1680
[NAME] | Firm Trades Sales | 104.6153846153846 | 2600
 | Firm Trades Purchases | 106.3095238095238 | 840
Spreadsheet: 801212d1666117002-formula-to-sift-all-rows-containing-a-certain-number-into-a-table-on-another-sheet-sample
Sheet: Sheet1

Room | Element | As Existing | Work Required | By Whom | Sequence | Complete
Living Room | Floor | Bare floorboards, non-insulated, poor condition with gaps but complete | QQ | [NAME] | 1 | N
 |  |  | WW | [NAME] | 2 | N
 |  |  | EE | [NAME] | 2 | N
 |  |  | RR | Contractor | 3 | N
 |  |  | TT | [NAME] | 4 | N
 |  |  | YY | [NAME] | 5 | N
 |  |  | UU | [NAME] | 6 | N
 |  |  | II | [NAME] | 7 | N
 |  |  | OO | [NAME] | 8 | N
 |  |  | PP | [NAME] | 9 | N
 |  |  | AA | [NAME] | 10 | N
Other room | Floor | Bare floorboards, non-insulated, poor condition with gaps but complete | Floorboards raised and numbered to enable plumbing/electrical and insulation | [NAME] | 1 | N
 |  |  | Any joist repairs undertaken | [NAME] | 2 | N
 |  |  | Temporary chipboard sheets laid to enable further works | [NAME] | 2 | N
 |  |  | Plumbing and electrics | Contractor | 3 | N
 |  |  | Under floor insulation - Sheep Wool with membrane plus sound insulating sheep wool tape across joists | [NAME] | 4 | N
 |  |  | Floorboards replaced as original - all protruding nails hammered below surface | [NAME] | 5 | N
 |  |  | Initial rough course of HSS belt sanding - diagonal course | [NAME] | 6 | N
 |  |  | Gaps filled with reclaimed pine slivers. Slivers to be glued, set, and chiselled level | [NAME] | 7 | N
 |  |  | Medium course of HSS belt sanding, plus skirting sander for edges | [NAME] | 8 | N
 |  |  | Fine course of HSS belt sanding plus skirting sander for edges | [NAME] | 9 | N
 |  |  | Floor finish applied - oil-based (treatex, liberon, or osmo polyx) | [NAME] | 10 | N
Spreadsheet: 269853d1381309170-problems-with-index-and-match-book12
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME]
2013-01-01 00:00:00 | 1 | 2 | 3
2013-01-02 00:00:00 | 1 | 2 | 3
2013-01-03 00:00:00 | 1 | 2 | 3
2013-01-04 00:00:00 | 1 | 2 | 3
2013-01-05 00:00:00 | 1 | 2 | 3
2013-01-06 00:00:00 | 1 | 2 | 3
2013-01-07 00:00:00 | 1 | 2 | 3
2013-01-08 00:00:00 | 1 | 2 | 3
 | [NAME]
2013-01-01 00:00:00
2013-01-02 00:00:00
2013-01-03 00:00:00
2013-01-04 00:00:00
2013-01-05 00:00:00
2013-01-06 00:00:00
2013-01-07 00:00:00
2013-01-08 00:00:00
2013-01-01 00:00:00 | 1
2013-01-02 00:00:00 | 1
2013-01-03 00:00:00 | 1
2013-01-04 00:00:00 | 1
2013-01-05 00:00:00 | 1
2013-01-06 00:00:00 | 1
2013-01-07 00:00:00 | 1
2013-01-08 00:00:00 | 1
[NAME]
[NAME]
[NAME]
Spreadsheet: 843712d1695509914-data-validation-that-removes-names-but-there-are-multiple-of-the-same-name-sample-dv-tms
Sheet: Employee List

 | *This page will be where the master list of employees will be, potentially thousands of names will be accrued
 | so I'm also not sure if the helper columns are the most efficient for a large file
 | Master List |  |  |  |  | Available List
 | First Name | Last Name | Full Name | Count |  | Full Name |  | Test
 | [NAME] | [NAME]
 | [NAME] | Matthews |  |  |  | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  |  |  | [NAME] |  | [NAME]
 | [NAME] | Cole |  |  |  | [NAME] |  | [NAME]
 | [NAME] | Saggat |  |  |  | [NAME] |  | [NAME]
 | [NAME] | Burns |  |  |  | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  |  |  | [NAME] |  | [NAME]
 | Fred | Fender |  |  |  | [NAME] |  | [NAME]
 | [NAME] | Sinatra
 | [NAME] | [NAME]
Spreadsheet: 884824d1734084512-vlookup-returns-a-value-of-0-even-though-there-is-no-valid-numerical-number-workbook-a_simplified
Sheet: ReferenceTable

Fixture Type | Category | Normal Operation | [NAME] (degC) |  |  |  |  |  |  |  | Category | Normal Operation | [NAME] (degC)
Sinks | Piping Distribution System |  | 65 |  |  |  |  |  |  |  | Hot Water Storage Tanks | 70 | 80
Lavatory |  |  |  |  |  |  |  |  |  |  | Piping Distribution System | 60 | 65
Hand Sink |  |  |  |  |  |  |  |  |  |  | Patient/Public-Use Outlets | 43 | 49
 |  |  |  |  |  |  |  |  |  |  | General-Use Outlets, Food Prep Area, Central Supply Rooms | 49 | 60
 |  |  |  |  |  |  |  |  |  |  | Automatic Washer(s) | 77 | 82
 |  |  |  |  |  |  |  |  |  |  | Laundry | 77 | 82
 |  |  |  |  |  |  |  |  |  |  | Other Uses | 43 | 65
Spreadsheet: 550143d1512128024-need-formula-to-bring-a-cell-value-from-non-successive-rows-sample-data
Sheet: Sheet 1

Invoice | Value | Mapping Value | Pending Amount
Invoice A | 500 | 400 | 100
Invoice B | 600 | 450
Invoice A | Need formula to bring D2 value here | 50 | 50
Invoice B | Need formula to bring D3 value here | 150 | 0
Invoice A | Need formula to bring D4 value here | 25 | 25
Invoice A | Need formula to bring D6 value here | 25 | 0
Note : "Invoice A" is there in multiple rows which are not successive
End result will be like the below table
Invoice | Value | Mapping Value | Pending Amount
Invoice A | 500 | 400 | 100
Invoice B | 600 | 450
Invoice A | 100 | 50 | 50
Invoice B | 150 | 150 | 0
Invoice A | 50 | 25 | 25
Invoice A | 25 | 25 | 0
Spreadsheet: 828091d1683216283-need-help-to-evaluate-multiple-cell-contents-on-a-row-and-return-the-number-of-variations-sample-cell-contents-evaluation-formula
Sheet: Sheet1

Account # |  | [NAME] | Comments | ID #1 | ID #2 | ID #3 | ID #4 | ID #5 | ID #6 | ID #7 | ID #8 | ID #9 | ID #10
231155 |  |  | wrong | 8411325 | 8411325 | 651145 | 8411325 | NULL | 8411325 | 811221
260822 |  |  | Correct | 6513310 | NULL | 6513310 | 7291148 | 6513310 | NULL | 6513310
267213 |  |  | Correct | 7125211 | 7125211 | 7125211
215447 |  |  | Wrong | 3501821 | 4173801 | 4173801 | 3501821 | NULL | 3501821 | 3111311
213252 |  |  | Correct | 3091443 | 3091443
210269 |  |  | Wrong | 3431255 | 3614348 | 3431255 | 3551431 | 3431255
Spreadsheet: 707632d1607382207-countifs-with-year-function-with-blank-and-error-data-countifs-with-multiple-criteria-with-blank-and-error-data
Sheet: Sheet1

STATUS | DATE |  | CRITERIA 1 | CLOSED
CLOSED |  |  | CRITERIA 2 | 2019
OPEN | #N/A
CLOSED | 2020-04-01 00:00:00 |  | Desired COUNTIFS result |  |  | 4
OPEN
CLOSED | #N/A
OPEN | 2019-04-01 00:00:00
CLOSED
OPEN | #N/A
CLOSED | 2019-05-01 00:00:00
OPEN
CLOSED | #N/A
OPEN | 2019-06-01 00:00:00
CLOSED
OPEN | #N/A
CLOSED | 2019-12-01 00:00:00
OPEN
CLOSED | #N/A
OPEN | 2020-09-01 00:00:00
CLOSED
OPEN | #N/A
CLOSED | 2020-01-01 00:00:00
OPEN
CLOSED | #N/A
OPEN | 2020-07-01 00:00:00
Spreadsheet: 779618d1651910530-way-to-hide-certain-dates-when-date-is-in-another-field-daf-dharvey-no-all-dates-aligw
Sheet: Sheet1

Dates - Week One |  |  |  |  |  |  | Dates - Week Two
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Holiday Dates
2022-04-15 00:00:00 | Good Friday
2022-04-16 00:00:00 | Saturday before Easter Sunday
2022-04-17 00:00:00 | Easter Sunday
2022-04-18 00:00:00 | Easter Monday
2022-04-25 00:00:00 | Anzac Day
2022-06-13 00:00:00 | Queen's Birthday
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 13c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche
Europe | 0 | 957862 | 0 | 128813
North America/Asia | 0 | 1088004 | 0 | 117568
Index
Asia | 0 | 196980 | 0 | 45781
Europe | 2062139 | 3990836 | 924809 | 962696
North America | 884786 | 3400619 | 482473 | 1205076
Other | 13151 | 459684 | 6499 | 64701
Other
Exotic/Total Return Swap | 0 | 72780 | 0 | 36199
Swaptions | 0 | 709910 | 0 | 293357
TOTAL
Spreadsheet: f9e67ce6-a842-4e28-90a3-5eba2ad5f1e1
Sheet: Sheet1

Release: Housing Units Authorized By Building Permits | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=148
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-31 1:19 PM CDT
 | Real-Time | Period
Name: | Start | End
Housing Units Authorized By Building Permits | 2007-11-28 00:00:00 | Current
Link:
http://www.census.gov/construction/bps/ | 2007-11-28 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2007-11-28 00:00:00 | Current
Notes:
Table 2 - United States, Region, Division and State (Unadjusted Data) | 2007-11-28 00:00:00 | Current
Table 3 - Metropolitan Areas (Unadjusted Data)
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-11-28 00:00:00
2007-12-27 00:00:00
2008-01-28 00:00:00
2008-02-27 00:00:00
2008-03-26 00:00:00
2008-04-24 00:00:00
2008-05-27 00:00:00
2008-06-25 00:00:00
2008-07-25 00:00:00
2008-08-26 00:00:00
2008-09-25 00:00:00
2008-10-27 00:00:00
2008-11-26 00:00:00
2008-12-23 00:00:00
2009-01-29 00:00:00
2009-02-26 00:00:00
2009-03-25 00:00:00
2009-04-24 00:00:00
2009-05-27 00:00:00
2009-06-24 00:00:00
2009-07-27 00:00:00
2009-08-26 00:00:00
2009-09-25 00:00:00
2009-10-27 00:00:00
2009-11-25 00:00:00
2009-12-23 00:00:00
2010-01-28 00:00:00
2010-02-25 00:00:00
2010-03-24 00:00:00
2010-04-26 00:00:00
2010-05-26 00:00:00
2010-06-24 00:00:00
2010-07-27 00:00:00
2010-08-25 00:00:00
2010-09-27 00:00:00
2010-10-27 00:00:00
2010-11-24 00:00:00
2010-12-23 00:00:00
2011-01-27 00:00:00
2011-02-25 00:00:00
2011-03-24 00:00:00
2011-04-26 00:00:00
2011-05-25 00:00:00
2011-06-24 00:00:00
2011-07-27 00:00:00
2011-08-24 00:00:00
2011-09-27 00:00:00
2011-10-27 00:00:00
2011-11-28 00:00:00
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
2013-05-24 00:00:00
2013-06-26 00:00:00
2013-07-25 00:00:00
2013-08-26 00:00:00
2013-09-26 00:00:00
2013-11-27 00:00:00
2013-12-24 00:00:00
2014-01-28 00:00:00
2014-02-27 00:00:00
2014-03-26 00:00:00
2014-04-24 00:00:00
2014-05-27 00:00:00
2014-06-25 00:00:00
2014-07-25 00:00:00
Spreadsheet: tracy_geaccone__40304__02CapPlan_8_27_01
Sheet: NNG Imb. & Purch.

NORTHERN NATURAL GAS COMPANY
1996 ACTUAL - 2003 PROJECTION
IMBALANCE SETTLEMENTS / GAS PURCHASES
($ Millions)
 |  |  |  |  |  |  |  | 1996 |  | 1997 |  | 1998 |  | 1999 |  | 2000 |  | 2001 |  | 2002 |  | 2003
 |  |  |  |  |  |  |  | Actual |  | Actual |  | Actual |  | Actual |  | Actual |  | CE |  | Est. (1) |  | Est. (1)
Net Cash Flow Impact
 | Imbalance Activity - Cash In |  |  |  |  |  |  | 7.1 |  | 15.5 |  | 22.4 |  | 25 |  | 84 |  | 41
 |  | - Cash Out |  |  |  |  |  | -18.4 |  | -25 |  | -26.1 |  | -20.7 |  | -21.3 |  | -53.2
 |  | Net Imbalance Activity
 | Gas Purchases |  |  |  |  |  |  | -17.1 |  | -14.6 |  | -4.4 |  | -12.4 |  | -67.3 |  | -64.4
 |  | - Misc. |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Total Gas Purchases
 |  | Net Cash Flow Impact
Notes:
(1)  Estimate based on the average of 1998 through 2001.
(2)  Gas volumes purchased in one month are paid for in the next month
 |  | - Carlton |  |  |  |  |  | 0 |  | -2.6 |  | -2.6 |  | -2.6 |  | -2.5 |  | -2.5 |  | -2.5 |  | -2.5
Spreadsheet: joe_parks__14924__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-04-11 00:00:00
From the Waha Area | 200000
East of Waha to | 125000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25000
 | * Carthage Plant OK for 25,000
Spreadsheet: 861791d1709633293-countifs-and-averageifs-formula-9-aligw
Sheet: Sheet1

Date | Signal 1 | Signal 2 | Gains
2024-01-01 00:00:00 | Buy | Buy | 0.01
2024-01-02 00:00:00 | Buy | Buy | 0.02
 |  |  | t
2024-01-04 00:00:00 | Buy | Sell | 0.04
2024-01-05 00:00:00 | Buy | Buy | 0.05
2024-01-06 00:00:00 | Buy | Buy | -0.01
2024-01-07 00:00:00 | Sell | Sell | -0.02
2024-01-08 00:00:00 | Sell | Sell | -0.03
2024-01-09 00:00:00 | Buy | Buy | 0.04
2024-01-10 00:00:00 | Sell | Sell | 0.05
Requested formulas |  |  |  |  |  |  |  | Expected results:
1. Count all rows that Signal 1 = signal 2 and positive gains |  |  |  |  |  |  |  | 6
2. same as 1. but with average gains |  |  |  |  |  |  |  | 0.033
if possible, please use countifs and [NAME]
Spreadsheet: 823906d1680192073-populating-a-value-based-on-a-series-of-data-budget
Sheet: Sheet1

The following are the TYPES of selections I would have the option of choosing per employee.  Note for this first set of data, the options are by column
Insurance Selection | Employee Type | Coverage Selected | Healthcare Selection
Healthcare | Hourly | Employee Only | Standard
Dental | Salary | Employee & Spouse | Buy Up Plan
Vision |  | Employee and Children
 |  | Employee & Family
 |  | Waived
This next set of data would be the amounts that I am looking to populate based on the data chosen from above
Healthcare | Standard | Type | Employee Only | Employee & Spouse | Employee and Children | Employee & Family | Waived
healthcare | Hourly Employee | Standard | 84.42 | 226.41 | 135.91 | 257.75 | 0
healthcare | [NAME] | Standard | 91.45 | 245.28 | 147.23 | 279.24 | 0
healthcare | Hourly Employee | Buy Up | 123.6 | 260.49 | 250.17 | 372.03 | 0
healthcare | [NAME] | Buy Up | 133.61 | 282.2 | 271.03 | 403.03 | 0
dental | Hourly Employee | NA | 4.19 | 8.56 | 15.81 | 15.81 | 0
dental | [NAME] | NA | 4.55 | 9.28 | 17.13 | 17.13 | 0
vision | Hourly Employee | NA | 4.54 | 7.47 | 7.41 | 11.95 | 0
vision | [NAME] | NA | 4.92 | 8.1 | 8.03 | 12.95 | 0
Sample of data I would like to populate - I highlighted different colors from the above table to show my expected value
Employee Name | Employee Type | Healthcare | Expected Value | Dental | Expected | Vision | Expected
[NAME] | Salary | Employee Only/Standard | 91.45 | Employee & Spouse | 9.28 | Employee and Family | 12.95
[NAME] | Hourly | EE & Family/Buy Up | 372.03 | Employee Only | 4.19 | Waived | 0
Spreadsheet: 487786d1478253298-formula-formula
Sheet: Sheet1

2999
44
 |  |  |  | (1)-,+(should be positive taking  )
2247 |  |  |  | (2)+,-(should be negative taking )
-25.08 | This is okay |  |  | (3)+,+(positive is second is larger and negative if 1 is larger)
 |  |  |  | (4)-,-(negative is second is larger and positive if 1 is larger)
1479 |  |  |  | (5)0,-(negative)
 |  |  |  | (6)0,+(positive)
-34.18 | This is okay |  |  | (7)-,0(positive)
2610 |  |  |  | (8)+,0(negative)
76.47 | This is okay
4251
62.87 | This is okay
10903
156.48 | this should come ~256% |  |  | The blank space in between is needed as other values come there ehich has not to be included in this formula
 |  |  |  | that same formula should work giving correct results on A5,A9,A12,A15,A18 AND d5, d9, d12, d15, d18
-2250
-100 | this should come ~-120, as 10903>0 is -100 and  then 0 to -2250, is -21, so ~-121%
875
 |  |  |  | -4250 | 100
38.89 | this should come 138% |  |  | 52250
-1000
-214.29 | this is okay
-4250
-325 | this should come -425
52250
1229.41 | this is okay
Spreadsheet: 834345d1687712886-creating-another-sheet-from-a-master-excel-forum-planner-26-6-2023
Sheet: Preview

Midlands Preview Work Planner
Week Commencing |  |  |  |  | 2023-06-26 00:00:00
Name |  |  |  |  |  |  |  |  |  |  |  |  |  | Engine Service |  | S | Other Site Work |  | I
 | [NAME] |  |  |  | On Call till Thursday |  |  |  |  |  |  |  |  | Engine Repair |  | D | Daily |  | J
 | [NAME] |  |  |  | 27th & 28th holiday |  |  |  |  |  |  |  |  | Other |  | C | Weekly |  | W
 | [NAME] |  |  |  | 28th Holiday |  |  |  |  |  |  |  |  | Training/Meeting |  | TM | Quarterly |  | Q
 | [NAME] |  |  |  | On Call from Friday |  |  |  |  |  |  |  |  | Gas Balance |  | G | GF Maintenance |  | GFM
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Availability |  | A
 | [NAME]
 |  | Lincoln |  | Warboys |  | [NAME] |  | Gresley |  | Sandwell |  | Wednesbury |  | Mucklow |  | Granville |  | Himley
Mon | AM
 | PM
[NAME] | AM
 | PM
Wed | AM
 | PM
Thurs | AM
 | PM
Fri | AM
 | PM
 |  |  | Day | site works
 |  |  | Mon
 |  |  | [NAME]
 |  |  | Wed
 |  |  | Thurs
 |  |  | Fri
Spreadsheet: 722481d1615293288-formula-if-one-or-more-the-cells-within-a-selection-of-cells-contains-text-then-change-tex-dailymanagement-test
Sheet: Employees

Day | 1 | 2 | 3
Employee 1 | Green | Green | Green
Employee 2 | Green | Green | Green
Employee 3 | Green | Green | Green
Employee 4 | Orange | Green | Green
Employee 5 | Orange | Green | Green
Employee 6 | Red | Green | Green
Employee 7 | Green | Green | Green
Employee 8 | Green | Green | Green
Employee 9 | Green | Green | Green
Employee 10 | Green | Green | Green
Manager 1 | Orange | Green | Green
Manager 2 | Green | Green | Green
Manager 3 | Red | Green | Green
Manager 4 | Green | Green | Green
Manager 5 | Green | Green | Green
Spreadsheet: 848902d1699512413-extract-data-from-raw-data-tab-test-file-7-aligw
Sheet: Results

Results
Person Name | Physics | Science | Chemistry | History | Math
Derek
Duke
[NAME]
Jamison
Jeremy
Joee
[NAME]
Louis
Rio
Shawn
[NAME]
[NAME]