tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: james_steffes__12811__Weekly Power & Gas Report
Sheet: Gas-Summary

Weekly Gas Report
Week of 6/22/01 - 6/28/01
State | # Deals | Customer Type | Deal Type | Volume (Dth)
CA | 4 | Modified2 | Fixed | 128455
CA | 13 | New | Fixed | 923216
CA | 3 | Existing | Index | 119000
CA | 0 | Modified2 | Index | 23359
CA | 1 | New | Index | 134521
IL | 11 | Existing | Fixed | 251321
IL | 0 | Modified2 | Fixed | 13806
IL | 4 | New | Fixed | 66696
IL | 1 | Existing | Index | 2000
IL | 1 | Modified2 | Index | 55500
IN | 1 | Existing | Fixed | 68574
IN | 1 | Modified2 | Fixed | 56837
IN | 1 | New | Fixed | 11392
IN | 2 | Existing | Index | 32821
MD | 9 | Modified2 | Fixed | 206200
MD | 2 | New | Fixed | 46082
MD | 2 | Modified2 | Index | 4800
MI | 1 | Modified2 | Fixed | 32000
MO | 1 | Modified2 | Fixed | 50350
MO | 2 | Existing | Index | 32400
NJ | 8 | Existing | Fixed | 112050
NJ | 1 | Modified2 | Fixed | 3750
NJ | 10 | New | Fixed | 115401
NJ | 1 | Existing | Index | 7440
NJ | 1 | New | Index | 4960
NY | 1 | Existing | Fixed | 4362
NY | 2 | New | Fixed | 5788
NY | 4 | New | Index | 29009
NYMEX1 | 2 | Modified2 | Fixed | 12046
NYMEX1 | 6 | New | Fixed | 282261
OH | 11 | Existing | Fixed | 226066
OH | 4 | Modified2 | Fixed | 379346
OH | 8 | New | Fixed | 218805
OH | 20 | Existing | Index | 7992593
OH | 3 | Modified2 | Index | 1037177
OH | 6 | New | Index | 954610
PA | 1 | Existing | Fixed | 75700
PA | 4 | New | Fixed | 38184
WI | 1 | Modified2 | Fixed | 25465
WI | 1 | Existing | Fixed | 82895
TOTAL
1.  NYMEX listed as citygate; could not determine customer's state.
2.  Where possible, offsetting unwinds were elimnated from totals.
 | 44 modified contracts were identified by customer type "modified".  16 of the 44 offsetting transactions were identified as follows:
 |  | 7 contracts converted customer from Index to Fixed price and most extended the contract term
 |  |  | 4 contracts in CA, 2 contracts in MD and 1 contract in OH
 |  | 2 contracts kept the cusomer on a Fixed price and extended the contract term
 |  |  | 1 contract in WI (extended 2 years) and 1 contract in CA (extended 5 years)
 |  | 7 contracts appear to be unwinds/corrections.
Spreadsheet: 126409d1319670678-index-and-match-formula-tournamenttemplatetest
Sheet: Banner

Category:
[NAME] | Donation | Description of Goods/Services | Hole Sponsorship | Value | Prefix | First Name | Last Name | Company Name | Street Address | City | State | Zip Code | Greeting | E-mail | Phone |  | [NAME] | [NAME] in Charge:
Spreadsheet: 881009d1728918932-changing-cell-colour-based-on-date-cdf
Sheet: Sheet1

Today: |  |  |  |  |  |  |  | 2024-10-01 00:00:00
 |  |  |  |  |  |  |  | 2024-10-05 00:00:00
 |  |  |  |  |  |  |  | 2024-10-10 00:00:00
 |  |  |  |  |  |  |  | 2024-10-13 00:00:00
 |  |  |  |  |  |  |  | 2024-10-14 00:00:00
 |  |  |  |  |  |  |  | 2024-10-15 00:00:00
 |  |  |  |  |  |  |  | 2024-10-20 00:00:00
 |  |  |  |  |  |  |  | 2024-10-25 00:00:00
 |  |  |  |  |  |  |  | 2024-10-30 00:00:00
 |  |  |  |  |  |  |  | 2024-11-05 00:00:00
 |  |  |  |  |  |  |  | 2024-11-10 00:00:00
 |  |  |  |  |  |  |  | 2024-11-11 00:00:00
 |  |  |  |  |  |  |  | 2024-11-12 00:00:00
 |  |  |  |  |  |  |  | 2024-11-13 00:00:00
 |  |  |  |  |  |  |  | 2024-11-14 00:00:00
 |  |  |  |  |  |  |  | 2024-11-15 00:00:00
 |  |  |  |  |  |  |  | 2024-11-16 00:00:00
 |  |  |  |  |  |  |  | 2024-11-17 00:00:00
 |  |  |  |  |  |  |  | 2024-11-18 00:00:00
