warning messages – How to apply percent error to list of data

Say I have a list of data. data = {1,2,3,4,5} and those data values were measured with an instrument that has a listed 3% error. I can apply this per value with code:Around[1,Scaled[Quantity[3,"Percent"]]]
. How would I apply this to the whole list that may be a few hundred data points long?

Can I apply for a Canadian study Visa with an expired passport with assurance that I would get a renewed passport before I’m required to travel?


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




How to apply formula to new rows that are generated by script

I have a spreadsheet where new data into rows is added every hour. I tried using arrayformula but couldn’t figure out how.

Example spreadsheet: https://docs.google.com/spreadsheets/d/1SQ1ACRy1I4aW9abRWP-cuV65PPNla1cC6NTycsaEizs/edit?usp=sharing

I would like to compute column per hour

dataframe – panda apply function with a set of values of two columns

I have a data frame with two important columns source and target. I would like to detect inverse rows ie : for a pair of values (source, target) if it exist a pair of values (target, source) then assign it to true in a new columns.

cols = ('source', 'target')
_cols = ('target', 'source')
sub_edges = edges(cols)
sub_edges('oneway') = sub_edges.apply(lambda x: True if x(x.isin(x(_cols))) else False, axis=1)

document library – Apply New Default Column Value to PreExisting List Items

I am creating a calculated date column that adds a year to the end date column. I have a document library and I created a default column value for that column. Once I implemented it, the column populates to all the list/library items, but there is no value populating to it? Do I have to manually enter it into each item? I tried this in another list and it automatically populated to the single document that was in the library, I do not want to have to manually populate to hundreds of documents if I do not have to.

sharepoint online – Apply the list validation to only certain content types

I have the following formula inside the list validation:-

=IF(Status="Invoiced",IF((Customer Invoiced Date)<>"",TRUE,FALSE),TRUE)=IF(Status="Commission Paid",IF((Commission Paid Date)<>"",TRUE,FALSE),TRUE)=IF(Status="Delivered",IF((Order Delivered Date)<>"",TRUE,FALSE),TRUE)

and i have 3 content types for the list:-

  1. Project
  2. Sales
  3. Task

where i want to apply the formula only if content type != Task?
can anyone advice?
Thanks

dnd 3.5e – Apply force armor from mage armor/inertial armor/etc. against touch attacks?

I want to cast a spell or manifest a power that provides a +4-or-greater bonus to AC that lasts hours/level or longer, and have it apply to touch attacks.

The mage armor, luminous armor, and greater luminous armor spells, and the inertial armor psionic power, all create a force effect that provides an armor bonus to AC for hours/level. Because it is a force effect, it applies against the touch attacks of incorporeal creatures. Consistent with physical armor, however, these spells do not apply against other touch attacks (e.g. spells).

On the other hand, with regular armor, you have options like the Deflective Armor feat from Races of Stone, which allows your armor’s armor bonus to AC to apply against touch attacks. Deflective Armor requires Heavy Armor Optimization, and that you be wearing heavy armor. It also specifies that it affects “the AC bonus from your armor” rather than “your armor bonus to AC,” so even if you jumped through the hoops necessary to wear heavy armor while also using one of these spells, it probably still wouldn’t apply to the bonus from mage armor or inertial armor.

So, is there anything that does? The ideal is something that says “the armor bonus to AC you receive from force effects also applies to touch attacks,” but if it specifies mage armor or inertial armor or one of the other spells—or another effect, or if it is another spell or power—that would be acceptable.

Answers can be from any 3.xe source published by Wizards of the Coast (including electronic publications, e.g. PDFs or pages from wizards.com), or from any 3.xe issue of Dragon or Dungeon magazine. It must be 3.5e-legal, that is, if it’s 3.0e material it can’t have been replaced by 3.5e material (that likely nixes almost all of 3e psionics, though feel free to make the case for something that doesn’t explicitly reference mechanics that no longer exist). Epic material doesn’t exist, but high non-epic levels are allowed. Any spell suggested must actually produce an armoring effect—changing into a creature with higher AC and touch AC, for example, does not count. A spell or power that summons a suit of heavy armor, with which you could then take Heavy Armor Optimization and Deflective Armor, is an acceptable answer but not a great one (I’d only really be interested if it were significantly superior to magic full-plate somehow).

Google Sheets SUMIFS – apply REGEXTRACT to sum_range?

I have the following Google Sheets table and want to calculate the total sums of various medications prescribed:

Type    Amount (in g)   Daily dosage (in g)
A       60              2
B       25 mg/capsule   30 pieces, 0-0-1 for 30 days
A       10              0.5

This is very easy for medication type A, as I can just look in column B.

My issue is that the entries associated with medication type B don’t only consist of digits, so I need to apply two REGEXTRACTs.

"(0-9){2}"

"(d+) pieces"

That is all fine and would work.

But how do I get around the issue that the sum_range in SUMIFS needs to be digits?

Because something like this would not work afaik:

=ARRAYFORMULA(SUMIFS(REGEXEXTRACT(C2,"(d+) pieces")...

I cannot change the way this data is entered and also don’t want to create additional columns if possible.

Hi…..my Russian wife wishes to bring her Russian gandaughter age 6, over to Spain, How, where, and when we can apply for a visa for the child

my Russian wife wishes to bring her Russian gandaughter age 6, over to Spain, where we are residents, to spend summer with us. Her father is deceased so we would like to know How, where, and when we can apply for a visa for the child. She has already spent one summer with us. Awaiting your reply…thanks.

Error when trying to apply Always Encrypted encryption on aspnet_Membership table

I’m trying to encrypt the Email and LoweredEmail columns on a SQL database using Always Encrypted encryption using SSMS and I always get the same error:

Lock request time out period exceeded. There is no user table matching the input name ‘(dbo).(aspnet_Membership)’ in the current database or you do not have permission to access the table.
I still get the same error when I log in as the SA account, sio I guess that it’s not a permissions problem.

SSMS select column
SSMS key
SSMS proceed
SSMS summery
SSMS error

EDIT *** Added the PowerShell Script

Import-Module SqlServer

$password = “”
$sqlConnectionString = “Data Source=GALADRIELSKYLINE;Initial Catalog=SkylineMembership;User ID=sa;Password=$password;MultipleActiveResultSets=False;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;Packet Size=4096;Application Name="Microsoft SQL Server Management Studio“”
$smoDatabase = Get-SqlDatabase -ConnectionString $sqlConnectionString

#Add-SqlAzureAuthenticationContext -Interactive

#Add-SqlAzureAuthenticationContext -ClientID ” -Secret ” -Tenant ”

$encryptionChanges = @()

$encryptionChanges += New-SqlColumnEncryptionSettings -ColumnName dbo.aspnet_Membership.Email -EncryptionType Deterministic -EncryptionKey “CEK_Auto1”
$encryptionChanges += New-SqlColumnEncryptionSettings -ColumnName dbo.aspnet_Membership.LoweredEmail -EncryptionType Deterministic -EncryptionKey “CEK_Auto1”

Set-SqlColumnEncryption -ColumnEncryptionSettings $encryptionChanges -InputObject $smoDatabase