tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 376103d1423492492-lookup-multiple-lists-with-unique-part-numbers-for-total-quantity-oeldere-376099d1423492075-lookup-multiple-lists-with-unique-part-numbers-for-total-quantity-m
Sheet: Parts 1

Parts | Part Number | Qty
1 | 10001 | 0 |  |  | Rijlabels | Som [NAME]
1 | 10002 | 0 |  |  | 10001 | 2
1 | 10003 | 0 |  |  | 10002 | 1
1 | 10004 | 0 |  |  | 10003 | 0
1 | 10005 | 0 |  |  | 10004 | 2
1 | 10006 | 0 |  |  | 10005 | 1
1 | 10007 | 0 |  |  | 10006 | 2
1 | 10008 | 1 |  |  | 10007 | 56
1 | 10009 | 0 |  |  | 10008 | 6
1 | 10010 | 0 |  |  | 10009 | 4
1 | 10011 | 2 |  |  | 10010 | 0
1 | 10012 | 0 |  |  | 10011 | 2
1 | 10013 | 4 |  |  | 10012 | 5
1 | 10014 | 0 |  |  | 10013 | 4
1 | 10015 | 5 |  |  | 10014 | 0
1 | 10016 | 21 |  |  | 10015 | 50
1 | 10017 | 0 |  |  | 10016 | 42
1 | 10018 | 0 |  |  | 10017 | 0
1 | 10019 | 0 |  |  | 10018 | 0
1 | 10020 | 5 |  |  | 10019 | 52
2 | 10001 | 2 |  |  | 10020 | 5
2 | 10003 | 0 |  |  | 10021 | 0
2 | 10005 | 1 |  |  | 10022 | 0
2 | 10007 | 56 |  |  | 10023 | 0
2 | 10009 | 0 |  |  | 10024 | 0
2 | 10011 | 0 |  |  | 10025 | 5
2 | 10013 | 0 |  |  | 10026 | 12
2 | 10015 | 45 |  |  | 10027 | 2
2 | 10017 | 0 |  |  | 10028 | 1
2 | 10019 | 52 |  |  | 10029 | 1
2 | 10021 | 0 |  |  | 10030 | 5
2 | 10023 | 0 |  |  | 10031 | 0
2 | 10025 | 5 |  |  | 10032 | 0
2 | 10027 | 2 |  |  | 10033 | 2
2 | 10029 | 1 |  |  | 10034 | 0
2 | 10031 | 0 |  |  | 10035 | 4
2 | 10033 | 2 |  |  | 10036 | 0
2 | 10035 | 4 |  |  | 10037 | 5
2 | 10037 | 5 |  |  | 10038 | 0
2 | 10039 | 6 |  |  | 10039 | 6
3 | 10002 | 0 |  |  | 10040 | 2
3 | 10004 | 2 |  |  | Eindtotaal | 279
3 | 10006 | 0
3 | 10008 | 5
3 | 10010 | 0
3 | 10012 | 5
3 | 10014 | 0
3 | 10016 | 21
3 | 10018 | 0
3 | 10020 | 0
3 | 10022 | 0
3 | 10024 | 0
3 | 10026 | 12
3 | 10028 | 1
3 | 10030 | 5
3 | 10032 | 0
3 | 10034 | 0
3 | 10036 | 0
3 | 10038 | 0
3 | 10040 | 2
4 | 10006 | 2
4 | 10009 | 4
4 | 10002 | 1
Spreadsheet: 885481d1735105101-rank-students-according-to-marks-obtained-based-on-multiple-criteria-rank-function2
Sheet: RESULT

ABCD SCHOOL
TOTAL
Sl. No. | Name of the Student | Class | Sec. | Roll No. | Sex | Cat. | Status | Total Marks Obtained | Grade | % Marks Obtained | Exected Rank | Qualified / Not-qualified
 | [NAME] | X | A | 1 | G | SC | AP | 447 | 0D | 0.6385714285714286 |  | PASS
 | RIYA BARMAN | X | A | 2 | G | SC | AP | 447 | 0D | 0.5971428571428572 |  | PASS
 | [NAME] | X | A | 3 | G | GEN | AP | 447 | 3D | 0.6385714285714286 |  | PASS
 | [NAME] | X | A | 4 | G | GEN | AP | 300 | 0D | 0.5842857142857143 |  | PASS
 | [NAME] | X | A | 5 | B | GEN | AP | 447 | 2D | 0.4442857142857143 |  | PASS
 | [NAME] | X | A | 6 | G | SC | AP | 350 | 0D | 0.5642857142857143 |  | PASS
 | [NAME] | X | A | 7 | G | SC | AP | 447 | 4D | 0.4828571428571429 |  | PASS
 | KAKALI BARMAN | X | A | 8 | G | GEN | AP | 447 | 1D | 0.4728571428571429 |  | PASS
 | BARNALI BARMAN | X | A | 9 | G | SC | AP | 450 | 1D | 0.4642857142857143 |  | PASS
Spreadsheet: 25491d1216816181-golf-handicap-spreadsheet-peters-golf-handicap-calculator
Sheet: P. Jones

 | Name: |  | [NAME]
 | Date | Category | Score | [NAME] | Course Par | Handicap | Uncorrect handicap | Over/ Under par | Handicap correction
 |  | 4 | 96 | 68 | 70 | 28 | 28 | -2 | 27.2 | 27.2 | 27.2 | 27.2 | 28 |  | Handicap | Category | Buffer Zone | Above Buffer | [NAME]
 |  | 4 | 106 | 79 | 68 | 27 | 27.2 | 11 | 27.3 | 27.3 | 27.3 | 27.3 | 27.2
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3 |  | 0 to 5 | 1 | 1 | 0.1 | 0.1
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3 |  | 6 to 12 | 2 | 2 | 0.1 | 0.2
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3 |  | 13 to 20 | 3 | 3 | 0.1 | 0.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3 |  | 21 to 28 | 4 | 4 | 0.1 | 0.4
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3 |  | 29 to 36 | 5 | 5 | 0.1 | 0.5
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  | 4 | 0 | 0 | 70 | 27 | 27.3 | 0 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3
 |  |  | To round handicap to nearest. Add 0.5 to uncorrected handicap then round with INT (round down)
Spreadsheet: 48280d1247510804-cell-referencing-rows-to-columns-cell-ref
Sheet: ROW REF 1

 | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
 | 2009-07-13 00:00:00 | 2009-07-14 00:00:00 | 2009-07-15 00:00:00 | 2009-07-16 00:00:00 | 2009-07-17 00:00:00 | 2009-07-18 00:00:00 | 2009-07-19 00:00:00
PAYMENTS | 8 | 5 | 7 | 2 | 9 | 11 | 2
DISBUSMENTS | 6 | 3 | 5 | 1 | 5 | 4 | 1
Spreadsheet: 153109d1335775810-returning-a-price-based-on-data-moulding-stocklist
Sheet: E 1-6

Rack 1 |  | E | Rack 2 |  | E | Rack 3 |  | E | Rack 4 |  | E | Rack 5 |  | E | Rack 6 |  | E
Code | Amount |  | Code | Amount |  | Code | Amount |  | Code | Amount |  | Code | Amount |  | Code | Amount
W938547 | 32ft |  | C2134 | 18 Ft | 27.86 | 657902 | 10ft |  | 645305 | bits |  | pol4448/blue | 36ft |  | B1498 | 18ft | 7.99
[NAME] | 35ft |  | 2291 ivo | 15 Ft |  | 457904 | 32ft |  | 435305 | 27 Ft |  | pol4447/red | 45ft |  | 744-sil | 9ft
W938553 | 10ft |  | 2293 ivo | 13 Ft |  | 457905 | 15ft |  | 435303 | 23 Ft |  | pol4446/gold | 31 Ft |  | 2085-arg | 58.5ft
W938549 | 11 Ft |  | Mo3580 | 36 Ft |  | Pol4574 | 18 Ft |  |  |  |  | MO9037 | 0 Ft |  | 342605 | 30ft
2021207 | 20ft |  | 2201 | 10 Ft |  |  |  |  |  |  |  | pol4482 | 25 Ft |  | 446400000 | 32.5ft
W911126 | 40ft |  | 2202 | 12 Ft |  |  |  |  |  |  |  | pol4479 | 9ft |  | 442608 | 9ft
W911120 | 19ft |  | 123-nat | 8 Ft |  |  |  |  |  |  |  |  |  |  | 234924 | 5 Ft
416.01 | 140ft |  | 124400000 | 10 Ft |  |  |  |  |  |  |  |  |  |  | 342600 | 13ft
W911125 | 30ft |  | PW76 | 6 Ft |  |  |  |  |  |  |  |  |  |  | D3495 | 14 Ft | 18.07
772541 | 15ft |  | [NAME] | 10 Ft | 8.60 |  |  |  |  |  |  |  |  |  | 771-arg | 25 Ft
771-arg | 0 Ft |  | Pol sg500 | 9 Ft
 |  |  | Pol4279 | 31.50 Ft
 |  |  | C2789 | 6 Ft | 9.84