Spreadsheet: 105793d1303078594-help-with-making-if-function-add-several-cells-base-schedule
Sheet: Sheet1

Store Name                Period  Week                          Week Commencing
Name | Contract | Hol | Worked | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat
 |  |  | 8 | 06:00:00 | 14:00:00
 |  |  | -6 | 06:00:00
 |  |  | -6 | 06:00:00
 |  |  | -6 | 06:00:00
 |  |  | -6 | 06:00:00
 |  |  | -6 | 06:00:00
Total Hours | 0 | 0 | -10
Managers At Opening |  |  |  | 2
Colleagues At Opening
Managers At Closing
Colleagues At Closing
Spreadsheet: 863595d1711018603-index-with-multiple-criteria-with-results-displayed-horizontally-index-with-multiple-criteria-test-sheet-aligw
Sheet: ORDERS

Item | Batch | Quantity Sold
Product 1 | 32165 | 12
Product 4 | 37415 | 10
Product 5 | 36521 | 5
Product 4 | 35741 | 2
Product 5 | 39521 | 1
Product 1 | 32165 | 5
Product 2 | 36247 | 9
Product 3 | 32845 | 11
Spreadsheet: c1618108-72a5-4104-885a-113f99bf106b
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
HVAR | Test | HVAR | [NAME] (HVA), [NAME], [NAME] | [NAME] (HVA), Random, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME]: Urine |  |  | 7 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068)  [NAME]: 7 mL  Collection Instructions:  1. Collect a random urine specimen. 2. Adjust the urine pH to a level between 1 and 5 by adding 50% acetic acid dropwise and checking the pH. Additional Information:  1. Patient's age is required. 2. Administration of L-dopa may falsely increase homovanillic acid results; it should be discontinued 24 hours prior to and during collection of specimen. 3. Bactrim may interfere with detection of the analyte. All patients taking [NAME] should be identified to the laboratory when this test is ordered. | 2 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | <1 year: <35.0 mg/g creatinine 1 year: <23.0 mg/g creatinine 2-4 years: <13.5 mg/g creatinine 5-9 years: <9.0 mg/g creatinine 10-14 years: <12.0 mg/g creatinine > or =15 years (adults): < or =10.0 mg/g creatinine | Monday through Saturday; 8 a.m. | 2 days (not reported on Sunday) | 4 days | 1 | 83150 |  |  |  |  | Rochester
HVAR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
HVAR | Result | 60275 | [NAME] (HVA), Random, U | [NAME] (HVA), Random, U | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 11146-8 | Homovanillate/Creatinine:MRto:Pt:[NAME]:Qn:
Spreadsheet: 53120d1253045770-adding-data-from-one-worksheet-to-another-and-more-book1-2
Sheet: DATA

Code | Description | Price
A100 | Retaining Wall Block | 6.35
[NAME] | Wall Caps | 3.56
A102 | PL Block adhesive | 2.16
A103 | Paving Base | 3.24
A104 | Bullet Edgers | 1.19
A105 | Decorative Rock | 2.13
A106 | Pulverized Black Dirt | 27.25
A107 | Weed Barrier Fabric 3' x 100' | 52
A108 | Lawn Edging | 24.5
A109 | Mulch/Woodchips | 1.89
A110 | 6 ML Black Poly 10' x 100' | 22.48
Spreadsheet: 65868d1266509611-transferring-and-looking-up-name-checker
Sheet: Sheet1

 |  | quote |  | sales members
 | quote number | dd/q52 |  | dd | [NAME] duck | 111
 | quote number | [NAME]/q52 |  | [NAME] | [NAME] | 222
 |  |  |  | bm | batman | 333
 |  |  |  | r | [NAME] | 444
 |  |  |  | s | spiderman | 555
 |  |  |  | return name
 |  |  |  | and number
 |  |  |  | in red cell
