Sponsored Content
Full Discussion: Excel
Special Forums Windows & DOS: Issues & Discussions Excel Post 302534784 by Maggiepie on Tuesday 28th of June 2011 07:12:10 PM
Old 06-28-2011
Excel Help!!

Ok I have created a sample spreadsheet for your review. What I need for this spreadsheet to do is that everytime I highligt one of the section for one of the members in green as complete that section updates the last tab with the appropriate point value for example 1.0 or 2.5 etc. If highlighted in red in represnets not completed hence 0. The total should add up to 100%.

Additionally, I would like to create graphs to show each unit per tab their progress. Please let me know if this is possible.

I do thank you in advance.

Moderator's Comments:
Mod Comment Neo: Removed Attachment Per User Request

Last edited by Neo; 06-29-2011 at 07:27 AM.. Reason: removed
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

excel

i am currently using a unix environment and will be constantly receiving documents in excel format(.xls) my question is is there any tools that will do auto convertion of data in the excel doc into .txt? ps.. my job are mainly for batch processing. thus it would be great if no manual work is... (2 Replies)
Discussion started by: swakoo
2 Replies

2. UNIX for Dummies Questions & Answers

Excel help

Folks; I'm writing a shell script to extract some field out of log file to a text file which i can convert/open in Excel sheet. I gave names to the fields like (Editor_name, Owner, etc..) to be in the top of the Excel sheet. When i open the file using Excel sheet i see these filed names fine on... (2 Replies)
Discussion started by: moe2266
2 Replies

3. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies

4. Windows & DOS: Issues & Discussions

Excel manipulation

I have a .csv file, when i open it in excel sheet the content is getting displayed in scientific notation (E+e.) , now inorder to remove tht i have appended ' (single quote) infront of the number. This is working fine. But when i open in excel the ' single quote is appearing before the number. My... (1 Reply)
Discussion started by: dvrraju
1 Replies

5. Shell Programming and Scripting

Excel

I have file called abc.txt at /usr/abc.. Content of file is as below. mZ2|uM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2 oZ2|iM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2 pZ2|qM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2... (3 Replies)
Discussion started by: j_panky
3 Replies

6. UNIX for Dummies Questions & Answers

Help for Excel

Hello everybody. I am new here and hoping someone is willing to help. I just want to know if anyone can tell me how it would be possible to combine two separate rows in excel while adding certain pieces of information and keeping others the same. Here is what I mean. I want to combine the same... (1 Reply)
Discussion started by: blubiz2
1 Replies

7. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed. What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies

8. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

9. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

10. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
Excel::Template::Container::Loop(3pm)			User Contributed Perl Documentation		     Excel::Template::Container::Loop(3pm)

NAME
Excel::Template::Container::Loop - Excel::Template::Container::Loop PURPOSE
To provide looping NODE NAME
LOOP INHERITANCE
Excel::Template::Container ATTRIBUTES
o NAME This is the name of the loop. It's used to identify within the parameter set what variables to expose to the children nodes each iteration. CHILDREN
None EFFECTS
None DEPENDENCIES
None USAGE
<loop name="LOOPY"> ... Children here ... </loop> In the above example, the children nodes would have access to the LOOPY array of hashes as parameters. Each iteration through the array would expose a different hash of parameters to the children. These loops work just like HTML::Template's loops. (I promise I'll give more info here!) There is one difference - I prefer using Perl-like scoping, so accessing of variables outside the LOOP scope from within is perfectly acceptable. You can also hide outside variables with inner values, if you desire, just like Perl. AUTHOR
Rob Kinyon (rob.kinyon@gmail.com) SEE ALSO
perl v5.14.2 2012-04-29 Excel::Template::Container::Loop(3pm)
All times are GMT -4. The time now is 02:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy