tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848772d1699404496-workforce-planning-formula-workforce-planning-template
Sheet: Gantt

Week Days/Month
Department/Segment | 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
Corporate
ID
OH
Finance
ID
OH
Fleet
ID
OH
HR
ID
OH
Operations
ID
OH
Safety
ID
OH
Sales
ID
OH
Spreadsheet: 79603e6c-4f7f-4e35-b189-95818041d605
Sheet: Sheet2

 |  | University Means | National Means | CACREP Means | Non-CACREP Means | Minimum Criteria
2002-04-13 00:00:00 | 83.33% Passed | 111 | 108.8 | 117.42 | 114.85 | 102
2002-10-19 00:00:00 | 79.16% Passed | 112.88 | 108.53 | 115.33 | 108.19 | 97
2003-04-12 00:00:00 | 75% Passed | 115.5 | 111.7 | 123.07 | 120.54 | 103
2003-10-18 00:00:00 | 100% Passed | 124.5 | 108.5 | 113.82 | 110.82 | 98
2004-04-24 00:00:00 | 91.66% Passed | 117.33 | 105.44 | 117.62 | 115.01 | 100
2004-10-23 00:00:00 | 100% Passed | 110.27 | 102.91 | 110.18 | 107.34 | 93
2005-04-16 00:00:00 | 75% Passed | 113.63 | 105.04 | 115.5 | 113.67 | 99
2005-10-22 00:00:00 | 81% Passed | 111.69 | 105.29 | 114.15 | 108.77 | 95
2006-04-22 00:00:00 | 91% Passed | 111.91 | 101.31 | 115.11 | 114.51 | 98
2006-10-21 00:00:00 | 89% Passed | 114.68 | 99.12 | 110.89 | 108.22 | 92
2007-04-21 00:00:00 | 63.64% Passed | 111.18 | 105.18 | 120.53 | 115.63 | 102
2007-10-20 00:00:00 | 100% Passed | 115.86 | 97.51 | 109.69 | 106.3 | 90
2008-04-12 00:00:00 | 84.61% Passed | 109.54 | 100.11 | 114.44 | 113.56 | 97
2008-10-18 00:00:00 | 88.89% Passed | 116.11 | 99.24 | 111.55 | 105 | 91
2009-04-18 00:00:00 | 90% Passed | 115.1 | 92.82 | 112.62 | 109.32 | 94
2009-10-17 00:00:00 | 60% Passed | 100.9 | 99.62 | 110.01 | 106.25 | 91
2010-04-17 00:00:00 | 75% Passed | 160 | 97.6 | 111.77 | 110.57 | 95
2010-10-16 00:00:00 | 90% Passed | 110 | 96.7 | 108.28 | 105.41 | 89
2011-04-16 00:00:00 | 77% Passed | 112.85 | 99.53 | 116.44 | 114.94 | 100
2011-10-15 00:00:00 | 87% Passed | 104.13 | 95.72 | 108.45 | 106.41 | 89
2012-10-13 00:00:00 | 90% Passed | 107.1 | 98.91 | 110.44 | 107.25 | 92
Spreadsheet: 789152d1658930962-split-dollar-amount-into-different-amounts-based-on-percentage-copy-of-invoice-approval-splits-bg-sfy-2022
Sheet: Repairs & Maintenance

 |  |  |  | USPIRITUS INVOICE APPROVAL FORM
 |  | Person  Requesting |  |  |  | Date
 |  | Supervisor Approval
 | General [NAME]
 | GL | Fund | Department | Event | Location | Grant | Restriction | Amount
 | 8262 | 01 | 546 | N000 | 31 | 99 | 1
 | 8262 | 01 | 481 | N000 | 31 | 35 | 1
 | 8262 | 01 | 482 | N000 | 31 | 35 | 1
 | 8262 | 01 | 483 | N000 | 31 | 35 | 1
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  |  |  |  |  |  | TOTAL | 275
 | NOTES:
Spreadsheet: 708514d1607889407-work-delay-we-have-given-a-task-and-want-to-count-how-much-is-work-delay-or-work-on-time-test-work-delay
Sheet: Sheet1

S.No. | Date | Day | Office Timing | Work Given to | Work Name | Work Deadline | Work Finish Time |  | Delay / Comp
 |  |  |  |  |  |  | Work Done | Date and Time (MM:DD:YY)
1 | 2020-12-03 00:00:00 | Thursday | 9:00 am to 6:00 pm | Rohit | Work 1 | 2020-12-04 16:00:00 | Rohit Work 1 Done | 2020-12-07 17:00:00 |  | Work Late by 19 Hour
2 | 2020-12-04 00:00:00 | Friday | 9:00 am to 6:00 pm | [NAME] | work 2 | 2020-12-07 11:00:00 | [NAME] Work 2 Done | 2020-12-07 10:30:00 |  | Work done before time
3 | 2020-12-05 00:00:00 | Saturday | 9:00 am to 6:00 pm | Rohit | Work 3 | 2020-12-05 14:00:00 | Rohit Work 3 Done | 2020-12-05 17:00:00 |  | Work Late by 3 Hour
4 | 2020-12-06 00:00:00 | Sunday | 9:00 am to 6:00 pm | Off
5 | 2020-12-07 00:00:00 | Monday | 9:00 am to 6:00 pm | [NAME] | Work4 | 2020-12-09 17:00:00 | [NAME] Work4 Done | 2020-12-10 17:00:00 |  | Work Late by 8 Hour
6 | 2020-12-08 00:00:00 | Tuesday | 9:00 am to 6:00 pm | Holiday
7 | 2020-12-09 00:00:00 | Wednesday | 9:00 am to 6:00 pm
7 | 2020-12-10 00:00:00 | Thursday | 9:00 am to 6:00 pm
 |  |  | 9:00 am to 6:00 pm | Working Hour is 9 Hour
 |  |  |  | Work 1 Deadline is, Date 04 and time 04:00 pm
 |  |  |  | Late on 04 Dec | 2 Hour
 |  |  |  | Late on 05 Dec | 9 Hour
 |  |  |  | Late on 07 Dec | 8 Hour
 |  |  |  | Total | 19 Hour | but it is showing 22 Hour
Spreadsheet: a6edfc66-21b0-4fdd-95fb-f902c8cdfc5f
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
FFTOX | Test | FFTOX | [NAME], [NAME] (Serum) | [NAME], Serum, ELISA | Enzyme Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL serum refrigerated. | 0.10 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | REFERENCE RANGE:  Negative  Results of this assay must be interpreted with caution, as broad variations in antibody response occur, and levels may remain elevated for years after infection. Further, as with many parasitic serology assays, antibodies induced by other parasitic infections may crossreact in this assay. Although a negative result usually rules out infection with Toxocara spp., parallel testing of serial samples may prove useful in following patients with suspected Toxocara infection.    Test Performed by: Focus Diagnostics, Inc.                              5785 Corporate Avenue 	                 Cypress, CA 90630-4750 | Tuesday, Friday | 1 - 5 days | 2 - 7 days | 1 | 86682 |  |  |  |  | Focus Diagnositics, Inc.
FFTOX | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FFTOX | Result | [NAME] | [NAME], Serum, ELISA | [NAME], Serum, ELISA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5386-8
Spreadsheet: 877690d1724504847-pay-calculation-form-junior-to-senior-scale-krixxx-salaries-2007-jt
Sheet: Sheet1

 |  |  |  |  | Salary Month | Pay Scale after Promotion |  | Junior Programmer  Pay Scale | Senior [NAME]
Pay Scale on Date | 2024-08-08 00:00:00 | Pay Scale of Junior Programmer | 35830 |  |  |  |  | 29100 | 35700 |  | Remarks
 |  |  |  |  |  |  |  |  |  |  | Column F from Cell F2 onwards contains formula to return the months
Regular Increment Date/Month | 2025-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | Column I contains formula from Cell I3 onwards to calculate pay scale
 |  |  |  |  |  |  |  |  |  |  | Column J contains formula from Cell J3 onwards to calculate pay scale
In excel column I there is pay scale range starting from cell I2 to I33 which is 29100 in cell I2 and it increase by 3 percentage and rounded to ceiling 10, in I33 the pay scale is 73020 of Junior Programmer,  In column J there is pay scale range starting from J2 to J33 which is 35700 in cell J2 and increase by 3 percentage and rounded to ceiling 10, in J33 the pay scale is 89510 of Senior Programmer. In cell B2 there is present pay scale date which is in this example is 08-aug-2024 and the regular increment date is in cell B4 which is 01-apr-2025 in this case. The present pay scale of Junior Programmer is in cell [NAME] which is 35830 in this example and the pay scale fixation of promoted employee will be done as shown in column G starting from cell G2 onwards and Salary Months will be as per column F. The logic of pay fixation of promoted employee will be as below. In our example, The present pay scale of promoted employee is 35830, then he will get the increment in Junior Programmer cadre as per column I, which is 36910, and his regular increment month/date it 01-apr-2025, in column G the result will be from cell G2 to G9 will be 36910.  When the regular increment month Apr-25 will come in column F Cell (in this case Cell F10) the employee will received next increment in the Junior Programmer cadre which will be in this case is 38020 as per column I and will be fitted in the next higher scale of Senior Programmer  cadre as per column J which is 39030. So this employee will receive 39030 from Apr-25 onwards for next 12 months till mar-26 and then in apr-26 he will received next increment as per column J which will be 40210 in this case and that scale will be last for 12 months and so on. So basically by entering Data in Cell B2, B4 and D2 I expect the result as per Column G from cell G2 onwards. P.S. Colour coding and formatting is for better understanding only.
Spreadsheet: phillip_m_love__30670__200001_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 265657 |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  | 0 |  | 0 |  | 170000 |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -144747 |  |  |  |  |  |  |  |  |  | 3924785
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  | -730000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -60039 | -315734
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg) |  |  |  |  | 730000 | 1854200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60039
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -146152 |  | 146152
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  | 97061 |  |  |  |  |  |  |  | 0 |  | 362654 |  |  |  |  |  | 93300 |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  |  |  | -170000
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  | 91764 |  | -91764 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME] |  |  |  |  |  | 25279 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 820000
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  |  |  | -362654
 |  | TOTAL
Spreadsheet: 722085d1615034204-calculate-difference-between-pairs-of-times-excelcase
Sheet: All_Tagihan

Code | Time1 | Time2 | Time3 | [NAME] | V
J | 07:30:00 | 07:53:00 | 08:30:00 | 09:00:00 | OK
J | 08:20:00 | 09:00:00 | 17:40:00 | 18:20:00 | #N/A
 | 08:20:00 | 09:00:00 | 16:00:00 | 16:40:00 | OK
J | 08:20:00 | 09:00:00 | 17:40:00 | 18:20:00 | #N/A
J | 07:00:00 | 07:40:00 | 16:00:00 | 16:40:00 | OK
J | 07:00:00 | 07:40:00 | 16:00:00 | 22:00:00 | CHECK
K | 07:00:00 | 08:00:00 | 16:00:00 | 17:00:00 | OK
L | 07:00:00 | 08:00:00 | 16:00:00 | 17:00:00 | OK
Spreadsheet: 845037d1696597720-conditional-formatting-entire-row-based-on-one-column-fayec-test-1-aligw
Sheet: ASPEN 091023

SHIP NAME: ASPEN |  | Flag - CY |  |  | Ref:- | 492-1023 |  |  |  | Deferred Account | DDP
ETA:   09/10/2023 |  | IMO  9195389 |  | SEKHN |  |  | UVI: |  |  | Other agent | Totals
B/L | CUSTOMER | SHIPPER | PACKS | KGS | MARKS | Value | M3 | Terms | Agent | Sales Inv No | UCN
2 | Sofidel | Rottneros | 331 | 406134 | CS075 |  |  |  | IIF
3 | Compass - C | [NAME] | 14 | 32006 | 150-3 | 15669.51 | 66.679 | CIF | DDP
4 | Severn Valley | [NAME] | 13 | 38152 | ST10935 | 15341 | 72.138 | CIF | HBH
 |  |  |  |  |  |  |  |  | ABC
32
33
Spreadsheet: 718411d1613136056-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Classes

