tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 09a1d105-3264-45b6-921f-d5c819021aa5
Sheet: Finance June 11

TATSFIELD PARISH COUNCIL |  |  |  |  | 11/66
 |  | APPENDIX B |  | Oct 2011
Expenditure to be authorised:-
Payee | Description |  | Nett | VAT | Total | chq
Mrs A Hughes | Salary | Sept | 685.46
 | Telephone | Sept | 3.5
 | Postage | Sept | 5.52
 | Mileage / travel | Sept | 24.4
 | Purchases : keys | Sept | 21
 |  |  |  |  |  | 797
M Lambert | Car park / TCGA maintenance + materials | Sept | 84 | 0 |  | 798 | includes £16 for painting materials for TCGA storage box
Goldservice Cleaners | Clean of AMB | Sept | 104 |  |  | 799
T Dawkins | Outstanding fees ref Maint Project | May - Sept | 3976 |  |  | 800 | this will be coming off the total amount owed by the PC to ABW
T Dawkins | Building Regs payment | Sept | 100 |  | 120 | 800 | payment re windows
DH Reeves | Outstanding work for Maint Project | Sept | 2730 |  |  | 801 | this will be coming off the total amount owed by the PC to ABW
[NAME] | Travel / parking expenses | Sept | 62 | 0 | 62 | 802
HMRC | Quarter 2 PAYE/NI | July - Sept | 106.74 | 0 |  | 803
[NAME] | TIB | Sept | 168.6 |  |  | 804
P Kerry | Expenses for NALC Conference | Sept | 23 | 0 |  | 805
P Kerry | Co2 alarm | Sept | 22.75 |  |  | 805
Land Registry | [NAME] | Sept | 40 | 0 |  | 796
TVSC | annual membership | Sept | 10 | 0 |  | 806
Whelan Homes | Allotments rental | Sept | 882.19 | 0 |  | 807
BDO | Annual Audit | Sept | 400 |  |  | 808
[NAME] | SVOTY expenses for hosting | Sept | 45.16 | 0 | 45.16 | 809
Kells Electrical | Timer on hot water cylinder | Sept | 45.15 |  |  | 810
 | TOTALS
Paid by Direct Debit
E.On Energy | [NAME] for May-Sept | Sept | 28.56
Thames Water | Water bill | Sept | 27.62
EDF Energy | Electricity bill - Aileen McHugo Building | Sept | 27.62 |  |  |  | this was increased at my request as our previous bill had accrued a debit balance.
TDC | Rates for ground floor | Sept | 80
 | TOTALS
Receipts since last meeting:
TDC | 2nd Precept Payment | Sept | 16500
S [NAME] | Payment for hire of TCGA + key deposiot | Sept | 172
Kestrell Childrens Services | Rental on TCGA room until March 2012 | Sept | 380
E.On Energy | Refund for credit balance | Sept | 35.72 |  | 35.72
 | Total Receipts
 | Balance
Balances at HSBC Bank
2011-09-30 00:00:00 | Current Account | ***** | 14640.29
 | Deposit Account No | **** | 18909.64
 | **** includes interest for | Sept | 1.12
Spreadsheet: 781227d1653068267-toc-that-notifies-if-todays-date-occurs-in-any-other-wkbk-sheets-01-attorney-tracking-template-forum
Sheet: Research

email | fp_id | first_name | middle_name | last_name | title | firm | location | phone | bar_admissions | practice_areas | specialties | law_school | graduation_year | undergraduate | advanced_degree | raw_education | languages | profile_url | sectors_primary | jobs_practice_primary | jobs_practice_secondary | degree | leadership_matches | Deposition/Notes | Research Send Date | Follow up 1 | Follow up 2 | Follow up 3 |  |  |  |  |  |  |  | Deposition/Notes
[EMAIL] | 1 | [NAME] | G. | Mcleod | of counsel | Adams And Reese Llp | Alabama-Birmingham | [PHONE] | Alabama, Texas | Litigation | Appellate, Professional Liability | University of Alabama | 2008 | University of Mobile |  | Education University of Alabama School of Law, J.D., 2008 University of Mobile, B.A., 2004 |  | https://www.adamsandreese.com/people/aaron-mcleod | appellate work, trial work | commercial litigation | appellate litigation, personal injury/death litigation, lawyer/firm defense litigation, insurance litigation, professional liability litigation, education/research litigation, real estate litigation |  |  | Geographical Interests: Firm Size Interests: Partnership Interests: Practice-based Interests: Remote Work Interests:  Notes: | 2022-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | Geographical Interests: Firm Size Interests: Partnership Interests: Practice-based Interests: Remote Work Interests:  Notes:
Spreadsheet: 451307c4-5183-40b4-81d4-765353dcdee2
Sheet: Sheet1

"Pompeii - Az eltemetett város" - levelező-pályázat | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Jelentkezési lap (Kérjük, vegye figyelembe, hogy a dokumentum kétoldalas!)
Az iskola neve:
Címe:
Megye:
Telefonszáma: |  |  |  |  | Faxszáma:
Csapat neve:
A munkát irányító tanár neve:
Szakja(i):
E-mail cím (kérjük, mindenképpen adjon meg érvényes e-mail címet, mert a pályázattal [NAME] csak ezen az úton juthat hozzá):
Telefonszáma (otthoni vagy mobil):
Honnan értesültek pályázatunkról?
Résztvevő gyerekek neve |  |  |  |  |  |  |  | Osztálya
Csapat neve:
Név |  |  |  |  |  |  |  | Osztály
Dátum: |  |  |  |  | Aláírás:
Spreadsheet: 0eb76dc4-6453-4ce0-a89b-3f4c79d3606f
Sheet: Table I.16

Table I.16 الجدول
Selected Water Quality Indicators in Iraq
مؤشرات مختارة لقياس نوعيّة الموارد المائية في العراق
 | 2008a/ | 2009b/
Concentration of Nitrate in Surface Water in Site 1 (mg/l) | 1077 | … | [NAME] النيترات في المياه السطحية في الموقع 1
Conductivity level of Surface Water in Site 1 (micromhos per centimetre (µmhos/cm) | 0.56 | … | مستوى الموصلية للمياه السطحية في الموقع 1
Total dissolved solids (TDS) in Surface Water in Site 1 (mg/l) | 698 | … | مجموع  [NAME] [NAME] في موقع 1
Concentration of Sulfates of Groundwater in Site 1 (mg/l) | 244 | … | كثافة الكبريتات في المياه الجوفية في الموقع 1
Concentration of Chlorides in Groundwater in Site 1 (mg/l) | 104 | 103 | كثافة الكلوريدات في المياه الجوفية في الموقع 1
Concentration of Calcium in Groundwater in Site 1 (mg/l) | 82 | 80 | كثافة الكالسيوم في المياه الجوفية في الموقع 1
Concentration of Magnesium in Groundwater in Site 1 (mg/l) | 38 | 37 | كثافة المغنيسيوم في المياه الجوفية في الموقع 1
Total Suspended Solids in Groundwater in Site 1 (mg/l) | … | 504 | مجموع المواد الصلبة العالقة في المياه الجوفية في الموقع 1
Sources: | a/ | Environmental Statistics in Iraq Report 2008, COSIT, 2009.
 | [NAME] | Environmental Statistics in Iraq Report 2009, COSIT, 2010.
Spreadsheet: 144931d1331216123-how-to-separate-numbers-from-text-in-a-code-into-a-separate-column-0135_seperate-numbers1
Sheet: Actual Sheet

 |  | CODE |  | Letters | Numbers |  | From Left | From right |  | Enywhere
 |  | 02135AR1234 |  | 0AR1234 | 2135 |  | 2135 | 1234 |  | 21351234
 |  | AR1456 |  | AR | 1456 |  | #N/A | 1456 |  | 1456
 |  | AR1567 |  | AR | 1567 |  | #N/A | 1567 |  | 1567
 |  | QR1342 abc 123 |  | QR abc 123 | 1342 |  | #N/A | 123 |  | 1342123
 |  | 1235 AA 1234 |  | AA 1234 | 1235 |  | 1235 | 1234 |  | 12351234
 |  | BBBB - 233445 |  | BBBB | 233445 |  | #N/A | -233445 |  | 233445
 |  | AASFFHFHGH / 44326788 klo  123 |  | AASFFHFHGH klo 123 | 44326788 |  | #N/A | 123 |  | 44326788123
 |  | 1234ABC |  | ABC | 1234 |  | 1234 | #N/A |  | 1234
Spreadsheet: daren_farmer__5388__HPL-Aug
Sheet: June 00

 |  | Reliant Energy - Entex
 |  | Enron Capital &  Trade/Houston Pipe Line
 |  | MONTHLY NOMINATION SUMMARY
 |  |  | From |  | Month to Date
Gas Flow Day |  | [NAME]. | 2000-08-01 00:00:00 | 1999-09-18 00:00:00
Houston Pipe Line
982000 |  | HPL  Points | 70000
981258 | Industrial Tier 1 & 2 | CHAMPIONS | 0
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon |  |  | 50000
Total  Midcon
NGPL Spring City Gate |  |  | 1000
Total  NGPL
PAYBACK |  |  | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | Contract terminated 07/31/00 | NGMS 308 | 0
016-41991-306 | Trans 6- Silsbee |  | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90
016-41991-311 |  | CNG | 250
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7500
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 2000
016-41991-306 | VA Hospital | VA Hosp | 500
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 500
016-41991-301 | Trans 9 -Woodlands |  | 2000
016-41991-301 | Trans 8 - Conroe |  | 0
Total H/W/C
Transportation
012-41991-204 |  | IT | 10000
012-41991-203 |  | Firm Trsp
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-204 | TEJAS THOMPSONVILLE | 6296 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000
Spreadsheet: a8722103-367c-4cc5-94e2-2320a5fd6052
Sheet: Sheet1

2006-09-12 00:00:00 | GOVERNOR - DEMOCRATIC | Unnamed: 2 | Unnamed: 3
Belknap County | Lynch, d | Coburn, r | [NAME]
Alton | 118 |  | 1
Barnstead | 136 |  | 1
Belmont | 99 |  | 1
Center Harbor | 38
Gilford | 202
Gilmanton | 79
[NAME] | 88
[NAME] | 83
[NAME] 3 | 100
[NAME] | 81 |  | 11
[NAME] | 91
[NAME] 6 | 84 |  | 2
Meredith | 159
New Hampton | 79
Sanbornton | 132 |  | 1
[NAME] | 147
TOTALS | 1716 |  | 17
Carroll County | Lynch, d | Coburn, r | [NAME]
Albany | 30
[NAME] | 177
[NAME] | 35
Chatham | 17
Conway | 312 | 1 | 1
Eaton | 44
[NAME] | 54 |  | 1
Freedom | 52
Hale's Location | 4
Hart's Location
[NAME] | 111 |  | 3
[NAME] | 103
Moultonborough | 90 |  | 1
Ossipee | 137 |  | 2
Sandwich | 143
Tamworth | 189
Tuftonboro | 79
Wakefield | 128
Wolfeboro | 252
TOTALS | 1957 | 1 | 8
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 1021

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OME 1021 |  | Start Date | 24/07/2011 |  |  |  | [NAME]
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | d
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 174874d1345222257-email-alert-for-documents-expiry-expiry-alert
Sheet: Sheet1

sr. no. | name | documents type | issue date | expiry date | email ID | Message | attachment
1 | Employee1 | Passport | 2010-05-01 00:00:00 | 2012-05-12 00:00:00 | [EMAIL] | Hi, Your passport is getting expire on 12-05-12
2 | Employee2 | visa | 2010-05-02 00:00:00 | 2012-05-13 00:00:00 | [EMAIL] | Hi, Your Visa is getting expire on 13-05-12
3 | Employee3 | ID Card | 2010-05-03 00:00:00 | 2012-05-14 00:00:00 | [EMAIL] | Hi, Your ID Card is getting expire on 14-05-12
4 | Employee4 | Driving License | 2010-05-04 00:00:00 | 2012-05-15 00:00:00 | [EMAIL]
5 | Employee5 | ID Card | 2010-05-05 00:00:00 | 2012-05-16 00:00:00 | [EMAIL]
6 | Employee6 | Driving License | 2010-05-06 00:00:00 | 2012-05-17 00:00:00 | [EMAIL]
7 | Employee7 | Passport | 2010-05-07 00:00:00 | 2012-05-18 00:00:00 | [EMAIL]
8 | Employee8 | visa | 2010-05-08 00:00:00 | 2012-05-19 00:00:00 | [EMAIL]
9 | Employee9 | visa | 2010-05-09 00:00:00 | 2012-05-20 00:00:00 | [EMAIL]
10 | Employee10 | Passport | 2010-05-10 00:00:00 | 2012-05-21 00:00:00 | [EMAIL]
11 | Employee11 | Passport | 2010-05-11 00:00:00 | 2012-05-22 00:00:00 | [EMAIL]
12 | Employee12 | Driving License | 2010-05-12 00:00:00 | 2012-05-23 00:00:00 | [EMAIL]
13 | Employee13 | ID Card | 2010-05-13 00:00:00 | 2012-05-24 00:00:00 | [EMAIL]
14 | Employee14 | visa | 2010-05-14 00:00:00 | 2012-05-25 00:00:00 | [EMAIL]
15 | Employee15 | Driving License | 2010-05-15 00:00:00 | 2012-05-26 00:00:00 | [EMAIL]
16 | Employee16 | ID Card | 2010-05-16 00:00:00 | 2012-05-27 00:00:00 | [EMAIL]
Spreadsheet: 707939d1607542483-subtract-from-one-column-until-zero-then-another-than-another-acc1
Sheet: Sheet1

 | Sale |  |  |  |  |  |  |  | Remainder
 | PROJECT | Date | Name | Non-Taxable | Taxable | Tax | Project Total | Paid | Taxable | Non-Taxable | Tax | Balance
 | 1001 | 2020-11-05 00:00:00 | [NAME] | 2500 | 5000 |  |  |  | pay first | pay second | pay third |  | if customer paid this amount
 | 1001 | 2020-11-05 00:00:00 | [NAME] | 2500 | 5000 |  |  | 1500 | 1000 | 5000 | 312.5 |  | 1500
 | 1001 | 2020-11-05 00:00:00 | [NAME] | 2500 | 5000 |  |  | 2500 | 0 | 5000 | 312.5 |  | 2500
 | 1001 | 2020-11-05 00:00:00 | [NAME] | 2500 | 5000 |  |  | 5000 | 0 | 2500 | 312.5 |  | 5000
 | 1001 | 2020-11-05 00:00:00 | [NAME] | 2500 | 5000 |  |  | 7000 | 0 | 500 | 312.5 |  | 7000
 | 1001 | 2020-11-05 00:00:00 | [NAME] | 2500 | 5000 |  |  | 7800 | 0 | 0 | 300 |  | 7800
 | 1001 | 2020-11-05 00:00:00 | [NAME] | 2500 | 5000 |  |  | 2500 | 0 | 0 | 0 |  | 7812.5
Spreadsheet: 329784d1404403229-index-lookup-for-top-10-index-lookup-1-
Sheet: Sheet1

 | Site | Year | product | VS | project id | Savings
 | California | 2013 | 78 | cargo | INT0002 | 1000
 | California | 2013 | other | cargo | INT0014 | 891 |  |  | Wisconsin Top 10
 | California | 2013 | 78 | cargo | INT0026 | 927 |  |  | project id | product | VS | savings
 | Wisconsin | 2013 | 32 | evac | INT0031 | 1868
 | Florida | 2013 | 38 | seats | INT0036 | 2016
 | Wisconsin | 2013 | 78 | cargo | INT0040 | 1868
 | Florida | 2013 | other | cargo | INT0042 | 1905
 | mexico | 2013 | 100 | cargo | INT0043 | 250
 | Wisconsin | 2014 | 78 | light | INT0001 | 500
 | Wisconsin | 2014 | 78 | cargo | INT0004 | 435
 | Florida | 2014 | 78 | cargo | INT0006 | 205
 | Florida | 2014 | 38 | cargo | INT0009 | 33
 | Wisconsin | 2014 | 38 | seats | INT0010 | 267
 | California | 2014 | 78 | cargo | INT0011 | 677
 | Wisconsin | 2014 | 38 | light | INT0013 | 1743
 | Florida | 2014 | other | light | INT0015 | 2209 |  |  | Mexico Top 10
 | California | 2014 | 33 | evac | INT0020 | 952 |  |  | project id | product | VS | savings
 | California | 2014 | 38 | cargo | INT0023 | 396
 | Wisconsin | 2014 | 77 | light | INT0025 | 1738
 | Wisconsin | 2014 | 78 | seats | INT0034 | 1553
 | mexico | 2014 | 100 | seats | INT0044 | 645
 | Florida | 2015 | 78 | light | INT0003 | 204
 | California | 2015 | 38 | cargo | INT0005 | 734
 | Wisconsin | 2015 | other | evac | INT0007 | 1045
 | Wisconsin | 2015 | cross | cargo | INT0016 | 109
 | Wisconsin | 2015 | 38 | evac | INT0019 | 255
 | Florida | 2015 | 47 | cargo | INT0021 | 1908
 | Wisconsin | 2015 | other | cargo | INT0028 | 1382
 | Florida | 2015 | 47 | cargo | INT0033 | 2189
 | California | 2015 | 38 | cargo | INT0035 | 1323 |  |  | 2014 California Top  10
 | Wisconsin | 2015 | 77 | light | INT0037 | 1088 |  |  | project id | product | VS | savings
 | California | 2015 | 78 | cargo | INT0038 | 1575
 | mexico | 2015 | 300 | evac | INT0045 | 2000
 | mexico | 2015 | 47 | seats | INT0046 | 2000
 | California | 2016 | 78 | evac | INT0008 | 2064
 | Florida | 2016 | 78 | seats | INT0012 | 345
 | California | 2016 | 37 | cargo | INT0017 | 995
 | Florida | 2016 | 47 | cargo | INT0018 | 2036
 | Wisconsin | 2016 | 53 | seats | INT0022 | 405
 | Florida | 2016 | 38 | light | INT0027 | 2240
 | Florida | 2016 | 38 | cargo | INT0030 | 1775
 | Florida | 2016 | other | light | INT0039 | 735
 | Florida | 2017 | other | seats | INT0024 | 1064
 | California | 2017 | other | cargo | INT0029 | 496
 | California | 2017 | 34 | evac | INT0032 | 503
 | California | 2017 | other | cargo | INT0041 | 2255
Spreadsheet: 54142d1254161941-excel-2007-irr-function-case09_alslezak_2
Sheet: Cash Flow

NewLeaf Paper
Projected Five Year Cash Flow
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Operating Profit
Depreciation Add Back
Total Cash Inflows
Income Tax
Interest Expense
Debt Payment
Total Cash Outflows
Net Cash Flow
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A95nn54s9462ppp463
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vg!ngzuvf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Al Slezak
Spreadsheet: 1e76d19c-ed99-4dcf-a2c0-23ea0f245280
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
Analysis of TA of class seawater samples
USGS titrator using one point method and spectrophometric method to measure pH
Acid | used acid supplied by [NAME] stated normality 0.100002 N
Replicates | umol/kg
 | 2081.2
 | 2086.9
 | 2086.1
 | 2083.1
 | 2078.8
Avg | 2083.22
SD | 3.015559649377037
RSMAS titrator using modified [NAME] method to estimate equivalence point and glass pH electrode to measure pH
Acid | used acid from home that was standardized against CRM 98 at the meeting c=0.009753 N
Replicates | umol/kg
 | 2091.9
 | 2086.4
Avg | 2089.15
SD | 2.75
Spreadsheet: 12bf1985-ceef-44dc-b430-17db67bb01c4
Sheet: ECC

FY13 FRINGE BENEFIT WORKSHEET - EPA One-Time Payments for Extended Clinical Care Agreements
Name:
Hired Prior to 7/1/96? | Yes | Enter Yes or No
State or Optional Retirement? | Optional | Select State, Optional, or Not Applicable
Description | Object Code | Factor | [NAME] | OTP
One-Time Payment Amount | 1133
BENEFITS
Medicare | 1813
State Retirement | 1822
Optional State Retirement | 187X
Unemployment, workers compensation, etc. | 1892
Transit Tax | 3914
Communication Technologies Core Fee | 3225
Total Benefits
TOTAL COMPENSATION
Notes:
1) SSN Tax may be applicable but not included as most physicians' salaries are over the maximum taxable amount.
Spreadsheet: 163076d1340185103-conditional-formatting-using-a-formula-book1_tolerancetable
Sheet: Sheet1

