There are a number of key risk factors in shift schedule design, which must be considered when assessing and managing the risks of shift work. Note the assessment and actions on HazChat. Click the "Run" button in the lower left of Simcenter Testlab Neo. All rights reserved. Login or register to use them Postings made by forum users are personal opinions. endobj What kind of formula can I use to calculate how many days a person works and knows when that person reaches the 7th day and resets after the alloted time. Or is this from a bulletin? Calculation Procedure1) Input Applied Stress, 4) Determine Modifying Factors for High Cycle Fatigue Limit. Note the assessment and actions on HazChat. %FZBM}j\2ijRQ {f^x.6(.r:\yx eIr0MC;O{Y]w~]'Y(: Mean high cycle fatigue limit factor ('mean' represents a 50% survival limit). Essentially fatigue needs to be managed, like any other hazard. Fatigue Risk Management Chart Free Download this Fatigue Risk Management Chart Design in Excel, Google Sheets Format. Wilson, The calculators in the links below (ETB and Stacie Glass), High notch sensitivity for Brittle/Hard Materials q=1.0, Very perfect material is significantly damaged by addition of a notch, Low Notch sensitivity for Soft Ductile Materials. %PDF-1.7 assurance of compliance with relevant H&S regulations. Not one i have ever used, but sadly the HSE seem to be putting more and more of these out to private companies to mainatain who then charge. Follow these easy steps to disable AdBlock, Follow these easy steps to disable AdBlock Plus, Follow these easy steps to disable uBlock Origin, Follow these easy steps to disable uBlock. This is probably the most common fatigue tool in the rail industry, and based upon published scientific literature on fatigue, alertness, sleepiness, and occupational injuries. !! 6A)L7YA/j.2 jl$~KCK3n4lMAExT_g|8V&^/DZXvI"9a%v~s)()jgakKU)dbz{#7 :SLu41wcGs>O$6pjR0B$=hlzhT766iT=v|sW uIkOAKUcb1?giMvzKdbS9XTW_OfN+xGr9S K~%;: )R {! BW8:1tKkwi% 2oej-uSGQV4_[o7q;w+}"+k=++ S\&zP{b!~-} ~on 3g. Managing shift work - Health and safety guidance. The key considerations should be the principles contained in HSE's guidance. 3 Put the crack size back to initial crack size. Once you click calculate, you will be taken to your results, where you will be able to generate a PDF report and see a detailed breakdown of the calculation. 1 0 obj the software platform, on which it runs is an older version of Excel that can no longer be supported and maintained on the HSE website. <> i6ho-d}1d>x:^6;[>gAMdiL{gqa1G X$zyg/bF_"HK"SW=;'b@K$wv}h5c f?9\O d,khI%/M`uN*JXc`4-,vG#d2-N_:tg,Zr6jPt^yAy9|u1XZy%pg The user guide which outlines how to use the FRC can also be found below. Controls may include self and peer monitoring, task rotation, increased breaks, pacing work load. Shift Work Fatigue Calculator by BGW Sat Oct 04, 2008 7:04 am BGW Tip: Buried deep into the HSE website is this excellent tool for measuring the levels of fatigue across different shift patterns. The reasons for this are: FRI users who have access to the FRI in its current format can continue to use it provided you have the necessary expertise to use the tool and understand the outputs and limitations. Implement the policy and make arrangements to monitor and enforce it. healthier shift patterns. Your likelihood of fatigue Sleep history Sleep in the 24 hours before starting work Sleep in the previous 24 hours Total sleep in the last 48 hours = 14 hours Awoke today at Calculate Working Time Regulations, BERR website. endobj Load the Process called "TL_Goodman and Damage calculation.tbd" In the new menu, select the Material Excel XML sheet as shown in Figure 14. <>/Metadata 448 0 R/ViewerPreferences 449 0 R>> The FRI should not be used on its own to consider a roster or selection of rosters. Following feedback we are making the tool available, as well as how to documents, to aid with calculations. Downloads . 8 0 obj Determine the number of constant load cycles until the beam will suffer a fast fracture. HSE Research Report 446 (2006) (available on HSE 's website in the 'Research' pages). Iamtrying to find out whether there is a wider issue with its applicablity, usefulness etc.. For backgroundon a very basic level the current Rail standards and the upcoming new ones require work patterns/rostas to have been fed into the FRI calculatorand acheive below a certainlevel for day and another for night. There are a number of tools associated with the Management Standards process provided across this website which are free for you to use or share with your colleagues. Note the assessment on HazChat. Download PTA Fatigue Calculator App and enjoy it on your iPhone, iPad and iPod touch. See the reference section for details on the methodology and the equations used. There are many different shift work-schedules and each schedule has different features. These should be considered at a local level when reviewing the roster and, judgement made about the impact they might have. National Work Stress Network, UK. 7 0 obj Here is a sample of are schedule, work 4 days, off 7, work 4 nights, off 3, work 3 days, off 1, work 3 nights, off 3,then starts over on the 4 days. As I said I can still get hold of the FRI tool , direct download , links from the NR documents etc. Discuss with team/crew, decide on appropriate controls. x\TW$fe$jj"e* *bAwE!A^f9w@Cs_~3{)o\ DUjP>_~.1??>}o }+2LF&+}5r[K&xtkK*S\.:+d"i LQ)j=ZZ/ALg8{q%F @? Alternatively, since there appears to be a more pronounced size effect in reversed bending and/or torsion than in the reversed axial loading situation this suggests that the stress gradient at the surface is partially responsible for the size effect.Surface finish factor. 5) Calculate High Cycle Fatigue LimitFatigue limit at zero mean stress, Calculation ReferencePetersons Stress Concentration Factors Machinery's Handbook 18th ed. IOSH is not responsible for the content or accuracy of any of the information contained in forum postings. The tool does not take into account a number of factors that may impact how. Not sure where this leaves the new current and new Network rail standards which mandate it ? Problems with overtime and shift-swapping may indicate inadequate resource allocation and. Copyright 2023 Energex. Continue to monitor fatigue. Guidance is provided for general bolted joint design, computation of preload uncertainty and preload loss, and the calculation of the bolted joint factor of safety. This calculation has been checked against three published calculations. The calculator contains two separate indices, one which relates to fatigue ( Fatigue Index) and one that relates to risk (Risk Index). This Excel spreadsheet has been developed as a simple tool to Using the FRI tool in Excel You can access the FRI tool, created by HSE, on the Fatigue Reduction SharePoint site.You can save it so you can access it easily next time you need it. Fracture and Fatigue Calculator.xls. endobj /)$+3SYZ83dc>%sRs)\b-1"UQ`:p].5F4|>]H_fgXtd1jvU`$R ^1hef,DGpKUzz Good to go? Fatigue results in slower reactions, reduced ability to process information, memory lapses, absent-mindedness, decreased awareness, lack of attention, underestimation of risk, reduced coordination etc. Controls are unlikely to be sufficient. 4 ENTERING DATA The spreadsheet uses a number of macros to calculate the Fatigue and Risk Indices. dunno.. :). And I downloaded it in 2019. got it it was changed on 12 July 2019 the link to the excel sheet was on the main page prior to thatI would send a screenshot but I can'tused wayback machine to find the linkso don't know the why yetbut the only security update was the use of VBA macros in Excel so perhaps it is based on that? There are also a number of templates for you to use as a starting point. Additionally, limited guidance is provided for fatigue considerations. Hence, when the size increases, the endurance decreases. ^wD\G/9+P33 5pvh0Mmf>ECd@\+50\ |#vq|>7Xm|o^M0=?!KsXY~n$o4u}mXVT1\3#%A[Nb&Xu?Mp/Ri`TV6kk$UGGQx TUC Working Time Myths report, 27 April 2009. Number of cycles related to mean low cycle fatigue limit. Privacy policy. It is important not to underestimate the risks of fatigue. Make arrangements to convey worker home. behaviour (HSG48), The development of a fatigue / risk index for shiftworkers, Guidance for managing shiftwork and fatigue offshore, Effect of shift schedule on offshore shiftworkers' circadian rhythms and health. See the instructions within the documentation for more details on performing this analysis. This Standard provides the minimum mandatory requirements for working hours, work schedules, rest periods, fatigue assessment and other fatigue-related responsibilities of workers, supervisors and managers to support the effective management of fatigue risk. Determine the relationship between the fatigue limit and the tensile strength. I'm fairly new to Excel and I need help with a spreadsheet that I use for scheduling. Welcome Guest! They work in a wide variety of industries including the emergency services, healthcare, the utilities, transport, manufacturing (including oil, gas & chemical industries), entertainment and retail. Fatigue and Risk Index Calculator v2.3 Before using for the first time, users are recommended to read the user manual and the research report describing the tool development (especially section 2). HSE Fatigue Risk Index (FRI) Calculator Fatigue Risk Index (FRI) Fatigue Risk Index (FRI) been withdrawn the HSE website. It is also related to workload, in that workers are more easily fatigued if their work is machine-paced, complex or monotonous. ))OT%_pXv13UiuYf>;@;L}GB#Um=E/,070}9W[ u@I0W2 Y#ER(M}\Ht)Z;nw6m7:SXAQ ih{\~Wbm-;K,kjDPRdh{hjjnk-[Y:hUmmUs/{Mj]UQA/{B&7n4Y`>J.8vS75(7uEj^p}szjq%wG{:xp;rH7gbl[KDVCd?*PCgrmh$ZZ,^[^DhD `OKEC&{!S[5e6"a7+@ Fatigue Risk Index Calculator This calculator produces a risk score and a fatigue score which may support compliance with NR/L2/OHS/003. The Fatigue Risk Index (FRI) has been withdrawn from the HSE website. Never mind just make sure your XLC is engaged properly. Advise Supervisor if appropriate. Changes to working hours need to be risk assessed. I'm in the same position of needing to use the calculator as a rail requirement and fortunately having downloaded it. Mailing Address Campus Box 7906 NC State University Raleigh, NC 27695-7906 Send Us an Email 919.515.2052 Physical Address 915 Partners Way, Room 4201 Stress intensity factor. ACTU reasonable hours campaign, Australia. 4) Determine Size Factor, Ko 5) Determine Surface Finish Factor, Cs 6) Determine Allowable Unnotched Zero-Mean Alternating Stress Develop a policy that specifically addresses and sets limits on working hours, overtime and shift-swapping, and which guards against fatigue. % Network Rail 2008-2015. Does anyone know why the HSE Fatigue Risk index calculator links have been removed from the HSE web site? Be sure to edit the file with the desired material data if needed. 9 0 obj <> Why does modifying the Applied stresses in the first part modify our SN Curve ? Determine the fatigue strength of a material. The Bolted Joint Analysis calculator allows for stress analysis of a bolted joint, accounting for preload, applied axial load, and applied shear load. I do have a copy that is not the issue. Calc opens the file but the vast majority of formulai are missing and from within Calc it is unusable. Mechanical Engineers Data Book (J.Carvill) Machine Design-Theory & Practice A.D Deutschman, W.J Michels, C.E. The maximum working day not to exceed 9 hours 30 minutes, or between 8 and 9 . V For example, the incidence of accidents and injuries has been found to be higher on night shifts, after a succession of shifts, when shifts are long and when there are inadequate breaks. It's always been like that at least as far as I can remember. stream by Skype or Managing fatigue offers measurable benefits and return on investment, including: increased productivity. More than 3.5 million people are employed as shift workers in the UK. This sheer diversity of work and workplaces means that there is no single optimal shift system that suits everyone. The student will type numerical values for machine design parameters and Excel will perform the calculations. Changes to working hours need to be risk assessed. Controls may include increased supervision, task re-assignment, buddy check, arrange back-up, transport alternatives may be required. The design of the FRI requires improvement to promote better understanding of its outputs, its limitations and its role in a Fatigue Management System. Fatigue refers to the issues that arise from excessive working time or poorly designed shift patterns. Part 1 introduces the causes of fatigue and the FRMP concept. Tools and templates. <> ); e) whether sufficient rest is actually obtained on rest days; f) changes in workload on site and environmental conditions during the work. 2007-2023 MoreVision Ltd. All Rights Reserved. Consider whether high risk tasks should occur. An app to measure fatigue levels. However, note that employees may prefer certain shift patterns that are unhealthy and likely to cause fatigue. Poorly designed shift-working arrangements and long working hours that do not balance the demands of work with time for rest and recovery can result in fatigue, accidents, injuries and ill health. The IOSH forums are a free resource to both members and non-members. https://www.hse.gov.uk/research/rrhtm/rr446.htm, Welcome Guest! Cell formulae checked using XLC. 1 Use Excel Goal seek to change crack size until fracture ratio = 100%. During investigations evidence on possible fatigue should be sought. Fatigue results in slower reactions, reduced ability to process information, memory lapses, absent-mindedness, decreased awareness, lack of attention, underestimation of risk, reduced. Discuss controls with crew/team and with Supervisor. We have a great community of people providing Excel help here, but the hosting costs are enormous. The calculator will estimate how much of the burden can be avoided with programs implemented in the workplace. Education on individual, responsibility, health and wellbeing lifestyle choices on managing fatigue outside of. Determine the fatigue limit. The IOSH forums are a free resource to both members and non-members. HSE Fatigue Risk Index calculator RR46- No longer available? Employees should be consulted on working hours and shift patterns. For example, the proposed, time varying reversing loads on . Im at work and can out post an Image of my spreadsheet so I will have to do it when i'm at home. I got my copy of the calculator through the research report. Number of cycles related to mean high cycle fatigue limit, Allowable alternating stress - Soderberg (conservative), Allowable alternating stress - Goodman (steel, aluminium & titanium), Allowable alternating stress - Gerber (less conservative), Allowable alternating stress - Smith (cast iron & magnesium), Rough turned (peak to valley height 30m), Turned/rough ground (peak to valley height 12m), Fine turned (peak to valley height 6.5m), Fine ground (peak to valley height 2.5m), Lapped/rough polished (peak to valley height 1m), Mechanical Engineers Data Book (J.Carvill), Machine Design-Theory & Practice A.D Deutschman, W.J Michels, C.E. Purpose of calculation: Produce Wohler /S-N Plots and Goodman Diagram Plot. The legal duty is on employers to manage risks from fatigue, irrespective of any individual's willingness to work extra hours or preference for certain shift patterns for social reasons. The research report outlining the work carried out to revise and update the HSE Fatigue Index (FI) is available below. These are the workload, the work activity, shift timing and duration, direction of rotation and the number and length of breaks during and between shifts. FRI users who have access to the FRI in its current format can continue to use it, provided you have the necessary expertise to use the tool and understand the outputs and limitations. However, a planned and systematic approach to assessing and managing the risks of shift work can improve the health and safety of workers. Questions about the calculator? Here is a sample of the spreadsheet.. HSE has oversight for safety in the UK workplace and wanted a tool that could be used by UK industry to predict high fatigue levels for shift workers. The information and data contained on this page including but not limited to the fatigue calculator has been developed for Energex employee purposes only and should'nt be relied upon for any other purpose/s. Lighting, thermal comfort, noise and vibration, Extract from inspectors human factors toolkit Managing fatigue risks, Managing shift work: Health and Safety Guidance HSG 256, Reducing error and influencing I need a formula to calculate fatigue days after 7 days straight of working to show up in red. Stress tool went a while ago - then i attended a webnare a few weeks ago about the new online MAC tool which turned out to be a sales pitch! I don't see this on the HSE website - is there a link to it there? control fatigue risks. I hope it works. This is possibly related to the probability of a high stress interacting with a critical flaw within a certain volume, i.e., when the volume is large there is a higher probability of failure. You are using an out of date browser. Night workers are particularly at risk of fatigue because their day sleep is often lighter, shorter and more easily disturbed because of daytime noise and a natural reluctance to sleep during daylight. Below is a quick access list of those tools: This is beyond my skill set but I'm willing to learn. ) {cy1>'EbM\'u31C'U=xcRF ;sW( q 5ZjI'{X%fv!jTE)qteb-l)n-mzWXD5/ClfC'{m8|1 \zF4"j<0tSm~) : l;{u|7,s$oZws,d]D,lb:p"1h*RFzTdlez4+Q2hEB(+~4+Lo wZ5[jm/O|$+;v],Hs^lDH>D!YG obt{BJ7*"R8o"9wC/9gQ'o#t '.Xf=/}0uzHQC*>1 o+Mh,8C\*.ask`Fo:J1|~aN x:HH% ~Itrk;>x n))KX-plrk+g~C,92)1/q-,8Fvam. You can get the tool itself (an Excel Spreadsheet), and the User Guide free here RSSB information on fatigue and shiftwork Sadly sounds like its going to become another pay to use tool to me - like the Stress Management and the Recent online MAC tools. The Fatigue Risk Index (FRI) For a better experience, please enable JavaScript in your browser before proceeding. The Excel spreadsheet is available for downloading on HSE's website. Compliance with the Working Time Regulations alone is insufficient to manage the risks of fatigue. endobj Surface Finish. The fatigue calculator is designed to help keep our staff safe. Material with a lot of flaws not damaged much by one more. This includes a limitation of drivers hours by negotiation of the following: An average 32hr, 4 day week over the yearly roster cycle for all our members with special cognisance of shift patterns and fatigue. Right to information - SN curve is a g. Submitted By: toyota@st162. HSE Fatigue Risk Index calculator RR46- No longer available? staff buy-in to managing fatigue on- and offline. -, YAF.NET 2003-2023, Yet Another Forum.NET. > ~ M i T R { f u o " P C o m p O b j p i 2 1 + % n` ` $$ $ # Frame4094 ( g 0 4 Label339 , h D CommandButton3 v > $ % &. Fatigue has also been implicated in 20% of accidents on major roads and is said to cost the UK 115 - 240 million per year in terms of work accidents alone. Download: Fatigue and Machine Design Excel Spreadsheet Calculator. HSE Fatigue and Index Calculator. Email us. Submitted On: 24 Apr 2023. Short Description: Submitted By: JohnDoyle[Admin] Submitted On: 24 Mar 2011. Sleep disturbances can lead to a 'sleep debt' and fatigue. HSE fatigue calculator, UK and guidance document . HSE Fatigue and Risk Index (FRI) Calculator The Fatigue Risk Index (FRI) The Fatigue Risk Index (FRI) has been withdrawn from the HSE website. <> This method loads the specimens by reversed bending. The reasons for this are: The software platform is an older Excel that can no longer be supported on the HSE website. endobj It recommends a more comprehensive approach to managing fatigue in a risk-based and systematic manner, and for fostering shared responsibility between an organisation and its employees. Easily Editable, Printable, Downloadable. HSE aims to reduce work-related death, injury and ill health. While the two indices are similar in many respects they diverge in others. No warranty or representation is made as to its accuracy or completeness. Continuing with any work requires GM approval. Login or register to use them. endobj Stop Work (or do not commence). xU[O@~opdO~EQud*UP,{AhYW!3.i?7^~u{i.:yH`8f(I=88lc1d@{RSIG?w`G8J8CmsG+ T g) domestic and/or personal circumstances or situations; h) whether individuals are actually turning up well-rested and fit for duty. reasons this are: software platform an older Excel can longer supported the HSE website.. The publication is divided into two parts. The 2010 AAD updated the ASLEF Health and Safety Charter. :Tw|aaDA~8A:qtDOGf01i4z/UJj 9{~h[Ph@u^Q^}wz8CXrpL&G~'pd(H5CH1c]0*eP2C0&F4R$NnvaVsWWI It is often a root cause of major accidents eg Herald of Free Enterprise, Chernobyl, Texas City, Clapham Junction, Challenger and Exxon Valdez.. Size Factor - The endurance limits of specimens have been observed to vary with their size. You can help keep this site running by allowing ads on MrExcel.com. Preview: Fatigue and Machine Design Excel Spreadsheet Calculator (Very Partial) Source: Norton, Machine Design, p. 378. Are fatigue schedule says we can work 7 straight day without being an exception. by mobile. Download this Template Google Sheets Excel Attribution required Know more Get access to all Documents, Designs & Templates Easily Customizable Instant Downloads The Fatigue Risk Index has been withdrawn from the HSE website. 2 This is the critical size for fast fracture, and make a note of the number. Determine the fatigue strength of a material. Use Excel curve fit functions for SN curve, Calculate allowable alternating stress for known number of cycles, Calculate allowable number of cycles for known alternating stress. Hi, The British Health and Safety Executive (HSE) have produced a fatigue calculator for shift workers which was produce in MS Excel. I didn't find it by an obvious link. Terms of use - What kind of formula can I use to calculate how many days a person works and knows when that person reaches the 7th day and resets after the allotted time and looks into the future to see if that person works he wont go into Exception on his regular shift.. All Rights Reserved, Infrastructure Safety Leadership Group (ISLG), Prevention through Engineering and Design, Management of Occupational Road Risk (MORR), Construction, Design and Management (CDM), Occupational Health and Wellbeing Strategy, Drugs and Alcohol standard (Network Rail colleagues only), Drugs and Alcohol standard (supplier page), Designing for Low Whole-Life Carbon (WS13), Weather Resilience and Climate Change Adaptation, Weather Attributed Schedule 8 and Schedule 4 Data, HSE Fatigue and Risk Index (FRI) Calculator. Determine the relationship between the fatigue limit and the tensile strength. I need a formula to calculate fatigue days after 7 days straight of working to show up in red. Downloads: 11. appropriate a particular roster is, and these include: a) quality and length of sleep between shifts; b) whether rest breaks are taken as detailed within the tools default settings; c) personal preference (are people morning/evening/night people? Metal Fatigue Excel Calculations, is a 5 Professional Development Hour (PDH) online course having a series of input fatigue data and solved output equations in an Excel format. Please carefully consider any advice you receive. Fatigue and Risk Index Calculator - Nottinghamshire Police Authority Fatigue results slower reactions, reduced ability process information, memory lapses, absent-mindedness, decreased . JavaScript is disabled. <>/ExtGState<>/XObject<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/MediaBox[ 0 0 595.32 841.92] /Contents 4 0 R/Group<>/Tabs/S/StructParents 0>> FRI fitted the requirement and was made available to UK industry hosted within a a simple spreadsheet with consequentially limited usability and functionality. It is generally considered to be a decline in mental and/or physical performance that results from prolonged exertion, sleep loss and/or disruption of the internal clock. TUC working time webpages. To assess an individual or group using actual worked data, such as submitted timesheets, to establish fatigue risk when changing a roster or authorising overtime. The National Safety Council has teamed with Brigham and Women's Hospital to develop an easy-to-use online tool, where employers can receive a tailored estimate of how much fatigue is costing their bottom line. Both SN curve and Goodman diagram are commonly used approaches to study fatigue in engineering and material science. This may include developing a robust system of recording working hours, overtime, shift-swapping and on-call working. by Skype or the design of the FRI requires improvement to promote better understanding of its outputs, its limitations, and its role in a Fatigue Risk Management System. Axial loads, shear loads, thermal loads, and thread tear out are used in factor of safety calculations. 3 0 obj In its current format, there have been case of the FRI being issued in order to justify work patterns that clearly require further action t reduce fatigue-relate risk. The development of a fatigue/risk index for shiftworkers, HSE report RR446, HSE, UK. > ~ M i T R { f u o " P C o m p O b j p i 2 1 + % n` ` $$ $ # Frame4094 ( g 0 4 Label339 , h D CommandButton3 v > $ % &. Other features of the workplace environment such as the physical environment, management issues and employee welfare can also contribute to the risks associated with shift work. 2 0 obj https://roymech.org/Useful_Tables/Fatigue/Fatigue_index.html, http://materials.open.ac.uk/mem/mem_mf.htm, Click here for information on subscriptions, Produce Wohler /S-N Plots and Goodman Diagram Plot. stream Fatigue needs to be managed, like any other hazard. I need help. Having downloaded the spreadsheet, save and use this version as a template for future assessments. The main differences are due to the different If the calulator is no longer available I wonder where this leaves this requirement. endobj Find out your likelihood of being fatigued in three easy steps. You must log in or register to reply here. Both are available from HSE's website at: http://www.hse.gov.uk/research/rrhtm/rr446.htm Charts Summary Schedule Constants Company Location Date Day Stop Work. optimised alertness and decision making. LM MMH Data Collection Sheet_Metric(pdf), NIOSH LE Calculator English Units(Excel), Revised Strain Index Calculator English Units(Excel), 915 Partners Way, Campus Box 7906, Raleigh, NC 27695, Ergonomics Culture and Program Development, Industrial Ergonomics Process Workshop (IEPW), Office Ergonomics Accreditation Program (OEAP), Advanced Topics in Office Ergonomics (ATOE), Ergonomics Training for Managers and Supervisors, Deep Dive Ergonomics Analysis Tool Matrix (Excel), Revised Strain Index Calculator English Units, We have a full-service office in Colorado Springs, CO, We offer specialized training for engineers, We can help you build a world-class ergonomics program, We have a full-service office in Charlotte, NC. Postings made by forum users are personal opinions. IOSH is not responsible for the content or accuracy of any of the information contained in forum postings. Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result, Here is a sample of the spreadsheet each cell is a dropdown list of peoples names that can work that job post. There are days and nights, the seven day fatigue resets for those working days after 36 hours off, for those working nights it resets after 48 hours. by mobile, EU +44 113 8152220