tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 816690d1675780813-cut-pattern-formula-from-calculated-matrix-data-cut-pattern
Sheet: Ex

 | query
 | bar length | 12 |  | PCS and rest
 | Position | length | KOM | 0.09999999999999964 | 0.1 | 0 | 1.4 | 8.9 | 8.9000000001 | 3.17 | 4.06 | 0.10000000001 | 4.76 | 9.11
 | 3 | 5.8 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 0 | 5 |  |  |  | Pos 3 | Pos 1 | Pos 9 | Pos 10 | Pos 11 | Pos 7 | Pos 5
 | 2 | 4.5 | 3 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Cut Pattern 2 | Pos 2 | Pos 4 | Pos 8 | Pos 10
 | 4 | 3 | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Cut Pattern 3 | Pos 2 | Pos 4 | Pos 5 | Pos 11
 | 5 | 3.1 | 2 | 0 | 0 | 0 | 1 | 1 |  | 1 | 1 | 1 |  | 1 |  |  | Cut Pattern 4 | Pos 5 | Pos 9 | Pos 7 | Pos 1 | Pos 6 | Pos 8
 | 1 | 0.3 | 1 | 1 | 1 | 0 | 0 | 0 | 5 | 0 | 2 | 0 | 5 | 0 |  |  | Cut Pattern 5 | Pos 3 | Pos 5 | Pos 6 | Pos 11 | Pos 10
 | 6 |  |  | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 0 | 0 | 0 | 0 |  |  | Cut Pattern 6 | Pos 5 | Pos 1 | Pos 11
 | 9 |  |  | 3 | 0 | 0 | 0 | 6 | 5 | 0 | 0 | 0 | 0 | 0 |  |  | Cut Pattern 7 | Pos 1 | Pos 8 | Pos 7
 | 8 |  |  | 0 | 0 | 4 | 0 | 0 | 2 | 0 | 0 | 0 | 6 | 0 |  |  | Cut Pattern 8 | Pos 3 | Pos 5 | Pos 11 | Pos 10
 | 11 |  |  | 0 | 1 | 0 | 1 | 0 | 0 | 7 | 2 | 0 | 0 | 4
 | 7 |  |  | 0 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 4 | 1 | 0
 | 10 |  |  | 5 | 0 | 6 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 2 |  | or
 |  |  |  | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | 2 | 0 | 0 |  |  | Cut Pattern 1 | Pos 3 | Pos 1 | Pos 9 | Pos 10 | Pos 11 | Pos 7 | Pos 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Cut Pattern 2 | Pos 2 | Pos 4 | Pos 8 | Pos 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.4 | Cut Pattern 3 | Pos 2 | Pos 4 | Pos 5 | Pos 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.9 | Cut Pattern 4 | Pos 5 | Pos 9 | Pos 7 | Pos 1 | Pos 6 | Pos 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.17 | Cut Pattern 5 | Pos 3 | Pos 5 | Pos 6 | Pos 11 | Pos 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.06 | Cut Pattern 6 | Pos 5 | Pos 1 | Pos 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.76 | Cut Pattern 7 | Pos 1 | Pos 8 | Pos 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.11 | Cut Pattern 8 | Pos 3 | Pos 5 | Pos 11 | Pos 10
Spreadsheet: 770210d1645893518-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: combo box

Year |  |  |  |  |  | Negative bugs | Positive bugs |  | Negative bugs | Positive bugs
Type |  |  |  |  |  | Citrobacter freundii | Group B Strep |  | Citrobacter freundii |  | Group B Strep
 |  |  |  |  |  | E. coli | MRSA |  | E. coli |  | MRSA
 |  |  |  |  |  | Enterobacter cloacae complex | MSSA |  | Enterobacter cloacae complex |  | MSSA
 |  |  |  |  |  | Klebsiella aerogenes | Staphylococcus aureus |  | Klebsiella aerogenes |  | Staphylococcus aureus
 |  |  |  |  |  | Klebsiella pneumoniae |  |  | Klebsiella pneumoniae |  | 0
 |  |  |  |  |  | Morganella morganii |  |  | Morganella morganii |  | 0
 |  |  |  |  |  | Proteus mirabilis |  |  | Proteus mirabilis |  | 0
