tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__6635__Texas Nat_Gas Ops 0200 O&M Report
Sheet: 2940

2940 |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSOCHC | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALYSTHC | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
 |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Analysts and Associates
TOT_EMP_EXP | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Technology
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: 727274d1617813446-remove-filterxml-from-formula-roster-vs-schedule-example
Sheet: Classes

Day | Monday | Monday | Monday | Monday | Tuesday | Tuesday | Tuesday | Tuesday | Wednesday | Wednesday | Wednesday | Wednesday | Wednesday | Thursday | Thursday | Thursday | Thursday | Thursday | Friday | Friday
System | System 1 | System A | System 2 | System 3 | System 4 | System B | System 5 | System 6 | System 7 | System 8 | System C | System D | System 9 | System E | System F | System 10 | System G | System G | System H | System 11
 | OVERFLOW
 | Monday | Tuesday | Wednesday | Thursday | Friday
 |  |  |  |  |  |  | In the System G (R column) above I can get it so the formula looks at the System column in the Names tab but when I change the Array to look at System and System 2 like the formula below (and in the S column). I loose students in the list.  =IFERROR(INDEX(Names!A:A,AGGREGATE(15,6,ROW(Roster[Student Name])/(Roster[[System]:[System 2]]={"System 8","System 9","System 10"})
 | Student 3 | Student 6 | Student 4 | Student 3 | Student 3
 | Student 4 | Student 7 | Student 6 | Student 4 | Student 4
 | Student 7 | Student 8 | Student 8 | Student 6 | Student 6
 | Student 9 | Student 9 | Student 9 | Student 7 | Student 7
 | Student 10 | Student 10 | Student 11 | Student 8 | Student 8
 | Student 12 | Student 11 | Student 12 | Student 9 | Student 9
 | Student 13 | Student 12 | Student 14 | Student 11 | Student 10
 | Student 14 | Student 13 | Student 15 | Student 14 | Student 11
 | Student 15 | Student 15 | Student 18 | Student 15 | Student 12
 | Student 16 | Student 16 | Student 19 | Student 18 | Student 13
 | Student 17 | Student 17 | [NAME] | Student 19 | Student 14
 | Student 18 | Student 18 |  | [NAME] | Student 15
 | Student 19 | Student 19 |  |  | Student 16
 | [NAME] | [NAME] |  |  | Student 17
 |  |  |  |  | Student 18
 |  |  |  |  | Student 19
 |  |  |  |  | [NAME]
Spreadsheet: 456462d1460882039-calculations-using-a-matrix-correlations-use-tables_2
Sheet: Input Flow

Commodities/Industries | 111CA | 113FF | 211 | 212 | 213 | 22 | 23 | 321 | 327 | 331 | 332 | 333 | 334 | 335 | 3361MV | 3364OT | 337 | 339 | 311FT | 313TT | 315AL | 322 | 323 | 324 | 325 | 326 | 42 | 441 | 445 | 452 | 4A0 | 481 | 482 | 483 | 484 | 485 | 486 | 487OS | 493 | 511 | 512 | 513 | 514 | 521CI | 523 | 524 | 525 | HS | ORE | 532RL | 5411 | 5415 | 5412OP | 55 | 561 | 562 | 61 | 621 | 622 | 623 | 624 | 711AS | 713 | 721 | 722 | 81 | GFGD | GFGN | GFE | GSLG | GSLE
111CA
113FF
211
212
213
22
23
321
327
331
332
333
334
335
3361MV
3364OT
337
339
311FT
313TT
315AL
322
323
324
325
326
42
441
445
452
4A0
481
482
483
484
485
486
487OS
493
511
512
513
514
521CI
523
524
525
HS
ORE
532RL
5411
5415
5412OP
55
561
562
61
621
622
623
624
711AS
713
721
722
81
GFGD
GFGN
GFE
GSLG
GSLE
Used
Other
V001
V002
V003
Spreadsheet: 96928d1296164312-excel-2007-getting-only-selcted-rows-to-transfer-to-a-new-sheet-for-printing-sample-sheet
Sheet: jan

Last Name | First Name | MI | Address | City | State | Zip | Phone | FAX | E-Mail | Salary | Insurance | 401K
Mickeley | [NAME] | M | 503 [NAME] Dr. | Auburndale | FL. | 33823 | 8637984545 | 8636825214 | [EMAIL] | 25500 | No | Yes
[NAME] | George | J | 206 Lake St. | Auburndale | FL. | 33823 | 8637956565 | 8636829874 |  | 65500 | Yes | Yes
Samson | [NAME] | J | 405 Liberty St. | Auburndale | FL. | 33823 | 8637998653 | 8636665452 | [EMAIL] | 60000 | Yes | Yes
Gremsley | Lovey | C | 225 Edgewood St. | Auburndale | FL. | 33823 | 8636879630 | 8636593407.1694 | [EMAIL] | 65500 | No | No
[NAME] | [NAME] | M | 1631 Monterey Ave. | Auburndale | FL. | 33823 | 8636889512 | 8636588353.47939 | [EMAIL] | 58500 | No | Yes
[NAME] | [NAME] | B | 616 Alamo Dr. | Auburndale | FL. | 33823 | 8637984455 | 8636583299.78938 |  | 55600 | Yes | Yes
Washington | [NAME] | W | 1260 Pipkin Ave. | Auburndale | FL. | 33823 | 8637998855 | 8636542870.26934 | [EMAIL] | 59600 | Yes | Yes
Heffner | Ursula | F | 123 Reynolds Rd. | Auburndale | FL. | 33823 | 7996209462.96916 | 8636305346.83908 |  | 32800 | Yes | Yes
Fletcher | Nona | M | 6311 Sandpiper Rd. | Auburndale | FL. | 33823 | 7907419674.63275 | 8636280078.38905 |  | 49666.6666666667 | Yes | No
Tallgates | [NAME] | A | 932 Edith Ave. | Auburndale | FL. | 33823 | 7889661716.96546 | 8636275024.69904 |  | 53316.6666666667 | Yes | No
Spreadsheet: 870043d1716550748-formula-with-multiple-condition-categories-dubx-double-lookup-aligw
Sheet: Sheet1

Type | Weight | Result
A | 0 | 1
A | 10000 | 2
A | 20000 | 3
C | 0 | 5
C | 10000 | 6
C | 15000 | 7
C | 40000 | 8
A | 100
C | 23456 | 7
Spreadsheet: 702702d1604493139-google-sheets-how-to-embed-a-condition-with-if-clause-in-given-formula-live-tracking-unique
Sheet: Re-order columns

 |  |  |  |  |  |  |  | BALANCE
Spreadsheet: 10c86c67-0cad-4510-ac54-72a30fbfbb61
Sheet: Sheet1

[Grantee Name] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | CPMP Version 2.0 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Summary of Specific Annual Objectives
Specific Obj. # |  | Outcome/Objective | Sources of Funds | Performance Indicators | Year | Expected Number | Actual Number | Percent Completed
 |  | Specific Annual Objectives |  |  |  |  |  |  | Reserved
A |  | B
C |  | E | G | P | 2005 | Q | R | S
D |  |  |  |  | 2006 | T | U | V
 |  |  | H |  | 2007 | W | X | Y
 |  |  |  |  | 2008 | Z | AA | AB
 |  |  | I |  | 2009 | AC | AD | AE
 |  |  |  | MULTI-YEAR GOAL |  | AF | AG | AH | AI
 |  |  | J | AK | 2005 | AL | AM | AN | AJ
 |  |  |  |  | 2006 | AO | AP | AQ
 |  |  | K |  | 2007 | AR | AS | AT
 |  | F |  |  | 2008 | AU | AV | AW
 |  |  | L |  | 2009 | AX | AY | AZ
 |  |  |  | MULTI-YEAR GOAL |  | BA | BB | BC
 |  |  | M | BH | 2005 | BI | BJ | BK | BD
 |  |  |  |  | 2006 | BL | BM | BN | BE
 |  |  | N |  | 2007 | BO | BP | BQ | BF
 |  |  |  |  | 2008 | BR | BS | BT | BG
 |  |  | O |  | 2009 | BU | BW | BX | BV
 |  |  |  | MULTI-YEAR GOAL |  | BY | BZ | CA | CB
 |  |  |  |  |  |  |  |  | CC
 |  |  |  |  |  |  |  |  | CD
Spreadsheet: 725729d1616820868-auto-populate-values-from-raw-data-using-multiple-criteria-sheetscreenshot
Sheet: Sheet1

Date | Symbol | Type | Sector | MANUAL | CLOSE | H1 | H2 | H3 | H4 | H5 | DAY
2021-02-17 00:00:00 | TEMP | BEST | FMCG
 | 2021-02-17 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-19 00:00:00 | 2021-02-22 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-24 00:00:00
Symbol | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH
TEMP | 100 | 200 | 101 | 104 | 95 | 99 | 102 | 109 | 101 | 106 | 98 | 102
 |  |  |  |  | 100 | 104 | 99 | 109 | 106 | 102 | 3
The region highlighted in yellow is the place where I need formulas that will auto-populate data from the raw data given in row 5:7
Let me explain:
F2 = In this cell, I need the close of date mentioned in cell A2 for the symbol "Temp" (B2)
Subsequent columns from G2:K2 = Here I need the high value of next 5 available dates in the raw data from the date mentioned in cell A2 for the symbol "Temp" (B2). Keep cell blank if enough data is not available. Eg. if the date in A2 is 18-Feb, then only 4 future dates are available in the raw data, in such a case, K2 will be blank.
L2 = In this cell I need to put after how many days, the value reached greater than or equal to 5% compared to value in cell F2. In this example, on the third day the value jumped to 9% and hence the number 3. Show zero if the value does not cross 5%
Spreadsheet: 772254d1647114638-to-calculate-fuel-sur-charge-for-certain-customers-test-load-sheet-etaf
Sheet: Sheet2

Date | MateriUS loaded at | Customer | Destination | Ticket # | [NAME] | Base Rate | Total | FSC | FSC-Calc
2022-03-04 00:00:00 | COUCH | RMUSA | ANYWHERE,US | 7738555 | 28.26 | 11.6 | 327.816
2022-03-05 00:00:00 | VMC | RMUSAWF | ANYWHERE,US | 7738556 | 28.09 | 9 | 252.81
2022-03-06 00:00:00 | COUCH | RMUSA | ANYWHERE,US | 7738557 | 28.16 | 11.6 | 326.656
2022-03-07 00:00:00 | DUNN | ACI | ANYWHERE,US | 7738558 | 28.31 | 7 | 198.17
2022-03-08 00:00:00 | COUCH | RMUSA | ANYWHERE,US | 7738559 | 28.06 | 11.6 | 325.496
2022-03-09 00:00:00 | VMC | RMUSAWF | ANYWHERE,US | 7738560 | 27.35 | 9 | 246.15
2022-03-10 00:00:00 | DUNN | ACI | ANYWHERE,US | 7738561 | 28.28 | 7 | 197.96
2022-03-11 00:00:00 | COUCH | MSP | TARRANT,US | 7738562 | 28.22 | 11 | 310.42 | 55.87 | 55.87559999999999
2022-03-13 00:00:00 | RED BLUFF | MSP | TARRANT,US | 7738564 | 27.35 | 11 | 300.85 | 54.18 | 54.153
2022-03-14 00:00:00 | VMC | RMUSAWF | ANYWHERE,US | 7738565 | 29.05 | 9 | 261.45
2022-03-15 00:00:00 | COUCH | RMUSA | USEXANDER CITY,US | 7738566 | 28.02 | 8.35 | 233.967
2022-03-16 00:00:00 | MIDSOUTH AGG | MSP | ANYWHERE,US | 7738567 | 27.51 | 10 | 275.1 | 49.51 | 49.518
2022-03-17 00:00:00 | RED BLUFF | MSP | TARRANT,US | 7738568 | 28.16 | 11 | 309.76 | 55.79 | 55.7568
2022-03-18 00:00:00 | MMONEIL | MSP | ANYWHERE,US | 7738569 | 28.05 | 8.78 | 246.279 | 44.31 | 44.33022
2022-03-19 00:00:00 | RED BLUFF | KPC | WETUMOKA,US | 7738570 | 28 | 5 | 140
2022-03-11 00:00:00 | RED BLUFF | MSP | WETUMOKA,US | 7738571 | 28.3 | 5 | 141.5 |  | 25.47
 |  |  |  | [NAME] | 449.17 | Gross | 4094.384 | 259.66 | 285.10362
 | Gross | 4094.384
 | 0.1 | 409.4384
 | Liability/Cargo Ins | 132
 | BC/BS | 123.98
 | W/Comp | 60
 | Aflac | 76.53
 | Sub Net | 3292.435599999999
 | [NAME] | 259.66
 | Net Due | 3552.095599999999
Spreadsheet: 750797d1633636432-search-row-for-2-matches-and-sum-collumn-below-excel-help-forum
Sheet: Forecast

 |  |  | Month 1 |  | Month 2 |  | Month 3 |  | Month 4 |  | Month 5 |  | Month 6 |  | Month 7 |  | Month 8 |  | Month 9 |  | Month 10 |  | Month 11 |  | Month 12
Revenue | YearStart- | 2023 | January | % | February | % | March | % | April | % | May | % | June | % | July | % | August | % | September | % | October | % | November | % | December | %
Net Income
 |  |  | The green cells on row 3 are the object cells
[NAME] |  |  | I want the formulas to look at the month directly above (light orange) in the cell above and the year in C2 (yellow)
January | 1 |  | (I have been using a vlookup table to help convert the month to a number in other formulas in my sheet. You may not need this though :) )
February | 2
March | 3 |  | I would like the formula to search Revenue!Row1 for the year and month and sum the totals in row 2-10
April | 4 |  | If sum is not possible, then please link it to the already Sum'ed amount in red.
May | 5
June | 6 |  | For this example the search is all months in 2023 and should look like this:
July | 7
August | 8
September | 9
October | 10
November | 11
December | 12
 |  |  | Please note that my Revenue sheet is adjustable and can start at a non-January month.
 |  |  | If the Year on the Revenue sheets needs repositioning to a row above, then so be it :)
Spreadsheet: 1327cbb2-5162-47c2-acb9-034681c13f7f
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
APCRV | Test | APCRV | Activated Protein C Resistance V (APCRV), Plasma | Activated Protein Resistance V, P | Clot-Based Assay | Light blue-top (citrate) tube: LgtBlu |  |  | 1 | mL | See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Spin down, remove plasma, and spin plasma again. 2. Freeze specimens immediately at < or =-40 degrees C, if possible. Additional Information: 1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. If priority specimen, mark request form, give reason, and request a call-back. 3. Each coagulation assay requested should have its own vial. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK - refreeze - note to lab Lipemia	Mild OK; Gross reject Icterus	NA Other	[NAME] vial | APCRV RATIO > or =2.3 Pediatric reference range has neither been established nor is available in scientific literature. The adult reference range likely would be applicable to children >6 months.  REPORTABLE RANGE 1.0-10.0 | Monday through Friday | 1 day | 3 days | 1 | 85307 |  |  |  |  | Rochester
APCRV | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
APCRV | Result | APCR | [NAME] | [NAME] | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13590-5
APCRV | Result | INT55 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 30236755-1152-4c4e-ad84-d76bf0965369
Sheet: 2006

WEST BRANCH MARINA HISTORICAL DATA - 2006
Category |  |  |  |  |  |  |  |  |  |  |  |  | Total | Commission | %
of Revenue | Jan. | Feb. | March | Apr. | May | Jun. | Jul. | Aug. | Sept. | Oct. | Nov. | Dec. | Receipts | Paid | Paid
Rental - Boats & Motors | 0 | 0 | 0 | 0 | 8906.25 | 17484 | 47729.5 | 43827.5 | 5707 | 0 | 0 | 0 | 123654.25 | 13601.98 | 0.11
Marine Equipment Sales | 0 | 0 | 0 | 0 | 590.69 | 2542.51 | 4457.96 | 2360.59 | 42.75 | 0 | 0 | 0 | 9994.5 | 699.62 | 0.07
Bait and Tackle | 0 | 0 | 0 | 0 | 523.49 | 915.49 | 1437.41 | 1584.48 | 126.4 | 0 | 0 | 0 | 4587.27 | 504.5899999999999 | 0.11
Gasoline and Oil | 0 | 0 | 0 | 0 | 2710.2 | 8472.06 | 21530.22 | 16341.81 | 1028.87 | 0 | 0 | 0 | 50083.16 | 1502.5 | 0.03
Food and Beverage | 0 | 0 | 0 | 0 | 1366.59 | 6339.01 | 9964.35 | 7068.99 | 1509.31 | 0 | 0 | 0 | 26248.25 | 2099.86 | 0.08
Vending | 0 | 0 | 0 | 0 | 194 | 180 | 257 | 175 | 100 | 0 | 0 | 0 | 906 | 90.6 | 0.1
Transient Dockage | 0 | 0 | 0 | 0 | 15 | 105 | 345 | 250 | 0 | 0 | 0 | 0 | 715 | 357.5 | 0.5
Souvenirs and Sundries | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12
All Other Receipts | 0 | 0 | 0 | 0 | 0 | 43.76 | 436.33 | 275.68 | 0 | 0 | 0 | 0 | 755.77 | 60.45999999999999 | 0.08
Totals | 0 | 0 | 0 | 0 | 14306.22 | 36081.83000000001 | 86157.77 | 71884.04999999999 | 8514.33 | 0 | 0 | 0 | 216944.2 | 18917.11
Spreadsheet: 827846d1683063389-need-help-adding-to-an-existing-formula-23-pallet-log-pallet-test
Sheet: Formula

Formula of # of Signatures Per Pallet for Pallet Tags
Booklets - Perfect Bound (Pink Paper)
64 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 5500 | per pallet
48 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 9000 | per pallet
32 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 11000 | per pallet
16 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 13000 | per pallet
Tabloids - Perfect Bound (Pink Paper)
32 pg tabs | Finish Quantity + over's + 6,000 |  | @ | 5500 | per pallet
24 pg tabs | Finish Quantity + over's + 6,000 |  | @ | 9000 | per pallet
16 pg tabs | Finish Quantity + over's + 6,000 |  | @ | 11000 | per pallet
8 pg tabs | Finish Quantity + over's + 6,000 |  | @ | 13000 | per pallet
Booklets - Saddle Stitched (Blue paper)
64 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 5500 | per pallet
48 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 9000 | per pallet
32 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 11000 | per pallet
16 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 13000 | per pallet
Tabloids - Saddle Stitched (Blue paper)
32 pg tabs | Finish Quantity + over's + 6,500 |  | @ | 5500 | per pallet
24 pg tabs | Finish Quantity + over's + 6,500 |  | @ | 9000 | per pallet
16 pg tabs | Finish Quantity + over's + 6,500 |  | @ | 11000 | per pallet
8 pg tabs | Finish Quantity + over's + 6,500 |  | @ | 13000 | per pallet
Didde
Flat sheets: | Use the same quantity as web divided by the # printed up, divided by the SPI of paper,
 | divided by 108" on pallet.
Folded 8-pg sigs: Use the same Quantity as web |  |  | @ | 15000 | per pallet | 1 sheet/pallet
* To Figure out the # of pallets use the figures on the front of this sheet.						 * Then enter the # pallets on the Pallet Log page. 						 * The # of white & color tags will automatically be figured.
To Print
* Select Print
* Make sure the ADV 6255 printer is selected
* Select Page Setup -- Select US Legal 8-1/2" x 14"
* Select Printer -- Select a - Pallet Tags (white) - print amount needed.
* Select Printer -- Select b - Pallet Tags (color) - print amount needed.
* Make sure the appropriate color paper in in tray 3 when printing color sheets.
Put the Didde envelopes in the box in Plating by the door.
Put the Web envelopes with [NAME] sheet in the box in Pressroom on the table.
Put the Web envelopes with [NAME] sheet in the box in Pressroom on the table.
Spreadsheet: 672412d1586865055-vlookup-hlookup-for-question-2
Sheet: New Roll Up

Store + SKU | SKU | STORE | What DC are they attached to? | DC New Format | Concat | DC Inventory | Store Inventory | Weekly Movement
1975040 | 19750 | 40 | DC04 - DUNN, NC | DC- 04 | DC- 0419750 | 825 | FORMULA (DATA on STORE INVENTORY TAB) | FORMULA (DATA on WEEKLY STORE MOVEMENT TAB)
1975057 | 19750 | 57 | DC04 - DUNN, NC | DC- 04 | DC- 0419750 | 825 | FORMULA (DATA on STORE INVENTORY TAB) | FORMULA (DATA on WEEKLY STORE MOVEMENT TAB)
1975059 | 19750 | 59 | DC04 - DUNN, NC | DC- 04 | DC- 0419750 | 825 | FORMULA (DATA on STORE INVENTORY TAB) | FORMULA (DATA on WEEKLY STORE MOVEMENT TAB)
1975061 | 19750 | 61 | DC04 - DUNN, NC | DC- 04 | DC- 0419750 | 825 | FORMULA (DATA on STORE INVENTORY TAB) | FORMULA (DATA on WEEKLY STORE MOVEMENT TAB)
1975067 | 19750 | 67 | DC04 - DUNN, NC | DC- 04 | DC- 0419750 | 825 | FORMULA (DATA on STORE INVENTORY TAB) | FORMULA (DATA on WEEKLY STORE MOVEMENT TAB)
Spreadsheet: 834342d1687705415-trying-to-use-number-0-9-in-total-of-numbers-to-auto-generate-0000-9999-4d
Sheet: Sheet1

Number + 5
4 | 1 | 9 | 3
8 | 7 | 0 | 0
1 | 3 | 6 | 6
0 | 8 | 8 | 0
9 | 7 | 6 | 3
7 | 2 | 4 | 5
=
9 | 6 | 4 | 8
3 | 2 | 5 | 5 |  |  |  | NUM | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
6 | 8 | 1 | 1 |  |  |  | TOTAL
5 | 3 | 3 | 5
4 | 2 | 1 | 8
2 | 7 | 9 | 0
0111
0112 | 0122 |  |  |  |  |  |  |  |  | 0222
0113 | 0123 | 0133 |  |  |  |  |  |  |  | 0223 | 0233 |  |  |  |  |  |  |  | 0333
0114 | 0124 | 0134 | 0144 |  |  |  |  |  |  | 0224 | 0234 | 0244 |  |  |  |  |  |  | 0334 | 0344
0115 | 0125 | 0135 | 0145 | 0155 |  |  |  |  |  | 0225 | 0235 | 0245 | 0255 |  |  |  |  |  | 0335 | 0345 | 0355
0116 | 0126 | 0136 | 0146 | 0156 | 0166 |  |  |  |  | 0226 | 0236 | 0246 | 0256 | 0266 |  |  |  |  | 0336 | 0346 | 0356 | 0366
0117 | 0127 | 0137 | 0147 | 0157 | 0167 |  |  |  |  | 0227 | 0237 | 0247 | 0257 | 0267 |  |  |  |  | 0337 | 0347 | 0357 | 0367
0118 | 0128 | 0138 | 0148 | 0158 | 0168 | 0178 | 0188 |  |  | 0228 | 0238 | 0248 | 0258 | 0268 | 0278 | 0288 |  |  | 0338 | 0348 | 0358 | 0368 | 0378 | 0388
0119 | 0129 | 0139 | 0149 | 0159 | 0169 | 0179 | 0189 | 0199 |  | 0229 | 0239 | 0249 | 0259 | 0269 | 0279 | 0289 | 0299 |  | 0339 | 0349 | 0359 | 0369 | 0379 | 0389 | 0399
0444
0445 | 0455 |  |  |  |  |  | 0555
0446 | 0456 | 0466 |  |  |  |  | 0556 | 0566 |  |  |  |  | 0666
0447 | 0457 | 0467 |  |  |  |  | 0557 | 0567 |  |  |  |  | 0667
0448 | 0458 | 0468 | 0478 | 0488 |  |  | 0558 | 0568 | 0578 | 0588 |  |  | 0668 | 0678 | 0688 |  |  | 0788 |  |  | 0888
0449 | 0459 | 0469 | 0479 | 0489 | 0499 |  | 0559 | 0569 | 0579 | 0589 | 0599 |  | 0669 | 0679 | 0689 | 0699 |  | 0789 | 0799 |  | 0889 | 0899
Spreadsheet: 786452d1657197789-split-names-at-capital-letter-directly-after-lowercase-letter-book1
Sheet: Sheet1

Arizona Diamondbacks‎Colorado Rockies‎ |  | Colorado Rockies‎
Atlanta Braves‎St. [NAME] | Atlanta Braves‎ | St. Louis Cardinals‎
Baltimore Orioles‎Los Angeles Angels‎ | Baltimore Orioles‎ | Los Angeles Angels‎
Boston Red Sox‎New York Yankees‎ | Boston Red Sox‎ | New York Yankees‎
Chicago White Sox‎Detroit Tigers‎ | Chicago White Sox‎ | Detroit Tigers‎
Houston Astros‎Kansas City Royals‎ | Houston Astros‎ | Kansas City Royals‎
Los Angeles Dodgers‎Chicago [NAME] | Los Angeles Dodgers‎ | Chicago Cubs‎
New York Mets‎Miami Marlins‎ | New York Mets‎ | Miami Marlins‎
Philadelphia Phillies‎Washington Nationals‎ | Philadelphia Phillies‎ | Washington Nationals‎
San Diego Padres‎San Francisco Giants‎ | San Diego Padres‎ | San Francisco Giants‎