Defining a variable through user input in Office Scripts

Hello all,

I am setting up a script for my company in the Office 365 version of Excel that takes the raw timber volume output from our computation software and organizes it into tables and graphs to be used for management plans and other communications with our clients. The computation software automatically organizes our data into stand types, but my boss would like the script to also create a tab that presents the aggregate data of all the stands as a total for the entire property. The problem with this is that our computation software provides the data on a per acre basis for the stands and does not show the acreage for each stand in the output that the script is using. This information is readily available to anyone in our company, but because I am using Office Scripts instead of VBA for security reasons I cannot fully automate pulling that information into the file.

Currently, I have a required user input tab that the user must fill out the stand acreages in before running the script but I would like the script to be able to be run directly from the raw data after copying it into the worksheet. Ideally this would be done by prompting the user to enter the stand acres into the script and have it save the answer as a variable as it runs but I have not been able to find the commands for this functionality on the Microsoft 365 documentation website or anything on StackOverflow that explains how to set this up. Does anyone know how to do this in Office Scripts?