tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 100495aa-6931-4b7c-a0a9-cf113bd8ebb6
Sheet: Sheet1

MONDAY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Chest | Warmup 1 | [NAME] | Warmup 3 | Working Set | Static Hold
(A)Decline BB
(B)Dips
(C)Flat DB
Shoulders | Warmup 1 | [NAME] | Warmup 3 | Working Set | Static Hold
(A)Smith Presses
(B)DB Shoulder Press
(C)HS Press
Triceps | Warmup 1 | [NAME] | Warmup 3 | Working Set(20 RP)
(A)RGBP
(B)CGBP
(C)Skull Crushers
Back Width | Warmup 1 | [NAME] | Warmup 3 | Working Set | Static Hold
(A)Assisted Pull Ups
(B)Cable Close Grip Variation
(C)Hammer/Wide Grip Pulldowns
Back Thickness | Warmup 1 | [NAME] | Warmup 3 | Heavy Set | Straight Set(12)
(A)Rack Deads
(B)Rack Deads
(C)Rack Deads
WEDNESDAY
Biceps | Warmup 1 | [NAME] | Warmup 3 | Working Set(20 RP) | Static Hold
(A)Seated DB Curls
(B)One Arm Cable Curl
(C)BB Curls
Forearms | Warmup 1 | [NAME] | Warmup 3 | Straight Set(15)
(A)Reverse Grip One Arm Cable Curl
(B)Hammer Curls
(C)Pinwheel Curls
Calves (long negatives) | Warmup 1 | [NAME] | Warmup 3 | Working Set
(A)Seated Calves
(B)Standing Calves
Hamstrings | Warmup 1 | [NAME] | Warmup 3 | Working Set (20 RP)
(A)Lying [NAME]
(B)Upright [NAME]
Quads | Warmup 1 | [NAME] | Warmup 3 | Heavy Set | Straight Set(20)
([NAME]
(B)Front Squats (heavy 4-6)
(C)Leg Press (heavy 6-10)
FRIDAY
Chest | Warmup 1 | [NAME] | Warmup 3 | Working Set | Static Hold
(A)Decline BB
(B)Dips
(C)Flat DB
Shoulders | Warmup 1 | [NAME] | Warmup 3 | Working Set | Static Hold
(A)Smith Presses
(B)DB Shoulder Press
(C)HS Press
Triceps | Warmup 1 | [NAME] | Warmup 3 | Working Set(20 RP)
(A)RGBP
(B)CGBP
(C)Skull Crushers
Back Width | Warmup 1 | [NAME] | Warmup 3 | Working Set | Static Hold
(A)Assisted Pull Ups
(B)Cable Close Grip Variation
(C)Hammer/Wide Grip Pulldowns
Back Thickness | Warmup 1 | [NAME] | Warmup 3 | Heavy Set | Straight Set(12)
(A)Rack Deads
(B)Rack Deads
(C)Rack Deads
Spreadsheet: 117df557-de35-4beb-a9bb-ee3cafe57b6e
Sheet: Tabla 20

[NAME] DEL PLAN DE ACCIÓN INTEGRADO
Tabla 20. Actividades integradas dentro y fuera del sector salud por cada resultado esperado, y productos esperados
Actividades integradas dentro y fuera del sector salud por cada resultado esperado | Producto por cada actividad
Objetivo específico 1:
Resultado esperado 1.1.
Actividad 1.1.1.
Actividad 1.1.2.
Resultado esperado 1.2.
Actividad 1.2.1
Actividad 1.2.2.
Resultado esperado 1.3.
Actividad 1.3.1.
Actividad 1.3.2.
Objetivo específico 2:
Resultado esperado 2.1.
Actividad 2.1.1.
Actividad 2.1.2
Resultado esperado 2.2.
Actividad 2.2.1.
Actividad 2.2.2.
Resultado esperado 2.3.
Actividad 2.3.1.
Actividad 2.3.2.
Objetivo específico 3:
Resultado esperado 3.1.
Actividad 3.1.1.
Actividad 3.1.2.
Resultado esperado 3.2.
Actividad 3.2.1.
Actividad 3.2.2.
Resultado esperado 3.3.
Actividad 3.3.1.
Actividad 3.3.2.
Spreadsheet: 685114d1593734407-how-to-ignore-zero-values-in-list-for-data-validation-sample_datav_new
Sheet: Sheet1

 | 2020 |  | 2019
 | From
 | formula used -> =OFFSET(B1,0,0,1,COUNTIF(FromYear,"<>"))
 | 2020 YTD | <- data validation applied to cell B9
 |  | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005
 | formula used -> =FILTER(B1:AG1,B1:AG1>2000)
 |  | <-data validation
Spreadsheet: 166932d1341847822-inormation-from-one-sheet-to-another-book2
Sheet: Summary

NOTE: Please be sure to use Military Time!
[NAME] vs. Actual
Defrost
 | Projected
Item # | # Cases | Weight
52 | 350 | 1400
56 | 350 | 2100
51 | 350 | 2800
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 1050 | 6300
Injection
Projected
Item # | # Cases | Weight
21 | 175 | 3500
54 | 140 | 1610
21 | 280 | 1078
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 595 | 6188
Grinding
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
Raw Prep
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
Rack & Cook
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
Raw Pack
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
[NAME]
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
Poly Clip
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
[NAME]
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
[NAME]
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
[NAME]
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
[NAME]
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
[NAME] vs. Actual
Slicing
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
[NAME]
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
8610 Cryovac
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
Drake/Multivac
Projected
Item # | # Cases | Weight
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Total | 0 | 0
Spreadsheet: 128569d1321050481-how-do-i-glue-cells-together-to-get-the-date-have-tried-concatenate-help1
Sheet: Sheet2

 |  | 2011 | January |  |  | 1
 |  | 2012 | February |  |  | 2
 |  | 2013 | March |  |  | 3
 |  | 2014 | April |  |  | 4
 |  | 2015 | May |  |  | 5
 |  | 2016 | June |  |  | 6
 |  | 2017 | July |  |  | 7
 |  | 2018 | August |  |  | 8
 |  | 2019 | September |  |  | 9
 |  | 2020 | October |  |  | 10
 |  |  | November |  |  | 11
 |  |  | December |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 |  |  |  |  |  | 15
 |  |  |  |  |  | 16
 |  |  |  |  |  | 17
 |  |  |  |  |  | 18
 |  |  |  |  |  | 19
 |  |  |  |  |  | 20
 |  |  |  |  |  | 21
 |  |  |  |  |  | 22
 |  |  |  |  |  | 23
 |  |  |  |  |  | 24
 |  |  |  |  |  | 25
 |  |  |  |  |  | 26
 |  |  |  |  |  | 27
 |  |  |  |  |  | 28
 |  |  |  |  |  | 29
 |  |  |  |  |  | 30
 |  |  |  |  |  | 31
Spreadsheet: 880964d1728851353-lookup-true-and-return-value-from-another-columns-based-on-descriptions-in-rows-sample-1-
Sheet: Sheet1

 | Table to populate |  |  |  |  |  |  |  | DATA
 | AA | 2024-09-16 00:00:00 |  |  |  |  |  |  | AA | BB | 9/16/2024 | 9/23/2024 | 9/30/2024 | 10/7/2024 | 10/14/2024 | 10/21/2024
 | TAPE1 |  |  |  |  |  |  |  | TAPE1 | LP1 | False | True | True | False | False | False
 | TAPE2 |  |  |  |  |  |  |  | TAPE1 | [NAME] | False | False | False | True | True | False
 | TAPE3 |  |  |  |  |  |  |  | TAPE1 | LP3 | False | False | False | False | False | True
 |  |  |  |  |  |  |  |  | TAPE2 | LP4 | True | True | False | False | False | False
 |  |  |  |  |  |  |  |  | TAPE2 | LP5 | False | False | True | True | False | False
 | Desired Result |  |  |  |  |  |  |  | TAPE2 | LP6 | False | False | False | False | True | False
 | AA | 2024-09-16 00:00:00 |  |  |  |  |  |  | TAPE3 | LP7 | False | True | False | False | False | True
 | TAPE1 |  | LP1 | LP1 | [NAME] | [NAME] | LP3 |  | [NAME] | LP8 | False | True | False | True | False | True
 | TAPE2 | LP4 | LP4 | LP5 | LP5 | LP6 |  |  | TAPE9 | LP9 | False | True | False | False | False | True
 | TAPE3 |  | LP7 |  | LP8 |  | LP9 |  | TAPE10 |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 | AA | 9/16/2024 | 9/23/2024 | 9/30/2024 | 10/7/2024 | 10/14/2024 | 10/21/2024
 | TAPE1 |  | LP1 | LP1 | [NAME] | [NAME] | LP3
 | TAPE2 | LP4 | LP4 | LP5 | LP5 | LP6
 | TAPE3 |  | LP7 |  |  |  | LP7
 | [NAME] |  | LP8 |  | LP8 |  | LP8
 | TAPE9 |  | LP9 |  |  |  | LP9
Spreadsheet: 112298d1308464951-index-match-across-multiple-sheets-using-multiple-criteria-index-match-across-multiple-sheets-using-multiple-criteria
Sheet: Dept1

 |  | Enter the Year ► | 2011
 |  | Department Name ► | Dept1
 | Campaign 1 |  |  |  |  | Campaign 2
Row # | Week | Task | Responsible |  | Row # | Week | Task | Responsible
Spreadsheet: 286659d1388417550-copying-row-to-other-worksheet-if-cell-has-specific-data-rt-tracking-sheet-sample
Sheet: Sheet2

Date | LOC Code | CO Code | How | ? | Purchase Order # | Invoice # | SM#              Job # | SP | Claim Amount |  | Vendor Paid
41568 | FX | CF |  | PD | 163543 | 1656520 | 83394 | NR | 653.77 |  | 653.77
Spreadsheet: 683819d1592968939-conditional-remove-duplicates-based-on-another-column-in-power-query-related-to-power-bi-example-of-cleaned-data
Sheet: Sheet3

ID | JobPositionCode | AwardCode | AwardLevelCode | JobPositionCategoryCode | JobPositionActiveFlag | Surname | Preferred | FTE | CurrentJobPositionFlag | FutureJobPositionFlag | JobStartDate
5000 | PRINCIPAL | TEACHING | LEADERSHIP | TEACHER | True | Wilson | Rebel | 1 | True | False | 43432
6111 | TEACHER | TEACHING | COACH | TEACHER | True | Blanchett | Cate | 0.63 | True | False | 42460
6111 | ES | LEARNING DIVERSITY |  | LEARNING ENHANCEMENT | True | Blanchett | Cate | 0.17 | True | False | 42460
25000 | TEACHER | TEACHING | HEAD OF HOUSE | TEACHER | True | Jackman | Hugh | 1 | True | False | 43843
6000 | ES | FINANCE |  | PAYROLL OFFICER | True | Weaver | [NAME] | 1 | True | False | 40179
6000 | ES | FINANCE | LSL | PAYROLL OFFICER | True | Weaver | [NAME] | 0 | True | False | 40179
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Power Volume Management

Power Volume Management |  | ok
[NAME] | [NAME] | 1
[NAME] | Director | 1
[NAME] | Spec
[NAME] | Spec
Marci Mansfield | Spec | 3
[NAME] | Sr. Spec | 1
[NAME] | Staff
[NAME] | Staff | 2
[NAME] |  |  | 12500
ScottieGilbert |  |  | 35000
[NAME] |  |  | 12500
[NAME], [NAME] |  |  | 12500
Thompson , [NAME] |  |  | 12500
 |  | 8
 |  | 13
Spreadsheet: 96944d1296172419-excel-2007-how-to-automatically-populate-data-test1
Sheet: Sheet1

Date | Category | Amount
2010-02-16 00:00:00 | Account Expense (paid) | -64.49
2010-02-16 00:00:00 | Account Expense (paid) | -56.41
2010-02-18 00:00:00 | Capital Call | 551000
2010-02-19 00:00:00 | Acquisitions | -550000
2010-03-12 00:00:00 | Capital Call | 670000
2010-03-12 00:00:00 | Acquisitions | -245000
2010-03-12 00:00:00 | Account Expense (paid) | -20000
2010-03-15 00:00:00 | Account Expense (paid) | -74.96
2010-03-16 00:00:00 | Acquisitions | -400000
2010-03-18 00:00:00 | Capital Call | 158000
2010-03-19 00:00:00 | Premiums | -118000
2010-03-19 00:00:00 | Account Expense (paid) | -40000
Spreadsheet: 3c764292-2395-45a0-9ea8-e84d4e1ff538
Sheet: Sheet1

ACTIVITEITENKALENDER 2012 | Unnamed: 1
Zondag 8 januari | [NAME] tot 17u00
 | [NAME]
 | (uitzonderlijk 2de zondag [NAME])
Zondag 5 februari | [NAME] tot 17u00
 | Valentijnshopping
Zondag 4 maart | [NAME] tot 17u00
 | [NAME]
Zondag 18 maart | Made in Limburg dag
Zondag 1 april | [NAME] tot 17u00
 | Culinair Shoppen
Dinsdag 1 mei | [NAME]
Zondag 6 mei | [NAME] tot 17u00
Vrijdag 11 mei | Openingsfeest Grote Markt
Zaterdag 12 mei | en omgeving
Zondag 13 mei
Woensdag 16 mei | Avondmarkt
 | [NAME] tot 22u00
 | (ter vervanging [NAME])
Zondag 3 juni | [NAME] tot 17u00
 | Straattheaterfestival
Zaterdag 23 juni | Kraampjesverkoop
 | [NAME] tot 18u00
Dinsdag 26 juni | 4 dolle dagen
Woensdag 27 juni | 4 dolle dagen
Donderdag 28 juni | 4 dolle dagen
Vrijdag 29 juni | 4 dolle dagen
Zaterdag 30 juni | [NAME]
Zondag 1 juli | [NAME] tot 17u00
 | Stadsmuzikantenfestival
Zondag 5 augustus | [NAME] tot 17u00
 | Festival 'Bier Anders'
Zondag 12 augustus | [NAME] tot 18u00
 | op het Begijnhof
Zondag 2 september | [NAME] tot 17u00
 | Ambiorixfeesten
Donderdag 13 september | Jaarmarkt van 8u00 tot 13u00
[NAME] 15 september | [NAME] tot 18u00
[NAME] 15 september | [NAME] tot 18u00
[NAME] 22 september | [NAME]
 | nagevraagd
Zondag 7 oktober | [NAME] tot 17u00
 | Modepromenade
Zondag 4 november | [NAME] tot 17u00
 | [NAME]
Zondag 2 december | Koopzondag
 | Eindejaarsshoppen
Zondag 9 december | [NAME] tot 17u00
 | Eindejaarsshoppen
Zondag 16 december | [NAME] tot 17u00
Zondag 23 december | [NAME] tot 17u00
 | Eindejaarsshoppen
Spreadsheet: 65142d1265872183-mixing-date-in-one-column-concatif-temp_avk
Sheet: Sheet1

 |  |  | code | abc | bcd | cde | visit date in may | visit date in june | visit date in july | visit date in aug | visit date in sept | visit date in oct | visit date in nov
 | 604117 | NW | INX1024399
 | 604118 | NW | INX1024398 |  |  |  |  |  |  |  |  |  | 13.11.08
 | 604119 | NW | INX1024397 |  |  |  |  |  |  |  |  |  | 15.11.08
 | 604117 | NW | INX1024399 |  |  |  |  |  |  |  |  |  | 20.11.08
 | 604118 | NW | INX1024398 |  |  |  |  |  |  |  |  |  | 21.11.08
 | 604119 | NW | INX1024397 |  |  |  |  |  |  |  |  |  | 22.11.08
 | 604117 | NW | INX1024399 |  |  |  |  |  |  |  |  |  | 20.11.09
 | 604118 | NW | INX1024398 |  |  |  |  |  |  |  |  |  | 21.11.09
 | 604119 | NW | INX1024397 |  |  |  |  |  |  |  |  |  | 22.11.09
Spreadsheet: robin_rodrigue__33242__YTD Recon
Sheet: Aug 00

 | 2000-08-01 00:00:00 |  | 2000-08-02 00:00:00 |  | 2000-08-03 00:00:00 |  | 2000-08-04 00:00:00 |  | 2000-08-07 00:00:00 |  | 2000-08-08 00:00:00 |  | 2000-08-09 00:00:00 |  | 2000-08-10 00:00:00 |  | 2000-08-11 00:00:00 |  | 2000-08-14 00:00:00 |  | 2000-08-15 00:00:00 |  | 2000-08-16 00:00:00 |  | 2000-08-17 00:00:00 |  | 2000-08-18 00:00:00 |  | 2000-08-21 00:00:00 |  | 2000-08-22 00:00:00 |  | 2000-08-23 00:00:00 |  | 2000-08-24 00:00:00 |  | 2000-08-25 00:00:00 |  | 2000-08-28 00:00:00 |  | 2000-08-29 00:00:00 |  | 2000-08-30 00:00:00 |  | 2000-08-31 00:00:00 |  | MTD |  | YTD |  | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (as of 7/31) |  | (as of 8/31)
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54162933
South |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2404073
Tholt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4797129
Lenhart |  |  |  |  |  |  |  |  |  |  |  |  | -3734 |  | 19418 |  |  |  | -7831 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140870
Kuykendall |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 534744
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this is last day numbers
Spreadsheet: 869801d1716364546-find-the-time-period-a-customer-returns-test-customer-aligw-1-
Sheet: Sheet1

 |  |  |  | Customer |  | Date |  |  | formula | What it should be
 |  |  |  | 6 |  | 2024-03-20 00:00:00 |  | 0 - 1 month |  | 5
 |  |  |  | 11 |  | 2024-01-01 00:00:00 |  | 1- 3 month | 1 | 2
 |  |  |  | 11 |  | 2024-01-09 00:00:00 |  | 3 - 6 month | 1 | 0
 |  |  |  | 11 |  | 2024-01-23 00:00:00 |  | 6 - 12 month | 0 | 1
 |  |  |  | 11 |  | 2024-02-02 00:00:00 |  | 12 - 24 month | 0 | 0
 |  |  |  | 11 |  | 2024-04-03 00:00:00 |  | 24+ | 0 | 0
 |  |  |  | 11 |  | 2024-04-22 00:00:00
 |  |  |  | 22 |  | 2024-03-03 00:00:00
 |  |  |  | 22 |  | 2024-05-11 00:00:00
 |  |  |  | 33 |  | 2024-06-22 00:00:00
 |  |  |  | 44 |  | 2024-02-12 00:00:00
 |  |  |  | 55 |  | 2024-02-22 00:00:00
 |  |  |  | 55 |  | 2024-03-03 00:00:00
 |  |  |  | 55 |  | 2024-10-09 00:00:00
Spreadsheet: 874058d1720625109-loookup-and-copy-based-on-matching-report
Sheet: Sheet1

Asset IP Address | Server Name
30.55.18.145 | Server1
30.55.18.15 | Server2
30.55.18.183 | Server3
30.55.18.207 | Server4
30.55.18.212 | Server5
30.55.2.148 | Server6
30.55.30.11 | Server7
30.55.30.238 | Server8
30.55.31.132 | Server9
30.55.31.178 | Server10
30.55.32.28 | Server11
30.55.35.63 | Server12
30.55.35.64 | Server13
30.55.36.169 | Server14
30.55.36.36 | Server15
30.55.6.225 | Server16
30.55.90.10 | Server17
30.55.90.23 | Server18
30.55.90.238 | Server19
30.55.90.247 | Server20
30.55.91.10 | Server21
30.55.92.103 | Server22
30.55.92.110 | Server23
30.55.92.111 | Server24
30.55.92.126 | Server25
30.55.92.167 | Server26
30.55.92.171 | Server27
30.55.92.177 | Server28
30.55.92.189 | Server29
30.55.92.232 | Server30
30.55.92.46 | Server31
30.55.92.55 | Server32
30.55.92.67 | Server33
30.55.92.82 | Server34
30.55.92.99 | Server35
30.55.93.126 | Server36
30.55.93.13 | Server37
30.55.93.130 | Server38
30.55.93.14 | Server39
30.55.93.152 | Server40
30.55.93.177 | Server41
30.55.93.180 | Server42
30.55.93.186 | Server43
30.55.93.19 | Server44
30.55.93.210 | Server45
30.55.93.241 | Server46
30.55.93.248 | Server47
30.55.93.253 | Server48
30.55.93.27 | Server49
30.55.93.29 | Server50
30.55.93.5 | Server51
30.55.93.59 | Server52
30.55.93.60 | Server53
30.55.93.64 | Server54
30.55.93.68 | Server55
30.50.12.220 | Server56
30.50.15.70 | Server57
30.50.61.18 | Server58
30.50.62.211 | Server59
30.50.62.226 | Server60
30.50.62.77 | Server61
30.50.63.16 | Server62
30.50.63.248 | Server63
30.55.18.219 | Server64
30.55.92.177 | Server65
30.55.93.245 | Server66
30.55.5.17 | Server67
30.55.92.83 | Server68
30.55.93.126 | Server69
30.55.93.185 | Server70
30.55.92.88 | Server71
30.55.93.234 | Server72
30.55.93.24 | Server73
30.55.35.146 | Server74
30.55.35.142 | Server75
Spreadsheet: 28419d1222692748-macro-needed-to-help-attach-data-example
Sheet: Sheet2

Name | Distribution | Team | Desk | Lap | Blackberry
Bncos |  |  | y
Htowes |  |  |  | y
Jfive
Jkow
[NAME] |  |  |  |  | y
Lbean
[NAME] |  |  | y
Mpeople |  |  |  | y
Nmcall |  |  |  |  | y
Pchorely
Psmith |  |  |  |  | y
[NAME]
Twerp |  |  |  | y
Jlow |  |  | y
Hfive
Sand |  |  |  |  | y
Psiper
Prock |  |  | y | y
[NAME] | Systems | 351 Sup | y | y | y
Scloth |  |  | y | y | y
Ftemple |  |  |  |  | y
Fgiblet |  |  |  |  | y
Spreadsheet: 688479d1595809113-adding-all-purchases-from-a-custom-date-range-from-a-purchase-journal-pj-finbar-sample
Sheet: Sheet3

2020 FISCAL DATES
PERIOD | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6
1 | 1/1-1/5 | 1/6-1/12 | 1/13-1/19 | 1/20-1/26 | 1/27-1/31
2 | 2/1-1/2 | 2/3-2/9 | 2/10-2/16 | 2/17-2/23 | 2/24-2/29
3 | 3/1-3-1 | 3/2-3/8 | 3/9-3/15 | 3/16-3/22 | 3/23-3/29 | 3/30-3/31 |  |  |  | 2020-07-01 00:00:00 | 2020-07-05 00:00:00
4 | 4/1-4/5 | 4/6-4/12 | 4/13-4-19 | 4/20-4/26 | 4/27-4/30
5 | 5/1-5/3 | 5/4-5/10 | 5/11-5/17 | 5/18-5/24 | 5/25-5/31
6 | 6/1-6/7 | 6/8-6/14 | 6/15-6/21 | 6/22-6/28 | 6/29-6/30
7 | 7/1-7/5 | 7/6-7/12 | 7/13-7/19 | 7/20-7/26 | 7/27-7/31
8 | 8/1-8/2 | 8/3-8/9 | 8/10-8/16 | 8/17-8/23 | 8/24-8/30 | 8/31-8/31
9 | 9/1-9/6 | 9/7-9/13 | 9/14-9/20 | 9/21-9/27 | 9/28-9/30
10 | 10/1-10/4 | 10/5-10/11 | 10/12-10/18 | 10/19-10/25 | 10/26-10/31
11 | 11/1-11/1 | 11/2-11/8 | 11/9-11/15 | 11/16-11/22 | 11/23-11/29 | 11/30-11/30
12 | 12/1-12/6 | 12/7-12/13 | 12/14-12/20 | 12/21-12/27 | 12-28-12/31
2020 SALES
PERIOD | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | PERIOD TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
 |  |  |  |  |  |  | YEAR TOTAL
2020 PURCHASES
PERIOD | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | PERIOD TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
 |  |  |  |  |  |  | YEAR TOTAL
Spreadsheet: 756783d1637772646-excel-formula-to-find-a-last-filled-cell-in-a-table-row-expenditures_fixed_charges-bo_rys-code-modified-keebellah-
Sheet: VASTE_LASTEN

 |  |  |  |  |  |  |  |  |  |  | Total table column count:
 |  |  |  |  |  |  |  |  |  |  | Table column based on Today's  date: |  | 2019-12-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-25 00:00:00 | 2021-07-01 00:00:00 | 2021-10-29 00:00:00 | 2021-11-01 00:00:00 | 2021-11-20 00:00:00 | 2022-01-01 00:00:00
 | Soort Lasten | Omschrijving | P | Bedrag | Verschil | [NAME] |  |  |  |  | Omschrijving | P | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9
 | Cumul 0001 |  |  |  |  |  |  |  |  |  | Post 1 | 1 | 861.37 | 885.5 | 892.38 |  |  |  | 895 | 700
 | Cumul 0001 |  |  |  |  |  |  |  |  |  | Post 2 | 1 | 999.99 |  |  | 174 |  | 200
 | Cumul 0002 |  |  |  |  |  |  |  |  |  | Post 3 | 1 | 249.55 | 270.32 | 284.13
 | Cumul 0002 |  |  |  |  |  |  |  |  |  | Post 4 | 1 | 124.88 | 131.2 | 131.2 |  | 133.43
 | Cumul 0003 |  |  |  |  |  |  |  |  |  | Post 5 | 1 | 36.65 |  | 37.9 |  | 38.9
 | Cumul 0003 |  |  |  |  |  |  |  |  |  | Post 6 | 1 | 56 | 58.5 | 59.5 |  | 60.5
 | Cumul 0003 |  |  |  |  |  |  |  |  |  | Post 7 | 1 | 13.5 | 13.78 | 15
 | Cumul 0003 |  |  |  |  |  |  |  |  |  | Post 8 | 1 | 13.5 | 13.78 | 15.47
 | Cumul 0003 |  |  |  |  |  |  |  |  |  | Post 9 | 1 |  | 18.5
 | Cumul 0003 |  |  |  |  |  |  |  |  |  | Post 10 | 1 |  | 15.95
 | Cumul 0004 |  |  |  |  |  |  |  |  |  | Post 11 | 1 | 13.75 | 14 | 14.25
 | Cumul 0004 |  |  |  |  |  |  |  |  |  | Post 12 | 1 | 13.75 | 14 | 14.25
 | Cumul 0004 |  |  |  |  |  |  |  |  |  | Post 13 | 1 | 13.75 | 14 | 14.25
 | Cumul 0005 |  |  |  |  |  |  |  |  |  | Post 14 | 1 | 200
 | Cumul 0006 |  |  |  |  |  |  |  |  |  | Post 15 | 1 |  | 4.35
 | Cumul 0006 |  |  |  |  |  |  |  |  |  | Post 16 | 1 |  | 4.35
 | Cumul 0006 |  |  |  |  |  |  |  |  |  | Post 17 | 1
 | Cumul 0007 |  |  |  |  |  |  |  |  |  | Post 18 | 2 |  | 180
 | Cumul 0007 |  |  |  |  |  |  |  |  |  | Post 19 | 2 |  | 81
 | Total |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 143220d1330304998-problems-with-pivot-table-sales-summary-test
Sheet: Pivot

Channel | (All)
 | Values
Row Labels | Units Sold | $ Sales | $ GM | % GMN | Margin | [NAME]
Medium screw | 360 | 402.45 | 284.85 | 0.7077897875512486
Product B | 360 | 402.45 | 284.85 | 0.7077897875512486
Small screw | 335 | 427.35 | 240.81 | 0.5634959634959634
Product A | 290 | 397.2 | 225.96 | 0.568882175226586
Product B | 45 | 30.15 | 14.85 | 0.4925373134328359
Large Screw | 567 | 90.61 | 37.22 | 0.4107714380311224
Product C | 567 | 90.61 | 37.22 | 0.4107714380311224
Grand Total | 1262 | 920.4100000000001 | 562.8800000000001 | 0.611553546788931
 | * How do I insert a calculated field to show the cumulative margin, as a % of total margin?
 | * In trying to use a helper column, I can't get the cell formula in column F to pick up the value in column D. Even removing absolute cell references does not help
Spreadsheet: 875581d1722188877-how-to-make-index-work-after-drag-solved-test
Sheet: март

№ | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | ORANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEAR