tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__22736__Turbine Position Report 032301
Sheet: Summary by Region

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Controlling Region
($ MMs) |  |  |  |  |  |  |  | DRAFT
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | STATUS | DASH APPROVAL DATE / STATUS | PROJECT(S) | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION
EECC
 |  |  |  |  | TOTAL EECC
EA
 |  |  |  |  | TOTAL EA
EGM
 | UNITS - TOTAL |  |  |  | GRAND TOTALS
 |  |  |  |  | per Summary By [NAME] report
 |  |  |  |  | Difference
Spreadsheet: 781229d1653068764-using-multiple-columns-to-match-against-a-list-then-multiply-toppingsexcelcostdiff
Sheet: Topping Sales

 |  |  |  |  |  |  |  | Column1 | Column2 | Column3 | <----Difference for total
 |  |  |  |  |  |  |  | Pepperoni | Pizza | 0.09819622811551414
 |  |  |  |  |  |  |  | Soft | Tacos | 0.05595066264269842
 |  |  |  |  |  |  |  | Supreme | Pizza | 0.08367919345821992
 |  |  |  |  |  |  |  | Hard | Tacos | 0.1160930131018405
 |  |  |  |  |  |  |  | Cheese | Pizza | 0.02433348940819248
 |  |  |  |  |  |  |  | Three Cheese | Pizza | 0.02438444082033359
 |  |  |  |  |  |  |  | Softer | Tacos | 0.1642494294338514 |  |  | Goal (Sample)
Type | Topping | Cost | Diff | Newtotal |  |  |  | Chicken | Pizza | 0.03819555353306163 |  |  | Type | Topping | Cost | Diff | Newtotal
Pizza | Pepperoni | 20 |  |  |  |  |  |  |  |  |  |  | Pizza | Pepperoni | 20
Tacos | Soft | 15 |  |  |  |  |  |  |  |  |  |  | Tacos | Soft | 15
Pizza | Supreme | 33 |  |  |  |  |  | Type | Topping | Cost | NewCost |  | Pizza | Supreme | 33
Tacos | Hard | 65 |  |  |  |  |  | Pizza | Cheese | 77 | 78.9 |  | Tacos | Hard | 65
Pizza | Cheese | 77 |  |  |  |  |  | Pizza | Chicken | 120 | 124.6 |  | Pizza | Cheese | 77
Pizza | Three Cheese | 80 |  |  |  |  |  | Pizza | Pepperoni | 20 | 22 |  | Pizza | Three Cheese | 80
Tacos | Softer | 95 |  |  |  |  |  | Pizza | Supreme | 33 | 35.8 |  | Tacos | Softer | 95
Pizza | Chicken | 120 |  |  |  |  |  | Pizza | Three Cheese | 80 | 82 |  | Pizza | Chicken | 120
 |  |  |  |  |  |  |  | Tacos | Hard | 65 | 72.5
 |  |  |  |  |  |  |  | Tacos | Soft | 15 | 15.8
 |  |  |  |  |  |  |  | Tacos | Softer | 95 | 110.6
Spreadsheet: c5e7a10c-7fbd-40f5-93bc-c87375653ba9
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
 |  |  |  | SOL.LICITUD D'AJUT DE TRANSPORT PER A ALUMNES DESOCUPATS PARTICIPANTS EN ACCIONS FORMATIVES PER A COL·LECTIUS VULNERABLES
