tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 525999d1499075690-averageif-help-s666-operational-reporting-analyst-test-2
Sheet: Pivot

STATUS | Open
Department | Count of STATUS
Engineering | 3
Health & Dental Clinics | 7
Legal | 2
Manufacturing | 10
Supply Chain | 6
Grand Total | 28
Financial Year | 2017
Count of STATUS | Column Labels
BILLING TYPE | Filled Roles | Grand Total
[NAME] | 4 | 4
Direct | 5 | 5
Internal | 2 | 2
Grand Total | 11 | 11
Financial Year | 2017
Region | Count of STATUS
APAC | 1
EMEA | 3
USA | 7
Grand Total | 11
Spreadsheet: 81105d1281372329-if-vlookup-and-linear-interpolation-combined-solveequations
Sheet: Sheet1

 |  | Cat 1 |  | Table 4.1(A) Mz,cat
 |  | y= 0.0714ln(x) + 0.9534 |  |  | Terrain/height multiplier ([NAME],cat)
Height | Terrain Category | Trend Equation |  | Height (z) m | Cat 1 | Cat 2 | Cat 3 | Cat 4 |  | Pikes' Suggestion, expanded
3 | Cat 1 |  |  | 3 | 0.99 | 0.91 | 0.83 | 0.75
5 |  |  |  | 5 | 1.05 | 0.91 | 0.83 | 0.75
10 |  |  |  | 10 | 1.12 | 1 | 0.83 | 0.75
15 |  |  |  | 15 | 1.16 | 1.05 | 0.89 | 0.75
20 |  |  |  | 20 | 1.19 | 1.08 | 0.94 | 0.75
30 |  |  |  | 30 | 1.22 | 1.12 | 1 | 0.8
40 |  |  |  | 40 | 1.24 | 1.16 | 1.04 | 0.85
50 |  |  |  | 50 | 1.25 | 1.18 | 1.07 | 0.9
75 |  |  |  | 75 | 1.27 | 1.22 | 1.12 | 0.98
100 |  |  |  | 100 | 1.29 | 1.24 | 1.16 | 1.03
150 |  |  |  | 150 | 1.31 | 1.27 | 1.21 | 1.11
200 |  |  |  | 200 | 1.32 | 1.29 | 1.24 | 1.16
250 |  |  |  | 250 | 1.34 | 1.31 | 1.27 | 1.2
300 |  |  |  | 300 | 1.35 | 1.32 | 1.29 | 1.23
400 |  |  |  | 400 | 1.37 | 1.35 | 1.32 | 1.28
500 |  |  |  | 500 | 1.38 | 1.37 | 1.35 | 1.31
 |  | Cat 2
 |  | y = 0.0942ln(x) + 0.7945
500
 |  | Cat 3
 |  | y = 0.1154ln(x) + 0.6227
500
 |  | Cat 4
 |  | y = 0.1277ln(x) + 0.4612
500
Final Layout
Height | Terrain Category | Mz,cat
20 | Cat 4
Spreadsheet: 735393d1622947623-filter-one-column-for-specific-name-then-average-another-column-qa-test
Sheet: Sheet1

Agent Name: | Supervisor: | Project 1 | Project 2 | Project 3 | Project Average: |  | Supervisor: | Team Average: |  | Company Average:
Agent 1 | Supervisor 1 | 1 | 0.85 | 0.6 |  |  | Supervisor 1
Agent 2 | Supervisor 2 | 0.9 | 0.9 | 0.9 |  |  | Supervisor 2
Agent 3 | Supervisor 3 | 1 | 0.95 | 1 |  |  | Supervisor 3
Agent 4 | Supervisor 1 | 1 | 0.9 | 1
Agent 5 | Supervisor 2 | 0.65 | 0.65 | 0.65
Agent 6 | Supervisor 3 | 0.4 | 0.4 | 0.4
Agent 7 | Supervisor 1 | 1 | 0.65 | 1
Agent 8 | Supervisor 2 | 0.85 | 0.85 | 0.85
Agent 9 | Supervisor 3 | 0.85 | 0.85 | 0.85
Agent 10 | Supervisor 1 | 0 | 0 | 0
Spreadsheet: 167500d1342013721-excel-2003-date-formatting-error-date-appears-one-way-but-is-read-another-way-excel-date-changer
Sheet: File that Needs dates changing

CSR Name | ActionDate
SMITH, BOB | 2011-12-01 00:00:00
SMITH, BOB | 2011-11-18 00:00:00
SMITH, BOB | 2011-11-17 00:00:00
SMITH, BOB | 2011-10-10 00:00:00
SMITH, BOB | 2011-10-05 00:00:00
SMITH, BOB | 2011-10-03 00:00:00
SMITH, BOB | 2011-09-13 00:00:00
SMITH, BOB | 2011-08-16 00:00:00
SMITH, BOB | 2011-08-09 00:00:00
ROGERS, [NAME] | 2011-09-23 00:00:00
ROGERS, [NAME] | 2011-09-13 00:00:00
ROGERS, [NAME] | 2011-07-19 00:00:00
ROGERS, [NAME] | 2011-06-14 00:00:00
ROGERS, [NAME] | 2011-04-06 00:00:00
ROGERS, [NAME] | 2011-01-24 00:00:00
ROGERS, [NAME] | 2011-01-21 00:00:00
ROGERS, [NAME] | 2011-01-14 00:00:00
ROGERS, [NAME] | 2011-01-14 00:00:00
CORDOVA, MARTY | 2011-12-28 00:00:00
CORDOVA, MARTY | 2011-12-13 00:00:00
CORDOVA, MARTY | 2011-11-18 00:00:00
CORDOVA, MARTY | 2011-11-18 00:00:00
CORDOVA, MARTY | 2011-10-04 00:00:00
CORDOVA, MARTY | 2011-09-29 00:00:00
CORDOVA, MARTY | 2011-09-09 00:00:00
CORDOVA, MARTY | 2011-08-26 00:00:00
CORDOVA, MARTY | 2011-07-05 00:00:00
CORDOVA, MARTY | 2011-07-05 00:00:00
CORDOVA, MARTY | 2011-05-20 00:00:00
Spreadsheet: 839751d1692196889-help-linking-2-workbooks-extracting-column-header-based-on-date-copy-of-2023-manufacturing-schedule_excelforum
Sheet: forecasts

 | 2017 forecast | not confirmed
 | Figures as of Nov 2015
 | Sales Demand in Doses | 2017
 | FluMist - Base ( incl 800000 K replacements) | 14000000 | 15736347.5099757 | 16320791.1267567 | 16592781.1685566 | 16844036.2483255 | 17002922.5437573 | 17091896.7657239 | 17169258.7348487 | 17242158.8587948
 | FluMist - Int'l - New
 | [NAME] | 60588.70776 | 155576.97368952 | 2748997.716791744 | 3525131.3645222 | 4633621.852652464 | 4974105.56717608 | 5405261.66140312 | 6373695.957218047 | 6528832.925981728
 | Replacements | 800000 | 800000 | 800000 | 800000 | 800000 | 800000 | 800000 | 800000 | 800000
 | TOTAL ( M Doses ) | 23340952.97382857 | 28499487.12219535 | 32652093.43596351 | 34293712.99716467 | 36154485.98305246 | 37114346.11482877 | 37875610.08172504 | 38991703.93127863 | 39277284.17407878
Spreadsheet: 834830d1688112859-how-can-i-list-all-the-corresponding-values-based-on-certain-values-that-appeared-in-anoth-s666-pq-list-all-the-corresponding-values-based-on-certain-values
Sheet: Sheet1

Red | Orange | Yellow | Green | Blue | Navy | Purple | There are upto 50 columns..
[NAME] , [NAME] | Babalola, [NAME] | Brown, Kehau | Abbasi, Imran | Altenbaugh, [NAME] | Abbasi, Imran | [NAME], [NAME]
Adefehinti, Mo | Brown, Kehau | Brown, Kehau | [NAME], [NAME] | Pierce, Karin | King, [NAME] | [NAME], [NAME]
[NAME], [NAME] | Gonring, [NAME] | Etheridge, Christine | Develice, [NAME] | Solanki, Dishal | Pierce, Karin | Drake, [NAME]
Babalola, [NAME] | Khalil, Haydy | Froelich, Sara | Doney, [NAME] |  | [NAME], [NAME] | Platt, Frances
[NAME], [NAME] | [NAME], Lyn | Kieckbusch, [NAME] | [NAME], [NAME] |  | Solanki, Dishal | Schreiner, Trisha
[NAME], Michon | Lewis, Janelle | Kostanyan, Gor | Kieckbusch, [NAME] |  |  | Sokova-Robles, [NAME]
Daigle, Amanda | Michalski, Stacy | [NAME], [NAME] | Linnartz, [NAME] |  |  | Stauceanu, Bogdan
Doney, [NAME] | [NAME], [NAME] |  | [NAME], [NAME]
Doney, [NAME] | Radtke, [NAME] |  | Newcomer, [NAME]
Esalapuram, DIVYA |  |  | Parra, [NAME]
Gonring, [NAME] |  |  | [NAME], Rupal
Hepesh, Wadeda |  |  | Perrotti, Gwen
[NAME], Holly |  |  | Rimarcuk, Jen
Lewis, Janelle |  |  | Schreiner, Trisha
Mabe, Cristal |  |  | Taiwo, Anthonette
Meinen, [NAME] |  |  | [NAME], Rachel
[NAME], [NAME] |  |  | Wagner, [NAME]
Newcomer, [NAME] |  |  | Zeiger, Jessica
Newton, [NAME]
Noonan, [NAME]
Okpara, Chika
Painter, [NAME]
Patwal, Pooja
Spreadsheet: 828902d1683789652-search-a-text-from-an-array-of-values-fetch-object
Sheet: Data

Text | Find Object | Expected Result
1.  Hours and [NAME] (P311221) |  | P311221
1. RMA Revisions - P400511 (ZJDE0001) |  | P400511
6. Preference Profile (R40400) |  | R40400
12. Specify P4113 version to use (Recognize blank LOTS) custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 |  | P4113
2. Enter Version for R04110ZA |  | R04110ZA
1. Enter Version for R47011 : |  | R47011
3.  Enter the version for [NAME] (cvt to .txt) to call.       Blank = Version XBX0002 with the country        code defined here. |  | [NAME]
12. P42101 [NAME] |  | P42101
1. R42565 Version |  | R42565
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: EAST-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | 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 | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
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
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
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
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-EAST
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 69307d1269861854-auto-populate-data-for-roster-eg
Sheet: Daily Roster

 | Mon | [NAME] | Wed | Thurs | Fri
[NAME] | AM | AM | PM | PM | PM
[NAME] | AM | AM | AM | PM | PM
[NAME] | PM | PM | PM | AM | AM
[NAME] | PM | PM | AM | AM | AM
Spreadsheet: 03ce87f5-7d9e-4cea-8016-3dec6bcb740c
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Faculty of Applied Health Sciences
Study Year | Major [NAME] | 1999-00 | 2000-01 | 2001-02 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07* | 2007-08
 | Single | 462 | 541 | 520 | 565 | 773 | 875 | 759 | 659 | 781
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year I | Sub-Total: | 462 | 541 | 520 | 582 | 773 | 875 | 759 | 659 | 781
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0
 | Total: | 462 | 541 | 520 | 582 | 773 | 875 | 759 | 661 | 781
 | Single | 428 | 464 | 549 | 508 | 561 | 880 | 815 | 635 | 573
 | Combined | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year II | Sub-Total: | 429 | 464 | 549 | 508 | 561 | 880 | 815 | 635 | 573
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 7
 | Total: | 429 | 464 | 549 | 508 | 561 | 880 | 819 | 637 | 580
 | Single | 643 | 613 | 691 | 761 | 773 | 715 | 847 | 763 | 671
 | Combined | 1 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Year III | Sub-Total: | 644 | 616 | 692 | 761 | 773 | 715 | 847 | 763 | 671
 | Gen/Integ Studies | 2 | 5 | 4 | 1 | 4 | 4 | 5 | 6 | 8
 | Total: | 646 | 621 | 696 | 762 | 777 | 719 | 852 | 769 | 679
 | Single | 167 | 338 | 420 | 589 | 674 | 540 | 517 | 635 | 591
 | Combined | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Year IV | Sub-Total: | 167 | 338 | 422 | 589 | 674 | 540 | 517 | 635 | 591
 | Gen/Integ Studies | 0 | 0 | 3 | 1 | 1 | 0 | 2 | 4 | 4
 | Total: | 167 | 338 | 425 | 590 | 675 | 540 | 519 | 639 | 595
 | Single | 0 | 33 | 30 | 0 | 0 | 13 | 24 | 14 | 16
 | Combined | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year V | Sub-Total: | 2 | 33 | 30 | 0 | 0 | 13 | 24 | 14 | 16
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 2 | 33 | 30 | 0 | 0 | 13 | 24 | 14 | 16
 | Single | 1700 | 1989 | 2210 | 2440 | 2781 | 3023 | 2962 | 2706 | 2632
 | Combined | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL: | Sub-Total: | 1702 | 1992 | 2213 | 2440 | 2781 | 3023 | 2962 | 2706 | 2632
 | Gen/Integ Studies | 2 | 5 | 7 | 2 | 5 | 4 | 11 | 14 | 19
 | Total: | 1704 | 1997 | 2220 | 2442 | 2786 | 3027 | 2973 | 2720 | 2651
Male |  | 913 | 858 | 923 | 1039 | 1082 | 1177 | 1170 | 1076 | 1094
Female |  | 791 | 1139 | 1297 | 1403 | 1704 | 1850 | 1803 | 1644 | 1557
Full-Time |  | 1609 | 1773 | 1916 | 2114 | 2451 | 2686 | 2684 | 2448 | 2396
Part-Time |  | 102 | 224 | 304 | 328 | 335 | 341 | 289 | 272 | 255
* Tourism removed from Applied Health Sciences starting in 2006-07
Spreadsheet: 869950d1716477866-monthly-calendar-with-recurring-activities-spanning-several-days-monthly-calendar-example
Sheet: Calendar

 | May |  |  |  |  |  | 2024
 | SUNDAY
 |  | 2024-04-29 00:00:00 | 2024-04-30 00:00:00 | 2024-05-01 00:00:00 | 2024-05-02 00:00:00 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00
 |  |  |  | Activity 1 | Activity 1 | Activity 1 | Activity 1
 |  | 2024-05-06 00:00:00 | 2024-05-07 00:00:00 | 2024-05-08 00:00:00 | 2024-05-09 00:00:00 | 2024-05-10 00:00:00 | 2024-05-11 00:00:00
 | Activity 1 | Activity 1 | Activity 1 | Activity 1 | Activity 1 | Activity 2 | Activity 2
 |  | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00 | 2024-05-16 00:00:00 | 2024-05-17 00:00:00 | 2024-05-18 00:00:00
 | Activity 2 | Activity 2 | Activity 2 | Activity 2 | Activity 2 | Activity 2 | Activity 2
 |  |  |  | Activity 3 | Activity 3 | Activity 3 | Activity 3
 |  | 2024-05-20 00:00:00 | 2024-05-21 00:00:00 | 2024-05-22 00:00:00 | 2024-05-23 00:00:00 | 2024-05-24 00:00:00 | 2024-05-25 00:00:00
 | Activity 2 | Activity 4 | Activity 4 | Activity 4 | Activity 4 | Activity 4 | Activity 4
 | Activity 3 | Activity 5 | Activity 5 | Activity 5 | Activity 5
 |  | 2024-05-27 00:00:00 | 2024-05-28 00:00:00 | 2024-05-29 00:00:00 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-01 00:00:00
 | Activity 6 | Activity 6 | Activity 6 | Activity 6 | Activity 6 | Activity 6
 |  | 2024-06-03 00:00:00 | Notes:
Spreadsheet: e8971c04-9cfc-42ba-b1a7-3cb9843cc7d6
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
FLEC | Test | FLEC | Flecainide, Serum | Flecainide, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Plasma, serum gel tube, whole blood | 0.2-1.0 mcg/mL | Monday, Wednesday, Friday; 9:00 a.m. | Same day/1 day | 8 days | 1 | 80299 |  |  |  |  | Rochester
FLEC | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FLEC | Result | 9243 | Flecainide, S | Flecainide, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3638-4
Spreadsheet: 67801d1268323100-using-auto-complete-horizontally-test1
Sheet: Data Interoperability Conf

Date | 2010-02-08 00:00:00
Host/Sponsor | ABCD
Location | Los Angeles, CA
Audience | Data and Information Policy Leaders
Themes | New Challenges and Opportunities for the Enterprise
Notes | None
Past Participation | None
Cost | 225
Org Participation | Person1
Key Personnel | TBD
Spreadsheet: 861020d1709033746-return-true-if-months-match-date-q
Sheet: Sheet1

Amt | [NAME] | Mth | Status |  |  |  |  | Reference Data
-37.92 | sdg | 2024-01-01 00:00:00
-50 | zfsfj | 2024-02-20 00:00:00
-46 | yuk | 2024-02-20 00:00:00
-285.36 | fhd | 2024-03-01 00:00:00
-377.38 | f,fi | 2024-05-01 00:00:00 |  |  |  |  |  | 2024-02-20 00:00:00
-59.99 | iukj | 2024-06-01 00:00:00
-80 | [NAME] | 2024-08-01 00:00:00
-200 | wer | 2024-09-01 00:00:00
-160.68 | ytr | 2024-09-01 00:00:00
-40 | zxcv | 2024-09-01 00:00:00
Spreadsheet: 858313d1707045954-combined-two-operations-result-in-one-summary-sheet-shipment_receipt_report-aligw
Sheet: Feb 2024

 | Sr. No | Offloading Date | BL# / AWB# | Container # | Type | Inv# | Supplier | WH | Unloaded by | Cost
 |  | 2024-02-03 00:00:00 |  | tnsu-2001254 | 1x20ft. Dry | EG-230139 | EVEREST GLOBAL | 901 | Outsource | 275
Spreadsheet: 709762d1608546074-help-with-ipmt-formulas-for-advance-payments-on-a-loan-amortization-schedule-loan-amort-2
Sheet: Sheet1

Loan Amount | 200000
Residual Value | 15000
Annual rate | 0.051 |  | Note: APR is not the same as "Annual rate".  APR calculation might include loan fees, etc
Number of Pmts | 24
 | Payment At The Begining (type=1) |  |  |  |  |  | Payment At The End (type=0)
Payment# | Begin Balance | Payment | Interest | Principal | End Balance |  | Begin Balance | Payment | Interest | Principal | End Balance
1
TOTAL
Start Period | End Period |  | [NAME] | [NAME] |  |  |  |  | [NAME] | [NAME]
1 | 24
Spreadsheet: 23aeab6b-c1bd-4fa5-a7ea-9ff838a086d6
Sheet: 3.5 Table

3.5 Labour productivity
Quarter | 2010–11 | 2011–12 | 2012-13 | 2013-14 | 2014-15
Labour productivity index (a) (b)
September | 93 | 95.1 | 99.1 | 100.9 | 102.8
December | 92.7 | 96.1 | 99.9 | 101.5
March | 93.1 | 97 | 100.4 | 102.1
June | 93.9 | 98.1 | 100.6 | 102.6
Annual average (c) | 96.6 | 100 | 103.675 | 105.85
Quarterly change (from previous quarter) – per cent (d)
September | -0.2 | 1.3 | 1 | 0.3 | 0.2
December | -0.3 | 1.1 | 0.8 | 0.6
March | 0.4 | 0.9 | 0.5 | 0.6
June | 0.9 | 1.1 | 0.2 | 0.4
Annual change (from same quarter of previous year) – per cent (d)
\
September | 0.431965442764585 | 2.258064516129026 | 4.206098843322819 | 1.816347124117065 | 1.883052527254699
December | -0.4296455424274882 | 3.667745415318222 | 3.954214360041635 | 1.601601601601596
March | -0.1072961373390649 | 4.189044038668105 | 3.505154639175263 | 1.693227091633455
June | 0.7510729613733936 | 4.47284345047922 | 2.54841997961264 | 1.988071570576541
Annual average (e) | 0.1 | 3.7 | 3.6 | 1.8
(a) Using trend data.
(b) Reference year for index is 2012-13= 100.0.
(c ) Average for year ending 30 June. Using original data.
(d) Using trend data.
(e) Annual average of year ending 30 June, using original data.
Source: ABS, Australian National Accounts: National Income, Expenditure and Product, Cat. no. 5206.0
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2015-03-04 00:00:00
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: QTD Recon Q2FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended September 30, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 715 |  | 0 |  | 0 |  | 319 |  | 0 |  | 0 |  | 0 |  | 1034
Cost of revenue | 432 |  | -8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 424
Gross profit | 283 |  | 8 |  | 0 |  | 319 |  | 0 |  | 0 |  | 0 |  | 610
Operating expenses:
Marketing and sales | 222 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 216
General and administrative | 88 |  | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 79
Research and development | 318 |  | 0 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 290
Acquisition-related contingent consideration | 17 |  | -17 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 13 |  | -13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | -1 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0
Total operating expenses | 657 |  | -30 |  | 0 |  | 0 |  | 1 |  | -43 |  | 0 |  | 585
Operating income (loss) | -374 |  | 38 |  | 0 |  | 319 |  | -1 |  | 43 |  | 0 |  | 25
Interest and other income (expense), net | -6 |  | 0 |  | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2
Income (loss) before provision for (benefit from) income taxes | -380 |  | 38 |  | 4 |  | 319 |  | -1 |  | 43 |  | 0 |  | 23
Provision for (benefit from) income taxes | -40 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 46 |  | 6
Net income (loss) | -340 |  | 38 |  | 4 |  | 319 |  | -1 |  | 43 |  | -46 |  | 17
Loss per share |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and Diluted | -1.03 |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 0.05
 |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.05
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 331 |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 331
 |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 337
Spreadsheet: 539564d1506244221-finding-lowest-cost-carrier-among-an-arry-sample-5-
Sheet: Sheet1

Monthly Active Premiums
 | Company 1 | Company 2 | Company 3 | Company 4 | Company 5 | Company 6 | Company 7 | Company 8 | Company 9 | Company 10
[NAME] | 613.27 | 17 | 17 | N/A | 300 | 1 | 20145 | 0.3 | 120 | 61.4
[NAME] | 10 | N/A | 2 | N/A | 538.49 | 11 | 0.2 | 300 | 100 | N/A
Silver | 14 | 604.56 | N/A | N/A | 659.66 | 600.94 | 357.04 | 300 | 549.12 | N/A
Gold | 907.17 | 737.33 | 12 | N/A | 397.03 | 99 | 333 | 120 | 15 | N/A
Platinum | 1055.3 | 833.43 | N/A | N/A | 984.8 | 807.06 | 518.52 | N/A | 809.82 | N/A
 | Fails with any tied result |  | Fails with ties in column |  | Works with any ties
Lowest cost: | [NAME] | [NAME]* | [NAME] | [NAME]* | [NAME] | [NAME]*
Price
Carrier
Spreadsheet: 53619d1253560538-concatenate-and-delimiters-redux-case
Sheet: Sheet1

ted smith | 0.01 |  |  | ted smith
[NAME] | 0.01 |  |  | [NAME]
[NAME] | 0.01 |  |  | [NAME]
[NAME] | 0.01 |  |  | [NAME]
[NAME] | 0 |  |  |  |  |  |  |  | ted ,smith ,alice ,brown ,bill ,jones ,mary ,billeci ,hooley ,schell ,terri ,mangelus
hooley schell | 0.02 |  |  | hooley schell
[NAME] | 0.02 |  |  | [NAME]
Spreadsheet: 701524d1603801630-use-count-if-formula-in-a-table-to-fetch-different-values-from-pivot-table-testing-excel
Sheet: Sheet  

 | Count | Type | ROOM | category
 | 1 | CP | ROOM 1 | Plumber |  |  |  | Count of Count | Column Labels |  |  |  |  |  |  | DESIRED
 | 2 | CP | ROOM 1 | Plumber |  |  |  | Row Labels | [NAME] | Doctor | Plumber | Grand Total |  |  |  |  | Plumber | Doctor | [NAME]
 | 3 | FO | ROOM 1 | Plumber |  |  |  | ROOM 1 | 2 | 1 | 3 | 6 |  |  |  | ROOM 1 CP
 | 4 | CP | ROOM 1 | [NAME] |  |  |  | CP | 2 | 1 | 2 | 5 |  |  |  | ROOM 1 FO
 | 5 | CP | ROOM 1 | Doctor |  |  |  | FO |  |  | 1 | 1 |  |  |  | ROOM 2 CP
 | 6 | FO | ROOM 2 | [NAME] |  |  |  | ROOM 2 | 1 |  |  | 1 |  |  |  | ROOM 2 FO
 | 7 | FO | ROOM 3 | Doctor |  |  |  | FO | 1 |  |  | 1 |  |  |  | ROOM 3 CP
 | 8 | FO | ROOM 4 | Plumber |  |  |  | ROOM 3 |  | 1 |  | 1 |  |  |  | ROOM 3 FO
 | 9 | CP | ROOM 4 | Plumber |  |  |  | FO |  | 1 |  | 1 |  |  |  | ROOM 4 CP
 | 10 | CP | ROOM 1 | [NAME] |  |  |  | ROOM 4 |  |  | 2 | 2 |  |  |  | ROOM 4 FO
 |  |  |  |  |  |  |  | CP |  |  | 1 | 1
 |  |  |  |  |  |  |  | FO |  |  | 1 | 1
 |  |  |  |  |  |  |  | Grand Total | 3 | 2 | 5 | 10
Spreadsheet: 716954d1612434903-retrieve-sheet-name-of-specific-text-book1-gk
Sheet: Cons Support

 |  |  | ENGLISH | BILINGUAL | FRENCH
 |  |  | 8002445 | 8002204
 |  |  | 8002578 | 8002030
 |  |  | 8002431 | 8002032
 |  |  | 8002450 | 8002029
 |  |  | 8002443 | 8002035
 |  |  | 8002562 | 8002034
 |  |  | 8002434 | 8002164
 |  |  |  | 8002083
 |  |  |  | 8002106
 |  |  |  | 8002104
 |  |  |  | 8002057
 |  |  |  | 8002061
 |  |  |  | 8002022
Spreadsheet: 154099d1336207219-formula-to-count-specific-text-only-if-a-primary-condition-is-met-using-03-book2
Sheet: Sheet1

Trade | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  | GH | L | C | T
MO | GH | GH | GH | GH |  |  |  |  | L | L |  |  | MO | 9 | 2 | 2 | 0
NO |  | C | C | C | C | C | C |  |  |  |  |  | NO | 0 | 1 | 9 | 10
AMT | GH | GH | GH | GH | GH | T | T | T | T | T |  |  | AMT | 14 | 1 | 6 | 10
MO | C | C |  |  |  | GH | GH | GH | GH | GH
NO | T | T | T | T | T | L
AMT | T | T | T | T | T | L
AMT |  |  |  |  |  |  |  | GH | GH | GH
AMT |  |  |  | C | C | C | C | C | C
AMT |  | GH | GH | GH | GH | GH | GH
NO | T | T | T | T | T |  | C | C | C