Spreadsheet: 48332bf4-9d52-4623-af38-6ea72dec99c6
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Area |  | Yield | Supply |  |  |  |  | Use
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed & |  |  | Ending
September 1 |  |  |  | stocks | Production | Imports | Total |  |  | residual | Exports | Total | stocks
 | Million acres |  | Bu./acre |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2012/131 | 77.198 | 76.164 | 39.82959140801429 | 169.37 | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1689 | 89.96486634648022 | 1319.565775516722 | 3098.530641863203 | 140.557
2013/142 | 76.533 | 75.869 | 43.34883812888005 | 140.557 | 3288.833 | 90 | 3519.39 |  | 1700 | 94.38999999999987 | 1600 | 3394.39 | 125
2014/152 | 81.493 | 80.5 | 45.15527950310559 | 125 | 3635 | 15 | 3775 |  | 1715 | 110 | 1625 | 3450 | 325
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  | Supply |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
 |  |  |  |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2012/13
September-November |  |  |  | 169.37 | 3033.581 | 4.2863493307698 | 3207.23734933077 |  | 622.6353144323552 |  | 618.4410348984147 | 1241.07634933077 | 1966.161
December-February |  |  |  | 1966.161 | --- | 4.7181036423045 | 1970.879103642304 |  | 447.2727627133432 |  | 525.5863409289612 | 972.8591036423045 | 998.02
March-May |  |  |  | 998.02 | --- | 7.8351491690241 | 1005.855149169024 |  | 446.1362887515575 |  | 125.0548604174667 | 571.1911491690241 | 434.664
June-August |  |  |  | 434.664 | --- | 19.2970397211039 | 453.9610397211039 |  | 262.9205004492242 |  | 50.48353927187971 | 313.4040397211039 | 140.557
Total |  |  |  |  | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1778.96486634648 |  | 1319.565775516722 | 3098.530641863203
2013/14
September-November |  |  |  | 140.557 | 3288.833 | 11.8156584914991 | 3441.205658491499 |  | 626.4199921664529 |  | 661.164666325046 | 1287.584658491499 | 2153.621
December-February |  |  |  | 2153.621 | --- | 8.359778436657901 | 2161.980778436658 |  | 445.0152191447472 |  | 724.6405592919108 | 1169.655778436658 | 992.325
Total to date |  |  |  |  | 3288.833 | 20.175436928157 | 3449.565436928157 |  | 1071.4352113112 |  | 1385.805225616957 | 2457.240436928157
1 Estimated. 2 Forecast.  Note: 1 metric ton equals 36.744 bushels and 1 acre equals 2.471 hectares.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2014-06-13 08:15:42.920000
Spreadsheet: 72603d1273286151-change-currency-formatting-based-on-value-of-another-cell-macro-start
Sheet: CALCULATIONS

Subject :
Item | Description |  | Qty | MC - U/Price ([NAME]) | MC - U/Price (A$) | MC - Total Price (JPY) | MC - Total Price (A$) | MAL - U/Price ([NAME]) | MAL - U/Price (A$) | Amount  ([NAME]) | Amount (A$)
1 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | FOB Japan |  |  |  |  | 0 | 0 |  |  | 0 | 0
 | Air Freight & Insurance (Internal Interest inc. in final total) |  |  |  |  |  | 0 |  |  | 0 | 0
 | CIF Total |  |  |  |  | 0 | 0 |  |  | 0 | 0
 | Ocean Freight & Insurance (Internal Interest inc. in final total) |  |  |  |  |  | 0 |  |  | 0 | 0
 | CIF Total |  |  |  |  | 0 | 0 |  |  | 0 | 0
 | Margins |  |  |  |  | Inland |  |  | Internal Interest
 | Profit Margin |  |  |  |  | Customs and Transport |  |  | Rate
 | Freight and Insurance | 0.1 |  |  |  | 5% duty | 0 |  | Air | 0 | 0
 |  |  |  |  |  | 15% MAL admin. Fee | 0 |  | Ocean | 0 | 0
 | Rates
 |  |  |  |  |  | Total | 0
 | Date | 2010-05-08 00:00:00
 | SAP Rate
 | Exchange Rate | -4
 |  |  |  |  |  | Checked by
 | Summary  (CIF Price)
 | Revenue | 0 | 0
 | Cost | 0 | 0 |  |  | Approved by
 | Profit | 0 | 0
Spreadsheet: 136414d1326626498-array-formula-needed-to-choose-details-from-existing-list-and-display-as-a-row-date-20query-1-
Sheet: Sheet1

Sat | 2012-01-07 00:00:00 | 6.45-12.15 |  | Sun | 2012-01-08 00:00:00
Sun | 2012-01-08 00:00:00 | 6.45-11.45 |  |  | 2012-01-15 00:00:00
Fri | 2012-01-13 00:00:00 | 8-12.15 |  |  | 2012-01-22 00:00:00
Sat | 2012-01-14 00:00:00 | 6.45-12.15
Sun | 2012-01-15 00:00:00 | 6.45-11.45
Fri | 2012-01-20 00:00:00 | 8-12.15
Sat | 2012-01-21 00:00:00 | 6.45-12.15
Sun | 2012-01-22 00:00:00 | 6.45-11.45
Fri | 2012-01-27 00:00:00 | 8-12.15
Spreadsheet: darrell_schoolcraft__7751__0302 Lamar NNG Nomination
Sheet: 03- (23-25)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-03-23 00:00:00 | Revised
 |  |  |  | Ending Gas Day: | 2002-03-25 00:00:00
 |  | [NAME] |  |  | 45000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 2000
 | ** |  | 0
 | ** | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | ** |  | 2000
 | ** |  | 2000
Spreadsheet: 871398d1717772983-linking-contents-of-another-worksheet-based-on-pivot-values-example-workbook
Sheet: Summary

 |  | Would like column D to be a formula that checks Row B order number, then autofills a hyperlink to the supporting worksheet
 |  |  | Would like column F to automatically check each [NAME] analysis sheet and pull the text from Cell B2
Row Labels | Sum of Value £ | Order analysis sheet | Order comments
1 | 100 | 1'!A1 | Test - Order 1
2 | 200 | 2'!A1 | Test - Order 2
3 | 300 | 3'!A1 | Test - Order 3
4 | 400 | 4'!A1 | Test - Order 4
5 | 500 | 5'!A1 | Test - Order 5
6 | 600
7 | 700
8 | 800
9 | 900
10 | 1000
Grand Total | 5500
Spreadsheet: 789511d1659125118-return-1st-cell-with-correct-conditions-excel-help
Sheet: Sheet1

Date | Status |  | Begin Date | First Close
2022-06-23 00:00:00 | Open |  | 2022-06-28 00:00:00 | 2022-07-05 00:00:00 | *I need to return the first "Closed" date after the Begin date in Cell D2
2022-06-24 00:00:00 | Open
2022-06-27 00:00:00 | Open
2022-06-28 00:00:00 | Open | *Begin Searching
2022-06-29 00:00:00 | Open
2022-06-30 00:00:00 | Open
2022-07-01 00:00:00 | Open
2022-07-05 00:00:00 | Closed | <----- Result I want
2022-07-06 00:00:00 | Closed
2022-07-07 00:00:00 | Open
2022-07-08 00:00:00 | Open
2022-07-11 00:00:00 | Open
2022-07-12 00:00:00 | Open
2022-07-13 00:00:00 | Open
2022-07-14 00:00:00 | Closed
2022-07-15 00:00:00 | Open
2022-07-18 00:00:00 | Open
2022-07-19 00:00:00 | Open
2022-07-20 00:00:00 | Open
Spreadsheet: 0d62a241-c2f5-464d-ac4d-45b75519e4e9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259473 | 73589 | Lais | [NAME] | BRA |  | 00:19:32 | 00:01:16 | [NAME] | 00:00:57 | 00:28:38 | 1 | 01:29:41
Spreadsheet: 42945d1241559494-cell-formatting-research
Sheet: Sheet1

Projects | Resources | Jan | Feb | [NAME] | June | July | Aug
Requirement by projects |  | Jan | Feb | Mar | Apr | May | June | July
M | X | 1 | 2 | 2 |  |  | 1
A | Y |  | 1 | 3 | 1 | 1 | 4
A | Z | 1 | 2
M | X |  |  | 2 |  | 1 | 4
B | Y | 1 | 2 | 4 |  | 4
H | X | 5
B | Z |  | 3 | 3 | 3 | 1 | 1
M | y | 2
M | Z | 1 |  | 4 |  |  | 4
C | X | 1 | 1 | 1 | 1 | 1
C | Y |  | 1 | 4
D | Z |  | 4 |  |  | 2 | 2
D | X | 2 | 5 |  | 1 | 4
D | Y | 1 | 2 | 6
D | Z | 1 | 1 |  | 2
Requirement |  | Jan | Feb | Mar | Apr | May | June
 | X | 9 | 8 | 5 | 2 | 6 | 5
 | Y | 4 | 6 | 17 | 1 | 5 | 4
 | Z | 3 | 10 | 7 | 5 | 3 | 7
Availability |  | Jan | Feb | Mar | Apr | May | June
 | X | 5 | 5 | 5 | 5 | 5 | 4
 | Y | 5 | 7 | 5 | 5 | 5 | 6
 | Z | 5 | 5 | 5 | 5 | 5 | 3
Surplus/Deficit |  | Jan | Feb | Mar | Apr | May | June
 | X | -4 | -3 | 0 | 3 | -1 | -1
 | Y | 1 | 1 | -12 | 4 | 0 | 2
 | Z | 2 | -5 | -2 | 0 | 2 | -4
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: NEW ZEALAND

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 269976d1381337421-huge-problem-with-the-indirect-function-trying-to-create-dependent-drop-downs-pcard-amounts-removed
Sheet: May

Regina Downtown
P-card [NAME]
Purpose: June | Statement
Description | Retailer | Goods Purchased | Total | GST | Fund | Org | Activity | Acct | Project | [NAME]
Events & Programming | Facebook | General -Facebook | 16.4 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
Member [NAME] | Beer bros | Fashion Week | 135.86 | 5.24 | 520 | 0000 | R210 | 64115 | Y0720 | 00
Meetings, Receptions & food | flip | other stakeholder | 37.18 | 0 | 520 | 0000 | R110 | 64115 | Y0709 | 00
Events & Programming | Facebook | General -Facebook | 4.6 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
Publications | [NAME] | Team Uniform | 1233.76 | 56.08 | 520 | 0000 | R210 | 65213 | Y0722 | 00
Publications | [NAME] | Team Uniform | 181.28 | 8.24 | 520 | 0000 | R210 | 65213 | Y0722 | 00
Ped Count | [NAME] | Shirts | 850.34 | 38.65 | 520 | 0000 | R410 | 65213 | Y0740 | 00
Events & Programming | Sake | Team Lunch | 139.28 | 5.68 | 520 | 0000 | R210 | 64115 | Y0724 | 00
Equip. Rentals & Stationary | Staples | Stationary | 11.17 | 0.51 | 520 | 0000 | R110 | 65230 | Y0706 | 00
Ped Count | Walmart | Water for Pedcount | 71.53 | 38.65 | 520 | 0000 | R410 | 64115 | Y0740 | 00
Member [NAME] | Mail Chimp | General Correspondence | 31.86 | 0 | 520 | 0000 | R210 | 64232 | Y0720 | 00
Publications | Metro | Doors Open Ad buy | 367.5 | 0 | 520 | 0000 | R210 | 65112 | Y0722 | 00
Ped Count | [NAME] | [NAME] bits | 37.24 | 0 | 520 | 0000 | R410 | 64115 | Y0740 | 00
Ped Count | Flip | Team Lunch | 307.31 | 12.73 | 520 | 0000 | R410 | 64115 | Y0740 | 00
Publications | Staples | Doors Open Stationary | 36.65 | 1.67 | 520 | 0000 | R210 | 65112 | Y0722 | 00
Publications | Esso | Doors Open Ice | 12.76 | 0 | 520 | 0000 | R210 | 64115 | Y0722 | 00
Events & Programming | Facebook | General -Facebook | 65.55 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
Events & Programming | Facebook | General -Facebook | 49.82 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
 |  |  |  |  |  |  |  |  |  | 00
