tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 586433d1534378027-allocating-contract-costs-by-fiscal-month-contract-spend-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN
 |  |  |  |  |  |  |  |  | 2018-02-04 00:00:00 | 2018-03-04 00:00:00 | 2018-04-08 00:00:00 | 2018-05-06 00:00:00 | 2018-06-03 00:00:00 | 2018-07-08 00:00:00 | 2018-08-05 00:00:00 | 2018-09-02 00:00:00 | 2018-10-07 00:00:00 | 2018-11-04 00:00:00 | 2018-12-02 00:00:00 | 2019-01-06 00:00:00
 | SPEND | START | END | EOY | TOTAL DAYS | FISCAL DAYS | COST/DAY |  | 2018-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-02-02 00:00:00
 | 40161.44 | 2018-06-11 00:00:00 | 2018-10-19 00:00:00 | 2019-02-02 00:00:00
 | 10462.32 | 2018-06-25 00:00:00 | 2018-07-18 00:00:00 | 2019-02-02 00:00:00
 | 63406.61 | 2018-04-02 00:00:00 | 2019-07-01 00:00:00 | 2019-02-02 00:00:00
Spreadsheet: 688096d1595570603-vlookup-from-2-different-points-to-return-value-from-different-sheets-sample
Sheet: Print

 |  |  |  |  |  | Truck 01 | Cell g will change all the time to match truck number
 |  |  |  |  |  |  | which will change cell E   if Cell |  |  |  |  |  |  |  | SAMPLE | Monday |  |  |  | SAMPLE | Tuesday
 |  |  |  | carrier
 |  | carrier |  |  |  |  |  |  |  |  |  | Pick day below |  |  |  |  | carrier |  |  |  |  | carrier
 |  |  |  |  |  |  |  |  |  |  |  | Monday |  |  | Truck 01 |  | aaaa |  |  | Truck 01 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 02 |  | bbbb |  |  | Truck 02 |  | aaaa
 |  |  |  |  |  |  |  |  | day will only change once a day |  |  |  |  |  | Truck 03 |  | aaaa |  |  | Truck 03 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 04 |  | dddd |  |  | Truck 04 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 05 |  | rrrrr |  |  | Truck 05 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 06 |  | aaaa |  |  | Truck 06 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 07 |  | abc123 |  |  | Truck 07 |  | abc123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 08 |  |  |  |  | Truck 08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 09 |  | abc123 |  |  | Truck 09 |  | abc123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 10 |  | dddd |  |  | Truck 10 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 11 |  |  |  |  | Truck 11 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 12 |  | abc123 |  |  | Truck 12 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 13 |  |  |  |  | Truck 13 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 14 |  | bbbb |  |  | Truck 14 |  | bbbb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 15 |  |  |  |  | Truck 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 16 |  | aaaa |  |  | Truck 16 |  | abc123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 17 |  |  |  |  | Truck 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 18 |  | aaaa |  |  | Truck 18 |  | abc123
Spreadsheet: 889965d1741037445-reference-a-table-object-in-let-merge-tables-with-inheritance
Sheet: Joined

 | Primary | Value 2 | Value 3 | Value 4 | Value 5 | Value 6
1234561 | Parent 1 | Parent 11 | Parent 12 | Parent 13 | Parent 14 | Parent 15
1234562 | Parent 2 | Parent 21 | Parent 22 | Parent 23 | Parent 24 | Parent 25
1234563 | Parent 3 | Parent 31 | Parent 32 | Parent 33 | Parent 34 | Parent 35
1234564 | Parent 4 | Parent 41 | Parent 42 | Parent 43 | Parent 44 | Parent 45
1234565 | Parent 5 | Parent 51 | Parent 52 | Parent 53 | Parent 54 | Parent 55
1234566 | Parent 6 | Parent 61 | Parent 62 | Parent 63 | Parent 64 | Parent 65
1234567 | Parent 7 | Parent 71 | Parent 72 | Parent 73 | Parent 74 | Parent 75
1234568 | Parent 8 | Parent 81 | Parent 82 | Parent 83 | Parent 84 | Parent 85
1234569 | Parent 9 | Parent 91 | Parent 92 | Parent 93 | Parent 94 | Parent 95
1234570 | Parent 10 | Parent 101 | Parent 102 | Parent 103 | Parent 104 | Parent 105
1234571 | Parent 11 | Parent 111 | Parent 112 | Parent 113 | Parent 114 | Parent 115
1234572 | Parent 12 | Parent 121 | Parent 122 | Parent 123 | Parent 124 | Parent 125
1234573 | Parent 13 | Parent 131 | Parent 132 | Parent 133 | Parent 134 | Parent 135
1234574 | Parent 14 | Parent 141 | Parent 142 | Parent 143 | Parent 144 | Parent 145
1234575 | Parent 15 | Parent 151 | Parent 152 | Parent 153 | Parent 154 | Parent 155
1234576 | Parent 16 | Parent 161 | Parent 162 | Parent 163 | Parent 164 | Parent 165
234577 | Parent 1 | Child 35 | Parent 12 | Child 45 | Child 55 | Parent 15
234578 | Parent 2 | Child 36 | Parent 22 | Child 46 | Child 56 | Parent 25
234579 | Parent 3 | Child 37 | Parent 32 | Child 47 | Child 57 | Parent 35
234580 | Parent 1 | Child 35 | Parent 12 | Child 45 | Child 55 | Parent 15
234581 | Parent 2 | Child 36 | Parent 22 | Child 46 | Child 56 | Parent 25
234582 | Parent 3 | Child 37 | Parent 32 | Child 47 | Child 57 | Parent 35
234583 | Parent 1 | Child 35 | Parent 12 | Child 45 | Child 55 | Parent 15
234584 | Parent 2 | Child 36 | Parent 22 | Child 46 | Child 56 | Parent 25
234585 | Parent 3 | Child 37 | Parent 32 | Child 47 | Child 57 | Parent 35
234586 | Parent 1 | Child 35 | Parent 12 | Child 45 | Child 55 | Parent 15
234587 | Parent 2 | Child 36 | Parent 22 | Child 46 | Child 56 | Parent 25
234588 | Parent 3 | Child 37 | Parent 32 | Child 47 | Child 57 | Parent 35
234589 | Parent 1 | Child 35 | Parent 12 | Child 45 | Child 55 | Parent 15
234590 | Parent 2 | Child 36 | Parent 22 | Child 46 | Child 56 | Parent 25
Spreadsheet: 799109d1664925745-sick-time-tracker-with-cap-on-maximum-accrued-plus-sick-time-used-sampleworkbook
Sheet: Janitorial sick time

Hours Accrued | SD hours used | Balance
 | 24
 | 20
 | 60
 | 52
 | 2
 | 0
 | 19
 | 0
 | 27.4
Spreadsheet: 59175d1259654899-summing-across-multiple-sheets-summary-report
Sheet: Oct-09

 | Trip details
Name | From | To | Number Of Days | Destination | Total ammount | reason of trip
[NAME] | 2009-10-06 00:00:00 | 2009-10-06 00:00:00 | 1 | Dubai | 40.097
[NAME] | 2009-10-06 00:00:00 | 2009-10-06 00:00:00 | 1 | Dubai
Shakeel Younus | 2009-10-18 00:00:00 | 2009-10-19 00:00:00 | 2 | Dubai | 55.214
[NAME] | 2009-10-18 00:00:00 | 2009-10-19 00:00:00 | 2 | Dubai | 182.265
[NAME] | 2009-10-18 00:00:00 | 2009-10-19 00:00:00 | 2 | Dubai | 270.152
[NAME] | 2009-10-18 00:00:00 | 2009-10-19 00:00:00 | 2 | Dubai | 166.747
[NAME] | 2009-10-24 00:00:00 | 2009-10-24 00:00:00 | 1 | Iraq | 70
[NAME] | 2009-10-28 00:00:00 | 2009-10-28 00:00:00 | 1 | Iraq | 78.55
 | Total Days |  | 12 |  | 863.0250000000001
 |  | Saving |  | #N/A
Spreadsheet: benjamin_rogers__1227__UAE with 2 LM's & debt structure 04-21-00
Sheet: Returns Analysis

RETURNS ANALYSIS
 | 0
