tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 489209d1479145385-extend-a-nested-if-formula-or-macro-example2
Sheet: Sheet1 (2)

 | 1 | .0001 / 100 |  |  | 0 |  |  |  | 0.01 | 0.02 |  | 1 | 0.01 | 0.01 | x2 |  | .0100 x2 | .0100 [NAME] | .0100 x4 | .0100 x5 | .0100 x6 | .0100 x7 | .0100 x8 | .0100 x9 | .0100 x10 | .0100 x12 | .0100 x16 | .0100 MAX | .0100 R | .01 º | [NAME] | 0.0100
 | IF(P1="x2",R1,IF(P1="x3",S1,IF(P1="x4",T1,IF(P1="x5",U1,IF(P1="x6",V1,IF(P1="x7",W1,IF(P1="x8",X1,IF(P1="x9",Y1,""))))))))
 | (IF(P1="x10",Z1,IF(P1="x12",AA1,IF(P1="x16",AB1))))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x2" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  R1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x3" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  S1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x4" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  T1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x5" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  U1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x6" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  V1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x7" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  W1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x8" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  X1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x9" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x10" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  Z1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x12" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  AA1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x16" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  AB1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Else
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do Nothing
Spreadsheet: 599894d1543350421-find-closest-value-in-a-table-of-values-book2
Sheet: Sheet1

 | Category | Rate | Closest |  | Category | Point 1 | Point 2 | Point 3 | Point 4 | Point 5
 | IT 02 | 20.3184 |  |  | IT 01 | 14.04 | 15.25 | 16.21 | 19.7 | 22.95
 | IT 04 | 28.6824 |  |  | IT 02 | 18.02 | 20.81 | 23.6 | 25.67 | 28.71
 | IT 05 | 37.6482 |  |  | IT 03 | 20.61 | 23.34 | 27.8 | 31.25 | 35.71
 | IT 06 | 35.2818 |  |  | IT 04 | 24.19 | 27.59 | 30.73 | 34.11 | 38.19
 |  |  |  |  | IT 05 | 27.99 | 32.51 | 36.21 | 40.02 | 45.6
 |  |  |  |  | IT 06 | 35.36 | 40.56 | 44.7 | 49.07 | 55.38
 |  |  |  |  | IT 07 | 44.17 | 51.8 | 57.46 | 62.94 | 69.91
 |  |  |  |  | IT 08 | 59.1 | 67.27 | 72.94 | 78.83 | 86.86
 |  |  |  |  | IT 09 | 74.54 | 84.34 | 90.49 | 96.26 | 104.47
Spreadsheet: 746826d1631051920-excel-to-return-lookup-value-besides-the-first-matching-value-data-table
Sheet: Data

KeyWord Deep Dive | Notes | [NAME]
Billing Explanation | breakdown of the charges |  | Total | %
Make payment |  | >>Disconnect<<
Transfer Services to Address |  | Can No Longer Afford
Return Shipping Label |  | Switch to Competitor
Can No Longer Afford | Offered a lower rate but decided to cancel still | Customer Care Issue
Phone Issues | Unable to connect call | Doesn't use enough
Transfer Services to Address |  | Port-Out
Updating Payment |  | Promotion Ended
Renew Value Plan | VP expiring and requesting to renew | Technical Issues
Billing Explanation |  | Customer Declined to say
Transfer Services to Address |  | Deceased
Billing Explanation |  | Moving - Services Included
Cable Issues |  | Moving - Secondary Address
Credit(s) | Refund process | Partial Disconnect
[NAME] |  | >>Moving<<
Wifi Speed/Connection | Slow | Moving Outside Footprint
Update Account Information |  | Moving to [NAME]
Updating Payment | Scam email to provide credit card information | Transfer Services to Address
Moving - Services Included |  | >>Technical<<
Switch to Competitor |  | Wifi Speed/Connection
Pricing/Plan Inquiry | customer have legacy INT and CBL svc inquired about upgrading all | Cable Issues
[NAME] | Signed up new VP this morning and has some questions | Phone Issues
Billing Explanation |  | Appointments
Partial Disconnect | Inquiried about cancelling home phone | MyShaw/Email
Account Balance |  | Return Shipping Label
 |  | Equipment Swap
 |  | Additional Equipment
 |  | >>Billing/Account<<
 |  | Billing Explanation
 |  | Payment Arrangement
 |  | Report Payment
 |  | Make Payment
 |  | Updating Payment
 |  | Update Account Information
 |  | Account Balance
 |  | Credit(s)
 |  | CC Reversals
 |  | UEF / Return Equipment Procedures
 |  | >>Package Changes<<
 |  | Add Channel
 |  | [NAME]
 |  | Downgrade Internet
 |  | Downgrade TV
 |  | Upgrade Internet
 |  | Upgrade TV
 |  | Renew Value Plan
 |  | Sign New Value Plan
 |  | Pricing/Plan Inquiry
 |  | New RGU
 |  | Home Phone Add On
 |  | >>Value Plan & Promotions<<
 |  | Promotion/VP Ending
 |  | [NAME]
 |  | Competitor [NAME]
 |  | Seeking Offers/Promotions
 |  | Marketing Offer
 |  | >>Mobile<<
 |  | Pricing/Plan Inquiry
 |  | SIM Activation
 |  | >>Other<<
 |  | TCIS
 |  | Non Related
 |  | Direct
 |  | Business
Spreadsheet: b9a6acca-50c5-4be5-bf1f-236c63726d32
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
ALAD | Test | ALAD | Aminolevulinic Acid Dehydratase (ALAD), [NAME] | ALA Dehydratase, WB | Enzymatic End point/Spectrofluorometric |  |  |  | 4 | mL | All porphyrin tests on whole blood can be performed on 1 draw tube.   Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: Lavender top (EDTA) or green top (lithium heparin) [NAME]: Full tube Collection Instructions: 1. Patient should abstain from alcohol for 24 hours. 2. Immediately place specimen on wet ice. Additional Information: Include a list of medications the patient is currently taking. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.    2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 3 mL | Hemolysis	Mild reject; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =4.0 nmol/L/sec 3.5-3.9 nmol/L/sec (indeterminate) <3.5 nmol/L/sec (diminished) | Monday through Friday; 8 a.m. | 2 days (not reported on Saturday or Sunday) | 3 days | 1 | 82657 |  |  |  |  | Rochester
ALAD | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 4 days
ALAD | Result | 4021 | ALA Dehydratase | ALA Dehydratase | Numeric |  |  |  |  | nmol/L/sec |  |  |  |  |  |  |  |  |  | 2813-4
ALAD | Result | 28399 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 151da7d4-255f-4047-af9a-ec01b6905cfc
Sheet: Sheet1

[Project Name (Municipality, County, Project)] | 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 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Discharge | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Elevation | Unnamed: 36 | Unnamed: 37 | Unnamed: 38
POC: |  |  |  |  |  |  |  | [Project Budget Amount]
Owners  &           Co-owners       Name | Street Address | NEMIS Property Number | Reviewer Initials  (PEMA/FEMA Use Only) | City | Zip Code | Year Built | Fair Market Value | Structure Type Comments | # of stories | Area Sq FT | Basement       (Yes or No) | Walk-out        (Yes   NO) | Finished (%Livable Space) | [NAME]Total) | Garage Sq Ft | [NAME] | [NAME] | Replacement Cost/Sq Ft | Total Replacement Cost | Location Factor | Total Replacement Cost | BCA Benefit | BCA Ratio | Latitude | Longitude | High Water Mark | FFE | BFE | Streambed Elevation | Sub Damage | 10 | 50 | 100 | 500 | 10 | 50 | 100 | 500
Spreadsheet: 267385d1380059871-conditionally-format-cell-based-on-dates-within-a-number-of-days-apart-excel-forum-question-3
Sheet: Sheet1

Date | Name1 | [NAME]
2013-10-02 00:00:00 | P | P
2013-10-09 00:00:00
2013-10-18 00:00:00 |  | P
2013-10-23 00:00:00 | P
2013-10-30 00:00:00 | P
2013-11-06 00:00:00
2013-11-13 00:00:00 | P
2013-11-20 00:00:00
2013-11-27 00:00:00
2014-01-29 00:00:00
2014-02-04 00:00:00
2014-02-12 00:00:00
2014-02-19 00:00:00
2014-02-26 00:00:00
2014-03-03 00:00:00
2014-03-12 00:00:00
2014-03-18 00:00:00
2014-03-27 00:00:00
2013-10-02 00:00:00 | P
2013-10-11 00:00:00 | X
2013-10-16 00:00:00 | P | P
2013-10-23 00:00:00
2013-11-01 00:00:00 | P | X
2013-11-08 00:00:00 | X
Days apart | 7
Spreadsheet: 66994d1267643508-conditional-unique-values-accounts
Sheet: Current Formulas

Accounts | Totals
1480-01 | 4000
1480-02 | 800 |  |  | This sheet | 89587.68
1480-03 | 66.22
1516-01 | 100 |  |  | Data sheet | 89587.68000000001
1516-02 | 50
1480-15 | 4862.24 |  |  | Difference | 0
1495-01 | 11.22
2615-01 | 78000
2615-02 | 100
6515-08 | 98
1515-15 | 1500
 |  |  | My end result is that I will always have an automated account list with totals.
Spreadsheet: 725412d1616670755-help-required-in-filter-formula-filter_formula_sample-1-
Sheet: ExpectedResult

 | Date | 2021-02-01 00:00:00 | To | 2021-02-28 00:00:00
 |  | Assigned | Closed |  |  |  |  | S.No. | Ticket No. | Ticket type | Status | Assigned Date | Closed Date
 | Low |  |  |  |  | Filter formula -- >> |  |  | 2121 | Low | In Progress | 2021-02-01 00:00:00
 | Medium |  |  |  |  |  |  | 2 | 2122 | Low | Closed | 2021-02-02 00:00:00 | 2021-02-05 00:00:00
 | High |  |  |  |  |  |  | 3 | 2135 | Medium | Opened | 2021-02-15 00:00:00
 |  |  |  |  |  |  |  | 4 | 2226 | High | Closed | 2021-02-10 00:00:00 | 2021-03-15 00:00:00
 |  |  |  |  |  |  |  | 7 | 2137 | Medium | Closed | 2021-02-10 00:00:00 | 2021-03-02 00:00:00
 |  |  |  |  |  |  |  | 9 | 2240 | High | Opened | 2021-02-12 00:00:00
 |  |  |  |  |  |  |  | 10 | 2242 | Low | Closed | 2021-03-18 00:00:00 | 2021-02-15 00:00:00
 |  |  |  |  |  | Expected Result |  | S.No. | Ticket No. | Ticket type | Status | Assigned Date | Closed Date
 |  |  |  |  |  |  |  | 1 | 2121 | Low | In Progress | 2021-02-01 00:00:00
 |  |  |  |  |  |  |  | 2 | 2122 | Low | Closed | 2021-02-02 00:00:00 | 2021-02-05 00:00:00
 |  |  |  |  |  |  |  | 3 | 2135 | Medium | Opened | 2021-02-15 00:00:00
 |  |  |  |  |  |  |  | 4 | 2226 | High | Closed | 2021-02-10 00:00:00 | 2021-03-15 00:00:00
 |  |  |  |  |  |  |  | 7 | 2137 | Medium | Closed | 2021-02-10 00:00:00 | 2021-03-02 00:00:00
 |  |  |  |  |  |  |  | 9 | 2240 | High | Opened | 2021-02-12 00:00:00
 |  |  |  |  |  |  |  | 2 | 2122 | Low | Closed | 2021-02-02 00:00:00 | 2021-02-05 00:00:00
 |  |  |  |  |  |  |  | 10 | 2242 | Low | Closed | 2021-03-18 00:00:00 | 2021-02-15 00:00:00
Spreadsheet: 4f2b4c67-c250-4dcb-8a4b-321c578649cc
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/22/2014 | Women's Soccer | at Penn State (Penn State Invitational) | 05:00 PM | L, 1-3
08/24/2014 | Women's Soccer | vs. Missouri (Penn State Invitational) | 12:00 PM
08/29/2014 | Women's Soccer | Duke | 07:30 PM
08/31/2014 | Women's Soccer | Elon | 01:00 PM
09/05/2014 | Women's Soccer | Hofstra (WVU 90 Minute Classic) | 07:00 PM
09/07/2014 | Women's Soccer | UNC Greensboro (WVU 90 Minute Classic) | 05:00 PM
09/12/2014 | Women's Soccer | Georgetown | 07:00 PM
09/14/2014 | Women's Soccer | Duquesne | 01:00 PM
09/19/2014 | Women's Soccer | [NAME] | 07:00 PM
09/21/2014 | Women's Soccer | Villanova | 01:00 PM
09/26/2014 | Women's Soccer | at TCU* | 08:00 PM
09/28/2014 | Women's Soccer | at Texas* | 02:00 PM
10/10/2014 | Women's Soccer | Texas Tech* | 07:00 PM
10/17/2014 | Women's Soccer | at Iowa State* | 08:00 PM
10/19/2014 | Women's Soccer | at Kansas* | 02:00 PM
10/24/2014 | Women's Soccer | Oklahoma State* | 07:00 PM
10/26/2014 | Women's Soccer | Oklahoma* | 01:00 PM
10/31/2014 | Women's Soccer | Baylor* | 07:00 PM
11/05/2014 | Women's Soccer | Big 12 Soccer Championship Quarterfinal (Kansas City, Mo.)
11/07/2014 | Women's Soccer | Big 12 Soccer Championship Semifinal (Kansas City, Mo.)
11/09/2014 | Women's Soccer | Big 12 Soccer Championship Final (Kansas City, Mo.)
Spreadsheet: 815695d1675157448-nested-if-formula-with-multiple-conditions-to-check-keep-getting-value-error-excel-formula-help
Sheet: Logic

 | LOGIC |  |  |  |  |  |  |  | No. of days in month
 |  |  |  |  |  |  |  |  | Start of month | 2023-01-01 00:00:00 | 2023-02-01 00:00:00
 |  |  |  |  |  |  |  |  | End of month
 |  |  |  |  |  | Start date | Maturity date | Daily brokerage fee |  | 2023-01-01 00:00:00
 |  |  |  |  | Deal 1 |  |  | 50
 |  |  |  |  | Deal 2 | 2017-02-28 00:00:00 | 2022-12-28 00:00:00 | 55
 |  |  |  |  | Deal 3 |  | 2023-01-18 00:00:00 | 65
 |  |  |  |  | Deal 4 |  | 2023-05-05 00:00:00 | 75
 |  |  |  |  | Deal 5 | 2017-02-28 00:00:00 |  | 60
 |  |  |  |  | Deal 6 | 2023-01-05 00:00:00 |  | 30
 |  |  |  |  | Deal 7 | 2023-02-05 00:00:00 |  | 40
 |  |  |  |  | Deal 8 | 2021-12-28 00:00:00 | 2022-12-28 00:00:00 | 100
 |  |  |  |  | Deal 9 | 2022-12-28 00:00:00 | 2023-02-18 00:00:00 | 80
 |  |  |  |  | Deal 10 | 2022-12-28 00:00:00 | 2023-01-18 00:00:00 | 70
 |  |  |  |  | Deal 11 | 2023-01-05 00:00:00 | 2023-01-18 00:00:00 | 20
 |  |  |  |  | Deal 12 | 2023-01-05 00:00:00 | 2023-05-15 00:00:00 | 10
 |  | Conditions:
 |  |  |  | [NAME]: | Outcome
 | 1 | Start date of deal is blank & End date of deal is blank | Do full months days x daily brokerage fee | =IF(OR(AND($G6=0,$H6=0),$I6*K$2) | 1550
 |  | Start date of deal is blank & End date of deal is < Start of month | Show 'Check'
 |  | Start date of deal is blank & End date of deal is <= End of month but >= start of month | Show 'Check'
 |  | Start date of deal is blank & End date of deal is > End of month | Show 'Check'
 | 2 | Start date of deal  is < Start of month & End date of deal is blank | Do full months days x daily brokerage fee | =IF(AND($G6<K$3,$H6=0),$I6*K$2) | 1550
 | 3 | Start date of deal  is >= Start of month & End date of deal is blank | Do (end date of month less start date of deal + 1 day) x daily brokerage fee | =IF(AND($G6>=K$3,$H6=0),((K$4-$G6)+1)*$I6) | False
 |  | Start date of deal  is > End of month & End date of deal is blank | Nothing | =IF(AND($G6>K$4,$H6=0),0) | False
 |  | Start date of deal  is < Start of month & End date of deal is < start of month | Nothing | =IF(AND($G6<K$3,$H6<K$3),0) | 0
 |  | Start date of deal  is < Start of month & End date of deal is > end of month | Do full months days x daily brokerage fee | =IF(AND($G6<K$3,H$6>K$4),(K$2*$I6)) | False
 |  | Start date of deal  is < Start of month & End date of deal is <= end of month | Do (end date of deal less start of month + 1 day) x daily brokerage fee | =IF(AND($G6<[NAME]) | -2246300
 |  | Start date of deal  is >= Start of month & End date of deal is <= end of month | Do (end date of deal less start date of deal + 1 day) x daily brokerage fee | =IF(AND($G6>=K$3,$H6<=K$4),(($H6-$G6)+1)*$I6) | False
 |  | Start date of deal  is >= Start of month & End date of deal is > end of month | Do (end date of month less start date of deal + 1 day) x daily brokerage fee | =IF(AND($G6>=$K3,$H6>K$4),(($K4-$G6)+1)*$I6) | False
Spreadsheet: 682408d1592070789-find-date-of-which-employee-satisfies-two-conditions-sample-2
Sheet: BONOUS

CODE | NET LIVES | NET FP | DATE(YYYYMMDD) |  |  | CHANGE DATE
 |  |  |  |  |  | AS REQUIRED
192 |  |  |  |  |  | 20190401 | 20200331
727
888
 |  |  |  |  |  | PROJECT : IF AN EMPLOYEE (SHOWN IN SHEET NBD COLUMN "EM-CODE) COMPLETES SIX UNIQUE ORDERS(UNIQUE ORDER MEANS: ' ORDER-NO' WITH UNIQUE' DOB')
 |  |  |  |  |  | AND SUM OF ALL ORDER PREM IS >=50000 IN GIVEN DATE RANGE .EMPLOYEE IS ELIGIBLW FOR BONUS FROM DATE ON WHICH HE SATISFIES TWO CONDITIONS.
 |  |  |  |  |  | SOLUTION REQUIRED : I WANT TO DISPLAY DATE IN COL. [NAME] YYYYMMDD FORMAT(AS SHOWN IN COL. 'C' OF 'NBD' SHEET) ON WHICH EMPLOYEE SATISFY ABOVE MENTIONED
 |  |  |  |  |  | TWO CONDITIONS. SO THAT I CAN CALCULATE BONOUS FROM THAT DATE.
 |  |  |  |  |  | EXPECTED RESULT IS GIVEN IN COL. D
Spreadsheet: 99620d1298237518-vlookup-over-multiple-tabs-sheets-fundraising-1-
Sheet: Vlaams Brabant

algemeen nr | nr | organisatie | bedrag | betaling | etc | commentaar | blabla
1 | [NAME] | test1 | tes2 | test3 | test4 | test5
7 | brabant2 | imec | 10000 euro | [NAME] | blab | blob | [NAME]
8 | brabant3 | jsdkf | fgkls | sdhfg | ksgj
Spreadsheet: 219557d1362783631-two-drop-down-lists-to-produce-in-two-other-columns-xlf-fruit-and-veggiechallenge
Sheet: Sheet1

Gender | Age | How much Fruits | How much Vegetables | Total consumption |  |  | Gender | Age | FruitsM | FruitsW | [NAME] | VeggiesW
Men | 31-50 |  |  |  |  |  | Men | 19-30 | 2Cups | 2Cups | 3Cups | 2 1/2Cups
 |  |  |  |  |  |  | Women | 31-50 | 2Cups | 1 1/2Cups | 3Cups | 2 1/2Cups
 |  |  |  |  |  |  |  | 50+ | 2Cups | 1 1/2Cups | 2 1/2Cups | 2Cups
Spreadsheet: 04502f25-4156-44f5-9dc1-2fbf187f0385
Sheet: Sheet1

 | Participant Import
 | Use these headers when compiling a file of event Participants for importing onto an Event Record: |  |  |  |  |  |  |  |  |  |  | = Required Field
 | EventID | ConstituentID | First Name | Last Name | Middle Name | Title | Suffix | Participation | Registration | Registration Date | Attended? | [NAME]? | [NAME]? | Address Lines | City | State | Zip | [NAME] | Home Phone | Business Phone | Cell Phone | Notes | Key Indicator
Spreadsheet: kimberly_watson__20644__MN_Acct_Assgn
Sheet: by Originator

MN_Acct_Assgn.xls
 |  |  | North Region Team
 | PRIMARY ACCOUNT ASSIGNMENT RESPONSIBILITIES
[NAME] | Support |  | [NAME] | Support |  | [NAME] | Support
Agri-Energy - USES | L.Penkava |  | [NAME] -TransCanada | M.Barry |  | Agra Resources (EXOL) | M.Barry
[NAME] | L.Penkava |  | Circle Pines -TransCanada | M.Barry |  | [NAME] (Marathon) | M.Barry
Cenex (Honeymead) - USES | L.Penkava |  | Great Lakes Gas Trans. | L.Valley |  | Cogentrix (LS Power) | M.Barry
Community Utility - USES | L.Penkava |  | Great Plains -TransCanada | M.Barry |  | Minnesota Corn Processors | M.Barry
Duluth | L.Valley |  | Greater Minnesota Gas | L.Valley |  | Missouri Rivery Energy | M.Barry
Gorham Inc. | M.Barry |  | Hutchinson -TransCanada | M.Barry |  | NSP-Generation | L.Valley
Heartland Corn - USES | L.Penkava |  | New Ulm | L.Valley |  | NSP-MN (Incl. Western Gas) | L.Valley
Hibbing | M.Barry |  | Owatonna -TransCanada | M.Barry |  | NSP-WI | L.Valley
[NAME] | L.Penkava |  | Reliant Energy - MGO | L.Valley |  | Pheonix Chemical Co. | M.Barry
Midwest Natural Gas - USES | L.Penkava |  | Reliant Energy Retail | L.Valley |  | St. Croix Valley | M.Barry
Minnesota Power | L.Valley |  | Round Lake | L.Valley |  | US Gypsum | L.Penkava
Northwest Natural Gas | M.Barry |  | Westbrook | L.Valley |  | Viking Pipeline | M.Barry
ProCorn - USES | L.Penkava
[NAME] | L.Penkava
Semco | L.Valley
Sheehan Gas - USES | L.Penkava
Superior | L.Valley
Two Harbors | M.Barry
US Energy Services | L.Penkava
Virginia | M.Barry
Spreadsheet: 776043d1649454352-nested-if-too-many-arguments-testsheet
Sheet: Sheet2

Sunday | ON Duty |  |  | Call Up / Book | Both
 |  |  |  |  |  |  | These Columns will be hidden
Run | Time In | Time Out | Extended | Total | [NAME] |  |  |  |  | Platform | OT | Non-Platform | Stand By | [NAME] |  | [NAME] | [NAME]
 | 600 | 630 | 700 |  | Stand-By |  |  |  |  |  |  |  |  |  |  | Non Platform | 930
 | 630 | 930 | 945 |  | Platform |  |  |  |  |  |  |  |  |  |  | Platform | Call Up
 | 930 | 1030 |  |  | Non Platform |  |  |  |  |  |  |  |  |  |  | Stand-By | Both
 | 1100 | 1145 |  |  | OT |  |  |  |  |  |  |  |  |  |  | OT
 | 1200 | 2200 |  |  | Platform
 |  |  |  |  |  |  |  | total
Platform |  |  | Total Platform hours should only be 8hrs, anything in excess needs to be in Overtime cell.  So in this case, total of 13hours were platform, so it would be 8hrs platform, 3hrs OT
Overtime |  |  | This total I need it to include any hours over 8 from the platform dropdown + any hours with the OT drop down selected
Stand By |  |  | This works
Non Platform |  |  | This works
Call Up / Book |  |  | Is it possible to put 0.30 if selection in F1 is 930 or Call Up, but if "both" is selected it would put 1.0 ?
HOS Added | 0 |  | This value would be entered manually
Spreadsheet: 686244d1594453401-problem-with-formula-to-display-blank-cells-or-running-balance-sample-accounts-balance-problem-no-blanks
Sheet: Sheet1

Date | Payee | Description | Full cost | RS share | Cumulative total
2020-03-28 00:00:00 | Butcher | Groceries | 12.05 | 6.03
2020-03-28 00:00:00 | Waitrose | Groceries | 60.58 | 30.29
2020-03-28 00:00:00 | Shell | Groceries | 31.93 | 15.97
2020-04-04 00:00:00 | Sainsburys | Groceries | 49.79 | 29.9
2020-04-04 00:00:00 | [NAME] | Prescription charge for BP prescription | 18.3 | 18.3
2020-04-06 00:00:00 | M&S | Groceries | 13.13 | 6.57
 | Diet Chef | 1 month supply ordered by RS | -275 | -137.5
2020-04-10 00:00:00 | EB | Balance paid |  | 30.44
2020-04-11 00:00:00 | Bansted Fruiterers | Fruit & Veg | 8.59 | 4.27
2020-04-09 00:00:00 | Sainsburys | Groceries |  | 34
2020-04-10 00:00:00 | BP | Groceries & newspapers (no newsagent delivery) | 11.93
Total
Spreadsheet: 729976d1619463674-add-up-all-the-value-of-a-certain-instance-based-on-a-certain-sales-category-sales-team-2020
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Sales Category 1 |  | 1 |  | Sales Cateogry 2 |  | 2
Team | Region | SalesCat | Amount |  |  |  |  |  |  |  |  | Team | 100-399 | 400-699 | 700-1000 |  | 100-399 | 400-699 | 700-1000
A | East | 1 | 100 |  |  |  |  |  |  |  |  | A
B | West | 2 | 200 |  |  |  |  |  |  |  |  | B
A | East | 2 | 300
B | West | 1 | 400
A | East | 2 | 415
B | West | 2 | 600
A | East | 1 | 1000
B | West | 2 | 200
A | East | 1 | 150
B | West | 2 | 250
A | East | 1 | 750
B | West | 1 | 800
A | East | 2 | 901
B | West | 2 | 99
A | East | 1 | 345
B | West | 2 | 850
A | East | 1 | 905
B | West | 2 | 900
A | East | 2 | 201
B | West | 2 | 203
Spreadsheet: 69447d1269966319-merge-sheets-sample
Sheet: NL

NL
Ctry | LONDON | SWEDEN | [NAME] |  | LONDON | as | 2121 | 3 | 44 | 55 | 3 | 0 | 0
 |  |  |  |  | SWEDEN | 66 | 1221 | 66 | 66 | 55 | 3 | 0 | 0
Price |  |  |  |  | [NAME] | 77 | 77 | 77 | 77 | 22 | 3 | 0 | 0
30Kg | as | 66 | 77
40Kg | 2121 | 1221 | 77
50Kg | 3 | 66 | 77
60Kg | 44 | 66 | 77
Add1
Quarter 1 | 55 | 55 | 22
Quarter 2
Quarter 3
Quarter 4
Total | 3 | 3 | 3
C1 | 0 | 0 | 0
C2 | 0 | 0 | 0
[NAME] | 0 | 0 | 4
Add2
30Kg | 0 | 0 | 0
40Kg | 0 | 0 | 0
50Kg | 0 | 0 | 0
60Kg | 0 | 0 | 0
Add3
30Kg | 0 | 0 | 0
40Kg | 0 | 0 | 0
50Kg | 0 | 0 | 0
60Kg | 0 | 0 | 0
Add4
30Kg | 11 | 11 | 44
40Kg | 22 | 22 | 55
50Kg | 22 | 33 | 66
60Kg | 22 | 33 | 77
Add5
30Kg | 44 | 44 | 44
40Kg | 44 | 44 | 44
50Kg | 0 | 0 | 44
60Kg | 0 | 0 | 44
Spreadsheet: 32042d1228164953-adding-names-and-showing-on-all-sheets-generic-hours-and-miles_2008
Sheet: July

JULY | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0