tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64feffff-c35e-46cd-8741-e830b57ee081
Sheet: Sheet1

Release: Kansas City Financial Stress Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=198
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-29 11:55 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Kansas City Financial Stress Index | 2010-11-08 00:00:00 | Current
Link:
http://www.kansascityfed.org/research/indicatorsdata/kcfsi/ | 2010-11-08 00:00:00 | Current
Source:
Federal Reserve Bank of Kansas City | 2010-11-08 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-11-08 00:00:00
2010-12-08 00:00:00
2011-01-10 00:00:00
2011-02-08 00:00:00
2011-03-08 00:00:00
2011-04-08 00:00:00
2011-05-09 00:00:00
2011-06-08 00:00:00
2011-07-11 00:00:00
2011-08-08 00:00:00
2011-09-09 00:00:00
2011-10-11 00:00:00
2011-11-08 00:00:00
2011-12-08 00:00:00
2012-01-09 00:00:00
2012-02-08 00:00:00
2012-03-08 00:00:00
2012-04-09 00:00:00
2012-05-08 00:00:00
2012-06-08 00:00:00
2012-07-10 00:00:00
2012-08-08 00:00:00
2012-09-11 00:00:00
2012-10-09 00:00:00
2012-11-08 00:00:00
2012-12-10 00:00:00
2013-01-09 00:00:00
2013-02-08 00:00:00
2013-03-08 00:00:00
2013-04-08 00:00:00
2013-05-08 00:00:00
2013-06-10 00:00:00
2013-07-09 00:00:00
2013-08-08 00:00:00
2013-09-10 00:00:00
2013-10-08 00:00:00
2013-11-08 00:00:00
2013-12-09 00:00:00
2014-01-09 00:00:00
2014-02-10 00:00:00
2014-03-10 00:00:00
2014-04-08 00:00:00
2014-05-08 00:00:00
2014-06-09 00:00:00
2014-07-09 00:00:00
Spreadsheet: 144366d1330955888-database-search-test-data
Sheet: Address

tilte | initial | name |  | address 1 |  | address 2 | town | county | postcode
Mr | R | Bellew |  | 57 [NAME] |  | Park Street | St albans | Hertfordshire | AL2 2HP
Mr | A | Wilson |  | 23a How Wood |  |  | St albans | Hertfordshire | AL2 2QY
Mr | S | O'Neill |  | 189 - 191 High Street |  |  | Barnet | Hertfordshire | EN5 5SU
Mr | R | [NAME] |  | c/o Bergson And Eaton Ltd | 4 - 12 Kemson Close |  | Aylesbury | Buckinghamshire | HP19 8UQ
Mr | C | Rogers |  | c/o Bell Norris & Co | 1 Longmoor Barns | Cublington Road Aston Abbotts | Aylesbury | Buckinghamshire | HP22 4ND
Mr | J | Bly |  | Plough Cottage | Church Yard |  | Tring | Hertfordshire | HP23 5AE
Mr | E | Stafford - East |  | c/o Jeremy Gibbs & Co | 36 Sycamore Road |  | Amersham | Buckinghamshire | HP6 5DR
Mr | P | Beasley |  | 28 Dunton Road |  |  | Stewkley | Buckinghamshire | LU7 0HZ
Mr | M | Dunn |  | Manor Farm | [NAME] |  | Newton longville | Buckinghamshire | MK17 0AU
Dr | H | [NAME] |  | 27 Dale Green Road |  |  | London |  | N11 1DN
Mr | B | Gallagher |  | Building 4 | North London Business Park | Oakleigh Road South | London |  | N11 1NP
Mr |  | Bakhshi |  | 23 Laurel Way |  |  | London |  | N20 8HS
Miss | M | Aghdaei |  | 103 Dollis Road |  |  | London |  | N3 1RE
Mr |  | Wolanski |  | 1 Eton Avenue |  |  | London |  | NW3 3EL
Dr | N | Gutkin |  | 9 Downage |  |  | London |  | NW4 1AS
Mr | B | [NAME] |  | Foframe House | 35-37 Brent Street |  | London |  | NW4 2EF
Mr | D | Davila |  | 39 Neeld Crescent |  |  | London |  | NW4 3RP
Mr | S | Quinn |  | 8 Hartley Avenue |  |  | London |  | NW7 2HX
Mr | A | Bou Saba |  | Flat 2 | 71 Marlborough Road |  | London |  | NW8 0PT
Mr | B | [NAME] |  | c/o C R J Anstey Chartered Surveyors | Oakapple Farm | Marsh Gibbon | Bicester | Oxfordshire | OX27 0AL
Mr | N | [NAME] |  | Lilac Cottage | Chapel End | [NAME] | Gerrards cross | Buckinghamshire | SL9 9EB
Miss | L | Jermy |  | 11 Laurel Road |  | [NAME] | Gerrards cross | Buckinghamshire | SL9 9SN
Mr | N | Pike |  | c/o [NAME] | Netherstreet | [NAME] | Chippenham | Wiltshire | SN15 2DW
Mr |  | [NAME] |  | 52 The Chase |  |  | London |  | SW4 0NH
Dr |  | [NAME] |  | 30 Magnaville Road |  |  | Bushey | Hertfordshire | WD23 1PP
Miss | S | Lynch |  | 3 The Studios | [NAME] |  | Bushey | Hertfordshire | WD23 3AF
Dr | C | Croft |  | [NAME] | [NAME] |  | Rickmansworth | Hertfordshire | WD3 1PX
Mr | B | [NAME] |  | Highfield | [NAME] | Sarratt | Rickmansworth | Hertfordshire | WD3 6AW
Mr | R | [NAME] |  | 1 Banks Road |  |  | Borehamwood | Hertfordshire | WD6 5QR
Spreadsheet: 124801d1318612276-formula-to-populate-in-a-certain-format-example1
Sheet: Sheet1