Spreadsheet: 211670d1359880524-pattern-matching-within-a-dynamic-data-set-position_spreadsheet-copy
Sheet: 1Yr_Fly

 |  | Fly | Mar13Jun13Sep13 | Jun13Sep13Dec13 | Sep13Dec13Mar14 | [NAME] | Mar14Jun14Sep14 | [NAME] | Sep14Dec14Mar15 | Dec14Mar15Jun15 | Mar15Jun15Sep15 | [NAME]
 | Position
 |  | Spread | Mar13 [NAME] | [NAME] | [NAME] | Dec13 Mar14 | [NAME] | [NAME] Sep14 | Sep14 Dec14 | Dec14 Mar15 | Mar15 [NAME] | [NAME] | [NAME]
2013-03-18 00:00:00 | 0
2013-06-17 00:00:00 | 0
2013-09-16 00:00:00 | 10
2013-12-16 00:00:00 | 0
2014-03-17 00:00:00 | 0
2014-06-16 00:00:00 | 0
2014-09-15 00:00:00 | -20
2014-12-15 00:00:00 | 0
2015-03-16 00:00:00 | 0
2015-06-15 00:00:00 | 0
2015-09-14 00:00:00 | 10
2015-12-14 00:00:00 | 0
2016-03-14 00:00:00 | 0
Spreadsheet: 272606d1382444369-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-vat1_sr_rev
Sheet: Result

Date | Name of Party | Particulars | Vch No. | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total | TDS
 |  |  |  |  |  |  |  |  |  |  | 371
Spreadsheet: 141778d1329436955-sumproduct-copy-of-spend-analysis
Sheet: Sheet1

[NAME] | Net Spend
Seven Heaven Ltd | 85254.48
Seven Heaven Ltd | 134731.483333333 |  |  | Adhoc Tech Solution | 31179.1
Solutions Limited | 1199418.1 |  |  | Accoustic Services | 412556.01
Solutions Limited | 1139999.8 |  |  | Angus Supply | 140640.2066666667
Angus Supply | 93464.49 |  |  | Azad Solutions | 57954.87
Angus Supply | 47175.7166666667 |  |  | Comet Academy | 91758.96
Azad Solutions | 25652.87 |  |  | Indication IT Ltd | 166104.45
Azad Solutions | 32302 |  |  | Level Star Lighting | 167349.2
Comet Academy | 45879.48 |  |  | Loafers Ltd | 26423.68333333333
Comet Academy | 45879.48 |  |  | Modern Family Solution | 120521.08
Loafers Ltd | 26423.68333333333 |  |  | Seven Heaven Ltd | 219985.963333333
Accoustic Services | 412556.01 |  |  | [NAME] | 376683.7
[NAME] | 376683.7 |  |  | Solutions Limited | 2339417.9
Modern Family Solution | 120521.08 |  |  | Grand Total | 4150575.123333333
Indication IT Ltd | 94319.17
Indication IT Ltd | 71785.28
Level Star Lighting | 108894.95
Level Star Lighting | 58454.25
Adhoc Tech Solution | 31179.1
Spreadsheet: 158890d1338431081-unable-to-copy-the-source-formatting-border-font-size-font-colour-merger-of-cells-etc-speedtest1
Sheet: Test-37

Speed Test Result
Speed Test No.-37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dated: 10th May'11
Rank | Name ([NAME]) | G.S. |  |  | Reasoning |  |  | Maths |  |  | English |  |  | Grand Total |  |  |  | Percentage (Rounded)
 |  | Right | Wrong | Marks | Right | Wrong | Marks | Right | Wrong | Marks | Right | Wrong | Marks | Attemp. | Right | Wrong | Marks
1 | Sujeet UBI | 25 | 10 |  | 46 | 3 |  | 47 | 0 |  | 47 | 3
2 | Durgesh | 28 | 8 |  | 47 | 2 |  | 48 | 0 |  | 36 | 8
3 | Veeru | 30 | 12 |  | 45 | 3 |  | 44 | 1 |  | 36 | 12
4 | Anshul | 23 | 3 |  | 48 | 1 |  | 46 | 1 |  | 33 | 7
5 | Ajit | 15 | 15 |  | 43 | 3 |  | 46 | 2 |  | 40 | 8
6 | Raj | 20 | 16 |  | 47 | 1 |  | 35 | 8 |  | 34 | 15
7 | Neeta | 14 | 7 |  | 41 | 4 |  | 32 | 1 |  | 40 | 5
8 | Uttam | 29 | 3 |  | 46 | 4 |  | 26 | 7 |  | 21 | 26
9 | Abhi IDBI
10 | Abhi UBI
11 | Brijesh
12 | Kirti
13 | Pallavi
14 | Preeti
15 | Sujeet IT
16 | Sunil
 | Section Toppers
 | GS |  | Uttam
 | Reasoning |  | Anshul
 | Maths |  | Durgesh
 | English |  | Sujeet IT
Spreadsheet: 164573d1340811464-formula-using-yearfrac-on-a-range-then-returning-average-yearfrac-example
Sheet: Sheet1

 |  |  |  |  |  |  | Today's Date
 |  |  |  |  |  | Date of Hire | Length of Service years        months |  |  | AVERAGE LENGTH OF SERVICE:
 |  |  |  |  |  | 2006-09-11 00:00:00
 |  |  |  |  |  | 2011-01-24 00:00:00
 |  |  |  |  |  | 1999-09-13 00:00:00
 |  |  |  |  |  | 2005-02-28 00:00:00
 |  |  |  |  |  | 1999-10-25 00:00:00
 |  |  |  |  |  | 2005-05-09 00:00:00
 |  |  |  |  |  | 2005-08-06 00:00:00
 |  |  |  |  |  | 2012-04-02 00:00:00
 |  |  |  |  |  | 2012-04-02 00:00:00
 |  |  |  |  |  | 2012-04-02 00:00:00
 |  |  |  |  |  | 1999-04-27 00:00:00
 |  |  |  |  |  | 2003-05-12 00:00:00
 |  |  |  |  |  | 2011-06-21 00:00:00
 |  |  |  |  |  | 2000-06-29 00:00:00
 |  |  |  |  |  | 2000-07-17 00:00:00
 |  |  |  |  |  | 2012-01-09 00:00:00
 |  |  |  |  |  | 2011-12-12 00:00:00
 |  |  |  |  |  | 2008-07-28 00:00:00
 |  |  |  |  |  | 2000-01-12 00:00:00
Spreadsheet: 2b1e5a1f-d981-4d14-aaf4-e329a670a06e
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 9/30/2011
(As of 11/28/2011)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 441.95
Ansary, Raihana | At-will staff for Mayor [NAME]
Brooks, Caryn | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Clarke, [NAME] | At-will staff for Mayor [NAME]
Dillman, [NAME] | At-will staff for Mayor [NAME]
Edwards, [NAME] | At-will staff for Mayor [NAME]
[NAME], Todd | At-will staff for Mayor [NAME]
Fish, [NAME] | Commissioner | 260
Fritz, Amanda | Commissioner | 125
Gonzales, Cevero | At-will staff for Mayor [NAME]
Griffin-Valade, [NAME] | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Lauer, [NAME] | At-will staff for Mayor [NAME]
Leonard, [NAME] | Commissioner (Filed 7/18/2011) | 110
[NAME], [NAME] | At-will staff for Mayor Adams (Amended 7/26/2011)
Lord II, Reese | At-will staff for Mayor [NAME]
Marriot, [NAME] | Director of Bureau of Environmental Services  (Filed 7/18/2011)
[NAME], [NAME] | At-will staff for Mayor [NAME]  (Filed 7/18/2011)
Neal, Clay | At-will staff for Mayor [NAME]
Papaefthimiou, [NAME] | At-will staff for Mayor [NAME]
Parisot, [NAME] | At-will staff for Mayor [NAME] | 40
Reese, [NAME] | Director of Bureau of Police | 69
Ruiz, [NAME] | At-will staff for Mayor [NAME]
Saltzman, [NAME] | Commissioner | 135
Sandhu, Amreet | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Development Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Smith, [NAME] | Portland Planning Commission Member | 100
Uwagbae, Grace | At-will staff for Mayor [NAME]
Yocom, [NAME] | At-will staff for Mayor [NAME]
Spreadsheet: 60073d1260592788-cell-with-vlookup-needs-to-add-two-cells-sample-sheet
Sheet: January

