You can input to Excel if VBA is accessible to you:
1. Open Visual Basic Editor: Tools/Macro/Visual Basic Editor - shortcut is alt F11
2. In VB Editor View/Project Explorer - shortcut is ctrl+r
3. Right click in Project Explorer and choose Insert Module
4. Paste this code in code module window
Code:
Public Sub InputToExcel()
Dim nA, n23456, n789, nT As Integer
Dim n As Long
Worksheets("Sheet1").Activate
Cells(1, 1).Value = "A"
Cells(1, 2).Value = "23456"
Cells(1, 3).Value = "789"
Cells(1, 4).Value = "T"
Range(Cells(1, 1), Cells(1, 4)).HorizontalAlignment = xlHAlignCenter
Range(Cells(1, 1), Cells(1, 4)).Font.Bold = True
Range(Cells(1, 1), Cells(1, 4)).Borders.LineStyle = xlDouble
n = 1
For nA = 0 To 8
For n23456 = 0 To 40
For n789 = 0 To 24
For nT = 0 To 32
Cells(n + 1, 1).Value = nA
Cells(n + 1, 2).Value = n23456
Cells(n + 1, 3).Value = n789
Cells(n + 1, 4).Value = nT
Range(Cells(n + 1, 1), Cells(n + 1, 4)).HorizontalAlignment = xlHAlignCenter
n = n + 1
Next nT
Next n789
Next n23456
Next nA
End Sub
You can run code in VB Editor from Run Menu/Run Sub/UserForm - shortcut is F5.
You can also run from main Excel Window Tools Menu/Macros/InputToExcel after code has been pasted in module.
You will get 304425 rows of data. My version of Excel is limited to 65536 rows but I think newer versions can handle this.
good luck.
k_c
Bookmarks