VBA Randomize a 3x3 Filter for Convoluted Neural Network


EXCEL FOR FINANCE
How to Randomize a 3x3 Filter for a Convoluted
Neural Network in VBA

Option Explicit

Private Sub CommandButton1_Click()

   Application.ScreenUpdating = False
   Application.DisplayStatusBar = False
   Dim i, j As Integer
   Dim randomNumber As Double
   
   For i = 1 To 3
      Randomize
        
           For j = 1 To 3
              randomNumber = rnd()
               'Application.ActiveWorkbook.ActiveSheet.Cells(i + 20, j + 29).Select
               Application.ActiveWorkbook.ActiveSheet.Cells(i + 20, j + 29).Value = randomNumber
           Next j
   
   Next i
   
   Application.ScreenUpdating = True
   Application.DisplayStatusBar = True

End Sub
The effect: 


Piotr Kirklewski 0048787950948

Comments

Post a Comment

Popular posts from this blog

C# - Simple Class Library and how to use it in another project

Image
C# - Simple Class Library and how to use it Create  a Class Library Project Create a new project - Console Application Right click on the newly created project and Set it as a StartUp Project Reason: You cannot run a Class Library on it’s own, it needs to be called from another project. Add a reference to your Class Library project In the SimpleClassLibrary Project - rename the Class to PrintOK and add a public method WriteOK() using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.IO; namespace SimpleClassLibrary { public class PrintOK {     public void WriteOK(){      Console .WriteLine( "OK" );      Console .ReadLine(); } } } Add preprocessor  directive In the UsingClassLibrary project, add the following code: using System; using...
Read more

AWS CLI - INSTALLATION AND CONFIGURATION

Image
AWS CLI - INSTALLATION AND CONFIGURATION https://aws.amazon.com/cli/ Download the MSI installer from here Install as administrator If you haven’t done that before then create your IAM credentials here Access Key ID: AXXXXXXXXXXXXXXXXXXXXQ Secret Access Key : FYYYYYYYYYYYYYYYYYYYYYYYYYYYY2i After the installation is successfully accomplished - open cmd and issue the following command aws configure aws /? Try sns sns /? To get the list of commands that for the sns system You could also use aws help and aws sns help Run the following command: aws sns list-topics
Read more

Upload a file to a Web server in ASP.NET by using Visual C# .NET

Image
Upload a file to a Web server in ASP.NET by using Visual C# .NET Open the Visual Studio Click New > Project ASP.NET WebApplication Name it accordingly When the Project gets created, right click on it and click on Add > New Item > Web Form Name the form FileUpload.aspx Open the FileUpload.aspx the following code <% @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="FileUpload.aspx.cs" Inherits ="ASPFileUpload.FileUpload" %> <! DOCTYPE html > < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < title > FileUpload </ title > </ head > < body >     < form id ="form1" enctype ="multipart/form-data" runat ="server">         < p >< input type ="file" id ="File1" name ="File1" runat ="server...
Read more