tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 740981d1626752479-auto-calculate-end-date-auto-calculate-end-date-amended-200721-
Sheet: josephteh (amended)

Job | Allocated Hours | Start Date | End Date |  | Working Hours |  |  | Holidays |  |  | Workings |  |  | Date | Day | Working hours | Cumulative | Start/End Date | Start/End Time
Job A | 40 | 2021-07-19 10:35:00 |  |  | Start Hour | 08:00:00 |  |  |  | M3 | Allocated hours |  |  | 2021-07-19 00:00:00
Job B | 40 | 2021-07-19 12:00:00 |  |  | End Hour | 15:00:00 |  |  |  | M4 | Start date |  |  | 2021-07-20 00:00:00
Job C | 50 | 2021-07-19 09:00:00 |  |  | Working Hours |  |  |  |  | M5 | Computed end date |  |  | 2021-07-21 00:00:00
 |  |  |  |  |  |  |  |  |  | M6 | First day working hours |  |  | 2021-07-22 00:00:00
 |  |  |  |  |  |  |  |  |  | M7 | Last day working hours |  |  | 2021-07-23 00:00:00
 |  |  |  |  |  |  |  |  |  | M8 | Complete work days |  |  | 2021-07-24 00:00:00
 |  |  |  |  |  |  |  |  |  | M9 | Remaining hours |  |  | 2021-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  | M10 | Computed end date |  |  | 2021-07-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  | (combined formulas) |  |  | 2021-07-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
https://www.excelforum.com/excel-formulas-and-functions/1354786-auto-calculate-end-date.html |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-15 00:00:00
Spreadsheet: 453701d1459419944-matching-a-negative-value-with-a-positive-value-using-conditional-formatting-test23-1-
Sheet: Folha2

Values | Search | New formula
200
-150
-200
150
30
-25
-29
-30
-30
25
-7064
240
7064
115
-115
-240
115
Spreadsheet: 587922d1535385971-trying-to-condense-daily-shipping-to-semi-weekly-based-on-a-variety-of-shared-locations-shipping-example
Sheet: Desired Outcome

New Ship Date | New Ship Charges | Shipment Date | Tracking ID | Net Charge Amount | Recipient Name | Recipient Company | Recipient Address Line 1
 |  | 2018-04-02 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 11415 Main St
 |  | 2018-04-02 00:00:00 | [PHONE] | 17.86 | Kieron Parra | Communications Centers | 11415 Main St
Monday, April 2, 2018 |  |  | Total:
 |  | 2018-04-03 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 11415 Main St
 |  | 2018-04-05 00:00:00 | [PHONE] | 17.86 | [NAME] | Communications Centers | 11415 Main St
Thursday, April 5, 2018 |  |  | Total:
 |  | 2018-04-09 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Communications Centers | 11415 Main St
Monday, April 9, 2018 |  |  | Total:
 |  | 2018-04-10 00:00:00 | [PHONE] | 17.19 | Aoife [NAME] | Communications Centers | 11415 Main St
 |  | 2018-04-10 00:00:00 | [PHONE] | 17.9 | [NAME] | Communications Centers | 11415 Main St
 |  | 2018-04-10 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Communications Centers | 11415 Main St
 |  | 2018-04-11 00:00:00 | [PHONE] | 17.9 | Kieron Parra | Communications Centers | 11415 Main St
Thursday, April 12, 2018 |  |  | Total:
 |  | 2018-04-03 00:00:00 | [PHONE] | 19.13 | [NAME] | Communications Centers | 134 Simpson Rd
 |  | 2018-04-04 00:00:00 | [PHONE] | 19.13 | [NAME] | Communications Centers | 134 Simpson Rd
 |  | 2018-04-05 00:00:00 | [PHONE] | 19.13 | [NAME] | Communications Centers | 134 Simpson Rd
Thursday, April 5, 2018 |  |  | Total:
 |  | 2018-04-12 00:00:00 | [PHONE] | 19.18 | [NAME] | Communications Centers | 134 Simpson Rd
Thursday, April 12, 2018 |  |  | Total:
Costs based on New Schedule: |  |  | Total:
Spreadsheet: 684427d1593359353-indirect-function-looking-for-worksheet-named-after-current-year-sample
Sheet: 2019

2019
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | sheet2
 |  | 1
Spreadsheet: 536119d1504254863-help-with-tricky-if-formula-book1
Sheet: Sheet1

Business | EmployeeTrained | BusinessTrained?
Construction | Yes
Construction | No
Hairdresser | Yes
Government | No
Warehouse | Yes
Warehouse | Yes
Spreadsheet: 781391d1653301730-linest-for-mean-absolute-deviation-excelq1
Sheet: Sheet1

y | x | linest |  | 21.59236424219123
21 | 85
-87 | 36
45 | 66
1 | -86
-14 | -88
71 | 88
-30 | 16
33 | 63
91 | -53
87 | -32
Spreadsheet: 09a15107-bf03-47f2-a9c3-0dbc26c8cf7c
Sheet: High Cost Student Services

Student Information |  |  |  | High Cost Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Cost Equipment or Materials |  |  |  | Other Expenditures |  |  | Subtotal | Ineligible Amounts |  |  | Eligible Expenses
Student SSID | Grade 2013-14 | Instructional Setting | [NAME] | Speech Language Pathologist | [NAME] | Paraprofessional  (in addition to LEA ratios) | Behavior Specialist | Psychology or Mental Health | Hearing Specialist | Vision Specialist | Sign Language Interpreting | [NAME] | Other Language Interpreter or Translator | Transportation Para | Transition Services | Adaptive PE | Occupational Therapy | OT Para | Physical Therapy | PT Para | Nurse | Sensory Equipment | [NAME] | Other Specialized Instructional Materials | Assistive, Adaptive, or Augmentative Technology | Private School Tuition  (only if required for FAPE) | Specialized Transportation | Other (include comment) | Extraordinary Costs | Medicaid | Private Insurance | Threshold Expenses ($14,762 PreK or $19,683 K-12) | Extraordinary Costs Minus Ineligible Amounts
123456789 | 4 | General Education | 3000 | 1185 |  |  | 5000 |  | 2687 |  |  | 300 | 1355 | 919 |  | 727 |  |  |  |  | 35000 |  |  |  |  |  |  |  |  | 850
123456789 | 1 | Special School | 25000 |  | 3500 |  |  |  | 2687 |  |  |  | 7488 |  |  | 750 | 1172 | 587 |  |  | 1800 |  | 8000 |  |  |  |  |  |  |  | 300
Spreadsheet: 97695d1296802255-pivot-table-subtotals-on-inner-row-label-fields-pivot-chart-table-help
Sheet: Raw Data

State | Sample Size | Income ($)
Alabama | 140 | 100000
Alabama | 153 | 500000
Alabama | 27 | 800000
Alabama | 32 | 750000
Alabama | 71 | 100000
Alabama | 45 | 500000
Calif | 20 | 800000
Calif | 6 | 750000
Calif | 396 | 100000
Calif | 35 | 500000
Calif | 27 | 800000
Calif | 80 | 750000
Calif | 128 | 100000
Texas | 90 | 500000
Texas | 60 | 800000
Texas | 56 | 750000
Texas | 73 | 100000
Texas | 8 | 100000
Texas | 34 | 100000
Texas | 19 | 500000
Texas | 78 | 800000
Texas | 5 | 750000
Spreadsheet: phillip_m_love__30685__storage 9912&0001
Sheet: summary

 |  | Storage Variance
Prod Month | Facility | GL Volume | GL $ | [NAME] | Flash $ | Volume Var. | $ [NAME]. | Income Impact
9912 | [NAME] | -5864327 | -14100716
 | Centana | -63000 |  |  |  |  |  | -3248
 | CILCO | -504916 | -2273748 | -504916 | -1165111.74 |  |  | -1108636
 | Enron Gas Mktg |  | 2311 |  |  |  |  | 2311
0001 | [NAME] | -2562387 | -6135174
 | Centana | -115840 | -247573 | -50000 | -128440
 | CILCO | -854082 | -3862864 | -854082 | -1974467.45 |  |  | -1888397
 | Enron Gas Mktg |  | -120910 |  |  |  |  | -120910
0002 | [NAME] |  |  | -2920412 | -7999269
 | Centana | 0 | 0 | 0 | 0 |  |  | 0
 | CILCO | 0 | 0 | 0 | 0 |  |  | 0
 | Enron Gas Mktg |  | 885543 |  |  |  |  | 885543
Total
These amounts are net of inventory profit entries to be made in 0003 Accounting
Spreadsheet: 270588d1381532653-if-statement-difficult-ef496a_generate_text_conditionally
Sheet: Sheet1

Main | -4 |  |  |  |  | 2 |  |  |  |  | -2
A | 2 |  |  |  |  | 1 |  |  |  |  | -2
B | -9 |  |  |  |  | 3 |  |  |  |  | -3
C | -7 |  |  |  |  | 5 |  |  |  |  | -5
Spreadsheet: 621179d1556021220-returning-yes-no-results-from-multiple-sheets-volunteer-tracking-test
Sheet: Totals

Wrestlers  Name | Roast [NAME] | Tournament | Home Match #1 | Home Match #2 | Camp Credit Totals | Volunteer Obligations Met | Food Donation Obligations Met |  |  |  | Roast [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | Home Match #1
Jeremy |  |  |  |  |  |  |  |  |  |  | Home Match #2
[NAME] |  |  |  |  | 150
Spreadsheet: 886472d1736498574-calculate-average-hours-worked-over-52-weeks-not-including-time-off-dhfe-average-hours-tms
Sheet: Hours

Date | Average [NAME] | Time-Off | Average Hrs Pay | Josephteh
2023-01-02 00:00:00 | 1 | N
 | 2 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
 | 9.25 | N
Spreadsheet: 141a9ae5-8e65-473f-afc3-a1247256616c
Sheet: DCF

X | Dell Incorporated
 | Discounted Cash Flow Analysis
 | FY Ended Feb. 3
 | Operating Income
 | Tax-Affected EBIT (Operating Income )* (1-T)
 | (+) Depreciation
 | (+) Amortization of Intangibles | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | (-) Capital Expenditures
 | (-) Acquisition Spending
 | Unlevered Free Cash Flow to the Firm (UFCFF)
 | Net Present Value of 5 yr UFCFF |  |  | Risk-Free Rate (Normalized 10 Yr Treasury) |  |  |  | 0.0185
 | Terminal Value (Perpetuity Growth Method) |  |  | Target Debt to Capital |  |  |  | 0.51
 | Discounted Terminal Value |  |  | Equity Risk Premium (CAPM)
 | Enterprise Value |  |  | Beta (Equity) |  |  |  | 1.59
 | (+) Cash |  |  | Cost of Equity
 | (-) Market Value of Debt |  |  | Cost of Debt |  |  |  | 0.045
 | (-) PV of Operating Leases | 0
 | Equity Value |  |  | Weighted Average Cost of Capital (WACC)
 | (/) Diluted Shares Outstanding | 1853 |  | Perpetuity Growth Rate |  |  |  | 0.025
 | Implied Equity Value per Share |  |  | Tax Rate |  |  |  | 0.35
Spreadsheet: 778986d1651500153-ageing-defect-report-data-sheet-mccollantics2022-
Sheet: Report

ID | Priority | Defect Created Date | Days Open | Status
 |  |  |  |  |  | ID | Priority | Defect Created Date | Days Open | Status
 |  |  |  |  |  | 55005 | Very High | Mon Apr 11 13:49:29 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 55012 | High | Tue Apr 12 14:22:01 GMT 2022 | #[NAME]! | Opened
 |  |  |  |  |  | 55019 | High | Wed Apr 20 10:47:45 GMT 2022 | #[NAME]! | Opened
 |  |  |  |  |  | 55020 | Very High | Wed Apr 20 11:28:02 GMT 2022 | #[NAME]! | Ready to test
 |  |  |  |  |  | 55046 | High | Wed Apr 27 15:44:03 GMT 2022 | #[NAME]! | Opened
 |  |  |  |  |  | 56010 | High | Mon Apr 11 16:18:33 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 56012 | High | Tue Apr 12 10:38:28 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 56016 | Very High | Wed Apr 13 14:14:48 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 56018 | Urgent | 2022-04-14 09:26:21 | 13 | Closed
 |  |  |  |  |  | 56019 | High | Tue Apr 19 11:22:41 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 56023 | Very High | 2022-04-21 09:21:48 | 11 | Opened
 |  |  |  |  |  | 56028 | Very High | Mon Apr 25 11:09:15 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 56037 | Very High | Wed Apr 27 10:41:20 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 57008 | High | Mon Apr 11 16:30:55 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 57014 | High | Tue Apr 19 11:27:12 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 57017 | Very High | Tue Apr 19 14:42:20 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 57021 | Very High | Thu Apr 21 11:01:23 GMT 2022 | #[NAME]! | Closed
 |  |  |  |  |  | 57022 | Very High | Thu Apr 21 13:39:13 GMT 2022 | #[NAME]! | Closed
Spreadsheet: 105061d1302540262-weighted-average-including-n-a-cc1
Sheet: Call 5

 |  | Call ID: |  |  |  | Caller No.:
 |  | Date of Call: |  |  |  | Call Type:
 |  | Time of Call: |  |  |  | Duration:
 |  | Performance Area | Description | Performance |  |  |  |  |  |  |  | Performance Review Summary
 |  |  |  | Performance | Performance | Performance | Performance | Performance | Performance |  |  | Performance Area | Satisfactory Percentage | Weighting | Call 5 Weighted Score
 |  |  |  | Unacceptable | Below Satisfactory | Satisfactory | Good | Excellent | N/A
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  | 0.1
 |  | Opening | Welcome using company name |  | 1 |  |  |  |  |  |  |  |  | 0.25
 |  |  | Effective greeting |  |  | 1 |  |  |  |  |  |  |  | 0.15
 |  |  | Agent introduction including name |  |  | 1 |  |  |  |  |  |  |  | 0.15
 |  |  | Get customers name |  |  |  | 1 |  |  |  |  |  |  | 0.25
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  | 0.1
 |  | [NAME] | Every effort made towards first call resolution |  |  |  | 1 |  |  |  |  | Total Grade
 |  |  | Asked clarifying questions |  |  |  | 1
 |  |  | Demonstrated knowledge of products/services |  |  | 1
 |  |  | Showed clear understanding problems/issues |  |  | 1
 |  |  | Accurately diagnosed problems/issues |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | [NAME] | Volume & Clarity of agent |  |  |  |  | 1
 |  |  | Interruption of customer during call |  |  | 1
 |  |  | Demonstration of active listening |  |  |  | 1
 |  |  | Displayed a professional manner |  |  |  | 1
 |  |  | Polite, friendly & welcoming |  |  |  |  | 1
 |  |  | Avoided long silences / pauses |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | [NAME] | Requested permission to put on hold |  |  | 1
 |  |  | Used mute procedure effectively |  |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | Systems Skills | Used correct applications effectively |  |  |  | 1
 |  |  | Correctly escalated issues through [NAME] |  |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | Closing | Offer to assist with any other issue |  |  | 1
 |  |  | Close by thanking customer for contacting [NAME] |  |  | 1
Spreadsheet: 48848d1248151769-adding-multiple-values-for-same-lookup-excel_help
Sheet: Input_Production (3)

 |  |  |  |  |  |  |  | Line 40 |  |  |  |  |  |  |  |  |  |  | Line 50
Production Line # | Date Produced | Shift Produced | Product Code | Units produced
40 | 2009-05-20 00:00:00 | 1 | 15 168-19 | 5340 |  |  |  | 15 168-19 | 15 218-19 | 53 218-19 | 27 218-19 | 27 168-19 | 11 23H-19 | 53 030-19 | 27 030-19 | 11 716-19 | 53 716-19 | 53 034-19 | 15 168-19 | 15 218-19 | 53 218-19 | 27 218-19 | 27 168-19 | 11 23H-19 | 53 030-19 | 27 030-19 | 11 716-19 | 53 716-19 | 53 034-19
40 | 2009-05-20 00:00:00 | 1 | 15 218-19 | 9311 |  |  | Shift 1 | 0
40 | 2009-05-20 00:00:00 | 1 | 53 218-19 | 19075 |  |  | Shift 2 | 0
40 | 2009-05-20 00:00:00 | 1 | 15 168-19 | 60000 |  |  | Shift 3
40 | 2009-05-20 00:00:00 | 2 | 27 218-19 | 240
40 | 2009-05-20 00:00:00 | 2 | 53 218-19 | 12850
40 | 2009-05-20 00:00:00 | 3 | 27 168-19 | 6598
40 | 2009-05-20 00:00:00 | 3 | 27 218-19 | 24994
40 | 2009-05-24 00:00:00 | 3 | 11 23H-19 | 12320
50 | 2009-05-20 00:00:00 | 1 | 53 030-19 | 0
50 | 2009-05-20 00:00:00 | 2 | 27 030-19 | 20760
50 | 2009-05-20 00:00:00 | 2 | 53 030-19 | 32766
50 | 2009-05-20 00:00:00 | 3 | 11 716-19 | 3323
50 | 2009-05-20 00:00:00 | 3 | 27 030-19 | 40669
50 | 2009-05-21 00:00:00 | 1 | 11 716-19 | 33152
50 | 2009-05-21 00:00:00 | 1 | 53 716-19 | 38917
50 | 2009-05-21 00:00:00 | 2 | 53 218-19 | 2458
50 | 2009-05-21 00:00:00 | 2 | 53 716-19 | 37463
50 | 2009-05-21 00:00:00 | 3 | 53 034-19 | 34491
50 | 2009-05-21 00:00:00 | 3 | 53 218-19 | 5531
Spreadsheet: darrell_schoolcraft__7736__SUNFLOWER - NNG - HOURLY - 2002
Sheet: 5

WEEKENDS & AFTER 17:00 -
EMERGENCY CONTACTS: |  |  | [NAME] (PAGER)
 | S2 | [NAME] | S5 | HOLCOLM | S2 | [NAME] | S5 | S2, S4 & S5 | TOTAL
HOUR | MWH | MWH | MWH | MMBTU | MMBTU | MMBTU | MMBTU | MMBTU SUBTOTAL | MMBTU
09:00:00 |  | 0 | 0 | 6.75 | 0
10:00:00 |  | 0 | 0 | 6.75 | 0
11:00:00 |  | 0 | 0 | 6.75 | 0
12:00:00 |  | 0 | 0 | 6.75 | 0
13:00:00 |  | 0 | 0 | 6.75 | 0
14:00:00 |  | 0 | 0 | 6.75 | 0
15:00:00 |  | 0 | 0 | 6.75 | 0
16:00:00 |  | 0 | 0 | 6.75 | 0
17:00:00 |  | 0 | 0 | 6.75 | 0
18:00:00 |  | 0 | 0 | 6.75 | 0
19:00:00 |  | 0 | 0 | 6.75 | 0
20:00:00 |  | 0 | 0 | 6.75 | 0
21:00:00 |  | 0 | 0 | 6.75 | 0
22:00:00 |  | 0 | 0 | 6.75 | 0
23:00:00 |  | 0 | 0 | 6.75 | 0
1900-01-01 00:00:00 |  | 0 | 0 | 6.75 | 0
1900-01-01 01:00:00 |  | 0 | 0 | 6.75 | 0
1900-01-01 02:00:00 |  | 0 | 0 | 6.75 | 10.801546
1900-01-01 03:00:00 |  | 0 | 0 | 6.75 | 30.693502
1900-01-01 04:00:00 |  | 0 | 0 | 6.75 | 42.992292
1900-01-01 05:00:00 |  | 0 | 0 | 6.75 | 36.789424
1900-01-01 06:00:00 |  | 0 | 0 | 6.75 | 35.613018
1900-01-01 07:00:00 |  | 0 | 0 | 6.75 | 53.36605400000001
1900-01-01 08:00:00 |  | 0 | 0 | 6.75 | 176.353954
DAILY
TOTAL
Spreadsheet: 765752d1643566751-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Factory Orders

Salesperson | Year | Model | Client |  | Filled |  | ETA
Spreadsheet: 848587d1699292395-need-help-writing-formula-that-combines-data-excel-question-11-6-23
Sheet: Sheet1

Name | Sales Targets Hit | All Sales Targets Hits
[NAME] | Target A
Emma | Target A
[NAME] | Target A
Olivia | Target A
[NAME] | Target A
Ava | Target A
[NAME] | Target A
[NAME]
Emma | Target B
[NAME] | Target B
Olivia | Target B
[NAME] | Target B
Ava
[NAME] | Target B
[NAME] | Target C
Emma | Target C
[NAME]
Olivia | Target C
[NAME] | Target C
Ava | Target C
[NAME] | Target C
Spreadsheet: 489804d1479433340-vlookup-vlookup
Sheet: Jul

16-10-646 | a | TK-16-10-646 | 21 October 2016 | BB 11644 | NTT COMMUNICATIONS | 3265
16-10-646 | b | TK-16-10-646 | 21 October 2016 | BB 11644 | NTT COMMUNICATIONS | 1732
16-10-646 | c | TK-16-10-647 | 21 October 2016 | BB 11645 | NTT FLETS | 4500
Spreadsheet: 730544d1619758905-6-or-more-in-if-statements-showing-error-if-statement
Sheet: Sheet1

[NAME] Annual Base Salary |  |  |  |  |  |  |  |  | (3 x [NAME]) |  | GBP
250560 |  |  |  |  |  |  |  |  | Greater Than | Less Than
286704 |  |  |  |  |  |  |  |  | 0 | 258732.212160414 | 50000
275688 |  |  |  |  |  |  |  |  | 258733.212160414 | 388098.318240621 | 75000
353628 |  |  |  |  |  |  |  |  | 388099.318240621 | 517464.4243208279 | 100000
595368 |  |  |  |  |  |  |  |  | 517465.4243208279 | 646830.5304010349 | 125000
408240 |  |  |  |  |  |  |  |  | 646831.5304010349 | 776196.6364812419 | 150000
264636 |  |  |  |  |  |  |  |  | 776197.6364812419 |  | 200000
231300
275688
303084
Spreadsheet: sally_beck__35172__MgmtSum-Q3-0928_Global
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  | 3RD QTR 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME]
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Overview |  |  |  |  |  | 0 | 0
Office of the Chairman
Total Commercial
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
Interest Expense/(Income)
Global Markets Pre-tax Income
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 64257d1265132910-search-tabs-and-return-results-kc-environmental-aspects-and-impacts-worksheet-questions
Sheet: Process - Activity 11

Operating Condition | Process Evaluated |  | Date |  |  |  |  | Team
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 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
 |  |  |  |  | 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: 88479d1288281117-conditional-formatting-using-formula-nottersexample-1-
Sheet: Sheet1

2010-10-28 00:00:00
2010-11-15 00:00:00 |  | Due in 18 day(s) |  |  | Open
2010-10-20 00:00:00 |  | 8 day(s) late |  |  | Despatched
2010-10-31 00:00:00 |  | Due in 3 day(s) |  |  | Open
2010-11-05 00:00:00 |  | Due in 8 day(s) |  |  | Despatched
2010-08-23 00:00:00 |  | 66 day(s) late |  |  | Open
2010-11-30 00:00:00 |  | Due in 33 day(s) |  |  | Open
2010-11-24 00:00:00 |  | Due in 27 day(s) |  |  | Despatched
 | due in over 11 days
 | due between 10 and 3 days
 | Due in 2 or less days or late