Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3118030%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3118030%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20a%20formula%20that%20will%20pull%20out%20a%20figure%20dependent%20on%20the%20month%20selected.%20Eg%20if%20Dec%20selected%20then%20i%20need%20the%20sum%20of%20the%20column%20for%20dec.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3118030%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3118276%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3118276%22%20slang%3D%22en-US%22%3Elets%20assume%20you%20have%20a%20table%20with%20row%201%20having%20titles%20%22Jan%22%2C%20%22Feb%22%2C...%2C%22Dec%22%20and%20numbers%20below%20it.%3CBR%20%2F%3EAnd%20you%20have%20a%20cell%2C%20let's%20pretend%20it%20is%20AA1%20where%20you%20enter%20the%20month%20(ideally%20using%20Data%20Validation%20of%20the%20list%20of%20those%20Column%20headings).%20And%20you%20want%20the%20total%20in%20cell%20AA2%3CBR%20%2F%3EThere%20are%20a%20number%20of%20ways%20but%20here%20are%202%3A%3CBR%20%2F%3Ea)%20assuming%20the%20data%20is%20Formatted%20as%20a%20Table%20called%20%22Table1%22%20(the%20default%20name%20given)%20then%3CBR%20%2F%3E%3D%20SUM(INDEX(Table1%5B%23Data%5D%2C%20%2CMATCH(AA1%2CTable1%5B%23Headers%5D)))%3CBR%20%2F%3Eb)%20assuming%20columns%20%22Jan%22%20...%20%22Dec%22%20are%20columns%20B%3AM%20then%20something%20like%3CBR%20%2F%3E%3D%20SUM(INDEX(%24B%3A%24M%2C%20%2C%20MATCH(%24AA%241%2C%24B%241%3A%24M%241%2C0)))%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3125753%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3125753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20still%20struggling%20to%20get%20it%20to%20work%2C%20not%20sure%20if%20it%20is%20because%20I%20have%20it%20over%20two%20tabs.%20One%20has%20all%20the%20info%20laid%20out%2C%20the%202nd%20(where%20I%20want%20to%20put%20the%20formula)%20will%20be%20a%20journal%20which%20I%20want%20to%20automatically%20update%20figures%20when%20I%20change%20the%20month.%20Not%20sure%20how%20I%20can%20attach%20to%20show%20what%20I%20mean%20but%20hopefully%20this%20will%20help.%3C%2FP%3E%3CTABLE%20width%3D%221527%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%221446%22%3EPrepayments%20Schedule%202021-2022.%20Nominal%20Code%20Q103%3C%2FTD%3E%3CTD%20width%3D%2281%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECompany%3C%2FTD%3E%3CTD%3EDescription%3C%2FTD%3E%3CTD%3ENominal%3C%2FTD%3E%3CTD%3EDec%3C%2FTD%3E%3CTD%3EJan%3C%2FTD%3E%3CTD%3EFeb%3C%2FTD%3E%3CTD%3EMar%3C%2FTD%3E%3CTD%3EApr%3C%2FTD%3E%3CTD%3EMay%3C%2FTD%3E%3CTD%3EJun%3C%2FTD%3E%3CTD%3EJul%3C%2FTD%3E%3CTD%3EAug%3C%2FTD%3E%3CTD%3ESep%3C%2FTD%3E%3CTD%3EOct%3C%2FTD%3E%3CTD%3ENov%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3EExcess%20Professional%20Indemnity%20Insurance%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20285.37%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20285.37%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20257.75%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20285.37%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20276.16%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20285.37%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20276.16%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20285.37%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20285.37%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20276.16%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20285.37%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20276.16%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%203%2C360.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3EPI%20-%20Primary%20Policy%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20423.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20423.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20382.33%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20423.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20409.64%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20423.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20409.64%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20423.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20423.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20409.64%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20423.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20409.64%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%204%2C984.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3ECyber%20Package%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20135.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20135.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20122.74%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20135.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20131.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20135.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20131.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20135.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20135.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20131.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20135.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20131.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%2C600.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3EManagement%20Liability%20Package%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20137.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20137.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20124.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20137.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20133.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20137.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20133.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20137.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20137.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20133.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20137.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20133.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%2C619.41%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3ECombined%20Liability%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C453.93%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C453.93%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C119.68%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C453.93%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C342.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C453.93%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C342.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C453.93%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C453.93%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C342.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C453.93%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%203%2C342.51%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%2040%2C667.20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3ECombined%20Liability%20Year%20End%20Adj%2020-21%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20748.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20748.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20675.82%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20748.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20724.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20748.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20724.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20748.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20748.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20724.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20748.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20724.10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%208%2C809.85%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3EProperty%20Owners%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20881.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20881.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20795.92%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20881.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20852.77%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20881.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20852.77%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20881.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20881.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20852.77%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20881.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20852.77%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%2010%2C375.40%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3ECommercial%20Combined%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20755.08%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20755.08%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20682.01%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20755.08%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20730.72%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20755.08%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20730.72%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20755.08%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20755.08%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20730.72%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20755.08%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20730.72%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%208%2C890.43%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3EContract%20Works%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20802.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20802.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20724.56%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20802.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20776.31%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20802.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20776.31%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20802.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20802.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20776.31%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20802.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20776.31%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%209%2C445.16%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ESub%20Total%3C%2FTD%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C622.73%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C622.73%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%206%2C885.04%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C622.73%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C376.83%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C622.73%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C376.83%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C622.73%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C622.73%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C376.83%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C622.73%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%207%2C376.83%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESpecialist%20Risk%20Solutions.%20(CL1166)%3C%2FTD%3E%3CTD%3EVehicle%20Insurance%3C%2FTD%3E%3CTD%3EE104%20ENV%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C299.94%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%2016%2C945.60%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ESub%20Total%3C%2FTD%3E%3CTD%3EE104%20ENV%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C299.94%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C439.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C392.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest%20Valley%20Council%20(TE109)%3C%2FTD%3E%3CTD%3ERates%3C%2FTD%3E%3CTD%3EK135%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20861.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%2010%2C332.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest%20Valley%20Council%20(TE109)%3C%2FTD%3E%3CTD%3ERates%3C%2FTD%3E%3CTD%3EK135%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20624.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%207%2C488.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ESub%20Total%3C%2FTD%3E%3CTD%3EK135%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%201%2C485.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAchilles%20Information%20Ltd%3C%2FTD%3E%3CTD%3EAccreditation%3C%2FTD%3E%3CTD%3EK101%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20181.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20181.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20163.55%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20181.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20175.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20181.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20175.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20181.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20181.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20175.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20181.07%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20175.23%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%202%2C132.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECHAS%3C%2FTD%3E%3CTD%3EAccreditation%3C%2FTD%3E%3CTD%3EK101%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EISOQAR%3C%2FTD%3E%3CTD%3EAccreditation%3C%2FTD%3E%3CTD%3EK101%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20444.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20444.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20401.14%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20444.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20429.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20444.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20429.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20444.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20444.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20429.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20444.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20429.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%205%2C229.17%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EK101%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20625.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20625.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20564.69%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20625.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20605.03%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20625.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20605.03%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20625.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20625.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20605.03%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20625.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20605.03%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHSE%20(Due%2027th%20Nov%202023)%3C%2FTD%3E%3CTD%3ELicensing%3C%2FTD%3E%3CTD%3EK149%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2086.05%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%2C121.67%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EK149%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2086.05%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2095.26%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2092.19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EConstruction%20Line%3C%2FTD%3E%3CTD%3ETrade%20Association%3C%2FTD%3E%3CTD%3EK139%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20146.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20146.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20131.87%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20146.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20141.29%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20146.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20141.29%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20146.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20146.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20141.29%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20146.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20141.29%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%2C719.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EARCA%3C%2FTD%3E%3CTD%3ETrade%20Association%3C%2FTD%3E%3CTD%3EK139%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2093.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2093.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2084.38%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2093.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2090.41%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2093.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2090.41%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2093.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2093.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2090.41%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2093.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2090.41%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%2C100.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EK139%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20239.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20239.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20216.25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20239.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20231.70%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20239.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20231.70%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20239.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20239.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20231.70%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20239.42%3C%2FTD%3E%3CTD%3E%26nbsp%3B%C2%A3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20231.70%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22202%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22138%22%3EJournal%20Posting%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EDec%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EK118%20OVH%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20help%20gratefully%20received%20as%20this%20is%20driving%20me%20mad%20now%2C%20because%20I%20know%20it%20should%20be%20easy%20but%20I%20am%20a%20bit%20rusty%2C%20not%20having%20had%20to%20do%20stuff%20like%20this%20for%20a%20while%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETracie.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need to create a formula that will pull out a figure dependent on the month selected. Eg if Dec selected then i need the sum of the column for dec.

3 Replies
lets assume you have a table with row 1 having titles "Jan", "Feb",...,"Dec" and numbers below it.
And you have a cell, let's pretend it is AA1 where you enter the month (ideally using Data Validation of the list of those Column headings). And you want the total in cell AA2
There are a number of ways but here are 2:
a) assuming the data is Formatted as a Table called "Table1" (the default name given) then
= SUM(INDEX(Table1[#Data], ,MATCH(AA1,Table1[#Headers])))
b) assuming columns "Jan" ... "Dec" are columns B:M then something like
= SUM(INDEX($B:$M, , MATCH($AA$1,$B$1:$M$1,0)))

@mtarler 

I am still struggling to get it to work, not sure if it is because I have it over two tabs. One has all the info laid out, the 2nd (where I want to put the formula) will be a journal which I want to automatically update figures when I change the month. Not sure how I can attach to show what I mean but hopefully this will help.

Prepayments Schedule 2021-2022. Nominal Code Q103 
                
CompanyDescriptionNominalDecJanFebMarAprMayJunJulAugSepOctNovTOTAL
Specialist Risk Solutions. (CL1166)Excess Professional Indemnity InsuranceK118 OVH £     285.37 £     285.37 £     257.75 £     285.37 £     276.16 £     285.37 £     276.16 £     285.37 £     285.37 £     276.16 £     285.37 £     276.16 £    3,360.00
Specialist Risk Solutions. (CL1166)PI - Primary PolicyK118 OVH £     423.30 £     423.30 £     382.33 £     423.30 £     409.64 £     423.30 £     409.64 £     423.30 £     423.30 £     409.64 £     423.30 £     409.64 £    4,984.00
Specialist Risk Solutions. (CL1166)Cyber PackageK118 OVH £     135.89 £     135.89 £     122.74 £     135.89 £     131.51 £     135.89 £     131.51 £     135.89 £     135.89 £     131.51 £     135.89 £     131.51 £    1,600.00
Specialist Risk Solutions. (CL1166)Management Liability PackageK118 OVH £     137.54 £     137.54 £     124.23 £     137.54 £     133.10 £     137.54 £     133.10 £     137.54 £     137.54 £     133.10 £     137.54 £     133.10 £    1,619.41
Specialist Risk Solutions. (CL1166)Combined LiabilityK118 OVH £  3,453.93 £  3,453.93 £  3,119.68 £  3,453.93 £  3,342.51 £  3,453.93 £  3,342.51 £  3,453.93 £  3,453.93 £  3,342.51 £  3,453.93 £  3,342.51 £  40,667.20
Specialist Risk Solutions. (CL1166)Combined Liability Year End Adj 20-21K118 OVH £     748.23 £     748.23 £     675.82 £     748.23 £     724.10 £     748.23 £     724.10 £     748.23 £     748.23 £     724.10 £     748.23 £     724.10 £    8,809.85
Specialist Risk Solutions. (CL1166)Property OwnersK118 OVH £     881.20 £     881.20 £     795.92 £     881.20 £     852.77 £     881.20 £     852.77 £     881.20 £     881.20 £     852.77 £     881.20 £     852.77 £  10,375.40
Specialist Risk Solutions. (CL1166)Commercial CombinedK118 OVH £     755.08 £     755.08 £     682.01 £     755.08 £     730.72 £     755.08 £     730.72 £     755.08 £     755.08 £     730.72 £     755.08 £     730.72 £    8,890.43
Specialist Risk Solutions. (CL1166)Contract WorksK118 OVH £     802.19 £     802.19 £     724.56 £     802.19 £     776.31 £     802.19 £     776.31 £     802.19 £     802.19 £     776.31 £     802.19 £     776.31 £    9,445.16
                
 Sub TotalK118 OVH £  7,622.73 £  7,622.73 £  6,885.04 £  7,622.73 £  7,376.83 £  7,622.73 £  7,376.83 £  7,622.73 £  7,622.73 £  7,376.83 £  7,622.73 £  7,376.83 
                
Specialist Risk Solutions. (CL1166)Vehicle InsuranceE104 ENV £  1,439.22 £  1,439.22 £  1,299.94 £  1,439.22 £  1,392.79 £  1,439.22 £  1,392.79 £  1,439.22 £  1,439.22 £  1,392.79 £  1,439.22 £  1,392.79 £  16,945.60
                
 Sub TotalE104 ENV £  1,439.22 £  1,439.22 £  1,299.94 £  1,439.22 £  1,392.79 £  1,439.22 £  1,392.79 £  1,439.22 £  1,439.22 £  1,392.79 £  1,439.22 £  1,392.79 
                
Test Valley Council (TE109)RatesK135 OVH £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £     861.00 £  10,332.00
Test Valley Council (TE109)RatesK135 OVH £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £     624.00 £    7,488.00
                
 Sub TotalK135 OVH £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 £  1,485.00 
                
Achilles Information LtdAccreditationK101 OVH £     181.07 £     181.07 £     163.55 £     181.07 £     175.23 £     181.07 £     175.23 £     181.07 £     181.07 £     175.23 £     181.07 £     175.23 £    2,132.00
CHASAccreditationK101 OVH             £                 -  
ISOQARAccreditationK101 OVH £     444.12 £     444.12 £     401.14 £     444.12 £     429.79 £     444.12 £     429.79 £     444.12 £     444.12 £     429.79 £     444.12 £     429.79 £    5,229.17
                
  K101 OVH £     625.20 £     625.20 £     564.69 £     625.20 £     605.03 £     625.20 £     605.03 £     625.20 £     625.20 £     605.03 £     625.20 £     605.03 
                
HSE (Due 27th Nov 2023)LicensingK149 OVH £        95.26 £        95.26 £        86.05 £        95.26 £        92.19 £        95.26 £        92.19 £        95.26 £        95.26 £        92.19 £        95.26 £        92.19 £    1,121.67
                
                
  K149 OVH £        95.26 £        95.26 £        86.05 £        95.26 £        92.19 £        95.26 £        92.19 £        95.26 £        95.26 £        92.19 £        95.26 £        92.19 
                
Construction LineTrade AssociationK139 OVH £     146.00 £     146.00 £     131.87 £     146.00 £     141.29 £     146.00 £     141.29 £     146.00 £     146.00 £     141.29 £     146.00 £     141.29 £    1,719.00
ARCATrade AssociationK139 OVH £        93.42 £        93.42 £        84.38 £        93.42 £        90.41 £        93.42 £        90.41 £        93.42 £        93.42 £        90.41 £        93.42 £        90.41 £    1,100.00
                
  K139 OVH £     239.42 £     239.42 £     216.25 £     239.42 £     231.70 £     239.42 £     231.70 £     239.42 £     239.42 £     231.70 £     239.42 £     231.70 
                

 

Journal PostingDec
   
K118 OVH 

 

All help gratefully received as this is driving me mad now, because I know it should be easy but I am a bit rusty, not having had to do stuff like this for a while now.

 

Thanks in advance

 

Tracie.

 

 

@Tracie_Barker1270 i attached a sheet with some examples