tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: West-Trading w-o AA

 | West Gas - Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp |  | ADJUSTED
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 856458 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 0 |  |  |  |  |  | 420200
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 155337.6 | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 36000 |  |  |  |  |  | 75000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 36000 | Total |  |  |  |  | 75000
ENAOUTSV | Outside Services |  |  |  |  |  | 0 |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 24000 |  |  |  |  |  | 50000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000 |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | 283.2 | [NAME] | 48400 | 0 |  |  | 590
ENARENT | Rent |  |  |  |  |  | 0 | Staff | 49500 | 0 |  |  | 0
ENATECH | Technology |  |  |  |  |  | 48000 | Specialist | 57750 | 0 |  |  | 100000
ENATRANS | Transportation |  |  |  |  |  | 0.96 | Sr. Specialist | 71500 | 0 |  |  | 2
ENAOTHEX | Other Expenses |  |  |  |  |  | 7200 | Analyst | 60500 | 4 |  |  | 15000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 2 |  |  | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  | 0 | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 818106d1676589958-if-and-or-q-and-d-feb-with-summary-end
Sheet: 12th

1 | Defect ID | Unit ID | Unit Date | Prod Date | Act Date | Shift | Year | Serial | z | ID #1 | ID #2 | ID #3 | Product | Color #1 | Color #2 | Part | Location | Concern | [NAME] | Rank | Grid Label | Responsible Area | Responsible Cell | Recording User | Recording Area | Recording Cell | Recording Station | Defect Status | Root Cause | Root Cause User | Comments | sequence no | 1st | 2nd | 3rd | Date
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 025f689c-36bc-4a02-b352-3633394410cc
Sheet: $$ Monographs

[NAME] vs. [NAME]
Monographs Expenditures
 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | % Change
Peer Average
Peer Median
University of Rhode Island | 348430 | 303998 | 441062 | 304317 | 329296
[NAME] University | 900414 | 964945 | 879874 | 658887 | 667657
Montana State University - Bozeman | 254293 | 413799 | 289576 | 297853 | 257971
North Dakota State University - Main Campus | 169032 | 173682 | U/A | 144956 | U/A | U/A
University of Maine | 575553 | 592903 | 736352 | 514404 | 446985
University of New Hampshire - Main Campus | 784145 | 652488 | 548383 | 400948 | 405917
University of Vermont and State Ag. Coll. | U/A | 816624 | U/A | 754363 | 758392 | U/A
University of Wyoming | 248823 | 346806 | 2060183 | 3435937 | 1473112
Source: ACRLMetrics
Revised: October 24, 2011, ajr
Spreadsheet: 2d1077de-fc10-470c-a55e-c0a5342745ec
Sheet: August

FEDERAL COLLEGE WORK-STUDY PROGRAM
MASTER SHEET FOR STUDENT WORK HOURS
NAME |  |  |  |  |  |  |  | ASU ID #
PAY PERIOD BEGINNING |  |  | 2012-08-21 00:00:00 |  |  |  |  | PAY PERIOD ENDING |  |  | 2012-08-31 00:00:00
HOURLY RATE |  |  | 7.25 |  | TOTAL Hours |  |  |  |  | DEPARTMENT
TIME
WORKED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
IN
OUT
IN
OUT
IN
OUT
TOTAL
TIME
WORKED | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
IN
OUT
IN
OUT
IN
OUT
TOTAL
Student's Signature
[NAME]'s (Print Name) |  |  |  |  |  |  |  |  |  | [NAME]'s Signature
Department Head's (Print Name) |  |  |  |  |  |  |  |  |  | Department Head's Signature
Note:  This Master [NAME] should reflect the time and hours the student actually worked.  The total hours per day should reflect in the total column.
Students are not authorized to work no more than 20 hours per week.  No EXCEPTIONS!!!
Spreadsheet: 140452d1328754753-linked-drop-down-lists-and-vlookup-testdata1
Sheet: Sheet3

Month | TL
Jan | [NAME]
Feb | George
Mar | [NAME]
Apr | [NAME]
May | Zareen
Jun | Adeel
Jul | [NAME]
Aug | Fred
Sep | [NAME]
Oct | Nona
Nov | [NAME]
Dec | [NAME]
 | Chelsea
 | [NAME]
 | Mark
 | [NAME]
 | Vijay
Spreadsheet: 33974d1230939300-linking-to-last-record-in-a-spreadsheet-excelforum_2003_upload
Sheet: table 2 withIndexMatch

year | weight | length | length/[NAME] |  | year | weight | length | length/[NAME] | 15 |  |  | year | weight | length | length/[NAME]
1998 | 34 | 202 | 5.941176470588236 |  | 2008 | 56 | 301 | 5.375 |  |  | 15 | 1994 | 28 | 171 | 6.107142857142857
1999 | 24 | 123 | 5.125 |  | prev 5yr avg | 25.4 | 133 | 5.236220472440945 |  |  | 14 | 1995 | 23 | 154 | 6.695652173913044
2000 | 27 | 134 | 4.962962962962963 |  | 2007 | 28 | 147 | 5.25 |  |  | 13 | 1996 | 26 | 150 | 5.769230769230769
2001 | 21 | 121 | 5.761904761904762 |  | 2006 | 27 | 145 | 5.37037037037037 |  |  | 12 | 1997 | 22 | 111 | 5.045454545454546
2002 | 25 | 132 | 5.28 |  | 2005 | 22 | 126 | 5.727272727272728 |  |  | 11 | 1998 | 34 | 202 | 5.941176470588236
2003 | 19 | 112 | 5.894736842105263 |  | 2004 | 31 | 135 | 4.354838709677419 |  |  | 10 | 1999 | 24 | 123 | 5.125
2004 | 31 | 135 | 4.354838709677419 |  | 2003 | 19 | 112 | 5.894736842105263 |  |  | 9 | 2000 | 27 | 134 | 4.962962962962963
2005 | 22 | 126 | 5.727272727272728 |  | 2002 | 25 | 132 | 5.28 |  |  | 8 | 2001 | 21 | 121 | 5.761904761904762
2006 | 27 | 145 | 5.37037037037037 |  | 2001 | 21 | 121 | 5.761904761904762 |  |  | 7 | 2002 | 25 | 132 | 5.28
2007 | 28 | 147 | 5.25 |  | 2000 | 27 | 134 | 4.962962962962963 |  |  | 6 | 2003 | 19 | 112 | 5.894736842105263
prev 5yr avg | 25.4 | 133 | 5.319443729885156 |  | 1999 | 24 | 123 | 5.125 |  |  | 5 | 2004 | 31 | 135 | 4.354838709677419
2008 | 56 | 301 | 5.375 |  | 1998 | 34 | 202 | 5.941176470588236 |  |  | 4 | 2005 | 22 | 126 | 5.727272727272728
 |  |  |  |  | 1997 | 22 | 111 | 5.045454545454546 |  |  | 3 | 2006 | 27 | 145 | 5.37037037037037
 |  |  |  |  | 1996 | 26 | 150 | 5.769230769230769 |  |  | 2 | 2007 | 28 | 147 | 5.25
 |  |  |  |  | 1995 | 23 | 154 | 6.695652173913044 |  |  | 1 | prev 5yr avg | 25.4 | 133 | 5.236220472440945
 |  |  |  |  | 1994 | 28 | 171 | 6.107142857142857 |  |  | 0 | 2008 | 56 | 301 | 5.375
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -2
 |  |  |  |  |  |  |  |  |  |  | -3
 |  |  |  |  | Change Order [NAME] |  |  |  |  |  | [NAME] as Is -- Possible Approach
 |  |  |  |  |  |  |  |  |  |  | Use L to make life easier -- can be hidden...
 |  |  |  |  |  |  |  |  |  |  | Note that use of INDEX to return cell reference (for purposes of Averaging results)
 |  |  |  |  |  |  |  |  |  |  | is argued to be a Volatile action -- (ie acts as per OFFSET / INDIRECT etc...)
 |  |  |  |  | On a final note ... Am unsure as to how you're handling average for prior 5 years... Avg the prior avgs or avg the prior length / weight ?
Spreadsheet: 875494d1722061369-highlight-cells-relating-to-data-input-book2
Sheet: book2

 | Name: | Por2gal
MONDAY | DATE: | 2024-07-22 00:00:00 |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 4 |  | AM |  | AM |  |  | AM |  | AM
 | 1 |  | PM |  | PM |  |  | PM |  | PM
TUESDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 3 |  | AM |  | AM |  |  | AM |  | AM
 | 2 |  | PM |  | PM |  |  | PM |  | PM
WEDNESDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 6 |  | AM |  | AM |  |  | AM |  | AM
 | 3 |  | PM |  | PM |  |  | PM |  | PM
THURSDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 2 |  | AM |  | AM |  |  | AM |  | AM
 | 4 |  | PM |  | PM |  |  | PM |  | PM
FRIDAY | DATE:
 |  |  |  |  |  |  |  |  |  |  |  | Leave this Column Blank
 | number | SIGN ON |  | SIGN OFF |  | ALLOCATION
 | 5 |  | AM |  | AM
 | 6 |  | PM |  | PM
 |  |  | AM |  |  | PM
 |  | 1 | 06:00:00 | 09:00:00 |  | 14:45:00 | 16:15:00 | G36 and H36 Highlights with any number '1' placed in cells B8, B14,B20,B26,B32
 |  | 2 | 07:15:00 | 08:50:00 |  | 14:45:00 | 16:45:00 | G37 and [NAME] with any number '2' placed in cells B8, B14,B20,B26,B32
 |  | 3 | 07:00:00 | 08:50:00 |  | 14:30:00 | 16:15:00 | G38 and H38 Highlights with any number '3' placed in cells B8, B14,B20,B26,B32
 |  | 4 | 06:30:00 | 09:00:00 |  | 14:00:00 | 17:00:00 | G39 and [NAME] with any number '4' placed in cells B8, B14,B20,B26,B32
 |  | 5 | 07:00:00 | 08:50:00 |  | 14:00:00 | 17:00:00 | G40 and H340 Highlights with any number '5' placed in cells B8, B14,B20,B26,B32
 |  | 6 | 07:15:00 | 09:15:00 |  | 14:30:00 | 17:00:00 | G41 and H41 Highlights with any number '6' placed in cells B8, B14,B20,B26,B32
 |  |  | [NAME] and E36 Highlights with any number '1' placed in cells B7,B13,B19,B25,B31
 |  |  | D37 and [NAME] with any number '2' placed in cells B7,B13,B19,B25,B31
 |  |  | D38 and [NAME] with any number '3' placed in cells B7,B13,B19,B25,B31
 |  |  | D39 and [NAME] with any number '4' placed in cells B7,B13,B19,B25,B31
 |  |  | D40 and E40 Highlights with any number '5' placed in cells B7,B13,B19,B25,B31
 |  |  | D41 and [NAME] with any number '6' placed in cells B7,B13,B19,B25,B31
Spreadsheet: 142840d1330031561-excel-2007-looking-for-help-creating-average-if-formula-copy-of-moms-bp-readings
Sheet: Sheet3

Mom's Blood Pressure Readings Using Imron Wrist Cuff unit
Starting Feb 8, 2012 |  |  | (Averages based on systolic readings >85, diastolic<85)
Date | Time | Ave. BP |  | 1st Rdg |  | 2nd Rdg |  | 3rd Rdg |  | [NAME] |  | Read by: | Style
 |  | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom
2012-02-08 00:00:00 | 03:00:00 | 132 | 62 | 132 | 62 |  |  |  |  |  |  | Home Nurse | Arm Cuff
2012-02-08 00:00:00 | 03:15:00 | 136.25 | 68.75 | 143 | 67 | 132 | 67 | 132 | 68 | 138 | 73 | Mom | Wrist Cuff
 |  | 140 | 105 | 140 | 70 | 140 | 70 | 140 | 70 | 140 | 70
Spreadsheet: 326548d1403189628-functions-use-for-various-conditioning-book1
Sheet: Sheet3

 | Fruits | Occurrence | Time taken to sell (by hour) | Date Sold
 | Apple |  | 26 | 2014-01-01 00:00:00
 | Apple |  | 1 | 2014-01-07 00:00:00
 | Apple |  | 0.5 | 2014-01-14 00:00:00
 | [NAME] |  | 2.5 | 2014-01-21 00:00:00
 | [NAME] |  | 2 | 2014-01-28 00:00:00
 | Blueberry |  | 1 | 2014-02-04 00:00:00
 | Durian |  | 29 | 2014-02-12 00:00:00
 | Durian |  | 5 | 2014-02-18 00:00:00
 | Grapefruit |  | 6 | 2014-02-23 00:00:00
 | Kiwi |  | 3 | 2014-02-28 00:00:00
 | Kiwi |  | 28 | 2014-03-03 00:00:00
 | Mango |  | 2 | 2014-03-07 00:00:00
 | Mango |  | 5 | 2014-03-15 00:00:00
 | Mango |  | 25 | 2014-03-22 00:00:00
 | Mango |  | 4 | 2014-03-27 00:00:00
 | Mangosteen |  | 30 | 2014-04-04 00:00:00
 | Orange |  | 4 | 2014-04-16 00:00:00
 | Orange |  | 1 | 2014-04-20 00:00:00
 | Papaya |  | 8 | 2014-04-26 00:00:00
 | Papaya |  | 13 | 2014-05-01 00:00:00
 | Papaya |  | 25 | 2014-05-08 00:00:00
 | Starfruit |  | 3.5 | 2014-05-13 00:00:00
 | [NAME] |  | 3 | 2014-05-20 00:00:00
 | Watermelon |  | 2 | 2014-05-24 00:00:00
 | Watermelon |  | 2 | 2014-05-27 00:00:00
 | Wintermelon |  | 0.5 | 2015-05-31 00:00:00
Spreadsheet: 845475d1696972730-problem-with-league-table-golfscoresmultiplayerliveck76
Sheet: Handicaps

 |  |  | 2023-12-04 00:00:00 | 2024-01-08 00:00:00 | 2024-02-05 00:00:00 | 2024-03-04 00:00:00 | 2024-04-08 00:00:00 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00
Team/Hcap | StartHcp
Team1
Player1 | 12
Player2 | 17
Player3 | 16
Player4 | 17
Team2
Player5 | 10
Player6 | 15
Player7 | 19
Player8 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: A7

Local A7
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-01 00:00:00
[NAME]: | 4
Réservé:
Prix: | 125
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011 | Post-daté
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 857858d1706724644-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-gk-31-jan-final
Sheet: COSTA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
COSTA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  |  | Mo. [NAME]: |  |  |  | Hrly [NAME].: |  |  |  | Position: | Officer
 |  |  |  |  |  |  |  |  |  | Shift: | Grave |  |  | Stipends/UA |  |  |  | Bi-Wk Equiv.: |  |  |  | Union: | R08
LEAVE USAGE
TYPE | V | S | SF | CTO | HC | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
 |  |  |  |  |  |  |  |  |  | 1 | 2023-10-22 00:00:00 | 2023-11-04 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-18 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 3 | 2023-11-19 00:00:00 | 2023-12-02 00:00:00 | 80
 |  | NO TIME TAKEN |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
 |  |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
OVERTIME AUTHORIZED
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE |  |  |  |  |  | Difference:
FOOTBALL VS BOISE | 2023-11-04 00:00:00 | 1500 | 2330 | 8.5 | OTPR | 871-425P |  | 1.5
BOARD OF TRUSTEE MEETINGS | 2023-11-06 00:00:00 | 900 | 1330 | 4.5 | OTPR | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-07 00:00:00 | 700 | 2000 | 13 | CTO | 213-425P | 20 | 21.222
BOARD OF TRUSTEE MEETINGS | 2023-11-08 00:00:00 | 700 | 1700 | 10 | HOL(W) | 213-425P
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 12 | HG6 | 213-425HP
FOOTBALL VS NEW MEXICO | 2023-11-18 00:00:00 | 1600 | 2345 | 7.8 | OTPR | 871-425P |  | 1.75
THANKSGIVING DAY - REG SHIFT | 2023-11-23 00:00:00 |  |  | 12 | HG6 | 213-425HP
Total
 |  |  |  | Regular Shift Differential Hours: |  |  |  | 180
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: 769174d1645368036-filling-a-cell-with-only-the-last-available-data-measurement-of-a-sanple-sample-analyses-results
Sheet: Sheet1

Sample ID | Analysis Data |  | Sample ID | Rep. 1 | Rep. 2 | Rep. 3 | Rep. 4 | Rep. 5 | Rep. 6 | Reported result | or… | Sample ID
Sample 1 | 10 |  | Sample 1 |  |  |  |  |  |  |  |  | Sample 1
Sample 1 | 11 |  | Sample 2 |  |  |  |  |  |  |  |  | Sample 2
Sample 2 | 20 |  | Sample 3 |  |  |  |  |  |  |  |  | Sample 3
Sample 2 | 22 |  | Sample 4 |  |  |  |  |  |  |  |  | Sample 4
Sample 2 | 23
Sample 3 | 30
Sample 3 | 33
Sample 3 | 34
Sample 3 | 35
Sample 4 | 50
Sample 4 | 53
Sample 4 | 55
Sample 4 | 56
Sample 4 | 57
Spreadsheet: 125738d1319204933-formula-to-find-numbers-within-several-ranges-sample-11-
Sheet: Sheet1

Site | Date | Time | Extn |  | Code & Number |  |  | Type range: | 111190050 | 111190099
 | 2011-10-10 00:00:00 | 14:35:24 | 19007 |  | (0041) 111190051 | Switzerland | International | 00:00:03
 | 2011-10-05 00:00:00 | 10:17:23 | 19007 |  | (0041)111190059 | Switzerland | International | 00:00:01
 | 2011-10-05 00:00:00 | 10:32:37 | 19007 |  | (0041)111190059 | Switzerland | International | 00:15:23
 | 2011-10-05 00:00:00 | 14:02:49 | 19007 |  | (0041) 111190059 | Switzerland | International | 00:05:16
 | 2011-10-05 00:00:00 | 15:30:35 | 19007 |  | (0041) 111190059 | Switzerland | International | 00:00:03
 | 2011-10-05 00:00:00 | 15:39:36 | 19007 |  | (0041) 111190059 | Switzerland | International | 00:00:02
 | 2011-10-07 00:00:00 | 15:43:48 | 19007 |  | (0041) 111190077 | Switzerland | International | 00:05:18
 |  |  |  |  | 123456789
Spreadsheet: 743896d1628797980-help-correlate-an-output-based-on-two-inputs-time-per-cut-orrie
Sheet: Sheet1

CUT LENGTH | LINE SPEED | TIME PER CUT
29.25 | 5.5 | 7.7
32.25 | 7.5 | 5.75
32.25 | 8 | 5.48
32.25 | 8.4 | 5.7
32.25 | 9.2 | 4.66
32.25 | 10 | 4.6
33.75 | 9 | 5.38
33.75 | 9.4 | 5
34.5 | 5 | 9.7
34.5 | 5 | 9.5
34.5 | 6 | 8.5
34.5 | 6.2 | 8.9
38 | 7.6 | 6.75
41.25 | 6.2 | 8.5
41.25 | 5.5 | 10.5
42.19 | 6.1 | 9.35
42.5 | 9.5 | 6.7
43 | 6.8 | 8.75
43 | 6.8 | 9.4
43.5 | 6.45 | 10.1
46.28 | 6.1 | 9.65
48 | 2.8 | 22.5
48.5 | 6.7 | 10.5
50 | 7.8 | 10.2
50.75 | 7 | 10.8
53 | 5.6 | 13.9
56.5 | 5.3 | 13.9
62.375 | 5.6 | 14.63
63.95 | 5.6 | 11
65 | 5.8 | 5.5
65 | 6.5 | 12.2
65 | 5.2 | 16.2
66 | 10.5 | 9.3
Spreadsheet: 06b9fb9f-b9cf-4465-8529-78bd3b93aa0b
Sheet: W

Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
Women's Studies
WMST 101 | Social Sciences
WMST 102 | Social Sciences
WMST 202 | Social Sciences |  | cross-listed with SOCI 202
WMST 281 | Social Sciences
WMST 282 | Social Sciences
WMST 347 | Arts & Literature-Arts
WMST 361 | Social Sciences |  | cross-listed with COMM 361
WMST 300 & 301 | WMST 300 only | Capstone; Experiential-Research | WMST 300 & WMST 301 have the research designation
WMST 300 & 450 | WMST 300 | Capstone; Experiential-Field Studies | WMST 450 is a Field Studies course
WMST 300 & 455 | WMST 300 | Capstone
Spreadsheet: 724472d1616173381-sumproduct-adding-date-to-time-range-only-works-for-same-date-production_plan_test_2
Sheet: Production scedule

start date | run time |  |  | working week | [NAME] | fri
2021-02-01 06:30:00 |  | = 11 modules in 74 working hours |  | start work | 06:30:00 | 06:30:00 | start break | break time
 | using sumproduct | using sumifs |  | morning break start | 09:00:00 | 09:00:00 | 09:00:00 | 20
due date before breaks | counting breaks [min] | counting breaks [min] |  | morning break end | 09:20:00 | 09:20:00 | 12:00:00 | 25
 |  |  |  | lunch break start | 12:00:00
 |  |  |  | lunch break end | 12:25:00
 |  |  |  | end work | 15:15:00 | 11:50:00
 |  |  |  | Manually created scedule with correct due dates and times
 |  |  |  | mandag | tirsdag | onsdag | torsdag | fredag |  |  | mandag | tirsdag | onsdag | torsdag | fredag
 |  |  |  | 2021-02-01 06:30:00 | 2021-02-02 06:30:00 | 2021-02-03 06:30:00 | 2021-02-04 06:30:00 | 2021-02-05 06:30:00 |  |  | 2021-02-08 06:30:00 | 2021-02-09 06:30:00 | 2021-02-10 06:30:00 | 2021-02-11 06:30:00 | 2021-02-12 06:30:00
 |  |  |  | 2021-02-01 09:00:00 | 2021-02-02 09:00:00 | 2021-02-03 09:00:00 | 2021-02-04 09:00:00 | 2021-02-05 09:00:00 |  |  | 2021-02-08 09:00:00 | 2021-02-09 09:00:00 | 2021-02-10 09:00:00 | 2021-02-11 09:00:00 | 2021-02-12 09:00:00
 |  |  |  | 2021-02-01 09:20:00 | 2021-02-02 09:20:00 | 2021-02-03 09:20:00 | 2021-02-04 09:20:00 | 2021-02-05 09:20:00 |  |  | 2021-02-08 09:20:00 | 2021-02-09 09:20:00 | 2021-02-10 09:20:00 | 2021-02-11 09:20:00 | 2021-02-12 09:20:00
 |  |  |  | 2021-02-01 12:00:00 | 2021-02-02 12:00:00 | 2021-02-03 12:00:00 | 2021-02-04 12:00:00 |  |  |  | 2021-02-08 12:00:00 | 2021-02-09 12:00:00 | 2021-02-10 12:00:00 | 2021-02-11 12:00:00
 |  |  |  | 2021-02-01 12:25:00 | 2021-02-02 12:24:59.995000 | 2021-02-03 12:24:59.995000 | 2021-02-04 12:24:59.995000 |  |  |  | 2021-02-08 12:24:59.995000 | 2021-02-09 12:24:59.995000 | 2021-02-10 12:24:59.995000 | 2021-02-11 12:24:59.995000
 |  |  |  | 2021-02-01 15:15:00 | 2021-02-02 15:15:00 | 2021-02-03 15:15:00 | 2021-02-04 15:15:00 | 2021-02-05 11:50:00 |  |  | 2021-02-08 15:14:59.995000 | 2021-02-09 15:14:59.995000 | 2021-02-10 15:14:59.995000 | 2021-02-11 15:15:00 | 2021-02-12 11:50:00
Spreadsheet: 796008d1663066297-how-do-i-change-a-repeating-pattern-into-an-ascending-list-example-sheet
Sheet: Example Sheet

Output from Solar Fire v9.0.17
GMT +0:00 Tropical Geocentric Long
 | Mars
1932-03-16 00:00:00 | 345.68
1932-03-17 00:00:00 | 346.47
1932-03-18 00:00:00 | 347.26
1932-03-19 00:00:00 | 348.04
1932-03-20 00:00:00 | 348.83
1932-03-21 00:00:00 | 349.61
1932-03-22 00:00:00 | 350.39
1932-03-23 00:00:00 | 351.18
1932-03-24 00:00:00 | 351.96
1932-03-25 00:00:00 | 352.74
1932-03-26 00:00:00 | 353.53
1932-03-27 00:00:00 | 354.31
1932-03-28 00:00:00 | 355.09
1932-03-29 00:00:00 | 355.87
1932-03-30 00:00:00 | 356.65
1932-03-31 00:00:00 | 357.43
1932-04-01 00:00:00 | 358.21
1932-04-02 00:00:00 | 358.99
1932-04-03 00:00:00 | 359.77
1932-04-04 00:00:00 | 0.55 | This is where the 360 resets, the simple way would be to add 360 to all cells below, but I work with large columns and would need 360+ 100s of times
1932-04-05 00:00:00 | 1.33 | Each time it resets back to 0 after reaching 360 - it would require another 360 increment ++
1932-04-06 00:00:00 | 2.11
1932-04-07 00:00:00 | 2.88
1932-04-08 00:00:00 | 3.66
 | 358.99 | Here is my simple work-around
 | 359.77 | "B31+360"
 | 0.55
 | 1.33
 | 2.11
 | 2.88
Spreadsheet: 837982d1690568863-lists-excel-list-example
Sheet: Sheet1

HAVE
Student ID | student name | course | Code | current score | final score | unposted current score | unposted final score
2208171411 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0
2208171411 | Student A | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09
2208171411 | Student A | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46
1607120895 | Student B | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03
1607120895 | Student B | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16
NEED
Student ID | student name | course | Code | current score | final score | unposted current score | unposted final score | course | Code | current score | final score | unposted current score | unposted final score | course | Code | current score | final score | unposted current score | unposted final score
2208171411 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0 | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09 | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46 | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03 | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16
 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0 | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09 | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46 | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03 | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16