How do I translate this equation into an Excel formula? Below is the equation. And below is my Excel formula. But my formula does not seem to be working. What did I do wrong?
Here is the equation:

The radius (r) equals 24.01, so I just typed in 24.01 into cell A1. So, in my formula, I use a reference to the value of CELL A1 instead of "r" throughout the formula.
And the height (h) is represented by the value in CELL A12. So, in my formula, I use a reference to the value of CELL A12 instead of "h" throughout the formula.
Here is my Excel formula:
=14.963*(1/2)*((A12-A1)*SQRT(1-((A12-A1)/A1)^2)+(A1*ASIN((A12-A1)/A1)-((PI()*A1)/2)))
Thanks. Joseph A. Spadaro (talk) 01:11, 7 May 2016 (UTC)
- Your formula is missing.. Bytesock (talk) 01:09, 7 May 2016 (UTC)
- What do happen when you try it? btw, I would test SQ(2.5), (2.5)^2, PI() just to see if those work as aspected. Bytesock (talk) 02:22, 7 May 2016 (UTC)
- (1) What? I did not understand your suggestion at all. (2) What happens is that I get an incorrect result/value. Joseph A. Spadaro (talk) 02:33, 7 May 2016 (UTC)
- Looks like you have one of the closing parentheses out of place: Try:
=14.963*(1/2)*((A12-A1)*SQRT(1-((A12-A1)/A1)^2)+(A1*ASIN((A12-A1)/A1))-((PI()*A1)/2))
- -- Tom N talk/contrib 04:24, 7 May 2016 (UTC)
- Thanks. But, no. Your formula gave me the same exact results as did my formula. In my formula, if I enter the value "8" in Cell A12, I get a resulting value of negative 502.5414 from the formula. Your formula produces the exact same result. The correct result should be approximately positive 61 or so. For what it's worth, this question is related to another question that I posted on the Math Reference Desk. Here: Wikipedia:Reference desk/Mathematics#What kind of function does this data represent?. Thanks. Joseph A. Spadaro (talk) 04:48, 7 May 2016 (UTC)
- I now see that the misplaced parentheses only changed the additive grouping, with no net effect. I did some digging on the web and found a better formula, which I've posted on the Mathematics desk. -- Tom N talk/contrib 07:54, 7 May 2016 (UTC)
- My first chekc would be whether your formula expects the inverse sine function to work in degrees or radians. Excel works in radians.--Phil Holmes (talk) 11:41, 7 May 2016 (UTC)
- Of course it's radians — any measure of length/area/volume (and almost anything posted as serious mathematics — e.g., on the Math Desk) is naturally expressed therein (and there's a
next to the arcsine that is obviously an offset to its (radian-based) value). --Tardis (talk) 15:47, 7 May 2016 (UTC)
- One suggestion to avoid mistakes is to break such a complex formula up into pieces. For example, you could put this in one cell then use it later to build the full formula:

- You could even break up repeated expression, and assign them their own cells, like this:

- Or even this:

- This makes it easier to debug, as you can look at each component of the formula, and figure out if it is calculated correctly. StuRat (talk) 15:43, 7 May 2016 (UTC)
- Yes, I understand that reasoning and that approach. However, for me, that only makes the spreadsheet more confusing, more cluttered, and more difficult to understand. Joseph A. Spadaro (talk) 21:12, 7 May 2016 (UTC)
- Myself, I always seem to get my opening and closing parens mismatched, so it helps me to break it up. As far as appearing cluttered, I believe you can hide the row or column containing those cells once you no longer need to see them. StuRat (talk) 21:22, 7 May 2016 (UTC)
- Yes, the open and close parentheses are always a problem. One that is hard to pinpoint. As far as "hidden" stuff in a spreadsheet, that makes things for me even more confusing. I need to see everything directly in front of my eyes to "follow" how I created formulas and so forth. Joseph A. Spadaro (talk) 03:41, 8 May 2016 (UTC)
- Even if you want to have the final version as one big formula, I find that temporarily breaking it up can help with debugging. Once you have got it working, you can re-combine the parts into one equation. Iapetus (talk) 08:22, 11 May 2016 (UTC)
- Joseph, Did you try the new formula that I posted on the math desk?
The earlier calculation just doesn't seem right to me, having apparent inconsistent dimensionality - the first inner part calculates area, but the second and third parts calculate length. -- Tom N talk/contrib 21:36, 7 May 2016 (UTC)
- Thanks. No, I didn't get to that yet. But I will check it out. Thanks. Joseph A. Spadaro (talk) 03:43, 8 May 2016 (UTC)
- Turns out, the formula had a sign error. The following corrected version should give you the expected results:
=14.963*(1/2)*((A12-A1)*SQRT(1-((A12-A1)/A1)^2)-(A1*ASIN((A12-A1)/A1))-((PI()*A1)/2))
- More details on Mathematics desk. -- Tom N talk/contrib 03:21, 8 May 2016 (UTC)
Thanks, all. Joseph A. Spadaro (talk) 12:12, 9 May 2016 (UTC)
Can I edit ODK records online?
Can I manipulate Open Data Kit databases online? I can't find anything about editing (or removing or creating with un-real-timestamps) records, suggesting to me that it can't be done. (I'm working in KoBo Toolbox.) Perhaps it's part of a philosophy that anything and everything the collection forms collect must be carved in stone? Of course I can import the database somewhere and process it, but if, say, my first few records were tests, I'd have to delete them after every import, or build a work-around. Hayttom (talk) 16:47, 7 May 2016 (UTC)
- Honest, I didn't stage this: I just went back into the Data View screen and suddenly noticed the View Submission (tiny) icon. It brings up records with Edit and Delete options. While I can't access the timestamps, it's good enough for my purposes. Hayttom (talk) 17:13, 7 May 2016 (UTC)

Resolved