tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41699f27-af5f-4ed2-b95e-ab95b0a3d93b
Sheet: Sheet1

BID NUMBER: 28-10    Fuel Cards                                                                                                                                                                                                                                                                                                    OPENED: 11-18-10                                              AWARDED: 12-13-10                                                                                                                                                   EXPIRES: 12-12-13                                        1st Renewal Expires:                                         2nd Renewal Expires:                                        3rd Renewal Expires:                                    BOLD AREA INDICATES AWARD | Wright Express            7090 S Union Park Center, Suite 350 Midvale, UT. 84047          PH: [PHONE]          [NAME] | Fleet One                    613 Bakertown Rd. [NAME], TN. 37013          PH: [PHONE]                   FX: [PHONE]                   [NAME] | [NAME] Maryland Way Brentwood, TN. 37027 PH: [PHONE]          FX: [PHONE]          [NAME]
[NAME]
Discounts Offered Off of Pump Price | 1.45% off Total Invoice & Federal Excise Tax | $0.02 per Gallon & Federal Excise Tax | $0.01 - $0.0425 per Gallon & Federal Excise Tax *
Payment Option With Terms | Per Florida State Statutes | Net 30 No Discount | 30/7   .004 Invoice Discount
 |  | Net 15 No Discount | 15/15 .0045 Invoice Discount
 |  |  | 15/7 .010 Invoice Discount
Implementation / Administrative Costs | [NAME] to pay up to $7,500.00 for Implementation. Any costs above $7,500.00 to be paid by HCSO | 0 | 0
Final Invoice Pricing Based on Addendum #1 Gasoline | 22807.5 | 22960 | $22,820.00  30/7                                $22,807.50  15/15                  $22,607.00  15/7
Final Invoice Pricing Based on Addendum #1 Diesel | 22207.5 | 22360 | $22,220.00  30/7                   $22,207.50  15/15                 $22,070.00  15/7
.
Exceptions | $7.50 2nd Day air / $12.50 Overnight on Credit Cards ordered after initial setup shipment
* Discount per gallon offered at specific stations
Spreadsheet: 129362d1321556416-excel-lookup-index-duplicate-data-suggestion
Sheet: Sheet1

names | contact number | duplicate via VLOOKUP
a | 1 | a |  |  | If the VLOOKUP finds the value, return it.  That way you can easily see the duplicates to remove
b | 2 | b
c | 3 | c |  |  | Created a range name for the values on sheet2.  You need the contact number in column 1
d | 4 | d
f | 5 | f
gh | 6 | gh
jk | 7 | jk
l | 8 | l
Spreadsheet: 827007d1682429706-match-multiple-values-and-return-sum-of-multiple-columns-joboperations_sample
Sheet: Last_Operation

WC_CountIf | 1
 |  |  | Remaining Duration
Row Labels | Max of Operation
1980792
441400-001
1 | 25
1983022
441200-001
1 | 25
1993227
430700-001
1 | 20
1993229
430700-001
1 | 20
1993230
430700-001
1 | 20
1993231
430700-001
1 | 20
1993232
430700-001
1 | 20
2014088
1202300-001
4 | 50
2014429
1201000-001
1 | 50
2016148
1401400-001
1 | 10
Grand Total | 50
Spreadsheet: 765435d1643314763-ifs-if-formula-not-returning-values-based-on-logic-within-the-formula-excel-question
Sheet: Sheet1

X | Y | Z
7 | 5 | 10
10 | 5 | 7
10 | 7 | 5
7 | 10 | 5
5 | 10 | 7
5 | 7 | 10
Spreadsheet: 0e079c89-ff94-4fe2-a489-8910d7bccbd0
Sheet: K-5

MENU - K-5
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No or True/False
 |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
Grains (1 oz eq per day)  (7-10 oz eq per week) |  |  |  |  |  |  |  |  |  |  |  |  | Total "Grain" Servings           (Grain servings + MMA sesrvings)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Mt/MA (NOT required) (May count as grain if at least 1 oz eq of grain already being served)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Fruits (1/2 Cup per day) (2 1/2 cups per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
[NAME] (1 Cup per day) (5 per week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Spreadsheet: 765153d1643198018-divide-the-amount-by-a-fixed-number-and-get-the-remainder-data2
Sheet: Sheet1

Code | Amount |  |  | Expected Result |  | 50
101 | 170 |  | 101 | 50
102 | 80 |  | 101 | 50
103 | 40 |  | 101 | 50
104 | 50 |  | 101 | 20
105 | 200 |  | 102 | 50
106 | 101 |  | 102 | 30
 |  |  | 103 | 40
 |  |  | 104 | 50
 |  |  | 105 | 50
 |  |  | 105 | 50
 |  |  | 105 | 50
 |  |  | 105 | 50
 |  |  | 106 | 50
 |  |  | 106 | 50
 |  |  | 106 | 1
Spreadsheet: 840177d1692535916-need-to-calculate-average-over-a-date-range-using-several-variables-dummy-report-v2
Sheet: Sheet1

Date From: | 2022-06-01 00:00:00
Date To: | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2022-10-01 00:00:00 | 2023-04-01 00:00:00
Employee | Target |  | Employee | Date 1 | Pos 1 | Date 2 | Pos 2 | Date 3 | Pos 3 |  | Position | Target 1 | Target 2 | Target 3 | Target 4
Richie |  |  | Richie | 2020-01-01 00:00:00 | Assistant Consultant | 2022-12-01 00:00:00 | Consultant |  |  |  | Director | 5 | 5.5 | 6
Palmer |  |  | Palmer | 2020-01-01 00:00:00 | Director |  |  |  |  |  | Associate Director | 4 | 4.5 | 5
[NAME] |  |  | [NAME] | 2020-01-01 00:00:00 | Senior Consultant | 2023-04-01 00:00:00 | Associate Director |  |  |  | Senior Consultant | 3 | 3.5 | 4
Milligan |  |  | Milligan | 2020-01-01 00:00:00 | Consultant | 2022-08-01 00:00:00 | Senior Consultant | 2023-02-01 00:00:00 | Associate Director |  | Consultant | 2 | 2.5 | 3
 |  |  |  |  |  |  |  |  |  |  | Assistant Consultant | 1 | 1.5 | 2
Spreadsheet: 52458d1252188619-formula-help-for-if-or-len-left-book1
Sheet: Sheet1

EXAMPLE/STEP ONE:
 |  | FORMULA |  | WANT TO DISPLAY
ABC | 123 | 123 |  | 123
BCD | 234 | IT'S BROKEN |  | 234
CDE | 345 | IT'S BROKEN |  | 345
DEF | 456 | IT'S BROKEN |  | 456
EXAMPLE/STEP TWO:
FORWARD & INVERSE PAIRS
ABC | 123 |  |  | 123
BCD | 234 |  |  | 234
CDE | 345 |  |  | 345
DEF | 456 |  |  | 456
CBA | 123 |  |  | 123
BCD | 234 |  |  | 234
EDC | 345 |  |  | 345
FED | 456 |  |  | 456
DATA I'M WORKING WITH:
ABC | 123 |  |  | 123 |  |  | KEY:
ABC | 123AA |  |  | 123 |  |  | ABC & CBA = 123
ABC | 123BB |  |  | 123 |  |  | BCD & DCB = 234
ABC | 123CC |  |  | 123 |  |  | CDE & EDC = 345
ABC | 123DD |  |  | 123 |  |  | DEF & FED = 456
BCD | 234 |  |  | 234
BCD | 234AA |  |  | 234
BCD | 234BB |  |  | 234
BCD | 234CC |  |  | 234
BCD | 234DD |  |  | 234
CDE | 345 |  |  | 345
CDE | 345AA |  |  | 345
CDE | 345BB |  |  | 345
CDE | 345CC |  |  | 345
CDE | 345DD |  |  | 345
DEF | 456 |  |  | 456
DEF | 456AA |  |  | 456
DEF | 456BB |  |  | 456
DEF | 456CC |  |  | 456
DEF | 456DD |  |  | 456
CBA | 123 |  |  | 123
CBA | 123AA |  |  | 123
CBA | 123BB |  |  | 123
CBA | 123CC |  |  | 123
CBA | 123DD |  |  | 123
BCD | 234 |  |  | 234
BCD | 234AA |  |  | 234
BCD | 234BB |  |  | 234
BCD | 234CC |  |  | 234
BCD | 234DD |  |  | 234
EDC | 345 |  |  | 345
EDC | 345AA |  |  | 345
EDC | 345BB |  |  | 345
EDC | 345CC |  |  | 345
EDC | 345DD |  |  | 345
FED | 456 |  |  | 456
FED | 456AA |  |  | 456
FED | 456BB |  |  | 456
FED | 456CC |  |  | 456
FED | 456DD |  |  | 456
Spreadsheet: dc0b8f41-c44a-4386-b675-36d6d9069fee
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-15 09:28:18.710000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.57 | 102.445 | 102.32 | 101.945
4.5 | 101.652 | 101.527 | 101.402 | 101.027 |  | Note: | Refer To Price [NAME]
4.375 | 100.838 | 100.713 | 100.588 | 100.213 |  |  | For all Price Adjs
4.25 | 100.273 | 100.148 | 100.023 | 99.398
4.125 | 99.46 | 99.335 | 99.21 | 98.585
4 | 98.462 | 98.337 | 98.212 | 97.587
3.875 | 97.424 | 97.299 | 97.174 | 96.549
3.75 | 96.549 | 96.424 | 96.299 | 95.674
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.588 | 102.463 | 102.338 | 101.963
3.75 | 102.232 | 102.107 | 101.982 | 101.607
3.625 | 101.827 | 101.702 | 101.577 | 101.202
3.5 | 101.252 | 101.127 | 101.002 | 100.627
3.375 | 100.497 | 100.372 | 100.247 | 99.622
3.25 | 99.694 | 99.569 | 99.444 | 98.819
3.125 | 99.183 | 99.058 | 98.933 | 98.308 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-04-29 09:28:18.710000
30 DAY | 2014-05-14 09:28:18.710000
45 DAY | 2014-05-29 09:28:18.710000
60 DAY | 2014-06-13 09:28:18.710000
90 DAY | 2014-07-13 09:28:18.710000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 674657d1587978567-fill-automatically-the-fields-quadro
Sheet: 2

 |  | date | Number | type | payment | value |  |  | date | Number | type | payment | value |  |  | date | Number | type | payment | value |  |  | date | Number | type | payment | value
 | electricity |  |  |  |  |  |  | Water |  |  |  |  |  |  | Food |  |  |  |  |  |  | Garden
Spreadsheet: 1455e187-e7b3-433a-aa8f-ec5d1df44547
Sheet: Sheet1

25 Top Ranking Construction Companies of Azerbaijan | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
No | Company | Head of Company | [NAME] | Fax | [NAME]
1 | AKKORD INSHAAT SENAYE | [NAME] [NAME]  Chairman of Executive Board | (+99412) 5105720 | (+99412) 5640611 | [EMAIL]  www.akkord.az
2 | GILAN HOLDING | [NAME] | (+99412) 4932502 | (+99412) 4989679 | [EMAIL]
3 | PASHA CONSTRUCTION | [NAME] [NAME]  Director | (+99412) 4985801 | (+99412) 4985801 | [EMAIL]
4 | ZQAN HOLDING | [NAME] | (+99412) 4416784 | (+99412) 4409340 | [EMAIL]
5 | ALTES GROUP | [NAME]  Chairman of the  Board of Directors | (+99412) 4929123 | (+99412) 4926248 | [EMAIL]
6 | QARTAL CONSTRUCTION | [NAME]  General Manager | (+99418) 6482054-55 | (+99412) 4429387 | [EMAIL]  [EMAIL]  [NAME]
7 | UGUR 97 | Mokhnatov Azay  President | (+99412) 4936400  050 214 84 09 | (+99412) 4935442 | [EMAIL]  www.ugur97.com
8 | A+A GROUP OF COMPAMIES | [NAME]  President | (+99412) 4960026 | (+99412) 4473688 | [EMAIL]  www.aagroup.az
9 | AZINKO HOLDING | [NAME]  Director | (+99412) 5964107 (+99412) 5308330 | (+99412) 4407947 | [EMAIL]
10 | AZCOND | [NAME]  Director | (+99412) 4656989 | (+99412) 4972277 | [EMAIL]
11 | [NAME] | [NAME]  General Director | (+99412) 4902946 | (+99412) 4902698 | [EMAIL]  www.azwirt.com
12 | AZERTUNELTIKINTI | [NAME] President | (+99412) 4700107 | (+99412) 4705067 | [EMAIL]
13 | ATA HOLDING | Ahmet Erentok  Chairman of Supervisory  Board | (+99412) 4493925/26 | (+99412) 4498565 | [EMAIL]  www.ataholding.az
14 | AZERKORPU | [NAME] President | (+99412) 5104721/22 | (+99412) 4973485 | www.azerkorpu.com
15 | KORPU-BINATIKINTI | [NAME]  Director | (+99412) 4422537  (+99412) 4099733 | (+99412) 4420388  (+99412) 4099303 | [EMAIL]
16 | SHARUR INSHAAT | [NAME] | (+99412) 5625685 | (+99412) 5621203
17 | CASPIAN SERVICE | [NAME] | (+99412) 5980091 | (+99412) 5980091 | [EMAIL]
18 | ANT INSHAAT |  | (+99412) 4931471 | (+99412) 4651995 | [EMAIL]
19 | AzerInshaat Service | [NAME] | (+99412)4477003 | (+99412) 5981006 | [EMAIL]
20 | AZER AGRAR TIKINTI | [NAME] | (+99412) 4320069 | (+99412) 4329904 | [EMAIL]
21 | AZER ENERGY TIKINTI  QURASHDIRMA JSC |  | (+99412) 4985431 | (+99412) 4933312
22 | AZER SENAYE TIKINTI OJSC |  | (+99412) 4948904 | (+99412) 4930488
23 | AZERSUTIKINTI | [NAME]  Chairman | (+99412) 4930983 | (+99412) 4932546 | [EMAIL]
24 | TUNELMETRO TIKINTI | Shaik [NAME]  President | (+99412) 4386413 | (+99412) 4390566 | [NAME]
25 | BAKELECTRO OJSC | [NAME]  President | (+99412) 5149630/32 | (+99412) 5149630 | [EMAIL]
Spreadsheet: 51644d1251283229-counting-conditional-formatting-aug-backups
Sheet: 18th

Internt Backups |  |  | [NAME]
Customer/ server/ [NAME] job | Backup success |  | Customer/ server/ [NAME] job | Backup success |  | Y | Backup successful
Artist Indepenent |  |  | Able Services |  |  | N | Failed
AIFDC1-SYS-STATE | y |  | ADSDC1 | y |  | o | Backup Not found
AIFDCI-DATA | y |  | Finnsish Chamber of Commerce
AIFDC1-MSEXCH | y |  | FBCCS01 | y
AIFDC1-PST | y |  | LP Networks
Axis Security |  |  | LPNETDC1 | n
[NAME] | y |  | ML Select
AXISDC1-DATA | y |  | MLSDC1 | y
AXISDC1-MSEXCH | y |  | [NAME]
AXISDC1-BRICKLEVEL | y |  | SIDEKIXDC1 | o
AXISDC1-SQL | y
Colombier
[NAME] | y
COLUKDC1-DATA | y
COLUKDC1-PST | y |  | Date updated | 18.08.90
COLUKSRV1-SYS-STATE | y
COLUKSRV1-SQL | y
COLUKSRV1-DATA | y
Finch & Partners
FINCHDC1-DATA | y
FINCHDC1-MSEXCH | y
Glasshouse Entertainment
GOLCONDALA-SYS-STATE | y
GOLCONDALA-DATA | y
GOLCONDALA-MSEXCH | y
GOLCONDALA-PST | y
LOGO69
LOGODC1-SYS-STATE | y
[NAME] | y
LOGODC1-DATA | y
LOGODC1-PST | y
LPM Cleaning
LPMDC1-SYS-STATE | y
LPMDC1-DATA | y
LPMDC1-EXCH | o
LPMDC2-SYS-STATE | y
LPMDC2-SQL | y
LPMDC2-DATA | y
TMS-SYS-STATE | y
TMS-SQL | y
TMS-DATA | y
[NAME]
NGDC1-SYS-STATE | y
NGDC1-MSEXCH | y
NGDC1-DATA | y
Tavistock
TWOODSO1-SYS-STATE | y
TWOODS01-DATA | y
TWOODS01-MSEXCH | y
TWOODS01-PST | y
Spreadsheet: holden_salisbury__12311__August 2001 tranny
Sheet: Sheet1

 | Desk | Data
 | EPMI-ST-SW |  | EPMI-ST-WROCK |  | Total Sum of Gross MW | Total Sum of Total Amt
Act Date | Sum of Gross MW | Sum of Total Amt | Sum of Gross MW | Sum of Total Amt
2001-08-02 00:00:00 |  |  | -10 | -28.4 | -10 | -28.4
2001-08-07 00:00:00 | -25 | -71 |  |  | -25 | -71
Grand Total | -25 | -71 | -10 | -28.4 | -35 | -99.4
Schedule 1    Scheduling, System Control, and Dispatch Services -  $0.047 per MWh
ST_SW 25 MW x 0.047 = 1.18
ST_WROCKIES 10 MW x 0.047 = 0.47
Total: 35 MW x 0.047 = $1.65
Schedule 2    Reactive Supply and Voltage Control - $0.066 per MWh
ST_SW 25 MW x 0.066 = 1.65
ST_WROCKIES 10 MW x 0.066 = 0.66
35 MW x 0.066 = $2.31
Schedule 9    Loss Compensation Service - $2.76 per MWh (3% of cap price $91.87)
ST_SW 25 MW x $2.7561 = 68.9025
ST_WROCKIES 10 MW x $2.7561 = 27.561
35 MW x $2.7561 = $96.46
New Mexico Gross Receipts Tax - 5.75% of gross charges for the month
ST_SW [2.84 x 25 MW + (1.18 + 1.65 + 68.90)] x 5.75% = 8.21
ST_WROCKIES [2.84 x 10 MW + (0.47 + 0.66 + 27.561)] x 5.75% = 3.28
($99.40 energy charge + $100.42 ancillary charge total) x 5.75% = $ 11.49
Total ST_SW Annuity #  775592.1 for $79.94
Total ST_WROCKIES Annuity #  775676.1for $31.97
Spreadsheet: daren_farmer__6362__CES INFO
Sheet: CSGT

Purchase
 | From Spinnaker
 | At Brazos 368 (B368)
 | For IF-.08 for base vols & GDA-.08 for swing vols
 |  | Plus $.18 Transport
Sale
 | To Dow
 | At Cowtrap Facility (864101)
 |  | Operated By Coastal States Gas
 |  | [NAME] States Gas [PHONE]
 | For IF-.07 for base vols & GDA-.07 for swing vols
Term
 | Will be extended per [NAME]
Other
 | CSGT does not require nominations
 | Whatever is produced is allocated to Dow
 | Jan vols are approximately 1233 [NAME]
Deal Numbers
 | P - 144264, 144271
 | S - 144265, 144273
 | T - 148795
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF GOODWILL
FOR THE 3 MONTHS ENDED 3-31-2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-99 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2000
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 585104d1533632524-how-to-replicated-an-if-formulan-in-powerquery-accumulating-1-
Sheet: Sheet2

Apply Date | Historical Date | Employee | Employee Name | Employee Logon | EE Type | Manager | Pay Rule | Location | Cost Center | [NAME] | CR CCSS [NAME] | CR CCSS Sick Leave Unpaid | CR Leave of Absence Unpaid | Consecutive_days
2018-05-29 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 5.37 |  |  | 1
2018-06-12 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 3.4 |  |  | 1
2018-06-13 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 2
2018-06-21 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 5.93 |  |  | 1
2018-06-22 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 2
2018-06-23 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 3
2018-06-28 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 4
2018-06-29 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 5
2018-06-30 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 6
2018-07-01 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 7
2018-07-02 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 8
2018-07-03 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 9
2018-07-04 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 10
2018-07-05 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 11
2018-07-06 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 12
2018-07-07 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 13
2018-01-16 00:00:00 | 43111 | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 1
2018-01-16 00:00:00 | 43112 | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 2
2018-06-11 00:00:00 |  | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 1
2018-06-12 00:00:00 |  | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 2
2018-06-13 00:00:00 |  | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 3
Spreadsheet: 758668d1638990626-match-formula-based-on-ranked-criteria-example
Sheet: Test

Name | Staff | Component 1 | Component 2 | Component 3 | Component 4 | Overall rating
1 | A | Below | Below | Developing | Below
2 | B
3 | C
4 | A
5 | B
6 | C
7 | A
8 | B
9 | C
10 | A
11 | B
12 | C
13 | A
14 | B
15 | C
Spreadsheet: 98420d1297325370-multiply-countif-by-criteria-in-same-row-sample-book
Sheet: Sheet1

Customer | Code | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun |  | Code | Qty | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
cust 1 | Code 1 | Yes | No | Yes | No | Yes | No | No
cust 2 | Code 2 | No | Yes | No | Yes | No | Yes | Yes
cust 3 | Code 3 | Yes | No | Yes | No | Yes | No | Yes
cust 4 | Code 4 | Yes | No | Yes | No | Yes | No | No
cust 5 | Code 2 | Yes | No | Yes | No | No | Yes | No
cust 6 | Code 3 | No | Yes | No | Yes | Yes | Yes | No |  | Twice Weekly Delivery
cust 7 | Code 2 | No | Yes | No | Yes | Yes | No | Yes |  | Code | [NAME] | Fri
cust 8 | Code 1 | Yes | No | Yes | No | No | Yes | No |  | Code 1
cust 9 | Code 3 | No | Yes | No | Yes | Yes | Yes | No |  | Code 2
cust 10 | Code 2 | Yes | No | Yes | No | No | No | Yes |  | Code 3
cust 11 | Code 4 | Yes | No | Yes | No | No | No | Yes |  | Code 4
Spreadsheet: 443130d1453936202-count-games-played-442941d1453879801-count-games-played-sample
Sheet: Sheet1

Situation 1
PICKS | PLAYED BY | RESULTS |  |  | Game 1 | Game 2 | Game 3 | Game 4 | Game 5
Game 1 | [NAME] | Won | [NAME]
Game 2 | [NAME] |  | [NAME]
Game 3 | Juls |  | Juls
Game 4 | [NAME] |  | [NAME]
Game 5 | [NAME] |  | [NAME]
Game 1 | [NAME] | Won
Game 2 | [NAME]
Game 3 | Juls
Game 4 | [NAME]
Game 5 | [NAME]
Situation 2
RANK | Most Banned | Count |  |  | Game | Count
1 |  |  |  |  | Game 1 | 5
2 |  |  |  |  | Game 2 | 2
3 |  |  |  |  | Game 3 | 1
4 |  |  |  |  | Game 4 | 0
5 |  |  |  |  | Game 5 | 0
6 |  |  |  |  | Game 6 | 6
7 |  |  |  |  | Game 7 | 0
8 |  |  |  |  | Game 8 | 10
9 |  |  |  |  | Game 9 | 0
10 |  |  |  |  | Game 10 | 8
 |  |  |  |  | Game 11 | 0
 |  |  |  |  | Game 12 | 4
 |  |  |  |  | Game 13 | 0
 |  |  |  |  | Game 14 | 9
 |  |  |  |  | Game 15 | 0
 |  |  |  |  | Game 16 | 10
 |  |  |  |  | Game 17 | 3
 |  |  |  |  | Game 18 | 0
 |  |  |  |  | Game 19 | 0
 |  |  |  |  | Game 20 | 4
Spreadsheet: 46877d1245799632-looking-up-sports-stats-from-web-data-stats-index-match-
Sheet: Team Compare

 | Team Compare
 | Away | Points |  | Home |  | Drop down lists in C2 and in each Team column.
 | Florida |  |  | Oklahoma State |  | Make your choices and the stats will appear
 |  |  |  |  |  | Named ranges refer to the colored sections
 |  |  |  |  |  | on the first sheet
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5310

5310 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 722192d1615107891-modify-my-formula-to-to-check-the-values-and-enter-the-result-and-if-no-values-enter-a-m-missing-and-sum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | M | 2024-04-04 00:00:00 |  |  |  |  |  | P | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  | 4 |  |  |  |  | 3
 |  |  |  |  | 9 |  |  |  |  | M
 |  |  |  |  | 2 |  |  |  |  | 1 |  | here I need a formula that allocated points to each cell like t8=.45 and all other cells u8:aa8 will have 1 point each and
 |  |  |  |  |  |  |  |  |  |  |  | ab8 =.33 | We therafter need to sum the total from T8:u8 but end results must not be greater than 3  and result entered into cell M14
 |  |  |  |  |  |  |  |  |  |  |  | as in the case of K12 the value is 3 because e8:k8 total 3.45 rounded to 3
 |  |  |  |  |  |  |  |  |  |  |  | and in the case of m13 because the value is zero, (M)issing  gets pasted into there
 |  |  |  |  |  |  |  |  |  |  |  | the orange shaded cells will contain the fomula that I need help with