Seeking a sample spreadsheet - Inventory of items with 2 units

K

Ka Pilo

#1
Could anyone share a sample of spreadsheet that has inventory containing items with 2 units? For example, you have 1 box (containing 72 pcs) and another 5 pcs. And then, 8 pcs were sold. Therefore, the result would be 69 pcs. Instead of "box" the unit should be in "pcs" now.

Thank you
 
Elsmar Forum Sponsor

Stijloor

Leader
Super Moderator
#2
Could anyone share a sample of spreadsheet that has inventory containing items with 2 units? For example, you have 1 box (containing 72 pcs) and another 5 pcs. And then, 8 pcs were sold. Therefore, the result would be 69 pcs. Instead of "box" the unit should be in "pcs" now.

Thank you
Any Excel experts who can help?

Thank you!

Stijloor.
 
B

Bogie

#3
Here is a quick and dirty Excel solution. I made a very basic spreadsheet and the total will change as you change the the numbers in the AMT column. The G column can be hidden, but needs to stay for reference for the total.

I am sure it can be pared down, but it would take someone smarter and with more time than me.

Hope this helps!
 

Attachments

Thread starter Similar threads Forum Replies Date
K Seeking a Sample Procedure for Handling Potentially Unsafe Food Products Food Safety - ISO 22000, HACCP (21 CFR 120) 1
K Agriculture Industry - Seeking Sample Procedures ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
P Seeking sample Resignation Letter - Health and Relocation reasons Career and Occupation Discussions 3
S Decontamination of Customer Returned Product - Seeking sample procedure ISO 13485:2016 - Medical Device Quality Management Systems 8
Ron Rompen Need help with MSA/Gage R&R - Seeking Minitab template file/sample GR&R study Using Minitab Software 7
K Supplier Report Card - Seeking sample of a basic Supplier Report Card Supplier Quality Assurance and other Supplier Issues 4
K Seeking sample quality objective(s) for IMPEX (Import / Export) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
S APQP Timetable - The stage to producing a sample - Seeking Advice IATF 16949 - Automotive Quality Systems Standard 5
Q Seeking: Process Change Control Sample Procedure / Help IATF 16949 - Automotive Quality Systems Standard 6
Howard Atkins New to Internal Process Auditing - Seeking Sample Process Audits Process Audits and Layered Process Audits 31
I Seeking: Sample ISO 9001:2000 Quality Manual Quality Management System (QMS) Manuals 4
B Training Records and Competency - Seeking sample training record Records and Data - Quality, Legal and Other Evidence 7
N Seeking Sample quality system questionnaire which can be sent out to suppliers Supplier Quality Assurance and other Supplier Issues 3
G Seeking reference guides/ documentation /tips on verification best practices Other Medical Device Related Standards 6
J New QMS Auditor - seeking opportunities to gain audit experience Career and Occupation Discussions 3
M Seeking mentor/consultant for orthopaedic soft goods regulations Job Openings, Consulting and Employment Opportunities 0
M Seeking Consultant for Orthopedic Start Up company Other Medical Device and Orthopedic Related Topics 1
H SOP Template for seeking regulatory clearance - MDSAP Document Control Systems, Procedures, Forms and Templates 6
W Seeking Guidance Verification Test Strategy for Class B Medical Devices IEC 62304 - Medical Device Software Life Cycle Processes 1
M Seeking advice regarding use of off-the-shelf (OTS) batteries Other Medical Device and Orthopedic Related Topics 4
A ISMS - Seeking VAPT Consultant Food Safety - ISO 22000, HACCP (21 CFR 120) 1
M Medical Device Directive - Seeking common nonconformance write up scenarios CE Marking (Conformité Européene) / CB Scheme 2
silentmonkey Seeking efficient method to manage install base data Manufacturing and Related Processes 0
K Seeking ISO 13485 Registrar Recommendations Registrars and Notified Bodies 15
R Tapping problems - 3/8" hot roll pickled & oiled steel - seeking expertise Manufacturing and Related Processes 15
S Responsibilities between government owner and private subcontractor of a power plant seeking ISO 9001 certification ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
B Seeking for an example or a template of a Business Plan Service Industry Specific Topics 3
B Health Canada Recall Definition - Seeking Clarification Canada Medical Device Regulations 5
W Seeking Returned Merchandise Procedure Customer Complaints 1
QMMike New Trend of not seeking Official ISO 9001 Registration ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 43
R Clinical Evaluation according to MEDDEV 2.7.1 (Rev 4) - seeking template ISO 13485:2016 - Medical Device Quality Management Systems 6
T ISO 9001:2015 Training for Management Team in NM - Seeking Suggestions and Providers ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
D Seeking Corrective Action Process Examples Nonconformance and Corrective Action 3
M AS9102 Training - Seeking third party agency that provides online AS9102 training AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
F Seeking Internship/Co-op Opportunities in Regulatory Affairs/QA/Clinical Domain (USA) Career and Occupation Discussions 4
L Seeking help in Basic Maintenance Knowledge Manufacturing and Related Processes 4
M Seeking opinion for ISO14001 team activity ISO 14001:2015 Specific Discussions 3
smryan Seeking good 2D barcode add-in for Excel Excel .xls Spreadsheet Templates and Tools 6
S Seeking Feedback on ASQ Guide to Failure Mode and Effect Analysis FMEA and Control Plans 2
S Seeking examples of Nonconforming Materials Nonconformance and Corrective Action 5
S Seeking Quality Training for Quality Technicians Training - Internal, External, Online and Distance Learning 1
P Seeking Information on ISO 15504 - Information Technology Process Assessment Other ISO and International Standards and European Regulations 3
K Seeking NDT Training and Certifications Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
Chennaiite Cause Analysis for Verification/Validation Failures - Seeking Opinions Problem Solving, Root Cause Fault and Failure Analysis 3
Q Seeking Examples of current ISO/TS 16949 Training Procedures IATF 16949 - Automotive Quality Systems Standard 2
Ron Rompen Seeking Test Lab which can do 1440 Hour Accelerated Weathering Characteristics Misc. Quality Assurance and Business Systems Related Topics 1
S Seeking Ballooned PFMEA and Control Plans for Training FMEA and Control Plans 4
B Seeking help in answering Australia Tax Withholding Declaration Coffee Break and Water Cooler Discussions 1
H ASQ CQE Exam Review Workshop - Seeking Volunteers! September 2013 ASQ, ANAB, UKAS, IAF, IRCA, Exemplar Global and Related Organizations 7
N Seeking information on use of Byotrol Cleaning Chemicals in Pharma Industry Manufacturing and Related Processes 1

Similar threads

Top Bottom