I believe using either of these two applications should not pose any problems for implementing your spreadsheet automation ideas. This is because both have always been "friendly", towards making it easy for users to get more functionality out of them by way of custom programming.
To elaborate further: A one_page Variable Costs Analysis report sheet automatically generated by the custom spreadsheet application I earlier described, was a powerful tool used by top management to quickly assess performances of individual breweries. Among other benefits, the report made it quite easy to realistically compare sister breweries in different locations(even across countries) based on common denominators. Apart from summarising brewing/packaging materials in two groups _
Deciding What Spreadsheet Application To Use. This would ultimately be up to you. The big "fight" has always been between Lotus 1θι and Microsoft Excel. I started out with Lotus 1θι back in 1993 and learnt Lotus Macros programming(via self_tutoring). I eventually used this skill to develop _ in my free time _ various custom spreadsheet solutions(that were formally adopted for use in the departments I worked in as a brewer/manager in Guinness), before switching to Microsoft Excel in 2001. Subsequently, I developed my Excel Visual Basic spreadsheet programming skills (also via self_tutoring), because the company had chosen to adopt MS Office during the roll over to year 2000.
In my article titled You Can Increase Your Profits Without Changing Your Prices, I ended with the following summary: If You Remember Nothing Else, Remember The Following: 1. One good way to maintain and/or significantly increase your profits without raising your prices, is to reduce your Variable Costs(VCs). 2. You can reduce your variable costs by marketing more efficiently (getting more customers at lesser cost, AND maintaining them at lower expense). I once read an article that proposed a new parameter COCS: Cost Of Customers Sold or Served). This could be adopted as a Key Performance Indicator(KPI). 3. You can also reduce your variable costs by innovating more(i.e. developing greater efficiency in your routine internal operations and/or product/service delivery). That way, you would be able to produce/deliver more products and/or services with less effort, in less time, and using less resources. All of these would imply LOWER expenses/costs, leading to INCREASED profit retention per unit of product/service sold. 4. There is saying that: "You cannot manage something, if you do not measure it. Nor can you measure it, if you do not record it". Spreadsheet tracking will help you conveniently implement and sustain the process of monitoring, controlling and/or reducing your VCs. You will need to do this so as to constantly evaluate progress of your VC monitoring/control and reduction initiatives.