tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 856567d1705768845-retrieving-and-moving-transferring-data-latest-problem-tashface-
Sheet: Feb Wk1

 | Main Total
1 | Week | Month | Year | Value
2 |  |  |  |  | My random efforts to produce my required results.
 |  |  |  |  | This formula returns correct week but wrong months.
 |  |  |  |  |  |  |  |  | Is it possible to combine these 2 formulas to produce my required result below?        If so, how?
 |  |  |  |  | This formula returns correct month but wrong weeks.
 | 1 | 2 | 1995 | 198162 | This is the result I want to achieve, all week 1 from February.
 | 1 | 2 | 1996 | 256556
 | 1 | 2 | 1997 | 750792
 | 1 | 2 | 1998 | 665959
 | 1 | 2 | 1999 | 342860
 | 1 | 2 | 2000 | 530213
 | 1 | 2 | 2001 | 454703
 | 1 | 2 | 2002 | 633270
 | 1 | 2 | 2003 | 456370
 | 1 | 2 | 2004 | 216822
 | 1 | 2 | 2006 | 412729
 | 1 | 2 | 2007 | 769925
 | 1 | 2 | 2007 | 769925
 | 1 | 2 | 2008 | 212684
 | 1 | 2 | 2008 | 212684
 | 1 | 2 | 2009 | 534533
 | 1 | 2 | 2009 | 534533
Spreadsheet: ae7c5786-7531-4e37-ae5d-5c4d699e837c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-17 09:48:54.830000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 102.125 | 102 | 101.875 | 101.5
4.5 | 101.861 | 101.736 | 101.611 | 101.236 |  | Note: | Refer To Price [NAME]
4.375 | 100.939 | 100.814 | 100.689 | 100.314 |  |  | For all Price Adjs
4.25 | 100.403 | 100.278 | 100.153 | 99.528
4.125 | 99.612 | 99.487 | 99.362 | 98.737
4 | 98.624 | 98.499 | 98.374 | 97.749
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 102.125 | 102 | 101.875 | 101.5
3.625 | 101.95 | 101.825 | 101.7 | 101.325
3.5 | 101.396 | 101.271 | 101.146 | 100.771
3.375 | 100.675 | 100.55 | 100.425 | 99.8
3.25 | 99.918 | 99.793 | 99.668 | 99.043
3.125 | 99.082 | 98.957 | 98.832 | 98.207 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-10-31 09:48:54.830000
30 DAY | 2013-11-15 09:48:54.830000
45 DAY | 2013-11-30 09:48:54.830000
60 DAY | 2013-12-15 09:48:54.830000
90 DAY | 2014-01-14 09:48:54.830000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 731274d1620259849-formula-to-populate-orders-master-excel-forum
Sheet: Master

Both | Both | Purchases Sheet | Sales Sheet | Purchases Sheet | Purchases Sheet
Item Code | Item Description | Order Number | Customer | Supplier | Order Category # [NAME] | Equivalent UOM | Oct (2020) | Nov (2020) | Dec (2020) | Jan (2021) | Feb (2021) | Mar (2021) | Apr (2021) | May (2021) | Jul (2021) | Total
AU-100000 | vjhndfks;gv
AU-100000
Total
Spreadsheet: 723153d1615545239-multiple-criteria-search-for-discount-example-4-
Sheet: Commitment

 | Total
 | 2020
 | Commitment
 |  | Expenses
 | Agentur | Before Discount | % | After Discount
 | CUSTOMER A | 133922.2836405553
 | CUSTOMER A | 758580.301325947
 | CUSTOMER A | 434239.658005926
 | CUSTOMER A | 961203.331264831
Spreadsheet: 487153d1477935987-array-small-and-or-function-extract-data-for-given-date-copy-of-product_list-1
Sheet: all

 |  |  |  |  |  |  | vacation 1-st part |  |  |  |  | vacation 2-nd part |  |  |  |  | vacation 3-rd |  |  |  |  | vacation 4-th part
р.бр. | name | section | religious holiday | whole vacation | vacation left |  | no of days | beginning | без славе | end |  | days | beginning | без славе | end |  | days | beginning | без славе | end |  | days | beginning | без славе | end
1 | employe 1 | 1 | 2016-11-21 00:00:00 | 25 |  |  | 10 | 2016-11-18 00:00:00 |  |  |  | 5 | 2016-12-26 00:00:00
 | employe 2 | 2 | 2016-11-22 00:00:00 | 25 |  |  | 15 | 2016-08-12 00:00:00
 | employe 3 | 1 | 2016-11-23 00:00:00 | 25 |  |  | 15 | 2016-07-25 00:00:00
 | employe 4 | 3 | 2016-11-24 00:00:00 | 25 |  |  | 10 | 2016-09-15 00:00:00 |  |  |  | 10 | 2016-07-25 00:00:00
 | employe 5 | 1 | 2016-11-25 00:00:00 | 25 |  |  | 10 | 2016-07-01 00:00:00
 | employe 6 | 4 | 2016-11-26 00:00:00 | 25 |  |  | 10 | 2016-07-15 00:00:00 |  |  |  | 5 | 2016-09-15 00:00:00
 |  |  |  |  |  |  | I can make it to work between I and K columns but I don't know how to add other ranges and how to exclude #num values from list belowe
 | for a date:
 | 2016-07-26 00:00:00
Spreadsheet: 30574d1226111862-irr-function-is-returning-the-wrong-value-case09_joshuakampschmidt_2
Sheet: Profitability

NewLeaf Paper
Profitability of Investment
Payback Period
 | Cash Flow Summary
Initial Investment | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
-750000 | 274643.2897813903 | 277272.8928418722 | 307715.0631667399 | 345675.7944507743 | 388872.7075751248
Cumulative Net Cash Flow | -475356.7102186097 | -198083.8173767375 | 109631.2457900024 | 455307.0402407767 | 844179.7478159014
Profitability of Investment
Rate of Return | 0.18
Net Present Value | 217442.0861365075
Internal Rate of Return | 0.2593896114139408
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADw81r3su288946t75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | chlant!dtfilvafbwm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: d0e9aca5-2173-4326-959a-678cb125a0fd
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
RASP | Test | RASP | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RASP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RASP | Result | RASP | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7656-2 | Rubus idaeus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 888636d1739208762-pulldown-list-expenses
Sheet: 2025

 | Variable Cost 2025 (Credit Cards) |  |  |  | Hydro |  | Fixed Costs |  |  |  | Pay
 | # | Months | CIBC | RBC | [NAME] |  |  | Paid Off | Mortgage |  | # |  | 1st | 2nd | Total
 | 1 | January | 4694.5 | 81.84 | 82.54 |  |  | 235 | Taxes |  | 1 | January | 2100.64 | 2329.34
 |  | February |  |  |  |  |  | 726.49 | Condo Fees |  |  | February
 |  | March |  |  |  |  |  | 29.04 | OTIP Insurance |  |  | March
 |  | April |  |  |  |  |  | 169.02 | NLSC |  |  | April
 |  | May |  |  |  |  |  |  | Hydro (average) |  |  | May
 |  | June |  |  |  |  | Monthly |  |  |  |  | June
 |  | July |  |  |  |  | Yearly |  |  |  |  | July
 |  | August |  |  |  |  | Other Fixed Costs (piad on CC) |  |  |  |  | August
 |  | September |  |  |  |  | Paid on CIBC credit card under "Variable Cost" | 62.15 | Internet |  |  | September
 |  | October |  |  |  |  |  | 226 | Cell Phones |  |  | October
 |  | November |  |  |  |  |  |  | Insurance |  |  | November
 |  | December |  |  |  |  |  | 400 | Gas |  |  | December
 | Variable Cost |  |  |  |  |  |  | 400 | Eating Out |  | Total Pay
 | Average |  |  |  |  |  |  | 200 | TTC
 | Total Credit Card Spend |  |  |  |  |  | Monthly
 | Variable Cost minus "Other Fixed Costs (piad on CC)" |  |  | Fixed Costs | Cash Spending |  | Yearly
 |  |  |  |  |  |  | One Time Pay | 275.88 | Life Insurance
 |  |  | 2024 Total Expenditure |  |  |  |  | 229.9 | Life insurance
 |  |  | 2025 Total Expenditure |  |  |  | Yearly
 |  |  | Diffrence (2024 - 2025): |  |  |  | Total Fixed Yearly
 |  |  |  |  |  |  | Fixed Monthly |  | January
 |  |  |  |  |  |  | Variable Monthly
 |  |  | Diffrence (Pay - Expenditure): |  |  |  | Total
 |  |  | 2025 Montly Expenditure
