## ca.classical analysis and odes – How to determine an interval of values with 2 variables

I would like to determine an interval of values of that expression:

$$a^2 + b^2 + frac{1}{a^2} + frac{b}{a}$$ for a ∈ R-{0} and b ∈ R

I tried trivial solutions, AM-GM inequality, Cauchy-Schwarz inequality and … I’m stuck. That is the only problem I can’t solve on the list form my university ;/

## google sheets – Duplicate row values to next row, based off specific column

I’m trying to set up a button that will copy information from the last row and paste it into the row right underneath (based on where column D last has a value). Almost like a “duplicate” button, because I am inputting information that will repeat.

I had a script that was doing the copy perfectly. However, I realized an issue — because I have a unique ID pre-loaded to fill up all rows in the first column (causing the added row to come after this), I wanted this script to seek the last row based on the FOURTH column, not the FIRST.

On a similar pattern, I am looking to ONLY copy the information from column 4, 5, 6, and 7, into the row underneath — not any other info.

My idea was that I could basically combine these two concepts — copying and pasting the last row into the row underneath, and using GetColumnHeight so that I can control which columns should be selected.

``````function addRow() {
var sh = ss.getActiveSheet(), lRow = sh.getLastRow();
var lCol = sh.getLastColumn(), range = sh.getRange(lRow,1,4,lCol);
sh.insertRowsAfter(lRow, 1);
range.copyTo(sh.getRange(lRow+1, 1, 1, lCol), {contentsOnly:false});

var vs=sh.getRange(e.range.rowStart,4,1,3).getValues()
tsh.getRange(getColumnHeight(3,tsh,e.source)+1,4,1,3).setValues(vs);
}
}
function getColumnHeight(col,sh,ss){
var sh=sh||ss.getActiveSheet();
var col=col||sh.getActiveCell().getColumn();
var v=sh.getRange(1,col,sh.getLastRow(),1).getValues().map(function(r){return r(0);});
var s=0;
var h=0;
v.forEach(function(e,i){if(e==''){s++;}else{s=0;}h++;});
return (h-s);
}
``````

I’m really all over the place right now, and struggling to piece something together that will copy and paste the values in column 4,5,6, and 7 into the row below, ignoring the filled values in column A. Any suggestions?

Here is a visual to further explain my goal:

## dnd 3.5e – How many Joules does strength values ten through twenty estimate to?

D&D is not a science based or physics based game. Yet certain inquiring players apparently want to know.

Thus, how many Joules does strength values ten through twenty estimate to? Based on lift over head weight listed in the encumbrance chart.

Science related info for the problem:

The Prime material plane has been established as being the same as Earth in every aspect not specifically listed as being different (at least for Greyhawk, Forgotten Realms, and Dragonlance), thus for physics purposes, we can assume that Earth-like physics are actually the default when not overridden by psionics, magic, incarnum, etc..

The amount of weight being lifted is exactly equal to the max value listed in the table for every strength value, at sea level with regards to atmospheric pressure and gravity is assumed to be 1G since there is no indication in the primary D&D worlds that it isn’t.

Let’s assume a human is doing the lifting, for this purpose, in case it makes a difference, using the average height listed in the Height and Weight table.

## functions – Replacing \$x,y\$ in \$f(x,y,z)\$ with values from a list

I’m sure there is a simple solution to this using map or apply, but its not occurring to me.

Suppose I have a function $$f(x,y,z)= x+y+z)$$

And I want to evaluate $$f(x,y,1)$$ for $${x,y} ∈ {{1,2},{3,4}}$$

What is the best way to do this?

Examples:

If I use
`f(x_,y_,z_):= x+y+z; f(#1,#2,1)&/@ {{1,2},{3,4}}`

this will give me things like `{{2+#2,3+#2}}.`

On the other hand, `Apply` works on a single element
`f(#1,#2,1)& @@ {1,2}`
but not on a list such as `{{1,2},{3,4}}`. On the list it gives me `{f(1,3,1),f(2,4,1)`

I am not sure how to go from the case of a single pair to a list of pairs

## dnd 3.5e – How many Joules does strength values ten through twenty equate to?

D&D is not a science based or physics based game. Yet certain inquiring players apparently want to know.

Thus, how many Joules of energy does strength values ten through twenty equate to? Based on lift over head weight listed in the encumbrance chart.

## sharepoint online – Can you separate multiple values in a single string in @currentfield delimited in some way to make each value a hyperlink

I’m currently using MS’s column formatting JSON to turn a field’s string entry into a URL using the following to automatically make the ticket number entry a clickable hyperlink to our zendesk for the respective ticket number:

``````{
"\$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "@currentField",
"attributes": {
"target": "_blank",
"href": "='https://URLANONYMIZED.zendesk.com/agent/tickets/' + @currentField"
}
``````

However, if we have multiple tickets for the same issue, it would be nice to be able to do the same for multiple values that are separated by a space, comma, or what have you so that each ticket number would link to it’s respective ticket. Is this possible? Using Office 365 hosted sharepoint if that matters any.

## Parsing XML with java – does not get all xml values

Trying to parse xml to get tag value from this XML (pasted not the whole):

``````    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03">
<CstmrCdtTrfInitn>
<GrpHdr>
<MsgId>SANDISS_2020_10_08_001</MsgId>
<CreDtTm>2020-10-15T18:15:33</CreDtTm>
<NbOfTxs>3</NbOfTxs>
<CtrlSum>36.00</CtrlSum>
<InitgPty>
<Nm>Bank</Nm>
<Id>
<OrgId>
<Othr>
<Id>40100</Id>
<SchmeNm>
<Cd>COID</Cd>
</SchmeNm>
</Othr>
</OrgId>
</Id>
</InitgPty>
</GrpHdr>
``````

However, getting not all values

Here is the method for parsing and editing xml (writing back to XML file is skipped atm)

`````` public void modifyXmlFile(String filePath, Map<String, String> tagValuesToChange) {
try {
DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docBuilder = docFactory.newDocumentBuilder();
Document document = docBuilder.parse(filePath);
XPath xpath = XPathFactory.newInstance().newXPath();

for (Map.Entry<String, String> entry : tagValuesToChange.entrySet()) {
Node node = (Node) xpath.compile(entry.getKey()).evaluate(document, XPathConstants.NODE); //**This becomes null**
node.setTextContent(entry.getValue());
}
``````

Basically tag is not found and node variable is set to null.
Not sure why? Can you help me out?

## Dashboard charts where in some higher is better, others lower is better, and in yet others the values should fall between a range

As the title says, how are people approaching having multiple charts in a dashboard, where in some higher is better vs lower is better vs fits in range? All of these charts would have multiple values.

Consider, for example, a case where you want to show 3 charts side by side: 1] revenue by store [higher is better], 2] bad debts/write-offs [lower is better], and 3] price volatility [should be between upper and lower bounds]

I’ve struggled with this for years, and still haven’t found an elegant solution.

## how to allow user select shipping location(a custom locations dropdown) in checkout and recalculate values woocommerce

i need to know 2 things

1. how do i add custom shipping zones to a determinate contry (I need to add some neightbours of a main city)
2. How do i allow users to select the shipping zone when chekout or in the cart, and recalculate the total