TOTAL RECEIPTS
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Total Present Worth

Table 5.2.62.  Total Present Worth for Feasible Alternatives
 | Capital Costs | Replacement Costs Present Worth | O&M Costs Present Worth |  |  | Total Present Worth
 |  |  | Annual | Intermittent | Total
Spreadsheet: 180007d1347455531-rearranging-production-data-according-to-dates-production-rates
Sheet: Sheet1

Date | Product Grade to Produce | Production Start Time | Amt to [NAME] (tons) |  | Date | Production rate (tons)
2012-09-12 00:00:00 | [NAME] | 13:45:00 | 1000 |  | 2012-09-12 00:00:00 | ?
2012-09-15 00:00:00 | YYY | 02:30:00 | 800 |  | 2012-09-13 00:00:00 | ?
2012-09-17 00:00:00 | ZZZ | 20:00:00 | 900 |  | 2012-09-14 00:00:00 | ?
2012-09-20 00:00:00 | AAA | 04:15:00 | 200 |  | 2012-09-15 00:00:00 | ?
2012-09-20 00:00:00 | BBB | 23:50:00 | 550 |  | 2012-09-16 00:00:00 | ?
End production on 21 Sep, 17:00 hrs |  |  |  |  | 2012-09-17 00:00:00 | ?
 |  |  |  |  | 2012-09-18 00:00:00 | ?
e.g. for product XXX, production will take place from 12 Sep 13:45 to 15 Sep 2:29 |  |  |  |  | 2012-09-19 00:00:00 | ?
 |  |  |  |  | 2012-09-20 00:00:00 | ?
 |  |  |  |  | 2012-09-21 00:00:00 | ?
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 15b

 |  | Transactions
Product |  | HY** | IG | Other
Index Tranche* | Asia |  |  | <100
 | Europe |  |  | <100
 | North America | <100 | <100 | <100
Index | Asia |  | <100 | <100
 | Europe |  |  | 3883
 | North America | 1788 | 1581 | 157
TOTAL |  | 1788 | 1581 | 4040
Estimated swap transaction volumes, week ending August 9, by product type and grade (in number of transactions), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 839193d1691745556-how-to-create-a-dynamic-date-dynamic-date-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Unique receipt count
 | Table A |  |  |  |  | Table B
 | Date | Sales | Receipt | Qty |  | Date | Sales | Receipt | Qty |  | Date | Receipt | Product | Unit | Sales |  | Note:
 |  | 4500 |  |  |  | 2023-01-01 00:00:00 | 4490 | 3 | 5 |  | 2023-01-01 00:00:00 | 1 | iPhone | 1 | 980 |  | Product | Remark
 | 2023-01-02 00:00:00 | 1780 |  |  |  | 2023-01-02 00:00:00 | 1775 | 4 | 6 |  | 2023-01-01 00:00:00 | 1 | Apple Watch | 1 | 320 |  | Credit Off | Need to exclude from sale
 | 2023-01-03 00:00:00 | 1335 |  |  |  | 2023-01-03 00:00:00 | 1335 | 1 | 2 |  | 2023-01-01 00:00:00 | 2 | MacBook | 1 | 2200 |  | Free cleaning kits | Need to exclude from sale
 |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | iPad | 1 | 950 |  | Free Bag | Need to exclude from sale
 |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Earpod | 1 | 40 |  | Paper bag | Need to exclude from sale
 |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Free Cleaning kits | 1 | 10
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Nokia | 1 | 150
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Earpod | 1 | 30
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Paper bag | 1 | 0
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 5 | iPhone | 1 | 850
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 6 | iPad | 1 | 750
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 7 | iPone | 1 | 945
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 7 | iPad | 1 | -950
 |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | 7 | Credit Off | 1 | 5
 |  |  |  |  |  |  |  |  |  |  | 2023-01-03 00:00:00 | 9 | Dell Laptop | 1 | 1300
 |  |  |  |  |  |  |  |  |  |  | 2023-01-03 00:00:00 | 9 | Headphone | 1 | 35
 |  |  |  |  |  |  |  |  |  |  | 2023-01-03 00:00:00 | 9 | Free Bag | 1 | 0
