tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 039059c6-9e5b-4553-bc41-a5acd3538d55
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total value of building jobs ;  Australian Capital Territory ;  [NAME] ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2013-11-01 00:00:00 | 521 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Australian Capital Territory ;  [NAME] ;  Alterations and additions including conversions ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2013-11-01 00:00:00 | 485 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Australian Capital Territory ;  [NAME] ;  Total Work ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2013-11-01 00:00:00 | 485 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Australian Capital Territory ;  [NAME]-residential ;  Total Work ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2013-11-01 00:00:00 | 521 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Australian Capital Territory ;  Total (Type of Building) ;  Total Work ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2013-11-01 00:00:00 | 485 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 44809d1243542321-need-help-filtering-a-list-in-a-new-worksheet-from-a-master-list-personnel-tracker-mock
Sheet: Tracy

Current Manager: | [NAME] | Employees: | 39
 | Name | Contractor/ Employee ID | Logon ID | Purchasing Test Score | Suspense Test Score
 | Sandra L | C11133 | asdfhjkl23 | N/A | N/A
 | [NAME] | C11134 | asdfhjkl24 | N/A | N/A
 | [NAME] | C11135 | [NAME] | N/A | N/A
 | [NAME] | C11136 | asdfhjkl26 | N/A | N/A
 | [NAME] | C11137 | [NAME] | N/A | N/A
 | [NAME] | C11139 | asdfhjkl29 | N/A | N/A
 | [NAME] | C11140 | asdfhjkl30 | N/A | N/A
 | [NAME] R | C11141 | asdfhjkl31 | N/A | N/A
 | [NAME] | C11142 | asdfhjkl32 | N/A | N/A
 | Gengkok O | C11144 | asdfhjkl34 | N/A | N/A
 | Maybel H | C11145 | [NAME] | N/A | N/A
 | [NAME] | C11146 | asdfhjkl36 | N/A | N/A
 | Jennifer A | C11148 | asdfhjkl38 | N/A | N/A
 | Monique R | C11149 | asdfhjkl39 | 0.9507 | 0.9459
 | [NAME] | C11150 | asdfhjkl40 | 1 | 1
 | [NAME] | C11152 | asdfhjkl42 | 0.9733 | 0.9235
 | [NAME] | C11153 | asdfhjkl43 | 0.9467 | 0.8716
 | [NAME] | C11154 | [NAME] | 0.9648 | 0.9459
 | [NAME] | C11156 | asdfhjkl46 | 0.92 | 0.8941
 | Twinky T | C11157 | asdfhjkl47 | 0.9333 | 0.8941
 | Heather H | C11159 | asdfhjkl49 | 0.9333 | 0.831
 | Oganes K | C11160 | asdfhjkl50 | 0.96 | 0.9595
 | [NAME] | C11161 | asdfhjkl51 | 0.9867 | 0.973
 | [NAME] | [NAME] | asdfhjkl53 | 0.9933 | 0.8986
 | [NAME] | C11164 | asdfhjkl54 | 0.9333 | 0.9189
 | [NAME] | C11165 | asdfhjkl55 | N/A | 0.9875
 | [NAME] | C11167 | [NAME] | 0.96 | 1
 | Rebecca T | C11168 | asdfhjkl58 | 0.9733 | 1
 | Antonioni P | C11169 | asdfhjkl59 | 0.8533 | 0.975
 | Maureen M | C11171 | asdfhjkl61 | 0.9 | 1
 | [NAME] | C11172 | asdfhjkl62 | 0.86 | 0.9625
 | Rogers A | C11173 | asdfhjkl63 | 0.8333 | 0.9625
 | [NAME] | C11174 | asdfhjkl64 | 0.8067 | 1
 | Hank W | C11176 | asdfhjkl66 | 0.9368 | 1
 | [NAME] | C11177 | asdfhjkl67 | 0.9741 | 1
 | Remigio M | C11179 | asdfhjkl69 | 0.9195 | 0.9
 | Rina D | C11180 | asdfhjkl70 | 0.9885 | 0.9625
 | [NAME] | C11181 | asdfhjkl71 | 0.9195 | 0.975
 | [NAME] | C11182 | [NAME] | N/A | 0.8625
Spreadsheet: 217197d1362000563-now-formula-not-recognised-now-formula-test
Sheet: Sheet1

Dates |  | Quarter | Today Date
2011-06-01 00:00:00 | 2011-08-31 00:00:00 | Q1FY12
2011-09-01 00:00:00 | 2011-11-30 00:00:00 | Q2FY12
2011-12-01 00:00:00 | 2012-02-29 00:00:00 | Q3FY12
2012-03-01 00:00:00 | 2012-05-31 00:00:00 | Q4FY12
2012-06-01 00:00:00 | 2012-08-31 00:00:00 | Q1FY13
2012-09-01 00:00:00 | 2012-11-30 00:00:00 | Q2FY13
2012-12-01 00:00:00 | 2013-02-28 00:00:00 | Q3FY13
2013-03-01 00:00:00 | 2013-05-31 00:00:00 | Q4FY13
2013-06-01 00:00:00 | 2013-08-31 00:00:00 | Q1FY14
2013-09-01 00:00:00 | 2013-11-30 00:00:00 | Q2FY14
2013-12-01 00:00:00 | 2014-02-28 00:00:00 | Q3FY14
2014-03-01 00:00:00 | 2014-05-31 00:00:00 | Q4FY14
2014-06-01 00:00:00 | 2014-08-31 00:00:00 | Q1FY15
2014-09-01 00:00:00 | 2014-11-30 00:00:00 | [NAME]
2014-12-01 00:00:00 | 2015-02-28 00:00:00 | Q3FY15
2015-03-01 00:00:00 | 2015-05-31 00:00:00 | Q4FY15
Spreadsheet: 264804d1378987917-search-help-with-textbox-asda-obs
Sheet: Sheet1

First Name | Surname | Date | Observer | Result (%) | Department | Action
jan | winters | 2013-09-23 00:00:00 | [NAME] | 100 | Frontend | CELEBRATE
jan | warwick | 2013-09-11 00:00:00 | [NAME] | 100 | Frontend | CELEBRATE
jan | warwick | 2013-08-11 00:00:00 | [NAME] | 50 | H & L | FEEDBACK, INVESTIGATION AND DISCIPLINARY
jan | warwick | 2013-09-08 00:00:00 | [NAME] | 89 | Counters | FEEDBACK, FILE NOTE AND RETRAIN
jan | warwick | 2013-09-08 00:00:00 | [NAME] | 89 | Counters | FEEDBACK, FILE NOTE AND RETRAIN
jan | winters | 2013-09-23 00:00:00 | [NAME] | 100 | Frontend | CELEBRATE
jan | warwick | 2013-09-11 00:00:00 | [NAME] | 100 | Frontend | CELEBRATE
jan | warwick | 2013-08-11 00:00:00 | [NAME] | 50 | H & L | FEEDBACK, INVESTIGATION AND DISCIPLINARY
jan | warwick | 2013-09-08 00:00:00 | [NAME] | 89 | Counters | FEEDBACK, FILE NOTE AND RETRAIN
jan | warwick | 2013-09-08 00:00:00 | [NAME] | 89 | Counters | FEEDBACK, FILE NOTE AND RETRAIN
[NAME] | gallimore | 2013-09-05 00:00:00 | [NAME] | 100 | Frontend | CELEBRATE
ste | [NAME] | 2013-09-02 00:00:00 | [NAME] | 100 | Frontend | CELEBRATE
Spreadsheet: 758408d1638856593-formula-with-array-doesnt-work-formula-with-array-problem
Sheet: Sheet1

Date | Week | w | w2
2020-01-22 00:00:00
2020-03-09 00:00:00
2020-07-26 00:00:00
2020-05-29 00:00:00
2020-02-18 00:00:00
2020-03-10 00:00:00
2020-06-20 00:00:00
2020-08-21 00:00:00
2020-08-17 00:00:00
2020-08-21 00:00:00
2020-08-21 00:00:00
2020-05-27 00:00:00
2020-03-28 00:00:00
2020-05-05 00:00:00
2019-06-22 00:00:00
2019-05-12 00:00:00
Spreadsheet: 807469d1669911800-adding-forecasted-completion-time-calculating-working-hours-workdays-ramilh-
Sheet: Sayfa1

Project Start date | Break | Worked | Left | Projected Completion date |  | Working Hours Needed |  | Breaks
2022-12-02 08:00:00 |  |  |  |  |  | 50 |  | 03:30:00 | 11:30:00 | 19:00:00
 |  |  |  |  |  |  |  | 04:30:00 | 12:30:00 | 20:00:00
 |  |  |  |  |  |  |  | *Workdays are every day except Sunday
Spreadsheet: 127916d1320684205-solved-conditional-formatting-to-highlight-cells-lighting-take-off
Sheet: Sheet2

AtLite
CooperLED
Corelite
Fail-Safe
Halo
International
[NAME]
Lumark
Lumiere
McGraw-Edison
Metalux
MWS
[NAME]
Portfolio
Regent
Shaper
[NAME]
Sure-Lites
ACE
Apogee
Architectural [NAME]
Art of Neon
Bodine
[NAME]
Brightline
Dilor Lighting
[NAME] Controls
Edison Price
Elco Ltg.
E-Lite Technologies
ETC
Fleurs D'Allumage
Hilite
Illumination
Interlight
Irideon
ISIS
Ledalite
Lighting Dimensions
Linear Lighting
Lumec
Luxnet
Neri
North Star Ltg.
Novus
Orbit
[NAME].
PDM
Rambusch
[NAME]
Supervision Intl.
Thomas Lighting Canada
Times Square Lighting
Wendall Lighting
Windirect
Winona Lighting
Winscape
Insight Lighting
[NAME]
Lightron
Litecontrol
LSI Industries
Lumacell
[NAME]
Midwest Fluorescent
National Cathode
Paramount
Phoenix Lighting
Prudential Lighting
RSA Lighting
Se'lux
[NAME]
Strand Lighting
Visioneering
Visa Lighting
[NAME]
Webco
We-ef
Wila
[NAME]
Spreadsheet: 685994d1594306059-look-up-postcode-and-allocate-region-example-1-
Sheet: Calculator

 | Agent [NAME] | ip18
 | Region | [NAME]
 |  |  |  |  |  |  |  |  | Scott | 0 | Associate
 |  |  |  |  |  |  |  |  | Scott | 15 | AM
 | Number of branches |  |  |  |  |  |  |  | Scott | 31 | KAM
 | Amount of stock | 50 |  |  |  |  |  |  | [NAME] | 0 | Associate
 |  |  |  |  |  |  |  |  | [NAME] | 20 | AM
 |  |  |  |  |  |  |  |  | [NAME] | 40 | KAM
Spreadsheet: 00106cd7-b1a1-486f-afff-af9de1491bbe
Sheet: Table C - Economics Synbio

Process Details and Costs |  |  | PROPRIETARY/BUSINESS SENSITIVE
Feedstock Type |  | [NAME] or Current Process* | Intermediate Target (~6-8 months) | Final Target (18-24 months) | Anticipated cost improvements are due to:
[NAME] (dry ton/day)
Biofuel or [NAME] (gallons or lbs/dry ton)
Line 1:  [NAME] or Bioproduct Production (MM gallons or MM lbs)
Equipment Costs (2005$) as applicable | Description | Installed Capital Cost (MM$) |  | Installed Capital Cost (MM$)
Feedstock Handling
Pretreatment
Neutralization/Conditioning
Fermentation Organism Production (here or in operating costs)
Saccharification & Co-fermentation
Distillation & Solids Recovery
Wastewater Treatment
Storage
Utilities (include steam/electricity here or in operating costs)
Line 2:  Total Installed Capital
Total Installed Capital per Annual [NAME] or lb (line 2 divided by line 1)
Operating Costs (2005$) as applicable | Description | MM$/yr |  | MM$/yr
Feedstock
Organism Production Nutrients
Fermentation Nutrients
Enzymes (Cellulase)
Fermentation Organism (include licensing fees)
Other Raw Materials
Waste Disposal
Steam
Electricity
Labor and [NAME]
Line 3:  Total Operating Costs
Line 4:  Co-product Credits
Line 5:  Net Operating Costs (line 3 minus line 4)
Net Biofuel or Bioproduct Production Costs ($/gal) (line 5 divided by line 1)
* Provide best data based on current level of your technology development
Spreadsheet: 857734d1706663846-help-with-ifs-function-kansas-scheduler-v2-test-01302024-1-
Sheet: Digital

