tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e5533742-5f43-481e-8b32-68ceab193052
Sheet: A5.  Components of Rate Change

Exhibit A5:  Components of the Average Proposed Rate Change
[NAME]:
Plan Type(s):
Market Segment:
Rate Effective Date:
Components of Average Rate Change | Proposed Annual Rate Change |  | Federal Preliminary Justification
Utilization
Unit Cost
Retention
Over/Understatement of Prior Rates
Other
Total (includes impact of benefit changes):
check1
Benefit Changes Required by Law
Benefit Changes Not Required by Law
Total excluding Benefit Changes
Provide Explanation for what is included in "Other" if more than 0.5%:
Notes:
1.  The total rate change from this exhibit should tie to the  rate change [NAME] column M based on total enrollment.
Part I Federal Preliminary Justification Form- OPTIONAL
Section B3 |  |  | Cell
Utilization |  |  | K43
Unit Cost |  |  | K44
Section C
Prior Estimate of Current Rate:  Projected Net Claims |  |  | AA51
Prior Estimate of Current Rate:  Administrative Costs |  |  | AA52
Prior Estimate of Current Rate:  Underwriting Gain/Loss |  |  | AA53
Prior Estimate of Current Rate:  Total Rate |  |  | AA54
Future Rate:  Projected Net Claims |  |  | Q51
Future Rate:  Administrative Costs |  |  | Q52
Future Rate:  Underwriting Gain/Loss |  |  | Q53
Future Rate:  Total Rate |  |  | [NAME]
Section D
Prior Net Claims Estimate for Current Rate Period |  |  | Y74
Re-Estimate of Net Claims PMPM for Current Rate Period |  |  | Y75
Prior Estimate of Current Rate:  Total Rate
Utilization Impact
Unit Cost Impact
Retention Impact
Over/Understatement of Prior Rates
Spreadsheet: 04f4c61d-e0ef-42ec-b12a-3625216751d1
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | FORM D | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
INTERNATIONAL CIVIL AVIATION ORGANIZATION
AIR TRANSPORT REPORTING FORM
 | FLEET AND PERSONNEL - COMMERCIAL AIR CARRIERS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | State:
 | Contact person: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Air carrier:
 | Organization: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year ended:
 | Tel:
 | Fax:
 | E-mail:
 | Part I - FLEET
 | Aircraft in Fleet by Type |  | Number of Aircraft of each Type |  |  |  | Size of Aircraft |  |  | Utilization of aircraft during the year
 |  |  |  |  |  |  |  |  |  | Number of aircraft departures |  |  | Aircraft hours Flown |  |  | Aircraft kilometres flown
 |  |  |  | Changes during the year |  |  | Number of | Average |  |  |  |  |  |  |  |  |  |  | Total
 | Manufacturer and Model | Use/ | At the |  |  |  | Installed | payload | Average | Revenue flights |  | All | Revenue flights |  | All | Revenue Flights |  | All | aircraft
 |  | Version | beginning |  | Disposed | At the end | Passenger | capacity | MCTOM |  | Non-Scheduled | flights |  | Non-Scheduled | flights |  | Non-Scheduled | flights | days
 |  | code¹ | of the year | Acquired | of | of the year | Seats | (tonnes) | (tonnes) | Scheduled |  | (total) | Scheduled |  | (total) | Scheduled |  | (total) | available
 | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s
 | Part II - PERSONNEL
 |  |  |  | Total annual expenditures |  |  | 1 | Use/Version Codes
 |  |  |  | for each category
 |  | Number of personnel |  | Currency: |  |  |  | Report one of the following codes in column b for each aircraft entry in column a.
 | Category of personnel  2 | Mid-year | Year-end
 | a | b | c | d |  |  |  | Version codes for aircraft used by operator for commercial air transport:
 | Pilots and co -pilots |  |  |  |  |  |  | P - Passenger version of aircraft.
 | Other flight crew |  |  |  |  |  |  | F - Freighter version of aircraft, no provision for passengers.
 | [NAME] crew |  |  |  |  |  |  | M - Combination ("Combi") version of aircraft I.e aircraft capable of carrying both
 | Maintenance and overhaul personnel
 | a) Licensed aircraft maintenance engineers |  |  |  |  |  |  | Code for aircraft not used by operator for commercial air transport:
 | b) Other maintenance and overhaul personnel |  |  |  |  |  |  | O - Aircraft used for other purposes, such as  training, aerial work, etc.
 | Ticketing and sales personnel
 | All other personnel |  |  |  |  |  | 2 | Small carriers (see the reporting instructions) may include maintenance,
 | TOTAL |  |  |  |  |  |  | overhaul, ticketing and sales personnel in " all other personnel".
 | Remarks (including mention of any unavoidable deviation from the instructions):
