tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 835703d1688736177-finding-6-months-or-more-apart-date-6-months-apart-dates-dharmeshchauhan-
Sheet: Export

Assessment |  |  |  |  |  |  |  |  |  |  | Audiometry surveillance | Colour Vision Critical | Confined Spaces | FLT assessment | Food Handling | HAVS surveillance | Ionising Radiation | Manual Handling | Nightworker | Respiratory surveillance | Skin surveillance | [NAME] | Work at Heights
Unique ID | Surname | Forename | Job Title | Date of Birth | [NAME] | Division | Location | Department | Line Manager | Line Manager [NAME] | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | 6 Months Apart | 6 Months Plus
10000042 | [NAME] | [NAME] | FLT | 1988-11-27 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-06-28 00:00:00 |  | 2023-06-28 00:00:00 |  | 2023-06-28 00:00:00 |  |  |  |  | 2023-06-29 00:00:00
10000051 | [NAME] | Anna | Quality Assurance Technician | 1977-02-26 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-09-12 00:00:00 |  |  |  |  |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00
10000052 | Barclay | [NAME] | Capri | 1971-04-20 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2024-05-25 00:00:00 |  |  |  | 2025-05-25 00:00:00 |  |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  |  |  | Food Handling, Audiometry surveillance
10000055 | Bekey-Mills | [NAME] |  | 1963-07-03 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-01-27 00:00:00 |  | 2023-01-27 00:00:00 |  | 2023-01-27 00:00:00 |  |  |  | 2023-06-27 00:00:00 | 2023-06-27 00:00:00 |  |  |  | Nightworker,Respiratory surveillance
10000056 | [NAME] | [NAME] |  | 1979-05-10 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2024-01-19 00:00:00 |  |  |  |  |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  | 2023-06-29 00:00:00 |  | Audiometry surveillance
10000058 | [NAME] | [NAME] '[NAME]' | Tech Op | 2001-10-18 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-06-28 00:00:00 |  |  |  | 2023-06-28 00:00:00 |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00
10000059 | Briody | Jordan | Engineer | 1997-02-12 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-05-18 00:00:00 |  |  |  | 2023-05-18 00:00:00 |  |  | 2023-05-18 00:00:00 |  | 2023-11-29 00:00:00 |  |  |  |  | Respiratory surveillance
10000060 | Briody | Mark | STORES | 1977-04-15 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2024-05-26 00:00:00 |  | 2028-05-26 00:00:00 |  |  |  |  |  |  | 2023-06-29 00:00:00
Spreadsheet: 43901d1242555572-average-column-depending-on-values-in-another-column-forex-journal-template
Sheet: APRJOURNAL

 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 | TOTALS
Spreadsheet: 779458d1651789759-sumproduct-with-named-ranges-indirect-and-multiple-criteria-sales-2022-phone-stats-to-get-formula
Sheet: March

2022 | Inbound Sales
Date | Handled ACD Calls | [NAME] | Total Calls Rcd | [NAME] | [NAME] (sec) | [NAME] (sec) | Max Wait Time (sec) | Avg Wrap Time | Avg Call Time (sec) | Five9 OB Calls | Outbound Calls
2022-02-27 00:00:00
 | 0 |  |  |  |  |  |  | 0
 |  | 45 |  |  |  |  |  |  |  | 328
 |  | 82 |  |  |  |  |  |  |  | 427
 |  | 34 |  |  |  |  |  |  |  | 530
 |  | 32 |  |  |  |  |  |  |  | 362 | 313
Week TTL
 |  | 55 |  |  |  |  |  |  |  | 386 | 207
 |  | 33 |  |  |  |  |  |  |  | 399 | 336
 |  | 36 |  |  | 239 | 267 | 908 | 100 | 685 | 375 | 260
 |  | 40 |  |  | 376 | 360 | 1449 | 105 | 693 | 79 | 293
 |  | 32 |  |  | 174 | 265 | 795 | 121 | 729 | 332 | 282
Week TTL
 |  | 38 |  |  | 194 | 268 | 1016 | 88 | 672 | 227 | 309
 |  | 48 |  |  | 208 | 246 | 756 | 109 | 607 | 321 | 337
 |  | 33 |  |  | 198 | 159 | 969 | 153 | 661 | 268 | 313
 |  | 18 |  |  | 178 | 153 | 926 | 159 | 634 |  | 363
 |  | 24 |  |  | 151 | 129 | 818 | 185 | 651 |  | 286
Week TTL
 |  | 52 |  |  | 226 | 314 | 918 | 143 | 668 |  | 236
 |  | 37 |  |  | 188 | 203 | 855 | 154 | 635 |  | 336
 |  | 47 |  |  | 128 | 171 | 629 | 138 | 644 |  | 314
 |  | 10 |  |  | 146 | 124 | 494 | 174 | 643 |  | 250
 |  | 19 |  |  | 123 | 109 | 650 | 128 | 633 |  | 294
Week TTL
 |  | 55 |  |  | 184 | 323 | 795 | 137 | 636 | 289 | 213
 |  | 34 |  |  | 192 | 232 | 948 | 147 | 635 |  | 354
 |  | 60 |  |  | 208 | 235 | 1098 | 143 | 593 |  | 337
 |  | 21 |  |  | 134 | 209 | 1067 | 142 | 602 |  | 399
Week TTL
Month TTL
 |  |  |  |  |  |  |  |  |  |  | For Outbound Calls
 |  |  |  |  |  |  |  |  |  |  | Sales Agent Only Reason Code Summary with outbound Call Count
Spreadsheet: 190508d1351679528-how-sorting-with-linked-formulas-saeedo
Sheet: Лист1

A | B | C |  | E | F | G
1 | Mark | 3 |  | 20 | Mark | 4
2 | Erin | 1 |  | 21 | Mark | 2
3 | [NAME] | 0 |  | 22 | Erin | 1
 |  |  |  | 23 | Erin | 1
 |  |  |  | 24 | Erin | 1
 |  |  |  | 25 | [NAME] | 0
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: CRI Tracker and Schedule

ERF # | SN | Project Name | [NAME] | Site Due Date | Activity Plan | Part Number IN Generic: If comp bladed we could use RTRBLDFCRFBCU If un bladed we could use RTRUNBFCRFBCU ([NAME]) | Part Number OUT (Brown & Brown Refurb) | Serial Number | Note(s) | Was Arrival Date | Was Site Due Date
ERF-20-01782 | 300020094 | Calcasieu_Entergy_GT-01_W501FD2 Forced Outage 029191-MS
ERF-19-00294 | 300017238 | Mystic 93 026224-MS | 2020-10-20 00:00:00 | 2021-03-19 00:00:00 |  |  |  |  |  | 9/15/2020 10/20/2020 | 3/1/2021 2/26/2021
ERF-20-01149 | 300019182 | Termocandelaria GT1 027746-MS | 2020-12-15 00:00:00 | 2021-04-01 00:00:00 |  |  |  |  |  | 2020-11-02 00:00:00 | 2020-03-31 00:00:00
ERF-19-00102-04 | 300017603 | [NAME] 026709-MS | 2020-12-01 00:00:00 | 2021-05-31 00:00:00 |  |  |  |  |  | 10/1/2020 12/15/2020 | 2021-02-25 00:00:00
ERF-19-00102-03 | 300017602 | [NAME]Hobbs GT2 026709-MS | 2020-12-01 00:00:00 | 2022-01-24 00:00:00 |  |  |  |  |  | 10/1/2020 12/15/2020 | 2/25/2021 3/1/2022 2/7/2022
 |  | Tuxpan 5 | 2021-02-08 00:00:00 | 2021-11-12 00:00:00 |  |  |  |  |  | 12/15/2020 2/8/2021 1/4/2021 2/8/2021 | 2/7/2022 7/15/2021 5/1/2021 11/12/2021
 |  | Andres | 2021-02-08 00:00:00 | 2022-06-24 00:00:00 |  |  |  |  |  | 12/15/2020 2/8/2021 1/4/2021 2/8/2021 | 2/7/2022 4/23/2021 5/20/2022 6/24/2022
