Home
Downloads
Mach3
Plugins
CAM Post Processors
Screensets
Purchase
Support
Forum
Tutorial Videos
Documentation
Yahoo Group
Mach Wiki
Resources
Contact Us
Links
CNCZone
German Forum
Italian Forum
Korean Forum
Portugese (Brazil) Forum
Russian Forum (RSK CNCROUTER)
Thai Forum
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
May 28, 2012, 01:59:11 AM
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Search:
Advanced search
Select from and to languages
Chinese-simp to English
Chinese-trad to English
English to Chinese-simp
English to Chinese-trad
English to Dutch
English to French
English to German
English to Greek
English to Italian
English to Japanese
English to Korean
English to Portuguese
English to Russian
English to Spanish
Dutch to English
Dutch to French
French to English
French to German
French to Greek
French to Italian
French to Portuguese
French to Dutch
French to Spanish
German to English
German to French
Greek to English
Greek to French
Italian to English
Italian to French
Japanese to English
Korean to English
Portuguese to English
Portuguese to French
Russian to English
Spanish to English
Spanish to French
Machsupport Forum
Mach Discussion
General Mach Discussion
gCODE /eXCEL SPREADSHEET QUESTION
Pages:
1
Go Down
« previous
next »
Author
Topic: gCODE /eXCEL SPREADSHEET QUESTION (Read 334 times)
0 Members and 2 Guests are viewing this topic.
BR549
Active Member
Offline
Posts: 2,557
gCODE /eXCEL SPREADSHEET QUESTION
«
on:
July 19, 2011, 08:07:23 PM »
I have an Excel spreadsheet I am working with and I need to work with 262 cells. I need to start at O and at each cell increase the value by .004267176 up to total number of cells.
DOES ANYONE have a clue as to how to use a formula to do this?
(;-) TP
Logged
Chaoticone
South Carolina, US
Administrator
Offline
Posts: 3,598
Precision Chaos
Re: gCODE /eXCEL SPREADSHEET QUESTION
«
Reply #1 on:
July 19, 2011, 09:32:37 PM »
Terry, will fill series help?
Brett
Logged
If you could see the things I have in my head, you would be laughing too.
www.precisionchaos1.com
My guard dog is not what you need to worry about!
Picengraver
Active Member
Offline
Posts: 82
Re: gCODE /eXCEL SPREADSHEET QUESTION
«
Reply #2 on:
July 20, 2011, 04:47:14 AM »
Enter 0 in cell A1
Enter =+A1+.004267176 in cell A2
click once on cell A2 to highlight it
Scroll down to cell A261 (262 cells)
hold down SHIFT - click cell A261
hold down CONTROL key - hit D
cell A261 should now read 1.10946576
Hope this is what you need.
John Champlain
Logged
www.picengrave.com
Ya-Nvr-No
Active Member
Offline
Posts: 268
Scuptris 3D
Re: gCODE /eXCEL SPREADSHEET QUESTION
«
Reply #3 on:
July 20, 2011, 05:19:37 AM »
Here is a something that might work for you.
Lets you change either or both numbers to fill your table.
br549-excel.xls
(26 KB - downloaded 20 times.)
«
Last Edit: July 20, 2011, 05:30:23 AM by Ya-Nvr-No
»
Logged
Ya-Nvr-No
Active Member
Offline
Posts: 268
Scuptris 3D
Re: gCODE /eXCEL SPREADSHEET QUESTION
«
Reply #4 on:
July 20, 2011, 07:16:18 AM »
Or you can do it using VBA in excel
gives you even more control
But you have to have macros enabled to use this feature.
br549-excel-2.xls
(98.5 KB - downloaded 17 times.)
Logged
BR549
Active Member
Offline
Posts: 2,557
Re: gCODE /eXCEL SPREADSHEET QUESTION
«
Reply #5 on:
July 20, 2011, 01:04:03 PM »
AH fill series did the trick. Thanks GUYS
(;-) TP
Logged
Pages:
1
Go Up
« previous
next »
Jump to:
Please select a destination:
-----------------------------
Mach Discussion
-----------------------------
=> General Mach Discussion
=> Mach3 under Vista
=> Quantum
=> Mach SDK plugin questions and answers.
===> Finished Plugins for Download
=> VB and the development of wizards
=> Brains Development
=> Video P*r*o*b*i*n*g
=> Mach Screens
===> Screen designer tips and tutorials
===> Works in progress
===> Finished Screens
===> Flash Screens
===> JetCam screen designer
===> Machscreen Screen Designer
===> CVI MachStdMill (MSM)
=> Feature Requests
=> Non English Forums
===> Italian
===> French
===> Spanish
===> Chinese
===> German
===> Russian
===> Romanian
===> Japanese
===> Vietnamese
=> FAQs
-----------------------------
*****VIDEOS*****
-----------------------------
=> *****VIDEOS*****
-----------------------------
General CNC Chat
-----------------------------
=> Share Your GCode
=> Show"N"Tell ( What you have made with your CNC machine.)
=> Building or Buying a Wood routing table.. Beginnners guide..
=> Show"N"Tell ( Your Machines)
-----------------------------
G-Code, CAD, and CAM
-----------------------------
=> G-Code, CAD, and CAM discussions
=> LazyCam (Beta)
-----------------------------
Third party software and hardware support forums.
-----------------------------
=> LazyTurn
=> GearoticMotion Preliminary testing
=> Tempest Trajectory Planner
=> Contec
=> dspMC/IP Motion Controller
=> HiCON Motion Controller
=> Third party software and hardware support forums.
=> Galil
=> Newfangled Solutions Wizards
=> Mach3 and G-Rex
=> Mesa
=> Modbus
=> NC Pod
=> PoKeys
=> SmoothStepper USB
=> Sieg Machines
=> Promote and discuss your product
-----------------------------
Tangent Corner
-----------------------------
=> Tangent Corner
=> Competitions
=> Polls
=> Bargain Basement
-----------------------------
Support
-----------------------------
=> Downloads
===> XML files
===> Post Processors
===> Macros
===> Tutorials
===> Others
===> Beta Brains
===> Screen Sets
===> Documents
===> MACH TOOL BOX
=> One on one phone support.
=> Forum suggestions and report forum problems.
-----------------------------
Mach4
-----------------------------
=> Mach4 pre-Alpha Testing
Loading...