tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715123d1611579173-time-sheet-total-hours-calculate-mubarak
Sheet: DEC-2020

 |  |  |  | Attendence [NAME] الحضور
 |  |  |  |  |  | مبارک البوعنین
د سمبر | شهر: |  | 2020
 | MORNING صباح |  | AFTER NOON بعد الظهر
DATE: | IN | OUT | IN | OUT | T/HOURS | REMARK | SIGNATURE
التاريخ | دخول | خروج | دخول | خروج | مجموع الساعات | تعليق | التوقيع
2020-12-01 00:00:00 | 08:00:00 | 11:30:00 | 02:00:00 | 06:15:00
2020-12-02 00:00:00 | 08:20:00 | 11:30:00 | 02:00:00 | 06:15:00
2020-12-03 00:00:00 | 08:30:00 | 11:30:00 | 02:15:00 | 06:20:00
2020-12-04 00:00:00 |  |  |  |  |  |  | يوم الجمعة
2020-12-05 00:00:00 | 08:05:00 | 11:20:00 | 02:00:00 | 06:20:00
2020-12-06 00:00:00 | 07:55:00 | 11:30:00 | 02:00:00 | 06:15:00
2020-12-07 00:00:00 | 08:30:00 | 11:30:00 | 02:10:00 | 06:20:00
2020-12-08 00:00:00 | 08:20:00 | 11:30:00 | 02:00:00 | 06:00:00
2020-12-09 00:00:00 | 07:55:00 | 11:30:00 | 02:00:00 | 06:20:00
2020-12-10 00:00:00 | 08:20:00 | 11:00:00 | 02:30:00 | 06:10:00
2020-12-11 00:00:00 |  |  |  |  |  |  | يوم الجمعة
2020-12-12 00:00:00 | 08:00:00 | 11:20:00 | 02:00:00 | 06:20:00
2020-12-13 00:00:00 | 08:00:00 | 11:30:00 | 03:20:00 | 06:20:00
2020-12-14 00:00:00 | 08:00:00 | 11:30:00 | 02:00:00 | 06:20:00
2020-12-15 00:00:00 | 08:00:00 | 11:25:00 | 03:30:00 | 06:20:00
2020-12-16 00:00:00 | 08:10:00 | 11:15:00 | 02:30:00 | 06:00:00
2020-12-17 00:00:00 | 08:40:00 | 11:30:00 | 02:00:00 | 06:20:00
2020-12-18 00:00:00 |  |  |  |  |  |  | يوم الجمعة
2020-12-19 00:00:00 | 08:20:00 | 11:30:00 | 05:30:00 | 06:20:00
2020-12-20 00:00:00 | 08:10:00 | 11:30:00 | 03:30:00 | 06:10:00
2020-12-21 00:00:00 | 08:15:00 | 11:00:00 | 03:00:00 | 06:00:00
2020-12-22 00:00:00 | 08:30:00 | 11:25:00 | 02:40:00 | 06:20:00
2020-12-23 00:00:00 | 08:10:00 | 11:30:00 | 01:50:00 | 06:10:00
2020-12-24 00:00:00 | 08:35:00 | 11:20:00 | 02:45:00 | 06:00:00
2020-12-25 00:00:00 |  |  |  |  |  |  | يوم الجمعة
2020-12-26 00:00:00 | 08:15:00 | 11:00:00 | 03:00:00 | 06:00:00
2020-12-27 00:00:00 | 08:30:00 | 11:25:00 | 02:40:00 | 06:20:00
2020-12-28 00:00:00 | 08:10:00 | 11:30:00 | 01:50:00 | 06:10:00
2020-12-29 00:00:00 | 08:20:00 | 11:20:00 | 03:20:00 | 06:15:00
2020-12-30 00:00:00 | 08:00:00 | 11:25:00 | 03:30:00 | 06:20:00
2020-12-31 00:00:00 | 08:25:00 | 11:00:00 | 03:50:00 | 03:50:00
 |  | مجموع الساعات  [NAME]
Spreadsheet: 817992d1676544499-expected-outcome-based-on-2-criteria-sample-workbook-3-
Sheet: Sheet1

 |  |  |  |  | EXPECTED OUTCOME
CAAS | Account Name | GL Balance | Supporting Balances |  | GL Balance | Unreconciled/Out of balance
[PHONE]-0224241-0000000-Canadian Dollar | DIRECT FINANCE LEASE RECEIVABLE-NONUS-IL | 70689528.37
[PHONE]-0224241-0000000-Canadian Dollar | UNEARNED FINANCE INCOME-DIRECT LEASE FIN-NONUS-IL | -4952720.45
[PHONE]-0023313-0000000-US Dollar | SECURITY DEPOSIT- IL | 23850
[PHONE]-0027353-0000000-US Dollar | SECURITY DEPOSIT- IL | 87606.3
[PHONE]-0240685-0000000-US Dollar | SECURITY DEPOSIT- IL | 92287.6
[PHONE]-0228034-0000000-Statistical | 30-89 DAYS PD-LOANS TO NONDEPOSITORY FINANCIAL INST-IL | 41010.68
[PHONE]-0240685-0000000-Statistical | 30-89 DAYS PD-LOANS OF STATE/POLITICAL SUBDIVISIONS-IL | 20519.89
[PHONE]-0224241-0000000-Statistical | 30-89 DAYS PD LOANS TO NON-US GOVERNMENTS-IL | 245.31
[PHONE]-0228029-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 3358079
[PHONE]-0211738-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 21620219.08
[PHONE]-0228020-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 10064980.9
[PHONE]-0228021-0000000-Statistical | 30-89 DAYS PAST DUE-COMMERICAL LOANS-IL | 203303.79
[PHONE]-0228036-0000000-Statistical | 30-89 DAYS PAST DUE-COMMERICAL LOANS-IL | 58774.15
[PHONE]-0240695-0000000-Statistical | ASC 842-30-89 DPD-NONDEPOSITORY INSTITUTIONS-IL | 2134.88
 |  |  |  | TOTAL
Spreadsheet: e23630c0-f45e-40c8-bbd7-5f3171ff08bd
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Alliance Atlantic (Word | 75678323126 | [NAME] | Poetic Aftermath | 2002-04-01 | Compact Disc | Na | 16.99 | N | To Be Retired
Spreadsheet: 228611d1366160572-have-selected-data-appear-xlsforum-selecteddataappear
Sheet: Sheet1 (2)

Time | 5/1 | 5/2 | 5/3 | Name | jw
09:00:00 | JS | BF | RH
09:30:00 | JS | BF | RH
10:00:00 | JS | BF | RH
10:30:00 | JS | BF | RH
11:00:00 | JS | BF | RH
11:30:00 | JS | BF | RH
12:00:00 | JS | BF | RH
12:30:00 | JS | JW | KW
01:00:00 | JS | JW | KW
01:30:00 | JS | JW | KW
02:00:00 | JS | JW | KW
02:30:00 | JS | JW | KW
03:00:00 | JS | JW | KW
Spreadsheet: 181931d1348210217-no-formula-visible-in-cell-formula
Sheet: Sheet1

Needed | Filled | % | Status
79 | 39
76 | 65
76 | 65
77 | 100
77 | 69
78 | 73
56 | 53
79 | 77
33 | 44
22 | 33
66 | 100
100 | 66
22 | 33
33 | 44
22 | 44
100 | 34
Spreadsheet: 681551d1591632065-pensions-calculations-financial-comparison-example
Sheet: Sheet1

[NAME]
9000
Income Stream
1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
[NAME] Yield to Annual |  |  |  |  | [NAME] Annual Yield to Annual
Monthly % | 1 |  |  |  | Annual %
Annual % |  |  |  |  | Monthly %
[NAME] Yield to Annual |  |  |  |  | [NAME] Annual Yield to Weekly
Weekly % | 1 |  |  |  | Annual %
Annual % |  |  |  |  | Weekly %
Spreadsheet: 766520d1643914696-how-to-highlight-cell-based-on-adjacent-cell-value-highlightt-cell
Sheet: Sheet1

 |  | How To Highlight Cell Based On Adjacent Cell Value
 |  | TO DO List | weight |  | Notes
 |  | Shipment 1 | 20LB
 |  | Shipment 2 | 40LB
 |  | Shipment 3 | 50LB
 |  | Shipment 4 | 25LB
 |  | Shipment 5 | 35LB
 |  | Shipment 6 | 15LB
 |  | Shipment 7 | 100LB
 |  | Shipment 8 | 75LB
 |  | Shipment 9 | 55LB
 |  | Shipment 10 | 105LB
 |  | Shipment 11 | 40LB
 |  | Shipment 12 | 50LB
 |  | Shipment 13 | 200LB
 |  | Shipment 14 | 50LB
 |  | Shipment 15 | 125LB
 |  | Shipment 16 | 55LB
 |  | Shipment 17 | 115LB
 |  | Shipment 18 | 65LB
 |  | Shipment 19 | 95LB
 |  | Shipment 20 | 85LB
Spreadsheet: 0c3bd23b-ad72-4b03-9ba6-b960a02c1d45
Sheet: Sheet1

TRANSCRIPTIONAL TERRITORIES | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  |  | germline- |  | soma- |  | unknown-
 |  |  | all |  | expressed |  | expressed |  | expressed |  | all |  | germline |  | soma
Class | all |  | genes |  | genes |  | genes |  | genes |  | intergenic regions |  | intergenic regions |  | intergenic regions
INE | 386 | (42%) | 120 | (40.5%) | 50 | (61%) | 18 | (30.5%) | 52 | (33.5%) | 266 | (42.6%) | 128 | (49%) | 138 | (38%)
IR | 176 | (19.1%) | 66 | (22.3%) | 14 | (17.1%) | 12 | (20.3%) | 40 | (25.8%) | 110 | (17.6%) | 46 | (17.6%) | 64 | (17.6%)
Retroviral | 174 | (18.9%) | 47 | (15.9%) | 3 | (3.7%) | 12 | (20.3%) | 32 | (20.6%) | 127 | (20.4%) | 47 | (18%) | 80 | (22%)
non-LTR | 167 | (18.2%) | 52 | (17.6%) | 10 | (12.2%) | 14 | (23.7%) | 28 | (18.1%) | 115 | (18.4%) | 38 | (14.6%) | 77 | (21.2%)
Foldback | 11 | (1.2%) | 8 | (2.7%) | 2 | (2.4%) | 3 | (5.1%) | 3 | (1.9%) | 3 | (0.5%) | 0 | (0%) | 3 | (0.8%)
MITE | 6 | (0.7%) | 3 | (1%) | 3 | (3.7%) | 0 | (0%) | 0 | (0%) | 3 | (0.5%) | 2 | (0.8%) | 1 | (0.3%)
Total | 920 |  | 296 |  | 82 |  | 59 |  | 155 |  | 624 |  | 261 |  | 363
NON-TRANSCRIPTIONAL TERRITORIES
 |  |  |  |  | germline- |  | soma- |  | unknown-
 |  |  | all |  | expressed |  | expressed |  | expressed |  | all |  | germline |  | soma
Class | all |  | genes |  | genes |  | genes |  | genes |  | intergenic regions |  | intergenic regions |  | intergenic regions
INE | 1637 | (39.5%) | 744 | (46.5%) | 108 | (48%) | 197 | (49.6%) | 439 | (44.9%) | 893 | (35.1%) | 279 | (28.3%) | 614 | (39.5%)
IR | 761 | (18.4%) | 306 | (19.1%) | 41 | (18.2%) | 75 | (18.9%) | 190 | (19.4%) | 455 | (17.9%) | 190 | (19.3%) | 265 | (17.1%)
Retroviral | 828 | (20%) | 202 | (12.6%) | 29 | (12.9%) | 48 | (12.1%) | 125 | (12.8%) | 626 | (24.6%) | 307 | (31.1%) | 319 | (20.5%)
non-LTR | 798 | (19.3%) | 296 | (18.5%) | 41 | (18.2%) | 64 | (16.1%) | 191 | (19.5%) | 502 | (19.8%) | 191 | (19.4%) | 311 | (20%)
Foldback | 64 | (1.5%) | 36 | (2.3%) | 4 | (1.8%) | 8 | (2%) | 24 | (2.5%) | 28 | (1.1%) | 10 | (1%) | 18 | (1.2%)
MITE | 52 | (1.3%) | 15 | (0.9%) | 2 | (0.9%) | 5 | (1.3%) | 8 | (0.8%) | 37 | (1.5%) | 10 | (1%) | 27 | (1.7%)
Total | 4140 |  | 1599 |  | 225 |  | 397 |  | 977 |  | 2541 |  | 987 |  | 1554
Spreadsheet: 136177d1326461743-retrieve-row-of-data-only-when-a-certain-word-is-in-a-particular-cell-in-that-row-copy-of-example-6
Sheet: Sheet1

Date | Source | Supplier | Material Type | Assay No | [NAME] | [NAME] | Heavies | [NAME] | [NAME] | Stones | Fines | % [NAME] | % Hvy
2009-01-04 00:00:00 | Internal | R | GRANULATED ALI |  | 25.93 |  |  |  |  |  |  | 0 | 0
2009-01-05 00:00:00 | Group | A | ASR PLANT |  | 116.79 |  |  |  |  |  |  | 0 | 0
2009-01-06 00:00:00 | Group | N | +15M RESIDUE | 4695 | 25.42 | 7.81 | 5.42 | 0.32 | 0.53 | 3.55 | 0 | 0.3072383949645948 | 0.2132179386309992
2009-01-07 00:00:00 | Group | Not | 55% NF | 4691 | 47.38 | 11.89 | 5.88 | 0.82 | 1.22 | 4.3 | 3.94 | 0.2509497678345293 | 0.1241029970451667
2009-01-08 00:00:00 | Group | Not | 55% NF | 4690 | 48.4 | 14.95 | 5.1 | 0.95 | 2.37 | 4.6 | 4.19 | 0.3088842975206612 | 0.1053719008264463
2009-01-09 00:00:00 | Group | A | RESIDUE | 4692 | 25.32 | 7.01 | 4.4 | 1.35 | 3.43 | 3.29 | 4.65 | 0.2768562401263823 | 0.1737756714060032
2009-01-10 00:00:00 | Group | A | FLUFFY | 4693 | 17.16 | 3.67 | 0.3 | 0 | 0 | 0 | 0 | 0.2138694638694639 | 0.01748251748251748
2009-01-11 00:00:00 | Internal | R | GRANULATED ALI |  | 26.24 |  |  |  |  |  |  | 0 | 0
2009-01-12 00:00:00 | Group | LM | ASR PLANT |  | 20 |  |  |  |  |  |  | 0 | 0
2009-01-13 00:00:00 | NonGroup | MW | RESIDUE | 4698 | 145.84 | 2.23 | 13.25 | 4.31 | 1.73 | 11.25 | 0 | 0.01529072956664838 | 0.09085298957761931
2009-01-14 00:00:00 | NonGroup | S | RESIDUE | 4700 | 125.2 | 5.54 | 11.33 | 3.22 | 2.14 | 7.96 | 12.25 | 0.04424920127795527 | 0.09049520766773163
2009-01-15 00:00:00 | NonGroup | LB | RESIDUE | 4699 | 85.56 | 1.53 | 3.2 | 0.98 | 1.6 | 2.43 | 2.82 | 0.01788218793828892 | 0.03740065451145395
2009-01-16 00:00:00 | Group | LM | ASR PLANT |  | 20.56 |  |  |  |  |  |  | 0 | 0
2009-01-17 00:00:00 | Internal | R | GRANULATED ALI |  | 80.57 |  |  |  |  |  |  | 0 | 0
2009-01-18 00:00:00 | Internal | R | [NAME] |  | 14.65 |  |  |  |  |  |  | 0 | 0
2009-01-19 00:00:00 | Group | LM | ASR PLANT |  | 122.39 |  |  |  |  |  |  | 0 | 0
2009-01-20 00:00:00 | Group | A | RESIDUE | 4708 | 49.98 | 11.43 | 6.81 | 2.82 | 0.87 | 4.39 | 2.32 | 0.2286914765906363 | 0.1362545018007203
2009-01-21 00:00:00 | Group | N | 55% NF | 4704 | 48.48 | 12.35 | 7.88 | 0.7 | 1.29 | 4.55 | 4.73 | 0.2547442244224423 | 0.1625412541254125
Spreadsheet: 100896d1299105353-excel-2007-conditional-formatting-multiple-conditions-demo-customer-leads-template
Sheet: Agent 3

Lead Id | Lead Type Id | First Name | Last Name | Address | City | State | Zip | [NAME] | Phone | Inquiry Type Id | DateTimeCreated | DateTimeUpdated | Inquiry Type Name
210445 | 2 | Customer | Last Name | 124 main st | [NAME] | AR | 72082 |  |  | 5 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Home Office (home business)
210563 | 2 | Customer | Last Name | 125 main st | little rock | AR | 72206 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210593 | 2 | Customer | Last Name | 126 main st | Beebe | AR | 72012 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210621 | 2 | Customer | Last Name | 127 main st | OMAHA | AR | 72662 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210619 | 2 | Customer | Last Name | 128 main st | [NAME] | AR | 72007 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210491 | 2 | Customer | Last Name | 144 main st | Milo | IA | 50166 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210447 | 2 | Customer | Last Name | 179 main st | [NAME] | MO | 63736 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210434 | 2 | Customer | Last Name | 180 main st | [NAME] | MO | 63628 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210549 | 2 | Customer | Last Name | 181 main st | poplar bluff | MO | 63901 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210570 | 2 | Customer | Last Name | 182 main st | Bloomfield | MO | 63825 |  |  | 7 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Work from Home (telecommuter)
210583 | 2 | Customer | Last Name | 183 main st | Grassy | MO | 63751 |  |  | 4 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Residential
210507 | 2 | Customer | Last Name | 198 main st | Wildrose | ND | 58795 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210520 | 2 | Customer | Last Name | 246 main st | Howes | SD | 57748 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210635 | 2 | Customer | Last Name | 247 main st | [NAME] | SD | 57717 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
Spreadsheet: 675026d1588109641-less-than-and-greater-than-sample
Sheet: Sheet1

Entry | Exit | Duration |  | [NAME]
04/09/20 21:24:00 | 04/09/20 22:24:09 |  | if a3 - a2 is a positive number, and less than 5 minutes difference, put an "X". Otherwise, do nothing.
2020-04-09 21:29:00 | 04/10/20 19:41:50 |  | if a4 - a3 is a positive number, and less than 5 minutes difference, put an "X". Otherwise, do nothing.
04/10/20 21:27:19 | 04/10/20 21:44:24 |  | etc.
 | 04/10/20 22:21:52 | 0:00:00 | etc.
04/11/20 16:23:53 | 04/11/20 18:11:49 |  | etc.
04/11/20 18:30:16 | 04/11/20 19:15:03 |  | etc.
Spreadsheet: 274928d1383265647-extract-certain-data-from-a-column-dependent-on-another-column-to-another-sheet-drafting-report-beta-1-
Sheet: WD' In Progress

Working Drawings In Progress
Drafty | Job number
Spreadsheet: 826893d1682357188-monthly-headcount-by-teams-by-month-and-quarter-headcount-analysis
Sheet: Desired Pivot Format

 |  | Q1 2023 |  | Q2 2023 |  | Q3 2023 |  | Q4 2023
Team | Emp Type | Count | FTE-CTR % | Count | FTE-CTR % | Count | FTE-CTR % | Count | FTE-CTR %
Green | CTR | 36 | 0.06857142857142857 | 36 | 0.06857142857142857 | 36 | 0.06857142857142857 | 36 | 0.06857142857142857
 | FTE | 57 | 0.1085714285714286 | 57 | 0.1085714285714286 | 57 | 0.1085714285714286 | 57 | 0.1085714285714286
Purple | CTR | 72 | 0.1371428571428571 | 72 | 0.1371428571428571 | 72 | 0.1371428571428571 | 72 | 0.1371428571428571
 | FTE | 48 | 0.09142857142857143 | 48 | 0.09142857142857143 | 48 | 0.09142857142857143 | 48 | 0.09142857142857143
Red | CTR | 75 | 0.1428571428571428 | 75 | 0.1428571428571428 | 75 | 0.1428571428571428 | 75 | 0.1428571428571428
 | FTE | 57 | 0.1085714285714286 | 57 | 0.1085714285714286 | 57 | 0.1085714285714286 | 57 | 0.1085714285714286
Yellow | CTR | 33 | 0.06285714285714286 | 33 | 0.06285714285714286 | 33 | 0.06285714285714286 | 33 | 0.06285714285714286
 | FTE | 48 | 0.09142857142857143 | 48 | 0.09142857142857143 | 48 | 0.09142857142857143 | 48 | 0.09142857142857143
Blue | CTR | 54 | 0.1028571428571429 | 54 | 0.1028571428571429 | 54 | 0.1028571428571429 | 54 | 0.1028571428571429
 | FTE | 45 | 0.08571428571428572 | 45 | 0.08571428571428572 | 45 | 0.08571428571428572 | 45 | 0.08571428571428572
Issue: It's summing the months for the quarter showing triple headcount. Should be an average or just actual headcount.
Spreadsheet: 136814d1326831836-chart-adm-and-vst-chart
Sheet: Sheet1

 |  |  |  |  | [NAME] | 1267 | 96
 |  |  |  |  | Burns | 750 | 151
 |  |  |  |  | Croce | 1445 | 97
 |  |  |  |  | [NAME] | 568 | 103
 |  |  |  |  | [NAME] | 666 | 7
 |  |  |  |  | Carroll | 902 | 62
 |  |  |  |  | [NAME] | 1380 | 105
 |  |  |  |  | Sargent | 333 | 5
 |  |  |  |  | Digiovan | 1230 | 84
 |  |  |  |  | [NAME] | 259 | 16
 |  |  |  |  | Shiho | 790 | 1
 |  |  |  |  | Kouagheu | 908 | 48
 |  |  |  |  | [NAME] | 141 | 3
Spreadsheet: 38809d1236955065-commission-calculation-dialer-revenue-calc
Sheet: Sheet1

Dialer Revenue | Comp %
0-10000 | 0 |  | Office Expenses
10000-15000 | 0.3
15000-20000 | 0.28 |  | Dialer Revenue
20000-25000 | 0.26
25000-30000 | 0.24 |  | March's Share
30000-35000 | 0.22
35000-40000 | 0.2 |  | Boney/Hobby Share
40000-45000 | 0.18
45000-50000 | 0.16
50000-55000 | 0.14
55000-60000+ | 0.12
Spreadsheet: 99431d1298048780-excel-2007-hlookup-based-on-max-experimenting-with-excel
Sheet: Sheet1

Number of patient visits to clinic by week
week | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | 2011-01-17 00:00:00 | 2011-01-24 00:00:00 | 2011-01-31 00:00:00 | 2011-02-07 00:00:00 | 2011-02-14 00:00:00 | 2011-02-21 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00
North | 10 | 35 | 73 | 65 | 51 | 49 | 39 | 61 | 13 | 45 | 49
East | 12 | 41 | 31 | 49 | 55 | 47 | 53 | 40 | 65 | 44 | 49
Total
week | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | 2011-01-17 00:00:00 | 2011-01-24 00:00:00 | 2011-01-31 00:00:00 | 2011-02-07 00:00:00 | 2011-02-14 00:00:00 | 2011-02-21 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00
 | [NAME] | Date | ShouldBe
North
East |  |  | ok
Total |  |  | 2011-01-24 00:00:00
Spreadsheet: 675913d1588554403-formulas-to-apply-conditional-formatting-and-summing-based-on-checkmark-sample-data
Sheet: Tracking

 | With conditional foratting and control checkboxes |  |  |  |  | With checkmarks but no conditional formatting
 | Sample | True | 100 | 2020-05-01 00:00:00 |  |  | Sample | 100 | 2020-05-01 00:00:00
 | Sample | False | 100 | 2020-05-01 00:00:00 |  |  | Sample | 100 | 2020-05-01 00:00:00
 | Sample | False | 100 | 2020-05-04 00:00:00 |  |  | Sample | 100 | 2020-05-04 00:00:00
 | Sample | True | 100 | 2020-05-04 00:00:00 |  |  | Sample | 100 | 2020-05-04 00:00:00
 | Sample | False | 100 | 2020-05-05 00:00:00 |  |  | Sample | 100 | 2020-05-05 00:00:00
 | Sample | False | 100 | 2020-05-05 00:00:00 |  |  | Sample | 100 | 2020-05-05 00:00:00
 | Sample | False | 100 | 2020-05-05 00:00:00 |  |  | Sample | 100 | 2020-05-05 00:00:00
 | Sample | False | 100 | 2020-05-05 00:00:00 |  |  | Sample | 100 | 2020-05-05 00:00:00
 | Sample | False | 100 | 2020-05-07 00:00:00 |  |  | Sample | 100 | 2020-05-07 00:00:00
 | Sample | False | 100 | 2020-05-08 00:00:00 |  |  | Sample | 100 | 2020-05-08 00:00:00
 | Sample | False | 100 | 2020-05-08 00:00:00 |  |  | Sample | 100 | 2020-05-08 00:00:00
 | Sample | False | 100 | 2020-05-17 00:00:00 |  |  | Sample | 100 | 2020-05-17 00:00:00
 | Sample | False | 100 | 2020-05-19 00:00:00 |  |  | Sample | 100 | 2020-05-19 00:00:00
 | Sample | False | 100 | 2020-05-20 00:00:00 |  |  | Sample | 100 | 2020-05-20 00:00:00
 | Sample | False | 100 | 2020-05-20 00:00:00 |  |  | Sample | 100 | 2020-05-20 00:00:00
 | Sample | False | 100 | 2020-05-28 00:00:00 |  |  | Sample | 100 | 2020-05-28 00:00:00
 | Sample | False | 100 | 2020-05-30 00:00:00 |  |  | Sample | 100 | 2020-05-30 00:00:00
Spreadsheet: 812264d1673031464-i-need-formula-to-look-for-value-in-column-and-return-value-in-another-column-example
Sheet: Sheet2

cm | Liters | cm | Liters | cm | Liters | cm | Liters | cm | Liters | cm | Liters
300 | 3029450 | 350 | 3538589 | 400 | 4047727 | 450 | 4557089 | 500 | 5066471 | 550 | 5575853
301 | 3039633 | 351 | 3548771 | 401 | 4057910 | 451 | 4567277 | 501 | 5076659 | 551 | 5586041
302 | 3049816 | 352 | 3558954 | 402 | 4068092 | 452 | 4577465 | 502 | 5086846 | 552 | 5596228
303 | 3059999 | 353 | 3569137 | 403 | 4078275 | 453 | 4587652 | 503 | 5097034 | 553 | 5606416
304 | 3070181 | 354 | 3579320 | 404 | 4088458 | 454 | 4597840 | 504 | 5107222 | 554 | 5616604
305 | 3080364 | 355 | 3589502 | 405 | 4098646 | 455 | 4608028 | 505 | 5117409 | 555 | 5626791
306 | 3090547 | 356 | 3599685 | 406 | 4108833 | 456 | 4618215 | 506 | 5127597 | 556 | 5636979
307 | 3100730 | 357 | 3609868 | 407 | 4119021 | 457 | 4628403 | 507 | 5137785 | 557 | 5647166
308 | 3110912 | 358 | 3620051 | 408 | 4129209 | 458 | 4638590 | 508 | 5147972 | 558 | 5657354
309 | 3121095 | 359 | 3630234 | 409 | 4139396 | 459 | 4648778 | 509 | 5158160 | 559 | 5667542
 |  |  |  |  |  |  |  | AVERAGE  MILLIMETRES
 |  |  |  |  |  |  |  | 1 | 1019 | 6 | 6117
 |  |  |  |  |  |  |  | 2 | 2039 | 7 | 7136
 |  |  |  |  |  |  |  | 3 | 3058 | 8 | 8156
 |  |  |  |  |  |  |  | 4 | 4078 | 9 | 9175
 |  |  |  |  |  |  |  | 5 | 5097 | 0 | 0
 | for example 302cm and 2 millimeters is equal to 3051855 Liters
 | Search
 | cm | [NAME] | RESULT
 | 302 | 2
Spreadsheet: 888398d1738874801-copie-with-special-format-livro1
Sheet: Folha1

 |  |  |  |  | GROUP | DATA | VALOR
 |  |  |  |  | A | 2025-01-01 00:00:00 | 120
 |  |  |  |  |  | 2025-01-15 00:00:00 | 83
 |  |  |  |  |  | 2025-02-02 00:00:00 | 83
 |  |  |  |  | B | 2025-01-02 00:00:00 | 121
 |  |  |  |  |  | 2025-02-03 00:00:00 | 75
 |  |  |  |  | C | 2025-01-03 00:00:00 | 122
 |  |  |  |  | D | 2025-01-04 00:00:00 | 123
 |  |  |  |  | E | 2025-01-05 00:00:00 | 124
 |  |  |  |  | F | 2025-01-06 00:00:00 | 125
Spreadsheet: 04626cb6-95da-4920-a41e-ae4c11f007c3
Sheet: Sheet1

Robbery | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 6.464617211297505 | 11.47118946666252 | 1.214431023485193
13-14 | 168.2651044750004 | 287.8825341050682 | 42.64230284396284
15 | 320.8268095932474 | 564.7798439694528 | 63.74773512138561
16 | 388.0402126231566 | 695.670019985008 | 61.83583020960305
17 | 401.0564741565273 | 728.9049043714701 | 52.02595854047735
18 | 388.045193480792 | 715.3563774470962 | 43.91205913618861
19 | 318.5173009842086 | 585.8513804599875 | 39.73930332040574
20 | 257.9519060265126 | 473.0164276317503 | 33.46151363979922
21 | 225.4938387801988 | 415.2484297746124 | 27.44914562679893
22 | 206.3444219502298 | 373.0198506091162 | 33.89836907527381
23 | 189.7371622488104 | 343.645687214286 | 31.10068311387559
24 | 172.4535298603966 | 312.0693814219514 | 29.14883066107938
25-29 | 147.6255703668154 | 265.6355918717863 | 28.74212362420425
30-34 | 96.84973909616339 | 172.7984040707093 | 21.31889303430786
35-39 | 57.0538005044337 | 101.6410230757901 | 12.95791234477288
40-44 | 28.30528742496073 | 51.66660085872164 | 5.499412291882195
45-49 | 13.21621664626564 | 24.58087340582509 | 2.260953422727261
50-54 | 6.389127096829571 | 12.01076090224339 | 1.07002428742163
55-59 | 2.655156725538651 | 5.065695473115368 | 0.4341722148894048
60-64 | 1.543630902622708 | 3.138042251349367 | 0.133241267351882
65 and over | 0.6440659267951252 | 1.389027227260879 | 0.1361703928181045
Spreadsheet: 851697d1701869448-chronological-order-for-a-criteria-by-customer-id-excel-forum-14-aligw
Sheet: Sheet1

Client ID | Invoice date (month/day/year) | Cronological order of invoices by client
A | 2023-02-05 00:00:00
B | 2020-02-12 00:00:00 |  |  | 1
C | 2021-02-18 00:00:00 |  |  | 1
D | 2020-01-10 00:00:00 |  |  | 1
A | 2020-01-27 00:00:00 |  |  | 1
A | 2020-03-05 00:00:00 |  |  | 2
A | 2021-07-31 00:00:00 |  |  | 3
C | 2021-03-31 00:00:00 |  |  | 2
Spreadsheet: 794244d1661954129-how-to-change-from-one-table-to-another-table-h831-1
Sheet: Sheet1

DATE | MR Q | MR X | MS Y |  |  | DATE | QTY | NAME |  | TABLE 2
44800 | 1 | 58 |  |  |  | 44800 | 1 | MR Q
44801 | 2 | 59 | 35 |  |  | 44801 | 2 | MR Q
44802 | 3 | 60 | 36 |  |  | 44802 | 3 | MR Q
44803 |  | 61 | 37 |  |  | 44803 |  | MR Q
44804 | 5 | 62 | 38 |  |  | 44804 | 5 | MR Q
44805 | 6 | 63 | 39 |  |  | 44805 | 6 | MR Q
44806 | 7 |  | 40 |  |  | 44806 | 7 | MR Q
44807 | 8 | 65 | 41 |  |  | 44807 | 8 | MR Q
44808 | 9 | 66 | 42 |  |  | 44808 | 9 | MR Q
44809 | 10 | 67 | 43 |  |  | 44809 | 10 | MR Q
 |  |  |  |  |  | 44800 | 58 | MR X
 | TABLE 1 |  |  |  |  | 44801 | 59 | MR X
 |  |  |  |  |  | 44802 | 60 | MR X
 |  |  |  |  |  | 44803 | 61 | MR X
 |  |  |  |  |  | 44804 | 62 | MR X
 |  |  |  |  |  | 44805 | 63 | MR X
 |  |  |  |  |  | 44806 |  | MR X
 |  |  |  |  |  | 44807 | 65 | MR X
 |  |  |  |  |  | 44808 | 66 | MR X
 |  |  |  |  |  | 44809 | 67 | MR X
 |  |  |  |  |  | 44800 |  | MS Y
 |  |  |  |  |  | 44801 | 35 | MS Y
 |  |  |  |  |  | 44802 | 36 | MS Y
 |  |  |  |  |  | 44803 | 37 | MS Y
 |  |  |  |  |  | 44804 | 38 | MS Y
 |  |  |  |  |  | 44805 | 39 | MS Y
 |  |  |  |  |  | 44806 | 40 | MS Y
 |  |  |  |  |  | 44807 | 41 | MS Y
 |  |  |  |  |  | 44808 | 42 | MS Y
 |  |  |  |  |  | 44809 | 43 | MS Y