tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 822430d1679340487-filter-function-nested-if-multi-better-simpler-expression-pivot-tbl-and-slicer-xl21-
Sheet: PIVOT TBL & SLICER

MAKE | MODEL | FUEL | TYPE | Desc | Turbo | R/C/L | Litre | IG | SPORTS | 3 DOOR | E/W | AIR CON | ALLOYS | TRIP COMP
Bmw | 3 series | DIESEL | Tdi | Nice | Y | Y | 2.0 L | 10 | Y | Y | Y | Y | Y | Y
 |  |  | [NAME] | Nice | Y | Y | 2.0 L | 10 | Y | Y | Y | Y | Y | Y
 | X4 | PETROL | 4WD | 4x4 | (blank) | Y | 3.0 L | 16 | Y | (blank) | Y | Y | Y | Y
 | Z4 | PETROL | Sport | Great | (blank) | Y | 2.5 L | 15 | Y | Y | Y | Y | Y | Y
Citreon | Ax | PETROL | Vibe | Crap | (blank) | N | 1.1 L | (blank) | N | (blank) | (blank) | (blank) | (blank) | (blank)
Fiat | Panda | PETROL | Dlux | Crap | (blank) | N | 1.2 L | (blank) | N | (blank) | (blank) | (blank) | (blank) | (blank)
 | Punto | PETROL | Sport | Tidy | (blank) | Y | 1.6 L | 8 | Y | Y | Y | (blank) | Y | (blank)
Ford | Focus | DIESEL | TDCi | Great | Y | Y | 1.8 L | 11 | Y | Y | Y | Y | Y | Y
Honda | Civic | DIESEL | CDTi | Great | Y | Y | 1.7 L | 10 | Y | Y | Y | Y | Y | Y
 |  |  |  |  |  |  | 2.2 L | 10 | Y | Y | Y | Y | Y | Y
 |  | PETROL | Type R | [NAME] | (blank) | Y | 2.0 L | 13 | Y | (blank) | (blank) | (blank) | (blank) | (blank)
Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | Y | Y | 2.0 L | 7 | Y | Y | Y | Y | Y | Y
 |  |  | Hdi | [NAME] | Y | Y | 2.0 L | 7 | Y | Y | Y | Y | Y | Y
 |  | PETROL | Gti | Sporty | Y | Y | 2.0 L | 10 | Y | Y | Y | Y | Y | Y
 | 2O7 | PETROL | Gti | OK | (blank) | Y | 2.0 L | 15 | Y | (blank) | (blank) | (blank) | (blank) | (blank)
 | 3O6 | DIESEL | TD | [NAME] | Y | Y | 1.9 L | 13 | Y | Y | Y | Y | Y | Y
 | 3O7 | DIESEL | Hdi | Super | Y | Y | 2.0 L | 11 | Y | Y | Y | Y | Y | Y
 |  |  |  | [NAME] | Y | Y | 2.0 L | 11 | Y | Y | Y | Y | Y | Y
Proton | Impian | PETROL | Sport | Dull | Y | Y | 1.6 L | 8 | (blank) | (blank) | Y | (blank) | Y | (blank)
Renault | Megane | DIESEL | Dci | Great | Y | Y | 1.9 L | 8 | Y | Y | Y | Y | Y | Y
Rover Metro | Metro | PETROL | Club | Dull | (blank) | Y | 1.1 L | (blank) | N | (blank) | (blank) | (blank) | (blank) | (blank)
Vauxhall | Astra | PETROL | VXR | Great | (blank) | Y | 2.0 L | 9 | Y | Y | Y | Y | Y | Y
 | Nova | PETROL | SRI | Dull | (blank) | Y | 1.4 L | 8 | N | (blank) | (blank) | (blank) | (blank) | (blank)
Spreadsheet: 188262d1350777526-sorting-simultaneous-columns-for-same-data-names-corresponding-to-appointments-find-2-bobs
Sheet: Sheet1

