tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6fb6ed63-112e-4704-bb0f-6694d3ea4e92
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: |  |  | 2014-05-15 09:24:25.790000
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 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.85 | 102.725 | 102.6 | 102.225
4.5 | 102.763 | 102.638 | 102.513 | 102.138 |  | Note: | Refer To Price [NAME]
4.375 | 102.282 | 102.157 | 102.032 | 101.657 |  |  | For all Price Adjs
4.25 | 101.674 | 101.549 | 101.424 | 100.799
4.125 | 100.82 | 100.695 | 100.57 | 99.945
4 | 99.807 | 99.682 | 99.557 | 98.932
3.875 | 98.754 | 98.629 | 98.504 | 97.879
3.75 | 97.879 | 97.754 | 97.629 | 97.004
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.688 | 102.563 | 102.438 | 102.063
3.625 | 102.543 | 102.418 | 102.293 | 101.918
3.5 | 101.991 | 101.866 | 101.741 | 101.366
3.375 | 101.263 | 101.138 | 101.013 | 100.388
3.25 | 100.516 | 100.391 | 100.266 | 99.641
3.125 | 99.944 | 99.819 | 99.694 | 99.069 |  | 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 | 2014-05-29 09:24:25.790000
30 DAY | 2014-06-13 09:24:25.790000
45 DAY | 2014-06-28 09:24:25.790000
60 DAY | 2014-07-13 09:24:25.790000
90 DAY | 2014-08-12 09:24:25.790000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: ab46dc87-2d62-4543-a0eb-9468ae5a2d6a
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
COUNTRY |  | : | BRUNEI
SEASON |  | : | 01JAN12 - 31DEC12
CURRENCY |  | : | BRD
TAX RATE |  | :
RATE CODE |  | : |  |  | R3 | R3 | R3 | R3 | R3 | R3 | R3 | R3 | R3 | R3
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ADD | 1 | ADD
GRP | CODE | CAR TYPE (OR SIMILAR) |  |  | DAY | DAYS | DAYS | DAYS | DAYS | DAYS | DAYS | DAYS | MONTH | KM
B | EDMR | HYUNDAI ACCENT [AC] |  |  | 63 | 126 | 189 | 252 | 315 | 378 | 378 | 63 | 1512 | 0
C | CCAR | TOYOTA VIOS 1.5 [A][AC] |  |  | 67 | 134 | 201 | 268 | 335 | 402 | 402 | 67 | 1608 | 0
D | CDAR | [NAME] |  |  | 73 | 146 | 219 | 292 | 365 | 438 | 438 | 73 | 1752 | 0
E | IDAR | NISSAN BLUEBIRD SYLPHY 1.8 [A][AC] |  |  | 77 | 154 | 231 | 308 | 385 | 462 | 462 | 77 | 1848 | 0
 | BOOKING REQUIREMENTS |  |  |  |  |  | RATE SPECIFICATION
* | RATE IS AWD DEPENDENT |  |  |  |  | * | RATE INCLUDES   : |  |  | UNLIMITED MILEAGE CDW
 |  |  |  |  |  | * | RATE EXCLUDES   : |  |  | ALL OTHER SERVICES NOT INCLUDED ABOVE
* | RESERVATION AND VOUCHER MUST STATE RATE |  |  |  |  | * | MINIMUM RENTAL  : |  |  | AS SHOWN
 | NAME AND RATE CODE
* | CONSULT AVIS RESERVATIONS FOR ONE WAY |  |  |  |  | * | NOTES           : |  |  | NON-WAIVABLE INSURANCE EXCESS CHARGES APPLY
 | RENTAL AVAILABILITY AND FEES |  |  |  |  |  |  |  |  | ADDITIONAL SERVICES THAT MAY APPLY ARE:
 |  |  |  |  |  |  |  |  |  | PETROL/REFUELLING CHARGE, ADDITIONAL INSURANCES/WAIVERS
 |  |  |  |  |  |  |  |  |  | GOVERNMENT SURCHARGES, AIRPORT/CITY SURCHARGES
 |  |  |  |  |  |  |  |  |  | [NAME],SPECIAL EQUIPMENT
 |  |  |  |  |  |  |  |  |  | OTHER (SEE REFERENCE RACK / CONTRACT)
Spreadsheet: 116207d1311676733-need-help-with-sorting-using-formulas-forum-sort
Sheet: DATA & RESULTS

PEOPLE | TOWN VISITED
AA | 0 |  | RESULTS
AA | _x000C_ |  | 0 | I | A | D | S | L | V | Q | E | R | C | _x000C_
AA | D |  | AA | AA | AT | AA | EL | LA | CK |  | AA |  |  | AA
AA | E |  | AI | AI | AI | EL | JN | PK | EL |  | EE |  |  | EL
AA | I |  | AM | AN | AM | EO | LA |  | GS |  | FN |  |  | EO
AI | 0 |  | AN | AV | BA | LA | LW |  | JH |  | LA |  |  | GT
AI | A |  | AT | BC | CD | SP | RM |  | JN |  |  |  |  | JB
AI | I |  | AV | CD | DA | YW |  |  | PB |  |  |  |  | LA
AM | 0 |  | BA | CK | EA |  |  |  | PK |  |  |  |  | LW
AM | A |  | BC | DA | EL |  |  |  |  |  |  |  |  | PB
AN | 0 |  | CD | DC | EL |  |  |  |  |  |  |  |  | SD
AN | I |  | CK | DD | FA |  |  |  |  |  |  |  |  | SO
AT | 0 |  | DA | EE | GA |  |  |  |  |  |  |  |  | YW
AT | A |  | DB | EL | GO
AV | 0 |  | DC | EL | JA
AV | I |  | DD | EL | JB
BA | 0 |  | DH | EO | JG
BA | A |  | EA | FB | LM
BC | 0 |  | EA | FN | LW
BC | I |  | EE | FT | MD
CD | 0 |  | EL | GA | PB
CD | A |  | EL | GO | RB
CD | I |  | EL | GS | RM
CK | 0 |  | EO | GT | SO
CK | I |  | FA | IO
CK | V |  | FB | IS
DA | 0 |  | FN | JB
DA | A |  | FT | JH
DA | I |  | GA | JN
DB | 0 |  | GN | KA
DC | 0 |  | GO | KB
DC | I |  | GS | LA
DD | 0 |  | GT | LB
DD | I |  | HW | LE
DH | 0 |  | HZ | LM
EA | 0 |  | IO | MA
EA | 0 |  | IS | MB
EA | A |  | JA | MD
EE | 0 |  | JB | MM
EE | E |  | JG | MY
EE | I |  | JH | PB
EL | 0 |  | JN | PK
EL | 0 |  | KA | PM
EL | 0 |  | KB | RM
EL | _x000C_ |  | KO | SD
EL | A |  | KW | SP
EL | A |  | LA | VL
EL | D |  | LB | YW
EL | I |  | LE
EL | I |  | LM
EL | I |  | LW
EL | S |  | MA
EL | V |  | MB
EO | 0 |  | MD
EO | _x000C_ |  | MM
EO | D |  | MS
EO | I |  | MY
FA | 0 |  | NM
FA | A |  | PB
FB | 0 |  | PK
FB | I |  | PM
FN | 0 |  | RA
FN | E |  | RB
FN | I |  | RM
FT | 0 |  | RO
FT | I |  | SD
GA | 0 |  | SO
GA | A |  | SP
GA | I |  | VL
GN | 0 |  | YS
GO | 0 |  | YW
GO | A
GO | I
GS | 0
GS | I
GS | V
GT | 0
GT | _x000C_
GT | I
HW | 0
HZ | 0
IO | 0
IO | I
IS | 0
IS | I
JA | 0
JA | A
JB | 0
JB | _x000C_
JB | A
JB | I
JG | 0
JG | A
JH | 0
JH | I
JH | V
JN | 0
JN | I
JN | S
JN | V
KA | 0
KA | I
KB | 0
KB | I
KO | 0
KW | 0
LA | 0
LA | _x000C_
LA | D
LA | E
LA | I
LA | L
LA | S
LB | 0
LB | I
LE | 0
LE | I
LM | 0
LM | A
LM | I
LW | 0
LW | _x000C_
LW | A
LW | S
MA | 0
MA | I
MB | 0
MB | I
MD | 0
MD | A
MD | I
MM | 0
MM | I
MS | 0
MY | 0
MY | I
NM | 0
PB | 0
PB | _x000C_
PB | A
PB | I
PB | V
PK | 0
PK | I
PK | L
PK | V
PM | 0
PM | I
RA | 0
RB | 0
RB | A
RM | 0
RM | A
RM | I
RM | S
RO | 0
SD | 0
SD | _x000C_
SD | I
SO | 0
SO | _x000C_
SO | A
SP | 0
SP | D
SP | I
VL | 0
VL | I
YS | 0
YW | 0
YW | _x000C_
YW | D
YW | I
 | 0
 | _x000C_
Spreadsheet: sally_beck__36204__MgmtSum-Q201-Global-0525
Sheet: Mgmt Summary

ENRON GLOBAL MARKETS
2nd QUARTER 2001 EARNINGS ESTIMATE
Results based on activity through May 25, 2001
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Crude & Products
Coal / Emissions
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight Markets
LNG
Puerto Rico
Finance and Structuring |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Office of the Chairman
Overview |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | 0
Total Commercial
Group Cost |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0
Support Cost Allocated to Teams |  | 0 |  |  |  | 0 |  | 0 |  |  | 0 | 0 |  |  |  |  |  | 0
Other Interest Related Charges |  |  | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 |  | 0
Capital Charge Offset |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income) |  | 0 | 6900 |  |  |  |  |  |  |  | 0 | 9400 | 0 |  |  |  |  | 0 |  | 0
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes direct and allocated expenses
Spreadsheet: 004c7ac0-eb2e-4cdd-a769-5c86eb95291c
Sheet: Sheet1

Unnamed: 0 | READY TO USE | TO BE REPAIRED | UNUSABLE | TOTAL ITEMS | NO. ISSUED | EQUIP NEEDS
1. GAME PRACTICE BALLS
2. JERSEYS
A. DARK
B. LIGHT
3. SHOES
4. GAME PRACTICE [NAME]
5. GAME PRACTICE SHIRTS
6. SOCKS
7. WARM-UPS
A. TOP
B. BOTTOM
8. CORNER FLAGS
9. GOALS
10. GOALIE' SHIRTS
11. GOALIE PANTS
12. GOALIE SHORTS
13. GOALIE GLOVES
14. GOAL NETS
15. BALL, [NAME]
16. RAIN WEAR
A. TOP
B. BOTTOM
17. LONG SLEEVE T-SHIRTS
18. TRAVEL [NAME]
19. SUPPORTERS
20. SCORE BOOK
21. PUMP PRACTICE CONES
22. SWEAT TOPS
23. SCRIMMAGE VEST
24. ARMBANDS
DO NOT DISCARD OR DESTROY ANY THING; UNUSABLES WILL BE CHECKED BY
THE ATHLETIC DIRECTOR OR ASSISTANT ATHLETIC DIRECTOR.
DATE: ______________________________
SCHOOL: ____________________________________________
(CIRCLE ONE): BOYS          GIRLS
SOCCER COACH: ____________________________________
COORDINATOR: _____________________________________
PRINCIPAL: _________________________________________
P:/FORMS/M.S. SOCCER INVENTORY 10-11-06
Spreadsheet: 52385d1252078524-indirect-sum-through-worksheets-spearing-mod
Sheet: front

jul | 280 | formula in B1 sums values in cell [NAME] of all the sheets mentionned in the list in O2:O30 |  |  |  |  |  |  |  |  |  |  |  | Fill in list here
 |  |  |  |  |  |  |  |  |  |  |  |  |  | jan!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | feb!
 | 100 | simpler alternative if sheets are consecutive, not correct if Sheet 3 is moved in front of Sheet2 |  |  |  |  |  |  |  |  |  |  |  | [NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | apr!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | may!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | jun!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | jul!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | aug!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | sep!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | oct!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | nov!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | dec!
jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120
10 | 30 | 60 | 100 | 150 | 210 | 280 | 360 | 450 | 550 | 660 | 780
 | key
 | month
 | test values in cell a1 of each sheet
 | running total
Spreadsheet: kate_symes__18199__EESSales_dailyfeb
Sheet: 2-6

NP15 | 2001-02-06 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  |  | ZP26
Fixed Peak | 205.67 | Fixed Off Peak | 187.5 |  |  |  | Fixed Peak | 176.2 |  | Fixed Off Peak | 156.78 |  |  |  | Fixed Peak | 178.5 | Fixed Off Peak | 166.25
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 |  | -9.4 |  |  | 1 | -284.19 | 0 | -54 | -270.19 |  |  | 1 | -2 | 0 | 0 | -2
2 | 0 | 0 |  | -8.52 |  |  | 2 | -285.3 | 0 | -54 | -260.3 |  |  | 2 | -1.96 | 0 | 0 | -1.96
3 | 0 | 0 |  | -8.1 |  |  | 3 | -285.98 | 0 | -54 | -256.98 |  |  | 3 | -1.94 | 0 | 0 | -1.94
4 | 0 | 0 |  | -8.01 |  |  | 4 | -285.69 | 0 | -54 | -259.69 |  |  | 4 | -1.94 | 0 | 0 | -1.94
5 | 0 | 0 |  | -8.42 |  |  | 5 | -284.86 | 0 | -54 | -272.86 |  |  | 5 | -1.95 | 0 | 0 | -1.95
6 | 0 | 0 |  | -10.61 |  |  | 6 | -284.97 | 0 | -54 | -306.97 |  |  | 6 | -2.05 | 0 | 0 | -2.05
7 | -21.39 | 0 | -17 | -39.39 |  |  | 7 | -341.88 | 0 | -54 | -352.88 |  |  | 7 | -2.21 | 0 | 0 | -2.21
8 | -21.91 | 0 | -17 | -41.91 |  |  | 8 | -341.36 | 0 | -54 | -381.36 |  |  | 8 | -2.31 | 0 | 0 | -2.31
9 | -21.26 | 0 | -17 | -42.26 |  |  | 9 | -341.29 | 0 | -54 | -407.29 |  |  | 9 | -2.32 | 0 | 0 | -2.32
10 | -21.52 | 0 | -17 | -41.52 |  |  | 10 | -341.25 | 0 | -54 | -425.25 |  |  | 10 | -2.3 | 0 | 0 | -2.3
11 | -21.67 | 0 | -17 | -41.67 |  |  | 11 | -341.13 | 0 | -54 | -434.13 |  |  | 11 | -2.3 | 0 | 0 | -2.3
12 | -21.85 | 0 | -17 | -42.85 |  |  | 12 | -341.87 | 0 | -54 | -438.87 |  |  | 12 | -2.35 | 0 | 0 | -2.35
13 | -21.78 | 0 | -17 | -42.78 |  |  | 13 | -341.46 | 0 | -54 | -444.46 |  |  | 13 | -2.34 | 0 | 0 | -2.34
14 | -21.66 | 0 | -17 | -42.66 |  |  | 14 | -341.33 | 0 | -54 | -446.33 |  |  | 14 | -2.34 | 0 | 0 | -2.34
15 | -21.35 | 0 | -17 | -42.35 |  |  | 15 | -341.13 | 0 | -54 | -443.13 |  |  | 15 | -2.33 | 0 | 0 | -2.33
16 | -21.63 | 0 | -17 | -42.63 |  |  | 16 | -341.28 | 0 | -54 | -437.28 |  |  | 16 | -2.34 | 0 | 0 | -2.34
17 | -21.2 | 0 | -17 | -43.2 |  |  | 17 | -341.92 | 0 | -54 | -429.92 |  |  | 17 | -2.36 | 0 | 0 | -2.36
18 | -21.54 | 0 | -17 | -45.54 |  |  | 18 | -341.54 | 0 | -54 | -427.54 |  |  | 18 | -2.46 | 0 | 0 | -2.46
19 | -21.97 | 0 | -17 | -46.97 |  |  | 19 | -341.97 | 0 | -54 | -418.97 |  |  | 19 | -2.52 | 0 | 0 | -2.52
20 | -21.06 | 0 | -17 | -45.06 |  |  | 20 | -341.2 | 0 | -54 | -404.2 |  |  | 20 | -2.44 | 0 | 0 | -2.44
21 | -21.2 | 0 | -17 | -43.2 |  |  | 21 | -341.36 | 0 | -54 | -388.36 |  |  | 21 | -2.37 | 0 | 0 | -2.37
22 | -21.44 | 0 | -17 | -41.44 |  |  | 22 | -342 | 0 | -54 | -361 |  |  | 22 | -2.29 | 0 | 0 | -2.29
23 | 0 | 0 |  | -13.99 |  |  | 23 | -283.09 | 0 | -54 | -325.09 |  |  | 23 | -2.2 | 0 | 0 | -2.2
24 | 0 | 0 |  | -11.15 |  |  | 24 | -284.46 | 0 | -54 | -292.46 |  |  | 24 | -2.08 | 0 | 0 | -2.08
Spreadsheet: 678576d1589967510-formula-to-get-unique-data-sales
Sheet: Sheet1

MONTH | DEPT. | SALES
2020-01-01 00:00:00 | 12110 | 500
 | 13110 | 300
 | 14110
 | 15110 | 100
2020-02-01 00:00:00 | 13110 | 200
 | 12110
 | 15110 | 300
SUMMARY
SALES 12110 JAN-20 | 500
SALES 13110 JAN-20 | 300
SALES 15110 JAN-20 | 100
SALES 13110 FEB-20 | 200
SALES 15110 FEB-20 | 300
Spreadsheet: 271554d1381977079-help-with-multiple-vlookup-with-if-and-isna-testdataset
Sheet: Master-CurrentStudents

CurrentStudentID | CurrentlyEnrolledPreviousDropout? | Expected Column B Result | Range1LookupResult | Range2LookupResult | Range3LookupResult
1 |  | 1
2
3 |  | 1
4 |  | 1
5 |  | 1
7 |  | 0
8
10 |  | 1
Spreadsheet: 3c0e5959-0b85-49ad-b5f3-45fec329a84a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CRANB | Test | CRANB | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CRANB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CRANB | Result | CRANB | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7262-9
Spreadsheet: 808813d1670667821-split-text-within-an-dynamic-array-does-not-work-splittext_inside_array-aligw
Sheet: Feuil1

 |  |  |  |  | expected result
level |  | level_array_exploded |  |  | level_array_exploded
a
b_c |  | b | c |  |  | c
c |  | c
a_d |  | a | d |  |  | d
a |  | a
b_c_f |  | b | c | f |  | c | f
b |  | b
b |  | b
b |  | b
Spreadsheet: 114870d1310564420-pasting-a-formula-row-every-third-line-addformulae-vp-column-b-running-total-right-columns-tallgingerbloke-ef783977-sdg15
Sheet: Sheet1

 |  | feb | march | april | may
item a | deliveries | 10 | 10 | 120 | 10
stock | usage | 5 | 10 | 100 | 20
10 | running total | 15 | 15 | 35 | 25
item b | deliveries | 10 | 10 | 120 | 10
stock | usage | 5 | 10 | 100 | 20
10 | running total | 15 | 15 | 35 | 25
item c | deliveries | 10 | 10 | 120 | 10
stock | usage | 5 | 10 | 100 | 20
10 | running total | 15 | 15 | 35 | 25
 |  |  |  |  |  |  |  | AddFormulae - VP column B - running total right columns - tallgingerbloke - EF783977 - SDG15.xls
 |  |  |  |  |  |  |  | MS Office Version:Excel 2007
 |  |  |  |  |  |  |  | Pasting a formula row every third line
 |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/783977-pasting-a-formula-row-every-third-line.html
 |  |  |  |  |  |  |  | Hi,
 |  |  |  |  |  |  |  | I have a large spreadsheet that is very slow to work on due to the amount of calculations in it.
 |  |  |  |  |  |  |  | I have overcome this part by removing the formula and leaving just the data.
 |  |  |  |  |  |  |  | There is however one line of formula that I would like to keep in the spreadsheet
 |  |  |  |  |  |  |  | and I think it would be easier to re-introduce it after.
 |  |  |  |  |  |  |  | So, any ideas on how i can insert a strip of formula while leaving the rest of the spreadsheet.
 |  |  |  |  |  |  |  | I cannot do it manually as I have bout 10,000 lines.
 |  |  |  |  |  |  |  | Attached is a simplified version to show what I mean. I realize it may be a macro, which would be fine
 |  |  |  |  |  |  |  | hope I have made the situation clear, and thanks for reading.
 |  |  |  |  |  |  |  | Cheers
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | 'C5 then 3 rows down
 |  |  |  |  |  |  |  | '=A5-C4+C3
 |  |  |  |  |  |  |  | '=RC[-2]-R[-1]C+R[-2]C
 |  |  |  |  |  |  |  | 'D5 then 3 rows down and next column to right until LUC
 |  |  |  |  |  |  |  | '=C5-D4+D3
 |  |  |  |  |  |  |  | '=RC[-1]-R[-1]C+R[-2]C
Spreadsheet: 06e0a331-7fe8-4b0d-b0d1-f1640ca28ada
Sheet: Sheet1

FY2005 Salary Prediction Model | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
OVERVIEW/ASSUMPTIONS/APPLICATION
 | Overview
 | This model is intended to be used as a general guide for units to predict salary levels based on performance and
 | years of service.  Its development was based on the salary model approved in April of 1998.  The model enables
 | periodic reviews to be conducted for employees with at least satisfactory ratings as the performance threshold.
 | The review is intended to determine if those employees are progressing toward market salaries within a
 | reasonable timeframe given the resources available for base salary adjustments.  Further, this tool enables units
 | to identify the relative levels of inequity for employees within the unit.  The expectation is that those with the
 | greatest levels of inequity would be considered first for equity adjustments.
 | [NAME] ranges for faculty are calculated at 85% of market for the low end of the range and up to 125% of market
 | for the high end of the range.  All other employees range from a low of approximately 75% of market to a high
 | of 125% of market.  Market values are updated annually and are determined by:
 | Faculty - the Oklahoma State University Salary Survey
 | Non-faculty exempt - job analyses and the Administrative Compensation Survey (CUPA)
 | Classified staff - the Idaho Division of Human Resources
 | Salary increases were not provided in FY2003 or FY2004.  Further, the long-term history of state funding for salary
 | increases demonstrates that steady progress toward market salaries is not necessarily attainable.  Although providing
 | competitive job market average salaries is the guiding principle, fiscal realities typically constrain that component of
 | the compensation system.  Although the salary model indicates achieving market with satisfactory evaluations over
 | seven years is the goal this is not a realistic expectation.  The prediction model continues to use 7 years to
 | determine the percent inequity.
 | Annual performance evaluations (ratings) and length of service in the current classification are needed when using
 | the salary prediction model.  Comparable evaluation ratings are shown in the table below.
 | Faculty |  | Classified/NFE/Executive/Administrative
 | Dept. [NAME] | Rating | Dept. [NAME]
 | Less than satisfactory | 1 | Probation
 | Below Average | 2 | Needs Improvement
 | Average | 3 | Meets Requirements
 | Above Average | 4 | Exceeds Requirements
 | Outstanding | 5 | Outstanding
Spreadsheet: 153374d1335887191-conditional-formatting-new-rule-formula-sample-text
Sheet: Sheet1

 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00
In-Service Date | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
2012-12-31 00:00:00 |  |  |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
2012-06-30 00:00:00 |  |  |  |  |  |  |  | 5 | 5 | 9 | 9 | 9 | 4
2012-12-01 00:00:00 |  |  |  |  | 9 | 9 | 7 | 7 | 7 | 7 | 7 | 7 | 7
2012-12-01 00:00:00 |  |  |  |  |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
2012-12-31 00:00:00 |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 16 | 16 | 16
Spreadsheet: 762566d1641638022-excel-member-database-filter-member-example
Sheet: Member

Name | Surname | Member | Born | Address | City | email
Name1 | Surname1 |  | 2001-01-01 00:00:00 | Address1 | City1 | [EMAIL]
[NAME] | Surname2 |  | 2002-02-01 00:00:00 | Address2 | city2 | [EMAIL]
Name3 | Surname3 |  | 2003-03-01 00:00:00 | Address3 | city3 | [EMAIL]
Spreadsheet: 90925d1290613913-postage-prices-postage
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Weights |  | Sizes
 | Weight | 250 |  |  |  |  |  | 99250 |  | 100 |  | <=5 | 5
 | Size | >25 |  |  |  |  |  | 99 |  | 250 |  | >5<-=25 | 25
 | Service | SD |  |  |  |  |  | 6 |  | 500 |  | >25 | 99
 |  |  |  |  |  |  |  |  |  | 750
 | Price | 13.1 |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  | 1250
 |  |  |  |  |  |  |  |  |  | 1500
 |  |  |  |  |  |  |  |  |  | 1750
 |  |  |  |  |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  | Main Table
 |  |  |  |  |  |  |  |  |  |  | size | weight | 1 | 2 | SD
 |  |  |  |  |  |  |  |  |  | 5100 | 5 | 100 | 0.41 | 0.32
 |  |  |  |  |  |  |  |  |  | 25100 | 25 | 100 | 0.66 | 0.51
 |  |  |  |  |  |  |  |  |  | 25250 | 25 | 250 | 0.96 | 0.81
 |  |  |  |  |  |  |  |  |  | 25500 | 25 | 500 | 1.32 | 1.11
 |  |  |  |  |  |  |  |  |  | 25750 | 25 | 750 | 1.87 | 1.59
 |  |  |  |  |  |  |  |  |  | 99100 | 99 | 100 | 1.39 | 1.17 | 11.35
 |  |  |  |  |  |  |  |  |  | 99250 | 99 | 250 | 1.72 | 1.51 | 13.1
 |  |  |  |  |  |  |  |  |  | 99500 | 99 | 500 | 2.24 | 1.95 | 13.1
 |  |  |  |  |  |  |  |  |  | 99750 | 99 | 750 | 2.75 | 2.36 | 15.2
 |  |  |  |  |  |  |  |  |  | 991000 | 99 | 1000 | 3.35 | 2.84 | 15.2
 |  |  |  |  |  |  |  |  |  | 991250 | 99 | 1250 | 4.5 |  | 18.8
 |  |  |  |  |  |  |  |  |  | 991500 | 99 | 1500 | 5.2 |  | 18.8
 |  |  |  |  |  |  |  |  |  | 991750 | 99 | 1750 | 5.9 |  | 18.8
 |  |  |  |  |  |  |  |  |  | 992000 | 99 | 2000 | 6.6 |  | 18.8
Spreadsheet: 121656d1316223644-trouble-with-sumif-from-multiple-columns-budget-template-sample-2
Sheet: Sheet3

Weekly |  |  | Yes | D
Monthly |  |  | No | A
Fortnightly
Quarterly
Car Rego
Clothes
Entertainment
Fines
Bank Fees/Charges
Food
Licensing
Mechanical
Other
Petrol
Presents
Stationary
Tools/Hardware
Tyres
Vet
Acc 123456
Acc 1212121
Acc 4141414