tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19098__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-13 00:00:00 |  | 155.23 | 23600 | 76.12 | 10400
 | 2001-04-12 00:00:00 |  | 173.67 | 28080 | 86.85 | 9600 | 154.54 | 3865 | 74.1 | 415
 | 2001-04-11 00:00:00 |  | 179.1 | 25424 | 91.37 | 9280 | 176.83 | 2341 | 68.53 | 739
 | 2001-04-10 00:00:00 |  | 175.51 | 21664 | 89.05 | 7360 | 152.75 | 5195 | 106.04 | 1927
 | 2001-04-09 00:00:00 |  | 140.37 | 29824 | 99.04 | 10024 | 160.69 | 4429 | 82.6 | 1221
 | 2001-04-08 00:00:00 |  | 135 | 0 | 99 | 0 | 94.68 | 4331 | 89.95 | 950 |  | 98.94 | 30072
 | 2001-04-07 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 124.58 | 4097 | 104.49 | 973
 | 2001-04-06 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 144.64 | 4383 | 107.57 | 1185
 | 2001-04-05 00:00:00 |  | 210.51 | 39072 | 95.69 | 12336 | 113.42 | 2159 | 94.37 | 1318
 | 2001-04-04 00:00:00 |  | 235.75 | 35568 | 96.01 | 11864 | 134.48 | 2153 | 65.34 | 1391
 | 2001-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424 | 124.35 | 2275 | 80.72 | 166
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
Spreadsheet: 869766d1716347228-formula-to-de-concatenate-data-string-example-file
Sheet: Sheet1

Imported Concatenation String | Concat1 | Concat2 | Concat3 | Concat4 | Concat (5-50)
17165624|17111996|17029062|17004593|17004085|17004102|15981590|15885416|15981590|15885416|17165624|17111996|17029062|17004593|17004085|17004102 |  |  | ?
16386362|16253089|16253089 |  |  | ?
16184942|16184942 |  | ?
Outstanding | ?
16482813 | ?
17129531|17028782|16755556|16176427|15816828|16581167|16368754|16176427|15816828|17129531|17028782|16755556 |  |  | ?
Outstanding | ?
17239059|17239059 |  | ?
Spreadsheet: 114375d1310119695-updating-indirect-with-closed-workbook-briansummary
Sheet: Summary

Summary
march
US Dollar cash balance:
Ending balance
Jan
Feb
March
April
May
June
July
THIS IS THE WORKBOOK THAT NEEDS TO WORK. Cells B4:[NAME] and b6:x6 are linked to BrianFormulas.xlsx but they only update when brianformulas.xlsx is open. I need them to open when brianformulas is closed
Spreadsheet: d1dc4f14-b309-4b3b-bd01-08746a418323
Sheet: Vendor 3

C R I T E R I A | Total Possible Score |  |  |  |  |  |  |  |  |  |  | Average
Qualification Requirements
Understanding the Problem |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Personnel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Soundness of Approach |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Terms and Conditions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Available Facilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value Added Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Evaluation of Costs
Cost Rating
Total Qualification & Cost Requirements
Oral Presentation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Score
Spreadsheet: ebfb8e99-cb2c-4e55-9090-857c0622260e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-08-18 14:20:48.830000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 101.856 | 101.731 | 101.606 | 101.231 |  | and are added to price quote
4.25 | 100.967 | 100.842 | 100.717 | 100.342
4.125 | 100.271 | 100.146 | 100.021 | 99.646 |  | Note: | Refer To Price [NAME]
4 | 99.833 | 99.708 | 99.583 | 99.208 |  |  | For all Price Adjs
3.875 | 99.25 | 99.125 | 99
3.75 | 98.211 | 98.086 | 97.961
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.463 | 101.338 | 101.213 | 100.838
3.625 | 101.153 | 101.028 | 100.903 | 100.528
3.5 | 100.849 | 100.724 | 100.599 | 100.224
3.375 | 100.444 | 100.319 | 100.194 | 99.819
3.25 | 99.915 | 99.79 | 99.665
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-09-01 14:20:48.830000
30 DAY | 2011-09-16 14:20:48.830000
45 DAY | 2011-10-01 14:20:48.830000
60 DAY | 2011-10-16 14:20:48.830000
90 DAY | 2011-11-15 14:20:48.830000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 868603d1715282589-why-are-my-bottom-two-contras-not-matching-2-can-someone-help-new-check
Sheet: Sheet1

Invoice Separated | Customer Name | Sum of Revenue | ABS | Countif | Concat | Countif | Expected
1390951 | Sahara | -2985
1390951 | Sahara | 2985
1393230 | Sahara | -2985
1393230 | Sahara | 2985
1394846 | Virgin | 2985
12569 | Plastic | -2985 |  |  |  |  | shoul be 2
12569 | Plastic | 2985 |  |  |  |  | shoul be 2
1397943 | Plastic | -2985 |  |  |  |  | should be 2
1390957 | ALi | 2077.69
1390957 | ALi | -2077.69
1390961 | Univar Speciality Consumables Limited | 1696.6
1390962 | [NAME] | 565.64
1390963 | Tele | 678.19
1390963 | Tele | 3049.36
1390964 | Remington | 884.34
123456 | Plastic Reinforcement Fabrics Limited | 2985
123456 | Plastic Reinforcement Fabrics Limited | -2985
1397943 | Plastic | 2985 |  |  |  |  | should be 2
 |  |  |  | I think this column is casuing issue
Spreadsheet: 792126d1660746121-check-tab-not-checking-out-help
Sheet: WESTERN

 | PAC MTN DESERT |  |  | PACIFIC CENTRAL |  |  | PACIFIC NORTH |  |  | PACIFIC NORTHWEST |  |  | PACIFIC SOUTH |  |  | TOTAL WESTERN |  |  |  | Check
EVENT NAME | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H |  | Q3 | Q4 | 2H
CEILING FANS
SPRING GIFT CENTER
OUTDOOR CLEANING TRAIN
GRILL EVENT
Q2 SPECIAL BUYS
SUMMER PAINT EVENT
HURRICANE TRAIN
POWER TRAIN WAVE 3
TOOL DAYS
BACK TO CAMPUS
BRUSHFIRE AND BLACKOUT TRAIN
Q2 CLEANING TRAIN
POWER TRAIN WAVE 4
Q3 SPECIAL BUYS
SUMMER CLEANING TRAIN
SUMMER STORAGE
GARAGE STORAGE
BATTERY TRAIN
SUMMER BATH
HEATED GEAR AND WORKWEAR
LABOR DAY PAINT
HALLOWEEN
HALLOWEEN HOOKUP
FIRE & SAFETY
POWER TRAIN WAVE 5
FALL CLEANUP
HOLIDAY HOOKUP
DECO HOLIDAY
HOLIDAY SPECIAL BUYS
[NAME]
SMART HOME TRAIN
WINTER STORAGE
Q4 TOOL STORAGE
2023 Q1 EVENTS
TOTAL EVENTS
MAP
OFF-SHELF TOTAL
Spreadsheet: cooper_richey__4325__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 31, 2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | +/-28.6 | +/-28.6 | +/-28.6
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 27.5 | 28.5
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 27.5 | 28.5
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 27.25 | 28.5
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 25.5 | 27.5
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 27.75 | 28.5
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 32 | 32.75
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 32 | 32.75
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 32 | 32.75
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 35 | 36
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 35 | 36
 |  | DEC | 33.61 | 42.64 | 23.12 |  | DEC | 35 | 36
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 839724d1692185941-display-missing-numbers-not-found-within-a-list-excel-forum-16-august
Sheet: Sheet1

List of numbers |  |  | Range (First number) | Range (last number) | Missing number
#40904 |  |  | 40904 | 40920 | #40916
#40905
#40906
#40907
#40908
#40909
#40910
#40911
#40912
#40913
#40914
#40915
#40917
#40918
#40919
#40920
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: Infrastructure

Infrastructure | ok
Mercedes Estrada | Admin, Sr. | 1
[NAME] | Director |  |  | 4
[NAME] | Director | 2 |  | 6
[NAME] | Manager |  |  | 1
[NAME] | Manager |  |  | 2
[NAME] | Manager |  |  | 4
[NAME] | Manager |  |  | 2
[NAME] | Manager |  |  | 4
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager | 9 |  | 2
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec |  |  | 2
[NAME] | Spec
[NAME] | Spec |  |  | 2
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec | 10 |  | 1
[NAME] | Sr. Director |  |  | 9
[NAME] | Sr. Director |  |  | 3
[NAME] | Sr. Director |  |  | 6
[NAME] | Sr. Director | 4 |  | 7
[NAME] | Sr. Spec
Brent Tiner | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
Troy Beyer | Sr. Spec |  |  | 3
[NAME] | Sr. Spec | 24
[NAME] | Staff
[NAME] | Staff
[NAME] | Staff | 3
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant | 7
[NAME] | Vice Pres | 1 |  | 2
 | TOTAL
Spreadsheet: 232309d1367384920-society-scoring-system-template-society-scoring-system-template
Sheet: handicaps

 | Date Confirmed | Club H/Cap |  | Society H/Cap
 | Name | H/cap | Date | H/cap | Revised Date
1 | cooper glynn | 11.1 | 2013-04-20 00:00:00 | 11.5 | 2013-04-27 00:00:00
2 | cooper [NAME] | 15 | 2013-04-20 00:00:00 | 15.5 | 2013-04-27 00:00:00
3 | [NAME] | 25.9 | 2013-04-20 00:00:00 | 26.4 | 2013-04-27 00:00:00
4 | [NAME] | 21 | 2013-04-20 00:00:00 | 16.6 | 2013-04-27 00:00:00
5 | [NAME] | 20.9 | 2013-04-20 00:00:00 | 21.4 | 2013-04-27 00:00:00
6 | [NAME] | 15.2 | 2013-04-20 00:00:00 | 15.7 | 2013-04-27 00:00:00
7 | frost stephen | 15 | 2013-04-20 00:00:00 | 15.5 | 2013-04-27 00:00:00
8 | owen steph | 14 | 2013-04-20 00:00:00 | 14.5 | 2013-04-27 00:00:00
9 | pine kev | 17.7 | 2013-04-20 00:00:00 | 18.2 | 2013-04-27 00:00:00
10 | [NAME] | 26.7 | 2013-04-20 00:00:00 | 27.2 | 2013-04-27 00:00:00
11 | [NAME] | 19.7 | 2013-04-20 00:00:00 | 20.2 | 2013-04-27 00:00:00
12 | turner grant | 24.3 | 2013-04-20 00:00:00 | 24.8 | 2013-04-27 00:00:00
13 | turner russ | 26.3 | 2013-04-20 00:00:00 | 26.8 | 2013-04-27 00:00:00 | 18 | 2005-03-14 00:00:00 | 18
14 | hurst [NAME] | 15.5 | 2013-04-20 00:00:00 | 16 | 2013-04-27 00:00:00
15 | [NAME] | 16.6 | 2013-04-20 00:00:00 | 17.1 | 2013-04-27 00:00:00
16 | horbury [NAME] | 24 | 2013-04-20 00:00:00 | 24 | 2013-04-27 00:00:00
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40 | Society average handicap
 | Golf Club Handicap | Date Confirmed |  | Official Handicap
 | Awarded Handicap | Date Confirmed |  | As Awarded by Society
 | Society Handicap | As per 321 System |  | Actual Playing
 | Renewal Date | As per 321 System |  | After 1 Year Review
 | It is your responsibility to check your handicap and
 | advise the handicap secretary of any changes.
Spreadsheet: 33978d1230944814-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-revised-1
Sheet: Master

Name of Employee | Compensation | HCE | KEY | Benefiting PSP | Benefiting401K | Benifiting Safe Harbor | Date of Birth | Date of Hire | Date of Termination | 1= 1000 | Hours Worked | Date of Entry | Eligible for Plan | MPP Contibution | PSP Contibution | 401 k | 401m | [NAME]
[NAME] | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
[NAME] | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
[NAME] | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
[NAME] | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0
4
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | If a Key = 1 than transfer to spreadsheet [NAME] as a Key employee in colum B
 | If a HCE = 1 than transfer to spreadsheet 410b Ratio Per Tst as a HCE in colum E 16
