tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 176599d1345963351-tidy-up-printed-invoice-factuur_excel-forum
Sheet: Hulp_Code

Ja & Nee |  | Gebruiker |  | Bedrijfsvorm |  | Geslacht |  | BTW |  | Periodiek |  | Soorklant
 |  |  |  | Eenmanszaak (EZ)
 |  | Abou |  | Maatchap (MTS) |  | de heer |  | 0 |  | Maand |  | Privé
 |  | [NAME] |  | Commanditaire vennootschap (CV) |  | mevrouw |  | 0.06 |  | Kwartaal |  | Zakelijke
 |  | [NAME] |  | Besloten vennootschap (BV) |  |  |  | 0.19 |  | [NAME]
 |  | [NAME] |  | Naamloze vennootschap (NV) |  |  |  | 0.21 |  | [NAME]
 |  | Michel |  | Vereniging |  |  |  | [NAME]
 |  | Joop |  | Stichting
 |  | [NAME] |  | [NAME]
 |  |  |  | Onderlinge waarborgmaatschappij
Spreadsheet: louise_kitchen__23955__SepYTD Orig w notes sf
Sheet: Development

Development
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Booth |  | Power |  | Development |  | 6000000
[NAME] |  | Power |  | Development |  | 5729000
Mitro |  | Power |  | Development |  | 3350000
Tapscott |  | Power |  | Development |  | 1600000
Total
Spreadsheet: 868416d1715162058-calculating-summary-sheet-using-indirect-function-for-multiple-months-yiyi2-payroll-example
Sheet: Summary

Emp Code | [NAME] | Surname | Date Joined | Terminated | Work Month | Total Roster Hour | [NAME] | OW Hour | WW Hour | Total Work Hour | Lateness | Overtime | Early Leave | Total Roster Day | OP Day | OW Day | WW Day | Total Work Days | SL | OFF | NPL | SH | AL
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-04-01 00:00:00
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-03-01 00:00:00
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-02-01 00:00:00
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-01-01 00:00:00
Spreadsheet: 36141d1233915418-how-to-deduct-holidays-and-take-multiple-projects-into-account-in-a-report-project-overlap
Sheet: Sheet1

Project | Start Date | End Date | Employee |  |  |  |  |  | Public Holidays
A | 2008-12-20 00:00:00 | 2008-12-31 00:00:00 | Mr [NAME] |  |  |  |  |  | 2008-12-25 00:00:00
B | 2009-01-01 00:00:00 | 2009-01-31 00:00:00 | Mr [NAME] |  |  |  |  |  | 2008-12-26 00:00:00
C | 2009-01-01 00:00:00 | 2009-01-15 00:00:00 | Mr [NAME] |  |  |  |  |  | 2009-01-01 00:00:00
 | Project A: | 6 | This should be fine as it is.
 | Project B: | 21 | This should take into account that Project C was worked on at the same time, so, 5 network days should be deducted (e.g. Half of the Project C network days).
 | Project C: | 10 | And here, the whole project should be halfed, as Project B was worked on during the whole project period.
Spreadsheet: rick_buy__32898__money market wksht _2
Sheet: Sheet1

a/o 10/22/01
Product |  | Class | Yield
AIM Institutional - Short Term Investments |  | Cash Mgmt. | 0.0265
(STIC Prime) - Primary Investments |  | Resource | 0.0257
Taxable |  | Private | 0.0249
AIM Institutional - Short Term Investment Trust |  | Cash Mgmt. | 0.0271
(STIC Liquid) - Treasury Portfolio |  | Resource | 0.0259
Taxable |  | Private | 0.0249
AIM Institutional - Short Term Investment Trust |  | Cash Mgmt. | 0.0259
(STIT Treasury) |  | Resource | 0.0251
Taxable |  | Private | 0.0237
ARPS - 7 Day - Taxable |  |  | 0.0275
- 28 Day - Taxable |  |  | 0.0275
AIM Institutional - Cash Reserve Portfolio |  | Cash Mgmt | 0.0191
Tax Free Investments Co. - Cash Reserve |  | Resource | 0.0183
Short Term Municipal |  | Private | 0.0174
ARPS - 7 Day - Tax Free |  |  | 1.70-1.90%
- 28 Day - Tax Free |  |  | 0.028
Treasuries |  |  | 0.05375
Spreadsheet: 876535d1723236241-multi-criteria-lookup-multi-condition-lookup
Sheet: Sheet1

 |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
