tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: brad_mckay__1412__NY City Forecast
Sheet: Transco Meters

 | [NAME] on TRANSCO
 |  | -ve gas off system
 |  | +ve gas into system |  |  |  |  |  | Z6 NY Deliveries
 |  | Meter # | [NAME] | Peak Day | Non coinsidental Peak day |  |  | Meter # | LDC | [NAME] | Peak Day | Non coinsidental Peak day
 | p | 3057 | Linden Oakford Received | 132339 | 155184
 | p | 3091 | Riverdale | 65652 | 110337
 | p | 3146 | East Rutherford | 5343 | 8079
 | p | 3195
 | p | 3198 | CIGS Sendout | 130182 | 199110
 | p | 3563 | Orange Rockland Rivervale In | 18893 | 44740
 | p | 3572 | St. 240 Regeneration Gas | 10946 | 13368
 | p | 4050
 | p | 4145 | [NAME] In | -23099 | -26233
 | p | 4195
 | p | 6023 | Erie Street | -71603 | -71603
 | p | 6028 | Richmond Narrows | -7216 | -12401 |  |  | p | 6028 | Richmond Narrows | -7216 | -12401
 | p | 6037
 | p | 6039 | [NAME] | -29557 | -59909
 | p | 6043 | West End | 0 | -133802
 | p | 6047 | Paterson | -61934 | -67115
 | p | 6051
 | p | 6051 | Manhatten | -460706 | -512853 |  |  | p | 6051 | Manhatten | -460706 | -512853
 | p | 6062 | Narrows | -162449 | -266058 |  |  | p | 6062 | Narrows | -162449 | -266058
 | p | 6087 | Emerson | -55422 | -59679
 | p | 6091 | Fairlawn | -1328 | -1478
 | p | 6095
 | p | 6097 | East Rutherford | -171301 | -185904
 | p | 6101 | Ridgefield | -41201 | -99409
 | p | 6115 | Central Manhatten | -450282 | -537607 |  |  | p | 6115 | Central Manhatten | -450282 | -537607
 | p | 6137 | Roseland | -63295 | -81887 |  |  | p
 | p | 6147 | Paramus | -125508 | -138817 |  |  | p
 | p | 6153 | North Avenue | -28902 | -31869 |  |  | p | 6153 | North Avenue | -28902 | -31869
 | p | 6178 | East Rutherford #2 | -5343 | -8079 |  |  | p | 6178 | East Rutherford #2 | -5343 | -8079
 | p | 6210 | Long Beach | -307164 | -419514 |  |  | p | 6210 | Long Beach | -307164 | -419514
 | p | 6230 | [NAME] | 0 | -57589 |  |  | p
 | p | 6236 | Kearny | 0 | -41961 |  |  | p
 | p | 6255 | Gillette | -31114 | -33895 |  |  | p
 | p | 6263 | [NAME] | -62573 | -239317 |  |  | p
 | p | 6266 |  |  |  |  |  | p
 | p | 6284 | [NAME] | -33236 | -34795 |  |  | p
 | p | 6287 | Bridgewater | -33239 | -35450 |  |  | p
 | p | 6301 | [NAME] | -1099 | -1944 |  |  | p | 6301 | [NAME] | -1099 | -1944
 | p | 6302 | Hoechst Celanese Cogen | 0 | -1805 |  |  | p
 | p | 6303 | PSE&G Chatam | -22339 | -27394 |  |  | p | 6303 | PSE&G Chatam | -22339 | -27394
 |  |  | Supply |  |  |  |  |  |  | Supply
 |  |  | Demand |  |  |  |  |  |  | Demand
Spreadsheet: 673148d1587215771-get-last-non-zero-value-of-a-row-test1
Sheet: Sheet1

 |  | Sales
Name | Last Date Sold | 27/03/2020 | 30/03/2020 | 31/03/2020 | 01/04/2020 | 02/04/2020 | 03/04/2020 | 04/06/2020 | 04/08/2020 | 04/09/2020 | 04/10/2020 | 04/15/2020 | 04/16/2020 | 04/17/2020
[NAME] |  | 0 | 0 | 0 | 0 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Carlo |  | 0 | 0 | 24 | 0 | 29 | 40 | 0 | 0 | 0 | 0 | 34 | 0 | 38
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 39 | 0 | 24 | 0 | 110 | 150 | 0 | 102 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 39 | 99 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 48 | 57 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Taro |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sato |  | 0 | 0 | 0 | 0 | 19 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Piyal |  | 54 | 0 | 35 | 0 | 66 | 67 | 0 | 74 | 0 | 0 | 0 | 0 | 79
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 14 | 52 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Eg. Result to be as follows
 |  | Name | Last Date Sold
 |  | [NAME] | 02/04/2020
 |  | Carlo | 04/17/2020
 |  | [NAME] | 04/15/2020
 |  | [NAME] | Never
 |  | [NAME] | 04/08/2020
 |  | [NAME] | 27/03/2020
Spreadsheet: 880840d1728667710-select-correct-dates-bonus-schedule
Sheet: Bonus Schedule

Hire Date | Bonus Amount | [NAME]
2024-10-28 00:00:00 | 15000 | Two Years
Fulfillment Date (3 Months) | Fulfillment Date (6 Months) | Fulfillment Date (9 Months) | Fulfillment Date (12 Months) | Fulfillment Date (15 Months) | Fulfillment Date (18 Months) | Fulfillment Date (21 Months) | Fulfillment Date (24 Months)
Next Pay Date (3 Months) | Next Pay Date (6 Months) | Next Pay Date (9 Months) | Next Pay Date (12 Months) | Next Pay Date (15 Months) | Next Pay Date (18 Months) | Next Pay Date (21 Months) | Next Pay Date (24 Months)
Payment Amount (3 Months) | Payment Amount (6 Months) | Payment Amount (9 Months) | Payment Amount (12 Months) | Payment Amount (15 Months) | Payment Amount (18 Months) | Payment Amount (21 Months) | Payment Amount (24 Months)
Spreadsheet: 296111d1391973931-customize-date-excel-2013-auotfilter-not-thursday
Sheet: Sheet1

2014-01-07 00:00:00 | Helper
2014-01-08 00:00:00
2014-01-09 00:00:00
2014-01-10 00:00:00
2014-01-13 00:00:00
2014-01-14 00:00:00
2014-01-15 00:00:00
2014-01-16 00:00:00
2014-01-17 00:00:00
2014-01-20 00:00:00
2014-01-21 00:00:00
2014-01-22 00:00:00
2014-01-23 00:00:00
2014-01-24 00:00:00
2014-01-27 00:00:00
2014-01-28 00:00:00
2014-01-29 00:00:00
2014-01-30 00:00:00
2014-01-31 00:00:00
2014-02-03 00:00:00
2014-02-04 00:00:00
2014-02-05 00:00:00
2014-02-06 00:00:00
2014-02-07 00:00:00
2014-02-10 00:00:00
Spreadsheet: 848097d1698890383-formula-to-rearrange-data-as-pasted-from-external-source-digitalpeon-workbook-example
Sheet: Sheet1

Question Number | Question | Answer | Score
1
Spreadsheet: 700993d1603449147-count-office-and-non-office-hour-between-dates-excel-example_v6
Sheet: Sheet1

To calculate the no. of Office Hours (and Non-Office Hours) excluding the defined office hours (Mon-Fri, 09:00-18:00, Sat 09:00-13:00), Sunday and Public Holidays
 |  |  |  |  | FORMULAS |  | CORRECT ANSWERS
 | Engineer Onsite Date | Engineer Onsite Time | Engineer Offsite Date | Engineer Offsite Time | No of Office Hours * | No of Non-Office Hours * | No of Office Hours * | No of Non-Office Hours * |  | Office Hour Definition | In | out
Example 1 - Sep 5 is Weekend (SAT) | 2020-09-05 00:00:00 | 09:00:00 | 2020-09-05 00:00:00 | 10:00:00 |  |  | 1 | 0 |  | Monday to Friday, 09:00 - 18:00 | 09:00:00 | 18:00:00
Example 2 - Oct 1 is Public Holiday | 2020-10-01 00:00:00 | 16:00:00 | 2020-10-01 00:00:00 | 17:30:00 |  |  | 0 | 1.5 |  | Saturday | 09:00:00 | 13:00:00
Example 3 - Across Weekdays & Weekend | 2020-09-25 00:00:00 | 17:00:00 | 2020-09-28 00:00:00 | 02:30:00 |  |  | 5 | 52.5
Example 4 - Across Weekdays, Public Holidays, Weekend | 2020-09-30 00:00:00 | 16:30:00 | 2020-10-05 00:00:00 | 13:00:00 |  |  | 9.5 | 107 |  | Non Office Hour Definition
 |  |  |  |  |  |  |  |  |  | Monday to Saturday, other than above working hours
 |  |  |  |  |  |  |  |  |  | Anytime in Sunday
 |  |  |  |  |  |  |  |  |  | Public Holiday as below:
 |  |  |  |  |  |  |  |  |  | Jan 1, 2020 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 25, 2020 | 2020-01-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 26, 2020 | 2020-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 27, 2020 | 2020-01-27 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 28, 2020 | 2020-01-28 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 4, 2020 | 2020-04-04 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 10, 2020 | 2020-04-10 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 11, 2020 | 2020-04-11 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 13, 2020 | 2020-04-13 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 30, 2020 | 2020-04-30 00:00:00
 |  |  |  |  |  |  |  |  |  | May 1, 2020 | 2020-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Jun 25, 2020 | 2020-06-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Jul 1, 2020 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Oct 1, 2020 | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Oct 2, 2020 | 2020-10-02 00:00:00
 |  |  |  |  |  |  |  |  |  | Oct 26, 2020 | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  | Dec 25, 2020 | 2020-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Dec 26, 2020 | 2020-12-26 00:00:00
Spreadsheet: 32095d1228220637-problem-with-a-top-10-list-topten
Sheet: Sheet1

a | 2 |  |  |  |  | Top Ten | 1st | j | 117
b | 3 |  |  |  |  |  | 2nd | l | 93
c | 22 |  |  |  |  |  | 3rd | c | 22
d | 1 |  |  |  |  |  | 4th | s | 21
e | 9 |  |  |  |  |  | 5th | k | 17
f | 10 |  |  |  |  |  | 6th | f | 10
g | 3 |  |  |  |  |  | 7th | e | 9
h | 8 |  |  |  |  |  | 8th | e | 9
j | 117 |  |  |  |  |  | 9th | h | 8
y | 0 |  |  |  |  |  | 10th | b | 3
k | 17
r | 9
s | 21
l | 93
Spreadsheet: theresa_staab__39614__Howell Nomination-LCG
Sheet: Sheet1

TO: |  |  |  | Gathering Nomination Form |  |  |  |  |  | FROM:
Enron North America |  |  |  |  |  |  |  |  |  | Howell Petroleum Corporation
Contract # :
 | [NAME] |  |  |  |  |  |  |  |  | Attention: | [NAME]
Ph: | [PHONE] |  |  |  |  |  |  |  |  | Ph: | (303) 794-7382
Fax: | [PHONE] |  |  |  |  |  |  |  |  | Fax: | (303) 794-7383
E-Mail: | [EMAIL] |  |  |  |  |  |  |  |  | E-Mail: | [EMAIL]
Flow Date: | 2001-09-01 00:00:00 |  | Cycle: | First of Month
Through: | 2001-09-30 00:00:00
Receipts:
 | Rec. Point |  | BTU factor | Volume Mcf | Volume BTU
804003 | Sand Draw |  | 1.0974 | 1900
 |  |  |  | 0
 |  |  |  | 0
 | TOTAL RECEIPTS
 | 1% fuel deduct
 | Available for Delivery
Spreadsheet: 833469d1686993860-retrieve-all-info-from-source-data-for-all-matches-from-list-find-all-matches
Sheet: Results

Asset | User | Make | Model | S/N
C000001 | [NAME] | HP | x360 | SN001
C000007 | [NAME] | HP | x360 | [NAME]
C000008 | [NAME] | HP | FireFly | SN008
C000014 | [NAME] | Dell | 7400 | SN014
C000015 | [NAME] | Dell | 7200 | SN015
C000016 | [NAME] | Dell | 7400 | SN016
C000019 | [NAME] | HP | x360 | SN019
C000020 | [NAME] | Apple | MacBook Air | SN020
Spreadsheet: 707061d1607017384-networkdays-minus-weekends-and-holidays-tweak-needed-networkdays-example
Sheet: Days

Date of Incident | Date Submitted | Interval
01/01/2020 | 01/02/2020
01/02/2020 | 01/07/2020
01/02/2020 | 01/02/2020
01/02/2020 | 01/10/2020
01/05/2020 | 01/15/2020
01/06/2020 | 02/14/2020
01/14/2020 | 02/06/2020
Spreadsheet: 98173d1297195515-average-using-results-of-sumproduct-outbound
Sheet: SUMMARY

REPORT DATE RANGE | 2011-02-14 00:00:00 | 2011-02-28 00:00:00
COMPANY
DATE RANGE |  | 0.9500000000000001 | 0.5900000000000001 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.12 | 0.13 | 0.14
YEAR TO DATE |  | 0.3166666666666667 | 0.1966666666666667 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.12 | 0.13 | 0.14
Spreadsheet: 727504d1617913467-listing-a-persons-contributions-without-revealing-the-rest-of-the-data-your-contributions-only
Sheet: Sheet1

Contribution Type | Betty | Sue | [NAME] | [NAME]
[NAME] of Chips | 2 |  | 1
Packs of Hot Dogs | 1 | 1 |  |  |  |  |  |  | Betty |  |  | Sue
Buns |  | 2 |  |  |  |  |  |  | [NAME] of Chips | 2 |  | Pack of Hot Dogs | 1
[NAME] |  |  |  | 1 |  |  |  |  | Pack of Hot Dogs | 1 |  | Buns | 2
Mustard |  |  |  | 1
Chairs |  |  | 20
 |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Bag of Chips | 1 |  | [NAME] | 1
 |  |  |  |  |  |  |  |  | Chairs | 20 |  | Mustard | 1
Spreadsheet: john_griffith__16215__1_31_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | EXP |  |  | 43 | 60 | 1.72 | 2002-01-25 15:07:00
 | [NAME] | 52 | 520 | 580 | 48 | 53.6 | 1.66 | 2002-01-31 12:42:00
 | HO J2 | 52 | 730 | 830 | 46.5 | 52.9 | 1.62 | 2002-01-31 12:42:00
 | HO K2 | 53 | 875 | 975 | 43.6 | 48.6 | 1.54 | 2002-01-31 12:42:00
 | HO M2 | 53 | 1000 | 1100 | 42.4 | 46.7 | 1.48 | 2002-01-31 12:42:00
 | HO N2 | 54 | 1100 | 1200 | 41.3 | 45 | 1.46 | 2002-01-31 12:42:00
 | HO Q2 | 55 | 1160 | 1260 | 38.9 | 42.3 | 1.4 | 2002-01-31 12:42:00
 | HO U2 | 56 | 1225 | 1325 | 37.3 | 40.4 | 1.37 | 2002-01-31 12:42:00
 | [NAME] | 56 | 1275 | 1375 | 36.5 | 39.4 | 1.34 | 2002-01-31 12:42:00
 | HO X2 | 57 | 1325 | 1450 | 35 | 38.4 | 1.32 | 2002-01-31 12:42:00
 | [NAME] | 58 | 1350 | 1500 | 33.6 | 37.3 | 1.29 | 2002-01-31 12:42:00
 | HO F3 | 59 | 1350 | 1500 | 31.6 | 35.2 | 1.24 | 2002-01-31 12:42:00
 | [NAME] | 58 | 1400 | 1600 | 31.9 | 36.5 | 1.25 | 2002-01-31 12:42:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 823737d1680117551-if-statements-multiple-parameters-tipsheet-wip-2-
Sheet: EMPLOYEE

 |  |  |  |  |  | Tip-out Percents and Ratios:
 |  |  |  |  |  | Server | Bartenders | 0.05 | Alcohol sales
 |  |  |  |  |  | Backserver | Backservers - ≥2 | 0.03 | All sales
 |  |  |  |  |  |  | Full Shift | 1 | [NAME]
 |  |  |  |  |  |  | Mid Shift | 0.5 | [NAME]
 |  |  |  |  |  |  | Food Run | 0.25 | [NAME]
 |  |  |  |  |  |  | Backserver - 1 | 0.02 | All sales
 |  |  |  |  |  |  | Backserver - Mid | 0.01 | All sales
 |  |  |  |  |  | Bartender | Backserver | 0.035 | Food Sales
 |  |  |  |  |  |  | Barback | 0.5 | [NAME]
Spreadsheet: 846515d1697692539-vertical-multiple-dependent-drop-down-list-2nd-layer-inquiry-event-itinerary-master_sample
Sheet: Vendor List

 |  |  |  |  |  |  | Production 制作 |  |  |  |  |  |  | Operation オペレーション
 |  |  | Production 制作 | Operation オペレーション |  |  | Construction 施工 | Sound 音響 | Lighting 照明 | Audio Visual (AV) 映像 | Moving Company 引越し/運搬 |  |  | Staffing 運営 | Catering ケータリング | Model モデル | PR Agency PR エジェンシー | DJ | Performance パフォーマンス | Photograpgher カメラマン | Videographer ビデオグラファ | Calligrapy カリグラフィー | Table Decorations テーブル装飾 | Floral & Plants 花と植栽 | Rental Furniture レンタル家具 | Purchased Furniture 購入家具
 |  |  | Construction 施工 | Staffing 運営 |  |  | Con. Vendor A | Sound Vendor A | Light 01 | AV 01 | moving 01 |  |  | Staffing Vendor A | Catering Vendor A | Model Vendor 1 | PR Vendor 1 | DJ A | perf 01 | phto 01 | video 01 | calli 01 | table 01 | floral 01 | rental 01 | furn 01
 |  |  | Sound 音響 | Catering ケータリング |  |  | Con. Vendor B | Sound Vendor B |  |  |  |  |  |  |  |  |  | DJ B
 |  |  | Lighting 照明 | Model モデル |  |  |  | Sound Vendor C |  |  |  |  |  |  |  |  |  | DJ C
 |  |  | Audio Visual (AV) 映像 | PR Agency PR エジェンシー
 |  |  | Moving Company 引越し/運搬 | DJ
 |  |  |  | Performance パフォーマンス
 |  |  |  | Photograpgher カメラマン
 |  |  |  | Videographer ビデオグラファ
 |  |  |  | Calligrapy カリグラフィー
 |  |  |  | Table Decorations テーブル装飾
 |  |  |  | Floral & Plants 花と植栽
 |  |  |  | Rental Furniture レンタル家具
 |  |  |  | Purchased Furniture 購入家具
Spreadsheet: 685491d1594038997-extract-every-words-after-certain-character-in-any-position-within-a-cell-then-split-ask-ask
Sheet: Sheet1

 | Please read until line 37
 | LIST OF DATA
 | Kids>Boy (4 years and above)|Type>Christmas|Type>Festive|Brand>Mayoral|Type>Outerwear
 | Type>Chinese New Year|Chinese New Year|Baby>Girl (0-36 Months)|Type>Sets|Brand>Sissae
 | Baby>Girl (0-36 Months)|Type>Shoes|Brand>Tiny Soles
 | [NAME]
 | 1. How to extract EVERY TYPE, within each cell?
 | Result needed:
 | Christmas, Festive, Outerwear
 | Chinese New Year, Sets
 | Shoes
 | 2. And then let's assume there's list of item type
 | Top
 | Bottom
 | Outerwear
 | Sets
 | Shoes
 | and so on
 | How to automatically put those type,
 | which exist in list of item, in the first column?
 | which doesn't exist in list of item, in the second column?
 | Final Result needed:
 | 1st column | 2nd column
 | Outerwear | Christmas, Festive
 | Sets | Chinese New Year
 | Shoes | -
 | if there's solution to solve all questions above in a single move, it would be very helpful
 | thank you
Spreadsheet: 179906d1347408820-different-tables-using-data-validation-ticket-tracker
Sheet: Ticket Sheet

TICKET NUMBERS |  |  |  | DATE |  |  |  | 2012-09-01 00:00:00
AP | T&E | FOLLOW-UPS |  | 2012-09-01 00:00:00 |  |  |  | 2012-09-02 00:00:00
 |  |  |  |  |  |  |  | 2012-09-03 00:00:00
1 | 1 | 1 |  |  |  |  |  | 2012-09-04 00:00:00
2 | 2 | 2 |  |  |  |  |  | 2012-09-05 00:00:00
3 | 3 | 3 |  |  |  |  |  | 2012-09-06 00:00:00
4 | 4 | 4 |  |  |  |  |  | 2012-09-07 00:00:00
5 | 5 | 5 |  |  |  |  |  | 2012-09-08 00:00:00
6 | 6 | 6 |  |  |  |  |  | 2012-09-09 00:00:00
 | 9 | 7 |  |  |  |  |  | 2012-09-10 00:00:00
 | 10 | 8 |  |  |  |  |  | 2012-09-11 00:00:00
 | 11 |  |  |  |  |  |  | 2012-09-12 00:00:00
 | 12 |  |  |  |  |  |  | 2012-09-13 00:00:00
 |  |  |  |  |  |  |  | 2012-09-14 00:00:00
 |  |  |  |  |  |  |  | 2012-09-15 00:00:00
 |  |  |  |  |  |  |  | 2012-09-16 00:00:00
 |  |  |  |  |  |  |  | 2012-09-17 00:00:00
 |  |  |  |  |  |  |  | 2012-09-18 00:00:00
 |  |  |  |  |  |  |  | 2012-09-19 00:00:00
 |  |  |  |  |  |  |  | 2012-09-20 00:00:00
 |  |  |  |  |  |  |  | 2012-09-21 00:00:00
 |  |  |  |  |  |  |  | 2012-09-22 00:00:00
 |  |  |  |  |  |  |  | 2012-09-23 00:00:00
 |  |  |  |  |  |  |  | 2012-09-24 00:00:00
 |  |  |  |  |  |  |  | 2012-09-25 00:00:00
 |  |  |  |  |  |  |  | 2012-09-26 00:00:00
 |  |  |  |  |  |  |  | 2012-09-27 00:00:00
 |  |  |  |  |  |  |  | 2012-09-28 00:00:00
 |  |  |  |  |  |  |  | 2012-09-29 00:00:00
 |  |  |  |  |  |  |  | 2012-09-30 00:00:00
Spreadsheet: 685546d1594063976-sum-amounts-column-d-by-department-column-a-sample-3-
Sheet: Data

