tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60867d1261456882-compile-worksheet-list-toll-free-test
Sheet: 8771234567

 |  | [PHONE]
 | Total | 26 | 16 | 1036 | 10 | 0.6153846153846154 | 5 | 0.1923076923076923
 |  | Attempted Calls | Completed Calls | Completed MOU | Incomplete Calls | Percent Complete | Busy Calls | Percent Busy
 | 2009-11-11 00:00:00 | 3 | 2 | 435 | 1 | 0.6666666666666666 | 0 | 0
 | 2009-11-12 00:00:00 | 6 | 3 | 342 | 3 | 0.5 | 3 | 0.5
 | 2009-11-13 00:00:00 | 5 | 3 | 234 | 2 | 0.6 | 1 | 0.2
 | 2009-11-14 00:00:00 | 12 | 8 | 25 | 4 | 0.6666666666666666 | 1 | 0.08333333333333333
 | 2009-11-15 00:00:00
 | 2009-11-16 00:00:00
 | 2009-11-17 00:00:00
 | 2009-11-18 00:00:00
 | 2009-11-19 00:00:00
 | 2009-11-20 00:00:00
 | 2009-11-21 00:00:00
 | 2009-11-22 00:00:00
 | 2009-11-23 00:00:00
 | 2009-11-24 00:00:00
 | 2009-11-25 00:00:00
 | 2009-11-26 00:00:00
 | 2009-11-27 00:00:00
 | 2009-11-28 00:00:00
 | 2009-11-29 00:00:00
 | 2009-11-30 00:00:00
 | Sub Total : Nov | 26 | 16 | 1036 | 10 | 0.6153846153846154 | 5 | 0.1923076923076923
 | 2009-12-01 00:00:00
 | 2009-12-02 00:00:00
 | 2009-12-03 00:00:00
 | 2009-12-04 00:00:00
 | 2009-12-05 00:00:00
 | 2009-12-06 00:00:00
 | 2009-12-07 00:00:00
 | 2009-12-08 00:00:00
 | 2009-12-09 00:00:00
 | 2009-12-10 00:00:00
 | 2009-12-11 00:00:00
 | 2009-12-12 00:00:00
 | 2009-12-13 00:00:00
 | 2009-12-14 00:00:00
 | 2009-12-15 00:00:00
 | 2009-12-16 00:00:00
 | 2009-12-17 00:00:00
 | 2009-12-18 00:00:00
 | 2009-12-19 00:00:00
 | 2009-12-20 00:00:00
 | 2009-12-21 00:00:00
 | 2009-12-22 00:00:00
 | 2009-12-23 00:00:00
 | 2009-12-24 00:00:00
 | 2009-12-25 00:00:00
 | 2009-12-26 00:00:00
 | 2009-12-27 00:00:00
 | 2009-12-28 00:00:00
 | 2009-12-29 00:00:00
 | 2009-12-30 00:00:00
 | 2009-12-31 00:00:00
 | Sub Total : Dec | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A
Spreadsheet: b07f0f82-9d10-4d03-a334-e4dfe71f2091
Sheet: Fields B-E

Permit No.: |  |  | WQ0003405 |  |  |  | Facility Name: |  | Elm City WWTP |  |  |  |  |  | County: | Wilson |  | Month: |  |  | Year:
Did irrigation occur at this facility? |  |  |  |  |  |  | Field Name: |  | B |  | Field Name: |  | C |  | Field Name: |  | D |  | Field Name: |  | E
 |  |  |  |  |  |  | Area (acres): |  | 13.63 |  | Area (acres): |  | 7.62 |  | Area (acres): |  | 8.5 |  | Area (acres): |  | 3.64
 |  |  |  |  |  |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue
 |  |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  |  | Annual Rate (in): |  | 14.58 |  | Annual Rate (in): |  | 36.19 |  | Annual Rate (in): |  | 46.57 |  | Annual Rate (in): |  | 36.19
Day | Weather |  |  | Freeboard |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Primary Lagoon | 301 Lagoon | Secondary Lagoon | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time    Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading
 |  | ºF | in | ft | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 43716d1242330506-nested-if-statements-or-choose-statements-needed-for-multiple-conditions-formula-nested-if-statements
Sheet: Sheet1

I have the text in two column - example column R has "High" and column s has "annual". |  |  |  |  |  |  |  |  |  |  |  |  | Column R | Column S | Column U |  | Low | Monthly |  | 1 | IF statement
 |  |  |  |  |  |  |  |  |  |  |  |  | High | Annual | 1 |  |  |  |  | 1 | SUMPRODUCT
I have a set of conditions that I need the formula to perform: |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Annual | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Low | Quarterly | 1
if Column R has "high" and column S has "annual", the formula should display the words "1" in column U. |  |  |  |  |  |  |  |  |  |  |  |  | High | Quarterly | 3
if Column R has "low" and column S has "quarterly", the formula should display the words "1" in column U. |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Quarterly | 2
if Column R has "medium" and column S has "annual", the formula should display the words "1" in column U. |  |  |  |  |  |  |  |  |  |  |  |  | Low | Monthly | 1
if Column R has "low" and column S has "monthly", the formula should display the words "1" in column U.
if Column R has "high" and column S has "quarterly", the formula should display the words "3" in column U.
if Column R has "medium" and column S has "quarterly", the formula should display the words "2" in column U.
Can someone please help in the next few minutes if possible, I'd appreciate it!
Thanks!! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Annual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Quarterly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | Monthly
Spreadsheet: 787098d1657633197-sum-the-expenses-by-month-groups-of-contractors-samplesheet
Sheet: Received invoices

Number | Name of the contractor | Date of the payment | Price | Currency | Code
1 | [NAME] | 2019-01-01 00:00:00 | 456 | USD | wgQZSnj7mG ext000 part000 backend000
2 | [NAME] | 2019-01-02 00:00:00 | 126 | USD | HJbA3ebAxb apps000 otherapp000
3 | [NAME] | 2019-05-05 00:00:00 | 897 | USD | 4kZps56gHs apps000 [NAME]
4 | Morgan Freeman | 2019-01-02 00:00:00 | 456 | USD | 7EyAAAQhQQ int000 full000 support000
5 | [NAME] | 2019-02-08 00:00:00 | 745 | USD | wgQZSnj7mG ext000 part000 backend000
6 | [NAME] | 2019-01-07 00:00:00 | 559 | USD | 7Sfsfe894ds apps000 [NAME]
7 | [NAME] | 2019-01-09 00:00:00 | 426 | USD | 4kZps56gHs apps000 [NAME]
8 | [NAME] | 2019-01-09 00:00:00 | 477 | USD
9 | Morgan Freeman | 2019-03-05 00:00:00 | 456 | USD | 7EyAAAQhQQ int000 full000 support000
10 | [NAME] | 2019-01-04 00:00:00 | 87 | USD | wgQZSnj7mG ext000 part000 backend000
11 | [NAME] | 2019-06-12 00:00:00 | 998 | USD | HJbA3ebAxb apps000 otherapp000
12 | [NAME] | 2019-01-02 00:00:00 | 4265 | USD | 4kZps56gHs apps000 [NAME]
13 | Morgan Freeman | 2019-01-02 00:00:00 | 452 | USD | 7EyAAAQhQQ int000 full000 support000
14 | [NAME] | 2019-05-02 00:00:00 | 42 | USD | wgQZSnj7mG ext000 part000 backend000
15 | [NAME] | 2019-01-02 00:00:00 | 899 | USD | wr89ssEfd45E ext000 part000 backend000
Spreadsheet: 375868d1423377928-help-with-date-range-example
Sheet: Data

Object ID | Object Name | Owner | Start Date | End Date | Kickoff Date | Draft Review | [NAME] | Release
C001 | Jupiter | [NAME] | 2014-12-01 00:00:00 | 2015-02-27 00:00:00 | 2015-03-06 00:00:00 | 2015-02-15 00:00:00 | 2015-02-21 00:00:00 | 2
E023 | Milky | Greg | 2014-11-21 00:00:00 | 2015-02-19 00:00:00 | 2015-03-05 00:00:00 | 2015-02-15 00:00:00 | 2015-02-21 00:00:00 | 3
R021 | Andromeda | Ray | 2015-01-21 00:00:00 | 2015-04-06 00:00:00 | 2015-01-08 00:00:00 | 2015-03-21 00:00:00 | 2015-04-01 00:00:00 | 2
C005 | Mars | [NAME] | 2015-01-21 00:00:00 | 2015-03-20 00:00:00 | 2015-03-06 00:00:00 | 2015-03-06 00:00:00 | 2015-03-15 00:00:00 | 3
W005 | Surfer | [NAME] | 2014-12-01 00:00:00 | 2015-01-23 00:00:00 | 2015-03-05 00:00:00 | 2015-01-08 00:00:00 | 2015-01-13 00:00:00 | 3
W009 | [NAME] | Ray | 2014-11-21 00:00:00 | 2015-01-26 00:00:00 | 2015-01-08 00:00:00 | 2015-01-08 00:00:00 | 2015-01-13 00:00:00 | 2
C021 | Star | Greg | 2015-01-21 00:00:00 | 2015-03-30 00:00:00 | 2015-03-06 00:00:00 | 2015-03-06 00:00:00 | 2015-03-15 00:00:00 | 3
E056 | Pluto | [NAME] | 2014-11-01 00:00:00 | 2015-03-13 00:00:00 | 2015-03-05 00:00:00 | 2015-02-21 00:00:00 | 2015-03-01 00:00:00 | 2
R123 | Earth | Ray | 2014-12-01 00:00:00 | 2015-01-30 00:00:00 | 2015-01-08 00:00:00 | 2015-01-08 00:00:00 | 2015-01-13 00:00:00 | 3
R432 | Saturn | [NAME] | 2014-11-21 00:00:00 | 2015-02-04 00:00:00 | 2015-03-06 00:00:00 | 2015-01-20 00:00:00 | 2015-01-30 00:00:00 | 3
C043 | Neptune | Greg | 2015-01-21 00:00:00 | 2015-04-17 00:00:00 | 2015-03-05 00:00:00 | 2015-03-21 00:00:00 | 2015-04-01 00:00:00 | 3
E087 | Mercury | [NAME] | 2014-11-21 00:00:00 | 2015-02-09 00:00:00 | 2015-01-08 00:00:00 | 2015-01-20 00:00:00 | 2015-01-30 00:00:00 | 3
W231 | Gemini | Ray | 2014-12-01 00:00:00 | 2015-02-09 00:00:00 | 2015-03-06 00:00:00 | 2015-01-20 00:00:00 | 2015-01-30 00:00:00 | 2
E096 | Venus | [NAME] | 2014-11-01 00:00:00 | 2015-02-27 00:00:00 | 2015-03-05 00:00:00 | 2015-02-15 00:00:00 | 2015-02-21 00:00:00 | 3
C056 | Crab | [NAME] | 2014-11-01 00:00:00 | 2015-03-13 00:00:00 | 2015-01-08 00:00:00 | 2015-03-06 00:00:00 | 2015-03-15 00:00:00 | 3
W321 | Pillars | Ray | 2014-11-21 00:00:00 | 2015-02-09 00:00:00 | 2015-03-06 00:00:00 | 2015-01-20 00:00:00 | 2015-01-30 00:00:00 | 2
E066 | Skywalker | [NAME] | 2014-12-01 00:00:00 | 2015-02-09 00:00:00 | 2015-01-08 00:00:00 | 2015-01-20 00:00:00 | 2015-01-30 00:00:00 | 3
C087 | Orion | [NAME] | 2015-01-21 00:00:00 | 2015-03-23 00:00:00 | 2015-03-06 00:00:00 | 2015-03-05 00:00:00 | 2015-03-15 00:00:00 | 2
Spreadsheet: 125427d1319027888-excel-2007-moving-values-between-sheets-by-using-number-commands-afhendingase-lar-and-loadinfo-1
Sheet: ULD3&4

Name of airline |  |  |  | Aircraft Position |  |  | Name of Airline |  |  |  | Aircraft Position
Built up by: | Hjortur |  | Origin | ULD Ident |  |  | Built up by: | Hjortur |  | Origin | ULD Ident
Total Pages: |  |  |  |  |  |  | Total Pages:
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: errol_mclaughlin_jr__10328__Rpt PMA RM 0009
Sheet: Sheet 1

Variances as of September Accounting
Bookcode | Month | Code | Type | Description | Risk
APEA Prepay (QZ) | Jun | RM | T | May MTM Ending Balance on DPR does not = June MTM Beginning Balance on DPR for Price Deals | -77553.24
Chase II Prepay (QI) | Jun | RM | T | May MTM Ending Balance on DPR does not = June MTM Beginning Balance on DPR for Price Deals | 31765.51
Chase Mahonia IV  (QK) | Jun | RM | T | May MTM Ending Balance on DPR does not = June MTM Beginning Balance on DPR for Price Deals | -9677.61
Chase V (QL) | Jun | RM | T | May MTM Ending Balance on DPR does not = June MTM Beginning Balance on DPR for Price Deals | -23606.96
Chase VIII | Jun | RM | T | May MTM Ending Balance on DPR does not = June MTM Beginning Balance on DPR for Price Deals | -1605418.67
Energy America Prepay (QH) | Jun | RM | T | May MTM Ending Balance on DPR does not = June MTM Beginning Balance on DPR for Price Deals | -11449.84
FPL Hedge (G&) | Aug | RM | E | One Liquidation came through for Aug NT4811; Not in DPR | -159803
FPL Hedge (G&) | Various | RM | T | MTM- Brooklyn's prior explanation: Amount needs to be put back into Schedule C on Roll 4. Requested DPR adjusted for March 2000. | 117313
FPL Hedge (G&) | Various | RM | E | EZ0695.1, EZ0696.1, EZ0697.1 | -1358.37
FT Texas Online | Sep | RM | O | Gas Daily Variances | 2094.96
JS-Executive Spec  (GY) | Jul | RM | E | DPR adj taken twice | 112148
JS-Executive Spec  (GY) | Jul | RM | E | DPR adj taken twice | -1564
NG Gas Hedge (QN, W( ) | Sep | RM | E | Gas Daily Variances | 10165.85
NG PRICE | Aug | RM | E | NS6608.1 not in DPR | 1735070
NG PRICE | Aug | RM | E | NS9850.1 not in DPR | -875285
NG PRICE | Aug | RM | E | NQ1035.1 not in DPR | -1185000
NG PRICE | Aug | RM | E | NQ6582.1 not in DPR | -2370000
NG PRICE | Aug | RM | E | NQ1049.1 not in DPR | -592500
NG PRICE | Aug | RM | E | NK8033.2 not in DPR | -166625
NG PRICE | Aug | RM | E | NQ6584.1 not in DPR | 1092500
NG PRICE | Jul | RM | E | NYMEX Options/Futures | 500
NG PRICE | Sep | RM | E | Broker Fees | -510112
NG PRICE | Sep | RM | E | Qualitech Steel Corp.- Reverse DPR Adjustments taken; Brooklyn had been sending deal E49515.1 as a revenue adjustment to the DPR because she was told that this deal was in bankrupt status. However, there was an offsetting deal E49515.2 that should have been coded to offset the bankrupt deal. So, in total there should have been no P&L affect. | -1059860.9
NG PRICE | Sep | RM | E | Access Differences | -4439.09
NG PRICE | Sep | RM | E | NU 1922.1 not in DPR | 118000
Strategic Energy Prepay (QP) | Jun | RM | T | May MTM Ending Balance on DPR does not = June MTM Beginning Balance on DPR for Price Deals | -3905.32
Spreadsheet: 210736d1359553320-trying-to-seperate-a-lot-of-vertical-text-from-a-single-cell-aba
Sheet: ABA

Subject | Body | From: (Name) | From: (Address) | From: (Type) | To: (Name) | To: (Address) | To: (Type) | CC: (Name) | CC: (Address) | CC: (Type) | BCC: (Name) | BCC: (Address) | BCC: (Type) | Billing Information | Categories | Importance | Mileage | Sensitivity
[NAME] | Name of Organisation:_x000D_ _x000D_  _x000D_ _x000D_ Halcyon Days Ltd_x000D_ _x000D_  _x000D_ _x000D_ First Name_x000D_ _x000D_  _x000D_ _x000D_ Wendy_x000D_ _x000D_  _x000D_ _x000D_ Last Name_x000D_ _x000D_  _x000D_ _x000D_ Collins_x000D_ _x000D_  _x000D_ _x000D_ Emai_x000D_ _x000D_ Wendy@testmonkey.com_x000D_ _x000D_ Phone_x000D_ _x000D_ 01234567_x000D_ _x000D_ Course Title_x000D_ _x000D_ Working with Excel Advanced_x000D_ _x000D_  _x000D_ _x000D_  _x000D_ _x000D_  _x000D_ _x000D_ | [NAME] | /O=HALCYON/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=AMY | EX | [NAME] | /O=QLIKTECH/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=[NAME] | EX |  |  |  |  |  |  |  |  | Normal |  | Normal
Spreadsheet: af257546-2c97-4a45-9d53-4429065bc304
Sheet: Sheet1

Unnamed: 0 | Town & Country Sanitation - PO Box 7 - Boscobel, WI  53805 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 800/626.1915
 | 2012 RECYCLING INSTRUCTIONS
 | ALL RECYCLING BINS MUST BE KEPT INSIDE IN DRY PLACE
 | ANY SCHEDULED PICK UP DAYS ON A HOLIDAY AND DAYS FOLLOWING
 | A HOLIDAY WILL RUN ONE DAY LATE
 | GLASS |  |  | PLASTIC |  |  | NEWSPAPER
 | ACCEPTABLE: |  |  | CONTAINERS MUST
 | Soda, beer, wine & liquor |  |  | HAVE RECYCLING |  |  | BUNDLED AND TIED
 | bottles, juice and food |  |  | SYMBOL
 | containers, catsup bottles |  |  |  |  |  | IN A BOX OR GARBAGE BAG
 | ALL COLORS
 | RINSE CLEAN |  |  |  |  |  | KEEP DRY
 | NO LIDS |  |  | PLASTICS 1 THROUGH 7
 | UNBROKEN |  |  |  |  |  | MAY BE PLACED
 | LABELS ON OK! |  |  | NO PLASTIC BAGS |  |  | NEXT TO BIN
 | Not acceptable:  mirrors,
 | ceramic cups and plates, clay |  |  | Items which can be tied together |  |  | MAGAZINES
 | flower pots, crystal, light bulbs, |  |  | (such as milk cartons) may be
 | window glass, heat resistant |  |  | placed next to [NAME]. |  |  | CATALOGS
 | ovenware, drinking glasses
 |  |  |  | RINSE |  |  | BUNDLED AND TIED
 |  |  |  | NO CAPS OR LIDS
 |  |  |  | [NAME] IS NOT RECYCLABLE
 | TIN CANS |  |  | ALUMINUM |  |  | OTHERS
 | RINSE CLEAN |  |  | ALUMINUM CANS |  |  | Corrugated cardboard and
 |  |  |  |  |  |  | [NAME] (cereal, pop, etc.,
 |  |  |  | MAKE SURE FOIL |  |  | must be flattened, bundled
 | ALSO |  |  | IS ALUMINUM |  |  | and tied, in 3 x 4 sheets
 | EMPTIED AEROSOL |  |  |  |  |  | or smaller)
 | CANS ARE |  |  | RINSE
 | RECYCLABLE |  |  |  |  |  | OFFICE PAPER
 |  |  |  |  |  |  | (IN SEALED CLEAR BAG)
 |  |  |  |  |  |  | BATTERIES
 |  |  |  |  |  |  | WASTE OIL
 |  |  |  |  |  |  | (Will be picked up curbside.
 |  |  |  |  |  |  | Nothing bigger than 5 gal.
 |  |  |  |  |  |  | jug with leakproof cap)
 | PLACE AT CURBSIDE BY 6:00 AM
 | THANK YOU!
Spreadsheet: 834449d1687844903-need-to-replace-sumif-function-when-working-with-2-different-criteria-capturing
Sheet: CAPTURING

CADDY | ITEM | AMOUNT
CCV65 | ACE | 700
CCV70 | CS | 500
CCV65 | ACE | 200
CCV66 | BM | 150
CCV65 | ACE | 700
CCV70 | CS | 500
CCV65 | DP | 200
[NAME] | ACE | 1000
CCV88 | ACE | 1000
Spreadsheet: 769077d1645280459-30-day-moving-total-starting-with-today-sums-based-on-dates-and-weeknumbers-barksato-
Sheet: Report1_summary

 |  |  |  |  |  | Date:
 |  |  |  |  |  | Last Data Date:
 |  |  |  |  |  | Week #:
Overall Cummulative Stats
 | This Week |  | Last Week |  | This Month |  | 30day [NAME] |  | This Quarter |  | Last Quarter |  | YTD |  | Last Year |  | 2 Years Ago |  | Total
 |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | %
Average
High
Low
Performance Over Time :  # of REPORTs/# of Days Person was Marked Present
 | This Week |  | Last Week |  | This Month |  | 30day [NAME] |  | This Quarter |  | Last Quarter |  | YTD |  | Last Year |  | 2 Years Ago |  | Total
 | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | %
Spreadsheet: 167153d1341917765-copy-data-with-3-horisontal-or-vertical-criterias-index-and-match-test-excel-sample2
Sheet: Data Source

Cars | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
Europe | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909
Eurasia | 1353 | 1953 | 2553 | 3153 | 3753 | 4353 | 4953 | 5553 | 6153 | 6753 | 7353 | 7953
MEA | 797 | 707 | 617 | 527 | 437 | 347 | 257 | 167 | 77 | 99 | 8803 | 9193
SEAP | 241 | 261 | 281 | 301 | 321 | 341 | 361 | 381 | 401 | 421 | 441 | 461
India | 8989 | 8766 | 8543 | 8320 | 8097 | 7874 | 7651 | 7428 | 7205 | 6982 | 6759 | 6536
NA | 1433 | 185 | 698 | 777 | 856 | 935 | 1014 | 1093 | 1172 | 1251 | 1330 | 1409
LATAM | 3399 | 3398 | 3397 | 3396 | 3395 | 3394 | 3393 | 3392 | 3391 | 3390 | 3389 | 3388
China | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377
World TOTAL | 2287 | 2293 | 2299 | 2305 | 2311 | 2317 | 2323 | 2329 | 2335 | 2341 | 2347 | 2353
Boats | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
Europe | 2083 | 235 | 876 | 1517 | 2158 | 2799 | 3440 | 4081 | 4722 | 5363 | 6004 | 6645
Eurasia | 1953 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225
MEA | 1823 | 215 | 888 | 1561 | 2234 | 2907 | 3580 | 4253 | 4926 | 5599 | 6272 | 6945
SEAP | 1693 | 205 | 999 | 1793 | 2587 | 3381 | 4175 | 4969 | 5763 | 6557 | 7351 | 8145
India | 1563 | 195 | 876 | 1557 | 2238 | 2919 | 3600 | 4281 | 4962 | 5643 | 6324 | 7005
NA | 1433 | 185 | 698 | 777 | 856 | 935 | 1014 | 1093 | 1172 | 1251 | 1330 | 1409
LATAM | 3399 | 3398 | 3397 | 3396 | 3395 | 3394 | 3393 | 3392 | 3391 | 3390 | 3389 | 3388
China | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377
World TOTAL | 9876 | 9854 | 9832 | 9810 | 9788 | 9766 | 9744 | 9722 | 9700 | 9678 | 9656 | 9634
Spreadsheet: 847250d1698261764-sum-if-multiple-criteria-example-calculate_all
Sheet: Poslovi_2023

R/B | Oznaka izdanog računa | TD | PROJECT NAME | Partner | Price |  |  |  | Komentar
 |  |  | Project 100 | Partner A | 200 |  |  |  | PAID
 |  |  | Project 101 | Partner B | 400 |  |  |  | TO BE PAID
 |  |  | Project 102 | Partner A | 352 |  |  |  | TO BE PAID
 |  |  | Project 103 | Partner C | 255 |  |  |  | PAID
 |  |  | Project 104 | Partner D |  |  |  |  | NOT FINISHED
 |  |  | Project 105 | Partner D |  |  |  |  | NOT FINISHED
 |  |  | Project 106 | Partner D |  |  |  |  | PAID
 |  |  | Project 107 | Partner A |  |  |  |  | TO BE PAID
 |  |  | Project 108 | Partner C |  |  |  |  | TO BE PAID
 |  |  | Project 109 | Partner B | 400 |  |  |  | TO BE PAID
Spreadsheet: 813516d1673832016-iferror-vlookup-help-when-lookup-is-not-found-or-column-sorted-different-vehicle-ef-gk
Sheet: August2022

Biosecurity Operations Branch Vehicle Fleet August 2022
[NAME] | Make | Lease | Location | Region | Cost Code | Responsible Area / Driver | Service Interval Mnths/Kms | Expected KM | vlookup lease | Current Kilometres | Current KM Decimal | Expected KM + 5000 | Expected KM - 5000 | Utilisation + or - 5 | Utilisation | Under / Over Agreement | Comments
G00DA | Toyota Rav4 | 36 mnths/60,000K | [NAME] | NW | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G04CL | [NAME] Dual Cab 4x4 Ute | 36 mnths/60,000K | Mt Pleasant | N | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G06CW | Toyota Corolla Hatchback | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000
G25CO | Toyota Camry | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G28CR | Toyota Camry | 36 mnths/60,000K | New Town | S | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G29CO | Toyota Rav4 | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
A79KH | Make/Model Manually added for forum | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000
Spreadsheet: 134623d1325520440-concatenating-a-varying-daily-list-forum-sample1
Sheet: Sheet1

 | 3
05 | 053
15 | 153
25 | 253
35 | 353
45 | 453
55 | 553
56 | 563
57 | 573
58 | 583
59 | 593
09 | 093
19 | 193
29 | 293
39 | 393
49 | 493
69 | 693
79 | 793
89 | 893
99 | 993
00 | 003
01 | 013
02 | 023
03 | 033
04 | 043
06 | 063
07 | 073
08 | 083
18 | 183
28 | 283
38 | 383
48 | 483
68 | 683
78 | 783
88 | 883
13 | 133
23 | 233
33 | 333
34 | 343
36 | 363
37 | 373
11 | 113
12 | 123
14 | 143
16 | 163
17 | 173
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3