SHELDON
  • Insights
  • About

SHELDON-AFWERX Discussion 2024-12-11

Review of SHELDON Summary Data for 51 AFWERX Stratfi Companies

AFWERX
RGI
Due Diligence
Summary Metrics
Author

SHELDON

Published

December 10, 2024

SHELDON-AFWERX 2024-12-11 Draft Summary Data Review
Discussion items for 2024-12-11 call.

Contract Details

Contract Number: FA228024C0012
Contractor Name: P.W. Communications, Inc.
Contractor Address: 11200 Rockville Pike Suite 130 Rockville, MD 20852

Company Key SAM Features

Below is a table containing the key features about the companies from System for Award Management (SAM).

These features include:

  1. Unique identifiers including CAGE Code, Unique Entity ID and Company Website (when applicable)

  2. Company naming including Legal Business Name, DBA

  3. Key dates including Company Founding and Initial SAM Registration

  4. Geographic feature of company and entity formation

  5. Key party contact information

  6. Business and entity type specifics including Entity Structure, Entity Type and specialized SAM Business Types

  7. Company stated NAICS and Product Service Codes

  8. SHELDON extracted w3 metadata and media content from company website

  • Company Feature Table

Download Company Key SAM Features

Prime to Sub Summary

This details all of the relationships between Primes and AFWERX companies.

  • Prime to Sub Summary Table

Entity Attribution

First Government Award

  • Attribution Table
  • First Attribution by SHELDON Type Count

First Phase I/II SBIR/STTR

  • Attribution Table
  • First Attribution by Funding Agency Count

Air Force Funded Phase I/II SBIR/STTR

  • Attribution Table
  • First Attribution by Funding Office Count
  • Subsequent vs Prior Scatter

Sample Summary Data Table

Temporal Analysis

  • SAM Registration Date vs First Award Date
  • Company Founding Date vs First Award Date

Company Key Federal Award Metrics

Below are tables and visualizations containing the key summary statistics for the AFWERX stated UEI’s aggregated at the Total Federal Level meaning any contract/procurement (direct), assistance award (direct), public sub-contract (indirect) and public sub-assistance (indirect).

The table includes the total actual obligation amount, number of distinct awards, number of award actions on those awards, information about number of awarding agencies, awarding offices, funding agencies and funding offices. There is also information about the unique company names a UEI has won an award under, first and recent award date, logical variables that helps isolates companies that won specific types of awards, information about the top relationships by total amount, and first company interaction by date.

All Time Federal Performance

  • Company Federal Performance Table - All Time
  • Distinct Award Count vs Amount – All Time
  • # Days in USG vs Sheldon Transition $
  • $ Phase I/II vs Sheldon Transition $
  • # Phase I/II vs SBIR Efficency
  • # Phase I/II vs FPDS Phase III $

Download Company Key Federal Award Metrics – All Time

Normalized Federal Performance

  • Company Federal Performance Table - Normalized Per 1 Year of Output
  • Distinct Award Count vs Amount – Normalized

Download Company Key Federal Award Metrics – Normalized Per Year of Output by Days Operating in USG

Last 2 Years of Federal Performance

  • Company Federal Performance Table - Awards Last 2 Years
  • Distinct Award Count vs Amount – Last 2 Years
  • # Days in USG vs Sheldon Transition $
  • $ Phase I/II vs Sheldon Transition $
  • # Phase I/II vs SBIR Efficency
  • # Phase I/II vs FPDS Phase III $

Download Company Key Federal Award Metrics – Awards Starting within Last 2 Years

Last 5 Years of Federal Performance

  • Company Federal Performance Table - Awards Last 5 Years
  • Distinct Award Count vs Amount – Last 5 Years
  • # Days in USG vs Sheldon Transition $
  • $ Phase I/II vs Sheldon Transition $
  • # Phase I/II vs SBIR Efficency
  • # Phase I/II vs FPDS Phase III $

Download Company Key Federal Award Metrics – Awards Starting within Last 5 Years

Company Key Metrics by Sheldon Funding Type

The table below is similar to the one above but faceted by a special grouping variable called Sheldon Funding Type which isolates awards as follows:

  • Phase I SBIR/STTR Awards (Procurement or Assistance)
  • Phase II SBIR/STTR Awards (Procurement or Assistance)
  • FPDS Phase III SBIR/STTR
  • Non-SBIR Procurement
  • Assistance Excluding Known SBIR/STTRs
  • Sub-Assistance
  • Sub-Contract Major Prime (Any prime company in the top 50 of DoD procurement)
  • Sub-Contract Non-Major Prime (All other sub-contract)

All Time Performance by Sheldon Award Type

  • Company SHELDON Award Type Table – All Time
  • Distinct Award Count vs Amount – All Time by Sheldon Award Type

Download Company Key Metrics by SHELDON Funding Type – All Time

Normalized Per 1 Year of Output by Sheldon Award Type

  • Company SHELDON Award Type Table – Normalized Per 1 Year of Output by Days Operating in USG
  • Distinct Award Count vs Amount – Normalized Per 1 Year of Output by Time in USG by Sheldon Award Type

Download Company Key Metrics by SHELDON Funding Type – Normalized by Days Operating Per Year of Output

Last 2 Years by Sheldon Award Type

  • Company SHELDON Award Type Table – Awards Last 2 Years
  • Distinct Award Count vs Amount – Awards within Last 2 Years by Sheldon Award Type

Download Company Key Metrics by SHELDON Funding Type – Awards Starting within Last 2 Years

Last 5 Years by Sheldon Award Type

  • Company SHELDON Award Type Table – Awards Last 5 Years
  • Distinct Award Count vs Amount – Awards within Last 5 Years by Sheldon Award Type

Download Company Key Metrics by SHELDON Funding Type – Awards Starting within Last 5 Years

GWalkR Analysis Tool

  • All Federal Data
  • Last 2 Years
  • Last 5 Years

2025, SHELDON