tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22487__Hanson Scheduling Model_6_18
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-06-18 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 30.576 | 29.364 | 28.344 | 23.856 | 26.652 | 27.12 | 27.036 | 26.964 | 26.316 | 22.392 | 22.152 | 23.58 | 24.408 | 23.4 | 24.492 | 24.456 | 24.012 | 23.856 | 24.72 | 25.224 | 25.356 | 26.172 | 26.016 | 23.064 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 32.36023590669259 | 32.36023590669259 | 32.56023590669258 | 25.50023590669258 | 25.50023590669258 | 25.50023590669258 | 25.50023590669258 | 25.50023590669258 | 19.87523590669258 | 19.87523590669258 | 20.62523590669258 | 19.74523590669259 | 26.80523590669258 | 26.80523590669258 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 773502d1647884446-nested-formulas-in-excel-sheet-sample-2-
Sheet: Master

Produk | Prys | Virginia | [NAME] | Cindy/Jenny | Yolandie | Sus | Moniqudex | [NAME] | [NAME] | Andrisa | Name | [NAME] | Name3 | Name4 | Name5 | Name6 | Name7 | Name8 | Name9 | Name10 | Name11 | Name12 | Totaal Produk Bestel | Totaal Per Produk
Sunlight Liq |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 8
Jik |  |  | 0 | 1
[NAME] |  |  | 1 | 1
Sunlight Liq
Vanish
[NAME] |  | 1
Totaal Per Persoon
Spreadsheet: daren_farmer__6654__Texas Matrix
Sheet: Texas

User ID | User Name | Role
achoksh | [NAME] | Logistics
alannou | [NAME] | Logistics
bfletch | [NAME] | Logistics
ccernos | C C Cernosek | Logistics
chawkin | [NAME] | Logistics
crodrig | [NAME] | Logistics
dfarmer | [NAME] | Logistics
ekam | [NAME] | Logistics
ggrant | [NAME] | Logistics
[NAME] | [NAME] | Logistics
jpattis | [NAME] | Logistics
[NAME] | [NAME] | Logistics
kbussel | [NAME] | Logistics
klenart | [NAME] | Logistics
kmoore | [NAME] | Logistics
kolinge | [NAME] | Logistics
kseaman | [NAME] | Logistics
[NAME] | [NAME] | Logistics
mbowen | [NAME] | Logistics
mfrankl | [NAME] | Logistics
mmackin | [NAME] | Logistics
mmcclur | [NAME] | Logistics
mmsmith | [NAME] | Logistics
pclynes | [NAME] | Logistics
rcotten | [NAME] | Logistics
rcrocke | [NAME] | Logistics
rlloyd | [NAME] | Logistics
rpinion | [NAME] | Logistics
rstanle | [NAME] | Logistics
rsupert | [NAME] | Logistics
sgilber | [NAME] | Logistics
smorris | Stella Morris | Logistics
sneuwei | [NAME] | Logistics
strevin | [NAME] | Logistics
tacton | [NAME] | Logistics
tmaire | [NAME] | Logistics
bherod | [NAME] | Risk Analytics
bhull | [NAME] | Risk Analytics
csulliv | [NAME] | Risk Analytics
dbaumba | [NAME] | Risk Analytics
ebass | [NAME] | Risk Analytics
hwither | [NAME] | Risk Analytics
mfriedm | [NAME] | Risk Analytics
mwalter | [NAME] | Risk Analytics
nferrie | Nelson Ferries | Risk Analytics
owinfre | [NAME] | Risk Analytics
sventur | [NAME] | Risk Analytics
cmetz | [NAME] | Trader
egottlo | [NAME] | Trader
etisdal | [NAME] | Trader
evillar | [NAME] | Trader
ewardle | [NAME] | Trader
ghanks | [NAME] | Trader
glamphi | [NAME] | Trader
gmcclen | [NAME] | Trader
[NAME] | [NAME] | Trader
[NAME] | [NAME] | Trader
[NAME] | [NAME] | Trader
jsabine | [NAME] | Trader
jwallis | [NAME] | Trader
lallen | [NAME] | Trader
[NAME] | [NAME] | Trader
[NAME] | [NAME] | Trader
mabraha | [NAME] | Trader
[NAME] | [NAME] | Trader
wfalbau | [NAME] ([NAME]) | Trader
Spreadsheet: 40696d1239104393-fantasy-football-supercoach-breakeven-formula-book1
Sheet: Sheet1

 | starting price |  | current price |  | score per | round -> | 1 | 2 | 3 | 4 | 5
