tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862106d1709874810-solved-extracting-data-from-a-matrix-testextractionofdata-bvj-
Sheet: Sheet1

Data Table
 |  | 1870 | 1871 | 1872 | 1873 | 1874 | 1875 | 1876 | 1877 | 1878 | 1879 | 1880 | 1881 | 1882
4 | 1 | 0 |  | 0 | 6 | 9 | 32 | 6.5 | 14 | 211 | 69.5 | 41.5 | 0 | 61
4 | 2 | 0 |  | 0 | 6 | 9 | 32 | 6.5 | 14 | 215 | 69.5 | 44.5 | 0 | 77
4 | 3 | 0 |  | 0 | 10 | 9 | 37 | 6.5 | 14 | 219 | 69.5 | 48 | 0 | 94.5
4 | 4 | 0 |  | 0 | 18.5 | 9 | 39.5 | 6.5 | 14 | 224.5 | 69.5 | 49.5 | 0 | 107
4 | 5 | 0 |  | 0 | 23.5 | 9 | 50 | 6.5 | 16 | 232 | 69.5 | 49.5 | 0 | 107
4 | 6 | 0 |  | 0 | 24.5 | 9 | 59.5 | 9.5 | 16 | 235.5 | 79.5 | 49.5 | 0 | 115.5
4 | 7 | 0 |  | 0 | 24.5 | 9 | 71 | 9.5 | 28 | 240.5 | 86 | 49.5 | 0 | 122.5
4 | 8 | 0 |  | 0 | 24.5 | 9 | 78 | 11.5 | 32.5 | 252.5 | 96.5 | 49.5 | 0 | 130
4 | 9 | 0 |  | 0 | 24.5 | 9 | 78 | 19.5 | 39 | 264.5 | 107.5 | 64.5 | 2 | 131.5
4 | 10 | 0 |  | 0 | 24.5 | 13.5 | 81 | 27.5 | 48 | 267 | 111 | 69.5 | 2 | 131.5
4 | 11 | 0 |  | 0 | 24.5 | 13.5 | 81 | 35.5 | 58.5 | 274.5 | 111.5 | 69.5 | 2 | 131.5
4 | 12 | 0 |  | 0 | 26.5 | 13.5 | 81 | 40.5 | 67.5 | 282 | 118 | 75.5 | 2 | 131.5
4 | 13 | 0 |  | 0 | 37 | 22.5 | 81 | 40.5 | 75 | 286 | 122 | 97.5 | 2 | 131.5
4 | 14 | 0 |  | 0 | 55.5 | 23.5 | 85.5 | 40.5 | 86.5 | 289 | 127 | 112.5 | 2 | 131.5
4 | 15 | 0 |  | 0 | 59 | 23.5 | 85.5 | 44 | 94 | 297 | 129.5 | 112.5 | 2 | 133
4 | 16 | 0 |  | 0 | 63 | 23.5 | 85.5 | 44 | 105 | 313.5 | 132 | 112.5 | 7.5 | 140
4 | 17 | 0 |  | 0 | 63.5 | 28 | 85.5 | 44 | 120 | 334 | 134 | 119 | 22 | 153.5
4 | 18 | 0 |  | 0 | 72.5 | 34 | 87.5 | 46.5 | 129 | 357.5 | 142 | 133.5 | 31.5 | 169.5
4 | 19 | 0 |  | 0 | 75.5 | 34 | 92 | 55.5 | 142.5 | 379 | 154.5 | 140 | 37.5 | 176.5
4 | 20 | 0 |  | 0 | 77.5 | 34 | 92 | 68 | 153 | 394.5 | 167 | 146 | 50 | 178
4 | 21 | 0 |  | 0 | 77.5 | 34 | 92 | 78.5 | 168.5 | 408.5 | 186 | 163.5 | 66 | 182
4 | 22 | 0 |  | 0 | 77.5 | 34 | 94.5 | 88.5 | 190 | 429.5 | 212 | 175 | 79.5 | 184.5
Results Table
 |  | 1882 | 1873 | 1875 | 1877 | 1879 | 1870
4 | 1
4 | 2
4 | 3
4 | 4
4 | 5
4 | 6
4 | 7
4 | 8
4 | 9
4 | 10
4 | 11
4 | 12
4 | 13
4 | 14
4 | 15
4 | 16
4 | 17
4 | 18
4 | 19
4 | 20
4 | 21
4 | 22
Spreadsheet: 703424d1604996275-vlookup-across-multiple-sheets-lookup
Sheet: GENERAL

CUSTOMER | PRODUCT |  | QUANTITY
1 | A |  | FORMULA ?
1 | B |  | FORMULA ?
1 | C |  | FORMULA ?
1 | D |  | FORMULA ?
1 | E |  | FORMULA ?
2 | A |  | FORMULA ?
2 | B |  | FORMULA ?
2 | C |  | FORMULA ?
2 | D |  | FORMULA ?
2 | E |  | FORMULA ?
Spreadsheet: 44b7860c-ff40-41f9-90f1-bb8b7a697a7f
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
IOD | Test | IOD | Iodine, Serum | Iodine, S | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1 | mL | Collection Container/Tube: Plain, royal blue-top [NAME] plastic trace element blood collection tube, catalog #368380 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 1 mL Collection Instructions:  1. Allow specimen to clot for 30 minutes; then centrifuge the specimen to separate serum from the cellular fraction. 2. Remove the stopper. Carefully pour specimen into a 7-mL Mayo metal-free, screw-capped, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | 40-92 ng/mL | Monday, Tuesday, Wednesday, Friday; 5 p.m. | 1 day | 3 days | 1 | 83018 |  |  |  |  | Rochester
IOD | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
IOD | Result | 81574 | Iodine, S | Iodine, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2494-3 | Iodine:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 710259d1608812761-need-a-change-in-if-formula-to-get-the-exact-result-in-house-production-tracking-with-completion-
Sheet: DATE TRACK

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-23 00:00:00
CHOOSE P.O. NO. | 4191 |  |  |  |  |  |  |  |  |  |  |  |  | DAILY PRODUCTION REPORT |  |  |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  | TO
 |  |  | TOTAL METER | ORG. ORDER | STOCK | FINAL ORDER | ORDER DATE | ORDER START DATE | PENDING ORDER | ORDER END DATE | EXTENDED DATE | EXTENDED DAYS | AVG PROD.
QUALITY | P.O. NO. | WIDTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER | ORDER DATE | LEAD TIME | TOTAL | DIFFERENCE | DAILY EXPECTED | END DATE | AVG PROD. | EXTENDED DATE | EXTENDED DAYS | TOTAL | ORDER START DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 193 | 135.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 106 |  | 494 | 391 | 510 | 183.5 | 166 | 94 | 190.5 |  |  | 41 |  | 154 | 144 | 486 |  | 233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100.5 | 140 |  | 208 | 63 | 166 | 99 | 97 | 9.5 |  |  |  | 48 | 98 | 134 | 148 | 297.5 |  | 127 | 16
Spreadsheet: 747660d1631633015-lookup-details-in-sheet-2-return-information-upgrades-pricingupdate_testing-tms
Sheet: Sheet1

Azure Region | Company | Application | Subscription | Resource Group Name | Service | Service Name | [NAME] | sku Family | skuCode/Name | sku [NAME] | Runtime Stack | OS | Current Est Monthly Cost | [NAME] | upgrade ProudctName | Type | Est Monthly Cost | Currency Code
SA North |  |  | Production |  | ASP-zanetrgemtp001-b3a9 |  | Standard |  | S1 |  | PHP 7.4 | Windows | $106,58 | I13
SA North |  |  | Production |  | Azure Database for MySQL Server |  | Basic | Gen5 | B_Gen5_1 | 5120 |  |  | $34,09
 |  |  |  |  |  |  |  |  |  |  |  |  |  | =SORT(FILTER(FILTER(Sheet2!A:T,Sheet2!A:A=O2,Sheet2!$T:$T="*"&M2&"*"),{1,1,1,1,0,0,0,0,0,0,0,1,1,0,0,0,0,1,0,1}),2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Azure App Service Isolated Plan | USD | 2076.12 | DZH318Z0BQJP | DZH318Z0BQJP/00HB | Consumption | I13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I13 | Azure App Service Isolated Plan | USD | 2076.12 | DZH318Z0BQJP | DZH318Z0BQJP/00HB | Consumption | I13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I13 | Azure App Service Isolated Plan - Linux | USD | 1979.76 | DZH318Z0BXW6 | DZH318Z0BXW6/00BM | Consumption | I13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I13 | Azure App Service Isolated Plan - Linux | USD | 1979.76 | DZH318Z0BXW6 | DZH318Z0BXW6/00BM | Consumption | I13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | =SORT(FILTER(FILTER(Sheet2!A:R,Sheet2!A:A=O2),{1,1,1,1,0,0,0,0,0,0,0,1,1,0,0,0,0,1}),2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Azure App Service Isolated Plan | USD | 2076.12 | DZH318Z0BQJP | DZH318Z0BQJP/00HB | Consumption
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I13 | Azure App Service Isolated Plan | USD | 2076.12 | DZH318Z0BQJP | DZH318Z0BQJP/00HB | Consumption
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I13 | Azure App Service Isolated Plan - Linux | USD | 1979.76 | DZH318Z0BXW6 | DZH318Z0BXW6/00BM | Consumption
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I13 | Azure App Service Isolated Plan - Linux | USD | 1979.76 | DZH318Z0BXW6 | DZH318Z0BXW6/00BM | Consumption
 |  |  |  |  |  |  |  |  |  |  |  |  |  | JeteMc:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SORT(FILTER(FILTER(Sheet2!A:T,Sheet2!A:A=O2,Sheet2!$T:$T="*"&M2&"*"),{0,1,1,1,0,0,0,0,0,0,0,1,1,0,0,0,0,1,0,0}),1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD | 2076.12 | DZH318Z0BQJP | DZH318Z0BQJP/00HB | Consumption
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Azure App Service Isolated Plan | USD | 2076.12 | DZH318Z0BQJP | DZH318Z0BQJP/00HB | Consumption
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Azure App Service Isolated Plan - Linux | USD | 1979.76 | DZH318Z0BXW6 | DZH318Z0BXW6/00BM | Consumption
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Azure App Service Isolated Plan - Linux | USD | 1979.76 | DZH318Z0BXW6 | DZH318Z0BXW6/00BM | Consumption
Spreadsheet: 870275d1716814033-suitable-formula-for-matching-the-work-counter-code-for-each-name-for-each-date-roster-trial
Sheet: By Counter

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
Seq | Counter Code | Counter | Time | Code | 2024-05-01 00:00:00
1 |  | GAP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Dennis | [NAME] |  | [NAME] | [NAME] | Dennis | Dennis | [NAME] | Dennis |  | Dennis | Dennis | Dennis
2 |  | GAP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dennis | Dennis | [NAME] | Dennis | Carol |  |  | Carol |  |  | [NAME] | [NAME] |  |  | Carol | Carol | Carol
3 |  | GAP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carol | Carol |  | Carol | [NAME]
4 |  | GAP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
8 |  | GAP | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carol | Carol | Carol | Carol
1 |  | CCP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emma | Emma | [NAME] | [NAME] | [NAME] | Dennis |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | Emma | Emma | Emma
2 |  | CCP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dennis |  |  |  |  |  |  |  |  | Dennis
3 |  | CCP | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  | Emma
1 |  | SMP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2 |  | SMP | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
3 |  | SMP | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME]
1 |  | PAP | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  | [NAME] | [NAME]
1 |  | OWHK | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
2 |  | OWHK | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  | Tsely | Tsely
3 |  | OWHK | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tsely |  |  |  |  |  | [NAME] | [NAME] | Tsely |  |  |  | [NAME]
4 |  | OWHK | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tsely |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tsely
Spreadsheet: 218142d1362368269-combining-two-if-functions-together-copy-of-test
Sheet: Sheet2

Tax | Receipt | Travel | GST | BC (PST) | ON (HST) | QB (PST) | Total
HST(BC) | Yes |  |  |  |  |  | 105
HST(ON) | No |  |  |  |  |  | 105
GST | No |  |  |  |  |  | 112
GST | No |  |  |  |  |  | 112
GST
GST
GST
GST
GST
GST
GST
 | Total
Spreadsheet: 827428d1682691975-expiry-date-excel-formula-expiry-date-formula-aligw
Sheet: Sheet1

 |  |  |  | Enter date |  |  |  | I am looking for
 |  |  | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date |  | Condition - When Inspected date(E6) is before & within 10 to 12 calender month from Exisiting expiry date (E3), the result of next inspection date (G4) will be 364 days from existing expiry date.
 |  |  |  |  |  |  | result
 |  |  |  | Enter date
 |  |  | inspected date | 2020-02-21 00:00:00 |  |  |  | If above condition is not satisfy then Next inspection date (G4)  will be count (364 days)  from inspected date (E6).
 |  | At different scenario
 |  |  |  |  |  |  |  | Inspected date is before & within 10 to 12 calender month from existing expiry date. Result of next inspection date will be 364 days from existing expiry date.
 |  | Scenario - 1 | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date
 |  |  |  |  |  |  | result
 |  |  | inspected date | 2020-02-21 00:00:00
 |  | Scenario - 2 | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date |  | Inspected date is after existing expiry date. Result of next inspection date will be 364 days from inspected date
 |  |  |  |  |  |  | result
 |  |  | inspected date | 2020-03-28 00:00:00
 |  | Scenario - 3 | Existing expiry date | 2020-03-25 00:00:00 |  | next inspection date |  | Inspected date is before but Not within 10 to 12 calender month from existing expiry date. Result of next inspection date will be 364 days from inspected date
 |  |  |  |  |  |  | result
 |  |  | inspected date | 2020-01-23 00:00:00
Spreadsheet: 849763d1700159012-data-from-1-column-to-extract-into-multiple-columns-get-data-from-1-column-into-multiple
Sheet: Sheet1

Data | Explanation of the structure of Column A |  | Desired Result
Some Random Text 1 |  |  | Header | Sub Header | [NAME]
Some Random Text 2 |  |  | 30010 | 30060000 | 30060001
30010 [NAME] | [NAME] |  | 30010 | 30060000 | 30060002
30060000 SubHeader Description | SubHeader Description Start (end with 0000) |  | 30010 | 30060000 | 30060003
30060001 - Description Detail 01 |  |  | 30010 | 30060000 | 30060004
30060002 - Description Detail 02 |  |  | 30010 | 30060000 | 30060005
30060003 - Description Detail 03 |  |  | 30010 | 31060000 | 31060001
30060004 - Description Detail 04 |  |  | 30010 | 31060000 | 31060002
30060005 - Description Detail 05 |  |  | 30010 | 31060000 | 31060003
31060000 SubHeader Description | SubHeader Description Start (end with 0000) |  | 90010 | 59990000 | 59990001
31060001 - Description Detail 01 |  |  | 90010 | 59990000 | 59990002
31060002 - Description Detail 02
31060003 - Description Detail 03
30010 [NAME] | [NAME]
90010 [NAME] | [NAME]
59990000 SubHeader Description | SubHeader Description Start (end with 0000)
59990001 - Description Detail 01
59990002 - Description Detail 02
90010 [NAME] | [NAME]
Some Random Text 1
Some Random Text 2
Some Long Random Text
Spreadsheet: 91858d1291561194-vlookup-error-test-database
Sheet: Quote Template

 |  | Date | 2010-12-05 22:55:40 |  |  | Cost Summary |  |  | New Quotation
 |  |  |  |  |  | Labour | 0 |  | Quotation Charge Out Rate |  | 90
 |  | Quotation No |  |  |  | Materials | 0 |  | Actual Hourly Cost Rate |  | 75
 |  |  |  |  |  | Labour Hours | 0 |  | Base Hourly Rate |  | 35
 |  |  |  |  |  |  |  |  | Profit |  | 0
 |  |  |  |  |  |  |  |  | Total of Quotation |  | 0
 |  | Job Name | [NAME] |  |  |  |  |  | Old Quotation
 |  | Job Address | #N/A |  |  |  |  |  | [NAME] |  | 0.2
 |  | Suburb |  |  |  |  |  |  | Material Total |  | 0
 |  |  |  |  |  |  |  |  | Labour Total |  | 0
 |  | Phone No |  |  |  |  |  |  | Profit |  | 0
 |  | Fax No |  |  |  |  |  |  | Sub Cost |  | 0
 |  | [NAME] |  |  |  |  |  |  | Superannuation |  | 0
 |  |  |  |  |  |  |  |  | Workers Compensation |  | 0
 |  |  |  |  |  |  |  |  | Payroll Tax |  | 0
 |  |  |  |  |  |  |  |  | PLSL |  | 0
 |  |  |  |  |  |  |  |  | Quotation Total |  | 0
Add | BOQ No: | Category | Product | Oty | Unit | Price | Material Total | Labour | Labour Total | Line Total | Est Hours
 |  |  | Total |  |  |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 883473d1732094715-use-the-other-formula-instead-of-vlookup-formula-file-a-vehile-ecel-help-forum-4
Sheet: form

 |  |  | ABC INTERNATIONAL COMPANY
 |  |  | OPERATIONAL VEHICLE DUTY SLIP No: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =VLOOKUP($B4,$B$84:$AK$165,COLUMN(E1),0) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =VLOOKUP($L$5,data!$A$4:$P$17,4,FALSE)
Name |  |  |  |  |  |  |  | Employe No. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =INDIRECT("'"&D6&"'!h21")
Designation |  |  |  |  |  |  |  | Type of Vehicle Required: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | '  =INDIRECT(sheet_name&"!A1") |  |  | =VLOOKUP(Sheet1!#REF!,Sheet1!F4:F24,1,)
Date: |  |  | 2024-11-12 00:00:00 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(Sheet1!#REF!=F4,Sheet1!F4,Sheet1!E4)
Place / Address where vehicle required: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF($L$5=data!A2,data!D2,data!D3)
Purpose:-
Place be visited: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =VLOOKUP($B$9,data!$A$1:$F$11,2,FALSE)
Applied By                                  Recommended By                        Approved By
Vehicle No. |  |  |  |  |  |  |  |  | Make |  |  |  | Power(CC)
[NAME] at the start of duty:-- |  |  |  |  |  |  |  |  |  |  |  |  | at the end of duty
Total running of this visit:-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I used here [NAME] formula, I want to use another formula for dynmic range and spell all the values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from sheet2(data)…
Signature of Driver |  |  |  |  |  |  |  |  |  |  |  |  | Signature of [NAME]
Spreadsheet: 112499d1308618496-excel-2007-using-multiple-if-statements-with-blanks-problem1
Sheet: Sheet1

Original Prices
 | T1 | T2 | T3 | T4
Item 1 | 5 | 6 | 9 | 10
Item 2 | 5 | 6 | NA | 7
Item 3 | 8 | NA | NA | 11
Item 4 | 3 | 4 | 4 | NA
New Prices
 | T1 | T2 | T3 | T4 | Desirable Result
Item 1 | 5 | 6 | 9 | 10 | 11.11111111111111
Item 2 | 5 | 6 |  | 7 | #[NAME]! | I want 16.67 here
Item 3 | 8 |  |  | 11 | #[NAME]! | I want 37.5 here
Item 4 | 3 | 4 | 4 |  | #[NAME]! | I want blank here
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T9

الجدول 9: السكان في الأردن بحسب [NAME] تعداد 2004
Table 9: Population of Jordan by age groups, 2004 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total | المجموع | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 314778 | 299417 | 18438 | 17698 | 257669 | 246198 | 75547 | 70917 | 333216 | 317115 | 650331
5-9 | 313300 | 298550 | 15833 | 15188 | 253774 | 241809 | 75359 | 71929 | 329133 | 313738 | 642871
10-14 | 298669 | 283693 | 14414 | 13353 | 240723 | 228598 | 72360 | 68448 | 313083 | 297046 | 610129
15-19 | 270699 | 257522 | 16994 | 14623 | 221213 | 210062 | 66480 | 62083 | 287693 | 272145 | 559838
20-24 | 248508 | 232933 | 31092 | 27660 | 217092 | 204308 | 62508 | 56285 | 279600 | 260593 | 540193
25-29 | 202463 | 193959 | 37311 | 22528 | 186570 | 169380 | 53204 | 47107 | 239774 | 216487 | 456261
30-34 | 174537 | 175223 | 32641 | 16768 | 164238 | 151997 | 42940 | 39994 | 207178 | 191991 | 399169
35-39 | 145100 | 145613 | 22637 | 10076 | 134829 | 124907 | 32908 | 30782 | 167737 | 155689 | 323426
40-44 | 108609 | 111054 | 15336 | 6401 | 101442 | 95481 | 22503 | 21974 | 123945 | 117455 | 241400
45-49 | 78163 | 79165 | 8935 | 4193 | 70890 | 67482 | 16208 | 15876 | 87098 | 83358 | 170456
50-54 | 58488 | 60234 | 6119 | 3399 | 51210 | 50969 | 13397 | 12664 | 64607 | 63633 | 128240
55-59 | 51589 | 55163 | 4176 | 2793 | 45618 | 47275 | 10147 | 10681 | 55765 | 57956 | 113721
60-64 | 49252 | 44722 | 2832 | 1981 | 42634 | 37635 | 9450 | 9068 | 52084 | 46703 | 98787
65-69 | 35497 | 33430 | 1598 | 1298 | 29956 | 27528 | 7139 | 7200 | 37095 | 34728 | 71823
70-74 | 22574 | 22447 | 893 | 906 | 18503 | 18455 | 4964 | 4898 | 23467 | 23353 | 46820
75+ | 22059 | 22631 | 729 | 909 | 17292 | 18244 | 5496 | 5296 | 22788 | 23540 | 46328
غير محدد    Not stated | 662 | 663 | 1362 | 1159 | 1778 | 1624 | 246 | 198 | 2024 | 1822 | 3846
المجموع    Total | 2394947 | 2316419 | 231340 | 160933 | 2055431 | 1941952 | 570856 | 535400 | 2626287 | 2477352 | 5103639
Spreadsheet: 788467d1658492711-a-function-to-count-time-within-a-range-of-times-hours-time-test-file
Sheet: Unavailability

Resource | Unavailability option | Unavailability Sub Option | Start Time | End Time | Month | Day | Time
DAVE SMITH | Holiday | Bank Holiday | 2022-01-01 09:00:00 | 2022-01-01 17:30:00
[NAME] | Training |  | 2022-01-04 09:00:00 | 2022-01-04 12:30:00
[NAME] | ACS renewal |  | 2022-01-05 09:00:00 | 2022-01-08 00:00:00
[NAME] |  | CarS | 2022-01-03 08:00:00 | 2022-01-03 13:00:00
GRAHAM BROWN | Holiday | Bank Holiday | 2022-01-03 08:00:00 | 2022-01-03 18:00:00
[NAME] | Holiday | Bank Holiday | 2022-01-03 08:30:00 | 2022-01-03 17:30:00
[NAME] | Annual Leave | Bank Holiday | 2022-01-03 09:00:00 | 2022-01-03 17:00:00
[NAME] | LMS/Desktop |  | 2022-01-05 09:00:00 | 2022-01-05 17:25:00
TREVOR SMITH | Holiday | Bank Holiday | 2022-01-03 09:00:00 | 2022-01-03 17:30:00
SARAH ADAMS | Holiday | Bank Holiday | 2022-01-03 09:00:00 | 2022-01-03 17:30:00
PHILIP MORRIS | Holiday | Bank Holiday | 2022-01-03 09:00:00 | 2022-01-03 17:30:00
ALEC GUINESS | Complaint Report/Followup |  | 2022-01-04 09:00:00 | 2022-01-04 18:30:00
[NAME] |  | Complaint Report/Followup | 2022-01-03 09:00:00 | 2022-01-03 17:30:00
SANDY BEACHES | Holiday |  | 2022-01-06 09:00:00 | 2022-01-06 22:00:00
PAT MCGURN |  | Excessive Travel | 2022-01-03 09:00:00 | 2022-01-03 10:30:00
[NAME] | Holiday | Bank Holiday | 2022-01-03 09:00:00 | 2022-01-03 17:30:00
TANYA HIDE | Excessive Travel |  | 2022-01-03 14:00:00 | 2022-01-03 15:30:00
[NAME] | Holiday | Bank Holiday | 2022-01-03 09:00:00 | 2022-01-03 17:30:00
BJORN BORG | Holiday | Bank Holiday | 2022-01-03 09:00:00 | 2022-01-03 17:30:00