tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__943__PJM Daily Capacity Changes
Sheet: Summary

Visible
1 | Weekday | Date | PJM Scheduled Capacity | PJM Unscheduled Capacity | PJM Forecasted Outages | Total Stack | Change
0 |  | 2001-10-26 00:00:00
 |  | 2001-10-27 00:00:00
 |  | 2001-10-28 00:00:00 | 41602 | 7535 | 8261
 |  | 2001-10-29 00:00:00 | 40867 | 9554 | 8261
 |  | 2001-10-30 00:00:00 | 41903 | 6599 | 7939
 |  | 2001-10-31 00:00:00 | 40409 | 8552 | 7939
 |  | 2001-11-01 00:00:00 | 40758 | 8492 | 8475
 |  | 2001-11-02 00:00:00 | 40079 | 8874 | 8475
 |  | 2001-11-03 00:00:00
 |  | 2001-11-04 00:00:00
 |  | 2001-11-05 00:00:00 | 41120 | 7629 | 9742
 |  | 2001-11-06 00:00:00 | 40936 | 8319 | 9053
 |  | 2001-11-07 00:00:00 | 40524 | 9689 | 9013
 |  | 2001-11-08 00:00:00
 |  | 2001-11-09 00:00:00
 |  | 2001-11-10 00:00:00
 |  | 2001-11-11 00:00:00
 |  | 2001-11-12 00:00:00
 |  | 2001-11-13 00:00:00
 |  | 2001-11-14 00:00:00
 |  | 2001-11-15 00:00:00
 |  | 2001-11-16 00:00:00
 |  | 2001-11-17 00:00:00
 |  | 2001-11-18 00:00:00
 |  | 2001-11-19 00:00:00
 |  | 2001-11-20 00:00:00
 |  | 2001-11-21 00:00:00
 |  | 2001-11-22 00:00:00
 |  | 2001-11-23 00:00:00
 |  | 2001-11-24 00:00:00
 |  | 2001-11-25 00:00:00
 |  | 2001-11-26 00:00:00
 |  | 2001-11-27 00:00:00
 |  | 2001-11-28 00:00:00
 |  | 2001-11-29 00:00:00
 |  | 2001-11-30 00:00:00
Spreadsheet: 6c660c02-bba7-497b-82c7-b7aa8bdf6469
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Fervent Records | [PHONE] | [NAME] August | No Far Away | 2010-08-24 | Compact Disc | Ac | 13.99 | Y | To Be Retired
Word Records | [PHONE] | [NAME] | Anatomy Of Broken, The | 2010-09-14 | Compact Disc | Ac | 13.99 | N | To Be Retired
Taseis | [PHONE] | Chris Jones & Word Of Praise | Dance | 2006-02-28 | Compact Disc | Black Gospel | 13.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] | Only You Can Save | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] | One | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] August | [NAME] | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] August | 7X70 | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Taseis | [PHONE] | Chris & Kyle With True Spirit | Heal Me | 2010-09-21 | Compact Disc | Gospel | 8.99 | Y | Available
Fervent Records | 080688806521AG | [NAME] August | No Far Away (Autographed) | 2010-08-24 | Compact Disc | Ac | 11.99 | Y | Available
Word Records | 080688808327AG | [NAME] | Anatomy Of Broken, The (Autographed) | 2010-09-14 | Compact Disc | Ac | 13.99 | N | To Be Retired
Print Music, Word Owned * | [PHONE] | [NAME] | Living Room Sessions: Hymns | 2001-06-05 | Piano Folio | Na | 16.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | Run The Earth, Watch The Sky | 2003-03-22 | Vocal Folio | Na | 14.95 | N | To Be Retired
Print Music, Word Owned * | [PHONE] | [NAME] | What A Heart Is Beating For | 2007-10-09 | Vocal Folio | Na | 22.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | Amusing | 2005-09-23 | Vocal Folio | Na | 14.95 | N | To Be Retired
Print Music, Word Owned * | [PHONE] | [NAME] | Short Term Memories | 2004-10-22 | Vocal Folio | Na | 24.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | [NAME] | 1998-11-18 | Vocal Folio | Na | 16.95 | Y | Available
Fervent Records | [PHONE] | [NAME] August | No Far Away (Deluxe Edition) | 2011-12-20 | Compact Disc | Ac | 15.99 | Y | Available
Fervent Records | [PHONE] | [NAME] August | The Upside Of Down | 2012-08-21 | Compact Disc | Ac | 13.99 | Y | Available
Word Records | [PHONE] | [NAME] August | Restore | 2013-05-07 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] August | Songs From [NAME] August The Upside Of Down | 2012-11-13 | Vocal Folio | Na | 19.95 | Y | Available
Metro One | [PHONE] | [NAME] | Power In Weakness | 2012-08-14 | Compact Disc | Rock | 13.99 | N | To Be Retired
Fervent Records | [PHONE] | [NAME] August | Unashamed Of You | 2013-12-03 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | [PHONE] | Group 1 Crew Ft. [NAME] August | He Said | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Fervent Records | [PHONE] | [NAME] August | [NAME] August 2014 Christmas Ep | 2014-10-28 | Compact Disc | Ac | 4.99 | N | NYP
Spreadsheet: 155305d1336756679-search-text-in-2-columns-if-match-get-cell-and-insert-into-second-sheet-test-degree-evaluation
Sheet: DegreePlan

ANGELO STATE UNIVERSITY |  |  |  |  |  |  | BACHELOR OF SCIENCE
DEGREE PLAN |  |  |  |  |  |  | 2011-2012 BULLETIN
 |  |  |  | Date:
Address: |  |  |  | CID#
Phone: |  |  |  | SSN:
Computer Science
Major | Certification |  |  | Minor
 |  | MAJOR
 | Course | SCH | Gr |  | Course | SCH | Gr
Computer Science | 1361 | 3 |  | Computer Science (4306, 4307, 4318, 4371) |  | 3
Computer Science | 1362 | 3 |  | Computer Science                           ADV |  | 3
Computer Science | 2305 | 3 |  | Computer Science                           ADV |  | 3
Computer Science | 3304 | 3 |  | Computer Science                           ADV |  | 3
Computer Science | 3352 | 3 |  | Computer Science |  | 3
Computer Science | 4301 | 3 |  | Computer Science |  | 3
Computer Science | 4302 | 3
 |  | OTHER REQUIREMENTS
Communication | 2301 | 3 |  | Natural Sciences |  | 4
English | 1301 | 3 |  | (Biology or Geology) |  | 4
English | 1302 | 3 |  | Chem, Phys or PS |  | 4
Sophomore Literature |  | 3 |  | Physics | 3444 | 4
English | 3351 | 3 |  | History | 1301 | 3
Political Science | 2301 | 3 |  | History | 1302 | 3
Political Science | 2302 | 3 |  | Social Science
Mathematics | 1561 | 5 |  | (AGEC, ECO, GEOG, PSY, SOC) |  | 3
Mathematics | 2305 | 3 |  | Visual and Performing Arts |  | 3
 |  | MINOR
 |  | 3 |  |  |  | 3
 |  | 3 |  |  |  | 3
 |  | 3 |  |  |  | 3
 |  | ELECTIVES
ADV |  | 3
ADV |  | 2
 |  | 2
Work in Residence
Advanced SCH  (min. 24 SCH) |  |  |  | Total Advanced SCH  (min. 42 SCH)
Total SCH  (min. 30 SCH) |  |  |  | Grand Total SCH  (min. 120)
Head of Department |  |  |  | Dean, College of Science
Spreadsheet: 679369d1590355659-same-cust-number-within-2-or-more-groups-unique-group-updated
Sheet: Sheet1

GROUP NUM | CUST NUM | ACC NO | Flag I want
8 | NSRN67L100800X | 13400310
8 | NSRN67L100800X | 13491858
8 | NSRN67L100800X | 13487635
10 | NSRN67L100800X | 13008840
10 | NSRN67L100800X | 13393888
27 | NSRN67L100800X | 14693886
27 | NSRN67L100800X | 13293807
8 | MXXN67L100800X | 13400314
8 | MXXN67L100800X | 13400324
8 | MXXN67L100800X | 13400378
Spreadsheet: 36a94f7f-baf5-47d4-82bc-66860bc0322e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6312 | 15872 | [NAME] | Reinahart | GER | 0 | 00:16:07 | 00:00:00 | 00:32:13 | 00:00:00 | 00:26:02 | 1 | 01:14:22
6312 | 46781 | Giovanni | [NAME] | ITA | 0 | 00:16:21 | 00:00:00 | 00:31:30 | 00:00:00 | 00:27:32 | 2 | 01:15:23
6312 | 10491 | Co | Looijesteijn | NED | 0 | 00:16:17 | 00:00:00 | 00:32:02 | 00:00:00 | 00:28:21 | 3 | 01:16:39
6312 | 9487 | Reinhold | Humbold | GER | 0 | 00:16:14 | 00:00:00 | 00:35:16 | 00:00:00 | 00:27:21 | 4 | 01:18:51
6312 | 10315 | [NAME] | [NAME] | ITA | 0 | 00:18:48 | 00:00:00 | 00:39:13 | 00:00:00 | 00:31:33 | 5 | 01:29:34
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 10. HBV

 |  | HBV test results |  |  |  |  | HBV test results | 0
 |  |  |  |  |  |  | Please indicate HBV genotypes prevalent in your country:
 |  | Please indicate the 3 most prevalent HBV genotypes in your country: |  |  |  |  | A, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | B, percentage (if data available) | 0 | 0
 |  | A, percentage (if data available) |  |  |  |  | C, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | D, percentage (if data available) | 0 | 0
 |  | B, percentage (if data available) |  |  |  |  | E, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | F, percentage (if data available) | 0 | 0
 |  | C, percentage (if data available) |  |  |  |  | G, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | H, percentage (if data available) | 0 | 0
 |  | D, percentage (if data available) |  |  |  |  | Please indicate HBV genotypes prevalent in your donor population:
 |  |  |  |  |  |  | A, percentage (if data available) | 0 | 0
 |  | E, percentage (if data available) |  |  |  |  | B, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | C, percentage (if data available) | 0 | 0
 |  | F, percentage (if data available) |  |  |  |  | D, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | E, percentage (if data available) | 0 | 0
 |  | G, percentage (if data available) |  |  |  |  | F, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | G, percentage (if data available) | 0 | 0
 |  | H, percentage (if data available) |  |  |  |  | H, percentage (if data available) | 0 | 0
 |  | Please indicate the 3 most prevalent HBV genotypes in your donor population:
 |  | A, percentage (if data available)
 |  | B, percentage (if data available)
 |  | C, percentage (if data available)
 |  | D, percentage (if data available)
 |  | E, percentage (if data available)
 |  | F, percentage (if data available)
 |  | G, percentage (if data available)
 |  | H, percentage (if data available)
 |  |  |  | Page 32 of 34
Spreadsheet: 842501d1694566763-fix-value-errors-for-text-string-longer-than-255-count-formula
Sheet: Sheet1

Name | Questions | Answers | Combined | Count
[NAME] | What is your role? | Supervisor/Manager
Sheryl Arno | Are you a | Other Professional
Sandra meeks | We want to hear from you! Which part of the show did you like best? | I liked the game that was played by all staff members and their family.  It really helped with team building and encouraged this to be a regular part of our agency format.  I also liked the door prizes since we have never done that before.  Lastly, a hot lunch is always preferred rather than boxed sandwiches.
Spreadsheet: 677445d1589363298-mobile-file-extractions-for-marketting-book1
Sheet: Sheet1

<span title="Ali, [NAME], Sm Habib Products, +[PHONE], +254 740 060786, +255 682 049 156, +255 683 411 786, +255 684 349 523, | +255 682 049 156 | +255 683 411 786 | +255 684 349 523
<span title="Ali, [NAME], Sm Habib Products, +[PHONE], +254 740 060786, +255 682 049 156,+254 740 060786, +255 683 411 786, +255 684 349 523,+254 740 060786, +255 682 049 156,+254 740 060786, +255 683 411 786, +255 684 349 523, | +255 682 049 156 | +255 683 411 786 | +255 684 349 523 | +255 682 049 156 | +255 683 411 786 | +255 684 349 523
 | +255 682 049 156 | +255 683 411 786 | +255 684 349 523
 | +255 682 049 156 | +255 683 411 786 | +255 684 349 523 | +255 682 049 156 | +255 683 411 786 | +255 684 349 523
Spreadsheet: 63b8792c-2973-411f-9f73-4f4e019d2d75
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2012
 |  | Data Extracted on: August 2, 2014 (4:51 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270223 | 277650 | 277603 | 282873
2009 | 261921 | 266862 | 265511 | 280665
2010 | 267597 | 274785 | 276049 | 291794
2011 | 277416 | 289110 | 288779 | 305253
2012 | 291952 | 300081 | 298950 | 322308
Spreadsheet: 270202d1381413620-what-lookup-function-should-i-use-tracker-9999-rows
Sheet: 6074

 | Reference | 6074
 | Title | Example 2
 | Notes
 | Funding received
 | Name | Amount Received | Date Received
 | Total amount received
Spreadsheet: 844007d1695814941-data-getting-error-tet-aligw
Sheet: Sheet1

 |  |  | Costing | CPM | quality | Iteam | Add
 |  |  | 5001
 |  |  | Costing | CPM | quality | Iteam | Add
 |  |  | 0 | 0 | 0
 |  |  | 100 | 0 | 0
 |  |  | 1001 | 0 | 0
 |  |  | 3001 | 0 | 0
 |  |  | 5000 | 70 | 300*250
 |  |  | 10000 | 50 | 343*600
 |  |  | 50000 | 50 | 343*600
Spreadsheet: 852358d1702417812-using-index-match-with-two-criteria-when-one-of-them-is-a-numeric-interval-problemsheet
Sheet: Sheet1

Balance | Account risk | Aproval level ? |  |  | Approval level | Account Risk | [NAME] from | [NAME] to
60000000 | Medium |  |  |  | 2 | Low | 2000000000 | 500000000
100717150 | Medium |  |  |  | 2 | Medium | 1000000000 | 400000000
291801382 | Medium |  |  |  | 2 | High | 500000000 | 200000000
76597697 | Low |  |  |  | 3 | Low | 500000000 | 160000000
72889993 | Low |  |  |  | 3 | Medium | 400000000 | 80000000
338621207 | Low |  |  |  | 3 | High | 200000000 | 40000000
56570126 | Medium |  |  |  | 4 | Low | 160000000 | 80000000
53719560 | Low |  |  |  | 4 | Medium | 80000000 | 50000000
60109142 | Low |  |  |  | 4 | High | 40000000 | 30000000
71907271.75 | Medium |  |  |  | 5 | Low | 50000000 | 0
73540327.37 | Low
50152000 | Medium
133394082.25 | Medium
120912120.24 | Medium
71192542.23 | Low
67208448.88 | Low |  |  |  |  |  |  |  | ?
153204148.44 | Low
127731122.67 | Low
122341006.67 | Low
66739016.68 | Medium
244694673.89 | Medium
55150944.44 | Low
70997260 | Low
171335579.6 | Low
94887352.55 | Medium
80941399.3 | Medium
56940213.12 | Medium
57984638.89 | Low
63337692.1 | Low
64633864.97 | Low
289969685.33 | Low
67656552.43 | Low
174817557.21 | Low
50070706.16 | Medium
51186055.14 | Low
73146922.22 | Low
108070743.07 | high
170799566.67 | Low
Spreadsheet: sally_beck__35334__cashcoll0901(1)
Sheet: Freight

Freight Markets - Balances >$2,500
Counterparty | Amount | Due Dates | Status | Desk
Adcom Express, Inc. | 2750 | 2001-09-13 00:00:00 |  | Freight
Advantage Transportation Services, | 2600 | 2001-09-20 00:00:00 |  | Freight
BALL TRANSPORT | 2700 | 2001-09-13 00:00:00 | Paid9/26/2001 | Freight
B-Lak Corporation | 2800 | 2001-09-18 00:00:00 |  | Freight
C & C Trucking | 2750 | 2001-09-13 00:00:00 |  | Freight
Cardinal Brands, Inc. | 2702 | 2001-09-20 00:00:00 |  | Freight
CH Powell Company, Inc. | 2932.1 | 2001-09-18 00:00:00 |  | Freight
CH Powell Company, Inc. | 2932.1 | 2001-09-18 00:00:00 |  | Freight
CH Powell Company, Inc. | 2932.1 | 2001-09-13 00:00:00 |  | Freight
CH Powell Company, Inc. | 2932.1 | 2001-09-13 00:00:00 |  | Freight
Combined Express Inc. | 2975 | 2001-09-10 00:00:00 |  | Freight
CRST Logistics, Inc. | 2671 | 2001-09-05 00:00:00 |  | Freight
CT LOGISTICS INC | 2925 | 2001-09-05 00:00:00 | Paid 9/14/2001 | Freight
Dependable Highway Express, Inc. | 2700 | 2001-09-24 00:00:00 |  | Freight
[NAME], LLC. | 2573 | 2001-09-13 00:00:00 |  | Freight
FMAC | 2542 | 2001-09-20 00:00:00 |  | Freight
Hub Group North Central | 2700 | 2001-09-18 00:00:00 |  | Freight
Hub Group North Central | 2700 | 2001-09-13 00:00:00 |  | Freight
Hub Group North Central | 2700 | 2001-09-11 00:00:00 |  | Freight
INTRANSIT | 3046.5 | 2001-09-04 00:00:00 | Paid 9/19/2001 | Freight
ITS Industrial Profile System | 2850 | 2001-09-13 00:00:00 |  | Freight
L J ELKIN INC | 2527.75 | 2001-09-04 00:00:00 | Paid 9/17/2001 | Freight
[NAME] | 2580 | 2001-09-06 00:00:00 | Paid 9/11/2001 | Freight
North Bergen Rex Transport Inc. | 2900 | 2001-09-18 00:00:00 |  | Freight
North Bergen Rex Transport Inc. | 2950 | 2001-09-18 00:00:00 |  | Freight
North Bergen Rex Transport Inc. | 2900 | 2001-09-13 00:00:00 |  | Freight
North Bergen Rex Transport Inc. | 2950 | 2001-09-11 00:00:00 |  | Freight
Orbis, a dba of Menasha Corporation | 2545 | 2001-09-13 00:00:00 |  | Freight
Pacific Atlantic Brokerage, Inc. | 2950 | 2001-09-25 00:00:00 |  | Freight
Pacific Atlantic Brokerage, Inc. | 3000 | 2001-09-21 00:00:00 |  | Freight
Retail Concepts, Inc. | 2755 | 2001-09-26 00:00:00 |  | Freight
Ryder Integrated Logistics | 2600 | 2001-09-21 00:00:00 |  | Freight
Seamates International, Inc. | 3800 | 2001-09-14 00:00:00 |  | Freight
Southern Logistics, LLC | 3500 | 2001-09-27 00:00:00 |  | Freight
Southern Logistics, LLC | 2565 | 2001-09-07 00:00:00 |  | Freight
Southern Logistics, LLC | 2752.5 | 2001-09-07 00:00:00 |  | Freight
Streamline Shippers Association, | 3028.3 | 2001-09-21 00:00:00 |  | Freight
Streamline Shippers Association, | 3070.1 | 2001-09-18 00:00:00 |  | Freight
Streamline Shippers Association, | 3103 | 2001-09-18 00:00:00 |  | Freight
Streamline Shippers Association, | 3028 | 2001-09-18 00:00:00 |  | Freight
Streamline Shippers Association, | 3028.3 | 2001-09-13 00:00:00 |  | Freight
Streamline Shippers Association, | 3028.4 | 2001-09-12 00:00:00 |  | Freight
VALIMET INC GENERA | 2584 | 2001-09-12 00:00:00 | Paid 9/11/2001 | Freight
Total
Unpaid @ 09/30/01 | 103345
excludes intercompany
Spreadsheet: 851761d1701896001-return-true-if-row-number-matches-a-variable-row-number
Sheet: Sheet1

Player # | Score | Scratched |  | Player #: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 1.26
2 | 1.12 |  |  |  | True | True | True | False |  | False |  | False | False | True
3 | 1.12
4 | 0.95
5 |  | x
6 | 0.95
7 |  | x
8 | 0.95
9 | 0.95
10 | 1.35
Spreadsheet: 752596d1634842704-returning-one-value-contained-in-a-list-wordmatch_gw_reva
Sheet: Sheet1

 |  |  | [NAME] attempt | GW attempt |  |  |  | Ideal Answers | GW attempt-2
 | red |  |  |  |  | red ball, walk, show, tent, invade,matchmake,computer,
 | red ball |  |  |  |  |  |  | Red Ball
 | red pen
 | make
 | shift
 | computer |  |  |  |  |  |  | Computer
Spreadsheet: 766452d1643897554-lookup-and-return-items-in-column-array-based-on-date-lookup-and-return-in-a-column2
Sheet: Rawdata

Vendor | Receipt | Payment | Date of Payment
[NAME] | 560 | 400 | 2021-03-13 00:00:00
Kurt | 1000 | 780 | 2021-03-14 00:00:00
[NAME] | 678 | 560 | 2021-04-15 00:00:00
[NAME] | 543 | 230 | 2021-04-16 00:00:00
Felix | 900 | 340 | 2021-05-17 00:00:00
[NAME] | 2000 | 1200 | 2021-05-18 00:00:00
Spreadsheet: 63873d1264730669-automatically-divide-list-into-even-segments-trucks
Sheet: Sheet1

TRUCK | WORK | split |  | number of teams | Team #1 |  | Team #2 |  | Team #3 |  | Team #4
350A | 415 | 1 |  | 3 | TRUCK | WORK | TRUCK | WORK | TRUCK | WORK | TRUCK | WORK
351A | 416 | 1 |  | number of trucks | 350A | 415 | 362A | 427 | 375A | 440
352A | 417 | 1 |  | 38 | 351A | 416 | 363A | 428 | 376A | 441
353A | 418 | 1 |  |  | 352A | 417 | 364A | 429 | 377A | 442
354A | 419 | 1 |  |  | 353A | 418 | 365A | 430 | 377A | 443
355A | 420 | 1 |  |  | 354A | 419 | 366A | 431 | 377A | 444
356A | 421 | 1 |  |  | 355A | 420 | 367A | 432 | 377A | 445
357A | 422 | 1 |  |  | 356A | 421 | 368A | 433 | 377A | 446
358A | 423 | 1 |  | all trucks accounted for ok | 357A | 422 | 369A | 434 | 377A | 447
359A | 424 | 1 |  |  | 358A | 423 | 370A | 435 | 377A | 448
360A | 425 | 1 |  |  | 359A | 424 | 371A | 436 | 377A | 449
361A | 426 | 1 |  |  | 360A | 425 | 372A | 437 | 377A | 450
362A | 427 | 2 |  |  | 361A | 426 | 373A | 438 | 377A | 451
363A | 428 | 2 |  |  |  |  | 374A | 439 | 377A | 452
364A | 429 | 2 |  |  | TOTAL |  | TOTAL |  | TOTAL |  | TOTAL
365A | 430 | 2
366A | 431 | 2
367A | 432 | 2
368A | 433 | 2
369A | 434 | 2
370A | 435 | 2
371A | 436 | 2
372A | 437 | 2
373A | 438 | 2
374A | 439 | 2
375A | 440 | 3
376A | 441 | 3
377A | 442 | 3
377A | 443 | 3
377A | 444 | 3
377A | 445 | 3
377A | 446 | 3
377A | 447 | 3
377A | 448 | 3
377A | 449 | 3
377A | 450 | 3
377A | 451 | 3
377A | 452 | 3
Spreadsheet: 467232d1466622829-range-formula-help-needed-pivot-vs-countifs-and-averageifs
Sheet: Median (AVGIFS)

 | Based on Median (Vented Core) |  |  |  |  |  |  |  | Based on Median ([NAME])
 | Frame | Poles | Motor Type | Horsepower |  |  |  |  | Frame | Poles | Motor Type | Horsepower
Frame |  |  | Vented Core | 0>700 | 701>1250 | 1251>3000 | 3001>18,000 |  |  |  | [NAME] | 0>700 | 701>1250 | 1251>3000 | 3001>18,000
500 | 500 | 2-pole |  |  |  |  |  |  |  | 2-pole
500 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
500 |  | 6-pole |  |  |  |  |  |  |  | 6-pole |  |  |  |  |  |  | ** Return column J from VSM tab if Criteria is met.
500 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
500 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
500 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
500 |  | 16-pole |  |  |  |  |  |  |  | 16-pole |  |  |  |  |  |  | I added column A to make the formulas cleaned, you can group and contract it so you don’t have to see it. Or you can just hide it
580 | 580 | 2-pole |  |  |  |  |  |  |  | 2-pole
580 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
580 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
580 |  | 8-pole |  |  |  |  |  |  |  | 8-pole |  |  |  |  |  |  | Also this ONLY returns the FIRST data point, but as I mentioned in the forum, you could have multple 500 frame 6 pole vented under [NAME], THEN what should the math be?
580 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
580 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
580 |  | 16-pole |  |  |  |  |  |  |  | 16-pole |  |  |  |  |  |  | Also look at my VSM Avg Pivot and VSM Count Pivot sheets, that is likely how I would do it.
680 | 680 | 2-pole |  |  |  |  |  |  |  | 2-pole
680 |  | 4-pole |  |  |  |  |  |  |  | 4-pole |  |  |  |  |  |  | Also I have no idea what to do with column D or L
680 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
680 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
680 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
680 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
680 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
800 | 800 | 2-pole |  |  |  |  |  |  |  | 2-pole
800 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
800 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
800 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
800 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
800 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
800 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
630 | 630 | 2-pole |  |  |  |  |  |  |  | 2-pole
630 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
630 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
630 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
630 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
630 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
630 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
710 | 710 | 2-pole |  |  |  |  |  |  |  | 2-pole
710 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
710 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
710 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
710 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
710 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
710 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
Spreadsheet: 088ac78b-f84f-4b95-9089-a0439ffc35e9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  | CUSTOMIZE YOUR WORD SEARCH
 |  |  |  |  |  | Hover Your Pointer
 |  |  |  |  |  | HERE for a Useful Tip!
 |  |  | Type School Information Here...
 |  |  | School Name | SCHOOL NAME | Year | Year
 |  |  | Teacher Name | Teacher Name | Sem/Qtr | Semester/Qtr Number
 |  |  | Class/Project | Class/Project
 |  |  | Formatted Information
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | Invoice