tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123550d1317731460-obtaining-data-within-a-specific-date-range-copy-of-resource-center-service-tracking-log
Sheet: Participant Roster 

 | DEMOGRAPHICS |  |  |  | ENROLLMENT INFORMATION |  |  |  |  |  |  |  | 3 MONTH RECERTIFICATION |  | 6 MONTH RECERTIFICATON |  | 9 MONTH RECERTIFICATION |  | 12 MONTH RECERTIFICATION |  |  | SUPPORTIVE SERVICES RECEIVED
Date of Entry | Last Name | First Name | DOB | Last 4  of Social | Homeless Verification | [NAME] | Date Enrolled | Case Manager | Assessment Completed | HMIS # | Income at Entry | Type of Service | Homeless verification | Income | Homeless verification | Income | Homeless verification | Income | Homeless verification | Income | Exit Date | Tokens Received | Meal Voucher | BC Voucher | ID Voucher | Comments
2011-04-02 00:00:00 | Lam | Vaness |  |  |  |  | 2011-04-02 00:00:00 | [NAME] |  | 1072746 |  | supportive service
2011-04-04 00:00:00 | Ngon | Men |  |  |  |  | 2011-04-04 00:00:00 | Brandie |  | 1035491
2011-04-05 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-05 00:00:00 | Brandie |  | 1071611
2011-04-05 00:00:00 | Rhodes | [NAME] |  |  |  |  | 2011-04-05 00:00:00 | Brandie |  | 1069958
2011-04-06 00:00:00 | Hermann | [NAME] |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1071694
2011-04-06 00:00:00 | Moore | [NAME] |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1071678 |  | supportive service
2011-04-06 00:00:00 | Rojas | Reene |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1058568
2011-04-06 00:00:00 | Vargas | [NAME] |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1071639 |  | supportive service
2011-04-08 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-08 00:00:00 | Brandie |  | 1021132
2011-04-11 00:00:00 | [NAME] | Laverne |  |  |  |  | 2011-04-11 00:00:00 | Brandie |  | 1049480
2011-04-12 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-12 00:00:00 | Brandie |  | 1016075 |  | supportive service
2011-04-12 00:00:00 | McGee | [NAME] |  |  |  |  | 2011-04-12 00:00:00 | Brandie |  | 1071666
2011-04-12 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-12 00:00:00 | Brandie |  | 1014864
2011-04-13 00:00:00 | Boney | [NAME] |  |  |  |  | 2011-04-13 00:00:00 | Brandie |  | 1071681
2011-04-13 00:00:00 | Soukup | [NAME] |  |  |  |  | 2011-04-13 00:00:00 | Brandie |  | 1072444
2011-04-14 00:00:00 | Habel | [NAME] |  |  |  |  | 2011-04-14 00:00:00 | Brandie |  | 1071697
2011-04-14 00:00:00 | Martinez | Christian |  |  |  |  | 2011-04-14 00:00:00 | Brandie |  | 1071700
2011-04-18 00:00:00 | [NAME] | Marlon |  |  |  |  | 2011-04-18 00:00:00 | Brandie |  | 1068796
2011-04-18 00:00:00 | [NAME] | Debora |  |  |  |  | 2011-04-18 00:00:00 | Brandie
Spreadsheet: 792716d1661096776-rolling-total-for-points-scored-in-last-3-games-game-scores
Sheet: 22

Date | Home | Away | Full Time Home Point | Full Time Away Point | Full Time ResultResult | Half Time Home Point | Half Time Away Point | Half Time Result
2022-06-01 00:00:00 | [NAME] | [NAME] | 1 | 1 | d | 0 | 0 | d
2022-06-02 00:00:00 | [NAME] | [NAME] | 1 | 0 | h | 0 | 0 | d
2022-06-03 00:00:00 | [NAME] | [NAME] | 0 | 1 | a | 0 | 0 | d
2022-06-04 00:00:00 | [NAME] | [NAME] | 1 | 1 | d | 1 | 0 | h
2022-06-05 00:00:00 | [NAME] | [NAME] | 1 | 0 | h | 0 | 0 | d
2022-06-06 00:00:00 | [NAME] | [NAME] | 2 | 1 | h | 1 | 0 | h
2022-06-07 00:00:00 | Bethany | [NAME] | 0 | 0 | d | 0 | 0 | d
2022-06-08 00:00:00 | [NAME] | Bethany | 1 | 4 | a | 1 | 0 | h
2022-06-09 00:00:00 | [NAME] | [NAME] | 6 | 0 | h | 1 | 0 | h
2022-06-10 00:00:00 | Nicki | [NAME] | 2 | 1 | h | 0 | 0 | d
2022-06-11 00:00:00 | [NAME] | Nicki | 0 | 0 | d | 0 | 0 | d
2022-06-12 00:00:00 | [NAME] | [NAME] | 0 | 1 | a | 0 | 0 | d
2022-06-13 00:00:00 | [NAME] | [NAME] | 3 | 0 | h | 1 | 0 | h
2022-06-14 00:00:00 | [NAME] | [NAME] | 0 | 1 | a | 0 | 0 | d
2022-06-15 00:00:00 | [NAME] | [NAME] | 2 | 2 | d | 0 | 0 | d
2022-06-16 00:00:00 | Nicki | [NAME] | 2 | 1 | h | 1 | 0 | h
2022-06-17 00:00:00 | [NAME] | Nicki | 0 | 1 | a | 0 | 1 | a
2022-06-18 00:00:00 | [NAME] | [NAME] | 0 | 0 | d | 0 | 0 | d
2022-06-19 00:00:00 | [NAME] | [NAME] | 1 | 0 | h | 1 | 0 | a
2022-06-20 00:00:00 | [NAME] | [NAME] | 2 | 0 | h | 1 | 0 | a
2022-06-21 00:00:00 | Nicki | [NAME] | 3 | 1 | h | 1 | 1 | d
2022-06-22 00:00:00 | [NAME] | Nicki | 1 | 0 | h | 0 | 0 | d
2022-06-23 00:00:00 | [NAME] | [NAME] | 2 | 1 | h | 1 | 0 | h
2022-06-24 00:00:00 | Nicki | [NAME] | 1 | 1 | d | 0 | 1 | a
2022-06-25 00:00:00 | [NAME] | Nicki | 2 | 2 | d | 1 | 0 | h
2022-06-26 00:00:00 | [NAME] | [NAME] | 4 | 1 | h | 0 | 0 | d
2022-06-27 00:00:00 | [NAME] | [NAME] | 1 | 2 | a | 0 | 1 | a
2022-06-28 00:00:00 | Bethany | [NAME] | 4 | 0 | h | 1 | 0 | h
2022-06-29 00:00:00 | [NAME] | Bethany | 0 | 2 | a | 0 | 1 | a
2022-06-30 00:00:00 | Nicki | [NAME] | 3 | 3 | d | 0 | 0 | d
2022-07-01 00:00:00 | [NAME] | Nicki | 1 | 1 | d | 0 | 1 | a
2022-07-02 00:00:00 | [NAME] | [NAME] | 0 | 0 | d | 0 | 0 | d
2022-07-03 00:00:00 | [NAME] | [NAME] | 0 | 1 | a | 0 | 0 | d
2022-07-04 00:00:00 | [NAME] | [NAME] | 5 | 0 | h | 1 | 0 | h
2022-07-05 00:00:00 | [NAME] | [NAME] | 4 | 1 | h | 1 | 1 | d
2022-07-06 00:00:00 | [NAME] | [NAME] | 0 | 2 | a | 0 | 0 | d
2022-07-07 00:00:00 | [NAME] | [NAME] | 1 | 1 | d | 0 | 1 | a
2022-07-08 00:00:00 | Bethany | [NAME] | 2 | 0 | h | 1 | 0 | h
2022-07-09 00:00:00 | [NAME] | Bethany | 1 | 0 | h | 0 | 0 | d
2022-07-10 00:00:00 | [NAME] | [NAME] | 0 | 4 | a | 0 | 2 | a
2022-07-11 00:00:00 | Bethany | [NAME] | 1 | 1 | d | 0 | 1 | a
2022-07-12 00:00:00 | [NAME] | Bethany | 1 | 2 | a | 0 | 1 | a
2022-07-13 00:00:00 | Nicki | [NAME] | 4 | 2 | h | 1 | 2 | a
2022-07-14 00:00:00 | [NAME] | Nicki | 3 | 1 | h | 1 | 1 | d
Spreadsheet: 168968d1342642177-conditional-columns-monthly-average
Sheet: Sheet1

