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 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 28.90 18.60 9.60 SR Tick length (0 - 0.2): 0.03 2 15.10 14.45 12.10 SR Plot C40 line? (Y or N): y 3 19.05 12.60 12.00 SR L+R axis lines? (Y or N): n 4 16.00 11.05 7.35 R Bot'm axis lines? (Y or N): n 5 21.65 10.30 9.20 R Bot'm axis ticks? (Y or N): y 6 13.80 9.75 8.60 R 7 23.15 17.85 7.48 SA 8 16.59 11.37 11.06 SA 9 24.17 15.34 13.58 SR 10 21.88 13.70 12.84 SA 11 24.51 13.99 11.57 A 12 18.52 13.20 9.55 SR 13 19.65 12.88 10.62 R 14 13.63 10.02 9.76 SR 15 18.80 12.35 5.47 SR 16 14.44 13.42 7.92 SR 17 21.03 9.70 5.22 SR 18 16.68 11.24 10.18 R 19 15.84 14.11 8.50 R 20 12.35 9.30 8.92 WR 21 19.54 14.59 2.93 SA 22 22.81 17.69 7.19 SR 23 12.59 11.87 7.77 SR 24 13.77 10.66 6.29 R 25 13.34 11.76 9.51 SR 26 14.56 12.63 11.11 SR 27 14.83 10.25 7.00 WR 28 17.04 11.69 10.63 R 29 26.01 14.55 13.44 SR 30 29.40 15.62 10.91 SR 31 31.25 18.60 16.40 SA 32 18.00 11.65 10.00 SR 33 16.65 11.55 7.50 SA 34 16.60 12.75 6.50 A 35 20.70 15.20 9.60 SA 36 21.35 19.65 13.00 R 37 16.60 12.20 8.45 SA 38 17.45 9.96 6.91 SR 39 17.35 12.81 11.86 SR 40 16.26 15.57 13.87 SR 41 16.89 10.24 5.18 A 42 15.06 11.92 7.69 R 43 16.13 8.69 6.91 SR 44 13.13 10.68 5.90 SR 45 16.89 13.90 10.76 SR 46 16.86 12.40 7.59 SR 47 14.67 11.61 5.50 A 48 15.27 15.13 8.73 SR 49 12.80 8.82 7.94 SR 50 17.51 13.41 7.11 SR 51 12.25 11.74 7.97 A 52 11.11 9.67 5.69 SA 53 11.08 9.12 6.46 SR 54 14.03 10.78 9.80 SR 55 18.34 15.88 7.24 SA 56 17.80 9.77 8.61 R 57 17.21 11.30 9.80 SR 58 16.86 11.46 8.90 A 59 15.90 14.14 12.10 SR 60 13.86 10.38 7.26 SR 61 29.70 18.20 9.12 SR 62 14.48 12.10 9.28 SR 63 13.46 12.30 7.92 R 64 24.42 11.60 8.10 A 65 21.90 11.18 7.80 SR 66 15.20 8.18 8.14 SR 67 16.20 9.82 6.52 SR 68 22.54 15.70 8.60 R 69 14.12 12.12 8.82 SA 70 21.38 15.40 9.62 A 71 19.38 11.04 5.90 SR 72 12.98 11.20 8.66 R 73 14.30 9.62 8.60 SA 74 16.68 13.00 9.40 R 75 15.88 10.01 7.46 SR 76 15.46 10.94 6.46 SR 77 11.92 11.42 8.07 SR 78 15.82 15.72 10.33 R 79 16.85 9.75 7.56 SR 80 18.30 12.65 11.57 SA 81 15.65 14.09 9.79 SA 82 18.39 11.80 7.90 SA 83 14.91 10.87 10.48 A 84 18.70 9.70 7.23 SR 85 17.21 8.99 6.53 SA 86 14.69 11.55 9.89 A 87 14.83 10.43 7.46 SA 88 15.86 10.95 7.87 SR 89 16.07 10.08 5.36 SA 90 14.08 9.69 6.92 SR 91 13.73 10.02 5.67 SR 92 14.82 11.64 3.63 A 93 14.46 10.15 5.11 SA 94 11.04 9.56 6.62 SA 95 9.78 8.82 7.74 SR 96 13.14 11.50 7.22 SR 97 10.78 8.22 5.44 SA 98 12.59 11.10 5.66 A 99 13.20 10.37 6.82 SA 100 11.87 11.23 9.35 SA AVER 16.92 12.10 8.50 ##### Sheet/List 3 ##### 8-16 mm quartz shares (%) very angular 0 angular 12 subangular 23 subrounded 47 rounded 16 well rounded 2 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 28.9 18.6 9.6 0.332179931 0.643598616 0.522491349 0.316434602 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 15.1 14.45 12.1 0.801324503 0.956953642 0.443708609 0.763341722 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 19.05 12.6 12 0.62992126 0.661417323 0.653543307 0.600062992 0.1 0.19052 0.9 0.19052 0.5 0.9526 0.2 0 0.2 0 4 16 11.05 7.35 0.459375 0.690625 0.5390625 0.437600625 0.3 0.15 0.28578 0.85 0.28578 0 0 0 0 0.3 0 0.3 0 5 21.65 10.3 9.2 0.424942263 0.475750577 0.736720554 0.4048 0.12 0.28578 0.865 0.314358 0 0 0 0 0.293249285 -0.027845067 0.293249285 -0.027845067 6 13.8 9.75 8.6 0.623188406 0.706521739 0.605072464 0.593649275 0.15 0.28578 0.85 0.28578 0.3 0 0.3 0 7 23.15 17.85 7.48 0.323110151 0.771058315 0.39049676 0.30779473 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 16.59 11.37 11.06 0.666666667 0.685352622 0.647980711 0.635066667 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 24.17 15.34 13.58 0.561853537 0.63467108 0.646255689 0.53522168 0.2 0.38104 0.8 0.38104 0.5 0.9526 0.4 0 0.4 0 10 21.88 13.7 12.84 0.586837294 0.626142596 0.667276051 0.559021207 0.5 0.25 0.4763 0.75 0.4763 0 0 0 0 0.5 0 0.5 0 11 24.51 13.99 11.57 0.472052224 0.570787434 0.665238678 0.449676948 0.22 0.4763 0.765 0.504878 0 0 0 0 0.5 -0.028578 0.5 -0.028578 12 18.52 13.2 9.55 0.515658747 0.712742981 0.545086393 0.491216523 0.25 0.4763 0.75 0.4763 0.5 0 0.5 0 13 19.65 12.88 10.62 0.540458015 0.655470738 0.61475827 0.514840305 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 13.63 10.02 9.76 0.716067498 0.735143067 0.622890682 0.682125899 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 18.8 12.35 5.47 0.290957447 0.656914894 0.48856383 0.277166064 0.3 0.57156 0.7 0.57156 0.5 0.9526 0.6 0 0.6 0 16 14.44 13.42 7.92 0.548476454 0.929362881 0.344875346 0.52247867 0.7 0.35 0.66682 0.65 0.66682 0 0 0 0 0.7 0 0.7 0 17 21.03 9.7 5.22 0.248216833 0.461245839 0.662862577 0.236451355 0.32 0.66682 0.665 0.695398 0 0 0 0 0.706750715 -0.027845067 0.706750715 -0.027845067 18 16.68 11.24 10.18 0.610311751 0.673860911 0.631294964 0.581382974 0.35 0.66682 0.65 0.66682 0.7 0 0.7 0 19 15.84 14.11 8.5 0.536616162 0.890782828 0.377525253 0.511180556 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 12.35 9.3 8.92 0.722267206 0.753036437 0.608097166 0.688031741 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 19.54 14.59 2.93 0.149948823 0.74667349 0.328300921 0.142841249 0.4 0.76208 0.6 0.76208 0.5 0.9526 0.8 0 0.8 0 22 22.81 17.69 7.19 0.315212626 0.775537045 0.382069268 0.300271548 0.9 0.45 0.85734 0.55 0.85734 0 0 0 0 0.9 0 0.9 0 23 12.59 11.87 7.77 0.617156473 0.942811755 0.365766481 0.587903257 0.42 0.85734 0.565 0.885918 0 0 0 0 0.912579722 -0.025944155 0.912579722 -0.025944155 24 13.77 10.66 6.29 0.456790123 0.774146696 0.454248366 0.435138272 0.45 0.85734 0.55 0.85734 0.9 0 0.9 0 25 13.34 11.76 9.51 0.712893553 0.88155922 0.474887556 0.679102399 1 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 1 0 1 0 26 14.56 12.63 11.11 0.763049451 0.867445055 0.51407967 0.726880907 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 14.83 10.25 7 0.472016183 0.691166554 0.544841537 0.449642616 0.5 0.9526 0.5 0.9526 0.5 0.9526 1 0 1 0 28 17.04 11.69 10.63 0.623826291 0.686032864 0.625880282 0.594256925 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 29 26.01 14.55 13.44 0.516724337 0.559400231 0.698961938 0.492231603 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 30 29.4 15.62 10.91 0.371088435 0.531292517 0.654251701 0.353498844 0.5 0.9526 0.5 0.9526 0 0 0 0 31 31.25 18.6 16.4 0.5248 0.5952 0.6672 0.49992448 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 32 18 11.65 10 0.555555556 0.647222222 0.630555556 0.529222222 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 33 16.65 11.55 7.5 0.45045045 0.693693694 0.531531532 0.429099099 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 34 16.6 12.75 6.5 0.391566265 0.768072289 0.427710843 0.373006024 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 35 20.7 15.2 9.6 0.463768116 0.734299517 0.497584541 0.441785507 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 36 21.35 19.65 13 0.608899297 0.920374707 0.384074941 0.580037471 0.5 0.9526 0.5 0.9526 0 0 0 0 37 16.6 12.2 8.45 0.509036145 0.734939759 0.519578313 0.484907831 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 38 17.45 9.96 6.91 0.395988539 0.570773639 0.62722063 0.377218682 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 39 17.35 12.81 11.86 0.683573487 0.73832853 0.603458213 0.651172104 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 40 16.26 15.57 13.87 0.85301353 0.957564576 0.468942189 0.812580689 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 41 16.89 10.24 5.18 0.306690349 0.606275903 0.547069272 0.292153227 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 42 15.06 11.92 7.69 0.51062417 0.791500664 0.463811421 0.486420584 0.5 0.9526 0.5 0.9526 0 0 0 0 43 16.13 8.69 6.91 0.428394296 0.538747675 0.675449473 0.408088407 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 44 13.13 10.68 5.9 0.449352628 0.813404417 0.411271896 0.428053313 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 45 16.89 13.9 10.76 0.637063351 0.822972173 0.495559503 0.606866548 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 46 16.86 12.4 7.59 0.450177936 0.735468565 0.489620403 0.428839502 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 47 14.67 11.61 5.5 0.374914792 0.791411043 0.396046353 0.357143831 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 48 15.27 15.13 8.73 0.571709234 0.990831696 0.295022921 0.544610216 0.5 0.9526 0.5 0.9526 0 0 0 0 49 12.8 8.82 7.94 0.6203125 0.6890625 0.62109375 0.590909688 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 50 17.51 13.41 7.11 0.406053684 0.765848087 0.437178755 0.386806739 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 12.25 11.74 7.97 0.650612245 0.958367347 0.366938776 0.619773224 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 52 11.11 9.67 5.69 0.512151215 0.870387039 0.385688569 0.487875248 0.5 0.9526 0.5 0.9526 0 0 0 0 0 0 0 0 53 11.08 9.12 6.46 0.583032491 0.823104693 0.468411552 0.555396751 0.5 0.9526 0.5 0.9526 0 0 0 0 54 14.03 10.78 9.8 0.698503207 0.768353528 0.580898076 0.665394155 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 55 18.34 15.88 7.24 0.39476554 0.865866957 0.331515812 0.376053653 0.5 0.9526 0.5 0.9526 0 0 0 0 0.5 0.9526 0 0 0 0 56 17.8 9.77 8.61 0.483707865 0.548876404 0.692977528 0.460780112 0.5 0.9526 0.5 0.9526 0.5 0.9526 0 0 0 0 57 17.21 11.3 9.8 0.569436374 0.656595003 0.628123184 0.54244509 58 16.86 11.46 8.9 0.527876631 0.679715302 0.584223013 0.502855279 59 15.9 14.14 12.1 0.761006289 0.889308176 0.491194969 0.724934591 60 13.86 10.38 7.26 0.523809524 0.748917749 0.512987013 0.498980952 61 29.7 18.2 9.12 0.307070707 0.612794613 0.540740741 0.292515556 62 14.48 12.1 9.28 0.640883978 0.835635359 0.48480663 0.610506077 63 13.46 12.3 7.92 0.588410104 0.913818722 0.38038633 0.560519465 64 24.42 11.6 8.1 0.331695332 0.475020475 0.690827191 0.315972973 65 21.9 11.18 7.8 0.356164384 0.510502283 0.667579909 0.339282192 66 15.2 8.18 8.14 0.535526316 0.538157895 0.729605263 0.510142368 67 16.2 9.82 6.52 0.402469136 0.60617284 0.595061728 0.383392099 68 22.54 15.7 8.6 0.381543922 0.696539485 0.494232476 0.36345874 69 14.12 12.12 8.82 0.624645892 0.858356941 0.453966006 0.595037677 70 21.38 15.4 9.62 0.449953227 0.720299345 0.504677268 0.428625444 71 19.38 11.04 5.9 0.304437564 0.569659443 0.58255934 0.290007224 72 12.98 11.2 8.66 0.667180277 0.862865948 0.470724191 0.635555932 73 14.3 9.62 8.6 0.601398601 0.672727273 0.627972028 0.572892308 74 16.68 13 9.4 0.563549161 0.779376499 0.502398082 0.53683693 75 15.88 10.01 7.46 0.4697733 0.630352645 0.604534005 0.447506045 76 15.46 10.94 6.46 0.417852523 0.7076326 0.501293661 0.398046313 77 11.92 11.42 8.07 0.677013423 0.958053691 0.38045302 0.644922987 78 15.82 15.72 10.33 0.652970923 0.993678887 0.332806574 0.622020101 79 16.85 9.75 7.56 0.448664688 0.578635015 0.645697329 0.427397982 80 18.3 12.65 11.57 0.632240437 0.691256831 0.624863388 0.60227224 81 15.65 14.09 9.79 0.625559105 0.900319489 0.412460064 0.595907604 82 18.39 11.8 7.9 0.429581294 0.641653072 0.573137575 0.409219141 83 14.91 10.87 10.48 0.70288397 0.729040912 0.622401073 0.66956727 84 18.7 9.7 7.23 0.386631016 0.518716578 0.67459893 0.368304706 85 17.21 8.99 6.53 0.379430564 0.522370715 0.667344567 0.361445555 86 14.69 11.55 9.89 0.673247107 0.786249149 0.550374404 0.641335194 87 14.83 10.43 7.46 0.50303439 0.703304113 0.548213082 0.47919056 88 15.86 10.95 7.87 0.496216898 0.690416141 0.557692308 0.472696217 89 16.07 10.08 5.36 0.333540759 0.627255756 0.539514624 0.317730927 90 14.08 9.69 6.92 0.491477273 0.688210227 0.557528409 0.46818125 91 13.73 10.02 5.67 0.412964312 0.729788784 0.476693372 0.393389803 92 14.82 11.64 3.63 0.244939271 0.785425101 0.337044534 0.23332915 93 14.46 10.15 5.11 0.353388658 0.701936376 0.474757953 0.336638036 94 11.04 9.56 6.62 0.599637681 0.865942029 0.433876812 0.571214855 95 9.78 8.82 7.74 0.791411043 0.901840491 0.493865031 0.75389816 96 13.14 11.5 7.22 0.549467275 0.875190259 0.399543379 0.523422527 97 10.78 8.22 5.44 0.504638219 0.762523191 0.489795918 0.480718367 98 12.59 11.1 5.66 0.449563145 0.881652105 0.343129468 0.428253852 99 13.2 10.37 6.82 0.516666667 0.785606061 0.472727273 0.492176667 100 11.87 11.23 9.35 0.787700084 0.946082561 0.447767481 0.7503631