tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 680432d1591018809-closed-formula-for-stepwise-defined-function-fees
Sheet: Sheet1

 |  |  |  |  | Input Cell
 | Till Value | For each Step of | # of max Steps | Fee per Step | Fee [NAME] acc. | Rem. Value1 | Fee
base/min | 500 |  | 1 | 15
 | 2000 | 500 |  | 4
 | 10000 | 1000 |  | 6
 | 25000 | 3000 |  | 8
 | 50000 | 5000 |  | 10
 | 200000 | 15000 |  | 27
 | 500000 | 30000 |  | 50
 | 5000000 | 50000 |  | 80
 | 10000000 | 200000 |  | 130
 | 20000000 | 250000 |  | 150
 | 30000000 | 500000 |  | 280
= cap | 60000000 | 1000000 |  | 120
 | Total Fee
 | i.e. min fee = 15, [NAME]. fee, even if value >60 Mio. = 26,585 |  |  |  |  |  | Value1 | Fee1
 |  |  |  |  |  | Examples | 3000000 | 4935
 |  |  | [NAME] |  |  |  | 5417845.75 | 8525
 |  |  |  |  |  |  |  | 25985
 |  |  | Example
Spreadsheet: 48a62af8-8831-4bfd-b9b3-2bab16e8f584
Sheet: Sheet1

Unnamed: 0 | Tabhair faoi deara go [NAME] an fhoirm seo á úsáid ag chuile ealaíon: [NAME], seans nach mbeidh gach píosa de feiliúnach duitse | Unnamed: 2
 | Teideal an togra
 | Ainm an Comhlucht / Ealaiontóir
 | Ioncaim | €
 | Comhairle Ealaíon
 | Ioncaim ón oifig ticéad
 | [NAME]
 | [NAME]
 | Díolachán ar chláir
 | Urraíocht
 | Eile
 | Iomlán | 0
 | Caiteachas | €
 | Costais réamh-chamchuairt
 | Pá agus táillí
 | Costais teichniúil agus léiriú
 | Poiblíocht
 | [NAME]
 | Eile
 | Costais chamchuairt
 | Pá agus táillí
 | Liúntais taistil agus chothaithe
 | Costais teichniúil agus léiriú
 | Poiblíocht
 | [NAME]
 | Eile
 | Iomán | 0
 | * Tabhair faoi deara cuir in áireamh ar chostais díreach [NAME]
Spreadsheet: 825551d1681387977-display-cell-value-in-table-2-based-on-position-of-minimum-value-in-table-1-example-for-cell-matching
Sheet: Example

 |  | C | F | I | L | O | S | W | AA | AE
Table 1: Modified Data | Parameter | B01 | B02 | B03 | B04 | B05 | B06 | B07 | B08 | B09 |  | Table 3: Min value | Parameter | Min Value | B Ref
 | A01
 | A02
 | A03
 | A04
 | A05
 | A06
 | A07
 | A08
 | A09
 | A10
 | A11
 | A12
 | A13
 | A14
 | A15
 | A16
 | A17
 | A18
 | A19
 | A20
 | A21
 | A22
 | A23
 | A24
Table 2: Original Data | Parameter | B01 | B02 | B03 | B04 | B05 | B06 | B07 | B08 | B09 |  | Table 4: Min value original data | Parameter | Min Value | B Ref
 | A01 |  |  |  |  |  | 10^2
 | A02
 | A03
 | A04
 | A05
 | A06
 | A07
 | A08
 | A09
 | A10
 | A11
 | A12
 | A13
 | A14
 | A15
 | A16
 | A17
 | A18
 | A19
 | A20
 | A21
 | A22
 | A23
 | A24
Spreadsheet: 823934d1680201295-golf-combine-formulas-for-single-vs-team-match-play-sample-match-scores
Sheet: Sheet1

 |  |  |  | Scores | Hole | 1 |  |  |  |  |  |  |  |  | Total
 |  |  |  | Player 1 |  | 7 | 4 | 6 | 3 | 4 | 3 | 5 | 5 | 7
 |  |  |  | Player 2 |  | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 3 | 5
 |  |  |  | Opponent 1 |  | 5 | 4 | 6 | 3 | 3 | 5 | 5 | 4 | 5
 |  |  |  | Opponent 2 |  | 6 | 3 | 4 | 4 | 4 | 6 | 4 | 3 | 6
 |  |  |  | Individual Match Points
 |  |  |  | Player 1 Wins
 |  |  |  | Player 2 Wins
 |  |  |  | Opponent 1
 |  |  |  | Opponent 2
 |  |  |  | Team Match Points
 |  |  |  | Match Team 1
 |  |  |  | Match Opponent 1
 |  | Game Format |  | Team | <-- drop down
 |  |  |  | Player 1
 |  |  |  | Player 2
 |  |  |  | Opponent 1
 |  |  |  | Opponent 2
 |  |  |  | Match Points awarded
 |  |  |  | Player 1
 |  |  |  | Player 2
 |  |  |  | Opponent 1
 |  |  |  | Opponent 2
Spreadsheet: 176687d1346073424-indexing-with-duplicates-issue-department-position-status-working-file
Sheet: HROD

HROD
 | Filled Positions |  |  |  |  |  |  |  |  |  |  |  | Open Positions
 | Title | Location | Category | Hiring Manager | Number of Openings | Number Filled | Date Activated | Date Filled | Start Date | Business Days to Offer | Comments |  |  | Title | Location | Category | Hiring Manager | Created Date | Age | Comments
Spreadsheet: 859128d1707584131-creating-a-schedule-using-the-if-formula-weekly_employee_schedule_template
Sheet: Cashiers Solo

SCHEDULE
NAME: | 1.Chiara
 | Start | Breaks | End | Hours
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
TOTAL HOURS
Spreadsheet: 489216d1479145825-extend-a-nested-if-formula-or-macro-copy-of-example2
Sheet: Sheet1 (2)

 | 1 | .0001 / 100 |  |  | 0 |  |  |  | 0.01 | 0.02 |  | 1 | 0.01 | 0.01 | x2 |  | .0100 x2 | .0100 [NAME] | .0100 x4 | .0100 x5 | .0100 x6 | .0100 x7 | .0100 x8 | .0100 x9 | .0100 x10 | .0100 x12 | .0100 x16 | .0100 MAX | .0100 R | .01 º | [NAME] | 0.0100
 | IF(P1="x2",R1,IF(P1="x3",S1,IF(P1="x4",T1,IF(P1="x5",U1,IF(P1="x6",V1,IF(P1="x7",W1,IF(P1="x8",X1,IF(P1="x9",Y1,""))))))))
 | (IF(P1="x10",Z1,IF(P1="x12",AA1,IF(P1="x16",AB1))))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x2" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  R1
 |  |  |  |  |  |  |  |  |  |  |  | Key | Value
 |  |  |  |  |  |  |  |  |  |  |  | X2 | .0100 x2 |  |  |  | If p1 = "x3" Then
 |  |  |  |  |  |  |  |  |  |  |  | X3 | .0100 [NAME] |  |  |  | XValue =  S1
 |  |  |  |  |  |  |  |  |  |  |  | X4 | .0100 x4
 |  |  |  |  |  |  |  |  |  |  |  | X5 | .0100 x5 |  |  |  | If p1 = "x4" Then
 |  |  |  |  |  |  |  |  |  |  |  | X6 | And so on |  |  |  | XValue =  T1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x5" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  U1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x6" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  V1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x7" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  W1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x8" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  X1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x9" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x10" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  Z1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x12" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  AA1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If p1 = "x16" Then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XValue =  AB1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Else
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do Nothing
Spreadsheet: 792518d1660931062-spill-error-budget-aug-18-1230-2022-
Sheet: accnt relationships

 |  |  | wb-s1
 |  |  |  | account type
 |  |  |  | savings
 |  |  |  | use:
 |  |  |  | property tax escrow
 |  |  |  | input
 |  |  |  | WB-S5
 |  |  |  | Output
 |  |  |  | WB-S8
 |  |  |  | [NAME] manually sent to Town
 |  |  | wb-s4
 |  |  |  | account type:
 |  |  |  | savings | savings
 |  |  |  | use:
 |  |  |  | balance sheet of repayment of Loan I provided [NAME]
 |  |  |  | input:
 |  |  |  | [NAME] initiated and signed RVC check
 |  |  |  | Output:
 |  |  |  | WB-L147
 |  |  |  | other
 |  |  | wb-s5
 |  |  |  | account type:
 |  |  |  | checking
 |  |  |  | use:
 |  |  |  | (1) All revenue funds are deposited here
 |  |  |  |  | social security monthly deposit
 |  |  |  | (2) dispurses revenue to re-occurring monthly expenses
 |  |  |  |  | WB-S8 | [NAME]
 |  |  |  | (3) dispurses revenues to re-occuring monthly Loan accounts
 |  |  |  |  | WB-L141 | visa
 |  |  |  |  | WB-L142 | Over [NAME]
 |  |  |  |  | WB-L148 | Car Loan
 |  |  |  | (4) dispurses the lump sum that covers all non-re-occuring budgeted expenses
 |  |  |  |  | WB-S6 | checks and debit card expenses
 |  |  |  | input:
 |  |  |  | Social Security Monthly Deposit
 |  |  |  | other
 |  |  |  | Output:
 |  |  |  | see above
 |  |  |  | other
 |  |  | wb-s6
 |  |  | account type:
 |  |  |  | checking
 |  |  | use:
 |  |  |  | non-re-occurring budgeted expenses
 |  |  | input:
 |  |  |  | wb-s5 lump sum
 |  |  | output:
 |  |  |  | checks and Debit Card payments
 |  |  | wb-s8
 |  |  | account type:
 |  |  |  | checking
 |  |  | use:
 |  |  |  | Funds from which [NAME] credits in paying checks to vendors
 |  |  | input:
 |  |  |  | wb-s5 lump sum
 |  |  | output:
 |  |  |  | funds supporting checks issued by [NAME]
Spreadsheet: 206736d1358268147-data-check-validation-when-inputting-copy-of-trainer-availabilty
Sheet: Sheet1

 | Trainer | Trainer | Trainer
2013-01-01 00:00:00
2013-01-02 00:00:00
2013-01-03 00:00:00
2013-01-04 00:00:00
2013-01-05 00:00:00
2013-01-06 00:00:00
2013-01-07 00:00:00
2013-01-08 00:00:00
2013-01-09 00:00:00
2013-01-10 00:00:00
2013-01-11 00:00:00
2013-01-12 00:00:00
2013-01-13 00:00:00
2013-01-14 00:00:00
2013-01-15 00:00:00
2013-01-16 00:00:00
2013-01-17 00:00:00
2013-01-18 00:00:00
2013-01-19 00:00:00
2013-01-20 00:00:00
2013-01-21 00:00:00
2013-01-22 00:00:00
2013-01-23 00:00:00
2013-01-24 00:00:00
2013-01-25 00:00:00
2013-01-26 00:00:00
2013-01-27 00:00:00
2013-01-28 00:00:00
2013-01-29 00:00:00
2013-01-30 00:00:00
2013-01-31 00:00:00
Spreadsheet: 480294d1473852897-solved-how-to-copy-a-column-data-in-another-column-ignoring-the-blanks-ignoring_blanks
Sheet: Folha1

875 |  |  |  | a
47
 |  |  |  | c
541 |  |  |  | v
9855 |  |  |  | g
 |  |  |  | h
44
2
 |  |  |  | l
845
54
Spreadsheet: richard_ring__31655__Sample Invoice (10-15-01)
Sheet: Hourly EESI Price Calcs

 | Enron Energy Services Operations, Inc.
 |  |  | BGE Index Product Example Calculations
Maryland Customer
Attn:
 |  | From: | To:
