tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Market East-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | MidMarket |  | 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 | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  | 0
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -630000 | -1982500
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250000
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 122731 |  | -122731
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 591641
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  | 0
34 |  | Originations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -591641
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -14186602
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -743288
 |  | TOTAL
Spreadsheet: 159730d1338829772-vlookup-based-on-values-from-two-columns-problem
Sheet: Dancers

FirstName | LastName | Skill | State | [NAME]
[NAME] | [NAME] | Ballet | California
[NAME] | Catalino | Tap | London
Natasha | Curtis | Ballet | Australia
Shen | Watson | Modern | Kansas
Spreadsheet: gerald_nemec__11329__Kern Pmt 2 Calcs
Sheet: Summary

Kern Payment 2 Summary
 | July |  | August |  | Total Payment
PCHC
[NAME]
Kennedy Oil
JM Huber
FMI Weld
Patina
Cannon
TOTALS
Spreadsheet: 48295d1247529749-summarizing-complex-data-summarizing_data
Sheet: Sheet1

Date | Company | Invoice | Amount
2009-07-01 00:00:00 | Company X | 1234X | 100
2009-07-01 00:00:00 | Company Y | 4321Y | 150
2009-07-01 00:00:00 | Company Z | 8420Z | 200
2009-07-02 00:00:00 | Company X | 1234X | 100
2009-07-02 00:00:00 | Company Y | 4321Y | 150
2009-07-02 00:00:00 | Company Z | 8420Z | 200
2009-07-03 00:00:00 | Company X | 1234X | 100
2009-07-03 00:00:00 | Company Y | 4321Y | 150
2009-07-03 00:00:00 | Company Z | 8420Z | 200
2009-07-04 00:00:00 | Company X | 1234X | 100
2009-07-04 00:00:00 | Company Y | 4321Y | 150
2009-07-04 00:00:00 | Company Z | 8420Z | 200
2009-07-05 00:00:00 | Company X | 1234X | 100
2009-07-05 00:00:00 | Company Y | 4321Y | 150
2009-07-05 00:00:00 | Company Z | 8420Z | 200
 |  |  |  |  | Date | 2009-07-01 00:00:00
 |  |  |  |  | Sum of Amount
 |  |  |  |  | Company | Invoice | Total
 |  |  |  |  | Company X | 1234X | 100
 |  |  |  |  | Company Y | 4321Y | 150
 |  |  |  |  | Company Z | 8420Z | 200
 |  |  |  |  | Grand Total |  | 450
Spreadsheet: sally_beck__35172__MgmtSum-Q3-0928_Global
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
TOT_ALLOCATION | 3RD QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-09-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
 | Liquids |  | 0 | 0 |  |  |  |  |  |  | 5296 |  | London plan shortfall
COAL | Coal |  | 665 |  |  |  |  |  |  |  |  |  | London plan shortfall
SO2 | Emissions
WEATHER | Weather
INSURANCE | Global Risk Markets |  | 0 |  |  |  |  |  |  | 446
ECT_INV_IRFX | Financial Trading
 | Office of the Chairman |  | 0 | 0 |  |  |  |  |  | 0 | 0
 | Subtotal
 | [NAME] |  |  |  |  |  |  |  |  | 0 | 0
 | Group |  | 0 | 0
 | Total
Spreadsheet: 271908d1382104573-require-a-function-to-return-a-last-non-zero-value-in-a-column-my-requirement
Sheet: Sheet1

Para meter A | 2 |  |  | [NAME]"
Para meter B | 2 |  |  | [NAME]"
[NAME] C | 3
[NAME] D | 4
Sl.No | Input values | Dependent value
1 | 1
2 | 2
3 | 3 |  |  | The value for cells B2, B3, B4, [NAME] are used along with values of B9:B208 to calculate values of C9:C208. Values of the range B9:B208 are generated by a machine from which they are copied and pasted here. The actual range is about 10000, but I have taken only 200 values as an example. I need to find the last non zero values of the columns B and C (i.e.) for ranges B9:B208 and C9:C208. [NAME] using LOOKUP function in the cell F2 is working fine, but similarly when used in cell F3 for " Dependent Value" range, it isn't returning any value.
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 8
10 | 976
11 | 3
12 | 2
13 | 9876
14 | 2.5
15 | 2.5
16 | 2.5
17 | 0
18 | 0
19 | 0
20 | 2.5
21 | 0
22 | 9
23 | 0
24 | 0
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
196
197
198
199
200
Spreadsheet: 58749d1259015581-excel-2007-sort-and-group-numbers-into-lists-howey9
Sheet: Sheet1

8.26 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
11.11 | 4.57 | 5.34 | 6.49 | 7.24 | 8.12 | 9.92 | 10.24 | 11.11
11.33 | 4.66 | 5.75 |  | 7.28 | 8.23 |  | 10.97 | 11.33
4.85 | 4.85 | 5.88 |  | 7.46 | 8.26 |  |  | 11.97
5.75 |  |  |  | 7.9 | 8.33
8.33
7.28
11.97
4.57
7.46
7.24
10.97
4.66
8.12
5.88
8.23
5.34
6.49
10.24
9.92
7.9
Spreadsheet: 595133d1540286734-retail-inventory-calculating-multiple-items-in-a-sale-retail-inventory-23102018
Sheet: Help

Product Name | Current Inventory | Pending Purchases | Re-Order Point | Re-order - Curr Inv | Amount | Quantity | Rank |  |  |  | RANK | PRODUCT NAME | AMOUNT | QUANTITY
Spreadsheet: 382997a1-7d8f-48f5-9af2-c77f9b73772e
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 7. LEASE AND COMMERCIAL FINANCE COMMITMENTS, Stocks and Flows: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Lease Finance - Total commitments ; |  |  | Original | A2413496R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Lease Finance - Commitments not drawn at end of month ; |  |  | Original | A2413497T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Revolving Credit - New and increased credit limits ; |  |  | Original | A2413498V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Revolving Credit - Cancellations and reductions ; |  |  | Original | A2413499W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Revolving Credit - Total credit limits at end of month ; |  |  | Original | A2413500V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Revolving Credit - Credit used at end of month ; |  |  | Original | A2413501W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 109419d1306278676-trying-to-convert-a-data-collection-from-one-format-to-another-format-1-to-format-2
Sheet: Sheet1

 | Jon | [NAME] | [NAME] | Shannon | [NAME]
Sunday, June 26, 2011 | site A | site B | site C | site A | site B
Monday, June 27, 2011 | site B | site C | site A | site B | site C
Tuesday, June 28, 2011 | site C | site A | site B | site C | site A
Wednesday, June 29, 2011 | site A | site B | site C | site A | site B
Thursday, June 30, 2011 | site B | site C | site A | site B | site C
 | site A | site B | site C
Sunday, June 26, 2011 | Jon, Shannon | [NAME], [NAME] | [NAME]
Monday, June 27, 2011 | [NAME] | Jon, Shannon | [NAME], [NAME]
Tuesday, June 28, 2011 | [NAME], [NAME] | [NAME] | Jon, Shannon
Wednesday, June 29, 2011 | Jon, Shannon | [NAME], [NAME] | [NAME]
Thursday, June 30, 2011 | [NAME] | Jon, Shannon | [NAME], [NAME]
Spreadsheet: 68172d1268734789-need-to-return-data-in-excel-not-vlookup-mondays
Sheet: mondays

Monday
2009-03-30 00:00:00 | 100
2009-04-06 00:00:00 | 500
2009-04-13 00:00:00 | 500
2009-04-20 00:00:00 | 700
2009-04-27 00:00:00 | 845
2009-05-04 00:00:00 | 990
2009-05-11 00:00:00 | 1135
2009-05-18 00:00:00 | 1280
2009-05-25 00:00:00 | 1425
2009-06-01 00:00:00 | 1570
2009-06-08 00:00:00 | 1715
Spreadsheet: 180977d1347890676-find-match-a-cell-value-to-another-cell-and-return-all-column-values-book1
Sheet: Sheet1

Name G | Name C | Name C | Name A | Name E | Name F | Name X | Name B
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
11 | 11 | 11 | 11 | 11 | 11 | 11 | 11
12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
17 | 17 | 17 | 17 | 17 | 17 | 17 | 17
18 | 18 | 18 | 18 | 18 | 18 | 18 | 18
19 | 19 | 19 | 19 | 19 | 19 | 19 | 19
20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Spreadsheet: 44902d1243623974-pivot-table-help-copy-of-query
Sheet: Sheet1

Date | Day | Num
2009-03-01 00:00:00 | Sunday | 10
2009-03-02 00:00:00 | Monday | 12
2009-03-03 00:00:00 | Tuseday | 12
2009-03-04 00:00:00 | Wedenesday | 5 |  |  | Output
2009-03-05 00:00:00 | Thursday | 5
2009-03-06 00:00:00 | Friday | 3 |  |  | Sunday | 22
2009-03-07 00:00:00 | Saturday | 12 |  |  | Monday | 20
2009-03-08 00:00:00 | Sunday | 2 |  |  | Tuseday | 30
2009-03-09 00:00:00 | Monday | 2 |  |  | Wedenesday | 10
2009-03-10 00:00:00 | Tuseday | 2 |  |  | Thursday | 0
2009-03-11 00:00:00 | Wedenesday | 32 |  |  | Friday | 11
2009-03-12 00:00:00 | Thursday | 2
2009-03-13 00:00:00 | Friday | 22
2009-03-14 00:00:00 | Saturday | 2
2009-03-15 00:00:00 | Sunday | 22
2009-03-16 00:00:00 | Monday | 2
2009-03-17 00:00:00 | Tuseday | 2
2009-03-18 00:00:00 | Wedenesday | 11
2009-03-19 00:00:00 | Thursday | 11 |  | The requirment is :  from the raw data on the left , I want to get the Sum of numbers for the weekdays for entire month either using [NAME] or any other means - I tried Pivot but propabaly due to lack of my understanding of the same the desired result was not recived
2009-03-20 00:00:00 | Friday | 12
2009-03-21 00:00:00 | Saturday | 11
2009-03-22 00:00:00 | Sunday | 1
2009-03-23 00:00:00 | Monday | 22
2009-03-24 00:00:00 | Tuseday | 1
2009-03-25 00:00:00 | Wedenesday | 1 |  | Sum of Num
2009-03-26 00:00:00 | Thursday | 11 |  | Day | Total
2009-03-27 00:00:00 | Friday | 22 |  | Monday | 46
2009-03-28 00:00:00 | Saturday | 33 |  | Thursday | 29
2009-03-29 00:00:00 | Sunday | 3 |  | Friday | 59
2009-03-30 00:00:00 | Monday | 8 |  | Saturday | 58
2009-03-31 00:00:00 | Tuseday | 9 |  | Sunday | 38
 |  | 305 |  | Tuseday | 26
 |  |  |  | Wedenesday | 49
 |  |  |  | Grand Total | 305
Spreadsheet: 135939d1326313272-formula-countif-multiple-ranges-with-one-criteria-dynamic_by_row
Sheet: Summary

Automated Claim Denials
1. Total number of automated claims denials: |  |  | 5
2. Total (estimated) associated dollars associated with automated claim denials: |  |  | 511.05
3. Total dollars recouped for automated claim denials: |  |  | 511.05
Underpayments
1. Total number of claims identified as underpayments: |  |  | 0
2. Estimate the total dollars associated with underpayments: |  |  | #N/A
3. Total dollars returned to facility: |  |  | #N/A
Complex Claim Denials
1.  Total number of medical record requests received |  |  | 0 |  | 1A.  Total dollar value of the claims associated with the medical records requested |  |  | 3456814.069999998
2.  Total number of medical records approved |  |  | #N/A |  | 2A.  Total dollar value of medical records approved |  |  | #N/A
3.  Total number of medical records where an overpayment was identified (i.e. denied) |  |  | #N/A |  | 3A.  Total dollar value of medical records in which an overpayment was identified (i.e. denied) |  |  | #N/A
4.  Total number of medical records pending determination by the RACs |  |  | 300372.25 |  | 4A.  Total dollar value of medical records pending determination
5.  Estimate the total dollars associated with the overpayments identified during medical record review (complex claim denials) |  |  |  |  | 6. Report the total dollars recouped to date for complex claim denials |  |  | 190874.9100000001
Spreadsheet: 274649d1383170423-change-days-to-hours-on-a-template-ts1027802351-edited-
Sheet: Settings

 | List of Employees | Bucket |  | Type of Leave |  | Company Holidays | Description
 | Brent Hayes | 120 |  | Sick
 | [NAME] |  |  | Vacation
 | [NAME] |  |  | Floating Holiday
 | [NAME] |  |  | Other
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Wade Lowery
 | [NAME]
Spreadsheet: 329882d1404444742-determine-date-given-day-of-year-and-year-book1
Sheet: Sheet1

Day of Year | YEAR | DATE
273 | 2007 | dd/mm/yy
188 | 2005
240 | 2005
94 | 2007
65 | 2010
278 | 2003
279 | 2006
313 | 2006
35 | 2005
183 | 2007
85 | 2006
208 | 2010
280 | 2014
72 | 2003
346 | 2004
296 | 2008
153 | 2011
256 | 2007
Spreadsheet: 163017d1340149099-make-a-repair-and-maintenance-report-with-printable-form-testing
Sheet: Sheet2

 |  |  | RMR# | 238
 | DATE: |  |  |  | SERVICE TYPE :
 | ESN# :
 | VAN # :
 | PART # |  | [NAME] |  | QUANTITY |  | REMARKS :
 | 1
Spreadsheet: 689626d1596561063-conditional-formatting-rule-comparing-multiple-date-ranges-sample
Sheet: Sheet1

 |  |  |  |  | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of
 |  |  |  |  | 2020-08-03 00:00:00
Resource | Project | Start Date | End Date | Task | 2020-08-09 00:00:00
Resource 1
 | Project Sample
 |  | 2020-09-24 00:00:00 | 2020-10-22 00:00:00 | Task 1
 |  | 2020-10-05 00:00:00 | 2020-10-16 00:00:00 | Task 2
 |  | 2020-10-07 00:00:00 | 2020-11-14 00:00:00 | Task 3
Spreadsheet: 838441d1691009740-excel-calander-employee-absence-schedule12023
Sheet: May

 | Absence Type Key | AL | Annual Leave |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | May | Dates of Absence
 | Employee Name | 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 | Total Days | AL | Personal | Sick
 | [NAME] | BH
 | [NAME] | BH
 | Alsop | BH
 | [NAME] | BH
 | [NAME] | BH
 | Avery | BH
 | Bailey | BH
 | [NAME] | BH
 | [NAME] | BH
 | Bell | BH
 | Berry | BH
 | Black | BH
 | Blake | BH
 | Bond | BH
 | Bower | BH
 | [NAME] | BH
 | Buckland | BH
 | Burgess | BH
 | Butler | BH
 | Cameron | BH
 | Campbell | BH
 | [NAME] | BH
 | Chapman | BH
 | Churchill | BH
 | [NAME] | BH
 | Clarkson | BH
 | [NAME] | BH
 | Cornish | BH
 | [NAME] | BH
 | Davies | BH
 | [NAME] | BH
 | [NAME] | BH
 | [NAME] | BH
 | Dyer | BH
 | Edmunds | BH
 | [NAME] | BH
 | Ferguson | BH
 | Fisher | BH
 | [NAME] | BH
 | [NAME] | BH
 | [NAME] | BH
 | [NAME] | BH
 | Glover | BH
 | [NAME] | BH
 | Grant | BH
 | Gray | BH
 | Greene | BH
 | [NAME] | BH
 | Hardacre | BH
 | [NAME] | BH
