tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: aff0be73-572f-4ccd-a032-788c94d010fd
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
EPUR | Test | EPUR | Epicoccum purpurascens, IgE | Epicoccum Purpurascens, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EPUR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EPUR | Result | EPUR | Epicoccum Purpurascens, IgE | Epicoccum Purpurascens, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6111-9 | Epicoccum [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 702113d1604082439-sumifs-with-2-criteria-in-same-column-example1919
Sheet: Stores

 | Man 0 | a |  |  | 0 | a |  |  | 0 | a
3001 | 3
3118 |  | 4
3003
Spreadsheet: f495485e-f6f9-44c2-80d6-aef1f4079859
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
FFTRU | Test | FFTRU | Trichloroacetic Acid, [NAME] | Trichloroacetic Acid, [NAME] | Headspace Gas Chromatography/Electron Capture Detection (GC-EC) Spectrophotometry (SPEC) | [NAME]: Urine |  |  | 10 | mL | Submit a 10 mL aliquot from a random or spot urine collected at end of shift, end of exposure, or end of workweek. Send specimen refrigerated. | 0.25 mL | Hemolysis	NA Thawing	Warm Reject; Cold Reject Lipemia	NA Icterus	NA Other	NA | Creatinine: >50 mg/dL   Trichloroethane Exposure: 	Normal (unexposed population): 		None detected 	Exposed: 		Biological Exposure Index (BEI): 		10 mg/L (end of workweek) 	Toxic: 		Not established   Trichloroethylene Exposure: 	Normal (unexposed population): 		None detected 	Exposed: 		Biological Exposure Index (BEI): 		100 mg/g creat (end of workweek) 		 Biological Tolerance Value ([NAME]): 100 mg/L (end of exposure or end of shift, or after several shifts for long-term exposure) 	Toxic: 		Not established   [NAME] (Perchloroethylene) Exposure: 	Normal (unexposed population): 		None detected 	Exposed: 		Biological Exposure Index (BEI): 		7.0 mg/L (end of workweek) 	Toxic: 		Not established   Test Performed by:	Medtox Laboratories Inc. 			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 7 days | 9 - 11 days |  | Profile |  |  |  |  | Medtox Laboratories, Inc.
FFTRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
FFTRU | Result | Z1181 | Creatinine | Creatinine | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTRU | Result | Z1058 | Trichloroacetic Acid | Trichloroacetic Acid | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTRU | Result | Z1059 | Trichloroacetic Acid | Trichloroacetic Acid | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTRU | Billing Component | FFTRU |  | Organic Acid, Single, QNT |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 83921
FFTRU | Billing Component | FFTRU |  | Creatinine, [NAME]
Spreadsheet: 876263d1722950733-add-information-from-1-table-automatically-into-another-testfile
Sheet: Table 1

Nutricontrol |  |  |  |  |  |  | NIR
Monsternummer | Datum | Productsoort | Monsternummer klant | Aufrere | Vocht 80°C (vacuum) | Ruw eiwit (Kjeldahl, 6,25) | NIR-code | Aufrere2 | Moisture103 | Protein625 | GS/EP | Controle
The first part works perfect. Now I want to add some data that is extracted form Table3. I have tried replicating the Byrow and Lambda combination but have not been able to get it to work. Thanks in advance.
 |  |  |  |  |  |  |  |  | Extract from table 3
 |  |  |  |  |  |  | Table3[Monsternummer]
 |  |  |  |  |  |  | NIR-code | Aufrere | Moisture103 | Protein625 | GS/EP | Controle
 | 26-7-2024 | S ND | [PHONE] |  | 34 | 504
M001 | 24-7-2024 | S A | [PHONE] |  | 26 | 509
M002 | 24-7-2024 | S B | [PHONE] |  | 116 | 459
M003 | 24-7-2024 | S C | [PHONE] |  | 29 | 507
M004 | 24-7-2024 | S D | [PHONE] |  | 35 | 504
M005 | 24-7-2024 | S E | 24-07-24_13:00_SojaEP |  | 38 | 506
M301 | 17-7-2024 | S A | [PHONE] | 77,1 | 28 | 503
M302 | 17-7-2024 | S B | [PHONE] | 76,4 | 27 | 514
M303 | 17-7-2024 | S C | [PHONE] | 76,1 | 25 | 498
M304 | 17-7-2024 | S D | [PHONE] | 75,9 | 26 | 502
Test | 17-7-2024 | S D | 00081999 | 500 | 5 | 50
M305 | 45491 | S D | 82000 | 12.3 | 55 | 66
M306 | 45491 | S D | 82001 | -40.9666666666667 | 1.73333333333333 | -19.6166666666667
 |  |  |  |  |  |  | In this column I want to search which number in Table3[Monsternummer] is closest to "Monsternummer klant" in column D. (See formula I used in H3) | In this column I want to search the Aufrere value in Table3 by combining looking for Aufrere in Table3[Constituent] en giving the value next to it from Table3[Waarde]. | Same as with Aufrere but with Moisture103 | Same as with Aufrere but with Protein625 | I want to check if this row is about GS or EP. By using the formula if(Moisture103<=60;"EP";"GS") | This row is to column is to check if the number in the column "NIR-code" (H) is an exact match with the number in column "Monsternummer Klant" (D). See the formula I used in column M.
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 317921.79
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | -2875811 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  | 961031
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1635870
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  | -2032788
18 |  | W/D (Purchase from Stg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13960584
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  | 174016 |  |  |  |  |  |  |  | 93300
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  | -162912 |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME] |  |  |  |  |  | 26966
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 216086d1361576611-convert-fraction-to-a-decimal-convert-fraction-to-a-decimal
Sheet: Sheet1

Ad Size | Decimal Number
 |  |  | We sell ads in a monthly magazine.
1/8 | 0.125 |  | We sell ad sizes that are either:
1/2 | 0.5
full | 1 |  | Full | = | 1
1/2 | 0.5 |  | 1/2 | = | 0.5
1/2 | 0.5 |  | 1/4 | = | 0.25
1/4 | 0.25 |  | 1/8 | = | 0.125
1/2 | 0.5 |  | Out | = | 0
Full | 1
1/2 | 0.5
1/4 | 0.25
1/2 | 0.5 |  | What I would like to know is how
out | 0 |  | to convert the fraction to a
1/2 | 0.5 |  | decimal in a separate column
1/4 | 0.25 |  | and then I can sum the decimals column at the end.
1/4 | 0.25
1/8 | 0.125
1/8 | 0.125
1/8 | 0.125
Out | 0
1/4 | 0.25
1/2 | 0.5
1/2 | 0.5
1/4 | 0.25
Total | 8.5
Pages
Spreadsheet: 850545d1700912073-i-want-to-lookup-data-in-other-sheets-and-put-them-each-in-a-seperate-row-in-the-same-col-2023-sponsor-data-4-1-2-
Sheet: Collected data

Edukid ID | Informal letter name | Sponsor name | My role model is | In the future | I am most proud | Image Ref
Spreadsheet: 769184d1645373503-index-match-solution-required-for-multiple-criteria-with-merged-cell-index-match-for-merged-cell
Sheet: Summary

Device | Working Ratio | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-05 00:00:00
Water Meter | [NAME] | 100 | 100 | 100 | 100 | 100
 | Consumption Ratio | 96 | 0 | 0 | 90 | 80.4
Air meter | [NAME] | 100 | 100 | 100 | 100 | 100
 | Consumption Ratio | 96 | 0 | 0 | 90 | 80.4
Oil meter | [NAME] | 92 | -100 | -100 | 80 | 60.8
 | Consumption Ratio | 88 | -200 | -200 | 70 | 41.2 |  |  |  | Required Result
 |  |  |  |  |  |  |  |  |  | 2022-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Oil meter
Spreadsheet: 618436d1554277166-override-rank-formula-rank-override-example
Sheet: Sheet1

 |  |  |  |  |  |  | Actual |  |  | Override
 | Project | Priority Score | Ranking | Rank Override |  |  | Rank | Project |  | Rank | Project
 | A | 10 |  |  |  |  | 1 |  |  | 1 | B
 | B | 6.4 |  | 1 |  |  | 2 |  |  | 2 | A
 | C | 7 |  |  |  |  | 3 |  |  | 3 | F
 | D | 5.3 |  |  |  |  | 4 |  |  | 4 | C
 | E | 11 |  | 6 |  |  | 5 |  |  | 5 | D
 | F | 8 |  |  |  |  | 6 |  |  | 6 | E
 | G | 3.2 |  |  |  |  | 7 |  |  | 7 | G
Spreadsheet: tracy_geaccone__40158__sharris0401wk2
Sheet: Estimate Vs. Plan

Transwestern Pipeline Company
($[NAME])
April Week 2  April 13, 2001 |  |  |  |  |  | 2001-04-12 08:55:46.860000
 |  | April, 2001
 |  | Plan | Estimate | [NAME] |  | Comments
West Demand Revenues |  | 9.9615 | 10.2506241555 | 0.2891241554999997 |  | Reliant $62K,  Astra $29K, OneOk & APS @ Max Rates
West Commodity Revenues |  | 0.7592000000000001 | 0.9786273624999996 | 0.2194273624999995 |  | IT deals from PG&E to Socal greater than Plan by $317K
East Demand Revenues |  | 1.053 | 1.163610888 | 0.1106108880000001 |  | Add'l  contracts
East Commodity Revenues |  | 0.1566 | 0.2664407456 | 0.1098407456 |  | Higher [NAME]
[NAME] |  | 0.6127 | 0.7120197 | 0.09931970000000001 |  | Higher Rates
[NAME] Revenues |  | 0.0947 | 0.0869760451 | -0.00772395490000001
Revenue Variance |  | 12.6387 | 13.4592988967 | 0.8195988967000035
Fuel Price [NAME] |  | 0.5435613421415527 | 0.7784735078791715 | 0.2349121657376187 |  | MTD index price of $5.00 vs. Plan index price of $3.49
 |  |  |  |  |  | Unhedged Plan volume (756-600) 156
Fuel Volume Variance-Unhedged |  | 0 | -0.09273855767543977 | -0.09273855767543977 |  | Lower retained volumes than Plan volumes.  Increased volumes flowing East.
 |  |  |  |  |  | -18.5 @ MTD index price of $5.00
Sales Margin Variance on Unhedged |  | 0 | 0.177 | 0.177 |  | 20,000 Mmbtu linepack sale on 4/6
Hedging |  | 2.1276 | 2.1351 | 0.007500000000000284 |  | Add'l price on physical sales of HEDGED volumes
 |  |  |  |  |  | ($.005 on 10,000/day, $.02 on 10,000/day)
Other |  |  |  | 0
Fuel Variance(Excludes UAF) |  | 2.671161342141553 | 2.997834950203732 | 0.3266736080621793
Month-To-Date Variance |  | 15.30986134214155 | 16.45713384690373 | 1.146272504762183
Monthly Stretch |  | 0.842 | 0 | -0.842
ADJ Month-To-Date Variance |  | 16.15186134214155 | 16.45713384690373 | 0.3042725047621829
Spreadsheet: 105585d1302888593-freight-charges-based-on-zip-someko_freightperzipcode-2-
Sheet: Sheet1

Zip Code | STATE | Basic Charge | Min Charge | 0 - 250 KGS | 251 - 500 KGS | 501 - 1000 KGS | 1001 - 3000 KGS | 3001 + KGS
900-1000 | CA | 20 | 65 | 3.0774 | 5.8757 | 5.5557 | 5.5557 | 5.0774
3450-4550 | WY | 3 | 70 | 0.8252 | 2.0786 | 0.7577 | 0.8788 | 0.8252
9999-10111 | AZ | 50 | 78 | 0.9276 | 2.2558 | 2.2227 | 2.0075 | 0.7276
 |  | Zip Code | STATE | Basic Charge | Min Charge | Weight | Cost
 |  | 900-1000 | CA |  |  | 14 | 65 | Array
 |  | 900-1000 | CA | 20 | 65 | 14 | 65 | Non-array
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: MENU INFO

Menu Item List
 | Table 1.1 |  |  |  |  | Table 3.1 |  |  |  |  | Table 4.1
 | Highest Degree Offered |  |  |  |  | Campus Site |  |  |  |  | Major Group ID/Major [NAME]
 | 4-year & master's |  |  |  |  | [NAME] |  |  |  |  | AC - Accounting
 | 4-year & doctoral |  |  |  |  | Branch Campus |  |  |  |  | AG - Agriculture and Farming
 | 4-year undergraduate |  |  |  |  | Satellite Site |  |  |  |  | AL - American Indian Languages
 | 2-year |  |  |  |  |  |  |  |  |  | AS - American Indian Studies
 |  |  |  |  |  | Table 3.1 |  |  |  |  | AR - Art
 | Table 1.1 |  |  |  |  | Main Function |  |  |  |  | AU - Automotive Technology
 | [NAME] |  |  |  |  | Administration/Office |  |  |  |  | BI - Biology
 | Quarter |  |  |  |  | Auxiliary |  |  |  |  | BT - Building Trades
 | Semester |  |  |  |  | Classroom |  |  |  |  | BU - Business
 | Trimester |  |  |  |  | Cultural Center/Museum |  |  |  |  | CH - Chemistry
 | Other |  |  |  |  | Distance Learning |  |  |  |  | CS - Computer Science
 |  |  |  |  |  | Laboratory |  |  |  |  | CT - Computer Technology
 | Table 1.1 |  |  |  |  | Library |  |  |  |  | CL - Corrections/Law Enforcement
 | Land-Granted |  |  |  |  | Research |  |  |  |  | EA - Education-Paraprofessional
 | Yes |  |  |  |  | Residence |  |  |  |  | EO - Education-Professional
 | No |  |  |  |  | Student Services/Recreation |  |  |  |  | EN - English
 |  |  |  |  |  |  |  |  |  |  | ES - Environmental Science/Natural Resources
 | Table 1.1 |  |  |  |  | Table 3.1 |  |  |  |  | GE - Geography
 | Location |  |  |  |  | Own/Lease |  |  |  |  | HC - Health Careers
 | On Reservation |  |  |  |  | Assigned by Tribe |  |  |  |  | HI - Hospitality Industry
 | Off Reservation |  |  |  |  | Donated |  |  |  |  | HS - Human Services
 |  |  |  |  |  | Lease/Rent |  |  |  |  | IP - Individualized Program
 |  |  |  |  |  | Own |  |  |  |  | LA - Liberal Arts/General Studies
 |  |  |  |  |  |  |  |  |  |  | LS - Life Sciences
 |  |  |  |  |  | Table 3.2 |  |  |  |  | MA - Mathematics
 |  |  |  |  |  | Catalogue On-line Access |  |  |  |  | NS - Natural Science
 |  |  |  |  |  | Inter-Library System |  |  |  |  | NU - Nursing
 |  |  |  |  |  | Computer Lab w/ Internet |  |  |  |  | OA - Office Administration/Technology
 |  |  |  |  |  | Yes |  |  |  |  | PA - Paralegal
 |  |  |  |  |  | No |  |  |  |  | PE - Pre-Engineering
 |  |  |  |  |  |  |  |  |  |  | PV - Pre-Veterinary Science
 |  |  |  |  |  | Table 3.2 |  |  |  |  | SC - Science
 |  |  |  |  |  | Community Library Status |  |  |  |  | SS - Social Science
 |  |  |  |  |  | Community Library |  |  |  |  | VC - Vocational/Career Programs
 |  |  |  |  |  | Institution Use Only |  |  |  |  | UN - Undeclared/Nondeclared
 |  |  |  |  |  |  |  |  |  |  | MS - Master Degree Programs
 |  |  |  |  |  | Table 3.2
 |  |  |  |  |  | Community Learning Center
 |  |  |  |  |  | Yes
 |  |  |  |  |  | No
Spreadsheet: tracy_geaccone__40292__Cash_Sheets
Sheet: Causey_CFFO

Enron Corp
Cash Flow From Operating Activities
2001 Third Quarter
 |  |  |  |  |  |  | 3rd Quarter 2001
 |  |  | June YTD |  | Current |  | Identified |  |  |  | Sept YTD
 |  |  | Actuals |  | View * |  | Transactions |  | Total |  | Estimate
 | Transportation & Distribution
 | Enron Transportation Services
 | Portland General Group
 | Wholesale
 | Enron North America
 | Enron Europe
 | CATS & Margaux
 | Middle East
 | Enron Global Markets
 | Enron Broadband
 | Global Explor & Prod
 | EEOS
 | Enron Net Works
 | Enron Global Finance
 | Enron Industrial Markets
 | Enron Investment Partners
 | Wholesale - Other
 | Wholesale - EES
 | Wholesale - Elims
 | EI Headquarters
 | Enron Global Assets & Services
 | Enron Energy Services
 | Enron Renewable Energy
 | Corporate & Other
 | Total
 | Wholesale includes - Americas, Europe, EGM, EIM, ENW, EBS, EIP, EGEP and EE&CC
 | Corp and Other includes - Corp, Azurix and Clean Fuels
 | Corporate & Other
 | Corp & Other
 | ECM Other
 | Azurix
 | Clean Fuels
 | Finance
 | Overview
 | IVEST
 | Eliminations
 | Total
Spreadsheet: 852126d1702225163-excel-formula-to-extract-data-from-salary-sheet-to-payslip-match-payslip-adjusted-
Sheet: Payslip

 | Kindly asking for excel formula to extract data on the salary sheet to the Payslip sheet as
 | shown below. Where there is no amount the formula should leave out the naration e.g. Pension
 | on Doroth salary there is zero and pension is not included in the payslip. Thank you.
 | NB Select month and Employee name from the drop down list
 | Desired solution
 | PAYSLIP
 | 2023-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | January
 | Month | February |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  | April
 | Employee Name | [NAME] |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  | July
 | Eearnings | USD | ZWL |  |  | Deductions | USD | ZWL |  |  |  |  | August
 |  |  |  |  |  | Nssa | 45 |  |  |  |  |  | September
 | Over time |  | 150000 |  |  | Nec | 90 |  |  |  |  |  | October
 |  |  |  |  |  | PAYE | 11.27232849150665 | 63044.72402642548 |  |  |  |  | November
 |  |  |  |  |  | Aids Levy | 0.3381698547451996 | 1891.341720792764 |  |  |  |  | December
 |  |  |  |  |  | Net Pay | 53.38950165374817 | 965063.9342527818
 | Total |  |  |  |  | Total
Spreadsheet: 861247d1709170923-single-cell-formula-to-create-a-dynamic-array-dynamicarray-one-function-dj
Sheet: Sheet1

ID | Period | Rate |  |  |  | 2024 | 2025
A001 | 2023 | 100 |  |  |  | 105 | 110
A002 | 2023 | 200 |  | A002 | 200 | 210 | 220
A003 | 2023 | 300 |  | A003 | 300 | 315 | 330
A004 | 2023 | 400 |  | A004 | 400 | 420 | 440
A001 | 2024 | 105
A002 | 2024 | 210 |  |  |  |  |  |  |  |  | 2023 | 2024 | 2025
A003 | 2024 | 315 |  |  |  | 105 | 110 |  |  | A001 | 100 | 105 | 110
A004 | 2024 | 420 |  |  | 200 | 210 | 220 |  |  | A002 | 200 | 210 | 220
A001 | 2025 | 110 |  |  | 300 | 315 | 330 |  |  | A003 | 300 | 315 | 330
A002 | 2025 | 220 |  |  | 400 | 420 | 440 |  |  | A004 | 400 | 420 | 440
A003 | 2025 | 330
A004 | 2025 | 440
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: TTM Recon Q4FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended March 31, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Gain on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3589 |  | 0 |  | 239 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3828
Cost of goods sold | 1499 |  | -12 |  | 0 |  | 1 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1486
Gross profit | 2090 |  | 12 |  | 239 |  | -1 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2342
Operating expenses:
Marketing and sales | 747 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -21 |  | 0 |  | 726
General and administrative | 301 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -40 |  | 0 |  | 261
Research and development | 1153 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -111 |  | 0 |  | 1042
Acquisition-related contingent consideration | -17 |  | 17 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 57 |  | -57 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 161 |  | 0 |  | 0 |  | 0 |  | 0 |  | -161 |  | 0 |  | 0 |  | 0
Total operating expenses | 2402 |  | -40 |  | 0 |  | 0 |  | 0 |  | -161 |  | -172 |  | 0 |  | 2029
Operating income (loss) | -312 |  | 52 |  | 239 |  | -1 |  | 0 |  | 161 |  | 174 |  | 0 |  | 313
Gain on strategic investments | 23 |  | 0 |  | 0 |  | 0 |  | -23 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 10 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 10
Income (loss) before provison for (benefit from) income taxes | -279 |  | 52 |  | 239 |  | -1 |  | -23 |  | 161 |  | 174 |  | 0 |  | 323
Provision for (benefit from) income taxes | -3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 93 |  | 90
Net income (loss) | -276 |  | 52 |  | 239 |  | -1 |  | -23 |  | 161 |  | 174 |  | -93 |  | 233
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.84 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  | 0.7
Spreadsheet: 59e480db-f6eb-4a59-87ea-de83c9bf5de7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8501.0 Retail Trade, Australia
 | TABLE 17. Quarterly Consumer Sales, Australia, By Type of Activity
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Consumer sales ;  Electricity retailing ;  Total (State) ;  Current Price ; |  |  | Original | A83750223R | 2012-06-01 00:00:00 | 2013-09-01 00:00:00 | 6 | $ Millions | FLOW | Quarter | 3
Consumer sales ;  Gas retailing ;  Total (State) ;  Current Price ; |  |  | Original | A83750225V | 2012-06-01 00:00:00 | 2013-09-01 00:00:00 | 6 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2013