tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 169586d1342969424-how-to-apply-countif-formula-when-data-are-on-different-sheets-book1
Sheet: January

 |  |  |  | January
 |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
S.no | Employee Name | SID | Process | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
1 |  |  |  | ML | ML | ML
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 73784b80-f8fd-4005-aeea-4c0f38533349
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42964326 | 2014-08-31 21:30:46 | ALLIES | 1 | 7 | 5 | 1628520 | player1628520 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42964626 | 2014-08-31 21:45:05 | AXIS | 1 | 7 | 4 | 1628520 | player1628520 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
Spreadsheet: f1087f59-e0e9-46f5-aee1-686f46ba0f2a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FALCO | Test | FALCO | Alcohol, [NAME] | Alcohol, Methyl (Methanol) | Gas Chromatography-Flame Ionization Detection (GC-FID) | Gray-Top Tube (Potassium Oxalate/Sodium Fluoride): GryPOSF |  |  | 1 | mL | Draw blood in a grey top (NaF/oxalate) tube(s). Send 1 mL of whole blood refrigerate.  Note:  [NAME] should be filled to prevent loss of volatile                compound into headspace. | 0.2 mL Note:  Submission of the | Specimens other than	Whole blood Anticoagulants other than	Sodium fluoride/potassium oxalate Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | No reference range provided.  [NAME] (methyl alcohol) concentrations >3 mg/dL are  potentially toxic.                     Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 1 day | 2-4 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc
FALCO | [NAME] | WBNAFL | [NAME] NaFl-KOx |  |  |  | Refrigerated
FALCO | Result | Z1129 | Alcohol, Methyl (Methanol) | Alcohol, Methyl (Methanol) | Alphanumeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 692348d1598287346-powerquery-or-formulas-2020-08-24-oeldere-kcroft9-692347d1598285959-powerquery-or-formulas-test-data-tables
Sheet: Sheet1

Current Data set
Account Name | Product Code | Product Description | Quantity | Order Ship Date | Source | Month |  | Delta
Autoglass | AI10170 | Product 1 | 6 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10180 | Product 3 | 1 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10152 | Product 4 | 1 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10116 | Product 2 | 6 | 2020-08-10 00:00:00 | Forecast
Autoglass | AI10180 | Product 3 | 3 | 2020-08-18 00:00:00 | Order/Invoiced
Autoglass | AI10152 | Product 4 | 4 | 2020-08-18 00:00:00 | Order/Invoiced
Autoglass | AI10170 | Product 1 | 1 | 2020-08-18 00:00:00 | Order/Invoiced
Autoglass | AI10116 | Product 2 | 2 | 2020-08-18 00:00:00 | Order/Invoiced
What I think I need to do in order to achieve the delta column
Solution I Require
Account Name | Product Code | Product Description | Forecast | Order/Invoiced | Month | Delta
Autoglass | AI10170 | Product 1 | 6 | 1 | Aug-20
Autoglass | AI10180 | Product 3 | 1 | 2 | Aug-20
Autoglass | AI10152 | Product 4 | 1 | 3 | Aug-20
Autoglass | AI10116 | Product 2 | 6 | 4 | Aug-20
Som van Quantity | Kolomlabels
Rijlabels | Forecast | Order/Invoiced | Eindtotaal
aug-yy | 14 | 10 | 24
Autoglass | 14 | 10 | 24
Product 1 | 6 | 1 | 7
Product 2 | 6 | 2 | 8
Product 3 | 1 | 3 | 4
Product 4 | 1 | 4 | 5
Eindtotaal | 14 | 10 | 24
Spreadsheet: 854519d1704363519-trying-to-use-unique-function-to-create-tracker-trial-sheet
Sheet: Pivot

ENTITY | (All)
Row Labels | Count of Session 1 | Count of Session 3 | Count of Session 2 | Count of NAME
Finance | 5 | 5 | 5 | 5
Front Office | 15 | 5 | 15 | 15
Nurses | 136 | 140 | 136 | 140
Physician | 27 |  |  | 27
Grand Total | 183 | 150 | 156 | 187
Spreadsheet: 86125d1286154690-mailto-command-in-excel-example
Sheet: Sheet1

 |  | [NAME] | Subject | HTML
 | Item #1 | [EMAIL] | Query Item #1 | mailto:[EMAIL]?subject=Query Item #1
 | Item #2 | [EMAIL] | Query Item #2 | mailto:[EMAIL]?subject=Query Item #2
 | Item #3 | [EMAIL] | Query Item #3 | mailto:[EMAIL]?subject=Query Item #3
 | Item #4 | [EMAIL] | Query Item #4 | mailto:[EMAIL]?subject=Query Item #4 |  |  |  |  |  | SAMPLE BODY CODE
 | Item #5 | [EMAIL] | Query Item #5 | mailto:[EMAIL]?subject=Query Item #5 |  |  |  |  |  | mailto:[NAME],dan?cc=mike&bcc=sue&subject=test&body=message+here
 | GOAL:
 | Automatically create an email message using Column C & D for email address and subject
 | But also generate a generic text in the email body but it will need to include 3 lines each which has to be separated by a space in between - see screenshot below:
 |  |  |  |  |  |  |  | PROBLEM:
 |  |  |  |  |  |  |  | It is easy to include a body text using the "Sample Body Code" above, However it does not allow the text input
 |  |  |  |  |  |  |  | as 3 separate short lines as in the screenshot on the left.
 |  |  |  |  |  |  |  | Is it possible to generate a custom body like the screenshot?
Spreadsheet: 813816d1674004612-put-sequence-number-with-letter-example_sequence
Sheet: Sheet1

Date | Year | Log no. |  |  | Year | Letter
2022-01-01 00:00:00 |  | A1 |  |  | 2022 | A
2022-02-01 00:00:00 |  | A2 |  |  | 2023 | B
2022-02-02 00:00:00 |  | A3 |  |  | 2024 | C
2022-02-02 00:00:00 |  | A4
2023-01-01 00:00:00 |  | B1
2023-02-01 00:00:00 |  | B2
2023-02-03 00:00:00 |  | B3
2024-01-01 00:00:00 |  | C1
Spreadsheet: 773411d1647861500-countif-based-on-two-conditions-over-non-continuous-cells-test_new-1-
Sheet: Sheet1

Count | A | B | C | A | B | C | A | B | C
3 | 1 |  |  | 1 |  |  | 1
2 | 1 |  |  | 1 |  |  | 1 | z
3 | 1 |  |  | 1 | y |  | 1 | y
0 | 0 |  |  | 0 |  |  | 0
1 | 1 | z |  | 1 | z |  | 1
COUNTIF | Column: A > 0 AND column B is either blank OR equal to 'y'
 | The green cells are the ones COUNTED in each row.
Spreadsheet: 215152d1361285799-return-a-variable-based-on-a-selection-between-dates-and-times-in-a-range-help-request-file
Sheet: FTE Activation

Activation Date | Activation Time | Deactivation Date | Deactivation  Time | Unit Assignment | FTE 1 | FTE 2
2013-02-19 00:00:00 | 21:00:00 | 2013-02-20 00:00:00 | 00:15:00 | 1 | [NAME] | [NAME]
2013-02-20 00:00:00 | 00:16:00 | 2013-02-20 00:00:00 | 08:00:00 | 1 | [NAME] | [NAME]
2013-02-20 00:00:00 | 08:01:00 | February 20,2013 | 16:30:00 | 1 | [NAME] | [NAME] |  | Range = A2:G10  =  FTE
2013-02-20 00:00:00 | 09:00:00 | February 20,2013 | 17:00:00 | 2 | [NAME] | [NAME]
 |  |  |  | 3
 |  |  |  | 4
Spreadsheet: 453382d1459288632-if-function-with-multiple-options-theatre-tech-charge-sheet
Sheet: Totals

Event
Date
Permit
Pricing Tier |  | Percentage
Commercial |  | 0
Discount Plan |  | Discount |  |  |  |  |  |  |  |  |  |  |  | Not Discounted |  | 0
Not Discounted |  | 0 |  |  |  |  |  |  |  |  |  |  |  | Resident Non Profit |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Sponsored |  | 1
Description of Fees and Charges |  |  |  |  |  |  |  |  |  |  |  |  |  | Resident Nonprofit |  | 0
Base Fees 2010-2011 and rounding over 8. |  | Qty. | Rate | Fees |  | Equip Rep. |  |  |  |  |  |  |  | Nonresident Nonprofit |  | 0.25
Base Rate Per Hour (Minimum 6 hours) |  |  |  |  |  |  |  |  |  |  |  |  |  | Commercial |  | 0.5
Base Rate Over 8 Hrs.
Performance Fee
Dark Day Charge
Between 12am and 8am Adder
Non Refundable Booking Deposit |  | 0 | 400
Staffing |  | Qty. | Rate | Fees
Technician Per Hour (Minimum 4 hours)
Technician Over Time Hours
Unscheduled Tech. Assist/Training  (Minimum 4 hours)
[NAME] (Per Hour)
Extended Custodial Service (Per Hour)
Specialized Equipment |  | Qty. | Rate | Fees |  | Equip Rep.
Bubbles |  |  | 16
Fog- Chemical |  |  | 21
Fog- Dry Ice |  |  | 21
Piano |  |  | 25
Snow |  |  | 21
Extra Spotlight |  |  | 51
Stage Deck |  |  | 16
Wireless Microphone Channel |  |  | 14
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Rooms |  | Qty. | Rate | Fees
[NAME]
Comstock Room
Gym
Sierra Room
Tahoe Room
Non Discountable Charges |  | Qty. | Rate | Fees
LED Reader Board Ad Slot (minimum of 2 per week) |  | 0 | 20
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0 |  |  | Subtotal Equipment Replacement
 |  | 0 | 0
 |  |  | Total Charges
 | Discount Program |  |  |  |  | Discount
 |  |  |  | Total [NAME] |  | Equipment Replacement
Statistics
Total Attendance performance and rehearsal
Performance only attendance
Estimated Facility Cost per ticket
Facility Cost per available seat
V1      2016
Spreadsheet: 525560d1498771635-extract-duplicates-from-index-match-but-the-criteria-is-three-columns-copy-of-duplicate-katie-
Sheet: Sheet1

 |  |  |  | B | True
Cust | Line | In Work
7 | A | False
6 | B | True
5 | C | False
4 | B | True
3 | B | False
2 | F | True
1 | B | True
 |  | Sample formula to get duplicates that doesn't work here:
Spreadsheet: c8eebb67-56b6-4c96-9d27-1903ec8a166a
Sheet: Sheet1

Breastfeeding by Year of Birth, Maine, 2000-2007 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Year of  Birth | Ever [NAME] |  | Breastfeeding at 6 Months*
 | % | 95% Margin of Error | % | 95% Margin of Error
2000 | 65.6 | ±14.1 | 43.6 | ±14.2
2001 | 73.9 | ±5.4 | 40.8 | ±5.7
2002 | 67.8 | ±6.1 | 35.9 | ±5.9
2003 | 77.1 | ±5.4 | 45.3 | ±6.2
2004 | 75.4 | ±5.6 | 46.1 | ±6.2
2005 | 75.5 | ±5.6 | 43.3 | ±6.1
2006 | 74.9 | ±5.4 | 42.8 | ±5.6
2007† | 75.2 | ±6.3 | 48.2 | ±7.0
US 2007† | 75 | ±1.2 | 43 | ±1.3
Data Source:  Centers for Disease Control and Prevention, National Immunization Survey, Any Breastfeeding Rates by State and Local Areas Tables ([NAME]; accessed 3/15/2012).
* Breastfeeding at six months includes breastfeeding with or without complementary liquids or solids
† Provisional data
All percentagess are weighted to be more representative of the population of Maine and to adjust for non-response.
Note:  Breastfeeding data are not available by demographic group.
Spreadsheet: kate_symes__18630__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-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 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
 | 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: b452b58f-c775-4fba-9f10-a95bd9c81686
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FVEGF | Test | FVEGF | Vascular Endothelial Growth Factor (VEGF), ELISA | VEGF | Enzyme Immunoassay (ELISA) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Draw blood in lavender-top (EDTA) tube(s). Separate and send 1.0 mL EDTA plasma frozen.   NOTE: Cytokine levels may demonstrate diurnal variation. Recommend cytokine levels be determined at the same time of day for improved longitudinal comparison. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum | VEGF:  31 - 86 pg/mL   This test was performed using a kit that has not been approved or cleared by the FDA. The analytical performance characteristics of this test have been determined by Quest Diagnostics Nichols Institute. This test should not be used for diagnosis without confirmation by other medically established means.   Test Performed by: Quest Diagnostics Nichols Institute                               33608 [NAME]                               San Juan Capistrano, CA 92690-6130 | Thursday [NAME] | 3 days | 5 - 11 days | 1 | 83520 |  |  |  |  | Quest Diagnostics/Nichols Institute
FVEGF | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 365 days
FVEGF | Result | Z1575 | VEGF | VEGF | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 734370d1622126206-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: vlist

project | Vertrek | Aankomst | begeleider | tijd | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3 |  | Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K | wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
Spreadsheet: 165895d1341388487-how-to-empty-the-lookup-output-cells-when-the-primary-cells-are-emptied-development_swing-ticket-20120703_beta
Sheet: SwingTicketData

PrintshopID | DateInSystem | CustOrgID | CustPONumber | POCtrlNo | ShippingMethodCode | VendorRefCode | Courier | CourierAcctNo | VendorRef | ShipToOrgName | ShipToContactName | ShipToAddress1 | ShipToAddress2 | ShipToAddress3 | ShipToCity | ShiptoState | ShiptoZip | ShipToCountryCode | ShipToCountryName | ShipToPhone | [NAME] | ShipToEmail | VendorRef | DetailCtrlNo | SBOrigCode | CustItemCode | Quantity | UOM | OrderWeight | ItemCtrlID | PrimarySize | SecondarySize | PantoneCode | MSRP | UPC | InforLine1 | Color | Story | StyleNumber | XPartSets
Z56 | 2012-06-01 00:00:00 |  | 1063710 |  | REGULAR | 05254 |  |  | 1063710 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000000 | IS | ICELAND | 0 | 0 | 0 |  |  |  | ST/L2101OT | 20 |  |  |  | 6 | SHORT FITTING | 134C | 99.99 | 86535763 | [NAME] | BLUE MIX | Story Desc Test | T32/5089
Z56 | 2012-06-01 00:00:00 |  | 1063710 |  | REGULAR | 05254 |  |  | 1063710 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000000 | IS | ICELAND | 0 | 0 | 0 |  |  |  | ST/L2101OT | 12 |  |  |  | 30 | SHORT/MEDIUM | 702C |  | 77987689 | [NAME] | BLUE MIX |  | T32/5089 | 2 PART SET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: print size X - Y onto left and right size block if there is "-", print "-" across the two upper size blocks
remark: Z56 refers to Brilliant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: texts print to next line after "/" within same size block |  |  |  | remark: Concatenate "Dept" + "/" + "SupplierCode" + "/" + "Stroke"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: secondary size is printed at lower part size block. when there is "-", print size in cm on the left size block, print size in inch on the right size block |  |  |  |  |  |  | remark: concatenate "Dept" + "Stroke"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: When there is "/", use two pantone colors on 4 size blocks, the former for the upper left, the later one for upper right size block.
Spreadsheet: 855469d1705021120-create-new-table-based-on-values-contained-within-a-source-table-5000326-qty-10-sample-2-
Sheet: Sheet1

INPUT |  |  |  |  | OUTPUT |  |  |  |  | FORMULA
Material | Batch # | Quantity | Expiration Date |  | Material | Batch # | Quantity | Expiration Date
Material A | [NAME] | 3 | 2025-06-20 00:00:00 |  | Material A | [NAME] | 1 | 2025-06-20 00:00:00
Material B | [NAME] | 5 | 2024-03-23 00:00:00 |  | Material A | [NAME] | 1 | 2025-06-20 00:00:00
Material C | F104848 | 2 | 2024-03-23 00:00:00 |  | Material A | [NAME] | 1 | 2025-06-20 00:00:00
 |  |  |  |  | Material B | [NAME] | 1 | 2024-03-23 00:00:00
 |  |  |  |  | Material B | [NAME] | 1 | 2024-03-23 00:00:00
 |  |  |  |  | Material B | [NAME] | 1 | 2024-03-23 00:00:00
 |  |  |  |  | Material B | [NAME] | 1 | 2024-03-23 00:00:00
 |  |  |  |  | Material B | [NAME] | 1 | 2024-03-23 00:00:00
 |  |  |  |  | Material C | F104848 | 1 | 2024-03-23 00:00:00
 |  |  |  |  | Material C | F104848 | 1 | 2024-03-23 00:00:00
Spreadsheet: kate_symes__18491__Palo
Sheet: DJ Palo Verde 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-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800