tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 416eb1de-2822-4cda-ac63-80095675ec74
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-04-26 09:49:02.460000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.125 | 102 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
5 | 101.697 | 101.447 | 101.322 | 100.947
4.875 | 101.152 | 100.902 | 100.777 | 100.402 |  | Note: | Refer To Price [NAME]
4.75 | 100.168 | 99.918 | 99.793 | 99.418 |  |  | For all Price Adjs
4.625 | 99.011 | 98.761 | 98.636
4.5 | 98.501 | 98.251 | 98.126
 |  |  |  |  |  | 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.375 | 102 | 101.75 | 101.625 | 101.25
4.25 | 101.507 | 101.257 | 101.132 | 100.757
4.125 | 100.494 | 100.244 | 100.119 | 99.744
4 | 100.133 | 99.883 | 99.758 | 99.383
3.875 | 99.725 | 99.475 | 99.35
 |  |  |  |  |  | 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-05-10 09:49:02.460000
30 DAY | 2011-05-25 09:49:02.460000
45 DAY | 2011-06-09 09:49:02.460000
60 DAY | 2011-06-24 09:49:02.460000
90 DAY | 2011-07-24 09:49:02.460000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 494343d1482336417-conditional-formatting-with-multiple-criteria-team-full-stats-record-editable-v2
Sheet: Year To Date

 | Year to Date Data
January | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration (Mins) | Av Per person | Prod Per Hr
February | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
March | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
April | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
May | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
June | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
July | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
August | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
September | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
October | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
November | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
December | Name | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 |  | QA % | [NAME] | Duration | Av Per person | Prod Per Hr
 | Acc QA Pass | Acc QA Rec | Acc QA AR | Total Pass Acc | BAU Pass | BAU Rec | BAU AR | Total Pass BAU | [NAME] | Duration | Av Per Person | Prod Per Hr
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
YTD | Pass | Rec | AR | Total Acc Pass | Pass | Rec | AR | Total BAU Pass | [NAME] | Duration | Av Per Person | Prod Per Hr
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 05 April 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-04-05 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | last year balance leave 2011
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Annual leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS | Comp off
Spreadsheet: 43955d1242640912-excel-2007-seperate-shees-and-summary-example-sheets-summary
Sheet: Dick

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | 2 | 17 | 9
 | 4 | 13 | 4
 | 7 | 12 | 7
Month Total | 13 | 42 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 718469d1613146937-lookup-month-in-col-a-and-if-col-h-on-same-sheet-x-display-x-otherwise-blank-staff-changes-by-month-example-1-
Sheet: Jan

Staff Transferred Out |  |  |  |  |  |  |  |  | Jan
Spreadsheet: 769077d1645280459-30-day-moving-total-starting-with-today-sums-based-on-dates-and-weeknumbers-barksato-
Sheet: Report2_summary

 |  |  |  |  |  | Date:
 |  |  |  |  |  | Last Data Date:
 |  |  |  |  |  | Week #:
Overall Cummulative Stats
 | This Week |  | Last Week |  | This Month |  | 30day [NAME] |  | This Quarter |  | Last Quarter |  | YTD |  | Last Year |  | 2 Years Ago |  | Total
 |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | %
Average
High
Low
Performance Over Time :  # of REPORTs/# of Days Person was [NAME]
 | This Week |  | Last Week |  | This Month |  | 30day [NAME] |  | This Quarter |  | Last Quarter |  | YTD |  | Last Year |  | 2 Years Ago |  | Total
 | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | %
Spreadsheet: 540140d1506543514-create-a-list-if-cell-0-then-display-cell-copy-of-smr-costings-domestic-roofing-quotation-master-qrx-27-09-2017-list-of-inclusions
Sheet: DP W.O.

P.O. Number |  |  |  | DP
DATE
 | Supplier NAME
 | Supplier NAME
 | Supplier ABN/ACN
 | Supplier Address Line 1
 | Supplier Address Line 2
 | [NAME]
Site Address
 | Delivery Date | To be confirmed
 | Install Date | To be confirmed
 | Must be completed by | To be confirmed
Site Contact |  | Shane Treacy [PHONE]
DESCRIPTION OF GOODS/SERVICES
[NAME] |  | Qty | Ea | Total
INSTALL DOWNPIPES |  |  |  |  |  |  | ESTIMATED DURATION - FASCIA GUTTER LABOUR
Single Storey DP 1.8 |  |  | 25 |  |  |  |  | Single Storey DP 1.8
[NAME] DP 2.4 |  |  | 30 |  |  |  |  | [NAME] DP 2.4
 | Lower (Connect from upper) 2.5 |  | 15 |  |  |  |  | Lower (Connect from upper) 2.5
 | DP with Spreader |  | 40 |  |  |  |  | DP with Spreader
Rainheads |  |  | 40 |  |  |  |  | Rainheads
 | Other |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  | 2 | DP per Hr
 | SUBTOTAL EXCL GST |  |  |  |  |  | 16 | DP per Day
 |  |  | GST % | 0.1
 |  |  | GST Amount |  |  |  |  | HRS
 |  |  | TOTAL INCL GST |  |  |  |  | DAY
 | Invoice number:
Please invoice only for work completed
Spreadsheet: 787879d1658131600-if-vlookup-and-mod-subtotal-backwards-math-calculation-examplev2
Sheet: Sheet1

 | CURRENT RESULTS:
 | Item | Current Price | Start to calculate in how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 2 | 2
 | Pears | 15 | 3 | 1
 | Strawberries | 13 | 5 | 1
 | [NAME] | 22 | 2 | 1
 | EXPECTED RESULTS:
 | Item | Current Price | Start to calculate in how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 2 | 2
 | Pears | 15 | 3 | 1
 | Strawberries | 13 | 5 | 0 |  |  |  |  | 19.03
 | [NAME] | 22 | 2 | 0 |  | 24.2
 | NOTE: Main formula considers an increase of 10% per year
Spreadsheet: 728104d1618312045-how-can-i-pull-a-value-from-a-cell-if-it-finds-a-match-test-spreadsheet
Sheet: Code Master Sheet

Code | Account Name | ARC |  |  |  |  |  | Code
FER010/001 | [NAME] | Balanced | 1731126 | 603460 | 4666459 | 4666460 | 4667460 | FER010/001
ADV001/001 | [NAME] | Balanced | HAR239 |  |  |  |  | ADV001/001
[NAME] | [NAME] | Balanced | 0041848 |  |  |  |  | [NAME]
ARM001/001 | [NAME] | Balanced | IPM  0052 |  |  |  |  | ARM001/001
ASH001/001 | Trunks | Balanced | CHANC0016 | CHANC5006 | ASHTO0139 |  |  | ASH001/001
Spreadsheet: 784109d1655452623-data-extracting-sorting-and-organizing-book2
Sheet: Sheet3

Smith | [NAME] | [NAME] | Dr. | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;; | ADR;TYPE=HOME;;HomeAddress;;;;
Plextor | George |  |  | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD | ENDVCARD
Spreadsheet: sara_shackleton__36547__AIGCommodityArbLP
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | Caroline Abramo
COUNTERPARTY: | AIG Commodity Arbitrage | CONTACT:
ADDRESS: | Fund L.P. | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State | Delaware LP | S&P Rating
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 5
Incorporation State |  | OR
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | Please insert Hedge Fund | 0
 | Independent Amount Language
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 100000
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
ADDITIONAL EVENTS OF DEFAULT
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change
-Below = S&P/Moody's |  | BBB-
Financial Covenants
-Max Liabilities/NAV | 2 to 1
-Minimum NAV | $40MM
-NAV Trigger | 0.5 |  | If NAV declines by 50% in any 12 month period
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME]) | 1.5MM
-Guarantor ($[NAME]) |  | 150
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS: | DKR Management Company, Inc. is the GP and investment manager.  Finagra Capital LLC is the trading advisor.
If [NAME] or [NAME] cease to control the investments, both become incapacitated, etc. it should be an additional termination
event unless a suitable replacement (in Enron's sole discretion) is named.
Minimum Additional Amount is $250,000 if any transactions are outstanding.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-8356
Spreadsheet: 39014d1237233006-if-formula-book1
Sheet: Sheet1

 |  | 10 |  | Yes
 |  | 15 |  | Yes
 |  | 25 |  | Yes
 |  | 52 |  | No
 |  | 56 |  | No
 |  | 68 |  | No
 |  | 40 |  | Yes
 |  | 30 |  | Yes
 |  | 80 |  | No
 |  | 29 |  | Yes
Spreadsheet: 102435d1300371953-keyword-search-2-arrays-search-2-arrays
Sheet: Sheet1

 | MAIN NAME | ALTERNATE NAME | ENTRY# |  |  |  | GWI
 | BCBS | BCBS | 1 |  | 2 |  | 1
 | GLOBAL WIRELESS GWI | GWI | 2 |  | 3 |  | 2
 | GLOBAL WIRELESS INC | GWI | 3 |  | 6 |  | 3
 | GONE FINSHING INC | GONE FINSHING INC | 4 |  | 7 |  | 4
 | GONE FINSHING INC | GONE FINSHING INC | 5 |  | 7 |  | 5
 | GWI | GLOB. WIRELESS | 6 |  | #N/A |  | 6
 | GWI | GWI SYSTEMS | 7 |  | #N/A |  | 7
 | HIGHMARK | BCBS | 8 |  | #N/A |  | 8
 |  |  |  |  | #N/A |  | 9
 |  |  |  |  | #N/A |  | 10
 |  |  |  |  | #N/A |  | 11
 |  |  |  |  | #N/A |  | 12
 |  |  |  |  | ENTRY# 7 IS FOUND TWICE ON THIS LIST BECAUSE KEYWORD "GWI" IS THE FIRST 3 LETTERS OF BOTH
 |  |  |  |  | COLUMN B AND COLUMN C.
 |  |  |  |  | HOW CAN I ELIMINATE THE DUPLICATES SO THAT WHATEVER THE KEYWORD, EVERY
 |  |  |  |  | ENTRY# IS DISPLAYED ONLY 1 TIME?
 |  |  |  |  | *NOTE - There will be more complex data in the entry field (not a number), and this formula is to be used on a list 7000 entries long
Spreadsheet: 885568d1735282770-formula-for-random-distribution-sample
Sheet: Sheet1

GST SALES @ 12% | 2577865.46
GST SALES @ 18% | 7393243.44 | 0.05 | 0.12 | 0.18
GST SALES @ 5% | 9570322.09
GST SALES - EXEMPTED | 13161404.4
IGST SALES @12% | 78606.94
IGST Sales @ 18% | 30007.24
IGST SALES@5% | 661134.86
IGST SALES EXEMPTED | 826948.84
HSN CODE | % | PRODUCT NAME | Calculation |  | QTY. | TAXABLE | IGST | CGST | SGST
1904 | 0 | AVALAKKI |  |  | 500
2106 | 18 | SWASTIK BADAM POWDER(500 GM) |  |  | 60
1106 | 0 | [NAME] |  |  | 15
801 | 5 | JH |  |  | 200
1006 | 0 | [NAME] |  |  | 425
906 | 5 | D\S |  |  | 15
909 | 5 | DHANIYA |  |  | 55
2501 | 0 | SALT |  |  | 200
1108 | 12 | CFLOUR |  |  | 15
2106 | 5 | PUTANI |  |  | 90
1103 | 0 | C RAVE |  |  | 150
1101 | 0 | MAIDA |  |  | 50
1511 | 5 | RGOLD  BOX |  |  | 400
1701 | 5 | SUGAR |  |  | 1500
3405 | 18 | SHASHI BAG |  |  | 60
3402 | 18 | WHEEL 1 KG |  |  | 22
1905 | 18 | GD10RE BOX RED |  |  | 15
916 | 5 | CKN |  |  | 100
910 | 12 | TGINGER |  |  | 30
904 | 5 | A CT |  |  | 50
1512 | 5 | SPURE |  |  | 15
3402 | 18 | S XL |  |  | 200
2101 | 18 | SRICE |  |  | 15
1006 | 0 | [NAME] |  |  | 75
713 | 0 | MOONG DAL |  |  | 85
813 | 0 | TAMARIND |  |  | 10
2001 | 12 | PICKLE |  |  | 24
3605 | 12 | HOME LIGHT |  |  | 66
1902 | 12 | MAGGE |  |  | 35
3808 | 18 | GOOD KNIGHT |  |  | 140
908 | 5 | ELACHI |  |  | 500
405 | 12 | GHEE |  |  | 120
1101 | 0 | ATTA CHAKKI |  |  | 45
1902 | 12 | YIPEE 5RECASE |  |  | 1540
1905 | 18 | MOMS 5RE |  |  | 98
3401 | 18 | RIN 10RS BOX (72) |  |  | 10
1513 | 5 | PARA 1LTR |  |  | 400
3305 | 5 | TREMSEE (4RE) |  |  | 44
3402 | 18 | COLIN 500ML |  |  | 600
1905 | 18 | KJACK 5RE |  |  | 30
909 | 5 | A SAMBAR RS10.00 |  |  | 200
1106 | 5 | KGF 10KG |  |  | 26
2501 | 0 | SALT |  |  | 25
910 | 5 | POPPY SEEDS |  |  | 18
713 | 0 | KCHANNA |  |  | 47
1202 | 5 | GNS |  |  | 60
909 | 5 | SOAMP |  |  | 11
806 | 5 | GRAPES |  |  | 45
1903 | 0 | SABHUDANA |  |  | 56
1207 | 5 | TILL WHITE LOOSE |  |  | 140
1905 | 18 | PG 10 BOX |  |  | 52
2103 | 12 | [NAME] (5RE) |  |  | 250
904 | 5 | A CP RS10.00 |  |  | 35
2101 | 18 | SRISE RS2(B) |  |  | 120
3405 | 18 | VIM BAR RS10 |  |  | 216
9619 | 12 | PAMPERS M |  |  | 10
3306 | 18 | COLORES |  |  | 250
3402 | 18 | SXLPOWDER 10RE |  |  | 15
713 | 0 | GPEAS |  |  | 214
909 | 5 | BCHILLY (A) |  |  | 60
1301 | 5 | LG POWDER |  |  | 200
Spreadsheet: 692957d1598652045-why-is-the-countifs-function-not-working-book7
Sheet: Sheet2

[NAME] | WK | 0 | n/a | Got on it!
Beaumont | Slip | 1 | 1 | Negative
Fackrell | Short third | -1 | 0 | Dolly CT
Freeborn | Third | 2 |  | Rego CT
[NAME] | Point | -2 |  | Worldie CT
Graves | Deep point | 3 |  | DP Dolly
Harmer | Cover | -3 |  | DP Rego
[NAME] | Deep cover | 4 |  | DP Dolly
Kbryce | Extra | -4 |  | Run Out
Kellogg | Mid off | 5 |  | Close - Run Out Chance Shy
[NAME] | Long off | -5 |  | Miss - Run Out Chance Shy
Pai | Mid on |  |  | Game Changer
Presland | Long on |  |  | Key point
[NAME] | Cow
Sims | Mid-wicket
 | [NAME]-wicket
 | Square leg
 | Deep square leg
 | Short fine
 | Short fine leg
Spreadsheet: 744737d1629411135-extract-a-specific-number-of-rows-fulfilling-different-criteria-random-selection-with-condition-theriel-
Sheet: People

Num | Name | Category | Column1
1 | [NAME] | Red
2 | [NAME] | Red
3 | [NAME] | Blue
4 | [NAME] | Blue
5 | [NAME] | Blue
6 | [NAME] | Yellow
7 | [NAME] | Red
8 | [NAME] | Blue
9 | [NAME] | Yellow
10 | [NAME] | Red
11 | [NAME] | Red
12 | [NAME] | Yellow
13 | [NAME] | Blue
14 | Kierra Gentry | Blue
15 | [NAME] | Red
16 | [NAME] | Yellow
17 | [NAME] | Yellow
18 | [NAME] | Red
19 | [NAME] | Yellow
Spreadsheet: 698589d1602070364-extract-n-values-from-list-based-on-criteria-example-q
Sheet: Sheet1

 |  | City | Sales rep
 |  | Chicago | [NAME]
 |  | Chicago | [NAME]
 |  | Chicago | [NAME]
 |  | Chicago | [NAME] |  | New York | 1
 |  | Chicago | [NAME] |  |  | 2
 |  | New York | Maria |  |  | 3
 |  | New York | [NAME] |  |  | 4
 |  | New York | [NAME] |  |  | 5
 |  | New York | [NAME]
 |  | New York | [NAME]
 |  | Philadelphia | Jan
 |  | Philadelphia | [NAME]
 |  | Philadelphia | Tobias
 |  | Philadelphia | [NAME]
 |  | Philadelphia | [NAME]
 |  | Oslo | [NAME]
 |  | Oslo | [NAME]
 |  | Oslo | Mark
 |  | Oslo | Mick
 |  | Oslo | Julie
Spreadsheet: 738158d1624878139-ifs-with-nested-vlookup-ifs-vlookup-test
Sheet: Projections

Fuel Inflation |  |  | 0.051 | ONS CPI 2008 - 2020 |  |  | Generation (SAP)
Gas Inflation |  |  | 0.033 | ONS CPI 2008 - 2020 |  |  | Solar Self Consumption |  | 0.5
 |  |  |  |  |  |  | Battery Self Consumption |  | 0.3
 |  |  |  |  |  |  | Export
Unit Rate |  |  | 0.165 | From [NAME]
Gas Annual Use (kWh) |  |  | 12000 | From [NAME] |  |  | System Cost |  | 8000
Elec. Annual Use (kWh) |  |  | 4000 | From [NAME] |  |  | Deposit |  | 1000
Export Tariff |  |  | 0.055 | Available Tariff |  |  | Payment Type |  | Loan @ 4.9%
 |  |  |  |  |  |  | Annual Interest Rate
 |  |  |  |  |  |  | Payment Terms (years) |  | 10
Panel Degradation |  |  | 0.00925 |  |  |  | Annual Loan Repayment
Year | [NAME] | Export | Savings | Solar Total | Rep. Costs | Monthly Payment | Total Yearly Payment | Annual Benefit | Net Position
1
2
3
4
5
 |  |  |  |  | -1500
 |  |  |  |  | -1000
Spreadsheet: 863372d1710874201-calculating-weighted-averages-slightly-differently-daily-completion
Sheet: EXPERIMENTAL

 |  |  | BASE SCORE: | 1
 |  |  | % Complete | Activity | Weight | Points | Weighted Score
 |  |  | 1 | physical | -2
 |  |  | 0 | emotional | 0
 |  |  | 0 | financial | 0
 |  |  | 0 | professional | 0
 |  |  |  |  | Overall
Spreadsheet: 540001d1506466587-referencing-row-wise-data-in-a-column-test1
Sheet: User_Data

CAN-ID1 | CAN-ID2 | CAN-ID3 | DLC | No_of_pulses | Pulse_width1 | Gap_between_pulses | Pulse_width2 | Manual_Trigger | Repeat_trigger_period | Trigger_Select | Volt_ref | Temp_ref | PS_En_nRESET | Discharge | Zero
9 | 10 | 11 | 8 | 255 | 100 | 25 | 20 | 0 | 2000 | 1 | 1000 | 25 | 1 | 0 | 0
9 | 10 | 11 | 8 | 100 | 100 | 25 | 20 | 1 | 2000 | 1 | 1000 | 25 | 1 | 0 | 0
Spreadsheet: kate_symes__18163__CAL Prices
Sheet: Price-Graph

Buy MW | (All)
Sell MW | (All)
Sum of Price | Zone | Peak / Off-Peak
 | NP-15 |  | SP-15
Date | OP | P | OP | P
2001-02-06 00:00:00 | 177.5 | 180.6153846153846 | 146.7763157894737 | 166.9047619047619
2001-02-07 00:00:00 | 213.8888888888889 | 246.8571428571429 | 146.2 | 172.2597402597403
2001-02-08 00:00:00 | 216.75 | 273 | 146.75 | 175.25
2001-02-09 00:00:00 | 200 | 216.0017647058824 | 125.7068965517241 | 153.6111111111111
2001-02-10 00:00:00 | 200 | 216.0017647058824 | 125.7068965517241 | 153.6111111111111
2001-02-11 00:00:00 | 227.5 |  | 159.1194029850746
2001-02-12 00:00:00 | 227.5 | 258.3333333333333 | 159.1194029850746 | 192
2001-02-13 00:00:00 | 238.5 | 276.3131578947368 | 157.6123076923077 | 204.9997560975609
2001-02-14 00:00:00 | 291.6666666666667 | 315.83 | 197.0967741935484 | 272.0597014925373
2001-02-15 00:00:00 | 340 | 432.0833333333333 | 308.0833333333333 | 411.7965625
2001-02-16 00:00:00 | 340 | 432.0833333333333 | 308.0833333333333 | 411.7965625
2001-02-17 00:00:00 | 299.7 | 324.4444444444445 | 266 | 322.5
2001-02-18 00:00:00 | 299.7 |  | 266
2001-02-19 00:00:00 | 217.1111111111111 | 305.592 | 192.2727272727273 | 285.8333
2001-02-20 00:00:00 | 217.1111111111111 | 305.5952 | 192.2727272727273 | 285.8333
Spreadsheet: 726995d1617642389-data-entered-a-sheet-need-to-appear-automatically-on-another-sheet-as-per-headings-etc-accounting-module-caracalla-sol-01-1-
Sheet: Monthly Expenses Summary

 | MONTHLY EXPENSES SUMMARY - KEGALLE
 | Slicer to filter data by Account Titles is in this cell. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | 2021
 | G/L Code | Final Acc. Entry | Account Title | January | February | March | April | May | June | July | August | September | October | November | December | Total | Trend
 |  |  | Expenses
 |  |  | Building Rent
 |  |  | Electricity
 |  |  | Fuel
 |  |  | Internet Charges
 |  |  | Mobile Charges
 |  |  | Statationery
 |  |  | Computers
 |  |  | Furniture
 |  |  | Travelling Costs
 |  |  | Marketing/Advertising
 |  |  | Charitables
 |  |  | Sponsorships
 |  |  | Entertainment
 |  |  | Insurance
 |  |  | Water Bill
 |  |  | Car
 |  |  | Motor Bike
 |  |  | Owners Withdrawals
 |  |  | Salaries
 |  |  | Loans Disburesed
 |  |  | Interest Paid
 |  |  | Petty Cash
 |  |  | EPF
 |  |  | ETF
 |  |  | Bonus
 | Total
 |  |  | Incomes
 |  |  | Document Charges
 |  |  | Loan Capital Recovery
 |  |  | Loan Interest Recovery
 |  |  | Donations
 |  |  | Other Incomes
 |  |  | Owners Capital
 |  |  | Third Party Loans
 | Total
Spreadsheet: 50754d1250232924-cumulative-values-example1
Sheet: Sheet1

Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Open per Month | 1 | 2 | 2 | 1 | 1 | 2 | 2 | 6 | 6 | 7 | 7
Open Per Month Cumulative
Spreadsheet: 156731d1337429974-min-value-of-column-of-specific-cells-book1
Sheet: B (data)

Στήλη1 | Στήλη2 | Στήλη22 | Στήλη3 | Στήλη4 | Στήλη7 | Στήλη8 | Στήλη9 | Στήλη10 | Στήλη11 | Στήλη12 | Στήλη13 | Στήλη14 | Στήλη15 | Στήλη16 | Στήλη17 | Στήλη18
7061520
7061610
7061620
7066211
7066221
7068210
7068220
7068510
7068520
7071511
7071512
7071521
7071522
7071611
7071621
7071622
7071811
7071812
7071821
7071822
7071612
8041610
8041620
8041810
8041820
7140200
7090611
Spreadsheet: 777877d1650646411-merging-list-information-from-multiple-sheets-that-may-have-added-rows-test
Sheet: Q1

 |  |  |  | YTD |  | YTD
 |  | Hire |  | Info to |  | Info to |  | Quarterly
NAME |  | Date |  | 2022-03-31 00:00:00 |  | 2022-03-31 00:00:00 |  | Wages
(these are made up names and info)
Abbott, [NAME] |  | 1995-12-02 00:00:00 |  | 1500
[NAME], [NAME] |  | 2020-08-10 00:00:00 |  | 2000
Cabott, Fred |  | 2007-08-01 00:00:00 |  | 4000
Dabott, [NAME] |  | 2002-05-15 00:00:00 |  | 8000