tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 3

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-03 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1052 |  | 923 |  | 67694 |  |  |  |  |  | 21 | 1 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 2 | 21
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 5802 |  | 12802 |  | 67694 |  |  |  |  |  | 22 | 3 | 22 |  |  | 15
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0 |  |  |  |  | 21 | 4 | 20 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 5 | 22 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1175 |  | 4075 |  | 67694 |  |  |  |  |  | 22 | 6 | 21 |  |  | 22
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68915 | 0 |  |  |  |  | 21 | 7 | 21 |  |  | 15
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 | 0 |  |  |  |  | 22 | 8 | 23 |  |  | 14
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0 |  |  |  |  | 21 | 9 | 23 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 15 | 26 |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 7350 |  | 8350 |  | 67694 |  |  |  |  |  | 22 | 35 | 22 |  |  | 17
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 21 | 39 | 20 |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2332 |  | 2332 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1580 |  | 3572 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 11910 |  | 11910 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2614 |  | 2720 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3287 |  | 3173 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 3762 |  | 3476 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 2101 |  | 2101 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 45 |  | 46 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 159461d1338665452-align-text-vlookup-sumif-countifexampletext
Sheet: Sheet1

Text | Count |  | TextData
A | 5 |  | A
B | 3 |  | B
C | 1 |  | C
D | 2 |  | D
E | 2 |  | E
F | 4 |  | F
 |  |  | F
 |  |  | E
 |  |  | D
 |  |  | A
 |  |  | A
 |  |  | A
 |  |  | F
 |  |  | B
 |  |  | B
 |  |  | A
 |  |  | F
Spreadsheet: 102265d1300227372-random-item-number-equals-correct-price-new-job-template-1
Sheet: Purchase Order

[NAME]
 |  |  |  |  |  |  | Date:
Contractor: | LaMorinda Tile and Stone |  |  | Job Name:
Address: | 2261 Commerce Ave., Suite B |  |  | Address:
City: | Concord, CA 94520 |  |  | City:
Phone: | [PHONE] |  |  | Phone:
Fax : | [PHONE] |  |  | Fax:
[NAME]: | [EMAIL] |  |  | [NAME]:
[NAME]
Item | Color/ Type |  |  |  |  | Quantity | 2CM/3CM
 | Please Ship To:
 | LaMorinda Tile and Stone
 | 2261 Commerce Ave., Suite B
 | Concord, CA 94520
Spreadsheet: 525366d1498680852-how-to-use-sumif-on-two-columns-not-sumifs-sample
Sheet: split bills

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Admit,D/C Same Day L1 | 99234 | 2.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Admit,D/C Same Day L2 | 99235 | 3.24
 |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | Admit,D/C Same Day L3 | 99236 | 4.2
Admit | Discharge | MRN | DOS | Code | RVU's |  | Split |  |  | [NAME]
[NAME] | adam | 12345 | 2017-06-28 00:00:00 | 99236 |  |  |  |  |  | adam
[NAME] | [NAME] |  |  | 99235
Spreadsheet: 3a2cb38e-25f1-418f-b5fe-263a8329ded6
Sheet: bugs-2014-05-19

Collection | Bug Number | Edit Number | Error or Warning | Edit Message | Summary
TSDL Interchange | 2802 | N/A | N/A | Can't submit Instructor File Data | Resolved
TSDL Interchange | 3228 | TD023 | Error | unable to deactivate business rules in pipeline, need to deactivate TD023 (Student Credit Earned must not be zero if the student was indicated as passing the class) | Resolved
TSDL Interchange | 3246 | N/A | N/A | Course Instructor File Extract is Missing Fields | Not Working
TSDL Interchange | 3272 | N/A | N/A | The batch maintenance screen is displaying incorrect number of the errors when there are no errors in the file | Not Working
TSDL Interchange | 3330 | N/A | N/A | Course Enrollment File Not Uploading | Resolved
TSDL Interchange | 3331 | TD019 | Error | TD019- checking EDID in staff interchange and not referencing correct district field | Not Working
TSDL Interchange | 3675 | N/A | N/A | Large file upload fails without error message due to size of file | Not Working
TSDL Snapshot | 3712 | N/A | N/A | snapshot is not being created/session timeout | Not Working
TSDL Snapshot | 3711 | N/A | N/A | Status [NAME] showing No Data Exists when data was pulled into snapshot | Not Working
Spreadsheet: 024f0463-c88e-4e6c-906d-6010e1e646e2
Sheet: Rate Summary

Service Center Rate Summary Sheet - Operating Budget
 |  |  | TOTAL
 | Service 1 | Service 2
Prior Year Fund Balance (if applicable)
ANNUAL COSTS
Salaries and [NAME]
Travel
Operating Costs
Equipment < $5,000
Capital equipment depreciation
TOTAL ANNUAL SERVICE COSTS W/ SUBSIDIES
% of Total Costs
Revised Prior Year Balance (Add Deficit, Subtract Surplus)
Estimated 2 months working capital
TOTAL REVISED COSTS
# of Annual Units
Unit Base
CALCULATED RATE PER SERVICE PER UNIT W/ SUBSIDIES
UNIT RATE THAT WILL BE CHARGED TO [NAME] | 0 | 0
Current year rates
SUBSIDIES |  |  | TOTAL
Salaries
Travel
Operating Expense
Equipment <$5,000
Depreciation
TOTAL SUBSIDIES
TOTAL SERVICE COSTS
FULLY COSTED RATES
Spreadsheet: 123309d1317549153-excel-2007-boxcar-averaging-794729
Sheet: Sheet1

 | 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
Spreadsheet: 693845d1599182689-really-need-help-with-sum-going-insane-over-this-ny-m-ngd-r-kning
Sheet: Sheet1

 | B | c |  |  |  |  |  |  |  |  |  | BEBO021999 |  |  |  | COPY NUMBERS TO HERE
 | 500 | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  | >
 | 500 | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  | >
 | 800 | 600
 | 800 | 600
 | 800 | 600
 |  |  |  |  |  |  |  |  |  |  |  | STOP | STOP
Spreadsheet: 856347d1705607255-dynamic-conditional-formatting-on-activity-calendar-cal-workbook-billbalint-
Sheet: Class List

 | CLASS LIST |  |  |  | Class Schedule
 | CLASS | ID | DAY | START TIME | END TIME | UNIQUE
 | Hold Course 1 | Course 1 | MONDAY | 13:00:00 | 14:00:00
 | Hold Course 2 | Course 2 | WEDNESDAY | 13:00:00 | 14:00:00
 | Hold Course 3 | Course 3 | MONDAY | 15:00:00 | 16:00:00
 | Hold Course 4 | Course 4 | TUESDAY | 11:00:00 | 12:00:00
 | Hold Course 5 | Course 5 | THURSDAY | 11:00:00 | 12:00:00
 | Hold Course 6 | Course 6 | MONDAY | 08:10:00 | 09:15:00
 | Hold Course 7 | Course 7 | WEDNESDAY | 08:10:00 | 09:15:00
 | Hold Course 8 | Course 8 | FRIDAY | 20:10:00 | 21:15:00
Spreadsheet: 716273d1612140347-index-match-combination-issues-supplylistef
Sheet: Results

Invoice | Supply Name |  | Actual
 | Pen's | [NAME]. |  | 1
2001 | Pencil's | General Pencil Co. |  | 2
3001 | Crayon's | Crayola |  | 1
4001 | Marker's | Sharpie |  | 1.5
5001 | Paper's | HP |  | 3
6001 | Folders | Staples |  | 0.75
Spreadsheet: 714479d1611242517-display-range-based-on-multiple-cell-values-test-cases-templates-sandbox2
Sheet: Sheet1

Test Scenario:
Retail Tiers:
Mail Tiers:
Smart90:
VBID:
Excl Accredo:
Pricing Band:
Test Case Name/Description | Expected Results | Actual Results/Comments | Tester | Test Date | Status | Test Pharmacy NPI | Test Member ID
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 21

731
Name | Amount
Name 2 | 137
Name 2 | 195
Name 2 | 197
Name 3 | 118
Name 1 | 126
Name 1 | 117
Name 2 | 195
Name 3 | 149
Name 1 | 190
Name 2 | 118
Name 1 | 131
Name 1 | 167
Name 3 | 127
Name 2 | 120
Name 3 | 119
Name 3 | 103
Name 3 | 141
Name 2 | 148
Name 3 | 154
Name 3 | 181
Name 3 | 104
Name 2 | 125
Name 3 | 145
Name 2 | 140
Name 3 | 176
Spreadsheet: 35678d1233260942-autoshape-for-pie-segment-pie
Sheet: Sheet1

 | Topic 1 | Segment 1
 | Topic 1 | Segment 2
 | Topic 1 | Segment 3
 | Topic 1 | Segment 4
 | Topic 2 | Segment 1
 | Topic 2 | Segment 2
 | Topic 2 | Segment 3
 | Topic 2 | Segment 4
 | Topic 3 | Segment 1
 | Topic 3 | Segment 2
 | Topic 3 | Segment 3
 | Topic 3 | Segment 4
 | Topic 4 | Segment 1
 | Topic 4 | Segment 2
 | Topic 4 | Segment 3
 | Topic 4 | Segment 4
 | Topic 4 | Segment 5
 | Topic 4 | Segment 6
 | Topic 4 | Segment 7
 | Topic 4 | Segment 8
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: NC

Raw Material |  | NC
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 0.66
Total
Spreadsheet: 730311d1619636118-convert-daily-data-to-monthly-data-day-to-month
Sheet: Sheet2

Years | Date | Sum of Value
2011 | Mar | 3117.92
 | Apr | 62820.04000000001
 | May | 66681.19
 | Jun | 67194.87999999999
 | Jul | 62598.34999999999
 | Aug | 63006.72000000001
 | Sep | 56993.49000000001
 | Oct | 58422.73000000001
 | Nov | 59891.27
 | Dec | 60359.63
2012 | Jan | 60523.85999999999
 | Feb | 63555.70000000001
 | Mar | 71240.75
 | Apr | 64264.6
 | May | 68204.09
 | Jun | 63801.67
 | Jul | 65423.57
 | Aug | 74252.51999999999
 | Sep | 63452.71
 | Oct | 70030.87999999999
 | Nov | 68910.92000000001
 | Dec | 67710.46
2013 | Jan | 74952.4
 | Feb | 69882.01000000001
 | Mar | 75732.06
 | Apr | 84258.72
 | May | 88689.10999999999
 | Jun | 79585.46999999999
 | Jul | 90853.35000000002
 | Aug | 91642.81000000001
 | Sep | 84699.03
 | Oct | 99589.92999999998
 | Nov | 89500.36
 | Dec | 95253.18999999999
2014 | Jan | 96469.65
 | Feb | 87806.43000000001
 | Mar | 100023.24
 | Apr | 100108.67
 | May | 101389.52
 | Jun | 104965.41
 | Jul | 111187.04
 | Aug | 105655.18
 | Sep | 107155.85
 | Oct | 113654.31
 | Nov | 99664.65999999999
 | Dec | 116386.17
Grand Total |  | 3631562.52
Spreadsheet: b30d4e46-12bd-4609-858d-1e39fa2429fb
Sheet: Income Statement 10-K

UNIVERSAL AMERICAN CORP. AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF OPERATIONS
(UNAUDITED)
DO NOT DELETE - USED FOR LINKING
 |  | Twelve months ended December 31, |  |  |  | Change
 |  | 2011 |  | 2010(1) |  | $ | %
Revenues: |  | (In thousands, per share amounts in dollars)
Net premium and policyholder fees earned | NPPFE | 2219812.90908 |  | 3445748.50787
Net investment income | NII | 47425.15381 |  | 39885.95969
Fee and other income | FAOI | 14636.91425999999 |  | 9574.50195
Realized gain( loss):
Total other-than-temorary impairment losses on securities | TOTTI | 0 |  | -1915
Portion of loss recognized in other comprehensive income | PRICI | 0 |  | 1100
Net other-than-temporary impairment losses on securities recognized in earnings | RIE
Realized (loss) gain, excluding other-than-temporary impairment losses on securities | EXOTTI
Net realized losses on investments | NRG | 841.4575700000022 |  | 6575.264
Total revenues | TR
Benefits, claims and expenses:
Claims and other benefits | COB | 1812814.776790001 |  | 2860640.52577
Change in deferred acquisition costs | CDAC | 3236.562669999998 |  | 5648
Amortization of present value of future profits | APVFP | 4411.335833306901 |  | 7257.73344
Commissions | COMM | 59888.17031000001 |  | 121354.14896
Reinsurance commissions and expense allowances | RCEA | 3328.80612 |  | -17897
Interest expense | IE | 2266.708040000001 |  | 24.97516000000178
Other operating costs and expenses | OOCAE | 355025.6579312715 |  | 405543.2184199999
Total benefits, claims and expenses | TBCE
Income (loss) from continuing operations before income taxes | INC-C-BT
Provision for income taxes | PFIT | 3820.573913834658 |  | 31240.91394911982
Income (loss) from continuing operations | INC-C
Discontinued Operations:
Income from discontinued operations, net of income taxes | DISCOPS | -32605.02455167335 |  | 102329.4364641204
Expenses of transactions, net of income taxes | EOT | -10670.2555635 |  | -2622.154275
Income from discontinued operations | INC-D
Net Income | NI
Earnings per common share:
Basic:
Continuing Operations | EPSC
Discontinued Operations | EPSD
Net Income | EPSBNI
Diluted:
Continuing Operations | DEPSC
Discontinued Operations | DEPSD
Net Income | EPSDNI
Weighted average shares outstanding:
Weighted average common shares outstanding | WACSO | 78776.58190055248 |  | 78748
Less weighted average treasury shares | LWATS | -2094.896331491713 |  | -4871
Basic weighted shares outstanding | BWSO
Weighted average common equivalent of preferred shares outstanding | PSO | 2768.229281767956 |  | 4211
Effect of dilutive securities | EFFDIL | 584.8781683782298 |  | 612
Diluted weighted shares outstanding | DWSO
Cash dividends per common share |  | 0 |  | 2
Effective tax rate | EFFTXRT
(1)  Restated to reflect discontinued operations
Spreadsheet: 124865d1318673220-required-formula-for-text-test-j
Sheet: Sheet1

 | Emp Code | Name | Term | Term Status
 | 1 | AAAAAAAAAA | 1 | Poor
 | 2 | BBBBBBBBBB | 1 | Better
 | 3 | CCCCCCCCCCCC | 1 | Outstanding
 | 4 | [NAME] | 1 | Good |  |  |  |  | Emp Code | 1
 | 1 | AAAAAAAAAA | 2 | Outstanding
 | 2 | BBBBBBBBBB | 2 | Poor
 | 3 | CCCCCCCCCCCC | 2 | Better |  |  |  |  | Term 1 Status | poor | When I Enter the emp code, the staus of term has to come in the concerned box. (For ex: when emp code 1 is given the term 1 status 'poor' should come at the term status 1 box)
 | 4 | [NAME] | 2 | Good |  |  |  |  | Term 2 Status
 | 1 | AAAAAAAAAA | 3 | Poor |  |  |  |  | Term 3 Status
 | 2 | BBBBBBBBBB | 3 | Better |  |  |  |  | Term 4 Status
 | 3 | CCCCCCCCCCCC | 3 | Good
 | 4 | [NAME] | 3 | Outstanding
 | 1 | AAAAAAAAAA | 4 | Outstanding
 | 2 | BBBBBBBBBB | 4 | Poor
 | 3 | CCCCCCCCCCCC | 4 | Good
 | 4 | [NAME] | 4 | Better
Spreadsheet: 871767d1718189256-reducing-the-size-of-a-spreadsheet-stopping-a-formula-from-calculating-upon-criteria-example-workbook
Sheet: Report

Ref | CC
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
Spreadsheet: 857999d1706808239-index-small-repeatation-excel-test
Sheet: Statement

 | Customer Name | Customer 3
 | Month of Claim | March
 |  |  |  | Total:
 | Account Number | Ref No | Month | Discount | Usage in KWH | Total Value | [NAME] | Sub Total.
Spreadsheet: 771887d1646907696-index-match-function-error-sample
Sheet: Raw Data

ID |  | Code |  |  |  |  |  |  |  | B | KK | KK E
1000 |  | FC0001 |  |  |  |  |  |  |  | 20000 | 5000 | 1000
2000 |  | FC0001 |  |  |  |  |  |  |  | 60000 | 10000 | 2000
3000 |  | FC0001 |  |  |  |  |  |  |  | 30000 | 15000 | 3000
4000 |  | FC0001 |  |  |  |  |  |  |  | 40000 | 20000 | 4000
1000 |  | FC0200 |  |  |  |  |  |  |  | 50000 | 25000 | 5000
2000 |  | FC0201 |  |  |  |  |  |  |  | 60000 | 30000 | 6000
3000 |  | FC0202 |  |  |  |  |  |  |  | 70000 | 35000
4000 |  | FC0300 |  |  |  |  |  |  |  | 80000 | 40000
2000 |  | FC3000 |  |  |  |  |  |  |  | 90000 | 45000 | 9000
3000 |  | FC3000 |  |  |  |  |  |  |  | 100000 | 50000 | 10000
4000 |  | FC3000 |  |  |  |  |  |  |  | 110000 | 55000 | 11000
5000 |  | FC3000 |  |  |  |  |  |  |  | 120000 | 60000 | 12000
6000 |  | FC3000 |  |  |  |  |  |  |  | 130000 | 65000
7000 |  | FC3000 |  |  |  |  |  |  |  | 140000 | 70000 | 14000
8000 |  | FC3000 |  |  |  |  |  |  |  | 150000 | 75000 | 15000
2000 |  | FC3053 |  |  |  |  |  |  |  | 160000 | 80000 | 16000
3000 |  | FC3350 |  |  |  |  |  |  |  | 170000 | 85000
4000 |  | FC3407 |  |  |  |  |  |  |  | 180000 | 90000 | 18000
5000 |  | FC3501 |  |  |  |  |  |  |  | 190000 | 95000 | 19000
6000 |  | FC3502 |  |  |  |  |  |  |  | 200000 | 100000 | 20000
Spreadsheet: 683655d1592872735-source-gets-auto-highlights-when-click-from-target-hyperlink
Sheet: Source

 | No. | CUSTOMER
 | 1 | ABC Company
 | 2 | DEF Company
 | 3 | XYZ Company
 | 4 | 123 Company
 | 5 | 456 Company
 | 6 | 789 Company
 | 7 | OPS
 | 8 | FIN
 | 9 | MAR
 | 10
 | 11
 | 12
 | 13
Spreadsheet: 819232d1677328395-calculate-credit-card-account-age-skydivetom-credit-age
Sheet: Sheet1

Account Opened | Year(s) | Month(s)
2017-03-01 00:00:00
2018-04-01 00:00:00
2018-04-30 00:00:00
2019-07-01 00:00:00
2001-06-16 00:00:00
2023-01-01 00:00:00
Today's Date: | Oldest | Newest
 | Year(s) | Month(s)
Oldest:
Newest:
Average Age:
Spreadsheet: 840977d1693238704-extracting-numbers-from-a-cell-count-demo
Sheet: number extract

OFFPLAYERS | O1 | O2 | O3 | O4 | O5 | O6 | O7 | O8 | O9 | O10 | O11 | O1 | O2 | O3 | O4 | O5 | O6 | O7 | O8 | O9 | O10 | O11
TNUN 17 (RF2); TNUN 24 (KR); TNUN 89 (MB); TNUN D03 (KFB); TNUN D25 (LF2); TNUN D29 (RF1); TNUN D31 (LB); TNUN D35 (LF3); TNUN [NAME] (LF1); TNUN D44 (RB); TNUN D57 (RF3) |  |  |  |  |  |  |  |  |  |  |  | 17 | 24 | 89 | 3 | 25 | 29 | 31 | 35 | 36 | 44 | 57
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR) |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 | 10 | 15 | 54 | 58 | 63 | 75 | 76 | 80 | 87
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (FB-L)
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR)
TNUN 02 (HB-L); TNUN 07 (QB); TNUN 10 (TE-R); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR)
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR)
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR)
TNUN 65 (PPL); TNUN 66 (PPRi); TNUN D02 (PRT); TNUN D03 (GR); TNUN D14 (PLT); TNUN D28 (GL); TNUN D31 (PRG); TNUN D38 (PLG); TNUN D99 (PPRo); TNUN S37 (P); TNUN S47 (PLS)
Spreadsheet: 705465d1606142822-amend-index-aggregate-formula-calendar
Sheet: Data

