tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 95117d1294789471-help-with-using-formulas-2011-new-sales
Sheet: Dec

Advisor | FC | Individual Life Premium |  | Individual Life Volume | Type |  | Asset Volume | Portal Bus. | Case Name
 |  | Large Case - Y | [NAME] |  | B/F/O
 |  | 0 | 0 | 0 | B - | 0 | 0 | 0
 |  | 0 | 0 | 0 | F - | 0 | 0 | 0
 | Total All Cases: | 0 |  |  | O - | 0
 |  | 0 |  |  | Total - | 0
Note:  Large Case = > $5,000 Annual Premium for all Life Plans including U.L.
# L/C | # Not L/C | L/C Ind. Life Prem. | Ind. Life Prem. | Ind. Life. Vol. | B | F | O | Asset Vol. | # Asset Vol. | Portal Bus.
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 58
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 69
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 71
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 74
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 77
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 111
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 181
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 |  |  |  | 0
Spreadsheet: 3d478222-6c37-46d3-be7c-9d4f58042d7a
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
CHLE | Test | CHLE | [NAME], Serum | [NAME], S | [NAME] | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Fasting-overnight (12-14 hours). 2. Patient must not consume any alcohol for 24 hours before the specimen is drawn. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | 60-80% of total cholesterol  Reference values have not been established for patients that are <16 years of age. | Monday through Friday; 7 a.m.-5 p.m. | Same day | 3 days | 1 | 84311 |  |  |  |  | Rochester
CHLE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CHLE | Result | CHLES | [NAME], S | [NAME], S | Numeric |  |  |  |  | % total chol |  |  |  |  |  |  |  |  |  | 21197-9 | Cholesterol esters/Cholesterol.total:MFr:Pt:Ser/Plas:Qn:
Spreadsheet: 540140d1506543514-create-a-list-if-cell-0-then-display-cell-copy-of-smr-costings-domestic-roofing-quotation-master-qrx-27-09-2017-list-of-inclusions
Sheet: Projected Project

Address:
JOB:
Date:
Description:
PROJECTED - SPECIALISED LABOUR + MATERIAL PROFIT & LOSS SUMMARY - PROJECT
SUMMARY |  |  |  |  | TOTAL LABOUR TIME
SUB TOTAL LABOUR |  |  |  |  |  | Roofing |  | HRS
SUB TOTAL MATERIALS |  |  |  |  |  |  |  | DAYS
 |  |  |  |  |  | [NAME] |  | HRS
SUB TOTAL MISCELLANEOUS (Add) |  |  |  | 0 |  |  |  | DAYS
SUB TOTAL OTHER (Add) |  |  |  | 0 |  | Downpipes |  | HRS
 |  |  |  |  |  |  |  | DAYS
TOTAL LABOUR
TOTAL MATERIALS |  |  |  |  |  | TOTAL |  | HRS
TOTAL COMBINED COST EX GST |  |  |  |  |  | TOTAL |  | DAYS
PROGRESS CLAIM - PROJECT |  |  | Units | TOTAL
Deposit |  | 0 | 1
Claim 1. |  |  | 1
Claim 2. |  | 0 | 1
Claim 3. |  | 0 | 1
 |  |  |  |  | TOTAL PAY EX GST