Order | Period | Year | % split 1 | Cost Centre 1 | % split 2 | Cost Centre 2 |  | Order | Period | Year | % split 1 | Cost Centre 1 | % split 2 | Cost Centre 2 |  | Order Split & CC Master Table
Ord1 | 12 | 2024 |  |  |  |  |  | Ord1 | 12 | 2024 |  | A |  |  |  | Order | From Year | From Period | To Year | To Period | % split | Cost Centre | Helper From | Helper To
Ord1 | 4 | 2025 |  |  |  |  |  | Ord1 | 4 | 2025 | 1 | C |  |  |  | Ord1 | 2024 | 1 | 2024 | 12 | 1 | A
Ord2 | 3 | 2025 |  |  |  |  |  | Ord2 | 3 | 2025 | 0.5 | F | 0.5 | G |  | Ord1 | 2025 | 1 |  |  | 1 | C
Ord2 | 1 | 2025 |  |  |  |  |  | Ord2 | 1 | 2025 | 0.5 | D | 0.5 | E |  | Ord2 | 2022 | 1 | 2025 | 1 | 0.5 | D
Ord3 | 10 | 2024 |  |  |  |  |  | Ord3 | 10 | 2024 |  |  |  |  |  | Ord2 | 2022 | 1 | 2025 | 1 | 0.5 | E
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ord2 | 2025 | 2 |  |  | 0.5 | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ord2 | 2025 | 2 |  |  | 0.5 | G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ord3 | 2023 | 11 |  |  | 1 | H
Steps:
1. Take [NAME] number, period & year (columns A, B & C) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Note blank end year/periods means it's the latest active rule
2. Use the info from step 1 to find the relevant info from the master table on the right (blue)
Spreadsheet: 723657d1615822989-if-isnumber-formula-update-cells-with-character-depending-on-dates-actygation-holiday-forms-2021
Sheet: Colleague 20

HOLIDAY FORM 2021
NAME: |  |  |  | 2020 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday)
2021 ENTITLEMENT |  | 25 |  | 05/04/2021 (Easter Monday)
CARRIED OVER FROM 2020 |  | 5 |  | 03/05/2021 (May Bank Hol)
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol)
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2021 (Aug Bank Hol)
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2020 (Xmas Day)
Reason: |  |  |  | 28/12/2020 (Xmas BH Day)
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
2021-06-04 00:00:00 | 13/04/2021 | 6
2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 1
22/01/2021 | 22/01/2021 | 0.5
29/01/2021 | 29/01/2021 | 0.5
15/07/2021 | 16/07/2021 | 2
16/08/2021 | 17/08/2021 | 2
29/12/2021 | 31/12/2021 | 3
25/10/2021 | 29/10/2021 | 5
Spreadsheet: 220475d1363177160-return-row-and-column-number-from-cell-in-2d-array-match-offset
Sheet: Blad1

 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
18.7 | 90 | 91 | 92 | 92 | 93 | 94 | 94 | 95 |  |  | 18.3 | 95
18.6 | 91 | 91 | 92 | 93 | 94 | 94 | 95 | 96
18.5 | 91 | 92 | 93 | 93 | 94 | 95 | 96 | 96 |  |  |  |  |  |  |  | [NAME] (De eerste waarde (95) moet verwijzen naar 13 en niet naar 14)
18.4 | 92 | 92 | 93 | 94 | 95 | 95 | 96 | 97
18.3 | 92 | 93 | 94 | 95 | 95 | 96 | 97 | 98 |  |  | 18 | 99
18.2 | 93 | 94 | 94 | 95 | 96 | 97 | 97 | 98
18.1 | 93 | 94 | 95 | 96 | 97 | 97 | 98 | 99 |  |  |  |  |  |  |  | [NAME] (De eerste waarde (99) moet verwijzen naar 16 en niet naar 17)
18 | 94 | 95 | 96 | 96 | 97 | 98 | 99 | 99
17.9 | 95 | 95 | 96 | 97 | 98 | 98 | 99 | 100
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
18.7 | 90 | 91 | 92 | 92 | 93 | 94 | 94 | 95 |  |  | 18.3 | 13
18.6 | 91 | 91 | 92 | 93 | 94 | 94 | 95 | 96
18.5 | 91 | 92 | 93 | 93 | 94 | 95 | 96 | 96 |  |  |  |  |  |  |  | Resultaat
18.4 | 92 | 92 | 93 | 94 | 95 | 95 | 96 | 97
18.3 | 92 | 93 | 94 | 95 | 95 | 96 | 97 | 98 |  |  | 18 | 16
18.2 | 93 | 94 | 94 | 95 | 96 | 97 | 97 | 98
18.1 | 93 | 94 | 95 | 96 | 97 | 97 | 98 | 99 |  |  |  |  |  |  |  | Resultaat
18 | 94 | 95 | 96 | 96 | 97 | 98 | 99 | 99
17.9 | 95 | 95 | 96 | 97 | 98 | 98 | 99 | 100
 |  |  |  |  |  |  |  |  |  |  |  | Resultaat
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
18.7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  | 44
18.6
18.5
18.4
18.3 |  |  |  |  |  |  |  |  |  |  |  |  | 77
18.2
18.1
18 |  |  |  |  |  |  |  |  |  |  |  | Resultaat
17.9
Spreadsheet: 224887d1364821405-check-this-employee-was-off-or-absence-oxogen
Sheet: Leaves

Employment ID Num | Start | End
123 | 2013-03-21 00:00:00 | 2013-03-27 00:00:00
456 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
789 | 2013-03-09 00:00:00 | 2013-03-22 00:00:00
123 | 2013-02-21 00:00:00 | 2013-02-28 00:00:00
789 | 2013-02-02 00:00:00 | 2013-02-06 00:00:00
789 | 2013-01-10 00:00:00 | 2013-01-16 00:00:00
Spreadsheet: 68338d1268855569-pulling-off-a-specific-value-from-a-table-testsumprod
Sheet: Sheet1

 |  | 2009 | 2009 | 2010 | 2010 | Region | Person
Region | Person | £ | No | £ | No | UK | Man1
UK | Man1 | 342 | 43 | 24 | 4
UK | Man1 | 2342 | 42 | 234 | 45
UK | Man1 | 234 | 23 | 32 | 5
UK | Man1 | 3242 | 234 | 4 | 4
UK | Man1 | 3 | 4 | 24 | 45
UK | Man2 | 42 | 423 | 5 | 45
UK | Man2 | 4 | 3 | 45 | 5
UK | Man2 | 4 | 234 | 4 | 54
UK | Man2 | 324 | 4 | 5 | 4
UK | Man2 | 324 | 2 | 4 | 5
USA | Man1 | 324 | 234 | 54 | 543
USA | Man1 | 2 | 4 | 5 | 4
USA | Man1 | 42 | 32 | 4 | 45
USA | Man1 | 4 | 24 | 545 | 5
USA | Man1 | 2 | 4 | 4 | 4
USA | Man2 | 42 | 2 | 5 | 5
USA | Man2 | 34 | 42 | 45 | 4
USA | Man2 | 234 | 4 | 4 | 45
USA | Man2 | 234 | 432 | 54 | 5
USA | Man2 | 4 | 3 | 5 | 5
Spreadsheet: 819803d1677694885-determining-first-5-instances-of-a-date-in-a-table-excelhelp
Sheet: Sheet1

Agent | Date | Year |  | Agent | 1 | 2 | 3 | 4 | 5
[NAME] | 2022-03-02 00:00:00 | 2022 |  | [NAME] |  | 2023-01-13 00:00:00 | 2023-01-27 00:00:00 | 2023-02-08 00:00:00 | 2023-02-13 00:00:00
[NAME] | 2022-03-07 00:00:00 | 2022 |  | [NAME] | 2023-01-19 00:00:00 | 2023-01-20 00:00:00 | 2023-01-24 00:00:00
[NAME] | 2022-03-15 00:00:00 | 2022 |  | [NAME] | 2023-01-05 00:00:00 | 2023-02-23 00:00:00
[NAME] | 2022-07-12 00:00:00 | 2022
[NAME] | 2022-07-25 00:00:00 | 2022
[NAME] | 2022-08-31 00:00:00 | 2022
[NAME] | 2022-10-04 00:00:00 | 2022
[NAME] | 2022-10-28 00:00:00 | 2022
[NAME] | 2022-11-10 00:00:00 | 2022
[NAME] | 2022-11-28 00:00:00 | 2022
[NAME] | 2022-12-12 00:00:00 | 2022
[NAME] | 2022-12-16 00:00:00 | 2022
[NAME] | 2022-12-29 00:00:00 | 2022
[NAME] | 2023-01-11 00:00:00 | 2023
[NAME] | 2023-01-13 00:00:00 | 2023
[NAME] | 2023-01-27 00:00:00 | 2023
[NAME] | 2023-02-08 00:00:00 | 2023
[NAME] | 2023-02-13 00:00:00 | 2023
[NAME] | 2022-03-07 00:00:00 | 2022
[NAME] | 2022-03-10 00:00:00 | 2022
[NAME] | 2022-04-26 00:00:00 | 2022
[NAME] | 2022-05-04 00:00:00 | 2022
[NAME] | 2022-07-14 00:00:00 | 2022
[NAME] | 2022-08-01 00:00:00 | 2022
[NAME] | 2022-08-02 00:00:00 | 2022
[NAME] | 2022-09-09 00:00:00 | 2022
[NAME] | 2022-09-13 00:00:00 | 2022
[NAME] | 2022-10-17 00:00:00 | 2022
[NAME] | 2022-10-20 00:00:00 | 2022
[NAME] | 2022-11-10 00:00:00 | 2022
[NAME] | 2022-11-29 00:00:00 | 2022
[NAME] | 2022-12-22 00:00:00 | 2022
[NAME] | 2023-01-19 00:00:00 | 2023
[NAME] | 2023-01-20 00:00:00 | 2023
[NAME] | 2023-01-24 00:00:00 | 2023
[NAME] | 2022-08-31 00:00:00 | 2022
[NAME] | 2022-09-27 00:00:00 | 2022
[NAME] | 2022-10-20 00:00:00 | 2022
[NAME] | 2022-11-01 00:00:00 | 2022
[NAME] | 2023-01-05 00:00:00 | 2023
[NAME] | 2023-02-23 00:00:00 | 2023
Spreadsheet: 0d72f6c1-9a0b-4efd-b6c5-679628938c4b
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | RECRUITMENT
 |  |  |  |  |  |  | BRANCH: MULGRAVE
 |  |  |  |  |  |  | TIMESHEET: send approved timesheets to [EMAIL]
 |  |  |  |  |  |  | or FAX to: 1800 652 808 before 9am Monday
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email: [EMAIL]
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 745 Springvale Road, MULGRAVE VIC 3170
August 2010
Spreadsheet: 98196d1297208311-sum-with-criteria-need_help
Sheet: Dec

 | Part Number |  |  |  |  |  |  | Category | Sub-Category |  |  | Delivery Location |  |  |  | Delivered Price | Supplier
 | 1 |  |  |  |  |  |  | Fittings | Code 62 |  |  | Fort Payne, AL |  |  |  | 10000
 | 2 |  |  |  |  |  |  | Fittings | Code 62 |  |  | Fort Payne, AL |  |  |  | 5000
 | 3 |  |  |  |  |  |  | Fittings | 37° Flare J533b |  |  | Fort Payne, AL |  |  |  | 7000
