Month: July 2024
Pick Lists – Data Validation
Hello!
I want to be able to create a pick list which if chosen populates a number of columns with key information.
It’s for a recipe template I am doing so when I pick an ingredient, I want it to complete other columns about that ingredient – nutritional data, pricing etc
I can only seem to use Data Validation to fill in one column.
Can anyone help?
Hello!I want to be able to create a pick list which if chosen populates a number of columns with key information.It’s for a recipe template I am doing so when I pick an ingredient, I want it to complete other columns about that ingredient – nutritional data, pricing etcI can only seem to use Data Validation to fill in one column.Can anyone help? Read More
Using Bookings to assign staffing and rooms
Hi all,
I am trying to set up a bookings page which would involve 1 staff member (representing a whole team on a rota) as well as 2 available room spaces which have been set up as “staff” identities so we can have a calendar for them.
What I need to be able to do is set up a service which will search the staff member’s calendar for availability and then look to see if either of the two rooms is available.
I have puzzled over this for a while and can’t see that there is a workaround as such that will allow me to have a staff and either of the two rooms together as a bookable entity. It would just have to be the staff member and room 1 and then another service with the staff member and room 2.
This could get really confusing for end users as they are going to have to look at two different services to see if appointments are available.
Can anyone see a fix I have missed please?
Hi all,I am trying to set up a bookings page which would involve 1 staff member (representing a whole team on a rota) as well as 2 available room spaces which have been set up as “staff” identities so we can have a calendar for them.What I need to be able to do is set up a service which will search the staff member’s calendar for availability and then look to see if either of the two rooms is available. I have puzzled over this for a while and can’t see that there is a workaround as such that will allow me to have a staff and either of the two rooms together as a bookable entity. It would just have to be the staff member and room 1 and then another service with the staff member and room 2. This could get really confusing for end users as they are going to have to look at two different services to see if appointments are available.Can anyone see a fix I have missed please? Read More
Copilot in Outlook – ‘Sound like me’ tone is missing in both new and classic outlook
In this short video it shows a tone ‘Sound like me’. This is missing in our menu, how do I enable this option? Draft an email message with Copilot in Outlook – Microsoft Support.
From video
From my computer:
In this short video it shows a tone ‘Sound like me’. This is missing in our menu, how do I enable this option? Draft an email message with Copilot in Outlook – Microsoft Support.From videoFrom my computer: Read More
SharePoint SOAP endpoints not accessible with OAuth2 authentication
Hi Developers,
As Microsoft has now enabled the new feature Enable Security Defaults with Microsoft Entra ID, we are facing issues in accessing the SOAP endpoints for SharePoint online. To resolve this issues we have been trying to move an existing code with SAML authentication to access SOAP endpoints to OAuth2 but I after getting the access token from OAuth2 & passing it as a header to SOAP endpoints it is giving an error as 401-Unauthorized. For this problem I have used below details for OAuth2
1. Registered the App on Azure Active directory.
2. Given necessary application & delegated permissions to app.
3. Added delegated permission for Microsoft Graph API.
4. Used scope value as “openid offline_access https://your-domain-name.sharepoint.com/.default“
5. Used endpoint as “https://your-domain-name.sharepoint.com/sites/site-name/_vti_bin/webs.asmx“
When we set scope value “https://graph.microsoft.com/.default” to generate access token, it gives error as 403-Forbidden.
When we disable the Security Defaults feature or enable the conditional access with P1 license the same code works fine.
Any assistance for this issue will be of a great help.
Thanks in advance!!!
Hi Developers, As Microsoft has now enabled the new feature Enable Security Defaults with Microsoft Entra ID, we are facing issues in accessing the SOAP endpoints for SharePoint online. To resolve this issues we have been trying to move an existing code with SAML authentication to access SOAP endpoints to OAuth2 but I after getting the access token from OAuth2 & passing it as a header to SOAP endpoints it is giving an error as 401-Unauthorized. For this problem I have used below details for OAuth21. Registered the App on Azure Active directory.2. Given necessary application & delegated permissions to app.3. Added delegated permission for Microsoft Graph API.4. Used scope value as “openid offline_access https://your-domain-name.sharepoint.com/.default”5. Used endpoint as “https://your-domain-name.sharepoint.com/sites/site-name/_vti_bin/webs.asmx” When we set scope value “https://graph.microsoft.com/.default” to generate access token, it gives error as 403-Forbidden.When we disable the Security Defaults feature or enable the conditional access with P1 license the same code works fine. Any assistance for this issue will be of a great help. Thanks in advance!!! Read More
Records Management vs Data Life Cycle Management
Hello Members,
What is the difference between Records management and Data Lifecycle management?
Hello Members, What is the difference between Records management and Data Lifecycle management? Read More
How can I remove all the names of cells without screws the spreadsheet?
Hi masters,
I wanna remove all the names I’ve configurated converting on referral of cells. My spreadsheet has a lot names and needs to be more clean again. If I just remove all the names in Names Manager screws all the spreadsheet with #REF.
Tks in advance!
Hi masters, I wanna remove all the names I’ve configurated converting on referral of cells. My spreadsheet has a lot names and needs to be more clean again. If I just remove all the names in Names Manager screws all the spreadsheet with #REF. Tks in advance! Read More
Bookings is duplicating the group appointments
When attendees are registering to a booking group appointment through reservation page – instead of creating one group appointment and adding attendees to it – Booking is duplicating 1:1 meetings. This way the appointment is still available to the same number of people, although we have more and more single reservations. This bug seems to be new – about week ago it was all working properly. Is it global issue? Can you solve this or give a hint how to work with it?
Major impact and urgency
When attendees are registering to a booking group appointment through reservation page – instead of creating one group appointment and adding attendees to it – Booking is duplicating 1:1 meetings. This way the appointment is still available to the same number of people, although we have more and more single reservations. This bug seems to be new – about week ago it was all working properly. Is it global issue? Can you solve this or give a hint how to work with it?Major impact and urgency Read More
New on Azure Marketplace: June 27-30, 2024
We continue to expand the Azure Marketplace ecosystem. For this volume, 90 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
AI Copilot: Aisera’s AI Copilot assistant boosts productivity by answering questions, analyzing data, and completing tasks. It uses domain-specific large language models and offers customizable prompts. AI Copilot has more than 3,000 prebuilt and customizable AI workflows and more than 500 out-of-the-box connectors to enterprise SaaS applications.
AI Search: Aisera’s AI Search allows for enterprise-wide searches using natural language, generating results based on user preferences and permissions while maintaining security and privacy. Aisera has deep integrations with Microsoft SharePoint, Microsoft Azure, Azure OpenAl Service, Copilot for Microsoft 365, Microsoft Fabric, Microsoft 365, and Microsoft Graph.
AtomEngine: AtomEngine is a cloud game engine that can simulate scenarios as large as a planet or as small as a single vehicle. It is used for logistics, energy networks, urban planning, disaster response, and more. Users can create scenarios using its integrated library of world content and real-world phenomena.
Celonis Platform Connector for Power BI: The Celonis Platform Connector for Microsoft Power BI allows you to link Power BI with your Celonis Platform Instance. As a result, you can embed process intelligence produced by the Celonis Platform into Power BI to enhance reporting with insightful process knowledge. Define records in process query language inside knowledge models and load them into Power BI.
Cordova: This offer from ATH Infosystems provides Cordova with Ubuntu 20.04 on a Microsoft Azure virtual machine. Cordova is a framework that enables developers to build mobile apps using HTML5, CSS3, and JavaScript. Apps can be deployed across multiple platforms with a single codebase.
DocLens AI Studio: DocLens is an AI-driven solution that analyzes documents and produces field-specific, role-based summaries, enhancing efficiency and comprehension. These smart summaries ensure that users can quickly grasp the essence of lengthy documents, saving hours.
EBS – Enterprise Blockchain as a Service by BBChain: EBS is a SaaS platform for creating and managing blockchain networks. EBS offers governance, security, and scalability, allowing for the rapid launch of minimum viable products and cost-effective scaling. It is cloud-native, API-first, and offers a grow-on-your-own-terms model with no lock-in. This offer is available only in Portuguese.
Encoding and Playback – Enterprise: Bitmovin’s Encoding and Playback products enable reliable video content delivery to global audiences. The products can be used individually or combined for maximum benefit. Features include live encoding, VOD encoding, and playback with integrations for automated testing and performance analytics. Bitmovin offers API libraries and an easy-to-use UI, and volume discounts are available through a private offer.
Gibbon: This offer from ATH Infosystems provides Gibbon with Ubuntu 20.04 on a Microsoft Azure virtual machine. Gibbon is an open-source school management platform with features like class scheduling, attendance tracking, a grade book, assessment management, and reporting.
Honeycomb Enterprise: Honeycomb is an observability platform for cloud-native apps that abets troubleshooting by drilling down to the individual user level. Its event-based telemetry model and powerful query engine enable engineering teams to debug application performance in even the most complex app stacks.
LionGuard File Encryption Software: LionGuard is a desktop application that uses AES-256 encryption to protect sensitive files from cyber threats. It offers swift and secure encryption and decryption processes, a history list of activities, and a simple user interface.
Minecraft Bedrock Game Server on AlmaLinux 8: This offer from Tidal Media provides a Minecraft: Bedrock Edition game server on AlmaLinux 8. Enjoy a seamless and immersive multiplayer experience for Minecraft across various devices. With customizable settings and features, players can enjoy a peaceful building experience or an action-packed survival challenge.
Minecraft Bedrock Game Server on AlmaLinux 9: This offer from Tidal Media provides a Minecraft: Bedrock Edition game server on AlmaLinux 9. Enjoy a seamless and immersive multiplayer experience for Minecraft across various devices.
Minecraft Bedrock Game Server on Rocky 8: This offer from Tidal Media provides a Minecraft: Bedrock Edition game server on Rocky Linux 8. Enjoy stable performance, customization options, scalability, security features, and community collaboration.
Minecraft Bedrock Game Server on Rocky 9: This offer from Tidal Media provides a Minecraft: Bedrock Edition game server on Rocky Linux 9. Enjoy stable performance, customization options, scalability, security features, and community collaboration.
OnID Transactional Biometric Security Platform: OnID from Onboarding & Identification SL is a platform for user onboarding, identification, and authentication that incorporates biometric validation, document verification, and proof-of-life measures (facial recognition or fingerprint recognition). It caters to banking, national ID systems, and online communities.
ownCloud: This offer from ATH Infosystems provides ownCloud with Ubuntu 20.04 on a Microsoft Azure virtual machine. ownCloud is an open-source file-sharing server that lets you to store and access your data from any device. It’s a robust alternative to proprietary cloud storage services and gives you extensive customization and control over your data.
Pico: This offer from ATH Infosystems provides Pico with Ubuntu 20.04 on a Microsoft Azure virtual machine. Pico is a lightweight, flat-file content management system that supports the Markdown language and uses simple text files for content storage.
SafeStack: Secure Development Training Platform: SafeStack is a secure development education platform that offers flexible online courses for software developers, testers, analysts, and architects. It provides ongoing security education programs, hands-on labs, compliance reporting, and access to a community of software development teams worldwide.
Volo SaaS: Cloud Foundations (Landing Zone and Shared Services): Volo Cloud Foundations correctly sets up cloud environments and provides the appropriate controls to make applications and environments secure, easy to operate, scalable, and cost-effective. It is aligned with Microsoft Cloud Adoption Framework (CAF) guidelines and best practices.
Go further with workshops, proofs of concept, and implementations
Azure Landing Zone Design: Enfo will design an Azure landing zone to enable creation of a well-architected, secure foundation for your cloud-based business ecosystem. An assessment will precede the design work. An infrastructure-as-code implementation is optional.
Azure Management & Optimization: Mariner’s experts will optimize your Microsoft Azure costs, maximize efficiency, and provide greater visibility into your financial landscape. With proven FinOps strategies, Mariner empowers organizations to make informed decisions and align every dollar spent with their business goals.
Decentralized Clinical Trials: Harman International Industries will deliver a proof of concept of its HCC platform powered by Microsoft Azure. The platform offers a decentralized solution for conducting clinical trials. It integrates wearables and biosensors to capture detailed insights and improve patient engagement and data accuracy.
Entra ID Onboarding Pack: 3-Month Implementation: Withum will automate Microsoft Entra ID device lifecycle management for organizations of any size. Withum can seamlessly connect Entra ID with a diverse range of human resources systems, enhancing processes and data management. Cut down on manual IT work and enhance business productivity.
Next Evolution of AI: AI-Controlled Processes: novaCapta offers packages for companies to evaluate the potential of AI agents, autonomous software entities that can communicate, act, and make decisions independently. AI agents can interact with other systems, applications, and devices through APIs. novaCapta’s AI packages can be booked directly as a bundle or one after the other. This offer is available only in German.
Nous Copilot for Security & Compliance Auditing: Nous Infosystems will deliver a proof of concept of Nous Security Copilot, an incident-response, threat-hunting, and intelligence-gathering tool that enhances an organization’s security posture. Deliverables include a basic security audit report, source code, a POC delivery report, and a road map for a comprehensive implementation plan.
Reference Data Management: Your Forces Sp. z o.o. will deliver a proof of concept of Metastudio DRM, a centrally managed solution for reference data. Metastudio DRM is commonly used in the banking and insurance sectors in Poland. It allows the management of hierarchies (organizational structures, charts of accounts), analytic dimensions (customer segmentations, product classifications), data conversion rules, and more.
UNITE: Advanced Network Support: Infinity Group will provide proactive monitoring and break-fix support for your organization’s Microsoft Azure environment and on-premises networking resources, including virtual networks and firewalls. Infinity Group follows best practices for efficient IT service management, and its centralized service desk ensures prompt troubleshooting, often resolving issues remotely with minimal impact on end users.
Contact our partners
1Password for Microsoft Sentinel
AI ShieldOps MxDR SOC Services
Attendance Recognition System – Bail Kiosk
Avanade’s IBM Cognos to Microsoft Power BI Migration
Avanade’s MicroStrategy to Microsoft Power BI Migration
Avanade’s Tableau to Microsoft Power BI Migration
Datacenter Server Core for Windows Server 2016
Datacenter Server Core for Windows Server 2019
DataParrots Query Database with Natural Languages
DISARM Content Security for Email
Genaiera: Next-Level Business App Creation with AI
Industrial Manufacturing Workflow Intelligence
Kubling Data Virtualization Engine
SUSE Enterprise 15 with Minecraft Java Game Server
SUSE Enterprise Linux 15 SP6 + 24×7 Support
SUSE Enterprise Linux 15 SP6 + Patching
SUSE Enterprise Linux 15 SP6 ARM64 + 24×7 Support
SUSE Enterprise Linux for SAP 15 SP6 + 24×7 Support
SUSE Enterprise Linux for SAP 15 SP6 Hardened + 24×7 Support
SUSE Enterprise Linux HPC 15 SP6 + 24×7 Support
SUSE Linux Enterprise Server 15 SP6 for SAP – BYOS
SUSE Linux Enterprise Server 15 SP6 for SAP – Hardened BYOS
TidyBuild: Construction Management
TidyCommerce: E-Commerce Website Builder
TidyStock: Inventory Management
TidyWork: Job and Project Management
ViewSonic SW-217 for Outlook: Meeting Room Booking Software
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More
PSCP: What is this report metric?
This is the last metric shown in Chapter 2 of generated PSCP reports. It seems to be 100% unless there is a red check.In this case, there was 1 red check out of about 100 files processed. When the red check was eliminated, the value changed to 100%. I looked through the user guide and reference docs but did not find an answer.This is the last metric shown in Chapter 2 of generated PSCP reports. It seems to be 100% unless there is a red check.In this case, there was 1 red check out of about 100 files processed. When the red check was eliminated, the value changed to 100%. I looked through the user guide and reference docs but did not find an answer. This is the last metric shown in Chapter 2 of generated PSCP reports. It seems to be 100% unless there is a red check.In this case, there was 1 red check out of about 100 files processed. When the red check was eliminated, the value changed to 100%. I looked through the user guide and reference docs but did not find an answer. polyspace, reports MATLAB Answers — New Questions
Space in a text is taken as line break in UIcontrol
I have a long string variable like this.
tex = "Date=09-Jul-2024 Delta_E=-3.3317 Delta_U=300-320V Sigma=0.094335 MaxAbs=0.00056882 MeanAbs=-0.079426 MaxRel=0.012132 eanRel=-0.9771 AllowedDeviation=0.05-0.1"
I am trying to represent this in a fig as UIcontrol using this line of code
txt_title = uicontrol(‘Style’, ‘text’, ‘String’,tex,’FontSize’,10,’Position’, [100 200 180 150]);
But space in the string variable is read as line break. Why is that, i tried removing linebreak using strtrim, erase(tex,char(10)). But nothing is working.
I need this in one line and not like this. What is the error? Thank you.I have a long string variable like this.
tex = "Date=09-Jul-2024 Delta_E=-3.3317 Delta_U=300-320V Sigma=0.094335 MaxAbs=0.00056882 MeanAbs=-0.079426 MaxRel=0.012132 eanRel=-0.9771 AllowedDeviation=0.05-0.1"
I am trying to represent this in a fig as UIcontrol using this line of code
txt_title = uicontrol(‘Style’, ‘text’, ‘String’,tex,’FontSize’,10,’Position’, [100 200 180 150]);
But space in the string variable is read as line break. Why is that, i tried removing linebreak using strtrim, erase(tex,char(10)). But nothing is working.
I need this in one line and not like this. What is the error? Thank you. I have a long string variable like this.
tex = "Date=09-Jul-2024 Delta_E=-3.3317 Delta_U=300-320V Sigma=0.094335 MaxAbs=0.00056882 MeanAbs=-0.079426 MaxRel=0.012132 eanRel=-0.9771 AllowedDeviation=0.05-0.1"
I am trying to represent this in a fig as UIcontrol using this line of code
txt_title = uicontrol(‘Style’, ‘text’, ‘String’,tex,’FontSize’,10,’Position’, [100 200 180 150]);
But space in the string variable is read as line break. Why is that, i tried removing linebreak using strtrim, erase(tex,char(10)). But nothing is working.
I need this in one line and not like this. What is the error? Thank you. matlab MATLAB Answers — New Questions
Rate Transition in If-action Subsystems
Hello,
I am trying to setup a control system with different controller operating modes. I want to handle the selectionm of the operating mode with a if-action subsystem structure. I’m getting the following error that I am not completly sure how to handle:
‘ctrlActiveHandler_0_4_sim/Axis_Control/AbsPosMode/Horizontal_Axis_Control/Rate Transition’ is a rate transition block. A rate transition block is not allowed inside the if action subsystem ‘ctrlActiveHandler_0_4_sim/Axis_Control/AbsPosMode’ unless its input or output port sample time is asynchronous sample time. Consider placing the rate transition block outside the if action subsystem.
I can’t take the rate transition outside the subsystem as it ensures integrity between to different blocks. And I am not sure about the asynchrounus sample time. Can someone explain this error and its fix?
Thank you very much.Hello,
I am trying to setup a control system with different controller operating modes. I want to handle the selectionm of the operating mode with a if-action subsystem structure. I’m getting the following error that I am not completly sure how to handle:
‘ctrlActiveHandler_0_4_sim/Axis_Control/AbsPosMode/Horizontal_Axis_Control/Rate Transition’ is a rate transition block. A rate transition block is not allowed inside the if action subsystem ‘ctrlActiveHandler_0_4_sim/Axis_Control/AbsPosMode’ unless its input or output port sample time is asynchronous sample time. Consider placing the rate transition block outside the if action subsystem.
I can’t take the rate transition outside the subsystem as it ensures integrity between to different blocks. And I am not sure about the asynchrounus sample time. Can someone explain this error and its fix?
Thank you very much. Hello,
I am trying to setup a control system with different controller operating modes. I want to handle the selectionm of the operating mode with a if-action subsystem structure. I’m getting the following error that I am not completly sure how to handle:
‘ctrlActiveHandler_0_4_sim/Axis_Control/AbsPosMode/Horizontal_Axis_Control/Rate Transition’ is a rate transition block. A rate transition block is not allowed inside the if action subsystem ‘ctrlActiveHandler_0_4_sim/Axis_Control/AbsPosMode’ unless its input or output port sample time is asynchronous sample time. Consider placing the rate transition block outside the if action subsystem.
I can’t take the rate transition outside the subsystem as it ensures integrity between to different blocks. And I am not sure about the asynchrounus sample time. Can someone explain this error and its fix?
Thank you very much. action subsystem, rate transition, asynchronous sample time MATLAB Answers — New Questions
How is ‘join on time’ calculated?
From the blurb:
Join on time rate = Join on time rate measures the percentage of Teams meetings where the person joined early or within five minutes of the meeting’s scheduled start time.
Can anyone explain exactly how ‘join on time rate’ in calculated in Viva Insights? Our current team of ~60 people is reported to be just 43% !! However, when we asked people for their individual numbers they were typically around the 85-95% region. So why is the teams ‘join on time rate’ so low?
I’d like to know the calculations and rules that are applied to make sense of this.
TIA,
robo
From the blurb:Join on time rate = Join on time rate measures the percentage of Teams meetings where the person joined early or within five minutes of the meeting’s scheduled start time. Can anyone explain exactly how ‘join on time rate’ in calculated in Viva Insights? Our current team of ~60 people is reported to be just 43% !! However, when we asked people for their individual numbers they were typically around the 85-95% region. So why is the teams ‘join on time rate’ so low? I’d like to know the calculations and rules that are applied to make sense of this. TIA,robo Read More
Cant find product when assigning user
We, recently granted a non profit service. Please tell me steps how to register and assign products.
We, recently granted a non profit service. Please tell me steps how to register and assign products. Read More
Transfer email accounts from IMAP
Hello
Please i need your help on this issue.
One of my client own a domain and he has 3 IMAP email accounts for two users plus two aliases.
He would like to migrate to Microsoft 365.
Can i know the process?
Hello Please i need your help on this issue. One of my client own a domain and he has 3 IMAP email accounts for two users plus two aliases. He would like to migrate to Microsoft 365. Can i know the process? Read More
ASR Rule Blocking ms-teams.exe
Hi,
We have seen the ASR Rule for, ‘Block Office communication application from creating child processes’ start to block ms-teams.exe, this morning which is causing quite a lot of issues in the estate.
The current workaround is to set the ASR Rule of, ‘Block Office communication application from creating child processes’, to Audit Mode instead of Block Mode.
This has also been mentioned by a couple of people now on Twitter, so is MS aware of this issue and do you know when a fix may be in place for this, so I can safely move the ASR Rule back to Block Mode
Hi, We have seen the ASR Rule for, ‘Block Office communication application from creating child processes’ start to block ms-teams.exe, this morning which is causing quite a lot of issues in the estate. The current workaround is to set the ASR Rule of, ‘Block Office communication application from creating child processes’, to Audit Mode instead of Block Mode.This has also been mentioned by a couple of people now on Twitter, so is MS aware of this issue and do you know when a fix may be in place for this, so I can safely move the ASR Rule back to Block Mode Read More
Can Microsoft Software Key Storage Provider be used on Integrated CA on Windows 2008R2?
Hi, is it possible to use “Microsoft Software Key Storage Provider” on Windows 2008R2 server?
I found instructions on how to migrate from CSP on a 2012 server, but I can’t find information whether it also applies to 2008R2.
Can anyone confirm that I can change from “Microsoft Strong Cryptographic Provider” to KSP on 2008R2.
My goal is to start using sha256RSA.
Hi, is it possible to use “Microsoft Software Key Storage Provider” on Windows 2008R2 server?I found instructions on how to migrate from CSP on a 2012 server, but I can’t find information whether it also applies to 2008R2.Can anyone confirm that I can change from “Microsoft Strong Cryptographic Provider” to KSP on 2008R2.My goal is to start using sha256RSA. Read More
error using trainNetwork Invalid training data. Responses must be a matrix of numeric responses, or a N-by-1 cell array of sequences, where N is the number of sequences
Hi
I have this following code and the data set is traffic flow that gathered every 15 seconds and I want to predict data flow but i faced an error "Invalid training data. Responses must be a matrix of numeric responses, or a N-by-1 cell array of sequences, where N is the number of sequences. The feature dimension of all sequences must be the same"and I can’t fix it can anyone help me with it
My code is :
clc
close all
clear all
warning off
[~,~,flow_data] = xlsread(‘two_days.xlsx’); % Here we have two days data
data_mat = cell2mat(flow_data(2:end,3:4));
YTrain = data_mat(:,:)’;
XTrain = data_mat(:,:)’;
%
% %
XTrain = num2cell(XTrain,1)’;
YTrain = num2cell(YTrain,1)’;
numResponses = 1 ;
% numResponses = size(YTrain{1},1);
featureDimension = size(XTrain{1},1);
numHiddenUnits = 100;
layers = [ …
sequenceInputLayer(featureDimension)
lstmLayer(numHiddenUnits)
% dropoutLayer(0.1) %%0.5
fullyConnectedLayer(numResponses)
regressionLayer];
maxepochs = 500;
miniBatchSize = 1;
options = trainingOptions(‘adam’, … %%adam
‘MaxEpochs’,maxepochs, …
‘GradientThreshold’,1, …
‘InitialLearnRate’,0.005, …
‘LearnRateSchedule’,’piecewise’, …
‘LearnRateDropPeriod’,125, …
‘LearnRateDropFactor’,0.2, …
‘Verbose’,1, …
‘Plots’,’training-progress’);
%%Train the Network
net = trainNetwork(XTrain,YTrain,layers,options);
% YTest = data_mat(0.85*length(data_mat):end,1)’;
% XTest = data_mat(0.85*length(data_mat):end,1)’;
%
% XTest = num2cell(XTest,1);
% YTest = num2cell(YTest,1);
%
% net = resetState(net);
% YPred = predict(net,XTest)
%
%
% y1 = (cell2mat(YPred(1:end, 1:end))); %have to transpose as plot plots columns
% plot(y1)
% hold on
% y2 = (cell2mat(YTest(1:end, 1:end))’);
% plot(y2)Hi
I have this following code and the data set is traffic flow that gathered every 15 seconds and I want to predict data flow but i faced an error "Invalid training data. Responses must be a matrix of numeric responses, or a N-by-1 cell array of sequences, where N is the number of sequences. The feature dimension of all sequences must be the same"and I can’t fix it can anyone help me with it
My code is :
clc
close all
clear all
warning off
[~,~,flow_data] = xlsread(‘two_days.xlsx’); % Here we have two days data
data_mat = cell2mat(flow_data(2:end,3:4));
YTrain = data_mat(:,:)’;
XTrain = data_mat(:,:)’;
%
% %
XTrain = num2cell(XTrain,1)’;
YTrain = num2cell(YTrain,1)’;
numResponses = 1 ;
% numResponses = size(YTrain{1},1);
featureDimension = size(XTrain{1},1);
numHiddenUnits = 100;
layers = [ …
sequenceInputLayer(featureDimension)
lstmLayer(numHiddenUnits)
% dropoutLayer(0.1) %%0.5
fullyConnectedLayer(numResponses)
regressionLayer];
maxepochs = 500;
miniBatchSize = 1;
options = trainingOptions(‘adam’, … %%adam
‘MaxEpochs’,maxepochs, …
‘GradientThreshold’,1, …
‘InitialLearnRate’,0.005, …
‘LearnRateSchedule’,’piecewise’, …
‘LearnRateDropPeriod’,125, …
‘LearnRateDropFactor’,0.2, …
‘Verbose’,1, …
‘Plots’,’training-progress’);
%%Train the Network
net = trainNetwork(XTrain,YTrain,layers,options);
% YTest = data_mat(0.85*length(data_mat):end,1)’;
% XTest = data_mat(0.85*length(data_mat):end,1)’;
%
% XTest = num2cell(XTest,1);
% YTest = num2cell(YTest,1);
%
% net = resetState(net);
% YPred = predict(net,XTest)
%
%
% y1 = (cell2mat(YPred(1:end, 1:end))); %have to transpose as plot plots columns
% plot(y1)
% hold on
% y2 = (cell2mat(YTest(1:end, 1:end))’);
% plot(y2) Hi
I have this following code and the data set is traffic flow that gathered every 15 seconds and I want to predict data flow but i faced an error "Invalid training data. Responses must be a matrix of numeric responses, or a N-by-1 cell array of sequences, where N is the number of sequences. The feature dimension of all sequences must be the same"and I can’t fix it can anyone help me with it
My code is :
clc
close all
clear all
warning off
[~,~,flow_data] = xlsread(‘two_days.xlsx’); % Here we have two days data
data_mat = cell2mat(flow_data(2:end,3:4));
YTrain = data_mat(:,:)’;
XTrain = data_mat(:,:)’;
%
% %
XTrain = num2cell(XTrain,1)’;
YTrain = num2cell(YTrain,1)’;
numResponses = 1 ;
% numResponses = size(YTrain{1},1);
featureDimension = size(XTrain{1},1);
numHiddenUnits = 100;
layers = [ …
sequenceInputLayer(featureDimension)
lstmLayer(numHiddenUnits)
% dropoutLayer(0.1) %%0.5
fullyConnectedLayer(numResponses)
regressionLayer];
maxepochs = 500;
miniBatchSize = 1;
options = trainingOptions(‘adam’, … %%adam
‘MaxEpochs’,maxepochs, …
‘GradientThreshold’,1, …
‘InitialLearnRate’,0.005, …
‘LearnRateSchedule’,’piecewise’, …
‘LearnRateDropPeriod’,125, …
‘LearnRateDropFactor’,0.2, …
‘Verbose’,1, …
‘Plots’,’training-progress’);
%%Train the Network
net = trainNetwork(XTrain,YTrain,layers,options);
% YTest = data_mat(0.85*length(data_mat):end,1)’;
% XTest = data_mat(0.85*length(data_mat):end,1)’;
%
% XTest = num2cell(XTest,1);
% YTest = num2cell(YTest,1);
%
% net = resetState(net);
% YPred = predict(net,XTest)
%
%
% y1 = (cell2mat(YPred(1:end, 1:end))); %have to transpose as plot plots columns
% plot(y1)
% hold on
% y2 = (cell2mat(YTest(1:end, 1:end))’);
% plot(y2) trainnetwork, lstm, data MATLAB Answers — New Questions
Section color no longer an option in 2021b?
Prior to the changeover (versions 2021a and older), the current section in the Editor would be highlighted a yellowish color. Now with 2021b, there is a blue bar on the left to indicate the current section. I’d like the yellow-highlighted color back. Looking at the forum, there was an option in Preferences -> Colors -> Programming Tools that would allow the user to customize this section color, but unfortunately this has been removed. Or am I not seeing it somewhere?Prior to the changeover (versions 2021a and older), the current section in the Editor would be highlighted a yellowish color. Now with 2021b, there is a blue bar on the left to indicate the current section. I’d like the yellow-highlighted color back. Looking at the forum, there was an option in Preferences -> Colors -> Programming Tools that would allow the user to customize this section color, but unfortunately this has been removed. Or am I not seeing it somewhere? Prior to the changeover (versions 2021a and older), the current section in the Editor would be highlighted a yellowish color. Now with 2021b, there is a blue bar on the left to indicate the current section. I’d like the yellow-highlighted color back. Looking at the forum, there was an option in Preferences -> Colors -> Programming Tools that would allow the user to customize this section color, but unfortunately this has been removed. Or am I not seeing it somewhere? section, color, preferences, programming tools MATLAB Answers — New Questions
Conditional formatting help
Hi there. I’m looking for some help please.
I am using a data set and have put this into a pivot table. I was to use conditional formatting to highlight when a particular cell is higher, lower, or the same value as the cell beside it.
I’ve managed to get it to work with the first cell (E6).
How do I ensure this works all the way down the sheet without having to do a formula for every cell?
So for example, I want E7 (105) to highlight depending on the value in cell D7 and so on…
Hi there. I’m looking for some help please. I am using a data set and have put this into a pivot table. I was to use conditional formatting to highlight when a particular cell is higher, lower, or the same value as the cell beside it. I’ve managed to get it to work with the first cell (E6). How do I ensure this works all the way down the sheet without having to do a formula for every cell? So for example, I want E7 (105) to highlight depending on the value in cell D7 and so on… Read More
Excel macro to help transfer projects from Wrike to MS Project?
Hi all,
I am in the process of transferring projects from Wrike to Project via excel Wrike-export files.
The structure of the Wrike exports into Excel do not match what Project expects.
I was wondering whether anybody knows of or has a macro of sorts that helps modify the Excel Wrike export files to improve importing them into Project.
Best,
Jacques
Hi all,I am in the process of transferring projects from Wrike to Project via excel Wrike-export files.The structure of the Wrike exports into Excel do not match what Project expects.I was wondering whether anybody knows of or has a macro of sorts that helps modify the Excel Wrike export files to improve importing them into Project.Best,Jacques Read More