Spreadsheet: 860545d1708609436-formulas-not-working-as-intended-not-sure-why-custom-sales-history-and-spa-analysis-tool-template90-aligw
Sheet: SALES HISTORY & SPA ANALYSIS

SALES HISTORY |  |  |  |  |  | RPS DATA |  |  |  |  |  |  |  | NO HISTORY ITEMS
SIM | SIM Description | [NAME] Months | Sales - 24 Months | Market Cost | Margin | [NAME] | Authorization Name | Contract Start Date | Contract Stop Date | Cost-Side Claim | Market Cost (Includes WTT) | Sell | Loaded Margin | SIM | [NAME]
 | EMT EMT-CONDUIT-1/2 1/2 16MM | 970 | 900.31 | 719.33 | 0.20101964878764 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 27.583 | 35.88 | 0.2312430323299889 |  | [NAME]
[PHONE] | EMT EMT-CONDUIT-3/4 3/4 21MM | 2400 | 3201.75 | 2722.82 | 0.1495838213477 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 27.583 | 35.88 | 0.2312430323299889 | 62001330000 | EMT EMT-CONDUIT-1/2 1/2 16MM
[PHONE] | EMT EMT-CONDUIT-1IN 1IN 27MM | 1750 | 3722.58 | 3248.61 | 0.127322985671228 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 64.155 | 97.37 | 0.3411214953271028 | 62001330010 | EMT EMT-CONDUIT-3/4 3/4 21MM
[PHONE] | EMT EMT-CONDUIT-1-1/4 1-1/4 35MM | 130 | 447.9 | 382.2 | 0.146684527796383 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 64.155 | 97.37 | 0.3411214953271028 | 62001330020 | EMT EMT-CONDUIT-1IN 1IN 27MM
[PHONE] | EMT EMT-CONDUIT-1-1/2 1-1/2 41MM | 70 | 284.76 | 243.24 | 0.145806995364517 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 73.708 | 115.3 | 0.3607285342584562 | 62001330030 | EMT EMT-CONDUIT-1-1/4 1-1/4 35MM
[PHONE] | EMT EMT-CONDUIT-2IN 2IN 53MM | 460 | 2511.19 | 2232.24 | 0.111082793416667 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 73.708 | 115.3 | 0.3607285342584562 | 62001330040 | EMT EMT-CONDUIT-1-1/2 1-1/2 41MM
[PHONE] | EMT EMT-90-ELL-1-1/4 1-1/4-90D-EL | 5 | 48.92 | 44.02 | 0.100163532297629 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 110.803 | 169.79 | 0.3474115083338241 | 62001330050 | EMT EMT-CONDUIT-2IN 2IN 53MM
[PHONE] | ABB CI5510 EMT SET-SCREW CPLG STEEL | 20 | 23.44 | 20.68 | 0.117747440273038 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 128.822 | 203.13 | 0.365814995323192 | 62001330330 | EMT EMT-90-ELL-1-1/4 1-1/4-90D-EL
[PHONE] | T-B CI5510 1-1/4-STL-SET-SCR-CPLG | 4 | 5.36 | 4.14 | 0.227611940298507 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 14.852 | 19.32 | 0.2312629399585921 | 62253841505 | ABB BC1110 UTLTY BOX 2-3/8IN WIDE 1
[PHONE] | ABB BC1104-L DEVICE BOX 2-1/2IN D 1 | 2 | 4.68 | 4.29 | 0.0833333333333333 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 37.331 | 48.56 | 0.2312397034596375 | 62253824510 | ABB CI5510 1-1/4-STL-SET-SCR-CPLG
[PHONE] | T-B BC1104-L SWBX-2-1/2X2X3-W/CLMP | 10 | 34.56 | 30.13 | 0.12818287037037 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 39.955 | 51.98 | 0.2313389765294344 | 62253875110 | ABB CI6110 LT CONNECTOR - IRON - 1-
[PHONE] | T-B BC1110 HANDY-BOX-L/BRKT-1-7/8 | 40 | 115.26 | 60.83 | 0.472236682283533 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 39.955 | 51.98 | 0.2313389765294344 | 62253875112 | ABB CI6112 LT CONNECTOR - IRON - 1-
[PHONE] | T-B CI6110 1-1/4IN-MALL-IRON-CONN | 8 | 177.68 | 116.4 | 0.344889689329131 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 39.955 | 51.98 | 0.2313389765294344 | 62253875116 | ABB CI6116 LT CONNECTOR - IRON - 2
[PHONE] | T-B CI6112 1-1/2IN-MALL-IRON-CONN | 4 | 151.1 | 90.01 | 0.404301786896095 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 40.867 | 53.16 | 0.2312452972159519
[PHONE] | T-B CI6116 2IN-MALL-IRON-CONN | 2 | 141.65 | 82.51 | 0.417507942110837 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 40.867 | 53.16 | 0.2312452972159519
[PHONE] | CSE 1HD363 3P-100A-SFTY-SW | 5 | 1827.45 | 1550.25 | 0.151686776655996 | 8460-CONTROL B SHEET-W | 0 | 2018-04-04 00:00:00 | 2099-12-31 00:00:00 | 0 | 40.867 | 53.16 | 0.2312452972159519
[PHONE] | CSE 1HD364 3P-200A-SFTY-SW | 1 | 597.04 | 506.75 | 0.151229398365269 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 71.063 | 112.46 | 0.3681042148319402
[PHONE] | EAT 1HD364 3P-200A-SFTY-SW | 2 | 1300.3 | 1066.24 | 0.180004614319772 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 330.214 | 622.93 | 0.4699019151429534
[PHONE] | HMN CSKO12124 12X12X4IN-SCR-CVR | 2 | 53.88 | 31.64 | 0.412769116555308 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 8.979 | 17.09 | 0.4746050321825629
[PHONE] | GRN 430 1PLY-6500FT-PULLLINE-B | 3 | 284.3 | 162.33 | 0.429018642279282 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 13.11 | 21.78 | 0.3980716253443527
[PHONE] | STL IT100SC 0-ANTI-SHORT-BAG/35 | 32 | 55.83 | 31.7 | 0.432204907755687 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 47.017 | 70.04 | 0.3287121644774415
[PHONE] | T&B H104-3/8X10EGC HANGER-ROD | 480 | 388.53 | 308.15 | 0.206882351427174 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 112.012 | 175.46 | 0.3616094836429956
[PHONE] | T&B A1200S10PGC 1-5/8X1-5/8-SLOT-CH | 40 | 350.37 | 167.81 | 0.521049176584753 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 150.163 | 219.67 | 0.3164155323894932
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABB BC1104-L DEVICE BOX 2-1/2IN D 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Left-aligned = TEXT | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Right-aligned = NUMBER | 0