tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 743635d1628634964-i-am-having-trouble-with-the-index-match-function-book1
Sheet: Sheet1

 |  | [NAME] | 42
 |  | Length | 42
 |  |  | Price per unit
 |  | [NAME]
 |  | Lookup Length
 |  |  | Sales price per Unit
 |  | 36 | 48 | 60 | 72 | 84 | 96
 | 36 | 35.3990784 | 42.6013056 | 50.123136 | 66.1627008 | 154.3796352 | 117.6225792
 | 48 | 41.53632 | 53.4648576 | 66.8309376 | 88.21693440000001 | 154.3796352 | 117.6225792
 | 60 | 50.09007359999999 | 66.8309376 | 83.5387392 | 110.271168 | 154.3796352 | 176.4338688
 | 72 | 60.1477632 | 80.19728640000001 | 100.2465408 | 129.6374016 | 154.3796352 | 176.4338688
 | 96 | 80.19728640000001 | 101.5534464 | 133.6618752 | 176.4338688 | 205.8395136 | 176.4338688
Spreadsheet: 40287d1238594330-cannot-save-formulas-with-weeknum-function-solved-with-workaround-weeknum-problem-dummy-workbook
Sheet: Teams sheet should be

W Company
January 2009 Bookings
2009-01-01 00:00:00
Team-Sales Rep Summary |  |  |  |  |  |  |  |  | Team-Order Type Summary
Sales Rep | YTD | MTD | WTD (week begins Sunday,) |  |  |  |  |  | Order Type | YTD | MTD | WTD (week begins Sunday,)
Team | Sales Team A | Jan-2009 | 2009-1 | 2009-2 | 2009-3 | 2009-4 | 2009-5 |  | Team | Sales Team A | Jan-2009 | 2009-1 | 2009-2 | 2009-3 | 2009-4 | 2009-5
 |  |  | 2008-12-28 00:00:00 | 2009-01-04 00:00:00 | 2009-01-11 00:00:00 | 2009-01-18 00:00:00 | 2009-01-25 00:00:00 |  |  |  |  | 2008-12-28 00:00:00 | 2009-01-04 00:00:00 | 2009-01-11 00:00:00 | 2009-01-18 00:00:00 | 2009-01-25 00:00:00
 |  |  | ^^^ |  |  |  |  |  |  |  |  | ^^^
 |  |  | Cells D8 through H9 and M8 through Q9 are the ones that keep losing their formulas.
 |  |  | When you change the month in A4, for instance from 1/1/2009 to 2/1/2009,
 |  |  | the array formulas below on the Teams sheet update the month to date and week to date totals based on that date.
D8 through H8 should contain the following 5 formulas: YEAR($A4)&"-"&WEEKNUM($A4) ---- YEAR($A4)&"-"&WEEKNUM($A4)+1 ---- YEAR($A4)&"-"&WEEKNUM($A4)+2 ---- [NAME] ---- YEAR($A4)&"-"&WEEKNUM($A4)+4
and the same for M8 through Q8.
D9 through G9 contains (DATE(LEFT(D8,4),1,VALUE(IF(LEN(WEEKNUM($A4))=2,RIGHT(D8,2),RIGHT(D8,1)))*7-2)-WEEKDAY(DATE(LEFT(D8,4),1,4)))-7
in the first 4 cells, replacing D8 with E8, etc, same with M9 through P9, and
H9 and Q9 contain (DATE(LEFT(H8,4),1,VALUE(IF(OR(LEN(WEEKNUM($A4))=2, MONTH(A4)=2),RIGHT(H8,2),RIGHT(H8,1)))*7-2)-WEEKDAY(DATE(LEFT(H8,4),1,4)))-7 in the fifth cell,
replacing H8 with Q8 where necessary.
Spreadsheet: 32498d1228713657-vlookup-returns-a-fill-colour-sample
Sheet: Sheet1

Cells I9:M12 pick up the colour corresponding to cells B9:F12 from the range P5:P15
 |  |  |  |  |  |  | TRYING TO ACHIEVE… |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 | WORK TYPE |  |  |  |  |  |  | QUICK REFERENCE |  |  |  |  |  |  | C