Press List | Print Time Calculations |  |  |  |  |  |  |  | Material |  | [NAME] |  |  | Links
 |  | [NAME] |  |  |  |  |  |  |  |  | 4 Pass | [NAME] |  | Large Job Gant Chart for KS.xlsx
 |  | HP/ 3R Formula |  |  |  |  |  |  |  |  | 5-Pass | 3R/HP |  | PACE JOBS FOR MS.xlsx
 |  | GS Formula |  |  |  |  |  |  |  |  | Heavy Smoothing | GS |  | Timeline Requests.xlsx
 |  | HS Formula |  |  |  |  |  |  |  |  | No Smoothing | HS |  | https://www.weprint.com/number-out-calculator.asp
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
[NAME]
3R |  | 2024-02-02 00:00:00 | 14574 | 2 | BBB | 250 | 20 | 20 |  | 1 | Backlit
[NAME] |  | 2024-02-06 00:00:00 | 444444 | 1 |  | 3000 | 25 | 48 |  | 1 | 4-Pass
[NAME] |  | 2024-01-31 00:00:00 | 123456 |  |  | 100 | 20 | 20 |  | 2 | 4-Pass
3R |  | 2024-02-05 00:00:00 | 789456
Canon |  | 2024-02-10 00:00:00 | 159357
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -13559 | -14000
2 | -13675 | -14000
3 | -13732 | -14000
4 | -13318 | -14000
5 | -14017 | -14000
6 | -13620 | -14000
7 | -13282 | -14000
8 | -13676 | -14000
9 | -13585 | -14000
10 | -13644 | -14000
11 | -13501 | -14000
12 | -15295 | -14000
13 | -14142 | -14000
14 | -14021 | -14000
15 | -14016 | -14000
16 | -12589 | -14000
17 | -13832 | -14000
18 | -25911 | -25928
19 | -14237 | -14000
20 | -13946 | -14000
21 | -14148 | -14000
22 | -14162 | -14000
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -15514.53
2002-01-22 00:00:00
CBS Volume
 |  |  | 5596
Spreadsheet: c8d5ec14-9988-4dfa-94f4-ec58722ecbe2
Sheet: Sheet1

European Senior Championships 2012 | Unnamed: 1 | Unnamed: 2
Age Group 35+
Selections are in alphabetical order, not ranking order
Men's Singles | Family Name | First Name
 | Murphy | Ian
Women's Singles | Family Name | First Name
 | Culyer | [NAME]
Men's Doubles | Family Name | First Name
 | Dibble | Haydn
 | Murphy | Ian
 | Hancox | Adrian
 | Hawksworth | Mathew
 | Priestley | Julian
 | Partner Wanted
Women's Doubles | Family Name | First Name
 | Bradbury | Julie
 | Chernyavskaya | [NAME]
 | [NAME] | Sue
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Culyer | Loiuse
[NAME] | Family Name | First Name
 | [NAME] | [NAME]
 | Knowles | [NAME]
 | Hancox | Adrian
 | Bryant | [NAME]
 | [NAME] | [NAME]
 | Dawes | Deena
 | Vickers | [NAME]
 | [NAME] | [NAME]
Spreadsheet: 464798d1465319033-overlay-worksheets-with-formatting-copy-of-the-programme-sample
Sheet: Resource

Approx No.s | SITE | JUNE 2016 |  |  |  |  |  | JUNE 2016
 |  | 6 | 7 | 8 | 9 | 10 |  | 13 | 14 | 15 | 16 | 17
 | BITS & PIECES |  |  | * |  | 521+0.5 |  |  | * |  |  | *
 |  |  | JIL | FREE |  |  |  | E CAD | E CAD | FREE
 |  | E CAD | E CAD |  | PM |  |  |  | JIL | JIL
 |  |  | [NAME]
 | Poole NMA
800-OUTLINE | Newquay - (800-OUTLINE)
250-OUTLINE | Matford Park (250-OUTLINE) |  |  |  |  |  |  | RESUB | RESUB
 |  |  |  |  |  |  |  | TR
238 | [NAME] (238)
460 | [NAME], [NAME] (460)
86 | Tews Lane, Barnstaple (86)
120 | [NAME] (120) - FGM & S
400 | Ash (400) |  |  |  |  |  |  |  |  |  | RESUB | RESUB
46 | [NAME] (46) |  |  |  |  |  |  | RESUB
70 | Portishead (70)
75 | [NAME] (75) |  |  |  | RESUB | RESUB |  |  |  |  |  | RESUB
86 | [NAME]86)
59 | [NAME] (59)
15 | Sonning Golf Club (OUTLINE-15)
[NAME] | [NAME] (110) | V | P | L
 |  |  | TW
[NAME] | Horton (10) |  |  |  |  |  |  | V | L+P
JULY | [NAME] (24) |  |  |  | BSPOKE | BSPOKE |  |  |  | BSP-0.5 | BSP-0.5
 |  |  | DAS | DAS
JULY | Basingstoke (129)
[NAME] | Crediton
AUGUST | Faringdon (200)
SEPT | North Tawton (100)
SEPT/OCT | Truro (190)
350-OUTLINE | Winchester (350-OUTLINE)
60 | Heyford Phase 5 (60)
350 | [NAME] (350) | L | CHECK | P |  | P |  |  |  | RESUB | RESUB
42 | Heyford Phase 6 (42) |  |  |  |  | ph4 htypes
14 | [NAME] (14)
264 | Barnstaple (264) |  | M | RESUB
91 | Heyford Trident (91) |  |  |  | RESUB
 |  |  |  |  | RESUB
252 | [NAME] (252) | P | P |  |  |  |  |  | RESUB |  |  | RESUB-0.5
 |  |  | CHECK
181 | [NAME] (181)
MAY | Woodville Chinner (80) |  |  | S/S+DAS | COL | SUB
MAY | Totnes (8) |  |  |  |  | S/S+P
 |  |  |  |  | DAS
JULY /AUG | Heyford Phase 9 (300) |  | M
AUGUST | Manadon (85) |  |  |  |  |  |  |  |  | L | L | L
 |  |  |  |  |  |  |  |  |  | TR | TR
SEPTEMBER | Cheddar (85)
SEPT/OCT | Parklands (230)
 | [NAME] (150)
DAZ | SERGEY | DAVEY
 | PABS |  |  |  |  |  |  |  |  |  | DAVEY
[NAME] | DAN |  |  |  |  |  |  |  |  |  | JONNY L
JON | DAVEY |  |  |  |  |  |  |  | [NAME] |  |  | DAGMARA (PM)
WATTO | JONNY THE BEAR |  |  |  |  |  |  |  |  | SERGEY (PM) | SERGEY (PM)
ZSOLT | [NAME]
J.R | DAGMARA
ADRIAN G | ADRIAN
Spreadsheet: 598839d1542732744-common-text-numbers-in-multiple-columns-gk-ef
Sheet: Sheet1

Value 1 | Value 2 | Value 3 | Value 4 | MIXED Text & Numbers
Q | I | G | C
 | O | H | T
14 | T | T | B
R | 14 | K | Q
T | Q | Q | M
Y | D | 14 | 14
U |  | X
Spreadsheet: 642517d1569230052-allocation-formula-to-allocate-excess-stocks-to-required-inter-trasnfer-file-test-1-1-
Sheet: Shortage

Sku Code | To Store | Incoming Stock | Qty Needed | From | Allocated | Balance | Action | Incoming excess stock
1000058 | HKP06 |  | 3 | hpp28
1000058 | HHP20 |  | 4 | hpp28
1000058 | HHP30 |  | 4 | hpp28
1000058 | HHP28 |  | 5 | hpp28
1000060 | HHP27 |  | 2 | hpp28
1000060 | HKP22 |  | 5 | hpp28
1000061 | [NAME] |  | 1 | hpp28
1000061 | HKP25 |  | 1 | hpp28
1000061 | HKP06 |  | 2 | hpp28
 |  |  | Result should be
 |  |  | Qty Needed | From | Allocated | Balance | Action
 |  |  | 3 | hpp28 | 3 | 3
 |  |  | 4 | hpp28 | 3 | 0
 |  |  | 4 | hpp28 | 0 | 0
 |  |  | 5 | hpp28 | 0 | 0
 |  |  | 2 | hpp28 | 2 | 7
 |  |  | 5 | hpp28 |  | 2
 |  |  | 1 | hpp28 | 0
 |  |  | 1 | hpp28 | 0
 |  |  | 2 | hpp28 | 0
Spreadsheet: 454601d1459894790-sumifs-column-but-only-if-rows-contain-x-no-of-values-xlf-sum-if-rows-contain-no-zeroes
Sheet: Sheet1

 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | Include in Sum?
ABC | 4 | 6 | 7 | 5 | 3 | 2 | 5 | 6 | 7 | 9 | 3 | 6
DEF | 4 | 7 | 3 | 8 | 4 | 9 | 4 | 6 | 1 | 5 | 7 | 2
ABC | 4 | 7 | 8 | 3 | 5 | 9 |  | 3 | 2 |  | 3 | 7
GHI | 5 | 8 | 3 | 4 | 2 | 6 | 8 | 3 | 5 | 8 | 6 | 4
ABC | 5 | 2 | 7 | 3 | 3 | 9 | 4 | 2 | 5 | 8 | 2 | 1
GHI | 1 | 6 | 3 |  |  | 3 | 7 | 9 | 3 | 5 |  | 3
 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
ABC
DEF
GHI
Spreadsheet: 759429d1639534446-sum-if-array-produces-zero-arrayproblem
Sheet: Boxes

Date | Name | DM
2021-10-22 00:00:00 | P1 | 14.01666666666667
2021-10-22 00:00:00 | P2 | 14.95
2021-10-22 00:00:00 | P3 | 6.8
2021-10-22 00:00:00 | P4 | 9.616666666666667
2021-10-22 00:00:00 | P5 | 14.08333333333333
2021-10-22 00:00:00 | P6 | 11.26666666666667
2021-10-22 00:00:00 | P7 | 5.766666666666667
2021-10-22 00:00:00 | P8 | 13.3
2021-10-22 00:00:00 | P9 | 8.383333333333333
2021-10-22 00:00:00 | P10 | 3.55
2021-10-20 00:00:00 | P1 | 9.783333333333333
2021-10-20 00:00:00 | P2 | 13
2021-10-20 00:00:00 | P3 | 8.2
2021-10-20 00:00:00 | P4 | 13.16666666666666
2021-10-20 00:00:00 | P1 | 9.333333333333334
2021-10-20 00:00:00 | P6 | 8.033333333333333
2021-10-20 00:00:00 | P7 | 9.616666666666667
2021-10-20 00:00:00 | P8 | 8.683333333333334
2021-10-20 00:00:00 | P9 | 4.816666666666666
2021-10-20 00:00:00 | P1 | 4.483333333333333
Spreadsheet: 173431d1344548926-vlookup-lookup2
Sheet: Sheet1

 | A B | 28832.28360000002
 | A B 50% ONLY | 3063.1516
 | AFC-1001 | 35.785
 | BAOC-1000 | 88.87
 | BUTENE | 243016.6015
 | BUTENE BRASKEM | 20718.75
 | DC3203F | 30282.29
 | D350 | 5278.452
 | EF403AQ | 20904.11199999999
 | ET3803 | 2283.7
 | F171B | 51.7
 | HS BLACK REPRO | 37775.08
 | H171B | 5727.200000000001
 | LD124 MS | 6906.25
 | MLLDPE | 183954.64328
 | NX20 | 4.115
 | OCTENE | 885662.0818399993
 | P A | 9494.313800000005
 | PB1600M | 207.51
 | PF1140G | 8529.284
 | PL1840G | 2342.3
 | PX3236 | 113.74
 | SLIP | 22253.40427000002
 | SLIP SSC-0100 | 166.688
 | UE624000 | 4476.360000000001
 | ULTRA LOW | 42680.576
 | UVI | 460.17
 | WHITE | 51132.70140000003
 | 1000 | 367139.70756
 | 1012CA | 41836.83958
 | 12127 SILVER | 59.169
 | 12425 SILVER | 1082.34
 | 14052 ORANGE | 648.0192000000001
 | 15250A RED | 2507.49
 | 1601-2 SURLYN | 4079.25
 | 16180 BLUE | 728.19
 | 1652 SURLYN | 12105.7824
 | 1800 | 267200.9198
 | 20D828 APPEEL | 16312.66
 | 2000 | 12326.112
 | 2010CE | 3012.962
 | 3G46 | 600.24
 | 30E753 | 13187.5
 | 3132 | 60164.361
 | 3600 | 151.89
 | 41E710 | 317.36
 | 4104 | 107403.96
 | 4201 | 13304.8362
 | 5033B | 23341.38
 | 6420 | 142459.4190999999
 | 7194 | 1840.5
 | 7416XCP | 3193.319
 | 7740753 OD | 688
 | 9400 | 278066.22253
 | 9400KP | 24946.397
 | 9659 | 8503.600000000002
 | HS8350 | 153.72
 | PF1140 OR 3132 | 12548.88
 | PM1346 FR ONLY | 1314
Spreadsheet: 107468d1304622557-caluclating-value-of-investment-investments-by-cbl
Sheet: City of Delhi

Date Bought | Property Number | Name | Property Descrption | Amount Paid | [NAME] | Register Letter Cost | Total Paid | Year One Taxes | Year Two taxes | Year Three Taxes | Year Four taxes | Year Five Taxes | Total Invested | Date Redemed | Redemtion Amount | Profit | Value 10/31/11
2011-05-04 00:00:00 | [PHONE] | [NAME] |  | 106.55 | 0.05 |  | 106.55 |  |  |  |  |  | 106.55 |  |  |  | 144.908
Spreadsheet: daren_farmer__6010__EI333reveff061500
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/19/00
Subject:  Revised Availabilities Effective 6/15/00 - 6/16/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-12 00:00:00 | EI 333 | 4084 | 0.1219 |  |  | 2918
1st of month DBQ = 2918/d
Spreadsheet: 186366d1350006434-compare-data-from-two-different-tabs-and-to-identify-variance-items-variance-analysis
Sheet: Comparison

 | Quarter 4 | Quarter 3 | Var
