tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darron_c_giron__8050__2000
Sheet: January 2000

Done after bid-week:
Telerate/Price Basis/Quotes/Deals/OTC/Pub Posting
Pull up Crude Merc value & update cell E9 |  |  |  |  | Date,F5,%Nxavcprompt,F3
Update following cells from Gas Market Report
 |  | Note: Insert the #'s in blue to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 |  | 27.0142 | 2.19 | 2.36 | 2.18 | 2.18
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 | 27258 | E21728 | 2,500/day | 506767 | 7/95-12/2001
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | 106622 | E11400 | 2,500/day | 506767 | 1/92-12/2003
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | 106624 | E22656 | 7,000/day | 506767 | 1/95-12/2001
CPR# | Sitara # | TAGG # | Southern | Facility | Term | Calculated Price
394674 | 27253 | E21977 | 10,000/day | 506766 | 6/96-4/2002
CPR# | Sitara # | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | 27245 | E20337 | 10,000/day | 58649 | 1/93-12/2002 |  | * moved to Central desk for March
 |  | Last Update:
Spreadsheet: 883183d1731681379-linking-two-sheets-with-data-specific-information-job-book-test-1-jwalden15-
Sheet: Job Book 

Job  Number | Client | Order Number | Job Details | Sample No | Prep | CL | HAC | A/C | MIX | A/S SO3 | W/S SO4 | tS | S2- | MCHW Sulphate Suite | [NAME] | Alkalis | Volhard | Paint | Water | C/S | Other | Date recieved | Due | Reported | Invoiced | Invoice No | Job Turnaround Time | Total Job Cost
22499
22500
22501
22502
22503
22504
22505
22506
22507
22508
22509
22510
22511
 |  | Notes:
Spreadsheet: 98807d1297662059-excel-2007-vlookup-from-a-range-of-numbers-book1
Sheet: IPPT Chart

IPPT Age Category
 | Category | Age
1 | Category X | >24
2 | Category Y | 25-29
Age Group | Grade | Pts | Sit-Up | Standing [NAME] (cm) | [NAME] Up (Reps) | 4x10 m [NAME] (sec) | 2.4km Run-Walk (mins:sec)
 |  |  | (Reps)
CAT X | A | 5 | >39 | >242 | >11 | <10.2 | <10:21
Below 25 Years | B | 4 | 37-39 | 234-242 | 10-11 | 10.2-10.30 | 10:21-11:00
 | C | 3 | 34-36 | 225-233 | 8-9 | 10.4-10.5 | 11:01-11:40
 | D | 2 | 31-33 | 216-224 | 6-7 | 10.6-10.7 | 11:41-12:20
 | E | 1 | 28-30 | 207-215 | 4-5 | 10.8-10.9 | 12:21-13:00
