tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0208db61-e963-43b7-98f3-67ad452ae351
Sheet: CUADRO RESUMEN

CUADRO RESUMEN DEL APARTADO 4. CÁLCULO DEL AHORRO ENERGÉTICO  DE LAS MEMORIAS TÉCNICAS (EXCEPTO MEDIDA F.1)
MEJORA | AHORRO ENERGÉTICO PREVISTO | UNIDAD | EMISIONES EVITADAS | UNIDAD'
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
TOTAL |  | kWh/año |  | tCO2/[NAME]
CALCULO DEL PORCENTAJE DE AHORRO PREVISTO
Hay actuaciones en las que se exige un porcentaje [NAME] puedan ser subvencionables: COMPRUEBE ESTE DATO
Spreadsheet: 36df152b-82cd-4284-a78d-cfcb63954680
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
FOOD5 | Test | FOOD5 | Food-Meat Panel | Food-Meat Panel | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top		 Acceptable: Serum gel [NAME]: 0.5 mL	 Additional Information: See 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
FOOD5 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FOOD5 | Result | FOOD5 | Food-Meat Panel | Food-Meat Panel | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 46710-0
Spreadsheet: 807876d1670124697-select-and-extract-data-of-wanted-years-and-months-cbookm
Sheet: 574230

 | year | month | day |  |  |  |  |  |  |  |  | level |  | 6 | 1314.56
