tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 801602d1666270858-data-retrieval-from-multiple-sheets-for-multiple-variables-excel-file
Sheet: System

CoCd | G/L acct | Short Text | For. Crcy | BusA | Balance Carryforward | Balanceprev,periods | Debit rept,period | Credit report per, | Accumulated balance
200 | 2220001 | CAD Entity B | CAD |  |  |  |  |  | -17500000
200 | 2220004 | USD Entity RW | USD |  |  |  |  |  | -37500000
200 | 2310100 | CAD short-term credi | CAD |  |  |  |  |  | -60000000
200 | 2320200 | [NAME] short-term credi | [NAME] |  |  |  |  |  | -80000000
200 | 2330300 | USD short-term credi | USD |  |  |  |  |  | -30000000
200 | 1340001 | Non-curr. rec. third | COP |  |  |  |  |  | 0
Spreadsheet: john_griffith__15885__11_12_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 275 | 37 | 39 | 83.4 | 87.9 | 14.81 | 2001-11-12 14:47:00
 | NG F2 | 295 | 65.5 | 66.5 | 80.8 | 82 | 15.1 | 2001-11-12 14:47:00
 | NG G2 | 295 | 78 | 80.5 | 73.1 | 75.5 | 13.78 | 2001-11-12 14:47:00
 | NG H2 | 295 | 81 | 81.5 | 65.2 | 65.6 | 12.13 | 2001-11-12 14:47:00
 | NG J2 | 290 | 74 | 75.5 | 54 | 55.1 | 9.95 | 2001-11-12 14:47:00
 | NG K2 | 295 | 75.5 | 78 | 48.9 | 50.6 | 9.23 | 2001-11-12 14:47:00
 | NG M2 | 300 | 82.5 | 85.5 | 48.3 | 50 | 9.27 | 2001-11-12 14:47:00
 | NG N2 | 305 | 90 | 93 | 48.6 | 50.3 | 9.48 | 2001-11-12 14:47:00
 | NG Q2 | 310 | 98 | 100 | 49 | 50.1 | 9.66 | 2001-11-12 14:47:00
 | NG U2 | 310 | 101 | 106 | 47.9 | 50.4 | 9.58 | 2001-11-12 14:47:00
 | NG V2 | 310 | 107 | 114 | 48.6 | 51.9 | 9.79 | 2001-11-12 14:47:00
 | NG X2 | 330 | 118 | 123 | 48.2 | 50.3 | 10.22 | 2001-11-12 14:47:00
 | [NAME] | 355 | 134 | 137 | 49.3 | 50.4 | 11.13 | 2001-11-12 14:47:00
 | NG H3 | 355 | 139 | 140 | 46.5 | 46.8 | 10.41 | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 062d687e-8169-4868-aa0e-28e63d8c72bc
Sheet: CDS-A

A.  General Information
A0 | Respondent Information (Not for Publication)
A0 | Name: |  | [NAME]
A0 | Title: |  | Assessment Research Analyst
A0 | Office: |  | Office of Academic Assessment and Institutional Research
A0 | Mailing Address: |  | Ball State University, 200 West Quad
A0 | City/State/Zip/Country: |  | Muncie, IN 47306
A0 | Phone: |  | [PHONE]
A0 | Fax: |  | [PHONE]
A0 | E-mail Address: |  | [EMAIL]
A0 | Are your responses to the CDS posted for reference on your institution's Web site? |  |  | Yes | No
 |  |  |  | X
A0 | If yes, please provide the URL of the corresponding Web page:
 | http://cms.bsu.edu/About/AdministrativeOffices/Assessment/OfficialStatistics/CommonData.aspx
A0A | We invite you to indicate if there are items on the CDS for which you cannot use the requested analytic convention, cannot provide data for the cohort requested, whose methodology is unclear, or about which you have questions or comments in general. This information will not be published but will help the publishers further refine CDS items.
A1 | Address Information
A1 | Name of College/University: | Ball State University
A1 | Mailing Address: | 2000 W. University Ave.
A1 | City/State/Zip/Country: | Muncie, IN 47306
A1 | Street Address (if different):
A1 | City/State/Zip/Country:
A1 | Main Phone Number: | [PHONE]
A1 | WWW Home Page Address: | www.bsu.edu
A1 | Admissions Phone Number: | [PHONE]
A1 | Admissions Toll-Free Phone Number: | [PHONE]
A1 | Admissions Office Mailing Address: | Admissions Office, Ball State University
A1 | City/State/Zip/Country: | Muncie, IN 47306-0855
A1 | Admissions Fax Number: | [PHONE]
A1 | Admissions E-mail Address: | [EMAIL]
A1 | If there is a separate URL for your school’s online application, please specify: ______________ | www.bsu.edu/admissions/apply
A1 | If you have a mailing address other than the above to which applications should be sent, please provide:
A2 | Source of institutional control (Check only one):
A2 | Public | X
A2 | Private (nonprofit)
A2 | Proprietary
A3 | Classify your undergraduate institution:
A3 | Coeducational college | X
A3 | Men's college
A3 | Women's college
A4 | Academic year calendar:
A4 | Semester | X
A4 | Quarter
A4 | Trimester
A4 | 4-1-4
A4 | [NAME]
A4 | Differs by program (describe):
A4 | Other (describe):
A5 | Degrees offered by your institution:
A5 | Certificate
A5 | Diploma
A5 | Associate | X
A5 | Transfer Associate
A5 | Terminal Associate
A5 | Bachelor's | X
A5 | Postbachelor's certificate | X
A5 | Master's | X
A5 | Post-master's certificate | X
A5 | Doctoral degree research/scholarship | X
A5 | Doctoral degree – professional practice | X
A5 | Doctoral degree -- other | X
Spreadsheet: 45078d1243867401-using-boolean-to-compile-knowledge-flags-send
Sheet: Europe

6 | Country | Sent | Received | Location | Contact | Notes
0 | Albania
0 | Austia
0 | Bangladesh
7 | Belgium | Yes
0 | France
0 | Germany
0 | Great Britain
0 | Hungary
8 | Israel | Yes
0 | Italy
0 | Kazakistan
0 | Lebanon
0 | Malta
0 | [NAME]
0 | Netherlands
0 | Norway
0 | Romania
0 | Russia
0 | Spain
0 | Turkey
0 | Ukraine
0 | Uzbekistan
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 704499d1605604131-multiple-if-formulas-in-1-cell-calculator-sheet
Sheet: Calc Sheet

 | Prijs calculatie
 |  |  |  |  |  |  | Service | Product | Amount (Min) | Amount ([NAME]) | Contract Fee
 | Input aantal services | 251 |  |  |  |  | - | - | 0 | 50 | 26.86
 |  |  |  |  |  |  |  |  | 50 | 150 | 28.93
 | Total fee |  |  |  |  |  |  |  | 150 | 250 | 30.99
 |  |  |  |  |  |  |  |  | 250 | - | 33.06
 | Input 251 services
 | < 50 | 50 | for 26,86
 | 50 < 150 | 100 | for 28,93
 | 150 < 250 | 100 | for 30,99
 | > 250 | 1 | for 33,06
 | Input 64 services
 | < 50 | 50 | for 26,86
 | 50 < 150 | 14 | for 28,93
 | 150 < 250 | 0 | for 30,99
 | > 250 | 0 | for 33,06
 | Input 148 services
 | < 50 | 50 | for 26,86
 | 50 < 150 | 98 | for 28,93
 | 150 < 250 | 0 | for 30,99
 | > 250 | 0 | for 33,06
 | Input 193 services
 | < 50 | 50 | for 26,86
 | 50 < 150 | 100 | for 28,93
 | 150 < 250 | 43 | for 30,99
 | > 250 | 0 | for 33,06
Spreadsheet: 688083d1595562218-paye-as-you-earn-formula-paye-tax-formula
Sheet: Sheet1

PAY AS YOU EARN PAYE TABLE
Monthly
 | $ |  | $ |  | Rates |  | $
