tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788543d1658517145-formular-to-get-sum-in-another-sheet-analysis
Sheet: SHEET3

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA MUHULA WA KWANZA JULAI, 2022 DARASA LA TATU
NA | SHULE | KATA | WALIOFANYA |  |  | WALIOFAULU |  |  | A |  |  | B |  |  | C |  |  | % [NAME] | WASTANI WA ALAMA | D |  |  | E |  |  | % YA WALIOFELI | [NAME] SHULE
 |  |  | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML |  |  | WAV | WAS | JML | WAV | WAS | JML
1 | NAMELOCK
2 | KINUA
3 | NJIAPANDA
4 | OLOIMUGI
5 | KAZINGUMU
6 | [NAME]
7 | MUUNGANO
8 | Nhati
9 | MWITIKIRA
10 | NDEDO
Spreadsheet: 83490d1283451681-rolling-average-formula-example-1-
Sheet: Sheet1

 | Midnight | Day | Afternoon | Total
2010-08-01 00:00:00 | 1 | 2 | 3
2010-08-02 00:00:00 | 4 | 5 | 6
2010-08-03 00:00:00 | 7 | 8 | 9
2010-08-04 00:00:00 | 10 | 11 | 12
2010-08-05 00:00:00 | 13 | 14 | 15 |  |  | 30 shift average
2010-08-06 00:00:00 | 16 | 17 | 18
2010-08-07 00:00:00 | 19 | 20 | 21
2010-08-08 00:00:00 | 22 | 23 | 24
2010-08-09 00:00:00 | 25 | 26 | 27
2010-08-10 00:00:00 | 28 | 29 | 30
2010-08-11 00:00:00 | 31 | 32 | 33
2010-08-12 00:00:00 | 34 | 35 | 36
2010-08-13 00:00:00 | 37 | 38 | 39
2010-08-14 00:00:00 | 40 | 41 | 42
2010-08-15 00:00:00 | 43 | 44 | 45
2010-08-16 00:00:00 | 46 | 47 | 48
2010-08-17 00:00:00 | 49 | 50 | 51
2010-08-18 00:00:00 | 52 | 53 | 54
2010-08-19 00:00:00
2010-08-20 00:00:00
2010-08-21 00:00:00
2010-08-22 00:00:00
2010-08-23 00:00:00
2010-08-24 00:00:00
2010-08-25 00:00:00
2010-08-26 00:00:00
2010-08-27 00:00:00
2010-08-28 00:00:00
2010-08-29 00:00:00
2010-08-30 00:00:00
2010-08-31 00:00:00
Spreadsheet: 455180d1460141846-trouble-selecting-specific-values-from-a-cell-containing-other-values-and-text-example1
Sheet: Sheet1

 |  |  |  | Helper Column | Lower Limit | Upper Limit
Title: Example 1       Date: Today
 |  |  |  |  |  |  | Desired Outcome
Serial: 1
A      1 < 11 < 50
B      100 < 101 < 102
C      2 < 4 < 8
D      -1 < -2 < -3
Result: Pass
Serial: 2
A     1 < 8 < 50
B     100 < 101 < 102
Result: Fail
Serial: 3
A     1 < 33 < 50
B    100 < 101 < 102
C     2 < 4 < 8
D    -1 < -2 < -3
Result: Pass
Spreadsheet: 064c2195-b95f-41c5-bd65-48fb28f17e38
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | International Taekwon-Do Federation | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | International Instructor Course
 |  |  | Individual Application Form
 |  | City: |  |  | Country:
Participant:
 | name |  |  |  | surname |  |  | M/F
Address:
 | street |  |  |  | number | code | city
Date of Birth: |  |  |  |  | Nationality:
 | year | month | day
e.mail:
actual kup/degree |  |  |  |  | ITF degree number: |  | -    -
signature:
Participants Instructor and/or Master:
 | name |  |  |  | surname
Plaque Certificate number: |  |  |  |  | ITF degree number: |  | -    -
e.mail:
signature:
Organiser:
(Federation/Association name)
President:
 | name |  |  |  | surname
e.mail:
signature:
date of event: | 2013 | June | 1-2
 | year | month | day
please send this application form with 1 photo (name attach)
on or before 30 April 2013
[NAME]
Secretary General ITF-JAPAN
[EMAIL]
Spreadsheet: 142294d1329765449-sumif-begins-with-help-sumif-test
Sheet: Sheet1

5090-00 | Absorbed Labor | -253284.8
5090-10 | Absorbed Labor: Shop | 0
5090-20 | Absorbed Labor: D&E | -18253
5090-94 | Absorbed Labor - Unbillable | -62500
5090-95 | Absorbed Labor: Subcontract | 0
5100-10 | Holiday wages: Shop | 0
5100-20 | Holiday wages: D&E | 0
Spreadsheet: 51055d1250625525-sum-help-for-help
Sheet: Sheet1

 |  |  | HDR
name |  |  | daily entry | cumlative total
[NAME] |  |  | 4 | 4 |  | [NAME] has 4 entries today, the first day for a cumlative of 4, but then tomorrow ) the 2nd day) I need to enter that [NAME] had 3 for that day to bring his cumlative to 7, then repeat each day and for each person the same way.
MARY |  |  | 6 | 6 |  | mary same as able
[NAME] |  |  | 8 | 8 |  | [NAME] same as above
[NAME] |  |  | 10 | 10 |  | [NAME] same as ablove
 |  |  |  |  |  | I need the cumlative to always update with each new daily entry but only for the row (person) im working on.
 |  |  |  |  |  | Thanks a bunch.
Spreadsheet: 145730d1331725037-excel-2007-alternative-for-using-sumif-with-a-3d-reference-example-3d-sumif
Sheet: Loc_b

 |  |  | Area location: | [NAME] |  |  |  |  |  |  |  | Loc_A
 |  |  |  |  |  | 2011 | 2012 | 2013 | 2014 | 2015
 |  |  |  |  | Sales | 50 | 40 | 50 | 40 | 50
 |  |  |  |  | Revenue | 25 | 20 | 25 | 20 | 25
Spreadsheet: 54637d1254683254-testing-for-blank-cells-testdata
Sheet: Sheet1

RRR | 123 | 555 | 60-EC1 | 45556 | 45559 | [NAME] | [NAME] | [NAME] | [NAME] | 234 | 457 |  | 678 | 367 | 876 | [NAME] | [NAME] | [NAME]
MTC | 233 | 234 | 40-30E | 4577 | 4578 | [NAME] | [NAME] | [NAME] | [NAME] | 2345 |  | 678 |  |  |  | [NAME] | [NAME] | [NAME]
TTT | 444 | 765 | 50-A10-B | 9876 | 9878 | [NAME] | [NAME] | [NAME] | [NAME] | 432 |  | 346 |  |  | 456 | [NAME] | [NAME] | [NAME]
BBB | 333 | 788 | 12-4ES-B | 45678 | 45690 | [NAME] | [NAME] | [NAME] | [NAME] | 567 | 566 | 677 |  |  |  | [NAME] | [NAME] | [NAME]
BBB | 444 | 667 | 45-3D-DF | 34564 | 34554 | [NAME] | [NAME] | [NAME] | [NAME] | 433 | 444 |  |  | 566 |  | [NAME] | [NAME] | [NAME]
Spreadsheet: 292711d1390759280-excel-quiz-question-randomizer-random-selection
Sheet: Sheet1

Question |  | Include?
1 |  |  |  | Number of Questions: | 40 | **Change this
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Spreadsheet: 166049d1341439270-drop-down-menu-to-show-data-4-variables-by-weeks-drop-down-showing-data-oeldere2-
Sheet: Data

 | Week | % | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | local damages |  | 14 | 12 | 5 | 11
 | mistakes |  | 5 | 3 | 1 | 9
 | lacks |  | 2 | 6 | 15 | 2
 | remote damages |  | 8 | 16 | 4 | 3
 | local damages % | 2 |  | 0.8571428571428571 | 0.4166666666666667 | 2.2
 | mistakes % | 2 |  | 0.6 | 0.3333333333333333 | 9
 | lacks % | 2 |  | 3 | 2.5 | 0.1333333333333333
 | remote damages % | 2 |  | 2 | 0.25 | 0.75
 | select work | sel.week |  |  | %
 | local damages | 3 |  | 5 | 0.4166666666666667
 | lacks | 4 |  | 2 | 0.1333333333333333
 | mistakes | 1 |  | 5
 | remote damages | 3 |  | 4 | 0.25
 |  |  |  |  |  |  |  |  | % | 2
 |  |  |  |  |  |  |  |  |  | Waarden
 |  |  |  |  |  |  |  |  | Rijlabels | Som van 1 | Som van 2 | Som van 3 | Som van 4
 |  |  |  |  |  |  |  |  | lacks | 0 | 3 | 2.5 | 0.1333333333333333
 | No ZEROES in this spreadsheet |  |  | 14.28571428571429 | 58.33333333333334 | -120 |  |  | local damages | 0 | 0.8571428571428571 | 0.4166666666666667 | 2.2
 |  |  |  | 40 | 66.66666666666667 | -800 |  |  | mistakes | 0 | 0.6 | 0.3333333333333333 | 9
 |  |  |  | -200 | -150 | 86.66666666666667 |  |  | remote damages | 0 | 2 | 0.25 | 0.75
 |  |  |  | -100 | 75 | 25 |  |  | Eindtotaal | 0 | 6.457142857142857 | 3.5 | 12.08333333333333
Spreadsheet: 40474d1238776871-excel-2007-compare-and-show-only-the-different-value-cells-as-result-compare-2
Sheet: Details

 | Master Data |  |  | To Check |  |  | Result
 | Request_A | Item_A |  | Request_B | Item_B |  | Request_Final | Item_Final
 | 10051 | 10 |  | 10051 | 10 |  | 10051 | 20
 | 10051 | 20 |  | 10052 | 10 |  | 10053 | 20
 | 10052 | 10 |  | 10053 | 10 |  | 10054 | 30
 | 10053 | 10 |  | 10054 | 10 |  | 10056 | 10
 | 10053 | 20 |  | 10054 | 20 |  | 10057 | 20
 | 10054 | 10 |  | 10055 | 20
 | 10054 | 20 |  | 10055 | 30
 | 10054 | 30
 | 10055 | 20
 | 10055 | 30
 | 10056 | 10
 | 10057 | 20
Spreadsheet: 183962d1349103629-excel-pivot-tables-tf-performance-2-latest-q3
Sheet: Data

 |  | Client | Products | Support Craft | Years
 |  | Addax | PMS | TF - 1 | 2010
 |  | Addax | AGO | TF - 2 | 2011
 |  | Agri | DPK | Glory | 2012
 |  | Arcadia | Crude Oil | Apollo | 2013
 |  | Augusta | Fuel Oil | Commodore | 2013
 |  | Awaritse | Naptha |  | 2014
 |  | AX-Energy | Other
 |  | Brila Energy
 |  | Brila Energy Ltd.
 |  | Conoil (OAN)
 |  | [NAME]
 |  | Downstream
 |  | Energy Culture
 |  | Fargo
 |  | Glencore
 |  | Glencore
 |  | Gulf Treasure
 |  | [NAME]
 |  | Honeywell
 |  | [NAME]
 |  | Matrix
 |  | Mercuria
 |  | Mocoh S.A.
 |  | Nadabo Energy
 |  | Nepal
 |  | Nimex
 |  | Nipco
 |  | Noble
 |  | OAN
 |  | Oil Bath
 |  | Oilsep
 |  | [NAME]
 |  | Ontario Oil
 |  | Optima
 |  | [NAME]
 |  | Optima Energy SA
 |  | Petrocam
 |  | Petrogap
 |  | Petroserve
 |  | Pinnacle
 |  | Sahara Energy
 |  | Sea Transport Group Ltd.
 |  | Seatransport
 |  | Somerset Energy Services Ltd
 |  | Sopetro
 |  | Spog
 |  | Tarcona
 |  | Tonique Oil Services Limited
 |  | Trafigura
 |  | Union Maritime Ltd.
 |  | Vitol
 |  | Taleveras
 |  | Rain Oil
 |  | Delaney
 |  | MRS Holdings
 |  | Quest Drilling
 |  | Masters Energy
Spreadsheet: 63879d1264733982-merging-cells-without-losing-zeros-book1
Sheet: Sheet1

Row | Plant | Plant ID
1 | 0 | 100
1 | 1 | 101
8 | 12 | 812
44 | 31 | 4431
9 | 51 | 951
6 | 2 | 602
57 | 9 | 5709
4 | 7 | 407
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Blue Jays

Toronto Blue Jays | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Toronto Blue Jays | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
Cunningham, [NAME] | ML | ML | ML | ML | ML | ML |  | From Athletics | -0.3
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Braves | -1 | -0.8
Lobstein, [NAME] | ML | ML | ML | ML | ML | ML |  | From Giants | -7.6 | -0.3
[NAME], J.P. | ML | ML | ML | ML | ML | ML |  | From Padres | -4 | -1.5
[NAME] | ML | ML | ML | ML | ML | ML |  | From Rangers | -0.7
Bell, [NAME] | ML | ML | ML | ML | ML | ML |  | From Yankees | -3.5
Carrasco, [NAME] | ML | ML | ML | ML | ML | ML
Castillo, [NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
[NAME], Wilkins | ML | ML | ML | ML | ML | ML |  | Hoey, [NAME] | 0.4
DeJesus, [NAME] | ML | ML | ML | ML | ML | ML |  | To Angels | 0.9
Font, Wilmer | ML | ML | ML | ML | ML | ML |  | To Athletics | 1.7
Heredia, Jairo | ML | ML | ML | ML | ML | ML |  | To Rays | 1.5
Herrera, [NAME] | ML | ML | ML | ML | ML | ML |  | To Padres | 5
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Lindsey, [NAME] | ML | ML | ML | ML | ML | ML
Marte, Jefre | ML | ML | ML | ML | ML | ML
Martinez, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Parra, [NAME] | ML | ML | ML | ML | ML | ML
Pennington, Cliff | ML | ML | ML | ML | ML | ML
Peralta, Wily | ML | ML | ML | ML | ML | ML
Perez, Rossmel | ML | ML | ML | ML | ML | ML
Reckling, Trevor | ML | ML | ML | ML | ML | ML
Rhee, Dae-Eun | ML | ML | ML | ML | ML | ML
Tejeda, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Villalona, [NAME] | ML | ML | ML | ML | ML | ML
Vizcaino, Arodys | ML | ML | ML | ML | ML | ML
Beckett, [NAME] | 27.8 | 27.8 | 27.8
Sheets, [NAME] | 21.9 | 21.9 | 21.9
Ramirez, Aramis | 16 | 16
[NAME], [NAME] | 4.9 | A3
Renteria, [NAME] | 4.5
[NAME], [NAME] | 4 | A3
Ibanez, [NAME] | 3.4
[NAME], [NAME] | 3.2 | 3.2 | 3.2 | 3.2
Marmol, [NAME] | 3 | A2 | A3
Scott, [NAME] | 2.6 | A2 | A3
[NAME], [NAME] | 2.5
[NAME], [NAME] | 0.7 | A1 | A2 | A3
Iannetta, [NAME] | 0.7 | A1 | A2 | A3
[NAME], Hong-Chih | 0.7 | A1 | A2 | A3
Pelfrey, [NAME] | 0.7 | A1 | A2 | A3
Wilson, C.J. | 0.7 | A1 | A2 | A3
Affeldt, Jeremy | 0.7
Hanrahan, Joel | 0.5 | A
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Brocail, [NAME] | 0.2
Spreadsheet: 769405d1645525588-if-and-function-gives-value-error-counting-not-summing-aligw
Sheet: Sheet1

Client type | Ranking
B | 4
A | 7
A | 7
A | 10
A | 7
C | -1
A | 9
A | 9
A | 10
B | 8
B | 9
A | 8
B | -1
A | 10
D | 10
A | 8
E | -1
A | -1
F | 8
A | 8
 |  |  |  |  |  |  |  |  |  | "A"
 |  |  |  |  |  |  |  |  | >8
 |  |  |  |  |  |  |  |  | 7, 8
Spreadsheet: 807447d1669905397-categorized-modes-of-payment-sales-eba
Sheet: Speedpoint

ACRYLON PAINTS (PTY) LTD
CASH SALES - (Speedpoint)
Details
Date | Document Number | Customer Name | Cash Sale Amount | MoP
 | `
Spreadsheet: c04543b7-6260-4dcc-8c5a-6b93e54a3102
Sheet: Sheet1

2013 BUDGET FOR SPF PROPOSALS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
PROJECT NAME: | Our State & Private Forestry Project
Please note: There are TWO spreadsheets here - this is the example for you to review.  When you're ready to fill out your budget form, please use the blank form (use the tab below).
Please fill out the blank form, save a copy for your records, and submit your budget form in pdf format via e-mail.  Thank you!
 |  |  | MATCHING FUNDS
DESCRIPTION - EXAMPLE | CDA WMF FUNDS |  | APPLICANT CASH | APPLICANT IN-KIND | PARTNER CASH | PARTNER IN-KIND | OTHER CASH | OTHER IN-KIND |  | ITEM TOTAL
EXPENSES
Contracted Services | 2150 |  | 1500 |  | 1600 |  | 150 |  |  | 3250
[NAME] labor (20 people x 10 hrs x $12/hr) |  |  |  | 1400 |  | 1000 |  |  |  | 2400
Equipment - handheld GPS units (2) | 250 |  |  |  |  |  |  |  |  | 0
Equipment - herbicide | 500 |  | 1000 |  | 1000 |  |  |  |  | 2000
Educational - 1,000 door hangers | 100 |  |  |  |  |  | 100 |  |  | 100
Educational - 1,000 brochures - fair booth |  |  |  |  |  |  | 250 |  |  | 250
Seasonal employee | 4500 |  | 2000 |  |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
SUMMARY OF PROJECT FUNDS | 7500 |  | 4500 | 1400 | 2600 | 1000 | 500 | 0 |  | 10000
These cells will fill automatically:
AMOUNT OF SPF GRANT REQUEST: | 7500
REQUIRED MINIMUM MATCH: | 7500
PROPOSED MATCH: | 10000
Spreadsheet: 73113d1273763380-unique-values-uniquelist
Sheet: Sheet1

Codes | Uniqueness |  | [NAME] |  | Unique Items |  |  |  |  | Table of Orders
170940 | 1 |  | 27 |  | 170940 | [NAME] |  |  |  | Code | Client
170940 |  |  |  |  | 169938 | [NAME] |  |  |  | 170940 | [NAME]
170940 |  |  |  |  | 170780 | [NAME] |  |  |  | 169938 | [NAME]
170940 |  |  |  |  | 170779 | [NAME] |  |  |  | 170780 | [NAME]
169938 | 2 |  |  |  | 169921 | [NAME] |  |  |  | 170779 | [NAME]
170780 | 3 |  |  |  | 170100 | [NAME] |  |  |  | 169921 | [NAME]
170779 | 4 |  |  |  | 170111 | [NAME] |  |  |  | 170100 | [NAME]
170779 |  |  |  |  | 170111/1 | [NAME] |  |  |  | 170111 | [NAME]
169921 | 5 |  |  |  | 170121 | [NAME] |  |  |  | 170111/1 | [NAME]
170100 | 6 |  |  |  | 170122 | [NAME] |  |  |  | 170121 | [NAME]
170111 | 7 |  |  |  | 170182 | [NAME] |  |  |  | 170122 | [NAME]
170111 |  |  |  |  | 170643 | [NAME] |  |  |  | 170182 | [NAME]
170111/1 | 8 |  |  |  | 170909 | [NAME] |  |  |  | 170643 | [NAME]
170121 | 9 |  |  |  | 170507 | [NAME] |  |  |  | 170909 | [NAME]
170122 | 10 |  |  |  | 170509 | [NAME] |  |  |  | 170507 | [NAME]
170182 | 11 |  |  |  | 170507/1 | [NAME] |  |  |  | 170509 | [NAME]
170643 | 12 |  |  |  | 170509/1 | [NAME] |  |  |  | 170507/1 | [NAME]
170643 |  |  |  |  | 170526 | [NAME] |  |  |  | 170509/1 | [NAME]
170643 |  |  |  |  | 170597 | [NAME] |  |  |  | 170526 | [NAME]
170643 |  |  |  |  | 170347 | River Phoenix |  |  |  | 170597 | [NAME]
170643 |  |  |  |  | 170782 | [NAME] |  |  |  | 170347 | River Phoenix
170909 | 13 |  |  |  | 170782/1 | [NAME] |  |  |  | 170782 | [NAME]
170909 |  |  |  |  | 170872 | [NAME] |  |  |  | 170782/1 | [NAME]
170507 | 14 |  |  |  | 170872/1 | [NAME] |  |  |  | 170872 | [NAME]
170507 |  |  |  |  | 170737 | [NAME] |  |  |  | 170872/1 | [NAME]
170507 |  |  |  |  | 170738 | [NAME] |  |  |  | 170737 | [NAME]
170507 |  |  |  |  | 170739 | [NAME] |  |  |  | 170738 | [NAME]
170507 |  |  |  |  |  |  |  |  |  | 170739 | [NAME]
170507
170507
170507
170507
170507
170507
170507
170507
170507
170509 | 15
170507/1 | 16
170507/1
170507/1
170509/1 | 17
170509/1
170509/1
170509/1
170526 | 18
170526
170597 | 19
170347 | 20
170347
170782 | 21
170782
170782/1 | 22
170782/1
170872 | 23
170872
170872
170872
170872/1 | 24
170872/1
170737 | 25
170738 | 26
170738
170739 | 27
170739
170739
170739
170739
170739
170739
170739
170739
170739
170739
170739
Spreadsheet: 28edd9bb-ba73-4940-8e20-af1b7e7cbb1e
Sheet: Buffer Strip

VEGETATED BUFFER STRIP CALCULATOR
This calculator determines the minimum width for a vegetated buffer strip based on the width of the Drainage Management Area (DMA).
CALCULATOR
Vegetated [NAME] - by DMA width
1 | [NAME] of contributing DMA |  |  | feet
2 | Is the DMA width < 60 feet?
3 | Minimum VBS Width |  |  | feet
INSTRUCTIONS
Use steps 1 through 3 to determine the minimum width of the vegetated buffer strip to meet the treatment design requirements.
Step
1 | Enter the width of the contributing DMA, where width is measured in the direction of runoff from the DMA. The vegetated buffer strip (VBS) is located parallel to the DMA and should extend the full length of the DMA. For instance, for a crowned roadway, the DMA width would be the distance from the centerline of the road to the edge of pavement where the VBS begins.
2 | If the DMA width is greater than 60 feet, an additional treatment BMP must be used in conjunction with the VBS.
3 | The minimum VBS width is calculated here, where width is measured in the direction of runoff. The VBS width should be greater than or equal to half the DMA width and should be no less than 15 feet.
DEFINITIONS
 | [NAME] | [NAME] of the DMA in the direction of flow. The width extends from the upstream edge of the DMA to the boundary with the VBS.
 | [NAME] | [NAME] of the vegetated buffer strip in the direction of flow. The width extends from the boundary with the DMA to the downstream edge of the VBS.
Spreadsheet: eaf8cd96-1a6f-4f14-a8b8-1884cf990121
Sheet: Sheet1

NEW HAMPSHIRE - GENERAL ELECTION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2010-11-02 00:00:00 | STATE REPRESENTATIVES - BELKNAP COUNTY
District No. 1 (1) | Simpson, r | Gulick, d | [NAME]
Center Harbor | 314 | 176 | 1
New Hampton | 494 | 405
TOTALS | 808 | 581 | 1
District No. 2 (2) | Tobin, r | Fields, r | Merry, d | Dawson, d | Couture, Jr., [NAME] | [NAME]
Sanbornton | 724 | 648 | 574 | 295 | 46
[NAME] | 599 | 625 | 483 | 340 | 68 | 2
TOTALS | 1323 | 1273 | 1057 | 635 | 114 | 2
District No. 3 (2) | Worsman, r | Greemore, r | Miller, d | Horne, d | [NAME]
Meredith | 1480 | 1412 | 995 | 1185 | 1
District No. 4 (5) | [NAME], r | Accornero, r | Flanders, r | Kingsbury, r | Luther, r | [NAME]
[NAME] | 661 | 575 | 669 | 564 | 614 | 6
[NAME] | 393 | 348 | 385 | 338 | 351 | 5
[NAME] 3 | 442 | 368 | 444 | 362 | 401 | 4
[NAME] | 419 | 355 | 429 | 337 | 380 | 1
[NAME] | 322 | 278 | 326 | 262 | 285 | 1
[NAME] 6 | 621 | 564 | 632 | 551 | 577 | 2
TOTALS | 2858 | 2488 | 2885 | 2414 | 2608 | 19
District No. 4 (5) | Stuart, d | Allard, d | Arsenault, d | Baxley, d | Stamps, d
[NAME] | 408 | 362 | 425 | 320 | 386
[NAME] | 290 | 247 | 308 | 222 | 273
[NAME] 3 | 371 | 316 | 376 | 278 | 385
[NAME] | 323 | 298 | 345 | 258 | 288
[NAME] | 219 | 194 | 261 | 173 | 209
[NAME] 6 | 337 | 330 | 390 | 280 | 330
TOTALS | 1948 | 1747 | 2105 | 1531 | 1871
District No. 5 (7) | Malone, r | Pilliod, r | St. Cyr, r | Swinford, r | Bolster, r | [NAME], r | [NAME], r
Alton | 1331 | 1254 | 1571 | 1274 | 1281 | 1193 | 1294
Barnstead | 779 | 742 | 874 | 939 | 776 | 732 | 840
Belmont | 1074 | 1269 | 1133 | 1049 | 1072 | 1113 | 1006
Gilford | 1614 | 1958 | 1679 | 1639 | 1603 | 1948 | 1569
TOTALS | 4798 | 5223 | 5257 | 4901 | 4732 | 4986 | 4709
District No. 5 (7) | Condodemetraky, d | [NAME], d | [NAME], d | Morin, Jr., d | Andersen, d | Bourbeau, d | [NAME], d | [NAME]
Alton | 434 | 645 | 509 | 476 | 458 | 437 | 422 | 8
Barnstead | 375 | 514 | 457 | 414 | 409 | 414 | 398 | 3
Belmont | 586 | 701 | 533 | 682 | 478 | 478 | 471 | 14
Gilford | 749 | 1207 | 768 | 951 | 704 | 637 | 746 | 3
TOTALS | 2144 | 3067 | 2267 | 2523 | 2049 | 1966 | 2037 | 28
District No. 6 (1) | [NAME], r | Chase, d | [NAME]
Gilmanton | 968 | 534 | 3
Spreadsheet: 714967d1611487527-conditional-formatting-highlight-cell-between-start-date-and-end-date-file-01
Sheet: Sheet1

 |  | Project Start Date: | 2021-01-01 00:00:00
ID | Name | Start | Finish | Total
Column1 | Column2 | Column8 | Column9 | Column7 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40
1125 | Mr.[NAME] ,[NAME] | 2021-01-01 00:00:00 | 2021-01-03 00:00:00
3626 | Mr.[NAME],Pablo | 2020-11-06 00:00:00 | 2021-02-04 00:00:00
2925 | Ms.[NAME],Albertine | 2020-11-14 00:00:00 | 2021-02-11 00:00:00
2525 | Mr.[NAME],Duque | 2020-11-15 00:00:00 | 2021-02-09 00:00:00
3507 | Ms.[NAME] | 2021-01-13 00:00:00 | 2021-01-24 00:00:00
3525 | Miss [NAME] | 2021-01-13 00:00:00 | 2021-01-24 00:00:00
3321 | Ms.[NAME] | 2020-11-30 00:00:00 | 2021-01-29 00:00:00
3430 | Mr.[NAME] ,[NAME] | 2021-01-05 00:00:00 | 2021-02-04 00:00:00
2822 | Mr.[NAME] | 2020-12-04 00:00:00 | 2021-01-31 00:00:00
2621 | Mr.[NAME] | 2021-01-15 00:00:00 | 2021-02-14 00:00:00
3228 | Mr.[NAME] | 2020-12-09 00:00:00 | 2021-03-06 00:00:00
3025 | Mr.[NAME] | 2021-01-08 00:00:00 | 2021-01-27 00:00:00
2623 | Mr.[NAME] | 2021-01-14 00:00:00 | 2021-01-27 00:00:00
3027 | Mr.[NAME] en | 2021-01-16 00:00:00 | 2021-01-26 00:00:00
2510 | Mr.[NAME] [NAME] | 2021-01-13 00:00:00 | 2021-01-23 00:00:00
2803 | Mr.[NAME] | 2021-01-17 00:00:00 | 2021-02-01 00:00:00
1325 | Mr.[NAME] | 2021-01-17 00:00:00 | 2021-01-27 00:00:00
1301 | Mr.[NAME] | 2021-01-15 00:00:00 | 2021-01-27 00:00:00
3132 | Mr.[NAME] | 2021-01-11 00:00:00 | 2021-02-10 00:00:00
2703 | Mr.[NAME] | 2021-01-12 00:00:00 | 2021-02-11 00:00:00
2613 | Ms.[NAME] | 2021-01-14 00:00:00 | 2021-02-13 00:00:00
3006 | Mr.[NAME] | 2020-12-25 00:00:00 | 2021-01-24 00:00:00
3307 | Mr.[NAME] | 2020-11-04 00:00:00 | 2021-02-03 00:00:00
2620 | Mr.[NAME] | 2021-01-15 00:00:00 | 2021-02-14 00:00:00
3821 | Ms.[NAME] | 2020-12-15 00:00:00 | 2021-01-26 00:00:00
1302 | Mrs.[NAME] Kalambet | 2021-01-15 00:00:00 | 2021-01-27 00:00:00
927 | Mr.[NAME] Tudor | 2020-12-12 00:00:00 | 2021-01-26 00:00:00
911 | Mr.[NAME] | 2021-01-09 00:00:00 | 2021-01-22 00:00:00
3600 | Mr.[NAME] | 2021-01-06 00:00:00 | 2021-03-06 00:00:00
3313 | Mr.[NAME] | 2021-01-06 00:00:00 | 2021-02-05 00:00:00
Spreadsheet: 125570d1319108890-excel-2007-moving-values-between-sheets-by-using-number-commands-weight-and-buildup
Sheet: ULD9&10

9 |  |  |  |  |  |  | 10
 |  |  |  | Aircraft Position |  |  |  |  |  |  | Aircraft Position
Built up by: |  |  | Origin | ULD Ident |  |  | Built up by: |  |  | Origin | ULD Ident
Total Pages: |  |  | KEF |  |  |  | Total Pages: |  |  | KEF
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Regional sales

 | < $900,000
Region | Sales
NorthWest | 1781345
West | 534389
SouthWest | 1009268
South | 899999
Central | 2345184
NorthEast | 900000
East | 1567090
Territories | 34678
Total