tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 11 - Table 2

HILA-Ex results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume total ('000 hl) | 6330.963387299918 | -516.247892 | 0 | 564.7096126399689 | 6379.425107939887 | 0.007654715037080262 | 0.09711732467331004
Beer volume ('000 hl) | 2484.487081880003 | -421.8964456699998 | 0 | 324.8911758499933 | 2387.481812059996 | -0.03904438486619255 | 0.1575160723346338
CSD volume ('000 hl) | 3846.476305419917 | -94.35144633000019 | 0 | 239.8184367899725 | 3991.943295879889 | 0.03781824686011981 | 0.06391536683780316
Net revenue | 563.961 | -102.098 | -28.7658749961513 | 82.37987499615129 | 515.477 | -0.08597048377458727 | 0.1783643093214899
Net revenue/hl | 89.07980752681667 | -9.649782038324986 | -4.509164150285116 | 5.882187726266793 | 80.80304906447336 | -0.09291396885710224 | 0.07405496460679142
[NAME] | -372.938 | 68.585 | 18.57194348388519 | -40.24794348388522 | -326.029 | -0.1257823016158182 | 0.1322409947787116
[NAME]/hl | -58.90699048238433 | 6.565134677743323 | 2.911225254571982 | -1.675698701170482 | -51.10632925123951 | -0.1324233536167079 | 0.03201450684944768
Gross profit | 191.023 | -33.51300000000002 | -10.1939315122661 | 42.13193151226607 | 189.448 | -0.008245080435340446 | 0.2674873437385948
Gross margin | 0.3387166843097307 |  | 0 | 0 | 0.3675197923476702 | 290 | 260
SG&A excl. deprec.&amort. | -277.26 | 66.553 | 14.1870768619745 | -36.1350768619745 | -232.655 | -0.1608778763615378 | 0.1714944299998315
SG&A deprec.&amort. | -40.016 | 6.945 | 2.226424250572791 | -7.190424250572791 | -38.035 | -0.04950519792083174 | 0.2174238532421999
SG&A total | -317.276 | 73.49799999999999 | 16.41350111254729 | -43.32550111254729 | -270.69 | -0.1468311501657863 | 0.1777252299737765
Other operating income/expenses | 3.084 | -1.981 | 0.2993570532464316 | -4.607357053246432 | -3.205 | nm | nm
Normalized EBIT | -123.169 | 38.00399999999997 | 6.518926653527622 | -5.800926653527647 | -84.44700000000002 | 0.3143810536742198 | -0.06811397467888974
Normalized EBIT margin | -0.2183998538906059 |  | 0 | 0 | -0.1638230221716973 | 550 | 170
Normalized EBITDA | -55.65100000000001 | 28.893 | 2.981575679659805 | -0.6795756796597944 | -24.456 | 0.5605469802878655 | -0.0253971029097763
Normalized EBITDA margin | -0.09867880935029197 |  | 0 | 0 | -0.04744343588559722 | 510 | 80
Spreadsheet: 777893d1650649113-how-to-change-cell-name-based-on-another-cell-and-place-data-on-correct-row-sample-workbook
Sheet: INPUT

clinic | echeckin | number
CLINIC1 [10402254] | Completed | 92
CLINIC1 [10402254] | In Progress | 9
CLINIC1 [10402254] | Not Yet Available | 1
CLINIC1 [10402254] | Not Started | 19
CLINIC2 [10402304] | Completed | 46
CLINIC2 [10402304] | In Progress | 3
CLINIC2 [10402304] | Not Yet Available | 0
CLINIC2 [10402304] | Not Started | 0
CLINIC3 [10402165] | Completed | 0
CLINIC3 [10402165] | In Progress | 3
CLINIC3 [10402165] | Not Yet Available | 0
CLINIC3 [10402165] | Not Started | 0
Spreadsheet: 150318d1334423484-song-competition-ranking-order-and-breaking-ties-tony-song-list-test-formulae
Sheet: Sheet1

 | artist | song | [NAME] | [NAME] | [NAME] | pete | Total | Rank Helper Column | rank
1 | artist 1 | song 1 | 3 | 3 | 1 | 4 | 11 | 11.41 | 11
2 | artist 2 | song 2 | 5 | 5 | 3 | 5 | 18 | 18.53 | 6
3 | artist 3 | song 3 | 6 | 8 | 6 | 7 | 27 | 27.81 | 3
4 | artist 4 | song 4 | 5 | 3 | 5 | 4 | 17 | 17.52 | 9
5 | artist 5 | song 5 | 1 | 1 | 0 | 3 | 5 | 5.31 | 12
6 | artist 6 | song 6 | 3 | 4 | 4 | 6 | 17 | 17.61 | 8
7 | artist 7 | song 7 | 5 | 4 | 4 | 5 | 18 | 18.52 | 7
8 | artist 8 | song 8 | 7 | 6 | 5 | 4 | 22 | 22.71 | 4
9 | artist 9 | song 9 | 5 | 7 | 6 | 9 | 27 | 27.91 | 2
10 | artist 10 | song 10 | 7 | 5 | 8 | 8 | 28 | 28.82 | 1
11 | artist 11 | song 11 | 6 | 2 | 2 | 6 | 16 | 16.62 | 10
12 | artist 12 | song 12 | 6 | 3 | 6 | 7 | 22 | 22.71 | 4
Spreadsheet: 2f0c1a28-fa2d-4149-ae3e-64ca6bff03e6
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193152527 | Alvin Darling & Celebration | You Can Make It | 2009-10-20 | Compact Disc | Gospel | 10.99 | Y | Available
Taseis | 801193151629 | Alvin Darling & Celebration | My Blessing Is On The Way | 2007-04-17 | Compact Disc | Black Gospel | 10.99 | Y | Available
Spreadsheet: michael_maggi__26462__NYMEXWEEKLY
Sheet: cl

Week Ending: | 2001-10-12 00:00:00
 | Futures Settlement Prices
 | CRUDE OIL |  |  |  |  | Contract Symbol:  CL
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-08 00:00:00 | 2001-10-09 00:00:00 | 2001-10-10 00:00:00 | 2001-10-11 00:00:00 | 2001-10-12 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 22.45 | 22.48 | 22.53 | 23.34 | 22.5 | 91248
 | 2001-12-01 00:00:00 | 22.86 | 22.89 | 22.96 | 23.69 | 22.82 | 102087
 | 2002-01-01 00:00:00 | 23.01 | 23.04 | 23.1 | 23.78 | 22.93 | 42189
 | 2002-02-01 00:00:00 | 23.16 | 23.19 | 23.22 | 23.82 | 22.98 | 19375
 | 2002-03-01 00:00:00 | 23.23 | 23.26 | 23.28 | 23.82 | 23.01 | 17431
 | 2002-04-01 00:00:00 | 23.25 | 23.28 | 23.3 | 23.8 | 22.93 | 15924
 | 2002-05-01 00:00:00 | 23.22 | 23.25 | 23.26 | 23.7 | 22.85 | 10858
 | 2002-06-01 00:00:00 | 23.17 | 23.2 | 23.2 | 23.6 | 22.77 | 27253
 | 2002-07-01 00:00:00 | 23.1 | 23.13 | 23.13 | 23.51 | 22.68 | 9579
 | 2002-08-01 00:00:00 | 23.01 | 23.05 | 23.05 | 23.41 | 22.59 | 11909
 | 2002-09-01 00:00:00 | 22.92 | 22.97 | 22.97 | 23.31 | 22.48 | 11525
 | 2002-10-01 00:00:00 | 22.81 | 22.87 | 22.87 | 23.19 | 22.37 | 7009
 | Total Weekly Volume
 |  |  | 685882 |  | Total Open Interest |  | 451803
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Crude Oil
 | 5 Day Hist. Vol. |  |  | 0.4743
 | 20 Day Hist. Vol. |  |  | 0.7038
 | Implied Volatility-Options
 |  |  |  | Crude Oil
 | At the Money Call & Put
 |  |  |  | 0.5714
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: P Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 15-01-2019 | pdf |  | 01-01) 15-01-2019 | pdf |  | 04-01) 08-04-2019 | pdf |  | 01-01) 08-01-2019 | pdf |  | 11-01) 24-11-2019 | pdf
 | 02-01) 28-02-2019 | pdf |  | 04-01) 09-04-2019 | pdf |  | 07-01) 10-07-2019 | pdf |  | 02-01) 20-02-2019 | pdf
 | 04-01) 09-04-2019 | pdf |  | 07-01) 10-07-2019 | pdf |  | 10-01) 09-10-2019 | pdf |  | 01-01) 14-01-2020 | pdf
 | 05-01) 30-05-2019 | pdf |  | 10-01) 09-10-2019 | pdf |  | 12-01) 22-12-2019 | pdf
 | 07-01) 10-07-2019 | pdf |  | 01-01) 14-01-2020 | pdf
 | 10-01) 09-10-2019 | pdf
 | 11-01) 24-11-2019 | pdf
 | 12-01) 22-12-2019 | pdf
 | 01-01) 14-01-2020 | pdf
Spreadsheet: 865850d1712831474-excel-omits-adjacent-cells-fix-test-excel-1-aligw
Sheet: Cash Flow 2024

Date | Type | Activity | Amount | Description | Total Spend (Past Week) | Total Spend (YTD Type) | Total Spend (YTD Activity) | Total Spend (YTD)
2024-01-01 00:00:00 | Debit | Shopping (Recreational) | 319
2024-01-01 00:00:00 | Transfer | [NAME] (Account Transfer) | 1752.67
2024-01-04 00:00:00 | Debit | Food | 13.2
2024-01-05 00:00:00 | Debit | Food | 21.21
2024-01-05 00:00:00 | Transfer | Misc (Savings) | 250
2024-01-07 00:00:00 | Debit | Living Expenses (Board) | 50
2024-01-09 00:00:00 | Debit | Entertainment (Subscriptions) | 20.99
2024-01-10 00:00:00 | Credit | Income | 2064.82
2024-01-10 00:00:00 | Debit | Shopping (Recreational) | 23.94
2024-01-12 00:00:00 | Transfer | Misc (Savings) | 250
2024-01-13 00:00:00 | Debit | Food | 24.24
2024-01-14 00:00:00 | Debit | Living Expenses (Board) | 50
2024-01-14 00:00:00 | Debit | Events | 8.7
2024-01-14 00:00:00 | Debit | Shopping ([NAME]) | 35
2024-01-14 00:00:00 | Debit | Shopping ([NAME]) | 12.35
2024-01-15 00:00:00 | Debit | Events | 500
2024-01-15 00:00:00 | Debit | Events | 500
2024-01-16 00:00:00 | Credit | Reimbursement | 9
2024-01-18 00:00:00 | Debit | Shopping (Grocery) | 66.68
2024-01-19 00:00:00 | Debit | Food | 24.95
2024-01-19 00:00:00 | Transfer | Misc (Savings) | 250
2024-01-20 00:00:00 | Credit | Present | 100
2024-01-20 00:00:00 | Debit | Events | 147.32
2024-01-20 00:00:00 | Debit | Entertainment (Subscriptions) | 11.95
2024-01-20 00:00:00 | Transfer | [NAME] (Account Transfer) | 8.88
2024-01-21 00:00:00 | Debit | Living Expenses (Board) | 50
2024-01-22 00:00:00 | Debit | Food | 13.75
2024-01-23 00:00:00 | Debit | Transport | 56.1 | MetroCard
2024-01-24 00:00:00 | Credit | Income | 2627.99
2024-01-24 00:00:00 | Debit | Food | 19.3
2024-01-24 00:00:00 | Debit | Food | 7
2024-01-25 00:00:00 | Debit | Living Expenses (Misc) | 35.53 | Haircut
2024-01-25 00:00:00 | Debit | Shopping (Recreational) | 33.15
2024-01-25 00:00:00 | Debit | Shopping ([NAME]) | 16.15
Spreadsheet: 71504d1272283247-dropdown-menu-inside-an-dropdownmenu-kokeilu
Sheet: Sheet1

 | data2 |  | data 2
 |  |  | name |  | value |  | unit
 |  |  | xxxx |  | 2 |  | s
 |  |  | xxx |  | 45 |  | mbar |  |  |  |  |  |  |  | data2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | data3
 |  |  | aaa |  | 2
 | when data 2 is selected from the dropdown menu in cell B3 |  | www |  | 333 |  | deg
 |  |  | ggg |  | 456 |  | C
 | then i would like to have a drop down menu in cell D16 |  | table y
 |  |  |  |  | 10 | 200 | 200 | 200 | 200 | 200
 |  |  |  |  | 10 | 56 | 6 | 78 | 78 | 6
 | so that i can choose table y, table b or table c |  |  |  | 10 | 56 | 5 | 4 | 45 | 56
 |  |  |  |  | 10 | 5 | 5 | 56 | 86 | 6
 |  |  |  |  | 10 | 3 | 6 | 45 | 78 | 6
 |  |  |  |  | 10 | 8 | 4 | 45 | 45 | 45
 |  |  |  |  | 10 | 45 | 45 | 5 | 3 | 45
 |  |  |  |  | Table b
 |  |  |  |  | 15 | 333 | 333 | 333 | 333 | 333
 |  |  |  |  | 15 | 56 | 56 | 5 | 7 | 76
 |  |  |  |  | 15 | 4 | 46 | 5 | 5 | 7
 |  |  |  |  | 15 | 7 | 56 | 346 | 36 | 6
 |  |  |  |  | 15 | 6 | 47 | 43 | 5 | 45
 |  |  |  |  | 15 | 7 | 4 | 4 | 4 | 7
 |  |  |  |  | 15 | 2 | 6 | 4 | 64 | 7
 |  |  |  |  | table c
 |  |  |  |  | 30 | 250 | 250 | 250 | 250 | 250
 |  |  |  |  | 30 | 36 | 56 | 68 | 568 | 568
 |  |  |  |  | 30 | 36 | 8 | 8 | 45 | 5
 |  |  |  |  | 30 | 36 | 3 | 36 | 5 | 7
 |  |  |  |  | 30 | 8 | 346 | 56 | 56 | 346
 |  |  |  |  | 30 | 36 | 7 | 3467 | 34 | 345
 |  |  |  |  | 30 | 3 | 347 | 3 | 45 | 66
Spreadsheet: 111141d1307605120-copying-and-separating-out-delimited-fields-copying-and-separating-out-delimited-fields
Sheet: SHIPMENTS

Filed1 | Filed2 | Filed3 | Filed4 | Row Position | Total Numbers
PART X | DEVICE | 2009-02-26 00:00:00 | 34228ý39598ý62038ý41379ý42628 | 1 | 5
PART Y | DEVICE2 | 2011-03-10 00:00:00 | 31223ý34000 | 6 | 2
PART Z | [NAME] | 2011-03-11 00:00:00 | 34111 | 8 | 1
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 17

Product* | November 22 | November 29 | December 6 | December 13 | December 20
Total*** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Agricultural | N/A | N/A | N/A | N/A | N/A
Index | N/A | N/A | N/A | N/A | N/A
Energy | N/A | N/A | N/A | N/A | N/A
Metals | N/A | N/A | N/A | N/A | N/A
OTHER** | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, December 20 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**OTHER variable includes the following products: Multi-Commodity, Environmental, and Freight.
***These numbers are estimates.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: sally_beck__35758__MgmtSum-Q1-0313
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON NORTH AMERICA
2000-03-01 00:00:00 | 1ST QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast Margin Calculation
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin |  |  |  | Earnings Before Allocated Expenses
 | Business Team |  | DPR* | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME] |  |  | Plan | Forecast | [NAME]
[NAME] | Gas Trading |  | 42097
[NAME] | Power Trading |  | 71056
IR_FX | Financial Drift |  | 19516
ECT_INV_IRFX | Financial Trading
TRD_MKT | Canada |  | 12897 | 2098 |  |  | -2820
COAL | Coal |  | 410 | 52 | 16
WEATHER | Weather |  | 5422
SO2 | Emissions |  | 2018
INSURANCE | Insurance Group
EXEC_TRD | Executive Trading |  | -223
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream |  |  | 3723
PAPER | Industrial Downstream - Paper |  |  | 189
DWNSTRM_IND_ORIG | Industrial Downstream - Chemicals |  |  | 1
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico
EXEC_ORIG | Executive Origination
 | Total Origination
GENCOS | Genco |  | 15914
N_BS_DEV | Generation Investments |  |  | 3553 |  |  |  |  |  | 3000
ASST_ORIG | Gas Assets |  |  |  |  |  |  |  |  | 410
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  |  | 107896
PROD_FIN | Upstream E&P |  |  | 25741 | 157
ENVR_ENGY | Investment Management |  |  | -18563 | -447 |  |  |  |  | -3000
RESTRUCTURING | Restructuring |  |  | 4134 | 41 |  |  |  |  | -4000
FIN | Canada - Investing
 | Total Investing
CTG | Commercial Transactions Group |  |  |  |  | 100
OF_CHAIR | Office of the Chairman
TREASURY_INT | Other Interest Related Charges |  |  | -7935 |  | -12576
 | Overview
 | Total
 | * Excludes Cap. Charge & Operating Costs
 | Check Figures
 | Gas Trading
 | Emerging Businesses
Spreadsheet: 96877d1296139881-countifs-to-get-criteria-from-a-cell-reference-capacity
Sheet: Details

 | Current | Tool 1 | Tool 2 | Tool 3 | Tool 4 | Tool 5
per comm | 2.5 | 2.25 | 2 | 1.75 | 1.5 | 1
# people | Current | Tool 1 | Tool 2 | Tool 3 | Tool 4 | Tool 5
5 HC
6 HC
7 HC
8 HC
9 HC
10 HC
# people | Current | Tool 1 | Tool 2 | Tool 3 | Tool 4 | Tool 5
5 HC
6 HC
7 HC
8 HC
9 HC
10 HC
Spreadsheet: 148201d1333243017-how-to-make-x-equal-total-beginner12_help_31mar12_01
Sheet: Sheet1

Items | Count | Price | Per Piece | number of pieces | Total | Use This Item | Column8 | # of X Boxes | Column10
Ribbons | 83 | 1.5 |  | 2 |  | x
Pull Bow 5.5 | 50 | 14.75 |  | 3 |  | x
Pull Bow 4 | 100 | 14.75
Pull Bow 1 | 87 | 14.75
Pull Bow 3.5 | 10 | 14.75 |  | 5 |  | x
Pull Bow 2 | 58 | 14.75
I need to calculate the amount for the X boxes.
How do I get the X cells in column G to give a complete total of the cell for the items being used?
Spreadsheet: 80890d1281039541-compare-and-replace-formula-needed-sub-list-fix-example
Sheet: Sheet1

80354785 |  | 80354786
80354786 |  | 354786
80354787 |  | 80458658
80354788 |  | 80362352
80354790 |  | 80362353
80354791 |  | 354791
80354799 |  | 80354805
80354805 |  | 80354786
80354807 |  | 80362613
80354812 |  | 80332038
80354833 |  | 354833
80354834 |  | 80354837
80354837 |  | 354837
80354847 |  | 354847
80354873 |  | 80237078
Spreadsheet: 797492d1663922253-to-sum-accumlative-as-per-category-in-one-column-case-accumulative
Sheet: Sheet1

Cat | Value | % of Accum | HD |  | expected Results
A | 100 |  |  | in Column C4, need one single formula to accumulated of value based on Categories
A | 100
A | 100
A | 100
A | 100
A | 100
A | 100
A | 100
B | 100
B | 100
B | 100
B | 100
B | 100
B | 100
B | 100
B | 100
B | 100
C | 100
C | 100
C | 100
C | 100
C | 100
C | 100
C | 100
Spreadsheet: 665630d1583249118-complex-timesheet-template-sample-timesheet-fish31-
Sheet: Sheet2

Date | Task | Time In | Break Start | Break End | Time Out | Total Hrs | Task A Hrs | Task A OT Hrs | Task B Hrs | Task B OT Hrs | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Sat | Task A | 09:00:00 | 12:00:00
 | Task B |  |  | 13:00:00 | 18:00:00
Sun | Task A
 | Task B
Mon | Task A | 09:00:00 | 12:00:00 | 13:00:00 | 18:00:00
 | Task B
Tue | Task A |  |  | 19:00:00 | 20:00:00
 | Task B | 09:00:00 | 12:00:00 | 13:00:00 | 19:00:00
Wed | Task A | 09:00:00 | 12:00:00 | 13:00:00 | 18:00:00
 | Task B |  |  | 18:00:00 | 19:00:00
Thu | Task A | 09:00:00 | 12:00:00 | 13:00:00 | 17:00:00
 | Task B |  |  | 17:00:00 | 18:00:00
Fri | Task A | 09:00:00 | 12:00:00 | 18:00:00 | 19:00:00
 | Task B |  |  | 13:00:00 | 18:00:00
Spreadsheet: 136638d1326752663-auto-populate-work-order-forms-from-different-sheet-example
Sheet: New Work order

Date Called: |  |  |  |  |  |  | Time: |  |  |  |  | Designated Employee: |  |  |  |  | Report Provided: (circle one)                                       YES - Attach Copy           NO - Fill In Scope of Work |  |  |  |  |  | Date Called | Time | Employee | Report Provided | Return Call by | Appt Req'd | Service Date | Time | Company | Hours of operation | Days of Operation | Contact | Acct Number | Acct Status | PO Req'd | Address
JAN 10 2012 |  |  |  |  |  |  | 09:00:00 |  |  |  |  | DP |  |  |  |  | NO |  |  |  |  |  | JAN 10 2012 | 0.375 | DP | NO | . | . | JAN 13 2012 | AM | SAFETY BOSS | . | . | AFSANEH | S0618 | CHARGE | NO | 2501 ALYTH ROAD SE
Return Call By: |  |  |  |  |  |  |  |  |  |  |  | Appt. [NAME]?:           YES    NO |  |  | Service Date: |  |  |  |  | Time: |  |  | PO # | Payment Type | City | Province | Postal Code | Card Number | Exp | Phone | Cell | Job Number | Fax | [NAME] | Jobsite Address | Alternate Contact | Phone | Information
. |  |  |  |  |  |  |  |  |  |  |  | . |  |  | JAN 13 2012 |  |  |  |  | AM |  |  | . | CHARGE | CALGARY | AB | . | . | . | [PHONE] | . | . | . | . | . | . | . | CHECK TO SEE IF THIS IS A MOVE OR A NEW BUILDING IN ADDITION TO THEIR DOWNTOWN LOCATION
Company: |  |  |  |  |  |  |  |  |  |  |  | Hours of Operation: |  |  |  |  |  | Days of Operation: |  |  |  |  | Last Service | Service Due | City Section
SAFETY BOSS |  |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  |  | . |  |  |  |  | JUNE 2010 | JUNE 10TH 2011 | NE9 | NE10
Contact: |  |  |  |  |  |  |  |  |  |  |  | Acct# |  |  |  |  | Acct. Status: CHARGE     COD |  |  | PO# [NAME]?           YES - Fill In PO#   NO
AFSANEH |  |  |  |  |  |  |  |  |  |  |  | S0618 |  |  |  |  | CHARGE |  |  | NO
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | PO# |  |  |  |  |  |  | Payment Type:                                           VISA   M/C   CASH   CHEQ
2501 ALYTH ROAD SE |  |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  |  |  | CHARGE
City: |  |  |  |  |  | Province: |  |  | Postal: |  |  | Card Number: |  |  |  |  |  |  |  | EXP:
CALGARY |  |  |  |  |  | AB |  |  | . |  |  | . |  |  |  |  |  |  |  | . |  |  |  | w-761070
Phone: |  |  |  |  |  | Cell: |  |  |  |  |  | Job Number (If [NAME]):
[PHONE] |  |  |  |  |  | . |  |  |  |  |  | .
Fax: |  |  |  |  |  | E-Mail: |  |  |  |  |  | Jobsite Address (if different from billing address):
. |  |  |  |  |  | . |  |  |  |  |  | .
Alternate Contact: |  |  |  |  |  | Phone: |  |  |  |  |  | City Section
. |  |  |  |  |  | . |  |  |  |  |  | SE1
Information/Message/Scope of Work:
CHECK TO SEE IF THIS IS A MOVE OR A NEW BUILDING IN ADDITION TO THEIR DOWNTOWN LOCATION
Spreadsheet: 147542d1332852092-summarising-multiple-entries-in-an-array-help-with-sumifs-example
Sheet: Sheet1

SOURCE DATA/ARRAY |  | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00
A Contractor | Bristol | 0 | 100 | 120
Another Person | Bristol | 100 | 100 | 0
Person 3 | London | 200 | 200 | 200
Person 4 | London | 50 | 0 | 50
SUMMARY | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00
Bristol | #N/A
London
SUMMARY | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00
Bristol | 100 | 200 | 120
London | 250 | 200 | 250
Spreadsheet: 43961d1242646731-sum-only-negative-numbers-for-a-specific-name-negativecust
Sheet: Sheet1

AAA | -45
AAA | -300
BBB | -799
AAA | 356
CCC | 66
AAA | 621
BBB | 567
BBB | 33
BBB | -66
BBB | 34
BBB | -75
CCC | 66
AAA | -3
CCC | 33
CCC | -754
AAA | 84
BBB | 458
 |  | Should be
AAA | (?) | -348
BBB | (?) | -940
CCC | (?) | -754
Spreadsheet: 884667d1733908107-struggling-with-indirect-formula-project-stat-template-202412110900
Sheet: 2025

 |  |  |  |  |  |  |  | 2025
Number | Request Date | Project ref | Section | Contact | Request Description | Request Type: Research Development Explore Response Consultation Learning | Urgent Y/N | Customer Name | CEO | Dept. | Business Area | Secondary Areas: | Action | STATUS: Approved - Start Approved - wait Rejected Differed Scoping Referred Completed | Date of last Status Action
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Urgent |  |  | 2024 Overall tasks |  |  | Tasks for dept |  |  | Tasks status |  |  | Tasks per team
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes |  |  | Jan |  |  | Section1 |  |  | Scoping |  |  | TeamA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  | Feb |  |  | Section2 |  |  | Approved |  |  | TeamB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar |  |  | Section3 |  |  | Rejected |  |  | TeamC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr |  |  | Section4 |  |  | Differed |  |  | TeamD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Urgent & Completed |  |  | May |  |  | Section5 |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes |  |  | Jun |  |  | Section6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  | Jul |  |  | Section7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug |  |  | Section8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep |  |  | Section9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct |  |  | Section10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov |  |  | Section11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec |  |  | Section12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 800180d1665521251-how-to-display-current-based-on-location-date-and-time-in-cities
Sheet: Sheet1

Location | Time Zone UTM | Date and Time
Local Time | -5
UTM | 0
Houston, Texas | -5
Los Angeles, CA | -7
New York, NY | -5
Queensland | 10 |  |  | Los Angeles, CA
Argentina | -3
Congo | 1
Hawaii, HI | -10
Atlanta, GA | -4
Boise, ID | -7
[NAME] | 9
Taiwan | 8
Other City | 7
Spreadsheet: 169148d1342711980-unique-values-without-remove-duplicates-sample-2
Sheet: Sheet1

Clean Link Domain | Clean Target URL | Common Competitor Links
11plus.co.uk | getyourlearners.co.za | 0
a1windups.co.uk | salearners.co.za | 0
arrivealive.co | getyourlearners.co.za | 1 | You will see that the data in col a is common to 3 rows in col [NAME], the first instance needs to be a 1
arrivealive.co | salearners.co.za | 0
arrivealive.co | k53.gavinhoole.ws | 0
arrivealive.co.za | getyourlearners.co.za | 1 | Same here, you will see col A is commin to 3 rows in COL B, it also needs to be counted.
arrivealive.co.za | salearners.co.za | 0
arrivealive.co.za | k53.gavinhoole.ws | 0
autostart.co.za | salearners.co.za | 0 | Here col a only has 1 reference in col B.
brainexperiment.org | getyourlearners.co.za | 0
carinsurance.arrivealive.co.za | salearners.co.za | 0
chuckra.co.uk | getyourlearners.co.za | 0
chuckra.com | getyourlearners.co.za | 0
idrive.co.za | salearners.co.za | 0
insurancechat.co.za | k53.gavinhoole.ws | 0
joblog.co.za | salearners.co.za | 0
kidspartyvenues.co.za | getyourlearners.co.za | 0
loaded.co.za | salearners.co.za | 0
mysite.mweb.co.za | salearners.co.za | 0
pressportal.co.za | getyourlearners.co.za | 0
rainbownation.com | salearners.co.za | 0
saeverything.co.za | salearners.co.za | 0
satoplinks.co.za | salearners.co.za | 0
searchengine.co.za | getyourlearners.co.za | 0
unlock-your-happiness.com | k53.gavinhoole.ws | 0
webaddict.co.za | salearners.co.za | 0
webmastercoffee.com | k53-test.co.za | 0