4133 | 1395 | 3 | 20 | 52.08 |  |  |  |  |  |  | 1368 |  |  | 7 | 1314.41
4133 | 1395 | 4 | 22 | 53.68 |  |  |  |  |  |  | 1368 |  |  | 8 | 1312.57
4133 | 1395 | 5 | 7 | 53.73 |  |  |  |  |  |  | 1368 |  |  | 9 | 1312.68
4133 | 1395 | 6 | 8 | 53.8 |  |  |  |  |  |  | 1368 |  |  | 10 | 1312.61
4133 | 1395 | 7 | 1 | 53.78 |  |  |  |  |  |  | 1368 |  |  | 11 | 1312.82
4133 | 1395 | 8 | 22 | 53.95 |  |  |  |  |  |  | 1368 |  |  | 12 | 1312.92
4133 | 1395 | 9 | 9 | 54.1 |  |  |  |  |  |  | 1368 |  |  | 1 | 1312.75
4133 | 1395 | 10 | 11 | 54.05 |  |  |  |  |  |  | 1368 |  |  | 2 | 1312.63
4133 | 1395 | 11 | 16 | 54.08 |  |  |  |  |  |  | 1368 |  |  | 3 | 1312.24
4133 | 1395 | 12 | 4 | 54 |  |  |  |  |  |  | 1368 |  |  | 4 | 1312.14
4133 | 1396 | 1 | 20 | 53.93 |  |  |  |  |  |  | 1368 |  |  | 5 | 1311.7
4133 | 1396 | 2 | 19 | 54.16 |  |  |  |  |  |  | 1368 |  |  | 6 | 1311.5
4133 | 1396 | 3 | 10 | 54.41 |  |  |  |  |  |  | 1368
4133 | 1396 | 4 | 18 | 54.53 |  |  |  |  |  |  | 1368
4133 | 1396 | 5 | 25 | 54.73 |  |  |  |  |  |  | 1368
4133 | 1396 | 6 | 19 | 53.44 |  |  |  |  |  |  | 1368
4133 | 1396 | 7 | 17 | 53.59 |  |  |  |  |  |  | 1368
4133 | 1396 | 8 | 3 | 55.43 |  |  |  |  |  |  | 1368
4133 | 1396 | 9 | 8 | 55.32 |  |  |  |  |  |  | 1368
4133 | 1396 | 10 | 11 | 55.39 |  |  |  |  |  |  | 1368
4133 | 1396 | 11 | 19 | 55.18 |  |  |  |  |  |  | 1368
4133 | 1396 | 12 | 14 | 55.08 |  |  |  |  |  |  | 1368
4133 | 1397 | 1 | 17 | 55.25 |  |  |  |  |  |  | 1368
4133 | 1397 | 2 | 20 | 55.37 |  |  |  |  |  |  | 1368
4133 | 1397 | 3 | 30 | 55.76 |  |  |  |  |  |  | 1368
4133 | 1397 | 4 | 20 | 55.86 |  |  |  |  |  |  | 1368
4133 | 1397 | 5 | 25 | 56.3 |  |  |  |  |  |  | 1368
4133 | 1397 | 6 | 27 | 56.5 |  |  |  |  |  |  | 1368
4133 | 1397 | 7 | 19 | 56.55 |  |  |  |  |  |  | 1368
4133 | 1397 | 8 | 27 | 55.9 |  |  |  |  |  |  | 1368
4133 | 1397 | 9 | 15 | 55.65 |  |  |  |  |  |  | 1368
4133 | 1397 | 10 | 15 | 55.59 |  |  |  |  |  |  | 1368
4133 | 1397 | 11 | 15 | 55.35 |  |  |  |  |  |  | 1368
4133 | 1397 | 12 | 15 | 55.32 |  |  |  |  |  |  | 1368
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: December

 |  |  |  | Date | 2010-08-10 12:26:51 |  | December Total Hours
 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Percentage
 | Year | Month | Date | Hours | Total Hours |  |  | Total Hours |  |  | 248 | 100
 | 2010 | December | 2010-12-01 00:00:00 | 0 | 0 |  |  | Total Hours Requested |  |  | 0 | 0
 |  |  | 2010-12-02 00:00:00 | 0 |  |  |  | Hours Not Requested |  |  | 248 | 100
 |  |  | 2010-12-03 00:00:00 | 0 |  |  |  |  |  |  |  |  |  | Key
 |  |  | 2010-12-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Hours Requested
 |  |  | 2010-12-05 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Left Over Hours
 |  |  | 2010-12-06 00:00:00 | 0
 |  |  | 2010-12-07 00:00:00 | 0
 |  |  | 2010-12-08 00:00:00 | 0
 |  |  | 2010-12-09 00:00:00 | 0
 |  |  | 2010-12-10 00:00:00 | 0
 |  |  | 2010-12-11 00:00:00 | 0
 |  |  | 2010-12-12 00:00:00 | 0
 |  |  | 2010-12-13 00:00:00 | 0
 |  |  | 2010-12-14 00:00:00 | 0
 |  |  | 2010-12-15 00:00:00 | 0
 |  |  | 2010-12-16 00:00:00 | 0
 |  |  | 2010-12-17 00:00:00 | 0
 |  |  | 2010-12-18 00:00:00 | 0
 |  |  | 2010-12-19 00:00:00 | 0
 |  |  | 2010-12-20 00:00:00 | 0
 |  |  | 2010-12-21 00:00:00 | 0
 |  |  | 2010-12-22 00:00:00 | 0
 |  |  | 2010-12-23 00:00:00 | 0
 |  |  | 2010-12-24 00:00:00 | 0
 |  |  | 2010-12-25 00:00:00 | 0
 |  |  | 2010-12-26 00:00:00 | 0
 |  |  | 2010-12-27 00:00:00 | 0
 |  |  | 2010-12-28 00:00:00 | 0
 |  |  | 2010-12-29 00:00:00 | 0
 |  |  | 2010-12-30 00:00:00 | 0
 |  |  | 2010-12-31 00:00:00 | 0
Spreadsheet: 9e1c8192-590d-442d-bfde-9fcead86ad68
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6338 | 10061 | Raino | [NAME] | FIN | 952 | [NAME] | 00:01:46 | 01:14:21 | 00:02:40 | 00:25:29 | 1 | 02:34:18
6338 | 13403 | [NAME] | Funk | GER | 956 | 00:54:00 | 00:02:26 | 01:16:59 | 00:02:49 | 00:28:30 | 2 | 02:44:43
6338 | 8033 | Arnott | [NAME] | GBR | 954 | [NAME] | 00:02:55 | 01:21:34 | 00:02:42 | 00:29:08 | 3 | [NAME]
6338 | 12396 | [NAME] | [NAME] | GBR | 955 | 00:52:38 | 00:03:04 | [NAME] | 00:03:23 | 00:30:00 | 4 | 02:58:49
6338 | 12442 | [NAME] | Peck | GBR | 953 | 00:56:59 | 00:01:45 | 01:26:22 | 00:03:20 | 00:36:35 | 5 | 03:05:01
Spreadsheet: 70289d1271085762-consolidating-data-into-one-cell-sample-data
Sheet: Finishing Data if possible

Data | Data2 | Description consolidated together
SII001 | 123A01 | [NAME] Abu Dhabi Cabinda Dubai Luanda Soyo
SII001 | 123B01 | Barrio Santa Genoveva Buenos Aires Comodoro Rivadavia Luanda [NAME] Mendoza Neuquen Tartagal
SII002 | 123A02 | Aracaju Baden Baku Bentley Broome Corio Quay Dampier [NAME] Dhaka Malaga Nivelles Perth Rio Gallegos Santa Cruz Tartagal
SII002 | 123B02 | [NAME]
SII003 | 123A03 | [NAME] Parauapebas Rio De Janeiro Salvador Sao Goncalo Sao Mateus Sao Paulo Serra Simoes Filho [NAME] Vitoria
SII003 | 123B03
SII004 | 123A04
SII004 | 123B04
SII005 | 123A05
SII005 | 123B05
SII006 | 123A06
SII006 | 123B06
SII007 | 123A07
SII007 | 123B07
SII008 | 123A08
SII008 | 123B08
SII009 | 123A09
SII009 | 123B09
SII010 | 123A10
SII010 | 123B10
SII011 | 123A11
SII011 | 123B11
SII012 | 123A12
SII012 | 123B12
SII013 | 123A13
SII013 | 123B13
SII014 | 123A14
SII014 | 123B14
SII015 | 123A15
SII015 | 123B15
SII016 | 123A16
SII016 | 123B16
SII017 | 123A17
SII017 | 123B17
SII018 | 123A18
SII018 | 123B18
Spreadsheet: 793079d1661290778-formula-to-show-results-of-evaluation-tie-match-sample-wb
Sheet: Supplier 1

 |  |  |  | (The details are to be consistent with the criteria outlined in the forms)
 |  |  |  |  | Score
 | Weighting Ratio |  | Price
 |  |  | Non-Price
 | Quotation 1 - Supplier/Service Provider Name:
 | Table 1 - Compliance Assessment Criteria
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Consensus
 | 1 | aa |  |  |  |  |  |  |  | SATISFACTORY | EXCEPTIONAL | EXCEPTIONAL | EXCEPTIONAL
 | 2 | fffg |  |  |  |  |  |  |  | SATISFACTORY | SATISFACTORY | UNSATISFACTORY | EXCEPTIONAL
 | 3 | fffg |  |  |  |  |  |  |  | EXCEPTIONAL | SATISFACTORY | SATISFACTORY | EXCEPTIONAL
Spreadsheet: 790526d1659768112-search-table-given-dates-and-numbers-as-criteria-help_please
Sheet: Sheet1

VOLUME DISCOUNT PER ITEM TABLE BASED ON INVOICE DATE
VOLUME PER ITEM: |  | 30000 | <<-- GIVEN | CHANNEL: |  | EU | <<-- GIVEN
INVOICE DATE: |  | 2022-01-15 00:00:00 | <<-- GIVEN | VOLUME DISCOUNT: |  |  | <<<--- HELP W/ THIS FORMULA
 |  |  |  | EXCEL 365 FORMULA: |  |  | <<<--- OK
The above EXCEL 365 [NAME] works fine. However, I need a working formula for those not running Excel 365. I need help @ G3 - To search a table with date ranges and number ranges using INDEX MATCH or other ways.
SORT DATE THEN VOL ASCENDING
VOL | FR_DATE | TO_DATE | EU | DL | DR | TB | PL | RM
0 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.03 | 0 | 0 | 0 | 0 | 0
5000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.06 | 0 | 0 | 0 | 0 | 0
10000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.09 | 0 | 0 | 0.03 | 0.03 | 0
15000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.12 | 0 | 0 | 0.06 | 0.06 | 0
20000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.09 | 0.09 | 0
25000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.12 | 0.12 | 0
30000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
999999999 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
0 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.02 | 0 | 0 | 0 | 0 | 0
5000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.04 | 0 | 0 | 0 | 0 | 0
10000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.06 | 0 | 0 | 0.02 | 0.02 | 0
15000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.08 | 0 | 0 | 0.04 | 0.04 | 0
20000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.06 | 0.06 | 0
25000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.08 | 0.08 | 0
30000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
999999999 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
Spreadsheet: 865719d1712738571-conditional-concatenated-list-forumq
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Expected answers
 | Arm ID | Arm Name | Bus Services |  |  |  | 1A | 1B | 1C | Bus Services Affected
 | 1A | A6181 Westgate | 633;634; |  |  |  | 1 | 0 | 0 | 633;634;
 | 1B | [NAME] | 662;A3; |  |  |  | 0 | 1 | 1 | 662;A3;
 | 1C | B6144 Westgate | 617;618;620;621; |  |  |  | 1 | 0 | 1 | 633;634;617;618;620;621;
 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | 1 | 1 | 1 | 633;634; 662;A3;617;618;620;621;
Spreadsheet: 856453d1705682754-using-excel-as-identification-page-paints-and-pigments-edited
Sheet: Sheet1

 | Show all
 | A.MIG-3001 Pigment Black | A.MIG-3002 Pigment Light Dust | A.MIG-3003 Pigment North  Africa Dust | A.MIG-3004 Pigment Europe Earth | A.MIG-3005 Pigment Medium Rust | A.MIG-3006 Pigment Light  Rust | A.MIG-3007 Pigment Dark  Earth | A.MIG-3008 Pigment Track  Rust | A.MIG-3009 Pigment Gun Metal | A.MIG-3010 Pigment Concrete | A.MIG-3011 Pigment [NAME]  Dust | A.MIG-3012 Pigment Sand
 | A.MIG-3013 Pigment Rubble | A.MIG-3014 Pigment Russian Earth | A.MIG-3015 Pigment Brick  Dust | A.MIG-3016 Pigment White | A.MIG-3017 Pigment Primer  Red | A.MIG-3018 Pigment Middle East Dust | A.MIG-3019 Pigment Army  Green | A.MIG-3020 Pigment Metal Slag | A.MIG-3021 Pigment Polished Metal | A.MIG-3022 Pigment Vietnam Earth | A.MIG-3023 Pigment Sinai Dust | A.MIG-3024 Pigment Negev  Sand
 | A.MIG-3025 Pigment Syrian Ground | A.MIG-3026 Pigment Golan  Earth | A.MIG-3027 Pigment Farm Dark Earth | A.MIG-3028 Pigment City Dark Dust | A.MIG-3029 Pigment Winter Soil | A.MIG-3030 Pigment Factory [NAME] | A.MIG-2251 U-Rust Deep Oxide | A.MIG-2252 U-Rust Black Oxide Transparent | A.MIG-2253 U-Rust Black Oxide | A.MIG-2254 U-Rust Rust Oxide Patina | A.MIG-2255 U-Rust Copper Blue Patina | A.MIG-2256 U-Rust Oxide Grime
 | A.MIG-1000 [NAME] for German Dark Yellow | A.MIG-1001 [NAME] | A.MIG-1002 [NAME] | A.MIG-1003 Interiors Wash | A.MIG-1004 Light Rust Wash | A.MIG-1005 [NAME] for Green Vehicles | A.MIG-1006 [NAME] for Panzer Grey | A.MIG-1007 US Modern [NAME] | A.MIG-1008 [NAME] | A.MIG-1009 [NAME] | A.MIG-1010 Neutral Wash | A.MIG-1011 Black Wash
 | Muds
 | Streaking
Spreadsheet: 794234d1661952701-vlookup-with-multiple-conditions-template-mock
Sheet: Steel Detail

# | Qty | MATERIAL |  |  |  |  | MATERIAL | MATERIAL | SHEET PRICE | POWDER | Price per [NAME] | LBS. NEEDED | MAX PER WIDTH | MAX PER WIDTH | MAX PER LENGTH | SHEETS NEEDED | Total SQ/FT | [NAME] | Length | Material | MATERIAL WEIGHT | TOTAL WEIGHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shop Labor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solid | Powder | Shear&Brake | [NAME] | Shipping |  | shop labor steel detail |  |  | SELL |  | Material | Price
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0785
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0516
Total Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Materials
Buy Price From CAGSIL NO ADD ON
Buy Price From CAGSIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shop labor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 288707d1389283862-12-month-rolling-period-with-variable-dates-over-the-12-month-period-12-month-rolling-period-leave-date
Sheet: Sheet1

Date | 1/2 Day | 12 mth rolling total
2012-01-03 00:00:00 | 1 |  |  | Actually Taken
2012-02-03 00:00:00 | 0 |  |  | Planned
2012-03-31 00:00:00 | 1
31/04/2012 | 0
2012-05-31 00:00:00 | 0
31/06/2012 | 0
2012-07-31 00:00:00 | 0
2012-08-30 00:00:00 | 1
2012-09-03 00:00:00 | 0
2012-10-03 00:00:00 | 0
2012-11-03 00:00:00 | 0
2012-12-03 00:00:00 | 0 | 3
2013-01-03 00:00:00 | 0 | 2
2013-02-03 00:00:00 | 0 | 2
2013-03-03 00:00:00 | 0 | 1
2013-04-03 00:00:00 | 0 | 1
2013-05-08 00:00:00 | 1 | 2
2013-05-22 00:00:00 | 1 | 3
2013-06-03 00:00:00 | 0 | 2
2013-07-19 00:00:00 | 1 | 3
2013-08-03 00:00:00 | 0 | 2
2013-09-03 00:00:00 | 0 | 2
2013-10-03 00:00:00 | 0 | 2
2013-11-03 00:00:00 | 0 | 2
2013-12-03 00:00:00 | 0 | 2
2014-01-03 00:00:00 | 0 | 2
2014-02-03 00:00:00 | 0 | 2
2014-03-23 00:00:00 | 1 | 3
2014-04-14 00:00:00 | 1 | 4
2014-05-12 00:00:00 | 0 | 4
2014-05-23 00:00:00 | 0 | 4
2014-06-03 00:00:00 | 0 | 4
2014-07-03 00:00:00 | 0 | 3
2014-08-01 00:00:00 | 1 | 4
2014-09-03 00:00:00 | 0 | 4
2014-10-03 00:00:00 | 0 | 4
2014-11-03 00:00:00 | 0 | 4
2014-12-03 00:00:00 | 0
2005-01-03 00:00:00 | 0
2015-02-03 00:00:00 | 0
2015-03-03 00:00:00 | 0
2015-04-03 00:00:00 | 0
2015-05-03 00:00:00 | 0
2015-06-03 00:00:00 | 0
2015-07-03 00:00:00 | 1
2015-08-03 00:00:00 | 0
2015-09-03 00:00:00 | 1
2015-10-03 00:00:00 | 1
2015-11-03 00:00:00 | 0
2015-12-03 00:00:00 | 0
2016-01-03 00:00:00 | 0
2016-02-03 00:00:00 | 0
2016-03-03 00:00:00 | 0
2016-04-03 00:00:00 | 0
2016-05-03 00:00:00 | 0
2016-06-03 00:00:00 | 0
2016-07-03 00:00:00 | 0
2016-08-03 00:00:00 | 0
2016-09-03 00:00:00 | 0
2016-10-03 00:00:00 | 0
2016-11-03 00:00:00 | 0
2016-12-03 00:00:00 | 0
2017-01-03 00:00:00 | 0
2017-02-03 00:00:00 | 0
Spreadsheet: 136138d1326429277-reading-from-other-files-multi-year-testing-data-sheets
Sheet: 2012

year | 2012
Name | age | spelling | maths | reading
 |  | 14 | 6705 | 8
 |  | 15 | 75 | 9
 |  | 16 | 80 | 10
 |  | 17 | 85 | 11
 |  | 18 | 90 | 12
 |  | 1* | 95 | 13
Spreadsheet: benjamin_rogers__1298__Caledonia model template  final version III
Sheet: IDC

INTEREST DURING CONSTRUCTION
Current Month
Calendar Month |  |  |  |  |  |  |  |  |  | TOTAL | 1
 | (excl IDC) |  | Total
Project Cost
Interest Rate
Debt/Equity Structure
Construction Balance
Beginning Construction Balance |  |  |  | 0
Construction Drawdown
Ending Construction Balance
Cumulative % complete (excl IDC & Prepayment)
All-In Cumulative % Complete (excl Prepayment)
Debt Balance
Beginning Debt Balance
Plus:  Debt Proceeds
Ending Balance Debt Only
Interest During Construction -- Monthly
Equity Balance
Beginning Equity Balance
Plus:  Equity Proceeds
Ending Equity Balance
Total Interest During Construction
Spreadsheet: 783778d1655136798-using-iferror-and-unique-to-create-a-summary-table-voucher-tracker2
Sheet: MasterList

Staff issuing | Project name | Date issued | Recipient name | Recipient Postcode | Ward Area | Amout issued | Date issued | Reason for allocation | Additional information
[NAME] | Atrax |  |  |  |  | 1
[NAME] | Atrax |  |  |  |  | 2
[NAME] | Works4Youth |  |  |  |  | 4
[NAME] | Elecmobile |  |  |  |  | 3
[NAME] | PolyCarbon |  |  |  |  | 5
[NAME] | Atrax |  |  |  |  | 3
[NAME] | [NAME] |  |  |  |  | 2
Spreadsheet: 813185d1673605417-if-with-if-and-annual-leave-entitlement-for-excelforum
Sheet: Sheet1

SURNAME | FIRST NAME | Base A/L | Bank Holiday | Extra Bank Holiday | Continual Service Annual Leave | Total Annual Leave | Work Time Equivalent | Annual Leave (Hours) | NHS continuous service date | 2023-03-31 00:00:00
Staff | Member | 27 | 8 | 2 |  |  | 0.4 |  | 2014-04-07 00:00:00
Total Staff on [NAME]
Spreadsheet: 348459d1412002142-establish-a-link-to-data-on-the-line-chart-label-data-labels
Sheet: Sheet1

 | Turnover | Event
 | 125047
 | 91229
 | 92411 | School
 | 91244
 | 99031
 | 88143
 | 108153 | School
 | 117363
 | 99430
 | 97503
 | 96173
 | 95135 | Summer
 | 93689
 | 89429
 | 105177
 | 118055
 | 100185 | Student Sales Night
 | 94573
Spreadsheet: 761192d1640712630-adding-one-more-condition-to-my-ifs-function-missing-date
Sheet: Sheet1

Date | Client Name | Product | State | Referral | Effective date | Added by | Completed by | [NAME] referral | Call client | [NAME] client | Text client | Date completed | Quote Status
2021-12-27 00:00:00 | First Last | Auto | CA | Rajesh | 2022-01-10 00:00:00 | LS | AD |  | 0 | 0 |  | 2021-12-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
2021-12-27 00:00:00 | First Last | Home | AZ | [NAME] | 2022-01-10 00:00:00 | LS |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
2021-12-27 00:00:00 | First Last | Home | AZ | [NAME] | 2022-01-10 00:00:00 | LS | DB |  | X | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
2021-12-27 00:00:00 | First Last | Home | AZ | [NAME] | 2022-01-10 00:00:00 | LS | DB |  | X | 0 |  | 2021-12-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: errol_mclaughlin_jr__10157__broker names
Sheet: Sheet1

BROKER LEGAL NAMES |  |  |  |  |  |  | SHORT NAMES
[NAME], L.L.C. |  |  |  |  | Kristine |  | ALTRS
Amerex |  |  |  |  | Kristine |  | AMERG
American Gas Marketing |  |  |  |  | Kristine |  | AGM
APB |  |  |  |  | [NAME] |  | APB
Choice Energy |  |  |  |  | [NAME] |  | CHOIC
Coquest Energy Services |  |  |  |  | [NAME] |  | CESI
Dataline |  |  |  |  | Kristine |  | [NAME]
EDF Mann |  |  |  |  | [NAME] |  | MAN
Elite Energy Brokers |  |  |  |  | [NAME] |  | ELITE
GA Options, L.L.C. |  |  |  |  | [NAME] |  | GAOPT
GFI Group, Inc.  (formerly GFI Brokers, LTD.) |  |  |  |  | Kristine |  | GFIGR
Natsource, Inc.  (formerly Optimum) |  |  |  |  | [NAME] |  | NAT S
Orion |  |  |  |  | Kristine |  | ORION
Power Merchants |  |  |  |  | Kristine |  | PMGL
Prebon Yamane (formerly Prebon Energy) |  |  |  |  | [NAME] |  | PREBO
SCS Commodities |  |  |  |  | Kristine |  | SCS
Spectron Energy, Inc |  |  |  |  | [NAME] |  | SPECI
Syntrade Energy |  |  |  |  | Kristine |  | SYNTD
TCT Natural Gas |  |  |  |  | Kristine |  | TCT
TFS Energy, L.L.C. (formerly [NAME]) |  |  |  |  | Kristine |  | TFS
Tradespark, L.P. (formerly [NAME]) |  |  |  |  | Kristine |  | TRAPA
United Crude Oil |  |  |  |  | Kristine |  | UNITD
United Fuels Intl. |  |  |  |  | Kristine |  | UNFLS
Spreadsheet: 272345d1382363841-combining-text-with-comma-if-any-of-the-cells-data-is-present-in-3-columns-combining-text
Sheet: Sheet1

email | firstname | lastname
[EMAIL] | [NAME]
[EMAIL]
[EMAIL] | sean
[EMAIL] |  | [NAME]
[EMAIL] | jane | doe
[EMAIL] |  | appleseeds
[EMAIL] | sean | [NAME]
[EMAIL]
[EMAIL] | [NAME] | doe
Spreadsheet: 216619d1361824286-how-to-get-value-from-cell-that-matches-2-criterias-copy-of-adh-solved
Sheet: Sheet2

Helper | Date | Login ID | Minutes
100;41275 | 2013-01-01 00:00:00 | 100 | 410
101;41275 | 2013-01-01 00:00:00 | 101 | 543
102;41275 | 2013-01-01 00:00:00 | 102 | 677
103;41275 | 2013-01-01 00:00:00 | 103 | 324
104;41275 | 2013-01-01 00:00:00 | 104 | 563
105;41275 | 2013-01-01 00:00:00 | 105 | 466
106;41275 | 2013-01-01 00:00:00 | 106 | 234
107;41275 | 2013-01-01 00:00:00 | 107 | 245
108;41275 | 2013-01-01 00:00:00 | 108 | 678
100;41276 | 2013-01-02 00:00:00 | 100 | 211
101;41276 | 2013-01-02 00:00:00 | 101 | 435
102;41276 | 2013-01-02 00:00:00 | 102 | 767
103;41276 | 2013-01-02 00:00:00 | 103 | 223
104;41276 | 2013-01-02 00:00:00 | 104 | 0
105;41276 | 2013-01-02 00:00:00 | 105 | 0
106;41276 | 2013-01-02 00:00:00 | 106 | 0
107;41276 | 2013-01-02 00:00:00 | 107 | 422
108;41276 | 2013-01-02 00:00:00 | 108 | 765
100;41277 | 2013-01-03 00:00:00 | 100 | 900
101;41277 | 2013-01-03 00:00:00 | 101 | 231
102;41277 | 2013-01-03 00:00:00 | 102 | 345
103;41277 | 2013-01-03 00:00:00 | 103 | 674
104;41277 | 2013-01-03 00:00:00 | 104 | 709
105;41277 | 2013-01-03 00:00:00 | 105 | 0
106;41277 | 2013-01-03 00:00:00 | 106 | 0
107;41277 | 2013-01-03 00:00:00 | 107 | 0
108;41277 | 2013-01-03 00:00:00 | 108 | 0
Spreadsheet: 58365d1258631630-lookup-sample
Sheet: Sample

 | Date
Part No | 110 | 210 | 310 | 410 | 510 | 610 | 710 | 810 | 910 | 1010 | 1110 | 1210 | 1310 | 1410 | 1510 | 1610 | 1710 | 1810 | 1910 | 2010 | 2110 | 2210 | 2310 | 2410 | 2510 | 2610 | 2710 | 2810 | 2910 | 3010 | Total
Part1 | 1
Part2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 3
Part3 |  |  |  | 1 |  |  |  | 1
Part4 |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 2 | 8 |  |  |  |  |  |  |  |  |  |  | 9
Part5 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Part6 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  | 5 |  |  | 3 |  |  |  |  |  |  | 1
Part7 |  | 1 |  |  | 2 |  |  | 1 |  |  |  |  |  | 9 |  |  |  | 1 |  |  |  |  | 6
Part8 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Part9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
Part10 |  |  |  |  | 4 |  |  | 1 |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 5 |  |  | 1 | 1
Part11 |  |  |  |  |  |  |  |  | 1 |  |  |  | 4 |  |  | 1
Part12 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
Part13 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1
Part14 |  |  |  | 2 | 5 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
Part15 |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 9 |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1
Part16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
Part17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 6
Part18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Part19 |  |  |  |  | 8 |  |  |  |  |  |  |  | 3 |  |  |  | 1 |  |  |  |  | 1
Part20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
Part21 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 1 |  |  |  |  | 1
Part22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Part23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Part24
Part25
Total
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | 0 | 71296 | 71296
Cross_Currency Fixed-Fixed | 0 | 8113 | 8113
Cross_Currency Fixed-Float | 0 | 4686 | 4686
TOTAL | 0 | 84095 | 84095