tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 177370d1346275972-if-statement-not-functioning-properly-overtime-and-salary-calculator-8225
Sheet: Overtime Calculator

Salary |  | Taxable |  | Tax & National Insurance |  | Net Salary |  | Net Monthly Pay |  | [NAME]
£ | 27000 | £ |  | £ |  | £ |  | £ |  | £
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total OT Financial Year 12-13 |  |  | Hours done This Month
Overtime Hours |  | Rate |  | Equivelant Hours |  | Night Shift |  | Job Ref |  | Sub-Value |  | Date
20 |  | 1 |  |  |  |  |  |  |  | £ |  |  |  |  | April | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  | 35 |  | May | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | June | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | July | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  | 1 |  | August | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  | 1.5 |  | September | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  | 2 |  | October | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | November | 1000
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | Gross Earnings
 |  |  |  |  |  |  |  |  |  | £
 |  |  |  |  |  |  |  |  |  | £
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | Year | Salary | Gross Earnings | Overtime | Total Annual OvertimeHrs
 |  |  |  |  |  |  |  |  |  | £
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | 2010 - 2011
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | 2011 - 2012
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | 2012 - 2013
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | 2013 - 2014
 |  |  |  |  |  |  |  |  |  | £ |  |  |  |  | 2014 - 2015
Gross Overtime |  | Net Overtime @ 20% |  | Net Monthly Pay inc Overtime
£ |  | £ |  | £
40% Bracket |  | Net Overtime @ 40%
 |  | £
Spreadsheet: 763894d1642445321-sum-formula-nested-with-if-and-and-or-book1
Sheet: Sheet1

 |  |  |  |  |  |  | Date | pants | ,<--drop down
Date | Pants | Shirts | Shoes |  |  |  | 2021-01-01 00:00:00
2021-01-01 00:00:00 | 10 | 15 | 45 |  |  |  | 2021-01-02 00:00:00
2021-01-02 00:00:00 | 0 | 0 | 45 |  |  |  | 2021-01-03 00:00:00
2021-01-03 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-04 00:00:00
2021-01-04 00:00:00 | 0 | 15 | 0 |  |  |  | 2021-01-05 00:00:00
2021-01-05 00:00:00 | 15 | 0 | 32 |  |  |  | 2021-01-06 00:00:00
2021-01-06 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-07 00:00:00
2021-01-07 00:00:00 | 0 | 15 | 0 |  |  |  | 2021-01-08 00:00:00
2021-01-08 00:00:00 | 0 | 0 | 16 |  |  |  | 2021-01-09 00:00:00
2021-01-09 00:00:00 | 20 | 0 | 0 |  |  |  | 2021-01-10 00:00:00
2021-01-10 00:00:00 | 0 | 15 | 0 |  |  |  | 2021-01-11 00:00:00
2021-01-11 00:00:00 | 0 | 0 | 17 |  |  |  | 2021-01-12 00:00:00
2021-01-12 00:00:00 | 45 | 0 | 0 |  |  |  | 2021-01-13 00:00:00
2021-01-13 00:00:00 | 0 | 0 | 20 |  |  |  | 2021-01-14 00:00:00
2021-01-14 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-15 00:00:00
2021-01-15 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-16 00:00:00
2021-01-16 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-17 00:00:00
2021-01-17 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-18 00:00:00
2021-01-18 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-19 00:00:00
2021-01-19 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-20 00:00:00
2021-01-20 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-21 00:00:00
2021-01-21 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-22 00:00:00
2021-01-22 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-23 00:00:00
2021-01-23 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-24 00:00:00
2021-01-24 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-25 00:00:00
2021-01-25 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-26 00:00:00
2021-01-26 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-27 00:00:00
2021-01-27 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-28 00:00:00
2021-01-28 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-29 00:00:00
2021-01-29 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-30 00:00:00
2021-01-30 00:00:00 | 0 | 0 | 0 |  |  |  | 2021-01-31 00:00:00
2021-01-31 00:00:00 | 0 | 0 | 0
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 8b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 87 | 6 | 18 | 8 | 4 | 2 | 6 | 131
Cap/Floor | 59 | 12 | 11 | 0 | 0 | 4 | 3 | 89
Debt Option | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Exotic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed-Fixed | 1 | 0 | 0 | 4 | 0 | 0 | 14 | 19
Fixed-Float | 7502 | 2109 | 878 | 1630 | 351 | 435 | 1342 | 14247
FRA | 113 | 1065 | 63 | 0 | 103 | 3 | 138 | 1485
Inflation | 58 | 54 | 11 | 0 | 1 | 0 | 0 | 124
OIS | 35 | 67 | 6 | 0 | 33 | 12 | 79 | 232
Swaption | 446 | 204 | 43 | 63 | 9 | 5 | 38 | 808
TOTAL
Spreadsheet: 158dcaf3-d4a8-4c40-944d-f2083a2c8688
Sheet: ACTUAL EXP

CITY OF PORTLAND
FY 11/12 GENERAL FUND OVERHEAD "TRUE-UP"
BASED ON ACTUAL EXPENDITURES
USING FY 11/12 DATA
0.99
 |  |  | BUREAU COST CATEGORIES
 |  |  |  |  |  | ALLOCABLE
 |  |  | TOTAL | INTERNAL | OUTSIDE | OVERHEAD
 | COST CENTERS |  | EXPENSE | REVENUE | REVENUE | COSTS
ATTORNEY
 | AT Office of City Attorney |  |  | 0 | 0
AUDITOR
 | AUDA000001 Management |  |  | 0 | 0
 | AUCA000002 Ind Police Review |  | 0 | 0 | 0
 | AUDA000002 Council/Contracts |  | 0 | 0 | 0
 | AUDA000004 Assmts/Fin/Foreclose |  | 0 | 0 | 0
 | AUCA000003 Progress Board |  | 0 | 0 | 0
 | AUCA000005 Hearings Officer |  | 0 | 0 | 0
 | Public involvement best practices |  |  | 0 | 0
 | AUCA000004 Ombudsman Office |  | 0 | 0 | 0
 | AUCA000006 City Auditor |  | 0 | 0 | 0
AUDIT SERVICES
 | LAAUAU00000000GL |  | 0 | 0 | 0
 | [NAME] |  | 0 | 0 | 0
 | RECORDS MANAGERMENT |  | 0 | 0 | 0
 | AUDA000003 Archives & Records |  | 0 | 0 | 0
CITY COUNCIL
 | PW Commissioner of Public Works |  |  | 0 | 0
 | PS Commissioner of Public Safety |  |  | 0 | 0
 | PA Commissioner of Public Affairs |  |  | 0
 | PU Commissioner of Public Utilities |  |  | 0 | 0
 | MY Office of the Mayor |  |  | 0 | 0
 | GR Office of Governmental Relations |  |  | 0 | 0
PLANNING
 | Comprehensive Planning |  |  | 0 | 0
 | Governmental Coordination |  |  | 0 | 0
 | District Planning CAPD10000 |  |  | 0 | 0
ONI
 | NIIR Information & Referral |  |  | 0
PURCHASING
 | MFPU000001 Procurement
 | MFPU000002 Director |  | 0 | 0.25 | 0
 | MFPU000003 Outside Services |  |  | 0
 | Minority Evaluator position |  |  | 0 | 0
 | MFIB - MFOP000071 |  | 0 | 0 | 0
OMF
 | MFDR000001 CAO
 | MFOP000001 Fin & [NAME]
FINANCIAL PLANNING
 | MFFS000008 Financial Planning |  |  |  | 0
 | MFEB EBS Ongoing |  | 0 | 0 | 0
 | GRANTS |  |  |  | 0
 | Unused |  | 0 | 0 | 0
 | 9AUSA0000001 Single Audit |  | 0 | 0 | 0
ACCOUNTING
 | MFFS000001 Acct Admin
 | MFFS000002 Acct Process |  |  | 0
 | MFFS000003 Acct Technical
 | MFFS000004 Acct Customer
 | LAAUAUCA000000GL CAFR audit |  | 0 | 0 | 0
SPECIAL APPROPRIATION
 | MFSA000002 City Membership/Dues |  |  | 0 | 0
 | MFSA000003 Leaders Roundtable |  | 0 | 0 | 0
 | MFSA000005 Council E-Funds |  | 0 | 0 | 0
HR ORG 1..6
 | MFHR000001 Operations
 | MFHR000002 Labor |  | 0 | 0 | 0
 | MFHR000003 Class/Comp |  | 0 | 0 | 0
 | MFHR000004 E&D |  | 0 | 0 | 0
 | MFHR000005 Diversity |  | 0 | 0 | 0
 | MFHR000006 Benefits |  | 0 | 0 | 0
HR UTILITIES
 | MFHR000007 Utilities |  |  | 0 | 0
HR SAFETY
 | MFHR000008 Safety |  |  | 0 | 0
HR ADMIN
 | MFHR000009 [NAME] |  |  | 0 | 0
OEM
 | PSEO000000000000/FREO000004 |  |  | 0 | 0
OFFICE OF EQUITY
 |  |  |  | 0 | 0
POEM
 | EMEM Emergency Management
 | Subtotals | $
 | SPECIFIC ALLOCATIONS: |  |  |  |  | 0
 | City-Wide Cost Allocation
Spreadsheet: f4b6b687-617a-4b2a-9593-7de6c43e144a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2012
 |  | Data Extracted on: April 18, 2014 (5:03 am)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229646
Q2-2004 | 233241
Q3-2004 | 235336
Q4-2004 | 237875
Q1-2005 | 242085
Q2-2005 | 244136
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276019
Q2-2008 | 278206
Q3-2008 | 280691
Q4-2008 | 273572
Q1-2009 | 267266
Q2-2009 | 267665
Q3-2009 | 268736
Q4-2009 | 271174
Q1-2010 | 273058
Q2-2010 | 275612
Q3-2010 | 279685
Q4-2010 | 281383
Q1-2011 | 283078
Q2-2011 | 290271
Q3-2011 | 293177
Q4-2011 | 293795
Q1-2012 | 297910
Q2-2012 | 301286
Q3-2012 | 303811
Q4-2012 | 309614
Spreadsheet: c856edc3-62ef-4ade-90d0-a998ad2b2a77
Sheet: PAN A-E

 | Permit No.: | WQ0003626 |  | Facility Name: |  | Campbell Soup Supply Company, LLC |  |  |  |  |  | County: |  | Robeson |  | Month: |  |  |  | Year:
 |  | Field Name: |  | A |  | Field Name: |  | B |  | Field Name: |  | C |  | Field Name: |  | D |  | Field Name: |  | E
 |  | Area (acres): |  | 83.35 |  | Area (acres): |  | 8.6 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME]
 |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
 |  |  |  | 350 |  |  |  | 350 |  |  |  | 350 |  |  |  | 350 |  |  |  | 350
Spreadsheet: 06b7426d-b82d-44fe-9135-8b2e7fb21ace
Sheet: Hybrid Example

 |  | Return to Index Page
 | Period | Mon | Tue | Wed | Thu | Fri | Total | [NAME].
 | 1 | 43 | 43 | 90 |  | 43
 | 2 | 47 | 47 |  | 90 | 47
 | 3 | 46 | 46 | 90 |  | 46
 | 4 | 45 | 45 |  | 90 | 45
 | 5 | 46 | 46 | 90 |  | 46
 | 6 | 46 | 46 |  | 90 | 46
 | 7 | 45 | 45 | 90 |  | 45
 | 8 | 48 | 48 |  | 90 | 48
 | OJT | 60 | 60 | 60 | 60 | 60
 | Seminar |  |  |  |  |  |  | 5
 | Course |  | Number | Period | Class
Approved Class Name | Code | Teacher | Period | Enrolled | Minutes | Total
Accounting I | 12345 |  | 4 | 26
Accounting II | 12346 |  | 5 | 12
Computer Applications I | 21534 |  | 1 | 15
Computer Applications I | 21534 |  | 2 | 14
Computer Applications I | 21534 |  | 3 | 16
Computer Applications I | 21534 |  | 6 | 16
Computer Applications II | 21535 |  | 7 | 15
Computer Applications II | 21535 |  | 8 | 15
Advanced Drafting | 34156 |  | 4 | 12
Cabinet Making III | 45678 |  | 3 | 4
Cabinet Making IV | 45679 |  | 4 | 3
Business OJT | 51456 |  | OJT | 3
Seminar Period |  |  | Seminar | 148
 |  |  |  |  | TOTAL MINUTES
 |  |  |  |  | TOTAL HOURS
Spreadsheet: 01c4580c-b9ed-4183-a75c-eb5fefdb5a81
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | FORMULARIO N
ORGANIZACIÓN DE AVIACIÓN CIVIL INTERNACIONAL
FORMULARIO DE INFORMACIÓN DE TRANSPORTE AÉREO
INSTRUCCIÓN Y LICENCIAS DEL PERSONAL DE AVIACIÓN
Persona contacto: |  |  |  | Estado:
Organización:
Tel: |  |  |  | [NAME]:
Fax:
Correo-e:
CALIFICACIONES DEL PERSONAL DE AVIACIÓN
Código OACI | Calificaciones, por categoría |  | Calificaciones expedidas  (anuales) | Calificaciones activas  totales | Convalidaciones/conversiones anuales | Convalidaciones/ conversiones totales | [NAME] jubilatoria
 | a |  | b | c | d | e | f
 | 1 | ATPL
 | 2 | CPL
 | 3 | MPL
 | 4 | PPL
 | 5 | Habilitaciones de instructor de vuelo
 | 6 | Autorizaciones específicas
 | 7 | Licencias para mantenimiento de aeronaves
 | 8 | Licencias de ATC
CAPACIDAD FUTURA DE FORMACIÓN DE PERSONAL DE AVIACIÓN
Código OACI | Licencias por categoría |  | Organizaciones de instrucción  (actuales) | Organizaciones de instrucción  (en 5 años) | [NAME](en 5 años)
 | g |  | h | i | j
 | 9 | Pilotos (PPL/CPL/ATPL)
 | 10 | Pilotos (MPL)
 | 11 | Licencias para mantenimiento de aeronaves
 | 12 | Licencias de ATC
Spreadsheet: sally_beck__33954__Weekly Operating Report 2-15
Sheet: Data

New Deals |  |  |  | Contracts
Physical Gas | 6500 |  |  |  | Gas On-System | Gas Off-System | Power
Financial Gas | 7500 |  |  | Buy | 2 | 6 | 3
Physical Power | 4000 |  |  | Sell | 3 | 10 | 2
Financial Power | 55 |  |  | Transport | 4 | 2 | 0
Physical Lumber | 3 |  |  | Storage | 0 | 0 | 0
Financial Lumber | 5
Physical Newsprint | 10
Financial Newsprint | 20
 |  |  |  | New Deals
Financial Liquids | 50 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1 | 2/2 - 2/8 | 2/9 - 2/15
IR/FX | 175 |  |  | Gas |  |  |  |  |  |  |  |  | MMBTU
Weather | 2 |  |  | Power |  |  |  |  |  |  |  |  | MHtz
Physical Pulp | 20 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
Financial Pulp | 30 |  |  | IR/FX |  |  |  |  |  |  |  |  | BBL
Physical Steel | 1 |  |  | Liquids |  |  |  |  |  |  |  |  | TONNE
Financial Steel | 3 |  |  | Coal |  |  |  |  |  |  |  |  | HDD/CDD
Coal | 2 |  |  | Weather |  |  |  |  |  |  |  |  | USD
Physical Liquids | 65 |  |  | Emissions |  |  |  |  |  |  |  |  | CONTRACTS
Emissions | 10 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
 |  |  |  | Newsprint |  |  |  |  |  |  |  |  | TONNE
M&A | 0 |  |  | Pulp |  |  |  |  |  |  |  |  | TONNE
Legal | 0 |  |  | Lumber |  |  |  |  |  |  |  |  | TONNE
Lease | 0 |  |  | Steel |  | 0 | 0 | 0 |  |  |  |  | TONNE
Auction | 1
Gas | 1300 |  |  | [NAME]
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
Others | 50 |  |  | MMBTU
Lumber | 0 |  |  | MHtz
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
 |  |  |  | Total EIM
Newsprint | 0 |  |  | Newsprint
Pulp | 5 |  |  | Pulp
Steel | 0 |  |  | Lumber
 |  |  |  | Steel
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
 |  |  |  | Liquids
EGM |  |  |  | Coal
Liquids | 45 | 40 | 55 | Emissions | 5 | 5
IR/FX | 150 | 120 | 125 | Weather | 49250 | 45350 | 120900 | 115500
 |  |  |  | IR/FX | 6275000 | 6398750 | 3718000 | 6618000
Weather | 2 | 5 | 2
Emissions | 2 | 1 | 10
ENA
Gas | 11000 | 12500 | 12000
Power | 5500 | 5000 | 4055
EIM
Newsprint | 25 | 52 | 30
Pulp | 10 | 42 | 50
Lumber | 8 | 8 | 8
Steel | 3 | 1 | 4
Date | Unit Type | Commodity | Units | New Deals
Wk 1 | MMBTU | Gas | 1350
Wk 1 | MHtz | Power | 180 | 5500
Wk 1 | Loads | Lumber | 8 | 8
Wk 1 | Bails | Newsprint | 15 | 25
Wk 1 | Bars | Steel | 5 | 3
Wk 1 | Buckets | Pulp | 10 | 10
Wk 1 | [NAME] | Liquid | 45 | 45
Wk 1 | Lumps | Coal | 2 | 2
Wk 2 | MMBTU | Gas | 1505
Wk 2 | MHtz | Power | 175 | 5000
Wk 2 | Loads | Lumber | 10 | 8
Wk 2 | Bails | Newsprint | 25 | 52
Wk 2 | Bars | Steel | 7 | 1
Wk 2 | Buckets | Pulp | 30 | 42
Wk 2 | [NAME] | Liquid | 32 | 40
Wk 2 | Lumps | Coal | 2 | 1
Wk 3 | MMBTU | Gas | 1600
Wk 3 | MHtz | Power | 190 | 4055
Wk 3 | Loads | Lumber | 10 | 8
Wk 3 | Bails | Newsprint | 25 | 30
Wk 3 | Bars | Steel | 8 | 4
Wk 3 | Buckets | Pulp | 40 | 50
Wk 3 | [NAME] | Liquid | 37 | 55
Wk 3 | Lumps | Coal | 2 | 2
Spreadsheet: 697606d1601439815-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics
Sheet: Data

Date | Credit | Debit | Amount | Project |  |  |  | Credit | [NAME] | Adam | Emma | Ellen | [NAME] | [NAME] | Emily | [NAME] | chk
2018-11-17 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-03-15 00:00:00 | [NAME] | Ellen | 280 | Proj-6
2017-04-10 00:00:00 | Adam | [NAME] | 150 | Proj-8
2018-12-07 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 320 | Proj-5
2019-08-15 00:00:00 | Ellen | Emily | 700 | Proj-8
2019-04-20 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2020-04-30 00:00:00 | Adam | [NAME] | 200 | Proj-3
2019-02-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2019-01-09 00:00:00 | [NAME] | Ellen | 1700 | Proj-2
2018-08-26 00:00:00 | [NAME] | Adam | 500 | Proj-5 |  |  |  | Debit | [NAME] | Adam | Emma | Ellen | [NAME] | [NAME] | Emily | [NAME] | chk
2017-04-10 00:00:00 | Adam | [NAME] | 180 | Proj-8
2019-11-28 00:00:00 | Ellen | [NAME] | 400 | Proj-9
2018-08-02 00:00:00 | Emma | Adam | 920 | Proj-10
2017-06-04 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-11-23 00:00:00 | Ellen | Adam | 1500 | Proj-6
2017-06-02 00:00:00 | Adam | [NAME] | 280 | Proj-1
2018-09-27 00:00:00 | [NAME] | Adam | 1170 | Proj-5
2018-04-15 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
2020-04-22 00:00:00 | Adam | [NAME] | 400 | Proj-3
2018-07-12 00:00:00 | [NAME] | Adam | 495 | Proj-5
2019-11-13 00:00:00 | Emily | [NAME] | 650 | Proj-9 |  |  | Balance
2019-08-19 00:00:00 | Ellen | [NAME] | 500 | Proj-8
2018-04-15 00:00:00 | [NAME] | Adam | 500 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 1000 | Proj-5 |  |  | https://www.excelforum.com/excel-formulas-and-functions/1328708-help-analyzing-data-in-a-table-shared-expense-who-owes-whom.html
2019-08-19 00:00:00 | Ellen | Emily | 300 | Proj-8
2018-02-09 00:00:00 | [NAME] | Ellen | 400 | Proj-6
2019-02-05 00:00:00 | Emma | Ellen | 3400 | Proj-7
2018-08-12 00:00:00 | Ellen | Adam | 500 | Proj-6
2018-07-12 00:00:00 | Adam | [NAME] | 350 | Proj-5
2018-11-07 00:00:00 | Adam | Emily | 185 | Proj-6
2019-11-20 00:00:00 | Adam | [NAME] | 300 | Proj-9
2019-03-15 00:00:00 | [NAME] | Emily | 360 | Proj-6
2018-08-04 00:00:00 | [NAME] | Emily | 250 | Proj-1
2018-08-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2020-04-26 00:00:00 | Adam | [NAME] | 250 | Proj-3
2019-11-20 00:00:00 | Adam | [NAME] | 450 | Proj-9
2018-07-09 00:00:00 | [NAME] | [NAME] | 350 | Proj-5
2018-10-05 00:00:00 | Emma | Adam | 550 | Proj-5
2019-11-25 00:00:00 | Ellen | [NAME] | 300 | Proj-9
2019-11-24 00:00:00 | [NAME] | Emily | 650 | Proj-4
2017-04-10 00:00:00 | Adam | [NAME] | 105 | Proj-10
2017-07-10 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2018-10-31 00:00:00 | [NAME] | Adam | 1500 | Proj-5
2019-11-05 00:00:00 | Ellen | [NAME] | 400 | Proj-3
2018-02-13 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-04-24 00:00:00 | [NAME] | Adam | 495 | Proj-5
2018-04-11 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-12-23 00:00:00 | Ellen | [NAME] | 150 | Proj-1
2018-06-28 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
Spreadsheet: 843218d1695134801-conditional-formatting-to-colour-when-name-shows-2-times-with-another-criteria-included-conditional-format-test
Sheet: Sheet1

Helper | Name | Fruit | Colour it should be
 | [NAME] | Apple | Green
 | [NAME] | Apple | Amber
 | [NAME] | [NAME] | Amber
 | [NAME] | [NAME] | Red
 | [NAME] | [NAME] | Red
 | [NAME] | Pear | Red
 | [NAME] | Pear | Red
 | [NAME] | Apple | Red
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  ONTARIO
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 33532345 | 75233124
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2963205 | 7101003
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 36495550 | 82334127
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -35715373 | -80552149
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -807938 | -1908298
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -36523311 | -82460447
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 27761 | 66348.79
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | -3274
 | Total Transport Expense: |  | 0 | -3274
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 708911.5228982903
31 |  | Prior Month Book Balance | 0 | -695660
 |  | Total MTM Income | 0 | 13251.52289829031
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 80335
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -110
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 32201
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | 686492
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: Example

Premium Saver-Insured HRA-Request for Quote
Employer Name: | ABC Manufacturing |  |  |  |  |  | Telephone: | 989-999-999
Employer Address: | 123 Main Street
Employer City: | Anytown |  |  |  | State: | MI | Zip Code: | 49xxx
Nature of business |  |  |  |  |  |  | Effective Date: | 2013-01-01 00:00:00
Agent Name: | CIC |  |  |  |  |  | Telephone: | [PHONE]
[NAME] To: | email address@company |  |  | Fax to: | [PHONE] |  | Questions: | [PHONE]
Current Plan(s) | Plan One |  |  | Plan Two |  |  | Plan Three
Medical Carrier | BCBSM CB 1 |  |  | BCBSM CB 4 |  |  | BCBSM CB 19
Deductible Amount | 0 |  |  | 500 |  |  | 1000
Employee Coinsurance | 0 |  |  | 0.2 |  |  | 0.2
$ Of Coinsurance | 0 |  |  | 1500 |  |  | 3000
Total Dollars OOP | 0 |  |  | 2000 |  |  | 4000
Doctor Office | $10 Copay |  |  | $20 Copay |  |  | $40 Copay
Specialist Office Visit | $10 Copay |  |  | $20 Copay |  |  | $40 Copay
Chiropractic | $10 Copay |  |  | $20 Copay |  |  | $40 Copay
Drug Co Pays | [NAME] |  |  | [NAME] |  |  | [NAME]
Emergency Room Copay | $50 Copay |  |  | $100 Copay |  |  | $250 Copay
Urgent Care Copay | $10 Copay |  |  | $20 Copay |  |  | $40 Copay
Drug Deductible Amount | 0 |  |  | 0 |  |  | 0
Renewal Date | 2013-01-01 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-01 00:00:00
 | # Employee | Current | Renewal | # Employee | Current | Renewal | # Employee | Current | Renewal
Employee | 11 | 650 | 780 | 20 | 400 | 480 | 6 | 350 | 400
Employee and Spouse | 10 | 1300 | 1560 | 10 | 800 | 960 | 5 | 850 | 970
Employee/Child(ren) | 0
Family | 20 | 1950 | 2340 | 35 | 1200 | 1440 | 1 | 1000 | 1180
 |  |  |  | Special Instructions
Alternate Plan
Medical Carrier | BCBSM CB 15/20
Deductible Amount | 5000
[NAME]. |  | 20 | %
$ Of Coinsurance | 2500
Total Dollars OOP | 7500
Doctor Office | $20 Copay
Specialist Office Visit | $20 Copay
Chiropractic | $20 Copay
Drug Co Pays | Tiered |  |  | Primary Goal of this [NAME] is to Save Premium
ER Copay | $100 Copay |  |  | Second Goal is to…
Urgent Care Copay | $20 Copay |  |  | (Please check one)
Drug Deductible Amt | 0 |  |  |  | Save Premium
Renewal Date | 2013-01-01 00:00:00 |  |  |  | Keep the Current Deductible & Coinsurance
 | # | Rates |  |  | Increase the Deductible & Coinsurance (increases savings)
Employee |  | 276.01 |  |  | Lower the Deductible and Coinsurance (improves benefits)
Employee/Spouse |  | 662.42
Employee/Child(ren)
Family |  | 828.02
Notes
Are Rates Firm | Yes/No
Insured HRA Plan Design (please enter the plan design you want quoted)
 |  |  |  | Plan One |  | Plan Two |  | Plan Three
Deductible Amount (Per Person) |  |  |  | 250 |  | 500 |  | 1000
Deductible Type  (Calendar Year or Plan Year) |  |  |  | Calendar |  | Calendar |  | Calendar
Co-Insurance % |  |  |  | 0 |  | 20 |  | 20
Co-Insurance $ [NAME] (Excludes Deductible) |  |  |  | 0 |  | 1500 |  | 3000
Benefit Amount |  |  |  | 7250 |  | 5500 |  | 3500