tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 63b36342-98f0-4b6f-8092-4e77a806894c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Valstybės ir savivaldybės įmonių nuosavo kapitalo pokyčių ataskaitos forma | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  |  |  | ([NAME])
 |  |  |  |  | ([NAME], adresas, kiti duomenys)
 |  |  |  |  |  |  |  |  |  | (Tvirtinimo žyma)
20___ m. ______________  ___ d.  NUOSAVO KAPITALO POKYČIŲ ATASKAITA
 | _____________________________________ Nr. _____
 | (finansinės atskaitomybės sudarymo diena)
(ataskaitinis laikotarpis) |  |  |  |  |  |  |  |  | (finansinės atskaitomybės valiuta ir jos tikslumo lygis)
 | [NAME] savininko kapitalas | Turtą, kuris pagal [NAME] tik valstybės nuosavybė, atitinkantis kapitalas |  | [NAME] rezervas (rezultatai) |  | Privalomasis rezervas |  | Kiti rezervai |  | Nepaskirs-tytasis pelnas (nuostoliai) | Iš viso
 |  |  |  | Ilgalaikio materialio-jo turto | [NAME] turto
1. Likutis užpraėjusių finansinių [NAME] |  |  |  |  |  |  |  |  |  |  | 0
2. Apskaitos politikos pakeitimo rezultatas |  |  |  |  |  |  |  |  |  |  | 0
3. Esminių klaidų taisymo rezultatas |  |  |  |  |  |  |  |  |  |  | 0
4. Perskaičiuotas likutis užpraėjusių finansinių [NAME] | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
5. Ilgalaikio materialiojo turto vertės [NAME] (sumažėjimas) |  |  |  |  |  |  |  |  |  |  | 0
6. [NAME] turto vertės [NAME] (sumažėjimas) |  |  |  |  |  |  |  |  |  |  | 0
7. Pelno (nuostolių) ataskaitoje nepripažintas pelnas (nuostoliai) |  |  |  |  |  |  |  |  |  |  | 0
8. Ataskaitinio laikotarpio grynasis pelnas (nuostoliai) |  |  |  |  |  |  |  |  |  |  | 0
9. Turtą, kuris pagal [NAME] tik valstybės nuosavybė, atitinkančio kapitalo didinimas (mažinimas) |  |  |  |  |  |  |  |  |  |  | 0
10. Sudaryti rezervai |  |  |  |  |  |  |  |  |  |  | 0
11. Panaudoti rezervai |  |  |  |  |  |  |  |  |  |  | 0
12. [NAME] savininko [NAME] (mažinimas) |  |  |  |  |  |  |  |  |  |  | 0
13. Likutis praėjusių finansinių [NAME] pabaigoje | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
14. Ilgalaikio materialiojo turto vertės [NAME] (sumažėjimas) |  |  |  |  |  |  |  |  |  |  | 0
15. [NAME] turto vertės [NAME] (sumažėjimas) |  |  |  |  |  |  |  |  |  |  | 0
16. Pelno (nuostolių) ataskaitoje nepripažintas pelnas (nuostoliai) |  |  |  |  |  |  |  |  |  |  | 0
17. Ataskaitinio laikotarpio grynasis pelnas (nuostoliai) |  |  |  |  |  |  |  |  |  |  | 0
18. Turtą, kuris pagal [NAME] tik valstybės nuosavybė, atitinkančio kapitalo didinimas (mažinimas) |  |  |  |  |  |  |  |  |  |  | 0
19. Sudaryti rezervai |  |  |  |  |  |  |  |  |  |  | 0
20. Panaudoti rezervai |  |  |  |  |  |  |  |  |  |  | 0
21. [NAME] savininko [NAME] (mažinimas) |  |  |  |  |  |  |  |  |  |  | 0
22. Likutis ataskaitinių finansinių [NAME] | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
_______________________________ |  |  | _____________________________ |  |  |  |  | _______________________________
(įmonės vadovo pareigų [NAME]) |  |  | (parašas) |  |  |  |  | ([NAME] pavardė)
Spreadsheet: 41440d1239900520-listbox-of-unique-records-populating-another-listbox-countrycitylistbox
Sheet: Sheet1

Field1 | Field2 | Field 3
Albania | Tirana | 55678 |  |  | Country
Armenia | [NAME] | 55679
[NAME] | [NAME] | 55680 |  |  | City | chaco
Argentina | [NAME] | 55681
Argentina | Chaco | 55682 |  |  | Code | 55682
Argentina | Corrientes | 55683
Argentina | Cordoba | 55684
Australia | Toowoomba | 55685
Austrailia | Willawong | 55686
Australia | Warrnambool | 55687
Australia | Wodonga | 55688
Aruba | Oranjestad | 55689
Bosnia and Herzegovina | Sarajevo | 55690
Bangladesh | Dhaka | 55691
Belgium | Berchem | 55692
Belgium | Brussels | 55693
Belgium | Leuven | 55694
Bulgaria | Sofia | 55695
Spreadsheet: 716632d1612289455-eliminate-duplicate-text-eliminate-duplicate-text-question
Sheet: Sheet1

 | Room | Spec Tag | [NAME] |  | Results Required
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | co-working area | FIN-155 | Dulux Trade Vinyl Matt
 | reception | FIN-155 | Dulux Trade Vinyl Matt
 | reception | CLG-30 A | Feature timber ceiling
 | reception | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | residents' lounge | FIN-155 | Dulux Trade Vinyl Matt
 | residents' lounge | CLG-30 A | Feature timber ceiling
 | residents' lounge | CLG-30 A | Cube acoustic panel by Autex Acoustics Ltd.
 | workstations | FIN-155 | Dulux Trade Vinyl Matt
 | workstations | FIN-155 | Dulux Trade Vinyl Matt
 | workstations | FIN-155 | Dulux Trade Vinyl Matt
 | meeting room | FIN-155 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | screening room | CLG-40 | Cube acoustic panel by Autex Acoustics Ltd.
 | Staff Shower/ WC | FIN-155 | Dulux Trade Vinyl Matt
 | accessible WC | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | staff room | FIN-155 | Dulux Trade Vinyl Matt
 | meeting room | FIN-155 | Dulux Trade Vinyl Matt
 | post room | FIN-155 | Dulux Trade Vinyl Matt
 | mail room | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | dog wash | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | yoga room | CLG-22 | Dulux Trade Vinyl Matt
 | gym | CLG-22 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | storage | FIN-155 | Dulux Trade Vinyl Matt
 | playspace | CLG-22 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 01 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 01 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 02 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 02 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 02 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 03 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | residents lounge | FIN-155 | Dulux Trade Vinyl Matt
 | residents lounge | CLG-30 B | Feature timber ceiling
 | residents lounge | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | games | FIN-155 | Dulux Trade Vinyl Matt
 | games | CLG-30 B | Feature timber ceiling
 | games | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | storage | FIN-155 | Dulux Trade Vinyl Matt
 | accessible WC | FIN-155 | Dulux Trade Vinyl Matt
 | WC lobby | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | lounge/ library | FIN-801 | Dulux Trade Vinyl Matt
 | lounge/ library | CLG-30 C | Feature timber ceiling
Spreadsheet: 866118d1713064153-count-cells-containing-keywords-with-multiple-criteria-producttest
Sheet: Sheet1

2024-04-07 00:00:00 | Product 1 | No | abc, def, ghi |  |  |  |  | 2024-03-24 00:00:00 | 2024-03-31 00:00:00 | 2024-04-07 00:00:00
2024-04-07 00:00:00 | Product 1 | No | def |  |  |  | def
2024-04-07 00:00:00 | Product 2 | No | abc, ghi |  |  |  |  |  |  | =SUMPRODUCT(IF($C:$C="No",--ISNUMBER(SEARCH($H2, SUBSTITUTE($D:$D,",",""))),""))
2024-03-31 00:00:00 | Product 1 | No | def
2024-03-31 00:00:00 | Product 2 | No | abc
2024-03-24 00:00:00 | Product 2 | No | ghi
2024-03-24 00:00:00 | Produce 1 | No | def |  |  | Product 1 | def | 2024-03-24 00:00:00 | 2024-03-31 00:00:00 | 2024-04-07 00:00:00
2024-03-24 00:00:00 | Product 1 | Yes | def
Spreadsheet: 94b0866b-f65a-4abb-9f13-5549f9a3c422
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SHSTO | Test | SHSTO | [NAME], Serum | [NAME], S | Complement Fixation (CF)/Immunodiffusion | Plain, Red-Top Tube: Red |  |  | 0.75 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.5 mL | Hemolysis	Mild OK;Gross reject Thawing	Cold OK; Warm reject Lipemia	Mild OK;Gross reject Icterus	NA Other	NA | Mycelial by CF: negative (positives reported as titer) Yeast by CF: negative (positives reported as titer) Antibody by immunodiffusion: negative (positives reported as band present) | Monday through Friday; 9:30 a.m. | 2 days | 7 days | 3 | 86698 |  |  |  |  | Rochester
SHSTO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SHSTO | Result | 15121 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30360-2 | Histoplasma capsulatum mycelial Ab:ACnc:Pt:Ser:Ord:Comp fix
SHSTO | Result | 15122 | Histoplasma Yeast | Histoplasma Yeast | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35435-7 | Histoplasma capsulatum yeast phase Ab:ACnc:Pt:Ser:Ord:Comp fix
SHSTO | Result | 15123 | Histoplasma Immunodiffusion | Histoplasma Immunodiffusion | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5218-3 | Histoplasma capsulatum Ab:ACnc:Pt:Ser:Ord:Immune diffusion
Spreadsheet: 782361d1654003189-determine-in-which-month-sample-data-will-pass-limit-based-on-monthly-average-sample-data-2-aligw
Sheet: sample data

ID | Minimum of Start Date | Sub Item End Date | % Plan Limit Used | Apr Total | Limit | [NAME] | Feb Total | Jan Total | Date Due | Late?
name1 | 2020-12-22 00:00:00 | 2023-12-21 00:00:00 |  | 73739491.24 | 200000000 | 68512823.37 | 63266824.26 | 58987145.31
[NAME] | 2022-01-01 00:00:00 | 2025-12-31 00:00:00 |  | 5159467.67 | 90000000 | 3801557.75 | 2606521.21 | 5813334.08
name3 | 2021-09-13 00:00:00 | 2022-09-12 00:00:00 |  | 2043229.1 | 2500000 | 1770563.2 | 1494093.83 | 1231223.69
name4 | 2021-06-22 00:00:00 | 2022-06-21 00:00:00 |  | 78748.03 | 150000 | 38826.14 | 32646.76 | 32646.76
name5 | 2021-05-24 00:00:00 | 2022-05-23 00:00:00 |  | 48331029.8 | 41666666.7 | 44803503.51 | 37910673 | 32728463.08
Question | In which month will ID (name1, etc) pass the Limit based on monthly average usage
Question 2: Identify if it will be past the Sub item end date
Spreadsheet: 115496d1311091254-multiple-sumif-criteria-within-same-column-multiple-sumif-example-
Sheet: Raw Data

Criteria | MAY-11 | JUN-11 | JUL-11 | AUG-11 | SEP-11
Apple | 0 | 0 | -5.82076609134674e-14 | -4.94765117764473e-13 | -52.1519600000001 |  | -54.1975815316776
[NAME] | 3 | 5 | 2 | 0 | -2.0456215316775
[NAME] | 34 | 2 | 23 | 21 | 0
Ford |  |  | 0 | 0 | 0 |  | 0
Porsche |  |  | 63.8032666285716 | 74.4371445 | 74.4371445 |  | SUMIF(A2:A13,OR("Apple","Banana","Cherry"),(F2:F13))
Mango |  | 0 | 10.6285714285696 | -242.27118 | -472
[NAME] |  |  | 107.142857142857 | 960 | 200
Toyota |  | 0 | 0 | 0
Nissan |  |  | 23.6785723285773 | -3.25000010000001 | -3.2500001
Honda |  |  | 366.642870557143 | -914.50003659999 | -15.5000013000008
Carrot |  |  | 0
Bean |  |  | -351.517859221429 | 1047.7500062 | -1.00000079328311e-07
Spreadsheet: 163976d1340584648-calculate-opponents-win-loss-record-tennis-tourney-2012v2
Sheet: Prelims

Winner | Score |  |  | [NAME] |  | Name | W | L | Win % | Games-W | Games-L | Games-% | Opponents-W | Opponents-L | Opponents-Win% | Power Rank | Rank
[NAME] | 6 | - | 1 | [NAME] |  | [NAME] |  |  |  |  |  |  | 7 | 6
Kris | 6 | - | 0 | [NAME] |  | [NAME] |  |  |  |  |  |  | 0 | 0
Kris | 6 | - | 0 | [NAME] |  | [NAME] |  |  |  |  |  |  | 0 | 0
[NAME] | 6 | - | 2 | [NAME] |  | [NAME] |  |  |  |  |  |  | 0 | 0
[NAME] | 7 | - | 5 | Shawn |  | [NAME] |  |  |  |  |  |  | 0 | 0
Shannon | 6 | - | 0 | [NAME] |  | [NAME] |  |  |  |  |  |  | 0 | 0
[NAME] | 6 | - | 2 | [NAME] |  | [NAME] |  |  |  |  |  |  | 11 | 12
Shannon | 6 | - | 3 | Shawn |  | [NAME] |  |  |  |  |  |  | 0 | 0
Kris | 6 | - | 0 | [NAME] |  | Kris |  |  |  |  |  |  | 4 | 10
[NAME] | 7 | - | 5 | [NAME] |  | [NAME] |  |  |  |  |  |  | 0 | 0
[NAME] | 6 | - | 2 | [NAME] |  | [NAME] |  |  |  |  |  |  | 0 | 0
Kris | 6 | - | 0 | Shawn |  | Shannon |  |  |  |  |  |  | 0 | 0
[NAME] | 6 | - | 1 | [NAME] |  | Shawn |  |  |  |  |  |  | 0 | 0
Shannon |  | - |  | [NAME] |  | [NAME] |  |  |  |  |  |  | 0 | 0
Shannon |  | - |  | [NAME] |  | Trevor |  |  |  |  |  |  | 0 | 0
[NAME] | 6 | - | 4 | Shannon |  |  |  |  |  |  |  |  | 0 | 0
[NAME] | 6 | - | 0 | [NAME]
[NAME] | 6 | - | 0 | [NAME]
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
Spreadsheet: 848350d1699061444-bringing-shift-pattern-into-a-rolling-calendar-ef1617a_calendar-with-4-shifts
Sheet: Calculations

DATES | Week number in Month | [NAME] |  |  |  | A Shift | B Shift | C Shift | D Shift |  | A Shift | B Shift | C Shift | D Shift
Spreadsheet: 91272d1291047407-if-a-new-name-is-added-to-list-b-automatically-add-it-to-list-a-unique-names
Sheet: Sheet1

list b | list a | excel2007 version
martin
martin
martin
martin
martin
martin
pete
pete
pete
pete
pete
[NAME]
[NAME]
[NAME]
fred
martin
Spreadsheet: 88867d1288699655-multiple-criteria-lookup-to-return-values-in-a-column-ydj
Sheet: Sheet1

Brand | Size | ID Number | Date | Row | Production No. |  | 2010-10-02 00:00:00 | 2
GY | 1100 | ME4752 | 2010-10-02 00:00:00 | 1 | HB 072
BS | 900 | E2E1051 | 2010-10-02 00:00:00 | 1 | HB 073
HK | 825 | L1E1488 | 2010-10-02 00:00:00 | 2 | HB 074
BS | 750 | A3E2081 | 2010-10-02 00:00:00 | 2 | HB 075
BS | 900 | 53E1978 | 2010-10-02 00:00:00 | 1 | HB 076
GY | 1000 | E1E0519 | 2010-10-02 00:00:00 | 2 | HB 077
BS | 1000 | M1E0193 | 2010-10-02 00:00:00 | 2 | HB 078
GT | 700 | E1E0563 | 2010-10-02 00:00:00 | 2 | HB 079
GY | 1100 | 09T111049 | 2010-10-03 00:00:00 | 2 | HB 080
GT | 900 | 609S86-12 | 2010-10-03 00:00:00 | 2 | HB 081
GT | 1000 | 209S58-29 | 2010-10-03 00:00:00 | 1 | HB 082
GT | 900 | 609S89-28 | 2010-10-03 00:00:00 | 2 | HB 083
GT | 750 | 709S58-26 | 2010-10-03 00:00:00 | 1 | HB 084
GT | 900 | 209S58-26 | 2010-10-03 00:00:00 | 1 | HB 085
BS | 900 | B2E2384 | 2010-10-03 00:00:00 | 1 | HB 086
BS | 1000 | R3F0790 | 2010-10-03 00:00:00 | 2 | HB 087
 |  |  |  |  |  |  |  |  | ↑
 |  |  |  |  |  |  | ↑ |  | =INDEX($A$1:$F$17,SMALL(IF($D$1:$D$17=$H$1,ROW($D$1:$D$17)),ROW(1:1)),3
 |  |  |  |  |  |  | =INDEX($C$1:$C$17,MATCH($H$1&$I$1,$D$1:$D$17&$E$1:$E$17,0)
Spreadsheet: drew_fossum__8677__Fixed3
Sheet: ENA_11

[NAME]
FUEL HEDGING BOOK
Enron North America_11
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2001-01-01 00:00:00 |  | ENA | 3.74
2001-02-01 00:00:00 |  | ENA | 3.74
2001-03-01 00:00:00 |  | ENA | 3.74
2001-04-01 00:00:00 |  | ENA | 3.74
2001-05-01 00:00:00 |  | ENA | 3.74
2001-06-01 00:00:00 |  | ENA | 3.74
2001-07-01 00:00:00 |  | ENA | 3.74
2001-08-01 00:00:00 |  | ENA | 3.74
2001-09-01 00:00:00 |  | ENA | 3.74
2001-10-01 00:00:00 |  | ENA | 3.74
2001-11-01 00:00:00 |  | ENA | 3.74
2001-12-01 00:00:00 |  | ENA | 3.74
 |  |  |  |  |  | TW Index
2001-01-01 00:00:00 |  | Over-retention | 3.74
2001-02-01 00:00:00 |  | Over-retention | 3.74
2001-03-01 00:00:00 |  | Over-retention | 3.74
2001-04-01 00:00:00 |  | Over-retention | 3.74
2001-05-01 00:00:00 |  | Over-retention | 3.74
2001-06-01 00:00:00 |  | Over-retention | 3.74
2001-07-01 00:00:00 |  | Over-retention | 3.74
2001-08-01 00:00:00 |  | Over-retention | 3.74
2001-09-01 00:00:00 |  | Over-retention | 3.74
2001-10-01 00:00:00 |  | Over-retention | 3.74
2001-11-01 00:00:00 |  | Over-retention | 3.74
2001-12-01 00:00:00 |  | Over-retention | 3.74
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: f4bb9de2-778d-4f85-a370-8a1064b16b60
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBEFG | Test | FBEFG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <2 mcg/mL  The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicated immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FBEFG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FBEFG | Result | FBEFG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: phillip_allen__28915__version 2_20
Sheet: Proforma

 | One Bedroom Rate | 625 |  |  | Internet | 0
 | Two Bedroom Rate | 575
 | Three Bedroom Rate | 510
 | Four Bedroom Rate | 425
 | CATEGORIES |  |  |  | ONE BEDROOM |  |  |  | PLAN 1016 |  |  |  | PLAN 1213 |  |  |  | FOUR BEDROOM |  |  |  | PROJECT TOTAL |  |  |  |  | PROJECT TOTAL
 |  |  |  |  | TOTAL | Per Unit | Per SF |  | TOTAL | Total | Per SF |  | TOTAL | Total | Per SF |  | TOTAL | Per Unit | Per SF |  | Total | [NAME] | [NAME] |  |  | TOTAL | PER UNIT | % INCOME
 | Bedrooms/Baths |  |  |  | 1 | 2.5 |  |  |  | 2 | 2.5 |  |  | 3 | 3.5 |  | 4 | 2.5
 | [NAME]. Ft |  |  |  | 500
 | Stories/Garages |  |  |  | Two Story |  |  |  |  | 2 / 0 |  |  |  | 2 / 1.5 |  |  | Two Story
 | Unit [NAME] |  |  |  | 15.83 | LF |  |  | 15.83 | LF |  |  | 26 | LF |  |  | 26 | LF
 | Mix - Units |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | Mix - %
 | INCOME:
 | Rental Income
 | Vacancy Allowance-5% | 0.05 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | Security Deposit Forfeit
 | Misc. Income:  Vending Machines | 300 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL INCOME:
 | EXPENSES:
 | Management Fee - 5% Total Income | 0.05
 | Unit Maintenance | 250/YR/Unit
 | Grounds Maintenance
 | Cable TV & T-1 | CATV $13+$10 T-1
 | Utilities
 | Advertising/Promotion | 300/YR
 | Property Taxes
 | Property Insurance
 | Liability Insurance
 | Legal
 | Rental Commissions
 | TOTAL OPERATING EXPENSES:
 | MONTHLY NOI:
 | Replacement Reserve $350/u/y
 | Mortgage: 25Y, 7.5%, 80% Value | MortRate
 | MONTHLY NET CASH INCOME:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.35 | 0.45 | 0.5
 | COVERAGE RATIO: NOI/MORTGAGE
 | VALUE @ 10% CAP RATE | 0.1
 | CONSTRUCTION LOAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Value
 | 75% Loan to Cost
 | Cash Equity After C.Profit
 | 90% Loan to Cost
 | Cash Equity After C.Profit
 | 97% Loan to Cost
 | Cash Equity After C.Profit
 | MORTGAGE LOAN @ 80%LTV | LTV | 0.8
 | VALUE @ 9.5% CAP RATE
 | VALUE @ 10.0% CAP RATE
 | VALUE @ 10.5% CAP RATE
 | Total Cost With 15% Profit
 | Permanent Loan Cash Equity
 | Project Equity
 | Investor Return
 | Annual Cash - 50% Share
 | Return on Cash Equity
Spreadsheet: 98254d1297245816-get-the-text-from-one-string-extracting-20the-20text-20from-20the-20string-1-
Sheet: MAIN

ROLE | OUTPUT |  | Marcol | Martin |  |  |  | CHECK with Sheet LIST
ZG_HA_ECC_FI14_AR_ACC_CLK_HU04 | FI14 |  | FI14 | ZGHA |  | FI14_AR_ACC_CLK_HU04 | FI14 | 1
ZG_HU_ECC_FI140_AR_ACC_CLK_HU08 | FI14 |  | [NAME] | [NAME] |  | FI140_AR_ACC_CLK_HU08 | [NAME] | 0
ZG_HU_ECC_FI18_TR_CSH_MGR_HU04 | FI18 |  | FI18 | FI18 |  | FI18_TR_CSH_MGR_HU04 | FI18 | 1
ZG_HU_ECC_FI18_TR_CSH_MGR_HU08 | FI18 |  | FI18 | FI18 |  | FI18_TR_CSH_MGR_HU08 | FI18 | 1
ZG_HU_ECC_FI23_TV_TRA | FI23 |  | FI23 | FI23 |  | FI23_TV_TRA | FI23 | 1
ZG_HU_ECC_CRXD11_WH_OPE_P2_HU02 | LO17 |  | CRXD11 | CRXD1 |  | CRXD11_WH_OPE_P2_HU02 | CRXD11 | 1
ZG_HU_ECC_LO17_WH_OPE_P2_HU04 | LO17 |  | LO17 | LO17 |  | LO17_WH_OPE_P2_HU04 | LO17 | 1
ZG_HU_ECC_LO17_WH_OPE_P2_HU08 | LO17 |  | LO17 | LO17 |  | LO17_WH_OPE_P2_HU08 | LO17 | 1
ZG_HU_ECC_TR02_PRINTER_HU08 | TR02 |  | TR02 | TR02 |  | TR02_PRINTER_HU08 | TR02 | 1
ZG_HA_ECC_TR901_BC_ENDUSER | TR01 |  | [NAME] | ZGHA |  | TR901_BC_ENDUSER | [NAME] | 0
ZG_HU_ECC_CO04_LO_CTL_CLK_HU08 | CO04 |  | CO04 | CO04 |  | CO04_LO_CTL_CLK_HU08 | CO04 | 1
ZG_HU_ECC_CO12_CC_ACC_CLK_HU08 | CO12 |  | CO12 | CO12 |  | CO12_CC_ACC_CLK_HU08 | CO12 | 1
ZG_HU_CR09_CCC_AGT_HU02 | CR09 |  | CR09 | CR09 |  | CR09_CCC_AGT_HU02 | CR09 | 1
ZG_HU_CR09_CCC_AGT_HU04 | CR09 |  | CR09 | CR09 |  | CR09_CCC_AGT_HU04 | CR09 | 1
ZG_HU_CR09_CCC_AGT_HU08 | CR09 |  | CR09 | CR09 |  | CR09_CCC_AGT_HU08 | CR09 | 1
ZG_HU_CR14_VALIDATOR_HU02 | CR14 |  | CR14 | CR14 |  | CR14_VALIDATOR_HU02 | CR14 | 1
ZG_HU_CR14_VALIDATOR_HU04 | CR14 |  | CR14 | CR14 |  | CR14_VALIDATOR_HU04 | CR14 | 1
Extracting the role in the Cell A2 by searching  the items in the "list" tab and give the result in cell B2 for  the corresponding role
Spreadsheet: 05196c0f-cd5c-498b-bc42-fbf2e7aaad7e
Sheet: Sheet1

Table 3--U.S. fiber supply | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Oct. |  | Nov. |  | Dec. |  | Dec
Item | 2013 |  | 2013 |  | 2013 |  | 2012
 | 1,000 480-lb. [NAME]
Cotton:
Stocks, beginning | 2377 |  | 4169 | 2750 | 8810 |  | 12022
Ginnings | 2520 |  | 5405 |  | 3200 |  | 3147
Imports since August 1 | 1.5 |  | 1.5 |  | 1.5 |  | 1.1
 | Million pounds
Manmade:
Production | 566.3 |  | 510.4 |  | 496.7 |  | 450.3
Noncellulosic | 566.3 |  | 510.4 |  | 496.7 |  | 450.3
Cellulosic
Total since January 1 | 5369.5 | 3140.2 | 5879.9 |  | 6376.6 |  | 6082.5
 | Sep. |  | Oct. |  | Nov. |  | Nov.
 | 2013 |  | 2013 |  | 2013 |  | 2012
 | Million pounds
Raw fiber imports: | 152.2 |  | 156.4 |  | 144.9 |  | 143.7
Noncellulosic | 139.7 |  | 142.5 |  | 133.4 |  | 130.3
Cellulosic | 12.5 |  | 13.9 |  | 11.5 |  | 13.4
Total since January 1 | 1401.6 |  | 1558 |  | 1702.9 |  | 1692.9
 | 1,000 pounds
Wool and mohair:
Raw wool imports, clean | 437.1 |  | 919.6 |  | 458.2 |  | 610.2
48s-and-finer | 162 |  | 442.1 |  | 271.4 |  | 498.5
Not-finer-than-46s | 275.1 |  | 477.4 |  | 186.8 |  | 111.8
Total since January 1 | 5798 |  | 6717.5 |  | 7175.8 |  | 8698.1
Wool top imports | 290.2 |  | 107.2 |  | 170.7 |  | 426.8
Total since January 1 | 4200.8 |  | 4308 |  | 4478.7 |  | 4098.1
Mohair imports, clean | 0 | 0 | 0 |  | 0 |  | 0
Total since January 1 | 0 | 0 | 0 |  | 0 |  | 7.2
NA = Not available.
Sources: USDA, National Agricultural Statistics Service;
U.S. Dept. of Commerce, U.S. Census Bureau; and [NAME].
Last update:2/12/14.