tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813965d1674075565-selecting-the-nearest-static-location-weather-station-for-a-list-of-gps-tracker-points-gps_weather_sample_data
Sheet: Tarifa Weather

Station name | Latitude | Longitude | dt_iso | Date_Time | T_Min (C) | [NAME] (C) | Pressure (hPa) | Humidity (%) | Wind_Speed (m/s) | Wind_Deg (˚) | [NAME]) | Clouds (%)
Tarifa | 36.015313 | -5.602976 | 2020-06-05 06:00:00 +0000 UTC |  | 18 | 20 | 1015 | 88 | 2.1 | 180 |  | 75
Tarifa | 36.015313 | -5.602976 | 2020-06-05 07:00:00 +0000 UTC |  | 18.53 | 20 | 1015 | 77 | 2.6 | 170 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 08:00:00 +0000 UTC |  | 19.28 | 22 | 1015 | 64 | 2.6 | 190 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 09:00:00 +0000 UTC |  | 19.81 | 23 | 1015 | 60 | 3.6 | 200 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 10:00:00 +0000 UTC |  | 20.52 | 24 | 1015 | 57 | 5.1 | 230 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 11:00:00 +0000 UTC |  | 20.99 | 24 | 1016 | 57 | 5.1 | 220 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 12:00:00 +0000 UTC |  | 21.31 | 24 | 1015 | 60 | 5.1 | 230 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 13:00:00 +0000 UTC |  | 21.53 | 25 | 1015 | 64 | 6.2 | 240 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 14:00:00 +0000 UTC |  | 21.62 | 25 | 1015 | 64 | 6.2 | 230 |  | 40
Tarifa | 36.015313 | -5.602976 | 2020-06-05 15:00:00 +0000 UTC |  | 21.62 | 26 | 1014 | 64 | 4.6 | 240 |  | 40
Spreadsheet: 71f5b8b4-1061-4457-a0a4-302c49a4dcb7
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
FSH | Test | FSH | Follicle-Stimulating Hormone (FSH), Serum | FSH, S | Immunoenzymatic Assay | Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Males 1-7 days: < or =3.0 IU/L 8-14 days: < or =1.4 IU/L 15 days-3 years: < or =2.5 IU/L 4-6 years: < or =6.7 IU/L 7-8 years: < or =4.1 IU/L 9-10 years: < or =4.5 IU/L 11 years: 0.4-8.9 IU/L 12 years: 0.5-10.5 IU/L 13 years: 0.7-10.8 IU/L 14 years: 0.5-10.5 IU/L 15 years: 0.4-18.5 IU/L 16 years: < or =9.7 IU/L 17 years: 2.2-12.3 IU/L > or =18 years: 1.0-18.0 IU/L   TANNER STAGES* Stage l: < or =3.7 IU/L Stage ll: < or =12.2 IU/L Stage lll: < or =17.4 IU/L Stage lV: 0.3-8.2 IU/L Stage V: 1.1-12.9 IU/L *Puberty onset occurs for boys at a median age of 11.5 (+/- 2) years. For boys there is no proven relationship between puberty onset and body weight or ethnic origin. Progression through Tanner stages is variable. Tanner stage V (adult) should be reached by age 18.  Females 1-7 days: < or =3.4 IU/L 8-14 days: < or =1.0 IU/L 15 days-6 years: < or =3.3 IU/L 7-8 years: < or =11.1 IU/L 9-10 years: 0.4-6.9 IU/L 11 years: 0.4-9.0 IU/L 12 years: 1.0-17.2 IU/L 13 years: 1.8-9.9 IU/L 14-16 years: 0.9-12.4 IU/L 17 years: 1.2-9.6 IU/L > or =18 years: Premenopausal Follicular: 3.9-8.8 IU/L Midcycle: 4.5-22.5 IU/L Luteal: 1.8-5.1 IU/L Postmenopausal: 16.7-113.6 IU/L   TANNER STAGES* Stage l: 0.4-6.7 IU/L Stage ll: 0.5-8.7 IU/L Stage lll: 1.2-11.4 IU/L Stage lV: 0.7-12.8 IU/L Stage V: 1.0-11.6 IU/L *Puberty onset (transition from Tanner stage I to Tanner stage II) occurs for girls at a median age of 10.5 (+/- 2) years. There is evidence that it may occur up to 1 year earlier in obese girls and in African American girls. Progression through Tanner stages is variable. Tanner stage V (adult) should be reached by age 18.   Pediatric ranges derived for DXI method from analytic comparison to reference method in: Elmlinger MW, Kuhnel W, [NAME]: Reference ranges for serum concentrations of lutropin (LH), follitropin (FSH), estradiol (E2), prolactin, progesterone, sex hormone-binding globulin (SHBG), dehydroepiandrosterone sulfate (DHEAS), cortisol and ferritin in neonates, children and young adults. [NAME] 2002;40(11):1151-1160 | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 83001 |  |  |  |  | Rochester
FSH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FSH | Result | FSH | FSH, S | FSH, S | Numeric |  |  |  |  | IU/L |  |  |  |  |  |  |  |  |  | 15067-2
Spreadsheet: 137009d1326909602-indirect-function-copy-of-qa-tracking-sheet
Sheet: Pal

Date | Converted by |  | Error | [NAME] |  | Date | Count
2012-01-18 00:00:00 | Abu | 1 | perfect |  |  | 2012-01-01 00:00:00 | 0
2012-01-18 00:00:00 | Tamar | 2 | perfect |  |  | 2012-01-02 00:00:00 | 0
 |  |  |  |  |  | 2012-01-03 00:00:00 | 0
 |  |  |  |  |  | 2012-01-04 00:00:00 | 0
 |  |  |  |  |  | 2012-01-05 00:00:00 | 0
 |  |  |  |  |  | 2012-01-06 00:00:00 | 0
 |  |  |  |  |  | 2012-01-07 00:00:00 | 0
 |  |  |  |  |  | 2012-01-08 00:00:00 | 0
 |  |  |  |  |  | 2012-01-09 00:00:00 | 0
 |  |  |  |  |  | 2012-01-10 00:00:00 | 0
 |  |  |  |  |  | 2012-01-11 00:00:00 | 0
 |  |  |  |  |  | 2012-01-12 00:00:00 | 0
 |  |  |  |  |  | 2012-01-13 00:00:00 | 0
 |  |  |  |  |  | 2012-01-14 00:00:00 | 0
 |  |  |  |  |  | 2012-01-15 00:00:00 | 0
 |  |  |  |  |  | 2012-01-16 00:00:00 | 0
 |  |  |  |  |  | 2012-01-17 00:00:00 | 0
 |  |  |  |  |  | 2012-01-18 00:00:00 | 2
 |  |  |  |  |  | 2012-01-19 00:00:00 | 0
 |  |  |  |  |  | 2012-01-20 00:00:00 | 0
 |  |  |  |  |  | 2012-01-21 00:00:00 | 0
 |  |  |  |  |  | 2012-01-22 00:00:00 | 0
 |  |  |  |  |  | 2012-01-23 00:00:00 | 0
 |  |  |  |  |  | 2012-01-24 00:00:00 | 0
 |  |  |  |  |  | 2012-01-25 00:00:00 | 0
 |  |  |  |  |  | 2012-01-26 00:00:00 | 0
 |  |  |  |  |  | 2012-01-27 00:00:00 | 0
 |  |  |  |  |  | 2012-01-28 00:00:00 | 0
 |  |  |  |  |  | 2012-01-29 00:00:00 | 0
 |  |  |  |  |  | 2012-01-30 00:00:00 | 0
 |  |  |  |  |  | 2012-01-31 00:00:00 | 0
Spreadsheet: 832591d1686466110-if-any-cell-in-column-b-includes-any-of-these-words-in-range-j1-j4-then-highlight-row-post-4-book1
Sheet: Sheet1