Spreadsheet: 63530d1264439680-getting-rid-of-the-n-a-in-a-vlookup-lookuptest
Sheet: Sheet1

ProductID | Part Number | ProductDescription | UnitPrice
1 | COMP101 | Desktop Computer | 1299
2 | COMP102 | Server | 2999
3 | COMP103 | Laptop | 1999
4 | MONT101 | 15" Monitor | 299
5 | MONT102 | 17" Monitor | 599
6 | MONT103 | 20" Monitor | 799
7 | MONT104 | 15" LCD Monitor | 799
8 | MONT105 | 17" LCD Monitor | 999
9 | PRINT101 | Laser Printer | 1299
10 | PRINT102 | Color Laser Printer | 1999
11 | SPEAK101 | Speakers | 39.99
12 | SPEAK102 | Speakers w/Sub | 99.99
13 | DISC101 | 25 - 3.5" Diskettes | 5.99
14 | DISC102 | 25 - CD-R | 5.99
15 | DISC103 | 10 - DVD-R | 12.99
16 | PRINT104 | Ink Jet Printer | 599
17 | PER101 | [NAME] | 29.99 |  | id | part | des | qty | price | total
18 | PER102 | Optical Mouse | 59.99 |  | 2 | COMP102 | Server | 2 | 2999 | 5998
19 | PER103 | Keyboard | 59.99 |  |  |  |  | 3 |  | #N/A
20 | PER105 | [NAME] | 499 |  | 0 |  |  | 4 |  | #N/A
21 | PER106 | DVD Drive | 199 |  | 0 |  |  | 5 |  | #N/A
 |  |  |  |  | 0 |  |  | 6 |  | #N/A
 |  |  |  |  | 0 |  |  | 7 |  | #N/A
 |  |  |  |  | 0 |  |  | 8 |  | #N/A
 |  |  |  |  | 0 |  |  | 9 |  | #N/A
 |  |  |  |  | 0 |  |  | 10 |  | #N/A
 |  |  |  |  | 0 |  |  | 11 |  | #N/A
 |  |  |  |  | 0 |  |  | 12 |  | #N/A
 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 852234d1702322057-calculating-the-number-of-ot-hours-between-two-times-from-times-that-cross-midnight-time-sheet-calculator
Sheet: Data

Years | Months | Days | Weekend
2023 | January | 1 | No Weekend
2024 | February | 2 | Sat & Sun
2025 | March | 3 | Sun & Mon
2026 | April | 4 | Mon & Tue
2027 | May | 5 | Tue & Wed
2028 | June | 6 | Wed & Thu
2029 | July | 7 | Thu & Fri
2030 | August | 8 | Fri & Sat
2031 | September | 9 | Mon Only
2032 | October | 10 | Tue Only
2033 | November | 11 | Wed Only
2034 | December | 12 | Thu Only
2035 |  | 13 | Fri Only
2036 |  | 14 | Sat Only
2037 |  | 15 | Sun Only
2038 |  | 16
2039 |  | 17
2040 |  | 18
2041 |  | 19
2042 |  | 20
2043 |  | 21
2044 |  | 22
2045 |  | 23
2046 |  | 24
2047 |  | 25
2048 |  | 26
2049 |  | 27
2050 |  | 28
 |  | 29
 |  | 30
 |  | 31
Spreadsheet: 78f6caf2-1e2a-4737-84ff-9e9d3645722d
Sheet: Capital

CAPITAL PROJECT |  |  |  |  |  |  | 120543
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Southmoreland Park Wall Repair
Is  this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  |  | Replacement
 |  |  |  | X | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify year in which this project was funded.
 | If no, please detail the reasons why this project was not included and need for present funding request.
 | The wall collapsed in two locations and this will cover the expense of repair. The wall is more than 100 years
 | old in certain locations and needs to be restored.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify source and amount.
 | If no, please identify source and amount of city funds.
 | Fourth Council District Contingency
If ordinance is for construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  |  | 14900
 | Estimated lifespan of project in years |  |  |  | 10 years
 | Estimated annual operating and maintenance costs |  |  |  | 500
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | 2017
Reference Numbers: (Previously approved legislation):
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 84619d1284652768-vlookup-next-record-then-the-next-then-the-next-etc-missingdatareport
Sheet: Select By

Number | Name | Edited | Address | Postcode | Landline | Mobile | [NAME] | Correct [NAME] | [NAME] |  | Select By |  | Lookup_By | Name
145403 | Mr G Stuart | 2010-09-08 00:00:00 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 11 | cxn | CLAIRE | axc
197180 | Mrs J [NAME] | 2010-09-06 00:00:00 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 20 |  |  | axr
199294 | Mr [NAME] | 2010-08-19 00:00:00 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 21 |  |  | [NAME]
276547 | Mr K Gardiner | 2010-08-26 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 33 |  |  | cxn | CLAIRE
280050 | Mrs J [NAME] | 2010-08-31 00:00:00 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 35 |  |  | dxb
280525 | Mrs J Baldwin | 2010-08-20 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 36 |  |  | dzt
302332 | Mrs R Odd | 2010-08-25 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 42 |  |  | eqr
305458 | Miss H Coast | 2010-08-25 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 45 |  |  | exf
317645 | Mr A Blackmore | 2010-08-31 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 51 |  |  | ixw
322231 | [NAME] | 2010-08-24 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 55 |  |  | jxm
338222 | Mr [NAME] | 2010-08-24 00:00:00 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 71 |  |  | jzc
350643 | Mr Reynolds | 2010-08-16 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 79 |  |  | ljl
352534 | Mrs C Strong | 2010-09-03 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 82 |  |  | lxo
353370 | Mrs J Birchall | 2010-08-25 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 84 |  |  | met
357845 | Mr [NAME] | 2010-08-17 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 98 |  |  | mzp
357876 | Mr Turnbell | 2010-08-16 00:00:00 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 99 |  |  | prt
357939 | Mr [NAME] | 2010-08-17 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 104 |  |  | rjs
358131 | Mr [NAME] | 2010-08-20 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 112 |  |  | scr
358247 | [NAME] | 2010-08-23 00:00:00 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 115 |  |  | sqc
358316 | Mr Lovelady | 2010-08-25 00:00:00 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 118 |  |  | sza
358350 | Mrs C Brown | 2010-08-24 00:00:00 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 119
358603 | Mr A [NAME] | 2010-08-31 00:00:00 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 141
358701 | Mr [NAME] | 2010-09-02 00:00:00 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 147
358728 | [NAME] | 2010-09-02 00:00:00 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 148
359006 | Miss Pook | 2010-09-09 00:00:00 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 159
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 183205d1348747579-if-condition-checking-across-3-cells-0a1_fot_f_sample1-3-
Sheet: Tab2

HANDSET_MODEL | SALES_PERIOD | APP
iPhone 4 | 201104 | 4268.224664224664
iPhone 4 | 201103 | 4283.284493284493
iPhone 3GS | 201105 | 3398.412698412698
iPhone 4 | 201105 | 4295.165631469979
iPhone 4 | 201106 | 3980.428571428571
iPhone 3GS | 201104 | 3446.190476190476
iPhone 3GS | 201102 | 3446.190476190476
Spreadsheet: 878333d1725409881-cell-referencing-and-colloborating-data-sept-9-3-eba-2
Sheet: M 17

WORKCENTER | M 17 | [NAME] @ shift start |  |  |  |  |  |  |  | No Entry
Operator (name) |  | Run Clock @ End of shift |  |  |  |  |  |  |  | Entry for Operators
Shift |  | Total Runtime |  |  |  |  |  |  |  | Entry for TPL's
Break Schedule |  | Total Uptime %
Machine Hours |  | Target Uptime % | 0.65 |  | Bagmaking Scrap Form |  |  |  | [NAME] |  |  |  |  | Hour | 09:30:00
Total Bags |  | Hourly Target | 0.65 |  |  |  |  |  |  |  |  |  |  | Hour | 12:30:00
Total Scrap |  |  |  |  |  |  |  |  |  |  |  |  |  | Hour | 03:30:00
Total DT (mins)
IF WE CAN NOT OPERATE AT TARGET BPM - CONTACT TECH TO GET SUPPORT. IF TECH CAN NOT GET MACHINE TO OEPRATE AT TARGET = TIMELINE |  |  |  |  |  |  |  | DOCUMENT ALL UNPLANNED DOWNTIME, WHEN ORDER CHANGES OCCUR, WHEN JAW CHANGES OCCUR, AND ANY OTHER MISC. ISSUES/PROBLEMS
Hour | Bag Type (choose one) | Product Type (choose one) | Length | [NAME] | Target BPM | Actual BPM | Scrap (LBS) | ZAHN INK (seconds) | Hourly Total Uptime | [NAME] | Downtime/HR (mins) | Reason for Unplanned downtime/Scrap |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper
6:30 - 7:30 |  |  |  |  |  |  |  | 30 | 0.5 |  |  | maintenance
7:30 - 8:30
8:30 - 9:30
9:30 - 10:30
10:30 - 11:30
11:30 - 12:30
12:30 - 1:30
1:30 - 2:30
2:30 - 3:30
3:30 - 4:30
4:30 - 5:30
5:30 - 6:30
Comments:
Spreadsheet: 155448d1336846252-incorrect-spelling-disrupting-vlookup-vloopuk-error
Sheet: lookup

Date settled | Course | Time | [NAME] | Selection | Date | Count | Yield | Unique ID | Amt? | Name? | test
2009-11-01 00:00:00 |  |  |  | Fault | 2009-11-01 00:00:00 | 9
2009-11-01 00:00:00 |  |  |  | Galley slave | 2009-11-01 00:00:00 | 5
2009-11-01 00:00:00 |  |  |  | Killyglen | 2009-11-01 00:00:00 | 4
2009-11-01 00:00:00 |  |  |  | Listento | 2009-11-01 00:00:00 | 3
2009-11-01 00:00:00 |  |  |  | More Shennanigans | 2009-11-01 00:00:00 | 2
2009-11-01 00:00:00 |  |  |  | Party in the park | 2009-11-01 00:00:00 | 7
2009-11-01 00:00:00 |  |  |  | Sadlers star | 2009-11-01 00:00:00 | 6
2009-11-01 00:00:00 |  |  |  | Shake on it | 2009-11-01 00:00:00 | 8
2009-11-01 00:00:00 |  |  |  | Witherspoon | 2009-11-01 00:00:00 | 1
2009-11-02 00:00:00 |  |  |  | Battle cry | 2009-11-01 00:00:00 | 13
2009-11-02 00:00:00 |  |  |  | By George | 2009-11-01 00:00:00 | 15
2009-11-02 00:00:00 |  |  |  | [NAME] | 2009-11-01 00:00:00 | 14
2009-11-02 00:00:00 |  |  |  | [NAME] hook | 2009-11-01 00:00:00 | 10
2009-11-02 00:00:00 |  |  |  | Like minded | 2009-11-01 00:00:00 | 11
2009-11-02 00:00:00 |  |  |  | Parco | 2009-11-01 00:00:00 | 12
2009-11-02 00:00:00 |  |  |  | Rileyev | 2009-11-01 00:00:00 | 16
2009-11-02 00:00:00 |  |  |  | You can of course | 2009-11-01 00:00:00 | 17
2009-11-03 00:00:00 |  |  |  | Banda sea | 2009-11-01 00:00:00 | 29
2009-11-03 00:00:00 |  |  |  | Confessional | 2009-11-01 00:00:00 | 18
2009-11-03 00:00:00 |  |  |  | Cuttilon | 2009-11-01 00:00:00 | 21
2009-11-03 00:00:00 |  |  |  | [NAME] dick | 2009-11-01 00:00:00 | 27
2009-11-03 00:00:00 |  |  |  | [NAME] | 2009-11-01 00:00:00 | 28
2009-11-03 00:00:00 |  |  |  | Grisson | 2009-11-01 00:00:00 | 19
2009-11-03 00:00:00 |  |  |  | Lorship | 2009-11-01 00:00:00 | 20
2009-11-03 00:00:00 |  |  |  | Mahogany blaze | 2009-11-01 00:00:00 | 25
2009-11-03 00:00:00 |  |  |  | Moleskin | 2009-11-01 00:00:00 | 23
2009-11-03 00:00:00 |  |  |  | Red harbour | 2009-11-01 00:00:00 | 24
2009-11-03 00:00:00 |  |  |  | Royal charm | 2009-11-01 00:00:00 | 22
2009-11-03 00:00:00 |  |  |  | Ticko polos | 2009-11-01 00:00:00 | 26
2009-11-04 00:00:00 |  |  |  | Final drive | 2009-11-01 00:00:00 | 36
2009-11-04 00:00:00 |  |  |  | San histoire | 2009-11-01 00:00:00 | 32
2009-11-04 00:00:00 |  |  |  | Sarde | 2009-11-01 00:00:00 | 31
2009-11-04 00:00:00 |  |  |  | Sir [NAME] run | 2009-11-01 00:00:00 | 30
Spreadsheet: 858846d1707366882-count-numbers-greater-than-zero-in-both-cells-new-microsoft-excel-worksheet
Sheet: Sheet1

Retailer Name | PCNO 100ML | PCNO 200ML | Manual Result
Dulal Store | 2 | 1 | 1
[NAME] | 3 | 0 | 0
Alaur Store | 12 | 6 | 1
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Bipul [NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Jan store | 0 | 0 | 0
[NAME] | 2 | 12 | 1
Ongon Cosmatic | 0 | 0 | 0
Modina supar store | 1 | 6 | 1
[NAME] | 0 | 3 | 0
Nasim Brathers | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Spreadsheet: 81683d1281809873-sorting-excel-spreadsheets-sample-workbook
Sheet: Summary

ISSUE No. | PRIORITY | STATUS | Description of Issue
1 | 5 | R | R
7 | 10 | Y
6 | 5 | B
5 | 2 | LG
4 | 10 | R
3 | 5 | B
2
1
100!J1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09111965
Spreadsheet: 725789d1616861087-index-aggregate-multiple-criteria-and-columns-to-search-problem1
Sheet: Sheet2

Product | Component | Quantity |  |  |  |  | Product | Component | Country | Qty In | Qty Out | Value | Box |  |  | Label |  |  | Bag
Beverage | [Item] Tea |  |  |  |  |  | Beverage | [Item] Tea | - | 50 | - | - | Box A | 1 | 11 | [NAME] | 2 | 11 | Bag S | 8 | 11
Beverage | [Item] Juice |  |  |  |  |  | Beverage | [Item] Juice | - | 50 | - | - | Box A | 1 | 11 | [NAME] | 2 | 11 | Bag S | 8 | 11
Beverage | Box A |  |  |  |  |  | Flower | [Item] Tulip | - | 100 | - | - | [NAME] | 2 | 12 | [NAME] | 1 | 12 | Bag M | 5 | 12
Beverage | [NAME] |  |  |  |  |  | Furniture | [Item] Table | - | 75 | - | - | Box C | 3 | 24 | [NAME] | 10 | 24 | Bag L | 6 | 24
Beverage | Bag S |  |  |  |  |  | Furniture | [Item] Tea | - | 80 | - | - | Box C | 3 | 24 | [NAME] | 10 | 24 | Bag L | 6 | 24
Food | [Item] Bacon |  |  |  |  |  | Furniture | [Item] Chair | - | 150 | - | - | Box C | 3 | 24 | [NAME] | 10 | 24 | Bag L | 6 | 24
Food | [Item] Egg |  |  |  |  |  | Furniture | [Item] Couch | - | 76 | - | - | Box C | 3 | 24 | [NAME] | 10 | 24 | Bag L | 6 | 24
Food | Box D |  |  |  |  |  | Food | [Item] Bacon | - | 188 | - | - | Box D | 4 | 36 | [NAME] | 8 | 36 | Bag XL | 11 | 36
Food | [NAME] |  |  |  |  |  | Food | [Item] Egg | - | 125 | - | - | Box D | 4 | 36 | [NAME] | 8 | 36 | Bag XL | 11 | 36
Food | Bag XL |  |  |  |  |  | Pets | [Item] Cat | - | 304 | - | - | Box A | 5 | 12 | [NAME] | 4 | 12 | Bag M | 3 | 12
Flower | [Item] Tulip
Flower | [NAME]
Flower | [NAME]
Flower | Bag M
Furniture | [Item] Table
Furniture | [Item] Chair
Furniture | [Item] Couch
Furniture | Box C
Furniture | [NAME]
Furniture | Bag L
Furniture | [Item] Tea
Furniture | [Item] Chair
Furniture | [Item] Couch
Furniture | Box C
Furniture | [NAME]
Furniture | Bag L