Department | Distributor | Invoice | Amount | Month
PART | HUL | 5812 | 142.74 | Jan
PART | HUL | 5822 | 48.37 | Jan
PART | HUL | 6094 | 27.35 | Jan
PART | HUL | 6100 | 99.3 | Jan
PART | HUL | 6109 | 146.02 | Jan
PART | HUL | 6118 | 15.6 | Jan
PART | HUL | 6124 | 48.9 | Jan
PART | HUL | 6016 | 551.69 | Jan
PART | HUL | 6131 | 67.15 | Jan
PART | HUL | 6149 | 121.7 | Jan
PART | HUL | 6151 | 66.46 | Jan
PART | HUL | 6156 | 102.82 | Jan
PART | HUL | 6157 | 72.7 | Jan
PART | WEB | 65940751 | 2283.24 | Jan
PART | WEB | 65952121 | -807.88 | Jan
PART | WEB | 65998737 | 805.64 | Jan
PART | WEB | DISCOUNT | -41.58 | Jan
PART | GRAG | 122683040 | 680.75 | Jan
PART | GRAG | DISCOUNT | -12.84 | Jan
PART | PAR | 1003790 | 12.73 | Jan
PART | BRL | 171703 | 19.09 | Jan
PART | RKM | 968032 | 3.19 | Jan
RENT | TAYR | 23240003 | 24.86 | Jan
TRASH | DEN |  | 45 | Jan
TOOL | BRL | 171033 | 29.94 | Jan
INS | NGM | CK# 2731 | 561.8 | Jan
VEH | GFN |  | 524.3 | Jan
LAB | SMD | WE142020 | 760 | Jan
PART | HUL | 5812 | 142.74 | Feb
PART | HUL | 5822 | 48.37 | Feb
PART | HUL | 6094 | 27.35 | Feb
PART | HUL | 6100 | 99.3 | Feb
PART | HUL | 6109 | 146.02 | Feb
PART | HUL | 6118 | 15.6 | Feb
PART | HUL | 6124 | 48.9 | Feb
PART | HUL | 6016 | 551.69 | Feb
PART | HUL | 6131 | 67.15 | Feb
PART | HUL | 6149 | 121.7 | Feb
PART | HUL | 6151 | 66.46 | Feb
PART | HUL | 6156 | 102.82 | Feb
PART | HUL | 6157 | 72.7 | Feb
PART | WEB | 65940751 | 2283.24 | Feb
PART | WEB | 65952121 | -807.88 | Feb
PART | WEB | 65998737 | 805.64 | Feb
PART | WEB | DISCOUNT | -41.58 | Feb
PART | GRAG | 122683040 | 680.75 | Feb
PART | GRAG | DISCOUNT | -12.84 | Feb
PART | PAR | 1003790 | 12.73 | Feb
PART | BRL | 171703 | 19.09 | Feb
PART | RKM | 968032 | 3.19 | Feb
RENT | TAYR | 23240003 | 24.86 | Feb
TRASH | DEN |  | 45 | Feb
TOOL | BRL | 171033 | 29.94 | Feb
INS | NGM | CK# 2731 | 561.8 | Feb
VEH | GFN |  | 524.3 | Feb
LAB | SMD | WE142020 | 760 | Feb
Spreadsheet: 1495f262-749b-4bf3-83aa-9ed9c0005a84
Sheet: E

