Author Topic: Any Google Sheets knowledge?  (Read 844 times)

MDM

  • Walrus Stache
  • *******
  • Posts: 9243
Any Google Sheets knowledge?
« on: January 16, 2018, 12:30:44 PM »
There have been comments that the case study spreadsheet does not work as well in Google Sheets (or LibreOffice Calc, but that is another topic) as it does in Excel.

After looking at some online comparisons between Excel and Sheets it appears Sheets simply doesn't have the needed functionality.  In case that is too pessimistic, see the quote from the Excel vs. Calc thread:
Quote
A significant issue, however, is the marginal rate chart near cell F81.  Works great in Excel, but not in Calc.  Perhaps the most significant difference is between Excel's {TABLE} vs. Calc's MULTIPLE.OPERATIONS functions.  Some of that is cosmetic, e.g., getting cells U84 and O82 to work correctly, and probably manageable.

Where a more knowledgeable set of eyes is most needed is cells Q83:Q583.  Excel fills those with the tax results corresponding to the different values of whatever one has chosen for the x-axis variable on the chart (using Excel's "Data Table" column input).  Calc fills those with identical values. 

Anyone know how to correct that in Sheets?


MDM

  • Walrus Stache
  • *******
  • Posts: 9243
Re: Any Google Sheets knowledge?
« Reply #1 on: January 18, 2018, 02:04:46 PM »
Bump.