I made this post to vent and was made aware of this place.
the tl;dr without the snide remarks: Db admins want to move analysts off the production server and use a new SQL server that combines the data from 2 other servers we were using. But the new data they've given us is missing pieces that were in the 2 production servers in addition to retaining all inconsistencies (column titles, column content).
I'm new to the company it's only been a month, I don't know what the back end looks like. I don't know how big of a mess it is, I don't know if their rational is reasonable. I made an azure SQL server for myself to tool around in, to upload data make tables etc... it didn't seem particularly hard to rename tables / columns - but I've not worked in a DB at an enterprise level so I don't know what the backend looks like, I don't know if their roadblocks are legitimate or not... keep reading on reddit ➡
I just cannot seem to get it. I like the way material looks/feels. But say I try to replicate Facebooks login header (in desktop mode) - I have my title on the left side, then I want my login in on the left (I managed to get that too).
My problem is that I cannot shrink the inputs (specifically text inputs). I tried styling it with height=20px but nothing changes.
I'm trying it with css grid, and now I'm on Bulma, but I still cannot change the sizing. In case, my question is not clear enough, the gist is that I want to be able to make google material inputs smaller. I'm using the inputs with floats if that matters.
Ideally I want ->
column(title) column(empty) column(<loginFrm></loginFrm>
And in loginFrm.html,
... keep reading on reddit ➡
<form class="columns" #logingForm novalidate> <div class="column"> <mat-form-field> <input matInput class="" type="text" placeholder="Username"> </mat-form-field&
None of my old scripts seem to work in SP365, and it's extremely frustrating -- I'm not sure what's causing this issue, but it's driving me crazy. I've rebuilt/migrated the old Script Library to a new SP365 Script Library in 'Site Assets' to no avail, so I figured I'd use web-references. No dice.
Here is an example...
I want to put a simple autocomplete in a custom, default New Form.
The Attempted Solution I created a custom default 'New Form'. I've edited the deault new form, and have tried placing this in a script editor above and bel... keep reading on reddit ➡
I'm doing covid data analysis.
What I'm trying to do is, for example, if a column has "Italy" is the first cell in a column, I want all of the other cells in that column to pull data from the Italy tab.
I know how to do it for a single cell.
But what I want to do is to be able to copy and paste the same formula across the entire sheet and have the corresponding cell reference automatically change.
I don't know how the terms to correctly explain this, but if you have a formula "=c4+d4" and you paste it down a column it automatically adjusts to "c5+d5".
That's what I want while dynamically grabbing the data based on the column title.
IF Rangers, as now seems likely, don't go on and claim the Premiership title this season, they will have nobody to blame but themselves.
The fingers will point at Steven Gerrard and his players and it is they who will feel the heat from punters and pundits if Celtic go on and turn a ten-point lead at the top of the table into nine-in-a-row.
The fall-out when Rangers have stumbled this season is fierce. Everything from Gerrard's team selections to his tactics, from his players' mentality to injuries and suspensions is debated.
But the role that refereeing decisions have played cannot be overlooked. It is not an excuse, far from it, but the men in black have cost those in blue over the campaign.
Blaming the officials in the aftermath of a defeat can be an easy cop-out for a boss. As Gerrard said after the game with Livingston, you can be seen to be getting the violins out if you focus on the referee rather than your individual or collective failings.
The Gers boss was clearly upset... keep reading on reddit ➡
Not sure if this has been posted but I just found something interesting. The page from Liber Primus called 229.jpg that I'm referring to is seen here https://i.imgur.com/DNqXu5r.png
I figured out something with the 5x5 number grid. I plugged the numbers into excel and summed each row and noticed it added up to 3301. Also summed each column and noticed each column also sums to 3301. Then I summed diagonally (top left to bottom right) and it sums to 3301. Then summed diagonally from (top right to bottom left) also it also sums to 3301. I don't think solves anything but just found it interesting nonetheless. Hopefully somebody can look into this and take it further!
Picture example of rows,columns, and diagonals all summing to 3301 below.
tl;dr I just found it interesting how the whole grid's rows, columns, and diagonals all sum to 3301!
I finally started a column about obscure and quirky C64 titles, focused particularly on game design but also trying to make it interesting for people who "weren't around" at the time.
Does anyone remember Fiona?
GUI mockup with added simple column description of what it does:
After switching to Advanced Mode I couldn't figure out the purpose of two columns in the new more advanced popup of uBlock. Until I done trial and error and observed the rules and noticed that controls in first column are global and apply to all websites and the second column only applies to current page and is per-page control. Why isn't this absolutely obvious from the interface already? They are just blank columns...
Simply adding "Global" on top of column that applies rules globally and "Page" to column that applies rules per-page makes a HUGE difference to usability and makes columns basically self explanatory from there on. Red is block, grey is "with rules" and red is blocked. Then you just tick things in appropriate column. But without Global and Page text above both columns they just don't make any sense.
Would greatly appreciate if this tiny change is do... keep reading on reddit ➡
I am making a spreadsheet that requires you to dump a query from our ERP system into its designated tab. There are 2 or 3 columns I'd like to return on another tab.
Normally I'd Index the specific column that has the values I want to return, with a Match function for a specific array column I'm matching it too... simple.
The problem is that the query/dashboard within our ERP system allows users to change the column order. Obviously now someone's import of the query may not match my Index and Match Array columns in my function.
My Spreadsheet Headers:
(I'm indexing "Price", and my Match Array is "Description" (we'll call it Index($B:$B) and Match(sheet1,$C:$C,0) (ignore sheet1, I just used that to keep the formula consistent with Excel, for this example focus on Column B&C.
Now my coworker has organized their columns differently, and now my formula would end up indexing "QT... keep reading on reddit ➡
Hello everyone, I have the following proble: for a monthly reporting I am using pivottables to gather the relevant data from another workbook.
The PivotTables are looking like this right now.
I have been struggling for several hours now to do a rather simple task: Is it possible to have the following layout somehow?
|Row Labels||Sum of Jan||Sum of Feb||Sum of Mar|
Any help would be greatly appreciated
For reference, this can be done in Excel so even if the user scrolls very far, the labels can still be seen for ease of use
Hi All, I did a quick search and didn't find the match (also googled for a bit and didn't quite find the answer).
Anyways what I want to accomplish is basically what Python/Pandas does with append. I'd like to merge two or more datasheets into a master sheet, if the column names match, just add it in the rows under, if not create a new column and put the data under that column.
A B C
1 2 3
4 5 6
B C D
7 8 9
10 11 12
Should Result In
A B C D
1 2 3
4 5 6
- 7 8 9
- 10 11 12
Is this making sense ? Basically just keep adding rows under, if column match pun in that column, no match create a new column.
The reason for this is I'm trying to merge data together to slice and dice the data better, and SQL Join logic doesn't quite work the way I need it to. I've seen a tool called Merge Sheets but I wanna try and figure out how to do it myself. That and I could do it in Python pretty quick but can't find the equivalent in Sheets and it's drivin... keep reading on reddit ➡
As sometimes happens in life, I struggled with what to write this week. I put several ideas to paper, didn’t like what I had written, abandoned it, and tried to write about something new. As the midnight hour approaches, I turned to looking up Mr Rogers’ quotes, hoping some inspiration might strike. I found my favorite quote of all time from him:
Love isn’t a state of perfect caring. It is an active noun like “struggle.” To love someone is to strive to accept that person exactly the way he or she is, right here and now.” (From “The World According to Mister Rogers.”)
I have always loved this quote because not only does it admit that love is not some easy feeling, but by using “struggle” as an example, Mr Rogers already seemingly points out to us that love can be a struggle - That love is an active thing too. So, it can be inferred that love is something that we have to actively work on, and struggle with, and most importantly “to accept” another person exactly the way they are. I f... keep reading on reddit ➡
So Im wondering how can I get rid of column titles in a .csv file but keep the values associated with the columns.
Name Hobby Mike Guitar Joseph Toys Grace Planning Elliot Volunteering
Mike Guitar Joseph Toys Grace Planning Elliot Volunteering
I want to basically get rid of those two titles
I'm trying to automatize some student assessment analysis and am running into some issues. So the data makes more sense, the assessment is supposed to approximate the students' reading level based on a few things, but for now, I'm just working with their number of errors. Here's some sample data:
|Student||Errors Grade 1||Errors Grade 2||Errors Grade 3||Errors Grade 4||Errors Grade 5||Errors Grade 6|
I have another tab where I'm keeping the summary/results of the assessment (as opposed to this raw data) and am trying to make another table that looks something like this:
|A||2nd grade||5th grade||6th grade|
|B||1st grade||-||2nd grade|
|C||1st grade||-||2nd grade|
|D||1st grade||2nd grade||3rd grade|
In this summary table, the highest grade with 0 errors is considered independent, the highest grade with 1 error is instructional, and the lowes... keep reading on reddit ➡
i have about 300 product categories with over 40 components for each product with a bunch of info. i need to make a searchable cell where i can write the component number and i can get related info. i have made a mock table using food for example and what my goal for it to look like. i know i can do it manually but i need to do this a lot and can never do it all by hand. im going to try to copy table into excel, but here is a link to the picture "i hope it doesn't get removed" https://ibb.co/NTVB2ZL
Good for her. I had a crush on her before but now it’s a full on love affair.
So I am comparing two companies (A and B) and I've contructed table where I listed the count of items where the total cost for company A is less than company B, company B is less than company A, company A is equal to company B. I am also planning to calculate the total cost for each of those three items.
Hi, I was wondering if there was a way/formula to be able to search a table, using the row, column titles for the value at the cross section, for instance, in this example, if I could enter (2,3) and it would spit out J. I am trying to do this kind of lookup for a very large amount of data. I tried making an IF/AND conditional formula, but doing that for the amount of data I'm trying would take, pretty much several pages of code. Hope I was clear enough. Any help is appreciated!
I want to make a "by continent" quiz, but there are two things I don't know: 1. How do I make like a title as Europe and put two columns under there?
2. How do I make (and design) more than one grid?
Hello, I'm new with the automation of Excel and in my work we're trying to optimize time. We daily download 3 workbooks to separate data based on the name showed in column A and only using the values of column B if column D or E is equal to zero.
Usually we have a lot of duplicate names in column A so I think it will be easier if we can create one new workbook for each unique name in the column A and only have the values of B if the others equals zero.
Is there a way to make this with VBA or with another tool? I tried with a simple copy code but I can only get worksheets for each unique name of the A column.
Thanks in advance.
So I made a pivot table that horizontally displays values for
To show data for the last 3 months
For comprehension I clicked the column header and typed over the base name 0 month and replaced it with May.
The pivot table field list update to reflect this change.
I now update the column header to June, and the pivot table field list retains the May title
How do I make the name update? When I click on the value field settings the custom name is correct. The source name is 0 month. Nowhere do I see “may”.
I am having an issue with chart creation and "axis (category)" labels in powerpoint. I am normally plotting time series.
Generally, in Excel, you can select the entire data block, with the top row being titles of each series and the far-left row being dates or whatever other label you wanted for the x-axis. Excel/Powerpoint usually figure out easily that the far left row is dates. My problem is that this is not working for me in Powerpoint, and the issue began when my company created a new mandatory Powerpoint template that we had to use. (I suspect that the groups who made the template do not really use Powerpoint in the way that I or others who use it to make presentations do, so they did not really notice how much of an annoyance this would be when creating or frequently editing large decks.) What is happening is that Powerpoint is thinking that my far-left dates columns are unnamed series, not the horizontal axis titles. Does anyone have a relatively easy fix for this? I don't... keep reading on reddit ➡
#1 - [Screenshots of what I'm talking about] (https://imgur.com/a/o0DswVO)
Any way to make the album titles (group) show up only when sorted by artist/album? Been searching for solutions on the forums and reddit but to no avail there's nothing.
#2 - [SCREENSHOT] (https://i.imgur.com/MQwsGzY.png) Is there any methods to move and recolor the toolbar and seekbar on the bottom?