tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daeb11df-9c23-4d09-8d85-b5328f4f8662
Sheet: Sheet1

Scenario Code | LTC>=3 | LTC>=5 | LTC>=10 | [NAME] | DE=52 | CNI>10 | CNI>100 | [NAME]
vil_def | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2
k19_def | 100 | 81 | 68 | 20 | 73 | 89 | 68 | 1434
k29_def | 65 | 49 | 32 | 16 | 37 | 52 | 30 | 1505
k58_def | 20 | 10 | 2 | 11 | 5 | 18 | 6 | 265
[NAME]
[NAME] | 62 | 20 | 7 | 11 | 13 | 38 | 1 | 135
k29_NCV_0 | 36 | 12 | 1 | 10 | 5 | 23 | 0 | 91
[NAME] | 2 | 1 | 0 | 5 | 0 | 2 | 0 | 21
vil_NCV_8
k19_NCV_8 | 272 | 255 | 252 | 19 | 254 | 256 | 252 | 3752
[NAME] | 174 | 160 | 154 | 21 | 157 | 166 | 154 | 7202
k58_NCV_8 | 62 | 44 | 34 | 16 | 37 | 52 | 37 | 2096
vil_NSA_2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2
k19_NSA_2 | 327 | 311 | 303 | 26 | 306 | 312 | 301 | 4878
k29_NSA_2 | 280 | 257 | 246 | 30 | 251 | 259 | 242 | 11889
k58_NSA_2 | 114 | 67 | 26 | 14 | 49 | 70 | 19 | 449
vil_MTP_0.43 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2
k19_MTP_0.43 | 64 | 35 | 18 | 14 | 27 | 46 | 21 | 660
k29_MTP_0.43 | 47 | 30 | 9 | 14 | 17 | 38 | 11 | 332
k58_MTP_0.43 | 11 | 3 | 0 | 6 | 1 | 9 | 1 | 126
vil_AM_4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2
k19_AM_4 | 33 | 14 | 4 | 12 | 6 | 26 | 6 | 314
[NAME] | 19 | 7 | 2 | 10 | 4 | 21 | 1 | 112
k58_AM_4 | 4 | 1 | 0 | 5 | 0 | 6 | 0 | 49
vil_AM_26 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2
k19_AM_26 | 191 | 159 | 147 | 21 | 153 | 166 | 144 | 3082
k29_AM_26 | 132 | 107 | 89 | 22 | 99 | 116 | 84 | 6564
k58_AM_26 | 48 | 23 | 10 | 15 | 17 | 32 | 19 | 2326
vil_NCPC_150
k19_NCPC_150 | 104 | 67 | 36 | 15 | 51 | 80 | 22 | 532
k29_NCPC_150 | 59 | 31 | 11 | 12 | 18 | 44 | 4 | 139
k58_NCPC_150 | 14 | 4 | 0 | 6 | 0 | 14 | 0 | 31
vil_EC_0.01 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2
k19_EC_0.01 | 107 | 86 | 78 | 18 | 82 | 97 | 76 | 1721
k29_EC_0.01 | 83 | 48 | 34 | 18 | 39 | 63 | 33 | 1639
k58_EC_0.01 | 21 | 4 | 0 | 8 | 1 | 14 | 1 | 171
vil_RPC_high | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2
[NAME] | 135 | 116 | 105 | 18 | 108 | 119 | 103 | 1885
[NAME] | 69 | 53 | 31 | 18 | 46 | 63 | 34 | 1621
k58_RPC_high | 23 | 12 | 3 | 13 | 8 | 18 | 5 | 347
vil_chr | 0 | 0 | 0 | 1 | 1000 | 0 | 0 | 2
k19_chr | 161 | 124 | 88 | 18 | 1000 | 147 | 99 | 1592
[NAME] | 110 | 72 | 33 | 17 | 1000 | 104 | 44 | 1947
[NAME] | 23 | 7 | 2 | 12 | 1000 | 18 | 2 | 216
Table S4. Summary of simulation outcomes for the four historical scenarios (1000 simulation runs for each parameter combination). In addition to the default parameter settings, we ran simulations with variations in selected parameters that had discrepant reported estimates or no direct empirical estimates.
Spreadsheet: 02984e28-d02e-44b7-bf49-f2be1f27690f
Sheet: Sheet1

Date | Agency | [NAME] | Action | Reason
2006-11-15 00:00:00 | [NAME] | Charter Projections | Reduced Self Contained projection from 9 to 4 | Email from [NAME] at Thomas Edison Charter Schools
2006-11-15 00:00:00 | [NAME] | Charter Projections | Reduced Self Contained projection from 13 to 3 | Email from [NAME] at Thomas Edison Charter Schools
2006-11-21 00:00:00 | Salt Lake Arts Academy | Agency Enrollment | Deleted all 60 9th grade students | School does not serve 9th grade
2006-11-21 00:00:00 | Spectrum | Agency Enrollment | Deleted 17 students ratably, with 2 additional subtracted from K | Audit report
2006-11-28 00:00:00 | [NAME] for Deaf and Blind | Agency Enrollment | Deleted all 348 students | According to USDB Supt. [NAME], USDB students should be included in LEA Clearinghouse files
2007-01-10 00:00:00 | [NAME] | Charter Projections | Increased total projection from 625 to 675 and decreased K from 75 to 50 | Updated figure from [NAME] in Charter School Section
2007-02-12 00:00:00 | Jordan | Agency Enrollment | Corrected foreign exchange from 41 to 21 | Discovered a typographical error
Spreadsheet: 860587d1708621642-average-dates-between-a-min-and-max-with-while-sorting-names-and-years-total-productive-maintenance-log
Sheet: Data

Total Mean Time to Repair |  |  |  |  | Average Mean-Time to Repair
Mean-Time to Repair Cost |  | Total Downtime Cost |  |  | Total Cost of Maintenance
Category | 2024 | 2025 | 2026
Breakdown
[NAME]
Inspection
Maintenance
 | 2024 | 2025 | 2026
PPP- |  |  |  | 90.58
 | 2024 | 2025 | 2026
30R- |  |  |  | 47.71
18R- |  |  |  | 47.71
 | 2024 | 2025 | 2026
Shim- |  |  |  | 24.02
WT- |  |  |  | 24.02
WF- |  |  |  | 24.29
Skive-
 | 2024 | 2025 | 2026
Bandline- |  |  |  | 45.28
[NAME] |  |  |  | 45.28
[NAME] |  |  |  | 22.64
 | 2024 | 2025 | 2026
20T- |  |  |  | 47.02
22T- |  |  |  | 47.02
14T- |  |  |  | 46.11
18T- |  |  |  | 47.02
 | 2024 | 2025 | 2026
PE- |  |  |  | 69.21
CH- |  |  |  | 69.21
#1- |  |  |  | 69.21
[NAME] |  |  |  | 69.21
32CTL- |  |  |  | 45.74
TC-2- |  |  |  | 22.64
Spreadsheet: 126160d1319551709-pivot-table-grand-total-not-the-sum-of-the-column-pt-problem
Sheet: Raw Data

Date | D/Order # | From | To | Car Register No | Customer | Quantity | Trip | Amount | Driver | Type of Vehicle | % of Commission
40802 | BTC 173412 | Tungku | [NAME] | BH 2070 | ABASJAYA LOGISTICS SDN BHD | 1 Trip | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40803 | BTC 173413 | Lambak | Muara | BH 2070 | [NAME] FORWARDING (QNP) | 1 trip | 1 | 90 | FAUZAN | Cargo Truck | 0.3
40805 | BTC 173414 | Berakas Power Station | Jerudong Park | BH 2070 | BERAKAS POWER MANAGEMENT CO SDN BHD | 1 Trip | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40807 | BTC 173415 | Seria | Airport | BH 2070 | MULTIMODAL SEA & AIRFRT SVC SDN BHD | 1 Trip | 1 | 140 | FAUZAN | Cargo Truck | 0.3
40807 | BTC 173416 | Beribi | Lambak | BH 2070 | KINGSTON BEVERAGE AND CREAMERY SDN BHD | 11 Pllets | 1 | 60 | FAUZAN | Cargo Truck | 0.3
40809 | BTC 173417 | [NAME] | Lambak | BH 2070 | PS-LIM YING HOCK | 23 Pkgs | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40809 | BTC 173418 | Beribi | Lambak | BH 2070 | KINGSTON BEVERAGE AND CREAMERY SDN BHD | 12 Pllets | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40809 | BTC 173419 | [NAME] | [NAME] | BH 2070 | PENANSHIN JOLLY-B EXPRESS SDN BHD | 34 Bales | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40810 | BTC 173420 | [NAME] | Kg. [NAME] | BH 2070 | CASH | 2 Pkgs | 1 | 0 | FAUZAN | Cargo Truck | 0.3
40809 | BTC 173421 | [NAME] | The Mall,Gadong | BH 2070 | LE MAGNIFIQUE COMPANY | 13 Pkgs | 1 | 0 | FAUZAN | Cargo Truck | 0.3
40809 | BTC 173422 | [NAME] | The Mall,Gadong | BH 2070 | LE MAGNIFIQUE COMPANY | 11 Ctns | 1 | 0 | FAUZAN | Cargo Truck | 0.3
40810 | BTC 173423 | [NAME] | Lambak | BH 2070 | CASH | 1 Trip | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40812 | BTC 173424 | [NAME] | Kiulap | BH 2070 | O.K.K.Y JEWELLERY SDN BHD | 125 Ctns | 1 | 0 | FAUZAN | Cargo Truck | 0.3
40812 | BTC 173425 | [NAME] | [NAME] | BH 2070 | O.K.K.Y JEWELLERY SDN BHD | 42 Ctns | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40815 | BTC 173426 | Gadong | Rimba | BH 2070 | GIANT HYPERMARKET TMC (B) SDN BHD | 1 Trip | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40815 | BTC 173427 | Rimba | Kiulap | BH 2070 | GIANT HYPERMARKET TMC (B) SDN BHD | 1 Trip | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40817 | BTC 173428 | [NAME] | Lambak | BH 2070 | SYARIKAT PERNIAGAAN MALAR SETIA | 10 Plts | 1 | 70 | FAUZAN | Cargo Truck | 0.3
40819 | BTC 173429 | Gadong | Rimba | BH 2070 | GIANT HYPERMARKET TMC (B) SDN BHD | 1 Trip | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40820 | BTC 173430 | [NAME] | Lambak | BH 2070 | SYARIKAT PERNIAGAAN MALAR SETIA | 1 Trip | 1 | 70 | FAUZAN | Cargo Truck | 0.3
40822 | BTC 173431 | [NAME] | [NAME] | BH 2070 | ECONOPAK FORWARDING COMPANY | 3 Pkgs | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40822 | BTC 173432 | [NAME] | Lambak | BH 2070 | SYARIKAT PERNIAGAAN MALAR SETIA | 10 Plts | 1 | 70 | FAUZAN | Cargo Truck | 0.3
40824 | BTC 173433 | [NAME] | [NAME] | BH 2070 | ECONOPAK FORWARDING COMPANY | 38 Units | 1 | 50 | FAUZAN | Cargo Truck | 0.3
40826 | BTC 173434 | Gadong | Rimba | BH 2070 | GIANT HYPERMARKET TMC (B) SDN BHD | 200 Bgs | 1 | 50 | FAUZAN | Cargo Truck | 0.3
Spreadsheet: 824136d1680332292-list-match-based-on-2-partial-strings-test-1-
Sheet: Sheet1

Ref | First 7 characters & PO###### of Col A contained in Col B? | Expected Result
2 Of Brazil's M…KO062276.txt   4 MB |  | Yes
You_Don't_Have…KO062276.txt   3.7 MB
You Don't Have …KO062217.txt   5.2 MB
Untitled (D-Andr…KO062217.txt   3.9 MB |  | Yes
Walking_On_B_O…KO775527.txt   5 MB |  | Yes
Who_Do_You_B…KO775527.txt   5 MB |  | Yes
Thru_My_Rear_V…KO775527.txt   4.2 MB |  | Yes
 | Scenario 1
2 Of Brazil's M…KO062276.txt   4 MB
You_Don't_Have…KO123456.txt   3.7 MB
 | Scenario 2
KO062217
KO123456
Spreadsheet: 44457d1243226049-sum-of-cells-when-cells-show-value-help
Sheet: Sheet1

Qty |  |  |  |  |  |  | price | [NAME] | sale price | profit % | profit $
1 | cl6 |  |  |  |  |  | 6.11 | 0.5 | 9.165000000000001 | 0.3333333333333334 | 3.055000000000001
 |  |  |  |  |  |  |  | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | total | #N/A
Spreadsheet: kate_symes__18512__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-01-26 00:00:00
 | 2001-01-25 00:00:00 |  | 208.12 | 14880 | 179.01 | 6280
 | 2001-01-24 00:00:00 |  | 222.73 | 18880 | 169.8 | 6240
 | 2001-01-23 00:00:00 |  | 251.47 | 12800 | 171.59 | 5800
 | 2001-01-22 00:00:00 |  | 267.54 | 15440 | 185.36 | 2800
 | 2001-01-21 00:00:00 |  |  |  |  |  | 185 | 2400
 | 2001-01-20 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-19 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-18 00:00:00 |  | 326.07 | 5600 | 216.1 | 3080
 | 2001-01-17 00:00:00 |  | 232.5 | 8000 | 179.95 | 3680
 | 2001-01-16 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-15 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-14 00:00:00 |  |  |  |  |  | 128.51 | 4440
 | 2001-01-13 00:00:00 |  | 169.31 | 26800 | 128.51 | 1480
 | 2001-01-12 00:00:00 |  | 170.09 | 18800 | 123.67 | 2400
 | 2001-01-11 00:00:00 |  | 170.09 | 18800 | 123.67 | 2400
 | 2001-01-10 00:00:00 |  | 164.78 | 14800 | 129.9 | 2000
 | 2001-01-09 00:00:00 |  | 155.6 | 14000 | 129.75 | 3200
 | 2001-01-08 00:00:00 |  | 135.72 | 11600 | 102.7 | 2000
 | 2001-01-07 00:00:00 |  |  |  |  |  | 102.7 | 6000
 | 2001-01-06 00:00:00 |  | 139.35 | 10400 | 101.82 | 4400
 | 2001-01-05 00:00:00 |  | 139.35 | 10400 | 101.82 | 4400
 | 2001-01-04 00:00:00 |  | 146.31 | 6400 | 108.22 | 3600
 | 2001-01-03 00:00:00 |  | 146.92 | 4800 | 115.58 | 2400
 | 2001-01-02 00:00:00 |  | 143.57 | 2800 | 120 | 2600
 | 2001-01-01 00:00:00 |  |  |  |  |  | 120 | 7800
 | 2000-12-31 00:00:00 |  |  |  |  |  | 112 | 6000
 | 2000-12-30 00:00:00 |  | 135.5 | 4000 | 112 | 2000
 | 2000-12-29 00:00:00 |  | 176.02 | 3520 | 90.91 | 2200
 | 2000-12-28 00:00:00 |  | 174.87 | 3120 | 90.91 | 2200
 | 2000-12-27 00:00:00 |  | 239.8 | 2000 | 146.18 | 2200
Spreadsheet: 720369d1614119451-filter-formula-to-pull-data-from-matching-range-group-filter-group-example
Sheet: DATA TEST

 | CLASS 1 |  |  | CLASS B |  |  | CLASS 4 |  |  | CLASS G
 | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA
 | [NAME] | 50 | PASS | SAM | 550 | PASS | [NAME] | 51 | PASS | JAKE | 551 | FAIL
 | TOM | 300 | FAIL | WILL | 270 | PASS | FRANK | 301 | FAIL | JENNY | 271 | FAIL
 | BILL | 25 | FAIL | BOB | 15 | PASS | [NAME] | 26 | FAIL | WILMA | 16 | PASS
 | FRED | 250 | FAIL | TOM | 275 | PASS | PAT | 251 | PASS | OLGA | 276 | FAIL
 | SUE | 5 | PASS | [NAME] | 25 | FAIL | [NAME] | 6 | PASS | EUGENE | 26 | PASS
 | [NAME] | 250 | FAIL | HARRY | 50 | PASS | FRED | 251 | PASS | HARRY | 51 | PASS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CLASS: | CLASS 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME: | TOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORE:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRITERIA:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CLASS: | CLASS 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME: | TOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORE: | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRITERIA: | FAIL
Spreadsheet: 855957d1705395327-v-lookup-and-return-row-based-on-cell-value-excel-help-
Sheet: Sheet1

TICKET | NAME | TYPE | DETAILS | STATUS | ETD
1 | Red | Feature | ddsd | IN PROGRESS
2 | Blue | Bug | sdsd | [NAME]
3 | Purple | Mechanic | sdsd | DEPLOYED TM |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
4 | Orange | Feature | sdsd | ARCHIVE 24 |  |  |  |  | 1 | Red | Feature | ddsd | IN PROGRESS | 0
5 | Silver | Bug | fsdfsd | TRIARGE
6 | Blue | Feature | fdsfdsf | DEPLOYED TM |  |  |  |  | [NAME]
7 | Green | Bug | fdfsdss |  |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
 |  |  |  |  |  |  |  |  | 2 | Blue | Bug | sdsd | [NAME] | 0
 |  |  |  |  |  |  |  |  | DEPLOYED TM
 |  |  |  |  |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
 |  |  |  |  |  |  |  |  | 3 | Purple | Mechanic | sdsd | DEPLOYED TM | 0
 |  |  |  |  |  |  |  |  | 6 | Blue | Feature | fdsfdsf | DEPLOYED TM | 0
 |  |  |  |  |  |  |  |  | ARCHIVE 24
 |  |  |  |  |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
 |  |  |  |  |  |  |  |  | 4 | Orange | Feature | sdsd | ARCHIVE 24 | 0
 |  |  |  |  |  |  |  |  | TRIARGE
 |  |  |  |  |  |  |  |  | TICKET | NAME | TYPE | DETAILS | STATUS | ETD
 |  |  |  |  |  |  |  |  | 5 | Silver | Bug | fsdfsd | TRIARGE | 0
Spreadsheet: 170356d1343242525-moving-data-with-index-and-match-for-pricing-sheet-ef136_copy-of-revised-pricing
Sheet: Estimate

CUSTOMER |  |  |  | PHONE NUMBER
INTERIORS |  |  |  | DOOR
Code | [NAME] |  | DEPTH | SQ.FT | QUANITY | COLOR | COST
W2412 |  |  |  |  |  | WHITE MEL.
Spreadsheet: 701877d1603977638-equation-for-averaging-cells-that-include-signs-excel-help
Sheet: Sheet1

I came across the example below  and I wanted to know how to make the result show <2 in cell J54 in these situations.  No sample can be reported at a value lower than 2.
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 106 | 200 | 4 | 8.04 | 5.84 |  | 1.27
 | 107 | 180 | 4 | 8.15 | 6.05 |  | 1.27
 | 108 | 150 | 4 | 8.29 | 6.31 |  | 1.27
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Average:
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 109 | 200 | 4 | 8.17 | 6.02 |  | 1.27
 | 110 | 180 | 4 | 8.28 | 6.16 |  | 1.27
 | 111 | 150 | 4 | 8.45 | 6.47 |  | 1.27
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Duplicate Average:
 |  |  |  |  |  |  | Duplicate % Recovery (<20%):
 |  |  |  |  |  |  | Effluent & Duplicate Average:
Spreadsheet: 865469d1712556969-calculate-max-borrowing-based-on-funds-available-cell-and-lvr-of-88-investment-property-spreadsheet-example
Sheet: Proposed Analysis

POTENTIAL PROPERTY ANALYSIS
 | MINIMUM INPUTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC
 |  | Proposed Property Address: |  |  |  |  |  | Enter the address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC | 2.5% (40 Yrs) |  |  |  | NSW
 |  | Proposed Purchase Price: |  |  |  |  |  | 600000 |  |  |  |  |  | State: |  |  |  | VIC |  |  |  |  |  |  |  | NSW | 4.0% (25 Yrs) |  |  |  | SA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD |  |  |  |  | WA
 |  | Proposed Loan Amount: |  |  |  |  |  | 575100 |  |  |  |  |  | Proposed LVR: |  |  |  |  |  |  |  |  |  |  |  | SA |  |  |  |  | TAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA |  |  |  |  | NT
 |  | Proposed Rental Amount: |  |  |  |  |  | 550 |  | Per Week |  |  |  | Stamp Duty: |  |  |  |  |  |  |  |  |  |  |  | TAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NT
 | OPTIONIAL INPUTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACT
 |  | Capital Growth Rate: |  |  |  |  |  |  |  |  |  | Consumer Price Index: |  |  |  |  |  | 0.03
 |  |  |  | Property Expenses: |  |  |  |  |  |  |  |  |  | Loan Interest Rate: |  |  |  | 0.065
 |  |  |  | [NAME]: |  |  |  | Interest Only Repayments |  |  |  |  |  | Dwelling Cost:
 |  |  |  | Deprecication Calculation: |  |  |  | 2.5% (40 Yrs)
 | STATISTICS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I want to calculate the potential purchase price based off the amount of funds avaialble in Cell E51 and continued all the way up to cell W51 if each year and a [NAME] loan to value ratio of 88%, like the example provided above.  If you are not sure what Loan to Value ratio is it is calcuated as the % of the loan balance against the value of the property  This potential price has nothing to do with the property details at the top.  This is based on the available equity in the property, how much they could spend on the next property.  I understand this might be a difficult calculation and that is why I require help
 |  | Today |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Year 6 |  | Year 7 |  | Year 8 |  | Year 9 |  | Year 10
 | Property Value:
 | Equity In Property:
 | Property Growth %: | 0
 | LVR:
 | Loan Balance: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q
 | Surplus to reinvest: |  |  | 19680 |  | 23422
 | Purchase Power: | 0 |  | 104766
 | Rental Income:
 | [NAME] Yield:
 | Net Rental Yield:
 | DEDUCTIONS
 | Property Expenses:
 | Loan Interest Payments:
 | Loan P & I Payments:
 | Pre-Tax Cashflow p/a:
 | Pre-Tax cashflow p/w:
 | NON - CASH DEDUCTIONS
 | Depreciation:
 | FINAL ANALYSIS
 | Total Deductions:
 | Net Profit or Loss:
 | Tax Refund:
 | Land Tax:
 | After-Tax Cashflow p/a:
 | After-Tax cashflow p/w:
Spreadsheet: joe_parks__15035__BridgeDPR0606
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1103.240170299997 | 6258.240170299998 | 11549.2401703
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1103.240170299997 | 6258.240170299998 | 11549.2401703
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: rick_buy__32758__0827_Violation
Sheet: Sheet1

 | To: |  | [NAME], [NAME] and [NAME]
 | Copy to: |  | Distribution
 | From: |  | Global Risk Management Operations
 | Date: |  | 2001-08-28 00:00:00
 | Re: |  | Limit Violations and Notifications for August 27, 2001
 |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  | Violation/
 |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  | ($MMs) |  |  |  |  |  | ($MMs) |  | ($MMs)
1 | Enron Office of the Chair |  | EOL 24/7 Crude Trading | B |  | 2 Mil Bbl WTI | Net Open Position | (4.72) Mil Bbl WTI | 31 |  | -4308 |  | -32750 |  |  | Due to the $2 October 2001 price increases, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
2 | Enron Office of the Chair |  | EOL 24/7 Crude Trading | B |  | 3 Mil Bbl WTI | Maturity Gap Risk | (4.73) Mil Bbl WTI | 23 |  | -4308 |  | -32750 |  |  | Due to the $2 October 2001 price increases, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
3 | Enron Office of the Chair |  | EOL 24/7 Crude Trading | B | 3 |  | VAR | 3.3 | 17 |  | -4308 |  | -32750 |  |  | The Crude EOL VAR violation is due to the portfolio having a 4.73 million bbl short position and the September Nymex contract increased $.27/bbl.
4 | Enron Americas |  | Gas Trading | B |  | 200 Bcf | Maturity Gap Risk | (421) Bcf | 55 |  | 2710 |  | 667998 |  |  | The Maturity Gap Risk violation is driven by short fixed price positions in the three month period between March 2002 and May 2002. The Financial Desk is carrying the majority of those positions, (369) Bcf, between March 2002 and May 2002.
5 | Enron Americas |  | Gas Trading | B |  | 500 Bcf | Net Open Position | (586) Bcf | 21 |  | 2710 |  | 667998 |  |  | The Net Open Position violation is driven by Alberta Power Desk’s (244) Bcf short gas positions, U.S. Natural Gas trading (206) Bcf short positions and Cross Commodity (73) Bcf short positions.
6 | Enron Global Markets |  | Global Products | B | 15 |  | VAR | 15.8 | 17 |  | -4308 |  | -32750 |  |  | Discretionary VaR of $2.5 million expired; Global Products is in the process of re-applying for discretionary VaR.
 | B= Business Unit Violation |  | C= Concentration Violation
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: stacey_white__39047__10222001WestPosition Copy
Sheet: West Power Pos Change

West Power Position Change
Peak Positions
Off Peak Positions
Total Position Change
Spreadsheet: 14097180-ee7c-4799-90cc-c08ede1ad843
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
260985 | 63776 | [NAME] | Dewalque | IRL | 81 | 00:51:56 | 00:07:22 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 838496d1691066413-multiple-condition-based-on-the-multiple-status-reference-11
Sheet: Sheet1

Low | Medium | High | Very High | Catastrophic |  | Status
1 | 1 | 1 | 2 | 1 |  | Catastrophic |  |  |  | Low | Combination of medium/low severity (should not be > 3 medium severity, otherwise rating should be upgraded into Medium)
 |  |  |  |  |  |  |  |  |  | Medium | Combination of at least 1 high finding and medium/low findings
Low | Medium | High | Very High | Catastrophic |  |  |  |  |  | High | Combination of 2-3 high findings and medium/low findings
1 | 1 | 2 | 3 | 0 |  | Catastrophic |  |  |  | Very High | <2 very high or >4 high findings and high/medium/low findings
 |  |  |  |  |  |  |  |  |  | Catastrophic | >1 Catastrophic or >3 very high findings and high/medium/low findings
Low | Medium | High | Very High | Catastrophic
1 | 1 | 3 | 1 | 0 |  | Very High
Low | Medium | High | Very High | Catastrophic
1 | 1 | 4 | 0 | 0 |  | Very High
Low | Medium | High | Very High | Catastrophic
1 | 3 | 3 | 0 | 0 |  | High
Low | Medium | High | Very High | Catastrophic |  | High
3 | 3 | 2 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Medium
3 | 2 | 1 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Medium
4 | 3 | 0 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Low
5 | 2 | 0 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Low
5 | 1 | 0 | 0 | 0