tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 134066d1324984165-set-up-profit-loss-sheets-eventdata
Sheet: Tables

 | Event Table |  |  |  |  | Categories |  |  | Client Table
 | Code | Description | Client Name |  |  | Deposit |  |  | Client Name | Address 1 | Address 2 | Address 3
 | E1 | Event 1 | ABC Inc |  |  | Expense |  |  | ABC Inc
 | E2 | Event 2 | DEF Inc |  |  | Income |  |  | DEF Inc
 | E3 | Event 3 | GHI Corporation |  |  | Refund |  |  | GHI Corporation
 | E4 | Event 4 | ABC Inc
 | E5 | Event 5 | ABC Inc
Spreadsheet: 8ff48254-92e7-4ec9-8630-c8d89a00e4a0
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
FUNA | Test | FUNA | Fungal Ident Panel A (Bill Only) | Fungal Ident Panel A |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87107 |  |  |  |  | Rochester
FUNA | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 62925d1263913529-countif-with-multiple-criteria-countif-example
Sheet: Sheet1

 |  | [NAME] REPRESENT THE CORRECT VALUES (WITHOUT THE FORMULA)
 |  | YEAR SHIPPED
PRODUCT |  | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | Older
 | A | 2 |  | 2 | 1 |  |  | 1
 | O |  | 1 | 1 |  | 2 |  | 1 |  |  | Apples = A
 | B |  | 1 |  | 1 | 1 | 1 |  |  |  | Oranges = O
 | T |  | 2 |  | 1 | 1 |  | 1 |  |  | Bananas = B
 |  |  |  |  |  |  |  |  |  |  | Tomatoes = T
 | Criteria 1 |  | NOTE:  ANYTHING OLDER THAN 2005 NEEDS TO BE IN THE "OLDER COLUMN". |  |  |  |  |  |  | [NAME]
 |  | Product
 |  | Year Shipped | Shipment # | Year Shipped | Shipment # | Year Shipped | Shipment # | Year Shipped | Shipment #
 |  | 2007 | A | 2008 | O | 2007 | C | 2004 | T
 |  | 2009 | T | 2010 | C | 2009 | T | 2006 | O
 |  | 2006 | O | 2006 | T | 2010 | A | 2002 | C
 |  | 2002 | A | 2007 | T | 2003 | O | 2007 | B
 |  | 2005 | B | 2008 | A | 2008 | A | 2009 | O
 |  | 2006 | B | 2009 | B | 2006 | T | 2010 | A
Spreadsheet: 0171c3ea-d772-4e68-8bc1-4a99bc5d9a95
Sheet: Sheet1

Table 3--U.S. monthly average farm prices and marketings | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2010/11
Month |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August |  | 14.6 |  | 10856 |  | 13.6 |  | 11434 |  | 11.7 |  | 10691
September |  | 14.3 |  | 10630 |  | 14.4 |  | 12704 |  | 11 |  | 15095
October |  | 14.2 |  | 14547 |  | 14.9 |  | 12070 |  | 11.5 |  | 17131
November |  | 14.4 |  | 15772 |  | 15.3 |  | 11404 |  | 12.6 |  | 16929
December |  | 14.6 |  | 15163 |  | 15 |  | 14624 |  | 13.9 |  | 19137
January |  | 14.5 |  | 18693 |  | 15.2 |  | 15053 |  | 14 |  | 21806
February |  | 15.3 | 1/ |  |  | 14.1 |  | 13555 |  | 13.4 |  | 14847
March |  |  |  |  |  | 14.1 |  | 14682 |  | 13 |  | 15844
April |  |  |  |  |  | 14.4 |  | 13311 |  | 13.1 |  | 12727
May |  |  |  |  |  | 14.1 |  | 13127 |  | 12.7 |  | 14227
June |  |  |  |  |  | 14.2 |  | 10510 |  | 12.1 |  | 11317
July |  |  |  |  |  | 14.5 |  | 11380 |  | 12.9 |  | 12369
Average price to date |  | 14.55714285714286 | 2/
Season average farm price |  | 14.9 | 3/ |  |  | 14.5 |  |  |  | 12.7
Average Marketings |  |  |  | 14276.83333333333 |  |  |  | 12821.16666666667 |  |  |  | 15176.66666666667
Total volume marketed |  |  |  | 85661 |  |  |  | 153854 |  |  |  | 182120
N/A = Not available.
1/ Mid-month only.  2/ Simple average.  3/ Mid-point of season-average farm price projection range.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated March 8, 2013.
Spreadsheet: paul_y'barbo__28499__NatGas NYMEX NX3 Settles 2001 MM
Sheet: NYMEX 2001

 |  |  | NX3
 | Contract | Trading | Closing
 | Month | Date | Prices
 | 2001-01-01 00:00:00 | 2000-12-22 00:00:00 | 9.579
 | 2001-01-01 00:00:00 | 2000-12-26 00:00:00 | 9.805
 | 2001-01-01 00:00:00 | 2000-12-27 00:00:00 | 9.978
 | 2001-02-01 00:00:00 | 2001-01-25 00:00:00 | 7.27
 | 2001-02-01 00:00:00 | 2001-01-26 00:00:00 | 7.256
 | 2001-02-01 00:00:00 | 2001-01-29 00:00:00 | 6.293
 | 2001-03-01 00:00:00 | 2001-02-22 00:00:00 | 5.142
 | 2001-03-01 00:00:00 | 2001-02-23 00:00:00 | 5.131
 | 2001-03-01 00:00:00 | 2001-02-26 00:00:00 | 4.998
 | 2001-04-01 00:00:00 | 2001-03-26 00:00:00 | 5.322
 | 2001-04-01 00:00:00 | 2001-03-27 00:00:00 | 5.621
 | 2001-04-01 00:00:00 | 2001-03-28 00:00:00 | 5.384
 | 2001-05-01 00:00:00 | 2001-04-24 00:00:00 | 5.078
 | 2001-05-01 00:00:00 | 2001-04-25 00:00:00 | 4.981
 | 2001-05-01 00:00:00 | 2001-04-26 00:00:00 | 4.891
 | 2001-06-01 00:00:00 | 2001-05-24 00:00:00 | 4.054
 | 2001-06-01 00:00:00 | 2001-05-25 00:00:00 | 3.973
 | 2001-06-01 00:00:00 | 2001-05-29 00:00:00 | 3.738
 | 2001-07-01 00:00:00 |  |  | ?
 | 2001-07-01 00:00:00
 | 2001-07-01 00:00:00
 | 2001-08-01 00:00:00
 | 2001-08-01 00:00:00
 | 2001-08-01 00:00:00
 | 2001-09-01 00:00:00
 | 2001-09-01 00:00:00
 | 2001-09-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
 | 2001-12-01 00:00:00
 | 2001-12-01 00:00:00
 |  | Average
Spreadsheet: 26c13d54-ff3c-42f4-87d5-6961b690b13d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | University of Arkansas at Pine Bluff | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  |  |  | Time Record: For Faculty, Non-Classified Employees and
 |  |  |  |  |  |  | Exempt Classified Employees
Employee Name : |  |  |  |  |  |  |  | Social Security Number :
Department :
For the Month Ended :
 |  |  |  |  |  | [NAME] for the Month
 |  | Date | [NAME] |  |  |  |  | Date | [NAME]
 |  |  | Hours |  | Code |  |  |  | Hours |  | Code
 |  | 1 |  |  |  |  |  | 16
 |  | 2 |  |  |  |  |  | 17
 |  | 3 |  |  |  |  |  | 18
 |  | 4 |  |  |  |  |  | 19
 |  | 5 |  |  |  |  |  | 20
 |  | 6 |  |  |  |  |  | 21
 |  | 7 |  |  |  |  |  | 22
 |  | 8 |  |  |  |  |  | 23
 |  | 9 |  |  |  |  |  | 24
 |  | 10 |  |  |  |  |  | 25
 |  | 11 |  |  |  |  |  | 26
 |  | 12 |  |  |  |  |  | 27
 |  | 13 |  |  |  |  |  | 28
 |  | 14 |  |  |  |  |  | 29
 |  | 15 |  |  |  |  |  | 30
 |  |  |  |  |  |  |  | 31
 |  | Tot. | 0 |  |  |  |  | Tot. | 0
 | Total Hours for the Month |  |  |  |  |  |  |  | 0
SUMMARY |  |  |  |  |  |  |  |  |  |  | My signature certifies employment and leave taken
 |  |  |  |  |  |  |  |  |  |  | for the above noted period.
Vacation Hours Taken (V) |  |  |  |  | 0
Sick Hours Taken-Employee (SE) |  |  |  |  | 0 |  |  |  |  | Signature (Employee)
Sick Hours Taken-Family (SF) |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Signature (Supervisor)
Holidays (H) |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | If all leave time has been exhausted
Other (0) -- Describe |  |  |  |  | 0 |  |  |  |  |  | leave without pay will be employed
Spreadsheet: 824592d1680699341-using-conditional-formatting-to-highlight-columns-with-same-in-same-rows-short-term-real-trades-4-oct-2013-study-35-lar9149-
Sheet: Sheet1

 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1st |  |  |  | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 7 | 6 | 6 | 8 | 8 | 11
2nd |  |  | all | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 8 | 6 | 6 | 9 | 9 | 12
3rd |  |  | [NAME]) | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 3 | 4 | 9 | 6 | 7 | 10 | 11 | 14
4th |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 2 | 4 | 5 | 11 | 10 | 9 | 16 | 15 | 19
5th |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 3 | 4 | 6 | 12 | 13 | 12 | 21 | 19 | 26
6th |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 6 | 13 | 16 | 15 | 28 | 22 | 32
7th |  |  |  | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 7 | 14 | 17 | 17 | 30 | 26 | 36
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1st |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 3 | 3 | 2 | 4 | 4 | 6
2nd |  |  | all | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 2 | 2 | 4 | 4 | 3 | 5 | 5 | 7
3rd |  |  | [NAME]) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 5 | 5 | 7 | 7 | 9
4th |  |  | all(s/fexp) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 8 | 5 | 9 | 8 | 11
5th |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 3 | 2 | 2 | 4 | 7 | 6 | 10 | 12 | 15 | 16 | 20
6th |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
7th |  |  |  | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
 |  |  |  |  |  | EXCEL STUDY
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1st |  |  |  | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5
2nd |  |  | all | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5
3rd |  |  | [NAME]) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 2 | 5 | 6
4th |  |  | all(s/fexp) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 4 | 7 | 8
5th |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 3 | 1 | 2 | 7 | 9 | 5 | 8 | 11 | 13
6th |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18
7th |  |  |  | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18
Spreadsheet: 115da12c-2041-4a8d-96a0-9224a299d4bf
Sheet: Sheet1

 | Directions:   Fiscal Year 2014 EQIP payments will me made by practice.  The intent of this form is to provide a format to list all of the practices for a project with the appropriate practice units that are listed in the 2014 EQIP Practice Payment Schedule.  In addition, it provides a listing of the appropriate Technical Service Payment Unit(formerly NTE rate) and quantity for TSP reimbursement.  Choose a practice in the "Practice" column and then enter the appropriate practice extent (quantity) in the "Practice Extent" column, and Technical Service Payment Quantity in the Technical Service Payment Quantity column.  (If this project is not a FY - 2014 EQIP contract, then use the appropriate FY spreadsheet.)
 | SD NRCS Practice Payment & Technical Service Payment Quantity List (FY2014 EQIP)
 | Certification of Quantities | Description of Quantites           (check one):
 |  | Preliminary Estimate Quantities:
 | [NAME]:  _________________________________________________ | Final Design Quantities:
 | TSP Engineer:   ____________________________________________ | As-Built Quantities:
 | Date:  _________________________________________________ | _________________ Quantities:
 | Practice | Practice Extent | Practice Payment Unit | Technical Service Payment Quantity | Technical Service Payment UNIT from Techreg
Spreadsheet: 801952d1666512295-formula-for-dashboard-summary-of-player-statistics-rl-world-cup-stats-copy
Sheet: Engine

 | Team |  | World Cup
 | Aotearoa Māori |  | 1954
 | Australia |  | 1957
 | Cook Islands |  | 1960
 | England |  | 1968
 | Fiji |  | 1970
 | France |  | 1972
 | Great Britain |  | 1975
 | Greece |  | 1977
 | Ireland |  | 1988
 | Italy |  | 1992
 | Jamaica |  | 1995
 | Lebanon |  | 2000
 | New Zealand |  | 2008
 | [NAME] |  | 2013
 | Russia |  | 2017
 | Samoa |  | 2021
 | Scotland
 | South Africa
 | Tonga
 | USA
 | Wales
 | Western Samoa
Spreadsheet: 648765d1573183742-automatically-calculate-increase-or-decrease-for-the-year-example-excel-question
Sheet: Example

Clients | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | % Change
Example 1 | 7938 | 14288 | 23920 | 27613 | 31648 | 19899 | 19555 | 24509 | 28316 | 30632 | 22341 | 15474 | 34006 | 37892 | 57098 | 66838 | 44088 | 20157 | 18447 | 18031 | 18251 | 17999 |  |  | ?
Example 2 | 23392 | 39495 | 47390 | 43726 | 43515 | 28970 | 25545 | 31924 | 32078 | 28762 | 22432 | 14305 | 25343 | 35292 | 44574 | 57784 | 48164 | 27533 | 25532 | 24802 | 27212 | 25539 |  |  | ?
Example 3 | 33350 | 26203 | 28828 | 28743 | 28947 | 34863 | 32958 | 22871 | 25677 | 29685 | 25941 | 26706 | 34673 | 24581 | 26518 | 28357 | 27806 | 31478 | 30873 | 26080 | 22467 | 23684 |  |  | ?
Example 4 | 43221 | 30176 | 27023 | 23960 | 24678 | 25272 | 30182 | 37284 | 39575 | 46781 | 57564 | 64609 | 67426 | 46189 | 41387 | 36515 | 39786 | 37337 | 41668 | 46789 | 47194 | 47997 |  |  | ?
2018
2019
Spreadsheet: 386038d1427561894-back-again-qm-for-cobb-douglas-and-markowitz-cobb_douglas_solver
Sheet: Question 1

Decision Variables |  |  | [NAME]
Labor L = | 750 |  | Exponent c1 = | 0.25
Capital C = | 750 |  | Coffefficient c0 = | 5
Total Costs = | 75000 |  | Labor Unit Cost = | 25
 |  |  | Captial Unit Cost = | 75
S(L,C)
Constraint 2
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74034

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 408 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20403 |  | Cactus Reports |  |  |  |  |  | Z0074034
 |  | Cactus Audit Support |  |  |  | 1/1/96 | 12/31/96
 |  | Tax Support Co. 521 & 522 |  |  |  | 1/1/98 | 12/31/98
 |  | E-Schedules |  |  |  | 11/01/98 | 12/31/98
 |  | Distiribution of Available Cash |  |  |  | 1998-07-01 00:00:00 | 1999-03-31 00:00:00
 |  | Cactus Hyperion Entries |  |  |  | 1996-06-01 00:00:00 | 1997-03-01 00:00:00
 |  | Cactus Asset Folder
 |  | [NAME], [NAME], EOTT Energy Corp. |  |  |  | 1997-01-01 00:00:00 | 1998-05-31 00:00:00
 |  | Arch Petroleum |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
 |  | Cactus Trust Federal Income Tax Return |  |  |  | 1996-01-01 00:00:00 | 1996-12-31 00:00:00
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: 859946d1708167044-adding-multiplication-after-formula-hansdouwe-simplified-version-formula
Sheet: MONEY HOLE

 |  | 20 |  | 15 |  | 20 |  | 15 |  | HansDouwe simplified version formula
A | 10 |  | 4 |  | 2 |  | 3
B | 5 |  | 4 |  | 4 |  | 5
C | 5 |  | 2 |  | 3 |  | 6
D | 5 |  | 5 |  | 4 |  | 4
E | 5 |  | 5 |  | 5 |  | 5
F | 2 |  | 3 |  | 3 |  | 3
G | 6 |  | 3 |  | 5 |  | 3
As you can see above, player A won this game in Round 3 and again in Round 4 so he won $20 for Round 3 and in Round 4 he should win $30 since the game is worth $15 but since he won two in a row, he should win double on last round. Player C has done the same thing but he won in Round 2 and in Round 3 so his Round 3 winnings should show $40 which is double the $20 winning amount. PLayer F has won all four rounds so he should show $0, for Round 1, $30 for Round 2, $60 for Round 3, and $60 for Round 4. Player G should only show $15 in Round 2 and $15 in Round 4 since he didn't win back to back rounds.
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 10

HILA-Ex results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 1Q10 | Scope |  |  | 1Q11 | Reported | Organic
Volume total ('000 hl) | 1594.435087679987 | -181.78741221 | 0 | 186.3758533399907 | 1599.023528809978 | 0.002877784843952069 | 0.131933713250888
Beer volume ('000 hl) | 584.0703262300033 | -152.9509140799999 | 0 | 97.1868896599969 | 528.3063018100003 | -0.09547484594867683 | 0.2254291663075978
CSD volume ('000 hl) | 1010.364761449984 | -28.83649813000006 | 0 | 89.1889636799936 | 1070.717226999977 | 0.05973334369201599 | 0.09086744316288478
Net revenue | 158.077 | -46.213 | -9.899426656347934 | 21.43942665634794 | 123.404 | -0.2193424723394295 | 0.1916561776473927
Net revenue/hl | 99.14295114391453 | -19.95547790308473 | -6.190919944570965 | 4.178045936711499 | 77.17459923297034 | -0.2215825901637247 | 0.05276145033703714
[NAME] | -99.084 | 26.738 | 7.043846519427632 | -18.35384651942764 | -83.656 | -0.1557062694279601 | 0.2536953877122113
[NAME]/hl | -62.14363994220302 | 10.93058713628626 | 4.405092478326313 | -5.508968405946277 | -52.31692873353673 | -0.1581289930523168 | 0.1075696156373207
Gross profit | 58.99299999999999 | -19.475 | -2.855580136920302 | 3.085580136920296 | 39.74799999999999 | -0.3262251453562288 | 0.0780803719044561
Gross margin | 0.3731915458921918 | 0 | 0 | 0 | 0.3220965284755761 | -510 | -340
SG&A excl. deprec.&amort. | -89.195 | 27.808 | 5.376392945724263 | -4.202392945724272 | -60.213 | -0.3249285273838219 | 0.0684573760849084
SG&A deprec.&amort. | -11.468 | 3.091000000000001 | 0.6400011068172167 | -0.553001106817218 | -8.290000000000001 | -0.2771189396581792 | 0.06601421831410029
SG&A total | -100.663 | 30.899 | 6.016394052541486 | -4.75539405254149 | -68.503 | -0.3194818354310919 | 0.06816401084429635
Other operating income/expenses | 0.005 | -0.013 | -0.01226072451590633 | 0.7412607245159062 | 0.7209999999999999 | nm | nm
Normalized EBIT | -41.665 | 11.411 | 3.148553191105277 | -0.9285531911052882 | -28.03400000000001 | 0.3271570862834511 | -0.03069191482466082
Normalized EBIT margin | -0.2635740809858487 | 0 | 0 | 0 | -0.2271725389776669 | 360 | 370
Normalized EBITDA | -22.826 | 7.531 | 2.037403915257566 | -1.023403915257564 | -14.281 | 0.3743538070621222 | -0.06691101113158313
Normalized EBITDA margin | -0.144397983261322 | 0 | 0 | 0 | -0.1157255842598295 | 290 | 140
Spreadsheet: 816453d1675635453-compare-tables-and-conditional-format-duplicates-row-by-row-compare-tables-for-duplicates
Sheet: Sheet1

20 | 39 | 31 | 9 | 22 |  | 19 | 20 | 31 | 9 | 22 | 23
14 | 19 | 5 | 4 | 21 |  | 15 | 19 | 4 | 5 | 21 | 10
16 | 17 | 34 | 10 | 27 |  | 15 | 16 | 20 | 17 | 34 | 27
12 | 12 | 35 | 3 | 26 |  | 15 | 3 | 35 | 49 | 26 | 12
Below are the results that I want, ie.  A9:E9 will be compared with G9:L9, A10:E10 will be compared with G10:L10 etc.
Table 1 |  |  |  |  |  | Table 2 |  |  |  |  |  |  | no. of duplicates in each row
20 | 39 | 31 | 9 | 22 |  | 19 | 20 | 31 | 9 | 22 | 23 |  | 4
14 | 19 | 5 | 4 | 21 |  | 15 | 19 | 4 | 5 | 21 | 10 |  | 4
16 | 17 | 34 | 10 | 27 |  | 15 | 16 | 20 | 17 | 34 | 27 |  | 5
12 | 12 | 35 | 3 | 26 |  | 15 | 3 | 35 | 49 | 26 | 12 |  | 4
Spreadsheet: 825058d1681093768-dependant-drop-down-list-display-data-from-multiple-dynamic-ranges-invoice_example
Sheet: Price Lists

 | Manufacturing |  |  |  |  |  |  |  |  |  |  |  |  | Retail
 | Clothing |  |  |  |  |  |  |  |  |  |  |  |  | Clothing
 | T-Shirt |  |  |  |  |  |  |  | ea. | 5 |  |  |  | T-Shirt |  |  |  |  |  |  |  | ea. | 10
 | Short |  |  |  |  |  |  |  | ea. | 8 |  |  |  | Short |  |  |  |  |  |  |  | ea. | 14
 | Jacket |  |  |  |  |  |  |  | ea. | 15 |  |  |  | Jacket |  |  |  |  |  |  |  | ea. | 35
 | Shoes |  |  |  |  |  |  |  | pair. | 40 |  |  |  | Accessories
 | Accessories |  |  |  |  |  |  |  |  |  |  |  |  | Glove |  |  |  |  |  |  |  | pair. | 6
 | Scarf |  |  |  |  |  |  |  | ea. | 10
 | Hat |  |  |  |  |  |  |  | ea. | 2
 | These price lists form a printable document that is given to the customer, so it needs to retain some user friendly formatting, like headings and sub headings.
Spreadsheet: 119427d1314381767-match-or-lookup-cant-make-it-work-question-3
Sheet: Sheet1

 | Maximum allowed revenue | 6000
 | Current revenue
 | Shortfall
 | Revenues
 | Total revenue
 | Sales price | 100
 | Number of sales | 15 |  |  |  | Alternatives for overtime hours
 | Revenue from sales |  |  |  |  | 15
 | Other revenue
 | Revenue per hour | 150
 | Overtime hours | ? | <------- | [NAME]
 | Total revenue from hours
Spreadsheet: 2803d754-a6b5-48cb-baa7-987faaf155a8
Sheet: Sheet1

Unnamed: 0 | Occupied Housing Units, Total | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Owner-Occupied Housing Units | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Renter-Occupied Housing Units | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Ownership Status, 2010 (not reported in 2000) | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
County | 2000 | 2010 | % Change |  | 2000 | Percent of Occupied Housing Units, 2000 | 2010 | Percent of Occupied Housing Units, 2010 |  | 2000 | Percent of Occupied Housing Units, 2000 | 2010 | Percent of Occupied Housing Units, 2010 |  | Total owner-occupied housing units | Owned with a mortgage or a loan | Percent Owner-Occupied, owned with a mortgage or a loan | Owned free and clear | Percent owner-occupied, owned free and clear
Cook County | 1974181 | 1966356 | -0.003963668984758743 |  | 1142677 | 0.578810656165772 | 1143857 | 0.5817140944976393 |  | 831504 | 0.421189343834228 | 822499 | 0.4182859055023607 |  | 1143857 | 846809 | 0.740310196117172 | 297048 | 0.259689803882828
DuPage County | 325601 | 337132 | 0.03541451039769534 |  | 248762 | 0.7640087100469594 | 251835 | 0.7469922760224482 |  | 76839 | 0.2359912899530407 | 85297 | 0.2530077239775518 |  | 251835 | 193534 | 0.7684952449024163 | 58301 | 0.2315047550975837
Kane County | 133901 | 170479 | 0.2731719703362933 |  | 101739 | 0.7598076190618442 | 130570 | 0.7659007854339831 |  | 32162 | 0.2401923809381558 | 39909 | 0.2340992145660169 |  | 130570 | 106363 | 0.814605192616987 | 24207 | 0.1853948073830129
Kendall County | 18798 | 38022 | 1.022661985317587 |  | 15810 | 0.8410469198850942 | 32554 | 0.8561885224343802 |  | 2988 | 0.1589530801149058 | 5468 | 0.1438114775656199 |  | 32554 | 28320 | 0.8699391779812005 | 4234 | 0.1300608220187995
Lake County | 216297 | 241712 | 0.1175004738854445 |  | 168301 | 0.7781014068618612 | 185213 | 0.7662548818428543 |  | 47996 | 0.2218985931381388 | 56499 | 0.2337451181571457 |  | 185213 | 146185 | 0.7892804500763986 | 39028 | 0.2107195499236015
McHenry County | 89403 | 109199 | 0.2214243369909287 |  | 74391 | 0.8320861716049797 | 90722 | 0.8307951538017747 |  | 15012 | 0.1679138283950203 | 18477 | 0.1692048461982253 |  | 90722 | 74221 | 0.8181146800114636 | 16501 | 0.1818853199885364
Will County | 167542 | 225256 | 0.3444748182545272 |  | 139311 | 0.8314989674230939 | 187425 | 0.8320533082359627 |  | 28231 | 0.1685010325769061 | 37831 | 0.1679466917640374 |  | 187425 | 153193 | 0.8173562758436708 | 34232 | 0.1826437241563292
7-County Region Total | 2925723 | 3088156 | 0.05551892643288513 |  | 1890991 | 0.6463328893405151 | 2022176 | 0.6548166608163577 |  | 1034732 | 0.3536671106594849 | 1065980 | 0.3451833391836423 |  | 2022176 | 1548625 | 0.7658210759103066 | 473551 | 0.2341789240896935