tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 03481cb9-9f77-4a81-9d3d-5941d56e02d3
Sheet: Sheet1

Training Matrix -- Expected New Leader [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Position | Position Code | Youth Protection within 90 days*** | Venturing Youth Protection within 90 days*** | This is [NAME] | Fast Start Training for your position** | COR Training | Cub Leader [NAME] | Introduction to Outdoor Leader Skills | [NAME] and ASM Specific | Troop (Team) Committee Challenge | Merit Badge Counselor | Varsity Specific | Venturing Specific (includes Venturing Youth Protection) | Sea Scout Officers Specialized Training | Commissioner [NAME] | Trainer's EDGE
Pack Committee | CC, MC | X |  | X | X |  | X
Cubmaster | CM | X |  | X | X |  | X
Assistant [NAME] | CA | X |  | X | X |  | X
[NAME] Leader | WL | X |  | X | X |  | X
Assistant [NAME] Leader | WA | X |  | X | X |  | X
Den Leader | DL | X |  | X | X |  | X
Assistant [NAME] Leader | DA | X |  | X | X |  | X
Tiger Cub Den Leader | TL | X |  | X | X |  | X
Pack Trainer | PT | X |  | X | X |  |  |  |  |  |  |  |  |  |  | X
ScoutParent Unit Coordinator - Cubs | PC | X |  | X | X |  | X
Lone Cub Scout Friend and Counselor | 88 | X |  |  | X |  | X
Troop Committee | CC, MC | X |  | X | X |  |  |  |  | X
[NAME] | SM | X |  | X | X |  |  | X | X
Assistant [NAME] | SA | X |  | X | X |  |  | X | X
ScoutParent Unit Coordinator - Scouts | PC | X |  | X | X |  |  |  |  | X
[NAME] and Counselor | 96 | X |  |  | X |  |  | X | X
Merit Badge Counselor | 42 | X |  |  |  |  |  |  |  |  | X
Team Committee | CC, MC | X |  | X | X |  |  |  |  | X
Varsity Scout Coach | VC | X |  | X | X |  |  | X |  |  |  | X
Assistant Varsity Scout Coach | VA | X |  | X | X |  |  | X |  |  |  | X
ScoutParent Unit Coordinator - Varsity | PC | X |  | X | X |  |  |  |  | X
Crew Committee | CC, MC |  | X | X |  |  |  |  |  |  |  |  | X
ScoutParent Unit Coordinator - Crew/Ship | PC |  | X | X |  |  |  |  |  |  |  |  | X
Crew Advisor | NL |  | X | X | X |  |  |  |  |  |  |  | X
Crew Associate Advisor |  |  | X | X | X |  |  |  |  |  |  |  | X
Skipper | SK |  | X | X |  |  |  |  |  |  |  |  | X | X
Mate | MT |  | X | X |  |  |  |  |  |  |  |  | X | X
Ship Committee | CC, MC |  | X | X |  |  |  |  |  |  |  |  | X | X
Commissioners | 80, 81, 82, 83 | X |  |  | X |  |  |  |  |  |  |  |  |  | X
Chartered Organization Representative | CR | X |  |  |  | X
** This course should be taken immediately after you register and before you begin activities
*** All volunteers are expected to complete Youth Protection training. It is available online on the Web site www.scouting.org and each local council provides training to leaders on a regular basis throughout the year. As a volunteer, you are expected to complete the training within 90 days of assuming a leadership position.
Created by [NAME] (bnelson45<at>hotmail.com) V. 1
Improved by [NAME]
Spreadsheet: 544252d1508833807-help-trying-to-link-values-from-one-workbook-to-another-formulas-for-dimensions-of-shited-spur-gears-samp
Sheet: Gear 0013 - Gear 2000

POSITIVE SHIFTED SPUR GEAR |  |  |  |  |  | MAX ADDENDUM |  | MIN # OF TEETH
SYMBOL | TO FIND | FORMULA | EXAMPLE |  |  | HA1 | HA2 | Z1 | [NAME]
 |  |  | PINION | GEAR
M | MODULE
α | PRESSURE ANGLE
Z1 , [NAME] | NUMBER OF TEETH
X1 , X2 | COEFFICIENT OF PROFILE SHIFT |  | 0.05
Inv αW | INVOLUTE FUNCTION αw | 2 TAN ( α ) [ ( x1 + x2 ) / ( z1 + z2 ) ] + INV ( α )
αw | WORKING PRESSURE ANGLE | [NAME] ( INV αw )        (ITERATIVE 100)
Y | CENTER DISTANCE INCREMENT FACTOR | [ ( Z1 + Z2 ) / 2 ] * [ ( COS ( α ) / COS ( αw ) ) - 1 ]
AX | CENTER DISTANCE | [ ( ( Z1 + Z2 ) / 2 ) + Y ] * M
DP | PITCH DIAMETER | Z * M
DB | BASE DIAMETER | Dp  * COS ( α )
DW | WORKING PITCH DIAMETER | DB / COS ( αw )
HA1 | ADDENDUM | ( 1 + Y - X2 ) * M |  |  |  | MEASURED VALUES
HA2 |  | ( 1 + Y - X1 ) * M
HWA | WHOLE DEPTH | [ 2.25 + Y - ( X1 + X2 ) ] * M |  |  |  | DA | ΔDA | DF | DFΔ
DA | OUTSIDE DIAMETER | DP + ( 2 * HA ) |  |  |  | 159.75 |  | 145
DF | ROOT DIAMETER | DA - ( 2 * HWA ) |  |  |  | 193.125 |  | 176.25
Adjusted Center Distance Calculations
AA | ADJUSTED CENTER DISTANCE | ADJUSTED TO 0.50MM INCREMENT
[NAME] | ADJUSTED CENTER DISTANCE INCREMENT FACTOR | ( AA / M ) - [ ( Z1 + Z2 ) / 2 ]
αWA | ADJUSTED WORKING PRESSURE ANGLE | cos -1 [ ( ( Z1 + Z2 ) cos ( α ) ) / ( ( 2 * YA ) + [NAME] ) ]
XA1 + XA2 | ADJUSTED COEFFICIENT OF PROFILE SHIFT | [ ( Z1 + Z2 ) * ( INV ( αwa ) - INV ( α ) ) ] / ( 2 TAN ( α ) )
Δ XAA | COEFFICIENT OF PROFILE SHIFT FACTOR | (XA1 + XA2) / (X1 + X2)
XA1, XA2 | ADJUSTED COEFFICIENT OF PROFILE SHIFT | XAA * X(1,2)
DB | ADJUSTED BASE DIAMETER | Dp  * COS ( α )
DAWP | ADJUSTED WORKING PITCH DIAMETER | DB / COS ( αWA )
HAA1 | ADJUSTED ADDENDUM | ( 1 + YA - XA2 ) * M
HAA2 |  | ( 1 + YA - XA1 ) * M
HWAA | ADJUSTED WHOLE DEPTH | [ 2.25 + YA - ( XA1 + XA2 ) ] * M
DAA | ADJUSTED OUTSIDE DIAMETER | DAWP + ( 2 * HAA )
DAF | ADJUSTED ROOT DIAMETER | DAA - ( 2 * HWAA )
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 11969
2 | 11965
3 | 4507
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
2001-08-31 00:00:00 |  |  | 450250
2001-09-03 00:00:00
CBS Volume
 |  |  | 50872
Spreadsheet: 537657d1505218528-power-query-date-time-pomaster
Sheet: OPEN PO

 | Last updated from E2 Export
Vendor Desc | PO Num | Date Ent | PO Due Date | Entered By | Job No | Customer | Job Due Date | Qty | [NAME] | Part No | Part Desc | Comments
PTI INDUSTRIES, INC. | 30274 | 2017-01-03 00:00:00 | 2017-01-10 00:00:00 | JKULAK | 22412-16 | KAMAN AEROSP | 2017-11-07 00:00:00 | 2 | 0 | K974208-007
PTI INDUSTRIES, INC. | 30274 | 2017-01-03 00:00:00 | 2017-01-10 00:00:00 | JKULAK | 22412-20 | KAMAN AEROSP | 2017-11-07 00:00:00 | 2 | 0 | K974208-007
Techmetals Incorporated | 30418 | 2017-02-03 00:00:00 | 2017-02-13 00:00:00 | MSMITH | 23756-01 | AEROSOURCE, | 2016-10-31 00:00:00 | 60 | 0 | 1013-008-101-0 | PIN-LINK
Techmetals Incorporated | 30418 | 2017-02-03 00:00:00 | 2017-02-13 00:00:00 | MSMITH | 23756-01 | AEROSOURCE, | 2016-10-31 00:00:00 | 60 | 0 | 1013-008-101-0 | PIN-LINK
X-Ray Industries | 30546 | 2017-02-08 00:00:00 | 2017-02-27 00:00:00 | JKULAK | 24405-01 | JPL ACCOUNTS | 2017-02-28 00:00:00 | 29 | 0 | 10453595-1 | SPRING RET WASHER, RTG ADAPTER
X-Ray Industries | 30546 | 2017-02-08 00:00:00 | 2017-02-27 00:00:00 | JKULAK | 24405-01 | JPL ACCOUNTS | 2017-02-28 00:00:00 | 29 | 0 | 10453595-1 | SPRING RET WASHER, RTG ADAPTER
ALUMINUM FINISHING CO. | 30849 | 2017-03-23 00:00:00 | 2017-03-31 00:00:00 | KBILLIE | 24654-01 | SIKORSKY AIR | 2017-04-12 00:00:00 | 3 | 0 | T0695-00011-102 | Sensor Bracket
American Metaseal of CT | 31010 | 2017-04-12 00:00:00 | 2017-04-18 00:00:00 | JKULAK | 22412-01 | KAMAN AEROSP | 2017-12-20 00:00:00 | 2 | 0 | K974208-007
American Metaseal of CT | 31010 | 2017-04-12 00:00:00 | 2017-04-18 00:00:00 | JKULAK | 22412-02 | KAMAN AEROSP | 2017-12-20 00:00:00 | 2 | 0 | K974208-007
American Metaseal of CT | 31010 | 2017-04-12 00:00:00 | 2017-04-18 00:00:00 | JKULAK | 22412-01 | KAMAN AEROSP | 2017-12-20 00:00:00 | 2 | 0 | K974208-007
American Metaseal of CT | 31010 | 2017-04-12 00:00:00 | 2017-04-18 00:00:00 | JKULAK | 22412-02 | KAMAN AEROSP | 2017-12-20 00:00:00 | 2 | 0 | K974208-007
AMERICAN-URETHANE, INC. | 31072 | 2016-12-05 00:00:00 | 2017-01-06 00:00:00 | AFOIW | 24184-01 | PUROLATOR FI | 2017-01-09 00:00:00 | 50 | 0 | 6701-10-001 | KNOCKOUT PAD SMALL
AMERICAN-URETHANE, INC. | 31072 | 2016-12-05 00:00:00 | 2017-01-06 00:00:00 | AFOIW | 24184-01 | PUROLATOR FI | 2017-01-09 00:00:00 | 50 | 0 | 6701-10-001 | KNOCKOUT PAD SMALL
Spreadsheet: 01cacebc-dac0-4611-8e37-5252e5132da9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 42. OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number: $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413806K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413807L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413808R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413809T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413810A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413811C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413812F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413813J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413814K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413815L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413816R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 727833d1618141890-import-data-in-a-cell-to-another-workbook-automatic-update-by-date-asq-meal-plan-daily-revenue-042021
Sheet: KOR

Date |  | Room  Available for ASQ |  | Breakfast | Lunch | Dinner | Cost
 |  |  | RM Occupied | Actual Guest (Pax) | Actual Guest (Pax) | Actual Guest (Pax) | Food Cost 450 Breakfast (150) [NAME] (150) Dinner (150) | Estimate Breakfast Cost | Estimate  Lunch  Cost | Estimate Dinner  Cost | REMARK
Total
Spreadsheet: darrell_schoolcraft__7253__saledoc02_13TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-02-12 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/13/2002 |  |  | FAX Number:
Total Quantity |  |  | 12000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.25
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/13/2002 | 2002-02-13 00:00:00 | 12000 |  | 12000 |  | 12000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 12000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 88948d1288751883-help-with-count-if-function-test
Sheet: TEST

Region | Account | Role 1 | Role 2 | Role 3 | Role 4 | Migration Start Date | Planned Migration Months | Migration Month Start | 2010-11-01 00:00:00
 |  |  |  |  |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 1 | Role 2 | Role 3 | Role 4 | Role 1 | Role 2 | Role 3 | Role 4 | Role 1 | Role 2 | Role 3 | Role 4 | Role 1 | Role 2 | Role 3 | Role 4 | Role 1 | Role 2 | Role 3 | Role 4
AMS | Aeromexico | 0.1 | 2 | 2 | 3.5 | 2010-11-22 00:00:00 | 4
APJ | Affinia | 0.1 | 2 | 2 | 3.5 | 2010-12-14 00:00:00 | 3
AMS | AGCO | 0.1 | 2 | 2 | 3.5 | 2010-12-13 00:00:00 | 3
EMEA | VSPR - Vin&Spiritus (DK) | 0.1 | 2 | 2 | 3.5 | 2011-01-18 00:00:00 | 4
 |  |  |  |  |  |  |  | Total FTEs
 |  |  |  |  |  |  |  |  | ITAM AsM Manager |  | ITAM AsM Data Analyst |  | ITAM AsM Manager |  | ITAM AsM Data Analyst |  | ITAM AsM Manager |  | ITAM AsM Data Analyst |  | ITAM AsM Manager |  | ITAM AsM Data Analyst |  | ITAM AsM Manager |  | ITAM AsM Data Analyst |  | ITAM AsM Manager |  | ITAM AsM Data Analyst
 |  |  |  |  |  |  |  | Total FTEs Mo
 |  |  |  |  |  |  |  |  | Accounts Migrating Month |  |  |  | Accounts Migrating Month |  |  |  | Accounts Migrating Month |  |  |  | Accounts Migrating Month |  |  |  | Accounts Migrating Month |  |  |  | Accounts Migrating Month
 |  |  |  |  |  |  |  |  | AMS Accounts Migrating |  |  |  | AMS Accounts Migrating |  |  | 2 | AMS Accounts Migrating |  |  | 2 | AMS Accounts Migrating |  |  |  | AMS Accounts Migrating |  |  |  | AMS Accounts Migrating
 |  |  |  |  |  |  |  |  | APJ Accounts Migrating |  |  | 0 | APJ Accounts Migrating |  |  | 1 | APJ Accounts Migrating |  |  | 1 | APJ Accounts Migrating |  |  |  | APJ Accounts Migrating |  |  |  | APJ Accounts Migrating
 |  |  |  |  |  |  |  |  | [NAME] |  |  | 0 | [NAME] |  |  | 0 | [NAME] |  |  | 1 | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Spreadsheet: 729318d1619020274-text-within-column-to-dictate-value-in-another-column-example-excel
Sheet: Sheet1

asin | item_name.value | number_of_items.value | min_order_qty.value |  |  | KEY
B07G5LPQ5L | Steel Spring Pin, Zinc Plated Finish, Inch (Pack of 25) |  |  |  |  | pack qty | min order qty
B07CR5F7L3 | 18-8 Stainless Steel Hex Nut, Right Hand Threads, Meets ASME B18.2.2, Inch (Pack of 50) |  |  |  |  | 10 | 10
B07CQ399LN | Brass Hex Nut, Right Hand Threads, Meets (Pack of 10) |  |  |  |  | 25 | 5
B07CL6PHNY | [NAME] [NAME], M6 x 1 mm [NAME], 30 mm Long, Stainless Steel (Pack of 100) |  |  |  |  | 50 | 20
 |  |  |  |  |  | 100 | 20
Spreadsheet: 716743d1612350255-indirect-formula-indirect-test
Sheet: Sheet1

No | Ref | Value |  | No | Ref | Value
1 |  |  |  | 1
2 |  |  |  | 2
Spreadsheet: 36fa1bbc-a216-4e17-8e1e-793c15994eec
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Hohenstein-Ernstthal, Stadt - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 2056 | 2114 | 1996 | 1782
20 - 60 | 7812 | 6777 | 5919 | 5108
60 und mehr | 5682 | 5884 | 6014 | 6142
Insgesamt | 15550 | 14775 | 13929 | 13032
%
unter 20 | 13.22186495176849 | 14.30795262267343 | 14.32981549285663 | 13.67403314917127
20 - 60 | 50.2379421221865 | 45.86802030456853 | 42.49407710531984 | 39.19582565991406
60 und mehr | 36.54019292604502 | 39.82402707275804 | 43.17610740182353 | 47.13014119091467
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 26.31848438300051 | 31.19374354434115 | 33.7219124852171 | 34.88645262333595
Altenquotient | 72.7342549923195 | 86.82307805813781 | 101.6050008447373 | 120.2427564604542
Gesamtquotient | 99.05273937532002 | 118.016821602479 | 135.3269133299544 | 155.1292090837901
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 231772d1367223286-how-to-sort-information-based-on-date-in-a-header-row-excel-schedule
Sheet: Jun

 |  |  |  | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 2013-01-01 00:00:00 |  | J | u | n | e
No. | Activity | Start Date | 2013-06-01 00:00:00 | 2013-06-02 00:00:00 | 2013-06-03 00:00:00 | 2013-06-04 00:00:00 | 2013-06-05 00:00:00 | 2013-06-06 00:00:00 | 2013-06-07 00:00:00 | 2013-06-08 00:00:00 | 2013-06-09 00:00:00 | 2013-06-10 00:00:00 | 2013-06-11 00:00:00 | 2013-06-12 00:00:00 | 2013-06-13 00:00:00 | 2013-06-14 00:00:00 | 2013-06-15 00:00:00 | 2013-06-16 00:00:00 | 2013-06-17 00:00:00 | 2013-06-18 00:00:00 | 2013-06-19 00:00:00 | 2013-06-20 00:00:00 | 2013-06-21 00:00:00 | 2013-06-22 00:00:00 | 2013-06-23 00:00:00 | 2013-06-24 00:00:00 | 2013-06-25 00:00:00 | 2013-06-26 00:00:00 | 2013-06-27 00:00:00 | 2013-06-28 00:00:00 | 2013-06-29 00:00:00 | 2013-06-30 00:00:00
 |  | [NAME] | 2013-06-01 00:00:00 | 2013-06-02 00:00:00 | 2013-06-03 00:00:00 | 2013-06-04 00:00:00 | 2013-06-05 00:00:00 | 2013-06-06 00:00:00 | 2013-06-07 00:00:00 | 2013-06-08 00:00:00 | 2013-06-09 00:00:00 | 2013-06-10 00:00:00 | 2013-06-11 00:00:00 | 2013-06-12 00:00:00 | 2013-06-13 00:00:00 | 2013-06-14 00:00:00 | 2013-06-15 00:00:00 | 2013-06-16 00:00:00 | 2013-06-17 00:00:00 | 2013-06-18 00:00:00 | 2013-06-19 00:00:00 | 2013-06-20 00:00:00 | 2013-06-21 00:00:00 | 2013-06-22 00:00:00 | 2013-06-23 00:00:00 | 2013-06-24 00:00:00 | 2013-06-25 00:00:00 | 2013-06-26 00:00:00 | 2013-06-27 00:00:00 | 2013-06-28 00:00:00 | 2013-06-29 00:00:00 | 2013-06-30 00:00:00
1
2
2.1
2.2
2.3
2.4
2.5
3
3.1
3.2
4
4.1
4.2
4.3
5
5.1
5.2
5.3
6
6.1
6.2
6.3
6.4
7
7.1
7.2
7.3
7.4
7.5
8
8.1
8.2
8.3
8.4
8.5
8.6
Spreadsheet: 835046d1688238671-locate-multiple-match-results-and-return-adjacent-cell-value-sample
Sheet: Sheet1

 | ⤋  Source Data  ⤋ |  | ⤋  Trying to get Results  ⤋ |  |  |  | ⤋  Source Data  ⤋ |  | ⤋  Expected Result  ⤋
 |  |  |  |  | [NAME]
 | JobCost | JobName | JobCostSort | RowForIndex | JobNameSort1 |  | JobCost | JobName | JobCostSort | JobNameSort
 | 5 | Job 1 |  |  |  |  | 5 | Job 1 |  | Job 18
 | 7 | Job 2 |  |  |  |  | 7 | Job 2 |  | Job 20
 | 0 | Job 3 |  |  |  |  | 0 | Job 3 |  | Job 17
 | 6 | Job 4 |  |  |  |  | 6 | Job 4 |  | Job 19
 | 0 | Job 5 |  |  |  |  | 0 | Job 5 |  | Job 12
 | 12 | Job 6 |  |  |  |  | 12 | Job 6 |  | Job 7
 | 15 | Job 7 |  |  |  |  | 15 | Job 7 |  | Job 15
 | 3 | Job 8 |  |  |  |  | 3 | Job 8 |  | Job 13
 | 2 | Job 9 |  |  |  |  | 2 | Job 9 |  | Job 6
 | 5 | Job 10 |  |  |  |  | 5 | Job 10 |  | Job 14
 | 0 | Job 11 |  |  |  |  | 0 | Job 11 |  | Job 2
 | 16 | Job 12 |  |  |  |  | 16 | Job 12 |  | Job 4
 | 13 | Job 13 |  |  |  |  | 13 | Job 13 |  | Job 1
 | 9 | Job 14 |  |  |  |  | 9 | Job 14 |  | Job 10
 | 14 | Job 15 |  |  |  |  | 14 | Job 15 |  | Job 8
 | 0 | Job 16 |  |  |  |  | 0 | Job 16 |  | Job 9
 | 20 | Job 17 |  |  |  |  | 20 | Job 17 |  | Job 3
 | 25 | Job 18 |  |  |  |  | 25 | Job 18 |  | Job 5
 | 17 | Job 19 |  |  |  |  | 17 | Job 19 |  | Job 11
 | 21 | Job 20 |  |  |  |  | 21 | Job 20 |  | Job 16
Spreadsheet: 768374d1644938996-trying-to-look-up-and-filter-data-example
Sheet: REDK050

REDK050
Product | Component name | Result text
Spreadsheet: 44218d1242853298-select-based-on-2-search-criteria-pp-rater
Sheet: RATES FACTORS ETC

BASE RATES
 |  |  |  |  |  |  | 50000 |  |  |  |  |  | 200
 | 50/100 |  |  | 5000 |  |  | Personal |  |  | Statutory |  |  | Deductible |  |  | 200 |  |  | $25 |  |  | 50
 | Bodily |  |  | Property |  |  | Injury |  |  | Uninsured |  |  | Compre- |  |  | Deductible |  |  | Towing |  |  | Towing
 | Injury |  |  | Damage |  |  | Protection |  |  | Motorists |  |  | hensive |  |  | Collision |  |  | & Labor |  |  | & Labor
 |  |  |  |  |  |  | (no Deduct) |  |  |  |  |  | (Symbol 2) |  |  | (Symbol 2)
01 | 532 |  | 01 | 179 |  | 01 | 793 |  | 01 | 16 |  | 01 | 329 |  | 01 | 397 |  | 01 | 4 |  | 01 | 8
03 | 408 |  | 03 | 129 |  | 03 | 471 |  | 03 | 16 |  | 03 | 335 |  | 03 | 372 |  | 03 | 4 |  | 03 | 8
05 | 406 |  | 05 | 137 |  | 05 | 572 |  | 05 | 16 |  | 05 | 346 |  | 05 | 312 |  | 05 | 4 |  | 05 | 8
17 | 726 |  | 17 | 147 |  | 17 | 922 |  | 17 | 16 |  | 17 | 425 |  | 17 | 424 |  | 17 | 4 |  | 17 | 8
18 | 346 |  | 18 | 111 |  | 18 | 365 |  | 18 | 16 |  | 18 | 248 |  | 18 | 275 |  | 18 | 4 |  | 18 | 8
19 | 358 |  | 19 | 116 |  | 19 | 450 |  | 19 | 16 |  | 19 | 296 |  | 19 | 295 |  | 19 | 4 |  | 19 | 8
20 | 332 |  | 20 | 150 |  | 20 | 525 |  | 20 | 16 |  | 20 | 144 |  | 20 | 303 |  | 20 | 4 |  | 20 | 8
21 | 283 |  | 21 | 151 |  | 21 | 454 |  | 21 | 16 |  | 21 | 129 |  | 21 | 276 |  | 21 | 4 |  | 21 | 8
22 | 268 |  | 22 | 132 |  | 22 | 363 |  | 22 | 16 |  | 22 | 119 |  | 22 | 238 |  | 22 | 4 |  | 22 | 8
55 | 412 |  | 55 | 136 |  | 55 | 527 |  | 55 | 16 |  | 55 | 322 |  | 55 | 347 |  | 55 | 4 |  | 55 | 8
75 | 269 |  | 75 | 152 |  | 75 | 389 |  | 75 | 16 |  | 75 | 93 |  | 75 | 265 |  | 75 | 4 |  | 75 | 8
76 | 241 |  | 76 | 125 |  | 76 | 380 |  | 76 | 16 |  | 76 | 86 |  | 76 | 235 |  | 76 | 4 |  | 76 | 8
Expense | 38 |  | Expense | 17 |  | Expense | 29 |  | Expense | 0 |  | Expense | 32 |  | Expense | 46 |  | Expense | 0 |  | Expense | 0
INCREASE LIMIT FACTORS
BI ILF |  |  | PD ILF |  |  | 100 DEDUCTIBLE PIP |  |  | 200 DEDUCTIBLE PIP
25,000 / 50,000 | 0.94 |  | 10000 | 1.05 |  | 01 | 0.8 |  | 01 | 0.67
50,000 / 100,000 | 1 |  | 25000 | 1.08 |  | 03 | 0.8 |  | 03 | 0.67
100,000 / 300,000 | 1.31 |  | 50000 | 1.13 |  | 05 | 0.8 |  | 05 | 0.67
300,000 / 300,000 | 1.39 |  | 100000 | 1.18 |  | 17 | 0.8 |  | 17 | 0.67
250,000 / 500,000 | 1.43 |  |  |  |  | 18 | 0.8 |  | 18 | 0.67
500,000 / 1,000,000 | 1.56 |  |  |  |  | 19 | 0.8 |  | 19 | 0.67
 |  |  |  |  |  | 20 | 0.8 |  | 20 | 0.67
 |  |  |  |  |  | 21 | 0.8 |  | 21 | 0.67
 |  |  |  |  |  | 22 | 0.87 |  | 22 | 0.71
 |  |  |  |  |  | 55 | 0.8 |  | 55 | 0.67
 |  |  |  |  |  | 75 | 0.87 |  | 75 | 0.71
 |  |  |  |  |  | 76 | 0.87 |  | 76 | 0.71
MEDICAL PAYMENTS |  |  | RENTAL REIMB |  |  | OBEL
5000 | 2 |  | 15 DAILY | 22 |  | 6
10000 | 3 |  | 20 DAILY | 30 |  | 5
25000 | 4 |  | 40 DAILY | 40
50000 | 6
100000 | 7
DISCOUNTS
NOT APPLICABLE | 1
APC COURSE | 0.9
DRIVER AIRBAGS | 0.8
DUAL AIRBAGS | 0.7
ABS | 0.95
DAY RUNNING LIGHTS | 0.97
ANTI-THEFT ACTIVE | 0.95
ANTI-THEFT PASSIVE | 0.9
LO JACK | 0.85
VIN ETCHING | 0.95
Spreadsheet: 856048d1705437160-formula-for-finding-a-specific-value-in-a-table-based-on-2-inputs-find-setting
Sheet: Sheet1

 | INDEX | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Setting | MCP Continous Amp Rating |  |  |  |  |  |  |  |  | Setting
INDEX |  | 3 | 7 | 15 | 30 | 50 | 100 | 150 | 175 | 250 |  |  | MCP Rating | Setting | Setting in Amps
2 | A | 12 | 28 | 45 | 90 | 150 | 300 | 750 | 875 | 1250 | A |  | 15 | D
3 | B | 15 | 34 | 60 | 120 | 200 | 400 | 844 | 984 | 1406 | B
4 | C | 17 | 40 | 75 | 150 | 250 | 500 | 938 | 1094 | 1563 | C |  | Motor Size | [NAME] in Amps | MCP rating | Setting
5 | D | 20 | 46 | 90 | 180 | 300 | 600 | 1031 | 1203 | 1719 | D |  | 5 | 83.6 | 15
6 | E | 23 | 53 | 105 | 210 | 350 | 700 | 1125 | 1313 | 1875 | E
7 | F | 25 | 59 | 120 | 240 | 400 | 800 | 1219 | 1422 | 2031 | F
8 | G | 28 | 65 | 135 | 270 | 450 | 900 | 1313 | 1531 | 2188 | G
9 | H | 30 | 71 | 150 | 300 | 500 | 1000 | 1406 | 1641 | 2344 | H
10 | I | 33 | 77 | 165 | 330 | 550 | 1100 | 1500 | 1750 | 2500 | I
 |  | In a nutshell: |  |  |  |  |  |  |  |  |  |  | Objective:Return Trip Setting L4:L12  Search in array C4:[NAME], the explicit column is based on P7 Find the clostest value in the array that is <=O2 Return letter from Setting Column L4:L12
 |  | Find in Row C3:K3 the MCP rated P7
 |  | Find O7 in the array containing P7
 |  | Return the associated letter in array L4:L12 in the same row O7 was found
 |  | Examples: |  |  | Amps | MCP | Setting
 |  | 30A MCP Setting 210 - Return E |  |  | 210 | 30
 |  | 3A MCP, Setting 33 - Return I |  |  | 33 | 3
 |  | 250A MCP, Setting 2188 - Return G |  |  | 2188 | 250
 |  |  |  |  | 84 | 15