Search Results

Search found 4866 results on 195 pages for 'excel ranges'.

Page 148/195 | < Previous Page | 144 145 146 147 148 149 150 151 152 153 154 155  | Next Page >

• How do I calculate percentiles with python/numpy?

  - by Uri

  Is there a convenient way to calculate percentiles for a sequence or single-dimensional numpy array? I am looking for something similar to Excel's percentile function. I looked in NumPy's statistics reference, and couldn't find this. All I could find is the median (50th percentile), but not something more specific.

  Read the article

• How to SELECT the last 10 rows of an SQL table which has no ID field?

  - by Edward Tanguay

  I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten rows to make sure it imported everything. However, since there is no ID column, I can't say: SELECT * FROM big_table ORDER BY id DESC What SQL statement would show me the last 10 rows of this table? The structure of the table is simply this: columns are: A, B, C, D, ..., AA, AB, AC, ... (like Excel) all fields are of type TEXT

  Read the article

• extracting only unique row from csv based on multiple column criteria ?

  - by wefwgeweg

  basically i have rows after rows of data event | venue | date | some | other | columns | here| there are lot of overlapping event that happens at same venue and date. so i would like to end up with only unique events by matching event, venue, date. is this possible in excel , how to approach this ? VBA ? or some option i dont know about ? thank you.

  Read the article

• What is the best way to detect if my page needs saving - ussing WPF MVVM

  - by Eli Perpinyal

  I have an application where you can open many different items (like in excel you can open many different tabs) If an item or "tab" is modified I want to detect the changes and allow the use to save or prompt if the user closes without saving. Maybe enable/disabling save button when a save is available/not available. I am using c# WPF with MVVM pattern.

  Read the article

• protecting non .aspx pages with Asp.net Membership provider

  - by Dave

  I'm currently using the asp.net membership provider (with logins stored in db) to protect certain pages of my site. However, I also have non .aspx resources I wish to protect - word docs, excel spreadsheets, pdfs, etc. Is this even possible? If so how would I go about doing this? thanks!

  Read the article

• Capture output value from a shell command in VBA ?

  - by asksuperuser

  Found this function http://www.cpearson.com/excel/ShellAndWait.aspx But would need also to capture output from the shell output. Any code suggestion ?

  Read the article

• Check for hung Office process when using Office Automation

  - by Rob

  Is there a way to check to see if an Microsoft Office process (i.e. Word, Excel) has hung when using Office Automation? Additionally, if the process is hung, is there a way to terminate it?

  Read the article

• Light and simple bugtracker for a small team

  - by Varnenchik

  I'm looking for a simple and light tool for tracking ideas and bugs for small physics lab team (4 members). Bugzilla and Trac have too much fields and other stuff for us. I don’t think that we need more than issue descriptions and simple categorization. But we are not happy with text and excel files suggested here. Could you please advise me anything easy to install preferably?

  Read the article

• Find Missing Records

  - by Lennie De Villiers

  Hi, My SQL is a bit bad. I got a query that when I run it I return for example 10 rows but there are 15 in my where clause, how do I identify those 5 that I can't find? Off course I can dump it in MS Excel but how do I use SQL?

  Read the article

• Why W3C CSS Validator showing parsing error on "Ends-with" Attribute Value Selector

  - by metal-gear-solid

  Why W3C Validator showing parsing error on this. I selected CSS3 profile also from dropdown. a[href $=.xls]{background: transparent url(ms-excel-icon.gif) left top no-repeat; padding-left: 22px;display: block;height: 16px;}

  Read the article

• Is there a way to select nth column in a SELECT clause from a table/view

  - by Vishal Seth

  I've this GIGANTIC view with several hundred columns and I need to select 114th column something like: SELECT "144" FROM MyView; PS: Obviously, I don't know the name of the column. I just copied the results row into an Excel file, searched for a particular value that is in EJ column so I want to select all rows showing only nth column in my view to do my further debugging. Cheers!

  Read the article

• VBA Or .Net Framework?

  - by hosseinsinohe

  Hi All I Want Develop And Automat Office Softwares like 'Microsoft Excel 2007' And 'Microsoft Word 2007' .But I do not know Use VBA or Use C Sharp Language And .Net Framework to do this? What is the Benefits of Use VBA or Use .Net Framework? Which One Is Better To Learning And Focus?

  Read the article

• How can I call different sprites images and properties of it from a file ?

  - by srikanth rongali

  My small game consists of a player and 10 targets. I have an excel sheet of information of target. It includes the target speed, target accuracy, target probability of hitting of the player. These factors change from target1 to target10. Each time target should appear on screen starting from target1 to target10. How can I call them in such a way?

  Read the article

• How can I extract parts of this filename in Perl?

  - by devtech

  In my Excel sheet with column Changeset I am getting the changeset like: C:\ccviews\hgdasdff-9302\dfcsz\ahgrt\kjhssl\ASGHLS@@\main\ajsdkljlat\hahdasdhfk\1\test.txt\sub\hsdaklfl\3 I need to use split function in a Perl script so that there will be two ouput (input as the above string) the part before @@ (e.g-here C:\ccviews\hgdasdff-9302\dfcsz\ahgrt\kjhssl\ASGHLS) the last character of the string (e.g-here 3)

  Read the article

• jira plugin format issue

  - by zapping

  Does anybody know which date format is to be used, trying to create a plugin that generates a report that can be exported to excel or pdf.

  Read the article

• What's the right tool for this job in Google Spreadsheets?

  - by Daniel Harvey

  Is it possible to nest simple programs within a Google doc spreadsheet, similar to how you would w/Basic in Excel? Or alternatively a simple = syntax using regex, if there is a way to do that in google docs? I want to take a list of multiple names(name1, name2, name3) in a single cell from across multiple identical sheets and transpose them to another sheet within the same spreadsheet, check for duplicates and ignore capitals, etc. Is there a way to do this?

  Read the article

• Need ad-hoc reporting component

  - by Nelson

  We need some simple ad-hoc reporting solution for our ASP.NET web-site. Just an ability to build a query with user friendly interface, then show the result of this query in some table and maybe export it to Excel or print. The solution must be quite easy for end users (our site visitors) who know nothing about databases, SQL and other tech stuff.

  Read the article

• Django save method

  - by Marijus

  So I have a model with a FileField for excel spreadsheet. What I need to do this add another column in this spreadsheet, in each row let user pick from a drop-down list then save it and display it in html. All the picking and uploading will happen through the admin interface. So I have figured out way how to display a spreadsheet in html, however I have no idea how to write this save method. I could really use some hints and tips..

  Read the article

• Do we have any Equivalent of Response.AppendHeader in windows application

  - by cmrhema

  Hi, I came around this technique of converting datatable to excel http://www26.brinkster.com/mvark/dyna/downloadasexcel.html Do we have any Equivalent of Response.AppendHeader in windows application in C#. Regards Hema

  Read the article

• Download file using ajax and webservice

  - by megabyte

  Hi All There is this 3rd party webservice. One of the public webmethods available is a GetDocument() method. This method returns a Document object. The Document object has properties for File(byte[]), ContentType(string) ect. My Question : Can I subscribe to this service using javascript(mootools) + ajax + JSON, return the document object, in this case an excel document, and force the file download?

  Read the article

• How can I make a web-based "table" select like a spreadsheet? (rectangular area vs row-wrap selecti

  - by Dax

  I want to make a table that displays on a webpage, but one requirement is to make it easy to copy and paste into a spreadsheet. Normal HTML tables selection behavior is obviously different from how a spreadsheet like Excel selects -- when you select multiple rows it wraps around instead of selecting a rectangular area. Is there any way to make HTML table behave like a spreadsheet in this regard, or is the only way to resort to a Flash table or something similar?

  Read the article

• How do you read a cell's value from an OpenOffice Calc .ods file with python?

  - by user329257

  I have been able to read an excel cell value with xlrd using column and row numbers as inputs. Now I need to access the same cell values in some spreadsheets that were saved in .ods format. So for example, how would I read the value stored in cell E10 from a .ods file from python?

  Read the article

• When writing a form submit to a file, strip line breaks and commas

  - by bccarlso

  I have a form with a textarea in it. I log the results to a text file on the server, but I would like to strip out any line breaks a user would put in the textarea, as well as any commas that would interfere with importing the comma-delimited log text file into Excel or something for later use. I think this has to do with regex, but I'm no expert and could use some help. Or maybe there is an easy PHP function that will do it?

  Read the article

• How to do number formatting to 1 decimal point in SSRS?

  - by san

  Hi, I have a SSRS report with full of number fields. I would like to have that to be displayed as in one decimal. i tried to use F1. it gives me only one decimal points in html rendering, but in excel exported version it shows 2 decimal points. How can i have just one decimal point both ecxel and html rendering. Please comment. Thanks in advance San

  Read the article

• I know my Before Tax Pay and my After Tax Pay, how can I work out how much I get taxed?

  - by Pete

  I've been entering some data into an Excel spreadsheet to work out my monthly earnings, etc. and was wondering how I can I find out how much I'm getting taxed? Say this is my current spreadsheet: Hours Worked 37.5 39.5 37.5 30 Hourly Rate $25 $25 $25 $25 Before Tax 937.50 987.50 937.50 750.00 After Tax 260.00 276.00 260.00 ??? How can I use this known data to work out my After Tax pay for the 4th column? :/

  Read the article

< Previous Page | 144 145 146 147 148 149 150 151 152 153 154 155  | Next Page >