tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838414d1690986173-countif-index-match-query-approved-suppliers-list
Sheet: Supplier Documents

Contractor | Service / Product | Information Processing Type | NDA Required | NDA Received | Insurance Exp Date | Current Safety Statement Date last checked | Permits & Licences | Expires | Type required
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  | None |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
 |  |  |  | No
Spreadsheet: 105382d1302751964-how-to-display-a-blank-value-instead-of-div-0-example-sheet-1-
Sheet: Line-A

EMERGENCY LODGING CENTER PROJECT, SHUMAISI
EXTERNAL WORKS - ROAD PROJECTS
Storm Drainage System
Excavation
Line No. | Pipe Dia. | From Manhole | To Manhole | Average N.G.L |  |  | Average Excavation |  |  | Hight | [NAME] | Length | Volume | Remarks
 |  |  |  | 1 | 2 | AV | 1 | 2 | AV
Line A | 700 | SD.MH-A3 | SD.MH-A4 | 200 | 500 | 350 | 250 | 50 | 150 | 200 | 1.3 | 85.5 | 22230 | WOW!
"       " | 700 | SD.MH-A4 | SD.MH-A5 |  |  |  |  |  |  |  | 1.3 | 83
"       " | 700 | SD.MH-A5 | SD.MH-A6 |  |  |  |  |  |  |  | 1.3 | 96
"       " | 600 | SD.MH-A6 | SD.MH-A7 |  |  |  |  |  |  |  | 1.2 | 100
"       " | 600 | SD.MH-A7 | SD.MH-A8 |  |  |  |  |  |  |  | 1.2 | 100
"       " | 500 | SD.MH-A8 | SD.MH-A9 |  |  |  |  |  |  |  | 1.1 | 93.5
"       " | 500 | SD.MH-A9 | SD.MH-A10 |  |  |  |  |  |  |  | 1.1 | 106
"       " | 400 | SD.MH-A10 | SD.MH-A11 |  |  |  |  |  |  |  | 1 | 100
"       " | 400 | SD.MH-A11 | SD.MH-A12 |  |  |  |  |  |  |  | 1 | 100
"       " | 700 | SD.MH-A3 | SD.MH-A2 |  |  |  |  |  |  |  | 1.3 | 111.5
"       " | 800 | SD.MH-A2 | SD.MH-A1 |  |  |  |  |  |  |  | 1.4 | 100
"       " | 800 | SD.MH-A1 | SD.MH-A |  |  |  |  |  |  |  | 1.4 | 60.5
"       " | 1400 | SD.MH-A | SD.MH-1A |  |  |  |  |  |  |  | 2 | 84.5
"       " | 1400 | SD.MH-1A | SD.MH-2A |  |  |  |  |  |  |  | 2 | 84.5
"       " | 1800 | SD.MH-2A | SD.MH-3A |  |  |  |  |  |  |  | 2.4 | 95
"       " | 1800 | SD.MH-3A | SD.MH-4A |  |  |  |  |  |  |  | 2.4 | 95
"       " | 1800 | SD.MH-4A | SD.MH-5A |  |  |  |  |  |  |  | 2.4 | 96
"       " | 2000 | SD.MH-5A | SD.MH-6A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-6A | SD.MH-7A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-7A | SD.MH-8A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-8A | SD.MH-9A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-9A | SD.MH-10A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-10A | SD.MH-11A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-11A | SD.MH-12A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-12A | SD.MH-13A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-13A | SD.MH-14A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-14A | SD.MH-15A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-15A | SD.MH-16A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-16A | SD.MH-17A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-17A | SD.MH-18A |  |  |  |  |  |  |  | 2.6 | 75
"       " | 2000 | SD.MH-18A | SD.MH-19A |  |  |  |  |  |  |  | 2.6 | 75
 |  |  |  |  |  |  |  |  |  |  | Total Volume
Spreadsheet: 673905d1587584361-formula-to-calculate-business-days-wwc-team-metrics
Sheet: Productivity

