Welcome: Guest | Register | Login |

"); $q = explode("&",$_SERVER["QUERY_STRING"]); foreach ($q as $qi) { if ($qi != "") { $qa = explode("=",$qi); list ($key, $val) = $qa; if ($val) { $$key = urldecode($val); //echo "
1: $$key=$val"; } } } reset ($_POST); while (list ($key, $val) = each ($_POST)) { if ($val) { $$key = $val; //echo "
2: $$key=$val"; } } //echo("
"); global $user; $uid = $user->uid; $timenow=time(); $current_year = date("Y"); $state=strtoupper($state); drupal_set_title(""); if($state == "") { $state = "MA"; } require_once("/ipool/htdocs/ChartDirector/lib/phpchartdir.php"); #################BAR CHART###################### $labels = array("83-87", "88-92", "93-97", "98-02", "03-07", "08-12", "13-17"); $SQLstatement = "SELECT * FROM sbir_state_office_info WHERE state='$state'"; $SQLstatement1 = "SELECT * FROM sbir_state_office_info WHERE state='US'"; $replace_pattern = array("$", ","); $result = mysql_query("$SQLstatement") or die("SELECT Error: ".mysql_error()); $row = mysql_fetch_array($result, MYSQL_ASSOC); $total_dollars_since_FY12 = $row[block_2013_2017]; $row[block_1983_1987] = str_replace($replace_pattern, "", $row[block_1983_1987]); $row[block_1988_1992] = str_replace($replace_pattern, "", $row[block_1988_1992]); $row[block_1993_1997] = str_replace($replace_pattern, "", $row[block_1993_1997]); $row[block_1998_2002] = str_replace($replace_pattern, "", $row[block_1998_2002]); $row[block_2003_2007] = str_replace($replace_pattern, "", $row[block_2003_2007]); $row[block_2008_2012] = str_replace($replace_pattern, "", $row[block_2008_2012]); $row[block_2013_2017] = str_replace($replace_pattern, "", $row[block_2013_2017]); $data1 = array(($row[block_1983_1987] / 1000000), ($row[block_1988_1992] / 1000000), ($row[block_1993_1997] / 1000000), ($row[block_1998_2002] / 1000000), ($row[block_2003_2007] / 1000000), ($row[block_2008_2012] / 1000000), ($row[block_2013_2017] / 1000000)); $result1 = mysql_query("$SQLstatement1") or die("SELECT Error1: ".mysql_error()); $row1 = mysql_fetch_array($result1, MYSQL_ASSOC); $row1[block_1983_1987] = str_replace($replace_pattern, "", $row1[block_1983_1987]); $row1[block_1988_1992] = str_replace($replace_pattern, "", $row1[block_1988_1992]); $row1[block_1993_1997] = str_replace($replace_pattern, "", $row1[block_1993_1997]); $row1[block_1998_2002] = str_replace($replace_pattern, "", $row1[block_1998_2002]); $row1[block_2003_2007] = str_replace($replace_pattern, "", $row1[block_2003_2007]); $row1[block_2008_2012] = str_replace($replace_pattern, "", $row1[block_2008_2012]); $row1[block_2013_2017] = str_replace($replace_pattern, "", $row1[block_2013_2017]); $data2 = array(($row1[block_1983_1987] / 1000000), ($row1[block_1988_1992] / 1000000), ($row1[block_1993_1997] / 1000000), ($row1[block_1998_2002] / 1000000), ($row1[block_2003_2007] / 1000000), ($row1[block_2008_2012] / 1000000), ($row1[block_2013_2017] / 1000000)); ################BAR CHART###################### #The data for the chart $result_DOD = mysql_query("SELECT * FROM sbir_awards WHERE firms_state='$state' AND department='DOD'") or die("SELECT Error_DOD: ".mysql_error()); $num_rows_DOD = mysql_num_rows($result_DOD); $result_NIH = mysql_query("SELECT * FROM sbir_awards WHERE firms_state='$state' AND agency='NIH'") or die("SELECT Error_NIH: ".mysql_error()); $num_rows_NIH = mysql_num_rows($result_NIH); $result_NASA = mysql_query("SELECT * FROM sbir_awards WHERE firms_state='$state' AND agency='NASA'") or die("SELECT Error_NASA: ".mysql_error()); $num_rows_NASA = mysql_num_rows($result_NASA); $result_DOE = mysql_query("SELECT * FROM sbir_awards WHERE firms_state='$state' AND agency='DOE'") or die("SELECT Error_DOE: ".mysql_error()); $num_rows_DOE = mysql_num_rows($result_DOE); $result_NSF = mysql_query("SELECT * FROM sbir_awards WHERE firms_state='$state' AND agency='NSF'") or die("SELECT Error_NSF: ".mysql_error()); $num_rows_NSF = mysql_num_rows($result_NSF); $result_Smaller = mysql_query("SELECT * FROM sbir_awards WHERE firms_state='$state' AND department!='DOD' AND agency!='NIH' AND agency!='NASA' AND agency!='DOE' AND agency!='NSF'") or die("SELECT Error_Smaller: ".mysql_error()); $num_rows_Smaller = mysql_num_rows($result_Smaller); $bdata = array($num_rows_DOD, $num_rows_NIH, $num_rows_NASA, $num_rows_DOE, $num_rows_NSF, $num_rows_Smaller); # The labels for the bar chart $labels = array("DOD", "NIH", "NASA", "DOE", "NSF", "Smaller"); # Create a XYChart object of size 600 x 380 pixels. Set background color to brushed # silver, with a 2 pixel 3D border. Use rounded corners of 20 pixels radius. $b = new XYChart(320, 180, brushedSilverColor(), Transparent, 2); # Set the plotarea at (70, 55) and of size 460 x 280 pixels. Use transparent border # and black grid lines. Use rounded frame with radius of 20 pixels. $b->setPlotArea(50, 50, 250, 100, -1, -1, Transparent, 0x000000); $b->setRoundedFrame(0xffffff, 10); #Add a title box to the chart using 8 pts Arial Bold Italic font (arialbi.ttf). The title is #in CDML and includes embedded images for highlight. The text is white #(0xffffff) on a dark grey (0x505c65) background, with a 1 pixel 3D border. $btitleObj = $b->addTitle( "Awards distribution by funding source\nover the life of program", "arial.ttf", 12, 0xffffff); $btitleObj->setBackground(0x0B3335, 0x000000, glassEffect()); # Add a single-color bar chart layer using the supplied data. Set cylinder bar shape. $barLayerObj = $b->addBarLayer($bdata,0x505c65); $barLayerObj->setBarShape(CircleShape); # Set the labels on the x axis. $b->xAxis->setLabels($labels); # Set the left y-axis and right y-axis title using 10pt Arial Bold font $b->yAxis->setTitle("Number of awards", "arial.ttf", 8); # Set y-axes to transparent $b->yAxis->setColors(Transparent); # Disable ticks on the x-axis by setting the tick color to transparent $b->xAxis->setTickColor(Transparent); # Set the label styles of all axes to 8pt Arial Bold font $b->xAxis->setLabelStyle("arial.ttf", 8); $b->yAxis->setLabelStyle("arial.ttf", 8); #Create the image and save it in a temporary location $state_bar_chart1URL = $b->makeChart("tmp/state_bar_chart_$uid.user_$timenow.PNG"); #################################### $result_states = mysql_query("SELECT * FROM sbir_state_names LEFT JOIN sbir_state_email_web ON sbir_state_names.state=sbir_state_email_web.state WHERE sbir_state_names.state='$state'") or die("SELECT sbir_state_names: ".mysql_error()); $num_rows_states = mysql_num_rows($result_states); $row_state = mysql_fetch_array($result_states, MYSQL_ASSOC); $state_email=""; $state_web=""; $state_name=$row_state[fullname]; $result_total_awards = mysql_query("SELECT * FROM sbir_awards") or die("SELECT Error_total_awards: ".mysql_error()); $num_rows_total_awards = mysql_num_rows($result_total_awards); $result_p1_awards = mysql_query("SELECT * FROM sbir_awards WHERE firms_state='$state'") or die("SELECT Error_p1_awards: ".mysql_error()); $num_rows_p1_awards = mysql_num_rows($result_p1_awards); $result_p2_awards = mysql_query("SELECT * FROM sbir_awards WHERE phase=2 AND firms_state='$state'") or die("SELECT Error_p1_awards: ".mysql_error()); $num_rows_p2_awards = mysql_num_rows($result_p2_awards); $result_total_comps = mysql_query("SELECT * FROM sbir_companies") or die("SELECT Error_total_comps: ".mysql_error()); $num_rows_total_comps = mysql_num_rows($result_total_comps); $result_comps = mysql_query("SELECT * FROM sbir_companies WHERE state='$state'") or die("SELECT Error_comps: ".mysql_error()); $num_rows_comps = mysql_num_rows($result_comps); $p1_awards_percent = (int)(($num_rows_p1_awards/$num_rows_total_awards) * 100); $p2_awards_percent = (int)(($num_rows_p2_awards/$num_rows_total_awards) * 100); $comps_percent = (int)(($num_rows_comps/$num_rows_total_comps) * 100); if($p1_awards_percent == 0) { $p1_awards_percent = 1; } if($p2_awards_percent == 0) { $p2_awards_percent = 1; } if($comps_percent == 0) { $comps_percent = 1; } $num_rows_p1_awards = number_format($num_rows_p1_awards); $num_rows_p2_awards = number_format($num_rows_p2_awards); $num_rows_comps = number_format($num_rows_comps); $current_year = date("Y", $timenow); $result_recent_awards = mysql_query("SELECT * FROM sbir_awards WHERE (firms_state='$state') AND (p1_year >= $current_year-2 OR p2_year = $current_year-2) ORDER BY p2_year DESC, RAND() LIMIT 3") or die("SELECT Error_recent_awards: ".mysql_error()); $num_rows_recent_awards = mysql_num_rows($result_recent_awards); $compare_timestamp = date("Y-m-d", ($timenow - 31557600)); //echo("compare_timestamp=$compare_timestamp
"); $result_featured_firm = mysql_query("SELECT * FROM sbir_companies WHERE state='$state' AND profile !='' AND (STR_TO_DATE(date_modified, '%m/%d/%Y') > '$compare_timestamp') ORDER BY RAND() LIMIT 1") or die("SELECT Error_featured_firm: ".mysql_error()); $num_rows_featured_firm = mysql_num_rows($result_featured_firm); $row_featured_firm = mysql_fetch_array($result_featured_firm, MYSQL_ASSOC); //echo("row_featured_firm[affiliation]=$row_featured_firm[affiliation] - $row_featured_firm[date_modified]
"); $comp_nid=$row_featured_firm[nid]; $comp_id=$row_featured_firm[id]; $comp_name=$row_featured_firm[affiliation]; $comp_address=$row_featured_firm[address]; $comp_city=$row_featured_firm[city]; $comp_state=$row_featured_firm[state]; $comp_zip=$row_featured_firm[zip]; $comp_phone=$row_featured_firm[phone]; $comp_fax=$row_featured_firm[fax]; $comp_email=$row_featured_firm[email]; $comp_web=$row_featured_firm[web]; $comp_business_id=$row_featured_firm[business_id]; $comp_profile=mb_convert_encoding($row_featured_firm[profile], "auto"); $comp_year_formed=$row_featured_firm[year_formed]; $comp_first_year_in_sbir=$row_featured_firm[first_year_in_sbir]; $comp_size=$row_featured_firm[size]; $comp_sales=$row_featured_firm[sales]; $comp_awards=$row_featured_firm[awards]; $comp_patents=$row_featured_firm[patents]; $comp_status=$row_featured_firm[status]; $comp_private_public=$row_featured_firm[private_public]; $comp_symbol=$row_featured_firm[symbol]; $comp_vc_funded=$row_featured_firm[vc_funded]; $comp_p1awards=$row_featured_firm[p1awards]; $comp_p2awards=$row_featured_firm[p2awards]; $comp_p1dollars=$row_featured_firm[p1dollars]; $comp_p2dollars=$row_featured_firm[p2dollars]; $comp_total_dollars=$row_featured_firm[total_dollars]; if($comp_web=="") { $comp_web_url="no website avail."; } else { $comp_web_url="
$comp_web"; } if($comp_phone=="") { $comp_phone="no phone avail."; } $web_phone_line = "$comp_web_url | $comp_phone"; $limit=180; $comp_profile_length = strlen($comp_profile); if($comp_profile_length > $limit) { $comp_profile_snippet = substr($comp_profile, 0, $limit); $comp_profile_snippet = $comp_profile_snippet . "... see more"; } else { $comp_profile_snippet = $comp_profile . "... see more"; } if ($comp_profile == "") { $comp_profile_snippet = "Currently there is no description available for this company."; $comp_profile = "Currently there is no description available for this company."; } // Prepare PDF file for Featured Firm $profile_comp_name = str_replace(" ", "_", $comp_name); $profile_filename = $timenow . "_" . $uid . "_" . $profile_comp_name; $filein = "/ipool/downloads/CompanyReportTemplate.html"; $fileout = "tmp/$profile_filename"; $FILEIN = fopen($filein, "r"); $FILEOUT = fopen($fileout, "w"); $buffer = fread($FILEIN, filesize($filein)); $buffer = str_replace("0a0a0a0a0a", "$comp_affiliation", "$buffer"); $buffer = str_replace("aaaaaaaaaa", "$comp_name", "$buffer"); $buffer = str_replace("bbbbbbbbbb", "$comp_year_formed", "$buffer"); $buffer = str_replace("cccccccccc", "$comp_first_year_in_sbir", "$buffer"); $buffer = str_replace("dddddddddd", "$comp_size", "$buffer"); $buffer = str_replace("eeeeeeeeee", "$comp_sales", "$buffer"); $buffer = str_replace("ffffffffff", "$comp_awards", "$buffer"); $buffer = str_replace("gggggggggg", "$comp_patents", "$buffer"); $buffer = str_replace("hhhhhhhhhh", "$comp_status", "$buffer"); $buffer = str_replace("iiiiiiiiii", "$comp_address", "$buffer"); $buffer = str_replace("jjjjjjjjjj", "$comp_city", "$buffer"); $buffer = str_replace("kkkkkkkkkk", "$comp_state", "$buffer"); $buffer = str_replace("llllllllll", "$comp_zip", "$buffer"); $buffer = str_replace("mmmmmmmmmm", "$comp_phone", "$buffer"); $buffer = str_replace("nnnnnnnnnn", "$comp_fax", "$buffer"); $buffer = str_replace("oooooooooo", "$comp_web", "$buffer"); $buffer = str_replace("pppppppppp", "$comp_profile", "$buffer"); $buffer = str_replace("qqqqqqqqqq", "$comp_date", "$buffer"); $buffer = str_replace("rrrrrrrrrr", "$comp_business_id", "$buffer"); $buffer = str_replace("ssssssssss", "$comp_stock", "$buffer"); $buffer = str_replace("tttttttttt", "$logofilepath", "$buffer"); $buffer = str_replace("uuuuuuuuuu", "$comp_private_public", "$buffer"); $buffer = str_replace("vvvvvvvvvv", "$presidentName", "$buffer"); $buffer = str_replace("wwwwwwwwww", "$comp_email", "$buffer"); $buffer = str_replace("6a6a6a6a6a", "$comp_vc_funded", "$buffer"); $buffer = str_replace("xxxxxxxxxx", "$comp_p1awards", "$buffer"); $buffer = str_replace("yyyyyyyyyy", "$comp_p2awards", "$buffer"); $buffer = str_replace("zzzzzzzzzz", "$comp_p1dollars", "$buffer"); $buffer = str_replace("1a1a1a1a1a", "$comp_p2dollars", "$buffer"); $buffer = str_replace("2a2a2a2a2a", "$comp_total_dollars", "$buffer"); $buffer = str_replace("8a8a8a8a8a", "$num_rows0", "$buffer"); $buffer = str_replace("3a3a3a3a3a", "$awardAGENCIES", "$buffer"); $buffer = str_replace("4a4a4a4a4a", "$awardTABLE", "$buffer"); $buffer = str_replace("5a5a5a5a5a", "$patentTABLE", "$buffer"); fwrite($FILEOUT, $buffer); fclose($FILEIN); fclose($FILEOUT); $awardAGENCIES=""; $awardTABLE=""; $patentTABLE=""; //$output = array(); //$output[] = node_view(node_load($comp_nid), 'full'); //print implode("\n", $output); //$fileout_nid = drupal_render(node_view(node_load($comp_nid))); //echo("*****$fileout_nid****"); //system("htmldoc --webpage -f $fileout $fileout_nid"); system("htmldoc --webpage --textcolor 505050 --bodyfont Times --logo /ipool/htdocs/images/BusinessProfileHeader.jpg --header l --footer ..1 --bottom 10mm --top 10mm --left 10mm --right 10mm -f $fileout.pdf $fileout"); system("rm $fileout"); // $state_Map_Logo = $state . "_Map_Logo_150.jpg"; ?>
.png" />
     .gif" />
" method="post" name="my_state_comps_form" onsubmit="return validate_see_state_comps_Form(my_state_comps_form);"> 

Support Organizations

  • Entity 1
  • Entity 2
  • Entity 3
  • Entity 4
  • Entity 5

Basic SBIR & STTR Stats

$num_rows_p1_awards\" data-size=\"100\" data-back=\"#E4E4E4\" data-width=\"10\" data-label=\"Phase I\" data-color=\"#505c65\">
$num_rows_p2_awards\" data-size=\"100\" data-back=\"#E4E4E4\" data-width=\"10\" data-label=\"Phase II\" data-color=\"#505c65\">
$num_rows_comps\" data-size=\"100\" data-back=\"#E4E4E4\" data-width=\"10\" data-label=\"Awardees\" data-color=\"#505c65\" ata-animate_gauge_colors=\"1\" data-animate_text_colors=\"1\">

Featured SBIR Firm

$web_phone_line "); ?>

State SBIR-STTR Data: synopsis

  Note: Phase II awards may be incrementally funded. Hence, downturn indicated by this graph is not an error nor a major drop-off of SBIR funding availability. As Phase II awards are made - almost 3/4 of all dollars - steepness of this curve will increase substantially.

Extent of this State's SBIR-STTR

-*SELECT * FROM sbir_state_office_info where state='$state'*-
"); $result = mysql_query( "SELECT * FROM sbir_state_office_info where state='$state'") or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); $row = mysql_fetch_array($result, MYSQL_ASSOC); ?>
Extent of this State's SBIR-STTR
participation over life of program
Award-related data
Awards Phase I Phase II
Total Award Dollars 1983-current
Number Awardees
Current SBIR-STTR Activity Level
Awards (last 5yr) Phase I Phase II
Award Dollars
Current Awardees
External business factors by State Awardees
Publicly Traded
M&A Deals
VC Funded Firms
Total US issued patents
In DOD and NIH particularly, Phase II may be on Phase I awards made three-four years earlier. The comprehensive SBIR tracking system developed and rigorously maintained by the Innovation Development Institute is project-grounded. All related Phase IIs are tracked by relevance to original Phase I i.e. in a single record. As applicable - for example in NIH and some DOD - Phase II awards dollars are recorded incrementally in our offline systems but posted online by total to date.
Source: Innovation Development Institute, Swampscott, MA. ©Copyright 1995-. All rights reserved.

"); ?>
If you want to succeed, you should strike out on new paths rather than travel the worn paths of accepted business 
John D. Rockefeller

To service diverse needs, interests and concerns of the very different segments of SBIR Community using this SIte - Awardees, Federal Agency personnel, Tech Seekers, State Support entities and the range of Professional Service providers - various types of Site Use Accounts are offered

  • No-Cost (Site Registration required)
  • Low Cost: Level ONE Search capacity
  • Partnering: reciprocal Content Provision. Relevant primarily to State Support and Professional Service providers
  • Full-blown Tech Seeker Retainer Contracts: SMART Office Capacity and Custom Support. Major and mid-sized corporations and some Federal players

Consistent with that diversity of Users and of their differing interests, this Site also supports various Search Capabilities and analyses within -- as well as by -- each of these populations.


Part of the small group that achieved passage of original - highly controversial - SBIR enabling legislation in 1982, on the political frontline in 1986 and 1992 Reauthorizations, the last-minute rescue of SBIR in closing minutes of 106th Congress (Dec. 2000) and, though the years, the many other determined efforts to hobble the program, better than most we understand the political effort required to maintain a Federal Program requiring regular Congressional approval.
      Not wishing to repeat the nightmare of the Continuing Resolution marathon of last SBIR Reauthorization (2008-2011), Congressional SBIR Advocates on both sides of the aisle have been working to achieve passage in this 114th Congress. With uncertainly surrounding what the next Congress will look like, there is concern that if SBIR is allowed to lapse by default, re-establishing the Program could be nigh impossible.
      Having made important progress in the Senate -- https://www.congress.gov/bill/114th-congress/senate-bill/2793/all-action... -- the wheels seem to have fallen off the House effort.

