tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884634d1733857477-calculating-what-fiscal-years-expenses-will-hit-in-fy-expense
Sheet: Sheet2

 |  | Cur FY | 2024-07-01 00:00:00 | 2025-06-30 00:00:00
 |  | FY25
 | Start Date | End Date | Amount | Contract # of months | Cur Year Mos Left | Avg Cost | Cur Year Cost | FY26 Cost | FY27 Cost
Project A | 2024-07-01 00:00:00 | 2025-06-30 00:00:00 | 120000
Project B | 2025-01-01 00:00:00 | 2026-03-31 00:00:00 | 150000
Project C | 2024-07-01 00:00:00 | 2027-06-30 00:00:00 | 360000
Project D | 2023-08-01 00:00:00 | 2026-06-30 00:00:00 | 350000
 |  |  |  |  |  |  | should be 120K
Spreadsheet: 171979d1343936208-formula-that-combines-text-cells-into-single-cell-paragraph-bga10s
Sheet: Company2

COMPANY NAME: | Company2
REVIEWER: | Brooke
OVERALL SCORE |  | POSSIBLE CUTS | INSTRUCTIONS
Work-Life Balance | High | Work-Life Balance | Enter values into these fields.
Development, Recognition and Feedback | High | Young Workers | Choose from these drop-downs.
Communication and Leadership | High |  | These fields will populate.
Workplace Culture/Perks | High
Benefits | High
LIST DATA | RANK | EE SATISFACTION
Forbes 100 Best Companies | -
GlassDoor Top Companies | - | -
GlassDoor Career Opportunities | - | -
GlassDoor Work-Life Balance | - | -
Work-Life Balance |  | Development, Recognition and Feedback
Tele-commuting (work from home) | Tele-commuting (work from home) | High pay | High pay
Paid vacation | Paid vacation | Bonus and incentive program | Bonus and incentive program
Flexible Hours | Flexible Hours | Study assistance | Study assistance
Paid holidays | Paid holidays | Mentorship programs | Mentorship programs
Employee Childcare | Employee Childcare | Benchmarking | Benchmarking
Subsidized Montessori care | Subsidized Montessori care | Professional development | Professional development
Maternity Leave | Maternity Leave
Other | LifeWorks Limited Concierge Service (to locate trainer, lawn mower, tutor, pet-sitter, car dealership, etc.)
Other | Employee Assistance Program
Other | Eldercare resource program
Other | Adoption Assistance
Other | Future Leave
SCORE: | High | SCORE: | High
Communication and Leadership |  | Workplace Culture/Perks
Open door leadership | Open door leadership | Onsite gym/gym discounts | Onsite gym/gym discounts
Electronic newsletters | Electronic newsletters | Company-specific perks | Company-specific perks
CEO Updates | CEO Updates | Other | Flexible spending accounts
 |  | Other | Accenture Perks and Discount Directory
 |  | Other | 401(k) Match and Savings Program
SCORE: | High | SCORE: | High
Benefits
100% Health Care Coverage | 100% Health Care Coverage
Medical benefits | Medical benefits
Life/Disability Insurance | Life/Disability Insurance
Employee wellness programs | Employee wellness programs
[NAME] | [NAME]
SCORE: | High
Spreadsheet: 6ac539d4-e9d8-488b-9882-d634372e8707
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
FOXYC | Test | FOXYC | Oxycodone (Percodan), Urine-Forensic | Oxycodone, [NAME] | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | [NAME], sterile container: SrwStlCont |  |  | 10 | mL | Collect 20 mL random urine.    Note:   Submission of the minimum volume results in an elevated                reporting limit and inability to repeat analysis. | 10 mL | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Oxycodone, [NAME]:   Oxycodone         ng/mL Oxymorphone    ng/mL   Reference ranges have not been established for urine specimens.   This specimen was handled by Medtox Laboratories as a forensic specimen under chain of custody protocol.   Test Performed By:  Medtox Laboratories                                        402 W. County Road D                                         St. Paul, MN  55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FOXYC | Result | Z1212 | Oxycodone | Oxycodone | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FOXYC | Result | Z1071 | Oxymorphone | Oxymorphone | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 838737d1691329910-finding-matches-across-columns-and-writing-corresponding-ids-find_and_write_id-1-
Sheet: Sheet

ID | NAME | Used_Method | Second_Used_Method |  |  | SUMMARY
ID_1 | Title_1 | Method A | Method B |  |  |  | Which article/s  includes the following method?
ID_2 | Title_2 | Method A | Method C |  |  |  |  | Title_2 | Title_3 | Title_4 | Title_5 | Title_6
ID_3 | Title_3 | Method A |  |  |  | Method B |  | Title_4
ID_4 | Title_4 | Method A | Method B |  |  | Method C
ID_5 | Title_5 | Method A |  |  |  | Method D
ID_6 | Title_6 | Method A | Method D
Spreadsheet: 76469d1277025964-if-then-patient-questionnaires
Sheet: Sheet1

Question | Response - 1-4 |  |  | very good | good | fair | needs improving
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
Spreadsheet: 868879d1715606826-count-and-condition-book1
Sheet: book1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 21.5
 | Discount Rate |  |  |  | [%]
 |  |  | Offset
 | Discount Factor |  | 0 |  | [#]
Spreadsheet: 685005d1593664671-juxtaposing-successive-levels-from-parent-child-relational-data-relational-data
Sheet: Relataional data

Raw data table: IDs are generated as serial numbers without regard to what types of levels they are generated for. There may be gaps in the serial numbers, there may be duplicates and they may be listed in no particluar order etc. IDs and ParentTypes may be numbers stored as text. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Results table: Table is dynamic as new parents arrive and existing parents (Level1) begets more children (Level2) and grand children (Level3). Data is therefore continuously expanded downwards in the table, from all levels. The table must automatically be sorted by Level1, then Level2 and then Level3.
ID children | ID parents | Level1 ParentTypes | Level2 & Level3 ParentTypes |  |  | L1 | L2 | L3 |  | Only L1 | Only 1-2 | Full 3Ls |  | R | R1 | R2 | R3 |  |  | R | Row | Sorted ID children for Level1_ParentType1, Level1_ParentType2 & Level1_ParentType3 | Sorted ID children for Level2_ParentType4 | Sorted ID children for Level3_ParentType5 |  | Sorted ID children for Level1_ParentType1, Level1_ParentType2 & Level1_ParentType3 | Sorted ID children for Level2_ParentType4 | Sorted ID children for Level3_ParentType5
1000 |  | Level1_ParentType1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 1006 | 1013
1001 |  | Level1_ParentType1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 1006 | 1014
1002 |  | Level1_ParentType2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 1006 | 1015
1003 |  | Level1_ParentType2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 1007 | 1016
1004 |  | Level1_ParentType3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 1007 | 1017
1005 |  | Level1_ParentType3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 1008 | 1018
1006 | 1000 |  | Level2_ParentType4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 1009 | 1019
1007 | 1000 |  | Level2_ParentType4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 1009 | 1020
1008 | 1001 |  | Level2_ParentType4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1002 | 1010
1009 | 1001 |  | Level2_ParentType4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1002 | 1011
1010 | 1002 |  | Level2_ParentType4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1003 | 1012 | 1021
1011 | 1002 |  | Level2_ParentType4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1004
1012 | 1003 |  | Level2_ParentType4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1005
1013 | 1006 |  | Level3_ParentType5
1014 | 1006 |  | Level3_ParentType5
1015 | 1006 |  | Level3_ParentType5
1016 | 1007 |  | Level3_ParentType5
1017 | 1007 |  | Level3_ParentType5
1018 | 1008 |  | Level3_ParentType5
1019 | 1009 |  | Level3_ParentType5
1020 | 1009 |  | Level3_ParentType5
1021 | 1012 |  | Level3_ParentType5
Spreadsheet: lindy_donoho__22113__2002 Summary for Presentation_Rev
Sheet: By Risk Category

NORTHERN NATURAL GAS COMPANY
Commercial Group
2002 Plan
Contracted, Uncontracted, [NAME]
Millions of Dollars
 | Contracted |  |  |  | Uncontracted |  |  |  | Stretch |  |  |  | Total
Team | Demand | Commodity | Total |  | Demand | Commodity | Total |  | Demand | Commodity | Total |  | Demand | Commodity | Total
North | 155.9 | 9.5 |  |  | 2.4 | 0.6 |  |  | 0.3 | 0.1
Central | 162.2 | 14.4 |  |  | 6.8 | 1.3 |  |  | 1.2 | 0
NNG Business Development - North | 0.3 | 0.2 |  |  | 0.3 |  |  |  | 0.5
UNIDENTIFIED STRETCH |  |  |  |  |  |  |  |  | 1.4
SLA |  |  |  |  |  |  |  |  | 2.9
ACA/GRI | -0.7
Carlton Expense |  | -0.8
DDVC |  |  |  |  |  |  |  |  |  | 0.8
Total Net Midwest Margin (includes TFF)
NNG Business Development - North | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | moved under Midwest
NNG Business Development - South | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | moved to non-recurring
Offshore | 0 | 0.7 |  |  | 0 | 0 |  |  | 0 | 0
ACA/GRI
Total Net NNG Business Development Margin
Pricing & Structuring | 11.1 | 3 |  |  | 4.6 | 9.2 |  |  | 1.4 | 2
UNIDENTIFIED STRETCH |  |  |  |  |  |  |  |  | 2.5
Structured Products / Hedge Activity
ACA/GRI
Carlton Expense |  | -0.1
Total Net Pricing & Structuring Margin
Storage | 22.1 | 0 |  |  |  |  |  |  | 0 | 2.6
UNIDENTIFIED STRETCH | 0 | 0 |  |  | 0 | 0 |  |  |  | 2.5
Total Net Storage Margin
Executive
Executive Stretch & Disc. Capital |  |  |  |  |  |  |  |  |  | 0.1
Speculative Income (Other Income)
Tenaska Consulting (Other Income)
Strangers Gas (Other Revenue)
Net Fuel/UAF (Expense)
Other (Other Revenue)
Reserves
Other (GL vs. [NAME])
Total Executive
TOTAL MARGIN
NNG Business Development - Asset Sales
Executive Stretch
 |  |  |  |  |  | Tranche One |  |  |  |  |  |  |  |  | Tranche One
 |  |  |  |  |  | Tranche Two |  |  |  |  |  |  |  |  | Tranche Two
 |  |  |  |  |  | Tranche Three |  |  |  |  |  |  |  |  | Tranche Three
 |  |  |  |  |  | SP |  |  |  |  |  |  |  |  | SP
Spreadsheet: 114944d1310603920-vlookup-in-two-or-more-columns-sample
Sheet: Sheet1

SKU | BarCode | Description | store Cost | Retail Price
A12345 | 4011K00005 | Product A | 33 | 63
AA2255 | 40W3850005 | Product B | 24 | 54
BSE3548 | 40U7400005 | Produc C | 22 | 52
ASS55887 | [PHONE] | Product D | 34 | 64
Spreadsheet: d2ac0916-0bc1-4e8f-a794-064c32e5b2a5
Sheet: Sheet1

STATE REPRESENTATIVES - BELKNAP COUNTY  --  DEMOCRATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
District No. 1 (1) | Gulick, d | Simpson, r
Center Harbor | 42 | 1
New Hampton | 108 | 5
TOTALS | 150 | 6
District No. 2 (2) | Merry, d | Dawson, d | Fields, r | Tobin, r
Sanbornton | 189 | 63 | 7 | 13
[NAME] | 120 | 69 | - | -
TOTALS | 309 | 132 | 7 | 13
District No. 3 (2) | Miller, d | Horne, d | Worsman, d | [NAME]
Meredith | 169 | 197 | 4 | 2
District No. 4 (5) | Arsenault, d | Baxley, d | Laughton, d | Stamps, d | Stuart, d | Allard, r | [NAME], r | Accornero, r
[NAME] | 72 | 55 | 29 | 64 | 67 | 57 | 1 | 1
[NAME] | 77 | 55 | 23 | 59 | 71 | 57 | 1 | 1
[NAME] 3 | 87 | 48 | 21 | 81 | 83 | 67 | - | -
[NAME] | 75 | 43 | 39 | 54 | 63 | 51 | - | -
[NAME] | 59 | 33 | 15 | 34 | 40 | 37 | 1 | 1
[NAME] 6 | 76 | 51 | 37 | 61 | 68 | 58 | - | 1
TOTALS | 446 | 285 | 164 | 353 | 392 | 327 | 3 | 4
District No. 5 (7) | Condodem-etraky, d | [NAME], d | [NAME], d | Morin, d | Andersen, d | Bourbeau, d | [NAME], d | Bolster, r
Alton | 79 | 96 | 91 | 85 | 81 | 86 | 79 | 3
Barnstead | 77 | 91 | 87 | 79 | 83 | 77 | 82 | -
Belmont | 79 | 101 | 92 | 105 | 83 | 85 | 83 | -
Gilford | 151 | 199 | 154 | 176 | 147 | 143 | 163 | 1
TOTALS | 386 | 487 | 424 | 445 | 394 | 391 | 407 | 4
District No. 6 (1) | Chase, d | Bickford, r | [NAME]
Gilmanton | 100 | 1 | 5
Spreadsheet: 889998d1741105731-excel-formula-for-sales-incentive-hierarchy-level-sum-target-allocation-updated-with-expected-result
Sheet: CALC

 |  |  | July'24 | Aug'24 | Sept'24 | Q2 FY25
Sno. | E ECN | Employee Name | Target | Target | Target | Total
1 | 10903822 | Aishwarya Prachi
2 | 10903824 | [NAME]
3 | 10903665 | Dibyendu Rabindranath Pal
4 | 10903548 | Divyank Hitesh Udani
5 | 10903719 | Krunal Chetan Rupani
6 | 10903545 | [NAME]
7 | 10903857 | [NAME]
8 | 10903832 | [NAME]
9 | 10903616 | [NAME]
10 | 10903817 | [NAME]
11 | 10903620 | [NAME]
12 | 10903526 | Kailash Anand Shinde
13 | 3256625 | Ketan Prakash Netawate
14 | 3455918 | Meha Samit Shah
15 | 10903794 | Chirag Kishor Limbad
16 | 10903316 | Prajeshlal Prakashan Podikalamparambil
17 | 10903610 | Akbarali [NAME]
18 | 10903821 | [NAME]
19 | 10903829 | Dimple Kamlesh Desai
20 | 10903561 | Siddhant Chandrakant Naik
21 | 3305957 | [NAME]
22 | 3212442 | [NAME]
23 | 10903833 | [NAME] [NAME]
24 | 10903429 | Vikas Ratan Sharma
25 | 10903404 | [NAME]
26 | 10903463 | Suman [NAME]
27 | 10903830 | Meghna Adhikary
28 | 10903650 | [NAME] Amandeep [NAME]
29 | 10903639 | Sumeet Ramesh Kotwani
30 | 10903549 | [NAME] Faheem Qadri
31 | 10903334 | [NAME]
260 | 10903203 | [NAME]
261 | 10903539 | [NAME]
Spreadsheet: 377700d1424124489-deleting-rows-between-pages-excelforumdeleterowsbetweenpages-2015-02-16-17-04
Sheet: Sheet1

ExcelForumDeleteRowsBetweenPages.xls
Reference: | http://www.excelforum.com/excel-general/1066614-deleting-rows-between-pages.html
This is page content on row 7. |  |  |  |  |  | xxx
This is page content on row 8. |  |  |  |  |  | xxx
This is page content on row 9. |  |  |  |  |  | xxx
This is page content on row 10. |  |  |  |  |  | xxx
This is page content on row 11. |  |  |  |  |  | xxx
This is page content on row 12. |  |  |  |  |  | xxx
Page 3 |  |  |  | Page 3
This is page content on row 16. |  |  |  |  |  | xxx
This is page content on row 17. |  |  |  |  |  | xxx
This is page content on row 18. |  |  |  |  |  | xxx
This is page content on row 19. |  |  |  |  |  | xxx
This is page content on row 20. |  |  |  |  |  | xxx
This is page content on row 21. |  |  |  |  |  | xxx
This is page content on row 22. |  |  |  |  |  | xxx
This is page content on row 23. |  |  |  |  |  | xxx
This is page content on row 24. |  |  |  |  |  | xxx
Page 4 |  |  |  | Page 4
This is page content on row 28. |  |  |  |  |  | xxx
This is page content on row 29. |  |  |  |  |  | xxx
This is page content on row 30. |  |  |  |  |  | xxx
This is page content on row 31. |  |  |  |  |  | xxx
This is page content on row 32. |  |  |  |  |  | xxx
This is page content on row 33. |  |  |  |  |  | xxx
This is page content on row 34. |  |  |  |  |  | xxx
This is page content on row 35. |  |  |  |  |  | xxx
This is page content on row 36. |  |  |  |  |  | xxx
Page 5 |  |  |  | Page 5
This is page content on row 40. |  |  |  |  |  | xxx
This is page content on row 41. |  |  |  |  |  | xxx
This is page content on row 42. |  |  |  |  |  | xxx
This is page content on row 43. |  |  |  |  |  | xxx
This is page content on row 44. |  |  |  |  |  | xxx
This is page content on row 45. |  |  |  |  |  | xxx
This is page content on row 46. |  |  |  |  |  | xxx
This is page content on row 47. |  |  |  |  |  | xxx
This is page content on row 48. |  |  |  |  |  | xxx
Page 6 |  |  |  | Page 6
Spreadsheet: 793065d1661279938-get-all-values-and-append-from-desired-tables-append-all-values-from-1-field-of-dynamic-table-name
Sheet: Sheet1

Data Validation |  |  | First Name Table |  |  |  |  | Last Name Table
 |  |  | ID | Name | [NAME] |  |  | ID | Name | [NAME]
First Name Table |  |  | 1 | [NAME] |  |  |  | 1 | Doe
Last Name Table |  |  | 2 | [NAME] | [EMAIL] |  |  | 2 | Smith | [EMAIL]
 |  |  | 3 | [NAME] | [EMAIL] |  |  | 3 | [NAME] | [EMAIL]
 |  |  | 4 | [NAME] | [EMAIL] |  |  | 4 | [NAME] | [EMAIL]
 |  |  | 5 | [NAME] | [EMAIL] |  |  | 5 | [NAME] | [EMAIL]
 |  |  |  |  |  |  |  | 6 | Jones
 |  |  | tblFirst |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  |  | tblLast
 |  |  | All |  |  |  |  | Name
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | Doe |  | Desired result |  |  | Doe
 |  |  | Smith |  | Append [Name] from all tables |  |  | Smith
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | Jones |  |  |  |  | Jones
 |  |  | [NAME] |  |  |  |  | [NAME]
Spreadsheet: 5b2235fe-823f-4f54-bb71-9f8660ad3ebc
Sheet: Q3

Johnson & Johnson and Subsidiaries
Condensed Consolidated Statement of Earnings
(Unaudited; in Millions Except Per Share Figures) | THIRD QUARTER
 | 2011 |  |  |  | 2010 |  |  |  | Percent
 |  |  | Percent |  |  |  | Percent |  | Increase
 | Amount |  | to Sales |  | Amount |  | to Sales |  | (Decrease)
Sales to customers | 16005 |  | 100 |  | 14982 |  | 100 |  | 6.828193832599119
Cost of products sold | 5072 |  | 31.69009684473602 |  | 4594 |  | 30.66346282205313 |  | 10.40487592511972
Selling, marketing and administrative expenses | 5240 |  | 32.73976882224305 |  | 4709 |  | 31.43105059404619 |  | 11.27627946485453
Research and development expense | 1773 |  | 11.07778819119025 |  | 1657 |  | 11.05993859297824 |  | 7.00060350030175
Interest (income)expense, net | 117 |  | 0.7310215557638238 |  | 95 |  | 0.6340942464290481
Other (income)expense, net | -308 |  | -1.924398625429553 |  | -292 |  | -1.959005473234548
Earnings before provision for taxes on income | 4111 |  | 25.67572321149641 |  | 4219 |  | 28.15045921772794 |  | -2.559848305285613
Provision for taxes on income | 909 |  | 5.679475164011246 |  | 802 |  | 5.353090375116807 |  | 13.34164588528678
Net earnings | 3202 |  | 20.00624804748516 |  | 3417 |  | 22.80736884261113 |  | -6.292069066432543
Net earnings per share  (Diluted) | 1.15 |  |  |  | 1.23 |  |  |  | -6.504065040650413
Average shares outstanding  (Diluted) | 2778.2 |  |  |  | 2786.4
Effective tax rate | 22.11140841644369 | % |  |  | 19.00924389665798 | %
Adjusted earnings before provision for taxes and net earnings
Earnings before provision for taxes on income | 4427 | (1) | 27.66010621680725 |  | 4219 |  | 28.16045921772794 |  | 4.930078217587107
Net earnings | 3443 | (1) | 21.51202749140894 |  | 3417 |  | 22.80736884261113 |  | 0.7609013754755634
Net earnings per share  (Diluted) | 1.24 | (1) |  |  | 1.23 |  |  |  | 0.8130081300813016
Effective tax rate | 0.2222724192455387 |  |  |  | 0.1900924389665798
(1) The $316 million difference between as reported earnings and as adjusted earnings before provision for taxes on income is the exclusion of a mark-to-market adjustment associated with a currency option and deal costs related to the planned acquisition of Synthes.  Net earnings and net earnings per share (diluted) on these items are $241 million and $0.09 per share, respectively.
Spreadsheet: benjamin_rogers__931__Northeast Historical Pricing
Sheet: Spreads

On Peak Pricing |  |  |  |  |  | On Peak Pricing
 | A-West | G-West | J-West | East-West |  |  | A-East | G-East | J-East | West-East
2000-01-01 00:00:00
2000-02-01 00:00:00
2000-03-01 00:00:00 |  |  |  |  |  | 2000-03-01 00:00:00
2000-04-01 00:00:00 |  |  |  |  |  | 2000-04-01 00:00:00
2000-05-01 00:00:00 |  |  |  |  |  | 2000-05-01 00:00:00
2000-06-01 00:00:00 |  |  |  |  |  | 2000-06-01 00:00:00
2000-07-01 00:00:00 |  |  |  |  |  | 2000-07-01 00:00:00
2000-08-01 00:00:00 |  |  |  |  |  | 2000-08-01 00:00:00
2000-09-01 00:00:00 |  |  |  |  |  | 2000-09-01 00:00:00
2000-10-01 00:00:00 |  |  |  |  |  | 2000-10-01 00:00:00
2000-11-01 00:00:00 |  |  |  |  |  | 2000-11-01 00:00:00
2000-12-01 00:00:00 |  |  |  |  |  | 2000-12-01 00:00:00
2001-01-01 00:00:00 |  |  |  |  |  | 2001-01-01 00:00:00
2001-02-01 00:00:00 |  |  |  |  |  | 2001-02-01 00:00:00
2001-03-01 00:00:00 |  |  |  |  |  | 2001-03-01 00:00:00
2001-04-01 00:00:00 |  |  |  |  |  | 2001-04-01 00:00:00
2001-05-01 00:00:00 |  |  |  |  |  | 2001-05-01 00:00:00
2001-06-01 00:00:00 |  |  |  |  |  | 2001-06-01 00:00:00
2001-07-01 00:00:00 |  |  |  |  |  | 2001-07-01 00:00:00
2001-08-01 00:00:00 |  |  |  |  |  | 2001-08-01 00:00:00
2001-09-01 00:00:00 |  |  |  |  |  | 2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
Spreadsheet: john_forney__15513__SCHED2001
Sheet: JULY'01

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | JULY
NAME | 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 | FRI | SAT | SUN | MON | TUE
ERCOT | 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
[NAME] |  |  |  |  | D | D |  |  | D | D |  |  |  | D | D | D | D |  |  |  |  |  | N | N | N |  |  | D | D | D
ALEX McELREATH |  | D | D | D |  |  | N | N |  |  | D | D | D |  |  |  | N | N |  |  | N | N |  |  |  | D | D |  |  |  | D
JOHN FORNEY |  | D | D |  | D | D |  |  | D | D | D | D | V |  |  | V | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D
[NAME] | D |  |  |  | N | N | N | N |  |  |  |  |  | N | N | N |  |  |  |  | D | D |  |  |  | N | N | N | N
CHRIS WATTS |  |  | N | N |  |  | D | D |  |  |  | N | N | V | V
[NAME] | N | N |  | D |  |  |  |  | N | N | N |  |  |  |  |  |  | N | N | N |  |  | D | D | D |  |  |  |  | N | N
SOUTHEAST
[NAME] |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D
MIGUEL GARCIA |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D
MAURICIO TREJO | N |  |  |  |  |  | D | D | D | D |  |  |  | N | N | N | N |  |  |  | D | D | D | D |  |  |  |  |  | N | N
[NAME] | N |  |  | N | N | N |  |  |  |  | N | N | N |  |  |  | D | D | D | D |  |  |  | N | N | N |  |  |  | D | D
MIDWEST
[NAME] |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D
J.D.KINSER |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | V
DEAN LAURENT |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | S | DH | D | D | D |  |  | D | D | D | D | D |  |  | D | D
DUSTIN COLLINS |  | N | N | N |  |  | N | N | N |  |  |  |  | D | D | D | D |  |  |  |  |  |  | N | N | N |  | D | D
JUAN PADRON | D | D | D |  |  |  | D | D |  |  |  | D | D |  |  |  |  |  |  |  | N | N | N |  |  | D | D | D | D
ANDREW GREER | D |  |  |  |  |  | D | D |  | N | N | N |  | D | D |  |  | N | N | N |  |  | D | D |  |  | N | N | N
NORTHEAST
NIGHTS
DAYS
Spreadsheet: 871900d1718289812-highlight-next-odd-number-months-in-range-dates
Sheet: Sheet1

 | DATES
 | 2024-06-02 00:00:00