litt | based application for controlling Philips Hue lights

we're using a PS-Script for creating new AD-users and configure everything in one go. I'd like to create a unique 6-digit number and check if it's already in use. I thought a do-until-loop will do the trick, but i can't get it to re-run if a match is found.

My code as of now is this:

I want to create a number pyramid like this,

I have a litte problem with Microsoft SignTool.exe. I have installed Windows 10 SDKs and Office SIPs to support macro enabled documents. Then I followed readme to activate dlls and made all the changes, including:

1. Installed - Microsoft Visual C++ Runtime Libraries
2. Set path to VBE7.DLL

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VBA]
"Vbe71DllPath"="C:\Workspace\Signing\vbe7.dll"

1. Registered MSOSIPX.DLL with REGSVR32
2. I have also created wintrust.dll.ini and added:
   

[1]
DLL=
GUID={6E64D5BD-CEB0-4B66-B4A0-15AC71775C48}
CryptSIPDllCreateIndirectData=_VBASipCreateIndirectData@12
CryptSIPDllGetSignedDataMsg=_VBASipGetSignedDataMsg@20
CryptSIPDllIsMyFileType2=_VBASipIsMyTypeOfFileName@8
CryptSIPDllPutSignedDataMsg=_VBASipPutSignedDataMsg@20
CryptSIPDllRemoveSignedDataMsg=_VBASipRemoveSignedDataMsg@8
CryptSIPDllVerifyIndirectData=_VBASipVerifyIndirectData@8

1. I'm using:

   signtool sign /debug /n "Cert" /fd SHA256 test.xlsm and the following happens:

SignTool Error: This file format cannot be signed because it is not recognized.
SignTool Error: An error occurred while attempting to sign: test.xlsm
Number of files successfully Signed: 0
Number of warnings: 0
Number of errors: 1

Little note at the end:

With test.exe it worked just fine.

I have two lists (variable length) in Excel (1, 2 resp.) and wish to find the union of these:

My research yields numerous solutions / questions to this effect, however, they either focus on Office 365, VB, Lambdas, PowerQuery variations - they do not proivde a function fit for Excel 2010 etc.:

Requirements/research:

• No Office 365 requirement (so no FilterXML, let, choose, etc. etc. - per here, here, here)
• Am not interested in VB (trivial) / PowerQuery (ditto - i.e. simple 'insert/data/append 2 or more queries)
• Am not interested in Lambda variations (per here)
• Duplicates are fine

Progress

Have been contemplating an offset function that picks up values in the 2nd list once those in the first list are exhausted in an array function -- but am a litte lost otherwise (and don't want to restrict anyone in scope of functions that may be avail. in this regard).

Can someone assist me in finding a function per above pls?

I want to build an Onboarding Screen for an app especially for blind people. so the pages should play a small mp3 file.

But if I implement the code as attached, the behavior seems weird for me. If I change from page 1 to page 2 the first mp3 file stops and the second starts. as I want it. if I go further to page 3 the mp3 from page 2 continues and the mp3 from page 3 starts also. the both sound are overlaying each other.

I don't understand why .onDisappear sometimes seems not to be executed...

sometime Xcode throws a Thread 1: Fatal error: Unexpectedly found nil while implicitly unwrapping an Optional value --> solved by the hint from jnpdx - Thanks

in the .onDisappear section.

Here is a litte video of my problem. Maybe it's easier to understand what I mean if you see the video...

https://www.eckeonline.de/RPReplay_Final1643832563.MP4

i use GS with this command line

i was wondering if you use a DropDownMenu in Flutter there is a possibility to get different values.

For Example: You have the items ['item1','item2','item3','item4','item5'] then you use a DropDownButton with these items. But for every single item there should be passed a different value so i can work with that later.

So that item1 = 90, item2 = 180, item3 = 270 and so on. If item1 is selected it should be displayed to the user like that and the app gets the value 90 for example where it can work with later.

I hope you get what i mean and can help me a litte bit.

I have this thing right now, but the first part is something iffy with because the answer should be 12 because my file have 12 chapters , but i get 2726 as the answer. I also need to make a forth function called:

analyze_book(filename, chapter_delimiter, word)

where the task is to use the three other functions to take in a word, calculate how many times that word is in each chapter of the book, and then plot the resaults in a graf where the x-axes is the chapternumber and the y-axes is the amount of times that word is in that chapter. the graf is also going to look like this:

1. Title of the graf is: Amount of word shows up per chapter in filename
2. Title x-axis: Chapter
3. Title y-axis: Amount of word
4. x-axis goes from 1 to amount of chapters
5. y-axis goes from 0 to highest amount og times word +3

As said at the top, def get_chapter is a litte iffy somewhere and i dont know why And i also lack the last function and i have no idea where to go from here.

We booked an azure account in Germany with the Telekom as a reseller (due to GDPR reasons, it "sounds better" if you say to your customers you host with the Telekom than on Microsoft :-))

We have an elastic database pool:

Germany West Central, Elastic Pool, RA-GRS, vCore, General, Gen 5, 2 vCores, pay as you go, no hybrid, 32 GB

According to standard azure price lists, price calculator and documentations this should produce round about 329,23€ per month (plus reseller margin). All information I can find confirms that this cost is fixed and there is no variable part that could increase this cost.

In the first month (12 Databases, 1GB used, nearly no actual use) the cost where as expected.

In the second month (14 Databases, 2GB, not exactly sure about usage) the cost raised by 150€.

In the third month (14 Databases, 2GB, nearly no actual usage) the cost raised again by 150€.

Aside from addingh 2 databases and using 1 more GB nothing has changed. The configuration of the pool was not changed in all thoose month.

So currently we pay double the expected cost and worry that it will raise another 150€ the next month. The Telekom claimed that "there are no fixed prices with microsoft" and that the raise is because of the 2 new databases. This sounds like complete nonsense to me. They opened a ticket at Microsoft, but after 2 weeks we have still no answer.

Assuming (as they also claim) that the problem is not on the Telekom side and Microsoft really bills them an increasing amount every month, despite it should be a constant price and despite it is barely used und nothing has changed that could explain the raise, does anybody have any idea, what could cause this raising costs?

Edit 1 : This is not the "branched" Telekom Cloud Azure that was discontinued this year.

Edit 2 : Because of the reselling, all cost control tools are disabled and replaced by "ask your reseller".

Edit 3 : I'm quite sure that I understand the azure price model correctly and this is not the way it should be. My suspicion is, that there is maybe some variable cost part that under normal circumstances doesn't play a role (like e.g. network traffic or something like that) and that there is something special going on (like a programing error, causing an infinite loop causing querying the database over and over again, causing TBs of traffic each month. But this is not the case. The metrics show 0% IO over the last month).

Edit 4: The invoice lists 2 positions. One for the pool and one for the sql server license. There is an "amount" (a four digit number). This grows over the 3 month from 1488, to 2230 to 3156. The price for position 1 is 0,141€, the one for the license is 0,084€ per "unit". I have no idea what this unit should be nor why it is growing each month. I also have no idea while the sql server license is also billed according to this "amount". It seems like a completely different pricing model to me where pool and license are charged for something like "minutes with activity" or something like that.

Edit 5 : I just noticed a strange thing. While in the pool under configuration there is a "data max size" of 32 GB, if I look into a database of the pool under "compute+storage" there is also a slider "Data max size" (but no one for the vcores) whith shows 250GB? Whats going on here? How can the pool have 32GB max but each database 250GB max? (I'm absolutely sure I have not configured this and I don't understand how the db max can be more than the pool max). But event this could not explain the charged amount (the data max size is more or less cheap and does not increase the license costs).

Edit 6 : If I compare the numbers it seems that the unit of the billed "amount" is 0,5h (strange). The prices for pool and license are more or less exactly double the hourly prices at MS, and the amount in the first invoice (1488) is a litte bit more than double the 730h a month has. According to that we were billed for 46 days in the second and for 66 days in the third month. If it were 31,62 and 93 I would have an idea whats going on (they don't reset the counter after billing) but the numbers do not give that.