tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73982d1274561286-trouble-with-laying-out-data-set-dataset_rev2
Sheet: Revenue Analysis

 | Forecast Month | Year
 | Jan | 2010
 |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
 |  | Complete
 |  | Live
 |  | Booked on
 |  | High Prob
 |  | Indentified
 |  | Blue Sky
 | Each department has a sheet similar to this in there revenue spreadsheets which capture the different parameters  from a detailed sheet.
Spreadsheet: 01bafca2-52ec-4ff2-8e38-ed8c9d4858af
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  |  | Derechos reservados de Visual Software   www.visual-software.net
 |  | Comercial Los Andes Ltda.
 |  | 000.000.000-0 |  |  | Comp. Egreso
 |  | [NAME] |  |  | Núm: | 0
 |  |  |  |  | Fecha:
 |  |  |  |  | Base:
 |  |  |  |  | Relativo:
 |  |  |  |  | Plazo:
 | Concepto:
 | Forma de pago: |  | Cta. Banco: |  | Cheque:
 | Cuenta |  |  | Débitos | Créditos
 |  |  | Sumas: | 0 | 0
 | Observaciones:
 | Elaboró: |  | Contabilizó: |  | Aceptado:
 | [NAME] 18 78-74 Of. 308 Tel:5304526 Fax:6364256
Spreadsheet: 51aba1b0-6236-4b9a-a459-77af92e2f561
Sheet: NCPC Daily Settlement

Real Time Net Commitment Period Compensation Settlement Report
SR_RTNCPCSTL_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT
Real Time NCPC Charges |  |  |  |  |  |  |  | NCPC Payments |  |  | Net NCPC Settlement | Real Time NCPC Charges |  |  | NCPC Payments | Net NCPC Settlement
Total Real Time Economic NCPC Credits | Participant Real Time Increment & Import Deviation | Participant Real Time NCPC Load Obligation Deviation | Participant Real Time Generation Deviation | Participant Real Time Deviation | Total Pool Real Time Deviation | Participant Real Time Economic NCPC Charges | Participant Real Time LSCPR Charge | Participant Real Time NON-VAR/SCR NCPC Payment | Participant Real Time VAR Payment | Participant Real Time SCR Payments | Participant Net Real Time NON-VAR/SCR NCPC Settlement | Participant Real Time Increment Deviation | Participant Real Time NCPC Import Deviation | Participant Real Time SCR NCPC Charges | Participant Real Time Economic, LSCPR, and SCR NCPC Payment | Participant Net Real Time Economic, LSCPR, and SCR NCPC Settlement
$ | MWh | MWh | MWh | MWh | MWh | $ | $ | $ | $ | $ | $ | MWh | MWh | $ | $ | $
Spreadsheet: 126616d1319775978-using-reference-with-inserting-rows-sample-1-
Sheet: Summary

task | ACTUALS | Planned
task 1 - draw |  |  | Solution 1
task 2 - build
task 3 - assemble something
task 4 - some task again
task | ACTUALS | Planned
task 1 - draw |  |  | Solution 2
task 2 - build
task 3 - assemble something
task 4 - some task again
task | ACTUALS | Planned
task 1 - draw |  |  | Solution 3
task 2 - build
task 3 - assemble something
task 4 - some task again
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 2010-11

Table C
Graduate Student Numbers by Faculty and Year Group
2010-11
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Year 6+ | Total
Arts and Humanities | 729 | 193 | 48 | 26 | 14 | 6
Biomedical Sciences | 1334 | 608 | 239 | 151 | 90 | 14
Built Environment | 833 | 131 | 62 | 25 | 10 | 14
Engineering Sciences | 1187 | 173 | 120 | 57 | 23 | 5
Laws | 515 | 23 | 8 | 4 | 1 | 2
Life Sciences | 801 | 240 | 182 | 54 | 12 | 5
Mathematical and Physical Sciences | 339 | 101 | 108 | 50 | 12 | 2
Social and Historical Sciences | 1487 | 252 | 87 | 50 | 21 | 17
Total
The Biomedical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 8d2e3fba-1cc1-4b65-bd1e-f2103f3857eb
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
9945 | Test | 9945 | Verhoeff's Elastic Tissue-Van Gieson's (V-ELVG) Stain for Collagen and Elastic Fibers | Verhoeffs Elastic Tiss [NAME] | Includes pathology consultation charged separately. | H & E Slide: HE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88313 |  |  |  |  | Rochester
9945 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
9945 | Result | 9945 | Verhoeffs Elastic Tiss [NAME] | Verhoeffs Elastic Tiss [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10748-2
Spreadsheet: 540273d1506605348-re-arrange-the-data-analysis-2
Sheet: Analysis

I would like to see my result like this based on criteria A5 |  |  |  |  |  |  |  | Data base model
XA3 |  |  |  |  |  |  |  | XA1 | E | SADMN | SAJUB | AEJEA | SAJED
 | E | I | Port |  |  |  |  | XA1 | I | SAJED | AEKLF | AEJEA | SADMN
 | 1 | 1 | AEKLF |  |  |  |  | XA2 | E | PKKHI | INMUN | OMSOH | AEJEA | BHBAH | KWSAA | IQUQR
 | 1 |  | AEJEA |  |  |  |  | XA2 | I | PKKHI | IQUQR | BHBAH | AEAUH | [NAME] | AEJEA | OMSOH
 | 1 |  | PKKHI |  |  |  |  | XA3 | E | AEKLF | AEJEA | PKKHI | INMUN | INNSA | SAJED
 | 1 |  | INMUN |  |  |  |  | XA3 | I | SAJED | AEKLF
 | 1 |  | INNSA |  |  |  |  | XA4 | E | INNSA | INHZR | INMUN | SARUH
 | 1 | 1 | SAJED |  |  |  |  | XA4 | I | SARUH | DJJIB | PKBQM | INNSA
 |  |  |  |  |  |  |  | XA5 | E | INNSA | INMUN | SAJED
 |  |  |  |  |  |  |  | XA5 | I | SAJED | AEKLF | AEJEA | PKBQM | INNSA
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74029

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 404 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20365 |  | Contracts & Agreements |  |  |  |  |  | [NAME]
 |  | Gulfstar Energy, Inc |  |  |  | 11/1/96 | 11/1/96
 |  | EnSerCo Sr Rev Credit Facility |  |  |  | 01/01/98 | 01/01/98
 |  | Bonus Resource Services Corp |  |  |  | 08/01/98 | 08/01/98
 |  | EnSerCo Loan Facility to Bonus Resources
 |  | Vol. 1 & 2 |  |  |  | 06/01/98 | 06/01/98
 |  | [NAME], Ltd |  |  |  | 06/01/98 | 06/01/98
 |  | [NAME], Ltd |  |  |  | 12/01/97 | 12/01/97
 |  | Tripoint |  |  |  | 08/01/97 | 08/01/97
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: 92780d1292339591-help-automatic-insert-or-delete-row-and-column-with-vba-bcaonew
Sheet: Sheet2

January | 8 | 10
February | 4 | 8
March | 11 | 5
April | 6 | 9
May | 7 | 4
June | 10 | 8
July | 12 | 0
August | 6 | 10
September | 3 | 9
October | 5 | 11
Novembe | 8 | 4
December | 12 | 7
Spreadsheet: 365d298b-bfdd-427f-b7c1-6069318c9235
Sheet: Sheet1

Suggested Timeline for CME Courses | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Task | Chronological Timeline | Task Assignee | Due Date | Date Completed
Identify Professional Practice Gaps | 12 Months | Course Director
Identify Intended Program Outcomes | 12 Months | Course Director
Identify Target Audience | 12 Months | Course Director
Contact CME Department to request CME sponsorship | 12 Months | Course Director
Review "What You Need to Know" Planning Document & CME Application | 12 Months | Course Director
Select Planning Committee | 12 Months | Course Director
Select Date | 12 Months | Course Director/Committee
Select Location | 12 Months | Course Director/Committee
Submit Completed Application to CME Department | 12 Months | Course Director
Select Specific Topics/Draft Agenda | 9-12 months | Course Director/Committee
Invite Speakers | 9-12 Months | Course Director
Send Speaker Packets | 9-12 Months | Course Director/Support Staff
Create Draft Budget | 6-12 Months | Course Director
Apply for Pharmaceutical Grants | 6-8 Months | CME
Invite Vendors to Display | 6-8 Months | Course Director/Support Staff
Review Speaker COI Forms/Submit to CME | 6-8 Months | Course Director/CME
[NAME] the Date to Marketing (if applicable) | 6 Months | Course Director/Support Staff
Order/Prepare Marketing Distribution Lists | 6 months | Support Staff
Send Marketing STD Draft to CME for approval | 6 months | Support Staff
Distribute Save the Date Card | 4-6 Months | Support Staff
Send Brochure Text to Marketing | 4-6 Months | Support Staff
Send Brochure Drafts to CME for approval | 4-6 Months | Support Staff
Confirm Speaker [NAME] | 4 Months | Support Staff
Confirm Vendor Exhibits | 4 Months | Support Staff
Confirm Audiovisual | 4 Months | Support Staff
Distribute Brochure | 3-4 Months | Support Staff
Register Participants | Ongoing | Support Staff
Confirmation Letters to Participants | Ongoing | Support Staff
Confirm Individual Speakers AV Needs | 6-8 Weeks | Support Staff
Confirm Catering/Room Set Up | 6-8 Weeks | Support Staff
[NAME] | 2-4 Weeks | Support Staff
[NAME] | 2 Weeks | Support Staff
Print Syllabus/Handouts | 1-2 Weeks | Support Staff
Create & Print Sign-In Roster | 1-2 Weeks | Support Staff
Create & Print Evaluation | 1-2 Weeks | Support Staff
Create & Print Name Badges | 1 Week | Support Staff
Finalize Count for Catering | 3-5 Days | Support Staff
Finalize AV Needs | 3-5 Days | Support Staff
Post Conference Documents to CME | 1-2 Weeks Post | Support Staff
Send Certificates | 1-2 Weeks Post | CME
Evaluation Summary | 2-4 Weeks Post | CME
Final Budget to CME | 2-4 Weeks Post | Support Staff
Outcome Measurement Survey | 3 Months Post | CME
Spreadsheet: 94275d1294140456-vlookup-and-date-problem-weeklyonlinereporthelp
Sheet: Weekly

 | Week Commencing | Visits
 | 2010-01-03 00:00:00
 | 2010-01-10 00:00:00
 | 2010-01-17 00:00:00
 | 2010-01-24 00:00:00
 | 2010-01-31 00:00:00
 | 2010-02-07 00:00:00
 | 2010-02-14 00:00:00
 | 2010-02-21 00:00:00
 | 2010-02-28 00:00:00
 | 2010-03-07 00:00:00
 | 2010-03-14 00:00:00
 | 2010-03-21 00:00:00
 | 2010-03-28 00:00:00
 | 2010-04-04 00:00:00
 | 2010-04-11 00:00:00
 | 2010-04-18 00:00:00
 | 2010-04-25 00:00:00
 | 2010-05-02 00:00:00
 | 2010-05-09 00:00:00
 | 2010-05-16 00:00:00
 | 2010-05-23 00:00:00
 | 2010-05-30 00:00:00
 | 2010-06-06 00:00:00
 | 2010-06-13 00:00:00
 | 2010-06-20 00:00:00
 | 2010-06-27 00:00:00
 | 2010-07-04 00:00:00
 | 2010-07-11 00:00:00
 | 2010-07-18 00:00:00
 | 2010-07-25 00:00:00
 | 2010-08-01 00:00:00
 | 2010-08-08 00:00:00
 | 2010-08-15 00:00:00
 | 2010-08-22 00:00:00
 | 2010-08-29 00:00:00
 | 2010-09-05 00:00:00
 | 2010-09-12 00:00:00
 | 2010-09-19 00:00:00
 | 2010-09-26 00:00:00
 | 2010-10-03 00:00:00
 | 2010-10-10 00:00:00
 | 2010-10-17 00:00:00
 | 2010-10-24 00:00:00
 | 2010-10-31 00:00:00
 | 2010-11-07 00:00:00
 | 2010-11-14 00:00:00
 | 2010-11-21 00:00:00
 | 2010-11-28 00:00:00
 | 2010-12-05 00:00:00
 | 2010-12-12 00:00:00
 | 2010-12-19 00:00:00
 | 2010-12-26 00:00:00
 | 2011-01-02 00:00:00
 | 2011-01-09 00:00:00
 | 2011-01-16 00:00:00
 | 2011-01-23 00:00:00
 | 2011-01-30 00:00:00
Spreadsheet: jay_reitmeyer__13559__judgement house volunteers
Sheet: Sheet1

Reservation & Registration Volunteer Schedule
2001-10-28 00:00:00
Time | Director | Asst. Director | Greeter #1 | Greeter #2 | Data Entry #1 | Data Entry #2 | Guest Organizer #1 | Guest Organizer #2 | [NAME]
7:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
8:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
9:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2001-10-29 00:00:00
Time | Director | Asst. Director | Greeter #1 | Greeter #2 | Data Entry #1 | Data Entry #2 | Guest Organizer #1 | Guest Organizer #2 | [NAME]
7:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
8:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
9:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
2001-10-30 00:00:00
Time | Director | Asst. Director | Greeter #1 | Greeter #2 | Data Entry #1 | Data Entry #2 | Guest Organizer #1 | Guest Organizer #2 | [NAME]
7:00pm | [NAME] | [NAME] | [NAME] | June Smothers | [NAME] |  | [NAME] | [NAME] | [NAME]
8:00pm | [NAME] | [NAME] | [NAME] | June Smothers | [NAME] |  | [NAME] | [NAME] | [NAME]
9:00pm | [NAME] | [NAME] | [NAME] | June Smothers | [NAME] |  | [NAME] | [NAME] | [NAME]
2001-10-31 00:00:00
Time | Director | Asst. Director | Greeter #1 | Greeter #2 | Data Entry #1 | Data Entry #2 | Guest Organizer #1 | Guest Organizer #2 | [NAME]
7:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
8:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
9:00pm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 36091d1233853208-vlookup-not-ready-numbers-vlookup-example
Sheet: Sheet2

Vendor - Vendor No. | Vendor - Company Code | Vendor - Purchasing Organistion | Vendor - Original Payment Code
1000000244 | 6500 |  | #N/A
1000000001 | 6500 |  | #N/A
1900024260 | 6500 |  | #N/A
1900024260 | 6503 |  | #N/A
1900040735 | 6500 |  | #N/A
1900014280 | 6500 |  | #N/A
1900027620 | 6503 |  | #N/A
1900005270 | 6503 |  | #N/A
1900012400 | 6500 |  | #N/A
1900012400 | 6503 |  | #N/A
1900004820 | 6500 |  | #N/A
1900004820 | 6503 |  | #N/A
1900040948 | 6500 |  | #N/A
1900019060 | 6500 |  | #N/A
1900006230 | 6500 |  | #N/A
1900006230 | 6503 |  | #N/A
1900024530 | 6500 |  | #N/A
1900015410 | 6500 |  | #N/A
1900040541 | 6500 |  | #N/A
1900040541 | 6503 |  | #N/A
1900001180 | 6500 |  | #N/A
1000063710 | 6500 |  | #N/A
1000063424 | 6500 |  | #N/A
1900041490 | 6500 |  | #N/A
Spreadsheet: 841730d1693906509-data-validation-based-on-index-match-temp_2023
Sheet: Invoice

 |  | INVOICE
 |  |  | Date:
 |  |  | PO #:
 |  |  | Invoice #: | 328
 |  |  | Currency: | PKR
Style No. | Item Description | Quantity | Unit Price | Amount
 | Fancy Button
 | Fancy Button
 |  | TOTAL
Make sure all checks payable to Sohail Cloth & Zari Center.
Thank you for your business!
Should you have any enquiries concerning this invoice, please contact SCZ.
This is computer generated invoice no signature required.*
Spreadsheet: 164133d1340655427-excel-2007-need-help-pulling-info-from-several-tabs-into-one-final-tab-orders
Sheet: Tue

STORE # | 12
STORE | DAVE |  |  |  |  | Date: | 2012-06-19 00:00:00
ORDER # | 965482
# of Pages | 5
Puller | Justin |  |  | QA | Tonya |  |  | Stacker | [NAME] |  |  |  | TOTAL
Start | 07:00:00 |  |  | Start | 08:40:00 |  |  | Start | 08:00:00 |  |  |  | 1.916666666666668
End | 08:00:00 |  |  | End | 09:05:00 |  |  | End | 08:30:00
Total | 0.9999999999999991 |  |  | Total | 0.4166666666666679 |  |  | Total | 0.5000000000000009
 | Over Pack | Full Case | Total
Units | 149 | 264
Lines | 8 | 17
Cartons | 2 | 51 | 53
STORE # | 13
STORE | Kelly
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE # | 14
STORE | JACK
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE # | 15
STORE | JILL
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE # | 16
STORE | CAT
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE # | 17
STORE | [NAME]
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
Spreadsheet: 355927d1414860566-auto-filter-test-marks
Sheet: Failed

Name | Marks Science | Maths | English | Physics | History | GK | Remarks
Spreadsheet: 849554d1699982664-sum-output-per-year-excel-example
Sheet: Sheet1

Delivery Plan |  |  |  |  |  |  |  |  |  |  |  | Summary - Output |  |  |  | Year | Total Quantity
Tranche 1 | Quantity 1 | Tranche 2 | Quantity 2 | Tranche 3 | Quantity3 | Tranche 4 | Quantity 4 | Tranche 5 | Quantity 5 | Tranche 6 | Quantity 6 | 2022 | 2023 | 2024 | 2025 | 2022 | 36
2023-01-01 00:00:00 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 | 470
2023-11-01 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024 | 73
2024-10-01 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025 | 365
2025-08-01 00:00:00 | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026 | 70
2023-07-01 00:00:00 | 25
2022-01-01 00:00:00 | 6
2024-02-01 00:00:00 | 3
Spreadsheet: 859304d1707736916-formula-to-calculate-dependent-on-closest-two-variables-in-columns-test2
Sheet: Sheet1

 | Variable 1 |  |  |  | Variable 2 |  |  | Variable 3 | Total
Test 1 | 100 |  |  | [NAME] | 95 |  | sdf | 80
Test 2 | 100 |  |  | asdfg | 96 |  | hjfe | 95
Test 3 | 100 |  |  |  | 90 |  |  | 98.5
Test 4 | 100 |  |  | [NAME] | 95 |  | sdf |  | 97.5
Test 5 | 100 |  |  | asdfg |  |  | hjfe | 95 | 97.5
Test 6 |  |  |  |  | 90 |  |  | 100 | 95
Spreadsheet: 467624d1466787918-automatically-populating-chart-2-from-numbers-in-chart-1-example
Sheet: Chart 1

 |  | Daily Numbers
Shift | I H | Rivet | Turn | Pack
1 | 2196 | 2117 | 2134 | 1860
 |  |  | 35
2 | 1885 | 2174 | 2267 | 2368
 |  |  | 15
3 | 2150 | 1900 | 1403 | 1717
 |  |  | 23
Total
Scrap
 |  | Total Turn |  |  | Total  Yield
 |  |  | Total  Scrap
 |  |  | Total Scrap %
 | I need to be able to populate this chart and it automatically populate in Chart 2. I also need it to automatically change to the next day on chart two. Example: Chart 1, Cell B3 500, Cell C3 600. I would need  cell C6 and D6 in Chart 2 to show 500 and 600 respectively. I also need it to fill in the correct date on chart 2 based on CELL E1 (today function) in Chart 2. .
Spreadsheet: da9e365d-7d0b-4c3e-af1c-103717520e82
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
FIXKM | Test | FIXKM | Hemophilia B, Factor IX Gene Known Mutation Screening | Factor IX Gene Known Mutation | Polymerase Chain Reaction (PCR)/Fluorescent DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Yellow-Top (ACD) Tube: ACD |  |  | 6 | mL | Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: EDTA or sodium citrate [NAME]: 6 mL Collection Instructions:  1. Invert several times to mix blood.  2. Send specimen in original tube. Forms:  1. Hemophilia B Patient Information Sheet (Supply T518) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK - phone lab Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Green-top (heparin) tube or cord blood | An interpretive report will be issued which will include specimen information, assay information, background information, and conclusions based on the test results (ie, information about the mutation and carrier status). | Monday through Friday | 21 days | 28 days | 1 | 81403 |  |  |  |  | Rochester
FIXKM | [NAME] | BLOOD | Whole blood |  |  |  | Ambient
FIXKM | Result | 23763 | F IX Know Mut Reason for Referral | F IX Know Mut Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
FIXKM | Result | 23764 | Factor IX Known Mutation Method | Factor IX Known Mutation Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FIXKM | Result | 23765 | Factor IX Known Mutation  Result | Factor IX Known Mutation  Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69483-6
FIXKM | Result | 23766 | Factor IX Known Mutation Interp | Factor IX Known Mutation Interp | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69049-5
FIXKM | Result | 23768 | Factor IX Known Mut Reviewed By | Factor IX Known Mut Reviewed By | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 693764d1599140139-display-cell-data-if-multiple-criteria-match-test
Sheet: Sheet1

 |  | AB | AC | AD | AE
128 | Budget
 | Spent
 | Planned
 | Remaining
129 | Budget
 | Spent
 | Planned
 | Remaining
130 | Budget
 | Spent
 | Planned
 | Remaining
131 | Budget
 | Spent
 | Planned
 | Remaining
132 | Budget
 | Spent
 | Planned
 | Remaining
Spreadsheet: 834549d1687894256-boolean-or-in-an-array-formula-test
Sheet: Sheet1

Lv | Length | Ref | Ref 2
5 | 10 | core
2 | 10 |  | something
1 | 10 | never
5 | 10 |  | mind
8 | 10 |  | core
1 | 10 | core | core
2 | 10 | yes | no