tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 165735d1341329859-finance-accruals-uk-retainer-billing2
Sheet: Previous Invoices FPR

Our Ref | Account Code | Transaction D | GL Code | Net Total Base | Currency | Net Total | Total | From | To |  | Account Code | Accending | To | Decending
SIN008616 | a | 24/05/2012 | 51010 | -15000 | £ | -15000 | -15000 | 01/04/2012 | 30/04/2012
SIN008673 | b | 25/06/2012 | 51010 | -10120.18 | $ | -16000 | -16000 | 01/07/2012 | 31/07/2012 |  |  |  |  |  | 1
SIN008462 | c | 23/03/2012 | 51010 | -36000 | £ | -36000 | -36000 | 24/03/2012 | 23/06/2012 |  |  |  |  |  | 1
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet28

 |  |  | Row Labels | Count of Status
 |  |  | Rejected (1st) | 52
 |  |  | Not Suitable | 42
 |  |  | Not Interested | 19
 |  |  | No Show | 17
 |  |  | Rejected-Online Test | 13
 |  |  | Duplicate | 13
 |  |  | Rejected (2nd) | 7
 |  |  | Offer Accepted | 6
 |  |  | Reschedule | 5
 |  |  | Not Yet Scheduled | 4
 |  |  | [NAME] | 3
 |  |  | Rejected (Final) | 2
 |  |  | Didn't join after selection | 1
 |  |  | Scheduled | 1
 |  |  | In Progress | 1
 |  |  | Grand Total | 186
Spreadsheet: 165347d1341190299-pivot-table-query-for-selective-data-pivot-table-query-answer
Sheet: Data

Period | Organisation | Sales
1.2012 | Japan | 100
1.2012 | Taiwan | 200
1.2012 | Malayasia | 300 |  | Organisation | Japan | <<Click here to get only Japan
2.2012 | Japan | 400
2.2012 | Taiwan | 500 |  | Sum of Sales
2.2012 | Malayasia | 100 |  | Period | Total | <<Click the dropdown to filter for 1st quarter and second quarter.
3.2012 | Japan | 200 |  | 1.2012 | 100
3.2012 | Taiwan | 300 |  | 2.2012 | 400
3.2012 | Malayasia | 400 |  | 3.2012 | 200
4.2012 | Japan | 500 |  | Grand Total | 700
4.2012 | Taiwan | 100
4.2012 | Malayasia | 200
5.2012 | Japan | 300
5.2012 | Taiwan | 400
5.2012 | Malayasia | 500
6.2012 | Japan | 100
6.2012 | Taiwan | 200
6.2012 | Malayasia | 300
Please see attached.
I need to get a pivot table for Quarter 1 (1.2012, 2.2012 and 3.2012)  sales for Japan Only
I need to get another pivot table for Quarter 2 (4.2012, 5.2012 and 6.2012)  sales for Japan Only
Spreadsheet: 702582d1604420517-index-match-multiple-criteria-sorting-issue-wip1
Sheet: Panels

Panel Name | Last Purchase Date | Source | Creds Purchased | Setup Fee | Per Cred cost | Transaction Total | Available Credits | Active Subs
Friday [NAME] | 2020-10-30 00:00:00 | Sir [NAME] | 50 | 5 | 1.75 |  | 50 | 0
Vstreams | 2020-09-06 00:00:00 | Sir [NAME] | 80 | 0 | 2.6 |  | 62.9 | 12
[NAME] | 2020-10-30 00:00:00 | [NAME] | 100 | 0 | 4.5 |  | 100 | 0
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: LIST