('000 $) | Close
EBITDA | 0
Less Interest Payments | 0
Pre-Tax Cashflow
Less Cash Taxes | 0
Less Principal Payments | 0
Less Capex | 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
Cashflow to Equity
Distribution to Equity | 1
Equity RROR | 0.14
Beginning Balance
RROR Target Coupon | 0
Actual Cash Flow
Equity Paydown | 0
Ending Balance
ENRON'S RETURNS ANALYSIS
Zero Residual Value
Equity Return
Actual Cash Flow
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 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
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 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
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 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
Total Cash Flow
 | IRR
Spreadsheet: 813428d1673748914-countif-between-two-dates-countif-between-two-dates-1-
Sheet: Taux de service

 | Taux de service
2022
2023
2024
2025 | Mois | 2
2026 | Année | 2023
2027
2028 |  |  | 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
 |  | Service
 |  | Logistique
 |  | Ressource Humaines
 |  | Finnance et Comptabilité
 |  | Commercial
 |  | Marketing
 |  | IT
 |  | Service | Employés | Date de départ | Date de retour | Type de congés | durée | Total | Depuis Recrutement | Reliquat
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | [NAME] | 2023-02-01 00:00:00 | 2023-02-06 00:00:00 | CA | 12 |  | 161.8333333333333
 |  | Ressource Humaines | Bekka Souad | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | CA | 21 |  | 161.9166666666667
 |  | Ressource Humaines | [NAME] sabria | 2023-02-12 00:00:00 | 2023-03-02 00:00:00 | CA | 18 |  | 238.5833333333333
Spreadsheet: 70012d1270663430-iferror-with-zeros-2009-8teams-1_jt
Sheet: WEEK 3A

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost | TOT Unit Profit | TOT $$$ Profit
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | BOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | MIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CHC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | KC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
RETURN TO MLB OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT L | 0 | 0
WEEK 3A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT W | 0
Spreadsheet: 215688d1361457285-merging-seperate-spreadsheets-susan
Sheet: Susan

Head 1 | Head 2 | Head 3 | Head 4 | Head 5 | Head 6 | Head 7 | Head 8 | Head 9 | Head 10 | To Master
1 | Blah 10 | Widget 10 | Value 10 | Head 5 1 | Head 6 1 | Head 7 1 | Head 8 1 | Head 9 1 | Head 10 1
2 | Blah 11 | Widget 11 | Value 11 | Head 5 2 | Head 6 2 | Head 7 2 | Head 8 2 | Head 9 2 | Head 10 2
3 | Blah 12 | Widget 12 | Value 12 | Head 5 3 | Head 6 3 | Head 7 3 | Head 8 3 | Head 9 3 | Head 10 3
4 | Blah 13 | Widget 13 | Value 13 | Head 5 4 | Head 6 4 | Head 7 4 | Head 8 4 | Head 9 4 | Head 10 4
Spreadsheet: 139364d1328201980-multiple-sumif-statements-forum-example
Sheet: Summary Sheet

 |  | Pre 2012 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6
 |  | 2010-01-01 00:00:00 | 2012-01-01 00:00:00
 |  | 2011-12-31 00:00:00 | 2012-01-07 00:00:00
Project Name | Item # | Hours | Hours | Hours | Hours | Hours | Hours
Job 1 | 0130D
Job 1 | 0131D
Job 1 | 0132D
Job 1 | 0133D
Job 1 | 0134D
Job 1 | 0135D
Job 1 | 0136D
Job 1 | 0137D
Job 1 | 0138D
Job 1 | 0139D
Job 1 | 0140D
Job 1 | 0141D
Job 1 | 0142D
Job 2 | 0130D
Job 2 | 0131D
Job 2 | 0132D
Job 2 | 0133D
Job 2 | 0134D
Job 2 | 0135D
Job 2 | 0136D
Job 2 | 0137D
Job 2 | 0138D
Job 2 | 0139D
Job 2 | 0140D
Job 2 | 0141D
Job 2 | 0142D
Spreadsheet: 77774d1278255495-change-text-date-to-month-numbers-copy-1
Sheet: Sheet1

invoice no | date | period | months | rental charge | due | amt paid
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 | 1 | 3336 | 3336
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 | 1 | 25362 | 25362
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 | 1 | 3336 | 3336
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 | 1 | 25362 | 25362
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 | 1 | 3336 | 3336
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 | 1 | 3336 | 3336
251 | 2010-05-05 00:00:00 | jan-mar |  | 25362 | 25362
251 | 2010-05-05 00:00:00 | jan-mar |  | 3336 | 3336
251 | 2010-05-05 00:00:00 | jan-mar |  | 25362 | 25362
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 |  | 2653 | 2653 | 5306
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 |  | 2653 | 2653 | 5306
251 | 2010-05-05 00:00:00 | 2010-02-01 00:00:00 |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | 2010-01-01 00:00:00 |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | [NAME] |  | 25362 | 25362
251 | 2010-05-05 00:00:00 | [NAME] |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | [NAME] |  | 2653 | 2653 | 5306
251 | 2010-05-05 00:00:00 | [NAME] |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | [NAME] |  | 2653 | 2653 | 5306
251 | 2010-05-05 00:00:00 | [NAME] |  | 3336 | 3336
251 | 2010-05-05 00:00:00 | [NAME] |  | 25362 | 25362
251 | 2010-05-05 00:00:00 | [NAME] |  | 3336 | 3336
251 | 2010-05-05 00:00:00 | [NAME] |  | 25362 | 25362
251 | 2010-05-05 00:00:00 | [NAME] |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | [NAME] |  | 2653 | 2653 | 5306
251 | 2010-05-05 00:00:00 | march |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | march |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | march |  | 756.02 | 756.02 | 1512.04
251 | 2010-05-05 00:00:00 | march |  | 25362 | 25362
 |  | april |  | 756.02 | 756.02 | 1512.04
 |  | april |  | 756.02 | 756.02 | 1512.04
 |  | april |  | 756.02 | 756.02 | 1512.04
 |  | april |  | 25362 | 25362
 |  | april |  | 756.02 | 756.02 | 1512.04
 |  | april |  | 2653 | 2653 | 5306
 |  |  |  |  |  |  |  | hjk
 |  |  |  |  |  |  |  | hj
 |  | hjkhjk
 |  | khjk
 |  | hjk |  | khj
 |  |  |  |  |  | hjk
Spreadsheet: 818303d1676722627-model-with-weights-trying-to-perform-2m-vlookups-model-and-weights-query
Sheet: Sheet2

 |  | Answer | Personality 1 | Personality 2 | Personality 3 | Personality 4 | Personality 5 | Personality 6
 | Answer 1 | Y | 10 | 1 | 0 | -0.25 | 0 | -10
 | Answer 1 | N | -10 | -1 | 0 | 0.25 | 0.5 | 1
 | Answer 2 | Y | 5 | 1 | 0 | -5 | 0 | -10
 | Answer 2 | N | -5 | -1 | 0 | 0 | 0.5 | 1
 | Answer 3 | Y | 2 | 1 | 0 | -10 | 0 | -1
 | Answer 3 | N | -2 | -1 | 0 | 10 | 0.5 | -2
 | Answer 4 | Y | 10 | 1 | 0 | -0.25 | 0 | -10
 | Answer 4 | N | -10 | -1 | 0 | 0.25 | 0.5 | 1
 | Answer 5 | Y | 5 | 1 | 0 | -5 | 0 | -10
 | Answer 5 | N | -5 | -1 | 0 | 0 | 0.5 | 1
 | Answer 6 | Y | 2 | 1 | 0 | -10 | 0 | -1
 | Answer 6 | N | -2 | -1 | 0 | 10 | 0.5 | -2
 | Answer 7 | Y | 10 | 1 | 0 | -0.25 | 0 | -10
 | Answer 7 | N | -10 | -1 | 0 | 0.25 | 0.5 | 1
 | Answer 8 | Y | 5 | 1 | 0 | -5 | 0 | -10
 | Answer 8 | N | -5 | -1 | 0 | 0 | 0.5 | 1
Spreadsheet: 792389d1660874261-calculate-deadline-based-on-production-capacity-prod-cap-deadlines-imtryingmybestok-
Sheet: 2.0 (2)

 | project ID |  |  |  |  |  |  |  |  | Standard production capacity |  |  |  |  | Yes
 | words | 1500 | pages | 25 | hours | 3 |  |  |  | 1000 | words take | 1 | h |  | No
 |  |  |  |  |  |  |  |  |  | 2 | pages take | 2 | h
 | Assignment | Priority | Task | Step 1 | Step 2 | Step 3 | Deadline
 | 1 | Yes |  |  |  |  | 2022-08-16 10:00:00
 | 2 | No |  |  |  |  | 2022-08-16 18:00:00 |  |  | Hour range
 | 3 | Yes |  |  |  |  | 2022-08-16 18:00:00 |  |  | from | 08:30:00 | till | 17:00:00
 | 4 |  |  |  |  |  | 2022-08-17 18:00:00
 | 5 |  |  |  |  |  | 2022-08-22 18:00:00
 |  |  |  |  |  |  |  |  |  | time needed for step 2 |  | 3 | h
 |  |  |  |  |  |  |  |  |  | time needed for step 3 |  | 4 | h
 |  |  |  |  |  |  |  |  |  | Start: | 2022-08-16 10:00:00
Spreadsheet: 31275d1227093005-dynamic-graphs-using-offset-book2
Sheet: test

 |  |  |  | Starting from | 16
 |  |  |  | Number to show | 6
 | 1999-01-01 00:00:00 | 50 | 200
 | 1999-02-01 00:00:00 | 100 | 500
 | 1999-03-01 00:00:00 | 200 | 600
 | 1999-04-01 00:00:00 | 500 | 400
 | 1999-05-01 00:00:00 | 600 | 300
 | 1999-06-01 00:00:00 | 400 | 50
 | 1999-07-01 00:00:00 | 300 | 250
 | 1999-08-01 00:00:00 | 500 | 300
 | 1999-09-01 00:00:00 | 600 | 600
 | 1999-10-01 00:00:00 | 400 | 700
 | 1999-11-01 00:00:00 | 100 | 600
 | 1999-12-01 00:00:00 | 50 | 500
 | 2000-01-01 00:00:00 | 100 | 100
 | 2000-02-01 00:00:00 | 200 | 50
 | 2000-03-01 00:00:00 | 500 | 100
 | 2000-04-01 00:00:00 | 600 | 200
 | 2000-05-01 00:00:00 | 400 | 200
 | 2000-06-01 00:00:00 | 300 | 200
 | 2000-07-01 00:00:00 | 50 | 200 |  |  |  | XValues | 36708
 | 2000-08-01 00:00:00 | 250 | 300 |  |  |  | YValues | 1900-01-01 00:00:00
 | 2000-09-01 00:00:00 | 300 | 500 |  |  |  | Y2Values | 500
 | 2000-10-01 00:00:00 | 600 | 600
 | 2000-11-01 00:00:00 | 700 | 400
 | 2000-12-01 00:00:00 | 600 | 100
Spreadsheet: 681181d1591377579-vlookup-and-index-match-quicker-alternatives-example
Sheet: Sheet2

ID | France | Germany | Holland | Italy | Iran | [NAME]
1 | C
2 |  |  |  | I
3 |  |  |  | C
4 |  |  |  | I
5 |  |  |  |  | C
6 |  | I
7 |  |  | C
8 |  |  | I
9 |  |  | C
10 |  |  |  |  |  | I
Spreadsheet: 727712d1618052228-help-identify-position-on-graph-excelhelp2
Sheet: Sheet1

Row Labels | Sum of Total Discount | Sum of Gross Price List Price
Applied Materials Inc. - (42728840)Americas | 0.9589498538238209 | 81764958.49804688
Dell Technologies Inc. - (601839660)Americas | 0.9453015892525085 | 33083172.97500038
General Dynamics Corporation - (1381284)Americas | 0.9445326319601323 | 23869102.20019531
Honeywell International Inc. - (139691877)Americas | 0.9897631030456128 | 151378675.9375
Huntington Ingalls Industries Inc. - (967362331)Americas | 0.8317054338586382 | 22915974
Koch Industries Inc. - (6944334)Americas | 0.7722227378364783 | 16539832.33000183
Lear Corporation - (175592476)Americas | 0.8315551746301538 | 21260244
Massachusetts Institute of Technology - (1425594)Americas | 0.9560792070603206 | 20009694
N/AAmericas | 0.9957219041887215 | 7081979667.710291
Space Exploration Technologies Corp. - (120406462)Americas | 0.8917564960180722 | 36775354.20019531
Grand Total | 0.9927302601198268 | 7489576675.851231
Spreadsheet: 871321d1717696319-sla-business-hours-calculation-isolated-date-issue-jamessullivan88-
Sheet: Sheet2

 |  | Start Date
 |  | Dates
 |  | Day | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | Start
 |  | End
Date
Start Time
End Time
Duration
SLA
Finish Date
Finish Time
Spreadsheet: 145330d1331536174-specific-formating-question-for-column-of-data-utc2012-specific-formating-question-for-column-of-data
Sheet: Sheet1

Input |  |  |  |  |  | Result | Required |  | Result
1H2406 | 1 | H2406 | 2406 | H | HO | 001HO02406 | 001HO02406 |  | 001HO02406 |  |  | H | HO
501H7052 | 501 | H7052 | 7052 | H | HO | 501HO07052 | 501HO07052 |  | 501HO07052 |  |  | WW | WW
97WW5247 | 97 | WW5247 | 5247 | WW | WW | 097WW05247 | 097WW05247 |  | 097WW05247 |  |  | G | GU
11G3764 | 11 | G3764 | 3764 | G | GU | 011GU03764 | 011GU03764 |  | 011GU03764 |  |  | S | SR
203SR5846 | 203 | SR5846 | 5846 | SR | SR | 203SR05846 | 203SR05846 |  | 203SR05846 |  |  | J | JE
9J781 | 9 | J781 | 781 | J | JE | 009JE00781 | 009JE00781 |  | 009JE00781 |  |  | MO | MO
205MO2783 | 205 | MO2783 | 2783 | MO | MO | 205MO02783 | 205MO02783 |  | 205MO02783 |  |  | L | LB
100LB937 | 100 | [NAME] | 937 | LB | LB | 100LB00937 | 100LB00937 |  | 100LB00937 |  |  | MS | MS
Spreadsheet: 756543d1637621366-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: March

 | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU
 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-07 00:00:00 | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-13 00:00:00 | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-27 00:00:00 | 2021-03-28 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU
 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-07 00:00:00 | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-13 00:00:00 | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-27 00:00:00 | 2021-03-28 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 95989d1295473901-excel-2007-if-and-or-workproject
Sheet: EMPLOYEES

Employee Number | Title | Surname | First Name | Gender | DOB | Address | Town | County | Post Code | Start Date | Dept | Pay Grade | Pension | Tax Letter
 |  |  |  |  |  |  |  |  |  | 10/08/1991 | Production |  | Y | L
 |  |  |  |  |  |  |  |  |  | 22/08/1991 | Production |  | Y | H
 |  |  |  |  |  |  |  |  |  | 09/12/1991 | [NAME] |  | Y | H
 |  |  |  |  |  |  |  |  |  | 03/03/1992 | Production |  | Y | L
 |  |  |  |  |  |  |  |  |  | 05/03/1992 | Design |  | N | H
 |  |  |  |  |  |  |  |  |  | 14/06/1993 | [NAME] |  | N | L
 |  |  |  |  |  |  |  |  |  | 10/02/1994 | [NAME] |  | N | H
 |  |  |  |  |  |  |  |  |  | 01/12/1994 | Production |  | Y | H
 |  |  |  |  |  |  |  |  |  | 11/01/1995 | Production |  | N | H
 |  |  |  |  |  |  |  |  |  | 06/02/1995 | Production |  | Y | H
 |  |  |  |  |  |  |  |  |  | 17/02/1995 | Production |  | N | L
 |  |  |  |  |  |  |  |  |  | 08/11/1995 | [NAME] |  | Y | L
 |  |  |  |  |  |  |  |  |  | 05/08/1996 | Design |  | Y | H
 |  |  |  |  |  |  |  |  |  | 02/01/1998 | Production |  | Y | L
 |  |  |  |  |  |  |  |  |  | 11/07/1998 | Design |  | Y | L
 |  |  |  |  |  |  |  |  |  | 17/08/1998 | [NAME] |  | Y | L
 |  |  |  |  |  |  |  |  |  | 18/12/1998 | Production |  | N | L
 |  |  |  |  |  |  |  |  |  | 11/10/1999 | [NAME] |  | N | H
 |  |  |  |  |  |  |  |  |  | 29/11/1999 | Design |  | N | H
 |  |  |  |  |  |  |  |  |  | 29/07/2002 | Production |  | N | H
 |  |  |  |  |  |  |  |  |  | 28/11/2002 | Design |  | N | H
 |  |  |  |  |  |  |  |  |  | 22/12/2002 | Production |  | Y | L
 |  |  |  |  |  |  |  |  |  | 29/02/2004 | Design |  | Y | H
 |  |  |  |  |  |  |  |  |  | 26/04/2004 | Production |  | Y | L
 |  |  |  |  |  |  |  |  |  | 19/07/2004 | Production |  | Y | H
 |  |  |  |  |  |  |  |  |  | 24/04/2006 | Production |  | Y | H
 |  |  |  |  |  |  |  |  |  | 19/05/2007 | Production |  | Y | L
 |  |  |  |  |  |  |  |  |  | 01/03/2008 | Design |  | N | H
 |  |  |  |  |  |  |  |  |  | 19/01/2009 | Production |  | N | L
 |  |  |  |  |  |  |  |  |  | [NAME] | Design |  | N | H