From | 0 | to | 70 | multiply by rate | 0 | Deduct | 0
From | 70.01 | to | 300 |  | 0.2 |  | 14
From | 300.01 | to | 1000 |  | 0.25 |  | 29
From | 1000.01 | to | 2000 |  | 0.3 |  | 79
From | 2000.01 | to | 3000 |  | 0.35 |  | 179
From | 3000.01 | and above |  |  | 0.4 |  | 329
Example
If any employee earns $1500.00 per month
1500.00 x 30.00 -79.00 | 371
EMPLOYEE NAME | [NAME] | TAX
TOMY | 70
CRAIG | 200
YOLANDA | 1500 |  | example
KIMBERLY | 2300
GABRIEL | 3000
ASHTON | 3100
I'm kindly asking for a excel formula to calculate tax for the above employees. The one which I used on C19 is time consuming.
I want a formula which I insert on C17 and drag and automatically calculates tax.
Spreadsheet: 80323d1280495287-extract-rows-based-on-criteria-sample1-1-
Sheet: Sheet1

Date | ID | Name | [NAME] | [NAME]
[NAME] |  | [NAME] | 1 | adrhaerjh
[NAME] |  | Will | 1 | darhaeh
[NAME] |  | Greg | 1 | adrhaerjh
[NAME] |  | [NAME] | 1 | aerh
[NAME] |  | Lore | 1 | hreaha
[NAME] |  | [NAME] | 1 | aerhadrha
Spreadsheet: 764602d1642812235-formula-needs-to-compare-cases-upper-lower-of-first-letter-and-update-words-correctly-change-case-upper_lower-of-1st-letter
Sheet: Sheet1

ID | <> 'Simple Present Tense' | = 'Simple Present Tense' | Status | Comment | Update To (Column C)
1 | achieve | achieve | Ok | 1. No difference between words (col B vs. col C); 2. both are in *lower* case
2 | Acquire | Acquire | Ok | 1. No difference between words (col B vs. col C); 2 both are in *Title* (proper) case
3 | Acquired | Acquire | Ok | 1. Tense was changed correctly (i.e., past tense to simple present tense); 2 both are in *Title* (proper) case
4 | act | act | Ok | 1. No difference between words (col B vs. col C); 2. both are in *lower* case
5 | Acted | Act | Ok | 1. Tense was changed correctly (i.e., past tense to simple present tense); 2 both are in *Title* (proper) case
6 | Acts | Act | Ok | 1. Tense was changed correctly (i.e., simple present tense continuous to simple present tense); 2 both are in *Title* (proper) case
7 | address | address | Ok | 1. No difference between words (col B vs. col C); 2. both are in *lower* case
8 | Addressed | address | Error | 1. Although tense was changed correctly; the word in column B is is *Title* (proper) case while word in column C is in lower case. | [NAME] needs to change word from "address" to "Address" to match source word's "A" in col B.
9 | Adept | Adept | Ok | 1. No difference between words (col B vs. col C); 2 both are in *Title* (proper) case
10 | advanced | Advance | Error | 1. Although tense was changed correctly; the word in column B is is *lower* case while word in column C is in *Title* (proper) case. | [NAME] needs to change word from "Advance" to "advance" to match source word's "a" in col B.
11 | advise | Advise | Error | 1. Although tense was changed correctly; the word in column B is is *lower* case while word in column C is in *Title* (proper) case. | [NAME] needs to change word from "Advise" to "advise" to match source word's "a" in col B.
12 | Bring | Bring | Ok | 1. No difference between words (col B vs. col C); 2 both are in *Title* (proper) case
13 | Broke | Break | Ok | 1. No difference between words (col B vs. col C); 2 both are in *Title* (proper) case
14 | build | Build | Error | 1. Although tense was changed correctly; the word in column B is is *lower* case while word in column C is in *Title* (proper) case. | [NAME] needs to change word from "Build" to "build" to match source word's "b" in col B.
15 | Built | Build | Ok | 1. No difference between words (col B vs. col C); 2 both are in *Title* (proper) case
Spreadsheet: 696922d1601042096-how-to-efficiently-manage-trapping-value-and-n-a-errors-example-level-1-10-country-carnival-and-level-6-10-state-challenge-7th-and-8th-november-202
Sheet: Floor

Level 1 - 10 - Country Carnival & Level 6-10 State Challenge - 7th & 8th November 2020 Session 1 Gymnastics Club ABC & Gymnastics Club [NAME] |  |  |  |  |  |  |  |  |  |  |  | Please select one gymnast for the Superhero Artistic Floor Novelty Award | Please select one gymnast considered for the Sportmanship Novelty Award | Please select one gymnast considered for the Superhero Costume Novelty Award | Scratch | Award Bagged
Club | Comp Number | First Name | Last Name | Level | Judge 1 | Judge 2 | D Score | Neutral Deduction | Average | Score | [NAME] | Superhero Artistic Floor | Sportmanship | Superhero Costume | Scratch | Award Bagged
ABC | 1111 | Gymnast | One | 3 |  |  | 10
ABC | 2222 | Gymnast | Two | 4 | 1 |  | 10
ABC | 3333 | Gymnast | Three | 5 |  |  | 10
 | Level 3 | Level 4 | Level 5
XYZ | 9999 | Gymnast | One | 3 | 1 |  | 10
XYZ | 8888 | Gymnast | Two | 3 | 2 | 1.5 | 10
XYZ | 7777 | Gymnast | Three | 4 | 3 |  | 10
XYZ | 6666 | Gymnast | Four | 4 | 2 |  | 10
XYZ | 5555 | Gymnast | Five | 5 |  |  | 10
XYZ | 4444 | Gymnast | Six | 5 |  |  | 10
 | Level 3 | Level 4 | Level 5
Spreadsheet: 752505d1634809839-partial-text-frequency-counting-in-reports-forum-sample-adenoma
Sheet: Sheet1

number | Report | Amount of [NAME]/no adenomas | Amount of no adenomas | Amount of adenomas
1 | Colonoscopy: biopsy performed 50 cm from anus. No polyp or adenoma. Tubulovillieus adenoma in biopsy 2. Biopsy 3 hyperplastic polyp. No adenoma.
2 | Fragemented hyperplastic polyp. No adenoma.
3 | Villieus adenoma in 1. No polyp. Biopsy 2 no polyp or adenoma. Biopsy 3 no adenoma or polyp
4 | I:  Tubular adenoma low grade dysplasia  II: biopsy 75 cm from anus: tubular adenoma low grade dysplasia III:  Tubular adenoma low grade dysplasia  IV:  Tubular adenoma low grade dysplasia  V: biopsy 60 cm from anus. No polyp or adenoma. VI: biopsy 50 cm from anus. hyperplastic polyp no adenoma.
5 | sessile laesion. 50 cm from anus
6 | [NAME] from anus. Adenocarcinoma, no other polyps
7 | I:  Tubular adenoma low grade dysplasia  II: no polyp or adenoma III:  adenoma undefined IV: hyper plastic polyp, no adenoma
8 | tubulovillieus adenoma in 1. Hyperplastic polyp in 2, no adenoma. No polyp or adenoma in 4.
9 | Infectious activity in 1
10 | I:  [NAME] biopsy coecum: tubulovillieus adenoma with low grade dysplasia. II: Polypectomy: tubular adenoma low [NAME]. Diamiter polyp 0,5 cm  III: Polypectomy 80 cm from anus. Tubulovilieus adenoma low [NAME]; diameter polyp 1,5cm. IV:  [NAME] membrane: No abnormalities (no polyp or adenoma)
Spreadsheet: john_forney__15504__200107
Sheet: TECO-SVCE

EPMI-TECO-SVCE
 |  | Deal Number | Total |  | 7/1 - 7/2 | 7/3 - 7/4 | 2001-07-05 00:00:00 | 7/6 - 7/8 | 2001-07-09 00:00:00 | 2001-07-10 00:00:00
Static Scheduling | Reliant Energy HL&P | 597370 |  |  | 49 |  | 147 | 98 |  | 98
 | Texas New Mexico Power | 670765
 | [NAME] | 670770 |  |  |  | 40 |  |  | 40
 | [NAME] | 628735
Unplanned Losses | American Electric Power Services Corp | 597371 |  |  | -2070.7 | -1939.9 | -3675.57 | -7046.03 | -1711.21 | -2154.43
 | [NAME] | 597372 |  |  | 15.65 | -106.34 | -113.4 | -174.97 | 58.54 | -8.29
 | [NAME] | 597373 |  |  | -139.51 | -14.14 | -23.65 | -33.56 | -142.15 | -61.36
 | Bryan Texas Utilities | 597374 |  |  | 150.17 | -2.44 | -3.84 | -4.29 | 150.62 | 67.18
 | City of Denton Municipal Utilities | 628739 |  |  |  |  |  |  |  | 1.26
 | City of Garland | 597376 |  |  |  |  |  | 0.98 |  | 5.77
 | City Public Services | 597375 |  |  | -207.11 | -405.83 | -500.65 | -927.53 | -55.52 | -252.46
 | Farmer's Electric Cooperative
 | Grayson-Collin Electric Cooperative
 | Greenville Electric Utility System |  |  |  |  |  |  |  |  | 1.48
 | Lower Colorado River Authority | 597377 |  |  | -101.31 | -134.63 | -204.12 | -388.25 | 389.15 | -113.05
 | Magic Valley Electric Cooperative | 597378 |  |  | -47.73 | -21.47 | -87.78 | -170.35 | -43.22 | -47.98
 | Public Utilities Board of Brownsville | 597379 |  |  | -7.57 | -9.27 | -12.06 | -22.92 | -6.09 | -7.96
 | Reliant Energy HL&P | 597380 |  |  | 364.91 | 1040.91 | 1099.46 | 1982.51 | 181.35 | 509.21
 | Rio Grande Electric Cooperative
 | South Texas Electric Cooperative | 597381 |  |  | -132.27 | -215.12 | -214.03 | -445.82 | -82.98 | -145.1
 | Southwest Electric Service Company |  |  |  |  |  |  | 0.16 |  | 0.17
 | Texas Municipal Power | 597383 |  |  | 217.63 | -9.27 | -15.28 | -22.37 | 216.93 | 102.61
 | Texas New Mexico Power | 597384 |  |  | 74.96 |  | -3.43 | -6.05 | 75.03 | 31.2
 | Tex-La Electric Cooperative
 | TXU Electric Services | 597382 |  |  | -383.92 | -441.44 | -584.03 | -807.33 | -292.87 | -125.85
password for Totals sheet = ercot
 | Counterparty Name
 | TXU Electric Services
 | Texas New Mexico Power
 | Reliant Energy HL&P
 | City Public Services
 | American Electric Power Services Corp
 | Lower Colorado River Authority
 | American Electric Power Services Corp
 | [NAME]
 | [NAME]
 | Texas Municipal Power
 | South Texas Electric Cooperative
 | South Texas Electric Cooperative
 | Public Utilities Board of Brownsville
 | Southwest Electric Service Company
 | Farmer's Electric Cooperative
 | TXU Electric Services
 | TXU Electric Services
 | Tex-La Electric Cooperative
 | Magic Valley Electric Cooperative
 | South Texas Electric Cooperative
 | TXU Electric Services
 | City of Garland
 | Rio Grande Elerctic Cooperative
 | Grayson-Collin Electric Cooperative
 | Bryan Texas Utilities
 | City of Denton Municipal Utilities
 | Grrenville Electric Utiliy System
Spreadsheet: 843627d1695404893-find-unique-value-in-one-column-then-return-furthest-yet-first-value-in-another-column-unique_value
Sheet: Sheet1

CS2
CS2 | 7
CS2 | 7 | 12
CS2 | 7 | 12 | 14
CS2 | 7 | 12 | 14 | 27
CS2 | 7 | 12 | 14 | 27 | 446
CS2 | 7 | 12 | 14 | 27 | 446 | [PHONE]
CS2 | 7 | 12 | 14 | 27 | 446 | [PHONE]
CS2 | 7 | 12 | 14 | 27 | 52
CS2 | 7 | 12 | 15 | 27 | 52 | [PHONE]
CS2 | 7 | 12 | 16 | 27 | 53
CS2 | 7 | 12 | 16 | 27 | 53 | [PHONE]
CS2 | 7 | 12 | 16 | 27 | 53 | [PHONE]
CS2 | 7 | 12 | 17 | 27 | 55
CS2 | 7 | 12 | 18 | 27 | 55 | [PHONE]
CS2 | 7 | 12 | 19
CS2 | 7 | 12 | 20 | 30
CS2 | 7 | 12 | 20 | 30 | [PHONE]
Spreadsheet: 56676d1256818330-combining-similar-rows-count-book1
Sheet: Sheet1

A | B | C
1 | ## | 109
1 | ## | 75
2 | ## | 67
2 | ## | 1999
2 | ## | 100
2 | ### | 104
2 | ## | 210
3 | ## | 3000
3 | ## | 98
3 | ## | 203
Spreadsheet: 281863d1386180341-faster-way-than-deleting-columns-one-by-one-to-reduce-my-data-to-the-correct-columns-test
Sheet: Large

Order Number | [NAME] | Line Number | Shipment Priority Code | HEADER Hold Name | LINE Hold Name | Source Type Code | Schedule Shipment Date
110018594 | ICSUS Standard | 1.1 | ICSUS_2 |  | Customer Service Hold | INTERNAL | 2013-12-02 00:00:00
110024589 | ICSUS Standard | 1.1 | ICSUS_2 |  | Customer Service Hold | INTERNAL | 2013-12-02 00:00:00
110025141 | ICSUS Standard | 6.1 | ICSUS_3 |  |  | INTERNAL | 2013-11-25 00:00:00
110025142 | ICSUS Standard | 2.1 | ICSUS_3 |  |  | INTERNAL | 2013-12-02 00:00:00
110025143 | ICSUS Standard | 3.1 | ICSUS_3 |  |  | INTERNAL | 2013-12-02 00:00:00
Spreadsheet: ab91e035-c2f6-423e-b478-b375f3a4add5
Sheet: 29

Uke: | 29 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: Greater Taree CRB20

CRB20 for Greater Taree
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Greater Taree CRB20 |  | RMS Specification |  | Deviation | % Retained | [NAME] |  | Deviation | Result | Spec
Sieve mm | 20mm Roadbase | White Roadbase | Pit Fines | 10mm | Crun 210513 | Ammd 20mm Scalps | ROSA | Blend Result | Passing Lower | Passing Upper | Passing Lower | Passing Upper | Passing | Blend Result | Lower | Upper | Retained | ABC
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 99 | 100 | 100 | 100 | 99 | 100 | 100 | 99.4 | 95 | 100 | 95 | 100 | 0 | 0.5999999999999943
13.2 | 87 | 86 | 100 | 100 | 89 | 90 | 100 | 89.4 | 77 | 93 | 78 | 92 | 0 | 10 | 6 | 18 | 0
9.5 | 74 | 68 | 100 | 87 | 75 | 72 | 100 | 78 | 63 | 83 | 63 | 83 | 0 | 11.40000000000001 | 7 | 17 | 0
6.7 | 62 | 54 | 100 | 28 | 59 | 57 | 100 | 68 | 50 | 70 | 50 | 70 |  |  | 10 | 21
4.75 | 52 | 42 | 100 | 7 | 45 | 46 | 100 | 59.6 | 44 | 64 | 44 | 64 | 0 | 18.4 | 13 | 25 | 0
2.36 | 32 | 29 | 100 | 2 | 26 | 30 | 100 | 45 | 29 | 49 | 33 | 49 | 0 | 14.6 | 7 | 19 | 0
0.425 | 11 | 17 | 65 | 0 | 8 | 8 | 100 | 23 | 13 | 23 | 14 | 23 | 0 | 22 | 14 | 30 | 0 | 51.11111111111111 | 35-55
0.075 | 5.5 | 12 | 35 | 0 | 3 | 4 | 100 | 12.7 | 5 | 11 | 7 | 14 | 1.699999999999999 | 10.3 | 6 | 13 | 0 | 55.21739130434782 | 35-55
0.0135 | 3.5 | 6 | 17 | 0 | 1 | 2 | 40 | 6.7 | 3 | 7 | 3 | 7 | 0 | 5.999999999999999 | 3 | 8 | 0 | 52.75590551181103 | 35-60
PI | 0 | 7 | 0 |  |  |  |  | 1.034782608695652 | 2 | 6 | 2 | 6
Ratio | 60 | 20 | 20 | 0 | 0 | 0 | 0 | 100 | Min CBR | 80
 |  |  |  |  |  |  |  |  | Note: Pre-treatment required
Spreadsheet: 6fbd8422-9e0e-411d-8416-119270e249a3
Sheet: Sheet1

WQCD GWUDI Screening Tool - Version 3.2 - December 26, 2013
Instructions: Enter data in the grey cells only.  Determine the GWUDI Score.
Well Information | Data Entry | Units | Score | Explanation
System Name: | Beaver Creek Youth Camp |  |  | new name:  [NAME]
PWSID: | CO0253060
Well name:
DWR Well Permit No.: | 24661F
Total Depth of well: | 264 | feet
Screened Interval Depth, top: | 184 | feet |  | <20 feet = 60; 20-50 feet = 40; >50 feet = 0
Screened Interval Depth, bottom: | 264 | feet
[NAME] pump rate: | 25 | gpm
Nominal pump rate: | 6 | gpm |  | This value is used to calculate 50 day radius. It is convereted to cubic feet per minute in the 50 day calculation.
Aqquifer Name | "ALL UNNAMED AQUIFERS" |  |  | Aquifer name should be on DWR Permit Application (not always available).
DWR Aquifer Type: | Type 3 |  |  | Type 1 ([NAME]) = NOT GWUDI;  Type 2 (Unconfined Bedrock Aquifer) = 10  Type 3 (Unconfined [NAME]) = 10
Estimated Porosity = 0.25 (Do not change): | 0.25 |  |  | Default is 0.25 (no units for porosity) - most water rights calculations use 0.3, but for the purposes of this screening, use 0.25.
[NAME]  (at screened interval): | 169-185 Red granite, 185-220 black granite with clay, 220-245 black granite, 245-264 black granite with clay |  |  | Obtain from DWR well log, inlcude type of soils: sand, clay, gravel, etc.
MPA Result Ranking: | no mpa |  |  | Low = 0, moderate = 30, High = 50 - no mpa = 10
Algae or diatoms present?
MPA Score: |  |  |  | MUST BE TAKEN APRIL - SEPT.
DISTANCE TO SURFACE WATER
Type of nearest surface water: | creek |  |  | river, intermittent stream, ditch, pond, reservoir, etc
Name of nearest surface water: | Beaver Creek
How was distance measured: | Google Earth
Horizontal distance to surface water (feet): | 277 | feet |  | <100 feet = 40, 100 to 500 feet=20, >500 feet = 0
50 Day Radius Estimate: |  | feet |  | 50 day+10% > horizontal distance → 30;  50 day-5% < horizontal distance → 0;  50 day (+/- 5-10%) = horizontal distance → 20
 |  |  |  | Assumes steady state pumping, homogeneous aquifer, no regional groundwater flow
Total Score |  |  |  | >40 points = GWUDI Evaluation Necessary
 |  |  |  | ≤40 points = No Evaluation
 |  |  | Type 1 | Yes
 |  |  | Type 2 | No
 |  |  | Type 3
 |  |  | low
 |  |  | moderate
 |  |  | high
 |  |  | no mpa
Spreadsheet: 40709d1239112848-check-if-date-is-between-2-dates-book2
Sheet: Sheet2

Sample dates |  |  |  |  | Fin Year | Fin Month | Start Date |  | End Date
2008-06-29 00:00:00 |  |  |  |  | FY09 | P1 | 2008-06-28 00:00:00 |  | 2008-08-01 00:00:00
2008-08-03 00:00:00 |  |  |  |  |  | P2 | 2008-08-02 00:00:00 |  | 2008-08-29 00:00:00
 |  |  |  |  |  | P3 | 2008-08-30 00:00:00 |  | 2008-09-26 00:00:00
 |  |  |  |  |  | P4 | 2008-09-27 00:00:00 |  | 2008-10-31 00:00:00
 |  |  |  |  |  | P5 | 2008-11-01 00:00:00 |  | 2008-11-28 00:00:00
 |  |  |  |  |  | P6 | 2008-11-29 00:00:00 |  | 2008-12-26 00:00:00
 |  |  |  |  |  | P7 | 2008-12-27 00:00:00 |  | 2009-01-30 00:00:00
 |  |  |  |  |  | P8 | 2009-01-31 00:00:00 |  | 2009-02-27 00:00:00
 |  |  |  |  |  | P9 | 2009-02-28 00:00:00 |  | 2009-03-27 00:00:00
 |  |  |  |  |  | P10 | 2009-03-28 00:00:00 |  | 2009-05-01 00:00:00
 |  |  |  |  |  | P11 | 2009-05-02 00:00:00 |  | 2009-05-29 00:00:00
 |  |  |  |  |  | P12 | 2009-05-30 00:00:00 |  | 2009-07-03 00:00:00