Home

How to add additional calculating sections to a current spread sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-841531%22%20slang%3D%22en-US%22%3EHow%20to%20add%20additional%20calculating%20sections%20to%20a%20current%20spread%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-841531%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EI%20need%20help%20with%20a%20current%20spreadsheet%20we%20are%20using.%20I%20am%20looking%20for%20an%20easier%20way%20to%20enter%20additional%20employee%20lines%20(sections)%20into%20a%20multi-calculating%20Excel%20spread%20sheet.%20E%3CSPAN%3E%3CSPAN%3E%3CSPAN%3Each%20employee%20section%20is%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%3E24%20lines%2F37%20columns%20-%20%3CSPAN%3E%3CSPAN%3Erefer%20to%201st%20uploaded%20picture%20of%20one%20employee%20section).%26nbsp%3BThere%20are%20currently%20about%2025%20employee%20sections%20in%20this%20spread%20sheet.%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EI%20enter%20each%20employee%E2%80%99s%20hours%2C%20each%20day%20by%20job%2C%20for%20a%20two-week%20period.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EThe%20sheet%20totals%20the%20hours%20I%20enter%20for%20each%20employee%20by%20job--by%20week%20and%20then%20calculates%20a%202-week%20total.%20The%20lines%20are%20also%20totaled%20to%20the%20right%20by%20job%20type.%26nbsp%3B%20%3C%2FSPAN%3EThere%20are%2028%20job%20columns.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EAt%20the%20bottom%20of%20the%20spread%20sheet%20there%20is%20a%20line%20where%20the%20two%20week%20total%20hours%20for%20all%20employees%2C%20for%20each%20job%2C%20%3CSPAN%3E%3CSPAN%3Eis%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3Edisplayed.%20Those%20hours%20are%20then%20subtracted%20from%20the%20scheduled%20hour%20totals%20for%20each%20job%2F2-week%20period.%20Any%20difference%20appears%20on%20a%20third%20line.%20Picture%202.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EBelow%20that%2C%20is%20a%20chart%20where%20the%20spread%20sheet%20totals%20and%20displays%20the%20hours%20for%20each%20job%2C%20by%20day.%20It%20also%20totals%20the%20daily%20hours%20for%20each%20job%20for%20each%20week%2C%20and%20then%20the%20two%20week%20totals%20combine.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3ELast%20year%2C%20I%20had%20to%20enter%20new%20employee%20sections%20into%20this%20spread%20sheet.%20I%20did%20it%20by%20cutting%20and%20pasting%20and%20dragging%2C%20and%20then%20spent%20a%20good%20bit%20of%20time%20making%20sure%20all%20the%20calculations%20were%20adding%20correctly.%20It%20was%20a%20bit%20of%20a%20trial%20and%20error%20process%2C%20that%20I%20finally%20got%20to%20work%2C%20but%20it%20was%20FAR%20from%20ideal.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3ERecently%2C%20I%20have%20been%20trying%20different%20ways%20to%20cut%20and%20paste%20and%20insert.%20I%20can%20get%20the%20section%20to%20total%20correctly%2C%20but%20the%20numbers%20are%20not%20getting%20picked%20up%20to%20calculate%20into%20the%20sections%20below--the%20combined%20employee%20totals.%20I%20am%20hoping%20there%20is%20an%20easy%20way%20to%20do%20this.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EHelp%20please%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EFeel%20free%20to%20direct%20me%20to%20appropriate%20tutorials%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EI%20searched%20for%20anything%20I%20could%20find%20to%20help%20me%2C%20but%20it%20may%20be%20that%20I%20didn%E2%80%99t%20know%20how%20to%20correctly%20describe%20in%20a%20tag%20line%2C%20what%20I%20am%20trying%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%3E%3CSPAN%3Eto%20do.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EThank%20you%20for%20any%20help%20you%20can%20offer.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3ECate%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130506i774DDECE421452BB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ENTER%20EMPLOYEES%20INDIV%20HOURS).png%22%20title%3D%22ENTER%20EMPLOYEES%20INDIV%20HOURS).png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EENTER%20EMPLOYEE%20HRS%20BY%20JOB%2FDAY%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130507i3B92222346E9DBCF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22TOTALS%20ALL%20HOURS%20BY%20JOB%20%26amp%3B%20COMPARES%20TO%20SCHEDULED%20HRS.png%22%20title%3D%22TOTALS%20ALL%20HOURS%20BY%20JOB%20%26amp%3B%20COMPARES%20TO%20SCHEDULED%20HRS.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESHEET%20TOTALS%20HOURS%20WORKED%20BY%20JOB%20%26amp%3B%20COMPARES%20TO%20SCHEDULED%20HRS%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130508i06BF2F28C465D68D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SORTS%20HOURS%20BY%20JOB%20BY%20DAY%2C%20WEEK%2C%202%20WK%20TOTAL.png%22%20title%3D%22SORTS%20HOURS%20BY%20JOB%20BY%20DAY%2C%20WEEK%2C%202%20WK%20TOTAL.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESHEET%20POPULATES%20THIS%20TABLE%20WITH%20TOTALS%20BY%20JOB%20BY%20DAY%2C%20BY%20WEEK%2C%202%20WK%20TOTAL%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-841531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
CATE11
Occasional Visitor

Hello.

I need help with a current spreadsheet we are using. I am looking for an easier way to enter additional employee lines (sections) into a multi-calculating Excel spread sheet. Each employee section is 24 lines/37 columns - refer to 1st uploaded picture of one employee section). There are currently about 25 employee sections in this spread sheet. 

 

I enter each employee’s hours, each day by job, for a two-week period.

 

The sheet totals the hours I enter for each employee by job--by week and then calculates a 2-week total. The lines are also totaled to the right by job type.  There are 28 job columns.  

 

At the bottom of the spread sheet there is a line where the two week total hours for all employees, for each job, is displayed. Those hours are then subtracted from the scheduled hour totals for each job/2-week period. Any difference appears on a third line. Picture 2.

 

Below that, is a chart where the spread sheet totals and displays the hours for each job, by day. It also totals the daily hours for each job for each week, and then the two week totals combine.

 

Last year, I had to enter new employee sections into this spread sheet. I did it by cutting and pasting and dragging, and then spent a good bit of time making sure all the calculations were adding correctly. It was a bit of a trial and error process, that I finally got to work, but it was FAR from ideal.

Recently, I have been trying different ways to cut and paste and insert. I can get the section to total correctly, but the numbers are not getting picked up to calculate into the sections below--the combined employee totals. I am hoping there is an easy way to do this.

Help please?

 

Feel free to direct me to appropriate tutorials

I searched for anything I could find to help me, but it may be that I didn’t know how to correctly describe in a tag line, what I am trying to do.

Thank you for any help you can offer.

Cate

 

 

ENTER EMPLOYEES INDIV HOURS).pngENTER EMPLOYEE HRS BY JOB/DAYTOTALS ALL HOURS BY JOB & COMPARES TO SCHEDULED HRS.pngSHEET TOTALS HOURS WORKED BY JOB & COMPARES TO SCHEDULED HRSSORTS HOURS BY JOB BY DAY, WEEK, 2 WK TOTAL.pngSHEET POPULATES THIS TABLE WITH TOTALS BY JOB BY DAY, BY WEEK, 2 WK TOTAL.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies