Tag Archives: microsoft
Unable to access membership workspace
As soon as we started associating members profile to the partner center I am unable to see the learning profile and membership workspace.
Any idea?
As soon as we started associating members profile to the partner center I am unable to see the learning profile and membership workspace. Any idea? Read More
Creating a Sliding Commission Scale in Excel
Hi
I have a Sliding Scale Commission that I pay my staff.
They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission.
I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box.
The scale is:
£0-£2000 @ 15%
£2000-£3000 @ 16%
£3000-£4000 @ 17%
£4000+ @18%
So for example, if their sales is £2500:
they would get 15% of the £2000 = £300
then they would get 16% on the £500 = £80
so I would pay them £380
Is there a way to do this?
TIA
Hi I have a Sliding Scale Commission that I pay my staff. They have to submit an invoice to me to show how much sales have been done and then how much I need to pay them in commission. I would like to create a generic Excel spreadsheet that they complete the total sales amount and it works out their commission pay in another box. The scale is:£0-£2000 @ 15%£2000-£3000 @ 16%£3000-£4000 @ 17%£4000+ @18%So for example, if their sales is £2500:they would get 15% of the £2000 = £300then they would get 16% on the £500 = £80 so I would pay them £380 Is there a way to do this? TIA Read More
Adjusting URL column formula
Greetings,
In column D, I have a specific page number for websites.
I am trying to create a column E, which would have a clickable link for each page.
For example:
D1- 4321 E1- https://bobsmadeupsite.org/4321
D2- 4345 E2- https://bobsmadeupsite.org/4345
D3- 4598 E3- https://bobsmadeupsite.org/4598
Is there a simple formula to alter column E to add and adjust column D’s information?
Help would be appreciated. Thanks.
Greetings, In column D, I have a specific page number for websites. I am trying to create a column E, which would have a clickable link for each page. For example: D1- 4321 E1- https://bobsmadeupsite.org/4321 D2- 4345 E2- https://bobsmadeupsite.org/4345 D3- 4598 E3- https://bobsmadeupsite.org/4598 Is there a simple formula to alter column E to add and adjust column D’s information? Help would be appreciated. Thanks. Read More
Checking to see if a serial number follows a certain format
I am trying to check a cell to see if it has a correct formatting for a serial number. for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.
L=letters
N=numbers
LLNNNNNN
If not, I would like to either have it highlighted or I could put something in another column. Just something to catch my eye for corrections.
I’m not great with formulas and my work excel is, I believe, the 2016 version.
I am trying to check a cell to see if it has a correct formatting for a serial number. for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.L=lettersN=numbersLLNNNNNNIf not, I would like to either have it highlighted or I could put something in another column. Just something to catch my eye for corrections.I’m not great with formulas and my work excel is, I believe, the 2016 version. Read More
Convert Access query to Sql Server
I can’t get two Max(IIf statement form an Access query to work in a Sql Server view. I have tried everything that I can think of and can’t get it to work. Could someone help me out. The highlighted in green code is the Access code that needs to added to Sql Server or something like it. Bob
SQLServer Design for dbo.TemporaryTransactionsQuery3
Sql Server code that can be copied, pasted and edited.
SELECT TOP (100) PERCENT dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit,
dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName,
dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.Multiple,
dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate
FROM dbo.tblTemporaryTransactions INNER JOIN
dbo.TemporaryTransactionsQuery2 ON dbo.tblTemporaryTransactions.ID = dbo.TemporaryTransactionsQuery2.ID INNER JOIN
dbo.tblTransactions ON dbo.TemporaryTransactionsQuery2.AccountName = dbo.tblTransactions.Account
GROUP BY dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance,
dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16,
dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate, dbo.TemporaryTransactionsQuery2.Multiple
ORDER BY dbo.TemporaryTransactionsQuery2.Date DESC
MS Access Sql code
SELECT TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, Max(IIf([tblTransactions].[Account]=[TemporaryTransactionsQuery2].[AccountName] And [tblTransactions].[PayeePayor]=[TemporaryTransactionsQuery2].[PayeePayor] And [tblTransactions].[ConbinedCategory]=[TemporaryTransactionsQuery2].[CombinedCategory] And [tblTemporaryTransactions].[Date]-10>=[tblTransactions].[TranDate],1,0)) AS Expr2, Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)) AS Expr3, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFees
FROM (TemporaryTransactionsQuery2 INNER JOIN tblTemporaryTransactions ON TemporaryTransactionsQuery2.ID = tblTemporaryTransactions.ID) INNER JOIN tblTransactions ON TemporaryTransactionsQuery2.AccountName = tblTransactions.Account
GROUP BY TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFees
HAVING (((Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)))=1))
ORDER BY TemporaryTransactionsQuery2.Date DESC;
I can’t get two Max(IIf statement form an Access query to work in a Sql Server view. I have tried everything that I can think of and can’t get it to work. Could someone help me out. The highlighted in green code is the Access code that needs to added to Sql Server or something like it. BobSQLServer Design for dbo.TemporaryTransactionsQuery3 Sql Server code that can be copied, pasted and edited.SELECT TOP (100) PERCENT dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.Multiple, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDateFROM dbo.tblTemporaryTransactions INNER JOIN dbo.TemporaryTransactionsQuery2 ON dbo.tblTemporaryTransactions.ID = dbo.TemporaryTransactionsQuery2.ID INNER JOIN dbo.tblTransactions ON dbo.TemporaryTransactionsQuery2.AccountName = dbo.tblTransactions.AccountGROUP BY dbo.TemporaryTransactionsQuery2.Account, dbo.TemporaryTransactionsQuery2.ChkRef, dbo.TemporaryTransactionsQuery2.Debit, dbo.TemporaryTransactionsQuery2.Credit, dbo.TemporaryTransactionsQuery2.Balance, dbo.TemporaryTransactionsQuery2.Date, dbo.TemporaryTransactionsQuery2.Description, dbo.TemporaryTransactionsQuery2.AccountName, dbo.TemporaryTransactionsQuery2.Description16, dbo.TemporaryTransactionsQuery2.PayeePayor, dbo.TemporaryTransactionsQuery2.CombinedCategory, dbo.TemporaryTransactionsQuery2.ID, dbo.tblTransactions.TranDate, dbo.TemporaryTransactionsQuery2.MultipleORDER BY dbo.TemporaryTransactionsQuery2.Date DESCMS Access Sql codeSELECT TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, Max(IIf([tblTransactions].[Account]=[TemporaryTransactionsQuery2].[AccountName] And [tblTransactions].[PayeePayor]=[TemporaryTransactionsQuery2].[PayeePayor] And [tblTransactions].[ConbinedCategory]=[TemporaryTransactionsQuery2].[CombinedCategory] And [tblTemporaryTransactions].[Date]-10>=[tblTransactions].[TranDate],1,0)) AS Expr2, Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)) AS Expr3, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFeesFROM (TemporaryTransactionsQuery2 INNER JOIN tblTemporaryTransactions ON TemporaryTransactionsQuery2.ID = tblTemporaryTransactions.ID) INNER JOIN tblTransactions ON TemporaryTransactionsQuery2.AccountName = tblTransactions.AccountGROUP BY TemporaryTransactionsQuery2.Account, TemporaryTransactionsQuery2.ChkRef, TemporaryTransactionsQuery2.Debit, TemporaryTransactionsQuery2.Credit, TemporaryTransactionsQuery2.Balance, TemporaryTransactionsQuery2.Date, TemporaryTransactionsQuery2.Description, TemporaryTransactionsQuery2.AccountName, TemporaryTransactionsQuery2.Description16, TemporaryTransactionsQuery2.PayeePayor, TemporaryTransactionsQuery2.CombinedCategory, TemporaryTransactionsQuery2.Multiple, TemporaryTransactionsQuery2.ID, TemporaryTransactionsQuery2.Type, TemporaryTransactionsQuery2.Shares, TemporaryTransactionsQuery2.Price, TemporaryTransactionsQuery2.CommFeesHAVING (((Max(IIf(IsNull([tblTemporaryTransactions].[PayeePayor])=True And IsNull([tblTemporaryTransactions].[CombinedCategory])=True,1,0)))=1))ORDER BY TemporaryTransactionsQuery2.Date DESC; Read More
MY PROFILE ON MICROSOFT OUTLOOK
Dear Friends and Cousins
My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have genitals. They cant be horny. Iam afraid. Iam a Human and Newlywed. I have genitals just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens. Their from California who DONT HAVE GENITALY. I dont like California.
From JULIA R. 40 YEARS OLD
Dear Friends and Cousins My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have genitals. They cant be horny. Iam afraid. Iam a Human and Newlywed. I have genitals just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens. Their from California who DONT HAVE GENITALY. I dont like California. From JULIA R. 40 YEARS OLD Read More
Powershell Script not running on Client
Hello,
I had created a powershell script in Endpoint Manager / Inutne.
But the script will not load and run a my Windows 10 test client. When I look on my test client i do not see the EnterpriseDesktopAppManagement CSP by Intune. I see only logs.
When I create a configuration policies it will push ( also apps) to the client.
What can I do to run ps scripts on the client via Intune?
Regards
Stefan
Hello,I had created a powershell script in Endpoint Manager / Inutne. But the script will not load and run a my Windows 10 test client. When I look on my test client i do not see the EnterpriseDesktopAppManagement CSP by Intune. I see only logs.When I create a configuration policies it will push ( also apps) to the client. What can I do to run ps scripts on the client via Intune? RegardsStefan Read More
SharePoint Doc link broken
One of my users links a URL to a SharePoint site, but this link gets encoded incorrectly, resulting in a broken link that removes some filters. The encoding for ‘%3F’ is being changed to ‘?’, which removes the filters from the link. Please guide me.
https://test1.constoso.com/[shortened]/list.do%3F
https://test1.constoso.com/[shortened]/list.do%?
One of my users links a URL to a SharePoint site, but this link gets encoded incorrectly, resulting in a broken link that removes some filters. The encoding for ‘%3F’ is being changed to ‘?’, which removes the filters from the link. Please guide me.https://test1.constoso.com/[shortened]/list.do%3Fhttps://test1.constoso.com/[shortened]/list.do%? Read More
Sum of subtotal cell from multiple workbooks
Hi Folks,
I do the invoicing for my wife’s physio business. I downloaded a simple invoice template and have been using this for the past few years.
On OneDrive, I have a directory with my wife’s business name and then sub-directories of years and within each year, months. So, for instance, a directory 2022, with all the months of the year Jan-Dec, and within each month a patient’s invoice for that month.
Each workbook contains a worksheet invoice with a cell in each worksheet containing the sum of the number of visits for that month in $. What I would like to do is add up all the subtotals for each patient for each month and a total for the year.
For example, 2022 would have directories of Jan to Dec, with a workbook containing an invoice worksheet for each patient. I would like to get a total of all the patients’ subtotals included in each monthly directory, and then a grand total for the year. So essentially, I am trying to sum one cell from one worksheet found in multiple workbooks.
I am not a power user so the easier the better even if it may not be the most efficient method. I just do not want to have to open up every workbook containing the invoice and manually add the subtotal of each patient’s charges.
Can this be done through a power query or macro. I am not very good with Excel but I am willing to give it a try.
Thanks!!
Best regards,
Rich
Hi Folks, I do the invoicing for my wife’s physio business. I downloaded a simple invoice template and have been using this for the past few years. On OneDrive, I have a directory with my wife’s business name and then sub-directories of years and within each year, months. So, for instance, a directory 2022, with all the months of the year Jan-Dec, and within each month a patient’s invoice for that month. Each workbook contains a worksheet invoice with a cell in each worksheet containing the sum of the number of visits for that month in $. What I would like to do is add up all the subtotals for each patient for each month and a total for the year. For example, 2022 would have directories of Jan to Dec, with a workbook containing an invoice worksheet for each patient. I would like to get a total of all the patients’ subtotals included in each monthly directory, and then a grand total for the year. So essentially, I am trying to sum one cell from one worksheet found in multiple workbooks. I am not a power user so the easier the better even if it may not be the most efficient method. I just do not want to have to open up every workbook containing the invoice and manually add the subtotal of each patient’s charges. Can this be done through a power query or macro. I am not very good with Excel but I am willing to give it a try. Thanks!! Best regards,Rich Read More
Captions in Word
I am trying to place a caption under Tables and Figures that include chapter numbers as follows: Figure 1.1, Figure 1.2, Figure 2.1. I follow all instructions but when I enter the caption it returns it as Figure 0.1, which means it is not picking up the chapter number. Since I am using custom headers that are not reflected in the Caption dialogue box, I go back and set up a new header style (Header 6) that is not used anywhere else in the document. Then when I apply that to the Chapter number header, it applies it to all section headers in the document. Anyone know what I am doing wrong?
I am trying to place a caption under Tables and Figures that include chapter numbers as follows: Figure 1.1, Figure 1.2, Figure 2.1. I follow all instructions but when I enter the caption it returns it as Figure 0.1, which means it is not picking up the chapter number. Since I am using custom headers that are not reflected in the Caption dialogue box, I go back and set up a new header style (Header 6) that is not used anywhere else in the document. Then when I apply that to the Chapter number header, it applies it to all section headers in the document. Anyone know what I am doing wrong? Read More
Laptop OneDrive files not visible on the desktop
I have one drive on my desktop, works fine. I have a laptop and it can see the OneDrive files from my desktop but when I add files from my laptop they show up in OneDrive on the laptop but are not visible from the desktop. I will quickly get my files out of sync at this rate. I want the files I modify or change on my laptop to be visible and up to date on my desktop. How do I fix this? Otherwise, I will need to move off OneDrive.
I have one drive on my desktop, works fine. I have a laptop and it can see the OneDrive files from my desktop but when I add files from my laptop they show up in OneDrive on the laptop but are not visible from the desktop. I will quickly get my files out of sync at this rate. I want the files I modify or change on my laptop to be visible and up to date on my desktop. How do I fix this? Otherwise, I will need to move off OneDrive. Read More
MY PROFILE ON OUTLOOK
Dear Friends and Cousins
My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have **bleep** or Vegina. They cant be horny. Iam afraid. I have a Vegina just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens from California who DONT HAVE **bleep**/VEGINA.
From JULIA R. 40 YEARS OLD
Dear Friends and Cousins My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have **bleep** or Vegina. They cant be horny. Iam afraid. I have a Vegina just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens from California who DONT HAVE **bleep**/VEGINA. From JULIA R. 40 YEARS OLD Read More
Scaling a Letter-size document to A4
I created a document using a tri-fold brochure template. Only when I printed did I realise it was a “Letter (8.5″ x 11” document) and I am printing on A4. When I change the page size to A4 it completely messes up my layouts and I spent hours trying to adjust them with no luck. It seems the template is made using multiple tables for the layout, as I couldn’t select the whole table to enlarge it. Is there an easy way to do this? Unfortunately I am printing wirelessly so I there’s nothing i can do in print settings
I created a document using a tri-fold brochure template. Only when I printed did I realise it was a “Letter (8.5″ x 11” document) and I am printing on A4. When I change the page size to A4 it completely messes up my layouts and I spent hours trying to adjust them with no luck. It seems the template is made using multiple tables for the layout, as I couldn’t select the whole table to enlarge it. Is there an easy way to do this? Unfortunately I am printing wirelessly so I there’s nothing i can do in print settings Read More
How to trim an mp3 file on Windows 11 in bulk?
Recently, I copied hundreds of songs in mp3 format from old CDs. Many of the mp3 files have very long duration and I am going to trim the mp3 file to get rip the useless prelude. I tried the Windows Media Player but it does not work. Hope someone could suggest a good way to bulk trim mp3 files on Windows 11?
Recently, I copied hundreds of songs in mp3 format from old CDs. Many of the mp3 files have very long duration and I am going to trim the mp3 file to get rip the useless prelude. I tried the Windows Media Player but it does not work. Hope someone could suggest a good way to bulk trim mp3 files on Windows 11? Read More
Best Way to bulk rename files on Windows 11?
When I transferred my photos on my Android phone to Windows 11, I found out the photos are named under the data plus a set of random digits. I NEED to bulk rename the files on Windows 11. Can the Photos app is able to rename files in bulk? It could be so boring to rename it one by one.
Thanks
When I transferred my photos on my Android phone to Windows 11, I found out the photos are named under the data plus a set of random digits. I NEED to bulk rename the files on Windows 11. Can the Photos app is able to rename files in bulk? It could be so boring to rename it one by one. Thanks Read More
Blue Screen w/no response from the settings menu, and all functionality not responding.
The systems been active for 2.5 hrs., when I selected “system” from the task bar, the display was blue textured with vertical lines, the entire display on Lenovo:
Edition Windows 11 Home
Version 23H2
Installed on 2/20/2024
OS build 22631.3593
Serial number PF22E7GD
Experience Windows Feature Experience Pack 1000.22700.1003.0
The systems been active for 2.5 hrs., when I selected “system” from the task bar, the display was blue textured with vertical lines, the entire display on Lenovo:Edition Windows 11 HomeVersion 23H2Installed on 2/20/2024OS build 22631.3593Serial number PF22E7GDExperience Windows Feature Experience Pack 1000.22700.1003.0 Read More
Allocating / Apportioning Challan Amounts to Different Receipts
The attached file contains three Tables
1. Challan : This table contains the data for the Tax deposited via Challan.
2. Receipts : This table contains the data for the Amounts received against which the tax has been deposited.
3. ChallanAllocation : This table contains the mapping (from Challan Table) of challan number and date to all the amounts (in the Receipts Table)
My Request involves creation of ChallanAllocation like Information in an automated way
Here one challan amount might be sufficient to cover multiple receipts
or
One receipt might be sufficient to cover multiple challans
Considering the Receipts Table as base We need to Map (allocate and / or apportion) the Challan amount to all the receipts on FIFO basis, without leaving any balance in challan, and create a new table (Structured Data Table or simple data range). We might need to split the single challan across various receipts OR split the single receipts across several challans and might need to ADD more rows to accommodate such splits.
Notes:
1. Challan date and Receipt Date need to be in ascending order, but Challan Date may be before or after the Receipt Date. I will enter the data in ascending order but appreciate if the proposed solution can sort the data based on ID and CIN Date / Receipt Date.
2. I have given data for only Two IDs (i.e., A01, A02) but there are multiple IDs for which Data is maintained in the same table.
3. Total Challan Amount and Total Receipt Amount is matching in case of A01 but might be different in other cases (like in A02). In case Total Challan Amount is MORE than the Total Receipt Amount, the balance can be ignored. But if the Challan Amount is LESS than the Receipt Amount, the additional row should appear with “Short” in CIN Column in ChallanAllocation Table (like in Cell Q49)
Any solution (VBA, non VBA) to solve this and create the desired data is EQUALLY appreciated.
As I am not very good in VBA, I am trying my best to find a Non VBA solution using Dynamic Array Functions, but I am struggling to add new rows automatically to the existing table.
In real scenario, I am going to use three different sheets (Challan, Receipts, ChallanAllocation) and will be copying the new data on the Challan and Receipts sheet, hoping that the solution will create the desired data in Sheet ChallanAllocation. Here for the sake of easy matching, I have kept the data on one sheet.
and to all the Esteemed Experts
The attached file contains three Tables1. Challan : This table contains the data for the Tax deposited via Challan.2. Receipts : This table contains the data for the Amounts received against which the tax has been deposited.3. ChallanAllocation : This table contains the mapping (from Challan Table) of challan number and date to all the amounts (in the Receipts Table) My Request involves creation of ChallanAllocation like Information in an automated way Here one challan amount might be sufficient to cover multiple receiptsorOne receipt might be sufficient to cover multiple challans Considering the Receipts Table as base We need to Map (allocate and / or apportion) the Challan amount to all the receipts on FIFO basis, without leaving any balance in challan, and create a new table (Structured Data Table or simple data range). We might need to split the single challan across various receipts OR split the single receipts across several challans and might need to ADD more rows to accommodate such splits. Notes:1. Challan date and Receipt Date need to be in ascending order, but Challan Date may be before or after the Receipt Date. I will enter the data in ascending order but appreciate if the proposed solution can sort the data based on ID and CIN Date / Receipt Date.2. I have given data for only Two IDs (i.e., A01, A02) but there are multiple IDs for which Data is maintained in the same table.3. Total Challan Amount and Total Receipt Amount is matching in case of A01 but might be different in other cases (like in A02). In case Total Challan Amount is MORE than the Total Receipt Amount, the balance can be ignored. But if the Challan Amount is LESS than the Receipt Amount, the additional row should appear with “Short” in CIN Column in ChallanAllocation Table (like in Cell Q49) Any solution (VBA, non VBA) to solve this and create the desired data is EQUALLY appreciated. As I am not very good in VBA, I am trying my best to find a Non VBA solution using Dynamic Array Functions, but I am struggling to add new rows automatically to the existing table. In real scenario, I am going to use three different sheets (Challan, Receipts, ChallanAllocation) and will be copying the new data on the Challan and Receipts sheet, hoping that the solution will create the desired data in Sheet ChallanAllocation. Here for the sake of easy matching, I have kept the data on one sheet.@Sergei Baklan@Peter Bartholomew@lori_m@Chris_Grossand to all the Esteemed Experts Read More
How can I send a message between steps
I have a python script to send email from SSIS, which reads the parameter as text and sends it. I’d like to be able to recognize what is the preceding step, instead of creating several repeated send email processes. Thanks!
I have a python script to send email from SSIS, which reads the parameter as text and sends it. I’d like to be able to recognize what is the preceding step, instead of creating several repeated send email processes. Thanks! Read More
Define Patch Approvals in WSUS but pull patches from Internet
We currently use WSUS to distribute Microsoft patches and also use Solarwinds Patch Manager to push 3rd party patches into WSUS. This allows us to fully patch an endpoint with all MS and 3rd party software patches via Windows Update Agent/WSUS. We now have a fleet of laptops connected back to our Datacenter via a VPN and they are consuming a lot of bandwith during patching cycles.
We have the following challanges:
We do use some throttling on BITS/Delivery opitmization but have had mixed resultsWe have MECM but don’t use Cloud Management gatway as was deemed too expensive. we have not moved patching to MECM yet.If we use Windows Update for Business we cannot patch 3rd party updates and loose some control around pilot groups and reporting in our estimation
Q: So is there a way for us to continue to define the approved patches/metadata via WSUS but have the system pull the patches files from the internet (Windows Update) source? Perhaps this is possible with MECM?
We currently use WSUS to distribute Microsoft patches and also use Solarwinds Patch Manager to push 3rd party patches into WSUS. This allows us to fully patch an endpoint with all MS and 3rd party software patches via Windows Update Agent/WSUS. We now have a fleet of laptops connected back to our Datacenter via a VPN and they are consuming a lot of bandwith during patching cycles.We have the following challanges: We do use some throttling on BITS/Delivery opitmization but have had mixed resultsWe have MECM but don’t use Cloud Management gatway as was deemed too expensive. we have not moved patching to MECM yet.If we use Windows Update for Business we cannot patch 3rd party updates and loose some control around pilot groups and reporting in our estimationQ: So is there a way for us to continue to define the approved patches/metadata via WSUS but have the system pull the patches files from the internet (Windows Update) source? Perhaps this is possible with MECM? Read More
Trying to pull specific data from spread sheet to a calendar
Hello,
I’m trying to figure out an easier way to populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am unsure of what formula i could use to total the bed types for each day. I’m sure it is an easy thing but my googling has failed me.
here is the calendar.
Hello,I’m trying to figure out an easier way to populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am unsure of what formula i could use to total the bed types for each day. I’m sure it is an easy thing but my googling has failed me. here is the calendar. Read More