Name | W | L | Record
A | 5 | 2
B | 8 | 6
C | 8 | 5
D | 6 | 7
E | 3 | 9
F | 12 | 10
G | 10 | 12
H | 12 | 13
I | 11 | 10
J | 7 | 15
K | 8 | 3
L | 9 | 5
M | 21 | 20
N | 2 | 2
O | 21 | 18
P | 17 | 10
Q | 14 | 13
R | 21 | 10
S | 13 | 12
T | 15 | 20
U | 12 | 10
V | 13 | 11
W | 8 | 5
X | 7 | 6
Y | 3 | 2
Spreadsheet: 714933d1611442631-populate-calendar-in-excel-from-list-help-calendar
Sheet: Month

Budget Calendar with Daily Balance
Year: | 2021 |  | Month: | 1 |  | Start Day: | 1 | 1=Sun, 2=Mon …
Date:
Spreadsheet: 26336d1218478779-inputing-hours-in-cells-book2
Sheet: Sheet1

NAME | SHIFT |  |  | HRS SCHED | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00
[NAME] |  | - |  | 0 | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M
Shellie |  | - |  | 0 |  |  |  |  | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M
Brent |  | - |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | M | M | M | M | M | M | M | M | M | M | M
 |  | - |  | 0
Paola |  | - |  | 8
[NAME] |  | - |  | 8 | 1 | 1 | 1 | 1
Marnie |  | - |  | 7.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] |  | - |  | 7.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Damean |  | - |  | 6 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 0a3e1fd2-e933-44ef-9844-30f5f8f87985
Sheet: Sheet1

Changes in Net Pension Liability | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  | Increase (Decrease)
 |  |  |  | TPL |  | PNP |  | NPL
 |  |  |  | (a) |  | (b) |  | (a)-(b)
Balances --at 06/30/2014 |  |  | $ | 285000000 | $ | 171000000 | $ | 114000000
Changes for the year:
 | Service Cost |  |  | 7500000 |  |  |  | 7500000
 | Interest |  |  | 12000000 |  |  |  | 12000000
 | Difference between expected |  |  |  |  |  |  | 0
 | and actual experience |  |  | -3500000 |  |  |  | -3500000
 | [NAME] |  |  |  |  | 9000000 |  | -9000000
 | [NAME] Member |  |  |  |  | 4500000 |  | -4500000
 | Net investment income |  |  |  |  | 15000000 |  | -15000000
 | Benefits paid |  |  | -8500000 |  | -8500000 |  | 0
 | Plan administrative expenese |  |  |  |  | -150000 |  | 150000
 | Other |  |  |  |  | 50000 |  | -50000
 |  | Net changes |  | 7500000 |  | 19900000 |  | -12400000
Balances --at 06/30/2015 |  |  | $ | 292500000 |  | 190900000 |  | 101600000
JE 1
 |  |  | DR | CR |  | Pension expense:
Net position |  |  | 114000000 |  |  | Service cost |  | 7500000
Pension expense |  |  | 1350000 |  |  | Interest on liability |  | 12000000
Deferred inflow-expected v. actual |  |  |  | 3150000 |  | Difference exp and act |  | -350000
Deferred inflow-invest |  |  |  | 1600000 |  | Expected ret. |  | -13000000
Contributions |  |  |  | 9000000 |  | Employee contrib. |  | -4500000
NPL |  |  |  | 101600000 |  | Plan fees |  | 150000
 |  |  | 115350000 | 115350000 |  | Differ project and act inv |  | -400000
 |  |  |  |  |  | Other changes |  | -50000
 |  |  |  |  |  |  |  | 1350000
Projected earnings were: |  |  | 13000000 | 5 years closed, first year current year
Differences between expected
actual experience |  |  | -3500000 | Amortized over 10 years (expected remaining
 |  |  |  | service lives of all employees, active and inactive)
Contributions after
measurement date |  |  | 4600000
 |  |  |  | 0
Spreadsheet: 784770d1655950592-excel-lookup-multiple-criteria-excel-sample-workbook
Sheet: Sheet1

Product | Source | Amount | Manual Count | [NAME]
Apple | Online | 2000 | 1 |  |  |  | New Compensation Structure (w.e.f Q1FY23)
Pear | Supermarket | 4000 | 2 |  |  |  | Count (Source A 1X) | Count (Source B 2X) | $ - Apple, Orange, Pear, Cherry | $ - Watermelon, [NAME]
Orange | [NAME] | 5000 | 2 |  |  |  | 1x | 2x | <$5K | <$10K
[NAME] | Supermarket | 6000 | 4 |  |  |  | 2x | 4x | $5K-$10K | $10K-$30K
[NAME] | [NAME] | 7000 | 1 |  |  |  | 3x | 6x | >$10K | >$30K
Watermelon | Supermarket | 10000 | 4
[NAME] | Wet Market | 35000 | 3 |  |  |  | Source A | Source B
 |  |  |  |  |  |  | Wet Market | Supermarket
 |  |  |  |  |  |  | Convenience store
 |  |  |  |  |  |  | Online
 |  |  |  |  |  |  | Fruit store
Spreadsheet: 542990d1508189817-automatically-creating-names-for-multiple-rows-create-from-selection-upload-excelforum
Sheet: Sheet1

 | 1 | 3610 | ABCD
_01361001 | 1 | TEST01 |  | Manufacturing Location
_01361001 |  |  |  | Recycled Content
_01361002 | 2 | TEST02 |  | Manufacturing Location
_01361002 |  |  |  | Product Content
_01361003 | 3 | TEST03 |  | Product Content
_01361003 |  |  |  | Manufacturing Location
 |  |  |  | Rental
 | 1 | 5000 | DEFG
_015000601 | 1 | TEST06 |  | FSC Certified Wood
_015000601 |  |  |  | Reuse
_015000601 |  |  |  | Rental
_015000601 |  |  |  | Reuse
_015000601 |  |  |  | Harvest/Extraction Location
_015000601 |  |  |  | Manufacturing Location
_015000602 | 2 | TEST10 |  | Reuse
_015000602 |  |  |  | Harvest/Extraction Location
_015000603 | 3 | TEST17 |  | Rental
_015000603 |  |  |  | Reuse
 | 2 | 3800 | HIJK
_02380001 | 1 | TEST13 |  | Harvest/Extraction Location
_02380001 |  |  |  | Responsible Extraction
_02380002 | 2 | TEST17 |  | Harvest/Extraction Location
_02380002 |  |  |  | Responsible Extraction
_02380003 | 3 | TEST14 |  | Rental
_02380003 |  |  |  | Manufacturing Location
_02380003 |  |  |  | Recycled Content
Spreadsheet: 875965d1722599255-vlookup-not-giving-the-intended-answer-error-etaf
Sheet: Sheet1

 |  | Name | Work Days | Salary |  | VLOOKUP | Salary
 |  | [NAME] | 29 | 45600 |  | [NAME]
 |  | [NAME] | 26 | 45200 |  | [NAME]
 |  | Saroj Chandra | 34 | 62200 |  | Saroj Chandra
 |  | [NAME] | 37 | 30600 |  | [NAME]
 |  | [NAME] | 33 | 40800 |  | [NAME]
 |  | [NAME] | 36 | 39200 |  | [NAME]
 |  | [NAME] | 20 | 41500 |  | [NAME]
 |  | Karthik Jeeva | 30 | 58000 |  | Karthik Jeeva
 |  | [NAME] | 21 | 23100 |  | [NAME]
Spreadsheet: 888529d1739035481-formula-needed-that-only-counts-data-for-certain-months-example
Sheet: January

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | Ricardo Herrera
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | Alexis Jaimes
 | [NAME]
 | Alexis Jaimes
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 7. Buildings

