tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 67e462ef-e358-4fdf-b0f6-af0f20c7d53f
Sheet: Sheet1

Single Stage Activated Sludge Oxidation-Nitrification Design | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
as proposed by [NAME], [NAME] ([NAME], June 2006)
Program and Comparisons Prepared by [NAME]
Input Data: Insert Design Parameters in Blue Fields
Sr = Influent BOD5 = |  |  |  |  | 170 | mg/L
Minimum Sustained temperature = |  |  |  |  | 20 | 0C
DO to be maintained in aeration tanks = |  |  |  |  | 2 | mg/L
un,[NAME]. temp-specific growth rate = |  |  |  |  | 0.45 | d-1
a = heterotrophic yield coefficient = |  |  |  |  | 0.55 | lb VSS/lb BOD
knd = nitrification decay rate = |  |  |  |  | 0.05 | d-1
Safety Factor = |  |  |  |  | 2
K0 = half-saturation coefficient for DO = |  |  |  |  | 1
kb = endogenous decay rate = |  |  |  |  | 0.1 | d-1
t = hydraulic residence time = |  |  |  |  | 0.25 | d
Xd = degradable fraction of MLSS |  |  |  |  | 0.64
NH3-N = ammonia-N limit = |  |  |  |  | 1
Kn = nitrification half saturation coefficient = |  |  |  |  | 0.5
MLVSS/MLSS = |  |  |  |  | 0.75
Solution:
Un,maxT = [NAME],max15 (e0.098(T-15)) = |  |  |  |  | 0.734542295211679 | d-1
Un = |  |  |  |  | 0.3264632423163017 | d-1
Determine design SRT
Correcting Decay Rate for Temperature
Nitrification Theta for [NAME] rate = |  |  |  |  | 1.04
Nitrification [NAME] ar T  = knd = knd(Theta)(T-20) = |  |  |  |  | 0.05
SRT = 1/Un - Knd |  |  |  |  | 3.617117384653615 | d
SRT(Safety Factor) = |  |  |  |  | 7.234234769307229 | d
Correcting Endogenous Decay Rate for Temperature
Theta for Endogenous Decay rate = |  |  |  |  | 1.04
Endogenous [NAME] at T = |  |  |  |  | 0.1 | d-1
Xv = MLVSS = |  |  |  |  | 1849.364594212106 | mg/L
MLSS = MLVSS/Fraction of VSS = |  |  |  |  | 2465.819458949475 | mg/L
Variation of SRT and MLVSS with Temperature and DO
DO = | 2 mg/L
Temperature | SRT | MLVSS
deg C | days | mg/L
5 |  | 4887
8 | 39.43 | 4185
10 | 27.58 | 3730
15 | 13.33 | 2691
18 | 9.16 | 2160
20 | 7.23 | 1849
23 | 5.15 | 1449
25 | 4.14 | 1224
Temperature | DO Conc | SRT | MLVSS
deg C | mg/L | days | mg/L
5 | 1 |  | 5570
8 | 1 |  | 4872
10 | 1 | 48 | 4403
15 | 1 | 20 | 3281
18 | 1 | 13.2 | 2678
20 | 1 | 10.3 | 2317
23 | 1 | 7.2 | 1840
25 | 1 | 5.72 | 1566
Temperature | DO Conc | SRT | MLVSS
deg C | mg/L | days | mg/L
5 | 0.5 |  | 6474
8 | 0.5 |  | 5827
10 | 0.5 |  | 5371
15 | 0.5 | 40 | 4202
18 | 0.5 | 24 | 3525
20 | 0.5 | 18 | 3101
23 | 0.5 | 12 | 2518
25 | 0.5 | 9.24 | 2172
Spreadsheet: 160328d1339054441-count-but-only-in-columns-with-specific-value-sample
Sheet: Blad1

Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday
-1 | 0 | 1 | -1 | 1 | 1 | 1 | -1 | 0 | 1 | -1 | 1 | 1 | 1
0 | 1 | 1 | 1 | 2 | 1 | -1 | 0 | 1 | 1 | 1 | 2 | 1 | -1
1 | 3 | -1 | 1 | 1 | 2 | -1 | 1 | 3 | -1 | 1 | 1 | 2 | -1
-1 | 2 | 2 | 0 | 0 | -1 | 2 | -1 | 2 | 2 | 0 | 0 | -1 | 2
3 | -1 | 0 | 2 | 1 | -1 | 1 | 3 | -1 | 0 | 2 | 1 | -1 | 1
2 | 0 | 4 | 2 | 1 | 0 | 1 | 2 | 0 | 4 | 2 | 1 | 0 | 1
Spreadsheet: 213405d1360492360-help-using-a-countif-function-operatingschedule-caiteden-oeldere-
Sheet: Calendar Year

 | month | PINS Date | enddate | Amount | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 |  | sum | control
Capital Depreciation - Hardware
Purchase 1 | 36 | 2013-03-01 00:00:00 |  | 10000
Purchase 2 |  |  |  | 500
Purchase 3 |  |  |  | 1000000
Purchase 4 |  |  |  | 5000000
Purchase 5 |  |  |  | 6000000
Capital Depreciation - Software
Purchase 1 | 60 | 2011-05-01 00:00:00 |  | 400
Purchase 2
Purchase 3
Purchase 4
Purchase 5
Maintenance
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Expenses
Professional Services |  | 2013-02-01 00:00:00 |  | 10000
Licenses
Travel
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 164776 | 208372 |  | -45846 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 115066 | 197136 |  | -84123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 106244 | 197136 |  | -91292 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 127004 | 187111 |  | -60293 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-06-30 00:00:00 |  |  |  | 8807
 | 2001-07-04 00:00:00
Spreadsheet: 767860d1644679784-creating-multiple-dependent-dropdown-lists-from-the-same-target-cell-example-70-ans2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  | MODEL | COLOR | STORAGE
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Model |  |  |  |  |  |  | iPhone_SE
 |  |  | [NAME] |  |  |  |  |  |  | iPhone_13
 |  |  | iPhone_SE
 |  |  | iPhone_13
 |  |  |  |  |  |  |  |  |  | =INDIRECT(INDEX(Sheet2!$L$2:$L$4,MATCH($D2,Sheet2!$K$2:$K$4,0)))
 |  |  |  |  |  |  |  |  |  | [NAME])))
 |  |  |  | [NAME]
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 64GB | Black
 |  |  |  | 128GB | White
 |  |  |  | iPhone_SE
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 64GB | Black
 |  |  |  | 128GB | White
 |  |  |  |  | Red
 |  |  |  | iPhone_13
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 128GB | Starlight
 |  |  |  | 256GB | Midnight
 |  |  |  | 512GB | Red
 |  |  |  |  | Pink
Spreadsheet: 62244d1263226609-open-text-file-into-excel-template-pmw-performance-management
Sheet: Performance Management

2010 PERFORMANCE MANAGEMENT WORKSHEET
(January 1, 2009 through December 31, 2009)
Eligible Employees:  Regular Employee Status; Hired Before October 1, 2009
Location: PN100
Location Description: General Office UBC 100
REGION | EE ID | LAST | FIRST | HIRE_DT | TERMINATION_DT | [NAME] | TITLE | EE Status | FT/PT | FLSA | MANAGER | LOCATION/RESPONSIBLE MANAGER | OVERALL PERFORMANCE RATING (use drop down) | COMMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 = Meets Expectations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 = Exceeds Expectations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 = Needs Improvement
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select Rating:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Too New to Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 = Needs Significant Improvement
Spreadsheet: 74322d1274869191-excel-2007-data-transfer-remains-260510-example-
Sheet: Table

 | Order remains
 | Description |  |  | Remains |  | Ordered |  |  | Arrived
 | Material | Length | Color | Bars | Wight (Kg) | Bars |  | Date | Bars | Kg | Date
