-
What a pain
01/07/2022 at 14:41 • 0 commentsVBA Excel Script
Private Sub CommandButton1_Click() Module1.createLetters End Sub # Module1 ############################################################### Dim LColumns(16383) As String ---------------------------------------------------------------------------------------------------------------------------------- Sub createLetters() Module1.setColumns Sheets.Add.Name = "Letters" For x = 0 To 16383 Sheets("Letters").Cells(1, x + 1).Value = LColumns(x) Sheets("Letters").Cells(2, x + 1).Value = x Next x ActiveWorkbook.Save End Sub --------------------------------------------------------------------------------------------------------------------------------------------------- Sub setColumns() Dim col_count As Integer Dim letters As Variant Dim ColumnL As String letters = Array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z") col_count = 0 While col_count < 16384 If col_count < 26 Then ColumnL = letters(col_count Mod 26) ElseIf (col_count >= 26) And (col_count < ((26 * 26) + 26)) Then ColumnL = letters(Int((col_count / 26) - 1) Mod 26) & letters(col_count Mod 26) Else If Int((col_count / 26) - 1) Mod 26 < 25 Then ColumnL = letters(Int((col_count / 26 / 26) - 1)) & letters(Int((col_count / 26) - 1) Mod 26) & letters(col_count Mod 26) Else ColumnL = letters(Int((col_count / 26 / 26) - 2)) & letters(Int((col_count / 26) - 1) Mod 26) & letters(col_count Mod 26) End If End If LColumns(col_count) = ColumnL col_count = col_count + 1 Wend End Sub
Python
letters = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'] col_count = 0 columns = [] while col_count < 16384: if col_count < 26: column = letters[col_count%26] elif col_count >= 26 and col_count < (26*26) + 26: column = letters[(int(col_count/26)-1)%26] + letters[col_count%26] else: if int(col_count/26)-1)%26 < 25: column = letters[(int(col_count/26/26)-1)%26] + letters[(int(col_count/26)-1)%26] + letters[col_count%26] else: column = letters[(int(col_count/26/26)-2)%26] + letters[(int(col_count/26)-1)%26] + letters[col_count%26] col_count += 1 columns.append(column)
-
Light up Octopus
03/21/2021 at 16:00 • 0 comments -
Practicality of Wireless Communication Underwater
05/15/2020 at 02:49 • 0 comments433Mhz radios communicate better than expected in fresh water, and can even break the surface barrier. Still have to test the results with 915Mhz, and 2.4Ghz, and test everything in salt water.
-
Serial Over USB on BBB
05/15/2020 at 02:06 • 0 commentshttp://m-embedded.blogspot.com/2015/03/embedded-serial-over-usb-on-beaglebone.html (this is old, but simpler now)
sudo modprobe g_serial stty -F /dev/ttyGS0 raw stty -F /dev/ttyGS0 -echo cat /dev/ttyGS0
Then connect to available com port:
Not perfect, but it will do.
BBB:
import serial comm = serial.Serial("/dev/ttyGS0", 9600) while True: data = comm.read_until(b'\r\n') print(data) comm.write(data)
PC:
import serial comm = serial.Serial("COM21", 9600) while True: comm.write(b"This is a test.\r\n") data = comm.read_until(b'\r\n') print(data)
-
tensorflow - cudnn
03/04/2020 at 17:25 • 0 commentsJetpack 42 - CuDNN 7.5.0
Jetpack 43 - CuDNN 7.6.3
-
Beaglebone Black 3v3 Regulator Bug
01/15/2020 at 21:35 • 0 commentsUsed this fix:
https://groups.google.com/forum/#!msg/beagleboard/7sxPePT7wkM/_oNSCta5WusJ
for this problem, as recommended:
https://elinux.org/BeagleBone_Power_Management
Seems to be working well.
-
DCR006
11/26/2018 at 04:50 • 0 comments -
Hacking tractors
10/31/2018 at 23:29 • 0 commentsMy question is, we are at the point that we can refine upon any definition of efficiency we choose. Be it a working business model, grain production and harvesting, etc... as to this guys point, it only makes a little bit of sense to keep making bigger more efficient ag equipment. Why not figure out the point where it makes the most sense to say we will build a combine only so big, but we need X number of farmers in the country to run them. Agriculture should not be run by large corporations or conglomerates. There is no heart in the heartland when this happens.
Like the idiot Americans we are we would rather make sure that morons own guns because it is constitutional, than focus on the ground we are losing beneath our feet.
I have spent a fair amount of time on a farm, and I have yet to think of anything that couldn't be improved on, and most things in a major way.
-
BBBW thinks it is a BBB
10/21/2018 at 13:11 • 0 commentsI bought a Beaglebone Black Wireless a few days ago, and this is my first time using them. I wanted it specifically to use it as a wireless access point, however I was met with several hours of frustration in trying to figure out why ifconfig would list an ethernet port, but no wlan0.
This saved the day: https://groups.google.com/forum/#!category-topic/beaglebone/PUPLXFkJsaI
-
Holy Grail
07/31/2018 at 01:16 • 0 comments -
-------------------------------
06/10/2018 at 15:00 • 0 comments -
SMD Challenge
01/30/2018 at 03:16 • 0 comments -
just because most people think of Tom hanks when they think of forest gump.
08/04/2017 at 18:13 • 0 commentsWhen I reflect on things this always comes to mind.
"But let me tell you this: sometimes at night, when I look up at the stars, an see the whole sky jus laid out there, don't you think I ain't rememberin it all. I still got dreams like anybody else, an ever so often, I am thinkin about how things might of been. An then, all of a sudden, I'm forty, fifty, sixty years ole, you know?
Well, so what? I may be a idiot, but most of the time, anyway, I tried to do the right thing-- an dreams is jus dreams, ain't they? So whatever else has happened, I am figgerin this: I can always look back an say, at least I ain't led no hum-drum life.
You know what I mean?"-Winston Groom, Forest Gump
-
Playing with the Hackaday - Belgrade Page
02/23/2016 at 00:24 • 0 comments -
Random Puzzle
11/17/2015 at 17:24 • 8 comments10110111 10110111 11011111 10110111 10101001 11011111 10101001
11011111 10111101 11011111 11001110 11011111 11001101 11001111
11011111 11001110 11001110 11011111 10111110 10101001 11011111
10111101 10101100 11011111 10111100 10111000 11011111 10111011
10110011 11011111 10111001 10101010 11011111 10110111 10100101
11011111 10110110 10110001 11011111 10110100 10110010 11011111
10110000 10101000 11011111 10101101 10100111 11011111 10101000
10100111 10111100
LMCJXTTVUWUGUQRWFAGNTRPHNXVMZFBVAGSWQVZQCZKDXO
WTDLMNRYNTVFFALXLNMWWAERLAHDCJPKWEYRZOETIWVNFLC
ETHFZTTBOYDODNZBTDGOYKPMHZNOBICFHRNVBULUNLTJPVRA
HXMFDKXYVDCRNMKQVSLLDVANJJHJKUEUYJBLZHHHEDLYNPFN
ZJRADXFBNTQAPCAADUQZHZTBHDWQHWDMCOZRTQAKUXZSCX
RZNSZNCTWMEHMTSXRYMANXPMCURNGDERSIPVLLOUPYXECS
LGBYFDXIEPLBHIRJTOYMCYCADOFBHNTODPTCWPMKJXKVSWH
TINWJKPHLXDSPRMYGIEDVJWKTDCOGTTLGTHZFWBEXZLECRTI
HANJQBDFCLJYRHLLHUJZLFMFLQTHJHZDAKDHBOAVBANINGRK
BDNEOTULNIDOZWLRCENSRHROXCYFPSFQMONHBQAEELLOH
GUEYKNARFYJJOURVGONUMGZNGYOTSZLIODFTGIHVPULLLH
RYCFLORWZK -
LightBlue Bean Arrived!
05/12/2015 at 23:02 • 1 commentThanks Hackaday! Can't wait to try it out.
-
Home SDN - maybe
03/25/2015 at 02:15 • 1 commentAn Introduction To Software Defined Networking (SDN Tutorial):
Prof. Jennifer Rexford - Frenetic: A Programming Language for Software D...:
-
Gravity
03/07/2015 at 19:24 • 8 commentsThis is just a random page for me (and anyone else who feels so inclined) to post links for the things found on the topic.
I can not speak for anyone else, but I have found the topic of gravity confounding at both the cosmic and quantum levels. While I think that I understand, at least at some level, what Einstein proposed and I get some of the concepts of quantum mechanics, but from what I gather, gravity at a quantum level us best summed up as "?", and for a better answer than that a subscription to some school of thought is required. So, I have made my subscription in the following:
"Gremlins
A new interpretation, presented for the first time here, is that there are little green gremlins hovering around, going backwards and forwards in time, shaking hands and collapsing with mirth as they poke and prod subatomic particles in a way they calculate most likely to confuse us. This explains all of the observed experimental results, but it does introduce gremlins, and the need for a further theory about why they should want to confuse us. Using the principle of Ockham's razor, this interpretation will probably not find much popularity among the scientific community although it may be the basis for a new religion. Watch this space.
What happens to the Cat? Depends on what the gremlins think will confuse us most."
(http://www.higgo.com/quantum/laymans.htm)
Out side of the above, having spent quite a lot of time in the water, I thoroughly enjoy the idea of space being some type of "superfluid". From this I have come to view gravity as something as a false force along the same lines as centrifugal force, due to gravity being the result of matter displacing space (or maybe gravity is real and time is a false force, I am undecided). If I understand correctly this is somewhat in line with Einstein's gravity being a property of space. As for what this "superfluid" is composed of I am odds with because this whole concept comes back around to the aether idea, but just the same I am going with unexcited photons. This seems the most plausible to me because I am apprehensive to come to terms with the idea of the light bulb just releasing an endless supply of photons. It would make sense to me that as one descends out of space and into the atmosphere the space between the nucleus and electrons is still composed of space (in this case photons) and continues to be so to a lesser and lesser extent until the core is reached and then the process is reversed when continuing on to the other side. Additionally, the Centennial Bulb (http://www.centennialbulb.org) stays lit by good craftsmanship, and an answer for the endless supply of photons. So until gremlins and a sea of photons have been irreconcilably disproved I will continue to post links to support my argument.