Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki How To Set up a Grouped Sheet
    • Sign In
    • -gINT | Keynetix Wiki
      • +gINT
      • +gINT Collector
      • +gINT Civil Tools
      • -Keynetix
        • +Installing or Upgrading to CONNECT Edition
        • +Archive Webinars
        • +HoleBASE
        • +HoleBASE Civil Extension
        • +HoleBASE Data Entry
        • +HoleBASE Excel Extension
        • +HoleBASE Template Studio
        • +KeyAGS
        • -KeyLAB
          • Implimenting KeyLAB
          • +KeyLAB Setup and Installation
          • +KeyLAB Getting Started Videos
          • +KeyLAB How Tos
          • +Excel Tips and Tricks
          • -KeyLAB FAQ's
            • +Working with Samples
            • +Working with Tests
            • -Test Sheet Design
              • FAQ-How does the 'Engineering Mode' for scaling work
              • How do I hide/remove Test Definitions and Tests which i no longer need?
              • How do I use two input sheets for the same test
              • How Do I Add a Reference Cell?
              • How To Create a Duplicate Test Definition
              • How to Define a Calibration Row for Input Sheets and show a Calibration Table
              • How To Extend List Beyond 100 Rows
              • How To Fix a KeyLAB sheet which isn't showing the correct number of test sheets
              • How To Fix a KeyLAB sheet which isn't showing the correct number of test sheets1
              • How to Fix a Name Range Error
              • How to Fix Lost Test Links
              • How To Fix Problems with Calculation Tabs in KeyLAB
              • How To Link Tests in KeyLAB
              • How to Reference the Schedule Name on a test sheet
              • How to Set Graphing Scales
              • How to Set Printing Settings for consistant margins
              • How To Set up a Grouped Sheet
              • How to set up decimal places and significant figures in KeyLAB.
              • How to set up Image Placeholders
              • How to Use Text Boxes for Headers in KeyLAB
              • How to use the AGS Mapping to Control the Format of the Numeric Values
              • How to use the Geotechnical Function for Graphical Interpretation.
              • How To Use the KeyLAB Validation Cells
              • How To Use the Ordering on Report sheet
              • How To Use the Splitting on Report Sheets
              • Issues Printing Problems
              • Issues With KeyLAB Test Definition and What you Can Put in Them.
              • Issues-Why Do the Graphs not Update when Batch Printing from KeyLAB?
              • One or More Named Ranges contain Invalid References
              • The Geotechnical Functions Addin is not loaded in KeyLAB2
              • There is no Image Path defined in the Preferences dialog
              • Why does my VBA run Slowly within KeyLAB?
            • +Configuration
            • +AGS Management
          • KeyLAB Release Notes
        • +Keynetix Component Downloads
        • +Working from Home with Keynetix Products
        • Hardware Specifications and Recommendations
        • Supported Platforms

     
     Questions about this article, topic, or product? Click here. 

    How To Set up a Grouped Sheet

      Product(s): Keynetix
      Version(s): 1.0
      Area: Assist

    How To Set up a Grouped Sheet

    Explanation

    Grouped sheet let you present more than one sample on an input or output sheet. These take the form of summaries or group input sheet like the standard Moisture Content sheet.

    Process

    To set up groups you will need to create the first row of the group. This will need to include any extra data for reference cells used for calculations which might be hidden to the left of the sheet.

    Once you have the first row correct, highlight it and click the drop down for grouping in the KeyLAB sheet designer ribbon. Select Set, this will set that highlighted area as the first group.

    Once you have set the top group you can go down to the next row. When you go to the next row go to the grouping drop down and click paste, it will create a new row with all the same reference or data cells now in group 2. Repeat this process until you have all the rows you need

    If you make any changes to the grouped sheet. its very important to make sure that you reset the group before making the changes. To reset the groups go to the grouping drop down and click reset. depending on the size of the sheet this may take a minute

    • Migrated
    • Share
    • History
    • More
    • Cancel
    • wiki.author Created by Bentley Colleague wiki.author
    • When: Tue, Jun 9 2020 9:46 PM
    • Revisions: 1
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies