tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36705d1234555166-using-list-function-with-hiding-irrelevant-outputs-monthly-models-3
Sheet: VOLUMES 

Entire 2008 |  | 0.01
Source | A | B | C | Total
COMPANY 2 | 8899 | 60.77 | 3813 | 12772.77
COMPANY 2 - Total | 8899 | 60.77 | 3813 | 12772.77
2008-01-01 00:00:00
COMPANY 2 | 530 | 4.69 | 321 | 855.69
COMPANY 2 - Total | 530 | 4.69 | 321 | 855.69
2008-02-01 00:00:00
COMPANY 2 | 390 | 3.16 | 207 | 600.1600000000001
COMPANY 2 - Total | 390 | 3.16 | 207 | 600.1600000000001
2008-03-01 00:00:00
COMPANY 2 | 465 | 2.62 | 171 | 638.62
COMPANY 2 - Total | 465 | 2.62 | 171 | 638.62
2008-04-01 00:00:00
COMPANY 2 | 944 | 4.51 | 199 | 1147.51
COMPANY 2 - Total | 944 | 4.51 | 199 | 1147.51
2008-05-01 00:00:00
COMPANY 2 | 1028 | 7.09 | 304 | 1339.09
COMPANY 2 - Total | 1028 | 7.09 | 304 | 1339.09
2008-06-01 00:00:00
COMPANY 2 | 944 | 8.34 | 249 | 1201.34
COMPANY 2 - Total | 944 | 8.34 | 249 | 1201.34
2008-07-01 00:00:00
COMPANY 2 | 1005 | 6.59 | 226 | 1237.59
COMPANY 2 - Total | 1005 | 6.59 | 226 | 1237.59
2008-08-01 00:00:00
COMPANY 2 | 860 | 5.75 | 197 | 1062.75
COMPANY 2 - Total | 860 | 5.75 | 197 | 1062.75
2008-09-01 00:00:00
COMPANY 2 | 769 | 5.93 | 619 | 1393.93
COMPANY 2 - Total | 769 | 5.93 | 619 | 1393.93
2008-10-01 00:00:00
COMPANY 2 | 847 | 4.26 | 369 | 1220.26
COMPANY 2 - Total | 847 | 4.26 | 369 | 1220.26
2008-11-01 00:00:00
COMPANY 2 | 606 | 3.75 | 472 | 1081.75
COMPANY 2 - Total | 606 | 3.75 | 472 | 1081.75
2008-12-01 00:00:00
COMPANY 2 | 511 | 4.08 | 479 | 994.08
COMPANY 2 - Total | 511 | 4.08 | 479 | 994.08
Spreadsheet: 227307d1365671279-competition-generator-leaguekatti
Sheet: Sheet1

 | Player | P | W | D | L | F | A | [NAME] | Pts | points deducted
1
2
3
4
Spreadsheet: 5e339c78-d751-415c-b7f3-a900d965c99c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
36329462 | 2013-06-10 00:48:31 | AXIS | 0 | 3 | 6 | 904518 | lordgun | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
36414719 | 2013-06-16 01:29:08 | ALLIES | 1 | 6 | 4 | 1343414 | Wooj87 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
36415107 | 2013-06-16 02:24:46 | ALLIES | 0 | 7 | 10 | 1344296 | player1344296 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
36415461 | 2013-06-16 02:48:45 | AXIS | 1 | 10 | 7 | 1344296 | player1344296 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T33

الجدول 33: النسبة المئوية للإعالة لمجموع السكان خلال سنوات التعداد
Table 33: Dependency ratio during the census years
Country | Round 2000           دورة 2000 |  | Round 2010           دورة 2010 |  | البلد
 | census year سنة التعداد | dependency % نسبة الإعالة | census year سنة التعداد | dependency % نسبة الإعالة
Bahrain | 2001 | 43.66178522849724 | 2010 | 28.50289466178984 | البحرين
Egypt | 1996 | 69.68700438847395 | 2006 | 69.73021738864531 | مصر
Iraq | 1997 | 93.36027156090952 |  | … | العراق
Jordan | 2004 | 68.22721888338114 |  | … | الاردن
Kuwait | 1995 | 45.59630375609385 | 2005 | 36.27159012128486 | الكويت
Lebanon |  | … |  | … | لبنان
Oman | 2003 | 57.30783659101635 | 2010 | 43.8654050748277 | عمان
Palestine | 1997 | 102.0566503515685 | 2007 | 89.17227501910958 | فلسطين
Qatar | 2004 | 31.13693405338334 | 2010 | 16.95768990952724 | قطر
Saudi Arabia | 2004 | 59.04145633668879 |  | … | المملكة العربية السعودية
Sudan |  | … | 2008 | 85.16454014327775 | السودان
Syrian Arab Republic | 2004 | 91.46985273687135 |  | … | الجمهورية العربية السورية
United Arab Emirates | 1995 | 37.67811701928392 | 2005 | 25.62089579816612 | الإمارات العربية المتحدة
Yemen | 2004 | 94.06888081621177 |  | … | اليمن
Spreadsheet: 083649de-b258-478f-b978-e54ff52d946c
Sheet: Sheet1

CSBG PROGRAM | Unnamed: 1 | Unnamed: 2
REQUEST FOR REIMBURSEMENT
1.  MAIL TO: | 2.  TYPE OF PAYMENT: | 3.  GRANTEE ORGANIZATION:
 | (mark one) | (Name and Remit Address)
CSBG Program
Department of Local Affairs | _______ Monthly Reimbursement
Division of Local Government
1313 Sherman Street, Room 521 | _______ Final Reimbursement
Denver, CO 80203
4.PERIOD COVERED BY THIS REQUEST: | 5.  PAYMENT | 6. CONTRACT ENCUMBRANCE
 | REQUEST NUMBER | NUMBER:
FROM:                        TO:
 | # ______ | L12CSBG____(enter last two digits here)
7.  BUDGET CATEGORY (Identify budget line items and the corresponding reimbursement request for that line item)
Budget Category |  | Reimbursement Amount
Indirect Operating and Personnel costs
Direct Operating andf Personnel costs
Subgrantee (identify by name below, each subgrantee agency requesting reimbursement)
Agency Name:
Agency Name:
Agency Name:
Agency Name:
Agency Name:
Agency Name:
Agency Name:
8.  COMPUTATION OF AMOUNT AND REIMBURSEMENT
a.  TOTAL CSBG FUNDS CURRENTLY BEING REQUESTED: |  | 0
[NAME] REQUESTED: |  | 0
[NAME] TO DATE (LINE 8a PLUS LINE 8b) |  | 0
d.  TOTAL CSBG CONTRACT AMOUNT: |  | 0
e.  TOTAL CSBG REMAINING BALANCE (LINE 8d MINUS LINE 8c) |  | 0
CERTIFICATION: | 9.  ORIGINAL SIGNATURE OF | DATE REIMBURSEMENT SUBMITTED:
 | AUTHORIZED SIGNATORY
I certify to the best of my knowledge
and belief the data above is correct
and that all expenditures were made
in accordance with the grant | PRINT NAME AND TITLE: | PHONE #: (person preparing report)
requirements.
 |  | EMAIL ADDRESS:
Spreadsheet: 166521d1341605437-building-estimation-spreadsheet-estimating-sheet
Sheet: Sheet1

Code | Item | Cost | Delivery | total |  |  | Code | Item | Cost | Delivery | total
10001 | G | 100 | 50 |  |  |  | 10001
10002 | S | 75 | 50
10003 | M | 60 | 50
10004 | L | 110 | 0
10005 | F | 50 | 0
10006 | T | 120 | 50
Spreadsheet: 154435d1336424122-challenge-with-ranked-cells-tigeravatar-example-for-led1308-with-unique-rank
Sheet: Sheet1

Item | Score | Unique Rank |  | Rank | Item
Item A | 12 | 3 |  | 1 | Item B
Item B | 14 | 1 |  | 2 | Item D
Item C | 11 | 4 |  | 3 | Item A
Item D | 14 | 2
Spreadsheet: 873576d1720081153-data-formatting-help-example
Sheet: Data

