tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 553490d1514366964-how-to-convert-dollar-value-to-number-to-sum-up-s666-pq-how-to-convert-dollar-value-to-number-to-sum-up
Sheet: Sheet1

A | B | Total
$12.00 |  | 12
$12.00 | $36.00 | 48
$12.00 |  | 12
$12.00 | $6.00 | 18
$12.00 | $18.00 | 30
$12.00 | $6.00 | 18
$12.00 |  | 12
$12.00 |  | 12
$12.00 | $12.00 | 24
$12.00 | $12.00 | 24
$12.00 | $12.00 | 24
$12.00 | $6.00 | 18
$12.00 | $24.00 | 36
$12.00 |  | 12
$12.00 |  | 12
Spreadsheet: 24a1af34-d74f-4255-ab22-680a047d86c7
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Metro One | 74948819321 | Smooth | [NAME] | 2001-01-10 | Compact Disc | Rap | 16.99 | N | To Be Retired
Spreadsheet: 82041d1282105335-lookup-from-a-list-and-count-lookup-and-count-file
Sheet: Sales - Brand 2

Date | Customer | Invoice #
2010-07-07 00:00:00 | [NAME] | 10039
2010-07-16 00:00:00 | [NAME] | 10054
2010-07-18 00:00:00 | [NAME] | 10056
2010-07-07 00:00:00 | AB Barlow | 10040
2010-07-17 00:00:00 | AB Barlow | 10055
2010-07-04 00:00:00 | AB Crack | 10034
2010-07-11 00:00:00 | AB Crack | 10047
2010-07-05 00:00:00 | AC Timeline | 10035
2010-07-12 00:00:00 | AC Timeline | 10048
2010-07-06 00:00:00 | Countess corp | 10037
2010-07-06 00:00:00 | Countess corp | 10038
2010-07-14 00:00:00 | Countess corp | 10052
2010-07-15 00:00:00 | Countess corp | 10053
2010-07-06 00:00:00 | Custom | 10036
2010-07-07 00:00:00 | Custom | 10041
2010-07-13 00:00:00 | Custom | 10049
2010-07-02 00:00:00 | Ensignia | 10030
2010-07-10 00:00:00 | Ensignia | 10044
2010-07-01 00:00:00 | floor lake | 10029
2010-07-09 00:00:00 | floor lake | 10043
2010-07-13 00:00:00 | floor lake | 10051
2010-07-13 00:00:00 | gravity | 10050
2010-07-03 00:00:00 | Mad Hatters | 10031
2010-07-10 00:00:00 | Mad Hatters | 10045
2010-07-03 00:00:00 | Polly lacards | 10033
2010-07-03 00:00:00 | [NAME] | 10032
2010-07-08 00:00:00 | [NAME] | 10042
2010-07-10 00:00:00 | [NAME] | 10046
Spreadsheet: 328343d1403876063-multiple-true-statements-but-need-one-to-override-the-other-example-workbook-for-forum-jacc3
Sheet: TEKNE CUTTING SHEET Jacc3 Table

