Anyone Want to Build a Simple Spreadsheet for a Newbie?!

[Kelly Jean]

Hello all! I am a newcomer to this thread and Excel. I am in need of a spreadsheet for work with multiple, separate tables. I also need the spreadsheet to automatically calculate numbers and daily variances. I need it to look exactly the same on the screen as it does when it prints out, so that the employee's can simply enter their numbers, and Excel automatically places the totals and variances in the correct places.
I can create a sheet within Word to look exactly as I need it, but for obvious reasons, we cannot use Word for this type of formatting.
Is there anyone out there who could guide me, in laymen terms on how to do this? Alternatively, if there is someone who maybe feels like creating a spreadsheet for me, that'd be fantastic!
I apologize in advance; I really am not a complete idiot, I just have a hard time with Excel. We are simple farm workers, and do not regularly use computer programs. However, the use of this specific spreadsheet would help make our jobs (and lives) so much easier!
Thank you everyone!

***I have also posted this thread on another website, for help. I have used this additional post as a link, so that others can view the attached document. Thank you!***

[6StringJazzer]

Here is a start but this leads to a lot of questions about what all of this stuff means. Like, there are two references to "Yest". What do "nest" and "floor" indicate in a given House? For Variance are you looking for the actual statistical variance? If so, for what set of data? Each house for all hourly data for that house? Each house for all data for all houses?

Sorry, I am not a complete idiot, just a simple city boy who knows nothing about farms

[Kelly Jean]

Dear "Simple City Boy",

I greatly appreciate your response! I apologize if my document is vague. This is actually a count of the eggs produced on the farm. "Nest" will equal out to how many eggs were gathered from the nests and "Floor" will equal out to how many eggs were gathered from the floor.

The "Yest" (yesterday's totals) will be entered manually by the employees before Today's totals, and the chart should automatically show the variance between today's Total and Yest. For example, in House 1, across the board Nest will equal out to "Total Eggs"; depending on what the employee entered as Yest. total, the variance will show the difference.
Then downward from the time (which will also be manual input, as the time-frames vary) the "Total" will be the amount of eggs from today, the "Cumulative Total" (***. Tot.) will be of that house plus today's total from the next (Ex. 8Am totals for all houses Nest and Floor = 1256 - 7Am totals for all houses Nest and Floor = 1423, the Cumulative Totals under 8AM will = 2679). Yesterday's total will be input manually and the spreadsheet will automatically adjust the Variance.
"Total Eggs" for House 1 (Nest / Floor) will equal all egg totals for the day (gathered each hour) "Yest. Total" will be manually input as the total daily inventory from yesterday, "Variance" will automatically adjust between the two totals. "House Total" for House 1 (Nest AND Floor) will equal all egg totals for the day, "Yest. House Total" will be manually input as the total daily inventory from yesterday, and "Variance" will automatically adjust between the two totals....please let me know if this makes any sense, lol. Thank you much!

[Kelly Jean]

I know it seems confusing...and trust me, give a new farm hand one of my Word spreadsheets and a calculator and it's Armageddon! Lol. So, if I could equip them with a laptop and a spreadsheet that will keep them from having to use a calculator and lots of white-out (or, *gulp* turning in incorrect numbers to Headquarters), it'd make everyone so much happier!

[JeteMc]

Another "City Boy" here, although I have gathered eggs. Working off 6StringJazzer's .xlsx file I added the following formulas:
To get the cumulative totals the following formula can be pasted in B24 and dragged it across to O24: =SUM($B22:B22)
To get the variance between the number of eggs gathered yesterday and today (by time frame) the following formula can be pasted in B28 and dragged it across to O28: =B26-B22
NOTE: If the variance is supposed to be between the cumulative from yesterday and today the formula would need to be modified to read =B26-B24
For the variance per nest/floor the following formula can be pasted in R5 and dragged down to R19: =IF(ISNUMBER(P5),Q5-P5,"")
For the House Total the following formula can be pasted in S5 and dragged down to S17: =IF(MOD(ROW(),4)=1,SUM(P5:P7),"")
For the Variance per house the following formula can be pasted in U5 and dragged down to U17: =IF(ISNUMBER(S5),T5-S5,"")
Let me know if you have any questions.