tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: vkaminski__40727__Storage Model - Intrinsic
Sheet: LRC - FgtZ2

ENRON CAPITAL & TRADE RESOURCES
Storage Analysis
Koch FSS Bistineau |  |  |  |  |  | LRC/HenryHub to Florida Z2
 |  | [NAME] |  |  |  |  | Index |  |  | Libor | Net Cash | Cost of | Discounted
Month |  | Daily | Monthly | Cumulative | Nymex | Basis | Price |  | Dollars | Curve | Flow | Money | Net Cash Flow
2000-01-01 00:00:00 | 31 | 0 |  |  | 0 | 0
2000-02-01 00:00:00 | 29 | 0 |  |  | 0 | 0
2000-03-01 00:00:00 | 31 | 0 |  |  | 0 | 0 | 0
2000-04-01 00:00:00 | 30
2000-05-01 00:00:00 | 31
2000-06-01 00:00:00 | 30
2000-07-01 00:00:00 | 31
2000-08-01 00:00:00 | 31
2000-09-01 00:00:00 | 30
2000-10-01 00:00:00 | 31 | 0
2000-11-01 00:00:00 | 30 | 0
2000-12-01 00:00:00 | 31
2001-01-01 00:00:00 | 31
2001-02-01 00:00:00 | 28
2001-03-01 00:00:00 | 31 | 0
2001-04-01 00:00:00 | 30 | 0 |  |  | 0 | 0
2001-05-01 00:00:00 | 31 | 0 |  |  | 0 | 0
2001-06-01 00:00:00 | 30 | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | Spread before inj/wd fees, fuel, & cost of $) |  |  |  | Net Storage Fee
Variables |  | Storage Fuel |  | 0.016
 |  | Injection Fee |  |  | 0.005
 |  | Withdrawal Fee |  |  | 0.005
Spreadsheet: 773127d1647628428-sort-data-from-multiple-colums-business-pay-summary
Sheet: Sheet1

 | BUSINESS A |  |  |  |  | BUSINESS B |  |  |  |  |  | PAY
 | EMPOYEE # | NAME | HOURS | PAY | OVERTIME | EMPOYEE # | NAME | HOURS | PAY | OVERTIME |  | ID | 8826 | 10136 | 10156 | 12211 | 15656 | 15757 | 21105 | 24513 | 24513 | 67044 | 131266
1 | 10156 | JOHNS | 8 | 300 | NO | 8826 | [NAME] | 11 | 500 | YES |  | NAME | [NAME] | STEVENS | JOHNS | MCALISTAR | ALBERTS | TODD | SWEENEY | SMITH | WHITE | MARSH | WHIP
2 | 12211 | MCALISTAR | 7.5 | 252.38 | NO | 15757 | TODD | 7.5 | 274.88 | NO |  | 1 | 500 | 300 | 300 | 252.38 | 149.63 | 274.88
3 | 10136 | STEVENS | 8 | 300 | NO | 10156 | JOHNS | 8 | 316 | NO |  |  | 440 |  | 316 | 252.38 | 149.63
4 | 10156 | JOHNS | 10 | 475 | YES | 24513 | WHITE | 12 | 455 | YES |  |  |  |  | 475
5 | 21105 | SWEENEY | 4.5 | 126.9 | NO | 67044 | MARSH | 7.5 | 274.88 | NO
6 | 24513 | SMITH | 7.5 | 236.25 | NO | 131266 | WHIP | 4.5 | 134.33 | NO
7 | 15656 | ALBERTS | 4.5 | 149.63 | NO | 8826 | [NAME] | 10 | 440 | YES
8 | 12211 | MCALISTAR | 7.5 | 252.38 | NO | 15656 | ALBERTS | 4.5 | 149.63 | NO
 | 10136 | 10156 | 12211 | 15656 | 15757 | 21105 | 24513 | 24513 | 67044 | 131266 |  |  |  | 10136 | 10156 | 12211 | 15656 | 15757 | 21105 | 24513 | 24513 | 67044 | 131266