*   3551 SCOGS - 3rd Pty | 1210673.81 | 818202.04 | 392471.77
*   3552 SCOGS TPA - 3rd Pty | 4293132.7 | 1503969.69 | 2789163.01
*   3560 SCOGS - InterCompany | 113403.96 | 164941.49 | -51537.52999999998
*   3703 Mfg Variances | 0 | 79.63 | -79.63
*   3700 CY Currency Variances | -8591.39 | 1254.28 | -9845.67
*   3890 Freight Out | 185823.86 | 121147.75 | 64676.10999999999
*   3895 Distribution | 193718.92 | 192051.8 | 1667.120000000024
*   3895 Distribution - Additional | 20717.43 | 45356.11 | -24638.68
*   3835 Inventory Provisions | 2624.53 | 49925.39 | -47300.86
*   3836 Inventory Provisions TPA | -188533 | 0 | -188533
*   3843 Other Cost Of Sales - Auto | 237176.58 | 121264.86 | 115911.72
*   3843 Other Cost of Sales - Manual | 132945.53 | 236119.13 | -103173.6
*   5099 Promotion Expense | 151055.27 | 166957.41 | -15902.14000000001
*   5041 Samples | 31213.51 | 52047.52 | -20834.01
*   5042 Samples Trans Price Adj | 5158.44 | 8659.92 | -3501.48
*   5299 Selling Expenses | 1571649.23 | 1500720.2 | 70929.03000000003
*   5499 Other Marketing Expense | 184981.86 | 84578.06 | 100403.8
*   5261 G & A Facilities | 85184.12 | 56449.2 | 28734.92
*   5268 G & A Finance | 126451.84 | 79561.63 | 46890.20999999999
*   5269 G & A I.S. | 15581 | 12769.04 | 2811.959999999999
*   5469 G & A I.S. Alloc w/in G&A | 29583.39 | 29951.69 | -368.2999999999993
*   5298 G & A Other | 66792.8 | -35015.92 | 101808.72
*   5897 R&D Regulatory Fees | 12329.97 | 11150.01 | 1179.959999999999
Spreadsheet: 771176d1646478530-fetch-value-to-adjacent-left-next-cell-book2
Sheet: Sheet1

ORIGINAL DATA
[NAME]. | Time | Customer
34627 | 11:25:31 | KEERTHI MINI SUPER MARKET
 | 29BRCPJ1501M1ZV
34658 | 16:31:10 | HARI OM SUPER MARKET
34659 | 16:33:26 | AMBIKA SUPERMARKET
 | 29BERPR5540C1Z5
34660 | 16:35:48 | HEERA DEPARTMENTAL STORE
34662 | 16:40:19 | EVER GREEN SUPER MARKET
 | 29CRHPM3026N2ZB
REQUIRED DATA
[NAME]. | GST Numbers | Customer
34627 | 29BRCPJ1501M1ZV
34658 | 0
34659
34660 | 0
34662
Spreadsheet: 787549d1657855522-calculate-total-rent-over-the-period-of-a-lease-with-annual-fixed-rent-increases-mockup
Sheet: Sheet1

 |  |  |  |  |  |  | proof of concept
 |  |  |  |  |  |  | yr | rent
 | Initial annual rent | 50000 |  |  |  |  | 1
 | Operating Expenses | 10000 |  |  |  |  | 2
 | Lease years | 10 |  |  |  |  | 3
 | CPI | 0.03 |  | annual rent and OPEX increase |  |  | 4
 | Total net rent received over lease period |  |  | Annual rent minus OPEX year on year |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | total
Spreadsheet: 765410d1643306122-count-if-formula-date-issue-count-if-by-date-example
Sheet: Sheet1

Name | Date | Completed |  | Wanted Output |  |  | [NAME]
[NAME] | 2022-01-08 01:07:08 | Yes |  | Date | Count of Completed by Date |  | Date | Count of Completed by Date
[NAME] | 2022-01-08 07:13:57 | Yes |  | 2022-01-08 00:00:00 | 2
[NAME] | 2022-01-08 02:17:21.450000 | No |  | 2022-01-09 00:00:00 | 1 |  | 2022-01-09 00:00:00
[NAME] | 2022-01-09 15:51:47 | Yes |  | 2022-01-10 00:00:00 | 0 |  | 2022-01-10 00:00:00
Sal | 2022-01-10 16:10:59 | No
Spreadsheet: 165991d1341420186-search-values-in-data-table-that-are-greater-than-cell-value-sambuka_premier-quick-help-2-_04jul1_01
Sheet: Quick Search

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Product: |  |  |  |  |  | [NAME]: | Malbec
Country: |  |  |  |  |  | Vendor:
Region: |  |  |  |  |  | BTG Min: | 10 |  | Need to have filtered by greater than / equal to in column G
Appellation: |  |  |  |  |  | BTG Max: | 25 |  | Need to have filtered by less than / equal to in column G
Item ID | Product Name | Size | Pk | Front | Level 3 | BTG | Varietal | Country | Region | Appellation | Vendor | Inv | Order | Date