I am trying to convert portions of this google sheets workbook into Excel.

Could anyone be so kind as to tell me how =getCurrentStakesText(D1) in cells J1:K1 works.
https://docs.google.com/spreadsheets...py?usp=sharing
Please advice if your not able to open file from google sheets.

getCurrentStakesText is a function written in Apps Script, Google's macro language. You cannot automatically convert this to Excel. The code would have to be rewritten in VBA.

Here is the Apps Script code:

Please Login or Register  to view this content.

Apps Script looks just like Java to me. This should do it but I haven't tested it yet.

Please Login or Register  to view this content.

You cannot automatically convert this to Excel. The code would have to be rewritten in VBA.

Is this still true? As MSFT tries to move away from VBA, I thought they had made it possible to write UDFs in other programming languages -- including Java and Javascript. If this is true, one of the big advantages I see is the possibility of writing a UDF in javascript like the OP has done and using it across different spreadsheet platforms, but I have not seen anyone anywhere try to explain how that would work.

Here's MSFT's introduction to UDFs using and Officescript add-in: https://learn.microsoft.com/en-us/of...tions-overview
Is there enough information in there to explain how to make an appscript/javascript udf available to Excel?

I don't have experience with using other languages for Excel macros but this looks promising. It does seem to require building an add-in.

This approach would obviate the need to rewrite the code but I don't know how you build in the API calls (like getRange), and it would still not be a one-click conversion process. I am wondering if it would be more straightforward for online Excel using Office Script, which I don't have access to.

I am trying to convert portions of this google sheets workbook into Excel. https://docs.google.com/spreadsheets...py?usp=sharing
Would like to get help move Cash table from tournament to cash games, and the stats in.
I would like the code to fill Cell O1 on the Cash Games sheet, and the data code will need is in colummns AF:AO on the Info sheet.
please feel free to ask any questions.
cheers

I looked at your file but did not see where that function was referenced in the worksheet. Was the formula converted to values?

I am working my way through testing the code. Your code refers to sheets "Bankroll Rules" and "Worksheet" but these do not exist in the Excel file you attached.

I could just try starting with your Google Sheets version instead but you have a lot of macro functions in there. If they are all needed, I don't have time to rewrite them all.

@ 6StringJazzer: I have been helping West123 with the workbook. I have included the Bankroll Rules and Worksheet sheets in the file. Hope that this helps.