tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758609d1638969471-if-with-sumproduct-from-multiple-sheets-result-dig-new-
Sheet: DIGI summary ACT vs. BU-FC

 | ↓↓↓↓↓ P&L NOT including released reserv ↓↓↓↓↓
 | PROFIT & LOSS (TSEK) |  |  |  |  |  | YTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD |  |  |  |  |  |  |  |  | YTD
 | DEPT TOT | Actual | Budget | Delta |  |  |  |  |  |  |  |  | Dept1 |  |  |  |  |  |  |  |  | Dept2 |  |  |  |  |  |  |  |  | Dept3
 | Running operating expenses |  |  |  |  |  |  |  |  |  |  |  | Running operating expenses |  |  |  |  |  |  |  |  | Running operating expenses |  |  |  |  |  |  |  |  | Running operating expenses
 | Content Other Content / Product Costs
 | Content Content / Product staff direct costs
 | Content / Product Costs
 | Marketing Advertising and promotion
 | Marketing Other marketing and advertising costs
 | Marketing and Advertising
 | [NAME] finance and billing
 | Customer Other customer operations costs
 | [NAME] operations staff direct costs
 | Customer Operations
 | Sales Channel marketing support costs OPEX
 | Sales Other channel operating costs OPEX
 | Sales Sales and Distribution staff direct costs OPEX
 | Sales and  Distribution
 | G&A / Other
 | CRC Contract Others (please specify)
 | CRC Contract Retention Staff Direct Costs - contract
 | Net retention costs
 | CAC non contract Revenue from handset sold with SIM (including connection fee)
 | CAC non contract Cost of handsets sold with SIM
 | Net customer acquisition costs
 | Own Retail CAC Contract - Sales Channel marketing support costs
 | Own Retail CAC Contract - Sales Other channel operating costs
 | Own Retail CAC Contract - Sales Sales and Distribution staff direct costs
 | Own retail chain costs - Contract
 | Total OPEX |  |  |  |  |  |  |  |  |  |  |  | Total OPEX |  |  |  |  |  |  |  |  | Total OPEX |  |  |  |  |  |  |  |  | Total OPEX
 | Total Staff Cost |  |  |  |  |  |  |  |  |  |  |  | Total Staff Cost |  |  |  |  |  |  |  |  | Total Staff Cost |  |  |  |  |  |  |  |  | Total Staff Cost
Spreadsheet: 886273d1736315708-copy-and-delete-example
Sheet: Sheet1

Row | PartName | Remark
1 | A | ok |  |  |  | Sub A()
2 | B |  |  |  |  | Dim ws1 As Worksheet, ws2 As Worksheet
 |  |  |  |  |  | Set ws1 = ThisWorkbook.Sheets("sheet1")
 |  |  |  |  |  | Set ws2 = ThisWorkbook.Sheets("sheet2")
 |  |  |  |  |  | If Not Intersect(Target, ws1.Range("B1")) Is Nothing Then
 |  |  |  |  |  | If ws1.Range("b1").Value = "ok" Then
 |  |  |  |  |  | ws1.Range("A1").Copy
 |  |  |  |  |  | Destination = ws2.Range("A1")
 |  |  |  |  |  | s1.Range("A2").Copy
 |  |  |  |  |  | Destination = ws2.Range("A2")
 |  |  |  |  |  | End If
 |  |  |  |  |  | End If
 |  |  |  |  |  | End Sub
Spreadsheet: 682792d1592332632-combining-3-array-formulas-to-one-sample
Sheet: NO

 | Name | Phone | Date order Received | [NAME] | Disc £ ea | Balance | Paid | Product | Notes/ Special Reqs | Status | Collection Date | Time
 | [NAME] | 123456 |  | 2 |  |  | paid | 5f |  |  | 2020-06-10 00:00:00 | 10:00:00
 | [NAME] | 67890 |  | 4 |  |  |  | 5f |  |  | 2020-06-12 00:00:00 | 13:00:00
 | patric | 876543 |  | 6 |  |  | paid | 6f |  |  | 2020-06-08 00:00:00 | 13:00:00
 | [NAME] | 9812345 |  | 5 |  |  |  | 6f |  |  | 2020-06-12 00:00:00 | 11:00:00
Spreadsheet: 47716d1246893444-excel-2007-find-highest-value-from-several-lists-list-example
Sheet: Sheet6

Row Labels | Sum of Points
only1rooney | 78.74007874011811
boltsy32 | 55.67764362830022
blaffaaaa | 45.46060565661953
johgal79 | 39.37003937005905
Yash111 | 35.21363372331802
denice4 | 32.14550253664319
MartinBookie | 29.7609523657138
biluthyrning | 27.83882181415011
DanishDynamit3 | 26.2466929133727
pulern | 24.89979919597747
snoopol16 | 23.74102701309199
salsa75salsa | 22.73030282830976
gambarossa | 21.83856856396675
SuicideMessiah | 21.04417123236605
kanotemet | 20.33060090930254
goose5577 | 19.68501968502953
Opis | 19.09727421264462
expekttroubles | 18.55921454276674
aspireT6 | 18.06421294919001
doyleku | 17.60681686165901
abbecasa | 17.18249385968449
helpisuck | 16.78744119329035
flambookey | 16.41844138130366
Toband | 16.07275126832159
[NAME] | 15.74801574802362
Kalle4444 | 15.44219992298826
AndForFun | 15.15353521887317
goeasy76 | 14.8804761828569
LarsM81 | 14.62166554973392
bjornu | 14.37590576856522
1Caroline | 14.14213562373095
expekt2481 | 13.91941090707505
plikspiesis | 13.70688833684684
PistaBond001 | 13.50381209794
kueki2012 | 13.30950251297385
nanuk11 | 13.12334645668635
Plasil10 | 12.94478920521951
bigmursu | 12.7733274731701
Amc1 | 12.60850343912231
Muqqu084 | 12.44989959798873
bastardcard | 12.2971343082493
JockeExpekt | 12.14985792587912
Tegebro | 12.00774943574473
[NAME] | 11.870513506546
LuckyLuciano3232 | 11.73787790777267
thecube12 | 11.60959123723364
hsonlarsson | 11.48542091597088
ondrejvich | 11.36515141415488
CISKisCRAP | 11.24858267715973
macklani123 | 11.13552872566004
joetam | 11.02581640745847
[NAME] | 10.91928428198338
[NAME] | 10.8157816211068
12345jojo12345 | 10.71516751221439
Viktorph | 10.6173100513865
wuilo | 10.52208561618303
oneydpirate | 10.42937820891358
qlimax07 | 10.33907886245859
EatmySh0rts | 10.2510851017203
[NAME] | 10.16530045465127
Kryddan1 | 10.08163400755528
ch3vch3lios | 10
Grand Total | 1130.004850666997
Spreadsheet: 0c86978f-e6ed-43ce-9bfc-64b0b6fe7f9f
Sheet: Sheet1

Unnamed: 0 | CONSTITUTIONAL AMENDMENT QUESTION | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2000-11-07 00:00:00
 | YES | NO |  | YES | NO
Summary By |  |  | Carroll
Counties |  |  | County
Belknap | 8687 | 11778 | Albany | 105 | 120
Carroll | 9370 | 8526 | [NAME] | 717 | 505
Cheshire | 11369 | 13026 | [NAME] | 138 | 143
Coos | 4751 | 5755 | Chatham | 44 | 45
[NAME] | 12997 | 15075 | Conway | 1455 | 1568
Hillsborough | 58462 | 62430 | Eaton | 56 | 35
Merrimack | 20506 | 25010 | [NAME] | 227 | 289
Rockingham | 52934 | 50543 | Freedom | 386 | 271
[NAME] | 17570 | 18638 | Hale's Location | 0 | 0
[NAME] | 5721 | 8094 | Hart's Location | 11 | 10
TOTALS | 202367 | 218875 | [NAME] | 277 | 135
 |  |  | [NAME] | 431 | 398
Belknap |  |  | Moultonborough | 1153 | 1071
County |  |  | Ossipee | 684 | 671
Alton | 854 | 1098 | Sandwich | 311 | 379
Barnstead | 588 | 891 | Tamworth | 479 | 502
Belmont | 697 | 1447 | Tuftonboro | 630 | 580
Center Harbor | 248 | 234 | Wakefield | 725 | 681
Gilford | 1243 | 1612 | Wolfeboro | 1541 | 1123
Gilmanton | 552 | 766 | TOTALS | 9370 | 8526
[NAME] | 475 | 557
[NAME] | 324 | 412 | Cheshire
[NAME] 3 | 313 | 425 | County
[NAME] | 353 | 463 | Alstead | 328 | 437
[NAME] | 260 | 338 | Chesterfield | 655 | 648
[NAME] 6 | 345 | 473 | Dublin | 359 | 384
Meredith | 1164 | 1265 | [NAME] | 318 | 318
New Hampton | 333 | 502 | Gilsum | 114 | 154
Sanbornton | 471 | 652 | Harrisville | 236 | 201
[NAME] | 467 | 643 | Hinsdale | 566 | 407
TOTALS | 8687 | 11778 | [NAME] | 845 | 963
 |  |  | [NAME] | 512 | 563
 |  |  | [NAME] | 679 | 725
 |  |  | [NAME] 3 | 682 | 778
 |  |  | [NAME] | 663 | 786
 |  |  | [NAME] | 727 | 828
 |  |  | Marlborough | 363 | 452
 |  |  | Marlow | 105 | 224
 |  |  | [NAME] | 144 | 128
 |  |  | Richmond | 179 | 237
 |  |  | Rindge | 830 | 915
 |  |  | Roxbury | 33 | 55
 |  |  | Stoddard | 185 | 236
 |  |  | [NAME] | 103 | 161
 |  |  | [NAME] | 130 | 170
 |  |  | Swanzey | 877 | 1137
 |  |  | Troy | 304 | 405
 |  |  | Walpole | 677 | 670
 |  |  | Westmoreland | 321 | 379
 |  |  | Winchester | 434 | 665
 |  |  | TOTALS | 11369 | 13026
Spreadsheet: 819776d1677686285-adding-a-select-drop-down-filter-calendar-doc
Sheet: Content

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ► |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ◄ Unhide these columns to extend the timeline
 |  |  |  |  |  |  |  | Display Start: | 2023-02-27 00:00:00
 |  |  |  |  |  |  |  | Start Week: | 1
 |  | ACTIVITY TYPE | TITLE | PRIORITY | SHORT [NAME] | DESC LENGTH | CHANNEL IMPACT | DRAFT DATE | PUBLISH DATE | END DATE | LINK
 |  | Events/Training/Huddles | test |  | test |  | test |  | 2023-02-27 00:00:00 | 2023-02-27 00:00:00
 |  | Events/Training/Huddles | test |  | test |  | test |  | 2023-02-28 00:00:00 | 2023-02-28 00:00:00
 |  | Events/Training/Huddles | test |  | test |  | test |  | 2023-03-01 00:00:00 | 2023-03-01 00:00:00
 |  | Events/Training/Huddles | test |  | test |  | test |  | 2023-03-02 00:00:00 | 2023-03-02 00:00:00
 |  | Events/Training/Huddles | test |  | test |  | test |  | 2023-03-03 00:00:00 | 2023-03-03 00:00:00
 |  |  | [NAME] new rows ABOVE this one
 | https://www.vertex42.com/calendars/content-calendar.html |  |  |  |  |  |  |  |  |  | Content Calendar Template © 2020 by Vertex42.com
 |  |  | 😎 DONE
 |  |  | Move rows here after they are published and you no longer need to see them in your list |  |  |  |  |  |  |  | {42}
Spreadsheet: phillip_allen__28829__pivot_1002
Sheet: pivot

Category2 | (All)
Description | (All)
Vendor | (All)
Written | (All)
Sum of Amount | Year | Cleared
 | 1999 |  |  |  | 1999 Total | 2000 |  |  |  |  |  |  |  |  | 2000 Total | Grand Total
Category | August | November | October | September |  | January | February | March | April | May | June | July | August | September
Income |  |  |  |  |  | 15899.83 | 22600.35 | 16504.24 | 16809.79 | 18188.41 | 22000.72 | 17968.54 | 23537.8 | 18108.53 | 171618.21 | 171618.21
Labor |  |  |  |  |  | -1815 | -2972.5 | -2789 | -2839 | -6867.6 | -3187 | -3681.75 | -7005 | -3762 | -34918.85 | -34918.85
Materials |  |  |  |  |  | -1890.81 | -4705.3 | -3104.71 | -2279.33 | -2705.96 | -6037.57 | -5631.09 | -6227.94 | -3916.13 | -36498.84 | -36498.84
Other | 200 |  |  |  | 200 |  | 0 | -10000 |  | 0 | 0 | 0 | 0 | -100 | -10100 | -9900
Services |  | -10 | -10 | -10 | -30 | -66.69 | -177.41 | -47.41 | -52.78 | -311.96 | -53.43 | -397.41 | -4535.99 | -97.41 | -5740.49 | -5770.49
Utilities |  |  |  |  |  | -3675.44 | -5081.28 | -3857.15 | -3933.72 | -3633.04 | -3133.21 | -3658.34 | -5441.89 | -4891.67 | -37305.74 | -37305.74
Personal |  |  |  |  |  | -15846.58 |  |  | -889.4 | -1901.8 | -1441.83 | -1476.69 | -1697.03 | -1547.82 | -24801.15 | -24801.15
Financing |  |  |  |  |  | -3941.3 | -3941.3 |  | -3941.3 | -3941.3 | -3941.3 | -3941.3 | -3941.3 | -3941.3 | -31530.4 | -31530.4
Taxes |  |  |  |  |  | -11639.77 |  |  |  |  |  |  |  |  | -11639.77 | -11639.77
Grand Total | 200 | -10 | -10 | -10 | 170 | -22975.76 | 5722.56 | -3294.03 | 2874.26 | -1173.25 | 4206.38 | -818.0399999999954 | -5311.35 | -147.800000000002 | -20917.03 | -20747.03
Spreadsheet: 10f228c3-4bef-4576-9e5c-95172935f17c
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
CRS | Test | CRS | Chromium, Serum | Chromium, S | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectometry (DRC-ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1.6 | mL | Collection Container/Tube: Plain, royal blue-top Monoject trace element blood collection tube, product #8881-307006 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 1.6 mL Collection Instructions: 1. Allow the specimen to clot for 30 minutes; then centrifuge the specimen to separate serum from the cellular fraction. 2. Remove the stopper. Carefully pour specimen into a Mayo metal-free, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.4 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | <0.3 ng/mL When collected by a phlebotomist experienced in ultra-clean collection technique and handled according to the instructions in Metals Analysis-Collection and Transport in Special Instructions, we have observed the concentration of chromium in serum to be <0.3 ng/mL. However, the majority of specimens submitted for analysis from unexposed individuals contain 0.3-0.9 ng/mL of chromium. Commercial evacuated blood collection tubes not designed for trace-metal specimen collection yield serum containing 2.0-5.0 ng/mL chromium derived from the collection tube. | Tuesday through Friday; 8 a.m. - 11 a.m | 1 day | 4 days | 1 | 82495 |  |  |  |  | Rochester
CRS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CRS | Result | 8638 | Chromium, S | Chromium, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5622-6
Spreadsheet: 6bfa54ba-1efb-4181-9c31-563ae4c400ea
Sheet: Sheet1

Release: International Financial Statistics | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=239
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-17 11:01 AM [NAME]
 | Real-Time | Period
Name: | Start | End
International Financial Statistics | 2011-10-13 00:00:00 | Current
Link:
http://www.imf.org/external/data.htm | 2011-10-13 00:00:00 | Current
Source:
International Monetary Fund | 2011-10-13 00:00:00 | Current
Notes:
The International Financial Statistics (IFS) consist of approximately | 2011-10-13 00:00:00 | Current
32,000 time series covering more than 200 countries starting in 1948.
Includes exchange rates, Fund accounts and the main global and country
economic indicators.
The IMF does not make this data available to the public free of charge
on its website.  The Federal Reserve Bank of St. Louis has been given
permission by the IMF to publish a limited number of IFS time series.
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:
2011-10-13 00:00:00
2012-02-08 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-06-29 00:00:00
2012-08-02 00:00:00
2012-09-04 00:00:00
2012-10-01 00:00:00
2012-11-15 00:00:00
2012-12-03 00:00:00
2013-01-02 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-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-02 00:00:00
2014-01-01 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
Spreadsheet: b623d935-b553-480d-9460-6d98d9e8ed44
Sheet: Weighted Average Calculator

 | Type Name |  | Class Grade: |  | Type Name |  | Class Grade: |  | Type Name |  | Class Grade: |  | Type Name |  | Class Grade: |  | Type Name |  | Class Grade: |  | Type Name |  | Class Grade: |  | Type Name |  | Class Grade: |  | Type Name |  | Class Grade:
 | Type Grade | Points Earned | Points Possible | Type  Weight | Type Grade | Points Earned | Points Possible | Type  Weight | Type Grade | Points Earned | Points Possible | Type  Weight | Type Grade | Points Earned | Points Possible | Type  Weight | Type Grade | Points Earned | Points Possible | Type  Weight | Type Grade | Points Earned | Points Possible | Type  Weight | Type Grade | Points Earned | Points Possible | Type  Weight | Type Grade | Points Earned | Points Possible | Type  Weight
 |  |  |  | 100 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned | Assignment Name | Assignment Grade (0-100) | Assignment  Points Possible | Assignment  Points Earned
Spreadsheet: 538338d1505542981-filter-data-from-table-that-have-unique-characteristics-s666-1201175-filter-data-from-table-that-have-unique-characteristics
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 |  | Score | 0.5312002088526958 | 0.5285056218230669 | 0.2913163178364175 | 0.2639660761637467 | 0.2563116726086936
Score | 0.5312002088526958 | 0.5285056218230669 | 0.3711687736490517 | 0.3485801902474591 | 0.3167337155327513 | 0.2913163178364175 | 0.2879042689418327 | 0.2639660761637467 | 0.2563116726086936 |  | Type | 29 | 27 | 25 | 10 | 30
Type | 29 | 27 | 27 | 29 | 27 | 25 | 29 | 10 | 30
Column1 | Column2 | Column3 | Column4 | Column5 | Column6
Score | 0.5312002088526958 | 0.5285056218230669 | 0.2913163178364175 | 0.2639660761637467 | 0.2563116726086936
Type | 29 | 27 | 25 | 10 | 30
Spreadsheet: 70334d1271116435-if-formula-config-sheet-budget-2011
Sheet: Mar

1st |  |  |  | 8th |  |  |  | 15th |  |  |  | 22nd |  |  |  |  |  |  |  |  |  |  |  | Income
Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Transfer
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Birthday
Savings Balance |  | 0 |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Clothing
Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Entertainment
Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Fast Food
 |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  | Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Insurance
Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Loan
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Misc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smokes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over
Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings
Spreadsheet: 729685d1619257993-pull-the-content-of-the-last-cell-of-a-column-from-multiple-sheets-to-a-master-front-sheet-example-31-ans
Sheet: Flight Log

Flight # | Pilot | Date | Location | Day / Night | Start Time | Finish Time | Duration | Issues | Batt # | Camera | Comments
 |  |  |  |  |  |  |  |  |  |  |  | Total Flight Time: |  | Typhoon Battery 1 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Typhoon Battery 2 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Typhoon Battery 3 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Typhoon Battery 4 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Typhoon Battery 5 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Typhoon Battery 6 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Typhoon Battery 7 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Typhoon Battery 8 Charge Cycles:
 |  |  |  |  |  |  |  |  |  |  |  | Total Flights:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Flight Time on Battery 1:
 |  |  |  |  |  |  |  |  |  |  |  | Total Day Flights: |  | Total Flight Time on Battery 2:
 |  |  |  |  |  |  |  |  |  |  |  | Total Night Flights: |  | Total Flight Time on Battery 3:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Flight Time on Battery 4:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Flight Time on Battery 5:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Flight Time on Battery 6:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Flight Time on Battery 7:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Flight Time on Battery 8:
Spreadsheet: 199518d1355243849-matching-multiple-criteria-both-exactly-and-approximately-example-coded-vs-charges
Sheet: Sheet2

DOS | PT NAME | CPT | MOD | DX 1 | DX 2 | DX3
2012-11-08 00:00:00 | [NAME], [NAME] | 99284 |  | 9 | 787.91 | 729.1
2012-11-08 00:00:00 | Connery, Sean | 99284 |  | 307.81
2012-11-08 00:00:00 | Doe, [NAME] | 99284 |  | 535.5 | 789.09 | 787.91
2012-11-08 00:00:00 | Doe, [NAME] | 99284 |  | 351 | 788 | 599
2012-11-08 00:00:00 | [NAME], [NAME] | 99285 | 25 | 995.3
2012-11-08 00:00:00 | [NAME], [NAME] | 93010 |  | 995.3
Spreadsheet: 682488d1592143894-automating-a-task-automating-task-1-
Sheet: E

May | E | <-- Select client
EU | Stock 1 |  |  |  | Stock 2
Week number / Week ending: | Open | Receipts | Pick | Close | Open | Receipts | Pick | Close | Totals | Returns
(18) .01/05/2020 | 0 |  |  |  | 0
(19). 08/05/2020
(20). 15/05/2020
(21). 22/05/2020
(22). 29/05/2020
 |  |  |  |  |  |  | Inbound | Outbound | Storage | Returns
 |  |  |  |  |  | Total:
 |  |  |  |  |  | Rate: | 14.65 | 94.56 | 864.25 | 9999
 |  |  |  |  |  | Invoice:
US | Stock 1 |  |  |  | Stock 2
Week number / Week ending: | Open | Receipts | Pick | Close | Open | Receipts | Pick | Close | Totals | Returns
(18) .01/05/2020 | 0 |  |  |  | 0
(19). 08/05/2020
(20). 15/05/2020
(21). 22/05/2020
(22). 29/05/2020
 |  |  |  |  |  |  | Inbound | Outbound | Storage | Returns
 |  |  |  |  |  | Total:
 |  |  |  |  |  | Rate: | 24.65 | 104.56 | 874.25 | 11111
 |  |  |  |  |  | Invoice:
Columns C, E, G, and I are where I manually input data
The equation in C24 is what I have in mind, it should be 7 due to the US/ USA issue, but can something like this be scaled up.