{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["P&L","Balance Sheet","Cash Flow","Net Income & EPS Non-GAAP","Segment Results","Core Revenue by Segment (QTD)"],"not_rendered":{"defined_names":25},"read":"whole","date_system":"1900"}

{"sheet":"P&L","index":0,"n_rows":51,"n_cols":8,"rows_kept":51,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[7,1,7,3],[7,5,7,7],[8,1,8,3],[8,5,8,7],[47,0,47,7],[50,0,50,7],[53,0,53,5]]}
["AGILENT TECHNOLOGIES, INC."]
["CONDENSED CONSOLIDATED STATEMENT OF OPERATIONS"]
["(In millions, except per share amounts)"]
["(Unaudited)"]
["PRELIMINARY"]
[]
[]
[null,"Three Months Ended",{"$nulls":3},"Six Months Ended"]
[null,"April 30,",{"$nulls":3},"April 30,"]
[null,2022,null,2021,null,2022,null,2021]
[]
["Net revenue",{"v":1607,"d":"$1,607"},null,{"v":1525,"d":"$1,525"},null,{"v":3281,"d":"$3,281"},null,{"v":3073,"d":"$3,073"}]
[]
["Costs and expenses:"]
["Cost of products and services",746,null,708,null,{"v":1510,"d":"1,510"},null,{"v":1418,"d":"1,418"}]
["Research and development",115,null,109,null,232,null,212]
["Selling, general and administrative",386,null,420,null,803,null,827]
["Total costs and expenses",{"$f":"SUM(B15:B17)","v":{"v":1247,"d":"1,247"}},null,{"$f":"SUM(D15:D17)","v":{"v":1237,"d":"1,237"}},null,{"$f":"SUM(F15:F17)","v":{"v":2545,"d":"2,545"}},null,{"$f":"SUM(H15:H17)","v":{"v":2457,"d":"2,457"}}]
[]
["Income from operations",{"$f":"B12-B18","v":360},null,{"$f":"D12-D18","v":288},null,{"$f":"F12-F18","v":736},null,{"$f":"H12-H18","v":616}]
[]
["Interest income",1,null,1,null,2,null,1]
["Interest expense",{"v":-21,"d":"(21)"},null,{"v":-20,"d":"(20)"},null,{"v":-42,"d":"(42)"},null,{"v":-39,"d":"(39)"}]
["Other income (expense), net",{"v":-7,"d":"(7)"},null,4,null,{"v":-44,"d":"(44)"},null,7]
[]
["Income before taxes",{"$f":"SUM(B20:B24)","v":333},null,{"$f":"SUM(D20:D24)","v":273},null,{"$f":"SUM(F20:F24)","v":652},null,{"$f":"SUM(H20:H24)","v":585}]
[]
["Provision for income taxes",59,null,57,null,95,null,81]
[]
["Net income ",{"$f":"B26-B28","v":{"v":274,"d":"$274"}},null,{"$f":"D26-D28","v":{"v":216,"d":"$216"}},null,{"$f":"F26-F28","v":{"v":557,"d":"$557"}},null,{"$f":"H26-H28","v":{"v":504,"d":"$504"}}]
[]
[]
[]
["Net income per share:"]
["                             Basic",{"$f":"B30/B39","v":{"v":0.9163879598662207,"d":"$0.92"}},null,{"$f":"D30/D39","v":{"v":0.7105263157894737,"d":"$0.71"}},null,{"$f":"F30/F39","v":{"v":1.8566666666666667,"d":"$1.86"}},null,{"$f":"H30/H39","v":{"v":1.6524590163934427,"d":"$1.65"}}]
["                             Diluted",{"$f":"B30/B40","v":{"v":0.9102990033222591,"d":"$0.91"}},null,{"$f":"D30/D40","v":{"v":0.7035830618892508,"d":"$0.70"}},null,{"$f":"F30/F40","v":{"v":1.8443708609271523,"d":"$1.84"}},null,{"$f":"H30/H40","v":{"v":1.6363636363636365,"d":"$1.64"}}]
[]
["Weighted average shares used in computing net income per share:     "]
["                             Basic",299,null,304,null,300,null,305]
["                             Diluted",301,null,307,null,302,null,308]
{"$rows_empty":7}
["The preliminary income statement is estimated based on our current information."]
[]
[]
["Page 1"]

{"sheet":"Balance Sheet","index":1,"n_rows":59,"n_cols":7,"rows_kept":59,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[58,0,58,6]]}
["AGILENT TECHNOLOGIES, INC."]
["CONDENSED CONSOLIDATED BALANCE SHEET"]
["(In millions, except par value and share amounts)"]
["(Unaudited)"]
["PRELIMINARY"]
[]
[]
[{"$nulls":4},"April 30,",null,"October 31,"]
[{"$nulls":4},2022,null,2021]
["ASSETS"]
[]
["Current assets:"]
[null,"Cash and cash equivalents",null,null,{"v":1186,"d":"$1,186"},null,{"v":1484,"d":"$1,484"}]
[null,"Short-term investments",null,null,21,null,91]
[null,"Accounts receivable, net",null,null,{"v":1237,"d":"1,237"},null,{"v":1172,"d":"1,172"}]
[null,"Inventory",null,null,937,null,830]
[null,"Other current assets",null,null,262,null,222]
[null,null,"Total current assets",null,{"$f":"SUM(E13:E17)","v":{"v":3643,"d":"3,643"}},null,{"$f":"SUM(G13:G17)","v":{"v":3799,"d":"3,799"}}]
[]
["Property, plant and equipment, net",{"$nulls":3},{"v":1010,"d":"1,010"},null,945]
["Goodwill and other intangible assets, net",{"$nulls":3},{"$f":"3956+898","v":{"v":4854,"d":"4,854"}},null,{"$f":"3975+981","v":{"v":4956,"d":"4,956"}}]
["Long-term investments",{"$nulls":3},190,null,185]
["Other assets",{"$nulls":3},758,null,820]
[null,null,"Total assets",null,{"$f":"SUM(E18:E23)","v":{"v":10455,"d":"$10,455"}},null,{"$f":"SUM(G18:G23)","v":{"v":10705,"d":"$10,705"}}]
[]
["LIABILITIES AND EQUITY"]
[]
["Current liabilities:"]
[null,"Accounts payable",null,null,{"v":503,"d":"$503"},null,{"v":446,"d":"$446"}]
[null,"Employee compensation and benefits",null,null,347,null,493]
[null,"Deferred revenue",null,null,511,null,441]
[null,"Short-term debt",null,null,175,null,"—  "]
[null,"Other accrued liabilities",null,null,277,null,328]
[null,null,"Total current liabilities",null,{"$f":"SUM(E29:E33)","v":{"v":1813,"d":"1,813"}},null,{"$f":"SUM(G29:G33)","v":{"v":1708,"d":"1,708"}}]
[]
["Long-term debt",{"$nulls":3},{"v":2730,"d":"2,730"},null,{"v":2729,"d":"2,729"}]
["Retirement and post-retirement benefits",{"$nulls":3},187,null,220]
["Other long-term liabilities",{"$nulls":3},603,null,659]
[null,null,"Total liabilities",null,{"$f":"SUM(E34:E38)","v":{"v":5333,"d":"5,333"}},null,{"$f":"SUM(G34:G38)","v":{"v":5316,"d":"5,316"}}]
[]
["Total Equity:"]
[null,"Stockholders' equity:"]
[null,"Preferred stock; $0.01 par value; 125 million"]
[null,null,"shares authorized; none issued and outstanding",null,"—  ",null,"—  "]
[null,"Common stock; $0.01 par value, 2 billion"]
[null,null,"shares authorized; 299 million shares at April 30, 2022"]
[null,null,"and 302 million shares at October 31, 2021, issued and outstanding",null,3,null,3]
[null,"Additional paid-in-capital",null,null,{"v":5292,"d":"5,292"},null,{"v":5320,"d":"5,320"}]
[null,"Retained earnings",null,null,160,null,348]
[null,"Accumulated other comprehensive loss",null,null,{"v":-333,"d":"(333)"},null,{"v":-282,"d":"(282)"}]
[null,null,"Total stockholders' equity",null,{"$f":"SUM(E44:E50)","v":{"v":5122,"d":"5,122"}},null,{"$f":"SUM(G44:G50)","v":{"v":5389,"d":"5,389"}}]
[{"$nulls":3},"Total liabilities and stockholders' equity",{"$f":"E39+E51","v":{"v":10455,"d":"$10,455"}},null,{"$f":"G39+G51","v":{"v":10705,"d":"$10,705"}}]
[]
[]
["The preliminary balance sheet is estimated based on our current information."]
[]
[]
[]
["Page 2"]

{"sheet":"Cash Flow","index":2,"n_rows":82,"n_cols":8,"rows_kept":82,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[7,5,7,7],[81,0,81,7]]}
["AGILENT TECHNOLOGIES, INC."]
["CONDENSED CONSOLIDATED STATEMENT OF CASH FLOWS"]
["(In millions)"]
["(Unaudited)"]
["PRELIMINARY"]
[]
[]
[{"$nulls":5},"Six Months Ended"]
[{"$nulls":5},"April 30,",null,"April 30,"]
[{"$nulls":5},2022,null,2021]
["Cash flows from operating activities:"]
[null,"Net income",{"$nulls":3},{"v":557,"d":"$557"},null,{"v":504,"d":"$504"}]
[]
["Adjustments to reconcile net income to net cash provided by operating activities:"]
[null,"Depreciation and amortization",{"$nulls":3},164,null,153]
[null,"Share-based compensation",{"$nulls":3},71,null,66]
[null,"Excess and obsolete inventory related charges",{"$nulls":3},10,null,14]
[null,"Loss on extinguishment of debt",{"$nulls":3},"—",null,17]
[null,"Asset impairment charges",{"$nulls":3},"—",null,2]
[null,"Net loss (gain) on equity securities",{"$nulls":3},62,null,{"v":-15,"d":"(15)"}]
[null,"Change in fair value of contingent consideration",{"$nulls":3},{"v":-25,"d":"(25)"},null,"—"]
[null,"Other non-cash expenses, net",{"$nulls":3},9,null,2]
[null,"Changes in assets and liabilities:"]
[null,null,"Accounts receivable, net",null,null,{"v":-108,"d":"(108)"},null,{"v":-17,"d":"(17)"}]
[null,null,"Inventory",null,null,{"v":-124,"d":"(124)"},null,{"v":-80,"d":"(80)"}]
[null,null,"Accounts payable",null,null,54,null,51]
[null,null,"Employee compensation and benefits",null,null,{"v":-144,"d":"(144)"},null,{"v":-3,"d":"(3)"}]
[null,null,"Other assets and liabilities ",null,null,12,null,16]
["Net cash provided by operating activities (a)",{"$nulls":4},{"$f":"SUM(F12:F28)","v":538},null,{"$f":"SUM(H12:H28)","v":710}]
[]
["Cash flows from investing activities:"]
[null,"Investments in property, plant and equipment",{"$nulls":3},{"v":-139,"d":"(139)"},null,{"v":-72,"d":"(72)"}]
[null,"Proceeds from sale of property, plant and equipment",{"$nulls":5},"—"]
[null,"Acquisition of businesses and intangible assets, net of cash acquired",{"$nulls":3},{"v":-18,"d":"(18)"},null,{"v":-547,"d":"(547)"}]
[null,"Payment to acquire equity securities",{"$nulls":3},{"v":-3,"d":"(3)"},null,{"v":-8,"d":"(8)"}]
[null,"Proceeds from sale of equity securities",{"$nulls":5},"—"]
[null,"Proceeds from sale of equity securities",{"$nulls":3},6,null,"—"]
[null,"Payment in exchange for convertible note",{"$nulls":3},{"v":-1,"d":"(1)"},null,{"v":-2,"d":"(2)"}]
[null,"Acquisition of businesses and intangible assets, net of cash acquired",{"$nulls":5},"—"]
["Net cash used in investing activities",{"$nulls":4},{"$f":"SUM(F32:F39)","v":{"v":-155,"d":"(155)"}},null,{"$f":"SUM(H32:H39)","v":{"v":-629,"d":"(629)"}}]
[]
["Cash flows from financing activities:"]
[null,"Issuance of common stock under employee stock plans",{"$nulls":3},27,null,26]
[null,"Payment of taxes related to net share settlement of equity awards ",{"$nulls":3},{"v":-64,"d":"(64)"},null,{"v":-73,"d":"(73)"}]
[null,"Issuance of senior notes",{"$nulls":3},"—",null,848]
[null,"Debt issuance costs",{"$nulls":3},"—",null,{"v":-7,"d":"(7)"}]
[null,"Payment of dividends",{"$nulls":3},{"v":-126,"d":"(126)"},null,{"v":-118,"d":"(118)"}]
[null,"Repayment of senior notes",{"$nulls":3},"—",null,{"v":-417,"d":"(417)"}]
[null,"Proceeds from commercial paper",{"$nulls":3},575,null,{"v":1232,"d":"1,232"}]
[null,"Repayment of commercial paper",{"$nulls":3},{"v":-400,"d":"(400)"},null,{"v":-1102,"d":"(1,102)"}]
[null,"Proceeds from revolving credit facility",{"$nulls":5},"—"]
[null,"Repayment of revolving credit facility",{"$nulls":5},"—"]
[null,"Repayment of finance lease",{"$nulls":5},"—"]
[null,"Treasury stock repurchases",{"$nulls":3},{"v":-681,"d":"(681)"},null,{"v":-539,"d":"(539)"}]
["Net cash used in financing activities",{"$nulls":4},{"$f":"SUM(F41:F54)","v":{"v":-669,"d":"(669)"}},null,{"$f":"SUM(H43:H54)","v":{"v":-150,"d":"(150)"}}]
[]
["Effect of exchange rate movements",{"$nulls":4},{"v":-16,"d":"(16)"},null,9]
[]
["Net decrease in cash, cash equivalents and restricted cash",{"$nulls":4},{"$f":"F29+F40+F55+F57","v":{"v":-302,"d":"(302)"}},null,{"$f":"H29+H40+H55+H57","v":{"v":-60,"d":"(60)"}}]
[]
["Cash, cash equivalents and restricted cash at beginning of period",{"$nulls":4},{"v":1490,"d":"1,490"},null,{"v":1447,"d":"1,447"}]
[]
["Cash, cash equivalents and restricted cash at end of period",{"$nulls":4},{"$f":"SUM(F59:F61)","v":{"v":1188,"d":"$1,188"}},null,{"$f":"SUM(H59:H61)","v":{"v":1387,"d":"$1,387"}}]
[]
[]
["Reconciliation of cash, cash equivalents and restricted cash to the condensed consolidated balance sheet:"]
[]
[null,"Cash and cash equivalents",{"$nulls":3},{"v":1186,"d":"$1,186"},null,{"v":1380,"d":"$1,380"}]
[null,"Restricted cash, included in other assets",{"$nulls":3},2,null,7]
[null,"Total cash, cash equivalents and restricted cash",{"$nulls":3},{"$f":"SUM(F68:F69)","v":{"v":1188,"d":"$1,188"}},null,{"$f":"SUM(H68:H69)","v":{"v":1387,"d":"$1,387"}}]
[]
[]
["(a) Cash payments included in operating activities:"]
[]
[null,"Income tax payments, net",{"$nulls":3},{"v":134,"d":"$134"},null,{"v":116,"d":"$116"}]
[null,"Interest payments",{"$nulls":3},{"v":40,"d":"$40"},null,{"v":36,"d":"$36"}]
[]
[]
["The preliminary cash flow is estimated based on our current information."]
[]
[]
["Page 3"]

{"sheet":"Net Income & EPS Non-GAAP","index":3,"n_rows":53,"n_cols":15,"rows_kept":53,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[4,0,4,15],[6,4,6,8],[6,10,6,14],[7,4,7,8],[7,10,7,14],[9,7,9,8],[9,13,9,14],[25,0,25,14],[26,0,26,9],[27,0,27,14],[28,1,28,14],[29,1,29,14],[30,1,30,14],[31,1,31,14],[32,1,32,14],[33,1,33,14],[34,1,34,14],[35,1,35,14],[35,15,35,28],[35,29,35,31],[36,1,36,14],[37,1,37,14],[38,1,38,14],[39,1,39,14],[40,1,40,14],[40,15,40,28],[40,29,40,31],[41,1,41,14],[43,0,43,14],[45,0,45,14],[47,0,47,14],[50,0,50,14],[52,0,52,14]]}
["AGILENT TECHNOLOGIES, INC."]
["NON-GAAP NET INCOME AND DILUTED EPS RECONCILIATIONS"]
["(In millions, except per share amounts)"]
["(Unaudited)"]
["PRELIMINARY"]
[]
[{"$nulls":4},"Three Months Ended",{"$nulls":5},"Six Months Ended"]
[{"$nulls":4},"April 30,",{"$nulls":5},"April 30,"]
[{"$nulls":4},2022,"Diluted EPS",null,2021,"Diluted EPS",null,2022,"Diluted EPS",null,2021,"Diluted EPS"]
[]
["GAAP net income",{"$nulls":3},{"v":274,"d":"$274"},{"v":0.91,"d":"$0.91"},null,{"v":216,"d":"$216"},{"v":0.7,"d":"$0.70"},null,{"v":557,"d":"$557"},{"v":1.84,"d":"$1.84"},null,{"v":504,"d":"$504"},{"v":1.64,"d":"$1.64"}]
[null,"Non-GAAP adjustments:"]
[null,null,"Asset impairments",null,"—","—",null,2,0.01,null,"—","—",null,2,0.01]
[null,null,"Intangible amortization",null,50,0.17,null,46,0.15,null,101,0.34,null,90,0.29]
[null,null,"Transformational initiatives",null,9,0.03,null,9,0.03,null,13,0.04,null,20,0.06]
[null,null,"Acquisition and integration costs",null,8,0.03,null,13,0.04,null,15,0.05,null,22,0.07]
[null,null,"Change in fair value of contingent consideration",null,{"v":-28,"d":"(28)"},{"v":-0.09,"d":"(0.09)"},null,"—","—",null,{"v":-25,"d":"(25)"},{"v":-0.08,"d":"(0.08)"},null,"—","—"]
[null,null,"Loss on extinguishment of debt",null,"—","—",null,12,0.04,null,"—","—",null,17,0.06]
[null,null,"Business exit and divestiture costs",null,7,0.02,null,3,0.01,null,7,0.02,null,4,0.01]
[null,null,"Net loss (gain) on equity securities",null,16,0.05,null,{"v":-11,"d":"(11)"},{"v":-0.04,"d":"(0.04)"},null,61,{"v":0.2,"d":"0.20"},null,{"v":-11,"d":"(11)"},{"v":-0.04,"d":"(0.04)"}]
[null,null,"Other",null,"—","—",null,3,0.01,null,"—","—",null,6,0.02]
[null,null,"Adjustment for taxes (a)",null,4,0.01,null,6,0.02,null,{"v":-21,"d":"(21)"},{"v":-0.07,"d":"(0.07)"},null,{"v":-27,"d":"(27)"},{"v":-0.09,"d":"(0.09)"}]
["Non-GAAP net income",{"$nulls":3},{"$f":"SUM(E11:E22)","v":{"v":340,"d":"$340"}},{"$f":"SUM(F11:F22)","v":{"v":1.1300000000000001,"d":"$1.13"}},null,{"$f":"SUM(H11:H22)","v":{"v":299,"d":"$299"}},{"$f":"SUM(I11:I22)","v":{"v":0.9700000000000001,"d":"$0.97"}},null,{"$f":"SUM(K11:K22)","v":{"v":708,"d":"$708"}},{"$f":"SUM(L11:L22)","v":{"v":2.3400000000000003,"d":"$2.34"}},null,{"$f":"SUM(N11:N22)","v":{"v":627,"d":"$627"}},{"$f":"SUM(O11:O22)","v":{"v":2.03,"d":"$2.03"}}]
[]
[]
["(a) The adjustment for taxes excludes tax benefits that management believes are not directly related to on-going operations and which are either isolated or cannot be expected to occur again with any regularity or predictability. For the three months ended April 30, 2022, management used a non-GAAP effective tax rate of 13.92%.  For the six months ended April 30, 2022, management used a non-GAAP effective tax rate of 14.00%.  For the three and six months ended April 30, 2021, management used a non-GAAP effective tax rate of 14.75%."]
[]
["We provide non-GAAP net income and non-GAAP net income per share amounts in order to provide meaningful supplemental information regarding our operational performance and our prospects for the future. These supplemental measures exclude, among other things, charges related to asset impairments, amortization of intangibles, transformational initiatives, acquisition and integration costs, change in fair value of contingent consideration, loss on extinguishment of debt, business exit and divestiture costs and net loss (gain) on equity securities."]
[null,"Asset impairments include assets that have been written down to their fair value."]
[null,"Transformational initiatives include expenses associated with targeted cost reduction activities such as manufacturing transfers including costs to move manufacturing, small site consolidations, legal entity and other business reorganizations, insourcing or outsourcing of activities. Such costs may include move and relocation costs, one-time termination benefits and other one-time reorganization costs. Included in this category are also expenses associated with company programs to transform our product lifecycle management (PLM) system, human resources and financial systems.\n\n"]
[null,"Acquisition and integration costs include all incremental expenses incurred to effect a business combination. Such acquisition costs may include advisory, legal, accounting, valuation, and other professional or consulting fees. Such integration costs may include expenses directly related to integration of business and facility operations, the transfer of assets and intellectual property, information technology systems and infrastructure and other employee-related costs. \n"]
[null,"Pension settlement loss relates to the relief of the US Retirement Plan pension obligation due to increased lump sum payouts over a specified accounting threshold. "]
[null,"Change in fair value of contingent consideration represents changes in the fair value estimate of acquisition-related contingent consideration."]
[null,"Loss on extinguishment of debt relates to the net loss recorded on the redemption of the remaining $300 million of the $400 million outstanding 3.2% 2022 senior notes due on October 1, 2022, called on March 5, 2021 and settled on April 5, 2021."]
[null,"Business exit and divestiture costs include costs associated with business divestitures. "]
[null,"Pension settlement loss relates to the relief of the US Retirement Plan pension obligation due to increased lump sum payouts over a specified accounting threshold. "]
[null,"NASD site costs include all the costs related to the expansion of our manufacturing of nucleic acid active pharmaceutical ingredients incurred prior to the commencement of commercial manufacturing. "]
[null,"Special compliance costs include costs associated with transforming our processes to implement new regulations such as data privacy regulations, revenue recognition, lease accounting and certain tax reporting requirements."]
[null,"Acceleration of share-based compensation expense represents stock-based compensation expense that was accelerated upon employees’ involuntary termination from the company."]
[null,"Net loss (gain) on equity securities relates to the realized and unrealized mark-to-market adjustments for our marketable and non-marketable equity securities."]
[null,"Other includes certain legal costs and settlements, special compliance costs and acceleration of share-based compensation expense in addition to other miscellaneous adjustments."]
[null,"Tax benefit on intra-entity asset transfer relates to our operations in Singapore along with our application of the new accounting rules for income tax consequences of intra-entity transfer of assets as adopted on November 1, 2018."]
[]
["Our management uses non-GAAP measures to evaluate the performance of our core businesses, to estimate future core performance and to compensate employees. Since management finds this measure to be useful, we believe that our investors benefit from seeing our results “through the eyes” of management in addition to seeing our GAAP results. This information facilitates our management’s internal comparisons to our historical operating results as well as to the operating results of our competitors."]
[]
["Our management recognizes that items such as amortization of intangibles can have a material impact on our cash flows and/or our net income. Our GAAP financial statements including our statement of cash flows portray those effects. Although we believe it is useful for investors to see core performance free of special items, investors should understand that the excluded items are actual expenses that may impact the cash available to us for other uses. To gain a complete picture of all effects on the company’s profit and loss from any and all events, management does (and investors should) rely upon the GAAP income statement. The non-GAAP numbers focus instead upon the core business of the company, which is only a subset, albeit a critical one, of the company’s performance."]
[]
["Readers are reminded that non-GAAP numbers are merely a supplement to, and not a replacement for, GAAP financial measures. They should be read in conjunction with the GAAP financial measures. It should be noted as well that our non-GAAP information may be different from the non-GAAP information provided by other companies."]
[]
["The preliminary non-GAAP net income and diluted EPS reconciliation is estimated based on our current information."]
[]
[]
["Page 4"]

{"sheet":"Segment Results","index":4,"n_rows":68,"n_cols":5,"rows_kept":68,"merged":[[0,0,0,4],[0,5,0,8],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[7,0,7,4],[33,0,33,4],[60,0,60,4],[62,0,62,4],[67,0,67,4]]}
["AGILENT TECHNOLOGIES, INC."]
["SEGMENT INFORMATION"]
["(In millions, except where noted)"]
["(Unaudited)"]
["PRELIMINARY"]
[]
[]
["Quarter-over-Quarter"]
[]
["Life Sciences and Applied Markets Group"]
[null,null,"Q2'22",null,"Q2'21"]
["Revenue",null,{"v":896,"d":"$896"},null,{"v":881,"d":"$881"}]
["Gross Margin, %",null,{"v":0.59,"d":"59.0%"},null,{"v":0.599,"d":"59.9%"}]
["Income from Operations",null,{"v":228,"d":"$228"},null,{"v":226,"d":"$226"}]
["Operating margin, %",null,{"v":0.255,"d":"25.5%"},null,{"v":0.257,"d":"25.7%"}]
[]
[]
["Diagnostics and Genomics Group"]
[null,null,{"$f":"C11","v":"Q2'22"},null,{"$f":"E11","v":"Q2'21"}]
["Revenue",null,{"v":358,"d":"$358"},null,{"v":315,"d":"$315"}]
["Gross Margin, %",null,{"v":0.56,"d":"56.0%"},null,{"v":0.534,"d":"53.4%"}]
["Income from Operations",null,{"v":91,"d":"$91"},null,{"v":69,"d":"$69"}]
["Operating margin, %",null,{"v":0.255,"d":"25.5%"},null,{"v":0.219,"d":"21.9%"}]
[]
[]
["Agilent CrossLab Group"]
[null,null,{"$f":"C11","v":"Q2'22"},null,{"$f":"E11","v":"Q2'21"}]
["Revenue",null,{"v":353,"d":"$353"},null,{"v":329,"d":"$329"}]
["Gross Margin, %",null,{"v":0.471,"d":"47.1%"},null,{"v":0.453,"d":"45.3%"}]
["Income from Operations",null,{"v":87,"d":"$87"},null,{"v":69,"d":"$69"}]
["Operating margin, %",null,{"v":0.246,"d":"24.6%"},null,{"v":0.21,"d":"21.0%"}]
[]
[]
["Year-over-Year"]
[]
["Life Sciences and Applied Markets Group"]
[null,null,"FY21",null,"FY20"]
["Revenue",null,{"v":2823,"d":"$2,823"},null,{"v":2392,"d":"$2,392"}]
["Gross Margin, %",null,{"v":0.598,"d":"59.8%"},null,{"v":0.592,"d":"59.2%"}]
["Income from Operations",null,{"v":722,"d":"$722"},null,{"v":548,"d":"$548"}]
["Operating margin, %",null,{"v":0.256,"d":"25.6%"},null,{"v":0.229,"d":"22.9%"}]
[]
[]
["Diagnostics and Genomics Group"]
[null,null,{"$f":"C37","v":"FY21"},null,{"$f":"E37","v":"FY20"}]
["Revenue",null,{"v":1296,"d":"$1,296"},null,{"v":1047,"d":"$1,047"}]
["Gross Margin, %",null,{"v":0.528,"d":"52.8%"},null,{"v":0.519,"d":"51.9%"}]
["Income from Operations",null,{"v":273,"d":"$273"},null,{"v":192,"d":"$192"}]
["Operating margin, %",null,{"v":0.21,"d":"21.0%"},null,{"v":0.183,"d":"18.3%"}]
[]
[]
["Agilent CrossLab Group"]
[null,null,{"$f":"C37","v":"FY21"},null,{"$f":"E37","v":"FY20"}]
["Revenue",null,{"v":2200,"d":"$2,200"},null,{"v":1900,"d":"$1,900"}]
["Gross Margin, %",null,{"v":0.523,"d":"52.3%"},null,{"v":0.522,"d":"52.2%"}]
["Income from Operations",null,{"v":618,"d":"$618"},null,{"v":516,"d":"$516"}]
["Operating margin, %",null,{"v":0.281,"d":"28.1%"},null,{"v":0.272,"d":"27.2%"}]
[]
[]
[]
["Income from operations reflect the results of our reportable segments under Agilent's management reporting system which are not necessarily in conformity with GAAP financial measures. Income from operations of our reporting segments exclude, among other things, charges related to asset impairments, amortization of intangibles, transformational initiatives, acquisition and integration costs, change in fair value of contingent consideration and business exit and divestiture costs."]
[]
["Readers are reminded that non-GAAP numbers are merely a supplement to, and not a replacement for, GAAP financial measures.  They should be read in conjunction with the GAAP financial measures.  It should be noted as well that our non-GAAP information may be different from the non-GAAP information provided by other companies."]
[]
["The preliminary segment information is estimated based on our current information. "]
[]
[]
["Page 5"]

