tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_lavorato__16545__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 792812d1661177545-formula-for-stacking-values-warehouse-inventory
Sheet: MASTER SHEET

FABRIC DESCRIPTION | TOTAL STOCK IN | TOTAL STOCK OUT | CURRENT STOCK
190/180 RECDWUV
180/150 RENDWUV
99/165 NDWUV
48/70 CDW - GRN
48/70 NDW
120/160 RECSFUV
108/150 NDWUV
190/150 NDWUV
40/70 NDW
120/160 CDWUV - CLR
67/42/150 - GUSSET (BLUE)
72/65 NDFUV
128/60 CSFUV - CLR
108/150 NSWUV
113/150 NSWUV
99/200 CDWUV - BLK
90/55/150 CDFUV - GUSSET (BLUE)
88/65 NDFUV
70/150 CDFUV - BLUE
200/150 NDWUV
190/180 RECDWUV - GRN/PBLUE
105/65 NDFUV
190/150 NDWUV - RE MARKINGS
103/170 NSWUV
99/150 NDWUV
190/190 RENDWUV
105/65 [NAME]
Spreadsheet: 777729d1650566196-reverse-matrix-lookup-return-array-of-matching-values-in-column-reverse-lookup-from-matrix
Sheet: Sheet1

Product | FIRST SALE | part 1 | part 2 | part 3 | part 4 |  |  | PARTS | MIN | MAX
1111 | 2022-01-01 00:00:00 | A | B | C |  |  |  | A
2222 | 2022-02-01 00:00:00 | A | G | H | I |  |  | B
3333 | 2022-03-01 00:00:00 | D | E | F |  |  |  | C
4444 | 2022-04-01 00:00:00 | F | I | K |  |  |  | D
5555 | 2022-05-01 00:00:00 | A | B | E |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
TABLE 1 |  |  |  |  |  |  |  | TABLE 2
Spreadsheet: 274399d1383105721-add-cells-together-that-have-a-certain-name-associated-with-them-excel-help
Sheet: Sheet1

 |  |  |  |  |  |  |  | [NAME] | Price Type | Hours Worked | Hours Overtime | Hours Charged | Total Sell
 |  |  |  |  |  |  |  | [NAME] | Fleet | 15.07 | 0.3 | 25.7375 | 2367.37
 |  |  |  |  |  |  |  | [NAME] | Internal N | 6.46 | 0.13 | 1.1051 | 101.67
 |  |  |  |  |  |  |  | [NAME] | Workshop | 28.21 | 0.12 | 33.2736 | 4353.87
 |  |  |  |  |  |  |  | [NAME] | Warranty | 5.57 | 0 | 4.6 | 469.33
 |  |  |  |  |  |  |  | [NAME] | Fleet | 18 | 0.13 | 24.3302 | 2270.16
 |  |  |  |  |  |  |  | [NAME] | Internal N | 4.44 | 0.07 | 0.748 | 96.49
 |  |  |  |  |  |  |  | [NAME] | Workshop | 113.97 | 0.51 | 106.1148 | 13295.74
 |  |  |  |  |  |  |  | [NAME] | Warranty | 1.78 | 0.03 | 1.1 | 118.08
 |  |  |  |  |  |  |  | [NAME] | Fleet | 18.16 | 0 | 18.927 | 1771.87
 |  |  |  |  |  |  |  | [NAME] | Internal N | 5.16 | 0.03 | 2.4996 | 353.44
 |  |  |  |  |  |  |  | [NAME] | Workshop | 31.91 | 0.75 | 42.0282 | 5406.22
 |  |  |  |  |  |  |  | [NAME] | Warranty | 3.36 | 0 | 6.027 | 704.54
 |  |  |  |  |  |  |  | [NAME] | Fleet | 23.6 | 0 | 34.8871 | 3375.74
 |  |  |  |  |  |  |  | [NAME] | Internal N | 2.59 | 0 | 1.9564 | 263.98
 |  |  |  |  |  |  |  | [NAME] | Workshop | 49.24 | 0.31 | 56.4104 | 6890.25
 |  |  |  |  |  |  |  | [NAME] | Warranty | 3.87 | 0 | 9.9 | 1087.78
 |  |  |  |  |  |  |  | [NAME] | Fleet | 14.01 | 0 | 14.3471 | 1338.39
 |  |  |  |  |  |  |  | [NAME] | Internal N | 15.68 | 0.09 | 14.0526 | 1541.77
 |  |  |  |  |  |  |  | [NAME] | Workshop | 43.28 | 0 | 41.1635 | 5207.76
 |  |  |  |  |  |  |  | [NAME] | Warranty | 1.01 | 0 | 2.1 | 231.16
 |  |  |  |  |  |  |  | [NAME] | Fleet | 24.95 | 0.08 | 29.124 | 2674.45
 |  |  |  |  |  |  |  | [NAME] | Internal N | 2.65 | 0 | 0 | 0
 |  |  |  |  |  |  |  | [NAME] | Workshop | 31.28 | 0.03 | 32.3267 | 4212.76
 |  |  |  |  |  |  |  | [NAME] | Warranty | 1.9 | 0 | 1.3 | 139.1
 |  |  |  |  |  |  |  | [NAME] | 55 Plus | 0.8 | 0 | 1.1057 | 105.04
 |  |  |  |  |  |  |  | [NAME] | Fleet | 36.07 | 0.1 | 41.5477 | 4068.56
 |  |  |  |  |  |  |  | [NAME] | Internal N | 5.75 | 0 | 4.1214 | 529.67
 |  |  |  |  |  |  |  | [NAME] | Workshop | 95.69 | 0.46 | 120.6756 | 14082.2
 |  |  |  |  |  |  |  | [NAME] | Warranty | 2.12 | 0 | 3.8 | 408.29
 |  |  |  |  |  |  |  | [NAME] | 55 Plus | 1.88 | 0.03 | 1.1 | 148.5
 |  |  |  |  |  |  |  | [NAME] | Fleet | 25.15 | 0.05 | 23.3503 | 2242.64
Spreadsheet: 747723d1631666254-time-to-expiry-date-formula-not-working-training_log_sample
Sheet: Course List

 |  | ?
 |  | COURSE LIST
 |  | TITLE | CERTIFICATION EXPIRES? | CERTIFICATION LENGTH | COST OF COURSE | TRAINING PROVIDER | [NAME]
 |  | Housing for Beginners | No |  | 750 | Housing Training Services Ltd | General introduction to housing
 |  | Surveying for Beginners | No |  | 750 | Housing Training Services Ltd | General introduction to housing surveys
 |  | Surveying Intermediate | Yes | 3 | 800 | Housing Training Services Ltd | Stage 2 of General Surveying Certificate
 |  | Architecture for Beginners | No |  | 750 | Trainers R Us | Stage 1 of General Architecting Certificate
 |  | Architecture Intermediate | No |  | 850 | Trainers R Us | Stage 2 of General Architecting Certificate
 |  | Advanced Architecture | Yes | 2 | 540 | Housing Training Services Ltd | Stage 3 of General Architecting Certificate
 |  | Advanced Surveying | Yes | 3 | 750 | Housing Training Services Ltd | Stage 3 of General Surveying Certificate
 |  | Housing Health & Safety | Yes | 1 | 150 | CBC - HR | Annual health & Safety certificate
 |  | Contracts for Beginners | No |  | 250 | Trainers R Us | Stage 1 of General Contracts Certificate
 |  | Contracts Intermediate | Yes | 3 | 650 | Trainers R Us | Stage 2 of General Contracts Certificate
 |  | Advanced Contracts | No |  | 850 | Trainers R Us | Stage 3 of General Contracts Certificate
 |  | Managing for Managers | No |  | 1250 | Acme Training Services | How to manage managers
Spreadsheet: 197516d1354401074-how-do-i-link-formulas-to-total-data-from-2-colums-with-differing-subjects-excelforum-01-12-2012
Sheet: Sheet1

Duration (days) | Area |  | Overdue | 21-30 | 31-40 | 41-50 | 51-100
21 | F |  | C |  | 2 | 1 | 1
22 | E |  | E | 4
22 | H |  | F | 2
22 | W |  | M | 1
23 | E |  | S | 3 |  |  | 1
23 | S |  | W | 4 | 1 | 1
23 | S |  | U | 1
23 | W |  | T | 1 | 1
24 | E |  | H | 2 | 2 | 1
24 | H |  | N |  | 1
24 | U
25 | F
26 | W
27 | S
28 | T
29 | M
30 | E
30 | W
34 | C
34 | T
37 | C
37 | H
37 | H
37 | N
37 | W
43 | C
44 | H
45 | W
61 | C
61 | S
Spreadsheet: 857003d1706110308-find-value-return-sheet-colum-and-row-name-searchexample_excelforum_v5
Sheet: DETALLES Fl

REF | NAME
1 | TGF |  | C | 4
 | TAGF |  | A | 10
2 | MGF |  | A | 2 | F 2 | A | 3 | F 2 | C | 8
 | MGR |  | D | 7 | F 2 | D | 8 | F 2 | E | 2
 | CAGF |  | A | 8
 | CAGR |  | E | 7
Spreadsheet: 288312d1389154734-complex-dropwons-lists-need-help-dependant-menu-example
Sheet: data

Menu | Menu_Start | Product
breakfast | breakfast | eggs
lunch | breakfast | bacon
dinner | breakfast | muffin
 | lunch | salad
 | lunch | burger
 | lunch | sandwich
 | dinner | steak
 | dinner | fish
 | dinner | chicken
Spreadsheet: c7ea94a0-d061-4dcc-8153-2eed9a5f20c9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Police
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2340 |  | 129996 |  | X |  |  |  | 428487 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 428487
BUSINESS UNIT: |  |  |  | KCPDU |  | DATE: |  |  |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2340 |  | 129996 |  | 980001 |  |  |  | 428487 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 428487
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 0
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 706995d1606992133-using-index-match-function-to-create-multi-dependent-drop-down-lists-returning-error-quoting-tool-v10
Sheet: Quoting Tool

Proactive Product Pricing Quote Tool
 |  | =INDEX('Master Table Lookup'!$H$8:$S$25,,MATCH($B5,Product_Services,0))
 |  | =INDEX('Master Table Lookup'!$H$8:$X$25,,MATCH($B5,Product_Services,0))
Data Validation = List, Master Table Lookup MTL), Column A (named Table Range = Product) | Dependent dropdown list based on Col A selection, looking up MTL B8:F30 = Named Tabled Range Product_Services | Dependent dropdown list based on Col B selection, looking up MTL H8:V30 = Named Tabled Range Product_Services | Lookup dependent on Col C selection | Lookup dependent on Col C selection |  | Calculated Cell (E*F)
Product | Product Services | Product Service Options | Product Descriptions | Unit Price | Qty | Total Cost
Travel, [NAME] and [NAME] | Travel time |  |  |  | 5
Mobile Clinic | Health Monitoring | Four Corners of Health Workshops |  |  | 1
Injury Prevention and Early Intervention | Workstation Assessments and DPI Prevention | Workstation Screen – Individual Education |  |  | 5
Injury Prevention and Early Intervention | Workstation Assessments and DPI Prevention | Workstation Screen - Group Education |  |  | 1
Occupational Health and Wellbeing | Pre-employment Test | Heat and Cold Stress |  |  | 1
 |  |  | Total Cost
Spreadsheet: 769931d1645725557-xlookup-assistance-sample-workbook
Sheet: FORM

 | . | PART ORDER FORM
 |  | 25155
To: | National Bus Sales | 2022-02-24 00:00:00
 | 8649 S Regency Dr
 | Tulsa, OK, 74131
 |  | Prod #:
From: | Executive Coach Builders, INC | Sales:
 | 4400 [NAME] | Ordered By :
 | Springfield, Missouri 65803 | Phone # :
 |  | Payment type :
