dnd 5e – When using the Template variant rule from Xanathar’s Guide to Everything, do 5 foot wide Lines actually affect a 10 foot wide row of grid squares?

Xanathar’s Guide to Everything has a few variant options for playing on a Grid.

XGtE, Page 86:

… Choose an intersection of squares as the point of origin of an area of effect …

… If any part of a square is under the template, that square is included in the area of effect. …

Diagrams 2.1 & 2.2 show this, with the Cone’s origin being on the intersection. Its shadow clearly covers small sections of both squares just after the intersection.

PHB, Page 205:

A line extends from its point of origin in a straight path up to its length and covers an area defined by its width.

My interpretation is that this means using templates on grids increases the average Area of Effect size notably for Cones & Lines particularly.

Does that seem correct?

Visual example:
enter image description here

Which would affect all 4 enemies labeled 1 if the caster is the one labeled 2.

layout – TextField dentro de una Row en Flutter

Estoy obteniendo un error de renderización, cuando compilo mi código Flutter, el método es el siguiente:

Widget _formWidget() {
return Column(
  children: <Widget>(
    _entryField("NÚMERO DE TARJETA", "1234 5678 9012 3456"),
    SizedBox(height: 10),
    Row(
      children: <Widget>(
        _blockField("FECHA DE EXP.", "MM/YY"),
        _blockField("CVV", "123"),
      ),
    ),
    SizedBox(height: 10),
    _entryField("PAÍS", "México"),
    SizedBox(height: 10),
    _entryField("CÓDIGO POSTAL", "123456"),
  ),
);}

El error se produce al no vizualizar los dos bloques que se encuentran dentro de Row, el Widget _blockField contiene elsiguiente código:

Widget _blockField(String title, String hint) {
return Container(
  margin: EdgeInsets.symmetric(vertical: 4),
  child: Column(
    crossAxisAlignment: CrossAxisAlignment.start,
    children: <Widget>(
      Text(
        title,
        style: TextStyle(
            fontWeight: FontWeight.w700,
            fontSize: 10,
            color: Color(0x99000000)),
      ),
      SizedBox(
        height: 10,
      ),
      new Flexible(
          child: TextField(
              obscureText: true,
              decoration: InputDecoration(
                  hintText: hint,
                  border: InputBorder.none,
                  fillColor: Color(0xfff3f3f4),
                  filled: true))),
    ),
  ),
);}

Leí que el problema radica en que TextField no tiene un ancho especifico y es por ello que se debe colocar dentro de un componente Flexible; así:

Row(
      children: <Widget>(
        Flexible(child: TextField()),
        Flexible(child: TextField()),
      ),
    ),

¿Cómo debería implementarlo?

microsoft excel – Look up list of values on different worksheets and return both column and row header

I am trying to look up a list of values in multiple worksheets of a workbook and return both the column header and row header in the cells next to my search value.
I found a code that works perfect for all values in my first column of data (ColB) in the active worksheet. If I add values to my list that are located in another column or another worksheet I get a circular reference error and it places a 0 in my function cells.
I have put my list of values to look up in column 1 under my last row of data and put both functions in the columns next to them.

Can anyone help me fix this problem?

My workbook consists of a growing amount of worksheets in the same format.
Every worksheet has Column headers in Row 1 and row haeaders in Column 1, 81 rows and 40 columns filled with data. The list of values to be looked up can be up to 1000 or more.

    Function MyROW(MyVAL)
With ActiveSheet.UsedRange
    FFIND = False
    For J = .Column + 1 To .Column + .Columns.Count
        For I = .Row + 1 To .Row + .Rows.Count
            If (Cells(I, J) = MyVAL) Then
                FFIND = True
                GoTo MyEND
            End If
        Next I
    Next J
    MyEND:
    If (FFIND) Then MyROW = Cells(I, .Column)
End With

End Function

    Function MyCOLUMN(MyVAL)
With ActiveSheet.UsedRange
    FFIND = False
    For J = .Column + 1 To .Column + .Columns.Count
        For I = .Row + 1 To .Row + .Rows.Count
            If (Cells(I, J) = MyVAL) Then
                FFIND = True
                GoTo MyEND
            End If
        Next I
    Next J
    MyEND:
    If (FFIND) Then MyCOLUMN = Cells(.Row, J)
End With

End Function

enter image description here

google sheets – How to change focus from one cell to a different row and cell

I’m trying to make an ID Card Tracking List in Google Sheets. Example: B5 would contain the issuance date. Once filled in the cell is no longer accessible, focus switches to C5, the expiration date. Once the expiration date is entered,that cell is no longer accessible and the focus shifts to B7 a new issuance date for a different person.Then the process starts over again, moving to a new row and column. At the end of the year all of the prior entries are automatically removed and and the process starts over again for the new year.I can’t figure out how to make it work. This list is only Viewable…This list can only be edited from the master list each manager has for their department.

Table/list: find the last real number element of each row to constitute a list

I have a list (Table), mostly composed of real numbers. The list also contains some non-real elements. The list is similar to the following (but much much larger):

{{0.11011887269, 0.02087291466, 0.02082444233, 0.02083704779, 
  0.02084940959, 0.02086181292, 0.02087425501, 0.02088673503, 
  0.02089925331, 0.02091181001, 0.02092440529, 0.02093703933, 
  0.02094971232, 0.02096242441, test1(18, 15)}, {0.10941526373, 
  0.017604005802, 0.017549654594, 0.017558686829, test1(19, 5), 
  test1(19, 6), test1(19, 7), test1(19, 8), test1(19, 9), 
  test1(19, 10), test1(19, 11), test1(19, 12), test1(19, 13), 
  test1(19, 14), test1(19, 15)}, {0.10890647143, 0.014986243752, 
  0.014927392616, 0.014934004368, test1(20, 5), test1(20, 6), 
  test1(20, 7), test1(20, 8), test1(20, 9), test1(20, 10), 
  test1(20, 11), test1(20, 12), test1(20, 13), test1(20, 14), 
  test1(20, 15)}}

I would like to construct a single row or column list that preserves the last real number element of each row of the above list. For example, with the above table, the resulting list should contain only 3 elements as:

{0.02096242441, 0.017558686829, 0.014934004368}

How can this resulting list be automatically constructed from the original one?

distributed systems – How to Concurrently Add a Row to a Relational Database

Say I have a relational database and I want to support allowing multiple writers to add create a new row in the same table. How is this implemented?

I’ve read a lot about locks for dealing with concurrent access to the same row with shared locks and exclusive locks for example (AKA writing locks vs reading locks) but not about how a new row is created.

How does this work for

  1. A table on a single node with multiple writers
  2. A distributed table that is sharded
  3. A distributed table that is replicated

moving row within a table on draw.io

On draw.io, I am trying to move a row in a table, I grab the right hand equals sign on
the row to move, but when I move it to a new position the row snaps back
to its original position. I am using the online version on Windows 10

Find how many members are the maximum values in both their row and their column im mat

I have a matrix [N] [N] without double numbers.

The goal is to find how many members are the maximum values in both their row and their column.

prints only 1 row

Hi guys finally got a slew of files figured out but this one – I hate it!
I had it working displaying all five rows but now displays only the first. Please, what’s wrong?
——————————
the code:

<?php error_reporting (E_ALL ^ E_NOTICE);

// Include config file
require_once "getprerentdb.php";

//MySqli Select Query
$results = $mysqli->query ("SELECT * FROM paytbl");

//Print version
   //Set at what record to break at 25 records per page
   $BreakAT=25; 
   $num=0;
   $pagenum = 1;
   $totpaid=0;
  // ---------------------------------------
  while($row = mysqli_fetch_array($results))  {
// ----------------------------------------
   if($num % $BreakAT == 0)
  {
if($num>0)
  
    { echo '</table class="print">';
        echo '<div class="breakhere"></div>';
        $pagenum++; }
    echo date('m/d/y');
     echo " Page " . $pagenum;
?>
   <div class="title">Payment Report</div><br />
   <table align="center" cellspacing=0 cellpadding=0 border=1>
   <thead>
     <tr>
<th>tenant</th>
<th>unit</th>
<th>rent paid</th>
<th>rent due</th>
<th>prev bal</th>
<th>late chg</th>
<th>sec dep</th>
<th>damage</th>
<th>court cost</th>
<th>nsf</th>
<th>hud pay</th>
<th>tenant pay</th>
<th>date paid</th>
<th>late</th>
<th align=left>comment</th>
     </tr>
   </thead>
<?php   
   $totpaid += $row('paidsum'); 
  echo '
   <tr>
<td>' . $row('tenant') . '</td>
<td>' . $row('unit') . '</td>
<td align=right class="currency">$'.number_format($row('rentpaid'),2).'</td>  
<td align=right class="currency">$'.number_format($row('rentdue'),2).'</td>
<td align=right class="currency">$'.number_format($row('prevbal'),2).'</td>
<td align=right class="currency">$'.number_format($row('latechg'),2).'</td>
<td align=right class="currency">$'.number_format($row('secdep'),2).'</td>
<td align=right class="currency">$'.number_format($row('damage'),2).'</td>
<td align=right class="currency">$'.number_format($row('courtcost'),2).'</td>
<td align=right class="currency">$'.number_format($row('nsf'),2).'</td>
<td align=right class="currency">$'.number_format($row('hudpay'),2).'</td>
<td align=right class="currency">$'.number_format($row('paidsum'),2).'</td>
<td>' . $row('datepaid') . '</td>
<td>' . $row('late') . '</td>
<td>' . $row('comments') . '</td>
   </tr>';
     $num++;
  }
}
  echo '
   <tr>
     <th scope="row" colspan="11">Total Paid:</th>
     <td bgcolor="#FFD4D4" class="currency">' . number_format($totpaid, 2, '.', '') . '</td>
   </tr>
</table>';
?>  
</center></div></body></html>

PHP:

——————————
the result:
04/11/21 Page 1
Payment Report

tenant unit rent paid rent due prev bal late chg sec dep damage court cost nsf hud pay tenant pay date paid late comment
tenant1 apt1 $540.00 $530.00 $0.00 $10.00 $0.00 $0.00 $0.00 $0.00 $0.00 $540.00 12/20/2020 L
Total Paid: 540.00
SEMrush

 

mysql – Row Level Trigger for insert/update to a table

Given a table ITEM as below :

CREATE TABLE ITEM (
ItemNo        int not null,
category      varchar(20) not null,
Quantity      int not null,
Price       decimal(10,2) not null,
Total       decimal(10,2) not null,
CONSTRAINT pk_item primary key (ItemNo)
);

I need to write a row-level trigger called update_item that will fire whenever Quantity and/or Price is inserted/updated. When this happens, the Total column will be set by the trigger as the product of Quantity and Price.

Any help will be appreciated.