tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807870-transpose-a-table-into-column-vstack-tocol-reversed
Sheet: sample1

 | [NAME] |  |  |  |  | [NAME] | Ibrahim | [NAME] | [NAME] | Isobelle
 | [NAME] |  |  |  |  | [NAME] | Kirsten | Edna | [NAME] | Lina
 | Alistair |  |  |  |  | Callum | Agnes | Maksymilian | Shannon | [NAME]
 | Barney |  |  |  |  | Hiba | Barney | Alistair | [NAME] | [NAME]
 | Hiba |  |  |  |  |  |  |  |  |  |  | Helper Array below:
 | [NAME] |  |  |  |  | [NAME] | Ibrhim | [NAME] | [NAME] | Isobelle
 | Shannon |  |  |  |  | [NAME] | Kirsten | Edna | [NAME] | Lina
 | Maksymilian |  |  |  |  | Callum | Agnes | Marksymillan | Shannon | [NAME]
 | Agnes |  |  |  |  | Hiba | Barney | Alistair | [NAME] | [NAME]
 | Callum
 | Lina
 | [NAME] |  |  |  |  | [NAME]
 | Edna |  |  |  |  | Alistair
 | Kirsten |  |  |  |  | Barney
 | [NAME] |  |  |  |  | Hiba
 | Isobelle |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  | Shannon
 | [NAME] |  |  |  |  | Marksymillan
 | Ibrahim |  |  |  |  | Agnes
 | [NAME] |  |  |  |  | Callum
 |  |  |  |  |  | Lina
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Edna
 |  |  |  |  |  | Kirsten
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Isobelle
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Ibrhim
 |  |  |  |  |  | [NAME]
Spreadsheet: 539561d1506243116-golf-formulas-help-please-golfpayouts
Sheet: Sheet1

POT | 60
 |  |  |  |  | NEXT WEEK - POINTS TO BE PULLED
 | 2017-09-18 00:00:00 |  |  |  |  |  |  |  |  | <-- Dates calculated from B4.
RAY | 28
STAN | 29
WAYNE | 16
LYNN | 28
MOE | 22
CHRIS | 22
[NAME] | 28
HARRY | 23
PETE | 28
EDD | 9
[NAME] | 9
STEVE | 22
 |  |  |  |  | ACTUAL POINTS PULLED
 | 28
 | 10
 | 27
 | 28
 | 24
 | 26
 | 7
 | 16
 | 16
 | 30
 |  |  |  |  | MONEY WON
# OF PLAYERS
 | if(b122>=8,
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 45

कार्यक्रम PROGRAM |  |  | प्रलेखन [NAME] | PROG CODE
 |  |  |  | IT 1705
तर्षर् समूह/SUBJECT GROUP |  |  | CREDIT MONITORING, LEGAL & RECOVERY
उद्देश्य/OBJECTIVE |  |  | EQUIPPING FOR PERFECT DOCUMENTATION
लतक्षि समूह/TARGET GROUP |  |  | MIXED
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Need & Importance of documentation
 | II | Documentation for different types of borrowers
 | III | Legal aspects of banking with reference to Stamp Act, Companies Act and Charge Registration vis a vis Impact of its non-compliance.
 | IV | Legal aspects of banking with reference to B R Act, NI Act & Partnership Act vis a vis Impact of its non-compliance.
Day 2 | I | Legal Aspects of Mortgage in Specific Registered Mortgage; Equitable Mortgage. DCCO extension, CERSAI Creation, Obtention of EC; Creation of Charge, ROC, ECGC, CGTMSE Coverage, Claim etc.
 | II | Intricacies of LSR, Importance of 13 years / 30-year title search, important sections of LSR for mortgage and enforceability, Chain of documents - types and importance, search conducted in sub registrar office, Importance of Certified copies of title deeds in LSR. Concept of land locked properties. Cases where bank lost its right on the property due to defective title
 | III | E- Documentation, Letter of Revival; AOD; Limitation Act and its implications.
 | IV | Case Studies on preparation of loan documents (Agriculture, MSME, OCC, Retail loan etc.) and attending inspection observations and valediction
Day 3 | I | Intricacies of valuation, valuation methods, types of valuer and valuations, valuation report format explanation. Areas where overvaluation is given by the valuers. Importance of chartered engineer's certificate. Difference in valuation done by panel valuer and chartered engineer.
 | II | Practical cases where overvaluation / undervaluation has played adverse role in bank's safety of advances.
 | III | Overview of Asset and Liability Products of the Bank
 | IV | Business Ethics and Value System & Valediction
Spreadsheet: 82204d1282221695-vlookup-values-hlookup
Sheet: Sheet1

Weights | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5
Shipping Cost | 20000 | 25700 | 33500 | 44500 | 55625 | 66750 | 77875 | 89000
Spreadsheet: 698670d1602111373-add-a-condition-to-an-if-formula-ef-4015-components-register-1-
Sheet: EF 4015 register

Components | Product | Component Lot Number | Released from production | Lot QTY | Qty used | Qty reconciliation | Components in Stock
 |  | 1 | Yes | 100 | 50
 |  | 2 | No
 |  | 3 | Yes | 100 | 25
 |  | 4 | Yes
 |  | 5 | Yes | 100 | 100
Spreadsheet: 159640d1338795261-copy-and-update-problem-in-mastersheet-to-other-worksheets-request-handling-partial
Sheet: MAIN

Name | Department | Location | Designation | Comp./ID # | Supervisor | Ref # | Request Date | Equipmment / Access Control | Remarks | Status
 |  |  | /Job lvl |  | /Manager |  |  | Description
[NAME] | ICTD | field | 2 | 900333 | [NAME] | 96773 | [NAME] | computer set
Spreadsheet: fa44617f-ac71-4e13-92b8-aa2538d8d910
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4461 | 15348 | Stephen | [NAME] | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:17:12
4461 | 10171 | [NAME] | Bright | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:18:18
4461 | 21375 | Yves | Cordier | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | [NAME]
Spreadsheet: 858248d1706978039-median-if-formula-query-please-sample-spreadsheet
Sheet: Sheet1

WEEK | DAY | DATE | MONTH | K NUMBER | CONS | OPERATION | DISCHARGED | LOS |  |  | Month | Mean LOS | Median LOS
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K0418529 | HEM | [NAME] | 2023-08-10 00:00:00 | 1 |  |  | 2023-08-01 00:00:00
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K1039925 | HEM | [NAME] | 2023-08-10 00:00:00 | 1 |  |  | 2023-09-01 00:00:00
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K0195870 | HEM | [NAME] | 2023-08-10 00:00:00 | 1 |  |  | 2023-10-01 00:00:00
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K3573430 | DMH | THR | 2023-08-11 00:00:00 | 2 |  |  | 2023-11-01 00:00:00
6 | Thursday | 2023-09-07 00:00:00 | 2023-09-01 00:00:00 | [NAME] | BVB | [NAME] | 2023-09-10 00:00:00 | 2
6 | Friday | 2023-09-08 00:00:00 | 2023-09-01 00:00:00 | K0171573 | RB | [NAME] | 2023-09-08 00:00:00 | 0
6 | Friday | 2023-09-08 00:00:00 | 2023-09-01 00:00:00 | K0016993 | RB | UKR | 2023-09-09 00:00:00 | 1
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K3137900 | ARM | THR | 2023-10-14 00:00:00
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K0105403 | BVB | [NAME] | 2023-10-08 00:00:00 | 2
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K0939239 | BVB | THR | 2023-10-08 00:00:00 | 2
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K1514953 | BVB | [NAME] | 2023-10-10 00:00:00 | 4
11 | Monday | 2023-10-09 00:00:00 | 2023-10-01 00:00:00 | K0761898 | RB | [NAME] | 2023-10-10 00:00:00 | 1
11 | Monday | 2023-10-09 00:00:00 | 2023-10-01 00:00:00 | K1167521 | RB | THR | 2023-10-10 00:00:00 | 1
11 | Monday | 2023-10-09 00:00:00 | 2023-10-01 00:00:00 | K1592087 | RB | [NAME] | 2023-10-10 00:00:00 | 1
14 | Friday | 2023-11-03 00:00:00 | 2023-11-01 00:00:00 | K0585157 | ARM | THR | 2023-11-04 00:00:00 | 1
14 | Friday | 2023-11-03 00:00:00 | 2023-11-01 00:00:00 | K1052434 | BVB | [NAME] | 2023-11-04 00:00:00 | 1
14 | Friday | 2023-11-03 00:00:00 | 1932-11-01 00:00:00 | K0426464 | BVB | [NAME] | 2023-11-10 00:00:00 | 7
14 | Friday | 2023-11-03 00:00:00 | 2023-11-01 00:00:00 | K0210156 | ARM | THR | 2023-11-05 00:00:00 | 2
15 | Monday | 2023-11-06 00:00:00 | 2023-11-01 00:00:00 | K0851529 | APB | THR | 2023-11-08 00:00:00 | 2
Spreadsheet: 56551d1256736923-count-repeated-hours-book1
Sheet: Sheet1

 | Count: | 6 x 4:xx hours
07:00:00 | 1
07:43:00 | 2
04:55:00 | 5
07:22:00 | 1
04:55:00 | 5
04:55:00 | 5
04:55:00 | 5
07:11:00 | 1
07:43:00 | 2
04:55:00 | 5
06:22:00 | 1
04:21:00 | 1
07:04:00 | 1
07:19:00 | 1
07:42:00 | 1
07:33:00 | 1
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 135991d1326357962-excel-2007-want-to-use-sumproduct-with-min-function-sumprduct-and-min-max
Sheet: Data1

Apps | Service
App1 | Serv1
App2 | Serv2
App3 | Serv3
App4
App5
App6
App7
App8
App9
[NAME]
App11
App12
[NAME]
App14
App15
App16
App17
App18
App19
App20
App21
App22
Spreadsheet: 853401d1703260870-formula-for-pro-rating-given-values-pto-calculator
Sheet: Employee PTO Load

Name | Anniversary Date | 2024 PTO
[NAME] | 2014-04-20 00:00:00
[NAME] | 2014-10-31 00:00:00
Name | Anniversary Date | Old Entitlement | New Entitlement | 2024 Calculation
[NAME] | 2014-04-20 00:00:00 | 26 | 31
[NAME] | 2014-10-31 00:00:00 | 26 | 31 |  |  | 26.5
MANUAL CALCULATION
PARAMETERS
<3 years | 16 Days
3-5 years | 21 Days
5-10 years | 26 Days
10+ years | 31 Days
1. Time must be used in 0.5 increments, and is always rounded DOWN
2. An employee accrues time MONTHLY
For example, if an employee has a start date of April 14th, 2014 - he will not have any accrual for April.
For employees who are terminated, if they leave mid-month, they do not accrue time for the current month.
Spreadsheet: 114902d1310577714-excel-2007-vlookup-or-something-similar-finding-a-date-later-than-a-previous-date-cp-example
Sheet: Cost Evaluation

Trailer Number | Date Shipped | Date Received | Fiscal Week | Weight | Pallets | [NAME] | Dray | Fuel | Total | Reference PO
 | "Date Received" represented in "Inbound Log" sheet
 | All other columns pulled from "Intermodal" sheet except Fiscal Week
 | Fiscal Week pulling from [NAME] (OK)
 | Date Shipped | = | Intermodal!B2
 | Date Received | = | Inbound Log'!B2
 | Fiscal Week | = | IF(ISNA(VLOOKUP(C2,References!A:B,2,0)),"",VLOOKUP(C2,References!A:B,2,0))
 | Weight | = | Intermodal!J2
 | Pallets | = | Intermodal!K2
 | [NAME] | = | Intermodal!L2
 | Dray | = | SUM(Intermodal!M2:N2)
 | Fuel | = | Intermodal!Q2
 | Total | = | SUM(G2:I2)
 | Reference PO | = | Intermodal!T2
Spreadsheet: 33990e1e-2cce-4598-9e0c-11b91f98b6c8
Sheet: Sheet1

City of [NAME], Commercial Projects under review, approved and under construction as of October 18, 2012
During the past year 74% of commercial projects have been reviewed within 10 days or less,
with an average review time of 7.3 days.
Project Name |  |  | Project Address |  | Brief Description | Date Plans | Date Plans | Date Under
 |  |  |  |  |  | Submitted | Approved | Construction
 |  |  |  |  |  | For Review
COMMERCIAL PROJECTS
Main Street Commons |  |  | 3610 N Main |  | 4 story bldg for seniors | 2011-12-20 00:00:00 | 2012-05-03 00:00:00 | 2012-05-14 00:00:00
Alliance Geotechnical |  |  | 404 [NAME] |  | Office Building | 2011-09-19 00:00:00 | 2011-12-13 00:00:00 | 2012-03-16 00:00:00
[NAME] |  |  | [NAME] |  | Manufacture of Windows | 2012-03-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-14 00:00:00
McCoy's Hardware Site |  |  | 3409 N  Main |  | [NAME] | 2012-03-01 00:00:00 | 2012-06-15 00:00:00 | 2012-06-18 00:00:00
McCoy's Hardware Bldg |  |  | 3409 N  Main |  | [NAME] | 2012-06-25 00:00:00 | 2012-08-16 00:00:00 | 2012-08-30 00:00:00
Gemini Accessory Building |  |  | 102 Wagner Way |  | Utility Bldg | 2012-02-28 00:00:00
Masonic Lodge Expansion |  |  | 2707 [NAME] Dr |  | Expansion | 2012-01-03 00:00:00 | 2012-01-09 00:00:00 | 2012-02-01 00:00:00
[NAME] |  |  | N Main |  | Fast Food Store | 2010-11-01 00:00:00 | 2010-11-11 00:00:00
Wal Mart Remodel |  |  | N Main |  | [NAME] | 2011-10-11 00:00:00 | 2011-11-12 00:00:00 | 2012-02-15 00:00:00 | Complete
HEB Remodel |  |  | N Main |  | [NAME] | 2011-08-11 00:00:00 | 2011-10-12 00:00:00 | 2011-11-15 00:00:00 | Complete
First Assembly of God |  |  | [NAME] |  | New Church | 2008-01-07 00:00:00 | 2012-05-25 00:00:00 | 2012-08-06 00:00:00
El Vaquerto Addition |  |  | 221 W 4th |  | Addition to existing restaurant | 2012-02-27 00:00:00
Frills |  |  | 201 W 4th |  | Remodel commercial for rest. | 2012-03-23 00:00:00 | 2012-04-30 00:00:00 | 2012-05-14 00:00:00
[NAME] |  |  | [NAME]. [NAME]/CGP |  | Office Bldg | 2010-10-11 00:00:00 | 2011-04-07 00:00:00
K of C Barbeque Pits Addition |  |  | 2201 E 4th |  | Addition | 2012-04-24 00:00:00 | 2012-06-13 00:00:00
Beveridge Phase 2 |  |  | 1102 E 4th |  | New Commercial | 2012-06-05 00:00:00 | 2012-06-12 00:00:00 | 2012-06-18 00:00:00
Round Rock Refuse |  |  | 9979 Chandler Road |  | New Commercial | 2012-07-09 00:00:00 | 2012-08-07 00:00:00
Traci Qualls Pavilion |  |  | E 4th St |  | Add Pavilion | 2012-08-03 00:00:00 | 2012-08-13 00:00:00 | 2012-08-17 00:00:00 | Complete
[NAME] |  |  | W 2nd St |  | New Commercial
Car Wash |  |  | N Main St |  | New Commercial
Big Industrial Remodel |  |  | [NAME] |  | Remodel commercial
Community Recreation Center |  |  | Public Building |  |  | 2012-09-26 00:00:00
Blue Bonnet Remodel |  |  | 404 [NAME] |  | Remodel commercial | 2012-09-17 00:00:00
The above denotes most recent plan version.  Comment review time is shorter than plan approval  date.
Plans may include Site Plan, Building Plans, Foundation Plans, and Fire Protection Plans
Spreadsheet: 46385d1245259652-if-option-using-text-ang-numbers-688011
Sheet: Sheet1

b | 3 | 105
a | 1 | 100
a | 2 | 101
a | 3 | 102
b | 1 | 103
b | 2 | 104
b | 3 | 105
c | 1 | 106
c | 2 | 107
c | 3 | 108
Spreadsheet: 764886d1643054174-syntax-to-blank-0-from-blank-referenced-cell-hbsqa_spreadsheets-blanking-referenced-cells
Sheet: 3-Ongoing

 |  |  | Ongoing |  | Baseline |  |  |  |  |  |  |  | System # |  |  | System Location |  | Year
 |  |  | A | B | A | B |  | Subject:
 | Mean:
 | Standard Deviation:
 | Covariance:
 | N:
Spreadsheet: 274665d1383175049-lookup-on-highest-value-lookup-on-highest-value
Sheet: Sheet1

Service Provider | Location | wrvus
[NAME], [NAME] D | PMI Madrona Pediatrics | 3215.919999999995
ANGELOW, ANGEL | PMI [NAME] | 1453.34 | <<--pull in PMI San Pedro
ANGELOW, ANGEL | PMI Vasek Polak Health Clinic | 19.91
ANGELOW, ANGEL | PMI Urgent Care Del Amo | 427.78
BEZEMA, ERIK | PMI Advanced Medical Care Santa Clarita | 2970.790000000013
BOROVAY, [NAME] | PMI Madrona | 5094.650000000011 | <<--pull in PMI Madrona
BOROVAY, [NAME] | PMI Urgent Care Del Amo | 783.6999999999999
BOROVAY, [NAME] | PMI Madrona Pediatrics | 9.36
Expected Results
[NAME], [NAME] D | PMI Madrona Pediatrics
ANGELOW, ANGEL | PMI [NAME]
BEZEMA, ERIK | PMI Advanced Medical Care Santa Clarita
BOROVAY, [NAME] | PMI Madrona
Spreadsheet: 690033d1596812267-help-with-forecasting-formula-for-a-retailer-i-am-stumped-please-help-example-for-phasing-help_v2
Sheet: Dashboard example

Key Forecast | Cateogry | Type | Group | Gender | Start week* | RID MERCH | [NAME] | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5
 | Footwear | ENDUR | SHOES | U | 38 | 2020-09-01 00:00:00 | 1300
 | Socks | Running Socks | SOCKS | U | 41 | 2020-07-15 00:00:00 | 1154
Spreadsheet: 485186d1476769410-sum-an-index-sum-an-index
Sheet: Sheet1

 | RANDOM TEXT WOOP WOOP
 | Agent  1132 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 21h26
 | [NAME] Received |  | 43 |  | Total Queue Call Time |  |  | 02h36
 | Direct Calls received |  | 5 |  | Total Direct Call Time |  |  | 01:59
 | Outbound Calls Made |  | 139 |  | Total Outbound Call Time |  |  | 02h46
 | Internal Calls Made |  | 0 |  | Total Internal Call Time |  |  | 00:00
 | Agent  1132 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 21h26
 | [NAME] Received |  | 67 |  | Total Queue Call Time |  |  | 02h36
 | Direct Calls received |  | 5 |  | Total Direct Call Time |  |  | 01:59
 | Outbound Calls Made |  | 139 |  | Total Outbound Call Time |  |  | 02h46
 | Agent  1177 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 34h10
 | [NAME] Received |  | 68 |  | Total Queue Call Time |  |  | 10h00
 | Direct Calls received |  | 11 |  | Total Direct Call Time |  |  | 03:04
 | Outbound Calls Made |  | 199 |  | Total Outbound Call Time |  |  | 07h05
 | Agent  1177 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 34h10
 | [NAME] Received |  | 32 |  | Total Queue Call Time |  |  | 10h00
 | Direct Calls received |  | 11 |  | Total Direct Call Time |  |  | 03:04
 | Outbound Calls Made |  | 199 |  | Total Outbound Call Time |  |  | 07h05
Spreadsheet: 5a629878-0097-4d9e-b550-f80d99e5ca02
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
RWEED | Test | RWEED | [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
RWEED | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RWEED | Result | RWEED | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 11194-8
Spreadsheet: darrell_schoolcraft__7843__Griffith901
Sheet: DETM-Receipts

 | Citizens Arizona Gas |  |  | Customer: | Duke Energy Trading & Marketing
 | Scheduled Receipts
 |  |  |  | Month Of:  9-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Transwestern Lateral |  |  |  |  |  |  |  |  |  |  |  |  |  |  | El Paso Lateral
 |  |  |  |  |  |  |  |  |  |  |  |  | Daily | Month |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily | Month |  | Daily | Month
 |  |  |  |  |  |  |  |  |  |  |  |  | Total | To-Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | To-Date |  | Total | To-Date
Day | Agr. # | Dth | Arg. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Dth | Dth |  | Agr. # | Dth | Arg. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Dth | Dth |  | Dth | Dth
1 | 20248 | 20000 | 26372 | 25000 | 26520 | 15000 | 26758 | 15000
 | 20248 | 40000 | 26372 | 25000 | 26520 | 15000 | 26758 | 15000
 | 20248 | 10000 | 26372 | 7621 | 26520 | 15000 | 26758 | 5629
 | 26520 | 5000
 | 26372 | 17991 | 20248 | 17000
 | 26372 | 22995 | 26520 | 18843 | 26758 | 18065
 | 26372 | 11697 | 26520 | 18527 | 26758 | 9854
 | 26372 | 12055 | 26520 | 18859 | 26758 | 9508
 | 26520 | 19593 | 26758 | 18500
 | 26372 | 24980 | 26520 | 19900
 | 26372 | 8114 | 26520 | 19518 | 20248 | -19564
 | 26372 | 6446
 | 26372 | 14310 | 20248 | 33558
 | 26372 | 25000 | 20248 | 30000
 | 26372 | 22790 | 26520 | 19917 | 26758 | 18801 | 27568 | 10000
 | 26372 | 25000 | 26520 | 19912 | 26758 | 25000 | 27568 | 10000
 | 26372 | 13089 | 26520 | 19862 | 26758 | 9961 | 27568 | 10000
 | 26372 | 10000 | 26520 | 19918 | 27568 | 10000
 | 26520 | 19917 | 26758 | 25000 | 27568 | 10000
 | 26372 | 8333 | 26520 | 20000 | 26758 | 8333 | 27568 | 10000
Total
Spreadsheet: 667847d1584528944-automating-supply-orders-frustration03
Sheet: INPUT SHEET

VENDER NUMBER | NUMBER OF ITEMS
I WILL SCAN BAR CODE TO THIS CELL THEN I NEED TO MOVE TO THE NEXT CELL RIGHT | I WILL SCAN THE BAR CODE FOR THE # OF ITEMS THAT I NEED HERE THEN I NEED TO SEARCH THE INVENTORY SHEET, COULUM E,  FOR THE # [NAME], IF FOUND I NEED TO COPY THE ROW IT IS IN AND PUT IT IN THE FIRST EMPTY ROW IN ORDER FORM. THEN THE NUMBER IN B2 NEEDS TO BE COPIED AND PUT INTO THE  COROSPONDING CELL IN COLUM F OF THE ORDER FORM. IF NO NUMBER FROM A3 IS FOUND IN THE INVENTORY SHEET THEN PUT THAT # INTO THE NEXT EMPTY CELL IN COLUMN E OF THE ORDER FORM SHEET AND THE QUANITY IN COLUMN B SHOULD GO IN THE E COLUMN OF THE CORESPONDING ROW. RINSE AND REPEAT. i HAVE TRIED TO MAKE AN EXAMPLE BELOW.
22222 | 7 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
44444 | 3 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
66666 | 1 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
XX12345XX | 1 | IF THE VENDER # CAN NOT BE FOUND COPY THE DUMMY ROW IN INVENTORY, AND PASTE IT TO THE NEXT ROW ON THE ORDER FORM AND PUT THE NUMBER OF ITEMS IN F COLUMN OF THE ORDER FORM
33333 | 25 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
55555 | 1 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
77777 | 2 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
88888 | 3 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
99999 | 4 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
11111 | 5 | FOUND 22222 ON THE INVENTORY AND PLACED THE WHOLE ROW ON ORDER FORM. THE # IN COLUMN B THIS ROW GOES TO ORDER FORM COLUMN F OF THE SAME ROW.
Spreadsheet: 189688d1351281860-index-match-with-multiple-criteria-across-both-rows-and-columns-george_k_871673_26oct12_01
Sheet: Summary Page

Product | Warranty Status | Product Age (Yrs) | World Region | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
Product A | In warranty | 5-9 | North America
Product A | Out of Warranty | 5-9 | North America
Product B | In warranty | 5-9 | North America
Product B | Out of Warranty | 5-9 | North America
Product C | In warranty | 5-9 | North America
Product C | Out of Warranty | 5-9 | North America
Spreadsheet: 92299d1291906964-formula-to-transfer-hours-to-timeline-workplan-example
Sheet: Our Schedule

Monday
Employee | 06:00:00 | 06:15:00 | 06:30:00 | 06:45:00 | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00 | 23:15:00 | 23:30:00 | 23:45:00 | 1900-01-01 00:00:00
A
B
C
D
E