tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: matthew_lenhart__26364__West Prices0601-01
Sheet: Power West Price Peak

 |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
Price change |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
 |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0 | 0 | 0 | 0 | 200 | 253 | 300 | 200 | 166.6666666666667 | 207.5714285714286 | 128.3333333333333 | 56.66666666666666 | 120 | 51.66666666666666 | 89.16666666666667 | 51.91666666666666 | 45.51583333333334 | 38.07036666666667 | 26.48443333333334 | 70.8633333333333 | 34.1511 | 42.39230833333339
COB | 0 | 0 | 0 | 0 | 200 | 260 | 300 | 195 | 170 | 209.2857142857143 | 121.6666666666667 | 57 | 138.3333333333333 | 53.66666666666666 | 92.66666666666667 | 54.25 | 45.9325 | 33.46916666666667 | 30.57416666666666 | 67.25 | 38.57416666666665 | 42.466875
NP15 | 0 | 0 | 0 | 0 | 215 | 245 | 285 | 180 | 107 | 178 | 80 | 49 | 105 | 39 | 68.25 | 39.75 | 37.25 | 30.79333333333334 | 32.04666666666665 | 61.805 | 31.04666666666665 | 38.92291666666674
ZP26 | 0 | 0 | 0 | 0 | 205 | 245 | 285 | 175 | 101.3333333333333 | 173.4285714285714 | 88 | 74 | 120.3333333333333 | 47 | 82.33333333333333 | 39.5 | 37.08333333333334 | 30.38833333333334 | 32.02703013170774 | 60.18730470309485 | 30.93535911917075 | 38.38450682182672
SP15 | 0 | 0 | 0 | 0 | 205 | 250 | 285 | 175 | 102 | 174.4285714285714 | 61 | 53 | 115 | 37 | 66.5 | 43.16666666666666 | 39.83333333333334 | 31.59217116379136 | 34.49109582551636 | 64.44363578113366 | 32.12011845633126 | 40.66175530669319
Palo Verde | 0 | 0 | 0 | 0 | 240 | 290 | 330 | 185 | 108.3333333333333 | 195.7142857142857 | 60 | 57 | 145 | 35 | 74.25 | 40.22550064453224 | 37.25199578767897 | 35.66641968558074 | 35.22327412548415 | 58.07405980078455 | 30.05130470060531 | 39.75376457811369
ROCKIES | 0 | 0 | 0 | 0 | 240 | 290 | 330 | 185 | 108.3333333333333 | 195.7142857142857 | 60 | 57 | 145 | 35 | 74.25 | 40.22550064453224 | 37.25199578767897 | 35.66641968558074 | 35.22327412548415 | 58.07405980078455 | 30.05130470060531 | 39.75376457811369
Spreadsheet: 4e7dac4d-971e-4afb-aa21-757051804480
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Cuadro 4.4-07
[NAME]
Desempleo1 por [NAME], según año 2003-2011
[NAME] | Total Desempleo | Agricultura, ganaderia, caza y silvicultura | Explotación de minas y canteras | Industrias manufactureras | [NAME], gas y agua | [NAME] | [NAME] por mayor y menor; [NAME], motocicletas, efectos personales y enseres domésticos | Hoteles y restaurantes | Transporte, almacenamiento y comunicaciones | Intermediación financiera | [NAME] pública y defensa; planes de seguridad social de afiliación obligatoria | Otros Servicios | Poblacion sin Rama de Actividad.
2003 | 633233 | 14892 | 373 | 100186 | 2270 | 27817 | 75904 | 35731 | 16012 | 9343 | 10750 | 101756 | 238199
2004 | 723728.5 | 11004 | 1068.5 | 84357.5 | 3355.5 | 22539.5 | 67409.5 | 36235.5 | 16810.5 | 9277 | 19645 | 119368 | 332658
2005 | 715837 | 11181.5 | 1086.5 | 91788.5 | 4636.5 | 25989 | 68191 | 38252.5 | 12792.5 | 10226.5 | 20536.5 | 130053 | 300725
2006 | 665346 | 10808.5 | 259.5 | 76657.5 | 3961.5 | 21861 | 61187.5 | 37256.5 | 13148 | 6848.5 | 10480 | 110085 | 312518
2007 | 653972 | 10449.5 | 36.5 | 70493.5 | 4216 | 16345.5 | 60391 | 34017 | 13114.5 | 6791 | 13957 | 106749 | 317105
2008 | 602501 | 9304 | 335 | 58591 | 1336 | 10691 | 57891 | 15871 | 13724 | 5346 | 11598 | 80310 | 337504
2009 | 627895 | 11644 | 663 | 67028 | 3590 | 16076 | 61616 | 30360 | 15091 | 4643 | 11601 | 96264 | 309319
2010 | 625337 | 9431 | 235 | 61617 | 3114 | 18633 | 63869 | 34154 | 11598 | 7798 | 7798 | 95808 | 311282
2011 | 668408 | 12157 | 241 | 69380 | 2334 | 24658 | 76253 | 34049 | 15554 | 12703 | 65425 | 54831 | 300823
(1):   Desempleo son [NAME] años o más que no laboraron durante [NAME] anterior a la ENFT pero que estaban dispuestas a trabajar
Nota:   [NAME] clasificación utilizada está de acuerdo a la  "Clasificación  Internacional  Uniforme  de  Actidades  (CIIU) Rev.3 "
Fuente:   Encuesta Nacional de Fuerza de Trabajo (ENFT). Banco Central de la República Dominicana
Spreadsheet: 773680d1647993565-setting-up-formula-a-to-check-a-or-tol-between-columns-and-print-a-custom-text-result-example
Sheet: ExcelCertAttachmentforTPgtxAmo

Equipment | As Found | Line Number | Description | Standard | Tolerance - Neg | Tolerance - Pos | As Left | UOM | Result | Precision | Deviation | [NAME] | Limited | Result | Uncertaintity | Unc. Uom
 | 0.77 | 1 |  | 0.77 | -0.7699 | 0.7701 | 0.7701 | inch - In | In Tolerance | 5
 | 0.79 | 2 |  | 0.79 | -0.7899 | 0.7901 | 0.7901 | inch - In |  | 5
 | 0.8 | 3 |  | 0.8 | -0.7999 | 0.8001 | 0.8001 | inch - In | In Tolerance | 5
 | 0.82 | 4 |  | 0.82 | -0.8199 | 0.8201 | 0.82 | inch - In | In Tolerance | 5
 | 0.85 | 5 |  | 0.85 | -0.8499 | 0.8501 | 0.8498 | inch - In | Fail | 5
 | 0.87 | 6 |  | 0.87 | -0.8699 | 0.8701 | 0.8699 | inch - In | In Tolerance | 5
Spreadsheet: 85860d1285875059-mapping-and-sorting-and-laziness-book1
Sheet: Mapping

Mapping | Customer X | Customer Q | [NAME], LTD | Customer 4 | Customer JJ | Catalyst 17 | Customer 7 | The Gape | Number 9 | Customer Z | QUEST INDUSTRIES | ABC Co
Apples | X | X | X | X | X | X | X | X | X | X | X | X
Oranges | X |  |  |  |  |  |  | X |  | X | X | X
Orangutans | X |  |  |  | X | X | X |  | X | X | X | X
Bananas | X | X |  |  |  |  |  |  |  | X | X | X
Skirts | X |  |  |  |  |  |  |  |  | X | X | X
Herring Bone Armor Plated Vehicles | X |  |  |  |  |  |  |  |  | X | X | X
Fiddlesticks | X |  |  | X |  |  |  |  | X |  | X | X
Hands Free Head Sets (Type 1) | X |  |  |  |  |  |  |  |  | X |  | X
Empty Shoe Boxen | X |  |  |  |  |  |  |  |  | X |  | X
[NAME] of Law & Order: SVU Season 7 | X |  |  |  |  | X |  | X |  | X | X
[NAME] of the Apocalypse | X |  |  | X |  | X |  |  |  | X | X | X
Hands Free Head Sets (Type 2) | X |  |  |  |  | X | X |  |  | X | X | X
[NAME] the Red's Finger Nail Clipping | X |  |  |  |  |  | X | X |  | X | X | X
Spreadsheet: 44009d1242679850-solver-solverproblem
Sheet: Sheet1

Stock |  | Business | College | Home | Total Available
 | 15 inc | 0 | 0 | 1 | 9999999999
 | 19 inc | 1 | 0 | 0 | 38
 | 17 inc | 0 | 1 | 0 | 45
 | 60 GB | 1 | 1 | 0 | 30
 | 30GB | 0 | 0 | 1 | 40
 | DVD | 1 | 0 | 0 | 35
 | CD | 0 | 1 | 1 | 45
Contribution per unit |  | 85 | 65 | 70
MODEL
No of Business |  | 30.00000000006526
No of College |  | 0
No of Home |  | 40.00000000000429
Total Contribution |  | 0
 |  | Used | Available
Constraints
15 inc |  | 40.00000000000429 | 9999999999
19 inc |  | 30.00000000006526 | 38
17 inc |  | 0 | 45
60 GB |  | 30.00000000006526 | 30
30GB |  | 40.00000000000429 | 40
DVD |  | 30.00000000006526 | 35
CD |  | 40.00000000000429 | 45
Spreadsheet: 137072d1326936812-indirect-function-copy-of-qa-tracking-sheet
Sheet: Pal

Date | Converted by |  | Error | [NAME] |  | Date | Count
2012-01-18 00:00:00 | Abu | 401-5487 | perfect |  | Abuperfect | 2012-01-01 00:00:00 | 0
2012-01-18 00:00:00 | Tamar | 210-5487 |  |  | Tamar | 2012-01-02 00:00:00 | 0
 |  |  |  |  |  | 2012-01-03 00:00:00 | 0
 |  |  |  |  |  | 2012-01-04 00:00:00 | 0
 |  |  |  |  |  | 2012-01-05 00:00:00 | 0
 |  |  |  |  |  | 2012-01-06 00:00:00 | 0
 |  |  |  |  |  | 2012-01-07 00:00:00 | 0
 |  |  |  |  |  | 2012-01-08 00:00:00 | 0
 |  |  |  |  |  | 2012-01-09 00:00:00 | 0
 |  |  |  |  |  | 2012-01-10 00:00:00 | 0
 |  |  |  |  |  | 2012-01-11 00:00:00 | 0
 |  |  |  |  |  | 2012-01-12 00:00:00 | 0
 |  |  |  |  |  | 2012-01-13 00:00:00 | 0
 |  |  |  |  |  | 2012-01-14 00:00:00 | 0
 |  |  |  |  |  | 2012-01-15 00:00:00 | 0
 |  |  |  |  |  | 2012-01-16 00:00:00 | 0
 |  |  |  |  |  | 2012-01-17 00:00:00 | 0
 |  |  |  |  |  | 2012-01-18 00:00:00 | 2
 |  |  |  |  |  | 2012-01-19 00:00:00 | 0
 |  |  |  |  |  | 2012-01-20 00:00:00 | 0
 |  |  |  |  |  | 2012-01-21 00:00:00 | 0
 |  |  |  |  |  | 2012-01-22 00:00:00 | 0
 |  |  |  |  |  | 2012-01-23 00:00:00 | 0
 |  |  |  |  |  | 2012-01-24 00:00:00 | 0
 |  |  |  |  |  | 2012-01-25 00:00:00 | 0
 |  |  |  |  |  | 2012-01-26 00:00:00 | 0
 |  |  |  |  |  | 2012-01-27 00:00:00 | 0
 |  |  |  |  |  | 2012-01-28 00:00:00 | 0
 |  |  |  |  |  | 2012-01-29 00:00:00 | 0
 |  |  |  |  |  | 2012-01-30 00:00:00 | 0
 |  |  |  |  |  | 2012-01-31 00:00:00 | 0
Spreadsheet: 26736d1219151085-only-print-select-certain-rows-book1
Sheet: Sheet1

2008-09-20 00:00:00 | 1
2008-09-21 00:00:00 | 2
2008-09-22 00:00:00 | 3
2008-09-23 00:00:00 | 4
2008-09-24 00:00:00 | 5
2008-09-25 00:00:00 | 6
2008-09-26 00:00:00 | 7
2008-09-27 00:00:00 | 8
2008-09-28 00:00:00 | 9
2008-09-29 00:00:00 | 10
2008-09-30 00:00:00 | 11
2008-10-01 00:00:00 | 12
2008-10-02 00:00:00 | 13
2008-10-03 00:00:00 | 14
2008-10-04 00:00:00 | 15
2008-10-05 00:00:00 | 16
2008-10-06 00:00:00 | 17
2008-10-07 00:00:00 | 18
2008-10-08 00:00:00 | 19
2008-10-09 00:00:00 | 20
2008-10-10 00:00:00 | 21
2008-10-11 00:00:00 | 22
2008-10-12 00:00:00 | 23
2008-10-13 00:00:00 | 24
2008-10-14 00:00:00 | 25
2008-10-15 00:00:00 | 26
2008-10-16 00:00:00 | 27
2008-10-17 00:00:00 | 28
2008-10-18 00:00:00 | 29
2008-10-19 00:00:00 | 30
2008-10-20 00:00:00 | 31
2008-10-21 00:00:00 | 32
2008-10-22 00:00:00 | 33
2008-10-23 00:00:00 | 34
2008-10-24 00:00:00 | 35
2008-10-25 00:00:00 | 36
2008-10-26 00:00:00 | 37
2008-10-27 00:00:00 | 38
2008-10-28 00:00:00 | 39
2008-10-29 00:00:00 | 40
2008-10-30 00:00:00 | 41
2008-10-31 00:00:00 | 42
2008-11-01 00:00:00 | 43
2008-11-02 00:00:00 | 44
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 11b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | <100 | 160 | <100 | 690 | 850
FRA | 3896 | 2116 | <100 | 3894 | 9906
IRS- [NAME] | 8871 | 1676 | 1646 | 7026 | 19219
OIS | 1144 | 232 |  | 228 | 1604
VNS | <100 |  |  |  | <100
Zero Coupon | <100 | <100 |  | <100 | <100
TOTAL | 13911 | 4184 | 1646 | 11838 | 31579
Estimated swap transaction volumes, week ending November 9, by product type and supermajor currency (in number of transactions), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for supermajor currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 737701d1624548970-find-if-text-in-col-on-a-particular-date-has-already-appeared-in-above-rows-on-same-date-symbolon-date
Sheet: Sheet2

DATE |  | SYMBOL |  |  |  | 1st Time Symbol Appears on Date?
2021-05-16 00:00:00 |  | ETH |  |  |  | 1
2021-05-16 00:00:00 |  | NMR |  |  |  | 1
2021-05-16 00:00:00 |  | IOTA |  |  |  | 1
2021-05-16 00:00:00 |  | ETH |  |  |  | 0
2021-05-16 00:00:00 |  | ETH |  |  |  | 0
2021-05-16 00:00:00 |  | IOTA |  |  |  | 0
2021-05-16 00:00:00 |  | IOTA |  |  |  | 0
2021-05-16 00:00:00 |  | NMR |  |  |  | 0
2021-05-16 00:00:00 |  | NMR |  |  |  | 0
2021-05-16 00:00:00 |  | NMR |  |  |  | 0
2021-05-16 00:00:00 |  | XVG |  |  |  | 1
2021-05-16 00:00:00 |  | ETH |  |  |  | 0
2021-05-16 00:00:00 |  | NMR |  |  |  | 0
2021-05-16 00:00:00 |  | NMR |  |  |  | 0
2021-05-17 00:00:00 |  | CELO |  |  |  | 1
2021-05-17 00:00:00 |  | ETH |  |  |  | 1
2021-05-17 00:00:00 |  | NEO |  |  |  | 1
2021-05-17 00:00:00 |  | ETH |  |  |  | 0
2021-05-17 00:00:00 |  | CELO |  |  |  | 0
2021-05-17 00:00:00 |  | CELO |  |  |  | 0
2021-05-17 00:00:00 |  | CELO |  |  |  | 0
2021-05-17 00:00:00 |  | CELO |  |  |  | 0
2021-05-17 00:00:00 |  | ETH |  |  |  | 0
2021-05-17 00:00:00 |  | ETH |  |  |  | 0
2021-05-17 00:00:00 |  | SNX |  |  |  | 1
Spreadsheet: 08c54ead-101d-4921-89cc-344f4f4311af
Sheet: qryBio

Basin | 8 Digit HUC Name | Level IV Ecoregion | Waterbody | Station | County | Latitude | Longitude | Date | Collection No. | NCIBI Score | NCIBI Rating
PAS | [NAME] | Chesapeake-Pamlico Lowlands & Tidal Marshes | Burnt [NAME] | NC 37 | [NAME] | 36.0961111111111 | -76.5347222222222 | 1995-02-27 00:00:00 | 95-02 | --- | Not Rated
PAS | [NAME] | Nonriverine Swamps & Peatlands | Main Canal | SR 1180 | Washington | 35.8488888888889 | -76.5613888888889 | 1995-02-27 00:00:00 | 95-01 | --- | Not Rated
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: 4-C  230

Hour |  |  |  |  |  |  |  |  |  |  | Linked Data
Ending |  |  |  | hourly non-firm
Pacific | 4C 345 physical | PNM | PNM(t) | APS | PSCO | PNM | PINN | EPE | PNM | WAPA | To | Balance
Standard | position | Purchase | from 4C | from PV | Purch | Purch | Sale | Sale | Sale | Sale | PV
(PST) |  |  | 345/230 | PV/4C | EOL | EOL | EOL |  |  |  | APS(t)
 |  |  | 18054 |  |  |  |  |  |  | 70
100
200
300
400
500
600
700
800
900
1000
1100
1200 |  |  | 10 |  |  |  |  |  |  | -10
1300 |  |  | 10 |  |  |  |  |  |  | -10
1400 |  |  | 5 |  |  |  |  |  |  | -5
1500
1600
1700
1800
1900
2000
2100
2200
2300
2400
Spreadsheet: 125570d1319108890-excel-2007-moving-values-between-sheets-by-using-number-commands-weight-and-buildup
Sheet: ULD11&12

11 |  |  |  |  |  |  | 12
 |  |  |  | Aircraft Position |  |  |  |  |  |  | Aircraft Position
Built up by: |  |  | Origin | ULD Ident |  |  | Built up by: |  |  | Origin | ULD Ident
Total Pages: |  |  | KEF |  |  |  | Total Pages: |  |  | KEF
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: 170465d1343293143-about-transposing-ef137_transpose
Sheet: Sheet1

 |  | seq
11 | 317 | 11_1 |  | 11 | 317 | 408 | 5737 | 5738 | 5822
11 | 408 | 11_2 |  | 12 | 6099 | 7454 | 7455 | 7456
11 | 5737 | 11_3 |  | 13 | 8326 | 9522 | 9961 | 9962
11 | 5738 | 11_4
11 | 5822 | 11_5
12 | 6099 | 12_1
12 | 7454 | 12_2
12 | 7455 | 12_3
12 | 7456 | 12_4
13 | 8326 | 13_1
13 | 9522 | 13_2
13 | 9961 | 13_3
13 | 9962 | 13_4
Spreadsheet: 89874d1289601801-combobox-values-for-germ
Sheet: Data List

Product 1 | 1
Product 2 | 5
Product 3 | 5
Product 4 | 3
Product 5 | 4
Product 6 | 5
Product 7 | 6
Product 8 | 7
Product 9 | 8
Product 10 | 3
Product 11 | 3
Product 12 | 3
Spreadsheet: 464880d1465364116-error-while-checking-the-check-boxes-test
Sheet: Sheet1

True
True
True |  |  |  |  |  | pv | Column1 | upv | Column2 | sessions | Column3 | USERS
True |  |  |  |  | Column1 |  |  | Column1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pageviews
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unique pageviews
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sessions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Users
 |  | Pageviews
 |  | Unique pageviews
 |  | Sessions
 |  | Users |  |  |  |  |  |  |  |  |  |  |  | Column1 | Column2 | Column3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | upv |  | sessions |  | USERS
Spreadsheet: 166731d1341760913-excel-2007-unique-list-of-names-seperated-by-dashes-in-a-column-2012-07-08-excelforum-oeldere-
Sheet: Blad1

[NAME] | george | [NAME] |  |  |  | text to collumn
george
eva | george
[NAME] | richard | jack | [NAME] | ... *
[NAME] | george | eva | [NAME] |  |  | transpose
george |  | george | richard
[NAME] |  |  | jack
 |  |  | [NAME]
 |  |  | ... *
[NAME] |  |  |  |  |  | copy and paste
george
[NAME]
george
eva
george
[NAME]
richard
jack
[NAME]
... *
 |  | Count | helpcollumn | Large |  | result
[NAME] |  | 1 | 1.00025 | 2.00031 |  | [NAME]
george |  | 1 | 1.00026 | 2.0003 |  | george
[NAME] |  | 1 | 1.00027 | 1.00035
george |  | 1 | 1.00028 | 1.00034
eva |  | 1 | 1.00029 | 1.00033
george |  | 2 | 2.0003 | 1.00032
[NAME] |  | 2 | 2.00031 | 1.00029
richard |  | 1 | 1.00032 | 1.00028
jack |  | 1 | 1.00033 | 1.00027
[NAME] |  | 1 | 1.00034 | 1.00026
... * |  | 1 | 1.00035 | 1.00025
Spreadsheet: 884906d1734251852-transpose-the-data-from-single-column-to-multiple-data-transpose
Sheet: Sheet1

Column1 | Column2 | 1 | Company Name: Startech Innovations | [NAME]: [EMAIL]
1 | Company Name: Startech Innovations | 2 | Company Name: Oceanic Designs | Owner Name: [NAME]
1 | [NAME]: [EMAIL] | 3 | Company Name: Greenleaf Solutions | Owner Name: [NAME] | [NAME]: [EMAIL]
3 | Company Name: Greenleaf Solutions | 4 | Company Name: Apex Ventures | Owner Name: Emily Vargas | [NAME]: [EMAIL] | ADDRESS: ABC ROAD | BUSINESS : FOOD
3 | Owner Name: [NAME]
3 | [NAME]: [EMAIL]
4 | Company Name: Apex Ventures | Column1 | 1 | 2 | 3 | 4 | 5
4 | Owner Name: Emily Vargas | 1 | Company Name: Startech Innovations | [NAME]: [EMAIL]
4 | [NAME]: [EMAIL] | 2 | Company Name: Oceanic Designs | Owner Name: [NAME]
4 | ADDRESS: ABC ROAD | 3 | Company Name: Greenleaf Solutions | Owner Name: [NAME] | [NAME]: [EMAIL]
4 | BUSINESS : FOOD | 4 | Company Name: Apex Ventures | Owner Name: Emily Vargas | [NAME]: [EMAIL] | ADDRESS: ABC ROAD | BUSINESS : FOOD
2 | Company Name: Oceanic Designs
2 | Owner Name: [NAME]
Spreadsheet: 752476d1634781299-needing-help-with-matching-lookup-table-produced-from-mulitple-tables-using-power-query-ctuck1002-
Sheet: CL IX Bulk

NIIN | Nomenclature | U of I | Batch | QTY | Unit Price | Total Price | Location | Date
015004991 | WHEEL AND TIRE ASSY | EA | A | 3 | 2543 |  | BTIRES | 2021-05-28 00:00:00
014935859 | WHEEL AND RUNFLAT | EA | A | 2 | 2183 |  | BTIRES | 2021-05-28 00:00:00
015427405 | WHEEL,PNEUMATIC TIRE | EA | A | 4 | 986 |  | BTIRES | 2021-05-28 00:00:00
013337632 | TIRE,PNEUMATIC,VEHICULAR | EA | A | 1 | 562.68 |  | BTIRES | 2021-05-28 00:00:00
011481635 | TIRE,PNEUMATIC,VEHICULAR | EA | A | 4 | 160.62 |  | BTIRES | 2021-05-28 00:00:00
014407615 | PARTS KIT, TRACK SHOE CONNECTOR | EA | B | 1059 | 15.88 |  | BTRACK | 2021-06-04 00:00:00
014968858 | PAD, TRACK SHOE | EA | B | 135 | 14.52 |  | BTRACK | 2021-06-04 00:00:00
011303366 | PAD, TRACK, SHOE | EA | B | 121 | 11.52 |  | BTRACK | 2021-06-04 00:00:00
012341917 | TRACK SHOE,VEHICULAR | EA | A | 32 | 347 |  | BT5 | 2021-07-09 00:00:00
014429686 | TRACK SHOE,VEHICULAR | EA | A | 64 | 199 |  | BT5 | 2021-07-09 00:00:00
014964444 | TRACK SHOE ASSEMBLY | EA | B | 217 | 227 |  | BT5 | 2021-07-09 00:00:00
013666243 | FILTER, GAS-PARTICULATE | EA | A | 1 | 2816 |  | BJ1 | 2021-07-23 00:00:00
015804772 | FENDER, VEHICULAR | EA | B | 1 | 1899.19 |  | BJ1 | 2021-07-23 00:00:00
011573652 | TANK, FUEL ENGINE | EA | B | 1 | 1411.51 |  | BJ1 | 2021-07-23 00:00:00
015254023 | BUMPER, VEHICULAR | EA | B | 1 | 592.32 |  | BJ1 | 2021-07-23 00:00:00
016768103 | DOOR, VEHICULAR | EA | A | 1 | 8101 |  | BJ1 | 2021-07-30 00:00:00
013527252 | DOOR, VEHICULAR | EA | A | 2 | 2089.55 |  | BJ1 | 2021-07-30 00:00:00
013306175 | DOOR, VEHICULAR | EA | A | 1 | 151.22 |  | BJ1 | 2021-07-30 00:00:00
014732309 | HOOD, ENGINE COMPARTMENT | EA | A | 2 | 1508 |  | BJ1 | 2021-07-30 00:00:00
016264650 | WINDOW INSTALLATION KIT, VEHICULAR | KT | A | 1 | 4121.07 |  | BJ1 | 2021-07-30 00:00:00
013840910 | SIDE RACK, VEHICLE BODY | EA | A | 1 | 1017.14 |  | BJ1 | 2021-07-30 00:00:00
015291110 | PLATE, FLOOR, METAL | EA | A | 1 | 1063 |  | BJ1 | 2021-07-30 00:00:00
013946981 | LADDER, VEHICLE BOARDING | EA | A | 1 | 203.94 |  | BJ1 | 2021-07-30 00:00:00
013816341 | MAST | EA | B | 3 | 4859.14 |  | BJ1 | 2021-08-06 00:00:00
015678727 | TURRET, COMBAT VEHICLE | EA | B | 2 | 15729.25 |  | BJ1 | 2021-08-06 00:00:00
Spreadsheet: 877978d1724924931-dynamic-drop-down-dependent_data_validation
Sheet: Cherry

[NAME]
Branch | [NAME]
Area
Schools | Type | Model | Grade
School 9
School 9
School 10
School 10
School 10
Spreadsheet: 864162d1711457141-formula-name-errors-preventive-maintenance-schedule-2
Sheet: Maintenance Tasks

 | Preventive Maintenance Tasks
 | Tasks Performed | Miles Between Service | Months Between Service
 | Air Filter Change | 10000 | 6
 | Battery Replacement |  | 36
 | Belt Replacement | 50000 | 24
 | Brake Pad Replacement | 15000
 | Bulb Replacement
 | Engine Coolant | 30000 | 18
 | Fuel Filter Change | 25000 | 12
 | [NAME] | 60000 | 48
 | Oil & Filter Change | 3000 | 3
 | Tire Alignment | 6000
 | Tire Repair / Replacement | 65000 | 48
 | Tire Rotation / Balance | 7500 | 6
 | Transmission Fluid | 50000 | 24
 | [NAME] |  | 6
Spreadsheet: 744132d1628986195-find-missing-hours-within-a-day-sample
Sheet: MISSING TIME

Hours |  | Need to get this missing Hours
2021-08-14 00:00:00 |  | 2021-08-14 02:00:00
2021-08-14 01:00:00 |  | 2021-08-14 03:00:00
2021-08-14 05:00:00 |  | 2021-08-14 04:00:00
2021-08-14 06:00:00 |  | 2021-08-14 13:00:00
2021-08-14 07:00:00 |  | 2021-08-14 16:00:00
2021-08-14 08:00:00 |  | 2021-08-14 19:00:00
2021-08-14 09:00:00
2021-08-14 10:00:00
2021-08-14 11:00:00
2021-08-14 12:00:00
2021-08-14 14:00:00
2021-08-14 15:00:00
2021-08-14 17:00:00
2021-08-14 18:00:00
2021-08-14 20:00:00
Spreadsheet: 123050d1317306134-sort-columns-not-redundant-example
Sheet: Sheet1

 | COLUMN 1 | COLUMN 2 |  |  | COLUMN 1 | COLUMN 2
 | 40000168 | DBI:BI_5401_SFE_1 |  |  | 40000168 | DBI:BI_5401_SFE_1
 | 40000168 | DBI:BI_5401_SFE_3 |  |  | 50000191 | DBI:BI_5402_SFE_2
 | 40000168 | DBI:[NAME] |  |  | 50000234 | DBI:PRD_APPLFORV_BI
 | 50000191 | DBI:BI_5402_SFE_2 |  |  | 50000235 | DBI:PRD_QUERYDESIGN
 | 50000191 | DBI:BI_5402_SFE_5 |  |  | 50000293 | DSRM:BI_5402_SFE_2
 | 50000234 | DBI:PRD_APPLFORV_BI |  |  | 50000295 | DSRM:BI_5403_SFE_3
 | 50000235 | DBI:PRD_QUERYDESIGN |  |  | 50001625 | KECC:HR_RC_REKRF_0001_BAS
 | 50000235 | DBI:PRD_QUERYDESIGN_2 |  |  | 50001628 | KECC:HR_RC_REKRF_0002_BAS
 | 50000293 | DSRM:BI_5402_SFE_2 |  |  | 40000168 | DBI:BI_5401_SFE_3
 | 50000295 | DSRM:BI_5403_SFE_3 |  |  | 50000191 | DBI:BI_5402_SFE_5
 | 50001625 | KECC:HR_RC_REKRF_0001_BAS |  |  | 50000235 | DBI:PRD_QUERYDESIGN_2
 | 50001628 | KECC:HR_RC_REKRF_0002_BAS |  |  | 50001628 | KECC:HR_RC_REKRF_0003_BAS
 | 50001628 | KECC:HR_RC_REKRF_0003_BAS |  |  | 40000168 | DBI:[NAME]