tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 137854d1327410594-calculating-week-and-highlighting-cells-vacation_planner_final_2
Sheet: Summary

 |  |  |  |  |  |  |  |  | Year | 2012-12-31 00:00:00
Type Title Here
Name | Date of joining | Days Entitled to if 100% | Working time% | Vacation entitlement this year | Remaining leave last year | Total Vacation entitlement this year | Vacation planned | Remaining leave this year | Sick days this year | Day of Working % Change | New # of Days Off
Wai | 2011-01-01 00:00:00 | 25 | 80
[NAME] | 2011-01-05 00:00:00 |  | 100
Paolo | 2011-01-05 00:00:00 |  | 60 |  | 5
[NAME] | 2011-01-07 00:00:00 |  | 100
Elke | 2011-01-10 00:00:00 |  | 100
Louis | 2011-01-05 00:00:00 |  | 100
Employee | 2012-03-05 00:00:00 |  | 100
[NAME] | 2012-02-01 00:00:00 |  | 40
X | 2012-01-01 00:00:00 | 25 | 100
c | 2012-01-01 00:00:00 | 24 | 100
P | 2012-01-01 00:00:00 |  | 100
q
Spreadsheet: 36199d1233960548-excel-for-mac-2008-table-graphing-example
Sheet: Sheet1

1998 | 497900 | 510496.87 | 498857.54 | 501301.94 | 571383.95 | 581040.34 | 623107.66 | 789913.59 | 981151.67 | 912961.63 | 1007544.45 | 991121.47
1999 | 967136.34 | 1013365.45 | 938883.09 | 995216.08 | 1005068.72 | 970795.87 | 969242.6 | 971956.48 | 941437.05 | 887492.7 | 1014670.41 | 1218923.56
2000 | 1238670.12 | 1250065.89 | 1157185.99 | 1146539.88 | 1174630.11 | 1187198.65 | 1157637.4 | 1204290.19 | 1089762.19 | 1090089.12 | 1125626.03 | 1353452.73
Spreadsheet: 128039d1320758041-excel-2007-drop-down-box-to-read-data-from-a-table-forum
Sheet: Sheet1

Irradiance calc
TILT | 45°
ORIENTATION | E/W
SAP CALC
 | ORIENTATION
TILT | South | SE/SW | E/W | NE/NW | North
Horizontal | 933 | 933 | 933 | 933 | 933
30° | 1042 | 997 | 886 | 762 | 709
45° | 1023 | 968 | 829 | 666 | 621
60° | 960 | 900 | 753 | 580 | 485
Vertical | 724 | 684 | 565 | 427 | 360
i am aiming to achieve the result from the two drop down boxes picking the relevant information from the table below.  The table would ideally be placed on a seperate sheet but is not essential.
Spreadsheet: 713630d1610839672-calculate-material-release-bill-of-material-excel_matrelease_probsheet
Sheet: Sheet1

BILL OF MATERIAL |  |  |  | [NAME] REPORT SHEET |  |  |  |  | MATERIAL RELEASE SHEET
PRODUCT | MATERIAL | CONSUMPTION |  | PRODUCT | PRODUCTION_QTY | PRODUCTION_DATE |  |  | MATERIAL | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00
A | MATA | 3 |  | A | 4 | 2021-01-01 00:00:00 |  |  | MATA | 12 | 15
A | MATB | 5 |  | A | 5 | 2021-01-02 00:00:00 |  |  | MATB | 20 |  | 12
A | MATC | 2 |  | B | 7 | 2021-01-02 00:00:00 |  |  | MATC | 8 |  | 6
A | [NAME] | 12 |  | B | 3 | 2021-01-03 00:00:00 |  |  | [NAME] | 48 | 60
B | MATB | 4
B | MATC | 2
Spreadsheet: 152264d1335317215-listbox-item-selection-to-got-to-specific-sheet-listboxitemlinkwithsheet
Sheet: AdCallRep

 |  | AD CALL REPORT
Sl | Subject | Work to be done
1 | Paper AD | When & where to be published, how many times in a month, which model covers, AD Layout design and writings on layout
2 | AD Call | How many AD call received (total number to be received by next day), [NAME] [NAME], How many C0, C1, C2 and [NAME], RYG Status
3 | KAP | Is it holding or shifted, Is budget ok? Is leaflet ok? Call on the day, Update C0, C1, C2 and [NAME] generated in KAP
4 | Tracker | What distance covered, Is it open or closed or useless, how many requires?
5 | Daily Report | Is report ok? Whose pipeline is poor, how many to be done by this week? Is it sent, if not why?
6 | RYG | When Green customer to be converted, How many RYG
7 | Check Every Report | Check all report before sent
8 | Magic | When and where registration to be done, How Route permit can be arranged, what other problems Magic team is facing
9 | Report Analysis | Prepare various report from different angle
10 | Rajib Works | What he is doing now, what is to be done, what problem is facing now, ensure of all leaflet to be reached in Branch timely
11 | New Customer Buildup | Is report ok? Who is generating poor number? Number should not more than 5 in a single day
Spreadsheet: 167069d1341888391-vlookup-help-sample
Sheet: Sheet1

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | [NAME] | Contract Value | Cost Analyst | Estimated Time |  |  |  |  |  |  |  |  |  |  |  |  | Area2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area3
Spreadsheet: 674513d1587890058-format-problem-and-the-lookup-function-format-problem-and-vlookup
Sheet: Sheet-1

Account | Descrition
1040 | Description-17
1045 | Description-18
1050 | [NAME]
1055 | Description-20
1060 | [NAME]
1065 | Description-22
1080 | Description-28
1099 | Description-29
1100 | Description-30
1110 | Description-31
1120 | Description-32
1130 | Description-33
1140 | Description-34
1145 | Description-35
1150 | [NAME]
1155 | Description-37
1220 | Description-51
1224 | Description-52
1225 | Description-53
1230 | Description-54
1235 | Description-55
1249 | Description-62
1250 | Description-63
1260 | Description-64
1265 | Description-65
1270 | Description-66
1280 | Description-67
1289 | Description-68
1290 | Description-69
1320 | Description-85
1325 | Description-86
1330 | Description-87
1340 | Description-88
1345 | Description-89
1350 | Description-90
1355 | Description-91
1375 | Description-98
1380 | Description-99
1384 | [NAME]
1385 | Description-101
1429 | Description-114
1440 | Description-115
1449 | Description-116
1460 | Description-117
1465 | Description-118
1469 | Description-119
1470 | Description-120
1471 | Description-121
1472 | Description-122
1473 | Description-123
1490 | Description-131
1499 | Description-132
1500 | Description-133
Spreadsheet: mike_swerzbin__28060__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-04 00:00:00 | 18 | 19.5 | 17 | 18.5
Mid-Columbia | 2002-01-04 00:00:00 | 18 | 19.5 | 17 | 18.5
COB | 2002-01-04 00:00:00 | 21 | 24.25 | 16 | 20
N. California | 2002-01-04 00:00:00 | 22 | 26.5 | 16 | 21
Midway/Sylmar | 2002-01-04 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-04 00:00:00 | 23.15 | 25 | 15.5 | 19.25
Mead | 2002-01-04 00:00:00 | 24 | 24.75 | 17 | 19.5
Palo Verde | 2002-01-04 00:00:00 | 22.75 | 24.5 | 15.25 | 17
Inland SW | 2002-01-04 00:00:00 | 22.75 | 24.75 | 15.25 | 19.5
4-Corners | 2002-01-04 00:00:00 | 21.5 | 24 | 15.5 | 17.5
Central Rockies | 2002-01-04 00:00:00 | 21.25 | 24.5 | 17.25 | 22.5
NW/N. Rockies | 2002-01-05 00:00:00 | 18 | 19.5 | 17 | 18.5
Mid-Columbia | 2002-01-05 00:00:00 | 18 | 19.5 | 17 | 18.5
COB | 2002-01-05 00:00:00 | 21 | 24.25 | 16 | 20
N. California | 2002-01-05 00:00:00 | 22 | 26.5 | 16 | 21
Midway/Sylmar | 2002-01-05 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-05 00:00:00 | 23.15 | 25 | 15.5 | 19.25
Mead | 2002-01-05 00:00:00 | 24 | 24.75 | 17 | 19.5
Palo Verde | 2002-01-05 00:00:00 | 22.75 | 24.5 | 15.25 | 17
Inland SW | 2002-01-05 00:00:00 | 22.75 | 24.75 | 15.25 | 19.5
4-Corners | 2002-01-05 00:00:00 | 21.5 | 24 | 15.5 | 17.5
Central Rockies | 2002-01-05 00:00:00 | 21.25 | 24.5 | 17.25 | 22.5
Spreadsheet: 47825d1246994081-sorting-by-index-and-matching-formula-packing-example
Sheet: Packing Info

Packing Information
Container Type | # of Identical  Boxes | Net Weight- # | Total Net Weight-# | Total Net Weight-kg | Gross Weight- # | Total Gross Weight- # | Total GrossWeight-kg
SML-1 | 5 | 25 | 125 | 57 | 31 | 155 | 70
BLK-4 | 2 | 300 | 600 | 273 | 356 | 712 | 324
LGE-3 | 2 | 70 | 140 | 64 | 84 | 168 | 76
[NAME] | 4 | 358 | 1432 | 651 | 414 | 1656 | 753
BLK-4 | 1 | 305 | 305 | 139 | 361 | 361 | 164
SML-1 | 2 | 26 | 52 | 24 | 32 | 64 | 29
MED-2 | 2 | 34 | 68 | 31 | 44 | 88 | 40
Totals | 18 |  |  | 1239 |  | 3204 | 1456
SML-1 | 7
MED-2 | 2
LGE-3 | 2
BLK-4 | 3
[NAME] | 4
Totals By Container Size
SML-1 | 7 |  |  |  | Container | Dimensions | Ice Weight - #
[NAME] | 4 |  |  |  | SML-1 | 18" x 15" x 11" | 6
BLK-4 | 3 |  |  |  | MED-2 | 22" x 19" x 12" | 10
MED-2 | 2 |  |  |  | LGE-3 | 23" x 15" x 20" | 14
MED-2 | 2 |  |  |  | BLK-4 | 48" x 35" x 31" | 56
 |  |  |  |  | [NAME] | 48" x 40" x 32" | 56
Spreadsheet: 80100d1280323346-combining-information-horizontally-open-jobs-in-order
Sheet: Jobs in Order

Open Jobs
756622
756657
756659
756660
756662
756670
756859
756892
756905
756906
757009
757010
757011
757013
757014
757015
757016
757017
757018
757025
757026
757041
757043
757045
757047
757048
757049
757050
757052
757053
757054
757055
757056
757057
757059
757062
757064
757065
757070
757071
757072
757075
757105
757120
757121
757122
757123
757124
757125
757126
757127
757128
757129
757130
757131
757132
757133
757143
757144
757145
757146
757147
757148
757149
757150
757151
757152
757153
757155
757157
757158
757159
757160
757161
757162
757163
757164
757165
757166
757167
757168
757169
757170
757171
757172
Spreadsheet: 94839d1294607432-retreiving-multiple-matches-values-in-same-row-if-x-is-true-1test
Sheet: Production

PRODUCTION
 |  | Line A |  |  |  |  | Line B |  |  |  |  | Line C |  |  |  |  | Line D
 |  | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5
Saturday | 2011-01-01 00:00:00 | 2800 | 3200 | 4000 | 2400 | 3600 | 2736 | 3216 | 4016 | 2440 | 3648 | 2752 | 3088 | 3880 | 2200 | 3376 | 2616 | 3008 | 3976 | 2272 | 3536
Sunday | 2011-01-02 00:00:00 | 2670 | 3045 | 3795 | 2295 | 3420 | 2792 | 3272 | 4072 | 2496 | 3704 | 2730 | 3045 | 3787.5 | 2212.5 | 3315 | 3040 | 3432 | 4400 | 2696 | 3960
Monday | 2011-01-03 00:00:00 | 3072 | 3472 | 4272 | 2672 | 3872 | 3008 | 3488 | 4288 | 2712 | 3920 | 3024 | 3360 | 4152 | 2472 | 3648 | 2888 | 3280 | 4248 | 2544 | 3808
Tuesday | 2011-01-04 00:00:00 | 2656 | 3056 | 3856 | 2256 | 3456 | 2600 | 3080 | 3880 | 2304 | 3512 | 2720 | 3056 | 3848 | 2168 | 3344 | 2848 | 3240 | 4208 | 2504 | 3768
Wednesday | 2011-01-05 00:00:00 | 2608 | 3008 | 3808 | 2208 | 3408 | 2544 | 3024 | 3824 | 2248 | 3456 | 2560 | 2896 | 3688 | 2008 | 3184 | 2600 | 3080 | 3880 | 2304 | 3512
Thursday | 2011-01-06 00:00:00 | 2848 | 3240 | 4208 | 2504 | 3768 | 3040 | 3432 | 4400 | 2696 | 3960 | 2656 | 3056 | 3856 | 2256 | 3456 | 2912 | 3248 | 4040 | 2360 | 3536
Friday | 2011-01-07 00:00:00 | 2720 | 3056 | 3848 | 2168 | 3344 | 3024 | 3360 | 4152 | 2472 | 3648 | 2600 | 3080 | 3880 | 2304 | 3512 | 2736 | 3216 | 4016 | 2440 | 3648
Saturday | 2011-01-08 00:00:00
Sunday | 2011-01-09 00:00:00
Monday | 2011-01-10 00:00:00
Tuesday | 2011-01-11 00:00:00
Wednesday | 2011-01-12 00:00:00
Thursday | 2011-01-13 00:00:00
Friday | 2011-01-14 00:00:00
Saturday | 2011-01-15 00:00:00
Sunday | 2011-01-16 00:00:00
Monday | 2011-01-17 00:00:00
Tuesday | 2011-01-18 00:00:00
Wednesday | 2011-01-19 00:00:00
Thursday | 2011-01-20 00:00:00
Friday | 2011-01-21 00:00:00
Saturday | 2011-01-22 00:00:00
Sunday | 2011-01-23 00:00:00
Monday | 2011-01-24 00:00:00
Tuesday | 2011-01-25 00:00:00
Wednesday | 2011-01-26 00:00:00
Thursday | 2011-01-27 00:00:00
Friday | 2011-01-28 00:00:00
Saturday | 2011-01-29 00:00:00
Sunday | 2011-01-30 00:00:00
Monday | 2011-01-31 00:00:00
Spreadsheet: 844935d1696528004-priority-task-list-book3
Sheet: Top 10

Priority | Task # | Title | Desciption
1 | 1004 | Title 4 | [NAME] 4
2 | 1020 | Title 20 | [NAME] 20
3 | 1006 | Title 6 | [NAME] 6
4 | 1024 | Title 24 | [NAME] 24
5 | 1016 | Title 16 | [NAME] 16 | What I want it to look like
6 | 1008 | Title 8 | [NAME] 8
7 | 1018 | Title 18 | [NAME] 18
8 | 1010 | Title 10 | [NAME] 10
9 | 1028 | Title 28 | [NAME] 28
10 | 1032 | Title 32 | [NAME] 32
1
2
3
4
5 |  |  |  | What I'm getting
6
7
8
9
10
VLOOKUP(LARGE($D$2:$D$36,37-ROW()),$D$2:$F$36,2,) |  |  |  | Works on Top 20 Tab
VLOOKUP(LARGE(List!$A$2:$A$41,42-ROW()),List!$A$2:$D$41,2,) |  |  |  | Does not work on this tab
Spreadsheet: 472913d1469837367-import-specific-cells-in-multiple-sheets-from-hundreds-of-identical-workbooks-imp_ds_templatefordb
Sheet: Title Page

DIG DATA SHEET
Revised 8/22/2012
Company / Phone:*
Pipeline Name/Number:*
[NAME] Number:* |  |  |  |  |  | 1
[NAME]):* |  |  |  |  |  | 50795
Workorder:* |  |  |  |  |  | 67689164
Date:* |  |  |  |  |  | 2013-11-15 00:00:00
 |  | ASSESSMENT TYPE AND DIG PRIORITY
 |  |  | ECDA
 |  |  |  | Initial Dig Priority:
 |  |  |  |  | Immediate |  | Scheduled |  |  |  |  | Monitored |  |  |  | Validation
 |  |  |  | Final Dig Priority (if reclassified):
 |  |  |  |  | Immediate |  | Scheduled |  |  |  |  | Monitored |  |  |  | Validation
 |  |  |  | Dig Category:
 |  |  |  |  | Original |  | Additional
 |  |  | ICDA
 |  |  |  | Dig Type:
 |  |  |  |  | Low Point |  | 1st Critical Inclination Angle |  |  |  |  |  |  |  | Other
 |  |  |  | Dig Category:
 |  |  |  |  | Original |  | Additional
 |  |  | SCCDA
 |  |  |  | Dig Category:
 |  |  |  |  | Original |  | Additional
 |  |  | ILI
 |  |  |  | Dig Priority:
 |  |  |  | 1 | Immediate | X | Scheduled |  |  |  |  | Monitored
 |  |  | Pressure Test
 |  |  | [NAME]
 |  |  | Coupling Weld Cover Pumpking Sleeve
 |  | PIPE REPAIRS PERFORMED (CFR 49 - 192.933):
 |  |  |  |  | Yes |  | No
 |  |  |  | Repair Type*:
 |  |  |  |  | Immediate |  | Scheduled |  |  |  |  | Monitored
* Data Required
Spreadsheet: daren_farmer__5641__SDSNOM
Sheet: Sheet1

SDSNOM.xls
TO:    [NAME]
CC:   [NAME], [NAME], [NAME]/HPL
FROM:   [NAME] (Previously TUFCO) |  |  |  |  |  |  |  |  |  |  | June |  | 35 |  | 30
 |  |  |  |  |  |  |  |  |  |  | July |  | 35 |  | 31
SUBJECT:   Gas Sales and Purchase Contract between TXU Fuels and SDS |  |  |  |  |  |  |  |  |  |  | August |  | 35 |  | 31
Nomination of Estimated Monthly Quantity |  |  |  |  |  |  |  |  |  |  | September |  | 25 |  | 30
 |  |  |  |  |  |  |  |  |  |  | October |  | 20 |  | 31
 |  |  |  |  |  |  |  |  |  |  | November |  | 0 |  | 30
 |  | Date |  | Estimated |  | Estimated |  |  |  |  | December |  | 24.516 |  | 31
Nomination Month |  | Nominated |  | Daily Quantity |  | Monthly Quantity
 |  |  |  | MMBtu |  | MMBtu
2001 |  |  |  |  |  |  |  |  |  |  |  | Period Average -
January |  | 2000-12-21 00:00:00 |  | 30000
February
March |  |  |  |  |  |  |  |  |  |  | January |  | 30 |  | 31
April |  |  |  |  |  |  |  |  |  |  | February |  | 0 | 0 | 28
May |  |  |  |  |  |  |  |  |  |  | March |  | 20 |  | 31
June |  |  |  |  |  |  |  |  |  |  | April |  | 20 |  | 30
July |  |  |  |  |  |  |  |  |  |  | May |  | 20 |  | 31
August |  |  |  |  |  |  |  |  |  |  | June |  | 30 |  | 30
September |  |  |  |  |  |  |  |  |  |  | July |  | 35 |  | 31
October |  |  |  |  |  |  |  |  |  |  | August |  | 35 |  | 31
November |  |  |  |  |  |  |  |  |  |  | September |  | 35 |  | 30
December |  |  |  |  |  |  |  |  |  |  | October |  | 20 |  | 31
 |  |  |  |  |  |  |  |  |  |  | November |  | 30 |  | 30
 |  |  |  |  | Total |  |  |  |  |  | December |  | 20 |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | Period Average -
Note:  Please advise immediately should you have any questions concerning the above.
C:      R. Skerik
D. Avila
G. Green
M. Jones
Spreadsheet: 735226d1622773945-filter-formula-unable-to-look-up-a-certain-word-from-2-x-columns-permit-register-example-emma-03-06-21-revised
Sheet: To Approve

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP
 | Address 4 | Description 4 | Client 4 | 001/001/004 | 2021-05-04 00:00:00 | APPROVE
ABC-21022 | Address 22 | Description 22 | Client 22 | 001/001/022 | APPROVE | APPROVE
Spreadsheet: 149031d1333654513-excel-2007-help-with-an-expenses-tracker-pullman-audit-trail3
Sheet: Settings

Department Settings
Code | Name |  | Paid Hours |  | Name of the Department |  | Time Format
 |  |  |  |  | Staff Wages |  | 12:00PM | 1
 |  |  |  |  | Holiday Pay |  | 1 day, 0:00:00
 |  |  |  |  | ER's, NI, Pensions
 |  |  |  |  | Agency/Temp Staff
 |  |  |  |  | Door Staff
 |  |  |  |  | Contract Cleaners
 |  |  |  |  | Management Salary
 |  |  |  |  | Marketing
 |  |  |  |  | Entertainment
 |  |  |  |  | Music and TV License
 |  |  |  |  | Sky Tv
 |  |  |  |  | House Repairs
 |  |  |  |  | Maintenance
 |  |  |  |  | Epos (Tills)
 |  |  |  |  | Other EQUIPT Rental
 |  |  |  |  | Sanitary Services
 |  |  |  |  | Cash Collection
 |  |  |  |  | Cleaning Materials
 |  |  |  |  | Gardening
 |  |  |  |  | Health and Safety
 |  |  |  |  | Pub Consumables
 |  |  |  |  | Pump Gas
 |  |  |  |  | Security
 |  |  |  |  | Staff Recr & Training
 |  |  |  |  | Refuse
 |  |  |  |  | Uniforms
 |  |  |  |  | Linen and Laundry
 |  |  |  |  | Window Cleaning
 |  |  |  |  | Licenses
 |  |  |  |  | Knife Sharpening
 |  |  |  |  | Other General Expenses
 |  |  |  |  | Bank Charges
 |  |  |  |  | Credit Card Charges
 |  |  |  |  | Stolen/Forged Cash
 |  |  |  |  | Under and Overbanking
 |  |  |  |  | Proffesional Fees
 |  |  |  |  | Stationary & Postage
 |  |  |  |  | Telephone & Internet
 |  |  |  |  | Vehicle Costs
 |  |  |  |  | Travel Costs
 |  |  |  |  | Other Administraion Costs
 |  |  |  |  | Electricity
 |  |  |  |  | Gas
 |  |  |  |  | Water and Sewage
 |  |  |  |  | Business Rates
 |  |  |  |  | Insurance
 |  |  |  |  | Rent
 |  |  |  |  | Managers Accomodation
Spreadsheet: 845978d1697271606-how-to-get-unique-data-from-two-column-book2
Sheet: Sheet1

Unique Data | Data Collection from Column A | Need Unique Data
350317671237273 | 350317671237273
350317671211781 | 350317671211781
359885852133686 | 359885852133686
353828958128776 | 353828958128776
355895960535791 | 355895960535791
353828958230234 | 353828958230234
353598491067126 | 353598491067126
350862310060669 | 350862310060669
350862310060644 | 350862310060644
350568490088798 | 350568490088798
350317671214827 | 350317671214827
359885853397124
353828958235159
353598490915069
353598490960396
353598490611171
351465071837082
357567590936313
359885852128520
353598491066664
353598490670151
351465072088271
353598490978620
353828955042004
350568490762079
350568490344498
350568490095421
Spreadsheet: 93530d1293104710-excel-2007-need-help-with-a-concatenate-issue-upload-sample
Sheet: Sheet1

 | Model | YR | Alpha | Serial # |  | Desired Results |  |  | What I am getting
 | 740 | 2008 | FB | 10059 |  | 740-08-FB10059 |  |  | 7408FB10059
 | 540 | 2008 | A | 6035 |  | 540-08-A06035 |  |  | 5408A6035
 | 540 | 2008 | A | 6036 |  | 540-08-A06036 |  |  | 5408A6036
 | 740 | 2009 | CB | 10193 |  | 740-09-CB10193 |  |  | [NAME]
 | 420 | 2010 |  | 14682 |  | 420-10-14682 |  |  | 4201014682
 | SA | 2010 |  | 14683 |  | SA-10-14683 |  |  | SA01014683
