I ran across an Excel spreadsheet that simulates what 100 randomly generated equity curves look like given a percent win, ave win, ave loss, win stdeva, loss stdeva. Is there a way to calculate the standard deviation of the wins and losses without exporting to Excel, sorting and running the stdeva function?

Take a look under TradersStudio Macro's at the Monti-Carlo Macro. This will give you an example of what I think you are looking for.