tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167555d1342024507-find-specific-text-in-text-string-and-return-value-in-adjacent-column-forum-example
Sheet: RADCOM

FILE NAME | DATE CREATED
250706031 98W035506.txt | 2008-05-24 00:00:00
251740308 93W038302 03A748881.txt | 2008-05-24 00:00:00
251965603 95W014904 95A100322.txt | 2008-05-24 00:00:00
258200512 94W025279.txt | 2008-05-24 00:00:00
259890460 97A294999.txt | 2008-05-24 00:00:00
259956861 96W131999.txt | 2008-05-24 00:00:00
480659309 01W016618.txt | 2008-05-24 00:00:00
480659309 99W025750.txt | 2008-05-24 00:00:00
754709894 03A249308.txt | 2008-05-24 00:00:00
827499547 99A814415.txt | 2008-05-24 00:00:00
816739132 97W002200 96A191971.txt | 2008-07-15 00:00:00
256096426 99W024006.txt | 2008-09-02 00:00:00
000000000 000000000 000000000.txt | 2008-11-14 00:00:00
000000000 000000000 05A157602.txt | 2008-11-14 00:00:00
000000000 90767292  02A200456.txt | 2008-11-14 00:00:00
000000000 96W140734 96A157277.txt | 2008-11-14 00:00:00
000000000.txt | 2008-11-14 00:00:00
000000100 02W022854 02A177515.txt | 2008-11-14 00:00:00
000001004 01W027164 01A170948.txt | 2008-11-14 00:00:00
00000CIS5 01M204891.txt | 2008-11-14 00:00:00
Spreadsheet: 66797d1267482512-summing-totals-of-quantities-test-spreadsheet
Sheet: Lists

Action | Model | [NAME] | Cost | Category
New H/P Desktop |  |  | 2000 | ND
New H/P Laptop |  |  | 2500 | NL
New Laptop |  |  | 2000 | NL
New Desktop |  |  | 1500 | ND
New Sec Laptop |  |  | 3000 | NL
Repurposed Laptop |  |  | 80 | RL
Repurposed Desktop |  |  | 80 | RD
Low End Server |  |  | 2000 | LS
Mid Range Server |  |  | 3000 | MS
Spreadsheet: 726589d1617306982-excel-lookup-value-and-modify-value-of-another-cell-slynch51-example
Sheet: Sheet1

Training Information | ID
CH | 11
R | 11
Training | 11
CH | 43
R | 43
Training | 43
R | 56
Training | 56
CH | 66
R | 66
Training | 66
CH | 76
R | 76
Training | 76
R | 88
Training | 88
I need to run a formula on a very big data set where it will automtically take the above and display what is below
Training Information | ID
CH | 11
R | 11
Training - CH | 11
CH | 43
R | 43
Training - CH | 43
R | 56
Training - R | 56
CH | 66
R | 66
Training - CH | 66
CH | 76
R | 76
Training - CH | 76
R | 88
Training - R | 88
Spreadsheet: 763211d1642054622-formula-to-calculate-cost-and-price-calc-1-
Sheet: Sheet1

[NAME] | cost | % | price 1 | price 2 | price 3 | profit
123456 | 50
123457 | 20
123458 | 100
Spreadsheet: tracy_geaccone__40317__2002 Capital by month
Sheet: MD

2002 Capital by Month
company | function | project # | project name | total $'s | inservice | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
MD
 | Allocations from other pipelines
 | 2002 | Class [NAME] |  | 0.003 | 2002-04-01 00:00:00
 | 2002 | comp | OPS | 0.003 | 2002-06-01 00:00:00
 | 2002 | Dot | ops | 0.001 | 2002-04-01 00:00:00
 | 2002 | sale fac | ops | 0.003 | 2002-09-01 00:00:00
 | 2002 | pipe data | ops | 0.013 | 2002-12-01 00:00:00
 | 2002 | Blanket - Field | ops | 0.026
Total 2002
Marketing
 | 2002 | Elect [NAME] Fil | Rates | 0.001 | 2002-06-01 00:00:00
Total Marketing
Gas Logistics
 | 2002 | Shared CRM & Tele | GL | 0.013 | 2002-06-01 00:00:00
 | 2002 | Shared HotTap Redesign | GL | 0.005 | 2002-06-01 00:00:00
