tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827047d1682444259-divide-points-by-rank-divide-points-test-answer5
Sheet: Sheet1

Points | Rank 1 | Player # | Rank | SCORE | 0.1 | 0.05
100 | 0.3 | 4 | 1
 |  | 7 | 1 | 22.5 | 20 | 20
Players |  | 1 | 3 | 12.82976950846987 | 13.99611219105804 | 13.99611219105804
10 |  | 9 | 4 | 9.622327131352401 | 10.49708414329353 | 10.49708414329353
 |  | 8 | 5 | 7.697861705081921 | 8.397667314634822 | 8.397667314634822
 |  | 6 | 6 | 6.414884754234934 | 6.998056095529019 | 6.998056095529019
 |  | 5 | 7 | 5.498472646487087 | 5.99833379616773 | 5.99833379616773
 |  | 10 | 8 | 4.811163565676201 | 5.248542071646764 | 5.248542071646764
 |  | 2 | 9 | 4.276589836156623 | 4.665370730352679 | 4.665370730352679
 |  | 3 | 10 | 3.848930852540961 | 4.198833657317411 | 4.198833657317411
 |  |  |  | SUM
Points | Rank 1 | Player # | Rank | SCORE |  |  | [NAME]
100 | 0.3 | 4 | 1 |  | 1 | [NAME]
 |  | 7 | 1 |  | 2 | D32
Players |  | 1 | 3 |  | 3 | D33
 |  | 9 | 4 |  | 4 | D34
 |  | 8 | 5 |  | 5 | D35
 |  | 6 | 6 |  | 6 | [NAME]
 |  | 5 | 7 |  | 7 | D37
 |  | 10 | 8 |  | 8 | D38
 |  | 2 | 9 |  | 9 | D39
 |  | 3 | 10 |  | 10 | D40
 |  |  |  |  | 11 | D41
 |  |  |  |  | 12 | D42
 |  |  |  |  | 13 | D43
 |  |  |  |  | 14 | D44
 |  |  |  |  | 15 | D45
 |  |  |  |  | 16 | D46
 |  |  |  |  | 17 | D47
 |  |  |  |  | 18 | D48
 |  |  |  |  | 19 | D49
 |  |  |  |  | 20 | D50
 |  |  |  |  | 21 | D51
 |  |  |  | SUM
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 10a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated net notional amount outstanding, January 4 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
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 and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared 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: 593804d1539337754-im-having-a-problem-formatting-a-column-so-that-it-shows-a-percentage-the-way-i-need-example-2
Sheet: Sheet1

1975 | 8
1976 | 6.4
1977 | 5.9
1978 | 6.5
1979 | 9.9
1980 | 14.3
1981 | 11.2
1982 | 7.4
1983 | 3.5
1984 | 3.5
1985 | 3.1
1986 | 1.3
1987 | 4.2
1988 | 4
1989 | 4.7
1990 | 5.4
1991 | 3.7
1992 | 3
1993 | 2.6
1994 | 2.8
1995 | 2.6
1996 | 2.9
1997 | 2.1
1998 | 1.3
1999 | 2.5
2000 | 3.5
2001 | 2.6
2002 | 1.4
2003 | 2.1
2004 | 2.7
2005 | 4.1
2006 | 3.3
2007 | 2.3
2008 | 5.8
2009 | 0
2010 | 0
2011 | 3.6
2012 | 1.7
2013 | 1.5
2014 | 1.7
2015 | 0
2016 | 0.3
2017 | 2
2018 | 2.8
Spreadsheet: 130997d1322682458-re-arrange-a-worksheet-range-to-a-pivot-friendly-table-forumquestion-xytabletopivotfriendlytable
Sheet: Sheet1

 | SOURCE TABLE |  |  |  |  |  |  |  |  | DESTINATION TABLE
 | Timestamp | Task | Robb | Sansa | [NAME] | Arya | [NAME] |  |  | Timestamp | Task | Name | Score | Gender | Group | TaskCategory | TaskOther | HelperCell-Name_Task | HelperCell-Name_Date | Helper-Group_Task
1 | 2011-11-29 15:45:08 | Task A | 6 | 4 | 5 | 8 | 9 |  |  | 2011-11-29 15:45:08 | Task A | Robb | 6
2 | 2011-11-30 14:05:08 | Task B | 8 | 6 | 9 | 8 | 4 |  |  | 2011-11-29 15:45:08 | Task A | Sansa | 4
3 | 2011-12-03 15:02:08 | Task A | 5 | 6 | 7 | 9 | 4 |  |  | 2011-11-29 15:45:08 | Task A | [NAME] | 5
 |  |  |  |  |  |  |  |  |  | 2011-11-29 15:45:08 | Task A | Arya | 8
 |  |  |  |  |  |  |  |  |  | 2011-11-29 15:45:08 | Task A | [NAME] | 9
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | Robb | 8
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | Sansa | 6
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | [NAME] | 9
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | Arya | 8
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | [NAME] | 4
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | Robb | 5
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | Sansa | 6
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | [NAME] | 7
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | Arya | 9
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | [NAME] | 4
 | NUMBER OF PEOPLE |  | (counts the number of people in the grey table below --  this number is used to determine the "PersonNum" and "RowNum" columns below
Fixed Num | PersonNum | RowNum |  |  |  |  | Helper cells:
 | 0 | 0 | Timestamp | Task | Name | Score
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
 | Num | Name | Gender | Group |  | Task | Category | Other |  |  | TOTAL (ALL TASKS) | (Pink cells - dropdown)
 | 1 | Robb | M | RR |  | Task A | Blue | UPHP |  |  | Group | KL
 | 2 | Sansa | F | KL |  | Task B | Red | RUEO |  |  | TOTAL (By Task):
 | 3 | [NAME] | M | WF |  | Task C | Green | DHFO |  |  | Group: | RR | Task: | Task B | Total:
 | 4 | Arya | F | KL |  | Task D | Blue | NSUU |  |  | INDIVIDUAL TOTAL (By Task)
 | 5 | [NAME] | M | WF |  |  |  |  |  |  | Person: | Arya | Task: | Task A | Total:
 | 6
 |  |  |  |  | Group List
 |  |  |  |  | KL
 |  |  |  |  | RR
 |  |  |  |  | W
 |  |  |  |  | WF
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 778 | 0 | 372
Cross-Currency Fixed-Fixed | 0 | 55 | 0 | 89
Cross-Currency Fixed-Float | 0 | 566 | 0 | 398
TOTAL | -
Spreadsheet: 869513d1716099644-bypass-the-number-of-cells-based-on-the-value-ang-highlight-calender-template-1-aligw
Sheet: Sheet1

Start Date | Frequency | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00
2024-01-01 00:00:00 | 7
2024-01-01 00:00:00 | 10
2024-01-01 00:00:00 | 5
2024-01-01 00:00:00 | 12
2024-01-01 00:00:00 | 4
2024-01-01 00:00:00 | 3
Spreadsheet: 264ef56f-8515-4563-b2cd-4bdafbdb787b
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 55 | 356498 | 347338 | 336926 | 324265
55 - 60 | 30506 | 30581 | 35623 | 33461
60 - 65 | 27777 | 30574 | 30135 | 35039
65 - 75 | 62840 | 55359 | 54180 | 59109
75 - 85 | 38562 | 48033 | 52753 | 45105
85 und mehr | 13598 | 15907 | 19167 | 26305
Insgesamt | 529781 | 527792 | 528784 | 523284
%
unter 55 | 67.29157897319837 | 65.8096371297784 | 63.71713213712972 | 61.96730647220248
55 - 60 | 5.758228400036996 | 5.794138600054567 | 6.736777209597871 | 6.394424442558916
60 - 65 | 5.24310988880311 | 5.792812320004851 | 5.698924324487882 | 6.695981532017031
65 - 75 | 11.86150503698698 | 10.48879103889411 | 10.24614965657055 | 11.29577820074759
75 - 85 | 7.278856735141502 | 9.10074423257647 | 9.976285212865745 | 8.61960235741968
85 und mehr | 2.566720965833052 | 3.013876678691606 | 3.62473145934824 | 5.026906995054311
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 31. [NAME] 2008
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 681325d1591478113-grouping-continuous-dates-dates-example
Sheet: Sheet1

Tenant | Property | From | To | Method 1 | What it should be
A | House1 | 2011-09-01 00:00:00 | 2012-08-31 00:00:00 |  | 1
A | House2 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 |  | 2
B | House4 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 |  | 1
A | House3 | 2014-09-01 00:00:00 | 2015-08-31 00:00:00 |  | 3
A | House3 | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 |  | 4
B | House4 | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 |  | 2
B | House4 | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 |  | 2
A | House4 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  | 5
B | House4 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  | 2
A | House4 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 5
C | House5 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 1
A | House4 | 2020-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 5
Spreadsheet: louise_kitchen__23047__11-08 Short Term Cash
Sheet: Variance

Changes as of 10:00 am
Current Day Variance
 | 590.63 |  | Projected beginning last night
 | -0.16 |  | Forecasted receipts not received
 |  |  | Actual Opening Balance
 | -268.86 |  | Business units detailed on schedule
 |  |  | Net A2P2 shown on schedule
 |  |  | Net A1P1 shown on schedule
 |  |  | End of Day Adjustment
 |  |  | Rounding
 |  |  | Expected Ending 11/8/01
Total Variance
 | 45.81 | 12/31 Forecast as of 11/7
 | -0.16 | Beg. [NAME].
 |  | Current Day BU/Corp Activity
 |  | -0.7 | Estimate
 |  | -268.86 | Actual for all operations
 |  | End of Day adj
 | 0.01 | Rounding
 |  | 12/31 Forecast as of 11/8
Spreadsheet: 00e545c4-cc5d-4756-b621-711a62274c6d
Sheet: Sheet1

 | LCCC Prioritization Checklist for New Trials
 | PI Name: |  | Study Number: |  | Short Title:
 |  | Factor | Sub-Factors |  |  | Points Available | Calculated Points
 | Sponsor Type: | (please place an "x" beside the applicable entry) | LCCC IIT |  |  | X=6
 |  |  | Non-UNC IIT |  |  | X=3
 |  |  | Externally  Peer Reviewed |  |  | X=3
 |  |  | Cooperative Group |  |  | x=3
 |  |  | Industry |  |  | x=1
 | Collaboration:
 | Phase II for UNC [NAME]? |  | LCCC IIT multicenter with community sites |  |  | 2 for Yes, 0 for No
 | Inter Institutional Collaboration. |  | LCCC IIT multicenter with academic sites |  |  | 1 for Yes, 0 for No
 | Provides Support for LCCC correlative research?                                                                                          Explain>> |  |  |  |  | 2 for Yes, 0 for No
 | Collaboration outside of LCCC with in UNC?                                                                                                  Explain>> |  |  |  |  | 1 for Yes, 0 for No
 | Involves named [NAME]?                                       (Indicate name:  ACCRU, Aptium, BTTC,SEP2C, TBCRC)>> |  |  |  |  | 3 for Yes, 0 for No
 | Science
 | Phase I Trial |  |  |  |  | 3 for Yes, 0 for No
 | Builds on Previous/Existing LCCC Research or continues prior phase trial completed here.                Explain>> |  |  |  |  | 2 for Yes, 0 for No
 | Authorship Potential
 | UNC Authorship Potential: |  | Yes, UNC PI will be first author |  |  | 3 for Yes, 0 for No
 |  |  | Yes, UNC PI will not be first author |  |  | 1 for Yes, 0 for No
 |  |  | No Authorship Potential (respond No to both above)
 | PI is Study Chair  for Cooperative Group Trial |  |  |  |  | 2 for Yes, 0 for No
 | Income & Clinical Potential
 | Compelling clinical need (i.e. drug with documented efficacy that is not yet commercially available).                                                                                                                Explain>> |  |  |  |  | 1 for Yes, 0 for No
 | Expected accrual 5, 10 or greater. |  | Enter Target Accrual # |  |  | 1 for >=5, 3 for >=10
 | Budget (Expected Revenue) |  | Projected Trial Income will exceed costs |  |  | 3  for Yes, 0 for No
 | **to be provided to PI by Finance. Trials with insufficient funding will be reviewed by POEC. |  | ….If not, is trial projected to break even? (revenue = costs) |  |  | 1 for Yes, 0 for No
 |  |  | Finance comment:
 | POEC Bonus | (added by POEC only)
 | Version 2-12-2013 |  |  |  |  | Total Points
 |  |  |  |  | Minimum Score for CPO implentation = 4
 |  |  |  |  | POD Leader to Validate score at sign off.
Spreadsheet: 37675d1235697912-formula-excluding-string-of-zeros-datasample
Sheet: Sheet1

 | 2008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hope To Achieve
Item | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | STDEV
A002AMF0100A103 | 0 | 432 | 720 | 432 | 432 | 1584 | 2736 | 2880 | 1440 | 576 | 1440 | 864 | 720 | 1728 | 1152 | 576 | 0 | 3888 | 1584 | 720 | 864 | 576 |  | Correct
A020AMF0100A104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9672 | 0 | 0 | 1248 | 3360 | 384 | 0 | 3648 | 2136 | 0 |  | 3029.49342
A043AMF0080A104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9672 | 0 | 0 | 1248 | 2688 | 2136 | 528 | 312 | 1003 | 101 |  | 2924.96404
The item numbers are qty ordered by week. As you see in row 3 & 4, we did not produce the item until week 13 so the zeros skew the standard deviation, mean, etc. I would like to have the formula exclude a string of zeros of five or more.
This would cover our monthly, quarterly, and new items launched later in the year. Appreciate any input on this. Thanks.
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 14b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia |  | <100 | 358
 | Europe |  |  | 171254
 | North America | 18405 | 138418 | 2094
Index | Asia | 555 | 8244 | 12828
 | Europe |  |  | 380716
 | North America | 89992 | 367457 | 57748
TOTAL |  | 108951 | 514119 | 625000
Estimated net notional amount outstanding, December 21 weekly snapshot, by product type and grade (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type  as more complete data becomes available.
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 Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 35007d1232478381-sumif-sumif-example
Sheet: Sheet1

Employee | Bonus | Frequency | Date
[NAME] | 225 | Annual | 2008-10-03 00:00:00
[NAME] | 6000 | Annual | 2008-10-30 00:00:00
[NAME] | 55 | Annual | 2008-07-31 00:00:00
[NAME] | 99.95 | Annual | 2008-06-26 00:00:00
[NAME] | 525 | Annual | 2008-08-05 00:00:00
Sue | 49.95 | Annual | 2008-07-17 00:00:00
[NAME] | 500 | Annual | 2008-11-02 00:00:00
Molly | 299 | Annual | 2008-08-12 00:00:00
[NAME] | 349.65 | Annual | 2008-07-29 00:00:00
Desired Result
Date | Total Bonus
Jan
Feb
Mar
Apr
May
Jun
Jul | 454.6
Aug | 824
Sep
Oct | 6225
Nov | 500
Dec
Spreadsheet: 864105d1711425560-concise-formulas-to-make-excel-file-smaller-sample-results
Sheet: Dashboard 2024

AS | Jan | Jan% | Feb | Feb% | Mar | [NAME] | Apr | Apr% | May | May% | Jun | Jun% | Jul | [NAME] | Aug | Aug% | Sep | Sep% | Oct | Oct% | Nov | Nov% | Dec | Dec%
Overall Satisfaction Score
Easy
Prompt
Expertise
Clear
Sales | Jan | Jan% | Feb | Feb% | Mar | [NAME] | Apr | Apr% | May | May% | Jun | Jun% | Jul | [NAME] | Aug | Aug% | Sep | Sep% | Oct | Oct% | Nov | Nov% | Dec | Dec%
Overall Satisfaction Score |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Suitable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AS
Responsiveness |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales
Expectations
Satisfied
Spreadsheet: phillip_allen__28830__routine
Sheet: routine

 | Trading Rules
 | 1.  Think for yourself.
 | 2.  Trade the market not your own opinions.
 | 3.  Plan your trade and trade your plan.
 | 4.  Money management.
 | 5.  Focus on path of least resistance.
 | 6.  No ego.  Learn to take small losses.
 | 7.  Trading is buying and selling.
 | 8.  Manage risk never sit on it.  Close positions you don't believe in.
 | Daily Routine
 | Weather
 |  | East |  | Midwest |  | West |  | Texas
 |  | 1-5 | 6-10 | 1-5 | 6-10 | 1-5 | 6-10 | 1-5 | 6-10
 | Freese
 | Earthsat
 | American
 | European
 | Canadian
 | Ensembles
 | Operational
 |  | Sendouts | Storage
 | Socal
 | PG&E
 | EOC's
 | Clay
 | Power
 | Prices-see price worksheet
 | Charts
 |  | Trend/Trendline | Yes Hi/10 Per. Hi | Yes Lo/10 Per. [NAME] | MACD | Formation | Support | Resistance
 | Weekly
 | Daily
 | 60 Min
 | Market Assessment
 |  | Range | Continue Trend | Reversal | (circle one)
 | Possible Outcomes
 | Trading Ideas
 | Plan
Spreadsheet: daren_farmer__5317__hpl0621
Sheet: Sheet1

HPLN0621.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 21, 2000
 |  |  |  |  |  | ** Wednesday | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-21 00:00:00 | 2000-06-21 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 02100 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM |  | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 60 | 0
Enron (FM) |  | HPL - Katy (DBND) |  | HPL | 0 | 0 | 0
 |  | Firm Summary
ENRON (S) |  | Oasis Turbine |  | ENA | 0 | 5
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65 | 0.65
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 841455d1693628608-adjacent-lowermost-cell-checking-sample
Sheet: Sheet1

DATE
 | IN | OUT
2023-09-04 00:00:00 | 5 | 12 |  | Lowest value |  |  | =LOOKUP(2,1/(1-ISBLANK(B5:B18)),B5:B18)
2023-09-06 00:00:00 | 1 | 2
 |  |  |  | Latest received yet?
 | 3 | 1
 | 15 | 3
 | 5
Spreadsheet: 0c114c1c-d652-45c5-a37f-48b73395480d
Sheet: Spring Semester Budget

Proposed Budget for the Upcoming Semester
 |  | Estimated | Actual
Professional Development | Description
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
Total
Events | Description
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
Total
T- Shirts | Description
 |  | 0 | 0
 |  | 0 | 0
Total
Miscellaneous | Description
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
Total
Totals
Spreadsheet: 716600d1612280288-return-a-sign-if-there-is-any-values-inside-the-month-if-not-a-sign-forum-excel-1-f-v-2021
Sheet: Paiements

Date | Description | Amount | Mode paiement | Categories | Cycle | Néc./Luxe | Type note
2020-01-01 00:00:00 | [NAME] (payé le 19-sep-2019) | 50 | Comptant | [NAME]/chauffage | Irrégulier | Nécessité | $
2020-01-01 00:00:00 | Internet [NAME] (payé le 19-sep-2019) | 100 | Comptant | Internet | Irrégulier | Nécessité | $
2020-02-01 00:00:00 | Loyer février (payé le 19-sep-2019) | 60 | Comptant | Logement | Irrégulier | Nécessité | $
2020-02-01 00:00:00 | Hydro février (payé le 19-sep-2019) | 50 | Comptant | [NAME]/chauffage | Irrégulier | Nécessité | $
Spreadsheet: 751013d1633781872-employee-days-off-holidays
Sheet: Holiday

Ian |  | Days taken | days left | Absent
2021-10-08 00:00:00
[NAME]
 |  |  | I need the word Booked to disappear when date is passed "A2" and if a person missed a day then i need booked to be replaced with Missed otherwise blank.  The data is from the Holiday data sheet
 |  |  | [NAME] has missed 2 days but its not shown up he missed 13 Sep and 9 Oct
Inserted Manually | 2021-10-06 00:00:00 | Missed
 |  |  | Dates in A2 can be changed to see effect
Spreadsheet: 200146d1355427973-excel-highlighting-cells-rotaexample
Sheet: Rota

Employee | Wed |  |  | Thur |  |  | Fri |  |  | Sat |  |  | Sun |  |  | Mon |  |  | [NAME]
Staff 1 |  |  |  | 16:00:00 | 21:30:00 |  |  |  |  |  |  |  | 11:00:00 | 19:30:00 |  | 16:00:00 | 22:30:00 |  | 16:00:00 | 22:30:00
Staff 2 | 09:00:00 | 16:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  | 08:00:00 | 15:00:00 |  |  |  |  | 15:00:00 | 22:30:00 |  | 07:00:00 | 16:00:00
Staff 3 | 07:00:00 | 15:00:00 |  |  |  |  | 16:00:00 | 21:30:00 |  | 13:00:00 | 21:30:00 |  |  |  |  | 07:00:00 | 15:00:00
Staff 4 | 07:00:00 | 15:00:00 |  | 16:00:00 | 21:30:00 |  | 07:00:00 | 15:00:00 |  | 08:00:00 | 16:00:00 |  |  |  |  | 09:00:00 | 17:00:00
Staff 5 | 17:00:00 | 21:30:00 |  | 07:00:00 | 15:00:00 |  | 09:00:00 | 16:00:00 |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 13:00:00 | 22:30:00
Staff 6 | 16:00:00 | 21:30:00 |  | 10:00:00 | 16:00:00 |  | 07:00:00 | 15:00:00 |  |  |  |  | 15:00:00 | 19:30:00 |  |  |  |  | 07:00:00 | 15:00:00
Staff 7 | 13:00:00 | 17:00:00 |  | 13:00:00 | 16:00:00 |  | 17:00:00 | 21:30:00 |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 16:00:00
Staff 8 |  |  |  |  |  |  | 13:00:00 | 17:00:00 |  |  |  |  | 11:00:00 | 15:00:00 |  |  |  |  | 17:00:00 | 22:30:00
Staff 9 |  |  |  |  |  |  |  |  |  | 12:00:00 | 21:30:00 |  |  |  |  | 13:00:00 | 17:00:00
Spreadsheet: 677720d1589483526-uk-telephone-numbers-selecting-sorting-and-formatting-sample-of-number-formats-to-excelforum
Sheet: Sheet2

NewHome | NewMobile
 | 07766 731871
 | 07971 601972
 | 07825 045119
01937 845040
 | 07720 771237
[PHONE]
 | 07927 327043
 | 07590 467070
[PHONE]
 | 07717 574470
 | 07831 184928
 | 07713 244301
01937 586639
 | 07791 316609
 | 07927 260174
 | 07807Â 887399
01757 212120 | 07788 450853
01924 277902
 | 07802 647475
 | [PHONE]
 | 07775Â 350332
01937 573512
 | 07547Â 522030
Spreadsheet: 273776d1382906574-countif-with-variable-range-excel-countif-answer
Sheet: Log

 |  |  | Count | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
 |  |  |  | Met | Missed | Missed | Met | Missed
 |  |  | Objective
 |  |  | Count the number of occurrences of the word "Missed" in the five months ended with the current month
 |  |  | The current month is a variable, and is listed on the worksheet named Month, cell D6
 |  |  | Place the result in cell D7
 |  |  | No VBA
 |  |  | Considerations
 |  |  | The dates in row 6 are currently entered as the first day of each month (e.g., 10-1-13).  However, they could actually be any date in that month (e.g., 10-16-13).
 |  |  | The Month specified on the worksheet named Month currently has a value of the first day of the month (i.e., 10-1-13).  However, the date could actually be entered as any day in that month (e.g., 10-28-13)