tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 174330d1345025332-vlookup-with-drop-down-functionality-vlookup-with-a-drop-down-menu
Sheet: Result

Year To Date -> | 2011 | Feb | 2012 | Apr |  |  |  |  |  |  |  | 2011 | Jan
PRODUCTS | Actual Units | Actual Value | Plan Units | Plan Value |  |  |  |  |  |  |  | 2012 | Feb
Product A | 20 | 235 | 40 | 700 |  |  |  |  |  |  |  | 2013 | Mar
Product B | 55 | 5647 | 10 | 800 |  |  |  |  |  |  |  |  | Apr
Product C | 44 | 4567 | 25 | 567 |  |  |  |  |  |  |  |  | May
Product D | 23 | 4569 | 26 | 465 |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  | Dec
1,  Need to put a drop down menu that will give me monthly year to date figures eg- February YTD, March YTD. Which will automatically update figures
2, To do a V LookUP
Spreadsheet: 853823d1703786087-lookup-text-with-delimiter-abc
Sheet: Table

 | Group | V2 FORM - Review & Approve
 | Name |  |  | Company | Job title
Spreadsheet: 878749d1726035258-referencing-multiple-sheet-inorder-to-create-pt-ekac-pl2-spill-indirect-365-aligw
Sheet: Result

Sheet Name > | [NAME]
Subject > | Science
Above amount > | 1000
 | Step 1 |  |  |  | Step 2 |  | Step 3
 |  |  |  |  | Adding unique |  | filtering >1000 based on Name
 |  |  | >>>>> | Name | Marks | >>>>> | Name | ID | Marks
 |  |  |  | Shweta |  |  | Shweta | 74
 |  |  |  | Check | 192
Spreadsheet: 862885d1710450478-function-to-find-value-if-index-row-overlaps-formula-to-find-new-values
Sheet: Sheet1

Index | 1 | 2 | 3 | 4 | 5 | 6 | Total
A | 0 | 100 | 100 | 300 | 500 | 0
B | 0 | 100 | 100 | 100 | 100 | 100
C | 200 | 200 | 200 | 0 | 0 | 0
Spreadsheet: 107206d1304427166-merging-and-matching-colums-copy-of-help2
Sheet: Sheet1

Data |  |  |  |  |  |  |  |  |  | Values
Stock 2011 | Qty 2011 | Stock 2010 | Qty 2010 |  |  |  |  |  | Row Labels | Sum of Qty 2010 | Sum of Qty 2011
BRO20025 | 300 | BRO20025 |  |  |  |  |  |  | BRO20025 | 1 | 300
BRO20027 | 301 | BRO20026 |  |  |  |  |  |  | BRO20026 | 2
BRO20035 | 302 | BRO20028 |  |  |  |  |  |  | BRO20027 |  | 301
BRO20039 | 303 | BRO20035 |  |  |  |  |  |  | BRO20028 | 3
BROMK231 | 304 | BRO20039 |  |  |  |  |  |  | BRO20035 | 4 | 302
BROTZ222 | 309 | BROTZ231 |  |  |  |  |  |  | BRO20039 | 5 | 303
BROTZ231 | 310 | BROTZ222 |  |  |  |  |  |  | BRO9386 | 12
BROTZ232 | 311 | BRO9386 |  |  |  |  |  |  | BROMK231 |  | 304
BROTZ241 | 312 | BROTZ241 |  |  |  |  |  |  | BROTZ222 | 11 | 309
BRO20025 |  |  | 1 |  |  |  |  |  | BROTZ231 | 10 | 310
BRO20026 |  |  | 2 |  |  |  |  |  | BROTZ232 |  | 311
BRO20028 |  |  | 3 |  |  |  |  |  | BROTZ241 | 13 | 312
BRO20035 |  |  | 4 |  |  |  |  |  | Grand Total | 61 | 2752
BRO20039 |  |  | 5
BROTZ231 |  |  | 10
BROTZ222 |  |  | 11
BRO9386 |  |  | 12
BROTZ241 |  |  | 13
End Result
 | Qty 2010 | Qty 2011
BRO20025 | 300
BRO20025 |  | 1
BRO20026 | 301 | 2
BRO20027 | 301
BRO20028 |  | 3
BRO20035 | 302 | 4
BRO20039 | 303 | 5
BRO9386 |  | 12
BROMK231 | 304
BROTZ222 | 309 | 11
BROTZ231 | 310 | 10
BROTZ232 | 311
BROTZ241 | 312 | 13
Spreadsheet: benjamin_rogers__1259__merchant peaker plants version4
Sheet: ENA Comps

 |  | [NAME]
 |  |  |  |  |  |  |  |  |  | ENA | CSFB
 |  | Company | Location | Source | Turbine Type | Article Date | Operation Date | MW's | Cost ($ [NAME]) | Cost/kW | Cost/kW
 | 1 | Dynergy | Lake Charles | Co. Press Release | GE 7FA | 1999-07-23 00:00:00 | 2000-06-01 00:00:00 | 155 | 50 |  | 322
 |  | Tenaska | Georgia | Co. Press Release | GE 7FA | 1999-11-11 00:00:00 | 2001-06-01 00:00:00 | 936 | 410 |  | 354.84
 |  | Entergy | Miss. | Co. Press Release | GE 7EA | 2000-02-24 00:00:00 | 2001-06-01 00:00:00 | 300 | 140 |  | 466.67
 |  | Southwestern Elec. Coop. | Illinois | Megawatt Daily | GE LM 6000 | 1999-12-06 00:00:00 | 2001-06-01 00:00:00 | 45 | 25 |  | 555.56
 |  | Hoosier Energy/Williams | Indiana | N/A | GE LM 6000 | N/A | N/A | 170 | 94 |  | N/A
 |  | [NAME] | Texas | Co. Press Release | GE LM 6000 | N/A | 2001-06-01 00:00:00 | 178 | 93.2 |  | N/A
 |  | [NAME] | Louisiana | Co. Press Release | 6 LM 6000 & 1 7EA | 2000-05-10 00:00:00 | 2002-06-01 00:00:00 | 550 | 250 |  | N/A
 |  | DPL | Ohio | Co. Press Release | GE Gas Turbines | 2000-08-30 00:00:00 | 1999-06-01 00:00:00 | 250 | 75 |  | N/A
 |  | DPL | Ohio | Co. Press Release | Pratt & Whitney | 2000-01-31 00:00:00 | 2000-06-01 00:00:00 | 225 | 80 |  | 444.44
 |  | DPL | Ohio | Co. Press Release | GE Gas Turbines | 2000-01-10 00:00:00 | 2001-12-01 00:00:00 | 160 | 60 |  | 390.63
 |  | Indeck | Illinois | Co. Press Release | N/A | 2000-05-24 00:00:00 | 2001-06-01 00:00:00 | 700 | 250 |  | 357.14
 |  | Indeck | Illinois | Co. Press Release | N/A | 2000-03-01 00:00:00 | N/A | 300 | 100 |  | 333.33
 |  | Standard Power & Light | Illinois | Generation Week | N/A | 2000-03-01 00:00:00 | N/A | 800 | 380 |  | 475
 |  | PPL Global | Pennsylvania | Electric Power Daily | N/A | 2000-05-26 00:00:00 | 2002-06-01 00:00:00 | 900 | 425 |  | N/A
 | 15 | Constellation | Illinois | Electric Power Daily | N/A | 2000-06-20 00:00:00 | 2001-06-01 00:00:00 | 300 | 130 |  | N/A
 | 16 | TVA | Mississippi | Electric Power Daily | GE Gas Turbines | 2000-06-23 00:00:00 | 2002-06-01 00:00:00 | 340 | 170 |  | N/A
 |  | Average
 |  | Average (w/o GE LM 6000's)
Spreadsheet: 686963d1594892476-get-an-average-but-ignoring-zeros-using-indirect-and-match-help-please
Sheet: Daily Stats

 | Call Centre
Date | Calls Received | Calls Abandon | Percent Abandon | Ave Call Time | Average Waiting Time
2020-07-06 00:00:00 | 703 | 105 |  | 00:03:45 | 00:01:30
 | 486 | 27 |  | 00:04:00 | 00:00:42
 | 497 | 19 |  | 00:03:14 | 00:00:22
 | 463 | 29 |  | 00:03:31 | 00:00:40
 | 445 | 15 |  | 00:03:33 | 00:00:20
 | 665 | 65 |  | 00:03:39 | 00:01:05
 | 597 | 27 |  | 00:03:33 | 00:00:32
 | 503 | 57 |  | 00:04:01 | 00:01:17
Spreadsheet: 328802d1404096884-solved-formula-to-count-date-without-converting-data-to-text-format-analysis-of-trend-by-regions-and-approvers
Sheet: Sheet1

By Region
% Verified / Processed
Region | No. of Branches | No. of Near Miss Detected |  |  | Total Near Missed | 2014
 |  |  |  |  |  | NOA Processed |  |  |  |  |  | NOA Verified |  |  |  |  |  | % Verified / Processed
 |  | 2012 | 2013 | 2014 |  | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun
FT
JM
Perak
PKP
PKT
Sabah
Sarawak
Sel/NS
Total
% Near Missed / Verified
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Text Format
Region | No. of Branches | No. of Near Miss Detected |  |  | Total Near Missed | 2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "DDD-MM" format
 |  |  |  |  |  | NOA Verified |  |  |  |  |  | NOA Near Missed |  |  |  |  |  | % Near Missed / Verified
 |  | 2012 | 2013 | 2014 |  | Jan | Feb | Mar | Apr | May | Jun | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun
FT
JMK
PRK
PKP
PKT
SBH
SWK
SNS
Total
By Approvers
% Verified / Decided
No. | Approver | No. of Near Miss Detected |  |  | Total Near Missed | 2014
 |  |  |  |  |  | NOA Decided |  |  |  |  |  | NOA Verified |  |  |  |  |  | % Verified / Decided
 |  | 2012 | 2013 | 2014 |  | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun
1 | UM
2 | UM
3 | UM
4 | UM
5 | AUM
6 | AUM
7 | AUM
8 | AUM
Total
% Near Missed / Verified
No. | Approver | No. of Near Miss Detected |  |  | Total Near Missed | 2014
 |  |  |  |  |  | NOA Verified |  |  |  |  |  | NOA Near Missed |  |  |  |  |  | % Near Missed / Verified
 |  | 2012 | 2013 | 2014 |  | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun
1 | UM
2 | UM
3 | UM
4 | UM
5 | AUM
6 | AUM
7 | AUM
8 | AUM
Total
Spreadsheet: darrell_schoolcraft__7579__0302 Lamar NNG Nomination
Sheet: 03- (9-11)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-03-09 00:00:00
 |  |  |  | Ending Gas Day: | 2002-03-11 00:00:00
 |  | [NAME] |  |  | 35000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 3000
 |  |  | 2000
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 772151d1647021758-tallying-multiple-worksheets-sample
Sheet: TOTALS

Part # | Part | Total required
56-142 | chassis | 410
56-155 | back wall | 460
56-932 | header | 410
56-342 | wheels | 1640
56-159 | front wall | 600
56-146 | chassis a | 399
56-933 | header a | 400
56-346 | wheels locking | 1600
56-778 | graphic panels | 2000
56-876 | shroud | 1000
Spreadsheet: 173339d1344519644-create-numerous-dynamic-range-listexample2
Sheet: Sheet1

List 1 | List 2 | List 3 | List 4 | List 5 | List 6 |  |  | List 1 | List 2 | List 3 | List 4 | List 5 | List 6
Item 1 | Item 1 | Item 1 | Item 1 | Item 1 | Item 1 |  |  | Item 1 | Item 1 | Item 1 | Item 1 | Item 1 | Item 1
Item 2 | Item 2 | Item 2 | Item 2 | Item 2 | Item 2 |  |  | Item 2 | Item 2 | Item 2 | Item 2 | Item 2 | Item 2
Item 3 | Item 3 | Item 3 | Item 3 |  | Item 3 |  |  | Item 3 | Item 3 | Item 3 | Item 3 |  | Item 3
Item 4 | Item 4 | Item 4 | Item 4 |  | Item 4 |  |  | Item 4 | Item 4 | Item 4 | Item 4 |  | Item 4
Item 5 | Item 5 | Item 5 | Item 5 |  | Item 5 |  |  | Item 5 | Item 5 | Item 5 | Item 5 |  | Item 5
Item 6 | Item 6 | Item 6 | Item 6 |  | Item 6 |  |  | Item 6 | Item 6 | Item 6 | Item 6 |  | Item 6
Item 7 | Item 7 | Item 7 | Item 7 |  | Item 7 |  |  | Item 7 | Item 7 | Item 7 | Item 7 |  | Item 7
Item 8 | Item 8 | Item 8 | Item 8 |  | Item 8 |  |  | Item 8 | Item 8 | Item 8 | Item 8 |  | Item 8
Item 9 | Item 9 | Item 9 | Item 9 |  | Item 9 |  |  | Item 9 | Item 9 | Item 9 | Item 9 |  | Item 9 |  | Keep note: I do not want the blank spaces denoted by a red fill to show up on my drop box from these lists.  The main intent here is that there will be ample blank spaces beneath each list to allow another person to come in and add to the list as needed (most users aren't Excel saavy and need a simple way to input new options).
Item 10 | Item 10 |  | Item 10 |  | Item 10 |  |  | Item 10 | Item 10 |  | Item 10 |  | Item 10
Item 11 | Item 11 |  | Item 11 |  | Item 11 |  |  | Item 11 | Item 11 |  | Item 11 |  | Item 11
Item 12 | Item 12 |  | Item 12 |  | Item 12 |  |  | Item 12 | Item 12 |  | Item 12 |  | Item 12
Item 13 |  |  | Item 13 |  | Item 13 |  |  | Item 13 |  |  | Item 13 |  | Item 13
Item 14 |  |  | Item 14 |  | Item 14 |  |  | Item 14 |  |  | Item 14 |  | Item 14
Item 15 |  |  |  |  | Item 15 |  |  | Item 15 |  |  |  |  | Item 15
Item 16 |  |  |  |  | Item 16 |  |  | Item 16 |  |  |  |  | Item 16
Item 17 |  |  |  |  | Item 17 |  |  | Item 17 |  |  |  |  | Item 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Just to example's-sake, let's pretend the yellow cells will be used for drop down boxes (column-respective).  Each drop down box will have its respective list contained within it, but will not have the blank spaces at the end.
Spreadsheet: f0550fcc-38ab-42ef-86b6-5e5c478e0617
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2113 | 5427 | Deniz | Dimaki | GRE | 0 | 00:25:57 | 00:00:43 | 01:10:55 | 00:00:43 | 00:38:14 | 1 | 02:16:33
2113 | 6332 | [NAME] | Ignat | [NAME] | 74 | 00:25:49 | 00:00:38 | 01:13:03 | [NAME] | 00:45:39 | 2 | [NAME]
2113 | 7932 | Niyazi | Ugur | TUR | 70 | 00:30:07 | 00:01:08 | 01:18:20 | 00:02:56 | 00:44:45 | 3 | 02:37:16
2113 | 7933 | [NAME] | Kourti | GRE | 75 | 00:25:50 | 00:00:41 | 01:20:59 | 00:03:00 | 00:46:55 | 4 | 02:37:25
2113 | 7934 | Maria | Tzini | GRE | 80 | 00:32:57 | [NAME] | 01:16:01 | 00:03:10 | 00:44:24 | 5 | 02:38:15
2113 | 7942 | Ipek | Onaran | TUR | 81 | 00:31:29 | 00:00:56 | 01:23:55 | 00:02:57 | 00:44:35 | 6 | 02:43:52
Spreadsheet: 815976d1675290710-lookup-function-trial
Sheet: Sheet1

 |  |  | Predicted Collection Time
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 162338d1339801572-no-idea-how-to-title-this-some-sort-of-referencing-trucking-master-1-
Sheet: Sheet2

 |  |  | Hours |  |  |  | Loads
 | TRUCK # | DRIVER NAME | TOTAL | STNDBY | RGLR | HOURLY RATE | MILLING | HOTMIX | TONS | [NAME] LOAD | AVRG LOADS HOUR | COST PER TON | COST PER LOAD | TOTAL
 |  |  |  | 2 | 1 | 70
JMT6618 | 231 J&M | ISHMEAL
JMT2644 | 232 J&M | ALFREDO
JMT0941 | 276 J&M | ALVARO
JMT8413 | 277 J&M | MUNDO
[NAME] | 11 SORIANO'S | [NAME]
DAILY TOTALS
AVERAGES
MILLING LOADS | HOTMIX [NAME] | TOTAL [NAME] | TOTAL TONS | TOTAL PAY | COST PER LOAD | COST PER TON | AVERAGE TONS PERLOAD | AVERAGE LOADS PER HOUR
Spreadsheet: 156420d1337282436-excel-2007-need-a-drop-down-bar-to-pick-from-blue
Sheet: Sheet1

2012 [NAME] |  |  |  |  | Tavolacci
 |  |  |  |  | Crossroads
 |  |  |  |  | [NAME]
 |  |  |  |  | PFI Receiving
Date | Time | Truck Load # | Receiving Station | Paper Load # | Receiver # | Grower # | [NAME] | State | Variety | Brand | # of Pallets | # of Lugs | Weight | Room | Avg. [NAME].
 |  |  |  |  |  |  |  |  | star
 |  |  |  |  |  |  |  |  | rebel
 |  |  |  |  |  |  |  |  | rabbit eye
 |  |  |  |  |  |  |  |  | utilities
Spreadsheet: 5f836fbd-6596-4375-a36d-049b3441f3f1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  |  |  | COURSE SCHEDULE*
 |  |  |  |  | FIN 357 (03395), FALL 2012
CLASS | DATE |  | CHAPTER | Event Due |  | ASSIGNMENT/TOPIC TO BE COVERED IN CLASS
1 | 2012-08-30 00:00:00 | TH | 1 |  | Course Introduction and Calculator Overview
2 | 2012-09-04 00:00:00 | T | 2 |  | Financial Institutions and Indirect Financing |  |  |  | (Sections 1-3 and 5)
3 | 2012-09-06 00:00:00 | TH | 6 |  | Discounted Cash flow and Valuation
4 | 2012-09-11 00:00:00 | T | 6 | HW1 | Discounted Cash flow and Valuation
5 | 2012-09-13 00:00:00 | TH | 7 |  | Risk and Return
6 | 2012-09-18 00:00:00 | T | 7 |  | Risk and Return continued
7 | 2012-09-20 00:00:00 | TH | 8 | Quiz 1 | Bond Valuation and the Sturcture of Interest Rates
8 | 2012-09-25 00:00:00 | T | 8 |  | Bond Valuation and the Sturcture of Interest Rates
9 | 2012-09-27 00:00:00 | TH | 9 | HW2 | Stock Valuation and Chapter 2 Section 5
10 | 2012-10-02 00:00:00 | T | 9 |  | Stock Valuation and Chapter 2 Section 5
11 | 2012-10-04 00:00:00 | TH |  | Exam I | Optional review |  | Exam I,  6:00-8:30 pm, Location TBA
12 | 2012-10-09 00:00:00 | T | 10 |  | Fundamentals of Capital Budgeting
13 | 2012-10-11 00:00:00 | TH | 10 |  | Fundamentals of Capital Budgeting
14 | 2012-10-16 00:00:00 | T | 11 |  | Cash Flows and Capital Budgeting
15 | 2012-10-18 00:00:00 | TH | 11 | HW 3 | Cash Flows and Capital Budgeting
16 | 2012-10-23 00:00:00 | T | 12 |  | Evaluating Project Economics and Capital Rationing
17 | 2012-10-25 00:00:00 | TH | 12 | Quiz 2 | Evaluating Project Economics and Capital Rationing
18 | 2012-10-30 00:00:00 | T | 13 |  | Cost of Capital
19 | 2012-11-01 00:00:00 | TH | 13 | HW 4 | Cost of Capital
20 | 2012-11-06 00:00:00 | T |  | Exam II | Optional review |  | Exam Ii,  6:00-8:30 pm, Location TBA
21 | 2012-11-08 00:00:00 | TH | 15 |  | How Firms Raise Capital
22 | 2012-11-13 00:00:00 | T | 16 |  | Capital Sturcture Policy
23 | 2012-11-15 00:00:00 | TH | 16 | HW 5 | Capital Sturcture Policy
24 | 2012-11-20 00:00:00 | T | 18 |  | Business Formation,Valuation, and Financial Planning
 | 2012-11-22 00:00:00 | TH |  |  | Happy Thanksgiving
25 | 2012-11-27 00:00:00 | T | 18 | HW 6 | Business Formation,Valuation, and Financial Planning
26 | 2012-11-29 00:00:00 | TH | 17 | Quiz 3 | Dividend Policy
27 | 2012-12-04 00:00:00 | T | 20 |  | Options and Corporate Finance: Basic Concepts
28 | 2012-12-06 00:00:00 | TH |  | Exam III | Exam III, 6:00-8:30 pm, Location TBA
 | * I reserve the right to make adjustments to the lecture schedule to best serve the interest of the class.
 |  |  | [NAME] and exam dates will not change.
Spreadsheet: holden_salisbury__12296__$ Calculator
Sheet: Bal of Month

Balance of Month   (25 MW Block) |  |  |  |  |  |  |  |  | Balance of Month   (25 MW Block)
 |  |  | Days |  | Price |  |  |  |  |  |  | Days |  | Price
 |  | Buy | 9 | at | 215 |  |  |  |  |  | Buy | 1 | at | 100
 | and |  |  |  |  |  |  |  |  | and
 |  | Sell | 3 | at | 190 |  |  |  |  |  | Sell | 19 | at | 47
To Breakeven : |  |  |  | at |  |  |  |  | To Breakeven : |  |  |  | at
To Show Profit : |  |  |  | at | 65 |  |  |  | To Show Profit : |  |  |  | at | 45.5
 |  | = |  |  |  |  |  |  |  |  | =
Balance of Month   (25 MW Block)
 |  |  | Days |  | Price
 |  | Buy | 20 | at | 33.75
 | and
 |  | Sell | 2 | at | 20
To Breakeven : |  |  |  | at
To Show Profit : |  |  |  | at | 33
 |  | =
Spreadsheet: 754780d1636494961-calculating-8-threads-cash-flow-template-r1
Sheet: Cash Flow - Internal Actual

 | From Budget Excel - Can be Cost Phases or Owner SOV | From Budget Excel | Progress Monthly amounts through schedule review - Update Monthly
 |  |  | 2020 | 2020 | 2020 | 2020 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022 | 2022
Phase | Description | Budget | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | Total | Difference
E0020 |  | 13694
E0030 |  | 23890
E0121 |  | 100000
E0130 |  | 12000
[NAME] |  | 92000
E0133 |  | 13080
E0149 |  | 9967
E0151.01 |  | 1500
E0151.02 |  | 6000
E0152 |  | 16000
E0153 |  | 2000
E0156 |  | 500
ADMTEL.01 |  | 2400
ADMTI.01
E0162 |  | 5000
E0164 |  | 6000
[NAME] |  | 10000
E0170 |  | 3231
E0189 |  | 12000
[NAME] |  | 10000
E0195 |  | 2500
E0221 |  | 5000
E0310 |  | 147620
E0315 |  | 19321
E0320 |  | 63014
E0330 |  | 75302
E0335 |  | 9600
E0405 |  | 150220
E0550 |  | 8000
E0610 |  | 70462
E0640 |  | 4650
E0729 |  | 10600
E0736 |  | 17896
E0751 |  | 1379
E0792 |  | 900
E0810 |  | 15995
E0850 |  | 300
E0920 |  | 10500
E0962 |  | 1863
E0991 |  | 6250
E1044 |  | 1800
E1090 |  | 700
E2201 |  | 711600
E2205.01 |  | 343016
E2605.01 |  | 294708
E3105 |  | 644765
E3231
9700
COVID19 |  | 8642.630000000001
AC2001 |  | 10056
AC2004 |  | 4250
AC0005 |  | 12362.91
AC0006 |  | 12100
AC0007 |  | 3602.5
AC0008 |  | -5965.429999999999
AC0009 |  | 650
AC0011 |  | 6320
AC0015 |  | 19463.43
AC0016 |  | 1958.25
AC0017 |  | 72965.52
AC0020 |  | 1634.85
AC0021 |  | 0
AC0022 |  | -2850
AC0023 |  | 29267.7
AC2002 |  | 5500
AC2003 |  | 26957.98
AC2009 |  | 350
AC2011 |  | 17251.58
AC2012 |  | 560
AC2014 |  | 1080
AC2035 |  | 804.72
AC3015 |  | 11032.38
AC3032 |  | 1252.78
AC5001 |  | -500
AC5010 |  | -1000
AC5017 |  | 2187.5
AC5018 |  | 15560
AC5028 |  | 1700
 |  | 0
 |  | 0
 |  | Actual Monthly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <---Updated Automatically
 |  | Actual Cummulative
 |  | Plan Monthly | 193640.425 | 156385.625 | 239176.425 | 268033.225 | 434783.4 | 326833.1 | 294451.1 | 645287.1 | 398632.6
 |  | Plan Cummulative
 |  | Difference
 |  | Forecast %
Spreadsheet: 716792d1612366712-sumif-across-multiple-sheets-test
Sheet: 2021-MOC-Bend 24 Jan

Qty | Product | Type |  | Amount
2 | [NAME] | Case
1 | Apple Butter Spread | Case
1 | [NAME] | Case
 |  | Subtotal
 |  | [NAME] 15%
 |  | tax |  | n/a
Spreadsheet: 271914d1382107752-sum-values-from-different-sheets-to-summary-sheet-sum-values
Sheet: Summary

Our Global Company
[NAME], Previous Fiscal Year
Data Consolidation
Sales Group: |  | Consulting: | Marketing: | Outsourcing: | Bundling:
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Northeast
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Southeast
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Northwest
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Southwest
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
TOTAL
Total Revenue:
1. I want to sum the qtr1+qtr2+qtr3+qtr4 in cell b5 in summary sheet.
2. If I drag down the formula to right & down it should give me the correct sum result.
By [NAME]
Sales Group: | Consulting: | Marketing: | Outsourcing: | Bundling:
Northeast
Southeast
Northwest
Southwest
TOTAL
Total Revenue:
Spreadsheet: 63209d1264131656-alternative-to-sumif-sumif
Sheet: Sheet1

 | Name | Total # of Minutes
 | [NAME] | 02:45:00
 | [NAME] | 03:26:00
 | Sandro | 01:20:00
 | Glenda | 1900-01-01 00:00:00
 | Audi
 | [NAME]
 | Gio
 | Sandy
 | [NAME]
 | Alvin
 | Alvin
 | [NAME]
 | Xavier
 | [NAME]
 | Ororo
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Sanji
 | Name |  | # of Minutes
 | [NAME] |  | 00:30:00
 | [NAME] |  | 00:45:00
 | Sandro |  | 00:15:00
 | [NAME] |  | 00:05:00
 | [NAME] |  | 00:25:00
 | Sandro |  | 00:40:00
 | [NAME] |  | 00:10:00
 | [NAME] |  | 00:10:00
 | Sandro |  | 00:10:00
 | [NAME] |  | 00:15:00
 | [NAME] |  | 00:20:00
 | Sandro |  | 00:05:00
 | Sandro |  | 00:10:00
 | [NAME] |  | 00:24:00
 | [NAME] |  | 00:52:00
 | [NAME] |  | 00:25:00
 | [NAME] |  | 00:05:00
 | [NAME] |  | 00:30:00
 | [NAME] |  | 00:15:00
 | [NAME] |  | 00:35:00
 | [NAME] |  | 00:25:00
 | Glenda |  | 1900-01-01 00:00:00
 | Audi |  | 01:00:00
 | [NAME] |  | 04:15:00
 | Gio |  | 00:50:00
 | Sandy |  | 00:10:00
 | [NAME] |  | 00:10:00
 | Alvin |  | 1900-01-01 00:00:00
 | Alvin |  | 00:23:00
 | [NAME] |  | 01:02:00
 | Xavier |  | 01:00:00
 | [NAME] |  | 00:05:00
 | Ororo |  | 02:52:00
 | [NAME] |  | 00:55:00
 | [NAME] |  | 00:05:00
 | [NAME] |  | 00:35:00
 | [NAME] |  | 1900-01-01 00:00:00
 | [NAME] |  | 01:30:00
 | Sanji |  | 00:50:00
Spreadsheet: 270517d1381511365-reduce-the-number-of-entries-in-an-array-2013-10-11-arraylengthreductionexample
Sheet: duffry

a | 2013-05-01 00:00:00
a | 2013-04-01 00:00:00
a | 2013-05-01 00:00:00
a | 2013-03-01 00:00:00
a | 2013-04-01 00:00:00
a | 2013-04-01 00:00:00
a | 2013-05-01 00:00:00
b | 2013-06-01 00:00:00
 | =MIN(IF(INDEX(($A$1:$A$8="a")*(FREQUENCY($B$1:$B$8,$B$1:$B$8)>=3)*($B$1:$B$8),,1)>0,INDEX(($A$1:$A$8="a")*(FREQUENCY($B$1:$B$8,$B$1:$B$8)>=3)*($B$1:$B$8),,1)))
 | =MIN(IF(INDEX(($A$1:$A$9="a")*(FREQUENCY($B$1:$B$8,$B$1:$B$8)>=3)*($B$1:$B$9),,1)>0,INDEX(($A$1:$A$9="a")*(FREQUENCY($B$1:$B$8,$B$1:$B$8)>=3)*($B$1:$B$9),,1)))
 | =MIN(IF(INDEX(($A$1:$A$9="a")*(LARGE(FREQUENCY($B$1:$B$8,$B$1:$B$8)>=3,ROW(INDIRECT("1:8"))))*($B$1:$B$9),,1)>0,INDEX(($A$1:$A$9="a")*(LARGE(FREQUENCY($B$1:$B$8,$B$1:$B$8)>=3,ROW(INDIRECT("1:8"))))*($B$1:$B$9),,1)))
 | =MIN(IF(B1:B8>0,B1:B8))
Spreadsheet: 876049d1722691861-rent-increase-at-specified-period-book1
Sheet: Data

[NAME] |  | 96
Rental Rate |  | 1000
Lease Date |  | 2023-12-01 00:00:00
First Payment  Date |  | 2023-12-01 00:00:00
Rent Increase % |  | 0.1
Increase @ Period No |  | 12
Increase Interval |  | 12
Period No | Month | Rent Increase | expected result
1 | 2023-12-01 00:00:00 |  | 1000
2 | 2024-01-01 00:00:00 |  | 1000
1 | 2024-02-01 00:00:00 |  | 1000
2 | 2024-03-01 00:00:00 |  | 1000
3 | 2024-04-01 00:00:00 |  | 1000
4 | 2024-05-01 00:00:00 |  | 1000
5 | 2024-06-01 00:00:00 |  | 1000
6 | 2024-07-01 00:00:00 |  | 1000
7 | 2024-08-01 00:00:00 |  | 1000
8 | 2024-09-01 00:00:00 |  | 1000
9 | 2024-10-01 00:00:00 |  | 1000
10 | 2024-11-01 00:00:00 |  | 1000
11 | 2024-12-01 00:00:00 |  | 1000
12 | 2025-01-01 00:00:00 |  | 1100
13 | 2025-02-01 00:00:00 |  | 1100
14 | 2025-03-01 00:00:00 |  | 1100
15 | 2025-04-01 00:00:00 |  | 1100
16 | 2025-05-01 00:00:00 |  | 1100
17 | 2025-06-01 00:00:00 |  | 1100
18 | 2025-07-01 00:00:00 |  | 1100
19 | 2025-08-01 00:00:00 |  | 1100
20 | 2025-09-01 00:00:00 |  | 1211