# How Would I Properly Setup A 2D Coordinate System?

Nov 20, 2009

I am setting up a spreadsheet to be able to calculate loads on spread footings. The thing is the footings may be as small as a 2 x 2 or as large as a 6 x 6 or any combination inbetween so I need a coordinate system (to the nearest inch with a max of 1800 inches) to be able to assign each spread footing to a certain spot in the system with which I can calculate the soil stresses.

I intend to make this as idiot proof as possible for anyone who uses this spreadsheet so I was going to set it up as in the attachment where a user can input each individual load on each footing and the distance between it and its neighbors. The numbers are just random values with in each footing and feet between each one. Naturally most people would probably begin data entry in the upper left footing first so I was going to make that the origin unless for coding purposes the lower left would be best.

In this case the upper left footing would be 0,0 and the footing to its right 20,0 and the one farther right 55,0 (20+35) and so forth.

## Coordinate System - Combine All Data In Single Graphic

Jan 3, 2012

I want to combine all data in a single graphic. It must be like a coordinate system.

The file is in that address: [URL] .......

## DGET Setup - Pull Coordinate Pairs From A List And Match To A Label Based On Certain Criteria

May 15, 2013

I'm trying to use DGET to pull coordinate pairs from a list and match them up to a label based on certain criteria. I can't seem to get it to work. I'm also thinking that the way I have it set up, the coordinate pairs might not stay together and that has to be the case. My criteria is multiple cell based too and I don't think DGET can handle that.

For example, In order for a coordinate pair to be labeled "B" the x coordinate must satisfy a condition and the y coordinate must satisfy a different condition. Can I use DGET with the AND function?

## How To Properly Setup Page To Get Accurate Cashflow

Dec 25, 2013

I am looking to create an invoice details in excel where it correlates to the payment schedule. and the schedule is biweekly starting jan 3rd

I want to also match the start dates to each invoice date, where the invoice date is every 7 days (on a weekly basis)
But, I'm looking to have the invoice date driven in accordance to the employees start date

I'm doing this for a friend, but i'm not sure exactly what he is looking for, and what I have to do in excel

Does he just want me to keep on filling out employee 5 to finish the process?

Or should I create a separate column for each employee for it to be more detailed?

The Overall goal is to get an accurate cashflow

Attached can see what excel sheet looks like : excel.jpgâ€Ž

## Setup New Inventory System?

Aug 26, 2013

We have 100+ clients. Each client has inventory in our warehouse. Every day we write down how many items went out to our client on a piece of paper and subtract that number to get a balance inventory. When we run low, we order more on a new FO number. What is the best approach for tracking this? I was thinking one way is to put our clients in a drop box at the top of the page and then the data will appear at the bottom, however I can't get that to work. I am trying filters to see, but I am unable to subtract the balance automatically from the last FO# and from the correct area.

Is there a way to choose a client and product at the top of the page and have the tracking below?

## Record Windows Paint Coordinate

Aug 14, 2009

You know when you open a picture using windows paint,
there's a coordinate on the bottom right of the screen right?

Now, Is it possible to make a macro that records the coordinate everytime i maka a dot using "pencil" feature in paint?

So everytime i click on a spot in the image (draw a single dot), excel would track the coordinates of these dots and write it vertically in 2 columns (x & y)... the result is something like this :

## Coordinate Lines On Scatter Graph?

Jun 28, 2012

I have the following data points:

A
B

1
X
Y

2
0.18
0.52

[Code] ......

And can create a scatter diagram fine. However, I've been asked if it's possible to show on the graph, for each point a line to it's respective X and Y co-ordinate. For example, for row 4 (in red), on the same scatter graph, I'd like there to be two lines for this point,

Line1 drawn from (0.1, 0) to (0.1, 0.26) and
Line2 drawn from (0,0.26) to (0.1,0.26)

I know it's possible to overlap graphs in Excel, but I can't find how to achieve this with scatter plots

## Coordinate Specific Ranges Across Worksheets

Jan 24, 2008

I have a spreadsheet of several sheets, but 7 of them (Red, Orange, Yellow, Green, Blue, Purple, Black) are the guts of the file and where I make adjustments. The layout of these sheets is the same, there are several cells of data on each sheet that coordinate with data in the same cell on other sheets. The problem is the sheets are so big, when I change sheets I have to go find the data that was in the same cell (or close) to where I just was on a previous sheet. So for example if on “Red” I am in cell AX253 and I go to sheet “Yellow” I would like it if AX253 would be selected when I get there. And if I select a different cell like D56 on Yellow and pick Green then I want D56 to be automatically selected on Green.

In addition, I plan to use a check box on an eighth sheet called “White” to turn the feature on and off. I have never written code for a check box before.

Is this to terribly difficult to do? I did some searching and saw some code that was similar to this but could not get it to work.

## Calculate The Y-coordinate Of The Center Of Mass Of These Datapoints

Feb 9, 2009

I generate a large dataset of X- and Y-coordinates. Togeter, these datapoints form random curves. So, in excel, I want to calculate the Y-coordinate of the center of mass of these datapoints.

## Geographic Coordinate Data Types / Formats

Feb 15, 2008

I often find that it would be useful to have a data type for geographic coordinates (i.e. latitudes and longitudes) that would e.g. permit/facilitate formatting negative values as South and West, direct subtraction of one latitude/longitude from another, conversion of degrees-minutes-seconds to decimal degrees, properly formatted axis labels when using Excel to draw maps (at the moment, I am editing the axis labels in the PostScript file by hand, when I don't use chart labeller to paste axis labels in) and so on.

(Time formats could be used, if only they could be prevented from converting hours over 24 to days, which I have not found out how to do.)

Therefore: does anyone know of any Add-In out there somewhere that could supply the lack of a geographic coordinate data type?

## Estimate Linear Formula From Multiple Coordinate Pairs

Aug 13, 2007

I have 32 pairs of coordinates (X,Y). If I graph them using a scatter chart in Excel, I can see that it looks like they suggest a linear relationship between the points.

Other than printing the chart and trying to draw a "best fit" line manually, is there some sort of way I can get Excel to come up with the "best" linear formula (y=mx+b format)?

Aug 23, 2007

Basically, i've got 90 players on a ladder. When one beats the other they replace them in their position and the beaten player moves down one.

Has anyone got any idea how I can set it up so that I have got a box come up with players names in a drop down box. I can then select the player on the left who has won, and the player on the right who has lost, enter it and the ladder to automatically update.

## Setup/uninstall

Jul 4, 2009

I have an Excel Workbook that is linked to Word.docm files and I want to put them on a CD, But I need for it to have a setup/uninstall format attached. Or maybe you might have a better method. The reasons for the setup/uninstall is for the unknowing person, with limited computer skills. This way from the autorun to setup/uninstall it will already give a destination to install file and add an icon on desktop. More user friendly.

## Forecasting Setup

Sep 14, 2006

If I have a database of 1000 records that are logged and counted as to which of these records are successful and unsuccessful sales,

can excel be programmed to give an accurate forecast of what will be the number/ percentage of successful sales records over the next 100, 50, 30 and 10 new record entry ranges, using the database history?, then which of the new records within each selected range are most likely to be successful sales using the database history?

If so, what components or data references are needed in a worksheet to meet these requirements to allow for creating an accurate forecasting application within excel?

## How To Setup A Spreadsheet

Jun 26, 2008

I am trying to set up a costings sheet for my other half. So far I have worked out his costs for this basics i.e. van etc. man power, days, mileage. He now wants to be able to enter his miles to a job, man power, days etc, Then to show total invoice cost and show profit i.e. if miles need to be changed.

## How To Use Find Properly

Nov 2, 2007

Does anyone have any links to using .find object.find range.find properly? or can explain it?

Basically I have a column of unique numbers... and I have to offset to find what I'm looking for.. however it cannot be done with vlookup because i need it to also go down the column (variable number of entries) to retrieve whatever is under that entry.

## How Would I Get A Cell Value Into VBA To Run This Properly

Sep 3, 2009

heres the Coding.

' Justin SQL Server Connection
'
' FOR THIS CODE TO WORK
' In VBE you need to go Tools References and check Microsoft Active X Data Objects 2.x library
'

In the Server_name = "SRVREG1" in red above, i would like it to reference a cell...say A30. How is this done?? so that if im on the worksheet called Title on A30 i type in SRVREG1 and the VBA knows what to do from there.

## Excel Page Setup Up

Jun 16, 2009

This might seem a strange type of Excel question.

Some "Clever" person decided to create a site plan using MS Excel. It has been done quite well tbh. The problem with Excel is that I am unable to set a custom page size as this plan sits nicely on a paper size I made ealier through using Word. Guess what there is a custom page size selection on Word but not Excel. Is there a walkaround for this ?

The only other way I can do this, is to print off 2 a4 landcape print out but the printer goes to the next page and leaves a nasty seperation.

The copy of Excel i have is 2003 sp3

## How To Setup Sheet Protection

Nov 27, 2012

When I protect the entire sheet, I can click in a cell and see what's in it, when I protect just a portion of the sheet, I can only click in the unprotected cells. Is this an Excel thing, or am I doing something wrong when protecting? I would like to see what the formula is in the cell when protected, but I can't click on the cell, what's the deal?

## Correlation Tables -- Setup

Oct 17, 2005

I'm trying to Pearson Ranks correlation table. This is the formula I'm
using:

=PEARSON(Ranks!\$B\$3:\$B\$230,Ranks!B\$3:B\$230)

This is placed in cell B3. When I copy the formula over to DT3 the formula
correctly adjusts the B in the second part of the formula all the way to DT
and still references the values in the B column.

But I want to now copy this down to C4, D5, E6 and then over to DT for each
so that it correctly makes the correlation table.

## Page Setup Changes On Different Machines

Jun 16, 2008

I set up a spreadsheet for use by my colleagues, on an Acer 17 inch portable. My colleagues all use HP or Dell with 15 inch monitors (and different graphics cards to mine). They all complained that when they opened my sheet, the page breaks were all in the wrong place. When they fixed the breaks on their machines and I opened those file, the breaks were now in the wrong place on mine, but were all right on theirs.

I have now "upgraded" to a Toshiba 17 inch laptop, and find that my original spreadsheet done on the Acer 17 inch shows page breaks in the wrong place on my new machine.

Is this something to do with display adaptors? If so, does anyone know what I can do to standardise this across the board? (My boss uses a 20 inch screen, and the sheet for him is even more wildly out).

## Speeding Up Page Setup

Jun 23, 2008

This part of my macro can be improved as it runs through over 100 sheets and takes a while?

Sheets.Select
For Each sh In Worksheets
With sh.PageSetup
.Zoom = False
.LeftFooter = "&F" & Chr(10) & "&A"
.CenterFooter = "&P of &N"
.RightFooter = "&D"
.FitToPagesWide = 1
.FitToPagesTall = 1
.LeftMargin = Application.InchesToPoints(0.15748031496063)
.RightMargin = Application.InchesToPoints(0.15748031496063)
.TopMargin = Application.InchesToPoints(0.393700787401575)
.BottomMargin = Application.InchesToPoints(0.354330708661417)
.FooterMargin = Application.InchesToPoints(0.196850393700787)
.TopMargin = 1
.BottomMargin = 1
.Orientation = xlPortrait
End With
Next sh

## Using XLM4 Page Setup

Jan 8, 2009

I visited all of the sites listed in the various posts & downloaded the XLM function help file.

My question is which syntax would I use? I'm wanting to add this to an existing macro (one that currently takes FOREVER). I think syntax 1 for worksheets & macro sheets, but I'm adding to visual basic, so maybe syntax 3 for vb modules?

Here's my existing code, if anyone wants to help me change this to XLM4pageSetUp ..

## Setup Calender Object In VBA

Sep 7, 2006

how to setup calender object in VBA application

## Protection For Page Setup

Jun 13, 2007

Is it possible to protect against users changing the page setup?

## Sum With Offset Not Working Properly?

May 30, 2013

Total amount in Column B should same as shown in Column F

=IF(E3<>"",SUM(OFFSET(\$C3,ISTEXT(E3),,,1):C3),"")Above formula is calculating always two rows.

## Vlookup Not Working Properly

Apr 10, 2009

I have problem with vlookup. I am attaching my file.

## Date Does Not Display Properly?

May 6, 2013

I have formatted cells to date but when I enter in a date of 020413 (Feb 04, 2013) my reslut shows as 11/20/55. I have a coworker who is having the same problem (but hers displays even a different date) so was wondering if there is a setting in excel that I don't know about.

## Sorting A-Z Not Working Properly

Sep 3, 2013

I am including an attached file for reference.

The file is sorted A-Z, but if you scroll down towards the bottom, you will see that some values are out of order. Both instances of University of Central Florida and University of North Dakota are out of place.

University of Central Florida should be between University of California and University of Colorado.

University of North Dakota should be between University of Colorado and University of Southern Mississippi.

## Macro Name Not Displaying Properly?

Jan 27, 2014

I have created a macro 'uid' and rename the module to 'profession'. In the list of macro 'alt + f8' the name displays 'profession.uid' which confuse me. I want to display the name 'uid' and not 'profession.uid'. I select the macro by pressing the first letter of it as in this case 'u' and reach that macro and click it to run.