Autofill a cell in a list if another cell in the same list contains a certain text value

I want a cell in a SP list to automatically populate/fill-in if a certain text value is present in a column in the same list. For example the list contains two columns named: Route of Flight and Spare Parts.

The Route of Flight column is filled in by the planner with a string of text, e.g. KOKC-KLIT-KDFW-KOKC. If the Route of Flight column contains KDFW then I want the Spare Parts column to auto-populate with “NEEDED”. If the route of flight does not contain KDFW then the Spare Parts column should auto-populate with “NOT NEEDED”.


I’ll polymorph an adult dragon into a mice and put it into a mouse cell. What would happened? [duplicate]

This question already has an answer here:

  • What happens when Wild Shape/Polymorph runs out in a space that's too small? 2 answers

What would happened after the polymorph ends?

Does a dragon stay a tiny sized dragon forever bcz there was a size limitation to enlatge more then tiny creature?

Does a dragontear the cell apart when he becomes huge dragon again? In such case, how many damage he got? And what if the cell is made with adamantium? The same result or not?

What would happened in case it is not a mice cell, but an adamantium box with thin wall?

It looks like that one of these assumptions is the real answer.

Merge and edit two cell phone videos for

I have two cell phone videos the first 45 seconds and the second 30 seconds. I would like to merge them together and upload to I also need to insert introductory video leaders:

  • a 3 second introductory clip “This is before repair”
  • first video of 45 seconds
  • a 3 second introductory clip “This is after repair”
  • second video

What tools are available to create this video in Ubuntu 16.04 (I also have Ubuntu 19.04 installed)?

Note: I didn’t specify a video file format when I made the two videos on my cell phone but it is running Android 7 I believe.

Messing with cell phone during D&D sessions

There are lots of questions on this site about players using their phones (the phone being a symbol for not keeping their eyes on the game — it could be a magazine, a tv, or the bird feeder at the window — any distraction, basically). However, they’ve all come with the caveat that use of the phone diverts one’s attention from the game, thus slowing it down.

I find myself in a different situation. I simultaneously use my phone and am arguably the most attentive player at the table in most cases. During combat, I’m regularly the person who already has his turn planned out. If another person doesn’t realize it’s their turn, I immediately notice it, and, if the pregnant pause goes on too long, I’m the stickler notifying them of that fact.

I’ve never been called out on my phone use (probably because it’s so obvious that I’m engaged when it comes time for me to do something), but as players and GMs, do you consider phone use during game play to be “bad”, even if it does not impact the flow of the game?

Here are some additional details into why I use the phone:

  1. There is inherent downtime in the game. In combat, when it’s not my turn, I’m waiting for it to become my turn. Out of combat is less of an issue in general for me — I don’t play in role-play heavy groups, so there aren’t any real immersion concerns in that respect. So out of combat, my eyes and hands are never required, so they can busy themselves on my phone without any impact on the session.
  2. I have busy fingers. When I’m concentrating, I enjoy having things to do with my hands. I often do origami (or it’s more primitive cousin, folding paper into a grid pattern until it disintegrates), or, obviously, play games on my phone, when I’m doing something that doesn’t require my eyes/hands.

Spreadsheet Cell Color Conventions

Is there some convention for coloring certain spreadsheet cells with certain colors to indicate the meaning/type of cell?

Excel provides the following. Is that an Excel thing or a broader color scheme and style convention?
Are there any best practices and/or guidelines for visually separating inputs, parameters, know constants, conversions, intermediate calculations etc…


I found this for financial data. Not sure how generally acceppted and expected that is.

VBA query 2010 SharePoint list using multiple cell value conditions

I’d like to begin by stating that I am able to successfully query my sharepoint list and import data based on a single condition.

My issue:

  • In excel, I have a list of unique ID’s in column A and column B is titled “Name.
  • The above setup resides on a sharepoint list which contains the name.
  • I want vba to create a ‘query array’ that contains all ID’s under column A and then query the sharepoint list to extract the “Name” and place it in column B.

My code that extracts based on a single condition

dim usr as string usr = "X12345" Set cn = New ADODB.Connection Set rs = New ADODB.Recordset With cn .ConnectionString = sConn .Open End With sSQL = "SELECT [Name] FROM [splistname] WHERE [emp_id]= '" & usr & "'" rs.Open sSQL, cn, adOpenStatic, adLockOptimistic Sheet3.Range("b5").CopyFromRecordset rs 

I’ve tried putting this in a “For” loop, but I have very limited knowledge on how to achieve this or even if it is possible.

Hoping someone can point me in the right direction.

What is the best practice for data table cell content alignment

We are currently working on a windows based application where users capture data. Some data is captured in a table where other data is captured in text blocks. Im currently faced with the dilemma of how to align contents specifically decimal values. Editable cells in a grid are indicated with a pencil icon which disappears once in edit mode. You will notice that the table consists of various field types, decimals and text. So what should I do and why?

A> right align all cell content

B> left align all cell content

C> right align only decimal values in cells

D> Whatever else you can suggest

enter image description here

Keep moving cell phone connected to any tower within specified distance

Solve using ford fulkersen algorithm. Please see the comment section for the source of the problem and for the google doc link to my failed attempt .

“You can tell that cellular phones are at work in rural communities, from the giant microwave towers you sometimes see sprouting out of corn fields and cow pastures. Let’s consider a very simplified model of a cellular phone network in a sparsely populated area. We are given the locations of n base stations, specified as points b1 ,…, b n in the plane. We are also given the locations of n cellular phones, specified as points p1 ,…, pn in the plane. Finally, we are given a range parameter d> 0. We call the set of cell phones fully connected if it is possible to assign each phone to a base station in such a way that

1)Each phone is assigned to a different base station, and

2) If a phone at pi is assigned to a base station at bj , then the straight-line distance between the points pi and bj is at most distance d

Suppose that the owner of the cell phone at point p1 decides to go for a drive, traveling continuously for a total of z units of distance due east. As this cell phone moves, we may have to update the assignment of phones to base stations (possibly several times) in order to keep the set of phones fully connected.

Give a polynomial-time algorithm to decide whether it is possible to keep the set of phones fully connected at all times during the travel of this one cell phone. (You should assume that all other phones remain stationary during this travel.) If it is possible, you should report a sequence of assignments of phones to base stations that will be sufficient in order to maintain full connectivity; if it is not possible, you should report a point on the traveling phone’s path at which full connectivity cannot be maintained. You should try to make your algorithm run in O(n^3 ) time if possible.

Example. Suppose we have phones at p1 = (0, 0) and p2 = (2, 1); we have base stations at b1 = (1, 1) and b2 = (3, 1); and d=2. Now consider the case in which the phone at p1 moves due east a distance of 4 units, ending at (4, 0). Then it is possible to keep the phones fully connected during this motion: We begin by assigning p1 to b1 and p2 to b2 , and we reassign p1 to b2 and p2 to b1 during the motion (for example, when p1 passes the point (2, 0)). “