tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 599091d1542852122-sumifs-formulea-results-0-00-not-working
Sheet: Combined

All Brokers Combined
Referrer | Total Number | Settled | NPW | Deferred | Loan Amount |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Pedram |  |  |  |  |  |  |  |  |  | Lana
Graeme |  |  |  |  |  |  |  |  |  | [NAME]
Justin
[NAME]
Other
Yes
No
Spreadsheet: 802928d1667154687-problem-eliminating-text-duplicates-duplicates-1-dropdownlistfrequency
Sheet: DROP DOWN CODE

SELECT CODE
Spreadsheet: 856771d1705946377-check-multiple-conditions-for-proper-value-topstep
Sheet: TRADES

INSTRUMENT | WEEK | DATE | TIME | SIDE | RISK | ENTRY | STOP | SIZE | ADD | ADD SIZE | DD | HIGH / LOW | PT 1 | PT 1 SIZE | EXIT | EXIT SIZE | TICKS | POINTS | COMM | NET | R2R | SETUP | ENTRY POINT | EXIT REASON | CHART | NOTES
ES | 202404 | 2024-01-19 00:00:00 | 10:14:00 | Short | 150 | 4810 | 4811.5 | 2 |  |  |  | 4812 |  |  | 4806 | 2 |  |  |  |  |  | BO | HOD | Failed
Spreadsheet: 189755d1351323600-required-the-total-of-odd-number-of-each-doc-no-and-mention-count-no-from-excel-working-book1
Sheet: Sheet1

 |  |  |  |  | Desired Result
 | Doc No. | Amount | Count |  | Doc No. | Amount | Count
 | 98521685 | 100 |  |  | 98521685 | 100 | 1
 | 98521685 | 200 |  |  | 98521685 | 300 | 3
 | 98521685 | 300 |  |  | 98521685 | 500 | 5
 | 98521685 | 400 |  |  | 98652487 | 100 | 1
 | 98521685 | 500 |  |  | 99745823 | 100 | 1
 | 98521685 | 600
 | 98652487 | 100
 | 98652487 | 200
 | 99745823 | 100
 | 99745823 | 200
Spreadsheet: 672561d1586910865-count-unique-values-of-text-with-an-additional-with-clause-example
Sheet: Hotspot

Data | Data | Data | Data | Data | Data | Data | Pet | Colour
x | x | x | x | x | x | x | Dog | Red
x | x | x | x | x | x | x | Cat | Red
x | x | x | x | x | x | x | Fish | Blue
x | x | x | x | x | x | x | Bird | Blue
x | x | x | x | x | x | x | Dog | Green
x | x | x | x | x | x | x | Horse | Orange
x | x | x | x | x | x | x | Dog | Red
x | x | x | x | x | x | x | Cat | Yellow
x | x | x | x | x | x | x | Cat | Purple
x | x | x | x | x | x | x | Bird | [NAME]
x | x | x | x | x | x | x | Rat | [NAME]
Spreadsheet: hunter_shively__12718__NatGasProductLists
Sheet: Central Gas Products

CENTRAL GAS TRADING PRODUCT LAUNCH SCHEDULE
 |  | Phase 1 |  |  |  |  | Phase 2
 | Type | Region | Location | Period | Trader | Type | Location | Period | Trader
1 | Basis Swaps (Financial) | Market Area | Chicago | Feb |  | Physical Fixed price Gas | Market Area | Chicago | Daily
2 |  |  |  | Mar |  |  |  |  | Prompt
3 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  | Michcon | Daily
7 |  |  | Michcon | Feb |  |  |  |  | Prompt
8 |  |  |  | Mar |  |  |  | Dawn | Daily
9 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  |  | Prompt
13 |  | Midcon | Pepl | Feb |  |  | Midcon | Pepl | Daily
14 |  |  |  | Mar |  |  |  |  | Prompt
 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  | [NAME] | Daily
 |  |  | [NAME] | Feb |  |  |  |  | Prompt
 |  |  |  | Mar |  |  |  | Ventura | Daily
 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  |  | Prompt
 |  |  | Ventura | Feb |  |  |  | ANR-SW | Daily
 |  |  |  | Mar |  |  |  |  | Prompt
 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  | NGPL-Midcon | Daily
 |  | Gulf | ANR-SE | Feb |  |  |  |  | Prompt
 |  |  |  | Mar |  |  | Gulf | ANR-SE | Daily
 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  |  | Prompt
 |  |  | NGPL-LA | Feb |  |  |  | NGPL-LA | Daily
 |  |  |  | Mar |  |  |  |  | Prompt
 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  | Trunk-LA | Daily
 |  |  | Trunk-LA | Feb |  |  |  |  | Prompt
 |  |  |  | Mar |  |  |  | NGPL-Texok | Daily
 |  |  |  | Apr-Oct'02 & Nov02-Mar03 |  |  |  |  | Prompt
 |  |  | NGPL-Texok | Feb
 |  |  |  | Mar
 |  |  |  | Apr-Oct'02 & Nov02-Mar03
 | Gas Daily Swaps (Financial) | Market Area | Chicago | Daily |  | Physical Index Gas |  | Chicago | Prompt
 |  |  |  | BOM
 |  |  |  | Prompt |  |  |  | Michcon | Prompt
 |  |  | Michcon | Daily
 |  |  |  | BOM |  |  |  | Pepl | Prompt
 |  |  |  | Prompt
 |  |  | Dawn | Daily |  |  |  | [NAME] | Prompt
 |  |  |  | BOM
 |  |  |  | Prompt |  |  |  | Ventura | Prompt
 |  |  |  | Feb
 |  |  |  | Mar |  |  |  | ANR-SW | Prompt
 |  |  |  | Apr-Oct'02 & Nov02-Mar03
 |  | Midcon | Pepl | Daily |  |  |  | NGPL-Midcon | Prompt
 |  |  |  | BOM
 |  |  |  | Prompt |  |  |  | ANR-SE | Prompt
 |  |  | [NAME] | Daily
 |  |  |  | BOM |  |  |  | NGPL-LA | Prompt
 |  |  |  | Prompt
 |  |  | Ventura | Daily |  |  |  | Trunk-LA | Prompt
 |  |  |  | BOM
 |  |  |  | Prompt |  |  |  | NGPL-Texok | Prompt
 |  | Gulf | ANR-SE | Daily
 |  |  |  | BOM
 |  |  |  | Prompt
 |  |  | NGPL-LA | Daily
 |  |  |  | BOM
 |  |  |  | Prompt
 |  |  | Trunk-LA | Daily
 |  |  |  | BOM
 |  |  |  | Prompt
Spreadsheet: 150574d1334606633-copying-data-to-another-worksheet-test
Sheet: TEST #1

TEST #1
 | DATE |  | 2012-04-16 00:00:00 |  |  |  | INIT |  | TEST
 | FIRST NAME
 | LAST NAME
 | DATE
 | 1. Fill in your particulars in the highlighted boxes above.
 | 2. This is a 25 question multiple choice test. Pass is 15 out of 25 for 60%.
 | 3. Type in your answer in the form of either A, B, C, or D in the yellow highlighted box to the right of each of the questions. For example, if Question 1 was "A", then fill in box as:
 |  |  |  |  |  |  |  |  |  | A
 | 4. Once you have completed the test, e-mail the test back to me. You will receive an answer as soon as possible.
 | 5. If you should happen to "fail' the test, you will be given a new test within 24hrs.
1 | What is 25 x 25?
A | 355
B | 625
C | 435
D | 425
2 | When did Columbus discover America?
A | 1592
B | 1364
C | 1492
D | 1508
3 | How many continents of the world are there?
A | 5
B | 9
C | 6
D | 7
4 | How many hours in a day?
A | 24
B | 23
C | 25
D | 26
5 | How many days in a normal year?
A | 367
B | 365
C | 366
D | 364
6 | How many colours in a rainbow?
A | 5
B | 6
C | 8
D | 7
7 | How many letters in the English alphabet?
A | 24
B | 26
C | 27
D | 28
8 | How many bones in the adult human body?
A | 201
B | 210
C | 206
D | 180
9 | How long is a millenium?
A | 100 years
B | 10 years
C | 500 years
D | 1000 years
10 | Four score and seven years is how long?
A | 47
B | 63
C | 87
D | 107
Spreadsheet: 0eb76dc4-6453-4ce0-a89b-3f4c79d3606f
Sheet: Table I.7

Table I.7 الجدول
Total Freshwater Abstracted (MCM/yr)
مجموع المياه العذبة المستخرجة (مليون متر مكعب/سنة)
 | Surface Water Abstraction |  |  | Groundwater Abstraction
 | استخراج المياه السطحية |  |  | استخراج المياه الجوفية
 | 2005 | 2007 | 2008 | 2005 | 2007 | 2008
Bahrain | … | … | … | 50d/, 5 | 40d/, 5 | 29d/, 5 | البحرين
Egypt | 53,100a/ | 54,030a/ | 56,150a/ | 5,884a/ | 6,474a/ | 7,500a/ | مصر
Iraq | 51,442a/, 1 | 58,919a/, 2 | 55,345a/, 3 | … | … | … | العراق
Jordan | 351a/ | 345a/ | 336a/ | 506a/ | 504a/ | 499a/ | الأردن
Kuwait | -b/ | -b/ | … | 164e/, 5 | 156e/, 5 | 142e/,5 | الكويت
Lebanon | 563c/ | … | … | 700c/ | … | … | لبنان
Oman | … | … | … | 53f/ | … | 94g/ | عمان
Palestine | … | … | … | 268a/, 6 | 286a/, 6 | 251a/, 6 | فلسطين
Qatar | -c/ | … | … | 1a/ | … | 16f/ | قطر
Saudi Arabia | 1,100c/, 4 | … | … | … | 920h/ | 958h/ | المملكة العربية السعودية
United Arab Emirates | -a/ | -a/ | -a/ | 114a/ | 121a/ | 133a/ | الإمارات العربية المتحدة
Yemen | … | … | … | 130a/, 7 | 140a/, 7 | 142a/, 7 | اليمن
ESCWA | … | … | … | 78708 | 86419 | 976410 | [NAME]
Sources: | a/ | UNSD/UNEP Questionnaire on Environment Statistics 2010.
 | [NAME] | UNSD/UNEP Questionnaire on Environment Statistics 2008.
 | c/ | Aquastat Database, accessed on 17 April 2011.
 | d/ | Ministry of Electricity and Water website.
 | e/ | Kuwait Statistical Yearbook 2009, Statistics Department and Information Center.
 | f/ | Water Statistical Book for the Cooperation Council for the Arab States of the Gulf, First Edition, 2008.
 | g/ | Water Statistical Book for the Cooperation Council for the Arab States of the Gulf, Second Edition, 2010.
 | h/ | Annual Report (1430-1431 h) 2009, Ministry of Water and Electricity, Kingdom of Saudi Arabia.
Notes: | 1 | Includes surface water abstracted by the water supply industry (ISIC 36) and agriculture, forestry and fishing only.
 | 2 | Includes surface water abstracted by the water supply industry (ISIC 36), households, agriculture, forestry and fishing and manufacturing (ISIC 10-33) only.
 | 3 | Includes surface water abstracted by the water supply industry (ISIC 36), agriculture, forestry and fishing, manufacturing (ISIC 10-33) and electricity industry (ISIC 351) only.
 | 4 | FAO Estimate.  Data for the year 2006.
 | 5 | Value converted from Million Imperial Gallons per day- 1IG=0.004546 m3.
 | 6 | Includes groundwater abstracted by the water supply industry (ISIC 36) only.  Includes water extracted from underground wells and the annual flow of water springs.  Source: Central Bureau of Statistics, 2009.  [NAME] in the Palestinian territories, Annual Report 2008 Ramallah – Palestine.
 | 7 | Includes groundwater abstracted by the water supply industry (ISIC 36) for household usages only.
 | 8 | Excluding Iraq and Saudi Arabia.
 | 9 | Excluding Iraq, Lebanon, Oman and Qatar.
 | 10 | Excluding Iraq and Lebanon.
Spreadsheet: 887020d1737104248-rquired-formula-for-common-digits-and-remening-digits-in-0-9-common-digits-1
Sheet: Sheet1

 | D1 |  | D2 |  | D3 |  | D4 |  | D5 |  | [NAME] | REMANING DIGITS
 | 45326 |  | 60139 |  | 34567 |  | 12345 |  | 13579
 | 43270 |  | 89034 |  | 89012 |  | 12340 |  | 70624
 | 63271 |  | 10639 |  | 15678 |  | 12346 |  | 45160
 |  |  |  |  |  |  |  | I need this result from [NAME]
Spreadsheet: 219315d1362710432-if-else-if-or-easier-recommendation-rp_supporter2012_sample-ver1
Sheet: Comish Calc

Commission Report
Sub Pro | 518 |  |  |  | Total Payout :
Month | 3
Row Labels | Sum of Points | Total Items | Premium
Name | 10 | 1 | 606.03
111111111 | 10 | 1 | 606.03
[NAME] | 100 | 1 | 750.65
222222222 | 100 | 1 | 750.65
Grand Total | 110 | 2 | 1356.68
Potential Commission =
Bonus Payout =
Total Payout =
Spreadsheet: 864313d1711536689-booking-document-need-help-booking-ramadhan-ballroom
Sheet: Reservation Summary 

Total booking code | Booking code | Total in IDR
 | 250323
 | 260323
 | 270323
 | 280323
 | 290323
 | 300323
 | 310323
 | 10423
 | 20423
 | 30423
 | 40423
 | 50423
 | 60423
 | 70423
 | 80423
 | 90423
 | 100423
 | 110423
 | 120423
 | 130423
 | 140423
 | 150423
 | 160423
 | 170423
 | 180423
 | 190423
 | 200423
 | 210423
 | 220423
Spreadsheet: 109327d1306231107-advanced-formatting-and-macro-book1
Sheet: Sheet1

Team | Vertical | Tickets |  |  |  |  | DropDown |  | List
Sales Engine |  |  |  |  |  |  | Sales Engine |  | Sales Engine
 |  |  |  |  |  |  |  |  | STO
Team | Vertical | Tickets
1G | . | 105
1G | Agency | 26
1G | Automotive | 3
1G | B2B | 5
1G | Entertainment | 2
1G | Finance | 4
1G | FMCG | 21
1G | Local | 30
1G | Other | 5
1G | Retail | 76
1G | Technology | 19
1G | Travel | 17
Ads Policy | . | 18
Ads Policy | Agency | 4
Ads Policy | B2B | 1
Ads Policy | Entertainment | 6
Ads Policy | Finance | 2
Ads Policy | FMCG | 3
Ads Policy | Retail | 7
Ads Policy | Technology | 1
Ads Policy | Travel | 4
Approvals | . | 111
Approvals | Agency | 6
Approvals | Automotive | 12
Approvals | B2B | 11
Approvals | Display | 28
Approvals | Entertainment | 41
Approvals | Finance | 6
Approvals | FMCG | 18
Approvals | Local | 3
Approvals | Other | 114
Approvals | Retail | 28
Approvals | Technology | 10
Approvals | Travel | 13
Sales Engine | . | 93
Sales Engine | Agency | 50
Sales Engine | Automotive | 51
Sales Engine | B2B | 46
Sales Engine | Display | 2
Sales Engine | Entertainment | 325
Sales Engine | Finance | 33
Sales Engine | FMCG | 153
Sales Engine | Local | 133
Sales Engine | Other | 29
Sales Engine | Retail | 188
Sales Engine | Technology | 79
Sales Engine | Travel | 83
STO | . | 105
STO | Agency | 29
STO | Automotive | 9
STO | B2B | 10
STO | Display | 33
STO | Entertainment | 12
STO | Finance | 5
STO | FMCG | 18
STO | Local | 68
STO | Other | 74
STO | Retail | 40
STO | [NAME] | 4
STO | Technology | 26
STO | Travel | 29
Grand Total |  | 2487
Spreadsheet: 81735d1281907662-formulas-previously-working-now-resulting-in-0-trimmean-average-formulas-used-excel-help-forum-rev1
Sheet: Monday Prep

Monday |  |  | Need | Have | Make | Initial
Dough | Pans (44 = 1 Batch)
 | Mids (68 = 1 Batch)
 | Thins (72 = 1 Batch)
 | Personals
Mids | Meatlovers
 | Hawaiian
 | Supreme
 | Pepperoni
Pans | Meatlovers
 | Hawaiian
 | Supreme
 | Pepperoni
Thins | Pepperoni
TO BE COMPLETED AFTER DOUGH AND PRE-MAKES WITH MAKE-BENCH FULL
Cheese | Containers (Coolroom) |  | 3
 | X.Large Bains ([NAME]) |  | 4
Pineapple | [NAME] ([NAME]) |  | 4
Capsicum | Buckets (Coolroom) |  | 0.5
Onion | Buckets (Coolroom) |  | 0.5
Mushrooms | Cartons (Coolroom) |  | 1
Olives | Small Bains ([NAME] fridge) |  | 1
Sauces | [NAME] ([NAME] fridge) |  | 2
 | Tomato Sauce Buckets (Cool Room) |  | 3
 | [NAME] ([NAME] fridge) |  | 2
Wings | Packets (Makebench fridge) |  | 6
Ribs | Packets (Makebench fridge) |  | 9
Steak | Small Bains ([NAME] fridge) |  | 1
Pork | Small Bains ([NAME] fridge) |  | 1
Meat Mix | Buckets (Cool Room) |  | 1
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: EDUC

Old course number | New course number
EDUC-310 | EDUC-2310
EDUC-320 | EDUC-3320
EDUC-321 | EDUC-3321
EDUC-330 | EDUC-2330
EDUC-433 | EDUC-4330
EDUC-433 | EDUC-6330
EDUC-434 | EDUC-4340
EDUC-434 | EDUC-6340
EDUC-436 | EDUC-4360
EDUC-436 | EDUC-6360
EDUC-437 | EDUC-4437
EDUC-437 | EDUC-6370
EDUC-440 | EDUC-4440
EDUC-442 | EDUC-4442
EDUC-443 | EDUC-4443
EDUC-465 | EDUC-4465
EDUC-470 | EDUC-4470
EDUC-499 | [NAME]
EDUC-530 | [NAME]
EDUC-531 | EDUC-5531
EDUC-535 | EDUC-5535
EDUC-564 | EDUC-5640
EDUC-610 | EDUC-6100
EDUC-632 | EDUC-6320
EDUC-640 | EDUC-6400
EDUC-642 | EDUC-6422
EDUC-643 | EDUC-6423
EDUC-650 | EDUC-6501
EDUC-700 | EDUC-7200
EDUC-710 | EDUC-7210
EDUC-721 | EDUC-7212
EDUC-732 | EDUC-7732
EDUC-739 | [NAME]
EDUC-800 | EDUC-8105
EDUC-805 | [NAME]
EDUC-811 | EDUC-8114
EDUC-815 | EDUC-8115
EDUC-818 | EDUC-8180
EDUC-823 | EDUC-8233
EDUC-824 | EDUC-8244
EDUC-825 | EDUC-8257
EDUC-831 | EDUC-8310
EDUC-833 | EDUC-8330
EDUC-846 | EDUC-8463
EDUC-868 | EDUC-8999
EDUC-869 | EDUC-8701
EDUC-870 | EDUC-8702
EDUC-890 | EDUC-8991
EDUC-891 | EDUC-8992
Spreadsheet: louise_kitchen__23960__marginValue
Sheet: Sheet1

FUTURES MARGIN REQUIREMENTS
2001-10-30 00:00:00
2001-10-29 00:00:00
 | US $$$ |  |  |  |  |  |  | CANADIAN $$$
Broker | OTE | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin | Line of Credit Covering Realized/Unrealized Gains & Losses |  | OTE | Initial Margin
ABN-Amro Inc | 196116 | 0 | 541200 |  | 541200 | 0 |  |  |  | 0 |  | 4156650
ADM INVESTOR | 316250 | 0 | 0 |  | 0
BANK ONE | 0 | 0 | 0 |  | 0
CARR FUTURES (NG) | 0 | 0 | 0 |  | 0
CARR FUTURES INC. | -332327.9937999998 | 0 | 1905767.27 |  | 1905767.27
CREDIT SUISSE FIRST BOSTON | -464710.82 | 0 | 1027951 |  | 1027951
EDF MAN   (see note below) | -36532400.5 | -32837071 | 28750721 | 25000000 | 3750721 | 0
FIMAT * | 36082986 | 0 | 9423683 | 0 | 9423683 | 0
HSBC - US$ | -3078187.5 | 0 | 379061 |  | 379061
HSBC - Canadian |  | 0 |  |  | 0 |  |  | -53690 | 402320
JP Morgan | 530592.41 | 0 | 436520 |  | 436520
[NAME] | 0 | 0 | 0 |  | 0
PARIBAS | 100216202.2 | 0 | 37707045 | 37707045 | 0 | 0
PRUDENTIAL SI | 210796.7 | 0 | 316470 |  | 316470
REFCO, INC | 0 | 0 | 0 |  | 0
R J O'BRIEN | -5731 | 0 | 91000 |  | 91000
SAUL STONE & COMPANY | 79794 | 0 | 117000 |  | 117000
SMITH BARNEY, INC ** | 4503644.6 | 0 | 5979859 | 5979859 | 0 | 0
SMITH BARNEY, INC ** (Financial) | -87000 | 0 | 86400 |  | 86400
TOTAL EXCLUDING MID-DAY CALLS | 101636024.0962 | -32837071 | 86762677.27 | 68686904 | 18075773.27 | 0 |  | -53690 | 402320
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 101636024.0962
** Smith Barney Initial Margin does not include Delivery Margin of |  |  |  | 0
Credit Lines: | Line | Used Line | Unused Line
Smith Barnery | 50000000 | 5979859 | 44020141
Paribas | 75000000 | 37707045 | 37292955
EDF | 25000000 | 25000000 | 0
Fimat | 20000000 |  | 20000000
 | 170000000 | 68686904 | 101313096
Note:  EDF Man - Positive Net Option value is collateral for futures requirement.
Initial Margin |  |  | 28750721
Option value used to cover Margin |  |  | 0
Initial Margin less positive option value |  |  | 28750721
[NAME] of Credit Analysis:
Initial Margin |  |  | 28750721
OTE |  |  | 20000000 | (limit 20,000,000)
Net Option Value |  |  | 32837071
Line of Credit Balance |  |  | 25000000 | (limit 50,000,000)
Paribas Line of Credit Limit is $75,000,000
* Fimat includes Variation Margin in Initial Margin facility amount unless total trade equity is negative.
Spreadsheet: 277946d1384478659-trying-to-copy-master-data-sheet-rows-if-criteria-exists-to-a-new-sheet-277939d1384472308-trying-to-copy-master-data-sheet-rows-if-criteria-exists-to-a-new-sheet-11-13
Sheet: Ted L follow Up

[NAME]
Job Name | Customer | Job Location | Date In | Due Date | Time | Prints DL | Days to Bid | Quote Number | [NAME] | Memo | Status | Reject Critiera | Commercial Door | Framing | Truss Systems | Floor System | Millwork | [NAME] | Windows | Other | Installed Sales | Wall Panels | Roofing | Siding | Quote $ Submitted | Comments | Commercial Door | Framing | Roof  System | Floor System | Millwork | [NAME] | Windows | Other | Installed Sales | Wall Panels | Roofing
Spreadsheet: 468866d1467640836-how-to-use-large-formula-with-multiple-arrays-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Item 1 |  | Item 2 |  | Item 3 (only tier 3 or 5)
 |  | LEVEL | TIER 1 | TIER 2 | TIER 3 | TIER 4 | TIER 5 |  |  |  | Tier | Rank | Tier | Rank | Tier | Rank
 |  | 1 | 1 | 0 | 2 | 1 | 0 |  |  |  | TIER 1 |  | TIER 4 |  | TIER 3
 |  | 2 | 2 | 2 | 3 | 0
 |  | 3 | 1 | 0 | 6 | 0 | 1
 |  | 4 | 3 | 3 | 0 | 3 | 0
 |  | 5 | 5 | 0 | 7 | 8 | 1
Spreadsheet: 121612d1316194130-returning-a-figure-if-the-destination-cell-fits-a-critera-budget-template-sample
Sheet: Sheet3

Weekly |  |  | Yes
Monthly |  |  | No
Fortnightly
Quarterly
Car Rego
Clothes
Entertainment
Fines
Bank Fees/Charges
Food
Licensing
Mechanical
Other
Petrol
Presents
Stationary
Tools/Hardware
Tyres
Vet
Cheque 123456
Bills 111111
other 121212
Spreadsheet: 481696d1474603640-match-dates-and-sum-values-example
Sheet: Master

OVERALL STAFF REQUIREMENTS
 | Venue1 |  | Venue2 |  | Venue…
START DATE | FLT Operators | Crew | FLT Operators | Crew | FLT Operators | Crew
2018-02-27 00:00:00
2018-02-28 00:00:00
2018-03-01 00:00:00
2018-03-02 00:00:00
2018-03-03 00:00:00
2018-03-04 00:00:00
2018-03-05 00:00:00
2018-03-06 00:00:00
2018-03-07 00:00:00
2018-03-08 00:00:00
2018-03-09 00:00:00
2018-03-10 00:00:00
2018-03-11 00:00:00
2018-03-12 00:00:00
2018-03-13 00:00:00
2018-03-14 00:00:00
2018-03-15 00:00:00
2018-03-16 00:00:00
2018-03-17 00:00:00
2018-03-18 00:00:00
2018-03-19 00:00:00
2018-03-20 00:00:00
2018-03-21 00:00:00
2018-03-22 00:00:00
2018-03-23 00:00:00
2018-03-24 00:00:00
2018-03-25 00:00:00
2018-03-26 00:00:00
2018-03-27 00:00:00
2018-03-28 00:00:00
2018-03-29 00:00:00
2018-03-30 00:00:00
2018-03-31 00:00:00
2018-04-01 00:00:00 | "BLANK"
2018-04-02 00:00:00 | "BLANK"
2018-04-03 00:00:00 | "BLANK"
2018-04-04 00:00:00 | "BLANK"
2018-04-05 00:00:00 | "BLANK"
2018-04-06 00:00:00
2018-04-07 00:00:00
2018-04-08 00:00:00
2018-04-09 00:00:00
2018-04-10 00:00:00
2018-04-11 00:00:00
2018-04-12 00:00:00
2018-04-13 00:00:00
2018-04-14 00:00:00
2018-04-15 00:00:00
2018-04-16 00:00:00
2018-04-17 00:00:00
2018-04-18 00:00:00
2018-04-19 00:00:00
2018-04-20 00:00:00
2018-04-21 00:00:00
2018-04-22 00:00:00
2018-04-23 00:00:00
2018-04-24 00:00:00
2018-04-25 00:00:00
2018-04-26 00:00:00
2018-04-27 00:00:00
2018-04-28 00:00:00
2018-04-29 00:00:00
2018-04-30 00:00:00
Spreadsheet: 789576d1659191185-separate-h-m-s-in-a-non-time-formatted-cell-taysue-sample
Sheet: Sheet3

Vehicle | Idle Event Start | Idle Event End | Idle Event Duration | Fuel Used
101-Stakebed-1649 | 2022-06-01 08:34:00 | 2022-06-01 08:40:00 | 6m 12s | 0.11
101-Stakebed-1649 | 2022-06-01 15:06:00 | 2022-06-01 15:09:00 | 2m 43s | 0.02
101-Stakebed-1649 | 2022-06-08 07:45:00 | 2022-06-08 07:56:00 | 11m 41s | 0.16
101-Stakebed-1649 | 2022-06-08 10:32:00 | 2022-06-08 10:41:00 | 9m 9s | 0.18
101-Stakebed-1649 | 2022-06-08 15:25:00 | 2022-06-08 15:29:00 | 4m 22s | 0.03
101-Stakebed-1649 | 2022-06-08 15:31:00 | 2022-06-08 15:33:00 | 2m 39s | 0.02
101-Stakebed-1649 | 2022-06-09 07:33:00 | 2022-06-09 07:55:00 | 22m 48s | 0.23
101-Stakebed-1649 | 2022-06-09 08:45:00 | 2022-06-09 08:58:00 | 12m 57s | 0.12
101-Stakebed-1649 | 2022-06-09 14:58:00 | 2022-06-09 15:00:00 | 2m 28s | 0.02
101-Pickup-6314 | 2022-06-14 15:07:00 | 2022-06-14 15:58:00 | 51m 9s | 0.15
101-CDL-7391 | 2022-06-30 16:42:00 | 2022-06-30 17:00:00 | 18m 12s | 0.36
Spreadsheet: lisa_gang__22282__ENA_PGE_APRIL_30_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI | EPMI
To: | PGE System Transactions | PGE System Transactions
Date: | 2002-04-30 00:00:00 | 2002-04-30 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  | Total In To PGE Trans
0100 |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0
0700 | 25 | 100 | 25 | 25
0800 | 25 | 100 | 25 | 25
0900 | 25 | 100 | 25 | 25
1000 | 25 | 100 | 25 | 25
1100 | 25 | 100 | 25 | 25
1200 | 25 | 100 | 25 | 25
1300 | 25 | 100 | 25 | 25
1400 | 25 | 100 | 25 | 25
1500 | 25 | 100 | 25 | 25
1600 | 25 | 100 | 25 | 25
1700 | 25 | 100 | 25 | 25
1800 | 25 | 100 | 25 | 25
1900 | 25 | 100 | 25 | 25
2000 | 25 | 100 | 25 | 25
2100 | 25 | 100 | 25 | 25
2200 | 25 | 100 | 25 | 25
2300 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0
 | AVISTA(G)CHELAN | [NAME] | AVISTA(G)CHELAN | EWEB(G)
 | BPA(T)SYS/JD | BCH(T)SYS/BCUS | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AVISTA(PSE) | AVISTA(PSE) | AVISTA(PSE) | AEP
 | EPMI(PSE) | BPA(T)BCUS/[NAME] | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | AVISTA(PSE) | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AVISTA(PSE) | PGE(T)JD/MAL5 | AVISTA(PSE) | AEP
 | PGE | EPMI(PSE) | TEMU | PPM
 | MORGAN | AVISTA(PSE) | SNCL | CDWR
 | APX | PGE | ISO(T)CPJK/SNCL SYS | ISO(T)MALIN/NP15
 | ISO(T)MALIN/NP15 | MORGAN | SNCL(L,FS)SYS | CERS(L,FS) SYS (CA)
 | APX(L,FS)NP15 (CA) | APX
 |  | ISO(T)MALIN/NP15
 |  | APX(L,FS)NP15 (CA)
Spreadsheet: 745675d1630094008-filtered-lookup-with-multi-column-data-return-draftexcelforumhelpnewweeklyphecreadings
Sheet: DropDownLists

Year |  | Week |  | Zone
2020 |  | 1 |  | 1
2021 |  | 2 |  | 2
2022 |  | 3 |  | 3
2023 |  | 4 |  | 4
 |  | 5 |  | 5
 |  | 6 |  | 6
 |  | 7 |  | 7
 |  | 8 |  | 8
 |  | 9 |  | 9
 |  | 10 |  | 10
 |  | 11 |  | 11
 |  | 12 |  | 12
 |  | 13 |  | 13
 |  | 14 |  | 14
 |  | 15 |  | 15
 |  | 16 |  | 20A
 |  | 17 |  | 20B
 |  | 18 |  | 20C
 |  | 19 |  | 20D
 |  | 20 |  | Hoop 1
 |  | 21 |  | Hoop 2
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
 |  | 40
 |  | 41
 |  | 42
 |  | 43
 |  | 44
 |  | 45
 |  | 46
 |  | 47
 |  | 48
 |  | 49
 |  | 50
 |  | 51
 |  | 52
 |  | 53
Spreadsheet: 854231d1704188421-looking-for-a-formula-ifs-with-multi-criteria-sample-sheet
Sheet: Main

SR# | DATE | REFERENCE | Weight
1 |  | x | 0.5
2 |  | x | 2
3 |  | y | 5
4 |  | y | 6
5 |  | x | 12
6 |  | x | 3.5
7 |  | z | 0.5
8 |  | x | 2.5
9 |  | z | 3
10 |  | y | 2.5
11 |  | z | 12
Spreadsheet: 737953d1624701546-picture-display-depending-on-cell-data-issue-sample
Sheet: SEARCH

Material | PART NUMBER | Material Description | [NAME] | Material | PART NUMBER | Unrestricted | Base UOM | Moving price | Price Unit | Total Val | CAG Number | Part Number | Material Description | [NAME] |  |  |  |  |  |  |  | TYPE IN BELOW
[PHONE]-173406 |  | PIN GREEN 0990.H024.007.00 | K6TOP | [PHONE]-173406 |  | 2000 | EA | 751 | 10000 |  | 77264426 |  |  |  |  |  |  |  |  |  | SEARCH | 801-173489
[PHONE]-173489 |  | PLUG WALL RED | A4N05 | [PHONE]-173489 |  | 1390 | EA | 0.01 | 1 |  | 20012970