I have this sheet formatted so that cell 34 is performing a calculation on cells C28-C33 and then adding the sums of those calculations. Cell C46 is then dividing cell 34 by row C25. The same pattern is used across the columns, and for each person in the list (Person A, B, C, and D). In the “Team Total Section”, everyone’s numbers for each task are added together (eg. cell C10,20,30,and 40 are added in cell C50), and then row 54 perform calculations on rows 48-53 and adds the output of the calculations. Finally, row 56 divides row 54 by row 55. 

I want to write a macro that can continuously add space for new team members with all the appropriate formulas set up to calculate the totals and percent utilization for the new team members and then factor those team members’ numbers into the calculations for team totals. I’ve been able to write a pair of macros that can successfully do this once (eg. add one new team member and account for their totals in the Team Totals), but can’t get it to automatically update to include more than one new team member in the “Team Totals” calculations. The formulas don’t automatically expand to include the new cells that are added, so the calculation just reflects the totals of the old team members and the most recent one to be added. Help would be much appreciated. 

If it helps, here are the pair of macros that I’ve used to 1) add a single new team member and then 2)update the team totals: 

Sub Add_Team_Member()
‘
‘ Add_Team_Member Macro
‘

‘
Rows(“7:16”).Select
Selection.Copy
ActiveWindow.ScrollRow = 7
ActiveWindow.ScrollRow = 9
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollRow = 11
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollRow = 13
ActiveWindow.ScrollRow = 14
ActiveWindow.ScrollRow = 15
ActiveWindow.ScrollRow = 16
ActiveWindow.ScrollRow = 18
ActiveWindow.ScrollRow = 19
ActiveWindow.ScrollRow = 20
ActiveWindow.ScrollRow = 21
ActiveWindow.ScrollRow = 22
ActiveWindow.ScrollRow = 23
ActiveWindow.ScrollRow = 24
ActiveWindow.ScrollRow = 25
ActiveWindow.ScrollRow = 26
ActiveWindow.ScrollRow = 27
ActiveWindow.ScrollRow = 28
ActiveWindow.ScrollRow = 29
ActiveWindow.ScrollRow = 30
ActiveWindow.ScrollRow = 31
ActiveWindow.ScrollRow = 32
ActiveWindow.ScrollRow = 33
ActiveWindow.ScrollRow = 34
Rows(“47:47”).Select
Selection.Insert Shift:=xlDown
Range(“A47:H47”).Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = “”
Range(“A54:B54”).Select
ActiveCell.FormulaR1C1 = “Total – “
Range(“C48:K53”).Select
Selection.ClearContents
Range(“C55:K55”).Select
Selection.ClearContents
Range(“A47:H47”).Select
ActiveCell.FormulaR1C1 = “New Team Member”
Range(“A54:B54”).Select
ActiveCell.FormulaR1C1 = “Total – New Team Member”
Range(“K54”).Select
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
End Sub

—-

Sub Update_Team_Totals()
‘
‘ Update_Team_Totals Macro
‘

‘
Application.Run “‘OnCore Workload Aug 15_messingwith.xlsm’!Add_Team_Member”
ActiveWindow.ScrollRow = 35
ActiveWindow.ScrollRow = 36
ActiveWindow.ScrollRow = 37
ActiveWindow.ScrollRow = 38
ActiveWindow.ScrollRow = 39
ActiveWindow.ScrollRow = 40
ActiveWindow.ScrollRow = 41
ActiveWindow.ScrollRow = 42
ActiveWindow.ScrollRow = 43
ActiveWindow.ScrollRow = 44
ActiveWindow.ScrollRow = 45
ActiveWindow.ScrollRow = 46
ActiveWindow.ScrollRow = 47
ActiveWindow.ScrollRow = 46
ActiveWindow.ScrollRow = 45
ActiveWindow.ScrollRow = 44
ActiveWindow.ScrollRow = 43
ActiveWindow.ScrollRow = 42
ActiveWindow.ScrollRow = 43
Range(“K58”).Select
ActiveCell.FormulaR1C1 = “=R[-50]C+R[-40]C+R[-30]C+R[-20]C+R[-10]C”
Range(“K58”).Select
Selection.AutoFill Destination:=Range(“K58:K63”), Type:=xlFillDefault
Range(“K58:K63”).Select
Range(“K65”).Select
ActiveCell.FormulaR1C1 = “=R[-50]C+R[-40]C+R[-30]C+R[-20]C+R[-10]C”
Range(“N64”).Select
End Sub

​I have this sheet formatted so that cell 34 is performing a calculation on cells C28-C33 and then adding the sums of those calculations. Cell C46 is then dividing cell 34 by row C25. The same pattern is used across the columns, and for each person in the list (Person A, B, C, and D). In the “Team Total Section”, everyone’s numbers for each task are added together (eg. cell C10,20,30,and 40 are added in cell C50), and then row 54 perform calculations on rows 48-53 and adds the output of the calculations. Finally, row 56 divides row 54 by row 55.  I want to write a macro that can continuously add space for new team members with all the appropriate formulas set up to calculate the totals and percent utilization for the new team members and then factor those team members’ numbers into the calculations for team totals. I’ve been able to write a pair of macros that can successfully do this once (eg. add one new team member and account for their totals in the Team Totals), but can’t get it to automatically update to include more than one new team member in the “Team Totals” calculations. The formulas don’t automatically expand to include the new cells that are added, so the calculation just reflects the totals of the old team members and the most recent one to be added. Help would be much appreciated.  If it helps, here are the pair of macros that I’ve used to 1) add a single new team member and then 2)update the team totals: Sub Add_Team_Member()
‘
‘ Add_Team_Member Macro
‘

‘
Rows(“7:16”).Select
Selection.Copy
ActiveWindow.ScrollRow = 7
ActiveWindow.ScrollRow = 9
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollRow = 11
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollRow = 13
ActiveWindow.ScrollRow = 14
ActiveWindow.ScrollRow = 15
ActiveWindow.ScrollRow = 16
ActiveWindow.ScrollRow = 18
ActiveWindow.ScrollRow = 19
ActiveWindow.ScrollRow = 20
ActiveWindow.ScrollRow = 21
ActiveWindow.ScrollRow = 22
ActiveWindow.ScrollRow = 23
ActiveWindow.ScrollRow = 24
ActiveWindow.ScrollRow = 25
ActiveWindow.ScrollRow = 26
ActiveWindow.ScrollRow = 27
ActiveWindow.ScrollRow = 28
ActiveWindow.ScrollRow = 29
ActiveWindow.ScrollRow = 30
ActiveWindow.ScrollRow = 31
ActiveWindow.ScrollRow = 32
ActiveWindow.ScrollRow = 33
ActiveWindow.ScrollRow = 34
Rows(“47:47”).Select
Selection.Insert Shift:=xlDown
Range(“A47:H47”).Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = “”
Range(“A54:B54”).Select
ActiveCell.FormulaR1C1 = “Total – “
Range(“C48:K53”).Select
Selection.ClearContents
Range(“C55:K55”).Select
Selection.ClearContents
Range(“A47:H47”).Select
ActiveCell.FormulaR1C1 = “New Team Member”
Range(“A54:B54”).Select
ActiveCell.FormulaR1C1 = “Total – New Team Member”
Range(“K54”).Select
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
End Sub—-Sub Update_Team_Totals()
‘
‘ Update_Team_Totals Macro
‘

‘
Application.Run “‘OnCore Workload Aug 15_messingwith.xlsm’!Add_Team_Member”
ActiveWindow.ScrollRow = 35
ActiveWindow.ScrollRow = 36
ActiveWindow.ScrollRow = 37
ActiveWindow.ScrollRow = 38
ActiveWindow.ScrollRow = 39
ActiveWindow.ScrollRow = 40
ActiveWindow.ScrollRow = 41
ActiveWindow.ScrollRow = 42
ActiveWindow.ScrollRow = 43
ActiveWindow.ScrollRow = 44
ActiveWindow.ScrollRow = 45
ActiveWindow.ScrollRow = 46
ActiveWindow.ScrollRow = 47
ActiveWindow.ScrollRow = 46
ActiveWindow.ScrollRow = 45
ActiveWindow.ScrollRow = 44
ActiveWindow.ScrollRow = 43
ActiveWindow.ScrollRow = 42
ActiveWindow.ScrollRow = 43
Range(“K58”).Select
ActiveCell.FormulaR1C1 = “=R[-50]C+R[-40]C+R[-30]C+R[-20]C+R[-10]C”
Range(“K58”).Select
Selection.AutoFill Destination:=Range(“K58:K63”), Type:=xlFillDefault
Range(“K58:K63”).Select
Range(“K65”).Select
ActiveCell.FormulaR1C1 = “=R[-50]C+R[-40]C+R[-30]C+R[-20]C+R[-10]C”
Range(“N64”).Select
End Sub  Read More

​

Você já pensou em criar suas próprias aplicações de Inteligência Artificial utilizando JavaScript? Porém, não sabe como dar os primeiros passos?

O time de Advocacia de JavaScript gostaria de te convidar para o curso gratuito de: Generative AI with JavaScript!

Neste artigo, estarei explorando um pouco mais sobre o curso e como você pode pontencializar suas habilidades de desenvolvimento com JavaScript com IA!

Generative AI with JavaScript – O curso que você estava esperando!

Como já dito, a série de vídeos Generative AI com JavaScript cobre tudo que você precisa saber sobre o uso de IA com JavaScript. Desde os fundamentos dos Modelos de Linguagem Extensos (LLMs) até a criação de aplicações completas, incluindo técnicas para melhorar a precisão e confiabilidade das respostas com o Retrieval-Augmented Generation (RAG) e o uso de frameworks como o LangChain.js.

Abaixo, segue um resumo de cada episódio para você acompanhar. Vejamos agora um overview de cada um dos episódios:

LLMs: Fundamentos e Funcionamento

Nesse vídeo você aprenderá: O que são Grandes Modelos de Linguagem (LLMs), como são treinados, funcionam e quais são suas limitações.

Técnicas Essenciais de Prompt Engineering

Nesse vídeo você aprenderá como estruturar perguntas e prompts para obter os melhores resultados dos modelos de IA

Aumente a precisão e a confiabilidade da IA com o RAG

Nesse vídeo você aprenderá como usar dados específicos para gerar respostas personalizadas com a técnica de Retrieval-Augmented Generation.

Acelere seu desenvolvimento de IA com o LangChain.js

Nesse vídeo você aprenderá como conceitos do LangChain.js e como ele pode acelerar o desenvolvimento de aplicações de IA.

Execute modelos de IA em sua máquina local com o Ollama

Nesse vídeo você aprenderá como integrar modelos de IA locais no seu fluxo de desenvolvimento para testes e execuções.

Comece a usar IA gratuitamente usando o Phi-3

Nesse vídeo você aprenderá a como experimentar modelos gratuitos diretamente no navegador com o Ollama e Phi-3.

Introdução a Azure AI Studio

Nesse vídeo você aprenderá a como utilizar o Azure AI Studio para criar e treinar modelos de IA na nuvem.

Criação de Aplicações de IA generativa com o Azure Cosmos DB

Nesse vídeo você aprenderá a como utilizar o Azure Cosmos DB para armazenar dados e fazer pesquisas vetoriais em aplicações de IA.

Ferramentas e serviços do Azure para hospedagem e armazenamento de aplicativos de IA

Nesse vídeo você aprenderá a como utilizar os serviços do Azure para hospedar, armazenar e escalar aplicações de IA.

Streaming de Resultados com AI Chat Protocol

Nesse vídeo você aprenderá a como integrar funcionalidades de streaming nas suas aplicações de IA usando o AI Chat Protocol.

Como usar o repositório do curso?

Sim! O curso além de ser gratuito, dispoe de um repositório no GitHub com todo o material necessário.

Você vai encontrar códigos de exemplo, tutoriais, slides e scripts que facilitam o acompanhamento do conteúdo. Recomendamos abrir o projeto no GitHub Codespaces para começar a praticar imediatamente.

Assim sendo você encontrará:

Sessões: Cada sessão do repositório contém descrições, links de recursos e scripts para você acompanhar.

Slides e Demos: Utilize os slides e as demonstrações das sessões para aprender mais sobre os conteúdos ensinados no curso.

Tutoriais Hands-On: Tutoriais detalhados para você aprender práticas recomendadas e aplicar conceitos de IA.

Comece Agora!

O repositório também fornece “quickstarts” para quem deseja começar a programar com JavaScript com IA:

Phi-3 no Navegador: Execute diretamente no navegador (conta GitHub necessária).

GitHub Models: Acesse modelos diretamente no seu navegador após o beta público.

Azure OpenAI: Utilize a conta gratuita da Azure para começar a usar a OpenAI.

Exemplos de Códigos e Aplicações de JavaScript com IA

O repositório conta também com exemplos de códigos e aplicações práticas de JavaScript com IA. Você pode acessar diretamente no repositório do curso no GitHub

Conclusão

Quer desenvolver habilidades essenciais em IA usando JavaScript? A série Generative AI with JavaScript oferece uma oportunidade única para aprender de forma prática, utilizando ferramentas amplamente conhecidas pelos desenvolvedores.

De práticas de prompt engineering, você poderá aprender como criar aplicações de ponta. Além disso, a integração com serviços da Azure permitirá aumentar o potencial de suas soluções.

Assista agora mesmo a série completa e transforme suas ideias em soluções inteligentes com JavaScript e IA!

Não perca tempo, comece agora e desvende o poder da IA com JavaScript!

E nos vemos no próximo artigo! 😎

​Microsoft Tech Community – Latest Blogs –Read More 

Tengo un problema enorme y es que no puedo iniciar sesión en mi cuenta de Outlook la cual tengo relacionada a Authenticator, me dice que me va a llegar un código y nunca me llega doy para ingresar el código manual y al ingresar el que me arroja en la app me dice que el código es erróneo, y no puedo montar un ticket porque para ello necesitaría iniciar sesión en la cuenta, y hablando con los soportes de chat no me dan una solución, soy de Colombia alguien me puede ayudar.

​Tengo un problema enorme y es que no puedo iniciar sesión en mi cuenta de Outlook la cual tengo relacionada a Authenticator, me dice que me va a llegar un código y nunca me llega doy para ingresar el código manual y al ingresar el que me arroja en la app me dice que el código es erróneo, y no puedo montar un ticket porque para ello necesitaría iniciar sesión en la cuenta, y hablando con los soportes de chat no me dan una solución, soy de Colombia alguien me puede ayudar.  Read More

​

Health and Life Sciences Fabric User Group present:

Healthcare Data Solutions in Fabric

Live webinar

Tuesday, October 29

10:30-11:30 AM ET

Register here

​Microsoft Tech Community – Latest Blogs –Read More 

Description: I’m working on a PowerShell script to initiate and auto-answer VOIP calls using the Microsoft Graph API. I have successfully set up my Azure App Registration, including a callback URI. However, I’m encountering issues when trying to auto-answer calls

Details:

Call Initiation: The script successfully initiates a call using the New-MgCommunicationCall endpoint.Call Status: The call transitions from “establishing” to “established” status as expected.Error on Auto-Answer: Upon attempting to auto-answer the call with the Invoke-RestMethod to the answer endpoint, I receive a 404 Not Found error. The output indicates that the call ID is valid, but it seems the call resource is not found at the time of answering.

Current Script Setup:

I’m using a callback URI (https://kyncomdigiwasusdev.onmicrosoft.com/callback) configured for handling call events.I have ensured the necessary permissions are granted in Azure for the app.I have tried various delays (currently set to 5 seconds) between establishing the call and answering it, but I still receive the 404 error.

Questions:

Are there any known issues with the auto-answer feature in the Microsoft Graph API for VOIP calls?What additional steps should I take to troubleshoot this error?

​Description: I’m working on a PowerShell script to initiate and auto-answer VOIP calls using the Microsoft Graph API. I have successfully set up my Azure App Registration, including a callback URI. However, I’m encountering issues when trying to auto-answer calls Details:Call Initiation: The script successfully initiates a call using the New-MgCommunicationCall endpoint.Call Status: The call transitions from “establishing” to “established” status as expected.Error on Auto-Answer: Upon attempting to auto-answer the call with the Invoke-RestMethod to the answer endpoint, I receive a 404 Not Found error. The output indicates that the call ID is valid, but it seems the call resource is not found at the time of answering.Current Script Setup:I’m using a callback URI (https://kyncomdigiwasusdev.onmicrosoft.com/callback) configured for handling call events.I have ensured the necessary permissions are granted in Azure for the app.I have tried various delays (currently set to 5 seconds) between establishing the call and answering it, but I still receive the 404 error.Questions:Are there any known issues with the auto-answer feature in the Microsoft Graph API for VOIP calls?What additional steps should I take to troubleshoot this error?  Read More

​

I am currently transitioning our Self-Service Password Reset (SSPR) and Multi-Factor Authentication (MFA) to the new Authentication Methods policy, moving away from legacy policies. However, the lack of clarity on which methods are compatible with both scenarios is quite frustrating, and I wonder if I might be missing something.

Our goal is to exclusively use the Authenticator app and security keys for both MFA and SSPR, eliminating all other methods. Additionally, we want to maintain the requirement of two methods (Authenticator app and security key) for password changes. We are in the process of distributing security keys to all staff.

The issue I’m encountering is that while Microsoft promotes this new portal as a unified solution for both MFA and SSPR, not all methods are supported across both. Specifically, the security key does not currently work for SSPR. If I am unable to use the security key for SSPR and must resort to a less secure second method, I would at least like to disable that less secure method for MFA. However, it seems there is no way to configure this in the policy.

Am I on the right track here? I am aware that Authentication Strengths can be configured—perhaps this is where I should focus?

Any advice or discussion would be greatly appreciated.

​I am currently transitioning our Self-Service Password Reset (SSPR) and Multi-Factor Authentication (MFA) to the new Authentication Methods policy, moving away from legacy policies. However, the lack of clarity on which methods are compatible with both scenarios is quite frustrating, and I wonder if I might be missing something. Our goal is to exclusively use the Authenticator app and security keys for both MFA and SSPR, eliminating all other methods. Additionally, we want to maintain the requirement of two methods (Authenticator app and security key) for password changes. We are in the process of distributing security keys to all staff. The issue I’m encountering is that while Microsoft promotes this new portal as a unified solution for both MFA and SSPR, not all methods are supported across both. Specifically, the security key does not currently work for SSPR. If I am unable to use the security key for SSPR and must resort to a less secure second method, I would at least like to disable that less secure method for MFA. However, it seems there is no way to configure this in the policy. Am I on the right track here? I am aware that Authentication Strengths can be configured—perhaps this is where I should focus? Any advice or discussion would be greatly appreciated.  Read More

​

Is it possible to create e-mail templates that have contacts in the ‘To’ and ‘Cc’ boxes? The current template functionality only allows you to store the body of the mail, not persons copies of the templates should go to.

​Is it possible to create e-mail templates that have contacts in the ‘To’ and ‘Cc’ boxes? The current template functionality only allows you to store the body of the mail, not persons copies of the templates should go to.  Read More

​

How do I get an entire row to change color based on any date being entered into the first cell of the row? I would like to apply this to all rows where only rows with a date in the first cell will change colors.

​How do I get an entire row to change color based on any date being entered into the first cell of the row? I would like to apply this to all rows where only rows with a date in the first cell will change colors.  Read More

​

​Microsoft Tech Community – Latest Blogs –Read More 

Have you been looking to expand your storage on Azure VMware Solution (AVS), but do not need the extra compute performance and the associated costs that come with adding more nodes? Are you looking for a more cost-efficient alternative storage solution that is easy to set up and manage? If so, you will be as excited as we are to learn about the general availability of Azure Elastic SAN for AVS – out today!

Using Azure Elastic SAN to expand your storage

Azure Elastic SAN is Azure’s latest addition to our family of block storage products, unique in part because of its support for remote block storage (iSCSI) and cost-efficient provisioning model for deployment at scale. Because Azure VMware Solution supports attaching iSCSI datastores as a persistent storage option, you can create Virtual Machine File System (VMFS) datastores with Azure Elastic SAN volumes and attach them to clusters of your choice. By using VMFS datastores backed by Azure Elastic SAN, you can expand your storage with an Azure deployed, fully-managed and VMware Certified storage area network instead of scaling the clusters.

With this integration, we add an important tool for optimizing workloads, whether they are large-scale databases requiring high storage capacity, or performance-intensive, mission-critical applications. Not every application requires the performance of directly attached storage, and many workloads, like backup and disaster recovery use cases or other capacity intensive workloads, can benefit from a more cost-efficient extensible storage solution. Azure Elastic SAN can be deployed and connected straight from the Azure portal, and at $0.06-0.08 per GiB per month (based on current pricing in East US), it is the cheapest per GiB storage option for AVS, while still offering scalable performance for a variety of use cases.

How to optimize price-performance with Azure Elastic SAN

When setting up an Elastic SAN, you create a pool of resources that is shared among the “volumes” within the SAN. Each of these volumes can be exposed as a datastore to your AVS SDDC. While Elastic SAN volumes share the performance you provision at the SAN level, the individual volumes have their own performance limits (shown in table below). By design, the individual volume limit is high so we can accommodate traffic bursts on any given volume. If you require more than 80,000 IOPS, you could spread your workloads across multiple volumes, placing them on different datastores.

Elastic SAN

Scale targets

Volume/Datastore

Elastic SAN

Size

64 TiB

1 PiB

IOPS

80,000

2,000,000

Throughput

1,280 MB/s

80,000 MB/s

Provisioning model

Per GiB provisioning granularity

Flexible model at TiB granularity

The pool of resources for your Elastic SAN is built up out of 1 TiB units: “Base units” and “Capacity-only units”. Base units provide both storage capacity and performance, while Capacity-only units provide just storage capacity. In practice, you start adding Base units until you reach the desired level of performance, then in case your storage capacity requirements are not yet met, you can add additional Capacity-only units. Both units offer local (LRS) or zonal (ZRS) redundant storage, and are priced as follows:

Pricing Meter

Unit

Monthly Price per GiB*

Premium LRS Base unit

1 TiB, 5000 IOPS, 200 MB/s

$ 0.08

Premium LRS Capacity only unit

1 TiB, capacity only (no provisioned performance)

$ 0.06

Premium ZRS Base unit  

1 TiB, 5000 IOPS, 200 MB/s 

$ 0.12 

Premium ZRS Capacity only unit 

1 TiB, capacity only (no provisioned performance) 

$ 0.09 

*Based on pricing in East US region as of 10/17/2024. Always refer to our pricing page for up-to-date details.

Get Started Today

By using Azure Elastic SAN for AVS, you get access to an Azure deployed, fully managed, VMware Certified storage area network (SAN) that can achieve massive scale, is easy to manage, and has redundancy built in at a low TCO. If you are looking for a native Azure Storage experience or you want to scale your storage capacity independently from your performance to get the lowest TCO and highest scale, get started with Azure Elastic SAN for AVS today! 

​Microsoft Tech Community – Latest Blogs –Read More