tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 72951d1273636071-formula-without-volatile-formulation-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | User's Choice
 |  |  |  |  |  |  |  |  |  | From: | 2010-07-01 00:00:00 | 2010-07-02 00:00:00
 | 2010-07-01 00:00:00 |  |  |  |  |  |  |  |  | To: | 2010-07-03 00:00:00 | 2010-07-07 00:00:00
Product 1 | 57 | 20 | 16 | 19 | 19 | 41 | 30 | 10 |  |  |  |  |  |  | Create formulae to reflect User's Choice
Product 2 | 25 | 47 | 53 | 54 | 52 | 23 | 22 | 12
Product 3 | 32 | 15 | 19 | 35 | 34 | 22 | 35 | 19
Product 4 | 53 | 24 | 51 | 24 | 16 | 26 | 37 | 41
Product 5 | 31 | 53 | 14 | 35 | 12 | 27 | 34 | 17
Product 6 | 17 | 41 | 11 | 32 | 39 | 41 | 55 | 51
Product 7 | 49 | 56 | 24 | 14 | 42 | 13 | 16 | 49
Product 8 | 38 | 13 | 34 | 26 | 42 | 47 | 49 | 48
Spreadsheet: 115729d1311256219-displaying-a-column-of-data-based-on-drop-down-entry-transferringcolumnsofdata
Sheet: Data

ColA | ColB | ColC | ColD | ColE
1 | 21 | 41 | 61 | 81 |  | Column A data is named ColA, etc.
2 | 22 | 42 | 62 | 82
3 | 23 | 43 | 63 | 83
4 | 24 | 44 | 64 | 84
5 | 25 | 45 | 65 | 85
6 | 26 | 46 | 66 | 86
7 | 27 | 47 | 67 | 87
8 | 28 | 48 | 68 | 88
9 | 29 | 49 | 69 | 89
10 | 30 | 50 | 70 | 90
11 | 31 | 51 | 71 | 91
12 | 32 | 52 | 72 | 92
13 | 33 | 53 | 73 | 93
14 | 34 | 54 | 74 | 94
15 | 35 | 55 | 75 | 95
16 | 36 | 56 | 76 | 96
17 | 37 | 57 | 77 | 97
18 | 38 | 58 | 78 | 98
19 | 39 | 59 | 79 | 99
20 | 40 | 60 | 80 | 100
Spreadsheet: 54411d1254395415-compare-text-between-cells-701613_paokun
Sheet: Sheet1

 |  | Mediterranean Sea. | zbor | DO
 |  | Mediterranean Ses. | 0.9444444444444444 | 0.05555555555555558
 |  | Atlantic Ocean. | 0 | 1
 |  | Atlantic | 0 | 0.4666666666666667
 |  | atlantic | 0 | 0.125
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 56346d1256549527-sum-numeric-values-that-include-units-excel-forum-test-2
Sheet: Heated Volumes

Room/Space Name | Area m2 | Height to  Ceiling m | Heated Volume m3 | Populated Area m2 | Un-Populated Area m2 | Void/Duct Area m2
Room 001 | 11.96 m2 | 2.4 | 28.704
Room 002 | 45.27 m2 | 2.2 | 99.59400000000001
Room 003 | 16.29 m2 | 3 | 48.87
Room 004 | 4.79 m2 | 3 | 14.37
Room 005 | 18.76 m2 | 3 | 56.28
Room 006 | 8.11 m2 | 3 | 24.33
Room 007 | 14.18 m2 | 3 | 42.54
Room 008 | 14.09 m2 | 3 | 42.27
Room 009 | 27.92 m2 | 3 | 83.76
Room 010 | 49.68 m2 | 3 | 149.04
Room 011 | 11.82 m2 | 3 | 35.46
Room 012 | 5.80 m2 | 3 | 17.4
Room 013 | 18.02 m2 | 3 | 54.06
Room 014 | 12.87 m2 | 3 | 38.61
Room 015 | 26.16 m2 | 3 | 78.48
Room 016 | 12.09 m2 | 3 | 36.27
Room 017 | 11.63 m2 | 3 | 34.89
Room 018 | 13.04 m2 | 3 | 39.12
Room 019 | 7.52 m2 | 3 | 22.56
Room 020 | 7.52 m2 | 3 | 22.56
Room 021 | 7.75 m2 | 3 | 23.25
Room 022 | 7.99 m2 | 3 | 23.97
Room 023 | 2.87 m2 | 3 | 8.61
Floor Level Totals | 356.13 |  | 1024.998 | 0 | 0 | 0
Spreadsheet: 796331d1663227840-filter-from-another-workbook-value-error-and-spill-errors-tracker_filter-1-
Sheet: Tickets

Ticket | Date | Client | Rep | Business Unit | Owner | Summary | Segment | Ticket Status |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9
DS282624 | 2021-05-14 00:00:00 | 2 Brothers | Client man | RPT | Raou | Prism Analysis | VLOOKUP EXISTS HERE | On Hold
DS284720 | 2021-06-30 00:00:00 | 1 man | Client man | MFP |  | Prism Analysis | VLOOKUP EXISTS HERE | Awaiting Feedback
DS290679 | 2021-10-15 00:00:00 | Client A | Client man | MFP | r | Hierarchy Amend | VLOOKUP EXISTS HERE | Complete
DS292715 | 2021-12-20 00:00:00 | Client A | Client man | MFP | fer | Prism Analysis | VLOOKUP EXISTS HERE | On Hold
DS295398 | 2022-02-25 00:00:00 | Client A | Client man | RPT | rt | Standard Coding Error | VLOOKUP EXISTS HERE | Closed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 11
DS295410 | 2022-02-25 00:00:00 | Client A | Client man | MFP | tgh | Missing Products/Barcodes | VLOOKUP EXISTS HERE | Closed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 10
DS295633 | 2022-03-02 00:00:00 | Client A | Client man | RPT | Household | Missing Attribute | VLOOKUP EXISTS HERE | Complete
DS295907 | 2022-03-08 00:00:00 | Client A | Client man | MFP | Jofr | Missing Products/Barcodes | VLOOKUP EXISTS HERE | Closed
DS296197 | 2022-03-10 00:00:00 | Client A | Client man | MFP | Jos | Hierarchy Amend | VLOOKUP EXISTS HERE | Closed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 8
DS296637 | 2022-03-16 00:00:00 | Client A | Client man | RPT | sdw | New Attribute | VLOOKUP EXISTS HERE | Complete
DS296649 | 2022-03-16 00:00:00 | Client A | Client man | MFP | ws | New Hierarchy | VLOOKUP EXISTS HERE | Complete
DS296651 | 2022-03-16 00:00:00 | Client A | Client man | MFP | w3e | Missing Attribute | VLOOKUP EXISTS HERE | Complete
DS296671 | 2022-03-16 00:00:00 | Client A | Client man | RPT | LucAN | SKU | VLOOKUP EXISTS HERE | Complete
DS297252 | 2022-03-22 00:00:00 | Client A | Client man | MFP | ws | New Hierarchy | VLOOKUP EXISTS HERE | Complete
DS297254 | 2022-03-22 00:00:00 | Client A | Client man | MFP | Joeew | New Hierarchy | VLOOKUP EXISTS HERE | Complete
DS297255 | 2022-03-22 00:00:00 | Client A | Client man | MFP | sw | New Hierarchy | VLOOKUP EXISTS HERE | Closed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7
DS298216 | 2022-04-07 00:00:00 | Client A | Client man | MFP |  | Standard Coding Error | VLOOKUP EXISTS HERE | Closed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 6
DS298355 | 2022-04-08 00:00:00 | Client A | Client man | MFP | edd | New Hierarchy | VLOOKUP EXISTS HERE | Complete
DS299472 | 2022-04-28 00:00:00 | Client A | Client man | MFP | re | New Attribute | VLOOKUP EXISTS HERE | Complete
Spreadsheet: 825479d1681336456-substitute-issue-sub-example
Sheet: Sheet1

Item | Sub |  | Item | Sub
X | 1 |  | X | 1
X | 2 |  | X | 2
X | 3 |  | X | 3
1 | X |  | Y | 4
1 | 2 |  | Y | 5
1 | 3 |  | Y | 6
2 | 1 |  | Z | 7
2 | X |  | Z | 8
2 | 3 |  | Z | 9
3 | 1
3 | 2
3 | X
Y | 4
Y | 5
Y | 6
4 | Y
4 | 5
4 | 6
5 | 4
5 | Y
5 | 6
6 | 4
6 | 5
6 | Y
Z | 7
Z | 8
Z | 9
7 | Z
7 | 8
7 | 9
8 | 7
8 | Z
8 | 9
9 | 7
9 | 8
9 | Z
Spreadsheet: 838218d1690823945-average-formula-but-does-not-include-blank-fields-labor-tracker-1945
Sheet: Daily Tracking

Labor Tracker Week Ending Date | 2023-06-29 00:00:00 |  |  |  | Market #
 |  |  | Actual Hours Used By Day in Each Site
 |  |  | Friday |  |  | Saturday |  |  | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Remaining Hours | Average Hours/Day | Remaining Manager [NAME]
Store # | Weekly Budget Hours | AVERAGE/DAY | Regular | Manager | ShiftSmart | Regular | Manager | ShiftSmart | Regular | Manager | ShiftSmart | Regular | Manager | ShiftSmart | Regular | Manager | ShiftSmart | Regular | Manager | ShiftSmart | Regular | Manager | ShiftSmart
2723421 | 271.4 |  | 0 |  | 12 | 0 |  |  | 86.44 | 32.7
2723432 | 273 |  | 0 |  | 12 | 0 |  |  | 47.22 | 29.78
2723435 |  |  | 0 |  | 8 | 0 |  |  | 86.68 | 0
2723437 | 248.6 |  | 0 |  | 12 | 0 |  |  | 69.41 | 18.55
2723440 | 264.9 |  | 0 |  | 12 | 0 |  |  | 88.54 | 10.6
2723448 | 288.1 |  | 0 |  | 12 | 0 |  |  | 113.94 | 0
2723456 | 310.7 |  | 0 |  | 12 | 0 |  |  | 82.21 | 8.98
2723736 | 351 |  | 0 |  | 20 | 0 |  |  | 132.7 | 10
2723738 | 365 |  | 0 |  | 12 | 0 |  |  | 156.48 | 17.5
2723745 | 314.4 |  | 0 |  | 12 | 0 |  |  | 101.24 | 12.97
2723748 | 312.2 |  | 0 |  | 12 | 0 |  |  | 144.11 | 10.3
2723759 | 263.1 |  | 0 |  | 12 | 0 |  |  | 77.76 | 0.03
2723761 | 264.3 |  | 0 |  | 12 | 0 |  |  | 82.45 | 17.78
2723859 | 329.5 |  | 0 |  | 12 | 0 |  |  | 122.1 | 0
Market Total
Spreadsheet: 125609d1319126214-track-rental-availability-tracking-template
Sheet: RENTAL tracking 

2011 MATTING RENTAL
TYPE | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | MATT # | STATUS | COMPANY | CONSULTANT | TOTAL MATTS
8" x 40" [NAME] | 7 | 49 | 18 | 22 | 34 | 15 | 16 | 26 | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On-Location | ABC WIDGET | [NAME] | 9
8" x 40" [NAME] | 8 | 12 | 16 | 45 | 47 | 39 | 84 | 112 | 223 | 224 | 238 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On-Location | BCD Gravel | [NAME] | 11
Spreadsheet: 753576d1635528351-creating-a-hierarchy-structure-with-formulas-sample1
Sheet: Sheet1