OFFICE
TELEVISIONS | REVOLABS
AMPLIFIERS & AV Receivers | POLYCOM
DVD PLAYERS & BLUE RAY DISC | AMX
POWER CONDITIONERS | LIFESIZE
STABILIZER | LOGITECH
HOME THEATRE SYSTEM | WIRE MANAGERS
[NAME] | VOL.CONTROLLERS
SPEAKERS | UPSCALERS
MIKES | MIXERS
CABLES | SHEETS
SUBWOOFERS | PC TO TV
SWITCHERS & MULTIPLIERS | STANDS & WALL MOUNTS BRACKETS
SCREEN GOO PAINTS | LAMPS
SCREENS | ACCESSORIES/SPARES
LUTRON | REPAIRS
OTHER ITEMS
Spreadsheet: 0f369882-65ea-4091-854b-7aef8d71b335
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflower | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 |  |  |  | Cents/pound
2001/02 | 16.46 | 17.98 | 23.25 | 23.45 | 32.23 | 19.14 | 13.55 | 13.87
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/121 | 53.5 | 55 | 86 | 58.5 | 98.5 | 58 | 53.25 | 52.25
2012/131 | 52.5-56.5 | 54.5-58.5 | 88.0-92.0 | 58.0-62.0 | 97.5-101.5 | 58.0-62.0 | 48.5-52.5 | 48.0-52.0
2010/11
October | 44.02 | 47.2 | 56 | 51.45 | 71.4 | 47.5 | 46.64 | 37
November | 47.62 | 50.75 | 63 | 53.63 | 75.13 | 51.96 | 37.32 | 41.75
December | 51.51 | 54 | 62.9 | 58.25 | 77.9 | 54.71 | 38.3 | 45
January | 53.84 | 55.92 | 74.125 | 59.5 | 80.06 | 57.91 | 48.5 | 50.1
February | 54.21 | 56.75 | 85.625 | 60.13 | 79.63 | 63.39 | 49.6 | 49.9
March | 54.07 | 55.5 | 96.75 | 60.25 | 77.5 | 67.72 | 52 | 51.75
April | 56.65 | 57.7 | 101.2 | 62.05 | 78.7 | 68.89 | 51.5 | 52.83
May | 56.09 | 56.06 | 103.75 | 60.19 | 82.81 | 68.33 | 54.31 | 53.87
June | 55.68 | 55.25 | 103.25 | 59.56 | 78.5 | 66.7 | 56.75 | 57.41
July | 55.16 | 54.75 | 97 | 60.7 | 88.05 | 62 | 63 | 60.89
August | 54.39 | 54.75 | 95 | 60 | 95.56 | 62 | 58.96 | 56.35
September | 55.13 | 55.35 | 94.8 | 58.45 | 97.5 | 57.95 | 61.33 | 59.28
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April1 | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2012-05-14 15:00:41.420000
Spreadsheet: 885903d1735824350-formula-to-extract-min-and-max-in-a-date-range-formula-to-extract-min-and-max-date-in-a-range
Sheet: Sheet1

Date
31/10/2024
30/11/2024
31/10/2024
30/11/2024
31/10/2024
31/10/2024
31/10/2024
31/10/2024
30/11/2024
30/11/2024
31/10/2024
30/11/2024
30/11/2024
31/10/2024
31/10/2024
31/10/2024
31/10/2024
30/11/2024
30/11/2024
Spreadsheet: 0464edbc-12c4-4c0b-97eb-53d524e95d61
Sheet: Sheet1

WIC ANNUAL COST ALLOCATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Period |  | to
Provider:
RFP No.:
ASO Log No. (As Applicable):
B U D G E T |  | Total | Administrative | Direct Client Services | Nutrition Education | Breastfeeding
C A T E G O R I E S
A. | PERSONNEL COST
 | 1.  Salaries
 | 2.  Payroll Taxes & Assessments
 | 3.  [NAME]
 | TOTAL PERSONNEL COST
B. | OTHER CURRENT EXPENSES
 | 1.  Airfare, Inter-Island
 | 2.  Airfare, Out-of-State
 | 3.  Audit Services
 | 4.  Contractual Services - Administrative
 | 5.  Contractual Services - Subcontracts
 | 6.  Insurance
 | 7.  Lease/Rental of Equipment
 | 8.  Lease/Rental of Motor Vehicle
 | 9.  Lease/Rental of Space
 | 10.  Mileage
 | 11.  Postage, Freight & Delivery
 | 12.  Publication & Printing
 | 13.  Repair & Maintenance
 | 14.  Staff Training
 | 15.  Substance/Per Diem
 | 16.  Supplies
 | 17.  Telecommunication
 | 18.  Transportation
 | 19.  Utilities
 | 20.  [NAME]
 | 21. Indirect Cost
 | 22.
 | 23.
 | TOTAL OTHER CURRENT EXPENSES
C. | EQUIPMENT PURCHASES
D. | MOTOR VEHICLE PURCHASES
TOTAL  (A+B+C+D)
 |  |  | Budget Prepared By:
SOURCES OF FUNDING
 | (a)  WIC |  | Name (Please type or print) |  |  | Phone
 | (b)
 | (c) |  | Signature of Authorized Official |  |  | Date
 | (d)
 |  |  | Name and Title (Please type or print)
 |  |  | For State Agency Use Only
TOTAL REVENUE
 |  |  | Signature of Reviewer |  |  | Date
Form WIC Annual (effective 10/01/10)
Spreadsheet: 143954d1330636097-sumproduct-spreadsheet-copy
Sheet: Summary

2012 | Monthly Totals |  | # of WFM Boxes |  |  |  |  | West Coast |  | East Coast |  | Broker |  | Event
 | AM | M | #1 | #2 | #3 | #4 |  | AM | M | AM | M | AM | M | AM | M
January
February
March
April
May
June
July
August
September
October
November
December
WFM Boxes: | 56 #1s, 1 #2
Individual Totals
Combined Totals
Spreadsheet: 82578d1282652043-countifs-in-two-columns-by-using-a-condition-in-3rd-column-demo-file
Sheet: Sheet1

Partner Name | Capacity | Source/Shelf/Slot/Port
B | STM-64 | YNBD1a/shelf3/s3
B | STM-64 | HJRD1b/shelf3/s3
J | STM-64 | YNBD1a/shelf3/s6
J | STM-64 | HJRD1b/shelf3/s6
M | [NAME] | YNBD1a/shelf1/s17
M | [NAME] | YNBD1a/shelf3/s1
M | [NAME] | YNBD1a/shelf3/s1
M | [NAME] | YNBD1a/shelf1/s17
M | STM-64 | YNBD1a/shelf2/s4
M | STM-64 | YNBD1a/shelf4/s1
M | STM-64 | YNBD1a/shelf1/s6
M | STM-64 | YNBD1a/shelf3/s12
M | [NAME] | YNBD1a/shelf3/s1
M | [NAME] | YNBD1a/shelf1/s17
Spreadsheet: 798071d1664290144-if-cell-is-65-or-less-than-another-return-value-example
Sheet: Sheet1

BATTERY AMPERAGE | TEST LEFT | TEST RIGHT |  | LEFT FAIL | RIGHT FAIL
7 | 4.12 | 6.58 |  |  |  | There would be 1 fail on the left
7 | 5.52 | 2.14 |  |  |  | There would be 1 fail on the right
50 | 42.36 | 12.35 |  |  |  | There would be 1 fail on the right
50 | 12.68 | 15.78 |  |  |  | Both left and right fail
50 | 38.96 | 25.25 |  |  |  | Right fails
50 | 49.56 | 44.52 |  |  |  | No Fails
 | 7AH Fails |  |  | <--- Count number of 7AH fails total
 | 50AH Fails |  |  | <--- Count number of 50AH fails total
 | A FAIL constitues if the test of either battery is less than 65% of the Battery Amperage
 | If there are NO entries in the left or right side, leave cell blank
Spreadsheet: 046dff07-fa6d-40c3-95b6-af53d2eb2ff5
Sheet: D2012

2012 Rank | NAME OF EMPLOYER | EMPLOYEES(1) | BUSINESS | 2011 Rank
1 | HARVARD UNIVERSITY | 11167 | HIGHER EDUCATION | 1
2 | MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 7824 | HIGHER EDUCATION | 2
3 | CITY OF CAMBRIDGE(2) | 2925 | GOVERNMENT | 3
4 | NOVARTIS INSTITUTE FOR BIOMEDICAL RESEARCH | 2276 | BIOTECHNOLOGY | 4
5 | MT. AUBURN HOSPITAL | 1731 | HEALTH CARE | 6
6 | BIOGEN IDEC | 1530 | BIOTECHNOLOGY | 8
7 | CAMBRIDGE INNOVATION CENTER(3,5) | 1453 | START UP INCUBATOR | --
8 | VERTEX PHARMACEUTICALS(4) | 1420 | BIOTECHNOLOGY | 5
9 | FEDERAL GOVERNMENT | 1226 | GOVERNMENT | 11
10 | DRAPER LABORATORY | 1214 | RESEARCH & DEVELOPMENT | 7
11 | MILLENNIUM PHARMACEUTICALS | 1212 | BIOTECHNOLOGY | 12
12 | GENZYME CORPORATION | 1148 | BIOTECHNOLOGY | 9
13 | CAMBRIDGE HEALTH ALLIANCE | 992 | HEALTH CARE | 10
14 | MICROSOFT | 913 | SOFTWARE DEVELOPMENT | 17
15 | PFIZER | 875 | BIOTECHNOLOGY | 15
16 | BROAD INSTITUTE | 872 | RESEARCH & DEVELOPMENT | 13
17 | AKAMAI TECHNOLOGIES | 849 | INTERNET TECHNOLOGY | 14
18 | GOOGLE(4,5) | 800 | SOFTWARE DEVELOPMENT | 26
19 | EF INTERNATIONAL | 739 | TRAVEL & EXCHANGE PROGRAMS | 18
20 | WHOLE FOODS | 678 | SUPERMARKET | 19
21 | FORRESTER RESEARCH | 604 | BUSINESS SERVICES | 20
22 | CAMP, DRESSER & MCKEE | 583 | ENGINEERING CONSULTANTS | 21
23 | PEGASYSTEMS | 565 | SOFTWARE DEVELOPMENT | 24
24 | RAYTHEON BBN TECHNOLOGIES | 564 | RESEARCH & DEVELOPMENT | 25
25 | SPAULDING HOSPITAL CAMBRIDGE | 498 | HEALTH CARE | 16
25 | LESLEY UNIVERSITY(5) | 498 | HIGHER EDUCATION | 28
Spreadsheet: 4515fb3d-c36f-438d-9839-107200f68281
Sheet: Classifica

 |  |  | Totale |  |  |  | In casa |  |  |  | Fuori casa |  |  |  | [NAME] |  |  | Media inglese
 | Squadra | Punti | Giocate | Vinte | Nulle | Perse | Giocate | Vinte | Nulle | Perse | Giocate | Vinte | Nulle | Perse | Fatte | [NAME] | Diff.
 | Genoa |  |  |  |  |  |  | 1 | 0 | 0 |  | 0 | 0 | 0
 | Milan |  |  |  |  |  |  | 0 | 0 | 0 |  | 1 | 0 | 0
 | Palermo |  |  |  |  |  |  | 1 | 0 | 0 |  | 0 | 0 | 0
 | Sampdoria |  |  |  |  |  |  | 0 | 0 | 0 |  | 1 | 0 | 0
 | Juventus |  |  |  |  |  |  | 1 | 0 | 0 |  | 0 | 0 | 0
 | [NAME] |  |  |  |  |  |  | 1 | 0 | 0 |  | 0 | 0 | 0
 | Parma |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 1 | 0
 | Udinese |  |  |  |  |  |  | 0 | 1 | 0 |  | 0 | 0 | 0
 | [NAME] |  |  |  |  |  |  | 0 | 1 | 0 |  | 0 | 0 | 0
 | Fiorentina |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 1 | 0
 | [NAME] |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 1 | 0
 | Inter |  |  |  |  |  |  | 0 | 1 | 0 |  | 0 | 0 | 0
 | Cagliari |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 1 | 0
 | Livorno |  |  |  |  |  |  | 0 | 1 | 0 |  | 0 | 0 | 0
 | Roma |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 1
 | Catania |  |  |  |  |  |  | 0 | 0 | 1 |  | 0 | 0 | 0
 | Napoli |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 1
 | Siena |  |  |  |  |  |  | 0 | 0 | 1 |  | 0 | 0 | 0
 | Atalanta |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 1
 | Chievo |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 1
 |  | Legenda
 |  |  | Campione d'Italia (accesso [NAME] "Champions League")
 |  |  | Accesso [NAME] "Champions League"
 |  |  | Preliminari di "Champions League"
 |  |  | "Europa League"
 |  |  | Retrocessione in Serie B
Spreadsheet: 886601d1736651370-create-a-vertical-array-from-a-table-create-a-vertical-array-from-a-table
Sheet: Sheet1

Equipment | Count |  | Equipment List
Photostat Machine | 5
Binding Machine | 1 |  | 2. Photostat Machine |  | Photostat Machine2 |  |  | 2.Photostat Machine
Desktop Computer | 2 |  | 3. Photostat Machine |  | Photostat Machine3 |  |  | 3.Photostat Machine
Refrigerator | 3 |  | 4. Photostat Machine |  | Photostat Machine4 |  |  | 4.Photostat Machine
Shredder | 2 |  | 5. Photostat Machine |  | Photostat Machine5 |  |  | 5.Photostat Machine
 |  |  | 1. Binding Machine |  | Binding Machine1 |  |  | 1.Binding Machine
 |  |  | 1. Desktop Computer |  | Desktop Computer1 |  |  | 1.Desktop Computer
 |  |  | 2. Desktop Computer |  | Desktop Computer2 |  |  | 2.Desktop Computer
 |  |  | 1. Refrigerator |  | Refrigerator1 |  |  | 1.Refrigerator
 |  |  | 2. Refrigerator |  | Refrigerator2 |  |  | 2.Refrigerator
 |  |  | 3. Refrigerator |  | Refrigerator3 |  |  | 3.Refrigerator
 |  |  | 1. Desktop Computer |  | Shredder1 |  |  | 1.Shredder
 |  |  | 2. Desktop Computer |  | Shredder2 |  |  | 2.Shredder
Spreadsheet: 4b39f5eb-8b6f-4710-b9d4-7a6aee114493
Sheet: RDS Adjustment

Baker Hughes Incorporated
Supplemental Financial Information
Reservoir Development Services Reclassification1
Segment Revenue |  |  | Q411 | Q311 | Q211 | Q111 | Q410 | Q310 | Q210 | Q110 | Q409 | Q309 | Q209 | Q109
 | North America |  | 7 | 5.400000000000091 | 4 | 6 | 7 | 3 | 5 | 6 | 5 | 4 | 5 | 3
 | Latin America |  | 2 | 2 | 2 | 1 | 3 | 3 | 0 | 1 | 2 | 1 | 1 | 2
 | Europe/Africa/Russia/Caspian |  | 12 | 13 | 11 | 11 | 13 | 11 | 9 | 12 | 14 | 12 | 9 | 6
 | Middle East/Asia Pacific |  | 12 | 3 | 12 | 5 | 6 | 4 | 4 | 5 | 6 | 4 | 3 | 3
 | Industrial Services |  | -33 | -23 | -29 | -23 | -29 | -21 | -18 | -24 | -27 | -21 | -18 | -14
Total |  |  | 0 | 0.4000000000000909 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Segment Profit Before Tax |  |  | Q411 | Q311 | Q211 | Q111 | Q410 | Q310 | Q210 | Q110 | Q409 | Q309 | Q209 | Q109
 | North America |  | -5 | -5 | -6 | -5 | -4 | -3 | -7 | -2 | 1 | -4 | -1 | -2
 | Latin America |  | -3 | 0 | 0 | -1 | -1 | 2 | -1 | 0 | 0 | 0 | -1 | 1
 | Europe/Africa/Russia/Caspian |  | 2 | -2 | -3 | -3 | 1 | 0 | -3 | -1 | -2 | -1 | -2 | -1
 | Middle East/Asia Pacific |  | 0 | -9 | -1 | 0 | -1 | -3 | -1 | -4 | 0 | -2 | -2 | -1
 | Industrial Services |  | 6 | 16 | 10 | 9 | 5 | 4 | 12 | 7 | 1 | 7 | 6 | 3
Total |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | The revenue and profit before tax of Reservoir Development Services have been reclassified from the Industrial Services segment into the geographic operating segments.  Quarterly segment revenue and profit before tax for the three years ended December 31, 2011 have been reclassified to reflect this change.
Spreadsheet: 813734d1673963776-drag-cells-and-go-every-2-cells-1-hd
Sheet: Sheet1

 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  | 1 | 2 | 3 | 4 | 5 | 6
Spreadsheet: 386077d1427572771-6-real-estate-analysis-questions-homework-real-estate-analysis
Sheet: Market Leasing - $22.00 Base Ye

 |  |  |  |  |  |  |  |  |  |  |  |  | Software: ARGUS Ver. 15.0.1.26
 |  |  |  |  |  |  |  |  |  |  |  |  | Property Type: Office & Retail
 |  |  |  |  |  |  |  |  |  |  |  |  | Portfolio:
 |  |  |  |  |  |  |  |  |  |  |  |  | Date: 11/19/14
 |  |  |  |  |  |  |  |  |  |  |  |  | Time: 8:10 am
 |  |  |  |  |  |  |  |  |  |  |  |  | Ref#: ATU
 |  |  |  |  |  |  |  |  |  |  |  |  | Page: 3
 |  |  | $22.00 Base Year
 |  |  | Market Leasing Assumption Results
 |  |  | In Inflated Dollars for the Fiscal Year Beginning 1/01/15
 |  | Year  1 | Year  2 | Year  3 | Year  4 | Year  5 | Year  6 | Year  7 | Year  8 | Year  9 | Year 10 | Year 11 | Year 12
For the Years Ending |  | Dec-2015 | Dec-2016 | Dec-2017 | Dec-2018 | Dec-2019 | Dec-2020 | Dec-2021 | Dec-2022 | Dec-2023 | Dec-2024 | Dec-2025 | Dec-2026
 |  | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________ | ___________
Renewal Probability |  | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
Market Rent | $/SqFt/Yr
 | New: | 22 | 23.5 | 25 | 25.5 | 26 | 26.5 | 27 | 27.5 | 28 | 28.5 | 29 | 29.5
 | Renewal: | 22 | 23.5 | 25 | 25.5 | 26 | 26.5 | 27 | 27.5 | 28 | 28.5 | 29 | 29.5
 | Result: | 22 | 23.5 | 25 | 25.5 | 26 | 26.5 | 27 | 27.5 | 28 | 28.5 | 29 | 29.5
Months Vacant | New: | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | Renewal: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rounded: | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Tenant Improvements | $/SqFt
 | New: | 20 | 20.6 | 21.22 | 21.85 | 22.51 | 23.19 | 23.88 | 24.6 | 25.34 | 26.1 | 26.88 | 27.68
 | Renewal: | 10 | 10.3 | 10.61 | 10.93 | 11.26 | 11.59 | 11.94 | 12.3 | 12.67 | 13.05 | 13.44 | 13.84
 | Result: | 13 | 13.39 | 13.79 | 14.21 | 14.63 | 15.07 | 15.52 | 15.99 | 16.47 | 16.96 | 17.47 | 18
Leasing Commissions | New: | 0.08 | 0.08 | 0.08 | 0.08 | 0.08 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
As % of Lease Years | Renewal: | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02
11 #'s significant | Result: | 0.052 | 0.052 | 0.052 | 0.052 | 0.052 | 0.026 | 0.026 | 0.026 | 0.026 | 0.026 | 0.026 | 0.026
Rent Abatements | New: | 5 | 4 | 3 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | Renewal: | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Result: | 4.3 | 3.3 | 2.3 | 1.3 | 0.3 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0
Non-Weighted Items
Rent Changes |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Retail Rent Changes
 | Reimbursements New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea New Base Yea
Term Lengths in Year |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
No Term Overrides
Spreadsheet: 872224d1718633015-formula-to-fetch-data-file_updated
Sheet: Master data

A | B | C | D | Ccy. | ID | Account No. | IBAN | Valid Until
100_EUR01 | 100 A | G | Ba1 | EUR | ANBPAFFPP/AT941810010134880900 | 10134880900 | AT941810010134880900 | UFN
101_EUR01 | 101 B | B | KP6 | EUR | [NAME] | 4221869693 | DE98512106004221869693 | UFN
103_EUR01 | 103 D | G | Lq3 | EUR | ANBPAFFPP/BE28001830653412EUR | [PHONE] | BE28001830653412 | UFN
113_EUR01 | 113 T | Z | MQE2 | EUR | XAZEHR2X/HR4423600001101234512-978 | 1101234512 | HR4423600001101234512 | UFN
120_EUR01 | 120 R | R | 9HZ | EUR | MBRZRRMM/MBRZRRMM/40702978000000931203/ | 40702978000000931203 |  | UFN
118_ZAR01 | 118 ZA | F | RMB2L | ZAR | BARNZZJJ/[PHONE] | 62839440392 |  | UFN
Spreadsheet: 881917d1730154677-checking-three-tables-for-name-to-macth-column-a-on-fourth-table-then-document-if-found-example-form
Sheet: Users

Username | Name | [NAME] | Status | alias1 | Cisco | [NAME] | ADFS
aaabbbb | [NAME] | [EMAIL] | Active
aaaccc | Ace Name | [EMAIL] | Active | Ace.is.the.best
aadd | Dis Name |  | Active
aaee | E Name |  | Active
bbcc | unknown | unknown | Active
ddaa | datablank |  | Active
Spreadsheet: 70aff6fa-1bd8-4a33-9b58-a2569647600e
Sheet: BA 6

Būvdarbu apjomu saraksts Nr.6
Specializētie darbi - ārējie tīkli, sistēmas
Lietus ūdens kanalizācijas tīkli.
(darba veids vai konstruktīvā elementa nosaukums)
Būves nosaukums :
Objekta nosaukums :  Automašīnu stāvlaukums ar kases māju jaunbūve
Objekta adrese :   ''Slodas'', [NAME] pagasts, Madonas novads
[NAME].
Nr.p.k. | Kods | Darba nosaukums | Mērvienība | Daudzums | Vienības izmaksas (Ls) | Summa (Ls)
6-1 |  | Lietus kanalizācija [NAME]
6-1-1 |  | Caurule dn200 pvc t8 montāža | m | 175
6-1-2 |  | Caurule dn250 pvc t8 montāža | m | 150
6-1-3 |  | Caurule dn315 pvc t8 montāža | m | 42
6-1-4 |  | Caurule dn400 pvc t8 montāža | m | 12
6-1-5 |  | Caurule dn560/400 rupniski izoleta pvc t8 montāža | m | 6
6-1-6 |  | Gala [NAME] | gb | 2
6-1-7 |  | Naftas atdalītājs Q=40l/s | gb | 1
6-1-8 |  | STORM N lietus ūdens nosed aka dn200/400/r40 H=1,7m | gb | 5
6-1-9 |  | STORM  lietus ūdens nosed aka dn250/630/r40 H=1,7m | gb | 10
6-1-10 |  | STORM PRO lietus ūdens nosed aka dn315/630/r40 H=1,7m | gb | 2
6-1-11 |  | Lietus [NAME]/r40 | gb | 20
6-1-12 |  | Čuguna lūkas apbetonešana dn700  0,2m3  z.z | gb | 2
6-1-13 |  | Čuguna [NAME] dn400  0,15m3  z.z | gb | 1
6-1-14 |  | Dz/bet grodu aka dn1500  h=1,3m | gb | 2
6-1-15 |  | [NAME] | gb | 1
6-1-16 |  | [NAME] | gb | 1
6-1-17 |  | [NAME] | gb | 3
6-1-18 |  | [NAME] trases [NAME] | m | 385
6-1-19 |  | K1 izlaide grāvi | gb | 1
6-1-20 |  | [NAME] | m3 | 670
6-1-21 |  | [NAME] blietējot | m3 | 610
6-1-22 |  | Smilts pabērums | m3 | 610
6-1-23 |  | Liekās zemes aizvešana | m3 | 610
6-1-24 |  | [NAME] ar pazemes komunikācijām | gb | 3
6-1-25 |  | Caurtekas d 500mm izbūve ieskaitot smilts pabērumu un caurtekas apbēršanu blietējot | m | 10
 |  | Kopā ārējie [NAME] tīkli :
 |  | Sastādija _____________________________________________________
 |  | (paraksts un tā atšifrējums,datums)
 |  | Pārbaudīja _______________________________________________________
 |  | (paraksts un tā atšifrējums,datums)
 |  | [NAME]._______________________
 |  | Piezīmes:
 | 1. | Būvdarbu tiešajās izmaksās ietver : būvmateriālu, būvkonstrukciju, palīgmateriālu, darba, mehānismu un transporta izmaksas.
 | 2. | Smilts, šķembu, melnzemes un liekās grunts un būvgružu apjomi doti blīvā veidā, neņemot vērā irdinājuma koeficientu.
 | 3. | [NAME] daudzums uzrādīts nepielāgojot patēriņa koeficientu.
Spreadsheet: 270694d1381592982-discount-calculation-wideearp_discount
Sheet: Sheet1

Cost | [NAME] | Sale Price | Gross Profit
100 | 0.5
 | Discount | Sale Price | Gross Profit
 | 0.08
 | Qty Sale | Gross Profit
 | 20 |  | no discount
 | 26.31578947368421 |  | with discount
 | Qty Sale | same profit
Spreadsheet: 167944d1342164921-i-want-to-send-data-in-multiple-workbook-projcet-22-expense-ledger
Sheet: Supplier-Sami

 |  |  |  |  |  | PROJECT # 22
 |  |  | Supplier-Sand |  |  | Mr.[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22000 | 33000 | -11000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A/C Ref #
DATE | B# | P# | L# | V# | A/C | Description | [NAME]# | Qty | Rate | Cheq#/PS | Bank | Book# | [NAME]# | Page# | Ledger# | DEBIT | CREDIT | BALANCE
2011-11-16 00:00:00 | 1 | 25 | CL-10 |  | Material | [NAME],[NAME] | 727 | 1 | 11000 |  |  |  |  |  |  |  | 11000 | -11000
2011-11-16 00:00:00 | 2 | 25 | CL-10 |  | Material | [NAME],[NAME] | 728 | 1 | 11000 |  |  |  |  |  |  |  | 11000 | -22000
2011-11-27 00:00:00 | 3 | 25 | CL-10 |  | Material | [NAME],[NAME] | 745 | 1 | 11000 |  |  |  |  |  |  |  | 11000 | -33000
2011-12-01 00:00:00 | V-01 | 25 | CL-10 |  | Payment | Cheque Paid |  |  |  | 57053500 | HMB | A-6 |  | 85 | BL-02 | 22000 |  | -11000