Room | Slot | Day |  |  |  |  |  | Time | Party 1 | Party 2 | Party  1 | Party  2 | Both parties (auto filled)
Room 1 | 1 | Wednesday | 08:00:00 | 08:15:00 |  |  |  | 08:00 to 08:15 | bob | [NAME]
Room 2 | 2 | Wednesday | 16:00:00 | 16:15:00 |  |  |  | 16:00 to 16:15 | [NAME] | bob
Room 2 | 5 | Thursday | 15:00:00 | 15:15:00 |  |  |  | 15:00 to 15:15 | [NAME] | mark
Room 1 | 1 | Wednesday | 08:45:00 | 09:00:00 |  |  |  | 08:45 to 09:00 | mark | bob
Room 4 | 2 | Wednesday | 14:15:00 | 14:30:00 |  |  |  | 14:15 to 14:30 | [NAME] | [NAME]
Room 2 | 2 | Wednesday | 13:45:00 | 14:00:00 |  |  |  | 13:45 to 14:00 | mark | bob
Room 1 | 1 | Wednesday | 09:30:00 | 09:45:00 |  |  |  | 09:30 to 09:45 | [NAME] | [NAME]
Room 5 | 1 | Wednesday | 10:15:00 | 10:30:00 |  |  |  | 10:15 to 10:30 | [NAME] | mark
Room 7 | 3 | Wednesday | 20:15:00 | 20:30:00 |  |  |  | 20:15 to 20:30 | [NAME] | [NAME]
Room 9 | 6 | Thursday | 19:00:00 | 19:15:00 |  |  |  | 19:00 to 19:15 | [NAME] | [NAME]
 |  |  |  |  |  |  |  | name | [NAME] | <--- type name here to find it in both lists
Spreadsheet: 736673d1623792085-need-and-formula-please-iferror-index-i-believe-work-classifications
Sheet: Sheet1

A0 | 17.7 | 26.55
A1 | 19.25 | 28.88
A2 | 22.9 | 34.35
A3 | 26 | 39
A4 | 34.3 | 51.45
A5 | 39 | 58.5
J | 52 | 78
J/F | 55.1 | 82.65
J/S | 56.15 | 84.23
OP | 52.1
Spreadsheet: 763384d1642151239-attendance-calculation-book_shiva
Sheet: Sheet1

Location |  | Shifts |  |  | Name1 | Amount1 | [NAME] | Amount2 | Name3 | Amount3 | Name4 | Amount4 | Name5 | Amount5
[NAME] | 2021-12-01 00:00:00 | Shift-1 | 50 | 22 | M | 100 | N | 600 | O | 600 | P | 600 | Q | 400
[NAME] |  | Shift-2 | 45 | 17 | M | 200 | N | 400 | O | 400 | P | 200 | Q | 100
XYZ-02 | 2021-12-01 00:00:00 | Shift-1 | 0 | 1 | M | 100 | N | 600 | O | 600 | P | 600 | Q | 400
XYZ-02 |  | Shift-2 | 0 | 1 | M | 200 | N | 400 | O | 400 | P | 200 | Q | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attendance | Total Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 2 | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 2 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | 2 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | 2 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 2 | 500
Spreadsheet: 56463d1256655065-excel-2007-excluding-0-as-data-in-average-formula-monthly-report
Sheet: Week 3

 |  |  |  | WEEK 3
 | Technician |  |  |  | Work Comp % | QC Pass % | CDV/HSI Jobs | Activation Attemtps | [NAME] | VOD Attempts
 | 1 |  |  |  | 0.8824 | 0
 | 2 | [NAME] |  |  | 0 | 0
 | 3 | [NAME] |  |  | 0.8824 | 1
 | 4 | [NAME] |  |  | 0.8462 | 0
 | 5 | [NAME] |  |  | 0.9744 | 0.99
 | 6 | [NAME] |  |  | 0.8636 | 1
 | 7 | [NAME] |  |  | 0.9 | 0
 | 8 | [NAME] |  |  | 0.9048 | 0.9425
 | 9 | [NAME] |  |  | 0.9667 | 0.8467
 | 10 | [NAME] |  |  | 0.8421 | 0.9267
 | 11 | [NAME] |  |  | 0.8889 | 0
 | 12 | [NAME] |  |  | 0.8571 | 1
 | 13 | [NAME] |  |  | 1 | 0
 | 14 | [NAME] |  |  | 0.8947 | 1
 | 15 | [NAME] |  |  | 1 | 1
 | 16 | [NAME] |  |  | 1 | 0.95
 | 17 | [NAME] |  |  | 0.7778 | 0.95
 | 18 | 0
 | 19 | 0
 | 20 | 0
 | 21 | 0
 | 22 | 0
 | 23 | 0
 | 24 | 0
 | 25 | 0
