tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 54049d1254061346-problem-with-date-range-lookups-and-calculations-rolling-average
Sheet: Sheet1

Date | salary | rolling average
2008-01-30 00:00:00 | 2000
2008-02-28 00:00:00 | 2000 | 25172.41379310345 | 48666.66666666666
2008-03-31 00:00:00 | 2300 | 25729.50819672131 | 37088.70967741936
2008-04-29 00:00:00 | 2300 | 26766.66666666667 | 34494.50549450549
2008-06-30 00:00:00 | 2400 | 21611.84210526316 | 26241.83006535948
2008-07-31 00:00:00 | 2400 | 22737.70491803279 | 26581.52173913044
2008-09-30 00:00:00 | 2500 | 20793.03278688525 | 23687.75510204082
2008-10-31 00:00:00 | 2600 | 21900 | 24465.57971014493
2008-12-31 00:00:00 | 2800 | 20965.77380952381 | 23069.73293768546
2009-02-28 00:00:00 | 2700 | 19945.35519125683 | 21880.10899182561
2009-03-31 00:00:00 | 3000 | 20700 | 22937.15846994536
2009-05-31 00:00:00 | 3000 | 20701.49253731343 | 23247.02380952381
Spreadsheet: 42121d1240667196-first-in-first-out-fifo-accounting-for-equity-trades-book-cost-fifo-help
Sheet: Sheet1

T/D | S/D | Investment | Type | [NAME] | Cost per share | [NAME] | Cost of Sales
2007-01-01 00:00:00 |  | Random | purchase | 650 | 46.15384615384615
2007-01-02 00:00:00 |  | Random | purchase | 6000 | 58.33333333333334 |  | 0
2007-01-03 00:00:00 |  | Random | purchase | 3950 | 50.63291139240506 |  | 0
2007-01-04 00:00:00 |  | Random | purchase | 4250 | 47.05882352941177 |  | 0
2007-01-05 00:00:00 |  | Random | purchase | 4500 | 44.44444444444444 |  | 0
2007-01-06 00:00:00 |  | Random | purchase | 4450 | 44.9438202247191 |  | 0
2007-01-07 00:00:00 |  | Random | purchase | 650 | 46.15384615384615 |  | 0
2007-01-08 00:00:00 |  | Random | purchase | 3950 | 45.56962025316456 |  | 0
2007-01-09 00:00:00 |  | Random | sale | 0 |  | 3900 | 219583.3333333333
2007-01-10 00:00:00 |  | Random | sale | 0 |  | 2250 | 131250
2007-01-11 00:00:00 |  | Random | sale | 0 |  | 5800 | 292696.0784313725
2007-01-12 00:00:00 |  | Random | sale | 0 |  | 3050 | 143137.2549019608
2007-01-13 00:00:00 |  | Random | purchase | 3200 | 50 |  | 0
2007-01-14 00:00:00 |  | Random | sale | 0 |  | 1000 | 44444.44444444445
Spreadsheet: kam_keiser__18033__Summary of Book Requests PowerUpdate
Sheet: TAGG

 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION
 |  |  | Type Of Transactions |  |  | Book Mapping
 | Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed
166966 | PWR-GAS-WMGMT | POWERGASWESTMANAGEMENT | x |  |  | MJ | NYMEX1 | x |  |  |  |  |  | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166967 | PWR-GAS-NW | POWERGASNORTHWEST | x |  |  | MJ | NYMEX2 | x |  |  |  |  |  | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166968 | PWR-GAS-SW | POWERGASSOUTHWEST | x |  |  | MJ | NYMEX3 | x |  |  |  |  |  | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166969 | PWR-GAS-CALI | POWERGASCALIFORNIA | x |  |  | MJ | NYMEX4 | x |  |  |  |  |  | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166973 | PWR-GAS-MGMT | POWER GAS MANAGEMENT | x |  |  | ME | NYMEX1 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166961 | PWR-GAS-OPTION | POWER GAS OPTION | x |  |  | ME | NYMEX2 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167192 | PWR-GAS-PJM | POWER GAS PJM | x |  |  | ME | NYMEX3 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166962 | PWR-GAS-NE | POWER GAS NORTHEAST | x |  |  | ME | NYMEX4 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166963 | PWR-GAS-MW | POWER GAS MIDWEST | x |  |  | ME | NYMEX5 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166965 | PWR-GAS-ERCOT | POWER GAS ERCOT | x |  |  | ME | NYMEX6 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167108 | PWR-GAS-LT-ERCT | POWER GAS LONG TERM ERCOT | x |  |  | MQ | NYMEX1 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167109 | PWR-GAS-LT-SPP | POWER GAS LONG TERM SPP | x |  |  | MQ | NYMEX2 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167111 | PWR-GAS-ST-PJM | POWER GAS SHORT TERM PJM | x |  |  | MQ | NYMEX3 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167113 | PWR-GAS-ST-ERCT | POWER GAS SHORT TERM ERCOT | x |  |  | MQ | NYMEX4 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167114 | PWR-GAS-ST-NY | POWER GAS SHORT TERM NEW YORK | x |  |  | MQ | NYMEX5 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167115 | PWR-GAS-ST-MW | POWER GAS SHORT TERM MIDWEST | x |  |  | MQ | NYMEX6 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167116 | PWR-GAS-LT-OPTB | POWER GAS LONG TERM OPTION B | x |  |  | MQ | NYMEX7 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
Spreadsheet: 109016d1305921054-sum-of-a-specific-item-into-another-column-sampleworkbook
Sheet: Sheet1

Item | Qty |  | Item | Total
Apple | 3 |  | Apple | 11
Orange | 5 |  | Orange | 5
Apple | 8 |  | [NAME] | 16
[NAME] | 10 |  | Kiwi | 20
Kiwi | 20
Spreadsheet: 54ae4dfd-b4d2-41b5-a754-b2d637fe4626
Sheet: Sheet1

Journal Entry | Unnamed: 1 | Unnamed: 2 | Whitman College
 |  |  | Business Office
Move from field to field using the "Tab" key
DATE SUBMITTED | Use to correct entries to departmental accounts.  Do not use to effect budget changes.  Please reference or attach any documents that support this entry.  Below each entry please include a general ledger description of 30 spaces or less. |  | NUMBER (B/O ONLY)
SUBMITTING OFFICE | BUDGET YEAR |  | POSTING DATE (B/O ONLY)
General Ledger Code | Debit | Credit | Department
(14 digits) | amount | amount | name
 | 0 | 0
FURTHER JUSTIFICATION OR EXPLANATION
INITIATED BY | DATE | BUDGET OFFICER | DATE
 |  | APPROVAL   required if entry over $5,000
 | 00:00:00
DEPARTMENT OR | DATE | BUSINESS OFFICE | DATE
DIVISION APPROVAL |  | APPROVAL
Spreadsheet: 390410d1429625851-returning-data-from-a-table-based-on-a-drop-down-selection-table-returns-from-drop-down-s-1
Sheet: Data

NAME
No. | Table 1 | Table 2 | Table 2 | Table 2 | Information | Table 3 | Information
 | Good | Average | Good | Poor |  | Good
1
Spreadsheet: 839466d1692010642-excel-formula-to-best-match-product-based-on-4-criteria-required-quick-sales-calc-v1-demo
Sheet: Sensor Qty CALC test

Location | Indoor/Outdoor | Cable/Wifi/BT | Height Required | [NAME] | Height Recommended | Sensor Quantity/Width | Sensor MSRP (USD) | Sensor Recommended |  | Sensor Total Price | ColBC CONCAT
location 1 | Indoor | Cable | 3.5 | 2.37 |  |  |  |  |  |  |  |  | ColBC CONCAT Ref
location 2 | Indoor | Cable | 3.5 | 2.37 |  |  |  |  |  |  |  |  | IndoorCable
location 3 | Indoor | Cable | 3.35 | 3 |  |  |  |  |  |  |  |  | IndoorWifi/BT
location 4 | Indoor | Cable | 2.6 | 5.18 |  |  |  |  |  |  |  |  | OutdoorCable
location 5 | Indoor | Cable | 3.5 | 7.31 |  |  |  |  |  |  |  |  | OutdoorWifi/BT
Sensor | Indoor/Outdoor | Cable/Wifi/BT | Height | [NAME] | Length | Coverage of Height/Width | Sensor MSRP (USD) | ColBC CONCAT | Height AB Test | ColBC CONCAT Match
sensor 1 | Indoor | Cable | 2.5 | 1.88 | 1.06 |  | 500
sensor 1 | Indoor | Cable | 3 | 3.75 | 2.13 |  | 500
sensor 1 | Indoor | Cable | 3.5 | 5.63 | 3.19 |  | 500
sensor 1 | Indoor | Cable | 4 | 7 | 4.25 |  | 500
sensor 1 | Indoor | Cable | 4.5 | 7 | 5 |  | 500
sensor 1 | Indoor | Cable | 5 | 7 | 5 |  | 500
sensor 1 | Indoor | Cable | 5.5 | 7 | 5 |  | 500
sensor 1 | Indoor | Cable | 6 | 7 | 5 |  | 500
sensor 2 | Indoor | Wifi/BT | 2.5 | 1.88 | 1.06 |  | 1000
sensor 2 | Indoor | Wifi/BT | 3 | 3.75 | 2.13 |  | 1000
sensor 2 | Indoor | Wifi/BT | 3.5 | 5.63 | 3.19 |  | 1000
sensor 2 | Indoor | Wifi/BT | 4 | 7 | 4.25 |  | 1000
sensor 2 | Indoor | Wifi/BT | 4.5 | 7 | 5 |  | 1000
sensor 2 | Indoor | Wifi/BT | 5 | 7 | 5 |  | 1000
sensor 2 | Indoor | Wifi/BT | 5.5 | 7 | 5 |  | 1000
sensor 2 | Indoor | Wifi/BT | 6 | 7 | 5 |  | 1000
sensor 3 | Outdoor | Cable | 2.5 | 1.88 | 1.06 |  | 2000
sensor 3 | Outdoor | Cable | 3 | 3.75 | 2.13 |  | 2000
sensor 3 | Outdoor | Cable | 3.5 | 5.63 | 3.19 |  | 2000
sensor 3 | Outdoor | Cable | 4 | 7 | 4.25 |  | 2000
sensor 3 | Outdoor | Cable | 4.5 | 7 | 5 |  | 2000
sensor 3 | Outdoor | Cable | 5 | 7 | 5 |  | 2000
sensor 3 | Outdoor | Cable | 5.5 | 7 | 5 |  | 2000
sensor 3 | Outdoor | Cable | 6 | 7 | 5 |  | 2000
sensor 4 | Outdoor | Wifi/BT | 2.5 | 1.88 | 1.06 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 3 | 3.75 | 2.13 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 3.5 | 5.63 | 3.19 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 4 | 7 | 4.25 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 4.5 | 7 | 5 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 5 | 7 | 5 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 5.5 | 7 | 5 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 6 | 7 | 5 |  | 3000
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 2007-08

Table F
Student Numbers by [NAME] and Method of Study
2007-08
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 5698 | 6158 |  | 1756 | 125
%
Graduate | 2340 | 2826 |  | 1415 | 1433
%
Total
Spreadsheet: 261ec12c-0467-4291-9076-f27043865dbf
Sheet: EPR BS

Consolidated Balance Sheets ([NAME] and Condensed)
 | March 31, |  | September 30,
 | 2014 |  | 2013
(In millions)
Assets
Current assets
Cash and equivalents | 355.8 |  | 713.3
Investment securities | 15 |  | 28.8
Restricted cash and investments | 61.5 |  | 67
Jackpot annuity investments | 55 |  | 56.5
Receivables, net | 551.5 |  | 577.9000000000001
Inventories | 76 |  | 90.10000000000001
Other assets and deferred costs | 284.4 |  | 242.4
Total current assets | 1399.2 |  | 1776
Property, plant and equipment, net | 443.9000000000001 |  | 483.9
Jackpot annuity investments | 253.3 |  | 268.6
Contracts and notes receivable, net | 143.6 |  | 165.6
Goodwill and other intangibles, net | 1577.8 |  | 1601.7
Other assets and deferred costs | 483.6999999999999 |  | 317
Total Assets | 4301.5 |  | 4612.799999999999
Liabilities and Shareholders' Equity
Current liabilities
Short-term debt | 846.4 |  | 826.6
Accounts payable | 92.9 |  | 110
Jackpot liabilities, current portion | 121.9 |  | 131.7
Dividends payable | 27.2 |  | 25.9
Other accrued liabilities | 337.9999999999999 |  | 414.3
Total current liabilities | 1426.4 |  | 1508.5
Long-term debt | 1357.1 |  | 1366.3
Jackpot liabilities | 278.5 |  | 293.3
Other liabilities | 124.9 |  | 190.6
Total Liabilities | 3186.9 |  | 3358.7
Total Equity | 1114.6 |  | 1254.1
Total Liabilities and Shareholders' Equity | 4301.5 |  | 4612.8
Spreadsheet: 824221d1680389147-need-minor-modification-to-multiple-criteria-formula-i-think-book1
Sheet: Sheet1

 | RUN | WINDOWS | Actual
 | 1 | 6AM-8AM / 12PM-2PM
 | 1 | 10AM-12PM
 | 1 | 1PM-3PM / 11AM-1PM
 | 1 | 2PM-4PM / 10AM-12PM
 | 1 | 2PM-4PM / 10AM-12PM
 | 2 | 5PM-7PM
 | 2 | 8AM-10AM / 5PM-7PM
 | 2 | 11AM-1PM / 1PM-3PM
 | 2 | 12PM-2PM
 | 3 | 12PM-2PM
 | 3 | 3PM-5PM
 | 3 | 7AM-9AM
 | 3 | 8AM-10AM
 | 3 | 9AM-11AM
 | 4 | 9AM-11AM
 | 4 | 2PM-4PM
 | 4 | 8AM-10AM / 5PM-7PM
 | 4 | 6AM-8AM
 | 4 | 7AM-9AM
 | 4 | 8AM-10AM
 | 4 | 11AM-1PM
 | 4 | 1PM-3PM / 12PM-2PM
 | 4 | 1PM-3PM
 | 4 | 2PM-4PM
 | 4 | 3PM-5PM
 | 4 | 4PM-6PM
 | 5 | 4PM-6PM / 12PM-2PM
 | 5 | 1PM-3PM
 | 5 | 6AM-8AM
 | 5 | 5PM-7PM
 | 5 | 4PM-6PM / 7AM-9AM
 | 5 | 10AM-12PM / 8AM-10AM
 | 5 | 2PM-4PM / 10AM-12PM
 | 5 | 1PM-3PM / 11AM-1PM
Spreadsheet: c73315b5-2362-4768-8d64-eea83c61c352
Sheet: New Table 3

Table 3
Rail Deliveries to Port (carloads)1
 | Mississippi |  | Pacific | Atlantic & |  |  | Cross-Border
Week ending | Gulf | Texas Gulf | Northwest | East Gulf | Total | Week ending | Mexico3
10/22/2014p |  |  |  |  |  | 2014-10-18 00:00:00
10/15/2014r |  |  |  |  |  | 2014-10-11 00:00:00
2014 YTDr |  |  |  |  |  | 2014 YTD
2013 YTDr |  |  |  |  |  | 2013 YTD
2014 YTD as % of 2013 YTD |  |  |  |  |  | % change YTD
Last 4 weeks as % of 20132 |  |  |  |  |  | Last 4wks % 2013
Last 4 weeks as % of 4-year avg.2 |  |  |  |  |  | Last 4wks % 4 yr
Total 2013 |  |  |  |  |  | Total 2013 | 70298
Total 2012 |  |  |  |  |  | Total 2012 | 92008
1 Data is incomplete as it is voluntarily provided
2 Compared with same 4-weeks in 2013 and prior 4-year average.
3 Cross- border weekly data is aproximately 15 percent below the Association of American Railroads reported weekly carloads received by Mexican railroads
to reflect switching between KCSM and FerroMex.
YTD = year-to-date; p = preliminary data; r = revised data; n/a = not available
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 57687d1257900773-search-table-with-multiple-criteria-and-return-row-example
Sheet: lists

SALES | SALES# | FINANCE | FINANCE# | MANAGER | MANAGER# | DEALTYPE | DEALTYPE# | SALETYPE |  |  | DOCFEE | USEDPACK | NEWPACK | SPFI | SPFI FI
BROWN,STERLING U | 9025 | DEALER TRADE | 98 | DISANTO,TJ | 9962 | RETAIL | 1   1 | RETAIL |  |  | 250 | 200 | 50 | 9997 | 1975
CARTER,CLARENCE M | 6514 | LAYTON,MICHELLE | 8585 | GRUNWALD,TERRANCE | 8801 | WHOLESALE | 2   3 | HOUSE
CLARK,DANIEL | 5792 | SPFI | 1975 | HOUSE | 9998 | FLEET |  | WHOLE
CONLEY,[NAME] | 1084 | [NAME],CODY | 5339 | SPFI | 9997 | DEALER TRADE | 2   7 | FLEET
COUNSELMAN,KENNETH | 2911 |  |  |  |  |  |  | COMMERCIAL
DEFABBO,SCOTT | 9773 |  |  |  |  |  |  | DEALER TRADE
DHAHER,[NAME] | 6126
EDWARDS,[NAME] | 7156
FRIEDMAN,BRUCE | 9562 |  |  | HS | HSREPORT
GURKO,MATTHEW S | 9242 |  |  | 1 | PENDING BUT NOT DELIVERED
HENDERSON,JEROME | 4885 |  |  | 2 | DELIVERED BUT NOT APPROVED
HOUSE | 9999 |  |  | 3 | APPROVED BUT NOT BOOKED
INTERNET SALESPERSON | 555 |  |  | 4 | BOOKED BUT NOT FINALIZED
IVERY,WILLIAM | 37 |  |  | 5 | FINALIZED BUT NOT FUNDED
JURSEK,THOMAS | 9595 |  |  | 6 | FUNDED BUT NOT TITLED
LAUHON,NORVEL S | 6928 |  |  | 7 | FUNDED BUT TRADE NOT PAID OFF
LAVENDER,JEROME | 9304
LEWIS,REGINALD | 9386
MCKOY,[NAME] | 3781
REBANT,[NAME] | 1115
REED,[NAME] | 6944
RODGERS,VIOLA | 6282
STIGGERS II,HARRY L | 8134
SUSTER,[NAME] | 7513
WALK,ROBERT | 3070
Spreadsheet: 669623d1585504068-how-to-put-multiple-if-conditions-in-one-nested-condition-stock-simulation
Sheet: Sheet1

 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  | Sales | 81 | 53 | 54 | 90 | 54 | 56 | 84 | 71 | 67 | 84 | 63 | 71 | 80 | 65 | 48
 |  |  | Closing Stock | 159 | 182 | 190 | 173 | 250 | 191 | 30 | 156 | 179 | 164 | 189 | 173
 |  | Output Result | Month of Supply Ratio |  | 2.7 | 2.8 | 2.8 | 3.6 |  | 0.4
Spreadsheet: 002ff8f7-34f1-4f75-ab90-dc7586af3484
Sheet: SUM-Other

Summary Exhibit |  |  | SUM-Other
Insurance Company: | Insert Company Name
Program: | Insert Program Type
Effective Date: | MM/DD/YYYY
Coverage | Earned Premium or Earned Exposures | Indicated Change | Proposed Change
(Add/Delete rows as needed)
C 1
C 2
C 3
etc
Overall Total
Insurer Notes:
Notes:
1.  The Coverage Indicated Change value should balance to the Coverage Credibility Weighted Indicated Change value in RLI-Other Exhibit
2. The Coverage Proposed Change value should balance to the Coverage Overall Change value in OB-Other Exhibit
3. Complete this exhibit for each Program type being filed
Spreadsheet: 769634d1645625178-partial-vlookup-with-multiple-matches-vlook-mult-matches
Sheet: Sheet1

 | Reference Table
 | Phrases | Reference
 | A blessing in disguise | 10234 |  |  |  | Lookup Words (Containing Full or Partial Match from the B Column) | EXPECTED RESULTS
 | A dime a dozen | 10235 |  |  |  | Easy | 10243
 | Beat around the [NAME] | 10236 |  |  |  | Better late | 10237
 | Better late than never | 10237 |  |  |  | Cutting Corners | 10242
 | Bite the bullet | 10238 |  |  |  | drawing | 10248
 | Break a leg | 10239 |  |  |  | together | 10246, 10258
 | Call it a day | 10240 |  |  |  | Science | 10251
 | Cut somebody some slack | 10241 |  |  |  | Rocket | 10251
 | Cutting corners | 10242 |  |  |  | Sack hook | 10250, 10252
 | Easy does it | 10243 |  |  |  | Someone | 10247, 10252, 10257
 | Get out of hand | 10244 |  |  |  | Long story | 10253
 | Get something out of your system | 10245 |  |  |  | Get | 10244, 10245, 10246, 10258, 10264
 | Get your act together | 10246
 | Give someone the benefit of the doubt | 10247
 | Go back to the drawing board | 10248
 | Hang in there | 10249
 | Hit the sack | 10250
 | It's not rocket science | 10251
 | Let someone off the hook | 10252
 | Make a long story short | 10253
 | Miss the boat | 10254
 | No pain, no gain | 10255
 | On the ball | 10256
 | Pull someone's leg | 10257
 | Pull yourself together | 10258
 | So far so good | 10259
 | Speak of the devil | 10260
 | That's the last straw | 10261
 | The best of both worlds | 10262
 | Time flies when you're having fun | 10263
 | To get bent out of shape | 10264
 | To make matters worse | 10265
 | Under the weather | 10266
 | We'll cross that bridge when we come to it | 10267
 | Wrap your head around something | 10268
 | You can say that again | 10269
 | Your guess is as good as mine | 10270
Spreadsheet: 773438d1647866119-lookup-and-provide-max-latest-value-with-condition-test9v2
Sheet: Sheet1

ID | Most recent 'Last Login Date&Time' | Most Recent 'Last Login Date&Time' is within 6 months of now? | Expected Results Column B | Expected Results Column C
133435833032 |  |  | 2021-03-12 20:35:39
228056127019 |  |  | 2022-03-15 08:35:12 | Yes
228056127019 |  |  | 2022-03-15 08:35:12 | Yes
228056127019 |  |  | 2022-03-15 08:35:12 | Yes
555877949108 |  |  | 2022-02-17 14:16:33 | Yes
568845263108 |  |  | 2022-02-17 14:16:33 | Yes
611766667046
642188514565
Spreadsheet: 327721d1403662624-negative-stock-summary-3-branches-branch-sum-neg-stk
Sheet: Sheet1

case 1
REF | [NAME] | B1 | B2 | B3
248.000.00 | ARIEL WALL 25 X 35 = SNOW WHITE WM290A | 1.92 | 0.17 | 0.25
248.000.01 | ARIEL WALL 25 X 33 = CORAL CREAM WM291A | 1 | 1.08 | 0.58
248.000.02 | ARIEL FLOOR 33 X 33 = SNOW WHITE MB290A | 33 | 4.89 | 0
248.000.04 | NYETRA 30 X 60 = CORNSILK [NAME] MB340A | -8 | 0 | 12.67 | b1
248.000.21 | BRONX 25 X 33 =MATT ANTIQUE COPPER WM283 | 20.25 | 0.08 | -9.92 | b3
248.000.46 | SANCTUARY 30 X 60 = WG 021 A | 3.83 | -71.17 | 6.17 | b2
case 2
REF | [NAME] | B1 | B2 | B3
248.000.58 | CONKRIT 60 X 60 = SD 72 A | -113 | -129.67 | 1 | b1b2
 | Case 1 formula on f1 to comment which btranch has negative stock , expected results plugged
 | Case 2 formula on f14 to comment b1b2 since two branches has neg stock , this is rare that is above i need see how one branch comment looks
Spreadsheet: 270201d1381413582-formula-to-find-multiple-matches-and-then-sum-result-from-another-column-into-another-sheet-consolidate-codes
Sheet: Sheet1

code | this year | last year
4-0000
4-0001
4-0002
4-1100
4-1105
4-1110
4-1115
4-1119
4-1120
4-1121
4-1122
4-1123
4-1124
4-1128
4-1129
4-1130
4-1140
4-1150
4-1160
4-1170
4-1180
4-1190
4-5100
4-5150
4-5152
4-5153
4-9900
4-9905
4-9910
4-9925
5-0000
5-1000
5-1100
5-1101
5-1102
5-1105
5-1106
5-1108
5-1130
5-1131
5-1132
5-1133
5-1160
5-1165
5-1170
5-1180
5-2000
5-2100
5-2151
5-2152
5-2154
5-2155
5-2156
5-4000
5-4100
5-4110
5-4120
5-4130
5-4150
5-4160
5-4170
5-4173
5-4174
5-4180
5-4190
5-5000
5-5001
5-5002
5-5003
5-5004
5-5005
5-5010
5-5014
5-5501
5-5520
5-9000
5-9001
6-0000
6-0010
6-0040
6-0041
6-1010
6-1015
6-1016
6-1017
6-1200
6-1210
6-1225
6-1226
6-1230
6-1240
6-1250
6-1260
6-1272
6-1274
6-1275
6-1276
6-2200
6-2231
6-2232
6-2233
6-2234
6-2440 |  | combined codes total to appear here
6-2236
6-2273
6-2274
6-2500
6-2505
6-2520
6-2525
6-2530
6-2540
6-2550
6-2560
6-2565
6-2570
6-2598
6-2599
6-3000
6-3603
6-3604
6-3605
6-3606
6-3607
6-3608
6-3609
6-3610
6-3611
6-3630
6-3640
6-3645
6-3660
6-3661
6-4000
8-0000
8-1000
9-0000
9-4005
9-4006
9-5000
9-9991
Spreadsheet: 887757d1738080054-formula-only-to-choose-highest-top-score-and-change-to-tick-sign-formula
Sheet: Sheet1

 |  | Day 1 |  |  | Day 2 |  |  | Day 2
 |  | Bad | Good | Excellent | Bad | Good | Excellent | Bad | Good | Excellent
 | Company 1 | 20 | 15 | 10 | 40 | 60 | 55 | 75 | 55 | 25
 | Company 2 | 80 | 30 | 20 | 60 | 50 | 45 | 55 | 60 | 70
 | Company 3 | 50 | 30 | 30 | 50 | 40 | 35 | 35 | 55 | 70
 | Company 4 | 60 | 40 | 20 | 70 | 50 | 30 | 40 | 45 | 55
 | Company 5 | 10 | 20 | 30 | 50 | 70 | 60 | 55 | 50 | 40
 | Company 6 | 150 | 70 | 55 | 120 | 160 | 80 | 70 | 100 | 30
 | Company 7 | 1500 | 200 | 500 | 40 | 60 | 80 | 85 | 75 | 115
 | Company 8 | 3500 | 2000 | 7800 | 45 | 60 | 35 | 15 | 10 | 5
 | Company 9 | 15 | 25 | 10 | 10 | 20 | 30 | 400 | 600 | 755
 | Company 10 | 25 | 800 | 20 | 150 | 380 | 1100 | 200 | 800 | 600
 |  | *[NAME] to choose only top score in day 1, day2, day3 and change to tick sign
 |  | As result should be show as below
 |  | Day 1 |  |  | Day 2 |  |  | Day 2
 |  | Bad | Good | Excellent | Bad | Good | Excellent | Bad | Good | Excellent
 | Company 1 | 20 |  |  |  | 60 |  | 75
 | Company 2 | 80 |  |  | 60 |  |  |  |  | 70
 | Company 3 | 50 |  |  | 50 |  |  |  |  | 70
 | Company 4 | 60 |  |  | 70 |  |  |  |  | 55
 | Company 5 |  |  | 30 |  | 70 |  | 55
 | Company 6 | 150 |  |  |  | 160 |  |  | 100
 | Company 7 | 1500 |  |  |  |  | 80 |  |  | 115
 | Company 8 |  |  | 7800 |  | 60 |  | 15
 | Company 9 |  | 25 |  |  |  | 30 |  |  | 755
 | Company 10 |  | 800 |  |  |  | 1100 |  | 800