[NAME] | STEVENS | JOHNS | MCALISTAR | ALBERTS | TODD | SWEENEY | SMITH | WHITE | MARSH | WHIP |  |  | [NAME] | STEVENS | JOHNS | MCALISTAR | ALBERTS | TODD | SWEENEY | SMITH | WHITE | MARSH | WHIP
440 | 300 | 300 | 252.38 | 149.63 | 274.88 | 126.9 | 236.25 | 455 | 274.88 | 134.33 |  |  | 440 | 300 | 300 | 252.38 | 149.63 | 274.88 | 126.9 | 236.25 | 455 | 274.88 | 134.33
500 |  | 316 | 252.38 | 149.63 |  |  |  |  |  |  |  |  | 500 |  | 316 | 252.38 | 149.63
 |  | 475 |  |  |  |  |  |  |  |  |  |  |  |  | 475
Spreadsheet: 31066d1226785715-autofill-from-column-on-another-worksheet-dispatch-master-copy
Sheet: Customer Database

Customer | Address | Home Phone | Cell Phone | Additional Phone | Past Invoices
[NAME] | 2312 I St. Eureka | 7076675340 | 7075025899 |  | 32123, 25432
[NAME] | 76 Main St. USA | 600-4233 | 3212873 |  | 45672
[NAME] | 55 Anywhere St. USA | 5551212 | 121-5555 | 3432234 | 45684, 42788
[NAME] | Disneylane | 2325557843 |  |  | 67894
[NAME] | DO NOT WORK FOR 32 [NAME] eureka | [PHONE] |  |  | 32744, 45321
[NAME] | 2575 Alliance Rd. Apt 6c Arcata | 7078261285 | 7076161248 |  | 23443, 34599
Spreadsheet: 107638d1304768578-predictive-stock-predictive-20stock-1-
Sheet: Jan

Milkshakes |  | Sales
 |  | 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
 |  | 10 |  | 10 |  | 40
Milkshakes | Opening | Stocks
 |  | 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
 | 100
Milkshakes |  | Stocks
 |  | 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
Spreadsheet: 265581d1379334143-help-need-for-calculating-summery-satputenandkumar0
Sheet: SUMMERY

1 | 2 | 3
 |  |  | TOTAL
 |  |  | ADVANCE
 |  |  | BALANCE
Spreadsheet: 865257d1712307704-complex-conditional-formatting-formula-sample
Sheet: Products

No | Category | Product Name | Owner | Scope Category | Description
1 | Category 1 | Product A | Product Owner Name | In Scope | TEXT
2 | Category 1 | Product B | Product Owner Name | Out Of Scope | TEXT
3 | Category 2 | Product C | Product Owner Name | In Scope | TEXT
4 | Category 2 | Product D | Product Owner Name | Incompatible | TEXT
5 | Category 2 | Product E | Product Owner Name | Not Applicible | TEXT
Spreadsheet: 792024d1660708525-optomize-raw-material-pallet-beta_modded
Sheet: OpenSolver_result

 |  | T | W | L
 |  | 16 | 75 | 845 | 16
 |  | 16 | 75 | 945 | 36
 |  | 16 | 75 | 1000 | 36
 |  | 16 | 75 | 1140 | 12
 |  | 16 | 75 | 1200 | 35
 |  | 16 | 75 | 2400 | 4
 |  | Stock L | 4800
 |  |  |  |  |  |  |  |  |  |  | waste | Bars | Tot waste
 |  |  |  |  | 2400 | 1200 | 1140 | 1000 | 945 | 845 | pr bar | used | from bars
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Total
 |  |  |  | Demand | 4 | 35 | 12 | 36 | 36 | 16
 |  |  | Excess production
 |  |  | Total excess = Tot waste + Excess production
Spreadsheet: 682776d1592327509-engineer-project-allocation-app-sanitised-tracker
Sheet: Skills Matrix

