Tissue Compartment gas loading spreadsheet

[EFX]

Switching to metric crashes excel......

I had a similar problem developing the ss in Excel 2010 running under Win7. Making any selection in the common row crashed Excel. I couldn't find a fix for that particular problem from Microsoft. It has to do with the worksheet_change function in sheet2.

To fix this do the following:

1. open the ss and press alt-F8. This opens up the VB editor.
2. select calc_press from the left window .
3. click on edit in the right window.
4. double click on sheet2 (DIVE) in the left window. This opens up the sheet2 VB module.
5. In the right window click inside the parenthesis of the if (true) then statement and change the true to false.
6. save the file and close the VB editor.

This change will prevent the DIVE sheet from recognizing cells whose values have changed so you will not get a notice to recalculate, but the ss will work without crashing.

 

[EFX]

If you disable the code in the worksheet_change function you will not receive any indication that any of the cells on the DIVE sheet have changed. This has one important implication. If the values you see don't make sense with the profiles you have entered click calculate. You may have changed the profile(s), got interrupted, and forgot to press calculate. This was the main reason for the worksheet_change function; to alert the user that a change was made that requires a recalculate.

BTW, if you are interested in the code behind the DIVE sheet follow steps 1-3 in the above post. calc_press is the name of the subroutine that starts the entire program behind the DIVE sheet. When you click on calculate from the ss the subroutine that gets run is calc_press(). All the code behind the DIVE sheet is in the DIVE module of which the starting routine is calc_press. You can leave the VB window open and switch to the ss to calculate various profiles.

 

[BenjaminF]

Thank you very much!

 

[EFX]

This is version 22.1. I fixed a problem that switched to the main2 gas when the %O2 was zero. I also added and cleaned up the comments on the dive_help sheet and in the VB code.

Akimbo: I reverted back to posting a link to the spreadsheet on Tinyupload's server. While uploading a file is simpler and more convenient I cannot delete the link or attachment once the post is a few days old. I rather not keep old copies of the ss when revisions are soooooo much better.

dive_022818_v22_1.xls

 

[EFX]

This is version 23.0. I added a minimum first stop time to the deco common. You can select 1, 2, or 3 minutes. I removed the helium half-time multiplier from the deco common and put it in the program constants. I also added a nitrogen half-time multiplier to program constants. I took it out of the deco common because most divers won't need to change the ht's. I changed the order of data on the ss, grouping the data where it makes more sense.

dive_030318_v23_0.xls

 

[EFX]

This is version 23.1. I fixed a problem with deco dives on fresh water not showing correct deco. I created another subroutine to initialize data. The a/b and half-time arrays are initialized once now. The ss should run much faster. For those of you whose ss crashes when you change a parameter from a drop down box you will need to change the true to a false within the sheet 2 VB code. See the instructions in an earlier post.

dive_030618_v23_1.xls

 

[EFX]

This is version 24.0. Here are the changes:

1. The calculation for the ceiling was not using the correct helium a/b coefficients. Fixed.
2. The CNS %O2 decay was not being calculated correctly. Fixed.
3. The total CNS %O2 for the profile is now shown in the last segment of each profile.
4. The CNS %O2 decay total is now shown next to the Use GF from GF sheet at the top of the dive sheet.
5. Added enable events to the DIVE sheet VB code. This should prevent Excel from crashing when changing data. If it doesn't see the fix in an earlier post in this thread.
6. Added a N2 and He on and offgassing rate constant to calculate TC pressures using a linear rate instead of the default Schreiner exponential rate.
7. made some minor changes to the DIVE sheet.

dive_040318_v24_0.xls