cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-71564%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E9%85%8D%E6%96%B9%E5%AF%A6%E9%A9%97%E8%A8%AD%E8%A8%88%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71564%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E5%BF%85%E9%A0%88%E7%82%BA%202%20%E5%80%8B%E9%80%A3%E7%BA%8C%E5%9B%A0%E5%AD%90%E5%92%8C%201%20%E5%80%8B%E5%AE%9A%E6%80%A7%E5%9B%A0%E5%AD%90%E5%AE%9A%E7%BE%A9%20DOE%EF%BC%8C%E4%B8%A6%E5%9C%A8%E4%B8%8D%E5%90%8C%E6%BF%83%E5%BA%A6%E4%B8%8B%E6%B8%AC%E8%A9%A6%202%20%E5%80%8B%E6%B0%B4%E5%B9%B3%EF%BC%88A%20%E5%92%8C%20B%EF%BC%89%E3%80%82%E6%88%91%E7%9A%84%E9%99%90%E5%88%B6%E5%A6%82%E4%B8%8B%EF%BC%9A%3C%2FP%3E%3CP%3E-%20%E5%A6%82%E6%9E%9C%20A%20%E6%BF%83%E5%BA%A6%20%26gt%3B0%EF%BC%8C%E5%89%87%20B%3D0%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20%E5%A6%82%E6%9E%9C%20B%20%E6%BF%83%E5%BA%A6%20%26gt%3B0%EF%BC%8C%E5%89%87%20A%3D0%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E7%9B%AE%E7%9A%84%E6%98%AF%E5%84%AA%E5%8C%96%E9%85%8D%E6%96%B9%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E6%88%91%E5%98%97%E8%A9%A6%E9%80%B2%E8%A1%8C%E8%87%AA%E8%A8%82%E8%A8%AD%E8%A8%88%EF%BC%8C%E4%BD%86%E6%89%BE%E4%B8%8D%E5%88%B0%E5%AE%9A%E7%BE%A9%E7%B4%84%E6%9D%9F%E7%9A%84%E6%96%B9%E6%B3%95%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E6%9C%80%E4%BD%B3%E5%80%BC%E6%87%89%E9%81%B8%E6%93%87%E5%AE%9A%E6%80%A7%E5%9B%A0%E5%AD%90%EF%BC%88A%20%E6%88%96%20B%EF%BC%89%E7%9A%84%E6%9C%80%E4%BD%B3%E6%B0%B4%E5%B9%B3%E4%BB%A5%E5%8F%8A%20-1%20%E5%88%B0%201%20%E7%AF%84%E5%9C%8D%E5%85%A7%E7%9A%84%E6%BF%83%E5%BA%A6%E6%B0%B4%E5%B9%B3%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E6%88%91%E5%B0%87%E6%84%9F%E8%AC%9D%E6%82%A8%E5%B0%8D%E9%80%99%E5%80%8B%E4%B8%BB%E9%A1%8C%E7%9A%84%E5%B9%AB%E5%8A%A9%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E6%8F%90%E5%89%8D%E8%87%B4%E8%AC%9D%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71742%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9ADOE%20%E9%85%8D%E6%96%B9%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71742%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E5%A6%82%E6%9E%9C%E7%AF%84%E5%9C%8D%E9%9D%9E%E5%B8%B8%E4%B8%8D%E5%90%8C%EF%BC%8C%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E7%9A%84%E5%8F%A6%E4%B8%80%E7%A8%AE%E6%96%B9%E6%B3%95%E6%98%AF%E4%BD%BF%E7%94%A8%E5%BE%9E%20-1%20%E5%88%B0%201%20%E7%9A%84%E7%B7%A8%E7%A2%BC%E7%AF%84%E5%9C%8D%E3%80%82%E7%95%B6%E6%82%A8%E9%81%87%E5%88%B0%20(A%2C-1)%20%E8%99%95%E7%9A%84%E8%99%95%E7%90%86%E6%99%82%EF%BC%8C%E9%80%99%E8%A1%A8%E7%A4%BA%E6%82%A8%E5%9C%A8%2010%20%E8%99%95%E5%9F%B7%E8%A1%8C%20A%E3%80%82%E5%A6%82%E6%9E%9C%E6%98%AF(B%2C-1)%EF%BC%8C%E6%82%A8%E4%BB%A5800%20%E9%81%8B%E8%A1%8CB%E3%80%82%E6%82%A8%E9%9C%80%E8%A6%81%E8%A8%98%E4%BD%8F%E5%B0%87%E7%B5%90%E6%9E%9C%E8%BD%89%E6%8F%9B%E5%9B%9E%E9%81%A9%E7%95%B6%E7%9A%84%E6%AF%94%E4%BE%8B%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71741%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9ADOE%20%E9%85%8D%E6%96%B9%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71741%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E6%84%9F%E8%AC%9D%E6%82%A8%E6%8F%90%E4%BE%9B%E6%AD%A4%E9%99%84%E5%8A%A0%E8%B3%87%E8%A8%8A%E3%80%82%E6%89%80%E4%BB%A5%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%88%91%E5%BE%88%E5%A5%BD%E7%90%86%E8%A7%A3%E7%9A%84%E8%A9%B1%EF%BC%8C%E7%95%B6%E5%B0%84%E7%A8%8B%E7%A2%BA%E5%AF%A6%E4%B8%8D%E5%90%8C%E6%99%82%EF%BC%8C%E4%B8%A6%E4%B8%8D%E7%9C%9F%E6%AD%A3%E5%BB%BA%E8%AD%B0%E4%BD%BF%E7%94%A8%E9%80%99%E5%80%8B%E6%AF%8D%E9%B9%BF%E5%B0%96%E7%AB%AF%E3%80%82%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71610%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9ADOE%20%E9%85%8D%E6%96%B9%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71610%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E5%AE%9A%E5%88%B6%E8%A8%AD%E8%A8%88%E5%B0%8D%E6%88%91%E4%BE%86%E8%AA%AA%E6%B2%92%E6%9C%89%E6%94%B6%E6%96%82%EF%BC%8C%E6%89%80%E4%BB%A5%E6%88%91%E7%84%A1%E6%B3%95%E6%AA%A2%E6%9F%A5%E6%9C%80%E7%B5%82%E7%9A%84%E8%A8%AD%E8%A8%88%E3%80%82%E6%88%91%E7%9B%B8%E4%BF%A1%E4%BD%A0%E5%B0%8D%20A%20%E5%92%8C%20B%20%E6%B0%B4%E5%B9%B3%E4%B8%8D%E5%B9%B3%E8%A1%A1%E7%9A%84%E8%A7%80%E5%AF%9F%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%88%91%E5%88%AA%E9%99%A4%E4%BA%86%E7%B4%84%E6%9D%9F%E4%B8%A6%E9%80%B2%E8%A1%8C%E4%BA%86%E8%A8%AD%E8%A8%88%EF%BC%8C%E5%95%9F%E7%94%A8%E4%BA%86%E6%A8%A1%E6%93%AC%E9%9F%BF%E6%87%89%EF%BC%8C%E8%A3%BD%E4%BD%9C%E4%BA%86%E6%95%B8%E6%93%9A%E8%A1%A8%EF%BC%8C%E6%89%8B%E5%8B%95%E5%B0%87A%20%E7%9A%84505%20%E6%9B%B4%E6%94%B9%E7%82%BA12.5%EF%BC%8C%E5%B0%871000%20%E6%9B%B4%E6%94%B9%E7%82%BA15%EF%BC%8C%E5%B0%87B%20%E7%9A%8410%20%E6%9B%B4%E6%94%B9%E7%82%BA800%EF%BC%8C%E5%B0%87505%20%E6%9B%B4%E6%94%B9%E7%82%BA900%EF%BC%8C%E7%84%B6%E5%BE%8C%E6%A8%A1%E6%93%AC%E9%9F%BF%E6%87%89%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%88%91%E6%87%B7%E7%96%91%E7%94%B1%E6%96%BC%E5%AD%98%E5%9C%A8%E5%A5%87%E9%BB%9E%EF%BC%8C%E9%80%99%E4%BA%9B%E6%95%B8%E6%93%9A%E5%AF%A6%E9%9A%9B%E4%B8%8A%E4%B8%A6%E4%B8%8D%E6%94%AF%E6%8C%81%E4%BC%B0%E8%A8%88%E6%A8%A1%E5%9E%8B%E5%8F%83%E6%95%B8%E3%80%82%E4%BA%8B%E5%AF%A6%E8%AD%89%E6%98%8E%EF%BC%8C%E6%83%85%E6%B3%81%E4%B8%A6%E6%B2%92%E6%9C%89%E9%82%A3%E9%BA%BC%E7%B3%9F%E7%B3%95%EF%BC%8C%E5%8F%AA%E6%98%AF%E9%9D%9E%E5%B8%B8%E7%B3%9F%E7%B3%95%E3%80%82%20A%20%E5%92%8C%20B%20%E7%9A%84%E6%89%80%E9%9C%80%E6%BF%83%E5%BA%A6%E6%B0%B4%E6%BA%96%E5%9C%A8%20X3%E3%80%81%E6%BF%83%E5%BA%A6%E4%BB%A5%E5%8F%8A%E8%88%87%20X3%20%E7%9A%84%E4%BB%BB%E4%BD%95%E4%BA%A4%E4%BA%92%E4%BD%9C%E7%94%A8%E7%9A%84%E4%BC%B0%E8%A8%88%E5%80%BC%E4%B9%8B%E9%96%93%E7%94%A2%E7%94%9F%E9%9D%9E%E5%B8%B8%E5%BC%B7%E7%9A%84%E7%9B%B8%E9%97%9C%E6%80%A7%E3%80%82%E9%80%99%E7%A8%AE%E7%9B%B8%E9%97%9C%E6%80%A7%E5%8F%8D%E9%81%8E%E4%BE%86%E5%8F%88%E5%B0%8E%E8%87%B4%E4%BC%B0%E8%A8%88%E4%B8%8D%E7%A9%A9%E5%AE%9A%E3%80%82%E6%88%91%E5%9C%A8%E6%A8%A1%E6%93%AC%E9%9F%BF%E6%87%89%E4%B8%AD%E5%8A%A0%E5%85%A5%E4%BA%86%20Conc%20%E7%9A%84%E5%BC%B7%E7%83%88%E9%9D%9E%E7%B7%9A%E6%80%A7%E6%95%88%E6%87%89%E5%92%8C%E8%BC%83%E5%A4%A7%E7%9A%84%20X3*Conc%20%E4%BA%A4%E4%BA%92%E4%BD%9C%E7%94%A8%EF%BC%8C%E4%BD%86%E6%A0%B9%E6%9C%AC%E6%B2%92%E6%9C%89%E6%AA%A2%E6%B8%AC%E5%88%B0%E5%AE%83%E5%80%91%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%88%91%E9%99%84%E4%B8%8A%E9%80%99%E5%80%8B%E6%95%B8%E6%93%9A%E8%A1%A8%E4%BE%9B%E6%82%A8%E6%AA%A2%E6%9F%A5%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71602%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9ADOE%20%E9%85%8D%E6%96%B9%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71602%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E9%9D%9E%E5%B8%B8%E6%84%9F%E8%AC%9D%E6%82%A8%E7%9A%84%E5%9B%9E%E5%A4%8D%EF%BC%8C%E9%80%99%E6%98%AF%E8%A7%A3%E6%B1%BA%E6%88%91%E7%9A%84%E5%95%8F%E9%A1%8C%E7%9A%84%E4%B8%80%E5%80%8B%E6%9C%89%E8%B6%A3%E7%9A%84%E6%96%B9%E6%B3%95%EF%BC%88%E6%88%91%E6%9C%89%E9%BB%9E%E7%B5%95%E6%9C%9B%EF%BC%89%E3%80%82%E5%8F%AA%E6%98%AF%E4%B8%80%E5%89%87%E8%A9%95%E8%AB%96%EF%BC%8C%E4%B9%9F%E8%A8%B1%E6%98%AF%E6%82%A8%E7%9A%84%E4%B8%80%E6%A2%9D%E5%BB%BA%E8%AD%B0%EF%BC%8C%E7%95%B6%20A%20%E6%BF%83%E5%BA%A6%E7%AF%84%E5%9C%8D%20(10-15)%20%E8%88%87%20B%20%E6%BF%83%E5%BA%A6%E7%AF%84%E5%9C%8D%20(800-1000)%20%E7%A2%BA%E5%AF%A6%E4%B8%8D%E5%90%8C%E6%99%82%EF%BC%8C%E6%82%A8%E5%A6%82%E4%BD%95%E8%99%95%E7%90%86%E3%80%82%20A%20%E5%92%8C%20B%20%E4%B9%8B%E9%96%93%E7%9A%84%E9%81%8B%E8%A1%8C%E6%AC%A1%E6%95%B8%E7%A2%BA%E5%AF%A6%E4%B8%8D%E5%B9%B3%E8%A1%A1%EF%BC%88A%20%E9%81%8B%E8%A1%8C%203%20%E6%AC%A1%EF%BC%8CB%20%E9%81%8B%E8%A1%8C%2017%20%E6%AC%A1%EF%BC%89%E3%80%82%E6%88%91%E8%A6%BA%E5%BE%97%E5%BE%88%E5%A5%87%E6%80%AA%E3%80%82%E4%B8%8B%E9%9D%A2%E6%98%AF%E7%A8%8B%E5%BC%8F%E7%A2%BC%E7%AF%84%E4%BE%8B%E3%80%82%3CBR%20%2F%3E%E4%BD%A0%E6%80%8E%E9%BA%BC%E8%AA%8D%E7%82%BA%EF%BC%9F%3CBR%20%2F%3E%E5%86%8D%E6%AC%A1%E6%84%9F%E8%AC%9D%E6%82%A8%E7%9A%84%E5%8F%8A%E6%99%82%E5%9B%9E%E8%A6%86%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%E7%BE%8E%E5%9C%8B%E8%83%BD%E6%BA%90%E9%83%A8%EF%BC%88%3CBR%20%2F%3E%E5%AE%A2%E8%A3%BD%E5%8C%96%E8%A8%AD%E8%A8%88%EF%BC%8C%3CBR%20%2F%3E%20%7B%E6%96%B0%E5%A2%9E%E5%9B%9E%E6%87%89(%E6%9C%80%E5%A4%A7%E5%8C%96%2C%20%22Y%22%2C%20.%2C%20.%2C%20.%20)%2C%3CBR%20%2F%3E%E6%B7%BB%E5%8A%A0%E5%9B%A0%E5%AD%90(%E9%80%A3%E7%BA%8C%2C%20-1%2C%201%2C%20%22X1%22%2C%200%20)%2C%3CBR%20%2F%3E%E6%B7%BB%E5%8A%A0%E5%9B%A0%E5%AD%90(%E9%80%A3%E7%BA%8C%2C%20-1%2C%201%2C%20%22X2%22%2C%200%20)%2C%3CBR%20%2F%3E%E6%B7%BB%E5%8A%A0%E5%9B%A0%E5%AD%90(%20%E5%88%86%E9%A1%9E%2C%20%7B%22A%22%2C%20%22B%22%7D%2C%20%22X3%22%2C%200%20)%2C%3CBR%20%2F%3E%E5%8A%A0%E5%9B%A0%E5%AD%90(%20Continuous%2C%2010%2C%201000%2C%20%22Conc%22%2C%200%20)%2C%20%E8%A8%AD%E5%AE%9A%E9%9A%A8%E6%A9%9F%E7%A8%AE%E5%AD%90(%202111591509%20)%2C%3CBR%20%2F%3E%E9%96%8B%E5%A7%8B%E6%AC%A1%E6%95%B8(%201453%20)%EF%BC%8C%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B1%2C%200%7D%20)%EF%BC%8C%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B1%2C%201%7D%20)%EF%BC%8C%3CBR%20%2F%3E%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B2%2C%201%7D%20)%E3%80%81%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B3%2C%201%7D%20)%E3%80%81%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B4%2C%201%7D%20)%E3%80%81%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B1%2C%202%7D%20)%E3%80%81%3CBR%20%2F%3E%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B1%2C%201%7D%2C%20%7B2%2C%201%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B2%2C%202%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B1%2C%201%7D%2C%20%7B3%2C%201%7D%20)%2C%3CBR%20%2F%3E%E5%8A%A0%E9%A0%85(%20%7B2%2C%201%7D%2C%20%7B3%2C%201%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B1%2C%201%7D%2C%20%7B4%2C%201%7D%20)%2C%3CBR%20%2F%3E%E5%8A%A0%E5%85%A5%E8%A1%93%E8%AA%9E(%20%7B2%2C%201%7D%2C%20%7B4%2C%201%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B3%2C%201%7D%2C%20%7B4%2C%201%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E8%A1%93%E8%AA%9E(%20%7B4%2C%202%7D%20)%2C%3CBR%20%2F%3E%E6%96%B0%E5%A2%9E%E5%88%A5%E5%90%8D%E9%A0%85(%20%7B1%2C%201%7D%2C%20%7B2%2C%201%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E5%88%A5%E5%90%8D%E9%A0%85(%20%7B1%2C%201%7D%2C%20%7B3%2C%201%7D%20)%2C%3CBR%20%2F%3E%E6%96%B0%E5%A2%9E%E5%88%A5%E5%90%8D%E9%A0%85(%20%7B1%2C%201%7D%2C%20%7B4%2C%201%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E5%88%A5%E5%90%8D%E9%A0%85(%20%7B2%2C%201%7D%2C%20%7B3%2C%201%7D%20)%2C%3CBR%20%2F%3E%E6%96%B0%E5%A2%9E%E5%88%A5%E5%90%8D%E9%A0%85(%20%7B2%2C%201%7D%2C%20%7B4%2C%201%7D%20)%2C%20%E6%96%B0%E5%A2%9E%E5%88%A5%E5%90%8D%E9%A0%85(%20%7B3%2C%201%7D%2C%20%7B4%2C%201%7D%20)%2C%3CBR%20%2F%3E%E8%A8%AD%E5%AE%9A%E6%A8%A3%E6%9C%AC%E5%A4%A7%E5%B0%8F(%2020%20)%EF%BC%8C%E4%B8%8D%E5%85%81%E8%A8%B1%E7%9A%84%E7%B5%84%E5%90%88(%3CBR%20%2F%3E%20X3%20%3D%3D%201%20%26amp%3B%20%E6%BF%83%20%26gt%3B%2015%20%7C%20X3%20%3D%3D%202%20%26amp%3B%20%E6%BF%83%E5%BA%A6%20%26lt%3B%20800%3CBR%20%2F%3E%20)%E3%80%81%E6%9C%80%E5%84%AA%E6%BA%96%E5%89%87(%202%20)%E3%80%81%E9%80%B2%E8%A1%8C%E8%A8%AD%E8%A8%88%E3%80%81%E8%A8%AD%E5%AE%9A%E9%81%8B%E4%BD%9C%E9%A0%86%E5%BA%8F(%E9%9A%A8%E6%A9%9F%E5%8C%96)%E3%80%81%3CBR%20%2F%3E%E8%A3%BD%E4%BD%9C%E8%A1%A8%E6%A0%BC%7D%3CBR%20%2F%3E%20%EF%BC%89%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71589%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9ADOE%20%E9%85%8D%E6%96%B9%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71589%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E8%AB%8B%E5%8F%83%E9%96%B1%E6%AD%A4%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FConstraint-set-up-in-an-optimal-design%2Fm-p%2F71323%23M35395%22%20target%3D%22_self%22%3E%E8%A8%8E%E8%AB%96%3C%2FA%3E%E3%80%82%E5%B0%87%E6%BF%83%E5%BA%A6%E5%AE%9A%E7%BE%A9%E7%82%BA%E8%B7%A8%E8%B6%8A%20A%20%E5%92%8C%20B%20%E7%9A%84%E8%BC%83%E5%AF%AC%E7%AF%84%E5%9C%8D%E3%80%82%E8%A8%AD%E5%AE%9A%E4%B8%80%E5%80%8B%E7%B4%84%E6%9D%9F%EF%BC%8C%E4%BB%A5%E4%BE%BF%E7%95%B6%E5%9B%A0%E5%AD%90%E8%A8%AD%E5%AE%9A%E7%82%BA%20A%20%E6%99%82%EF%BC%8C%E6%8E%92%E9%99%A4%E6%BF%83%E5%BA%A6%E7%AF%84%E5%9C%8D%E7%9A%84%E4%B8%80%E9%83%A8%E5%88%86%E3%80%82%E5%B0%8D%E8%A8%AD%E5%AE%9A%E7%82%BA%20B%20%E7%9A%84%E5%9B%A0%E5%AD%90%E5%9F%B7%E8%A1%8C%E7%9B%B8%E5%90%8C%E6%93%8D%E4%BD%9C%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%88%91%E8%AA%8D%E7%82%BA%E5%AE%83%E6%87%89%E8%A9%B2%E5%9B%9E%E7%AD%94%E6%82%A8%E7%9A%84%E5%95%8F%E9%A1%8C%EF%BC%8C%E4%BD%86%E5%A6%82%E6%9E%9C%E6%82%A8%E4%BB%8D%E7%84%B6%E9%9C%80%E8%A6%81%E5%B9%AB%E5%8A%A9%EF%BC%8C%E8%AB%8B%E5%91%8A%E8%A8%B4%E6%88%91%E5%80%91%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71588%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9ADOE%20%E9%85%8D%E6%96%B9%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71588%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E5%BF%98%E4%BA%86%E8%A3%9C%E5%85%85%E4%B8%80%E9%BB%9E%EF%BC%8C%E5%85%A9%E7%A8%AE%E6%88%90%E5%88%86%E7%9A%84%E6%BF%83%E5%BA%A6%E7%AF%84%E5%9C%8D%E6%98%AF%E4%B8%8D%E5%90%8C%E7%9A%84%E3%80%82%3C%2FP%3E%3CP%3E%E4%BA%8B%E5%AF%A6%E4%B8%8A%E6%88%91%E7%9A%84%E9%99%90%E5%88%B6%E5%A6%82%E4%B8%8B%EF%BC%9A%3C%2FP%3E%3CP%3E%E5%A6%82%E6%9E%9C%20CA%26gt%3B0%20%E5%89%87%20CB%3D0%3C%2FP%3E%3CP%3E%E6%88%96%E5%A6%82%E6%9E%9C%20CB%26gt%3B0%20%E5%89%87%20CA%3D0%3C%2FP%3E%3CP%3E%E5%85%B6%E4%B8%AD%20CA%EF%BC%88%E5%88%86%E5%88%A5%20CB%EF%BC%89%E6%98%AF%20A%EF%BC%88%E5%88%86%E5%88%A5%E7%82%BA%20B%EF%BC%89%E6%88%90%E5%88%86%E7%9A%84%E6%BF%83%E5%BA%A6%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E7%95%B6%E6%88%91%E5%98%97%E8%A9%A6%E5%AF%A6%E7%8F%BE%E6%AD%A4%E7%B4%84%E6%9D%9F%E6%99%82%EF%BC%8C%E6%88%91%E6%94%B6%E5%88%B0%E4%BB%A5%E4%B8%8B%E8%A8%8A%E6%81%AF%EF%BC%9A%3C%2FP%3E%3CP%3E%E2%80%9C%E6%A8%A1%E5%9E%8B%E5%A4%A7%E7%B6%B1%E4%B8%AD%E9%81%B8%E5%AE%9A%E7%9A%84%E9%A0%85%E7%9B%AE%E8%88%87%E5%85%88%E5%89%8D%E7%9A%84%E9%A0%85%E7%9B%AE%E7%B7%9A%E6%80%A7%E7%9B%B8%E9%97%9C%E3%80%82%E8%AB%8B%E6%8C%89%E2%80%9C%E5%88%AA%E9%99%A4%E9%A0%85%E7%9B%AE%E2%80%9D%E6%8C%89%E9%88%95%EF%BC%8C%E7%84%B6%E5%BE%8C%E9%87%8D%E8%A9%A6%E3%80%82%E2%80%9D%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E6%88%91%E5%B8%8C%E6%9C%9B%E5%AE%83%E6%9C%89%E5%B9%AB%E5%8A%A9%E3%80%82%3C%2FP%3E%3CP%3E%E5%9C%A8%E6%AD%A4%E5%85%88%E6%84%9F%E8%AC%9D%E6%82%A8%E7%9A%84%E5%B9%AB%E5%BF%99%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71587%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9ADOE%20%E9%85%8D%E6%96%B9%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71587%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E9%9C%80%E8%A6%81%E7%B4%84%E6%9D%9F%E5%97%8E%EF%BC%9F%E4%BC%BC%E4%B9%8E%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%9C%89%E5%85%A9%E5%80%8B%E5%9B%A0%E7%B4%A0%EF%BC%9A%E6%88%90%E5%88%86%EF%BC%88A%20%E6%88%96%20B%EF%BC%89%E7%9A%84%E5%88%86%E9%A1%9E%E5%9B%A0%E7%B4%A0%E5%92%8C%E6%BF%83%E5%BA%A6%E7%9A%84%E9%80%A3%E7%BA%8C%E5%9B%A0%E7%B4%A0%E3%80%82%E9%80%99%E6%A8%A3%EF%BC%8CA%20%E5%92%8C%20B%20%E5%B0%B1%E4%B8%8D%E6%9C%83%E5%87%BA%E7%8F%BE%E5%9C%A8%E5%90%8C%E4%B8%80%E5%80%8B%E9%85%8D%E6%96%B9%E4%B8%AD%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
hytou31
Level I

Formulation DOE

I have to define DOE for  2 continuous factors and 1 qualitative factor with 2 levels (A and B)  tested at different concentrations. My constraints are the following:

- if the A concentration is >0 then B=0

- if the B concentration is >0 then A=0

The objective is to optimize the formulation.

I try to do a custom design but I didn't find the way to define my constraint.

The optimum should select the best level for the qualitative factor (A or B) and the concentration level between the range -1 to 1.

I will appreciate your help for this topic.

Thanks in advance. 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Formulation DOE

One additional approach that could be used if the ranges are very different is to use a coded range from -1 to 1. When you encounter a treatment at (A,-1), it will mean you run A at 10. If it is (B,-1), you run B at 800. You would need to keep in mind the translation of the results back to the appropriate scales.

Dan Obermiller

View solution in original post

7 REPLIES 7

Re: Formulation DOE

Do you need a constraint? It seems that you could have two factors: a categorical factor for ingredient (A or B) and a continuous factor for concentration. This way, you would never have A and B in the same formulation.

hytou31
Level I

Re: Formulation DOE

I forgot to add that the concentration range is different between both ingredient.

In fact my constraint are the following:

if CA>0 then CB=0

or if CB>0 then CA=0

where CA (resp. CB)  is the concentration of the A (resp. B) ingredient.

 

When I try to implement this cosntraint, I have the following message:

"The selected terms in the Model outline are linearly dependent on the previous terms. Please press the Remove Term button and try again."

 

I hope it is helpful.

Thanks in advance for your help.

 

Re: Formulation DOE

Please see this discussion. Define concentration to have a wide range that spans both A and B. Set one constraint so that when factor set to A, then exclude one portion of the concentration range. Do the same for factor set to B.

 

I think that it should answer your question, but if you still need help, let us know.

hytou31
Level I

Re: Formulation DOE

Thanks a lot for your response, it is an interesting approach to solve my issue (I was a little bit desperate). Just a comment and maybe a piece of advice from you, how do you manage when A concentration range (10-15) is really different than the B concentration range (800-1000). The number of runs between A and B are really unbalanced (3 runs with A and 17 with B). It seems to me strange. Here below an example of code.
What do you think?
Thanks again for your prompt response.

DOE(
Custom Design,
{Add Response( Maximize, "Y", ., ., . ),
Add Factor( Continuous, -1, 1, "X1", 0 ),
Add Factor( Continuous, -1, 1, "X2", 0 ),
Add Factor( Categorical, {"A", "B"}, "X3", 0 ),
Add Factor( Continuous, 10, 1000, "Conc", 0 ), Set Random Seed( 2111591509 ),
Number of Starts( 1453 ), Add Term( {1, 0} ), Add Term( {1, 1} ),
Add Term( {2, 1} ), Add Term( {3, 1} ), Add Term( {4, 1} ), Add Term( {1, 2} ),
Add Term( {1, 1}, {2, 1} ), Add Term( {2, 2} ), Add Term( {1, 1}, {3, 1} ),
Add Term( {2, 1}, {3, 1} ), Add Term( {1, 1}, {4, 1} ),
Add Term( {2, 1}, {4, 1} ), Add Term( {3, 1}, {4, 1} ), Add Term( {4, 2} ),
Add Alias Term( {1, 1}, {2, 1} ), Add Alias Term( {1, 1}, {3, 1} ),
Add Alias Term( {1, 1}, {4, 1} ), Add Alias Term( {2, 1}, {3, 1} ),
Add Alias Term( {2, 1}, {4, 1} ), Add Alias Term( {3, 1}, {4, 1} ),
Set Sample Size( 20 ), Disallowed Combinations(
X3 == 1 & Conc > 15 | X3 == 2 & Conc < 800
), Optimality Criterion( 2 ), Make Design, Set Run Order( Randomize ),
Make Table}
)

Re: Formulation DOE

Custom Design did not converge for me, so I cannot inspect the resulting design. I believe your observation about the imbalance of the A and B levels.

 

I removed the constraint and made the design, enabled Simulate Responses, made the data table, manually changed 505 to 12.5 and 1000 to 15 for A and changed 10 to 800 and 505 to 900 for B, and then simulated the response.

 

I suspected that this data would not actually support estimating the model parameters due to a singularity. It turns out that the situation isn't that bad, it is just really bad. The desired concentration levels for A and B produce very strong correlations among the estimates for X3, Conc, and any interaction with X3. This correlation in turn leads to unstable estimates. I included strong non-linear effect of Conc and a large X3*Conc interaction in the simulated response but they were not detected at all.

 

I attached this data table for you to inspect.

hytou31
Level I

Re: Formulation DOE

Thanks for this additional information. So, if I well understood, it is not really recommanded to use this doe tip when range are really different.

Re: Formulation DOE

One additional approach that could be used if the ranges are very different is to use a coded range from -1 to 1. When you encounter a treatment at (A,-1), it will mean you run A at 10. If it is (B,-1), you run B at 800. You would need to keep in mind the translation of the results back to the appropriate scales.

Dan Obermiller

Recommended Articles