tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 137236d1327008976-produce-a-list-based-on-two-inputs-test200112
Sheet: Sheet2

Variables
Category | APCIMS Growth |  |  |  | APCIMS Income |  | 2 years
Time | 3 months |  |  |  | APCIMS Balanced |  | 1 year
 | APCIMS Growth 3 months |  |  |  | APCIMS Growth |  | 6 months
Fixed Interest | 4 |  |  |  |  |  | 3 months
UK Equities | 4 |  |  |  |  |  | 1 month
Overseas Equities | 4
Hedge funds | 4
Property | 4
Cash | 4
Spreadsheet: 107673d1304795213-help-on-correct-use-of-if-statement-within-formula-excel-example
Sheet: Sheet1

 | 600 | N
 | 2000 | N
 | 1000 | N
 |  | in the cell above C14 I want to show the sum of B4 to B13 but only if there is a Y in the corresponding row so in this instance C14 should show £0
 |  | if there is an N I simply want to add £0
 | 600 | Y
 | 2000 | N
 | 1000 | N
 |  | in the cell above C29 I want to show the sum of B19 to B28  but only if there is a Y in the corresponding row so in this instance C29 should show £600
 | 600 | Y
 | 2000 | Y
 | 1000 | Y
 |  | in the cell above C45 I want to show the sum of B35 to B44 but only if there is a Y in the corresponding row so in this instance C45 should show £3600
Spreadsheet: john_lavorato__16546__pdxaa1
Sheet: Analysts

 |  | Knowledge
 |  | High |  | Low
 |  | [NAME]
 | High | [NAME] |  | [NAME]
 |  | [NAME] | Holden Salisbury
 |  |  | [NAME] | [NAME] | [NAME]
Aptitude |  |  | [NAME] | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Geir [NAME] | [NAME]
 | Low |  |  | [NAME]
1 |  | [NAME] | Trading
 |  | [NAME] | Trading
 |  | [NAME] | Trading
2 |  | [NAME] | Trading
 |  | Holden Salisbury | Trading
 |  | [NAME] | Trading
 |  | [NAME] | Origination
 |  | [NAME] | Origination
 |  | [NAME] | Trading
3 |  | Geir [NAME] | Trading
 |  | [NAME] | Trading
 |  | [NAME] | Structuring
 |  | [NAME] | Origination
 |  | [NAME]
 |  | [NAME]
TBD |  | [NAME] | Risk
Spreadsheet: b60afc96-56af-4a5d-ae84-ac08ffef6567
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
OROT | Test | OROT | Orotic Acid, [NAME] | Orotic Acid, U | Colorimetric | [NAME]: Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions:  1. Collect a random or timed urine specimen. 2. No preservative. Additional Information: Patient's age is required. Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 3 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 weeks: 1.4-5.3 mmol/mol creatinine 2 weeks-1 year: 1.0-3.2 mmol/mol creatinine 2-10 years: 0.5-3.3 mmol/mol creatinine > or =11 years: 0.4-1.2 mmol/mol creatinine | Tuesday, Thursday; 8 a.m. | 4 day | 8 days | 1 | 83921 |  |  |  |  | Rochester
OROT | [NAME] | URINE | [NAME] |  |  |  | Frozen | 30 days
OROT | Result | 8905 | Orotic Acid, U | Orotic Acid, U | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 30480-8 | Orotate:ACnc:Pt:[NAME]:[NAME]:
Spreadsheet: 727816d1618135640-sum-daily-data-into-week-drag-down-formulas-book1
Sheet: Sheet1

 |  | 1 |  | week 1
 |  | 2 |  | week 2
 |  | 3 |  | week 3
 |  | 4 |  | week 4
 |  | 5 |  | week 5
 |  | 6 |  | week 6
 |  | 7 |  | week 7
 |  | 8 |  | week 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
Spreadsheet: tracy_geaccone__40483__EOTT Summary subunits
Sheet: Sell Ratio .3

Project NFL: Gain/Loss Calculation
Enron recapitalizing Sub-Units, and API at .30
All Estimates based on March / 2001 information
Summary:
 |  |  |  |  |  |  |  |  |  | Co #105 |  |  |  | Co #105 | Co #23Q
 |  |  |  |  |  |  |  |  |  | Recapitalizing EOTT's Subordinated Units |  |  |  | Sell EOTT GP, Sub-Units and API | [NAME] API's |  | Total
Income Statement Effect
 | Proceeds on Sale |  |  |  |  |  |  |  |  |  |  |  |  | 33.4
 |  | Book Basis per G/L - pre-sale |  |  |  |  |  |  |  |  |  |  |  | 38.3 | 9.32
 | Effective Book Basis
 |  |  | Book Gain/(Loss) pre-tax
 | Tax Expense
 |  |  |  | Current
 |  |  |  | Deferred
 |  |  |  |  |  | Total Tax Expense
 |  |  |  |  |  | Net Income/(Loss) on Sale
 |  |  |  |  |  | Effective Tax Rate on Sale
Current Tax Calculation
 | Proceeds on Sale
 | Tax Basis |  |  |  |  |  |  |  |  | -6.3 |  |  |  | 1.8
 | Tax effect/basis in contingency items |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 |  | 0
 |  |  |  |  | Taxable Income
 |  |  |  |  |  | Statutory Tax Rate |  |  |  | 0.383 |  |  |  | 0.383 | 0.383 |  | 0.383
 |  |  |  |  |  | Total Current Tax Expense
Deferred Tax Calculation
 |  |  |  | Tax Basis (estimate) |  |  |  |  |  |  |  |  |  | 1.8
 |  |  |  | Book Basis |  |  |  |  |  |  |  |  |  | 33.9
 |  |  |  |  | Net Basis difference
 |  |  |  |  | Statutory Tax Rate |  |  |  |  | 0.383 |  |  |  | 0.383 | 0.383 |  | 0.383
 |  |  |  |  |  | Subtotal Deferred Taxes Calculated
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.1
 |  |  |  |  |  | Total Deferred Taxes per G/L |  |  |  | -11.9
 | USE FOR PLANNING PURPOSES ONLY.  ACTUAL WILL BE DIFFERENT.
 |  |  |  |  |  | Sub-Units |  |  |  | 7000000
 |  |  |  |  |  | API's |  |  |  |  |  |  |  |  | 9318213
 |  |  |  |  |  | Convertion Ratio |  |  |  | 0.3 |  |  |  |  | 0.3
 |  |  |  |  |  | Base converted
 |  |  |  |  |  | Market Price |  |  |  | 16.95
 |  |  | Prepared By: |  |  |  |  | [NAME]
 |  |  | Date Prepared:
 |  |  | Location:
 |  |  | Run Date:
Spreadsheet: 714987d1611497322-sum-valves-from-different-columns-considering-multiple-variables-example-data-1-
Sheet: Sheet1

 |  |  |  |  |  | Home team |  | Away team
[NAME] | Date | Home Team | Away Team | Home team goals | Away team goals | Previous 2 games Goals Scored | Previous 2 games Goals Conceded | Previous 2 games Goals Scored | Previous 2 games Goals Conceded
 | 2004-08-14 00:00:00 | [NAME] | Southampton | 2 | 0
 | 2004-08-25 00:00:00 | Arsenal | [NAME] | 3 | 0
 | 2004-08-25 00:00:00 | Charlton | [NAME] | 5 | 1
 | 2004-08-25 00:00:00 | Fulham | Middlesbrough | 0 | 2
 | 2004-08-28 00:00:00 | [NAME] | Newcastle | 4 | 1
 | 2004-08-28 00:00:00 | [NAME] | Man United | 1 | 1
 | 2004-09-11 00:00:00 | [NAME] | Chelsea | 0 | 1
 | 2004-09-18 00:00:00 | [NAME] | [NAME] | 0 | 0
 | 2004-09-18 00:00:00 | West Brom | Fulham | 1 | 1
 | 2004-09-25 00:00:00 | [NAME] | Crystal Palace | 1 | 1
Spreadsheet: 276910d1384107360-same-name-in-cells-is-formatted-differently-how-can-i-replace-with-a-consistent-format-for-excel-forum-wk-10-11-10-13
Sheet: 2. ROS (Rest of Season Ranking)

 | RB
