Triangular diagram & histogram spreadsheet (TRI-PLOT2) "by David Graham (University of Wales, Aberystwyth)" and Nicholas Midgley (Liverpool John Moores University) "modified by Daniel Nývlt (Masaryk University, Brno, Czechia)" Introduction Instructions To generate SHAPE (Sneed and Folk) triangular diagrams To generate ROUNDNESS histograms References Technical notes Introduction top Instructions top top Data series User entered data Triangle outline Defines the triangle Left ticks Ticks on the left (c/a) axis Right ticks Ticks on the right (b/a) axis Bottom ticks Ticks on the bottom axis C40 line Defines the line where c/a = 0.4 Left axis lines Extension of left axis ticks across diagram Right axis lines Extension of right axis ticks across diagram Bottom axis lines Extension of bottom axis ticks across diagram top References top Technical notes top ##### Sheet/List 2 ##### SHAPE - data entry and results sheet Kolnovice VZOR Data entry area Plotting parameters area Error messages Clast axes Error messages Roundness Printer correction: 1.1 Clast no. a-axis b-axis c-axis Tick interval (0 - 0.5): 0.1 1 6.7 4.5 3.1 R Tick length (0 - 0.2): 0.03 2 5.9 4.2 2.1 SR Plot C40 line? (Y or N): y 3 6.2 3.2 1.1 SA L+R axis lines? (Y or N): n 4 6.4 5.7 2.2 SR Bot'm axis lines? (Y or N): n 5 6.2 3.5 2.1 SA Bot'm axis ticks? (Y or N): y 6 5.7 4.3 3.1 SR 7 6.2 3.4 2.7 SA 8 5.3 3.5 2.7 SA VZOR 9 7.1 6.2 2.3 SA 10 5.8 4.3 3.1 SA 11 4.4 3.6 2.5 SA 12 4.1 3.5 3.1 SR 13 6.6 4.5 2.8 SA 14 4.7 3.3 2.5 SA 15 4.6 3.7 2.3 SR 16 4.6 3.8 2.5 SA 17 4.2 3.5 3.1 SA 18 5.5 4.3 2.7 SR 19 4.2 3.7 1.5 SR 20 6.3 4.5 2.7 SA 21 5.3 3.5 2.6 SR 22 5.1 3.6 2.3 SA 23 6.8 4.2 2.5 SA 24 5.2 4.3 2.7 SA 25 4.6 3.7 1.5 SR 26 5.1 4.3 3.5 SR 27 6.2 3.8 1.7 SA 28 4.6 3.5 3.1 SR 29 6.2 4.5 2.1 SA 30 5.2 4.3 3.1 SA 31 6.6 4.8 3.1 SR 32 5.9 4.3 2.7 SR 33 6.3 4.8 3.1 SA 34 5.7 4.3 3.1 SR 35 5.4 3.1 2.7 SA 36 4.5 4.3 2.1 R 37 5.3 3.4 2.7 SA 38 4.3 3.6 2.1 SR 39 5.4 3.8 2.2 SR 40 4.4 4.1 2.8 SR 41 6.2 3.8 3.1 SA 42 5.3 4.1 2.7 SA 43 6.6 4.2 2.1 SR 44 5.5 4.1 3.8 SA 45 6.5 4.8 3.2 SA 46 5.4 4.6 3.1 SR 47 5.2 3.8 3.1 SR 48 5 3.3 2.7 SR 49 4.7 4.1 2.3 SA 50 7.2 5.6 3.1 R 51 7.8 4.6 3.1 SA 52 6.2 3.2 2.7 SA 53 5.4 4.2 3.7 SA 54 4.6 3.8 2.9 SR 55 5.2 3.9 1.7 SR 56 5.6 3.4 1.7 SR 57 6.2 4.5 3.9 A 58 5.8 4.3 3.9 SA 59 5.2 4.3 2 SR 60 4.6 3.7 1.5 SA 61 3.8 3.2 2.7 SR 62 4.5 3.7 2.1 SR 63 5.4 4.2 3.7 SA 64 5.1 4.1 3.3 SA 65 4.2 3.5 2.7 SR 66 5.6 4.1 2.3 SA 67 5.7 4.6 2.3 SR 68 5.5 4.1 3.6 SA 69 5.7 4 1.3 SA 70 5.2 3.9 2.1 SA 71 7.1 4.2 2.3 SA 72 5.3 3.2 2.7 SR 73 7.1 5.3 2.1 SR 74 4.2 3.5 2.7 SR 75 6.2 3.8 2.7 SA 76 7.4 3.3 2.1 SA 77 7.5 4.2 2.3 SR 78 6.1 4.5 2.7 SR 79 4.3 3.8 1.1 SA 80 7.2 4.1 1.5 SA 81 5.2 3.3 2.7 SR 82 5.4 3.8 2.1 SA 83 6.4 4.2 1.3 SR 84 4.3 3.8 2.7 SA 85 6.2 4.1 2.5 SR 86 5.3 3.7 2.7 SR 87 5.2 4.3 2.9 SR 88 5.3 4.9 2.1 SR 89 7.2 5.4 2.7 SR 90 4.4 3.5 2.1 SA 91 3.8 3.2 2.9 SA 92 4.3 4 2.1 SA 93 6.2 4.1 2.5 SA 94 4.6 4 2.1 SR 95 5.3 3.8 2.1 SA 96 6.3 4.2 3.1 SA 97 5.9 4.3 3.7 SA 98 7.3 4 2.1 SR 99 6.5 5.1 4.3 SR 100 6.2 3.3 2.7 SR AVER 5.57 4.04 2.58 ##### Sheet/List 3 ##### roundness pieces shares (%) very angular 0 angular 1 subangular 51 subrounded 45 rounded 3 well rounded 0 100 ##### Sheet/List 4 ##### SHAPE - calculations Calculations area: do not change It should not be necessary to modify the contents of this sheet unless you wish to modify the operation of TRI-PLOT. Triangle outline C40 line x y x y 0.5 0.9526 0.2 0.38104 0 0 0.8 0.38104 1 0 0.5 0.9526 Plotting parameters Printer correction: 1.1 Bot'm axis lines?: 0 Left (c/a ratio) axis ticks Right (b/a ratio) axis ticks Left axis lines Right axis lines Bottom axis lines Bottom axis ticks Tick interval: 0.1 Bot'm axis ticks?: 1 Tick position x y x y x y x y x y x-calc y-calc x y Tick length: 0.03 0 0 0 1 0 0 0 0 0 0 0 0 0 Plot C40 line?: 1 -0.03 0 1.015 0.028578 0 0 -0.01500033 -0.024749092 -0.01500033 -0.024749092 Plot lines?: 0 0 0 1 0 0 0 0 0 Data area Calculated values: do not change 0.1 0.05 0.09526 0.95 0.09526 0 0 0 0 0.5 0.9526 0.1 0 0.1 0 Clast axes Clast axis ratios Graph co-ordinates 0.02 0.09526 0.965 0.123838 0 0 0 0 0.5 0.9526 0.087420278 -0.025944155 0.087420278 -0.025944155 Clast no. a-axis b-axis c-axis c/a b/a x y 0.05 0.09526 0.95 0.09526 0.1 0 0.1 0 1 6.7 4.5 3.1 0.462686567 0.671641791 0.559701493 0.440755224 0.2 0.1 0.19052 0.9 0.19052 0 0 0 0 0.5 0.9526 0.2 0 0.2 0 2 5.9 4.2 2.1 0.355932203 0.711864407 0.466101695 0.339061017 0.07 0.19052 0.915 0.219098 0 0 0 0 0.5 0.9526 0.190179938 -0.027003587 0.190179938 -0.027003587 3 6.2 3.2 1.1 0.177419355 0.516129032 0.572580645 0.169009677 0.1 0.19052 0.9 0.19052 0.5 0.9526 0.2 0 0.2 0 4 6.4 5.7 2.2 0.34375 0.890625 0.28125 0.32745625 0.3 0.15 0.28578 0.85 0.28578 0 0 0 0 0.3 0 0.3 0 5 6.2 3.5 2.1 0.338709677 0.564516129 0.60483871 0.322654839 0.12 0.28578 0.865 0.314358 0 0 0 0 0.293249285 -0.027845067 0.293249285 -0.027845067 6 5.7 4.3 3.1 0.543859649 0.754385965 0.51754386 0.518080702 0.15 0.28578 0.85 0.28578 0.3 0 0.3 0 7 6.2 3.4 2.7 0.435483871 0.548387097 0.669354839 0.414841935 0.4 0.2 0.38104 0.8 0.38104 0 0 0 0 0.5 0.9526 0.4 0 0.4 0 8 5.3 3.5 2.7 0.509433962 0.660377358 0.594339623 0.485286792 0.17 0.38104 0.815 0.409618 0 0 0 0 0.5 0.9526 0.396558664 -0.028389353 0.396558664 -0.028389353 9 7.1 6.2 2.3 0.323943662 0.873239437 0.288732394 0.308588732 0.2 0.38104 0.8 0.38104 0.5 0.9526 0.4 0 0.4 0 10 5.8 4.3 3.1 0.534482759 0.74137931 0.525862069 0.509148276 0.5 0.25 0.4763 0.75 0.4763 0 0 0 0 0.5 0 0.5 0 11 4.4 3.6 2.5 0.568181818 0.818181818 0.465909091 0.54125 0.22 0.4763 0.765 0.504878 0 0 0 0 0.5 -0.028578 0.5 -0.028578 12 4.1 3.5 3.1 0.756097561 0.853658537 0.524390244 0.720258537 0.25 0.4763 0.75 0.4763 0.5 0 0.5 0 13 6.6 4.5 2.8 0.424242424 0.681818182 0.53030303 0.404133333 0.6 0.3 0.57156 0.7 0.57156 0 0 0 0 0.5 0.9526 0.6 0 0.6 0 14 4.7 3.3 2.5 0.531914894 0.70212766 0.563829787 0.506702128 0.27 0.57156 0.715 0.600138 0 0 0 0 0.5 0.9526 0.603441336 -0.028389353 0.603441336 -0.028389353 15 4.6 3.7 2.3 0.5 0.804347826 0.445652174 0.4763 0.3 0.57156 0.7 0.57156 0.5 0.9526 0.6 0 0.6 0 16 4.6 3.8 2.5 0.543478261 0.826086957 0.445652174 0.517717391 0.7 0.35 0.66682 0.65 0.66682 0 0 0 0 0.7 0 0.7 0 17 4.2 3.5 3.1 0.738095238 0.833333333 0.535714286 0.703109524 0.32 0.66682 0.665 0.695398 0 0 0 0 0.706750715 -0.027845067 0.706750715 -0.027845067 18 5.5 4.3 2.7 0.490909091 0.781818182 0.463636364 0.46764 0.35 0.66682 0.65 0.66682 0.7 0 0.7 0 19 4.2 3.7 1.5 0.357142857 0.880952381 0.297619048 0.340214286 0.8 0.4 0.76208 0.6 0.76208 0 0 0 0 0.5 0.9526 0.8 0 0.8 0 20 6.3 4.5 2.7 0.428571429 0.714285714 0.5 0.408257143 0.37 0.76208 0.615 0.790658 0 0 0 0 0.5 0.9526 0.809820062 -0.027003587 0.809820062 -0.027003587 21 5.3 3.5 2.6 0.490566038 0.660377358 0.58490566 0.467313208 0.4 0.76208 0.6 0.76208 0.5 0.9526 0.8 0 0.8 0 22 5.1 3.6 2.3 0.450980392 0.705882353 0.519607843 0.429603922 0.9 0.45 0.85734 0.55 0.85734 0 0 0 0 0.9 0 0.9 0 23 6.8 4.2 2.5 0.367647059 0.617647059 0.566176471 0.350220588 0.42 0.85734 0.565 0.885918 0 0 0 0 0.912579722 -0.025944155 0.912579722 -0.025944155 24 5.2 4.3 2.7 0.519230769 0.826923077 0.432692308 0.494619231 0.45 0.85734 0.55 0.85734 0.9 0 0.9 0 25 4.6 3.7 1.5 0.326086957 0.804347826 0.358695652 0.310630435 1 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 1 0 1 0 26 5.1 4.3 3.5 0.68627451 0.843137255 0.5 0.653745098 0.47 0.9526 0.515 0.981178 0 0 0 0 0.5 0.9526 1.01500033 -0.024749092 1.01500033 -0.024749092 27 6.2 3.8 1.7 0.274193548 0.612903226 0.524193548 0.261196774 0.5 0.9526 0.5 0.9526 0.5 0.9526 1 0 1 0 28 4.6 3.5 3.1 0.673913043 0.760869565 0.576086957 0.641969565 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 29 6.2 4.5 2.1 0.338709677 0.725806452 0.443548387 0.322654839 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 30 5.2 4.3 3.1 0.596153846 0.826923077 0.471153846 0.567896154 0.5 0.9526 0.5 0.9526 0 0 0 0 31 6.6 4.8 3.1 0.46969697 0.727272727 0.507575758 0.447433333 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 32 5.9 4.3 2.7 0.457627119 0.728813559 0.5 0.435935593 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 33 6.3 4.8 3.1 0.492063492 0.761904762 0.484126984 0.468739683 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 34 5.7 4.3 3.1 0.543859649 0.754385965 0.51754386 0.518080702 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 35 5.4 3.1 2.7 0.5 0.574074074 0.675925926 0.4763 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 36 4.5 4.3 2.1 0.466666667 0.955555556 0.277777778 0.444546667 0.5 0.9526 0.5 0.9526 0 0 0 0 37 5.3 3.4 2.7 0.509433962 0.641509434 0.613207547 0.485286792 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 38 4.3 3.6 2.1 0.488372093 0.837209302 0.406976744 0.465223256 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 39 5.4 3.8 2.2 0.407407407 0.703703704 0.5 0.388096296 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 40 4.4 4.1 2.8 0.636363636 0.931818182 0.386363636 0.6062 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 41 6.2 3.8 3.1 0.5 0.612903226 0.637096774 0.4763 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 42 5.3 4.1 2.7 0.509433962 0.773584906 0.481132075 0.485286792 0.5 0.9526 0.5 0.9526 0 0 0 0 43 6.6 4.2 2.1 0.318181818 0.636363636 0.522727273 0.3031 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 44 5.5 4.1 3.8 0.690909091 0.745454545 0.6 0.65816 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 45 6.5 4.8 3.2 0.492307692 0.738461538 0.507692308 0.468972308 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 46 5.4 4.6 3.1 0.574074074 0.851851852 0.435185185 0.546862963 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 47 5.2 3.8 3.1 0.596153846 0.730769231 0.567307692 0.567896154 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 48 5 3.3 2.7 0.54 0.66 0.61 0.514404 0.5 0.9526 0.5 0.9526 0 0 0 0 49 4.7 4.1 2.3 0.489361702 0.872340426 0.372340426 0.466165957 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 50 7.2 5.6 3.1 0.430555556 0.777777778 0.4375 0.410147222 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 "To expand the number of clasts, copy the contents of columns A-J into the rows below." 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 51 7.8 4.6 3.1 0.397435897 0.58974359 0.608974359 0.378597436 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 52 6.2 3.2 2.7 0.435483871 0.516129032 0.701612903 0.414841935 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 53 5.4 4.2 3.7 0.685185185 0.777777778 0.564814815 0.652707407 0.5 0.9526 0.5 0.9526 0 0 0 0 54 4.6 3.8 2.9 0.630434783 0.826086957 0.489130435 0.600552174 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 55 5.2 3.9 1.7 0.326923077 0.75 0.413461538 0.311426923 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 56 5.6 3.4 1.7 0.303571429 0.607142857 0.544642857 0.289182143 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 57 6.2 4.5 3.9 0.629032258 0.725806452 0.588709677 0.599216129 58 5.8 4.3 3.9 0.672413793 0.74137931 0.594827586 0.640541379 59 5.2 4.3 2 0.384615385 0.826923077 0.365384615 0.366384615 60 4.6 3.7 1.5 0.326086957 0.804347826 0.358695652 0.310630435 61 3.8 3.2 2.7 0.710526316 0.842105263 0.513157895 0.676847368 62 4.5 3.7 2.1 0.466666667 0.822222222 0.411111111 0.444546667 63 5.4 4.2 3.7 0.685185185 0.777777778 0.564814815 0.652707407 64 5.1 4.1 3.3 0.647058824 0.803921569 0.519607843 0.616388235 65 4.2 3.5 2.7 0.642857143 0.833333333 0.488095238 0.612385714 66 5.6 4.1 2.3 0.410714286 0.732142857 0.473214286 0.391246429 67 5.7 4.6 2.3 0.403508772 0.807017544 0.394736842 0.384382456 68 5.5 4.1 3.6 0.654545455 0.745454545 0.581818182 0.62352 69 5.7 4 1.3 0.228070175 0.701754386 0.412280702 0.217259649 70 5.2 3.9 2.1 0.403846154 0.75 0.451923077 0.384703846 71 7.1 4.2 2.3 0.323943662 0.591549296 0.570422535 0.308588732 72 5.3 3.2 2.7 0.509433962 0.603773585 0.650943396 0.485286792 73 7.1 5.3 2.1 0.295774648 0.746478873 0.401408451 0.28175493 74 4.2 3.5 2.7 0.642857143 0.833333333 0.488095238 0.612385714 75 6.2 3.8 2.7 0.435483871 0.612903226 0.60483871 0.414841935 76 7.4 3.3 2.1 0.283783784 0.445945946 0.695945946 0.270332432 77 7.5 4.2 2.3 0.306666667 0.56 0.593333333 0.292130667 78 6.1 4.5 2.7 0.442622951 0.737704918 0.483606557 0.421642623 79 4.3 3.8 1.1 0.255813953 0.88372093 0.244186047 0.243688372 80 7.2 4.1 1.5 0.208333333 0.569444444 0.534722222 0.198458333 81 5.2 3.3 2.7 0.519230769 0.634615385 0.625 0.494619231 82 5.4 3.8 2.1 0.388888889 0.703703704 0.490740741 0.370455556 83 6.4 4.2 1.3 0.203125 0.65625 0.4453125 0.193496875 84 4.3 3.8 2.7 0.627906977 0.88372093 0.430232558 0.598144186 85 6.2 4.1 2.5 0.403225806 0.661290323 0.540322581 0.384112903 86 5.3 3.7 2.7 0.509433962 0.698113208 0.556603774 0.485286792 87 5.2 4.3 2.9 0.557692308 0.826923077 0.451923077 0.531257692 88 5.3 4.9 2.1 0.396226415 0.924528302 0.273584906 0.377445283 89 7.2 5.4 2.7 0.375 0.75 0.4375 0.357225 90 4.4 3.5 2.1 0.477272727 0.795454545 0.443181818 0.45465 91 3.8 3.2 2.9 0.763157895 0.842105263 0.539473684 0.726984211 92 4.3 4 2.1 0.488372093 0.930232558 0.313953488 0.465223256 93 6.2 4.1 2.5 0.403225806 0.661290323 0.540322581 0.384112903 94 4.6 4 2.1 0.456521739 0.869565217 0.358695652 0.434882609 95 5.3 3.8 2.1 0.396226415 0.716981132 0.481132075 0.377445283 96 6.3 4.2 3.1 0.492063492 0.666666667 0.579365079 0.468739683 97 5.9 4.3 3.7 0.627118644 0.728813559 0.584745763 0.59739322 98 7.3 4 2.1 0.287671233 0.547945205 0.595890411 0.274035616 99 6.5 5.1 4.3 0.661538462 0.784615385 0.546153846 0.630181538 100 6.2 3.3 2.7 0.435483871 0.532258065 0.685483871 0.414841935