Solved

Document template for graph paper

Posted on 2001-07-23
11
1,920 Views
Last Modified: 2013-12-02
Are there any templates for fine-grid (1 mm) graph paper or fine grid polar graph paper that can be used in MS Word? It would be easier to have it in one file with the student exercises instead of sorting an extra printed page to each exemplar.

I looked in the internet, but I found only Postscripts that couldn't be converted to EPS (or at least Ghostscript couldn't) or PDFs.
0
Comment
Question by:mdietz
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 13

Expert Comment

by:cri
Comment Utility
Just an idea:

Define a Excel XY diagram, delete/hide the Series. Advantage:
- Much better precision than using a worksheet range as column width rounding effect far too big at 1 mm (width ~0.31).
- Allows distinction between major (1 cm) and minor gridlines ( 1 mm ). Looks better and makes printout less demanding regarding precision.
- Allows to predefine titles, axis scaling, etc.
- Easy creation of logarithmic scaling
Then Copy/PasteSpecial it as picture and finetune the size with the printouts on all available printers. WYSIWYG ? Within 2-5%....

As for polar grids: No idea other than to use MathCad or a similar program.
0
 
LVL 2

Author Comment

by:mdietz
Comment Utility
I tried your proposal. It may be a problem of our printer, or a problem of Excel, but when I use different line width for major and minor gridlines, the lines for the 1cm grid are too big, and so the whole paper becomes too dark, and if I try different grey levels they are printed all in the same black.

Thanks anyway
0
 
LVL 13

Accepted Solution

by:
cri earned 0 total points
Comment Utility
My Excel 97 SR-2 let me define different gridline line widths for the X gridlines but not for the Y gridlines. The Microsoft Knowledge Base does not seem to list anything in this respect. Oh my.

Only thing left is to make a 2 mm gridline and make sure you have the plot area whithout a pattern. Not exactly a graph paper.
0
 

Expert Comment

by:costello
Comment Utility
If no objections are made in the next 5 days, I will force accept the contribution by cri.

costello
Community Support Moderator @ Experts-Exchange

P.S. This post is made as part of the general effort to clean up this topic area, meaning, looping through all the open questions with no activity since 21 days.
0
 
LVL 13

Expert Comment

by:cri
Comment Utility
costello, my comment was only an idea which failed the 'Microsoft test'...Probably the only working solution left is to use a scan of a graphing paper or to draw one with a CAD package. I suggest you PAQ it and refund the points.

0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 2

Author Comment

by:mdietz
Comment Utility
Refunding points isn't necessary. I'm not using this service that often and so I collected aboz 6000 Question Points, but I recommend deleting the question, as a PAQ status could make other think, the problem was solved.
0
 
LVL 13

Expert Comment

by:cri
Comment Utility
Then why do you whack me with a C ? And, BTW, a PAQ does not necessarely have to be "sucess only solution", knowing that (most probably) there is no other 'solution' than a scan can save a lot of time.
0
 

Expert Comment

by:costello
Comment Utility
I will refund the points and change the grade to an A.

cri is right, you should not grade the unability of a software, but the willingness to help of an expert. I believe cri did all he could here to help you.

costello
Community Support Moderator
0
 
LVL 13

Expert Comment

by:cri
Comment Utility
costello, thank you for rectifying this.
0
 
LVL 2

Author Comment

by:mdietz
Comment Utility
Sorry, but I thought I should grade the answer, not the expenditure anyone had to present it. I know that cri

A: The solution is so good, I don't have to do anything else than what the solution says.
B: The solution is good and helps very far, but  Istill have to think about a few remaining problems and have to put some work in it.
C: The solution helped in some way by pointing me to the right direction, but the most brainwork for that problem remains with me.

The lines between these grades are diffuse, but if I start grading an answer "You can't do it yourself with Excel" with A when the original question was "Where can I download a WORD template", I would degrade all the answers I rewarded with an A. I often graded answers higher,when I saw creativity in the solution, or someone left the common paths of thinking and came to a solution, but I don't even see a shine of that in this answer. I graded the answer with a C to honor your effort, but as the problem isn't solved I asked to delete this question.

The second point is, I thought EE sees itself as a knowledge base. A knowledge base where you have to "buy" answers, but still a knowledge base. Under that point of view you can't say that a solution "you can't" without a real reason is something anyone has to pay for. A "you can't because the designer of that programming language wanted to prevent what you're trying" or "you can't because your object would have to move faster than light" or "you can't because 2 plus 2 is 4" still can be graded, but a "you can't because noone told you a solution" is no absolute "you can't", it still is a "I don't know" and as that isn't saving time. This is why I think Question which ended in a "We don't know a solution" should be deleted. The other possibility is to set such a question to 0 points after it ascended to PAQ status, but I don't see a way to do that.
0
 

Expert Comment

by:Vryeesfeathers
Comment Utility
http://www.marquis-soft.com/gppfree.htm
This site has awesome graph paper in pdf, but it rocks. Totally awesome for projects that require small metric graphs, and since it is pdf, anyone can use it if they go to download.com to get Adobe Acrobat Reader. Good luck. I know this is late, but I didn't run across it until today, Nov 7, 2002.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

PaperPort 14.5 Patch 1 update is often not detected or downloaded automatically. This article provides direct download links to solve the problem for retail (non-bundled) versions of the Standard and Professional editions, as well as the Professiona…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now