tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81700d1281823050-grouping-data-for-averaging-on-a-large-data-set-example_pivot
Sheet: Data

Year | Month | Day | Hour | Lat | Long | Wind Direction | Wind Speed |  | Create a Dynamic Named Range for use with the Pivot Table:
1992 | 1 | 1 | 0 | 527 | 23 | 200 | 20 |  | [NAME] Manager - New - Named Range:
1992 | 1 | 1 | 0 | 530 | 21 | 210 | 20 |  | Name: Pivot_Range
1992 | 1 | 1 | 0 | 531 | 22 | 220 | 26 |  | Refers to: =Data!$A$1:INDEX(Data!$H:$H,COUNTA(Data!$A:$A))
1992 | 1 | 1 | 0 | 535 | 22 | 210 | 10 |  | As data is added to the the table on the Data worksheet, the range will automatically increase
1992 | 1 | 1 | 1 | 527 | 23 | 200 | 21
1992 | 1 | 1 | 1 | 531 | 22 | 220 | 24 |  | Create the Pivot Table:
1992 | 1 | 1 | 1 | 535 | 22 | 210 | 9 |  | Insert - Pivot Table:
1992 | 1 | 1 | 2 | 527 | 23 | 210 | 20 |  | Used the named range Pivot_Range as the Table/Range
1992 | 1 | 1 | 2 | 531 | 22 | 220 | 25
1992 | 1 | 1 | 2 | 535 | 22 | 220 | 11
1992 | 1 | 1 | 3 | 527 | 23 | 210 | 18
1992 | 1 | 1 | 3 | 531 | 22 | 220 | 29
1992 | 1 | 1 | 3 | 535 | 22 | 210 | 12
1992 | 1 | 1 | 4 | 527 | 23 | 250 | 27
1992 | 1 | 1 | 4 | 531 | 22 | 220 | 29
1992 | 1 | 1 | 4 | 535 | 22 | 220 | 12
1992 | 1 | 1 | 5 | 527 | 23 | 250 | 28
1992 | 1 | 1 | 5 | 531 | 22 | 210 | 30
1992 | 1 | 1 | 5 | 535 | 22 | 360 | 21
1992 | 1 | 1 | 6 | 527 | 23 | 250 | 26 |  | In the Pivot Table:
1992 | 1 | 1 | 6 | 530 | 21 | 210 | 22 |  | Row Labels: Year, Month, Day, Hour
1992 | 2 | 1 | 0 | 527 | 23 | 200 | 20 |  | S Values: Average of Wind Direction, Average of Wind Speed
1992 | 2 | 1 | 0 | 530 | 21 | 210 | 20
1992 | 2 | 1 | 0 | 531 | 22 | 220 | 26 |  | Refresh the Pivot Table if you change or add to the Data Source:
1992 | 2 | 1 | 0 | 535 | 22 | 210 | 10 |  | To refresh the data in the Pivot Table, right click in the Pivot Table and click [NAME]
1992 | 2 | 1 | 1 | 527 | 23 | 200 | 21 |  | Or, with a cell in the Pivot Table selected, select [NAME]
1992 | 2 | 1 | 1 | 531 | 22 | 220 | 24
1992 | 2 | 1 | 1 | 535 | 22 | 210 | 9
1992 | 2 | 1 | 2 | 527 | 23 | 210 | 20
1992 | 2 | 1 | 2 | 531 | 22 | 220 | 25
1992 | 2 | 1 | 2 | 535 | 22 | 220 | 11
1992 | 2 | 1 | 3 | 527 | 23 | 210 | 18
1992 | 2 | 1 | 3 | 531 | 22 | 220 | 29
1992 | 2 | 1 | 3 | 535 | 22 | 210 | 12
1992 | 2 | 1 | 4 | 527 | 23 | 250 | 27
1992 | 2 | 1 | 4 | 531 | 22 | 220 | 29
1992 | 2 | 1 | 4 | 535 | 22 | 220 | 12
1992 | 2 | 1 | 5 | 527 | 23 | 250 | 28
1992 | 2 | 1 | 5 | 531 | 22 | 210 | 30
1992 | 2 | 1 | 5 | 535 | 22 | 360 | 21
1992 | 2 | 1 | 6 | 527 | 23 | 250 | 26
1992 | 2 | 1 | 6 | 530 | 21 | 210 | 22
Spreadsheet: 224660d1364686454-risk-matrix-conditional-formatting-rr-example
Sheet: Sheet1

Likelihood | Consequence | Risk Rating |  | Likelihood | Consequence | Risk Rating
Almost Certain | Insignificant | High
Almost Certain | Minor | High
Almost Certain | Moderate | Extreme
Almost Certain | Major | Extreme
Almost Certain | Catastrophic | Extreme
Likely | Insignificant | Medium
Likely | Minor | High
Likely | Moderate | High
Likely | Major | Extreme
Likely | Catastrophic | Extreme
Possible | Insignificant | Low
Possible | Minor | Medium
Possible | Moderate | High
Possible | Major | High
Possible | Catastrophic | Extreme
Unlikely | Insignificant | Low
Unlikely | Minor | Low
Unlikely | Moderate | Medium
Unlikely | Major | High
Unlikely | Catastrophic | Extreme
Rare | Insignificant | Low
Rare | Minor | Low
Rare | Moderate | Medium
Rare | Major | High
Rare | Catastrophic | High
Spreadsheet: 139201d1328127358-excel-2007-how-to-multiply-the-maximum-preceding-variable-by-a-specific-percentage-sample-workbook
Sheet: Projections

 | Retirement Plan
 | Age at Commencement |  |  | 65 |  |  |  |  | Assumptions
 | Sex |  |  | Male |  |  |  |  | Allocation Rate (%) |  |  |  | 1
 |  |  |  |  |  |  |  |  | Equity Growth Rate |  |  |  | 0.03 | pa
 | Commission Option |  |  | 3% Initial, 0.25% Trail |  |  |  |  | Bond Growth Rate |  |  |  | 0.03 | pa
 |  |  |  |  |  |  |  |  | Fund Growth Rate
 | Premium |  |  | 100000 |  |  |  |  | CPI |  |  |  | 0.03 | pa
 |  |  |  |  |  |  |  |  | Income Withdrawal Percentage
 | Fund Options |  |  | Advanced (60% Equities, 40% Bonds) |  |  |  |  | Policy Fee |  |  |  | 3 | pm (increasing with CPI)
 |  |  |  |  |  |  |  |  | Guarantee Charge
 |  |  |  |  |  |  |  |  | AMC + Trail Fee
 |  |  |  |  |  |  |  |  | Overall Income Requirement |  |  |  | 0.05
 | Age | Annual Locked In Income | Additional Drawings | Opening Fund Value | Drawings | Growth | AMC + Trail | Guarantee Charge | Closing Fund Value | Surrender Value |  | Year | Cumulative Drawings / Annuity | Surrender Value
Spreadsheet: 269216d1381060335-multiple-ifs-query-excel
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | v look up table
 |  |  | [NAME] | Term 2 | Term 3 | Term 4 |  | Progress |  |  |  |  | 40-60a | 3
 |  |  | 30-50a | 40-60a | 22-36a | 40-60a |  |  |  |  |  |  | 30-50a | 2
 |  |  | 22-36a | 30-50a | 30-50a | 40-60a |  |  |  |  |  |  | 22-36a | 1
 |  |  | 30-50a | 22-36a | 40-60a | 40-60a
 |  |  | In I6 I want to look at the progress from the beginning to the end.
 |  |  | It is always calculated from Term 4 - so it would be term 4 take take 1, however if term 1 is blank, take it from [NAME], however if term 2 is blank take it from term 3, however if term 3 is blank return ""
 |  |  | The v look up table converts the numerical ranges to a number format.
Spreadsheet: 703582d1605068839-subtraction-calculation-w-requirement-data-is-present-sampj
Sheet: example

TYPE: | # OF ITEMS A: | # OF ITEMS B: | SUM1: | SUM2: | CALC1 | CALC2
Down | 0 | 1 | 763979 | 90121 | 673858
Down | 3 | 0 | 145566 | 145566 | -
Up | 3 | 0 | 0 | N | -
Up | 2 | 0 | 0 | 70384 | -
Down | 0 | 1 | 107506615 | N | -
Up | 1 | 0 | 0 | 29228 | -
Down | 0 | 0 | 0 | N | -
Down | 2 | 1 | 75667411 | 4133973 | 71533438
Down | 0 | 0 | 0 | N | -
Up | 1 | 0 | 0 | N | -
Up | 1 | 0 | 0 | 8255 | -
Down | 1 | 1 | 20 | 10 | 10
Spreadsheet: 206329d1358161850-comparing-two-work-sheets-test
Sheet: Dayrate

No | Reg Number | Fleet number | Basket | VOR Y/N | Replacment Asset No | [NAME] | Asset Allocation | Comments
1 |  | 201 | B | N |  | N | Standby
 |  | 202 | A | N |  | N | Standby
 |  | 203 | A | N |  | Y | [NAME] | T
 | 3965/YD | 204 | A | N |  | N | Standby
 |  | 205 | A | N |  | Y | [NAME]
 |  | 206 | A | N |  | Y | [NAME] | T
 |  | 207 | B | N |  | Y | [NAME]
 |  | 208 | B | N |  | Y | [NAME] | T
 |  | 209 | B | N |  | Y | [NAME]
 |  | 210 | A | N |  | N | Standby
 |  | 211 | A | N |  | Y | [NAME] | T
 |  | 212 | A | N |  | Y | Ex-Rig 4 Move
1 | 3565/DK | 213 | A | N |  | Y | [NAME] | T
 | 2645/DK | 214 | A | N |  | Y | [NAME] | T
 |  | 215 | A | N |  | Y | [NAME]
 |  | 216 | A | N |  | Y | [NAME] | T
 |  | 217 | A | N |  | Y | [NAME] | T
 |  | 218 | A | N |  | Y | [NAME] | T
 |  | 219 | A | N |  | Y | [NAME]
 |  | 220 | A | N |  | Y | [NAME] | T
 |  | 221 | A | N |  | Y | [NAME] | T
 |  | 222 | A | N |  | Y | [NAME] | T
 |  | 223 | A | N |  | Y | [NAME] | T
 |  | 224 | A | N |  | Y | [NAME]
 |  | 225 | A | N |  | Y | [NAME] | T
 |  | 226 | A | N |  | Y | [NAME]
 |  | 227 | A | N |  | Y | [NAME] | T
 |  | 228 | A | N |  | Y | [NAME]
 |  | 229 | A | N |  | Y | [NAME]
 |  | 230 | A | N |  | Y | [NAME] | T
 |  | 231 | A | N |  | Y | [NAME] | T
 |  | 232 | A | N |  | Y | [NAME] | T
 |  | 233 | B | N |  | Y | [NAME] | T
 |  | 234 | B | N |  | Y | [NAME] | T
 |  | 235 | B | N |  | Y | [NAME]
 |  | 236 | B | N |  | Y | [NAME]
25 |  | 237 | B | N |  | Y | [NAME]
26 |  | 238 | B | N |  | Y | Cargo - Rig-01
27 |  | 239 | B | N |  | Y | Cargo-Rig-56
28 |  | 240 | B | N |  | Y | Cargo-Rig-67
29 |  | 241 | B | N |  | Y | Standby
30 |  | 242 | B | N |  | Y | Cargo-Rig-59
31 |  | 243 | B | N |  | Y | Cargo-Rig-207
Spreadsheet: 807269d1669825314-revenue-recognition-formula-excel-help-301122
Sheet: EXCEL HELP

 |  |  |  |  |  |  |  |  |  | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00
 |  |  |  |  |  |  |  |  | No. of Days being billed | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00
 |  | Invoice
 | Customer | number | Invoice date | Description | Reference | Amount | Billing period From Date | Billing period End Date |  | 2022-08-31 00:00:00 |  | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 |  |  |  |  |  |  |  | Total Revenue | Checker
 |  |  | 2022-10-17 00:00:00 |  |  | 120 | 2022-08-01 00:00:00 | 2022-09-30 00:00:00
 |  |  | 2022-10-17 00:00:00 |  |  | 3560.7 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 |  |  | 2022-10-17 00:00:00 |  |  | 286.5 | 2022-11-01 00:00:00 | 2023-10-31 00:00:00
 |  |  | 2022-10-17 00:00:00 |  |  | 832.5 | 2022-09-01 00:00:00 | 2022-09-30 00:00:00
 |  |  | 2022-11-01 00:00:00 |  |  | 1200 | 2022-12-18 00:00:00 | 2023-12-17 00:00:00
 |  |  | 2022-11-01 00:00:00 |  |  | 1000 | 2022-10-01 00:00:00 | 2022-10-31 00:00:00
 |  |  | 2022-12-01 00:00:00 |  |  | 1200 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  |  | 0 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  | 2022-12-01 00:00:00 |  |  | 1200 | 2021-10-01 00:00:00 | 2022-11-30 00:00:00
 |  |  |  |  |  |  |  | Total revenue recognised
 |  |  |  |  |  |  |  |  |  | Looking for a formula that can be used the grey box
 |  |  |  |  |  |  |  |  |  | Depending on the invoice date of the month does the recognition begin and the recogniiton will bas based on columns H & I
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R57