Day | Monday | Monday | Monday | Monday | Tuesday | Tuesday | Tuesday | Tuesday | Wednesday | Wednesday | Wednesday | Wednesday | Wednesday | Thursday | Thursday | Thursday | Thursday | Friday | Friday
System | System 1 | System A | System 2 | System 3 | System 4 | System B | System 5 | System 6 | System 7 | System 8 | System C | System D | System 9 | System E | System F | System 10 | System G | System H | System 11
 | Monday | Tuesday | Wednesday | Thursday | Friday
Spreadsheet: 218996d1362634861-populate-start-end-week-data-and-autorank-sample-ans2
Sheet: Sheet1

 |  |  |  | Week 1
Month: | March2013 |  |  |  |  |  |  |  | Average Score | Rank | Your Formula here
 |  |  |  | 3/1/2013 - 3/8/13 |  |  |  |  | 0.002592592592592593 | 1
 |  |  |  |  |  |  |  |  | 0.37 | 2
 |  |  |  | Week 2 |  |  |  |  | 0.035 | 3
Month: | March2013 |  |  |  |  |  |  |  | 0.18 | 4
 |  |  |  |  |  |  |  |  | 0.64 | 5
 |  |  |  |  |  |  |  |  | 0.88 | 6
 |  |  |  |  |  |  |  |  | 1 | 7
 |  |  |  |  |  |  |  |  | 0.09 | 8
 |  |  |  |  |  |  |  |  | 0.0008 | 9
 |  |  |  |  |  |  |  |  | 0.007 | 10
 |  |  |  |  |  |  |  |  | 0.0243 | 11
 |  |  |  |  |  |  |  |  | 0.365 | 12
 |  |  |  |  |  |  |  |  | 0.78 | 13
 |  |  |  |  |  |  |  |  | 0.96 | 14
 |  |  |  |  |  |  |  |  | 0.54 | 15
Spreadsheet: 684794d1593537859-filtering-table-with-cells-table-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | ASSET
 |  |  |  |  |  |  |  |  |  | AH-008
 |  |  |  |  |  |  |  |  |  | AH-016
 |  |  |  |  |  |  |  |  |  | AH-023
 |  |  |  |  |  |  |  |  |  | AH-030
 |  |  |  |  |  |  |  |  |  | AH-003
 |  |  |  |  |  |  |  |  |  | AH-011
