COLOGUARD ORDER REQUISITION FORM EXACT SCIENCES LABORATORIES LLC 145 E. Badger Rd Ste 100 Madison WI 53713 P 844. 870. 8879 www. exactlabs. com Fax completed form to 844. 870. 8875 REQUIRED Provider Information PROVIDER INFORMATION Healthcare Organization Location Address Provider Name City State Zip NPI Phone Number or DEA if NPI is not available Fax Number To receive results for this order please provide a secure FAX number PATIENT INFORMATION Patient ID/MRN First Name Last Name DOB...
cologuard order form

Get the free cologuard order form

Fill form: Try Risk Free
  • Get Form
  • eSign
  • Fax
  • Email
  • Add Annotation
  • Share
Video instructions and help with filling out and completing cologuard order form

Hey guys so question was asks how do you make an order form or for your customers or for you to order inventory that's going to tell you when you've gone over your price so we're going to make a template that you can use I'm just going to use a whole bunch of generic stuff you can modify it but it's going to teach you the basics and then you can go from there you can make this as complex or as simple as you want as you see very basic set up already I always find it helpful that when I'm trying to make a template use some fake numbers then then I can delete them save it with it empty and then every time I have like a new project or I want to use that template I'll make a copy of it rename it that way you don't have to make this setup every single time generic numbers I'm going to put in a whole bunch of stuff that way it's easier to see the format here we're going to put in our limit we're going to say it's $40 our tax rate is going to be 6% and some of these things I've already formatted to be dollar just hit the dollar sign for this one I just hit the % and had it show two decimal places depending on where you live we're also going to all of these make them into dollars these we don't really care these can just stay up at the top you see that they're just general it's perfectly fine then we also want this comp to equal your boxes times cost per box and then we want it to do that all the way through for subtotal we want it to equal the sum all of these boxes and hit enter the tax rate we want it to equal the subtotal times the tax rate and last but not least the grand total is going to equal some at least two and see that last one to start an equation you can either use plus or equals it works the same I want to format something so it looks a little bit better we'll make all these things in the center same with those all right but it's still not warning us obviously we're over our costs so we need to use some if-then statements to make it warn us and make everything work so in this total I'm going to do equals if that's what I want so so that wants the logic test so I'm going to say if this cell is less than I sixteen Plus all right so what I've pretty much done is said if if our limit is less than the subtotal plus the tax then I want it to just have the so total tax and display that if what I wanted to do I wanted to display over limit by will see that didn't frickin work so get a reverse our sign all right so we're over our limit and this will tell us we can even put in something to tell them by how much so this can just equal if this cell equals over limit Hey I want you to do 16 + 17 J - otherwise zero it's formatted as a dollar so here what it's saying is if the other cell equals over limit by it's going to do the calculation for us it's going to add subtotal and tax and then subtract our limit to tell us how much we're over by and so then the person could go in maybe they zero out a couple of things until they are good to order there we...