tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1f8ec0ae-bdc3-43dd-8e11-740dc0486433
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Science, Technology, Engineering and Mathematics: Engineering and Technology
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Engineering and Technology Pathway of the Science, Technology, Engineering and Mathematics Career Cluster) can serve as a guide, along with other career
planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals.
*This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Engineering and Technology Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Aeronautical Engineer ►Aerospace Engineer ►Agricultural Engineer ►Agricultural Technician ►Application Engineer ►Architectural Engineer ►Automotive Engineer ►Biomedical Engineer ►Biotechnology Engineer ►CAD Technician ►Chemical Engineer ►Civil Engineer ►Communications Engineer ►Computer Engineer ►Computer Programmer ►Construction Engineer ►Electrical Engineer ►Electronics Technician ►Geothermal Engineer ►Industrial Engineer ►Manufacturing Engineer ►Manufacturing Technician ►Marine Engineer ►Mechanical Engineer ►Metallurgist ►Mining Engineer ►Nuclear Engineer ►Petroleum Engineer ►Product/Process Engineer ►Survey Technician ►Systems Engineer ►Transportation Engineer
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 215382d1361365068-excel-formula-required-to-sum-values-that-fit-within-a-certain-criteria-195-excel-formula-required
Sheet: Sheet1

 | DATE | NAME | NUMBER |  |  | GRAND TOTAL
 | 2013-02-01 00:00:00 | Orange | 1 |  |  | Apple
 | 2013-02-01 00:00:00 | Apple | 1 |  |  | Orange
 | 2013-02-15 00:00:00 | Orange | 1 |  |  | Pear
 | 2013-02-18 00:00:00 | Apple | 1
 | 2013-02-20 00:00:00 | Orange | 1 |  |  | TOTAL IN FEB
 | 2013-02-27 00:00:00 | Pear | 1 |  |  | Apple
 | 2013-02-28 00:00:00 | Apple | 1 |  |  | Orange
 | 2013-03-05 00:00:00 | Orange | 1 |  |  | Pear
 | 2013-03-10 00:00:00 | Apple | 1
 | 2013-03-15 00:00:00 | Pear | 1 |  |  | TOTAL IN MAR
 | 2013-04-01 00:00:00 | Orange | 1 |  |  | Apple
 |  |  |  |  |  | Orange
 |  |  |  |  |  | Pear
 |  |  |  |  |  | TOTAL IN MAY
 |  |  |  |  |  | Apple
 |  |  |  |  |  | Orange
 |  |  |  |  |  | Pear
Spreadsheet: 805413d1668673051-excel-compare-data-and-rank-in-order-book1_upd-1-
Sheet: Consolidated

 | Value | Manager |  |  |  |  |  |  |  |  |  | Manager 1 |  |  |  |  |  |  |  |  |  | Manager 1
No of cases handled (highest) |  |  |  |  |  |  |  |  |  |  |  | Manager 2 |  |  |  |  |  |  |  |  |  | Manager 2
No of case reviewed (highest) |  |  |  |  |  |  |  |  |  |  |  | Manager 3 |  |  |  |  |  |  |  |  |  | Manager 3
Late cases (lowest)
HIPAA Errors (lowest)
No of cases handled |  | 57
 | Manager 2 | 25
 | Manager 1 | 15
No of case reviewed |  | 150
 | Manager 3 | 124
 | Manager 1 | 100
Late cases |  | 13
 | Manager 2 | 15
 | Manager 1 | 34
HIPAA Errors |  | 8
 | Manager 2 | 16
 | Manager 1 | 56
Spreadsheet: 673624d1587470803-simple-match-mismatch-formula-example
Sheet: Sheet1

Code | Sub Code | Ref Code 1 | Ref Code 2 | Ref Code 3 | Match/Mismatch
91460422 | 91460422 | 91460422 |  |  | MATCH |  |  | Codes in Columns A&B need to be compared to reference codes in Columns C through E. If there's a code in either Column A or Column B that is not in Columns C through E, then Column F outputs "MISMATCH". If codes in Column A & B match codes in Columns C through E, then Column F outputs "Match".   NOTE: Columns C through E could have extra codes that are not present in Columns A & B, but as long as the codes in A & B match the 2 out of 3 codes in Columns C through E, the  output should be "MATCH".
91732065 | 91500662 | 91732065 | 91500662 |  | MATCH
91460422 | 90613878 | 91460422 |  |  | MISMATCH
91732065 | 91539707 | 91732065 | 91460422 | 91500662 | MISMATCH
91460422 |  | 91460422 |  |  | MATCH
91732065 | 91539707 | 91732065 | 91539707 | 91500662 | MATCH
Spreadsheet: 191317d1352063363-remove-spaces-special-characters-after-numbers-testbook
Sheet: Sheet1

 | Month 1 | Month 2 | Month 3 | Quarter
2001 2nd Qtr |  | 0.4 | -3.24
2001 3rd Qtr | -2.06 | 0.16 | -14.43 | -16.06
2001 4th Qtr | 1.9 | 8.9 | 2.66 | 13.92
2002 1st Qtr | -2.66 | 1.51 | 9.01 | 7.71
2002 2nd Qtr | 0.4 | 3.31 | -8.46 | -5.05
2002 3rd Qtr | -9.77 | 0.12 | -14.51 | -22.77
2002 4th Qtr | 4.95 | 8.19 | -3.12 | 10
Spreadsheet: 837996d1690579018-reverse-engineer-an-if-statement-help
Sheet: Help

Parent | Child |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Center | 1
Center | [NAME]
[NAME] | PCON
[NAME] | PNONCON
PCON | PC-ADJ
PCON | PC-CORP
PCON | PC-HCI
PCON | PC-HSS
PCON | PC-RET
PNONCON | PC-BLS
PNONCON | PC-CHARITY
PNONCON | PC-FOUNDATION
PNONCON | PC-NEJE
Spreadsheet: 843012d1694990434-calculate-the-duration-duration-of-ticket
Sheet: Sheet1

start | end | duration
2023-09-15 09:00:00 | 2023-09-15 12:00:00 | 3 hours
2023-09-15 09:00:00 | 2023-09-18 12:00:00 | 1 day 3 hours
2023-09-15 09:00:00 | 2023-09-19 16:30:00 | 2 days 7 hours 30 Mins
2023-09-14 09:00:00 | 2023-09-15 10:00:00 | 1 day 1 hour
2023-09-14 09:00:00 | 2023-09-15 09:01:00
2023-08-22 16:25:00 | 2023-08-24 12:25:00
2023-08-22 00:00:00 | Tuesday | 16:25:00 | 1 day and 20 hours
2023-08-23 00:00:00 | Wednesday | 16:25:00
2023-08-24 00:00:00 | Thursday | 12:25:00
2023-09-15 00:00:00 | Friday
2023-09-16 00:00:00 | Saturday
2023-09-17 00:00:00 | Sunday
2023-09-18 00:00:00 | Monday
2023-09-19 00:00:00 | Tuesday
2023-09-20 00:00:00 | Wednesday
2023-09-21 00:00:00 | Thursday
Spreadsheet: 870224d1716780985-how-to-convert-table-with-relative-position-number-to-header-of-reference-table-stock-comparison-29-ans
Sheet: Sheet1

 | 13e | 02e | -11? | -20e |  | -4-2a | -6-41a | 013e | -2-1a |  |  | -1???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 4 | 6 | 6 | 8
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 1 | 4 | 6 | 6 | 10 | 10 | 13
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 2 | 5 | 7 | 6 | 10 | 10 | 14
 | 0 | 0 | 1 | 0 | 4 | 0 | 1 | 2 | 3 | 7 | 8 | 9 | 13 | 13 | 17
 | 0 | 0 | 3 | 0 | 5 | 1 | 4 | 2 | 8 | 10 | 12 | 11 | 17 | 15 | 22
ref table
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 1 | 4 | 6 | 5 | 5
all | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 1 | 4 | 6 | 5 | 5
[NAME]) | 1 | 0 | 1 | 0 | 2 | 3 | 1 | 1 | 1 | 4 | 2 | 5 | 9 | 7 | 8
all(s/fexp) | 1 | 0 | 1 | 0 | 2 | 3 | 1 | 1 | 1 | 6 | 2 | 5 | 9 | 7 | 10
all(s/fexp) | 1 | 0 | 1 | 0 | 2 | 3 | 2 | 1 | 2 | 6 | 2 | 5 | 11 | 7 | 13
all(s/fexp) | 1 | 0 | 1 | 0 | 2 | 3 | 3 | 2 | 2 | 8 | 4 | 8 | 14 | 10 | 16
 | 1 | 0 | 1 | 0 | 2 | 3 | 3 | 2 | 2 | 8 | 4 | 8 | 14 | 10 | 16
 |  |  | convert table row 6 to below
FORMULA |  | t2t4e | t2t4? | t2t4e |  | t2t4a | 1 extt3t8a | t8t9t11e | t7t8a |  |  | -1???
 | t2t4e | t2t4e | t2t4? | t2t4e |  | t2t4a | 1extt3t8a | t8t9t11e | t6t8a |  |  | -1???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 4 | 6 | 6 | 8
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 1 | 4 | 6 | 6 | 10 | 10 | 13
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 2 | 5 | 7 | 6 | 10 | 10 | 14
 | 0 | 0 | 1 | 0 | 4 | 0 | 1 | 2 | 3 | 7 | 8 | 9 | 13 | 13 | 17
 | 0 | 0 | 3 | 0 | 5 | 1 | 4 | 2 | 8 | 10 | 12 | 11 | 17 | 15 | 22
Spreadsheet: 93640d1293297522-last-data-range-cell-update-example
Sheet: Sheet1

45 | 2 |  |  |  |  |  | group "2" | group "5"
67 | 2 |  |  |  |  |  | 45 | 87
87 | 5 |  |  |  |  |  | 67 | 43
43 | 5 |  |  |  |  |  | 124 | 98
98 | 5 |  |  |  |  |  | 879 | 453
124 | 2 |  |  |  |  |  | 908 | 236
453 | 5
879 | 2
908 | 2
236 | 5
Spreadsheet: 585097d1533629147-dynamic-change-in-the-y-axis-problem-new-one
Sheet: Sheet2

 |  |  | Data 1 | Data 2 | Metric 1 | Metric 2 |  |  |  |  |  |  |  |  | Data 1 | Data 2 | Metric 1 | Metric 2 |  |  |  |  | Data 1 | Data 2 | Metric 1 | Metric 2 |  |  |  |  | Data 1 | Data 2 | Metric 1 | Metric 2 |  |  |  |  | Data 1 | Data 2 | Metric 1 | Metric 2 |  |  |  |  | Data 1 | Data 2 | Metric 1 | Metric 2 |  |  |  |  | Data 1 | Data 2 | Metric 1 | Metric 2
 |  | Data field | PE Ratio | EV / EBITDA | Median | Average |  |  |  |  |  |  |  | Data field | EV / EBITDA | EV / EBITDA | Median | Median |  |  |  | Data field | EBITDA |  | Median | Median |  |  |  | Data field | EBITDA |  | Median | Median |  |  |  | Data field | EBITDA |  | Median | Median |  |  |  | Data field | EBITDA |  | Median | Median |  |  |  | Data field | EBITDA |  | Median | Median
 |  | Year | 18bc | 18bc |  |  |  |  |  |  |  |  |  | Year | 18bc | 19bc |  |  |  |  |  | Year | 18bc |  |  |  |  |  |  | Year | 18bc |  |  |  |  |  |  | Year | 18bc |  |  |  |  |  |  | Year | 18bc |  |  |  |  |  |  | Year | 18bc
1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
Spreadsheet: 689788d1596652452-error-with-formula-need-help-finding-the-error-in-my-formula-gross-margin-scenarios
Sheet: Sheet2

