Spreadsheet: 802674d1666966763-how-to-write-a-formula-to-perform-column-or-row-scaling-of-data-prior-to-making-a-heatmap-scaled-and-unscaled-data
Sheet: Sheet1

Unscaled data |  |  |  |  | Scaled data
 | F1-F3 | F4-F6 | F7-F8 |  |  | F1-F3 | F4-F6 | F7-F8
VPS11 | 3.470869435083701 | 3.692095877644739 | 3.697142067919648 |  | VPS11 | -1 | 0.955397254969253 | 1
VPS16 | 3.491999276636599 | 3.712459718980041 | 3.691113807616809 |  | VPS16 | -1 | 1 | 0.806351550996354
VPS18 | 3.706224532466392 | 3.810278833419593 | 3.789610140863924 |  | VPS18 | -1 | 1 | 0.602732566240305
VPS26B | 3.777808081456174 | 3.844448969347779 | 3.847098733186207 |  | VPS26B | -1 | 0.923517421982076 | 1
VPS28 | 3.590639455228018 | 3.701635465553399 | 3.710061206783414 |  | VPS28 | -1 | 0.858891012394737 | 1
VPS29 | 3.832589446715708 | 3.967752480691639 | 3.904844197170159 |  | VPS29 | -1 | 1 | 0.0691495792750134
VPS33A | 3.49623041148065 | 3.707070675395274 | 3.67244203875898 |  | VPS33A | -1 | 1 | 0.671517802213378
VPS33B | 3.493500070816831 | 3.633527927249526 | 3.634765459323466 |  | VPS33B | -1 | 0.982479330754375 | 1
VPS36 | 3.377781455345727 | 3.516529813930113 | 3.514380310819628 |  | VPS36 | -1 | 1 | 0.969015804836678
VPS39 | 3.323669541345685 | 3.611988630306377 | 3.636384884688659 |  | VPS39 | -1 | 0.843971490995724 | 1
VPS4A | 3.362904530435068 | 3.591156425379435 | 3.692140754113796 |  | VPS4A | -1 | 0.386553960521046 | 1
VPS4B | 3.393641608040909 | 3.566922838019684 | 3.574700103945727 |  | VPS4B | -1 | 0.91409112411791 | 1
VTA1 | 3.656901674275808 | 3.812489916643417 | 3.865220279309616 |  | VTA1 | -1 | 0.493752728829562 | 1
WDR48 | 3.91613210447781 | 3.949494655007882 | 3.95181815975245 |  | WDR48 | -1 | 0.869780802238528 | 1
ANKRD13B | 3.20590361248751 | 3.379701680849968 | 3.383210182710202 |  | ANKRD13B | -1 | 0.960424457414891 | 1
ARL8B | 3.851989173358298 | 3.929093855634344 | 3.968951175775672 |  | ARL8B | -1 | 0.318456946400438 | 1
CHID1 | 3.721013680167405 | 3.860708859994244 | 3.861339240490274 |  | CHID1 | -1 | 0.991015457275496 | 1
CHMP3 | 3.697224573251725 | 3.82620468110424 | 3.83279131850243 |  | CHMP3 | -1 | 0.902828125201214 | 1
CHMP4A | 3.488396304210391 | 3.569700242989146 | 3.552951842206757 |  | CHMP4A | -1 | 1 | 0.58800518070926
CHMP4B | 3.897506261093889 | 3.980706833658695 | 3.941226983299408 |  | CHMP4B | -1 | 1 | 0.0509716666063478
DERL1 | 3.302467481348119 | 3.494918767037293 | 3.64481046347055 |  | DERL1 | -1 | 0.124318567864485 | 1
DERL2 | 3.248592566756618 | 3.371806488783434 | 3.579634438407679 |  | DERL2 | -1 | -0.255599169903853 | 1
ECPAS | 3.320657196147847 | 3.489231766910793 | 3.468724160097843 |  | ECPAS | -1 | 1 | 0.756693945947656
EXOC8 | 3.457100031148756 | 3.667912006010852 | 3.687837839526983 |  | EXOC8 | -1 | 0.827285925473745 | 1
FIG4 | 3.311707701276667 | 3.485723082300562 | 3.494272121910354 |  | FIG4 | -1 | 0.906344953960718 | 1
HTT | 3.506917611703606 | 3.649955487883221 | 3.650701841275834 |  | HTT | -1 | 0.989618424846267 | 1
KIDINS220 | 3.287055692260255 | 3.446059521765052 | 3.399431678999136 |  | KIDINS220 | -1 | 1 | 0.413500380322487
MTM1 | 3.566517355524715 | 3.668721819317208 | 3.672034495978397 |  | MTM1 | -1 | 0.937210643750468 | 1
MYO5A | 3.607847997653801 | 3.75616802724897 | 3.732284451382792 |  | MYO5A | -1 | 1 | 0.677945373509344
PIK3R4 | 3.277993116456841 | 3.518295342560741 | 3.516652961469119 |  | PIK3R4 | -1 | 1 | 0.986330704311398
RAB22A | 3.725649491752287 | 3.929300240704297 | 3.965067740560809 |  | RAB22A | -1 | 0.701213253087341 | 1
UBXN6 | 3.686551610579212 | 3.888050282077804 | 3.859171436324085 |  | UBXN6 | -1 | 1 | 0.713359442631155
UVRAG | 3.166197236605003 | 3.312929734233145 | 3.378773101987354 |  | UVRAG | -1 | 0.380518878417555 | 1
VAC14 | 3.456636618180223 | 3.611941351649573 | 3.608918146426062 |  | VAC14 | -1 | 1 | 0.961067442621015
VIPAS39 | 3.417881460919613 | 3.667353037901179 | 3.638377374921583 |  | VIPAS39 | -1 | 1 | 0.767703693301004