similar to: easing out of Excel

I''m trying to create a sequence with no gaps in my db (contrived example, but should work out the same as my real one), and believe db-managed transactions are the way to go about this. It''s my first real ''go'' at transactions, so I may be mistaken about how things really work. Anyway.. Consider this example code: Class Invoice < ActiveRecord::Base def

I have a frame which contains 3 columns: "date" "defectnum" "state" And I want to get the most recent state change for a given defect number. date is POSIXct. I have tried: aggregate(ev$date, by=list(ev$defectnum), max) Which appears to be working except that the dates seem to come back as integers (presumably the internal representation of POSIXct). When I

R People, Thanks for your help on my recent questions, Excel is never going to disappear from my office but with graphics from lattice package and some other stuff in R I have been able to add some value. I have a problem I haven't been able to figure out with aggregation, I mentioned it earlier but didn't state it very clearly. Basically I have many "defect events" and I want

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Somewhat OT, but it looks like a new player has entered the streaming MP3 server arena. http://www.apple.com/quicktime/products/qtss/ QTSS v4 was announced at the QuickTime Live conference today. Amongst its other features, it can now stream MP3s to any Internet-capable MP3 listener program. Source is available at

I would like to create a family of barplots with the same xlimits. Is there a way to "read" the xlimits from the first graph so I can apply it to the subsequent ones? I have tried just taking the min and max of the x data and the plot doesn't show. cheers [[alternative HTML version deleted]]

Hi, I have a problem when checking the package 'probdistr' (on probability distributions). I got this warning * checking index information ... WARNING Vignettes with missing or empty \VignetteIndexEntry: [1] "probdistr-chi" "probdistr-contextra" "probdistr-discrete" [4] "probdistr-discrextra" "probdistr-exp"

Hi: I am going through some of the xtable examples and I can't make the one below work. I need to create a longtable on the fly keeping the column headers for all the pages and I thought this example could give some ideas on how to do it. I am using Sweave and xtable to create my tables and graphics. I wonder if someone could tell me what's wrong. Thanks ## Not run: \begin{small}

Hi! Is it possible to easily cut & paste data from an Excel spreadsheet to an R edit( ) grid or to variable? It seems that R cannot handle the cell delimiters Excel hands over. Regards, Werner

Hi, I''m running the trunk version with drb server. In my ferret_server.log I get a lot of messages like this: #method_missing(:add, ["User", {:first_name=>"blah", :comments=>nil, :company=>"blah", :phone_day=>""}]) Over and over again. But more importantly, since yesterday doing a search has caused an exception: A NoMethodError

Hi Samba Users, I'm in the process of building a Samba4 CTDB /GPFS Cluster joined as a member server to AD that also supports ACL's . It has taken some time but almost everything is working now :) . My one outstanding issue is editing files using Excel 2007 on Windows 7 results in a 'Document not saved' error. I believe this is an issue with the SMB2 protocol as I can edit the same

can any one help me in customizing output(inserting 2 or more tables in a single sheet,creating table title etc.) in excel? I also need to know whether it is possible to create a page with charts and graphs in word by R? thanks in advance..... -- View this message in context: http://r.789695.n4.nabble.com/customize-output-in-Excel-and-creating-reports-in-word-tp3671447p3671447.html Sent from

Dear List Members, I need a bit help about fitting some theoretical distributions (such as geometric, exponential, lognormal or weibull distribution) to the following *dry spell*, *wet spell*, *cycles (Wet-Dry or Dry-Wet)* from my meteorological (daily rainfall) data http://www.angelfire.com/ab5/get5/R.rainfall.txt only for rainy seasen (july - september) of 14 years only:

I am trying to replace a spreadsheet model of a project justification with an R script. I can't seem to track down R functions to calculate Internal Rate of Return and NPV? Am I missing something? NPV doesn't seem so difficult to calculate (at least for a regular series) but I am struggling to identify how to solve for IRR in R. It would be sufficient if it worked for a regular

Dear list,I have read really a lot the past few days, but I haven't found a matching solution for my problem.I have R 2.9.2 on Windows XP and MikTex 2.8 installed.What I want to do is to automate the sweave file generation.I thought I could use the R2Sweave, RweaveLatex, and Sweave in a combination so thatI won't need to do anything.Perhaps some minor modifications at the last step.My

Dear list, I am using optim() function to MLE ~55 parameters, but it is very slow to converge (~ 25 min), whereas I can do the same in ~1 sec. using ADMB, and ~10 sec using MS EXCEL Solver. Are there any tricks to speed up? Are there better optimization functions? Thanks Toshihide "Hamachan" Hamazaki, $B_@:j=S=((JPhD Alaska Department of Fish and Game:

Dear List, As someone who is in the process of trying to migrate from Excel, I'd appreciate any help on this question: I have a data set and want to fit, say, three distributions to it. I would like to create a plot that shows my data points against all three fitted curves (estimated d.f.). Basically, I lookint to creat a plot that looks like the one presented in the attached paper (Figure

Quisiera saber si alguien desarrollo modelos de CRM o Marketing Relacional en la herramienta R? [[alternative HTML version deleted]]

Hello all, I would like to plot the emperical CDF, normal CDF and pareto CDF in the same graph and I amusing the following codes. "z" is a vector and I just need the part when z between 1.6 and 3. plot(ecdf(z), do.points=FALSE, verticals=TRUE, xlim=c(1.6,3),ylim=c(1-sum(z>1.6)/length(z), 1)) x <- seq(1.6, 3, 0.1) lines(x,pgpd(x, 1.544,0.4373,-0.2398), col="red") y

Prior to upgrading from RH7.0 to RH7.3 our Samba filserver worked perfectly. Now we are having locking problems. Initially Iused the same samba binaries built on RH70, I tried rebuilding Samba and reinstalling but it had no effect. If user bon opens an M$-Office file they frequently get a 'file is already in use by bob'. Sure enough smbstatus -L shows the file locked by bob, but bob

Dear All, I couldn't figure and couldn't google out how to make construct a pair of \Sexpr s or a LaTeX macro that would include 5\cdot 10^{-12} into the LaTeX output istead of 5e-12 . Any ideas? Thank you G?bor