Total Gas Logistics
Spreadsheet: 749162d1632551011-display-list-of-new-or-updated-rows-in-a-list-copy-of-update
Sheet: Sheet1

Title | PartID | Location | Price | Image [image] | Image2 [image2] | Image3 [image3] | Description | Quantity | Category
SamplePart1 | 1 | [NAME] | 0.04 |  |  |  | SampleDes1 | 500 | 0
SamplePart20 | 20 | LOC20 | 1.25 |  |  |  | SampleDes20 | 999
SamplePart21 | 21 | LOC21 | 5.21 |  |  |  | SampleDes21 | 888
Spreadsheet: c52a85d6-663f-4a3e-b036-fb9d4395d474
Sheet: Operating

OPERATING/PROGRAMMATIC
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Inclusive Access to Recreation Grant
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2010-11 |  |  | FY 2011-12
 | General Fund |  |  | $ |  |  | $
 | Special Revenue |  |  |  | 59250
 | Enterprise
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known or, if grant revenue, please identify source of funds (federal or state) and duration of grant support.)
 | The Revenue comes from EITAS Grant reimbursement
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2010-11 |  |  | FY 2011-12
 | Expenditure Account
 | General Fund |  |  | $ |  |  | $
 | Special Revenue |  |  |  | 59250
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | This appropriation has been requested for the grant period 2010-11; No additional staff, but a one year contract (grant funded)
 | with UMKC for program evaluation will be initiated.  Facilities used will be the Parks and Recreation's Community Centers and
 | related faclities.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | No |  | X | Yes
 | (Please detail estimated number of people to be served, who is currently delivering services to that population, service
 | performance expectations and, if grant supported, provisions for support if grant support ends.)
 | By year one of the grant, it is estimated that more than 100 persons with disabilities and their families will be served.  The [NAME]
 | and Recreation Department will be the only City Department providing Inclusive Recreation Programming experiences.  Performance
 | expectations are that staff will be adequately trained to work with persons with disabilities, individualized accommodations will
 | be provided to persons with disabilities, opportunities to try out a range of activities, collaborative partnerships with other
 | agencies will be created.  All of which will create sustainable environments for persons with disabilities in city programs.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
0ffice of Management and Budget |  |  |  |  |  | OMB Approval Date
Spreadsheet: 32f42d0f-3972-4e0c-b8f3-fcf9b03af32c
Sheet: excel

2014 MODEL RENTAL REPURCHASE AND RISK PROGRAM
Account Name: |  |  |  |  |  | Customer FIN Code:
Date: |  |  |  |  |  | Contact Name:
This Delivery Request does not constitute a delivery guarantee; however, we will make every effort to fulfill this request.
Requested "Production" Month
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG
FORD
C-MAX HYBRID (HEV & PHEV)
EDGE
ESCAPE
E-SERIES VAN
E-SERIES WAGON
EXPEDITION
EXPLORER
F150 (REG./SUPER CAB)
F-SERIES SUPER CREW
FIESTA
FLEX
FOCUS
FUSION
FUSION HYBRID (HEV & PHEV)
MUSTANG COUPE
MUSTANG CONV
SUPER DUTY (Risk Only)
TAURUS
TRANSIT CONNECT
Total
LINCOLN
MKS
MKT
MKX
MKZ
NAVIGATOR
Total
GRAND TOTAL
Shaded cells indicate 2015 Model Year production 1
Shaded cells indicate 2013 Model Year production
For those accounts ordering E-Series Pass Wagons (E1B and S3B), recognize that although every effort is made to accommodate your requested scheduling dates, demand consistently exceeds supply during the months of April and May.  Ford reserves the right to schedule E-Series Passenger Wagons up to 3 weeks prior to OR 3 weeks later than the requested production dates.
1  Dates are subject to change.  Latest updates to this plan will be posted on www.fleet.ford.com, under the Ordering Center tab:                                                                               Final Build Date/First Build Date by Model Year.
Spreadsheet: 168716d1342548711-cell-automation-sheet-oeldere-
Sheet: Sheet1

 |  |  | 1 |  |  |  |  |  |  |  | 2
 |  |  | DATE | ITEM | PRIZE |  |  |  |  |  | DATE | ITEM | PRIZE
 |  |  | 2012-02-05 00:00:00 | PEPPER | 43 |  |  |  |  |  | 2012-02-05 00:00:00 | PEPPER | 43
 |  |  | 2012-02-06 00:00:00 | old | 12
 |  |  | 2012-12-07 00:00:00 | bew | 6
