Forum Discussion
Converting Google Sheet spreadsheet to Excel
You can start helping us help you by posting here a link to that GoogleSheet, a link that grants edit access.
- rparker865Mar 16, 2023Copper Contributor
mathetes
Good idea, I created a share here:
https://docs.google.com/spreadsheets/d/1cPpFKGgsqcj4o6xRnelkh7jOmgVzlsdq2mU3INyktGc/edit?usp=sharing- mathetesMar 16, 2023Gold Contributor
OK, now that I've looked at it, let me invite you to help us help you further by giving some guidance as to how to navigate what you've shared. I've never looked at a "bill calendar" before, not knowingly at any rate.....so not sure how it would work. How would one be filling in data, how many bills and clients/customers are we billing (or paying?).... More specifically, where would Input take place; where Output? And what is (are) the Process (processes) that transform the former into the latter?
(As an aside, this looks like it possibly is a "spreadsheetization" of what has been a paper-based ledger-sheet "manual" process. As such--and this would not be the first time for such a thing to happen--it may not be taking full advantage of Excel's abilities to handle Input entered into a single database (not broken down into monthly or weekly sheets) and then reported or summarized in a single dashboard Output that is based on selection criteria specifying the data to be summarized. To the extent that is the case, or some variation on that, it might be appropriate to re-think the design. As noted, an aside.)
I glanced at some of the formulas and did not see anything that is outside the realm of Excel. But, yes, loading it in Excel generated a bunch of error messages.
Actually, you could also help us help you if you were to pull together a full set of the various formulas--one instance of each--that are used in your Google sheet and we could look at them, to see if there are one or two that don't work in Excel, or don't work with the same syntax