tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a7b4ae9d-4f0e-4765-abc4-1ee78310fffd
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
POU | Test | POU | Phosphorus, [NAME] | Phosphorus, U | Molybdic Acid | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options  Ambient	Yes Refrigerate	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	Yes Thymol	Yes | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <1,100 mg/specimen | Monday through Saturday | 1 day | 3 days | 1 | 84105 |  |  |  |  | Rochester
POU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
POU | Order Question | TM12 | Collection Duration |  | Plain Text
POU | Order Question | VL10 | [NAME] |  | Plain Text
POU | Result | POUU | Phosphorus, U | Phosphorus, U | Numeric |  |  |  |  | mg/spec |  |  |  |  |  |  |  |  |  | 2779-7
POU | Result | TM12 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9
POU | Result | VL10 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4
POU | Result | PHOCN | P Concentration | P Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 21458-5
Spreadsheet: 789152d1658930962-split-dollar-amount-into-different-amounts-based-on-percentage-copy-of-invoice-approval-splits-bg-sfy-2022
Sheet: Program Supplies--FPP Only

 |  |  |  | USPIRITUS INVOICE APPROVAL FORM
 |  | Person  Requesting |  |  |  | Date
 |  | Supervisor Approval
 | General [NAME]
 | GL | Fund | Department | Event | Location | Grant | Restriction | Amount
 | 8115 | 01 | 481 | N000 | 31 | 35 | 1
 | 8115 | 01 | 482 | N000 | 31 | 35 | 1
 | 8115 | 01 | 483 | N000 | 31 | 35 | 1
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  |  |  |  |  |  | TOTAL | 18.16
 | NOTES:
Spreadsheet: 887131d1737292967-countif-sumif-help-test1
Sheet: Sheet1

WHAT I WANT IT TO LOOK LIKE
Invoice # | Billable? | Amount | Total Yes
1 |  | 2000 | 1000
1 | Yes | -1000
1 | No | -1000
2 |  | 1500 | 1500
2 | Yes | -1000
2 |  | -500
3 |  | 2000 | 2000
3 | Yes | -2000
4 |  | 6000 | 4000
4 | Yes | -4000
4 | No | -2000
Spreadsheet: 716550d1612267285-how-to-show-upper-and-lower-tolerance-levels-from-dimension-in-one-cell-example-tolerance-table
Sheet: Sheet1

 |  | No | Dimension | Upper Tolerance | Lower Tolerance | Actual | Pass/Fail | Comments
 |  | 1 | 5.3
 |  | 2 | 45.2
 |  | 3 | 36.6
 |  | 4 | 1.2
 |  | 5 | 6
 |  | 6 | 130
 |  | 7 | 63.5
 |  | 8 | 50.5
 |  | Tolerance table
 |  | Dimension | 0.1 to 6 | 6 to 30 | 30 to 120 | 120 to 400
 |  | Tolerance | ±0.1 | ±0.2 | ±0.3 | ±0.5
Spreadsheet: 36017d1233762371-how-to-separate-first-and-last-names-entered-in-one-cell-into-two-different-cells-name-20separator-1-
Sheet: Sheet1

 |  |  | What I have: |  |  |  |  |  | What I want:
 |  |  | Name | lastName | firstName | midInit |  |  | lastName | firstName | midInit
 |  |  | Doe,[NAME] | Doe | [NAME] | A |  |  | Doe | [NAME] | A
 |  |  | Smith, [NAME] | Smith | Adam | C |  |  | Smith | Adam | C
 |  |  | Franklin, [NAME] | Franklin | [NAME] | B |  |  | Franklin | [NAME] | B
 |  |  | Jones, [NAME] | Jones | John | P. |  |  | Jones | [NAME] | P
 |  |  | Washington, [NAME] | Washington | George | R |  |  | Washington | George | R.
Spreadsheet: 695756d1600375499-countifs-function-book1
Sheet: Sheet2

 |  |  |  |  | 1//1/2020 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
2020-01-01 00:00:00 | Apple |  |  | Apple
2020-01-01 00:00:00 | Apple |  |  | Orange
2020-01-01 00:00:00 | Orange |  |  | Pear
2020-01-01 00:00:00 | Pear
2020-02-01 00:00:00 | Apple
2020-02-01 00:00:00 | Apple
2020-02-01 00:00:00 | Orange
2020-02-01 00:00:00 | Pear
2020-02-01 00:00:00 | Apple
2020-03-01 00:00:00 | Apple
2020-03-01 00:00:00 | Orange
2020-03-01 00:00:00 | Pear
2020-03-01 00:00:00 | Apple
2020-03-01 00:00:00 | Apple
2020-03-01 00:00:00 | Orange
2020-04-01 00:00:00 | Pear
2020-04-01 00:00:00 | Apple
2020-04-01 00:00:00 | Apple
2020-04-01 00:00:00 | Orange
2020-04-01 00:00:00 | Pear
Spreadsheet: 164480d1340790203-grouping-similar-numbers-in-a-row-onecoltoseveral
Sheet: Sheet1

Filename | In row | In column | Coordinate |  |  |  |  |  | Coordinate 2
1107000.jpg | 1 | 1 | 10001 |  |  |  |  |  | 10001
1107004.jpg | 1 | 2 | 10002 |  |  |  |  |  | 10002
1107005.jpg | 1 | 3 | 10003 |  |  |  |  |  | 10003
1108500.jpg | 2 | 1 | 20001 |  |  |  |  |  | 20001
1108503.jpg | 2 | 2 | 20002 |  |  |  |  |  | 20002
1108504.jpg | 2 | 3 | 20003 |  |  |  |  |  | 20003
1108505.jpg | 2 | 4 | 20004 |  |  |  |  |  | 20004
1108509.jpg | 2 | 5 | 20005 |  |  |  |  |  | 20005
1108510.jpg | 2 | 6 | 20006 |  |  |  |  |  | 20006
1108511.jpg | 2 | 7 | 20007 |  |  |  |  |  | 20007
 |  |  |  |  |  | See Sheet 2 for reformatted table.
Spreadsheet: 547039d1510309178-cf-saturdays-sundays-and-holidays-cal
Sheet: l

2017-01-01 00:00:00
Spreadsheet: 875581d1722188877-how-to-make-index-work-after-drag-solved-test
Sheet: август

№ | 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
 |  | DARK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 737722d1624553754-calculate-amount-used-by-weight-serial-number-and-date-calculate-by-weight-used-sample
Sheet: Sheet1

 | Serial Number | Date | Weight | Amount Used |  |  | Serial Number | Date | Weight | Amount Used
 | A | 2021-06-01 13:00:00 | 120 | ? |  |  | A | 2021-06-01 13:00:00 | 120 | 0
 | B | 2021-06-01 13:10:00 | 120 | ? |  |  | B | 2021-06-01 13:10:00 | 120 | 0
 | A | 2021-06-01 14:00:00 | 110 | ? |  |  | A | 2021-06-01 14:00:00 | 110 | 10
 | A | 2021-06-01 14:10:00 | 105 | ? |  |  | A | 2021-06-01 14:10:00 | 105 | 5
 | A | 2021-06-01 14:30:00 | 100 | ? |  |  | A | 2021-06-01 14:30:00 | 100 | 5
 | B | 2021-06-02 12:00:00 | 110 | ? |  |  | B | 2021-06-02 12:00:00 | 110 | 10
 | C | 2021-06-02 13:00:00 | 120 | ? |  |  | C | 2021-06-02 13:00:00 | 120 | 0
 | C | 2021-06-02 13:30:00 | 115 | ? |  |  | C | 2021-06-02 13:30:00 | 115 | 5
 | B | 2021-06-02 14:00:00 | 102 | ? |  |  | B | 2021-06-02 14:00:00 | 102 | 8
 | B | 2021-06-02 14:30:00 | 101 | ? |  |  | B | 2021-06-02 14:30:00 | 101 | 1
 | A | 2021-06-03 15:00:00 | 95 | ? |  |  | A | 2021-06-03 15:00:00 | 95 | 5
 | D | 2021-06-04 13:00:00 | 120 | ? |  |  | D | 2021-06-04 13:00:00 | 120 | 0
 | D | 2021-06-04 17:00:00 | 100 | ? |  |  | D | 2021-06-04 17:00:00 | 100 | 20
Spreadsheet: 274979d1383301749-sumproduct-indirect-array-containing-both-ors-and-ands-example
Sheet: Overview

 | Test Named [NAME] (sheet name)
 | example1
 | example2 |  |  | Criteria 1 | 11111
 | example3 |  |  | [NAME] | 2017 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | Expected Result | 1650 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | OR | AND | AND |  |  |  | The ORs |  |  |  |  |  |  | 1
SUMPRODUCT | IF {M4:M22} = E3     SUM {N4:N22} | {U4:U22} = E4 | {V4:V22} | = 1650 |  |  |  |  |  |  |  |  |  | 1
 | IF {O4:O22} = E3     SUM {O4:O22} |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | IF {Q4:Q22} = E3     SUM {R4:R22} |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | IF {S4:S22} = E3     SUM {T4:T22} |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | The first And |  | Thanks to [NAME] |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | My way |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | This is how I think it should be written, and fitted into the above OR |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 860224d1708412946-help-with-vlook-up-and-data-validation-google-sheet-exercise
Sheet: Worksheet 1

Name | Bike Type | Day | Date | Time | Status | [NAME] | Phone
Customer 5 | Mountain bike |  | 2030-01-18 00:00:00 | 16:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 7 | Road bike |  | 2030-01-08 00:00:00 | 11:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 13 | Mountain bike |  | 2030-01-03 00:00:00 | 13:30:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 3 | Gravel bike |  | 2030-01-10 00:00:00 | 14:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 15 | Mountain bike |  | 2030-01-11 00:00:00 | 16:00:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 10 | Gravel bike |  | 2030-01-09 00:00:00 | 13:30:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 6 | Road bike |  | 2030-01-04 00:00:00 | 14:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 19 | Road bike |  | 2030-01-19 00:00:00 | 09:30:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 9 | Road bike |  | 2030-01-16 00:00:00 | 14:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 14 | Mountain bike |  | 2030-01-07 00:00:00 | 09:30:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 11 | Gravel bike |  | 2030-01-17 00:00:00 | 16:00:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 1 | Gravel bike |  | 2030-01-02 00:00:00 | 11:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 4 | Gravel bike |  | 2030-01-14 00:00:00 | 11:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 17 | Road bike |  | 2030-01-05 00:00:00 | 16:00:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 8 | Road bike |  | 2030-01-12 00:00:00 | 16:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 16 | Mountain bike |  | 2030-01-15 00:00:00 | 13:30:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 2 | Gravel bike |  | 2030-01-06 00:00:00 | 16:45:00 | COMPLETED | [EMAIL] | (555)-555-5555
Customer 18 | Road bike |  | 2030-01-13 00:00:00 | 09:30:00 | CONFIRMED | [EMAIL] | (555)-555-5555
Customer 12 | Mountain bike |  | 2030-01-01 00:00:00 | 09:30:00 | CONFIRMED | [EMAIL] | (555)-555-5555
 |  | Status | Count
 |  | CONFIRMED
 |  | COMPLETED
 |  | Utilization Total
This is a datasheet for bike utilization monitoring.
1 | INSTRUCTIONS: [NAME] 1
 | Freeze and format the cell, font should be in [NAME]; fill cell A1 to H1 color should be blue.
 | Create a filter that will sort the Bike Types in column B.
2 | INSTRUCTIONS: Set up conditional formatting
 | Set up conditional formatting so that the "Status" column (column F) shows:
 | Yellow for "CONFIRMED" and [NAME] for "COMPLETED"
3 | INSTRUCTIONS: Create a formula to fill in the missing data in cells D25 to D27
 | Use the COUNTIF formula in cells D25 & D26
 | Use SUM for the Utilization Total
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 370HG

370HG
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-10-25 00:00:00 |  |  | JAD | 2010-10-25 00:00:00 |  |  | JAD |  | 2010-06-21 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
[NAME] will be leaving Honor Guard December 3rd, we will need to get a new 68 for this account. -A1C Yates, 15Nov10
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: a617d055-94f3-48f5-9baa-54e5bb023c01
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
 | Project Name: |  |  |  |  |  |  | Date:
 | Job Location: |  |  |  |  |  |  | Company:
 | Model
 | Quantity | Model
 |  | LPKNI-HID Knight Pedestrian
 | Options
 | FIG 1: PEDESTRIAN |  |  |  |  |  |  | Lamp Options
 |  |  |  |  |  |  |  | Please select one option below.
 |  |  |  |  |  |  |  | NOTE: Please call for pricing information.
 |  |  |  |  |  |  |  | M100 (metal halide)
 |  |  |  |  |  |  |  | M150 (metal halide)
 |  |  |  |  |  |  |  | S100 (high pressure sodium)
 |  |  |  |  |  |  |  | S150 (high pressure sodium)
 |  |  |  |  |  |  |  | Supply fixture without lamp? |  |  | Yes | No
 |  |  |  |  |  |  |  | j
 |  |  |  |  |  |  |  | Finish Options
 |  |  |  |  |  |  |  | Please select one bold option and one specific option under it.
 |  |  |  |  |  |  |  | NOTE: Due to the inherent nature of metal castings, gloss powdercoats are not offered for cast components.
 |  |  |  |  |  |  |  | Standard powdercoat color
 |  |  |  |  |  |  |  | Black Texture
 |  |  |  |  |  |  |  | Slate Texture
 |  |  |  |  |  |  |  | Forms+Surfaces powdercoat color
 |  |  |  |  |  |  |  | (Please call for pricing information.)
 |  |  |  |  |  |  |  | Aluminum Texture |  |  | Evergreen Texture
 |  |  |  |  |  |  |  | Argento Texture |  |  | Rust Texture
 |  |  |  |  |  |  |  | Cobalt Texture |  |  | Silver Texture
 |  |  |  |  |  |  |  |  |  |  | Weathered Iron Texture
 |  |  |  |  |  |  |  | Custom RAL powdercoat color
 |  |  |  |  |  |  |  | (Please call for pricing information.)
 |  |  |  |  |  |  |  | RAL Color:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | page 1 of 1  |  Rev. 01-25-11
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 6

 | Oct 26 |  | Nov 2 |  | Nov 9 |  | Nov 16
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500 | 84500
SD/MSPs** | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 105000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap event volumes by asset class and participant type (in number of events), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type 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: 705823d1606319744-trying-to-determine-cost-based-on-multiple-variables-using-vlookup-to-price-by-quadrants
Sheet: Sheet1

APN | Acreage | Offer |  | Per Acre Should be | Offer Should be |  | APN indicator | 1
1 | 4 |  |  | 5000 |  |  | 1 | 0 | 5000
2 | 42 |  |  | 1200 |  |  | 1 | 5 | 2500
3 | 86 |  |  | 1500 |  |  | 1 | 20 | 1500
2 | 22 |  |  | 2000 |  |  | 1 | 50 | 1000
1 | 12 |  |  | 2500 |  |  | 1 | 100 | 400
2 | 7 |  |  | 3000
3 | 1.5 |  |  | 6000 |  |  | APN indicator | 2
2 | 18 |  |  | 2000 |  |  | 2 | 0 | 4000
 |  |  |  |  |  |  | 2 | 3 | 3000
 |  |  |  |  |  |  | 2 | 15 | 2000
 |  |  |  |  |  |  | 2 | 40 | 1200
 |  |  |  |  |  |  | 2 | 75 | 600
 |  |  |  |  |  |  | APN indicator | 3
 |  |  |  |  |  |  | 3 | 0 | 6000
 |  |  |  |  |  |  | 3 | 10 | 4500
 |  |  |  |  |  |  | 3 | 30 | 2000
 |  |  |  |  |  |  | 3 | 80 | 1500
Spreadsheet: 103735d1301457266-extracting-numbers-from-detail-in-a-cell-lastword
Sheet: Sheet1

2-1 Freeman - New York [PHONE] NJ $981.11 | $981.11
2-1 ATM Mac Hase/An Fu Lu Shanghai 274.55 | 274.55
2-1 Mastercard Currency Exchange Fee 2.19 | 2.19
2-1 Vesta T-Mobile 888-27329847 OR 100.00 | 100.00
2-1 Nyc-Taxi Qps Long Island Cny 10.20 | 10.20
2-1 Nyc-Taxi Qps Woodside NY 8.40 | 8.40
2-1 Direct Withdrawal, American E [PHONE] 4.95 | 4.95
2-2 Bill Pay:LALA Management34 & 0210035 02090874 5,812.04 | 5,812.04
2-2 Bill Pay:Peeps Logistics U Fufillment 02087337 1,352.21 | 1,352.21
2-2 Bill Pay:Ups-United Parcel 0Aw447 02020837 1,103.94 | 1,103.94
Spreadsheet: 805121d1668533704-return-multiple-certifications-completed-and-sum-of-certifications-in-separate-columns-need-formula
Sheet: output

EMP ID | First Name | Exam Code
20291 | Vijay V | AZ-305
20291 | Vijay V | AZ-500
20291 | Vijay V | AZ-900
20291 | Vijay V | Microsoft B2E,B2C,B2B & Entra
20291 | Vijay V | SC-100
20291 | Vijay V | SC-200
20291 | Vijay V | SC-300
20291 | Vijay V | SC-400
20291 | Vijay V | SC-900
Spreadsheet: 161465d1339525246-sum-duplicate-values-then-delete-duplicate-rows-exc
Sheet: Sheet1

Site | Service Line Cost | 2011/Jan | 2011/Apr | 2011
23 | 00023-01 | 3444.46 | 3328.57 | 41721.33 |  | Row Labels | Sum of 2011/Jan | Sum of 2011/Apr | Sum of 2011
25 | 00025-01 | 2040.92 | 2146.86 | 29654.84 |  | 23 | 3444.46 | 3328.57 | 41721.33
26 | 00026-04 | 111.17 | 100.32 | 1715.92 |  | 25 | 2040.92 | 2146.86 | 29654.84
26 | 00026-02 | 4247.27 | 4566.7 | 61296.84 |  | 26 | 4358.440000000001 | 4667.02 | 63012.75999999999
28 | 00028-01 | 2462.88 | 2361.71 | 33332.92 |  | 28 | 2462.88 | 2361.71 | 33332.92
31 | 00031-01 | 1819.45 | 1895.82 | 24184.01 |  | 31 | 1819.45 | 1895.82 | 24184.01
 |  |  |  |  |  | (blank)
 |  |  |  |  |  | Grand Total | 14126.15 | 14399.98 | 191905.86
Spreadsheet: 863659d1711060922-index-match-formula-indexmatch_min-excel-function
Sheet: Sheet2

 | WOA TEXT | [NAME] | Work Start | Work End | District Code | Project Name (Raw Text) | Project Name | WELL Name
 | 92367 | 2016-09-01 00:00:00 | 2016-07-26 00:00:00 | 2016-10-10 00:00:00 | AC |  |  | Porter 69G
 | 26514 | 2016-12-31 00:00:00 | 2016-06-01 00:00:00 | 2016-10-10 00:00:00 | AC |  |  | Porter 69G
 | 92367 | 2016-09-01 00:00:00 | 2016-07-26 00:00:00 | 2016-10-10 00:00:00 | AC |  |  | Porter 69G
 | 28616 | 2021-04-01 00:00:00 | 2020-10-06 00:00:00 | 2021-01-09 00:00:00 | AC |  |  | Porter 69G
 | 88926 | 2021-04-01 00:00:00 | 2020-10-06 00:00:00 | 2021-01-09 00:00:00 | AC |  |  | Porter 69G
 | 88926 | 2021-04-01 00:00:00 | 2020-10-06 00:00:00 | 2021-01-09 00:00:00 | AC |  |  | Porter 69G
 | 89781 | 2023-03-31 00:00:00 | 2022-04-19 00:00:00 | 2022-12-15 00:00:00 | AC |  |  | Porter 69G
 | 89781 | 2023-03-31 00:00:00 | 2022-04-19 00:00:00 | 2022-12-15 00:00:00 | AC |  |  | Porter 69G
 | 89781 | 2023-03-31 00:00:00 | 2022-04-19 00:00:00 | 2022-12-15 00:00:00 | AC |  |  | Porter 69G
 | 70774 | 2025-01-06 00:00:00 | 2024-11-07 00:00:00 | 2024-02-15 00:00:00 | AC |  |  | Porter 69G
 | 70774 | 2025-01-06 00:00:00 | 2024-11-07 00:00:00 | 2024-02-15 00:00:00 | AC |  |  | Porter 69G
 | 70774 | 2025-01-06 00:00:00 | 2024-11-07 00:00:00 | 2024-02-15 00:00:00 | AC |  |  | Porter 69G
Spreadsheet: 853800d1703774026-lookup-to-return-x-results-and-punctuation-within-a-statement-book1-242-aligw
Sheet: Sheet1

Name of Participant |  |  |  | Description (if any) |  |  | Place |  |  | Name of Participant |  |  |  | Description (if any) |  |  | Place |  |  | Name of Participant |  |  |  | Description (if any) |  |  | Place
Anna |  |  |  | School 1 |  |  | 146 |  |  | Anna |  |  |  | School 1 |  |  | 146 | Qualified |  | Anna |  |  |  | School 1 |  |  | 146 | Qualified
[NAME] |  |  |  | School 2 |  |  | 6 |  |  | [NAME] |  |  |  | School 2 |  |  | 6 |  |  | [NAME] |  |  |  | School 2 |  |  | 6
[NAME] |  |  |  | School 3 |  |  | 9 |  |  | [NAME] |  |  |  | School 3 |  |  | 9 |  |  | [NAME] |  |  |  | School 3 |  |  | 9
[NAME] |  |  |  | School 4 |  |  | 123 |  |  | [NAME] |  |  |  | School 4 |  |  | 123 |  |  | [NAME] |  |  |  | School 4 |  |  | 123 | Qualified
[NAME] |  |  |  | School 5 |  |  | 121 |  |  | [NAME] |  |  |  | School 5 |  |  | 121 |  |  | [NAME] |  |  |  | School 5 |  |  | 121 | Qualified
Fred |  |  |  | School 6 |  |  | 60 |  |  | Fred |  |  |  | School 6 |  |  | 60 |  |  | Fred |  |  |  | School 6 |  |  | 60
George |  |  |  | School 7 |  |  | 140 |  |  | George |  |  |  | School 7 |  |  | 140 | Qualified |  | George |  |  |  | School 7 |  |  | 140 | Qualified
[NAME] |  |  |  | School 8 |  |  | 135 |  |  | [NAME] |  |  |  | School 8 |  |  | 135 |  |  | [NAME] |  |  |  | School 8 |  |  | 135 | Qualified
[NAME] |  |  |  | School 9 |  |  | 52 |  |  | [NAME] |  |  |  | School 9 |  |  | 52 |  |  | [NAME] |  |  |  | School 9 |  |  | 52
[NAME] |  |  |  | School 10 |  |  | 12 |  |  | [NAME] |  |  |  | School 10 |  |  | 12 |  |  | [NAME] |  |  |  | School 10 |  |  | 12
[NAME] |  |  |  | School 11 |  |  | 6 |  |  | [NAME] |  |  |  | School 11 |  |  | 6 |  |  | [NAME] |  |  |  | School 11 |  |  | 6
[NAME] |  |  |  | School 12 |  |  | 9 |  |  | [NAME] |  |  |  | School 12 |  |  | 9 |  |  | [NAME] |  |  |  | School 12 |  |  | 9
Nick |  |  |  | School 13 |  |  | 10 |  |  | Nick |  |  |  | School 13 |  |  | 10 |  |  | Nick |  |  |  | School 13 |  |  | 10
Qualifying Places: 1 |  |  |  |  |  |  |  |  |  | Qualifying Places: 2 |  |  |  |  |  |  |  |  |  | Qualifying Places: 5
And I can confirm that [NAME] has qualified to the next round. |  |  |  |  |  |  |  |  |  | I can confirm that [NAME] and [NAME] have qualified to the next round. |  |  |  |  |  |  |  |  |  | I can confirm that [NAME], [NAME], [NAME], [NAME] and [NAME] have qualified to the next round.
Spreadsheet: 78037d1278495783-sumif-multiple-criteria-example-4-
Sheet: Sheet4

Count of Likes Icecream | Likes Icecream
Status | No | Yes | Grand Total
Couple | 3 | 1 | 4
Married | 1 | 1 | 2
Single | 1 | 1 | 2
Grand Total | 5 | 3 | 8
Spreadsheet: 1f0f6848-0772-412a-89f8-dba11b644e3e
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
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 19. Materials used in Coal Mining, Index Numbers and Percentage Changes
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Number ;  Open cut mining ; |  |  | Original | A2314310A | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | Index Numbers | INDEX | Quarter | 3
Percentage change from pervious quarter ;  Open cut mining ; |  |  | Original | A2314311C | 1987-12-01 00:00:00 | 2009-06-01 00:00:00 | 87 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Open cut mining ; |  |  | Original | A2314312F | 1988-09-01 00:00:00 | 2009-06-01 00:00:00 | 84 | Percent | PERCENT | Quarter | 3
Index Number ;  Underground mining ; |  |  | Original | A2314376T | 1987-09-01 00:00:00 | 2009-06-01 00:00:00 | 88 | Index Numbers | INDEX | Quarter | 3
Percentage change from pervious quarter ;  Underground mining ; |  |  | Original | A2314377V | 1987-12-01 00:00:00 | 2009-06-01 00:00:00 | 87 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Underground mining ; |  |  | Original | A2314378W | 1988-09-01 00:00:00 | 2009-06-01 00:00:00 | 84 | Percent | PERCENT | Quarter | 3
© Commonwealth of Australia  2009