MARGIN - PROFIT OR LOSS |  |  |  |  | MARGIN EX GST
PROFIT or LOSS % |  |  |  |  | MARK UP after Build Cost
Spreadsheet: 198715d1354876679-excel-populating-a-calendar-excel-help-upload-7-dec-2012
Sheet: Inputs

 | Product | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] 3
 |  | Volume | SMS Order | SMS M.facture | SMS Ship | SMS [NAME] | SMS Test/Sell |  | Volume | Bulk 1 Order | Bulk 1 M.facture | Bulk 1 Ship | Bulk 1 Arrival | Bulk 1 Sell |  | Volume | Bulk 2 Order | Bulk 2 Mfacture | Bulk 2 Ship | Bulk 2 Arrival | Bulk 2 Sell |  | Bulk 3 Volume | Bulk 3 Order | Bulk 3 Mfacture | Bulk 3 Ship | Bulks 3 Arrival | Bulk 3 Sell
 | Product 1 | 100 | 2012-12-10 00:00:00 | 2012-12-15 00:00:00 | 2013-01-05 00:00:00 | 2013-01-25 00:00:00 | 2013-02-04 00:00:00 |  | 10000 | 2013-03-10 00:00:00 | 2013-03-14 00:00:00 | 2013-03-21 00:00:00 | 2013-04-05 00:00:00 | 2013-04-10 00:00:00
 | Product 2 | 120 |  |  |  |  |  |  | 4000
 | Product 3 | 300 |  |  |  |  |  |  | 4500
 | Product 4 | 100 |  |  |  |  |  |  | 14000
 | Product 5 | 50 |  |  |  |  |  |  | 3800
 | Product 6 | 80 |  |  |  |  |  |  | 8000
 | Product 7 | 30 |  |  |  |  |  |  | 9000
 | Product 8
 | Product 9
 | Product 10
 | Product 11
 | Product 12
 | Product 13
 | Product 14
 | Product 15
 | Product 16
 | Product 17
 | Product 18
 | Product 19
 | Product 20
 | Product 21
 | Product 22
 | Product 23
 | Product 24
 | Product 25
 | Product 26
 | Product 27
 | Product 28
 | Product 29
 | Product 30
 | Product 31
 | Product 32
 | Product 33
 | Product 34
 | Product 35
 | Product 36
 | Product 37
 | Product 38
 | Product 39
 | Product 40
 | Product 41
 | Product 42
 | Product 43
 | Product 44
 | Product 45
 | Product 46
 | Product 47
 | Product 48
 | Product 49
 | Product 50
Spreadsheet: 99990d1298487562-count-on-multiple-criteria-within-spcified-range-excel-2003-count-on-multiple-rows
Sheet: Sheet1

 |  |  |  |  | type | Mono# | Mono# | Date Complete | Date Complete
Start Period | 2010-12-01 00:00:00 |  |  |  | a | >24 | <32 | >=40513 | <=40543
End Period | 2010-12-31 00:00:00
Name (not important) | type | Mono# | Date Complete |  | type | Mono# | Mono# | Date Complete | Date Complete
1 | a | 25 | 2010-10-12 00:00:00 |  | b | >24 | <32 | >=40513 | <=40543
2 | b | 26 | 2010-12-09 00:00:00
3 | a | 27 | 2010-12-14 00:00:00 |  | type | Mono# | Mono# | Date Complete | Date Complete
4 | b | 28 | 2010-12-11 00:00:00 |  | a | >30 | <40 | >=40513 | <=40543
5 | a | 29 | 2010-12-15 00:00:00
6 | b | 30 | 2010-12-13 00:00:00 |  | type | Mono# | Mono# | Date Complete | Date Complete
7 | a | 31 | 2011-01-03 00:00:00 |  | b | >30 | <40 | >=40513 | <=40543
8 | b | 32 | 2010-12-14 00:00:00
9 | a | 33 | 2011-01-03 00:00:00
10 | b | 34 | 2010-12-15 00:00:00
11 | a | 35 | 2011-01-04 00:00:00
12 | b | 36 | 2010-12-16 00:00:00
13 | a | 37 | 2011-01-07 00:00:00
14 | b | 38 | 2011-01-03 00:00:00
15 | a | 39 | 2011-01-07 00:00:00
 | #
Range 25-31 A | 2 | 2 | [NAME] needed
Range 25-31 B | 3
Range 31-39 A | 0
Range 31-39 B | 3
Spreadsheet: 89755d1289494702-today-line-on-a-graph-not-working
Sheet: Monthly Graph

Month | Materials Required | Scheduled Install | Actual Install | Scheduled Commission | Actual Commission | Scheduled Verification | Actual Verification | Opportunities | Today
September 2010
October 2010
November 2010
December 2010
January
February
March
April
May
June
July
August
September
October
November
December
Month | [NAME] | Opportunity
September 2010
October 2010
November 2010
December 2010
January 2011
February 2011
March 2011
April 2011
May 2011
June 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
Spreadsheet: 137210d1327002087-calculation-based-on-cell-colour-change-orders-sheet-example_reply2
Sheet: Stock Orders

 | ORDER NO. | CUSTOMER / ADRESS | DEL FROM | DEL TILL | CAT | FOR | PREFIX | STYLE | COLOUR | XS_28 | S_30 | M_32 | L_34 | [NAME] | XXL_38 | TOTAL | Notes
 | 1 | Customer 1 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCHZ | COLIN-885 | White | 0 | 2 | 3 | 2 | 1 | 1 | 9
 | 2 | Customer 2 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCHZ | COLIN-885 | WATERFALL | 0 | 1 | 2 | 2 | 1 | 0 | 6
 | 3 | Customer 3 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCPJ | ANDERSON-130 | BLUE ASTER | 0 | 3 | 4 | 3 | 2 | 1 | 13 | Dispatched
 | 4 | Customer 4 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCHZ | BURTON-981 | Peacoat | 0 | 2 | 3 | 2 | 1 | 1 | 9
 | 5 | Customer 5 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCPJ | ANDERSON-130 | Peacoat | 0 | 3 | 4 | 3 | 2 | 1 | 13
 | 6 | Customer 6 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCJK | RANDEL-950 | RUDE WINE | 0 | 1 | 2 | 2 | 1 | 0 | 6 | Dispatched
 | 7 | Customer 7 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCJK | STEPHENS-937 | BLACK | 0 | 2 | 3 | 2 | 1 | 1 | 9 | Dispatched
 | 8 | Customer 8 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCJK | STEPHENS-937 | BLUE ASTER | 0 | 2 | 3 | 2 | 1 | 1 | 9 | Dispatched
 | 9 | Customer 9 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCJK | RANDEL-950 | TWILIGHT BLUE | 0 | 2 | 3 | 3 | 2 | 1 | 11 | Dispatched
 | 10 | Customer 10 | 2012-01-01 00:00:00 | 2012-03-30 00:00:00 | P&P | MEN | UCJK | RANDEL-950 | RUDE WINE | 0 | 2 | 3 | 3 | 2 | 1 | 11 | Dispatched
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | When "Dispatched" entered in Notes record appears in Stock Dispatched Sheet.
Spreadsheet: 2b53a7ad-14c1-4dcb-8576-248e2d63f1fd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | PRESUPUESTO 2008 | Unnamed: 7
ESTADO CONSOLIDADO DEL EXMO. AYUNTAMIENTO xxxxxx Y DE SUS ORGANISMOS AUTÓNOMOS Y SOCIEDADES DEPENDIENTES
[NAME] | Denominación |  | Importe | [NAME] | Denominación |  | Importe
1 | Impuestos directos |  |  | 1 | Gastos de personal
2 | Impuestos indirectos |  |  | 2 | Gastos corrientes en bienes y servicios
3 | Tasas y otros ingresos |  |  | 3 | Gastos financieros
4 | Transferencias corrientes |  |  | 4 | Transferencias corrientes
5 | Ingresos patrimoniales
 | Operaciones corrientes |  | 0 |  | Operaciones corrientes |  | 0
6 | Enajenación inversiones |  |  | 6 | Inversiones reales
7 | Transferencias de capital |  |  | 7 | Trasnferencias de capital
 | Operaciones de capital |  | 0 |  | Operaciones de capital |  | 0
 | Operaciones no financ. |  | 0 |  | Operaciones no financ. |  | 0
8 | Var. activos financieros |  |  | 8 | Var. activos financieros
 | Var. activos financieros |  |  |  | Var. activos financieros
9 | Var. [NAME] |  |  | 9 | Var. [NAME]
 | Var. [NAME] |  |  |  | Var. [NAME]
 | Operaciones financieras |  | 0 |  | Operaciones financieras |  | 0
 | Operaciones financieras |  |  |  | Operaciones financieras
 | TOTAL INGRESOS |  | 0 |  | TOTAL DE GASTOS
 |  |  |  |  |  |  | 0
 |  |  |  | Estabilidad Presupuestaria |  |  | 0
Cuadro 1.1
Spreadsheet: 224127d1364463284-automatically-copy-a-row-of-sheet1-to-the-next-row-in-sheet2-if-a-cell-in-column-c-xyz-test-book
Sheet: Master Sheet

DATE | NAME | CODE | JOB [NAME] | ADVANCE | TOTAL COST | BALANCE
 | Smith | 405
 | Micheal | 404
 | [NAME] | 401
 | Smith | 405
 | [NAME] | 401
 | dora | 402
 | [NAME] | 403
 | Micheal | 404
Spreadsheet: 148981d1333638675-min-sec-issue-dates-test
Sheet: Sheet1

Hold | Duration
44 s. | 4.3 min.
1.1 min. | 2 min.
47 s. | 1.2 min.
1.6 min. | 2.4 min.
39 s. | 5.8 min.
21 s. | 2.1 min.
29 s. | 59 s.
55 s. | 1.4 min.
55 s. | 58 s.
9 s. | 1.9 min.
27 s. | 2.1 min.
57 s. | 1.9 min.
12 s. | 2.1 min.
8 s. | 1.1 min.
9 s. | 25 s.
31 s. | 3 s.
48 s. | 41 s.
1.5 min. | 1.7 min.
48 s. | 50 s.
2.6 min. | 58 s.
3.2 min. | 1 min.
8 s. | 1.2 min.
46 s. | 4.5 min.
44 s. | 50 s.
22 s. | 12 s.
7 s. | 1.6 min.
1.2 min. | 51 s.
9 s. | 3.3 min.
47 s. | 59 s.
47 s. | 2.3 min.
12 s. | 5.6 min.
20 s. | 36 s.
1.2 min. | 4.3 min.
1.2 min. | 2 min.
8 s. | 1 min.
11 s. | 1.7 min.
7 s. | 2.2 min.
30 s. | 2.1 min.
8 s. | 4.3 min.
31 s. | 1.3 min.
1 min. | 2.1 min.
13 s. | 4.6 min.
14 s. | 3 min.
11 s. | 37 s.
58 s. | 59 s.
40 s. | 4.2 min.
6 s. | 49 s.
9 s. | 3.1 min.
18 s. | 43 s.
22 s. | 37 s.
22 s. | 41 s.
9 s. | 3 min.
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: DEG

Raw Material |  | DEG
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 10668.11
2023-10-28 00:00:00 |  | 10 | 230
Total
Spreadsheet: 90801d1290532663-how-to-get-a-list-based-on-month-wise-attendees
Sheet: Sheet2

2010-11-01 00:00:00 | Put in first of month
1
2
3
4
5
6
7
8
9
10
11
12
13
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1
2
3 |  | -2368
4 |  | -2368
5 |  | -2368
6 |  | -2368
7 |  | -2368
8
9
10
11
12
13
14
15
16 | -4
17 | -1
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 76325
2001-08-22 00:00:00
CBS Dollars
 |  |  | 341220.3
Spreadsheet: 284d70d5-ad87-4d7f-a312-2b207ce179f1
Sheet: Quality (Optional)

Project Name |  |  |  |  |  |  | Sponsor
Project Manager |  |  |  |  |  |  | Date Updated
Software Defects | Months
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
System Test
Severity High
High - Open
High - Closed
High - Total
Severity Medium
Medium - Open
Medium - Closed
Medium - Total
Severity Low
Low - Open
Low - Closed
Low - Total
Total Open
Total Closed
Total Defects
Acceptance Test
Severity High
High - Open
High - Closed
High - Total
Severity Medium
Medium - Open
Medium - Closed
Medium - Total
Severity Low
Low - Open
Low - Closed
Low - Total
Total Open
Total Closed
Total Defects
Spreadsheet: 714728d1611338537-help-with-commission-calculations-question-etaf
Sheet: Sheet1

customer | SP | stock# | Date | Type | PROFIT | COMMISSION | NET INCOME
kluger shimon | YK | 884230 | 2021-01-25 00:00:00 | A | 3400
[NAME] | YK | 86359 | 2021-01-27 00:00:00 | B | 860
 |  |  |  | A | 200
 |  |  |  | B | 4000
Profit – 150
If [NAME]  less than $1500  35%  , anything higher than 1500 is 50%
If [NAME]  less than $1500  25%  , anything higher than 1500 is 40%
Spreadsheet: 772662d1647427596-check-if-date-falls-in-condition-test5
Sheet: Sheet1

[NAME] | 90 Days
2016-11-19 13:22:16
2016-10-29 11:46:06
2017-10-08 18:08:30
2018-06-02 12:16:03
2017-12-21 12:09:17
2023-09-15 13:54:40
2016-10-23 08:47:11
2019-08-16 15:14:44
2019-01-10 14:50:47
2016-12-05 16:02:26
2017-01-30 14:19:33
2017-02-01 15:11:36
2018-07-20 10:52:42
2017-01-28 14:03:23
2022-05-26 11:23:30
2016-11-21 16:17:58
2018-09-05 11:09:04
2020-10-09 15:11:28
2022-07-23 11:35:20
2020-06-27 17:05:02
2021-06-07 14:49:59
2021-01-09 10:53:04
2016-12-16 10:10:49
2021-03-15 10:41:37
2023-01-13 13:12:11
2018-11-16 14:36:39
2018-02-09 08:55:27
2017-09-14 16:52:41
2017-05-01 12:13:45
2017-04-14 14:28:21
2017-04-14 15:43:38
2018-08-11 16:09:07
2016-05-07 06:58:25
2017-01-16 16:16:17
2022-04-06 14:34:10
2018-06-28 10:50:08
2019-01-10 14:57:30
2017-01-28 09:43:39
Spreadsheet: 850324d1700680413-conditional-formatting-formula-based-on-multiple-criteria-sample-workbook
Sheet: PostA

[NAME] | Year | Status | Training | Start Date
10015 | 2010-2011 | In Progress | ASD 403123 | 2010-09-20 00:00:00
10015 | 2010-2011 | In Progress | FortitudeX989 | 2011-02-22 00:00:00
10015 | 2011-2012 | In Progress | ASD 403124 | 2011-04-22 00:00:00
10015 | 2012-2013 | In Progress | ASD 403124 | 2013-08-01 00:00:00
10015 |  | Completed | ASD 403123 | 2013-11-01 00:00:00
10015 |  | Required to Discontinue | ADD 42 | 2014-10-01 00:00:00
10022 |  | In Progress | ASD 403939 | 2015-10-01 00:00:00
10022 |  | In Progress | ADD 40 | 2016-09-01 00:00:00
… | … | … | … | …
Desired Result: | Highlight rows that meet the below objective as in sample table above
Objective: | To capture where the all duplicates (triplciates, etc.) "In progress" statuses that need to manually adjusted by creating a conditional format to highlight rows that meet the following criteria:
Explanation of Criteria: | Status must be "in progress"
 | Training must be a different name
 | In Progess must follow another in progress
Note: Data (20,000 rows) is sorted in order of priority as follows:
[NAME]
Year
Start Date
Spreadsheet: 219921d1363014434-please-help-with-a-couple-issues-with-adding-moving-columns-financial-accounting-columbia-cu-hazel-savings-2010-upload
Sheet: Transactions

 | 2010 Final Smith Accounting-Joint Account Transactions
 | Bank Name: |  | Columbia Credit Union |  |  |  |  |  | Account: | Account #: |  | xxxxx
 | Accounts Reviewed: |  | Savings-Suffix 0 |  |  |  |  | Account Holder: |  | Account Holder: |  | [NAME]
 | Account Timeperiod: |  | January 1, 2010 - December 31, 2010
Account | Date | Category | Payee | Check # | Payment Amount | Deposit Amount | Amounts for Report | Cleared Payment | Cleared Deposit | Account Balance | Comments
 | 2010-01-01 00:00:00 | AV Starting Account Balance | Deposit |  |  | 5
 | 2010-05-08 00:00:00 | [NAME] | Deposit |  |  | 300
 | 2010-05-23 00:00:00 | AP Transfer Withdrawals | [NAME] |  | 300
 | 2010-05-31 00:00:00 | AV Account Earned Interest | Deposit |  |  | 0.03
Spreadsheet: 91694d1291368298-conditional-formatting-excel-help
Sheet: Sheet1

RM | Type | Client | Fee | Product | Revenue | Last Visit
J.B | Gold | Cust 1 | fixed | fixed | XX | 2010-11-10 00:00:00
J.B | Gold | Cust 2 | fixed | fixed | XX | 2010-12-02 00:00:00
J.B | Gold | Cust 3 | fixed | fixed | XX
J.B | Gold | Cust 4 | fixed | fixed | XX
J.B | Gold | Cust 5 | fixed | fixed | XX
J.B | Gold | Cust 6 | fixed | fixed | XX
J.B | Silver | Cust 7 | fixed | fixed | XX
J.B | Silver | Cust 8 | fixed | fixed | XX
J.B | Silver | Cust 9 | fixed | fixed | XX
J.B | Silver | Cust 10 | fixed | fixed | XX
J.B | Silver | Cust 11 | fixed | fixed | XX
J.B | Silver | Cust 12 | fixed | fixed | XX
J.B | Silver | Cust 13 | fixed | fixed | XX
J.B | Silver | Cust 14 | fixed | fixed | XX
 |  | Gold clients every 90 days
 |  | Silver Clients every 180 days
Spreadsheet: 220294d1363113811-populating-data-into-a-summary-tab-using-multiple-data-tabs-formulahelp1
Sheet: PQR

 |  |  |  | 202 | 204 | 52 | 20 | Total
 |  |  | EHI | 2 | 0 | 667 | 66
 |  |  | BSI | 32 | 4 | 3 | 565
 |  |  | RMI | 1 | 45 | 7 | 777
 |  |  | USI | 1 | 0 | 777 | 434
 |  |  | OHP | 7675 | 67 | 1 | 1
 |  |  | MAM | 757 | 0 | 44 | 0
 |  |  | WHO | 1 | 76 | 4 | 56
 |  |  | MVP | 57 | 564 | 56 | 656
 |  |  | CVI | 2 | 34 | 3434 | 875
 |  |  | HUI | 5 | 7 | 56 | 0
 |  |  | NCI | 2 | 767 | 688 | 777
 |  |  | HIP | 1 | 0 | 0 | 0
 |  |  | VIS | 4534 | 8 | 65 | 44
 |  |  | AMI | 8 | 56 | 444 | 234
 |  |  | JHP | 2 | 56 | 0 | 886
 |  |  | PIC | 1 | 0 | 666 | 0
 |  |  | HNI | 4 | 56 | 66 | 877
Spreadsheet: 216764d1361883421-use-several-cells-from-differnt-areas-as-one-row-or-column-test_one_row_column
Sheet: Hárok1

numbers are  in various cells  from different areas
 | 12 | 5
 |  |  | 2 | -7
wanted - one compact row formula
wanted - one compact column formula
another example - broken row |  |  | 12 | 34
 | 11 | 8
one-row formula:
Spreadsheet: 186594d1350096738-find-text-in-array-and-return-adjacent-cell-value-sample-worksheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | RESULT
 |  |  |  | 60177358001 | 50 | Y |  |  |  | 177758384
 |  |  |  | 60177514736 | BARRED |  |  |  |  | 177699667
 |  |  |  | 60177536504 | ACTIVE | Y |  |  |  | 177358001
 |  |  |  | 60177566236 | ACTIVE | N |  |  |  | 177514736
 |  |  |  | 60177699667 | SUSPEND |  |  |  |  | 177536504
 |  |  |  | 60177770082 |  |  |  |  |  | 177566236
Spreadsheet: 52767d1252592113-sum-a-column-if-certain-criteria-is-met-that-resides-in-other-columns-sample
Sheet: Sheet1

 |  |  |  |  |  |  | < Filtered Criteria
Identifer | Amount | Due Date | Interest only | Code | Fixed/Adjustable | Accrued
1 | 500 | 2009-01-01 00:00:00 | N | AUTO | F | N
2 | 300 | 2009-01-02 00:00:00 | Y | CREDIT | F | N
3 | 200 | 2009-01-03 00:00:00 | Y | CREDIT | A | N
4 | 233 | 2009-01-04 00:00:00 | Y | AUTO | A | N
5 | 50 | 2009-01-05 00:00:00 | N | CREDIT | F | Y
6 | 75 | 2009-01-06 00:00:00 | N | AUTO | A | Y
7 | 25 | 2009-01-07 00:00:00 | N | AUTO | F | N
8 | 222 | 2009-01-08 00:00:00 | N | CREDIT | F | N
9 | 4886 | 2009-01-09 00:00:00 | Y | CREDIT | A | N
10 | 1187633 | 2009-01-10 00:00:00 | N | EQUITY | A | Y
11 | 214 | 2009-01-11 00:00:00 | Y | EQUITY | A | N
12 | 2159 | 2009-01-12 00:00:00 | N | AUTO | F | N
13 | 92211 | 2009-01-13 00:00:00 | N | LOAN | F | N
14 | 2658 | 2009-01-14 00:00:00 | N | OTHER | A | N
15 | 2254 | 2009-01-15 00:00:00 | Y | OTHER | A | N
criteria
total sum if code =auto and equity, and fixed and adjustable=A, interest only=n and accrued =n
Subtotal: | 2684
Spreadsheet: 07fc84ef-b4c4-4421-9235-a07d8a176e7a
Sheet: Sheet1

Předmět | Od | Do | [NAME]
Nový rok | 1.1.2012 | 2012-01-01 00:00:00
GO + Regiontour | 2012-01-12 00:00:00 | 2012-01-15 00:00:00 | Brno
Sektorová rada pro vyhrazená zařízení | 18.1.2012 | 18.1.2012 | [NAME], [NAME]
Měsíčník ALDR | 3.2.2012 | 3.2.2012
Dozorčí rada | 1.3.2012 | 1.3.2012 | [NAME]
Měsíčník ALDR | 2.3.2012 | 2.3.2012
[NAME] | 19.3.2012 | 22.3.2012 | Baqueira (Spain)
Jednání výkonného výboru | 30.3.2012 | 30.3.2012 | Harrachov
SkiLift Cup | 31.3.2012 | 2012-04-01 00:00:00 | Harrachov
[NAME] bulletin | 2012-04-02 00:00:00 | 2012-04-02 00:00:00
Měsíčník ALDR | 6.4.2012 | 6.4.2012
Pondělí velikonoční | 9.4.2012 | 9.4.2012
[NAME] | 16.4.2012 | 22.4.2012 | [NAME]
Veletrh ProWinter | 18.4.2012 | 20.4.2012 | Bolzano (Italia)
Setkání výrobců s dozorovými orgány, DU, MD | 2012-04-24 00:00:00 | 2012-04-24 00:00:00 | [NAME] Moravě
Valná hromada | 2012-04-25 00:00:00 | 2012-04-25 00:00:00 | [NAME] Moravě
Svátek práce | 1.5.2012 | 1.5.2012
Měsíčník ALDR | 4.5.2012 | 4.5.2012
Informační bulletin - vydání | 7.5.2012 | 7.5.2012
Osvobození | 8.5.2012 | 8.5.2012
Školení náčelníků - Švýcaři | 15.5.2012 | 17.5.2012 | [NAME] Moravě
Školení zaplétačů | 29.5.2012 | 30.5.2012 | Harrachov
Školení elektrikářů | 31.5.2012 | 31.5.2012 | Harrachov
Měsíčník ALDR | 1.6.2012 | 1.6.2012
Školení [NAME] | 10.6.2012 | 15.6.2012
Jednání výkonného výboru | 28.6.2012 | 28.6.2012 | [NAME]
Měsíčník ALDR | 4.7.2012 | 4.7.2012
Cyril a Metoděj | 5.7.2012 | 5.7.2012
[NAME] | 6.7.2012 | 6.7.2012
Dozorčí rada | 12.7.2012 | 12.7.2012 | [NAME]
Měsíčník ALDR | 3.8.2012 | 3.8.2012
Uzávěrka veletržní katalog | 24.8.2012 | 24.8.2012
Jednání výkonného výboru | 6.9.2012 | 6.9.2012
Měsíčník ALDR | 7.9.2012 | 7.9.2012
[NAME] bulletin | 2012-09-27 00:00:00 | 2012-09-27 00:00:00
[NAME] | 28.9.2012 | 28.9.2012
Veletrh InterMountain | [NAME]
Měsíčník ALDR | 5.10.2012 | 5.10.2012
Dozorčí rada | 18.10.2012 | 18.10.2012
Den státnosti | 28.10.2012 | 28.10.2012
Měsíčník ALDR | 2.11.2012 | 2.11.2012
Jeseníky/Šumava ŠOLV | 2.11.2012 | 2.11.2012
Jeseníky/Šumava ŠOLV | 3.11.2012 | 3.11.2012
Tisková konference | 6.11.2012 | 6.11.2012
Informační bulletin - vydání | 2012-11-09 00:00:00 | 2012-11-09 00:00:00
Vysočina ŠOLV | 9.11.2012 | 9.11.2012
Vysočina ŠOLV | 2012-11-10 00:00:00 | 2012-11-10 00:00:00
Beskydy/Krušné hory ŠOLV | 16.11.2012 | 16.11.2012
[NAME] boje za svobodu a demokracii | 17.11.2012 | 17.11.2012
Beskydy / Krušné hory ŠOLV | 17.11.2012 | 17.11.2012
Výkonný výbor | 22.11.2012 | 22.11.2012
Krkonoše/Zlín ŠOLV | 23.11.2012 | 23.11.2012
Krkonoše ŠOLV | 24.11.2012 | 24.11.2012 | Rokytnice
Měsíčník ALDR | 7.12.2012 | 7.12.2012
Vánoce | 24.12.2012 | 26.12.2012