tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0000da82-026b-4cd6-aa11-f463422be589
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | Mærkningsskema |  |  |  | Dato | _______________________________________________
 |  |  |  |  |  | Sted/kultur | _______________________________________________
 |  |  |  |  |  | Mærket af | _______________________________________________
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Automatisk | [NAME]
Træart | Mærkefarve | Højde | Fra nr. | [NAME] nr. | Antal | Salgspris | Salg total | Bemærkninger
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 |  | 0
 | Automatisk | [NAME] | Automatisk
 |  | Omk./stk
Mærkning | 0 | 0 | 0
Anden omkst | 0 | 0 | 0
Transport | 0 | 0 | 0
Total |  |  | 0
DB i alt = | 0
Skovudstyr - Kalkulation
Spreadsheet: 82112d1282149076-hidden-format-akka02_demo
Sheet: old spreadsheet

year
1901 |  | concatenation |  |  | this formula works on the format text !
1902 |  | #N/A |  |  | V V V V
1903
1904 |  |  |  |  | 1904 hello
1905 |  |  |  |  | this works !
1906 |  | #N/A |  |  | this was the french formula !
1907
1908 |  |  |  |  | english version : take the ' away and change the ; maybe
1909 |  | #N/A |  |  | V V V V
1910 |  | problem
1911
1912 |  |  |  |  | since this formula works, with text, it proves there is an hidden format in the cells !
format cell = standard
this spreadsheet is coming from the past, yeah !
please have a look at the 2nd spreadsheet "new spreadsheet"
 |  | V V V V
 |  | V V V V
 |  | V V V V
 |  | V V V V
 |  | V V V V
 |  | V V V V
 |  | V V V V
Spreadsheet: 769266d1645443117-auto-populate-auto-populate
Sheet: DATA

Inventory ID | Name | Serial Number | Qty
45249 | BOX WHITE / KRAFT SBS | NL17187121 | 1
52605 | LAKE DOOR ASSEMBLY | NL17187121 | 1
52587 | LAKE FRONT HOUSING SUB-ASSEMBLY | NL17187121 | 1
52609 | LAKE REAR HOUSING ASSEMBLY | NL17187121 | 1
52666 | LABEL REGULATORY LAKE | NL17187121 | 1
52667 | LABEL INFORMATION BACK LAKE | NL17187121 | 1
54112 | User Manual, 1st | NL17187121 | 1
56224 | User manual, 2nd | NL17187121 | 1
16676-006 | Label Vinyl Wrap Around (3000/roll) | NL17187121 | 1
54071 | SHIPPING BOX LAKE | NL17187121 | 1
62815 | Label, Compat Ella Shipping Box | NL17187121 | 1
52613 | SCREW M2.5-1.40 X 12 PLASTITE 45 | NL17187121 | 4
52599 | SCREW M2.5-1.40 X 15.3 PLASTITE 45 | NL17187121 | 2
52596 | SCREW M2.0-1.35 X 8.0 PLASTITE 45 SELF TAPPING | NL17187121 | 11
54063-001 | LABEL SN NESTLE LAKE PUMP | NL17187121 | 6
54063-002 | LABEL SIDE BOX NESTLE LAKE (small label) | NL17187121 | 1
54063-003 | LABEL SHIPPER BOX NESTLE LAKE (Large label) | NL17187121 | 1
Spreadsheet: 25489172-f47b-4433-9d09-4e1877f2b929
Sheet: Table 8.3

Monthly Statistical Bulletin
8.3 Unemployment rates
 |  |  |  |  |  | Months (a)
 | Annual average (a) (b) |  |  |  |  |  | 2013
Country | 2009 | 2010 | 2011 | 2012 |  | Dec | Jan | Feb | Mar
Australia | 5.600000000000001 | 5.2 | 5.100000000000001 | 5.2 |  | 5.4 | 5.4 | 5.4
Canada | 8.3 | 8 | 7.5 | 7.2 |  | 7.100000000000001 | 7 | 7 | 7.2
France | 9.5 | 9.700000000000001 | 9.6 |  |  | 10.6 | 10.7 | 10.8
Germany | 7.8 | 7.100000000000001 | 6 | 5.5 |  | 5.4 | 5.4 | 5.4
Italy | 7.8 | 8.4 | 8.4 | 10.7 |  | 11.2 | 11.7 | 11.6
Japan | 5.100000000000001 | 5.100000000000001 | 4.600000000000001 | 4.4 |  | 4.3 | 4.2 | 4.3
New Zealand (c) | 6.100000000000001 | 6.5 | 6.5 | 6.9 |  | 6.9
United Kingdom | 7.600000000000001 | 7.8 | 8 | 7.9 |  | 7.7
United States | 9.3 | 9.6 | 9 | 8.1 |  | 7.8 | 7.9 | 7.7 | 7.600000000000001
OECD average | 8.1 | 8.3 | 8 | 8 |  | 8 | 8.1 | 8
G7 average | 8.03 | 8.19 | 7.67 | 7.42 |  | 7.3 | 7.4 | 7.3
Euro-zone average | 9.6 | 10.14 | 10.13 | 11.35 |  | 11.8 | 12 | 12
(a) Unemployment as a percentage of labour force.
(b) Years shown are calendar years.
(c) Data only available quarterly.
(d) monthly data seasonally adjusted
Note: Unemployment rates shown above have been adjusted as necessary by the OECD
to conform to international definitions and to ensure consistency over time.
Sources: Datastream
 |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | Late May 2013
Spreadsheet: 726769d1617442201-sumifs-function-doesnt-calculate-values-as-expected-accounting-module
Sheet: Solid Assets

 | ASSETS
 | Slicer to filter data by Account Titles is in this cell.
 | G/L Code | Account Title | January | February | March | April | May | June | July | August | September | October | November | December | Total
 | KND007 | Computers
 | KND008 | Furniture
 | KND016 | Car
 | KND017 | Motor Bike
 | Total
Spreadsheet: 188240d1350764274-lookup-formula-values-in-order-workbook-31
Sheet: Sheet2

Location | Manager | Service | Frequency |  |  | Location | Manager | Service | Frequency
[NAME] | Greg | GRU | Quarterly |  |  | [NAME] | Greg | GRU | Quarterly
Dunham | [NAME] | GR | Monthly |  |  | Dunham | [NAME] | GR | Monthly
 | [NAME] | COR | Quarterly |  |  | [NAME] | [NAME] | ART | Quarterly
 | [NAME] | GRU | Monthly |  |  | Helenville | [NAME] | TIP | Quarterly
[NAME] | [NAME] | ART | Quarterly |  |  | [NAME] | Franklin | TYI | Quarterly
 | [NAME] | KKO | Quarterly
Helenville | [NAME] | TIP | Quarterly
[NAME] | Franklin | TYI | Quarterly
 | Greg | TRE | Monthly
Spreadsheet: 62260d1263238049-open-text-file-into-excel-template-pmw-performance-management
Sheet: Performance Management

2010 PERFORMANCE MANAGEMENT WORKSHEET
(January 1, 2009 through December 31, 2009)
Eligible Employees:  Regular Employee Status; Hired Before October 1, 2009
Location: PN100
Location Description: General Office UBC 100
REGION | EE ID | LAST | FIRST | TITLE | EE Status | FT/PT | FLSA | HIRE DATE | MANAGER | LOC ID | [NAME] | LOCATION/RESPONSIBLE MANAGER | OVERALL PERFORMANCE RATING (use drop down) | COMMENTS
PMW | 032057 | Sutherland | [NAME] | Driver - CDL | S | Full-Time | Nonexempt | 2009-05-01 00:00:00 | Vandermolen,[NAME] | PN564 | Fremont 564 | Wagner,[NAME]
Spreadsheet: 863456d1710941171-sumifs-formula-exp-track-test
Sheet: gl

Requisition Name | Period | Fund | Account | Sub System Amount
18-0033 | 5 | 109555 | 56011 | 7528.56
18-0033 | 6 | 109555 | 55003 | 9885
18-0033 | 5 | 109555 | 55003 | 9885
18-0033 | 3 | 109555 | 56011 | 29217.17
18-0033 | 6 | 109555 | 56011 | 33287.28
18-0033 | 2 | 109555 | 56011 | 43112.67
18-0033 | 4 | 109555 | 56011 | 49147.46
18-0033 | 1 | 109555 | 56011 | 77955
18-0033 | 1 | 109555 | 56011 | 110570.64
19-0482 | 3 | 109555 | 56011 | 500
19-0482 | 2 | 109555 | 55009 | 663
19-0482 | 6 | 109555 | 56011 | 760
19-0482 | 3 | 109555 | 55009 | 786
19-0482 | 4 | 109555 | 55009 | 840
19-0482 | 5 | 109555 | 55009 | 959
19-0482 | 5 | 109555 | 55009 | 959
19-0482 | 2 | 109555 | 56902 | 982
19-0482 | 4 | 109555 | 56011 | 1279.11
19-0482 | 3 | 109555 | 55009 | 1715.8
19-0482 | 3 | 109555 | 55009 | 1814.4
19-0482 | 3 | 109555 | 55009 | 1824
19-0482 | 4 | 109555 | 55009 | 2451.25
19-0482 | 5 | 109555 | 55009 | 2637
19-0482 | 3 | 109555 | 56011 | 3180
19-0482 | 3 | 109555 | 56011 | 4500.57
19-0482 | 3 | 109555 | 56011 | 4586.71
19-0482 | 3 | 109555 | 55009 | 5700.8
19-0482 | 4 | 109555 | 56115 | 7425
19-0482 | 2 | 109555 | 56011 | 10232.82
19-0482 | 4 | 109555 | 55009 | 65000
19-0482 | 1 | 109555 | 56011 | 104645.24
19-0482 | 4 | 109555 | 56011 | 119938.7
19-0482 | 2 | 109555 | 56011 | 120228.55
19-0482 | 4 | 109555 | 56011 | 131172.73
19-0482 | 3 | 109555 | 56011 | 132776.01
19-0482 | 6 | 109555 | 56011 | 167515.5
19-0482 | 5 | 109555 | 56011 | 199997.23
19-0482 | 1 | 109555 | 56011 | 326282.2
23-0236 | 2 | 109556 | 56011 | 1492.3
23-0236 | 1 | 109556 | 56011 | 4240.32
Spreadsheet: 174316d1345018356-using-a-table-as-clickable-data-source-clickcell
Sheet: Sheet1

Table |  |  |  |  |  | value of clicked cell | multiply by | result
1 | 100 | 1000 |  |  |  |  | 2
2 | 101 | 1001
3 | 102 | 1002
4 | 103 | 1003
5 | 104 | 1004 |  |  |  | Click anywhere in the Table, then hit F9
6 | 105 | 1005
7 | 106 | 1006
8 | 107 | 1007
9 | 108 | 1008
10 | 109 | 1009
Spreadsheet: 78583d1278957080-formatting-cells-based-on-other-cell-values-finance-20spreadsheet-20v2-1-
Sheet: All History

 | Transaction
Date (dd/mm/yy) | In (£) | Out (£) | Details/Description | Previous Balance (£) | Current Cleared Balance(£) | Month
2010-06-01 00:00:00 | 20
2010-06-07 00:00:00 | 62
2010-06-11 00:00:00 |  | 59.6
2010-06-14 00:00:00 |  | 1.07
2010-06-14 00:00:00 |  | 7.49
2010-06-15 00:00:00 | 25
2010-06-16 00:00:00 |  | 1
2010-06-21 00:00:00 |  | 10
2010-06-21 00:00:00 |  | 7.47
2010-06-25 00:00:00 | 15 | 0
2010-07-01 00:00:00 | 1000
2010-07-02 00:00:00 |  | 500
Spreadsheet: 849308d1699836633-help-calculate-values-from-a-previous-range-example
Sheet: Sheet1

2023-08-04 00:00:00 | 45
2023-08-04 00:00:00 | 45
2023-08-04 00:00:00 | 45
2023-08-07 00:00:00 | 10 | 0.25
2023-08-07 00:00:00 | 10 | 0.25
2023-08-08 00:00:00 | 20 | 2
2023-08-08 00:00:00 | 20 | 2
2023-08-09 00:00:00 | 5 | 0.25
2023-08-09 00:00:00 | 5 | 0.25
2023-08-09 00:00:00 | 5 | 0.25
2023-08-09 00:00:00 | 5 | 0.25
2023-08-10 00:00:00 | 2 | 0.4
2023-08-10 00:00:00 | 2 | 0.4
Spreadsheet: 733369d1621529374-cancelling-negatives-and-positives-book1
Sheet: Sheet1

# | ABS | Balance
600
-600
600
-600
-610
-660
660
-660
-1500
1500
-1500
1500
-3200
3200
-3200
-150
150
580
-900
900
Spreadsheet: 796688d1663438421-how-to-display-a-result-if-all-the-data-in-a-row-from-table1-and-table2-match-classeur2
Sheet: Feuil1

Branche | Ex1 | Ex2 | Ex3 | Table 1 |  |  |  |  |  | Ex1 | Ex2 | Ex3 | Table 2
 | 1 | 18 | 23 |  |  |  |  |  |  | 12 | 20 | 20
 | 14 | 22 | 28 |  |  |  |  |  |  | 4 | 4 | 4
 | 1 | 18 | 12 |  |  |  |  |  |  | 1 | 18 | 12
 | 0 | 0 | 0 |  |  |  |  |  |  | 12 | 2 | 2
Expected results
Branche | Ex1 | Ex2 | Ex3 | Table3
 | 1 | 18 | 23
 | 14 | 22 | 28
BR | 1 | 18 | 12
 | 0 | 0 | 0
Spreadsheet: 456253d1460719130-concatenate-n-1-to-same-values-in-column-conc-new
Sheet: people

Old | New | Name |  | New
ABE |  | [NAME]
ADI |  | [NAME]
ADM |  | A dministrator
AH |  | [NAME]
AIKA |  | Aiko Kalvo
AK |  | Aggro Kalno
IT |  | [NAME]
ITA |  | Ieva Targale
IUR |  | [NAME]
Spreadsheet: 007c9430-2ab2-45e4-a57b-98611713e3e0
Sheet: Sheet1

Agency | Name | Phone Number | E-mail address | Name.1 | Phone Number.1 | E-mail address.1 | Name.2 | Phone Number.2 | E-mail address.2
Aging | [NAME] | 783-5166 | [EMAIL] | [NAME] | 783-8613 | [EMAIL]
Agriculture | [NAME] Smyser | 787-1065 | [EMAIL] | [NAME] | 787-1065 | [EMAIL] | Ericka Warner | 787-1065 | [EMAIL]
Banking & Securities | [NAME] | 783-3611 | [EMAIL]
Civil Service Commission | [NAME] | 783-2691 | [EMAIL]
Community and Economic Development | [NAME] | 783-0331 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Conservation and Natural Resources | [NAME] | 346-3962 | [EMAIL] | [NAME] | 705-3741 | [EMAIL]
Corrections | [NAME] | 728-5355 | [EMAIL] | [NAME] | 728-5351 | [EMAIL]
Drug & Alcohol Programs | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Education | [NAME] | 783-9343 | [EMAIL]
Environmental Protection | Renata E. Moseley | 787-8476 | [EMAIL]
Executive Offices | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Fish And Boat Commission | [NAME] | 705-7825 | [EMAIL]
Game Commission | [NAME] | 787-7836 | [EMAIL]
General Services | [NAME] | 783-0828 | [EMAIL]
Governor's Office | [NAME] | 787-5330 | [EMAIL]
Health | [NAME] | 547-3185 | [EMAIL] | [NAME] | 547-3197 | [EMAIL]
Historical & Museum Commission | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Insurance | [NAME] | 787-8027 | [EMAIL]
Labor & Industry | [NAME] | 787-2453 | [EMAIL]
Lieutenant Governor's Office | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Liquor Control Board | [NAME] | 783-9853 | [EMAIL]
Military and Veterans Affairs | [NAME] | 861-8850 | [EMAIL] | [NAME] | 861-6372 | [EMAIL]
Milk Marketing Board | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Municipal Retirement Board | [NAME] | 787-2065 | [EMAIL]
PA Emergency Management Agency | [NAME] | 651-2018 | [EMAIL]
PA Human Relations Commission | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Pennvest | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Probation And Parole Board | [NAME] | 787-5699 x1348 | [EMAIL]
Psers | [NAME] | 720-4738 | [EMAIL] | [NAME] | 720-4739 | [EMAIL]
Public Utility Commission | [NAME] | 787-8714 | [EMAIL]
Public Welfare | [NAME] | [PHONE] | [EMAIL] | [NAME] | 525-5477 | [EMAIL]
Revenue | [NAME] | 787-2709 | [EMAIL] | [NAME] | 787-2709 | [EMAIL]
State | [NAME] | 783-9274 | [EMAIL] | [NAME] | 787-6604 | [EMAIL]
State Emp Retirement Board | [NAME] | 237-0242 | [EMAIL] | [NAME] | 237-0265 | [EMAIL]
State Police | [NAME] | 787-6941 | [EMAIL] | [NAME] | 783-5547 | [EMAIL]
State Tax Equalization Board | [NAME] | 783-0331 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Transportation | [NAME] | 783-0331 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Turnpike | [NAME] | 831-7243 | [EMAIL]
Revised 7/30/14
Spreadsheet: 172176d1344013835-need-formula-for-tiered-interest-in-excel-tiered-interest-day92
Sheet: Sheet1

Date | Deposits | Results |  |  | Table |  | Interest
2012-06-30 00:00:00 | 6000 |  |  | 5000 | to | 10000 | 0.0005
2012-07-07 00:00:00 | 12000 |  |  | 10001 | to | 20000 | 0.00575
2012-07-16 00:00:00 | 6000 |  |  | 20001 | to | 50000 | 0.01
2012-07-16 00:00:00 | 2000 |  |  | 50001 | to | 100000 | 0.015
2012-07-18 00:00:00 | 100000 |  |  | 100001 | to | 200000 | 0.0175
2012-07-18 00:00:00 | 47000 |  |  | 200001 |  | 500000 | 0.02
2012-07-25 00:00:00 | 300000 |  |  | 500001 |  |  | 0.025
2012-07-25 00:00:00 | 95000
2012-07-29 00:00:00 | 720000
Spreadsheet: 157239d1337679555-finding-the-overall-average-value-in-excel-kg1
Sheet: Sheet1

 | Here is my case…!
 | Here there are two records. Row 1 and Row 2. Each contains six variables A,B,C,D,E and F
 | I am finding the FINAL VALUE for each record through various steps (finding F, G, H, I,J,K and then finally the FINAL VALUE)
 | Now, the simple addition of two FINAL VALUES (N12 and N13) gives a answer (N15) whereas if we apply the formula
 | it gives the value (N14). Both values are differing in 4th or 5th decimal. It should be same for me. Tell me how to get it.
 | Record | Raw data |  |  |  |  | Calculated data
 |  | A | B | C | D | E | F | G | H | I | J | K | FINAL VALUE
 | 1 | 19568 | 27 | 7650 | 600 | 16506 | 13.01815760188235 | 76500 | 1267.921352988792 | 40 | 67.72 | 0.9430847081237098 | 13.86603925317668
 | 2 | 19892 | 27 | 7650 | 600 | 16498 | 13.23370763576471 | 76500 | 1246.664990196201 | 40 | 67.72 | 0.9456420192437965 | 14.13385055310746
 | Summary | 19730 | 27 | 7650 | 1200 | 16502 | 13.12593261882353 | 153000 | 1257.205905227256 | 40 | 67.72 | 0.9443792665450674 | 28.00005003083409 | Obtained by applying formula
 |  |  |  |  |  |  |  |  |  |  |  |  | 27.99988980628414 | Obtained by adding two KG from two rows
 | Use of Variables in each formula column | -- | -- | -- | -- | -- | A,B,C | C,D | E,F | -- | I | H,J | F,G,I,K
 | You can click each cell to see the formula I have used
Spreadsheet: 706565d1606772105-match-formula-formula-help
Sheet: Adj Prices

OC | API | FG-ASJ | 0.5 | 0.5 | 1.05 | 0.648 | 0.6804
OC | API | FG-ASJ | 0.5 | 1 | 1.27 | 0.648 | 0.82296
OC | API | FG-ASJ | 0.5 | 1.5 | 2.41 | 0.648 | 1.56168
OC | API | FG-ASJ | 0.5 | 2 | 3.74 | 0.648 | 2.42352
OC | API | FG-ASJ | 0.5 | 2.5 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.5 | 3 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.5 | 3.5 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.5 | 4 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.5 | 4.5 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.5 | 5 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.5 | 5.5 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.5 | 6 | N/A | 0.648 | N/A
OC | API | FG-ASJ | 0.75 | 0.5 | 1.19 | 0.648 | 0.77112
OC | API | FG-ASJ | 2 | 1 | 1.39 | 0.648 | 0.90072
OC | API | FG-ASJ | 0.75 | 1.5 | 2.42 | 0.648 | 1.56816
OC | API | FG-ASJ | 0.75 | 2 | 3.86 | 0.648 | 2.50128
Spreadsheet: 742110d1627542717-my-index-match-is-broken-planning-file-excel-test
Sheet: Dashboard

Week Number |  | 31 |  |  |  |  |  |  |  | Flea = 30 Days Supply | 30
 |  |  |  |  |  |  |  |  |  | [NAME] = 120 Day Supply | 90
Item Code | Product Name | Lead Time | Weeks Cover | New Order Due | Stock Hold Cover | Av. Expected Weekly Sales | MOQ | Case QTY | Valid
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
 |  | 10 | 4 |  |  |  | 150 | 1
