tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81771d1281947230-formulae-for-cell-to-merge-after-conditional-formatting-draft
Sheet: Sheet1

 |  |  |  |  | 2010-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-26 00:00:00
 |  |  |  |  |  |  |  |  | M | O | N | D | A | Y | 23/8 |  |  |  |  |  |  |  |  |  |  |  |  |  | T | U | E | S | D | A | Y | 24/8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | E | D | N | E | S | D | A | Y | 25/8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | H | U | R | S | D | A | Y | 26/8
 | ET | ET |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | PDT | PDT |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
DR Application Timeline | SGT | SGT |  |  |  |  |  |  | M | O | N | D | A | Y | 23/8 |  | T | U | E | S | D | A | Y | 24/8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | E | D | N | E | S | D | A | Y | 25/8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | H | U | R | S | D | A | Y | 26/8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | R | I | D | A | Y | 27/8
TASK | START(ET) | END(ET) | Rounded off | Rounded off |  |  |  |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | DURATION TAKEN
Draft timing one | 2010-08-23 05:15:00 | 2010-08-24 11:30:00 | 2010-08-23 05:00:00 | 2010-08-24 12:00:00
Draft timing two | 2010-08-24 06:29:00 | 2010-08-25 07:30:00 | 2010-08-24 06:00:00 | 2010-08-25 08:00:00
Draft timing three | 2010-08-24 07:58:00 | 2010-08-26 08:30:00 | 2010-08-24 08:00:00 | 2010-08-26 09:00:00
Spreadsheet: 230373d1366743587-return-multiple-values-from-multiple-sheets-example
Sheet: MAY

EQUIPMENT | DATE | TEMP | BEGIN PSIG | END PSIG | VALVE | ACTIVITY | MCF LOSS | BBLS H20
COMPRESSOR #1 | 2013-05-02 00:00:00 | 98 | 1005 | 0 | N/A | BLOWDOWN | 15.25 | 0
COMPRESSOR #1 | 2013-05-05 00:00:00 | 95 | 1004 | 550 | N/A | BLOWDOWN | 8.25 | 0
COMPRESSOR #5 | 2013-05-08 00:00:00 | 91 | 996 | 0 | N/A | BLOWDOWN | 15 | 0
COMPRESSOR #5 | 2013-05-09 00:00:00 | 94 | 1001 | 600 | N/A | BLOWDOWN | 6 | 0
COMPRESSOR #5 | 2013-05-18 00:00:00 | 93 | 1000 | 0 | N/A | BLOWDOWN | 15.5 | 0
DEHY CONTACTOR | 2013-05-24 00:00:00 | 92 | 1002 | 0 | N/A | BLOWDOWN | 6.25 | 0
Spreadsheet: 167920d1342158028-excel-2007-calculation-of-multiple-cells-dependant-on-data-weekly-loading-allocation
Sheet: Weekly Loading Schedule WE 2707

 | Weekly Loading Schedule WE 27th July
 | R/T Drivers In Town | Load Allocation |  | Departing |  | Weeks Loading | Customer | Cartons | Destination | Trailers | Loaded By | Allocation | Notes
 |  |  |  |  |  |  |  | 1344 | Pth
 |  |  |  |  |  |  |  | 1344 | Pth
 |  |  |  |  |  |  |  | 2040 | Ade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pth | Melb | Ade | Syd | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Quanties
 |  | 66666 B - Doubles 66666 |  |  |  |  |  |  |  |  |  |  | Confirmed Loading
Spreadsheet: 789490d1659118370-find-the-sum-of-large-4-numbers-from-5-different-cell-values-large-function
Sheet: Sheet1

Name | English |  |  | Math |  |  | Science |  |  | History |  |  | Geography
 | Theory | Practical | Total | Theory | Practical | Total | Theory | Practical | Total | Theory | Practical | Total | Theory | Practical | Total
[NAME] | 61 | 15 |  | 51 | 12 |  | 71 | 11 |  | 82 | 20 |  | 56 | 15
 |  |  |  | Total of Best 4 Subjects =
The result comes wrong. Since the best 4 numbers are 102, 82, 76 & 71 and their total is 331. But as the range is used the result comes different. What formula can get me the total of best four numbers considering only the Total column for each subject.
Spreadsheet: 80903d1281043559-linking-data-from-one-sheet-to-another-client-invoice-blank
Sheet: Orders

Date | Customer Name | Method Of Payment | Supplier | [NAME] | Wig Number | Wig Color | Quantity | Cost Of Wig | Shipping | Balance Due
2010-08-05 00:00:00 | Test Customer | Credit Card | Widgets+ | Wig Ultra 9000 | 1231a | Teal | 1 | 99.97 | 25 | 9999
2010-08-05 00:00:00 | Test Customer |  | Widgets+ | Wig Ultra 9000 | 1231a | Fucia | 1 | 99.97
2010-08-05 00:00:00 | Test Customer |  | Widgets+ | Wig Ultra 9000 | 1231a | Eggplant | 1 | 99.97
2010-08-05 00:00:00 | Test Customer |  | Widgets+ | Wig Ultra 9000 | 1231a | Sea Foam | 1 | 99.97
Spreadsheet: 856357d1705613059-need-formula-to-determine-percentile-of-a-number-when-compared-to-a-group-of-numbers-sample2
Sheet: Sheet1

Outside Survey Pay for Position at other Facilities |  |  |  |  |  |  | Current Supervisor Name | Current Salary | Percentile of salary within outside survey
Percentile Rank |  |  |  |  |  |  | [NAME] | 78801.76
0.1 | 0.25 | 0.5 | 0.75 | 0.9 |  |  | [NAME] | 74611.94
56967 | 65105 | 74044 | 83581 | 92263 |  |  | [NAME] | 69930.12
 |  |  |  |  |  |  | [NAME] | 72720.7
Spreadsheet: barry_tycholiz__890__Customer List-info needed
Sheet: Industrials

 | Industrial | CP ID | [NAME]? Alternates? | CP ID | Who's Customer
96 | Cenex Refinery | See list | Cenex, Inc.
 |  |  | Cenex Harvest  States Cooperatives |  | Lucci
97 | KERR-MCGEE CHEMICAL CORP | See list | Kerr-McGee Corporation
 |  |  | Kerr-McGee Natural Gas, Inc.
 |  |  | Kerr-McGee Oil & Gas Corporation
 |  |  | Kerr-McGee Oil & Gas Onshore LP
 |  |  | Kerr-McGee Refining Corporation
98 | DIAMOND SHAMROCK | See list | Diamond Shamrock Offshore Partners Limited Partnership
 |  |  | Diamond Shamrock Refining & Marketing Company
 |  |  | Diamond Shamrock Refining Company LP
 |  |  | [NAME]
99 | KAISER ALUMINUM & CHEM CORP | See list | ICF Kaiser International Inc.
 |  |  | Kaiser Aluminum & Chemical Corporation
 |  |  | Kaiser Aluminum International
 |  |  | Kaiser Aluminum Corporation
100 | Mobil Oil Corp. | See list | Mobil Oil Canada
 |  |  | Mobil Oil Company Ltd.
 |  |  | Mobil Oil Corporation
 |  |  | Mobil Oil Corporation - Supply & Distribution
 |  |  | Mobil Oil Corporation - Beaumont Refinery
101 | OWENS - BROCKWAY | See list | Owens-Brockway Glass Container, Inc.
 |  |  | Owens-Brockway Packaging, Inc.
102 | PRAXAIR | See list | Praxair, Inc.
 |  |  | Praxair Argentina S.A.
 |  |  | [NAME], S.L.
 |  |  | Praxair Produccion [NAME], S.L.
103 | C & H SUGAR CO | [NAME] | California & Hawaiian Sugar Company? | 54991
104 | CEVRON PRODUCTS CO | [NAME] | Chevron Products Company? | 65255
105 | GOLDEN BEAR OIL | [NAME] | Golden Bear Oil Specialties, Inc.? | 66912
106 | HAYES WHEELS INTRNTNL-CALIFORN | [NAME] | Hayes Wheels International Inc.? | 4258
107 | HUNTWAY PARTNERS LP | [NAME] | Huntway Refining Company? | 63463
108 | INLAND EMPIRE PAPER CO | [NAME] | Inland Empire Distri.? | 89544
109 | MCCAIN FOODS INC | [NAME] | McCain Foods USA, Inc.? | 78161
110 | MOBIL OIL REFINERY | [NAME] | Mobil Oil Corporation - Beaumont Refinery? | 45911
111 | Montana Resources | [NAME] | Montana Resources Inc.? | 5554
112 | NESTLE FOOD CO | [NAME] | Nestle Foods Corporation? | 37016
113 | PACIFIC COAST BUILDING PDTS | [NAME] | Pacific Coast Producers Inc? | 93729
114 | SMURFIT NEWSPRINT CORP | [NAME] | Smurfit Newsprint Corporation of California Inc.? | 5656
 |  |  | Chevron Products Company, a division of Chevron USA, Inc.? | 58956
Spreadsheet: 824159d1680343217-calculating-an-amount-to-withhold-from-paycheck-deduction-calculator-1-
Sheet: Sheet1

The rates of Shortages applicable are as follows:
RATES OF NORMAL SHORTAGES FOR INDIVIDUALS
Exceeds | Does not exceed
Shortages |  | Fixed Deduction | Rate on Excess | Rates
 |  |  |  |  |  |  | Verify |  |  | Shortage | Deduction
0 | 200 | 200 | 0 | E200 + 0% of the excess of 0 |  |  | 0 |  |  | 500
200 | 250 | 200 | 0.09 | E200 + 0% of the excess of 200
250 | 300 | 200 | 0.08 | E200 + 0% of the excess of 250
300 | 350 | 200 | 0.07 | E200 + 0% of the excess of 300
350 | 400 | 200 | 0.06 | E200 + 0% of the excess of 350
400 | 450 | 200 | 0.05 | E200 + 0% of the excess of 400
450 | 500 | 200 | 0.04 | E200 + 0% of the excess of 450
500 | 550 | 200 | 0.03 | E200 + 0% of the excess of 500
550 |  | 200 | 0.02 | E200 + 0% of the excess of 550
Examples
Shortage | Deduction Calculator
 | Fixed Deduction per Table | Excess | Rate on excess |  | Expected Deduction
200 |  |  | 0 |  | 200
250 | 200 | 50 | 0.09
350 | 200 | 150 | 0.06
450 | 200 | 250 | 0.04
 | 200 | excess of 200 | 0.02
Spreadsheet: 115205d1310802068-excel-2007-calendar-reminder-questions
Sheet: Calendar

 |  |  | 2011-07-16 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  |  |  |  |  |  |  |  | This date should have another message aside from number "1" because in VL tab there's a match date for this box same on July 20.
 |  |  |  |  |  |  |  |  |  | if today is the day, it will highlight this as red. I know it should be on conditional formatting but i'm having a hard time doing it.
 |  |  |  |  | not(iserror(match(c9,mydates,0))
Spreadsheet: 734577d1622242929-split-breakdown-time-between-shifts-split-time-between-shifts-over-multiple-days-krzysiekpirat-
Sheet: Breakdown Log

Date | Time | Malfunction Time - Hrs |  |  |  | Date | A (6-14) | B (14-22) | C(22-6)
2021-05-20 00:00:00 | 11:45:00 | 75 |  |  |  | 2021-05-20 00:00:00 | 2.25 | 12,5(8+4,5) | 11(8+3)
2021-05-20 00:00:00 | 17:30:00 | 7 |  |  |  | 2021-05-21 00:00:00 | 8 | 8 | 10(8+2)
2021-05-21 00:00:00 | 03:00:00 | 2 |  |  |  | 2021-05-22 00:00:00 | 8 | 15(8+7) | 16(8+8)
2021-05-22 00:00:00 | 15:00:00 | 17 |  |  |  | 2021-05-23 00:00:00 | 10(8+2) | 0.75
Spreadsheet: 128606d1321096576-listing-items-without-empty-cells-showauctionreturnsbybuyerandseller
Sheet: Auction

Buyer | [NAME] | Item | Price | Quantity | Total
Buyer1 | Seller11 | knife | 5 | 1
Buyer2 | Seller11 | knife | 5 | 1
Buyer3 | Seller11 | knife | 5 | 1
Buyer1 | Seller12 | towels | 3 | 2
Buyer2 | Seller12 | towels | 3 | 1
Buyer3 | Seller12 | towels | 3 | 1
Buyer1 | Seller13 | candy | 1 | 5
Buyer2 | Seller13 | candy | 1 | 7
Buyer3 | Seller13 | candy | 1 | 3
Buyer1 | Seller11 | toy | 6 | 2
Buyer2 | Seller11 | toy | 6 | 1
Buyer3 | Seller11 | toy | 6 | 1
Buyer1 | Seller12 | lamp | 12 | 2
Buyer2 | Seller12 | lamp | 12 | 2
Buyer3 | Seller12 | lamp | 12 | 2
Buyer1 | Seller13 | lighter | 0.5 | 5
Buyer2 | Seller13 | lighter | 0.5 | 3
Buyer3 | Seller13 | lighter | 0.5 | 1
Spreadsheet: 551233d1512774931-concatenate-random-text-from-a-column-07_12_2017-table-sample-excel-2003-update
Sheet: draft

Row | Data | CAT I- | CAT II- | CAT III- | CAT IV- | CAT V-
Spreadsheet: 0d7be4a9-f3c7-4827-bc00-bf7b24a40b8d
Sheet: Sheet1

Titles discussed by [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Title | Author | ISBN | Publisher | Price | Format
The Galton Case | [NAME] | 9780679768647 | Knopf/Vintage | 13.95 | paperback
Five Roundabouts to Heaven | [NAME] | 9781416540441 | Simon & Schuster | 13 | paperback
The Deep Blue Good-By | [NAME] | 9780449223833 | Random/Fawcett | 7.99 | mass market
Side-Swipe | [NAME] | 9781400032488 | Knopf/Vintage | 12 | paperback
A Slight Trick of the Mind | [NAME] | 9781400078226 | Knopf/Anchor | 13.95 | paperback
The Suspect | [NAME] | 9781934609071 | Felony & Mayhem | 14.95 | paperback
In a Lonely Place | [NAME] | 9781558614550 | Feminist Press | 14.95 | paperback
[NAME]/Miasma | [NAME] Holding | 9780966784879 | [NAME] | 19.95 | paperback
Nine Coaches Waiting | [NAME] | 9781556526183 | Chicago Review | 14.95 | paperback
When Last I Died | [NAME] | 9780915230853 | [NAME] | 14.95 | paperback
That Awful Mess on the Via Merulana | [NAME] | 9781590172223 | NYRB Classics | 16.95 | paperback
The Deadly Percheron | [NAME] | 9781933618104 | Cocytus/Millipede | 15 | paperback
The Riddle of the Traveling Skull | [NAME] | 9781932416268 | [NAME]'s | 18 | hardcover
By Reason of Insanity | Shane Stevens | 9781556526626 | Chicago Review | 14.95 | paperback
I Was Dora Suarez | [NAME] | 9781852427993 | Serpent's Tail | 14.95 | paperback
Nightmare Alley | [NAME] | 9781590173480 | NYRB Classics | 14.95 | paperback
The True Detective | [NAME] | 9780380704996 | HarperCollins | 4.5 | mass market
The Friends of Eddie Coyle | [NAME] | 9780312429690 | Picador | 14 | paperback
The [NAME] in Town Are on Our Side | [NAME] | 9780312315825 | St. Martin's/Griffin | 15.95 | paperback
Spreadsheet: 485022d1476650645-sum-an-index-cross-sum
Sheet: Sheet1

 | RANDOM TEXT WOOP WOOP
 | Agent  1132 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 21h26
 | [NAME] Received |  | 43 |  | Total Queue Call Time |  |  | 02h36
 | Direct Calls received |  | 5 |  | Total Direct Call Time |  |  | 01:59
 | Outbound Calls Made |  | 139 |  | Total Outbound Call Time |  |  | 02h46
 | Internal Calls Made |  | 0 |  | Total Internal Call Time |  |  | 00:00
 | Agent  1132 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 21h26
 | [NAME] Received |  | 67 |  | Total Queue Call Time |  |  | 02h36
 | Direct Calls received |  | 5 |  | Total Direct Call Time |  |  | 01:59
 | Outbound Calls Made |  | 139 |  | Total Outbound Call Time |  |  | 02h46
 | Agent  1177 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 34h10
 | [NAME] Received |  | 68 |  | Total Queue Call Time |  |  | 10h00
 | Direct Calls received |  | 11 |  | Total Direct Call Time |  |  | 03:04
 | Outbound Calls Made |  | 199 |  | Total Outbound Call Time |  |  | 07h05
 | Agent  1177 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 34h10
 | [NAME] Received |  | 32 |  | Total Queue Call Time |  |  | 10h00
 | Direct Calls received |  | 11 |  | Total Direct Call Time |  |  | 03:04
 | Outbound Calls Made |  | 199 |  | Total Outbound Call Time |  |  | 07h05
Spreadsheet: 863224d1710787461-join-data-as-a-spilled-array-based-on-criteria-optimize-formula-02
Sheet: WIP

 | ID | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z |  |  | column | range |  |  | Unique Outcome
 | 1 | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  | g,i | 6
 | 2 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  | h,i | 4
 | 3 | 13 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2 |  |  | d,e,f | 6
 | 4 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  | d,e,g | 1
 | 5 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0 |  |  | d,e,h | 7
 | 6 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  | d,g,h | 1
 | 7 | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  | d,g,i | 1
 | 8 | 18 | 7 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  | d,e,g,i | 30
 | 9 | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2 |  |  | e,f,g | 3
 | 10 | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2 |  |  | e,f,h | 3
 | 11 | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22 |  |  | e,f,i | 3
 | 12 | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2 |  |  | e,g,h | 3
 | 13 | 20 | 1 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22 |  |  | e,g,i | 3
 | 14 | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22 |  |  | e,h,i | 3
 | 15 | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2 |  |  | f,g,h | 8
 | 16 | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0 |  |  | f,g,i | 8
 | 17 | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0 |  |  | f,h,i | 8
 | 18 | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0 |  |  | g,h,i | 8
 | 19 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0 |  |  | d,e,f,g | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 25
Spreadsheet: 2289e13c-3b1c-4ebc-983a-1b1990eeaee3
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 | E.1(1) | 1 | 1 |  |  | Ott | Nov | Dic | [NAME] | Feb | Mar | Apr | Mag | Giu | [NAME] | Ago | Set
 | E.1(2) | 2 |  |  | Zona D | 26 | 20 | 20 | 20 | 20 | 20 | 20 | 26 | 26 | 26 | 26 | 26
 | E.1(3) | 3 |  |  | Zona E, F | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 26 | 26 | 26 | 26 | 26
 | E.2 | 4
 | E.3 | 5
 | [NAME]) | 6
 | E.4(2) | 7
 | E.4(3) | 8
 | E.5 | 9
 | E.6(1) | 10
 | E.6(2) | 11
 | E.6(3) | 12
 | E.7 | 13
 | E.8 | 14
 | N
 | NE
 | NO
 | E
 | O
 | SE
 | SO
 | S
 | H
 | [NAME]
 | Ambiente riscaldato [NAME]
 | Ventilazione naturale
 | Ventilazione meccanica semplice flusso senza pre-riscaldamento
 | Ventilazione meccanica semplice flusso con pre-riscaldamento
 | Ventilazione meccanica doppio flusso senza pre-riscaldamento e senza recuperatore
 | Ventilazione meccanica doppio flusso con pre-riscaldamento e senza recuperatore
 | Ventilazione meccanica doppio flusso senza pre-riscaldamento e con recuperatore
 | assenti
 | presenti
 | [NAME]
 | Interno con intercapedina ventilata
 | Integrato con intercapedine non ventilata
 | Fisse
 | Orientabili
Spreadsheet: 91492d1291219341-excel-2007-find-and-copy-rows-and-stop-when-data-changes-sample-data
Sheet: Ext LR & HRS

1 - Breakdown | 39 | 47 | 184.7 | -0.15 | 184.7 | 16.81536780772032 | 16424.6385 | 88.92603410936654 | 0 | 11770.5019 | 71.66368927998019 | 63.72767677314564 | 28195.1404
10126600 | 94 | 1 | 7.5 | 0 | 7.5 | 0.6828113619810634 | 705 | 94 | 0 | 521.71 | 74.00141843971633 | 69.56133333333334 | 1226.71
26837800 | 94 | 8 | 25 | 0 | 25 | 2.276037873270211 | 2350 | 94 | 0 | 1107.48 | 47.12680851063829 | 44.2992 | 3457.48
2872501 | 98.1 | 1 | 0.2 | 0.1 | 0.2 | 0.01820830298616169 | 29.43 | 147.15 | 0 | 6.9 | 23.44546381243629 | 34.5 | 36.33
28772466 | 98.1 | 1 | 5.5 | 0 | 5.5 | 0.5007283321194465 | 539.5499000000001 | 98.09998181818185 | 0 | 24.6599 | 4.570457709286943 | 4.483618181818182 | 564.2098000000001
28772602 | 98.1 | 1 | 3.8 | 0 | 3.8 | 0.3459577567370722 | 372.78 | 98.1 | 0 | 0 | 0 | 0 | 372.78
3 - Repair  Field | 72 | 79 | 174.6 | 0.05 | 179.2 | 16.31463947560087 | 16195.9549 | 90.37921261160714 | 0 | 38041.41 | 234.8821680159161 | 212.2846540178572 | 54237.3649
10090173 | 109 | 1 | 11 | 0 | 11 | 1.001456664238893 | 1034 | 94 | 0 | 0 | 0 | 0 | 1034
11589000 | 94 | 2 | 5.5 | 0 | 5.5 | 0.5007283321194465 | 517 | 94 | 0 | 347.15 | 67.14700193423597 | 63.11818181818182 | 864.15
125 | 94 | 3 | 16.5 | 0 | 16.5 | 1.50218499635834 | 1551 | 94 | 0 | 538.05 | 34.69052224371373 | 32.60909090909091 | 2089.05
26837800 | 94 | 5 | 25.5 | 0 | 21.5 | 1.957392571012381 | 2397 | 111.4883720930233 | 0 | 2139.7 | 89.26574885273257 | 99.52093023255814 | 4536.7
2872501 | 98.1 | 1 | -0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: MathSciNet

MathSciNet
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | Price for 2004-2005 | Price per search
TOTAL
Sessions | 178 | 40 | 167 | 263 | 341 | 255 | 126 | 268 | 428 | 514 | 207 | 284
Searches | 351 | 174 | 373 | 519 | 1191 | 424 | 237 | 539 | 759 | 775 | 406 | 481 |  | 6686
Spreadsheet: 372470d1422030378-curve-chart-help-book2
Sheet: Sheet1

Years | Revenue (Millions) | Costs (Millions)
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Spreadsheet: 02c66b6a-39d9-4496-a3c8-fe4469e5b1ee
Sheet: K-5

MENU - K-5
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No |  |  | Decimal Equivalents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/8 Cup | 0.125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4 Cup | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/8 Cup | 0.375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/3 Cup | 0.333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/2 Cup | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/8 Cup | 0.625
 |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  |  |  |  | 2/3 Cup | 0.666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/4 Cup | 0.75
Mt/MA (1 oz eq per day)  (8-10 oz eq per week) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7/8 Cup | 0.875
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  |  |  | 1 Cup | 1
Vegetables (3/4 Cup per day) (3 3/4 Cup per week)
[NAME]  (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Red/Orange  (3/4 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Beans/Peas (Legumes) (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Starchy (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Other  (1/2 per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Daily total
Do you need additional vegetable(s) to reach [NAME] (1 Cup per week)?
Grains (1 oz eq day) (8-9 oz eq per week)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Fruits (1/2 Cup per day) (2 1/2 cups per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
[NAME] (1 Cup per day)  (5 a week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Spreadsheet: 867530d1714388001-using-array-formula-and-relative-referencing-most-efficiently-sample-data
Sheet: Example

 |  |  |  |  |  |  |  | Comment
 |  | OrderNo | Order qnty | Variable quantity | Difference |  |  | Column to use in formula calculation
 |  |  |  | 501 |  |  |  | E4
 |  | 3233322 | 34343 | 432 | 34343 | 34343 |  | E5
 |  | 432343 | 2323 | 42222 | 2323 | 42222 |  | E6
 |  | 4323423 | 233 | 443332 | 501 | 443332 |  | E7
 |  | 123123 | 33 | 25 | 501 | 33 |  | E8
 |  | 123123 | 34 | 35 | 501 | 35 |  | E9