MrRhodes2004
09-15-2006, 12:16 PM
TxDOT has produced a spreadsheet that calculates four values for the use in the design of their bridges. It is a good spreadsheet to use for the most part and has been verified. The problem is that the agency has locked down the file so that it cannot be effectively be used.
Typically, you need these factors for multiple bridges that have different cases, and situations. The file does not allow the copying of the sheet for different cases. The only thing that you can do is enter the information, write down the factors, and then enter the next case. A VERY tedious process. There are also other items in the spreadsheet that resets themselves at the change of information. If you forget to check that, your information may be wrong.
I would like to have a file that has all the different cases as user input then a results area where the four pieces of data are collected. There is a sample of what I am looking for and the distribution_factors.xls file.
I do not want to change their file. I just want to be able to make it more usable. Any ideas?
Typically, you need these factors for multiple bridges that have different cases, and situations. The file does not allow the copying of the sheet for different cases. The only thing that you can do is enter the information, write down the factors, and then enter the next case. A VERY tedious process. There are also other items in the spreadsheet that resets themselves at the change of information. If you forget to check that, your information may be wrong.
I would like to have a file that has all the different cases as user input then a results area where the four pieces of data are collected. There is a sample of what I am looking for and the distribution_factors.xls file.
I do not want to change their file. I just want to be able to make it more usable. Any ideas?