search for: spreadsheets

Displaying 20 results from an estimated 1093 matches for "spreadsheets".

Did you mean: spreadsheet
2015 Aug 21
3
Would a spreadsheet be a good project using LLVM?
I am thinking about writing a new open source spreadsheet application since I think the spreadsheet applications out there (Microsoft Excel, LibreOffice Calc, etc.) do not have some features that I would really like to use. I would like the spreadsheet to recalculate very fast and wondered if it would make sense to use LLVM to calculate the cell values quickly. Each cell of a spreadsheet
2015 Aug 21
3
Would a spreadsheet be a good project using LLVM?
Mats, Thanks for your feedback. I guess I should elaborate on one of the features I would like to implement. In today's spreadsheets if you want to crunch a lot of data, you usually put the data in rows and put expressions in cells to the right of the data and repeat those cells for every row of the data. I would like to create a spreadsheet system that can process the same quantity of data but only has the a single instanc...
2009 Feb 27
1
R-Google interface: Google summer of code
I use R for data management and ongoing data analysis for amongst other things, a multi-center medical research project. I have found Google spreadsheets to be a fantastic way for all collaborators to be on the same page. Furthermore, Google Forms allows one to capture data from respondents and effortlessly write it to a google spreadsheet. Currently, one has to manually download the spreadsheet as a csv file and then read that into R. Since data ch...
2007 Mar 27
3
Bridging R to OpenOffice
Dear members of the R Development Team, I am looking for people with a deep understanding of R internals to assist in bridging R to OpenOffice. While R is a state of the art statistical environment, less experienced users often find it difficult to work with R. Therefore, I believe that a bridge between R and a spreadsheet program will make this transition less painful. I sincerely believe
2011 Jun 08
3
Spreadsheet in Rails
Hi, Please help to create a spreadsheet view in rails application. Need to display the cell values from DB with manipulating option. Please specify gems/plugin if available. Thanks -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to
2010 Jul 21
2
RGoogleDocs ability to write to spreadsheets broken as of yesterday - CAN PAY FOR FIX
...worked OK until this morning, when my ability to write into spreadsheet > cells went away. I get the following weird error: > > Error in els[[type + 1]] : subscript out of bounds > > Looking at the Google Docs API changelog, I see the following: > > http://code.google.com/apis/spreadsheets/changelog.html > Release 2010-01 (July 14, 2010) > > This is an advanced notice about an upcoming change. > > - Starting July 19, 2010, all links returned by all Spreadsheets API > feeds will use HTTPS. This is being done in the interests of increased > security. If yo...
2010 Jul 20
1
RGoogleDocs ability to write to spreadsheets broken as of yesterday
...a Google Spreadsheet. Everything worked OK until this morning, when my ability to write into spreadsheet cells went away. I get the following weird error: Error in els[[type + 1]] : subscript out of bounds Looking at the Google Docs API changelog, I see the following: http://code.google.com/apis/spreadsheets/changelog.html Release 2010-01 (July 14, 2010) This is an advanced notice about an upcoming change. - Starting July 19, 2010, all links returned by all Spreadsheets API feeds will use HTTPS. This is being done in the interests of increased security. If you require the use of HTTP, we rec...
2002 Apr 26
7
spreadsheet data import
Hi colleages! I want to import data from ms-excel and other spreadsheet formats (lotus, etc). Does exist any way to do it within R? The main problem is that many spreadsheet data use comma as decimal separator and not the point as needed in R (and many software for Linux), so importing data first as a tab separated values does not solve this problem. Thanks, Tom?s Revilla
2012 Apr 05
4
Help Using Spreadsheets
Hello, I am a new user of R and I am trying to use the data I am reading from a spreadsheet. I installed the xlsReadWrite package and I am able to read data from this files, but how can I assign the colums into values? E.g: as I read a spreadsheet like this one: A B 1 2 4 9 I manually assign the values: A<-c(1,4) B<-c(2,9) to plot it on a graph: plot(A,B) or make histograms: hist(A) But
2008 Sep 15
1
Help... Organizing multiple spreadsheets data into a huge R data structure!
Hello R users, I am relatively new to the R program, and I hope some of you can offer me some suggestions on how to organize my data in R using some of the more advanced data structuring technique. Here's my scenario: I have date set of 50 participants (each with conditions and demographic data), each participant performed 2x16 trials, for each trial, there was specific information about the
2009 Feb 03
5
reading .odf spreadsheet into R
I have searched the archives and I did not find the answer to my question. Is there a way to read in a .odf spreadsheet without modification to a .csv file. I am analyzing my classes scores on their first exam, and would like to read the grade book in without converting it to .csv. thanks -- Stephen Sefick Let's not spend our time and resources thinking about things that are so little or
2020 Oct 29
8
[RFC] FileCheck: (dis)allowing unused prefixes
...eir tests: - either leveraging the flag, to explicitly indicate that unused prefixes is intended (i.e. add --allow-unused-patches=true); or - fix the test (e.g. maybe there was a misspelling issue/omission/etc). A spreadsheet with the failing tests is available here <https://docs.google.com/spreadsheets/d/1o6q3XH1n3DDyyccnYZ_kVfhFbTDzC_S09e973_cwYuw/edit?usp=sharing> [1]. The request to the community members is to please sign up for their respective area in the spreadsheet, and then mark it completed when that's the case (yes/no in the respective column). When all the tests are fixed, we...
2003 Jul 11
2
Problem with opening Excel spreadsheets that client cannot write to
We have some Excel spreadsheets stored on our Samba 2.2.8 fileserver. The permissions are set such that some users can write to these and some cannot, but they can all read them (the world-readable bit is set). When a user with read/write access tries to open the spreadsheet, there is no problem. The user is happy and productive...
2017 Apr 06
2
Excel shared spreadsheets behavior
Hello everyone I trying find what it happens on my Samba AD servers especially with shared spreadsheets, my personal opinion this feature on Excel is crap and unreliable but many people use it, how does Samba currently behave with this ? Is someone experienced any problem with this ? Frequently happens changes made by other user are lost the spreadsheet opens as read only , the shares are all using v...
2007 Sep 13
2
Export Step Function Coefficients to Spreadsheet or Text File
Hello, After I use the lm() function to perform a multiple linear regression, and then use the step function to eliminate variables that predict the weakest, I need to export the final equation to a spreadsheet or a text file. Below is some sample code. In the end I want to export the coefficients to a spreadsheet. Will you please direct me to the appropriate syntax? Thanks for your time, --Eric
2008 Aug 27
0
Edit & Email an Excel Spreadsheet in Rails 2.0
Dear Group, I hope someone out there can help me with this. I am building a Rails 2.0 application for a customer. The customer has a number of Excel spreadsheets which he would like his customers to open and complete online then submit the completed spreadsheet to him via email. A typical scenario would be: (1) The ''empty'' spreadsheets are provided as a list on the web site. (2) A user clicks on one of the spreadsheets and it opens in t...
2009 Mar 09
3
Creating an Excel file with multiple spreadsheets
DeaR all, I'd like to know how to create an Excel file with multiple spreadsheets from R. I searched the help files and found [1] but it is not what I want to do. Let's say I have a data frame called DF as in the following code # Some data set.seed(123) ID<-sample(5,100,replace=TRUE) X<-rnorm(100) Y<-rpois(100,10) Z<-X*Y DF<-data.frame(ID,X,Y,Z) str(DF) I...
2005 Jan 03
3
spreadsheet addiction
There's a new page on the Burns Statistics website http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html that looks at spreadsheets from a quality assurance perspective. It presents R as a suitable alternative to spreadsheets. Also there are several specific problems with Excel that are highlighted, including the status of statistical functionality in Excel. Patrick Burns Burns Statistics patrick at burns-stat.com +44 (0)20...
2010 Mar 12
4
Form using R
Hi, R users We can create a form using R? I would like to create a form where the information can be read by R. Itneeds to be updated daily because I have to tabulate the reasons for delays in the generation of numerical models products. I really appreciate any help, Thanks in advance, Nilza Barros [[alternative HTML version deleted]]
2007 Dec 14
1
RJDBC to OpenOffice Calc as RODBC to MS Excel
Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn...