Chart Type | Example | Chart | Notes | Sample Data | Sample Legends | |
Simple Vertical Bar Chart | "=CHART.BAR(E2:E11)" |
|
Each of the char types accepts the following variables in this order:
*Values - as array (ie "a1:a2") or jagged/multidimensional arrays (ie "[a1:a2, b1:b2]") *Legend - as array from string (ie "['First Legend Label', 'Second Legend Label']") or from cell values (ie "a1:a2") *Axis Labels - as array, similar to legend *Height as integer *Width as integer EXAMPLE: =CHART.BAR(a1:a2, "Sales", "2009", 100, 100) |
1 | Nov | 2000 |
Simple Horizontal Bar Chart | "=CHART.BARH(E2:E11)" |
|
One thing to note about dynamic images it that column sizing can get a bit messed up. | 2 | Dec | 2001 |
Simple Stacked Vertical Bar Chart | "=CHART.SBAR(E2:E11)" |
|
3 | Jan | 2002 | |
Simple Stacked Horizontal Bar Chart | "=CHART.SBARH(E2:E11)" |
|
4 | Feb | 2003 | |
Simple Line Chart | "=CHART.LINE(E2:E11)" |
|
5 | Mar | 2004 | |
Simple Pie Chart | "=CHART.PIE(E2:E11)" |
|
7 | May | 2005 | |
Advanced Simple Vertical Bar Chart | "=CHART.BAR(E2:E7, ['Dec 2008 Sales' , 'Jan 2009 Sales', 'Feb 2009 Sales', 'Mar 2009 Sales', 'May 2009 Sales', 'June 2009 Sales'])" |
|
7 | June | 2006 | |
Advanced Horizontal Bar Chart | "=CHART.SBARH([E2:E7, E2:E7, E2:E7, E2:E7, E2:E7], F2:F7, G2:G7, 350,200)" |
|
7.5 | |||
Advanced Vertical Bar Chart | "=CHART.BARH([G2:G7, G2:G7, G2:G7, G2:G7, G2:G7], i2:i7, H2:H7, 350,500)" |
|
8 | |||
Advanced Line Chart | "=CHART.LINE([[105.7,97.9],[108.1,101.6],[110.7,102.9],[111.0,93.7],[110.0,89.8],[109.0,90.7],
[107.5,93.0],[106.1,94.5],[104.3,91.9],[102.0,93.9],[102.8,93.6],[103.8,92.6], [102.9,94.0],[102.1,92.7],[100.6,96.0],[101.7,97.9],[101.8,105.0], [103.3,104.1],[104.0,105.1],[103.7,108.1],[108.4,108.4],[109.4,113.8], [112.0,109.1],[112.6,106.3],[115.5,106.7],[115.7,108.8],[114.7,118.8], [115.9,120.4],[116.2,115.9],[118.0,124.7],[123.3,126.5],[127.6,131.6], [130.3,134.0],[135.5,135.7],[138.2,126.4],[139.6,127.4],[145.1,131.0], [146.4,129.9],[147.1,133.7],[149.0,138.4],[150.3,141.0],[151.3,139.3], [153.4,145.3],[152.7,142.9],[152.9,129.2],[152.2,126.0],[151.9,124.8], [150.1,125.9],[148.2,118.9],[145.3,122.9],[142.9,127.7],[142.6,134.4], [144.0,138.5],[145.5,138.7],[147.2,141.8],[150.0,139.2],[153.8,145.6], [155.4,147.6],[157.0,157.9],[158.4,156.2],[162.8,153.9],[162.8,158.6], [164.7,166.3],[168.5,165.8]], ["Dec 2008 Sales" , "Jan 2009 Sales"])" |
|
A bit more complicated :) | 8.2 |
Inputs are for capturing fixed data, such as a drop down list (INPUT.SELECT), or a checkbox (INPUT.CHECKBOX) | ||||
Input Type | Example | Data Number | Data String | |
Select List | "=INPUT.SELECT(D3:D10)" | 34 | Lorem | |
Radio List | "=INPUT.RADIO(E3:E10)" |
Lorem
Proin Aliquam Quisque Aliquam Vivamus Etiam Donec |
-20 | Proin |
Checkbox | "=INPUT.CHECKBOX(E3)" |
Lorem
|
123 | Aliquam |
Get Select List Value | "=INPUT.SELECTVAL(C3)" | 4 | 123 | Quisque |
Get Radio List Value | "=INPUT.RADIOVAL(C4)" | Donec | 4 | Aliquam |
Get Checkbox Value | "=INPUT.CHECKBOXVAL(C5)" | Lorem | 534456 | Vivamus |
Detect if Checkbox is Checked | "=INPUT.ISCHECKED(C5)" | FALSE | 3 | Etiam |
1 | Donec |
Things to note:
*This sheet has over 1000 cells *Every cell's value from a1-j101 is random*pi *Totals are at the bottom *The chart to the right represents their groups of 10 rows, summed, then averaged. |
|
||||||||
0.2647338793066901 | 2.413761360843914 | 1.4000915889592525 | 1.7503596059679758 | 2.099471085856105 | 2.516911911100154 | 1.4580200147088738 | 1.0046204278609112 | 1.5116131618467399 | 1.4897638457290632 |
2.457032697391881 | 2.573902914377174 | 0.33513811061063287 | 2.701581954879495 | 2.8801745119517532 | 0.7100571930615495 | 3.076141965982756 | 2.5289359569562695 | 1.915472952679172 | 2.80668551017537 |
1.144212775868431 | 0.638278852946185 | 0.6400306614848044 | 2.428674188775375 | 0.4343202197984417 | 0.5146148008647108 | 0.9995742599842418 | 0.5139513390566532 | 0.37060841854710924 | 3.1146769635103566 |
0.5262965958506395 | 0.8915670313413037 | 1.951656061945698 | 0.30583005313031475 | 1.2839656759605618 | 1.8854892112989086 | 1.0694520411647443 | 2.7838788103296386 | 2.862201655168715 | 1.5550599319039138 |
1.499976258021483 | 0.9485366423364284 | 1.0075365090700663 | 2.317500505027117 | 1.3403121551898438 | 0.25002097048512656 | 2.3145608178497503 | 0.9954448485702364 | 0.30447334192408687 | 2.5917797853710107 |
0.7308984755906015 | 1.5827789745745389 | 0.7540005066706419 | 2.659620625612244 | 1.065537310254483 | 1.7295102822842328 | 2.806844070444213 | 0.5554287288908989 | 3.009980139071445 | 0.5534300088113328 |
0.8169815001239772 | 1.4371122382770625 | 1.5627109359948872 | 3.0345978690097755 | 0.0803654591338264 | 0.996551824289667 | 0.9683944480805202 | 3.123975970830178 | 0.8355652556590869 | 1.7034559219939243 |
2.3971249030923873 | 1.2335126247535952 | 2.242043020950451 | 2.3007163632819876 | 1.7020997429167022 | 0.6442046346076467 | 0.7522353871008824 | 0.7729118307623375 | 2.79482632120975 | 2.279082092120312 |
3.02158256240366 | 0.20723142907182784 | 2.429974073506664 | 1.779516620017695 | 1.3207110653284175 | 2.404030177887453 | 0.001666030599780995 | 3.1346711916553454 | 2.334968691244703 | 0.06452463448244108 |
1.4521398155566674 | 1.8559218129981923 | 2.1965217352770168 | 0.32826557931693673 | 2.325631242363481 | 2.9049109711512204 | 3.009125540486748 | 1.5476878849634137 | 1.0995657778170314 | 0.16053557710689256 |
2.4468611558206788 | 0.453507772896656 | 2.846569347835862 | 1.7837449681351878 | 2.2620886632516477 | 0.49544013395402453 | 1.4845785844336274 | 1.666225636950054 | 2.4857008614331058 | 1.1287678694814098 |
0.9602258455029025 | 0.07936517785182294 | 2.470108724270537 | 3.0436724542145344 | 0.35527552951617547 | 0.12471994991453972 | 0.9423571359680218 | 2.4381099887194444 | 2.6292869828796657 | 0.936234233843277 |
0.5650612339151618 | 0.8942468261353542 | 2.575858053220821 | 3.0897368954640396 | 2.748251402861193 | 0.03838377096373599 | 0.11455309452136966 | 2.310229618922285 | 1.0139340988065078 | 1.8563831866948055 |
2.6996006332398537 | 3.1374658708323775 | 2.104926859690758 | 1.5221223445469452 | 1.8598052650422212 | 2.2374573809795852 | 0.7281929707200433 | 0.09665690533148731 | 2.2759380281202564 | 1.3990517652452426 |
2.1711545277900886 | 0.3998111215481049 | 1.7769531491771577 | 1.3819753829798045 | 1.850371040565656 | 0.6552923786212216 | 1.796439757892861 | 1.809577991557053 | 2.145470250405133 | 0.6607629943822294 |
1.0165271437499366 | 0.1994357017872779 | 2.3364782517752 | 3.0851284457261605 | 2.217618771168729 | 2.0775906832096256 | 2.586400328785032 | 0.3032665570865038 | 1.315231758944601 | 1.4054247203633479 |
3.0028188342603253 | 0.6514766867409966 | 1.5184360292559387 | 1.8814186428863582 | 2.058217755246458 | 0.08970679592905315 | 2.895012519519102 | 0.9483428144017945 | 1.376163141052633 | 2.051009243285178 |
0.8100946548187161 | 2.460053030383834 | 2.9577652977156803 | 0.895196194001883 | 2.974372156193655 | 1.7375464010734096 | 0.02028847144461501 | 1.7118027782836436 | 0.7435981039357146 | 0.8260815706704862 |
1.1809826682826852 | 0.927543062861452 | 1.1628511666263153 | 0.33987267562144463 | 1.2486317278921772 | 1.4512504699796822 | 1.161868909863748 | 1.4631285940371823 | 1.0466192364817635 | 1.740189482604736 |
3.0870194556036012 | 1.315622168846044 | 1.7589012514294136 | 1.6999871869947705 | 2.020661466940404 | 0.0406079436060076 | 0.29063895962952124 | 1.3292229645982403 | 1.815356461311965 | 1.5531359213030846 |
1.5108914829119473 | 0.6658909260554677 | 1.2463070487425179 | 1.2781493789023062 | 0.6859666108827873 | 0.514853508704715 | 2.2577943282185418 | 0.8438408640591524 | 1.1134395547470308 | 2.8985103941645107 |
1.6916903231602194 | 1.9305602577324592 | 0.09665596062468078 | 2.469255817225945 | 0.5630586620123108 | 1.477251537300845 | 0.47097237418635224 | 1.8005543872559784 | 2.43814398896388 | 2.596478726259993 |
1.1007762987805692 | 1.7460391816043488 | 0.9683419815522167 | 1.2615225076814607 | 2.8007109606136384 | 1.94944240954925 | 0.7418277610844178 | 2.883527137827919 | 2.98667292003044 | 0.7927089189196209 |
2.5447959259996726 | 0.8685048540421947 | 0.6426672584424925 | 0.22245924694348382 | 0.2926298519105857 | 1.221618508815165 | 1.2613231804146645 | 1.606694549840203 | 2.165061979646199 | 0.06376958591996819 |
2.9513716492846225 | 2.5840862197439805 | 0.24787916401285134 | 2.551912571405129 | 0.7453524555259535 | 2.662327733512086 | 1.1141984210952007 | 2.1497562314252705 | 2.9224445229255105 | 0.2414413468006932 |
3.1204071416530175 | 0.20520262988599733 | 1.990781765466615 | 0.6056248949505725 | 0.40916630364747125 | 2.753304732396005 | 0.6208230900238652 | 2.4467538862243803 | 1.8460800169812712 | 2.7414709196805305 |
0.08279362747613767 | 0.14071792170891204 | 2.0933625464992796 | 2.7060820446052714 | 0.48410888055873885 | 0.9581182071911029 | 1.38910039093738 | 1.37856002325564 | 1.1146832744020492 | 1.7596590372810792 |
0.0005664061475322075 | 0.7288087474281808 | 1.9492711998586472 | 2.707361540733848 | 2.223475530524434 | 0.6179767093075861 | 2.720296810331842 | 0.5845738818427313 | 0.8167324733811411 | 0.9554080569542512 |
2.236339567827419 | 0.973881326173714 | 2.6197489834480248 | 2.9833854816205303 | 2.072587790443684 | 2.10220262175516 | 0.8145326313154974 | 2.003557138801733 | 2.8337841918691615 | 1.1929343825357184 |
2.053262480482202 | 2.9355680009421685 | 1.294539564364656 | 1.6660069470320458 | 1.5005799836371267 | 1.056967045299082 | 2.590901257237081 | 1.5423637604846194 | 1.4019890348551332 | 1.830721682553439 |
3.0052490642094862 | 1.090123917513495 | 0.5458125293807223 | 0.0862227428295987 | 1.9486252054749515 | 2.0247450317639606 | 2.670557042516703 | 0.025705161830997948 | 2.075736039798927 | 1.3563631872596424 |
1.9690614001265252 | 2.1204157726654995 | 2.7848809944374238 | 0.3084016119845504 | 2.3377081166576343 | 1.5590490898764846 | 2.445587510705313 | 2.3470273465323825 | 2.364632677786267 | 1.9751624081463641 |
1.702360650757766 | 2.491177186033386 | 1.4841625109910843 | 1.648506822445265 | 0.6723534200283573 | 0.4610310462094329 | 1.8563175021112166 | 1.7607388726753646 | 0.5047463314226545 | 2.338026951678944 |
0.09459691173934921 | 0.28794540251013173 | 1.1931184715443839 | 0.8889321475723153 | 1.2810480685615169 | 0.5980553946671748 | 1.8441323811580186 | 2.7094076126342763 | 0.26150363270374566 | 1.1887757779470747 |
0.25777582056607634 | 2.4176266931320067 | 1.2978917140778592 | 3.003368190242272 | 2.79009583615608 | 2.8863990553588628 | 2.9633967818453217 | 0.07881647437477268 | 1.9426334033697665 | 1.3854513611970682 |
1.0539160438304864 | 0.08183977908587924 | 2.9978533595087753 | 1.9475916388227958 | 2.724782630147906 | 1.7144012778736408 | 1.6330807741110231 | 2.5035765558788166 | 1.107042236501548 | 0.9775697976192813 |
0.9560453506514348 | 0.023137082599689447 | 0.9586731374650417 | 2.074382182574634 | 1.9547436779139058 | 3.053819747703964 | 0.3834394622628682 | 1.175964264807509 | 2.8455679014574056 | 2.0279030543595566 |
3.0291539666987655 | 1.7953780306191318 | 1.2542441223002174 | 2.581411825780241 | 2.865150691641662 | 1.2343806299333973 | 0.21123306774964057 | 0.9867397829493545 | 2.556025339780271 | 1.4540846765585538 |
2.330232433972486 | 3.022050850004937 | 0.22355748278570847 | 1.8068263425959847 | 2.2387350845311134 | 0.5316711020013329 | 1.2512321762697356 | 2.3444977080408687 | 1.9361620838714042 | 2.68708849943878 |
1.07224703139008 | 2.144849059989423 | 1.8696825828364305 | 1.847739302178472 | 0.26486026059188994 | 2.6257714672514827 | 0.9014918760733952 | 0.8824631619874388 | 2.3690530776586813 | 1.767822725032993 |
0.8170836128665496 | 0.510149326063143 | 0.3348403805001335 | 1.4929902045305024 | 0.10517505317352398 | 2.4480573883783796 | 0.34437190798965556 | 2.6396397853809828 | 2.5591727339243766 | 1.7416460910669167 |
1.696009065334251 | 2.817373612250871 | 1.7277682973663724 | 2.8647790989669892 | 0.8881745613821175 | 0.5494376033769177 | 2.5553908774776346 | 0.5726032672838308 | 1.7727586434910987 | 1.0630595290669242 |
1.436371749409764 | 1.3355075385367707 | 2.6799064039828595 | 2.3032777075135105 | 2.572133321732195 | 2.976998481798097 | 2.0312785024946134 | 2.1880447503740457 | 1.9243074292816824 | 2.0668514235808084 |
2.5290861601799355 | 2.446535738195974 | 1.3930546219638897 | 1.4800306711493119 | 1.595267999344164 | 1.0753698730545573 | 0.47302480956291154 | 2.463173982740696 | 0.9231840525059801 | 1.6770128344274073 |
2.9387137358203135 | 1.7309066379529765 | 3.138289166887683 | 1.1888508729289526 | 1.3784926353355496 | 2.2872600921639825 | 2.272720332917404 | 2.2393229921091193 | 1.9243300792887046 | 2.540978175595053 |
0.8026581937709384 | 2.7118336107402112 | 1.1971771123455681 | 2.65394941218606 | 1.9873300732590182 | 1.1995110743676316 | 2.217599593581095 | 2.3188126874956563 | 2.361582245270126 | 2.4517720883270737 |
2.366253999250409 | 2.2075735226846476 | 0.4258297937663581 | 0.1426603650564797 | 1.321804775540301 | 1.9466197573669044 | 0.39656797099661184 | 2.4549418481248417 | 1.5823593585791524 | 1.761022278515477 |
2.8673079750481696 | 0.35616605315344846 | 0.8585575982501625 | 0.060596654230155846 | 2.826272709292519 | 3.0698480578897716 | 0.6395439553908825 | 1.1853310526458432 | 3.1347752154267607 | 0.47063756350679603 |
0.03735213999506881 | 2.615895019336889 | 1.4305103649511355 | 0.9655823988869725 | 0.24790302281954762 | 1.3984120302510727 | 2.6953785875568315 | 1.749420865512977 | 2.1411366924501607 | 0.287269467488198 |
2.8427479216663256 | 0.8304134793929441 | 0.9716027221220203 | 3.095801895690804 | 1.6076595154864792 | 1.8703886036239006 | 2.010657366672417 | 3.130353642632239 | 2.2256021331943456 | 3.1373999811073703 |
1.6529032827654766 | 0.9348823451362691 | 2.1442856959903014 | 2.811341359379817 | 1.8355410410830642 | 2.8024185081244783 | 0.5407278506225118 | 0.264255155761108 | 2.1821421236751264 | 0.9437612128280135 |
0.730643735976577 | 2.6870937651484197 | 2.8145179600317136 | 0.4622444719518035 | 0.6054775397414665 | 1.473717773241238 | 2.55107282324621 | 1.7468069970511744 | 1.173742449124993 | 1.8619773149238459 |
2.713992723929286 | 0.4930925002551995 | 2.737112019930285 | 1.2319322010948317 | 0.33713353324923406 | 0.3647467108932168 | 1.2598679964662027 | 1.0398157178811276 | 1.8652347853808928 | 2.9250522752943287 |
2.7211838668849047 | 0.906483741955112 | 2.1179870807772394 | 2.4512285520975063 | 2.9742000577032157 | 1.2347522278592862 | 2.0763040195406925 | 3.08569874893624 | 1.9092981697338205 | 3.0339815679303532 |
2.269218654474095 | 1.9051836400625175 | 3.133220298484993 | 0.6037441317389115 | 2.569778599254588 | 1.5102042131011373 | 2.3377433503899194 | 1.8050363046654885 | 2.763998370278045 | 2.397870167390905 |
0.5459540919102585 | 2.7564932549992016 | 0.984345855796429 | 2.7947087378327233 | 1.384584850019592 | 0.48306453216178397 | 0.7240569403728172 | 0.20084263292806614 | 0.05682243381610347 | 1.678496873150033 |
1.9805273800690413 | 1.7117058306734438 | 1.2682151905334944 | 2.4357469846410447 | 0.0620218415496925 | 2.424524730374929 | 0.8914592774013166 | 0.2944895768337534 | 2.2186896814621635 | 2.8154882435993893 |
2.351860136841834 | 1.7831837595617084 | 0.6680001600998091 | 1.624425096869684 | 1.494548629975934 | 1.1044221045449014 | 2.944298796368053 | 1.1705767074054476 | 0.26942342475654457 | 0.45218652296686995 |
1.0601025354990723 | 1.3050267205501667 | 0.42705615034023553 | 2.3573027186190227 | 1.669811013530081 | 0.27630614373126705 | 1.3902627657947444 | 0.671729440073476 | 0.9385184832523045 | 2.2828146664537536 |
1.94996443018765 | 2.597697824397461 | 0.050989786076332075 | 2.674474400573713 | 2.810852398252543 | 1.269797368713116 | 0.2929279682919303 | 2.026972868725011 | 1.149498068750447 | 1.4971223629191142 |
3.0089862972507 | 0.6185412520405978 | 0.08561184567949717 | 1.7845226332265742 | 1.9232124364254668 | 0.19141928982349213 | 2.7840397265132535 | 1.375913635821531 | 0.6428817940762981 | 1.2514515069300558 |
1.8715778210744598 | 0.33834881856772453 | 3.0276766600835914 | 1.195653613547778 | 0.013038892073170038 | 2.0402085647275134 | 0.661010025973576 | 2.144031115553023 | 0.0310676202595266 | 0.28368754088355774 |
3.1390950986950124 | 2.3556978155901622 | 0.17483729363091394 | 1.1935986712864424 | 0.7739982291478632 | 0.3357159925514064 | 1.6015137642397845 | 0.5732316679676485 | 3.0672208956766602 | 0.8341048125604806 |
0.21176561044621012 | 0.9020652333550917 | 1.7645678798682558 | 2.565841018700783 | 0.4907827090011024 | 2.142150751257919 | 1.7077196428257526 | 0.056332939544744276 | 0.48023485562642354 | 2.526638530537297 |
2.513311435196509 | 2.027524593679799 | 0.019547322612605014 | 0.5429433730515268 | 1.5044796544430452 | 0.16777745650401102 | 1.9556758258485225 | 1.5979574774044216 | 0.7264674650790722 | 0.8589159435866263 |
0.2973406919479593 | 1.832561408466002 | 2.721725362842549 | 1.8734403660784302 | 1.7426227470566675 | 1.1754897526925923 | 1.9059658519939895 | 1.2923384443545058 | 0.2928039096041819 | 2.1074495497886447 |
2.0252733642205567 | 0.38054949012208905 | 2.5856307389406674 | 0.18771688706355644 | 2.1883028920894296 | 2.2645969564461126 | 2.412184752260819 | 0.6728391491772984 | 2.232895118205675 | 0.3569053271893683 |
2.596634592080056 | 1.9995814348845162 | 2.5703878435787693 | 1.3780012043741654 | 1.9023553911752886 | 1.379106270594864 | 0.03844056546842655 | 1.9217265314560619 | 1.3147936079154523 | 1.2742983535899768 |
2.8701623085129 | 2.887057609925312 | 0.7286856495229486 | 1.425698324577001 | 0.9811871390739715 | 2.7189417468989023 | 2.451594806577318 | 2.2298086244480833 | 3.095003527118071 | 1.7552531122200195 |
1.5405034918788254 | 2.276051398528018 | 1.7615306677830749 | 2.218013521518753 | 0.7425732391254252 | 2.795031657577043 | 2.977213162301536 | 2.5763451576344174 | 0.9541257248480075 | 2.714095399132869 |
0.1700565834488122 | 1.4559628532858049 | 0.8026656573515224 | 2.478584361466301 | 0.6460659172341957 | 0.9930820438760442 | 2.1688402502059856 | 0.8317863386779932 | 2.5762394271850684 | 1.6444394766756998 |
0.4286823353613886 | 1.4418465868278565 | 1.6160716012859566 | 0.5449348594269665 | 1.7431737552521311 | 1.1065797323328295 | 2.8500098521804964 | 2.709489269190553 | 0.3830818523043915 | 3.0359464819328768 |
2.9326090262132825 | 0.43174503430562317 | 0.39195627380719716 | 1.5220045538387592 | 1.6226061038261834 | 0.47547418074173614 | 2.9476637693497016 | 1.4317123870063848 | 2.9244939624741675 | 0.4213339264302702 |
0.4854982067525734 | 2.4433451234892387 | 0.49004116900510286 | 0.8395547003580015 | 0.020306071535165605 | 2.7304814212321964 | 2.97543602821173 | 0.7994771998022393 | 0.841482761382811 | 1.2060177501585427 |
0.7956941946789817 | 0.9535060283958436 | 2.5787545499586515 | 3.065346104788541 | 3.06925974409236 | 1.1787900868701562 | 0.18557564614438748 | 3.133072943249741 | 2.8564143232818338 | 1.3123702520265241 |
0.7580504583189205 | 1.925859776483312 | 3.0739392973327675 | 2.7684643851604216 | 2.5925958300154606 | 1.9438368288694496 | 2.2819224248893777 | 0.33751185512472986 | 2.184180372998664 | 0.919320243276467 |
0.5237469540499624 | 0.6426429133704995 | 0.15593305483634928 | 2.6816243224230685 | 2.813843845817102 | 2.3668571445682387 | 1.6822189573806814 | 1.7990022512470196 | 1.576954135193661 | 0.4545033521608446 |
0.024483667119347845 | 0.8526276261237996 | 3.0642497880307524 | 1.6354576902030327 | 0.15641753125268323 | 2.6671444151540067 | 2.9216623027224005 | 0.5807429453692767 | 0.3689555412170657 | 1.899488038101216 |
0.14198466215145056 | 3.0042899505809353 | 2.72953039949616 | 1.4706729413715456 | 0.5771105368683109 | 0.8470737998704514 | 2.8371660725583707 | 2.5556364394239712 | 0.5333811316865883 | 2.7505219585507845 |
2.412292287376806 | 0.9850780753553154 | 0.6417964288622358 | 2.381365231947749 | 2.1884994120803123 | 0.9251500785578163 | 1.1150256287871496 | 1.172734298795235 | 0.3416548997245687 | 0.8424808235305699 |
1.5419600622923448 | 1.6255791580894101 | 1.397238633659237 | 2.387305269046267 | 1.3510126140613958 | 0.16945610939690076 | 1.314455561015216 | 0.6444364877757661 | 2.9423792270798828 | 1.172598016186375 |
0.7689213652513239 | 1.776774920608402 | 1.6983679075369678 | 2.566631784671105 | 2.6684018035807404 | 1.2863083508329656 | 3.019044730878082 | 1.189184285725791 | 1.5054514669498442 | 1.6156344323206415 |
0.5783929283725792 | 2.4806948851051516 | 1.6308435134737933 | 1.8302207995928106 | 3.127348318561812 | 1.9451518608846172 | 2.1082471576473476 | 1.2950310399246525 | 3.0570750810566554 | 0.7716240348447674 |
3.058901336031198 | 2.615370337168875 | 1.985704102287449 | 1.6303410381780397 | 1.351619751949336 | 2.8455132281808515 | 1.7560362413481128 | 1.8859357840561002 | 0.8551424577418163 | 0.9471288511643212 |
3.1206254379023206 | 2.7007178012299575 | 0.3528299054545951 | 1.180598326849297 | 1.2566301457292215 | 2.5820423251118765 | 1.3761724297517257 | 1.0492926490306702 | 0.41441745532496177 | 3.0812067111116455 |
0.1922572694861769 | 2.8817784105757234 | 0.9655655923255722 | 2.665357967538424 | 0.8572768194437819 | 1.058965859950673 | 1.6298246845267286 | 2.7453388733008692 | 1.7472961539877365 | 2.139634568425547 |
2.9922786108596875 | 2.67248824526632 | 2.449239803240613 | 2.310377435302663 | 2.9165131173090852 | 0.4285276118123154 | 2.622617217601418 | 0.3307602293322136 | 2.4179301393143513 | 1.353125708903911 |
2.1692348841270523 | 2.1163237160565145 | 0.8772645680678607 | 3.141071196036666 | 2.552796834246753 | 2.557553127941261 | 2.9443083758096273 | 0.30048754476577394 | 2.6583760977866615 | 1.1563684132774303 |
0.7518569700248995 | 2.817342698218563 | 1.1643801251260624 | 0.6615559521859333 | 1.1653454256222675 | 1.875381541268823 | 1.3265843685587777 | 0.8176598709160061 | 2.0531528193586515 | 0.8867322676504029 |
1.0441748130366124 | 0.1303156122263902 | 2.8698786068841167 | 3.0623461661297102 | 0.7817843789143553 | 1.1771441086127472 | 0.3239837321287835 | 2.1160769536240536 | 1.5716391275707842 | 1.4482720924693977 |
0.4812001938485319 | 1.2480811329789192 | 2.2612517993094166 | 1.6745719820696046 | 0.4865191674660293 | 0.3896801846671327 | 1.1745492664885822 | 1.165628624121849 | 1.745563306114476 | 0.42344889473270786 |
0.11699750763277415 | 1.0279114792087882 | 0.3420951069231132 | 1.8695662508164799 | 1.3197916269185745 | 0.20473501899243293 | 2.6468717148742003 | 0.8125389645838927 | 2.4756575053437415 | 0.011359886686387839 |
0.9542476054923734 | 2.958716713829498 | 0.0533347982815916 | 1.4257287327368393 | 2.5137031192088606 | 2.8415765360750505 | 0.30619873348732907 | 2.0767710565400113 | 0.9021300922237974 | 1.4966585230269913 |
1.3879497443864366 | 1.2497265676260907 | 2.9905804729337637 | 0.5971866756282875 | 2.69289340856215 | 1.3015245130828905 | 1.2919299460801799 | 1.0216505318293676 | 1.6491955876720097 | 2.914405223932224 |
2.445841934810648 | 0.3991832520119247 | 2.427408060237434 | 1.3383388605798525 | 2.0754070267721683 | 0.13504038280735628 | 2.6401837398013153 | 1.1823907911948628 | 1.3154515458356488 | 0.36748675954685894 |
0.7130336401047844 | 3.0137765815385116 | 2.4260041260505103 | 0.6294664008364665 | 1.740064370064979 | 2.2056118644197875 | 0.10997191017819699 | 2.7366552710884706 | 0.6479968052401849 | 2.6801469445234223 |
3.0004107010812393 | 2.854530553765256 | 0.9427654089643843 | 1.662499078433379 | 0.8716510902339432 | 2.651613913647602 | 2.462302506986233 | 0.22861092654757845 | 2.415677115506994 | 1.5612657847138638 |
2.2296889605438186 | 2.1499447550206727 | 1.6628266965614953 | 1.636122879557016 | 2.8520315271025893 | 0.7487298646769439 | 3.0485221468791344 | 2.5353021617307427 | 1.437763309423639 | 0.8008870666387029 |
2.726581415054266 | 0.46314363020445404 | 1.5404127187447572 | 0.8882812080423163 | 1.2081693549380232 | 2.5742202324934973 | 2.9944286362402996 | 1.4058951132932052 | 2.905278313452601 | 2.339883078514223 |
0.1308341167087695 | 2.0180463570712517 | 0.3513012119041232 | 1.8136828392175401 | 0.13671147515029677 | 2.4299716817374586 | 0.24552186795678824 | 1.557028006632421 | 1.0935015845665181 | 1.985486750936206 |
Sum: 1600.5881419562709 | Cell Count: 1000 | Average: 1.6005881419562709 | Rounded: 1,601 | Dollar Amount: $1,600.59 |