{"sheet":"Core Revenue by Segment (QTD)","index":5,"n_rows":45,"n_cols":9,"rows_kept":45,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[7,1,7,8],[9,1,9,3],[21,1,21,3],[21,5,21,6],[22,6,23,6],[22,8,23,8],[32,0,32,8],[34,0,34,8],[36,0,36,8],[38,0,38,8],[41,0,41,8],[44,0,44,8]]}
["AGILENT TECHNOLOGIES, INC."]
["RECONCILIATIONS OF REVENUE BY SEGMENT"]
["EXCLUDING ACQUISITIONS, DIVESTITURES AND THE IMPACT OF CURRENCY ADJUSTMENTS (CORE)"]
["(in millions)"]
["(Unaudited)"]
["PRELIMINARY"]
[]
[null,"Year-over-Year"]
[]
[null,"GAAP"]
[{"$nulls":3},"Year-over-Year"]
["GAAP Revenue by Segment","Q2'22","Q2'21","% Change"]
[]
["Life Sciences and Applied Markets Group",{"v":896,"d":"$896"},{"v":881,"d":"$881"},{"v":0.02,"d":"2%"}]
["Diagnostics and Genomics Group",358,315,{"v":0.14,"d":"14%"}]
["Agilent CrossLab Group",353,329,{"v":0.07,"d":"7%"}]
["Agilent",{"$f":"SUM(B14:B16)","v":{"v":1607,"d":"$1,607"}},{"$f":"SUM(C14:C16)","v":{"v":1525,"d":"$1,525"}},{"v":0.05,"d":"5%"}]
[]
[]
[]
[]
[null,"Non-GAAP \n(excluding Acquisitions & Divestitures)",{"$nulls":3},"Year-over-Year\nat Constant Currency (a)"]
[{"$nulls":3},"Year-over-Year",null,"Year-over-Year","Percentage Point Impact from Currency",null,"Current Quarter Currency Impact (b)"]
["Non GAAP Revenue by Segment",{"$f":"B12","v":"Q2'22"},{"$f":"C12","v":"Q2'21"},"% Change",null,"% Change"]
[]
["Life Sciences and Applied Markets Group",{"v":896,"d":"$896"},{"v":881,"d":"$881"},{"v":0.02,"d":"2%"},null,{"v":0.04,"d":"4%"},"-2 ppts",null,{"v":-16,"d":"$(16)"}]
["Diagnostics and Genomics Group ",355,315,{"v":0.13,"d":"13%"},null,{"v":0.15,"d":"15%"},"-2 ppts",null,{"v":-8,"d":"(8)"}]
["Agilent CrossLab Group ",353,329,{"v":0.07,"d":"7%"},null,{"v":0.1,"d":"10%"},"-3 ppts",null,{"v":-8,"d":"(8)"}]
["Agilent (Core)",{"$f":"SUM(B26:B28)","v":{"v":1604,"d":"$1,604"}},{"$f":"SUM(C26:C28)","v":{"v":1525,"d":"$1,525"}},{"v":0.05,"d":"5%"},null,{"v":0.07,"d":"7%"},"-2 ppts",null,{"$f":"SUM(I26:I28)","v":{"v":-32,"d":"$(32)"}}]
[]
[]
[]
["We compare the year-over-year change in revenue excluding the effect of recent acquisitions and divestitures and foreign currency rate fluctuations to assess the performance of our underlying business.  "]
[]
["(a) The constant currency year-over-year growth percentage is calculated by recalculating all periods in the comparison period at the foreign currency exchange rates used for accounting during the last month of the current quarter and then using those revised values to calculate the year-over-year percentage change."]
[]
["(b) The dollar impact from the current quarter currency impact is equal to the total year-over-year dollar change less the constant currency year-over-year change."]
[]
["The preliminary reconciliation of GAAP revenue adjusted for recent acquisitions and divestitures and impact of currency is estimated based on our current information."]
[]
[]
[]
[]
[]
["Page 6"]