tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1925b837-663e-43b3-a24e-e031589a782d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-07-26 09:17:27.150000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.174 | 101.049 | 100.924 | 100.549
4.625 | 100.241 | 100.116 | 99.991 | 99.616 |  | Note: | Refer To Price [NAME]
4.5 | 99.764 | 99.639 | 99.514 | 99.139 |  |  | For all Price Adjs
4.375 | 99.141 | 99.016 | 98.891
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.629 | 101.504 | 101.379 | 101.004
4 | 101.31 | 101.185 | 101.06 | 100.685
3.875 | 100.908 | 100.783 | 100.658 | 100.283
3.75 | 100.31 | 100.185 | 100.06 | 99.685
3.625 | 99.384 | 99.259 | 99.134
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-08-09 09:17:27.150000
30 DAY | 2011-08-24 09:17:27.150000
45 DAY | 2011-09-08 09:17:27.150000
60 DAY | 2011-09-23 09:17:27.150000
90 DAY | 2011-10-23 09:17:27.150000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 525530d1498761420-list-to-matrix-list-to-matrix-v2
Sheet: Sheet1

Job Number | Employee | Occurances |  |  | Job Number | Employee 1 | 1-Count | Employee 2 | 2-Count | Employee 3 | 3-Count | Employee 4 | 4-Count | Employee 5 | 5-count
1 | [NAME] | 3 |  |  | 1
1 | [NAME] | 4 |  |  | 2
1 | [NAME] | 7 |  |  | 3
2 | [NAME] | 3 |  |  | 4
2 | [NAME] | 4 |  |  | 5
2 | [NAME] | 9
2 | [NAME] | 5
3 | [NAME] | 4
3 | [NAME] | 3
3 | [NAME] | 1
3 | [NAME] | 2
3 | [NAME] | 8
4 | [NAME] | 4
4 | [NAME] | 6
4 | [NAME] | 9
4 | [NAME] | 1
5 | [NAME] | 2
5 | [NAME] | 4
5 | [NAME] | 12
Spreadsheet: 823535d1680003748-complex-split-formula-to-split-column-to-different-columns-sample-split-1-2-
Sheet: sample (2)

POGB0006075-MB2 |  | MB2
POGB0006106-MB2 |  | MB2
[NAME] |  | MB1
POGB0005754-MB2 |  | MB2
POGB0005847-MB2 |  | MB2
POGB0006120-MB2 |  | MB2
POGB0006110-MB2 |  | MB2
POTR0004601-MB1 .POTR0004724-MB1 ,POTR0004723-MB1 .POTR0004719-MB1 ,POTR0004721-MB1 .POTR0004720-MB1 .POT [NAME] |  | MB1 .POTR0004724 | MB1 ,POTR0004723 | [NAME] | MB1 ,POTR0004721 | MB1 .POTR0004720 | MB1 .POT [NAME] | MB1.POTR0004671 | MB1
POGB0005983-MB2,POGB0005893-MB2,POGB0005975-MB2.POGB0005968-MB2.PO GB0005970-MB2.POGB0005961-MB2.POG B0005969-MB2.POGB0005965-MB2.POGB 0005966-MB2.POGB0005964-MB2.POGB0 005967-MB2.POGB0005963-MB2.POGB0005948-MB2 |  | MB2,POGB0005893 | MB2,POGB0005975 | MB2.POGB0005968 | MB2.PO GB0005970 | MB2.POGB0005961 | MB2.POG B0005969 | MB2.POGB0005965 | MB2.POGB 0005966 | MB2.POGB0005964 | MB2.POGB0 005967 | MB2.POGB0005963 | MB2.POGB0005948 | MB2
POGB0006088-MB2 |  | MB2
POTR0004774-MB1 |  | MB1
POTR0004741-MB1 |  | MB1
POGB0006072-MB2 |  | MB2
POGB0005755-MB2 |  | MB2
POTR0004789-MB1 |  | MB1
POTR0004790-MB1 |  | MB1
POGB0006086-MB2 |  | MB2
POGB0006113-MB2 |  | MB2
POTR0004556-MB1 |  | MB1
[NAME] |  | MB1
POTR0004684-MB1 |  | MB1
POTR0004755-MB1 |  | MB1
POTR0004797-MB1 |  | MB1
POTR0004646-MB1 |  | MB1
POTR0004822-MB1 |  | MB1
POGB0006129-MB2.POGB0006130-MB2 |  | MB2.POGB0006130 | MB2
POTR0004823-MB1 |  | MB1
[NAME] |  | MB1
POTR0004836-MB1 |  | MB1
[NAME] |  | MB1
POGB0006285-MB2 |  | MB2
POGB0006277-MB2 |  | MB2
Spreadsheet: michael_maggi__26465__NYMEXWEEKLY
Sheet: ho

Week Ending: | 2001-10-19 00:00:00
 | Futures Settlement Prices
 | HEATING OIL |  |  |  |  | Contract Symbol:  HO
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 0.6311 | 0.6267 | 0.621 | 0.6109 | 0.6263 | 26444
 | 2001-12-01 00:00:00 | 0.6397 | 0.6343 | 0.629 | 0.6161 | 0.6339 | 42523
 | 2002-01-01 00:00:00 | 0.6457 | 0.6408 | 0.636 | 0.6231 | 0.6399 | 24597
 | 2002-02-01 00:00:00 | 0.6447 | 0.6393 | 0.635 | 0.6226 | 0.6379 | 15160
 | 2002-03-01 00:00:00 | 0.6337 | 0.6283 | 0.625 | 0.6121 | 0.6259 | 15606
 | 2002-04-01 00:00:00 | 0.6222 | 0.6168 | 0.615 | 0.6021 | 0.6144 | 9163
 | 2002-05-01 00:00:00 | 0.6102 | 0.6048 | 0.6035 | 0.5911 | 0.6024 | 4541
 | 2002-06-01 00:00:00 | 0.6067 | 0.6013 | 0.601 | 0.5891 | 0.5994 | 7297
 | 2002-07-01 00:00:00 | 0.6097 | 0.6048 | 0.605 | 0.5931 | 0.6029 | 2661
 | 2002-08-01 00:00:00 | 0.6152 | 0.6103 | 0.611 | 0.5991 | 0.6084 | 2269
 | 2002-09-01 00:00:00 | 0.6222 | 0.6173 | 0.6185 | 0.6066 | 0.6159 | 2044
 | 2002-10-01 00:00:00 | 0.6292 | 0.6243 | 0.626 | 0.6141 | 0.6234 | 1463
 | Total Weekly Volume |  | 176893 |  | Total Open Interest |  | 159124
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | Heating Oil
 | 5 Day Hist. Vol. |  |  | 0.2953
 | 20 Day Hist. Vol. |  |  | 0.3502
 | Implied Volatility-Options |  |  | Heating Oil
 | At the Money Call & Put |  |  | 0.5013
Spreadsheet: 12852234-df04-43a0-b299-cc2e31369788
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 9314.0 Sales of New Motor Vehicles, Australia
 | Table 1: New Motor Vehicles Sales by Type, All series
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aust. ;  Passenger vehicles ; |  |  | Original | A367169W | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Original | A367214W | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Original | A367259A | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Original | A367304A | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Seasonally Adjusted | A367170F | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Seasonally Adjusted | A367215X | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Seasonally Adjusted | A367260K | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Seasonally Adjusted | A367305C | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Trend | A367171J | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Trend | A367216A | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Trend | A367261L | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Trend | A367306F | 1994-01-01 00:00:00 | 2011-03-01 00:00:00 | 207 | Number | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 884878d1734179033-2-columns-with-start-time-and-start-finish-to-count-by-hour-count-emp-working-given-hour
Sheet: Sheet1

Trying to use Excel to schedule employees shifts.  I want to be able to count the number of employees
working during each hour of the day.  I tried using a COUNTIF formula I saw on another site but I can't
get it to work with my setup.
 | Monday |  |  |  |  | ExcelExperts
 | Start | End | Real # of employees on shift each hour (figured manually) |  | My weak attempt | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Workers
[NAME] | 08:00:00 | 16:00:00 | 2 | 08:00:00
[NAME] | 10:00:00 | 18:00:00 | 2 | 09:00:00
[NAME] | 12:00:00 | 18:00:00 | 3 | 10:00:00
[NAME] | 08:00:00 | 14:00:00 | 4 | 11:00:00
[NAME] | 07:00:00 | 17:00:00 | 5 | 12:00:00
[NAME] | 13:00:00 | 20:00:00 | 6 | 13:00:00
 |  |  | 5 | 14:00:00
 |  |  | 5 | 15:00:00
 |  |  | 4 | 16:00:00
 |  |  | 3 | 17:00:00
 |  |  | 1 | 18:00:00
 |  |  | 1 | 19:00:00
 |  |  | 1 | 20:00:00
 |  |  | 0 | 21:00:00
 |  |  | 0 | 22:00:00
 |  |  | 0 | 23:00:00
Spreadsheet: 711698d1609854314-sum-values-with-criteria-computercount
Sheet: Sheet1

PC forecast | January | February | March |  |  | Count:
AME |  |  |  |  |  | PC Model | Jan | Feb | Mar
USA/Canada |  |  |  |  |  | ThinkPad T14 | ? | ? | ?
PC model |  |  |  |  |  | ThinkPad P15 | ? | ? | ?
ThinkPad T14 | 1 | 9 | 3 |  |  | ThinkCentre | ? | ? | ?
ThinkPad P15 | 4 | 4 | 6 |  |  | ThinkStation | ? | ? | ?
ThinkCentre | 3 | 2 | 3
ThinkStation | 4 | 2 | 6
Chile
PC model
ThinkPad T14 | 3 | 3 | 5
ThinkPad P15 | 4 | 5 | 2
ThinkCentre | 1 | 2 | 1
ThinkStation | 2 | 3 | 1
Peru
PC model
ThinkPad T14 | 1 | 2 | 2
ThinkPad P15 | 7 | 7 | 8
ThinkCentre | 3 | 4 | 3
ThinkStation | 3 | 4 | 2
Mexico
PC model
ThinkPad T14 | 1 | 2 | 2
ThinkPad P15 | 2 | 2 | 4
ThinkCentre | 4 | 2 | 5
ThinkStation | 4 | 1 | 3
Spreadsheet: 845072d1696617199-change-dates-depending-on-certain-cell-test-foodorder_gw
Sheet: 3 DAYTESTER

 |  | Food orders
 |  |  | Contact Name |  | PHONE NO:
 |  |  |  |  | PH NO HERE
 |  |  | Account No |  | EMAIL:
 |  |  | AC NO HERE |  | ADD EMAIL HERE
 |  |  | SELECT SUPPLIER
 |  |  |  |  | Date:
 |  | WEEK 1 | Products | Code | Price | Qty | Total
 |  | Monday | Chips |  |  | 8
 |  | DELIVERY DAY | 190g Chicken Kiev |  |  | 4
 |  | 2023-10-09 00:00:00 | Chips |  |  | 4
 |  |  | Pork Loin Chop |  |  | 4
 |  |  | Chips |  |  | 3
 |  |  | Bacon Chop |  |  | 1
 |  |  | Chips |  |  | 1
 |  |  | Chips |  |  | 3
 |  |  | Chips |  |  | 3
 |  |  |  |  | vfbvcfcbfd
 |  | WEEK 1 | Products | Code | Price | Qty | Total
 |  | Tuesday | Spice Burger |  |  | 8
 |  | DELIVERY DAY | Pork Loin Chop |  |  | 4
 |  |  | Pork Loin Chop |  |  | 4
 |  |  | Pork Loin Chop |  |  | 4
 |  |  | Pork Loin Chop |  |  | 3
 |  |  | Pork Loin Chop |  |  | 1
 |  |  | [NAME] 1x5 KG |  |  | 1
 |  |  | Bananas |  |  | 3
 |  | WEEK 1 | Product | Code | Price | Qty | Total
 |  | Thursday | Basil |  |  | 8
 |  | DELIVERY DAY | 2.5kg Diced Bacon 95% CL |  |  | 4
 |  |  | Diced Carrot & Turnip 1x5 KG |  |  | 4
 |  |  | Stir [NAME] 1x2 KG |  |  | 7
 |  |  | Spanish Onions Large 1x20 KG |  |  | 2
 |  |  | [NAME] 1x2.27 KG |  |  | 2
 |  |  | Mini Potatoes 1x10 [NAME] |  |  | 3
 |  |  | Bananas 1x12.72 KG |  |  | 3
 |  |  | Golden Delicious Apples 1x100'S |  |  | 2
 |  | WEEK 2
 |  | Tuesday
 |  | DELIVERY DAY
 |  | WEEK 2
 |  | Wednesday
 |  | DELIVERY DAY
 |  | WEEK 3
 |  | Monday
 |  | DELIVERY DAY
Spreadsheet: 6597b121-8005-451d-852c-94908476e121
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Eiendomsforvaltning og -utvikling
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Veidekke ASA | [NAME] v 4 | 0278 | Oslo | 21 05 50 00 | 21 05 50 01
OBOS Eiendomsforvaltning AS | Hammersborg Torg 1 | 0179 | Oslo | 22 86 59 99 | 22 86 59 76
Bryn Eiendom AS | [NAME] v 2 | 0667 | Oslo | 23 37 98 00 | 22 65 65 65
[NAME] | Hyggenv. 35 | 3440 | [NAME] | 31 29 79 50
Statsbygg | Biskop Gunnerus' g 6 | 0155 | Oslo | 815 55 045 | 22 95 40 01
Kongsberg Teknologipark AS | Kirkegårdsv. 45 | 3616 | Kongsberg | 32 28 82 50 | 32 28 83 00
Scandinavian Development AS | Parkv. 33 | 0258 | Oslo | 24 11 56 56 | 24 11 56 57
[NAME] | [NAME]. 1A | 5017 | Bergen | 55 21 76 70 | 55 21 76 80
Furuholmen Eiendom AS | Sørkedalsv. 24 | 0369 | Oslo | 23 19 62 80 | 23 19 62 99
[NAME] |  | 2624 | Lillehammer | 907 84 289
NCC Property Development AS | Østensjøv. 27 | 0661 | Oslo | 22 98 68 00
Mørstad Invest AS | Industriv. 29 | 2020 | Skedsmokorset | 63 87 65 05 | 63 87 64 87
Eiendomsinvest | [NAME] | 6010 | Ålesund | 70 17 83 00
Jensen Valter Eiendom ANS | Kristinelundv. 6 | 0268 | Oslo | 22 12 46 60 | 22 12 46 61
Hinna Park AS | [NAME]. 7 | 4020 | Stavanger | 51 95 73 00 | 51 95 73 01
Norrøna Eiendom AS | Hulderv. 10 | 9016 | Tromsø | 77 68 62 14
[NAME] bygg AS | Luramyrv. 59 | 4313 | Sandnes | 926 51 041
Sandnes Eiendom Invest AS | Gravarsv. 32 | 4306 | Sandnes | 51 60 59 00 | 51 66 09 44
Oslo S Utvikling AS | [NAME] g 16 | 0191 | Oslo | 22 36 60 20 | 22 36 60 21
Backer AS | Møllendalsv. 6 | 5009 | Bergen | 55 11 52 00 | 55 11 52 11
Pihl AS | [NAME] 2001 | 2612 | Sjusjøen | 62 33 43 80 | 62 33 43 81
Øra Industripark AS | Ørav. 2 | 1630 | Gamle Fredrikstad | 69 39 52 00 | 69 39 52 01
ICA Eiendom Norge AS | Sinsenv. 45 | 0585 | Oslo | 23 05 50 00
Steen Holding AS | [NAME]. 41 | 2317 | Hamar | 62 52 79 95
StorBergen Boligbyggelag | [NAME] | 5008 | Bergen | 55 94 27 00 | 55 94 27 01
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 121837d1316447781-an-addition-to-an-if-formula-timesheet
Sheet: Sheet2

 | 07:00:00
 | 07:15:00
 | 07:30:00
 | 07:45:00
 | 08:00:00
 | 08:15:00
 | 08:30:00
 | 08:45:00
 | 09:00:00
 | 09:15:00
 | 09:30:00
 | 09:45:00
 | 10:00:00
 | 10:15:00
 | 10:30:00
 | 10:45:00
 | 11:00:00
 | 11:15:00
 | 11:30:00
 | 11:45:00
 | 12:00:00
 | 12:15:00
 | 12:30:00
 | 12:45:00
 | 13:00:00
 | 13:15:00
 | 13:30:00
 | 13:45:00
 | 14:00:00
 | 14:15:00
 | 14:30:00
 | 14:45:00
 | 15:00:00
 | 15:15:00
 | 15:30:00
 | 15:45:00
 | 16:00:00
 | 16:15:00
 | 16:30:00
 | 16:45:00
 | 17:00:00
 | 17:15:00
 | 17:30:00
 | 17:45:00
 | 18:00:00
 | 18:15:00
 | 18:30:00
 | 18:45:00
 | 19:00:00
 | 19:15:00
 | 19:30:00
 | 19:45:00
 | 20:00:00
 | 20:15:00
 | 20:30:00
 | 20:45:00
 | 21:00:00
Spreadsheet: 54f86af5-c44c-4030-b8c8-2753ffc76b7f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6282 | 30751 | Edgardo | Puet | ARG | 0 | [NAME] | [NAME] | 01:31:33 | [NAME] | 00:24:12 | 1 | 02:42:44
6282 | 30748 | [NAME] | Galarza | ARG | 0 | 00:45:26 | 00:00:57 | 01:31:15 | 00:00:57 | 00:26:30 | 2 | 02:45:04
6282 | 45301 | Nestor | Orsi | ARG | 0 | [NAME] | [NAME] | [NAME] | [NAME] | 00:26:44 | 3 | 02:52:53
6282 | 45303 | [NAME] | Marquez | ARG | 0 | 00:52:29 | 00:02:02 | 01:37:25 | 00:02:02 | 00:31:52 | 4 | [NAME]
Spreadsheet: 99416d1298040023-error-on-nested-if-statement-flowchart1
Sheet: Sheet1

vlookup(95 Number,'Product Table'!N1:P309,3,FALSE))))))
 |  | C2 = Line 10
 | 1 |  | 0
 | 200 |  | C2 = Either Line 1 or Line 5
 |  | 1 |  |  | 0
 |  | A1>50 |  |  | C2 = Line 2,3,4 or 6
 | 1 |  | 0 | 1 |  |  | 0
 | 200 |  | 240 | A1>80 |  |  | C2=Line 9
 |  |  | 1 |  | 0 | 1 |  | 0
 |  |  | 150 |  | 170 | VLOOKUP("95 Number", Product Table!N1:P309,3,FALSE) |  | 0
Spreadsheet: michelle_lokay__26547__EOLTWdeals
Sheet: EOLDec01

 |  |  |  |  | New This Week
 | PRODUCTION  MONTH : |  |  |  | 2001-12-01 00:00:00 |  |  |  | Transwestern Pipeline Company
 | Contract | Shipper |  | Non | Term | Term | Monthly | # |  | Demand | Demand | Commodity | Total | Monthly | Monthly | Total Monthly | NOTES
 | # |  | Daily | [NAME] | Start | End | Volume | Days | MDQ | Monthly $ | Daily $ | per [NAME] | Rate | Demand | Commodity | Revenue
1 | 27748 | Burlington Resources | n |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 |  | 31 | 10000 |  | 0.05 | 1-Part |  |  | 0 |  | La Maquina to I/B Link
 | Total Deals
 |  |  |  |  |  |  | MMBtu |  | MMBtu |  |  |  |  | Monthly Demand | Commodity | Total Revenue
Spreadsheet: 805797d1668929587-search-tab-for-specific-text-then-offset-from-the-cell-containing-that-text-example2-1-
Sheet: Beta

 |  |  |  | Transaction Links | All Weather | 2023-09-30 00:00:00
 |  |  |  | Cash Flow Type | Cash Flow Name
 |  |  |  | Contributions | Fees | 0 | 7.897033991517565 | 0 | 6.013480804520922 | 0 | 4.53544394332155 | 0 | 3.431886901881908
 |  |  |  | Contributions | Expenses | 22.43017550062175 | 0 | 173.8117556586841 | 0 | 202.6633774997705 | 0 | 267.6713243095267 | 0
 |  |  |  | Contributions | Capital Calls | 8.485899289745902 | -0.1362003731834112 | 57.63091617980378 | -0.06897445300892191 | 73.80052705637746 | -2.20400153396699 | 96.91867028270889 | -0.4353141557889346
 |  |  |  | Contributions | Distributions | 0.9926080509970963 | -0.07056994952756433 | 6.849465590579263 | -0.05373802839342566 | 8.968512089571465 | -0.35951927333282 | 11.78152681095504 | -0.09446610722979704
 |  |  |  | Distributions |  | 0.9926080509970963 | -0.07056994952756433 | 6.849465590579263 | -0.05373802839342566 | 8.968512089571465 | -0.35951927333282 | 11.78152681095504 | -0.09446610722979704
 |  |  |  | Distributions |  | 6.798834690236557 | -0.4833664410179672 | 46.91517887652933 | -2.521129214549577 | 420.7593489385612 | -16.86691101796909 | 552.7324377745817 | -4.431894318455329
 |  |  |  | Distributions |  | 8.933472458973867 | -0.635129545748079 | 61.64519031521337 | -0.4836422555408309 | 80.71660880614319 | -3.23567345999538 | 106.0337412985953 | -0.8501949650681733
 |  |  |  | Distributions |  | 2.977824152991289 | -0.211709848582693 | 20.54839677173779 | -0.161214085180277 | 26.9055362687144 | -1.07855781999846 | 35.34458043286511 | -0.2833983216893911
Spreadsheet: 858829d1707357192-flatten-a-random-matrix-example-data
Sheet: Sheet1

 |  |  |  | Red | Blue
a | 1 | 2 | 3
b | 4
c | 5 | 6
a | 1Red
a | 2Red
a | 3Red
a | 1Blue
a | 2Blue
a | 3Blue
b | 4Red
b | 4Blue
c | 5Red
c | 6Red
c | 5Blue
c | 6Blue
Spreadsheet: daren_farmer__6594__HL&PMTD
Sheet: Feb 00

HL&P MONTH TO DATE
 | NOMS |  |  |  |  |  |  |  |  |  |  |  |  |  | BAV FLOW
 |  |  |  |  |  |  |  |  |  |  |  |  | NOM |  |  |  |  |  |  |  |  |  | BAV
 | 7268 |  |  |  |  |  | 1554 |  | 1554 |  | 1554 |  | TOTAL |  | 1393 | 1396 | 1401 | 1412 | 1480 |  | 1554 |  | TOTAL |  | DIFF.
DAY | 3 rd Party |  | HPL Spot |  |  |  | HPL |  | HPL SPOT |  | 3rd Party
2000-02-01 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 12038 |  |  |  | 24472
2000-02-02 00:00:00 |  |  | 20000 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 27480 |  | 14642 |  | 12991
2000-02-03 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 22948 |  |  |  | 11988
2000-02-04 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 23692 |  |  |  | 12325
2000-02-05 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 24987 |  |  |  | 11448
2000-02-06 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 21959 |  |  |  | 14061
2000-02-07 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 6002 |  |  |  | 29562
2000-02-08 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 34173
2000-02-09 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 33736
2000-02-10 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 33494
2000-02-11 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 24 |  |  |  | 33850
2000-02-12 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 32756
2000-02-13 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 32061
2000-02-14 00:00:00 |  |  | 23333 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 14492 | 8175 |  |  | 34228
2000-02-15 00:00:00 | 10000 |  | 10000 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 19591 |  |  |  | 34428
2000-02-16 00:00:00 | 10000 |  | 20000 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 29271 |  |  |  | 34082
2000-02-17 00:00:00 | 10000 |  | 20000 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 28920 |  |  |  | 33949
2000-02-18 00:00:00 |  |  |  |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 144 |  |  |  | 33768
2000-02-19 00:00:00 |  |  | 20000 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 19595 |  |  |  | 35014
2000-02-20 00:00:00 |  |  | 20000 |  |  |  | 34118 |  |  |  |  |  |  |  |  |  | 19582 |  |  |  | 34576
2000-02-21 00:00:00
2000-02-22 00:00:00
2000-02-23 00:00:00
2000-02-24 00:00:00
2000-02-25 00:00:00
2000-02-26 00:00:00
2000-02-27 00:00:00
2000-02-28 00:00:00
2000-02-29 00:00:00
 | 3rd Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All 3rd Party is kept
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | whole.