Name | Absence | Short | Start date | End date
Carlotta Hermeling | Sickness | S | 2020-01-06 00:00:00 | 2020-01-10 00:00:00
[NAME] | Holiday | H | 2020-01-20 00:00:00 | 2020-01-24 00:00:00
[NAME] | Work from home | W | 2020-01-06 00:00:00 | 2020-01-17 00:00:00
Carlotta Hermeling | Afternoon holiday | H1 | 2020-01-15 00:00:00 | 2020-01-15 00:00:00
[NAME] | Professional development | D | 2020-01-05 00:00:00 | 2020-01-06 00:00:00
Spreadsheet: benjamin_rogers__1253__merchant peaker plants version2
Sheet: ENA Comps

 |  | [NAME]
 |  |  |  |  |  |  |  |  |  | ENA | CSFB
 |  | Company | Location | Source | Turbine Type | Article Date | Operation Date | MW's | Cost ($ [NAME]) | Cost/kW | Cost/kW
 | 1 | Dynergy | Lake Charles | Co. Press Release | GE 7FA | 1999-07-23 00:00:00 | 2000-06-01 00:00:00 | 155 | 50 |  | 322
 |  | Tenaska | Georgia | Co. Press Release | GE 7FA | 1999-11-11 00:00:00 | 2001-06-01 00:00:00 | 936 | 410 |  | 354.84
 |  | Entergy | Miss. | Co. Press Release | GE 7EA | 2000-02-24 00:00:00 | 2001-06-01 00:00:00 | 300 | 140 |  | 466.67
 | 4 | Southwestern Elec. Coop. | Illinois | Megawatt Daily | GE LM 6000 | 1999-12-06 00:00:00 | 2001-06-01 00:00:00 | 45 | 25 |  | 555.56
 |  | Hoosier Energy/Williams | Indiana | N/A | GE LM 6000 | N/A | N/A | 170 | 94 |  | N/A
 |  | [NAME] | Texas | Co. Press Release | GE LM 6000 | N/A | 2001-06-01 00:00:00 | 178 | 93.2 |  | N/A
 |  | DPL | Ohio | Co. Press Release | GE Gas Turbines | 2000-08-30 00:00:00 | 1999-06-01 00:00:00 | 250 | 75 |  | N/A
 |  | DPL | Ohio | Co. Press Release | Pratt & Whitney | 2000-01-31 00:00:00 | 2000-06-01 00:00:00 | 225 | 80 |  | 444.44
 |  | DPL | Ohio | Co. Press Release | GE Gas Turbines | 2000-01-10 00:00:00 | 2001-12-01 00:00:00 | 160 | 60 |  | 390.63
 |  | Indeck | Illinois | Co. Press Release | N/A | 2000-05-24 00:00:00 | 2001-06-01 00:00:00 | 700 | 250 |  | 357.14
 |  | Indeck | Illinois | Co. Press Release | N/A | 2000-03-01 00:00:00 | N/A | 300 | 100 |  | 333.33
 |  | Standard Power & Light | Illinois | Generation Week | N/A | 2000-03-01 00:00:00 | N/A | 800 | 380 |  | 475
 |  | PPL Global | Pennsylvania | Electric Power Daily | N/A | 2000-05-26 00:00:00 | 2002-06-01 00:00:00 | 900 | 425 |  | N/A
 |  | Average
 |  | Average (w/o GE LM 6000's)
Spreadsheet: 882354d1730731653-trying-to-customize-the-excel-template-attendance-record-employee-attendance-record1
Sheet: Employee Leave Tracker

 | Employee leave tracker
 | Employee name | Start date | End date | Type of leave | Days