+ Reply to Thread
Results 1 to 2 of 2

Excel Spreadsheet Structure/Layout

  1. #1
    Registered User
    Join Date
    01-01-2020
    Location
    Auckland, New Zealand
    MS-Off Ver
    2016
    Posts
    1

    Excel Spreadsheet Structure/Layout

    Hi,
    I am in need of some assistance to develop a spreadsheet which will allow me to query, hours worked, Overtime Worked, Total Time Worked for around 100 employees. The spreadsheet needs to show the dept in which the employee's work and the Week Number. For example:
    Dept 321, Week Number, Employee SurName, FirstName, Normal Hours, Overtime Hours, Total Hours.
    I don't know how to Structure the spreadsheet so I can query trends in hours etc.. Can You Help Me Please???
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

    Re: Excel Spreadsheet Structure/Layout

    Hello & Welcome to the Forum,

    The best way to build your layout for easy analysis is in a flat file type of structure.

    https://www.dummies.com/software/mic...l-data-models/

    this second like goes a little but deeper, but might help you understand how to setup a clean and organized data structure that will aide in analysis.

    http://www.tushar-mehta.com/excel/ne...cel/index.html
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Spreadsheet structure and formula
    By Playgolf in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-19-2015, 04:29 AM
  2. Excel Spreadsheet for Bonus Structure Based on Sales
    By brookie1988 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-12-2013, 07:51 AM
  3. "convert" data with logfile structure to spreadsheet structure
    By boarders paradise in forum Excel General
    Replies: 7
    Last Post: 01-10-2011, 02:06 AM
  4. Replies: 2
    Last Post: 12-20-2009, 07:43 PM
  5. Help with spreadsheet structure
    By iRounak in forum Excel General
    Replies: 10
    Last Post: 11-25-2009, 05:43 AM
  6. [SOLVED] Spreadsheet Layout
    By Gregor in forum Excel General
    Replies: 3
    Last Post: 07-10-2006, 03:29 AM
  7. [SOLVED] Layout of spreadsheet
    By snidely in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-17-2005, 05:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1