This project has been implemented as a degree of Bachelor of Science education in Mechanical Engineering at the University of Karlstad during the spring of 2016. The work has been carried out by Hannah Jordansson, a student at the Faculty of Health, Nature and Technology science. The main task of the project was to develop a calculation program in Excel for industrial conveyors for the company ÅF Industry. ÅF Industry requested a calculation program to use as a tool when building the conveyors. The conveyors consist of two different types, one rolling conveyor and one chain conveyor. The two types will be developed separately in the calculation program. The goal with the work was to build a program that will give the user the right outputs from certain inputs. The desired outputs from ÅF Industry for both conveyors was the deflection of the trolley tracks, if needed a cross beam and also information about the required drive. During the development of functional calculation program the work began with preparing all the equations needed. The equations were then put together and evaluated. When all of the equations were approved they were put in and performed in Excel. The calculation program is completed, tested and evaluated. The program has been formed to a layout that meet ÅF Industry’s requests.

I laborationssalarna på KTH i Södertälje, som i huvudsak används till elektrorelaterade ämnen, har det funnits ett antal balkmodeller med monterade töjningsgivare. Dessa har inte använts på många år och det saknas vidare uppgifter om modellerna. Uppdraget bestod av att utarbeta en laboration till KTH:s undervisning. Laborationen skulle handla om balkböjning och signalbehandling, med tonvikt på̊ det senare. Som hjälpmedel skulle vi använda oss av balkmodellerna. I uppdraget ingick det också att undersöka balkmodellernas elektriska och mekaniska egenskaper. Med teknisk balkteori skulle en möjlig relation mellan nedböjning och töjning tas fram. Med balkmodellen i en bryggkoppling kunde dess signal via ett DAQ-kort överföras till en PC och LabVIEW för vidare behandling. I LabVIEW kan ett anpassat gränssnitt tas fram och för visning av valda parametrar. Bryggkopplingen balanseras med hjälp av en potentiometer. I gränssnittet kan spänningsförändringen i bryggan observeras när balken påverkas av nedböjning. Efter kalibrering av systemet kan töjning och nedböjning presenteras efter beräkningar i LabVIEW. För att erhålla en så stabil och brusfri signal som möjligt har gruppen använt sig avbåde ett hårdvarufilter av lågpass-typ och ett mjukvarufilter i LabVIEW. Signalen förstärks med hjälp av en OP-förstärkare innan den matas in i DAQ-kortet. Trots sin ålder kunde balkmodellerna fortfarande användas och ge stabila signaler för vidarebehandling. Modellerna kan med fördel användas i en laboration för studenter och färdigt underlag finns för detta. Laborationen bör öka förståelsen för hur en signal från en givare kan förstärkas, filtreras och behandlas vidare i detta fall för grundläggande hållfasthetsberäkningar. / In the laboratory at KTH in Södertälje, which are mainly used for electro-related subjects, there are a number of beam models with mounted strain gauges. These have not been used for many years and there is no further information about the models. The assignment consisted of preparing a laboratory task for KTH's teaching. The laboratory would consist of beam bending and signal processing, with emphasis on the latter. As an aid, the beam models will be used, these consisted of a fixed aluminum beam with mounted strain gauges. The assignment also includes examining the electrical and mechanical properties of the beam models. With technical beam theory, a possible relationship between deflection and strain would be developed. With the beam model connected in a bridge connection, its signal could be transferred via a DAQ card to a PC and LabVIEW for further processing. In LabVIEW, a custom interface can be created and for displaying selected parameters. The bridge coupling is balanced with the help of a potentiometer. In the interface, the voltage change in the bridge can be observed when the beam is affected by deflection. After calibration of the system in the interface, strain and deflection can be presented according to calculations in LabVIEW. To obtain as stable and noise-free a signal as possible, the group has used both a low-pass hardware filter and a LabVIEW software filter. The signal is amplified by an OP amplifier before being fed into the DAQ card. Despite their age, the beam models could still be used and give stable signals for further treatment. The models can be used to advantage in a laboratory for students and there is a ready basis for this. The laboratory should increase the understanding of how a signal from a sensor can be amplified, filtered and further processed in this case for basic strength calculations.