GM% | Price Factor
0.1 |  |  |  | Budgeted Cost | 1000
0.11 |  |  |  | Gross Margin % | 0.35
0.12 |  |  |  | Incremental Gross Margin | 0.03
0.13 |  |  |  | GM %
0.14 |  |  |  | SALES
0.15 |  |  |  | BUDGETED COST
0.16 |  |  |  | GROSS MARGIN $
0.17 |  |  |  | ADDITIONAL COST:
0.18
0.19
0.2
0.21
0.22
0.23
0.24 |  |  |  | TOTAL
0.25 |  |  |  | ACTUAL TOTAL COST
0.26 |  |  |  | ADJUSTED GROSS MARGIN
0.27 |  |  |  | GROSS MARGIN %
0.28
0.29
0.3
0.31
0.32
0.33
0.34
0.35
0.36
0.37
0.38
0.39
0.4
0.41
0.42
0.43
0.44
0.45
0.46
0.47
0.48
0.49
0.5
0.51
0.52
0.53
0.54
0.55
Spreadsheet: 136241d1326487339-using-a-formula-to-find-a-total-from-three-rows-copy_test2
Sheet: Sheet1

Code | EmpID | Fname | Mname | Lname | Dept | [NAME]
1 | 22094 | Mark |  | [NAME] | AUI | 64 |  |  | EmpID | 1 | 4 | 7 | Total
4 | 22094 | Mark |  | [NAME] | AUI | 8
7 | 22094 | Mark |  | [NAME] | AUI | 8
1 | 22244 | [NAME] | C | [NAME] | AUI | 66.67
4 | 22244 | [NAME] | C | [NAME] | AUI | 8
7 | 22244 | [NAME] | C | [NAME] | AUI | 8
1 | 22909 | [NAME] |  | Smith | ISG | 63.12
4 | 22909 | [NAME] |  | Smith | ISG | 16
7 | 22909 | [NAME] |  | Smith | ISG | 8
1 | 24721 | Anne |  | Heath | AIC | 51.25
4 | 24721 | Anne |  | Heath | AIC | 24
7 | 24721 | Anne |  | Heath | AIC | 8
1 | 24749 | Mark |  | Palmer | ISG | 72.78
4 | 24749 | Mark |  | Palmer | ISG | 8
7 | 24749 | Mark |  | Palmer | ISG | 8
1 | 28189 | [NAME] |  | [NAME] | AUI | 78
7 | 28189 | [NAME] |  | [NAME] | AUI | 8
1 | 47744 | Kathy |  | Bailey | AIC | 81
7 | 47744 | Kathy |  | Bailey | AIC | 8
1 | 48071 | Penny |  | Childress | AUI | 69.25
4 | 48071 | Penny |  | Childress | AUI | 8
7 | 48071 | Penny |  | Childress | AUI | 8
1 | 49667 | [NAME] |  | Camp | Jr | USA   72.6
7 | 49667 | [NAME] |  | Camp | Jr | USA  8
1 | 62976 | Scott |  | Moody | AUI | 68.02
4 | 62976 | Scott |  | Moody | AUI | 4.07
7 | 62976 | Scott |  | Moody | AUI | 8
1 | 66289 | Scott | N | [NAME] | AIC | 72
7 | 66289 | Scott | N | [NAME] | AIC | 8
1 | 66376 | Peggy |  | Ford | ISG | 43.7
4 | 66376 | Peggy |  | Ford | ISG | 33.72
7 | 66376 | Peggy |  | Ford | ISG | 8
1 | 80459 | Becki |  | Gardner | MIG SC | 71.13
4 | 80459 | Becki |  | Gardner | MIG SC | 8
7 | 80459 | Becki |  | Gardner | MIG SC | 8
1 | 85330 | Sandra | H | Major | AUI | 73.38
7 | 85330 | Sandra | H | Major | AUI | 8
1 | 118071 | [NAME] | [NAME] | Morrison | ITP | 61.77
4 | 118071 | [NAME] | [NAME] | Morrison | ITP | 16
7 | 118071 | [NAME] | [NAME] | Morrison | ITP | 8
1 | 132861 | [NAME] |  | Byrd | AUI | 53.97
4 | 132861 | [NAME] |  | Byrd | AUI | 24
7 | 132861 | [NAME] |  | Byrd | AUI | 8
1 | 133126 | [NAME] | D | Compton | ISG | 69.58
4 | 133126 | [NAME] | D | Compton | ISG | 11.68
7 | 133126 | [NAME] | D | Compton | ISG | 8
1 | 137752 | [NAME] |  | Neel | AUI | 80.88
7 | 137752 | [NAME] |  | Neel | AUI | 8
1 | 138422 | [NAME] | B | Crownover | AUI | 39.57
4 | 138422 | [NAME] | B | Crownover | AUI | 32
7 | 138422 | [NAME] | B | Crownover | AUI | 8
1 | 150264 | Joel | C | Ammons | ISG | 81
7 | 150264 | Joel | C | Ammons | ISG | 8
1 | 155841 | [NAME] |  | Parraga | AIC | 75.83
7 | 155841 | [NAME] |  | Parraga | AIC | 8
1 | 157510 | Fred |  | [NAME] | AUI | 87.07
4 | 157510 | Fred |  | [NAME] | AUI | 3.5
7 | 157510 | Fred |  | [NAME] | AUI | 8
1 | 165945 | [NAME] |  | [NAME] | AIC | 63
4 | 165945 | [NAME] |  | [NAME] | AIC | 16
7 | 165945 | [NAME] |  | [NAME] | AIC | 8
1 | 170775 | Yolanda |  | Smith | USA | 64
4 | 170775 | Yolanda |  | Smith | USA | 8
7 | 170775 | Yolanda |  | Smith | USA | 8
1 | 174142 | Rex | A | Lynch | MRA | 74.48
7 | 174142 | Rex | A | Lynch | MRA | 8
1 | 178972 | [NAME] | K | Seagroves | USA | 82.03
7 | 178972 | [NAME] | K | Seagroves | USA | 8
Spreadsheet: 481499d1474486569-fastest-way-to-put-data-into-the-graph-book1
Sheet: AllSolventsComparisGraphLines-2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
Spreadsheet: 02c6f315-a74c-42ec-9a1c-5e9d8ead0837
Sheet: Sheet1

University of Idaho | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Access Authorization List | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Records Management Office
Student Union Building, Room 53
Moscow, Idaho 83844-4247
Phone (208) 885-2580
Department Name: |  |  |  |  |  |  |  |  |  |  |  | No Abbreviations
The department named above acknowledges the following conditions for access to its records held in storage at the University of Idaho Records Center
1. | All requests for access are verified by Records Center staff with the names and signatures below using the Vandal Card or Drivers License to verify.
2. | Requests for access by individuals not on this list will be referred to the department for access.
3. | The department is responsible for maintaining an up-to-date Access Authorization List.  If personnel need to be added to or deleted from the list, the department head may either request a new form or see [NAME] staff to amend the list.
The following employees, are authorized to access all the departmental records held at the University of Idaho Records Center:
Name: |  |  |  |  |  | Title: | Department Chair/Head |  |  |  | Effective:
Phone: |  |  |  |  | E-mail: |  |  |  |  |  | End:
V-Number |  |  |  |  |  | Signature:
Name: |  |  |  |  |  | Title: | Appointed Records Coordinator |  |  |  | Effective:
Phone: |  |  |  |  | E-mail: |  |  |  |  |  | End:
V-Number |  |  |  |  |  | Signature:
Name: |  |  |  |  |  | Title: |  |  |  |  | Effective:
Phone: |  |  |  |  | E-mail: |  |  |  |  |  | End:
V-Number |  |  |  |  |  | Signature:
Name: |  |  |  |  |  | Title: |  |  |  |  | Effective:
Phone: |  |  |  |  | E-mail: |  |  |  |  |  | End:
V-Number |  |  |  |  |  | Signature:
Name: |  |  |  |  |  | Title: |  |  |  |  | Effective:
Phone: |  |  |  |  | E-mail: |  |  |  |  |  | End:
V-Number |  |  |  |  |  | Signature:
Spreadsheet: 703777d1605172801-formula-required-for-return-a-section-wise-different-objects-number-of-quantities-formula-required-for-return-a-section-wise-different-objects-number-of-quantities
Sheet: Sheet

Section-1
Lot Name | Timber | Plywood | Lights | Table | Blocks |  |  |  | Return a Quantities section wise
ABC | 71 | 53 | 89 | 63 | 44 |  |  |  |  | Section-1 |  | Section-2 |  | Section-3
BJH | 88 | 45 | 55 | 70 | 56 |  |  |  |  | Timber | Table | Timber | Blocks | Plywood | Lights
POL | 44 | 28 | 54 | 37 | 93 |  |  |  | POL
ASH | 97 | 70 | 73 | 41 | 40 |  |  |  |  | Plywood | Lights | Blocks | Plywood | Table | Lights
QWS | 47 | 34 | 38 | 88 | 90 |  |  |  | QWS ASH
 |  |  |  |  |  |  |  |  | Above return a quantities for joint look up values section wise
Section-2
Lot Name | Timber | Plywood | Lights | Table | Blocks
ABC | 79 | 69 | 63 | 53 | 70
BJH | 47 | 71 | 70 | 45 | 51
POL | 95 | 63 | 37 | 28 | 51
ASH | 98 | 89 | 41 | 70 | 46
QWS | 71 | 60 | 88 | 34 | 50
Section-3
Lot Name | Timber | Plywood | Lights | Table | Blocks
ABC | 70 | 44 | 66 | 69 | 71
BJH | 51 | 56 | 71 | 71 | 88
POL | 51 | 93 | 55 | 63 | 44
ASH | 46 | 40 | 64 | 89 | 97
QWS | 50 | 90 | 85 | 60 | 47
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 20

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, month ending July 31, by product, participant type, and cleared status (value of all trades in millions of USD).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: phillip_m_love__30141__200001_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 265657 |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  | -1400000 |  | 0 |  | 170000 |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | -528798 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -144747 |  |  |  |  |  |  |  |  |  | 3924785
7 |  | Liquidations |  |  |  | 1400000
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -60039 | -315734
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg) |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60039
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 362654 |  |  |  |  |  | 93300 |  |  |  | 0 |  | 547047
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  |  |  | -170000
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME] |  |  |  |  |  | 25279 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 820000
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  |  |  | -362654
 |  | TOTAL
Spreadsheet: 791132d1660166787-sliding-scale-formula-correction-sample_v3
Sheet: Nested IFs

 | Commission Table
 | Sales Tiers | [NAME] | [NAME]
 | $0-$50,000 | 0 | 0.05
 |  | 50001 | 0.07
 |  | 100001 | 0.1
 |  | 150001 | 0.15
 |  | Sales Amount | [NAME]
 | Nested IF Statement -> | 65000
Spreadsheet: 782590d1654152558-horizontal-sumif-and-other-function-that-i-need-help-sumproduct
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUM
A | B | C | D | E | F | A | B | C | D | E | F | … | over 3000 columns | A | B | C | D | E | F
1 | 89 | 0 | 74 | 9 | 31 | 3 | 29 | 2 | 37 | 8 | 62
8 | 45 | 0 | 36 | 2 | 64 | 24 | 15 | 2 | 18 | 1 | 128
0 | 12 | 9 | 59 | 1 | 97 | 0 | 4 | 11 | 29 | 0 | 194
2 | 32 | 3 | 51 | 1 | 17 | 6 | 10 | 5 | 25 | 0 | 34
3 | 65 | 6 | 23 | 0 | 28 | 9 | 21 | 8 | 11 | 2 | 56
11 | 24 | 7 | 35 | 5 | 39 | 33 | 8 | 9 | 17 | 4 | 78
…
over 700 rows