Spreadsheet: 858393d1707114163-extract-time-in-a-cell-book2
Sheet: Sheet1

Chat Duration | Hour | Minute | Second
9 Mins 2 Secs
32 Secs
49 Mins 49 Secs
20 Secs
9 Mins 17 Secs
1 Min 20 Secs
5 Secs
1 Min 17 Secs
7 Mins 58 Secs
32 Mins 12 Secs
2 Mins 7 Secs
54 Secs
12 Mins 38 Secs
53 Secs
10 Mins 1 Sec
24 Mins 58 Secs
2 Hours 6 Mins
8 Mins 30 Secs
2 Hours 37 Mins
8 Mins 47 Secs
14 Mins 59 Secs
23 Mins 40 Secs
29 Mins 50 Secs
11 Secs
9 Mins 13 Secs
9 Mins 22 Secs
55 Secs
9 Mins 35 Secs
2 Hours 7 Mins
9 Mins 51 Secs
11 Secs
10 Mins 4 Secs
7 Mins 30 Secs
10 Mins 12 Secs
2 Hours 5 Mins
25 Secs
39 Mins 6 Secs
7 Mins 41 Secs
5 Mins 22 Secs
24 Mins 45 Secs
19 Secs
40 Secs
11 Mins 14 Secs
51 Secs
3 Mins 24 Secs
8 Mins 49 Secs
34 Secs
9 Mins 13 Secs
9 Mins 34 Secs
6 Secs
10 Mins 13 Secs
10 Mins 21 Secs
10 Mins 41 Secs
14 Mins 1 Sec
8 Mins 1 Sec
11 Mins 21 Secs
8 Mins 30 Secs
17 Mins 27 Secs
8 Mins 37 Secs
7 Mins 8 Secs
9 Mins 9 Secs
1 Min 13 Secs
2 Mins 33 Secs
9 Mins 56 Secs
25 Secs
36 Mins 38 Secs
18 Secs
12 Secs
4 Mins 49 Secs
1 Min 18 Secs
Spreadsheet: fe77991a-487e-4d54-a899-e4ac3f6bfdff
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
HEAB | Test | HEAB | [NAME], Serum | [NAME], S | Chemiluminescence Immunoassay (CIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL  Collection Instructions: Spin down and immediately remove serum from clot.  Additional Information: 1. Date of draw is required. 2. If ordered with HBVQU/88634 Hepatitis B Virus DNA Detection and Quantification by Real-Time PCR, Serum; send separate vials. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Red top | Negative See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86707 |  |  |  |  | Rochester
HEAB | [NAME] | SST | Serum SST |  |  |  | Frozen
HEAB | Result | HEAB | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 21448d1208980088-count-within-a-month-suicide-assessments
Sheet: Sheet1

Month | Date | DOW | Time | Client | Received Suicide Assessment
April | 2008-04-04 00:00:00 | Fri | 16:45:00 | Pan, [NAME] | 1
April | 2008-04-04 00:00:00 | Fri | 20:00:00 | Pan, [NAME] | 1 |  | Count of Client | Month
April | 2008-04-06 00:00:00 | Sun | 18:50:00 | Pan, [NAME] | 1 |  | Received Suicide Assessment | April | May | Grand Total
April | 2008-04-08 00:00:00 | Tue | 21:20:00 | Squarepants, Spongebob | 1 |  | 1 | 7 | 1 | 8
April | 2008-04-08 00:00:00 | Tue | 10:05:00 | [NAME], [NAME] | 1 |  | Grand Total | 7 | 1 | 8
April | 2008-04-08 00:00:00 | Tue | 17:06:00 | [NAME], [NAME] | 1
April | 2008-04-04 00:00:00 | Fri |  | Pan, [NAME] | 1
May | 2008-04-05 00:00:00 | Sat | 17:30:00 | [NAME], [NAME] | 1 |  |  | April | May
 |  |  |  |  |  |  |  | 7 | 1
 |  |  |  |  |  |  |  | 7 | 1
Spreadsheet: 740012d1626139513-formula-to-pull-only-the-differences-between-sheets-occ-geo-template-sample-7-11-2021-3-
Sheet: (B) ExistingOCC

Employee Number | First Name | Last Name | Location | Position | Term Date | OCC
200245 | KRISTIN | KOKBORG | Cordova - 201 - LFS AK Production | 91011 - LFS AK Production - MP6100 - NET HANGER - GILLNET | 44274.9993055556 | 45-3011
200490 | GENEVIEVE | LUCCHETTI FELIX | Cordova - 201 - LFS AK Sales | 91021 - LFS AK Sales - SM0110 - SALES CLERK - LFS | 44029.9993055556 | 41-2011
200609 | TIMOTHY | MCALLISTER | Naknek - 404 - LFS AK Production | 91011 - LFS AK Production - MP6100 - NET HANGER - GILLNET | 44051.9993055556 | 53-7062
200723 | TUAN | NGUYEN | Dillingham - 405 - LFS AK Production | 91011 - LFS AK Production - MP6100 - NET HANGER - GILLNET | 44377.9993055556 | 45-3011
200802 | RUBEN | RAMIREZ | Anchorage - 503 - LFS AK Sales | 91021 - LFS AK Sales - SM0150 - SALES CLERK - LFS SEASONAL | 42960.9993055556 | 41-2031
200928 | [NAME] | SMITH | Cordova - 201 - LFS AK Production | 91011 - LFS AK Production - MP6100 - NET HANGER - GILLNET | 44286.9993055556 | 53-7062
201059 | [NAME] | BANKS | Cordova - 201 - LFS AK Production | 91011 - LFS AK Production - MP6110 - NET HANGER - SEINE | 44256.9993055556 | 45-3011
201520 | [NAME] | GREGORY JR | Naknek - 404 - LFS AK Sales | 91021 - LFS AK Sales - HS0650 - HOUSEKEEPING - AK NO R/B | 44060.9993055556 | 37-2012
201661 | LEIF CHRISTIAN | VAN CISE | [NAME] | 91021 - LFS AK Sales - SM0150 - SALES CLERK - LFS SEASONAL | 44060.9993055556 | 41-2011
201752 | KELSEY | QUINN | Homer - 303 - LFS AK Production | 91011 - LFS AK Production - MP6100 - NET HANGER - GILLNET | 44218.9993055556 | 45-3011
201758 | WAYNE | QUINN | Homer - 303 - LFS AK Production | 91011 - LFS AK Production - MP6100 - NET HANGER - GILLNET | 44075.9993055556 | 45-3011
202545 | NATHAN | COOK | Homer - 303 - LFS AK Production | 91011 - LFS AK Production - MP6100 - NET HANGER - GILLNET | 44342.9993055556 | 45-3011
202734 | CHASE | CRAUTHERS | Homer - 303 - LFS AK Warehouse | 91031 - LFS AK Warehouse - PS3110 - Warehouse Worker - AK LFS | 43013.9993055556 | 53-7062
203195 | BRANDON | MAXWELL | Cordova - 201 - LFS AK Production | 91011 - LFS AK Production - MP6110 - NET HANGER - SEINE | 44256.9993055556 | 45-3011
203195 | BRANDON | MAXWELL | Cordova - 201 - LFS AK Production | 91011 - LFS AK Production - MP6110 - NET HANGER - SEINE | 44256.9993055556 | 53-7062
500079 | ABEL | HERNANDEZ | [NAME] | 11002 - AK C/P Production - MP1770 - FACTORY MANAGER - CASE | 44295.9993055556 | 51-1011
501287 | CONNIE | CORPUS | [NAME] | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 44352.9993055556 | 51-3022