Date | Score |  | Month | Average
2012-01-20 00:00:00 | 80.8 |  | Jan
2012-02-23 00:00:00 | 95.2 |  | Mar
2012-02-23 00:00:00 | 94 |  | May
2012-05-17 00:00:00 | 97.6 |  | Jul
2012-01-27 00:00:00 | 97.6 |  | Aug
2012-02-01 00:00:00 | 86.8 |  | Sep
2012-01-04 00:00:00 | 96.8 |  | Oct
2012-02-23 00:00:00 | 95.6 |  | Nov
2012-04-11 00:00:00 | 84.2 |  | Dec
2012-05-17 00:00:00 | 92
2012-05-23 00:00:00 | 100
2012-01-20 00:00:00 | 94
2012-03-22 00:00:00 | 77.6
2012-03-23 00:00:00 | 92.4
2012-01-27 00:00:00 | 93.6
2012-05-17 00:00:00 | 80
2012-05-17 00:00:00 | 92
2012-06-21 00:00:00 | 90.8
Spreadsheet: 86833d1286806964-pivot-calculated-fields-book1
Sheet: Budgeted vs Projected

 |  |  |  |  |  | Actual data table |  |  |  | Equivalent data table with calculated item
 |  |  |  |  |  | MOS2 | Amount | [NAME] |  | MOS2 | Amount | [NAME]
 |  |  |  |  |  | 01-Budget | 650 | 510 |  | 01-Budget | 650 | 510
 |  |  |  |  |  | PROJECTED | 200 | 511 |  | PROJECTED | 200 | 511
 |  |  |  |  |  | 01-Budget | 300 | 588 |  | 01-Budget | 300 | 588
 |  |  |  | My formula (below) is what I'd |  | PROJECTED | 400 | 510 |  | PROJECTED | 400 | 510 |  |  |  |  | Remaining (Lapse)
 |  |  |  | like to be part of my pivot table. |  | 01-Budget | 500 | 511 |  | 01-Budget | 500 | 511 |  |  |  |  |  |  |  |  | -2022
 |  |  |  |  |  | PROJECTED | 50 | 588 |  | PROJECTED | 50 | 588
 |  |  |  |  |  |  |  |  |  | Diff | 250 | 510
 |  |  |  |  |  |  |  |  |  | Diff | -300 | 511
Sum of Amount | MOS2 |  |  |  |  |  |  |  |  | Diff | 250 | 588
[NAME] | 01-Budget | PROJECTED | Diff | Grand Total
510 | 650 | 400 | 250 | 1300
511 | 500 | 200 | 300 | 1000
588 | 300 | 50 | 250 | 600
Grand Total | 1450 | 650 | 800 | 2900
Spreadsheet: 754743d1636478882-sum-duplicate-data-sumduplicate
Sheet: Sheet1

DATA |  | RESULT
A | 1 | 3
A | 1
A | 1
B | 1 | 4
B | 1
B | 1
B | 1
C | 1 | 2
C | 1
Spreadsheet: 277854d1384447693-insert-new-row-copies-foruma-one-day-doesnt-the-next-add-delete-rows-protected-sheet_locked-cells-winon_rev_1
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9 | Header 10 |  | Password for this sheet = ditto
 | 0 | 50000 | 1.27 | 1.09 | 1.03 | 0.79
43.2 | 62 | 40000 | 1.55 | 1.34 | 1.26 | 1.08 | 1 | 1.08 | 43.2
180 | 277.5 | 30000 | 1.85 | 1.6 | 1.5 | 1.2 | 5 | 1.2 | 180
 | 0 | 30000 | 2.37 | 2.04 | 1.92 | 1.69
 | 0 | 20000 | 3.05 | 2.64 | 2.48 | 2.25
537.5999999999999 | 785.28 | 16000 | 4.09 | 3.54 | 3.32 | 2.8 | 12 | 2.8 | 537.5999999999999
 | 0 | 12000 | 3.65 | 3.15 | 2.96 | 2.9
643.1999999999999 | 792 | 8000 | 4.95 | 4.27 | 4.02 | 4.02 | 20 | 4.02 | 643.1999999999999
1082.4 | 1384.8 | 8000 | 5.77 | 4.98 | 4.68 | 4.51 | 30 | 4.51 | 1082.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
Spreadsheet: 465973d1465958844-sum-numeric-values-with-different-units-list-1
Sheet: 工作表1

 | Item 1 | Item 2 | Item 3 | Item 4
Compnay 1 | 10 KG | 1 CTR | 3 PKT | 0
[NAME] | 1 CTR | 3 CTR | 1 PKT | 1 PKT
Compnay 3 | 15 KG | 1 PKT | 3 CTR | 1 PKT
[NAME] | 3 PKT | 1 CTR | 10 CTR | 10 PKT
Compnay 5 | 4 KG | 5 PKT | 0 | 0
Compnay 6 | 0 | 9 CTR | 10 KG | 0 |  |  |  |  | Today
 |  |  |  |  |  |  |  |  | Backward or Forward
Total PKT
Total CTR
Total KG
Spreadsheet: 95323d1294933484-excel-2007-adding-2-sets-of-data-to-a-single-calendar-calendar-test
Sheet: Temp pivot

Count of Temp Date
Temp Date | combined | Total
2011-01-06 00:00:00 | KRAFT-HYATT RESTAURANT {Ramiro} 173.06 | 1 | KRAFT-HYATT RESTAURANT {Ramiro} 173.06
2011-01-07 00:00:00 | Stock-Classics Lot 18 {Ramiro} 130.25 | 1 | Stock-Classics Lot 18 {Ramiro} 130.25
2011-01-11 00:00:00 | Stock-Sarita 136 {Ramiro} 130.51 | 1 | Stock-Sarita 136 {Ramiro} 130.51
2011-01-19 00:00:00 | Stock-ALDEN WOODS 3-101 {Ramiro} 77.5 | 1 | Stock-ALDEN WOODS 3-101 {Ramiro} 77.5  Stock-ALDEN WOODS 3-102 {Ramiro} 77.5  Stock-ALDEN WOODS 3-201 {Ramiro} 85.67  Stock-ALDEN WOODS 3-202 {Ramiro} 85.67
 | Stock-ALDEN WOODS 3-102 {Ramiro} 77.5 | 1 | Stock-ALDEN WOODS 3-102 {Ramiro} 77.5
 | Stock-ALDEN WOODS 3-201 {Ramiro} 85.67 | 1 | Stock-ALDEN WOODS 3-201 {Ramiro} 85.67
 | Stock-ALDEN WOODS 3-202 {Ramiro} 85.67 | 1 | Stock-ALDEN WOODS 3-202 {Ramiro} 85.67
2011-01-21 00:00:00 | Stock-CALDECOTT 13 {0} 105.15 | 1 | Stock-CALDECOTT 13 {0} 105.15
2011-01-24 00:00:00 | Stock-MARTINIQUE 1 {0} 0 | 1 | Stock-MARTINIQUE 1 {0} 0
2011-12-30 00:00:00 | Stock-Lakoya 147 {RAMIRO} 137.3 | 1 | Stock-Lakoya 147 {RAMIRO} 137.3
Spreadsheet: 82590d1282656927-printing-a-selected-area-when-sheet-is-locked-book3sample
Sheet: Helen

