tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 45467a21-5039-494b-91f3-e85d567c903a
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
FENC | Test | FENC | Encainide (Enkaidr), ODE and MODE | Encainide (Enkaid) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Submit only 1 of the following:  Plasma Draw blood in a green-top (sodium heparin) tube(s). [NAME] is not acceptable. Spin down and send 1 mL of sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s). Serum gel tube is not acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icterus	NA Other	NA | Encainide: Reference Range: 15 - 100 ng/mL   O-Demethylencainide (ODE): [NAME]: 100 - 300 ng/mL   3-Methoxy-ODE (MODE): [NAME]: 60 - 300 ng/mL   10% of patients do not form therapeutic concentrations of the active metabolites, ODE and MODE. In these patients the recommended range for the encainide concentration is 300-1200 ng/mL.   Test Performed By:	Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Friday | 3 days | 5 - 7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FENC | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FENC | Result | Z1131 | Encainide | Encainide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FENC | Result | [NAME] | o-Demethylencainide (ODE) | o-Demethylencainide (ODE) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FENC | Result | Z1158 | 3-Methoxy-ODE (MODE) | 3-Methoxy-ODE (MODE) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 768185d1644871663-summing-data-based-on-overlapping-multiple-criteria-sum-by-overlapping-multiple-criteria-snook-adj-
Sheet: Sheet2

 | System Name | Date | Students | Total Students per Day/System
 | CLNC-CCS (CCS-006) | 2020-10-23 00:00:00 | 28 | 28
 | CLNC-CCS (CCS-006) | 2020-10-26 00:00:00 | 18 | 18
 | CLNC-CCS (CCS-006) | 2020-10-27 00:00:00 | 18 | 36
 | CLNC-CCS (CCS-006) | 2020-10-27 00:00:00 | 18
 | CLNC-CCS (CCS-006) | 2020-10-28 00:00:00 | 18 | 36
 | CLNC-CCS (CCS-006) | 2020-10-28 00:00:00 | 18
 | CLNC-CCS (CCS-006) | 2020-10-29 00:00:00 | 18 | 18
 | KBAY-CCS-(CCS-004) | 2020-10-06 00:00:00 | 24 | 48
 | KBAY-CCS-(CCS-004) | 2020-10-06 00:00:00 | 24
 | KBAY-CCS-(CCS-004) | 2020-10-16 00:00:00 | 19 | 57
 | KBAY-CCS-(CCS-004) | 2020-10-16 00:00:00 | 19
 | KBAY-CCS-(CCS-004) | 2020-10-16 00:00:00 | 19
 | KBAY-CCS-(CCS-004) | 2020-11-06 00:00:00 | 17 | 17
 | KBAY-CCS-(CCS-004) | 2020-11-13 00:00:00 | 19 | 19
 | KBAY-CCS-(CCS-004) | 2020-11-23 00:00:00 | 18 | 18
 | CLNC-CCS (CCS-007) | 2020-10-23 00:00:00 | 27 | 27
 | CLNC-CCS (CCS-007) | 2020-10-26 00:00:00 | 17 | 17
 | CLNC-CCS (CCS-007) | 2020-10-27 00:00:00 | 17 | 62
 | CLNC-CCS (CCS-007) | 2020-10-27 00:00:00 | 17
 | CLNC-CCS (CCS-007) | 2020-10-27 00:00:00 | 14
 | CLNC-CCS (CCS-007) | 2020-10-27 00:00:00 | 14
 | CLNC-CCS (CCS-007) | 2020-10-28 00:00:00 | 17 | 34
 | CLNC-CCS (CCS-007) | 2020-10-28 00:00:00 | 17
Spreadsheet: 17e49a6d-2768-4f01-a11f-2320a9261e18
Sheet: Agri

Cooperating Principal Eval. - Agriculture
Form Purpose - Please indicate the fulfillment of these roles/responsibilites by your cooperating principal
 | n=2 |  | n=2 |  | n=2 |  | n=2
 | Fall 2011 |  | Sp 2013 |  | Fall 2013 |  | Sp 2014
Question | Program | College | Program | College | Program | College | Program | College
Made efforts to orient me with respect to the beliefs and traditions of the community served by the school | 5 | 4.6 | 5 | 4.7 | 5 | 4.5 | 5 | 4.4
Demonstrated an interest in my teaching by completing a minimum of one written evaluation of my teaching with follow-up conference | 5 | 4 | 5 | 4.3 | 5 | 4.4 | 5 | 4.5
Encouraged the regular school staff and student body to accept and respect me in the same manner as the regular staff | 5 | 4.5 | 5 | 4.6 | 5 | 4.3 | 5 | 4.2
Worked to ensure the my experience was successful by periodically scheduling conferences with me, the cooperating teacher, and/or the university supervisor | 5 | 3.9 | 4.5 | 4.1 | 5 | 4.2 | 5 | 4.1
Cooperating Teacher Eval. - Agriculture
Form Purpose - Please indicate the fullfillment of these roles/responsibilities by your cooperating teacher
 | n=2 |  | n=2 |  | n=2 |  | n=2
 | Fall 2011 |  | Sp 2013 |  | Fall 2013 |  | Sp 2014
Question | Program | College | Program | College | Program | College | Program | College
Demonstrated characteristics of a master teacher and professional educator | 5 | 4.6 | 5 | 4.5 | 5 | 4.4 | 5 | 4.7
Maintained an appropriate learning environment to student needs | 5 | 4.8 | 5 | 4.6 | 5 | 4.6 | 5 | 4.5
Modeled effective teaching behaviors while allowing me to develop my own teaching style | 5 | 4.7 | 5 | 4.3 | 5 | 4.5 | 5 | 4.4
Exhibited a positive attitude toward working with me, the University supervisor, and McNeese faculty | 5 | 4.8 | 5 | 4.7 | 5 | 4.5 | 5 | 4.6
Assisted and advised me in the development of lesson plans; approved my lesson plans prior to teaching | 5 | 4.9 | 5 | 4.7 | 5 | 4.6 | 5 | 4.5
Furnished a semester teaching and observation schedule to me early in the semester | 5 | 4.7 | 5 | 4.4 | 5 | 4.5 | 5 | 4.3
Acquainted me with available technology and instructions for its use | 5 | 4.8 | 5 | 4.5 | 5 | 4.7 | 5 | 4.6
Inducted me into classroom procedures as completely as possible | 5 | 4.9 | 5 | 4.7 | 5 | 4.5 | 5 | 4.4
Accepted me as a professional colleague and helped me assume full teaching responsibilities during my all-day teaching | 5 | 4.8 | 5 | 4.7 | 5 | 4.6 | 5 | 4.5
Conferred with me concerning pupil evaluation and grading policies and procedures | 5 | 4.8 | 5 | 4.6 | 5 | 4.5 | 5 | 4.4
Checked tests I prepared in advance of class presentations to assure fairness and validity | 5 | 4.9 | 5 | 4.7 | 5 | 4.8 | 5 | 4.7
Observed me teaching and completed the required evaluation forms, with the follow-up conferences | 5 | 4.8 | 5 | 4.5 | 5 | 4.5 | 5 | 4.4
Completed mid-semester and final written evaluations with follow-up conferences | 5 | 4.9 | 5 | 4.8 | 5 | 4.7 | 5 | 4.5
Spreadsheet: 35934d1233658340-double-lookup-function-match
Sheet: Sheet2

Third | FP I | Name | MEDM
21 | 20 | A | 1112
20 | 10 | B | 1113
19 | 9 | C | 1114
18 | 8 | D | 1115
17 | 7 | E | 1116
16 | 6 | F | 1117
15 | 5 | G | 1118
14 | 4 | H | 1119
13 | 3 | I | 1120
12 | 2 | J | 1121
11 | 1 | K | 1122
Spreadsheet: 36777d1234718361-changing-a-formula-to-show-the-work-cord-fill-0-000
Sheet: Sheet1

COORDINATE METHOD
 |  |  |  |  |  |  | 19+175
A1
COORDINATES |  | POSITIVE CROSS-MULTIPLES |  |  | NEGATIVE CROSS-MULTIPLES
"N" | "E"
2.92 | -55.442 | A8*B7
2.94 | -50 | A9*B8 |  |  | A7*B8
3.08 | -25 | A10*B9 |  |  | A8*B9
3.18 | 0 | A11*B10 |  |  | [NAME]
4.531 | 0 | A12*B11 |  |  | A10*B11
4.281 | -50 | A13*B12 |  |  | A11*B12
2.92 | -55.442 |  |  |  | A12*B13
TOTALS |  | S= |  |  | S=
2 X AREA = | E14-H14
A1 AREA=
A2
COORDINATES |  | POSITIVE CROSS-MULTIPLES |  |  | NEGATIVE CROSS-MULTIPLES
"N" | "E"
3.447 | 53.335 | A22*B21
4.281 | 50 | A23*B22 |  |  | A21*B22
4.531 | 0 | A24*B23 |  |  | A22*B23
3.18 | 0 | A25*B24 |  |  | A23*B24
3.36 | 25 | A26*B25 |  |  | A25*B26
3.43 | 50 | A27*B26 |  |  | A27*B28
3.447 | 53.335
TOTALS |  | S= |  |  | S=
2 X AREA = | E28-H28
A2 AREA=
AREA= | B16+B30 | AREA=
Spreadsheet: 857281d1706289621-avg-conditionally-formatted-cells-ld-mailroom-sp-production-beta
Sheet: Sheet1

Rep |  | Task 1 |  | E.O.M. |  | Task 2 |  | E.O.M. |  | Task 3 |  | E.O.M. |  | Task 4 |  | E.O.M. |  | Task 5 |  | E.O.M. |  | Task 6 |  | E.O.M. |  | OTHER |  |  | ScoreCard
 |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal
Rep 1 |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 4 |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 6 |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 541370d1507243326-trying-to-set-a-text-value-in-if-function-trying-to-set-a-text-value-in-if-function
Sheet: Sheet1

 |  | f f |  | f f |  |  | 0.2
 |  | n/a |  | n/a |  |  | 0.2
 |  | 120 |  | 119.9 |  |  | 0.2
 |  | f f |  | f f |  |  | 0.2
 |  | n/a |  | n/a |  |  | 0.2
 |  | in cell G4 and G8, the value is less than the value set in cell J4 but it shows [NAME], yet in cell [NAME] with same value it shows Pass.  The only variation is in cell G4 it is text value for f f  set in C4 and E4 cells.  What the output in column J should be 80% of the value in column H.  It should show Pass in cell J4
Spreadsheet: 141454d1329278355-excel-2007-referencing-a-cell-at-the-interction-of-a-row-and-column-heading-test
Sheet: COMPARE

POSCO | 1-38 INF | 1-38 NEW | 2-1 CAV | 2-1 NEW | 2-12 FA | 2-12 NEW | 2-23 INF | 2-23 NEW
11B | 3 | here I need the value of the cell in "new number" that corresponds with the column and row headings in this sheet. | 3 |  | 12 |  | 4
12C | 6 |  | 6 |  | 23 |  | 5
15W
19D | 29 |  | 34 |  | 56 |  | 3
42A | 12 |  | 6 |  | 45 |  | 4
Spreadsheet: 778805d1651328667-formula-to-check-crossed-dates-from-to-crossed-dates
Sheet: Sheet1

# | From | To |  | From | To | result
 | 2022-01-01 00:00:00 | 2022-01-05 00:00:00 |  | 2022-02-25 00:00:00 | 2022-06-25 00:00:00
 | 2022-01-06 00:00:00 | 2022-02-20 00:00:00
3 | 2022-02-24 00:00:00 | 2022-03-04 00:00:00
4 | 2022-06-16 00:00:00 | 2022-06-19 00:00:00
5 | 2022-06-21 00:00:00 | 2022-06-21 00:00:00
Spreadsheet: 762466d1641568615-calculation-in-nested-formula-based-on-data-entry-from-table-book4-ans
Sheet: Sheet1

Name | Base | Agency | Commision |  |  |  |  |  |  |  |  |  |  | Agency | Commision
JS | 50000 | Adjusting Appointments |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.17
GT | 40000 | Heat |  |  |  |  |  |  |  |  |  |  |  | Adjusting Appointments | 0.25
NO | 30000 | Exchange Street |  |  |  |  |  |  |  |  |  |  |  | Exchange Street | 0.16
DR | 10000 | Adjusting Appointments |  |  |  |  |  |  |  |  |  |  |  | Heat | 0.15
BE | 25000 | Employee Referral |  |  |  |  |  |  |  |  |  |  |  | Employee Referral | 1000
SR | 20000 | [NAME]
AR | 20500 | Exchange Street
Spreadsheet: 169384d1342801347-arranging-information-into-tables-new-problem-1
Sheet: Sheet1

Sheet One
"Helper" | Unit/Process | Rating
A-1 | Inlet works | A
A-2 | [NAME] | A
B-1 | Grit removal | B
B-2 | Quality of grit | B
C-1 | Flow | C
D-1 | Sampling | D
A-3 | Channels | A
Spreadsheet: 688170d1595599996-3-level-drop-down-list-charity-dependants
Sheet: Lists

Category | Income | Government
Income | Government | 4-1010
Expenses | Donations | 4-1020
Assets | Goods/Services | 4-1030
Liabilities | Investments | 4-1040
 | OtherRevenue | 4-1050
 | OtherIncome | 4-1060
 |  | 4-1070
 |  | 4-1080
 |  | 4-1090
 |  | 4-1100
 |  | 4-3030
 |  | 4-1100
 |  | 4-3030
 |  | 4-1100
 |  | 4-3030
Spreadsheet: 800397d1665652527-filter-and-sort-formulas-sample
Sheet: Sheet2

 | Target> | sort by End Date all active tasks, excluding "Completed", plesae refer to Sheet 1
 | Task | Type | Task ID | Priority | Start | End | Status
1 | Task 2 | Various 2 | T2 | High | 2022-09-25 00:00:00 | 2022-12-16 00:00:00 | Planned
2 | Task 4 | Various 4 | T4 | High | 2022-08-20 00:00:00 | 2022-11-16 00:00:00 | Behind
3 | Task 5 | Various 5 | T5 | High | 2022-08-02 00:00:00 | 2022-11-01 00:00:00 | Stalled
4 | Task 6 | Various 6 | T6 | High | 2022-07-15 00:00:00 | 2022-10-17 00:00:00 | Stalled
5 | Task 9 | Various 9 | T9 | High | 2022-05-22 00:00:00 | 2022-09-02 00:00:00 | Planned
6 | Task 10 | Various 10 | T10 | High | 2022-05-04 00:00:00 | 2022-08-18 00:00:00 | Stalled
7 | Task 11 | Various 11 | T11 | High | 2022-04-16 00:00:00 | 2022-08-03 00:00:00 | Stalled
8 | Task 12 | Various 12 | T12 | High | 2022-03-29 00:00:00 | 2022-07-19 00:00:00 | Stalled
9 | Task 13 | Various 13 | T13 | High | 2022-03-11 00:00:00 | 2022-07-04 00:00:00 | Planned
10 | Task 15 | Various 15 | T15 | High | 2022-02-03 00:00:00 | 2022-06-04 00:00:00 | Behind
11 | Task 16 | Various 16 | T16 | High | 2022-01-16 00:00:00 | 2022-05-20 00:00:00 | Behind
12 | Task 19 | Various 19 | T19 | High | 2021-11-23 00:00:00 | 2022-04-05 00:00:00 | Planned
13 | Task 20 | Various 20 | T20 | High | 2021-11-05 00:00:00 | 2022-03-21 00:00:00 | In Progress
14 | Task 21 | Various 21 | T21 | High | 2021-10-18 00:00:00 | 2022-03-06 00:00:00 | In Progress
Spreadsheet: 275253d1383420631-item-list-from-table-itemlist_reply
Sheet: List

 |  |  |  |  |  | Name 1
ITEMS(Given to Name) | Pieces(Given to Name) | Usage Term(Of Item) | For Year(By default This Year) | Helper Column
 |  |  |  |  |  | Wanted List on this page
 |  |  |  |  |  | Pull information from Names Worksheet
 |  |  |  |  |  | as shown A, B, C cells
 |  |  |  |  |  | Like on this List Table
Spreadsheet: 746506d1630779072-automatically-work-out-percentage-increase-to-balance-figure-midshires-master-2022
Sheet: Playing

 | Playing Handicap | PLAYER | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Par 3 | Stroke Index |  |  |  | HANDICAPPING ALTERATIONS
 |  |  | PAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Playing H'Caps |  |  |  |  | 36 |  | Winners | Other |  | H'cap |  | catagory
 |  |  | S/I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S/I 1 | S/I 2 | S/I 3 |  | Points |  | POST | Cuts | Cuts | Increase | Change
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cuts
1 |  | SKINS
1
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 2001-02

Table C
Graduate Student Numbers by Faculty and Year Group
2001-02
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Total
Arts and Humanities | 399 | 165 | 45 | 18 | 17
Built Environment | 511 | 81 | 31 | 20 | 26
Clinical Sciences | 396 | 348 | 258 | 97 | 28
Eastman Dental Institute | 99 | 101 | 70 | 59 | 39
Engineering | 293 | 171 | 153 | 46 | 28
Laws | 342 | 18 | 2 | 4 | 2
Life Sciences | 403 | 255 | 158 | 55 | 8
Mathematical and Physical Sciences | 255 | 100 | 91 | 27 | 12
Social and Historical Sciences | 602 | 159 | 80 | 42 | 37
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 709075d1608145667-report-values-between-2-sheets-cerca-vert-partic-2
Sheet: Sheet2

 |  |  |  | ordine | PZ | SETTIMANA 1 |  | RESULT IS THIS
 |  |  |  | 1234 | 22 | ABC1 |  | ITALIA
 |  |  |  | 1234 | 22 | ABC1 |  | FRANCIA
 |  |  |  | 1235 | 22 | ABC3 |  | SPAGNA
 |  |  |  | 1237 | 22 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 22 | ABC1 |  | FRANCIA
 |  |  |  | 1237 | 22 | ABC1 |  | GERMANIA
 |  |  |  | 4533 | 12 | DSC1 |  | SPAGNA
 |  |  |  | 4533 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 4533 | 12 | DSC1 |  | GERMANIA
 |  |  |  | 3344 | 5 | EFG3 |  | FRANCIA
 |  |  |  | 8899 | 12 | [NAME] |  | ITALIA
 |  |  |  | 8899 | 12 | [NAME] |  | FRANCIA
 |  |  |  | 8899 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 9999 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 9999 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 7788 | 12 | ABC5 |  | FRANCIA
 |  |  |  | 1237 | 33 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 33 | ABC1 |  | FRANCIA
 |  |  |  | 789 | 12 | ABC5 |  | FRANCIA
 |  |  |  | 789 | 12 | DSC1 |  | SPAGNA
 |  |  |  | 789 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 789 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 148 | 24 | DSC2 |  | SPAGNA
 |  |  |  | 148 | 24 | DSC2 |  | SPAGNA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 24 | 24 | EFG2 |  | ITALIA
 |  |  |  | 33 | 24 | EFG2 |  | FRANCIA
 |  |  |  | 987 | 45 | EFG3 |  | FRANCIA
 |  |  |  | 85 | 12 | [NAME] |  | ITALIA
 |  |  |  | 85 | 12 | [NAME] |  | FRANCIA
 |  |  |  | 1237 | 33 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 33 | ABC1 |  | FRANCIA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 58 | 21 | EFG1 |  | GERMANIA
 |  |  |  | 99 | 24 | EFG3 |  | FRANCIA
 |  |  |  | 99 | 24 | EFG3 |  | ITALIA
 |  |  |  | 99 | 24 | EFG3 |  | USA
Spreadsheet: 783221d1654676808-count-distinct-multiple-conditions-and-time-range-rdt_01042022
Sheet: data

USER_ID | SKU_ID | [NAME] | TO_CHAR(IT.DSTAMP,'DD/MM/YYYY') | TO_CHAR(IT.DSTAMP,'HH24:MI:SS') | UPDATE_QTY
SOARESF | 375872 | SPORT | 2022-04-01 00:00:00 | 00:45:25 | 1
REMIGIOA | 988691 | SPORT | 2022-04-01 00:00:00 | 00:52:53 | 1
SOARESF | 1250700 | SPORT | 2022-04-01 00:00:00 | 00:54:37 | 2
SOARESF | 1293515 | SPORT | 2022-04-01 00:00:00 | 00:54:06 | 2
AMARALS | 1506460 | SPORT | 2022-04-01 00:00:00 | 00:35:58 | 10
ADRIANC | 53042 | SPORT | 2022-04-01 00:00:00 | 08:46:14 | 1
SANDRAC | 530907 | SPORT | 2022-04-01 00:00:00 | 07:26:28 | 1
ADRIANC | 756306 | SPORT | 2022-04-01 00:00:00 | 08:48:24 | 1
BALANL | 375644 | SPORT | 2022-04-01 00:00:00 | 08:34:12 | 1
BALANL | 375644 | SPORT | 2022-04-01 00:00:00 | 08:33:51 | 1
SOARESF | 375656 | SPORT | 2022-04-01 00:00:00 | 22:01:58 | 1
SOARESF | 375656 | SPORT | 2022-04-01 00:00:00 | 18:37:46 | 1
BALANL | 375656 | SPORT | 2022-04-01 00:00:00 | 08:08:44 | 1
BRYGM | 375872 | SPORT | 2022-04-01 00:00:00 | 06:37:45 | 3
Spreadsheet: 830493d1684943242-combing-unique-values-from-duplicate-rows-horizontally-samplespreadsheet
Sheet: How It Looks

ID # | Student Name | Grade Level | Course Name | Teacher Name | Grade | Percent
1 | Student A | 9 | Example 1 | Teacher 1 | F | 0
1 | Student A | 9 | Example 2 | Teacher 2 | F | 0
1 | Student A | 9 | Example 3 | Teacher 3 | F | 0
2 | Student B | 10 | Example 1 | Teacher 1 | F | 0
3 | Student C | 11 | Example 1 | Teacher 1 | F | 0
4 | Student D | 12 | Example 1 | Teacher 1 | F | 0
4 | Student D | 12 | Example 2 | Teacher 2 | F | 0
5 | Student E | 10 | Example 1 | Teacher 1 | F | 0
Spreadsheet: 767768d1644610154-create-a-summary-sheet-to-include-data-their-from-multiple-sheets-dummy-workbook
Sheet: Sheet5

 | Date | Time | Item | PO Number | Quantity  Ordered | Quantity  Delivered | Booking  Reference Number | STATUS
JANUARY | 2022-02-05 00:00:00 | 08:00:00 | Ti-Pure | 448127 | 6000 | 6000 | 21241 | DELIVERED
 | 2022-01-13 00:00:00 | 10:00 | Ti-Pure | 448129 | 6000 | 6000 | 21318 | DELIVERED
 | 2022-01-20 00:00:00 | 08:00 | Ti-Pure | 448130 | 6000 | 6000 | 21424 | DELIVERED
 | 2022-01-25 00:00:00 | 08:00 | Ti-Pure | 448131 | 6000 | 6000 | 21532 | DELIVERED
FEBRUARY | 2022-02-01 00:00:00 | 08:00 | Ti-Pure | 447954 | 6000 | 6000 | 21621 | DELIVERED
 | 2022-02-03 00:00:00 | 12:00 | Ti-Pure | 449338 | 6000 | 6000 | 21697 | DELIVERED
 | 2022-02-07 00:00:00 | 12:00 | Ti-Pure | 448085 | 6000 | 6000 | 21737 | DELIVERED
 | 2022-02-10 00:00:00 | 12:00 | Ti-Pure | 449727 | 6000 |  | 21845 | NOT DELIVERED
 | 2022-02-16 00:00:00 | 12:00 | Ti-Pure | 449766 | 6000 |  | 21890 | NOT DELIVERED
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1
2 |  |  |  | 3639
3 | 4302 |  |  | 3639
4 |  |  |  | 3639
5 | 18615 |  |  | 10000
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  |  |  | 61895
 | 2001-06-05 00:00:00
Spreadsheet: 88405d1288225851-nested-if-statement-book3
Sheet: Sheet1

Overtime Worksheet
Employee's name | [NAME] |  | Level | 5
Employee's number | 1234 |  | Step | 1
Date | Day | Time In | Time Out | Overtime hours | Overtime  Multiplier | Overtime Earned | Meal Allowance | Night Differential | Total Due
2010-10-01 00:00:00 | Friday | 17:30:00 | 20:20:00 | 2.833333333333334 | 1.5 | 255.0000000000001 |  |  | 255.0000000000001
2010-10-06 00:00:00 | Wednesday | 17:30:00 | 22:30:00 | 5.000000000000001 | 1.5 | 450.0000000000001 |  |  | 450.0000000000001
2010-10-09 00:00:00 | Saturday | 08:00:00 | 19:22:00 | 11.36666666666667 | 1.5 | 1023 |  |  | 1023
2010-10-10 00:00:00 | Sunday | 10:00:00 | 13:30:00 | 3.5 | 2 | 419.9999999999999 |  |  | 419.9999999999999
2010-10-11 00:00:00 | Monday | 08:00:00 | 17:00:00 | 9.000000000000002 | 1.5 | 810.0000000000002 |  |  | 810.0000000000002
 |  |  |  |  | 8 | 2958 | 0 | 0 | 2958
Spreadsheet: 01c2b492-ea2d-4bc8-ae45-cf91c59cf440
Sheet: % FTE Reduction

 | Voluntary FTE Reduction Calculator
Instructions: | Enter your annual salary rate, FTE, and percentage of monthly FTE reduction in the yellow highlighted fields
12-Month Employee
 |  |  | Monthly Gross Salary Reduction Amount | Days | Hours
Annual Salary | 50000
FTE | 1
% Monthly Reduction | 0.046
9-month Employee
 |  |  | Monthly Gross Salary Reduction Amount | Days | Hours
Annual Salary | 50000
FTE | 1
% Monthly Reduction | 0.046
* If you have any questions or need assistance, please contact Payroll at 346-3151.
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Sep

September Valet Totals
PIPER |  |  |  |  | MAIN |  |  |  |  | TOTAL
Average Wait Time |  |  |  |  | Average Wait Time |  |  |  |  | Average Wait Time
Average Storage Length |  |  |  |  | Average Storage Length |  |  |  |  | Average Storage Length
 | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours
5:00am-5:59am | 117 | 5.3 | 1 |  | 5:00am-5:59am | 0 | 0 | 0 |  | 5:00am-5:59am | 117 | 2.65 | 1
6:00am-6:59am | 182 | 8.3 | 2 |  | 6:00am-6:59am | 0 | 0 | 0 |  | 6:00am-6:59am | 182 | 4.15 | 2
7:00am-7:59am | 386 | 17.5 | 3.5 |  | 7:00am-7:59am | 63 | 2.9 | 2 |  | 7:00am-7:59am | 449 | 10.2 | 5.5
8:00am-8:59am | 665 | 30.2 | 5 |  | 8:00am-8:59am | 160 | 7.3 | 2 |  | 8:00am-8:59am | 825 | 18.75 | 7
9:00am-9:59am | 925 | 42 | 5.5 |  | 9:00am-9:59am | 296 | 13.5 | 2 |  | 9:00am-9:59am | 1221 | 27.75 | 7.5
10:00am-10:59am | 468 | 45.2 | 5 |  | 10:00am-10:59am | 421 | 19.1 | 3 |  | 10:00am-10:59am | 889 | 32.15000000000001 | 8
11:00am-11:59am | 550 | 42.2 | 5 |  | 11:00am-11:59am | 496 | 22.5 | 3 |  | 11:00am-11:59am | 1046 | 32.35 | 8
12:00pm-12:59pm | 882 | 40.1 | 5 |  | 12:00pm-12:59pm | 343 | 15.6 | 2 |  | 12:00pm-12:59pm | 1225 | 27.85 | 7
1:00pm-1:59pm | 799 | 36.3 | 5 |  | 1:00pm-1:59pm | 420 | 19.1 | 2 |  | 1:00pm-1:59pm | 1219 | 27.7 | 7
2:00pm-2:59pm | 748 | 34 | 4.5 |  | 2:00pm-2:59pm | 431 | 19.6 | 3 |  | 2:00pm-2:59pm | 1179 | 26.8 | 7.5
3:00pm-3:59pm | 652 | 29.6 | 3.5 |  | 3:00pm-3:59pm | 338 | 15.4 | 3 |  | 3:00pm-3:59pm | 990 | 22.5 | 6.5
4:00pm-4:49pm | 397 | 18 | 1.5 |  | 4:00pm-4:49pm | 182 | 8.3 | 2 |  | 4:00pm-4:49pm | 579 | 13.15 | 3.5
5:00pm-5:59pm | 247 | 11.2 | 1 |  | 5:00pm-5:59pm | 134 | 6.1 | 2 |  | 5:00pm-5:59pm | 381 | 8.649999999999999 | 3
6:00pm-6:59pm | 157 | 7.1 | 1 |  | 6:00pm-6:59pm | 137 | 6.2 | 2 |  | 6:00pm-6:59pm | 294 | 6.65 | 3
7:00pm-8:00pm | 0 | 0 | 0 |  | 7:00pm-8:00pm | 62 | 2.8 | 2 |  | 7:00pm-8:00pm | 62 | 1.4 | 2
 | 7175 | 24.46666666666667 | 48.5 |  |  | 3483 | 10.56 | 30 |  |  | 10658 | 17.51333333333333 | 78.5