ERF-20-01764 |  | [NAME] W501F | 2021-02-22 00:00:00 | 2021-04-23 00:00:00 |  |  |  |  |  | 1/4/2021 3/4/2021 2/22/2021 | 4/1/2021 8/18/2021 4/23/21
[NAME] | 300017472 | Costanera GT8 | 2021-03-01 00:00:00 | TBD
 |  | LTSA Spare 1 | 2021-05-03 00:00:00 | 2023-12-01 00:00:00
 |  | LTSA Spare 2 | 2021-05-03 00:00:00 | 2023-12-01 00:00:00
 |  | [NAME] 1A 004800-MS | 2021-11-01 00:00:00 | TBD
 |  | [NAME] 1B 004800-MS | 2021-11-01 00:00:00 | TBD
 |  | [NAME] 1C 004800-MS | 2021-11-01 00:00:00 | TBD
 |  | Rio Bravo 22 ([NAME]) | 2021-05-03 00:00:00 | 2022-02-18 00:00:00
ERF-20-00760 | 300019661 | FP&L 3A CRI | 2021-05-03 00:00:00 | 2022-01-07 00:00:00
 |  | Rio Bravo 21 (Rio Blk 4) | 2021-05-03 00:00:00 | 2022-11-11 00:00:00
 |  | Mystic GT82 | 2021-05-05 00:00:00 | 2021-10-19 00:00:00
 |  | Termocandelaria GT1 | 2021-06-08 00:00:00 | 2022-01-03 00:00:00
 |  | Mystic GT81 (Excelon) | 2021-10-11 00:00:00 | 2022-03-25 00:00:00
ERF-20-00803 |  | FP&L 3C CRI | 2021-10-15 00:00:00 | 2022-04-29 00:00:00
Spreadsheet: 840258d1692614445-training-log-possible-if-formulas-required-training-tracker-sample
Sheet: Training

 | Table 1: Site/Service Details |  |  | Table 2: Training Summary | Total Number | % Compliance
 | Training/Policy Year: |  |  | No. of employees |  | N/A
 | Name of site / service: |  |  | No. of employees on Extended Leave |  | N/A
 | Department/ ward/ unit: |  |  | No. of active employees for whom a TNA has been completed
 | Responsible Person: |  |  | No. of Training Programmes Identified |  | N/A
 | Completed By: |  |  | No. of Training Programmes Up To Date
 | Date (today): |  |  | No. of training programmes due for refresher/ completion
 | Date log last reviewed:
 |  |  |  | Name of Training or Policy | Biological Agents | Repeat not less than 3 yearly | Chemical | Repeat not less than 3 yearly | Chemical Safety | Repeat not less than 3 yearly | COVID-19 | First Aid Responder
 | Employee (name) | Title | Personnel Number | Staff Category | Last completed | Due | Last completed | Due | Last completed | Due | Last completed | Last completed
 | Employee 1 |  |  |  | 2022-06-21 00:00:00 |  | 2020-06-21 00:00:00 |  | 2023-07-31 00:00:00 |  | 2023-01-18 00:00:00 | NA
 | Employee 2 |  |  |  | NA |  | 2021-08-12 00:00:00 |  | 2021-08-12 00:00:00 |  | NA | 2021-04-01 00:00:00
 | Employee 3 |  |  |  | NA |  | NA |  | NA |  | 2020-05-14 00:00:00 | NA
 | Employee 4 |  |  |  | 2019-11-11 00:00:00 |  | 2022-04-24 00:00:00 |  | 2023-08-20 00:00:00 |  | 2022-10-10 00:00:00 | 2022-02-07 00:00:00
Spreadsheet: 730096d1619543726-formula-help-for-certain-criteria-kopie-van-book2
Sheet: Sheet1

 |  |  |  |  | Goal of the sheet
Serial Numbers | Type 1 | Type 2 |  |  | Serial Numbers | Type 1 | Type 2
1234A00123 |  |  |  |  | 1234A00123 | 1234A00123
2345B00123 |  |  |  |  | 2345B00123 | 2345B00123
123AB12345 |  |  |  |  | 123AB12345 |  | 123AB12345
X95WX12345 |  |  |  |  | X95WX12345 |  | X95WX12345
5678C00123 |  |  |  |  | 5678C00123 | 5678C00123
Spreadsheet: 88405d1288225851-nested-if-statement-book3
Sheet: Sheet2

Employee list
Name | Employee  Number | Flat rate -  meal allowance | Pay class
 |  |  | Level | Step
[NAME] | 1234 | 5 | 5 | 1
[NAME] | 5678 | 5 | 4 | 5
[NAME] | 1112 | 5 | 3 | 2
[NAME] | 1213 | 5 | 5 | 2
[NAME]
Level | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65
2 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75
3 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85
4 | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95
5 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100 | 105
Date Hired
Name | Employee  Number | Date Hired
[NAME] | 1234 | 2005-03-01 00:00:00
[NAME] | 5678 | 2001-06-16 00:00:00
[NAME] | 1112 | 2000-12-31 00:00:00
[NAME] | 1213 | 2005-03-15 00:00:00
Spreadsheet: 152341d1335358211-pivot-table-grand-total-row-grand-total-column
Sheet: Sheet4

Date | [NAME] | Value
2012-04-20 00:00:00 | A | 0
2012-04-20 00:00:00 | B | 154
2012-04-20 00:00:00 | C | 62
2012-04-20 00:00:00 | D | 102
2012-04-20 00:00:00 | E | 240
2012-04-20 00:00:00 | F | 80
2012-04-20 00:00:00 | G | 398
2012-04-20 00:00:00 | H | 11
2012-04-20 00:00:00 | I | 101
2012-04-20 00:00:00 | J | 1
2012-04-20 00:00:00 | K | 823
2012-04-20 00:00:00 | L | 5
2012-04-20 00:00:00 | M | 0
2012-04-20 00:00:00 | N | 1350
2012-04-21 00:00:00 | A | 137
2012-04-21 00:00:00 | B | 317
2012-04-21 00:00:00 | C | 10
2012-04-21 00:00:00 | D | 1107
2012-04-21 00:00:00 | E | 960
2012-04-21 00:00:00 | F | 890
2012-04-21 00:00:00 | G | 909
2012-04-21 00:00:00 | H | 467
2012-04-21 00:00:00 | I | 884
2012-04-21 00:00:00 | J | 341
2012-04-21 00:00:00 | K | 231
2012-04-21 00:00:00 | L | 0
2012-04-21 00:00:00 | M | 20
2012-04-21 00:00:00 | N | 0
2012-04-22 00:00:00 | A | 390
2012-04-22 00:00:00 | B | 267
2012-04-22 00:00:00 | C | 1100
2012-04-22 00:00:00 | D | 1122
2012-04-22 00:00:00 | E | 0
2012-04-22 00:00:00 | F | 1817
2012-04-22 00:00:00 | G | 499
2012-04-22 00:00:00 | H | 298
2012-04-22 00:00:00 | I | 364
2012-04-22 00:00:00 | J | 454
2012-04-22 00:00:00 | K | 504
2012-04-22 00:00:00 | L | 0
2012-04-22 00:00:00 | M | 0
2012-04-22 00:00:00 | N | 0
Spreadsheet: 789108d1658914470-dynamic-formula-for-standard-deviation-offset-volatility-formula
Sheet: Sheet1

 | B1 | Date | Monthly return
 | B2 | 2021-03-31 00:00:00 | 0.01 |  | Start date | 2021-03-31 00:00:00
 | B3 |  | 0.02 |  | End Date | 2022-06-30 00:00:00
 | B4 |  | -0.01 |  | Months
 | B5 |  | 0.01 |  | Annualised Volatility
 | B6 |  | -0.02
 | B7 |  | 0.025
 | B8 |  | 0.005
 | B9 |  | -0.04
 | B10 |  | 0.021
 | B11 |  | 0.035
 | B12 |  | -0.01
 | B13 |  | 0.005
 | B14 |  | 0.013
 | B15 |  | -0.01
 | B16 |  | 0.03
 | B17 |  | 0.02
Spreadsheet: 578937d1529582006-issue-translating-table-data-to-column-format-with-firm-year-datapoint-excel-forum-patent-dummy-sheet
Sheet: Sheet1

Firm |  | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017
Eli Lill |  | 0.08823529411764706 | 0.2195121951219512 | 0.2222222222222222 | 0.2765957446808511 | 0.32 | 0.3272727272727273 | 0.375 | 0.4426229508196721 | 0.421875 | 0.46875 | 0.4461538461538462 | 0.4328358208955224 | 0.4189189189189189 | 0.358974358974359 | 0.3292682926829268
[NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0.08333333333333333 | 0.1578947368421053 | 0.2368421052631579 | 0.2195121951219512 | 0.2173913043478261 | 0.5106382978723404
Genentec |  | 0.28125 | 0.2424242424242424 | 0.3055555555555556 | 0.425 | 0.4761904761904762 | 0.4761904761904762 | 0.4761904761904762 | 0.3720930232558139 | 0.3617021276595745 | 0.3269230769230769 | 0.2678571428571428 | 0.2333333333333333 | 0.1940298507462687 | 0.1594202898550725 | 0.1571428571428571
[NAME] Ph |  | 0.1739130434782609 | 0.1739130434782609 | 0.2692307692307692 | 0.4814814814814815 | 0.4516129032258064 | 0.375 | 0.4444444444444444 | 0.4102564102564102 | 0.3902439024390244 | 0.3902439024390244 | 0.2558139534883721 | 0.3111111111111111 | 0.2765957446808511 | 0.2708333333333333 | 0.3265306122448979
Merck Sh |  | 0.2888888888888889 | 0.3229166666666667 | 0.3267326732673267 | 0.3584905660377358 | 0.3675213675213675 | 0.3583333333333333 | 0.4333333333333333 | 0.3223140495867768 | 0.3064516129032258 | 0.3178294573643411 | 0.2556390977443609 | 0.2888888888888889 | 0.2592592592592592 | 0.1882352941176471 | 0.1781609195402299
GlaxoSmi |  | 0.2923076923076923 | 0.28 | 0.4358974358974359 | 0.5256410256410257 | 0.5365853658536586 | 0.46 | 0.4336283185840708 | 0.3129251700680272 | 0.2833333333333333 | 0.1697247706422018 | 0.1244635193133047 | 0.1219512195121951 | 0.1622641509433962 | 0.1884057971014493 | 0.277027027027027
Pharmaci |  | 0.2598425196850394 | 0.291044776119403 | 0.2985074626865671 | 0.3111111111111111 | 0.2740740740740741 | 0.325925925925926 | 0.3185185185185185 | 0.1925925925925926 | 0.1911764705882353 | 0.1605839416058394 | 0.1532846715328467 | 0.1214285714285714 | 0.06578947368421052 | 0.06451612903225806 | 0.05
[NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0.125 | 0.0625 | 0.0625 | 0.0625 | 0.0625 | 0.125
Spreadsheet: danny_mccarty__4635__Exhibit 7 - 2001- MKM
Sheet: September 2001

 | NORTHERN NATURAL GAS COMPANY |  |  |  | Privileged and Confidential.  Prepared for
 | System Levelized Account |  |  |  | Settlement purposes only.
 | September 2001
 |  |  |  |  |  |  |  |  |  |  | SLA Account
 |  |  |  |  |  |  |  |  |  |  | Total |  | Cash Portion - |  | Future
 |  | Operational |  |  |  |  |  |  |  |  |  |  | Cash Out/ |  | Liability
 |  | Storage |  | SLA Calculation |  |  |  |  |  |  |  |  | (Cash In)
 |  | [NAME] | Volume | Dollar | Dollar |  |  |  | Net |  | SLA Impact |  | Col (e)*-1 |  | Col (d)*(g)
Line |  | (Over)/Under | Valued | Valued | Amount | Cost |  | Monthly | Cost |  | Increase/
No. | Type of Volume | 14 Bcf | [NAME] | [NAME] | (Cash Out)/ | Per Mcf |  | MIP | Per Mcf |  | (Decrease)
 |  | Col (c)+(d) |  |  | Cash In | Col (e)/(d) |  |  | Col (g)-(f) |  | Col (d)*(h)
 | Column (a) | (b) | (c) | (d) | (e) | (f) |  | (g) | (h) |  | (i) |  | (j) |  | (k)
 | September, 2001
1 | 08/01 Balance Per Books: |  | -1494142 | 4846257 | -38909016 |  |  | 2.8522 |  |  |  |  | 38909016 |  | 13822494
2 | Revalue 08/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 2.0535
3 | 09/01 Activity
4 | Dollar Valued Imbalance |  |  | -262890
5 | Imbalance Tiering Gain |  |  |  | 37856
6 | Gas Purchases |  |  | -1500000 | -3378000
7 | Miscellaneous
8 | Net 09/01 Activity |  | 262874
9 | 09/01 Balance Per Books:
 | 1/  Prior Month's MIP
Spreadsheet: 49963d1249388660-linking-if-function-to-other-worksheets-figs-test
Sheet: Automotive

 | 2009
 | Market | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 |  | TOTAL
 | Automotive | 4943 | 374 | 994 | 2212 | 2194 | 249 | 524 | 214 | 1563 | 0 | 0 | 0 |  | 13267
Customer | Market | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 |  | Total
CUST 1 | Automotive | 130 | 282 | 91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 503
CUST 2 | Automotive | 4754 | 56 | 0 | 1332 | 1913 | 122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8177
CUST 3 | Automotive | 0 | 0 | 0 | 0 | 27 | 0 | 78 | 0 | 1330 | 0 | 0 | 0 | 0 | 1435
CUST 4 | Automotive | 59 | -346 | 903 | 249 | 0 | 0 | -50 | 99 | 106 | 0 | 0 | 0 | 0 | 1020
CUST 5 | Automotive | 0 | 0 | 0 | 251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 251
CUST 6 | Automotive | 0 | 382 | 0 | 380 | 254 | 127 | 496 | 115 | 127 | 0 | 0 | 0 | 0 | 1881
Spreadsheet: 34700d06-c5c0-4afe-bd69-30a98a3fc4bf
Sheet: 2 ONDA

SQUAT JUGGERNAUT |  |  |  |  |  |  |  |  | SECONDA ONDA DA 8
Massimale assoluto |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 |  | [NAME] effettivo                       (90% del max assoluto) |  |  |  | [NAME]
 |  |  |  |  |  | % del max effettivo da utilizzare
 | Data |  |  |  |  |  |  |  | [NAME] | serie | ripetizioni
1 SETTIMANA ACCUMULO |  |  |  |  |  | 0.65 |  |  |  | 5 | 8
2 SETTIMANA INTENSIFICAZIONE |  |  |  |  |  | 0.6 |  |  |  | 1 | 3
 |  |  |  |  |  | 0.675 |  |  |  | 1 | 3
 |  |  |  |  |  | 0.725 |  |  |  | 3 | 8
3 SETTIMANA REALIZZAZIONE |  |  |  |  |  | 0.5 |  |  |  | 1 | 5
 |  |  |  |  |  | 0.6 |  |  |  | 1 | 3
 |  |  |  |  |  | 0.7 |  |  |  | 1 | 2
 |  |  |  |  |  | 0.75 |  |  |  | 1 | 1
 |  |  |  |  |  | 0.8 |  |  |  | MAR*
4 SETTIMANA SCARICO |  |  |  |  |  | 0.4 |  |  |  | 1 | 5 |  | Commenti:
 |  |  |  |  |  | 0.5 |  |  |  | 1 | 5
 |  |  |  |  |  | 0.6 |  |  |  | 1 | 5
* MAR =NUMERO MASSIMO ASSOLUTO DI RIPETIZIONI
[NAME] (MAR) di ripetizioni effettuate
[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ver. 1.0
Spreadsheet: 762802d1641828476-using-unique-function-inside-of-countifs-function-countif-example
Sheet: Sheet8

# of Credit Code MA
F1
F2
F3
F4
F6
F9
24
3E
3F
Systems
[NAME]
Spreadsheet: 787790d1658050992-how-to-search-target-data-with-multiple-data-sample-data-lookup-serial-number-with-do-number
Sheet: SN History

Reff No | Item No. | Serial/Batch Number | Qty Out
22-0042 | [NAME] | 220325-011547 | 1
22-0042 | [NAME] | 220325-011549 | 1
22-0151/1 | S39224JS | S8SS2200088 | 1
22-0153/1 | 2000 | BA329118C00871D | 1
22-0153/1 | 5016000 | SP22030191 | 1
22-0153/1 | DE-400E | DE40EEHHJ003 | 1
22-0153/1 | DE-400E | DE40EEHGD001 | 1
22-0153/1 | DS II M | 220325-031040 | 1
22-0153/1 | DS II M | 220325-031038 | 1
22-0153/1 | DS II M | 220325-031041 | 1
22-0153/1 | DT-300S | DE30SEHHJ006 | 1
22-0153/1 | [NAME] | 220325-011545 | 1
22-0153/1 | PAX2C | 220330-011550 | 1
22-0156/1 | DS II M | 220325-031042 | 1
22-0156/1 | [NAME] | 220325-011548 | 1
22-0282 | 5016000 | SP22030190 | 1
22-0283 | DS II M | 220613-031053 | 1
22-0283 | OF001 | 220607-131375 | 1
22-0283 | [NAME] | 220621-011590 | 1
22-0367/3 | B76242DA | CBDGG2200092HM | 1
22-0405 | 860292 | US52210770 | 1
22-0405 | 860322 | US21959469 | 1
22-0405 | 989803157511 | US11912978 | 1
22-0405 | M4612A | [PHONE] | 1
22-0405 | M4612A | [PHONE] | 1
22-0413/1 | 1700001 | TDUO0937 | 1
22-0457 | CT1082B | 1216Y2202779 | 1
22-0457 | H4000SR | 1114053WX0 | 1
22-0457 | H40402LY | 1099818WX5 | 1
22-0457 | H48302BA | 6052331WX0 | 1
Spreadsheet: 716061d1612005537-google-sheets-trying-to-make-a-matrix-with-1-and-0-based-on-3-different-tabs-in-the-sheet-vh-test-matrix-1-
Sheet: Matrix wanted outcome example

 |  | Customer A | Customer B | Customer C | Customer D | Customer E | Customer F | Customer G | Customer H | Customer I | Customer J
70 | 1003 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
50 | 1003 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
51 | 0101 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0
50 | 1600 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0
50 | 0474 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0
50 | 2828 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
50 | 1328 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0
50 | 2825 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0
20 | 5068 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
20 | 5020 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
20 | 5010 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 123691d1317810932-subsidiaries-or-not-copy-of-example-1-
Sheet: Sheet1

Firm_id | UK | US | Aruba | Tanzania | Morocco | Firm investment in country without Smoking Ban Legislation |  |  | Country | No Smoking Legislation
1 | 3 | 4 | 0 | 1 | 0 |  |  |  | UK | 0
2 | 0 | 0 | 1 | 0 | 1 |  |  |  | US | 0
3 | 0 | 0 | 0 | 0 | 0 |  |  |  | Aruba | 1
4 | 1 | 0 | 0 | 0 | 0 |  |  |  | Tanzania | 1
5 | 25 | 13 | 1 | 0 | 0 |  |  |  | Morocco | 1
helper
Spreadsheet: 100408d1298787229-excel-2007-find-exact-duplicate-of-column-1-with-column-2-and-3-and-custom-text-messege-help-sample_123-bvj-
Sheet: Sheet1

Phone 1 | Phone 2 | Phone 3 |  | Custom formula needed I | Custom formula needed II
6468782470 | 9704198223 | 2129160996
6468957652 | 9704245007 | 2129160998
6469128463 | 9704292681 | 2129162000
6469203744 | 9704344685 | 2129162001
6469243681 | 9704344743 | 2129162940
6469243956 | 9704494121 | 2129183000
6469432172 | 9704494301 | 2129183024
6469636808 | 9704494302 | 6468782470
6469646667 | 9704530192 | 2129183026
6469649625 | 6469203744 | 2129183028
6469887531 | 9704532326 | 2129183029
 | 9704532734 | 2129183048
 | 9704532901 | 2129183084
 | 9704533165 | 2129183087
 | 9704534330 | 6469243956
 | 9704534580 | 2129183203
 | 9704534753 | 2129183262
 | 6469243956