beave Posted September 30, 2011 Share Posted September 30, 2011 Can you take a number that's been generated by a formula and use it elsewhere? Or does it have to be a 'clean' cell (no formulas) I want to take the number that's been generated and apply it to another formula to give me the percentage. Possible? Quote Link to comment
beave Posted September 30, 2011 Author Share Posted September 30, 2011 Also, when I'm in the spreadsheet all cells with formulas work, but when I leave they turn into #####... Whats going on with that? Quote Link to comment
Jonathan Pickup Posted September 30, 2011 Share Posted September 30, 2011 the column needs to be wider 1 Quote Link to comment
taoist Posted September 30, 2011 Share Posted September 30, 2011 Jonathan's comment is what is typical in an Excel spreadsheet. As far as using a value of one cell and referencing it to another I do not know. Great question though. I hope others who know more than us will chime in. I have not had to use the spreadsheets (functions) that much but it would be great to know. taoist Quote Link to comment
Bryan G. Posted September 30, 2011 Share Posted September 30, 2011 Yes you can reference other cells and info from other worksheets. Just ref the name of the worksheet where the data is residing. Quote Link to comment
Pat Stanford Posted September 30, 2011 Share Posted September 30, 2011 To reference a cell it is mostly like Excel. =A1*B1 will take the value from cell A1 and multiply it times the value in B1. If A1 and/or B1 contain formulas, the results of those formulas will be used. Be careful of what you put in the cells though. If you accidentally get a cell containing text rather than a value then you will not get a correct value as the result. Quote Link to comment
beave Posted September 30, 2011 Author Share Posted September 30, 2011 Thanks for your help everyone. Quote Link to comment
ashot Posted June 14, 2013 Share Posted June 14, 2013 (edited) "Yes you can reference other cells and info from other worksheets. Just ref the name of the worksheet where the data is residing." Can you please tell me how to reference cell from other worksheet. E.g. (Worksheet 2 cell A1) needs to refer to (Worksheet 1 cell B2) What is a syntax for cell A1 ? I tried this, but it doesn't work ='Worksheet 1'.B2 Edited June 14, 2013 by Ash Quote Link to comment
Ozzie Posted June 14, 2013 Share Posted June 14, 2013 If your Worksheet is named Worksheet1 I think =Worksheet1:A1 Quote Link to comment
James Russell Posted June 17, 2013 Share Posted June 17, 2013 You were so close Ash! ='Worksheet 1':B2 The apostrophe is only required if the worksheet title has a space in it otherwise whole words are fine, eg. =Worksheet1:B2 or =Worksheet-1:B2 Keep asking these questions, it's useful for everyone Cheers, J Quote Link to comment
ashot Posted June 17, 2013 Share Posted June 17, 2013 Can anyone look in .PNG attachment and tell if database subrows numbering can be replicated in the first column of any database. We use spreadsheets all the time and first column numbering is important for us. However, when spreadsheet includes database subrows, I can't find the solution for making similar numbering. Quote Link to comment
James Russell Posted June 17, 2013 Share Posted June 17, 2013 Ash, I've been playing with this issue for a while now and my answer so far is no. Without a record to reference, an entity counted by a database cannot create a numerical sequence purely within the database sub-rows. I'm hoping that someone is going to but in and have a clever way of =(CurrentSubRowNumber-CurrentRowNumber)*10 but I haven't found such an answer yet. I'll be interested to see though! J Quote Link to comment
michaelk Posted June 17, 2013 Share Posted June 17, 2013 I've been using a workaround for a similar situation when organizing the order of symbols in a key. 1. Add a field to the record format for the title block. In this example the new field is called Ordnung. 2. Create a blank worksheet with more rows than you need. I used 20 in this example. In A1 enter the number 1 In A2 enter =A1+1 Select Cell A2. Copy Select A3 through A20. Paste. 3. Select A1 through A14. Copy Go over to your sheet index worksheet. Select A3.1 through A3.14. Paste. Repeat as necessary. example attached. hth mk Quote Link to comment
ashot Posted June 19, 2013 Share Posted June 19, 2013 (edited) I used workaround similar to yours. In attached file you can see that in Title Block Record called 'MyCustBlkRecord 36x24' I am using special field 'S_Sheet No _ of' to catch the sheet number. (Go to Design Layer "Miscel" to see the main spreadsheet output. Open worksheet "SHEET INDEX", and make Database Headers shown) My "Sheet Index" worksheet is a good place to change any field info, since it works like a two-way table. Need to apply "update" for all title blocks and spreadsheets to refresh and bring them to the new state. I think this same procedure can be done with any symbol if you can create new record field "SerialNumber" for example. All is good, but not really a full automatic process. I was hoping to find some Script to catch for example "Stack Order" of Sheet Layers. If you think about it, the subrows of database must rely on stack order or creation order of all graphic elements (Sheet Layers, Door/Windows, any Symbol etc). Obviously this static information copied/pulled into the first column of spreadsheet may not be as dynamic as two-way table, but nevertheless it is something I would like to try. See attached file. By the way, one spreadsheet in viewport is on sheet layer "AS-GP1" and second spreadsheet, also in viewport is on sheet layer "S-GN1" Edited June 19, 2013 by Ash Quote Link to comment
ashot Posted June 20, 2013 Share Posted June 20, 2013 Here some Doors/Windows schedules with first column numbering. See attached VW file Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.