Spreadsheet: 802596d1666943312-looking-to-create-formula-to-pull-data-based-on-multiple-criteria-and-more-excel-help-2-1-
Sheet: Electric-G

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Properties
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BETA25
Property |  | BETA5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BETA5
 |  | [NAME] |  | Annual Consumption History (in Kwhs) |  |  |  |  |  | 3 Year |  | Supply |  | Delivery |  | 2021
 |  |  |  |  |  |  |  |  |  | Consumption |  | Actual |  | Actual |  | Projected
[NAME] |  | Month |  | 2020 |  |  |  |  |  | Average |  | Cost |  | Cost |  | Consumpion
 |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7720.96319721933 |  | Per
 |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7203.799799709413 |  | Unit
 |  | March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7099.02416772982
 |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6931.028414398574
 |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8406.629122580345
 |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10725.62932542736
 |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11088.77401694005
 |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10168.93751536891
 |  | September |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9594.381903485651
 |  | October |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6395.811174618896
 |  | November |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7144.570527701601
 |  | December |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7760.483520778887
 |  | Total
 |  |  |  | Projected usage:
 |  |  |  | Average year to date cost (per [NAME]):
 |  |  |  | Total year to date cost:
 |  |  |  | Projected consumption for the remainder of the year (in [NAME]): |  |  |  |  |  | 0
 |  |  |  | Projected price for the remainder of the year (average cost):
 |  |  |  | Forecasted cost for the remainder of the year:
 |  |  |  | Projected total electric cost for:
 |  |  |  | Projected annual consumption (estimate):
 |  |  |  | Projected price (per [NAME]):
 |  |  |  | Projected total electric cost for:
 |  |  |  | Notes
Spreadsheet: darron_c_giron__7992__midland_cogen
Sheet: firm9903

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1999-03-01 00:00:00
IFGMR (TRKL/TX) |  |  | 1.56 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 1.56
IFGMR (PEPL/TX/OK) |  |  | 1.58
IFGMR (ANR/LA) |  |  | 1.58
IFGMR (HENRY HUB) |  |  | 1.64
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: daren_farmer__5024__HPLN0323
Sheet: Sheet1

HPLN0323.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - March 23, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-03-23 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | 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: 755611d1636992328-if-formula-to-ignore-result-if-both-index-functions-return-from-the-same-cell-example
Sheet: Sheet1

Respondent |  | How often do you go to the cinema? |  |  |  |  |  |  | Difference between most recent answer and the answer before that
 | Answer in: | January | July | January | July |  |  |  | Previous | Most recent | Difference
A |  | Often | Sometimes | Sometimes
B |  | Sometimes | Sometimes
C |  | Often | Often | No data
D |  | Hardly ever or never | No data | Hardly ever or never | Sometimes
E |  | No data | Hardly ever or never | Sometimes
F |  | Sometimes | Often
Spreadsheet: 213270d1360417293-timesheet-that-calcs-time-in-time-out-lunch-used-reg-hours-ot-hours-double-hours-182-timesheet-2013
Sheet: 021713

Non Exempt Employee Time Sheet
Employee Name |  | Social Security Number |  |  | Weekending:
Day | MM/DD | Time In | Time Out | Less Meal | Reg Hours | O/T Hours | D/T Hrs | Other Hrs | Comments
Monday | 2013-02-04 00:00:00 | 08:00:00 | 22:00:00 | 1 | 8 | 4 | 0.9999999999999982
Tuesday | 2013-02-05 00:00:00 | 08:00:00 | 23:00:00 | 2 | 8 | 4 | 1
Wednesday | 2013-02-06 00:00:00 | 05:30:00 | 18:15:00 | 1 | 8 | 3.75 | 0
Thursday | 2013-02-07 00:00:00 | 09:00:00 | 17:30:00 | 0.5 | 8 | 0 | 0
Friday | 2013-02-08 00:00:00 |  |  |  | 0 | 0 | 0
Saturday | 2013-02-09 00:00:00 |  |  |  | 0 | 0 | 0
Sunday | 2013-02-10 00:00:00 |  |  |  | 0 | 0 | 0
Total Hours |  |  |  |  | 24 | 7.75 | 1.999999999999998 | 0
Monday | 2013-02-11 00:00:00
Tuesday | 2013-02-12 00:00:00
Wednesday | 2013-02-13 00:00:00
Thursday | 2013-02-14 00:00:00
Friday | 2013-02-15 00:00:00
Saturday | 2013-02-16 00:00:00
Sunday | 2013-02-17 00:00:00
Total Hours |  |  |  |  | 0 | 0 | 0 | 0
 |  | Grand Total Hours |  |  | 24 | 7.75 | 1.999999999999998 | 0
