The two main factors, that determine an AV file's size are: Duration and Bit-Rate.
Obviously, your Duration is set by however long your Timeline runs for, and the Bit-Rate is either set in Bytes-per-second, or in some cases by a Quality slider. In your case, the Quality is set at 100%, so the Bit-Rate will be as high, as it can be for that format.
Also, some CODEC's, allow for greater perceptual quality, at lower Bit-Rates. H.264 is one of those. DivX is another.
The reason that a file will be larger, upon Export, than the input media, is because of a difference in the Bit-Rate, and/or the CODEC used.
To reduce the file's size, experiment with the Quality slider in the case of this format. Look closely at the quality, and when you have reduced the Bit-Rate to the point, where you see degradation, turn it up slightly. That will be about as small a file, as you can get, with adequate quality.
You used our recommend YouTube settings for creating a quality video. Which is good.
However, your video is apparently longer than will allow you to post at that quality.
The easiest way to reduce the file size would be to use 855x480 as your frame size. That should make a BIG difference alone and may be enough to create smaller file.
I tried changing it to855x480 with the same presets as discussed in the original post but it made the file larger this time 950.200KB. at the end of the settings when I'm down by the audio tab it tells me how big the file is 801MB has been the average. but when I adjust the limited data rate from 8000 to 1000 the file size goes from 801 to 100MB is this something I should consider or should I try some other type of format to upload to vimeo
The Duration and the Bit-Rates will still be the "big 2," so I would experiment with Bit-Rate.
As I mentioned, some CODEC's allow for better preceptual qualtiy at lower Bit-Rates, than some others, but I am not sure that Vimeo will accept some of them, like DivX, which is a good, streaming media CODEC, but cannot be edited easily. The issue with many of those, and DivX is one, is that the viewer/client will need to download and install the CODEC, and that can be a turn-off to many.
Speaking of duration, how long his your video, Cory? An 800 meg file seems unusually large for an upload!
Most online videos are posted in 10-minute or so segments.
the video is 14min long