similar to: No subject

Hi, I'm having a weird problem. I have exel files with links in it to other exel files. When I share the map on a windows server (or windows os) eveything works. When I share it on a samba server it doesn't. When I open the file, it asks to enable macro's (I need them so say yes) - everything fine - After that It asks if I want to rework/check the links (don't know if reworks is

Hi all, I have a Samba 3.0.13 with ACL support running under SuSE and acting as a PDC for the hole organization. Among some shares, there's one that has about ten subdirectories. Everybody can access this share and restrictions are applied over those subdirs. The problem is that, for example, when I create a file (or modify it with Word or Exel) in the Finances subdirectory, the file has my

Hi R community, I want to create a script which will take the .csv table as input and do some prediction and output should be returned to some file.Inputs is exel sheet containing some tables of data.out should be table of predicted data.Will some one help me in this regards... Thanks in advance. I am using Windows R.Please advise proccedure to create Rscript. Regards --------- Vijay Research

k=lm(y~x) summary(k) returns R^2=0.9994 lm(y~x) is supposed to find coef. a anb b in y=a*x+b l=lm(y~x+0) summary(l) returns R^2=0.9998 lm(y~x+0) is supposed to find coef. a in y=a*x+b while setting b=0 The question is why do I get better R^2, when it should be otherwise? Im sorry to use the word "MS exel" here, but I verified it in exel and it gives: R^2=0.9994 when y=a*x+b is used

I used in 2004 an earlier version of R (1.6.0 ?) for quantile regressions Now I downloaded version 2.5.1-win32 and I cannot A) read my old files (Our exel working space was saved in csv) and also the series of instructions does not work, see below (B) rq function is not recognized) filename <- read.csv("filename.csv",header=TRUE,row.names=1) fit95

hello, does anyone know how I can write several matrices from R into one exel-file using different sheets for the different matrices? thank you very much in advance for your help. Marion [[alternative HTML version deleted]]

I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? Or the equivalent java tools? Or

Dear all, I am interested in reading Excel spreadsheets (*.xls) directly into R (I am using version 1.1.1 at the moment). I have not had much luck so far. For the time being, I have been converting Excel files to comma delimited files (*.csv) and reading these into R (using commands such as "read.csv"). This works well, but it would be more efficient if I could read the Excel files

Hello I am trying to import an *.xls spreadsheet into R. I am doing this as follows: > read.table(file("A5_DL.xls")) But obtain the error: Error in type.convert(data[[i]], as.is = as.is[i], dec = dec, na.strings = character(0)) : invalid multibyte string at '?????' So I copied it all over to a text document and tried to import that, thus: >

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

Dear R-experts, It is a quite stupid question but please help me. I am very confuced. I am able to import normal txt ant mat-files to R but unable to import .xls-file I do not understand the online help. Can please anyone send me the corresponding command lines? The .xls-file is attached. In my file we use commas for the decimal format (example: 0,712), changes might be needed. Thanks, Corinna

This is a suggestion for adding to rsync an option "--checksum-path=PROGRAM". Once this option is given, provided it is accompained by option "--checksum", both the receiving and sending side of rsync would compute checksums calling PROGRAM, instead of the usual checksum program. Why is this usefull? Suppose I have two collections of MP3 files at different locations which I

What is the syntax for this? If you have: vector = c(1,2,3,4), how would you output this to column A of an excel spreadsheet? -- View this message in context: http://r.789695.n4.nabble.com/how-to-you-output-a-vector-to-a-column-in-excel-tp2530470p2530470.html Sent from the R help mailing list archive at Nabble.com.

Hello all, I seem to be having a problem importing a data set from Excel into R. I'm using the "read.table" command to import the data with the following line of code: > newborn<-read.table("newborn edit.csv", header=T, sep=",") where "newborn edit.csv" is the name of the file. Unfortunately, I'm getting back the following error message:

Hello, I use google docs' Forms to conduct surveys online. Multiple choices questions are coded as comma separated values. For example, if the question is like: 1. What magazines do you currently subscribe to? (you can choose multiple choices) 1) Fast Company 2) Havard Business Review 3) Business Week 4) The Economist And if the subject chose 1) and 3), the data is coded as a cell in a

Dear , I want to import Excel data (.XLS). Can you help me to this. Best regards. Nour-Eddine HAKIM -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at

Hi Listers, I can't seem to figure out why I loose precision when I try to import a comma delimited file using read.csv or read.table. The fields of interest are rounded to one decimal place. DataTimeStamp TerminalID Hours Minutes Latitude Longitude Status Temperature Battery BootTimes Current Google 1 2/11/2010 12:22:21 PM 4894551 12 0 45.0 -66.5 0 30

Hello: I have been give a spreadsheet to work with formed as one big table. What it consists of is a 10-row-by-40-column table for each of about 70 different locations. In other words, the table row names are repeated 70 times, once for each of the locations (whose names also appear in the same column, where it's talking about the totals for that location), e.g.: A B C

I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in

Dear all What is the preferred spreadsheet-like x-delimited data format for use with R? Should I prefer tab-, comma-, space- or some_other_delimitor-seprated data? I'm asking this because I've been once bitten by CSV data containing ` ' ' (apostrophe) symbols that R couldn't easily digest. Probably no the best approach, I've eventually inspected the document and removed