There are several steps to the above video.
- Paste list of chemical names to a column. This list has "sarin" as the first chemical.
- In the cell to the right of "sarin" paste the Cactus service url to acquire the information you seek, in this case the molar mass of Sarin
- Go to the cell below the cell in step 2 and use the Replace function in Excel to replace the word "sarin" in the above script with the chemical name in the first column of the chemical below "sarin". This function has 4 attributes.
- Old Text: Is the string you want to replace (the Cactus look-up URL in step 2)
- Start, num: The number of characters from the start of the string where you want to start replacing text ("s" is the 46th character in).
- Num, char: The number of characters you want to replace (Sarin has 5 characters, so we want to replace 5 characters)
- New_text: We want to replace with the text of the cell next to this cell in the column of chemical names. You can click the icon to the right of the text box for this input, or type in the cell's row and column.
- Grab the "black square" in the bottom right corner of the cell you made the replace function in, and drag down, repeating this for every cell in the column of names until they have all been embedded into the script.
- Go to the top of the next column (next to the cell with the script for Sarin) and use the Web Service Function
- Place the data in the cell with the script for the Sarin lookup into the parenthesis (do not paste the text, but the cell number).
- Click "enter" and the Molar Mass should be returned.
- Grab the black square in the bottom right corner and drag down, converting all you chemicals to their molar masses.
*Note* The column of molar masses are connected to the two functions and if any of them change, the values will change. So it is a good idea to copy the column of molar masses and paste it to another column as "(V) values" (the icon with "123")". This is shown in the above video.