Ravi Sir's Cards › Excel
Printing Press Management System in Excel (card 1 of 2)
Revision card 1 for Printing Press Management System in Excel: Due date: =B5+L5 gives 03-10-2026; Automatic job number: ="P-"&TEXT(ROW()-4,"000") gives P-001; Sheets needed with wastage: =ROUNDUP(ROUNDUP(E5/F5,0)*(1+Setup!$B$6),0) gives 1,313. Includes an example data table.
Read card text
What this card says
1 for Printing Press Management System in Excel: Due date: =B5+L5 gives 03-10-2026
Automatic job number: ="P-"&TEXT(ROW()-4,"000") gives P-001
Sheets needed with wastage: =ROUNDUP(ROUNDUP(E5/F5,0)*(1+Setup!$B$6),0) gives 1,313. Includes an
Example
data table
Learn this in the lesson: Printing Press Management System in Excel: Job Estimator, Paper and Plates, Quotation, Delivery Status and Dashboard