search for: spreadsheet

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 valu...

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 instan...

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 c...

...e 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 that this will benefit both the R community as well as the potential new users. OpenOffice is an open-source office suite that includes a spreadsheet program (Calc). OpenOffice.org (OOo) is participating in the Google Summer o...

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 r...

...the RGoogleDocs/RCurl toolchain that will restore write access. Please contact me directly if you're interested. Thank you, -Harlan Harris On Tue, Jul 20, 2010 at 10:19 AM, Harlan Harris <harlan@harris.name> wrote: > Hi, > > I'm using RGoogleDocs/RCurl to update 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...

Hi, I'm using RGoogleDocs/RCurl to update 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/changel...

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...

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...

...sing 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 trial (i.e. errors, and timing), and a spreadsheet-like large data set with headers. I have to extract data from each spreadsheet-like data according to the information about the specific trial. And then group then according to trial nature in the 2x16 structure. Then I can further analyse then according to the demographic data grouping the 50 part...

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 so large that all th...

...avior * employ a 'busy beavers' approach, where test maintainers patch their 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...

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 productiv...

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...

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 x <- read.csv('C:/path/*.csv', comment.char = "", nrows = 99, header = TRUE, row.names =...

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...

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&...

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 Stati...

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]]

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$.eth...