Player A | 482100 |  |  |  |  |  | dnp | dnp | 54 | 133 | 100
Player B | 482100 |  |  |  |  |  | 54 | 133 | dnp | dnp | 100
 | current price should be same ($489,888) for both!
Spreadsheet: 40287d1238594330-cannot-save-formulas-with-weeknum-function-solved-with-workaround-weeknum-problem-dummy-workbook
Sheet: Teams

W Company
January 2009 Bookings
2009-01-01 00:00:00
Team-Sales Rep Summary |  |  |  |  |  |  |  |  | Team-Order Type Summary
Sales Rep | YTD | MTD | WTD (week begins Sunday,) |  |  |  |  |  | Order Type | YTD | MTD | WTD (week begins Sunday,)
Team | Sales Team B | Jan-2009 | 2009-10 | 2009-11 | 2009-12 | 2009-13 | 2009-14 |  | Team | Sales Team B | Jan-2009 | 2009-10 | 2009-11 | 2009-12 | 2009-13 | 2009-14
 |  |  | 2009-03-01 00:00:00 | 2009-03-08 00:00:00 | 2009-03-15 00:00:00 | 2009-03-22 00:00:00 | 2009-03-29 00:00:00 |  |  |  |  | 2009-03-01 00:00:00 | 2009-03-08 00:00:00 | 2009-03-15 00:00:00 | 2009-03-22 00:00:00 | 2009-03-29 00:00:00
Sum of Total | Year |  |  |  |  |  |  |  | Sum of Total | Year
Sales Rep (Order) | 2009 | Jan-2009 | 2009-10 | 2009-11 | 2009-12 | 2009-13 | 2009-14 |  | Order Type | 2009 | Jan-2009 | 2009-10 | 2009-11 | 2009-12 | 2009-13 | 2009-14
[NAME] Beta | 34716 | 7995 | 0 | 0 | 0 | 0 | 0 |  | Project | 26721 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 300 | 0 | 0 | 0 | 0 | 0 | 0 |  | Equipment Only | 8295 | 7995 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: john_forney__15507__Path15PriceswithZP11
Sheet: Congestion Prices

 |  | HA/DA | HA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-10-05 00:00:00
 |  | 2001-03-07 00:00:00 | 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
 |  | NP15 | 60 | 60 | 30 | 30 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 0
 |  | SP15 | 30 | 30 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ZP26 | 30 | 30 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Net Price NP to SP
 |  |  |  | a | 5 | 4
 |  |  |  | b | 5 | 5
 |  |  |  | total
Spreadsheet: 781565d1653417202-auto-count-rows-of-values-to-use-in-formula-to-get-an-average-sample-book
Sheet: Sheet1

 |  |  | Example 1 |  | Example 2 |  | Example 3 |  |  |  | Desired:
 |  |  | Margin |  | Margin |  | Margin
 |  |  | 0.21 |  | 0.63 |  | 0.63 |  |  |  | I would like to create a situation where (Example 1) the rows are added, then automatically divided by the number of rows with values. In this case, there are 5 rows with values, so the formula is =sum(D6:D10)/5.  (Example 2) there are 9 rows with values, so the formula is =sum(F6:F14)/9.  Same with formula 3.  Basically, I would like an example of how to have the number of rows with values automatically figure itself out so as to complete the formula.  THe goal being to determine the average margin.  This will be used in a sales KPI dashboard I am creating.
 |  |  | 0.54 |  | 0.35 |  | 0.35
 |  |  | 0.53 |  | 0.46 |  | 0.46
 |  |  | 0.67 |  | 0.95 |  | 0.95
 |  |  | 0.12 |  | 0.12 |  | 0.12
 |  |  |  |  | 0.15 |  | 0.15
 |  |  |  |  | 0.81 |  | 0.81
 |  |  |  |  | 0.31 |  | 0.31
 |  |  |  |  | 0.35 |  | 0.35
 |  |  |  |  |  |  | 0.38
 |  |  |  |  |  |  | 0.125
 |  |  |  |  |  |  | 0.43
 |  |  |  |  |  |  | 0.64
 |  |  |  |  |  |  |  |  |  |  | The results of the above are listed here
Spreadsheet: 756079d1637265305-dynamic-formula-to-get-company-and-its-quantity-and-put-the-results-on-2-columns-formula-
Sheet: Report

 |  | 2021-11-17 00:00:00
Area | Material | Company | Quantity
From Outside | Material 1 | Company 3 | 45
 |  | Company 4 | 100
 |  | Company 5 | 45
 |  | Company 6 | 45
 | Material | Company | Quantity
 | Material 2 | Company 13 | 42
Store | Material | Company | Quantity
 | Material 1 | Company 3 | 75
 | Material | Company | Quantity
 | Material 2 | 0
Shredding Area | Material | Company | Quantity
 | Material 1 | Company 3 | 60
 | Material | Company | Quantity
 | Material 2 | 0
Spreadsheet: 64204d1265098720-want-to-split-the-data-in-single-cell-to-multiple-column-sample
Sheet: Sheet1

Conversion Data
jan 06'2006     [NAME]    [EMAIL]    [NAME]663 Southpaw Drive          Rochester     ME       77645        123456789           987654321   Evening at home          VB123123 NY1231456 SS1534668   0.022     3600    2.5    Self Employed   [PHONE]
September 123 ' 2009  [NAME][EMAIL]          micheal      6639 [NAME]   rochester  ME   77546    213456647   [PHONE]    Any time    VB1231231 NY23454351 SS54564654     0.044    1800  7.5  Self Employed    [PHONE]
Text to Column Data
jan | 06'2006 | Adam | [NAME] | [EMAIL] | George | M | Wang | 663 | Southpaw | Drive | Rochester | ME | 77645 | 123456789 | 987654321 | Evening | at | home | VB123123 | NY1231456 | SS1534668 | 0.022 | 3600 | 2.5 | Self | Employed | 6548795621
September | 123 | ' | 2009 | Yi | Yan | Si | [EMAIL] | micheal | 6639 | nothr | street | rochester | ME | 77546 | 213456647 | 21321321321 | Any | time | VB1231231 | NY23454351 | SS54564654 | 0.044 | 1800 | 7.5 | Self | Employed | 6545647987
Spreadsheet: 9133f56c-0a50-45d8-87bb-fc253cac2e45
Sheet: Blank Semester Plan

 | Semester & Subject |  |  |  | Teachers
 | Aug 15-19 |  | Aug 22-26 |  | Aug 29-Sept 2 |  | Sept 5 - 9 |  | Sept 12-16 |  | Sept 19-23
M | Tree Diagrams | M | Perm and Comb Notes | M | 8th grade probability | M | Labor Day | M | Test | M | Review
T | Counting Principles | T | Perm and [NAME]. | T | Dependent and Indendent Prob. | T | Conditional Prob. | T | 5 number summary | T | Test
W | Counting Principles | W | Perm and [NAME] | W | Discovering Mutually Exclusive and [NAME] | W | Expected Value | W | Statistics | W | Review for Cummulative Test
Th | Counting Quiz | Th | Review | Th | Mutually Exclusive and Overlapping Prob | Th | Expected Value | Th | MAD | Th | Cumulative Test Unit 1
F | [NAME] and [NAME] | F | Test | F | Venn Diagram Conditionals | F | Review | F | MAD | F | Simplifying and Distributive
 | Sept 26-30 |  | Oct 3-7 |  | Oct 10-14 |  | Oct 17-21 |  | Oct 24-28 |  | Oct 31-Nov 4
M | Adding and Subtracting Polynomials | M | Multiplying Polynomials | M | Test | M | Fraction operations and Exponent Rules | M | Review for Cummulative Test Unit 2 | M | Function Notation
T | Vocabulary of Polynomials | T | Multiplying Quiz | T | Reviewing Simplifying Radicals | T | Simplifying and Operations on Rationals | T | Cummulative Test Unit 2 | T | Function Notation Quiz
W | Perimeter and Area Models | W | Long Division | W | Simplifying and Radical Operations | W | Operations on Rationals | W | Function Notation Task | W | Parent Function Discovery
Th | Modeling Multiplication | Th | Synthetic Division | Th | Simplifying and Radical Operations | Th | Review | Th | Input output charts | Th | Parent Function notes
F | Multiplying Polynomials | F | Polynomial Operations Review | F | Simplifying Radicals Quiz | F | Test | F | Function Notation Practice | F | Vocabulary of Characteristics
 | Nov 7-11 |  | Nov 14-18 |  | Nov 21-25 |  | Nov 28-Dec 2 |  | Dec 5-9 |  | Dec 12-16
M | Characteristics Practice | M | Test | M | Holiday | M | Sequence Practice | M | Average Rate of Change from graphs | M | Review for Cummulative Test
T | Teacher Work Day | T | 8th Grade Sequences | T | Holiday | T | Sequence Quiz | T | Average Rate of Change Review | T | Cumulative Test Unit 3
W | Function Characteristics | W | Sequence Task | W | Holiday | W | Slope | W | AROC Quiz | W | MidTerm Review
Th | Function Characteristics | Th | [NAME] and [NAME] | Th | Holiday | Th | Average Rate of Change from formulas | Th | Review | Th | MidTerm Review
F | Review | F | Sequence Practice | F | Holiday | F | Average Rate of Change from graphs | F | Test | F | MidTerm Review
 | Dec 19-23
M | MidTerm Review | M |  | M |  |  |  |  |  | M
T | Midterm Review | T |  | T |  |  |  |  |  | T
W | Midterm Review | W |  | W |  |  |  |  |  | W
Th | MidTerm | Th |  | Th |  |  |  |  |  | Th
F | MidTerm | F |  | F |  |  |  |  |  | F
Spreadsheet: 872027d1718377547-create-multiple-sheets-from-data-in-the-rows-of-a-sheet-transpose-example-commercial-permits-6-14-24
Sheet: Forest park Commercial 6-14-24

Record # | Record Type | [NAME] | Date Submitted | Address | [NAME] | Building Type | Street Name | Street No | Owner Name | Owner Phone No | Owner [NAME] | [NAME] | Location
FPB-23-1 | Forest Park Commercial & Multifamily Building Permit Application | [NAME] | 2023-02-13 18:45:29 | 1112 KEMPER MEADOW DR, OH 45240 | Active | NEIGH SHOP CENTER | KEMPER MEADOW DR | 1112 | KKG INVESTMENTS LLC |  |  | [PHONE] | 1112  KEMPER MEADOW DR,  OH 45240
FPB-23-2 | Forest Park Commercial Fire Protection Permit Application | [NAME] | 2023-02-15 14:03:37 | 1192 W Kemper, Cincinnati, Ohio 45240 | Complete |  | W Kemper | 1192 |  |  |  | [PHONE] | 1192  W Kemper, Cincinnati Ohio 45240
FPB-23-3 | Engineering Revision/Temporary Certificate of Occupancy/Inspection/Forest Park Board of Building Appeal |  | 2023-02-15 20:18:47 | 1194 W KEMPER RD, OH 45240 | Complete | NEIGH SHOP CENTER | W KEMPER RD | 1194 | FOREST PARK RETAIL CENTER LLC |  |  | [PHONE] | 1102-1192A [NAME]RD., FOREST PARK OH 45240
FPB-23-4 | Forest Park Commercial Mechanical Permit Application | [NAME] | 2023-02-16 17:45:13 | 1320 KEMPER MEADOW DR, Unit 600, OH 45240 | Complete |  | KEMPER MEADOW DR | 1320 |  |  |  | [PHONE] | 1320  KEMPER MEADOW DR, Unit 600,  OH 45240
FPB-23-5 | Forest Park Commercial Mechanical Permit Application | [NAME] | 2023-02-16 17:54:03 | 1310 KEMPER MEADOW DR, Unit 300, OH 45240 | Complete |  | KEMPER MEADOW DR | 1310 |  |  |  | [PHONE] | 1310  KEMPER MEADOW DR, Unit 300,  OH 45240
FPB-23-6 | Forest Park Commercial Mechanical Permit Application | [NAME] | 2023-02-16 17:56:18 | 1310 KEMPER MEADOW DR, Unit 600, OH 45240 | Complete |  | KEMPER MEADOW DR | 1310 |  |  |  | [PHONE] | 1310  KEMPER MEADOW DR, Unit 600,  OH 45240
FPB-23-8 | Forest Park Commercial Fire Protection Permit Application | MIKE TANNER | 2023-02-20 13:17:16 | 1310 KEMPER MEADOW DR, Unit 300, OH 45240 | Complete |  | KEMPER MEADOW DR | 1310 |  |  |  | [PHONE] | 1310  KEMPER MEADOW DR, Unit 300,  OH 45240
FPB-23-9 | Forest Park Commercial Fire Protection Permit Application | MIKE TANNER | 2023-02-20 13:26:24 | 1310 KEMPER MEADOW DR, Unit 600, OH 45240 | Complete |  | KEMPER MEADOW DR | 1310 |  |  |  | [PHONE] | 1310  KEMPER MEADOW DR, Unit 600,  OH 45240
FPB-23-10 | Forest Park Commercial Sign Permit Application | Sign Connection | 2023-02-23 18:59:53 | 1150-1184 WAYCROSS RD, OH 45240 | Complete | INDEPENDENT LIVING (SENIO | WAYCROSS RD | 1150-1184 | WINTON HOUSE SENIOR APARTMENTS LP |  |  | 9374354070 | 1150  WAYCROSS RD, CINCINNATI OH 45240
FPB-23-11 | Forest Park Commercial Mechanical Permit Application | [NAME] | 2023-02-23 19:58:41 | 1150-1184 WAYCROSS RD, OH 45240 | Complete | INDEPENDENT LIVING (SENIO | WAYCROSS RD | 1150-1184 | WINTON HOUSE SENIOR APARTMENTS LP |  |  | [PHONE] | 1150  WAYCROSS RD, CINCINNATI OH 45240
Spreadsheet: 764283d1642674485-pivot-data-using-excel-formulas-pivot-table-using-formulas
Sheet: Sheet1

 | Input table
 | Unit type | Package 1 | Package 2 | Package 3
 | Type 1 | 1 | 2 | 1
 | Type 2 | 2 | 1 | 1
 | Type 3 | 0 | 0 | 2
 | Output table
 | Unit type | Unit number | Package 1 | Package 2 | Package 3
 | Type 1 | 1 | 1 | 0 | 0
 | Type 1 | 2 | 0 | 1 | 0
 | Type 1 | 3 | 0 | 1 | 0
 | Type 1 | 4 | 0 | 0 | 1
 | Type 2 | 1 | 1 | 0 | 0
 | Type 2 | 2 | 1 | 0 | 0
 | Type 2 | 3 | 0 | 1 | 0
 | Type 2 | 4 | 0 | 0 | 1
 | Type 3 | 1 | 0 | 0 | 1
 | Type 3 | 2 | 0 | 0 | 1
Spreadsheet: 214036d1360779251-returning-a-value-from-a-cell-in-onecolumn-having-checked-for-conditions-in-another-column-for-olives-1-
Sheet: Sheet1

45 | 32.3 | 101 | 1 |  | How can I get the program, Excel, to look at Cell A1, compare A1 to all the cells in Column B and let me know which cells in Column B are greater than A1?
 | 42.6 | 115 | 2 |  |  |  |  |  |  |  | option 1 | option 2
 | 54.3 | 156 | 3 |  |  | Ok, this correct, B3 and B4 are greater than A1
 | 64.1 | 124 | 4
 | 22.3 | 111
 |  |  | I added these numbers above.
 |  |  |  |  | Next: Say there are 2 cells in Column B, for example, say B3 and B4, that are greater than A1. How can I then have Excel look at the adjacent column, Column C, for each of these cells, [NAME] and C4, compare their values and tell me [NAME] is higher than any other match?...
 |  |  |  |  | [NAME] is higher than what ?
 |  |  |  |  | Once B3 and B4 are identified as the solutions to which cells in Col B are greater than A1, the next comparison is with the adjecent cells, [NAME] and C4
 |  |  |  |  | [NAME] and C4 are highlighted in yellow above
 |  |  |  |  | [NAME] and C4 are compared and [NAME] is the one with the greater value (156)
 |  |  |  |  | Now, if I put numbers from 1, 2, 3 etc... in Column A, Excel could return the value 3, telling me [NAME], the highest of the values whose adjacent cell in Column B is greater than A1, is on row 3... Can anyone help? A very simple spreadsheet is attached.
 |  |  |  |  | share your expected output with a sample data
 |  |  |  |  | I would want 4 returned, either because it's on row 4 or because I numbered the column (see above left)
Spreadsheet: kate_symes__18519__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 788758d1658696516-help-with-excel-formula-to-find-the-price-based-on-industry-and-number-of-transactions-ef1587_sample_sliding_discount
Sheet: Input

Input | Industry | Avg Monthly Transactions |  |  |  | Reference 1 | Industry | price |  | Reference 2 | Pricing Tier | Minimum Average Monthly Transactions | Maximum Average Monthly Transactions
 | Automotive | 1128.75 |  |  |  |  | Automotive | 35 |  |  | A | 1 | 100
 | Financial Services | 7219.24 |  |  |  |  | Financial Services | 40 |  |  | B | 101 | 1000
 | Retail | 11795.4 |  |  |  |  | Retail | 30 |  |  | C | 1001 | 2500
 | Financial Services | 10091.76 |  |  |  |  |  |  |  |  | D | 2501 | 5000
 | Retail | 9444.76 |  |  |  |  |  |  |  |  | E | 5001 | 10000
 | Financial Services | 13245.46 |  |  |  |  |  |  |  |  | F | 10001
 | Retail | 5975.31
 | Financial Services | 15891.6
 | Retail | 9132.135
 | Automotive | 11398.24
Spreadsheet: 859076d1707516185-pull-data-from-otherworksheet-by-searching-text-in-the-column-which-is-changed-daily-book1
Sheet: MasterSheet

 | Net Income | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | Total
 | Company 1
 | Company 2