Never use Excel!
Never use Excel!
-- John Larkin Highland Technology, Inc picosecond timing precision measurement
Maybe it's Excel 2000 or some archaic version.
Cheers
That "dotted frame" is an indicator of a selected print area. Easily removed MANUALLY. "PrintArea" seems to be a reserved word for a Function/Method, but there is ZERO info on use ANYWHERE, so (in a macro) one cannot do a File.PrintArea.Deselect or a File.PrintArea.Clear
Well, I never use it.
A text editor or Word for concepts. A program to do math.
Don't use PowerPoint either.
-- John Larkin Highland Technology, Inc lunatic fringe electronics
I used to use Excel to solve non-linear equations. Now I just pop the equation into PSpice.
I agree, PowerPoint is a cumbersome useless piece-a-crap. Much easier to create PDF presentations with the same or better capabilities, such as hierarchical schematics. ...Jim Thompson
-- | James E.Thompson | mens | | Analog Innovations | et |
For a presentation example, see "Sample_Custom_Chip_Design.pdf" on the S.E.D/Schematics Page of my website. ...Jim Thompson
-- | James E.Thompson | mens | | Analog Innovations | et |
You're the boss. The boss can get away with many things his employees can't, including efficiency (Excel is the only MS Office program that actually works).
Word is horrible (and has nothing to do with Excel). Excel does a lot more than "math", though it's quite useful for that, too.
I'd rather go for a root canal, than create presentations with PowerPoint but every once in a while I can't con the boss into doing it for me (I'm really bad at it - by design). Visio used to be useful but they've gone backwards with every release but we still use it for block diagrams.
Word is fine if you turn off all the junk, and don't use goofy styles or macros or automatic toc's. I get Word docs that are so pimped-out that they don't work.
My manufacturing people do their serial number and RMA logs and stuff in Excel, which seems to work. There's not much computation involved.
What annoys me about spreadsheets is that there is seldom any context or version control; it's just a heap of numbers. Even a text file can and should start with a basic statement of what this is, who did it, and the dates.
I use Visio for block diagrams too. The 2002 version, before Microsoft changed it much. Exported EMF files look good in Word docs and subsequent PDFs.
-- John Larkin Highland Technology, Inc lunatic fringe electronics
One of the more complicated things I do in Excel are power tree calculations. I have a sheet that shows the power tree, with the current from each device, traced back to where it's sourced (and where that's sourced). That feeds individual sheets for each regulator, where the computations are made for each component. It goes a little deeper but that's the idea. It organizes the process and provides good material for design reviews.
It's no harder adding any of that to spreadsheets than it is to a text file.
We're stuck with Office/360. It's a real mess but no more so than anything else our IT people do.
Here's a power tree. I used a calculator.
This is from a 76-page design notes document.
-- John Larkin Highland Technology, Inc lunatic fringe electronics
Once i fiddled with PowerPoint and found it lame. Recently, i tried to use it to do a slide show of bunch of PDF files. Barf. Uninstalled it.
It is user error pure and simple. Two short planks problem.
Whilst am am inclined to think that MickeySoft definition of Help is never very good since they include trivia and miss out key info this is not one of them. Type "PrintArea" into Excel developer help and you get:
He's a clueless f****it. Incapable of using the Excel help system.
-- Regards, Martin Brown
On that we are agreed. It drives me up the wall when people design posters using it. The only way to get something out that looks the same for web display is screen capture on a large enough screen. Despite it being XML wrapped it cannot save as a web friendly version that looks anything remotely like the original (same for Word on a bad day too).
Excel is actually useful in its own right for generating test data and some sorts of prototyping because the errors you make in a programming language are radically different to the ones you make with a big table of numbers. It is also quite handy for lazy fitting of functions.
-- Regards, Martin Brown
I have one big customer where everyone sends technical stuff in PowerPoints, with lots of blurry cell phone pictures. Ghastly.
-- John Larkin Highland Technology, Inc lunatic fringe electronics
Word works fine to arrange a bunch of pics and titles, and then export to PDF.
-- John Larkin Highland Technology, Inc lunatic fringe electronics
+1
-- Regards, Martin Brown
That's all a spreadsheet is.
That's about the complexity of one of mine, though I only use one primary switching regulator (different needs) and only small LDOs.
And if anything changes, you have to go through all the documentation. The spreadsheet *is* my documentation.
I keep my design notes doc current, and add notes, like first board measurements and such. We keep a separate "next" file of potential changes to the next PCB rev.
Don't you do that?
My Word doc is my design documentation. It has discussions of theory, pictures, equations, chronologies, links. That sort of thing gets ugly in a spreadsheet.
I have one algorithm that has a 3 page explanation, with paragraphs of theory, equations, diagrams, and tables. How would you do that in Excel?
-- John Larkin Highland Technology, Inc lunatic fringe electronics
ElectronDepot website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.