Part # | Part Description | Quantity | Price | Ext. Total
1A | TEST PART 1 | 1 |  | 0 | D
2B | TEST PART 2 | 1 |  | 0 | S
3C | TEST PART 3 | 1 |  | 0 | S
4D | TEST PART 4 | 1 |  | 0 | D
5E | TEST PART 5 | 1 |  | 0 | S
6F | TEST PART 6 | 1 |  | 0 | S
7G | TEST PART 7 | 1 |  | 0 | D
8H | TEST PART 8 | 1 |  | 0 | S
9I | TEST PART 9 | 1 |  | 0 | S
10J | TEST PART 10 | 1 |  | 0 | S
 |  |  | Subtotal | 0
 |  |  | Shipping
 |  |  | Total : | 0
Spreadsheet: 271958d1382116721-calculate-percentage-change-across-two-separate-tables-tracker1
Sheet: Week2

Programs | Subject1 | Subject2 | Subject3 | Subject4 | Subject5 | Totals
101 | 1 | 2 | 1 | 3 | 1
102 | 2 | 2 | 1 | 2 | 1
103 | 3 | 2 | 1 | 2 | 1
104 | 1 | 1 | 1 | 2 | 1
105 | 1 | 2 | 2 | 1 | 1
106 | 4 | 1 | 1 | 3 | 1
107 | 1 | 4 | 2 | 3 | 1
107B | 2 | 3 | 2 | 1 | 2
108 | 1 | 4 | 1 | 2 | 2
109 | 4 | 1 | 1 | 3 | 2
110 | 2 | 1 | 3 | 1 | 1
111 | 1 | 2 | 2 | 1 | 1
Total
Spreadsheet: 65924b3a-1303-4eda-af6b-5fcba131dab2
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
PIOR | Test | PIOR | Pityrosporum orbiculare, IgE | Pityrosporum [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PIOR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PIOR | Result | PIOR | Pityrosporum [NAME], IgE | Pityrosporum [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10949-6 | Malassezia [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 875019d1721569672-how-to-create-a-shortcut-to-transform-the-green-conditional-formatting-in-1-mpp-post-dif-position
Sheet: Liste

Group | Status | Location 1 | Locations 2&3 | Triggers | Local / Expat | Work scheme |  |  | Group | Status | Location 1 | Locations | Triggers
CPF | BOC Secondee | France | EPC- CPF Offices | FID | Local | Rotation |  |  | Organisation Chart will be divided in five main groups | Staff [NAME] to be used when position will be opened for both status | Pre FID Location | ME base = Middle east base | Example: NWP - Cstr = Start of site activities for NWP Package
NWP | Staff TTE | UK | Site | CPF - Cstr | Expat | Residential |  |  | PMT are all the people not included in any package nor Drilling | TAS= expatriate TAS by opposition to TAS local |  |  | Comm. = Commissioning
EWI | Staff [NAME] | COC | ME base | NWP - Cstr |  |  |  |  | DRL = Drilling
DRL | TAS | NA | ME + Site | P.camp - Cstr |  |  |  |  | EXP= Exploitation
PMT | TAS local | Site | EPC- NWP Offices | EW - Cstr
EXP |  | HQ Basra | NA | Comm.
 |  | UK 1/5Q & PAU 4/5Q | TBD | RFSU
 |  |  | HQ Basra | NA
Spreadsheet: 110829d1307433347-excel-2007-weird-rounding-problem-weird-rounding-problem
Sheet: Sheet1

 | ORIGINAL NUMBER | B6*10000 | ROUND(B6*10000,20) | IF(MOD(C7,1)=0.5,MROUND(C7,2),ROUND(C7,B13-1-INT(LOG10(C7)))) | MOD(C7,1) | MROUND(C7,2)
 | 0.00145 | 14.5 | 14.5 | 0 | 0.4999999999999982 | FALSE
 | 0.00145 | 14.5 | 14.5 | 14 | 0.5 | 14
 | 0.00145 | 14.5 | 14.5 | 14 | 0.5 | 14
Spreadsheet: 116524d1311878402-selective-columns-handicapscorecards-master
Sheet: Master

Course
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tee | Yellow
HOLE > | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | OUT | Total
par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handicap |  |  | Handicap | Stableford |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
Stroke Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSS |  | Playing | Correct | Exact | Alteration | Points | Par 3 |  | Par Adjusted for Handicap |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IN | OUT | Total |  | Strokes added for Handicap |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IN | OUT | Total
Adams. [NAME] | 4 | 4 | 4 | 5 | 9 | 5 | 4 | 4 | 4 | 6 | 9 | 6 | 4 | 4 | 5 | 5 | 4 | 7
[NAME]. [NAME] | 5 | 6 | 5 | 6 | 3 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 | 5
Baxter. [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
[NAME]. [NAME] | 5 | 6 | 7 | 6 | 5 | 6 | 7 | 6 | 5 | 6 | 5 | 6 | 7 | 6 | 7 | 6 | 7 | 6
[NAME]. Martyn | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5
[NAME]. [NAME] | 6 | 5 | 4 | 3 | 4 | 5 | 6 | 5 | 4 | 3 | 4 | 5 | 6 | 3 | 5 | 4 | 6 | 7
Spreadsheet: c3a50b6c-611c-47e9-9fbe-91c349d61850
Sheet: Sheet1

BELKNAP COUNTY OFFICES - Democratic | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Sept. 12, 2000 | Sheriff |  |  | County Attorney |  |  | Treasurer
 |  | Hodges, r | [NAME] |  | [NAME], r | [NAME] |  | Corbin, r | [NAME]
Alton |  | -- | 1 |  | -- | 1 |  | -- | --
Barnstead |  | -- | 7 |  | -- | 1 |  | -- | 2
Belmont |  | 7 | 3 |  | 6 | 1 |  | 4 | 1
Center Harbor |  | 3 | -- |  | 1 | -- |  | 1 | --
Gilford |  | 11 | 4 |  | 5 | 9 |  | 3 | 1
Gilmanton |  | 2 | 4 |  | -- | 6 |  | 1 | 2
[NAME] |  | -- | -- |  | 1 | 2 |  | 1 | --
[NAME] |  | 2 | 2 |  | 2 | 1 |  | 2 | 1
[NAME] 3 |  | 7 | -- |  | 1 | 5 |  | -- | 1
[NAME] |  | 2 | 4 |  | 1 | 3 |  | -- | 4
[NAME] |  | 5 | 2 |  | 4 | 2 |  | 1 | 1
[NAME] 6 |  | 8 | 2 |  | 3 | 3 |  | -- | 2
Meredith |  | 7 | 3 |  | 6 | 1 |  | -- | 1
New Hampton |  | 5 | 2 |  | 5 | 1 |  | 1 | 1
Sanbornton |  | 3 | 2 |  | 9 | -- |  | 1 | 1
[NAME] |  | -- | 3 |  | 1 | 1 |  | -- | 1
TOTALS |  | 62 | 39 |  | 45 | 37 |  | 15 | 19
 | Reg. Of Deeds |  |  |  | Reg. Of Probate
 |  | Normandin, r | [NAME] |  |  | Dearborn, r | [NAME]
Alton |  | -- | -- |  |  | -- | --
Barnstead |  | 1 | 1 |  |  | 1 | 1
Belmont |  | 4 | 2 |  |  | 2 | --
Center Harbor |  | 2 | -- |  |  | 2 | --
Gilford |  | 10 | 5 |  |  | 5 | 5
Gilmanton |  | 3 | 3 |  |  | 2 | 2
[NAME] |  | 4 | 2 |  |  | 1 | --
[NAME] |  | 6 | -- |  |  | 2 | --
[NAME] 3 |  | 8 | -- |  |  | 5 | --
[NAME] |  | 1 | 3 |  |  | 1 | 2
[NAME] |  | 6 | 1 |  |  | 5 | --
[NAME] 6 |  | 9 | 2 |  |  | 4 | 2
Meredith |  | 2 | 1 |  |  | 1 | 2
New Hampton |  | 2 | 2 |  |  | 2 | 1
Sanbornton |  | 7 | -- |  |  | 4 | --
[NAME] |  | -- | 1 |  |  |  | 1
TOTALS |  | 65 | 23 |  |  | 37 | 16
BELKNAP COUNTY OFFICES - Democratic
 | County Commissioners
Page 2/2 | Dist. No. 1 |  |  |  | Dist. No. 2 |  | Dist. No. 3
 |  | Colby, r | Daigneault, r | [NAME] |  |  | Daigneault | Boothby, r | [NAME]
Alton |  |  |  |  |  |  |  | -- | --
Barnstead |  |  |  |  |  |  |  | -- | 2
Belmont
Center Harbor
Gilford |  |  |  |  | NO ELECTION |  | 11 | 1 | 9
Gilmanton
[NAME] |  | 8 | 18 | --
[NAME] |  | 10 | 11 | --
[NAME] 3 |  | 6 | 14 | --
[NAME] |  | 3 | 31 | 3
[NAME] |  | 1 | 20 | 1
[NAME] 6 |  | 3 | 20 | 2
Meredith |  |  |  |  |  |  | 2 | 7 | --
New Hampton
Sanbornton
[NAME]
TOTALS |  | 31 | 114 | 6 |  |  | 13 | 8 | 11
Spreadsheet: robin_rodrigue__33410__P&LSum
Sheet: Orig

QUARTER 1 ORIGINATION
 | Jan | Feb | Mar | Total |  | Options | Alberta
Marketing Transactions transferred from [NAME] | 2290855 | 2288744 | 1392731
Excluded because Amounts did not flow through the DPR:
BlueRange Orig with Credit | 26625000
BlueRange Writeoff/Recovery | -16598410 |  | 25854
Spreadsheet: 44319d1242921759-ifsum-problem-master
Sheet: Bar Business

WEEK COMMENCING
SALES ANALYSIS | MON | TUES | WED | THURS | FRI | SAT | SUN | TOTAL
DATE | 2009-05-18 00:00:00 | 2009-05-19 00:00:00 | 2009-05-20 00:00:00 | 2009-05-21 00:00:00 | 2009-05-22 00:00:00 | 2009-05-23 00:00:00 | 2009-05-24 00:00:00
Time Closed          ===>
TILL 2
TILL 3
TOTAL TILL VARIANCE
BUDGET | 0 | 0 | 500 | 500 | 1500 | 1500 | 0
TOTAL
BUDGET V ACTUAL
DOOR INCOME
C/ROOM INCOME
TOTAL
FOOD SALES
GAMES MACHINES
MACHINE SALES
CIGS MCHINE
TOTAL
TOTAL SALES
EXPENSES
Cash on Delivery | 90.66
EFT TRANSACTIONS
TOTAL
TOTAL CASH IN BAG
CASH BAG NUMBER
TOTAL BANKED MONEY
STAFF LABOUR COST
SECURITY COST
[NAME]
LABOUR %
Spreadsheet: 799417d1665070802-formula-to-get-ecact-date-date-3-
Sheet: RAW DATA

 |  |  |  |  | Today
 |  |  | Mode | Start Date | Resut formula
 |  |  | Half Yearly | 2018-03-30 00:00:00 |  | I need next date based on today and [NAME] (Yearly / Half yearly)
 |  |  | Yearly | 2018-07-24 00:00:00
 |  |  | Yearly | 2021-03-22 00:00:00
 |  |  | Yearly | 2013-01-28 00:00:00
 |  |  | Half Yearly | 2006-07-28 00:00:00
 |  |  | Yearly | 2008-05-24 00:00:00
 |  |  | Yearly | 2007-03-23 00:00:00
 |  |  | Yearly | 2005-02-28 00:00:00
 |  |  | Yearly | 2007-03-23 00:00:00
 |  |  | Yearly | 2007-01-31 00:00:00
Spreadsheet: 141714d1329407587-formula-to-show-true-false-time-on-course
Sheet: Sheet1

 | Start Date | 3 Months | 6 Months | 1 Year | End before 3 Months | End Before 6 Months but after 3 months | End Before 1 year but after 6 months | End After a Year | End date
 | 2012-11-27 00:00:00 | 2013-02-25 00:00:00 | 2013-05-26 00:00:00 | 2013-11-27 00:00:00 | Yes | No | No | No | 2012-02-20 00:00:00
 | 2011-08-20 00:00:00 | 2011-11-18 00:00:00 | 2012-02-16 00:00:00 | 2012-08-19 00:00:00 | NO | No | No | Yes | 2012-11-15 00:00:00
 | 2011-03-01 00:00:00 | 2011-05-30 00:00:00 | 2011-08-28 00:00:00 | 2012-02-29 00:00:00 | NO | No | No | Yes | 2012-03-01 00:00:00
 | 2012-02-01 00:00:00 | 2012-05-01 00:00:00 | 2012-07-30 00:00:00 | 2013-01-31 00:00:00 | Yes | No | No | No
 | 2012-02-05 00:00:00 | 2012-05-05 00:00:00 | 2012-08-03 00:00:00 | 2013-02-04 00:00:00 | Yes | No | No | No
Spreadsheet: 858506d1707163742-filter-not-bold-values-filtere-not-bold-values
Sheet: Sheet1

 |  | Assets |  |  |  | <<< | I need formula to filter only not bold values.
 |  |  |  |  | Property plant and equipment
 |  | Property plant and equipment |  |  | intangible Assets
 |  | intangible Assets |  |  | Investment
 |  | Investment |  |  | Financial assets
 |  | Financial assets
 |  | Total Non Current Assets
 |  | Cash and cash equivalents
 |  | Prepayments
 |  | Trade and other receivables
 |  | Dividends recievable
 |  | Interest receivable
 |  | Total Current Assets
 |  | Total Assets
 |  | Capital
 |  | Charter Capital
 |  | Retained earnings
 |  | Total Equity
 |  | Current Liabilities
 |  | Trade and other payables
 |  | Total Current Liabilities
 |  | Total Liabilities
 |  | Total equity and liabilities
Spreadsheet: 699687d1602706468-vlookup-via-dropdown-from-second-sheet-sampledata2a-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | This dropdown should show number of weeks/months
 |  |  |  |  |  |  |  |  |  |  |  |  | dependent on content in column F in sheet2 |  |  |  |  |  |  | The selection in O should
 |  |  |  |  |  |  |  |  |  |  |  |  | so user can select payment period. |  |  |  |  |  |  | be displayed here for further calculations
 | 2020-10-28 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | 4 Weeks
 |  | 5 |  |  |  |  |  |  |  |  |  |  | 2 Months | 4 Weeks |  |  |  |  |  | 2 | 4
 |  | 8 |  |  |  |  |  |  |  |  |  |  | 3 Months | 6 Weeks |  |  |  |  |  | 3 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 Months | 8 Weeks |  |  |  |  |  | 4 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 Months | 10 Weeks |  |  |  |  |  | 5 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 Months | 12 Weeks |  |  |  |  |  | 6 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 Months | 14 Weeks |  |  |  |  |  | 7 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 Months | 16 Weeks |  |  |  |  |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 Months | 18 Weeks |  |  |  |  |  | 9 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 Months | 20 Weeks |  |  |  |  |  | 10 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 Months |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 Months |  |  |  |  |  |  | 12
Spreadsheet: 719912d1613906565-countif-how-to-get-rows-between-date-book1
Sheet: Sheet1

 |  |  |  | From | To | Count
1901–1910 | 38237 | 385 |  | 1941 | 1981
1911–1920 | 42082 | 195
1921–1930 | 44027 | 201
1931–1940 | 45067 | 206
1941–1950 | 46038 | 213
1951–1960 | 50225 | 258
1961–1970 | 52807 | 312
1971–1980 | 55928 | 42
1981–1990 | 56357 | 108
1991–2000 | 57439 | 161
2001–2010 | 59113 | 324
2011–2021 | 63182 | 530