Check Tol +/- |  | Nominal | Actual |  | Lookup Table | Over (mm) | Tol +/-
0.2 | 0.03999999999999915 | 25 | 25.04 |  |  | 0 | 0.2
0.2 | 0.0799999999999983 | 30 | 30.08 |  |  | 50 | 0.25
0.2 | 0.1199999999999974 | 35 | 35.12 |  |  | 100 | 0.5
0.2 | 0.1599999999999966 | 40 | 40.16 |  |  | 150 | 0.75
0.2 | 0.2000000000000028 | 45 | 45.2 |  |  | 200 | 1
0.25 | 0.240000000000002 | 50 | 50.24 |  |  | 250 | 1.5
0.25 | 0.2800000000000011 | 55 | 55.28
0.25 | 0.1000000000000014 | 60 | 60.1
0.25 | 0.2000000000000028 | 65 | 65.2
0.25 | 0.09999999999999432 | 70 | 69.9
0.25 | 0.06666666666666288 | 75 | 74.93333333333334
0.25 | 0.09999999999999432 | 80 | 80.1
0.25 | 0.2000000000000028 | 85 | 84.8
0.25 | 0.2000000000000028 | 90 | 90.2
0.25 | 0.3333333333333286 | 95 | 94.66666666666667
0.5 | 0.2999999999999972 | 100 | 100.3
0.5 | 0.4666666666666686 | 105 | 104.5333333333333
0.5 | 0.4000000000000057 | 110 | 110.4
0.5 | 0.5999999999999943 | 115 | 114.4
0.5 | 0.5 | 120 | 120.5
0.5 | 0.7333333333333343 | 125 | 124.2666666666667
0.5 | 0.5999999999999943 | 130 | 130.6
0.5 | 0.2666666666666799 | 135 | 134.7333333333333
0.5 | 0.25 | 140 | 140.25
0.5 | 0.4000000000000057 | 145 | 144.6
0.75 | 0.3499999999999943 | 150 | 150.35
0.75 | 0.5333333333333314 | 155 | 154.4666666666667
0.75 | 0.4499999999999886 | 160 | 160.45
0.75 | 0.6666666666666572 | 165 | 164.3333333333333
0.75 | 0.5500000000000114 | 170 | 170.55
0.75 | 0.8000000000000114 | 175 | 174.2
0.75 | 0.6500000000000057 | 180 | 180.65
0.75 | 0.9333333333333371 | 185 | 184.0666666666667
0.75 | 0.75 | 190 | 190.75
0.75 | 1.066666666666663 | 195 | 193.9333333333333
1 | 0.8499999999999943 | 200 | 200.85
1 | 1.199999999999989 | 205 | 203.8
1 | 0.9499999999999886 | 210 | 210.95
1 | 0.4000000000000057 | 215 | 214.6
1 | 1 | 220 | 221
1 | 0.5999999999999943 | 225 | 224.4
1 | 1.400000000000006 | 230 | 231.4
1 | 0.8000000000000114 | 235 | 234.2
1 | 1.800000000000011 | 240 | 241.8
1 | 1 | 245 | 244
1.5 | 2.199999999999989 | 250 | 252.2
1.5 | 0.09999999999999432 | 255 | 254.9
1.5 | 0.3999999999999773 | 260 | 260.4
1.5 | 0.3000000000000114 | 265 | 264.7
1.5 | 0.8000000000000114 | 270 | 270.8
1.5 | 0.5 | 275 | 274.5
1.5 | 1.199999999999989 | 280 | 281.2
1.5 | 0.6999999999999886 | 285 | 284.3
1.5 | 1.600000000000023 | 290 | 291.6
1.5 | 0.8999999999999773 | 295 | 294.1
1.5 | 2 | 300 | 302
1.5 | 1.100000000000023 | 305 | 303.9
1.5 | 2.399999999999977 | 310 | 312.4
1.5 | 1.300000000000011 | 315 | 313.7
Spreadsheet: 790378d1659683604-subtotal-averageifs-that-include-only-visible-rows-filtered-view-test-sheet
Sheet: Sheet1

NO. | INITIATIVE | ELEMENT | PROGRESS (%) | GROUP
1 | Implement 46 types of courses | M | 1 | K1
2 | Offering 1420 scholarships | M | 0.86 | K1
3 | Sponsor 300 students | M | 0.55 | K1
4 | Sponsor 300 students | K | 0.35 | K1
4 | Develop portal | PD3 | 1 | K1
5 | Preparing anti corruption plan | PD4 | 1 | K1
6 | Resolve audit issues | PD4 | 0.1 | K1
7 | Develop and use integrated training platform | PD5 | 1 | J2
8 | Develop and use job portal | PD5 | 1 | J2
9 | Conduct 105 courses | M | 1 | J2
 |  |  |  |  |  | AVERAGE FOR GROUP K1 FOR ELEMENTS M & PD4 (%)
Spreadsheet: 818916d1677126440-sumproduct-formula-to-average-base-on-criteria-average-results
Sheet: Sheet1

Area | Total Points | Desired Results | Employee | applicable points | earned points | Area
OTTAWA |  |  | A | 5 | 0 | ottawa
TORONTO |  |  | B | 5 | 0 | ottawa
Combined |  |  | C | 5 | 5 | ottawa
 | SUMPRODUCT(K10:K20,J10:J20)/SUM(J10:J20) |  | D | 5 | 5 | ottawa
 |  |  | E | 5 | 5 | ottawa
 |  |  | F | 5 | 5 | toronto
 |  |  | G | 5 | 5 | toronto
 |  |  | H | 5 | 5 | toronto
 |  |  | I | 5 | 0 | toronto
 |  |  | J | 5 | 5 | toronto
 |  |  | K | 5 | 5 | toronto
Spreadsheet: 706644d1606818057-sorting-a-list-accordiong-to-total-value-and-variance-book1
Sheet: Sheet1

 | A | 4 | 5 | 3 | 12
 | B | 5 | 4 | 3 | 12
 | C | 4 | 4 | 4 | 12
 | D | 4 | 4 | 4 | 12
 | E | 4 | 4 | 4 | 12
 | F | 4 | 4 | 4 | 12
 | G | 4 | 4 | 4 | 12
 | H | 4 | 4 | 4 | 12
 | I | 4 | 4 | 4 | 12
 | J | 4 | 4 | 4 | 12
 | K | 4 | 4 | 4 | 12
 | L | 4 | 4 | 4 | 12
 | M | 4 | 4 | 4 | 12
 | N | 5 | 4 | 3 | 12
 | O | 5 | 3 | 4 | 12
 | P | 4 | 5 | 3 | 12
 | Q | 4 | 4 | 4 | 12
 | R | 4 | 4 | 4 | 12
 | S | 5 | 4 | 3 | 12
 | T | 5 | 3 | 4 | 12
 | U | 5 | 3 | 4 | 12
 | V | 3 | 5 | 4 | 12
 | W | 4 | 5 | 3 | 12
 | X | 4 | 4 | 4 | 12
 | Y | 4 | 4 | 4 | 12
 | Z | 5 | 4 | 3 | 12
Spreadsheet: 054203f3-9686-46b4-8758-c641871848cb
Sheet: Sheet1

PLANNED ACADEMIC PROGRAM WORKSHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
1.  NAME OF STUDENT (LAST, FIRST, MI) |  |  |  |  |  |  | 2.  [NAME] (BA, BS) |  |  |  |  |  | 3.  AS OF DATE (DAY,MONTH,YEAR)
4 | SEM, YEAR, COURSE NUMBER, COURSE TITLE,COURSE CREDIT HOURS, CREDITS THAT COUNT TOWARDS ACADEMIC DEGREE, AND ACHIEVED GRADES.
 |  | a |  |  |  |  |  | b |  |  |  |  |  | c
 | Term: | Fall 2008 |  | Year: | 2008 |  | Term: | Spring 2009 |  | Year: | 2009 |  | Term: | Fall 2009 |  | Year: | 2009
 | No. | Course Title | Hrs. | Cts. | Grd |  | No. | Course Title | Hrs. | Cts. | Grd |  | No. | Course Title | Hrs. | Cts. | Grd
 |  | Total Sem Hours: | 0 | 0 |  |  |  | Total Sem Hours: | 0 | 0 |  |  |  | Total Sem Hours: | 0 | 0
 |  | d |  |  |  |  |  | e |  |  |  |  |  | f
 | Term: | Spring 2010 |  | Year: | 2010 |  | Term: | Fall 2010 |  | Year: | 2010 |  | Term: | Spring 2011 |  | Year: | 2011
 | No. | Course Title | Hrs. | Cts. | Grd |  | No. | Course Title | Hrs. | Cts. | Grd |  | No. | Course Title | Hrs. | Cts. | Grd
 |  | Total Sem Hours: | 0 | 0 |  |  |  | Total Sem Hours: | 0 | 0 |  |  |  | Total Sem Hours: | 0 | 0
 |  | g |  |  |  |  |  | h |  |  |  |  |  | i
 | Term: | Fall 2011 |  | Year: | 2011 |  | Term: | Spring 2012 |  | Year: | 2012 |  | Term: |  |  | Year:
 | No. | Course Title | Hrs. | Cts. | Grd |  | No. | Course Title | Hrs. | Cts. | Grd |  | No. | Course Title | Hrs. | Cts. | Grd
 |  | Total Sem Hours: | 0 | 0 |  |  |  | Total Sem Hours: | 0 | 0 |  |  |  | Total Sem Hours: | 0 | 0
6.  SIGNATURE OF STUDENT: |  |  |  |  |  |  |  |  |  |  |  |  | 6a.  DATE:
7.  SIGNATURE OF REGISTRAR AND EXAMINER OF CREDENTIALS (OR OTHER INSTITUTION CERTIFYING OFFICIAL). |  |  |  |  |  |  |  |  |  |  |  |  | 7a.  DATE: