Data and results of predimensioning plate-to-plate joints obtained by the KinkJoint spreadsheet

A spreadsheet with graphical features has been developed to size the bolted extended plate-to-plate joints of rafters in polygonal portal frames. The graphical features of the spreadsheet are reflected in the diagram of the polygonal frame and the dimensioned drawing of the end-plate, with the position of the bolt holes. The spreadsheet constantly shows the maximum and minimum spacing conditions of the bolts, both between them and between the bolts and the edges of the plate. As the position of the bolts, their diameter, or the thickness of the plate is modified, the spreadsheet provides the utilisation percentage in relation to the bending moments and the shear force. A fixed control panel, permanently displayed in the upper-right corner of the interface during data input, continuosly reports key indicators: uttlisation ratios for positive/negative bending and shear, estimated joint rotational stiffness, recommended weld throat thicknesses with their utilisation ratios, and goberning failure modes for each bolt-row.研发了一款搭载可视化功能的电子表格（spreadsheet），用于开展多边形门式刚架（polygonal portal frames）中椽条的螺栓连接外伸端板节点（bolted extended plate-to-plate joints）的尺寸设计与验算工作。 该电子表格的可视化功能通过多边形门式刚架示意图以及标注了螺栓孔位置的端板施工图得以体现。 该电子表格可持续展示螺栓之间、螺栓与板边缘之间的最大与最小间距要求。当螺栓位置、螺栓直径或板厚发生修改时，该电子表格会给出对应弯矩与剪力作用下的节点承载力利用率。 在数据输入阶段，界面右上角固定显示的控制面板会持续报告核心指标： - 正/负弯矩与剪力的承载力利用率 - 估算的节点转动刚度 - 推荐的焊缝焊脚厚度及其承载力利用率 - 各螺栓排的控制破坏模式