Spreadsheet: 865340d1712364748-calculate-max-loan-amount-based-on-funds-available-and-lvr-investment-property-spreadsheet-copy
Sheet: Proposed Analysis - PI

POTENIAL PROPERTY ANALYSIS
 | MINIMUM INPUTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC
 |  | Proposed Property Address: |  |  |  |  |  | Enter the address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NSW
 |  | Proposed Purchase Price: |  |  |  |  |  | 600000 |  |  |  |  |  | State: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  | Proposed Loan Amount: |  |  |  |  |  | 540000 |  |  |  |  |  | Proposed LVR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NT
 |  | Proposed Rental Amount: |  |  |  |  |  | 550 |  | Per Week
 | OPTIONIAL INPUTS
 |  | Capital Growth Rate: |  |  |  |  |  | 0.06 |  |  |  | Consumer Price Index: |  |  |  |  |  | 0.03
 |  |  |  | Property Expenses: |  |  |  |  |  |  |  |  |  | Loan Interest Rate: |  |  |  | 0.065
 |  |  |  | [NAME]: |  |  |  | Interest Only Repayments
 | STATISTICS
 |  | Today |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Year 6 |  | Year 7 |  | Year 8 |  | Year 9 |  | Year 10
 | Property Value:
 | Equity In Property:
 | Property Growth %: | 0
 | LVR:
 | Loan Balance: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q
 | Surplus to reinvest:
 | Purchase Power: | 0 |  | 104766
 | Rental Income:
 | [NAME] Yield:
 | Net Rental Yield:
 | DEDUCTIONS
 | Property Expenses: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I want to calculate the potential purchase price based off the amount of funds avaialble in Cell E48 and a [NAME] loan to value ratio of cell S17, like the example provided above.  If you are not sure what Loan to Value ratio is it is calcuated as the % of the loan balance against the value of the property
 | Loan Interest Payments:
 | Loan P & I Payments:
 | Pre-Tax Cashflow p/a:
 | Pre-Tax cashflow p/w:
 | NON - CASH DEDUCTIONS
 | Depreciation:
 | FINAL ANALYSIS
 | Total Deductions:
 | Net Profit or Loss:
 | Tax Refund:
 | Land Tax:
 | After-Tax Cashflow p/a:
 | After-Tax cashflow p/w: