JFA-PI-CMS

• Customer Managemet & Quotations
• Proforma Invoicing
• Costing systems

~ Developed using One-Drive based MSO Excel worksheets for online use ~

Costing sheet

• Protected: manager-login system
• Dynamic display

SPV CMS & PI - single worksheet file

• heavy data-tables (TODO - make a linked data worksheet)
• single worksheet for use in all showrooms/places

SB CMS & PI - main CMS and linked worksheet for data

• all data in a common linked worksheet
• linked datasheet protected with User Login
• CMS worksheet copy-able to use in different showrooms with different setup data
• data sheet and CMS setup data are range-protected for manager-update
• not so heavy as SPV system due to linked datasheet.

Developer: Victor Wright (wrightsdesk.com)
Company: Jude Fernandopulle Assoc. (Pvt) Ltd. (jfalanka.com)
Date: ~ 2020