tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cc80ad30-f0d1-46a7-a90b-2d2affa5a336
Sheet: Sheet1

N° CRPG | Sample | As | Ba | Be | Bi | Cd | Ce | Co | Cr | Cs | Cu | Dy | Er | Eu | Ga | Gd
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1102301 | Sample 1 | 5.942 | 138.5 | 0.718 | 0.153 | 0.805 | 75.51 | 4.445 | 19.14 | 1.11 | 21.64 | 3.702 | 1.73 | 1.438 | 5.293 | 5.403
1102302 | Sample 2 | 3.263 | 196.7 | 0.635 | < L.D. | 1.615 | 42.89 | 4.548 | 15.27 | 0.867 | 18.5 | 2.197 | 1.125 | 0.763 | 4.647 | 2.997
N° CRPG | Sample | Ge | Hf | [NAME] | In | La | [NAME] | Mo | Nb | Nd | Ni | Pb | Pr | Rb | Sb | Sm
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1102301 | Sample 1 | 0.394 | 1.764 | 0.684 | < L.D. | 41 | 0.207 | 0.415 | 3.513 | 32.88 | 13.24 | 6.5655 | 8.481 | 24.89 | 0.152 | 5.721
1102302 | Sample 2 | 0.345 | 1.344 | 0.428 | < L.D. | 25.73 | 0.143 | 0.672 | 2.887 | 18.05 | 12.34 | 7.2369 | 4.795 | 19.54 | 0.153 | 3.133
N° CRPG | Sample | Sr | Sn | Ta | Tb | Th | Tm | U | V | W | Y | Yb | Zn | Zr
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1102301 | Sample 1 | 327.9 | 0.896 | 0.3 | 0.697 | 3.509 | 0.228 | 8.118 | 36.98 | 0.538 | 27.47 | 1.374 | 28.52 | 71.42
1102302 | Sample 2 | 894.4 | 0.878 | 0.245 | 0.411 | 3.008 | 0.15 | 9.32 | 49.69 | 0.52 | 15.99 | 0.944 | 32.86 | 52.48
N° CRPG | Sample | [NAME] | Al2O3 | Fe2O3 | MnO | MgO | CaO | Na2O | K2O | TiO2 | P2O5 | PF | Total
 |  | % | % | % | % | % | % | % | % | % | % | % | %
1102301 | Sample 1 | 11.82 | 3.548 | 1.208 | 0.7898 | 0.66 | 44.61 | 0.281 | 0.592 | 0.223 | 0.94 | 35.67 | 100.34
1102302 | Sample 2 | 10.71 | 3.245 | 0.992 | 0.8598 | 0.743 | 45.285 | 0.235 | 0.507 | 0.188 | 1.94 | 35.28 | 99.99
Spreadsheet: 59173d1259644392-excel-2007-vlookup-expenses-2009-4
Sheet: Summary

EXPENSES
Date |  | Creditor | Details | Invoice | Amount | [NAME] | Nett
2009-01-01 00:00:00 |  | Totals
2009-02-01 00:00:00 |  | Totals
2009-03-01 00:00:00 |  | Totals
2009-04-01 00:00:00 |  | Totals
2009-05-01 00:00:00 |  | Totals
2009-06-01 00:00:00 |  | Totals
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: EPFS

 | El Paso/TW Eddy Rec |  |  | 27677
 | 78093
Day | Measured | Scheduled
1 | 33881 | 31700
2 | 31257 | 31700
3 | 31828 | 31700
4 | 32873 | 30123
5 | 30293 | 31700
6 | 30860 | 31700
7 | 28133 | 29064
8 | 28521 | 31195
9 | 28261 | 31700
10 | 32591 | 31700
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 57061.55
2001-12-10 00:00:00
CBS Volume
 |  |  | 42218
Spreadsheet: 771892d1646908327-why-column-with-address-in-side-can-not-work-and-substitute-can-not-remove-the-quote-bobgiant-formula-breakdown-examples-tms
Sheet: Sheet1

 |  |  |  |  |  |  | =COLUMNS(ADDRESS(ROW($A$1:$C$1)+ROW(A1)-1,COLUMN($A$1:$C$1)+COLUMN(A1)-1,1)) return 3
 |  |  |  |  |  |  | when I do the entire f9 on the entire Address Function, it is =COLUMNS({"$A$1","$B$1","$C$1"}) and return 3 and if I manually erase and type other things inside like =COLUMNS({"hello","hihihi","good"}) it still return 3 and if I add another " " like =COLUMNS({"hello","hihihi","good","eeeeee"}) it will return 4
 |  |  |  |  |  |  | but why the below formula, the answer is 1
 |  |  |  |  |  |  | but If I do the F9 thing the result is 3 looking the same as above formula
 |  |  |  |  |  |  | =COLUMNS(INDIRECT(ADDRESS(ROW($A$1:$C$1)+ROW(A1)-1,COLUMN($A$1:$C$1)+COLUMN(A1)-1,1))) return 1
 |  |  |  |  |  |  | =ROW($A$1:$C$1)
 |  |  |  |  |  |  | =ROW(A1)-1
 |  |  |  |  |  |  | =ROW($A$1:$C$1)+ROW(A1)-1
 |  |  |  |  | 2 | 3 | =COLUMN($A$1:$C$1) spills across in Excel 365
 |  |  |  |  |  |  | =@COLUMN($A$1:$C$1) dragged across
 |  |  |  |  |  |  | =COLUMN(A1)-1
 |  |  |  |  | 2 | 3 | =COLUMN($A$1:$C$1)+COLUMN(A1)-1 spills across in Excel 365
 |  |  |  |  |  |  | =@COLUMN($A$1:$C$1)+COLUMN(A1)-1 needs to be dragged across
 |  |  |  |  | $B$1 | $C$1 | =ADDRESS(ROW($A$1:$C$1)+ROW(A1)-1,COLUMN($A$1:$C$1)+COLUMN(A1)-1,1) spills across in Excel 365
 |  |  |  |  |  |  | =ADDRESS(@ROW($A$1:$C$1)+ROW(A1)-1,@COLUMN($A$1:$C$1)+COLUMN(A1)-1,1) needs to be dragged across
 |  |  |  |  |  |  | =COLUMNS(ADDRESS(ROW($A$1:$C$1)+ROW(A1)-1,COLUMN($A$1:$C$1)+COLUMN(A1)-1,1))
 |  |  |  |  |  |  | =INDIRECT(ADDRESS(ROW($A$1:$C$1)+ROW(A1)-1,COLUMN($A$1:$C$1)+COLUMN(A1)-1,1)) spills across in Excel 365
 |  |  |  |  |  |  | =@INDIRECT(ADDRESS(@ROW($A$1:$C$1)+ROW(A1)-1,@COLUMN($A$1:$C$1)+COLUMN(A1)-1,1)) dragged across
 |  |  |  |  |  |  | =COLUMNS(INDIRECT(ADDRESS(ROW($A$1:$C$1)+ROW(A1)-1,COLUMN($A$1:$C$1)+COLUMN(A1)-1,1)))
Spreadsheet: 126142d1319547322-change-color-of-text-first-time-it-appears-in-a-range-format-first
Sheet: Sheet1

 | A | B | B | A | C | B | D |  | CONDITIONAL FORMAT IN B2 IS
 | A | A | B | C | C | B | D
 | MARTIN | MARTIN | FRED | FRED | FRED | PETE | MARTIN |  | THEN COPIED  FORMAT TO THE OTHER CELLS
Spreadsheet: 838190d1690811004-need-advanced-indexmatch-formula-with-specific-criteria-for-obtaining-exact-desired-result-excel-forum-help-formula
Sheet: Data

Month | Count | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | Nov'19 | Dec'19 | Jan'20 | Feb'20 | Mar'20
2019-04-30 00:00:00 | 44 | 0 | 1.5 | 0 | 1.2 | 1.1 | 7.1 | 1 | 0 | 0 | 0 | 0 | 0
 | 14 | 0 | 0 | 2.3 | 2.5 | 5.4 | 3.4 | 1.1 | 0 | 0 | 0 | 0 | 0
 | 44 | 0 | 0 | 0 | 1.2 | 1.1 | 5.4 | 5.4 | 0 | 0 | 0 | 0 | 0
 | 87 | 0 | 0 | 0 | 0 | 1.1 | 5.1 | 1.1 | 0 | 0 | 0 | 0 | 0
 | 42 | 0 | 0 | 0 | 0 | 0 | 5.4 | 1.7 | 0 | 0 | 0 | 0 | 0
 | 87 | 0 | 0 | 0 | 0 | 0 | 0 | 7.1 | 0 | 0 | 0 | 0 | 0
 | 47 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Nov'19 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dec'19 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jan'20 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feb'20 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mar'20 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 79564d1279803006-sorting-a-dataset-with-another-using-date-and-time-data_atd2-22march-22april
Sheet: TIDES

DATE | TIDE RANGE | HW | 1 | 2 | 3 | 4 | 5 | 6
2010-03-22 00:00:00 | 3.2 | 08:52:00 | NA | NA | NA
 | 3 | 21:10:00
2010-03-23 00:00:00 | 2.6 | 09:50:00
 | 2.5 | 22:18:00
2010-03-24 00:00:00 | 2.1 | 11:08:00
 | 2.2 | 23:44:00
2010-03-25 00:00:00 | 2.1 | 12:45:00
2010-03-26 00:00:00 | 2.9 | 01:19:00
 | 3 | 14:15:00
2010-03-27 00:00:00 | 3.6 | 02:35:00
 | 3.7 | 15:16:00
2010-03-28 00:00:00 | 4.5 | 03:32:00
 | 4.4 | 16:06:00
2010-03-29 00:00:00 | 5.1 | 04:42:00
 | 5 | 16:52:00
2010-03-30 00:00:00 | 5.4 | 05:08:00
 |  | 17:35:00
2010-03-31 00:00:00 | 5.5 | 05:53:00
 | 5.3 | 18:18:00
2010-04-01 00:00:00 | 5.4 | 06:36:00
 | 5.1 | 18:55:00
2010-04-02 00:00:00 | 5 | 07:14:00
 | 4.7 | 19:27:00
2010-04-03 00:00:00 | 4.4 | 07:47:00
 | 4.1 | 19:54:00
2010-04-04 00:00:00 | 3.7 | 08:15:00
 | 3.4 | 20:21:00
2010-04-05 00:00:00 | 2.9 | 08:44:00
 | 2.7 | 20:56:00
2010-04-06 00:00:00 | 2.2 | 09:27:00
 | 2 | 21:46:00
2010-04-07 00:00:00 | 1.6 | 10:36:00
 | 1.6 | 23:08:00
2010-04-08 00:00:00 | 1.6 | 12:52:00
2010-04-09 00:00:00 | 2 | 01:17:00
 | 2 | 13:58:00
2010-04-10 00:00:00 | 2.7 | 02:16:00
 | 2.7 | 14:46:00
2010-04-11 00:00:00 | 3.2 | 03:03:00
 | 3.2 | 15:28:00
2010-04-12 00:00:00 | 3.7 | 03:45:00
 | 3.7 | 16:07:00
2010-04-13 00:00:00 | 4 | 04:24:00
 | 4 | 16:45:00
2010-04-14 00:00:00 | 4.2 | 05:02:00
 | 4.2 | 17:21:00
2010-04-15 00:00:00 | 4.2 | 05:38:00
 | 4.2 | 17:56:00
2010-04-16 00:00:00 | 4.2 | 06:16:00
 | 4.2 | 18:30:00
2010-04-17 00:00:00 | 4.2 | 06:49:00
 | 4.1 | 19:02:00
2010-04-18 00:00:00 | 4 | 07:24:00
 | 4 | 19:34:00
2010-04-19 00:00:00 | 3.6 | 08:02:00
 | 3.5 | 20:15:00
2010-04-20 00:00:00 | 3.2 | 08:48:00
 | 3.2 | 21:04:00
2010-04-21 00:00:00 | 2.8 | 09:46:00
 | 2.7 | 22:09:00
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A5

TABLE A5 FREQUENCY OF PRICE SPIKES IN THE CALIFORNIA ISO REAL-TIME ENERGY MARKET SP15 DURING JUNE, JULY, AND AUGUST OF 1998, 1999, AND 2000
Price Equals or Exceeds | # of hours |  |  | # of hours |  |  | # of hours
 | % of available hours |  |  | % of available hours |  |  | % of available hours
 | 1998-06-01 00:00:00 | 1999-06-01 00:00:00 | 2000-06-01 00:00:00 | 1998-07-01 00:00:00 | 1999-07-01 00:00:00 | 2000-07-01 00:00:00 | 1998-08-01 00:00:00 | 1999-08-01 00:00:00 | 2000-08-01 00:00:00
100 | 0 | 16 | 168 | 22 | 22 | 214 | 51 | 37 | 486
 | 0 | 0.022 | 0.233 | 0.02957 | 0.02957 | 0.2876 | 0.06855 | 0.0497 | 0.649
250 | 0 | 4 | 81 | 4 | 3 | 87 | 18 | 7 | 110
 | 0 | 0.00556 | 0.1125 | 0.00538 | 0.00403 | 0.11694 | 0.02419 | 0.0094 | 0.148
500 | 0 | 0 | 56 | 0 | 0 | 23 | 0 | 0 | 16
 | 0 | 0 | 0.07778 | 0 | 0 | 0.0309 | 0 | 0 | 0.022
750 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0.0333 | 0 | 0 | 0 | 0 | 0 | 0
1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Source: CAISO website (www.caiso.com).
Spreadsheet: f82ce168-0d36-4262-aca1-5176999f378a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | [ PAPEL MEMBRETADO DEL CONTRATISTA/PROVEEDOR ] | Unnamed: 3 | Unnamed: 4
 |  | [ NOMBRE COMPLETO DE LA COMPAÑÍA Y DIRECCIÓN ]
 |  | Importaciones de Bienes y/o Servicios de Canadá, Europa y Asia
 |  |  |  | Fecha:
 |  | A) Información del Contrato con Petróleos Mexicanos/Organismo Subsidiario
 |  | No. de Contrato :
 |  | Objeto del Contrato :
 |  | Monto Total del Contrato :
 |  |  | M.N. :
 |  |  | USD :
 |  | B) Información del Contrato con el Exportador
 |  | Nombre del Exportador:
 |  | [NAME]:
 |  | Dirección del Exportador:
 |  | [NAME] (Nombre y Teléfono del Exportador):
 |  | [NAME]:
 |  | Moneda del Contrato de Exportación:
 |  | Monto Estimado de las Exportaciones en USD:
 |  | [NAME] y/o Servicios:
 |  | Fecha Estimada o Período Estimado  de Embarque de los Bienes o Período de Ejecución de los Servicios:
 |  | [NAME]:
 |  | [Nombre y Dirección de la Compañía, Teléfono]
 |  | Firma:
 |  | Nombre:
 |  | Cargo:
Spreadsheet: 06b01484-9741-40d5-be6b-a24e22975c4a
Sheet: PSQueryRequest

 |  |  |  |  |  |  |  |  | City and County of Denver
 |  |  |  |  |  |  |  |  | PeopleSoft [NAME]
 |  | Instructions
 |  |  |  |  | Please use this form to request a new PeopleSoft [NAME] or for modification(s) to exisiting queries. Once you have completed this form, email as an attachment to [EMAIL]. You will receive notification once your request is complete.
 |  | Contact Information
 |  |  |  |  | Requester: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Submitted:
 |  |  |  |  | Agency Name:
 |  |  |  |  | Contact Phone/E-Mail:
 |  | Timeline
 |  |  |  |  | How soon do you need this completed?
 |  |  |  |  | Note: We will do our best to honor your request. However, based on workload priorities this may not be possible. If your request will be delayed, we will let you know as soon as possible.
 |  | New Query Request
 |  |  |  |  | One time request, or recurring?
 |  |  |  |  | Reason for Request
 |  |  |  |  | Information Needed (Be specific. For example, "Employee ID, Name and Position", not "Employee Job Information)
 |  |  |  |  | Prompts of Report (Information that will change each time the query is run and should be entered by the user at run-time)
 |  |  |  |  | Prompt 1:
 |  |  |  |  | Prompt 2:
 |  |  |  |  | Prompt 3:
 |  |  |  |  | Prompt 4:
 |  | Modification Request |  | Existing Query Information (For modifications only)
 |  |  |  |  | Query to be modified:
 |  |  |  |  | Modifications Requested
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 101561 | 99387
2 | 104070 | 104668
3 | 102908 | 102434
4 | 84773 | 83676
5 | 70058 | 70461
6 | 93868 | 93801
7 | 91997 | 92787
8 | 92287 | 91788
9 | 92020 | 91755
10 | 92001 | 91755
11 | 106982 | 105491
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 40812.85
2001-09-11 00:00:00
CBS Volume
 |  |  | -36540
Spreadsheet: 839179d1691732601-need-help-to-make-formula-based-vba-help-for-make-a-report-from-none-indexed-data-report-joh555-
Sheet: Sale

Date | Invoice No | Item | Qty.
2023-04-17 00:00:00 | HR/18732 | 36W FITTINGS | 2
2023-04-17 00:00:00 | HR/18732 | ADORE LED 3W DEEP SPOT 3K | 3
2023-04-17 00:00:00 | HR/17450 | ADORE LED 3W DEEP SPOT 6K | 8
2023-04-03 00:00:00 | HR/17450 | ASTRAL SPOT LIGHT 2W 3000K | 2
2023-04-08 00:00:00 | HR/17455 | CENTURA PLUS LED FLOOD LIGHT 30W 6K IP65 | 1
2023-04-25 00:00:00 | HR/18850 | COMET SURFACE PANEL 6W 6K RD | 3
2023-04-25 00:00:00 | HR/18850 | CRYSTA COB SWIVEL SPOTLIGHT 3W 6500K | 1
2023-04-19 00:00:00 | HR/18760 | ELEC BALLAST EL STAR SLIM-36W | 2
2023-04-19 00:00:00 | HR/18760 | E-LITELED CURVE 20W 6K | 1
2023-04-23 00:00:00 | HR/18855 | FAN  VENTIL AIR DX 250MM HAVELLS | 1
2023-05-17 00:00:00 | HR/21115 | FAZER LED PANEL 18W 6K ROUND | 2
2023-05-17 00:00:00 | HR/21115 | INNOVA NEO LED SPOT LIGHT 6W 6K RD | 4
2023-05-17 00:00:00 | HR/21115 | KETTLE TRAVEL LITE 0.5L MAROON 1000W | 1
2023-05-03 00:00:00 | HR/19736 | 36W FITTINGS | 4
2023-05-03 00:00:00 | HR/19736 | ADORE LED 3W DEEP SPOT 3K | 2
2023-05-03 00:00:00 | HR/19736 | ADORE LED 3W DEEP SPOT 6K | 1
2023-05-10 00:00:00 | HR/20110 | LED ADORE 0.5W LAMP GREEN | 5
2023-05-12 00:00:00 | HR/20110 | ASTRAL SPOT LIGHT 2W 3000K | 9
2023-05-17 00:00:00 | HR/21100 | CENTURA PLUS LED FLOOD LIGHT 30W 6K IP65 | 3
2023-05-17 00:00:00 | HR/21100 | COMET SURFACE PANEL 6W 6K RD | 6
Spreadsheet: 783354d1654753800-solve-with-dynamic-range-formula-to-calculate-percentage-payments-over-moving-3-week-slot-dynamic-range-ask-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | criteria 1 |  |  | criteria 2
 |  |  |  |  |  | Data |  |  | Output Report
 |  |  |  |  |  |  |  |  | week
 |  |  |  |  |  | QTY | Week start |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  | 350 | 2 |  |  |  |  |  |  |  |  | percentage output 1st | 0.1
 |  |  |  |  |  | 450 | 1 |  |  |  |  |  |  |  |  | percentage output 2nd | 0.4
 |  |  |  |  |  | 100 | 3 |  |  |  |  |  |  |  |  | percentage output 3rd | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | Need Solve Using Dynamic Range (Offset) ???
 |  |  |  |  |  |  |  |  |  |  |  | Note :
 |  |  |  |  |  |  |  |  |  |  |  | 1. If Week start changed then automatic result
Spreadsheet: 781895d1653619218-using-conditional-formatting-with-multiple-criterias-penetration-report-template-2022
Sheet: Sheet1

 |  |  |  |  |  |  |  | HURDLE
Program | Preferred Partner |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HURDLE
Community | Months using AP | Units on AP | Total Units | AssetProtect Penetration % | Total on 3rd Party | Total Percent Insured |  | Months using AP | Expected Penetration % Auto Enroll | Expected Penetration % Preferred Partner | Expected Penetration % Opt Out |  | helper column |  |  | Month | Auto Enroll | Preferred Partner | Opt Out
Apartment 123 | 3 | 35 | 47 |  | 3 |  |  | 1 | 0 | 0 | 0 |  |  |  |  | 1 | 0 | 0 | 0
Apartment 124 | 7 | 12 | 240 |  | 73 |  |  | 2 | 0.06 | 0.03 | 0.03 |  |  |  |  | 2 | 0.06 | 0.03 | 0.03
Apartment 125 | 10 | 64 | 287 |  | 70 |  |  | 3 | 0.15 | 0.06 | 0.06 |  |  |  | AutoEnroll | 3 | 0.15 | 0.06 | 0.06
Apartment 126 | 20 | 20 | 104 |  | 15 |  |  | 4 | 0.22 | 0.09 | 0.09 |  |  |  | Preferred Partner | 4 | 0.22 | 0.09 | 0.09
Apartment 127 | 15 | 22 | 52 |  | 5 |  |  | 5 | 0.29 | 0.12 | 0.12 |  |  |  | Opt Out | 5 | 0.29 | 0.12 | 0.12
Apartment 128 | 15 | 17 | 200 |  | 71 |  |  | 6 | 0.36 | 0.15 | 0.15 |  |  |  |  | 6 | 0.36 | 0.15 | 0.15
Apartment 129 | 6 | 3 | 288 |  | 25 |  |  | 7 | 0.43 | 0.18 | 0.18 |  |  |  |  | 7 | 0.43 | 0.18 | 0.18
Apartment 130 | 9 | 90 | 252 |  | 32 |  |  | 8 | 0.5 | 0.21 | 0.21 |  |  |  |  | 8 | 0.5 | 0.21 | 0.21
Apartment 131 | 11 | 11 | 240 |  | 40 |  |  | 9 | 0.5700000000000001 | 0.24 | 0.24 |  |  |  |  | 9 | 0.5700000000000001 | 0.24 | 0.24
Apartment 132 | 14 | 120 | 264 |  | 86 |  |  | 10 | 0.64 | 0.27 | 0.27 |  |  |  |  | 10 | 0.64 | 0.27 | 0.27
Apartment 133 | 19 | 181.7416676299175 | 240 |  | 24 |  |  | 11 | 0.71 | 0.3 | 0.3 |  |  |  |  | 11 | 0.71 | 0.3 | 0.3
 |  |  |  |  |  |  |  | 12 | 0.78 | 0.33 | 0.33 |  |  |  |  | 12 | 0.78 | 0.33 | 0.33
 |  |  |  |  |  |  |  | 13 | 0.85 | 0.36 | 0.36 |  |  |  |  | 13 | 0.85 | 0.36 | 0.36
 |  |  |  |  |  |  |  | 14 | 0.88 | 0.4 | 0.4 |  |  |  |  | 14 | 0.88 | 0.4 | 0.4
Spreadsheet: 779128d1651595145-highlighting-date-cells-based-on-day-of-viewing-file-test
Sheet: Sheet1

Serial | Opportunity | Opportunity Lead | Account | Lead | Completion Date | Status
1 | Opportunity 1 | OL1 | Acc | Lead
2 | Opportunity 2 | OL2 | Acc | Lead | 2022-05-14 00:00:00 | In Progress
3 | Opportunity 3 | OL3 | Acc | Lead | 2022-05-15 00:00:00 | In Progress
4 | Opportunity 4 | OL4 | Acc | Lead | 2022-05-16 00:00:00 | Not Started
5 | Opportunity 5 | OL5 | Acc | Lead | 2022-05-17 00:00:00 | No update
6 | Opportunity 6 | OL6 | Acc | Lead | 2022-05-18 00:00:00 | No update
7 | Opportunity 7 | OL7 | Acc | Lead | 2022-05-04 00:00:00 | In Progress
8 | Opportunity 8 | OL8 | Acc | Lead | 2022-04-12 00:00:00 | In Progress
9 | Opportunity 9 | OL9 | Acc | Lead | 2022-05-04 00:00:00 | Completed
10 | Opportunity 10 | OL10 | Acc | Lead | 2022-05-02 00:00:00 | In Progress
11 | Opportunity 11 | OL11 | Acc | Lead | 2022-05-02 00:00:00 | Completed
12 | Opportunity 12 | OL12 | Acc | Lead |  | Completed
13 | Opportunity 13 | OL13 | Acc | Lead | 2022-04-11 00:00:00 | In Progress
14 | Opportunity 14 | OL14 | Acc | Lead | 2022-04-11 00:00:00 | In Progress
15 | Opportunity 15 | OL15 | Acc | Lead | 2022-04-11 00:00:00 | Not Started
16 | Opportunity 16 | OL16 | Acc | Lead | 2022-04-11 00:00:00 | In Progress
17 | Opportunity 17 | OL17 | Acc | Lead | 2022-04-18 00:00:00 | No update
18 | Opportunity 18 | OL18 | Acc | Lead | 2022-07-05 00:00:00 | In Progress
19 | Opportunity 19 | OL19 | Acc | Lead | 2022-04-28 00:00:00 | Not Started
20 | Opportunity 20 | OL20 | Acc | Lead | 2022-07-04 00:00:00 | In Progress
21 | Opportunity 21 | OL21 | Acc | Lead | 2022-04-11 00:00:00 | In Progress
22 | Opportunity 22 | OL22 | Acc | Lead | 2022-04-19 00:00:00 | In Progress
Spreadsheet: 103596d1301342900-using-a-string-function-within-a-range-in-sumif-possible-sample1
Sheet: Sheet1

 | Amount
001 - Total Cat1 | 12
001 - Total Cat2 | 43
001 - Total Cat3 | 44
002 - Total Cat1 | 43
002 - Total Cat2 | 66
002 - Total Cat3 | 89
003 - Total Cat1 | 23
003 - Total Cat2 | 11
003 - Total Cat3 | 23
Total Cat1
Total Cat2
Total Cat3
Spreadsheet: 831824d1685944450-order-sheet-for-supplies-for-my-special-education-class-supplies
Sheet: Totals

 | Order Information
 | Class | Total Supplies Ordered | Total Cost
 | AR
 | PLP1
 | [NAME]
 | PLP3
 | SSP1
 | SSP1
 | [NAME]
Spreadsheet: 295566d1391724262-sorting-data-in-dynamic-ranges-test
Sheet: source data (table)

Code | Name | Benchmark | 1m F | 1m B | 1m D | 3m F | 3m B | 3m D | YTD F | YTD B | YTD D | Frequency |  | Code | Name | Benchmark | 1m F | 1m B | 1m D | 3m F | 3m B | 3m D | YTD F | YTD B | YTD D | Frequency |  |  | Non Lagged
AAA | Apple | Apple BM | 0.09385447283368009 | -1.64289378008042 | 1.7367482529141 | 0.5524874947549225 | -2.489604044878329 | 3.042091539633252 | -2.590734495278935 | 1.1311436062281 | -3.721878101507035 | Lagged
BBB | [NAME] | [NAME] | 2.081421297628666 | -1.509647124264881 | 3.591068421893548 | -2.60748352992929 | 2.759892579170335 | -5.367376109099625 | 0.1072138107462477 | 0.7666595524018165 | -0.6594457416555688 | Non Lagged
CCC | Carrot | [NAME] | -1.735940776812684 | 2.375680360957627 | -4.111621137770311 | 0.9160221919753448 | -1.126337353953857 | 2.042359545929202 | -0.3972715110235985 | -1.480166202808849 | 1.082894691785251 | Exclude
DDD | Dragon | Dragon BM | -0.5718241303827729 | 0.8403152938867411 | -1.412139424269514 | -2.231016220344097 | -0.7779039928868485 | -1.453112227457248 | -1.48032769944372 | 0.3446663518343369 | -1.824994051278056 | Lagged
EEE | Eagle | Eagle BM | 0.2525689596958172 | -2.199419766526411 | 2.451988726222228 | 2.047545081937228 | 2.81215260240154 | -0.7646075204643124 | 2.878532721903929 | -0.3592567416806078 | 3.237789463584537 | Non Lagged
FFF | Frog | Frog BM | 0.31 | 0.67 | -0.36 | 0.99 | -0.12 | 1.11 | 1.27 | 1.36 | -0.09000000000000008 | Non Lagged
Spreadsheet: 786169d1657022869-find-the-50-1-value-in-a-range-workbook-example
Sheet: Sheet1

Study | Groups | # of Persons | Date | 50%+1
Study X | Cohort 1c | 4 | 2022-01-05 00:00:00
Study X | Cohort 1d | 2 | 2022-01-06 00:00:00
Study X | Cohort 2a | 4 | 2022-02-13 00:00:00 | 2022-02-13 00:00:00
Study X | Cohort 2b | 3 | 2022-02-17 00:00:00
Study Y | Cohort 2b | 2 | 2022-01-09 00:00:00
Study Y | Cohort 2c | 5 | 2022-01-11 00:00:00 | 2022-01-11 00:00:00
Study Y | Cohort 3a | 4 | 2022-02-06 00:00:00
Study Y | Cohort 3b | 6 | 2022-02-08 00:00:00
Spreadsheet: 121061d1315819350-unique-values-from-a-list-of-values-unique-value
Sheet: Sheet1

Data |  |  |  | Result
Person1
Person3
Person5
Person4
Person5
Person2
Person3
Person4
Person3
Person4
Person5
Person1
Person2
Person3
Person5
Person1
Spreadsheet: 44040d1242722350-reducing-long-repeptitive-formulas-684214-reducing-long-repeptitive-formulas
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA | CELL1 | CELL2 |  | Index | Cell1 | [NAME] | Value Expected
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | w | 1c |  | ww | w | w | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | w | 1c | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w1b | w | 1b | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w1a | w | 1a | 3
Spreadsheet: 545161d1509325465-conditionally-summing-across-a-varying-number-of-worksheets-copy-of-example-book-allisonns-
Sheet: Summary

 | Totals From Below
Year = | Check |  |  |  |  |  | <--------- | Takes the units on each tab on the date closest to the end of the calander year input on the summary sheet and sums them.
2016 | Difference
Tab# | Stock Name | Units Sold | Proceeds | Basis | Gain/Loss | Ending Units | [NAME]
1 | Stock 1 | 0 | 0 | 0 |  |  |  | Not the actual column references used but is exactly how the formulas are written on the summary sheet
2 | Stock 2 | -6512 | 22562 | 18962 |  |  |  | So the top level summary for this needs to sum all the maximum values after determining if it is the ending units column value or a number from the transaction
3 | Stock 3 | -5689 | 20496 | 20685 |  |  |  | column for each tab.
a4:i50 | a4 | g4:g50 | a4:a50
Spreadsheet: 116388d1311793914-excel-2007-help-with-an-if-function-excel-forum-help
Sheet: Sheet1

 |  |  |  | Control
 |  |  |  | Check
2011 |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | Control | Comments
Budget | Allocate | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec | Check
2500 | Monthly
6500 | Custom | 0 | 0 | 0 | 0 | 1000 | 4000 | 1500 | 0 | 0 | 0 | 0 | 0
5000 | Quarterly
9800 | Semiannually
100000 | Anually