Week | Mon | Tue | Wed | Thu | Fri |  |  | Mon | Tue | Wed | Thu | Fri |  |  | D
1 | A | B | C | D | E |  |  | A | B | C | D | E |  |  | E
2 | C | D | A | B | J |  |  | C | D | A | B | J |  |  | F
3 | K | L | C | D | K |  |  | K | G | C | D | K |  |  | G
4 | D | A | B | J | A |  |  | D | A | B | J | A |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
Spreadsheet: 16ffb20b-a0d7-40c7-81aa-885a7005170b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43509551 | 2014-10-09 21:09:48 | AXIS | 1 | 5 | 3 | 1089753 | Interociter2 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43509677 | 2014-10-09 21:23:03 | ALLIES | 0 | 3 | 5 | 1089753 | Interociter2 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43609499 | 2014-10-16 21:40:36 | AXIS | 1 | 5 | 3 | 578329 | Valentin de Ramillies | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43609660 | 2014-10-16 21:51:59 | ALLIES | 1 | 5 | 2 | 578329 | Valentin de Ramillies | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43694294 | 2014-10-22 20:53:51 | AXIS | 1 | 5 | 1 | 1634155 | toconarus | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43694472 | 2014-10-22 21:13:14 | ALLIES | 0 | 3 | 5 | 1634155 | toconarus | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6802 | 5488 |  |  | 1020 | 1011 | 1891 | 1414
2 | 6013 | 5488 |  |  | 1005 | 1011 | 577 | 1414
3 | 5948 | 5488 |  |  | 1055 | 1011 | 1908 | 1414
4 | 6198 | 5488 |  |  | 1045 | 856 | 1668 | 1414
5 | 6168 | 5488 |  |  | 607 | 1011 | 1539 | 1414
6 | 6277 | 5488 | 898 |  | 978 | 1011 | 1481 | 1414
7 | 6183 | 5488 | 2419 |  | 1079 | 506 | 1419 | 1414
8 | 6277 | 5488 | 2312 | 1000 | 1035 | 1007 | 1405 | 1414
9 | 6323 | 5488 | 2355 | 1000 | 1015 | 1011 | 1492 | 1414
10 | 3549 | 5488 | 2271 | 1000 | 871 | 1011 | 1559 | 1414
11 | 1420 | 5488 | 2181 | 1000 | 1020 | 1011 | 1457 | 1414
12 | 167 | 5488 | 2064 | 1000 | 1073 | 1011 | 1400 | 1414
13 | 4614 | 5488 | 2484 | 1000 | 961 | 1011 | 1376 | 1414
14 | 7263 | 5488 | 2371 | 1000 | 994 | 1011 | 818 | 1414
15 | 6620 | 5488 | 2262 | 1000 | 965 | 1011 | 1235 | 1414
16 | 6402 | 5488 | 2176 | 1000 | 951 | 1011 | 1214 | 1414
17 | 6116 | 5488 | 2116 | 1000 | 949 | 1011 | 929 | 1414
18 | 6326 | 5488 | 2017 | 1000 | 921 | 1011 | 1534 | 1414
19 | 6116 | 5688 | 1932 | 2300 | 925 | 1011 | 1840 | 1414
20 | 6167 | 5688 | 1860 | 2300 | 915 | 1011 | 1725 | 1414
21 | 5989 | 5688 | 1807 | 2300 | 960 | 1011 | 1894 | 1414
22 | 5734 | 5688 | 1732 | 2300 | 937 | 1011 | 1915 | 1414
23 | 5510 | 5688 | 1652 | 2300 | 921 | 1011 | 1733 | 1414
24 | 5377 | 5688 | 1567 | 2300 | 307 | 1011 | 1634 | 1414 |  |  | 377
25 | 5763 | 5688 | 1512 | 2300 | 1048 | 1011 | 1565 | 1414 |  |  | 725
26 | 6013 | 5688 | 1450 | 2300 | 1107 | 1011 | 1519 | 1414
27 | 5935 | 5688 | 1378 | 2300 | 991 | 1011 | 1526 | 1414
28 | 5801 | 5688 | 1313 | 2300 | 1040 | 1011 | 1637 | 1414
29 | 5812 | 5688 | 1243 | 2300 | 1061 | 1011 | 1641 | 1414
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | 423166.07
2001-12-29 00:00:00
CBS Volume
 |  |  | 174196
