Integrating marketing research and book production with excel/VBA and logogram–algorigram logic engineering field in education technical, technology tools assessment ,orientation lesson organization lesson, electrical engineering volume 2

Abstract This research explores the integration of a marketing research plan and a book production schedule using Excel formulas and Visual Basic for Applications (VBA) . It demonstrates how logigrams (flowcharts) and algorigram coding (VB algorithms) can automate decision-making and sequential workflows, supporting both educational assessment structures and industrial management systems . Scope Marketing research planning (scope, objectives, vendor selection). Book production scheduling (drafting, reviews, layout, finalization). Excel/VBA automation for timelines and dependencies. Application in South African TVET and engineering contexts . Overview The project integrates two workflows: Decision-based research planning (in-house vs. vendor). Sequential production scheduling (chapters 1–5). Both are linked through Excel worksheets and automated with VBA. Description Worksheet 1: MarketingPlan → ID, Owner, Start, Days, End. Worksheet 2: BookSchedule → Chapter, Task, Start, Days, End. Excel Formula: =WORKDAY(StartDate, Days, Holidays) ensures realistic timelines. VBA Code: Automates start/end dates and dependencies