Overview
Frequently Asked Questions
Why doesn’t Time Card Robot have this feature that I want?
Keep in mind that this spreadsheet was originally developed for my own workflow, but as it grew in capabilities, I thought that other people might also find it useful. I am happy to try adding new features and to refine the paycheck calculations, but there will alway be some limit as to what types of features can be added due to the fact that it isn’t really an app, but is instead a glorified Excel file designed in my spare time using a free piece of software from Apple. That being said, please email any suggestions to timecardrobot@gmail.com and I will see what I can do!
Why are certain tables locked and other can be edited?
The general design of the spreadsheet is to leave certain tables unlocked so that the user can input information while leaving important formulas untouched. If a table is locked it usually means you don’t want to edit the information unless you are aware of what the formula does or you have a backup of all the data you have put in up to that point. There are also many columns that are hidden by default simply because the interface would appear too cluttered if they were all visible, but some may also contain important formulas that will break certain features if they are changed or deleted.
The calculations are wrong!
First, that’s not a question. Second, that is probably true! The calculations are based on my best knowledge of our union contracts, but it is by no means comprehensive or definitive. If you have questions about why a calculation is a certain way, please email me and I can determine if the formulas are intentionally designed that way or if it is simply an oversight that didn’t take into account the specific contract you are working under. And if you are ever unsure how a contract works, you should get in touch with one of your union’s business reps to help explain the details. They will be happy to do so and they are far more knowledgeable than I am!