ITEM | [NAME] | QTY | LENGTH | WIDTH | THKNS | MATERIAL | P/S | COMMENTS | L+ | W+ | THK+ | LENGTH2 | WIDTH3 | THK | LENGTH4 | WIDTH5 | THKNS6
1 | PANEL 1 | 1 | 500 | 44 | 18 | MDF |  |  |  |  |  |  |  |  |  |  |  |  | After Material Name
2 | TIE RAIL S/WOOD | 1 | 500 | 44 | 19 | SOFTWOOD
3 | PANEL 1 EDGING | 1 | 500 | 18 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | < = Adds 100mm  TO LENGTH
4 | Oak post | 1 | 500 | 44 |  | oak |  |  |  |  |  |  |  |  |  |  |  |  | > = For tennons this adds 2x material width & rounds up to the nearest 100mm TO LENGTH
5 | worktop | 1 | 500 | 44 |  | zebrano >
6 | door lipping | 1 | 500 | 42 | 3 | poplar
7 | oak edging | 1 | 500 | 44 |  | oak
8 |  | 1 | 500 | 44
9 |  | 1 | 500 | 44
10 |  | 1 | 500 | 44
11 |  | 1 | 500 | 44
12 |  | 1 | 500 | 44
13 |  | 1 | 500 | 44
14 |  | 1 | 500 | 44
15 |  | 1 | 500 | 44
16 |  | 1 | 500 | 44
Spreadsheet: 73061d1273718684-inadvertently-pasted-graphic-s-easy-removal-fcontacts
Sheet: Input for New Tickets

 |  | [NAME] | [NAME] | Informational | 6962 | Washington | 05/11/2010 08:26 | [NAME] | S-F131 will not boot up
 |  | [NAME] | [NAME] | Informational | 6957 | Washington | 05/11/2010 08:26 | [NAME] | S-F1330 Will not log into windows.
 |  | [NAME] | [NAME] | Informational | 6960 | Washington | 05/11/2010 08:24 | [NAME] | S-F1260 will not boot up
 |  | [NAME] | [NAME] | Informational | 6958 | Washington | 05/11/2010 08:21 | [NAME] | S-F0714 will not boot up
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 87555 | 87075
2 | 98252 | 97649
3 | 78608 | 77218
4 | 101009 | 100503
5 | 90729 | 89600
6 | 91681 | 90563
7 | 105225 | 103990
8 | 109389 | 107112
9 | 96923 | 96695
10 | 62710 | 62247
11 | 98145 | 100814
12 | 93439 | 93039
13 | 102036 | 101331
14 | 104231 | 108641
15 | 108131 | 109178
16 | 94371 | 94262
17 | 91954 | 91776
18 | 87470 | 86776
19 | 83953 | 86780
20 | 87096 | 86776
21 | 97676 | 96772
22 | 94387 | 93565
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 21602.9
2001-08-23 00:00:00
CBS Volume
 |  |  | -43475
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C10

Local 10
Nom:
Numéro de téléphone:
[NAME]:
Paiement dû le:
[NAME]:
Réservé:
Prix:
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: b4756258-6601-409b-91c9-2dc050ca505b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
SENARAI SEMAK BORANG DAN DOKUMEN BERSARA PILIHAN SENDIRI
KUMPULAN SOKONGAN
( sediakan dalam 4 salinan untuk di hantar [NAME] )
 |  | NAMA |  |  | :
 |  | NO. K/P LAMA DAN BARU |  |  | :
 |  | JAWATAN |  |  | :
 |  | TARIKH BPS YANG DISOKONG |  |  | :
 |  | NO. FAIL JPS |  |  | :
 | 1 | [NAME]
 | 2 | [NAME] sebab mohon [NAME]
 | 3 | Salinan surat kelulusan istihar harta
 | 4 | [NAME] |  |  | - | Maklumat Pesara
 | 5 | [NAME] JPA.BP.SPPP.B03 |  |  | - | Maklumat Tanggungan
 | 6 | [NAME] JPA.BP.SPPP.B04 |  |  | - | Notis Pelepasan/ Pengasingan KWSP
 | 7 | Borang JPA.BP.UMUM.B01 |  |  | - | [NAME]
 | 8 | [NAME] |  |  | - | [NAME] ( [NAME] )
 | 9 | [NAME] |  |  | - | [NAME] jika ada anak [NAME]
 | 10 | Salinan [NAME] dan Kenyataan Cuti
 | 11 | [NAME], sekiranya tiada, surat akuan sumpah
 | 12 | [NAME] [NAME] suami/ [NAME]
 | 13 | Salinan Sijil Kelahiran [NAME] anak di bawah umur 21 tahun dan tiada had umur bagi anak  cacat
 | 14 | Salinan dokumen bank [NAME], [NAME] pengenalan [NAME] akaun bank
 | 15 | Salinan surat penyelesaian Cukai Pendapatan dari [NAME]
 | 16 | [NAME] Pembayaran [NAME] Perumahan dari Bhg. Pinjaman Perumahan
 |  | Kementerian Kewangan
 |  | catatan :
 |  |  | Bil 15 dan 16 [NAME] diuruskan oleh pihak sekolah dengan menggunakan borang C.P.22B-Pin 2/94 dan
 |  |  | Lampiran 1 ( P. Perumahan ) - dihantar [NAME] penyelesaian
 |  |  | cukai pendapatan [NAME] [NAME] segera.
Spreadsheet: 857163d1706205478-quick-help-with-an-if-and-formula-i-think-ambers-interview-spreadsheet
Sheet: Definitions

Job Title | Event Results | [NAME] | GHR Offer Status | [NAME] | Facility
Central Sterile Technician | No Offer | Pending REQ | Pending REQ | Aliya | DSMC
[NAME] | Offer | Extended | Extended | Amber | HHOA
Extern | Peer: HM Scheduling | Accepted | Accepted | [NAME] | LPDS
Food Service Associate | Interview: HM Scheduling | Verbal Extended | Declined | Armida | NAMC
LVN | Interview Sheet Not Returned | Verbal Accept | Withdrew | [NAME] | RRMC
Medical Assistant | Interview Sheet Not Clear | Pending Candidate Decision |  | Athena | SAMC
Medical Technologist |  | Pending Peer Results |  | Crystal | SDGH
New Grad LVN |  | Pending Interview Results |  | Emily | SDMC
New Grad RN |  |  |  | Emma | SDSH
Occupational Therapist |  |  |  | Halie
Paramedic ED |  |  |  | Jessica
Patient Care Technician |  |  |  | Julie
Patient Safety Technician |  |  |  | [NAME]
Pharmacy Technician |  |  |  | Kat
Radiology Technologist |  |  |  | [NAME]
Registered Nurse |  |  |  | [NAME]
Registered Nurse Case Manager |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Lauren
 |  |  |  | Natasha
 |  |  |  | Tamara
 |  |  |  | Thalia
 |  |  |  | [NAME]
 |  |  |  | Veronica
Spreadsheet: 487668d1478185889-please-help-consolidating-sales-info-based-upon-customer-name-daveydst-please-help-consolidating-sales-info-based-upon-customer-name-example
Sheet: Sheet1

CUSTOMER NAME | ORDER QUANTITY | TOTAL $ AMOUNT
A | 2000 | 15500
A | 5000 | 32500
A | 1000 | 7250
B | 3000 | 17400
D | 500 | 3200
D | 1000 | 4800
Spreadsheet: 863896d1711298106-ifs-function-problem-sample-1-
Sheet: Sheet1

Not working [NAME]
Tax Bracket | Lower | Upper | Amount to Tax | Actual Amount | Before Deduction Tax | After Standard Deduction | Total Tax | Effective Rate |  |  | From | Rate
0.1 | 0 | 16550 |  |  |  |  |  |  |  |  | 0 | 0.1
0.12 |  | 63100 |  |  |  |  |  |  |  |  | 16550 | 0.12
0.22 |  | 100500 |  |  |  |  |  |  |  |  | 63100 | 0.22
0.24 | 100500 | 191950 |  |  |  |  |  |  |  |  | 100500 | 0.24
0.32 |  | 243700 |  |  | 0 |  |  |  |  |  | 191950 | 0.32
0.35 |  | 609350 |  |  | 0 |  |  |  |  |  | 243700 | 0.35
0.37 |  | 1000000 |  |  | 0 |  |  |  |  |  | 609350 | 0.37
 | TOTAL |  |  | 124734.33
 |  |  |  |  |  |  |  |  |  |  | 124734.33
