Month: June 2024
Konica Universal Print App
Looking for others that are using this app. It seems the app crashes weekly on various models (C300i with latest firmware). We can resume printing by logging in with admin access and re-enabling the app.
We also see other issues like jobs printing (output produced) but not going to a completed state. These have been sitting like this for about 30 minutes. When this happens, we have to reboot the printer.
We got nowhere working with our local support vendor. We’re trying to get national support involved.
Looking for others that are using this app. It seems the app crashes weekly on various models (C300i with latest firmware). We can resume printing by logging in with admin access and re-enabling the app.We also see other issues like jobs printing (output produced) but not going to a completed state. These have been sitting like this for about 30 minutes. When this happens, we have to reboot the printer.We got nowhere working with our local support vendor. We’re trying to get national support involved. Read More
Mute and unmute yourself from Windows taskbar in Microsoft Teams
Hello, Microsoft 365 Insiders,
Exciting news for all users of the new Microsoft Teams experience! We’ve introduced a new feature that lets you mute and unmute yourself straight from the Windows taskbar—streamlining your virtual meetings like never before. Your feedback is our command, and we’re thrilled to deliver this update in the new Teams.
Read our latest blog post to learn all about it: Mute and unmute yourself from Windows taskbar in Microsoft Teams
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hello, Microsoft 365 Insiders,
Exciting news for all users of the new Microsoft Teams experience! We’ve introduced a new feature that lets you mute and unmute yourself straight from the Windows taskbar—streamlining your virtual meetings like never before. Your feedback is our command, and we’re thrilled to deliver this update in the new Teams.
Read our latest blog post to learn all about it: Mute and unmute yourself from Windows taskbar in Microsoft Teams
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
MEDIAN column of AVERAGEIFS and #DIV/0!
I’m a little confused on this.
I have an array of data that was generated by conditional “AVERAGEIFS” with locations by row and differing conditions by column. The data is pulled from a different page.
=AVERAGEIFS(Data!$AL:$AL,Data!$A:$A,”FG-*”,Data!$F:$F,”CRITERIA1″,Data!AL:AL,”<100″,Data!AL:AL,”>0″,Data!$G:$G,”CRITERIA2″)
This part works great
I’m trying to get basic statistics on each column.
Not every location has the conditions so I have #DIV/0! errors mixed through the data.
I am trying to get the median of the column. (and am hoping STDEV functions the same way)
Despite what MS says… =MEDIAN(C4:C88) just gives me a #DIV/0! error.
I’ve tried multiple IF functions but it seems that having the criteria data in the same column as the range for MEDIA is causing issues.
Any ideas?
Thanks
I’m a little confused on this. I have an array of data that was generated by conditional “AVERAGEIFS” with locations by row and differing conditions by column. The data is pulled from a different page. =AVERAGEIFS(Data!$AL:$AL,Data!$A:$A,”FG-*”,Data!$F:$F,”CRITERIA1″,Data!AL:AL,”<100″,Data!AL:AL,”>0″,Data!$G:$G,”CRITERIA2″)This part works great I’m trying to get basic statistics on each column. Not every location has the conditions so I have #DIV/0! errors mixed through the data.I am trying to get the median of the column. (and am hoping STDEV functions the same way)Despite what MS says… =MEDIAN(C4:C88) just gives me a #DIV/0! error. I’ve tried multiple IF functions but it seems that having the criteria data in the same column as the range for MEDIA is causing issues. Any ideas? Thanks Read More
Ny Bit.get-anbefalingskode: qp29 (ny registrering 2024)
Ny Bit.get-anbefalingskode: qp29 (ny registrering 2024)
Den beste B I T GE T-henvisningskoden for 2024 er “qp29”. Bruk denne koden for å få 30 % rabatt på handler. I tillegg kan nye brukere som registrerer seg på B I T GE T ved å bruke kampanjekoden “qp29” sikre seg en eksklusiv belønning på opptil 5005 USDT.
Fordeler med B I T GE T henvisningskode qp29
B I T GE T henvisningskode qp29 tilbyr en flott måte å spare på handelsgebyrer samtidig som du tjener attraktive belønninger. Ved å taste inn denne koden vil du motta en permanent 30% rabatt på handelsgebyrene dine. I tillegg, hvis du deler din personlige henvisningskode med venner, kan du motta en 50 % bonus på handelsgebyrene deres. Benytt deg av denne muligheten til å øke inntektene dine samtidig som du får nye brukere til plattformen.
Den beste B I T GE T-henvisningskoden for 2024
Den anbefalte B I T GE T-henvisningskoden for 2024 er qp29. Når du registrerer deg med denne koden kan du få opptil 5005 USDT som en bonus. Del denne koden med venner for å tjene 50 % provisjon, noe som hjelper deg med å sikre en maksimal registreringsbonus på opptil 5005 USDT. Dette er en fin måte å forbedre handelsopplevelsen din med tilleggsfordeler samtidig som du oppmuntrer andre til å delta.
Slik bruker du B I T GE T henvisningskoden
B I T GE T-henvisningskoden er spesifikt for nye brukere som ennå ikke har registrert seg på plattformen. Følg disse trinnene for å bruke koden:
Besøk B I T GE T-nettstedet og klikk “Logg på”.
Skriv inn brukerdetaljene dine og gå gjennom KYC- og AML-prosedyrene.
Når du blir bedt om din henvisningskode, skriv inn qp29.
Fullfør registreringsprosessen og fullfør eventuelle nødvendige verifikasjoner.
Når alle betingelsene er oppfylt, vil du umiddelbart motta din velkomstbonus.
Hvorfor bruke B I T GE T henvisningskode?
Permanent rabatt: Med koden qp29 får du automatisk 30 % rabatt på alle handelsprovisjoner.
Generøs velkomstbonus: Nye brukere kan motta opptil 5005 USDT.
Ytterligere inntekter: Del koden din og tjen 50 % provisjon.
Benytt deg av denne muligheten og sikre dine fordeler med den gjeldende B I T GE T henvisningskoden qp29! Motta opptil 5005 USDT og dra nytte av permanente rabatter på handelsgebyrene dine.
Ny Bit.get-anbefalingskode: qp29 (ny registrering 2024)Den beste B I T GE T-henvisningskoden for 2024 er “qp29”. Bruk denne koden for å få 30 % rabatt på handler. I tillegg kan nye brukere som registrerer seg på B I T GE T ved å bruke kampanjekoden “qp29” sikre seg en eksklusiv belønning på opptil 5005 USDT.Fordeler med B I T GE T henvisningskode qp29B I T GE T henvisningskode qp29 tilbyr en flott måte å spare på handelsgebyrer samtidig som du tjener attraktive belønninger. Ved å taste inn denne koden vil du motta en permanent 30% rabatt på handelsgebyrene dine. I tillegg, hvis du deler din personlige henvisningskode med venner, kan du motta en 50 % bonus på handelsgebyrene deres. Benytt deg av denne muligheten til å øke inntektene dine samtidig som du får nye brukere til plattformen.Den beste B I T GE T-henvisningskoden for 2024Den anbefalte B I T GE T-henvisningskoden for 2024 er qp29. Når du registrerer deg med denne koden kan du få opptil 5005 USDT som en bonus. Del denne koden med venner for å tjene 50 % provisjon, noe som hjelper deg med å sikre en maksimal registreringsbonus på opptil 5005 USDT. Dette er en fin måte å forbedre handelsopplevelsen din med tilleggsfordeler samtidig som du oppmuntrer andre til å delta.Slik bruker du B I T GE T henvisningskodenB I T GE T-henvisningskoden er spesifikt for nye brukere som ennå ikke har registrert seg på plattformen. Følg disse trinnene for å bruke koden:Besøk B I T GE T-nettstedet og klikk “Logg på”.Skriv inn brukerdetaljene dine og gå gjennom KYC- og AML-prosedyrene.Når du blir bedt om din henvisningskode, skriv inn qp29.Fullfør registreringsprosessen og fullfør eventuelle nødvendige verifikasjoner.Når alle betingelsene er oppfylt, vil du umiddelbart motta din velkomstbonus.Hvorfor bruke B I T GE T henvisningskode?Permanent rabatt: Med koden qp29 får du automatisk 30 % rabatt på alle handelsprovisjoner.Generøs velkomstbonus: Nye brukere kan motta opptil 5005 USDT.Ytterligere inntekter: Del koden din og tjen 50 % provisjon.Benytt deg av denne muligheten og sikre dine fordeler med den gjeldende B I T GE T henvisningskoden qp29! Motta opptil 5005 USDT og dra nytte av permanente rabatter på handelsgebyrene dine. Read More
S mode not turning off
Hi, I just got a new computer running windows 11 and I can’t turn off S mode. every time I try it brings up “something happened and we couldn’t start the upgrade.” I can’t find anything online about it except for one video that has you open up cmd and /.photo 1
Hi, I just got a new computer running windows 11 and I can’t turn off S mode. every time I try it brings up “something happened and we couldn’t start the upgrade.” I can’t find anything online about it except for one video that has you open up cmd and /.photo 1 Read More
Act now: Updated benefits in partner-led offerings to land the adoption of Azure
Azure Migrate and Modernize and Azure Innovate are two comprehensive offerings built to work together and enable simpler adoption of Azure—the foundation of the Microsoft Cloud. These offerings provide software and services partners the critical opportunity to support customer organizations from cloud migration to innovation, with Microsoft guidance, enablement, and funding to deliver expert value and win more business.
What’s new as of April 1, 2024:
Expanded eligibility for partners who build software: Azure Innovate has expanded eligibility for ISVs meeting specific performance criteria (details here). Use Azure Innovate to infuse AI into solutions, advance analytics capabilities, and help to build custom cloud-native applications. Accelerate your digital transformation and deliver innovation projects that drive consistent execution and customer experiences, increasing demand, pipeline, and consumption of AI and analytics projects.
For partners providing services, Azure Migrate and Modernize partner-led introduced an additional incentive: As your customer’s trusted partner, you can give them a modern security solution built for the cloud, and now, earn even more with every migration. Specialized partners can earn an additional incentive specifically for Infrastructure & Database Migration engagements that include Microsoft Defender for Cloud consumption (15% extra funding when compared to standard Infra/DB engagements. Migrations are the perfect opportunity to modernize your customer’s security and compliance with the security platform integrated into Azure and built to span on prem and multi-cloud environments. Defender for Cloud enables you to save costs by consolidating tools, improve visibility across on prem and multicloud systems, and ensure compliance across all workloads.
For a limited time: Azure Innovate is open to Azure specialized partners: Any Azure Migrate and Modernize or Azure Innovate eligible specialization (with the exception of DevOps for GitHub) can unlock access to Azure Innovate for analytics and AI apps projects and receive funding. Partners can nominate new engagements now through June 30, 2024, projects do not have to be completed in fiscal year ‘24. July 1st onwards, this temporary exception will expire and nominations to Azure Innovate will once again require the corresponding specialization.
Accelerate deals, maximize earnings, and activate across more scenarios with expert guidance, self-serve tooling, and rapid approval workflows – so you can deliver better customer experiences.
Get started
Microsoft Tech Community – Latest Blogs –Read More
Migrating OCR Enhancement from GPT-4 Turbo Vision Preview to GPT-4 Turbo GA
The introduction of Optical Character Recognition (OCR) enhancement as a component of the GPT-4 Turbo Vision Preview was aimed at generating higher-quality responses for dense texts, transformed images, and number-heavy financial documents. Although, the recent announcement regarding the GPT-4 Turbo 2024-04-09 General Availability (GA) model indicated that the OCR enhancement is not included in this GA version. This blog post delves into the details of how OCR enhancement functions, the additional system prompts used for OCR enhancement, and provides a code snippet that demonstrates how to replicate the OCR enhancement behavior in the GPT-4 Turbo 2024-04-09 GA model by modifying the input prompt.
How OCR enhancement works
OCR enhancement modifies input messages before sending them to the GPT-4 Vision model using the following steps:
Find the user prompt message that contains an image.
Call the OCR API for this image and obtain the OCR text.
Add the OCR text as additional content to the user prompt message.
Add an additional system prompt message to instruct the model on how to leverage the OCR text to improve the accuracy of the result.
Why OCR enhancement is not supported in GA
Although OCR enhancement functionality provides simplicity by orchestrating OCR API call and prompt modification, it lacks customization of OCR technology and prompt instructions. Running the OCR enhancement process manually provides the following benefits:
Flexibility to choose a different version of OCR (i.e., documents with complex layout and table may benefit from markdown support instead of using plain text).
Flexibility to modify system instructions how OCR text is leveraged by GPT model (i.e., based on document type/quality/etc, leverage OCR text for numbers extraction but rely on GPT vision for signature detection, etc).
Agility to run OCR enhancement for prompt with multiple images (i.e., multi-page documents, comparison scenario, etc). Preview API only supports OCR enhancement for prompts with 1 image.
Running OCR enhancement manually
The goal of the code sample is to illustrate how OCR enhancement can be done manually. It creates two sample GPT payloads:
The first payload is with OCR enhancement enabled.
The second payload is identical to the first one but with 2 additional messages with OCR instructions, added the same way as OCR enhancement is doing for Preview model in Azure OpenAI service backend.
Prerequisites
An Azure OpenAI resource(s) with deployments of GPT-4 Turbo Vision Preview and GPT-4 Turbo 2024-04-09 GA models.
A Document Intelligence resource to call OCR API.
Install Document Intelligence Python SDK:
pip install azure-ai-documentintelligence
Setup environment variables
Create and assign environment variables for resource endpoints and API keys and load them in Python. Also, provide deployment names for both GPT models by replacing ‘<your-deployment-name>’ strings.
import os
# GPT-4 Turbo Vision Preview model
GPT4V_PREVIEW_ENDPOINT = os.getenv(“AZURE_GPT4V_PREVIEW_ENDPOINT”)
GPT4V_PREVIEW_KEY = os.getenv(“AZURE_GPT4V_PREVIEW_KEY”)
GPT4V_PREVIEW_DEPLOYMENT = ‘<your-deployment-name>’
# GPT-4 Turbo 2024-04-09 General Availability (GA) model
GPT4_GA_ENDPOINT = os.getenv(“AZURE_GPT4_GA_ENDPOINT”)
GPT4_GA_KEY = os.getenv(“AZURE_GPT4_GA_KEY”)
GPT4_GA_DEPLOYMENT = ‘<your-deployment-name>’
# Azure Document Intelligence API
DI_ENDPOINT = os.getenv(“AZURE_DI_ENDPOINT”)
DI_KEY = os.getenv(“AZURE_DI_KEY”)
Sample GPT payload
Python code below creates sample Json payload for GPT-4 Turbo Vision Preview API with OCR enhancement enabled. It uses a sample image of Japanese receipt as input and asks to extract Total from the receipt. This receipt is selected because without OCR enhancement GPT-4 Turbo Vision gives wrong answer – 5000, but with OCR enhancement answer is correct – 4500:
import requests
import base64
# Sample image data
IMAGE_BYTES = requests.get(“https://documentintelligence.ai.azure.com/documents/samples/prebuilt/receipt-japanese.jpg”).content
encoded_image = base64.b64encode(IMAGE_BYTES).decode(‘ascii’)
payload_sample = {
“messages”: [
{
“role”: “system”,
“content”: [
{
“type”: “text”,
“text”: “You are AI assistance to help extract information.”
}
]
},
{
“role”: “user”,
“content”: [
{
“type”: “image_url”,
“image_url”: {
“url”: “data:” + “image/jpeg;base64,” + encoded_image
}
},
{
“type”: “text”,
“text”: “Receipt Total as number. Just the number, no currency symbol or additional text.”
}
]
}
],
“temperature”: 0.0, “max_tokens”: 1000
}
Run OCR using Azure Document Intelligence
Define the function which calls Document Intelligence OCR API for the image and returns OCR content:
from azure.ai.documentintelligence import DocumentIntelligenceClient
from azure.core.credentials import AzureKeyCredential
def run_ocr(image_bytes):
document_analysis_client = DocumentIntelligenceClient(endpoint=DI_ENDPOINT, credential=AzureKeyCredential(DI_KEY))
poller = document_analysis_client.begin_analyze_document(‘prebuilt-read’, analyze_request=image_bytes, content_type=’application/octet-stream’)
return poller.result().content
Manually OCR-enhanced GPT payload
Below is an example of manually OCR-enhanced payload. It has 2 changes to the original payload above:
System message is added after all system messages in original prompt with text DEFAULT_OCR_SYSTEM_PROMPT (see below).
OCR text content is added as a first element of user message content. OCR text is produced by “run_ocr” function above.
Same way users can modify any of their own prompts to achieve same results as current OCR enhancements. Payload below illustrate this update: additional system message is at lines 15-23, additional user message is at lines 27-30:
DEFAULT_OCR_PROMPT = “**OCR text:**”
DEFAULT_OCR_SYSTEM_PROMPT = f”Additional instructions: – You’re known to be good at recognizing equations and complete partially occluded text. Additional information has been generated by an OCR model regarding text present in the image in format of {DEFAULT_OCR_PROMPT}. However, you should refrain from incorporating the text information into your description, and only consult the OCR text when the text within the image is unclear to you. Follow your original analysis if OCR text does not help. “
payload_manually_ocr_enhanced = {
“messages”: [
{
“role”: “system”,
“content”: [
{
“type”: “text”,
“text”: “You are AI assistance to help extract information.”
}
]
},
{
“role”: “system”,
“content”: [
{ # OCR enhanced system message with additional instructions
“type”: “text”,
“text”: DEFAULT_OCR_SYSTEM_PROMPT
}
]
},
{
“role”: “user”,
“content”: [
{ # OCR enhanced user message with OCR text
“type”: “text”,
“text”: f”{DEFAULT_OCR_PROMPT} {run_ocr(IMAGE_BYTES)}”
},
{
“type”: “image_url”,
“image_url”: {
“url”: “data:” + “image/jpeg;base64,” + encoded_image
}
},
{
“type”: “text”,
“text”: “Receipt Total as number. Just the number, no currency symbol or additional text.”
}
]
}
],
“temperature”: 0.0, “max_tokens”: 1000
}
Compare results
Code below makes 4 different Azure OpenAI calls:
GPT-4 Turbo Vision Preview model with OCR Enhancement Disabled.
GPT-4 Turbo Vision Preview model with OCR Enhancement Enabled.
GPT-4 Turbo Vision Preview model for manually OCR-enhanced payload (OCR enhancement disabled).
GPT-4 Turbo 2024-04-09 GA model for manually OCR-enhanced payload.
def run_gpt(scenario, payload, url, api_key):
response_json = requests.post(url, json=payload, headers={“Content-Type”: “application/json”, “api-key”: api_key}).json()
print(f”{scenario}:n{response_json[‘usage’]}n{response_json[‘choices’][0][‘message’][‘content’]}n”)
return
# 1. GPT-4 Turbo Vision Preview model with OCR Enhancement disabled
payload_sample[‘enhancements’] = {‘ocr’: {‘enabled’: False}} # Disabled OCR enhancement
run_gpt(“1. GPT-4 Turbo with Vision Preview Results with OCR enhancement Disabled”,
payload_sample, f”{GPT4V_PREVIEW_ENDPOINT}/openai/deployments/{GPT4V_PREVIEW_DEPLOYMENT}/extensions/chat/completions?api-version=2023-12-01-preview”, GPT4V_PREVIEW_KEY)
# 2. GPT-4 Turbo Vision Preview model with OCR Enhancement enabled
payload_sample[‘enhancements’] = {‘ocr’: {‘enabled’: True}} # Enabled OCR enhancement
run_gpt(“2. GPT-4 Turbo with Vision Preview Results with OCR enhancement Enabled”,
payload_sample, f”{GPT4V_PREVIEW_ENDPOINT}/openai/deployments/{GPT4V_PREVIEW_DEPLOYMENT}/extensions/chat/completions?api-version=2023-12-01-preview”, GPT4V_PREVIEW_KEY)
# 3. GPT-4 Turbo Vision Preview model with manually OCR-enhanced payload (OCR enhancement disabled)
run_gpt(“3. GPT-4 Turbo with Vision Preview Results for manually OCR-enhanced payload (OCR enhancement Disabled)”,
payload_manually_ocr_enhanced, f”{GPT4V_PREVIEW_ENDPOINT}/openai/deployments/{GPT4V_PREVIEW_DEPLOYMENT}/chat/completions?api-version=2023-12-01-preview”, GPT4V_PREVIEW_KEY)
# 4. GPT-4 Turbo 2024-04-09 GA model with manually OCR-enhanced payload.
run_gpt(“4. GPT-4 Turbo 2024-04-09 GA Results for manually OCR-enhanced payload”,
payload_manually_ocr_enhanced, f”{GPT4_GA_ENDPOINT}/openai/deployments/{ GPT4_GA_DEPLOYMENT}/chat/completions?api-version=2024-02-15-preview”,GPT4_GA_KEY)
Script outputs GPT results for 4 scenarios and as well as token usage (see below).
Number of “prompt_tokens” for scenario #2 (OCR enhancement enabled) is 1032. It is larger than 801 “prompt_tokens” for scenario #1 (OCR enhancement disabled) even exactly same payload payload_sample was sent to the Azure OpenAI API. It happens because OCR enhancement adds OCR text into the input prompt, and it counts as additional tokens.
Results #2 (with OCR enhancement enabled) and #3 (manually OCR-enhanced payload) are identical. Most important is that number of “prompt_tokens” are identical and equals to 1032. It illustrates that manually OCR-enhanced payload payload_manually_ocr_enhanced is exactly same as the original payload_sample modified by OCR enhancement by Azure OpenAI service backend.
Results #3 (GPT-4 Turbo with Vision Preview) and #4 (GPT-4 Turbo 2024-04-09 GA) are identical for payload_manually_ocr_enhanced, but they may be slightly different for other prompts and/or images since GPT-4 Turbo 2024-04-09 GA model may behave differently than GPT-4 Turbo Vision Preview model.
1. GPT-4 Turbo with Vision Preview Results with OCR enhancement Disabled:
{‘completion_tokens’: 2, ‘prompt_tokens’: 801, ‘total_tokens’: 803}
5000
2. GPT-4 Turbo with Vision Preview Results with OCR enhancement Enabled:
{‘completion_tokens’: 2, ‘prompt_tokens’: 1032, ‘total_tokens’: 1034}
4500
3. GPT-4 Turbo with Vision Preview Results for manually OCR-enhanced payload (OCR enhancement Disabled):
{‘completion_tokens’: 2, ‘prompt_tokens’: 1032, ‘total_tokens’: 1034}
4500
4. GPT-4 Turbo 2024-04-09 GA results for manually OCR-enhanced payload:
{‘completion_tokens’: 2, ‘prompt_tokens’: 1032, ‘total_tokens’: 1034}
4500
We hope this blog post helps to understand exactly how OCR enhancement works and allows you to successfully migrate to GPT-4 Turbo GA model.
Thanks
Microsoft Tech Community – Latest Blogs –Read More
Partitioning data for Time Series TCN model Training, Validation, and Testing
Hello there, I am trying to build a TCN model to predict a continuous variable. I have time series data in which I am using 3 input features (accelrometer measuments in x,y,z directions) to estimate/predict a continuous variable. I have acceleromter data from 10 different trials stored in a 10×1 cell and each cell has the three accelerometer measurments over time stored in a 500×3 table for that trial. The target continous varable I am trying to predict is simialrly stored in a 10×1 cell array with each cell contaning a the a 500×1 table which is the true value of the predicted variable over time named "Taget". If I am trying to build a TCN model with this data what is the best way to partition the data for training, testing (10%), and validation (10%)? I think I need to use the tspartition function but am not sure how to use it for this type of data. Do I need to combine the data from all 10 trials into one large table and then partition? Or should I partition each trial seprately, train the model on a singluar trial, and then retrain the model on the next trial and so on. Any help would be greatly appreciated!Hello there, I am trying to build a TCN model to predict a continuous variable. I have time series data in which I am using 3 input features (accelrometer measuments in x,y,z directions) to estimate/predict a continuous variable. I have acceleromter data from 10 different trials stored in a 10×1 cell and each cell has the three accelerometer measurments over time stored in a 500×3 table for that trial. The target continous varable I am trying to predict is simialrly stored in a 10×1 cell array with each cell contaning a the a 500×1 table which is the true value of the predicted variable over time named "Taget". If I am trying to build a TCN model with this data what is the best way to partition the data for training, testing (10%), and validation (10%)? I think I need to use the tspartition function but am not sure how to use it for this type of data. Do I need to combine the data from all 10 trials into one large table and then partition? Or should I partition each trial seprately, train the model on a singluar trial, and then retrain the model on the next trial and so on. Any help would be greatly appreciated! Hello there, I am trying to build a TCN model to predict a continuous variable. I have time series data in which I am using 3 input features (accelrometer measuments in x,y,z directions) to estimate/predict a continuous variable. I have acceleromter data from 10 different trials stored in a 10×1 cell and each cell has the three accelerometer measurments over time stored in a 500×3 table for that trial. The target continous varable I am trying to predict is simialrly stored in a 10×1 cell array with each cell contaning a the a 500×1 table which is the true value of the predicted variable over time named "Taget". If I am trying to build a TCN model with this data what is the best way to partition the data for training, testing (10%), and validation (10%)? I think I need to use the tspartition function but am not sure how to use it for this type of data. Do I need to combine the data from all 10 trials into one large table and then partition? Or should I partition each trial seprately, train the model on a singluar trial, and then retrain the model on the next trial and so on. Any help would be greatly appreciated! model, machine learning MATLAB Answers — New Questions
selected workspace variables in Matlab
Is it possible to only display a selected group of variables in the workspace window instead of all of them?Is it possible to only display a selected group of variables in the workspace window instead of all of them? Is it possible to only display a selected group of variables in the workspace window instead of all of them? matlab selected workspace variables MATLAB Answers — New Questions
Replace NaN with Blanks
Hi guys I have a double matrix as shown in the attached picture that I am trying to replace all NaN values with Empty spaces so that the over all matrix dimension will be maintained. However, when I looked through the function and suggested solutions non of them is actully working what possible code can be used.
Thanks in advanceHi guys I have a double matrix as shown in the attached picture that I am trying to replace all NaN values with Empty spaces so that the over all matrix dimension will be maintained. However, when I looked through the function and suggested solutions non of them is actully working what possible code can be used.
Thanks in advance Hi guys I have a double matrix as shown in the attached picture that I am trying to replace all NaN values with Empty spaces so that the over all matrix dimension will be maintained. However, when I looked through the function and suggested solutions non of them is actully working what possible code can be used.
Thanks in advance nan, blank, empty, matrix MATLAB Answers — New Questions
Why are the descriptive names of my boxchart categories not visible in my figure?
Hi all, I am trying to visualise ply thicknesses (in multiple composite samples) using boxchart(). I manage to show the boxes according to the ply numbers. However, I would like to mention the fibre orientation with the ply numbers as well. The (adapted, for readability) code I used so far is shown below. I also included the result I obtained.
My problem is that the y-axis do not show both the number and the orientation of the plies. I tried to follow the "Create Multiple Box Charts Using Positional Grouping Variable" example in the boxchart documentation, because this example shows the replacement of numbered axis-ticklabels to a descriptive label (just like I want my axis to be). It tells me to use categorical() to "replace" the plain ply numbers, after which I need to use boxchart. Although I think I applied this example correctly to my case and all intermediate steps look like they were executed as desired, the figure does not turn out as intended. Why are the descriptive names on the y-axis not visible in the figure?
table = array2table([nr t]; % A table containing the ply numbers (pnr) and their corresponding thicknesses (t). This outputs a table with many rows (the amount of samples with n plies) by 2 columns (pnr and t)
for i = 1:nplies
p_ors_str = string(sprintf(‘%02i: %i%c’,nply(i),layup_weld(i),char(0176)))); % Describing the ply number with the corresponding orientation
end % Results in a nplies*1 string containing element similar to "01: 45°".
p_ors_cat = categorical(table.nr,1:nplies,p_ors_str); % Converting the ply numbers to a descriptive string in a categorical array
figure(1), clf(1), hold on
subplot(2,1,1), hold on % This method corresponds to the "boxchart(earthquakes.Month,earthquakes.EarthquakeMagnitude)"-command in the example
boxchart(table.pnr,table.t,’Orientation’,’Horizontal’) % The boxes visualise the several measurements for every ply, showing ply numbers
ylabel(‘Ply number’)
subplot(2,1,2), hold on % This method corresponds to the "boxchart(namedMonths,earthquakes.EarthquakeMagnitude)"-command in the example
boxchart(p_ors_str,table.t,’Orientation’,’Horizontal’) % The boxes should visualise the same as before, but describing the ply number with their orientation
ylabel(‘Ply number and orientation’)Hi all, I am trying to visualise ply thicknesses (in multiple composite samples) using boxchart(). I manage to show the boxes according to the ply numbers. However, I would like to mention the fibre orientation with the ply numbers as well. The (adapted, for readability) code I used so far is shown below. I also included the result I obtained.
My problem is that the y-axis do not show both the number and the orientation of the plies. I tried to follow the "Create Multiple Box Charts Using Positional Grouping Variable" example in the boxchart documentation, because this example shows the replacement of numbered axis-ticklabels to a descriptive label (just like I want my axis to be). It tells me to use categorical() to "replace" the plain ply numbers, after which I need to use boxchart. Although I think I applied this example correctly to my case and all intermediate steps look like they were executed as desired, the figure does not turn out as intended. Why are the descriptive names on the y-axis not visible in the figure?
table = array2table([nr t]; % A table containing the ply numbers (pnr) and their corresponding thicknesses (t). This outputs a table with many rows (the amount of samples with n plies) by 2 columns (pnr and t)
for i = 1:nplies
p_ors_str = string(sprintf(‘%02i: %i%c’,nply(i),layup_weld(i),char(0176)))); % Describing the ply number with the corresponding orientation
end % Results in a nplies*1 string containing element similar to "01: 45°".
p_ors_cat = categorical(table.nr,1:nplies,p_ors_str); % Converting the ply numbers to a descriptive string in a categorical array
figure(1), clf(1), hold on
subplot(2,1,1), hold on % This method corresponds to the "boxchart(earthquakes.Month,earthquakes.EarthquakeMagnitude)"-command in the example
boxchart(table.pnr,table.t,’Orientation’,’Horizontal’) % The boxes visualise the several measurements for every ply, showing ply numbers
ylabel(‘Ply number’)
subplot(2,1,2), hold on % This method corresponds to the "boxchart(namedMonths,earthquakes.EarthquakeMagnitude)"-command in the example
boxchart(p_ors_str,table.t,’Orientation’,’Horizontal’) % The boxes should visualise the same as before, but describing the ply number with their orientation
ylabel(‘Ply number and orientation’) Hi all, I am trying to visualise ply thicknesses (in multiple composite samples) using boxchart(). I manage to show the boxes according to the ply numbers. However, I would like to mention the fibre orientation with the ply numbers as well. The (adapted, for readability) code I used so far is shown below. I also included the result I obtained.
My problem is that the y-axis do not show both the number and the orientation of the plies. I tried to follow the "Create Multiple Box Charts Using Positional Grouping Variable" example in the boxchart documentation, because this example shows the replacement of numbered axis-ticklabels to a descriptive label (just like I want my axis to be). It tells me to use categorical() to "replace" the plain ply numbers, after which I need to use boxchart. Although I think I applied this example correctly to my case and all intermediate steps look like they were executed as desired, the figure does not turn out as intended. Why are the descriptive names on the y-axis not visible in the figure?
table = array2table([nr t]; % A table containing the ply numbers (pnr) and their corresponding thicknesses (t). This outputs a table with many rows (the amount of samples with n plies) by 2 columns (pnr and t)
for i = 1:nplies
p_ors_str = string(sprintf(‘%02i: %i%c’,nply(i),layup_weld(i),char(0176)))); % Describing the ply number with the corresponding orientation
end % Results in a nplies*1 string containing element similar to "01: 45°".
p_ors_cat = categorical(table.nr,1:nplies,p_ors_str); % Converting the ply numbers to a descriptive string in a categorical array
figure(1), clf(1), hold on
subplot(2,1,1), hold on % This method corresponds to the "boxchart(earthquakes.Month,earthquakes.EarthquakeMagnitude)"-command in the example
boxchart(table.pnr,table.t,’Orientation’,’Horizontal’) % The boxes visualise the several measurements for every ply, showing ply numbers
ylabel(‘Ply number’)
subplot(2,1,2), hold on % This method corresponds to the "boxchart(namedMonths,earthquakes.EarthquakeMagnitude)"-command in the example
boxchart(p_ors_str,table.t,’Orientation’,’Horizontal’) % The boxes should visualise the same as before, but describing the ply number with their orientation
ylabel(‘Ply number and orientation’) boxchart, plotting, boxplot, yticklabels, ticklabels, xticklabels, composites MATLAB Answers — New Questions
Temperature dependent thermal diffusivity using PDE Toolbox
Hello,
This is my first implementation of a problem using the PDE Toolbox. My 3D time-dependent thermal model is the following : a sphere (radius equals to 1) with radiative flux on the outside surface, with cell at inital temperature . I would like to use a temperature dependent thermal diffusivity where . I have then an analytical expression for it given by : , which I know from documentation for my material.
The parameters used in my simulations are the following :
lambda = @(location,state) 0.46+0.95*exp(-2.3e-3*state.u); % (W/m/K) Thermal conductivity
rho=1000; % (kg/m**3) Density
cp=1000; % (J/kg/K) Specific heat
T0=2000; % (K) Initial temperature
T_out=300; % (K) outer space temperature
eps=1; % Emissivity
dt=20; % (s) time-step
day=3600*24;
tmax=2*day;
tlist = [0:dt:tmax]; % time list
I then implement my model using Matlab PDE Toolbox :
thermalModel = createpde(‘thermal’,’transient’);
gm = multisphere(1);
thermalModel.Geometry=gm;
generateMesh(thermalModel,’Hmax’,0.2,"GeometricOrder","quadratic");
thermalModel.StefanBoltzmannConstant = 5.670373E-8;
thermalProperties(thermalModel,’ThermalConductivity’,lambda,’MassDensity’,rho,’SpecificHeat’,cp);
% Initial Temperature
thermalIC(thermalModel,T0);
% Radiative Flux :
thermalBC(thermalModel,"Face",1,"Emissivity",@(region,state) eps,"AmbientTemperature",T_out, "Vectorized","on");
% Solver
thermalResults = solve(thermalModel,tlist);
Does anyone know whether the implementation is correct ?
Many thanks for any help you can give me !
Regards,
TomHello,
This is my first implementation of a problem using the PDE Toolbox. My 3D time-dependent thermal model is the following : a sphere (radius equals to 1) with radiative flux on the outside surface, with cell at inital temperature . I would like to use a temperature dependent thermal diffusivity where . I have then an analytical expression for it given by : , which I know from documentation for my material.
The parameters used in my simulations are the following :
lambda = @(location,state) 0.46+0.95*exp(-2.3e-3*state.u); % (W/m/K) Thermal conductivity
rho=1000; % (kg/m**3) Density
cp=1000; % (J/kg/K) Specific heat
T0=2000; % (K) Initial temperature
T_out=300; % (K) outer space temperature
eps=1; % Emissivity
dt=20; % (s) time-step
day=3600*24;
tmax=2*day;
tlist = [0:dt:tmax]; % time list
I then implement my model using Matlab PDE Toolbox :
thermalModel = createpde(‘thermal’,’transient’);
gm = multisphere(1);
thermalModel.Geometry=gm;
generateMesh(thermalModel,’Hmax’,0.2,"GeometricOrder","quadratic");
thermalModel.StefanBoltzmannConstant = 5.670373E-8;
thermalProperties(thermalModel,’ThermalConductivity’,lambda,’MassDensity’,rho,’SpecificHeat’,cp);
% Initial Temperature
thermalIC(thermalModel,T0);
% Radiative Flux :
thermalBC(thermalModel,"Face",1,"Emissivity",@(region,state) eps,"AmbientTemperature",T_out, "Vectorized","on");
% Solver
thermalResults = solve(thermalModel,tlist);
Does anyone know whether the implementation is correct ?
Many thanks for any help you can give me !
Regards,
Tom Hello,
This is my first implementation of a problem using the PDE Toolbox. My 3D time-dependent thermal model is the following : a sphere (radius equals to 1) with radiative flux on the outside surface, with cell at inital temperature . I would like to use a temperature dependent thermal diffusivity where . I have then an analytical expression for it given by : , which I know from documentation for my material.
The parameters used in my simulations are the following :
lambda = @(location,state) 0.46+0.95*exp(-2.3e-3*state.u); % (W/m/K) Thermal conductivity
rho=1000; % (kg/m**3) Density
cp=1000; % (J/kg/K) Specific heat
T0=2000; % (K) Initial temperature
T_out=300; % (K) outer space temperature
eps=1; % Emissivity
dt=20; % (s) time-step
day=3600*24;
tmax=2*day;
tlist = [0:dt:tmax]; % time list
I then implement my model using Matlab PDE Toolbox :
thermalModel = createpde(‘thermal’,’transient’);
gm = multisphere(1);
thermalModel.Geometry=gm;
generateMesh(thermalModel,’Hmax’,0.2,"GeometricOrder","quadratic");
thermalModel.StefanBoltzmannConstant = 5.670373E-8;
thermalProperties(thermalModel,’ThermalConductivity’,lambda,’MassDensity’,rho,’SpecificHeat’,cp);
% Initial Temperature
thermalIC(thermalModel,T0);
% Radiative Flux :
thermalBC(thermalModel,"Face",1,"Emissivity",@(region,state) eps,"AmbientTemperature",T_out, "Vectorized","on");
% Solver
thermalResults = solve(thermalModel,tlist);
Does anyone know whether the implementation is correct ?
Many thanks for any help you can give me !
Regards,
Tom pde, diffusivity, toolbox, thermal, temperature, dependent MATLAB Answers — New Questions
Device selection for software download
I am unable to Download anything in this computer.Please advice Regards,Carlos Read More
What would you do? User needs to generate a random number and ideally not leave the worksheet
Hey Gang! I have a spreadsheet (see below) that requires the user to generate unique identifiers for the PCODE row and the BUNDLE IDENTIFIER row. What I have them doing is clicking on another worksheet and clicking the appropriate button, then return to the original worksheet and paste the value into the cell. The buttons are connected to a VBA routine that does the actual generation.
I have been struggling with how I can do this from within the same worksheet. The worksheet consists of different row types (PCODE, BUNDLE IDENTIFIER, COMPONENT), as the user builds out their bundle.
Update – I have found a method, which has the formula embedded in the target cell. The formula is connected to a VBA function. This works however, I need to copy that value into subsequent rows, and if I drag it, the formula comes along, so I am forced to copy and paste values which is a tad clunky.
formula – =ConcatRandomNumberWithSuffix(“B”)
It will also be subject to changing the value if i refresh the spreadsheet which would be a disaster.
Sub GeneratePCODE_Click()
Dim randomNumber As Long
Dim formattedNumber As String
Dim finalString As String
Dim ws As Worksheet
Dim genPCODEBUNDLEID As Worksheet
Dim cell As Range
! FOR PCODE
‘ Set the worksheet location for the output variables
Set genPCODEBUNDLEID = ThisWorkbook.Sheets(“Generate_PCODE_BUNDLEID”)
Set cell = genPCODEBUNDLEID.Range(“D9”)
cell.Value = “” ‘ clear out the value in the spreadsheet
genPCODEBUNDLEID.Calculate ‘ recalculate the sheet
‘ Generate a random number between 1,000,000 and 9,999,998
randomNumber = Application.WorksheetFunction.RandBetween(1000000, 9999998)
‘ Format the number with leading zeros to make it a 7-digit number
formattedNumber = Format(randomNumber, “0000000”)
‘ Concatenate the formatted number with “Q”
finalString = formattedNumber & “Q”
‘ Set the PCODE value
cell.Value = finalString
End Sub
Sub GenerateBUNDLEID_Click()
Dim randomNumber As Long
Dim formattedNumber As String
Dim finalString As String
Dim ws As Worksheet
Dim genPCODEBUNDLEID As Worksheet
Dim cell As Range
! FOR BUNDLEID
‘ Set the worksheet location for the output variables
Set genPCODEBUNDLEID = ThisWorkbook.Sheets(“Generate_PCODE_BUNDLEID”)
Set cell = genPCODEBUNDLEID.Range(“D18”)
cell.Value = “” ‘ clear out the value in the spreadsheet
genPCODEBUNDLEID.Calculate ‘ recalculate the sheet
‘ Generate a random number between 1,000,000 and 9,999,998
randomNumber = Application.WorksheetFunction.RandBetween(1000000, 9999998)
‘ Format the number with leading zeros to make it a 7-digit number
formattedNumber = Format(randomNumber, “0000000”)
‘ Concatenate the formatted number with “B”
finalString = formattedNumber & “B”
cell.Value = finalString
End Sub
Hey Gang! I have a spreadsheet (see below) that requires the user to generate unique identifiers for the PCODE row and the BUNDLE IDENTIFIER row. What I have them doing is clicking on another worksheet and clicking the appropriate button, then return to the original worksheet and paste the value into the cell. The buttons are connected to a VBA routine that does the actual generation. I have been struggling with how I can do this from within the same worksheet. The worksheet consists of different row types (PCODE, BUNDLE IDENTIFIER, COMPONENT), as the user builds out their bundle. Update – I have found a method, which has the formula embedded in the target cell. The formula is connected to a VBA function. This works however, I need to copy that value into subsequent rows, and if I drag it, the formula comes along, so I am forced to copy and paste values which is a tad clunky.formula – =ConcatRandomNumberWithSuffix(“B”)It will also be subject to changing the value if i refresh the spreadsheet which would be a disaster. Sub GeneratePCODE_Click()Dim randomNumber As LongDim formattedNumber As StringDim finalString As StringDim ws As WorksheetDim genPCODEBUNDLEID As WorksheetDim cell As Range! FOR PCODE’ Set the worksheet location for the output variablesSet genPCODEBUNDLEID = ThisWorkbook.Sheets(“Generate_PCODE_BUNDLEID”)Set cell = genPCODEBUNDLEID.Range(“D9”)cell.Value = “” ‘ clear out the value in the spreadsheetgenPCODEBUNDLEID.Calculate ‘ recalculate the sheet’ Generate a random number between 1,000,000 and 9,999,998randomNumber = Application.WorksheetFunction.RandBetween(1000000, 9999998)’ Format the number with leading zeros to make it a 7-digit numberformattedNumber = Format(randomNumber, “0000000”)’ Concatenate the formatted number with “Q”finalString = formattedNumber & “Q”‘ Set the PCODE valuecell.Value = finalStringEnd SubSub GenerateBUNDLEID_Click()Dim randomNumber As LongDim formattedNumber As StringDim finalString As StringDim ws As WorksheetDim genPCODEBUNDLEID As WorksheetDim cell As Range! FOR BUNDLEID’ Set the worksheet location for the output variablesSet genPCODEBUNDLEID = ThisWorkbook.Sheets(“Generate_PCODE_BUNDLEID”)Set cell = genPCODEBUNDLEID.Range(“D18”)cell.Value = “” ‘ clear out the value in the spreadsheetgenPCODEBUNDLEID.Calculate ‘ recalculate the sheet’ Generate a random number between 1,000,000 and 9,999,998randomNumber = Application.WorksheetFunction.RandBetween(1000000, 9999998)’ Format the number with leading zeros to make it a 7-digit numberformattedNumber = Format(randomNumber, “0000000”)’ Concatenate the formatted number with “B”finalString = formattedNumber & “B”cell.Value = finalStringEnd Sub Read More
LinkedIn Sales Navigator & Fundraising and Engagement
Hi all
Just wondering if there is any offering for MS Partners to be able to install an instance of LinkedIn Sales Navigator (LISN) on a sandbox Power Platform environment running MS NFP solutions, as I see that Fundraising and Engagement can be integrated with LISN.
As a partner it would be nice to be able to demonstrate this functionality to potential customers, but as far as I can see this isn’t possible without purchasing a full license.
Does anyone else have experience here?
Thanks in advance.
Hi allJust wondering if there is any offering for MS Partners to be able to install an instance of LinkedIn Sales Navigator (LISN) on a sandbox Power Platform environment running MS NFP solutions, as I see that Fundraising and Engagement can be integrated with LISN.As a partner it would be nice to be able to demonstrate this functionality to potential customers, but as far as I can see this isn’t possible without purchasing a full license.Does anyone else have experience here?Thanks in advance. Read More
formula error with specific values only
I’m getting the incorrect answer when the value in F15 is 2200 and the value in G15 is 2345. Instead of returning 1.75 it rounds up an additional 15 minutes to 2.0. It only seems to do it with those values, all others I try seem to work. Any ideas why?
=IFERROR(IF(AND(J15=FALSE,O15=FALSE),CEILING.MATH((TEXT(G15,”00:00″)-TEXT(F15, “00:00”)+(F15>G15))*24,15/60),0),0)
I’m getting the incorrect answer when the value in F15 is 2200 and the value in G15 is 2345. Instead of returning 1.75 it rounds up an additional 15 minutes to 2.0. It only seems to do it with those values, all others I try seem to work. Any ideas why? =IFERROR(IF(AND(J15=FALSE,O15=FALSE),CEILING.MATH((TEXT(G15,”00:00″)-TEXT(F15, “00:00”)+(F15>G15))*24,15/60),0),0) Read More
“All sources” filter
We’ve set up several graph connectors in the search center and plan to add more in the near future as we move towards using M365 search as our enterprise search solution. During our testing, we’ve noticed that the “All” search vertical sometimes shows “All sources” (a drop-down list of all of available content sources) and sometimes the “All sources” filter isn’t available. We haven’t been able to identify a pattern — sometimes “All sources” will show up for a particular person one day and not be available the next day. We’d like to make the “All sources” filter available for everyone and have it show up consistently. Does anyone know what determines when the “All sources” filter shows up?
We’ve set up several graph connectors in the search center and plan to add more in the near future as we move towards using M365 search as our enterprise search solution. During our testing, we’ve noticed that the “All” search vertical sometimes shows “All sources” (a drop-down list of all of available content sources) and sometimes the “All sources” filter isn’t available. We haven’t been able to identify a pattern — sometimes “All sources” will show up for a particular person one day and not be available the next day. We’d like to make the “All sources” filter available for everyone and have it show up consistently. Does anyone know what determines when the “All sources” filter shows up? Read More
New Retention Banners in Web Outlook
The new retention banners added in web outlook are horribly abrasive and distracting, your eyes keep going to them and not the content of the message. We can’t find a way to disable these unless we change the polocy. Curious if there is a way to, or hopefully MS changes this graphic. 
The new retention banners added in web outlook are horribly abrasive and distracting, your eyes keep going to them and not the content of the message. We can’t find a way to disable these unless we change the polocy. Curious if there is a way to, or hopefully MS changes this graphic.  Read More
How to move multiple contacts to Bcc
how do I move multiple contacts to Bcc in my email
how do I move multiple contacts to Bcc in my email Read More
Compliance Policy troublestooting
Hello
I have created a custom compliance policy to check whether third-party antivirus software is installed and deployed it to some test devices. This device group includes 35 devices, all of which are running either Windows 11 or Windows 10 22H2. However, 10 out of the 35 devices show the status as “not applicable.”
I would like to know how to troubleshoot this issue on the client side. Specifically, when I assign a compliance policy to a device, what happens first, and which logs or events can show that this policy has been received?
HelloI have created a custom compliance policy to check whether third-party antivirus software is installed and deployed it to some test devices. This device group includes 35 devices, all of which are running either Windows 11 or Windows 10 22H2. However, 10 out of the 35 devices show the status as “not applicable.”I would like to know how to troubleshoot this issue on the client side. Specifically, when I assign a compliance policy to a device, what happens first, and which logs or events can show that this policy has been received? Read More