Index | Period | YearTotal | Q1 | Q2 | Q3 | Q4
0 | Y-T-D
1 | H-T-D
2 | S-T-D
3 | Q-T-D
4 | P-T-D
5 | M-T-D
6 | W-T-D
7 | D-T-D
8 | BegBalance
9 | YearTotal
10 |  | Q1
11 |  |  | Dec
12 |  |  | Jan
13 |  |  | Feb
14 |  | Q2
15 |  |  |  | Mar
16 |  |  |  | Apr
17 |  |  |  | May
18 |  | Q3
19 |  |  |  |  | Jun
20 |  |  |  |  | Jul
21 |  |  |  |  | Aug
22 |  | Q4
23 |  |  |  |  |  | Sep
24 |  |  |  |  |  | Oct
25 |  |  |  |  |  | Nov
Spreadsheet: 177868d1346483563-want-to-get-highest-sales-qty-and-sales-person-name-within-specified-dates-devawad_855749_31aug12_01
Sheet: Sheet4

Sum of Qty | Column Labels
Row Labels | Pen | Grand Total
1.8.2012 - 7.8.2012 | 105 | 105
[NAME] | 35 | 35
Leo | 40 | 40
Ram | 20 | 20
Ravi | 10 | 10
8.8.2012 - 9.8.2012 | 20 | 20
[NAME] | 20 | 20
Grand Total | 125 | 125
Spreadsheet: 856598d1705788392-compare-planned-vs-actual-values-monthly-and-generate-a-table-20240121_o365_compare-planned-vs-actuals-excelforum-windknife
Sheet: Comparison

 | Activity | Month | Plan | Actual | Actual > Plan | [NAME] | Cumulative Variance | Actuals to cover Previous Months Backlog |  |  | Plan As of | 2023-03-01 00:00:00
 | Activity 1 | 2023-01-01 00:00:00 | 100 | 150 | 50 | 50 | 50 | 0 |  |  | Actual As of | 2023-05-30 00:00:00
 | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 | 0 | 0 | 50 | 0
 | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 | 300 | 300 | 350 | 0
 | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 | 100 | 100 | 100 | 0
 | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 | 0 | -200 | -100 | 0
 | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 | 250 | 250 | 150 | 100
 | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 | 0 | -200 | -200 | 0
 |  | 2023-01-01 00:00:00 | 100 | 150 | 50 | 50 | 50 | 0
 | Activity 1 | 2023-02-01 00:00:00 | 200 | 200 | 0 | 0 | 50 | 0
 | Activity 1 | 2023-03-01 00:00:00 | 300 | 600 | 300 | 300 | 350 | 0
 | Activity 2 | 2023-01-01 00:00:00 | 0 | 100 | 100 | 100 | 100 | 0
 | Activity 2 | 2023-02-01 00:00:00 | 200 | 0 | 0 | -200 | -100 | 0
 | Activity 2 | 2023-03-01 00:00:00 | 0 | 250 | 250 | 250 | 150 | 100 | This is correct.
 | Activity 3 | 2023-03-01 00:00:00 | 200 | 0 | 0 | -200 | -200 | 0 | Desired Result
 | Activity 3 | 2023-04-01 00:00:00 | 0 | 100 | 100 | 100 | -100 | 200 | 100 | As of Mar, there was a backlog of 200. From Apr actuals, 100 was used to cover this
 | Activity 3 | 2023-05-01 00:00:00 | 0 | 50 | 50 | 50 | -50 | 100 | 50 | As of Apr, there was a backlog of 100. From May actuals, 50 was used to cover this.
Spreadsheet: 58863d1259144088-copying-full-rows-if-certain-critera-met-test-sheet
Sheet: Master sheet

 |  |  |  | REP
2009-02-25 00:00:00 | Respite Care Centre,Clitheroe | 5986.42 | 40 | 108 - Pete Malone
2009-02-25 00:00:00 | RAF Coltishall, Building 7 | 8976.33 | 62 | 108 - Pete Malone
2009-02-24 00:00:00 | Harestock | 776.92 | 4 | 113 - [NAME]
2009-02-25 00:00:00 | Southdowns College | 14428.39 | 57 | 113 - [NAME]
2009-02-25 00:00:00 | Vinters [NAME], Maidstone | 3157.12 | 13 | 113 - [NAME]
2009-02-23 00:00:00 | [NAME] (New Bus Station) | 1226.72 | 7 | 115 - Colin/Darren Broad
2009-02-25 00:00:00 | [NAME] | 432.13 | 2 | 106 - [NAME]
2009-02-27 00:00:00 | Price Enquiry | 3157.12 | 13 | 113 - [NAME]
2009-02-25 00:00:00 | Woodlands School | 586.79 | 4 | 115 - Colin/Darren Broad
2009-02-26 00:00:00 | [NAME] | 649.05 | 4 | 115 - Colin/Darren Broad
Spreadsheet: 153499d1335945676-returning-value-from-the-list-top-forum1
Sheet: City

[NAME] | Area2
Streetname1 | Streetname14
Streetname2 | Streetname15
Streetname3 | Streetname16
Streetname4 | Streetname17
Streetname5 | Streetname18
Streetname6 | Streetname19
Streetname7 | Streetname20
Streetname8 | Streetname21
Streetname9 | Streetname22
Streetname10 | Streetname23
 | Streetname24
 | Streetname25
Spreadsheet: 680227d1590863695-my-sumifs-isnt-working-travel-card-reconciliation
Sheet: Sheet1

Travel Card Reconciliation
Date | Who? | What | [NAME] | [NAME]
2020-05-13 00:00:00 | [NAME] | Lodging - 2120 |  | 109
2020-05-13 00:00:00 | [NAME] | Lodging Tax - 2130 |  | 5
 | [NAME] | Lodging - 2120 |  | 109
 | [NAME] | Lodging Tax - 2130 |  | 5
 | [NAME] | Lodging - 2121 |  | 109
 | [NAME] | Lodging Tax - 2131 |  | 5
 | [NAME] | Lodging - 2122 |  | 109
 | [NAME] | Lodging Tax - 2132 |  | 5
 | [NAME] | Lodging - 2123 |  | 109
 | [NAME] | Lodging Tax - 2133 |  | 5
 | [NAME] | Lodging - 2124 |  | 109
 | [NAME] | Lodging Tax - 2134 |  | 5
 | [NAME] | Lodging - 2125 |  | 109
 | [NAME] | Lodging Tax - 2135 |  | 5
 | [NAME] | Lodging - 2126 |  | 109
 | [NAME] | Lodging Tax - 2136 |  | 5
 | [NAME] | Lodging - 2127 |  | 109
 | [NAME] | Lodging Tax - 2137 |  | 5
 | [NAME] | Lodging - 2128 |  | 109
 | [NAME] | Lodging Tax - 2138 |  | 5
 | [NAME] | Lodging - 2129 |  | 109
 | [NAME] | Lodging Tax - 2139 |  | 5
 | [NAME] | Lodging - 2130 |  | 109
 | [NAME] | Lodging Tax - 2140 |  | 5
 | [NAME] | Lodging - 2131 |  | 109
 | [NAME] | Lodging Tax - 2141 |  | 5
 | [NAME] | Lodging - 2132 |  | 109
 | [NAME] | Lodging Tax - 2142 |  | 5
 | [NAME] | Lodging - 2133 |  | 109
 | [NAME] | Lodging Tax - 2143 |  | 5
 | [NAME] | Lodging - 2134 |  | 109
 | [NAME] | Lodging Tax - 2144 |  | 5
 | [NAME] | Lodging - 2135 |  | 109
 | [NAME] | Lodging Tax - 2145 |  | 5
 | [NAME] | Lodging - 2136 |  | 109
 | [NAME] | Lodging Tax - 2146 |  | 5
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: ac

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 2a9f67db-8b18-4fbf-b714-a7a285587430
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-23 09:29:00.620000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.625 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.5 | 102.081 | 101.956 | 101.831 | 101.456
4.375 | 101.697 | 101.572 | 101.447 | 101.072 |  | Note: | Refer To Price [NAME]
4.25 | 101.18 | 101.055 | 100.93 | 100.555 |  |  | For all Price Adjs
4.125 | 100.412 | 100.287 | 100.162 | 99.537
4 | 99.452 | 99.327 | 99.202 | 98.577
3.875 | 98.437 | 98.312 | 98.187 | 97.562
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.125 | 102 | 101.875 | 101.5
3.625 | 102.083 | 101.958 | 101.833 | 101.458
3.5 | 101.869 | 101.744 | 101.619 | 101.244
3.375 | 101.116 | 100.991 | 100.866 | 100.491
3.25 | 100.392 | 100.267 | 100.142 | 99.517
3.125 | 99.706 | 99.581 | 99.456 | 98.831
3 | 99.174 | 99.049 | 98.924 | 98.299 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-11-06 09:29:00.620000
30 DAY | 2013-11-21 09:29:00.620000
45 DAY | 2013-12-06 09:29:00.620000
60 DAY | 2013-12-21 09:29:00.620000
90 DAY | 2014-01-20 09:29:00.620000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 90673d1290455026-excel-2007-copy-last-number-from-a-list-libro1
Sheet: Hoja1

Purchase | Product A | 25
Purchase | Product A | 37
Purchase | Product B | 19
Purchase | Product A | 18
Purchase | Product B | 26
Adjustment | Product A
Labelling | Product A
Labelling | Product B
Purchase | Product A | 9
Purchase | Product B | 76
Labelling | Product A
Spreadsheet: 677389d1589330119-assignment-assistance-formulas-sales-manager-excel-assignment
Sheet: Q2

Question: | This is a daily sales in GSV , we have 10 days as a working days for sales and we are in the seventh day,kindly note that the day No.5 is 1st of May
 | Please calculate all cells with "?" with formula Do Not calculate it manually?
Working days | Actual In GSV |  | Working  Day's | Time Gone | Time To Go | Time Gone%
1 | 2000000 |  | ? | ? | ? | ?
2 | 311742.3
3 | 1645375.44 |  | Target | Total Sales | Average Daily Sales | Ach%
4 | 963457.3500000001 |  | 10000000 | ? | ? | ?
5 | 0
6 | 1141836.69 |  | Remaining Sales | Average Required Sales
7 | 1550000 |  | ?
8
9
10
Spreadsheet: 757219d1638125796-calculations-vlookup-social-fuel-excel-test-for-sem-
Sheet: Campaign data

 | Campaign Report |  |  |  |  |  |  |  |  |  | Campaign Report
 | Date Range: July |  |  |  |  |  |  |  |  |  | Date Range: August
 | Campaign | Campaign ID | Device | Impr | Clicks | Spend | Leads | Revenue |  |  | Campaign | Campaign ID | Device | Impr | Clicks | Spend | Leads | Revenue
 | Campaign - Midwest - IL | 1 | Desktop | 100 | 25 | 81.25 | 5 | 115 |  |  | Campaign - Midwest - IL | 1 | Desktop | 82 | 8 | 47 | 3 | 90
 | Campaign - Midwest - MN | 2 | Desktop | 167 | 45 | 166.5 | 4 | 128 |  |  | Campaign - Midwest - MN | 2 | Desktop | 79 | 8 | 27 | 1 | 17
 | Campaign - Midwest - WI | 3 | Desktop | 110 | 33 | 82.5 | 7 | 238 |  |  | Campaign - Midwest - WI | 3 | Desktop | 70 | 12 | 62 | 6 | 258
 | Campaign - East - NJ | 4 | Desktop | 433 | 65 | 139.75 | 6 | 246 |  |  | Campaign - East - NJ | 4 | Desktop | 306 | 46 | 114 | 4 | 60
 | Campaign - East - NY | 5 | Desktop | 286 | 100 | 444.0000000000001 | 8 | 376 |  |  | Campaign - East - NY | 5 | Desktop | 284 | 53 | 413 | 4 | 192
 | Campaign - Midwest - IL | 1 | Mobile | 115 | 30 | 98 | 6 | 90 |  |  | Campaign - Midwest - IL | 1 | Mobile | 47 | 24 | 40 | 4 | 172
 | Campaign - Midwest - MN | 2 | Mobile | 192 | 53 | 200 | 5 | 245 |  |  | Campaign - Midwest - MN | 2 | Mobile | 11 | 5 | 68 | 1 | 25
 | Campaign - Midwest - WI | 3 | Mobile | 127 | 39 | 99 | 8 | 176 |  |  | Campaign - Midwest - WI | 3 | Mobile | 113 | 35 | 34 | 4 | 68
 | Campaign - East - NJ | 4 | Mobile | 498 | 77 | 168 | 7 | 119 |  |  | Campaign - East - NJ | 4 | Mobile | 266 | 20 | 106 | 6 | 186
 | Campaign - East - NY | 5 | Mobile | 329 | 118 | 533 | 10 | 390 |  |  | Campaign - East - NY | 5 | Mobile | 152 | 66 | 432 | 2 | 72
Spreadsheet: 270409d1381476285-forumla-from-drop-down-list-incorporating-vlookup-across-workbooks-and-sheets-cost-sheet-test
Sheet: Sheet1

 |  |  |  | COSTING SHEET
Costing Sheet Status: |  |  |  | COMPLETED |  |  |  |  |  |  |  |  | REVISION NO:
PREPARED BY |  |  |  |  |  | RESELLER NAME: |  |  |  |  |  | END-USER INFO:
DATE: |  |  |  |  |  | PAYMENT TERMS: |  | 30 DAYS
CPO REF NO / RECEIVED DATE: |  |  |  |  |  | COSTING SHT CURRENCY: |  | USD
SALES PERSONNEL: |  |  |  |  |  | EXCHANGE RATE (AUG 2013): |  | 1.3181
No. | Product Category | Product  ID/Code | Partner Level | Brief Description | DELIVERY LOCATION | Supplier  [SPO#] | List Price | Discount | Qty | Selling  Unit Price | Total  Selling Price | Unit  Cost | Total  Cost | Gross  Profit | Gross Margin | Freight
1 |  |  |  |  |  |  |  | 0 | 0 | 0
2 |  |  |  |  |  |  |  | 0
3 |  |  |  |  |  |  |  | 0
4 |  |  |  |  |  |  |  | 0
5 |  |  |  |  |  |  |  | 0
6 |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  | 0
8 |  |  |  |  |  |  |  | 0
9 |  |  |  |  |  |  |  | 0
10 |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  | 0
 |  |  |  |  | TOTALS:
PURCHASER's Comment: |  |  |  |  |  |  |  |  |  |  |  | Less: Freight cost (2% of HW):
 |  |  |  |  |  |  |  |  |  |  | Less: Marketing Development Fees (MDF) :
 |  |  |  |  |  |  |  |  |  |  |  | Gross Profit before commission
 |  |  |  |  |  |  |  |  |  |  | Country Mgrs/Products Mgrs/Consultants Comment (to indicate reason if margin is less than  8% (software) & 10% (hardware)
Approved by :                             Agreed by :                                       Agreed by :
______________________         _____________________                  ____________________
([NAME])                            (Finance Manager)                          (Managing Director)
DEFINITIONS OF PRODUCTS CATEGORY:
1 | H = | HARDWARE
2 | S = | SOFTWARE
3 | M = | NEW MAINTENANCE SUPPORT
4 | R = | [NAME]
5 | I  = | IN HOUSE MAINTENANCE
6 | P = | PROFESSIONAL SERVICES
7 | T = | TRAINING
Spreadsheet: 685291d1593884483-multiple-conditon-formula-for-monthly-spend-example
Sheet: example

 | Date | example | example2 | example3 | example4 | Price | Paid? | [NAME]? | Notified? |  |  | Total Month Spend:
 | 2020-01-01 00:00:00 |  |  |  |  | 0.5 | Y | Y | N |  |  | Currency: | $ | £
 | 2020-01-02 00:00:00 |  |  |  |  | $12.00 | N | N | N |  |  | Jan
 | 2020-01-03 00:00:00 |  |  |  |  | $0.00 | N/A | Y | Y |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  | Dec