Spreadsheet: 871220d1717606536-trouble-creating-dependent-drop-down-lists-best-way-to-go-about-this-health-tracking
Sheet: Mental Health Data

 |  | Mental Health Data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel
 |  |  |  |  |  |  |  |  | PHIN | Registration | Patient  First Name | Patient  Last Name | Date of Birth | Gender | Urban/Rural | Date of Referral | Referring  Doctor | Procedure | Explanation | Professional? | Type of Profession | Facility | Facility Location | Specific Program Name | Duration of Stay | Referral Approved? | [NAME]? | Referral Approval/Denial Date | Extension Requested? | Early Withdrawl? | Hospital Costs | Medical Costs | Refunded  Amount | Date Paid | Patient  Travel Cost | Escort  Travel Cost | Referral Notes | Duplicate Helper Column (Keep Hidden)
 |  | Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homewood |  | Addiction Medicine Program Mood Anxiety & Concurrent Program
 |  | Total Costs (Minus Refunds): |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homewood-Ravensview |  | Homeraven1
 |  | Total Procedure Costs:
 |  | Total Travel Costs: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ↑ | ↑ | ↑ | ↑
 |  | Total Patient Travel Costs: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choose the FACILITY | LOCATION is linked to the FACILITY | PROGRAM NAME is linked to FACILITY | Duration is linked to the PROGRAM NAME.
 |  | Total Escort Travel Costs: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ([NAME] down list) | (automatically populated) | (Dropdown list) | (Automatically populated)
 |  | Patient Numbers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All of these settings dropdown options are found in the "Dropdown Data" tab.
 |  | Total Unique Patients:
 |  | Total Approvals:
 |  | Total Denied:
 |  | Total # of paid procedures:
 |  | Total # of unpaid procedures:
 |  |  |  | Procedures completed | Procedures Declined | Procedures Approved | TOTAL procedures
 |  | Programs
 |  | [NAME]
 |  | Psychiatric
 |  | PTSD
 |  | Substance Abuse
 |  | Substance Abuse/Psychiatric
 |  | Substance Abuse/PTSD
Spreadsheet: 87980d1287872759-excluding-specific-values-in-calculating-max-help
Sheet: Sheet2