No. | Item | 2016 | 2017 | 2018 | 2019 |  |  |  | ItemsNames |  | If any cell in column B includes any of these words in range Table5, then highlight entire row with read
1 | Fixed assets |  |  |  |  |  |  |  | Fixed
2 | Total non-current assets |  |  |  |  |  |  |  | Loans
3 | Cash and the like |  |  |  |  |  |  |  | Sales
4 | Total current assets |  |  |  |  |  |  |  | Long
No. | Item | 2016 | 2017 | 2018 | 2019 |  |  |  | Asset |  | If I added any new item to Table 5 (like items in the range J7:J9, how to let it update itself and highlight the entire row?
1 | Total current liabilities |  |  |  |  |  |  |  | Cash
2 | long term loans |  |  |  |  |  |  |  | Goods
3 | Total non-current liabilities
4 | total liabilities
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Sales
2 | Cost of Goods Sold
3 | Inventory
4 | Loan
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Fixed Assets
2 | Cash Papers
3 | Inventory
4 | Long Loan
Spreadsheet: 806260d1669200831-extracting-missing-time-intervals-missing-times-ans
Sheet: Sheet1

 |  |  | Missing period
08:00:00 | 08:30:00 |  |  |  |  |  | 08:35:00
08:35:00 | 09:00:00 |  |  |  |  | 09:56:00 | 10:15:00
09:00:00 | 09:56:00
10:15:00 | 11:00:00
Spreadsheet: 764349d1642692715-requesting-for-a-nested-formula-to-allot-the-amount-variable-lookup-anil_kumar2011-
Sheet: Sheet1

2021-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Parameter | Criteria
 |  |  |  |  |  |  |  |  |  |  | Attendance | 1 day leave or no leaves
 |  |  |  |  |  |  |  |  |  |  | Other Parameters | >= team average
Name | Cummulative Score | Talktime | Leaves | EMP ID | Eligibility | Category | Amount | Rank | Category Rank
AAA | Not Eligible | 1 | 0 | ED21833273 | Cummulative Score | 5 |  | 31 |  |  | Slab | Criteria | Amount (TBD)
BBB | Not Eligible | 0 | 2 | ED21834339 | Cummulative Score | 5 |  | 28 |  |  | 1 | With 100% attendance & all other criteria | 10000 | 9750 | 9500
CCC | Eligible | 1 | 0 | ED21833277 | Eligible | 1 |  | 4 |  |  | 2 | With 100% attendance & all criteria (except TT >= 2 hour | 8000
DDDD | Not Eligible | 0 | 1 | ED21833479 | Cummulative Score | 5 |  | 34 |  |  | 3 | With 1 day leave & all criteria | 6000
EEEE | Not Eligible | 2 | 1 | ED21817669 | Cummulative Score | 5 |  | 21 |  |  | 4 | With 1 day leave & all criteria (except TT >= 2 hour | 4000
FFFF | Not Eligible | 0 | 4 | ED201804269 | Cummulative Score | 5 |  | 20 |  |  |  | [NAME] | Min | Condition | Count | 1 | 2 | 3 | 4 | 5
GGGG | Not Eligible | 0 | 3 | ED201804270 | Cummulative Score | 5 |  | 37 |  |  | Slab 1 with someone in Slab 2 | 10000 | 9000
HHHH | Not Eligible | 2 | 1 | ED21854295 | Cummulative Score | 5 |  | 27 |  |  | Slab 1 with no one in Slab 2 | 10000 | 7000
IIIII | Eligible | 1 | 0 | ED201705637 | Eligible | 1 |  | 3 |  |  | Slab 2 | 8999 | 7000
JJJJJJ | Eligible | 1 | 4 | ED21834792 | Attendance | 5 |  | 13 |  |  | Slab 3 with someone in Slab 4 | 6999 | 5000
KKKK | Eligible | 1 | 0 | ED201500744 | Eligible | 1 |  | 1 |  |  | Slab 3 with no one in Slab 4 | 6999 | 4000
LLLLLLL | Not Eligible | 0 | 3 | ED21853052 | Cummulative Score | 5 |  | 36 |  |  | Slab 4 | 4999 | 4000
Spreadsheet: 799770d1665268886-how-to-extract-the-corresponding-numbers-in-area-a-to-area-b-fr1009
Sheet: Sheet2

AREA A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AREA B
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 14 | 15 | 16 | 17
0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 1 | 2 | 3 | 4 | 5 | 8 | 9 | 11 | 12 | 14 | 15 | 16 | 17 | 18
0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 1 | 2 | 4 | 5 | 7 | 8 | 11 | 12 | 13 | 14 | 15 | 17
Spreadsheet: 01a7e229-0a57-4f22-bbf2-f7435fdca1d5
Sheet: Sheet1

Please complete | SASID should be a 10 digit number - no dashes or spaces | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
County: | Codes should not exceed 4 digits, no text
District/Charter School Name: | Text should go in "Comment" section
District/Charter School Code:
If Submitting as an individual charter school:
Authorizing Agent/District Name:
Authorizing Agent/District Code:
Student Name | SASID 10 digit | Birth date (to verify data) | School Code | District Code | Comment
Example Name | 1111111111 | 2000-01-01 00:00:00 | 1234 | 4321 | none
Spreadsheet: 676992d1589130938-transpose-data-from-1-column-to-rows-transpose-equally
Sheet: Sheet1

ITEMS ( RAW DATA WITH ME) |  | Output
1 |  | Persons | Attendance
2 |  | A | Present | 1 | 2 | 3 | 4 | 5
3 |  | B | Present | 6 | 7 | 8 | 9 | 10
4 |  | C | Abscent | - | - | - | - | -
5 |  | D | Present | 11 | 12 | 13 | 14 | 15
6 |  | E | Present | 16 | 17 | 18 | 19 | 20
7 |  | F | Present | 21 | 22 | 23 | 24 | 25
8 |  | G | Present | 26 | 27 | 28 | 29 | 30
9 |  | H | Present | 31 | 32 | 33 | 34 | 35
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
Spreadsheet: 887135d1737301735-assistance-with-comparing-and-identifying-differences-in-excel-match-lay-out
Sheet: old

TEST Name | Sex | Low range | High Range | Alert low | Alert High
ALB |  | 3.5 | 4.9 | 0 | 0
ALT |  | 1 | 45 | 0 | 0
AST |  | 1 | 35 | 0 | 0
BUN | F | 6 | 23 | 0 | 0
CA |  | 8.5 | 10.5 | 6.5 | 13
CL |  | 96 | 108 | 10 | 200
CREA | M | 0.7 | 1.3 | 0 | 0
GLUC |  | 60 | 100 | 49 | 501
K |  | 3.5 | 5.2 | 2.5 | 6.5
NA |  | 135 | 145 | 119 | 156
PO4 |  | 2.4 | 4.7 | 1.6 | 10.1
TBIL |  | 0.1 | 10 | 0 | 16
TCO2 |  | 22 | 30 | 11.9 | 40.1
Spreadsheet: 145687d1331710707-autofill-across-worksheets-sample-workbook
Sheet: Cash Budget

 |  | CASH BUDGET FORM
 |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4
1 | Accounts to be recieved
2 | Bank Loans | 5000 | 0 | 0 | 0 | 0 | 0 | 3000 | 0 | 0 | 0 | 0 | 0
3 | Bond Sale Return | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 2000 | 0 | 0
4 | Savings Interest
5 | Savings Withdrawal | 2000 | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | Plant & Equipment Sale | 90.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 121 | 0 | 300.6
7 | Stock Sale Return | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | Beginning Cash | 8378.46270078993 | 34663.0675886372 | 43047.41946270927 | 46033.92430950551 | 35546.89877826656 | 31448.3028334679 | 13892 | 2645.203013080216 | 0 | 6895 | 17678.62495577187 | 57182.96366794089
9 | Total Sources
10
11 | Production Costs | 32192 | 29015 | 31099 | 36019 | 44523 | 31284 | 27969 | 44706 | 40264 | 40417 | 44877 | 37090
12 | Marketing Costs | 5452 | 5894.51250624543 | 5916.690150229446 | 7198.438230355378 | 8500 | 9653.875775124328 | 11467.83649550702 | 12179.32995774063 | 11828.72988270592 | 15579.63561862309 | 19575.13895063947 | 21076.76667152366
13 | Other Costs | 5802.496652600044 | 6378.134628538357 | 6091.161259178189 | 7008.534374272705 | 7334 | 7643.816930882104 | 8764.857519971334 | 9594.546273835653 | 10015.95546791917 | 12785.65743969297 | 15374.71503798919 | 16710.96517326218
14 | Dividends | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | [NAME] | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 3000 | 787.9927964456438 | 0 | 0 | 0
16 | Bonds Redeemed | 0 | 2000 | 2000 | 2000 | 2000 | 2000 | 0 | 0 | 0 | 0 | 0 | 5000
17 | Income Taxes |  |  |  |  |  | 0
18 | Profit-Sharing Cost |  |  |  |  |  | 0
19 | Plant and Equipment Investment | 0 | 0 | 601.2 | 1801.2 | 903 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | Savings-Deposit | 0 | 0 | 2000 | 2000 | 2000 | 4000 | 0 | 0 | 0 | 0 | 4000 | 5000
21 | Total Allocations
22 | Ending Cash Balance
Spreadsheet: 377013d1423768318-calculate-the-home-win-streak-for-a-team-wins-at-home-countifs
Sheet: Sheet1

 |  |  | Home Away |  | Home | Visitor | W/L |  | Win streak | Home Win Streak | Wins Count | Home Wins
 |  |  | vs |  | 90 | 95
 |  |  | @ |  | 114 | 108
 |  |  | @ |  | 82 | 101
 |  |  | @ |  | 100 | 102
 |  |  | @ |  | 110 | 101
 |  |  | vs |  | 118 | 111
 |  |  | @ |  | 122 | 121
 |  |  | vs |  | 127 | 94
 |  |  | vs |  | 97 | 106
 |  |  | vs |  | 90 | 92
 |  |  | @ |  | 78 | 91
 |  |  | vs |  | 93 | 110
 |  |  | vs |  | 106 | 74
 |  |  | vs |  | 113 | 87
 |  |  | vs |  | 109 | 97
 |  |  | vs |  | 111 | 108
 |  |  | @ |  | 90 | 87
 |  |  | @ |  | 105 | 91
 |  |  | @ |  | 110 | 88
 |  |  | vs |  | 105 | 101
 |  |  | @ |  | 94 | 103
 |  |  | @ |  | 114 | 119
 |  |  | vs |  | 97 | 88
 |  |  | vs |  | 98 | 127
 |  |  | vs |  | 95 | 91
 |  |  | vs |  | 105 | 91
 |  |  | vs |  | 125 | 104
 |  |  | @ |  | 91 | 101
 |  |  | @ |  | 98 | 89
 |  |  | vs |  | 80 | 103
 |  |  | @ |  | 101 | 109
 |  |  | vs |  | 80 | 96
 |  |  | @ |  | 91 | 87
 |  |  | vs |  | 90 | 109
 |  |  | @ |  | 92 | 95
 |  |  | vs |  | 93 | 105
 |  |  | @ |  | 94 | 112
 |  |  | @ |  | 84 | 103
 |  |  | @ |  | 100 | 107
 |  |  | @ |  | 109 | 102
 |  |  | @ |  | 126 | 121
 |  |  | vs |  | 108 | 94
 |  |  | vs |  | 106 | 92
 |  |  | vs |  | 129 | 90
 |  |  | vs |  | 108 | 98
 |  |  | @ |  | 103 | 95
 |  |  | vs |  | 99 | 94
 |  |  | vs |  | 101 | 90
 |  |  | @ |  | 106 | 90
 |  |  | vs |  | 97 | 84
 |  |  | vs |  | 105 | 94
 |  |  | @ |  | 99 | 103
 |  |  | vs |  | 120 | 105
 |  |  | vs |  | 113 | 93
Spreadsheet: monika_causholli__28146__Christofer
Sheet: Sheet1

Source: RISI
Prepared by : [NAME]
 |  |  | RISI Forecast of Prices for SBSK
Date | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
SBSK | 514 | 671 | 760 | 772 | 655 | 510 | 548 | 757 | 733 | 510 | 540 | 777 | 733 | 522 | 550 | 778 | 757
Spreadsheet: 101267d1299428815-problem-with-countif-formula-countif_problem_book1-1-
Sheet: Sheet1

Serial Number |  | COUNTIF |  | MATCH |  | A*1 | COUNTIF |  | A&"A" | COUNTIF
899720203566850511 |  | 0 |  | #N/A |  | 8.9972020356685e+17 | 0 |  | 899720203566850511A | 0
899720203566848507 |  | 0 |  | #N/A |  | 8.99720203566848e+17 | 0 |  | 899720203566848507A | 0
899720203566850206 |  | 1 |  | #N/A |  | 8.9972020356685e+17 | 1 |  | 899720203566850206A | 0
899720203566849133 |  | 0 |  | #N/A |  | 8.99720203566849e+17 | 0 |  | 899720203566849133A | 0
899720203566849158 |  | 1 |  | #N/A |  | 8.99720203566849e+17 | 1 |  | 899720203566849158A | 0
899720203566848945 |  | 1 |  | #N/A |  | 8.99720203566848e+17 | 1 |  | 899720203566848945A | 0
899720203566849166 |  | 2 |  | #N/A |  | 8.99720203566849e+17 | 2 |  | 899720203566849166A | 0
899720203566849489 |  | 3 |  | #N/A |  | 8.99720203566849e+17 | 3 |  | 899720203566849489A | 0
899720203566849307 |  | 4 |  | #N/A |  | 8.99720203566849e+17 | 4 |  | 899720203566849307A | 0
899720203566849299 |  | 5 |  | #N/A |  | 8.99720203566849e+17 | 5 |  | 899720203566849299A | 0
899720203566849604 |  | 6 |  | #N/A |  | 8.99720203566849e+17 | 6 |  | 899720203566849604A | 0
899720203566849448 |  | 7 |  | #N/A |  | 8.99720203566849e+17 | 7 |  | 899720203566849448A | 0
899720203566849430 |  | 8 |  | #N/A |  | 8.99720203566849e+17 | 8 |  | 899720203566849430A | 0
899720203566849653 |  | 9 |  | #N/A |  | 8.99720203566849e+17 | 9 |  | 899720203566849653A | 0
899720203566848499 |  | 2 |  | #N/A |  | 8.99720203566848e+17 | 2 |  | 899720203566848499A | 0
899720203566849679 |  | 10 |  | #N/A |  | 8.99720203566849e+17 | 10 |  | 899720203566849679A | 0
899720203566849687 |  | 11 |  | #N/A |  | 8.99720203566849e+17 | 11 |  | 899720203566849687A | 0
899720203566849869 |  | 12 |  | #N/A |  | 8.99720203566849e+17 | 12 |  | 899720203566849869A | 0
899720203566849513 |  | 13 |  | #N/A |  | 8.99720203566849e+17 | 13 |  | 899720203566849513A | 0
899720203566849455 |  | 14 |  | #N/A |  | 8.99720203566849e+17 | 14 |  | 899720203566849455A | 0
899720203566849281 |  | 15 |  | #N/A |  | 8.99720203566849e+17 | 15 |  | 899720203566849281A | 0
899720203566850511 |  | 2 |  | 2 |  | 8.9972020356685e+17 | 2 |  | 899720203566850511A | 1
899720203566848507 |  | 3 |  | 3 |  | 8.99720203566848e+17 | 3 |  | 899720203566848507A | 1
899720203566850206 |  | 3 |  | 4 |  | 8.9972020356685e+17 | 3 |  | 899720203566850206A | 1
Spreadsheet: 69599d1270133449-calculating-accrual-of-sick-days-attendance_dummy
Sheet: YTD Summary

Last Name | First Name | Vacation | Statutory Holiday | Personal Days | Sick Days | Workshop | [NAME] | Meeting | Doctor's Appt. | In Late/  Left Early | no work (or bereavement) | Supervisor | Department | Hire Date | Vacation Days | Vacation Days Remaining | Sick Days | Sick Days Remaining | Telephone No. [PHONE]
Cole | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-23 00:00:00 | 15 |  |  |  | x. 233
Feigen | Pam |  |  |  |  |  |  |  |  |  |  |  |  | 2007-12-10 00:00:00 | 15 |  |  |  | x. 223
 |  |  |  |  |  |  |  |  |  |  |  |  | Abbreviations
 |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | v
 |  |  |  |  |  |  |  |  |  |  |  |  | Statutory Holidays | h
 |  |  |  |  |  |  |  |  |  |  |  |  | Personal Days | p
 |  |  |  |  |  |  |  |  |  |  |  |  | Sick Days | i
 |  |  |  |  |  |  |  |  |  |  |  |  | Workshop | w |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | l
 |  |  |  |  |  |  |  |  |  |  |  |  | Meeting | b
 |  |  |  |  |  |  |  |  |  |  |  |  | Doctor's Appt. | d
 |  |  |  |  |  |  |  |  |  |  |  |  | In Late/Left Early | a
 |  |  |  |  |  |  |  |  |  |  |  |  | no work (or bereavement) | n
Spreadsheet: 0b0cdc94-ff64-4818-94e2-966209cc6ece
Sheet: Sheet1

Bureau of Environmental Services Budget Advisory Committee FY 2014-15 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Budget Reductions Ranking Worksheet
Current |  |  |  | FY 2014-15
BAC Avg |  |  |  | Reduction
Average |  | BES |  | Amount |  | Explanation | Cumulative Total
4 |  | 4 |  | -47400 |  | 20% reduction in Intergovernmental Agreement for Vector Control. | -47400
4 |  | 4 |  | -60000 |  | Negotiate $5,000/monthly lease payment by Multnomah County Vector Control to the Bureau for beneficial use of Bureau property. | -107400
4 |  | 4 |  | -345538 |  | Updated projections based on energy usage at existing pump stations. | -452938
4 |  | 4 |  | -72000 |  | End support that BES provides to SWNI for staffing the Watershed Resource Center (WRC) | -524938
4 |  | 4 |  | -75000 |  | Stormwater Management Manual update complete. | -599938
3.8 |  | 4 |  | -150000 |  | Remove one-time expenditure for software upgrade and training. | -749938
3.75 |  | 4 |  | -119000 |  | Transfer funding for maintenance and repair of Loos to General Fund. | -868938
3.6 |  | 4 |  | -411354 |  | Facilities Plan completed. | -1280292
3.6 |  | 4 |  | -101748 |  | Remove one-time expenditure for software upgrade and training. | -1382040
3.6 |  | 4 |  | -10000 |  | Remove funding for equipment already purchased. | -1392040
3.5 |  | 4 |  | -425000 |  | End support for street cleaning. | -1817040
3.5 |  | 4 |  | -100000 |  | Reduce budget for developing  [NAME] Green Factor requirements to conform with historical expenditures. | -1917040
3.25 |  | 3 |  | -100000 |  | Reduce  funds  available for supporting the natural resource trustees. | -2017040
3.2 |  | 4 |  | -60000 |  | Purchase of equipment completed in prior year. | -2077040
3 |  | 3 |  | -60000 |  | Reduce interagency agreement for maintenance and janitorial services at the Water Pollution Control Laboratory from $260,000 to $200,000. | -2137040
2.6 |  | 4 |  | -450000 |  | Step one of a five-year transition of all water meter maintenance costs to the utility base charge. | -2587040
2.5 |  | 4 |  | -8000 |  | Remove one-time budget for electronic records management | -2595040
2 |  | 2 |  | -100000 |  | Decrease amount for legal support for the City's participation in the Portland Harbor Superfund liability allocation process. | -2695040
1.75 |  | 1 |  | -100000 |  | Decrease contract amount for technical assistance in support of the city's participation in the ongoing Portland Harbor liability allocation process. | -2795040
1.75 |  | 2 |  | -600000 |  | Eliminate $600,000 operating budget for repair of  private sewer laterals, moving project to capital. | -3395040
Priority rankings are from 0 (lowest to 4 (highest)
Spreadsheet: aa6c10b2-69a6-428f-ba89-2c487743327a
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
TOXOG | Test | TOXOG | [NAME], IgG, Serum | [NAME], IgG, S | Enzyme-Linked Fluorescence Assay (ELFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <4 IU/mL (negative) 4-7 IU/mL (equivocal) > or =8 IU/mL (positive) | Monday through Saturday; 9 a.m. | Same day/1 day | 2 days | 1 | 86777 |  |  |  |  | Rochester
TOXOG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TOXOG | Result | TOXOG | [NAME], IgG, S | [NAME], IgG, S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 5388-4