Original Example - format will be the same but there may be more or fewer rows |  |  |  | Required Output
Product Description | Ingredient | Country of Origin |  | Product Description | Ingredient | Country of Origin
Product 1 | Water | UK |  | Product 1 | Water | UK
 | Fish | Spain |  |  | Fish | Spain
 | Sugar | UK |  |  | Sugar | UK
 | Salt | UK, The Netherlands, Portugal, Italy |  |  | Salt | UK
 | Butter | UK, New Zealand |  |  |  | The Netherlands
 | [NAME] | UK, France |  |  |  | Portugal
 | Eggs | UK |  |  |  | Italy
 | Milk | Uk, Jersey |  |  | Butter | UK
 |  |  |  |  |  | New Zealand
 |  |  |  |  | [NAME] | UK
 |  |  |  |  |  | France
 |  |  |  |  | Eggs | UK
 |  |  |  |  | Milk | UK
 |  |  |  |  |  | Jersey
Spreadsheet: 147302d1332712962-excel-2003-drop-down-bar-auto-fill-another-cell-invoices-1-
Sheet: Sheet1

 |  |  |  |  |  | Fishing |  |  |  |  | Homeware
 |  | Invoice Month | Spend | Department |  | Month | Total Spend Per Month | Budget | Allowance |  | Month | Total Spend Per Month | Budget | Allowance
January |  | January | 1000 | Fishing |  | January | 4000 | 10000 | 6000 | 3200 | January |  | 10000 | 10000
February |  | January | 1000 | Shooting |  | February | 2000 | 10000 | 8000 |  | February |  | 10000 | 10000
March |  | January | 1000 | Homeware |  | March | 2300 | 10000 | 7700 |  | March |  | 10000 | 10000
April |  | February | 2000 | Fishing |  | April | 0 | 10000 | 10000 |  | April |  | 10000 | 10000
May |  | March | 2300 | Fishing |  | May | 0 | 10000 | 10000 |  | May |  | 10000 | 10000
June |  | February | 1200 | Homeware |  | June | 0 | 10000 | 10000 |  | June |  | 10000 | 10000
July |  | April | 1000 | Homeware |  | July | 0 | 10000 | 10000 |  | July |  | 10000 | 10000
August |  | January | 3000 | Fishing |  | August | 1000 | 10000 | 9000 |  | August |  | 10000 | 10000
September |  | August | 1000 | Fishing |  | September | 0 | 10000 | 10000 |  | September |  | 10000 | 10000
October |  | December | 123 | Shooting |  | October | 0 | 10000 | 10000 |  | October |  | 10000 | 10000
November |  | June | 2999 | Shooting |  | November | 0 | 10000 | 10000 |  | November |  | 10000 | 10000
December |  | July | 2340 |  |  | December | 0 | 10000 | 10000 |  | December |  | 10000 | 10000
 |  | October | 7650
Fishing |  | December | 1000 |  |  | Shooting
Shooting |  | November | 100 |  |  | Month | Total Spend Per Month | Budget | Allowance
Homeware |  | November | 4566 |  |  | January | 1000 | 10000 | 9000 |  | from the help given before I am able to populate column H. if I add another factor in such a department. How do I populate only the relevant department and that months department????
 |  | May | 3225 |  |  | February | 0 | 10000 | 10000
 |  | March | 2578 |  |  | March | 0 | 10000 | 10000
 |  | May | 100 |  |  | April | 0 | 10000 | 10000
 |  | May | 100 |  |  | May | 0 | 10000 | 10000
 |  | October | 7474 |  |  | June | 2999 | 10000 | 7001
 |  | September | 2357 |  |  | July | 0 | 10000 | 10000
 |  | June | 765 |  |  | August | 0 | 10000 | 10000
 |  | December | 56 |  |  | September | 0 | 10000 | 10000
 |  |  |  |  |  | October | 0 | 10000 | 10000
 |  |  |  |  |  | November | 0 | 10000 | 10000
 |  |  |  |  |  | December | 123 | 10000 | 9877
 |  |  |  |  |  | Homeware
 |  |  |  |  |  | Month | Total Spend Per Month | Budget | Allowance
 |  |  |  |  |  | January | 1000 | 10000 | 9000
 |  |  |  |  |  | February | 1200 | 10000 | 8800
 |  |  |  |  |  | March | 0 | 10000 | 10000
 |  |  |  |  |  | April | 1000 | 10000 | 9000
 |  |  |  |  |  | May | 0 | 10000 | 10000
 |  |  |  |  |  | June | 0 | 10000 | 10000
 |  |  |  |  |  | July | 0 | 10000 | 10000
 |  |  |  |  |  | August | 0 | 10000 | 10000
 |  |  |  |  |  | September | 0 | 10000 | 10000
 |  |  |  |  |  | October | 0 | 10000 | 10000
 |  |  |  |  |  | November | 0 | 10000 | 10000
 |  |  |  |  |  | December | 0 | 10000 | 10000
Spreadsheet: 96970d1296197301-converting-a-curvilinear-relationship-into-a-linear-one-curve-to-straight-line
Sheet: Sheet1

 | N | DATA | y
 | 0 | -1.786
 | 1 | -1.388
 | 2 | -1.226
 | 3 | #N/A
 | 4 | #N/A
 | 5 | #N/A
 | 6 | #N/A
 | 7 | -0.836
 | 8 | #N/A
 | 9 | #N/A
 | 10 | #N/A
 | 11 | -0.5238
 | 12 | -0.4364
 | 13 | #N/A
 | 14 | #N/A
 | 15 | -0.3205
 | 16 | -0.2595 |  |  |  |  |  | y = c + a * (1 - EXP(-b * x)) |  |  | How can we transform the data so we can see the relationship in a straight line?
 | 17 | -0.2191
 | 18 | -0.1891 |  |  |  |  |  | a= | 1.6483855
 | 19 | -0.174 |  |  |  |  |  | b= | 0.12338628
 | 20 | -0.1672 |  |  |  |  |  | c= | -1.6802232
 | 21 | -0.1554
 | 22 | #N/A
 | 23 | -0.1248
 | 24 | -0.1056
 | 25 | -0.09152
 | 26 | -0.03631
 | 27 | 0.01358
 | 28 | -0.02479
 | 29 | -0.04465
 | 30 | #N/A
 | 31 | #N/A
 | 32 | -0.06065
 | 33 | -0.06171
 | 34 | #N/A
 | 35 | -0.02346
 | 36 | -0.01639
 | 37 | -0.01063
 | 38 | -0.00703
 | 39 | -0.00578
 | 40 | -0.00674
 | 41 | #N/A
 | 42 | #N/A
 | 43 | -0.06989
 | 44 | -0.1145
 | 45 | #N/A
 | 46 | #N/A
 | 47 | #N/A
 | 48 | #N/A
 | 49 | -0.1198
 | 50 | -0.09813
 | 51 | -0.1004
 | 52 | #N/A
 | 53 | #N/A
 | 54 | #N/A
 | 55 | -0.0692
 | 56 | -0.06275
 | 57 | #N/A
 | 58 | -0.04865
 | 59 | -0.03692
 | 60 | -0.02917
 | 61 | -0.02605
 | 62 | #N/A
 | 63 | -0.02594
 | 64 | -0.02092
 | 65 | -0.01987
 | 66 | #N/A
 | 67 | #N/A
 | 68 | #N/A
 | 69 | #N/A
 | 70 | #N/A
 | 71 | #N/A
 | 72 | #N/A
 | 73 | #N/A
 | 74 | #N/A
 | 75 | #N/A
 | 76 | #N/A
 | 77 | -0.08259
 | 78 | -0.05582
 | 79 | -0.03424
 | 80 | -0.02461
 | 81 | -0.0233
Spreadsheet: 537713d1505233413-pivottable-count-non-zeros-count-months-of-activity
Sheet: Sheet1

 | CITY | NAME | DEP | year | MONTH | AMOUNT
 | NY | TOM | FINANCE | 2017 | JAN | 100 |  |  |  |  |  | Count of AMOUNT |  |  |  | MONTH
 | NY | TOM | FINANCE | 2017 | FEB | 150 |  |  |  |  |  | CITY | NAME | DEP | year | JAN | FEB | MAR | APR | MAY | JUN | (blank) | Grand Total
 | NY | TOM | FINANCE | 2017 | MAR | 200 |  |  |  |  |  | NY | TOM | FINANCE | 2017 | 2 | 2 | 1 | 1 | 1 | 1 |  | 8
 | NY | TOM | FINANCE | 2017 | APR | 0 |  |  |  |  |  | (blank) | (blank) | (blank) | (blank)
 | NY | TOM | FINANCE | 2017 | MAY | 0 |  |  |  |  |  | Grand Total |  |  |  | 2 | 2 | 1 | 1 | 1 | 1 |  | 8
 | NY | TOM | FINANCE | 2017 | JUN | 0
 | NY | TOM | FINANCE | 2017 | JAN | 500
 | NY | TOM | FINANCE | 2017 | FEB | 600
Spreadsheet: 875586d1722190937-how-is-to-represent-number-of-completed-sent-reports-in-chart-report
Sheet: Sheet1

Months | No of reports
Jan | 17
Feb | 19
Mar | 22
Apr | 18
May | 24
Jun | 25
Jul | 23
Aug | 30
Sep | 26
Oct | 23
Nov | 16
Dec | 20
Spreadsheet: 76a192b2-ae54-4496-9c3b-6cffc3b93a4a
Sheet: Sheet1

Unnamed: 0 | CITRIX SYSTEMS, INC. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | REVENUES BY PRODUCT MIX
 | (In thousands)
 |  |  | Three Months |  | Three Months |  | Three Months |  | Three Months |  | Year
 |  |  | Ended |  | Ended |  | Ended |  | Ended |  | Ended
 |  |  | March 31, |  | June 30, |  | September 30, |  | December 31, |  | December 31,
 |  |  | 2007 |  | 2007 |  | 2007 |  | 2007 |  | 2007
 | Revenues:
 | Product licenses |  | 122067 |  | 136587 |  | 140460 |  | 178030 |  | 577144
 | License updates |  | 112808 |  | 118163 |  | 124035 |  | 129663 |  | 484669
 | Online services |  | 47211 |  | 51810 |  | 55744 |  | 58979 |  | 213744
 | Technical services |  | 26002 |  | 27804 |  | 29692 |  | 32887 |  | 116385
 | Total net revenues |  | 308088 |  | 334364 |  | 349931 |  | 399559 |  | 1391942
 | Note:  This document should be read in conjunction with the Company's SEC Filings.
 | *Posted as of 01-23-2008
Spreadsheet: 676656d1588918782-to-find-out-company-ranking-issue-rank-model
Sheet: Sheet1

Product | Cost-Company-1 | Cost-Company-2 | Cost-Company-3 | Cost-Company-4 | Lowest Price Wise Company | Tie Company Name | Tie Company Name | Tie Company Name | Tie Company Name | Lowest Cost
A | 100 | 105 | 103 | 110 | Cost-Company-1
B | 120 | 115 | 110 | 118 | Cost-Company-3
C | 125 | 115 | 120 | 112 | Cost-Company-4
D | 130 | 133 | 129 | 129 | Tie-2 | Cost-Company-3 | Cost-Company-4
F | 150 | 155 | 148 | 158 | Cost-Company-3
G | 140 | 138 | 142 | 136 | Cost-Company-4
H | 150 | 149 | 149 | 149 | Tie-3 | Cost-Company-2 | Cost-Company-3 | Cost-Company-4
I | 160 | 157 | 155 | 162 | Cost-Company-3
J | 134 | 142 | 135 | 145 | Cost-Company-1
K | 140 | 132 | 135 | 138 | Cost-Company-2
Spreadsheet: sally_beck__35537__Energy Ops 98-01 headcount
Sheet: New Deals vs Headcount

E N R O N   W H O L E S A L E   S E R V I C E S
Enron Networks - Energy Operations 2001 Plan
Comparison of Transaction Growth in New Deals to Headcount Growth
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Deals
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-09-01 00:00:00 |  | 2000-09-01 00:00:00 |  | Increase |  | % Increase
 |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Operations Headcount
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-09-01 00:00:00 |  | 2000-09-01 00:00:00 |  | Increase |  | % Increase
 |  |  |  |  |  |  |  |  |  |  |  |  | Adj. Plan Headcount | 346 |  | 390
 |  |  |  |  |  |  |  |  |  |  |  |  | Actual Headcount | 346 |  | 393
Spreadsheet: 726776d1617448830-sumifs-function-doesnt-calculate-values-as-expected-accounting-module
Sheet: Reconciliation

RECONCILIATION WORKSHEET
 | Outstanding Withdrawals |  |  |  | Outstanding Deposits
 | Example Check 0001 |  | 50 |  | Example Deposit 10001 |  | 120 |  | You can delete or type over the examples
 | Total A |  |  |  | Total B
 | Enter any payments you made that are not showing on the bank statement |  |  |  | Enter any payments you have received that are not showing on the bank statement
 |  |  | Closing Cash Book Balance |  | enter the closing balance of the last day of the month from this Cashbook
 |  |  | Add: Outstanding Withdrawals (Total A)
 |  |  | Sub-total
 |  |  | Less: Outstanding Deposits (Total B)
 |  |  | Expected Bank Statement Balance
 |  |  | Actual Bank Statement Balance |  | enter the closing balance of last day of month from Bank Statement
 |  |  | Difference |  | This should be 0.00. If not, double check all your entries
 | This worksheet is not linked to any other worksheets
 | Use this worksheet to Reconcile your Cashbook to the Bank Balance each month. When a month is complete, print this out or PDF it before re-entering data for the next month.
 | You only have to use this reconciliation if you issue or receive checks/cheques or cash that take a few days to show up on the bank account.
Spreadsheet: 55680d1255818308-add-number-to-column-column_sum_replace
Sheet: Sheet1

 |  |  | Answers should be the following | but result should be appeared in C column
cab | 1 | 0.193171429 | 0.194171429
bar | 1 | 0.193171429 | 0.194171429
point | 1 | 0.236971429
rear | 1 | 0.236971429
[NAME] | 1 | 0.013271429
enzyme | 1 | 0.119471429
wan | 1 | 0.125671429
pir | 1 | 0.125671429
[NAME] | 1 | 0.121271429
dfhk | 1 | 0.121271429
asdk | 1 | 0.121271429
mkjy | 1 | 0.125671429
njty | 1 | 0.125971429 |  | A function or something to Add 0.001 with all rows of
bgp | 1 | 0.125971429 |  | column C  and replace colum C with the results
klo | 1 | 0.125971429
vyn | 1 | 0.125971429
pit | 1 | 0.125971429
bite | 1 | 0.125971429
ron | 1 | 0.125971429
son | 1 | 0.125671429
mon | 1 | 0.125971429
[NAME] | 1 | 0.125671429
con | 1 | 0.121271429
pro | 1 | 0.125671429
Spreadsheet: 91287d1291056945-excel-2007-copy-from-one-sheet-to-another-if-a-condition-is-met-copy-of-admin-budget-revised2
Sheet: Pivot

Expense Field | (All)
Purchaser | (All)
 | Values
Row Labels | Sum of Subtotal | Sum of GST | Sum of PST | Sum of HST | Sum of Total
2010-06-01 00:00:00 | 124.69 | 0.12 | 0.66 | 5.6364 | 135.2064
[NAME] | 19.99 | 0 | 0 | 2.3988 | 22.3888
Groceries | 47.39 | 0.12 | 0 | 0 | 47.51
[NAME] | 26.98 | 0 | 0 | 3.2376 | 33.4576
Postage Stamps | 30.33 | 0 | 0.66 | 0 | 31.85
2010-07-01 00:00:00 | 19.93 | 0 | 0 | 0 | 19.93
Groceries | 19.93 | 0 | 0 | 0 | 19.93
2010-08-01 00:00:00 | 442.6299999999999 | 0 | 0 | 52.3488 | 519.9788
5-Port Switch | 39.15 | 0 | 0 | 4.698 | 43.848
Groceries | 13.93 | 0 | 0 | 0 | 13.93
Headset | 86 | 0 | 0 | 10.32 | 96.32
Headset Connect Cord | 96 | 0 | 0 | 11.52 | 107.52
Headset tools | 15.1 | 0 | 0 | 2.772 | 25.872
Monitor | 129.99 | 0 | 0 | 16.6788 | 155.6688
Postage Stamps | 17.46 | 0 | 0 | 0 | 17.46
Training Cable | 45 | 0 | 0 | 6.359999999999999 | 59.36
Grand Total | 587.2500000000001 | 0.12 | 0.66 | 57.98519999999999 | 675.1152000000001
Spreadsheet: 108671d1305686695-excel-2007-sumproduct-question-sumproduct
Sheet: FEB

ID | Bought | Sold | % Sold
8178541110001 | 65 | 20
3531670110003 | 49 | 40
7855760111824 | 81 | 32
8262480013000 | 41 | 31
8385850010003 | 34 | 25
7009790210003 | 97 | 25
7286200510003 | 55 | 24
9163830010002 | 33 | 21
9989450210000 | 34 | 17
Spreadsheet: 77070d1277501389-tracking-hours-from-employee-calendar-master-schedule
Sheet: Lists

 | Names |  | Time
 | [NAME] |  | 08:30:00
 | [NAME] |  | 08:45:00
 | Carmen Peterson |  | 09:00:00
 | [NAME] |  | 09:15:00
 | [NAME] |  | 09:30:00
 | [NAME] |  | 09:45:00
 | [NAME] |  | 10:00:00
 | [NAME] |  | 10:15:00
 | [NAME] |  | 10:30:00
 | [NAME] |  | 10:45:00
 | [NAME] |  | 11:00:00
 | [NAME] |  | 11:15:00
 |  |  | 11:30:00
 |  |  | 11:45:00
 |  |  | 12:00:00
 |  |  | 12:15:00
 |  |  | 12:30:00
 |  |  | 12:45:00
 |  |  | 13:00:00
 |  |  | 13:15:00
 |  |  | 13:30:00
 |  |  | 13:45:00
 |  |  | 14:00:00
 |  |  | 14:15:00
 |  |  | 14:30:00
 |  |  | 14:45:00
 |  |  | 15:00:00
 |  |  | 15:15:00
 |  |  | 15:30:00
 |  |  | 15:45:00
 |  |  | 16:00:00
 |  |  | 16:15:00
 |  |  | 16:30:00
 |  |  | 16:45:00
 |  |  | 17:00:00
 |  |  | 17:15:00
 |  |  | 17:30:00
 |  |  | 17:45:00
 |  |  | 18:00:00
 |  |  | 18:15:00
 |  |  | 18:30:00
 |  |  | 18:45:00
 |  |  | 19:00:00
 |  |  | 19:15:00
 |  |  | 19:30:00
 |  |  | 19:45:00
 |  |  | 20:00:00
 |  |  | 20:15:00
 |  |  | 20:30:00
 |  |  | 20:45:00
 |  |  | 21:00:00
 |  |  | 21:15:00
Spreadsheet: 376450d1423601002-relating-merged-cells-to-others-in-a-row-example-databse
Sheet: Sheet1

Description |  |  |  |  |  | General Features
Store | Brand | Model | Year | Model # | Price | Case |  | Monitor |  | Speakers |  | [NAME]
Newfish | Acier | Titanium | 2015 | ZX44-1 | 230 | Plastic-Graphics | H:900[NAME] | Metal-Chrome | [NAME] | Metal-Graphics | [NAME] | Plastic-Paint | [NAME]
 |  |  |  |  |  |  | W:700[NAME] |  | W:800[NAME] |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  | H: | Plastic-Paint | H:750[NAME] |  | H: |  | H:
 |  |  |  |  |  |  | W: |  | W:900mm |  | W: |  | W:
Tiger Indirect | Packyrd | Gamer | 2015 | FDD5 | 450 | Metal-Paint | [NAME] | Plastic-Clear | H:660[NAME] | Metal-Graphics | H:89mm | Metal-Paint | [NAME]
 |  |  |  |  |  |  | [NAME] |  | W:678mm |  | W:70mm |  | [NAME]
 |  |  |  |  |  | Metal-Paint | [NAME] |  | H: |  | H: |  | H:
 |  |  |  |  |  |  | W:500[NAME] |  | W: |  | W: |  | W:
BestNot | IBW | Business | 2014 | R76 | 700 | Plastic-Graphics | H:545mm | Metal-Graphics | [NAME] | Metal-Paint | [NAME] | Plastic-Paint | H:150mm
 |  |  |  |  |  |  | [NAME] |  | W:878mm |  | [NAME] |  | W:75[NAME]
 |  |  |  |  |  | Plastic-Paint | H:878mm | Metal-Paint | [NAME] | Plastic-Graphics | [NAME] |  | H:
 |  |  |  |  |  |  | W:900mm |  | [NAME] |  | W:79mm |  | W:
Costmuch | ASUZ | ExtremeX | 2014 | B52 | 560 | Metal-Graphics | [NAME] | Plastic-Graphics | [NAME] | Plastic-Graphics | [NAME] | Plastic-Paint | H:50mm
 |  |  |  |  |  |  | W:800[NAME] |  | W:700[NAME] |  | W:25mm |  | [NAME]
 |  |  |  |  |  |  | H: |  | H: |  | H: |  | H:
 |  |  |  |  |  |  | W: |  | W: |  | W: |  | W:
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: Sheet1

Osnova fakture | IME NARUCIOCA | ADRESA | TELEFON | DEO GRADA | DAN | ZELJENO VREME DOSTAVE | PLANIRANO VREME DOSTAVE | BROJ TURE | REDOSLED DOSTAVLJANJA | [NAME] I OSTALE BELESKE | [NAME] | UKUPNO NARUCENO KROFNI | VANILA | MALINA | VISNJA | KAFA | MINT | BELA COKOLADA | MLECNA BADEM | [NAME]
 | 12
Broj | IME NARUCIOCA
2 | [NAME] | [NAME] 46, 11000 Novi Beograd | 63440455 | NOVI [NAME] | petak | 13:30:00 |  | 1900-01-03 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 1 |  | 1 | 1 | 1
Spreadsheet: 38290d1236379687-lookup-formula-example31
Sheet: Cat

KITTEN | Rank |  |  |  |  |  |  |  | sort ascending |  |  | sort ascending
Furry | 1 | 1 | Furry | 1 | 5 | Dopey |  |  | 1 | Furry |  | sort descending
Spaz | 3 | 2 | Fuzzy | 3 | 4 | [NAME] |  |  | 2 | Fuzzy
Fuzzy | 2 | 3 | Spaz | 2 | 3 | Spaz |  |  | 3 | Spaz
Dopey | 5 | 4 | [NAME] | 5 | 2 | Fuzzy |  |  | 4 | [NAME]
[NAME] | 4 | 5 | Dopey | 4 | 1 | Furry |  |  | 5 | Dopey
 |  |  |  |  |  |  |  |  | #N/A
 |  | above uses row() to number cells |  |  |  | above is order entered manually |  |  | #N/A | or just use small/large
 |  |  |  |  |  |  |  |  | #N/A | and use validation to toggle(J1)
 |  |  |  |  |  |  |  |  | #N/A | validation list in M1,M2
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 708279d1607701881-help-to-maybe-use-vlookup-to-quickly-copy-prices-from-table-b-to-a-sample-1-
Sheet: b

Customer P/N | SUPPLIERP/N | SEL-PRICE |  |  | duplicate check
1 | EMK105B7104KVHF | 1
2 | EMK107B7474KAHT | 3
3 | HMJ212BB7223KGHT | 4
4 | HMJ316BB7224KLHT | 9
5 | HMJ325KC7475KMHPE | 10
6 | HMK107B7223KAHT | 11
7 | HMK212B7104KGHT | 12
8 | HMK212BC7105KGHTE | 13
9 | [NAME] | 14
10 | TMJ316BB7106KLHT | 15
11 | TMK105B7103KVHF | 16
12 | TMK107AB7105KAHT | 28
13 | TMK212B7225KGHT | 2
14 | UMJ325KB7106KMHP | 3
15 | UMK105B7102KVHF | 1
16 | UMK105B7103KVHF | 5
17 | UMK105B7104KVHF | 6
18 | UMK105B7222KVHF | 8
19 | UMK105B7223KVHF | 3
20 | UMK105B7473KVHF | 9
21 | UMK105B7682KVHF | 8
22 | UMK105CG101JVHF | 9
23 | UMK105CG220JVHF | 0
24 | UMK105CG221JVHF | 2
25 | UMK105CG271JVHF | 5
26 | UMK105CG471JVHF | 7
27 | UMK107B7103KAHT | 9
28 | UMK107C7224KAHTE | 6