tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0d2603a3-9f96-43e7-9bc7-5d47a2cf9923
Sheet: Segment Results 

Lockheed [NAME]
Business Segment Summary Operating Results
(unaudited; in millions)
 |  | Quarters Ended
 |  | March 30, 2014 |  | March 31, 2013 |  |  | % Change
Net sales
Aeronautics |  | 3386 |  | 3186 |  |  | 6 | %
Information Systems & Global Solutions |  | 1910 |  | 2106 |  |  | -9 | %
Missiles and Fire Control |  | 1867 |  | 1988 |  |  | -6 | %
Mission Systems and Training |  | 1628 |  | 1830 |  |  | -11 | %
Space Systems |  | 1859 |  | 1960 |  |  | -5 | %
Total net sales |  | 10650 |  | 11070 |  |  | -4 | %
Operating profit
Aeronautics |  | 393 |  | 379 |  |  | 4 | %
Information Systems & Global Solutions |  | 174 |  | 189 |  |  | -8 | %
Missiles and Fire Control |  | 358 |  | 344 |  |  | 4 | %
Mission Systems and Training |  | 250 |  | 201 |  |  | 24 | %
Space Systems |  | 254 |  | 230 |  |  | 10 | %
Total business segment operating profit |  | 1429 |  | 1343 |  |  | 6 | %
Unallocated, net
FAS/CAS pension adjustment
FAS pension expense |  | -313 |  | -487
Less: CAS cost |  | 399 |  | 366
FAS/CAS pension income (expense)1 |  | 86 |  | -121 |  | -622
Special item - severance charges2 |  | - |  | -30
Stock-based compensation |  | -48 |  | -53 |  | -129
Other, net |  | -35 |  | -20 |  | -160
Total unallocated, net |  | 3 |  | -224
Total consolidated operating profit |  | 1432 |  | 1119 |  |  | 28 | %
Operating margins
Aeronautics |  |  | % |  | %
Information Systems & Global Solutions |  |  | % |  | %
Missiles and Fire Control |  |  | % |  | %
Mission Systems and Training |  |  | % |  | %
Space Systems |  |  | % |  | %
Total business segment operating margins |  |  | % |  | %
Total consolidated operating margins |  |  | % |  | %
1 The change in the FAS/CAS pension adjustment from expense to income between the periods was due to lower FAS pension expense in 2014 primarily
as a result of the increase in the discount rate used in the measurement of the Corporation’s GAAP postretirement benefit plan obligations at the end of
2013, and incrementally higher CAS costs in 2014 as a result of phasing in the CAS Harmonization rules as discussed in the Corporation’s Annual
Report on Form 10-K for the year ended Dec. 31, 2013.
2 Severance charges during the first quarter of 2013 consisted of amounts, net of state tax benefits, associated with the elimination of certain positions at
the Corporation's Information Systems & Global  Solutions business segment.  Severance charges for initiatives that are not significant are included in
business segment operating profit.
Spreadsheet: 852945d1702920244-lookup-and-return-the-dates-falls-between-from-and-to-date-return-dates-falls-between-from-and-to-date
Sheet: Sheet2

ID Number | From Date | To Date | Number Of Days
30153 | 2021-06-12 00:00:00 | 2021-06-30 00:00:00
30153 | 2021-07-01 00:00:00 | 2021-07-05 00:00:00
30153 | 2021-07-10 00:00:00 | 2021-07-31 00:00:00
30165 | 2021-07-26 00:00:00 | 2021-07-31 00:00:00
30153 | 2021-08-01 00:00:00 | 2021-08-08 00:00:00
30675 | 2021-08-19 00:00:00 | 2021-08-22 00:00:00
30159 | 2021-08-23 00:00:00 | 2021-08-31 00:00:00
30159 | 2021-09-01 00:00:00 | 2021-09-16 00:00:00
30114 | 2021-09-02 00:00:00 | 2021-09-16 00:00:00
30165 | 2021-09-18 00:00:00 | 2021-09-18 00:00:00
30675 | 2021-09-27 00:00:00 | 2021-09-30 00:00:00
30675 | 2021-10-01 00:00:00 | 2021-10-11 00:00:00
30675 | 2021-10-18 00:00:00 | 2021-10-24 00:00:00
30165 | 2021-11-20 00:00:00 | 2021-11-25 00:00:00
30165 | 2021-11-26 00:00:00 | 2021-11-30 00:00:00
30165 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
30114 | 2021-12-06 00:00:00 | 2021-12-12 00:00:00
30165 | 2021-12-13 00:00:00 | 2021-12-13 00:00:00
30114 | 2022-01-10 00:00:00 | 2022-01-31 00:00:00
30159 | 2022-01-17 00:00:00 | 2022-01-31 00:00:00
30114 | 2022-02-01 00:00:00 | 2022-02-13 00:00:00
30159 | 2022-02-12 00:00:00 | 2022-02-19 00:00:00
30159 | 2022-02-20 00:00:00 | 2022-02-20 00:00:00
30159 | 2022-02-23 00:00:00 | 2022-02-28 00:00:00
30159 | 2022-03-01 00:00:00 | 2022-03-06 00:00:00
30165 | 2022-03-19 00:00:00 | 2022-03-31 00:00:00
30675 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00
30165 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
30675 | 2022-04-04 00:00:00 | 2022-04-17 00:00:00
30114 | 2022-04-25 00:00:00 | 2022-04-25 00:00:00
30165 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00
30675 | 2022-05-30 00:00:00 | 2022-05-31 00:00:00
30675 | 2022-06-01 00:00:00 | 2022-06-12 00:00:00
30165 | 2022-06-06 00:00:00 | 2022-06-30 00:00:00
30165 | 2022-07-01 00:00:00 | 2022-07-31 00:00:00
30153 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00
30153 | 2023-05-01 00:00:00 | 2023-05-31 00:00:00
30153 | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
Spreadsheet: 10e30497-1abc-45a7-a196-aad392390512
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 48. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (NT), Original (Number, $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
1. . . [NAME] ; |  |  | Original | A2413737T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413738V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413739W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413740F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413741J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413742K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413743L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413744R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413745T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413746V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413747W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 492314d1481031669-formula-to-copy-filtered-data-to-another-tab-example
Sheet: Output

Code | Type | Number
AAA | Project | 1
BBB | Major Project | 2
CCC | Minor Project | 3
AAA | Project | 7
BBB | Major Project | 8
AAA | Minor Project | 9
BBB | Major Project | 16
AAA | Minor Project | 17
BBB | Project | 18
BBB | Minor Project | 21
CCC | Minor Project | 22
BBB | Minor Project | 24
AAA | Project | 25
Spreadsheet: 09fe1b17-9541-4a15-a8af-fe8b018654c2
Sheet: PV

n | 216 |  | month | net worth at the end of the month |  | Intrinsic
P |  |  | 0 | 14481.69909469767
X | 200 |  | 1
F | 120000 |  | 2
rate | 0.005 |  | 3
(1 + rate)^n |  |  | 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
 |  |  | 196
 |  |  | 197
 |  |  | 198
 |  |  | 199
 |  |  | 200
 |  |  | 201
 |  |  | 202
 |  |  | 203
 |  |  | 204
 |  |  | 205
 |  |  | 206
 |  |  | 207
 |  |  | 208
 |  |  | 209
 |  |  | 210
 |  |  | 211
 |  |  | 212
 |  |  | 213
 |  |  | 214
 |  |  | 215
 |  |  | 216
Spreadsheet: 543084d1508234377-pivot-not-showing-data-when-data-is-present-pivot-not-showing-data-when-data-is-present-pivot-example
Sheet: Data

Year | Supplier | Store | Jan | Feb | Mar | Apr | May | Jun | Jul
2016 | [NAME] | a | 0 | 0 | 1188 | 0 | 893 | 0 | 0
2016 | [NAME] | b | 0 | 0 | 0 | 0 | 0 | 512.5 | 0
2016 | [NAME] | c | 75 | 0 | 0 | 0 | 863.73 | 863.73 | 0
2016 | [NAME] | d | 0 | 0 | 75 | 0 | 943.23 | 726.73 | 1159.73
2016 | [NAME] | e | 0 | 0 | 0 | 0 | 0 | 0 | 0
2016 | [NAME] | a | 7575 | 0 | 0 | 0 | 0 | 649.5 | 0
2016 | [NAME] | b | 0 | 386 | 0 | 0 | 0 | 647.23 | -214.23
2016 | [NAME] | c | 0 | 0 | 0 | 4545 | 0 | 0 | 433
2016 | [NAME] | d | 772 | 0 | 0 | 0 | 647.23 | 0 | 945.5
2016 | [NAME] | e | 0 | 0 | 0 | 0 | 0 | 1263.5 | 808.5
2016 | [NAME] | f | 0 | 5485 | 0 | 0 | 0 | 863.73 | 0
2016 | [NAME] | a | 0 | 0 | 0 | 45 | 0 | 0 | 0
2016 | [NAME] | b | 0 | 0 | 7575 | 0 | 0 | 0 | 0
2016 | [NAME] | c | 4324 | 5 | 0 | 0 | 293.73 | -293.73 | 0
2016 | [NAME] | d | 0 | 0 | 75 | 868 | 0 | 0 | 1515.5
2017 | bill | a | 0 | 74 | 0 | 0 | 0 | 0 | 159
2017 | bill | b | 0 | 0 | 0 | 0 | 0 | 0 | 729
2017 | bill | c | 0 | 0 | 0 | 0 | 0 | 649.5 | 0
2017 | bill | d | 0 | 0 | 52445 | 56896 | 0 | 0 | 866
2017 | [NAME] | a | 45 | 0 | 0 | 0 | 0 | 0 | 0
2017 | [NAME] | b | 0 | 0 | 0 | 0 | 0 | 433 | 216.5
2017 | [NAME] | c | 0 | 545 | 0 | 0 | 0 | 0 | 0
2017 | [NAME] | d | 4242 | 0 | 0 | 7575 | 866 | 0 | 0
2017 | [NAME] | e | 0 | 0 | 0 | 0 | 433 | 649.5 | 0
2017 | [NAME] | a | 0 | 0 | 0 | 0 | 0 | 0 | 433
2017 | [NAME] | b | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017 | [NAME] | c | 45 | 47527 | 757 | 6 | 0 | 0 | 0
2017 | [NAME] | d | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017 | [NAME] | a | 0 | 0 | 0 | 0 | 159 | 0 | 216.5
2017 | [NAME] | b | 0 | 45 | 0 | 45 | 0 | 0 | 649.5
2017 | [NAME] | c | 0 | 0 | 0 | 0 | 0 | 428.46 | 0
2017 | [NAME] | d | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017 | [NAME] | e | 455 | 4545 | 0 | 6886 | 0 | 0 | 0
2017 | [NAME] | f | 0 | 0 | 0 | 688 | 433 | 0 | 0
Spreadsheet: 214838d1361147298-vlookup-function-bsbitu402a-part-a-task-2
Sheet: Sheet2

Employee Name | Base Weekly Salary | Sales Generated | Commission Percentage | Commission Payable | Total Pay Inc. Comm
Alman, D
Arnold, K
Childs, F
Craddock, L
Dale, P
[NAME], L
Debelak, G
Dunston, C
Fellows, M
Gates, J
Heaney, B
Lane, C
Linnis, P
Mackenzie, T
Mcguiness, A
Mok, R
Palmer, K
[NAME], K
Rugger, L
[NAME], J
Sargent, A
Scott, W
Simpson, M
[NAME], P
Total
Spreadsheet: 801871d1666445531-excel-extract-word-from-sentences-test-work
Sheet: WORK

FILENAMES | RESULTS (keywords1) | RESULTS (keywords2)
[NAME] ipsum dolor sit amet. [NAME] adipiscing elit.
N002 [NAME] in urna sed dolor Eastbourne. Paris tristique molestie eget [NAME].
[NAME] et massa sit amet [NAME] rutrum quis condimentum [NAME].
N004 Vivamus ut tortor ornare. [NAME]. lacinia elit.
N005 Integer maximus Orlando. Alabama. est quis magna scelerisque aliquam. 1900.
N006 Morbi iaculis risus eget elementum aliquam.
N007 Mauris in sapien ac enim sollicitudin interdum.
N008 Vestibulum dapibus elit London iaculis feugiat [NAME] molestie.
[NAME] id nisi quis lectus Lyon gravida cursus.
N010 Nullam sed dolor auctor. [NAME] eros quis. ultrices arcu.
N011 Donec finibus [NAME] urna tincidunt. a consectetur [NAME].
[NAME] at ipsum non nibh tincidunt tempor a sed orci. 1901.
N013 Integer dignissim ligula Buckfast vitae tellus ullamcorper feugiat quis ac enim.
N014 Phasellus parislyon pretium mi sed odio volutpat rutrum.
N015 Nullam dignissim new york [NAME] blandit tempor. 1902.
N016 Ut [NAME] tincidunt sapien sollicitudin. pulvinar odio in. euismod tellus.
N017 In Brighton vulputate elit nec ornare aliquet.
[NAME] non tellus in nisi congue aliquet. 1903.
N019 Quisque pretium ex non velit commodo. vitae egestas mi pellentesque.
N020 Suspendisse sollicitudin eros eget nulla vulputate.
N021 Sit amet consequat dolor ornare.
Spreadsheet: 865917d1712868586-one-value-in-multi-cell-to-return-multi-all-instances-help-formula-help-tingler0-
Sheet: Sheet1

Site | Patient Name | Patient SSN | Surgery Date Time | Prosthesis Name | Prosthesis Model | Prosthesis [NAME] | Prosthesis Vendor | Sterile Rspsblty Code | Device Qty | Implant Sterility Checked | Sterility Expiration Date | Lot Number | Serial Number | Verifier Staff | Provider Read Back Performed
626 | G*****,A******* | *******498 | 2023-08-23 07:59:00 | FEMORAL COMPONENT | 5510F601 | #6 | STRYKER | M | 1 | Y | 2025-02-15 00:00:00 | JS44P | No Serial Number | SPAIN,[NAME] | Y
626 | S****,S***** | *******906 | 2023-11-15 07:30:00 | ANCHOR | AR-1662PSL-7 | 7 X 19.5MM | ARTHREX | M | 1 | Y | 2028-04-30 00:00:00 | 15088661 | No Serial Number | BROWN,TIFFANY NICOLE | Y
626 | T*****,T***** | ******061 | 2018-04-19 07:58:00 | VASCULAR GRAFT | M002020852010 | 20 X 10 MM X 40 CM | MAQUET | M | 1 | Y | 2022-03-31 00:00:00 | 17D05 | [PHONE] | TONEY,CYNTHIA A | Y
626 | T****,T***** | ******061 | 2023-06-26 07:30:00 | CAROTID PATCH | GTIN 00384401015208-RIGHT CAROTID | 8 X 75MM | MAQUET | M | 1 | Y | 2024-10-31 00:00:00 | 19L14 | [PHONE] | ELLIOTT,HEATHER M | Y
626 | G*****,A******* | ******498 | 2023-08-23 07:59:00 | CEMENT - BONE | 61911010 | NA | MAN | M | 2 | Y | 2025-10-31 00:00:00 | RBE174 | 07006315M | SPAIN,[NAME] | Y
626 | G*****,A******* | ******498 | 2023-08-23 07:59:00 | PATELLAR COMPONENT | 5551G350E | [NAME] THKNS-10MM | STRYKER | M | 1 | Y | 2028-04-29 00:00:00 | XW37 | No Serial Number | SPAIN,[NAME] | Y
626 | G*****,A******* | ******498 | 2023-08-23 07:59:00 | TIBIAL BASE PLATE/TRAY | 5520B500 | #5 | STRYKER | M | 1 | Y | 2028-03-24 00:00:00 | YAT2T | No Serial Number | SPAIN,[NAME] | Y
626 | P****,S******* | ******650 | 2023-06-30 08:43:00 | MESH | 59500007 | 1.7" | BARD | M | 1 | Y | 2024-06-08 00:00:00 | HUGU2221 | . | TODD,[NAME] | Y
626 | L****,N***** | ******752 | 2023-06-09 08:27:00 | MESH | 5950007 | 4.3 CM | BARD | M | 1 | Y | 2024-11-28 00:00:00 | HUGZ0523 | No Serial Number | TONEY,CYNTHIA A | Y
626 | G****,E***** | ******868 | 2020-09-02 08:00:00 | VASCULAR GRAFT | M00202175430P0 | 30mm X 30cm | MAQUET | M | 1 | Y | 2024-10-31 00:00:00 | 19L27 | [PHONE] | PAUL,[NAME] | Y
626 | S*****,S***** | ******906 | 2023-11-15 07:30:00 | ANCHOR | [NAME] | 3.5 MM | TORNIER | M | 1 | Y | 2025-01-04 00:00:00 | AH64605 | No Serial Number | BROWN,TIFFANY NICOLE | Y
626 | M***,J**** | ******961 | 2023-02-22 07:45:00 | MITRAL VALVE | 310C29 | 29MM | MOSAIC | M | 1 | Y | 2025-09-30 00:00:00 | No Lot Number | D470992 | DOMINGUEZ,ANDREW | Y
626 | S*****,E**** | *****782 | 2020-01-09 13:32:00 | EAR VENTILATION TUBE | 1010030 | 1.14 MM D | MEDTRONIC | M | 1 | Y | 2027-01-15 00:00:00 | [PHONE] | No Serial Number | MEADE,LORI A | Y
626 | E****,R**G** | ******653 | 2023-11-29 07:38:00 | MESH | 5950007 | 4.3CM/1.7" | BARD | M | 1 | Y | 2025-02-28 00:00:00 |  | HUHQ0257 | No Serial Number |  | KURKOWSKI,[NAME] | Y
626 | W***,J**** | *****158 | 2023-08-04 10:41:00 | MESH | 5950007 | 4.3CM/1.7" | BARD-DAVOL | M | 1 | Y | 2025-02-28 00:00:00 |  | HUHQ0257 | No Serial Number |  | PECK,SARA CHRISTINE | Y
Spreadsheet: 108508d1305567403-need-to-find-formula-s-to-reformat-spread-mergelistexample
Sheet: Final Mailing List May 11 2011

DoctorFirst | DoctorLast | DoctorAdd1 | PatientFirst | PatientLast | PatientAdd1
TOM | CRUMBS | NEW YORK | [NAME] | SMITH | NEW YORK
TOM | CRUMBS | NEW YORK | ROB | SUN | NEW YORK
TOM | CRUMBS | NEW YORK | [NAME] | JACOBS | NEW JERSEY
TOM | CRUMBS | NEW YORK | MARY | LANE | RHODE ISLAND
MARY | ADAMS | MAINE | ART | GORDON | MAINE
MARY | ADAMS | MAINE | RACHEL | SMITH | MAINE
TOM | LAWSON | [NAME] | [NAME] | [NAME] | CONNETICUT
TOM | LAWSON | [NAME] | JACOB | KORR | [NAME]
TOM | LAWSON | [NAME] | SAM | WINTER | CONNETICUT
Spreadsheet: 732047d1620751724-pivot-table-calculation-field-power-query-to-produce-a-calculated-field-bttfin-
Sheet: calculation fiield

 |  |  | Dept# | Type | Amount
 |  |  | 1178 | Budget | 7441581.016612891
 |  |  | 1178 | Grant | 1624373.061435041
 |  |  | 1178 | Infrastucture | 2358668.781638639
 | Table |  | 1178 | Projects | 71727.77035511735
 |  |  | 1178 | Technology | 483244.1054255351
 |  |  | 1982 | Budget | 407327.7032340139
 |  |  | 1982 | Grant | 6243504.334392482
 |  |  | 1982 | Infrastucture | 1582005.761518852
 |  |  | 1982 | Projects | 473740.0782077953
 |  |  | 1982 | Technology | 1016031.534617374
 |  |  |  | Sum of Amount | Column Labels |  |  |  |  | I want to create this formula!
 |  |  |  | Row Labels | Budget | Grant | Infrastucture | Projects | Technology
 |  |  |  | 1178 | 5351608.430079562 | 6335703.767161363 | 2481183.520325623 | 666507.9105846069 | 255393.2201920023 | (budget + Grant) -( infrastucute +projects +technology) =
 |  |  |  | 1982 | 7885520.712215452 | 3413796.223045015 | 2056971.186506599 | 315493.1620303463 | 1582595.104725666 | (budget + Grant) -( infrastucute +projects +technology) =
 |  |  |  | Dept# | Budget | Grant | Infrastucture | Projects | Technology | Budget + Grant | Infrastructure + Projects + Technology | Result
 |  |  |  | 1178 | 7441581.016612891 | 1624373.061435041 | 2358668.781638639 | 71727.77035511735 | 483244.1054255351 | 9065954.078047931 | 2913640.657419292 | 6152313.420628639
 |  |  |  | 1982 | 407327.7032340139 | 6243504.334392482 | 1582005.761518852 | 473740.0782077953 | 1016031.534617374 | 6650832.037626497 | 3071777.374344022 | 3579054.663282475
Spreadsheet: 79f6629d-27bc-49e6-9b8a-a08494f396cd
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
[NAME] | Test | [NAME] | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6257-0 | Fragaria [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 484552d1476319221-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria-bvj-
Sheet: Sheet1

 |  |  |  | Example 1
 |  |  |  |  | date chosen
 |  |  |  |  |  | Summary | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12
 |  |  |  |  |  |  |  | 3
 |  |  |  |  | A1 |  | 10 |  | 456 |  | 65423 |  |  | 45
 |  |  |  |  | A2 |  | 5 | 24 |  |  | 54564 | 56 |  | 5956 |  |  | 8
 |  |  |  |  | A3 |  | 2 |  |  |  |  | 3 |  | 6 | 2
 |  |  |  |  | A4 |  | 20 | 234 | 34234 | 4 | 5 |  | 5 |  |  |  | 56
 |  |  |  |  | A5 |  | 304 |  |  |  |  | 4 |  | 4 | 5
 |  |  |  |  | A6 |  | 405 |  |  | 53 |  | 4 |  | 5
 |  |  |  |  | A7 |  | 435 | 3243 |  |  |  | 678 |  |  | 867
 |  |  |  |  | A8 |  | 45 |  |  | 768 | 67 | 7
 |  |  |  |  | A9 |  |  |  |  |  | 234 |  |  | 7756454
 |  |  |  |  | A10 |  | 78 | 67 |  |  |  |  | 234 |  | 234
 |  |  |  |  | A11 |  | 67 |  |  | 34 |  |  |  | 234 |  | 435
 |  |  |  |  | A12 |  |  | 173 | 45 | 5856 |  | 738 |  | 358 | 56
 |  |  |  |  |  |  | pick first M#
 |  |  |  |  |  | choose last column | M9 | <------
 |  |  |  |  | Areas | M10
 |  |  |  |  | A1
 |  |  |  |  | A10
 |  |  |  |  | A8
 |  |  |  |  | A3
 |  |  |  |  | A6
 |  |  |  |  | A12
 |  |  |  |  | A5
 |  |  |  |  | A9
 |  |  |  |  | A7
 |  |  |  |  | A11
 |  |  |  |  | A4
 |  |  |  |  | A2
Spreadsheet: 215041d1361235365-counts-of-text-where-you-dont-know-the-text-values-projectexample
Sheet: Sheet1

 | DAVE |  | SUE |  | [NAME] |  | [NAME]
 | AM | PM | AM | PM | AM | PM | AM | PM
MON | Support | Support | Project C | Project C | Project C | Project C | Project C | Project C
TUES | Project A | Project A | Support | Support | Project A | Project A | Support | Support
WED | Project A | Project A | Support | Support | Project A | Project A | Support | Support
THU | Project B | Project B | Project B | Project B | Support | Support | Project B | Project B
FRI | Project B | Project B | Project B | Project B | Support | Support | Project B | Project B
Project | Periods in Schedule
How do I get a unique project to appear here? | I think I can then get the count of the project using a COUNTIF
Spreadsheet: 677957d1589624489-have-a-list-generate-a-list-generate-a-list-from-a-list
Sheet: Blad1

Car Brands:
Saab |  | V70 | Saab 900 | Commander | Golf |  |  |  |  | Volvo: | Saab: | Jeep: | VW
 |  |  |  |  |  |  |  | Volvo |  | C30 | Saab 900 | [NAME] | Golf
 |  |  |  |  |  |  |  | Saab |  | V70 | Saab 9-3 | Grand Cherokee | Tiguan
 |  |  |  |  |  |  |  | Jeep |  | XC60 | Saab 600 | Commander | Polo
 |  |  |  |  |  |  |  | VW
Spreadsheet: 41116d1239643712-converting-score-sheet-to-lookup-formula-determine-rating
Sheet: Sheet1

Age | Excellent | Good | Average | Fair | Low
20-29 | > 35 | 29-35 | 22-28 | 17-21 | < 17
30-39 | > 29 | 22-29 | 17-21 | 12-16 | < 12
40-49 | > 21 | 17-21 | 13-16 | 10-12 | < 10
50-59 | > 20 | 13-20 | 10-12 | 7-9 | < 7
60-69 | > 17 | 11-17 | 8-10 | 5-7 | < 5
If I have a person that is 42 years old who scores a 19, I need to know how to lookup the correct rating, which should be 'Good'.