tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124712d1318559880-how-could-the-value-attached-to-a-specific-date-falls-into-the-corresponding-month-excel-question
Sheet: Sheet1

Entity Code | GL | GL Description | Lease ID | Level/Suite | Tenant | Tenancy Type | NLA  Area m2 | Lease Commencement Date | Lease [NAME] | Option Terms (Yrs) | Option (Yrs) | Next Review | Review Type | % | Rent p.a. | Rent $sqm | Net / Gross | $ Annual | $ [NAME] PA | No. of  Bays |  | 1ST Review | 1ST Review Type | 1ST Review Rent/Sqm | 1ST Review Yearly Rent | 2ND Review | 2ND Review Type | 2ND Review Rent/Sqm | 2ND Review Yearly Rent | 3RD Review | 3RD Review Type | 3RD Review Rent/Sqm | 3RD Review Yearly Rent | 4TH Review | 4TH Review Type | 4TH Review Rent/Sqm | 4TH Review Yearly Rent | 5TH Review | 5TH Review Type | 5TH Review Rent/Sqm | 5TH Review Yearly Rent |  | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-03-31 00:00:00 | 2013-04-30 00:00:00 | 2013-05-31 00:00:00 | 2013-06-30 00:00:00 | 2013-07-31 00:00:00 | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-30 00:00:00 | 2013-12-31 00:00:00 | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00 | 2014-05-31 00:00:00 | 2014-06-30 00:00:00 | 2014-07-31 00:00:00 | 2014-08-31 00:00:00 | 2014-09-30 00:00:00 | 2014-10-31 00:00:00 | 2014-11-30 00:00:00 | 2014-12-31 00:00:00 | 2015-01-31 00:00:00 | 2015-02-28 00:00:00 | 2015-03-31 00:00:00 | 2015-04-30 00:00:00 | 2015-05-31 00:00:00 | 2015-06-30 00:00:00 | 2015-07-31 00:00:00 | 2015-08-31 00:00:00 | 2015-09-30 00:00:00 | 2015-10-31 00:00:00 | 2015-11-30 00:00:00 | 2015-12-31 00:00:00 | 2016-01-31 00:00:00 | 2016-02-29 00:00:00 | 2016-03-31 00:00:00 | 2016-04-30 00:00:00 | 2016-05-31 00:00:00 | 2016-06-30 00:00:00 | 2016-07-31 00:00:00 | 2016-08-31 00:00:00 | 2016-09-30 00:00:00 | 2016-10-31 00:00:00 | 2016-11-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 |  | 2013 | 2014 | 2015 | 2016 | 2017
300277 |  | Licence-Telecommunication |  | Telco 17 | UEACCESS PTY LTD | TEL | 0 | 2000-08-01 00:00:00 | 2005-07-31 00:00:00 | 5 | Holdover Status* | 2012-08-01 00:00:00 | Fix | 0.04 | 20012.91 | 0 | TGR | 0 | 0 | 0 |  | 2012-08-01 00:00:00 | 0.04 | 0 | 20813.4264 | 2013-08-01 00:00:00 | 0.04 | 0 | 21645.963456 | 2014-08-01 00:00:00 | 0.04 | 0 | 22511.80199424 | 2015-08-01 00:00:00 | 0.04 | 0 | 23412.27407400961 | 2016-07-31 00:00:00 | 0.04 | 0 | 24348.76503696999 |  |  |  |  |  | 20813.4264 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21645.963456 |  |  |  |  |  |  |  |  |  |  |  | 22511.80199424 |  |  |  |  |  |  |  |  |  |  |  | 23412.27407400961 |  |  |  |  |  |  |  |  |  |  |  | 24348.76503696999 |  |  |  |  |  |  |  |  |  |  |  | 20813.4264 | 21645.963456 | 22511.80199424 | 23412.27407400961 | 24348.76503696999
Spreadsheet: 67827d1268334580-indexing-larger-value-copy-of-book3
Sheet: Customers

Account | Customer | Quantity | UM | Price | Document # | Rep | Date | Type | Discount | Cost | Tax Code | Revenue Account | Expense Account | Location/Sub-Location | Net Price | Week Created | Month Created | Net Charge Amount
396611 | [NAME] | 1 | EA | 339 | SO-5169750 | NLE | 2009-01-02 00:00:00 | [NAME] | 0 | 220 | EXEMPT |  |  | MAIN | 339 | WEEK 1,2009 | 2009, 1
403590 | [NAME] | 1 | EA | 339 | SO-5175793 | NLE | 2009-01-29 00:00:00 | [NAME] | 0 | 220 | EXEMPT |  |  | MAIN | 339 | WEEK 5,2009 | 2009, 1
421516 | [NAME] | 1 | EA | 319 | SO-5191623 | NLE | 2009-05-21 00:00:00 | [NAME] | 0 | 202.4 | EXEMPT |  |  | MAIN | 319 | WEEK 21,2009 | 2009, 5
420290 | [NAME] yates | 1 | EA | 319 | SO-5190527 | NLE | 2009-05-16 00:00:00 | [NAME] | 0 | 202.4 | EXEMPT |  |  | MAIN | 319 | WEEK 20,2009 | 2009, 5
Ok I have revised it for you…i..you will see that [NAME], [NAME], [NAME] yate have 2 shipments but
the net charge on one is higher than the other…is there a way to skip the lower charge and have the higher charge
put into S3
the higher charges are highlighted in green on Ground3 sheet
but as you can see [NAME] coleman only has 1 shipment and I still need to get the charge imported into the S colum also
Spreadsheet: 270859d1381721830-running-average-formula-running-average
Sheet: Sheet1

 | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Total | [NAME]
Stock A | 500 | 260 | 50 | 800 | 900 | 250 | 230
Stock B | 200 | 200 | 500 | 800 | 600 | 400 | 300
Stock C | 300 | 100 | 12 | 150 | 180 | 250 | 220
Stock D | 5000 | 50 | 500 | 800 | 300 | 400 | 500
Stock E | 8000 | 1000 | 1500 | 1300 | 1800 | 180 | 180
Total
 |  |  |  |  |  |  | Current Wk
Spreadsheet: 375738d1423315481-adding-up-check-boxes-book1-updated
Sheet: Sheet1

January 2015 Timesheet
MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
 |  |  | False | False | False | False
False | False | False | False | False | False | False |  | Select All Weekdays
False | False | False | False | False | False | False
False | False | False | False | False | False | False
False | False | False | False | False | False
 |  |  |  | Days Worked:
Spreadsheet: 708554d1607929373-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: GERMANY

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: 110599d1307218175-look-up-one-value-and-return-multiple-values-and-sum-tableptexample
Sheet: Sheet2

Date | Product | Sold |  |  |  |  |  |  |  | Products
2011-05-01 00:00:00 | Cookies | 1 | <<This is what a Table should look like |  |  |  |  |  |  | Cookies | <<This list used in Validation List of Products
2011-05-01 00:00:00 | Cakes | 10 |  |  |  |  |  |  |  | Cakes
2011-05-01 00:00:00 | Chocolate | 10 |  |  |  |  |  |  |  | Chocolate
2011-05-01 00:00:00 | Pies | 11 |  |  |  |  |  |  |  | Pies
2011-05-01 00:00:00 | Muffins | 8 |  |  |  |  |  |  |  | Muffins
 | Cookies | 30
 | Cakes | 9
 | Chocolate | 10 |  |  | Product | Muffins |  | <<Filter this pivot table for your product.
 | Pies | 9
 | Muffins | 2 |  |  | Row Labels | Sum of Sold
 | Cookies | 2 |  |  | 2011-05-01 00:00:00 | 5
 | Cakes | 22 |  |  | 2011-05-02 00:00:00 | 13
 | Chocolate | 26 |  |  | 2011-05-03 00:00:00 | 23
 | Pies | 28 |  |  | 2011-05-04 00:00:00 | 20
 | Muffins | 5 |  |  | 2011-05-05 00:00:00 | 12
 | Cookies | 0 |  |  | 2011-05-06 00:00:00 | 15
 | Cakes | 13 |  |  | 2011-05-07 00:00:00 | 9
 | Chocolate | 3 |  |  | 2011-05-08 00:00:00 | 30
 | Pies | 12 |  |  | 2011-05-09 00:00:00 | 23
 | Muffins | 3 |  |  | Grand Total | 150
 | Cookies | 29
 | Cakes | 15
 | Chocolate | 1
 | Pies | 2
 | Muffins | 18
 | Cookies | 9
 | Cakes | 8
 | Chocolate | 17
 | Pies | 30
 | Muffins | 15
 | Cookies | 2
 | Cakes | 6
 | Chocolate | 28
 | Pies | 4
 | Muffins | 19
 | Cookies | 16
 | Cakes | 22
 | Chocolate | 1
 | Pies | 6
 | Muffins | 28
 | Cookies | 5
 | Cakes | 6
 | Chocolate | 30
 | Pies | 22
 | Muffins | 18
Spreadsheet: 804220d1667940703-display-cells-based-on-value-entered-sportsref_download-table-autofilter
Sheet: Check

Team | Player | PTS RFE | PTS SB | PTS L10 | AST RFE | AST SB | AST L10 | TRB RFE | TRB SB | TRB L10 | 3P RFE | 3P SB | 3P L10 | Total RFE | Total SB | Total L10 | PT+Asst RFE | PT+ASST SB | PT+Asst L10 | PT+TRB RFE | PT+TRB SB | PT+TRB L10
Spreadsheet: 156849d1337521533-a-seriously-major-defect-in-excel-or-activitydemo
Sheet: Raw Data

To be Filled By Physician |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To Be Filled By The OR Station
Date | Assigned Physician | Scheduled start    time | File No. | Patient Name | Age | Sex | Eye | Surgery  Planned Pre Op.  Code | 2nd code (If Present) | 3rd Code (If Present) | Operation | Medical Considerations /Remarks | Payment Type | Prepared By | Hospital/center location | Hospital  Room | OR Room | Case order in OR Room | Actual Post Op sr.       code 1 | Actual Post Op   sr.    Code2 | Actual Post Op sr.    Code 3 | Time Of Entry to pre op | Time of entry to OR | Time surgery started | Time surgery ended | Time of entry to recovery | Time of exit from recovery | Type of anaethesia | Anaesthesiologist | Actual Surgeon | Assistant Surgeon | Observer physician
Spreadsheet: 108021d1305131420-vlookup-assistance-vlookup
Sheet: Lists

General Categories | Agency Actions | Funding Actions | Economic Conditions | Other Reasons | Amt_Deobl | Valid_Obl | ADMIN_BY | Tier
Agency Actions | Delays in design or construction changes | Transfers | Delays in fund commitment process | Programming errors and accounting adjustments | Yes | Yes | State | 1
Funding Actions | Delays in Awards | Earmarks | Funds commitment but not yet obligated | Other billing issues | No | No | LPA | 2
Economic Conditions | Environmental actions | Pooled fund project | Project Cost underestimated |  |  |  | [NAME] | 3
Other Reasons | Right-of-way actions | Debt service payments | Changes in priorities |  |  |  | FTA
 | Transfers and/or reprogramming actions | Advance Construction conversion | Not properly equipped or staffed |  |  |  | Other
 | Contract disputes
 | Project failure to advance
 | Delays in submitting bills
 | Expenditures posted since last inactive reporting cycle
 | Delays in submitting final records and/or final report
 | Funds de-obligated since prior period inactive report
 | Project cancelation, withdrawn and/or closed
 | Processing final voucher
 | Delays due to final audit
Spreadsheet: 855941d1705385413-how-to-reference-a-list-and-add-value-help02
Sheet: Sheet1

Employee No. | Employee Name | Supervisor Employee no. | [NAME]
0001 | Kimberly | 1010 | Bracha
0002 | [NAME] | 1010 | Bracha
0003 | Artichoke | 1010 | Bracha
0004 | Kiwi | 1010 | Bracha
0005 | [NAME] | 1010 | Bracha
0006 | [NAME] | 1010 | Bracha
0007 | [NAME] | 1010 | Bracha
0008 | [NAME] | 1010 | Bracha
Spreadsheet: 13ea0932-29ef-4000-91f2-50249675e005
Sheet: Sheet1

SampleWizard | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Panel Dialog | Setup Procedure | Next Procedure | Back Procedure | Finish Procedure | Cancel Procedure | Help Procedure
DBStep1 | Convert_Wizard_DBStep1_Setup | DBStep1_Next
DBStep2 | DBStep2_Setup | DBStep2_Next
DBStep3 | DBStep3_Setup |  |  | DBStep3_Finish
Spreadsheet: 842087d1694156158-dynamic-array-formula-needed-for-irregular-data-book1-6-
Sheet: Sheet1

 |  |  |  |  | Expected
 | [NAME] | Dataset | Product | Channel | Division |  |  |  |  |  | Dataset | unique id | Division
 | 1 | [NAME] |  |  |  |  |  |  |  |  | 1 | [NAME] | North
 |  |  | Product X | EU |  |  | North |  |  |  | 2 | XEFGH | South
 |  |  | Product X | UK |  |  | North |  |  |  | 3 | XIJKL | West
 |  |  | Product X | AU |  |  | North |  |  |  | 4 | XMNOP | North
 |  |  | Product X | US |  |  | North |  |  |  | 5 | XQRST | East
 | 2 | XEFGH |  |  |  |  |  |  |  |  | 6 | XUVWX | West
 |  |  | Product Y | EU |  |  | South
 |  |  | Product Y | UK |  |  | South
 |  |  | Product Y | AU |  |  | South
 |  |  | Product Y | US |  |  | South
 | 3 | XIJKL
 |  |  | Product Z | EU |  |  | West
 |  |  | Product Z | UK |  |  | West
 |  |  | Product Z | AU |  |  | West
 |  |  | Product Z | US |  |  | West
Spreadsheet: 143364d1330381793-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (29) Main Office

Date: | 2011-11-17 00:00:00 |  |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | Main Office
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
1 | tiles coming up in front of [NAME]'s office | basement | carryover
2 | emergency light out | mailroom storage area | carryover
 | emergency light out | main hallway top floor | carryover
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - housekeeping was good
ESCORT:
Spreadsheet: 675707d1588436869-create-summary-list-from-multiple-worksheets-create_summary
Sheet: Summary

Manufacturer | Model | Image | Store location
A | xx |  | Box 1
B | yy |  | Box 1
C | zz |  | [NAME]
D | yy |  | [NAME]
G | zzz |  | [NAME]
H | yy |  | [NAME]
A | [NAME] |  | Box 1
B | nn |  | Box 1
C | oo |  | [NAME]
N | y |  | Box 1
O | w |  | [NAME]
P | z |  | [NAME]
Spreadsheet: 274689d1383189034-can-i-filter-this-differently-filter-excel-fourm
Sheet: Sheet1

 |  |  |  | 2 | 2
 |  |  |  | 2 | 2 | I want to able to filter say rows 18,19,20 column E
 |  |  |  | 2 | 2 | or rows 5,6,7,8.  Is this possible?
 |  |  |  | 2
 |  |  |  | 8
 |  |  |  | 2
 |  |  |  |  | 6
 |  |  | OBHITS | 4
 |  |  | OBHITS | 2 | 2
 |  |  | OBHITS | 4
 |  |  | OBHITS | 2 | 2 |  |  |  |  | Id want to find all the combinations like this as if there were 100,000+ lines
 |  |  | OBHITS | 2 | 10
 |  |  | 50+ | 4 |  |  | say I wanted to search for the |  |  | 4
 |  |  | 50+ | 4 |  |  | following.  Is that possible? |  |  | 8 | 2
 |  |  | 50+ |  | 2 |  |  |  |  | 4
 |  |  | 50+ | 8
 |  |  | 50+ | 4
 |  |  | Sears | 4
 |  |  | Sears | 16 | 4
 |  |  | Sears | 2
 |  |  | Sears | 2
 |  |  | Sears | 24 | 24
 |  |  | Alpine | 2
 |  |  | Alpine | 6
 |  |  | Alpine | 2 | 4
 |  |  | Alpine | 6
Spreadsheet: 294219d1391257974-categories-on-one-sheet-when-sorted-data-on-other-sheets-doesnt-sort-with-it-categories
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total
Daily Totals
 | 123
Spreadsheet: dc14be58-b723-4ad5-8535-e267528ec1b8
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
PTP22 | Test | PTP22 | PTPN22 Genotype, 1858C->T | PTPN22 Genotype, 1858C>T | Polymerase Chain Reaction (PCR) 5'-Nuclease End point Allelic Discrimination Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular System, Inc.) | Lavendar-top (EDTA) Tube: EDTA |  |  | 3 | mL | Multiple whole blood EDTA genotype tests can be performed on a single specimen after a single extraction. See Multiple Whole Blood EDTA Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Additional Information: 1. Bone marrow and liver transplants will interfere with testing. Call Mayo Medical Laboratories at [PHONE] or [PHONE] for instructions. 2. Transfusions will interfere with testing for up to 4 to 6 weeks. DNA obtained from white cells may not provide useful information for patients who received a recent transfusion of blood that was not leukocyte-reduced. Wait 4 to 6 weeks until transfused cells have left the patient's circulation before drawing the patient's blood specimen for genotype testing. | 0.3 mL | Hemolysis	NA Thawing	Reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday; 8 a.m. | 1 day | 8 days | 1 | 81479 |  |  |  |  | Rochester
PTP22 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
PTP22 | Result | 31757 | PTPN22 Genotype, 1858C>T | PTPN22 Genotype, 1858C>T | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PTP22 | Result | 31758 | PTPN22 Interpretation | PTPN22 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PTP22 | Result | 31759 | [NAME] Reviewed by | [NAME] Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 97525d1296672504-how-to-delete-empty-rows-past-due-tracker
Sheet: Loans

 | Account Number | Name | Amt. | Collector | [NAME]? | Cost Center Name |  |  |  |  |  |  |  | YES |  | Indicates loan will not be over 30 days at month end
 | 12345 | [NAME] | 9867.97 | [NAME] | YES | [NAME] |  |  |  |  |  |  |  | NO
 | 67890 | [NAME] | 890 | [NAME] | NO | Harlingen
 | 56789 | [NAME] | 765.09 | [NAME] | NO | [NAME]
 | 21354 | [NAME] | 45675 | [NAME] | NO | [NAME]
 | 57985 | [NAME] | 478546.12 | [NAME] | YES | Edinburg South
 | 24895 | [NAME] | 98.21 | [NAME] | NO | Edinburg
 | 58963 | [NAME] | 5001.02 | [NAME] | NO | Mission Main
 | 54897 | [NAME] | 9954.2 | [NAME] | NO | [NAME] Main
 | 57007 | [NAME] | 2018.02 | [NAME] | NO | McAllen South
 | 54004 | [NAME] | 1023456.25 | [NAME] | NO | Mission East
 | 91154 | [NAME] | 4513.23 | [NAME] | YES | Mission West
 | 35458 | [NAME] | 34895.25 | [NAME] | NO | Harlingen South
 | 15647 | [NAME] | 99100.25 | [NAME] | NO | [NAME]
 | 97542 | [NAME] | 103589.21 | [NAME] | NO | Edinburg
 | 21354 | [NAME] | 4542.21 | [NAME] | NO | Edinburg South |  |  |  | [NAME] | Harlingen | Edinburg | Mission | Laredo
 | 78945 | [NAME] | 2408.05 | [NAME] | NO | [NAME] |  |  | Amount that will hit for city
 | 12565 | [NAME] | 623 | [NAME] | NO | Harlingen |  |  | Loans past due for city
 | 15648 | [NAME] | 465.25 | [NAME] | NO | Harlingen
 | 99960 | [NAME] | 98474.87 | [NAME] | YES | Harlingen South
 | 12300 | [NAME] | 1546.25 | [NAME] | NO | Laredo
 | 25885 | [NAME] | 98453 | [NAME] | YES | Mission |  |  |  | [NAME] | [NAME]
 | 97642 | [NAME] | 1544.14 | [NAME] | NO | Edinburg |  |  | Collector Past due $'rs
 | 25648 | [NAME] | 4654.24 | [NAME] | NO | [NAME] |  |  | Loans past due for collector
 | 10101 | [NAME] | 987465.2 | [NAME] | NO | Laredo South
 | 20202 | [NAME] | 245354.2 | [NAME] | YES | Harlingen
 | 40404 | [NAME] | 124545.46 | [NAME] | NO | [NAME]
 |  | Amount that will hit:
Spreadsheet: 144009d1330669709-how-to-split-some-qty-with-respect-to-a-particular-constant-copy-of-capacity-check_ref
Sheet: Output

Part Numer | Description |  | Demand Qty | CRD Date | # of Days to [NAME]
Spreadsheet: 693174d1598827360-sales-projections-using-a-monthly-growth-rate-modelexample-engineeradam-
Sheet: Sheet2

Sales Total | Month | Units | Clients => | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 1 | 2
 | 2 | 2
 | 3 | 4
 | 4 | 4
 | 5 | 6
 | 6 | 6
 | 7 | 6
 | 8 | 8
 | 9 | 8
 | 10 | 9
 | 11 | 9
 | 12 | 10
Spreadsheet: 453035d1459125702-chart-days-instead-of-months-inventory
Sheet: Inventory

 | Inventory
 | Select Day | 2016-03-01 00:00:00
 | Owner |  |  | Type |  |  |  |  |  |  |  | Customer
 | 1 | 2222 |  | O |  | 11021 |  |  |  |  |  | Unallocated |  | 0
 | 2 | 10999 |  | S |  | 2272 |  |  |  |  |  | Allocated |  | 0
 | 3 | 4411 |  | SF |  | 4421 |  |  |  |  |  | Customer 3 |  | 0
 | 4 | 50 |  |  |  |  |  |  |  |  |  | Customer 4 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 5 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 6 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 7 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 8 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 9 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 10 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 11 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Customer 12 |  | 0
 | 0
 | Day | 2016-03-01 00:00:00 | 2016-03-02 00:00:00 | 2016-03-03 00:00:00 | 2016-03-04 00:00:00 | 2016-03-05 00:00:00 | 2016-03-06 00:00:00
 | 1 | 2222 | 3000 | 3500 | 0 | 0 | 0 | Show
 | 2 | 10999 | 12333 | 9500 | 0 | 0 | 0 | Show
 | 3 | 4411 | 5000 | 4590 | 0 | 0 | 0 | Show
 | 4 | 50 | 68 | 75 | 0 | 0 | 0 | Show
 | Total | 17682 | 20401 | 17665 | 0 | 0 | 0
 | O | 11021 | 12383 | 9560 | 0 | 0 | 0 | Show
 | SF | 4421 | 5040 | 4665 | 0 | 0 | 0 | Show
 | S | 2272 | 3068 | 3575 | 0 | 0 | 0 | Show
 | Product 4 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 5 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 6 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 7 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 8 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 9 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 10 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 11 | 0 | 0 | 0 | 0 | 0 | 0 | Show
 | Product 12 | 0 | 0 | 0 | 0 | 0 | 0 | Show
Spreadsheet: 168259d1342353164-excel-2007-vlookup-returns-n-a-with-special-characters-arrayvlookup
Sheet: Sheet1

Job Number | Folder ID | Result I would like to have ([NAME])
Order 1 | 9(Dij':``%U33O7DX@MM | Data
Order 2 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 3 | -uecBgd@Do[XaZ.T5%0g | Bases 1
Order 4 | +0*2hqH"+sJ\&`X?c[sQ | Bases 2
Order 5 | +0*2hqH"+sJ\&`X?c[sQ | Bases 2
Order 6 | 9(Dij':``%U33O7DX@MM | Data
Order 7 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 8 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 9 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 10 | N[0$CF$h<CM0qqoVjoPs | Folder 3
Order 11 | 9(Dij':``%U33O7DX@MM | Data
Order 12 | 9(Dij':``%U33O7DX@MM | Data
Order 13 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 14 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 15 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 16 | 9(Dij':``%U33O7DX@MM | Data
Order 17 | gQ1rgV*`$kO9JKLjcCC" | Folder 2
Order 18 | gQ1rgV*`$kO9JKLjcCC" | Folder 2
Order 19 | gQ1rgV*`$kO9JKLjcCC" | Folder 2
Order 20 | N[0$CF$h<CM0qqoVjoPs | Folder 3
Order 21 | -uecBgd@Do[XaZ.T5%0g | Bases 1
Order 22 | -uecBgd@Do[XaZ.T5%0g | Bases 1
Order 23 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 24 | Kjo@FZoK4%T$qe.WC | #N/A
Order 25 | `&HC#GeTG1S>+s?J#A1g | Folder 5
Order 26 | Kjo@FZoK4%T$qe.WC | #N/A
Order 27 | 9(Dij':``%U33O7DX@MM | Data
Order 28 | Kjo@FZoK4%T$qe.WC | #N/A
Order 29 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 30 | 9(Dij':``%U33O7DX@MM | Data
Order 31 | gQ1rgV*`$kO9JKLjcCC" | Folder 2
Order 32 | -uecBgd@Do[XaZ.T5%0g | Bases 1
Order 33 | -uecBgd@Do[XaZ.T5%0g | Bases 1
Order 34 | 9(Dij':``%U33O7DX@MM | Data
Order 35 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 36 | \BqcJLABFgS<hh=?,Nhq | Folder 4
Order 37 | !!!!!!!!!!!!!!!!!!!! | Root
Order 38 | `&HC#GeTG1S>+s?J#A1g | Folder 5
Order 39 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 40 | `&HC#GeTG1S>+s?J#A1g | Folder 5
Order 41 | 9(Dij':``%U33O7DX@MM | Data
Order 42 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 43 | 9(Dij':``%U33O7DX@MM | Data
Spreadsheet: 56703d1256828077-suming-across-a-row-using-criteria-row-sum-example
Sheet: Sheet1

 | Day 1 |  | Day 2 |  | Day 3 |  | Day 4 |  | Day 5 |  | Day 6 |  | Day 7 |  | Day 8 |  | Total Holiday Hours
 | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours
Smith | In | 7.5 | Holiday | 7.5 | Holiday | 7.5 | AWOL | 7.5 | In | 7.5 | In | 7.5 | In | 7.5 | In | 7.5