Spreadsheet: 30236755-1152-4c4e-ad84-d76bf0965369
Sheet: Overview

WEST BRANCH MARINA HISTORICAL DATA
Category
of Revenue | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
Rental - Boats & Motors
Marine Equipment Sales
Bait and Tackle
Gasoline and Oil
Food and Beverage
Vending
Transient Dockage
Souvenirs and Sundries
All Other Receipts
Totals
Commissions Paid
Spreadsheet: 158468d1338274227-how-to-combine-if-and-offset-match-countif-together-excel-data-validation-techniques
Sheet: Data Validation - Switch Lists

 | Advanced Data Validation - Switching Between Lists
 | Created by Pointy Haired Dilbert - http://chandoo.org/wp | feel free to share, copy and extend
 | Cell with Validation |  |  | ShortList |  | Full List |  | Many thanks to [NAME] for sharing this idea :)
 |  |  |  | Full List |  | a |  | How this works?
 |  |  |  | a |  | b |  | » [NAME] the cell B7
 |  |  |  | b |  | c |  | » Go to menu > data > validation
 |  |  |  | c |  | d |  | » See how the validation formula is used (shown below)
 |  |  |  | x |  | e
 |  |  |  | y |  | f
 |  |  |  | z |  | g
 |  |  |  |  |  | h
 |  |  |  |  |  | i
 |  |  |  |  |  | j
 |  |  |  |  |  | k
 |  |  |  |  |  | l
 |  |  |  |  |  | m
 |  |  |  |  |  | n
 |  |  |  |  |  | o
 |  |  |  |  |  | p
 |  |  |  |  |  | q
 |  |  |  |  |  | r
 |  |  |  |  |  | s
 |  |  |  |  |  | t
 |  |  |  |  |  | u
 |  |  |  |  |  | v
 |  |  |  |  |  | w
 |  |  |  |  |  | x
 |  |  |  |  |  | y
 |  |  |  |  |  | z
Spreadsheet: 861468d1709308792-basic-checkbook-register-formula-problem-dw-checking-practice-2-bsb-
Sheet: Sheet1

CHASE BANK CHECKING ACCOUNT
DATE | [NAME] | PAYMENT | TAX DEP | N/TAX DEP | MY BALANCE | C | BANK BALANCE
 | BEGINNING BALANCE |  |  |  | 0 | c
 | INTIAL DEPOSIT |  |  | 100 |  | c
 | Entry 1 | 10
 | Entry 2 |  | 5 |  |  | c
 | Entry 3 | 10 |  |  |  | c
 | Entry 4 | 50 |  |  |  | c
 | Entry 5 |  | 25 |  |  | c
 | Entry 6 |  |  | 50
Spreadsheet: be51bc14-aec1-4834-a6cd-0cdaf62993e5
Sheet: Sheet1

Table S2.Spectral counts of proteins identified from reciprocal tandem affinity purifications and LC-MS/MS analysis for Ubp5, Ubp9 and their partners. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Ubp9 TAP | Bun107 TAP | Bun62 TAP
Ubp9 Spec. Counts | 364 | 72 | 443
Bun107 Spec. Counts | 1036 | 180 | 1730
Bun62 Spec. Counts | 281 | 85 | 827
 | Ubp5 TAP | Ftp105 TAP
Ubp5 Spec. Counts | 14458 | 60
Ftp105 Spec. Counts | 4013 | 50
Spreadsheet: 0adb3446-659b-4c1f-8ed2-2e2f96411ebc
Sheet: MainEntry&Data

 | Note:  text box appearance may vary with different Windows and Excel versions.
 |  |  | Please Read Cell Comments
 |  |  |  |  |  |  |  |  | Offgas temp., °C | 900
 |  |  |  |  |  |  |  |  | Heat loss, kJ | 40
 |  |  | Natural Gas Properties |  |  |  |  |  | Oxidant Properties
 |  |  | Species | Mol. mass | Vol % |  |  |  | % O2 in Oxidant | 0.21
 |  | Methane | CH4 | 16.043 | 0.93 |  |  |  | Upper limit on % excess oxidant | 1
 |  | [NAME] | C2H4 | 28.054 | 0.005
 |  | [NAME] | [NAME] | 30.07 | 0.02 |  |  |  | Element Balance
 |  | Propane | C3H8 | 44.097 | 0.004 |  |  |  | moles | mass |  | Figure 1.  Relationship between the % gross available heat and the % excess oxidant used for NG combustion.
 |  | Butanes & higher | C4H10 + | 58.124 | 0.003 |  |  | C |  |  |  | Chart and table will reconfigure when any entry value is changed. Legend refers to offgas temp. (cell K11).
 |  | Hydrogen | H2 | 2.016 | 0.005 |  |  | H |  |  |  | Excel's Trendline tool can be used to give a linear equation fit to the results.
 |  | Carbon monoxide | CO | 28.011 | 0.005 |  |  | O
 |  | Carbon dioxide | CO2 | 44.011 | 0.003 |  |  | N |  |  |  |  |  |  |  | Summary of Results
 |  | Water vapor | H2O | 18.016 | 0.005 |  |  | Sum
 |  | Nitrogen (by diff.) | N2 | 28.014
 |  |  | Molecular mass of NG
 |  |  |  | Table I. Molar DH°form at 25 °C |  |  |  | Table II. Molar DH°reax at 25 °C
 |  |  |  | kJ/g-mol |  |  | Reaction to form H2O(g) |  |  | kJ/g-mol
 |  |  | CH4 | -74.81 |  | 2O2 + CH4 → CO2 + 2H2O(g)
 |  |  | C2H4 | 52.467 |  | 3O2 + C2H4 → 2CO2 + 2H2O(g)
 |  |  | [NAME] | -84.684 |  | 3½O2 + C2H6 → 2CO2 + 3H2O(g)
 |  | NG reactant species | C3H8 | -103.847 |  | 5O2 + C3H8 → 3CO2 + 4H2O(g)
 |  |  | C4H10 | -126.148 |  | 6½O2 + C4H10 → 4CO2 + 5H2O(g)
 |  |  | H2 | 0 |  | [NAME] → H2O(g)
 |  |  | CO | -110.529 |  | [NAME]
 |  | Combustion | CO2 | -393.509 |  | H2O(g) → H2O(liq) |  |  |  | -44.02
 |  | products | H2O(g) | -241.814
 |  |  | H2O(liq) | -285.83
 |  | Table III. Heat Content Above 25 °C, J/g-mol
 |  | T (°C) | O2 | N2 | H2O(g) | CO2
 |  | 25.00000000000102 | 0 | 0 | 0 | 0
 |  | 192.5000000000009 | 5022.200082301772 | 4862.987998425089 | 5707.728944174383 | 6776.605265149223
 |  | 360.0000000000008 | 10322.95974606414 | 9872.320061862845 | 11690.43295872193 | 14482.88511517124
 |  | 527.5000000000007 | 15867.47035996946 | 15072.09395196746 | 18014.03111115142 | 22850.71575833034
 |  | 695.0000000000006 | 21596.85385380779 | 20444.54037016227 | 24689.83149329398 | 31691.27098592819
 |  | 862.5000000000006 | 27467.51650639045 | 25966.03972700029 | 31710.22658095851 | 40880.21938250194
 |  | 1030 | 33449.50395345974 | 31615.12748603094 | 39058.91163302134 | 50333.07262975676
 |  | 1197.5 | 39522.53233167862 | 37373.23886085024 | 46714.93731320716 | 59990.29783450754
 |  | 1365 | 45673.03083374837 | 43224.25765124475 | 54654.61340580671 | 69808.63957551436
 |  | 1700 | 58174.4894558684 | 55149.60476046221 | 71282.04165838279 | 89807.63199091275
 |  | Data from FREED database program.
