tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 680427d1591015642-transposing-of-table-and-output-column-names-data
Sheet: desired_result

 |  | Treatment.A.age1 | Treatment.A.age2 | Treatment.A.age3 | Treatment.B.age1 | Treatment.B.age2 | Treatment.B.age3
2005 |  | -0.532418604284094 | -0.58959073600488 | 0.2099558153439 | -0.495460469009352 | -0.754587208601683 | -0.0916575227918904
2006 |  | 0.206423628757292 | -0.0837431663282077 | -1.1303338275178 | 0.255557266263001 | -0.263465947015053 | -1.46456110472353
2007 |  | 0.390041429694331 | -0.198806854548055 | NA | 0.423321495098826 | -0.360342284130805 | NA
Spreadsheet: 342a0e65-e3d9-4f84-b014-a2fbf6def0a0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Colorado Department of Education | Unnamed: 4 | Unnamed: 5 | Page: 1 | Unnamed: 7
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Teacher Student Data Link | File Type: | Course Enrollment
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
BIRTH_DATE_STUDENT | TD008 | Error | Student's Date of Birth must be a valid date in MMDDYYYY format. | Active | 1
DISTRICT_CODE | TD001 | Error | District Code is required and must be a valid School District/BOCES Code. Refer to School District/BOCES Codes Table. | Active | 1
DISTRICT_CODE | TD013 | Error | District Code in the file must match the district code indicated as uploading the record in the system. | Active | 1
GENDER_STUDENT | [NAME] | Error | Student's Gender is required and must be a valid code. | Active | 1
LOCAL_COURSE_CODE | TD003 | Error | Local Course Code is required and must be a valid course code. | Active | 1
PASS_FAIL | TD015 | Error | Pass/Fail is required and must be a valid code.  Please zero-fill this field if the data is not available. | Active | 1
ROSTER_END_DATE | TD012 | Error | Roster End Date must contain a valid date if entered. | Active | 1
ROSTER_START_DATE | TD011 | Error | Roster Start Date must contain a valid date if entered. | Active | 1
ROSTER_START_DATE | TD022 | Error | Roster Start Date cannot be after Roster End Date. | Active | 1
SASID | 99999 | Error | The SASID is invalid or name, birth date, or gender doesnt match whats in the RITS system for the entered SASID | Active | 1
SASID | TD020 | Error | A matching record was not found in the Student Profile.  Please upload student data to the Student Profile Interchange. | Active | 1
SCHOOL_CODE | TD002 | Error | School Code is required and must be a valid Public School Code for the reporting district/BOCES. Refer to School Building Code Table. | Active | 1
STUDENT_CREDIT_EARNED | TD023 | Error | Student Credit Earned must not be zero if the student was indicated as passing the class | Active | 1
STUDENT_CREDIT_EARNED | [NAME] | Error | Student Credit Earned is required and must contain a valid credit value.  Enter 'NA' to indicate this data is not being submitted. | Active | 1
VERIFIED_STATUS | TD026 | Error | Verified is required and must be a valid code. | Active | 1
Spreadsheet: 161020d1339367481-need-formula-to-list-all-items-that-meet-prerequisite-forumexample
Sheet: Summary

I want these cells filled in from the 1st 2 sheets via formula…
[NAME]
Advertiser | Slogan | Col. | Inch | Total Inches | Color
To look like this…
[NAME]
Advertiser | Slogan | Col. | Inch | Total Inches | Color
ABC | test1 | 5 | 8 |  | RED
DEF | test2 | 6 | 9 |  | BLUE
MNO | test5 | 2 | 3 |  | RED
STU | [NAME] | 6 | 5 |  | YELLOW
VWX | test8 | 2 | 8 |  | BLUE
Spreadsheet: 73579d1274217695-staff-rota-date-and-day-calculation-rotadate2
Sheet: Dates

Month | Year
2 | 2010 | Change A2 & B2 to change dates from A5 onwards
Spreadsheet: 025a3251-ae6a-48a4-9bd6-fdd9a7f709b2
Sheet: a. Personnel

Detailed Budget Justification
a. Personnel
PLEASE READ!!!  List costs solely for employees of the entity completing this form (award prime recipient or sub-recipient with costs over $100,000).  All other personnel costs (for prime's subrecipients or other contractual efforts of the entity preparing this budget) must be included under f. Contractual.  This includes all consultants and FFRDCs.  Identify positions to be supported.  Key personnel should be identified by title.  All other personnel should be identified either by title or a group category.  State the amounts of time (e.g., hours or % of time) to be expended, the base pay rate (or composite base pay rate for group category), total direct personnel compensation, and identify the rate basis (e.g., actual salary, labor distribution report, technical estimate, state civil service rates, etc.).  Add rows as needed.  [NAME]/calculations will need to be entered by the preparer of this form.  Please enter formulas as shown in the example.   Include a brief narrative explanation of the costs in the "Additional Explanations/Comments" section to justify the costs.
Task # and Title | Position Title | Budget Period 1 |  |  | Budget Period 2 |  |  | Budget Period 3 |  |  | Project Total Hours | Project Total Dollars | Rate Basis
 |  | Time  (Hours) | Pay Rate ($/Hr) | Total Budget Period 1 | Time  (Hours) | Pay Rate ($/Hr) | Total Budget Period 2 | Time  (Hours) | Pay Rate ($/Hr) | Total Budget Period 3
1.  Generation 2A Receiver Design |  |  |  |  |  |  |  |  |  |  |  |  | Actual Salary
EXAMPLE | Sr. Engineer | 2000 | 85 |  | 200 | 50 |  | 200 | 50 |  |  |  | Actual Salary
ONLY!!! | Electrical engineers | 6200 | 35 |  | 400 | 35 |  | 600 | 35 |  |  |  | Actual Salary
 | Technician | 1800 | 20 |  | 0 | 0 |  | 0 | 0 |  |  |  | Actual Salary
1.   (Task 1 Title)
2.   (Task 2 Title)
3.   (Task 3 Title)
etc.
 | Total Personnel Costs
Additional Explanations/Comments (as necessary)
Spreadsheet: 80085d1280312994-search-and-delete-rows-if-it-meets-my-criteria-advanced-filter-or
Sheet: Sheet1

info1 | info2 |  | info1 | info2
blacktalldog.com | black tall dog |  | black*
blackhungrymouse.com | black hungry mouse |  | big*
thebigshortdog.net | the big short dog |  |  | *pink*
bigblacktable.net | big black table
bigtalltree.net | big tall tree |  |  |  |  |  | notice column header for criteria must be the same as those you want to filter
smalltree.net | a pink thing
cars | yellow
elephants | pink
 |  |  |  |  |  |  | now if you advance filter and set criteria range as d1:d3
 |  |  |  |  |  |  | you get this result | ie filter col info1 and find begins with black OR  big
 |  |  |  |  |  |  | info1 | info2
 |  |  |  |  |  |  | blacktalldog.com | black tall dog
 |  |  |  |  |  |  | blackhungrymouse.com | black hungry mouse
 |  |  |  |  |  |  | bigblacktable.net | big black table
 |  |  |  |  |  |  | bigtalltree.net | big tall tree
 |  |  |  |  |  |  | if you set the criteria as d1:e4
 |  |  |  |  |  |  | you get this
 |  |  |  |  |  |  | I.e allow begins with black OR begins with big in column info1 OR contains pink in column info2
 |  |  |  |  |  |  | info1 | info2
 |  |  |  |  |  |  | blacktalldog.com | black tall dog
 |  |  |  |  |  |  | blackhungrymouse.com | black hungry mouse
 |  |  |  |  |  |  | bigblacktable.net | big black table
 |  |  |  |  |  |  | bigtalltree.net | big tall tree
 |  |  |  |  |  |  | smalltree.net | a pink thing
 |  |  |  |  |  |  | elephants | pink
Spreadsheet: 9e12236c-4e92-43b8-b8d9-52b91229f067
Sheet: LIT 433

COURSE ASSESSMENT MATRIX
Lit 433 [NAME]: Lit 203. In its emphasis on the ability to discern qualitative storytelling in literature and cinema, this survey concentrates on reinforcing students’ existing analytical literary skills. Students will critically assess the material while reading the stories coupled with an analytical viewing of the films based on original literary works. Finally, students will explore the adaptation process and will achieve a better understanding of it. 3 credits
Goals: The goal of this course is to teach students how to discern qualitative storytelling in literature and cinema.
Think critically. | Quizzes                                        Weekly Assignments                                                             Exams | 80 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Practice information retrieval. | Quizzes                                        Weekly Assignments                                                             Exams | 80 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Reinforce overall understanding of national literary identity in comparison and contrast with individual and collective [NAME] culture. | Quizzes                                        Weekly Assignments                                                             Exams | 80 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Reinforce overall understanding of literary terms and devices. | Quizzes                                        Weekly Assignments                                                             Exams | 80 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Date | Form of Assessment and Actions Taken
Spring 2011 | Syllabus Reviewed --Mainly looked to see that all sections on checklist were present.  Scheduled to review content during the Fall 2011 semester.
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Spreadsheet: 217289d1362036903-if-with-vlookup-if-with-vlookup
Sheet: Sheet2

IT IS ONLY EXAMPLE
 |  | PART NUMBER |  |  | SPECIAL PRICE | ORDINARY PRICE
APPLE | 1 | AP22797 | APPLE | 1 | 35 | 25 | IF(APPLE PART NO STARTS WITH"NL22*" IT SHOULD BE ORDINARY PRICE, ELSE IF( SPECIAL PRICE.)
ORANGE | 2 | AP22697 | ORANGE | 2 | 20 | 10
MANGO | 3 | AP31891 | MANGO | 3 | 60 | 30
BANANA | 4 | AP31970 | APPLE | 1 | 50 | 25
Spreadsheet: 46061d1244842185-recurring-meetings-687359-recurring-meeting
Sheet: Calender

 |  | 2009-08-01 00:00:00
2009-06-28 00:00:00 |  | 2009-06-29 00:00:00 |  | 2009-06-30 00:00:00 |  | 2009-07-01 00:00:00 |  | 2009-07-02 00:00:00 |  | 2009-07-03 00:00:00 |  | 2009-07-04 00:00:00
Spreadsheet: 835173d1688383087-linking-two-excel-tabs-using-common-columns-01-expensestravel-index-test
Sheet: temple details

temple | City or town | Place | arya gowda rd | agamam /pooja procedure | moolavar | urchavar | amman | [NAME] | tank | age in uyears | kodi marams | other deities |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Temple opening Timing | Address | Ph
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
abhirami | THIRUKKADAIYIUR | 0 | 0
Adimoolavaradperumal | chennai | vadapalani | vadapalani
[NAME] | chennai | T Nagar | 0
[NAME] , saneeswar | pozhichalur | 0 | 0
Anjaneyar | chennai | ashok nagar | 0
Spreadsheet: 865960d1712906467-returning-value-from-three-criteria-return-value-from-three-criteria
Sheet: Look up

 |  |  | Load duration
 | Material | Service class | Permanent (more than 10 years) | Long-term (6 monhts - 10 years) | Medium-term (1 week - 6 months) | Short-term (less than one week) | Instantaneous
 | Solid timber | 1 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 2 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 3 | 0.5 | 0.55 | 0.65 | 0.7 | 0.9
 | Glued laminated timber | 1 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 2 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 3 | 0.5 | 0.55 | 0.65 | 0.7 | 0.9
 | LVL | 1 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 2 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 3 | 0.5 | 0.55 | 0.65 | 0.7 | 0.9
 | Plywood | 1 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 2 | 0.6 | 0.7 | 0.8 | 0.9 | 1.1
 |  | 3 | 0.5 | 0.55 | 0.65 | 0.7 | 0.9
 | OSB | 1 | 0.3 | 0.45 | 0.65 | 0.85 | 1.1
 |  | 2 | 0.4 | 0.5 | 0.7 | 0.9 | 1.1
 |  | 3 | 0.3 | 0.4 | 0.55 | 0.7 | 0.9
 | Particleboard | 1 | 0.3 | 0.45 | 0.65 | 0.85 | 1.1
 |  | 2 | 0.2 | 0.3 | 0.45 | 0 | 0.8
 | Fibreboard, hard | 1 | 0.3 | 0.45 | 0.65 | 0.85 | 1.1
 |  | 2 | 0.2 | 0.3 | 0.45 | 0.6 | 0.8
 | Fibreboard, medium | 1 | 0.2 | 0.4 | 0.6 | 0.8 | 1.1
 |  | 2 | 0 | 0 | 0 | 0.45 | 0.8
 | Fibreboard MDF | 1 | 0.2 | 0.4 | 0.6 | 0.8 | 1.1
 |  | 2 | 0 | 0 | 0 | 0.45 | 0.8
Spreadsheet: 97965d1297079220-collating-mutiple-columns-data-book2
Sheet: Sheet1

CURRENT DATA |  |  |  |  | COLLATED DATA
Currency | Amount | Date | Rate |  | Currency | Amount | Date | Rate
USD | 200000 | 2011-01-03 00:00:00 | 0.5 |  | USD |  | 2011-01-03 00:00:00
USD | 100000 | 2011-01-03 00:00:00 | 0.5 |  | USD |  | 2011-01-04 00:00:00
USD | 50000 | 2011-01-04 00:00:00 | 0.6 |  | EUR |  | 2011-01-04 00:00:00
EUR | 75000 | 2011-01-04 00:00:00 | 0.3 |  | EUR |  | 2011-01-05 00:00:00
EUR | 100000 | 2011-01-05 00:00:00 | 0.4
USD | 100000 | 2011-01-03 00:00:00 | 0.5
Spreadsheet: 804675d1668206590-concatenate-two-words-with-spacing-in-between-adjustable-concatenation-bvj-
Sheet: Sheet1

 |  |  |  |  | 27
 | Input-1 | Input-2 |  | Output
 | Out of Network | 12345
 | In Network | ABCDEF
 | Out of Scope | Television
 | XYZ | 12
 | Scope | Laptop
Spreadsheet: 774297d1648374981-5-year-moving-average-that-restarts-at-every-new-category-5-year-moving-average-that-restarts-at-every-new-category
Sheet: Sheet1

Country | Year | Calorie intake | 5 year moving average |  | Year Count | [NAME] |  | Combined Formula
Afghanistan | 1961 | 2069.31 | #N/A
Afghanistan | 1962 | 2012.73 | #N/A
Afghanistan | 1963 | 1861.62 | #N/A
Afghanistan | 1964 | 2037.57 | #N/A
Afghanistan | 1965 | 2039.64 | 2004.174
Afghanistan | 1966 | 1888.53 | 1968.018
Afghanistan | 1967 | 2049.99 | 1975.47
Afghanistan | 1968 | 2013.42 | 2005.83
Afghanistan | 1969 | 2025.15 | 2003.346
Afghanistan | 1970 | 1748.46 | 1945.11
Afghanistan | 1971 | 1733.28 | 1914.06
Albania | 1963 | 1487.64 | #N/A
Albania | 1964 | 1566.3 | #N/A
Albania | 1965 | 1555.26 | #N/A
Albania | 1966 | 1555.26 | #N/A
Albania | 1967 | 1560.78 | 1545.048
Albania | 1968 | 1616.67 | 1570.854
Albania | 1969 | 1658.76 | 1589.346
Albania | 1970 | 1666.35 | 1611.564
Albania | 1971 | 1628.4 | 1626.192
Algeria | 1965 | 1097.79
Algeria | 1966 | 1083.99
Algeria | 1967 | 1136.43
Algeria | 1968 | 1177.14
Algeria | 1969 | 1176.45
Algeria | 1970 | 1155.75
Algeria | 1971 | 1186.8
Angola | 1961 | 1240.62
Angola | 1962 | 1255.11
Angola | 1963 | 1278.57
Angola | 1964 | 1284.78
Angola | 1965 | 1295.13
Angola | 1966 | 1304.1
Angola | 1967 | 1325.49
Angola | 1968 | 1280.64
Angola | 1969 | 1342.74
Angola | 1970 | 1355.85
[NAME] and [NAME] | 1961 | 1385.52
[NAME] and [NAME] | 1962 | 1507.65
[NAME] and [NAME] | 1963 | 1415.88
[NAME] and [NAME] | 1964 | 1466.94
[NAME] and [NAME] | 1965 | 1533.18
[NAME] and [NAME] | 1966 | 1498.68
[NAME] and [NAME] | 1967 | 1351.71
[NAME] and [NAME] | 1968 | 1384.83
[NAME] and [NAME] | 1969 | 1417.95
[NAME] and [NAME] | 1970 | 1545.6
[NAME] and [NAME] | 1971 | 1493.85
Spreadsheet: 684656d1593488904-drop-down-list-showing-current-month-and-year-and-formula-to-show-prev-year-drop-down-current-vs-prev-year
Sheet: Sheet1

Branch | Oct-19 | Nov-19 | Dec-19 | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20
BR1 | 7 | 6 | 10 | 7 | 8 | 6 | 3 | 2
BR2 | 3 | 2 | 3 | 2 | 2 | 2 | 4 | 2
BR3 | 14 | 10 | 11 | 7 | 9 | 7 | 5 | 3
BR4 | 12 | 11 | 16 | 10 | 13 | 10 | 7 | 8
Branch | Oct-18 | Nov-18 | Dec-18 | Jan-19 | Feb-19 | Mar-19 | Apr-19 | May-19
BR1 | 7 | 6 | 4 | 4 | 5 | 5 | 3 | 6
BR2 | 2 | 2 | 1 | 2 | 2 | 1 | 1 | 2
BR3 | 8 | 8 | 8 | 8 | 8 | 9 | 9 | 8
BR4 | 7 | 8 | 12 | 10 | 10 | 8 | 12 | 9
 | Feb-20
BR1
BR2
BR3
BR4
Spreadsheet: d3ef583e-0421-4e20-b4e5-22ddd092cab5
Sheet: Sheet1

Release: S&P/Case-Shiller Home Price Indices | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=199
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-17 5:16 AM [NAME]
 | Real-Time | Period
Name: | Start | End
S&P/Case-Shiller Home Price Indices | 2010-10-26 00:00:00 | Current
Link:
http://www.standardandpoors.com/indices/sp-case-shiller-home-price-indices/en/us/?indexId=spusa-cashpidff--p-us---- | 2010-10-26 00:00:00 | Current
Source:
Standard and Poor's | 2010-10-26 00:00:00 | 2012-07-01 00:00:00
S&P Dow Jones Indices LLC | 2012-07-02 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-10-26 00:00:00
2010-11-30 00:00:00
2010-12-28 00:00:00
2011-01-25 00:00:00
2011-02-22 00:00:00
2011-03-29 00:00:00
2011-04-26 00:00:00
2011-05-31 00:00:00
2011-06-28 00:00:00
2011-07-26 00:00:00
2011-08-30 00:00:00
2011-09-27 00:00:00
2011-10-25 00:00:00
2011-11-29 00:00:00
2011-12-27 00:00:00
2012-01-31 00:00:00
2012-02-28 00:00:00
2012-03-27 00:00:00
2012-04-24 00:00:00
2012-05-29 00:00:00
2012-06-26 00:00:00
2012-07-31 00:00:00
2012-08-28 00:00:00
2012-09-25 00:00:00
2012-10-30 00:00:00
2012-11-27 00:00:00
2012-12-26 00:00:00
2013-01-29 00:00:00
2013-02-26 00:00:00
2013-03-26 00:00:00
2013-04-30 00:00:00
2013-05-28 00:00:00
2013-06-25 00:00:00
2013-07-30 00:00:00
2013-08-27 00:00:00
2013-09-24 00:00:00
2013-10-29 00:00:00
2013-11-26 00:00:00
2013-12-31 00:00:00
2014-01-28 00:00:00
2014-02-25 00:00:00
Spreadsheet: 349073d1412193748-time-input-and-hours-worked-calculations-weeklyinv-ndm
Sheet: Sheet2

07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
Spreadsheet: 790214d1659601157-weekly-report-shifting-employees-from-one-department-to-another-by-analyzing-data-base-excel-forum-logistik-help
Sheet: Output

 |  | 2022-07-25 00:00:00
 |  |  | Warehousing |  |  | Inbound |  |  | Outbound |  |  | Packaging management |  |  |  | Gesamt
 |  |  |  |  | Delta |  |  | Delta |  |  | Delta |  |  | Delta |  |  |  | Delta
 | Total operator | Total employees
 | Aussteuerung | partial retirement
 |  | net employees
 | own employee | thereof permanent
 | Temporary | thereof temporary
 | shift of the employee towards the area | Shifting to department |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
 | shift of the employee from the area | Shifting from department
 | Sick | Sick
 | Vacation | Vacation
 | Corona | Corona
 | Long Term Absence | long term ill
 | Injury | injury
 | Rest | missing without information
 | In-Production | Actual presence
 |  | Sick quote
 |  | Absence rate
 |  |  |  | Check |  |  | Check |  |  | Check |  |  | Check |  |  |  | Check
Spreadsheet: 45653d1244473242-nesting-vlookup-in-if-vice-versa-and-pivot-table-sample3
Sheet: Jan Summary

Model | Year-to-Date: Cat1 | Year-to-Date: Cat2 | Total YTD
500 | -174.29 | 245.7489 | 71.45889999999997
750 | -2262.167420000004 | 3189.656062200006 | 927.4886422000018
900 | 0 | 0 | 0
AB | -661.97716 | 933.3877956 | 271.4106356
AD | -53.8898 | 75.984618 | 22.094818
AG | 0 | 0 | 0
AL | -1523.33 | 2147.8953 | 624.5652999999998
AN | 0 | 0 | 0
BX | -4056.255 | 5719.31955 | 1663.06455
BZ | -3228.96 | 4552.8336 | 1323.8736
CA | -1841.355 | 2596.31055 | 754.9555499999997
CB | -402.3125 | 567.260625 | 164.948125
DE | 0 | 0 | 0
DF | 0 | 1143.86391 | 1143.86391
DS | 0 | 910.56672 | 910.56672
DV | 0 | 0 | 0
DX | 0 | 0 | 0
FA | 0 | 519.2621099999999 | 519.2621099999999
GL | -2868.781915198807 | 4044.982500430317 | 1176.200585231511
GM | -221.0269653693443 | 311.6480211707755 | 90.62105580143117
MF | -755.3130685052638 | 1064.991426592422 | 309.6783580871581
MR | -9278.193647035247 | 13082.2530423197 | 3804.05939528445
OA | -328.2282893398016 | 462.8018879691202 | 134.5735986293186
OB | -123.2664119982595 | 173.8056409175458 | 50.53922891928637
OR | -154.8486199890987 | 218.3365541846291 | 63.48793419553044
RA | 0 | 0 | 0
RF | 0 | 0 | 0
TM | 0 | 0 | 0
ZP | -271.5391654515289 | 382.8702232866557 | 111.3310578351268
Grand Total | -28205.73496288735 | 42343.77903767117 | 14138.04407478381
Spreadsheet: 838229d1690830912-average-formula-but-does-not-include-blank-fields-labor-tracker-1945-1-
Sheet: Daily Tracking

Labor Tracker Week Ending Date | 2023-06-29 00:00:00 |  |  |  |  | Market #
 |  |  | Actual Hours Used By Day in Each Site
 |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Remaining Hours | Average Hours/Day | Remaining Manager [NAME]
Store # | Weekly Budget Hours | AVERAGE/DAY | Regular | Manager | ShiftSmart | total | Regular | Manager | ShiftSmart | total | Regular | Manager | ShiftSmart | total | Regular | Manager | ShiftSmart | total | Regular | Manager | ShiftSmart | total | Regular | Manager | ShiftSmart | total | Regular | Manager | ShiftSmart | total
2723421 | 271.4 |  | 0 |  | 12 |  | 0 |  |  |  | 86.44 | 32.7
2723432 | 273 |  | 0 |  | 12 |  | 0 |  |  |  | 47.22 | 29.78
2723435 |  |  | 0 |  | 8 |  | 0 |  |  |  | 86.68 | 0
2723437 | 248.6 |  | 0 |  | 12 |  | 0 |  |  |  | 69.41 | 18.55
2723440 | 264.9 |  | 0 |  | 12 |  | 0 |  |  |  | 88.54 | 10.6
2723448 | 288.1 |  | 0 |  | 12 |  | 0 |  |  |  | 113.94 | 0
2723456 | 310.7 |  | 0 |  | 12 |  | 0 |  |  |  | 82.21 | 8.98
2723736 | 351 |  | 0 |  | 20 |  | 0 |  |  |  | 132.7 | 10
2723738 | 365 |  | 0 |  | 12 |  | 0 |  |  |  | 156.48 | 17.5
2723745 | 314.4 |  | 0 |  | 12 |  | 0 |  |  |  | 101.24 | 12.97
2723748 | 312.2 |  | 0 |  | 12 |  | 0 |  |  |  | 144.11 | 10.3
2723759 | 263.1 |  | 0 |  | 12 |  | 0 |  |  |  | 77.76 | 0.03
2723761 | 264.3 |  | 0 |  | 12 |  | 0 |  |  |  | 82.45 | 17.78
2723859 | 329.5 |  | 0 |  | 12 |  | 0 |  |  |  | 122.1 | 0
 |  |  | 25 | 25 | 25 |  | 25 | 25 | 25
Market Total
Spreadsheet: 113830d1309716341-excel-2007-timesheet-wage-test
Sheet: Sheet1

Job | Code | Pay | Code
Manger | 1 | 9
[NAME] | 2 | 8
Server | 3 | 4
Date | Sunday | Monday | Tuesday | Wednesday | Thrusday | Friday | Saturday
 | 2011-06-26 00:00:00
Pay Rate | 1 | 3 | 2 | 3 | 1 | 1 | 3
[NAME]: | 0 | 0 | 4.01 | 0 | 7.58 |  | 0 |  | Total Hours:
Pay |  |  |  |  |  |  |  |  | Gross Pay: