tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 721009d1614426139-need-help-to-remove-false-and-shorten-the-formula-sample-workbook-2-
Sheet: Prototype

Care Setting: |  |  |  | Start Point: | Free text field |  | Total Manpower Cost:
Length of Inpatient Stay: |  |  |  | End Point: | Free text field |  | Total Non-Manpower Cost:
Date of Update: |  |  |  | Exclusions: | Free text field |  | Overall Cost per Carepath:
S/N | Type of Cost | Type of Care Setting | Activity/ Therapy/ Procedures | Profession | Seniority | Generic Cost from Finance (Manpower) | FTE required | Activity Duration (minutes) | Manpower Cost per Activity | Generic Cost from Finance (Non-Manpower) | Non-Manpower Cost based on LOS
1 | Other Cost | Specialist Outpatient Clinic
2
3
4
5
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
Spreadsheet: 876104d1722770676-lottery-tracker-needed-firedog1-number-test-1-aligw
Sheet: Sheet1

 | Check number | #1 | #2 | #3 | #4 | #5 | #6 |  |  | # | [NAME]
 |  | 12 | 3 | 24 | 46 | 16 | 38 |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2
 | Match? | 1 | 2 | 3 | 4 | 5 | 6 |  |  | 3
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 5
 | Line # | #1 | #2 | #3 | #4 | #5 | #6 | # [NAME] |  | 6
 | 1 | 8 |  |  |  |  | 38 |  |  | 7
 | 2 |  |  |  |  |  |  |  |  | 8
 | 3 |  |  |  |  |  |  |  |  | 9
 | 4 |  |  |  |  |  |  |  |  | 10
 | 5 |  |  |  |  |  |  |  |  | 11
 | 6 |  |  |  |  |  |  |  |  | 12
 | 7 |  |  |  |  |  |  |  |  | 13
 | 8 |  |  |  |  |  |  |  |  | 14
 | 9 |  |  |  |  |  |  |  |  | 15
 | 10 |  |  |  |  |  |  |  |  | 16
 | 11 |  |  |  |  |  |  |  |  | 17
 | 12 |  |  |  |  |  |  |  |  | 18
 | 13 |  |  |  |  |  |  |  |  | 19
 | 14 |  |  |  |  |  |  |  |  | 20
 | 15 |  |  |  |  |  |  |  |  | 21
 | 16 |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  | n
 | 17 |  |  |  |  |  |  |  |  | 23
 | 18 |  |  |  |  |  |  |  |  | 24
 | 19 |  |  |  |  |  |  |  |  | 25
 | 20 |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  | 28
 | True | My lottery has 47 numbers (1-47), no special number, or PB. |  |  |  |  |  |  |  | 29
 | True | I would like the winning numbers placed in [NAME], and checked if they match. |  |  |  |  |  |  |  | 30
 | True | I would like the matched numbers placed in C6 :H6. |  |  |  |  |  |  |  | 31
 | True | I would like the M column to show how many times each ball was picked. |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 855526d1705062626-transform-data-datatransform
Sheet: Sheet1

 | Date | Shift | PartNr | SC Type1 | SC Type2 | SC Type3 |  |  | Date | Shift | PartNr | SC Type | Amount
 | 2024-01-02 00:00:00 | 2 | 7588SE | 12 |  | 1 |  |  | 2024-01-02 00:00:00 | 2 | 0298SE2 | Type1 | 6
 | 2024-01-02 00:00:00 | 2 | 587-6-M | 16 | 6 |  |  |  | 2024-01-02 00:00:00 | 2 | 0298SE2 | [NAME] | 6
 | 2024-01-02 00:00:00 | 2 | 0298SE2 | 6 |  | 6 |  |  | 2024-01-02 00:00:00 | 1 | 5062SE | Type1 | 9
 | 2024-01-02 00:00:00 | 2 | 752-7-SE | 6 |  |  |  |  | 2024-01-02 00:00:00 | 1 | 5070SE | Type1 | 24
 | 2024-01-02 00:00:00 | 1 | 5062SE | 9 |  |  |  |  | 2024-01-02 00:00:00 | 1 | 5070SE | [NAME] | 11
 | 2024-01-02 00:00:00 | 1 | 5070SE | 24 |  | 11 |  |  | 2024-01-02 00:00:00 | 2 | 587-6-M | Type1 | 16
 | 2024-01-02 00:00:00 | 1 | 590-1-SE | 8 |  | 4 |  |  | 2024-01-02 00:00:00 | 2 | 587-6-M | Type2 | 6
 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 | 1 | 590-1-SE | Type1 | 8
 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 | 1 | 590-1-SE | [NAME] | 4
 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 | 2 | 752-7-SE | Type1 | 6
 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 | 2 | 7588SE | Type1 | 12
 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 | 2 | 7588SE | [NAME] | 1
Spreadsheet: 3e7d8c7d-0de7-4135-a2a7-50173407a2fc
Sheet: Evergreen

REGIONAL DIRECTORY 2014/2015
EVERGREEN ELEMENTARY SCHOOL DISTRICT
[NAME], [NAME] | [NAME], MEP Coordinator | [NAME], Fiscal Officer
3188 Quimby Road | 3188 Quimby Road | 3188 Quimby Road
San Jose, CA 95148 | San Jose, CA 95148 | San Jose, CA 95148
O: [PHONE] | O: [PHONE] | O: [PHONE]
F; [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], Case Manager | [NAME], Accounting Analyst | [NAME], MEP PK Homebase Teacher
3188 Quimby Road | 3188 Quimby Road | 3188 Quimby Road
San Jose, CA 95148 | San Jose, CA  95148 | San Jose, CA 95148
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | n/a
Spreadsheet: 734278d1622087835-pull-data-from-another-sheet-if-condition-is-met-covid-line-listing-kosong
Sheet: Individual

NO | Nama Pesakit | No. KP / Passport | Tarikh Daftar | [NAME] | Umur (tahun) | Jantina | Alamat |  | No [NAME] | [NAME] | Warganegara | Pekerjaan | Tempat bertugas [NAME] | Sign and Symptom |  |  |  |  |  | Working Diagnosis |  | Status Pesakit ([NAME]) | Tarikh Onset | [NAME] | Tarikh Kemasukan ke PKRC | Tarikh sepatutnya discaj | Tarikh Discaj | STATUS PESAKIT | [NAME] | Close contact with confirmed 2019 nCoV | Tarikh akhir contact dengan pesakit Covid-19 | Risiko / co-morbids | [NAME] | Jenis Sampel Diambil | SAMPEL PERTAMA |  |  |  |  | SAMPEL KEDUA |  |  | Catatan (Rujukan dari PKD/HOSPITAL) | PATIENT STAGING | LENGTH OF STAY
 |  |  |  |  |  |  | Alamat [NAME] | Alamat [NAME] |  |  |  |  |  | Fever | Cough | Sorethroat | Myalgia | Headache | Lain-lain | Admission Diagnosis | Warded Diagnosis |  |  |  |  |  |  |  |  |  |  |  |  |  | Tarikh Sampel [NAME] | Tarikh Sampel [NAME] | Makmal Sampel [NAME] | Tarikh [NAME] Sampel Pertama | [NAME] Sampel Pertama | Tarikh sampel [NAME] diambil | Tarikh [NAME] sampel [NAME] | [NAME] sampel [NAME] |  |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | Day 20
 | test abc | 123 | 2021-01-01 00:00:00 | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc | abc
Spreadsheet: 827249d1682580754-depend-dropdownlist-example
Sheet: Sheet1

 |  |  | Master |  |  |  | Input
 |  |  | Continent | Region | Country |  | Continent | Region | Country
 |  |  | Asia | Asia Selatan | Afganistan
 |  |  | Eropa | Eropa Utara | [NAME]
 |  |  | Eropa | Eropa Selatan | Albania
 |  |  | Afrika | Afrika Utara | Aljazair
 |  |  | Oceania | Polinesia | Samoa Amerika
 |  |  | Eropa | Eropa Selatan | Andorra
 |  |  | Afrika | [NAME] | Angola
 |  |  | Amerika Utara | Karibia | Anguila
 |  |  | Antartika | Antartika | Antartika
Spreadsheet: 165791d1341340053-vlookup-wanting-2nd-3rd-occurrence-etc-occurrences
Sheet: Rollover

First Name Last Name
Donielle [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Luzdenia Barfield
[NAME]
Myesha Baytops
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Shoneal [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Crystal Crayton
[NAME]
Mickei Crews
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Billie Estremera
[NAME]
[NAME]
[NAME]
Asia Gravely
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Katheryn Humphries
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Penelope Maguire
M Rae Mapps
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Dominiquea Skillman
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Rhoda Young
Spreadsheet: 227600d1365762555-splitting-data-from-cells-examples-included-template-for-data-that-requires-sorting
Sheet: Sheet2

Title | Foremane | Surname |  | Add1 | Add2 | Add3 | Add4 | Postcode | Tel1 | Tel2 | Tel3
Spreadsheet: 198365d1354746976-row-highlighting-after-a-selection-quality-receiving-ncr-status-sheet-mrb-uncontrolled
Sheet: IN-HOUSE

ATG IN-HOUSE NON-CONFORMANCE REPORTS
STATUS | PO | NCR No. | PART NUMBER | REV | QTY: | LOC: | INSPECTOR | INSPECT DATE: | STATUS CHANGE  DATE | SCANNED,  SAVED,  LOG  UPDATED? (Y or N) | ORIGINAL OR SIGNED VERSION IN BINDER?  (Y or N) | AMICS  UPDATED w/NCR DISPOSITION  (Y OR N) | NOTES | QUANTITY/[NAME] |  |  |  |  | RMA REQUEST |  | RMA#: | RMA PO#: | SIGNATURES NEEDED BY:  (Yes, No, Signed) |  |  |  |  | SCAR#: | CAR#:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SCRAP | UAI | REWORK | RTV | ACCEPT | RMA (Y,N) | DATE |  |  | ENGINEERING | PURCHASING | QUALITY | PROG MGMNT | MFG
Spreadsheet: 527271d1499786197-using-vlookup-with-an-external-workbook-and-the-indirect-function-source
Sheet: Sheet4

S.NO. | CONTAINER NO. | SEAL NO. | WEIGHT
1 | ZZZZ | 4343 | 4343
2 | XXXX | 4545 | 4545
3 | CCCC | 4646 | 4646
4 | VVVV | 7575 | 7575
Spreadsheet: 873613d1720111046-return-specific-text-if-within-range-of-days-excel-help-date-range-lookup-example
Sheet: DATA VALIDATION

MIN | MAX | CATEGORY
0 | 31 | 0-1 MONTHS
 |  | 1-2 MONTHS
 |  | 2-3 MONTHS
 |  | 3-4 MONTHS
 |  | 4-5 MONTHS
 |  | 5-6 MONTHS
 |  | 6-7 MONTHS
 |  | 7-8 MONTHS
 |  | 8-9 MONTHS
 |  | 9-10 MONTHS
 |  | 10-11 MONTHS
 | 365 | 11 MONTHS TO 1 YEAR
 | 730 | 1-2 YEARS
 | 1095 | 2-3 YEARS
 | 1460 | 3-4 YEARS
 | 1825000 | NEVER
Spreadsheet: 75805d1276376428-consolidate-4-worksheets-into-1-copypastetest
Sheet: Blender assembly

 | [NAME] of Materials | MTTS | Blender assembly
MECHANICAL
Author: |  | Date initial: | 2010-05-19 00:00:00
 |  | Updated: | 2010-05-19 00:00:00
version:
Sequence | Designator | Type no. | Value | Footprint | Description | Nr. Required |  | price 1pc (US$) | Order code: | Note | Inspect 1 | Reference:
1 | blender | CT3-sơn tđ |  |  | 157x96mmx1[NAME] | 1
2 | gas reducing valve | copper |  |  | M32x1 | 2
3 | Nut M32x1 ([NAME]) | Nhựa POM |  |  | M32x1 | 2
4 | Nut M32x1 (Trong) | Nhựa POM |  |  | M32x1 | 2
5 | Nut M15x1 | Nhựa POM |  |  | M15x1 | 1
6 | Cover D11 (thread in side ) | Nhựa POM |  |  | M4(trong) | 1
7 | plug-in component           (đx,ôn,êcuh) | Nhựa POM |  |  |  | 1
8 | Input and bolt  plastic               ([NAME] nối ngoài ,êcu) | Nhựa POM |  |  |  | 1
9 | bolt M14x1( square) | Nhựa POM |  |  | M14x1 | 1
10 | Branch tee (Y) | Nhựa POM |  | for mix air | D8 | 1
11 | chart stick |  |  |  | chart for mix air | 1
12 | bolt M12xM8x12 | aluminium |  | for mix air |  | 1
13 | bolt [NAME] | inox |  | [NAME] hộp điện | [NAME] | 4
14 | pipe plastic | plastic |  | for air conduction | D8x250mm(2 part) | 2
Spreadsheet: 707279d1607150814-consoldate-mulitple-rows-into-a-single-row-sample-bene-data-v2-ans
Sheet: Sheet1

Oringinal Data
A/N | Type | Name | [NAME] | Relationship | [NAME] | %
123 | IRA | Smith | [NAME] | Spouse | Primary | 100
123 | IRA | Smith | [NAME] | Child | Contingent | 50
123 | IRA | Smith | Sue | Child | Contingent | 50
124 | AAA | asa | sss | dddd | [NAME] | 44
124 | AAA | asa | rrr | eee | wqw | 1000
Preferred Data Format
A/N | Type | Name | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | %
123 | IRA | Smith | [NAME] | Spouse | Primary | 100 | [NAME] | Child | Contingent | 50 | Sue | Child | Contingent | 50
New Data Set
A/N | Type | Name | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | %
123 | IRA | Smith | [NAME] | Spouse | Primary | 100
123 | IRA | Smith | [NAME] | Child | Contingent | 50
123 | IRA | Smith | Sue | Child | Contingent | 50
124 | AAA | asa | sss | dddd | [NAME] | 44
124 | AAA | asa | rrr | eee | wqw | 1000
125 | BBB | BTB | GRG | Spouse | Primary | 100
125 | BBB | BTB | FEF | Child | Contingent | 100
Attempt #1
A/N | Type | Name | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | %
 |  | In entering the ranges in formulas there were mistakes.
 |  | I have corrected them
Spreadsheet: 134787d1325629475-colour-coding-cells-if-contracted-hours-not-met-conf030112
Sheet: Ancillary paysheet

 | Date :- | Ancillary operators |  |  |  |  | Shift :-
 | Production
 | Operator | Clock no | Grade | In | Out | In | Out | - Breaks | Total Mins | Perf | Rate per sm | Earnings
 |  | Machine | Perf
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  |  |  |  | Average =
 | Time work
 | Operator | Clock no | Grade | In | Out | In | Out | - Breaks | Total Mins | Perf | Rate per sm | Earnings
 | Pay average
 | Operator | Clock no | Grade | In | Out | In | Out | - Breaks | Total Mins | Perf | Rate per sm | Earnings
 | Supervisor :- |  |  |  |  | Manager :-
Spreadsheet: 109627d1306428552-percentage-formula-for-specified-values-average_if-day92
Sheet: Sheet1

1 | 0.2 |  |  | 1
2 | 0.05 |  |  | 2
3 | 0.1 |  |  | 3
4 | 0.15 |  |  | 4
5 | 0.11 |  |  | 5
1 | 0.098 |  |  | 6
7 | 0.09 |  |  | 7
8 | 0.082 |  |  | 8
6 | 0.074 |  |  | 9
9 | 0.066 |  |  | 10
10 | 0.058
1 | 0.05
Spreadsheet: 71398d1272055327-vlookup-across-multiple-tabs-sample
Sheet: Doctor's

RISK RATING | Date Opened | [NAME] | Branch # | Acct #1 | Acct #2 | Acct #3 | Acct #4 | Acct #5
MEDIUM | 2008-01-02 00:00:00 | [NAME]
MEDIUM | 2009-04-27 00:00:00 | [NAME]
MEDIUM | 2008-04-25 00:00:00 | [NAME]
LOW | 2005-12-30 00:00:00 | Walter
LOW | 2002-07-03 00:00:00 | Greg
MEDIUM | 2008-03-27 00:00:00 | [NAME]
Spreadsheet: 65835d1266491122-vlookup-with-changeable-data-book2
Sheet: Sheet1

Author | Title | What I need it to do
[NAME] | cooper (d) | NO
[NAME] | Zanetti (H25386-1) - File Note | NO
Iain MacLauchlan | Clay Construction (H24520-1) - E-mail | NO
[NAME] | Smith (M18889-1) - Letter - Morley | NO
[NAME] | Homekeys (H25516-1) - E-mail | NO
[NAME] | ALL Gough & Kelly (W14724 - 5) - E-mail | Yes
correct format.
(Initial, dept or all)SPACE (Clinet name) SPACE(NUMBER)SPACE-SPACE(Decription)
Spreadsheet: 109559d1306390313-show-rows-that-have-value-in-column-a-or-column-b-sample-travel-schedule
Sheet: Sheet2

Lookup Date | 2011-05-25 00:00:00
Row # | Name | Date of Arrival | Flight # | Flight arrival time | Date of Return | Flight # | Flight departure time
Spreadsheet: 791217d1660213853-count-greater-than-0-numbers-referring-to-last-5-10-and-20-results-draft
Sheet: Result

Product | in Last5 | in last10 | in Last20 | 1 | 2 | 3 | 4 | 5 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53
A |  | 2 | 2
B | 0 | 0 | 0
C | 0 | 0 | 1
D | 0 | 0 | 0
E | 3 | 3 | 3
F | 0 | 1 | 1
G | 0 | 0 | 0
H | 0 | 0 | 0
I | 0 | 0 | 0
J | 0 | 1 | 1
K | 1 | 1 | 1
L | 1 | 1 | 1
M | 0 | 0 | 0
N | 0 | 1 | 1
Spreadsheet: 168126d1342230431-countifs-not-adding-up-example
Sheet: Sheet2

 |  |  | Row 1 | Count if Number 1 = Row 1 and Number 2 is greater than 0 and number 3 is less than or equal to 10 | Count if Number 1 = Row 1 and Number 2 is greater than 0 and number 3 is greater than 10
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
Spreadsheet: daren_farmer__6616__egmnom-Mar
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-207106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-03-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-03-31 00:00:00
RECEIPTS |  |  | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY | DUKE
644 | LONE STAR KATY | RICHARDSON
4132 | EXXON KATY | ECT | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
4132 | EXXON KATY | Kn Marketing 92155 |  |  |  |  |  |  |  |  |  |  | 5000 | 5000 | 5000 | 5000 | 5000
XXXX | IMBALANCE | ENTEX/HPL
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
1563 | COGEN | DYNEGY
1373 | [NAME] | MORGAN STANLEY | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
1485 | OXY BATTLEGROUND | OXY | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
1511 | Port Arthur - Clark | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1505 | DEER PARK | DUPONT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1394 | HILL PETRO | DYNEGY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8001 | AIR LIQUIDE | AIR LIQUIDE
XXXX | IMBALANCE | ENTEX/HPL
 |  | DELIVERY TOTAL
Spreadsheet: 808618d1670535662-need-to-exclude-weekends-from-total-countif-formula-2022-annual-leave-tracker-sample
Sheet: Holidays

General Holidays
Year | Holiday | Act Date | Obs Date | DOW
 | New Year's Day
 | Memorial Day |  |  |  |  | Last Year
 | Independence Day |  |  |  |  | This Year
 | Labor Day |  |  |  |  | Next Year
 | Thanksgiving
 | Christmas
 | New Year's Day
 | Memorial Day
 | Independence Day
 | Labor Day
 | Thanksgiving
 | Christmas
 | New Year's Day
 | Memorial Day
 | Independence Day
 | Labor Day
 | Thanksgiving
 | Christmas
Spreadsheet: chris_dorland__1609__Mirant - Deals Not in Tagg Query1
Sheet: Deals Not in Tagg Query

DATE | DEAL |  | EOL | VOLUME | INDEX | PRICE | FROM | TO | DELIVERY | .CURRENCY | FILE #
2001-02-05 00:00:00 | QP7039.1 | 602017 | N | -3500 |  | 7.645 | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | NIT | CAD | 2
2001-04-30 00:00:00 | V64794.1 | 1135839 | N | 5000 |  | 7.42 | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | NIT | CAD | 2
2001-05-01 00:00:00 | V67831.1 | 762385 | N | 4200 |  | 7.17 | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | NIT | CAD | 2
2001-05-02 00:00:00 | V70968.1 | 765528 | N | 3500 |  | 7.02 | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | NIT | CAD | 2
2001-05-14 00:00:00 | V92532.1 | 785872 | N | 5000 | NYMEX | -0.315 | 2001-11-01 00:00:00 | 2002-10-31 00:00:00 | NIT | USD | 2
2001-06-14 00:00:00 | VG9103.1 | 851584 | N | 5000 | NYMEX | -0.385 | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | NIT | USD | 2
2001-08-23 00:00:00 | VT5299.1 |  | N | 5000 | NYMEX | -0.49 | 2002-11-01 00:00:00 | 2003-03-01 00:00:00 | NIT | USD | 2
2001-09-24 00:00:00 | Y52491.1 |  | Y | 20000 | AECO - C | 0 | 2001-11-01 00:00:00 | 2002-03-01 00:00:00 | NIT | CAD | 2
2001-10-11 00:00:00 | YA2833.1 |  | N | 5000 |  | 3.44 | 2001-11-01 00:00:00 | 2001-11-01 00:00:00 | NIT | CAD | 2
2001-10-26 00:00:00 | YE3026.1 | 759594 | N | 5000 |  | 4.655 | 2001-11-01 00:00:00 | 2002-03-01 00:00:00 | NIT | CAD | 2
Spreadsheet: 20a392d2-7dd8-4e31-8937-15c2a7566f34
Sheet: A

Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
 | AOK Designation | CAR Designation | Comment
American Studies
AMST 309 | Arts & Literature-Literature |  | cross-listed with COMM 309
AMST 350 | Arts & Literature-Literature
AMST 351 | Arts & Literature-Literature
AMST 355 | Arts & Literature-Arts
AMST 356 | Arts & Literature-Literature
AMST 357 | Arts & Literature-Literature
AMST 358 | Arts & Literature-Literature
Arabic
ARAB 211-212 | Foreign Language
Archaeology
ARCH 450 |  | Experiential-Field Study; Capstone | cross-listed with CLAS 450
ARCH 495 |  | Capstone
[NAME]
ARTH 201 | Arts & Literature-Arts
ARTH 202 | Arts & Literature-Arts
ARTH 210 | Arts & Literature-Arts |  | cross-listed with CLAS 210
 | OR [NAME] (as HIST 101) | Non-Western
ARTH 211 | Arts & Literature-Arts | Non-Western | cross-listed with CLAS 211
 |  | Experiential-Travel* | * when course travels-the course does not travel for all offerings
ARTH 212 | Arts & Literature-Arts |  | cross-listed with CLAS 212
ARTH 213 | Arts & Literature-Arts |  | cross-listed with CLAS 213
ARTH 214 | Arts & Literature-Arts |  | cross-listed with CLAS 214
ARTH 215 | Arts & Literature-Arts
ARTH 216 | Arts & Literature-Arts
ARTH 217 | Arts & Literature-Arts |  | cross-listed with CLAS 217
ARTH 218 | Arts & Literature-Arts | Experiential-Travel* | cross-listed with CLAS 218;* when course travels-the course does not travel for all offerings
ARTH 219 | Arts & Literature-Arts
ARTH 221 | Arts & Literature-Arts | Experiential-Travel* | * when course travels-the course does not travel for all offerings
ARTH 222 | Arts & Literature-Arts | Experiential-Travel
ARTH 223 | Arts & Literature-Arts
ARTH 224 | Arts & Literature-Arts
ARTH 225 | Arts & Literature-Arts
ARTH 226 | Arts & Literature-Arts
ARTH 227 | Arts & Literature-Arts | Non-Western
ARTH 228 | Arts & Literature-Arts | Non-Western
ARTH 235 | Arts & Literature-Arts | Non-Western
ARTH 240 | Arts & Literature-Arts
ARTH 305 | Arts & Literature-Arts
ARTH 381 |  | Experiential-Research
ARTH 382 |  | Experiential-Research
ARTH 422 |  | Experiential-Research; Capstone
ARTH 450 |  | Capstone
Arts Management
AMGT 441 |  | Experiential-Internship; Capstone
Astronomy
ASTR 101 | Natural & Mathematical Sciences-Nat Sci w Lab
ASTR 231 | Natural & Mathematical Sciences-Nat Sci w/out Lab
ASTR 232 | Natural & Mathematical Sciences-Nat Sci w/out Lab
Asian Studies
ASTU 230 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 230
ASTU 231 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 231
ASTU 232 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 232
ASTU 233 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 233
ASTU 290 |  | Non-Western | cross-listed with HIST 290
ASTU 292 | Arts & Literature-Arts | Non-Western | cross-listed with FILM 292
ASTU 390 |  | Non-Western
ASTU 401 |  | Capstone
ASTU 450 |  | Experiential-Internship
ASTU 481 |  | Experiential-Research
ASTU 482 |  | Experiential-Research
Spreadsheet: 464215d1464943354-formula-to-count-employees-on-schedule-over-24-hour-period-week-ending-06-12-16-sample2
Sheet: Printable

 | X
Spreadsheet: 438148d1451788871-trouble-deleting-duplicates-shipment-calculation
Sheet: Tasks Per Hour

A
Time: | Shipment | SHP BKSTK | Consigna | CON BKSTK | Movements | Destocking | 25's | Daily Backstock | Maintenance | Customer Checks
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
1900-01-01 00:00:00
1900-01-01 01:00:00
1900-01-01 02:00:00
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: monographs productivity stats

Monographs Productivity Statistics FY09 and FY10
COLLECTION METRICS
 | FY09 | FY10 | % change
Monograph volumes withdrawn | 281 | 728
Monograph volumes added (total) | 9799 | 11532
Firm orders | 3037 | 3507
Standing orders | 168 | 218
Approval plan | 4224 | 3908
Gifts | 2370 | 3899
Media added | 323 | 218
PRODUCTIVITY METRICS
 | FY09 | FY10 | % change
ACQUISITIONS
Requests searched | 3851 | 5096
Duplicates returned | 316 | 291
Titles ordered | 3078 | 3965
Approvals returned | 102 | 56
Invoices processed | 649 | 698
COPY CATALOGING
LC Copy | 6085 | 6591
Edited Copy | n/a | 944 | n/a
Sent to Cataloging | 1428 | 1343
INVENTORY
Barcodes scanned | 2792 | 0
HELIN corrections | 121 | 0
Items found | 40 | 0
No PZ's | 0 | 0 | 0
No items | 2 | 0