tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 45141d1243921486-if-statement-simplification-inventory
Sheet: Inventory

 |  |  | CATEGORY |  | PRODUCT |  | PACKAGE TYPE |  | SHIPPING COST |  | NET COST | EBAY FEES |  | ADDON FEES | PAYPAL FEES | TOTAL COST |  |  | LISTING PRICE |  | LISTING S&H |  | LOWEST TOTAL PRICE | TOTAL INFLOW |  | PROFIT | ACTIVE
 |  |  | OTHER |  | 1 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 12.49
 |  |  | ELCTR |  | 2 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.5
 |  |  | COMP |  | 3 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.99
 |  |  | CLOTH |  | 4 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.99
 |  |  | MEDIA |  | 5 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44.99
 |  |  | OTHER |  | 6 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49.99
 |  |  |  |  | 8 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  | 10 Pack Topsy Turvy
 |  |  |  |  | 12 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 139.99
 |  |  |  |  | 24 Pack Topsy Turvy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 239.98
 |  |  |  |  | 48 Pack Topsy Turvy |  |  |  |  |  | 241.68
 |  |  |  |  | [NAME] |  |  |  |  |  | 3.5 |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  | Snuggie |  |  |  |  |  | 7.01 |  |  |  |  |  |  |  |  |  |  |  | 17.25
 |  |  |  |  | 10 2" Net Pots |  |  |  |  |  | 3.95 |  |  |  |  |  |  |  |  |  |  |  | 5.24
 |  |  |  |  | 10 3" Net Pots |  |  |  |  |  | 5.9 |  |  |  |  |  |  |  |  |  |  |  | 7.8
 |  |  |  |  | 1 [NAME] |  | FRS |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  | 8.19
 |  |  |  |  | 10 3.75" Net Pots |  |  |  |  |  | 5.99 |  |  |  |  |  |  |  |  |  |  |  | 8.48
 |  |  |  |  | 10 5" Net Pots |  |  |  |  |  | 9.95 |  |  |  |  |  |  |  |  |  |  |  | 12.45
 |  |  |  |  | 2 [NAME] |  | FR2 |  |  |  | 1.51 |  |  |  |  |  |  |  |  |  |  |  | 13.88
 |  |  |  |  | 6" Net Cup |  |  |  |  |  | 10.95 |  |  |  |  |  |  |  |  |  |  |  | 14.99
 |  |  |  |  | 20 3" Net Pots |  |  |  |  |  | 11.9 |  |  |  |  |  |  |  |  |  |  |  | 15.88
 |  |  |  |  | 168 GPH Sump Pump |  |  |  |  |  | 13.95 |  |  |  |  |  |  |  |  |  |  |  | 17.99
 |  |  | OTHER |  | Hydrofarm 15 Amp 24 Hour Grounded Timer |  |  |  |  |  | 15.95 |  |  |  |  |  |  |  |  |  |  |  | 19.99
 |  |  | OTHER |  | Hydrofarm 7-Day Grounded Digital Timer |  |  |  |  |  | 19.95 |  |  |  |  |  |  |  |  |  |  |  | 30.4
 |  |  | OTHER |  | Hydrofarm 7 Day Dual Outlet Digital Timer |  |  |  |  |  | 19.95 |  |  |  |  |  |  |  |  |  |  |  | 31.33
 |  |  |  |  | Active Air 6" In-Line Booster Fan |  |  |  |  |  | 54.95 |  |  |  |  |  |  |  |  |  |  |  | 73.1
 |  |  |  |  | Active Air 8" In-Line Booster Fan |  |  |  |  |  | 72.95 |  |  |  |  |  |  |  |  |  |  |  | 83.1
 |  |  |  |  | Active Air 10" In-Line Booster Fan |  |  |  |  |  | 94.95 |  |  |  |  |  |  |  |  |  |  |  | 93.1
Spreadsheet: 104096d1301727983-vlookup-index-or-if-report
Sheet: Data

Customer Data
Cust ID | Customer | TOTAL | Booking Amount | Total Balance | Executive
SW2011 | Mr. [NAME] | 100000 | 50000 |  | [NAME]
SW2013 | Dr. [NAME] | 100000 | 50000 |  | [NAME]
SW2012 | Mrs. [NAME] | 100000 | 10000 |  | [NAME]
This will be updated when new customer comes in…..
 |  |  |  |  |  |  | Report to be generated |  |  |  |  | Please help me to generate the following report
Payment Update |  |  |  |  |  |  |  |  |  |  |  | entering the cust ID
Cut ID | Customer | Date | Amount | Status |  |  | SW2012
SW2011 |  | 2011-01-01 00:00:00 | 10000 | Cleared |  |  | Executive
SW2013 |  | 2011-01-01 00:00:00 | 10000 | Cleared
SW2012 |  | 2011-01-01 00:00:00 | 10000 | Cleared |  |  | Date | Amount | status | Balance | Total Paid
SW2011 |  | 2011-02-01 00:00:00 | 10000 | Cleared |  |  | 2011-01-01 00:00:00 | 10000 | Cleared
SW2011 |  | 2011-03-01 00:00:00 | 10000 | Cleared |  |  | 2011-02-01 00:00:00 | 10000 | Cleared
SW2012 |  | 2011-02-01 00:00:00 | 10000 | Cleared |  |  | 2011-03-01 00:00:00 | 10000 | Pending | 70000 | 30000
SW2012 |  | 2011-03-01 00:00:00 | 10000 | Pending
This will update as per the payment…..
Spreadsheet: 176725d1346081377-looking-up-different-data-sets-depending-on-option-selected-example
Sheet: Sheet1

Customer | Department | Product |  | Result
1 | vegetables | A
1 | Fruit | B |  |  |  | Vegetables | A | B | C | D | E | F | G
2 | fresh | C |  |  |  | 1 | 25 | 25 | 25 | 25 | 25 | 25 | 25
3 | frozen | D |  |  |  | 2 | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  | E |  |  |  | 3 | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  | F |  |  |  | 4 | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  | G |  |  |  | 5 | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | 6 | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  | 7 | 46 | 46 | 46 | 46 | 46 | 46 | 46
 |  |  |  |  |  | Fruit | A | B | C | D | E | F | G
 |  |  |  |  |  | 1 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  | 2 | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  | 3 | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  |  |  |  |  | 4 | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  |  |  | 5 | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | 6 | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  | 7 | 46 | 46 | 46 | 46 | 46 | 46 | 46
 |  |  |  |  |  | Fresh | A | B | C | D | E | F | G
 |  |  |  |  |  | 1 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  | 2 | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  | 3 | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  |  |  |  |  | 4 | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  |  |  | 5 | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | 6 | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  | 7 | 46 | 46 | 46 | 46 | 46 | 46 | 46
 |  |  |  |  |  | Frozen | A | B | C | D | E | F | G
 |  |  |  |  |  | 1 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  | 2 | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  | 3 | 31 | 31 | 31 | 31 | 31 | 31 | 31
 |  |  |  |  |  | 4 | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  |  |  | 5 | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  |  | 6 | 18 | 18 | 18 | 18 | 18 | 18 | 18
 |  |  |  |  |  | 7 | 46 | 46 | 46 | 46 | 46 | 46 | 46
Spreadsheet: 125145d1318906006-automatically-update-chart-over-column-testing
Sheet: Chart MEA Quarter (fcst)

MOBILE
Target
Claims
RA Rate (Exclude FAN and LG Display)
Cost per Claim
Target |  |  |  |  |  |  |  |  |  |  |  |  | 65
Spreadsheet: 671267d1586335475-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 01 MONDAY

DAY: |  | MONDAY |  | DATE: | 2020-03-23 00:00:00
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D | EXMPLOYEE |  |  |  | 07:00:00 | 17:00:00 |  |  |  |  | 19900 | 7 |  |  |  |  | 7TON F/L | 5 | 1234 | 8
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 845045d1696601559-lookup-match-2-columns-from-2-pivot-tables-test
Sheet: Sheet1

YN | Part | Qty |  | YN | Part | Sum of Qty |  |  |  | YN | Part | Value |  | YN | Part | Sum of Value
Yes | PartA | 1 |  | No | PartA | 10 |  |  |  | Yes | PartA | 10 |  | No | PartA | 100
No | PartA | 10 |  | No | PartB | 20 |  |  |  | No | PartA | 100 |  | No | PartB | 200
Yes | PartB | 2 |  | Yes | PartA | 1 |  |  |  | Yes | PartB | 20 |  | Yes | PartA | 10
No | PartB | 20 |  | Yes | PartB | 2 |  |  |  | No | PartB | 200 |  | Yes | PartB | 20
Spreadsheet: 716633d1612289590-index-match-combination-issues-supplylistef-dexter2-
Sheet: Results

Invoice | Supply Name |  | Actual
 | Pen's | [NAME]. |  | 1
2001 | Pencil's | General Pencil Co. |  | 2
314 | Crayon's | Crayola |  | 1
4001 | Marker's | Sharpie |  | 1.5
5001 | Paper's | HP |  | 3
6001 | Folders | Staples |  | 0.75
Spreadsheet: 24831224-627d-466d-8f42-16ced77f8298
Sheet: at BRYC - Nov 7

Wednesday, Nov 7, SCHEDULE
Home Club: | BRYC Elite |  | Locations: | Robinson High School
[NAME]: | Loudoun
BRYC Elite wears All BLUE |  |  | http://brycsoccer.com/fielddirections/index_E.html
Loudoun will wear white jersey, black shorts, white socks
Robinson High School
U13G | 6:00pm | [NAME]
U15G | 7:30pm | [NAME]
U14G | 6:00pm | [NAME]
Spreadsheet: 850552d1700918076-i-want-to-lookup-data-in-other-sheets-and-put-them-each-in-a-seperate-row-in-the-same-col-2023-sponsor-data-4-1-2-1-
Sheet: Students vocational

Edukid ID | Student | Preferred Name | Sponsored (under fee programme) YES/NO (if yes, please do not place under half-price kiokit or law firm.) | SEND Children (put 'yes' next to SEND children) | SEND | Half Price ([NAME]/law firm etc) | School | AGE |  | DOB | Additional Information | Image Reference | Additional Photos | what are you most excited to achieve this school year? | what are you most proud of yourself ? | who is your role model and why? | what is your aspiration for your future? | How would you change the world if you could?
UG1008 | [NAME] | [NAME] |  |  |  |  | Bobi Commmunity Polytechnic | 19 | Year one | 2002-07-01 00:00:00 |  | UG1008 |  | I want to excel in my studies. | I am most proud of my building skills. | My parents because they care for me so well. | I aspire to become a professional building engineer | I would encourage everyone to be peaceful
Spreadsheet: 477619d1472412477-how-to-highlight-multiple-cells-based-off-a-value-fantasy-football
Sheet: QB

RK | Player | Pos | Team | Bye
1 | [NAME] | QB | GB | 4
2 | [NAME] | QB | SEA | 5
3 | [NAME] | QB | CAR | 7
4 | [NAME] | QB | NE | 9
5 | [NAME] | QB | IND | 10
6 | [NAME] | QB | NO | 5
7 | B. Roethlisberger | QB | PIT | 8
8 | E. Manning | QB | NYG | 8
9 | [NAME] | QB | ARZ | 9
10 | P. Rivers | QB | SD | 11
11 | [NAME] | QB | DAL | 7
12 | [NAME] | QB | BUF | 10
13 | [NAME] | QB | WAS | 9
14 | [NAME] | QB | JAC | 5
15 | [NAME] | QB | DET | 10
16 | [NAME] | QB | ATL | 11
17 | [NAME] | QB | OAK | 10
18 | [NAME] | QB | CIN | 9
19 | [NAME] | QB | CHI | 9
20 | [NAME] | QB | TB | 6
21 | M. Mariota | QB | TEN | 13
22 | [NAME] | QB | NYJ | 11
23 | [NAME] | QB | MIA | 8
24 | [NAME] | QB | KC | 5
25 | [NAME] | QB | BAL | 8
26 | [NAME] | QB | MIN | 6
27 | [NAME] | QB | HOU | 9
28 | [NAME] | QB | CLE | 13
29 | [NAME] | QB | PHI | 4
30 | [NAME] | QB | SF | 8
31 | [NAME] | QB | SF | 8
32 | [NAME] | QB | LAR | 8
33 | [NAME] | QB | NE | 9
34 | T. Siemian | QB | DEN | 11
35 | [NAME] | QB | DEN | 11
36 | [NAME] | QB | PHI | 4
37 | [NAME] | QB | DEN | 11
Spreadsheet: 784033d1655375101-data-extracting-sorting-and-organizing-book2
Sheet: Sheet2

Always starting with Sheet1 column D: Fields ([NAME] sorted and renaming dups WITHIN a record.) [NAME] has two "TEL;TYPE=CELL"
TEL;CELL | TEL;TYPE=HOME;TYPE=FAX | TEL;TYPE=PAGER | TEL;WORK;FAX
EMAIL;TYPE=WORK | NICKNAME | ORG | TEL;TYPE=AnotherCustom | TEL;TYPE=CELL | TEL;TYPE=CELL(2) | TEL;TYPE=Custom | TEL;TYPE=HOME | TEL;TYPE=HOME;TYPE=FAX | TEL;TYPE=PAGER | TEL;TYPE=PREF | TEL;TYPE=VOICE | TEL;TYPE=WORK | TEL;TYPE=WORK;TYPE=FAX | TITLE
[NAME] for ALL records
EMAIL;TYPE=WORK | NICKNAME | ORG | TEL;CELL | TEL;TYPE=AnotherCustom | TEL;TYPE=CELL | TEL;TYPE=CELL(2) | TEL;TYPE=Custom | TEL;TYPE=HOME | TEL;TYPE=HOME;TYPE=FAX | TEL;TYPE=PAGER | TEL;TYPE=PREF | TEL;TYPE=VOICE | TEL;TYPE=WORK | TEL;TYPE=WORK;TYPE=FAX | TEL;WORK;FAX | TITLE
 |  | [NAME] for ALL records
 |  | EMAIL;TYPE=WORK
 |  | NICKNAME
 |  | ORG
 |  | TEL;CELL
 |  | TEL;TYPE=AnotherCustom
 |  | TEL;TYPE=CELL
 |  | TEL;TYPE=CELL(2)
 |  | TEL;TYPE=Custom
 |  | TEL;TYPE=HOME
 |  | TEL;TYPE=HOME;TYPE=FAX
 |  | TEL;TYPE=PAGER
 |  | TEL;TYPE=PREF
 |  | TEL;TYPE=VOICE
 |  | TEL;TYPE=WORK
 |  | TEL;TYPE=WORK;TYPE=FAX
 |  | TEL;WORK;FAX
 |  | TITLE
Spreadsheet: f9bef6a7-8696-4b30-9192-ccc3d6258f4f
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
800071 | Test | 800071 | [NAME] coli Antigen, Feces | [NAME] coli Ag, F | Enzyme-Linked Immunosorbent Assay (ELISA) | Stool Container: Stool |  |  | 10 | g | Submit only 1 of the following specimens:   Preserved Stool Container/Tube: Culture and sensitivity media [NAME]: 10 g of diarrheal (liquid or loose gives optimal results) stool Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Specimen Stability Information: Refrigerate/Ambient NO/Frozen NO   Unpreserved Stool Collection Container/Tube: Stool container Submission Container/Tube: Plastic container [NAME]: 10 g of unpreserved diarrheal (liquid or loose gives optimal results) stool Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Specimen Stability Information: Frozen/Refrigerate <48 hours OK/Ambient NO | 2 g | Specimens other than	Feces Anticoagulants other than	15 mL of non-nutritive  transport medium containing phenol red as a pH indicator Hemolysis	NA Thawing	Fresh: Warm reject; Cold OK - note to lab In media: Warm reject; Cold reject Lipemia	NA Icterus	NA O | Negative | Monday through Saturday | 2 days | 3 days | 1 | 87427 |  |  |  |  | Jacksonville
800071 | [NAME] | FECES | Feces |  |  |  | See instructions
800071 | Result | 800071 | [NAME] coli Ag, F | [NAME] coli Ag, F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53946-0
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: QTD Recon Q2FY11

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, 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 | 631 |  | 0 |  | 253 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 884
Cost of revenue | 363 |  | -3 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 361
Gross profit | 268 |  | 3 |  | 253 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 523
Operating expenses:
Marketing and sales | 173 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 167
General and administrative | 77 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -10 |  | 0 |  | 67
Research and development | 277 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -27 |  | 0 |  | 250
Acquisition-related contingent consideration | -28 |  | 28 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 15 |  | -15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 6 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 0 |  | 0
Total operating expenses | 520 |  | 13 |  | 0 |  | 0 |  | 0 |  | -6 |  | -43 |  | 0 |  | 484
Operating income (loss) | -252 |  | -10 |  | 253 |  | -1 |  | 0 |  | 6 |  | 43 |  | 0 |  | 39
Gain on strategic investments | 28 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 6
Income (loss) before provision for (benefit from) income taxes | -218 |  | -10 |  | 253 |  | -1 |  | -28 |  | 6 |  | 43 |  | 0 |  | 45
Provision for (benefit from) income taxes | -17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 13
Net income (loss) | -201 |  | -10 |  | 253 |  | -1 |  | -28 |  | 6 |  | 43 |  | -30 |  | 32
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.61 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.1
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 329 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 329
 |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 333
Spreadsheet: 681844d1591785146-quotation-spreadsheet-test-2-
Sheet: Quotation

 | Your Company Name |  |  |  | Quotation
 | Your Company Slogan |  |  |  | DATE
 | Street Address |  |  |  | Quotation # | 100
 | City, State ZIP Code |  |  |  | Customer ID | ABC123
 | Phone: Enter Phone number here   Fax: Enter Fax number here
 | Quotation For: |  |  |  | Quotation valid until:
 | Name |  |  |  | Prepared by: | Name
 | Company Name
 | Street Address
 | City, ST  ZIP Code
 | Phone
 | Comments or Special Instructions: |  | None
 | SALESPERSON | P.O. NUMBER | SHIP DATE | SHIP VIA | F.O.B. POINT | TERMS
 |  |  |  |  |  | Due on receipt
 | QUANTITY | [NAME] |  | UNIT PRICE | TAXABLE? | AMOUNT
 | 34 | Item 1 |  | 44 | T
 |  |  |  |  | SUBTOTAL
 |  |  |  | Discount | 5
 |  |  |  | SALES TAX | 10
 |  |  |  | OTHER | 0.05
 |  |  |  |  | TOTAL
 | If you have any questions concerning this quotation, contact name, phone number, e-mail.
 | THANK YOU FOR YOUR BUSINESS!
Spreadsheet: 45917d1244695877-two-way-lookup-sample
Sheet: Matrix

Product | eMen | [NAME] | Blanca | Mstar | Wassum | Hymans | Hewitt | API | CBA | AC
LCG | 4 | 5 | 2 | 3 | 1 | 2 | 3 | 2 | 1 | 10
SCG | 1 | ? | ?
I need to be able to fill in the red numbers with some type of formula.
I have a large amount of data similar to what you see on the 'raw data' sheet.  It is not practical for me to do it manually.
Spreadsheet: kate_symes__18840__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
Spreadsheet: 142761d1330004911-search-2-columns-return-data-in-different-row-copy-of-formula
Sheet: Sheet1

Hi - needing some help with a formula - I have several columns taken from sage data. I have in one column employees hours and another employees name, as you can see sometimes employees name appears more than once. what I am needing is in another row is employee name who was working on the job to appear and all their hours beside their name. Would be greatful for your help
A | B | C | D
hours | rate | cost | employee
13.5 | 8 | 108 | SMITH
0.5 | 6.85 | 3.43 | JONES
0.5 | 6.85 | 3.43 | JONES
1.5 | 6.75 | 10.13 | SMITH
1 | 6.75 | 6.75 | SMITH
17 |  | 131.74
employee | total hours
SMITH | 16
JONES | 1
Sum of hours
employee | Total
JONES | 1
SMITH | 16
Grand Total | 17
Spreadsheet: 837616d1690292827-matching-two-lists-of-postcodes-example-2
Sheet: Sheet1

 |  |  | Addresses | Location |  |  |  | City Centre | Suburbs | Town Centre | Outskirts
 |  |  | M27 6AS |  |  |  |  | M30 0BF | M3 1AA | M28 1AD | M7 0ED
 |  |  | M30 0NB |  |  |  |  | M30 0ES | M3 5BY | M28 1DD | M7 1AJ
 |  |  | M6  6JZ |  |  |  |  | M30 0FB | M3 5EH | M28 1EB | M7 1AX
 |  |  | M27 9TT |  |  |  |  | M30 0FP | M3 5FE | M28 1ET | M7 1BF
 |  |  | M27 5WY |  |  |  |  | M30 0FW | M3 5FW | M28 1FG | M7 1BQ
 |  |  | M38 9PH |  |  |  |  | M30 0GD | M3 5GQ | M28 1FT | M7 1GY
 |  |  | M27 5WY
 |  |  | M44 6FE
Spreadsheet: 851918d1702041888-formula-to-change-text-color-if-2-criteria-are-met-ticket-tracking
Sheet: 3B2 Comments

 | Ticket Number | Priority / Emergency | Ticket Created Date | Resolution Time in days:hrs:min | Comments
Spreadsheet: juan_hernandez__17714__CinergyHourlyTradesReport
Sheet: Sheet1

Into Cinergy Peak Hourly Trades
Trans. Date:
Hour Ending | Wacop | Total Volume | Low | High
0700
0800
0900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
2200
Spreadsheet: 745917d1630363176-help-with-sumproduct-formula-that-contains-text-and-numbers-over-multiple-tables-t3-bvj-1-
Sheet: STAFF ROOMS

HOUSE | TYPE | ROOM | PRICE |  |  |  |  | House | Type | Basement | Ground | 3 | 4 | 5
Market Place | Single | 1 |  |  |  |  |  | Compston | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | Kirkwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | Brinwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 80 | 90 | 91 | 92 | 93
 |  |  |  |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | Market Place | Single | 70 | 80 | 90 | 100 | 110 |  |  | Compston | Kirkwood | Brinwood | Market Place
 |  |  |  |  |  |  |  | Compston | Double | 80 | 90 | 91 | 92 | 93 |  |  | Basement | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5