Characters length limitation on Excel File Name while sending RFQs
Product(s):
APM Implementation and Performance Management
Version(s):
N/A
Environment:
N/A
Area:
N/A
Subarea:
N/A
Problem:
There is a functionality in APM which allows the Users to send RFQs…
Importação de demandas de uma planilha
Aplica-se a
Produto(s):
WaterCAD, WaterGEMS
Versão(ões):
V8 XM, V8i, CONNECT Edition
Área:
Layout e entrada de dados
Autor Original:
Jesse Dringoli, Grupo de Suporte Técnico da Bentley
…
When I try to copy/paste results from the Post Processing tables into an Excel spreadsheet I get a message saying “Range too big” or “Selection is too large”
Applies To
Product(s):
STAAD.Pro
Version(s):
CONNECT Edition
Environment:
ALL
Area:
Miscellaneous
Subarea:
Original Author:
Phil Riegel, Bentley Technical Support Group…
SPPM - Ability to scroll while highlighting data in the spreadsheet
In Staad Pro Physical Modeler -
It is sometimes useful to drag and select multiple rows and columns in the spreadsheet sidebar/tab. However, when you get to the bottom row of what is shown on screen the program will not scroll down to allow you to continue…
RAM Structural System Excel Macros Using RAM Data Access
This wiki demonstrates an Excel macro created with RAM DataAccess, the programming interface into RAM Structural System model data that comes with regular product installation. At the link below is an Excel file containing a macro that automates the creation…
Member releases in an excel sheet
Applies To
Product(s):
STAAD.Pro
Version(s):
Connect Edition
Environment:
ALL
Area:
Modeling Solutions
Subarea:
Specifications
Original Author:
Sye Chakraborty, Bentley…
TAG report in CONNECT
Hello all,
I just installed CONNECT on my laptop and I don't know how to extract tag information into a spreadsheet. can anyone help me? I could do on V8i but cannot find in CONNECT.
Thank you, Marina
Practical use of the commands runner: Pile field
Application
PLAXIS 3D
Version
PLAXIS 3D
Date created
09 May 2011
Date modified
09 May 2011
The movie shows how to use the commands runner for more efficient modelling. The generation of a circular pile field was…
Running Tag Report - Macro
Hello,
I am am creating a Tag for every cable on most of our drawings. I can get it to the point where I can create a report and put it into a .CSV/Excel spreadsheet no problem.
Now, i need to do this on almost 100 drawings. So naturally, I find…
Copy and paste (import or export) tabular or Flextable data
Product(s):
WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm, PondPack
Version(s):
08.11.XX.XX and 10.00.00.XX
Area:
Layout and Data Input
Problem
How can tabular data (such as from a Flextable) be copied…
"External Component..." or "currently in use or invalid" error with ModelBuilder, SCADAConnect or Inroads Import
Product(s):
WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm
Version(s):
V8i, CONNECT Edition
Area:
Other
Problem
When working with a spreadsheet or Access Database file in ModelBuilder or SCADAConnect…
Import Demand Date by Node ID
communities.bentley.com/.../importing-demands-from-a-spreadsheet
Process does not work when your version of Microsoft Office is a different bit rate than the version of WaterGEMS installed. We have 64 bit WaterGEMS and 32 bit Office and get this error…
External database driver error with Excel file in ModelBuilder or SCADAConnect
Product(s):
WaterCAD, WaterGEMS, StormCAD, SewerCAD, SewerGEMS, CivilStorm
Version(s):
08.09.XX.XX, 08.11.XX.XX, 10.00.00.XX
Area:
Layout and Data Input
Problem
When attempting to connect to an Excel spreadsheet file in ModelBuilder…
Creating data tables (spreadsheets) from tags?
Hello,
I am not sure if this is where to post but if it is not, please feel free to move this to the relevant forum.
I have been tasked with a way to collect information from drawings. Namely cable tags that are going to appear sporadically within…
Easily export hydraulic model information to Excel spreadsheet format
Ever wished you could easily export all element information at once, including time-series data? (multiple timesteps). Watch this short video to see how this can be done with the Export to Excel feature.
Applicable Products:
- WaterCAD, WaterGEMS…
RE: StormCAD: Report of All Composite Tc Components
Bill,
I created the following article to explain how to export the time of concentration collection data.
How to create a report of catchment time of concentration collection data by exporting to an Excel spreadsheet with ModelBuilder.
RE: Import Foundation Input from a Microsoft Office Excel® spreadsheet to StaadFoundation Advanced V8i
Here is the easiest way to get a good spreadsheet. Open up STAAD Foundation Advanced and choose Open to bring up the Open dialog box. Browse to the installation folder of SFA and inside the Examples folder ( C:\Staad Foundation Advanced SS3\Examples …
How to create a PDF that contains a searchable excel table?
Hello,
When importing a table from excel I follow the "Inserting Tables" guide, http://communities.bentley.com/products/electrical___instrumentation/w/electrical_and_instrumentation__wiki/6787.inserting-tables
However when I create a PDF of the sheet…
Create A Spreadsheet
I would like to create a spreadsheet(table of data) within Promis.e. Is this possible?
API mac.xls
This files is an example spreadsheet for use as the instruction file with the Project API Builder tool in promis.e and Bentley Substation. It will create a project named API Builder Test, create a schematic page, and insert the MOT1 macro three times…
Export Column Design Results with Sketches.
Dear All,
This is a coded excel sheet that exports Column Design results from STAAD output and generates table with column data as well as a sketch ( Plan ) with Maximum Area Steel required in each Column.
the sheet selects the maximum area required…
How can I create a selection set from data I have in an excel spreadsheet?
Applies To
Product(s):
Bentley WaterGEMS, Bentley SewerGEMS, Bentley CivilStorm, Bentley StormCAD, Bentley PondPack, Bentley SewerCAD, Bentley HAMMER, Bentley WaterCAD
Version(s):
08.11.XX.XX
Environment…
Microstran Exchanging Data with Spreadsheets
Applies To
Product(s):
Microstran
Version(s):
V8i
Environment:
N/A
Area:
User Interface, Modeling
Original Author:
Richard Collins
Exchanging Data Between…
Error - Embedded Object - Excel Spreadsheet (Object Failed to activate)
-Microstation SS3
-Windows 7 (32bit)
I had recently received a file done by a consultant, on the final version of the drawing I got the spread sheet gave me this message (see below) instead of opening in excel. The consultant had claimed that on their…
Doors, Spaces and spreadsheets
I am currently working on a large project using Aecosim building designer. We are managing to utilise the tools available to apply data to doors, spaces and other objects as well as output schedules based on this information. We are limited to working…