Spreadsheet: 855518d1705056466-sum-formula-with-xlookup-with-multiple-arrays-summary
Sheet: External Budget Spend

 | Project ID | Projects | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 |  |  | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals
 |  |  |  |  |  |  | 4 | 2 | 8 | 6
Spreadsheet: 104885d1302301042-excel-2007-getting-data-from-another-sheet-page-771670-20-20excelforum-1-
Sheet: Redovisning

Kalkyl "Klassresa - Inkomster och avgifter"
Kalkyl för inkomster och avgifter av olika event samt förväntad inkomst för att [NAME] räkna [NAME] preliminär summa pengar som kommer samlas in för att sedan [NAME] räkna hur mycket som [NAME] behövas för att uppnå det slutgiltliga målet.
Varor (disco) |  | Inköpspris | [NAME] |  | Antal/person |  | Total/vara | Totalsumma
Inträde |  | 0 | 20 |  | 1
Läskburk |  | 3 | 10 |  | 2
Samlingsnamn godis |  | 1 | 2 |  | 10
Datum | Event | Gäster | Prel. Inkomst |  | Prel. Summa |  | Inkomst | Avgift | Summa | Totalsumma
länge | Astraförsäljning | 0
2011-04-11 00:00:00 | New Body | 0
2011-04-14 00:00:00 | Disco | 100
2011-04-29 00:00:00 | [NAME] | 100
2011-05-05 00:00:00 | [NAME] | 0
Total
Kassan |  |  |  |  | 20000 |  |  |  | 20000
Resan |  |  |  |  |  |  |  |  | 56492
Spreadsheet: 121109d1315851774-help-with-combining-two-column-lists-into-one-and-remove-dupes-combine-list-remove-duplicates
Sheet: Sheet1

List 1 | List 2 | Combined List | <- combines list 1 and list 2 and remove duplicates
Alba, [NAME] | Alba, [NAME] | Alba, [NAME]
Poppins, Mary | Poppins, Mary | Poppins, Mary
Klein, [NAME] | Ruddy, [NAME] | Klein, [NAME]
Wilson, [NAME] | Wilson, [NAME] | Ruddy, [NAME]
Wilcox, [NAME] | [NAME], [NAME] | Wilson, [NAME]
 |  | Wilcox, [NAME]
 |  | [NAME], [NAME]
List 1 | List 2 | Combined List
Alba, [NAME] | Alba, [NAME] | <formula?>
Poppins, Mary | Poppins, Mary | <formula?>
Klein, [NAME] | Ruddy, [NAME] | <formula?>
Wilson, [NAME] | Wilson, [NAME] | <formula?>
Wilcox, [NAME] | [NAME], [NAME] | <formula?>
 |  | <formula?>
 |  | <formula?>
Spreadsheet: 118514d1313742936-football-prediction-point-system-football-prediction
Sheet: Sheet1

 |  |  |  |  |  | Points Scored (formula goes here)
 | Predictions
 |  | GOALS |  | GOALS
 | [NAME] | 1 | v | 1 | Wolves |  |  | HOW PTS ARE SCORED
 | Fulham | 2 | v | 1 | [NAME] |  |  | HOME WIN PREDICTED
 | Liverpool | 2 | v | 1 | Sunderland |  |  | SPOT ON = 40 pts
 | Man City | 2 | v | 0 | Swansea |  |  | CLOSE = 20 [NAME] (-3 PER GOAL OUT)
 | Newcastle | 1 | v | 2 | Arsenal |  |  | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 | QPR | 1 | v | 2 | [NAME]
 | Stoke | 1 | v | 2 | Chelsea |  |  | DRAW PREDICTED
 | Tottenham | 1 | v | 1 | Everton |  |  | SPOT ON = 50 pts
 | West Brom | 1 | v | 3 | Man Utd |  |  | CLOSE = 30 [NAME] (-3 PER GOAL OUT)
 | [NAME] | 2 | v | 0 | [NAME] |  |  | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 |  |  |  |  |  |  |  | AWAY WIN PREDICTED
 | [NAME] |  |  |  |  |  |  | SPOT ON = 50 pts
 |  | GOALS |  | GOALS |  |  |  | CLOSE = 30 [NAME] (-3 PER GOAL OUT)
 | [NAME] | 1 | v | 2 | Wolves |  |  | WRONG = 0 [NAME] (-3 PER GOAL OUT)
 | Fulham | 0 | v | 0 | [NAME]
 | Liverpool | 1 | v | 1 | Sunderland
 | Man City | 2 | v | 0 | Swansea
 | Newcastle | 0 | v | 0 | Arsenal
 | QPR | 0 | v | 4 | [NAME]
 | Stoke | 0 | v | 0 | Chelsea
 | Tottenham | 1 | v | 1 | Everton
 | West Brom | 1 | v | 2 | Man Utd
 | [NAME] | 1 | v | 1 | [NAME]
Spreadsheet: 54982d1255021031-excel-2007-solved-auto-fill-columns-based-on-list-selection-indexmatch-simple
Sheet: Main

Codes | Issue | [NAME] | Size | Priority |  | Enter these codes in A2 |  |  | 211
211 | CRT cable disconnected | [NAME] | SM | 4 | INDEX/MATCH |  |  |  | 149
 |  |  |  |  | (no limitations) |  |  |  | 139
 |  |  |  |  |  |  |  |  | 132
211 | CRT cable disconnected | [NAME] | SM | 4 | LOOKUP()
 |  |  |  |  | (this only works because the data on the other sheet is sorted)
211 | CRT cable disconnected | [NAME] | SM | 4 | VLOOKUP()
 |  |  |  |  | (this formula is slightly different in each cell, and you can't reference a whole column
 |  |  |  |  | like you can with INDEX/MATCH and LOOKUP)
Spreadsheet: ea53cf7c-f3cd-4870-869d-010b8b218f70
Sheet: Statistics

 |  |  |  |  |  |  |  |  |  |  |  | Note: These numbers will change by [NAME] night as new leaks appear.
Averages | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | Total 2003-2014
Average length before first leak online (including cams)
Average length from US release to screener leak
Average length from screener release to screener leak
Average length from US release to retail DVD leak
Median | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | Total 2003-2014
Median days before first leak online (including cams)
Median days from US release to screener leak
Median days from screener release to screener leak
Median length from US release to retail DVD leak
Total Statistics
Total nominated films
# films leaked (including cams)
# screeners leaked
# Academy screeners leaked (probable)
# Screeners leaked by [NAME] night
% of Screeners leaked by [NAME] night
# Screeners/Retail DVDs leaked by [NAME] night
% of Screeners/Retail DVDs leaked by [NAME] night
# [NAME]
# Telesyncs
# R5/Telecines
# Retail DVD leaks
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: November

 |  |  |  |  |  |  |  |  | NOV
 | NOTES
Spreadsheet: 00cab62b-9b42-4204-b75e-3fd155c8777c
Sheet: Sheet1