1 | J Charles (KC)
2 | M Forte (CHI) |  | I call this sheet the "Rest of Season" rankings, and use the term "ROS" for "Rest of Season"
3 | A [NAME] (MIN) |  | I want to search this spreadsheet for [NAME], and return the ranking value of "3"
4 | L McCoy (PHI)
5 | [NAME] (DEN)
6 | M Lynch (SEA)
7 | R [NAME] (DET)
8 | E Lacy (GB)
9 | [NAME] (SF)
10 | A [NAME] (WAS)
11 | S Ridley (NE)
12 | Z Stacy (STL)
13 | L Bell (PIT)
14 | G Bernard (CIN)
15 | C [NAME] (TEN)
16 | D Murray (DAL)
17 | C [NAME] (BUF)
18 | [NAME] (BUF)
19 | D Woodhead (SD)
20 | A Ellington (ARI)
21 | R Rice (BAL)
22 | R Mathews (SD)
23 | S Vereen (NE)
24 | A [NAME] (HOU)
25 | [NAME] (MIA)
26 | M Jones-Drew (JAX)
27 | S Jackson (ATL)
28 | M James (TB)
29 | P Thomas (NO)
30 | D Sproles (NO)
31 | A Brown (NYG)
32 | T Richardson (IND)
33
Spreadsheet: a8ed07e0-2c39-4add-8069-bbe06abc4c1a
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
CDOMB | Test | CDOMB | Cadmium for Occupational Monitoring, Blood | Cadmium Occupational Monitor, B | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1 | mL | Container/Tube: Royal, blue-top Monoject trace element blood collection tube, product #8881-307022 (Supply T183), containing EDTA as an anticoagulant [NAME]: Full tube Collection Instructions: 1. Send specimen in original tube. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	Green-top (heparin) tube | 0.0-4.9 mcg/L Reference values apply to all ages. | Monday through Friday; 8 a.m. - 2 p.m.; Saturday; 8 a.m. - 3 p.m. Continuously | 1 day | 3 days | 1 | 82300 |  |  |  |  | Rochester
CDOMB | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 21 days
CDOMB | Result | 89539 | Cadmium Occupational Monitor, B | Cadmium Occupational Monitor, B | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5609-3
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 10 - Data

[NAME]
Focus Area 10 - Food Safety - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
10-01a | Campylobacter Species Incidence (rate per 100,000 population) | 11.0 (2000) | 12.8 (2008) | 12.3 | Moved away from target
10-01b | [NAME] E-Coli Incidence (rate per 100,000 population) | 1.7 (2006) | 1.2 (2008) | 1 | Moved toward target
10-01d | Salmonella Incidence (rate per 100,000 population) | 11.3 (2000) | 14.2 (2008) | 6.8 | Moved away from target
10-02a | Outbreaks of Infections Caused by [NAME] E-Coli | 5 (2007) | 1 (2009) | 50% Less | Met or exceeded target
10-02b | Outbreaks of Infections Caused by Salmonella | 3 (2005) | 2 (2009) | 50% Less | Moved toward target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.
Spreadsheet: 84213d1284217068-sumproduct-array-forumlas-overall-percentage-complete-percent-complete-tms
Sheet: P_Complete

Overall |  |  |  |  | Periods | From | To |  | Activity | Budget |  | Reports | Activity | Period | % Complete |  | Costs | Activity | Date | Invoice
 |  |  |  |  | 1 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00 |  | Act01 | 1000 |  |  | Act01 | 1 | 0.1 |  |  | Act01 | 2010-02-01 00:00:00 | 123
Period | Total Invoices | % Complete |  |  | 2 | 2010-01-31 00:00:00 | 2010-03-02 00:00:00 |  | Act02 | 1000 |  |  | Act01 | 2 | 0.15 |  |  | Act01 | 2010-02-04 00:00:00 | 234
1 | 1208.1644 | 0.0675 |  |  | 3 | 2010-03-02 00:00:00 | 2010-04-01 00:00:00 |  | Act03 | 1000 |  |  | Act01 | 3 | 0.2 |  |  | Act01 | 2010-03-05 00:00:00 | 345
2 | 514.9662000000001 | 0.16 |  |  | 4 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 |  | Act04 | 1000 |  |  | Act01 | 4 | 0.25 |  |  | Act02 | 2010-01-08 00:00:00 | 276
3 | 683.4923 | 0.195 |  |  | 5 | 2010-05-01 00:00:00 | 2010-05-31 00:00:00 |  |  |  |  |  | Act02 | 1 | 0.08 |  |  | Act02 | 2010-01-14 00:00:00 | 398
4 |  | 0.24 |  |  | 6 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 |  |  |  |  |  | Act02 | 2 | 0.12 |  |  | Act02 | 2010-03-05 00:00:00 | 167
 |  |  |  |  | 7 | 2010-06-30 00:00:00 | 2010-07-30 00:00:00 |  | Total Budget | 4000 |  |  | Act02 | 3 | 0.13 |  |  | Act03 | 2010-01-08 00:00:00 | 173.88
 |  |  |  |  | 8 | 2010-07-30 00:00:00 | 2010-08-29 00:00:00 |  |  |  |  |  | Act02 | 4 | 0.16 |  |  | Act03 | 2010-01-14 00:00:00 | 250.74
 |  |  |  |  | 9 | 2010-08-29 00:00:00 | 2010-09-28 00:00:00 |  |  |  |  |  | Act03 | 1 | 0.04 |  |  | Act03 | 2010-03-05 00:00:00 | 105.21
 |  | Best/scaleable |  |  | 10 | 2010-09-28 00:00:00 | 2010-10-28 00:00:00 |  |  |  |  |  | Act03 | 2 | 0.2 |  |  | Act04 | 2010-01-25 00:00:00 | 109.5444
Option 1 | Option 2 | Option 3 |  |  |  |  |  |  |  |  |  |  | Act03 | 3 | 0.22 |  |  | Act04 | 2010-02-25 00:00:00 | 157.9662
"Original" | Shorter | Named Ranges |  |  |  |  |  |  |  |  |  |  | Act03 | 4 | 0.15 |  |  | Act04 | 2010-03-25 00:00:00 | 66.28229999999999
0.0675 | 0.0675 | 0.0675 |  |  |  |  |  |  |  |  |  |  | Act04 | 1 | 0.05
0.16 | 0.16 | 0.16 |  |  |  |  |  |  |  |  |  |  | Act04 | 2 | 0.17
0.195 | 0.195 | 0.195 |  |  |  |  |  |  |  |  |  |  | Act04 | 3 | 0.23
 |  | 0.24 |  |  |  |  |  |  |  |  |  |  | Act04 | 4 | 0.4
Range | Name | Dynamic
N2:N13 | RepAct
O2:O13 | RepPer
P2:P13 | RepCom
J2:J5 | Activity
K2:K5 | Budget
Spreadsheet: 678955d1590140109-extracting-data-from-a-table-example-table
Sheet: Sheet1

 | Height |  | Length |  |  |  |  | Length
 | 0.01 |  | 0.006 |  |  |  |  | 0.004 | 0.006 | 0.008 | 0.01 | 0.012 | 0.014
 |  |  |  |  |  | height | 0.01 | 1 | 2 | 1 | 4 | 6 | 2
 |  |  |  |  |  |  | 0.02 | 2 | 3 | 2 | 7 | 7 | 4
 |  |  |  |  |  |  | 0.03 | 3 | 5 | 3 | 8 | 8 | 7
 |  |  |  |  |  |  | 0.04 | 4 | 6 | 4 | 10 | 9 | 8
 | = |  |  |  |  |  | 0.05 | 5 | 7 | 5 | 23 | 10 | 10
 |  |  |  |  |  |  | 0.06 | 6 | 8 | 6 | 12 | 24 | 23
 |  |  |  |  |  |  | 0.07 | 7 | 9 | 7 | 22 | 66 | 12
 |  |  |  |  |  |  | 0.08 | 8 | 10 | 8 | 22 | 77 | 22
Spreadsheet: 863898d1711298678-calendar-tracker-in-different-colours-tracker-log-viewotst-
Sheet: Calendar

 |  |  | [NAME]
 |  |  |  |  | January
 |  |  |  |  | February
 |  |  |  |  | March
 |  |  |  |  | April
 |  |  |  |  | May
 |  |  |  |  | June
 |  |  |  |  | July
 |  |  |  |  | August
 |  |  |  |  | September
 |  |  |  |  | October
 |  |  |  |  | November
 |  |  |  |  | December
Spreadsheet: 191860d1352233900-2-different-counting-functions-on-same-sheet-visits
Sheet: Sheet1

Total Vendors: | 9 | >$1K VENDORS
Vendor contacts YTD:
% Ven contacted YTD:
% Phone contact YTD:
[NAME] | Tot Amt Cert Prev FY | HR RATE | Visit | Phone | Repeat Visit | Date of Contact | Comments | 1 If New Vendor
Vendor 1 | 880.23 | 0
Vendor 2 | 242.75 | 55
Vendor 3 | 55.99 | 32
Vendor 4 | 239.91 | 0
Vendor 5 | 1583 | 0
Vendor 6 | 5794.24 | 0
Vendor 7 | 4498.98 | 80
Vendor 8 | 86.31 | 99
Vendor 9 | 671.96 | 0
Spreadsheet: 65243d1265925246-retrieving-multiple-solutions-with-vlookup-excel_forum
Sheet: Report

Product | Type |  | Cust | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19
1 | 107 |  |  | 0 | 0 | 0 | 125 | 0 | 0 | 0 | 154 | 0 | 0 | 0 | 183 | 0 | 0 | 0 | 143 | 0 | 0 | 0
 |  | Local |  | 0 | 0 | 0 | 125 | 0 | 0 | 0 | 154 | 0 | 0 | 0 | 183 | 0 | 0 | 0 | 143 | 0 | 0 | 0
41 | 104 |  |  | 0 | 0 | 0 | 0 | 27.0000000000004 | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 113 | 0 | 0 | 175
 |  | Local-2 |  | 0 | 0 | 0 | 0 | 27.0000000000004 | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 113 | 0 | 0 | 175
66 | 97 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 76.99999999999909 | 0 | 0 | 0 | 0 | 0
 |  | Local |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 76.99999999999909 | 0 | 0 | 0 | 0 | 0
 |  | Local-2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.000000000000114 | 0 | 0 | 0 | 0 | 0
 |  | ON1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 374.0000000000008 | 0 | 0 | 0 | 0 | 0
Spreadsheet: mary_fischer__25738__Quebecor Amort
Sheet: Quebecor 1.65 @ 60 mos

Quebecor Promo Based on a 5 Year Amortization $1.65MM
Month | Balance | Payment | Principal | Interest | Remaining Periods
2000-04-01 00:00:00 | 0 | 0 | 0 | 0
2000-05-01 00:00:00 | 1650000 | 20699.4361 | 8636.408 | 12063.0281 | 60
2000-06-01 00:00:00 |  | 20699.4361 | 8699.5482 | 11999.8879 | 59
2000-07-01 00:00:00 |  | 20699.4361 | 8763.1499 | 11936.2862 | 58
2000-08-01 00:00:00 |  | 20699.4361 | 8827.2167 | 11872.2194 | 57
2000-09-01 00:00:00 |  | 20699.4361 | 8891.7518 | 11807.6843 | 56
2000-10-01 00:00:00 |  | 20699.4361 | 8956.7587 | 11742.6774 | 55
2000-11-01 00:00:00 |  |  |  |  | 54
2000-12-01 00:00:00 |  |  |  |  | 53
2001-01-01 00:00:00 |  |  |  |  | 52
2001-02-01 00:00:00 |  |  |  |  | 51
2001-03-01 00:00:00 |  |  |  |  | 50
2001-04-01 00:00:00 |  |  |  |  | 49
2001-05-01 00:00:00 |  |  |  |  | 48
2001-06-01 00:00:00 |  |  |  |  | 47
2001-07-01 00:00:00 |  |  |  |  | 46
2001-08-01 00:00:00 |  |  |  |  | 45
2001-09-01 00:00:00 |  |  |  |  | 44
2001-10-01 00:00:00 |  |  |  |  | 43
2001-11-01 00:00:00 |  |  |  |  | 42
2001-12-01 00:00:00 |  |  |  |  | 41
2002-01-01 00:00:00 |  |  |  |  | 40
2002-02-01 00:00:00 |  |  |  |  | 39
2002-03-01 00:00:00 |  |  |  |  | 38
2002-04-01 00:00:00 |  |  |  |  | 37
2002-05-01 00:00:00 |  |  |  |  | 36
2002-06-01 00:00:00 |  |  |  |  | 35
2002-07-01 00:00:00 |  |  |  |  | 34
2002-08-01 00:00:00 |  |  |  |  | 33
2002-09-01 00:00:00 |  |  |  |  | 32
2002-10-01 00:00:00 |  |  |  |  | 31
2002-11-01 00:00:00 |  |  |  |  | 30
2002-12-01 00:00:00 |  |  |  |  | 29
2003-01-01 00:00:00 |  |  |  |  | 28
2003-02-01 00:00:00 |  |  |  |  | 27
2003-03-01 00:00:00 |  |  |  |  | 26
2003-04-01 00:00:00 |  |  |  |  | 25
2003-05-01 00:00:00 |  |  |  |  | 24
2003-06-01 00:00:00 |  |  |  |  | 23
2003-07-01 00:00:00 |  |  |  |  | 22
2003-08-01 00:00:00 |  |  |  |  | 21
2003-09-01 00:00:00 |  |  |  |  | 20
2003-10-01 00:00:00 |  |  |  |  | 19
2003-11-01 00:00:00 |  |  |  |  | 18
2003-12-01 00:00:00 |  |  |  |  | 17
2004-01-01 00:00:00 |  |  |  |  | 16
2004-02-01 00:00:00 |  |  |  |  | 15
2004-03-01 00:00:00 |  |  |  |  | 14
2004-04-01 00:00:00 |  |  |  |  | 13
2004-05-01 00:00:00 |  |  |  |  | 12
2004-06-01 00:00:00 |  |  |  |  | 11
2004-07-01 00:00:00 |  |  |  |  | 10
2004-08-01 00:00:00 |  |  |  |  | 9
2004-09-01 00:00:00 |  |  |  |  | 8
2004-10-01 00:00:00 |  |  |  |  | 7
2004-11-01 00:00:00 |  |  |  |  | 6
2004-12-01 00:00:00 |  |  |  |  | 5
2005-01-01 00:00:00 |  |  |  |  | 4
2005-02-01 00:00:00 |  |  |  |  | 3
2005-03-01 00:00:00 |  |  |  |  | 2
2005-04-01 00:00:00 |  |  |  |  | 1
2005-05-01 00:00:00 |  |  |  |  | 0
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Northern Dauphin

 |  |  |  |  |  |  | 2013 Northern Dauphin
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Every Thursday.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 853095d1703044317-need-help-with-if-function-and-function-and-mod-function-update_001_sales-discount-amount_more-than-multiplier
Sheet: Sheet_001

