{"id":141,"date":"2017-04-08T00:07:18","date_gmt":"2017-04-08T00:07:18","guid":{"rendered":"http:\/\/sites.warnercnr.colostate.edu\/jerryv\/?page_id=141"},"modified":"2017-09-21T17:31:22","modified_gmt":"2017-09-21T17:31:22","slug":"calculating-pci2-excel","status":"publish","type":"page","link":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/calculating-pci2-excel\/","title":{"rendered":"Calculating PCI2 in Excel"},"content":{"rendered":"<p class=\"par-reg\">PCI<sub>2<\/sub> Excel has 2 input forms and 1 results form<\/p>\n<p>On Form 1, specify:<br \/>\n<span class=\"left60\">Scale type (e.g., Bipolar, Unipolar)<\/span><br \/>\n<span class=\"left60\">Scale width (i.e., minimum &amp; maximum scale values)<\/span><br \/>\n<span class=\"left60\">Distance function (i.e., D<sub>1<\/sub>, D<sub>2<\/sub>, or D<sub>3<\/sub>)<\/span><br \/>\n<span class=\"left60\">Power function (default = 1)<\/span><br \/>\n<span class=\"left60\">Number of simulated replications (default n = 400)<\/span><\/p>\n<p>On Form 2, input observed frequency distribution<\/p>\n<p>Download the Excel workbook <a href=\"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-content\/uploads\/sites\/76\/2017\/04\/PCI2_09-16-2010.xls\">Potential Conflict Index version 2.0<\/a><\/p>\n<p>Be sure to <u>enable<\/u> macros when you open the workbook<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PCI2 Excel has 2 input forms and 1 results form On Form 1, specify: Scale type (e.g., Bipolar, Unipolar) Scale width (i.e., minimum &amp; maximum scale values) Distance function (i.e., D1, D2, or D3) Power function (default = 1) Number&hellip; <\/p>\n","protected":false},"author":117,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-141","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/pages\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/users\/117"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":3,"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/pages\/141\/revisions"}],"predecessor-version":[{"id":192,"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/pages\/141\/revisions\/192"}],"wp:attachment":[{"href":"https:\/\/sites.warnercnr.colostate.edu\/jerryv\/wp-json\/wp\/v2\/media?parent=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}