Alcatraz_Energy+Fuel+Expenses_MASTER_(1).xlsx
XLSX spreadsheet 68 KB Posted
- Attached to
- Alcatraz Island Repair Services IDIQ
- Solicitation number
- 140P8618R0006
About this file
Alcatraz PV System Historic Energy Use and Expense Data
View the file
Other files
Show all 22
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Data 44.3% PV System Actual (kWh) Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
A Value from Monthly Princeton Report need to be entered Generator Estimated (kWh) Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
A Value from Monthly Princeton Report need to be entered Island Load (kWh) Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
A Value from Monthly Princeton Report need to be entered Total Energy Generation (kWh) Island Load/Energy Generation Difference (%) Energy loss/Energy Produce=Energy Efficiency PV Energy Production ratio (%) Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
Use this value to generate the Total Energy Production Graph Generator Energy Production ratio (%) Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
Use this value to generate the Total Energy Production Graph Avg Cost of Energy ($) Fuel Price ($/gal) Maintain Fuel Delivery System ($) Maintain Electrical Generation System ($) Diesel Fuel Purchased ($) Total Diesel Generator Expenses ($) Money Saved from PV Energy Generation ($) Diesel Fuel Shipped (gal) Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
| Data from Jeff Obirek need to be entered monthly | Generator Fuel Efficiency (kWh/gal) | Offset Fuel Consumption by PV (gal) | Average Solar Production (%) | |||||||||||||||
| Equation | E = B + C | F= (E-D)/E | G= B/E | H=1-G | I = N/E | M = P*J | N = sum(K:M) | O = R*J | Q = C/P | R = B/Q | ||||||||
| MONTHLY AVERAGE | 22,641 | 28,500 | 43,232 | 51,141 | 15.5% | 44.3% | 55.7% | $0.74 | $6.80 | $4,245 | $15,665 | $17,943 | $37,853 | $14,254 | 2,640 | 11 | 2,098 |
Cryns, Allison: Cryns, Allison:
Extend equation as data is added.
Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
Use this value to generate the Total Energy Production Graph Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
Use this value to generate the Total Energy Production Graph Sandlin, Ayuchi H.: Sandlin, Ayuchi H.:
| Data from Jeff Obirek need to be entered monthly | 2012 Total | 29,393 | - 0 | - 0 | $6.90 | $8,400 | $31,000 | $48,031 | $87,431 | 6,961 | ||||||||
| 2013 Total | 338,163 | 378,105 | 621,173 | 716,268 | 13.3% | 47.2% | 53% | $0.67 | $6.56 | $50,589 | $186,698 | $242,634 | $479,921 | $217,003 | 37,001 | 10 | 33,092 | |
| 2014 Total | 273,698 | 366,547 | 559,131 | 640,245 | 12.7% | 42.7% | 57% | $0.67 | $7.05 | $51,156 | $188,790 | $189,730 | $429,676 | $141,670 | 26,928 | 14 | 20,107 | |
| 2015 Total | 290,171 | 314,659 | 531,010 | 604,830 | 12.2% | 48.0% | 52% | $0.73 | $6.77 | $51,156 | $188,790 | $199,220 | $439,166 | $183,716 | 29,445 | 11 | 27,153 | |
| 2016 Total | 229,394 | 325,955 | 464,850 | 555,349 | 16.3% | 41.3% | 59% | $0.77 | $6.54 | $51,545 | $190,227 | $184,781 | $426,554 | $130,042 | 28,254 | 12 | 19,884 | |
| 2017 Total | 159,950 | 238,250 | 330,197 | 398,200 | 17.1% | 40.2% | 60% | $0.44 | $6.63 | $4,457.73 | $16,451.14 | $153,791 | $174,700 | $103,248 | 23,205 | 10 | 15,579 |
| Nov-12 | 16,794 | 16,794 | $2.63 | $6.90 | $4,200 | $15,500 | $24,467 | $44,167 | ERROR:#DIV/0! | 3,546 | ERROR:#DIV/0! | |||||||
| Dec-12 | 12,599 | 12,599 | $3.43 | $6.90 | $4,200 | $15,500 | $23,564 | $43,264 | ERROR:#DIV/0! | 3,415 | ERROR:#DIV/0! | |||||||
| Jan-13 | 18,360 | 49,523 | 60,311 | 67,883 | 11.2% | 27.0% | 72.95% | $0.76 | $6.49 | $4,200 | $15,500 | $31,736 | $51,436 | $11,766 | 4,890 | 10 | 1,813 | 44.3% |
| Feb-13 | 35,766 | 33,843 | 52,675 | 69,609 | 24.3% | 51.4% | 48.62% | $0.73 | $6.49 | $4,200 | $15,500 | $30,990 | $50,690 | $32,751 | 4,775 | 7 | 5,046 | 44.3% |
| Mar-13 | 28,596 | 43,072 | 64,981 | 71,668 | 9.3% | 39.9% | 60.10% | $0.58 | $6.49 | $4,200 | $15,500 | $21,579 | $41,279 | $14,327 | 3,325 | 13 | 2,208 | 44.3% |
| Apr-13 | 33,015 | 35,906 | 63,089 | 68,921 | 8.5% | 47.9% | 52.10% | $0.60 | $6.49 | $4,200 | $15,500 | $21,417 | $41,117 | $19,693 | 3,300 | 11 | 3,034 | 44.3% |
| May-13 | 34,602 | 33,361 | 54,323 | 67,963 | 20.1% | 50.9% | 49.09% | $0.53 | $6.49 | $4,200 | $15,500 | $16,550 | $36,250 | $17,165 | 2,550 | 13 | 2,645 | 44.3% |
| Jun-13 | 39,488 | 14,940 | 48,790 | 54,428 | 10.4% | 72.6% | 27.45% | $0.51 | $6.31 | $4,200 | $15,500 | $8,203 | $27,903 | $21,681 | 1,300 | 11 | 3,436 | 44.3% |
| Jul-13 | 31,142 | 24,481 | 49,887 | 55,623 | 10.3% | 56.0% | 44.01% | $0.69 | $6.31 | $4,200 | $15,500 | $18,457 | $38,157 | $23,479 | 2,925 | 8 | 3,721 | 44.3% |
| Aug-13 | 33,575 | 17,909 | 45,979 | 51,484 | 10.7% | 65.2% | 34.79% | $0.79 | $6.31 | $4,200 | $15,500 | $21,139 | $40,839 | $39,630 | 3,350 | 5 | 6,280 | 44.3% |
| Sep-13 | 25,904 | 22,913 | 42,922 | 48,817 | 12.1% | 53.1% | 46.94% | $0.84 | $6.31 | $4,200 | $15,500 | $21,139 | $40,839 | $23,898 | 3,350 | 7 | 3,787 | 44.3% |
| Oct-13 | 22,862 | 25,808 | 40,916 | 48,670 | 15.9% | 47.0% | 53.03% | $0.55 | $7.00 | $4,263 | $15,733 | $7,000 | $26,996 | $6,201 | 1,000 | 26 | 886 | 44.3% |
| Nov-13 | 17,330 | 34,459 | 45,053 | 51,789 | 13.0% | 33.5% | 66.54% | $0.64 | $7.00 | $4,263 | $15,733 | $13,300 | $33,296 | $6,689 | 1,900 | 18 | 956 | 44.3% |
| Dec-13 | 17,523 | 41,890 | 52,247 | 59,413 | 12.1% | 29.5% | 70.51% | $0.85 | $7.00 | $4,263 | $15,733 | $30,352 | $50,348 | $12,697 | 4,336 | 10 | 1,814 | 44.3% |
| Jan-14 | 18,706 | 34,188 | 45,851 | 52,894 | 13.3% | 35.4% | 64.63% | $0.72 | $7.00 | $4,263 | $15,733 | $18,200 | $38,196 | $9,958 | 2,600 | 13 | 1,423 | 44.3% |
| Feb-14 | 16,059 | 33,980 | 43,740 | 50,039 | 12.6% | 32.1% | 67.91% | $0.75 | $7.00 | $4,263 | $15,733 | $17,500 | $37,496 | $8,271 | 2,500 | 14 | 1,182 | 44.3% |
| Mar-14 | 20,460 | 32,587 | 45,973 | 53,047 | 13.3% | 38.6% | 61.43% | $0.77 | $7.00 | $4,263 | $15,733 | $21,000 | $40,996 | $13,185 | 3,000 | 11 | 1,884 | 44.3% |
| Apr-14 | 22,849 | 30,441 | 47,027 | 53,290 | 11.8% | 42.9% | 57.12% | $0.80 | $7.00 | $4,263 | $15,733 | $22,750 | $42,746 | $17,076 | 3,250 | 9 | 2,439 | 44.3% |
| May-14 | 31,619 | 21,796 | 47,301 | 53,415 | 11.4% | 59.2% | 40.81% | $0.57 | $7.00 | $4,263 | $15,733 | $10,605 | $30,601 | $15,384 | 1,515 | 14 | 2,198 | 44.3% |
| Jun-14 | 29,148 | 23,286 | 46,614 | 52,434 | 11.1% | 55.6% | 44.41% | $0.70 | $7.00 | $4,263 | $15,733 | $16,450 | $36,446 | $20,591 | 2,350 | 10 | 2,942 | 44.3% |
| Jul-14 | 33,676 | 18,911 | 46,964 | 52,587 | 10.7% | 64.0% | 35.96% | $0.65 | $7.00 | $4,263 | $15,733 | $14,000 | $33,996 | $24,931 | 2,000 | 9 | 3,562 | 44.3% |
| Aug-14 | 27,525 | 25,018 | 45,079 | 52,543 | 14.2% | 52.4% | 47.61% | $0.65 | $7.11 | $4,263 | $15,733 | $14,064 | $34,059 | $15,473 | 1,978 | 13 | 2,176 | 44.3% |
| Sep-14 | 23,293 | 28,276 | 45,287 | 51,569 | 12.2% | 45.2% | 54.83% | $0.78 | $7.11 | $4,263 | $15,733 | $20,264 | $40,259 | $16,693 | 2,850 | 10 | 2,348 | 44.3% |
| Oct-14 | 21,450 | 34,149 | 48,071 | 55,599 | 13.5% | 38.6% | 61.42% | $0.48 | $7.11 | $4,263 | $15,733 | $6,506 | $26,501 | $4,086 | 915 | 37 | 575 | 44.3% |
| Nov-14 | 16,473 | 37,475 | 46,814 | 53,948 | 13.2% | 30.5% | 69.47% | $0.60 | $7.11 | $4,263 | $15,733 | $12,585 | $32,580 | $5,532 | 1,770 | 21 | 778 | 44.3% |
| Dec-14 | 12,440 | 46,440 | 50,410 | 58,880 | 14.4% | 21.1% | 78.87% | $0.61 | $7.11 | $4,263 | $15,733 | $15,642 | $35,638 | $4,190 | 2,200 | 21 | 589 | 44.3% |
| Jan-15 | 18,586 | 41,062 | 52,374 | 59,648 | 12.2% | 31.2% | 68.84% | $0.83 | $7.11 | $4,263 | $15,733 | $29,720 | $49,715 | $13,452 | 4,180 | 10 | 1,892 | 44.3% |
| Feb-15 | 19,447 | 30,709 | 44,035 | 50,156 | 12.2% | 38.8% | 61.23% | $0.84 | $7.11 | $4,263 | $15,733 | $21,899 | $41,894 | $13,868 | 3,080 | 10 | 1,950 | 44.3% |
| Mar-15 | 24,542 | 30,318 | 48,193 | 54,860 | 12.2% | 44.7% | 55.26% | $0.71 | $7.11 | $4,263 | $15,733 | $18,770 | $38,766 | $15,194 | 2,640 | 11 | 2,137 | 44.3% |
| Apr-15 | 27,288 | 26,511 | 47,902 | 53,799 | 11.0% | 50.7% | 49.28% | $0.64 | $7.11 | $4,263 | $15,733 | $14,220 | $34,216 | $14,637 | 2,000 | 13 | 2,059 | 44.3% |
| May-15 | 31,484 | 20,608 | 45,926 | 52,092 | 11.8% | 60.4% | 39.56% | $0.61 | $6.50 | $4,263 | $15,733 | $11,700 | $31,696 | $17,875 | 1,800 | 11 | 2,750 | 44.3% |
| Jun-15 | 34,150 | 14,635 | 42,744 | 48,785 | 12.4% | 70.0% | 30.00% | $0.66 | $6.50 | $4,263 | $15,733 | $12,025 | $32,021 | $28,060 | 1,850 | 8 | 4,317 | 44.3% |
| Jul-15 | 35,299 | 11,745 | 40,579 | 47,044 | 13.7% | 75.0% | 24.97% | $0.57 | $6.50 | $4,263 | $15,733 | $6,825 | $26,821 | $20,512 | 1,050 | 11 | 3,156 | 44.3% |
| Aug-15 | 31,024 | 15,707 | 40,160 | 46,731 | 14.1% | 66.4% | 33.61% | $0.59 | $6.71 | $4,263 | $15,733 | $7,381 | $27,377 | $14,579 | 1,100 | 14 | 2,173 | 44.3% |
| Sep-15 | 23,046 | 23,634 | 39,957 | 46,680 | 14.4% | 49.4% | 50.63% | $0.59 | $6.71 | $4,263 | $15,733 | $7,314 | $27,309 | $7,132 | 1,090 | 22 | 1,063 | 44.3% |
| Oct-15 | 17,013 | 29,328 | 42,522 | 46,341 | 8.2% | 36.7% | 63.29% | $0.82 | $6.71 | $4,263 | $15,733 | $18,218 | $38,213 | $10,568 | 2,715 | 11 | 1,575 | 44.3% |
| Nov-15 | 15,771 | 29,179 | 38,113 | 44,950 | 15.2% | 35.1% | 64.91% | $0.96 | $6.71 | $4,263 | $15,733 | $23,183 | $43,179 | $12,530 | 3,455 | 8 | 1,867 | 44.3% |
| Dec-15 | 12,521 | 41,223 | 48,505 | 53,744 | 9.7% | 23.3% | 76.70% | $0.91 | $6.41 | $4,263 | $15,733 | $28,749 | $48,744 | $8,732 | 4,485 | 9 | 1,362 | 44.3% |
| Jan-16 | 11,800 | 40,950 | 45,596 | 52,750 | 13.6% | 22.4% | 77.63% | $0.82 | $6.41 | $4,263 | $15,733 | $23,076 | $43,072 | $6,649 | 3,600 | 11 | 1,037 | 44.3% |
| Feb-16 | 20,427 | 31,368 | 40,901 | 51,795 | 21.0% | 39.4% | 60.56% | $0.68 | $6.41 | $4,263 | $15,733 | $15,384 | $35,380 | $10,018 | 2,400 | 13 | 1,563 | 44.3% |
| Mar-16 | 18,561 | 33,116 | 43,623 | 51,677 | 15.6% | 35.9% | 64.08% | $0.78 | $6.41 | $4,263 | $15,733 | $20,563 | $40,559 | $11,525 | 3,208 | 10 | 1,798 | 44.3% |
| Apr-16 | 23,696 | 22,415 | 39,077 | 46,111 | 15.3% | 51.4% | 48.61% | $0.72 | $6.41 | $4,263 | $15,733 | $13,141 | $33,136 | $13,891 | 2,050 | 11 | 2,167 | 44.3% |
| May-16 | 22,031 | 23,895 | 38,864 | 45,926 | 15.4% | 48.0% | 52.03% | $0.69 | $6.41 | $4,263 | $15,733 | $11,602 | $31,598 | $10,697 | 1,810 | 13 | 1,669 | 44.3% |
| Jun-16 | 22,439 | 20,443 | 36,225 | 42,882 | 15.5% | 52.3% | 47.67% | $0.74 | $6.41 | $4,263 | $15,733 | $11,538 | $31,534 | $12,665 | 1,800 | 11 | 1,976 | 44.3% |
| Jul-16 | 24,349 | 19,712 | 33,611 | 44,061 | 23.7% | 55.3% | 44.74% | $0.76 | $6.41 | $4,263 | $15,733 | $13,621 | $33,617 | $16,825 | 2,125 | 9 | 2,625 | 44.3% |
| Aug-16 | 21,235 | 23,545 | 37,808 | 44,780 | 15.6% | 47.4% | 52.58% | $0.45 | $6.41 | $4,263 | $15,733 | $0 | $19,996 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | 44.3% | |
| Sep-16 | 21,278 | 16,669 | 31,746 | 37,947 | 16.3% | 56.1% | 43.93% | $0.80 | $6.41 | $4,263 | $15,733 | $10,506 | $30,501 | $13,411 | 1,639 | 10 | 2,092 | 44.3% |
| Oct-16 | 17,585 | 22,770 | 31,614 | 40,355 | 21.7% | 43.6% | 56.42% | $0.91 | $7.19 | $4,458 | $16,451 | $15,753 | $36,662 | $12,166 | 2,191 | 10 | 1,692 | 44.3% |
| Nov-16 | 13,472 | 29,849 | 37,280 | 43,321 | 13.9% | 31.1% | 68.90% | $0.97 | $7.19 | $4,458 | $16,451 | $21,182 | $42,091 | $9,560 | 2,946 | 10 | 1,330 | 44.3% |
| Dec-16 | 11,670 | 42,226 | 49,608 | 53,896 | 8.0% | 21.7% | 78.35% | $0.82 | $7.19 | $4,458 | $16,451 | $23,310 | $44,219 | $6,442 | 3,242 | 13 | 896 | 44.3% |
| Jan-17 | 13,714 | 40,590 | 49,380 | 54,304 | 9.1% | 25.3% | 74.75% | $0.89 | $7.19 | $4,458 | $16,451 | $27,250 | $48,159 | $9,207 | 3,790 | 11 | 1,281 | 44.3% |
| Feb-17 | 16,833 | 28,770 | 37,171 | 45,603 | 18.5% | 36.9% | 63.09% | $0.85 | $7.19 | $4,458 | $16,451 | $17,759 | $38,668 | $10,391 | 2,470 | 12 | 1,445 | 44.3% |
| Mar-17 | 22,433 | 19,929 | 35,268 | 42,362 | 16.7% | 53.0% | 47.04% | $0.86 | $7.19 | $4,458 | $16,451 | $15,480 | $36,389 | $17,425 | 2,153 | 9 | 2,424 | 44.3% |
| Apr-17 | 22,477 | 16,760 | 32,399 | 39,237 | 17.4% | 57.3% | 42.71% | $0.92 | $7.19 | $4,458 | $16,451 | $15,020 | $35,929 | $20,143 | 2,089 | 8 | 2,802 | 44.3% |
| May-17 | 30,810 | 13,045 | 36,000 | 43,855 | 17.9% | 70.3% | 29.75% | $0.66 | $7.19 | $4,458 | $16,451 | $7,952 | $28,861 | $18,782 | 1,106 | 12 | 2,612 | 44.3% |
| Jun-17 | 28,826 | 12,500 | 36,225 | 41,326 | 12.3% | 69.8% | 30.25% | $0.69 | $7.19 | $4,458 | $16,451 | $7,406 | $28,315 | $17,078 | 1,030 | 12 | 2,375 | 44.3% |
| Jul-17 | 24,857 | 22,404 | 33,611 | 47,261 | 28.9% | 52.6% | 47.40% | $0.58 | $7.19 | $4,458 | $16,451 | $6,291 | $27,200 | $6,980 | 875 | 26 | 971 | 44.3% |
| Aug-17 | - 0 | 42,126 | 35,072 | 42,126 | 16.7% | 0.0% | 100.00% | $1.51 | $7.19 | $4,458 | $16,451 | $42,586 | $63,495 | $0 | 5,923 | 7 | 0 | 44.3% |
| Sep-17 | - 0 | 42,126 | 35,072 | 42,126 | 16.7% | 0.0% | 100.00% | $1.14 | $7.19 | $4,458 | $16,451 | $27,099 | $48,008 | $0 | 3,769 | 11 | 0 | 44.3% |
| Oct-17 | - 0 | - 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | $4.94 | $4,458 | $16,451 | $0 | $20,909 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | 44.3% | |||
| Nov-17 | - 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | $4.94 | $4,458 | $16,451 | $0 | $20,909 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | 44.3% | ||||
| Dec-17 | - 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | $4.94 | $4,458 | $16,451 | $0 | $20,909 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | 44.3% |
Total Energy Production Graph
Average Solar PV energy generated Jan, 2013 - Jan, 2015 The graph is automatically generated from the data on 'Sheet1'. To see the formula, click the area of the chart, Chart Tools>Design>Select Data
Alcatraz Island Total Energy Production PV 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 0.27046535951563722 0.51381286902555701 0.39900653011106768 0.47902671174242972 0.50912996777658437 0.72550892922760346 0.55987631015946637 0.65214435552793104 0.53063481983735172 0.46973494966098212 0.33462704435304796 0.29493545183714004 0.35365069762165841 0.32092967485361418 0.38569570380982904 0.42876712328767125 0.59194982682767017 0.55589884426135716 0.64038640728697205 0.52385665074320076 0.45168609048071517 0.38579830572492313 0.30534959590716987 0.21127717391304349 0.31159468884120173 0.38773028152165245 0.44735690849434923 0.50722132381642782 0.60439222913307222 0.70001024905196274 0.7503401071337471 0.66388478740022683 0.49370179948586118 0.36712630284197578 0.35085650723025585 0.23297484370348318 0.22369668246445498 0.39438169707500725 0.35917332662499757 Generators 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 0.72953464048436278 0.48618713097444294 0.60099346988893232 0.52097328825757028 0.49087003222341569 0.27449107077239654 0.44012368984053357 0.34785564447206901 0.46936518016264828 0.53026505033901783 0.66537295564695209 0.70506454816286002 0.64634930237834154 0.67907032514638577 0.61430429619017102 0.57123287671232881 0.40805017317232989 0.44410115573864284 0.35961359271302795 0.47614334925679919 0.54831390951928483 0.61420169427507687 0.69465040409283019 0.78872282608695654 0.68840531115879833 0.61226971847834755 0.55264309150565072 0.49277867618357218 0.39560777086692772 0.29998975094803731 0.24965989286625287 0.33611521259977317 0.50629820051413876 0.63287369715802422 0.64914349276974415 0.7670251562965168 0.77630331753554505 0.60561830292499275 0.64082667337500243 0.48610960508338574 0.52029351565561988 0.47672683177090619 0.4473797689566737 0.5257927646270657 0.43927056157271982 0.56424234915128235 0.68901918238267812 0.78347187175300581 0.74745875073659396 0.63087954739819752 0.47044521033001274 0.42714784514616305 0.29745753049823281 0.30247301940666893 0.47404836969171199 1 1 0 0 0 Average 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 0.44271201395244808 Ratio to total energy production Alcatraz Island Total Energy Production Solar PV 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 18360 35766 28596 33015 34602 39488 31142 33575 25904 22862 17330 17523 18706 16059 20460 22849 31619 29148 33676 27525 23293 21450 16473 12440 18586 19447 24542 27288 31484 34150 35299 31024 23046 17013 15771 12521 11800 20427 18561 23696 22031 22439 24349 21235 21278 17585 13472 11670 13714 16833 22433 22477 30810 28826 24857 0 0 Generators 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 49523 33843 43072 35906 33361 14940 24481 17909 22913 25808 34459 41890 34188 33980 32587 30441 21796 23286 18911 25018 28276 34149 37475 46440 41062 30709 30318 26511 20608 14635 11745 15707 23634 29328 29179 41223 40950 31368 33116 22415 23895 20443 19712 23545 16669 22770 29849 42226 40590 28770 19929 16760 13045 12500 22404 42126 42126 Energy Generated (kWh)
Historic Diesel Data
| Annual Energy Reported Diesel Use | ||||||
| Diesel (gal) | Diesel Offset from PV | Diesel price/gal (avg) | Diesel cost/ year | Diesel cost offset by PV | ||
| 2006 | - 0 | S:\Environmental Management System\Energy_Water\Water_Energy Accounts\FY06\PWR Energy Reporting 2006.xls | ||||
| 2007 | - 0 | S:\Environmental Management System\Energy_Water\Water_Energy Accounts\FY07\PWR Energy Report FY07.xls | ||||
| 2008 | 62,000 | S:\Environmental Management System\Energy_Water\Water_Energy Accounts\FY08\Energy Report Data Collection.xls | ||||
| 2009 | 57,200 | S:\Environmental Management System\Energy_Water\Water_Energy Accounts\FY09\Energy Report Data Collection FY09.xls | ||||
| 2010 | 51,812 | S:\Environmental Management System\Energy_Water\Water_Energy Accounts\FY10\Energy Report Data Collection FY10.xlsx | ||||
| 2011 | 55,612 | S:\Environmental Management System\Energy_Water\Water_Energy Accounts\FY11\Energy Report Data Collection FY11.xlsx | ||||
| 2012 | 54,651 | S:\Environmental Management System\Energy_Water\Water_Energy Accounts\FY12\Updated information 1.2.13\Energy Report Data Collection FY12(1.2.13) .xlsx | ||||
| 2013 | 37,001 | 33,092 | $ 6.56 | $ 242,634 | $ 217,003 | |
| 2014 | 26,928 | 20,107 | $ 7.05 | $ 189,730 | $ 141,670 | |
| 2015 | 29,445 | 27,153 | $ 6.77 | $ 199,220 | $ 183,716 | |
| 2016 | 28,254 | 19,884 | $ 6.54 | $ 184,781 | $ 130,042 | |
| 2017 (to 9/30) | 23,205 | 15,579 | $ 6.63 | $ 153,791 | $ 103,248 |
History of Diesel Fuel Consumption - Alcatraz
| Diesel (gal) | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 (to 9/30) | 62000 | 57200 | 51812 | 55612 | 54651 | 37001 | 26928 | 29445 | 28254 | 23205 | Diesel Offset from PV | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 (to 9/30) | 33092.31341294085 | 20106.943295129957 | 27153.47438020206 | 19884.027169394551 | 15578.760755508918 | Gallons | ||||||||||||
| FY14 | 42278 | 42309 | 42339 | 42370 | 42401 | 42430 | 42461 | 42491 | 42522 | 42552 | 42583 | 42614 | 1000 | 1900 | 4336 | 2600 | 2500 | 3000 | 3250 | 1515 | 2350 | 2000 | 1978 | 2850 | FY15 | 42278 | 42309 | 42339 | 42370 | 42401 | 42430 | 42461 | 42491 | 42522 | 42552 | 42583 | 42614 | 915 | 1770 | 2200 | 4180 | 3080 | 2640 | 2000 | 1800 | 1850 | 1050 | 1100 | 1090 |
| Diesel cost/ year | 2013 | 2014 | 2015 | 2016 | 2017 (to 9/30) | 242634.05750000002 | 189730.2 | 199219.96249999997 | 184781.15999999995 | 153791.13749999995 | Diesel cost offset by PV | 2013 | 2014 | 2015 | 2016 | 2017 (to 9/30) | 217002.84520535966 | 141670.17130026981 | 183715.88207738375 | 130041.53768784033 | 103248.23690713533 | Annual Cost |
Sheet1
| 9/1/2017 1669 139 | 139 |
| 9/2/2017 1531 138 | 138 |
| 9/3/2017 1406 125 | 125 |
| 9/4/2017 1279 127 | 127 |
| 9/5/2017 1143 136 | 136 |
| 9/6/2017 946 197 | 197 |
| 9/7/2017 2089 | |
| 9/8/2017 1942 147 | 147 |
| 9/9/2017 1815 127 | 127 |
| 9/10/2017 1641 174 | 174 |
| 9/11/2017 1481 160 | 160 |
| 9/12/2017 1347 134 | 134 |
| 9/13/2017 2385 | |
| 9/14/2017 2223 162 | 162 |
| 9/15/2017 2070 153 | 153 |
| 9/16/2017 1926 144 | 144 |
| 9/17/2017 1767 159 | 159 |
| 9/18/2017 1603 164 | 164 |
| 9/19/2017 1505 98 | 98 |
| 9/20/2017 1942 | |
| 9/21/2017 1826 116 | 116 |
| 9/22/2017 1644 182 | 182 |
| 9/23/2017 1497 147 | 147 |
| 9/24/2017 1361 136 | 136 |
| 9/25/2017 1193 168 | 168 |
| 9/26/2017 1093 100 | 100 |
| 9/27/2017 2135 | |
| 9/28/2017 2023 112 | 112 |
| 9/29/2017 1845 178 | 178 |
| 9/30/2017 1699 146 | 146 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it.