Baltimore, MD |  | 2003-01-01 00:00:00 | 2003-01-31 00:00:00
SITE | Description
 | (A) | (B) | (C) | (D) | (E) | (F) | (G) | (H) | (I) | (J)
 |  | Real-Time BGE LMP |  | Ancillary Services | Installed Capacity | Other ISO Charges | Management Fee | Total EESI Energy Price per kWh | kWh | Market-Priced Commodity Charge
Site 1 | Hour |  | Losses
 |  | ($/kWh) |  | ($/kWh) | ($/kWh) | ($/kWh) |  | (B)*[1+(C)]+(D)+ (E)+(F)+(G) |  | (H) x (I)
 | 1 | 0.031 | 0.045 |  |  | 0.001 | 0.005 |  | 1200
Total
Spreadsheet: 717267d1612547253-alternative-to-trimmean-book2
Sheet: Sheet1

15 |  |  |  | Smallest 3 |  | 5 | 12
5 |  |  |  | Largest 5 |  | 92 | 84 | 83 | 80
63
92
100 |  |  | [NAME]
50 |  |  | Cross-Check
84
40
29
67
72
12
33
68
23
83
64
46
80
4
Spreadsheet: 475060d1471056639-transpose-identified-duplicate-names-to-a-single-row-p99-sample
Sheet: Sheet1

DATE | FIRMS | value |  |  |  |  |  |  |  | DATE | aa | bbbb | [NAME]
2000-07-19 00:00:00 | aa | 112.98 |  |  |  |  |  |  |  | 2000-07-19 00:00:00 | 112.98 | 1430.38 | 405.11
2000-08-19 00:00:00 | aa | 113.39 |  |  |  |  |  |  |  | 2000-08-19 00:00:00 | 113.39 | 1480.42 | 413.5
2000-09-19 00:00:00 | aa | 113.31 |  |  |  |  |  |  |  | 2000-09-19 00:00:00 | 113.31 | 1493.2 | 377.44
2000-10-19 00:00:00 | aa | 113.18 |  |  |  |  |  |  |  | 2000-10-19 00:00:00 | 113.18 | 1446.37 | 212.25
2000-11-19 00:00:00 | aa | 954.35 |  |  |  |  |  |  |  | 2000-11-19 00:00:00 | 954.35 | 1301.2 | 239.99
2000-12-19 00:00:00 | aa | 897.76 |  |  |  |  |  |  |  | 2000-12-19 00:00:00 | 897.76 | 1249.58 | 364.34
. | aa | 939.72 |  |  |  |  |  |  |  | . | 939.72 | 1078.72 | 418.59
. | aa | 1108.41 |  |  |  |  |  |  |  | . | 1108.41 | 1082.35 | 616.33
. | aa | 1218.26 |  |  |  |  |  |  |  | . | 1218.26 | 967.47 | 584.3
2016-07-19 00:00:00 | aa | 1228.84 |  |  |  |  |  |  |  | 2016-07-19 00:00:00 | 1228.84 | 586.19 | 572.17
2000-07-19 00:00:00 | bbbb | 1430.38
2000-08-19 00:00:00 | bbbb | 1480.42
2000-09-19 00:00:00 | bbbb | 1493.2
2000-10-19 00:00:00 | bbbb | 1446.37
2000-11-19 00:00:00 | bbbb | 1301.2
2000-12-19 00:00:00 | bbbb | 1249.58
. | bbbb | 1078.72
. | bbbb | 1082.35
. | bbbb | 967.47
2016-07-19 00:00:00 | bbbb | 586.19
2000-07-19 00:00:00 | [NAME] | 405.11
2000-08-19 00:00:00 | [NAME] | 413.5
2000-09-19 00:00:00 | [NAME] | 377.44
2000-10-19 00:00:00 | [NAME] | 212.25
2000-11-19 00:00:00 | [NAME] | 239.99
2000-12-19 00:00:00 | [NAME] | 364.34
. | [NAME] | 418.59
. | [NAME] | 616.33
. | [NAME] | 584.3
2016-07-19 00:00:00 | [NAME] | 572.17
Spreadsheet: 69682d1270235234-countif-per-id-number-misspucca
Sheet: Blad1