NAME | RND 1 | RND 2 | FINAL
[NAME] | 49 | 51 | 100
[NAME] | 51 | 54 | 105
[NAME] | 51 | 54 | 105
[NAME] | 52 | 54 | 106
[NAME] | 53 | 54 | 107
PJ Vallentine | 54 | 54 | 108
[NAME] | 55 | 53 | 108
AJ Katchka | 55 | 54 | 109
[NAME] | 54 | 55 | 109
[NAME] | 55 | 55 | 110
[NAME] | 54 | 56 | 110
[NAME] | 57 | 54 | 111
[NAME] | 58 | 53 | 111
[NAME] | 58 | 54 | 112
[NAME] | 57 | 55 | 112
[NAME] | 59 | 54 | 113
[NAME] | 56 | 57 | 113
[NAME] | 57 | 56 | 113
[NAME] | 57 | 56 | 113
Ezra Gouge | 54 | 60 | 114
[NAME] | 56 | 59 | 115
[NAME] | 58 | 58 | 116
[NAME] | 57 | 60 | 117
[NAME] | 61 | 57 | 118
[NAME] | 57 | 61 | 118
[NAME] | 62 | 56 | 118
[NAME] | 59 | 60 | 119
[NAME] | 58 | 61 | 119
[NAME] | 58 | 62 | 120
[NAME] | 59 | 63 | 122
[NAME] | 61 | 61 | 122
[NAME] | 59 | 64 | 123
[NAME] | 61 | 62 | 123
[NAME] | 62 | 62 | 124
[NAME] | 59 | 67 | 126
[NAME] | 63 | 54 | 127
[NAME] | 61 | 66 | 126
[NAME] | 65 | 65 | 130
[NAME] | 67 | 63 | 130
[NAME] | 67 | 71 | 138
[NAME] | 80 | 74 | 154
Spreadsheet: 714022d1611063575-sum-with-multiple-criteria-sumifs-query
Sheet: Sheet1

 |  | TABLE A
 |  |  |  |  |  |  | 2020/21 | 2020/21 | 2020/21
 |  | CostCtre | DeptCode | Job Number | Project Number i.e. this is the NOC, NPFC or AT number | Project Header | Period Number | Period Number | Period Number
 |  |  |  |  |  |  | 10 | 11 | 12
 |  | ABC | DEP | 123 |  | Labour_Solutions | 1644.522530953505 | 1644.522530953505 | 1644.522530953505
 |  | DEF | DEP | 123 |  | Labour_Solutions | 27359.39386884803 | 27359.39386884803 | 27359.39386884803
 |  | GHI | DEP | 123 |  | Labour_Solutions | 48410.2402067556 | 48410.2402067556 | 48410.2402067556
 |  | JKL | DEP | 123 |  | Labour_Solutions | 3979.475667812074 | 3979.475667812074 | 3979.475667812074
 |  | MNO | DEP | 123 |  | Labour_Quality | 16018.07660019648 | 16018.07660019648 | 16018.07660019648
 |  | PQR | DEP | 123 |  | Labour_Quality | 8009.038300098238 | 8009.038300098238 | 8009.038300098238
 |  | TABLE B
 |  | Project | Project Header | Phase | Stage | Activity | Period Number | Period Number | Period Budget
 |  | 123 | Labour_Solutions |  |  |  | 10 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 10 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 10 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 10 | 2020
 |  | 123 | Labour_Quality |  |  |  | 10 | 2020
 |  | 123 | Labour_Quality |  |  |  | 10 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 11 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 11 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 11 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 11 | 2020
 |  | 123 | Labour_Quality |  |  |  | 11 | 2020
 |  | 123 | Labour_Quality |  |  |  | 11 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 12 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 12 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 12 | 2020
 |  | 123 | Labour_Solutions |  |  |  | 12 | 2020
 |  | 123 | Labour_Quality |  |  |  | 12 | 2020
 |  | 123 | Labour_Quality |  |  |  | 12 | 2020
 |  |  |  |  | Hi, How do I get the values in col H, I & J from table A into the table below by Project header and Period Number please?  I think it is some form of sumifs statement, but nothing I do is working.  Hoping someone can advise please.  Thank you so much in advance!  [NAME]
Spreadsheet: 771753d1646833385-issues-with-creating-summary-table-distinguishing-months-from-various-years-excel-help-document
Sheet: Summary Table

M4 Buoy Irish Sea Observation  between 03/05/2001 - 31/12/2018
Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Mean Wind speed (knots)
[NAME] (knots)
[NAME] (knots)
Mean Air Temperature (°C)
[NAME] (°C)
Min Air Temperature (°C)
Mean Sea Temperature (°C)
[NAME] (°C)
Min Sea Temperature (°C)
Mean [NAME] (metres)
Maximum Wave Height (metres)
Spreadsheet: work-breakdown-structure
Sheet: Help

HELP
https://www.vertex42.com/ExcelTemplates/work-breakdown-structure.html |  |  | © 2017 Vertex42 LLC
About this Template
 | This template provides a very basic WBS table that you can use for defining a hierarchical work breakdown structure for a project plan or process.
 | Want more features and automation?
 | Try the Gantt Chart Template by Vertex42.com
 | Note: The formula for the WBS numbering was developed by Vertex42.com for the Gantt Chart Template Pro spreadsheet, and is copyrighted. See the terms of use.
Instructions
1) | Choose a Level from the drop-down list in column B. The WBS code is created automatically. When adding rows, you will need to copy the formula in the WBS code column into the newly added rows.
2) | Indent Task Descriptions using the Indent buttons in the Home tab.
3) | Add or hide columns as needed.
4) | A conditional formatting rule automatically highlights level 1 tasks. Go to Home > Conditional Formatting > Manage Rules to remove or edit this rule.
Terms of Use
 | See the following page for information about how you may use this spreadsheet.
 | https://www.vertex42.com/licensing/EULA_privateuse.html
 | REFERENCES
SEE ALSO | Vertex42.com: [NAME]
SEE ALSO | Vertex42.com: Project Management Templates
TIPS | Vertex42.com: [NAME]
Spreadsheet: michelle_lokay__26811__RIghtFTS
Sheet: SC-SJ

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H:\1ZiminLu\1Zimin\OptionLibrary\Asian2\ResidOpt\Debug\residOpt.dll
 |  | Valuation Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StripVol
 |  | 2000-09-08 00:00:00 |  |  |  |  |  | daily volume (mmBTU) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KJKKKKBK
 |  |  |  |  |  |  |  | 20000 |  |  |  |  |  |  | Fuel |  | Forward Price Correlation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0475 |  | 0.95
 | mat |  | SOCAL | SJ | Volalitity | Int Rate | Days | Volume | DF | PV Volume |  | Rows | Years | Strip (Socal) | Strip (Permian) | Spread | Strip Vol (SOCAL) | Strip Vol (Permian) | Strike | Int | Correl | Correl+1% | T(days) | PV Volume | Total Intrinsic Value | Option Value | Option Value(+1%)
 |  | 2000-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | 18 | 1 |  |  |  |  |  | 0.3983 |  | 0.96
 |  | 2000-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | 30 | 2 |  |  |  |  |  | 0.3983 |  | 0.97
 |  | 2001-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 42 | 3 |  |  |  |  |  | 0.3983 |  | 0.98
 |  | 2001-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | 54 | 4 |  |  |  |  |  | 0.3983 |  | 0.99
 |  | 2001-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | 66 | 5 |  |  |  |  |  | 0.3983 |  | 0.995
 |  | 2001-04-01 00:00:00
 |  | 2001-05-01 00:00:00
 |  | 2001-06-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00
 |  | 2001-11-01 00:00:00
 |  | 2001-12-01 00:00:00
 |  | 2002-01-01 00:00:00
 |  | 2002-02-01 00:00:00
 |  | 2002-03-01 00:00:00
 |  | 2002-04-01 00:00:00
 |  | 2002-05-01 00:00:00
 |  | 2002-06-01 00:00:00
 |  | 2002-07-01 00:00:00
 |  | 2002-08-01 00:00:00
 |  | 2002-09-01 00:00:00
 |  | 2002-10-01 00:00:00
 |  | 2002-11-01 00:00:00
 |  | 2002-12-01 00:00:00
 |  | 2003-01-01 00:00:00
 |  | 2003-02-01 00:00:00
 |  | 2003-03-01 00:00:00
 |  | 2003-04-01 00:00:00
 |  | 2003-05-01 00:00:00
 |  | 2003-06-01 00:00:00
 |  | 2003-07-01 00:00:00
 |  | 2003-08-01 00:00:00
 |  | 2003-09-01 00:00:00
 |  | 2003-10-01 00:00:00
 |  | 2003-11-01 00:00:00
 |  | 2003-12-01 00:00:00
 |  | 2004-01-01 00:00:00
 |  | 2004-02-01 00:00:00
 |  | 2004-03-01 00:00:00
 |  | 2004-04-01 00:00:00
 |  | 2004-05-01 00:00:00
 |  | 2004-06-01 00:00:00
 |  | 2004-07-01 00:00:00
 |  | 2004-08-01 00:00:00
 |  | 2004-09-01 00:00:00
 |  | 2004-10-01 00:00:00
 |  | 2004-11-01 00:00:00
 |  | 2004-12-01 00:00:00
 |  | 2005-01-01 00:00:00
 |  | 2005-02-01 00:00:00
 |  | 2005-03-01 00:00:00
 |  | 2005-04-01 00:00:00
 |  | 2005-05-01 00:00:00
 |  | 2005-06-01 00:00:00
 |  | 2005-07-01 00:00:00
 |  | 2005-08-01 00:00:00
 |  | 2005-09-01 00:00:00
 |  | 2005-10-01 00:00:00
 |  | 2005-11-01 00:00:00
Spreadsheet: 755483d1636909438-offset-function-for-another-sheet-reference-point-error-allocation3-copy
Sheet: Monthly

Monthly Allocation
Purpose | To allocate the resource based on a monthly load
 | Note: Alloc Start must be first day of month and Alloc End must be last day of month
 | Project Manager
Allocation
 | Project | Alloc Start | Alloc End |  | Months | MonthlyAmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 |  | 2014-01-01 00:00:00 | 2014-06-30 00:00:00
 |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00
 |  | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
 |  | 2014-01-01 00:00:00 | 2014-04-30 00:00:00
 |  | 2014-03-01 00:00:00 | 2014-06-30 00:00:00
 |  | 2014-06-01 00:00:00 | 2014-12-31 00:00:00
Spreadsheet: 945237be-a2c4-4686-b479-823f5157f52d
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
FLEVO | Test | FLEVO | Levodopa, Serum/Plasma | Levodopa | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s).  (Serum gel tube is not acceptable.) Spin down and send  2 mL of serum frozen in plastic vial. Specimen must be frozen immediately or results  will be compromised. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum).   [NAME] blood in a lavender-top tube(s) or a green-top tube(s).   ([NAME] is not acceptable.) Spin down and send 2 mL of EDTA or heparinized plasma frozen in plastic vial.  [NAME] must be frozen immediately  or results will be compromised. Note:	1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma). | 0.7 mL | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, EDTA, heparin Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Reporting limit determined each analysis Steady state during chronic 3 to 8 gram p.o. dose: 0.2-3 mcg/mL plasma.   Test Performed by: NMS Labs                                       3701 Welsh Road                                       P.O. Box 433A                                       Willow Grove, PA 19090-0437 | Tuesday, Friday | 1 day | 5 days | 1 | 82491 |  |  |  |  | NMS Labs
FLEVO | [NAME] | VARIES | Varies |  |  |  | Frozen | 7 days
FLEVO | Result | [NAME] | Levodopa | Levodopa | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 9385-6
FLEVO | Result | [NAME] | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 787090d1657631101-seperate-large-data-set-across-multiple-tabs-sample-doc
Sheet: Master

Name | ACTUAL+FORECAST | CBS Code | Status (Complete) | Current ACCRUAL (inc withheld/under assessment) | ACTUAL to end Oct21 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00
Core Suppliers
A | 25312.625 | 220300 | Complete | 0 | 0 | 25312.625 | 0 | 0 | 0 | 0 | 0 | 0 | 0
b | 230749.8375 | 430100 | Complete | 0 | 218376.075 | 12373.7625 | 0 | 0 | 0 | 0 | 0 | 0 | 0
c | 21424.7125 | 220300 | Complete | 0 | 21424.7125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
d | 2540448.85 | 220300 |  | 385375.5625 | 1646570.05 | 124869.675 | 64597.2 | 104238.3 | 109210.5625 | 105587.5 | 0 | 0 | 0
e | 192334.1 | 710100 |  | 32871.4375 | 67493.225 | 34671.8125 | 10106.0125 | 21523.75 | 13089.7375 | 12578.125 | 0 | 0 | 0
f | 192470.2 | 430100 |  | 0 | 52521.075 | 29817.25 | 0 | 25662.5 | 33611.875 | 32757.5 | 18100 | 0 | 0
g | 10371.8625 | 430100 | Complete | 0 | 5184.825 | 0 | 5187.0375 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 461TR

461TR
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-08-30 00:00:00 |  |  | CJY | 2010-02-23 00:00:00 |  |  | JPR |  | 2010-06-23 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 342836d1409696050-event-calendar-with-recurring-event-140902_-calendar-of-events-2014-_-test
Sheet: Event Calendar - APR 15

 |  |  |  | EVENT CALENDAR
 |  |  |  |  |  | ENTER MONTH: | April
 |  |  |  |  |  | ENTER YEAR: | 2015
 |  |  |  |  |  | ENTER START DAY: | Sunday
 | TO EVENT LIST >>