Form 200157 |  |  |  |  |  |  |  |  |  |  | Time brought forward
FLEXIBLE WORKING HOURS -- Time Record |  |  |  |  |  | Name |  |  |  | Debit
Week Commencing |  |  |  |  |  |  | Week Commencing
 | Mon. | [NAME]. | Wed | Thurs. | Fri. |  |  | Mon. | [NAME]. | Wed | Thurs. | Fri. |  | Weeks 1 - 4
In |  |  |  |  |  |  | In
Out |  |  |  |  |  |  | Out
In |  |  |  |  |  |  | In
Out |  |  |  |  |  |  | Out
Lunch |  |  |  |  |  |  | Lunch
Time taken off |  |  |  |  |  |  | Time taken off
Total Hours |  |  |  |  |  |  | Total Hours
Standard hr. | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 |  |  | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333
Credit. / Debit. |  |  |  |  |  |  | Credit. / Debit.
Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00 |  | Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00
Balance from previous week |  |  |  |  | 1900-01-01 00:00:00 |  | Balance from previous week |  |  |  |  | 1900-01-01 00:00:00
Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00 |  | Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00
Total hours  for week |  |  |  |  | 1900-01-01 00:00:00 |  | Total hours for week |  |  |  |  | 1900-01-01 00:00:00
Week Commencing |  |  |  |  |  |  | Week Commencing
 | Mon. | [NAME]. | Wed | Thurs. | Fri. |  |  | Mon. | [NAME]. | Wed | Thurs. | Fri.
In |  |  |  |  |  |  | In |  |  |  |  |  |  | Helen
Out |  |  |  |  |  |  | Out
In |  |  |  |  |  |  | In
Out |  |  |  |  |  |  | Out
Lunch |  |  |  |  |  |  | Lunch
Time taken off |  |  |  |  |  |  | Time taken off
Total Hours |  |  |  |  |  |  | Total Hours
Standard hr. | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 |  |  | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333
Credit. / Debit. |  |  |  |  |  |  | Credit. / Debit.
Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00 |  | Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00
Balance from previous week |  |  |  |  | 1900-01-01 00:00:00 |  | Balance from previous week |  |  |  |  | 1900-01-01 00:00:00
Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00 |  | Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00
Total hours  for week |  |  |  |  | 1900-01-01 00:00:00 |  | Total hours for week |  |  |  |  | 1900-01-01 00:00:00 |  | Next
Certified times |  |  |  |  |  |  | Checked by
Correctly recorded |  | ……… | ……………………………. |  |  |  | Supervising Officer |  | ……. | ……………………………
Spreadsheet: 34246d1231408122-vlookup-problem-1st
Sheet: Sheet1

 | Line | [NAME] | Part Number | Build Time | Build Completion | Build State | Build Qty
 | IEC108-2 | 20623137 | 905-1716-001 | 2009-01-05 06:07:00 | 2009-01-05 06:44:09 | BUILD COMPLETE | 12
 | IEC108-2 | 20623138 | 905-1716-001 | 2009-01-05 06:14:00 | 2009-01-05 06:53:48 | BUILD COMPLETE | 12
 | IEC108-2 | 20623139 | 905-1716-001 | 2009-01-05 06:21:00 | 2009-01-05 07:07:41 | BUILD COMPLETE | 12
 | IEC108-2 | 20623140 | 905-1716-001 | 2009-01-05 06:28:00 | 2009-01-05 07:14:33 | BUILD COMPLETE | 12
 | IEC108-2 | 20623141 | 905-1716-001 | 2009-01-05 06:35:00 | 2009-01-05 07:20:05 | BUILD COMPLETE | 12
 | IEC108-2 | 20623142 | 905-1716-001 | 2009-01-05 06:42:00 | 2009-01-05 07:26:00 | BUILD COMPLETE | 12
 | IEC108-2 | 20623143 | 905-1717-001 | 2009-01-05 06:49:00 | 2009-01-05 07:32:47 | BUILD COMPLETE | 12
 | IEC108-2 | 20626718 | 905-2261-001 | 2009-01-05 15:00:51 |  | PRINTED | 2
 | IEC108-3 | 20623234 | 905-1099-001 | 2009-01-05 06:07:00 | 2009-01-05 06:38:16 | BUILD COMPLETE | 10
 | IEC108-3 | 20623235 | 905-1099-001 | 2009-01-05 06:13:53 | 2009-01-05 06:56:57 | BUILD COMPLETE | 10
 | IEC108-3 | 20623236 | 905-1099-001 | 2009-01-05 06:20:46 | 2009-01-05 06:43:31 | BUILD COMPLETE | 10
 | IEC108-3 | 20623237 | 905-1099-001 | 2009-01-05 06:27:39 | 2009-01-05 06:50:02 | BUILD COMPLETE | 10
 | IEC108-3 | 20623238 | 905-1099-001 | 2009-01-05 06:34:32 | 2009-01-05 07:04:14 | BUILD COMPLETE | 10
 | IEC108-3 | 20623239 | 905-1099-001 | 2009-01-05 06:41:25 | 2009-01-05 07:09:19 | BUILD COMPLETE | 10
 | IEC108-4 | 20623369 | 905-1577-001 | 2009-01-05 06:07:00 | 2009-01-05 06:17:56 | BUILD COMPLETE | 10
 | IEC108-4 | 20623370 | 905-1577-001 | 2009-01-05 06:15:10 | 2009-01-05 06:26:05 | BUILD COMPLETE | 10
 | IEC108-4 | 20623371 | 905-1595-001 | 2009-01-05 06:23:20 | 2009-01-05 07:13:36 | BUILD COMPLETE | 10
 | IEC108-4 | 20623372 | 905-1099-001 | 2009-01-05 06:31:30 | 2009-01-05 09:30:15 | BUILD COMPLETE | 10
 | IEC108-4 | 20623373 | 905-1099-001 | 2009-01-05 06:39:40 | 2009-01-05 09:35:15 | BUILD COMPLETE | 10
 | IEC108-5 | 20623070 | 901-1038-001 | 2009-01-05 06:07:00 | 2009-01-05 07:45:44 | BUILD COMPLETE | 48
 | IEC108-5 | 20623071 | 901-1038-001 | 2009-01-05 06:32:11 | 2009-01-05 08:20:12 | BUILD COMPLETE | 48
 | IEC108-5 | 20623072 | 901-1038-001 | 2009-01-05 06:57:22 | 2009-01-05 12:26:42 | BUILD COMPLETE | 48
 | IEC108-5 | 20623073 | 901-1038-001 | 2009-01-05 07:22:33 |  | PRINTED | 48
 | IEC108-5 | 20623074 | 901-1038-001 | 2009-01-05 07:47:44 |  | PRINTED | 48
 | IEC108-5 | 20623075 | 901-1038-001 | 2009-01-05 08:22:55 |  | PRINTED | 48
 | IEC108-5 | 20623076 | 901-1038-001 | 2009-01-05 08:48:06 |  | PRINTED | 48
 | IEC108-5 | 20623077 | 901-1038-001 | 2009-01-05 09:13:17 |  | PRINTED | 48
 | IEC108-5 | 20623078 | 901-1038-001 | 2009-01-05 09:38:28 |  | PRINTED | 48
 | IEC108-5 | 20623079 | 901-1038-001 | 2009-01-05 10:03:39 |  | PRINTED | 48
 | IEC108-5 | 20623080 | 901-1047-001 | 2009-01-05 10:28:50 |  | PRINTED | 72
Spreadsheet: 713642d1610857496-calculate-material-release-bill-of-material-excel_matrelease_probsheet-ans
Sheet: Sheet1

BILL OF MATERIAL |  |  |  | [NAME] REPORT SHEET |  |  |  |  | MATERIAL RELEASE SHEET
PRODUCT | MATERIAL | CONSUMPTION |  | PRODUCT | PRODUCTION_QTY | PRODUCTION_DATE |  |  | MATERIAL | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 |  |  | MATERIAL | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00
A | MATA | 3 |  | A | 4 | 2021-01-01 00:00:00 |  |  | MATA |  |  |  |  |  | MATA | 12 | 15
A | MATB | 5 |  | A | 5 | 2021-01-02 00:00:00 |  |  | MATB |  |  |  |  |  | MATB | 20 |  | 12
A | MATC | 2 |  | B | 7 | 2021-01-02 00:00:00 |  |  | MATC |  |  |  |  |  | MATC | 8 |  | 6
A | [NAME] | 12 |  | B | 3 | 2021-01-03 00:00:00 |  |  | [NAME] |  |  |  |  |  | [NAME] | 48 | 60
B | MATB | 4
B | MATC | 2
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: S

Scott. Bruce |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 250599d1373984711-array-formula-to-extract-and-sort-unique-values-from-two-worksheets-extract-unique-values-from-2-worksheets
Sheet: DATA SOURCE TAB 1

 |  |  |  |  |  |  |  |  | JAN 1
 |  |  |  |  |  |  |  |  | FEB 2
 |  |  |  |  |  |  |  |  | MAR 3
 |  |  |  |  |  |  |  |  | APR 4
 |  |  |  |  |  |  |  |  | MAY 5
 |  |  |  |  |  |  |  |  | JUN 6
 |  |  |  |  |  |  |  |  | JUL 7
 |  |  |  |  |  |  |  |  | AUG 8
 |  |  |  |  |  |  |  |  | SEP 9
 |  |  |  |  |  |  |  |  | OCT 10
 |  |  |  |  |  |  |  |  | NOV 11
 |  |  |  |  |  |  |  |  | DEC 12
 |  |  |  |  |  |  |  |  | JAN 13
 |  |  |  |  |  |  |  |  | FEB 14
 |  |  |  |  |  |  |  |  | MAR 15
 |  |  |  |  |  |  |  |  | APR 16
 |  |  |  |  |  |  |  |  | MAY 17
 |  |  |  |  |  |  |  |  | JUN 18
 |  |  |  |  |  |  |  |  | JUL 19
 |  |  |  |  |  |  |  |  | AUG 20
 |  |  |  |  |  |  |  |  | SEP 21
 |  |  |  |  |  |  |  |  | OCT 22
 |  |  |  |  |  |  |  |  | NOV 23
 |  |  |  |  |  |  |  |  | DEC 24
 |  |  |  |  |  |  |  |  | JAN 25
 |  |  |  |  |  |  |  |  | FEB 26
 |  |  |  |  |  |  |  |  | MAR 27
 |  |  |  |  |  |  |  |  | APR 28
 |  |  |  |  |  |  |  |  | MAY 29
 |  |  |  |  |  |  |  |  | JUN 30
 |  |  |  |  |  |  |  |  | JUL 31
 |  |  |  |  |  |  |  |  | AUG 32
 |  |  |  |  |  |  |  |  | SEP 33
 |  |  |  |  |  |  |  |  | OCT 34
 |  |  |  |  |  |  |  |  | NOV 134 | <<< Also listed on [NAME]
 |  |  |  |  |  |  |  |  | DEC 36
Spreadsheet: 686418d1594614361-lookup-value-example
Sheet: Sheet1

Text | Expected Result |  |  | Lookup
Ref1 Expense Accr - Jun19 | ICT expense |  |  | Ref1 Expense | ICT expense
Manual Ref1 Expense Accr | ICT expense |  |  | Project | Project Accrual
Ref1 Expense Accr - Jul19 | ICT expense
Additional Expense Accr | ICT expense
Ref1 Expense Accr - Sep19 | ICT expense
Ref1 Expense Accr - Oct19 | ICT expense
Ref1 Expense Accr - Sep19 | ICT expense
Ref1 Expense Accr - Nov19 | ICT expense
Ref1 Expense Accr - Oct19 | ICT expense
Project Accrual - Project 1 | Project Accrual
Project Accrual - Project 2 | Project Accrual
Addition cost for project | Project Accrual
Spreadsheet: 190305d1351611258-split-data-into-3-segements-of-each-volume-and-value-book1
Sheet: Office Supplies

