tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7470__MARKET2001
Sheet: OCT01

 |  |  |  | PERCENT
POI | SCHEDULED | ACTUAL | DEVIATION | [NAME]
71374 | 892 | 840
71393 | 2210 | 2312
71461 | 2530 | 2683
71463 | 1805 | 2106
71464 | 731 | 2146
71465 | 413 | 398
71466 | 145 | 110
TOTAL
Spreadsheet: 61442d1262285338-pulling-from-one-sheet-to-another-based-on-date-dc
Sheet: Income Statement

Personal Income Statement
 | January | February | March | April | May | June | July | August | September | October | November | December | Yr. Total
Income
Work
Investment Income
Other
EBIT
Taxes
federal
State
Local
Interest Paid
source
source
source
Total Income
Utilities
Gas
Electric
Trash
Water
Phone
Car Expenses
Gasoline
Insurance
Car Maintenance
Rent Expense
Rent
Improvements
Furniture
Other Expenses
Food
Entertainment
Clothing
Investment activities
Cigarettes
Gym
Total Expenses
Net Income
Spreadsheet: 70808d1271501465-printing-cell-contents-as-a-header-on-all-pages-stmaster_apr10
Sheet: Logos 1

Logo Options 1
Embroidery
Logo Position |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Stitch No | Hoop |  |  |  |  | Notes
[NAME] | Test |  |  | 20000 |  |  |  |  |  | full up
Right Breast |  |  |  | 0 |  |  |  |  |  | Test
Back | Test |  |  | 0 |  |  |  |  |  | Test
Left Sleeve |  |  |  | 0 |  |  |  |  |  | Test
Right Sleeve |  |  |  | 0 |  |  |  |  |  | Test
 |  |  | Total | 20000
Printing
Logo Position
 |  |  |  | Cost £ | Notes
Front | Test |  |  | 2 | off
Right Breast | Test |  |  | 3 | Test
Back | Crown thing |  |  | 4 | Test
Lower back | SA2010 |  |  | 0 | Test
Right Sleeve | [PHONE] |  |  | 0 | Test
[NAME] | TE |  |  | 0 | Test
 |  |  | Total | 9
Spreadsheet: 45777d1244576781-formula-giving-undesired-result-state-codes_1
Sheet: Sheet1

S.No | State Names | Codes | Text Files | Possible Text File
1 | Andaman & Nicobar Islands | 35 | AHQ.1 | N.A
2 | Andhrapradesh | 28 | AHQ. 2 | N
3 | Arunchal Pradesh | 12 | AHQ. 3 | N
4 | Assam | 18 | AHQ. 4 | N
5 | Bihar | 10 | AHQ. 5 | N
6 | Chandigarh | 4 | AHQ. 6 | N
7 | Chhattisgarh | 22 | AHQ. 7 | N
8 | Dadar & Nagar Haveli | 26 | AHQ. 8 | N
9 | Daman&Diu | 25 |  | N
10 | Delhi | 7 |  | N
11 | Goa | 30 |  | N
12 | Gujarat | 24 |  | N
13 | [NAME] | 6 |  | N
14 | Himachal Pradesh | 2 |  | N
15 | Jammu and Kashmir | 1 |  | N
16 | Jharkhand | 20 |  | N
17 | Karnataka | 29 |  | N
18 | Kerala | 32 |  | N
19 | Lakshadweep | 31 |  | N
20 | Madhya Pradesh | 23 |  | N
21 | Maharashtra | 27 |  | N
22 | Manipur | 14 |  | N
23 | Meghalya | 17 |  | N
24 | Mizoram | 15 |  | N
25 | Nagaland | 13 |  | N
26 | [NAME] | 21 |  | N
27 | [NAME] | 1 |  | N
28 | Punjab | 3 |  | N
29 | [NAME] | 8 |  | N
30 | Sikkim | 11 |  | N
31 | [NAME] | 33 |  | N
32 | Tripura | 16 |  | N
33 | Uttaranchal | 5 |  | N
34 | Uttar Pradesh | 9 |  | N.A
35 | West Bengal | 19 |  | N
Spreadsheet: 859488d1707857389-formula-to-sum-a-range-of-rows-and-columns-based-on-a-criteria-book1
Sheet: Sheet1

 | 00:00:00 | 02:00:00 | 04:00:00 | 06:00:00 | 08:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 18:00:00 | 20:00:00 | 22:00:00
2024-01-01 00:00:00 | 56.6188 | 56.6188 | 56.6188 | 56.6188 | 56.6188 | 56.6188 | 45.2944 | 56.6188 | 45.2944 | 56.6188 | 33.9711 | 22.6477
2024-01-02 00:00:00 | 56.6188 | 67.9421 | 67.9421 | 67.9421 | 56.6188 | 67.9421 | 67.9421 | 67.9421 | 56.6188 | 67.9421 | 56.6188 | 33.9711 |  |  |  | time from>> | 04:00:00
2024-01-03 00:00:00 | 56.6188 | 67.9421 | 67.9421 | 67.9421 | 67.9421 | 67.9421 | 67.9421 | 56.6188 | 67.9421 | 67.9421 | 67.9421 | 45.2944 |  |  |  | time to>> | 14:00:00
2024-01-04 00:00:00 | 56.4762 | 56.4762 | 56.4762 | 67.771 | 56.4762 | 56.4762 | 45.1803 | 56.4762 | 45.1803 | 33.8855 | 45.1803 | 33.8855 |  |  | From | To
2024-01-05 00:00:00 | 56.3336 | 67.5999 | 67.5999 | 67.5999 | 67.5999 | 67.5999 | 67.5999 | 67.5999 | 56.3336 | 67.5999 | 67.5999 | 67.5999 |  | Date: | 2024-01-05 00:00:00 | 2024-01-08 00:00:00 | formula???
2024-01-06 00:00:00 | 45.2944 | 33.9711 | 33.9711 | 45.2944 | 33.9711 | 33.9711 | 33.9711 | 33.9711 | 33.9711 | 33.9711 | 45.2944 | 33.9711
2024-01-07 00:00:00 | 56.6188 | 45.2944 | 45.2944 | 56.6188 | 45.2944 | 45.2944 | 56.6188 | 56.6188 | 67.9421 | 67.9421 | 56.6188 | 45.2944
2024-01-08 00:00:00 | 68.1133 | 68.1133 | 68.1133 | 68.1133 | 68.1133 | 56.7614 | 68.1133 | 68.1133 | 68.1133 | 68.1133 | 68.1133 | 68.1133
2024-01-09 00:00:00 | 56.7614 | 68.1133 | 56.7614 | 68.1133 | 68.1133 | 56.7614 | 68.1133 | 56.7614 | 56.7614 | 56.7614 | 56.7614 | 45.4085
2024-01-10 00:00:00 | 56.6188 | 67.9421 | 67.9421 | 67.9421 | 67.9421 | 67.9421 | 67.9421 | 56.6188 | 67.9421 | 67.9421 | 67.9421 | 67.9421
2024-01-11 00:00:00 | 45.1803 | 56.4762 | 45.1803 | 45.1803 | 56.4762 | 45.1803 | 45.1803 | 56.4762 | 56.4762 | 56.4762 | 45.1803 | 45.1803
2024-01-12 00:00:00 | 56.7614 | 45.4085 | 34.0566 | 45.4085 | 22.7048 | 34.0566 | 45.4085 | 34.0566 | 34.0566 | 34.0566 | 45.4085 | 34.0566
2024-01-13 00:00:00 | 45.5226 | 45.5226 | 34.1422 | 56.9041 | 68.2844 | 56.9041 | 68.2844 | 68.2844 | 68.2844 | 56.9041 | 68.2844 | 68.2844
2024-01-14 00:00:00 | 34.2278 | 34.2278 | 45.6367 | 45.6367 | 57.0467 | 57.0467 | 57.0467 | 45.6367 | 34.2278 | 57.0467 | 68.4556 | 34.2278
2024-01-15 00:00:00 | 45.6367 | 45.6367 | 45.6367 | 45.6367 | 45.6367 | 45.6367 | 45.6367 | 34.2278 | 45.6367 | 45.6367 | 45.6367 | 34.2278
Spreadsheet: 55968d1256126638-getting-values-of-scatter-example
Sheet: Sheet1

1e-15 | 33.96
2e-15 | 33.27
3e-15 | 32.86
4e-15 | 32.58
5e-15 | 32.35
6e-15 | 32.17
7e-15 | 32.02
8e-15 | 31.88
9e-15 | 31.76
1e-14 | 31.66
2e-14 | 30.97
3e-14 | 30.56
4e-14 | 30.27
5e-14 | 30.05
6e-14 | 29.87
7e-14 | 29.71
8e-14 | 29.58
9e-14 | 29.46
1e-13 | 29.36
2e-13 | 28.66
3e-13 | 28.26
4e-13 | 27.97
5e-13 | 27.75
6e-13 | 27.56
7e-13 | 27.41
8e-13 | 27.28
9e-13 | 27.16
1e-12 | 27.05
2e-12 | 26.36
3e-12 | 25.96
4e-12 | 25.67
5e-12 | 25.44
6e-12 | 25.26
7e-12 | 25.11
8e-12 | 24.97
9e-12 | 24.86
1e-11 | 24.75
2e-11 | 24.06
3e-11 | 23.65
4e-11 | 23.36
5e-11 | 23.14
6e-11 | 22.96
7e-11 | 22.81
8e-11 | 22.67
9e-11 | 22.55
1e-10 | 22.45
2e-10 | 21.76
3e-10 | 21.35
4e-10 | 21.06
5e-10 | 20.84
6e-10 | 20.66
7e-10 | 20.5
8e-10 | 20.37
9e-10 | 20.25
1e-09 | 20.15
2e-09 | 19.45
3e-09 | 19.05
4e-09 | 18.76
5e-09 | 18.54
6e-09 | 18.35
7e-09 | 18.2
8e-09 | 18.07
9e-09 | 17.95
1e-08 | 17.84
2e-08 | 17.15
3e-08 | 16.74
4e-08 | 16.46
5e-08 | 16.23
6e-08 | 16.05
7e-08 | 15.9
8e-08 | 15.76
9e-08 | 15.65
1e-07 | 15.54
2e-07 | 14.85
3e-07 | 14.44
4e-07 | 14.15
5e-07 | 13.93
6e-07 | 13.75
7e-07 | 13.6
8e-07 | 13.46
9e-07 | 13.34
1e-06 | 13.24
2e-06 | 12.55
3e-06 | 12.14
4e-06 | 11.85
5e-06 | 11.63
6e-06 | 11.45
7e-06 | 11.29
8e-06 | 11.16
9e-06 | 11.04
1e-05 | 10.94
2e-05 | 10.24
3e-05 | 9.84
4e-05 | 9.55
5e-05 | 9.33
6e-05 | 9.14
7e-05 | 8.99
8e-05 | 8.86
9e-05 | 8.74
0.0001 | 8.63
0.0002 | 7.94
0.0003 | 7.53
0.0004 | 7.25
0.0005 | 7.02
0.0006 | 6.84
0.0007 | 6.69
0.0008 | 6.55
0.0009 | 6.44
0.001 | 6.33
0.002 | 5.64
0.003 | 5.23
0.004 | 4.95
0.005 | 4.73
0.006 | 4.54
0.007 | 4.39
0.008 | 4.26
0.009 | 4.14
0.01 | 4.04
0.02 | 3.35
0.03 | 2.96
0.04 | 2.68
0.05 | 2.47
0.06 | 2.3
0.07 | 2.15
0.08 | 2.03
0.09 | 1.92
0.1 | 1.82
0.2 | 1.22
0.3 | 0.91
0.4 | 0.7
0.5 | 0.56
0.6 | 0.45
0.7 | 0.37
0.8 | 0.31
0.9 | 0.26
Spreadsheet: d54d441a-718a-4958-aa5a-f9ec1a7a9ddd
Sheet: Segment Information

 | MATTEL, INC. AND SUBSIDIARIES
 | SEGMENT INFORMATION
 |  |  |  | 2 0 1 1 |  | 2 0 1 2
 | (In millions) |  |  | 1 Qtr |  | 1 Qtr
 | Revenues by Segment
 | North America |  | $ | 508.8 | $ | 451.6
 | International |  |  | 453.8 |  | 484
 | American Girl |  |  | 78.5 |  | 81.6
 | Gross Sales |  |  | 1041.1 |  | 1017.2
 | [NAME] |  |  | -89.2 |  | -88.8
 | Net Sales |  | $ | 951.9 | $ | 928.4
 | Operating Income by Segment
 | North America |  | $ | 84.5 | $ | 64
 | International |  |  | 37.2 |  | 39.3
 | American Girl |  |  | 3 |  | 1.4
 |  |  |  | 124.7 |  | 104.7
 | Corporate and other expense |  |  | -87.9 |  | -76
 | Operating Income |  | $ | 36.8 | $ | 28.7
 | The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 821809d1678904029-formula-in-one-if-left-vlookup-query1
Sheet: A

 | code | Name
 | 11 | January
 | 12 | February
 | 13 | March
 | 14 | April
 | 15 | May
 | 16 | June
 | 17 | July
 | 18 | August
 | 19 | September
 | 20 | October
Spreadsheet: 172ae265-a1b1-494a-b4af-3a60ad161c38
Sheet: Disability codes

SFY 2015 FEDERAL CODE SHEET
SFY 2015 FEDERAL EDRS-SERVS-UFARS codes crosswalk
UFARS Program Code to EDRS Disability Code
UFARS PROGRAM CODE | EDRS DISABILITY CODE | [NAME]
401 | 401 | Speech or Language Impairments
402 | 402 | Developmental Cognitive Disability - Mild -Moderate
403 | 403 | Developmental Cognitive Disability - Severe-Profound
404 | 404 | Physically Impaired
405 | 405 | Deaf and Hard of Hearing
406 | 406 | Visually Impaired
407 | 407 | Specific Learning Disability
408 | 408 | Emotional or Behavioral Disorders
409 | 409 | Deaf-Blind
410 | 410 | Other Health Disabilities
411 | 411 | Autism Spectrum Disorders
412 | 412 | Developmentally Delayed
414 | 414 | Traumatic Brian Injury
416 | 416 | Severely Multiply Impaired
420 | 420 | Special Education - Aggregate (3 or more Disabilities)
422 | 422 | Non-Disabled (no IEP/IFSP/IIIP) (use FSC Z CEIS and FSC z MCEIS only)
end of worksheet
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 6185 | 772 | 6024 | 13203 | 31269 | 11182 | 14626 | 834 | 84095
Spreadsheet: 2a3f50c2-730e-4a8d-bc4b-2ee331b99b1a
Sheet: Sheet1

NSDI Training Program: Training Materials Inventory | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Module Name / Subject Area:
Inventoried by:
Title | Contact Organization | URL or filename | vers. date (yyyymmdd) | format | Add link from training page?
 |  |  |  | select one | no
Contact Name:
Contact Email:
Relevant Topics:
Description:
Comments / Value:
 |  |  |  | select one | no
Contact Name:
Contact Email:
Relevant Topics:
Description:
Comments / Value:
 |  |  |  | select one | no
Contact Name:
Contact Email:
Relevant Topics:
Description:
Comments / Value:
 |  |  |  | select one | no
Contact Name:
Contact Email:
Relevant Topics:
Description:
Comments / Value:
 |  |  |  | select one | no
Contact Name:
Contact Email:
Relevant Topics:
Description:
Comments / Value:
Spreadsheet: 465431d1465646437-calculate-unique-names-and-repeted-names-test
Sheet: Sheet1

Row Labels | Count of SIRE NAME
ALTAAGENCY | 4
ALTAANTRIM | 8
ALTAARMANI | 7
ALTAARMSTEAD | 7
ALTAAVALON | 9
TUNIS | 7
TWISTER | 6
ULTRAFOX | 1
URSUS | 2
VACHIM | 1
VAN DE VEN | 1
WATSON | 1
WIN 395 | 1
WINCEL | 1
YANKEE | 3
[NAME] | 2
Grand Total | 61
Spreadsheet: 685785d1594196073-split-5-parameters-separated-by-and-into-series-of-columns-pq-5-parameter-test-aligw
Sheet: Result

Product | 1.1 | 1.2 | 1.3 | 2.1 | 2.2 | 2.3 | 3.1 | 3.2 | 3.3 | 4.1 | 4.2 | 4.3 | 5.1 | 5.2 | 5.3
101 | 0219A | 0219B | 0219C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
102 | 0220A | 0220B | 0220C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
103 | 0221A | 0221B | 0221C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
Product | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | 2.1 | 2.2 | 2.3 | 2.4 | 2.5 | 3.1 | 3.2 | 3.3 | 3.4 | 3.5 | 4.1 | 4.2 | 4.3 | 4.4 | 4.5 | 5.1 | 5.2 | 5.3 | 5.4 | 5.5
101 | 0219A | 1 | January | PC | 4 | 0219B | 3 | February | PC | 2 | 0219C | 2 | March | PM | 2 | 0219C | 2 | March | PM | 2 | 0219C | 2 | March | PM | 2
102 | 0220A | 1 | January | PC | 4 | 0220B | 3 | February | PC | 2 | 0220C | 2 | March | PM | 2 | 0220C | 2 | March | PM | 2 | 0220C | 2 | March | PM | 2
103 | 0221A | 1 | January | PC | 4 | 0221B | 3 | February | PC | 2 | 0221C | 2 | March | PM | 2 | 0221C | 2 | March | PM | 2 | 0221C | 2 | March | PM | 2
Spreadsheet: 147105d1332526470-excel-2003-move-rows-to-adjacent-spreadsheets-based-on-cell-criteria-regulatory-compliance-report-f2012
Sheet: Data

AMF | Maureen | [NAME] | Action Required
FCAC | [NAME] | [NAME] | Question to Answer
Potential | Clarence | [NAME] | Too Late to Fix
Automatic | Bev | [NAME] | Quality
 |  | [NAME] | Feedback Only
 |  | [NAME]
 |  | [NAME]
 |  | Paulette Verni
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Rose Tamburello
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Catalina Loo
 |  | [NAME]
 |  | Danijela Petrovic
 |  | [NAME]
 |  | [NAME]
 |  | Philipe Simao
 |  | Clarence Layne
 |  | [NAME]
 |  | [NAME]
 |  | Yve De Moor
 |  | Christina Pucci
 |  | [NAME]
 |  | Sheriel Sinclair
 |  | Shirleen Brown
 |  | [NAME]
Spreadsheet: 127345d1320317657-daverage-with-no-headings-its-killing-my-head-averageifs_marciopf
Sheet: Sheet1

 |  |  |  |  |  | Example for 2007 |  |  |  | Example for 2003
 | Tree | Height | Age | Profit |  | Tree | Age | Profit |  | Tree | Min Age | Profit
 | Apple | 18 | 20 | 105 |  | Apple | >=9 |  |  | Apple | 9
 | Pear | 12 | 12 | 96 |  | Pear | >=9 |  |  | Pear | 9
 | [NAME] | 13 | 14 | 105 |  | [NAME] | >=9 |  |  | [NAME] | 9
 | Apple | 14 | 15 | 75
 | Pear | 9 | 8 | 76.8
 | Apple | 8 | 9 | 45
 | Apple | 8 | 14 | 39
 | Pear | 3 | 10 | 47
 | [NAME] | 8 | 13 | 10
 | Apple | 12 | 7 | 60
 | Pear | 10 | 6 | 58
 | Apple | 8 | 10 | 23
 | Apple | 5 | 4 | 33
 | Pear | 8 | 3 | 26
 | [NAME] | 11 | 2 | 46
Spreadsheet: joe_quenet__15087__PJM
Sheet: DJ PJM Electricity Index

 | DATE |  |  |  | Firm On Peak |  | MW |  | [NAME]
 | 2001-10-26 00:00:00 |  |  |  | 30.13 |  | 2950 |  | 47200
 | 2001-10-25 00:00:00 |  |  |  | 26.75 |  | 2350 |  | 37600
 | 2001-10-24 00:00:00 |  |  |  | 26.31 |  | 1950 |  | 31200
 | 2001-10-23 00:00:00 |  |  |  | 24.48 |  | 2150 |  | 34400
 | 2001-10-22 00:00:00 |  |  |  | 25.31 |  | 1350 |  | 21600
 | 2001-10-21 00:00:00
 | 2001-10-20 00:00:00
 | 2001-10-19 00:00:00 |  |  |  | 25.5 |  | 1250 |  | 20000
 | 2001-10-18 00:00:00 |  |  |  | 26.93 |  | 2600 |  | 41600
 | 2001-10-17 00:00:00 |  |  |  | 25.28 |  | 2750 |  | 44000
 | 2001-10-16 00:00:00 |  |  |  | 26.48 |  | 900 |  | 14400
 | 2001-10-15 00:00:00 |  |  |  | 26.31 |  | 1050 |  | 16800
 | 2001-10-14 00:00:00
 | 2001-10-13 00:00:00
 | 2001-10-12 00:00:00 |  |  |  | 23.51 |  | 2100 |  | 33600
 | 2001-10-11 00:00:00 |  |  |  | 23.98 |  | 1350 |  | 21600
 | 2001-10-10 00:00:00 |  |  |  | 25.31 |  | 1800 |  | 28800
 | 2001-10-09 00:00:00 |  |  |  | 28.25 |  | 1800 |  | 28800
 | 2001-10-08 00:00:00 |  |  |  | 29.17 |  | 3850 |  | 61600
 | 2001-10-07 00:00:00
 | 2001-10-06 00:00:00
 | 2001-10-05 00:00:00 |  |  |  | 28.6 |  | 1950 |  | 31200
 | 2001-10-04 00:00:00 |  |  |  | 28.93 |  | 1350 |  | 21600
 | 2001-10-03 00:00:00 |  |  |  | 27.5 |  | 900 |  | 14400
 | 2001-10-02 00:00:00 |  |  |  | 26.01 |  | 1000 |  | 16000
 | 2001-10-01 00:00:00 |  |  |  | 24.71 |  | 2050 |  | 32800
 | 2001-09-30 00:00:00
 | 2001-09-29 00:00:00
 | 2001-09-28 00:00:00 |  |  |  | 23.73 |  | 3450 |  | 55200
 | 2001-09-27 00:00:00 |  |  |  | 24.58 |  | 3200 |  | 51200
 | 2001-09-26 00:00:00 |  |  |  | 25.14 |  | 3600 |  | 57600
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: QTD Recon Q2FY10

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, 2009
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 788 |  | 0 |  | 359 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1147
Cost of goods sold | 593 |  | -3 |  | 0 |  | 0 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 592
Gross profit | 195 |  | 3 |  | 359 |  | 0 |  | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 555
Operating expenses:
Marketing and sales | 187 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -5 |  | 0 |  | 182
General and administrative | 91 |  | 0 |  | 0 |  | -14 |  | 0 |  | 0 |  | 0 |  | -10 |  | 0 |  | 67
Research and development | 316 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -29 |  | 0 |  | 287
Amortization of intangibles | 12 |  | -12 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 0 |  | 0
Total operating expenses | 612 |  | -12 |  | 0 |  | -14 |  | 0 |  | 0 |  | -6 |  | -44 |  | 0 |  | 536
Operating income (loss) | -417 |  | 15 |  | 359 |  | 14 |  | -2 |  | 0 |  | 6 |  | 44 |  | 0 |  | 19
Loss on strategic investments | -8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 8 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 7 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7
Income (loss) before provision for (benefit from) income taxes | -418 |  | 15 |  | 359 |  | 14 |  | -2 |  | 8 |  | 6 |  | 44 |  | 0 |  | 26
Provision for (benefit from) income taxes | -27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 7
Net income (loss) | -391 |  | 15 |  | 359 |  | 14 |  | -2 |  | 8 |  | 6 |  | 44 |  | -34 |  | 19
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -1.21 |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic | 0.09 |  |  | 0.06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted | 0.09 |  |  | 0.06
Number of shares used in computation
Basic and diluted | 324 |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 324
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 325
Spreadsheet: 05ccdf94-8999-4bae-b24f-15bcd4b21742
Sheet: Sheet1

COUNTY | A-EIN | B-FR | C-NAME OF ORGANIZATION | D-CONTINUATION NAME | E-CHAPTER NAME | F-CARE OF NAME | G-ADDRESS | H-CITY | I-ST | J-ZIP | K-UPDATES
 | 434454576 | 1 | 4-H CLUBS &  AFFILIATED 4-H | ORGANIZATIONS | BOX BUTTE COUNTY 4-H | % BRIAN SMITH | 415 BLACK HILLS AVE | ALLIANCE | NE | 693013243153
 | 470792323 | 2 | 4-H CLUBS &  AFFILIATED 4-H | ORGANIZATIONS | FOOTHILLS DROVERS 4-H CLUB | % JANE DOE | 2331 H RD | SHELTON | NE | 688769566900
Spreadsheet: mary_fischer__25619__77L
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077L
COMPANY NAME   PBM Mechanical Inc.
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Billings in excess |  | -2178258 |  | -2272927 |  |  |  | -155403
Gen Liability Ins - moved to 620 |  | -148868 |  | 148868
Worker's Comp Ins - moved to 620 |  | -110000 |  | 110000
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 546817d1510221774-search-for-a-formula-search-for-a-formula-book1
Sheet: Sheet1

ALC | AVI | 300
ALC | BAL | 1022
ALC | BEL | 406
ALC | BUR | 873
ALC | CAN | 28
ALC | CHA | 1207 |  |  | ALC | CAN
ALC | GSA | 610
ALC | HLV | 532
ALC | JAX | 1369
ALC | LCA | 1851
ALC | NOR | 541
ALC | NYC | 688
ALC | PCN | 1425
ALC | PTM | 497
ALC | PTTUP | 5
ALC | RHA | 1490
ALC | SYD | 139
ALC | TAG | 532
ALC | TAM | 1490
ALM | HLV | 0
ALM | NEW | 951
ALT | ALT | 1
ALT | PAS | 370
CAN | ALC | 55
Spreadsheet: 218966d1362623826-formula-check-counting-the-number-of-0s-in-a-array-test3_eajustin15-ver1
Sheet: Sheet1

1 | Active
1 | Active
1 | Active
1 | Active
1 | Active
1 | Active
3 | Active
1 | Active
4 | Active
1 | Active |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | 2012-08-01 00:00:00
0 | current |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End | 2013-08-01 00:00:00
0 | current
0 | current |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 |  |  | Aug YTD
0 | current |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 9 month without activity
 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 822990d1679634014-listing-the-winner-s-of-a-golf-skin-in-separate-cell-money-hole-formula-2-
Sheet: Sheet2

Player | CC |  | TL |  | CR |  | SH |  |  | WINNERS OF CC
A | 5 |  |  |  | 5 |  | 5
B
C
D
E
F
G
As you can see above, the winners for Round 1 (column B) were players B, C, D, and F because they all have a score less than a "4". I would love a formula that automatically places them under WINNERS over on the right.
Spreadsheet: elizabeth_sager__9479__E-delivery spreadsheet
Sheet: Scenarios

Based on the previous scenario the following assumptions were made for the cost of the internet and intranet packages
 |  |  | Scenario 1 (High-Low - 1st user $5,000 |  |  | Scenario 2 (Med-High - 1st user $3,000, |  |  |  | Scenario 3 (Med-Med - 1st user $3,000
 |  |  | Subsequent user $100 each |  |  | Subsequent User $500 each |  |  |  | Subsequent user $300 each
 |  |  | Intranet package $10,000 each) |  |  | Intranet package $10,000 each) |  |  |  | Intranet package $12,500 each)
Primary Members
Internet package (74)* | No. of users
33 | 1
18 | 2 - 5 | 3.5
11 | 6 - 10 | 8
7 | 11 - 20 | 15.5
5 | 21 - 30 | 25.5
Intranet package (32)*** |  |  |  | 320000 |  |  | 320000
Associate Members
Internet package  (42)**
19 | 1
10 | 2 - 5 | 3.5
7 | 6 - 10 | 8
4 | 11 - 20 | 15.5
2 | 21 - 30 | 25.5
Intranet package (14)**** |  |  |  |  |  |  | 140000
25% of 1999 Rev
Total publication Rev
* Of 212 Primary members assume 35% will buy on internet
** Of 141 Associate members assume 30% will buy on internet
*** Of 212 Primary members assume 15% will buy intranet package
**** Of 141 Associate members assume 10% will buy intranet package |  |  |  |  |  | High - Low | Med - High | Low - Low
 | Point of indifference for intranet package ( number of internet users) |  |  |  |  | 51 | 15 | 33
Spreadsheet: 118051d1313411229-extracting-data-from-multiple-sheets-in-to-one-example-packing-list
Sheet: 1075

 | CLOTHING PACKING LIST
 | I EUROPE LTD
 | CUSTOMER NAME: |  |  | Alive & Dirty Ltd
 | ADDRESS
 | ORDER NO. |  |  | UCLAW11 - 1075
 | INVOICE NO
 | AGENT NAME |  |  | [NAME]
 | REPEAT CONF. |  |  | 2011-07-15 00:00:00
 | CUST.PO
 | NO. OF CARTON |  |  | 1
 | STYLE | NO | CRTN NO | COLOUR | XS | S | M | L | XL | XXL | TOTAL | BX TOTAL
 | UCLG | RAYS-701 | 13267 | Peacoat | 0 | 2 | 4 | 8 | 4 | 2 | 20 | 20
 |  |  |  |  |  |  |  |  |  |  |  | 20