Spreadsheet: 5f26f016-325f-483c-b42c-ab65344b1720
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: |  |  | 2011-06-02 09:38:22.140000
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.75 | 101.635 | 101.51 | 101.385 | 101.01 |  | and are added to price quote
4.625 | 100.762 | 100.637 | 100.512 | 100.137
4.5 | 100.273 | 100.148 | 100.023 | 99.648 |  | Note: | Refer To Price [NAME]
4.375 | 99.712 | 99.587 | 99.462 | 99.087 |  |  | For all Price Adjs
4.25 | 98.648 | 98.523 | 98.398
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.642 | 101.517 | 101.392 | 101.017
4 | 101.322 | 101.197 | 101.072 | 100.697
3.875 | 100.929 | 100.804 | 100.679 | 100.304
3.75 | 100.359 | 100.234 | 100.109 | 99.734
3.625 | 99.23 | 99.105 | 98.98
 |  |  |  |  |  | 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 | 2011-06-16 09:38:22.140000
30 DAY | 2011-07-01 09:38:22.140000
45 DAY | 2011-07-16 09:38:22.140000
60 DAY | 2011-07-31 09:38:22.140000
90 DAY | 2011-08-30 09:38:22.140000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 159269d1338564473-sort-data-with-formula-example-sorting-table
Sheet: Sheet1

 | Supplier name | Shipment number | Date | Volume |  |  |  | Date | Supplier name | Volume
 | Supplier 1 | Shipment 1 | Jan | 10 |  |  |  | Nov | Supplier 3 | 20
 | Supplier 1 | Shipment 2 | Mar | 12 |  |  |  | Mar | Supplier 1 | 12
 | Supplier 1 | Shipment 3 | Apr | 8 |  |  |  | Jan | Supplier 1 | 10
 | Supplier 1 | Shipment 4 | Dec | 7 |  |  |  | Jan | Supplier 1 | 10
 | Supplier 2 | Shipment 1 | Jan 13 | 5 |  |  |  | Mar | Supplier 3 | 9
 | Supplier 2 | Shipment 2 | Apr | 3 |  |  |  | Apr | Supplier 1 | 8
 | Supplier 3 | Shipment 1 | Feb | 6 |  |  |  | Dec | Supplier 1 | 7
 | Supplier 3 | Shipment 2 | Mar | 9 |  |  |  | Feb | Supplier 3 | 6
 | Supplier 3 | Shipment 3 | Apr | 10 |  |  |  | Jan 13 | Supplier 2 | 5
 | Supplier 3 | Shipment 4 | Nov | 20 |  |  |  | Apr | Supplier 2 | 3
 | Supplier 3 | Shipment 5 | Dec | 2 |  |  |  | Dec | Supplier 3 | 2
Spreadsheet: 3b1ff14c-79a5-453f-bf0b-d3ca663c9ff1
Sheet: UW-Home

[NAME] |  |  |  |  |  | UW-Home
Insurance Company: | Insert Company Name
Effective Date: | MM/DD/YYYY
Actual SC Direct | Year | % of Premium | Year | % of Premium | Year | % of Premium
Earned Premium
Incurred Losses
Incurred LAE
Incurred U/W Expenses
U/W Results
Actual SC Net of Reinsurance | Year | % of Premium | Year | % of Premium | Year | % of Premium
Earned Premium
Incurred Losses
Incurred LAE
Incurred U/W Expenses
U/W Results
Insurer Notes:
Notes:
1.  Use South Carolina calendar year data
2.  Provide latest three years of data
Spreadsheet: 011c94ba-ae3a-424b-aae1-3b5886d45cae
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 82. Value of Building Approved, Chain Volume Measures, Original - South Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total houses ;  New ; |  |  | Original | A590507C | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total other residential building ;  New ; |  |  | Original | A590508F | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  New ; |  |  | Original | A590509J | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590510T | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590511V | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590512W | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590513X | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 276029d1383733437-rather-complicated-lookup-problem-containing-2-linked-sheets-index-and-match
Sheet: Request

 |  | After selecting the 'Matter', the following 3 cells should be filled in with the corresponding information from 'Authorisation' automatically
 |  |  | This should say a number
 |  |  | fromt the authorisation sheet.
 |  |  | (Like 2.500)
Approved | Function | Matter | Autorisation | Reports | Function
by |  |  | level | to
Person 2 |  | Expense reports |  | Chief 2 | Production manager 2
Person 29 |  | Raw material & supplies production |  | Chief 29 | Production manager 29
Person 43 |  | Debit and credit memo's
Select person
Select person
Select person
Select person