Manual
Tax Bracket | Lower | Upper | Amount to Tax | Actual Amount | Before Deduction Tax | After Standard Deduction | Total Tax | Effective Rate
0.1 | 0 | 16550
0.12 |  | 63100
0.22 |  | 100500
0.24 | 100500 | 191950 |  |  |  |  |  |  | <---------- | I manually just put in cell E23 ( E27-C23)  to get the result I need. I want the IFS formula above to be able to evalute it and automatically update it. Thanks!
0.32 |  | 243700 |  |  | 0
0.35 |  | 609350 |  |  | 0
0.37 |  | 1000000 |  |  | 0
 | TOTAL |  |  | 124734.33
Spreadsheet: 851662d1701849957-direct-formula-to-looking-for-data-according-date-of-birth-and-report-date-sample-me_
Sheet: Data

REPORT Date | 2023-12-31 00:00:00 |  |  |  | Try Me (manual)
NAME | GENDER | DATE OF BIRTH | EASY FORMULA or DIRECT FORMULA | Expected Result | CATEGORY |  |  | YEAR (age) | CATEGORY |  |  |  |  |  | age (year)
[NAME] | M | 2017-02-16 00:00:00 | ? | A |  |  |  | 6 | A
[NAME] | F | 2017-10-24 00:00:00 | ? | A |  |  |  | 7 | A
[NAME] | F | 2015-12-01 00:00:00 | ? | B |  |  |  | 8 | B
[NAME] | F | 2015-10-13 00:00:00 | ? | B |  |  |  | 9 | B
[NAME] | F | 2016-04-20 00:00:00 | ? | B |  |  |  | 10 | C
[NAME] | F | 2014-07-23 00:00:00 | ? | B |  |  |  | 11 | C
[NAME] | F | 2014-10-28 00:00:00 | ? | B |  |  |  | 12 | D
[NAME] | F | 2014-08-30 00:00:00 | ? | B |  |  |  | 13 | D
[NAME] | F | 2016-05-09 00:00:00 | ? | B |  |  |  | 14 | D
[NAME] | F | 2013-11-21 00:00:00 | ? | C
[NAME] | F | 2014-01-22 00:00:00 | ? | C
[NAME] | F | 2014-06-25 00:00:00 | ? | C
[NAME] | F | 2012-05-27 00:00:00 | ? | D
 |  |  | I want to find a formula that directly gets the information "CATEGORY" which comes from cells "I and J". The categories are based on date of birth and report date, so if the report date is changed or changed the category column automatically adjusts the value
Spreadsheet: 878712d1725971940-sort-automatically-by-column-test
Sheet: Sheet1

No | Name | Location | Date | SN | Code | Total | Bank | Notes
1 | Name 1 | Location 1 | 03.09.2024 | 00020 | 50401 | 10.5 | Bank 1
2 | Name 2 | Location 2 | 03.09.2025 | 00154 | 50405 | 886.52 | Bank 2
3 | Name 3 | Location 3 | 03.09.2026 | 00151 | 50405 | 672.36 | Bank 3
4 | Name 4 | Location 4 | 03.09.2027 | 00148 | 50405 | 36.72 | Bank 4
5 | Name 5 | Location 5 | 03.09.2028 | 00145 | 50405 | 7.5 | Bank 5
6 | Name 6 | Location 6 | 03.09.2029 | 00032 | 50405 | 136.8 | Bank 6
7 | Name 7 | Location 7 | 03.09.2030 | 00031 | 50401 | 56.95 | Bank 7
8 | Name 8 | Location 8 | 09.09.2024 | 00033 | 50401 | 41.15 | Bank 8
9 | Name 9 | Location 9 | 09.09.2024 | 00092 | 50401 | 42 | Bank 9
10 | Name 10 | Location 10 | 06.09.2024 | 00091 | 50401 | 7.5 | Bank 10
11 | Name 11 | Location 11 | 05.09.2024 | 00086 | 50401 | 7.5 | Bank 11
12 | Name 12 | Location 12 | 06.09.2024 | 00088 | 50401 | 10.2 | Bank 12
13 | Name 13 | Location 13 | 06.09.2024 | 00090 | 50401 | 9 | Bank 13
14 | Name 14 | Location 14 | 05.09.2024 | 00082 | 50401 | 9 | Bank 14
15 | Name 15 | Location 15 | 04.09.2024 | 00081 | 50401 | 20 | Bank 15
16 | Name 16 | Location 16 | 05.09.2024 | 00083 | 50401 | 9.57 | Bank 16
17 | Name 17 | Location 17 | 05.09.2024 | 00084 | 50401 | 18.78 | Bank 17
18 | Name 18 | Location 18 | 05.09.2024 | 00087 | 50401 | 21.9 | Bank 18
19 | Name 19 | Location 19 | 03.09.2024 | 00080 | 50401 | 10.36 | Bank 19
20 | Name 20 | Location 20 | 03.09.2024 | 00079 | 50401 | 7.71 | Bank 20
21 | Name 21 | Location 21 | 02.09.2024 | 00078 | 50401 | 9.03 | Bank 21
22 | Name 22 | Location 22 | 06.09.2024 | 00089 | 50401 | 31.34 | Bank 22
23 | Name 23 | Location 23 | 05.09.2024 | 000022 | 50429 | 80.38 | Bank 23
24 | Name 24 | Location 24 | 06.09.2024 | 000023 | 50429 | 95.15 | Bank 24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: dca90b76-9f92-4c90-b7bf-4d66eab46eea
Sheet: Loans Originated

Loans Originated for Home Purchase & Occupation for Multnomah County: 2006-2010
(By HUD MFI Groups)
Loan Origination for All Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (All)
2006 | 1 | 6 | 79 | 48 | 88 | 225
2007 | 2 | 2 | 62 | 52 | 129 | 248
2008 | 1 | 23 | 384 | 282 | 770 | 1472
2009 | 8 | 225 | 1036 | 423 | 1141 | 2860
2010 | 14 | 267 | 904 | 412 | 1003 | 2633
Loan Origination for White Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (White)
2006 | 3 | 5 | 68 | 45 | 77 | 198
2007 | 2 | 2 | 56 | 43 | 113 | 217
2008 | 1 | 19 | 337 | 245 | 664 | 1277
2009 | 3 | 178 | 863 | 359 | 967 | 2392
2010 | 9 | 199 | 763 | 349 | 858 | 2203
Loan Origination for Black or African American Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Blacks)
2006 | 0 | 0 | 3 | 1 | 3 | 7
2007 | 0 | 0 | 3 | 3 | 5 | 11
2008 | 0 | 0 | 10 | 12 | 29 | 51
2009 | 0 | 4 | 28 | 12 | 24 | 68
2010 | 0 | 8 | 32 | 10 | 19 | 71
Loan Origination for Hispanic Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Hispanics)
2006 | 0 | 2 | 4 | 3 | 5 | 14
2007 | 0 | 1 | 9 | 6 | 6 | 22
2008 | 0 | 3 | 37 | 27 | 55 | 122
2009 | 0 | 19 | 71 | 20 | 46 | 158
2010 | 2 | 26 | 79 | 20 | 43 | 171
Loan Origination for Asian Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Asians)
2006 | 1 | 1 | 4 | 5 | 4 | 15
2007 | 0 | 0 | 2 | 4 | 6 | 12
2008 | 0 | 1 | 15 | 14 | 45 | 76
2009 | 1 | 10 | 53 | 19 | 50 | 134
2010 | 2 | 24 | 44 | 20 | 29 | 121
Loan Origination for Native American Households
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total (Native Americans)
2006 | 0 | 0 | 4 | 2 | 5 | 11
2007 | 0 | 0 | 0 | 1 | 3 | 4
2008 | 0 | 0 | 4 | 3 | 9 | 16
2009 | 0 | 4 | 16 | 3 | 13 | 36
2010 | 1 | 3 | 12 | 3 | 9 | 28
Source: HMDA (LAR) 2001-2005
Note: Data reported here is for Multnomah County. These are loans for the purpose of purchasing a home. The loans are for homes that are meant for a primary occupancy of the owner. These are all represented for FHA loans. For ethnic and racial breakout, these are loans originated by households where either the applicant or co-applicant are representative of that group.
Spreadsheet: 735059d1622670450-formula-to-sum-all-cells-in-1-column-above-a-certain-cell-with-criteria-online-lessons-weekly-report-x-test
Sheet: Sheet2

Row Labels
MW1
MW2
MW3
MW4
MW5
MW6
MW7
MW8
MW9
MW10
MW11
MW12
MW13
MW14
MW15
MW16
MW17
MW18
MW19
MW20
MW21
MW22
MW23
MW24
MW25
MW26
MW27
MW28
MW29
MW30
MW31
MW32
MW33
MW34
MW35
MW36
MW37
MW38
MW39
MW40
MW41
MW42
MW43
MW44
MW45
MW46
MW47
MW48
MW49
MW50
MW51
MW52
(blank)
Grand Total
Spreadsheet: 875897d1722520605-help-adding-data-to-formula-result-ojr-formula-08012024
Sheet: DATA

 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  | Client | [NAME] Per Hour | Avg Per Day ([NAME] N1)
 |  |  |  |  |  |  |  |  |  |  | BASS | 45 | 450
 |  |  |  |  |  |  |  |  |  |  | CALE | 45 | 450
 |  |  |  |  |  |  |  |  |  |  | DELE | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | GIAB | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | GGPM | 35 | 350
 |  |  |  |  |  |  |  |  |  |  | HHGJ | 33 | 330
 |  |  |  |  |  |  |  |  |  |  | HHGL | 40 | 400
 |  |  |  |  |  |  |  |  |  |  | RACT | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | LLBE | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | NAC | 30 | 300
 |  |  |  |  |  |  |  |  |  |  | SAVE | 40 | 400
 |  |  |  |  |  |  |  |  |  |  | HALL | 40 | 400
 |  |  |  |  |  |  |  |  |  |  | BLST | 30 | 300
 |  |  |  |  |  |  |  |  |  |  | KNST | 45 | 450
 |  |  |  |  |  |  |  |  |  |  | SUNR | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | TOFA | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | KWIK | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | CKCC | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | SURL | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | CALS | 20 | 200
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 25 | 250
 |  |  |  |  |  |  |  |  |  |  | CASY | 40 | 400
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 282.14
Spreadsheet: 885357d1734868564-start-date-and-end-date-from-month-name-book25
Sheet: Sheet1

[NAME]
Start Date
End Date
Start Date Year | 2024
Selected Period | Total Year
January
February
March
April
May
June
July
August
September
October
November
December
Total Year
Spreadsheet: 794992d1662457210-formula-for-sumup-of-data-based-on-wildcard-criteria-masterfile-ihhn-flood-relief-2022-data
Sheet: Baluchistan

S.No | Description | 06-10 Aug-22 | 2022-08-29 00:00:00 | 2022-08-30 00:00:00 | 2022-08-31 00:00:00 | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00 | 2022-09-09 00:00:00 | 2022-09-10 00:00:00 | 2022-09-11 00:00:00 | 2022-09-12 00:00:00 | 2022-09-13 00:00:00 | 2022-09-14 00:00:00 | 2022-09-15 00:00:00 | 2022-09-16 00:00:00 | 2022-09-17 00:00:00 | 2022-09-18 00:00:00 | 2022-09-19 00:00:00 | 2022-09-20 00:00:00 | 2022-09-21 00:00:00 | 2022-09-22 00:00:00 | 2022-09-23 00:00:00 | 2022-09-24 00:00:00 | 2022-09-25 00:00:00 | 2022-09-26 00:00:00 | 2022-09-27 00:00:00 | 2022-09-28 00:00:00 | 2022-09-29 00:00:00 | 2022-09-30 00:00:00 | 2022-10-01 00:00:00
1 | District | Uthal, [NAME] | Khuzdar | PLANNING  DAY FOR CAMP IN DISTRICT KHUZDAR | Khuzdar | PLANNING  DAY FOR CAMP SITE IN DISTRICT KHUZDAR, naseerabad, Jaffarabad, [NAME] and [NAME]
2 | UC Name
3 | Affected Population in the Camp Area
4 | Total Number of Camps | 5 | 1 |  | 1
5 | Total Number of Patients Treated
 | [NAME] | 406 | 65 |  | 178
 | [NAME] | 677 | 173 |  | 175
 | Less than 5 Male | 271 | 87 |  | 114
 | Less than 5 Female