CAT Y | A | 5 | >38 | >238 | >10 | <10.3 | <10:41
25 to 29 Years | B | 4 | 36-38 | 230-238 | 9-10 | 10.3-10.4 | 10:41-11:20
 | C | 3 | 33-35 | 221-229 | 7-8 | 10.5-10.6 | 11:21-12:00
 | D | 2 | 30-32 | 212-220 | 5-6 | 10.7-10.8 | 12:01-12:40
 | E | 1 | 27-29 | 203-211 | 3-4 | 10.9-11.0 | 12:41-13:20
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 7b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Basis | 1102400 | 1990585 | 1845383 | 8195521 | 287688 | 108517 | 171345 | 13701439
Fixed-Float | 66008996 | 12613534 | 16638041 | 73990489 | 3921378 | 3917877 | 10371103 | 187461418
FRA | 27637691 | 9500559 | 26557 | 17422936 | 190817 | 58660 | 3851105 | 58688325
OIS | 20923625 | 5939183 | 112023 | 5823645 | 983014 | 526548 | 656386 | 34964424
Swaption | 6804312 | 970299 | 2281464 | 6011038 | 283541 | 10968 | 222509 | 16584131
OTHER* | 5567956 | 994570 | 282266 | 10198608 | 183669 | 39181 | 251455 | 17517705
TOTAL | 128044980 | 32008730 | 21185734 | 121642237 | 5850107 | 4661751 | 15523903 | 328917442
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 |  |  | -37797 | -39510
2 |  |  | -31170 | -33500
3 |  |  | -34998 | -34553
4 |  |  | -31405 | -37675
5 |  |  | -70684 | -71022
6 |  |  | -55482 | -53290
7 |  |  | -54649 | -54207
8 |  |  | -64238 | -65832
9 |  |  | -56899 | -51220
10 |  |  | -80878 | -83278
11 |  |  | -39218 | -34972
12 |  |  | -75159 | -76610
13 |  |  | -84552 | -83645
14 |  |  | -75573 | -76004
15 |  |  | -76895 | -77595
16 |  |  | -71854 | -71004
17 |  |  | -64280 | -68313
18 |  |  | -19489 | -24368
19 |  |  | -48291 | -48478
20 |  |  | -62451 | -61816
21 |  |  | -88384 | -90931
22 |  |  | -85131 | -86099
23 |  |  | -78019 | -81042
24 |  |  | -55687 | -60271
25 |  |  | -50744 | -50082
26 |  |  | -24808 | -37758
27 |  |  | -112267 | -116020
28 |  |  | -104613 | -114768
29
30
31
index
2001-06-30 00:00:00 |  |  |  |  | 555453.09
2001-07-28 00:00:00
Spreadsheet: 193337d1352806379-trying-to-apply-multiple-entries-with-vlookup-and-use-two-if-statements-adv-comp-project2
Sheet: Estimate Summary 

 | ESTIMATE SUMMARY SHEET
 |  |  |  | Form |  |  |  | Place |  |  |  | Finish |  |  |  | Total
 | Description | VOL (CY) | U.P ($/CY) | Labor | Mat'l | Equip | Total | Labor | Mat'l | Equip | Total | Labor | Mat'l | Equip | Total | Labor | Mat'l | Equip | Total
 | Wall
Spreadsheet: 142834d1330024032-if-then-problem-calendar-of-tasks-template
Sheet: Sheet1

Major [NAME]
Date | Project |  |  |  |  |  |  | Notes | Implementation | Impact | Complete (X) | % Complete
 | Petting Cats |  |  |  |  |  |  |  | Easy | High |  |  | Easy | High
 | Hugging Grandma |  |  |  |  |  |  |  | Hard | Low |  |  | Hard | Low
 | Trimming Trees |  |  |  |  |  |  |  | Easy | High
 | Desanitizing Grandpa |  |  |  |  |  |  |  | Hard | High
 | Plowing Snow |  |  |  |  |  |  |  | Easy | Low
Referral Resource Center |  |  |  |  |  |  |  |  |  |  |  | Complete
2012-01-11 00:00:00 | meet with Dino - get full vision of RRC
 |  | *wanted maps included - what else?
2012-01-18 00:00:00 | get with Sales team - get every ounce of data out of them regarding the info they provide to doctors and where we stand with new information
 |  | *preferrably digital
 |  | *meet with Mike - Physician Liasion Group
2012-01-25 00:00:00 | meet with online team - share with them the plan of action
2012-02-28 00:00:00 | goal to be live
Date | Project |  |  |  |  |  |  | Notes |  |  | Complete (X) | % Complete
Date | Project |  |  |  |  |  |  | Notes |  |  | Complete (X) | % Complete
Date | Project |  |  |  |  |  |  | Notes |  |  | Complete (X) | % Complete
Minor Projects
Date | Project |  |  |  |  |  |  | Notes |  |  | Complete (X) | % Complete
Date | Project |  |  |  |  |  |  | Notes |  |  | Complete (X) | % Complete
Date | Project |  |  |  |  |  |  | Notes |  |  | Complete (X) | % Complete
Adding Pelvic [NAME] to Site |  |  |  |  |  |  |  | Notes |  |  |  | Complete
2012-02-07 00:00:00 | Met with [NAME] to add info to site |  |  |  |  |  |  | under Women's Health/About Our Services |  |  |  | X
2012-02-17 00:00:00 | Will be on site by 2/17 |  |  |  |  |  |  |  |  |  |  | X
Execute Community Go Red Event |  |  |  |  |  |  |  | Notes |  |  |  | Complete
2012-02-02 00:00:00 | Created signage to direct public to auditorium |  |  |  |  |  |  |  |  |  |  | X
2012-02-02 00:00:00 | Created welcome & registration signage |  |  |  |  |  |  |  |  |  |  | X
2012-02-01 00:00:00 | Ordered heart balloons |  |  |  |  |  |  | will be delivered on 2/9/12 |  |  |  | X
2012-02-06 00:00:00 | Cut out Red Dress & Red Shoe handouts |  |  |  |  |  |  |  |  |  |  | X
2012-02-09 00:00:00 | Need to gather flyers to place on tables - 150 of each |  |  |  |  |  |  | Lesley to show me where they are |  |  |  | X
 | Impact
 | Implement |  | High |  |  |  |  | Low
 |  | Easy
 |  | Hard