January
Category | Code | Date | Transaction Description | Category | Conformation, Reciept, or Check # | Amount
Apples |  |  |  | Expense |  | 3
Peaches |  |  |  | Expense |  | 0
Oranges |  |  |  | Expense |  | 0
Apples |  |  |  | Expense |  | 2
Plums |  |  |  | Expense |  | 0
Apples |  |  |  | Expense |  | 0
Spreadsheet: 148452d1333413276-return-the-price-considering-id-of-the-item-and-ranking-that-should-fall-within-2-numbers-sample
Sheet: Sheet1

 | Inventory |  |  |  |  |  |  | Sold
ID | Price | Instock | End Stock | # [NAME] | # [NAME] |  | ID | Price | #Rank
123 | 5 | 5 |  | 0 | 5 |  | 123 | 5 | 1
123 | 7 | 5 |  | 5 | 10 |  | 123 | 5 | 2
145 | 12 | 3 |  | 0 | 1 |  | 123 | 5 | 3
 |  |  |  |  |  |  | 123 | 5 | 4
 |  |  |  |  |  |  | 123 | 5 | 5
 |  |  |  |  |  |  | 123 | 7 | 6
 |  |  |  |  |  |  | 145 | 12 | 1
Spreadsheet: 778351d1651013665-what-the-name-of-the-formula-for-counting-2-matching-criteria-data-count-question
Sheet: Sheet1

Data |  |  | Results
Type | Cost |  | Type | Cost | Amount
Apple | 1 |  | Apple | 1 | 2
Apple | 1 |  | Apple | 2 | 1
Apple | 2 |  | [NAME] | 1 | 1
[NAME] | 1 |  | [NAME] | 2 | 1
[NAME] | 2 |  | [NAME] | 3 | 1
[NAME] | 3
Spreadsheet: 60244d1260822220-inserting-text-into-spreadsheet-book4
Sheet: Sheet1

 |  | Tgt # | lon (w) | lon (w)
 |  | 1 | 147°41.659' | [NAME]
 |  | 2 | 147°39.707' | [NAME]
 |  | 3 | 147°39.433' | [NAME]
 |  | 4 | 147°39.476' | [NAME]39.476'
 |  | 5 | 147°39.402' | [NAME]
 |  | 6 | 147°39.450' | [NAME]39.450'
 |  | 7 | 147°42.629' | [NAME]
 |  | 8 | 147°42.524' | [NAME]
 |  | 9 | 147°42.288' | [NAME]42.288'
Spreadsheet: 701439d1603769130-salary-budget-report-sumifs-formula-salary-budget
Sheet: Actual Salaries

EMPLOYEE MONTHLY SALARY BUDGET
Employee Code Number | Employee Name | Desgnation | Date of Employment | Period | Actual Work Hours | [NAME] | Actual Overtime Hours | Actual Overtime Rate | Actual Benefits | Actual Bonus | Total Actual Salaries
CA1 | MARY | MANAGER | 1974-05-30 00:00:00 | 1 | 100 | 10 | 3 |  | 200 | 500
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 1 | 200 | 5 | 3 |  | 120 | 500
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 1 | 200 | 5 | 3 |  | 120 | 500
CA1 | MARY | MANAGER | 1974-05-30 00:00:00 | 1 | 100 | 10 | 4 | 15 | 120 | 500
CA1 | MARY | MANAGER | 1974-05-30 00:00:00 | 2 | 200 | 10 | 12 |  | 200 | 1000
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 2 | 200 | 5 | 12 |  | 120 | 500
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 2 | 200 | 5 | 12 |  | 120 | 500
CA1 | MARY | MANAGER | 1974-05-30 00:00:00 | 3 | 200 | 12 | 10 |  | 250 | 1200
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 3 | 200 | 7 | 10 |  | 200 | 700
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 3 | 200 | 7 | 10 |  | 200 | 700
Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: CREAC Sheet

 | CRE Appetite Compliance Summary | Compliant Yes /No
 | Borrower: |  | Mitigant / Explanation/ Commentary (by exception)
 | Prepared by:
 | Reviewed by:
 | Borrower Eligibility
1 | Customer Onboarding Check Sheet | Yes |  |  | Note:
 | Product Eligibility |  |  |  | Type Yes or No on items that comply with [NAME].
2 | Purpose | Yes |  |  | Any items not complying to be mitigated/ highlighted in credit paper
3 | Commercial Investment Property | Yes
4 | Senior Lender Eligibility Criteria | Yes
5 | Excluded Property | Yes
6 | Permitted Location | Yes
7 | Term not to exceed 5 years | Yes
8 | Base Case ICR | Yes
9 | Stressed Case DSCR | Yes
10 | [NAME] | Yes
11 | Minimum Return | Yes
12 | Variable - If not, explain | Yes
13 | Security | Yes
 | Credit Assessment
14 | Borrower grading | Yes
15 | Executive summary/ Sources & Uses | Yes
16 | Promoter/ Borrower | Yes
17 | Financial strength and cashflow sustainability | Yes
18 | Lending safety and security | Yes
19 | Risk assessment | Yes
20 | Overall strengths and weaknesses | Yes
21 | Conclusion/ Recommendation | Yes
22 | Appendices x6 | Yes
 | Finalised Pre - Drawdown
23 | Valuations
24 | Minimum Debt Yield
25 | Base Case ICR
26 | Stressed Case DSCR
27 | Entry LTV
28 | [NAME]
29 | LTVPV
30 | Borrower grading
31 | Insurance
32 | Loan Documentation
33 | Covenants & ongoing requirements
 | Compliance with CRE Appetite
 | Borrower Grading
 | Eligibility Criteria | Yes
 | Origination appetite
 | Note: The above table is based on the CRE Appetite Statement & Policy Version 4.4
Spreadsheet: tracy_geaccone__40252__C0366-112458
Sheet: Dept_100158

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
PHONE OPERATORS - Dept. 100158
April, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-04-23 00:00:00 | PHN2001/04-0366/112458 |  | Work Place | Work Place Count | 2 | 3.75 | /MO | 7.5
 |  |  |  |  |  |  | Ticket Total |  | 7.5
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 7.5
 |  |  |  |  |  |  | Total for Dept_100158 |  | 7.5
Spreadsheet: 860512d1708594724-converting-to-date-extract-no-datevalue-1-aligw
Sheet: Extract Number

1000
1000 | 1000
5000 | 5000
1 GB | 1
1 KG | 1
1 KG | 1
1 KG | 1
1.5 KG | 1.5
1.9 KG | 1.9
10 TAB | 10
10 TAB | 10
10 TAB | 10
10 TAB | 10
100 prs | 100
2 ROLLS | 2
2000 SHEETS | 2000
2000 SHEETS | 2000
250 GR | 250
3 KG | 3
5 TAB | 5
5 TAB | 5
500 SHEETS | 500
500 SHEETS | 500
500 SHEETS | 500
500 SHEETS | 500
500 SHEETS | 500
500 SHEETS | 500
500GR | 500
1500GR | 1500
512 MB | 512
512 MB | 512
750 GR | 750
Spreadsheet: 34138d1231266416-need-formula-to-return-value-instead-of-false-estimate
Sheet: Excel Quote Master

Whaley Foodservice Repairs, Inc.
PH: [PHONE]       FAX: [PHONE]
Estimate for Repairs
This estimate is for the location listed below.
This is only an estimate.  The actual cost at the time of repair may vary.
This estimate is in effect for 30 days from the "Date of Estimate."
Attention: |  |  |  | Date:
Phone # |  |  |  | Fax:
Location: |  |  |  | Make:
Street: |  |  |  | Description:
City: |  |  |  | Model:
State: |  | Zip: |  | Serial :
 |  |  |  | Rating:
Cust. PO# |  |  | Work Order #: |  |  | Technician
Quantity | Description |  |  |  |  |  | Unit | Total
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | Miscellaneous Charges |  |  |  |  | Parts sub-total |  | 0
0 |  | [NAME] | 0 |  |  | Tax |  | 0
0 |  | Disposal | 0 |  |  | Regular Shipping |  | 0
0 |  | Crane | 0 |  |  | Priority Shipping |  | 0
0 |  | CFC-EPA | 100 |  | PARTS TOTAL |  |  | 0
0 |  | Clamshell | 20 |  | Miscellaneous Charges |  |  | 0
0 |  |  |  | [NAME] | Hours |  | Travel | 0
 | Total Misc. |  | 0 |  |  | Labor in Job: Reg |  | 0
NOTE: |  |  |  |  |  | Labor in Job: O/T |  | 0
This job is quoted for normal business |  |  |  |  |  | Labor to Comp: [NAME] |  | 0
hours ( 8am - 5pm, Mon - Fri) unless otherwise |  |  |  |  |  | Labor to Comp: O/T |  | 0
noted.  All work prior to 8am or after 5pm will |  |  |  | TOTAL ESTIMATE: |  |  | 0
be charged at overtime rates.
Comments:
 |  |  |  |  |  | Date:
Quote Approved by: |  |  |  |  |  | Date:
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: MCronin

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 36748d1234671641-using-2-variables-to-return-multiple-items-from-multiple-sheets-2-variables-no-array
Sheet: Summary

 | Product | G | Select from Drop Down |  |  |  |  | (delete these comments)
 | Supply Less Than | 10
 |  |  |  |  |  |  |  | In this version, the array has
 | Store | Store Location | Supply | Available in Whse |  |  |  | been removed, and it starts
 | 1 | East St | OK | More than 10 |  |  |  | a complete list of all 25
 | 2 | 6th Ave | 14.58142501880557 | 6 |  |  |  | locations already visible in
 | 3 | Stafford | 11.91435650361798 | 7 |  |  |  | this sheet.  But Supply and
 | 4 | Manhattan | 20.78042457238807 | 1 |  |  |  | Available only populate based on
 | 5 | Ridgewood | 43.60657644043524 | 1 |  |  |  | the "less than" criteria. Any
 | 6 | Location6 | OK | More than 10 |  |  |  | with blanks are OK.
 | 7 | [NAME] | OK | More than 10
 | 8 | Location8 | OK | More than 10 |  |  |  | I changed the wharehouse count for
 | 9 | Location9 | OK | More than 10 |  |  |  | Product G, store 1 to 95 to show how
 | 10 | Location10 | OK | More than 10 |  |  |  | it returns "OK" instead
 | 11 | Location11 | OK | More than 10
 | 12 | Location12 | OK | More than 10 |  |  |  | Try product E, too
 | 13 | Location13 | OK | More than 10
 | 14 | Location14 | OK | More than 10 |  |  |  | See [NAME] (2) where we see how
 | 15 | Location15 | OK | More than 10 |  |  |  | to make the store # and location fields
 | 16 | Location16 | OK | More than 10 |  |  |  | go completely blank too if they are OK.
 | 17 | Location17 | OK | More than 10
 | 18 | Location18 | OK | More than 10
 | 19 | Location19 | OK | More than 10
 | 20 | Location20 | OK | More than 10
 | 21 | Location21 | OK | More than 10
 | 22 | [NAME] | OK | More than 10
 | 23 | Location23 | OK | More than 10
 | 24 | Location24 | OK | More than 10
 | 25 | Location25 | OK | More than 10
Spreadsheet: 866577d1713486487-not-transferring-employee-names-to-main-sheets-employee-absence-schedule
Sheet: December

 | Employee absence schedule
 | December
 | Absence type key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  | Dates of absence
 | Employee name | 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 days
 | [NAME]
 | [NAME]
 | Asaf Karten
 | [NAME]
 | [NAME]
Spreadsheet: 827396d1682668360-depend-dropdownlist-comboboxexample1
Sheet: Selections

Continent | Country | City
(Click below to enter)
Continent | Country | City
Asia | Thailand | Bangkok
North America | USA | Los Angeles
Africa | South Africa | Cape Elizabeth
North America | Canada | Montreal
Oceania | Australia | Sydney
Asia | Thailand | Bangkok
Europe | UK | London
Spreadsheet: 808587d1670524960-if-a-number-ends-in-x-change-that-digit-to-another-number-digitreplacement
Sheet: Sheet1

21 | 22
23 | 24
26 | 25
27 | 28
29 | 30
101 | 102
103 | 104
106 | 105
107 | 108
109 | 110