Account
10000148 | 825.64
10000210 | 759.7199999999999
10000262 | 77
10000319 | 375.98
10000366 | 106.44
10000476 | 0
10000920 | 891.09
10000951 | 364.13
10001204 | 126.16
10001280 | 434.66
10001893 | 156.27
10001929 | 92.49
10002021 | 73.68
10002049 | 77.39
10002368 | 610.61
10002470 | 708.24
10002546 | 99.28
10002802 | 475.46
10002872 | 28.01
10003050 | 535.61
10003102 | 294
10003986 | 237.75
10004610 | 193.62
10004650 | 416.08
10005455 | 247.63
10005561 | 0
10005981 | 144.49
10006175 | 291.42
10006543 | 638.75
10006636 | 99
10006641 | 371.57
10007522 | 271.26
10007876 | 29.99
10008025 | 315.87
10008788 | 614.1
10009835 | 170.65
10010388 | 363.79
10011099 | 541.2
10011762 | 988.3600000000001
10012616 | 112
10012637 | 0
10013377 | 165.97
10014126 | 187.92
10014216 | 28.75
10014493 | 459.92
10014908 | 502.42
10015104 | 553.6
10015125 | 338.74
10015155 | 14.22
10015266 | 251.49
10015337 | 465.27
10015518 | 620.25
10015954 | 886.44
10015956 | 546.03
10016285 | 214
10016713 | 440.8000000000001
10017542 | 239.08
10017569 | 231.99
10017670 | 213.08
10017789 | 177.87
10018256 | 147.2
10018988 | 0
10019169 | 693.32
10019616 | 795.3100000000001
10019641 | 925.15
10019886 | 42
10019995 | 522.02
10020311 | 267.3
10020401 | 0
10020508 | 787.63
10020677 | 880.5800000000002
10020866 | 763.1200000000001
10021733 | 43.98
10021979 | 206.76
10022070 | 159.96
10022193 | 0
10022196 | 88.97
10022245 | 236.49
10022524 | 245.28
10022754 | 968.17
10022893 | 30.93
10023081 | 555.2499999999999
10023158 | 949.68
10023169 | 132.2
10023175 | 707.75
10023188 | 590.1300000000001
10023189 | 894.72
10023321 | 411.86
10023361 | 297.8
10023736 | 944.08
10023773 | 284.58
10023793 | 568.2500000000001
10023795 | 271.08
10023909 | 0
10023962 | 745.63
10024178 | 253.8600000000001
10024384 | 735.5199999999999
10024571 | 442.31
10024680 | 561.3199999999999
10025241 | 396.28
10025301 | 152.02
10025479 | 467.62
10025672 | 51
10025852 | 291.47
10025937 | 0
10025982 | 318.47
10026252 | 168.37
10026365 | 133.99
10026404 | 248.64
10026743 | 507.37
10026863 | 790.33
10027048 | 55.96
10027213 | 456.34
10027309 | 554.4200000000001
10027335 | 211.57
10027580 | 659.6
10028049 | 652.53
10028253 | 257.97
10028346 | 807.4499999999999
10028379 | 0
 | 236235.1200000001
Spreadsheet: 763236d1642071747-lookup-where-there-are-approximate-matches-with-the-lookup-value-how-to-achieve-xlookup-query
Sheet: Master

Index No. | Application Name | License Model | Discovered Installs | Licenses Held |  |  |  | [NAME] | Installs
1 | [NAME] |  | 9 | 8 |  |  |  | [NAME] | 9
2 | Adobe After Effects 2021 |  | 3 | 4 |  |  |  | Adobe After Effects 2022 | 3
3 | PLSQL Developer 13 (32 bit) |  | 4 | 5 |  |  |  | PLSQL Developer 15 (32 bit) | 4
4 | Apro Banking Gateway |  | 2 | 10 |  |  |  | Apro Banking [NAME] v12 | 2
5 | Articulate 360 |  | 6 | 1 |  |  |  | Articulate Three Sixty | 6
6 | ASG-Remote Desktop 2018 |  | 17 | 20 |  |  |  | ASG-Remote Desktop 2020 | 17