Spreadsheet: 64071d1264937306-using-sum-in-auto-filter-faults-data
Sheet: Validation

P | U | C | F | DT
8 | 1 | 1 | red | 5
9 | 2 | 2 | yellow | 10
10 | 3 | 3 | green | 15
11 | 4 | 4 | blue | 20
12 | 5 | 5 | purple | 25
13 | 6 | 6 | orange | 30
14 | 7 | 7 | grey | 35
15 | 8 | 8 | black | 40
16 | 9 |  | [NAME] | 45
17 | 10 |  |  | 50
18 |  |  |  | 55
19 |  |  |  | 60
 |  |  |  | 65
 |  |  |  | 70
 |  |  |  | 75
 |  |  |  | 80
 |  |  |  | 85
 |  |  |  | 90
 |  |  |  | 95
 |  |  |  | 100
 |  |  |  | 105
 |  |  |  | 110
 |  |  |  | 115
 |  |  |  | 120
Spreadsheet: 477638d1472447933-conventional-index-match-not-perhaps-2-other-ways-with-condition-index-match-2-other-ways-or-might-need-offset
Sheet: Desired Index-Match 3

VALUE-1 | POINTS-1 | VALUE-2 | POINTS-2 | VALUE-3 | POINTS-3 | VALUE-4 | POINTS-4 | VALUE-5 | POINTS-5 | VALUE-6 | POINTS-6
100 | 4 | 10 | 7 | 10 | 7 | 99 | 4 | 13 | 35 | 120 | 4
110 | 4 | 31 | 6 | 14 | 6 | 2 | 4 | 34 | 22 | 100 | 4 |  |  |  |  |  |  | Uniques Values from Row 3:14 Column A,C,E,G,I,K (ONLY IF VALUE HAVE POINTS = 4 )--> | 100 | 90 | 120 | 93 | 110 | 105 | 101 | 99 | 116 | 92 | 115 | 112 | 34 | 33 | 26 | 16 | 12 | 8 | 5 | 2 | 1
105 | 4 | 18 | 5 | 25 | 6 | 92 | 4 | 93 | 4 | 116 | 4 |  |  |  |  |  |  | SUM Points  (Row 3:14 Column B,D,F,H,J,L) , to corresponded Uniques Values -------------> | 24 | 24 | 20 | 20 | 16 | 16 | 16 | 16 | 12 | 12 | 8 | 8 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
115 | 4 | 26 | 5 | 90 | 4 | 93 | 4 | 99 | 4 | 90 | 4
120 | 4 | 14 | 5 | 116 | 4 | 90 | 4 | 100 | 4 | 101 | 4
90 | 4 | 110 | 4 | 120 | 4 | 101 | 4 | 120 | 4 | 93 | 4
101 | 4 | 101 | 4 | 100 | 4 | 120 | 4 | 116 | 4 | 92 | 4
93 | 4 | 112 | 4 | 99 | 4 | 115 | 4 | 90 | 4 | 33 | 4
92 | 4 | 100 | 4 | 93 | 4 | 105 | 4 | 2 | 4 | 16 | 4
99 | 4 | 90 | 4 | 12 | 4 | 110 | 4 | 36 | 3 | 34 | 4
2 | 3 | 105 | 4 | 110 | 4 | 100 | 4 | 24 | 3 | 8 | 4
29 | 3 | 5 | 4 | 105 | 4 | 1 | 4 | 17 | 3 | 26 | 4
30 | 3 | 9 | 4 | 33 | 4 | 6 | 3 | 8 | 3 | 9 | 4
6 | 3 | 29 | 4 | 24 | 4 | 35 | 3 | 9 | 3 | 27 | 4
4 | 2 | 27 | 3 | 9 | 3 | 30 | 3 | 3 | 3 | 11 | 4
20 | 2 | 7 | 3 | 22 | 3 | 31 | 3 | 23 | 3 | 29 | 4
23 | 2 | 30 | 3 | 15 | 3 | 18 | 3 | 12 | 3 | 18 | 1
7 | 2 | 34 | 3 | 35 | 3 | 23 | 3 | 20 | 2 | 36 | 1
18 | 2 | 22 | 3 | 23 | 3 | 15 | 3 | 30 | 2 | 7 | 0
17 | 2 | 15 | 3 | 3 | 3 | 9 | 2 | 35 | 2 | 25 | 0
10 | 1 | 36 | 2 | 29 | 3 | 33 | 2 | 29 | 2 | 17 | 0
33 | 1 | 13 | 2 | 6 | 3 | 32 | 2 | 7 | 2 | 35 | 0
21 | 1 | 12 | 2 | 36 | 3 | 7 | 2 | 33 | 2 | 3 | 0
8 | 1 | 4 | 2 | 11 | 2 | 34 | 2 | 27 | 2 | 21 | 0
16 | 1 | 17 | 2 | 21 | 2 | 36 | 2 | 6 | 2 | 5 | 0
35 | 1 | 6 | 2 | 8 | 2 | 3 | 2 | 4 | 2 | 23 | 0
31 | 1 | 28 | 2 | 32 | 2 | 10 | 2 | 1 | 1 | 1 | 0
13 | 1 | 35 | 2 | 19 | 2 | 21 | 2 | 14 | 1 | 19 | 0
36 | 1 | 8 | 2 | 16 | 2 | 13 | 1 | 25 | 1 | 2 | 0
9 | 1 | 24 | 2 | 18 | 2 | 27 | 1 | 5 | 1 | 20 | 0
12 | 1 | 2 | 1 | 17 | 1 | 24 | 1 | 2 | 1 | 14 | 0
15 | 0 | 20 | 1 | 30 | 1 | 5 | 1 | 32 | 0 | 32 | 0
34 | 0 | 33 | 1 | 31 | 1 | 14 | 1 | 26 | 0 | 6 | 0
22 | 0 | 25 | 1 | 4 | 1 | 12 | 1 | 28 | 0 | 24 | 0
3 | 0 | 19 | 0 | 34 | 1 | 8 | 0 | 19 | 0 | 4 | 0
24 | 0 | 32 | 0 | 13 | 0 | 2 | 0 | 11 | 0 | 22 | 0
Spreadsheet: benjamin_rogers__1043__TerminalValuation
Sheet: DCF-PV 3 years

DCF Analysis
Consolidated UFCF - $4/kW-month (million $)
 |  |  |  | CONTRACT PERIOD
 |  |  |  | 2001 | 2002 | 2003
 |  |  | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2002-07-01 00:00:00 | 2003-07-01 00:00:00
EBITDA less Power Contract |  |  |  | 123.6240336759508 | 123.040164143352 | 122.5288210162394
 | % Annual Growth
Depreciation |  |  |  | 44.22506419986609 | 44.22506419986609 | 44.22506419986609
EBIT
Taxes on EBIT |  |  | 0.3871730172229804
Unlevered Net Income
Plus:  Depreciation
Plus:  Deferred Income Taxes |  |  |  | 20.3161325977545 | 20.55676770384788 | 21.01615991237545
Plus:  WC Adjustments (Property Taxes) |  |  |  | 0.1795618985999997 | 0.3466470000000004 | 0.1900860000000002
Unlevered Free Cash Flow |  |  | 0
 | % Annual Growth
Valuation Matrix (million $ except Per kW Value)
 |  |  |  |  | Terminal Value in Year 3 ($/kW)
 |  | DISCOUNT RATE |  |  | 350 |  | 360 |  | 370 |  | 380 |  | 390 |  | 400
 |  | 0.095 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of 2001-2003 UFCF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of 2001-2003 UFCF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of 2001-2003 UFCF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of 2001-2003 UFCF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enterprise Value
Spreadsheet: 24b9efbb-379d-4a54-9cf2-ef806696952c
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Facilities | 1 | Improve means of communication with clientele. | 1.1 | Establish a means for client event setup requests. | 1 | None | -- Pick One --
Facilities | 1 | Improve means of communication with clientele. | 1.2 | Establish an ongoing means for customer feedback. | 2 | None | -- Pick One --
Facilities | 1 | Provide continuity and consistency for the Facilities Department. | 2.1 | Document established Facilities Operating Procedures. | 3 | None | -- Pick One --
Facilities | 1 | Provide continuity and consistency for the Facilities Department. | 2.2 | Identify and plan solutions for possible problems over transition period anticipated in July 2010 when current Facilities Supervisor retires. | 4 | None | -- Pick One --
Facilities | 1 | Provide continuity and consistency for the Facilities Department. | 2.3 | Explore options for addressing anticipated staffing and equipment needs. | 5 | None | -- Pick One --
Spreadsheet: 81680327-e513-4f96-bc31-3326b9fc2797
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
URCU | Test | URCU | Uric Acid, [NAME] | [NAME], U | Uricase | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 10 g of boric acid as preservative at start of collection. 3. Mix well before taking 5-mL aliquot. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	No Refrigerated	Yes Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	Yes Toluene	Yes 6N HNO3	No Boric Acid	Preferred Thymol	Yes | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Diet-dependent: <750 mg/specimen The reference value is for a 24-hour collection. Specimens collected for other than a 24-hour time period are reported in unit of mg/dL for which reference values are not established. | Monday through Sunday; Continuously | Same day/1 day | Same day/1 day | 1 | 84560 |  |  |  |  | Rochester
URCU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
URCU | Order Question | TM29 | Collection Duration |  | Plain Text
URCU | Order Question | VL27 | [NAME] |  | Plain Text
URCU | Result | UACID | [NAME], U | [NAME], U | Numeric |  |  |  |  | mg/spec |  |  |  |  |  |  |  |  |  | 3087-4 | Urate:MRat:24H:[NAME]:Qn:
URCU | Result | TM29 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
URCU | Result | VL27 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
URCU | Result | UACN1 | Uric Acid Concentration | Uric Acid Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 21587-1 | Urate:MCnc:24H:[NAME]:Qn:
Spreadsheet: 818677d1676994877-formula-for-only-adding-cells-when-both-cells-contain-data-excel-example-tms
Sheet: Sheet1

 |  | Lot 1 | Lot 2 | Lot 3
 |  | 299.99 | 0 | 0
 |  | Lot 1 | Lot 2 | Lot 3
 |  | 0 | 299.99 | 0
 |  | Lot 1 | Lot 2 | Lot 3
 |  | 299 | 299.99
Spreadsheet: 271781d1382043303-index-match-with-date-range-criteria-formula-test-10-16
Sheet: P List

 |  |  | ID1 | ID2 |  |  | Name | SI | Exec | Mgr | Status | iStatus | Budget | IN | iDate | R | AR |  | Short Name
 |  |  | 12345 | 18000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  |  | 16888 | 16888 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 |  |  | 16565 | 16565 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MS
Spreadsheet: 45c0555c-f3fa-4957-b47b-249a0a2260b3
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Communication
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 843484d1695299369-excel-formula-for-a-simple-spreadsheet-sample-ibf
Sheet: Sheet1

PENDING SCHEDULING | DRUG | NEW- NEEDS TO BE WORKED | DRUG | IN PROCESS | DRUG | DATE | PENDING SCHEDULING | NEW- NEEDS TO BE WORKED | IN PROCESS
[NAME] | rituxan | [NAME] | truxima | [NAME] | orencia | 2023-09-18 00:00:00 | 2 | 4 | 5
[NAME] | remicade | [NAME] | rituxan | [NAME] | actemra | 2023-09-25 00:00:00
 |  | [NAME] | ZA | [NAME] | ZA | 2023-10-02 00:00:00
 |  | susan | humira | [NAME] | Remicade
 |  |  |  | [NAME] | avsola