1 | Material | 6 | Color |  |  | 10000 | Order No.1 | DATE
2 | Material | 6 | Color |  |  | 10000 | Order No.2 | DATE
 | Data from half cell C, sheet Order 1. |  |  |  |  | Data from half cell C, sheet Order 1.
Spreadsheet: 686753d1594802461-conditional-addition-payroll-test
Sheet: Monthly_multi

Employee Name | Monthly Salary | SSS | Philhealth | [NAME] | 13th Month | Adjustment | Absences/Tardiness | Taxable Income | Withholding Tax
Employee 1 | 22500 |  |  | 100
Employee 2 | 17500 |  |  | 100
Employee 3 | 42000 |  |  | 100
Employee 4 | 17335 |  |  | 100
Employee 5 |  |  |  | 100
Employee 6 |  |  |  | 100
Employee 7 |  |  |  | 100
Employee 8 |  |  |  | 100
Employee 9 |  |  |  | 100
Employee 10 |  |  |  | 100
Employee 11 |  |  |  | 100
Employee 12 |  |  |  | 100
Employee 13 |  |  |  | 100
Monthly Salary | 22500
SSS
Philhealth |  |  |  |  |  |  |  |  |  |  | BIR TAX TABLE
Pag Ibig Premium | 100 |  |  |  |  |  |  |  |  |  | [NAME] (ANNUAL) | INCOME TAX RATE
Bonus |  |  |  |  |  |  |  |  |  |  | 250000 and below | 0
13th Month Pay |  |  |  |  |  |  |  |  |  |  | 250000.01 to 400000 | 20% of the excess over 250000
Other Adjustment |  |  |  |  |  |  |  |  |  |  | 400000.01 to 800000 | 30000 + 25% of the excess over 400000
[NAME] |  |  |  |  |  |  |  |  |  |  | 800000.01 to 2000000 | 130000 + 30% of the excess over 800000
OT Meal allowance |  |  |  |  |  |  |  |  |  |  | 2000000.01 to 8000000 | 490000 + 32% of the excess over 2000000
Abcenses/tardiness |  |  |  |  |  |  |  |  |  |  | 8000000.01 and above | 2410000 + 35% of the excess over 8000000
Taxable Income
Withholding Tax
 |  |  |  |  |  |  |  |  |  |  | Taxable Income | 35000
 |  |  |  |  |  |  |  |  |  |  | Income Tax
 |  |  |  |  |  |  |  |  |  |  | Taxable Income | 20925
 |  |  |  |  |  |  |  |  |  |  | Income Tax
 |  |  |  |  |  |  |  |  |  |  | FROM | TO
 |  |  |  |  |  |  |  |  |  |  | 0 | 20832 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 20834 | 33332 | 0 | 0.2
 |  |  |  |  |  |  |  |  |  |  | 33334 | 66664 | 30000 | 0.25
 |  |  |  |  |  |  |  |  |  |  | 66666 | 166664 | 130000 | 0.3
 |  |  |  |  |  |  |  |  |  |  | 166666 | 666664 | 490000 | 0.32
 |  |  |  |  |  |  |  |  |  |  | 666666 | 99999999 | 2410000 | 0.35
 |  |  |  |  |  |  |  |  |  |  |  | 2410000
Spreadsheet: 84929d1285016125-one-payment-multiple-dates-summation-book1
Sheet: Sheet1

Payment | date | date | date
25 | 5/14/2009 | 2009-07-14 00:00:00 | 09/14/2009
50 | 05/15/2009 | 09/15/2009 | 01/15/2010
 | Sum amt Month
2009-05-01 00:00:00 | 75
2009-06-01 00:00:00 | 0
2009-07-01 00:00:00 | 25
2009-08-01 00:00:00 | 0
2009-09-01 00:00:00 | 75
2009-10-01 00:00:00 | 0
2009-11-01 00:00:00 | 0
2009-12-01 00:00:00 | 0
2010-01-01 00:00:00 | 50
Spreadsheet: 704846d1605777631-select-columns-containing-text-in-a-row-and-merge-into-single-column-on-the-same-row-sample
Sheet: Sheet1

First Name | Last Name | Logon ID | Enviroments | Manager [NAME] | Manager e-mail | Enviroment1 | Enviroment2 | Enviroment3 | Enviroment4
[NAME] | [NAME] | Jojo123 |  | Hagrid | [EMAIL] | Jojo123 |  | Jojo123
Guy | Baggins | Guba123 |  | [NAME] | [EMAIL] | Guba123 | Guba123 | Guba123 | Guba123
Correct | Example | Coex123 | Enviroment2; Enviroment4 | [NAME] | [EMAIL] |  | Coex123 |  | Coex123
 |  |  | I need it to look like the example above. Does not have to be exact.
 |  |  | Depending on what enviroments they have access to, it shows up under column D
 |  |  | I have around 15 enviroments, and I am lookign for an easy way  to move the enviroment names that contain text(same as logon ID) in the same row.
Spreadsheet: 08688de9-7591-437f-b361-5cf25a09ce50
Sheet: Com Expense

COMMERCIAL OPERATING BUDGET - EXPENSES
 | Project Name:
 | Date: |  |  | Annual Inflation Rate Factor: | 0.03
ANNUAL Operating Expenses |  |  | 1 | 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
Insurance
Utilities:(common areas)
 | Gas/Oil
 | Electric
 | Water & Sewer
 | Garbage Removal
Repairs
General Maintenance
Landscape Maintenance
Replacement Reserve
Property Management:
 | On-site
 | Contracted (Off-Site)
Professional Services:
 | Legal
 | Accounting
Office & Administration
Advertising/Marketing & Promotion
Turnover
Taxes(non-real estate)
Real Estate Taxes
Payroll Taxes
Other:
Other:
Total Annual Operating Expenses:
Less Debt Service:
Permanent loan
Rate | Term (Years) | Loan Amount
 | 1
Deferred Developer Fee
Rate | Term (Years) | Loan Amount
 | 1
Amortized Debt (HOME Loan, , [NAME],etc.) & Cashflow Loans
Rate | Term (Years) | Loan Amount
 | 1
 | 1
 | 1
Effective Gross Income:
Total Annual Operating Expenses:
Net Operating Income:
Primary Debt Service
Total Debt Service
Cash Flow Per Year
Primary Debt Coverage Ratio
Total Debt Coverage Ratio
Spreadsheet: 864369d1711560638-i-need-help-creating-a-formula-that-shows-arrival-and-departure-dates-based-on-data-set-arrival-departure-date-example-workbook
Sheet: Sheet2

2024-04-25 00:00:00 |  |  |  | Total |  | [NAME] | Departure
1 | 1 | 1 |  | 3
1 | 1 | 1 |  | 3
1 | 1 | 1 |  | 3
1 | 1 |  |  | 3
1 | 1 | 1 |  | 3
1 |  |  |  | 3
1 | 1 | 1 |  | 3
1 | 1 | 1 |  | 3
1 | 1 |  |  | 3
1 | 1 |  |  | 3
1 | 1 |  |  | 3
1 | 1 | 1 |  | 3
1 | 1 | 1 |  | 3
1 |  |  |  | 3
1 |  |  |  | 3
1 | 1 | 1 |  | 3
1 | 1 | 1 |  | 3
1 | 1 | 1 |  | 3
1 |  |  |  | 3
Spreadsheet: 017a30c3-f80b-47ad-91c1-8c7a95d268e2
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Executive Council - District No. 5              Democratic
2012-09-11 00:00:00 | [NAME], d | [NAME], r | [NAME]
Amherst | 664 | 1 | 3
Antrim | 187
Bennington | 93
Brookline | 262
Deering | 117
Dunbarton | 197 |  | 1
[NAME] | 168 | 2
Francestown | 154
[NAME] | 123
Greenville | 80
Hillsborough | 250
Hollis | 480 | 1
Hudson | 765 | 1 | 2
[NAME] | 349
Litchfield | 294
Lyndeborough | 103
Mason | 66 | 1
Merrimack | 1051
Milford | 637 | 2 | 2
[NAME] | 185
[NAME] | 535 | 1
[NAME] | 375 |  | 7
[NAME] | 416
[NAME] | 234 | 1
[NAME] | 405 | 1 | 1
[NAME] | 337
[NAME] | 385
[NAME] | 417 |  | 1
[NAME] 9 | 408 | 1 | 1
New Boston | 380 | 1
New Ipswich | 157
Peterborough | 735
Richmond | 97 |  | 2
Rindge | 207 | 2
[NAME] | 46
Swanzey | 373 | 1 | 2
Temple | 132
Troy | 102
Weare | 389
[NAME] | 271
Windsor | 14
Totals | 12640 | 16
Spreadsheet: 789279d1659022043-formula-to-make-one-column-data-from-multi-columns-data-sample-file-5
Sheet: Sheet1

Expected Results
1 |  | 1 | 11 | 21 | 31 | 41
2 |  | 2 | 12 | 22 | 32 | 42 |  |  | 2 | 2 | 2 | 2
3 |  | 3 | 13 | 23 | 33 | 43 |  |  | 3 | 3 | 3 | 3
4 |  | 4 | 14 | 24 | 34 | 44 |  |  | 4 | 4 | 4 | 4
5 |  | 5 | 15 | 25 | 35 | 45 |  |  | 5 | 5 | 5 | 5
6 |  | 6 | 16 | 26 | 36 | 46 |  |  | 6 | 6 | 6 | 6
7 |  | 7 | 17 | 27 | 37 | 47 |  |  | 7 | 7 | 7 | 7
8 |  | 8 | 18 | 28 | 38 | 48 |  |  | 8 | 8 | 8 | 8
9 |  | 9 | 19 | 29 | 39 | 49 |  |  | 9 | 9 | 9 | 9
10 |  | 10 | 20 | 30 | 40 | 50 |  |  | 10 | 10 | 10 | 10
11 |  |  |  |  |  |  |  |  | 11 | 11 | 11 | 11
12 |  |  |  |  |  |  |  |  | 12 | 12 | 12 | 12
13 |  |  |  |  |  |  |  |  | 13 | 13 | 13 | 13
14 |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14
15 |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
16 |  |  |  |  |  |  |  |  | 16 | 16 | 16 | 16
17 |  |  |  |  |  |  |  |  | 17 | 17 | 17 | 17
18 |  |  |  |  |  |  |  |  | 18 | 18 | 18 | 18
19 |  |  |  |  |  |  |  |  | 19 | 19 | 19 | 19
20 |  |  |  |  |  |  |  |  | 20 | 20 | 20 | 20
21 |  |  |  |  |  |  |  |  | 21 | 21 | 21 | 21
22 |  |  |  |  |  |  |  |  | 22 | 22 | 22 | 22
23 |  |  |  |  |  |  |  |  | 23 | 23 | 23 | 23
24 |  |  |  |  |  |  |  |  | 24 | 24 | 24 | 24
25 |  |  |  |  |  |  |  |  | 25 | 25 | 25 | 25
26 |  |  |  |  |  |  |  |  | 26 | 26 | 26 | 26
27 |  |  |  |  |  |  |  |  | 27 | 27 | 27 | 27
28 |  |  |  |  |  |  |  |  | 28 | 28 | 28 | 28
29 |  |  |  |  |  |  |  |  | 29 | 29 | 29 | 29
30 |  |  |  |  |  |  |  |  | 30 | 30 | 30 | 30
31 |  |  |  |  |  |  |  |  | 31 | 31 | 31 | 31
32 |  |  |  |  |  |  |  |  | 32 | 32 | 32 | 32
33 |  |  |  |  |  |  |  |  | 33 | 33 | 33 | 33
34 |  |  |  |  |  |  |  |  | 34 | 34 | 34 | 34
35 |  |  |  |  |  |  |  |  | 35 | 35 | 35 | 35
36 |  |  |  |  |  |  |  |  | 36 | 36 | 36 | 36
37 |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37
38 |  |  |  |  |  |  |  |  | 38 | 38 | 38 | 38
39 |  |  |  |  |  |  |  |  | 39 | 39 | 39 | 39
40 |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40
41 |  |  |  |  |  |  |  |  | 41 | 41 | 41 | 41
42 |  |  |  |  |  |  |  |  | 42 | 42 | 42 | 42
43 |  |  |  |  |  |  |  |  | 43 | 43 | 43 | 43
44 |  |  |  |  |  |  |  |  | 44 | 44 | 44 | 44
45 |  |  |  |  |  |  |  |  | 45 | 45 | 45 | 45
46 |  |  |  |  |  |  |  |  | 46 | 46 | 46 | 46
47 |  |  |  |  |  |  |  |  | 47 | 47 | 47 | 47
48 |  |  |  |  |  |  |  |  | 48 | 48 | 48 | 48
49 |  |  |  |  |  |  |  |  | 49 | 49 | 49 | 49
50 |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50
Spreadsheet: 48653d1247863817-vlookup-401-ded-worksheet-upload
Sheet: Hours

File# | Name | Gross earnings | Rate | Regular Hours | Vacations Hours | Sick Hours | Floating Holiday | Holiday | Total
1 | Doe, [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
2 | [NAME], [NAME] | 1000 | 25 | 24 | 8 | 0 | 0 | 8 | 40
2 | [NAME], [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
4 | [NAME], [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
4 | [NAME], [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
6 | Thompson, Jake | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
7 | Garner, [NAME] | 1200 | 25 | 32 | 0 | 8 | 8 | 0 | 48
8 | Holland, Maria | 1000 | 25 | 32 | 8 | 0 | 0 | 0 | 40
9 | Graft, Scott | 1000 | 25 | 24 | 16 | 0 | 0 | 0 | 40
10 | Topper, [NAME] | 1000 | 25 | 0 | 40 | 0 | 0 | 0 | 40
11 | [NAME], [NAME] | 1000 | 25 | 8 | 24 | 0 | 0 | 8 | 40
12 | Trully, [NAME] | 1000 | 25 | 32 | 0 | 0 | 0 | 8 | 40
13 | Fanta, [NAME] | 1000 | 25 | 24 | 8 | 0 | 0 | 8 | 40
14 | Shelton, [NAME] | 1000 | 25 | 40 | 0 | 0 | 0 | 0 | 40
15 | Edwards, [NAME] | 800 | 20 | 40 | 0 | 0 | 0 | 0 | 40
16 | Earhardt, Dale | 800 | 20 | 40 | 0 | 0 | 0 | 0 | 40
17 | [NAME], [NAME] | 800 | 20 | 40 | 0 | 0 | 0 | 0 | 40
18 | Frontal, [NAME] | 800 | 20 | 24 | 16 | 0 | 0 | 0 | 40
19 | Edon, [NAME] | 800 | 20 | 16 | 24 | 0 | 0 | 0 | 40
20 | [NAME], [NAME] | 2400 | 30 | 40 | 0 | 40 | 0 | 0 | 80
21 | Bing, [NAME] | 1280 | 32 | 0 | 0 | 0 | 0 | 0 | 0
22 | [NAME], [NAME] | 1923.2 | 48.08 | 0 | 0 | 0 | 0 | 0 | 0
23 | [NAME], [NAME] | 600 | 15 | 0 | 16 | 0 | 0 | 0 | 16
24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 679765d1590612395-is-there-a-way-to-create-a-table-and-use-that-table-to-format-cells-custom-format
Sheet: Original Report

Item | Desc | Price Matrix
ACO02F-R | Acorus americanus ([NAME]) | 7
ACT08F-R | Actaea rubra (Red Baneberry) | 2020-09-08 00:00:00
ADI02S-R | Adiantum pedatum ([NAME]) | 2020-06-05 00:00:00
ALL02F-R | Allium canadense ([NAME]) | 2020-04-03 00:00:00
ALL04F-R | Allium cernuum (Nodding Onion) | 2020-05-04 00:00:00
ALL07F-R | Allium canadense var. [NAME] ([NAME]) | 2020-06-05 00:00:00
ALL08F-R | Allium tricoccum ([NAME]) | 7-6-4.2
AME01T-R | Amelanchier canadensis (Shadblow) | 9
AME02T-R | Amelanchier laevis ([NAME]) | 9
AME04T-R | Amelanchier [NAME] ([NAME]) | 25
AME10T-R | Amelanchier arborea ([NAME]) | 9
AMO04T-R | [NAME] fruticosa (False Indigo) | 2020-08-07 00:00:00
ANE02F-R | Anemone canadensis (Canada Anemone) | 8
ANE06F-R | Anemone cylindrica (Thimbleweed) | 2020-07-06 00:00:00
ANE10F-R | Anemone virginiana ([NAME]) | 2020-07-06 00:00:00
ANG02F-R | Angelica atropurpurea (Angelica) | 5-4-2.8
ANT02F-R | Antennaria neglecta (Prairie Pussytoes) | 2020-06-05 00:00:00
ANT04F-R | Antennaria plantaginifolia (Pussytoes) | 2020-06-05 00:00:00
AQU02F-R | Aquilegia canadensis (Columbine) | 7
[NAME] | Aralia racemosa (Spikenard) | 2020-08-07 00:00:00
ARI02F-R | Arisaema triphyllum ([NAME]-in-the-Pulpit) | 9
ASA02F-R | Asarum canadense ([NAME]) | 2020-07-06 00:00:00
ASC04F-R | Asclepias exaltata ([NAME]) | 8
ASC08F-R | Asclepias incarnata ([NAME]) | 6
ASC16F-R | Asclepias tuberosa ([NAME]) | 8
ASC18F-R | Asclepias verticillata (Whorled Milkweed) | 2020-07-06 00:00:00
AST09F-R | Eurybia furcata (Forked Aster) | 2020-06-05 00:00:00
AST10F-R | Symphyotrichum laeve (Smooth Blue Aster) | 7
AST14F-R | Ionactis linariifolius ([NAME]) | 8
Spreadsheet: 271687d1382021935-setting-a-value-based-on-a-range-with-multiple-possible-outcomes-sample_sheet
Sheet: Table B

 | Activity | Progress | Comments
 | Prep |  | Line 5 -18
 | Post-use cleaning |  | Line 20, 41-48, 57-62 & 72-73
Type 4
Type 9V
Type 14
Type 19A
Type 23F
 | If all complete
[NAME]
Membrane Install
Moisture Sampling
Recon
Rxn Start
Rxn Stop
Stop Rxn Start
Stop Rxn Stop
UF/DF
Cold Storage
FDF Parts Prep
FDF
Cold Storage
Dilution
Cold Storage
MBC Prep
MBC Fill
Sealing
Spreadsheet: 894a9c91-32c6-4595-b55a-07e58344b099
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8207 | 57007 | Claudia | Schlindwein | GER | 118 | 0:44:09 | 0:01:41 | 5:06:38 | 0:02:10 | 2:39:27 | 1 | 8:34:08
8207 | 60741 | Sabine | Studer | SUI | 119 | 0:48:41 | 0:01:44 | 5:25:22 | 0:02:37 | 3:02:57 | 2 | 9:21:22