Spreadsheet: 844266d1695996597-arranging-table-using-pivot-function-testing
Sheet: Output required

Employee Name | Values | Amount |  | Employee Name | Attribute | Sum of Value
Employee A | Salary amount | 100000 |  | Employee A
 | Project-A | 75000 |  |  | Salary | 100000
 | Project-D | 25000 |  |  | Project A | 75000
 | [NAME] | 0 |  |  | Project D | 25000
 |  |  |  |  | Balance | 0
Employee B | Salary amount | 200000 |  | Employee B
 | Project-B | 100000 |  |  | Salary | 200000
 | Project-C | 50000 |  |  | Project B | 100000
 | Project-E | 50000 |  |  | Project C | 50000
 | [NAME] | 0 |  |  | Project E | 50000
 |  |  |  |  | Balance | 0
Employee C | Salary amount | 300000 |  | Employee C
 | Project-D | 50000 |  |  | Salary | 300000
 | Project-F | 100000 |  |  | Project D | 50000
 | Project-G | 150000 |  |  | Project F | 100000
 | [NAME] | 0 |  |  | Project G | 150000
 |  |  |  |  | Balance | 0
Employee D | Salary amount | 150000 |  | Employee D
 | Project-A | 50000 |  |  | Salary | 150000
 | Project-C | 75000 |  |  | Project A | 50000
 | [NAME] | 25000 |  |  | Project C | 75000
 |  |  |  |  | Balance | 25000
Employee E | Salary amount | 175000 |  | Employee E
 | Project-B | 75000 |  |  | Salary | 175000
 | Project-E | 25000 |  |  | Project B | 75000
 | Project-F | 30000 |  |  | Project E | 25000
 | Project-G | 20000 |  |  | Project F | 30000
 | [NAME] | 25000 |  |  | Project G | 20000
 |  |  |  |  | Balance | 25000
Spreadsheet: 130588d1322477280-vlookup-december
Sheet: 26

 |  |  |  | 2011-12-26 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 30566d1226092115-determining-if-numbers-span-a-range-profit-centre-calculations
Sheet: Sheet1

Test Size example | 228 |  |  | reference info:
 |  |  |  | point changes (+/-) 1 @ 0-13 range are $60
 |  |  |  | point changes (+/-) 1 @ 13-20 range are $30
PROFIT CENTRE |  | CHANGE | Gain (LOSS) | point changes (+/-) 1 @>20 range are $15
Current PR | 18 |  |  | this formula does not account for differential changes
Previous PR | 10 |  |  | and is wrong
PR Zone | units | Gain (LOSS)
<13 | 3
13-20 | 5
>20 | 0
 | did this column by hand
Spreadsheet: 105567d1302879989-calculate-the-number-of-options-by-divide-current-value-by-old-values-question-15-04
Sheet: Sheet1

DAYS |  | CALL
0 | OPEN | LOW | HIGH |  |  |  |  |  | # options | BUY? | Start over? | Right answers
1 | 0.35 | 0.35 | 0.35 |  |  |  |  | Begin |  | 1 | 1 | 1 |  |  | If there is a 1 in the buy column you buy
2 | 0.4 | 0.4 | 0.4 |  |  |  |  |  |  | 0
3 | 0 | 0 | 0 |  |  |  |  |  |  | 0
4 | 0 | 0 | 0 |  |  |  |  |  |  | 0 |  |  |  |  | If there is a 1 in start over? column you only buy 1 if there is a 2 you must also divide it also by the previous option value
5 | 0 | 0 | 0 |  |  |  |  |  |  | 0 |  |  |  |  | (# is number of)
6 | 0.25 | 0.2 | 0.25 |  |  |  |  |  |  | 1 | 2 | 1.4 |  |  | The second time you buy options you do ((0,35*#)/0,25) =  # options
7 | 0 | 0 | 0 |  |  |  |  |  |  | 0
8 | 0 | 0 | 0 |  |  |  |  |  |  | 0
9 | 0 | 0 | 0 |  |  |  |  |  |  | 0
10 | 0.15 | 0.15 | 0.3 |  |  |  |  |  |  | 1 | 3 | 4.666666666666667 |  |  | # options (((0,35*#)+(0,25*#)/0,15)
11 | 0.1 | 0.1 | 0.1 |  |  |  |  | start over |  | 1 | 1 |  |  |  | Here you start over because you sold something so # options is 1
12 | 0.25 | 0.15 | 0.25 |  |  |  |  |  |  | 0
13 | 0.15 | 0.15 | 0.2 |  |  |  |  | start over |  | 1 | 1 | 1
14 | 0.3 | 0.25 | 0.35 |  |  |  |  |  |  | 0
15 | 0 | 0 | 0 |  |  |  |  |  |  | 0
16 | 0.25 | 0.25 | 0.25 |  |  |  |  | start over |  | 1 | 1 | 1 |  |  | # options =1 of 0,25
17 | 0.2 | 0.2 | 0.2 |  |  |  |  |  |  | 0
18 | 0.15 | 0.15 | 0.15 |  |  |  |  |  |  | 0
19 | 0.15 | 0.15 | 0.15 |  |  |  |  |  |  | 1 | 2 | 1.666666666666667 |  |  | # options ((0,25*#)/0,15)
20 | 0 | 0 | 0 |  |  |  |  |  |  | 0
21 | 0.05 | 0.05 | 0.05 |  |  |  |  |  |  | 1 | 3 | 10 |  |  | # options(((0,25*#)+(0,15*#))/0,05)
22 | 0 | 0 | 0 |  |  |  |  |  |  | 0
23 | 0.15 | 0.15 | 0.15 |  |  |  |  |  |  | 1 | 4 | 6.666666666666667 |  |  | # options (((0,25*#)+(0,15*#)+(0,05*#))/0,15)
24 | 0.1 | 0.1 | 0.25 |  |  |  |  |  |  | 0
25 | 0 | 0 | 0 |  |  |  |  |  |  | 0
26 | 0 | 0 | 0 |  |  |  |  |  |  | 0
27 | 0.05 | 0.05 | 0.05 |  |  |  |  | start over |  | 1 | 1 | 1 |  |  | # options= 1 of 0,05
28 | 0 | 0 | 0 |  |  |  |  |  |  | 0
29 | 0 | 0 | 0 |  |  |  |  |  |  | 0
30 | 0 | 0 | 0 |  |  |  |  |  |  | 0
31 | 0 | 0 | 0 |  |  |  |  |  |  | 0
32 | 0 | 0 | 0 |  |  |  |  |  |  | 0
Spreadsheet: 1bd606da-fd29-4069-8e42-c6cb34da3b92
Sheet: Table 5

TABLE 5
CONTINUING EDUCATION & COMMUNITY SERVICE
PER-CREDIT TUITION SCHEDULE
UNIVERSITY OF HAWAI‘I
AY 2013-14 to AY 2016-17
 | CAMPUS |  | 2013 - 2014 |  |  | 2014 - 2015 |  |  | 2015 - 2016 |  |  | 2016 - 2017
 |  |  | Resident | Non-Res |  | Resident | Non-Res |  | Resident | Non-Res |  | Resident | Non-Res
 | UH MĀNOA OUTREACH COLLEGE  1/
 | Undergraduate  2/…………………………………………… |  | 381 | 1113 |  | 410 | 1193 |  | 441 | 1279 |  | 474 | 1371
 | Graduate  2/…………………………………… |  | 514 | 1245 |  | 552 | 1334 |  | 593 | 1430 |  | 637 | 1532
 | Graduate-Nursing……………………………….. |  | 811 | 1542 |  | 870 | 1652 |  | 933 | 1770 |  | 1001 | 1896
 | Graduate-CBA Masters  3/…………………… |  | 764 | 1311 |  | 802 | 1400 |  | 843 | 1496 |  | 887 | 1598
 | Graduate - Macc……………………………….. |  | 764 | 1311 |  | 802 | 1400 |  | 843 | 1496 |  | 887 | 1598
 | [NAME] |  | 764 | 1510 |  | 811 | 1633 |  | 870 | 1766 |  | 933 | 1909
 | Law-LLM…………………………………………. |  | 1529 | 1529 |  | 1622 | 1622 |  | 1737 | 1737 |  | 1860 | 1860
 | UH HILO CCECS  1/
 | Undergraduate…………………………………. |  | 258 | 748 |  | 277 | 777 |  | 297 | 807 |  | 319 | 840
 | Graduate………………………………………. |  | 389 | 892 |  | 417 | 956 |  | 447 | 1024 |  | 479 | 1097
 | Graduate Nursing………………………………………. |  | 635 | 1269 |  | 680 | 1359 |  | 729 | 1455 |  | 781 | 1558
 | Note:  Tuition rates subject to change.  Figures listed exclude fees.
1/ | At all campuses, tuition is not charged for credit courses subsidized under contractual agreements.  In accordance with University concurrent
 | enrollment policy, students enrolling at multiple institutions/campuses during the same term pay the applicable tuition at each campus.
2/ | Additional fees may be required based on program of study.
3/ | The CBA master's degrees offered in executive format charge the resident tuition established here plus additional fees delegated to
 | and approved by the President.
 | Source:  Executive Policy E6.201, October 26, 2011.
Spreadsheet: 544816d1509039937-how-to-sum-between-two-column-ranges-with-a-changing-variable-544795d1509034775-how-to-sum-between-two-column-ranges-with-a-changing-variable-progress-exampl
Sheet: Sheet1

 |  |  |  |  |  |  | Current Stage
 | Stage A | Stage B | Stage C | Stage D |  |  | Stage C
Product 1 | 43 | 119 | 92 | 52
Product 2 | 60 | 77 | 34 | 110
 |  |  |  |  |  | % Complete Example |  | Max 100
 | Stage A | Stage B | Stage C | Stage D |  | Product | Current Stage | Completion %
Product 1 | 43 | 119 | 92 | 52 |  | Product 1 | Stage C | 50
Product 2 | 60 | 77 | 34 | 110 |  |  | Calculated Points
Spreadsheet: 0b0b5f6c-508c-4bb7-bf24-b0e4d6ed20d1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 14F. Average Weekly Earnings, Private and Public Sectors, Tasmania (Dollars) - Original - Persons
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Tasmania ;  Private sector ; |  |  | Original | A2750898R | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Tasmania ;  Private sector ; |  |  | Original | A2750901T | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Tasmania ;  Private sector ; |  |  | Original | A2750907F | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Tasmania ;  Public sector ; |  |  | Original | A2732973T | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Tasmania ;  Public sector ; |  |  | Original | A2732976X | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Tasmania ;  Public sector ; |  |  | Original | [NAME] | 1994-11-15 00:00:00 | 2012-11-15 00:00:00 | 73 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Tasmania ;  Private sector ; |  |  | Original | A3523683A | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Total earnings ;  Tasmania ;  Private sector ; |  |  | Original | A3523686J | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Total earnings ;  Tasmania ;  Private sector ; |  |  | Original | A3523689R | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Tasmania ;  Public sector ; |  |  | Original | A3526923F | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Full Time; Adult; Total earnings ;  Tasmania ;  Public sector ; |  |  | Original | A3526926L | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
Standard Errors ;  Earnings; Persons; Total earnings ;  Tasmania ;  Public sector ; |  |  | Original | A3526929V | 2009-05-15 00:00:00 | 2012-11-15 00:00:00 | 15 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: sally_beck__33929__Weekly Operating Report 2-1
Sheet: Weekly Report

Principal Projects / Deals: |  |  |  |  |  |  |  | New Deals |  |  |  |  |  |  |  | Physical Volume of New Deals
Acquisition of Diashowa Newsprint Mill and related assets |  |  |  |  |  |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2 | Total |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/2 | Total
 | - operations to be assumed at closing in first quarter 2001 |  |  |  |  |  |  | EA |  |  |  |  |  |  |  | EA (in millions)
 | - approx. 400,000 tons of newsprint per year |  |  |  |  |  |  | Gas |  |  |  |  |  |  |  | Gas
 |  |  |  |  |  |  |  | Power |  |  |  |  |  |  |  | Power
HPL Monetization: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EGM (in thousands)
 | -  maintain operations and staff effectiveness through |  |  |  |  |  |  | EGM |  |  |  |  |  |  |  | Liquids
 | transfer date |  |  |  |  |  |  | IR/FX |  |  |  |  |  |  |  | Coal
 |  |  |  |  |  |  |  | Liquids |  |  |  |  |  |  |  | Emissions
 |  |  |  |  |  |  |  | Coal |  |  |  |  |  |  |  | EIM Total*
Develop Strategic Plan for commercialization of mid-office, |  |  |  |  |  |  |  | Weather |  |  |  |  |  |  |  | Newsprint
 | ASE February 12 & 13 |  |  |  |  |  |  | Emissions |  |  |  |  |  |  |  | Pulp
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lumber
Management information regarding PG&E |  |  |  |  |  |  |  | EIM |  |  |  |  |  |  |  | Steel
 |  |  |  |  |  |  |  | Newsprint |  |  |  |  |  |  |  | * Breakout of EIM volumes not available at this time
 |  |  |  |  |  |  |  | Pulp |  |  |  |  |  |  |  |  | New Counterparties
 |  |  |  |  |  |  |  | Lumber |  |  |  |  |  |  |  |  |  |  |  | 1/19 - 1/25 | 1/26 - 2/2
 |  |  |  |  |  |  |  | Steel |  |  |  |  |  |  |  |  | E-Commerce |  |  | 14 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non E-Commerce |  |  | 22 | 33
Spreadsheet: 882223d1730485644-excel-date-range-adding-zero-value-in-missing-date-excel-missing-date-with-value
Sheet: Sheet1

Actual |  |  |  | Expected
Date | Value |  |  | Date | Value
01/02/2024 | 750 |  |  | 2024-02-01 00:00:00 | 750
02/02/2024 | 38 |  |  | 2024-02-02 00:00:00 | 38+50
02/02/2024 | 50 |  |  | 2024-02-03 00:00:00 | 9275
03/02/2024 | 9275 |  |  | 2024-02-04 00:00:00 | 0
[NAME] | 8673 |  |  | 2024-02-05 00:00:00 | 8673
09/02/2024 | 300 |  |  | 2024-02-06 00:00:00 | 0
09/02/2024 | 15640 |  |  | 2024-02-07 00:00:00 | 0
12/02/2024 | 14 |  |  | 2024-02-08 00:00:00 | 0
12/02/2024 | 16 |  |  | 2024-02-09 00:00:00 | 300+15640
12/02/2024 | 17 |  |  | 2024-02-10 00:00:00 | 0
12/02/2024 | 5 |  |  | 2024-02-11 00:00:00 | 0
12/02/2024 | 5 |  |  | 2024-02-12 00:00:00 | 14+16+17+5+5
13/02/2024 | 7 |  |  | 2024-02-13 00:00:00 | 7
15/02/2024 | 8 |  |  | 2024-02-14 00:00:00 | 0
16/02/2024 | 9 |  |  | 2024-02-15 00:00:00 | 8
16/02/2024 | 0 |  |  | 2024-02-16 00:00:00 | 9+0
17/02/2024 | 1 |  |  | 2024-02-17 00:00:00 | 1+1
17/02/2024 | 1 |  |  | 2024-02-18 00:00:00 | 0
23/02/2024 | 1 |  |  | 2024-02-19 00:00:00 | 0
23/02/2024 | 1 |  |  | 2024-02-20 00:00:00 | 0
23/02/2024 | 1 |  |  | 2024-02-21 00:00:00 | 0
23/02/2024 | 1 |  |  | 2024-02-22 00:00:00 | 0
23/02/2024 | 1 |  |  | 2024-02-23 00:00:00 | 1+1+1+1
23/02/2024 | 1 |  |  | 2024-02-24 00:00:00 | 1
24/02/2024 | 1 |  |  | 2024-02-25 00:00:00 | 0
26/02/2024 | 1 |  |  | 2024-02-26 00:00:00 | 1+1
26/02/2024 | 1 |  |  | 2024-02-27 00:00:00 | 0
29/02/2024 | 1 |  |  | 2024-02-28 00:00:00 | 0
29/02/2024 | 1 |  |  | 2024-02-29 00:00:00 | 1
Spreadsheet: 9891b60e-c1f8-4ddb-9e30-2f45ac9d8475
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSTRP | Test | FSTRP | Streptomycin, HPLC | Streptomycin, HPLC | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 2 mL of serum frozen in  plastic vial. | 1.0 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Drug concentrations are expressed in mcg/mL.   Following intramuscular injection of 1 g of streptomycin as the sulfate, a peak serum level of 25 to 50 mcg/mL is reached within 1 hour.  Test Performed by: Focus Diagnostics, Inc.                               5785 Corporate Avenue                               Cypress, CA   90630-4750 | Monday, Wednesday, Friday | 5 - 6 days | 7 - 8 days | 1 | 80299 |  |  |  |  | Focus Diagnositics, Inc.
FSTRP | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
FSTRP | Result | Z0609 | Streptomycin, HPLC | Streptomycin, HPLC | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: richard_shapiro__32392__Proposed 2002 b
Sheet: Scenario 1

Cost Center Owner | [NAME]
Cost Center Number | 100088
 | Please use this form only for Outside Services
 | Scenario 1:  The "ideal" world
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | Piper Marbury | Legal/Illinois | 66000
 | Roan & Potts | Lobby/Illinois | 60000
 | Vorys Sater [NAME] | Lobby/Ohio | 36000
 | Karoub | Lobbying/Michigan | 60000
 | Varnum Riddering | Legal/Michigan | 24000
 | Bourgois | Lobby/Louisiana | 36000
 | BoseTreacy | Lobby/Indiana | 30000
 | Roy Cagle & Associate | Lobby/Missouri | 18000
 | Additional Lobbyist | Lobby/Missouri | 30000
 | Additional Lobby/Legal | Lobby/Arkansas | 15000
 | Corp. Contributions | Contribution/Illinois | 15000
 | Corp. Contributions | Contribution/Ohio | 8000
 | Corp. Contributions | Contribution/Michigan | 10000
 | Corp. Contributions | Contribution/Louisiana | 10000
 | Corp. Contributions | Contribution/Indiana | 8000
 | Corp. Contributions | Contribution/Missouri | 5000
 | Corp. Contributions | Contribution/Arkansas | 5000
 | Corp. Contributions | Contribution/MS | 3000
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | MWIPPS | Legal/Lobby/Regional | 30000
 | IMA, IRMA | Assoc./Illinois | 5000
 | ORM, OPAE | Assoc./Ohio | 3000
 | MRM, Chamber | Assoc./Michigan | 10000
 | LMOGA, LABI | Assoc./Louisiana | 15000
 | IRC, Chamber | [NAME] | 2000
 | Coalition, MRM, [NAME]. | Assoc/Missouri | 15000
 | IEC, ABI, Retail Fed. | [NAME].Lobby/Iowa | 4000
 | Chamber Choice Coalit. | [NAME]., Lobby/Minn | 5000
 | Manuf. & Chmbr, ALEC | [NAME]., Lobby/WI | 4000
 | USO&GA, MS, MMA | [NAME].Lobby/LA | 15000
 | USO&GA, MS, MMA | [NAME].Lobby/Miss. | 5000
 | USO&GA, MS, MMA | [NAME]. [NAME] | 10000
 | BILLD, NLIEC | Assoc.Lobbying | 9000
 | Varnum Riddering | Legal/Michigan | 50000
 | Piper Marbury | Legal/Illinois | 250000
 | Vorys Sater [NAME] | Legal/Ohio | 170000
 | Assorted - ENA | Legal/Regional | 60000
 | [NAME] | Legal/Indiana | 10000
 | [NAME] | Legal/West Virginia | 5000
 |  | Total:
 | Note:
 | Varnum - dereg. Proceedings, issues and rulemaking
 | Piper Marbury - ComEd., PPO Litigation, complaint against IP; other
 | Vorys - Complaint on physical delivery, OFO case against Columbus Coal
 | Plant Development
 | Assorted ENA Matters - Legal support for ENA Gas
 | Bose McKinney- Miscellaneous legal activity; IURC proceeding
 | on transmission.
 | Note also
 | Retainers for Indiana, Missouri and Louisiana may increase or decrease
 | based on decisions to pursue deregulation.