Ime artikla
Spreadsheet: 172639d1344279190-counting-the-number-of-times-a-specific-name-occurs-between-a-specified-period-of-time-example
Sheet: Sheet1

Online | Date Contacted | Total Occurrence |  |  | Start | 2012-02-05 00:00:00
ADPT | 2012-03-12 00:00:00 |  |  |  | End | 2012-06-05 00:00:00
BBB | 2012-01-08 00:00:00
ADPT | 2012-01-01 00:00:00
BBB | 2012-03-12 00:00:00
ADPT | 2012-01-08 00:00:00
BBB | 2012-01-01 00:00:00
ADPT | 2012-03-12 00:00:00
BBB | 2012-01-08 00:00:00
ADPT | 2012-01-01 00:00:00
BBB | 2012-03-12 00:00:00
ADPT | 2012-01-08 00:00:00
BBB | 2012-01-01 00:00:00
Spreadsheet: 799597d1665154080-insert-graphs-that-automatically-update-based-on-variables-chart2-eba
Sheet: 1a

Index | Level | [NAME] | Min
Spreadsheet: 54142d1254161941-excel-2007-irr-function-case09_alslezak_2
Sheet: Income Statement

NewLeaf Paper
Projected Five Year Income Statement
Percent Cost of Goods Sold | 0.8 |  |  | TaxRate | 0.38
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Revenues | 3499999.999999994 | 3864131.248468539 | 4266145.801540301 | 4709984.943501363 | 5199999.999999992
Cost of Sales
Gross Profit
Accounting | -12600 | -13300 | -14100 | -14800 | -15500
Advertising & Promotion | -37800 | -68400 | -75600 | -81000 | -86400
Insurance | -3600 | -5800 | -6200 | -6500 | -7200
Maintenance | -8640 | -13700 | -15100 | -16600 | -18000
Utilities | -13680 | -18700 | -20200 | -21600 | -23800
Miscellaneous | -4300 | -8000 | -9000 | -10000 | -12000
Total General Expenses
Earnings before Interest, Depr. & Tax
Depreciation Expense
Operating Profit
Interest Expense
Earnings Before Taxes
Estimated Tax
Net Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AD9rr98w3806ttt807
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wh!ohavwg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Al Slezak
Spreadsheet: 800666d1665782225-find-last-value-based-on-a-criteria-of-another-cell-sampledatanew_edited-good-
Sheet: Blad 1

Day (YYYY-MM-DD) | Value |  | Month (YYYY-MM) | Day | Last Day in Month | Last Value In Month | My desired output
2022-01-01 00:00:00 | 42 |  |  |  |  |  | 78
2022-01-02 00:00:00 | 35 |  |  |  |  |  | 76
2022-01-03 00:00:00 | 65 |  |  |  |  |  | 92
2022-01-04 00:00:00 | 21 |  |  |  |  |  | 28
2022-01-05 00:00:00 | 78 |  |  |  |  |  | 43
2022-02-04 00:00:00 | 97
2022-02-08 00:00:00 | 43
2022-02-16 00:00:00 | 76
2022-03-15 00:00:00 | 92
2022-03-20 00:00:00 | 63
2022-03-22 00:00:00 | 92
2022-04-13 00:00:00 | 87
2022-04-15 00:00:00 | 59
2022-04-21 00:00:00 | 28
2022-05-10 00:00:00 | 37
2022-05-28 00:00:00 | 74
2022-05-29 00:00:00 | 43
Spreadsheet: 491832d1480651885-tidy-exported-file-for-use-in-formulas-and-workings-sample
Sheet: What I Have

PayGlobal
Sample
Projected LSL Report x Department
 |  |  |  |  |  |  | Project leave to: 30/11/2016
 |  |  |  | Recognition | Service | Current | Contract
 | Descriptions |  |  | date | (years) | hrly rate | hrs/wk
Name, Name |  |  |  | 12/11/2015 | 1.05 | 21.492 | 10
Name, Name |  |  |  | 18/12/2006 | 9.95 | 21.8707 | 20.5
Name, Name |  |  |  | 29/07/1996 | 20.34 | 21.8707 | 19.5
 |  |  | Department : 81, [NAME]
Department : 82, Hat  Centre
Name, Name |  |  |  | 20/10/1993 | 23.11 | 32.4026 | 36
Name, Name |  |  |  | 21/02/2005 | 11.77 | 21.8707 | 18
Name, Name |  |  |  | 04/07/2003 | 13.41 | 21.8707 | 28
Name, Name |  |  |  | 09/08/1993 | 23.31 | 29.4921 | 26.5
Name, Name |  |  |  | 15/05/2005 | 11.55 | 21.8707 | 22.5
Name, Name |  |  |  | 24/10/2005 | 11.10 | 21.8707 | 22.5
Name, Name |  |  |  | 22/12/2003 | 12.94 | 21.8707 | 35
Name, Name |  |  |  | 04/09/2000 | 16.24 | 21.8707 | 12.5
Name, Name |  |  |  | 26/10/2009 | 7.10 | 21.8707 | 35
Name, Name |  |  |  | 24/11/2008 | 8.02 | 21.8707 | 23
Name, Name |  |  |  | 21/05/2007 | 9.53 | 21.8707 | 27.75
Name, Name |  |  |  | 24/07/2006 | 10.35 | 21.8707 | 13
Name, Name |  |  |  | 13/11/2000 | 16.05 | 21.8707 | 28
Name, Name |  |  |  | 04/07/2005 | 11.41 | 24.3786 | 36
 |  | Department : 82, [NAME]
Department : 83, Hostel Administration
PayGlobal
Sample
Projected LSL Report x Department
 |  |  |  |  |  |  | Project leave to: 30/11/2016
 |  |  |  | Recognition | Service | Current | Contract
 | Descriptions |  |  | date | (years) | hrly rate | hrs/wk
Name, Name |  |  |  | 12/11/2015 | 1.05 | 21.492 | 10
Name, Name |  |  |  | 18/12/2006 | 9.95 | 21.8707 | 20.5
Name, Name |  |  |  | 29/07/1996 | 20.34 | 21.8707 | 19.5
Department : 82, Town Centre
Department : 82, Town Centre
Name, Name |  |  |  | 20/10/1993 | 23.11 | 32.4026 | 36
Name, Name |  |  |  | 21/02/2005 | 11.77 | 21.8707 | 18
Name, Name |  |  |  | 04/07/2003 | 13.41 | 21.8707 | 28
Name, Name |  |  |  | 09/08/1993 | 23.31 | 29.4921 | 26.5
Name, Name |  |  |  | 15/05/2005 | 11.55 | 21.8707 | 22.5
Name, Name |  |  |  | 24/10/2005 | 11.10 | 21.8707 | 22.5
Name, Name |  |  |  | 22/12/2003 | 12.94 | 21.8707 | 35
Name, Name |  |  |  | 04/09/2000 | 16.24 | 21.8707 | 12.5
Name, Name |  |  |  | 26/10/2009 | 7.10 | 21.8707 | 35
Name, Name |  |  |  | 24/11/2008 | 8.02 | 21.8707 | 23
Name, Name |  |  |  | 21/05/2007 | 9.53 | 21.8707 | 27.75
Name, Name |  |  |  | 24/07/2006 | 10.35 | 21.8707 | 13
Name, Name |  |  |  | 13/11/2000 | 16.05 | 21.8707 | 28
Name, Name |  |  |  | 04/07/2005 | 11.41 | 24.3786 | 36
Department : 83, Hostel Administration
Spreadsheet: michelle_lokay__26678__TW_FT_Top_Twenty
Sheet: TW_FT_Top_Twenty

Legal Entity Name - Le | FT_Contracted
SOUTHERN CALIFORNIA GAS COMPANY | 506000
U S GAS TRANSPORTATION, INC. | 400000
PACIFIC GAS AND ELECTRIC COMPANY | 300000
NORTHWEST PIPELINE CORPORATION | 236750
BP ENERGY COMPANY | 163200
BURLINGTON RESOURCES TRADING, INC. | 148000
PAN-ALBERTA GAS (U.S.), INC. | 144000
DUKE ENERGY TRADING AND MARKETING,L.L.C. | 130000
RED CEDAR GATHERING COMPANY | 125000
AGAVE ENERGY CO. | 120000
SEMPRA ENERGY TRADING CORP. | 100500
WILLIAMS ENERGY MARKETING & TRADING CO. | 100000
EL PASO ENERGY MARKETING COMPANY | 90000
PG&E ENERGY TRADING-GAS CORPORATION | 61000
TEXACO NATURAL GAS, INC. | 53500
CONOCO, INC. | 50000
ASTRA POWER LLC | 50000
CITIZENS COMMUNICATIONS COMPANY | 50000
ENRON NORTH AMERICA CORP. | 41000
RELIANT ENERGY SERVICES, INC. | 40000
RICHARDSON PRODUCTS COMPANY | 35714
ENERVEST SAN JUAN OPERATING, L.L.C. | 32000
PHILLIPS PETROLEUM COMPANY | 30000
EL PASO MERCHANT ENERGY, L.P. | 28600
SOUTHERN ENERGY, INC. | 25000
ARIZONA PUBLIC SERVICE COMPANY | 22000
PNM GAS SERVICES | 20000
TXU ENERGY TRADING COMPANY | 20000
DUKE ENERGY FIELD SERVICES, LP | 20000
ONEOK ENERGY MARKETING AND TRADING COMPA | 20000
ONEOK BUSHTON PROCESSING, INC | 13000
SOUTHERN UTE INDIAN TRIBE | 12500
SACRAMENTO MUNICIPAL UTILITY DISTRICT | 10000
NORTH STAR STEEL COMPANY | 4800
EASTERN NEW MEXICO GAS ASSOCIATION | 4000
CITY OF LEFORS | 3000
PLAINS GAS FARMERS CO-OP | 3000
SOUTHWEST GAS CORPORATION | 3000
ONEOK WESTEX TRANSMISSION, INC | 3000
BASS ENTERPRISES PRODUCTION COMPANY | 2500
WTG GAS MARKETING, INC. | 2050
NAVAJO TRIBAL UTILITY AUTHORITY | 1346
NEW MEXICO NATURAL GAS INC | 1290
MERCADO GAS SERVICES INC | 500
ROGERS, J T | 200
BIGGS, JERRY | 200
BIGGS, RAYMOND | 200
DAUGHERTY, LEON | 200
JENKINS, PHILIP | 200
O'NEAL & SHADID | 200
OSBORNE, THAD M | 200
SCHULTE, EDNA L | 200
CLARK RANCH TRUST | 200
FISCHBACHER, PETE | 200
STEWART, HAROLD R | 200
NOEL, MELVIN EUGENE | 200
HARRISON, [NAME] | 200
[NAME], MARY VIOLA | 200
Spreadsheet: 163011d1340144673-count-cells-in-a-column-with-certain-criteria-hhh-niko79542-oeldere-
Sheet: Sheet1

 | 2 | 2
 | B | C
 | 1 | 4
 | 2 | 4
 | 3 | 4
 | 4 | 4
 | 0 | 0
 | 0 | 4
 | 5 | 4
 | 5 | 4
 | 0 | 4
 | 0
 | 3
0
 | 2
Spreadsheet: 167550d1342023291-finding-average-before-all-information-gathered-finding-average
Sheet: Sheet1

 |  |  | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4
Q 1 | 79 |  | 20 | 20 | 15 | 24
Q 2 | 89 |  | 21 | 25 | 18 | 25
Q 3 | 0
Q 4 | 0
AVERAGE | 42
Spreadsheet: daren_farmer__5489__2000 Winter Plan
Sheet: Summary

 |  | NOVEMBER
 |  | 1995 | 1996 | 1997 | 1998 | 1999 |  | 5-YR AVG | 2000
 |  |  |  |  |  |  |  |  | Estimate
HDD |  |  |  |  |  |  |  |  | 172 | 130.5 |  | Est = 1390
CDD
Average [NAME]. Temp |  |  |  |  |  |  |  |  | 72 |  |  | Norm = 1358
Average Min. Temp |  |  |  |  |  |  |  |  | 49 |  |  |  | HDD above normal
Average Temp |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  | Booked
Residential
H/W/C
Total Residential
Industrial
TOTAL ENTEX
TOTAL MIDCON |  |  |  |  |  | 15.3
 |  | DECEMBER
 |  | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 5-YR AVG | 2000
 |  |  |  |  |  |  |  |  | Estimate
HDD |  |  |  |  |  |  |  |  | 386 | 361.5
CDD
Average [NAME]. Temp |  |  |  |  |  |  |  |  | 64.5
Average Min. Temp |  |  |  |  |  |  |  |  | 42.1
Average Temp |  |  |  |  |  |  |  |  | 53.3
 |  |  |  |  |  |  |  |  | Booked
Residential
H/W/C
Total Residential
Industrial
TOTAL ENTEX
TOTAL MIDCON |  |  |  |  |  | 25.86
 |  | JANUARY
 |  | 1996 | 1997 | 1998 | 1999 | 2000 |  | 5-YR AVG* | 2001
 |  |  |  |  |  |  |  |  | Estimate
HDD |  |  |  |  |  |  |  |  | 446 | 441.7
CDD |  |  |  |  |  |  |  | 498.3
Average [NAME]. Temp |  |  |  |  |  |  |  |  | 61.5
Average Min. Temp |  |  |  |  |  |  |  |  | 40
Average Temp |  |  |  |  |  |  |  |  | 50.75
 |  |  |  |  |  |  |  |  | Booked
Residential
H/W/C
Total Residential
Industrial
TOTAL ENTEX
TOTAL MIDCON |  |  |  |  | n/a
 |  | FEBRUARY
 |  | 1996 | 1997 | 1998 | 1999 | 2000 |  | 5-YR AVG* | 2001
 |  |  |  |  |  |  |  |  | Estimate
HDD |  |  |  |  |  |  |  |  | 267 | 299
CDD
Average [NAME]. Temp |  |  |  |  |  |  |  |  | 65.32
Average Min. Temp |  |  |  |  |  |  |  |  | 43.32
Average Temp |  |  |  |  |  |  |  |  | 54.3
 |  |  |  |  |  |  |  |  | Booked
Residential
H/W/C
Total Residential
Industrial
TOTAL ENTEX
TOTAL MIDCON |  |  |  |  | n/a | 42.3
 |  | [NAME]
 |  | 1996 | 1997 | 1998 | 1999 | 2000 | 2000 | 5-YR AVG* | 2001
 |  |  |  |  |  |  |  |  | Estimate
HDD |  |  |  |  |  |  |  |  | 119 | 125.5
CDD
Average [NAME]. Temp |  |  |  |  |  |  |  |  | 71.48
Average Min. Temp |  |  |  |  |  |  |  |  | 50.4
Average Temp |  |  |  |  |  |  |  |  | 60.95
 |  |  |  |  |  |  |  |  | Booked
Residential
H/W/C
Total Residential
Industrial
TOTAL ENTEX
TOTAL MIDCON |  |  |  |  | n/a | 73.3
Spreadsheet: 038dfd5a-0b4f-4835-83c2-e0ab0fdac706
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. GOVT, PHIL, CRIJ) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. CCSS, CUL, SEC) | PSY
Discipline codes:  Security Studies = 4509                  (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
NO Local Code for Security Studies                          Leave Blank
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 31c4818b-209a-42ff-8608-9e7e41948f70
Sheet: Sheet1

Date:                   Team: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Date:                   Team:.1 | Unnamed: 5 | Unnamed: 6
At Bat # | # | Player Name |  | At Bat # | # | Player Name
1 |  |  |  | 1
2 |  |  |  | 2
3 |  |  |  | 3
4 |  |  |  | 4
5 |  |  |  | 5
6 |  |  |  | 6
7 |  |  |  | 7
8 |  |  |  | 8
9 |  |  |  | 9
10 |  |  |  | 10
11 |  |  |  | 11
12 |  |  |  | 12
13 |  |  |  | 13
14 |  |  |  | 14
15 |  |  |  | 15
16 |  |  |  | 16
17 |  |  |  | 17
18 |  |  |  | 18
19 |  |  |  | 19
20 |  |  |  | 20
Date:                   Team: |  |  |  | Date:                   Team:
At Bat # | # | Player Name |  | At Bat # | # | Player Name
1 |  |  |  | 1
2 |  |  |  | 2
3 |  |  |  | 3
4 |  |  |  | 4
5 |  |  |  | 5
6 |  |  |  | 6
7 |  |  |  | 7
8 |  |  |  | 8
9 |  |  |  | 9
10 |  |  |  | 10
11 |  |  |  | 11
12 |  |  |  | 12
13 |  |  |  | 13
14 |  |  |  | 14
15 |  |  |  | 15
16 |  |  |  | 16
17 |  |  |  | 17
18 |  |  |  | 18
19 |  |  |  | 19
20 |  |  |  | 20