1
By Dr. Mohamed Mahmoud
2
1. Data Entry and Storage:
Store and organize large volumes of structured data (e.g.,
customer lists, inventory, schedules).
Maintain records such as employee details, sales logs, or
Uses of spreadsheet ? research data.
2. Calculations and Formulas;
Perform mathematical, statistical, and financial calculations
using built-in formulas.
Automate totals, averages, percentages, and complex
equations.
3
3. Inventory and Asset Management;
Track stock levels, reorder points, and asset values over time.
4. Scenario and Risk Analysis:
Create "what-if" models to simulate different scenarios.
Perform risk assessments or impact analysis with variable inputs.
7. Data Import and Export’
Interface with databases, CSV files, and other systems to import/export data.
4
⦿ Category 1 – Infrastructure Software
⦿ Category 2 – no longer used (Firmware)
⦿ Category 3 – Non-Configured Products
⦿ Category 4 – Configured Products
⦿ Category 5 – Custom Applications
5
⦿ unique spreadsheet to do a calculation (e.g. Disposable Sheet) (Category 3)
⦿ A template isused by analysts in a laboratory to do a routine calculation of averages and standard
deviations of experimental results.(category 3)
⦿ A spreadsheet template requires the userto input tablet strength, so that the application
automatically branches to different cells to use strength-specific calculations based on thisinitial
input (Category 4,)
⦿ a spreadsheet application that employs custom macros or sophisticated or nested logic or lookup
functions should be treated as (Category 5)
6
⦿ Data management requirements
› Defining electronic record needed
› Required fields
› Inputformatand value range
› Data migration
› Data editing/change
› Backup
› Archival
7
Audit Trail.
Security requirements.
Time Stamp.
Electronic Signature.
8
⦿ All sheets and print-outs shallclearly identify
[requirements ]
› the spreadsheet name [i.e Title]
› Unique identification [e.g unique coding]
› version number.
⦿ The following to be displayed withinthe printarea of the spreadsheet
[Recommendation ]
› File path & filename [=CELL("filename")’ ]
› MS Excel® version number. [=INFO("RELEASE")]
› Date/Time of data entry. [=Now()]
› Cells for user input of Meta data [e.g sample code ,batch
number , sample name , ,…etc]
9
⦿ Good design practices
› cell identification
▪ Cells used for data input can be identified by a specific color
▪ Cells used for presenting the results of the calculations (output) can be identified by a specific color.
› Data validation rules
▪ can be applied to data input cells to prevent the introduction of aberrant values
› Conditional Formatting
▪ When the results are tested against acceptance criteria it isrecommended using conditional formatting
(Home tab >Conditional Formatting) to highlight out-of- specifications results.
› Data attribute Spaces on printed sheet
▪ The name of the operator responsible for data entry
▪ Signature
▪ the date and time of generation
10
⦿ Security and changes protection
› Calculation protection
▪ calculating cells shall be locked to protect cells containing calculations against unintended
modification, except those used for data input
› Template format Protection :
▪ each sheet content ,workbook structure should be password protected
› File Protection
▪ all validated Excel spreadsheets should be stored with read-only access rights for the end
users (e.g., on a protected network share).
▪ Only responsible persons :have write access
▪ End user :read only access
13
14
15
16
17
18
Validation V Model 19
Category 4
1- URS.
2- FS.
3- configuration Specification.
4- configuration testing.
5- Functional testing.
6- Requirements testing.
Validation V Model
Category 5
21
Thanks