Engineer | Skill | Category | Skill Level
Storage Engineer 14 | NetApp (FAS/AFF) |  | 8
Network Engineer 7 | Routing |  | 9
Storage Engineer 14 | XP Arrays |  | 7
Storage Engineer 15 | Veeam |  | 7
Network Engineer 8 | Routing |  | 8
Storage Engineer 14 | Veeam |  | 8
Storage Engineer 14 | Nimble |  | 8
Storage Engineer 14 | XP Arrays |  | 7
Spreadsheet: 858420d1707129054-automaticaly-updating-formulas-when-a-new-sheet-is-created-incoming-visual-inspection-register-test
Sheet: Repair Report 1

 |  | Repair Report |  |  |  |  |  | Doc. No.: | PRO-QC-012
 |  |  |  |  |  |  |  | Rev. No.: | 001
CUSTOMER: |  |  |  | SERIAL NUMBER: |  |  | DATE
PROJECT NUMBER: |  |  |  | WEIGHT |  |  | COLOUR
DRBM ID |  |  |  | [NAME] |  | lbs | DEPTH
OEM: | Matrix |  |  | 0 |  |  | SIZE ([NAME]) | 0
 |  | Repair Report |  |  |  |  |  | Doc. No.: | PRO-QC-012
 |  |  |  |  |  |  |  | Rev. No.: | 001
Remarks: 1. Preparation for repair of surface Defects according to 8.1.2. in PRO-QA-017_Preparation Department Procedure.  2, Reshaping the OD of the Element where cracks were exposed according to 8.1.1 in PRO-QA-016_Fairing Department Procedure. 3. Applying Fiber Glass & Fiber Glass Consolidation according to 8.1.3 in PRO-QA-035_Lamination Department Procedure.
SUMMARY OF REPAIRS REQUIRED
BONDING |  | 0 |  | REBUILD |  | 0 | MEDIUM REPAIR
TRANSVERSE FRACTURE (TF) |  | 1 |  | PAINT & MARKING |  | 1 | MAJOR REPAIR
LONGTITUDINAL FRACTURE (LF) |  | 0 |  | SMALL REPAIR |  |  | ADDITIONAL REPAIR
INSPECTED BY: Garth Tooth |  |  | APPROVED BY: |  |  |  | CLIENT APPROVAL: (if applicable)
SIGNATURE: |  |  | SIGNATURE: |  |  |  | SIGNATURE:
DATE: |  |  | DATE: |  |  |  | DATE:
Spreadsheet: 68174d1268735802-excel-2007-averaging-and-ignoring-non-numbers-when-not-in-a-range-sample
Sheet: Sheet1

 | A | 100 | 200
 | Offer | N/A | 50
 | Total Offer | N/A
 | [NAME] | N/A
 | Difference due to quote | N/A
 | B |  | 100
 | Offer | N/A
 | Total Offer | N/A
 | [NAME] | N/A
 | Difference due to quote | N/A
 | C | 150 | 89
 | Offer | N/A | 30
 | Total Offer | N/A
 | [NAME] | N/A
 | Difference due to quote | N/A
 | D
 | Offer | N/A
 | Total Offer | N/A
 | [NAME] | N/A
 | Difference due to quote | N/A
 | Average Quote Price
 | Average Price [NAME]
 | Average Quote Variance
Spreadsheet: 3d3b568e-2ac9-47d4-990f-9ef04392fda3
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
ALAUR | Test | ALAUR | Aminolevulinic Acid (ALA), [NAME] | Aminolevulinic Acid, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME]: Urine |  |  | 2 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 2 mL Collection Instructions:  1. Patient should abstain from alcohol for 24 hours prior to and during testing. 2. Collect a random urine specimen.  Additional Information: Patient's age is required. Forms: 1.	1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.	2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1 mL | Hemolysis	NA Thawing	Cold OK; Warm reject Lipemia	NA Icterus	NA Other	NA | <1 year: < or =10 nmol/mL 1-17 years: < or =20 nmol/mL > or =18 years: < or =15 nmol/mL | Tuesday, Thursday; 8 a.m. | 3 days (not reported Saturday or Sunday) | 6 days | 1 | 82135 |  |  |  |  | Rochester
ALAUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
ALAUR | Result | 61547 | Aminolevulinic Acid, U | Aminolevulinic Acid, U | Numeric |  |  |  |  | nmol/mL
ALAUR | Result | 34347 | Interpretation (ALA), U | Interpretation (ALA), U | Alphanumeric
ALAUR | Result | 34348 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 823135d1679734857-translating-table-data-eftable2023updated-1-
Sheet: Data

Route | Ids | Run
M100 | tripid: KB_A3-Sunday-029500_M100_1 | 1
M100 | tripid: KB_A3-Sunday-031500_M100_2 | 2
M100 | tripid: KB_A3-Sunday-033500_M100_3 | 3
M100 | tripid: KB_A3-Sunday-035000_M100_1 | 1
M100 | tripid: KB_A3-Sunday-035500_M100_4 | 4
M100 | tripid: KB_A3-Sunday-037000_M100_2 | 2
M100 | tripid: KB_A3-Sunday-037500_M100_5 | 5
M100 | tripid: KB_A3-Sunday-039000_M100_3 | 3
M100 | tripid: KB_A3-Sunday-039500_M100_1 | 1
M100 | tripid: KB_A3-Sunday-041000_M100_4 | 4
M100 | tripid: KB_A3-Sunday-041400_M100_2 | 2
M100 | tripid: KB_A3-Sunday-043000_M100_5 | 5
M100 | tripid: KB_A3-Sunday-043400_M100_3 | 3
M100 | tripid: KB_A3-Sunday-045000_M100_1 | 1
M100 | tripid: KB_A3-Sunday-045400_M100_4 | 4
M100 | tripid: KB_A3-Sunday-047000_M100_2 | 2
M100 | tripid: KB_A3-Sunday-047400_M100_6 | 6
M100 | tripid: KB_A3-Sunday-049400_M100_5 | 5
M100 | tripid: [NAME] | 3
M100 | tripid: KB_A3-Sunday-051400_M100_10 | 10
M100 | tripid: KB_A3-Sunday-051000_M100_4 | 4
M100 | tripid: [NAME] | 6
M100 | tripid: KB_A3-Sunday-054900_M100_1 | 1
M100 | tripid: KB_A3-Sunday-053400_M100_11 | 11
M100 | tripid: [NAME] | 5
M100 | tripid: KB_A3-Sunday-056400_M100_2 | 2
M100 | tripid: KB_A3-Sunday-057000_M100_10 | 10
M100 | tripid: KB_A3-Sunday-057900_M100_6 | 6
M100 | tripid: [NAME] | 13
M100 | tripid: KB_A3-Sunday-061000_M100_1 | 1
M100 | tripid: KB_A3-Sunday-059400_M100_3 | 3
M100 | tripid: KB_A3-Sunday-059000_M100_11 | 11
M100 | tripid: KB_A3-Sunday-062500_M100_2 | 2
M100 | tripid: KB_A3-Sunday-062000_M100_4 | 4
M100 | tripid: KB_A3-Sunday-063200_M100_10 | 10
M100 | tripid: KB_A3-Sunday-064000_M100_6 | 6
M100 | tripid: [NAME] | 5
M100 | tripid: KB_A3-Sunday-065500_M100_3 | 3
M100 | tripid: KB_A3-Sunday-066800_M100_1 | 1
M100 | tripid: KB_A3-Sunday-065600_M100_14 | 14
M100 | tripid: [NAME] | 13
M100 | tripid: KB_A3-Sunday-068000_M100_2 | 2
M100 | tripid: KB_A3-Sunday-068500_M100_4 | 4
M100 | tripid: KB_A3-Sunday-070000_M100_10 | 10
M100 | tripid: [NAME] | 15
M100 | tripid: [NAME] | 3
M100 | tripid: KB_A3-Sunday-073000_M100_14 | 14
M100 | tripid: [NAME] | 5
M100 | tripid: KB_A3-Sunday-070400_M100_11 | 11
M100 | tripid: [NAME] | 13
Spreadsheet: 773456d1647872526-dynamic-array-in-countif-book2
Sheet: Sheet1

Name | Prod |  | Duplicates
[NAME] | 1 |  |  | '=FILTER(UNIQUE(IF(COUNTIF(FILTER(A2:B8,{0,1}),FILTER(A2:B8,{0,1}))>1,FILTER(A2:B8,{0,1}),"")),(UNIQUE(IF(COUNTIF(FILTER(A2:B8,{0,1}),FILTER(A2:B8,{0,1}))>1,FILTER(A2:B8,{0,1}),""))<>""))
[NAME] | 2 | 2 | 3
[NAME] | 3 | 3
[NAME] | 4 | 4
[NAME] | 5 | 5 |  | 3 |  | 3 |  | 3
Harley | 3 | 3
[NAME] | 1 | 1
Spreadsheet: 97327d1296545126-need-logic-and-formula-vb-or-excel-formula-pls
Sheet: Sheet1

SVK/LON/-094393 | 2010-06-08 13:51:20 | 2010-06-09 06:13:00
SVK/LON/-094393 | 2010-06-09 09:18:37 | 2010-06-09 10:19:00
SVK/LON/-094393 | 2010-08-02 00:51:12 | 2010-08-10 04:57:00
SVK/LON/-094393 | 2010-08-12 15:47:14 | 2010-08-15 05:48:00 |  |  |  | ckt 1 | ckt 2 | site outage
SVK/LON/-094393 | 2010-10-11 12:39:51 | 2010-10-11 13:23:00 |  |  |  | SVK/LON/-094393 | SVK/LON/-094395 | 1
SVK/LON/-094395 | 2010-10-11 12:54:19 | 2010-10-11 13:25:00 |  |  |  | abc | ddd
SVK/LON/-094395 | 2010-11-11 01:54:29 | 2010-11-11 05:54:29 |  |  |  | gmm | gxx
There is a circuit line between = |  | SVK/LON/-094393 | & | SVK/LON/-094395
the yellow site is down from 11/10/2010 12:39 to 1:23
When the red circuit is down btw this period (ie yellow ckt downtime period)that means the whole circuit connecting two buildings are down :
I have the circuit paths as shown in g5 which is pre-set
I need the number of times the site were down on a single instance,ex here the ckt path was down for 1 time
Spreadsheet: 540532d1506741552-create-a-drop-down-for-each-month-of-th-year-kad-dashboard-bvj-
Sheet: Rankings

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  | Top Five |  |  | Team rankings |  | Trends |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  | 1st |  |  | Carol |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  | 2nd |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  | 3rd |  |  | Crystal |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  | 4th |  |  | Eliza |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  | 5th |  |  | Giuliana |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  | Ladawna |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
 |  |  |  |  | Ramona
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  | Month |  |  |  |  |  |  |  |  | Month
 |  |  | Team Rankings |  |  |  |  |  |  |  |  | Team Data
 |  | Agent | Network Response | On Time Call Backs | Trace Closure | QA |  |  |  |  | Agent | Network Response | On Time Call Backs | Trace Closure | QA
 |  | Carol |  |  |  |  |  |  |  |  | Carol
 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  | Crystal |  |  |  |  |  |  |  |  | Crystal
 |  | Eliza |  |  |  |  |  |  |  |  | Eliza
 |  | Giuliana |  |  |  |  |  |  |  |  | Giuliana
 |  | Ladawna |  |  |  |  |  |  |  |  | Ladawna
 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  | Ramona |  |  |  |  |  |  |  |  | Ramona
 |  |  |  |  |  |  |  |  |  |  | Averages
Spreadsheet: 792693d1661084101-need-to-flatten-many-column-ranges-into-one-row-easily-excel_forum_flatten_problem_sample
Sheet: Sheet1

Sample Data Set
Column1 | Column2 | Column3 | [NAME]
[NAME] | [NAME] | [NAME] | Pancakes
Pancakes | Eggs | Cereal | Eggs
Sandwich | Hamburger | Sandwich | Cereal
Porkchops | Pasta | Chicken | Hamburger
Pancakes | Eggs | Cereal | Eggs |  | How I DO Need Flatten to Work (Across 500+ columns with ranges like A2:A5, B2:[NAME], and on and on): |  |  | Value
 |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  | Pancakes |  |  | Pancakes
 |  |  |  |  | Sandwich |  |  | Sandwich
 |  |  |  |  | Porkchops |  |  | Porkchops
 |  |  |  |  | [NAME] |  |  | Pancakes
 |  |  |  |  | Eggs |  |  | [NAME]
 |  |  |  |  | Hamburger |  |  | Eggs
 |  |  |  |  | Pasta |  |  | Hamburger
 |  |  |  |  | [NAME] |  |  | Pasta
 |  |  |  |  | Cereal |  |  | Eggs
 |  |  |  |  | Sandwich |  |  | [NAME]
 |  |  |  |  | Chicken |  |  | Cereal
 |  |  |  |  |  |  |  | Sandwich
 |  |  |  |  |  |  |  | Chicken
 |  |  |  |  |  |  |  | Cereal
 |  |  |  |  |  |  |  | Pancakes
 |  |  |  |  |  |  |  | Eggs
 |  |  |  |  |  |  |  | Cereal
 |  |  |  |  |  |  |  | Hamburger
 |  |  |  |  |  |  |  | Eggs
Spreadsheet: 201955d1356244815-matching-multiple-criteria-both-exactly-and-approximately-example-coded-vs-charges
Sheet: Sheet1

DOS | NAME | ProfCPT1 | MOD | Dx1 | Dx2 | Dx3
2012-11-08 00:00:00 | [NAME], [NAME] | 99222 |  | 9 | 787.91 | 729.1
2012-11-08 00:00:00 | Doe, [NAME] | 99284 |  | 535.5 | 789.09 | 787.91
2012-11-08 00:00:00 | [NAME], [NAME] | 99000 | 255 | 995.3
2012-11-08 00:00:00 | Jones, [NAME] | 99285 |  | 780.4 | 787.01 | 780.64
Spreadsheet: 233605d1367867716-half-way-there-need-to-formula-to-display-data-when-some-cells-are-blank-example-doc-with-formula
Sheet: Sheet1

Block 1 |  |  |  |  |  |  | block 2 |  |  |  |  |  |  | Block 3 |  |  |  |  |  |  | Best Grade
EXPLORE | PLAN | THINK | DESIGN | MAKE | EVALUATE |  | EXPLORE | PLAN | THINK | DESIGN | MAKE | EVALUATE |  | EXPLORE | PLAN | THINK | DESIGN | MAKE | EVALUATE |  | EXPLORE | PLAN | THINK | DESIGN | MAKE | EVALUATE |  | [NAME]
3B | 4B | 6C | 3B | 4C | 4B |  | 5c |  |  |  |  |  |  | 7b |  |  |  |  |  |  |  |  |  |  |  |  |  | 8A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2C
Spreadsheet: john_griffith__15614__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.65 | 0.46 | 0.47 | 0.4806500000000009 | 0.01394999999999846
 | N | 4.7 | 0.725 | 0.74 | 0.4979000000000009 | 0.01889999999999792
 | Q | 4.8 | 0.91 | 0.94 | 0.5017000000000016 | 0.01139999999999874
 | U | 4.8 | 1.09 | 1.11 | 0.5101000000000014 | 0.006599999999999273
 | V | 4.85 | 1.23 | 1.27 | 0.519300000000001 | 0.008399999999999075
 | X | 5 | 1.41 | 1.45 | 0.5265000000000015 | 0.007799999999999141
 | Z | 5.2 | 1.61 | 1.65 | 0.5369000000000005 | 0.004199999999999537
 | F | 5.25 | 1.75 | 1.81 | 0.5447000000000007 | 0.008699999999999042
 | G | 5.15 | 1.8 | 1.86 | 0.5417000000000014 | -0.001199999999999868
 | H | 4.95 | 1.6 | 1.7 | 0.4823000000000016 | -0.008699999999999042
 | J | 4.55 | 1.2 | 1.3 | 0.3797000000000007 | 0.000299999999999967
 | K | 4.45 | 1.1 | 1.2 | 0.3467000000000022 | -0.003299999999999637
 |  |  | 2001-05-01 12:33:36.470000
Spreadsheet: 806395d1669278345-how-does-this-formula-works-copy-data-based-on-group-name-and-group-head
Sheet: Sheet1

Customer_Name | Old New Dlr Business Group Name | Old New Dlr Business Group | Group Head of A/c | Credit  Days | Desired Credit  Days
AWAN A ELECTRONCIS | AWAN | G | H
BROTHER B ELECTRONICS | BROTHER | G
CHAUDHARY B CORPORATION | CHAUDHARY | G
ZAMINDARA A ELECTRONICS |  |  |  | 30
BROTHER A ELECTRONICS | BROTHER | G | H | 40
BROTHER C ELECTRONICS | BROTHER | G
CHAUDHARY C CORPORATION | CHAUDHARY | G
BUMBAY ELECTRONICS |  | G |  | 45
AWAN B ELECTRONCIS | AWAN | G |  | 90
AWAN C ELECTRONCIS | AWAN | G
CHAUDHARY A CORPORATION | CHAUDHARY | G | H | 50
KOLKATA ELECTRONICS |  |  |  | 90
Spreadsheet: 37666d1235692891-random-input-example27
Sheet: Sheet2

a | sort a | b | sort b | c | sort c
112 | 0.6837001878608364 | 116 | 0.2966543934137571 | 120 | 0.06568564262384391
106 | 0.7794731194495821 | 102 | 0.9849008129042494 | 112 | 0.9335079392452275
113 | 0.7539682497647129 | 117 | 0.4998726740462258 | 103 | 0.2675465402637549
110 | 0.9441628403915816 | 109 | 0.6459192848915043 | 108 | 0.002840053029573575
118 | 0.4869700460364408 | 106 | 0.9532194426351135 | 117 | 0.7441491238849451
116 | 0.6541247165084827 | 107 | 0.02879492756765956 | 111 | 0.8308719812744503
102 | 0.9222105326329295 | 104 | 0.3258738258711658 | 119 | 0.897129449639027
111 | 0.05742851041712904 | 111 | 0.2050550963761752 | 109 | 0.8345824857229296
103 | 0.5247218390236741 | 115 | 0.6295835497761757 | 114 | 0.009731239378677481
119 | 0.1126848640952618 | 120 | 0.3100232087710352 | 106 | 0.188141929787459
104 | 0.6181708807188946 | 114 | 0.78182893799154 | 105 | 0.4168331143456649
105 | 0.2888197635141783 | 108 | 0.1034878034420787 | 115 | 0.3701678298085507
114 | 0.5533270149139748 | 103 | 0.7858989303369335 | 116 | 0.3056802084709718
108 | 0.5650446046548764 | 105 | 0.9293429887754316 | 101 | 0.2409679880007554
115 | 0.3513693518215435 | 101 | 0.7579371554184109 | 113 | 0.435940470146964
120 | 0.9492603403369961 | 110 | 0.6951158574320733 | 107 | 0.5143893155409396
107 | 0.00631064198450132 | 112 | 0.1927983273788678 | 104 | 0.7102244727447176
101 | 0.9121303642133558 | 118 | 0.7855896184753117 | 102 | 0.5045080515031977
117 | 0.4608588079837563 | 119 | 0.9196519048838301 | 118 | 0.8893772795660804
109 | 0.7846239194637032 | 113 | 0.5826843133336488 | 110 | 0.2167278066243185
Spreadsheet: 006ff03d-1659-4cdc-ad43-113e76cea2e8
Sheet: Sheet1

Psychology Purchase Request Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
P.O. #: |  |  |  |  | Professor:
Supplier: |  |  |  |  | Account #:
Date: |  |  |  | Order requested by:
 |  |  |  | Contact Ext. #
Source cheaper supplier?
 |  |  |  |  | Price
Item No. | Catalogue No. | Description |  | Quantity | Each | Total | Availability
1
2
3
4
5
6
7
8
9
10
 |  |  |  |  |  | 0
 |  | Date ordered
 | Contact Name or [NAME]
 | Confirmation #
Additional Charges (Dry Ice, Shipping etc.) |  |  |  | Signature