Spreadsheet: 164907d1340958041-look-values-with-a-twist-look-up-query-v2
Sheet: Data

Account | Cost Center | Amount | Amount
1006109 |  | 0 | 2461.62
1006109 |  | 0 | 262776.51
1006109 |  | 0 | 103308
2203015 |  | 0 | 648.38
2206001 |  | 0 | 35226.13
2206001 | SS | 0 | 10179.58
5000001 | 1405801100 | 8861.25 | 0
5000001 | 1505800650 | 37980.95 | 0
5000001 | 1705800001 | 58436.78 | 0
5000001 | 1705800002 | 130282.09 | 0
5000001 | 1705800012 | 10081.42 | 0
5000001 | 1705800022 | 26357 | 0
5000001 | 1805800005 | 6988.5 | 0
5000001 | 1805800018 | 23385.01 | 0
5000001 | 1805800035 | 6524.8 | 0
5000001 | 1805807100 | 11818.58 | 0
5000001 | 1905800002 | 17259.92 | 0
5000001 | 2305800001 | 19736.79 | 0
5010015 | 1405801100 | 3545 | 0
5010015 | 1505800650 | 6779 | 0
5010015 | 1805800018 | 3803 | 0
5010015 | 1805807100 | 5352 | 0
5010015 | 2305800001 | 2182 | 0
5030008 | 1405801100 | 1205.17 | 0
5030008 | 1505800650 | 4017.03 | 0
5030008 | 1705800001 | 5070.39 | 0
5030008 | 1705800002 | 12388.41 | 0
5030008 | 1705800012 | 839.74 | 0
5030008 | 1705800022 | 2372.13 | 0
5030008 | 1805800005 | 936.4 | 0
5030008 | 1805800018 | 2697.59 | 0
5030008 | 1805800035 | 628.43 | 0
5030008 | 1805807100 | 1663.54 | 0
5030008 | 1905800002 | 1482.26 | 0
5030008 | 2305800001 | 1925.04 | 0
Spreadsheet: 270045d1381351154-conditional-formatting-icon-sample3
Sheet: Sheet1

by # | by %
100 | 0.51
86 | 0
57 | 0.84
58 | 1.23
88 | 0
85 | 0.11
14 | 0
101 | 0.77
123 | 1.32
 | 0.89
 | 1
 | 0.99
Spreadsheet: 9441220d-d2df-4caa-a5b1-bd6830fb3dbf
Sheet: Sheet1

S | 821500000 | 10103 | 2011 | [NAME] | <[NAME]>
D | 1.2.01.01 | 11500000 | 1120947 | 0
D | 1.4.20.13 | 826341000 | 283194 | 0
D | 1.4.20.13 | 820923000 | 167964 | 0
D | 1.4.20.13 | 62900000 | 183293 | 0
D | 1.4.24.02 | 21805000 | 12164 | 0
D | 1.4.24.02 | 25744000 | 362191 | 0
D | 1.4.24.02 | 28450000 | 262812 | 0
D | 1.4.24.02 | 29566000 | 2684 | 0
D | 1.4.24.02 | 41200000 | 155732 | 0
D | 1.4.24.02 | 54617000 | 27814012 | 0
D | 1.4.24.02 | 62900000 | 500000 | 0
D | 1.4.24.02 | 115050000 | 350476 | 0
D | 1.4.24.02 | 122613000 | 356814 | 0
D | 1.4.24.02 | 123273000 | 315000 | 0
D | 1.4.24.02 | 163150000 | 43610 | 0
D | 1.4.24.02 | 210070400 | 314347 | 0
D | 1.4.24.02 | 210170001 | 72776 | 0
D | 1.4.24.02 | 210173001 | 107221 | 0
D | 1.4.24.02 | 210195001 | 100246 | 0
D | 1.4.24.02 | 210870508 | 60645 | 0
D | 1.4.24.02 | 211150711 | 39224 | 0
D | 1.4.24.02 | 211320013 | 29250 | 0
D | 1.4.24.02 | 211350313 | 66312 | 0
D | 1.4.24.02 | 211525815 | 182500 | 0
D | 1.4.24.02 | 211617616 | 67000 | 0
D | 1.4.24.02 | 215150251 | 62045 | 0
D | 1.4.24.02 | 216223162 | 310473 | 0
D | 1.4.24.02 | 216886568 | 52791 | 0
D | 1.4.24.02 | 217386573 | 43791 | 0
D | 1.4.24.02 | 219413894 | 96078 | 0
D | 1.4.24.02 | 220120001 | 534 | 0
D | 1.4.24.02 | 220208999 | 950000 | 0
D | 1.4.24.02 | 826668000 | 100000 | 0
D | 1.4.24.02 | 827294000 | 177195 | 0
D | 1.4.24.02 | 827991000 | 39004 | 0
D | 1.4.24.02 | 923272071 | 2568209 | 0
D | 1.4.70.46 | 11500000 | 8788750 | 0
D | 1.4.70.90 | 96400000 | 400000 | 0
D | 2.4.40.23 | 96400000 | 237387 | 0
D | 2.4.50.02 | 23500000 | 8243401 | 0
D | 4.7.05.08 | 11500000 | 0 | 19539759
D | 4.7.05.10 | 11500000 | 0 | 485237171
D | 4.8.08.19 | 910300000 | 0 | 24902969
D | 5.1.04.01 | 23900000 | 0 | 75203
D | 5.1.04.02 | 26800000 | 0 | 50151
D | 5.1.11.17 | 38750000 | 0 | 2639
D | 5.1.11.17 | 234111001 | 0 | 5332
D | 5.1.11.18 | 250105001 | 0 | 11260
D | 5.1.11.23 | 923269422 | 0 | 30000
D | 5.5.07.05 | 161525000 | 0 | 27405
D | 5.7.20.80 | 11500000 | 0 | 11162123
Spreadsheet: 173743d1344706878-combining-sumproduct-with-checked-checkboxes-for-my-friend
Sheet: Sheet1

2012-08-01 00:00:00 |  | True
2012-08-02 00:00:00 |  | True
2012-08-03 00:00:00 |  | True
2012-08-04 00:00:00 |  | True
2012-08-05 00:00:00 |  | False
2012-08-06 00:00:00 |  | True
2012-08-07 00:00:00 |  | False |  |  |  |  |  | =sumproduct( --(d9:d25>datevalue("3/1/08")), --(d9:d25<datevalue("6/30/08")) )
2012-08-08 00:00:00 |  | False
2012-08-09 00:00:00 |  | True
2012-08-10 00:00:00 |  | True
2012-08-11 00:00:00 |  | False
2012-08-12 00:00:00 |  | False
2012-08-13 00:00:00 |  | True
2012-08-14 00:00:00 |  | True
2012-08-07 00:00:00 |  | True
2012-08-16 00:00:00 |  | True
2012-08-17 00:00:00 |  | True
2012-08-18 00:00:00 |  | False
2012-08-19 00:00:00 |  | False
2012-08-20 00:00:00 |  | True
2012-08-21 00:00:00 |  | True
2012-08-22 00:00:00 |  | False
2012-08-23 00:00:00 |  | True
2012-08-24 00:00:00 |  | True
2012-08-25 00:00:00 |  | False
2012-08-26 00:00:00 |  | True
2012-08-27 00:00:00 |  | False
2012-08-28 00:00:00 |  | False
2012-08-29 00:00:00 |  | False
2012-08-30 00:00:00 |  | False
2012-08-31 00:00:00 |  | True