Sales amount
Segment | Segment's Range ( minimum) | Discount Rate | Discount Amount
1st Segment | 1000 and multipier 1000 | 0.005
2ed Segment | 100000 , multipier 1000 | 0.03
3rd Segment | 250000 , multipier 10000 | 0.02
4th Segment | 1000000 , multipier 100000 | 0.01
5th Segment | 3000000 , multipier 100000 | 0.015
Spreadsheet: 723644d1615818263-if-isnumber-formula-update-cells-with-character-depending-on-dates-holiday-forms-2021
Sheet: Colleague 13

HOLIDAY FORM 2021
NAME: |  |  |  | 2021 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday)
2021 ENTITLEMENT |  | 25 |  | 05/04/2021 (Easter Monday)
CARRIED OVER FROM 2020 |  | 0 |  | 03/05/2021 (May Bank Hol)
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol)
BOUGHT HOLIDAYS FOR 2021 |  | 3 |  | 30/08/2021 (Aug Bank Hol)
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 25/12/2021 (Xmas Day)
Reason: |  |  |  | 27/12/2020 (Xmas BH Day)
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
29/03/2021 | 2021-01-04 00:00:00 | 4
2021-12-07 00:00:00 | 16/07/2021 | 5
Spreadsheet: 773123d1647626279-count-unique-values-in-a-filtered-list-book1
Sheet: Sheet1

Thing 1 | Thing 2
Q | m
W | n
E | h
W | j
E | k
R | G
R | K
R | j
E | k
W | m
E | n
Y | j
G | n
H | m
G | n
H | j
Y | h
Spreadsheet: 184663d1349348890-handling-imported-dates-some-with-a-trailing-space-book4
Sheet: Sheet1

NAME | DATE |  | =Bxx
Timcw | 2011-09-11 00:00:00
JamesCanning | 2012-01-01 00:00:00
[NAME] | 2012-03-01 00:00:00
Taelos | 2012-07-01 00:00:00
[NAME] | 2012-03-03 00:00:00
Dawn Blackmore | 2012-08-03 00:00:00
8a22a | 2012-11-03 00:00:00
stroudwaterboy | 03/15/2012
adoades | 04/18/2012
douglasalt1 | 2012-11-05 00:00:00
cornwell40 | 05/27/2012
aldude52 | 2012-07-06 00:00:00
Msk100 | 2012-10-06 00:00:00
danielwejones | 06/18/2012
seamansgirl | 06/27/2012
webz | 06/30/2012
genhos | 07/21/2012
b.beacroft | 07/27/2012
[NAME] | 2012-04-08 00:00:00
gordoma | 2012-06-08 00:00:00
Aillerrg | 2012-08-08 00:00:00
rose-in-bloom | 08/20/2012
[NAME] | 08/22/2012
shockfire | 08/23/2012
adamhill1988 | 08/23/2012
dweymes1994 | 08/23/2012
djerram | 08/31/2012
sapient | 2012-12-09 00:00:00
t0ka | 09/22/2012
nate13 | 09/24/2012
wimbledog | 09/26/2012