tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 789475d1659109924-conditional-occurrences-count-test-ronyn-
Sheet: Sheet1

long_code | product_name | bonus_group | company_name | document_date | document_number | incoming/outgoing | document_type | quantity | test | Test2 | Helper | [NAME] and associated count | Running Count | Start Date: | 2021-12-19 00:00:00 |  | Exclude Companies
0634.349.853:000 | O-RING | T11 | A | 2022-06-16 00:00:00 | [PHONE] | Outgoing | credit | 1 |  |  | 1 | Credit -1 | -1
0634.349.853:000 | O-RING | T11 | B | 2022-05-26 00:00:00 | [PHONE] | Outgoing | invoice | -2 |  |  | 1 | Invoice +1 | 0
0634.349.853:000 | O-RING | T11 | A | 2022-05-26 00:00:00 | [PHONE] | Outgoing | credit | 1 |  |  | 1 | Credit -1 | -1
0634.349.853:000 | O-RING | T11 | A | 2022-05-11 00:00:00 | [PHONE] | Outgoing | invoice | -1 |  |  | 1 | Invoice +1 | 0
0634.349.853:000 | O-RING | T11 | A | 2022-05-11 00:00:00 | [PHONE] | Outgoing | invoice | -1 |  |  | 2 | Invoice duplicate (not counted) | 0
0634.349.853:000 | O-RING | T11 | A | 2021-10-06 00:00:00 | [PHONE] | Outgoing | invoice | -1 |  |  | 1 | Invoice pre 12/19/21 (not counted) | 0
0634.349.853:000 | O-RING | T11 | C | 2021-06-25 00:00:00 | [PHONE] | Outgoing | invoice | -10 |  |  | 1 | Invoice pre 12/19/21 (not counted) | 0
Spreadsheet: 266469d1379620825-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-county-fips-codes
Sheet: IDAHO-11

 | COUNTY | CODE
 | [NAME] | 1
 | Adams | 3
 | Bannock | 5
 | Bear Lake | 7
 | Benewah | 9
 | Bingham | 11
 | Blaine | 13
 | Boise | 15
 | [NAME] | 17
 | [NAME] | 19
 | Boundary | 21
 | [NAME] | 23
 | [NAME] | 25
 | Canyon | 27
 | [NAME] | 29
 | Cassia | 31
 | [NAME] | 33
 | Clearwater | 35
 | Custer | 37
 | Elmore | 39
 | Franklin | 41
 | Fremont | 43
 | Gem | 45
 | Gooding | 47
 | Idaho | 49
 | [NAME] | 51
 | [NAME] | 53
 | Kootenai | 55
 | Latah | 57
 | Lemhi | 59
 | Lewis | 61
 | Lincoln | 63
 | [NAME] | 65
 | Minidoka | 67
 | Nez Perce | 69
 | Oneida | 71
 | Owyhee | 73
 | Payette | 75
 | Power | 77
 | Shoshone | 79
 | Teton | 81
 | [NAME] | 83
 | Valley | 85
 | Washington | 87
Spreadsheet: 273647d1382815270-i-need-analysis-formula-resultanalysis
Sheet: Sheet1

GENDER | NAME | GRADE
F | ASHA | A
F | AMINA | C
F | [NAME] | C
F | FATMA | F
F | DIANA | D
F | REHEMA | D
F | NEEMA | B
F | TINA | D
M | ALLY | D
M | [NAME] | F
M | [NAME] | B
M | SELE | B
M | SAID | C
M | HASSAN | C
M | HUSSEN | F
M | BARAKA | C
M | MUSA | C
M | SUDI | D
M | MARCO | D
Spreadsheet: 811986d1672906546-sum-if-if-multiple-rows-book1
Sheet: Sheet1

ID | name | a | b | c | d | e | total | 1 | 2 |  | expected result
abc | abcde | 27 | 0 | 3 | 3 | 9 | 33 |  |  |  | PASS
abc | abcde | 27 | 0 | 3 | 3 | 3 | 33 |  |  |  | PASS
hellan | [NAME] dew | 1 | 0 | 0 | 0 | 0 | 1 |  |  |  | False
Spreadsheet: benjamin_rogers__1098__ENA Peaker Plant Summaries
Sheet: Gleason

 | PLANT LOCATION: |  | Gleason, TN
 | Pipeline: |  | [NAME]
 | Delivery Point: |  | ANR ML-2
 | MW Output: |  | 454 MW
 | Heat Rate: |  | 11500
 | 16 Hour Gas Flow: |  | 82,800 MMBtu/day
 | Facility Costs: |  | $1,100,000  Estimated (ENA Pays)
 | Start Date: |  | April, 1999 (Test gas March, 2000)
 | Transportation Arrangement:
 | [NAME] CONTRACT
 |  | Service: | ITS-3/IPLS
 |  | Term: | 10 years (Apr - Oct)
 |  | Volume: | 93,000 [NAME]/d
 |  | Rate (*) | $.1122 plus fuel from Chicago or SE LA
 |  |  | $.0322 plus fuel from Gleason Plant-gate to Brownsville Hub
 |  |  | $.0222 plus fuel from Brownsville Hub to Gleason Plant-gate
 |  | Fuel: | 0.0% on Backhaul; 2.69% on forward haul
 |  | Receipt Points: | SE Area, LA/Joliet, IL, [NAME], [NAME]
 |  | Balancing: | $.02 per MMBtu/d balancing up to 93,000 MMBtu years 1 to 10
 |  | (*)  Price reopener if plant connected to another pipeline.
 | BACK-UP CONTRACT
 |  | None in place; however, capacity release or seasonal firm can be utilized.
 | BALANCING:
 |  | IPLS service subject to economic dispatching and pipeline operational conditions
 |  | Balancing in-kind
 |  | Allows for uneven hourly flow at plant delivery point with even 24 hour supply flow
 | OTHER
 |  | ANR will maintain lateral and meter for $6,000 year.
 |  | ANR will construct interconnect and own hot tap & EMS.
 |  | Reasonable effort to provide 560 pressure. If pressure below 560 on day Genco
 |  | nominates gas using IT agmnt, ANR will waive IPLS for volumes parked.
Spreadsheet: 0f8382dd-5e8c-4362-ba6e-27693693fdd6
Sheet: Stability

Tune Step | Mass | Name | R | a | b (blank) | DL | BEC
1 | 44 | Ca | 0.999981118717671 | 0.0007012190786150714 | 0.0009747921979651611 | 0.1592759443452311 | 1.390139298392173
1 | 55 | Mn | 0.9999995503598277 | 0.1193716330913353 | 0.003186237954266338 | 0.005190888035684604 | 0.02669175139648495
1 | 56 | Fe | 0.9999985635509568 | 0.1814161407978488 | 0.1535923310799172 | 0.07934253779479095 | 0.8466299106817866
1 | 57 | Fe | 0.9999978016678593 | 0.004417437687879132 | 0.003173608470492117 | 0.1136948269260145 | 0.7184274447605863
1 | 59 | Co | 0.9999997157193699 | 0.33820064301851 | 0.006615689783139177 | 0.005112462856854319 | 0.01956143466816855
1 | 63 | Cu | 0.9999988719998366 | 0.2485537259192025 | 0.009934044622957426 | 0.01449984945602987 | 0.03996739371425351
1 | 64 | Zn | 0.9999839169576368 | 0.07336512351909784 | 0.006039897450178387 | 0.02922445523818949 | 0.08232654918935874
1 | 66 | Zn | 0.9999909532582021 | 0.04352651167243085 | 0.003681591751447583 | 0.02901417523912605 | 0.08458274302232809
Spreadsheet: 57545d1257768448-or-function-example
Sheet: Sheet3

SALES | SALES# | FINANCE | FINANCE# | MANAGER | MANAGER# | DEALTYPE | DEALTYPE# | SALETYPE |  |  | DOCFEE | USEDPACK | NEWPACK | SPFI | SPFI FI
BROWN,STERLING U | 9025 | DEALER TRADE | 98 | DISANTO,TJ | 9962 | RETAIL | 1   1 | RETAIL |  |  | 250 | 200 | 50 | 9997 | 1975
CARTER,CLARENCE M | 6514 | LAYTON,MICHELLE | 8585 | GRUNWALD,TERRANCE | 8801 | WHOLESALE | 2   3 | HOUSE
CLARK,DANIEL | 5792 | SPFI | 1975 | HOUSE | 9998 | FLEET |  | WHOLE
CONLEY,[NAME] | 1084 | [NAME],CODY | 5339 | SPFI | 9997 | DEALER TRADE | 2   7 | FLEET
COUNSELMAN,KENNETH | 2911 |  |  |  |  |  |  | COMMERCIAL
DEFABBO,SCOTT | 9773 |  |  |  |  |  |  | DEALER TRADE
DHAHER,[NAME] | 6126
EDWARDS,[NAME] | 7156
FRIEDMAN,BRUCE | 9562
GURKO,MATTHEW S | 9242
HENDERSON,JEROME | 4885
HOUSE | 9999
INTERNET SALESPERSON | 555
IVERY,WILLIAM | 37
JURSEK,THOMAS | 9595
LAUHON,NORVEL S | 6928
LAVENDER,JEROME | 9304
LEWIS,REGINALD | 9386
MCKOY,[NAME] | 3781
REBANT,[NAME] | 1115
REED,[NAME] | 6944
RODGERS,VIOLA | 6282
STIGGERS II,HARRY L | 8134
SUSTER,[NAME] | 7513
WALK,ROBERT | 3070
Spreadsheet: 674539d1587903273-conditional-formatting-based-on-cell-values-condformtest
Sheet: Sheet1

Approved Overdraft | 2000 | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period
 |  | 2019-12-30 00:00:00
 |  | 1
 |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual
 | OPENING CASH BALANCE | 500 | 500 |  | -8575 | 500 |  | 2000 |  |  | -1000
So, in the above example I wold like the cells to be coloured as follows:
F5 - because the value is >B1 it should be Red
I5 - because the value is >0 it should be normal
L5 - because the value is between -0.01 and -(B1) is should be Amber
The formula looks at the value in each cell on row5 ans applies the corret colour based on the value in that cell
Spreadsheet: 1482dd40-c719-476e-99da-bdff71e62242
Sheet: RESP

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.S. Degree Respiratory Care | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
 | RESP 050 | 1 | X | 1 | X | 1 | 4 | 1 | 4 | 1
1 | RESP 051X4 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 109AX2 | 1 | X | 1 | X | 1 | 2 | 1 | 1
 | RESP 109BX2 | 1 | X | 1 | X | 1 | 2 | 1 | 1 | 1
 | RESP 130 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 131 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 132 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 133 | 1 | X | 1 | X | 1 | 3 | 1 | 3 | 1
1 | RESP 134 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 135 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 136 | 1 | X | 1 | X | 1 | 3 | 1 | 3 | 1
1 | RESP 137 | 1 | X | 1 | X | 1 | 3 | 1 | 3 | 1
1 | RESP 138X4 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 139 | 1 | X | 1 | X | 1 | 3 | 1 | 3 | 1
1 | RESP 206 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 209AX2 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 209BX2 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 218 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 230 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 231 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 232 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 233 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 234 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 235 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 236 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 237 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | RESP 238X4 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | RESP 925X4 | 1
5 | RESP 927X4 | 1
5 | TOTAL
 | PERCENTAGE
Spreadsheet: 70dea5db-637f-44ee-802b-efb51f78551d
Sheet: Sheet1

Unnamed: 0 | High Cost Loans in Portland1 | Unnamed: 2 | Unnamed: 3
 | All Loans Originated | High Cost Loans Originated | High Cost Loans Percentage
2004 | 10121 | 633 | 0.06254322695385832
2005 | 12003 | 2524 | 0.2102807631425477
2006 | 10410 | 1634 | 0.1569644572526417
2007 | 9553 | 704 | 0.0736941274992149
2008 | 5573 | 186 | 0.03337520186614032
2009 | 3569 | 62 | 0.01737181283272625
2010 | 3474 | 21 | 0.006044905008635579
1 This accounts for loans originated within the Portland city limits. These are loans originated that were conventional loans, secured by a first lien, for one to four family dwellings, for home purchase and owner occupancy. High cost loans are loans with a rate spread higher than 3%.
Spreadsheet: 763106d1641996293-wanting-to-highlight-out-of-specification-cells-in-excel-based-different-specifications-demo-sheet-2022
Sheet: Specifications

 |  |  | Min | [NAME] | Min | [NAME] | Min | [NAME] | Min | [NAME] | Min | [NAME] | No Specification |  |  |  |  |  | Min | [NAME]
All others |  |  | 600 | 800 | 60 | 500 | 35 | 200 | 0 | 14 | 0 | 10 | - | - | - | - | - | - | 0 | 4
Tesla |  |  | 550 | 850 | 80 | 500 | 35 | 200 | 0 | 12 | 0 | 6 | - | - | - | - | - | - | 0 | 2
Renault |  |  | 700 | 900 | 60 | 500 | 0 | 200 | 0 | 14 | 0 | 8 | - | - | - | - | - | - | 0 | 1
Euroshopper |  |  | 600 | 745 | 60 | 500 | 30 | 200 | 0 | 14 | 0 | 11 | - | - | - | - | - | - | 0 | 1
Volvo |  |  | 500 | 800 | 60 | 500 | 0 | 200 | 0 | 14 | 0 | 10 | - | - | - | - | - | - | 0 | 1
Ford |  |  | 600 | 740 | 60 | 500 | 25 | 200 | 0 | 14 | 0 | 11 | - | - | - | - | - | - | 0 | 1
Date | Time | Customer | Density |  | Absorption (W) |  | Absorption (O) |  | Moisture |  | <0,5 |  | 0.5 - 1.0 | 1.00-2.00 | 2.0 - 2.8 | 2.8 - 4.0 | 4.0 - 5.6 | 5.6 - 6.7 | 6.7 - 10
Spreadsheet: 172211d1344026706-adding-reminders-tigeravatar-example-for-psilver1
Sheet: Bag 9

Item | Expiration Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bag 9
Item 01 | 2012-08-05 00:00:00
Item 02 | 2012-08-05 00:00:00
Item 03 | 2012-08-14 00:00:00
Item 04 | 2012-08-17 00:00:00
Item 05 | 2012-08-10 00:00:00
Item 06 | 2012-08-06 00:00:00
Item 07 | 2012-08-17 00:00:00
Item 08 | 2012-08-12 00:00:00
Item 09 | 2012-08-08 00:00:00
Item 10 | 2012-08-04 00:00:00
Item 11 | 2012-08-07 00:00:00
Item 12 | 2012-08-16 00:00:00
Item 13 | 2012-08-05 00:00:00
Item 14 | 2012-08-09 00:00:00
Item 15 | 2012-08-14 00:00:00
Item 16 | 2012-08-10 00:00:00
Item 17 | 2012-08-10 00:00:00
Item 18 | 2012-08-04 00:00:00
Item 19 | 2012-08-05 00:00:00
Item 20 | 2012-08-04 00:00:00
Spreadsheet: 695797d1600408015-vlookup-match-and-offset-test
Sheet: Sheet1

2020-09-08 00:00:00 |  |  |  | 2020-09-09 00:00:00 |  |  |  | 2020-09-10 00:00:00
[NAME] | 8 |  |  | Toby | 8 |  |  | [NAME] | 8
[NAME] | 8 |  |  | [NAME] | 8 |  |  | [NAME] | 8 |  |  |  | The data to the left imports from an external source on a rolling 1yr basis. For example purposes I've included only a few days. The person working & hours are only input if they work on the date in question, with the hours worked in the next column.
[NAME] | 7.5 |  |  | [NAME] | 8 |  |  | Les | 8
[NAME] | 7.5 |  |  | Mick | 8 |  |  | [NAME] | 8
Toby | 8 |  |  | [NAME] | 8 |  |  | Del | 8
[NAME] | 8 |  |  | [NAME] | 8 |  |  | [NAME] | 8
Del | 8 |  |  | Fred | 8 |  |  | [NAME] | 8
[NAME] | 8 |  |  | [NAME] | 8 |  |  | [NAME] | 8
Denzel | 7.5 |  |  | Del | 8 |  |  | [NAME] | 8
 |  |  |  | [NAME] | 8 |  |  | Fred | 8
 |  |  |  |  |  | 2020-09-08 00:00:00 | 2020-09-09 00:00:00 | 2020-09-10 00:00:00
 |  |  |  |  | [NAME] |  |  |  |  | <--- | Would like to be able to pull the number of hours worked for each person on the date specified(blue cells). If no hours are found then return a value of "0". This is only a very small extract of the workbook, the workbook being used covers a years worth of data on a rolling basis, which makes it harder to just lookup certain columns. To comply with GDPR the names in this document aren't those of my employees
 |  |  |  |  | [NAME]
Spreadsheet: 769176d1645369378-extract-specific-characters-from-a-cell-based-on-criteria-workbookexample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Event | Start
 |  |  | Event | Expected Answer | Automatic Answer |  |  |  |  |  |  |  |  | FP1 | 2022-02-01 00:00:00
 |  |  | FP5 - Bananas & Apples;FP3 - Bananas & Apples;FP4 - Bananas & Apples | FP5 |  | <-- Please insert automatic formula here |  |  |  |  |  |  |  | FP2
 |  |  | FP5 - Bananas & Apples;FP6 - Bananas & Apples | FP6 |  |  |  |  |  |  |  |  |  | FP3
 |  |  | FP6 - Orange & Pear;FP5 - Orange & Pear | FP6 |  |  |  |  |  |  |  |  |  | FP4
 |  |  | FP10 - [NAME] | FP11 |  |  |  |  |  |  |  |  |  | FP5
 |  |  | VS3- Bananas & Apples;VS2 - Bananas & Apples;VS4 - Bananas & Apples | VS4 |  |  |  |  |  |  |  |  |  | FP6
 |  |  | FP8 - Orange & Pear | FP8 |  |  |  |  |  |  |  |  |  | FP7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS15
Spreadsheet: 854237d1704194926-adding-cumulative-purchases-and-removing-sales-sales
Sheet: Sheet1

Type |  | Units | €/unit | Prev.Units | Cum. Units | Profit
Buy | Product A | 10 | 5 | 0 | 10
Buy | Product A | 10 | 5 | 10 | 20
Buy | Product B | 30 | 10 | 0 | 30
Sell | Product A | 10 | 8 | 20 | 10 | 30
Buy | Product B | 30 | 10 | 30 | 60
Sell | Product A | 10 | 8 | 10 | 0 | 30
Sell | Product B | 20 | 15 | 60 | 40 | 100
Buy | Product A | 30 | 5 | 0 | 30
Sell | Product B | 40 | 15 | 40 | 0 | 200
Spreadsheet: 106265d1303424486-how-to-lock-the-1st-drop-down-list-quote-form
Sheet: Sheet1

 |  | Date:
 |  |  |  |  |  | QUOTATION REQUEST
 |  | Prepared For:
 |  | Shipment Description: |  |  |  |  |  |  | Consignee | Address and Details:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transportation | Ground | Dom.Air | Intl.Air | Ocean | Other
 |  | Reference # : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground | Small Pack | NDA Early Am | NDA | LCL | See Notes
 |  |  |  |  |  |  | Door to Door |  |  |  |  |  |  |  |  |  |  | Dom.AIR | LTL | NDA | Priority | FCL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intl.AIR | FTL | 2nd Day | Economy
 |  | Commodity: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ocean | Other | Economy
 |  | Est. Commercial Value: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  | Total # Of Pieces: |  |  |  |  |  |  | Freight Charge: |  | USD
 |  | Actual Weight:
 |  | Dimensional Weight:
 |  | Transportation Type: |  |  |  | Dom.AIR | Small Pack |  | Origin Accessorials:
 |  | Origin: |  |  |  | 89502 |  |  |  |  | USD
 |  | Destination: |  |  |  |  |  |  |  |  | USD
 |  | Shipment Insured ? |  |  |  |  |  |  |  |  | USD
 |  | IncoTerms: |  |  |  | CIF |  |  |  |  | USD
 |  | C/D/T Clearance: |  |  |  | Consignee |  |  | Destination Accessorials:
 |  |  |  |  |  |  |  |  |  |  | USD
 |  | Freight Terms: |  |  |  | Pre-paid |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  | USD
 |  | Shipment Details (In Inches, Total Pounds, Total USD): |  |  |  |  |  |  |  |  | USD
 |  | Pieces | L | W | H | Actual Weight | Ins/Dec Value Total |  | Insurance/Declared Value:
 |  |  |  |  |  |  |  |  | Insurance |  | USD
 |  |  |  |  |  |  |  |  |  | Coverage Amount
 |  |  |  |  |  |  |  |  | Transit Time: |  | Days
 |  | Notes: |  |  |  |  |  |  | Total Price Quoted: |  | USD
 |  |  |  |  |  |  |  |  | **Quote Does Not Include C/D/T Clearance
 |  | Est. Date Freight Will be Ready for PU:
Spreadsheet: 95295d1294918600-auto-numbers-to-invoices-ls809-01-ist_1
Sheet: Sheet1

Company logo
 |  |  |  |  |  |  |  | SALES INVOICE |  |  |  |  | SALES TAX INVOICE
 |  |  |  |  |  |  |  |  |  |  |  |  | SALES INVOICE
 |  |  |  | Number |  |  |  |  | Date |  |  |  | [NAME]
Innovative Invoice: |  |  |  | LS | 080905 |  |  |  | 2008-09-23 00:00:00
Client Purchase Order: |  |  |  | LOP/IST Div/0708/226 |  |  |  |  | 2008-07-15 00:00:00
Innovative Delivery Chalan: |  |  |  | 28137 |  |  |  |  | 2008-09-23 00:00:00
 |  |  | Supplier |  | Buyer
Address
Tel:
ST Registration No:
NTN No:
DO NOT DEDUCT TAX AT SOURCE FROM THIS INVOICE |  |  |  |  |  |  | Value - Rs.
This Invoice is in respect  of goods  imported by us on which we have paid tax under  section 148,  these goods fall under the provisions of sub section 5 of section 153 of  Income Tax Ordinance 2001 under this section no tax deductions are applicable at the time of Payment. |  |  |  |  |  |  | Sales Tax Exclusive
 |  |  |  |  |  |  |  |  | Sales Tax Payable | Total Incl. Sales Tax
Sr. # | Qty | Descrption of Goods |  |  | Sales  Tax % |  | Unit | Total
1 | 2 | Article # 512 |  |  | 16 |  | 44136.20689655172 | 88272.41379310345 | 14123.58620689655 | 102396
 |  |  |  |  |  |  |  |  | Total: | 102396
Sales Tax Rs. |  |  | 14123.58620689655 |  |  |  |  |  | Paid: | 0
 |  |  |  |  |  |  |  |  | Balance: | 102396
IC Representative |  |  |  | Goods Issued by |  |  |  |  | Goods Received by
Spreadsheet: 745234d1629816738-need-formula-to-lookup-data-from-same-worksheet-and-match-to-criteria-sample
Sheet: Data 1

Sr | Particular | Result / or furmula required
1 | l love Apple Grapes Very Much
2 | l love Mango Blueberries Apricots
3 | l Like [NAME]
4 | l love Apple & Blackcurrant too
5 | l love Apricots & Mango
6 | l love [NAME] or Blackberries
Spreadsheet: 757665d1638385162-how-to-reference-formula-from-another-sheet-template-with-sheet-scope-named-ranges
Sheet: copy 2

 |  |  | Sunday | 100 | 0.01 |  | Tuesday
 |  |  | Monday | 110 | 0.05
 |  |  | Tuesday | 120 | 0.09
 |  |  | Wednesday | 130 | 0.13
 |  |  | Thursday | 140 | 0.17
 |  |  | Friday | 150 | 0.21
 |  |  | Saturday | 160 | 0.25
 |  |  | Holiday 1 | 170 | 0.29
 |  |  | Holiday 2 | 180 | 0.33
Spreadsheet: chris_germany__2576__VNG Pipeline Setup-Oct-00
Sheet: Confirmation

 | ENA Pipeline Citygate Nominations - October 10
 | Columbia
 |  |  |  |  | Previous | 2000-10-09 00:00:00 | New
 | Delivery |  |  |  | ENA |  |  |  | Gas Control
 | Point |  | Contract # |  | Nominated |  |  |  | Confirmed
 | [NAME] 30 VN |  | 65066 |  | 31825 |  | 31825
 | [NAME] 30 VN |  | 38115 | FTS
 | [NAME] 30 VN |  | 38088 | SST | 0 |  | 0
 |  |  |  |  |  | Total
 | CNG
 |  |  |  |  | Previous |  | New
 | Delivery |  |  |  | ENA |  |  |  | Gas Control
 | Point |  | Contract # |  | Nominated |  |  |  | Confirmed
 | Quantico |  | 10007 |  | 16558 |  | 16558
 |  |  |  |  |  | Total
 | ENA Total VNG Deliveries
 | ENA Pipeline Citygate Nominations - October 11
 | Columbia
 |  |  |  |  | Previous |  | New
 | Delivery |  |  |  | ENA |  |  |  | Gas Control
 | Point |  | Contract # |  | Nominated |  |  |  | Confirmed
 | [NAME] 30 VN |  | 65066 |  |  |  | 31825
 | [NAME] 30 VN |  | 38115 | FTS
 | [NAME] 30 VN |  | 38088 | SST |  |  | 1465
 |  |  |  |  |  | Total
 | CNG
 |  |  |  |  | Previous |  | New
 | Delivery |  |  |  | ENA |  |  |  | Gas Control
 | Point |  | Contract # |  | Nominated |  |  |  | Confirmed
 | Quantico |  | 10007 |  |  |  | 16558
 |  |  |  |  |  | Total
 | ENA Total VNG Deliveries
 | ENA Pipeline Citygate Nominations - October 12
 | Columbia
 |  |  |  |  | Previous |  | New
 | Delivery |  |  |  | ENA |  |  |  | Gas Control
 | Point |  | Contract # |  | Nominated |  |  |  | Confirmed
 | [NAME] 30 VN |  | 65066 |  |  |  | 31825
 | [NAME] 30 VN |  | 38115 | FTS
 | [NAME] 30 VN |  | 38088 | SST
 |  |  |  |  |  | Total
 | CNG
 |  |  |  |  | Previous |  | New
 | Delivery |  |  |  | ENA |  |  |  | Gas Control
 | Point |  | Contract # |  | Nominated |  |  |  | Confirmed
 | Quantico |  | 10007 |  |  |  | 16558
 |  |  |  |  |  | Total
 | ENA Total VNG Deliveries