list manipulation – Replacing a random ith row and column from a matrix

Currently I am trying to delete a randomly-chosen $i^{th}$ row and column from a square $n times n$ matrix $A$. So far I come up with the following code:

Drop[A, {RandomInteger[{1, 400}]}, {RandomInteger[{1, 400}]}]

The problem with this command is that the random integer for {i} is not the same as the random integer for {j}.

Is there a way of making them consistent, so that I drop the ith row and corresponding column while maintaining the randomness of selecting $i$?

And if the aim was to not delete the row and column entirely but to replace all their elements with, say 0, how would you go about it?

Thank you.

google sheets – Transform multiple columns into single column

I have a Google sheet in which the rows are unique cities and the columns are years. It can grow in two dimensions.

|            |         2010         |          2011        |
-----------------------------------------------------------
|    City    | Temp low | Temp high | Temp low | Temp high |
-----------------------------------------------------------
| London     |    10    |     11    |    21    |     22    |
| Birmingham |    12    |     13    |    23    |     24    |

However, this double header doesn’t work for creating a pivot table.

How can I transform the table such that it grows only in the row dimension and the years are simply a value in a single column?

|    City    | Year | Temp low | Temp high |
-------------------------------------------
| London     | 2010 |    10    |     11    |
| Birmingham | 2010 |    12    |     13    |
| London     | 2011 |    21    |     22    |
| Birmingham | 2011 |    23    |     24    |

list manipulation – Removing a random ith row and column from a matrix

Currently I am trying to delete a randomly-chosen $i^{th}$ row and column from a square $n times n$ matrix $A$. So far I come up with the following code:

Drop[A, {RandomInteger[{1, 400}]}, {RandomInteger[{1, 400}]}]

The problem with this command is that the random integer for {i} is not the same as the random integer for {j}.

Is there a way of making them consistent, so that I drop the ith row and corresponding column while maintaining the randomness of selecting $i$?

And if the aim was to not delete the row and column entirely but to replace all their elements with, say 0, how would you go about it?

Thank you.

Unknown column in ‘where clause’ when using an alias for a subquery in MySQL

This simple query:

select exam.id as exam_id,
(select count(*) from dataset where dataset.id = exam.id) as n_dataset
from exam
where n_dataset = 0

returns the following error:

ERROR 1054 (42S22) at line 1: Unknown column 'count' in 'where clause'

Why?

sharepoint online – The hidden ‘Order’ column in Tasks list not being migrated

So for classic Tasks list, you are able to manual sort and indent items. This sorting is persistent and not personal. List View sorting is set to None.

Manual Sort Buttons

Performing a migration using SP Migration Tool from SP2013 to SPO, classic task list functionality is still fully available.

  • Manual indent of items is migration
  • Manual sort order of items is NOT migrated (it defaults to sorting by list ID)

I have found a hidden ‘Order’ column which isn’t visable anywhere other than opening another column settings on the list and changing the URL to &Field=Order

  • this Order column is not part of any content type or visible via SPD
  • this column is present in the migrated list, but it not populated with data from the source

Anyone know any more about this column, can I extract data somehow?

SharePoint 2019 on premise – Open lookup column item without modal

Does anyone know any JSON formatting which will open a lookup field item directly without opening in a modal first?

macos – How to include footer cells in formula when selecting column range?

I have a sheet in Numbers where I have couple of values in columns and have one footer row. I need to include the cell in column including the footer. For e.g. in the below screenshot, the XIRR formula needs to include the cells A6 and B6 when using formula as Payments and Date respectively. Is it possible to achieve it?

enter image description here

How to loop throug a database table, to safe every column as a single node?

I have a module, which load company data from external db, to save this as content.

function example_create_nodes() {
// Get Data from external DATABASE
  db_set_active('db_wirdfit');
  $result = db_query('SELECT * FROM wirdfit.wirdfit_data');
  db_set_active();

 foreach ($result as $row) {
  $node->language = LANGUAGE_NONE;
  $node->type = "page";
  $node->title = $row->post_title;
  node_object_prepare($node);  //Set some default values

 // Try to set your custom field
  $node->field_id($node->language)(0)('value') = $row->id;
  $node->field_post_content($node->language)(0)('value') = $row->post_content;
  $node->field_post_author($node->language)(0)('value') = $row->post_author;

  $node->date = 'complaint_post_date';
  $node->created = strtotime('complaint_post_date');

  $path = 'content/mytest-' . date('YmdHis');
  $node->path = array('alias' => $path);
  print_r($row);
  node_save($node);

  }

Thats works but saved only one node from the the last row of my table.
How can i loop throug the table and save every row as a single content page.

Thanks for help

microsoft excel – Apply conditional formatting on different column as the column with the conditional formula

I have an excel table that looks like this (but bigger).

enter image description here

If the values in the 2nd, 4th and 6th column are bigger than 0.25, I want the value in the previous column to be red with conditional formatting, like so:

enter image description here

I got pretty far with this question
Conditional formatting based on several columns
using formula =$C$4>0,25 applied to =$B$4
But this only works for one cell. How do I apply this to the entire file?

Excel: how to move “answers” rows into under column “questions”?

How do I move answers from other column to same question under another column, can any one guide the exact formula to achieve this? See example below what needs to be achieved as shown in picture.

Excel to move coloumn