tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862437d1710169439-extract-moving-average-for-the-last-n-th-values-in-a-dynamic-row-in-excel-excluiding-zeros-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  | ave. volume | X1
 |  | Monday
 |  |  | interval | 2
 |  |  | WEEK 01 | WEEK 02 | WEEK 03 | WEEK 04 | WEEK 05 | WEEK 06 | WEEK 07 | WEEK 08 | WEEK 09 | WEEK 10 | WEEK 11 | WEEK 12 | WEEK 13 | WEEK 14 | WEEK 15 | WEEK 16 | WEEK 17 | WEEK 18 | WEEK 19 | WEEK 20 | WEEK 21 | WEEK 22 | WEEK 23 | WEEK 24 | WEEK 25 | WEEK 26 | WEEK 27 | WEEK 28 | WEEK 29 | WEEK 30 | WEEK 31 | WEEK 32 | WEEK 33 | WEEK 34 | WEEK 35 | WEEK 36 | WEEK 37
 |  |  | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday | Monday
 | xxxx | Monday | 2024-04-01 00:00:00 | 2024-04-08 00:00:00 | 2024-04-15 00:00:00 | 2024-04-22 00:00:00 | 2024-04-29 00:00:00 | 2024-05-06 00:00:00 | 2024-05-13 00:00:00 | 2024-05-20 00:00:00 | 2024-05-27 00:00:00 | 2024-06-03 00:00:00 | 2024-06-10 00:00:00 | 2024-06-17 00:00:00 | 2024-06-24 00:00:00 | 2024-07-01 00:00:00 | 2024-07-08 00:00:00 | 2024-07-15 00:00:00 | 2024-07-22 00:00:00 | 2024-07-29 00:00:00 | 2024-08-05 00:00:00 | 2024-08-12 00:00:00 | 2024-08-19 00:00:00 | 2024-08-26 00:00:00 | 2024-09-02 00:00:00 | 2024-09-09 00:00:00 | 2024-09-16 00:00:00 | 2024-09-23 00:00:00 | 2024-09-30 00:00:00 | 2024-10-07 00:00:00 | 2024-10-14 00:00:00 | 2024-10-21 00:00:00 | 2024-10-28 00:00:00 | 2024-11-04 00:00:00 | 2024-11-11 00:00:00 | 2024-11-18 00:00:00 | 2024-11-25 00:00:00 | 2024-12-02 00:00:00 | 2024-12-09 00:00:00
 | x1 | x1 | 320 | 540 | 620 | 320 | 540 | 620 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | x2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | xe | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 104901d1302335838-search-for-name-across-sheets-and-return-most-recent-date-involvement-final
Sheet: April 27

2011-04-27 00:00:00
WED
Singing:
[NAME]:
Closing:
Spreadsheet: 774306d1648382403-array-lookup-formula-issue-fcs-incentive-plan-expedition-class-copy
Sheet: Exact Commission

VS PAX  ONBOARD | TOT. BOOKING  AMOUNT (MIN) | 0 | 8 | 11 | 17
1 | 300000 | 0.003 | 0.0039 | 0.0065 | 0.0078
 | 200000 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 100000 | 0.0024 | 0.003 | 0.0045 | 0.0061
 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058 |  | # VS PAX ONBOARD |  |  |  | 4
2 | 400000 | 0.003 | 0.0039 | 0.0065 | 0.0078 | BOOKING AMOUNT IN USD $ |  |  |  |  | 400000
 | 300000 | 0.0026 | 0.0033 | 0.0056 | 0.0067 |  | # DAYS |  |  |  | 11
 | 200000 | 0.0024 | 0.003 | 0.0045 | 0.0061 |  | TOTAL COMMISSION: |  |  |  | =INDEX(C2:F593,MATCH(L5,A2:A593,0),MATCH(L6&L7,B2:B593&C1:F1,0))
 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
3 | 500000 | 0.003 | 0.0039 | 0.0065 | 0.0078 |  |  | =INDEX(C2:F593,MATCH(L5,A2:A593,0),MATCH(L6&L7,B2:B593&C1:F1,0))
 | 400000 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 100000 | 0.0024 | 0.003 | 0.0045 | 0.0061 |  | =INDEX(C2:F593,MATCH(1,INDEX((L5=A2:A593)*(L7=C1:F1)*(L6=B2:B593),0,1),0))
 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
4 | 700000 | 0.003 | 0.0039 | 0.0065 | 0.0078 |  | =IFERROR(INDEX(C2:F593,MATCH(1,INDEX(((L5=A2:A593)*(L7=C1:F1)*(L6=B2:B593),0,1),0)),"Not Available")
 | 500000 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 300000 | 0.0024 | 0.003 | 0.0045 | 0.0061
 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
5 | 1000000 | 0.003 | 0.0039 | 0.0065 | 0.0078
 | 750000 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 500000 | 0.0024 | 0.003 | 0.0045 | 0.0061
 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
Spreadsheet: 696118d1600638190-calculate-difference-between-two-numbers-based-on-a-range-of-dates-based-on-input-book1
Sheet: Sheet1

Date | Milage | Gallons | Cost | Cost per Gal | Milage | Miles Per Day |  |  | Year | 2018
2017-12-29 00:00:00 | 32456
2018-01-08 00:00:00 | 32597 | 7.867 | 21.71
2018-01-10 00:00:00 | 32828 | 11.026 | 32.52
2018-01-14 00:00:00 | 33076 | 12.306 | 34.94
2018-01-27 00:00:00 | 33310 | 11.633 | 33.72
2018-02-18 00:00:00 | 33529 | 12.018 | 35.8
2018-02-23 00:00:00 | 33655 | 6.525 | 19.18
2018-02-25 00:00:00 | 33872 | 11.018 | 29.74
2018-03-04 00:00:00 | 34076 | 10.408 | 29.65
2018-03-17 00:00:00 | 34329 | 13.357 | 33.11
2018-04-01 00:00:00 | 34576 | 12.144 | 35.81
2018-04-07 00:00:00 | 34847 | 14.222 | 41.66
2018-04-17 00:00:00 | 35102 | 13.035 | 40.14
2018-04-28 00:00:00 | 35375 | 13.483 | 41.38
2018-05-08 00:00:00 | 35665 | 14.203 | 44.02
2018-05-22 00:00:00 | 35919 | 12.703 | 41.91
2018-06-01 00:00:00 | 36208 | 14.237 | 43.98
2018-06-17 00:00:00 | 36480 | 13.247 | 40.26
2018-06-23 00:00:00 | 36629 | 7.592 | 25.12
2018-06-23 00:00:00 | 36813 | 8.04 | 26.2
2018-06-30 00:00:00 | 37098 | 13.503 | 40.5
2018-07-07 00:00:00 | 37307 | 10.45 | 32.18
2018-07-24 00:00:00 | 37564 | 13.064 | 44.01
2018-08-05 00:00:00 | 37835 | 12.929 | 41.1
2018-08-17 00:00:00 | 38120 | 14.423 | 44.41
2018-08-28 00:00:00 | 38362 | 11.847 | 36.71
2018-09-04 00:00:00 | 38632 | 12.793 | 41.69
2018-09-16 00:00:00 | 38838 | 10.398 | 28.48
2018-10-01 00:00:00 | 39110 | 13.102 | 37.85
2018-10-09 00:00:00 | 39365 | 12.177 | 37.25
2018-10-21 00:00:00 | 39669 | 14.769 | 45.03
2018-11-02 00:00:00 | 39911 | 11.604 | 34.68
2018-11-10 00:00:00 | 40182 | 13.431 | 39.61
2018-11-21 00:00:00 | 40450 | 13.604 | 33.86
2018-11-28 00:00:00 | 40695 | 12.531 | 32.19
2018-12-09 00:00:00 | 40930 | 12.068 | 30.4
2018-12-19 00:00:00 | 41152 | 12.058 | 29.89
2018-12-29 00:00:00 | 41400 | 12.742 | 31.21
2019-01-12 00:00:00 | 41632 | 11.952 | 28.67
2019-01-20 00:00:00 | 41837 | 10.575 | 26.96
2019-02-11 00:00:00 | 42050 | 11.452 | 27.24
2019-02-24 00:00:00 | 42277 | 11.778 | 31.79
2019-03-03 00:00:00 | 42514 | 12.229 | 35.7
Spreadsheet: 134477d1325324145-help-to-update-next-column-using-formula-book1
Sheet: Sheet2

 |  |  |  |  |  |  | Reference
 | 2010 |  | 2011
 | Jawatan | gred | jawatan | gred |  |  | 2010 |  | 2011
 | Guru | M12 |  |  |  |  | Jawatan | Gred | Jawatan | Gred
 | [NAME] | F12 |  |  |  |  | Guru | M12 | [NAME] | M-2-3
 | Jurulatih | K12 |  |  |  |  | [NAME] | F12 | Chef | NN-2-3
 | Pelajar | G12 |  |  |  |  | Jurulatih | K12 | Jurulatih | KK-2-3
 | Guru | [NAME] |  |  |  |  | Pelajar | G12 | Pelajar | M-1-2
 | [NAME] | F13
 | Jurulatih | K13
 | Pelajar | G13
 | Guru | M14
 | [NAME] | F14
 | Jurulatih | K14
 | Pelajar | G14
 | Guru | M15
 | [NAME] | F15
 | Jurulatih | K15
 | Pelajar | [NAME]
 | Guru | M16
Spreadsheet: 51989d1251659448-subtracting-hours-in-a-work-schedule-laura-test-for-schedule-formula-working-with-new-col
Sheet: Store 3

STORE 3
DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
EMPLOYEE | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | MONDAY |  |  | TUESDAY |  |  | TOTAL HOURS
DARCELL | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 08:15:00 | 16:00:00 | 7.249999999999999 | 09:00:00 | 16:15:00 | 6.750000000000001 | 09:00:00 | 16:00:00 | 6.499999999999999 | 40
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999
CATHERINE | 14:15:00 | 21:15:00 | 6.499999999999999 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 6.499999999999999
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0
NICK | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 34.49999999999999
Spreadsheet: 390498d1429652059-grading-spreadsheet-gradebook
Sheet: Sheet1

 |  |  | Assignment | Value | [NAME]
 |  |  | 50% Lab Exercises
 |  |  | Drawing 1 | 10
 |  |  | Drawing 2 | 5
 |  |  | Drawing 3 | 10
 |  |  | Drawing 4 | 5
 |  |  | Label Assignment | 25
 |  |  | Lab Exam 1 | 65
 |  |  | Lab Exam 2 | 65
 |  |  | Lab Exam 3 | 65
 |  |  | Lab Exam 4 | 75
 |  |  | Insect Collection | 175
 |  |  | Extra credit | 0
 |  |  | 50% Lecture Exams
 |  |  | Lecture Exam 1 | 100
 |  |  | Lecture Exam 2 | 100
 |  |  | Lecture Exam 3 | 100
 |  |  | Lab Points Earned
 |  |  | Lab Points Possible
 |  |  | Lecture Points Earned
 |  |  | Lecture Points Possible
 |  |  | Grade % to Date
Spreadsheet: martin_cuilla__25348__Bowl2000
Sheet: bonus

favorite | underdog
Spreadsheet: 268767d1380780070-indirect-function-to-pull-desired-no-of-cells-row-data-based-on-data-validation-in-input-file1
Sheet: M1

 | Arbind Pvt Ltd |  | Period
SN | Name of Product | Type of Scheme | From | To | Minimum Sales Qty | Scheme given on sales per carton(Free in Ctn)
1 | NEW LACTO EWP (1*30 ) | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 50
2 | CENTER COOL EWP ( 1*30 ) | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 50
3 | CAFE COFFEE EWP ( 1*30 ) | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 50
4 | MANGO TANGO EWP ( 1*30 ) | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 50
1 | NEW LACTO EWP (1*30 ) | B |  | 2013-09-16 00:00:00 | 50
2 | CENTER COOL EWP ( 1*30 ) | B |  | 2013-09-16 00:00:00 | 50
3 | CAFE COFFEE EWP ( 1*30 ) | B |  | 2013-09-16 00:00:00 | 50
 | MANGO TANGO EWP ( 1*30 ) | B |  | 2013-09-16 00:00:00 | 50
1 | NEW LACTO EWP (1*30 ) | C |  | 2013-10-17 00:00:00 | 50
2 | CENTER COOL EWP ( 1*30 ) | C |  | 2013-10-17 00:00:00 | 50
3 | CAFE COFFEE EWP ( 1*30 ) | C |  | 2013-10-17 00:00:00 | 50
4 | MANGO TANGO EWP ( 1*30 ) | C |  | 2013-10-17 00:00:00 | 50
1 | NEW LACTO EWP (1*30 ) | D |  | 2013-11-15 00:00:00 | 50
2 | CENTER COOL EWP ( 1*30 ) | D |  | 2013-11-15 00:00:00 | 50
 | CAFE COFFEE EWP ( 1*30 ) | D |  | 2013-11-15 00:00:00 | 50
 | MANGO TANGO EWP ( 1*30 ) | D |  | 2013-11-15 00:00:00 | 50
Spreadsheet: 843829d1695663094-using-countif-with-vlookup-to-return-of-results-for-a-given-date-tlc-client-tracking-prototype
Sheet: Input Data

Service Date | First Name | Last Name | New Contact? | Location | Address | DOB | Age (Automated, Do Not Edit!) | [NAME] | Race | Ethnicity | Phone | Gender | HIV Status | Service Notes | Employment | Life Skills | Housing | Medical | Behavioral Health | Substance Abuse | Community Resources | Legal | Education | Social | Snack | Total
2023-08-01 00:00:00 |  |  |  |  |  |  |  |  | Latinx |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2023-08-01 00:00:00 |  |  |  |  |  |  |  |  | Latinx |  |  |  |  |  | 1 |  | 1 |  | 1
2023-08-01 00:00:00 |  |  |  |  |  |  |  |  | Black or AA |  |  |  |  |  |  | 1 |  |  |  | 1 |  | 1 | 1
2023-08-02 00:00:00 |  |  |  |  |  |  |  |  | American Indian or Alaskan Native |  |  |  |  |  | 1 |  | 1 | 1 |  |  |  |  |  |  | 1
2023-08-02 00:00:00 |  |  |  |  |  |  |  |  | Multi-Racial |  |  |  |  |  | 1
2023-08-04 00:00:00 |  |  |  |  |  |  |  |  | White |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
Spreadsheet: 186076d1349918636-sorting-non-empty-cells-to-bottom-schedule-example2
Sheet: 6

2200-0000 |  |  | 0000-0200 |  |  | 0200-0400 |  |  | 0400-0600 |  |  | THURSDAY
CHRISTY |  |  | CHRISTY |  |  | CHRISTY |  |  | CHRISTY
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
STEPHANIE |  |  | STEPHANIE |  |  | STEPHANIE |  |  | STEPHANIE
ANGELA H |  |  | ANGELA H |  |  | DEBBIE |  |  | DEBBIE
BRANDY |  |  | BRANDY
DEBBIE |  |  | DEBBIE
NICHOLE |  |  | NICHOLE
0600-0800 |  |  | 0800-1000 |  |  | 1000-1200 |  |  | 1200-1400
 |  |  | KATY
KATY |  |  | [NAME] |  |  | KATY |  |  | KATY
[NAME] |  |  | CHERYL |  |  | [NAME] |  |  | [NAME]
CHERYL |  |  | RHONDA |  |  | CHERYL |  |  | CHERYL
RHONDA |  |  | CINDY |  |  | RHONDA |  |  | RHONDA
CINDY |  |  |  |  |  | CINDY |  |  | CINDY
 |  |  |  |  |  | LACY |  |  | LACY
 |  |  |  |  |  |  |  |  | MARK
 |  |  |  |  |  |  |  |  | KAY
1400-1600 |  |  | 1600-1800 |  |  | 1800-2000 |  |  | 2000-2200
 |  |  |  |  |  |  |  |  | CHRISTY
KATY |  |  | ANGELA H |  |  | ANGELA H |  |  | [NAME]
[NAME] |  |  | BRANDY |  |  | BRANDY |  |  | ANGELA H
CHERYL |  |  | LACY |  |  | LACY |  |  | JESS
RHONDA |  |  | NICHOLE |  |  | NICHOLE |  |  | BRANDY
CINDY |  |  | MARK |  |  | MARK |  |  | DEBBIE
LACY |  |  | KAY |  |  | KAY |  |  | NICHOLE
KAY |  |  |  |  |  |  |  |  | MARK
 |  |  |  |  |  |  |  |  | KAY
Spreadsheet: 102927d1300813933-eliminating-double-numbers-workbook15
Sheet: Sheet1

 |  | DOU
037
001
029
038
047
056
002
039
057
066
003
012
049
058
067
022
059
068
077
005
069
078
015
024
033
079
007
016
025
034
008
017
026
035
044
099
009
018
027
036
045
Spreadsheet: 119740d1314710726-checking-for-consecutive-values-book1
Sheet: Sheet2

 | meeting ID | Full name | presence | absence | תאריך ישיבה | quarter | year | company name
 | 1 | person 1 | 0 | 1 | 2011-08-31 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 1 | person 2 | 1 | 0 | 2011-08-31 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 1 | person 3 | 1 | 0 | 2011-08-31 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person 3 | 1 | 1 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person 1 | 0 | 1 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person2 | 1 | 0 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person 3 | 1 | 0 | 2011-09-01 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 3 | person 1 | 0 | 1 | 2011-09-04 00:00:00 | Q3 | 2011 | exsemple |  | 1
 | 3 | person 3 | 0 | 1 | 2011-09-04 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 1 | person 1 | 0 | 1 | 2011-09-05 00:00:00 | Q3 | 2011 | exsemple |  | 1
 | 1 | person 2 | 1 | 0 | 2011-09-05 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 1 | person 3 | 1 | 0 | 2011-09-05 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 2 | person 1 | 1 | 0 | 2011-09-06 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 2 | person 1 | 0 | 0 | 2011-09-06 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 2 | person2 | 1 | 0 | 2011-09-06 00:00:00 | Q3 | 2011 | exsemple |  | #N/A
 | 2 | person 3 | 1 | 0 | 2011-09-07 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 3 | person 1 | 0 | 1 | 2011-09-07 00:00:00 | Q3 | 2011 | exsemple |  | 0
 | 3 | person 2 | 0 | 1 | 2011-09-07 00:00:00 | Q3 | 2011 | exsemple |  | 0
Spreadsheet: 22e07c89-e994-41c7-a672-4de44db6776a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
264108 | 30685 | [NAME] | [NAME]   B1 | GBR | 2962 | 00:11:43 | 00:03:10 | 00:29:31 | 00:02:35 | [NAME] | 1 | 01:06:18
264108 | 30797 | [NAME] | [NAME] | GBR | 2961 | 00:16:33 | 00:03:14 | 00:29:17 | 00:02:20 | 00:19:25 | 2 | 01:10:53
Spreadsheet: 769005d1645244889-30-day-moving-total-starting-with-today-2022-02-18-dashboard_tracking_export
Sheet: Report1_data

Report1 Exported Data
week# | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 7
date | 02/19/22 | 02/18/22 | 02/17/22 | 02/16/22 | 02/15/22 | 02/14/22 | 02/13/22 | 02/12/22 | 02/11/22 | 02/10/22 | 02/09/22
Person 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1
Person 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Person 3 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Person 4 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
Person 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Person 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 550694d1512496625-ifs-networkdays-not-counting-first-day-samplebook
Sheet: JULY 2017 (2)

 | Promised & Delivered Reconciliation
# | JOB # | CUSTOMER | ORIGINAL DELIVERY  DATE | ORIGINAL ESTIMATED DATE (If different from column D) | SHIPPED  DATE | desired results | LATE TO  ORGINAL OR ORIGINAL ESTIMATED DATE          (DAYS) | CUSTOMER ALLOWED RE-SCHEDULED DATE
1 | 15828M | MG | 2017-07-17 00:00:00 |  | 2017-07-05 00:00:00 | -8
2 | 15829M | MG | 2017-07-17 00:00:00 |  | 2017-07-05 00:00:00 | -8
4 | 15836 | NO | 2017-07-24 00:00:00 |  | 2017-07-17 00:00:00 | -5
6 | 15858 | GP | 2017-07-05 00:00:00 |  | 2017-06-29 00:00:00 | -4
7 | 15869B | NO | 2017-07-03 00:00:00 |  | 2017-06-26 00:00:00 | -5
8 | 15873m | MG | 2017-07-24 00:00:00 |  | 2017-07-17 00:00:00 | -5
9 | 15880 | EDR | 2017-07-07 00:00:00 |  | 2017-06-14 00:00:00 | -17 |  |  | IF(F3="","",IF(D3="","",IF(ISNUMBER(H3),NETWORKDAYS(H3,F3),IF(E3="",NETWORKDAYS(D3,F3),NETWORKDAYS(E3,F3)))))
10 | 15967 | RN | 2017-07-14 00:00:00 |  | 2017-07-12 00:00:00 | -2
11 | 15968 | RN | 2017-07-25 00:00:00 |  | 2017-07-21 00:00:00 | -2
12 | 15978 | ST | 2017-07-21 00:00:00 |  | 2017-07-18 00:00:00 | -3
13 | 15980 | LAB | 2017-07-14 00:00:00 |  | 2017-07-10 00:00:00 | -4
14 | 15981 | ACEP | 2017-07-14 00:00:00 |  | 2017-07-12 00:00:00 | -2
15 | 15977 | SPT | 2017-07-21 00:00:00 |  | 2017-06-27 00:00:00 | -18
16 | 15986 | ATC | 2017-07-13 00:00:00 |  | 2017-07-12 00:00:00 | -1
17 | 15987 | ATC | 2017-07-13 00:00:00 |  | 2017-07-12 00:00:00 | -1
18 | 15985 | LAKE | 2017-07-14 00:00:00 |  | 2017-07-10 00:00:00 | -4
19 | 15976 | STM | 2017-07-14 00:00:00 |  | 2017-06-28 00:00:00 | -12
20 | 16003 | RTD | 2017-07-18 00:00:00 |  | 2017-07-18 00:00:00 | 0
21 | 16006 | RN | 2017-07-25 00:00:00 |  | 2017-07-21 00:00:00 | -2
22 | 16005 | SNY | 2017-07-19 00:00:00 |  | 2017-07-19 00:00:00 | 0
25 | 15865 | RU | 2017-07-21 00:00:00 |  | 2017-07-11 00:00:00 | -8
26 | 15866 | RU | 2017-07-22 00:00:00 |  | 2017-07-14 00:00:00 | -5
27 | 15773 | ATC | 2017-07-14 00:00:00 |  | 2017-07-14 00:00:00 | 0
28 | 15997 | ATC | 2017-07-28 00:00:00 |  | 2017-07-21 00:00:00 | -5
29
30
31
32
33
34
35
36
37
38
39
40
48
49
50
51
52
53
54
55
56
57
58
59
Promised & Delivered Reconciliation: |  |  |  | Monthly Averages:
Spreadsheet: 038bd9b6-7dc8-479f-a06b-1a6f39d9bfb3
Sheet: +45 MS 

BWF World Senior Championships 2013
MS 45 |  |  |  |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
1 | 2723 |  | FIN |  | [NAME] [1]
2 |  |  |  |  | Bye 1
3 | 83285 |  | SRI |  | [NAME]
4 | 92625 |  | DEN |  | [NAME]
5 | 74425 |  | GER |  | Heinz-Josef Rosch
6 |  |  |  |  | Bye 9
7 | 5160 |  | CAN |  | [NAME]
8 | 52227 |  | MGL |  | [NAME]
9 | 6983 |  | SWE |  | [NAME] [5/8]
10 |  |  |  |  | Bye 5
11 | 81440 |  | ENG |  | [NAME]
12 | 9236 |  | RUS |  | [NAME]
13 | 53702 |  | EST |  | [NAME]
14 |  |  |  |  | Bye 13
15 | 15848 |  | IND |  | [NAME]
16 | 64636 |  | TUR |  | Ahmet [NAME]
17 | 8218 |  | GER |  | [NAME] [3/4]
18 |  |  |  |  | Bye 3
19 | 59875 |  | UKR |  | Oleksandr Shlapak
20 | 1825 |  | SWE |  | [NAME]
21 | 83687 |  | IND |  | [NAME]
22 |  |  |  |  | Bye 11
23 | 81948 |  | DEN |  | [NAME]
24 | 58514 |  | ENG |  | [NAME]
25 | 67279 |  | JPN |  | [NAME] [5/8]
26 |  |  |  |  | Bye 7
27 | 57388 |  | QAT |  | Pavan [NAME] Venugopal
28 | 592 |  | FRA |  | Fabrice Vallet
29 | 1865 |  | RUS |  | [NAME]
30 | 79395 |  | HKG |  | [NAME]
31 | 82786 |  | TUR |  | [NAME]
32 | 93961 |  | BUL |  | [NAME]
33 | 72662 |  | POL |  | [NAME]
34 | 97234 |  | FIN |  | [NAME]
35 | 88650 |  | FRA |  | [NAME]
36 | 97122 |  | IND |  | Venkataraju Akula
37 | 83982 |  | RUS |  | Evgeny Poludkin
38 | 2969 |  | SVK |  | [NAME]
39 |  |  |  |  | Bye 8
40 | 1079 |  | DEN |  | [NAME] [5/8]
41 | 51407 |  | ENG |  | [NAME]
42 | 75094 |  | JPN |  | [NAME]
43 |  |  |  |  | Bye 12
44 | 96830 |  | TUR |  | Murat Ozmekİk
45 | 81244 |  | CAN |  | Sylvain Proteau
46 | 67382 |  | GER |  | Matthias Kleibel
47 |  |  |  |  | Bye 4
48 | 7579 |  | SWE |  | Magnus Gustafsson [3/4]
49 | 81035 |  | TUR |  | [NAME]
50 | 55879 |  | NOR |  | [NAME]
51 | 85147 |  | ITA |  | [NAME]
52 | 5835 |  | CZE |  | [NAME]
53 | 97995 |  | JPN |  | Minoru Ueji
54 | 67344 |  | FIN |  | [NAME]
55 |  |  |  |  | Bye 6
56 | 7622 |  | GER |  | Uwe Pawelek [5/8]
57 | 60031 |  | RUS |  | Dmitry Sudavtsov
58 | 11181 |  | FRA |  | Jean-Pierre Gregori
59 |  |  |  |  | Bye 10
60 | 94968 |  | AUT |  | [NAME]
61 | 80791 |  | DEN |  | [NAME]
62 | 6977 |  | SWE |  | [NAME]
63 |  |  |  |  | Bye 2
64 | 54029 |  | IND |  | [NAME] [2]
Spreadsheet: 376289d1423550399-can-this-be-done-calculate-only-selected-cells-carton-size-and-weight-calculation
Sheet: Sheet1

Total Items |  |  |  |  |  |  | Total Cu In. | Total Weight
2
 | Item Number | Something | [NAME] | Weight | Something | Something | Cu In. | Selected Wts.
 | 456565 | sfsf | 12x11x22 | 12 lbs | sfsfs | [NAME]
x | 456556 | jhjhj | 13"x21"x14" | 13 lbs | jgjgjgj | sfsfsf | 3822 | 13
 | 656545 | hfhfhfh | 12x15x12 | 22 lbs. | fsfsfsf | jfghj
x | 348675 | [NAME] | 14" x 13" x 12" | 10 | hkhkhk | jgjgj | 2184 | 10
Spreadsheet: 58393d1258643438-copy-the-titles-next-to-the-data-amy86
Sheet: amy

 | Currency | Receivables | Code | Payables
 |  |  | 200922
 | AUD | 5288.5 |  | 0 | 200922
 | CHF | -363.75 |  | 0 | 200922
 | DKK | 0 |  | 41339.7 | 200922
 | EUR | 439419.65 |  | -728447.12 | 200922
 | [NAME] | 89645235 |  | 0 | 200922
 | NOK | 0 |  | -558 | 200922
 | SGD | 0 |  | -16371 | 200922
 | USD | 71954.2 |  | -6545 | 200922
 |  |  | 200923
 | AUD | 11476 |  | 0 | 200923
 | CAD | 271655.5 |  | 0 | 200923
 | CHF | 918433.35 |  | 0 | 200923
 | DKK | 7141126.949999999 |  | -1498974.83 | ?
 | EUR | 26754485.3 |  | -4879613.53
 | GBP | 2613526.35 |  | 0
 | [NAME] | 16933746 |  | 0
 | NOK | 63996481.3 |  | 0
 | PLN | 0 |  | -557
 | SEK | 35442514.35 |  | -459269.75
 | USD | 384646.6 |  | -2347.55
 |  |  | 200924
 | CHF | 0 |  | -45781
 | EUR | 0 |  | -261789.29
 | [NAME] | 2438315 |  | 0
 | SGD | 0 |  | -3989.67
 | USD | 82364.35 |  | -47934
 |  |  | 201001
 | AUD | 6414.5 |  | 0
 | CHF | 72284.5 |  | 0
 | DKK | 248734.55 |  | 0
 | EUR | 1653272.95 |  | -145626.47
 | GBP | 1283133.55 |  | 0
 | [NAME] | 2448875 |  | 0
 | NOK | 16744752.55 |  | 0
 | SEK | 3278.5 |  | 0
 | USD | 568963.85 |  | -4626
Spreadsheet: 118971d1314116963-offset-function-and-blank-cells-formula
Sheet: Example

 | TABLE 1
 |  |  | Useful Life |  | 1 | 2 | 3 | 4 | 5
 | CAPEX |  | 3 |  | 3 | 3 | 3 | 3 | 4
 | Depreciation |  |  |  | 1 | 2 | 3 | 3 | 3.333333333333333
 | TABLE 2
 |  |  | Useful Life |  | 1 | 2 | 3 | 4 |  | 5
 | CAPEX |  | 3 |  | 3 | 3 | 3 | 3 |  | 4
 | Depreciation |  |  |  | 1 | 2 | 3 | 3 |  | 2.333333333333333