Month: September 2024
INCREASE VALUE ON SEPERATE SHEETS
Attention Advisor,
I am currently using excel spreadsheet for costs and quotes on customers.
I have one sheet up with part numbers and my costs on them, and what would make it very simple and beneficial for me is if I could set up separate sheets and have the costs get adjusted accordingly. For example lets say in sheet #1 it would have my cost in there, and sheet #2 it would have cost plus 10%, sheet #3 would be cost plus 20%. But if my costs change, it would be fantastic if I could adjust the price on sheet #1 and the other sheets would follow suit and adjust it automatically, rather then going into each individual sheet and adjusting every single time my cost goes up. Is anything like this a possibility?
Attention Advisor, I am currently using excel spreadsheet for costs and quotes on customers. I have one sheet up with part numbers and my costs on them, and what would make it very simple and beneficial for me is if I could set up separate sheets and have the costs get adjusted accordingly. For example lets say in sheet #1 it would have my cost in there, and sheet #2 it would have cost plus 10%, sheet #3 would be cost plus 20%. But if my costs change, it would be fantastic if I could adjust the price on sheet #1 and the other sheets would follow suit and adjust it automatically, rather then going into each individual sheet and adjusting every single time my cost goes up. Is anything like this a possibility? Read More
Sikkim Invite Code 2024: 667811500744 ( Claim Today Gift Bonus)
Sikkim Invite code is 667811500744, use this code at the time of sign up to get a free bonus of Rs.52 on. Sikkim colour prediction app lets you have fun guessing the next winning colour for a chance to earn rewards.The Sikkim is quite a fresh website, which is why, in the starting, you can get many bonuses on the Sikkim app. So, don’t hold up for long and register on the Sikkim app.
Sikkim Invite Code
Sikkim Invitation Code
667811500744
Signup Bonus
Rs. 1500
Sikkim Invite Code
667811500744
Sikkim Invitation Code 667811500744
667811500744 is a Sikkim app invite code. You will get a sign up bonus upto Rs.52 on using the code at the time of registration. You can also earn by sharing your invite code with your friends.
Sikkim offers you Daily Bonus, Weekly Bonus, Monthly Bonus, Rebate, Referral Bonus and many more advantages. Here you can easily do the Agent work also and make daily huge profits just by giving predictions to there team and make them play the games.
Sikkim Colour Prediction Game
On Sikkim Games you can play the Sikkim Colour Prediction Games in which you can either predict the Colours or the numbers as you can easily make your money 2X by predicting colours and 9X by predicting the numbers in less than 30 sec. Here, you can play Wingo, Trx Wingo, K3, 5D. On Sikkim App you can play many other games also like Aviator, Casino and many more games through which you can make daily huge money by investing your few seconds only.
About Sikkim
The Sikkim Colour Prediction app is an entertaining platform where users can predict the next winning colour or numbers. It is easy to play- simply choose a color you think will be selected, and if you are right you can easily double your money or even 10X in just 30sec. This app offers a simple way to pass the time while testing your luck. It is a popular way for those who enjoy casual games with a chance to win.
Sikkim Invite code is 667811500744, use this code at the time of sign up to get a free bonus of Rs.52 on. Sikkim colour prediction app lets you have fun guessing the next winning colour for a chance to earn rewards.The Sikkim is quite a fresh website, which is why, in the starting, you can get many bonuses on the Sikkim app. So, don’t hold up for long and register on the Sikkim app.Sikkim Invite Code Sikkim Invitation Code667811500744Signup BonusRs. 1500Sikkim Invite Code667811500744Sikkim Invitation Code 667811500744667811500744 is a Sikkim app invite code. You will get a sign up bonus upto Rs.52 on using the code at the time of registration. You can also earn by sharing your invite code with your friends.Sikkim offers you Daily Bonus, Weekly Bonus, Monthly Bonus, Rebate, Referral Bonus and many more advantages. Here you can easily do the Agent work also and make daily huge profits just by giving predictions to there team and make them play the games. Sikkim Colour Prediction Game On Sikkim Games you can play the Sikkim Colour Prediction Games in which you can either predict the Colours or the numbers as you can easily make your money 2X by predicting colours and 9X by predicting the numbers in less than 30 sec. Here, you can play Wingo, Trx Wingo, K3, 5D. On Sikkim App you can play many other games also like Aviator, Casino and many more games through which you can make daily huge money by investing your few seconds only. About SikkimThe Sikkim Colour Prediction app is an entertaining platform where users can predict the next winning colour or numbers. It is easy to play- simply choose a color you think will be selected, and if you are right you can easily double your money or even 10X in just 30sec. This app offers a simple way to pass the time while testing your luck. It is a popular way for those who enjoy casual games with a chance to win. Read More
Number assigned to Teams user is presenting INVITE wrong
I have a peculiar issue and I wonder if anyone else has had this issue or experienced anything similar.
At the tail end of migrating a company to Microsoft Teams voice, most of the issues have been rectified apart from two numbers. When ever we assign these numbers to a user, they cannot call out, assign a number and they work.
Immediately think its the SIP Provider, as in other cases the number has not been ported correctly. However from the investigation it seems on the INVITE as the number leaves teams, it is incorrect. On the offending number the P-ASSERTED-IDENTITY is showing as (tel:)
The working example given shows this as a SIP Record.
The CONTACT header is different. My Carrier has assured me the number is set up correctly and it this is coming from Teams
I have a peculiar issue and I wonder if anyone else has had this issue or experienced anything similar. At the tail end of migrating a company to Microsoft Teams voice, most of the issues have been rectified apart from two numbers. When ever we assign these numbers to a user, they cannot call out, assign a number and they work. Immediately think its the SIP Provider, as in other cases the number has not been ported correctly. However from the investigation it seems on the INVITE as the number leaves teams, it is incorrect. On the offending number the P-ASSERTED-IDENTITY is showing as (tel:)The working example given shows this as a SIP Record. The CONTACT header is different. My Carrier has assured me the number is set up correctly and it this is coming from Teams Read More
Use of Copilot to generate analytic reports from my tenancy
It would be useful to be able to use Copilot to generate usage/analytics reports from within my tenancy, without having to create Flows, PowerBI queries etc.
E.g. “Give me a list of all the files in SharePoint that have been shared with people from outside the organization. Include the date the share was created and the name of the person who created it. Tabulate these in an Excel spreadsheet.”
Try it for yourself, it doesn’t work. It gave me a small number of files in a table within the response window, and refuses to search beyond our ‘home’ SP site.
It would be useful to be able to use Copilot to generate usage/analytics reports from within my tenancy, without having to create Flows, PowerBI queries etc.E.g. “Give me a list of all the files in SharePoint that have been shared with people from outside the organization. Include the date the share was created and the name of the person who created it. Tabulate these in an Excel spreadsheet.”Try it for yourself, it doesn’t work. It gave me a small number of files in a table within the response window, and refuses to search beyond our ‘home’ SP site. Read More
Outlook search and other issues after Exchange 2019 CU14
Hi,
After Exchange 2019 CU14 users can’t:
– Search in cached mode.
– Open other users calendar.
– Set out of office.
All of the above works perfectly in OWA.
We did install the latest hotfix that should fix the search issue but no. We have installed latest outlook and reinstalled a computer, nothing helps.
Regards
Johan
Hi, After Exchange 2019 CU14 users can’t: – Search in cached mode.- Open other users calendar.- Set out of office. All of the above works perfectly in OWA. We did install the latest hotfix that should fix the search issue but no. We have installed latest outlook and reinstalled a computer, nothing helps. RegardsJohan Read More
How to recover deleted folder from OneDrive/sharepoint
I have synced my sharepoint folder in onedrive.
Onedrive was offline and not syncing with cloud due to some issue so reinstalled onedrive.
During installation i selected to sync existing directory.
After synchronization, one folder get removed from my onedrive. Is there any way to restore it ?
I have synced my sharepoint folder in onedrive.Onedrive was offline and not syncing with cloud due to some issue so reinstalled onedrive.During installation i selected to sync existing directory.After synchronization, one folder get removed from my onedrive. Is there any way to restore it ? Read More
Pipeline Error for SSIS
We are currently upgrading from a SQL 2012 Server to SQL 2022 on Windows Server 2022. We are using ODBC in SSIS to connect to an AS400 database. Our projects are currently set to a deployment version of SQL 2012. As long as we don’t change that setting, the packages run fine in Visual Studio 2019 with the latest SSIS extension. But, they do not work when deployed to SQL 2022.
When we deployed to our SQL 2022 server, or upgraded to a deployment server level of SQL 2019 or 2022 in Visual Studio, we received “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on xxxxx returned error code 0x80004005…” All parts of the data flow task have green check marks, but the DFT as a whole fails and the error is in the Progress tab.
Any ideas on what we can do to get this to work on our new server?
If we add a source without a destination, it doesn’t error out. As soon as we add any destination, the error occurs when deployed or when the project deployment server is set to SQL 2019 or higher. This makes sense to me since the pipeline probably isn’t initiated until a destination is added.
We are currently upgrading from a SQL 2012 Server to SQL 2022 on Windows Server 2022. We are using ODBC in SSIS to connect to an AS400 database. Our projects are currently set to a deployment version of SQL 2012. As long as we don’t change that setting, the packages run fine in Visual Studio 2019 with the latest SSIS extension. But, they do not work when deployed to SQL 2022. When we deployed to our SQL 2022 server, or upgraded to a deployment server level of SQL 2019 or 2022 in Visual Studio, we received “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on xxxxx returned error code 0x80004005…” All parts of the data flow task have green check marks, but the DFT as a whole fails and the error is in the Progress tab. Any ideas on what we can do to get this to work on our new server? If we add a source without a destination, it doesn’t error out. As soon as we add any destination, the error occurs when deployed or when the project deployment server is set to SQL 2019 or higher. This makes sense to me since the pipeline probably isn’t initiated until a destination is added. Read More
How to generate report of all distribution list usage over 90 days
Hello,
I am looking for an Exchange online Powershell script/command to run a report for how frequently all of our distribution lists are used over a 90 day period (if there is a way to generate the report in EAC that would be great too). I have found out how to run the report for 10 days, but I cannot find a command or way to generate further in the past. Any help would be appreciated, thank you.
Hello, I am looking for an Exchange online Powershell script/command to run a report for how frequently all of our distribution lists are used over a 90 day period (if there is a way to generate the report in EAC that would be great too). I have found out how to run the report for 10 days, but I cannot find a command or way to generate further in the past. Any help would be appreciated, thank you. Read More
Your thoughts serializing arrays to manage state in excel (by way of inventory tracking)
I’m curious what you all think of this approach for managing state in excel with minimal computational impact. I’m sure after a few thousand different items to track, performance may be implicated, but the formulas initially feel like they will create static values that don’t have to be recalculated with any frequency. Skip towards the end if you just want to see the formulas.
I think one of the important ideas here is that this formula can be used within a table column the same as any other formula that doesn’t return an array, the difference being that calculations are not lost between steps of the row and the only information a calculation needs is the limited state info in the prior state.
Any comments welcome. If you’ve found a better way to do this, I’d be curious to know. I am limiting myself to using only native excel formulas/functionality plus excel labs.
P.S. The formulas have one or two undeveloped ideas because they are not essential. For instance, there is one inline lambda that uses a switch to return a comparison function for data masking that has only implemented the equals and does not equal operators.
**********Description********************
General idea is such – write a series of formulas that serialize and deserialize arrays and combine it with an efficient mechanism to access the most recent state. The example uses the idea of lots of items where each lot has a quantity and cost – transactions can either increase the quantity (and cost) or decrease it. The state being managed is the existent lots, their quantities, and their costs.
columns are simple:
control; date; lot; qty; cost; state
So here is the overall structure:
table formula checks control column to see if the current row impacts the state –
if it doesn’t, return nothing,
if it does, move on
if it is the first control number, just serialize the row data
if it isn’t, find the prior state and update it
The way it updates the state is by
1) deserializing the prior state
2) determining whether the prior state already included the current row’s item
3) updating that value if so or just returning the current rows values,
4) filtering the prior state to remove the current row’s item
5) vstacking the filtered array onto the current row’s entry (potentially updated), and
6) serializing the current state.
Using 40 rows as an example, I might end with a serialized state that looks like this:
lot_H,65,650;lot_I,100,1000;lot_J,45,450;lot_K,70,700;lot_L,30,300;lot_A,135,1350;lot_B,150,1500;lot_C,145,1450;lot_D,90,900;lot_E,120,1200;lot_F,80,800;lot_G,170,1700
and deserializes to this:
lot_A 135 1350
lot_B 150 1500
lot_C 145 1450
lot_D 90 900
lot_E 120 1200
lot_F 80 800
lot_G 170 1700
lot_H 65 650
lot_I 100 1000
lot_J 45 450
lot_K 70 700
lot_L 30 300
using this function: SORT(array.deserialize_string(I57))
table formula:
=IF(
TRIM([@lot]) = “”,
“”,
IF(
[@control] = 1,
array.serialize_array(Table68[@[lot]:[cost]]),
LET(
current_trans, Table68[@[lot]:[cost]],
last_state_ctrl, MAX(
FILTER([control], ([control] < [@control]) * ([lot] <> “”) * (2025 <= [@date])),
1
),
last_state, XLOOKUP(last_state_ctrl, [control], [state], “”, 0),
array.serialize_array(array.track_state(array.deserialize_string(last_state), current_trans))
)
)
)
module formulas:
deserialize_string = LAMBDA(state_string, TEXTSPLIT(state_string, “,”, “;”, FALSE));
serialize_row = LAMBDA(row, TEXTJOIN(“,”, FALSE, row));
serialize_array = LAMBDA(state_array,
REDUCE(
,
BYROW(state_array, LAMBDA(r, serialize_row(r))),
LAMBDA(acc, current_row, acc & “;” & current_row)
)
);
serialized_wrapper = lambda(state_string, func_to_apply, serialize_array(func_to_apply(deserialize_string(state_string))));
replace_row =
lambda(
new_row,
original_array,
[replacement_col_idx],
let(
idx_col, if(isomitted(replacement_col_idx), 1, replacement_col_idx),
data_mask, choosecols(new_row, idx_col) <> choosecols(original_array,idx_col),
filtered_array, filter(original_array, data_mask),
hstack(filtered_array, replace_row)
)
);
columnMask =
lambda(
value,
comp_to_array,
[comparison_operator],
[column_idx],
[value_idx],
let(
operator, if(isomitted(comparison_operator),”=”,comparison_operator),
comp_func, lambda(operator, lambda(value, comp_array, switch(operator, “=”, value=comp_array, “<>”, value<>comp_array,”Not yet implimented”))),
col_idx, if(isomitted(column_idx), 1, column_idx),
val_idx, if(isomitted(value_idx), 1, value_idx),
adj_value, if(COLUMNS(value)>1, CHOOSECOLS(value, val_idx), value),
comp_col, choosecols(comp_to_array, col_idx),
comp_func(operator)(adj_value, comp_col)
)
);
track_state =
lambda(
last_state_string, current_trans,
LET(
lots, array.deserialize_string(last_state_string),
lot_to_add, INDEX(current_trans, 1, 1),
prior_lot_values, IFERROR(
FILTER(lots, array.columnMask(lot_to_add, lots), ERROR.TYPE(3)),
ERROR.TYPE(3)
),
filtered_array, FILTER(lots, array.columnMask(lot_to_add, lots, “<>”), ERROR.TYPE(3)),
replacement_line, IF(
ISNA(prior_lot_values),
current_trans,
HSTACK(
lot_to_add,
(INDEX(prior_lot_values, 1, 2) + INDEX(current_trans, 1, 2)),
(INDEX(prior_lot_values, 1, 3) + INDEX(current_trans, 1, 3))
)
),
final_array, IF(
OR(TRIM(last_state_string) = “”),
replacement_line,
IF(OR(ISNA(filtered_array)), replacement_line, VSTACK(filtered_array, replacement_line))
),
final_array
)
);
I’m curious what you all think of this approach for managing state in excel with minimal computational impact. I’m sure after a few thousand different items to track, performance may be implicated, but the formulas initially feel like they will create static values that don’t have to be recalculated with any frequency. Skip towards the end if you just want to see the formulas. I think one of the important ideas here is that this formula can be used within a table column the same as any other formula that doesn’t return an array, the difference being that calculations are not lost between steps of the row and the only information a calculation needs is the limited state info in the prior state.Any comments welcome. If you’ve found a better way to do this, I’d be curious to know. I am limiting myself to using only native excel formulas/functionality plus excel labs. P.S. The formulas have one or two undeveloped ideas because they are not essential. For instance, there is one inline lambda that uses a switch to return a comparison function for data masking that has only implemented the equals and does not equal operators. **********Description******************** General idea is such – write a series of formulas that serialize and deserialize arrays and combine it with an efficient mechanism to access the most recent state. The example uses the idea of lots of items where each lot has a quantity and cost – transactions can either increase the quantity (and cost) or decrease it. The state being managed is the existent lots, their quantities, and their costs. columns are simple:control; date; lot; qty; cost; state So here is the overall structure:table formula checks control column to see if the current row impacts the state – if it doesn’t, return nothing, if it does, move on if it is the first control number, just serialize the row data if it isn’t, find the prior state and update it The way it updates the state is by1) deserializing the prior state2) determining whether the prior state already included the current row’s item3) updating that value if so or just returning the current rows values,4) filtering the prior state to remove the current row’s item5) vstacking the filtered array onto the current row’s entry (potentially updated), and6) serializing the current state. Using 40 rows as an example, I might end with a serialized state that looks like this:lot_H,65,650;lot_I,100,1000;lot_J,45,450;lot_K,70,700;lot_L,30,300;lot_A,135,1350;lot_B,150,1500;lot_C,145,1450;lot_D,90,900;lot_E,120,1200;lot_F,80,800;lot_G,170,1700and deserializes to this: lot_A 135 1350lot_B 150 1500lot_C 145 1450lot_D 90 900lot_E 120 1200lot_F 80 800lot_G 170 1700lot_H 65 650lot_I 100 1000lot_J 45 450lot_K 70 700lot_L 30 300 using this function: SORT(array.deserialize_string(I57)) table formula:
=IF(
TRIM([@lot]) = “”,
“”,
IF(
[@control] = 1,
array.serialize_array(Table68[@[lot]:[cost]]),
LET(
current_trans, Table68[@[lot]:[cost]],
last_state_ctrl, MAX(
FILTER([control], ([control] < [@control]) * ([lot] <> “”) * (2025 <= [@date])),
1
),
last_state, XLOOKUP(last_state_ctrl, [control], [state], “”, 0),
array.serialize_array(array.track_state(array.deserialize_string(last_state), current_trans))
)
)
)
module formulas:
deserialize_string = LAMBDA(state_string, TEXTSPLIT(state_string, “,”, “;”, FALSE));
serialize_row = LAMBDA(row, TEXTJOIN(“,”, FALSE, row));
serialize_array = LAMBDA(state_array,
REDUCE(
,
BYROW(state_array, LAMBDA(r, serialize_row(r))),
LAMBDA(acc, current_row, acc & “;” & current_row)
)
);
serialized_wrapper = lambda(state_string, func_to_apply, serialize_array(func_to_apply(deserialize_string(state_string))));
replace_row =
lambda(
new_row,
original_array,
[replacement_col_idx],
let(
idx_col, if(isomitted(replacement_col_idx), 1, replacement_col_idx),
data_mask, choosecols(new_row, idx_col) <> choosecols(original_array,idx_col),
filtered_array, filter(original_array, data_mask),
hstack(filtered_array, replace_row)
)
);
columnMask =
lambda(
value,
comp_to_array,
[comparison_operator],
[column_idx],
[value_idx],
let(
operator, if(isomitted(comparison_operator),”=”,comparison_operator),
comp_func, lambda(operator, lambda(value, comp_array, switch(operator, “=”, value=comp_array, “<>”, value<>comp_array,”Not yet implimented”))),
col_idx, if(isomitted(column_idx), 1, column_idx),
val_idx, if(isomitted(value_idx), 1, value_idx),
adj_value, if(COLUMNS(value)>1, CHOOSECOLS(value, val_idx), value),
comp_col, choosecols(comp_to_array, col_idx),
comp_func(operator)(adj_value, comp_col)
)
);
track_state =
lambda(
last_state_string, current_trans,
LET(
lots, array.deserialize_string(last_state_string),
lot_to_add, INDEX(current_trans, 1, 1),
prior_lot_values, IFERROR(
FILTER(lots, array.columnMask(lot_to_add, lots), ERROR.TYPE(3)),
ERROR.TYPE(3)
),
filtered_array, FILTER(lots, array.columnMask(lot_to_add, lots, “<>”), ERROR.TYPE(3)),
replacement_line, IF(
ISNA(prior_lot_values),
current_trans,
HSTACK(
lot_to_add,
(INDEX(prior_lot_values, 1, 2) + INDEX(current_trans, 1, 2)),
(INDEX(prior_lot_values, 1, 3) + INDEX(current_trans, 1, 3))
)
),
final_array, IF(
OR(TRIM(last_state_string) = “”),
replacement_line,
IF(OR(ISNA(filtered_array)), replacement_line, VSTACK(filtered_array, replacement_line))
),
final_array
)
); Read More
Partner Blog | IDC study on partner profitability with Microsoft AI
Microsoft Tech Community – Latest Blogs –Read More
How to change date & year setting for timeline slicer after using pivot table
I have a data from October 2023, but when I am using timeline slicer, it shows me from Jan 2023. I want to fix this.
I have a data from October 2023, but when I am using timeline slicer, it shows me from Jan 2023. I want to fix this. Read More
More menu missing when viewing app on iOS
I have a static tab app where I have noticed that the more menu (i.e. the ellipsis at the top right of the screen) is no longer appearing when running the app in Teams in iOS. The more menu appears in the app in Android, desktop, and web. I looked at another static app I created and observe the same.
Is this a change in Teams for iOS? If so, how do users navigate to the About or reload functionalities?
I have a static tab app where I have noticed that the more menu (i.e. the ellipsis at the top right of the screen) is no longer appearing when running the app in Teams in iOS. The more menu appears in the app in Android, desktop, and web. I looked at another static app I created and observe the same.Is this a change in Teams for iOS? If so, how do users navigate to the About or reload functionalities? Read More
Entra ID Group Writeback Option Missing from Portal Web Interface
Yesterday in the middle of the day, the group writeback option for Azure AD (Entra ID) security groups and M365 groups was removed from the properties section for each group. (It’s normally below the “Microsoft Entra roles can be assigned to the group” y/n). This is regardless of whether you utilize portal.azure.com or entra.microsoft.com.
I had connected to the portal earlier in the day and saw it, then re-authed later in the day and it was gone for all groups. This was verified by a co-worker.
You can still see the writeback option via the group ‘list’ by adding the writeback column (i.e. Home -> Groups -> All Groups -> Manage View -> Edit Columns), but I’m curious if this was an intended change? I’ve heard that group writeback support might be going away from Entra ID Connect in favor of Entra Cloud Sync, but that shouldn’t affect the actual group attribute for the writeback status within the Azure portal.
When searching, I haven’t found anything mentioning the change so I was curious if anyone knew something that I couldn’t find.
Thanks.
Yesterday in the middle of the day, the group writeback option for Azure AD (Entra ID) security groups and M365 groups was removed from the properties section for each group. (It’s normally below the “Microsoft Entra roles can be assigned to the group” y/n). This is regardless of whether you utilize portal.azure.com or entra.microsoft.com. I had connected to the portal earlier in the day and saw it, then re-authed later in the day and it was gone for all groups. This was verified by a co-worker. You can still see the writeback option via the group ‘list’ by adding the writeback column (i.e. Home -> Groups -> All Groups -> Manage View -> Edit Columns), but I’m curious if this was an intended change? I’ve heard that group writeback support might be going away from Entra ID Connect in favor of Entra Cloud Sync, but that shouldn’t affect the actual group attribute for the writeback status within the Azure portal. When searching, I haven’t found anything mentioning the change so I was curious if anyone knew something that I couldn’t find. Thanks. Read More
Apparent MX issue impacting only one email account and only if sourced from OUTLOOK.COM
I have had an issue for years with email not being received to my Godaddy registered domain with an email hosted by Google. The common element is that the non-received emails are all sent from OUTLOOK.COM. These messages are not received in my inbox or spam. If I log into OUTLOOK.COM using that email address as the UID I see a blank screen, no sent or received emails at all. From my perspective, this seems to be an internal OUTLOOK.COM MX misconfiguration. Has anyone seen anything like this before? Who should I contact to try to resolve this issue?
PS: As a test to prove this issue, I would appreciate someone from the community to source an email from OUTLOOK.COM to two different emails on the domain; one will be received, and the other will not. Let me know if you would be willing to help me test this, and I will PM a reply with the email addresses.
Thanks
I have had an issue for years with email not being received to my Godaddy registered domain with an email hosted by Google. The common element is that the non-received emails are all sent from OUTLOOK.COM. These messages are not received in my inbox or spam. If I log into OUTLOOK.COM using that email address as the UID I see a blank screen, no sent or received emails at all. From my perspective, this seems to be an internal OUTLOOK.COM MX misconfiguration. Has anyone seen anything like this before? Who should I contact to try to resolve this issue? PS: As a test to prove this issue, I would appreciate someone from the community to source an email from OUTLOOK.COM to two different emails on the domain; one will be received, and the other will not. Let me know if you would be willing to help me test this, and I will PM a reply with the email addresses. Thanks Read More
I2C WriteRead with no restart, IoT libraries and FT4232H device
Hi everyone,
I am porting an app and trying to use the FTDI Ft4232H device to communicate to some I2C devices.
When I use the “old” dongle(going to be obsolete) and I2C call to the device, I get the correct transaction and read results from the device.
However, when I use the IoT libraries and the “WriteRead” command to do the same thing, the library issues a restart and the transaction fails.
Can anyone help or point me to:
A library that does a correct multi byte read without a restart?A way to do this with the current IoT libraries?
Here are the “using” statements in my C# code:
using Iot.Device.FtCommon;
using Iot.Device.Ft4232H;
using System.Device.I2c;
Cheers,
Steve
Hi everyone,I am porting an app and trying to use the FTDI Ft4232H device to communicate to some I2C devices.When I use the “old” dongle(going to be obsolete) and I2C call to the device, I get the correct transaction and read results from the device. However, when I use the IoT libraries and the “WriteRead” command to do the same thing, the library issues a restart and the transaction fails.Can anyone help or point me to:A library that does a correct multi byte read without a restart?A way to do this with the current IoT libraries?Here are the “using” statements in my C# code:using Iot.Device.FtCommon;using Iot.Device.Ft4232H;using System.Device.I2c; Cheers,Steve Read More
Using microsoft graph to pull calendar data weekly
Hello- I’ve building an app that requests calendar access from users with Graph API. I am hoping to request permissions once and then pull calendar data weekly but I’m not sure if this is possible. I’m using the python ms-graph sdk and the interactive authentication client to request access. I am seeing some things about offline_access scope providing a refresh token but unsure how it works and the docs I found haven’t been helpful. Any help would be appreciated!
Hello- I’ve building an app that requests calendar access from users with Graph API. I am hoping to request permissions once and then pull calendar data weekly but I’m not sure if this is possible. I’m using the python ms-graph sdk and the interactive authentication client to request access. I am seeing some things about offline_access scope providing a refresh token but unsure how it works and the docs I found haven’t been helpful. Any help would be appreciated! Read More
Azure AD-Connect Staging Mode server not kept in sync
I have a test environment where the Staging Mode server was not kept up to date with the Active Azure AD-Connect server. When I export the configs on each and compare the 2, there are some major differences. Is there a way I can just import the config from the Active server and place it on the Staging server so they get back to the same configuration?
Alternatively, can I uninstall the staging server then re-install / import the configuration from the Active server?
I have a test environment where the Staging Mode server was not kept up to date with the Active Azure AD-Connect server. When I export the configs on each and compare the 2, there are some major differences. Is there a way I can just import the config from the Active server and place it on the Staging server so they get back to the same configuration? Alternatively, can I uninstall the staging server then re-install / import the configuration from the Active server? Read More
Construction Startup Scales Operations with AI
Welcome back to Grow Your Business with Microsoft 365 Copilot, your monthly resource for actionable insights to harness the power of AI at small and medium sized business. In this edition, we look through the lens of a startup construction company using Copilot to revolutionize their operations. Did you know there are nearly half a million small and medium-sized trade contractor businesses, in the United States alone, with most firms having fewer than five employees? Limited resources can make completing administrative, project, and operational tasks a challenge, especially for small teams. But what if AI can take the pressure off by handling routine tasks, freeing up time to take on more projects and complete them faster?
How Copilot helps the construction industry scale for growth
We spoke with Nick Masci, principal and co-founder of the Boston-based startup, Industrialized Construction Group (ICG), about the hurdles they faced and the wins gained after incorporating Microsoft 365 Copilot into their daily workflow.
In the dynamic world of construction, ICG stands out by blending traditional methods with advanced manufacturing techniques. This innovative approach not only speeds up construction timelines but also enhances safety and efficiency. ICG’s top challenge was scaling for growth, when growth requires time spent out in the field, talking with customers, and orchestrating complex projects. ICG found that they were bogged down with inefficiencies in extensive documentation and high-volume data management, making accuracy difficult to achieve. Ensuring effective communication and collaboration among team members, especially in a hybrid work environment, was tricky and often resulted in miscommunication and project delays.
To ease these pains and transform business operations, ICG now leverages Microsoft 365 Copilot to speed creating customer proposals, reduce time on reporting, and more effectively manage projects.
Simplified customer proposals
Creating customer proposals was time-consuming and inefficient, often requiring extensive manual effort and coordination. Manual effort also impacted the quality and consistency.. Using Copilot for customer proposals in construction projects has proven to be highly beneficial for ICG. Copilot can assist in generating comprehensive and professional content in apps like Word and PowerPoint, reference files and content like past engagements and proposals, as well as bring in information from the web to add context to its responses and the content that it creates. With Copilot in Excel, Copilot can help interpret the data and create visuals and analyses to help employees get insights quickly and focus on ensuring that proposals are thorough and polished. Microsoft 365 Copilot has helped speed up the proposal process (up to six times faster) and improved their quality and professionalism.
Accelerated customer reporting
Generating customer reports was another lengthy process—with a single report sometimes taking up to eight hours and involving three people. Managing and compiling data from various sources led to inconsistencies and errors, affecting report quality and diverting resources from critical tasks. ICG to simplify reporting by. Business Chat can find and analyze the many sources of customer data, across work content, chats, emails, and files, and create first drafts of reports. Microsoft 365 Copilot helped reduce the time of customer reporting (up to half), thereby increasing ICG’s responsiveness and quality of customer service.
A screenshot of Microsoft 365 Copilot Business Chat
Improving project management
ICG faced frequent project delays due to inefficient communication and coordination among teams. The lack of real-time updates and fragmented communication channels led to misunderstandings and slowed down decision-making processes. Collaboration across different departments and project sites was challenging, with teams often working in silos, making it difficult to share information and collaborate effectively. With Copilot in Teams, you can pull insights from project huddles so you can quickly get key decisions and action items. With Copilot in Outlook, you can summarize long project email threads, helping you get right to what you need to respond to.
A screenshot of Copilot in Teams showing a meeting recap and answering questions about the meeting
By leveraging Microsoft 365 Copilot, ICG has significantly transformed their business operations with streamlined processes, enhanced productivity, and improved communication. “Our work must scale to an audience and customer base that is 1,000 times larger than it is today,” says Masci. “We want the suite of Microsoft products to not only grow with us, but to also anticipate our needs.”
We are thrilled to see ICG and other companies revolutionize the construction industry with AI. By integrating Microsoft 365 Copilot, ICG has set a new standard for productivity and innovation. As the industry evolves, AI will be key to competitive advantage and growth.
Tune in next month for another example of how Copilot helps unlock more value and opportunity. If your company has used Copilot for Microsoft 365 to grow and you’d like to share your story, we’d love to feature you! Comment below to let us know you’re interested and a member from our team will get in touch!
Take action! Try out some of the ways ICG used Microsoft 365 Copilot:
Maximize the full power of Copilot in Word
Learn how to leverage Copilot to generate customer proposals and more sales-related activities.
Read the full ICG case study on Microsoft.com
Become a power user of Microsoft 365 Copilot:
(New every week) Try a new proven Copilot productivity tip to get time back for more important work.
(new) Get your one-stop guide to successfully deploy Copilot with the Copilot Success Kit.
(new) Check out the new Mechanics video that goes over simple steps to check your data permissions are in place
Join the SMB Copilot Community to learn directly from Microsoft experts and your peers.
Here’s the latest news on how Microsoft 365 Copilot can accelerate your business
Earlier this week, Satya Nadella and Jared Spataro launched Wave Two of Copilot. Powered by customer feedback, we’re bringing together web + work + Pages as a completely new design system for work. Here is a rundown of key new features announced for every SMB:
Microsoft 365 Copilot Business Chat combines the latest information on the web and your data in the Microsoft Graph to find you the answers you need. The newly introduced Copilot Pages provides a new canvas for you to retain Copilot responses to simplify sharing, editing, and collaborating with them.
Copilot in Excel is now generally available. Additionally, Copilot in Excel with Python was introduced as a no-code way for you to perform advanced analysis with Copilot.
Narrative Builder in Copilot in PowerPoint helps you create first drafts, also being able to use your company templates to keep things on-brand.
Copilot in Teams will soon be able to reason over both the meeting transcript and meeting chat, so you never miss a note or action item from your meetings.
“Prioritize my inbox” feature coming to Copilot in Outlook helps you stay on top of your most important emails by prioritizing them based on your organizational context and content.
Copilot agents are here to help you coordinate line of business tools and orchestrate your business from a single place. They help you integrate your third-party tools, so Copilot respond based on that external data.
Check out the full details of the announcement and launch event.
Angela Byers
Microsoft
Senior Director, Copilot & Growth Marketing for SMB
Let’s connect on LinkedIn
Meet the team
The monthly series, Grow Your Business with Copilot for Microsoft 365, is brought to you by the SMB Copilot marketing team at Microsoft. From entrepreneurs to coffee connoisseurs, they work passionately behind the scenes, sharing the magic of Copilot products with small and medium businesses everywhere. Always ready with a smile, a helping hand, and a clever campaign, they’re passionate about helping YOUR business grow!
From left to right: An image of the SMB Copilot team at Microsoft, with Angela Byers, Mariana Prudencio, Elif Algedik, Kayla Patterson, Briana Taylor, and Gabe Ho.
About the blog
Welcome to “Grow Your Business with Microsoft 365 Copilot,” where we aim to inspire and delight you with insights and stories on how AI is changing the game for business. This monthly series is designed to empower small and mid-sized businesses to harness the power of AI at work. Each month, we feature scenarios where an SMB is using AI to transform, scale, and grow.
Microsoft Tech Community – Latest Blogs –Read More
WAC Future
I’m curious what the future of Windows Admin Center is?
Looking at some of the extensions like Active Directory, DNS, and DHCP you don’t get a lot of feature parity with their MMC counterparts. With Linux available in just about every environment, will there every be in the future a way to manage them inside of the admin center?
Will be the best way to manage this is through Azure instead of the On-Premises Windows Admin Center.
Thanks.
I’m curious what the future of Windows Admin Center is? Looking at some of the extensions like Active Directory, DNS, and DHCP you don’t get a lot of feature parity with their MMC counterparts. With Linux available in just about every environment, will there every be in the future a way to manage them inside of the admin center? Will be the best way to manage this is through Azure instead of the On-Premises Windows Admin Center. Thanks. Read More
Changing font size for Slicer & Timeline
How can I change font size for slicer & timeline after using pivot tables?
I am creating a dashboard and when excel sheet is at 40% zoom, it becomes near impossible to see the font size of slicer & timeline function
How can I change font size for slicer & timeline after using pivot tables?I am creating a dashboard and when excel sheet is at 40% zoom, it becomes near impossible to see the font size of slicer & timeline function Read More
