tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1b31b952-6767-42ae-a87f-1d1ca7d3dcde
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
NIRU | Test | NIRU | Nickel, Random, [NAME] | Nickel, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 2 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.9 mL | Hemolysis	NA Thawing	Warm OK;  Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-6.0 mcg/L  Reference values apply to all ages. | Wednesday; 5 p.m. | 1 day | 7 days | 1 | 83885 |  |  |  |  | Rochester
NIRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
NIRU | Result | 60441 | Nickel, Random, U | Nickel, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 14099-6
Spreadsheet: 681481d1591600622-adding-data-to-a-table-on-basis-of-dropdown-selection-sample
Sheet: Sheet1

 | Comm Plans/Profiles | 2
 | Quality of Service Type
 |  | [NAME]
 | Quality of Service Type
 | Comm Plans/Profiles | Quality of Service Type
Spreadsheet: 882238d1730509159-vlookup-error-vlookup-error
Sheet: Report

Ürün No | [NAME] | Gram
10053672
10053682
10053692
10012730
10012730
[PHONE]
10012622
10013105
[PHONE]
100135021
100135022
100159080
10019912
10012903
10012612
100153903
100153901
100153821
100153821
10015603
100153903
100153901
10015607
100153816
100153903
100153902
100153745
10012714
10012714
10012714
10012714
10012717
10012717
10012717
10012717
10012717
10012717
10012717
10012717
10044352
10015361
10018012
10011491
100152313
[PHONE]
100153901
100153819
100153901
10015602
10015602
10015602
553505P
2082P
504951P
504951P
504951P
10495P
88804P
88804P
15811P
15811P
3042P
5005P
1042P
458P
SRG0012
SRG0020
455P
455P
458P
10610P
57503P
57501P
57503P
575031P
574P
5741P
574P
5741P
575P
575P
5751P
5751P
574P
574P
5741P
5741P
57504P
575041P
57503P
575031P
57502P
575021P
575011P
575P
5751P
575P
5751P
575P
575P
575P
5751P
575P
5751P
5751P
5751P
574P
574P
574P
5741P
5741P
5741P
57504P
575041P
575011P
57501P
57502P
57502P
57502P
575021P
575021P
575021P
57401P
574011P
99114P
99110P
10441P
2690P
55910P
55910P
777323PK
777303PK
20033662
20033662
200343102
[PHONE]
20034401
20034401
20034411
200359080
20014601
20014601
20014601
20014601
20014601
20014601
2003520
2003521
2003520
2003521
2003520
2003521
2003520
2003521
[PHONE]
2003520
2003521
[PHONE]
20041101
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: D Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 02-01) 09-02-2020 | pdf
Spreadsheet: 780620d1652618917-data-not-extracted-applying-and-criteria-in-filter-function-dummy-test
Sheet: Result

 | 125 | A | 25
 | 326 | B |  |  |  | 45
 | 126 | C | 60
 | 316 | F | 75 |  |  | 35
 | 46 | G | 80
 | 124 | K | 65 |  |  | 32
Spreadsheet: 675403d1588269544-3d-vlookup-to-sum-values-across-multiple-sheets-3dvlookup
Sheet: 2018

 | January | February | March | April | May | June | July | August | September | October | November | December | YTD
[NAME] | 2 | 4 | 8 | 6 | 8 | 4 | 2 | 4 | 8 | 8 | 4 | 2
[NAME] | 2 | 6 | 4 | 8 | 6 | 2 | 2 | 4 | 4 | 4 | 8 | 4
Spreadsheet: 861780d1709623836-countifs-and-averageifs-formula-9-aligw
Sheet: Sheet1

