I’m thinking specifically of calc/excel.
I want to make two spreadsheets, one for working out my timesheets and figuring out how much time I’ve spent on a job compared to others etc.
Another which deals with my finances. In order to automate these as much as possible I would like to integrate my spreadsheets with Python and build several Macro’s.
Samples of what I would build is a prompting system which reads through a fie of my finances containing each item for the month. If it recognises the item it would automatically place it into a specific row/column/sheet. If not the programme will prompt me about the item if it doesn’t to tell iin order to figure out where to put it (in this case the response would then be stored in the hopes that future items will be remembered). Another would be for my timesheet system. There I’d set up a programme which would ask me for a job number, time spent and the day in which I’m talking about. That would then find the appropriate palce and automatically input the item.
After that the sheets would be set to automatically incorporate the new data into their analysis, updating any statistical tables and graphs I’ve set up.
My home computers are all running Ubuntu and therefore I’m using LibreOffice, however my work computer runs windows and Microsoft Office.
So what I want to know is that, if I build all my spreadhseets in LibreOffice, will I be able to transfer them over into Microsoft Office for work successfully. Or should I build a Microsoft and Libre Office version?