Spreadsheet: 267066d1379928765-help-course-details-copied-to-another-sheet-using-vlookup-if-statement-example-workbook
Sheet: Data

ID | Name | Course | Status | Date
1 | [NAME] | Beginners | Booked | 2013-09-09 00:00:00
 | [NAME] | Beginners | Booked | 2013-09-09 00:00:00
 | [NAME] | Intermediate | Booked | 2013-09-09 00:00:00
 | [NAME] | Intermediate | Cancelled | 2013-09-09 00:00:00
 | [NAME] | Beginners | Booked | 2013-10-14 00:00:00
 | [NAME] | Beginners | Cancelled | 2013-10-14 00:00:00
Spreadsheet: 440232d1452703404-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2016
Sheet: August

Employee Absence Schedule
August | Dates of Absence
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Hours
A
B
C
D
E
F
G
H
J
K
L
N
O
Spreadsheet: 704196d1605428802-formula-to-fill-down-values-in-column-d-fill_data-ans
Sheet: Sheet1

Sales ID | Sales YR | Sales ($) | Desired Results | FORMULA
1177 | 1999 |  | 18
1177 | 2000 |  | 19
1177 | 2002 | 21 | 21
1177 | 2003 | 22 | 22
1177 | 2004 | 23 | 23
1177 | 2005 | 24 | 24
1177 | 2006 | 25 | 25
1177 | 2007 | 26 | 26
1177 | 2008 | 27 | 27
1177 | 2009 | 28 | 28
1033 | 2002 | 28 | 28
1033 | 2003 | 29 | 29
1033 | 2006 | 32 | 32
1033 | 2007 | 33 | 33
1033 | 2008 | 34 | 34
1033 | 2009 | 35 | 35
1033 | 2010 |  | 36
1055 | 1999 | 49 | 49
1055 | 2000 | 50 | 50
1055 | 2001 | 51 | 51
1055 | 2002 | 52 | 52
1055 | 2003 |  | 53
1055 | 2004 |  | 54
1055 | 2005 |  | 55
1055 | 2006 |  | 56
1055 | 2007 |  | 57
1055 | 2008 |  | 58
1055 | 2009 |  | 59
1055 | 2010 |  | 60
1190 | 2000 | 50 | 50
1300 | 1999
1220 | 1999 |  | 30
1220 | 2000 |  | 31
1220 | 2001 |  | 32
1220 | 2002 |  | 33
1220 | 2003 |  | 34
1220 | 2004 |  | 35
1220 | 2005 |  | 36
1220 | 2006 | 37 | 37
1220 | 2007 | 38 | 38
1220 | 2008 | 39 | 39
1220 | 2009 | 40 | 40
1220 | 2010 | 41 | 41
1220 | 2012 |  | 43
Spreadsheet: d3e676c2-1d09-40c1-bf62-8d50b6ec7fe7
Sheet: Sheet1

Age | Name | Surname | Paid | Unnamed: 4 | To Pay | Unnamed: 6
14 YEARS & OLDER
 | [NAME] | Brandkamp | 71 |  | 1ST
 | [NAME] | [NAME] | 81 |  | 2ND
 | [NAME] | Godfrey | 93 |  | 3RD
 | Lindo | [NAME] | 94
 | Sherwin | Varries | 95
 | [NAME] | Naidoo | 98
 | [NAME] | [NAME] | 99
12 - 13 YEARS
 | Raylin | [NAME] | 79 |  | 1ST | wr
 | [NAME] | Naidoo | 80 |  | 2ND
 | [NAME] | Shaw | 90 |  | 3RD | wr
 | [NAME] | Le Roux | 95
 | Alkin | [NAME] | 96 |  |  | wr
 | [NAME] | [NAME] | 101 |  |  | wr
 | Tyron | Martin | 103 |  |  | wr
10 - 11 YEARS
 | [NAME] | Pienaar | 77 |  | 1ST | wr
 | [NAME] | vd [NAME] | 82 |  | 2ND
 | Cole | [NAME] | 86 |  | 3RD | wr
 | Bradley | Dunbar | 92 |  |  | wr
 | Katleho | Mota | 107
8 - 9 YEARS
 | [NAME] | Weir | 83 |  | 1ST
 | [NAME] | Pienaar | 85 |  | 2ND
 | [NAME] | [NAME] | 88 |  | 3RD
 | Yurav | Premlall | 97
GIRLS
 | Kaiyuree | Moodley G10 | 79 |  | 1ST
 | [NAME] | Mota G10 | 92 |  | 2ND
 | [NAME] | [NAME] | w/d |  | 3RD
7 YEARS
 | Tyla | [NAME] | 52 |  | 1ST
 | [NAME] | [NAME] | 53 |  | 2ND
 | Justin | Fleming 7 | 54 |  | 3RD
6 YEARS & YOUNGER
 | Arnoux | vd Merwe 5 | 40 |  | 1ST
 | [NAME] | Scott 6 | 42 |  | 2ND
 | Manav | Mohanlal 4 | 45 |  | 3RD
Spreadsheet: 128473d1320983272-compare-multiple-columns-with-multiple-sheets-sample-1-1-
Sheet: Sheet1

 |  |  | number | caller | number | receiver
 |  |  | 841122333 | number 1 | 844563219 | number 2
 |  |  | 849456322 | number 3 | 841122333 | number 1
 |  |  | 847896544 | number 4 | 841122333 | number 1
 |  |  | 841122333 | number 1 | 844563219 | number 2
 |  |  | 849456321
 |  |  | 847896543
Spreadsheet: 454499d1459866667-split-the-data-based-on-cell-value-impo
Sheet: AIR

Sl.No | DOC Rec | Supplier | Invoice No | Date | FC | Material | Inv_Value | Mode of Transit | TERM | FCL/LCL | Farwarder | Bl/AWB | Date | Sailled on | Transit Days | Insured Date | ETA | CFS Entry | CHA | BOE No | Date | Steamer Agent | D.O | Duty | CFS Free End | Cleared On
Spreadsheet: 886864d1736959736-robust-index-match-w-non-tabular-data-test-file-1-etaf-1-
Sheet: Sales Report

 |  |  |  | 68 | 67 | 66 | 65 | 64 | 63 | 62 | 61 | 60 | 59 | 58 | 57 | 56 | 55 | 54 | 53 | 52 | 51 | 50 | 49 | 48 | 47 | 46 | 45 | 44 | 43 | 42 | 41 | 40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 32 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16
 |  |  |  |  | 2025-01-18 00:00:00 | 2025-01-11 00:00:00 | 2025-01-04 00:00:00 | 2024-12-28 00:00:00 | 2024-12-21 00:00:00 | 2024-12-14 00:00:00 | 2024-12-07 00:00:00 | 2024-11-30 00:00:00 | 2024-11-23 00:00:00 | 2024-11-16 00:00:00 | 2024-11-09 00:00:00 | 2024-11-02 00:00:00 | 2024-10-26 00:00:00 | 2024-10-19 00:00:00 | 2024-10-12 00:00:00 | 2024-10-05 00:00:00 | 2024-09-28 00:00:00 | 2024-09-21 00:00:00 | 2024-09-14 00:00:00 | 2024-09-07 00:00:00 | 2024-08-31 00:00:00 | 2024-08-24 00:00:00 | 2024-08-17 00:00:00 | 2024-08-10 00:00:00 | 2024-08-03 00:00:00 | 2024-07-27 00:00:00 | 2024-07-20 00:00:00 | 2024-07-13 00:00:00 | 2024-07-06 00:00:00 | 2024-06-29 00:00:00 | 2024-06-22 00:00:00 | 2024-06-15 00:00:00 | 2024-06-08 00:00:00 | 2024-06-01 00:00:00 | 2024-05-25 00:00:00 | 2024-05-18 00:00:00 | 2024-05-11 00:00:00 | 2024-05-04 00:00:00 | 2024-04-27 00:00:00 | 2024-04-20 00:00:00 | 2024-04-13 00:00:00 | 2024-04-06 00:00:00 | 2024-03-30 00:00:00 | 2024-03-23 00:00:00 | 2024-03-16 00:00:00 | 2024-03-09 00:00:00 | 2024-03-02 00:00:00 | 2024-02-24 00:00:00 | 2024-02-17 00:00:00 | 2024-02-10 00:00:00 | 2024-02-03 00:00:00 | 2024-01-27 00:00:00
Prime [NAME] | Prime Item Desc | Data Type | Total to Date |  | 202452 | 202451 | 202450 | 202449 | 202448 | 202447 | 202446 | 202445 | 202444 | 202443 | 202442 | 202441 | 202440 | 202439 | 202438 | 202437 | 202436 | 202435 | 202434 | 202433 | 202432 | 202431 | 202430 | 202429 | 202428 | 202427 | 202426 | 202425 | 202424 | 202423 | 202422 | 202421 | 202420 | 202419 | 202418 | 202417 | 202416 | 202415 | 202414 | 202413 | 202412 | 202411 | 202410 | 202409 | 202408 | 202407 | 202406 | 202405 | 202404 | 202403 | 202402 | 202401
668517480 | A | POS Qty
668517480 | A | POS Sales
668517482 | B | POS Qty
668517482 | B | POS Sales
668517580 | C | POS Qty
668517580 | C | POS Sales
668517583 | D | POS Qty
668517583 | D | POS Sales
Spreadsheet: 2bfa624d-92d1-427d-8873-a2c613cd1ebf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-11-07 09:37:53.540000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.572 | 101.447 | 101.322 | 100.947
4.25 | 100.88 | 100.755 | 100.63 | 100.255 |  | Note: | Refer To Price [NAME]
4.125 | 100.517 | 100.392 | 100.267 | 99.892 |  |  | For all Price Adjs
4 | 100.061 | 99.936 | 99.811 | 99.186
3.875 | 99.499 | 99.374 | 99.249 | 98.624
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.414 | 101.289 | 101.164 | 100.789
3.75 | 100.966 | 100.841 | 100.716 | 100.341
3.625 | 100.649 | 100.524 | 100.399 | 100.024
3.5 | 100.297 | 100.172 | 100.047 | 99.672
3.375 | 99.914 | 99.789 | 99.664 | 99.039
3.25 | 99.4 | 99.275 | 99.15 | 98.525
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-11-21 09:37:53.540000
30 DAY | 2011-12-06 09:37:53.540000
45 DAY | 2011-12-21 09:37:53.540000
60 DAY | 2012-01-05 09:37:53.540000
90 DAY | 2012-02-04 09:37:53.540000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 0d01613b-0efd-4d93-89e0-65f190668ce5
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
CONTINUING EDUCATION ENROLLMENT
UNIVERSITY OF HAWAI‘I, BY CAMPUS
SUMMER 2012
 | CAMPUS |  |  |  | TOTAL
 |  |  |  |  | No. | V%
 |  | TOTAL 1/ ......................................................................................... |  |  | 15256 | 99.99000000000001
 |  | UH Mānoa ................................................................................. |  |  | 4326 | 28.35
 |  |  | Outreach College………………. |  | 1955 | 12.81
 |  |  | Community Service ................................ |  | 2044 | 13.4
 |  |  | Public Events ................................................................................ |  | 327 | 2.14
 |  | UH Hilo ....................................................................................... |  |  | 895 | 5.87
 |  |  | Conference Center ............................. |  | 580 | 3.8
 |  |  | Continuing Education .................................. |  | 227 | 1.49
 |  |  | Senior Programs ...................................... |  | 88 | 0.58
 |  | UH Community Colleges 2/ .................................................. |  |  | 10035 | 65.77000000000001
 |  |  | Hawai‘i ............................................................................... |  | 1497 | 9.81
 |  |  | Honolulu ....................................................................... |  | 2247 | 14.73
 |  |  | Kapi‘olani ......................................................................... |  | 1596 | 10.46
 |  |  | Kaua‘i .................................................................................... |  | 611 | 4
 |  |  | Leeward ....................................................................................... |  | 1295 | 8.49
 |  |  | Maui ........................................................................................... |  | 1906 | 12.49
 |  |  | [NAME] .................................................................................. |  | 883 | 5.79
 |  | 1/  Counts are registration counts, and may include multiple
 |  |  | counting of individuals.
 |  | 2/ ETC program dissolved in December 2010.
 |  | Source: Counts are from the respective campuses and
 |  | compiled by the UH Institutional Research and Analysis
 |  | Office.
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: QTD Recon Q3FY09

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 December 31, 2008
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 1654 |  | 0 |  | 88 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1742
Cost of goods sold | 925 |  | -4 |  | 0 |  | 0 |  | 0 |  | - |  | 0 |  | 921
Gross profit | 729 |  | 4 |  | 88 |  | 0 |  | 0 |  | - |  | 0 |  | 821
Operating expenses:
Marketing and sales | 250 |  | 0 |  | 0 |  | 0 |  | 0 |  | -5 |  | 0 |  | 245
General and administrative | 82 |  | 0 |  | 0 |  | 0 |  | 0 |  | -11 |  | 0 |  | 71
Research and development | 299 |  | 0 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 271
Acquired in-process technology | 1 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 15 |  | -15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Goodwill impairment | 368 |  | -368 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 18 |  | 0 |  | 0 |  | 0 |  | -18 |  | 0 |  | 0 |  | 0
Total operating expenses | 1033 |  | -384 |  | 0 |  | 0 |  | -18 |  | -44 |  | 0 |  | 587
Operating income (loss) | -304 |  | 388 |  | 88 |  | 0 |  | 18 |  | 44 |  | 0 |  | 234
Loss on strategic investments | -27 |  | 0 |  | 0 |  | 27 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 14 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 14
Income (loss) before provision for income taxes | -317 |  | 388 |  | 88 |  | 27 |  | 18 |  | 44 |  | 0 |  | 248
Provision for income taxes | 324 |  |  |  |  |  |  |  |  |  |  |  | -255 |  | 69
Net income (loss) | -641 |  | 388 |  | 88 |  | 27 |  | 18 |  | 44 |  | 255 |  | 179
Loss per share |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -2 |  |  |  |  |  |  |  |  |  | Basic | 0.09 |  |  | 0.56
 |  |  |  |  |  |  |  |  |  |  | Diluted | 0.09 |  |  | 0.56
Number of shares used in computation
Basic and diluted | 321 |  |  |  |  |  |  |  |  |  | Number of shares used in computation
 |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 321
 |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 322
Spreadsheet: 742040d1627487365-combine-two-cell-formula-output-results-in-a-desired-format-fjt-format-question-in-excel-20210728
Sheet: Sheet1 (2)

Format Question in Excel |  | IF [NAME] (Inches Fraction -  Format) | Desired Format | Formula Which Achieves Desired Format
This column | Fraction Portion
is Decimal Inches | of Column A
which are a Multiple | in
1/16 of an Inch | [NAME]
16.4375 |  | 16 - 7/16 | xxx,xxx -  x/xx
32.9375 |  | 32 - 15/16 | xxx,xxx - xx/xx
49.375 |  | 49 - 3/8 | xxx,xxx -   x/x
65.8125 |  | 65 - 13/16 | xxx,xxx - xx/xx
82.3125 |  | 82 - 5/16 | xxx,xxx -  x/xx
98.75 |  | 98 - 3/4 | xxx,xxx -   x/x
115.1875 |  | 115 - 3/16 | xxx,xxx -  x/xx
131.6875 |  | 131 - 11/16 | xxx,xxx - xx/xx
148.125 |  | 148 - 1/8 | xxx,xxx -   x/x
164.5625 |  | 164 - 9/16 | xxx,xxx -  x/xx
395 |  | 395 - 0 | xxx,xxx -     x
[NAME] for Fraction Column B
 |  |  | Possible
 |  |  | Formats
 |  |  | xxx,xxx -     x
 |  |  | xxx,xxx -   x/x
 |  |  | xxx,xxx -  x/xx
 |  |  | xxx,xxx - xx/xx
Spreadsheet: 737383d1624386821-identify-unique-id-across-2-sheets-but-the-unique-id-is-a-formula-not-a-value-test-sheet
Sheet: Sheet1

County | State | Color | Name | Flavor | Dog | Unique ID
Wayne | OH | Yellow | [NAME] | Vanilla | Spot
Greenville | SC | Blue | [NAME] | Chocolate | Rover
Abbington | GA | Red | [NAME] | [NAME] | [NAME]