-
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 -
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 -
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
-
-------------------------------
06/10/2018 at 15:00 • 0 comments -
SMD Challenge
01/30/2018 at 03:16 • 0 comments