tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 189000d1351056891-summing-and-averageing-based-on-criteria-project1a
Sheet: Sheet1

Name | Type | Start Date | Review Date | Completed Date
[NAME] | A | 2012-08-07 00:00:00 | 2012-08-17 00:00:00 | 2012-08-17 00:00:00
[NAME] | A | 2012-08-13 00:00:00 | 2012-08-20 00:00:00 | 2012-09-04 00:00:00
[NAME] | A | 2012-08-15 00:00:00 | 2012-08-21 00:00:00 | 2012-08-21 00:00:00
[NAME] | A | 2012-08-17 00:00:00 | 2012-08-21 00:00:00 | 2012-08-21 00:00:00
[NAME] | B | 2012-08-28 00:00:00 | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
[NAME] | B | 2012-08-30 00:00:00 | 2012-09-05 00:00:00 | 2012-09-05 00:00:00
[NAME] | A | 2012-08-31 00:00:00 | 2012-09-06 00:00:00 | 2012-09-06 00:00:00
[NAME] | B | 2012-08-14 00:00:00 | 2012-08-20 00:00:00 | 2012-08-20 00:00:00
[NAME] | A | 2012-08-27 00:00:00 | 2012-08-29 00:00:00 | 2012-08-29 00:00:00
Name | Type | Start Date | Ave Review Date (Days) | Ave [NAME] (days)
[NAME] | A | 2012-08-01 00:00:00
[NAME] | A | 2012-08-01 00:00:00
Name | Type | Start Date | Ave Review Date (Days) | Ave [NAME] (days)
[NAME] | B | 2012-08-01 00:00:00
[NAME] | B | 2012-08-01 00:00:00
Spreadsheet: 795380d1662651797-how-to-sum-multiple-datedifs-example-tracker-2
Sheet: Employer

Start Date | End Date | Duration | Discipline
2008-03-03 00:00:00 | 2009-07-31 00:00:00 |  | Quality Assurance
2008-09-01 00:00:00 | 2009-04-30 00:00:00 |  | Technical Writing
2009-10-01 00:00:00 | 2009-12-25 00:00:00 |  | Quality Assurance
2010-01-21 00:00:00 | 2010-08-18 00:00:00 |  | Quality Assurance
2010-09-01 00:00:00 | 2014-07-31 00:00:00 |  | Business Analysis
2013-08-01 00:00:00 | 2013-10-31 00:00:00 |  | Consultancy
2014-10-01 00:00:00 | 2014-12-26 00:00:00 |  | Project Management
2015-01-07 00:00:00 | 2017-08-31 00:00:00 |  | Business Analysis
2017-09-01 00:00:00 | 2019-09-30 00:00:00 |  | Product Management
2019-10-02 00:00:00 | 2021-06-30 00:00:00 |  | Product Management
2021-07-05 00:00:00 | 2021-12-31 00:00:00 |  | Product Management
2022-01-03 00:00:00 |  |  | Product Management
Spreadsheet: 0e1d07a1-2fe1-42c9-b37f-0e8cd4ff2a9d
Sheet: Sheet1

Loyola Marymount University | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mileage Reimbursement Request
Name :
Address :
When a privately owned vehicle or a university owned vehicle is used for University business, reimbursement will be in accordance with the IRS code.
If the total mileage traveled is less than your regular daily commute then none of your miles are reimbursable. If the total mileage traveled for that day
is more than your daily commute, you will be reimbursed for the additional miles driven.
Date | Purpose/Description |  | Starting Point (Address) | Destination Address | [NAME] | Rate | Reimbursement
 |  |  |  |  |  | 0.555 | 0
 |  |  |  |  |  | 0.555 | 0
 |  |  |  |  |  | 0.555 | 0
 |  |  |  |  |  | 0.555 | 0
 |  |  |  |  |  | 0.555 | 0
 |  |  |  |  |  | 0.555 | 0
 |  |  |  |  |  | 0.555 | 0
 |  |  |  | Total Page 1: | 0 | 0.555 | 0
 |  |  |  | Total Reimbursement (all pages): | 0 |  | 0 |  | check | 0
I certify that the mileage shown on this form was incurred by me on official university business on the dates shown and no part was for personal business.
Employee Signature   : |  |  | Check Mail       :
 |  |  | Direct Deposit       :
Account #   :
Supervisor Approval   : |  |  | Date       :
Spreadsheet: 271081d1381815610-help-need-a-formula-to-calculate-due-date-but-exclude-weekends-if-due-date-falls-on-it-due-date-sample
Sheet: Stat Holidays

Holidays
2013-10-14 00:00:00
2013-12-25 00:00:00
2013-12-26 00:00:00
2014-01-01 00:00:00
2014-02-17 00:00:00
2014-04-18 00:00:00
2014-05-19 00:00:00
2014-07-01 00:00:00
2014-08-04 00:00:00
2014-09-01 00:00:00
2014-10-13 00:00:00
2014-12-25 00:00:00
2014-12-26 00:00:00
2015-01-01 00:00:00
2015-02-16 00:00:00
2015-04-03 00:00:00
2015-05-18 00:00:00
2015-07-01 00:00:00
2015-08-03 00:00:00
2015-09-07 00:00:00
2015-10-12 00:00:00
2015-12-25 00:00:00
2015-12-26 00:00:00
Spreadsheet: 682725d1592301500-new-function-filter-dispaly-horizzontally-test
Sheet: Foglio1

List |  |  | Unique | Result
Student1 | V10 |  |  | V10
Student2 | V15 |  | Student2 | V15 | V63
Student2 | V63 |  | Student3 | V45 | v48
Student3 | V45 |  | Student9 | v47 | V46
Student9 | v47
Student3 | v48
Student9 | V46
Spreadsheet: 795392d1662654056-amalgamating-and-deleting-rows-gk-special-assistance-final
Sheet: Result

Passenger Assist List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-04 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Assigned To | Name | HIP | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments
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
Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: RO Costs

 | Exchange rate date | April 2011 |  |  | Type of setting in allowance
 | Exchange rate [NAME] vs. EUR | 0.24099 |  |  | single
 |  |  |  |  | couple
 |  | EUR | EUR |  | Relocation costs |  | Price/unit | Units | Total
 | 1550000   SALARIES |  | 0 |  | Setting in allowance | single | 2000 | 1 | 2000
 | 1551008   SALARIES - PRO RATA |  | 0 |  | Setting in allowance | couple | 3000 | 1 | 3000
 | 1557800   ONE-OFF PAYMENTS SALARIED EMPLOYEES |  | 0 |  | Setting in allowance - children |  | 800 | 2 | 1600
 | *          0630 personnel (salary earner) | 2042729 | 492277.26171 |  | Flight costs |  | 300 | 4 | 1200
 | 1581000   STATUTORY SOCIAL EXPENSE EMPLOYEE |  | 0 |  | Transport goods |  | 300 | 1 | 300
 | *          0640 social contributions (salary earner | 1194116.89 | 287770.2293211 |  | Relocation days off |  | 2560.44780585 | 3 | 7681.343417550001
 | 1580500   STATUTORY SOCIAL EXPENSE OTHERS |  | 0 |  | Free assistance |  | 1000 | 1 | 1000
 | 1591700   COMPANY DOCTORS AND THEIR SUBSTITUTES |  | 0 |  | Housing allowance manager |  | 2400 | 3 | 7200
 | 1595000   VOLUNTARY FRINGE BENEFITS |  | 0 |  | Housing allowance emp. |  | 1200 | 10 | 12000
 | *          0650 personnel other costs | 103355.5 | 24907.641945 |  | Total |  |  |  | 35981.34341755
 | **         0660 direct personnel expenses |  | 0
 | 1564000   CONTRIBUTION PLAN FOR PENSION FUND |  | 0
 | *          0680 pension plan contribution |  | 0
 | **         0700 pensions |  | 0
 | ***        0760 social expenses | 7703.22 | 1856.3989878
 | ****       0765 TM1: personnel expenses |  | 0
 | 1750500   TRAVEL EXPENSES/PER DIEM ALLOWANCES EMPL |  | 0
 | 1750600   TRAVEL EXPENSES/PER DIEM ALLOW. EMPLOYEE |  | 0
 | *          0780 TM1: travel expenses | 257166.63 | 61974.58616370001
 | 1753100   COURSES, SEMINARS AND MEETINGS EMPLOYEES |  | 0
 | *          0790 TM1:trainings | 783252.54 | 188756.0296146
 | 1767000   PROVISION OF PERSONNEL |  | 0
 | *          0800 temporary leased personnel |  | 0
 | Total personal costs other than salaries |  |  | 565264.8860322
 | *          IT expenses | 3534266.66 | 851722.9223934001
 | *          1180 TM1: communication | 223095.6 | 53763.808644
Spreadsheet: 734794d1622489624-lookup-value-in-one-sheet-against-another-along-rows-and-return-another-value-lookup-issue
Sheet: Progress

Test Case ID | [NAME] | [NAME] | [NAME]
TS-01-01
AC074
AC058
TS-01-02
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 132615d1323858483-cannot-copy-formula-to-below-cell-with-numerical-increase-in-increments-of-1-book3
Sheet: Sheet2

 | REF | VESSEL | GT | NT | SDWT | LOA | BEAM | IMO | CALL SIGN | MMSI | PORT | BERTH | CARGO | CARGO ID | QUANTITY | LAST PORT | NEXT PORT
 | 8100 | FOYNES LADY | 1233 | 1255 | 1800 | 129 | 15 | 922155 | EI125 | E22566 | AUGHINISH | INNER | ALUMINA | 11210 | 1800 | BLYTH | DUNKIRK
Spreadsheet: 50288d1249655767-offset-match-question-offset-question-for-upload
Sheet: Discounts

code | AA Code | desc | Standard Discount | X Corp | Y Corp | Z Corp
zz | PE | xx | 0.15
zz | PC | xx | 0.15
zz | PJ | xx | 0.15
zz | PM | xx | 0.15
zz | PH | xx | 0.15 |  | 0.01
zz | PK | xx | 0.15 |  | 0.02
zz | PO | xx | 0.15 |  | 0.03
zz | PI | xx | 0.15 | 0.14 | 0.04
zz | PL | xx | 0.15 |  | 0.05
zz | PP | xx | 0.15 | 0.14 | 0.06 | 0.05
zz | PS | xx | 0.15 |  | 0.07 | 0.06
zz | PT | xx | 0.15 |  | 0.08 | 0.07
zz | PU | xx | 0.15 |  | 0.09 | 0.08
zz | PD | xx | 0.15 | 0.14 | 0.1 | 0.09
zz | PN | xx | 0.15 |  | 0.11 | 0.1
zz | PQ | xx | 0.2 | 0.14 | 0.12 | 0.11
zz | ZO | xx | 0.2 |  | 0.13 | 0.12
zz | JJ | xx | 0.2 |  | 0.14 | 0.13
zz | A2 | xx | 0.2 |  | 0.15 | 0.14
zz | DC | xx | 0.2 |  |  | 0.15
zz | EB | xx | 0.2 |  |  | 0.16
zz | OE | xx | 0.2 |  |  | 0.17
zz | OP | xx | 0.2 | 0.14 |  | 0.18
zz | RJ | xx | 0.2 |  |  | 0.19
zz | RK | xx | 0.2 |  |  | 0.2
zz | ZC | xx | 0.2 |  |  | 0.21
zz | ZP | xx | 0.2 | 0.14 |  | 0.22
zz | ZS | xx | 0.2
zz | ZZ | xx | 0.2
zz | TR | xx | 0.2
zz | ZN | xx | 0.2 | 0.14
zz | QW | xx | 0.2
zz | HT | xx | 0.2
zz | IR | xx | 0.2 | 0.14
zz | NH | xx | 0.2
zz | NL | xx | 0.2
zz | QO | xx | 0.2
zz | A3 | xx | 0.2
zz | CL | xx | 0.2
zz | CR | xx | 0.2
zz | DA | xx | 0.2
zz | DB | xx | 0.2
zz | DL | xx | 0.2
zz | DP | xx | 0.2
zz | DR | xx | 0.2
zz | DS | xx | 0.2
zz | P3 | xx | 0.2
zz | PA | xx | 0.3
zz | QQ | xx | 0.3
zz | QR | xx | 0.3
zz | QS | xx | 0.3
zz | RB | xx | 0.3
zz | RC | xx | 0.3
zz | RF | xx | 0.3
zz | DE | xx | 0.3
zz | S1 | xx | 0.3
zz | UE | xx | 0.3
zz | YM | xx | 0.3
zz | UT | xx | 0.3
zz | W1 | xx | 0.3
zz | [NAME] | xx | 0.3
zz | A1 | xx | 0.3 | 0.185
zz | DU | xx | 0.3
zz | IE | xx | 0.3 | 0.195
zz | IG | xx | 0.3 | 0.185
zz | IH | xx | 0.3
zz | IY | xx | 0.3
zz | IZ | xx | 0.3
zz | OZ | xx | 0.3
zz | QM | xx | 0.3
zz | U2 | xx | 0.3 | 0.185
zz | U3 | xx | 0.3 | 0.185
zz | QA | xx | 0.3 | 0.26
Spreadsheet: 62926d1263913906-conditional-count-jan2010-job-attendance-template-matejabg
Sheet: validation list

Kategorija | RRD | VK | DP |  | Data validation for each type of day
RRD | SD | SD | DP |  | Category
VK | GO | NI | BO |  | RRD | workday
DP | PO | 1 | NO |  | VK | weekend
 | BO | 2 | NZ |  | DP | state holiday
 | NO | 3 | 1
 | NI | 4 | 2 |  | when you manually setup each day type for a specific month, formulas will be able to process data correctly
 | SO | 5 | 3
 | NZ | 6 | 4 |  | each day type has a set of data available for entry (explained in legend)
 | 1 | 7 | 5
 | 2 | 8 | 6
 | 3 | 9 | 7
 | 4 | 10 | 8
 | 5 | 11 | 9
 | 6 | 12 | 10
 | 7 |  | 11
 | 8 |  | 12
 | 9
 | 10
 | 11
 | 12
Spreadsheet: 42237d1240844358-vlookup-problem-hlookup
Sheet: Sheet2

1101 | 14211
1101 | 14541
1101 | 14857
1101 | 16957
1201 | 65124
1201 | 78412
1201 | 12458
1201 | 19874
1301 | 12457
1301 | 12458
Spreadsheet: 04584237-72d7-46d0-8bbf-1acd333858be
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TRAVEL MILEAGE LOG | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
EMPLOYEE'S NAME (Last, First, M.I.) |  |  |  | EMPL ID # |  | TA/TP#
 |  |  |  |  |  | ODOMETER
DATE |  | ADDRESS DEPARTED FROM | TIME | ADDRESS ARRIVED AT | TIME | START | END | [NAME]
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
 | Place: |  |  |  |  |  |  | 0
 | Address:
 | City:
TR Travel Mileage Log 58.doc  10/24/08 |  |  |  |  |  | Total Miles |  | 0
 |  |  |  |  |  | Mileage | Rate | 0.445
 |  |  |  |  |  | Total Reimbursement |  | 0
Spreadsheet: 680471d1591038564-sumifs-calculation-for-cumulative-annual-wages-sample-file-1
Sheet: Taxes

 | Year | Month | Monthly After Deductions | Cum Annual After Deductions | Annual Rate | Monthly Rate | Tax | NI | SLC | Pension | Total Deductions |  | Tax | NI
 | 2019 | 11 |  |  | 20000 |  |  |  |  |  |  |  | 124.9833333333333 | 104.96
 | 2019 | 12 |  |  | 22000 |  |  |  |  |  |  |  | 158.3166666666667 | 124.96
 | 2020 | 1 |  |  | 22000 |  |  |  |  |  |  |  | 158.3166666666667 | 124.96
 | 2020 | 2 |  |  | 24000 |  |  |  |  |  |  |  | 191.65 | 144.96
 | 2020 | 3 |  |  | 24000 |  |  |  |  |  |  |  | 191.65 | 144.96
 | 2020 | 4 |  |  | 26000 |  |  |  |  |  |  |  | 224.9833333333333 | 164.96
 | 2020 | 5 |  |  | 28000 |  |  |  |  |  |  |  | 258.3166666666667 | 184.96
Spreadsheet: 526078d1499105024-training-tracker-sample
Sheet: Sheet1

# | Staff ID | Name | Designation | Date Completed | Renewal Date | Status | Remarks
1 | 147623 | Dr. [NAME] VARREY (AMD) | SPECIALIST GYNAECOLOGIST | 2015-07-08 00:00:00 | 2017-07-08 00:00:00 |  |  |  | Summary
2 | 156677 | Dr. [NAME] (BM) | SPECIALIST ENT SURGEON | 2017-05-26 00:00:00 | 2019-05-26 00:00:00 |  |  |  | Expiring soon
3 | 177259 | Dr. [NAME] TOLENTINO | GENERAL PRACTITIONER |  |  |  | Scheduled July 14 |  | Expired
4 | 155707 | Ms. [NAME] LOSENTES RIVERA | NURSE | 2015-06-05 00:00:00 | 2017-06-06 00:00:00 |  | Scheduled July 14 |  | Valid
5 | 176825 | Mrs. BINCY ALYAS | NURSE |  |  |  | Scheduled July 14 |  | No record
6 | 300253 | Ms. [NAME] ANDREMAE FALABI CABASE | NURSE |  |  |  | Scheduled July 14
7 | 156675 | Mrs. [NAME] LOBO | LAB TECHNICIAN |  |  |  | Scheduled July 14 |  | Total Staff
8 | 300471 | Mr. [NAME] JOHN [NAME] | RADIOGRAPHER
9 | 168336 | Mr. [NAME] CHALIKANDY PEEDIKAY | INCHARGE PHARMACIST
Spreadsheet: 60214d1260788177-adding-values-reference-to-date-today-sumifdate
Sheet: Sheet1

name | 2009-12-11 00:00:00 | 2009-12-12 00:00:00 | 2009-12-13 00:00:00 | 2009-12-14 00:00:00 | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-17 00:00:00 | total
[NAME] | 3 | 2 | 0 | 1 | 10 | 5 | 8 | 5
[NAME] | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Spreadsheet: 184031d1349116603-how-to-populate-calendar-dates_reply
Sheet: calendar (2)

48
COMPANY 1
COMPANY 2
COMPANY 3
COMPANY 4
COMPANY 5
Spreadsheet: 47969d1247149261-conditional-formatting-borders-tomme
Sheet: Rota

 |  |  | Monday |  |  | M Tot | Tuesday |  |  | T Tot | Wednesday |  |  | W Tot | Thursday |  |  | T Tot | Friday |  |  | F Tot | Saturday |  |  | S Tot | Sunday |  |  | S Tot | Total | Total | Contract
 |  |  | Start | Break | Finish | Start | Start | Break | Finish | Break | Start | Break | Finish | Finish | Start | Break | Finish | Start | Start | Break | Finish | Break | Start | Break | Finish | Finish | Start | Break | Finish | Start
 |  |  | 11 | 1 | 20 |  | 12 | 1 | 20 |  |  |  |  |  | 12 | 1 | 16 |  |  |  |  |  |  |  |  |  | 1 | 1 | 23
 |  |  | 1 | 1 | 8 |  | 8 | 1 | 14 |  | 12 | 1 | 20 |  |  |  |  |  | 12 | 1 | 20 |  | 12 | 1 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 15 |  |  |  |  |  | 0 |  | 28
 |  |  | 12 | 1 | 14 |  | 15 | 1 | 22 |  | 20 | 1 | 23 |  | 23 |  | 24 |  | 0 | 1 | 14 |  | 0 |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 14
 |  |  | 0 | 1 | 11
 |  |  |  |  |  |  | 13 | 0.5 | 16
Spreadsheet: 766533d1643923200-formula-to-copy-over-data-new-haddo-formula
Sheet: Other

 |  |  |  |  |  | SEPTIC |  |  | MINOR
 |  |  | OFFICE |  | REFUSE | TANK | CLEANING | SANITARY | OFFICE |  | MINOR |  | STAFF
QTR | Date | Po | CLEANING | LAUNDRY | COLLECTION | COSTS | CONSUMABLES | CONSUMABLES | EQUIPMENT | STATIONARY | CONSUMABLES | LICENCES | UNIFORMS
Spreadsheet: 4457b6ff-427f-40cf-8047-3fb7abd79904
Sheet: Specific Room Request Form

Specific Classroom Request Form
Revised 10/2014
Instructions
1.  [NAME] in today's date, the term for which this request applies, your department and your name.
2.  Requests will be considered for classes meeting during standard meeting patterns only (see Standard Meeting Patterns tab).
3.  Acceptable reasons for the request: features unique to that classroom (indicate), instructor's physical limitation, classes that will be taught back-to-back (instructor needs to be listed in ISIS), proximity to other rooms in the bldg.
4.  We consider what is in ISIS to be official days/times the class will be offered, not what is entered on this sheet, and will assign a classroom accordingly.
5.  Any room assignments viewed in ISIS are subject to change until the listed timeline date.
6.  Dept. Chair Approval: Have your department chair enter his/her name and date.
7.  Forward to your [NAME] for approval.
8.  DEPARTMENT CHAIR: Please email to [NAME] as an attachment ([EMAIL] or [EMAIL]) by the timeline deadline.
Date:
Term:
Department:
Submitted By:
Dept. Chair Approval & Date:
Dean's Approval & Date:
DEPT. / COURSE NO. / SECTION NO. | DAYS | START/END TIME | REQUESTED ROOM | ESTIMATED ENROLLMENT | REASON FOR THIS SPECIFIC ROOM REQUEST
EXAMPLES:
ANTH 1000-001 | MWF | 8:00-8:50 | HALE 236 | 20 | Needs access to arch lab for demos
EBIO 2000-001 | TTH | 8:00-9:15 | RAMY N1B75 | 20 | Back-to-back class for instructor
EBIO 4000-001 | TTH | 9:30-10:45 | RAMY N1B75 | 20 | Back-to-back class for instructor
Spreadsheet: 121547d1316136484-how-do-i-automatically-attach-data-to-terms-i-copy-into-excel-stats
Sheet: Batting

** DO NOT TYPE IN ANY CELL THAT HAS BLACK TEXT, THESE WILL BE AUTOMATICALLY CALCULATED
# | Name | PA | AB | H | 1b | 2b | 3b | HR | ROE | HBP | SACf | SACb | BB | BB% | Ks | [NAME] | RBI | RUNS | BA | [NAME] | Slug% | SB | SBA | SB% | SBR
3 | Player 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0.5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
32 | Player 2 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0.5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
2 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
31 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
44 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 | Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Team Totals | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 4 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0
 |  | DEFINITIONS:
Baseball Almanac |  | PA | Plate Appearances |  |  |  | BB% |  | Base on Balls Percentage |  |  |  | ROE |  | Reached base on Error
www.baseball-almanac.com |  | AB | At Bats |  |  |  | [NAME] |  | Strikeout Ratio |  |  |  | BB |  | Walks |  |  |  |  | Slug% | Slugging Percentage
Copyright © 2003 Sean Holtz |  | H | Hits |  |  |  | SBR |  | [NAME] |  |  |  | Ks |  | [NAME] |  |  |  |  | SB | Stolen Bases
 |  | 1b | Singles |  |  |  |  |  |  |  |  |  | RBI |  | Runs Batted In |  |  |  |  | SBA | [NAME]
 |  | 2b | Doubles |  |  |  |  |  |  |  |  |  | RUNS |  | Runs |  |  |  |  | SB% | [NAME] Average
 |  | 3b | Triples |  |  |  |  |  |  |  |  |  | BA |  | Batting Average
 |  | HR | Home Runs |  |  |  |  |  |  |  |  |  | [NAME] |  | On Base Percentage
Spreadsheet: 102444d1300376190-how-to-count-across-multiple-rows-sample-workbook
Sheet: Sheet1

Service Line | Annual Revenue | Q1 | Q2 | Q3 | Q4
Checking Account | 4000 | 1000 | 2000 | 50 | 950
Savings Account | 3490 | 3000 | 0 | 0 | 490
IRA | 12000 | 10000 | 1000 | 0 | 1000
Checking Account | 4000 | 1000 | 2000 | 50 | 950
Savings Account | 3490 | 3000 | 0 | 0 | 490
IRA | 12000 | 10000 | 1000 | 0 | 1000
Checking Account | 4000 | 1000 | 2000 | 50 | 950
Savings Account | 3490 | 3000 | 0 | 0 | 490
IRA | 12000 | 10000 | 1000 | 0 | 1000
Summary | Annual Revenue | Q1 | Q2 | Q3 | Q4
Checking Account
Savings Account
IRA
Spreadsheet: 0a78c6e6-5558-408c-b205-94423f41316d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | CATEGORY: | Hydrology |  | Habitat | Thermal | Pathogens | Organics, Mercury, Solids, Total Metals | Nutrients | Dissolved Metals
 |  | INDICATOR (Main Surrogates): | Flow | Volume | Aquatic and Terrestrial Improvement | Temperature | E Coli | TSS | Total Phosphrus | Dissolved Zinc
 |  | ACTIONS
STRATEGIES | STORMWATER MANAGEMENT | 1. Increase infiltration | X | X
 |  | 2. Increase retention or detention of stormwater | X | X
 |  | 3. Treat stormwater pollutants |  |  |  | X | X | X | X | X
 |  | 4. Separate flow from combined storm/sanitary sewer | X | X
 | REVEGETATION | 5. Increase vegetative cover |  |  | X | X
 |  | 6. Improve vegetative cover |  |  | X | X
 | AQUATIC AND TERRESTRIAL ENHANCEMENT | 7. Restore channel and floodplain function | X | X | X | X
 |  | 8. Restore or create habitat structure and function | X | X | X | X
 |  | 9. Restore habitat connectivity and access | X |  | X
 |  | 10. Manage for appropriate native species |  |  | X
 | PROTECTION AND POLICY | 11. Implement management of pollutant discharge from construction sites |  |  |  |  |  | X | X | X
 |  | 12. Implement management of stormwater for all new and redevelopment projects | X | X |  | X |  | X | X
 |  | 13. Implement management of pollutant discharge for industrial and commercial sites |  |  |  |  |  | X |  | X
 |  | 14. Protect sites and features with high watershed value | X | X |  | X
 | OPERATIONS AND [NAME] | 15. Operate and maintain city facilities and infrastructure to remove and prevent pollutant discharges |  |  |  |  | X | X | X | X
 |  | 16. Reduce illicit and non-stormwater discharges |  |  |  |  | X | X | X | X
 |  | 17. Maintain and repair sewer systems to ensure conveyance | X |  |  |  | X | X | X | X
 | EDUCATION, INVOLVEMENT, AND STEWRDSHIP | 18. Provide education and assistance to prevent pollution |  |  |  | X | X | X | X | X
 |  | 19. Provide education, involvement, and stewardship on pollution prevention |  |  |  | X | X | X | X | X
 |  | 20. Provide education, involvement, and stewardship on watershed function | X | X | X | X | X | X | X | X
Spreadsheet: 707084d1607023249-formula-for-budgeting-from-lowest-cost-unit-pollution-removal
Sheet: Sheet1

 | 2020
Budget | 400 | 500 | 600 | 700 | 800
 |  |  | Polution unit removed
Location | Total polution unit | Cost for removing 1 unit of polution | 2020
a | 300 | 3
b | 100 | 2
c | 150 | 1
d | 200 | 4
e | 250 | 5
Budget spent