tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 90058d1289821718-dropping-lowest-grade-grades-per-possible-points-problem
Sheet: Grade_per_PossPoints_Only

RATs |  |  |  |  |  |  |  | Lab |  |  | ICQs |  |  | Hour Exam 1 |  | Hour Exam 2 |  | Final Exam
Grade | Possible Points |  | Grd/Pos Pts | # Sort Before (no ties) | Grds and PPs worst to best |  | Test | Grade | Possible Points |  | Grade | Possible Points |  | Grade | Possible Points | Grade | Possible Points | Grade | Possible Points
5 | 10 | RAT #1 | 0.5 | 0.001 | 5 | 10 | RAT #1 | 16 | 16 | Wk 2 Pre | 43 | 50 | ICQ #2 | 130 | 150 | 113 | 125
17 | 19 | RAT #2 | 0.8947368421052632 | 6.002 | 5 | 10 | RAT #3 | 7 | 9 | Wk 3 Pre | 42 | 50 | ICQ #3
5 | 10 | RAT #3 | 0.5 | 0.003 | 10 | 20 | RAT #12 | 16 | 17 | Wk 4 Pre | 46 | 50 | ICQ #4 |  | RATs | 0.1005586592178771
18 | 20 | RAT #4 | 0.9 | 7.004 | 10 | 20 | RAT #14 | 18 | 19 | Wk 6 Pre | 36 | 50 | ICQ #5 |  | ICQs | 0.1035428571428571
20 | 20 | RAT #5 | 1 | 11.005 | 12 | 20 | RAT #8 | 9 | 9 | Wk 8 Pre | 41 | 50 | ICQ #6 |  | Exam 1 | 0.2166666666666667
18 | 20 | RAT #6 | 0.9 | 7.006 | 7 | 10 | RAT #10 | 20 | 20 | Wk 9 Pre | 49 | 50 | ICQ #7 |  | Exam 2 | 0.226
20 | 20 | RAT #7 | 1 | 11.007 | 17 | 19 | RAT #2 |  |  |  | 45 | 50 | ICQ #8 |  | Particip | 0.01
12 | 20 | RAT #8 | 0.6 | 4.008 | 18 | 20 | RAT #4 |  |  |  |  |  | ICQ #10 |  | Lab | 0.1313868613138686 |  | Post-Lab | 0.8759124087591241
9 | 10 | RAT #9 | 0.9 | 7.009 | 18 | 20 | RAT #6 |  |  |  |  |  | ICQ #11 |  |  | 0.04777777777777778 |  | Pre-Lab | 0.9555555555555556
7 | 10 | RAT #10 | 0.7 | 5.01 | 9 | 10 | RAT #9 | 38 | 41 | Wk 2 Post |  |  | ICQ #12 |  |  | 0.015 |  | Oral | 1
9 | 10 | RAT #11 | 0.9 | 7.011 | 9 | 10 | RAT #11 | 18 | 22 | Wk 3 Post |  |  |  |  |  | 0.035 |  | Particip | 1
10 | 20 | RAT #12 | 0.5 | 0.012 | 20 | 20 | RAT #5 | 25 | 30 | Wk 4 Post |  |  |  |  | Weighted Total | 0.8859328221190473
10 | 10 | RAT #13 | 1 | 11.013 | 20 | 20 | RAT #7 | 25 | 30 | Wk 6 Post
10 | 20 | RAT #14 | 0.5 | 0.014 | 10 | 10 | RAT #13 | 14 | 14 | Wk 8 Post
 |  | RAT #15 |  |  |  |  |  |  |  | Wk 9 Post
 |  | RAT #16
 |  | RAT #17
 |  | RAT #18
 |  | RAT #19 |  |  |  |  |  | 1 | 1 | Oral Pres
150 | 179 |  |  |  |  |  |  | 1 | 1 | Particip
Spreadsheet: 72897d1273599817-lookup-or-index-formula-forum-example
Sheet: Sheet1

 |  | City |  |  |  |  |  |  |  | Effort | Last 5
 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  | CIN |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | PIT |  |  |  |  |  |  |  | HD | N | P | N | P | P
 |  | WAS |  |  |  |  |  |  |  | AD | P | P | P | N | P
 |  | NYM |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | FLA |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | CHC |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | HOU |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | STL |  |  |  |  |  |  |  | HF | P | P | N | P | P
 |  | ATL |  |  |  |  |  |  |  | AF | #N/A | #N/A | N | P | N
 |  | MIL |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | PHI |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | COL |  |  |  |  |  |  |  | HD | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | LAD |  |  |  |  |  |  |  | AD | #N/A | #N/A | N | N | N
 |  | ARI |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | SD |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | SF |  |  |  |  |  |  |  | HF | N | P | N | P | P
 |  | SEA |  |  |  |  |  |  |  | HF | P | N | N | N | N
 |  | BAL |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | NYY |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | DET |  |  |  |  |  |  |  | HD | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | TOR |  |  |  |  |  |  |  | AD | P | N | N | P | N
 |  | BOS |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | OAK |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | TEX |  |  |  |  |  |  |  | HF | N | P | N | N | N
 |  | CLE |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | KC |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | CHW |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | MIN |  |  |  |  |  |  |  | HF | P | P | N | P | P
 |  | TB |  |  |  |  |  |  |  | AF | #N/A | P | P | P | N
 |  | LAA |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 111479d1307855166-find-unique-values-and-string-concatenation-find-unique-values-and-string-concatenation
Sheet: Horizon

OrderKey
[PHONE]
[PHONE]
[PHONE] |  | Order Count
[PHONE] |  | Order No.
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
Spreadsheet: 111553d1307930324-excel-2007-how-can-i-auto-fill-numbers-going-upward-auto-fillupward
Sheet: Sheet1

-2 | -7
2
2 | 4
0 | 0
2 | 2
6 | 6
0
0 | 0
0 | 0
-1
0
2 | 1
-32 | -32
1
-1
1
1
2
1 | 5
4
-2 | 2
-2 | -2
2
10
1
-2 | 11
0 | 0
1
1
1
2
1
1 | 7
1 | 1
1 | 1
12 | 12
1
1
1 | 3
Spreadsheet: 06b04fca-d195-4f54-bf60-47850fb9b5d5
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | REQUEST FOR |  |  | Semester/Session
 |  |  |  |  |  |  | CHANGE IN PRINTED SCHEDULE |  |  | Year
 | Instructions: This form must be used to make any of the following changes in the printed Schedule of Classes:
 | * adding courses or creating new sections of courses
 | * changing days, hours, building, room number or instructor
 | * making changes neccessitated by actions of appropriate councils after schedule is printed
 | * dropping courses
This e-form must be emailed with complete information by the Assistant [NAME] to the appropriate [NAME];
if the [NAME] is out of the office, email this form to the Vice President, [NAME] (see link)
Changes Desired |  |  |  | From: |  |  |  |  | To:
Course Number | Course & Section | Course Title | Cr. Hrs. | Days | Hour | Campus | Bldg. & Room | Instructor | Days | Hour | Campus | Bldg. & Room | Instructor
 |  |  |  |  |  |  |  | Last Name |  |  |  |  | Last Name
Courses To Be Added |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to Send
Course Number | Course & Section | Course Title | Cr. Hrs. | Days | Hour | Campus | Bldg. & Room | Instructor | Capacity | Class
 |  |  |  |  |  |  |  | Last Name |  | Mode
Textbook Title |  |  | ISBN |  | Author |  | Edition |  |  |  |  | Enable  macros the first time you
 |  |  |  |  |  |  |  |  |  |  |  | send document by clicking "send" then
 |  |  |  |  |  |  |  |  |  |  |  | choose "options" and then "enable content"
Courses To Be Dropped |  |  |  |  |  |  |  |  |  |  |  | on the macro bar at the top of the document.
Course & Section | Course Title | Cr. Hrs. | Days | Hour | Campus | Bldg. & Room | Instructor
 |  |  |  |  |  |  | Last Name
Notes to approver:
Spreadsheet: 688046d1595539051-formatting-all-line-formatting
Sheet: Foglio1

1 | A | A | A | A | A | A | A | A | A | A | <<<<<
2 | A | A | A | A | A | A | A | A | A | A
3 | A | A | A | A | A | A | A | A | A | A
4 | A | A | A | A | A | A | A | A | A | A
5 | A | A | A | A | A | A | A | A | A | A
1 | A | A | A | A | A | A | A | A | A | A | <<<<<
2 | A | A | A | A | A | A | A | A | A | A
3 | A | A | A | A | A | A | A | A | A | A
4 | A | A | A | A | A | A | A | A | A | A
5 | A | A | A | A | A | A | A | A | A | A
1 | A | A | A | A | A | A | A | A | A | A
2 | A | A | A | A | A | A | A | A | A | A
3 | A | A | A | A | A | A | A | A | A | A
4 | A | A | A | A | A | A | A | A | A | A
5 | A | A | A | A | A | A | A | A | A | A
6 | A | A | A | A | A | A | A | A | A | A
1 | A | A | A | A | A | A | A | A | A | A
2 | A | A | A | A | A | A | A | A | A | A
3 | A | A | A | A | A | A | A | A | A | A
4 | A | A | A | A | A | A | A | A | A | A
5 | A | A | A | A | A | A | A | A | A | A
1 | A | A | A | A | A | A | A | A | A | A
2 | A | A | A | A | A | A | A | A | A | A
3 | A | A | A | A | A | A | A | A | A | A
4 | A | A | A | A | A | A | A | A | A | A
5 | A | A | A | A | A | A | A | A | A | A
1 | A | A | A | A | A | A | A | A | A | A
2 | A | A | A | A | A | A | A | A | A | A
3 | A | A | A | A | A | A | A | A | A | A
4 | A | A | A | A | A | A | A | A | A | A
5 | A | A | A | A | A | A | A | A | A | A
6 | A | A | A | A | A | A | A | A | A | A
Spreadsheet: faa0fd32-820b-4fa2-9d88-4fda1d0593e7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259062 | 71875 | [NAME] | Priest | RSA |  | 00:40:57 | 00:00:00 | 01:21:08 | 00:00:00 | 00:21:59 | 1 | 02:24:04
259062 | 71870 | Toni | Snoxell | RSA |  | 00:38:21 | 00:00:00 | 01:25:24 | 00:00:00 | 00:20:30 | 2 | 02:24:15
259062 | 71874 | Naomi | [NAME] | RSA |  | 00:39:11 | 00:00:00 | 01:25:58 | 00:00:00 | 00:21:18 | 3 | 02:26:27
259062 | 71873 | Esmari | Goosen | RSA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 02:28:33
259062 | 71872 | Dane | Phaal | RSA |  | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 162907d1340117075-stucking-on-lookup-inside-index-index-and-lookup
Sheet: Sheet1

Norm |  |  |  |  | No. | Product | Level | Index function | Offset function | Vlookup function
Product | Level 1 | Level 2 | Level 3 |  | 1 | Chair | 1
Chair | 500000 | 1000000 | 1500000 |  | 2 | Table | 1
Table | 250000 | 630000 | 890000 |  | 3 | Chair | 3
Wardrobe | 300000 | 380000 | 900000 |  | 4 | Wardrobe | 2
 |  |  |  |  | 5 | Table | 1
 |  |  |  |  | 6 | Chair | 2
 |  |  |  |  | 7 | Wardrobe | 3
 |  |  |  |  | 8 | Table | 2
 |  |  |  |  | 9 | Wardrobe | 1
 |  |  |  |  | 10 | Table | 3
Spreadsheet: 91986d1291667577-defining-a-column-for-use-in-another-sheet-2011-office-driver-call-sheet-input-practice
Sheet: input

 | DRIVER | # men | PL/SH/SA/SK | Time In | Time Out | Total | # men | PL/SH/SA/SK | Time In | Time Out | Total | # men | PL/SH/SA/SK | Time In | Time Out | Total | ICE MELT | SAND | RAPID THAW
lot 1 | CHUCK | 4 | PL | 2010-12-06 11:00:00 | 2010-12-06 11:15:00 | 1 |  |  |  |  | 0 |  |  |  |  | 0
lot 1 | [NAME] | 1 | SH | 2010-12-06 00:00:00 | 2010-12-06 00:30:00 | 0.5 |  |  |  |  | 0 |  |  |  |  | 0 | 50
lot 2 | JERRY | 12 | SH | 2010-12-06 00:00:00 | 2010-12-06 00:30:00 | 6 |  |  |  |  | 0 |  |  |  |  | 0
lot 2 | JERRY | 1 | PL | 2010-12-06 00:30:00 | 2010-12-06 01:00:00 | 0.5 |  |  |  |  | 0 |  |  |  |  | 0 | 25
lot 3 | PAUL | 4 | SH | 2010-12-06 01:00:00 | 2010-12-06 01:40:00 | 2.666666666666667 |  |  |  |  | 0 |  |  |  |  | 0 | 75
lot 3 | [NAME] | 1 | SA | 2010-12-06 01:45:00 | 2010-12-06 01:55:00 | 0.1666666666666667 |  |  |  |  | 0 |  |  |  |  | 0 |  | 2
Spreadsheet: 882503d1730895482-value-to-display-based-on-multiple-conditions-value-to-display-upon-multiple-conditions
Sheet: Sheet1

Project No | Buliding No | Phase No | PC Mark. | Part Mark | Parent Part [NAME] | Total Weight | Qty. | Thickness | Width-1 | Width-2 | Length-1 | Length-2 | Item | SS / DS | Plate
AB-07133 | A1 | 2 | F193 | TB105 | AB-07133A1710881 | 171.208 | 2 | 8 | 180 | 180 | 7461 |  | F | Y
AB-07133 | A1 | 2 | W152 | TB105 | AB-07133A1710881 | 89.171 | 1 | 5 | 300 | 300 | 7461 |  | W | Y | 2000
AB-07133 | A1 | 2 | F44 | C504 | AB-07133A1751961 | 549.52 | 1 | 20 | 370 | 370 | 9320 |  | F | Y
AB-07133 | A1 | 2 | F160 | C504 | AB-07133A1751961 | 549.52 | 1 | 20 | 370 | 370 | 9320 |  | F | Y
AB-07133 | A1 | 2 | [NAME] | C504 | AB-07133A1751961 | 1292.114 | 1 | 12 | 1450 | 1450 | 9320 |  | W | Y
AB-07133 | A1 | 2 | SP94 | C504 | AB-07133A1751961 | 141.153 | 1 | 28 | 370 | 370 | 1710 |  | SP | Y
If no End / Splice / Base Plate given, manual weld to be defaulted as 2000 mm either for Flange or Web
Col. A indicates a job and Col.B and C are Building and Phase (i.e. sub categories).  Each job will have several Part Marks (Col.E)
Parent Part Mark (Col.E) is the one component with some Child Parts attached to it
One component consists of "F"s, "W"s and one or more "ST","SP","P", etc. (See Col.N)
Requirement:
value to display in Col.P is 2000
Condition:
If Col.N does not contains alphabet "P" (SP/BP/P) for a Part Mark (Col.E), in a Job,Bld.,Ph. combination (Col.A,B&C) and
Col. N is "W"
(Ex: for TB105, SP/BP/P is not appearing in Col.N for Job No.AB-07133 Building A1 Ph.2.  So 2000 to be displayed in Cell:P4)
Spreadsheet: 71523d1272299806-vlookup-across-multiple-tabs-sample
Sheet: Sheet7

RISK RATING | Date Opened | [NAME] | Branch # | Acct #1 | Acct #2 | Acct #3 | Acct #4 | Acct #5
MEDIUM | 1999-01-01 00:00:00 | [NAME] | 1
MEDIUM | 2000-05-25 00:00:00 | [NAME] | 2
RISK RATING | Date Opened | [NAME] | Branch # | Acct #1 | Acct #2 | Acct #3 | Acct #4 | Acct #5
RISK RATING | Date Opened | [NAME] | Branch # | Acct #1 | Acct #2 | Acct #3 | Acct #4 | Acct #5
RISK RATING | Date Opened | [NAME] | Branch # | Acct #1 | Acct #2 | Acct #3 | Acct #4 | Acct #5
Spreadsheet: 218539d1362495369-conditional-formatting-for-overdue-and-due-soon-plus-totalling-these-excelforum1
Sheet: Sheet1

Team Report
Staff Member | Data 1 | Data 2 | Data3 | Plan of Action to be up to date with training
Staff Member | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
Staff Member | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00
Staff Member | 2012-03-06 00:00:00 | 2012-03-06 00:00:00 | 2012-03-01 00:00:00
Staff Member | 2012-03-05 00:00:00 | 2012-03-05 00:00:00 | 2012-04-01 00:00:00
Staff Member | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-01 00:00:00
Staff Member | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00
Staff Member | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00
Staff Member | 2012-08-01 00:00:00 | 2012-08-01 00:00:00 | 2012-08-01 00:00:00
Staff Member | 2012-09-01 00:00:00 | 2012-09-01 00:00:00 | 2012-09-01 00:00:00
Staff Member | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00
Staff Member | 2012-11-01 00:00:00 | 2012-11-01 00:00:00 | 2012-11-01 00:00:00
Staff Member | 2012-12-01 00:00:00 | 2012-12-01 00:00:00 | 2012-12-01 00:00:00
Staff Member | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00
Staff Member | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-02-01 00:00:00
Staff Member | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 | 2013-03-01 00:00:00
Staff Numbers
Overdue
Due Soon
Compliant
Spreadsheet: 689935d1596754337-grid-to-list-formula-order-example
Sheet: EXAMPLE

 | [NAME] |  |  |  |  |  |  | FORMULA OUTPUT
SKU | 2020-08-10 00:00:00 | 2020-09-10 00:00:00 | 2020-10-10 00:00:00 | 2020-11-10 00:00:00 | 2020-12-10 00:00:00 |  |  | SKU | QTY | DATE |  | SKU | QTY | DATE
AB | 1 | 2 | 3 | 4 | 5 |  |  | AB | 1 | 2020-08-10 00:00:00
ABC | 6 | 7 | 8 | 9 | 10 |  |  | AB | 2 | 2020-09-10 00:00:00
ABCD | 2 | 3 | 4 | 5 | 6 |  |  | AB | 3 | 2020-10-10 00:00:00
ABCDE | 7 | 8 | 9 | 10 | 11 |  |  | AB | 4 | 2020-11-10 00:00:00
ABCDEF | 3 | 4 | 5 | 6 | 7 |  |  | AB | 5 | 2020-12-10 00:00:00
ABCDEFG |  |  |  |  |  |  |  | ABC | 6 | 2020-08-10 00:00:00
ABCEDFGH |  |  |  |  |  |  |  | ABC | 7 | 2020-09-10 00:00:00
ABCDEFGHI |  |  |  |  |  |  |  | ABC | 8 | 2020-10-10 00:00:00
ABCDEFGHIJ |  |  |  |  |  |  |  | ABC | 9 | 2020-11-10 00:00:00
ABCDEFGHIJK |  |  |  |  |  |  |  | ABC | 10 | 2020-12-10 00:00:00
ABCDEFGHIJKL
Spreadsheet: 92838d1292367666-dice-simulation-game-question-dobbelsteen-simulation-game-vraag
Sheet: Sheet1

Question 6
Make an simulation game in excel throwing 100 times with a dice. Use if and random functions to create this program
How many times appear each outcome of the dice? What is the simulation probability of each outcome?
What is the expected value of the dice according to this simulation?
Result |  | Outcome | How many times appear each outcome
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | Total
 |  | Expected Value
Spreadsheet: larry_campbell__20963__Flagstaff1
Sheet: Turbine

[NAME]
RED ROCK EXPANSION PROJECT
FLAGSTAFF COMPRESSOR STATION
Table 1
TURBINE INFORMATION
Manufacturer: | GE LM2500
Fuel Type: | Sweet Natural Gas
HHV: | 1050 | Btu/scf
Site Elevation: | 7458
Inlet Loss: | 4 | in H2O
Exhaust Loss: | 4 | in H2O
Shaft Power: | 37270 | hp @ 12.8oF (Base Load)
 | 30565 | hp @ 60oF (Base Load)
[NAME]: | 9451 | Btu/hp-hr @95oF (50% Load)
 |  | [NAME]/hr | ([NAME] x shp@12.8oF)
[NAME]: | 6308 | Btu/hp-hr @60oF (Base Load)
 |  | [NAME]/hr | ([NAME] x shp@60oF)
Speed: | 6100 | rpm
[NAME]: |  | [NAME]/hr | ([NAME])
[NAME]: |  | [NAME]/hr | (Avg Heat Rate / HHV)
Annual Fuel: |  | [NAME]/yr | ([NAME])
Potential Emissions
Temp | Turbine | NOx (as NO2) |  | CO |  | THC
(oF) | Load (%) | (lb/hr) | (tpy) | (lb/hr) | (tpy) | (lb/hr) | (tpy)
0 | Base | 22.4 |  | 13.6 |  | 4.6
0 | 64 | 25.3 |  | 15.4 |  | 5.4
0 | 50 | 23 |  | 14 |  | 4.9
12.8 | Base | 22.7 |  | 13.8 |  | 4.7
12.8 | 50 | 22.6 |  | 13.7 |  | 4.8
40 | Base | 20.8 |  | 12.6 |  | 4.3
40 | 50 | 20.5 |  | 12.5 |  | 4.4
60 | Base | 19.4 |  | 11.8 |  | 4
60 | 50 | 13.2 |  | 8.1 |  | 2.7
95 | Base | 16.9 |  | 10.3 |  | 3.5
95 | 50 | 11.9 |  | 7.3 |  | 2.5
 | [NAME]
 | Base [NAME]
[NAME] (04/00)
PM | 0.0066 | lb/MMBtu
SO2 | 0.0034 | lb/MMBtu
Formaldehyde | 0.00071 | lb/MMBtu
Proposed Turbine Emissions
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX |  |  | @base load 80% of time, 64% load 20% of time
CO |  |  | @base load 80% of time, 64% load 20% of time
VOC |  |  | @base load 80% of time, 64% load 20% of time; assume 10% NMHC
PM |  |  | @max hourly based on [NAME] heat rate, annuals based on avg heat rate
SO2 |  |  | @max hourly based on [NAME] heat rate, annuals based on avg heat rate
Formaldehyde |  |  | @max hourly based on [NAME] heat rate, annuals based on avg heat rate
Proposed Turbine Emissions Plus 15% Safety Factor
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX
CO
VOC
PM
SO2
Formaldehyde
Spreadsheet: tracy_geaccone__40323__3rd quarter curr est
Sheet: Prepay_Exp

PRMA Prepays & Related Expenses
($ Millions)
 |  | Dec 00 |  | Jan 01 |  | Feb 01 |  | March 01 |  | April 01 |  | May 01 |  | June 01 |  | July 01 |  | Aug 01 |  | Sept 01 |  | Oct 01 |  | Nov 01 |  | Dec 01 |  | 2001 FY
COMMODITY PREPAYMENTS (Balance)
 | x | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | x | 0 |  | 0
 | x |  |  | 0
 | x |  |  | 0
 | x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Balance
Carrying Expense reflected in Gross Margin
 | x |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | x |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | x |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | x |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | x |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Expense
Spreadsheet: 797673d1664038843-sort-sum-and-count-in-one-function-sample
Sheet: Calculation

Control owner | Control name | Risk | Sum of risk |  | Controls in red above 40 |  |  |  |  |  |  |  | Summary table
Owner 1 | Control1 | 10
 | Control2 | 18 |  |  |  |  |  |  |  |  |  |  | Team name | Sum of risk | Controls > 40
 | Control3 | 20 |  |  |  |  |  |  |  |  |  |  | T3 |  | result should be 5
Owner 2 | Control4 | 45 |  |  |  |  |  |  |  |  |  |  | T1 |  | result should be 4
 |  |  |  |  |  |  |  |  |  |  |  |  | T2 |  | result should be 1
Spreadsheet: 117107d1312455101-matching-data-form-multiple-columns-multiple-match
Sheet: Sheet1

Model | Capacity | Fuel | Conversion
RXA | 10 | Husk | 15
SGI | 15 | Coal | 12
HPBB | 20 | Wood | 11
IFB | 10 | Coal | 10.5
CPD | 15 | LDO | 14.5
CPFD | 30 | HSD | 13
SMDH | 40 | FO | 16
TPD | 20 | Gas | 18
VTB | 20 | Briquette | 11
CPD | 15 | LDO
Spreadsheet: hunter_shively__12662__Nov_01 Volume Changes
Sheet: Nov 10-12

Pipeline | Producer | Deal | Zone | Current Volume | New Volume | Change | Index | GDA | Fixed
ANR | Ralaco | 969536 | Gath | 2840 | 2330 |  | -120 | -390
ANR | Panaco | 1135527 | Off | 1099 | 917 |  |  | -182
CGLF | Forest | 1109818 | [NAME] | 2256 | 576 |  | -1680
[NAME] | Forest | 1131239 | Zone 2 | 280 | 235 |  |  | -45
NGPL | KCS | 1143959 | Midcon | 2348 | 2649 |  |  | 301
SNAT | Stone | 1054822 | Uncnstrnd WH | 4032 | 4332 |  | 300
STRY | MMS | 1103008 | RCPTS | 66342 | 64892 |  |  | -1450
TENN | Shoreline | 1129078 | Zone 0 | 761 | 385 |  |  | -376
TENN | Pioneer | 1135749 | Zone 500 | 1731 | 1223 |  |  | -508
TENN | Cabot | 1138914 | Zone 500 | 16000 | 14800 |  | -1200
TENN | Torch | 1059789 | Zone 800 | 809 | 660 |  |  | -149
TENN | Westport | 1143232 | Zone 800 | 8000 | 10000 |  |  | 2000
TENN | [NAME] | 1132292 | Zone 800 | 11000 | 10000 |  |  | -1000
TGT | Unimark | 1146397 | ELA | 4267 | 1570 |  |  | -2697
TRCO | Torch | 1059003 | Zone 2 | 11 | 2 |  |  | -9
TRCO | Torch | 1085947 | Zone 2 | 62 | 500 |  |  | 438
TRCO | Torch | 1059107 | Zone 2 | 536 | 863 |  |  | 327
TRCO | Tristar | 1139955 | Zone 3 | 848 | 728 |  |  | -120
TRKL | Torch | 1058639 | ELA | 137 | 104 |  |  | -33
TRKL | Forest | 1109804 | ELA | 22250 | 21075 |  |  | -1175
TRKl | Forest | 1127986 | ELA | 2300 | 2500 |  |  | 200
 |  |  |  |  |  | Daily Total
 |  |  |  |  |  | MTD Total | -43614 | -2592 | 282
Spreadsheet: 843881d1695710901-create-a-dependent-drop-down-for-3-levels-dropdown
Sheet: HelperSheet

Description
 |  | 1
 | OFFICE
1st drop down | Offset start (dept.)
2nd drop down
 | DEPARTMENT
 | Offset start (staff)
3rd drop down
Spreadsheet: da6169dc-ae15-438c-8214-858ffbdbd186
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
FHALG | Test | FHALG | Halibut IgG | Halibut IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FHALG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FHALG | Result | FHALG | Halibut IgG | Halibut IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process