+ Reply to Thread
Results 1 to 2 of 2

simplified layout for job costings

  1. #1
    Registered User
    Join Date
    02-17-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    35

    simplified layout for job costings

    Hi.

    I am trying to devise a spreadsheet that shows four variables:

    Employee
    Employee Hours
    weekending date
    Project Name

    The spreadsheet attached is what I have come up with; however it seems quite cumbersome as the employees will be working on different jobs throughout the week.

    Ideally a pivot table would work, however, I need to load this spreadsheet into Google Drive for the boss to look through. The boss is not great on Excel, not too sure if he would work on pivot table, plus unsure if pivot table works in Drive. Originally, I had one sheet per job but we have 20 jobs on the go, so it is not realistic. I need the information consolidated into one spreadsheet. I am drawing a blank on a different way of approaching this.

    Thanks for any advice/thoughts.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,937

    Re: simplified layout for job costings

    The article linked below indicates that Google sheets does have pivot tables.
    https://support.google.com/docs/answ...DDesktop&hl=en
    I have very little experience with Google sheets, however assuming that the pivot tables a similar it will be easier to set up the pivot table if the source data is arranged row over row, meaning that each row will contain a date, employee name, job name, job number, hours, actual and charged. Some of the values like actual, charged and perhaps job number could be placed in other tables and inserted to the source data using VLOOKUP or INDEX/MATCH.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Multiple Criteria on Job Costings issue
    By Vibro in forum Excel General
    Replies: 4
    Last Post: 06-05-2018, 01:37 AM
  2. [SOLVED] Formula for multiple costings
    By dharvey078 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2017, 01:47 AM
  3. Formula to work out costings - PLS HELP
    By m_789 in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 02-18-2014, 11:17 AM
  4. Menu costings sheet with access?
    By garyi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2013, 05:51 AM
  5. Converitng Numbers into times for costings issue
    By Scott Pattison in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2008, 05:06 PM

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