Hello,
Someone has written an Excel formulas translator in the Python language.
Python is one of the languages used in my system. I'm going to explore the use of that software as a substitution for my transcription.
If the program includes forward and reverse transformations, I may be able to save/convert data in excel format.
Monday, April 6, 2020
Sunday, March 8, 2020
Backup everything
This post deals with an mportant topic: backups.
All equipment will eventually breakdown.
The only solution is to keep some sort of backup system in stock.
In my case, the current backup is a lower powered version of the present system. This will do until I get something with more power. The current backup will run my light and stereo, provided I don't play the stereo too loud.
I have spare cables and conectors for the solar station.
I have a 300w inverter and a 60A PWM controller.
Panels are not likely to go out or bad for over twenty years. Uless falling tree branches or speeding automobiles are an issue, there's no need for a full backup of panels, though one or two spare panels would be convenient.
If a component goes bad or is damaged beyond repair, I count on at least a week for a replacement to arrive. As an electronic engineering technician, I keep test and repair equipment on hand. I even have backups for those.
My batteries run about $150 each. My inverter runs $150-$250. The controller runs around $150.
If a cloudy day or two occur, I have a quiet 2000w gasoline generator that runs my system and charges the batteries, using an automobile battery charger. The batteries are marine grade dep discharge type.
Using a backup system as emergwncy aid is a good idea.
All equipment will eventually breakdown.
The only solution is to keep some sort of backup system in stock.
In my case, the current backup is a lower powered version of the present system. This will do until I get something with more power. The current backup will run my light and stereo, provided I don't play the stereo too loud.
I have spare cables and conectors for the solar station.
I have a 300w inverter and a 60A PWM controller.
Panels are not likely to go out or bad for over twenty years. Uless falling tree branches or speeding automobiles are an issue, there's no need for a full backup of panels, though one or two spare panels would be convenient.
If a component goes bad or is damaged beyond repair, I count on at least a week for a replacement to arrive. As an electronic engineering technician, I keep test and repair equipment on hand. I even have backups for those.
My batteries run about $150 each. My inverter runs $150-$250. The controller runs around $150.
If a cloudy day or two occur, I have a quiet 2000w gasoline generator that runs my system and charges the batteries, using an automobile battery charger. The batteries are marine grade dep discharge type.
Using a backup system as emergwncy aid is a good idea.
Monday, October 14, 2019
Actuator power relay switch
Actuator power relay switch installed.
I ordered and received a two-relay card. I use a four-channel version to reverse the actuator power for forward and reverse movement.
The two-channel unit controls the actuator power supply battery connection. This unit is controlled from the same script that moves the actuator, hence the solar array.
When the script runs, now, the two-channel unit turns on and connects the battery bank to the boost converter. The boost converter boosts the battery voltage to that needed to drive the actuator, approximately 32vdc-36vdc.
Previously, the unit was connected by manual operation of a mechanical switch.
Wednesday, August 14, 2019
Re-thinking the system
The system is running well. There are some changes that are needed but are difficult to implement.
Roof-top installations are the most popular now, but also the most inefficient. I opted for a single axis, sun tracking, ground mounted system. The most efficient is the two-axis tracking system. The hardware needed is being made, just not for consumers (complaint).
Due to the lack of adequate hardware support by the industry, I've had to innovate my own single axis tracker. There are limitations in the range of movement in the panels. This can be increased by raising the system off the ground and/or adding a linear actuator with a longer reach.
My current system uses one inch galvanized steel pipe as a mounting axis. Two rows of three panels each are mounted, one above the other. The pipe comes in ten foot lengths. The pipe is tilted at an optimum forty-five degrees, for this latitude. This creates a classic Pythagorean Isosceles triangle.
The pipe forms the hypotenuse of the triangle. If I extend the length of the pie by adding a short segment to the bottom, one of the angles will change. To maintain the proportions, I will also have to raise the upper end of the pipe, and possibly add a similar short segment to the top end.
I added a vertical ten foot section of strut to the left side to stabilise the upper and lower rows of panels. I need to add another to the left side.
In thinking this over, I realize I could extend those struts and add at least one more row of panels to the top.
Of course, adding all this extra weight means I may need to replace the one inch pipe with a two inch pipe.
I also consider adding a two foot extension to the bottom of the pipe.
After all this, I'm reconsidering the use of concrete placed rectangular steel tubing along with fixtures to make a dual-axis tracker. The model for this is a unit on YouTube from a Chinese company. I have to consider whether the model is scalable, i.e. whether a larger model will hold more panels safely and scurely. Needless to say, cost is still a factor.
Monday, July 29, 2019
It's that time again.
Every so often, the Raspberry Pi orgnization issues a new release of the operating system for the Raspberry Pi. Most recently, and coincident with the debut of the Rapspberry Pi 4B+, is the Debian Buster operating system. Before Buster were Jessie and Stretch.
When a major update to the operating system is issued, I have to re-format the SD memory card.
Then install the memory image on the card. I have to add a couple of files in order to communicate with the RPi without using an external monitor and keyboard. I can go 'headless' and use my local wifi router and my laptop to run SSH sessions.
Once communications is established, I set some system parameters. Next, I begin downloading and installing programs and other software to run on the RPi.
This process, with testing, can take half a day or more. For this reason, I keep a backup of the SD card once I'm done with updates and modifications. This way, if a card goes bad or some damage occurs, I'll have a spare ready for installation. Just plug and run.
When a major update to the operating system is issued, I have to re-format the SD memory card.
Then install the memory image on the card. I have to add a couple of files in order to communicate with the RPi without using an external monitor and keyboard. I can go 'headless' and use my local wifi router and my laptop to run SSH sessions.
Once communications is established, I set some system parameters. Next, I begin downloading and installing programs and other software to run on the RPi.
This process, with testing, can take half a day or more. For this reason, I keep a backup of the SD card once I'm done with updates and modifications. This way, if a card goes bad or some damage occurs, I'll have a spare ready for installation. Just plug and run.
Monday, November 5, 2018
October - more changes
Hello,
The array is now more exposed to early sunlight. I've cut down trees in the line of sight of morning sun and now get a couple more hours of sunlight. Good timing since the neighbor's tall evergreens and the old oak, on the other side, have begun casting a shadow on the array in the two o'clock zone.
I repositioned the actuator arm's connection to the array, further from the center to get a wider range of azimuths. The array begins at 150 degrees and ends at 210 degrees. This can be increased by raising the array high enough to swing East to 180 degrees and West to 270 degrees, and using an actuator with a thirty inch reach. As is, the array will be stopped by ground contact at current exteemes. Since I've oriented the array South, 180 degrees, and 45 degrees elevation, the optimum for mmy latitude, noon is thirty degrees or 5-6 seconds, and evening is 11-12 seconds of on time.
The array now moves five degrees for each second of on time. A total of twelve seconds moves the array between extremes and across sixty degrees of azimuth.
I've scrapped the old actuator script and now am using a new manual adjustment script until I write a new acuator automation script.
I'm considering using the sensor to align the array instead of calculations or interpolation.
There would need to be coding to eliminate stutters and shakes from minute changes in the environment. A sleep cycle lasting five minutes between moves, would work.
If the ADS1115 should fail, a safety should be triggered to prevent array movement or switch to calculated or interpolated motion and print an error message.
One of the ADS channels has had a problem for sometime. I replaced the ADS1115 with a new unit and the bad channel is still not functioning correctly. The new unit problem channel has an intermittent signal, meaning the wiring is probably faulty. I think I merely twisted the wires together and applied heatshrink. The signals are susceptible to line noise and this shows in the graphs of the channels. Shielded cable is needed, though the differential between channels and ground is correct. Since the readings are correct with respect to each other and five wire shielded cable is expensive, I'll forego the shielded cable unless actuator movement is effected if I use the sensor for array positioning.
I need to solder all joints and connections.
The controller was shutting down USB ports and reopening others, a sort of "wack-a-mole" with USB ports. Eventually, all ports ceased to function. I had read that fusible links were used to protect USB ports from over current states. I have made some unconventional power terminations over the last few months. I decided to keep the controller off line for a few weeks. When I reconnected, I had no problems and have had none since. I now make conventional power terminations. A power switch would be a helpful addition. An update: The problem reoccurred. On the advice of another RPi user, I'll add an FTDI-USB cable/connector. This is supposed to solve the problem. Updating the operating system may also work since the problem seems operating system related.
A month or so past, I did another water check for the battery bank. The usual units needed water added. I had attached the desulphator device, but a month has passed and I have removed the device.
As usual, more batteries are needed and more panels are needed. Two more batteries and six more panels are the near term goal. New or altered mounting of the array is also planned.
Currently, my backup sytem consists of the C-60 Xantrex PW controller (not an MPPT device) and the old three hundred watt sine inverter. The inverter will drive LED lights and the laptop but not much else. Certainly neither of the refrigerators. I'm not sure about the water pump.
I need to get system extra parts: a new MPPT contoller and a new inverter of at least a thousand watts, preferably two or three thousand watts and that is a pure sine wave inverter.
The array is now more exposed to early sunlight. I've cut down trees in the line of sight of morning sun and now get a couple more hours of sunlight. Good timing since the neighbor's tall evergreens and the old oak, on the other side, have begun casting a shadow on the array in the two o'clock zone.
I repositioned the actuator arm's connection to the array, further from the center to get a wider range of azimuths. The array begins at 150 degrees and ends at 210 degrees. This can be increased by raising the array high enough to swing East to 180 degrees and West to 270 degrees, and using an actuator with a thirty inch reach. As is, the array will be stopped by ground contact at current exteemes. Since I've oriented the array South, 180 degrees, and 45 degrees elevation, the optimum for mmy latitude, noon is thirty degrees or 5-6 seconds, and evening is 11-12 seconds of on time.
The array now moves five degrees for each second of on time. A total of twelve seconds moves the array between extremes and across sixty degrees of azimuth.
I've scrapped the old actuator script and now am using a new manual adjustment script until I write a new acuator automation script.
I'm considering using the sensor to align the array instead of calculations or interpolation.
There would need to be coding to eliminate stutters and shakes from minute changes in the environment. A sleep cycle lasting five minutes between moves, would work.
If the ADS1115 should fail, a safety should be triggered to prevent array movement or switch to calculated or interpolated motion and print an error message.
One of the ADS channels has had a problem for sometime. I replaced the ADS1115 with a new unit and the bad channel is still not functioning correctly. The new unit problem channel has an intermittent signal, meaning the wiring is probably faulty. I think I merely twisted the wires together and applied heatshrink. The signals are susceptible to line noise and this shows in the graphs of the channels. Shielded cable is needed, though the differential between channels and ground is correct. Since the readings are correct with respect to each other and five wire shielded cable is expensive, I'll forego the shielded cable unless actuator movement is effected if I use the sensor for array positioning.
I need to solder all joints and connections.
The controller was shutting down USB ports and reopening others, a sort of "wack-a-mole" with USB ports. Eventually, all ports ceased to function. I had read that fusible links were used to protect USB ports from over current states. I have made some unconventional power terminations over the last few months. I decided to keep the controller off line for a few weeks. When I reconnected, I had no problems and have had none since. I now make conventional power terminations. A power switch would be a helpful addition. An update: The problem reoccurred. On the advice of another RPi user, I'll add an FTDI-USB cable/connector. This is supposed to solve the problem. Updating the operating system may also work since the problem seems operating system related.
A month or so past, I did another water check for the battery bank. The usual units needed water added. I had attached the desulphator device, but a month has passed and I have removed the device.
As usual, more batteries are needed and more panels are needed. Two more batteries and six more panels are the near term goal. New or altered mounting of the array is also planned.
Currently, my backup sytem consists of the C-60 Xantrex PW controller (not an MPPT device) and the old three hundred watt sine inverter. The inverter will drive LED lights and the laptop but not much else. Certainly neither of the refrigerators. I'm not sure about the water pump.
I need to get system extra parts: a new MPPT contoller and a new inverter of at least a thousand watts, preferably two or three thousand watts and that is a pure sine wave inverter.
Friday, September 7, 2018
Setpember 7 update
My array is on the side of a hill.
To the East is an overgrown lot with wild trees and weeds.
To the West are several evergreen trees over 30 feet tall. Behind the trees and up the hill is a residence. These reduce the sunlight, especially in Winter when the light is most useful.
Down the hill is an eight foot tall wood plank fence in disrepair.
Up the hill is my residence.
I decided to clear off the overgrown brush on my lower lot, about 50ft by 100ft. I thought I could gain some daylight time in the morning. I did. I bought an electric hedge trimmer and an electric chainsaw. Clearing off the vegetation would be within the capabilities of the tools.
Before I cleared off the most relevant area, I started getting first strong light at ten o'clock. After clearing off that area, my daylight begins at nine o'clock.
If I can get the Eastern brush cleared, I could get first daylight unobstructed for a mile or two.
In summer, daylight is around six or seven in the morning. In Winter, first daylight is closer to seven or eight o'clock.
If I can get the evergreen trees removed on the Western side, I could extend my daylight length by another hour.
These obstruction issues are important. Especially in Winter when the sun rises low in the sky and is less intense. Oddly, the Sun is closest to the Earth early in January, contrary to what most would think. The Earth's nutation is greatest in Winter. This is the backward tilt of the Earth's axis. Locations below the Equator become closer to the Sun and locations North of the Equator become further from the Sun. This is where the seasons come from.
This brings me to an issue I need to think about and make a decision about. If the array is raised above the ground twenty or thirty feet, many of the local obstructions become null factors.
Of course, raising the array above the ground thirty feet, and maintaining the tracking system, is not an easy task.
The roof faces twenty degrees East of South. That is a workable bearing for roof mounting. The problem is the tracking system. A great deal of energy is lost if tracking is not used. The first approach that comes to mind is building a lumber frame attached to the roof to hold the array and tracking apparatus. This will give me both, tracking, and a South pointing direction for the array.
In Summer, there is no shortage of energy with a fixed tilt system. The array is fixed at forty-five degrees, the average tilt for the year. However, in the Winter, energy is more scarce and reorienting the array for Winter would be a good idea. This would require tilting the array forward, at least, twenty degrees. This brings up the question of the pivot point. Midpoint or top? A midpoint pivot is seesaw-like. A top pivot point fixes the bottom of the array pipe and moves the top or mid region. This is more difficult since the array has to stabilized in the lateral direction. This makes the seesaw pivot more attractive.
A tilt parallel to the roof of the house would be 30 degrees. The seesaw midpoint would have to raised off the roof enough to allow movement of the array to a greater degree.
Of some concern is the manner of attaching the lumber framework to the roof. Holes will leak and cause damage to the structure over time.
One possibility is a triangular frame with the top point at, and attached to, the chimney or the house framing there. The system would weigh enough that movement of the lower portion would not be a concern. In this situation, the house, itself, may become an obstacle to daylight, a factor that needs to be considered.
The array, in a simple form would not face directly South, but follow the roof structure. This is where the house, itself, mayblock sunlight.
Other approaches consist of ground mounting the array using long post or poles either embedded
in the ground, or in concrete blocks. The bigest issues with that approach are the difficulty in system maintenance and the permanence of the concrete blocks. Such blocks would be difficult or impossible to move. They take up yard space and are unsightly. If the blocks needed to be removed, a jack hammer would be needed, or a truck with a strong lift.
After a lot of thought about the matter, the last approach, concrete blocks and all, seems the better choice. No risk of damage to the house roof. No complex system to design and install. Direct Southern exposure is available.
If necessary, a deck could be built around the array, for maintenance purposes.
This idea came from another idea. Building a deck on the back of the house and letting the deck double as the array mounting platform. This is the best choice since an attractive deck is added and the array becomes an add on. Long treated lumber posts could be set into the ground or concrete filled containers, and project up and through the deck floor.
This, then, is the best idea, barring some technology I've not read about yet.
The back wall has two doors that can open onto the deck. The deck can be raised a couple of feet from the doorways to make basement access easy and lawn maintenance possible. Slits between deck floorboards are needed to provide drainage and some sunlight to the grass underneath.
If feasible, two arrays, one at each far corner of the deck, should be included in the design.
This will allow me to double my energy production. Combine a doubling of the number of panels with raising the wattage of the panels results in a potential twelve to twenty-four panels. If the panels are two hundred and fifty watts each, a total maximum production of three thousand to six thousand watts will be available. If the panels' wattage is raised to three hundred and fifty watts, the maximum output would be forty-two hundred to eighty-four hundred watts, or 3kW and 6kW or 4.2kW and 8.4kW.
Something to think about.
To the East is an overgrown lot with wild trees and weeds.
To the West are several evergreen trees over 30 feet tall. Behind the trees and up the hill is a residence. These reduce the sunlight, especially in Winter when the light is most useful.
Down the hill is an eight foot tall wood plank fence in disrepair.
Up the hill is my residence.
I decided to clear off the overgrown brush on my lower lot, about 50ft by 100ft. I thought I could gain some daylight time in the morning. I did. I bought an electric hedge trimmer and an electric chainsaw. Clearing off the vegetation would be within the capabilities of the tools.
Before I cleared off the most relevant area, I started getting first strong light at ten o'clock. After clearing off that area, my daylight begins at nine o'clock.
If I can get the Eastern brush cleared, I could get first daylight unobstructed for a mile or two.
In summer, daylight is around six or seven in the morning. In Winter, first daylight is closer to seven or eight o'clock.
If I can get the evergreen trees removed on the Western side, I could extend my daylight length by another hour.
These obstruction issues are important. Especially in Winter when the sun rises low in the sky and is less intense. Oddly, the Sun is closest to the Earth early in January, contrary to what most would think. The Earth's nutation is greatest in Winter. This is the backward tilt of the Earth's axis. Locations below the Equator become closer to the Sun and locations North of the Equator become further from the Sun. This is where the seasons come from.
This brings me to an issue I need to think about and make a decision about. If the array is raised above the ground twenty or thirty feet, many of the local obstructions become null factors.
Of course, raising the array above the ground thirty feet, and maintaining the tracking system, is not an easy task.
The roof faces twenty degrees East of South. That is a workable bearing for roof mounting. The problem is the tracking system. A great deal of energy is lost if tracking is not used. The first approach that comes to mind is building a lumber frame attached to the roof to hold the array and tracking apparatus. This will give me both, tracking, and a South pointing direction for the array.
In Summer, there is no shortage of energy with a fixed tilt system. The array is fixed at forty-five degrees, the average tilt for the year. However, in the Winter, energy is more scarce and reorienting the array for Winter would be a good idea. This would require tilting the array forward, at least, twenty degrees. This brings up the question of the pivot point. Midpoint or top? A midpoint pivot is seesaw-like. A top pivot point fixes the bottom of the array pipe and moves the top or mid region. This is more difficult since the array has to stabilized in the lateral direction. This makes the seesaw pivot more attractive.
A tilt parallel to the roof of the house would be 30 degrees. The seesaw midpoint would have to raised off the roof enough to allow movement of the array to a greater degree.
Of some concern is the manner of attaching the lumber framework to the roof. Holes will leak and cause damage to the structure over time.
One possibility is a triangular frame with the top point at, and attached to, the chimney or the house framing there. The system would weigh enough that movement of the lower portion would not be a concern. In this situation, the house, itself, may become an obstacle to daylight, a factor that needs to be considered.
The array, in a simple form would not face directly South, but follow the roof structure. This is where the house, itself, mayblock sunlight.
Other approaches consist of ground mounting the array using long post or poles either embedded
in the ground, or in concrete blocks. The bigest issues with that approach are the difficulty in system maintenance and the permanence of the concrete blocks. Such blocks would be difficult or impossible to move. They take up yard space and are unsightly. If the blocks needed to be removed, a jack hammer would be needed, or a truck with a strong lift.
After a lot of thought about the matter, the last approach, concrete blocks and all, seems the better choice. No risk of damage to the house roof. No complex system to design and install. Direct Southern exposure is available.
If necessary, a deck could be built around the array, for maintenance purposes.
This idea came from another idea. Building a deck on the back of the house and letting the deck double as the array mounting platform. This is the best choice since an attractive deck is added and the array becomes an add on. Long treated lumber posts could be set into the ground or concrete filled containers, and project up and through the deck floor.
This, then, is the best idea, barring some technology I've not read about yet.
The back wall has two doors that can open onto the deck. The deck can be raised a couple of feet from the doorways to make basement access easy and lawn maintenance possible. Slits between deck floorboards are needed to provide drainage and some sunlight to the grass underneath.
If feasible, two arrays, one at each far corner of the deck, should be included in the design.
This will allow me to double my energy production. Combine a doubling of the number of panels with raising the wattage of the panels results in a potential twelve to twenty-four panels. If the panels are two hundred and fifty watts each, a total maximum production of three thousand to six thousand watts will be available. If the panels' wattage is raised to three hundred and fifty watts, the maximum output would be forty-two hundred to eighty-four hundred watts, or 3kW and 6kW or 4.2kW and 8.4kW.
Something to think about.
Subscribe to:
Posts (Atom)
RPi4 shrink & backup
I decided to make a backup copy of the operating system on the Raspberry Pi 4. A lot of changes were made to the original setup, including...
-
In a recent post I presented the equation for energy incident on a solar panel (Sm). Here I present the set of equations used to calcu...
-
The new web page, for monitoring the solar power station activity, has two charts, one above the other. There are links to a copy of my ol...
-
I've been building my power station with n eye to minimizing the cost without sacrificing quality. I've mounted the array on a...