
Book2.xls [https://filedb.experts-exchange.com/incoming/2012/02_w07/550347/Book2.xls]

Book2.xls

<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
can you recommend any better ways of constructing the attached excel.<br />
<br />
the task is - a number will &nbsp;be entered for each employee in terms of a specific amount of duty that is done per day, then it is all added up as a report for the manager. if you look in sheet1, that is how it is done now. sheet2 is the desired way to do it. but i am seeking your input on how to make this better in terms of ease of use and purpose met. also how and what is best way to extend this template seamlessly for each week of the year. <br />
<br />
thx much!
</div>
</div>


hi,

can you recommend any better ways of constructing the attached excel.

the task is - a number will  be entered for each employee in terms of a specific amount of duty that is done per day, then it is all added up as a report for the manager. if you look in sheet1, that is how it is done now. sheet2 is the desired way to do it. but i am seeking your input on how to make this better in terms of ease of use and purpose met. also how and what is best way to extend this template seamlessly for each week of the year. 

thx much!

spice up excel calculations

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.