skip to main content
US FlagAn official website of the United States government
dot gov icon
Official websites use .gov
A .gov website belongs to an official government organization in the United States.
https lock icon
Secure .gov websites use HTTPS
A lock ( lock ) or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.


Title: Excel–SBOL Converter: Creating SBOL from Excel Templates and Vice Versa
Award ID(s):
2140378
PAR ID:
10402979
Author(s) / Creator(s):
; ; ; ; ;
Date Published:
Journal Name:
ACS Synthetic Biology
Volume:
12
Issue:
1
ISSN:
2161-5063
Page Range / eLocation ID:
340 to 346
Format(s):
Medium: X
Sponsoring Org:
National Science Foundation
More Like this
  1. This session is a basic introduction to descriptive statistics for research administration professionals. No worries! Excel will be used throughout, nothing will be calculated by hand. Averages (means), medians, standard deviations, correlations and other basic statistical concepts will be explained using only research administration data as context. A sample research administration data set will be provided and Excel will be used to analyze the data. Some sample charts and best practices in creating these charts will also be shown. Again using Excel. This is the perfect session for anyone in research administration whose roles include analyzing data using descriptive statistics. Whether you are new to statistics or whether you can't remember a statistics class you might have taken at some point. Basic knowledge of Excel would be helpful for this session. 
    more » « less
  2. Malicious software (malware) poses a significant threat to the security of our networks and users. In the ever-evolving malware landscape, Excel 4.0 Office macros (XL4) have recently become an important attack vector. These macros are often hidden within apparently legitimate documents and under several layers of obfuscation. As such, they are difficult to analyze using static analysis techniques. Moreover, the analysis in a dynamic analysis environment (a sandbox) is challenging because the macros execute correctly only under specific environmental conditions that are not always easy to create. This paper presents SYMBEXCEL, a novel solution that leverages symbolic execution to deobfuscate and analyze Excel 4.0 macros automatically. Our approach proceeds in three stages: (1) The malicious document is parsed and loaded in memory; (2) Our symbolic execution engine executes the XL4 formulas; and (3) Our Engine concretizes any symbolic values encountered during the symbolic exploration, therefore evaluating the execution of each macro under a broad range of (meaningful) environment configurations. SYMBEXCEL significantly outperforms existing deobfuscation tools, allowing us to reliably extract Indicators of Compromise (IoCs) and other critical forensics information. Our experiments demonstrate the effectiveness of our approach, especially in deobfuscating novel malicious documents that make heavy use of environment variables and are often not identified by commercial anti-virus software. 
    more » « less
  3. Older adults may experience certain forms of cognitive decline, but some forms of semantic memory remain intact in older age. To address how metaphor comprehension changes with age and whether metaphor comprehension relies more heavily on analogical reasoning (supported by fluid intelligence) or on conceptual combination (supported by crystalized intelligence), we compared performance of younger and older adults. In two experiments, healthy older adults (54–88 years) scored lower on a measure of fluid intelligence (Ravens Progressive Matrices) but higher on a measure of crystalized intelligence (Mill Hill Vocabulary Test) relative to younger adults (18–34 years). Groups were equally successful in comprehending relatively easy metaphors (Study 1), but older adults showed a striking advantage over younger adults for novel literary metaphors (Study 2). Mixed-effects modeling showed that measures of fluid and crystalized intelligence each made separable contributions to metaphor comprehension for both groups, but older adults relied more on crystalized intelligence than did younger adults. These age-related dissociations clarify cognitive effects of aging and highlight the importance of crystalized intelligence for metaphor comprehension in both younger and older adults. 
    more » « less