ASTM_D_4177_adjunct.xlsx

API MPMS 8.2/ASTM D4177-Sampling Frequency and SamplingSystem Monitoring SpreadsheetAPI MPMS 8.2/ASTM D4177-Sampling Frequency and Sampling System Monitoring SpreadsheetSampler Set-up Evaluation(See API MPMS Ch 15 for unit conversions)Input VariablesSVmax10galSample container volume(maximum fill,see API MPMS 8.3)Allowance20%Percent below SVmax to allow for changesSVmax8galSample container volume(maximum fill,see API MPMS 8.3)with safety factorSVmin2.0galThe greater of:1)The lowest volume which passed operator acceptance testing for sample container mixing system,if a LV was tested.(see API MPMS 8.3)or,2)The minimum sample volume required for testing,retains,and error margin when choosing the LV test point for SVmin(see API MPMS 8.3)b1.5mlExtractor grab volume as determined by prior testing(see section 11)Max Sample CycleFrequency15.0grabs/minMaximum Grab Frequency(Equipment limitations)4s/grabMax Flow Rate4,000Bbls/hrExpected maximum flowrate during the batchPVe75,000BblsExpected batch parcel volumeRounding of B1decimalsDecimals available on entry to controllerSummaryB4.5Bbl/grabIntragrab Volume(Rounded up)SVe6.7galSample volume expected in container25,313mlMargin of Error0.010Margin of error(best=0.010)Section 14.3.1Equation(1a)SVmax8galSample container volume(maximum fill,see API MPMS 8.3)with safety factorb1.5mlExtractor grab volume as determined by prior testing(see section 11)Nmax20,189grabsGrabs to get SVmaxSection 14.3.1Equation(1b)SVmin2galThe greater of:1)The lowest volume which passed operator acceptance testing for sample container mixing system,if a LV was tested.(see API MPMS 8.3)or,2)The minimum sample volume required for testing,retains,and error margin when choosing the LV test point for SVmin(see API MPMS 8.3)b1.5mlExtractor grab volume as determined by prior testing(see section 11)Nmin5,047grabsGrabs to get SVminSection 14.3.1Equation(1c)PVe75,000BblExpected batch parcel volumeMax Flow Rate4,000Bbls/hrExpected maximum flowrate during the batchMax Sample CycleFrequency4s/grabMaximum Grab Frequency(Equipment limitations)Nlimit16,875grabsMaximum grabs possible at sampling system cycling limitationsSection 14.3.1Determine NeNmax20,189grabsGrabs to get SVmaxNmin5,047grabsGrabs to get SVminNlimit16,875grabsMaximum grabs possible at sampling system cycling limitationsNlimit NminPassTest that it is possible to get the minimum number of grabsIf Nlimit Nmax thenNe=Nmax else Ne=NlimitFalsegrabsTest to limit grabsNe16,875grabsGrabs to get SVe(limited by Nmax)Section 14.3.1Equation(2)Ne16,875grabsGrabs to get SVe(limited by Nmax)b1.5mlExtractor grab volume as determined by prior testing(see section 11)SVe25,313mlSample volume expected in containerSVe6.7galSample volume expected in containerSection 14.3.1Equation(3)PVe75,000BblExpected batch parcel volumeNe16,875grabsGrabs to get SVe(limited by Nmax)API MPMS 8.2/ASTM D4177-Sampling Frequency and Sampling System Monitoring SpreadsheetBatch Performance Factor Evaluation(See API MPMS Ch 15 for unit conversions)Input Variablesb1.5mlExtractor grab volume as determined by prior testing(see section 11)PVco75,000BblsTotal batch parcel volume,as measured by the custody transfer system,at observed temperature and pressure.The total includes products,water andsediment.(GV for meters and TOV for tanks)SV6.7galSample volume collected in the primary container at observed conditionsSVmin2galThe greater of:1)The lowest volume which passed operator acceptance testing for sample container mixing system,if a LV was tested.(see API MPMS 8.3)or,2)The minimum sample volume required for testing,retains,and error margin when choosing the LV test point for SVmin(see API MPMS 8.3)B4.5Bbl/grabIntragrab VolumeSummaryMVPassMinimum volume ratioPFPassPerformance Factor(overall)Section 18.7.5Equation(7)SV6.7galSample volume collected in the primary container at observed conditionsSVmin2galThe greater of:1)The lowest volume which passed operator acceptance testing for sample container mixing system,if a LV was tested.(see API MPMS 8.3)or,2)The minimum sample volume required for testing,retains,and error margin when choosing the LV test point for SVmin(see API MPMS 8.3)MV3.35Minimum volume ratioTest MVPassSection 18.7.6Equation(8)SV6.7galSample volume collected in the primary container at observed conditions25,362mlB4.5Bbl/grabIntragrab Volume(Rounded up)PV75,000BblsTotal batch parcel volume,as measured by the custody transfer system,corrected to standard temperature and pressure.The total includes products,water and sediment.(GSV for meters and TCV for tanks)b1.5mlExtractor grab volume as determined by prior testing(see section 11)PF1.01Performance Factor(overall)Test PFPassBetween 0.9 and 1.1API MPMS 8.2/ASTM D4177-Sampling Frequency and Sampling System Monitoring SpreadsheetSecondary Performance Factor Evaluation(See API MPMS Ch 15 for unit conversions)Input Variablesb1.5mlExtractor grab volume as determined by prior testing(see section 11)N16,870GrabsTotal number of grabs recorded b