tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 494f33cf-8298-4e8a-8e3c-145e96f937c8
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
SRW | Test | SRW | Short Ragweed, IgE | Short Ragweed, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
SRW | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SRW | Result | SRW | Short Ragweed, IgE | Short Ragweed, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6085-5 | Ambrosia elatior [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 817691d1676392193-extract-multiple-words-from-text-string-example1-1-ans
Sheet: Sheet1

 |  |  | Required |  | FORMULA
 | OVERALL GROSS WINNER (Stroke) |  | 36 Gross Stroke
 | OVERALL NETT WINNER (Stroke) |  | 36 [NAME]
 | OVERALL GROSS RUNNER-UP (Stroke) |  | 36 Gross Stroke
 | OVERALL NETT RUNNER-UP (Stroke) |  | 36 [NAME]
 | OVERALL NETT 3RD (Stroke) |  | 36 [NAME]
 | OVERALL GROSS 3RD (Stroke) |  | 36 Gross Stroke
 | SENIOR GROSS WINNER (Stroke) |  | 36 Gross Stroke
 | SENIOR NETT WINNER (Stroke) |  | 36 [NAME]
 | OVERALL NETT 4TH (Stroke) |  | 36 [NAME]
 | OVERALL GROSS 4TH (Stroke) |  | 36 Gross Stroke
 | TUESDAY NETT WINNER (Stroke) |  | [NAME]
 | MONDAY NETT WINNER (Stroke) |  | Mon Nett Stroke
 | OVERALL NETT WINNER (Sford) |  | 36 [NAME]
 | OVERALL NETT RUNNER-UP (Sford) |  | 36 [NAME]
 | OVERALL NETT 3RD (Sford) |  | 36 [NAME]
 | OVERALL NETT 4TH (Sford) |  | 36 [NAME]
 | OVERALL GROSS WINNER (Sford) |  | 36 Gross Sford
 | OVERALL NETT 5TH (Sford) |  | 36 [NAME]
 | OVERALL NETT 6TH (Sford) |  | 36 [NAME]
 | SENIOR GROSS WINNER (Sford) |  | 36 Gross Sford
 | SENIOR NETT WINNER (Sford) |  | 36 [NAME]
 | OVERALL GROSS RUNNER-UP (Sford) |  | 36 Gross Sford
 | TUESDAY NETT WINNER (Sford) |  | [NAME]
 | MONDAY NETT WINNER (Sford) |  | [NAME]
Spreadsheet: 0583fdbb-7309-41eb-b242-2dcfeb8b99c4
Sheet: Obj Emp 

Survey of all Currently enrolled students Fall 2012 -- Objectives and Employment
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total |  | Obtaining  transfer credits is the most common goal.
Total
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total |  | Online students are more likely to be full time workers.
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total |  | Larimer students are most likely to be full-time students
Spreadsheet: 873020d1719473183-output-based-on-the-leading-status-excel-formula-with-condition
Sheet: Sheet1

TB Cash | TB Trade | DCDA | CC | FM | Output
Completed | Completed | Completed | Completed | Completed | Completed
Completed | Overdue | In Progress | Completed | Not Started | Overdue
At Risk | Completed | In Progress | Completed | Completed | At Risk
Completed | Completed | In Progress | Completed | Completed | In Progress
 |  |  |  |  | Not Started
Spreadsheet: 4584ee73-80da-4500-b764-06ba6186376d
Sheet: Legend

Supplementary Table 1
CNV Burden Statistics for Utah Cohort
Contained within this file are several subtables supporting the CNV burden tests reported in the main text. Each worksheet (subtable) contains summary statistics for a different subset of CNVs, selected by size and/or frequency.
Subtables
Name | Description
all_sums | The complete set of CNVs for this cohort
5p_sums | All CNVs with call frequency less than 5 percent
100kb_5p_sums | All CNVs with call frequency less than 5 percent and greater than 100kb in size
Legend
Variable | Description
class | Genomic location and "type" of CNV (deletions or duplications)
size | Size threshold for inclusion of CNV into analysis
ncnv | Total number of calls made in this class (cases + controls)
a_rate | Average number of CNVs in azoospermic cases
o_rate | Average number of CNVs in oligozoospermic cases
c_rate | Average number of CNVs in normospermic controls
co_pv | p-value of test comparing rates in combined azoo+ozoo cases versus controls
p_oa | p-value of test comparing rates in azoospermic versus oligozoospermic cases
a_totkb | Average total amount of aneuploid sequence in azoospermic cases
o_totkb | Average total amount of aneuploid sequence in oligozoospermic cases
c_totkb | Average total amount of aneuploid sequence in normospermic controls
p_totkb | p-value of test comparing total amount of aneuploid sequence in combined cases versus controls (a_totkb+o_totkb vs c_totkb)
Spreadsheet: 269690d1381249209-index-match-or-maybe-a-differnt-formula-to-look-up-multiple-criteria-dsl-test
Sheet: Sheet2

Component | Tier | 3 | 5
DM15B | 3-15 | 60.09 | 71.03
DM1B | 1-6 | 56.92 | 67.28
DM4B | 1-6 | 56.92 | 67.28
DS1B | 1-6 | 56.92 | 67.28
DS1FIRE | 1-6 | 56.92 | 67.28
DS2 | 1-6 | 56.92 | 67.28
[NAME] | 1-6 | 56.92 | 67.28
DS5RU | 1-6 | 56.92 | 67.28
DS6 | 1-6 | 56.92 | 67.28
DSLSUB | 1-6 | 56.92 | 67.28
DSLVPKG | 1-6 | 56.92 | 67.28
I10M1 | 3-15 | 60.09 | 71.03
I10M1B | 3-15 | 60.09 | 71.03
I10M1E | 3-15 | 60.09 | 71.03
I10M5B | 3-15 | 60.09 | 71.03
I10MB | 3-15 | 60.09 | 71.03
I128K | 1-6 | 56.92 | 67.28
I14M | 3-15 | 60.09 | 71.03
I1751 | 1-6 | 56.92 | 67.28
I1M | 1-6 | 56.92 | 67.28
I20M1B | 5-50 | 77.13 | 91.17
I2M | 1-6 | 56.92 | 67.28
I2MB | 1-6 | 56.92 | 67.28
I2MBF | 1-6 | 56.92 | 67.28
I2ME | 1-6 | 56.92 | 67.28
I4M | 1-6 | 56.92 | 67.28
[NAME] | 1-6 | 56.92 | 67.28
Spreadsheet: 46258d1245161053-working-hr-calculate-time
Sheet: Sheet1

In Time | Out Time | Working Hr. | In Time | Out Time | Working Hr. | In Time | Out Time | Working Hr. | In Time | Out Time | Working Hr.
14:29:00 | 23:41:00 |  | 14:45:00 | 23:42:00 |  | 14:57:00 | 23:41:00 |  | 16:58:00 | 03:13:00
19:06:00 | 03:28:00 |  | 12:35:00 | 22:27:00 |  | 14:54:00 | 00:49:00 |  | 19:02:00 | 03:32:00
23:01:00 | 09:01:00 |  | 23:03:00 | 08:01:00 |  | 00:01:00 | 08:01:00 |  | 23:03:00 | 09:01:00
17:02:00 | 02:06:00 |  | 17:05:00 | 02:03:00 |  | 17:03:00 | 02:19:00 |  | 17:05:00 | 01:01:00
15:32:00 | 01:37:00 |  | 15:32:00 | 03:15:00 |  | 15:31:00 | 01:17:00 |  | 15:47:00 | 01:57:00
00:34:00 | 08:39:00 |  | 00:17:00 | 08:03:00 |  | 00:34:00 | 10:34:00 |  | 21:55:00 | 10:14:00
16:18:00 | 01:29:00 |  | 20:08:00 | 02:18:00 |  | 15:46:00 | 00:51:00 |  | 15:42:00 | 02:05:00
23:44:00 | 08:39:00 |  | 00:05:00 | 08:47:00 |  | 00:21:00 | 09:15:00 |  | 00:29:00 | 08:07:00
09:27:00 | 18:42:00 |  | 09:23:00 | 18:03:00 |  | 09:28:00 | 18:34:00 |  | 09:16:00 | 18:14:00
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: Feb 17,18,19

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-02-17 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid: |  |  |  | Allocations took longer due to viewing  of Ventura by [NAME] and  Mkt Service Reps
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | Timely cycle allocations rolled back twice due to primary firm being cut at VENTURA.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  | [NAME]  6:30 - 3:30
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] 9:30 - 6:30
 |  |  |  |  | [NAME] 1:00 - 10:00
 |  |  |  |  | [NAME] 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | Allocation  process was delayed due to [NAME] problems and slow response time, but
 | 7:00 A.M. Non-grid: |  |  |  | process did complete at 9:00 am
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | [NAME] was down when the reps came in at 6:30 am,  some reps could get into hottap at various times.
 |  |  |  |  | Also, external customers had problems getting into Hottap since 5:00 am.
 |  |  |  |  | Several question from WPS Energy on allocation cuts @ Ventura.
 | On Call Reps: |  |  |  | [NAME]  6:30 - 3:30
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] 9:30 - 6:30
 |  |  |  |  | [NAME] 1:00 - 10:00
 |  |  |  |  | [NAME] 1:00 - 10:00
MONDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid: |  |  |  | took additional time to view Ventura allocation
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | when doing manual scheduling system took long time to save
 |  |  |  |  | [NAME]  6:30 - 3:30
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] 9:30 - 6:30
 |  |  |  |  | [NAME] 1:00 - 10:00
 |  |  |  |  | [NAME] 1:00 - 10:00
Spreadsheet: 162803d1340080225-excel-2007-how-to-fix-if-index-match-mjc-registro-interactivo
Sheet: DistNotas

[NAME]
[NAME] A Mayo
Por Grupo
2do R
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
Porcientos |  |  |  |  |  |  |  |  |  |  |  | %ABC
TOTAL % |  |  |  |  |  |  |  |  |  |  |  | %DF
2do M
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
3ro R
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
3ro D
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
4to G
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
[NAME]
2do R-M
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
3ro R-D
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
Spreadsheet: 156666d1337372456-aligning-information-scattered-throughout-a-row-into-uniform-columns-quoteproductioncapacity
Sheet: Production Schedule

DUE DATE | PART NUMBER | SAW | LATHE | MILL | EDM
2012-05-21 00:00:00 | 000-001
2012-05-22 00:00:00 | XYZ-001
2012-05-23 00:00:00 | 123-001
2012-05-24 00:00:00 | XYZ-002
2012-05-25 00:00:00 | XYZ-002
2012-05-26 00:00:00 | 000-002
2012-05-27 00:00:00 | 123-002
2012-05-28 00:00:00 | XYZ-003
2012-05-29 00:00:00 | 000-004
2012-05-30 00:00:00 | 000-003
2012-05-31 00:00:00 | XYZ-004
 |  |  |  |  |  | TOTAL
Spreadsheet: 50137d1249529090-recording-difference-in-multiple-time-entries-time-sample-4
Sheet: Sheet1

Hours and minutes are entered as per the 24 hour clock i.e. 18:30 or 09:15. They hours and minutes are in separate cells for ease of data entry.
Available hours are reported as hours and minutes
 | Default availability | Time | Elapsed |  | Default availability | Time | Elapsed |  | Default availability | Time | Elapsed |  | Default availability | Time | Elapsed
 | Open 1 | 06:15:00 |  |  | Open 1 | 06:15:00 |  |  | Open 1 | 06:15:00 |  |  | Open 1 | 06:15:00
 | Close 1 | 18:30:00 | 12:15:00 |  | Close 1 | 08:30:00 | 02:15:00 |  | Close 1 | 08:30:00 | 02:15:00 |  | Close 1 | 08:30:00 | 02:15:00
 | Open 2 |  |  |  | Open 2 |  |  |  | Open 2 | 10:45:00 |  |  | Open 2 | 10:45:00
 | Close 2 |  |  |  | Close 2 |  |  |  | Close 2 | 18:30:00 | 07:45:00 |  | Close 2 | 14:25:00 | 03:40:00
 | Open 3 |  |  |  | Open 3 |  |  |  | Open 3 |  |  |  | Open 3 | 16:40:00
 | Close 3 |  |  |  | Close 3 |  |  |  | Close 3 |  |  |  | Close 3 | 18:30:00 | 01:50:00
 | Availability |  | 12:15:00 |  |  |  | 02:15:00 |  |  |  | 10:00:00 |  |  |  | 07:45:00
Spreadsheet: 684560d1593443459-how-to-distribute-values-equally-in-excel-master-sheet-for-contractor-bills-v1
Sheet: Sheet2

Layer | Chainage |  |  | Distributed
 | From | To | Qty |  |  |  |  |  |  | Chainage | 1st Layer | 2nd Layer | 3rd Layer | 4th layer
1st Layer | 32000 | 32100 | 850 |  |  |  |  |  |  | 32000
2nd Layer | 32000 | 32100 | 840 |  |  |  |  |  |  | 32010
1st Layer | 32150 | 32190 | 300 |  |  |  |  |  |  | 32020
2nd Layer | 32160 | 32180 | 150 |  |  |  |  |  |  | 32030
3rd Layer | 32010 | 32080 | 150 |  |  |  |  |  |  | 32040
 |  |  |  |  |  |  |  |  |  | 32050
 |  |  |  |  |  |  |  |  |  | 32060
 |  |  |  |  |  |  |  |  |  | 32070
 |  |  |  |  |  |  |  |  |  | 32080
 |  |  |  |  |  |  |  |  |  | 32090
 |  |  |  |  |  |  |  |  |  | 32100
 |  |  |  |  |  |  |  |  |  | 32110
 |  |  |  |  |  |  |  |  |  | 32120
 |  |  |  |  |  |  |  |  |  | 32130
 |  |  |  |  |  |  |  |  |  | 32140
 |  |  |  |  |  |  |  |  |  | 32150
 |  |  |  |  |  |  |  |  |  | 32160
 |  |  |  |  |  |  |  |  |  | 32170
 |  |  |  |  |  |  |  |  |  | 32180
 |  |  |  |  |  |  |  |  |  | 32190
 |  |  |  |  |  |  |  |  |  | 32200
Spreadsheet: 778535d1651144077-average-data-to-transfer-from-one-cell-to-another-book1
Sheet: Sheet1

Date | Number
2021-02-04 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-05 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-06 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-07 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-08 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-09 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-10 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-11 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-01-04 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
2021-01-05 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
2021-01-06 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
2021-01-07 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
2021-01-08 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
2021-01-09 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
2021-01-10 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
2021-01-11 00:00:00 | 34 |  |  | 2021-01-01 00:00:00
Spreadsheet: 58425d1258655587-how-to-return-the-first-x-numbers-from-a-range-list-excel-doubt2
Sheet: Sheet1

 | MIN | MAX | AMOUNT
 | 1 | 18 | 12.6 | --> 70% of the MAX value
 | LIST |  | FORMULA? |  | --> I need a formula where it returns a list with the first 13 numbers from a range from 1 to 18 (MIN and MAX range)
 | 142 |  |  |  | (it needs to be authomatic, because in the future I would change the MAX value from 18 to other number that could go up to 160)
 | 45
 | 14 |  |  |  | Just in case it helps, I am using it to build a model where the MAX are the number of data I have, but I only want to use random 70% (AMOUNT) of the data to build the model
 | 83
 | 124
 | 121
 | 11
 | 74
 | 13
 | 90
 | 28
 | 81
 | 21
 | 89
 | 111
 | 3
 | 73
 | 1
 | 103
 | 126
 | 41
 | 91
 | 44
 | 50
 | 47
 | 82
 | 100
 | 87
 | 54
 | 15
 | 68
 | 5
 | 86
 | 113
 | 156
 | 29
 | 33
 | 49
 | 75
 | 34
 | 30
 | 150
 | 55
 | 56
 | 7
 | 132
 | 65
 | 140
 | 53
 | 157
 | 61
 | 72
 | 27
 | 24
 | 22
 | 63
 | 154
 | 95
 | 115
 | 84
 | 17
 | 76
 | 145
 | 97
 | 70
 | 153
 | 18
 | 6
 | 152
 | 101
 | 123
 | 125
 | 127
 | 77
 | 159
 | 8
 | 20
 | 138
 | 131
 | 4
 | 19
 | 37
 | 143
 | 57
 | 147
 | 149
 | 25
 | 42
 | 78
 | 129
 | 80
 | 69
 | 94
 | 104
 | 102
 | 58
 | 139
 | 98
 | 64
 | 120
 | 38
 | 39
 | 108
 | 158
 | 105
 | 2
 | 134
 | 144
 | 46
 | 110
 | 122
 | 99
 | 151
 | 43
 | 133
 | 26
 | 23
 | 51
 | 146
 | 135
 | 107
 | 93
 | 137
 | 60
 | 35
 | 62
 | 79
 | 9
 | 116
 | 128
 | 148
 | 32
 | 66
 | 118
 | 16
 | 155
 | 136
 | 85
 | 88
 | 48
 | 92
 | 106
 | 67
 | 117
 | 36
 | 96
 | 40
 | 10
 | 112
 | 12
 | 119
 | 114
 | 130
 | 59
 | 52
 | 141
 | 109
 | 31
 | 71
 | 160
Spreadsheet: 300396d1393456214-how-to-get-invoice-amount-with-corresponding-date-range-300389d1393454261-how-to-get-invoice-amount-with-corresponding-date-range-excel-question
Sheet: Sheet1

Invoice Number | [NAME] From/Bill To |  |  | Invoice Amount | Dec '13 | Jan '14 | Feb '14
1 | 01/01/2014 00:00 | 2014-01-01 00:00:00 |  | 38764.68
 | 01/02/2014 00:00 | 2014-01-02 00:00:00
2 | 12/30/2013 00:00 | 2013-12-30 00:00:00 |  | 61931.81
 | 01/01/2014 00:00 | 2014-01-01 00:00:00
3 | 01/01/2014 00:00 | 2014-01-01 00:00:00 |  | 8190.06
 | 01/02/2014 00:00 | 2014-01-02 00:00:00
Spreadsheet: 873303d1719801207-two-formulas-test-copy
Sheet: Tab 1

Date | 1 | 2 | 3 | 4 | 5 | 6
2024-01-01 00:00:00 | 1 | 2 | 3 | 4 | 5 | 6
2024-01-02 00:00:00 | 1 | 2 | 3 | 4 | 5 | 45
2024-01-03 00:00:00 | 9 | 9 | 9 | 9 | 9 | 9
2024-01-04 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-05 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-06 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-07 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-08 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-09 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-10 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-11 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
2024-01-12 00:00:00 | 3 | 7 | 15 | 27 | 35 | 40
Spreadsheet: 688469d1595804203-conditional-formatting-not-formatting-all-it-should-be-formatting-needhelpon
Sheet: Sheet1

7/23/2020 |  | Week > | Current & Late | 1 out | 2 out | 3 out
2020 |  | $ Needed >
 |  | $ Available > | 2200
NOTE  -
Week begins on Monday |  | Week #   >
 |  | Mon         >
 |  | Sunday   >
Name | Due Date | $
[NAME] | 2020-06-20 00:00:00 | 648
Sandy | 2020-07-30 00:00:00 | 30.05
[NAME] | 2020-08-01 00:00:00 | 971.75
Benson & Sons | 2020-06-01 00:00:00 | 188.34
Larue | 2020-05-08 00:00:00 | 257.66
BBB | 2020-08-01 00:00:00 | 399
Spreadsheet: 491904d1480692331-tracking-theh-trend-for-overdue-deadlines-and-how-many-closed-in-a-given-week-maint-table
Sheet: Sheet2

Count of Overdue/On Time | Column Labels
Row Labels | OD | OT | Grand Total
2016-11-03 00:00:00 |  | 3 | 3
2016-11-04 00:00:00 | 2 | 1 | 3
2016-11-05 00:00:00 | 5 | 12 | 17
2016-11-06 00:00:00 | 3 | 6 | 9
2016-11-07 00:00:00 | 23 | 2 | 25
2016-11-08 00:00:00 | 8 | 7 | 15
2016-11-09 00:00:00 | 9 | 10 | 19
2016-11-10 00:00:00 | 9 | 4 | 13
2016-11-11 00:00:00 | 3 | 7 | 10
2016-11-13 00:00:00 | 3 | 1 | 4
2016-11-14 00:00:00 | 20 | 5 | 25
2016-11-15 00:00:00 | 5 | 6 | 11
2016-11-16 00:00:00 | 12 | 6 | 18
2016-11-17 00:00:00 | 10 | 2 | 12
2016-11-18 00:00:00 |  | 12 | 12
2016-11-19 00:00:00 | 2 |  | 2
2016-11-20 00:00:00 | 6 |  | 6
2016-11-21 00:00:00 | 3 | 7 | 10
2016-11-22 00:00:00 |  | 20 | 20
2016-11-23 00:00:00 | 10 | 10 | 20
2016-11-24 00:00:00 | 12 | 1 | 13
2016-11-25 00:00:00 | 8 |  | 8
2016-11-26 00:00:00 |  | 1 | 1
2016-11-27 00:00:00 | 2 |  | 2
2016-11-28 00:00:00 | 11 |  | 11
2016-11-29 00:00:00 |  | 1 | 1
2016-11-30 00:00:00 |  | 13 | 13
2016-12-01 00:00:00 |  | 1 | 1
2016-12-12 00:00:00 |  | 1 | 1
2016-12-15 00:00:00 |  | 1 | 1
Grand Total | 166 | 140 | 306
Spreadsheet: 762963d1641918865-sum-of-values-across-multiple-sheets-sum-of-vls-mltpl-sheets
Sheet: JUL

2022-06-28 00:00:00 |  |  | 2500
2022-04-01 00:00:00 |  |  | 1250
2022-06-29 00:00:00 |  |  | 54.01600000000001
2022-07-01 00:00:00 |  |  | 3500
2022-07-01 00:00:00 |  |  | 932.45
2022-07-01 00:00:00 |  |  | 1284
2022-07-01 00:00:00 |  |  | 750
2022-07-01 00:00:00 |  |  | 20
2022-07-01 00:00:00 |  |  | 350
2022-07-01 00:00:00 |  |  | 550
2022-07-02 00:00:00 |  |  | 4.037696
2022-07-04 00:00:00 |  |  | 150
2022-07-04 00:00:00 |  |  | 11
2022-07-04 00:00:00 |  |  | 1250
2022-07-06 00:00:00 |  |  | 2278.62
2022-07-06 00:00:00 |  |  | 2323
2022-07-08 00:00:00 |  |  | 80
2022-07-08 00:00:00 |  |  | 80
2022-07-10 00:00:00 |  |  | 7
2022-07-11 00:00:00 |  |  | 2030
2022-07-11 00:00:00 |  |  | 1250
2022-07-13 00:00:00 |  |  | 16.98
2022-07-13 00:00:00 |  |  | 3885.5
2022-07-15 00:00:00 |  |  | 16
2022-07-16 00:00:00 |  |  | 300
2022-07-18 00:00:00 |  |  | 155.85
2022-07-18 00:00:00 |  |  | 1250
2022-07-25 00:00:00 |  |  | 1250
Spreadsheet: 856752d1705941748-multiple-criteria-data-validation-multiple-data-validation
Sheet: Sheet1

 |  |  | Firm | Firm A | Firm B | Firm C | Firm D | Firm A | Firm B | Firm C | Firm A | Firm B | Firm A
 |  |  | Fund | Fund 1 | Fund 1 | Fund 1 | Fund 1 | Fund 2 | Fund 2 | Fund 2 | Fund 3 | Fund 3 | Fund 4
 |  |  | ID | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Choose Firm | Firm A
Choose Fund | Fund 3
ID | 8
Spreadsheet: 747719d1631661102-how-to-display-a-company-that-uses-both-distributors-example
Sheet: Sheet1

Deal # | Company Name | [NAME]
1 | ABC Ltd | Distributor 1
2 | ABC Ltd | Distributor 1
3 | ABC Ltd | Distributor 1
4 | ABC Ltd | Distributor 1
5 | DEF Ltd | Distributor 2
6 | DEF Ltd | Distributor 2
7 | DEF Ltd | Distributor 2
8 | GHI Ltd | Distributor 1
9 | GHI Ltd | Distributor 1
10 | GHI Ltd | Distributor 2
11 | GHI Ltd | Distributor 2
12 | JKL Ltd | Distributor 1
13 | JKL Ltd | Distributor 2
14 | JKL Ltd | Distributor 1
15 | JKL Ltd | Distributor 2
Spreadsheet: 849255d1699788186-inserting-a-checkmark-when-all-referenced-cells-have-data-in-them-hours
Sheet: Sheet1

C O M P | WORK SHIFTS 2023/2024 |  |  | EARLIES
 |  |  |  | LATES
 |  |  |  | ROTA DAYS
 | DAY & DATE
 | SUNDAY |  | 2023-10-01 00:00:00 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
 | FROM |  | TO | FROM | TO | FROM | TO | FROM | TO | FROM | TO | FROM | TO | FROM | TO
 |  | 14:00:00 | 22:00:00 | RD | RD | RD | RD | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00
 |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
 |  | FROM | TO | FROM | TO | FROM | TO | FROM | TO | FROM | TO | FROM | TO | FROM | TO
 |  |  |  | RD | RD |  |  |  |  |  |  |  |  | RD | RD