tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109828d1306603789-avoid-repetition-tekla-parts
Sheet: Lista parti

[NAME]
SPD24"X0.75"
PL640*20
PL654*20
PL423.9*20
PD6.625"X0.2
SPD30"X1.0"
SPD16"X0.5"
SPD16"X0.5"
D20
PL10X214
SPD24"X0.5"
SPD24"X0.5"
SPD24"X0.5"
SPD24"X0.5"
PD14"X0.75"
PD14"X0.75"
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
SPD24"X0.75"
SPD24"X0.75"
SPD24"X0.75"
SPD24"X0.75"
SPD24"X0.75"
SPD24"X0.75"
SPD24"X0.75"
SPD24"X0.75"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.5"
SPD16"X0.375
SPD16"X0.375
SPD16"X0.375
SPD16"X0.375
PD16"X0.75"
SPD16"X0.375
SPD16"X0.375
SPD20"X0.75"
SPD20"X0.75"
SPD20"X0.75"
SPD20"X0.75"
SPD20"X0.75"
SPD20"X1.0"
SPD20"X1.0"
PD12.75"X0.5
PD12.75"X0.5
PD12.75"X0.3
PD12.75"X0.3
PD12.75"X0.5
PD12.75"X0.3
PD12.75"X0.5
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PD8.625"X0.3
PL423.9*20
PL319.1*20
PL373.1*20
PL319.1*20
PL268.3*20
PL268.3*20
PL10X214
PL10X214
PL10X214
PL10X214
PL10X214
PD16"X0.75"
PD16"X0.75"
PD16"X0.75"
PD16"X0.75"
PD16"X0.75"
PD16"X0.75"
PD16"X0.75"
PD16"X0.75"
PD16"X0.75"
PL373.1*12
PL423.9*20
PL6*313
PD14"X0.375"
PD14"X0.375"
PD14"X0.375"
PD6.625"X0.2
PD6.625"X0.2
PD6.625"X0.2
SPD24"X1.0"
SPD24"X1.0"
SPD24"X1.0"
SPD24"X1.0"
SPD30"X1.0"
SPD34"X0.5"
SPD30"X1.0"
SPD30"X1.0"
SPD48"X1.5"
SPD48"X1.5"
SPD48"X0.5"
SPD48"X0.5"
PD8.625"X0.3
SPD30"X1.0"
SPD24"X0.75"
PL10X214
PL10X214
SPD30"X1.0"
SPD30"X1.0"
SPD30"X1.0"
SPD30"X1.0"
SPD30"X1.0"
PL10X214
SPD16"X0.5"
SPD16"X0.375
SPD16"X0.375
SPD1066*25
PL10*186
PL10*277
PL10*277
PL10*277
PL20*868
PL20*1140
PL20*1376
PL560*20
SCONE2116*10
[NAME]*20
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
SPD16"X0.375
SPD16"X0.375
SPD16"X0.375
PL268.3*12
PL10*125
W18X97
W18X97
W18X97
W18X97
W18X97
W18X97
PL6*5120
L125*75*10
L125*75*10
L125*75*10
L125*75*10
L125*75*10
W14X48
W14X48
W14X48
PD10.75"X0.5
PD10.75"X0.5
SPD16"X0.375
SPD16"X0.375
SPD16"X0.375
SPD16"X0.375
PL20*194.17
PD16"X0.75"
SPD38"X0.5"
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
PL375*20
PL375*20
PL20*194.17
PD10.75"X0.5
PD16"X0.75"
PD10.75"X0.5
PD8.625"X0.3
PD8.625"X0.3
PD14"X8-5/8"
PD10.75"X0.5
PD10.75"X0.5
PD10.75"X0.5
PL319.1*20
PL432*6
PL268.3*12
PL373.1*12
PL268.3*12
PL268.3*12
PD14"X0.375"
PD14"X0.375"
PD14"X0.375"
PD14"X0.375"
PD14"X0.375"
PL10X214
PL12*158
PL12*158
PL12*159
PL10*476
PL6*476
PL6.4*476
[NAME]
PD16"X12-3/4
PL432*10
[NAME]
PD14"X8-5/8"
PL432*6.4
PD12.75"X0.5
ROD25
PL20*262.84
PL10*100
PL10*277
D20
PL10*102
PL6*108
PL6*108
W14X48
PL560*32
Spreadsheet: 852984d1702960363-filling-with-next-available-value-sample-excel-file
Sheet: Sheet1

 | 1
 | 1
 | 1
1 | 1
 | 10
 | 10
 | 10
 | 10
10 | 10
 | 12
 | 12
 | 12
 | 12
 | 12
 | 12
12 | 12
 | 8
 | 8
 | 8
8 | 8
Spreadsheet: 852693d1702647151-search-entire-workbook-and-display-results-search
Sheet: CAT C

Original Part No. | Customer A Part No. | Customer B Part No. | Customer C Part No.
CC001MX | C001F | CC-001-F | C1MX
CC002MX | C002F | CC-002-F | C2MX
[NAME] | C003F | CC-003-F | [NAME]
CC004MX | C004F | CC-004-F | C4MX
CC005MX | C005F | CC-005-F | C5MX
Spreadsheet: 125098d1318877530-spatially-formatting-a-graph-legend-how-to-format-legend-elmental-analysis
Sheet: Sheet1

 |  |  |  | Element
 |  |  |  | C | H | N | P | N/P
 |  |  | Experimental | 34.88500000000001 | 3.825 | 14.725 | 8.7875 | 0
 |  |  | Theoretical | 34.2 | 3.21 | 15.32 | 9.05 | 0
 |  |  | Experimental N/P |  |  |  |  | 1.655
 |  |  | Theoretical N/P |  |  |  |  | 1.69
Spreadsheet: 687530d1595261371-lookup-formula-to-output-all-values-tied-to-one-value-lookup-formula-to-output-matching-projects
Sheet: Sheet1

Project:
PR556000
Project Num | WO Num | Location | Submit Date
PR556000 | WO 3444 | Palm Springs | 2020-03-01 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-02 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-03 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-04 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-05 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-06 00:00:00
How do I get the output of all of the values assocaited with the project number listed in the "Project" field?
Spreadsheet: 726575d1617299681-sumifs-issue-template
Sheet: JUL

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-07-01 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 30
Spreadsheet: chris_germany__1984__ProducerAnalysis
Sheet: Volume Summary

Dominion Producers
Month | ENA Supply |  |  |  | ENA Accum Imbalance |  |  |  | [NAME] by [NAME]
 | 8T001S | 8G001S | 8G001N |  | 8T001S | 8G001S | 8G001N |  | 8T001S | 8G001S | 8G001N |  | Comments
2001-09-01 00:00:00 | 8188 | 170953 | 33 |  | -1091 | -122724 | 33 |  | 111 | 2338
2001-10-01 00:00:00 | 7886 | 184454 | 225 |  | 6795 | -14741 | 258 |  | 6 | 5068
2001-11-01 00:00:00 | 6687 | 163629 | 1095 |  | 5412 | -26482 | 1323 |  | 134 | 1665 | 72
2001-12-01 00:00:00 | 3493 | 70856 | 864 |  | 8143 | 31583 | 2187 |  | 48 | 662
2002-01-01 00:00:00 | 3881 | 137063 | 619 |  | 12024 | 168646 | 2806 |  | -373 | 175
2002-02-01 00:00:00 | -4223 | -157445 | -641 |  | 7801 | 11201 | 2165 |  | -4357 | -161430 | -641
Month | EES Supply |  |  |  | EES Accum Imbalance |  |  |  | [NAME] by [NAME]
 | 8G310N | 8G310S | 8T310S |  | 8G310N | 8G310S | 8T310S |  | 8G310N | 8G310S | 8T310S |  | Comments
2001-09-01 00:00:00 | 8835 | 41351 | 11672 |  | -6045 | 9100 | 8001 |  |  | 44 | 7
2001-10-01 00:00:00 | 24580 | 41916 | 10754 |  | 524 | 8515 | 744 |  | 6001
2001-11-01 00:00:00 | 14893 | 34521 | 8713 |  | -393 | 1336 | -3053
2001-12-01 00:00:00 | 1318 | 15450 | 2757 |  | 460 | 12790 | -1418 |  |  | 65 | 12
2002-01-01 00:00:00 | 17848 | 24773 | 9700 |  | 18308 | 37563 | 8282 |  |  | 10 | 12
2002-02-01 00:00:00 | -18325 | -38746 | -11891 |  | -17 | -1183 | -3609 |  | -18325 | -38746 | -11891
Notes: | *  The Supply volumes are from Dominion's Allocation Balance Reports by production month.
 | *  The Accum Imbalance volumes are from [NAME] which includes prior period adjustments.
 | *  The Adj By Acct Mo volumes are from the Allocation Balance Report's.
 | *  As of Dec 2001, ENA had 55 producers and 192 meters.
 | *  Two ENA producers were at a fixed price of $4.38 for 5,500 dth ([NAME] good through Nov 2002) and $5.80 for 1,377 dth (Commonweath good thru end of Dec)
 | *  As of Dec 2001, EES had 9 producers and 9 meters.
 | *  EES had a supply from Triad Energy with tiered pricing of $4.48 for 5,000 dth and anything over 5,000 at index.  The term is through Oct 2002.
 | Triad produced about 9,800 dth for Dec 2001 production.
 | *  Most of the supply is purchased under contracts with a 30 day termination notice.  Currently we don't have any statistics on how many
 | producers, if any, have properly terminated their contracts.
Assumptions
 | *  We are assuming that the decrease in Supply volume for Nov 2001 and Dec 2001 is due largely to line pressure which
 | is typical of low demand and high storage inventory levels.
Spreadsheet: 723447d1615706030-list-of-products-for-selected-company-list-of-products
Sheet: Sheet1

S.NO. | COMPANY NAME | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY |  | PRODUCT | B
1 | A | HMS | YES | PNS | YES | STEEL SCRAP | NO | HBI | YES | REBAR | YES
2 | B |  |  |  |  | STEEL SCRAP | NO |  |  |  |  |  |  | LIST OF PRODUCTS
3 | C | HMS | YES |  |  |  |  |  |  | REBAR | YES
4 | D |  |  |  |  | STEEL SCRAP | NO
5 | E |  |  |  |  |  |  |  |  | REBAR | YES
6 | F | HMS | NO | PNS | YES
7 | G | HMS | NO |  |  | STEEL SCRAP | NO
8 | H |  |  | PNS | YES
9 | I |  |  |  |  |  |  |  |  | REBAR | YES
10 | J | HMS | YES | PNS | NO | STEEL SCRAP | YES
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 13 - Table 1

LAS CSD&Nanc |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 3Q10 | Scope |  |  | 3Q11 | Reported | Organic
Volume ('000 hl) | 2905.378000000001 | 0 | 0 | 48.61999999999898 | 2953.998 | 0.01673448343038286 | 0.01673448343038289
Net revenue | 229.6039999999999 | 0 | -43.24235658370046 | 77.8513565837005 | 264.213 | 0.1507334366997093 | 0.3390679456093993
Net revenue/hl | 79.02723845227707 | 0 | -14.63858695357968 | 25.05385997219729 | 89.4425114708947 | 0.1317934578329876 | 0.317028159693658
[NAME] | -146.9522179392592 | 0 | 27.05912107813066 | -40.78866313887144 | -160.68176 | 0.09342861409833025 | 0.2775641205751035
[NAME]/hl | -50.57938001157136 | 0 | 9.160169058384827 | -12.97546365390528 | -54.39467460709182 | 0.0754318181568776 | 0.2565366291745135
Gross profit | 82.65178206074071 | 0 | -16.1832355055698 | 37.06269344482905 | 103.53124 | 0.2526195735733194 | 0.4484197741506857
Gross margin | 0.3599753578367134 | 0 | 0 | 0 | 0.3918476380798824 | 320 | 290
SG&A excl. deprec.&amort. | -52.95299999999997 | 0 | 8.687487107433668 | -12.1444871074337 | -56.41 | 0.06528430872660729 | 0.2293446472802996
SG&A deprec.&amort. | -7.604000000000003 | 0 | 1.300829290118035 | -1.239829290118033 | -7.543 | -0.00802209363492934 | 0.1630496173222031
SG&A total | -60.557 | 0 | 9.988316397551742 | -13.38431639755173 | -63.953 | 0.05607939627128156 | 0.221020136359987
Other operating income/expenses | -1.069129476584022 | 0 | -0.8081221950853767 | 7.112613267424933 | 5.235361595755535 | nm | nm
Normalized EBIT | 21.02565258415669 | 0 | -7.003041303103432 | 30.79099031470225 | 44.81360159575551 | 1.131377440789808 | 1.464448734300117
Normalized EBIT margin | 0.0915735465591048 | 0 | 0 | 0 | 0.1696116451338712 | 780 | 770
Normalized EBITDA | 36.83665258415672 | 0 | -9.107837691439752 | 31.55278670303857 | 59.28160159575554 | 0.6093102232978764 | 0.856559553856131
Normalized EBITDA margin | 0.1604355872901027 | 0 | 0 | 0 | 0.2243704950012132 | 640 | 620
Spreadsheet: 42d43986-9377-48d3-acc5-e422646117b1
Sheet: Table 3.5

Monthly Statistical Bulletin
3.5 Labour productivity
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012-13
Labour productivity index (a) (b)
September
December
March
June
Annual
Quarterly change (a) – per cent
September | 0
December
March
June |  |  |  | 0
Annual change (a) – per cent
\
September
December
March
June
Annual
(a) Quarterly figures are seasonally adjusted.
(b) Reference year for index is 2009–10 = 100.0.
Source: ABS, Australian national accounts: national income, expenditure and product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
Cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
 |  |  |  |  |  |  |  | Update
Spreadsheet: 76744d1277238708-work-out-from-dataset-screenshot-browser-version-analysis-14jun-21jun
Sheet: Sheet1

Internet Explorer | Visits
8 | 281108
7 | 87185
6 | 15705
Firefox | Visits
3.6 | 92058
3.5.9 | 23542
3.0.19 | 7425
3.6 | 2542
2.0.0.20 | 1134
3.6.2 | 1018
Chrome | Visits
5.0.375.70 | 45702
Opera | Visits
531.22.7 | 8364
533.16 | 7163
531.21.10 | 3849
531.9 | 1542
Spreadsheet: 3873d0b0-b846-4877-8ab2-3242beb204f0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Gene | qRT-PCR primer sets | Tm (°C)
 | attacin | F - 5'-ATGCCAACCTCTTCAACGAC-3' | 55
 |  | R - 5'-CGTAACCTAAGCCTCCACCA-3' | 56
 | cecropin | F - 5'-AGAGCGAAGCTGGTTGGTTA-3' | 56
 |  | R - 5'-GCAACATTTGCTGCTTGGTTG-3' | 56
 | [NAME] | F - 5'-GCACGAGGAAACAGTCAACA-3' | 56
 |  | R - 5'-CAGTAACGGCAACAGCACAT-3' | 56
 | tep2 | F - 5'-TGCTATCGTGGCAGACAAAG-3' | 55
 |  | R - 5'-ATACAGAGTGGCGGGAACTG-3' | 56
 | tep4 | F - 5'-CTGGGCATTACAGCAGACAA-3' | 55
 |  | R - 5'-CGGAATAAGGCAAACGGATA-3' | 52
 | PPO | F - 5'-ATGGTATGTGCGGGAACTTT-3' | 54
 |  | R - 5'-CCTTTCAGCCTGAGAACTGC-3' | 55
 | iNOS | F - 5'-GCTCTCAAGGCTCAGGATG-3' | 55
 |  | R - 5'-CTTGCCAGAAAGATCGGAATG-3' | 54
 | serpent | F - 5'-ATGGCTGCTTAACGCTATGC-3' | 56
 |  | R - 5'-GCCTGCTCAAATTGCTTAACG-3' | 55
 | lozenge | F - 5'-GAGGCAACTTGTAGAGGATATGG-3' | 55
 |  | R - 5'-CGCTATGGTCACCGTCAAAG-3' | 56
 | fliC | F - 5'-GAAGGTGTGATTTCTACGGGCAAAG-3' | 54
 |  | R - 5'-GCGACTGGCTCAGGTTGGC-3' | 55
 | groEL | F - 5'-CAGAGGATATCGAAGGTGAA-3' | 55
 |  | F - 5'-CCTGGAGCTTTTACTGCGG-3' | 55
 | beta-tubulin | F - 5'-CCATTCCCACGTCTTCACTT-3' | 55
 |  | R - 5'-GACCATGACGTGGATCACAG-3' | 55
Spreadsheet: 868842d1715564596-custom-calendar-help-dynamic-calendar-3-
Sheet: DEC

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
C |  | C |  | B |  | B |  | B |  | B |  | D
D |  | D |  | A |  | A |  | A |  | A |  | C
D |  | D |  | D |  | A |  | A |  | A |  | A
C |  | C |  | C |  | B |  | B |  | B |  | B
C |  | C |  | C |  | C |  | B |  | B |  | B
D |  | D |  | D |  | D |  | A |  | A |  | A
B |  | D |  | D |  | D |  | D |  | A |  | A
A |  | C |  | C |  | C |  | C |  | B |  | B
A |  | A |  | C
B |  | B |  | D
Spreadsheet: sara_shackleton__36396__projectlisting
Sheet: Projects

PULP & PAPER
TRANSACTIONS/STATUS REPORT
I.
Active Projects
Item # | PROJECT |  | RESPONSIBLE |  | DEAL MAKER |  | PROJECTED |  | STATUS/COMMENTS
 |  |  | ATTORNEY |  |  |  | CLOSING
1 | Skeena |  |  |  | [NAME] |  | 2000-01-01 00:00:00 |  | Financing project for pulp mill, 4 saw mills.
 |  |  |  |  |  |  |  |  | [NAME] located in B.C. Canada.  [NAME].
 |  |  |  |  |  |  |  |  | 2.4 million cubic meters of annual timber cut.
2 | Pontiac |  |  |  | [NAME] |  | 4th qtr 99 |  | NBHK. [NAME] location.
 |  |  |  |  |  |  |  |  | [NAME] /yr photo graphic pulp.. Jv. With Tembec.
3 | Celgar |  |  |  | [NAME] |  | Open |  | [NAME]/yr. NBSK. [NAME]
4 | Kenaf |  |  |  | [NAME] |  | 4th qtr 99 |  | Financing project for newsprint mill project.
5 | Northbrook |  |  |  | [NAME] |  | Open |  | [NAME] and 4 Saw Mills. CanFor purchasing.
 |  |  |  |  |  |  |  |  | Enron/Sodra possible J.V.
6 | FSC |  |  |  | Calger/Burnett |  | Open |  | Newsprint Project in Michigan.
7 | Smurfit Stone |  |  |  | [NAME] |  | Open |  | Newsprint mills. West coast
8 | Port Wentworth,Ga. |  |  |  | [NAME] |  | Open |  | Pulp Mill/Linerboard Machine.
 | Millennium Fibre |  |  |  | Anderson/Pratel |  | Open |  | Pulp Mill/ Energy Island Project.
9 | [NAME] |  |  |  | [NAME] |  | Open |  | [NAME]. [NAME]. Monetization project
10 | Heritage Newsprint |  |  |  | [NAME] |  | Open |  | Recycled greenfield project. Ct. or RI
 |  |  |  |  |  |  |  |  | Hedging, subdebt possibilities.
11 | Sappi |  |  |  | Saverance |  | Open |  | Pulp mill monetization.
 |  |  |  |  |  |  |  |  | Wisconsin location
12 | Waste Management |  |  |  | Moulton/Ajello |  | Open |  | Acquisition of Recycling Assets from Waste Mgmt.
 |  |  |  |  |  |  |  |  | Possible J.V.
12 | Re-Box Packaging |  |  |  | Robinson/Moulton |  | Open |  | [NAME] facility in Wisconsin.
13 | Paperboard Industries |  |  |  | Moulton |  | Open |  | [NAME] in France to monetize
14 | [NAME] |  |  |  | [NAME] |  | Q499 |  | Existing tissue mill in Wisconsin.  [NAME]
 |  |  |  |  |  |  |  |  | investment.
15 | City Forest |  |  |  | Ondarza |  | Open |  | Existing tissue mill in ?????????.  [NAME]
 |  |  |  |  |  |  |  |  | investment.
16 | Bronx Papers |  |  |  | Moulton/Pratel |  | Open |  | Possible financing, hedging.
 |  |  |  |  | [NAME] |  | Open |  | Energy Island
17 | Simpson Paper Mill |  |  |  | Moulton |  | Open |  | Possible purchase of mill
18 | National Gypsum |  |  |  | Cordesman |  | Open |  | Assistance in financing construction of new gypsum
 |  |  |  |  |  |  |  |  | facility
19 | Georgia Pacific |  |  |  | Ondarza/Ajello |  | Open |  | Various paper mill monetizations.
20 | Drypers |  |  |  | Ajello/Ondarza |  | Open
21 | Repap |  |  |  | Ajello/Burnett |  | Open |  | Sell Enron Investment in Debt Instrument.
22 | Bakersfield Newsprint |  |  |  | Ajello  ??? |  | Open
23 | Lenox Polymers |  |  |  | Anderson/Helfrich |  | Open |  | Development project, possible investment, financing
24 | Donohue Inc. |  |  |  | Ajello/Anderson |  | Open |  | Cogen project/Energy Island
25 | Bay State Paper |  |  |  | Anderson/Cummings |  | Open |  | Cogen project.
Spreadsheet: 678797d1590066956-generate-a-zero-as-an-option-small-a4-d4-countif-a4-d4-and-c5-1-change-trend
Sheet: Sheet1

Here is what I have |  |  |  |  |  |  |  | What I need - when the formula in f5 does not find a # higer then d5, it generates an error (#[NAME]), but instead of an error I want it to come back as a 0.
 | Hi | [NAME] | Close | Pivot | Previous Hi / Lo |  |  |  | Hi | [NAME] | Close | Pivot | Previous Hi / Lo
2018-12-07 00:00:00 | 1.66397 | 1.64934 | 1.65813 |  |  |  |  | 2018-12-07 00:00:00 | 1.66397 | 1.64934 | 1.65813
 | 1.66619 | 1.65075 | 1.65217 |  |  |  |  |  | 1.66619 | 1.65075 | 1.65217
 | 1.65839 | 1.64248 | 1.64452 |  |  |  |  |  | 1.65839 | 1.64248 | 1.64452 |  |  | 0
 | 1.6622 | 1.6419 | 1.65726 |  |  |  |  |  | 1.6622 | 1.6419 | 1.65726 |  |  | 0
 | 1.661 | 1.65081 | 1.6553 |  |  |  |  |  | 1.661 | 1.65081 | 1.6553
 | 1.67245 | 1.65352 | 1.66275 |  |  |  |  |  | 1.67245 | 1.65352 | 1.66275
 | 1.66944 | 1.66141 | 1.66741 |  |  |  |  |  | 1.66944 | 1.66141 | 1.66741
 | 1.6681 | 1.65303 | 1.65864 |  |  |  |  |  | 1.6681 | 1.65303 | 1.65864 |  |  | 0
 | 1.68272 | 1.6566 | 1.68061 |  |  |  |  |  | 1.68272 | 1.6566 | 1.68061
 | 1.69656 | 1.67783 | 1.68904 |  |  |  |  |  | 1.69656 | 1.67783 | 1.68904
 | 1.69838 | 1.68606 | 1.69207 |  |  |  |  |  | 1.69838 | 1.68606 | 1.69207
 | 1.70055 | 1.68741 | 1.6976 |  |  |  |  |  | 1.70055 | 1.68741 | 1.6976
 | 1.69544 | 1.68571 | 1.68589 |  |  |  |  |  | 1.69544 | 1.68571 | 1.68589 |  |  | 0
 | 1.7103 | 1.68493 | 1.70463 |  |  |  |  |  | 1.7103 | 1.68493 | 1.70463 |  |  | 0
 | 1.71086 | 1.70418 | 1.70608 |  |  |  |  |  | 1.71086 | 1.70418 | 1.70608
 | 1.70849 | 1.70049 | 1.70626 |  |  |  |  |  | 1.70849 | 1.70049 | 1.70626 |  |  | 0
 | 1.7085 | 1.7005 | 1.7063 |  |  |  |  |  | 1.7085 | 1.7005 | 1.7063
 | 1.71166 | 1.70044 | 1.70421 |  |  |  |  |  | 1.71166 | 1.70044 | 1.70421 |  |  | 0
 | 1.73233 | 1.67092 | 1.70177 |  |  |  |  |  | 1.73233 | 1.67092 | 1.70177 |  |  | 0
 | 1.70719 | 1.68823 | 1.69241 |  |  |  |  |  | 1.70719 | 1.68823 | 1.69241
 | 1.70004 | 1.68798 | 1.69781 |  |  |  |  |  | 1.70004 | 1.68798 | 1.69781 |  |  | 0
 | 1.70377 | 1.69426 | 1.70121 |  |  |  |  |  | 1.70377 | 1.69426 | 1.70121
 | 1.70185 | 1.68838 | 1.7 |  |  |  |  |  | 1.70185 | 1.68838 | 1.7 |  |  | 0
 | 1.70545 | 1.6939 | 1.69554 |  |  |  |  |  | 1.70545 | 1.6939 | 1.69554
Spreadsheet: 489097d1479088196-formula-required-vlookup-temp-hrs-test
Sheet: Sheet2

Personnel Number | Name | Date | Day | DWS | DV | Daily WS text | Va | Text | Grp | Start | End | [NAME] | HCl | DT | Day type text | Personal WS | Description | HCr | Text | Wk. time
123 | [NAME] | 2016-10-01 00:00:00 | FR | 3A06 |  | FT 15:00-23:00 |  |  | 17 | 15:00 | 23:00 | 8 | 1 |  | Work/paid | 3AKX | 15:00-23:00 SAT-SUN | CW | CP Standard (11 Day) CUPW | 0
123 | [NAME] | 2016-10-02 00:00:00 | SA | RDO |  | [NAME] |  |  | 17 |  |  | 0 |  |  | Work/paid | 3AKX | 15:00-23:00 SAT-SUN | CW | CP Standard (11 Day) CUPW | 0
123 | [NAME] | 2016-10-03 00:00:00 | SU | RDO |  | [NAME] |  |  | 17 |  |  | 0 |  |  | Work/paid | 3AKX | 15:00-23:00 SAT-SUN | CW | CP Standard (11 Day) CUPW | 0
123 | [NAME] | 2016-10-04 00:00:00 | MO | 3A06 |  | FT 15:00-23:00 |  |  | 17 | 15:00 | 23:00 | 8 |  |  | Work/paid | 3AKX | 15:00-23:00 SAT-SUN | CW | CP Standard (11 Day) CUPW | 0
123 | [NAME] | 2016-10-05 00:00:00 | TU | 3A06 |  | FT 15:00-23:00 |  |  | 17 | 15:00 | 23:00 | 8 |  |  | Work/paid | 3AKX | 15:00-23:00 SAT-SUN | CW | CP Standard (11 Day) CUPW | 0
123 | [NAME] | 2016-10-06 00:00:00 | WE | 3A06 |  | FT 15:00-23:00 |  |  | 17 | 15:00 | 23:00 | 8 |  |  | Work/paid | 3AKX | 15:00-23:00 SAT-SUN | CW | CP Standard (11 Day) CUPW | 1
Spreadsheet: 838417d1690987732-dynamically-unpivot-without-power-query-ignoring-blank-and-0-dynamically-unpivot-without-power-query-ignore-blank-and-0
Sheet: Sheet1

From \ To | C | D1 | D2 | D3 | E1 | E2 | E3 |  |  |  | Desired Result via formula as [NAME]
A | 1
B |  |  |  |  |  |  |  |  |  |  | From | To | Allocation
C |  | 0.5 | 0.25 | 0.25 |  |  |  |  |  |  | A | C | 1
D1 |  |  |  |  | 1 |  |  |  |  |  | C | D1 | 0.5
D2 |  |  |  |  |  | 1 |  |  |  |  | C | D2 | 0.25
D3 |  |  |  |  |  |  | 1 |  |  |  | C | D3 | 0.25
 |  |  |  |  |  |  |  |  |  |  | D1 | E1 | 1
 |  |  |  |  |  |  |  |  |  |  | D2 | E2 | 1
 |  |  |  |  |  |  |  |  |  |  | D3 | E3 | 1
Current Formula - Need to adjust formula to ignore anything that's blank/0
 | To | Allocation
A | C | 1
A | D1 | 0
A | D2 | 0
A | D3 | 0
A | E1 | 0
A | E2 | 0
A | E3 | 0
B | C | 0
B | D1 | 0
B | D2 | 0
B | D3 | 0
B | E1 | 0
B | E2 | 0
B | E3 | 0
C | C | 0
C | D1 | 0.5
C | D2 | 0.25
C | D3 | 0.25
C | E1 | 0
C | E2 | 0
C | E3 | 0
D1 | C | 0
D1 | D1 | 0
D1 | D2 | 0
D1 | D3 | 0
D1 | E1 | 1
D1 | E2 | 0
D1 | E3 | 0
D2 | C | 0
D2 | D1 | 0
D2 | D2 | 0
D2 | D3 | 0
D2 | E1 | 0
D2 | E2 | 1
D2 | E3 | 0
D3 | C | 0
D3 | D1 | 0
D3 | D2 | 0
D3 | D3 | 0
D3 | E1 | 0
D3 | E2 | 0
D3 | E3 | 1
Spreadsheet: 886235d1736267261-function-to-find-the-right-column-to-pull-data-from-0dte-butterfly-calculator
Sheet: SPX Options Chain

Stock quote and option quote for SPX on 1/7/25 07:15:01
UNDERLYING
LAST | LX | Net Chng | BID | BX | ASK | AX | Size | Volume | Open | High | Low
UNDERLYING EXTRA INFO
Last Size | Yield | PE | Div | [NAME].[NAME] | [NAME].Date | 52High | 52Low | Shares | Beta
 |  |  |  | --
7 JAN 25  (0)  100 ([NAME])
 |  | Delta | Gamma | Theta | Vega | BID | BX | ASK | AX | Exp | Strike | BID | BX | ASK | AX | Delta | Gamma | Theta | Vega
8 JAN 25  (1)  100 ([NAME])
9 JAN 25  (2)  100 ([NAME])
10 JAN 25  (3)  100 ([NAME])
13 JAN 25  (6)  100 ([NAME])
14 JAN 25  (7)  100 ([NAME])
15 JAN 25  (8)  100 ([NAME])
16 JAN 25  (9)  100 ([NAME])
17 JAN 25  (9)  100
17 JAN 25  (10)  100 ([NAME])
21 JAN 25  (14)  100 ([NAME])
22 JAN 25  (15)  100 ([NAME])
23 JAN 25  (16)  100 ([NAME])
24 JAN 25  (17)  100 ([NAME])
27 JAN 25  (20)  100 ([NAME])
28 JAN 25  (21)  100 ([NAME])
29 JAN 25  (22)  100 ([NAME])
30 JAN 25  (23)  100 ([NAME])
31 JAN 25  (24)  100 ([NAME])
3 FEB 25  (27)  100 ([NAME])
4 FEB 25  (28)  100 ([NAME])
5 FEB 25  (29)  100 ([NAME])
6 FEB 25  (30)  100 ([NAME])
7 FEB 25  (31)  100 ([NAME])
10 FEB 25  (34)  100 ([NAME])
11 FEB 25  (35)  100 ([NAME])
12 FEB 25  (36)  100 ([NAME])
14 FEB 25  (38)  100 ([NAME])
21 FEB 25  (44)  100
21 FEB 25  (45)  100 ([NAME])
24 FEB 25  (48)  100 ([NAME])
28 FEB 25  (52)  100 ([NAME])
7 MAR 25  (59)  100 ([NAME])
21 MAR 25  (72)  100
21 MAR 25  (73)  100 ([NAME])
31 MAR 25  (83)  100 ([NAME])
17 APR 25  (99)  100
17 APR 25  (100)  100 ([NAME])
30 APR 25  (113)  100 ([NAME])
16 MAY 25  (128)  100
16 MAY 25  (129)  100 ([NAME])
30 MAY 25  (143)  100 ([NAME])
20 JUN 25  (163)  100
30 JUN 25  (174)  100 ([NAME])
18 JUL 25  (191)  100
15 AUG 25  (219)  100
19 SEP 25  (254)  100
30 SEP 25  (266)  100 ([NAME])
17 OCT 25  (282)  100
21 NOV 25  (317)  100
19 DEC 25  (345)  100
31 DEC 25  (358)  100 ([NAME])
16 JAN 26  (373)  100
20 MAR 26  (436)  100
18 JUN 26  (526)  100
18 DEC 26  (709)  100
17 DEC 27  (1073)  100
15 DEC 28  (1437)  100
21 DEC 29  (1808)  100
17 DEC 27  (1075)  100
15 DEC 28  (1439)  100
21 DEC 29  (1810)  100