ID | Online/Offline |  | ID | Online | Offline
1 | 0 |  | 1
1 | 0 |  | 2
2 | 0 |  | 3
3 | 0 |  | 4
4 | 0 |  | 5
4 | 0 |  | 6
4 | 0 |  | 7
5 | 0 |  | 8
6 | 0 |  | 9
6 | 0 |  | 10
6 | 1
6 | 0
6 | 0
7 | 0
7 | 0
7 | 0
7 | 0
7 | 0
7 | 0
8 | 0
9 | 0
9 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
10 | 0
Spreadsheet: 794706d1662232047-extract-unique-values-from-multiple-columns-sample
Sheet: Sheet2

 | Result
Spreadsheet: f65ff5bd-ecaf-42e9-9948-2bfa1b047cbf
Sheet: Budget

Attachment C
[Insert Name] Independent School District #[Insert county-district number]
Revenues, [NAME], and Changes in Fund Balance (Actual and Projected)
 | FY 2012 |  |  |  | FY 2013 |  |  |  | FY 2014 | FY 2015
 | Original Budget | Actual | Difference | Explanation | Original Budget | Projected Final Budget | Difference | Explanation | Projected Budget | Projected Budget
Revenues
Tax Collections (Current)
Tax Collections (Delinquent)
Penalties and Interest
Other Local Revenue
State Revenue (Foundation School Funds)
State Revenue (Available School Fund)
State Revenue (Other)
Federal Revenue
Total Revenues
Expenditures
Instructional (F 11, 12, 13)
Instructional Leadership (F 21)
School Leadership (F 23)
Guidance, Social Work, and Health Services (F 31, 32, 33, 34)
Food Services (F 35)
Extracurricular Activities (F 36)
General Administration (F 41)
Facilities Maintenance and Operations (F 51)
Security and Monitoring Services (F 52)
Data Processing Services (F 53)
Community Services (F 61)
Debt Service (F 71)
Facilities Acquisition and Construction (F 81)
Intergovernmental Charges (F 91, 92, 93, 95, 97, 99)
Total Expenditures
Excess (Deficiency) of Revenues Over (Under) Expenditures
Other Sources of Funds (7900)
Long-term debt proceeds
Short-term loan proceeds
Other transfers in
Total Other Sources of Funds
Other Uses of Funds (8900: please list)
[Insert description]
[Insert description]
[Insert description]
Total Other Uses of Funds
Net Change in Fund Balance
Beginning Fund Balance (July 1 or September 1)
Ending Fund Balance (June 30 or August 31)
Spreadsheet: 157074d1337610453-excel-2007-lookup-to-return-multiple-rows-of-data-test-template
Sheet: Job 4

 | # | Date | Description | Requested | Spent
 | 1 | 2012-01-02 00:00:00 | Training | 387.75 | 387.75
 | 1 | 2012-01-03 00:00:00 | Office | 231.41 | 231.41
 | 1 | 2012-01-04 00:00:00 | Misc | 6000 | 6000
 | 1 | 2012-01-05 00:00:00
 | 1 | 2012-01-06 00:00:00
 | 1 | 2012-01-07 00:00:00
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 2 |  | Misc | 832.99 | 832.99
 | 2 | 2011-02-07 00:00:00 | Misc | 1716 | 1716
 | 2 | 2011-02-01 00:00:00 | Misc | 248.04 | 248.04
 | 2 | 2011-02-10 00:00:00 | Misc | 13.22 | 13.22
 | 2 | 2011-01-27 00:00:00 | MIsc | 840 | 840
 | 2 | 2011-02-11 00:00:00 | Misc | 507.5 | 507.5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 3 | 2011-02-24 00:00:00 | Misc | 2.65 | 2.65
 | 3 | 2011-03-04 00:00:00 | Misc | 2.82 | 2.82
 | 3 | 2011-02-28 00:00:00 | Misc | 650 | 650 | **Invoice in R#4
 | 3 | 2011-03-01 00:00:00 | Misc | 76.05 | 76.05
 | 3 | 2010-12-02 00:00:00 | MIsc | 47.99
 | 3 | 2011-03-21 00:00:00 | Misc | 37.5 | 37.5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 6
 | 6
 | 6
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 7
 | 7
 | 7
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 8
 | 8
 | 8
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
Spreadsheet: 271721d1382027346-get-the-top-5-values-and-associated-names-deals-data
Sheet: Front Sheet

 |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Win/Loss Analysis
 |  |  | Select Month |  | 2013-09-01 00:00:00
 |  |  |  |  |  |  |  |  | Average Life cycle |  | Days
 |  |  |  |  |  |  |  |  | Average Win time |  | Days
 |  |  |  |  |  |  |  |  | Average Loss time |  | Days
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Montly Target |  | USD
 |  |  |  |  |  |  |  |  | Achieved (Won) |  | USD
 |  |  |  |  |  |  |  |  | Month (%)
 |  |  |  |  |  |  |  |  | Difference |  | USD
 |  |  |  |  |  |  | Pipeline - Number of Deals | Pipeline - Revenue
 |  |  | Pipeline - Number of Deals |  |  |  |  | Month
 |  |  | Month |  |  |  |  | Targets |  |  |  |  |  |  | Biggest Open Deals
 |  |  | Won |  |  |  |  | Won
 |  |  | Loss |  |  |  |  | Loss
 |  |  | Pending |  |  |  |  | Pending
 |  |  | Lost Deal Analysis |  |  |  |  |  | Pending Deal Analysis
 |  |  | Stage | No. of Deals |  |  |  |  | Stage | No. of Deals | Revenue
 |  |  | [NAME] (S1) |  |  |  |  |  | [NAME] (S1)
 |  |  | Sent Proposal (S2) |  |  |  |  |  | Sent Proposal (S2)
 |  |  | Sent Proposal (S3) |  |  |  |  |  | Sent Proposal (S3)
 |  |  | [NAME] ([NAME]) |  |  |  |  |  | [NAME] ([NAME])
 |  |  |  |  | Recent Log
 |  |  | Recent activies from Highrise
 |  |  | 2.15 pm | Note: Meeting with Adconion tomorrow
 |  |  | 1.45 pm | email: [NAME] ……
 |  |  | Monthly Performance
 |  |  | [NAME] | Won | Lost | Pending | Total | Won % | Lost % | Pending %
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 859197d1707661740-displaying-information-with-dropdowns-testbook
Sheet: Bylines

Site | Year | Month | Quarter | Byline | Count | Byline Type | External | Internal | Total
Red | 2020 | Dec | Q4 | [NAME] | 100 | Internal
Red | 2020 | Dec | Q4 | [NAME] | 90 | External
Red | 2020 | Dec | Q1 | [NAME] | 80 | External
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal
Yellow | 2020 | Dec | Q2 | Mark | 60 | External
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal
Green | 2020 | Dec | Q4 | Mark | 81 | External
Green | 2021 | Dec | Q4 | [NAME] | 91 | Internal
Green | 2020 | Dec | Q3 | [NAME] | 100 | Internal
Spreadsheet: 678156d1589740543-how-to-return-a-number-based-on-two-sets-of-ranged-criteria-in-a-table-lmi-calculation
Sheet: Sheet1

 |  | lower loan ($) | 0 | 300001 | 5000001 | 600001 | 750001
 |  | higher loan ($) | 300000 | 500000 | 600000 | 750000 | 1000000
 | lower LVR (%) | higher LVR (%) | 0 | 0 | 0 | 0 | 0
 | 0.8001 | 0.81 | 0.00475 | 0.00568 | 0.00904 | 0.00904 | 0.00913
 | 0.8101 | 0.82 | 0.00485 | 0.00568 | 0.00904 | 0.00904 | 0.0058
 | 0.8201 | 0.83 | 0.00596 | 0.00699 | 0.00932 | 0.0109 | 0.01109
 | 0.8301 | 0.84 | 0.00662 | 0.00829 | 0.0096 | 0.0109 | 0.01146
 | 0.8401 | 0.85 | 0.00727 | 0.00969 | 0.01165 | 0.01333 | 0.01407
 | 0.8501 | 0.86 | 0.00876 | 0.01081 | 0.01258 | 0.01407 | 0.01463
 | 0.8601 | 0.869999999999999 | 0.00932 | 0.01146 | 0.01407 | 0.01631 | 0.01733
 | 0.8701 | 0.879999999999999 | 0.01062 | 0.01305 | 0.01463 | 0.01631 | 0.01752
 | 0.8801 | 0.889999999999999 | 0.01295 | 0.01621 | 0.01948 | 0.02218 | 0.02395
 | 0.8901 | 0.899999999999999 | 0.01463 | 0.01873 | 0.0218 | 0.02367 | 0.02516
 | 0.9001 | 0.909999999999999 | 0.02013 | 0.02618 | 0.03513 | 0.03783 | 0.0382
 | 0.9101 | 0.919999999999999 | 0.02013 | 0.02674 | 0.03569 | 0.03867 | 0.03932
 | 0.9201 | 0.929999999999999 | 0.0233 | 0.03028 | 0.03802 | 0.04081 | 0.04156
 | 0.9301 | 0.939999999999999 | 0.02376 | 0.03028 | 0.03802 | 0.04286 | 0.04324
 | 0.9401 | 0.949999999999999 | 0.02609 | 0.03345 | 0.03998 | 0.04613 | 0.04603
 | Purchase price | 1000000
 | Deposit | 150000
 | Borrowed amount
 | LVR | 0.85
 | LMI
Spreadsheet: 78105d1278529131-if-statements-in-excel-with-and-final
Sheet: Shet1

period | months |  |  |  |  |  |  |  | rental charge | due | amt paid | cost pool
Jan-may | 5 |  | Jan | Feb | Mar | Apr | May | 500 | 2500 | 15000 | 17500 | [NAME]
feb-may | 4 |  | Feb | Mar | Apr | May |  | 6340.5 | 25362 | 25362 | 50724 | [NAME]
Jan-apr | 4 |  | Jan | Feb | Mar | Apr |  | 834 | 3336 | 3336 | 6672 | [NAME]
Jan-apr | 4 |  | Jan | Feb | Mar | Apr |  | 6340.5 | 25362 | 25362 | 50724 | dbn
apr-may | 2 |  | Apr | May |  |  |  | 1668 | 3336 | 3336 | 6672 | dbn
[NAME] | 1 | [NAME] | Mar |  |  |  |  | 3336 | 3336 | 3336 | 6672 | [NAME]
jan-mar | 3 |  | Jan | Feb | Mar |  |  | 8454 | 25362 | 25362 | 50724 | [NAME]
jan-mar | 3 |  | Jan | Feb | Mar |  |  | 1112 | 3336 | 3336 | 6672 | [NAME]
jan-mar | 3 |  | Jan | Feb | Mar |  |  | 8454 | 25362 | 25362 | 50724 | [NAME]
Jan | 1 | jan | Jan |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
Jan | 1 | jan | Jan |  |  |  |  | 2653 | 2653 | 2653 | 5306 | dbn
Jan | 1 | jan | Jan |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
Jan | 1 | jan | Jan |  |  |  |  | 2653 | 2653 | 2653 | 5306 | dbn
feb | 1 | feb | Feb |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
Jan | 1 | jan | Jan |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
[NAME] | 3 |  | Mar | Apr | May |  |  | 252.0066666666667 | 756.02 | 756.02 | 1512.04 | psf
[NAME] | 2 |  | Feb | Mar |  |  |  | 12681 | 25362 | 25362 | 50724 | [NAME]
[NAME] | 2 |  | Feb | Mar |  |  |  | 378.01 | 756.02 | 756.02 | 1512.04 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 1326.5 | 2653 | 2653 | 5306 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 378.01 | 756.02 | 756.02 | 1512.04 | dbn
feb-Apr | 3 |  | Feb | Mar | Apr |  |  | 884.3333333333334 | 2653 | 2653 | 5306 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 1668 | 3336 | 3336 | 6672 | [NAME]
[NAME] | 2 |  | Feb | Mar |  |  |  | 12681 | 25362 | 25362 | 50724 | [NAME]
[NAME] | 2 |  | Feb | Mar |  |  |  | 1668 | 3336 | 3336 | 6672 | [NAME]
apr | 1 | Apr | Apr |  |  |  |  | 25362 | 25362 | 25362 | 50724 | [NAME]
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 1326.5 | 2653 | 2653 | 5306 | dbn
march | 1 |  | Mar |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
march | 1 |  | Mar |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
march | 1 |  | Mar |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
feb | 1 | feb | Feb |  |  |  |  | 25362 | 25362 | 25362 | 50724 | [NAME]
jan-apr | 4 |  | Jan | Feb | Mar | Apr |  | 189.005 | 756.02 | 756.02 | 1512.04 | dbn
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
apr | 1 | Apr | Apr |  |  |  |  | 25362 | 25362 | 25362 | 50724 | psf
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
apr | 1 | Apr | Apr |  |  |  |  | 2653 | 2653 | 2653 | 5306 | [NAME]
 |  |  |  |  |  |  |  | 162832.585 | 278032.2999999999
Spreadsheet: daren_farmer__6575__Cilco
Sheet: DEC. 1997

 |  |  |  | CILCO CONTACTS:
 |  |  |  | [NAME]
CILCO STORAGE |  |  |  | PH: (309) 677-5166
 |  |  |  | VONDA SECKLER
BEG. BALANCE |  | 2000000 |  | PH:  (309) 677-5164
 |  |  |  | FAX: (309) 677-5506
NOM. | REC | DEL.
EFF. DATE | VOLUME | VOLUME | STORAGE BAL.
1997-12-01 00:00:00 | 14732 | 14400
1997-12-02 00:00:00 | 14736 | 14400
1997-12-03 00:00:00 | 14845 | 14400
1997-12-04 00:00:00 | 14846 | 14400
1997-12-05 00:00:00 | 14738 | 14400
1997-12-06 00:00:00 | 14845 | 14400
1997-12-07 00:00:00 | 14845 | 14400
1997-12-08 00:00:00 | 14845 | 14400
1997-12-09 00:00:00 | 14738 | 14400
1997-12-10 00:00:00 | 28752 | 28000
1997-12-11 00:00:00 | 28832 | 28000
1997-12-12 00:00:00 | 11260 | 11000
1997-12-13 00:00:00 | 11280 | 11000
1997-12-14 00:00:00 | 11280 | 11000
1997-12-15 00:00:00 | 11280 | 11000
1997-12-16 00:00:00 | 11340 | 11000
1997-12-17 00:00:00 | 11340 | 11000
1997-12-18 00:00:00 | 11340 | 11000
1997-12-19 00:00:00 | 11340 | 11000
1997-12-20 00:00:00 | 11309 | 11000
1997-12-21 00:00:00 | 15124 | 14700
1997-12-22 00:00:00 | 15124 | 14700
1997-12-23 00:00:00 | 15154 | 14700
1997-12-24 00:00:00 | 15249 | 14700
1997-12-25 00:00:00 | 15248 | 14700
1997-12-26 00:00:00 | 15248 | 14700
1997-12-27 00:00:00 | 15248 | 14700
1997-12-28 00:00:00 | 15248 | 14700
1997-12-29 00:00:00 | 15248 | 14700
1997-12-30 00:00:00 | 16972 | 16500
1997-12-31 00:00:00 | 16887 | 16500
Spreadsheet: 36695d1234549583-freezing-a-pane-on-the-top-and-the-bottom-freeze
Sheet: Sheet4

SR | DATE | APPLE | ORANGE
TOTALS | 8 | 26 | 68
1 | 5 | 12 | 45
2 | 1 | 9 | 9
3 | 2 | 5 | 14
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
32