Month: June 2024
Issue with Batch Insertion using PreparedStatement in SQL Server
Hi,
We are experiencing an issue while executing batch insertion using the preparedStatement.executeBatch() method in our Scala code. The problem is that it is inserting object references instead of actual values for VARCHAR columns. Below are the settings and the code snippet we are using:
Settings:
sendStringParametersAsUnicode=falseconnection.setUseBulkCopyForBatchInsert(true)There is no Date type column in the target table. (issue not reproducible with date columns)
Mssql Driver version: Tested with latest driver
mssql-jdbc-12.6.2.jre11
Issue Description:
When using the above method, we notice that for VARCHAR columns, instead of inserting the actual values, object references are being inserted into the table.
Could you please provide guidance on how to resolve this issue or let us know if there are any specific configurations or code adjustments required?
Following is Code Example:
private def executeSqlBatch(query: String, records: List[scala.Array[Any]], conn: Connection): Unit = {
var connection = conn
var preparedStatement: PreparedStatement = null
try {
preparedStatement = connection.prepareStatement(query)
records.foreach(record => {
var idx = 0
record.foreach { field =>
idx += 1
preparedStatement.setObject(idx, field)
}
preparedStatement.addBatch()
})
if (records.nonEmpty) {
preparedStatement.executeBatch()
} else {
preparedStatement.execute()
}
if (conn == null && connection != null) {
connection.commit()
}
} catch {
case ex: Exception =>
try {
if (conn == null && connection != null) connection.rollback()
} catch {
case rEx: Exception => logger.error(“An exception occurred during rollback:”, rEx)
}
throw ex
} finally {
preparedStatement.clearBatch()
preparedStatement.clearParameters()
DbUtils.closeQuietly(preparedStatement)
if (conn == null) {
DbUtils.closeQuietly(connection)
}
}
}
Hi,We are experiencing an issue while executing batch insertion using the preparedStatement.executeBatch() method in our Scala code. The problem is that it is inserting object references instead of actual values for VARCHAR columns. Below are the settings and the code snippet we are using:Settings:sendStringParametersAsUnicode=falseconnection.setUseBulkCopyForBatchInsert(true)There is no Date type column in the target table. (issue not reproducible with date columns)Mssql Driver version: Tested with latest drivermssql-jdbc-12.6.2.jre11Issue Description:When using the above method, we notice that for VARCHAR columns, instead of inserting the actual values, object references are being inserted into the table.Could you please provide guidance on how to resolve this issue or let us know if there are any specific configurations or code adjustments required?Following is Code Example:private def executeSqlBatch(query: String, records: List[scala.Array[Any]], conn: Connection): Unit = {var connection = connvar preparedStatement: PreparedStatement = nulltry {preparedStatement = connection.prepareStatement(query)records.foreach(record => {var idx = 0record.foreach { field =>idx += 1preparedStatement.setObject(idx, field)}preparedStatement.addBatch()})if (records.nonEmpty) {preparedStatement.executeBatch()} else {preparedStatement.execute()}if (conn == null && connection != null) {connection.commit()}} catch {case ex: Exception =>try {if (conn == null && connection != null) connection.rollback()} catch {case rEx: Exception => logger.error(“An exception occurred during rollback:”, rEx)}throw ex} finally {preparedStatement.clearBatch()preparedStatement.clearParameters()DbUtils.closeQuietly(preparedStatement)if (conn == null) {DbUtils.closeQuietly(connection)}}} Read More
MVP’s Favorite Content: Copilot+ PC, AI, Identity, Aspire
In this blog series dedicated to Microsoft’s technical articles, we’ll highlight our MVPs’ favorite article along with their personal insights.
Tomokazu Kizawa, Windows and Devices MVP, Japan
“The Copilot+ PC is a new PC concept that allows AI processing, which was previously done in the cloud, to be performed at the edge (on the PC itself). It requires an NPU capable of performing 40 trillion operations per second, high-speed and large-capacity memory, and fast storage. The Surface Pro 11 and Surface Laptop 7, equipped with Qualcomm’s Snapdragon X series processors, have been announced as high-performance PCs that make the Copilot+ PC a reality.
This article provides an excellent explanation of the new Surface series.”
(In Japanese, Copilot+ PCは、クラウドで処理をしていたAI処理をエッジ(PC)でも実行できるようにした新しいPCのコンセプトです。1秒間に40兆回の処理を行うNPU、高速で大容量なメモリ、高速なストレージを持つことが条件になっています。そして、Copilot+ PCを実現する高性能PCとしてQualcommのSnapdragon Xシリーズプロセッサを搭載した、Surface Pro 11とSurface Laptop 7が発表されました。
この記事は新型Surfaceシリーズをわかりやすく解説した素晴らしい記事です。)
*Relevant Video: 第731回 パソコンが変わる。Surfaceが変える。Copilot+ PC・新型Surface Pro 11とSurface Laptop (2024/5/26) (youtube.com)
Komes Chandavimol, AI MVP, Thailand
“My favorite site is the Microsoft Generative AI Hackathon, where over 1,000 participants compete in creating multimodal applications. The winner of the competition is ChatEDU, an innovative tool designed to transform students’ use of generative AI from mere task and assignment automation into a dynamic copilot that collaborates and learns with them. The runner-up is Garvis, which eliminates the need for users to verbally describe visual problems by directly analyzing and understanding the scene and replaces text-based instructions with intuitive visual demonstrations directly in the user’s environment. Both projects are incredible. You can explore more interesting multimodal applications in the gallery at Microsoft Generative AI Hackathon Project Gallery.”
(In Thai, งาน Microsoft Generative AI Hackathon ล่าสุด มีผู้เข้าแข่งขันหลายพันคน โดยมีหลายๆทีมที่น่าสนใจมาใน AI Hackathon Gallery โดยผู้ชนะ คือ ChatEDU เครื่องมือช่วยนักเรียนใช้ Gen AI ช่วยในการเรียน)
Zheng Xing, Windows Development MVP, China
Use Identity to secure a Web API backend for SPAs | Microsoft Learn
“As the architect of the project, I am responsible for guiding the team in designing and implementing products that comply with the secure development lifecycle. For our project, in a web application that is split between front-end and back-end and will integrate multiple third-party systems in the future, introducing ASP.NET Core Identity to achieve comprehensive identity authentication and authorization is an efficient and reasonable solution. This article provides detailed guidance and a link to an example. I have benefited a lot from it. Meanwhile, through community interactions, I’ve found that not all developers are aware of ASP.NET Core Identity. Therefore, I seize this opportunity to highly recommend it to everyone!”
(In Chinese, 作为项目的架构师，我需要指导团队设计并实现符合安全开发生命周期的产品。对于我们的项目来说，一个前后端分离，且未来会集成多个三方系统的Web Application中，通过引入ASP.NET Core Identity来实现完善的身份认证和授权，是一个高效合理的方案。这篇文章给出了详细的指导，并提供了示例的链接。我受益良多，同时在社区的交流中我发现，并不是所有的开发者都知道ASP.NET Core Identity，借此机会强烈推荐给大家！)
Tomomitsu Kusaba, Developer Technologies MVP, Japan
“.NET Aspire has reached General Availability (GA). I believe this will have a significant impact on creating cloud-native applications.”
(In Japanese, .NET AspireがGAしました。これはクラウドネイティブアプリケーションを作成する上で大きなインパクトを与える事項になると考えています。)
Microsoft Tech Community – Latest Blogs –Read More
Single-region deployment without Global Reach, using Secure Virtual WAN Hub with Routing-Intent
This article describes the best practices for connectivity and traffic flows with single-region Azure VMware Solution when using Azure Secure Virtual WAN with Routing Intent. You learn the design details of using Secure Virtual WAN with Routing-Intent without Global Reach. This article breaks down Virtual WAN with Routing Intent topology from the perspective of an Azure VMware Solution private cloud, on-premises sites, and Azure native. The implementation and configuration of Secure Virtual WAN with Routing Intent are beyond the scope and aren’t discussed in this document.
In regions without Global Reach support or with a security requirement to inspect traffic between Azure VMware Solution and on-premises at the hub firewall, a support ticket must be opened to enable ExpressRoute to ExpressRoute transitivity. ExpressRoute to ExpressRoute transitivity isn’t supported by default with Virtual WAN. – see Transit connectivity between ExpressRoute circuits with routing intent
Secure Virtual WAN with Routing Intent is only supported with Virtual WAN Standard SKU. Secure Virtual WAN with Routing Intent provides the capability to send all Internet traffic and Private network traffic (RFC 1918) to a security solution like Azure Firewall, a third-party Network Virtual Appliance (NVA), or SaaS solution. In the scenario, we have a network topology that spans a single region. There’s one Virtual WAN with a single hub located in the Region. The Hub has its own instance of an Azure Firewall deployed, essentially making it a Secure Virtual WAN Hub. Having a Secure Virtual WAN hub is a technical prerequisite to Routing Intent. The Secure Virtual WAN Hub has Routing Intent enabled.
The single region also has an Azure VMware Solution Private Cloud and an Azure Virtual Network. There’s also an on-premises site connecting to the region, which we review in more detail later in this document.
Note
If you’re using non-RFC1918 prefixes in your connected on-premises, Virtual Networks or Azure VMware Solution, make sure you have specified those prefixes in the “Private Traffic Prefixes” text box for Routing Intent. Keep in mind that you should always enter summarized routes only in the “Private Traffic Prefixes” section to cover your range. Do not input the exact range that is being advertised to Virtual WAN as this can lead to routing issues. For example, if the ExpressRoute Circuit is advertising 40.0.0.0/24 from on-premises, put a /23 CIDR range or larger in the Private Traffic Prefix text box (example: 40.0.0.0/23). – see Configure routing intent and policies through Virtual WAN portal
Note
When configuring Azure VMware Solution with Secure Virtual WAN Hubs, ensure optimal routing results on the hub by setting the Hub Routing Preference option to “AS Path.” – see Virtual hub routing preference
Understanding Topology Connectivity
Connection
Description
Connections (D)
Azure VMware Solution private cloud managed ExpressRoute connection to the hub.
Connections (E)
on-premises ExpressRoute connection to the hub.
The following sections cover traffic flows and connectivity for Azure VMware Solution, on-premises, Azure Virtual Networks, and the Internet.
This section focuses on only the Azure VMware Solution private cloud. The Azure VMware Solution private cloud has an ExpressRoute connection to the hub (connections labeled as “D”).
With ExpressRoute to ExpressRoute transitivity enabled on the Secure Hub and Routing-Intent enabled, the Secure Hub sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to Azure VMware Solution over connection “D”. In addition to the default RFC 1918 addresses, Azure VMware Solution learns more specific routes from Azure Virtual Networks and Branch Networks (S2S VPN, P2S VPN, SDWAN) that are connected to the hub. Azure VMware Solution doesn’t learn specific routes from on-premises networks. For routing traffic back to on-premises networks, it uses the default RFC 1918 addresses that it learned from connection “D”. This traffic transits through the Hub firewall, as shown in the diagram. The Hub firewall has the specific routes for on-premises networks and routes traffic toward the destination over connection “E”. Traffic from Azure VMware Solution, heading towards Virtual Networks, will transit the Hub firewall. For more information, see the traffic flow section.
The diagram illustrates traffic flows from the perspective of the Azure VMware Solution Private Cloud.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN Hub firewall?
1
Azure VMware Solution Cloud
→
Virtual Network
Yes, traffic is inspected at the Hub firewall
2
Azure VMware Solution Cloud
→
on-premises
Yes, traffic is inspected at the Hub firewall
This section focuses only on the on-premises site. As shown in the diagram, the on-premises site has an ExpressRoute connection to the hub (connection labeled as “E”).
With ExpressRoute to ExpressRoute transitivity enabled on the Secure Hub and Routing-Intent enabled, the Secure Hub sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to on-premises over connection “E”. In addition to the default RFC 1918 addresses, on-premises learns more specific routes from Azure Virtual Networks and Branch Networks (S2S VPN, P2S VPN, SDWAN) that are connected to the hub. On-premises doesn’t learn specific routes from Azure VMware Solution networks. For routing traffic back to Azure VMware Solution networks, it uses the default RFC 1918 addresses that it learned from connection “E”. This traffic transits through the Hub firewall, as shown in the diagram. The Hub firewall has the specific routes for Azure VMware Solution networks and routes traffic toward the destination over connection “D”. Traffic from on-premises, heading towards Virtual Networks, will transit the Hub firewall. For more information, see the traffic flow section for more detailed information.
As mentioned earlier, when you enable ExpressRoute to ExpressRoute transitivity on the Hub, it sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to your on-premises network. Therefore, you shouldn’t advertise the exact RFC 1918 prefixes (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) back to Azure. Advertising the same exact routes creates routing problems within Azure. Instead, you should advertise more specific routes back to Azure for your on-premises networks.
Note
If you’re currently advertising the default RFC 1918 addresses from on-premises to Azure and wish to continue this practice, you need to split each RFC 1918 range into two equal sub-ranges and advertise these sub-ranges back to Azure. The sub-ranges are 10.0.0.0/9, 10.128.0.0/9, 172.16.0.0/13, 172.24.0.0/13, 192.168.0.0/17, and 192.168.128.0/17.
The diagram illustrates traffic flows from the perspective of on-premises.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN Hub firewall?
3
on-premises
→
Azure VMware Solution Cloud
Yes, traffic is inspected at the Hub firewall
4
on-premises
→
Virtual Network
Yes, traffic is inspected at the Hub firewall
This section focuses only on connectivity from an Azure Virtual Network perspective. As depicted in the diagram, the Virtual Network has a Virtual Network peering directly to the hub.
The diagram illustrates how all Azure native resources in the Virtual Network learn routes under their “Effective Routes”. A Secure Hub with Routing Intent enabled always sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to peered Virtual Networks. Azure native resources in the Virtual Network don’t learn specific routes from outside of their Virtual Network. With Routing Intent enabled, all resources in the Virtual Network currently possess the default RFC 1918 address and use the hub firewall as the next hop. All traffic ingressing and egressing the Virtual Networks will always transit the Hub Firewall. For more information, see the traffic flow section for more detailed information.
The diagram illustrates traffic flows from an Azure Virtual Network perspective.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN Hub firewall?
5
Virtual Network
→
Azure VMware Solution Cloud
Yes, traffic is inspected at the Hub firewall
6
Virtual Network
→
on-premises
Yes, traffic is inspected at the Hub firewall
This section focuses only on how internet connectivity is provided for Azure native resources in Virtual Networks and Azure VMware Solution Private Clouds in a single region. There are several options to provide internet connectivity to Azure VMware Solution. – see Internet Access Concepts for Azure VMware Solution
Option 1: Internet Service hosted in Azure
Option 2: VMware Solution Managed SNAT
Option 3: Azure Public IPv4 address to NSX-T Data Center Edge
Although you can use all three options with Single Region Secure Virtual WAN with Routing Intent, “Option 1: Internet Service hosted in Azure” is the best option when using Secure Virtual WAN with Routing Intent and is the option that is used to provide internet connectivity in the scenario. The reason why “Option 1” is considered the best option with Secure Virtual WAN is due to its ease of security inspection, deployment, and manageability.
As mentioned earlier, when you enable Routing Intent on the Secure Hub, it advertises RFC 1918 to all peered Virtual Networks. However, you can also advertise a default route 0.0.0.0/0 for internet connectivity to downstream resources. With Routing Intent, you can choose to generate a default route from the hub firewall. This default route is advertised to your Virtual Network and to Azure VMware Solution. This section is broken into two sections, one that explains internet connectivity from an Azure VMware Solution perspective and another from the Virtual Network perspective.
When Routing Intent is enabled for internet traffic, the default behavior of the Secure Virtual WAN Hub is to not advertise the default route across ExpressRoute circuits. To ensure the default route is propagated to the Azure VMware Solution from the Azure Virtual WAN, you must enable default route propagation on your Azure VMware Solution ExpressRoute circuits – see To advertise default route 0.0.0.0/0 to endpoints. Once changes are complete, the default route 0.0.0.0/0 is then advertised via connection “D” from the hub. It’s important to note that this setting shouldn’t be enabled for on-premises ExpressRoute circuits. As a best practice, it’s recommended to implement a BGP Filter on your on-premises equipment. A BGP Filter in place prevents the inadvertent learning of the default route, adds an extra layer of precaution, and ensures that on-premises internet connectivity isn’t impacted.
When Routing Intent for internet access is enabled, the default route generated from the Secure Virtual WAN Hub is automatically advertised to the hub-peered Virtual Network connections. You’ll notice under Effective Routes for the Virtual Machines’ NICs in the Virtual Network that the 0.0.0.0/0 next hop is the hub firewall.
For more information, see the traffic flow section.
The diagram illustrates traffic flows from a Virtual Network and Azure VMware Solution perspective.
Traffic Flow Chart
Traffic Flow Number
Source
Direction
Destination
Traffic Inspected on Secure Virtual WAN hub firewall?
7
Virtual Network
→
Internet
Yes, traffic is inspected at the Hub firewall
8
Azure VMware Solution Cloud
→
Internet
Yes, traffic is inspected at the Hub firewall
HCX Mobility Optimized Networking (MON) is an optional feature to enable when using HCX Network Extensions (NE). Mobility Optimized Networking (MON) provides optimal traffic routing under certain scenarios to prevent network tromboning between the on-premises-based and cloud-based resources on extended networks.
Enabling Mobility Optimized Networking (MON) for a specific extended network and a virtual machine changes the traffic flow. After implementing Mobility Optimized Networking (MON), egress traffic from that virtual machine does not trombone back to on-premises. Instead, it bypasses the Network Extensions (NE) IPSEC tunnel. Traffic for that virtual machine will now egress out of the Azure VMware Solution NSX-T Tier-1 Gateway> NSX-T Tier-0 Gateway>Azure Virtual WAN.
Enabling Mobility Optimized Networking (MON) for a specific extended network and a virtual machine results in a change. From Azure VMware Solution NSX-T, it injects a /32 host route back to Azure Virtual WAN. Azure Virtual WAN advertises this /32 route back to on-premises, Virtual Networks, and Branch Networks (S2S VPN, P2S VPN, SDWAN). The purpose of this /32 host route is to ensure that traffic from on-premises, Virtual Networks, and Branch Networks doesn’t use the Network Extensions (NE) IPSEC tunnel when destined for the Mobility Optimized Networking (MON) enabled Virtual Machine. Traffic from source networks is directed straight to the Mobility Optimized Networking (MON) enabled Virtual Machine due to the /32 route that is learned.
With ExpressRoute to ExpressRoute transitivity enabled on the Secure Hub and Routing-Intent enabled, the Secure Hub sends the default RFC 1918 addresses (10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16) to both the on-premises and Azure VMware Solution. In addition to the default RFC 1918 addresses, both on-premises and Azure VMware Solution learn more specific routes from Azure Virtual Networks and Branch Networks (S2S VPN, P2S VPN, SDWAN) that are connected to the hub. However, on-premises networks don’t learn any specific routes from the Azure VMware Solution, nor does the reverse occur. Instead, both environments rely on the default RFC 1918 addresses to facilitate routing back to one another via the Hub firewall. This means that more specific routes, such as HCX Mobility Optimized Networking (MON) Host Routes, aren’t advertised from the Azure VMware Solution ExpressRoute to the on-premises-based ExpressRoute circuit and vice-versa. The inability to learn specific routes introduces asymmetric traffic flows. Traffic egresses Azure VMware Solution via the NSX-T Tier-0 gateway, but returning traffic from on-premises returns over the Network Extensions (NE) IPSEC tunnel.
To correct any traffic asymmetry, you need to adjust the HCX Mobility Optimized Networking (MON) Policy Routes. Mobility Optimized Networking (MON) policy routes determine which traffic goes back to the on-premises Gateway via an L2 extension. They also decide which traffic is routed through the Azure VMware Solution NSX Tier-0 Gateway.
If a destination IP matches and is set to “allow” in the Mobility Optimized Networking (MON) policy configuration, then two actions occur. First, the packet is identified. Second, it’s sent to the on-premises gateway through the HCX Network Extension appliance.
If a destination IP doesn’t match, or is set to “deny” in the Mobility Optimized Networking (MON) policy, the system sends the packet to the Azure VMware Solution Tier-0 for routing.
HCX Policy Routes
Network
Redirect to Peer
Note
Azure Virtual Network Address Space
Deny
Please ensure to explicitly include the address ranges for all your Virtual Networks. Traffic intended for Azure is directed out via the Azure VMware Solution and doesn’t return to the on-premises network.
Default RFC 1918 Address Spaces
Allow
Add in the default RFC 1918 addresses 10.0.0.0/8, 172.16.0.0/12, and 192.168.0.0/16. This configuration ensures that any traffic not matching the above criteria is rerouted back to the on-premises network. If your on-premises setup utilizes addresses that aren’t part of RFC 1918, you must explicitly include those ranges.
0.0.0.0/0
Deny
For addresses that aren’t covered by RFC 1918, such as Internet-routable IPs, or any traffic that doesn’t match the specified entries above, exits directly through the Azure VMware Solution and isn’t redirected back to the on-premises network.
For more information on Virtual WAN hub configuration, see About virtual hub settings.
For more information on how to configure Azure Firewall in a Virtual Hub, see Configure Azure Firewall in a Virtual WAN hub.
For more information on how to configure the Palo Alto Next Generation SAAS firewall on Virtual WAN, see Configure Palo Alto Networks Cloud NGFW in Virtual WAN.
For more information on Virtual WAN hub routing intent configuration, see Configure routing intent and policies through Virtual WAN portal.
Microsoft Tech Community – Latest Blogs –Read More
Why does my GPU not outperform my CPU/another GPU? Troubleshooting Steps
Why does my GPU not outperform my CPU / another GPU?
Here are some troubleshooting steps to understanding factors which affect performance.Why does my GPU not outperform my CPU / another GPU?
Here are some troubleshooting steps to understanding factors which affect performance. Why does my GPU not outperform my CPU / another GPU?
Here are some troubleshooting steps to understanding factors which affect performance. gpu, graphics, performance, kernel, timeout, benchmark MATLAB Answers — New Questions
What does v51 or v37 or v46 etc. mean in license manager?
I am trying to make a tool to help my company organize our MATLAB license use. Currently I am using the command "lmutil lmstat -a -c <license server>" and I’m just parsing the string output. The command prints out each type of license we have such as MATLAB, SIMULINK, etc. then within each license section it prints information about the license for a certain block of users in a nodelocked or floating license. I’m guessing this is grouped by location like IP addresses of the same location or something similar. Within this information, right next to the license type it prints v51 or v46 or some 2 digit number. For example the section starts with MATLAB v51. Then below that section it prints information about each user currently using that license. Each user line also prints out a vXY, and it can be the same or different than the corresponding license above. For example MATLAB v51 could have a user with v37. I’m just wondering what this v number means. Does it correspond to a MATLAB version somehow? If not, is there other information in the output that would tell me a users version?I am trying to make a tool to help my company organize our MATLAB license use. Currently I am using the command "lmutil lmstat -a -c <license server>" and I’m just parsing the string output. The command prints out each type of license we have such as MATLAB, SIMULINK, etc. then within each license section it prints information about the license for a certain block of users in a nodelocked or floating license. I’m guessing this is grouped by location like IP addresses of the same location or something similar. Within this information, right next to the license type it prints v51 or v46 or some 2 digit number. For example the section starts with MATLAB v51. Then below that section it prints information about each user currently using that license. Each user line also prints out a vXY, and it can be the same or different than the corresponding license above. For example MATLAB v51 could have a user with v37. I’m just wondering what this v number means. Does it correspond to a MATLAB version somehow? If not, is there other information in the output that would tell me a users version? I am trying to make a tool to help my company organize our MATLAB license use. Currently I am using the command "lmutil lmstat -a -c <license server>" and I’m just parsing the string output. The command prints out each type of license we have such as MATLAB, SIMULINK, etc. then within each license section it prints information about the license for a certain block of users in a nodelocked or floating license. I’m guessing this is grouped by location like IP addresses of the same location or something similar. Within this information, right next to the license type it prints v51 or v46 or some 2 digit number. For example the section starts with MATLAB v51. Then below that section it prints information about each user currently using that license. Each user line also prints out a vXY, and it can be the same or different than the corresponding license above. For example MATLAB v51 could have a user with v37. I’m just wondering what this v number means. Does it correspond to a MATLAB version somehow? If not, is there other information in the output that would tell me a users version? license manager MATLAB Answers — New Questions
Clearly Identifying circular regions on a chip in a noisy environment
Hey everyone
As the summary suggests, I have been working with chip images in hopes of clearly identifying the circles via pre-processing so that I can binarize the image and use regionprops on them afterwards. I haven’t had much success and any help would be much appreciated. I have shared some photos that I am working with that should help!
My current algorithm is very slow but also not very good at identification.Hey everyone
As the summary suggests, I have been working with chip images in hopes of clearly identifying the circles via pre-processing so that I can binarize the image and use regionprops on them afterwards. I haven’t had much success and any help would be much appreciated. I have shared some photos that I am working with that should help!
My current algorithm is very slow but also not very good at identification. Hey everyone
As the summary suggests, I have been working with chip images in hopes of clearly identifying the circles via pre-processing so that I can binarize the image and use regionprops on them afterwards. I haven’t had much success and any help would be much appreciated. I have shared some photos that I am working with that should help!
My current algorithm is very slow but also not very good at identification. image processing, image segmentation, image analyst MATLAB Answers — New Questions
How can I use a custom board with the Zynq workflow provided by MATLAB/Simulink?
MathWorks offers an integrated workflow for targeting the Zynq platform using HDL Coder and Embedded Coder.
https://www.mathworks.com/help/hdlcoder/ug/getting-started-with-hardware-software-codesign-workflow-for-xilinx-zynq-platform.html
The currently supported boards are Zedboard, ZC702, ZC706, ZCU102.
However, I am using a board based on Zynq that is not supported by MathWorks (e.g. MicroZed, PicoZed, Arty), or a completely custom-made board. How can I use a custom board with the Zynq workflow provided by MATLAB/Simulink?
MathWorks offers an integrated workflow for targeting the Zynq platform using HDL Coder and Embedded Coder.
https://www.mathworks.com/help/hdlcoder/ug/getting-started-with-hardware-software-codesign-workflow-for-xilinx-zynq-platform.html
The currently supported boards are Zedboard, ZC702, ZC706, ZCU102.
However, I am using a board based on Zynq that is not supported by MathWorks (e.g. MicroZed, PicoZed, Arty), or a completely custom-made board. How can I use a custom board with the Zynq workflow provided by MATLAB/Simulink?
MathWorks offers an integrated workflow for targeting the Zynq platform using HDL Coder and Embedded Coder.
https://www.mathworks.com/help/hdlcoder/ug/getting-started-with-hardware-software-codesign-workflow-for-xilinx-zynq-platform.html
The currently supported boards are Zedboard, ZC702, ZC706, ZCU102.
However, I am using a board based on Zynq that is not supported by MathWorks (e.g. MicroZed, PicoZed, Arty), or a completely custom-made board. How can I use a custom board with the Zynq workflow provided by MATLAB/Simulink?
custom, board, soc, workflow, hardware, software, hw/sw, codesign, co-design, hdl, coder, zynq, xilinx, zynq-7000, all, programmable, blockset MATLAB Answers — New Questions
How to fix QuickBook Error 12007 after update?
How can I resolve QuickBook Error 12007? I encounter this error during software updates, and it seems to be related to network issues. What are the steps to troubleshoot and fix this problem?
How can I resolve QuickBook Error 12007? I encounter this error during software updates, and it seems to be related to network issues. What are the steps to troubleshoot and fix this problem? Read More
autofill column only when data are added
I have a column (Column C) that calculates a formula based on the entry in another column (Column B). The spreadsheet will be used by other users. The issue is that I do not know how many entries any particular user will have. They may have 20 or they may have 200 or they may have 2000. I do not want to autofill the entire column with the formula because (a) it slows everything down, (b) it is ugly/not user-friendly (displaying #DIV/0! until the column it needs is filled, and (c) it can actually end up affecting the results. I’ve seen another sheet that does the same thing. For example, there are 22 entries right now. Cell B24 and C24 are currently blank – no formula is showing for cell C24. If I add a number to B24, then C24 auto-populates the formula and calculates it. I cannot figure out how to make my spreadsheet do that, despite much searching and exploration. I’ve tried various fill options, an arrayfunction, a table, and I haven’t yet found a solution that work. Any help is appreciated!
I have a column (Column C) that calculates a formula based on the entry in another column (Column B). The spreadsheet will be used by other users. The issue is that I do not know how many entries any particular user will have. They may have 20 or they may have 200 or they may have 2000. I do not want to autofill the entire column with the formula because (a) it slows everything down, (b) it is ugly/not user-friendly (displaying #DIV/0! until the column it needs is filled, and (c) it can actually end up affecting the results. I’ve seen another sheet that does the same thing. For example, there are 22 entries right now. Cell B24 and C24 are currently blank – no formula is showing for cell C24. If I add a number to B24, then C24 auto-populates the formula and calculates it. I cannot figure out how to make my spreadsheet do that, despite much searching and exploration. I’ve tried various fill options, an arrayfunction, a table, and I haven’t yet found a solution that work. Any help is appreciated! Read More
Is there any data on how much energy does the power saving settings achieve?
I’m working on a emission footprint reduction project and one topic that came to mind was about the power saving recommendations from Windows.
I’ve tried to gather data on the percentages but with no success.
Does anyone have any firm and reliable info on that?
Thank you.
I’m working on a emission footprint reduction project and one topic that came to mind was about the power saving recommendations from Windows. I’ve tried to gather data on the percentages but with no success. Does anyone have any firm and reliable info on that? Thank you. Read More
Accessing Web Content – Consistent Login Requests
Hi all
Hope you are well and can maybe understand this one.
In my workplace, I have a master spreadsheet that needs to be “queried” from another spreadsheet.
The way I gone about this is using the “web content” function.
The master spreadsheet is located on my OneDrive and I have shared / allowed access to all my colleagues who need to access the data via another spreadsheet.
I have then in the end user spreadsheet made a data connection to the Sharepoint URL of the master spreadsheet. All the relevant sheets are imported and updated perfectly upon opening.
However, despite me setting the web content method as “Organizational Account”, randomly and frequently the attached error is being shown to my colleagues when opening the end user spreadsheet.
They then have to click “Organizational account” > “Sign in” > Connect.
This works most of the time, other times it just refuses and repeats the message attached.
Is there a better way of linking my OneDrive master spreadsheet to the end user one? Or is there any advice on how to fix this error? Changing the “level to apply settings to” sometimes works, other times does not. I am unsure why excel is constantly not being able to access my OneDrive master file.
Your support would be most appreciated
Thanks
Matt
Hi allHope you are well and can maybe understand this one. In my workplace, I have a master spreadsheet that needs to be “queried” from another spreadsheet. The way I gone about this is using the “web content” function. The master spreadsheet is located on my OneDrive and I have shared / allowed access to all my colleagues who need to access the data via another spreadsheet. I have then in the end user spreadsheet made a data connection to the Sharepoint URL of the master spreadsheet. All the relevant sheets are imported and updated perfectly upon opening. However, despite me setting the web content method as “Organizational Account”, randomly and frequently the attached error is being shown to my colleagues when opening the end user spreadsheet.They then have to click “Organizational account” > “Sign in” > Connect.This works most of the time, other times it just refuses and repeats the message attached. Is there a better way of linking my OneDrive master spreadsheet to the end user one? Or is there any advice on how to fix this error? Changing the “level to apply settings to” sometimes works, other times does not. I am unsure why excel is constantly not being able to access my OneDrive master file. Your support would be most appreciated Thanks Matt Read More
Microsoft AVD Authentication Timeout
Is there some sort of microsoft timeout for login.microsoftonline.com where the token expires? We’re utilizing Dell ThinOS thin clients and in WMS I have the broker set to Azure AVD.
When this is applied to the thin client, immediately a microsoft login box pops up over the Dell Login UI. If no user enters credentials in that login window for a while (I believe it’s 30-60min), the next person who tries to login receives the following message “Sorry, your sign-in timed out. Please sign in again.” It doesn’t say the credentials are invalid (because they aren’t) it just doesn’t successfully authenticate. At this point it does show our tenants custom background..
At that point the user can type their credentials in again and it successfully authenticates them. My worry is that we’ll have this happen to the first user who logs into each thin client every single morning and throughout the day as the thin clients set idle.
There aren’t many options you can set for the Azure broker. I was wondering if anyone else has come across this and has a potential solution? Something to note is I’m also experiencing this from a web browser outside of utilizing a thin client across different tenants.
Is there some sort of microsoft timeout for login.microsoftonline.com where the token expires? We’re utilizing Dell ThinOS thin clients and in WMS I have the broker set to Azure AVD. When this is applied to the thin client, immediately a microsoft login box pops up over the Dell Login UI. If no user enters credentials in that login window for a while (I believe it’s 30-60min), the next person who tries to login receives the following message “Sorry, your sign-in timed out. Please sign in again.” It doesn’t say the credentials are invalid (because they aren’t) it just doesn’t successfully authenticate. At this point it does show our tenants custom background.. At that point the user can type their credentials in again and it successfully authenticates them. My worry is that we’ll have this happen to the first user who logs into each thin client every single morning and throughout the day as the thin clients set idle. There aren’t many options you can set for the Azure broker. I was wondering if anyone else has come across this and has a potential solution? Something to note is I’m also experiencing this from a web browser outside of utilizing a thin client across different tenants. Read More
How to do OQPSK Demodulation in MATLAB 2020b without using inbuilt block?
I want to do modulation classification among OQPSK and QPSK. For that I require downsampled constellation (samples per symbol=1) of OQPSK. I am unable to get that in the comm.OQPSKModulator and comm.OQPSKDemodulator block of MATLAB 2020b. So I modulated the signal on my own by following steps:
a. Split bits to odd (I) and even (Q)
b. Filter both I & Q streams, e.g., with raised-cosine or half-sine filtering
c. Delay the even-bit stream (Q) by half a simple and make a complex waveform I + j*Q
Now I want to demodulate it. Please tell me the correct steps so that I can get downsampled constellation before demodulation.I want to do modulation classification among OQPSK and QPSK. For that I require downsampled constellation (samples per symbol=1) of OQPSK. I am unable to get that in the comm.OQPSKModulator and comm.OQPSKDemodulator block of MATLAB 2020b. So I modulated the signal on my own by following steps:
a. Split bits to odd (I) and even (Q)
b. Filter both I & Q streams, e.g., with raised-cosine or half-sine filtering
c. Delay the even-bit stream (Q) by half a simple and make a complex waveform I + j*Q
Now I want to demodulate it. Please tell me the correct steps so that I can get downsampled constellation before demodulation. I want to do modulation classification among OQPSK and QPSK. For that I require downsampled constellation (samples per symbol=1) of OQPSK. I am unable to get that in the comm.OQPSKModulator and comm.OQPSKDemodulator block of MATLAB 2020b. So I modulated the signal on my own by following steps:
a. Split bits to odd (I) and even (Q)
b. Filter both I & Q streams, e.g., with raised-cosine or half-sine filtering
c. Delay the even-bit stream (Q) by half a simple and make a complex waveform I + j*Q
Now I want to demodulate it. Please tell me the correct steps so that I can get downsampled constellation before demodulation. oqpsk, demodulation, offset qpsk, modulation, modulation classification MATLAB Answers — New Questions
How to create a Vector of Parameter Objects from a Simulink Model?
I am trying to create a Dual Polarisation Battery Model on simulink. I am using the Optimization Toolbox to create an experiment to run a cost function to determine parameters for my model. My model has initial parameters, which are defined in my code but I am unable to run my cost function. I am also using the sdo.optimize to run my code. Part of my code can be seen below:
open_system("BatteryModel.slx");
load("OutputCurrent.mat");
load("OutputVoltage.mat");
V_Out = OutputVoltage.Data;
I_In = OutputCurrent.Data;
time = OutputVoltage.Time;
experiment = sdo.Experiment(‘BattteryModel’);
input = Simulink.SimulationData.Signal;
input.Name = ‘HPPC Input Signal’;
input.Values = timeseries(I_In, time);
experiment.InputData = input;
output = Simulink.SimulationsData.Signal;
output.Name = ‘Output Voltage’;
output.Values = timeseries(V_Out, time);
experiment.OutputData = output;
R0_initial = param.Continuous(‘R0’ 0.01);
R1_initial = param.Continuous(‘R1’ 0.02);
R2_initial = param.Comtinuous(‘R2’, 0.1);
C1_initial = param.Continuous(‘C1’, 500);
C2_initial = param.Continuous(‘C2’, 1000);
params = [R0_initial, R1_initial, R2_initial, C1_initial, C2_initial];
opt = sdo.OptimizeOptions;
opt.Method = ‘lsqnonlin’;
[est_params, info] = sdo.optimize(@(p) costFunction(p, experiment), params, opt);
The circuit I am using can be seen below:I am trying to create a Dual Polarisation Battery Model on simulink. I am using the Optimization Toolbox to create an experiment to run a cost function to determine parameters for my model. My model has initial parameters, which are defined in my code but I am unable to run my cost function. I am also using the sdo.optimize to run my code. Part of my code can be seen below:
open_system("BatteryModel.slx");
load("OutputCurrent.mat");
load("OutputVoltage.mat");
V_Out = OutputVoltage.Data;
I_In = OutputCurrent.Data;
time = OutputVoltage.Time;
experiment = sdo.Experiment(‘BattteryModel’);
input = Simulink.SimulationData.Signal;
input.Name = ‘HPPC Input Signal’;
input.Values = timeseries(I_In, time);
experiment.InputData = input;
output = Simulink.SimulationsData.Signal;
output.Name = ‘Output Voltage’;
output.Values = timeseries(V_Out, time);
experiment.OutputData = output;
R0_initial = param.Continuous(‘R0’ 0.01);
R1_initial = param.Continuous(‘R1’ 0.02);
R2_initial = param.Comtinuous(‘R2’, 0.1);
C1_initial = param.Continuous(‘C1’, 500);
C2_initial = param.Continuous(‘C2’, 1000);
params = [R0_initial, R1_initial, R2_initial, C1_initial, C2_initial];
opt = sdo.OptimizeOptions;
opt.Method = ‘lsqnonlin’;
[est_params, info] = sdo.optimize(@(p) costFunction(p, experiment), params, opt);
The circuit I am using can be seen below: I am trying to create a Dual Polarisation Battery Model on simulink. I am using the Optimization Toolbox to create an experiment to run a cost function to determine parameters for my model. My model has initial parameters, which are defined in my code but I am unable to run my cost function. I am also using the sdo.optimize to run my code. Part of my code can be seen below:
open_system("BatteryModel.slx");
load("OutputCurrent.mat");
load("OutputVoltage.mat");
V_Out = OutputVoltage.Data;
I_In = OutputCurrent.Data;
time = OutputVoltage.Time;
experiment = sdo.Experiment(‘BattteryModel’);
input = Simulink.SimulationData.Signal;
input.Name = ‘HPPC Input Signal’;
input.Values = timeseries(I_In, time);
experiment.InputData = input;
output = Simulink.SimulationsData.Signal;
output.Name = ‘Output Voltage’;
output.Values = timeseries(V_Out, time);
experiment.OutputData = output;
R0_initial = param.Continuous(‘R0’ 0.01);
R1_initial = param.Continuous(‘R1’ 0.02);
R2_initial = param.Comtinuous(‘R2’, 0.1);
C1_initial = param.Continuous(‘C1’, 500);
C2_initial = param.Continuous(‘C2’, 1000);
params = [R0_initial, R1_initial, R2_initial, C1_initial, C2_initial];
opt = sdo.OptimizeOptions;
opt.Method = ‘lsqnonlin’;
[est_params, info] = sdo.optimize(@(p) costFunction(p, experiment), params, opt);
The circuit I am using can be seen below: optimization, help, costfunction, simulink, matlab MATLAB Answers — New Questions
Unexpected prompt characters on command line output
I am running MATLAB from command line using the following command on a linux system
$ matlab -nojvm -nodisplay < main.m
The command line ouput contains unexpected prompt characters (">>") at the beginning of the ouptut. The expected output, which is obtianed when running the code in the MATLAB command window is
>> main
Dimension 1: Range = [-9.93,9.93]
Dimension 2: Range = [-9.93,9.93]
Dimension 3: Range = [-9.93,9.93]
Size of a: 15180
Size of b: 32509
However, when run from the command line, the output looks like
$ matlab -nodisplay -nojvm < Collocate.m
< M A T L A B (R) >
Copyright 1984-2023 The MathWorks, Inc.
R2023b Update 5 (23.2.0.2459199) 64-bit (glnxa64)
November 28, 2023
For online documentation, see https://www.mathworks.com/support
For product information, visit www.mathworks.com.
>> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>>>>>>>Dimension 1: Range = [-9.93,9.93]
Dimension 2: Range = [-9.93,9.93]
Dimension 3: Range = [-9.93,9.93]
>> >> >> >> >> >> Size of a: 15180
>> Size of b: 32509
And keeps going on for a few more lines. I can’t understand where the prompt symbols ">>" come from. Is there any way of getting rid of these?I am running MATLAB from command line using the following command on a linux system
$ matlab -nojvm -nodisplay < main.m
The command line ouput contains unexpected prompt characters (">>") at the beginning of the ouptut. The expected output, which is obtianed when running the code in the MATLAB command window is
>> main
Dimension 1: Range = [-9.93,9.93]
Dimension 2: Range = [-9.93,9.93]
Dimension 3: Range = [-9.93,9.93]
Size of a: 15180
Size of b: 32509
However, when run from the command line, the output looks like
$ matlab -nodisplay -nojvm < Collocate.m
< M A T L A B (R) >
Copyright 1984-2023 The MathWorks, Inc.
R2023b Update 5 (23.2.0.2459199) 64-bit (glnxa64)
November 28, 2023
For online documentation, see https://www.mathworks.com/support
For product information, visit www.mathworks.com.
>> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>>>>>>>Dimension 1: Range = [-9.93,9.93]
Dimension 2: Range = [-9.93,9.93]
Dimension 3: Range = [-9.93,9.93]
>> >> >> >> >> >> Size of a: 15180
>> Size of b: 32509
And keeps going on for a few more lines. I can’t understand where the prompt symbols ">>" come from. Is there any way of getting rid of these? I am running MATLAB from command line using the following command on a linux system
$ matlab -nojvm -nodisplay < main.m
The command line ouput contains unexpected prompt characters (">>") at the beginning of the ouptut. The expected output, which is obtianed when running the code in the MATLAB command window is
>> main
Dimension 1: Range = [-9.93,9.93]
Dimension 2: Range = [-9.93,9.93]
Dimension 3: Range = [-9.93,9.93]
Size of a: 15180
Size of b: 32509
However, when run from the command line, the output looks like
$ matlab -nodisplay -nojvm < Collocate.m
< M A T L A B (R) >
Copyright 1984-2023 The MathWorks, Inc.
R2023b Update 5 (23.2.0.2459199) 64-bit (glnxa64)
November 28, 2023
For online documentation, see https://www.mathworks.com/support
For product information, visit www.mathworks.com.
>> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>>>>>>>Dimension 1: Range = [-9.93,9.93]
Dimension 2: Range = [-9.93,9.93]
Dimension 3: Range = [-9.93,9.93]
>> >> >> >> >> >> Size of a: 15180
>> Size of b: 32509
And keeps going on for a few more lines. I can’t understand where the prompt symbols ">>" come from. Is there any way of getting rid of these? output, system, print MATLAB Answers — New Questions
Managing Multiple Projects in One Workspace with a Client
I have searched online for this and have yet to find a best practice within Teams
Scenario:
1. We have created a TEAM’s workspace for a client and our internal team
2. We have three projects that we will be executing for the client with different team members in each project (but they all need to have access to the workspace – especially leadership)
Do I:
1. Create 3 separate workspaces? –> but then this does not address item 2 without a great deal of redundancy and possible loss of sight
2. Do I create 3 separate channels for each? but do the channels get too heavy with information since I cannot create children channels off of it?
Any suggestions/best practices would be most appreciated – thanks
I have searched online for this and have yet to find a best practice within TeamsScenario:1. We have created a TEAM’s workspace for a client and our internal team2. We have three projects that we will be executing for the client with different team members in each project (but they all need to have access to the workspace – especially leadership)Do I:1. Create 3 separate workspaces? –> but then this does not address item 2 without a great deal of redundancy and possible loss of sight2. Do I create 3 separate channels for each? but do the channels get too heavy with information since I cannot create children channels off of it? Any suggestions/best practices would be most appreciated – thanks Read More
How to format cells so 4 digits changes to time format with colon automatically?
For example, I want to be able to type the time as 0502 and it automatically changes to 05:02
Thanks for your help
For example, I want to be able to type the time as 0502 and it automatically changes to 05:02 Thanks for your help Read More
رقم شيخ روحاني حقيقي 00447312218463 واتس اب – السعودية – معتصم الطوخي
رقم شيخ روحاني حقيقي // ٠٠٤٤٧٣١٢٢١٨٤٦٣ // واتس اب – السعودية – معتصم الطوخي
i have the same problem thats @Adm34 has, and dose’nt solved.
I’m a heavy OneDrive user and this issue happens when I delete and move too many large files at the same time. It happens شيخ روحاني every quarter when I start moving files from one of my OneDrive accounts to my other corporate One Drive account. medium.com
I normally delete and change the file names to correct it. This time, however, I was changing too many GB with OneDrive at the same time at the sync issues are happening at the main folder level and I don’t want to use “Disable file on demand” جلب الحبيب because I have too many GB purposely not on my computer. But given that I can only change the file name online (I can’t change the file folders on my computer), this may be the only way. I’ll post what happens …
رقم شيخ روحاني حقيقي // ٠٠٤٤٧٣١٢٢١٨٤٦٣ // واتس اب – السعودية – معتصم الطوخيi have the same problem thats @Adm34 has, and dose’nt solved.I’m a heavy OneDrive user and this issue happens when I delete and move too many large files at the same time. It happens شيخ روحاني every quarter when I start moving files from one of my OneDrive accounts to my other corporate One Drive account. medium.com I normally delete and change the file names to correct it. This time, however, I was changing too many GB with OneDrive at the same time at the sync issues are happening at the main folder level and I don’t want to use “Disable file on demand” جلب الحبيب because I have too many GB purposely not on my computer. But given that I can only change the file name online (I can’t change the file folders on my computer), this may be the only way. I’ll post what happens … Read More
Total Project Progress % Report & S-Curve Report (E, P, C, C) – MS Project 2019 (Desktop)
Hi All,
This thread is a two part question. The Schedule does not contain any resources, this is purely task driven (Dates & Duration). The client is essentially looking to establish what we had planned and where we actually are within the project (Progress % wise).
1) Generate a Total Project Progress % Report (Example in 1. Total Project Progress %.pdf)
2) Generate an S-Curve Report using the items displayed in the graph axis (Example in 2. EPCC Report.pdf)
INFO before I begin: EPCC contract type (Engineering, Procurement, Construction & Commissioning) it’s a special type of contract, where the Contractor is responsible for all activities for design, procurement, construction, testing and commissioning and also delivery to the end user / customer.
What information and assistance I am looking for from this wonderful community:
1) Generate a Total Project Progress % Report → I have typed out what all is being shown in the PDF. I would like to understand what each item represents as well as how and where to find these items and/or how to create custom fields to show this information as well as if this report would be built within MS Project 2019 or generated through a Visual Report:
Please refer to: 1. Total Project Progress %.pdf
a) Cumulated Late Planned %
b) Cumulated Actual %
c) Cumulated Difference % (Difference between a & b, this you can ignore, fairly straight forward)
d) This Period Late Planned %
e) This Period Actual %
f) This Period Difference % (Difference between d & e, this you can ignore, fairly straight forward)
2) Generate an S-Curve Report → Once again, I have typed out what all data the report is using to display the S-Curve Report. Once again, I would like to understand what each item represents as well as how and where to find these items and/or how to create custom fields to show this information as well as if this report would be built within MS Project 2019 or generated through a Visual Report:
a) Actual % → I believe the is the % Complete field, correct?
b) Cumulative Baseline Early %
c) Cumulative Baseline Late %
d) Cumulative Forecast Early %
e) Cumulative Forecast Late %
Over and above that, I would assume this S-Curve would be a Visual Report as it shows a graph axis of the %, would I be correct in saying this?
Thanking you all in advance.
Hi All, This thread is a two part question. The Schedule does not contain any resources, this is purely task driven (Dates & Duration). The client is essentially looking to establish what we had planned and where we actually are within the project (Progress % wise). 1) Generate a Total Project Progress % Report (Example in 1. Total Project Progress %.pdf)2) Generate an S-Curve Report using the items displayed in the graph axis (Example in 2. EPCC Report.pdf) INFO before I begin: EPCC contract type (Engineering, Procurement, Construction & Commissioning) it’s a special type of contract, where the Contractor is responsible for all activities for design, procurement, construction, testing and commissioning and also delivery to the end user / customer. What information and assistance I am looking for from this wonderful community: 1) Generate a Total Project Progress % Report → I have typed out what all is being shown in the PDF. I would like to understand what each item represents as well as how and where to find these items and/or how to create custom fields to show this information as well as if this report would be built within MS Project 2019 or generated through a Visual Report: Please refer to: 1. Total Project Progress %.pdf a) Cumulated Late Planned %b) Cumulated Actual %c) Cumulated Difference % (Difference between a & b, this you can ignore, fairly straight forward)d) This Period Late Planned %e) This Period Actual %f) This Period Difference % (Difference between d & e, this you can ignore, fairly straight forward) 2) Generate an S-Curve Report → Once again, I have typed out what all data the report is using to display the S-Curve Report. Once again, I would like to understand what each item represents as well as how and where to find these items and/or how to create custom fields to show this information as well as if this report would be built within MS Project 2019 or generated through a Visual Report: a) Actual % → I believe the is the % Complete field, correct?b) Cumulative Baseline Early %c) Cumulative Baseline Late %d) Cumulative Forecast Early %e) Cumulative Forecast Late % Over and above that, I would assume this S-Curve would be a Visual Report as it shows a graph axis of the %, would I be correct in saying this? Thanking you all in advance. Read More
Set sequence possible?
Good day friends,
I am creating an excel sheet to document our PAT testing.
What I need is the ability to go from, for example:
A101-01-01
A101-01-02
A101-01-03
A101-01-04
then
A101-02-01
A101-02-02
A101-02-03
A101-02-04
etc etc without having to type EVERY single one.
Can any of you big brains/experts help?
Many thanks in advance,
Paul
Good day friends, I am creating an excel sheet to document our PAT testing.What I need is the ability to go from, for example:A101-01-01A101-01-02A101-01-03A101-01-04thenA101-02-01A101-02-02A101-02-03A101-02-04 etc etc without having to type EVERY single one.Can any of you big brains/experts help?Many thanks in advance,Paul Read More