6 | Nature of Intervention | Medical Camp | Mobile Medical Camp |  | Mobile Medical Camp
7 | Diseases Treated
 | Diarrhea | 445 | 163 |  | 109
 | Acute Respiratory Infection (ARI) | 384 |  |  | 145
 | Gastroenteritis | 0 | 93 |  | 61
 | Skin Infections | 243 | 43 |  | 23
 | Malaria | 0 | 10 |  | 19
 | Urinary Tract Infection (UTI) | 120 |  |  | 66
 | Others | 162 | 16 |  | 44
8 | Specific Outbreaks
9 | Number of CEC Sessions |  | 1
10 | Number of Critical Kits Distributed
 | Household Items/Hygiene Kits
 | Food
 | Clothing
 | Shelter
11 | Planned Upcoming Activities
12 | Laboratory Tests
 | CBC
 | Lab Test
 | Chemistry Test
 | Glucose by [NAME]
 | Malaria test
Spreadsheet: 128551d1321040713-concatif-across-multiple-sheets-hours-test4upl
Sheet: eemaster

Unique ID | SSN | First  Name | Last  Name | Company | Address | City | State | Zip | DOB | DOH | Dec. 10 Hour Balance | Dec Eligibility | JAN HRS  WRK | FEB HRS WRK | MAR HRS WRK | APR HRS WRK | MAY HRS WRK | JUN HRS WRK | JUL HRS WRK | AUG HRS WRK | SEPT HRS WRK | OCT HRS WRK | NOV HRS WRK | DEC HRS WKD | 2011 Cum Total Hrs | JAN BAL | FEB BAL | MAR  BAL | APR BAL | MAY BAL | JUN BAL | JUL BAL | AUG         BAL | SEPT BAL | OCT BAL | NOV BAL | DEC BAL | HOUR BANK  BAL |  | Jan Pension Contrib | Feb Pension Contrib | [NAME] | Apr Pension Contrib | May Pension Contrib | Jun Pension Contrib | July Pension Contrib | Aug Pension Contrib | Sept Pension Contrib | Oct Pension Contrib | Nov Pension Contrib | Dec Pension Contrib | 2011 YTD Pension Contrib | Jan Eligibility | Feb Eligibility | [NAME] | Apr Eligibility | May Eligibilty | Jun Eligibility | Jul Eligibility | Aug Eligibility | Sep Eligibility | Oct Eligibility | Nov Eligibility | Dec Eligibility |  | Sheet | Range
AckermanRo2269 | 2269 | Rocky | Ackerman | Architectural Glazing Systems | 14525 [NAME] | Bath | MI | 18808 | 1982-10-19 00:00:00 | 2008-08-01 00:00:00 | 89.5 | Eligible | 420.5 | 129 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Architectural Glazing Systems | VAGS
ArringtonDa2269 | 2269 | [NAME] | [NAME] | [NAME] | 11532 Colby Lake Rd | Laingsburg | MI | 48848 | 1956-10-12 00:00:00 | 1999-08-01 00:00:00 | 352.5 | Eligible | 214 | 164.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | VA1GCI
 |  |  | TOTALS |  |  |  |  |  |  |  | 442 |  | 634.5 | 293.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] - owners | VAGCO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | VAGCE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arnies Forman Ford | VAFF
 | Legend
 | BCBS only
 | Information missing/incorrect
 | Pension only
Spreadsheet: 6e600472-3e81-437a-b2ff-ecf06d9fd198
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SIIRO | Test | SIIRO | Sirolimus, Blood | Sirolimus, B | High-Performance Liquid Chromatography-Tandem Mass Spectrometry (HPLC-MS/MS) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions:  1. Draw blood immediately before a scheduled dose. 2. Do not centrifuge.  3. Send specimen in original tube. Additional Information:  1. Therapeutic range applies to trough specimen drawn immediately prior to a.m. dose. 2. For specimens sent ambient, sirolimus analysis cannot be performed; specimen must be sent refrigerated or frozen. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm >48 hours reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 4-20 ng/mL | Monday through Sunday; 1 p.m. | Same day/1 day | 3 days | 1 | 80195 |  |  |  |  | Rochester
SIIRO | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
SIIRO | Result | 35144 | Sirolimus, B | Sirolimus, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 879457d1726995392-sort-by-ascending-then-descending-up-down-up-again-etc-example
Sheet: Sheet1

DATA: |  |  |  |  | Desired Sort:
1 | 1 |  |  |  | 1 | 1
1 | 2 |  |  |  | 1 | 2
1 | 3 |  |  |  | 1 | 3
1 | 4 |  |  |  | 1 | 4
1 | 5 |  |  |  | 1 | 5
1 | 6 |  |  |  | 1 | 6
1 | 7 |  |  |  | 1 | 7
2 | 1 |  |  |  | 2 | 7
2 | 2 |  |  |  | 2 | 6
2 | 3 |  |  |  | 2 | 5
2 | 4 |  |  |  | 2 | 4
2 | 5 |  |  |  | 2 | 3
2 | 6 |  |  |  | 2 | 2
2 | 7 |  |  |  | 2 | 1
3 | 1 |  |  |  | 3 | 1
3 | 2 |  |  |  | 3 | 2
3 | 3 |  |  |  | 3 | 3
3 | 4 |  |  |  | 3 | 4
3 | 5 |  |  |  | 3 | 5
3 | 6 |  |  |  | 3 | 6
3 | 7 |  |  |  | 3 | 7
4 | 1 |  |  |  | 4 | 7
4 | 2 |  |  |  | 4 | 6
4 | 3 |  |  |  | 4 | 5
4 | 4 |  |  |  | 4 | 4
4 | 5 |  |  |  | 4 | 3
4 | 6 |  |  |  | 4 | 2
4 | 7 |  |  |  | 4 | 1
5 | 1 |  |  |  | 5 | 1
5 | 2 |  |  |  | 5 | 2
5 | 3 |  |  |  | 5 | 3
5 | 4 |  |  |  | 5 | 4
5 | 5 |  |  |  | 5 | 5
5 | 6 |  |  |  | 5 | 6
5 | 7 |  |  |  | 5 | 7
6 | 1 |  |  |  | 6 | 7
6 | 2 |  |  |  | 6 | 6
6 | 3 |  |  |  | 6 | 5
6 | 4 |  |  |  | 6 | 4
6 | 5 |  |  |  | 6 | 3
6 | 6 |  |  |  | 6 | 2
6 | 7 |  |  |  | 6 | 1
Spreadsheet: 45285d1244054965-reformat-a-vertical-data-set-to-a-horizontal-table-example-06-03-2009
Sheet: Sheet1

Existing Data:
 | Employee # | Description | Amount
 | 100 | Gross pay | 1000
 | 100 | Taxes | 50
 | 100 | Net Pay | 950
 | 200 | Gross pay | 1100
 | 200 | Taxes | 55
 | 200 | Net Pay | 1045
 | 300 | Gross pay | 2000
 | 300 | Taxes | 100
 | 300 | Net Pay | 1900
 | 400 | Gross pay | 500
 | 400 | Taxes | 20
 | 400 | Net Pay | 480
How I would like to reformat it:
 | Employee # | Gross pay | Taxes | Net Pay
 | 100 | 1000 | 50 | 950
 | 200 | 1100 | 55 | 1045
 | 300 | 2000 | 100 | 1900
 | 400 | 500 | 20 | 480