Agent Name | [NAME] | Inbound Handled | Outbound Handled | [NAME] | Refused | Refused Time | ACW Time | Working Time | ADP HOURS | WORKING RATE
Burger, [NAME] | Price, Riley | 111 | 30 | 12.4 | 3 | 38.07 | 41.18 | 5366.48 | 109.37
Bustillos, [NAME] | Porter, Heather | 53 | 66 | 8.6 | 1 | 3.46 | 17.37 | 5972.2 | 112.53
[NAME], Darnell | Price, Riley | 78 | 38 | 15.98 | 8 | 21.86 | 19.5 | 6036.38 | 116.07
Palmer2, Cherelle | Tanner, Charlette | 66 | 39 | 11.01 | 13 | 57.25 | 34.87 | 5106.58 | 107.83
Roles2, Sage | Tanner, Charlette | 117 | 25 | 13.75 | 7 | 34.19 | 19.74 | 5798.41 | 113.46
[NAME], Brandi | Pigott, Brandon | 63 | 4 | 10.34 | 6 | 64.22 | 17.03 | 4327 | 93.77
Wilson, Janelle | Pigott, Brandon | 121 | 7 | 5.95 | 30 | 101.87 | 7.69 | 5182.05 | 96.52
Spreadsheet: 121501d1316099734-conditional-sums-in-a-filtered-table-excel-help-forum-sales-example-data
Sheet: Sheet1

sale number | project number | price quoted | product type
1 |  | 15000 | 215
2 | 102 | 26000 | 230
3 |  | 3000 | 230
4 | 100 | 6000 | 230
5 | 101 | 11000 | 215
6 |  | 1900 | 215
 | total value of sales quotes: |  |  | = SUM(C2:C7)
 | value of displayed  sales quotes: |  |  | =SUBTOTAL(109, C2:C7)
 | desired solution:
 | value of displayed sales quotes that  GOT A PROJECT NUMBER (i.e. got sold)
 |  |  |  | =SUMIF(B3:B5, ">0", [NAME])
 | for example, if you filter "product type" to show just  product 215,   you want  a final number of 11000/(15000+11000+1900)= 39.4%
 | I can get the denominator with '= SUBTOTAL(109, C2:C7), but I'm having trouble getting the numerator without using another filter criterion on the project number column.
Spreadsheet: 216850d1361906753-converting-rows-to-columns-transpose-transpose-example
Sheet: Sheet1

Emp Number | Segment Name | Segment Value
1000 | Bus Unit | A
1000 | Cost Center | 24
1000 | Mandant | 01
1000 | Work Schedule Code | 1
1001 | Bus Unit | A
1001 | Cost Center | 11
1001 | Mandant | 02
1001 | Work Schedule Code | 1
1002 | Bus Unit | A
1002 | Cost Center | 18
1002 | Mandant | 01
1002 | Work Schedule Code | 1
Spreadsheet: 156604d1337356097-displaying-values-after-multiple-drop-down-box-selection-dropdown-example-modified-by-tigeravatar-
Sheet: Sheet1

REP | Company | Stage |  |  | Rep List | Stage Lists
Smith | WorldWide Corp | Pre-Presentation
Jones | AmeriCorp | 1st Presentation Complete
Ferguson | Innetech | Contract Presented
Black | Innetrode | Pre-Presentation
Jones | DM Company | Contract Presented
Jones | Perfect Products | Contract Presented
Ferguson | Sample A | 1st Presentation Complete
Black | Sample B | Contract Presented
Black | Sample C | 1st Presentation Complete
Smith | Company 1 | Contract Presented
Jones | Famous Company | 1st Presentation Complete
Ferguson | Best Company | Contract Presented
Black | Worst Company | Pre-Presentation
Smith | City Corp | Pre-Presentation
Ferguson | [NAME] | Pre-Presentation
Spreadsheet: 32770d1228934421-conditional-counter-compiler-conditonal-counter
Sheet: Counter

Simple Counter |  |  | Count of Issued Jobs: | 1 | 0
 |  | JOB# | STATUS | QTY
Start | 0 | 1 | Preliminary | 10 | 10
End | 225 | 2 | Preliminary | 2 | 2
Counter | 222 | 3 | Issued | 3 | 3
 |  | 4 | Released | 4 | 4
 |  | 5 | Preliminary | 3 | 3
 |  |  | Total (Issued) | 3
CONDITIONS
Preliminary |  |  | Total QTY ALL |  | 22
Invoiced |  |  | [NAME]) | 0
Hold |  |  | Control (Released) | 4
Pending |  |  | Control (Invoiced) | 0
Released |  |  | Control (Hold) | 0
Issued |  |  | Control (Pending) | 0
Complete |  |  | Total | 4
Spreadsheet: michelle_lokay__26576__Dec00pnr
Sheet: USGT Nov-Dec

 |  |  |  | 14243
 |  |  |  |  |  |  |  |  |  |  |  | Ratable Payback in December
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP |  |  | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP
 | USGT | 27268 | 00/11 | 500615 | PnR |  |  |  |  |  |  |  |  |  |  | -14243
1 |  |  |  |  |  |  |  |  |  |  |  | 14243 |  |  |  |  |  |  | 0.3883
2 |  |  |  |  |  |  |  |  |  |  |  | 14243 |  |  |  |  |  |  | 0.3883
3 |  |  |  |  |  |  |  |  |  |  |  | 14243 |  |  |  |  |  |  | 0.3883
4 |  |  |  |  |  |  |  |  |  |  |  | 14243 |  |  |  |  |  |  | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 14198 | 14243 |  |  |  |  |  |  | 0.3883
6 |  |  |  |  |  |  |  |  |  |  |  |  | 14198 |  |  |  |  |  | 0.3883
7 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
8 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
9 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
10 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
11 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
12 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
13 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
14 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
15 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
16 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
17 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
18 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
19 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
20 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
21 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
22 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
23 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
24 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
25 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
26 |  |  |  |  |  |  | -7293 |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
27 |  |  |  |  |  |  | -6950 |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
28 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
29 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
30 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 0.3883
 |  |  |  |  |  |  | Rate/Dth | 3.68
 |  |  |  |  |  | Invoice Amount |  |  | To be Invoiced with December Activity
 |  |  |  | Total Injection
 |  |  |  | Total W/D
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.27.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-27 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 11 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 22 | 0 | 5 | 0 | 2 | 1 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 24 | 0 | 4 | 0 | 1 | 0 | 0 | 3 | 0
 | ABC | 27 | 18 | 24 | 1 | 6 | 1 | 0 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-27 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 4 | 0 | 1 | 0 | 0 | 1 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 1 | 1 | 1 | 0 | 2 | 0
 | ABC | 27 | 18 | 18 | 0 | 5 | 1 | 2 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 1 | 1 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 226470d1365422684-how-do-i-take-a-two-digit-number-separate-the-two-digits-add-them-together-show-result-opc-code-algorythm
Sheet: Sheet1

 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th
 | Number | 0 | 2 | 0 | 7 | 1 | 1 | 8 | 2 | 1
 | Algorythm | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2
 | Result
 | Check digit
 |  | The algorythm:
 |  | Starting with the leftmost digit, multiply each digit by a weighting factor. The weighting factor follows a repeating 212 pattern. The first digit is multiplied by 2, the second digit by 1, the third digit by 2, the fourth digit by 1, and so on.Using our sample barcode above, we start with the number 020711721
 |  | 0 * 2 = | 0
 |  | 2 * 1 = | 2
 |  | 0 * 2 = | 0
 |  | 7 * 1 = | 7
 |  | 1 * 2 = | 2
 |  | 1 * 1 = | 1
 |  | 7 * 2 = | 14
 |  | 2 * 1 = | 2
 |  | 1 * 2 = | 2
 |  | Now sum all of the products, treating 2-digit numbers as individual digits. In the above example, 14 would be treated as a 1 and a 4:
 |  | 0 + 2 + 0 + 7 + 2 + 1 + 1 + 4 + 2 + 2 = 21
 |  | Divide the result by 10; in this example, 21 divided by 10 = 2 with a remainder of 1. Subtract the remainder from 10 to obtain the check digit; in this case, 10 - 1 = 9. If the result is 10 (in the case of 10 - 0 = 10) change the result to 0.
Spreadsheet: 32062d1228178371-compilation-work-sheet-balance
Sheet: GHI Supply

Date | Qty | Description | Cost | Amount | Credits | Balance
2008-01-05 00:00:00 | 1 | [NAME] | 1.71 | 1.71 |  | 1.71
2008-01-09 00:00:00 | 6 | Henges | 1.69 | 10.14 |  | 11.85
2008-01-12 00:00:00 | 1 | WD-40 | 2.5 | 2.5 |  | 14.35
2008-01-14 00:00:00 |  |  |  |  | 4.35 | 10
Spreadsheet: 138623d1327769321-budget-analysis-test-formulas
Sheet: RUNNING TOTALS

Expense Categories | Accumulating Totals
[NAME] (JMP)
[NAME] (Breadwinner)
Other Income
Mortgage
Consolidation Loan
Vanessa Loan PMT.
Savings
Groceries
Fuel (Car)
Restaurants (Take-away, Drinks etc.)
Enbridge (gas)
Rogers (Cable, Wireless & Internet)
Car Insurance
Home Insurance
TTC (Monthly Metrpass)
Dry Cleaning
Parking
Protein (Nutritional Supplements)
House (Maint. & Repair)
Misc._Shopping, Clothing, [NAME], etc.
Pets (The Fern)
Bank Fees + Charges
TD Bank F* Social + Lottery Fund
Legal, Accounting fees
Hydro (electricity)
Water + Waste Removal
Car (Maint. & Repair)
VISA PMT
Cash W/D
OTHER ([NAME].)
Spreadsheet: 728706d1618582426-sum-vertical-and-horizontal-time-tracking-by-user-sum-vertical-and-horizontal-time-tracking-by-user
Sheet: Sheet1

Month |  | jan | jan | jan | jan | Feb | Feb | Feb | Feb | Mar | Mar | Mar | Mar
Week |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
[NAME] | Project 1 | 2 | 4 | 6 | 6 | 4 | 7 | 8 | 5 | 4 | 6 | 5 | 7
[NAME] | Project 1 | 6 | 7 | 5 | 4 | 3 | 5 | 4 | 2 | 1 | 3 | 1 | 2
[NAME] | Project 1 | 3 | 2 | 3 | 4 | 3 | 2 | 3 | 4 | 3 | 2 | 4 | 3
[NAME] | Project 2 | 2 | 3 | 1 | 3 | 4 | 2 | 1 | 2 | 3 | 2 | 2 | 2
[NAME] | Project 2 | 3 | 2 |  | 4 |  | 4 |  | 4 | 4 |  | 4
[NAME] | Project 2 | 2 |  | 2 | 2 | 2 | 2 | 2 | 3 | 4 |  | 5 | 4
[NAME] | Project 2 | 3 |  | 4 |  |  | 5 | 6 | 6 | 4 |  | 3 | 2
Summary
[NAME]
[NAME]
[NAME]
[NAME]
project 1
Project 2
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: June2012

 |  |  |  |  |  |  |  |  |  |  |  | 0.3
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
3152 | Customer C | 101404 | 4mm Oriel Collection Brocade | 2 | 5.64 | 371.96 | 65.95 | 127.63 | 167.9342105263158 | 0 | 167.9342105263158 | 16.92
3152 | Customer C | 102614 | 4mm Oriel Texture Laurel stk | 4 | 11.28 | 764 | 67.73 | 357.69 | 470.6447368421053 | 0 | 470.6447368421053 | 33.84
3152 | Customer C | 500044 | Insulight(TM) | 222 | 129.66 | 2455.8 | 18.94 | 606.25 | 797.6973684210526 | 71.3 | 868.9973684210526 | 388.98
3152 | Customer C | 500045 | Insulight(TM) | 20 | 9.3 | 272.97 | 29.35 | 69.07 | 90.88157894736841 | 0 | 90.88157894736841 | 27.9
3152 | Customer C | 500144 | Insulight(TM) Protect | 70 | 30.87 | 869.45 | 28.16 | 145.2 | 191.0526315789473 | 47.36 | 238.4126315789474 | 92.61
3152 | Customer C | 500145 | Insulight(TM) Protect | 10 | 4.8 | 161.58 | 33.66 | 31.78 | 41.81578947368421 | 0 | 41.81578947368421 | 14.4
3152 | Customer C | 500146 | Insulight(TM) Sun | 1 | 1.14 | 42.12 | 36.95 | 6.83 | 8.986842105263158 | 0 | 8.986842105263158 | 3.42
3152 | Customer C | 500166 | Insulight(TM) Protect | 4 | 5.39 | 241.53 | 44.81 | 30.53 | 40.17105263157895 | 0 | 40.17105263157895 | 16.17
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 7 | 3.54 | 162.53 | 45.91 | 17.72 | 23.31578947368421 | 0 | 23.31578947368421 | 10.62
3152 | Customer C | 500265 | Insulight(TM) Protect | 37 | 20.27 | 863.15 | 42.58 | 28.52 | 37.52631578947368 | 22.07 | 59.59631578947369 | 60.81
3152 | Customer C | 500280 | Insulight(TM) Protect | 9 | 5.21 | 212.63 | 40.81 | 20.35 | 26.77631578947368 | 30.81 | 57.58631578947369 | 15.63
3152 | Customer C | 500290 | Insulight(TM) Protect | 3 | 1.81 | 109.33 | 60.4 | 14 | 18.42105263157895 | 0 | 18.42105263157895 | 5.43
3152 | Customer C | 512047 | energiKare(TM) | 1 | 0.51 | 23.65 | 46.37 | 5.78 | 7.605263157894737 | 0 | 7.605263157894737 | 1.53
3152 | Customer C | 512247 | energiKare(TM) | 1 | 0.61 | 28.21 | 46.25 | 3.05 | 4.013157894736842 | 0 | 4.013157894736842 | 1.83
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 1391.44 | 0 | 0 | 0 | 0 | 0 | 0
3278 | Customer G | 530047 | Insulight(TM) Therm | 4 | 1.2 | 75.76 | 63.13 | 1.93 | 2.539473684210526 | 0 | 2.539473684210526 | 3.6
3278 | Customer G | 99999999 | Energy Surcharge | 0 | 0 | 0.96 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 870048d1716557873-sumifs-criteria-not-working-v3-aligw
Sheet: WEEK3

 | DROP DOWN MENU ----> |  |  | 2024-05-01 00:00:00
 | 2024-05-20 00:00:00
 | SITE | Vacancies (P) | Interview Slots | Interviews Attended (s) | Attended  vs  Slots | Job Offers (z) | Offers  vs  Vacancies
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | District Office
 | [NAME]
 | Grand Total
Spreadsheet: 857003d1706110308-find-value-return-sheet-colum-and-row-name-searchexample_excelforum_v5
Sheet: F 1

F 1
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
A | FL-CGF | FL-MGF | FL-TGF | FL-UGF | UGF-FL 3´ | FL-OGF | FL-MCGF | FL-TCGF | Fl-UCGF | Fl-UAGF
B | FL-CAGF | FL-MAGF | FL-TAGF | FL-CXF | FL-MXF | FL-TXF | FL-UXF | FL-APGF | FL-APGF IDT | APGF-FL 3´
C | FL-4mCGF | FL-umCGF | FL-3mCGF | TGF | FL-74-3MGR | FL-74-3CGR | FL-3GMGAF | FL-3GUGAF | FL-MGF2525 | FL-MGF2020
D | FL-MGF1515 | FL-MGF1010 | FL-MGF0909 |  | FL-MGF0707 | FL-MGF0606 | FL-MGF0505 | Fl-MGF2010 | Fl-MGF1020 | Fl-TXF
E | Fl-0520 | TGF1 | Fl-OHU_CF | Fl-5OHMC_CGF | Fl-5FU_CGF | Fl-5BU_CGF | Fl-5BC_CGF | Fl-28 | Fl-29 | Fl-30
F | AL-MGF | AL-CGF | Al-28-OH | AL-28-P | AL-FWApF1 | FL-GGCCF | FL-GOCCF | FL-MGF61 | FL-TGF61
G | Fl-Atrich-F |  | Fl_ACT1_F5 | Fl-GHxCCFnoR | Fl_28G | Fl-6F6F | Fl-Mu6F6F | Fl-pGL3-F | Fl-UASF | Fl-6F6F2
H | Fl-HxGF | Fl-28G | Fl-GuCCFnoC | Fl28G-P | Fl-UGCG-F | Fl-CUCG-F | Fl-UCCG-F | Fl-UGF25 | Fl-CGF25 | GUCCnoC_Fl
I | Al-CGR STOCK | Fl-UGF STOCK | UGF-Fl 3' STOCK | Fl-OGF STOCK | Fl-UGF | UGF_Fl 3' |  |  |  | [NAME]
J | FL-CGR | FL-MGR | AL-CGR | AL-CGR-S | Bio-CGR | Bio-MGF | AL-FWApR1 | AL-GGCCR | AL-NoCG-R | [NAME]
Spreadsheet: 106724d1303927289-if-function-then-concatenate-book1-example
Sheet: Sheet1

Callsign |  | Frequency | Service |  |  |  |  |  |  |  | Callsign |  | Frequency | Service
KSFH |  | 87.9 | FM | Senario: |  |  |  |  |  |  | KSFH | KSFH-FM | 87.9 | FM
WJCF-FM |  | 87.9 | FM | Is there a formula that will do the following? |  |  |  |  |  |  | WJCF-FM | WJCF-FM | 87.9 | FM
WJCF-FM |  | 87.9 | FM |  |  |  |  |  |  |  | WJCF-FM | WJCF-FM | 87.9 | FM
K200AA |  | 87.9 | FX | If A2 is less than or equal to 4 characters in length, |  |  |  |  |  |  | K200AA | K200AA | 87.9 | FX
K201AO |  | 88.1 | FX | then, in column B grab value of A2 and value of D2 |  |  |  |  |  |  | K201AO | K201AO | 88.1 | FX
K201AM |  | 88.1 | FX | and concatenate together as per example in K2 |  |  |  |  |  |  | K201AM | K201AM | 88.1 | FX
K201BI |  | 88.1 | FX |  |  |  |  |  |  |  | K201BI | K201BI | 88.1 | FX
[NAME] |  | 88.1 | FX | Then if -FM as in A3 already exists, just copy |  |  |  |  |  |  | [NAME] | [NAME] | 88.1 | FX
K201AV |  | 88.1 | FX | A3 value over to B3 |  |  |  |  |  |  | K201AV | K201AV | 88.1 | FX
K201AL |  | 88.1 | FX |  |  |  |  |  |  |  | K201AL | K201AL | 88.1 | FX
K201CH |  | 88.1 | FX | The values that are 6 characters long leave as they are |  |  |  |  |  |  | K201CH | K201CH | 88.1 | FX
K201DA |  | 88.1 | FX | such as A5, just copy them over to column b |  |  |  |  |  |  | K201DA | K201DA | 88.1 | FX |  | Desired result
KCUK |  | 88.1 | FM |  |  |  |  |  |  |  | KCUK | KCUK-FM | 88.1 | FM
KRUA |  | 88.1 | FM |  |  |  |  |  |  |  | KRUA | KRUA-FM | 88.1 | FM
K201AG |  | 88.1 | FX |  |  |  |  |  |  |  | K201AG | K201AG | 88.1 | FX
KAQU-LP |  | 88.1 | FL |  |  |  |  |  |  |  | KAQU-LP | KAQU-LP | 88.1 | FL
[NAME] |  | 88.1 | FX |  |  |  |  |  |  |  | [NAME] | [NAME] | 88.1 | FX
K201CL |  | 88.1 | FX |  |  |  |  |  |  |  | K201CL | K201CL | 88.1 | FX
NEW |  | 88.1 | FM |  |  |  |  |  |  |  | NEW | NEW | 88.1 | FM
KCAI |  | 88.1 | FM |  |  |  |  |  |  |  | KCAI | KCAI-FM | 88.1 | FM
KHOH |  | 88.1 | FM | I am not interested in the color, this was to |  |  |  |  |  |  | KHOH | KHOH-FM | 88.1 | FM
WAYH |  | 88.1 | FM | highlight example output only. |  |  |  |  |  |  | WAYH | WAYH-FM | 88.1 | FM
Spreadsheet: 166048d1341438576-drop-down-menu-to-show-data-4-variables-by-weeks-drop-down-showing-data-oeldere-
Sheet: Data

 | Week | % | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | local damages |  | 14 | 12 | 5 | 11
 | mistakes |  | 5 | 3 | 1 | 9
 | lacks |  | 2 | 6 | 15 | 2
 | remote damages |  | 8 | 16 | 4 | 3
 | local damages | 2 |  | 0.8571428571428571 | 0.4166666666666667 | 2.2
 | mistakes | 2 |  | 0.6 | 0.3333333333333333 | 9
 | lacks | 2 |  | 3 | 2.5 | 0.1333333333333333
 | remote damages | 2 |  | 2 | 0.25 | 0.75 |  |  | % | 2
 |  |  |  |  |  |  |  |  |  | Waarden
 |  |  |  |  |  |  |  |  | Rijlabels | Som van 1 | Som van 2 | Som van 3 | Som van 4
 |  |  |  |  |  |  |  |  | lacks | 0 | 3 | 2.5 | 0.1333333333333333
 |  |  |  |  |  |  |  |  | local damages | 0 | 0.8571428571428571 | 0.4166666666666667 | 2.2
 |  |  |  |  |  |  |  |  | mistakes | 0 | 0.6 | 0.3333333333333333 | 9
 |  |  |  |  |  |  |  |  | remote damages | 0 | 2 | 0.25 | 0.75
 | No ZEROES in this spreadsheet |  |  | 14.28571428571429 | 58.33333333333334 | -120 |  |  | Eindtotaal | 0 | 6.457142857142857 | 3.5 | 12.08333333333333
 |  |  |  | 40 | 66.66666666666667 | -800
 |  |  |  | -200 | -150 | 86.66666666666667
 |  |  |  | -100 | 75 | 25