Skip to main content

Help us improve the Digital Marketplace - send your feedback

Millersoft Ltd

Sheetloom

Sheetloom decision intelligence integrates Excel with source data using SQL,CSVs, and APIs. Populate pivots, sheets and named ranges from source without any copy/paste or open database connections. Can Integrate with Power Pivot for unlimited rows of data. Deploy into own AWS, or access through Sheetloom hosted tenant account.

Features

  • Automatically extract, copy/paste data into spreadsheet from any source
  • Capture and analyse historic positons
  • Automatically update spreadsheet ranges, sheets, or pivot tables/charts
  • Secure, audited access to consistent spreadsheets
  • User access decoupled from access to the underlying data sources
  • Affordable scaling ensures single source of truth across the organisation
  • Connect to any data source using SQL, CSV, API
  • Dynamic and rich results by blending data from multiple sources
  • Remote access on any device
  • Blend multi source data directly into Excel ranges or sheets

Benefits

  • Consistent and error free spreadsheets across the organisation or agency
  • Time saving from reduced manual creation and maintenance of spreadsheets
  • Minimal set-up- design a spreadsheet and link it to Sheetloom
  • Enhanced security: no user connections to data sources are required
  • Low licence fee options make scaling cost effective
  • Easily keep spreadsheet models and reports current with one click
  • Capture historic positions without the cost of a data warehouse
  • Avoid "SpreadMarts"; get a single source of truth with Excel.

Pricing

£10 a licence a month

  • Free trial available

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at gerry@millersoftltd.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 14

Service ID

9 4 3 1 9 7 2 2 3 5 8 0 1 2 7

Contact

Millersoft Ltd Gerry Conaghan
Telephone: 0131 376 7114
Email: gerry@millersoftltd.com

Service scope

Software add-on or extension
No
Cloud deployment model
  • Public cloud
  • Private cloud
Service constraints
None
System requirements
None

User support

Email or online ticketing support
Email or online ticketing
Support response times
Standard support normally within 4 business hours.
User can manage status and priority of support tickets
No
Phone support
Yes
Phone support availability
9 to 5 (UK time), Monday to Friday
Web chat support
No
Onsite support
No
Support levels
L1: Tier/Level 1(T1/L1)
Initial support level responsible for basic customer issues. Gathering information to
determine the issue by analysing the symptoms and figuring out the underlying problem.
L2: Tier/Level 2(T2/L2)
This is a more in-depth technical support level than Tier I containing experienced and more
knowledgeable personnel on a particular product or service.
L3 Tier/Level 3(T3/L3)
Individuals are experts in their fields and are responsible for not only assisting both Tier I and
Tier II personnel, but with the research and development of solutions to new or unknown
issues.
Severity Definitions
1- Critical: Proven Error of the Product in a production environment. The Product Software
is unusable, resulting in a critical impact on the operation. No workaround is available.
2- Serious: The Product will operate but due to an Error, its operation is severely restricted.
No workaround is available.
3- Moderate: The Product will operate with limitations due to an Error that is not critical to
the overall operation. For example, a workaround forces a user and/or a systems
operator to use a time consuming procedure to operate the system; or removes a nonessential
feature.
4- Due to an Error, the Product can be used with only slight inconvenience.
Support available to third parties
Yes

Onboarding and offboarding

Getting started
User documentation on website
Video tutorials and feature guides
Online training covering the basics of set up and use of the service.
Assistance for clients deploying the application into their own AWS environment
Service documentation
Yes
Documentation formats
  • HTML
  • PDF
End-of-contract data extraction
Both generated spreadsheets and generated history are accessible from AWS S3.
End-of-contract process
No termination charge, pay per use model.

Using the service

Web browser interface
Yes
Supported browsers
  • Microsoft Edge
  • Firefox
  • Chrome
  • Safari
Application to install
No
Designed for use on mobile devices
Yes
Differences between the mobile and desktop service
None
Service interface
Yes
User support accessibility
WCAG 2.1 A
Description of service interface
User interface through graphical menus, and input panels using mouse and keyboard. No option to use microphone or camera.
Accessibility standards
WCAG 2.1 A
Accessibility testing
None, planned.
API
No
Customisation available
Yes
Description of customisation
An AWS Cloud Formation version which users can adapt to their own needs, install on their own AWS environment, and integrate more fully with other operational systems.

Scaling

Independence of resources
System scales horizontally via AWS Lambda.
Users with Sheetloom deployed in their own AWS environment will not be affected by external users.

Analytics

Service usage metrics
Yes
Metrics types
User activity and access reports.
Reporting types
  • Real-time dashboards
  • Reports on request

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Other security clearance
Government security clearance
Up to Developed Vetting (DV)

Asset protection

Knowledge of data storage and processing locations
Yes
Data storage and processing locations
  • United Kingdom
  • European Economic Area (EEA)
User control over data storage and processing locations
Yes
Datacentre security standards
Managed by a third party
Penetration testing frequency
At least every 6 months
Penetration testing approach
In-house
Protecting data at rest
  • Encryption of all physical media
  • Scale, obfuscating techniques, or data storage sharding
  • Other
Other data at rest protection approach
The default is SSE-S3 where AWS manages the encryption keys. It’s the simplest to use and provides 256-bit encryption on all the files stored.

If the Customer wishes to maintain the keys themselves then they can use SSE-KMS for more control. This approach is where the Customer uses AWS Key Management Service (KMS) to manage their encryption keys. It offers more granular control over keys at the cost of maintaining and rotating keys.
Data sanitisation process
No
Equipment disposal approach
Complying with a recognised standard, for example CSA CCM v.30, CAS (Sanitisation) or ISO/IEC 27001

Data importing and exporting

Data export approach
All data created by or uploaded into Sheetloom in any form (but typically csv or xlsx) is accessible to download.
Data export formats
  • CSV
  • Other
Other data export formats
PDF/A
Data import formats
  • CSV
  • Other
Other data import formats
All SQL databases

Data-in-transit protection

Data protection between buyer and supplier networks
  • Private network or public sector network
  • TLS (version 1.2 or above)
  • IPsec or TLS VPN gateway
  • Legacy SSL and TLS (under version 1.2)
  • Other
Other protection between networks
Will vary according to customer configuration.

Can also be encrypted prior to transfer
Data protection within supplier network
TLS (version 1.2 or above)

Availability and resilience

Guaranteed availability
99%. If 99% not met, we would negotiate a refund separately.
Approach to resilience
We are utilising AWS best practice in relation to resilience. AWS S3 is used as the backing store for all vulnerable data. S3 is designed for 11 9´s durability.
Outage reporting
AWS Cloudwatch alerts can be created

Identity and authentication

User authentication needed
Yes
User authentication
  • 2-factor authentication
  • Username or password
  • Other
Other user authentication
IP address is whitelisted.
2FA is an option if customer requires.
Access restrictions in management interfaces and support channels
Access to management interfaces and support channels is restricted through a combination of username and passwords, multifactor authentication, firewalling, IP restrictions, the use of bastion hosts as appropriate.
Access restriction testing frequency
At least once a year
Management access authentication
  • 2-factor authentication
  • Username or password
  • Other
Description of management access authentication
IP Address whitelisting

Audit information for users

Access to user activity audit information
Users contact the support team to get audit information
How long user audit data is stored for
Between 1 month and 6 months
Access to supplier activity audit information
Users have access to real-time audit information
How long supplier audit data is stored for
Between 1 month and 6 months
How long system logs are stored for
Between 1 month and 6 months

Standards and certifications

ISO/IEC 27001 certification
No
ISO 28000:2007 certification
No
CSA STAR certification
No
PCI certification
No
Cyber essentials
Yes
Cyber essentials plus
No
Other security certifications
No

Security governance

Named board-level person responsible for service security
Yes
Security governance certified
Yes
Security governance standards
Other
Other security governance standards
Cyber Essentials Certification
Information security policies and processes
Sheetloom follows AWS best practice on security https://aws.amazon.com/security/.
We have a range of technical and organisational measures to ensure data security and protection. These cover Access, Roles and Responsibilities, Resource/asset management, Access Control & Authentication, Workstation & Device Security, Network/Communications Security, Back-up, mobile/portable device security, and physical security of our premises. Staff training and awareness is ongoing, staff / contractors must sign confidentiality and privacy statements and read and sign company security policy. Sanctions are applicable for non-compliance. Our reporting structure if a security breach happens or is suspected: staff are trained to and required to immediately flag to DPO and CEO and lock down or isolate the breach where feasible; DPO/CEO will take immediate action including isolation or lock down of affected systems, notification to affected parties, implementation of business continuity and disaster recovery. Risk impact reviews are conducted when a new data category is processed, or system implemented, and security measures adapted as necessary. Category logs, training logs, access logs, and breach logs are maintained, reviewed and signed off periodically by the assigned DPO and CEO.

Operational security

Configuration and change management standard
Supplier-defined controls
Configuration and change management approach
All code is under version control using git.
Jenkins is used to build releases. An automated test framework is used for integration testing. Changes are tracked via JIRA. Cloudformation is used to deploy via AWS Marketplace
Vulnerability management type
Supplier-defined controls
Vulnerability management approach
Solution may be deployed into customer's AWS VPC via AWS Cloud Formation or they may subscribe to Millersoft version;
External access is configured via customer and GUI is locked down via AWS security groups/firewalls.
SSH access is also locked down via security group and PEM file.
The access is as secure as the customer´s network.
Protective monitoring type
Supplier-defined controls
Protective monitoring approach
Regular penetration testing
Awareness towards open source software defects (eg Python vulnerabilities)
All logs go to AWS Cloudwatch for auditing, monitoring and alerting.
Incident management type
Supplier-defined controls
Incident management approach
When a breach or suspected breach occurs staff our process requires staff to immediately report this to the DPO/CEO, raising a breach incident form and taking what actions are available to them to isolate or lock the system according to the severity of the breach. The DPO/CEO will assess the breach and implement appropriate measures to contain, and resolve and notify affected parties to the extent required. The nature of the breach, cause, impacts, actions to remedy it and timescale, outcome and further recommendations are recorded in breach incident log which is monitored by CEO and DPO.

Secure development

Approach to secure software development best practice
Supplier-defined process

Public sector networks

Connection to public sector networks
Yes
Connected networks
Other
Other public sector networks
Potentially all public sector networks based on client connectivity needs

Social Value

Social Value

Social Value

Tackling economic inequality

Tackling economic inequality

We believe that our social mission to assist young people into employment is compatible with the guidelines laid out in the Governments Social Value theme of tacking economic inequality (MAC 2.2). Wherever it has the opportunity to do so, Millersoft has and continues to offer placements, internships and employment to technology students from the deprived local area studying in local colleges and universities with whom we hold relations. Its method is to provide initial training and inductions to suitable internees before assigning them to live projects, where they are monitored, supported, challenged, and encouraged by experienced senior consultants and developers. As an organisation that values fresh and radical ideas to find new products and solutions to solve existing problems, internees are also encouraged to share their thoughts and ideas in a stimulating and collaborative environment, and often asked to implement, test and deploy them into real world projects. Regular development reviews are held with internees and progress objectives adapted accordingly. Internees, as is the case with all staff, receive regular training in the latest technologies which may cover Cloud Technologies (staff are trained to be Amazon Web Service Engineers and Architects), data processing tools, database management, project management, security. In most cases internees become full time employees at Millersoft once they graduate and are already well equipped to take on more responsibility and autonomy within the company.

Pricing

Price
£10 a licence a month
Discount for educational organisations
No
Free trial available
Yes
Description of free trial
Full access for 30 days

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at gerry@millersoftltd.com. Tell them what format you need. It will help if you say what assistive technology you use.