应用Excel进行沥青混合料配合比设计的优化计算

Vol117No15200010JOURNALOFHIGHWAYANDTRANSPORTATIONRESEARCHANDDEVELOPMENT:1002O0268(2000)05O0013-02:2000O01O23:(1971-),,,,1Excel,,(,510420):Excel,,:;;;:U41612:AOptimizedCalculationofBitumenMixDesignbyExcelYANGHuiOguang,YEYanOhu,TENGXueOfeng(GuangdongProvincialCommunicationsScienceResearchInstitute,GuangdongGuangzhou510420,China)Abstract:ThispaperpresentsoptimizedcalculationofbitumenmixdesignbyuseofplanningsloutionfunctionofExceltogettheopti2malquantitiesofeachoftheaggregates;andtherequirementsandcompositegradationcurvecanbeplottedbyuseofthegraphguidefunction1Keywords:Mixproportion;Optimization;Planningsolution;Graphguide,,,,Excel,,,ExcelMicrosoftOffice,WindowsExcel,Ex2cel,,,,,,11,,01075mm2136mm4175mm,,111MicrosoftExcel,MicrosoftExcel,1(ABC,123,Excel,),(,)©1994-2007ChinaAcademicJournalElectronicPublishingHouse.Allrightsreserved.=C4B4+C5B5+C6B6+C7B7(C11,=,=)D11=D4B4+D5B5+D6B6+D7B7E11=E4B4+E5B5+E6B6+E7B7L11=L4B4+L5L5+E6L6+L7B7,Excel,,C11,B4B5B6B7S|,C11,+,L11,112,,Excel,,1,::S|CS|11(,100):S|BS|4S|BS|7:,,S|BS|4S|BS|7=01S|DS|11=S|DS|10S|DS|11=S|DS|8S|ES|11=S|ES|10S|ES|11=S|ES|8S|LS|11=S|LS|10S|LS|11=S|LS|8(),,,,,,01075mm2136mm4175mm,S|FS|11=S|FS|9(20)2000514©1994-2007ChinaAcademicJournalElectronicPublishingHouse.Allrightsreserved.(1)(2),,,(3),(14)S|GS|11=S|GS|9S|LS|11=S|LS|9,,1,,,,,113Excel,,,,Ctrl,,,,22Excel,2,,,,,,,,,,,,,Excel,2000520©1994-2007ChinaAcademicJournalElectronicPublishingHouse.Allrightsreserved.