The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
1answer
21 views

Naming of custom bash functions [closed]

I recently decided to get into making my own bash functions and started with two easy ones hex2dec and dec2hex but the names of these are not unique enough. Like for dec2hex, it won't autocomplete ...
0
votes
0answers
3 views

Matlab - Function taking no arguments but not static [migrated]

I am trying to implement the following: classdef asset properties name values end methods function AS = asset(name, values) AS.name = name; ...
1
vote
3answers
6k views

How do I assign a number value to a non-numerical value in Excel

I have some survey responses with values like "VU" for "Very Unlikely" and "S" for Sometimes. Each survey response occupies a cell. For each cell containing a survey response, I want to fill another ...
0
votes
1answer
92 views

Asus R510D with Windows 8: Want to change volume with one button, rather than fn+F10/F11/F12

I have a new Asus laptop (R510D-FH11), and I would like to change the volume with one keystroke. As it is, I have to hold down fn+F10 or fn+F11. Because of my keyboard layout and average-sized female ...
0
votes
1answer
32 views

=randombetween with a certain percentage between a narrower range

I want to randomly generate dates (within a four-year period) for 32 different records/rows in excel. Additionally, I want 75% of those dates to be during one year in particular (within that four ...
1
vote
2answers
46 views

Function that interpretes trailing 'n' characters of a word as argument

Is there a way to pass the trailing n characters of a command to a function, so that it executes it as two commands? For example I define my function as abcx and whenever I enter abcxfoo to the ...
0
votes
2answers
3k views

How can I use multiple IF functions in Excel 2010?

Well, I am putting multiple =IF functions in a particular cell in Excel 2010. The Value if True part of the function is A18*0.5, however when I put more =IFs in the cell then the Value if True is ...
0
votes
1answer
79 views

How do I use variables in bash to output to a file and to a mail body with sendmail

I've been working on this little script and it's nearly at a point that I can start using it. The idea is to automate WordPress installs via Plesk. I've got Plesk setup with a cronjob to download ...
0
votes
1answer
38 views

Excel - Concatenate words separated by “_”

I need help with the following problem: My column in A2 in Excel has the value: TB_PLACES_NAMES But I need to separate the "_" from the others words in the same column. I've tried this function: ...
0
votes
2answers
889 views

.bashrc reports unexpected EOF

I am trying to add some functions to my bashrc, namely: h () { history | fgrep $1 | sort -u | cut -b 8- } extract () { if [ -f $1 ] ; then case $1 in *.tar.bz2) tar xvjf $1 ;; ...
0
votes
1answer
73 views

Stop execution of a function after a given time in PHP

I have five exec() functions in my script. I want to set it up so that if a function fails to respond in a given time, the function will be killed and the next function will start its execution. ...
0
votes
1answer
547 views

My bash script does not find an existing file (into the script's wd) which name I passed as a parameter in a function

I realized a bash script that works on an existing text file located into the same working directory of the script. The script take name of the file to compute through a function parameter. The issue ...
0
votes
0answers
96 views

AutoHotkey Script request: Autocharging and Autofire

This is a script request which would work for Mega Man and some other games. An AHK script which enables autocharging and autofire. I'm a newbie with programming so I believe I could use some help. ...
0
votes
1answer
15 views

Find and then ask to perform action

I have a few macros to help refactor code that I have inherited. For instance, this macro adds spaces around a = character: nnoremap <leader>bg /[^ ]=[^ ]<Return>a <Esc>la ...
1
vote
1answer
344 views

How to create an Excel SUMIF formula that can compare different date formats

For my source data I have a column of dates in the dd/mm/dddd format, and a column of values next to it. eg 03/02/2014 5 17/02/2014 4 03/03/2014 5 17/03/2014 4 On a summary sheet I have a ...
1
vote
3answers
636 views

How do I handle the failure of a command in a bash function?

I have a bash function on one of our test servers that deploys our code, but one of the commands fails frequently and we can't find the cause. We just retry until it works. I want to have the ...
0
votes
1answer
76 views

Converting Monthly data to Daily data on EXCEL for MAC

I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular ...
0
votes
1answer
34 views

How do I reverse a function button

My old laptop I could press f1 f2 etc no issue and to use extra features there was a function button to press with f1 for example to do something like volume control My new laptop works the other way ...
2
votes
1answer
65 views

Export bash function over SSH

I would like to export a bash function over ssh to use it in GNU parallel. That question seems to be answered here Exporting bash functions through ssh but I don't seem to be able to get it to work. ...
0
votes
1answer
296 views

Passing parameters to python -c inside a bash function?

I need to print the value of a Django setting while in a Bash shell. Basically, the command I'd like to run is python -c 'from django.conf import settings; print settings.MEDIA_ROOT'. I need to be in ...
4
votes
1answer
173 views

ms excel find and replace @ symbol results in broken formula

I'm trying to search and replace in excel, the column is formatted as 'Text'. Find: [@ replace with: @ Whenever this finds a match at the start of a cell i.e the cell contents start with [@ and ...
0
votes
3answers
72 views

Excel - Referring to a certain cell based off of data in another

I have a spreadsheet where there is one table with the headings: Coordinate, Lat, Long Another with headings Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area What this is for, is taking ...
0
votes
2answers
135 views

Excel VBA Right Function Error

I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error ...
0
votes
1answer
225 views

Ignore “[Value_if_false]” when value is true

In Excel, I am using an IF function and using the OFFSET function to assign a value in the [value_if_true] and using a 0 for the [value_if_false]. The true OFFSET function was occasionally returning ...
1
vote
0answers
112 views

Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed. I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...
0
votes
0answers
52 views

Batch file function is executed without being called

I defined a function, the strange thing is that the function lines are executed even if I do NOT call the function !! echo off cls REM call:ctrlService "stop" "1.1.1.1" echo.SERVICES STARTED ...
4
votes
2answers
8k views

Change middle mouse button function in Windows

Is there a way to assign a function (like cut/copy/paste) to the middle mouse button or scroll wheel in Windows 7?
2
votes
1answer
452 views

Excel formula for one cell to repeat across a different column (perhaps IF command)

I'm wanting to look up if a series of values (Column N) fall within a specified range. Currently trying this: =IF(AND(N:N<=C2,N:N >=L2),"YES","NO") This does not properly work. I want to ...
3
votes
1answer
779 views

Combining two IF functions in one cell using Excel 2010

I have these two IF functions that work correctly on their own. I need to combine the two into one cell but can't seem to get them to work. Any help would be appreciated. And thanks in advance. ...
1
vote
2answers
2k views

Excel- If multiple cells in a range are blank, return an answer

In Excel (365 edition), I want to have a formula determine whether in a range of 5 cells, 3 of those cells are blank. If there are 3 cells, I want it to display INELIGIBLE, if there are fewer than 3 ...
2
votes
1answer
414 views

Excel: Reverse VLOOKUP with comparaison

I have an original table (the value column is sorted): name | id | value --------+-------+------- abc | 1 | 12 def | 2 | 15 ghi | 3 | 23 jkl | 4 | 29 ...
0
votes
1answer
22 views

Why is GVim displaying the output from system() function as ^M and ^@

function! g:insert_date() let l:pattern="\\d\\{2}:\\d\\{2}" let l:match=match(getline('.'),l:pattern) let l:curline=getline('.') echo "Current line: ". l:curline normal gg ...
0
votes
0answers
28 views

Excel String compare [duplicate]

I am trying to compare string and then display the what doesn't match between the two of them, for example: take A1 which contains [alpha:beta] and then B1 which contains [alpha] and it will match ...
1
vote
1answer
270 views

Exporting bash functions through ssh

So I found a way to transfer environment variables through ssh without having to change neither server nor client: Transferring environment variable through SSH / quoting in bash/sh/csh/tcsh But I ...
1
vote
3answers
1k views

Display multiple cells if data on another workbook contains “X”value

I export a complex report daily and I transfer that information manually into another excel sheet. My question is: In workbook 1, can I get a group of cells in a row to display the text in workbook 2 ...
-1
votes
1answer
72 views

Emacs - Specific Bracket Behavior Customization

In emacs, I prefer the electric-pair-mode behavior for parentheses and brackets as opposed to what seems like the "jumpy" default behavior. However, I currently use auto-newline and like the ...
0
votes
2answers
60 views

May someone be able to fix this function please?

Like, what is the problem with it? =IF(F2>6,=A18*0.5,=A18*0.6) It keeps on making it just say =A18*0.5, not the actual contents of half of A18. So can someone try make this work? All help ...
1
vote
1answer
180 views

Call on a cell in Excel up to the first semi-colon

I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?
0
votes
1answer
150 views

Easy MS Excel - MIN column with IF condition checking another column

I'm analyzing some personal expenditures for somebody on Excel. I have a column for calendar dates and a column for expenditures on that date. Of course, there are days when there are no expenditures ...
0
votes
1answer
511 views

Libreoffice Calc - Fill with Sum is not working

I want to add 2 columns of data and output the sum into a third column, with a =sum(a1+b1). With many rows of data, I try dragging down the highlighted cell to Fill the rest of the output column with ...
2
votes
0answers
539 views

Linux Mint 14 Cinnamon - Fn Keys Brightness Level Intervals

I have a question in regards to setting the brightness level on laptop display using the function keys; I have determined that my screen is capable of having it's brightness level set to values 1-10 ...
2
votes
1answer
32 views

Rename selfdefined function

Having a precmd() that does quite a lot, like checking for VCS information, I want to disable it when I'm navigating on slow mounted network drives. I came up with the following with which I can say ...
0
votes
1answer
107 views

How to get the data from one cell to alter the function of other cells

I have 10+ worksheets, with the same layouts, all containing data from different days jobs. I am trying to create a "SimpleSheet" that only pulls specific data from one days sheet in a nice layout. So ...
1
vote
0answers
31 views

Custom function COUNTIFUNIQUES in Excel [duplicate]

Possible Duplicate: Excel: how to count number of distinct values in a range? I would like to create a custom function COUNTIFUNIQUES that extends the functionality of COUNTIFS. Here is an ...
-4
votes
1answer
60 views

Syntax for Functions in Bash

I do know the JavaScript syntax: var functionName = function(some perameter){ some code here; }; but what is the syntax for a function in bash?
3
votes
2answers
5k views

Excel - define a formula in one cell to be used in other cells with different inputs like a function

I use excel 2010. I want to use a formula defined in one cell as if it was a user-defined function. Example: In A1 I put something like (I know it's not a real syntax): = 3 * Input + 15 And then ...
2
votes
3answers
239 views

How do I make a bash alias that outputs file names in a format I can pipe to vim?

When rebasing with git, I'm interested to open the files that have merge conflicts. I can do this with: vi `git diff --name-status --diff-filter=U | awk '{print $2}'` but if I alias that: alias ...
0
votes
1answer
248 views

excel function searching multiple rows

I have a worksheet with a column (A) with dates. Some rows between dates are blank. I want to put a cell on another sheet that searches sheet1, column A for a particular date, and when that date is ...
0
votes
4answers
3k views

Function key emulator for Dell inspiron 6400 on external keyboard

I have a 3 year old Dell inspiron 6400 with windows 7 and ubuntu 9.10 dual boot. I messed up my Laptop keyboard and hence my Fn key is not working and I need it to activate the wireless whose ...
2
votes
1answer
1k views

How to return current record number in Access?

I want to have my table to automatically returns current record number. What functions should I input in default value of this field (indicated in blue arrow) in order to automatically generates ...