Spreadsheet: 221553d1363611170-using-autofilter-with-header-cells-locked-and-worksheet-protected-sample
Sheet: Sheet1

This space is taken up by instructions and other information in my spread sheet, so any coding would need to start at A8.
W/c | Date | Account number | Customer name | Sales order | Code | Feedback required | Feedback | Account Mngr | [NAME] | Action | Action owner | Action taken | Action by
2012-12-31 00:00:00 | 2013-01-01 00:00:00 | 123456 | Customer 1 | 123 | A11 | Ask why | Late arrival | A.N.Other | [NAME] | Reschedule | Customer Service | Yes | Customer Service
2013-01-07 00:00:00 | 2013-01-08 00:00:00 | 456789 | Customer 2 | 456 | B21 | Ask who | Customer | A.N.Other | [NAME] | Reschedule | Customer Service
2013-01-14 00:00:00 | 2013-01-15 00:00:00 | 789123 | Customer 3 | 789 | C31 | Ask when | Monday | A.N.Other | [NAME] | Reschedule | Customer Service | Yes | Customer Service
2013-01-21 00:00:00 | 2013-01-22 00:00:00 | 147258 | Customer 4 | 147 | D41 | Ask why | Parcel too big | S.Omeone Else | [NAME] | Reschedule | Customer Service
2013-01-28 00:00:00 | 2013-01-29 00:00:00 | 258369 | Customer 5 | 258 | E51 | Ask who | Company | S.Omeone Else | [NAME] | Reschedule | Customer Service | Yes | Customer Service
Spreadsheet: 865491d1712576482-how-to-look-up-both-vertically-and-horizontally-together-not_excel-ing-quote-help
Sheet: Solution

Lookup Section
 | 2023/24 | 2024/25 | 2025/26 | 2026/27 | 2027/28 | 2028/29 | 2029/30
Type1 | 12840 | 13353.6 | 13887.744 | 14443.25376 | 15020.9839104 | 15621.823266816 | 16246.69619748864
Type2 | 12840 | 13353.6 | 13887.744 | 14443.25376 | 15020.9839104 | 15621.823266816 | 16246.69619748864
[NAME] | 17610 | 18314.4 | 19046.976 | 19808.85504 | 20601.2092416 | 21425.257611264 | 22282.26791571456
Type4 | 17610 | 18314.4 | 19046.976 | 19808.85504 | 20601.2092416 | 21425.257611264 | 22282.26791571456
Type5 | 17610 | 18314.4 | 19046.976 | 19808.85504 | 20601.2092416 | 21425.257611264 | 22282.26791571456
Type6 | 24165 | 25131.6 | 26136.864 | 27182.33856 | 28269.6321024 | 29400.417386496 | 30576.43408195583
Type7 | 24165 | 25131.6 | 26136.864 | 27182.33856 | 28269.6321024 | 29400.417386496 | 30576.43408195583
Type8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Type9 | 12840 | 13353.6 | 13887.744 | 14443.25376 | 15020.9839104 | 15621.823266816 | 16246.69619748864
Type10 | 24165 | 25131.6 | 26136.864 | 27182.33856 | 28269.6321024 | 29400.417386496 | 30576.43408195583
Results that should be displayed.
2024/25 | 2025/26 | 2026/27 | 2027/28
Type1 | Type2 | [NAME] | Type10
0 | 0 | 0 | 0
0 | 0 | 0 | 0
13353.6 | 13887.744 | 19808.85504 | 28270
Spreadsheet: 837713d1690375520-calculate-top-7-team-points-and-sort-by-scores-2023-gacx-results-work
Sheet: ELKS

# | Place | Category | First Name | Last Name | Team Name | USAC License # | Series Pts | [NAME] | [NAME] | Field pts | Upgrade | 30min |  | 45min |  |  | 5< | 2019-05-10 00:00:00 | 2019-11-20 00:00:00 | 21-35 | 36-60 | 61-80 | 81+
510 |  | Men 5 | [NAME] | Tingle |  | 642558 |  |  |  |  |  | 30 |  | 60 |  |  |  | 3 | 4 | 5 | 8 | 10 | 11
515 |  | Men 5 | Mason | [NAME] | [NAME] | 603791 |  |  |  |  |  | 27 |  | 54 |  |  |  | 2 | 3 | 4 | 6 | 8 | 10
504 |  | Men 5 | Grant | Deckers |  | 632059 |  |  |  |  |  | 24 |  | 48 |  |  |  | 1 | 2 | 3 | 5 | 7 | 9
511 |  | Men 5 | Kit | Plummer | MACC RACING | 410979 |  |  |  |  |  | 21 |  | 42 |  |  |  |  | 1 | 2 | 4 | 6 | 8
501 |  | Men 5 | [NAME] | [NAME] | Women’s Health Professionals race team | 531997 |  |  |  |  |  | 19 |  | 38 |  |  |  |  |  | 1 | 3 | 5 | 7
641 |  | Women 5 | [NAME] | Drennen |  | 570933 |  |  |  |  |  | 17 |  | 34 |  |  |  |  |  |  | 2 | 4 | 6
643 |  | Women 5 | Ryann | [NAME] |  | 616125 |  |  |  |  |  | 15 |  | 30 |  |  |  |  |  |  | 1 | 3 | 5
642 |  | Women 5 | Mina | [NAME] | [NAME] |  |  |  |  |  |  | 13 |  | 26 |  |  |  |  |  |  |  | 2 | 4
108 |  | Masters 40+ 1/2/3/4 | Nathan | Sibly | Nomad Cycling Services | 32594 |  |  |  |  |  | 12 |  | 24 |  |  |  |  |  |  |  | 1 | 3
107 |  | Masters 40+ 1/2/3/4 | Reny | Townsend | Gulo Composite | 625328 |  |  |  |  |  | 11 |  | 22 |  |  |  |  |  |  |  |  | 2
106 |  | Masters 40+ 1/2/3/4 | Scott | [NAME] |  | 165565 |  |  |  |  |  | 10 |  | 20 |  |  |  |  |  |  |  |  | 1
104 |  | Masters 40+ 1/2/3/4 | [NAME] | DeRose | Force ATL | 145540 |  |  |  |  |  | 9 |  | 18
117 |  | Masters 40+ 1/2/3/4 | [NAME] | Holt | Team Type 1 | 63559 |  |  |  |  |  | 8 |  | 16
Spreadsheet: kam_keiser__17867__E&Y Form A
Sheet: Form B

All suggested threshold levels on the following forms are for placeholder purposes only.  Final buckets to be determined following more in-depth analysis.
Enron and Affiliates
[NAME] as of:_____________
Commodity:___________ |  |  | Date of Preparation:________
Legal Entity:___________
Statistic | Terminated |  | Non-Terminated |  | Total
 | Financial | Physical | Financial | Physical
Estimated MTM 1 ($)
# of Counterparties
Counterparty Distribution by MTM 2 (#)
<$0mm
>=$0mm, <$1mm
>=$1mm, <$5mm
>=$5mm, <$10mm
>=$10mm
# of Transactions
Transaction Distribution by MTM (#)
<$0mm
>=$0mm, <$1mm
>=$1mm, <$5mm
>=$5mm, <$10mm
>=$10mm
Tenor Distribution by Transactions (#)
< 1 year
>=1 year, <3 years
>=3 years, <5 years
>=5year, <10 years
>= 10 years
Tenor Distribution by MTM ($)
< 1 year
>=1 year, <3 years
>=3 years, <5 years
>=5year, <10 years
>= 10 years
Enron Continued Performance 3
Trade Type Distribution by Transactions (#)
Nymex look alike forward
Nymex look alike option
Basis Swap
Others 4
Trade Type Distribution by MTM ($)
Nymex look alike forward
Nymex look alike option
Basis Swap
Others 4
Notes
* Additional forms for each commodity should be labeled as Form B1, Form B2, etc.
1 MTM ([NAME]-to-Market Value) reflects no adjustment for Collateral or Accounts Payable/Receivable
2  < indicates less than, >= indicates greater than/equal to
3  The number of non-terminated contracts under which is Enron still performing to the counterparty
4 To be expanded depending on the underlying commodity
Spreadsheet: 220972d1363338182-finding-the-maximum-row-based-on-a-non-duplicate-rule-max-row-if
Sheet: Sheet1

REFERENCE NO | NAME | CONDITION |  |  |  | MAX ROW IF | CONDITION
313 | [NAME] | True |  |  | [NAME] |  | True
224 | [NAME] | True |  |  | [NAME] |  | True
153 | [NAME] | False |  |  | STEVE |  | True
244 | STEVE | False
321 | [NAME] | True |  |  |  | I REQUIRE THE MAX ROW IF COLUMN A DOES NOT CONTAIN A DUPLICATE VALUE
443 | [NAME] | False |  | EG | [NAME] | 0 | <<<   0 because Row 3 and 8 has a duplicate Row "Reference no".
313 | [NAME] | True
332 | STEVE | True
123 | STEVE | True
Spreadsheet: 884445d1733594797-transpose-alphanumeric-lists-match-lists
Sheet: Themes

Company Name | Ticker | Theme | Subtheme |  |  |  | Digitalisation* | AI | Cloud | Cybersecurity | Software | Infrastructure | Energy transition | Utilities | EVs | Renewables | Miners | Infrastructure | Demographic change | Healthcare | Consumer discretionary | Multipolarity | Reshoring | Defence
Alibaba Group Holding Ltd | 9988 HK | Digitalisation | AI |  |  | TICKER_AND_EXCH_CODE
Alibaba Group Holding Ltd | 9988 HK | Digitalisation | Cloud |  |  | 1299 HK
Alibaba Group Holding Ltd | 9988 HK | Digitalisation | Infrastructure |  |  | 9988 HK
Alibaba Group Holding Ltd | 9988 HK | Energy transition | EVs |  |  | 3319 HK
Alibaba Group Holding Ltd | 9988 HK | Energy transition | Infrastructure |  |  | 2020 HK
Alibaba Group Holding Ltd | 9988 HK | Multipolarity | Reshoring |  |  | BHARTI IN
Alibaba Group Holding Ltd | 9988 HK | Multipolarity | Defence |  |  | 3998 HK
AIA Group Ltd | 1299 HK | Demographic change | Healthcare |  |  | 293 HK
AIA Group Ltd | 1299 HK | Demographic change | Consumer discretionary
A-Living Smart City Services Co Ltd | 3319 HK | Digitalisation | Infrastructure
ANTA Sports Products Ltd | 2020 HK | Demographic change | Consumer discretionary
Bharti Airtel Ltd | BHARTI IN | Digitalisation | Infrastructure
Bosideng International Holdings Ltd | 3998 HK | Demographic change | Consumer discretionary
Cathay Pacific Airways Ltd | 293 HK | Demographic change | Consumer discretionary
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg22

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Drip Zone 27 (N) |  | Field Name: |  | Drip Zone 28 (N) |  | Field Name: |  | Drip Zone 29 (N) |  | Field Name: |  | Drip Zone 30 (N)
 |  |  |  |  |  | Area (acres): |  | 8.02 |  | Area (acres): |  | 17.09 |  | Area (acres): |  | 10.25 |  | Area (acres): |  | 0
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 31.3 |  | Annual Rate (in): |  | 24.6 |  | Annual Rate (in): |  | 25.1 |  | Annual Rate (in): |  | 0
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 37410d1235421610-pulling-data-from-a-cell-location-based-upon-two-inputs-axis-choices-in-a-data-table-heating_load_change_problem
Sheet: Sheet1

 |  | data: | example:
 | X Value: |  | 6
 | Y Value |  | 63
 | Output: |  | 0.2445
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | 70 | 0.0374 | 0.0741 | 0.1102 | 0.1456 | 0.1803 | 0.2142 | 0.2474 | 0.2799 | 0.3116
 | 69 | 0.0381 | 0.0756 | 0.1124 | 0.1484 | 0.1837 | 0.2181 | 0.2519 | 0.2849 | 0.317
 | 68 | 0.039 | 0.0772 | 0.1146 | 0.1513 | 0.1871 | 0.2223 | 0.2565 | 0.29 | 0.3227
 | 67 | 0.0397 | 0.0787 | 0.1169 | 0.1542 | 0.1907 | 0.2264 | 0.2612 | 0.2952 | 0.3284
 | 66 | 0.0406 | 0.0804 | 0.1192 | 0.1572 | 0.1944 | 0.2306 | 0.266 | 0.3007 | 0.3346
 | 65 | 0.0414 | 0.0819 | 0.1215 | 0.1603 | 0.198 | 0.2349 | 0.271 | 0.3064 | 0.3409
 | 64 | 0.0422 | 0.0836 | 0.124 | 0.1634 | 0.2019 | 0.2395 | 0.2764 | 0.3124 | 0.3474
 | 63 | 0.0432 | 0.0854 | 0.1265 | 0.1667 | 0.206 | 0.2445 | 0.2821 | 0.3186 | 0.3541
 | 62 | 0.0441 | 0.0871 | 0.1291 | 0.1702 | 0.2104 | 0.2497 | 0.2887 | 0.3249 | 0.3609
 | 61 | 0.045 | 0.089 | 0.1319 | 0.174 | 0.2151 | 0.255 | 0.2938 | 0.3315 | 0.3683
 | 60 | 0.046 | 0.0911 | 0.1351 | 0.1781 | 0.2199 | 0.2605 | 0.3 | 0.3385 | 0.3759
 | 59 | 0.0472 | 0.0934 | 0.1385 | 0.1823 | 0.2248 | 0.2662 | 0.3066 | 0.3458 | 0.3836
 | 58 | 0.0485 | 0.0958 | 0.1418 | 0.1865 | 0.2299 | 0.2723 | 0.3134 | 0.353
 | 57 | 0.0497 | 0.098 | 0.145 | 0.1906 | 0.2352 | 0.2784 | 0.3201
 | 56 | 0.0509 | 0.1003 | 0.1483 | 0.1952 | 0.2406 | 0.2845
 | 55 | 0.0521 | 0.1027 | 0.1521 | 0.1999 | 0.2462
Spreadsheet: 020b1087-5be6-489a-aa1f-70297ca3c691
Sheet: Labor

Schedule E - Labor Rates
Item # | Item | Year | Engineering | Installer | Technician
 | Hourly Labor Rate | 1 | 75.88 | 43.78 | 46.7
 |  | 2 | 77.4 | 44.66 | 47.63
 |  | 3 | 78.94 | 45.55 | 48.58
 |  | 4 | 80.52 | 46.46 | 49.55
 |  | 5 | 82.13 | 47.39 | 50.54
 | Overtime Labor Rate | 1 |  | 59.76 | 63.74
 |  | 2 |  | 60.95 | 65.01
 |  | 3 |  | 62.17 | 66.31
 |  | 4 |  | 63.42 | 67.64
 |  | 5 |  | 64.69 | 68.99
Spreadsheet: 99629d1298243511-distribute-value-by-hour-excel-forum-example-10
Sheet: EX Upload

Number to Distrib | Hours to Distrib |  | Distribution Method
1000 | 4 |  | 0.1 | over the first 25% of  A2
 |  |  | 0.5 | over the middle 50% of A2
 |  |  |  | over the last 25% of A2
 | HELP! |  |  | Must be one
Hour | A2 Distributed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
1 | ? |  |  |  | Portion of Time | [NAME]
2 | ? |  |  | 0.25
3 | ? |  |  | 0.5
4 | ? |  |  | 0.25
5
6
7
EXPECTED RESULT WITH EASY EXAMPLE
Number to Distrib | Hours to Distrib |  | Distribution Method
1000 | 4 |  | 0.25 | over the first 25% of the time.
 |  |  | 0.5 | over the middle 50% of the time.
 |  |  |  | over the last 25% of the time
 |  |  |  | Must be one
Hour | A2 Distributed
1 | 250
2 | 250
3 | 250
4 | 250
5
6
7
 |  | This will always = 1000
Spreadsheet: 137159d1326982700-help-with-sumif-function-with-multiple-crieteria-problem-example
Sheet: Sheet1

 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
2010-09-01 00:00:00 | 1 | 2 | 3 | 1 | 1 | 4 | 1 | 6 | 2 | 4 | 5 | 9
2010-02-01 00:00:00 | 2 | 4 | 6 | 2 | 2 | 8 | 2 | 12 | 4 | 8 | 10 | 18
2010-07-01 00:00:00 | 6 | 12 | 18 | 6 | 6 | 24 | 6 | 36 | 12 | 24 | 30 | 54
if the month is sept 10, take the count of July 10 and aug 10 and add them together, this is the before sept 10 of 60 days (7)
if the month is sept 10, take the count of Oct 10 and Nov 10 and add them together, this is the After sept 10 of 60 days (9)
Spreadsheet: 537134d1504824445-sorting-and-copying-to-a-new-sheet-based-on-values-copy-of-example-jacko2stars-
Sheet: Grades

Grades
A | -5
B | -4
C | -3
D | -2
0 | -1
0.5 | -0.5
F | 0
F.5 | 0.5
1 | 1
1.5 | 1.5
2 | 2
2.5 | 2.5
3 | 3
3.5 | 3.5
4 | 4
4.5 | 4.5
5 | 5
5.5 | 5.5
6 | 6
6.5 | 6.5
7 | 7
Spreadsheet: 830776d1685099039-expected-outcome-based-on-4-criteria-based-on-all-4-filters-sample-workbook
Sheet: Sheet1

Empolyee Name | Designation | Manager 1 | Manager 2 | Manager 3 | Status
A | Accountant | ABC | [NAME] | Swathi | Active
B | Financial Accountant | DEF | [NAME] | Swathi | Active
C | Analyst | GHI | [NAME] | Swathi | Active
D | Sr. Analyst | JKL | Sathish | Surya | Terminated
E | Coordinator | MNO | Keshav | Surya | Active
F | Sr. Financial Accountant | PQR | Gaurav | Surya | Active
G | Accountant | STU | Raghu | Surya | Terminated
H | Intern | VWX | [NAME] | Surya | Active
Expected outcome
Manager 3 | Swathi
Manager 2 | (All)
Manager 1 | GHI
Status | (All)
Empolyee Name | Designation | Manager 1 | Manager 2 | Manager 3 | Status
C | Analyst | GHI | [NAME] | Swathi | Active
Spreadsheet: 152850d1335550073-random-table-of-data-need-to-find-every-cell-that-contains-specific-data-random-tables-2
Sheet: Variables

1 | RI |  |  | FA
 | RI |  |  | RI |  | Initials: |  | LM
 | RI |  |  | CR
 | RI |  |  | DR
 | RI |  |  | CH
 | SC |  |  | PO
 | FA |  |  | SC
 | FA |  |  | DC
 | FA |  |  | OS
 | FA
 | FA
 | FA |  |  | Total
 | PO
 | CR
 | CH
 | CH
 | CH
 | DR
 | DR
 | DR
 | OS
 | DC
 | FA
 | FA
 | FA
 | RI
 | CH
 | DC
 | CH
 | RI
Spreadsheet: 09fc0fdf-71a0-4067-98dd-d0f72ac38d8c
Sheet: Sheet1

GIM Middle East Itinerary
 | Su, 17th | M, 18th | T, 19th | W, 20th | R, 21st | F, 22nd | Sa, 23rd
City | Chicago | Bahrain | Bahrain | Bahrain | Bahrain/Oman | Oman | Oman
Flights | D: ORD, 21:20 | A: BAH, 21:55 |  |  | D:BAH, 20:10; A: MCT, 22:40
 | Su, 24th | M, 25th | T, 26th | W, 27th | R, 28th | F, 29th | Sa, 30th
City | Oman/Abu Dhabi | Abu Dhabi | Abu Dhabi/Dubai | Dubai | Dubai | Dubai | Abu Dhabi Chicago
Flights | D: MCT, 23:30; A: AUH, 00:35 |  | bus |  |  |  | D: AUH 10:25; A: ORD 16:30