doppenhe

20 ms·

181.
by doppenhe 13y ago
have to say mutagen is spot on.
182.
by doppenhe 13y ago
In Excel 2010 a review of statistical accuracy of functions and related work was done. Here is a summary of the work: http://office.microsoft.com/en-us/excel-help/what-s-new-chan... Its also worth noting that Excel only guarantees a certa
183.
by doppenhe 13y ago
This is not far from the truth. In certain cases large solutions have been already developed to take into account any variation in implementation, accuracy or behavior. With millions of custom solutions based on Excel floating around , "fix
184.
by doppenhe 14y ago
As of Excel 2013 it has more database like capabilities (relationships between tables, combine multiple data sources). http://office.microsoft.com/en-us/excel-help/powerpivot-powe...
185.
by doppenhe 14y ago
ive been using CRD for a while... fantastic.
186.
by doppenhe 14y ago
thanks!
187.
Ask HN: Best VPS providers for fast scale-out
6 points by doppenhe 14y ago|9 comments
188.
by doppenhe 14y ago
We should talk i design the bi tools inside excel and would love to understand your scenarios. Twitter: doppenhe
189.
by doppenhe 14y ago
will pass along , thanks!
190.
by doppenhe 14y ago
Excel can be used as a database for analysis though.. check out www.powerpivot.com. This functionality also comes in Excel 2013.
191.
by doppenhe 14y ago
www.excelmashup.com
192.
by doppenhe 14y ago
<disclosure>I work for Microsoft, specifically I am a Program Manager on the Windows Excel team </disclosure> This is actually something we take very seriously and we have been building tools to improve this. Excel 2013 actu
193.
by doppenhe 14y ago
still are.
194.
by doppenhe 14y ago
biased opinion here, i helped build Excel 2013. We did a lot of investments in making it easier to work with your data. Off the top of my head here are some of the top things we did: Flash fill : Automatically detects what you are trying to
195.
by doppenhe 14y ago
congrats on the move... give a shout if you need any recommendations about Seattle (MSFT myself)
196.
225 Digits of π: An Irrational Auralization(225pi.com)
5 points by doppenhe 14y ago|0 comments
197.
Microsoft Employees Raise $1 Billion for Communities Around the World(microsoft.com)
2 points by doppenhe 14y ago|0 comments
198.
by doppenhe 14y ago
Do you really want them to have to write SQL queries? There are tons of modern tools that solve this issue including the latest version of Excel (personal bias :)). A simple tutorial on how to use PivotTables would probably get them 90% the
199.
Creating JOINS between Excel tables(blogs.office.com)
1 points by doppenhe 14y ago|0 comments
200.
by doppenhe 14y ago
Congrats guys love this stuff have been using it for a couple of months. The people who work on the Excel team were really impressed when I demoed it to them. Best of luck!
201.
Make any table data on the web interactive with Excel(blogs.office.com)
3 points by doppenhe 14y ago|0 comments
202.
by doppenhe 14y ago
For Excel in particular the list is actually really long. The big ones are flash fill (pattern recognizition for data cleansing), quick analysis (live preview of different analysis elements with your data), side by side Excel sheets, Chart
203.
by doppenhe 14y ago
thats right, but now you can do all that with JS/Html5. All in all I feel your pain though since i fall into this limitation myself (not a huge VBA fan).
204.
by doppenhe 14y ago
its really is pretty awesome, straight from Microsoft Research. I have been using it for the last couple of months and I don't think I could live without it at this point :)
205.
by doppenhe 14y ago
the apps will stream to your desktop but are desktop apps. O365 is also available which is the web apps.
206.
by doppenhe 14y ago
C# is absolutely supported through the COM interface. Although the built in IDE can only do VBA there is a full library that can be used with C# (how most add-ins are built)
207.
by doppenhe 14y ago
one of the main goals for the Office applications is so that you can create your own visualizations. Don't like any of the charts in powerpoint? create your own.
208.
by doppenhe 14y ago
again I cannot comment on the OSX release because I actually don't know. If your having stability issues make sure to send those crash reports we actually have some pretty cool collection and analysis tools for crashes that lets us work on
209.
by doppenhe 14y ago
the windows and OSX releases are not usually tied together and are actually developed by different teams. I do not have any info on their vnext release sadly.
210.
by doppenhe 14y ago
all office apps since Office 2010 can save to those same standard formats.

More ›