66=not applicable
77=not done/dementia
88=cancellation/no show
99=missing data
55=missing form
enter number of times
0 =none
99=missing data
a | b | c | d | e | f | g | h | i | Highest Number of Loads
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1
77 | 77 | 77 | 77 | 77 | 77 | 77 | 77 | 77 | 77
7 | 3 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 7
5 | 99 | 99 | 99 | 99 | 99 | 2 | 99 | 99 | 5
55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55
88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88 | 88
7 | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 7
Spreadsheet: a4cba4f3-884b-4318-978f-19630ac5a7b3
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187934122 | [NAME] | Glory All Around | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Curb Records | 715187934023 | [NAME] | Work Of Love | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Curb Records | 715187882621 | [NAME] | [NAME] | 2004-08-10 | Compact Disc | Ac | 7.99 | Y | Available
Curb Records | 715187931725 | Plumb | Need You Now | 2013-02-26 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187931824 | [NAME] | Some People Change | 2013-03-26 | Compact Disc | Pop | 13.99 | Y | Available
Curb Records | 715187935921 | [NAME] | Hurricane | 2013-10-15 | Compact Disc | Ac | 13.99 | Y | Available
Curb Records | 715187886025 | [NAME] | Awaken | 2005-03-22 | Compact Disc | Ac Pop | 7.99 | Y | Available
Curb Records | 715187889026 | [NAME] | Greatest Hymns ([NAME]) | 2005-08-23 | Compact Disc | Ac | 9.99 | Y | Available
Curb Records | 715187893122 | [NAME] | In Christ Alone-Greatest Hits ([NAME]) | 2006-06-27 | Compact Disc | Ac | 9.99 | Y | Available
Curb Records | 715187894426 | [NAME] | Bless The Broken Road: The Duets Album | 2006-08-08 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187913820 | [NAME] | You Deliver Me | 2009-08-25 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187915725 | Plumb | Beautiful History: A Hits Collection | 2009-11-03 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187918825 | [NAME] | Love Revolution | 2010-08-24 | Compact Disc | Pop | 13.99 | Y | Available
Curb Records | 715187902527 | [NAME] | Relentless | 2008-02-12 | Compact Disc | Ac | 9.99 | Y | Available
Curb Records | 715187925120 | Mikeschair | Beautiful Life, A | 2011-08-23 | Compact Disc | Rock | 11.99 | Y | Available
Curb Records | 715187925021 | [NAME] | Hope Of The Broken World | 2011-08-23 | Compact Disc | Insp | 13.99 | Y | Available
Curb Records | 715187921627 | Dr. [NAME] | [NAME], The: The Definitive Collection | 2011-09-13 | Compact Disc | Insp | 24.98 | Y | Available
Curb Records | 715187895225 | [NAME] | Shadow Of Your Wings: Hymns And [NAME], The | 2006-10-24 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187781221 | Oak Ridge Boys | Old Time Gospel Favorites | 2001-01-16 | Compact Disc | [NAME] | 7.99 | Y | Available
Curb Records | 715187732629 | Tennessee [NAME] | All Time Greatest Hymns | 2001-01-16 | Compact Disc | Country | 9.99 | Y | Available
Curb Records | 715187793828 | [NAME] | Be Still My Soul | 2001-01-16 | Compact Disc | Ac Pop | 7.99 | Y | Available
Curb Records | 715187871328 | [NAME] | Press On | 2001-05-29 | Compact Disc | Insp | 5.99 | Y | Available
Curb Records | 715187873421 | [NAME] | Stronger | 2002-02-20 | Compact Disc | Ac | 5.99 | Y | Available
Curb Records | 715187883420 | [NAME] | Hiding Place | 2004-05-25 | Compact Disc | Insp | 7.99 | Y | Available
Spreadsheet: 770275d1645975079-excel-formula-to-produce-balance-sheet-balannce-sheet-2021
Sheet: Financial Statement

I am kindly asking for a excel formula that can produce a Balance Sheet using data in Trial Balance worksheet  as shown in the desired outcome:
 | Desired outcome
 | ASSETS
 | Non-current Assets
 | Buildings |  | 331833
 | Furniture - Net Value |  | 605421.6226666667
 | Motor Vehicles - Net Value |  | 5101.970661039522
 | Equipment - Net Value |  | 149508.2933333333
 | Current Assets
 | Debtors and other receivables |  | 2868092.2
 | Cash and equivalents |  | 223983.38
 | Total Assets
 | FINANCED BY:
 | EQUITY AND LIABILITIES
 | Accumulated funds |  | 491809.59
 | Net Surplus for the year |  | 2536617.16
 | School development funds |  | 846341.62
 | Total
 | Current Liabilities
 | Sundry Suppliers |  | 309000
 | Other obligations |  | 172.1
 | Total Equity and Liabilities
Spreadsheet: kim_ward__20824__gas consumption
Sheet: Sheet1

City of Los Angeles
Department of Water & Power
Historical Gas Usage
Month | Gas Usage - MMBtu |  | Gas Usage - MMBtu/d
 | 1996 | 1997 | 1996 | 1997
January | 1025633 | 577958
February | 1157156 | 390184
March | 1111342 | 608193
April | 1149338 | 1454805
May | 1346921 | 2155329
June | 1629025 | 1068124
July | 3218406 | 2271143
August | 4725147 | 3554841
September | 2935917 | 4444562
October | 2065042 | 2294980
November | 733548 | 528509
December | 667604 | 550586
TOTAL:
AVERAGE:
Spreadsheet: 887624d1737895372-calculat-how-many-occurance-within-the-same-month-for-the-same-branch-and-sort-it-as-1st-calculat-how-many-occurance-within-the-same-month-for-the-same-branch-and
Sheet: SAMPLE

 |  |  |  |  |  |  |  |  |  |  | required result
 | HELPER COLUMNS
