<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Hi all, </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
I am working on transferring 3 expressions from Excel to QGIS. To do this I need to change the syntax and the references/variables of my expressions. Different Excel functions are used in all 3 expressions, and I can't find them in QGIS. I've looked online
for some guidance but didn't find much. Does QGIS even have these functions in the field calculator?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Here are the functions I used in Excel:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
AVERAGE</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
NORM.DIST</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
LN </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
IF</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
OR</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
TRUE </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
FALSE</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
IFERROR</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
VLOOKUP</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
I also used the dollar sign which works as an absolute cell reference in Excel formulas. Does QGIS have a similar function?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
I am very new to QGIS and not even sure if what I want to do is even possible. My goal is to transfer these expressions in QGIS, along with the attribute tables and the data they're linked to. In theory, once the transfer is complete, the expressions would
stay in QGIS and if or when the data is updated or newer/more precise data is available, I could update the contents of the expressions, but not the functions themselves. </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Here are the equations as they are formatted in Excel:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="" class="elementToProof">
<ol data-editing-info="{"orderedStyleType":3,"unorderedStyleType":1}" data-listchain="__List_Chain_324" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<li style="list-style-type: "1) ";"><span class="ContentPasted0"><br>
</span>
<div style="list-style-type: "2) ";"><span class="ContentPasted0">=IF(Options!$C$8=Options!$P$8,NORM.DIST(LN(AVERAGE($P7)),LN(Q7),R7,TRUE),NORM.DIST(LN($F7),LN($D7),$E7,TRUE)*NORM.DIST(LN($F7/2),LN(Q7),R7,TRUE)+
<div class="ContentPasted0">(NORM.DIST(LN($G7),LN($D7),$E7,TRUE)-NORM.DIST(LN($F7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($F7:$G7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($H7),LN($D7),$E7,TRUE)-NORM.DIST(LN($G7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($G7:$H7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($I7),LN($D7),$E7,TRUE)-NORM.DIST(LN($H7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($H7:$I7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($J7),LN($D7),$E7,TRUE)-NORM.DIST(LN($I7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($I7:$J7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($K7),LN($D7),$E7,TRUE)-NORM.DIST(LN($J7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($J7:$K7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($L7),LN($D7),$E7,TRUE)-NORM.DIST(LN($K7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($K7:$L7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($M7),LN($D7),$E7,TRUE)-NORM.DIST(LN($L7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($L7:$M7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($N7),LN($D7),$E7,TRUE)-NORM.DIST(LN($M7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($M7:$N7)),LN(Q7),R7,TRUE)+</div>
<div class="ContentPasted0">(NORM.DIST(LN($O7),LN($D7),$E7,TRUE)-NORM.DIST(LN($N7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($N7:$O7)),LN(Q7),R7,TRUE)+</div>
(1-NORM.DIST(LN($O7),LN($D7),$E7,TRUE))*NORM.DIST(LN(AVERAGE($O7)),LN(Q7),R7,TRUE))<br>
</span></div>
</li></ol>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span class="ContentPasted0"><br>
</span></div>
<ol start="2" data-editing-info="{"orderedStyleType":3,"unorderedStyleType":1}" data-listchain="__List_Chain_324" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<li style="list-style-type: "2) ";"><span class="ContentPasted0 ContentPasted1"><br>
</span>
<div style="list-style-type: "3) ";"><span class="ContentPasted0 ContentPasted1">=IFERROR('Options'!Y3,0)*(0.02*(AC7-AD7)+0.1*(AD7-AE7)+0.4*(AE7-AF7)+AF7)</span><br>
</div>
<div style="list-style-type: "3) ";"><span class="ContentPasted0 ContentPasted1"><br>
</span></div>
</li><li style="list-style-type: "3) ";"><br>
<div style="list-style-type: "4) "; font-size: 14.6667px; font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic";">
<span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">=IF(OR(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">="OTF1",</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">="OTF2",</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">="SPRUNG
SHELTER"),0,(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(235, 94, 96); background-color: rgb(255, 255, 255);" class="ContentPasted2">$PC6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">-</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(141, 97, 194); background-color: rgb(255, 255, 255);" class="ContentPasted2">$PQ6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">)*(VLOOKUP(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,'HAZUS
- Collapse% + Casualties'!$B$14:$F$49,</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(45, 150, 57); background-color: rgb(255, 255, 255);" class="ContentPasted2">RW$4</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,FALSE)/100)+(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(141, 97, 194); background-color: rgb(255, 255, 255);" class="ContentPasted2">$PQ6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">-</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(191, 76, 145); background-color: rgb(255, 255, 255);" class="ContentPasted2">$QE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">)*(VLOOKUP(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,'HAZUS
- Collapse% + Casualties'!$B$55:$F$90,</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(45, 150, 57); background-color: rgb(255, 255, 255);" class="ContentPasted2">RW$4</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,FALSE)/100)+(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(191, 76, 145); background-color: rgb(255, 255, 255);" class="ContentPasted2">$QE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">-</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(227, 130, 34); background-color: rgb(255, 255, 255);" class="ContentPasted2">$QS6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">)*(VLOOKUP(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,'HAZUS
- Collapse% + Casualties'!$B$96:$F$131,</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(45, 150, 57); background-color: rgb(255, 255, 255);" class="ContentPasted2">RW$4</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,FALSE)/100)+(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(227, 130, 34); background-color: rgb(255, 255, 255);" class="ContentPasted2">$QS6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">-</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(55, 127, 158); background-color: rgb(255, 255, 255);" class="ContentPasted2">$QU6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">)*(VLOOKUP(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,'HAZUS
- Collapse% + Casualties'!$B$181:$F$216,</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(45, 150, 57); background-color: rgb(255, 255, 255);" class="ContentPasted2">RW$4</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,FALSE)/100)+(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(55, 127, 158); background-color: rgb(255, 255, 255);" class="ContentPasted2">$QU6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">)*(VLOOKUP(</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(95, 140, 237); background-color: rgb(255, 255, 255);" class="ContentPasted2">$NE6</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,'HAZUS
- Collapse% + Casualties'!$B$181:$F$216,</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; color: rgb(45, 150, 57); background-color: rgb(255, 255, 255);" class="ContentPasted2">RW$4</span><span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2">,FALSE)/100))</span><br>
</div>
</li></ol>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);">I
appreciate any and all help! </span><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);"><br>
</span></span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="font-family: Consolas, Monaco, Menlo, "Courier New", monospace, Calibri, sans-serif, "Mongolian Baiti", "Microsoft Yi Baiti", "Javanese Text", "Yu Gothic"; font-size: 14.6667px; display: inline !important; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);" class="ContentPasted2"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);">Thanks, </span></span></div>
<div style=""><font face="Arial, Helvetica, sans-serif" style="color: rgb(68, 68, 68);"><span style="font-size: 14.6667px;"> Simon</span></font></div>
</div>
</body>
</html>