tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815891d1675253246-formula-to-sum-best-two-values-considering-groups-q218a
Sheet: Sheet1

 |  |  | Originally |  | How it is to be calculated?
 |  | Code | Obtained
 |  | B10 | 39 |  | Col C - B12 to [NAME] - check with [NAME], Sum best 2 of D12 TO D39 if F12 to F39 is "C"
 |  | C10 | 40 |  | i.e. | 1) Check - B12 to [NAME] if it match with B3
 |  | C13 | 39 |  |  | 2) After above, match F12 to F39 with "C"
 |  | E10 | 37 |  |  | 3) After both above, [NAME] to D39 - only best 2 values
 |  | A10 | 25
 |  | M10 | 28
 |  | R10 | 39
 |  | Code | Value | [NAME] | Desc1 |  | Example:
 |  | B10 | 13 | 20 | C | 28.6 is correct | Best 2 of B10 (of Col D) is 28.6 (of "C" as per Col F")
 |  | B10 | 15.6 | 20 | C
 |  | B10 | No | 20 | C
 |  | B10 | 10 | 10 | P
 |  | C10 | 4 | 10 | C
 |  | C10 | 8.2 | 10 | C | 13 is correct
 |  | C10 | 5 | 10 | C
 |  | C10 | 26.3 | 30 | P
 |  | C13 | 7.8 | 15 | C | 19.8 is correct
 |  | C13 | 6.3 | 15 | C
 |  | C13 | 12 | 15 | C
 |  | C13 | 19 | 20 | P
 |  | E10 | 11.8 | 20 | C
 |  | E10 | 12 | 20 | C
 |  | E10 | 15.2 | 20 | C
 |  | E10 | 10 | 10 | P
 |  | A10 | 2.4 | 15 | C
 |  | A10 | 3.6 | 15 | C
 |  | A10 | 5.7 | 15 | C
 |  | A10 | 16 | 20 | P
 |  | M10 | 2 | 20 | C
 |  | M10 | 10.8 | 20 | C
 |  | M10 | 7.6 | 20 | C
 |  | M10 | 10 | 10 | P
 |  | R10 | 6.9 | 15 | C
 |  | R10 | 11.4 | 15 | C
 |  | R10 | 8.4 | 15 | C
 |  | R10 | 18.7 | 20 | P
Spreadsheet: 36749d1234672422-link-sheets-and-populate-cell-based-on-entered-text-data1
Sheet: Data

 | Name | Won | Lost | Points | Average
 | [NAME] | 10 | 5 | 150 | 10
 | [NAME] | 6 | 9 | 95 | 6.333333333333333
 | [NAME] | 8 | 7 | 105 | 7
Spreadsheet: 705293d1605992468-is-if-formula-wrong-here-or-what-am-i-doing-wrong-handleliste
Sheet: Varer nødvendig

 |  | Kjøttdeig og spaghetti |  |  |  | Wraps med kylling og pestomasjones
 |  | hvitløksfedd | 2 | stk |  | Fullkornswrap | 4 | stk
 |  | [NAME] | 2 | stk |  | Kyllingfilet | 2 | stk
 |  | [NAME] | 1 | stk |  | [NAME] | 2 | ss
 |  | bacon | 150 | Gram |  | [NAME] | 6 | ss
 |  | kjøttdeig | 400 | Gram |  | Spinatblader | 80 | gram
 |  | Tine meierismør | 2 | ss |  | Cherrytomater | 8 | stk
 |  | hermetiske tomater à 400 g | 2 | bokser |  | Salt | 1 | Klype
 |  | salt | 1 | klype |  | Pepper | 1 | Klype
 |  | spaghetti (ev. fullkorn) | 400 | Gram |  | Solsikkeolje | 2 | ss
 |  | revet parmesan | 4 | ss
Spreadsheet: 770033d1645787480-count-values-with-multiple-or-criteria-jdging-example-1
Sheet: Draw_1

 | Gymnastics Judging Draw |  |  |  |  |  | Allocation of Judges to Venues
 | Name |  | Code |  |  | Name |  | Code |  |  | Name |  | Code
 | Judge 1 |  | J1 |  |  | Judge 2 |  | J2 |  |  | Judge 3 |  | J3
 | Venue A - 9: 00 AM |  |  |  |  | Venue B - 11: 00 AM |  |  |  |  | Venue C - 2:00 PM
 | Judge | Judge | Judge |  |  | Judge | Judge | Judge |  |  | Judge | Judge | Judge
 | Code | Code | Code | Candidate |  | Code | Code | Code | Candidate |  | Code | Code | Code | Candidate
Round 1 | J1 | J3 |  | [NAME] |  | J2 |  |  | [NAME] |  |  | J3 | J1 | [NAME]
 | J1 | J3 |  | [NAME] |  | J2 |  |  | Icration Jaunicee |  |  | J3 | J1 | Markwell Ashley
 | J1 | J3 |  | Drexyl Andria |  | J2 |  |  | Inmanally  Brett |  |  | J3 | J1 | [NAME]
Round 2 | J1 | J2 | J3 | [NAME] |  | J3 | J1 |  | Markwell Ashley |  | J2 | J1 | J3 | Drexyl Andria
 | J1 | J2 | J3 | [NAME] |  | J3 | J1 |  | [NAME] |  | J2 | J1 | J3 | [NAME]
 | J1 | J2 | J3 | [NAME] |  | J3 | J1 |  | [NAME] |  | J2 | J1 | J3 | Icration Jaunicee
 | These allocations are decided prior to the event
 |  |  | WORKINGS ONLY AS BELOW
 |  |  |  |  |  |  | Reconciliation
 |  |  |  |  |  | F1 | F2 | F3
 | [NAME] |  |  |  |  | 2 |  | 2
 | [NAME] |  |  |  |  | 2 | 1 | 2
 | [NAME]
 | [NAME]
 | Drexyl Andria |  |  |  |  | 2 | 1 | 2
 | [NAME] |  |  |  |  | 2 |  | 2
 | [NAME] |  |  |  |  | 1 | 1 | 1
 | [NAME] |  |  |  |  | 1 | 2 | 1
 | Icration Jaunicee |  |  |  |  | 1 | 2 | 1
 | Inmanally  Brett |  |  |  |  |  | 1
 | [NAME] |  |  |  |  | 2 | 1 | 2
 | Markwell Ashley |  |  |  |  | 2 |  | 2
Spreadsheet: 856105d1705483813-dynamic-array-for-cumulative-count-book1-fast-reduced
Sheet: Sheet1

 |  |  | 30 secs |  | 33  secs |  | 73 secs |  | 80  secs |  | 0.16 secs |  | 0.24 secs |  | 0.14 secs |  | 0.24 secs
Item | Value |  | Cumulative COUNTIF |  | Cumulative  SUMIF |  | Total COUNTIF |  | Total SUMIF |  | Cumulative COUNTIF |  | Cumulative  SUMIF |  | Total COUNTIF |  | Total SUMIF
C | 20
C | 23 |  |  |  |  |  |  |  |  |  | 2 |  | 43 |  | 5 |  | 73
B | 14 |  |  |  |  |  |  |  |  |  | 1 |  | 14 |  | 6 |  | 75
D | 3 |  |  |  |  |  |  |  |  |  | 1 |  | 3 |  | 3 |  | 21
B | 16 |  |  |  |  |  |  |  |  |  | 2 |  | 30 |  | 6 |  | 75
D | 4 |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 3 |  | 21
A | 16 |  |  |  |  |  |  |  |  |  | 1 |  | 16 |  | 4 |  | 65
B | 13 |  |  |  |  |  |  |  |  |  | 3 |  | 43 |  | 6 |  | 75
D | 14 |  |  |  |  |  |  |  |  |  | 3 |  | 21 |  | 3 |  | 21
B | 9 |  |  |  |  |  |  |  |  |  | 4 |  | 52 |  | 6 |  | 75
A | 15 |  |  |  |  |  |  |  |  |  | 2 |  | 31 |  | 4 |  | 65
B | 15 |  |  |  |  |  |  |  |  |  | 5 |  | 67 |  | 6 |  | 75
C | 15 |  |  |  |  |  |  |  |  |  | 3 |  | 58 |  | 5 |  | 73
A | 14 |  |  |  |  |  |  |  |  |  | 3 |  | 45 |  | 4 |  | 65
A | 20 |  |  |  |  |  |  |  |  |  | 4 |  | 65 |  | 4 |  | 65
C | 14 |  |  |  |  |  |  |  |  |  | 4 |  | 72 |  | 5 |  | 73
B | 8 |  |  |  |  |  |  |  |  |  | 6 |  | 75 |  | 6 |  | 75
C | 1 |  |  |  |  |  |  |  |  |  | 5 |  | 73 |  | 5 |  | 73
Spreadsheet: 743733d1628690318-using-the-optimal-number-of-bills-starting-with-the-smallest-forumhelpme
Sheet: Sheet1

 |  | Input | Output
 |  | Kasse 1 |  |  |  |  |  |  |  |  |  | Balance
 |  | Cash Value | Number of Bills | SUM | Removed | Left |  |  | Cash Value | # of bills | Sum
 |  | 500 | 0 |  |  |  |  |  | 5
 |  | 200 | 7 |  |  |  |  |  | 10
 |  | 100 | 14 |  |  |  |  |  | 20
 |  | 50 | 54 |  |  |  |  |  | 50
 |  | 20 | 49 |  |  |  |  |  | 100
 |  | 10 | 14 |  |  |  |  |  | 200
 |  | 5 | 14 |  |  |  |  |  | 500
 |  |  | [NAME] | 45.66
 |  |  | Coins in Safebag |  | Coins in Register
 |  |  | Base Amount in Register | 300 | Add to Register in Bills |  | Left to add
 |  |  | Should be Amount in Register
 |  |  | Actual Amount in Register
 |  |  | Difference
Spreadsheet: 688101d1595572191-countifs-in-combination-with-today-format-issue-issue-with-countifs-and-date
Sheet: Check

Issue with [NAME] and date
Date | Agent | Strike
01.07.2020 | [NAME] | Yes
01.07.2020 | George | No
01.07.2020 | [NAME] | No
02.07.2020 | [NAME] | No
02.07.2020 | George | Yes
02.07.2020 | [NAME] | No
03.07.2020 | [NAME] | Yes
03.07.2020 | George | Yes
03.07.2020 | [NAME] | Yes
10.07.2020 | [NAME] | No
10.07.2020 | George | No
10.07.2020 | [NAME] | Yes
11.07.2020 | [NAME] | Yes
11.07.2020 | George | Yes
11.07.2020 | [NAME] | Yes
20.07.2020 | [NAME] | No
21.07.2020 | George | No
22.07.2020 | [NAME] | Yes
23.07.2020 | [NAME] | No
23.07.2020 | George | Yes
23.07.2020 | [NAME] | Yes
24.07.2020 | [NAME] | Yes
24.07.2020 | George | Yes
24.07.2020 | [NAME] | Yes
Spreadsheet: 160655d1339159964-sumproduct-with-lookup-as-argument-conditionalsum4
Sheet: Result

Job \ Week number > | 1 | 2 | 3
Architect | #N/A | 1 | 0
Driver | 2 | 2 | 1
Salesperson | 2 | 2 | 3
 |  |  |  |  |  |  |  | Person | Job | Person
 |  |  |  |  |  | Attempt |  | Chelsea | Architect | Chelsea
 |  |  |  |  |  | Driver |  | [NAME] | Driver | [NAME]
 |  |  |  |  |  | Driver |  | [NAME] | Driver | [NAME]
 |  |  |  |  |  | Architect |  | Nina | Salesperson | Nina
 |  |  |  |  |  | Salesperson |  | [NAME] | Salesperson | [NAME]
 |  |  |  |  |  | Salesperson
 |  |  |  |  |  | Salesperson
 |  |  |  |  |  |  |  | Given input
 |  |  |  |  |  |  |  | Person \ Week number | 1 | 2 | 3
 |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 1
 |  |  |  |  |  |  |  | [NAME] | 1 | 1
 |  |  |  |  |  |  |  | Chelsea |  | 1
 |  |  |  |  |  |  |  | Nina |  |  | 1
 |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 1
 |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 1
 |  | Current situation: To get the table B2:D4 we have the green array, which represent the people belonging to a job in the order of I20:I25.
 |  | Goal: Calculate B2:D4 without to have the green array explicitly written down. An attempt which doesn't work is in B2
Spreadsheet: 47284d1246308764-job-hour-summary-using-daily-pivot-totals-can-it-be-done-weekly-timesheet-summary-7-days-
Sheet: Thursday

2009-01-15 00:00:00 | Thursday
Job # | Employee | Total Hours
870 |  | 1.5
 | [NAME] | 1.5
1223-5567 |  | 40.5
 | [NAME] | 4
 | [NAME] | 5.5
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 1.5
 | [NAME] | 3
 | [NAME] | 4.5
 | [NAME] | 3
 | [NAME] | 8
 | [NAME] | 3.5
5553-6789 |  | 35.5
 | [NAME] | 1.5
 | [NAME] | 8
 | [NAME] | 4
 | [NAME] | 6.5
 | [NAME] | 2
 | [NAME] | 8
 | [NAME] | 3
 | [NAME] | 2.5
shop |  | 16
 | [NAME] | 8
 | [NAME] | 8
yard |  | 6.5
 | Cecil Elliot | 6.5
7445-1235 |  | 5
 | [NAME] | 5
out |  | 0
 | Chase Payne | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | Pascual Mateo | 0
shipping office |  | 10.25
 | [NAME] | 8.25
 | [NAME] | 2
6789-9433 |  | 2.5
 | [NAME] | 2.5
5678-2345 |  | 1.5
 | [NAME] | 1.5
shop/tool manitenance |  | 3
 | [NAME] | 3
4567-7543 |  | 6
 | [NAME] | 3.5
 | [NAME] | 2.5
4568-8467 |  | 3
 | [NAME] | 3
4567-8210 |  | 2.5
 | [NAME] | 2.5
4568-9832 |  | 2
 | [NAME] | 2
load trucks |  | 7.5
 | [NAME] | 4
 | [NAME] | 3.5
3450-6743 |  | 4.5
 | [NAME] | 2
 | [NAME] | 2.5
5678-3832 |  | 7
 | [NAME] | 3.5
 | [NAME] | 3.5
3456-9876 |  | 5.5
 | [NAME] | 2
 | [NAME] | 3.5
Scruggs elec layout |  | 3
 | [NAME] | 3
sales |  | 5.5
 | [NAME] | 5.5
design |  | 5
 | [NAME] | 5
Grand Total |  | 173.75
Spreadsheet: 113a16d3-2d0d-4aa5-96d5-4ee83b5c8638
Sheet: USDA Logo Use Addendum

Name of Auditee:
Date of Audit:
Note:  An official identification logo has been developed in conjunction with the USDA GAP&GHP program which may be used to indicate participation in the program.  Participants may use the logo, provided they meet the requirements of the USDA logo use instructions found at www.ams.usda.gov/gapghp and meet the requirements of this audit.  Failure to meet the audit will result in steps taken in accordance with the USDA logo use instructions.
The USDA Logo Use [NAME] acceptance criteria is as follows:
1 | No questions are assessed as an "IAR", Immediate Action Required.
2 | Falsification of records is considered an "IAR".
3 | All questions not answered as "NA" are answered as compliant.
Q # | Requirement | DOC | C | CAN | IAR | NA | Auditor Comments
5 | Additional questions required for operations approved to use the USDA GAP&GHP Logo
5.1 | Active and Effective Traceability and Recall Program
5.1.1 | Questions in Section 1.6 and 1.7 have been marked Compliant. | WP,R
5.1.2 | The operation uses the USDA GAP&GHP logo only on packages, containers, or consumer units which are traceable. | WP
5.2 | Approved Suppliers
5.2.1 | The operation has supplied a list of approved suppliers to the local Federal or State auditor’s office. | R
5.2.2 | All suppliers currently in use by the operation are listed on the supplied list of approved suppliers. | WP, R
5.2.3 | All suppliers have successfully completed and met the requirements of a USDA approved GAP & GHP audit (USDA GAP&GHP audit, commodity specific audit, or [NAME] GAPs Harmonized audit performed by USDA) . | R
5.3 | Food Safety Plan or Quality Manual
5.3.1 | The operation’s food safety plan or quality manual contains procedures on how the USDA GAP&GHP logo will be used. | WP
5.4 | Containers or [NAME] with GAP&GHP Logo
5.4.1 | All containers or labels, which bear the GAP&GHP logo, are accountable items. | WP, R
5.4.2 | The operation’s inventory list of these containers or labels is maintained and current. | R
Code Key: WP = Written Policy/Procedure; R = Record
Additional Auditor Comments:
Spreadsheet: tracy_geaccone__40532__ETS - Transwestern IC 10-19
Sheet: IT Development

Cost Center | Project Manager | Activity | Project Name | ETS $ Expense | ETS $ [NAME]
103152 | Ogg | DEVELOPMENT SUPPORT | Oracle Software Maintenance** | 351424.8136782113 | 0
103152 | Ogg | DEVELOPMENT SUPPORT | [NAME] renewal | 92711.416781293 | 0
103153 | S.Cleverly | INTRANET | IZZIE Maintenance* | 16203.91567464527 | 0
Totals
ETS Company |  | Desktop Counts | Percentage | Oracle | Tibco | Other* | Total Projects
Northern Plains Natural Gas |  | 119 | 0.1187624750499002
Enron Transportation Services |  | 168 | 0.1676646706586826
Northern Natural Gas |  | 368 | 0.3672654690618762
[NAME] |  | 57 | 0.05688622754491018
Citrus Corp |  | 136 | 0.1357285429141717
Enron Asset Management Resources |  | 141 | 0.1407185628742515
Enron Pipeline Services Co. |  | 13 | 0.01297405189620758
ETS Total
*Other - remaining projects broken out by desktop counts.
**Please note tht the above Oracle amount is subject to change based on renegotiation of the project.
Spreadsheet: 161104d1339417779-date-problem-date_sample
Sheet: Sheet1

ACT_DATE
31/05/2012 |  | 31/05/2012
31/05/2012 |  | 31/05/2012
30/05/2012 |  | 30/05/2012
29/05/2012 |  | 29/05/2012
28/05/2012 |  | 28/05/2012
27/05/2012 |  | 27/05/2012
26/05/2012 |  | 26/05/2012
25/05/2012 |  | 25/05/2012
22/05/2012 |  | 22/05/2012
19/05/2012 |  | 19/05/2012
18/05/2012 |  | 18/05/2012
17/05/2012 |  | 17/05/2012
16/05/2012 |  | 16/05/2012
11/06/2012 |  | 06/11/2012
10/06/2012 |  | 06/10/2012
09/06/2012 |  | 06/09/2012
08/06/2012 |  | 06/08/2012
07/06/2012 |  | 06/07/2012
06/06/2012 |  | 06/06/2012
05/06/2012 |  | [NAME]
04/06/2012 |  | 06/04/2012
03/06/2012 |  | 06/03/2012
02/06/2012 |  | 06/02/2012
01/06/2012 |  | 06/01/2012
Spreadsheet: john_forney__15528__s_9-15-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-15 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME]
Enron Call |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Mirant Call |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
Total
[NAME]: |  | Deal Details
29
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 12 |  | 22
775471.1 |  | Enron sell | 50 |  | 12 |  | 22
Spreadsheet: 0cd6b7d0-b5ab-4728-94b7-073e2eb3e1b7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table 10--Acreage, yield, and production estimates, 2013
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 365 |  | 363 |  | 767 |  | 580
Florida | 130 |  | 123 |  | 780 |  | 200
Georgia | 1360 |  | 1335 |  | 845 |  | 2350
North Carolina | 465 |  | 460 |  | 856 |  | 820
South Carolina | 255 |  | 253 |  | 721 |  | 380
Virginia | 78 |  | 77 |  | 972 |  | 156
Southeast | 2653 |  | 2611 |  | 825 |  | 4486
Arkansas | 305 |  | 300 |  | 1232 |  | 770
Louisiana | 130 |  | 125 |  | 1267 |  | 330
Mississippi | 300 |  | 295 |  | 1188 |  | 730
Missouri | 250 |  | 241 |  | 976 |  | 490
Tennessee | 250 |  | 235 |  | 878 |  | 430
Delta | 1235 |  | 1196 |  | 1104 |  | 2750
Kansas | 27 |  | 26 |  | 683 |  | 37
Oklahoma | 185 |  | 170 |  | 565 |  | 200
Texas | 5750 |  | 3300 |  | 596 |  | 4100
Southwest | 5962 |  | 3496 |  | 595 |  | 4337
Arizona | 155 |  | 153 |  | 1616 |  | 515
California | 93 |  | 92 |  | 1461 |  | 280
New Mexico | 38 |  | 34 |  | 1059 |  | 75
West | 286 |  | 279 |  | 1497 |  | 870
Total Upland | 10136 |  | 7582 |  | 788 |  | 12443
Pima:
Arizona | 2 |  | 2 |  | 800 |  | 3
California | 187 |  | 186 |  | 1548 |  | 600
New Mexico | 4 |  | 3 |  | 1018 |  | 7
Texas | 9 |  | 8 |  | 960 |  | 16
Total Pima | 201 |  | 199 |  | 1510 |  | 626
Total all | 10337 |  | 7781 |  | 806 |  | 13069
Source:  USDA, December 2013 Crop Production report.
Last update: 12/12/13.
Spreadsheet: 73a197b3-c168-437e-9699-7bbff5acaef3
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Administrative Applications | 1 | Fill current vacant positions. | None | -- Pick One -- | 1.1.r1 | Overtime Budget | OneTime | 100000 | 0 | 100000 | 0 | 100000 | 0 | 0 | 0
Administrative Applications | 1 | Fill current vacant positions. | None | -- Pick One -- | 1.1.r2 | Training Budget | OneTime | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 2 | Determine and schedule staff training/conference opportunities | None | -- Pick One -- | 1.2.r1 | Training/Conference Budget | OnGoing | 50000 | 0 | 50000 | 0 | 50000 | 0 | 0 | 0
Administrative Applications | 3 | Improve helpdesk services through increased usage of online and self-help resources. | None | -- Pick One -- | 2.1.r1 | Software Budget | OnGoing | 50000 | 0 | 5000 | 0 | 5000 | 0 | 0 | 0
Administrative Applications | 3 | Improve helpdesk services through increased usage of online and self-help resources. | None | -- Pick One -- | 2.1.r2 | Training Budget | OneTime | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 4 | Improve effective written and verbal communication with users. | None | -- Pick One --
Administrative Applications | 5 | Train staff on Project Management Methodologies | None | -- Pick One -- | 3.1.r1 | Training Budget | OneTime | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 6 | Review ‘Project Prioritization’ process to maximize available resources. | None | -- Pick One --
Administrative Applications | 7 | Improve MIS Error Reporting | None | -- Pick One --
Spreadsheet: 846655d1697796004-excel-project-excel-help-1-
Sheet: Timesheet

Project | Name | Hours
1 | [NAME] | 1
1 | [NAME] | 2
1 | Martin | 3
1 | Ian | 4
1 | Bogdan | 5
2 | [NAME] | 1
2 | [NAME] | 2
2 | Martin | 3
2 | Ian | 4
2 | Bogdan | 5
Spreadsheet: james_steffes__12786__pa icap
Sheet: Sheet1

Wholesale Market Lines in PECO Energy: Derived All-Hours Electricity Prices in the PJM Wholesale Market (various estimates)
 | PHB/PECO ([NAME])* |  |  |  | EDS/PECO ([NAME])* |  |  |  | ICF/PECO ([NAME] and [NAME])* |  |  |  | PAOCA ([NAME])* |  |  |  | PAIEUG ([NAME])*
Year | Capacity ($/kW-year) | Capacity ($/kW-month) | Energy | Total | Capacity ($/kW-year) | Capacity ($/kW-month) | Energy | Total | Capacity ($/kW-year) | Capacity ($/kW-month) | Energy | Total | Capacity ($/kW-year) | Capacity ($/kW-month) | Energy | Total | Capacity ($/kW-year) | Capacity ($/kW-month) | Energy | Total
1999 | 16.0<+> |  | 2.02 | 2.2 | 23.9 |  | 2.15 | 2.42 | 23.9 |  | 2.22 | 2.49 | 19.7 |  | 2.24 | 2.46 | 24.2 |  | 2.39 | 2.67
2000 | 27 |  | 2.13 | 2.44 | 31.1 |  | 2.26 | 2.62 | 31.1 |  | 2.35 | 2.71 | 30.4 |  | 2.36 | 2.71 | 30.8 |  | 2.58 | 2.93
2001 | 45.4 |  | 2.23 | 2.75 | 45.1 |  | 2.41 | 2.92 | 45.1 |  | 2.45 | 2.96 | 41.7 |  | 2.51 | 2.99 | 46.5 |  | 2.6 | 3.13
2002 | 46.7 |  | 2.35 | 2.88 | 49.1 |  | 2.49 | 3.05 | 46.7 |  | 2.58 | 3.11 | 43.1 |  | 2.64 | 3.13 | 49 |  | 2.67 | 3.23
2003 | 48.1 |  | 2.47 | 3.02 | 50.3 |  | 2.58 | 3.15 | 47.8 |  | 2.65 | 3.2 | 44.2 |  | 2.81 | 3.31 | 53.4 |  | 2.71 | 3.32
2004 | 49.6 |  | 2.59 | 3.16 | 52.7 |  | 2.68 | 3.28 | 49.4 |  | 2.74 | 3.3 | 45.7 |  | 2.94 | 3.46 | 58.2 |  | 2.73 | 3.39
2005 | 51.3 |  | 2.71 | 3.3 | 54.2 |  | 2.76 | 3.38 | 51 |  | 2.85 | 3.43 | 47.1 |  | 3.18 | 3.72 | 60 |  | 2.83 | 3.51
2006 | 55 |  | 2.83 | 3.46 | 57.3 |  | 2.84 | 3.49 | 52.9 |  | 2.98 | 3.58 | 48.9 |  | 3.41 | 3.97 | 61.2 |  | 2.95 | 3.65
2007 | 56.9 |  | 2.95 | 3.6 | 58 |  | 2.98 | 3.64 | 54.5 |  | 3.1 | 3.72 | 50.4 |  | 3.6 | 4.18 | 61.3 |  | 3.09 | 3.79
2008 | 59 |  | 3.08 | 3.75 | 58.7 |  | 2.76 | 3.43 | 56.5 |  | 3.24 | 3.88 | 52.2 |  | 3.83 | 4.43 | 64.4 |  | 3.19 | 3.93
Notes: The names in parentheses are expert witnesses
Values for energy and total are in cents/kW-hour
Parties: Putnam [NAME], Electronic Data Systems, ICF Kaiser, Pennsylvania Office of Consumer Advocate, Philadelphia-Area Industrial Energy Users Group
Spreadsheet: 82887491-d244-45e1-849e-847383c02a2c
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
OPRM1 | Test | OPRM1 | Opioid Receptor, Mu 1 (OPRM1) Genotype for Naltrexone Efficacy | [NAME], Naltrexone Efficacy | Polymerase Chain Reaction (PCR) 5'-Nuclease End point Allelic Discrimination Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular System, Inc.) | Lavendar-top (EDTA) Tube: EDTA (<1 month old infant) |  |  | 3 | mL | Multiple whole blood EDTA genotype tests can be performed on a single specimen after a single extraction. See Multiple Whole Blood EDTA Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Additional Information: 1. Bone marrow and liver transplants will interfere with testing. Call Mayo Medical Laboratories at [PHONE] or [PHONE] for instructions. 2. Transfusions will interfere with testing for up to 4 to 6 weeks. DNA obtained from white cells may not provide useful information for patients who received a recent transfusion of blood that was not leukocyte-reduced. Wait 4 to 6 weeks until transfused cells have left the patient's circulation before drawing the patient's blood specimen for genotype testing. Forms: New York Clients-Informed consent is required. Please document on request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.3 mL | Hemolysis	NA Thawing	Warm reject; Gross reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday; 8 a.m. | 1 day | 8 days | 1 | 81479 |  |  |  |  | Rochester
OPRM1 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
OPRM1 | Result | 31912 | OPRM1 Result | OPRM1 Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
OPRM1 | Result | 31913 | OPRM1 Interpretation | OPRM1 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
OPRM1 | Result | 31914 | OPRM1 Reviewed by | OPRM1 Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: f574f895-d62d-4313-bc93-468ce8d82151
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT:
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 1000 |  | 2227 |  | B |  |  |  | 300000 |  | inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 300000
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 1000 |  | 702227 |  | 610120 |  |  |  | 300000 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 0
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 0
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE