tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 158664d1338334157-sum-of-range-where-position-changes-nodes
Sheet: Sheet1

node 5 | Sum5 | Sum10 | N_1 | N_2 | N_3 | N_4 | N_5 | N_6 | N_7 | N_8 | N_9 | N_10 | N_11 | N_12 | N_13 | N_14 | N_15 | N_16 | N_17 | N_18 | N_19 | N_20 | N_21 | N_22 | N_23 | N_24 | N_25
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | . | . | . | . | . | . | . | .
4 |  | . | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 1 | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
1 | 8 | . | 0 | 2 | 2 | 2 | 2 | 0 | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
Spreadsheet: debra_perlingiere__8516__Aes NewEnergy
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-10-16 00:00:00 | ENA CONTACT:
COUNTERPARTY: | AES NewEnergy, Inc | CONTACT:
ADDRESS: | 1000 Wilshire Blvd #500 | TITLE:
 | Los Angeles, CA 90017 | PHONE:
 |  | FAX:
INCORPORATION STATE: | ??? | S&P RATING:
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | $1MM | $15MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | AES Corp(BB) | Enron Corp. (BBB+)
LIMIT in $[NAME] | $2MM | $10MM
Incorporation State: | DE | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor | X | X
Debt Ratings Change |  | X
-Below = | BB | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum EBITDA, for trailing 12 months
-Minimum Cash & Cash equivalents
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME]) | $100MM | $300MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:    X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:   X | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | Vanek | x3-1436
Spreadsheet: 850953d1701256052-referencing-2-dynamic-cells-with-indirect-to-separate-sheet-template-tsn-x-sarantis-raport-digital-anual-1-aligw
Sheet: JAN

 |  |  |  |  | Monthly observations:
 | JANUARY |  |  |  | To be filled by Social Media Manager
 | Social Media Manager
 | Date of completion
 | Social Media - Report Builder Data | KPI | Result |  | Social Media - internally managed sources - Always On | Investment | Tracked KPI | Results |  |  | Observations
 |  |  |  |  |  |  |  | Estimated | Obtained
 | Facebook | Fans |  |  | Facebook - Page Management | 1 |  | 55 | 56 |  | Monthly Always On Agency Fee - do not change
 |  | Fan's change |  |  | Facebook - Ads Investment | 2 | Page Likes | 11 | 17
 |  | Interactions |  |  |  | 3 | Reach | 12 | 18
 |  | Page Impressions |  |  |  | 4 | Engagement | 13 | 19
 |  | Last28 Reach |  |  | Instagram - Page Management | 5 |  |  |  |  | Monthly Always On Agency Fee - do not change
 |  | Engagement Rate |  |  | Instagram - Ads Investment | 6 | Engagement | 14 | 20
 |  | No. of Posts |  |  | TikTok - Page Management | 7 |  |  |  |  | Monthly Always On Agency Fee - do not change
 | Instagram | Followers |  |  | TikTok - Ads Investment | 8 | Reach | 15 | 21
 |  | Impressions |  |  |  | 9 | Community Interaction | 16 | 22
 |  | Last28 Reach
 |  | Interactions |  |  | Social Media - internally managed sources - Dedicated Video Views | Investment | Tracked KPI | Results |  |  | Observations
 |  | No. of Posts |  |  |  |  |  | Estimated | Obtained
 |  |  |  |  | Facebook |  | Video Views |  |  |  | [NAME] campaigns for Video Views Objectives - not recurring
 | *input text to GREEN |  |  |  | Instagram |  | Video Views
 | **do NOT change GREY |  |  |  | [NAME] |  | Video Views
 |  |  |  |  | TikTok |  | Video Views
 |  |  |  |  | Social Media - internally managed sources - Dedicated Impressions Campaigns | Investment | Tracked KPI | Results |  |  | Observations
 |  |  |  |  |  |  |  | Estimated | Obtained
 |  |  |  |  | Facebook |  | Video Views |  |  |  | [NAME] campaigns for Impression Objectives - not recurring
 |  |  |  |  | Instagram |  | Video Views
 |  |  |  |  | Social Media - external sources - Influencer Collaborations | Investment | Tracked KPI | Results |  |  | Observations
 |  |  |  |  |  |  |  | Estimated | Obtained
 |  |  |  |  | Facebook |  | Reach |  |  |  | Dedicated budget allocation for influencer collaborations - not recurring. Estimated results are based on average of influencer previous results for similar campaigns.
 |  |  |  |  |  |  | Video Views
 |  |  |  |  | Instagram |  | Reach
 |  |  |  |  |  |  | Video Views
 |  |  |  |  | Other types of media - external sources - Ringier Group actions | Investment | Tracked KPI | Results |  |  | Observations
 |  |  |  |  |  |  |  | Estimated | Obtained
 |  |  |  |  | Ringier Group of Websites |  | Impressions |  |  |  | Dedicated budget allocation for Ringier Group of Websites collaborations - not recurring.
 |  |  |  |  |  |  | Video Views
Spreadsheet: 25180d1216310306-date-to-fill-and-stay-same-also-to-calculate-1-month-generic-invoice-template-auto-date
Sheet: Finance Charge

TMS Draft Ltd. |  |  |  |  | Invoice
 |  |  |  |  | Date: | 2008-07-17 00:00:00
 |  |  |  |  | Invoice #: | 123
 |  |  |  |  | Customer ID:
[NAME] to: | [NAME] |  |  | Ship to: | TMS Draft Ltd
 | Suite 1200, 401 - 9 Avenue SW |  |  |  | 102, 1915 - 26 Street SW
 | Calgary, Alberta T2P 3C5 |  |  |  | Calgary, Alberta T3E 2A2
 | Main: (403) 232-9800 |  |  |  | Main: (403) 441-6166
 |  |  |  |  | Cell: (403) 589-5351
Job |  |  |  |  | Payment Terms
PCOSI Ft. Hills Project - Raw Water Storage & Firewater Pumphouse |  |  |  |  | Due on | 2008-08-16 00:00:00
PCOSI Ft. Hills Project - Oily Water Treatment Facility
Description |  |  |  |  | Total
Invoice Period
February 24 - March 01, 2008 |  |  | Total hours | 0 | 0
March  02 - March 08, 2008 |  |  | Total hours | 0 | 0
March 09 - March 15, 2008 |  |  | Total hours | 0 | 0
March  16 - March 22, 2008 |  |  | Total hours | 0 | 0
March 23 - March 29, 2008 |  |  | Total hours | 0 | 0
Sub Total
Finance charge on overdue balance at 15% per month |  |  | Months over due | 0
(GST Number:  81439 8277 RT0001)             5% GST
 |  | (WCB Number:  530837-5) |  | Total Due
Make all checks payable to TMS Draft Ltd. Thank you for your business!
102, 1915 - 26 Street SW, Calgary, Alberta T3E 2A2, (403) 441-6166, (403) 589-5351, [EMAIL]
Spreadsheet: 767939d1644751241-problem-in-countifs-with-date-field-criteria-trade-log-sample
Sheet: Monthly P&L Summary

Day | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
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
Total
Total Trades
Profit Trades
%
[NAME]
%
[NAME] in Points
[NAME] in Points
Spreadsheet: 116247d1311697612-problem-with-matching-recognizing-specific-data-rows-columns-among-sheets-date-list
Sheet: MONDAY

 |  |  | MONDAY SCHEDULE
AGENT | Boat Details | TIME | T A X I  T R A N S F E R | TOTAL | B O O K I N G | HOLIDAY |  | TAXI ID | NET RATE
 |  |  |  |  |  |  |  | 1 | 50
 |  |  |  |  |  |  |  | 2 | 65
 |  |  |  |  |  |  |  | 3 | 24
 |  |  |  |  |  |  |  | 2 | 40
 |  |  |  |  |  |  |  | 1 | 40
 |  |  |  |  |  |  |  | 2 | 35
 |  |  |  |  |  |  |  | 4 | 65
 |  |  |  |  |  |  |  | 4 | 40
 |  |  |  |  |  |  |  | 3 | 35
 |  |  |  |  |  |  |  | 1 | 24
 |  |  |  |  |  |  |  | 3 | 50
Spreadsheet: 525588d1498788131-list-to-matrix-list-to-matrix-power-query
Sheet: Sheet1

Job Number | Employee | Occurances |  |  | Job Number | Employee 1 | Count 1 | Employee 2 | Count 2 | Employee 3 | Count 3 | Employee 4 | Count 4 | Employee 5 | Count 5
1 | [NAME] | 3 |  |  | 1 | [NAME] | 3 | [NAME] | 4 | [NAME] | 4
1 | [NAME] | 4 |  |  | 2 | [NAME] | 3 | [NAME] | 4 | [NAME] | 9 | [NAME] | 5
1 | [NAME] | 4 |  |  | 3 | [NAME] | 4 | [NAME] | 3 | [NAME] | 1 | [NAME] | 2 | [NAME] | 8
2 | [NAME] | 3 |  |  | 4 | [NAME] | 4 | [NAME] | 6 | [NAME] | 9 | [NAME] | 1
2 | [NAME] | 4 |  |  | 5 | [NAME] | 2 | [NAME] | 4 | [NAME] | 12
2 | [NAME] | 9
2 | [NAME] | 5
3 | [NAME] | 4
3 | [NAME] | 3
3 | [NAME] | 1
3 | [NAME] | 2
3 | [NAME] | 8
4 | [NAME] | 4
4 | [NAME] | 6
4 | [NAME] | 9
4 | [NAME] | 1
5 | [NAME] | 2
5 | [NAME] | 4
5 | [NAME] | 12
Spreadsheet: 108673d1305689995-excel-2007-sumproduct-question-ptsumproduct
Sheet: FEB

Date | ID | Bought | Sold | % Sold
2011-02-01 00:00:00 | 8178541110001 | 65 | 20
2011-02-01 00:00:00 | 3531670110003 | 49 | 40
2011-02-01 00:00:00 | 7855760111824 | 81 | 32
2011-02-01 00:00:00 | 8262480013000 | 41 | 31
2011-02-01 00:00:00 | 8385850010003 | 34 | 25
2011-02-01 00:00:00 | 7009790210003 | 97 | 25
2011-02-01 00:00:00 | 7286200510003 | 55 | 24
2011-02-01 00:00:00 | 9163830010002 | 33 | 21
2011-02-01 00:00:00 | 9989450210000 | 34 | 17
Spreadsheet: hunter_shively__12722__Fundamentals_Netco
Sheet: East - Struct

 | East Power Structuring
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000
 |  |  |  |  |  |  |  |  | Director | 156000 | 1
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 |  |  | 1
 |  |  |  |  |  |  |  |  | VP | 216000
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000
 | Total Headcount
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 205955d1357948919-find-and-input-with-to-criteria-input
Sheet: Sheet1

 | January | February | March | April | May | June | July | August | September | October | November | December
George | 9 | 6 | 60 | 40 | 10 | 90 | 50 | 10 | 20 | 30 | 80 | 40
mik | 40 | 30 | 9 | 50 | 60 | 40 | 60 | 80 | 20 | 7 | 10 | 9
[NAME] | 43 | 13 | 14 | 40 | 10 | 50 | 58 | 10 | 2 | 6 | 60 | 40
[NAME] | 1 | 50 | 8 | 8 | 6 | 3 | 98 | 20 | 50 | 6 | 3 | 20
tonny | 20 | 5 | 5 | 7 | 10 | 90 | 40 | 10 | 14 | 40 | 10 | 1
[NAME] | 0 | 12 | 53 | 20 | 50 | 60 | 40 | 10 | 20 | 50 | 20 | 20
Spreadsheet: 704607d1605638648-sorting-two-columns-into-multiple-columns-example_data
Sheet: Tabelle1

Data the way I have it |  |  | Data the way I want to have it
Hz | Effect |  | Hz
0 | 0.34 |  | 0 | 100 | 200 | 500 | 1000
0 | 0.51 |  | 0.34 | 3.2 | 3.01 | 4.04 | 4.87
100 | 3.2 |  | 0.51 | 3.12 | 3.12 | 4.07 | 4.78
0 | 0.61 |  | 0.61 | 2.98
500 | 4.04 |  | 0.67 | 1.98
100 | 3.12 |  | 0.72
0 | 0.67 |  | 0.13
200 | 3.01
200 | 3.12
100 | 2.98
500 | 4.07
1000 | 4.87
1000 | 4.78
400 | 3.98
0 | 0.72
100 | 1.98
0 | 0.13
400 | 3.78
1000 | 4.79
Spreadsheet: 456141d1460655152-duplicate-result-duplicate-score
Sheet: Sheet2

 | Game 1 | Game 2 | Game 3 | Game 4 | Game 5 | Game 6 |  | ,=INDEX(A$2:A$9,SMALL(INDEX(ROW(A$2:A$9)*($B$2:$G$9=$C$14),0),SUMPRODUCT(--($B$2:$G$9<$C$14))+ROW(A1))-1)
PLAYER 1 | 215 | 212 | 178 | 131 | 156 | 150
PLAYER 2 | 166 | 158 | 166 | 168 | 154 | 163
USER 1 | 144 | 169 | 162 | 191 | 171 | 170
USER 2 | 171 | 170 | 215 | 212 | 135 | 170
PLAYER 3 | 148 | 209 | 161 | 173 | 168 | 183
PLAYER 4 | 198 | 150 | 188 | 200 | 174 | 168
USER 3 | 180 | 149 | 167 | 195 | 215 | 192
USER 4 | 163 | 170 | 181 | 137 | 148 | 160
MIX DOUBLE BOWLING RESULT
HIGHEST PINFALL
PLAYER NAMES
PLAYER NAMES
PLAYER NAMES
 | aggregate | index
Spreadsheet: 217093d1361983734-if-then-vlookup-i-am-confused-test
Sheet: Sheet1

name | variable 1 | variable 2 | variable 3 | variable 4 |  | name | variable 1 | variable 2 | variable 3 | variable 4 |  | name | variable 1 | variable 2 | variable 3 | variable 4
person a | 24 | 56 | 54 | 45 |  | IF person is a,c,d,f, THEN pull all variables associated |  |  |  |  |  | IF variable 1 is >=30 AND variable 2 is <=50 then populate all values associated
person b | 12 | 54 | 34 | 65
person c | 32 | 65 | 23 | 34
person d | 36 | 45 | 43 | 23
person e | 32 | 34 | 23 | 65
person f | 43 | 76 | 54 | 23
person g | 11 | 45 | 23 | 43
Spreadsheet: 788291d1658386936-lookup-multiple-values-and-get-data-in-sort-order-material-master-views
Sheet: Sheet1

Views | Views Description
K | Basic Data
C | Classification
V | Sales
E | Puchasing
D | MRP
P | Forecasting
A | Work Scheduling
F | Production resources/tools
L | Storage
S | Warehouse Management
Q | Quality Management
B | Accounting
G | Costing
X | Plant Stocks
Z | Storage Location Stock
Spreadsheet: 764387d1642704993-matching-values-for-a-data-table-class-a-trench-headwalls
Sheet: Sheet1

Class A Trench Excavation - For Headwalls
ITEM NO
PRELIM QTY.
REMAIN QTY. |  |  |  |  |  |  |  |  |  |  |  | Trench Excavation Per VF (CF)
 |  |  |  |  |  |  |  |  |  |  |  | Pipe Diameter | 1.5:1 Slope | 2:1 Slope
 |  |  |  |  |  |  |  |  |  |  |  | 8" | 21.6 | 27.4
 |  |  |  |  |  |  |  |  |  |  |  | 10" | 23.91 | 30.35
 |  |  |  |  |  |  |  |  |  |  |  | 12" | 26.25 | 33.25
DATE | Location | Pipe Diameter (inches) | Slope | Trench Excavation Depth (VF) | Trench Excavation Quantity (CF/VF) | Volume (CY) |  |  |  |  |  | 15" | 29.75 | 37.63
 |  | 8 | 1.5:1 | 3 |  |  |  |  |  |  |  | 18" | 33.25 | 42
 |  | 10 | 1.5:1 | 3 |  |  |  |  |  |  |  | 21" | 37.35 | 47.25
 |  |  |  |  |  |  |  |  |  |  |  | 24" | 39.38 | 50.75
 |  |  |  |  |  |  |  |  |  |  |  | 30" | 43.75 | 59.5
(These columns are manually entered on a case by case basis)
note:
Cell F13 should = 23.91
Spreadsheet: 60393d1260935293-data-for-last-3-before-blank-attendance-harish
Sheet: Dec '09

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 days | 7 days
Emp No | Employee Name | Dec 1, 2009 | Dec 2, 2009 | Dec 3, 2009 | Dec 4, 2009 | Dec 5, 2009 | Dec 6, 2009 | Dec 7, 2009 | Dec 8, 2009 | Dec 9, 2009 | Dec 10, 2009 | Dec 11, 2009 | Dec 12, 2009 | Dec 13, 2009 | LOP | LOP
29 | AAA | P | OFF | P | P | P | P | OFF | P | P | P | LOP | LOP | LOP | 1 | 0
37 | BBB | P | P | P | LOP | P | OFF | P | LOP | LOP | P | P | LOP | OFF | 0 | 0
30 | CCC | P | OFF | P | P | P | P | LOP | LOP | LOP | OFF | LOP | LOP | LOP | 0 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Points to be noted
 |  |  |  |  |  |  |  |  |  |  |  | a | Inbetween if you have OFF, pls ignore it
 |  |  |  |  |  |  |  |  |  |  |  |  | or
 |  |  |  |  |  |  |  |  |  |  |  | b | count the maximum "P" or maximum character like (LOP (A)", etc
 |  |  |  |  |  |  |  |  |  |  |  | C | This data will be moving or, everyday an new column will be added as the days goes.
Spreadsheet: 874101d1720667171-combine-filter-with-multiple-sort-on-alphabetical-numercial-order-yeti2201-stock-overview-test-sheet
Sheet: Sheet1

10+
10+ |  |  |  | 8+
10+ |  |  |  | 8+
7-10 |  |  |  | 8+
10+ |  |  |  | 8+
10+ |  |  |  | 8+
8+ |  |  |  | 8+
8+ |  |  |  | 8+
8+ |  |  |  | 7-10
8+ |  |  |  | 7-10
8+ |  |  |  | 10+
8+ |  |  |  | 10+
10+ |  |  |  | 10+
10+ |  |  |  | 10+
7-10 |  |  |  | 10+
8+ |  |  |  | 10+
8+ |  |  |  | 10+
10+ |  |  |  | 10+
10+ |  |  |  | 10+
Spreadsheet: 81105d1281372329-if-vlookup-and-linear-interpolation-combined-solveequations
Sheet: Answer Report 1

Microsoft Excel 12.0 Answer Report
Worksheet: [Excel%20Forum%20Question(2).xlsx]Sheet1
Report Created: 09/08/2010 12:08:36
Target Cell (Value Of)
 | Cell | Name | Original Value | Final Value
 | $E$4 | Cat 1 | 0.99 | 0
Adjustable Cells
 | Cell | Name | Original Value | Final Value
 | $E$4 | Cat 1 | 0.99 | 0
 | $E$5 | Cat 1 | 1.05 | 1.05
 | $E$6 | Cat 1 | 1.12 | 1.12
 | $E$7 | Cat 1 | 1.16 | 1.16
 | $E$8 | Cat 1 | 1.19 | 1.19
 | $E$9 | Cat 1 | 1.22 | 1.22
 | $E$10 | Cat 1 | 1.24 | 1.24
 | $E$11 | Cat 1 | 1.25 | 1.25
 | $E$12 | Cat 1 | 1.27 | 1.27
 | $E$13 | Cat 1 | 1.29 | 1.29
 | $E$14 | Cat 1 | 1.31 | 1.31
 | $E$15 | Cat 1 | 1.32 | 1.32
 | $E$16 | Cat 1 | 1.34 | 1.34
 | $E$17 | Cat 1 | 1.35 | 1.35
 | $E$18 | Cat 1 | 1.37 | 1.37
 | $E$19 | Cat 1 | 1.38 | 1.38
Constraints
 | NONE
Spreadsheet: 115884d1311346907-excel-claim-sorting-claims-sorting-1-
Sheet: Sheet1

2007-02-02 00:00:00 | 2008-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2006-02-02 00:00:00 | To | 2007-02-01 00:00:00
Serial | Date | Paid | Oustanding | Total | Title |  |  |  |  |  |  | 2007-02-02 00:00:00 | To | 2008-02-01 00:00:00
2 | 2007-02-04 00:00:00 | 522 | 0 | 522 | PL |  |  |  |  |  |  | 2008-02-02 00:00:00 | To | 2009-02-01 00:00:00
3 | 2007-02-04 00:00:00 | 12132 | 0 | 12132 | MD |  |  |  |  |  |  | 2009-02-02 00:00:00 | To | 2010-02-01 00:00:00
4 | 2007-02-04 00:00:00 | 6545 | 0 | 6545 | TH |  |  |  |  |  |  | 2010-02-02 00:00:00 | To | 2011-02-01 00:00:00
5 | 2007-02-04 00:00:00 | 554 | 4545 | 5099 | MD |  | Note: | Select the date from Cell A1 |  |  |  | 2011-02-02 00:00:00 | To | 2012-02-01 00:00:00
6 | 2007-02-04 00:00:00 | 545 | 44 | 589 | EL |  |  | Copy paste the formula in A3:F3 below
7 | 2007-02-04 00:00:00 | 500 | 454 | 954 | PL |  |  | Hide column M:O
8 | 2007-02-04 00:00:00 | 522 | 5454 | 5976 | EL |  |  | there is similar formula in A3&C3:F3
9 | 2007-02-04 00:00:00 | 12132 | 5454 | 17586 | PL |  |  | There is separate formula in B3
10 | 2007-02-04 00:00:00 | 6545 | 54 | 6599 | PL |  |  | These are array formulas and should be confirmed throgh Ctrl+Shift+Enter
11 | 2007-02-04 00:00:00 | 554 | 454 | 1008 | PL
12 | 2007-02-04 00:00:00 | 545 | 45 | 590 | PL
13 | 2007-02-04 00:00:00 | 500 | 454 | 954 | EL
14 | 2007-02-04 00:00:00 | 522 | 45 | 567 | EL
15 | 2007-02-04 00:00:00 | 12132 | 454 | 12586 | EL
16 | 2007-02-04 00:00:00 | 6545 | 545 | 7090 | EL
17 | 2007-02-04 00:00:00 | 554 | 45 | 599 | MD
18 | 2007-02-04 00:00:00 | 545 | 45 | 590 | MD
19 | 2007-02-04 00:00:00 | 500 | 45 | 545 | MD
20 | 2007-02-04 00:00:00 | 522 | 45 | 567 | MD
21 | 2007-02-04 00:00:00 | 12132 | 45 | 12177 | TH
22 | 2007-02-04 00:00:00 | 6545 | 45 | 6590 | TH
23 | 2007-02-04 00:00:00 | 554 | 45 | 599 | TH
24 | 2007-02-04 00:00:00 | 545 | 45 | 590 | TH
25 | 2007-02-04 00:00:00 | 500 | 45 | 545 | TH
26 | 2007-02-04 00:00:00 | 522 | 4 | 526 | EL
27 | 2007-02-04 00:00:00 | 12132 | 54 | 12186 | EL
28 | 2007-02-04 00:00:00 | 6545 | 5457545 | 5464090 | EL
29 | 2007-02-04 00:00:00 | 554 | 45 | 599 | PL
30 | 2007-02-04 00:00:00 | 545 | 45 | 590 | PL
31 | 2007-02-04 00:00:00 | 545 | 45 | 590 | PL
32 | 2007-02-04 00:00:00 | 121 | 212 | 333 | PL
33 | 2007-02-04 00:00:00 | 212 | 55 | 267 | PL
34 | 2007-02-04 00:00:00 | 55 | 54 | 109 | TH
35 | 2007-02-04 00:00:00 | 4554 | 544 | 5098 | TH
36 | 2007-02-04 00:00:00 | 45 | 545 | 590 | TH
37 | 2007-02-04 00:00:00 | 4545 | 454 | 4999 | EL
38 | 2007-02-04 00:00:00 | 44 | 545 | 589 | EL
39 | 2007-02-04 00:00:00 | 4 | 45 | 49 | MD
40 | 2007-02-04 00:00:00 | 454 | 45 | 499 | MD
41 | 2007-02-04 00:00:00 | 54 | 454421 | 454475 | MD
42 | 2007-02-04 00:00:00 | 54 | 545 | 599 | PL
41 | 2007-02-04 00:00:00 | 54 | 454421 | 454475 | MD
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 39138d1237333030-record-count-meeting-4-criteria-sumproductsuggestion
Sheet: Sheet1

FY | Month | Type | POOM
2009 | March | MOTOR VEHICLE | 0
2008 | October | INDUSTRIAL | 0 |  |  | Records meeting criteria of : | 3
2007 | January | INDUSTRIAL | 0 |  |  | FY | 2009
2005 | October | INDUSTRIAL | 0 |  |  | Month_Desc | March
2006 | October | MOTOR VEHICLE | 7 |  |  | Type_Descript | Industrial
2004 | October | INDUSTRIAL | 6 |  |  | POOM | 0
2009 | March | MOTOR VEHICLE | 0
2007 | October | INDUSTRIAL | 3
2007 | March | MOTOR VEHICLE | 5
2007 | October | INDUSTRIAL | 4 |  |  | (All conditions must be met)
2009 | March | INDUSTRIAL | 0 |  |  | Answer = 3 records
2008 | October | INDUSTRIAL | 1
2009 | March | INDUSTRIAL | 0
2005 | March | INDUSTRIAL | 0
2006 | March | INDUSTRIAL | 0
2009 | March | INDUSTRIAL | 0
Spreadsheet: 72aa711f-9a61-4421-a7b3-7386ad3168dc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
266172 | 9355 | [NAME] | Sinclair | NZL | 435 | 00:12:23 | 00:01:14 | 00:41:32 | 00:01:00 | 00:24:09 | 1 | 01:20:16
266172 | 32446 | Helen | O'Shaughnessy | NZL | 420 | 00:13:10 | 00:01:23 | 00:51:44 | 00:01:04 | 00:26:24 | 2 | 01:33:44
266172 | 65341 | [NAME] | Fuhrer | NZL | 418 | 00:12:39 | [NAME] | 00:50:07 | 00:00:55 | 00:30:43 | 3 | [NAME]
266172 | 34758 | [NAME] | Majors | NZL | 419 | 00:18:05 | 00:01:44 | 00:47:41 | 00:01:24 | 00:28:47 | 4 | [NAME]
Spreadsheet: benjamin_rogers__1201__3rd Party Retail Shorts version 2
Sheet: Depreciation

DEPRECIATION SCHEDULE
('000 $)
US FEDERAL TAX DEPRECIATION & AMORTIZATION
 | Years
Plant & Equipment - MACRS |  |  | 0.05 | 0.095 | 0.0855 | 0.077 | 0.0693 | 0.0623 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0295 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Start-Up Costs - SL |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Transaction Costs - SL
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Total Beginning Book Value
Ending Value of Assets
STATE TAX DEPRECIATION & AMORTIZATION
 | Years
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Total Beginning Book Value
Ending Value of Assets
BOOK DEPRECIATION & AMORTIZATION
 | Years | Residual
Plant & Equipment - SL
Start-Up Costs - SL
Transaction Costs - SL
Plant & Equipment - MACRS
Start-Up Costs - SL
Transaction Costs - SL
Total Beginning Book Value
Ending Book Value of Assets
Spreadsheet: 812993d1673486551-formula-to-calculate-based-on-count-and-date-in-column-header-excelforum
Sheet: DataFile

Region | Product | Units | Date
North | Apples | 1 | 2021-09-07 00:00:00
South | Apples | 1 | 2022-10-07 00:00:00
East | Apples | 1 | 2023-10-17 00:00:00
West | Apples | 1 | 2023-11-15 00:00:00
North | Apples | 1 | 2023-11-15 00:00:00
South | Apples | 1 | 2023-09-21 00:00:00
East | Apples | 4 | 2023-08-22 00:00:00
West | Apples | 1 | 2023-01-07 00:00:00
North | Apples | 5 | 2023-06-28 00:00:00
South | Apples | 1 | 2023-05-25 00:00:00
East | Apples | 1 | 2023-09-21 00:00:00
West | Apples | 2 | 2027-09-22 00:00:00