Car Make/Model/Year | Volume Number
[NAME]
1921 | 224 no. 1
1922---parts list | 78 no. 1
1922 | 79 no. 2
1923 | 226 no. 11
[NAME]
191? | 79 no. 8
1917 | 79 no. 1
1917---parts list | 79 no. 10
1920---parts list | 78 no. 2
1920---repair manual | 78 no. 4
1920---parts list | 79 no. 7
1921 | 84 (+) no. 3
1922---parts list | 78 no. 10
1922---parts list | 79 no. 4
1922 | 84 (+) no. 4
1929 | 223 (+) no. 10
Elgin
191? | 84 (+) no. 2
1918---repair manual | 78 no. 7
1920---parts list | 78 no. 5
1920---repair manual | 79 no. 6
1920 | 225 no. 3
1931 | 223 (+) no. 8
Elwell-Parker
1913 | 132 (+) no. 1
Elmore
1905 | 78 no. 8
1905 | 78 no. 9
Emile (French) Pilain
1930 | 249 no. 12
1930 | 219 no. 2
1912 | 55 no. 7
Empire
1918---repair manual | 78 no. 3
1918---repair manual | 79 no. 5
Erskine. (Studebaker)
1927 | 251 no. 11
1928 | 191 no. 17
Excelsior (Belgian)
1912 | 45 (+) no. 10
Essex
191? | 187 no. 11,15
1912 | 45 (+) no. 10
1919 | 216 no. 10
1919 | 288 (+) no. 9
1919 | 317 no. 2
1919 | 318 no. 9
192? | 187 no. 7
1920---repair manual | 79 no. 3
1921 | 267 (+) no. 21
1922 | 79 no. 6
1922 | 180 no. 20
1923,1924,1925,1926,1926,1927 | 202 no. 12,13,14,15,16,17
1923---repair manual | 219 no. 7
1923---repair manual | 226 no. 5
1924---repair manual | 223 no. 2
1925 | 191 no. 5,6,7,8
1928 | 191 no. 15
1930 | 233 (+) no. 11
1931 | 187 no. 9
Spreadsheet: 702702d1604493139-google-sheets-how-to-embed-a-condition-with-if-clause-in-given-formula-live-tracking-unique
Sheet: CUTTING & PACKING

DATE | DEPARTMENT | P.O. NO. | QUALITY | COLOR | SIZE | PCS | PILLOW | CUSHION | WORKER | ORDER | SHIPPED | BOX
Spreadsheet: 214906d1361184980-using-text-forumlas-accounts-test-sheet
Sheet: Annual Summary

 |  |  |  |  |  |  |  |  |  |  |  | Year starting (job no)
 |  |  |  |  |  |  |  |  |  |  |  | 1st busyist month
 |  |  |  |  |  |  |  |  |  |  |  | 2nd busyiest month
 |  |  |  |  |  |  |  |  |  |  |  | 3rd busyiest month
ANNUAL ACCOUNTS SUMMARY SHEET 2013/2014 |  |  |  |  |  |  |  |  |  |  |  | 4th busyiest month
 |  |  |  |  |  |  | INTERNAL USE/RECORDS
MONTHLY NET PROFIT/LOSS |  |  |  | VAT TOTALS |  |  |  |  |  |  |  | 1st Quietest month
April |  |  |  | VAT PAID OUT |  |  | CREDIT ACCOUNT ANNUAL SPEND |  |  |  |  | 2nd Quietest month
May |  |  |  | VAT RECEIVED IN |  |  | TPS |  |  |  |  | 3rd Quietest month
June |  |  |  |  |  |  | OTHER 1
July |  |  |  |  |  |  | OTHER 2 |  |  |  |  | Total annual jobs
August |  |  |  |  |  |  | OTHER 3 |  |  |  |  | Annual turnover £
September |  |  |  |  |  |  |  |  |  |  |  | Annual profit £
October |  |  |  |  |  |  |  |  |  |  |  | Average monthly profit £
November |  |  |  |  |  |  |  |  |  |  |  | Annual profit growth £
December |  |  |  |  |  |  | TOTAL NUMBER OF JOBS |  |  |  |  | Fixed assets/equiptment £
January |  |  |  |  |  |  | AVERAGE MONTHLY PROFIT
February |  |  |  |  |  |  | ANNUAL TURNOVER |  |  |  |  | Total customer count
March |  |  |  |  |  |  |  |  |  |  |  | New customers originated from?
ANNUAL NET PROFIT/LOSS = |  |  |  |  |  |  |  |  |  |  |  | TPS Annual spend
 |  |  |  |  |  |  |  |  |  |  |  | TPS Average monthly spend
Spreadsheet: 53364d1253242335-selective-sums-mirmle
Sheet: Sheet1

item | price |  |  | [NAME] | Cash | Credit
pizza | 5 | [NAME] |  | 5 | 6 | 10
eggs | 1 | Cash
butter | 4 | Credit
bread | 3 | Cash
paper | 6 | Credit
erasers | 2 | Cash
Spreadsheet: 708027d1607591411-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: RUSSIA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label