Closed

Dynamic Analytics of Data in a Live Google sheet of 'Bookings for 33 different Course Modules'

Dynamic Analytics of Data in a Live Google sheet of 'Bookings for 33 different Course Modules'

I have a LIVE -DYNAMIC sheet (now orders /lines being added daily)

I require some custom dynamic Sub Totals and total in volume and in cash terms

There are 33 different unique Modules and - for which we need to Track and Monitor:

a) Number of Bookings per each of the 33 Modules to date (dynamic)

b) Cash Value of Bookings per each of the 33 Modules to date (dynamic)

c) Total number of ALL bookings this term to date:

d) Income Value of ALL Bookings this term to date

e) Stock Control of Places Left /Unsold per Module.

f) Auto Email Alert when only 4 Places lect in the module.

g) Auto Email Alert when the Module is fully booked.

You will have full access to the Live Master Google Sheet Document

Skills: Google Sheets, Google Analytics, Google Apps Scripts

About the Client:
( 6 reviews ) Greystones, Ireland

Project ID: #34272365