Date | Signal 1 | Signal 2 | Gains
2024-01-01 00:00:00 | Buy | Buy | 0.01
2024-01-02 00:00:00 | Buy | Buy | 0.02
2024-01-03 00:00:00 | Sell | Sell | 0.03
2024-01-04 00:00:00 | Buy | Sell | 0.04
2024-01-05 00:00:00 | Buy | Buy | 0.05
2024-01-06 00:00:00 | Buy | Buy | -0.01
2024-01-07 00:00:00 | Sell | Sell | -0.02
2024-01-08 00:00:00 | Sell | Sell | -0.03
2024-01-09 00:00:00 | Buy | Buy | 0.04
2024-01-10 00:00:00 | Sell | Sell | 0.05
Requested formulas |  |  |  |  |  |  |  | Expected results:
1. Count all rows that Signal 1 = signal 2 and positive gains |  |  |  |  |  |  |  | 6
2. same as 1. but with average gains |  |  |  |  |  |  |  | 0.033
if possible, please use countifs and [NAME]
Spreadsheet: 720280d1614093501-need-to-extract-data-and-skip-blanks-indexing-with-conditions-from-multiple-sheets-dawn-clark-
Sheet: AA-1 Plating Cost Calculator

 |  |  |  |  | PURCHASE ORDER ENTRY (Do not populate gray cells) |  |  |  |  | CNC-1 | CNC-2 | Millroom_Laser
CNC / LASER ENTRY (Do not populate gray cells) |  |  |  |  | PO SUBTOTAL |  |  | Expedite: NEXT DAY $ 285
 |  |  |  |  | PO WASTE FEE (5% of SUBTTL) |  |  | Expedite: SAME DAY $ 350
P/N | L (IN) | W (IN) | REV | QTY | Total Dimensions | Cost per Part | Total QTY Cost
Spreadsheet: 0160e8b8-5388-446d-ae9b-9c8faffa49b3
Sheet: Sheet1

VACCINE | <1 YEAR OF AGE | 1 YEAR OF AGE | 2 YEARS OF AGE | 3-5 YEARS OF AGE | 6 YEARS OF AGE | 7-10 YEARS OF AGE | 11-12 YEARS OF AGE | 13-18 YEARS OF AGE
DT
DTaP
[NAME]
DTaP-IPV-Hib
DTaP-IPV
[NAME]
[NAME]
[NAME]
Hib
HPV (Gardasil)
Influenza 6 mth & >
Influenza 6 -35mth
VACCINE | <1 YEAR OF AGE | 1 YEAR OF AGE | 2 YEARS OF AGE | 3-5 YEARS OF AGE | 6 YEARS OF AGE | 7-10 YEARS OF AGE | 11-12 YEARS OF AGE | 13-18 YEARS OF AGE
Influenza - 4 yrs & >
IPV (Polio)
MCV 4 (Menactra)
MMR
Pneumo (PPV23)
Pnu-Child ([NAME])
Rotavirus
TD
Tdap
Varicella
Spreadsheet: e580573d-6862-4206-b160-5f25fd2fbcb1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
ABDALLAH CANDIES | Hundreds of varieties of fresh classic chocolates, upscale packaging, fast shipping.
ALABAMA GIRL | Glitter caps, fashion hats, great value scarves
ART STUDIO | Fashion forward bags and scarves. Environmentally conscious dyes and fabrics
BARLOW DESIGNS | Great men's gifts, custom ornaments, money clips. knives - golf, nautical, hunting, etc
BIJOULEE | Sterling interchangeable jewelry - Change becomes you.
BOOKMARK TRENZ | Amazing 3-D bookmarks, luggage tags and keychains. Collegiate 3D too.
CANDLEWARMERS | The original candle warmer.  Burn candles without the flame!
CATHEDRAL ART | Angels, inspriational gifts of sentiment since 1920. Gifts that touch the heart.
COYNES & COMPANY | Fountains, Animated novelties, seasonal décor, ladies accessories, [NAME]
DYNASTY GALLERY | Elegant glass paperweights,  decorative glass fish, jellyfish, turtles-Wow!
GRANDCO | Ladies sandals - resort wear - great prices!
HAND VIBES | The new collectible fashion craze. Rings with an attitude!
HATLEY | Humorous gifts and apparel for the whole family
ICU EYEWEAR | Fashion readers and eyewear for women and men
IT'S A WRAP | [NAME] wraps, can coolers, travel mugs, and more! Made in USA
JOHN HINDE | KIDS: Mugs, Water bottles, flashlights, key chains - personalized. Voo [NAME]
[NAME] | Ladies fashion accessories - Great prices! NEW - ME BEADS!!
LAMAR CREATIONS (MICKI'S) | Blue Luster CZ, Sterling Essense - High quality, high margin traditional CZ jewelry
LANTERN PRESS | [NAME] items for tourism and destinations.Exclusive artwrork on stationery, magnets and mugs.
LOTTI DOTTIES | Affordable interchangeable magnetic fashion
LUG | Live life in color. Bags and Travel Accessories
MAD STYLE | Women's fashion accessories - bags, jewelry, shell bags
MAGNET WORKS | Leading outdoor décor co. MailWraps, [NAME], and [NAME] for outdoor and indoor décor.
PERIWINKLE | Fashion jewelry and handbags, scarves and sun catchers
REGAL ARTS | [NAME] always fresh new designs, colorful and cute!
SUNSET VISTA DESIGNS | Home, garden and seasonal whimsy décor
TRIPAR INTERNATIONAL | Home décor, wall art, fixtures, displays, ornament stands and more - great prices!
TWO LUMPS OF SUGAR | Kitchen accessories, storage and organizers, baby, travel. Get your lumpers here!
VANDOR | Nostalgic icons on your favorite product -Beatles, Elvis, [NAME], Ali & more
WELLSPRING | Brings art & organization to everyday life. Wellspring helps you stay in touch in a busy world.
WISHPETS | The best value in quality PLUSH! Personalization available
WOODSTOCK | The original precision-tuned, high quality windchimes and music collection instruments.
Spreadsheet: 51f888a8-ec3f-4ffd-a69c-2dfd7d9e6c79
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Business Services | 3 | Improve Purchasing and Contract Processes | None | -- Pick One -- | 1.1.r1 | Purchasing Technician | OnGoing | 45000 | 40000 | 45000 | 40000 | 45000 | 40000 | 0 | 0
Business Services | 4 | Improve Requisition Process | None | -- Pick One --
Business Services | 1 | Expand Information Resources | None | -- Pick One --
Business Services | 2 | Improve communications and customer service | None | -- Pick One --
Spreadsheet: 152846d1335548591-vlookup-or-something-else-cschoyer_book2_27apr12_01
Sheet: Sheet1

 | Vendor | Approved By |  |  |  |  |  | Vendor | Approver
 | Xxyy | [NAME] |  |  |  |  |  | xxyy
 | Abcd | [NAME] |  |  |  |  |  | abcd
 | PPll | [NAME]
 | [NAME] | [NAME]
 | Xxyy | [NAME]
 | Wxrt | [NAME]
 | Abcd | [NAME]
Spreadsheet: 772523d1647342134-excel-formula-to-find-conditional-duplicate-instances-in-a-column-sample-data
Sheet: Data

Category | Sub Category | Item Number
1000 | A | AB1234
2000 | A | AB1236
1000 | B | BB4567
2000 | B | BB4569
1000 | C | AB1236 |  |  |  |  | Category | Sub Category | D
2000 | C | BB4567 |  |  |  |  | 2000 | A | Count=1
3000 | B | AB1238
4000 | B | AB1239
3000 | A | AB1238
4000 | A | AB1239
1000 | D | AB1234
2000 | D | AB1236
3000 | D | BB4567
4000 | D | BB4569
1000 | E | AB1238
2000 | E | AB1239
3000 | E | AB1238
5000 | B | AB1239
3000 | C | AB1234
4000 | E | AB1236
Spreadsheet: 494080d1482165324-sort-array-formula-results-in-descending-order-sort-array-formula-results-in-descending-order-download-example-1
Sheet: PS_DROP DOWN LISTS DATA

MANUFACTURE LOCATION |  | DEILVERY TYPE |  | DRIVER |  | TRANSPORT |  | DELIVERY No. |  | CLIENT LIST |  | JOB LIST |  | DELIVERY COUNT  (BY JOB) |  | TRANSPORT (DATE SPECIFIC)
SITE 1 |  | DELIVERY |  | Driver 1 |  | Vehicle 1 |  | DEL 1
SITE 2 |  | SITE |  | Driver 2 |  | Vehicle 2 |  | DEL 2
ALL OUTSOURSE |  | CLIENT COLLECT |  | Driver 3 |  | Vehicle 3 |  | DEL 3
 |  | OTHER |  | Driver 4 |  | Vehicle 4 |  | DEL 4 |  |  |  |  |  |  |  |  |  |  |  | =OFFSET(PRICELIST!$A$5,0,0,COUNTA(PRICELIST!$A$5:$A$202))
 |  | COLLECTION |  | Driver 5 |  | Vehicle 5 |  | DEL 5 |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(INDEX(RANGE,MATCH(0,COUNTIF($A$3:A3,RANGE),0)),"")
 |  |  |  | Driver 6 |  | Vehicle 6 |  | DEL 6 |  |  |  |  |  |  |  |  |  |  |  | =OFFSET(CALCSHEET!$A$4, 0, 0, COUNT(IF(CALCSHEET!$A$4:$A$50="", "", 1)), 1)
 |  |  |  | Driver 7 |  | Vehicle 7 |  | DEL 7
 |  |  |  | Driver 8 |  | Vehicle 8 |  | DEL 8 |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(INDEX(TYPE,MATCH(0,COUNTIF($B$3:B3,TYPE)+(RANGE<>$A$1),0)),"")
 |  |  |  |  |  |  |  | DEL 9
 |  |  |  |  |  |  |  | DEL 10
 |  |  |  |  |  |  |  | DEL 11
 |  |  |  |  |  |  |  | DEL 12
 |  |  |  |  |  |  |  | DEL 13
 |  |  |  |  |  |  |  | DEL 14
 |  |  |  |  |  |  |  | DEL 15
Spreadsheet: 6b94da6b-a516-418d-86f2-5050d7654618
Sheet: Sheet1

Unnamed: 0 | Team | Wins | Loss | Tie | Gaveup | Runs
1 | Bases Loaded | 7 | 1 |  | 72 | 111
2 | Bust N Balls | 6 | 2 |  | 38 | 79
3 | Double Play | 6 | 2 |  | 32 | 70
4 | No Glove No Love | 5 | 3 |  | 81 | 86
5 | Bombers | 5 | 3 |  | 76 | 79
6 | Just the Tip | 3 | 5 |  | 122 | 73
7 | [NAME] | 2 | 6 |  | 96 | 49
8 | Dirtbags | 2 | 6 |  | 48 | 52
9 | Work the Problem | 0 | 8 |  | 68 | 32
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T36

الجدول 36: النسبة المئوية للأولاد (0-14) سنة، خلال سنوات التعداد
Table 36: Percentage of children (0-14) years, during the census years
Country | Round 2000           دورة 2000 |  |  |  | Round 2010           دورة 2010 |  |  |  | البلد
 | Census year سنة التعداد | % Male child نسبة الذكور الأطفال | % Female child  نسبة الإناث الأطفال | % Total child  نسبة المجموع الأطفال | Census year سنة التعداد | % Male child نسبة الذكور الأطفال | % Female child  نسبة الإناث الأطفال | % Total child  نسبة المجموع الأطفال
Bahrain | 2001 | 14.25383182396665 | 13.62318706924642 | 27.87701889321307 | 2010 | 10.26210724211082 | 9.793685417849602 | 20.05579265996042 | البحرين
Egypt | 1996 | 19.43505591379307 | 18.23885773003835 | 37.67391364383143 | 2006 | 19.44698650098362 | 18.23752747124733 | 37.68451397223095 | مصر
Iraq | 1997 | 22.81122807132136 | 22.06876146340392 | 44.87998953472528 |  | ... | ... |  | العراق
Jordan | 2004 | 19.11248033021144 | 18.18112527159542 | 37.29360560180687 |  | ... | ... |  | الأردن
Kuwait | 1995 | 15.3209314724195 | 14.60449234245384 | 29.92542381487335 | 2005 | 12.91572816277521 | 12.0229699254804 | 24.93869808825561 | الكويت
Lebanon |  | ... | ... | ... |  | ... | ... |  | لبنان
Oman | 2003 | 17.25766453137048 | 16.57239038539996 | 33.83005491677044 | 2010 | 14.2186401988261 | 13.6105591569289 | 27.82919935575499 | عمان
Palestine | 1997 | 24.10256646790964 | 22.91325299259821 | 47.01581946050785 | 2007 | 22.0894682187741 | 21.28450456392631 | 43.37397278270042 | فلسطين
Qatar | 2004 | 11.44659683963932 | 11.08182611161662 | 22.52842295125593 | 2010 | 7.01056527610647 | 6.6753950577692 | 13.68596033387567 | قطر
Saudi Arabia | 2004 | 17.11816805009132 | 17.21534921856005 | 34.33351726865136 |  | ... | ... |  | المملكة العربية السعودية
Sudan |  | ... | ... | ... | 2008 | 22.26813578723666 | 20.34205783295862 | 42.61019362019528 | السودان
Syrian Arab Republic | 2004 | 20.21430963277152 | 19.01439892845184 | 39.22870856122335 |  | ... | ... |  | الجمهورية العربية السورية
United Arab Emirates | 1995 | 13.57890637280743 | 12.73313062697814 | 26.31203699978557 | 2005 | 10.12918255749591 | 9.349075138531536 | 19.47825769602744 | الإمارات العربية المتحدة
Yemen | 2004 | 23.27615202131189 | 21.73985775376691 | 45.0160097750788 |  | ... | ... |  | اليمن
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 11d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | <100 | <100 | <100 | 110 | 240 | 196 | 240 | 786
FRA | 3556 | 2534 | 1898 | 2432 | <100 |  |  | 10420
IRS- [NAME] | <100 | 342 | 282 | 2186 | 9168 | 11532 | 11776 | 35286
OIS | 142 | 236 | 152 | 584 | 394 | <100 | <100 | 1508
VNS |  |  | <100 | <100 | <100 | <100 | <100 | <100
Zero Coupon |  | <100 | <100 | <100 | <100 | <100 | 102 | 102
TOTAL | 3698 | 3112 | 2332 | 5312 | 9802 | 11728 | 12118 | 48102
Estimated swap transaction volumes, week ending October 25, by product type and tenor (number of trades), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for tenor bucket descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 11156cd9-fc23-4537-b360-ad9f4f222870
Sheet: Sheet1

Global Innovation Initiative: Proposal Budget Template
 | U.S. Partner: [insert name] | UK Partner: [[NAME] Name] | 3rd Country Partner: [[NAME] Name] | Total Funds Requested | Cost-Share
Personnel
[Insert line item]
[Insert line item]
[Insert line item]
Personnel Subtotal
Other Direct Costs
[Insert line item]
[Insert line item]
[Insert line item]
Direct Costs Subtotal
Indirect Costs
[Insert line item]
[Insert line item]
[Insert line item]
Indirect Costs Subtotal
Total
Spreadsheet: 22536d1211482099-transpose-row-in-one-sheet-to-column-in-another-columntorow
Sheet: Sheet1

43 | 34 | 16 | 47 | 31 | 12 | 33 | 21 | 3 | 5 | 33 | 26
 |  |  |  |  |  | 43
 |  |  |  |  |  | 34
 |  |  |  |  |  | 16
 |  |  |  |  |  | 47
 |  |  |  |  |  | 31
 |  |  |  |  |  | 12
 |  |  |  |  |  | 33
 |  |  |  |  |  | 21
 |  |  |  |  |  | 3
 |  |  |  |  |  | 5
 |  |  |  |  |  | 33
 |  |  |  |  |  | 26
Spreadsheet: f9342724-ca92-4f05-b156-2cacf759f7f5
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
[NAME] | Test | [NAME] | Cell-Bound Platelet Autoantibody, [NAME], Blood | Cell Bound Platelet Autoantibody, B | Enzyme-Linked Immunoabsorbent Assay (ELISA) | 2 EDTA (lavender-top) Tubes: 2 |  |  | 20 | mL | The patient must have a platelet count >10,000/microliter.   [NAME] must arrive within 48 hours. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube: Lavender top (EDTA) [NAME]: 20 mL | Adults: 10 mL/Pediatric: 5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	[NAME] older than 48 hours | An interpretive report will be provided. | Monday through Friday; 7:30 a,m.-5:00 p.m. Saturday; 10:00 a.m.-6:00 p.m | 2 days | 3 days | 1 | 86022 |  |  |  |  | Rochester
[NAME] | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 48 hours
[NAME] | Result | CBP_A | Cell Bound Platelet Autoantibody, B | Cell Bound Platelet Autoantibody, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | CMT27 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
Spreadsheet: 772903d1647522757-value-error-when-linked-source-is-closed-material-monitoring-trial
Sheet: Sheet1

SUMIFS USED FORMULA
 | 2022-01-01 00:00:00 | 2022-01-20 00:00:00
Item code | PC | KGS
BR-1
BR-10
BR-13
BR-14
BS-36
BS-67
SB-123/124
SB-126
SB-129
SB-130
[NAME]
SB-133/134
SB-141/142
SB-147
SB-150
SB-151/152
SB-155
TR-44
TR-46
Spreadsheet: 882709d1731128925-how-to-retrieve-the-quantity-of-replacement-products-in-the-data-file-hongnhung88-tim-so-luong-spill-365-aligw
Sheet: result

CODE | Quantity |  | 365 |  | 365 SPILL
APX M-8720 | 240
AG-7130R | 1470 |  |  |  | 1470
AG-2065-S | 355 |  |  |  | 355
AG-7070-T | 420 |  |  |  | 420
Spreadsheet: 107036d1304191668-spellnumber-formula-example-sheet
Sheet: Line-A2

EMERGENCY LODGING CENTER PROJECT, SHUMAISI
EXTERNAL WORKS - ROAD PROJECTS
Storm Drainage System
Pipe Installation
Request No. | Line No. | From Manhole | To Manhole | Pipe Dia. | Excavaion | Beding | Pipe |  | Gravel | Layer 1 | Layer 2 | Layer 3 | Layer 4 | Layer 5 | Layer 6 | Layer 7 | As per Drawing | Approved Qty
 |  |  |  |  |  |  | Test | Survey
 | [NAME] | SD.MH-A2 | SD.MH-A2/1 | 600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 73.5
 | "       " | SD.MH-A2/1 | SD.MH-A2/2 | 600 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 83
 | "       " | SD.MH-A2/2 | SD.MH-A2/3 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 96
 | "       " | SD.MH-A2/3 | SD.MH-A2/4 | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 100
 | "       " | SD.MH-A2/4 | SD.MH-A2/5 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 100
 | "       " | SD.MH-A2/5 | SD.MH-A2/6 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 93.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length |  | 0 | 0
Spreadsheet: 801741d1666352918-use-of-if-and-and-or-functions-to-determine-a-result-book1
Sheet: Sheet1

Scenario | Likelihood | Severity | Calculated Result | Desired Result
1 | Alpha | Tango |  | D |  |  |  |  |  |  |  |  |  | Severity
2 | Bravo | Victor |  | C |  |  |  |  |  |  |  |  |  | Tango | Uniform | Victor | Whisky | Xray | Yellow | Zero
3 | Bravo | Whisky |  | B |  |  |  |  |  |  |  | Likelihood | Alpha | D | C | B | A
4 | [NAME] | Uniform |  | D |  |  |  |  |  |  |  |  | Bravo | D | D | C | B | A
5 | Echo | Yellow |  | C |  |  |  |  |  |  |  |  | [NAME] | D | D | C | B | B | A
 |  |  |  |  |  |  |  |  |  |  |  |  | Delta | D | D | D | C | C | B | A
 |  |  |  |  |  |  |  |  |  |  |  |  | Echo | D | D | D | D | D | C | B
User inputs results in columns B and C (from a drop-down list)
Column D should auto-populate based on the table to the right.
I can achieve this for a single argument (see cell D2 IF function), but cannot capture all combinations. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lists (Column B and C)
I need a way for column D to display the correct result subject to the selected values in column B and C. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Likelihood | Severity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alpha | Tango
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bravo | Uniform
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Victor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delta | Whisky
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Echo | Xray
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zero
Spreadsheet: 865277d1712320290-dividends-lockup-period-dividends-wip-ans2
Sheet: Sheet1

Lockup Period (years) | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 6 | YEAR 7 | YEAR 8 | YEAR 9 | YEAR 10 | YEAR 11 | YEAR 12 | YEAR 13 | YEAR 14 | YEAR 15
4
Per Share Earning | -0.01332051892399999 | -0.008418020227809521 | 0.007112088978310507 | 0.02163120654774272 | 0.04633909915786336 | 0.06851466202315518 | 0.09844629759913674 | 0.1499448599226626 | 0.2122650561268285 | 0.2928276336132047 | 0.4018437421213192 | 0.515773141318059 | 0.638487900404493 | 0.781994390447292 | 0.9385826309055527
% Available for Dividends | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Seed
Outstanding Shares | 271981600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Series A
Outstanding Shares | 0 | 0 | 0 | 0 | 0 | 0 | 200040000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Outstaning shares (Row 10 and Row 14) is a variable that can change in value AND the year it comes in
 | Based on that outstanding shares I need to be able to calculate the dividends considering the lockup period (in B2) during which time no dividends are paid out
 | Right now I am not able to lock payment until lockup period is over for any column but Column B