Preferably while they are home in the District, YOUR Representatives need to hear from YOU:  individually and collectively! - not only about what SBIR has meant to you BUT also to give them some sense of

  • economic impact:  quality jobs created with the consequent ripple impact in the local area
  • technical impact:  problems being solved, new industries created

For all the reauthorization emphasis in DC - legions of published studies, Congressional Hearings, on-the-Hill visits etc - for my money, nothing comes close to value and effectiveness of In-the-District interaction.

In other words, if SBIR-STTR are/have been important to you, YOU need to be speaking up!


  1. Congressional Testimony Ann Eskesen, President, Innovation Development Institute, LLC
  2. Small Business Technology Council: long time SBIR advocates
Drawing down on comprehensive SBIR-STTR relational databases maintained offline, effort here is to provide
  • No-Cost/Low Cost searchable access of all SBIR Awards, relevant Awardee Business Profiles and some useful Tech Seeker data
  • along with our in-house use of powerful whole system capacities to analyze participation and outcomes in various useful / interesting ways:  VC and IPOs, M&A transactions, Patents: licensing and collaborations, Technology trends; etc. 
For fee, custom studies can be undertaken

Getting to a Deal:
In the final analysis, effective SBIR involvement is NOT about getting Phase I or Phase II Awards.  It's about bringing the developed technology to use-condition.

The organizing principle of this site -- and of idi as a firm -- is to enable that to happen. 

Integrated multi-component system with On- and Offline elements to support full and effective engagement of relevant SBIR talent
Expedited access, useful tools and resources for those seriously interested in systematic SBIR engagement
A la carte, facilitated access for those with less extensive partnering requirements

ExPreS: Expertise Precision Sourcing - NOT Crowd-sourcing
Targeted visibility of external access, project-needs
Customized business-actionable information
Integrated Corporate SBIR engagement system
Range of source-delivery approaches: face-to-face; proposal based; pro-active Tech Sourcing
Substantial opportunities for relevant fertilization across-industry and across-discipline
Depth-in-quality source engagement
Useful business profiles and capability indicators on every SBIR awardes of interest and potential project partnering
Early-stage, cost-effective and lower-risk access to demonstrable talent and disruptive technologies
Sustainable business and technology partnering relationships
In-system catalog of areas of expertise:  self-manage option. Detailed Business Profile, Competency Listings & available technologies
Overview Profiles of every SBIR-STTR Awardees on-site fully searchable by all Site-Registered Users
Pro-active, facilitated access by ASSETs Corporate Clients with specific partnering requirements

Valuable insights into actual technology and business partnering needs of a large range of major/mid-sized corporations
Enabled contact with senior, decision-making personnel having external outreach responsibilities in Major/mid-sized corporations
Improved prospects for likely SBIR selection through systematic securing of Support Letters and other useful indicators of business connection
Invitation to capability-relevant Closed-Door events and proposal submission opportunities
Pre-vetted presentation and face-to-face interaction opportunitiess: individual or group as appropriate
Facilitated access to additional R&D funding and capital resources
Useful enabling of peer-to-peer collaborations
Sustainable business and technology partnering relationships

Contact information

Innovation Development Institute, LLC

   45 Beach Bluff Avenue, Suite 300
     Swampscott,  MA 01907-1542

  Tel:  (781) 595-2920