Asset | Description | Net Book Value | Purchase cost | Present previous | Previous Status | Date Purchased | Updated Value ?
AH-001 | Wallcovering | 1286.88 | 2859.88 | 1 | No | 2016-01-11 00:00:00
AH-002 | Safe Cabinet | 2240.32 | 4978 | 1 | Y | 2016-01-12 00:00:00
AH-003 | [NAME] cabinet | 2999.92 | 6666 | 1 | No | 2016-01-13 00:00:00
AH-004 | Furniture | 2475 | 5500 | 1 | Y | 2016-01-14 00:00:00
AH-005 | Chairs | 1575 | 3500 | 1 | No | 2016-01-15 00:00:00
AH-006 | Accessories | 507.5 | 1127.46 | 1 | No | 2016-01-16 00:00:00
AH-007 | ELV | 1467 | 3260 | 1 | No | 2016-01-17 00:00:00
AH-008 | Artwork | 143.94 | 319.5 | 1 | Y | 2016-01-18 00:00:00
AH-009 | Artwork | 81.46 | 180.9 | 1 | Y | 2016-01-19 00:00:00
AH-010 | Drapery | 2273.99 | 5053.47 | 1 | Y | 2016-01-20 00:00:00
AH-011 | Furniture | 38445.64 | 85435 | 1 | Y | 2016-01-21 00:00:00
AH-012 | Beds | 5823 | 12940 | 1 | Y | 2016-01-22 00:00:00
AH-013 | Wallcovering | 1286.88 | 2859.88 | 1 | Y | 2016-01-23 00:00:00
AH-014 | Safe Cabinet | 2240.32 | 4978 | 1 | No | 2016-01-24 00:00:00
AH-015 | [NAME] cabinet | 2999.92 | 6666 | 1 | No | 2016-01-25 00:00:00
AH-016 | Furniture | 2475 | 5500 | 1 | No | 2016-01-26 00:00:00
AH-017 | Chairs | 1575 | 3500 | 1 | Y | 2016-01-27 00:00:00
AH-018 | Accessories | 507.5 | 1127.46 | 1 | Y | 2016-01-28 00:00:00
AH-019 | ELV | 1467 | 3260 | 1 | Y | 2016-01-29 00:00:00
AH-020 | Artwork | 143.94 | 319.5 | 1 | Y | 2016-01-30 00:00:00
AH-021 | Artwork | 81.46 | 180.9 | 1 | Y | 2016-01-31 00:00:00
AH-022 | Drapery | 2273.99 | 5053.47 | 1 | No | 2016-02-01 00:00:00
AH-023 | Furniture | 38445.64 | 85435 | 1 | No | 2016-02-02 00:00:00
AH-024 | Beds | 5823 | 12940 | 1 | No | 2016-02-03 00:00:00
AH-025 | Wallcovering | 1286.88 | 2859.88 | 1 | No | 2016-02-04 00:00:00
AH-026 | Safe Cabinet | 2240.32 | 4978 | 1 | No | 2016-02-05 00:00:00
AH-027 | [NAME] cabinet | 2999.92 | 6666 | 1 | No | 2016-02-06 00:00:00
AH-028 | Furniture | 2475 | 5500 | 1 | No | 2016-02-07 00:00:00
AH-029 | Chairs | 1575 | 3500 | 1 | No | 2016-02-08 00:00:00
AH-030 | Accessories | 507.5 | 1127.46 | 1 | Y | 2016-02-09 00:00:00
AH-031 | ELV | 1467 | 3260 | 1 | Y | 2016-02-10 00:00:00
AH-032 | Artwork | 143.94 | 319.5 | 1 | Y | 2016-02-11 00:00:00
AH-033 | Artwork | 81.46 | 180.9 | 1 | Y | 2016-02-12 00:00:00
AH-034 | Drapery | 2273.99 | 5053.47 | 1 | Y | 2016-02-13 00:00:00
AH-035 | Furniture | 38445.64 | 85435 | 1 | Y | 2016-02-14 00:00:00
AH-036 | Beds | 5823 | 12940 | 1 | Y | 2016-02-15 00:00:00
Spreadsheet: 681288d1591452154-help-with-automatically-populating-cells-kindergarden
Sheet: Daily

 | Under 2
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | 2 Year Old
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | 3 Years +
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
Spreadsheet: 812266d1673032826-need-to-do-a-calculation-based-on-a-last-name-based-on-the-result-of-the-first-name-sample
Sheet: Sheet1

[NAME] | [NAME] |  | 10
[NAME] | Smith
[NAME] | [NAME]
[NAME] | Clare
[NAME] | Doe
[NAME] | clare
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: 64257d1265132910-search-tabs-and-return-results-kc-environmental-aspects-and-impacts-worksheet-questions
Sheet: Process - Activity 1

Operating Condition | Process Evaluated |  | Date |  |  |  |  | Team
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer  Reclaim | Resource Preservation | 0 | -1 | 0 | 0 |  | Yes | Yes
 | Polymer Consumption | Depletion of Natural Resources | 3 | 1 | 0 | 0 |  | No
 | Web Treating - Chemicals | Degradation of Air Quality | 2 | 1 | 0 | 0 |  | Yes | Yes
 | Screen Cleaning | Water Quality Impact | 2 | 1 | 0 | 0 |  | No
 | Maintenance |  | 2 | 2 | 0 | 0 |  | No
 | Oil Change | Contamination of Air/Soil/Water | 2 | 2 | 0 | 0
Abnormal | Glycol System - Spill | Contamination of Air/Soil/Water | 3 | 2 | 0 | 0
 | Energy Use (Electric) | Degradation of Air Quality | 3 | 4 | 0 | 0
 | Natural Gas Usage | Depletion of Natural Resources | 3 | 4 | 0 | 0
 | Waste Disposal | Contamination of Air/Soil/Water | 3 | 4 | 0 | 0
 | VOC Emmissions | Degradation of Air Quality | 3 | 4 | 0 | 0
 | HAP Emmissions | Degradation of Air Quality | 3 | 4 | 0 | 0
 | Spills | Water Quality Impact | 2 | 4 | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
Spreadsheet: 440230d1452703184-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2015
Sheet: January 

Employee Absence Schedule
January | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Hours | Start Date
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-10-23 00:00:00
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-11-11 00:00:00
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-08-11 00:00:00
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-10-27 00:00:00
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-30 00:00:00
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-21 00:00:00
G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-05-29 00:00:00
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-20 00:00:00
I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-15 00:00:00
J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-31 00:00:00
K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 2014-01-27 00:00:00
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-09 00:00:00
M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-10-29 00:00:00
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-20 00:00:00
 | [NAME] |  |  |  |  | 8 | 8 Hours |  |  | 6 | 6 Hours |  |  | 4 | 4 Hours |  |  | 2 | 2 Hours |  |  | H | Holiday
Spreadsheet: 825679d1681466798-sumif-using-different-criteria-is-column-is-empty-book1
Sheet: Sheet1

Type | Cost per day | Inbound Date | Est Outbound Date | Actual Outbound Date
Door | 1 | 2021-01-01 00:00:00 |  | 2021-01-15 00:00:00 |  |  |  | 2021-01-31 00:00:00
Furniture | 2 | 2021-02-03 00:00:00 |  |  |  |  | Door |  | 458 | 527 | 358 | 186 | 300 | 310 | 150
Furniture | 3 | 2021-02-15 00:00:00 |  |  |  |  | Furniture | 564 | 1648 | 1640 | 1138 | 492 | 78 | 0 | 0
Furniture | 4 | 2021-01-11 00:00:00 |  | 2021-01-15 00:00:00 |  |  | Carpet | 0 | 0 | 140 | 105 | 0 | 0 | 0 | 0
Furniture | 5 | 2021-02-01 00:00:00 |  |  |  |  | TV | 0 | 0 | 0 | 0 | 713 | 580 | 360 | 0
Furniture | 6 | 2021-03-15 00:00:00
Carpet | 7 | 2021-03-12 00:00:00 |  | 2021-04-15 00:00:00
Door | 8 | 2021-01-11 00:00:00 |  |  |  |  |  | * How do I create a formula that will take (D-C+1)*B if E is blank
Door | 9 | 2021-02-03 00:00:00 |  |  |  |  |  | * and if E is NOT blank, take (E-C+1)*B
Door | 10 | 2021-05-17 00:00:00 |  |  |  |  |  | * The result of to be shown respective in their month column (I:P) base on D (if E is blank) and E (if E is not blank)
TV | 11 | 2021-05-01 00:00:00 |  | 2021-06-20 00:00:00 |  |  |  | * best is no helper column
TV | 12 | 2021-05-01 00:00:00
Furniture | 13 | 2021-01-16 00:00:00
Furniture | 14 | 2021-02-01 00:00:00 |  | 2021-03-12 00:00:00
Furniture | 15 | 2021-02-15 00:00:00
Furniture | 16 | 2021-01-11 00:00:00 |  | 2021-03-12 00:00:00
Spreadsheet: 60533d1261059840-excel-2007-rounding-up-minutes-to-nearest-hour-work-rosters
Sheet: Test Formulas

 | Time On | Time Off | [NAME]
 | 06:00:00 | 14:00:00
 | 02:00:00 | 12:00:00
 | 00:01:00 | 08:00:00 |  | <-- Would like to round to nearest hour(i.e. 08:00)
 | 12:00:00 | 20:00:00
 | 00:01:00 | 09:00:00 |  | <-- Would like to round to nearest hour(i.e. 09:00)
 | Week 1 |  |  | <-- If D5 & D7 rounded up would this total be automatically rounded up?
 | Time On | Time Off | [NAME]
 | 02:00:00 | 10:00:00
 | 06:00:00 | 15:00:00
 | 00:01:00 | 09:00:00 |  | <-- Would like to round to nearest hour(i.e. 09:00)
 | 13:30:00 | 01:30:00
 | 18:00:00 | 02:00:00
 | Week 2
 |  | Total
 |  |  |  | <-- and likewise would this total be rounded up?