Spreadsheet: 37133d1235071610-using-a-formula-to-transfer-information-between-sheets-in-different-rows-practice-workbook-for-excel-forum
Sheet: Sheet3

Name | Education | Test Score | [NAME]
[NAME] | PhD | 90 | [EMAIL]
[NAME] | MA | 89 | [EMAIL]
[NAME] | MA | 92 | [EMAIL]
[NAME] | PhD | 89
[NAME] | MA | 80 | [EMAIL]
[NAME] | HS | 79 | [EMAIL]
MIA | BA | 91 | [EMAIL]
[NAME] | BA | 95 | [EMAIL]
[NAME] | PhD | 87
[NAME] | HS | 93
[NAME] | Eight Grade | 84 | [EMAIL]
Gatta Spree | MA | 90 | [EMAIL]
Slick Deals | BA | 87 | [EMAIL]
Spreadsheet: 599933d1543377390-nested-if-statement-with-vlookups-too-many-arguments-customs-formula-issue
Sheet: Sheet1

 |  |  | Select Address
 |  |  | 22 Address
Cust Item # | Item # |  |  |  |  |  |  |  |  |  |  |  | Hello,
 | 1111
 | 1111 |  |  |  |  |  |  |  |  |  |  |  | I am trying to build a nest IF statement with VLOOKUPS but receive the error "Too Many Arguments". A single IF statement with this criteria is successful. Any help is appreciated.
*=IF(E3="Canadian Tire",VLOOKUP(B9,Sheet3!A:B,2,FALSE), " ", IF(E3="Home Depot CA",VLOOKUP(B9,Sheet3!A:C,3,FALSE), " ", IF(E3="Lowes CA",VLOOKUP(B9,Sheet3!A:D,4,FALSE), " "))) | 1111
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  |  |  |  |  |  |  | =IF(E3="Canadian Tire",VLOOKUP(B7,Sheet3!A:B,2,FALSE), " ", IF(E3="Home Depot CA",VLOOKUP(B7,Sheet3!A:C,3,FALSE), " ", IF(E3="Lowes CA",VLOOKUP(B7,Sheet3!A:D,4,FALSE), " ")))
 |  |  |  |  |  |  |  |  |  |  |  |  | I have also tried a IFS statement but it produces #[NAME] error:
 |  |  |  |  |  |  |  |  |  |  |  |  | Ultimately, what I am trying to accomplish is a universal customs doc. D2 is where you select shipping address. E3 has a vlookup to Sheet 2 to see if [NAME] is a retailer that needs their item # present. A7 is where I am inserting formula. If E3 is one of the three retailers, then I want their item number to pull from the item master on Sheet 3. If E3 is blank, then I want a space returned.
 |  |  |  |  |  |  |  |  |  |  |  |  | Any ideas on how I can accomplish this? Attached is the file I am working in.
 |  |  |  |  |  |  |  |  |  |  |  |  | Thanks!
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: john_griffith__15949__11_15_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 255 | 27.5 | 29.5 | 74.7 | 80.1 | 12.41 | 2001-11-15 14:38:00
 | NG F2 | 280 | 56.5 | 58.5 | 76 | 78.7 | 13.62 | 2001-11-15 14:38:00
 | NG G2 | 280 | 71 | 73 | 71.4 | 73.5 | 12.75 | 2001-11-15 14:38:00
 | NG H2 | 280 | 76 | 76.5 | 65.4 | 65.8 | 11.55 | 2001-11-15 14:38:00
 | NG J2 | 280 | 71.5 | 73.5 | 54.6 | 56.2 | 9.75 | 2001-11-15 14:38:00
 | NG K2 | 285 | 74 | 76 | 50.1 | 51.5 | 9.1 | 2001-11-15 14:38:00
 | NG M2 | 290 | 80 | 83 | 48.8 | 50.6 | 9.06 | 2001-11-15 14:38:00
 | NG N2 | 295 | 87 | 91 | 48.9 | 51.2 | 9.28 | 2001-11-15 14:38:00
 | NG Q2 | 300 | 94 | 98 | 48.9 | 51 | 9.42 | 2001-11-15 14:38:00
 | NG U2 | 305 | 99 | 104 | 48 | 50.5 | 9.44 | 2001-11-15 14:38:00
 | NG V2 | 305 | 105 | 110 | 48.7 | 51.1 | 9.57 | 2001-11-15 14:38:00
 | NG X2 | 325 | 117 | 123 | 48.7 | 51.3 | 10.22 | 2001-11-15 14:38:00
 | [NAME] | 345 | 127 | 134 | 48.2 | 50.9 | 10.75 | 2001-11-15 14:38:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: sally_beck__35194__EGM_MgmtSum-Q4-1019
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-12-01 00:00:00 | 4TH QUARTER 2000 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Liquids |  |  | 6246
COAL | Coal |  |  |  |  |  | McKinsey study expenses transferred to Transportation
SO2 | Emissions |  |  |  |  |  | Nox Tech R&D Project
WEATHER | Weather
INSURANCE | Global Risk Markets
ECT_INV_IRFX | Financial Trading
 | Transportation |  |  | 0 |  |  | McKinsey study
 | Office of the Chairman |  | 350 | 0
 | Subtotal
 | LNG |  | 1377 | 1385
 | Middle East |  | 1538 | 1536
 | Puerto Rico |  | 615 |  |  |  | Development expenses under plan
 | Subtotal Commercial
 | Total
 | Group |  |  | 26030 |  |  | Unplanned IT and legal expenses
 | Other Interest Related Charges |  | 0 | 0
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
Spreadsheet: 151246d1334839977-show-top-salesmen-from-dynamic-range-slashdottopten
Sheet: Sheet1

S.no | [NAME] | Zone | Sales |  |  |  |  | IN THIS FORMAT
1 | [NAME] | A | 75 |  |  |  |  | TOP Sales Men by Sales
2 | Angie | C | 83 |  |  |  |  | S.No | Sales person name here | sales
3 | Anne | A | 150 |  |  |  |  | 1 | xxx | xxx
4 | [NAME] | B | 25 |  |  |  |  | 2 | xxx | xxx
5 | Mairi-Claire | B | 15 |  |  |  |  | 3 | xxx | xxx
6 | [NAME] | C | 225
Spreadsheet: 162784d1340060664-copy-of-managers-clients-info-from-master-list-database-example
Sheet: FT

Name | SSN | CAT | VASH | Refer Date | [NAME] | Exit Date | Recert Date | Exit Date | Recert Date | Exit Date | Case Mgr | Referral Source | M/F | OIF/ OEF | Spouse | # M Dep | # F Dep | Total # Dep | Total # M | Total # F | Total Household | Spouse Disabled | Child >18 Disabled | <30% AMI | Chronically Homeless | Comments
Work Space Here
Mirror Active (no exited dates) clients here for just [NAME]
Spreadsheet: 9a0816ce-f5eb-4ee8-98b8-6cc7e486d682
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Water Services
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2008-08-22 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 8200 |  | 807771 |  | B |  | 82000070 |  | 254361.62 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 254361.62
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2008-08-22 00:00:00 |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 8200 |  | 807771 |  | 611060 |  | 82000070 |  | 254361.62 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 254361.62
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 107094d1304289714-vlookup-with-concatenate-excel-help
Sheet: Sheet3

Course | Sect | CRN |  |  | Concatenated
6001 | 1
6001 | 2
6001 | 3
6001 | 4
6001 | 5
6001 | 6
6001 | 7
6001 | 8
9001 | 1
9001 | 2
9001 | 3
9001 | 4
9001 | 5
9001 | 6
9001 | 7
9001 | 8
Spreadsheet: 174330d1345025332-vlookup-with-drop-down-functionality-vlookup-with-a-drop-down-menu
Sheet: Plan

 |  | 2012 | 2012 | 2012 | 2012
Product |  | Jan | Feb | Mar | Apr
Product A | Plan Units | 10 | 20 | 30 | 40
Product B | Plan Units | 30 | 20 | 40 | 10
Product C | Plan Units | 20 | 25 | 35 | 25
Product D | Plan Units | 26 | 24 | 26 | 26
Product A | Plan Value | 400 | 500 | 600 | 700
Product B | Plan Value | 123 | 654 | 50 | 800
Product C | Plan Value | 1254 | 256 | 235 | 567
Product D | Plan Value | 235 | 569 | 5674 | 465
Spreadsheet: 837841d1690459946-lookup-last-values-from-list-lookup-last-figure
Sheet: Sheet1

Company | Invoice Value |  |  |  |  |  | SEPARATE SHEET
ABC | 100 |  |  |  |  |  | ABC | FORMULA that provides the last value in the list in Column A
PLN | 150 |  |  |  |  |  | PLN | e.g. 844
TRG | 200 |  |  |  |  |  | TRG | 583
LGB | 44 |  |  |  |  |  | LGB | 568
MND | 220 |  |  |  |  |  | MND | 967
TPO | 641 |  |  |  |  |  | TPO | etc
WRE | 109 |  |  |  |  |  | WRE | etc
ABC | 120 |  |  |  |  |  | ABC | etc
FTR | 346 |  |  |  |  |  | FTR | etc
ABC | 943
PLN | 266
TRG | 221
LGB | 330
MND | 405
TPO | 669
WRE | 787
ABC | 224
FTR | 651
ABC | 570
PLN | 844
TRG | 583
LGB | 568
MND | 967
TPO | 504
WRE | 303
ABC | 964
FTR | 723
Spreadsheet: 74413d1274929211-show-row-of-data-from-a-selection-in-a-list-box-project-data-with-combo-box
Sheet: A

 |  |  | Project ID | Project Name | Start Date | End Date
 |  |  | I used the INDEX formula to return the row of data.
 |  |  | Here's my attempt at a semantic explanation.
 |  |  | INDEX(array,row_num,[column_num])
 |  |  | array = | "project_list":   this is the name that I gave to the table (A2:D11)
 |  |  | row_num = | "list_value":  this is the name of the cell that serves as the "Cell Link" for the combo box
 |  |  |  | Each item in the combo box has it's own row number, and as luck would have it,
 |  |  |  | that row number corresponds to the row on the table "project_list" on which that item lives
 |  |  | column_num = | the column number on table "project_list" where the corresponding project data live
 |  |  | So, what I’m asking with this formula is:
 |  |  | Go to the table that I named project_list, then go to the row (list_value) that matches my selection, and give me the value from the column number I entered
Spreadsheet: 62829d1263836345-is-this-type-of-copy-even-possible-test4-1-
Sheet: HRS

Sub | SOP Name | Identifier | Responsible | Due Date | Authored | Approved | Submitted
DATA207 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA208 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA209 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA210 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA211 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA212 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA213 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA214 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA215 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA216 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA217 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA218 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA219 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA220 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA221 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA222 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA223 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA224 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA225 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA226 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA227 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA228 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA229 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA230 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA231 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA232 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA233 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA234 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA235 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA236 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA237 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA238 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA239 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA240 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA241 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
Spreadsheet: 47380d1246413515-conditional-maximum-and-cancatenate-value-return-conditional-max-and-concatenate-concatif-
Sheet: Sheet1

Name | Value | Function | Function
A | 3 | 5 | 3,5
A | 5
B | 6 | 6 | 6,4,3,1
B | 4
B | 3
B | 1
B | 3
C | 7 | 7 | 7,4,6
C | 4
C | 6
D | 5 | 5 | 5
E | 9 | 9 | 9,4
E | 4
G | 3 | 3 | 3
G | 3
Spreadsheet: 703765d1605167650-use-formulas-to-show-visibility-of-employees-shift-visibility-test
Sheet: Final Table Manual

Data Entry | Sales | After Sales Care |  |  | Data Entry | Sales | After Sales Care
Approach 1.  Combine Shift & ToT |  |  |  |  | Approach 2.  [NAME] with format change
Spreadsheet: 820485d1678122931-product-percentages-based-on-a-date-criteria-sample-sheet
Sheet: Sheet1

 |  | Year | increase | First | Last
 |  | 2022 | 0.031
 |  | 2021 | 0.005
 |  | 2020 | 0.017
 |  | 2019 | 0.024
 |  | 2018 | 0.03
 |  | 2017 | 0.01
 |  | 2016 | 0
 |  | 2015 | 0.012
 |  | 2014 | 0.027
 |  | 2013 | 0.022
 |  | 2012 | 0.052
 |  | 2011 | 0.031
 |  | 2010 | 0
 |  | 2009 | 0.05
 |  | 2008 | 0.039
 |  | 2007 | 0.036
 |  | 2006 | 0.027
 |  | 2005 | 0.031
 |  | 2004 | 0.028
 |  | 2003 | 0.017
 |  | 2002 | 0.017
 |  | 2001 | 0.033
 |  | 2000 | 0.011
 |  |  |  |  |  |  |  |  | Task: instead of having to break down the criteria in columns E,F and [NAME] And instead of using a shift+ctrl+enter cell with product. I want to use an aggregate formula that take criteria from anything within or equal to the date ranges and the products those percentage increase. Output should be 1.0834
 |  | Date Lower Range |  | 2016 |  | Desired output
 |  | Date Upper Range |  | 2020
 |  |  |  |  |  | Failed attempt
Spreadsheet: 34467d1231772254-how-can-i-check-a-4-column-range-for-a-particular-number-copy
Sheet: DATA Download

 |  |  | Line nbr | Dept | Division | Sub | ET Mo | Page Line | Employee  Name | Employee  ID | Title | Period   End Date | DOS | Time | Rate Type | Pay  Rate | A J | Gross    Earnings | Total    Benefits | GSTR/ IAPOF | OASDI/ ME
 |  |  | 1 | 444941 | 99999 | '0 | '0901 | 2075301 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-07-31 00:00:00 | REG | 0.5 | %
 |  |  | 3 | 444941 | 99999 | '0 | '0902 | 2158201 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-08-31 00:00:00 | REG | 0.5 | %
 |  |  | 5 | 444941 | 99999 | '0 | '0903 | 2148701 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-09-30 00:00:00 | REG | 0.5 | %
 |  |  | 4 | 444941 | 99999 | '0 | '0904 | 2181701 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-10-31 00:00:00 | REG | 0.5 | %
 |  |  |  | 444941 | 99999 | '0 | '0905 | 2241001 | Doright, [NAME] | 0Z12345678 | 3257 | 2008-11-30 00:00:00 | REG | 0.5 | %