Spreadsheet: d5de40de-454f-486d-b43d-f7bbfe32e95e
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
FPNG4 | Test | FPNG4 | Peanut IgG4 | Peanut IgG4 | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Cold OK; Warm OK Lipemia:	NA Icterus:	NA Other:	NA | <0.15 mcg/mL  The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG4 tests has not been clearly established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food related complaints, and to evaluate food allergic patients prior to food challenges. The presence of food-specific IgG4 alone cannot be taken as evidence of food allergy and only indicated immunologic sensitization to the food allergen in question.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday, Wednesday, Friday | 2 - 3 days | 4 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPNG4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPNG4 | Result | FPNG4 | Peanut IgG4 | Peanut IgG4 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 859317d1707741752-counting-occurrences-in-months-book-1
Sheet: Sheet1 (3)

Scheme Pin | Description | Manager | Start Date | End Date | Duration | Budget | Stage | Funding | Area
612021 | Descrption A | [NAME] A | 2024-04-01 00:00:00 |  |  |  | Stage 3 |  | Area 1
612678 | Descrption B | [NAME] | 2024-04-02 00:00:00 |  |  |  | Stage 3 |  | Area 2
612662 | Descrption C | [NAME] C | 2024-02-05 00:00:00 |  |  |  | Stage 2 |  | Area 3
613228 | Descrption D | [NAME] | 2024-05-06 00:00:00 |  |  |  | Stage 3 |  | Area 1
566234 | Descrption E | [NAME] | 2024-05-05 00:00:00 |  |  |  | Stage 3 |  | Area 1
614526 | Descrption F | [NAME] | 2024-05-31 00:00:00 |  |  |  | Stage 0 |  | Area 1
614527 | Descrption G | [NAME] | 2024-06-06 00:00:00 |  |  |  | Stage 3 |  | Area 2
601143 | Descrption H | [NAME] | 2024-07-09 00:00:00 |  |  |  | Stage 3 |  | Area 2
600717 | Descrption I | [NAME] I | 2024-07-10 00:00:00 |  |  |  | Stage 0 |  | Area 1
562650 | Descrption J | [NAME] J | 2024-12-12 00:00:00 |  |  |  | Stage 2 |  | Area 3
615154 | Descrption K | [NAME] | 2024-01-01 00:00:00 |  |  |  | Stage 0 |  | Area 1
614422 | Descrption L | [NAME] | 2025-02-03 00:00:00 |  |  |  | Srage 3 |  | Area 3
614500 | Descrption M | [NAME] | 2024-08-09 00:00:00 |  |  |  | Stage 3 |  | Area 1
Spreadsheet: 289189d1389446316-extracting-data-from-the-spreadsheet-mainfile
Sheet: Ronaldinho

010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
010920011 | Shot Fake | 0 | Ronaldinho | 4
Spreadsheet: 68365d1268900154-array-search-trigger-issues
Sheet: Sheet1

3 |  | "Range A1:A13"
6 |  | "If the rows were a time series, I want to find the first to trigger over say 10"
9 |  | "So I would expect the result to be 12"
2 |  | "I also want to output the range needed to reach above 10, here for example would be A1:A7"
5
9
12
11
4
6
7
11
8
"I try to use min to take the range, but I get the first sequential number "11" over the number not the series first hit I want"
11
"I try to index match the row as index being range,row(match function),column(1)"
#N/A |  | "Seems both of my statements fail"
#N/A
"As to get the range required before getting that term I was attempting countif function but again getting stuck in the sequence issue"
"If I were to countif and get a number say here 7 counts to reach the target, how could I output that as "A1:A7""
"Thanks for reading"
Spreadsheet: 97770d1296853940-sumif-help-with-multiple-tabs-payroll-cards-formula-test
Sheet: Prog Totals

 | Hours | BSS-CSP | YRP | PSYCH | TOTAL
Noni
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Michelle
Bettina
[NAME]
Jessica
[NAME]
[NAME]