Date | Month | Year | Branch | Contract | Attended | Attended % | Absence | Absence % | # no attendance | How Many Times No One Attended For Each Branch For Each Month | Order
2025-01-01 00:00:00 |  |  | A | 8 | 0 |  |  |  |  |  | 1st | column J uses values in column B and column C as helper columns to find the required criteria to use that criteria in the fromula.
2025-01-02 00:00:00 |  |  | A | 11 | 0 |  |  |  |  |  | 2nd | my question, is it possible to delete these 2 helper columns and embed its formulas into the column J inside the formula itself as my sheet is very wide and can not hide columns as requested from me.
2025-01-03 00:00:00 |  |  | C | 12 | 11
2025-01-04 00:00:00 |  |  | A | 12 | 0 |  |  |  |  |  | 3rd
2025-01-05 00:00:00 |  |  | E | 12 | 10
2025-01-06 00:00:00 |  |  | B | 12 | 0 |  |  |  |  |  | 1st
2025-01-07 00:00:00 |  |  | G | 12 | 11
2025-01-08 00:00:00 |  |  | H | 8 | 6
2025-01-09 00:00:00 |  |  | B | 11 | 0 |  |  |  |  |  | 2nd
2025-01-10 00:00:00 |  |  | B | 12 | 11
2025-01-11 00:00:00 |  |  | C | 12 | 0 |  |  |  |  |  | 1st
2025-01-12 00:00:00 |  |  | D | 12 | 10
2025-01-13 00:00:00 |  |  | C | 12 | 0 |  |  |  |  |  | 2nd
2025-02-01 00:00:00 |  |  | F | 12 | 10
2025-02-02 00:00:00 |  |  | G | 8 | 7
2025-02-03 00:00:00 |  |  | H | 11 | 9
2025-02-04 00:00:00 |  |  | A | 12 | 11
2025-02-05 00:00:00 |  |  | B | 12 | 10
2025-02-06 00:00:00 |  |  | F | 12 | 0 |  |  |  |  |  | 1st
2025-02-07 00:00:00 |  |  | D | 12 | 11
2025-02-08 00:00:00 |  |  | E | 12 | 10
2025-02-09 00:00:00 |  |  | F | 8 | 0 |  |  |  |  |  | 2nd
2025-02-10 00:00:00 |  |  | G | 11 | 9
2025-02-11 00:00:00 |  |  | H | 12 | 11
2025-02-12 00:00:00 |  |  | A | 12 | 11
2025-03-01 00:00:00 |  |  | B | 12 | 11
2025-03-02 00:00:00 |  |  | C | 12 | 10
2025-03-03 00:00:00 |  |  | D | 12 | 9
2025-03-04 00:00:00 |  |  | E | 8 | 6
2025-03-05 00:00:00 |  |  | A | 11 | 0 |  |  |  |  |  | 1st
Spreadsheet: 103782d1301491693-max-formula-book1_jkalub
Sheet: Sheet1

Test 1 | 15 | Test 18 |  | Test > | 1
Test 2 | 9
Test 3 | 13
Test 4 | 14
Test 5 | 8
Test 6 | 8
Test 7 | 15
Test 8 | 14
Test 9 | 6
Test 10 | 17
Test 11 | 7
Test 12 | 13
Test 13 | 15
Test 14 | 9
Test 15 | 12
Test 16 | 12
Test 17 | 8
Test 18 | 20
Test 19 | 7
Test 20 | 19
Spreadsheet: 161817d1339636834-displaying-month-to-date-data-movements-2012
Sheet: DATA ENTRY

 | Date & Time | Vessel | Total Actual (tonnes) | Total  Planned (tonnes) | Remain | Remain Cummulative | [NAME] | Accumulated variance | Attainment | Comments | Time Stamp
 | 2012-05-02 16:30:00 | Jones | 80000 | 82000
 | 2012-05-03 16:30:00 | Smith | 50000 | 52000
 | 2012-05-05 16:30:00 | Smythe | 77000 | 78000 | 5000
 | 2012-05-09 16:30:00 | Joynes | 58000 | 60000
 | 2012-05-11 16:30:00 | Pyramid | 81000 | 82000 | 1500
 | 2012-05-11 16:30:00 | Safers | 66000 | 63000
 | 2012-05-12 16:30:00 | Tweed | 82000 | 83000 | 500
 | 2012-05-13 16:30:00 | Weaver | 62000 | 63000
 | 2012-05-14 16:30:00 | Ageed | 60000 | 61000
 | 2012-05-14 16:30:00 | Boing | 67000 | 69000
 | 2012-05-15 16:30:00 | Mathers | 78000 | 80000 | 1900
 | 2012-05-16 16:30:00 | Angels | 68500 | 70000
 | 2012-05-17 16:30:00 | Jones | 80000 | 82000 | 1300
 | 2012-05-18 16:30:00 | [NAME] | 50000 | 52000
 | 2012-05-18 16:30:00 | Nevers | 77000 | 78000 | 700
 | 2012-05-20 16:30:00 | Weaver | 58000 | 60000 | 800
 | 2012-05-21 16:30:00 | Bottle | 81000 | 82000
 | 2012-05-23 16:30:00 | Newman | 66000 | 63000
 | 2012-05-23 16:30:00 | Pyramid | 82000 | 83000 | 500
 | 2012-05-25 16:30:00 | Tweed | 62000 | 63000 | 800
 | 2012-05-27 16:30:00 | Shanes | 60000 | 61000
 | 2012-05-28 16:30:00 | Ageed | 67000 | 69000 | 400
 | 2012-05-29 16:30:00 | Minnie | 78000 | 80000
 | 2012-05-30 16:30:00 | Packer | 68500 | 70000
 | 2012-05-30 16:30:00 | Boing | 80000 | 82000 | 950
 | 2012-05-29 16:30:00 | [NAME] | 50000 | 52000
 | 2012-06-01 16:30:00 | Jones | 80000 | 82000
 | 2012-06-02 16:30:00 | Smith | 50000 | 52000
 | 2012-06-03 16:30:00 | Smythe | 77000 | 78000 | 5000
 | 2012-06-03 16:30:00 | Joynes | 58000 | 60000
 | 2012-06-05 16:30:00 | Pyramid | 81000 | 82000 | 1500
 | 2012-06-06 16:30:00 | Safers | 66000 | 63000
 | 2012-06-07 16:30:00 | Tweed | 82000 | 83000 | 500
 | 2012-06-10 16:30:00 | Weaver | 62000 | 63000
 | 2012-06-11 16:30:00 | Ageed | 60000 | 61000
 | 2012-06-12 16:30:00 | Boing | 67000 | 69000
 | 2012-06-15 16:30:00 | Mathers | 78000 | 80000 | 1900
 | 2012-06-16 16:30:00 | Angels | 68500 | 70000
 | 2012-06-17 16:30:00 | Jones | 80000 | 82000 | 1300
 | 2012-06-18 16:30:00 | [NAME] | 50000 | 52000
 | 2012-06-18 16:30:00 | Nevers | 77000 | 78000 | 700
 | 2012-06-20 16:30:00 | Weaver | 58000 | 60000 | 800
 | 2012-06-21 16:30:00 | Bottle | 81000 | 82000
 | 2012-06-18 16:30:00 | Newman | 66000 | 63000
 | 2012-06-23 16:30:00 | Pyramid | 82000 | 83000 | 500
 | 2012-06-24 16:30:00 | Tweed | 62000 | 63000 | 800
 | 2012-06-27 16:30:00 | Shanes | 60000 | 61000
 | 2012-06-28 16:30:00 | Ageed | 67000 | 69000 | 400
 | 2012-06-29 16:30:00 | Minnie | 78000 | 80000
 | 2012-06-30 16:30:00 | Packer | 68500 | 70000
 | 2012-07-01 16:30:00 | Boing | 80000 | 82000 | 950
 | 2012-07-02 16:30:00 | [NAME] | 50000 | 52000
Spreadsheet: 51644d1251283229-counting-conditional-formatting-aug-backups
Sheet: 26th

Internt Backups |  |  | [NAME]
Customer/ server/ [NAME] job | Backup success |  | Customer/ server/ [NAME] job | Backup success |  | Y | Backup successful
Artist Indepenent |  |  | Able Services |  |  | N | Failed
AIFDC1-SYS-STATE | y |  | ADSDC1 | n |  | o | Backup Not found
AIFDCI-DATA | y |  | Finnsish Chamber of Commerce
AIFDC1-MSEXCH | y |  | FBCCS01 | y
AIFDC1-PST | y |  | LP Networks
Axis Security |  |  | LPNETDC1 | y
[NAME] | y |  | ML Select
AXISDC1-DATA | y |  | MLSDC1 | y
AXISDC1-MSEXCH | y |  | [NAME]
AXISDC1-BRICKLEVEL | y |  | SIDEKIXDC1 | o
AXISDC1-SQL | y
Colombier
[NAME] | y
COLUKDC1-DATA | not yet finished
COLUKDC1-PST | y |  | Date updated | 2009-08-26 00:00:00
COLUKSRV1-SYS-STATE | y
COLUKSRV1-SQL | y
COLUKSRV1-DATA | y
Finch & Partners
FINCHDC1-DATA | y
FINCHDC1-MSEXCH | y
Glasshouse Entertainment
GOLCONDALA-SYS-STATE | y
GOLCONDALA-DATA | y
GOLCONDALA-MSEXCH | y
GOLCONDALA-PST | y
LOGO69
LOGODC1-SYS-STATE | y
[NAME] | y
LOGODC1-DATA | y
LOGODC1-PST | y
LPM Cleaning
LPMDC1-SYS-STATE | y
LPMDC1-DATA | y
LPMDC1-EXCH | o
LPMDC2-SYS-STATE | y
LPMDC2-SQL | y
LPMDC2-DATA | y
TMS-SYS-STATE | y
TMS-SQL | y
TMS-DATA | y
[NAME]
NGDC1-SYS-STATE | y
NGDC1-MSEXCH | y
NGDC1-DATA | y
Tavistock
TWOODSO1-SYS-STATE | Y
TWOODS01-DATA | Still Running
TWOODS01-MSEXCH | Y
TWOODS01-PST | Y
Spreadsheet: a6a6dbe8-0e83-4a4d-876d-87037694536e
Sheet: TTM Recon Q1FY10

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 June 30, 2009
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 4052 |  | 0 |  | 241 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4293
Cost of goods sold | 2152 |  | -14 |  | 0 |  | -38 |  | 0 |  | 0 |  | -2 |  | 0 |  | 2098
Gross profit | 1900 |  | 14 |  | 241 |  | 38 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2195
Operating expenses:
Marketing and sales | 727 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -18 |  | 0 |  | 709
General and administrative | 314 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -42 |  | 0 |  | 272
Research and development | 1315 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -124 |  | 0 |  | 1191
Acquired in-process technology | 1 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 55 |  | -55 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Certain abandoned acquistion-related costs | 21 |  | -21 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Goodwill impairment | 368 |  | -368 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 74 |  | 0 |  | 0 |  | 0 |  | 0 |  | -74 |  | 0 |  | 0 |  | 0
Total operating expenses | 2875 |  | -445 |  | 0 |  | 0 |  | 0 |  | -74 |  | -184 |  | 0 |  | 2172
Operating income (loss) | -975 |  | 459 |  | 241 |  | 38 |  | 0 |  | 74 |  | 186 |  | 0 |  | 23
Loss on strategic investments | -72 |  | 0 |  | 0 |  | 0 |  | 72 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 22 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 22
Income (loss) before provison for income taxes | -1025 |  | 459 |  | 241 |  | 38 |  | 72 |  | 74 |  | 186 |  | 0 |  | 45
Provision for income taxes | 202 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -190 |  | 12
Net income (loss) | -1227 |  | 459 |  | 241 |  | 38 |  | 72 |  | 74 |  | 186 |  | 190 |  | 33
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -3.82 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.11