OK... just got Melodyne 4 Studio.  Did a bunch of free form piano snippits...Loaded one up, selected the clip... brought it up in M4s, got the tempo map to show (cool!) but after half an hour have NO idea how to get it into Sonar (SPlat)...
 
Googled, nothing... no manual... I did find this,  which includes a very nicely done pdf for Studio1v3 that someone on their forum wrote up...While I have S1v3, I don't use it and it doesn't work for Sonar.   Can't see how to either export from M4 nor import into Sonar.  I know next to nothing... no, to be precise... NOTHING about melodyne but this has me wanting to finally use it.  
 
A detailed step by step for an idiot would be most appreciated! 

I believe you need to export as MIDI from the standalone version and then import into SONAR.
http://forum.cakewalk.com/FindPost/3356645
 

I've gotten this far But it doesn't work:

1. export the piano as a wav file
2. bring up M4studio external desktop program
3. load the wav into M4... select all (don't know if this is necessary)
4. Click Edit, go to Temp at bottom, click Detect Tempo of Selection
5. File export, Tempo map... (entire length) I save it
6. Go to Sonar, add midi track (don't know if that's necessary...) File import,  Midi 
7. Select the exported midi track (.mid)
8. Sonar LOOKS like it's importing it but nothing happens on the screen, no tempo map appears, and it continues to play at 120 and ignore what ever it invisibly imported.  

 
What am I doing wrong?   I JUST updated to Manchester... before trying this.
 

I believe you have to Open the MIDI file, not import it.  It has to be the starter to the project to set the tempo map.
 

You're right, Matt... here is the procedure one has to use at the moment... 
 
OK, so this is the clugy system that seems to work:

1. export the piano as a wav file
2. bring up M4studio or editor's external desktop program
3. load the wav into M4... select all (don't know if this is necessary)
4. Click Edit, go to Temp at bottom, click Detect Tempo of Selection
5. File export, Tempo map... save it
6. Go to Sonar, Go to file open, and select the saved tempo map (the .mid file in "5" above) your essentially opening up a new song
7. It will import the tempo map... into this new empty song
8. Then you can re-import the wav file melodyne analyzed into this new song.

This is real wacked, especially if you have several live tracks to save and reimport...
 
Studio1 v.3 has a much better/easy/direct ara system per a pdf prepared by a forum member I reviewed while trying to figure this out.  Imports directly in the same song into the tempo map.  While I have S1v3, I haven't used it yet so don't know if this works...
 
I'm sure the bakers are gonna fix this but it's NOT fixed in Manchester as I'm running it...

FWIW, Noel mentioned that they're planning to improve the tempo map integration in a future release.  So yeah, I think Manchester is the first tested version with Melodyne 4 (using ARA) and not everything that can be done.

Vastman

1. export the piano as a wav file
2. bring up M4studio or editor's external desktop program
3. load the wav into M4... select all (don't know if this is necessary)
4. Click Edit, go to Temp at bottom, click Detect Tempo of Selection
5. File export, Tempo map... save it
6. Go to Sonar, Go to file open, and select the saved tempo map (the .mid file in "5" above) your essentially opening up a new song
7. It will import the tempo map... into this new empty song
8. create a MIDI track and put one note at 1:1
9. copy special of the MIDI track (include everything including Tempo map)
10. Open original project and paste special

Revised for simplicity (especially for a large track project).
 

I wonder if you could use a CAL script to apply the tempo map from a MIDI file to the current project?  Automate the process above basically.  I really wish Cakewalk would invest in expanding the CAL/API features in Sonar.