Employee Signature and Date |  |  | Supervisor Signature
Spreadsheet: 168855d1342610199-unique-record-sum-sampledata
Sheet: Sheet1

TripID | ReceiptDate | ItemType | DriverID | Jurisdiction | EnvMiles
37553 | 2012-01-02 00:00:00 | Truck Fuel | 88 | 43 | 9054 |  | I want the sum of EnvMiles for unique TripID
37553 | 2012-01-02 00:00:00 | Service Fee | 88 | 43 | 9054
37553 | 2012-01-02 00:00:00 | [NAME] | 88 | 43 | 9054 |  | Example,
37634 | 2012-01-02 00:00:00 | Truck Fuel | 39 | 51 | 11416 |  | In the database
37634 | 2012-01-02 00:00:00 | Service Fee | 39 | 51 | 11416 |  | ItemType | Truck Fuel
37644 | 2012-01-02 00:00:00 | Truck Fuel | 3 | 16 | 3884 |  | DriverID | 88
37644 | 2012-01-02 00:00:00 | [NAME] | 3 | 16 | 3884
37649 | 2012-01-02 00:00:00 | Truck Fuel | 192 | 40 | 848
37650 | 2012-01-02 00:00:00 | Truck Fuel | 208 | 40 | 858 |  | Current [NAME] I'm using
37650 | 2012-01-02 00:00:00 | Discount | 208 | 40 | 858
37650 | 2012-01-02 00:00:00 | Service Fee | 208 | 40 | 358 |  | *But this formula is using 2 identical numbers from the SAME TripID (67656).
37654 | 2012-01-02 00:00:00 | Truck Fuel | 214 | 40 | 2361 |  | I need suum EnvMIles with UNIQUE TripID only!
37654 | 2012-01-02 00:00:00 | Discount | 214 | 40 | 2361
37654 | 2012-01-02 00:00:00 | Cash Advance | 214 | 40 | 2361
37654 | 2012-01-02 00:00:00 | Service Fee | 214 | 40 | 2361
37655 | 2012-01-02 00:00:00 | Truck Fuel | 215 | 40 | 2369
37656 | 2012-01-02 00:00:00 | Truck Fuel | 88 | 43 | 11500
37656 | 2012-01-02 00:00:00 | Service Fee | 88 | 43 | 11500
37656 | 2012-01-02 00:00:00 | [NAME] | 88 | 43 | 11500
67656 | 2012-01-02 00:00:00 | Truck Fuel | 88 | 43 | 11500
67656 | 2012-01-02 00:00:00 | Service Fee | 88 | 43 | 11500
67656 | 2012-01-02 00:00:00 | [NAME] | 88 | 43 | 11500
Spreadsheet: 143130d1330213693-sorting-multiple-columns-with-lookup-values-sorthelper
Sheet: Sheet1

RANKINGS |  |  |  |  | Results | Points | Correct Picks | SortHelp
[NAME] | 4 | 2 |  |  | [NAME] | 3 | 1 | 3174111104
[NAME] | 3 | 1 |  |  | [NAME] | 4 | 2 | 426611198
[NAME] | 3 | 1 |  |  | [NAME] | 3 | 3 | 3383101114
[NAME] | 3 | 3 |  |  | [NAME] | 3 | 1 | 3174101102
 | ^ SORT THESE ^ |  |  |  | ^These are updated and I want the RANKINGS to change
 |  |  |  | 1. Sort by Column B
 |  |  |  | 2. A and C just go along with it