Category: News
Quic~kB00ks Unrecoverable Error When Opening Company File
Hi everyone,
I’m encountering a frustrating issue with Quic~kB00ks. Every time I try to open my company file, I receive an “Unrecoverable Error” message. The error codes vary, but it’s making it impossible for me to access my data. I’ve tried restarting my computer and running Quic~kB00ks as an administrator, but nothing seems to work. Has anyone else experienced this issue? What steps can I take to resolve it?
Hi everyone,I’m encountering a frustrating issue with Quic~kB00ks. Every time I try to open my company file, I receive an “Unrecoverable Error” message. The error codes vary, but it’s making it impossible for me to access my data. I’ve tried restarting my computer and running Quic~kB00ks as an administrator, but nothing seems to work. Has anyone else experienced this issue? What steps can I take to resolve it? Read More
Quick~B00ks Automatic Backup Not Working – Help Needed!
Hi everyone,
I’m having an issue with Quick~B00ks where the automatic backup feature isn’t working. I’ve set it up to back up my company files daily, but it seems like it’s not creating any backups at all. I’ve double-checked the settings, and everything seems correct.
Has anyone else encountered this problem? What steps did you take to resolve it? I really need to ensure my data is backed up regularly. Any advice or solutions would be greatly appreciated!
Hi everyone,I’m having an issue with Quick~B00ks where the automatic backup feature isn’t working. I’ve set it up to back up my company files daily, but it seems like it’s not creating any backups at all. I’ve double-checked the settings, and everything seems correct.Has anyone else encountered this problem? What steps did you take to resolve it? I really need to ensure my data is backed up regularly. Any advice or solutions would be greatly appreciated! Read More
Outlook Add-On: Measurably improving meeting effectiveness
Hi everyone,
We have built an add-on that syncs all Outlook calendar data from your organization and turns it into individual & organizational recommendations based on best practices for running effective meetings.
We have two clients and great feedback so far, being able to save 15+ hours/meetings in the first week, reducing average meeting length across the org by 8 min and more.
Looking for more early adopters that are fed up with ineffective meetings.
If this is you, feel free to book time with me directly here or be part of our benchmarking report.
Dm for more info. Appreciate being able to tap into this expert + user network!!
Hi everyone,We have built an add-on that syncs all Outlook calendar data from your organization and turns it into individual & organizational recommendations based on best practices for running effective meetings. We have two clients and great feedback so far, being able to save 15+ hours/meetings in the first week, reducing average meeting length across the org by 8 min and more. Looking for more early adopters that are fed up with ineffective meetings. If this is you, feel free to book time with me directly here or be part of our benchmarking report. Dm for more info. Appreciate being able to tap into this expert + user network!! Read More
Referencing sheets based on a drop-down option
Hi there guys! Hopefully this question isn’t super complicated, but I am trying to make things simple for my co-workers. We’re making a project hours tracker using excel since our team is too small to need an online project management service. Here’s the gist of what I want to do…
In one workbook, each employee has identical worksheet templates which can be filled in as needed with tasks done during the month. Let’s say we have 3 employees on the team. That means, our workbook contains 3 separate worksheets which act as individual logs for each employee. The name of each worksheet is the name of the employee (‘Employee Name’). In their respective worksheets, employees are to log a work entry by filling in three columns per entry: the project name (drop-down selection), a description of the task, and then the numbers of hours spent on that task.
Also in the workbook, there is a fourth worksheet which is for our supervisor. I would like for him, from a drop down, to select the employee’s name he wishes to make an hours report on. So, when he selects the name…maybe we can say John Smith is the employee…the worksheet essentially fills out a report with the projects John Smith worked on and the total hours for each, then creates a pie chart showing percentages.
Most of the functionality of this idea is working pretty well, but for the tallying of hours in the final report, I’m having trouble getting functions to reference the appropriate worksheet. To tally hours, I’m using a SUMIF formula that looks like this:
=SUMIF(‘Employee Name’!A:A,’Hours Report’!A3,’Employee Name’!D:D)
‘Employee Name’!A:A references the full column of project names in the employee log. ‘Hours Report’!A3 references the cell with the project name being tallied in the final report. ‘Employee Name’!D:D references the column of hours logged by the employee.
The worksheet reference name (‘Employee Name’) needs to be changed based on what employee the final report is about, so it can address the appropriate log to sum hours from. I haven’t a clue how to do thus, and tried things like ADDRESS, VLOOKUP, and others without much luck. Any suggestions, thoughts, or solutions?
Hi there guys! Hopefully this question isn’t super complicated, but I am trying to make things simple for my co-workers. We’re making a project hours tracker using excel since our team is too small to need an online project management service. Here’s the gist of what I want to do…In one workbook, each employee has identical worksheet templates which can be filled in as needed with tasks done during the month. Let’s say we have 3 employees on the team. That means, our workbook contains 3 separate worksheets which act as individual logs for each employee. The name of each worksheet is the name of the employee (‘Employee Name’). In their respective worksheets, employees are to log a work entry by filling in three columns per entry: the project name (drop-down selection), a description of the task, and then the numbers of hours spent on that task. Also in the workbook, there is a fourth worksheet which is for our supervisor. I would like for him, from a drop down, to select the employee’s name he wishes to make an hours report on. So, when he selects the name…maybe we can say John Smith is the employee…the worksheet essentially fills out a report with the projects John Smith worked on and the total hours for each, then creates a pie chart showing percentages.Most of the functionality of this idea is working pretty well, but for the tallying of hours in the final report, I’m having trouble getting functions to reference the appropriate worksheet. To tally hours, I’m using a SUMIF formula that looks like this:=SUMIF(‘Employee Name’!A:A,’Hours Report’!A3,’Employee Name’!D:D) ‘Employee Name’!A:A references the full column of project names in the employee log. ‘Hours Report’!A3 references the cell with the project name being tallied in the final report. ‘Employee Name’!D:D references the column of hours logged by the employee. The worksheet reference name (‘Employee Name’) needs to be changed based on what employee the final report is about, so it can address the appropriate log to sum hours from. I haven’t a clue how to do thus, and tried things like ADDRESS, VLOOKUP, and others without much luck. Any suggestions, thoughts, or solutions? Read More
SharePoint search no longer available for nearly all users
Hello Community,
we currently have a problem with a customers SharePoint site collection.
From all users, only one user account can search for documents on the site collection. No other user can search for documents anymore.
All the users who are searching for documents have the required permissions on both the library and document, when the users navigate manually to the document, they can open it – so there should be no permission problem here.
we also checked if the libraries and lists are searchable (in the library settings), which is positive.
We also triggered a reindex multiple times over the last few days, but that didn’t really help.
I don’t know where the problem is, since one user seems to be able to search for documents but nobody else can.
Can anybody give us some advice on what to check next or what this problem is?
Hello Community, we currently have a problem with a customers SharePoint site collection.From all users, only one user account can search for documents on the site collection. No other user can search for documents anymore.All the users who are searching for documents have the required permissions on both the library and document, when the users navigate manually to the document, they can open it – so there should be no permission problem here.we also checked if the libraries and lists are searchable (in the library settings), which is positive. We also triggered a reindex multiple times over the last few days, but that didn’t really help. I don’t know where the problem is, since one user seems to be able to search for documents but nobody else can. Can anybody give us some advice on what to check next or what this problem is? Read More
Sharepoint List Validation
I have a status column in a SharePoint list. I need to write validation to make sure the statuses go in order. The correct order for all entries should be ” not started” -> ” In Work” -> “Complete”. I also want to make it so that if the list item is a “Material Site transfer” to “XYZ city” it will allow you to choose ” in transit” so the order would be ” not started” -> ” In Work” -> ” in transit” ->”Complete” but only if the Request type = material site transfer and To location = XYZ city. Any help would be appreciated, Im not savvy with coding.
I have a status column in a SharePoint list. I need to write validation to make sure the statuses go in order. The correct order for all entries should be ” not started” -> ” In Work” -> “Complete”. I also want to make it so that if the list item is a “Material Site transfer” to “XYZ city” it will allow you to choose ” in transit” so the order would be ” not started” -> ” In Work” -> ” in transit” ->”Complete” but only if the Request type = material site transfer and To location = XYZ city. Any help would be appreciated, Im not savvy with coding. Read More
Please help
I have been messing with conditional formatting all day and have no idea how to figure this out.
Please help us as this is will greatly help our unit save so much time, thank you so much!!
PS: I manually colored these boxes to show how I wish the formatting would look like after inserting formular/rules.
I have been messing with conditional formatting all day and have no idea how to figure this out.Please help us as this is will greatly help our unit save so much time, thank you so much!!PS: I manually colored these boxes to show how I wish the formatting would look like after inserting formular/rules. Read More
Azure Data Scientist Associate
Hi everyone,
I was wandering if anyone can help me.
I have completed the AI Fundamentals (AI-900) exam, the Data Fundamentals (DP-900) exam and the Azure Data Scientist Associate (DP-100) exam. This has really furthered my knowledge on becoming a data scientist.
What is the next step? How do I apply for jobs and further my knowledge?
Thanks
Josh
Hi everyone,I was wandering if anyone can help me.I have completed the AI Fundamentals (AI-900) exam, the Data Fundamentals (DP-900) exam and the Azure Data Scientist Associate (DP-100) exam. This has really furthered my knowledge on becoming a data scientist.What is the next step? How do I apply for jobs and further my knowledge?ThanksJosh Read More
Can’t manually add booking or edit a booking
Hey! I’m desperate for some help!
For the last couple days, I can’t manually add a booking to my shared calendar nor can I edit one. I’m able to click on the day I want to add a booking and I’m able to click the booking I want to edit but when it comes time to click “create booking” or “edit booking” to publish it on the calendar, the box just blinks and doesn’t do anything. I’ve tried having a coworker add a booking or edit one and he also is having the same problem so it’s not just my computer.
What’s weird is that I can add time off with no problem. That’s the only thing Bookings will let me put on the calendar.
Anyone have any idea what the problem may be?? I’ve tried googling but I can’t find anyone on the problem I’ve been having.
Thank you!
Hey! I’m desperate for some help! For the last couple days, I can’t manually add a booking to my shared calendar nor can I edit one. I’m able to click on the day I want to add a booking and I’m able to click the booking I want to edit but when it comes time to click “create booking” or “edit booking” to publish it on the calendar, the box just blinks and doesn’t do anything. I’ve tried having a coworker add a booking or edit one and he also is having the same problem so it’s not just my computer. What’s weird is that I can add time off with no problem. That’s the only thing Bookings will let me put on the calendar. Anyone have any idea what the problem may be?? I’ve tried googling but I can’t find anyone on the problem I’ve been having. Thank you! Read More
How to Fix Quick~B00ks Abort Error During Company File Access?
Hi everyone,
I’m encountering an issue with Quick~B00ks where the program abruptly shuts down with an “Abort Error” message whenever I try to access my company file. This has been happening consistently over the past few days and it’s really affecting my workflow. I’ve tried restarting my computer and updating Quick~B00ks to the latest version, but the problem persists. Has anyone else experienced this issue? What steps can I take to resolve this error?
Hi everyone,I’m encountering an issue with Quick~B00ks where the program abruptly shuts down with an “Abort Error” message whenever I try to access my company file. This has been happening consistently over the past few days and it’s really affecting my workflow. I’ve tried restarting my computer and updating Quick~B00ks to the latest version, but the problem persists. Has anyone else experienced this issue? What steps can I take to resolve this error? Read More
Announcing API Management and API Center Community Live Stream on Thursday, July 25th
Microsoft Tech Community – Latest Blogs –Read More
Azure Capacity Reservations with Automatic Consumption
Solving the ask – Automatic Capacity Reservations
Historically, the setting to use a Capacity Reservations Groups must be defined while the virtual machine is being deployed or changed while the machine is deallocated. While this is still the requirement, the drafted Azure Policy (at the bottom of this document) automates the additional setting to be specified even if it wasn’t specified on the VM Creation process.
For example, some solutions, such as Citrix DaaS hosted on Azure, use automation such as recreation of VMs to handle update management or scalability demands. The update process doesn’t have the ability to add this setting without code changes to their process which requires a significant investment of time per cloud provider to update. If this capacity isn’t available for any reason, the scale out or recreation could fail causing the environment to become unhealthy.
What are Azure Capacity Reservations?
Azure Capacity Reservations are a new feature that allows you to reserve compute resources for your virtual machines (VMs) in a specific region and/or availability zone. By using Azure Capacity Reservations, you can ensure that your VMs have guaranteed access to the resources they need, even during periods of high demand or unexpected events.
Reserved Virtual Machine Instance (RI) to on-demand Capacity Reservation work together. You can apply existing or future RIs to on-demand capacity reservations and receive RI discounts. Available RIs are applied automatically to Capacity Reservation the same way they’re applied to VMs.
Azure Capacity Reservation Group (CRG) is a grouping of Capacity Reservations. VM creation targets the CRG and not the specific Capacity Reservation.
How to create Azure Capacity Reservations?
To get started with Azure Capacity Reservations, you need to follow these steps:
Create a capacity reservation group: A reservation group is a logical container that holds one or more reservations. You can assign VMs to a reservation group to use the reserved resources.
Create a capacity reservation: A reservation is a specific amount of compute resources that you reserve for a certain VM size, region, and availability zone. You can create multiple reservations within a reservation group.
How do I use the Capacity Reservations?
To deploy your virtual machines to the capacity that is created, you need to follow either of these options:
Assign VMs to a reservation group: You can assign existing deallocated VMs or new VMs to a reservation group, either individually or as part of a scale set. The VMs will use the reserved resources from the reservation group, as long as they match the reservation criteria.
Leverage Azure Policy (New as of July 2024):
Using Azure policy, you can deploy a policy per subscription that specifying:
VM SKU
Region
Target Capacity Reservation
Is this a zonal deployment
When VMs are created, this policy will automatically add the virtual machine to the Azure Capacity Reservation Group.
How do I use Azure Policy to set the Capacity Reservation?
With the below parameters set via policy per subscription, VMs of the desired SKU and availability will automatically be added based on:
Region
SKU
Multiple SKUs can be targeted with the policy
Zonal – yes or no
Capacity Reservation ID
The Capacity reservation targeted with the policy will need to match the zonal decision or VM Creations will fail.
Using this functionality, it is now possible to specify a minimum quantity of VM Compute that is guaranteed to be available.
What does this look like in production?
Create Capacity Reservation Group with correct quantities
Create the policy definition
Assign the policy to have VMs automatically added
Create Virtual Machines
Create Capacity Reservations with correct quantities
Create the Capacity Reservation Group to hold the specific Capacity Reservations based on regional or zonal alignment. For each SKU, create a capacity reservation with the minimum amount of compute you wish to be reserved per region or zone. Capacity Reservations can be overallocated. If you reserve 3 nodes of E2s_v4 in zone 1, but attempt to deploy 10 VMs, you are guaranteed to have the 3 available for your consumption and the remaining 7 are subject to normal availability within the zone.
In this example, I have created a Capacity Reservation Groups for regional and another for zonal alignment:
Regional: CRGRG1-WUS3-r
Zonal: CRGRG1-WUS3-z
Create the policy definition
To simplify the experience, I have created a single Azure Policy that is able to be referenced for both scenarios.
An example copy of the policy can be found at the bottom of this article.
Assign the policy to have VMs automatically added
Based on the assignment parameters below:
This example for regional:
allowedLocations
westus3
CapacityReservationID
/subscriptions/########-####-####-####-############/resourceGroups/CRGRG/providers/Microsoft.Compute/capacityReservationGroups/CRGRG1-WUS3-r
listOfCRGSKUs
Standard_E2s_v4
Zonal
False
Based on the assignment parameters below (this example for zonal):
allowedLocations
westus3
CapacityReservationID
/subscriptions/########-####-####-####-############/resourceGroups/CRGRG/providers/Microsoft.Compute/capacityReservationGroups/CRGRG1-WUS3-z
listOfCRGSKUs
Standard_E2s_v4
Zonal
True
Create Virtual Machines within the specified context
Based on the above, if a VM is created with the SKU E2s_v4 in availability zone 1, it will automatically be added to CRGRG1-WUS3-z.
Based on the above, if I create a VM with the SKU E2s_v4 without specifying an availability zone, it will automatically be added to CRGRG1-WUS3-r.
The above Azure Policy and assignments added this line of code in the VM Creation template.
“type”: “Microsoft.Compute/virtualMachines”,
“location”: “westus3”,
“properties”: {
“capacityReservation”: {
“capacityReservationGroup”: {
“id”: “/subscriptions/########-####-####-####-############/resourceGroups/CRGRG/providers/Microsoft.Compute/capacityReservationGroups/CRGRG1-WUS3-z”
}
}
An example copy of the policy can be found below:
The below policy is a draft and is based on new functionality. It should not be treated as production ready unless deemed so by the appropriate resources at your organization.
{
“mode”: “All”,
“policyRule”: {
“if”: {
“allOf”: [
{
“field”: “type”,
“equals”: “Microsoft.Compute/virtualMachines”
},
{
“field”: “location”,
“in”: “[parameters(‘allowedLocations’)]”
},
{
“field”: “Microsoft.Compute/virtualMachines/sku.name”,
“in”: “[parameters(‘listOfCRGSKUs’)]”
},
{
“field”: “Microsoft.Compute/virtualMachines/zones”,
“exists”: “[parameters(‘Zonal’)]”
},
{
“field”: “Microsoft.Compute/virtualMachines/capacityReservation.capacityReservationGroup.id”,
“notequals”: “[parameters(‘CapacityReservationID’)]”
}
]
},
“then”: {
“effect”: “modify”,
“details”: {
“roleDefinitionIds”: [
“/providers/Microsoft.Authorization/roleDefinitions/9980e02c-c2be-4d73-94e8-173b1dc7cf3c”
],
“operations”: [
{
“operation”: “addOrReplace”,
“field”: “Microsoft.Compute/virtualMachines/capacityReservation.capacityReservationGroup.id”,
“value”: “[parameters(‘CapacityReservationID’)]”
}
]
}
}
},
“parameters”: {
“allowedLocations”: {
“type”: “Array”,
“metadata”: {
“displayName”: “Specific Region that is covered under this CRG”,
“description”: “The list of locations that resource groups can be created in.”,
“strongType”: “location”
}
},
“listOfCRGSKUs”: {
“type”: “Array”,
“metadata”: {
“displayName”: “Allowed Size SKUs”,
“description”: “The list of size SKUs that can be specified for virtual machines.”,
“strongType”: “VMSKUs”
}
},
“CapacityReservationID”: {
“type”: “String”,
“metadata”: {
“displayName”: “Capacity Reservation ID”,
“description”: “The capacity reservation targets this policy to target. Resource ID should be formatted as: ‘/subscriptions/{SubID}/resourceGroups/{RGName}/providers/Microsoft.Compute/capacityReservationGroups/{CRG Name}.'”
}
},
“Zonal”: {
“type”: “String”,
“metadata”: {
“displayName”: “Is this Zonal?”,
“description”: “If this is Zonal, it will attempt to add to the Zonal Capacity Reservation Groups. If not, it will add to the reginoal Capacity Reservation Groups.”
},
“allowedValues”: [
“true”,
“false”
]
}
}
}
Microsoft Tech Community – Latest Blogs –Read More
!^¿Como marcar a telefono United Colombia?^!
Para marcar atención al cliente de ^United Colombia llame aquí +57 601 580 4990 /+57 601 580 4990 – luego seleccione el idioma en lo que prefiere hablar con la gente de ^United Colombia^ los ejecutivos están abiertos para asistir los clientes de Delta.
Para marcar atención al cliente de ^United Colombia llame aquí +57 601 580 4990 /+57 601 580 4990 – luego seleccione el idioma en lo que prefiere hablar con la gente de ^United Colombia^ los ejecutivos están abiertos para asistir los clientes de Delta. Read More
O365 Exporting files with multiple periods in file name using DoCmd.Transfertext stopped working
We upgraded from access 2013 to office 365 few years ago. And have been using Transfertext to export files in txt, xls, xlsx formats until last week. Many of the exported files have multiple periods in the file names.
All of a sudden we are getting error message to remove multiple periods and exports are aborting.
Few users of the application are on Access 2013 and we don’t see any issue with 2013.
Is there a solution or fix for above issue?
Thanks in Advance
Shiva
We upgraded from access 2013 to office 365 few years ago. And have been using Transfertext to export files in txt, xls, xlsx formats until last week. Many of the exported files have multiple periods in the file names.All of a sudden we are getting error message to remove multiple periods and exports are aborting.Few users of the application are on Access 2013 and we don’t see any issue with 2013. Is there a solution or fix for above issue? Thanks in AdvanceShiva Read More
System and organization controls in XDR?
A recent Service Health post in the Office 365 Admin Center, regarding a problem with Defender XDR, says “This issue impacts tenant admins and users with system and organization controls (SOC) permissions.”
Is this a mistake? Do they mean “security operations center permissions” (i.e., Entra ID roles or RBAC roles) rather than “system and organization controls?” The former would make sense.
Looking for any clarity anyone can provide on this post.
Thanks in advance!
A recent Service Health post in the Office 365 Admin Center, regarding a problem with Defender XDR, says “This issue impacts tenant admins and users with system and organization controls (SOC) permissions.” Is this a mistake? Do they mean “security operations center permissions” (i.e., Entra ID roles or RBAC roles) rather than “system and organization controls?” The former would make sense. Looking for any clarity anyone can provide on this post. Thanks in advance! Read More
Applied Skills Question – Title Plan Duration vs. learn.microsoft.com
Hi TSPP Team,
we have several questions about the new Applied Skills offerings?
* There are discrepancies between course duration in titleplan and the content on learn.microsoft.com.
e.g.
– MS4008, Title Plan Duration 1Day – Link on learn.microsoft.com Duration 1hr39min
– MS4001, Title Plan 1 day – learn.microsoft.com 3h47min
– SC5006, TP: 1day – learn.microsoft.com 3hrs
I think thats not optimal for students when they attend a 1 day ILT course (in EMEA 7 work-hours) and then they see the content is only 1hr 39min.
Thanks for any tips for to sell this stuff for Learning Partners.
Mario
Hi TSPP Team, we have several questions about the new Applied Skills offerings? * There are discrepancies between course duration in titleplan and the content on learn.microsoft.com.e.g.- MS4008, Title Plan Duration 1Day – Link on learn.microsoft.com Duration 1hr39min- MS4001, Title Plan 1 day – learn.microsoft.com 3h47min- SC5006, TP: 1day – learn.microsoft.com 3hrs I think thats not optimal for students when they attend a 1 day ILT course (in EMEA 7 work-hours) and then they see the content is only 1hr 39min. Thanks for any tips for to sell this stuff for Learning Partners.Mario Read More
Need Help for Selling Applied Skills
Hi,
we appreaciate the new offerings for copilot, AI, and more. For our understanding it would be helpful to have a learning path available which course has which content and whats the audience for it.
There are more than 20 new applied skills for copilot and ai. Is our opinion there is much content overlapping, very short new content for 1 day courses, and basics in nearly every course (e.g. responsible AI, what is Copilot, What are LLMs)
e.g. Overlapping content in the MS4004 to 4008, 4012 courses.
Some are only the “legacy” course split up in 4 courses (e.g. AI3002, 3003, 3004) is the same content as AI102.
A big picture about the new applied skills would be helpful to understand and to sell.
What about a poster: “How to successfully learn, plan, apply the copilot solutions”
Overall our students find it very frustrating to have only Click-Thru-Simulations or Demonstration Only Courses.
We are waiting for many months now to get training licenses for Copilot Training. No one is willing to give us a working answer.
It is very difficult to decide which course to offer and which one to skip. You have to check:
* learn.microsoft.com
* PPT Slides (when LDC is down)
* Course Description & Format differences
* GIT-Hub MCT Pages are almost all empty without any content. (besided the template files azuredeploy.json)
Regards,
Mario
Hi, we appreaciate the new offerings for copilot, AI, and more. For our understanding it would be helpful to have a learning path available which course has which content and whats the audience for it. There are more than 20 new applied skills for copilot and ai. Is our opinion there is much content overlapping, very short new content for 1 day courses, and basics in nearly every course (e.g. responsible AI, what is Copilot, What are LLMs) e.g. Overlapping content in the MS4004 to 4008, 4012 courses. Some are only the “legacy” course split up in 4 courses (e.g. AI3002, 3003, 3004) is the same content as AI102. A big picture about the new applied skills would be helpful to understand and to sell.What about a poster: “How to successfully learn, plan, apply the copilot solutions” Overall our students find it very frustrating to have only Click-Thru-Simulations or Demonstration Only Courses. We are waiting for many months now to get training licenses for Copilot Training. No one is willing to give us a working answer. It is very difficult to decide which course to offer and which one to skip. You have to check: * learn.microsoft.com* PPT Slides (when LDC is down)* Course Description & Format differences* GIT-Hub MCT Pages are almost all empty without any content. (besided the template files azuredeploy.json) Regards,Mario Read More
Out-of-date- connecting on-premises exchange servers
Hi
I am getting issues with sending emails. Please find snapshots. I have done Pause Enforcement for 10 days. It is working fine now but I need permanent solutions.
HiI am getting issues with sending emails. Please find snapshots. I have done Pause Enforcement for 10 days. It is working fine now but I need permanent solutions. Read More
Formula for gannt-charts in projects
Hi everyone,
I am trying to make a gannt-chart for projects and I encounter the following problem.
In the picture you see at my company we have different types of projects (full, medium , light , full ctpd). Regarding this there are different types of hours involved every week, so we have made basic scheme for each type of project(see second picture). I would like that Excel returns these rows based on a) the type of project and b) that it starts returning this row from the date (week) the project starts. The conditional formatting between start date and end date is not difficult to format. Secondly return the rows is also not the problem however let the rows start from the start date is difficult.
Does someone has thoughts on this?
Hi everyone, I am trying to make a gannt-chart for projects and I encounter the following problem. In the picture you see at my company we have different types of projects (full, medium , light , full ctpd). Regarding this there are different types of hours involved every week, so we have made basic scheme for each type of project(see second picture). I would like that Excel returns these rows based on a) the type of project and b) that it starts returning this row from the date (week) the project starts. The conditional formatting between start date and end date is not difficult to format. Secondly return the rows is also not the problem however let the rows start from the start date is difficult. Does someone has thoughts on this? Read More
How to plot RGB histogram of an image into a single 3D slice plot?
Hello. Im working on color image encryption and need to plot the histogram for each color channels. I can plot the individual color channel histogram in three 2D plot with this code.
close all;
image = imread(‘peppers.png’);
R = image(:,:,1);
G = image(:,:,2);
B = image(:,:,3);
[Width,Length] = size(image);
subplot(2,2,1); imshow(image);
title(‘Plain Image’)
subplot(2,2,2);
imhist(R);
myHist1 = findobj(gca, ‘Type’, ‘Stem’);
myHist1.Color = [1 0 0];
title(‘Red Channel Plain Histogram’)
subplot(2,2,3);
imhist(G);
myHist2 = findobj(gca, ‘Type’, ‘Stem’);
myHist2.Color = [0 1 0];
title(‘Green Channel Plain Histogram’)
subplot(2,2,4);
imhist(B);
myHist3 = findobj(gca, ‘Type’, ‘Stem’);
myHist3.Color = [0 0 1];
xlim([0 256]);
title(‘Blue Channel Plain Histogram’)
But, i tried to plot them together in a 3D plot like this below (picture from an article i found), but i cant. I tried to find any forum that talks about this, but i can only found slice plots of meshgrid, not from histogram.
If anyone could help, I would appreciate it so much.
Thank you!Hello. Im working on color image encryption and need to plot the histogram for each color channels. I can plot the individual color channel histogram in three 2D plot with this code.
close all;
image = imread(‘peppers.png’);
R = image(:,:,1);
G = image(:,:,2);
B = image(:,:,3);
[Width,Length] = size(image);
subplot(2,2,1); imshow(image);
title(‘Plain Image’)
subplot(2,2,2);
imhist(R);
myHist1 = findobj(gca, ‘Type’, ‘Stem’);
myHist1.Color = [1 0 0];
title(‘Red Channel Plain Histogram’)
subplot(2,2,3);
imhist(G);
myHist2 = findobj(gca, ‘Type’, ‘Stem’);
myHist2.Color = [0 1 0];
title(‘Green Channel Plain Histogram’)
subplot(2,2,4);
imhist(B);
myHist3 = findobj(gca, ‘Type’, ‘Stem’);
myHist3.Color = [0 0 1];
xlim([0 256]);
title(‘Blue Channel Plain Histogram’)
But, i tried to plot them together in a 3D plot like this below (picture from an article i found), but i cant. I tried to find any forum that talks about this, but i can only found slice plots of meshgrid, not from histogram.
If anyone could help, I would appreciate it so much.
Thank you! Hello. Im working on color image encryption and need to plot the histogram for each color channels. I can plot the individual color channel histogram in three 2D plot with this code.
close all;
image = imread(‘peppers.png’);
R = image(:,:,1);
G = image(:,:,2);
B = image(:,:,3);
[Width,Length] = size(image);
subplot(2,2,1); imshow(image);
title(‘Plain Image’)
subplot(2,2,2);
imhist(R);
myHist1 = findobj(gca, ‘Type’, ‘Stem’);
myHist1.Color = [1 0 0];
title(‘Red Channel Plain Histogram’)
subplot(2,2,3);
imhist(G);
myHist2 = findobj(gca, ‘Type’, ‘Stem’);
myHist2.Color = [0 1 0];
title(‘Green Channel Plain Histogram’)
subplot(2,2,4);
imhist(B);
myHist3 = findobj(gca, ‘Type’, ‘Stem’);
myHist3.Color = [0 0 1];
xlim([0 256]);
title(‘Blue Channel Plain Histogram’)
But, i tried to plot them together in a 3D plot like this below (picture from an article i found), but i cant. I tried to find any forum that talks about this, but i can only found slice plots of meshgrid, not from histogram.
If anyone could help, I would appreciate it so much.
Thank you! image processing, histogram, 3d plots MATLAB Answers — New Questions