Technical Specifications

SheetKraft is an automation framework geared towards automating spreadsheet based processes.

The software has three components:

  1. Microsoft Excel Add-on: This is installed on the user's profile on his / her desktop. It helps business users specify the process steps via a user interface within the excel spreadsheet.
  2. SheetKraft Server: This is a software which sits on a server and is capable of running processes setup via the Excel add-on. Multiple users can log on to the server and users will be allowed to setup processes which can then be run on the server.
  3. Database: This holds all the application data.

Application Server Requirements:

  • Windows Server 2012 or above (64-bit) with the latest service pack installed
  • 3 GHz quad core processor or better is recommended
  • 16+ GB RAM available for SheetKraft processes
  • 500 GB of free disk space (required for installation, log files, temporary files, and user input files)
  • .NET Framework 4.7.2 or above
  • Windows Powershell 4 or above
  • SSL Certificate to enable https protocol (if https is required)
  • Connectivity to database server
  • Connectivity to Active Directory servers and database servers (if such integration is desired)
  • Administrative access during initial installation and at the time of applying patches.
  • A functional Id which has admin access to the server to run the application pool, activity runner and access shared folder from the server. A functional Id is a user account whose password will not expire.

Database Server Requirements:

  • SQL Server 2012 or above (with the latest service pack installed) or PostgreSql Version 11 and above. This may require .NET Framework 3.5 and .NET Framework 4.7.2
  • 3 GHz quad core processor or better is recommended
  • 8+ GB RAM
  • 500 GB of disk space (required for the database)
  • Permissions to create a database (during initial installation) and create users with full access to that database (The installation tool generates a script that does this. This script may be run by a database administrator if permissions are not granted)

Development Machine Requirements (for development and maintenance):

  • 64 bit Microsoft Excel 2013 or above
  • 100 GB of disk space (required for installation of SheetKraft Add-in and temporary files)
  • Windows 7 or above (with latest service pack) 64 bit
  • 3 GHz dual core processor or better is recommended
  • 8 GB RAM or more (16 GB is recommended)
  • .Net Framework 4.7.2 or above
  • Visual C++ Redistributable 2015
  • SQL Server Management Studio (latest version)
  • Connectivity to Active Directory servers for user logins (if such integration is desired)
  • Connectivity to Database Server
  • Remote Desktop access to Application Server
  • Unrestricted permission to download files from (This is required for applying patches)
  • Administrative access to install any other useful software (If this is not provided, considerable delays can occur during implementation)

Client Requirements (for web access):

  • Most recent two versions of any web browser (IE, Chrome, Firefox, Safari)

Note: Any pre-requisites for any of the above mentioned software need to be installed on the machines.