FY 2013 Federal Real Property Charts
Buildings†
Agency | Owned Building Assets** | Owned SF** | Owned Annual Operating Costs** | Leased Building Assets | Leased SF | Leased Annual Costs*
Agriculture | 21184 | 41476022 | 329317565.76 | 3330 | 16047869 | 232673125.64
Air Force*** | 46494 | 522779824 | 2594611372.78 | 4635 | 59215057 | 366053484.17
Army*** | 85213 | 775580897.569 | 2691022327.49 | 15085 | 121194625.01 | 590456154.57
Commerce | 483 | 7517403 | 49741597 | 166 | 1101121 | 27199323.15
Corps of Engineers*** | 952 | 10251885.5 | 38812004.34 | 220 | 2446311.14 | 38085476.08
Defense/WHS*** | 102 | 7523499.04 | 39482254.39
Energy | 10399 | 117005578 | 1753273143 | 58 | 1206522 | 13564612
Environmental Protection Agency | 171 | 4168577 | 40269125.92 | 3 | 201983 | 16061066.63
General Services Administration | 1585 | 227310604.54 | 1158792284.11 | 7120 | 199856142.57 | 5449843313.58
Health and Human Services | 2725 | 32422392.078 | 404684889.322 | 87 | 2638929.9 | 84976315.551
Homeland Security | 9103 | 43059194.23 | 362853670.11 | 1233 | 10269353.82 | 116111640.43
Interior | 43206 | 102403967.1 | 430352512.022 | 319 | 3636036 | 66101044.277
Justice | 3854 | 69891875 | 590637721.93 | 32 | 842363 | 12303303.52
Labor | 2106 | 21991503 | 97726859.17 | 292 | 3338316 | 26337382.273
National Aeronautics And Space Administration | 2428 | 45879725 | 277660074 | 9 | 861362 | 6683110
National Science Foundation | 435 | 5948240.66 | 34259810.96 | 12 | 192937 | 2802575.2
Navy*** | 47465 | 483501504.84 | 3314280987.8 | 4416 | 57312479.04 | 605188766.56
Office of Personnel Management |  |  |  | 4 | 74985 | 1097640
State | 4630 | 44444811 | 427903047.81 | 13329 | 38731596 | 922559011.66
State (USAID) | 100 | 1057655 | 7262039.35 | 1494 | 4268867 | 80778292.6
Transportation | 10015 | 19105095.25 | 210052503.69 | 1081 | 6479850 | 119834583.14
Treasury | 11 | 4088647 | 71409084 | 95 | 2265341 | 82291320
Veterans Affairs | 6032 | 151656981 | 783325053.52 | 1571 | 15807957 | 294274192.08
Total
† All real property data from the CFO Act agencies required to submit data to the FRPP
*Includes operations and maintenance costs and rent
**includes federal government owned, foreign government owned, museum trust, state government owned
*** Department of Defense
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -44020
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -2414541
58710 | -78159 | -41897
60921 |  | 1667119
78026 | 19288 | 73214
500084 | -8383 | -24000
500085
500097
INDEX
2001-05-31 00:00:00 |  |  | 597578.71
2001-06-24 00:00:00
Spreadsheet: 486230d1477394727-creating-a-field-that-can-create-specific-cells-samplebook
Sheet: Folha1

 | This is the default table with the products (and possibly all the tools's specifications)
 | Tool Name | Brand | Product Type | Cutting Depth | Fuel Consumption | Chain Speed | Power | Electrical Consumption | [NAME] | Size | Thickness
 | Electrical Saw ES433 | AEG | Electrical Saw
 | [NAME] | AEG | Chainsaw
 | Lawnmower [NAME] | AEG | Lawnmower
 | Now, if for the selected tool I pick "Electrical Saw" as product type, all the other fields disappears and I fill the current field with what I want to.
 | Tool Name | Brand | Product Type | Cutting Depth | Power | Electrical Consumption
 | Electrical Saw ES433 | AEG | Electrical Saw
 | [NAME] | AEG | Chainsaw
 | But in here, if I picked on the dropdown (or checkbox) the product type as chainsaw, all the other fields would disappear and only the specifications for product type "[NAME]" would appear.
 | Tool Name | Brand | Product Type | Cutting Depth | Fuel Consumption | Chain Speed.
 | Electrical Saw ES433 | AEG | Chainsaw
 | I added three more pages for the specifications for Chainsaw and Lawnmower, but it's something like this.
 | Also, if I could somehow get some other way to get the specifications for every type of tool without having to type them all in a line, it would greatly help (because there's different types of specifications.)
Spreadsheet: 73686d1274295444-create-a-user-friendly-log-sheet-saleslog
Sheet: Orders

Date | Distributor | Purchaser | PO Amount
2010-01-01 00:00:00 | B | [NAME] | 5800
2010-02-01 00:00:00 | dasdf | [NAME] | 150 |  |  |  | Distributor column will have dropdown lists
2010-03-01 00:00:00 | Cz | bob | 35000 |  |  |  | Purchaser will be a text field
2010-04-01 00:00:00 | A | [NAME] | 27.56
2010-05-01 00:00:00 | Cz | kathy | 8000
 |  |  |  |  |  |  |  |  | <---- pushing this button will essentially "copy" the formatting/data validation of the last line on the sales log and insert it as a new line at the bottom of that list
Spreadsheet: 842452d1694526873-rolling-calculation-example-162-aligw
Sheet: Sheet1

Region | Jul 2022 | Aug 2022 | Sep 2022 | Oct 2022 | Nov 2022 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | June 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | VS Prior Month | VS PY | VS Prior 6 Months | VS Prior 12 Months
Territory 1 | 86118.63 | 126859.59 | 76883.35 | 90932.71 | 90466.84 | 69726.27 | 76280.31 | 61440.82 | 87304.35 | 108757.95 | 53716.34 | 79644.16 | 64184.87
Territory 2 | 101492.71 | 124631.16 | 146052.37 | 89587.98 | 186526.83 | 137164.76 | 122946.73 | 99532.94 | 114672.84 | 96769.05 | 136331.73 | 153595.93 | 96365.53
Territory 3 | 269984.87 | 321286.66 | 421870.74 | 269539.67 | 364012.47 | 357367.37 | 331032.84 | 325889.65 | 438793.77 | 285095.09 | 321867.97 | 402809.87 | 317118.7
Territory 4 | 25944.51 | 18335.23 | 21297.26 | 13362.16 | 26404.7 | 16105.44 | 30692.75 | 13624.44 | 35108.39 | 26654.19 | 24124.69 | 20571.13 | 40951.22
Territory 5 | 6348.53 | 2224.72 | 3927.29 | 2750.53 | 3906.02 | 5804.93 | 1670.85 | 13139.35 | 4992.88 | 6723.41 | 3932.21 | 6002.36 | 11275.43
Spreadsheet: 293836d1391103179-translating-city-codes-to-names-example-attached-vlookup
Sheet: Data

Account_Num | Situs_Address | City | Situs_City
03230597 | 1045 Reed St | 028
02176580 | 2816 Gardenia Dr | 026
05301793 | 1116 Matlock Rd | 017
03201457 | 618 Dickey Dr | 025
03288714 | 1027 [NAME] | 017
00539309 | 2124 Mountainview Dr | 028
01498398 | 322 W Broadway St | 014
01286153 | 1200 Magnolia St | 017
02668963 | 7521 [NAME] Dr | 026
04990455 | 7819 Lowery Rd | 026
02668726 | 7637 Beckwood Dr | 026
00264598 | 1512 Grantland Cir | 026
Here is what the table should look like after [NAME]
Account_Num | Situs_Address | City | Situs_City
03230597 | 1045 Reed St | 028 | Hurst
02176580 | 2816 Gardenia Dr | 026 | Fort Worth
05301793 | 1116 Matlock Rd | 017 | Mansfield
03201457 | 618 Dickey Dr | 025 | Euless
03288714 | 1027 [NAME] | 017 | Mansfield
00539309 | 2124 Mountainview Dr | 028 | Hurst
01498398 | 322 W Broadway St | 014 | [NAME]
01286153 | 1200 Magnolia St | 017 | Mansfield
02668963 | 7521 [NAME] Dr | 026 | Fort Worth
04990455 | 7819 Lowery Rd | 026 | Fort Worth
02668726 | 7637 Beckwood Dr | 026 | Fort Worth
00264598 | 1512 Grantland Cir | 026 | Fort Worth
Spreadsheet: 861050d1709047809-excess-counting-logic-help-incentive-calculation
Sheet: Sheet1

Loans | Loans Conversion | Cards | Target | Total Achievement | Eligible for incentive? | Excess Loan |  | Excess Card | 0-10 | 11-15 | 16-20 | 21+
635500 |  | 10 | 8 |  |  |  |  |  |  |  |  |  | this the formula you gave me which needs some ammendment
Only "Cards" should be counting on slabs after the "Target" but based on the total "Achievement"
Examples:
Loans | Loans Conversion | Cards | Target | Total Achievement | Eligible for incentive? | Excess Loan |  | Excess Card | 0-10 | 11-15 | 16-20 | 21+
635500 |  | 10 | 8 |  |  |  |  |  |  | 3 | 5 | 2 | since total achievement is 22.71 and target is 8, I need to count the 10 cards after the 12.71 loans so 13th onwards as per slab
500000 |  | 4 | 6 |  |  |  |  |  | 0 | 4 | 0 | 0 | since total achievement is 14 and target is 6, I need to count the 4 cards as 11th,12th,13th,14th
250000 |  | 6 | 5 |  |  |  |  |  | 5 | 0 | 0 | 0
175000 |  | 2 | 7 |  |  |  |  |  | 0 | 0 | 0 | 0 | total achievement is less than target so all slabs should be zero
654987 |  | 9 | 11 |  |  |  |  |  | 0 | 2 | 5 | 2
789654 |  | 5 | 16 |  |  |  |  |  | 0 | 0 | 4.79308 | 0
Spreadsheet: 749252d1632646851-counting-details-from-multiple-sheets-file
Sheet: Vehicle Three

Log
SR.# | DATE | SALES EXECUTIVE |  | [NAME] | [NAME] | [NAME] | Ashraf [NAME] | [NAME] | [NAME] | [NAME]. [NAME] | [NAME]
1 | 2021-09-01 00:00:00 | Savanna
2 | 2021-09-04 00:00:00 | Krystin
3 | 2021-09-04 00:00:00 | [NAME]
4 | 2021-09-05 00:00:00 | Isobel
5 | 2021-09-07 00:00:00 | [NAME]
6 | 2021-09-11 00:00:00 | Savanna
7 | 2021-09-11 00:00:00 | Krystin
8 | 2021-09-12 00:00:00 | [NAME]
9 | 2021-09-14 00:00:00 | Isobel
10 | 2021-09-14 00:00:00 | [NAME]
11 | 2021-09-15 00:00:00 | Savanna
12 | 2021-09-15 00:00:00 | Krystin
13 | 2021-09-16 00:00:00 | [NAME]
14 | 2021-09-18 00:00:00 | Isobel
15 | 2021-09-18 00:00:00 | [NAME]
16 | 2021-09-18 00:00:00 | Savanna
17 | 2021-09-21 00:00:00 | Krystin
18 | 2021-09-22 00:00:00 | [NAME]
19 | 2021-09-23 00:00:00 | Isobel
20 | 2021-09-25 00:00:00 | [NAME]
21 | 2021-09-25 00:00:00 | Savanna
Spreadsheet: 07f6b4fb-70f6-4eeb-b7ef-868f4b809903
Sheet: Sheet1

Parameter | Symbol | 0-6 h | 6-24 h | 24-36 h | 36-48h
Division rate, liver | lL | 0.375 | ↓ 0.107 | ↑ 0.146 | 0.146
Death rate, liver | mL | 0.635 | ↓ 0.017 | 0.017 | 0.017
Net growth rate, liver | rL = lL–mL | -0.26 | ↑ 0.090 | ↑ 0.129 | 0.129
Division rate, spleen | [NAME] | 0.44 | ↓ 0.097 | ↑ 0.133 | 0.133
Death rate, spleen | mS | 0.59 | ↓ 0.009 | 0.009 | 0.009
Net growth rate, spleen | rS = [NAME]–mS | -0.15 | ↑ 0.088 | ↑ 0.124 | 0.124
Transfer rate from the blood to the liver | qL | 0.527 | 0.646 | 0.646 | 0.646
Transfer rate from the blood to the spleen | qS | 0.59 | 0.724 | 0.724 | 0.724
Transfer rate from the organs to the blood | qB | 0 | 0 | 0 | ↑ 0.005
Spreadsheet: 454829d1459985150-simplify-calculation-remove-steps-from-existing-sheet-disc-1
Sheet: Data

 |  |  |  |  |  | Ground | Ground | Ground | Ground
 |  | Next_Day_Air | Next_Day_Saver | 2nd_Day_Air | 3_Day_Select | 1-5 lbs. | 6-10 lbs. | 11-30 lbs. | 31+lbs.
 | 0 | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08
 | 50 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09
 | 100 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1
 | 200 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11
 | 300 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12
 | 400 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13
 | 600 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14
 | 800 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15
 | 1000 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16
 | 2000 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17
Spreadsheet: 715616d1611788316-count-of-last-number-from-an-array-between-two-values-counttestv2
Sheet: Sheet1 orig

 | Count of values between 0.5 and 2.5 among the last 3 instances of each | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00
Alpha |  | 4 |  |  | 3 |  | 4 | 2 |  | 3 |  |  | 2
Beta |  | 0 |  |  | 2 |  | 1 | 3 |  | 0
Gamma |  | 2 |  | 3 |  | 2 |  | 0 | 1 |  | 3 |  |  |  | 1
Delta |  | 1 |  | 1 |  | 2 |  | 3 | 3 |  | 4 |  |  |  | 3
Epsilon |  | 3 |  | 0 |  | 1 |  | 2 | 0 |  | 1 |  |  |  | 2
Zeta |  | 3 |  | 0 |  | 2 |  | 0 | 0 |  | 0 |  |  |  | 2
Eta |  | 0 |  | 3 |  | 7 |  |  | 2 |  | 1 |  | 1
Theta |  | 2 |  | 5 |  | 5 |  |  | 5 |  | 4 |  | 2
Iota |  | 1 |  | 1 |  | 0 |  |  | 1 |  | 0
Kappa |  | 3 |  | 2 |  | 2 |  |  | 3 |  | 1 |  | 2
Lamda |  | 1 |  | 1 |  | 1 |  |  | 3 |  |  |  | 2
Spreadsheet: 737590d1624490276-2-columns-instead-of-zz-example-forum-23062021
Sheet: Blad1

0 | nummer | ref
 | 1 | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p
 | 2 | a | b | c | d | e | f | g
 | 3 | a | b | c | d | e | f | g | h | i | j | k
 | 4 | k | l | m | n | o | p | q | r | s | t
 | Has to become
 | number | ref