tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883875d1732628787-return-multiple-nonblank-values-from-column-into-one-cell-on-multiple-lines-product-selector
Sheet: Sheet2

 | Product 1 | False
 | Product 2 | True |  | Product 3
 | Product 3 | True |  | Product 4
 | Product 4 | True |  | Product 6
 | Product 5 | False
 | Product 6 | True
 | Product 7 | False
 | Product 8 | False
This column contains a list of products that the user can select, via checkboxes | These are the names of the products which correspond to the checkbox value in Column A | This column evaluates whether the checkbox has been checked or not (TRUE if checked, FALSE if unchecked) | This column returns the product name if it has been checked and a blank cell if it is unchecked | FILTER formula returns all nonblank cells from Column D
What I am trying to do: Take only the nonblank cells from Column E and return each product on its own line WITHOUT ANY BLANKS
Current State (With several blanks after Product 6): |  | Desired State (No blanks after Product 6): | Product 2 Product 3 Product 4 Product 6
Spreadsheet: 873715d1720258378-find-a-result-from-2-matrix-tables-matrix-example-2-
Sheet: Results

 | users / groups |  |  |  |  |  |  |  | functions / groups |  |  |  |  |  |  |  |  |  |  | results
 |  | Production | Sales | Finance | Management | GROUPLIST |  |  |  | Production | Sales | Finance | Management | GROUPLIST |  |  |  |  |  |  | Order | Quote | Job | Pay | PO's | Supplier |  | Order | Quote | Job | Pay | PO's | Supplier
 | User1 | x |  |  |  |  |  |  | Order | x | x | x | x |  |  |  |  |  |  | User1 | x |  | x |  | x |  |  |  |  | x |  | x |  | <<Root
 | User2 | x |  |  | X |  |  |  | Quote |  | x | x |  |  |  |  |  |  |  | User2 | x |  | x |  | x | ? |  | x |  | x |  | x | x
 | User3 |  | x |  |  |  |  |  | Job | x | x |  |  |  |  |  |  |  |  | User3 | x | x | x |  | x |  |  | x | x | x |  | x
 | User4 |  | x |  |  |  |  |  | Pay |  |  | x |  |  |  |  |  |  |  | User4 | x | x | x |  | x |  |  | x | x | x |  | x
 | [NAME] |  | x |  |  |  |  |  | PO's | x | x | x |  |  |  |  |  |  |  | [NAME] | x | x | x |  | x |  |  | x | x | x |  | x
 | [NAME] |  |  | x |  |  |  |  | Supplier |  |  | x | x |  |  |  |  |  |  | [NAME] | x | x |  | x | x | x |  | x | x |  | x | x | x
 | User7 |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User7 | x |  |  |  |  | x |  | x |  |  |  |  | x
 | User8 |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User8 | x |  |  |  |  | x |  | x |  |  |  |  | x
 | [NAME] | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | x | x | x |  | x |  |  | x | x | x |  | x
 | User10 | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User10 | x |  | x |  | x |  |  | x |  | x |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the objective is (in V3)
 |  |  |  |  |  |  |  | this is looking up users / groups using "User1" as the search and GroupList as the return |  |  |  |  |  |  |  |  |  |  |  |  | search users / groups using U3 as search criteria to return the GroupList (column G find row)
 |  |  |  |  |  |  |  | this is looking up functions / groupd using "Order" as the search and GroupList as the return |  |  |  |  |  |  |  |  |  |  |  |  | search functions / groups using V2 as search criteria to return the GroupList (colum O find row)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | check Array1 results with Array2 to see if any contents match. If they do, return TRUE
 |  |  |  |  |  |  |  | Because the word 'Production is in both array lists, I would expect a return value of TRUE |  |  |  |  |  |  |  |  |  |  |  |  | This would then mark if the user has access to the group.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need to see if Array1 has any contents of Array2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Array1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Array2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | result | True
Spreadsheet: 38517d1236687293-choose-ytd-and-month-figures-test
Sheet: Sales Purchases

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tot 08/09 | Nov 09 | Dec 09 | Jan 10 | Feb 10 | Mar 10 | Apr 10 | May 10 | Jun 10 | Jul 10 | Aug 10 | Sep 10 | Oct 10 | Tot 09/10 | Nov 10 | Dec 10 | Jan 11 | Feb 11 | Mar 11 | Apr 11 | May 11 | Jun 11 | Jul 11 | Aug 11 | Sep 11 | Oct 11 | Tot 10/11
Sales
Parts
Labour
MOT |  | 0 | 0 | 650 | 650 | 650 | 300 | 550 | 650 | 650 | 650 | 650 | 650 |  | 650
Sundries |  | 0 | 0 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 |  | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
Purchases
Parts
MOT |  | 0 | 0 | 325 | 325 | 325 | 150 | 275 | 325 | 325 | 325 | 325 | 325 |  | 325
Consumables |  | 0 | 50 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 |  | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120
Waste removal |  | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 |  | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
Customer petrol |  | 0 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 |  | 130 | 130 | 130 | 130 | 130 | 130 | 130 | 130 | 130 | 130 | 130 | 130
Carriage |  | 0 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 |  | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
Spreadsheet: 59173d1259644392-excel-2007-vlookup-expenses-2009-4
Sheet: 2009-05

EXPENSES
Date |  | Creditor | Details | Invoice | Amount | [NAME] | Nett
Total
2009-05-06 00:00:00 |  | C N A | Stationary |  | 438.55 | 61.4 | 499.95
2009-05-10 00:00:00 |  | Imaginet | Services | 0003008-3-0905 | 3328.11 | 465.94 | 3794.05
2009-05-19 00:00:00 |  | Digital Planet | Wireless Acess Router | 257383 | 1892.11 | 264.89 | 2157
2009-05-20 00:00:00 |  | [NAME] | Petrol. Oil and [NAME] sales | 20348 |  |  | 307.55
2009-05-23 00:00:00 |  | Bargain Books | Stationary |  | 17.5 | 2.45 | 19.95
2009-05-24 00:00:00 |  | Game Stores | Stationary | 173/24052009/130/37/0048 | 278.95 | 39.05 | 318
2009-05-25 00:00:00 |  | clicks | Misc Sales |  | 379.13 | 18.87 | 398
2009-05-25 00:00:00 |  | [NAME] | Repairs | 17 |  |  | 150
2009-05-26 00:00:00 |  | clicks | Misc Sales |  | 387.04 | 54.18 | 441.22
2009-05-28 00:00:00 |  | Ackermans | Misc Sales | 6960 | 116.49 | 16.31 | 132.8
2009-05-30 00:00:00 |  | GA Design | Sketch plans | 51 | 4800 | 672 | 5472
Spreadsheet: tracy_geaccone__40259__C0366-111727
Sheet: Dept_100182

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
BUILDING SERVICES - Dept. 100182
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-06-21 00:00:00 | BSV100182-2001-06-0366-111727 |  | Building Services | Sq. Ft. Occupied | 1619 | 0.03 | /EACH | 48.57
 |  |  |  |  |  |  | Ticket Total |  | 48.57
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 48.57
 |  |  |  |  |  |  | Total for Dept_100182 |  | 48.57
Spreadsheet: 825965d1681700170-sort-formula-sort-by-aligw
Sheet: Sheet1

Name | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Michelle | 3890 | 3529 | 2803 | 3534 | 2668 | 4608 | 2882 | 4901 | 1536 | 3952 | 4578 | 2009
[NAME] | 3672 | 2442 | 1993 | 4427 | 2861 | 1298 | 1364 | 2953 | 4149 | 1614 | 4918 | 1970
Addy | 3791 | 4463 | 1324 | 3798 | 3278 | 1253 | 2443 | 4154 | 2794 | 4801 | 1543 | 4876
[NAME] | 1138 | 1050 | 3527 | 3936 | 1512 | 3500 | 2494 | 1890 | 3558 | 4902 | 3075 | 4280
 | Sort By Name |  | Sort By Month |  | Manually |  |  |  |  | How do I get the Name of the Person and Sort it by biggest to smallest?
 |  |  |  |  | 2022-04-30 00:00:00 | To Show the month instead of the amount
 | Addy |  | 15269 |  | 2022-10-31 00:00:00 |  |  |  |  | How do I get the Date and Sort it by biggest to smallest?
 | [NAME] |  | 14114 |  | 2022-11-30 00:00:00
 | [NAME] |  | 13898 |  | 2022-08-31 00:00:00
 |  |  | 13135 |  | 2022-12-31 00:00:00
 |  |  | 12491 |  | 2022-01-31 00:00:00
 |  |  | 12037 |  | 2022-09-30 00:00:00
 |  |  | 11484 |  | 2022-02-28 00:00:00
 |  |  | 10659 |  | 2022-06-30 00:00:00
 |  |  | 10319 |  | 2022-05-31 00:00:00
 |  |  | 9647 |  | 2022-03-31 00:00:00
 |  |  | 9183 |  | 44773
Spreadsheet: 43a548e5-73cb-4460-a5e1-3cb2f18519b2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | ITEMIZADO   PROYECTO:
 | OFICINAS   DE  MANTENIMIENTO  CHILECTRA
 | PROYECTO    DE   OBRAS  CIVILES
ITEM | PARTIDA | UN
1.0 | INSTALACIÓN   DE  FAENAS
1.1.3 | [NAME] | un
1.1.4 | [NAME] | un
1.1.5 | Duchas Químicas | un
1.1.6 | Comedor | un
1.1.7 | Vestidor de Personal | un
 | OBRAS   CIVILES
2.0 | Protección del Inmueble | m2
3.0 | Demolición
3.1 | Retiro de Equipos de Clima,[NAME] e  instalaciones  relacionadas  con  [NAME]. | un
3.2 | Retiro de equipo  de Iluminación y de Instalaciones Eléctricas de Iluminación  y Equipos Clima Suprimidos. | un
3.3 | Retiro  Artefactos  Sanitarios | un
3.4 | Retiro  Puerta   Acceso  a  baño | un
3.5 | Retiro  y [NAME] en sector [NAME] metálica 100% de su superficie. | m2
4.1 | Retapes de Dinteles y [NAME] | m2
4.2 | Reinstalación de Paños Vidriados Fijos en Áreas con retiro [NAME]. | un
5.0 | [NAME] | m2
6.0 | Perforaciones en [NAME] | un
7.0 | Perforaciones  en  Cubierta   existente de   40x50cms. | un
8.0 | [NAME] en  Cubierta | mt L
9.0 | Sujeción de Equipos de clima en vigas hormigón sobre  nivel de cubierta con perfilería  metálica. | [NAME]
10.0 | [NAME]
10.1 | [NAME] embutidos luminotecnia PL 2 x 26 Código 7227 * 702 con cristal serigrafiado y retraído, bisel termo esmaltado blanco, cuerpo aluminio brillante, ballast electrónico. | un
10.2 | [NAME] embutidos luminotecnia PL 2 x 26 Código 280, con cristal serigrafiado, bisel termo esmaltado blanco, cuerpo aluminio brillante, ballast electrónico para baños. | un
10.3 | [NAME] Lux 3X14W T5, [NAME],  [NAME] [NAME] ballast electrónico | un
10.4 | Lámparas Luminotecnia    Confort Lux 3X14W T5, para sobreponer,  [NAME] [NAME] ballast electrónico, gabinete electro pintado color blanco. | un
10.5 | [NAME] en cubículos WC, son los existentes. | un
10.6 | Considerar  KIT  de Emergencia de acuerdo a planos de instalación eléctrica. | un
11.0 | [NAME] | un
12.0 | [NAME]
12.1 | [NAME] agua [NAME], , color yelow fleecker | m2
12.2 | Pintura en puertas existentes | m2
13.0 | [NAME] | Ver  Itemizado  Electricidad
13.1 | Ítems  relacionados a  Climatización
13.2 | [NAME]
14.0 | Instalaciones  Climatización | Ver  Itemizado  [NAME]
15.0 | Instalación  Sanitaria | un
15.1 | Desinstalar  los WC, | un
15.2 | Remover y verificar el sellado | un
15.3 | Volver a instalar  WC y nivelarlos | un
15.4 | Conexión desagüe [NAME] clima [NAME] 1 | un
15.4.1 | Sellar cámara baño | un
15.4.2 | Varios a criterio de contratista   (detallar) | gl
16.0 | Instalaciones  Varias:          Nota: Listado no excluyente, respecto a planos de instalaciones y arquitectura.
16.1 | [NAME]. | un
16.2 | Tarjetero  Control  Acceso | un
16.3 | [NAME] | un
16.4 | Extintores  de  Incendio | un
16.5 | Señalética de Emergencia | un
16.6 | Parlantes  Altavoces | un
17.0 | [NAME] | gl
 |  | COSTO  DIRECTO
 |  | GASTOS    GENERALES
 |  | UTILIDADES
 |  | SUBTOTAL   NETO
Spreadsheet: 808084d1670274925-exponentially-weighted-moving-average-result-in-a-single-function-cell-ewma
Sheet: EWMA

 | Weighting
 | Prior periods | 0.8
 | Current period
 | nr_lt_check | 1
 | Data
 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Etc. ->
 | Sales | 10 | 2 | 5 | 4 | 7 | 2 | 10 | 4 | 3 | 3 | 3 | 1
 | The math
 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 80% of the prior  Period
 |  | + 20% of the current period
 | Total
 | Result - Exponentially weighted moving average
 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | Model
 | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is there a way to calculate this result without having to do/show
 |  |  |  |  |  |  | All of this?
Spreadsheet: 86039d1286006287-grouping-amounts-based-on-working-days-map1
Sheet: Data

Company | Customer | Invoice | Invoice date | Due date | Invoice Amount | Current date | Overdue working days | Current | 0-30 | 31-60 | 61-90 | 90 >
A | SMITH | 1 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 1200 |  |  |  |  |  | 1200
A | [NAME] | 2 | 2010-04-25 00:00:00 | 2010-06-25 00:00:00 | 1500 |  |  |  |  |  | 1500
A | BECKER | 3 | 2010-02-01 00:00:00 | 2010-05-01 00:00:00 | 2512 |  |  |  |  |  |  | 2512
B | SMITH | 145 | 2010-05-01 00:00:00 | 2010-07-01 00:00:00 | 1815 |  |  |  |  |  | 1815
B | [NAME] | 152 | 2010-09-18 00:00:00 | 2010-10-18 00:00:00 | 2000 |  |  | 2000
B | BECKER | 168 | 2010-07-21 00:00:00 | 2010-08-21 00:00:00 | 100 |  |  |  | 100
Spreadsheet: 79994d1280242532-auto-formulas-sample-workbook
Sheet: OIF

Authorized Position | First Name | Last Name | Last 4 SSN | Status | Provider | Date Attended MRAP-U (FSR/RR/Instructors Only) | CRC Completion Date | Arrival in Country Date | Country | Location | R&R Start | R&R End | Date of Physical | Remarks | Tour End Date | Renew/Extend Y/N | 90-Day Loss
IT Coordinator | [NAME] | [NAME] | 3387 | Duty | JLI | N/A | 13-May-05 | 2004-05-15 00:00:00 | Iraq | PM FWD HQ | 2010-08-06 00:00:00 | 2010-08-22 00:00:00 |  |  |  |  | Yes
SAMS-E Operator | Antoine | Champion |  | Duty | JLI |  |  |  | Iraq | Al Asad |  |  |  |  |  |  | Need Tour End Date
FSR | [NAME] | Hill |  | Duty | RG33 |  |  |  | Iraq | Balad |  |  |  |  |  |  | Need Tour End Date
SPAWAR C4I FSR | Gregory | Hulin |  | Duty | EMA | N/A |  |  | Iraq | Balad |  |  |  |  |  |  | Need Tour End Date
Site Property Book Technician | [NAME] | Schultz | 7679 | Duty | JLI | N/A | 27-Oct-07 | 04-Nov-07 | Iraq | Al Asad |  |  |  |  |  | YES
FSR | [NAME] | Griegsby |  | TDY | BAE-TVS |  |  |  | Iraq | Balad |  |  |  | Shocker |  |  | Yes
SPAWAR C4I FSR | [NAME] | Marsh |  | TDY | EMA |  |  |  | Iraq | Balad |  |  |  | Speicher |  |  | Need Tour End Date
FSR | Marcus | [NAME] |  | Duty | [NAME] |  |  | 07-Nov-09 | Iraq | Liberty |  |  |  |  |  |  | Need Tour End Date
FSR | Lewis | Exford | 2676 | Duty | BAE | N/A | N/A | 30-Aug-09 | Iraq | Al Asad |  |  |  |  |  | NO | Yes
Mechanic | [NAME] | Iran |  | Duty | RRAD |  |  |  | Iraq | Tallil
Safety Tech | [NAME] | [NAME] | 6124 | TDY | JLI | N/A | N/A | 02-Dec-09 | Iraq | PM FWD HQ |  |  |  | Liberty |  | Yes
FSR | [NAME] | Bassim |  | Duty | [NAME] |  |  |  | Iraq | Liberty |  |  |  |  |  |  | Need Tour End Date
Sustainment Mechanic | Randall | Betteridge |  | R&R | RRAD |  |  |  | Iraq | Al Asad
FSR | [NAME] | [NAME] |  | Duty | BAE |  |  |  | Iraq | Taji
Regional [NAME] | Scott | Dominick |  | Duty | [NAME] |  |  |  | Iraq | Stryker (VBC) |  |  |  |  |  | No | Need Tour End Date
QA / QC Representative | [NAME] | [NAME] |  | Duty | RRAD |  |  |  | Iraq | Tallil |  |  |  |  |  | No
Supply Tech | Jermaine | Guillory |  | R&R | JLI |  |  |  | Iraq | Liberty | 2010-07-25 00:00:00 | 2010-08-10 00:00:00
PBUSE Technician | [NAME] | [NAME] |  | Duty | Honeywell |  |  |  | Iraq | Liberty
Sustainment Mechanic | Reginald | [NAME] |  | Duty | RRAD |  |  |  | Iraq | Speicher
Spreadsheet: 0c387165-d6e6-4837-8967-f8b33f20e127
Sheet: Active Claims History-Combined

City of Carrollton
Active Claims History-Combined
December 2012
2012
Period | Census | Medical | Prescription | Dental Claims |  | 12 MONTH RECAP: |  |  | January '12 - December '12
January | 686 | 489865.25 | 90105.15 | 39406.76
February | 682 | 452840.91 | 86587.97 | 49222.18 |  | MEDICAL
March | 682 | 958842.16 | 125946.93 | 60578.47
April | 684 | 302832.56 | 122116.36 | 54068.38 |  | DENTAL |  |  | 546050
May | 679 | 517916.95 | 173763.25 | 33892.81
June | 673 | 692254.49 | 124130.84 | 35309.58 |  | PRESCRIPTION DRUGS |  |  | 1608789
July | 678 | 590456.5 | 118616.52 | 42955.14
August | 683 | 409198.82 | 115918.77 | 43553.78 |  |  |  | TOTALS: | 8712378
September | 679 | 474061.76 | 133871.32 | 47863.28
October | 676 | 432575.61 | 124764.99 | 51573.5
November | 668 | 410612.05 | 127475.8 | 40622.47
December | 662 | 495802.84 | 153533.1 | 47004.06
Total
2011
Period | Census | Medical | Prescription | Dental Claims |  | 12 MONTH RECAP: |  |  | January '11 - December '11
January | 682 | 404382.96 | 56002.61 | 51331.92
February | 675 | 310251.48 | 67549.12 | 38407.52 |  | MEDICAL
March | 679 | 464003.9 | 77718.59 | 40998.64
April | 672 | 412301.66 | 67128.91 | 44472.03 |  | DENTAL
May | 669 | 360824.4 | 76955.62 | 47817.21
June | 676 | 365582.6 | 68984.45 | 30190.8 |  | PRESCRIPTION DRUGS
July | 679 | 314217.84 | 63965.67 | 45137.13
August | 679 | 601833.32 | 91599.97 | 40529.07 |  |  |  | TOTALS:
September | 677 | 504431.9 | 77874.53 | 32537.67
October | 675 | 466052.84 | 78266.06 | 30481.97
November | 678 | 384158.67 | 93975.49 | 41191.69
December | 679 | 633220.64 | 94567.79 | 47399.73
Total
2010
Period | Census | Medical | Prescription | Dental Claims |  | 12 MONTH RECAP: |  |  | January '10 - December '10
January | 724 | 308438.46 | 111906.35 | 56259
February | 716 | 553936.49 | 105754.34 | 54836.14 |  | MEDICAL
March | 716 | 330626.01 | 109632.25 | 55250.34
April | 719 | 272719.61 | 117522.78 | 42997.71 |  | DENTAL
May | 716 | 260064.38 | 92575.99 | 47337.21
June | 710 | 332137.64 | 88188.34 | 40952 |  | PRESCRIPTION DRUGS
July | 706 | 365796.01 | 96640.64 | 42396.33
August | 703 | 269981.6 | 95509.38 | 50381.92 |  |  |  | TOTALS:
September | 694 | 293579.63 | 101006.27 | 33100.49
October | 691 | 250003.76 | 87545.03 | 42743.92
November | 687 | 215461.45 | 90833.35 | 30467.95
December | 690 | 308546.33 | 101316.67 | 37030.36
Total
2009
Period | Census | Medical | Prescription | Dental Claims |  | 12 MONTH RECAP: |  |  | January '09 - December '09
January | 719 | 181601.53 | 92720.07
February | 720 | 371683.89 | 81852.72 |  |  | MEDICAL
March | 724 | 308119.72 | 90548.84
April | 731 | 516627.45 | 96651.16 |  |  | DENTAL
May | 730 | 322981.11 | 83250.54
June | 732 | 297068.5 | 92351.11 |  |  | PRESCRIPTION DRUGS
July | 723 | 295400.13 | 85377.1
August | 726 | 256023.43 | 84934.69 |  |  |  |  | TOTALS:
September | 719 | 363855.39 | 105865.3
October | 716 | 278221.22 | 103530.69
November | 716 | 271039.06 | 95128.38
December | 718 | 409056.58 | 110459.61
Total
Spreadsheet: 167824d1342110932-excel-2007-vlookup-help-2012-bud-help_v2
Sheet: Jan

Monthly [NAME]
 | [NAME] | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage |  |  | 875.48
 | Tundra | 2012-01-31 00:00:00 | 2012-01-15 00:00:00 | 343.92 | 343.92
 | Sorento | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
 | Verizon Wireless | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 200 | 219.26
 | RZMC | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 51 | 51
 | Capital One | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 25 | 25
 |  | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
 | Household Bank
 | Insurance | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 79.8 | 79.8
 | RG&E | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 185.2 | 185.2
 | Time Warner | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 159.79 | 159.79
 | ACS | 2012-01-31 00:00:00 |  | 156.29
 | AES | 2012-01-31 00:00:00 |  | 138.86
 | Sallie Mae | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 213.47 | 213.47
 | 1st Financial | 2012-01-31 00:00:00
 | Waste Management | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 82.89
 | Water Authority
 | Wells Fargo - Furniture | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 30 | 40
 | Doe |  |  | 503.71
 | [NAME]
Spreadsheet: 167827d1342111573-1st-time-user-of-excel-solver-function-can-some-one-double-check-my-work-for-accuracy-efficient-frontier-calc-7-11-12
Sheet: S&P500_Barclays Aggr E.F

 | Efficient Frontier Calculation
 |  |  | Deviation |  |  |  |  | Deviation
 |  |  | about |  |  |  |  | about
 | Fixed Income |  | the mean | [NAME] |  | Equities |  | the mean | [NAME]
 | 2012-05-31 00:00:00 | 0.00904659 |  |  |  | 2012-05-31 00:00:00 | -0.0614
 | 2012-04-30 00:00:00 | 0.011089 |  |  |  | 2012-04-30 00:00:00 | 0.006
 | 2012-03-31 00:00:00 | -0.005479319999999999 |  |  |  | 2012-03-31 00:00:00 | 0.0332
 | 2012-02-29 00:00:00 | -0.0002281 |  |  |  | 2012-02-29 00:00:00 | 0.0424
 | 2012-01-31 00:00:00 | 0.00877641 |  |  |  | 2012-01-31 00:00:00 | 0.0461
 | 2011-12-31 00:00:00 | 0.01099119 |  |  |  | 2011-12-31 00:00:00 | 0.0103
 | 2011-11-30 00:00:00 | -0.00086912 |  |  |  | 2011-11-30 00:00:00 | -0.0033
 | 2011-10-31 00:00:00 | 0.0010765 |  |  |  | 2011-10-31 00:00:00 | 0.1097
 | 2011-09-30 00:00:00 | 0.007272499999999999 |  |  |  | 2011-09-30 00:00:00 | -0.0701
 | 2011-08-31 00:00:00 | 0.01461067 |  |  |  | 2011-08-31 00:00:00 | -0.0549
 | 2011-07-31 00:00:00 | 0.01586882 |  |  |  | 2011-07-31 00:00:00 | -0.0197
 | 2011-06-30 00:00:00 | -0.0029292 |  |  |  | 2011-06-30 00:00:00 | -0.0166
 | sum |  |  |  |  | sum
 | count |  |  |  |  | count
 | avg mean |  |  |  |  | avg mean
 | [NAME] |  |  |  |  | [NAME]
 | Standard Deviation |  |  |  |  | Standard Deviation
 | Fixed Income Allocation |  |  | 0.9813270369176315
 | Equities Allocation |  |  | 0.01867296308236855
 | Total Weight
 | [NAME]
 | Start Date
 | End Date
 | F_I_Average Return
 | [NAME]. Return
 | F_I_Standard Deviation
 | [NAME] Deviation
 | Portfolio Average Return
 | [NAME]
 | Portfolio Standard Deviation
 | Slope
 | Covariance
 | [NAME]
Spreadsheet: 735847d1623214314-formula-that-adds-1-if-cells-in-range-contain-specific-text-example-workbook-2-ans2
Sheet: Sheet1

 | 2021-09-12 00:00:00
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | WKN | [NAME]
EE A | D | D | N |  |  | D | N | N |  |  |  |  | N | N | N |  |  |  | D | D |  |  |  |  |  | D | N | N | 4
EE B |  |  | D | D | N |  |  | D | N | N |  |  | D | N |  |  | D | D |  |  | N | N |  |  | D | D |  |  | 3
EE C | D | D |  |  |  | D |  |  |  |  | D | D |  | D | D |  |  |  | D | N |  |  |  |  |  |  | D | D | 4
Spreadsheet: frank_ermis__11180__1109
Sheet: Export

[NAME] | [NAME] | Deal No. | Originator | Broker | Type | Deal Date | Status | Brk | Stmt | CP | Trd | Retro | Quantity | Comm | Delivery Ref | Index | Beg Date | End Date | N | Premium | Price | Broker Fee
Enron North America Corp. | Williams Energy Marketing & Trading Company | YI4970.1 |  | NatSource In | Gas Daily S | 2001-11-09 00:00:00 | New deal | No | ANE | No | No | N | 5000 [NAME]/day | NG | GDP-CIG/RKYMTN | IF-CIG/RKYMT | 2001-11-13 00:00:00 | 2001-11-30 00:00:00 | F |  | US 2.04000 | 45
BP Amoco Oil Company | Enron North America Corp. | [NAME] |  | Amerex Petro | Swap | 2001-11-09 00:00:00 | New deal | No | AE | No | No | N | 5000 [NAME]/day | NG | IF-ELPO/PERMIAN | NX1 | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | F |  | US -0.1150 | 912.5
BP Oil International Limited | Enron North America Corp. | YI4947.1 |  | Tradition Fi | Swap | 2001-11-09 00:00:00 | New deal | No | AE | No | No | N | 10000 MMBtu/day | NG | IF-ELPO/PERMIAN | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F |  | US -0.1550 | 535
Spreadsheet: 725922d1616967963-calculate-weighted-percentile-weighted-percentile-sample-bwv10-
Sheet: Sheet1

Sample Data
Company | Plant | Production | Cost
A | AA | 150 | 1200 |  |  | Company | Weighted avg. Cost | Percentile
A | AV | 2000 | 1515 |  |  | A |  | ?
A | AC | 1555 | 1745 |  |  | B
B | BE | 851 | 1987 |  |  | C
B | BY | 158 | 1212 |  |  | D
C | CP | 546 | 1645
C | CI | 658 | 1845
C | CT | 1368 | 1864
D | DI | 987 | 1549
D | DL | 754 | 1843