tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859122d1707577722-number-of-days-between-similar-record-types-warmcoldrecords-1-
Sheet: Sheet1

 | Desired Table |  |  |  |  |  |  |  | Test Table
 | Date | Type of Record | # of Days Between Similar Records | # of Similar Records in a Row | End Date for Similar Records | # of Similar Records in Streak |  |  | Date | Type of Record | # of Days Between Similar Records | # of Similar Records in a Row | End Date for Similar Records | # of Similar Records in Streak
 | 1900-01-14 00:00:00 | Warmest |  | 1 | 1900-01-20 00:00:00 | 2 |  |  | 1900-01-14 00:00:00 | Warmest
 | 1900-01-20 00:00:00 | Warmest |  | 2 |  |  |  |  | 1900-01-20 00:00:00 | Warmest
 | 1900-01-22 00:00:00 | Coldest |  | 1 | 1900-01-23 00:00:00 | 2 |  |  | 1900-01-22 00:00:00 | Coldest
 | 1900-01-23 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-01-23 00:00:00 | Coldest
 | 1900-01-24 00:00:00 | Warmest |  | 1 | 1900-01-24 00:00:00 | 1 |  |  | 1900-01-24 00:00:00 | Warmest
 | 1900-01-31 00:00:00 | Coldest |  | 1 | 1900-01-31 00:00:00 | 1 |  |  | 1900-01-31 00:00:00 | Coldest
 | 1900-02-15 00:00:00 | Warmest |  | 1 | 1900-02-15 00:00:00 | 1 |  |  | 1900-02-15 00:00:00 | Warmest
 | 1900-02-24 00:00:00 | Coldest |  | 1 | 1900-02-24 00:00:00 | 1 |  |  | 1900-02-24 00:00:00 | Coldest
 | 1900-02-25 00:00:00 | Warmest |  | 1 | 1900-02-25 00:00:00 | 1 |  |  | 1900-02-25 00:00:00 | Warmest
 | 1900-03-15 00:00:00 | Coldest |  | 1 | 1900-03-16 00:00:00 | 3 |  |  | 1900-03-15 00:00:00 | Coldest
 | 1900-03-15 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-03-15 00:00:00 | Coldest
 | 1900-03-16 00:00:00 | Coldest |  | 3 |  |  |  |  | 1900-03-16 00:00:00 | Coldest
 | 1900-03-17 00:00:00 | Warmest |  | 1 | 1900-03-17 00:00:00 | 1 |  |  | 1900-03-17 00:00:00 | Warmest
 | 1900-03-22 00:00:00 | Coldest |  | 1 | 1900-04-07 00:00:00 | 3 |  |  | 1900-03-22 00:00:00 | Coldest
 | 1900-04-06 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-04-06 00:00:00 | Coldest
 | 1900-04-07 00:00:00 | Coldest |  | 3 |  |  |  |  | 1900-04-07 00:00:00 | Coldest
 | 1900-04-08 00:00:00 | Warmest |  | 1 | 1900-05-12 00:00:00 | 5 |  |  | 1900-04-08 00:00:00 | Warmest
 | 1900-04-27 00:00:00 | Warmest |  | 2 |  |  |  |  | 1900-04-27 00:00:00 | Warmest
 | 1900-04-28 00:00:00 | Warmest |  | 3 |  |  |  |  | 1900-04-28 00:00:00 | Warmest
 | 1900-05-03 00:00:00 | Warmest |  | 4 |  |  |  |  | 1900-05-03 00:00:00 | Warmest
 | 1900-05-12 00:00:00 | Warmest |  | 5 |  |  |  |  | 1900-05-12 00:00:00 | Warmest
 | 1900-05-13 00:00:00 | Coldest |  | 1 | 1900-06-26 00:00:00 | 2 |  |  | 1900-05-13 00:00:00 | Coldest
 | 1900-06-26 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-06-26 00:00:00 | Coldest
Spreadsheet: 158717d1338369737-error-in-formula-of-match-and-offset-error-in-formula-of-match-and-offset
Sheet: Sheet1

Formula |  |  |  |  |  |  | correct
answer |  |  | TO KNOW MISTAKE |  |  |  | ANSWER
 |  | M/S 1 |  |  |  |  | M/S 1
 |  | 1 |  |  |  |  | M/S 1
 |  | 2 |  |  |  |  | M/S 1
 |  | 3 |  |  |  |  | M/S 1
 |  | 4 |  |  |  |  | M/S 1
 |  | 5 |  |  |  |  | M/S 1
 |  | 6 |  |  |  |  | M/S 1
 |  | M/S 2 |  |  |  |  | M/S 2
 |  | 1 |  |  |  |  | M/S 2
 |  | 2 |  |  |  |  | M/S 2
 |  | 3 |  |  |  |  | M/S 2
 |  | 4 |  |  |  |  | M/S 2
 |  | 5 |  |  |  |  | M/S 2
 |  | M/S 3 |  |  |  |  | M/S 3
 |  | 1 |  |  |  |  | M/S 3
 |  | 2 |  |  |  |  | M/S 3
 |  | 3 |  |  |  |  | M/S 3
 |  | M/S 4 |  |  |  |  | M/S 4
 |  | 1 |  |  |  |  | M/S 4
 |  | 2 |  |  |  |  | M/S 4
 |  | M/S 5 |  |  |  |  | M/S 5
 |  | 1 |  |  |  |  | M/S 5
 |  | 2 |  |  |  |  | M/S 5
 |  | 3 |  |  |  |  | M/S 5
 |  | 2 |  |  |  |  | M/S 5
 |  | M/S 6 |  |  |  |  | M/S 6
 |  | 1 |  |  |  |  | M/S 6
 |  | 2 |  |  |  |  | M/S 6
 |  | 3 |  |  |  |  | M/S 6
 |  | M/S 7 |  |  |  |  | M/S 7
 |  | 1 |  |  |  |  | M/S 7
 |  | 2 |  |  |  |  | M/S 7
 |  | 3 |  |  |  |  | M/S 7
 |  | M/S 8 |  |  |  |  | M/S 8
 |  | 1 |  |  |  |  | M/S 8
 |  | 2 |  |  |  |  | M/S 8
 |  | 3 |  |  |  |  | M/S 8
 |  | M/S 9 |  |  |  |  | M/S 9
 |  | 1 |  |  |  |  | M/S 9
 |  | 2 |  |  |  |  | M/S 9
 |  | 3 |  |  |  |  | M/S 9
Spreadsheet: chris_stokley__3944__ISO EES Price Graphs
Sheet: ScalersNP01

Scalers NP01
[NAME]
 | price_100 | price_200 | price_300 | price_400 | price_500 | price_600 | price_700 | price_800 | price_900 | price_1000 | price_1100 | price_1200 | price_1300 | price_1400 | price_1500 | [NAME] | price_1700 | price_1800 | price_1900 | price_2000 | price_2100 | price_2200 | price_2300 | price_2400
1
2
3
4
5
6
7
8
9
10
11
12
On [NAME]
 | price_100 | price_200 | price_300 | price_400 | price_500 | price_600 | price_700 | price_800 | price_900 | price_1000 | price_1100 | price_1200 | price_1300 | price_1400 | price_1500 | [NAME] | price_1700 | price_1800 | price_1900 | price_2000 | price_2100 | price_2200 | price_2300 | price_2400
1
2
3
4
5
6
7
8
9
10
11
12
Sunday
 | price_100 | price_200 | price_300 | price_400 | price_500 | price_600 | price_700 | price_800 | price_900 | price_1000 | price_1100 | price_1200 | price_1300 | price_1400 | price_1500 | [NAME] | price_1700 | price_1800 | price_1900 | price_2000 | price_2100 | price_2200 | price_2300 | price_2400
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 119207d1314270537-duplicate-name-generation-here-you-are
Sheet: Sheet1

Name | Duplicate count formula |  | Name without duplicate and blank row
Accession | 3 | Accession | Accession | [NAME] is required in column No.F
APJ print world | 4 | APJ print world | APJ print world | In Column F blank should not be there, [NAME] name should there without any blank
Brainy Bytes | 5 |  | Brainy Bytes
Creative Enterprises | 6 |  | Creative Enterprises
Digital park | 7 |  | Digital park
Brainy Bytes |  | Brainy Bytes
Creative Enterprises |  | Creative Enterprises
Digital park |  | Digital park
Spreadsheet: 53346d1253219486-merging-two-spreadsheets-test
Sheet:  Report

[NAME] of Lading | Total Billed
101 | 172.86
102 | 175.09
103 | 177.32
104 | 179.55
105 | 181.78
106 | 184.01
107 | 186.24
108 | 188.4699999999999
109 | 190.6999999999999
110 | 192.9299999999999
111 | 195.1599999999999
112 | 197.3899999999999
113 | 199.6199999999999
114 | 201.8499999999999
115 | 204.0799999999999
116 | 206.3099999999999
117 | 208.5399999999998
118 | 210.7699999999998
119 | 212.9999999999998
120 | 215.2299999999998
121 | 217.4599999999998
122 | 219.6899999999998
123 | 221.9199999999998
124 | 224.1499999999998
125 | 226.3799999999998
126 | 228.6099999999998
127 | 230.8399999999997
128 | 233.0699999999997
129 | 235.2999999999997
130 | 237.5299999999997
131 | 239.7599999999997
132 | 241.9899999999997
133 | 244.2199999999997
134 | 246.4499999999997
135 | 248.6799999999997
136 | 250.9099999999997
137 | 253.1399999999996
138 | 255.3699999999996
139 | 257.5999999999996
140 | 259.8299999999996
141 | 262.0599999999997
142 | 264.2899999999997
143 | 266.5199999999997
144 | 268.7499999999997
145 | 270.9799999999997
146 | 273.2099999999998
147 | 275.4399999999998
148 | 277.6699999999998
149 | 279.8999999999998
150 | 282.1299999999998
151 | 284.3599999999998
152 | 286.5899999999999
153 | 288.8199999999999
154 | 291.0499999999999
155 | 293.2799999999999
156 | 295.5099999999999
157 | 297.74
158 | 299.97
159 | 302.2
160 | 304.43
161 | 306.66
162 | 308.89
163 | 311.1200000000001
164 | 313.3500000000001
165 | 315.5800000000001
166 | 317.8100000000001
167 | 320.0400000000001
168 | 322.2700000000002
169 | 324.5000000000002
170 | 326.7300000000002
171 | 328.9600000000002
172 | 331.1900000000002
173 | 333.4200000000002
174 | 335.6500000000003
175 | 337.8800000000003
176 | 340.1100000000003
177 | 342.3400000000003
178 | 344.5700000000003
179 | 346.8000000000004
180 | 349.0300000000004
181 | 351.2600000000004
182 | 353.4900000000004
183 | 355.7200000000004
184 | 357.9500000000004
185 | 360.1800000000005
186 | 362.4100000000005
187 | 364.6400000000005
188 | 366.8700000000005
189 | 369.1000000000005
190 | 371.3300000000006
191 | 373.5600000000006
192 | 375.7900000000006
193 | 378.0200000000006
194 | 380.2500000000006
195 | 382.4800000000006
196 | 384.7100000000007
197 | 386.9400000000007
198 | 389.1700000000007
199 | 391.4000000000007
200 | 393.6300000000007
201 | 395.8600000000008
202 | 398.0900000000008
203 | 400.3200000000008
204 | 402.5500000000008
205 | 404.7800000000008
206 | 407.0100000000008
207 | 409.2400000000009
208 | 411.4700000000009
209 | 413.7000000000009
210 | 415.9300000000009
Spreadsheet: 202237d1356432069-find-1st-2nd-and-3rd-place-2012-12-25-pivot-table-oeldere-
Sheet: Blad1

weight | name
-0.0198 | [NAME] |  |  | Rijlabels | Som van weight
-0.0292 | [NAME] |  |  | Biff | -0.0387
-0.0387 | Biff |  |  | [NAME] | -0.0357
-0.0348 | [NAME] |  |  | [NAME] | -0.0356
0 | [NAME] |  |  | [NAME] | -0.0348
-0.001 | [NAME] |  |  | [NAME] | -0.0292
0 | [NAME] |  |  | [NAME] | -0.0198
-0.0356 | [NAME] |  |  | [NAME] | -0.001
-0.0357 | [NAME] |  |  | [NAME] | 0
 |  |  |  | [NAME] | 0
 |  |  |  | Eindtotaal | -0.1948
Spreadsheet: 5fd672bb-43f8-4368-b6e0-3308d0b14fc7
Sheet: Engel Curve

a = |  | b = |  | Px = |  | Py =
increment | 5
Income (I)
0
Spreadsheet: 800522d1665698426-sumifs-2-criterias-on-same-column-sumifs-2-criterias-on-same-column
Sheet: Sheet1

Day(MM-DD-YYYY) : 09-01-2022 | Total calls
8:00-9:00 | 0
9:00-10:00 | 0
10:00-11:00 | 2
11:00-12:00 | 2
12:00-13:00 | 3
13:00-14:00 | 3
14:00-15:00 | 7
15:00-16:00 | 5
16:00-17:00 | 2
Total
Day(MM-DD-YYYY) : 9-02-2022 | Total calls
8:00-9:00
9:00-10:00
10:00-11:00
11:00-12:00
12:00-13:00
13:00-14:00
14:00-15:00
15:00-16:00
16:00-17:00
Total
Spreadsheet: 166673d1341704072-calculation-formula-for-incentive-incentive-calculation-formula
Sheet: Sheet1

% of Target | [NAME] of Sales
85-90.99 | 0.2
91-92.99 | 0.4 |  |  | I need to populate Row 17 with Incentives which is calclued as % of sales multiplied by Row 15
93-94.99 | 0.5
95-96.99 | 0.6 |  |  | For example-  % of Target is 95.63%, incentive will be 60% of Sales ($1667) , answer will be $1000
97-98.99 | 0.8
99-100.99 | 1
101.103.99 | 1.1
104.105.99 | 1.2
Additional % up to | +1%
% of Target | 1.25 | 1.37 | 1.36 | 1.25 | 1.22 | 1.2 | 0.7769 | 0.9563 | 0.9755
Sales | 1666.666666666667 | 1666.666666666667 | 1666.666666666667 | 1666.666666666667 | 1666.666666666667 | 1666.666666666667 | 1666.666666666667 | 1666.666666666667 | 1666.666666666667
Incentive
Spreadsheet: 719516d1613699203-logic-updates-to-existing-formulas-duplicates-exclusion-lookups-samplep
Sheet: SHIP

ID |  |  | type | rec count |  | [NAME] |  | [NAME] |  |  | Counts |  |  |  |  | Counts:
1163603 |  |  | Final | 302404597 |  | Net Down |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value:302,404,597
1163603 |  |  | Final | 302404597 |  | Net Down |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value:302,404,597
1172600 |  |  | A | 0 |  | Post 100% |  | A |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | INT | 35360098 |  | Post 100% |  | C D w/o I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | Final | 50039 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | Final | 50039 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1179778 |  |  | Final | 11431902 |  | Post 100% |  | C D w/ I |  | Final Reject Sample |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> "Rej" is found in Column K for this ID | Expected Value: 11431902
1179778 |  |  | Final | 393559 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> "Rej" is found in Column K for this ID | Expected Value: 11431902
1224113 |  |  | Final | 21429 |  | Post 100% |  | C D w/ I |  | Final
1226191 | BB of B |  | Final | 90076559 |  | Net Down |  | C D w/ I |  | Final
1226191 | BB of B |  | Final |  |  | Net Down |  | Rp |  | Final
1226572 | AAA |  | INT | 33882484 |  | Post 100% |  | C D w/o I |  | Final
1226572 | AAA |  | Final | 249975 |  | Post 100% |  | C D w/ I |  | Final
Spreadsheet: 703676d1605110946-vlookup-with-two-conditions-example
Sheet: Sheet1

Product | Code | Country |  |  |  |  |  |  |  |  | Product | Code | Country
A | 1 |  |  |  |  |  |  |  |  |  | A | 1 | PT
B | 2 |  |  |  |  |  |  |  |  |  | B | 2 | ES
C | 3 |  |  |  |  |  |  |  |  |  | C | 3 | FR
F | 4 |  |  |  |  |  |  |  |  |  | D | 4 | ES
H | 5 |  |  |  |  |  |  |  |  |  | E | 5 | PL
X | 6 |  |  |  |  |  |  |  |  |  | E | 6 | DE
L | 7 |  |  |  |  |  |  |  |  |  | G | 9 | PT
 |  |  |  |  |  |  |  |  |  |  | L | 10 | IT
Spreadsheet: 106488d1303762570-vlookup-with-a-sum-calculation-test-1-
Sheet: Summary by Country

Comparison by Country |  |  |  |  |  | Enter New %
Region |  | 0.07 | 0.05 | 50/50 | Current Total | 0.1 | Diff | Diff %
ARGENTINA |  |  |  |  |  |  |  |  |  | Country | B | C
 | B |  |  | 50 |  |  |  |  |  | ARGENTINA | 100 | 200
 | C |  |  | 75 |  |  |  |  |  | AUSTRALIA
 |  |  |  |  |  |  |  |  |  | AUSTRIA
AUSTRALIA |  |  |  |  |  |  |  |  |  | BAHRAIN
 | B |  |  | 65 |  |  |  |  |  | BANGLADESH
 | C |  |  | 125 |  |  |  |  |  | BELGIUM
 |  |  |  |  |  |  |  |  |  | BRAZIL
AUSTRIA |  |  |  |  |  |  |  |  |  | BULGARIA
 | B | 45 | 65 | 75
 | C | 50 | 70 | 80
 |  | 95 | 135 | 155 | 385
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Abdullah Al Essa 

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation | 0.5
 |  | [NAME] in the Clinics (After deducting OHE 5% + Lab Fee) | 0.45
 |  | Invisalign (After deducting OR Cost+OHE 5% + Lab Fee) | 0.35
 |  | Dental Procedure other than [NAME] (After deducting OR Cost + OHE 5% + Lab Fee) | 0.45
Doctor Calculation
 |  | Gross Revenue
 |  | Doctor Consultation Revenue | 1650
 |  | Amount to be paid
 |  | Ortho / Dental Procedure Revenue | 24150.21999999999
 |  | Labs
 |  | OHE (5%)
 |  | Net Revenue |  |  |  |  |  |  | Dental Procedure Revenue
 |  | Amount to be paid
 |  | Invisalign Revenue | 32000.32 |  |  |  |  |  | Canine palatal exposure(PR0192)
 |  | LAB | 0 |  |  |  |  |  | Crown lengthening soft tissue   tooth ( difficult )(PR0183)
 |  | OHE (5%) |  |  |  |  |  |  | Essex(PR0904)
 |  | Net Revenue |  |  |  |  |  |  | Unspecified code by report(PR0320)
 |  | Amount to be paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -1797
3531 | -491191 | -241688
60667 | -325838
60749 | 750694 | 113164
61206
61334 | -25143
62960
INDEX
2001-07-31 00:00:00 |  |  | 704039.33
2001-08-18 00:00:00
CBS Volume
 |  |  | 80036
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 | 674 |  | 34705 | 34133
2 | 318 |  | 34620 | 34133
3 | 423 |  | 34786 | 34133
4 | 713 |  | 34587 | 34133
5 | 772 |  | 34764 | 33120
6 | 596 |  | 34664 | 33120
7 | 408 |  | 34690 | 34133
8 | 294 |  | 33684 | 33120
9 | 239 |  | 33588 | 33120
10 | 273 |  | 33588 | 33120
11 | 223 |  | 33597 | 33120
12 | 246 |  | 33591 | 33120
13 | 265 |  | 30293 | 33120
14 | 259 |  | 32532 | 33120
15 | 236 |  | 23932 | 33120
16 | 271 |  | 33597 | 32657
17 | 274 |  | 33619 | 33120
18 | 307 |  | 33637 | 33120
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183022 | -164488
2002-02-28 00:00:00 | Balance | -1033420.01 |  | -647086.22
2002-03-18 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1200266.6 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -169549
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 42510d1241055332-employee-schedule-help-schedual09b
Sheet: Friday

 | Area |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 10:00:00 |  | Total Hours
 | Service Desk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
62 | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
74 | Hayley | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9 | [NAME] | 3 | x | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  | 7
26 | [NAME] | 4 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x |  |  | 8
43 | Ramsay | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | #N/A | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 125095d1318876457-excel-2007-date-and-location-data-counting-test-sheet
Sheet: Data

Date |  | Location |  |  |  | Date |  | AE |  | RL |  | Total
2011-09-08 00:00:00 |  | AE |  |  |  | 2011-09-08 00:00:00
2011-09-08 00:00:00 |  | RL |  |  |  | 2011-09-09 00:00:00
2011-09-09 00:00:00 |  | AE |  |  |  | 2011-09-12 00:00:00
2011-09-09 00:00:00 |  | AE |  |  |  | 2011-09-13 00:00:00
2011-09-09 00:00:00 |  | AE
2011-09-12 00:00:00 |  | AE
2011-09-12 00:00:00 |  | AE
2011-09-12 00:00:00 |  | AE
2011-09-12 00:00:00 |  | AE
2011-09-12 00:00:00 |  | AE
2011-09-12 00:00:00 |  | AE
2011-09-12 00:00:00 |  | RL
2011-09-12 00:00:00 |  | RL
2011-09-13 00:00:00 |  | AE
2011-09-13 00:00:00 |  | AE
2011-09-13 00:00:00 |  | AE
2011-09-13 00:00:00 |  | RL
Spreadsheet: 59215d1259701145-between-2-dates-problem-demo-analysis
Sheet: Rounds Detailed

 | Weekday Green Fee |  |  |  |  | Weekend Green Fee
 | From: |  | To: |  |  | From: |  | To:
 | Item # | 2010 Membership Cards | # of Rounds | Sales |  | Item # | 2010 Membership Cards | # of Rounds | Sales
 | 9504 | Adult 18 Hole: |  |  |  | 9505
 | 9500 | Adult 18 + Cart: |  |  |  | 9501
 | 9502 | Adult 9 Hole: |  |  |  | 9503
 | 9515 | Senior 18 Hole: |  |  |  | 9516
 | 9511 | Senior 18 + Cart: |  |  |  | 9512
 | 9513 | Senior 9 Hole: |  |  |  | 9514
 | 9525 | Volume 18 Hole: |  |  |  | 9526
 | 9521 | Volume 18 + Cart: |  |  |  | 9522
 | 9523 | Volume 9 Hole: |  |  |  | 9524
 | 9508 | [NAME]: |  |  |  | 9509
 | 9506 | [NAME]: |  |  |  | 9507
 | 9519 | Senior Spouse: |  |  |  | 9520
 | 9517 | Senior [NAME]: |  |  |  | 9518
 | 9529 | Volume Spouse: |  |  |  | 9530
 | 9527 | Volume Spouse + Cart: |  |  |  | 9528
 |  | Total: |  |  |  |  | Total:
 | Item # | 2009 Membership Cards | # of Rounds | Sales |  | Item # | 2009 Membership Cards | # of Rounds | Sales
 | 008 |  |  |  |  | 014
 | 4000 |  |  |  |  | 4001
 | 9003 |  |  |  |  | 9004
 | 005 |  |  |  |  | 012
 | 4004 |  |  |  |  | 4005
 | 9005 |  |  |  |  | 9006
 | 028 |  |  |  |  | 042
 | 4002 |  |  |  |  | 4003
 | 9001 |  |  |  |  | 9002
 | 0011 |  |  |  |  | 0101
 | 4006 |  |  |  |  | 4007
 | 0031 |  |  |  |  | 0121
 | 4010 |  |  |  |  | 4011
 | 0281 |  |  |  |  | 0421
 | 4008 |  |  |  |  | 4009
 |  | Total: |  |  |  |  | Total:
 | Item # | General Rates | # of Rounds | Sales |  | Item # | General Rates | # of Rounds | Sales
 | 001 | Adult 18 Hole: |  |  |  | 010
 | 018 | Adult 9 Hole: |  |  |  | 013
 | 003 | Senior 18:
 | 047 | Student: |  |  |  | 026
 | 004 | Off Peak: |  |  |  | 011
 | 007 | Sundowner: |  |  |  | 046
 |  | Total: |  |  |  |  | Total:
 | Item # | Promotional Rounds | # of Rounds | Sales |  | Item # | Promotional Rounds | # of Rounds | Sales
 | 060 | Camper Promo: |  |  |  | 061
 | 038 | Hotel Promo: |  |  |  | 041
 | 058 | Military Promo:
 | 2506 | Off-Peek Promo:
 | 2507 | CMC Promo:
 | 1153 | Youth on Course Promo:
 | 1155 | SCGA Promo:
 |  | Total: |  |  |  |  | Total:
 | Item # | Courtesy Rounds | # of Rounds | Sales
 | 016 | Play 10 Card:
 | 0171 | Marshal:
 | 0172 | Employee:
 | 0173 | Professional Golfer:
 | 0174 | Superintendent:
 | 029 | Golf Team:
 | 044 | Disc. Card:
 | 2500 | Birthday:
 | 2502 | Replay Promotion:
 | 2508 | August Promo:
 | 2509 | September Promo:
 |  | Total:
Spreadsheet: vkaminski__40925__ConstellDelta PostitionNYC
Sheet: Sheet1

Positions
Peak 5X16
 | Power - (Long) |  |  |  |  |  | Resid - (Short)
 | MW Hours | MW | Delta | Mwh Delta Position | MW Delta Position |  | Barrels per Month | Resid Delta | Resid Delta Position
2001-03-01 00:00:00 | 35200 | 100 | 0.9997956702535604 | 35192.80759292532 | 99.97956702535605 |  | 61587.40257674567 | -0.9996952977841815 | -61568.63675871403
2001-04-01 00:00:00 | 33600 | 100 | 0.9845132144963045 | 33079.64400707583 | 98.45132144963044 |  | 58787.97518689359 | -0.9772808942009209 | -57452.36495890892
2001-05-01 00:00:00 | 35200 | 100 | 0.9652648129416278 | 33977.3214155453 | 96.52648129416278 |  | 61587.40257674567 | -0.9388360080098187 | -57820.47117884552
2001-06-01 00:00:00 | 33600 | 100 | 0.9753294731315522 | 32771.07029722015 | 97.53294731315522 |  | 58787.97518689359 | -0.9379286970261604 | -55138.92896784936
2001-07-01 00:00:00 | 33600 | 100 | 0.9938385979470337 | 33392.97689102033 | 99.38385979470337 |  | 58787.97518689359 | -0.9758765961646053 | -57369.809120795
2001-08-01 00:00:00 | 36800 | 100 | 0.9942204361354794 | 36587.31204978564 | 99.42204361354794 |  | 64386.82996659774 | -0.9774462950120338 | -62934.66839842076
2001-09-01 00:00:00 | 30400 | 100 | 0.957996640984809 | 29123.09788593819 | 95.7996640984809 |  | 53189.12040718944 | -0.9319590281635448 | -49570.08096355804
2001-10-01 00:00:00 | 36800 | 100 | 0.9613907811200294 | 35379.18074521708 | 96.13907811200293 |  | 64386.82996659774 | -0.9389743809418707 | -60457.5838086956
2001-11-01 00:00:00 | 33600 | 100 | 0.9594647460404088 | 32238.01546695774 | 95.94647460404087 |  | 58787.97518689359 | -0.9358128640843617 | -55014.54343336728
2001-12-01 00:00:00 | 32000 | 100 | 0.9578372559713048 | 30650.79219108175 | 95.78372559713047 |  | 55988.54779704152 | -0.9331322730255485 | -52244.72086925292
2002-01-01 00:00:00 | 35200 | 100 | 0.997431137808061 | 35109.57605084375 | 99.7431137808061 |  | 61587.40257674567 | -0.9951253249015584 | -61287.1839990271
2002-02-01 00:00:00 | 32000 | 100 | 0.9969387484782714 | 31902.03995130468 | 99.69387484782713 |  | 55988.54779704152 | -0.9941797951120716 | -55662.68297748516
Spreadsheet: chris_germany__2936__mid continent needs
Sheet: Sheet1

MID CONTINENT AREA
 |  |  |  | C & I | CONSUMERS |  | PRIM | JONES |  | 8907
 |  |  |  | C & I | CONSUMERS |  | SEC | JONES |  | 0
 |  |  |  | CHOICE | MICHCON (mcf) |  | PRIM | JONES |  | 7300
 |  |  |  | CHOICE | MICHCON (mcf) |  | SEC | JONES
 |  |  |  | C & I | MICHCON (mcf) |  | PRIM | JONES |  | 4117
 |  |  |  | C & I | MICHCON (mcf) |  | SEC | JONES
 |  |  |  | C & I | INDIANA GAS |  | PRIM | JONES |  | 1551
 |  |  |  | C & I | INDIANA GAS |  | SEC | JONES |  | 0
 |  |  |  | C & I | NICOR/NIGAS |  | PRIM | JONES |  | 710
 |  |  |  | C & I | NICOR/NIGAS |  | SEC | JONES |  | 0
 |  |  |  | CHOICE | NIPSCO |  | PRIM | JONES |  | 0
 |  |  |  | CHOICE | NIPSCO |  | SEC | JONES
 |  |  |  | CHOICE | NIPSCO |  | SEC | JONES
 |  |  |  | C & I | NIPSCO |  | PRIM | JONES |  | 0
 |  |  |  | C & I | NIPSCO |  | SEC | JONES
 |  |  |  | C & I | NORTH SHORE |  | PRIM | JONES |  | 70
 |  |  |  | C & I | NORTH SHORE |  | SEC | JONES |  | 0
 |  |  |  | C & I | PEOPLES GL&C |  | PRIM | JONES |  | 60
 |  |  |  | C & I | PEOPLES GL&C |  | SEC | JONES |  | 0