Microsoft Excel database to Stand-alone software

drobbins329

Starting to get Involved
#1
So.... I have been hard at work. Coincidentally, unpaid work. I have written software completely replacing my Microsoft excel based calibration records. It supports all that the excel version did, plus a LOT of extras.

The last thing I have to do, is implement an ANOVA Gauge R&R, and an attribute gauge r&r. I have seen several excel tables performing this calculation. However, I can't find much detail on the calculations behind them. Every one I have found is "locked" to prevent viewing of the formulas.

Can anyone offer any insight on this?

If interested, I can provide a copy of my software as is in exchange for help. I am on the fence on trying to license it. I did all the coding at home unpaid, and would like to find some* compensation for the effort and time.
 

Attachments

Last edited:
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#2
Thank you for all of your hard work. My heart is with you: I have made many Excel-based tools and submitted a number of papers in the Stealth Quality forum.

Lots of consultant make free tools, with which to entice clients to contract our services. You can license the tool if you like (I can't see anything much in the thumbnail image), I haven't. I wish I knew more about VBA so I could make my risk, audit and CA program management tools better.
 

drobbins329

Starting to get Involved
#3
Thank you for all of your hard work. My heart is with you: I have made many Excel-based tools and submitted a number of papers in the Stealth Quality forum.

Lots of consultant make free tools, with which to entice clients to contract our services. You can license the tool if you like (I can't see anything much in the thumbnail image), I haven't. I wish I knew more about VBA so I could make my risk, audit and CA program management tools better.
I can give you some help on vba. I could also send you better screen shots.

Sent from my SM-S903VL using Tapatalk
 
Thread starter Similar threads Forum Replies Date
QSM_Rick Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
O Chi Square Normality Test using Microsoft Excel Excel .xls Spreadsheet Templates and Tools 2
AnaMariaVR2 Guide to Microsoft Excel for Calculations, Statistics, and Plotting Data Excel .xls Spreadsheet Templates and Tools 11
M Microsoft Excel - Trouble with Auto-Entry of Dates Excel .xls Spreadsheet Templates and Tools 13
L 21 CFR Part 11 Requirements - Microsoft Excel Add-on Functions 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 6
J Conditional Formatting for Microsoft Excel Excel .xls Spreadsheet Templates and Tools 2
Colin Changing the Colour of a Date in Microsoft Excel Excel .xls Spreadsheet Templates and Tools 4
X Microsoft Excel 2003 Formula Restrictions Excel .xls Spreadsheet Templates and Tools 9
L Pareto question Microsoft Excel Excel .xls Spreadsheet Templates and Tools 6
Marc Microsoft Excel zero-day vulnerability confirmed Excel .xls Spreadsheet Templates and Tools 2
C X-R chart - Microsoft Excel .xls Programmed X-R Chart Spreadsheet Excel .xls Spreadsheet Templates and Tools 61
W Sorting in Microsoft Excel .xls - I want to create a Pareto Chart Excel .xls Spreadsheet Templates and Tools 21
D Hyperlinks in Microsoft Excel and Word - Linking Documents Excel .xls Spreadsheet Templates and Tools 12
J Microsoft Smart Art Turtle Diagram Process Maps, Process Mapping and Turtle Diagrams 9
M Informational Microsoft Built a Bot to Match Patients to Clinical Trials Medical Device and FDA Regulations and Standards News 0
J Microsoft Teams to manage Internal Audit System? Internal Auditing 3
A Free software similar to Microsoft Project - Any suggestion? APQP and PPAP 5
Marc ASQ Linkedin Group - Microsoft Sharepoint discussion - June 2017 Quality Assurance and Compliance Software Tools and Solutions 0
Marc Microsoft to rip up P2P Skype, killing native Mac, Linux native apps World News 0
Marc Microsoft just bought LinkedIn For $196/Share World News 9
I How to build a Microsoft Access MDB Database for Document Control Document Control Systems, Procedures, Forms and Templates 6
M Active X and latest update from Microsoft - Dec 2014 After Work and Weekend Discussion Topics 4
N Microsoft Word - How to make high-light go away after text is put in Excel .xls Spreadsheet Templates and Tools 5
insect warfare IRS pays Microsoft for Windows XP support After Work and Weekend Discussion Topics 2
Marc Microsoft to push out XP patch on March Patch Tuesday - 2014 After Work and Weekend Discussion Topics 19
T Microsoft Access Database to create a Simple Calibration Certificate General Measurement Device and Calibration Topics 6
V Alternative to Microsoft Office - Open Office vs. Google Docs After Work and Weekend Discussion Topics 26
Jim Wynne Have you tried Microsoft Windows 8? After Work and Weekend Discussion Topics 25
H 4.2.3 Document Control using Microsoft Sharepoint - Visibility of Draft Documents ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Q Looking for Microsoft Dynamics AX Training Videos for Inspection Journals Manufacturing and Related Processes 1
michellemmm Pagination in Microsoft Word Documents Document Control Systems, Procedures, Forms and Templates 21
H AS9101D Microsoft Word Format: Worth It? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
P Creating a Traceability Database with Microsoft Access Document Control Systems, Procedures, Forms and Templates 7
Marc Microsoft Losing Big To Apple On Campus After Work and Weekend Discussion Topics 18
P Magic with Microsoft (things that could not be explained) Funny Stuff - Jokes and Humour 8
Marc Apple Dethrones Microsoft As World's Biggest Tech Company After Work and Weekend Discussion Topics 6
E Signature of Records - Microsoft Word forms Records and Data - Quality, Legal and Other Evidence 7
Claes Gefvenberg Microsoft Windows users: Which windows version are you using? March - April 2010 After Work and Weekend Discussion Topics 37
S Microsoft OneNote - Is anyone using Microsoft OneNote Quality Assurance and Compliance Software Tools and Solutions 13
D Microsoft Word problems Document Control Systems, Procedures, Forms and Templates 11
M Microsoft Sharepoint as Document Control Software - FDA Validation Requirements Document Control Systems, Procedures, Forms and Templates 15
Marc The Hidden Cost of Using Microsoft Software After Work and Weekend Discussion Topics 14
C Microsoft Access Database for In-Process Run Charts Quality Assurance and Compliance Software Tools and Solutions 4
Stijloor Microsoft's Ballmer: Windows 7 is nearly final After Work and Weekend Discussion Topics 13
Coury Ferguson Bill Gates to step down from Microsoft After Work and Weekend Discussion Topics 8
A Fullscope with Microsoft AX ERP System Manufacturing and Related Processes 1
B UK standards body taken to court over OOXML (Microsoft's Open office XML) Other ISO and International Standards and European Regulations 6
GStough Microsoft InfoPath - Anyone Ever Used This? Document Control Systems, Procedures, Forms and Templates 7
Stijloor Microsoft Offers to Buy Yahoo for $44.6 Billion World News 3

Similar threads

Top Bottom