El Sr. / [NAME].
DNI núm. |  |  |  |  |  | adreça |  |  |  |  |  |  |  |  |  |  |  |  |  | localitat
CP |  |  |  | [NAME] |  |  |  |  | en situació laboral d'atur, i amb la tarjeta de demanda d'ocupació actualitzada a dia d'alta al curs:
 |  | DECLARO QUE:
 |  | En data |  |  |  |  | he [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | núm.
 |  | organitzat pel Centre |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | de
 |  | localitat
 |  | Per això,
 |  | SOL.LICIT que em concedin l'ajut per a transport que estableix l'article 26,1 de l'ordre TAS/718/2008
 |  | de 7 de març (BOE núm. 67 de 18 de març) que desenvolupa el RD 395/2007 de 23 de març que regula
 |  | el subsistema de formació professional per a l'ocupació.
 |  |  |  | Transport corresponent per residència en el mateix municipi.
 |  |  |  | Transport corresponent per residència en diferent municipi.
 |  | Documentació que s'adjunta:
 |  |  |  | Fotocòpia actualitzada de la targeta de demanda d'ocupació el dia d'alta a l'acció formativa
 |  |  |  | DNI / NIE o PASSAPORT (estrangers comunitaris) / PERMÍS DE TREBALL (estrangers no comunitaris)
 |  |  |  | Imprès TG-002.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | , |  | de |  |  |  | de
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signatura
 | Director [NAME]
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 128480 | 128394
2 | 149328 | 149088
3 | 142966 | 142375
4 | 136982 | 136328
5 | 129996 | 129960
6 | 145458 | 145113
7 | 140099 | 139463
8 | 162210 | 160263
9 | 148158 | 147714
10 | 147931 | 147714
11 | 133006 | 132704
12 | 154943 | 155214
13 | 112317 | 111466
14 | 150744 | 150756
15 | 155104 | 155263
16 | 155250 | 155262
17 | 169771 | 171441
18 | 165548 | 172019
19 | 152757 | 152904
20 | 138724 | 138233
21 | 157606 | 157187
22 | 157405 | 155124
23 | 161681 | 160214
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2002-01-31 00:00:00 |  |  | -61603.36 |  |  |  | 530
2002-02-23 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -29617
Spreadsheet: 795827d1662973467-formulas-wanted-to-get-the-first-and-last-columns-where-non-zero-data-appears-get-first-and-last-cols-with-data
Sheet: Sheet1

 | Source: | [NAME]
 | Purpose: | To find the first and last non-blank columns in a table
 |  | Empty cells contain 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOLUTIONS
 | Division | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 |  |  | Months to capture:
 | Collaboration | 0 | 0 | 0 | 2 | 1 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | From:
 | Commercial | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |  | To:
 | Eng | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | H&S | 0 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  | Sol'n #1
 | HR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | (numeric)
 | Mths captured: |  | Jul-22 | Aug-22 | Sep-22 | Nov-22 | Jan-23 | Mar-23 | Apr-23 | May-23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sol'n #2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (text)
Spreadsheet: 73145d1273782409-index-and-match-benefits-1
Sheet: Benefits Sheet

 |  |  |  |  | Date: | 2010-05-13 00:00:00
 |  |  |  |  | Patient:
 |  |  |  |  | Insurance: | Cigna
Unused [NAME] |  |  |  |  |  | Ins | Pt
Today's Visit |  |  |  |  | OS |  | 1
Rem Maximum |  | 0 |  |  | GA |  | 1
Remaining Ded
Proposed Treatment Plan
T# | Code | Description | NCOS Fee | - | Ins Fee | = | IWO | Est Ins Pmt | Est Pt Pmt
 | 7953 | Graft w/Ext. | 386 |  | 267 |  | 119 | 0 | 267 | (Ded)
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
General Anesthesia
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  | 0 |  |  |  | 0 | 0 | 0
 |  | Totals: | 386 |  | 267 |  | 119 | 0 | 267
 |  |  |  |  |  |  | Overmax |  | 0
 |  |  |  |  |  |  | Total Pt Share |  | 267
I authorize the doctor and/or such qualified assignees to preform the services listed above
Patient Signature ___________________________________________   Date ____________________
Financial Arrangements:
Disclaimer: Insurance coverage is estimated. Your actual indemnity may be less. You, the patient, are responsible for all amounts not covered by your inurance carrier. Ultimately, you are responsible for all financial obligations for your health care services. If for some reason the account should become deliqeunt, you agree to pay for all rebilling charges, interest charged, colection costs and attorney fees.
Signature ____________________________________________________   Date ______________________
 | Aetna | BC | Cigna | Delta | Guardian | Humana | 1st Dent | Metlife | UFCW | UC
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 10d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 22234937 | - | 2670745
Cross-Currency Fixed-Fixed | - | 468110 | - | 409864
Cross-Currency Fixed-Float | - | 1956555 | - | 636131
TOTAL | - | 24659602 | - | 3716740
Spreadsheet: 191205d1351968787-how-to-skip-blanks-in-col-b-to-return-list-items-from-col-a-example-attached-ef252_even_easier
Sheet: Sheet1

ITEMS | QTYS | helper |  | DESIRED RESULT
A | 22 | 1 |  | A |  | This formula in C2, copied down:
B |  |  |  | C
C | 3 | 2 |  | F
D |  |  |  | J |  | This formula in E2, copied down:
E |  |  |  | K
F | 56 | 3 |  | L
G |  |  |  | O
H
I
J | 3 | 4
K | 4 | 5
L | 5 | 6
M
N
O | 9 | 7
P
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 12a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending December 14, by product type and cleared status (value of all trades in millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 174567d1345116334-combining-2-workbooks-workbook-1
Sheet: November

 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 31 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 18 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 32 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 19 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-11-11 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-17 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 33 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 20 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-11-18 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-24 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 34 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 21 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
Spreadsheet: 788869d1658770801-formula-t-2022-07-25-oeldere-rexcel548562-sample-file-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Example 1 |  |  |  | Example 2
 |  |  |  |  |  |  |  |  |  | Expected Results |  |  |  | Expected Results
 |  |  |  |  |  | -10 | 10 |  | 5 | 5 |  |  | 2 | 2
 |  |  |  |  |  |  |  |  | -5 | -5 |  |  | -8 | -8
 |  |  |  |  |  |  |  |  | -12 | -12 |  |  | 9 | 9
 |  |  |  |  |  |  |  |  | 15 | -12 |  |  | -9 | -9
 |  |  |  |  |  |  |  |  | 1 | -12 |  |  | 11 | 11
 |  |  |  |  |  |  |  |  | 5 | -12 |  |  | -12 | 11
 |  |  |  |  |  |  |  |  | 20 | -12 |  |  | 5 | 11
 |  |  |  |  |  |  |  |  | 30 | -12 |  |  | -15 | 11
 |  |  |  |  |  |  |  |  | -25 | -12 |  |  | 25 | 11
 |  |  |  |  |  |  |  |  | -1 | -12 |  |  | 30 | 11
Spreadsheet: mike_carson__27600__KOCH
Sheet: Sheet1

 | Power for delivery
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 17.325 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 17.7536 |  | 1
 | Comed | -100 | 17.5 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 14.786 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Total
 |  |  |  |  |  | Net AMT
Spreadsheet: 27802d1221481769-time-into-critera-book7
Sheet: Sheet5

Minutes: | 12345
Days: | 8.572916666666666
Group: | 5-10
Lookup | Reply
0 | 1-5
5 | 5-10
10 | 10-15
15 | 15-30
30 | 30-60
60 | >60
Reference table
Spreadsheet: 96225d1295629227-lookup-with-multiple-sources-test
Sheet: 1000 After

1000
DATE | Data 1 | Data 2
2007-01-01 00:00:00 | 0 | 0
2007-02-01 00:00:00 | 0 | 0
2007-03-01 00:00:00 | 0 | 0
2007-04-01 00:00:00 | 0 | 0
2007-05-01 00:00:00 | 0 | 0
2007-06-01 00:00:00 | 0 | 0
2007-07-01 00:00:00 | 0 | 0
2007-08-01 00:00:00 | 0 | 0
2007-09-01 00:00:00 | 0 | 0
2007-10-01 00:00:00 | 0 | 0
2007-11-01 00:00:00 | 0 | 0
2007-12-01 00:00:00 | 0 | 0
2008-01-01 00:00:00 | 0 | 0
2008-02-01 00:00:00 | 0 | 0
2008-03-01 00:00:00 | 0 | 0
2008-04-01 00:00:00 | 0 | 0
2008-05-01 00:00:00 | 0 | 182930
2008-06-01 00:00:00 | 0 | 232967
2008-07-01 00:00:00 | 0 | 246720
2008-08-01 00:00:00 | 0 | 245726
2008-09-01 00:00:00 | 0 | 253656
2008-10-01 00:00:00 | 0 | 269175
2008-11-01 00:00:00 | 0 | 250779
2008-12-01 00:00:00 | 0 | 260418
2009-01-01 00:00:00 | 0 | 272911
2009-02-01 00:00:00 | 0 | 246172
2009-03-01 00:00:00 | 0 | 261482
2009-04-01 00:00:00 | 0 | 263792
2009-05-01 00:00:00 | 0 | 267221
2009-06-01 00:00:00 | 0 | 275704
2009-07-01 00:00:00 | 0 | 271749
2009-08-01 00:00:00 | 0 | 276344
2009-09-01 00:00:00 | 0 | 259226
2009-10-01 00:00:00 | 0 | 281711
2009-11-01 00:00:00 | 0 | 273722
2009-12-01 00:00:00 | 0 | 284036
2010-01-01 00:00:00 | 0 | 289409
2010-02-01 00:00:00 | 0 | 252947
2010-03-01 00:00:00 | 0 | 301290
2010-04-01 00:00:00 | 0 | 283627
2010-05-01 00:00:00 | 0 | 214423
2010-06-01 00:00:00 | 0 | 273808
2010-07-01 00:00:00 | 0 | 264300
2010-08-01 00:00:00 | 0 | 284575
2010-09-01 00:00:00 | 0 | 276194
2010-10-01 00:00:00 | 0 | 300697
2010-11-01 00:00:00 | 0 | 290235
Spreadsheet: 850868d1701185954-replicate-a-data-set-in-some-cells-from-sheet-1-to-sheet-2-according-to-the-criteria-example-175-aligw
Sheet: Tab1

[NAME] | Company Name | Address | Size | Opportunity | Won/Lost | Value
357 | Mazwell | 44 Stakehigh | Medium | Yes | Won | 35000
697 | Snoopdeek | 357 yeoman | Large | yes | Won | 10500
998 | Hightown | 295 Adscomne | Large | Yes | lost | 25000
996 | Fircrow | 30-  35 easyway | Small | No | N/A | 1000
369 | Niceave | 215 streetnews | Large | yes | Won | 350692
247 | [NAME] | 295 -holfman | Medium | Yes | lost | 45879
367 | Seafood | 357 - reekstreet | Small | Yes | Won | 3000
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: TTM Recon Q2FY11

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 September 30, 2010
 | 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 and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3668 |  | 0 |  | -49 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3619
Cost of revenue | 1537 |  | -10 |  | 0 |  | 2 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1527
Gross profit | 2131 |  | 10 |  | -49 |  | -2 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2092
Operating expenses:
Marketing and sales | 679 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -18 |  | 0 |  | 661
General and administrative | 314 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -40 |  | 0 |  | 274
Research and development | 1153 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -114 |  | 0 |  | 1039
Acquisition-related contingent consideration | -24 |  | 24 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 59 |  | -59 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 128 |  | 0 |  | 0 |  | 0 |  | 0 |  | -128 |  | 0 |  | 0 |  | 0
Total operating expenses | 2309 |  | -35 |  | 0 |  | 0 |  | 0 |  | -128 |  | -172 |  | 0 |  | 1974
Operating income (loss) | -178 |  | 45 |  | -49 |  | -2 |  | 0 |  | 128 |  | 174 |  | 0 |  | 118
Gain on strategic investments | 21 |  | 0 |  | 0 |  | 0 |  | -21 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2
Income (loss) before provison for income taxes | -155 |  | 45 |  | -49 |  | -2 |  | -21 |  | 128 |  | 174 |  | 0 |  | 120
Provision for income taxes | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 32 |  | 34
Net income (loss) | -157 |  | 45 |  | -49 |  | -2 |  | -21 |  | 128 |  | 174 |  | -32 |  | 86
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -0.48 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.26
Spreadsheet: 112339d1308500218-how-to-count-answers-of-respondents-excel-tna-final
Sheet: Sheet2

 | Knowledge | Respondent | Answer
 | Vision | R1 | 4 |  |  |  | Count of Answer | Column Labels
 | Mission | R1 | 4 |  |  |  | Row Labels | 2 | 3 | 4 | Grand Total
 | Core Values | R1 | 4 |  |  |  | Core Values |  |  | 2 | 2
 | Vision | R2 | 2 |  |  |  | Mission |  | 1 | 1 | 2
 | Mission | R2 | 3 |  |  |  | Vision | 1 |  | 1 | 2
 | Core Values | R2 | 4 |  |  |  | Grand Total | 1 | 1 | 4 | 6
Spreadsheet: 125918d1319383667-multiple-matching-and-indexing-with-null-logic-797818-multiple-matching-and-indexing-test
Sheet: 2

pt # | Expected Completion Date
90-2332 | 2011-11-11 00:00:00
90-4523 | 2012-11-25 00:00:00
90-6544 | 2011-12-03 00:00:00
90-3344 | 2011-12-07 00:00:00
90-7754 | 2011-12-15 00:00:00
87-7676 | 2011-12-22 00:00:00
21-311 | 2012-01-03 00:00:00
345-fdbg | 2012-01-14 00:00:00
54-7886 | 2012-01-24 00:00:00
Spreadsheet: 701269d1603675316-looking-for-a-formula-to-count-the-number-of-times-a-specific-value-appears-in-sequence-in-sample-5
Sheet: Master_Dont_Touch

Positive | Negative | False/Fail | 1 | Answer Im Looking for
 | 1 |  |  |  |  | I want to count the number of times Column B has a value, while ignoring the values in Column C , A value I Column A is what halts the sequence. AliGW was good enough to write the formula in yellow for me for a totally different application . I have been trying to get it to work hear with helper rows etc , but Im stuck Answers Im after are in Column E--Thanks in anticipation
1
 |  | 1
 |  | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 5
 |  | 1
 |  | 1
 |  | 1
1
 | 1
 |  | 1
 | 1
 | 1 |  |  |  | 3
1
1
 | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 6
Spreadsheet: 767011d1644237946-best-easiest-way-of-reordering-address-fields-to-populate-a-mandatory-city-field-address-reorder-workbook
Sheet: Desired Output

Address line 1 | Address line 2 | Address line 3 | City | County
Flat 16 | Sapphire Court | Lord Street | Watford | Hertfordshire
Flat 125 | Nine Acre Court | 27 Taylorson Street | Salford | Greater Manchester
Flat 5 | Midsummer Court | 119 Hindes Road | Harrow
Flat 44 | [NAME] | 77 Manor Road | Bournemouth
18 Hertford Avenue |  |  | London
10 Bullfinch Way |  |  | Innsworth
8 Brewery Close |  |  | Stamfordham
467 Lytham Road |  |  | Blackpool
8 [NAME] |  |  | Rossendale
Yallingup | Pilgrims Way |  | Chew Stoke
Oaklea | [NAME] |  | Tittensor
Spreadsheet: 102991d1300852352-calculate-age-retire-date-calculate-age-1-
Sheet: Sheet1

NAME | D,O,B | AGE NOW | RETIREMENT DATE | Days until retirement
A | 1945-06-06 00:00:00 | 65 | 2010-06-05 00:00:00 | -290
F | 1946-03-24 00:00:00 | 64 | 2011-03-23 00:00:00 | 1 |  | Retirement date should be 27/06/2012
B | 1947-06-29 00:00:00 | 63 | 2012-06-28 00:00:00 | 464 |  | Retirement date should be 28/06/2012
C | 1950-06-01 00:00:00 | 60 | 2015-05-31 00:00:00 | 1531
D | 1960-06-01 00:00:00 | 50 | 2025-05-31 00:00:00 | 5184
E | 1980-09-20 00:00:00 | 30 | 2045-09-19 00:00:00 | 12600
Me | 1970-05-13 00:00:00 | 40 | 2035-05-12 00:00:00 | 8817
 | 1990-09-19 00:00:00
Spreadsheet: 161020d1339367481-need-formula-to-list-all-items-that-meet-prerequisite-forumexample
Sheet: Sean Carter

Advertiser | Slogan | Col. | Inch | Total Inches | Color
ABC | test1 | 5 | 8 |  | RED
DEF | test2 | 6 | 9 |  | BLUE
GHI | test3 | 2 | 3 |  | B&W
JKL | test4 | 4 | 10 |  | B&W
Spreadsheet: 293192d1390917750-dependant-list-with-illegal-characters-and-multiple-words-sample-ndm
Sheet: FRA

Division:
No. | Division | Section
1 | Finance | Accounting & Financial Services
 | Energy Efficiency & Renewables | Renewables Technology & Climate
 | Resources | Minerals Productivity
 | ICT | VAN
 | Energy Markets Policy | Governance & Demand Side Policy
 | Corporate | Governance
 | Enterprise & Skills Connect | Network
 | A Industry | Program Delivery Services
 | Science, Research & Innovation | Research Collaboration & International Engagement
 | Skills | Quality & Standards
 | National Institute | Chemical & Biological Metrology
 | A Observatory | Corporate Administration
 | Qcon | Operations
 | SKA Office | Project
 | Industry Economics Group | Resource & Energy Economics
 | Industry | Automotive
 | Business Competitiveness & Trade | Trade & International
Spreadsheet: 54616d1254666491-opening-up-profiles-upon-clicking-on-the-personnels-name-team-attendance
Sheet: Team Data

Team |  |  |  | 1
Team Particulars
[NAME] Theng |  |  |  | [NAME]
[NAME] |  |  | M | [NAME] |  |  | M
Employee No. |  |  | 118137 | Employee No. |  |  | 114220
Job Group |  |  | RSS | Job Group |  |  | 9
Designation |  |  | STL | Designation |  |  | [NAME]
[NAME] |  |  |  | Mukri Moharam
[NAME] |  |  | M | [NAME] |  |  | M
Employee No. |  |  | 115602 | Employee No. |  |  | 154606
Job Group |  |  | 8 | Job Group |  |  | 8
Designation |  |  | [NAME] | Designation |  |  | [NAME]
Khameed [NAME] |  |  |  | [NAME]
[NAME] |  |  | M | [NAME] |  |  | S
Employee No. |  |  | 127292 | Employee No. |  |  | 114200
Job Group |  |  | 7 | Job Group |  |  | 7
Designation |  |  | [NAME] | Designation |  |  | [NAME]
[NAME] |  |  |  |  | S = Single, M = Married
[NAME] |  |  | S
Employee No. |  |  | 126111
Job Group |  |  | 6
Designation |  |  | [NAME]