tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65010d1265792499-excel-2007-how-to-convert-transpose-my-data-sample
Sheet: Arkusz1

I have my data in this format : |  | i want to convert to this format:
21.11.2002 |  | date | transaction number | transaction type | description1 | amount of money transfered | amount of money after transfer | description2 | description3 | account number | title | operation number
e-149
money transfer |  | 21.11.2002 | e-149 | money transfer | university of krakow | 312 | 312 | 76-861 Krakow | [NAME]. | Nr..: [PHONE]-12345-1234 | Title: **money for study* | operation number: 2345-1
university of krakow |  | 21.11.2002 | e-148 | money transfer | university of krakow | 312 | 624 | 76-861 Krakow | [NAME]. | Nr..: [PHONE]-12345-1234 | Titlr: **money for study* | operation number: 54455-1
312 |  | 21.11.2002 | e-147 | payment | for somethig | -9 | 615 |  |  |  |  | operation number: 455435-1
312 |  | 23.11.2002 | e-146 | oneway transfer | [NAME] | -400 | 215 | [NAME] |  | Nr..: [PHONE]-12345-1234 | Title: money transfer for anne | operation number: 11112-1
76-861 Krakow |  | 28.11.2002 | e-145 | transfer | [NAME] | -200 | 15 | warsaw |  | Nr..: 125435346-98989898 | Title: transfer to account | operation number: 435453-1
[NAME].
Nr..: [PHONE]-12345-1234
Title: **money for study*
operation number: 2345-1
21.11.2002
e-148
money transfer
university of krakow
312
624
76-861 Krakow
[NAME].
Nr..: [PHONE]-12345-1234
Titlr: **money for study*
operation number: 54455-1
21.11.2002
e-147
payment
for somethig
-9
615
operation number: 455435-1
23.11.2002
e-146
oneway transfer
[NAME]
-400
215
[NAME]
Nr..: [PHONE]-12345-1234
Title: money transfer for anne
operation number: 11112-1
28.11.2002
e-145
transfer
[NAME]
-200
15
warsaw
Nr..: 125435346-98989898
Title: transfer to account
operation number: 435453-1
Spreadsheet: 867118d1713997220-changing-template-data-employee-absence-report-copy-
Sheet: May

 | Employee Absence Report
 | May
 | Absence type key | V | Vacation (10) |  |  | P | Paid (2) |  |  | S | Unpaid (1) |  |  | U | Unauthorized |  |  | O | Other
 |  | Dates of absence
 | Employee 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 | Total days
 | [NAME]. M  (PMO)
 | [NAME]. P  (PMO) | V
 | [NAME]. R  (GL)
 | [NAME]. M  (GL)
 | Teddy. M  (GL)
 | Krushna. J  (DLO)
 | [NAME]. W  (PFO)
 | Jaxon. B  (PMO)
 | Daman. S (PMO)
 | Alvin. C  (GL)
 | Baldomero. N  (GL)
 | Junner. B  (GL)
 | Heather. C  (PFO)
 | Jordan. B  (LO)
 | Santos. C  (GL)
 | Sunny. I  (GL)
 | Oliver. M  (PR)
 | [NAME]. C  (TL)
 | Justin. H  (YFO)
 | [NAME]. M  (YFO)
 | [NAME]. T  (YFO)
 | [NAME]. B  (SHC)
 | [NAME]. H  (IM)
 | [NAME]. A  (IM)
 | [NAME]. M  (IM)
 | Maryanne. B  (IMA)
 | Art. P  (MF)
 | Fabrice. M  (MF)
 | [NAME]. T (IE)
 | [NAME]. P  (IE)
 | Justin. N  (IEA)
 | Paige. B  (WMR)
 | Maryann. R  (PSC)
Spreadsheet: 123750d1317834675-excel-list-help-excel-list-example
Sheet: Sheet1

Score | Location |  | Location | Rank | Score
15 | A |  | B | 1 | 20
20 | B |  | J | 2 | 18.5
0 | C |  | M | 3 | 18
3 | D |  | A | 4 | 15
12 | E |  | A | 5 | 15
8.5 | F |  | A | 6 | 15
4 | G |  | E | 7 | 12
12 | H |  | E | 8 | 12
15 | I |  | N | 9 | 10
18.5 | J |  | F | 10 | 8.5
5 | K |  | K | 11 | 5
15 | L |  | G | 12 | 4
18 | M |  | D | 13 | 3
10 | N |  | C | 14 | 0
0 | O |  | C | 15 | 0
Spreadsheet: 798077d1664293208-merged-cells-in-dynamic-array-jade-help-file
Sheet: Lookup Info

 |  | Results | Group | Centre | Name | Program Code | Program Name | 5731 | 5798 | 5825 | 5725 | 5858 | 5764 | 5750 | 5695 | 5712 | 5857 | 5744
Results |  | EC |  | 321 | Centre 1 | 5731 | P1 | 961012 |  |  |  |  |  |  |  |  | 960501
Program | dbo_E_Freq1 | SU |  |  | Centre 2 | 5798 | P2 | 961024 |  |  |  |  |  |  |  |  | 960515
Students | dbo_E_Ele | EQ |  |  | Centre 3 | 5825 | P3 | 961034 |  |  |  |  |  |  |  |  | 960526
 |  | PN |  |  | Centre 4 | 5725 | P4 | 961042 |  |  |  |  |  |  |  |  | 960534
 |  |  |  |  | Centre 5 | 5858 | P5 | 961054
 |  |  |  |  | Centre 6 | 5750 | P6 | 961066
 |  |  |  |  | Centre 7 | 5712 | P7 | 961074
 |  |  |  |  | Centre 8 | 5857 | P8
 |  |  |  |  |  | 5764 | P9
 |  |  |  |  |  | 5695 | P10
 |  |  |  |  |  | 5744 | P11
 |  |  |  |  |  |  |  |  | 843665 | 754664 |  |  |  |  | 801974 |  |  | A744071
 |  |  |  |  |  |  |  |  | 843671 | 754714 |  |  |  |  | 801981
 |  |  |  |  |  |  |  |  | 843686 | 754795 |  |  |  |  | 801996
 |  |  |  |  |  |  |  |  |  | 754828
 |  |  |  |  |  |  |  |  |  | 754865
Spreadsheet: 67716d1268264023-unique-and-minimum-value-buffers
Sheet: Buffers

BID | FCOUNT | ENUM_LINK_DIST
52713 | 1 | 21570_43077_200
52721 | 1 | 21570_43077_200
52732 | 1 | 21570_43077_200
52738 | 1 | 21570_43077_200
52748 | 1 | 21570_43077_200
52773 | 2 | 21570_43077_200 | 21570_43077_150
52784 | 1 | 21570_43077_200
52790 | 1 | 21570_43077_200
52795 | 1 | 21570_43077_200
52800 | 1 | 21570_43077_200
52832 | 3 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100
52852 | 1 | 21570_43077_200
52863 | 3 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100
52865 | 1 | 21570_43077_200
52869 | 1 | 21570_43077_200
52891 | 3 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100
52896 | 1 | 21570_43077_200
53010 | 1 | 21570_43077_200
53015 | 4 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100 | 21570_43077_50
53016 | 3 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100
53020 | 4 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100 | 21570_43077_50
53026 | 2 | 21570_43077_200 | 21570_43077_150
53027 | 2 | 21570_43077_200 | 21570_43077_150
53028 | 2 | 21570_43077_200 | 21570_43077_150
53031 | 2 | 21570_43077_200 | 21570_43077_150
53038 | 1 | 21570_43077_200
53039 | 1 | 21570_43077_200
53044 | 4 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100 | 21570_43077_50
53047 | 2 | 21570_43077_200 | 21570_43077_150
53049 | 1 | 21570_43077_200
53051 | 1 | 21570_43077_200
53055 | 3 | 21570_43077_200 | 21570_43077_150 | 21570_43077_100
53056 | 1 | 21570_43077_200
53204 | 5 | 21570_43077_200 | 21570_43079_200 | 21570_43077_150 | 21570_43079_150 | 21570_43077_100
53206 | 6 | 21570_43077_200 | 21570_43079_200 | 21570_43077_150 | 21570_43079_150 | 21570_43077_100 | 21570_43077_50
53207 | 5 | 21570_43077_200 | 21570_43079_200 | 21570_43077_150 | 21570_43079_150 | 21570_43077_100
53212 | 6 | 21570_43077_200 | 21570_43079_200 | 21570_43077_150 | 21570_43079_150 | 21570_43077_100 | 21570_43079_100
53214 | 2 | 21570_43077_200 | 21570_43077_150
53215 | 2 | 21570_43077_200 | 21570_43077_150
Spreadsheet: 6e399ef2-a197-4afe-b3f4-76db1adffcfd
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
0 | Kolář | Tomáš | 0 | 0 | 3 | 3 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 7
0 | Lasovský | Jan | 0 | 0 | 7 | 7 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 11 | 15
0 | Řezníček | [NAME] | 0 | 0 | 5 | 5 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 8 | 13
0 | Obruča | Jakub | 0 | 0 | 7 | 7 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 12 | 15
0 | Toušek | Michal | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 12
0 | Šefránek | Michal | 0 | 0 | 6 | 6 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 15 | 16
0 | Šefránek | [NAME] | 0 | 0 | 3 | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7
0 | Kotrč | Tomáš | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | -1 | 2
 |  |  |  |  | 38 | 38 | 2 | 2 | 10 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 68 | 87
 |  |  |  |  | 100% |  | 100% |  | 50%
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: DON'T DELETE

 |  |  |  | Kickoff | In Progress | Pending | Lost | Won | Closeout |  |  | Key
 |  |  |  |  |  |  | Abandoned |  |  |  |  | Pending
 |  |  |  |  |  |  | Expired |  |  |  |  | Won
 |  |  |  |  |  |  | Declined |  |  |  |  | Kickoff
 |  |  |  |  |  |  | Obsolete |  |  |  |  | In Progress
 |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  | Lost
 |  |  |  |  |  |  |  |  |  |  |  | Abadoned / Obsolete
 |  |  |  |  |  |  |  |  |  |  |  | Expired
 |  |  |  |  |  |  |  |  |  |  |  | Closeout
https://amermhpsteam.sharepoint.com/sites/BusinessPlanningTeam/Shared Documents/ERF & Related
https://amermhpsteam.sharepoint.com/sites/BusinessPlanningTeam/_layouts/15/guestaccess.aspx?guestaccesstoken=Hehdi4464H%2BqRH5rmHw7VWgWDDPao%2FDv9kIHGOse%2Frk%3D&docid=2_17d06e06a11334c0cb078313c1dd0d6a9&rev=1&e=qPQyB4
Spreadsheet: 72951a65-6605-40e1-a101-b12282bc6006
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5197 | 5486 | Anastasiya | Polyanskaya | RUS | 33 | 00:21:06 | 00:00:20 | [NAME] | 01:08:47 | 00:41:57 | 1 | 02:11:51
5197 | 9820 | [NAME] | Ivanovskaya | RUS | 32 | 00:21:06 | 00:00:23 | 01:08:25 | [NAME] | 00:42:00 | 2 | 02:11:56
5197 | 6744 | [NAME] | Langit | PHI | 34 | 00:20:54 | 00:00:21 | 01:08:40 | 01:09:01 | 00:46:08 | 3 | 02:16:04
5197 | 32605 | Regina | [NAME] | AUS | 35 | 00:21:08 | 00:00:21 | 01:08:24 | 01:08:45 | 00:48:08 | 4 | 02:18:02
5197 | 31820 | [NAME] | Ying | SIN | 0 | 00:21:20 | 00:00:23 | 01:18:49 | 01:19:13 | [NAME] | 5 | 02:26:54
Spreadsheet: 7e9adf2a-71db-4ae2-acd1-67a83f5189af
Sheet: Weld Cars

Contract/ Type | Description | Numbers | Original Numbers | 1960s [NAME] | Builder | Notes | Status
Weld Cars
none | Tool Welding Car | 42 | 5000 | 20146 | 1918 ACF | R&NRCD 112
R-56 | Weld Car | W301-W302 |  |  |  | R&NRCD 241
Spreadsheet: 717966d1612924439-lookup-via-keyword-on-multiple-sheets-excel-lookup-example
Sheet: Sheet1

SHAPEFILE NAME | TYPE | KEYWORDS | COMMENTS | DATE MODIFIED | [NAME]
Boundaries
Boundaries/Australia
200124 Large-scale Background less VIC outline |  | BOUNDARIES |  | 2020-01-24 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia
200124 Large-scale Background |  | BOUNDARIES |  | 2020-01-24 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia
Australiaboundary67 |  | BOUNDARIES |  | 2018-12-03 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia
ACT_STATE_POLYGON_shp | State Boundary | ACT, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
NSW_STATE_POLYGON_shp | State Boundary | NSW, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
NT_STATE_POLYGON_shp | State Boundary | NT, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
OT_STATE_POLYGON_shp | State Boundary | BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
QLD_STATE_POLYGON_shp | State Boundary | QLD, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
SA_STATE_POLYGON_shp | State Boundary | SA, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
TAS_STATE_POLYGON_shp | State Boundary | TAS, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
VIC_STATE_POLYGON_shp | State Boundary | VIC, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
WA_STATE_POLYGON_shp | State Boundary | WA, BOUNDARIES |  | 2020-01-14 00:00:00 | 05 GIS/01 GIS Layers/Current/Boundaries/Australia/state-boundaries-november-2019/State Boundaries NOVEMBER 2019/Standard
Spreadsheet: 845292d1696838370-data-cleansing-data-cleansing-aligw
Sheet: Data

כתובת הפגישה
זום
טלפון
יצחק שדה 8
יצחק שדה 8 עיטם
משרדי עיטם
בארית 9 להבים
אשדוד
כתובת | המרה
משרדי עיטם | ת"א - יצחק שדה 8 (משרדי עיטם)
יצחק שדה 8 עיטם | ת"א - יצחק שדה 8 (משרדי עיטם)
יצחק שדה 8 | ת"א - יצחק שדה 8 (משרדי עיטם)
טלפון | ZooM
זום | ZooM
תל אביב | ת"א
אשדוד | אשדוד
Spreadsheet: 804823d1668380349-solver-for-resource-allocation-book1-hiwire03-
Sheet: Sheet1

[NAME] |  |  | 1
[NAME] |  |  | 2
[NAME] |  |  | 3
[NAME] |  |  | 4
G2-T1
G2-T2
G2-T3
G3-T1
G3-T2
G3-T4
Spreadsheet: 134396d1325265553-creating-a-graph-with-scroll-and-checkboxes-pnl_qty
Sheet: Desks

AccountID | Topics
BXC | Options
08125 | Options
AL2 | Global Equities Trading
ALNB3 | Agriculture
023-49310 | Agriculture
08113 | Agriculture
08120 | Agriculture
08135 | Agriculture
M49882 | Agriculture
ALC54949 | Halo Energy
ALNY2 | Halo Energy
ALNYT | Options
08123 | Options
08136 | Options
023-16980 | R+D
08130 | R+D
023-49311 | R+D
M49986 | FX
YALLST | FX
ALC55036 | Energy
[NAME] | Energy
ALNYX | Energy
08143 | Metals
353-50831 | Metals
[NAME] | Metals
M49982 | Metals
M49988 | Metals
METALS | Metals
A12 | FX
08105 | Options
023-21104 | STIRs
033-96520 | STIRs
033-965245 | STIRs
08112 | STIRs
023-02861 | STIRs
023-05754 | R+D
ALNY3 | R+D
M50031 | R+D
ALLDM | Energy
M50032 | R+D
08121 | Empirical Trading Group
08104 | Empirical Trading Group
023-05751 | Empirical Trading Group
023-05018 | Equity Index
08102 | Equity Index
08116 | Equity Index
08139 | Equity Index
AL3 | Equity Index
023-02861 | Treasuries
08126 | Treasuries
08128 | Treasuries
08138 | Treasuries
08140 | Treasuries
91890705 | Treasuries
10013274 | Treasuries
023-20729 | Economic Releases
08110 | Economic Releases
ALNB4 | Economic Releases
ALC55038 | Economic Releases
ALELX | STIRs
ALNY4 | Treasuries
ALC54953 | Energy
ALLFE | STIRs
08150 | STIRs
08119 | FortyFour
08151 | FortyFour
ALLSS | FortyFour
08152 | FortyFour
AL4 | Empirical Trading Group
023-47754 | Empirical Trading Group
08134 | Empirical Trading Group
ALC54957 | FortyFour
96Y03498 | STIRs
CASH12345 | Treasuries
023-84817 | FortyFour
023-47360 | Treasuries
08118 | Global Equities Trading
023-11748 | Treasuries
0581BCL40 | FX
0581BCL57 | FX
023-25584 | FortyFour
023-08481 | FortyFour
A10 | Spreads
052895307 | FX
08137 | Spreads
08108 | STIRs
AL6 | Spreads
ALGET | Spreads
08107 | Empirical Trading Group
A11 | Spreads
08129 | Empirical Trading Group
08115 | FX
08127 | Equity Index
080-11-113500 | Options
155-11-014514 | STIRs
AL7 | Equity Index
08109 | Options
75001685 | Treasuries
66651301 | Treasuries
Spreadsheet: 2816e8e1-ace6-46c7-87d5-44e98e03f181
Sheet: Sheet1

Adults Ages 18 Years and Over, Who Always Use a Seatbelt,  by Race, Ethnicity and Sexual Orientation, Maine 2006, 2008, 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Unweighted Number | Weighted Number | % | LCL | UCL
Race and Ethnicity
American Indian or Alaskan Native, non-Hispanic | 124 | 21861.78999949338 | 77.32065640406616 | 68.31848059264092 | 86.3228322154914
Black only, non-Hispanic | DNR | DNR | DNR | DNR | DNR
Hispanic | 158 | 29192.10035381219 | 78.94544902963598 | 70.83319356357597 | 87.05770449569599
Multiracial, non-Hispanic | 135 | 21330.74683925781 | 78.6398033992288 | 70.93596935222996 | 86.34363744622765
Other, non-Hispanic | 88 | 21940.79140638089 | 87.54018233548419 | 77.60387388454923 | 97.47649078641916
White only, non-Hispanic | 14988 | 2361378.896102454 | 80.07843611618112 | 79.20949795705968 | 80.94737427530258
Sexual Orientation
Heterosexual or straight | 14981 | 2381924.75857635 | 80.1527537118894 | 79.28570174276429 | 81.01980568101452
Homosexual or gay or lesbian | 217 | 31700.4208645251 | 76.48953018900605 | 68.08611376355364 | 84.89294661445845
Bisexual | 98 | 22388.10558570827 | 75.06308608886812 | 65.46504144417187 | 84.66113073356438
Other | DNR | DNR | DNR | DNR | DNR
Adults Ages 18 Years and Over, Who Always Use a Seatbelt, by Year, Maine 2002, 2006, 2008, 2010
Year | Unweighted Number | Weighted Number | % | LCL | UCL
2002 | 1820 | 715357.7461774892 | 72.38644935897702 | 70.32368770684823 | 74.44921101110582
2006 | 3088 | 776256.5855518444 | 75.38789187895017 | 73.64061816958639 | 77.13516558831395
2008 | 5666 | 849700.6679046649 | 81.49986782560872 | 80.1818083124304 | 82.81792733878703
2010 | 6911 | 860397.9676535174 | 83.41841901793218 | 82.1376698230871 | 84.69916821277727
Data Source: Behavioral Risk Factor Surveillance System % = Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage All percentages are weighted to be more representative of the population of Maine and to adjust for non-response.
Spreadsheet: 328523d1403934058-how-to-link-drop-down-list-to-table-groups-tracker-by-month
Sheet: Aug

Century Park, Jakarta - Groups Tracker
Group Name | Sales | Event | [NAME] | Departure Date | Total Room | Rate Offered | Rate Accepted | Cut Off Date | Inclusions | Total Revenue | Status | Comments
[NAME] | [NAME] | Unknown | 2014-08-02 00:00:00 | 2014-08-04 00:00:00 | 32 | 910000 | 910000 | 2014-07-22 00:00:00 | 1 Breakfast |  | Tentative | NO MOP |  | Please Select
CARGILL | Vera | Unknown | 2014-08-05 00:00:00 | 2014-08-08 00:00:00 | 39 | 1000000 | 1000000 | 2014-07-23 00:00:00 | 2 Breakfast |  | Tentative | Wait Payment |  | Tentative
HM Sampoerna | Putri | Unknown | 2014-08-11 00:00:00 | 2014-08-14 00:00:00 | 210 | 950000 | 950000 | 2014-07-17 00:00:00 | 2 Breakfast |  | Tentative | Wait GL |  | Approved
[NAME] | Mr Ario | Unknown | 2014-08-14 00:00:00 | 2014-08-17 00:00:00 | 600 | 1010000 | 1010000 | 2014-07-02 00:00:00 | 2 Breakfast |  | Tentative | Wait Payment |  | Not Approved
Hands Seidel Foundation | Ichsan | Unknown | 2014-08-18 00:00:00 | 2014-08-21 00:00:00 | 60 | 1100000 | 1100000 | 2014-07-24 00:00:00 | 1 Breakfast |  | Tentative | NO MOP |  | Confirm
Tupperware MC | Yessy ? | Unknown | 2014-08-19 00:00:00 | 2014-08-21 00:00:00 | 300 | 980000 | 980000 | 2014-07-04 00:00:00 | 2 Breakfast |  | Cancel | Wait Payment |  | Guarantee
[NAME] PT | [NAME] | Unknown | 2014-08-19 00:00:00 | 2014-08-20 00:00:00 | 75 | 1200000 | 1200000 | 2014-07-16 00:00:00 | 1 Breakfast |  | Tentative | Wait Payment |  | Cancel
Kajima - Yoshiko | Putri | Unknown | 2014-08-20 00:00:00 | 2014-08-22 00:00:00 | 42 | 950000 | 950000 | 2014-07-23 00:00:00 | 1 Breakfast |  | Tentative | NO MOP
SMI Travel | [NAME] | Unknown | 2014-08-22 00:00:00 | 2014-08-23 00:00:00 | 16 | 1099938 | 1099938 | 2014-07-24 00:00:00 | 2 Breakfast |  | Tentative | Wait Payment
Ace Life Assurance | Vera | Unknown | 2014-08-22 00:00:00 | 2014-08-23 00:00:00 | 150 | 1100000 | 1100000 | 2014-07-24 00:00:00 | 1 Breakfast |  | Tentative | Wait Payment
GPDI (Pantekosta Conference) | Putra/Ichsan | Unknown | 2014-08-25 00:00:00 | 2014-08-28 00:00:00 | 3 | 1000000 | 1000000 | 2014-07-19 00:00:00 | 2 Breakfast |  | Cancel | Deposit received IDR 50.000.000
Indoaqua Culture | [NAME] | Unknown | 2014-08-26 00:00:00 | 2014-08-29 00:00:00 | 225 | 980000 | 980000 | 2014-07-24 00:00:00 | 1 Breakfast |  | Tentative | Wait Payment
Indoaqua Culture - Dinas | [NAME] | Unknown | 2014-08-26 00:00:00 | 2014-08-29 00:00:00 | 75 | 980000 | 980000 | 2014-07-24 00:00:00 | 1 Breakfast |  | Tentative | Wait Payment
Spreadsheet: 21a0afb7-a61b-4f5b-9fa3-9f42ecc39195
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | ENDURANCE TIMING SHEET | ENDURANCE RIDE TIMNG SHEET | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
RIDE: |  |  |  |  |  |  | DISTANCE: |  | [NAME]:
START TIME: |  |  |  |  |  | TOTAL HOLD TIME:
 |  |  |  |  |  |  | FINISH TIME |  | RUNNING TIME
 |  |  |  |  |  |  | LESS THAN |  | LESS THAN
 |  |  |  |  |  |  | START TIME | TOTAL | HOLD TIME
 |  |  |  |  |  | FINISH | RUNNING | HOLD | RIDING
PLACE | RIDER # | RIDERS NAME |  |  |  | TIME | TIME | TIME | TIME
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
Spreadsheet: 788219d1658329712-combining-subtotal-with-index-and-match-sample-sheet
Sheet: Sheet1

ID | DATE | VALUE
AB-01 | 2022-01-01 00:00:00 | 9.5
AB-01 | 2022-02-01 00:00:00 | 3.5
AB-01 | 2022-03-01 00:00:00 | 3.5
AB-02 | 2022-01-01 00:00:00 | 0.5
AB-02 | 2022-02-01 00:00:00 | 0.7
AB-02 | 2022-03-01 00:00:00 | 0.3
AB-03 | 2022-01-01 00:00:00 | 1.1
AB-03 | 2022-02-01 00:00:00 | 1.2
AB-03 | 2022-03-01 00:00:00 | 1.3
AB-04 | 2022-01-01 00:00:00 | 2.1
AB-04 | 2022-02-01 00:00:00 | 2.2
AB-04 | 2022-03-01 00:00:00 | 2.3
[NAME] | 2022-01-01 00:00:00 | 0.6
[NAME] | 2022-02-01 00:00:00 | 0.4
[NAME] | 2022-03-01 00:00:00 | 0.8
AB-06 | 2022-01-01 00:00:00 | 0.1
AB-06 | 2022-02-01 00:00:00 | 0.2
AB-06 | 2022-03-01 00:00:00 | 0.1
 | [NAME]:
 | Location:
 | Date:
Spreadsheet: 175074d1345370969-which-lookup-function-to-use-pivot
Sheet: Sales by week

Sum of Sales | name
date | [NAME] | [NAME] | Elvis | Fred | [NAME] | [NAME] | Grand Total
2012-01-12 00:00:00 |  |  | 446 |  |  |  | 446
2012-01-31 00:00:00 |  |  | 545 |  |  |  | 545
2012-02-12 00:00:00 |  |  | 874 |  |  |  | 874
2012-02-14 00:00:00 |  |  | 120 |  |  |  | 120
2012-02-18 00:00:00 |  |  | 120 |  |  |  | 120
2012-03-05 00:00:00 |  |  | 325 |  |  |  | 325
2012-04-01 00:00:00 |  |  | 841 |  |  |  | 841
2012-04-06 00:00:00 |  |  | 545 |  |  |  | 545
2012-06-04 00:00:00 |  | 123 |  |  | 74 | 152 | 349
2012-07-04 00:00:00 | 124 |  |  | 456 |  |  | 580
2012-08-08 00:00:00 | 345 | 588 |  | 965 | 45 | 145 | 2088
2012-08-12 00:00:00 |  |  | 898 |  |  |  | 898
2012-09-11 00:00:00 |  |  | 894 |  |  |  | 894
2012-09-14 00:00:00 | 21 |  |  | 215 |  |  | 236
2012-10-01 00:00:00 | 434 |  |  | 854 |  |  | 1288
2012-10-05 00:00:00 | 65 |  |  | 841 |  |  | 906
2012-10-14 00:00:00 |  | 545 |  |  | 56 | 452 | 1053
2012-10-15 00:00:00 |  | 854 |  |  | 848 | 225 | 1927
2012-10-16 00:00:00 |  | 336 |  |  | 453 | 665 | 1454
2012-10-22 00:00:00 | 332 | 468 |  | 898 | 953 | 455 | 3106
2012-11-04 00:00:00 | 121 |  |  | 123 |  |  | 244
2012-11-05 00:00:00 |  | 842 |  |  | 873 | 875 | 2590
2012-11-07 00:00:00 |  | 842 |  |  | 554 | 215 | 1611
2012-11-12 00:00:00 | 35 | 843 |  | 842 | 123 | 230 | 2073
2012-11-15 00:00:00 | 678 |  |  | 554 |  |  | 1232
2012-11-18 00:00:00 | 211 |  |  | 544 |  |  | 755
2012-11-24 00:00:00 |  | 547 |  |  | 783 | 980 | 2310
Grand Total | 2366 | 5988 | 5608 | 6292 | 4762 | 4394 | 29410
Spreadsheet: 727264d1617809020-help-with-average-across-multiple-columns-sample-wb
Sheet: sample supervisor

 | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00
Moore, Altonese |  |  |  |  |  |  |  |  |  |  |  |  |  | Need to calculate the average from the DB by supervisor by date
Barnes, LaShanda
Exume, [NAME]
Faue, [NAME]
[NAME], [NAME]
Edwards, [NAME]
Campbell, Amelia
Simpson, [NAME]
[NAME], [NAME]
Ellis, Subama
Criales, Mauricio
Hooke-Andrew, Shayla