tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5548__HPLN1031
Sheet: Sheet1

HPLN1031.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 31, 2000
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-10-31 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine Meter |  | HPL | 22.5 | 22.5
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 63640d1264534370-lookup-with-multiple-criteria-sumproduct-error-premium-sample
Sheet: Premium Calculation Worksheet

Premium Calculation Worksheet
EE# | Last Name | First Name | Address 1 | Address 2 | City | Province | Postal Code | Status | Leave  Type | [NAME] | [NAME] than Monthly Premium? | As of (Date) | Monthly Accruals | H&D
1234 | Smith | [NAME] | Address 1 |  | Toronto | ON | X1X 1X1 | FULL | N/A | 400 | #N/A | 2010-01-26 00:00:00 | 0
Spreadsheet: 62584d1263497372-filtering-linked-values-attendancesample
Sheet: Sheet1

KEY GUIDE
"V" = Vacation (new)
"S" = Sick
"HS" = Home Sick
"P" = Personal
"HP" = Home Personal
"B" = Bereavement
"J" = Jury Duty
"D" = Short Term Dis or [NAME], etc.
 | JANUARY
Analyst/Specialist/Other | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 2010-01-23 00:00:00 | 2010-01-24 00:00:00 | 2010-01-25 00:00:00 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 2010-01-28 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-01-31 00:00:00
Employee A
Employee B
Employee C
Employee D
Employee E
Spreadsheet: 116488d1311865277-vlookup-with-if-function-example1
Sheet: Sheet1

1 | 2 | 1
1 | 4 | 2
1 | 5 | 3
0 | 6 | 4
0 | 9 | 5
0 | 11 | 13
0 |  | 14
0 |  | 15
0 |  | 16
0 |  | 17 |  | Ineed the cell in colume A to have a "1" them when the value in column B is somehere in the entire array C.
0 |  | 18
0 |  | 19
0 |  | 20
Spreadsheet: 195046d1353407858-div-0-error-diverror
Sheet: Total Htls Combined

 | 2012-01-01 00:00:00
Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40
Month
Calls Received
Spreadsheet: 025f689c-36bc-4a02-b352-3633394410cc
Sheet: # Current Serials

[NAME] vs. [NAME]
Current Serial Subscriptions
 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | % Change
Peer Average
Peer Median
University of Rhode Island | 31892 | 20079 | 31443 | 38795 | 24392
[NAME] University | 27930 | 45551 | 66766 | 69418 | 52277
Montana State University - Bozeman | 51555 | 60794 | U/A | U/A | 15089
North Dakota State University - Main Campus | 18229 | 16300 | U/A | 36546 | U/A | U/A
University of Maine | 21449 | 7004 | 58300 | 68162 | 17480
University of New Hampshire - Main Campus | 36546 | U/A | 59398 | 54507 | 37413
University of Vermont and State Ag. Coll. | U/A | 18892 | U/A | 35665 | 50866 | U/A
University of Wyoming | 38928 | 37599 | 15756 | 68221 | 72617
Source: ACRLMetrics
Revised: October 24, 2011, ajr
Spreadsheet: 201157d1355888945-how-this-excel-grab-the-share-information-revenuegrowth-2-
Sheet: 主表

股票代號 | 2330
營收年成長率
盈餘年成長率
最近年度 | m | b | 成長率(月) | 成長率(年) | m | b | 成長率(季) | 成長率(年)
1年 |  | 30187672.76231707 |  |  |  | 26414259.33241831
3年 |  | 28954567.78002083 |  |  |  | 35140226.24769803
4年 |  | 20409533.81234188 |  |  |  | 13412735.18811706
年度 | 營收年成長率 | 盈餘年成長率 | 權重
1年 |  |  | 0.4
3年 |  |  | 0.3
4年 |  |  | 0.3
日期 | 月營收 | 預估 |  |  | 季度 | 季盈餘
Spreadsheet: 56385d1256584097-excel-2007-sumif-formula-that-averages-weekly-data-monthly-report
Sheet: Week 1

 |  |  |  | WEEK 1
 | Technician |  |  |  | Work Comp % | QC Pass % | CDV/HSI Jobs | Activation Attemtps | [NAME] | VOD Attempts
 | 1 |  |  |  | 0.889 | 0.932 | 8 | 6 | 10 | 9
 | 2 |  |  |  | 0 | 0
 | 3 |  |  |  | 0.8438 | 0.95
 | 4 |  |  |  | 0.9412 | 0.766
 | 5 |  |  |  | 0 | 0
 | 6 |  |  |  | 0.7143 | 0.915
 | 7 |  |  |  | 0.9231 | 1
 | 8 |  |  |  | 0.7778 | 0.95
 | 9 |  |  |  | 1 | 0.945
 | 10 |  |  |  | 0.875 | 1
 | 11 |  |  |  | 0.8462 | 0.93
 | 12 |  |  |  | 0.8621 | 0
 | 13 |  |  |  | 1 | 0
 | 14 |  |  |  | 0.7727 | 0
 | 15 |  |  |  | 0.8947 | 1
 | 16 |  |  |  | 0.8333 | 0
 | 17 |  |  |  | 0 | 0
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 765227d1643214127-time-card-formula-help-bi-weekly-timesheet
Sheet: JENNIFER

Bi-Weekly Time Record
Employee:
Pay ending: | 2022-02-04 00:00:00
Day | Date | Total hours | Sick | Vacation | Holiday | MISC | Regular Hours | Overtime Hours | Notation |  |  | HOURS | GROSS
Saturday |  | 0 |  |  |  |  |  |  |  |  | REGULAR
Sunday |  | 0 |  |  | 8 |  |  |  | ON CALL |  | OVER TIME
Monday |  | 3 |  |  |  |  |  |  |  |  | ON CALL PER DAY
Tuesday |  | 3 |  |  |  |  |  |  |  |  | VACATION
Wednesday |  | 3 |  |  |  |  |  |  |  |  | SICK DAY
Thursday |  | 3 |  |  |  |  |  |  |  |  | HOLIDAY
Friday |  | 3 |  |  |  |  |  |  |  |  | MISC
 | Total hours |  |  |  |  |  |  |  |  |  | BONUS | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | GROSS
Day | Date | Total Hours | Sick | Vacation | Holiday | MISC | Regular Hours | Overtime Hours | Notation |  | MEDICAL | 59.79
Saturday |  |  |  |  |  |  |  |  |  |  | TOTALS
Sunday
Monday |  |  | 8
Tuesday |  |  |  | 8 | 8
Wednesday |  |  |  |  |  | 8
Thursday |  | 8
Friday |  | 8
 | Total hours
Spreadsheet: 3ee49524-bb9f-4a96-bbb7-bc41a7ee05b5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
WHT | Test | WHT | Wheat, IgE | Wheat, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
WHT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
WHT | Result | WHT | Wheat, IgE | Wheat, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6276-0 | Triticum aestivum [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 185493d1349731444-delivery-schedule-in-excel-len
Sheet: Sheet1

CUST-ID | NAME | ADDRESS 1 | ADDRESS 2 | CITY | STATE | ZIP | Delivery Date | Occurrence | Next Delivery
JOEPIZ | [NAME] PIZZA | 123 MAIN ST. | SUITE 1 | NEW YORK | NY | 10001 | 2012-10-11 00:00:00 | 3
MIKPIZ | MIKE'S PIZZA | 123 COVERED LANE | PO BOX 123 | NEW YORK | NY | 10002 | 2012-10-09 00:00:00 | 1
[NAME] | [NAME]'S DELI | 424 HEATHER LANE |  | BRONX | NY | 10101 | 2012-10-10 00:00:00 | 2
TOMPIZ | TOMMY'S | 28-32 34TH STREET |  | BROOKLYN | NY | 10221
Spreadsheet: rick_buy__32877__Turbine Position Report 111501a
Sheet: Summary by Status

Turbine Position Report |  |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Status
($ MMs)
 |  |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PHYSICAL LOCATION | FINANCING VEHICLE | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION COST TO DATE | STATUS
COMMITTED - turbines committed to deals which have been DASHed and financing is in process.
 |  |  |  |  | Total Committed
TENTATIVE - turbines tentatively committed to ONE deal which has not yet been DASHed, but is likely to be.
1 | 7FA |  | In Fabrication | E-Next Generation |  | DASH 11/16/01 |  |  |  | Tentative
 |  |  |  |  | Total Tentative
AVAILABLE - turbines which may be potential matches with SEVERAL deals, none of which have been approved to date.
1 | 501D5A simple cycle |  | Houston Ship Channel | Balance Sheet |  |  |  |  |  | Available
1 | 9FA STAG power islands |  | Shipboard to Cadiz, Spain | Whitewing | Arcos |  |  |  |  | Available
2 | 9FA STAG power islands |  | In Fabrication | Whitewing |  |  |  |  |  | Available
2 | 11N1 |  | Calgary | Whitewing |  |  |  |  |  | Available
2 | MHI 501F simple cycle (Units 1 & 2) |  | Shipboard to Freeport, TX | West LB CAA |  |  |  |  |  | Available
2 | MHI 501F simple cycle (Units 3 & 4) |  | In Fabrication | West LB CAA |  |  |  |  |  | Available
2 | Fr 6B 60hz power barges (BV=0) |  | East River / NY | Balance Sheet |  |  |  |  |  | Available
1 | LM6000 |  | S&S / Houston | Balance Sheet / PGE |  |  |  |  |  | Available
 |  |  |  |  | Total Available
NEGOTIATING - turbines for which the purchase is currently being negotiated, but Enron does not yet have control of these turbines.
 |  |  |  |  | Total Negotiating
 | UNITS - TOTAL |  |  |  | GRAND TOTALS
SCHEDULED VS CANCELLATION PAYMENTS
($ MMs)
*  Total Cancellation Payments = Total Enron Exposure
Spreadsheet: 149318d1333837609-index-or-lookup-formula-crisis-mdot218_book1_07apr12_01
Sheet: Sheet2

 | [NAME] | absent
Date | Day | Difference | Reason
Spreadsheet: 120995d1315746489-combining-two-data-sets-help-1-
Sheet: Lookup Tables (2)

SiN |  |  |  | Estimated year 11 Coursework Grade
0 | U |  |  | 0 | U
20 | G |  |  | 20 | F
25 | F |  |  | 26 | E
30 | E |  |  | 32 | D
35 | D |  |  | 39 | C
40 | C |  |  | 44 | B
44 | B |  |  | 50 | A
49 | A |  |  | 54 | A*
53 | A*
Spreadsheet: 129517d1321645907-if-and-to-extact-item-from-table-or-not-solved-simpson_location
Sheet: Sheet1

location | HLN | MSLA | BZN | SPO | GRF
big sky | 6 | 34 | 2 | 34 | 556
Lakeside | 13 | 45 | 334 | 23 | 34
I90 Truck Stop | 56 | 23 | 45 | 45 | 23
Stromberg's | 87 | 1 | 67 | 56 | 115
GF Sinclair | 22 | 2 | 87 | 65 | 5
H&R #5 | 34 | 45 | 7 | 76 | 1
H&R #4 | 45 | 5 | 68 | 86 | 4
H&R #1 | 6 | 6 | 7 | 87 | 2
GF Sinclair | 7 | 78 | 65 | 34 | 5
Joyco #1 -stn | 87 | 87 | 55 | 87 | 41
[NAME] (bulk) | 97 | 56 | 9 | 87 | 42
Spreadsheet: 821628d1678820288-determine-if-cells-date-is-in-current-month-if-true-apply-days-function-current-month-example
Sheet: Sheet1

Created | Updated | Resolved | No Days to Close | No of Days to Close (this month)
2023-03-01 16:27:00 | 2023-03-08 13:08:00 | 2023-03-10 13:08:00
2023-02-24 11:29:00 | 2023-02-28 15:49:00
2023-02-23 13:45:00 | 2023-02-28 11:27:00
2023-02-07 13:47:00 | 2023-03-07 17:09:00
2023-02-07 10:59:00 | 2023-02-28 13:08:00
2023-02-06 17:52:00 | 2023-02-21 10:15:00 | 2023-02-21 10:15:00
2023-01-26 15:59:00 | 2023-02-06 11:56:00
2023-01-26 15:25:00 | 2023-01-31 10:56:00
2023-01-22 21:25:00 | 2023-01-23 16:18:00 | 2023-01-23 16:17:00
2023-01-13 14:55:00 | 2023-03-01 17:52:00
2023-01-13 12:51:00 | 2023-01-18 13:58:00 | 2023-01-18 13:58:00
2023-01-13 10:45:00 | 2023-02-07 13:33:00 | 2023-02-01 11:23:00
2023-01-10 18:31:00 | 2023-02-14 13:27:00 | 2023-02-14 13:27:00
2023-01-08 14:57:00 | 2023-03-02 14:52:00
2023-01-06 10:17:00 | 2023-03-08 10:32:00
2022-12-23 11:38:00 | 2023-02-28 13:08:00
2022-12-22 14:50:00 | 2023-01-13 16:05:00
2022-12-15 10:38:00 | 2023-01-17 11:26:00 | 2023-01-17 11:26:00
2022-12-20 16:04:00 | 2023-02-06 15:46:00 | 2023-02-06 15:46:00
Spreadsheet: 189474d1351195154-interest-formula-interest-formula
Sheet: Hemmat (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End date | 2012-09-30 00:00:00
HEMMAT MD,MEHDI
 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2009 Total |  | Test
Pay on Production | 13173.29999999999 | 12619.25 | 22812.64999999997 | 19140.1 | 30490.59999999996 | 16891.28 | 18833.36000000001 | 21497.55999999997 | 8430.099999999982 | 28178.28999999996 | 15558.90000000001 | 16463.44 | 224088.8299999998 |  | Months
Actual Pay | 15706.28 | 15483.83 | 19277.42 | 17367.61 | 23564.29 | 18980.51 | 10101.28 | 14404.57 | 15774.41 | 18505.93 | 9528.839999999998 | 11578.51 | 190273.48 |  | Owed
Difference | 2532.980000000007 | 2864.580000000002 | -3535.229999999967 | -1772.490000000002 | -6926.309999999958 | 2089.23 | -8732.080000000009 | -7092.989999999972 | 7344.310000000018 | -9672.359999999957 | -6030.060000000007 | -4884.930000000002 | -33815.34999999985
Interest | 0 | 0 | 2970 | 2899 | And so on……
Interest
Spreadsheet: 178486d1346806358-how-to-assign-a-value-to-a-data-point-preseason-rankings
Sheet: Sheet2

Team | [NAME] | Leggo My Ego | ABC &RGIII | [NAME] | 3 QBs | Gamebreakers | Favorites | Hillbilly Teeth | UGF | [NAME] | First place Votes | Ranking pts
LBs Vag |  | 4 |  | 8 | 5 | 5 |  | 6 | 7 |  |  | 31
Leggo My Ego | 6 |  |  | 6 | 7 | 2 |  | 2 | 4 |  |  | 39
ABC Easy as RGIII | 8 | 9 |  | 9 | 9 | 9 |  | 5 | 6 |  |  | 22
[NAME] | 5 | 7 |  |  | 8 | 1 |  | 3 | 5 |  |  | 37
3QBs are better than 1 | 4 | 8 |  | 7 |  | 7 |  | 4 | 9 |  |  | 27
Kings Gamebreakers | 3 | 1 |  | 1 | 4 |  |  | 9 | 8 |  |  | 40
Preseason Favorites | 1 | 2 |  | 5 | 1 | 6 |  | 8 | 3 |  |  | 51
Hillbilly Teeth | 2 | 3 |  | 4 | 2 | 8 |  |  | 2 |  |  | 45
Ugandan Horse Factory | 9 | 6 |  | 2 | 3 | 4 |  | 1 |  |  |  | 41
Team Dotseth | 7 | 5 |  | 3 | 6 | 3 |  | 7 | 1 |  |  | 45
Spreadsheet: 139838d1328508530-journal-journal
Sheet: Data entry

JANUARY  2012 - DOLLAR - U.N. BRANCH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training & Project Expense
C A S H     B O O K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Office Operation Expense
Date | Particulars | Account | CV No. | Charge to: | debit | credit | Cash in Bank | Petty Cash | FC:Unappropriated | FC:Appropriated | Accommodation | Air Fare | Communication | Equipment | Honorarium | Gasoline | Interest | License | Mandatory | Miscellaneous | Per Deim | Postage,Parcel, Freight | Professional Fee | Repair & Maintenance | Rental & other related | Salary | Supllies & Materials | Travel | Website | Fund Transer to Peso
 |  |  |  |  | 1108557.91 |  | 10000
2012-02-02 00:00:00 |  | Training & Project Expense |  |  |  | 2305.42
2012-02-03 00:00:00 |  | Training & Project Expense |  |  |  | 6000
2012-02-04 00:00:00 |  | Office Operation Expense |  |  |  | 936
2012-02-05 00:00:00 |  | Training & Project Expense |  |  |  | 23732.33
2012-02-06 00:00:00 |  | Training & Project Expense |  |  |  | 66369.59
 |  |  |  |  |  | 21000
 |  |  |  |  |  | 5200
 |  |  |  |  |  | 1050
 |  |  |  |  |  | 4302
 |  |  |  |  | 694728.9
 |  |  |  |  |  | 140000
 |  |  |  |  |  | 40192
 |  |  |  |  |  | 58068.82
 |  |  |  |  | 820.5
 |  |  |  |  | 532.37
 |  |  |  |  |  | 106.47
Spreadsheet: 237442d1369221302-csv-data-solution3
Sheet: Sheet1

Before you apply the formula, eliminate the points/commas from cells by using find option (Ctrl+F) and choose to replace points/commas with blank.
Before |  |  |  | After
12578800 | 12612500 | 12576800 | 12602300
12602100 | 12619800 | 12593900 | 12605000
12605100 | 12611300 | 12596700 | 12599800
12600000 | 12602900 | 12571700 | 12577800
12578300 | 12591400 | 12562800 | 12566400
12566300 | 12586900 | 12504100 | 12512300
12512300 | 12535100 | 12507500 | 12524400
12524100 | 12539900 | 12504600 | 12511300
12512200 | 12519800 | 12503700 | 12513100
12513200 | 12523400 | 12508900 | 12520000
12520000 | 12529800 | 12517800 | 12523300
12523300 | 12533600 | 12521400 | 12528000
12527800 | 12530300 | 12518300 | 12528800
12528800 | 12532500 | 12508500 | 12525000
12527300 | 12532300 | 12523600 | 12527400
12528200 | 12531400 | 12521400 | 12531400
12531500 | 12532400 | 12516400 | 12521900
12522000 | 12527400 | 12514800 | 12519800
12519800 | 12527800 | 12512800 | 12520900
12520800 | 12522300 | 12508100 | 12512300
Spreadsheet: 139195d1328122817-true-false-to-yes-no-0a1
Sheet: Φύλλο1

1 | Yes
0 | No
1 | Yes
0 | No
1 | Yes
0 | No
1 | Yes
0 | No
1 | Yes
0 | No
Spreadsheet: 699983d1602868646-count-contiguous-occurrences-within-a-range-sample
Sheet: Sheet1

 |  |  |  |  | Expected | */- | HI | LO
 |  |  |  |  | 120 | 2 | 2 | 2
2020-07-01 00:00:00 | 00:10 | 116
2020-07-01 00:00:00 | 00:20 | 117
2020-07-01 00:00:00 | 00:30 | 115
2020-07-01 00:00:00 | 00:40 | 116
2020-07-01 00:00:00 | 00:50 | 120
2020-07-01 00:00:00 | 01:00 | 122
2020-07-01 00:00:00 | 01:10 | 121
2020-07-01 00:00:00 | 01:20 | 123
2020-07-01 00:00:00 | 01:30 | 115
2020-07-01 00:00:00 | 01:40 | 116
2020-07-01 00:00:00 | 01:50 | 117
2020-07-01 00:00:00 | 02:00 | 115
2020-07-01 00:00:00 | 02:10 | 116
2020-07-01 00:00:00 | 02:20 | 114
2020-07-01 00:00:00 | 02:30 | 113
2020-07-01 00:00:00 | 02:40 | 119
2020-07-01 00:00:00 | 02:50 | 118
2020-07-01 00:00:00 | 03:00 | 122
2020-07-01 00:00:00 | 03:10 | 123
2020-07-01 00:00:00 | 03:20 | 124
2020-07-01 00:00:00 | 03:30 | 123
2020-07-01 00:00:00 | 03:40 | 126
2020-07-01 00:00:00 | 03:50 | 124
2020-07-01 00:00:00 | 04:00 | 118
2020-07-01 00:00:00 | 04:10 | 120
2020-07-01 00:00:00 | 04:20 | 115
2020-07-01 00:00:00 | 04:30 | 116
2020-07-01 00:00:00 | 04:40 | 117
2020-07-01 00:00:00 | 04:50 | 112
Spreadsheet: 266818d1379762863-create-tab-update-leaderboards-automatically-calend-rio-e-tabelas
Sheet: Folha2

 |  | JOGO |  |  |  |  |  | DATA |  | HORA |  | CAMPO
 |  | [NAME] | 0 | : | 0 | [NAME] |  | 2013-08-07 00:00:00 |  | 18h00 |  | Campo A
 |  | [NAME] | 0 | : | 0 | [NAME] |  | 2013-08-07 00:00:00 |  | 18h00 |  | Campo A
Spreadsheet: 162645d1340020823-excel-formulas-seem-to-stop-working-at-a-certain-range-camp-sign-up-spreadsheet-test
Sheet: Payment Sheet

 | Name | Total Amount Owed | Amount Paid | Amount Left
1 |  |  |  | 0
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 727269d1617810884-reference-data-from-another-tab-and-return-values-mom-stats_v2_eh
Sheet: Sheet1

 | Auto Pub | Auto Pub % | Vetted | Vetted % | Total Reviews
Auto | 4668 |  | 10979
Finance | 3712 |  | 6224
Manu | 16046 |  | 12450
Retail | 271410 |  | 130861
Travel | 4911 |  | 10633
Total
 |  |  |  |  |  |  |  |  |  | Auto Pub | Auto Pub % | Automatically published | Vetted | Vetted % | Vetted by a moderator | Total Reviews | Total % | Total | Total
 |  |  |  |  |  |  |  |  | Auto |  |  |  |  |  |  |  | 0.215 | 0.789
 |  |  |  |  |  |  |  |  | Finance |  |  |  |  |  |  | 9936
 |  |  |  |  |  |  |  |  | Manu |  |  |  |  |  |  | 28496
 |  |  |  |  |  |  |  |  | Retail |  |  |  |  |  |  | 402271
 |  |  |  |  |  |  |  |  | Travel |  |  |  |  |  |  | 15544
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Auto | 22297.83 | 0.156 | 120637 | 0.844 | 142934.83
 |  |  |  |  |  |  |  |  | Finance | 52720.14 | 0.322 | 111007 | 0.678 | 163727.14
e | Auto Pub | Auto Pub % | Vetted | Vetted % | Total Reviews |  |  |  | Manu | 144478.31 | 0.315 | 314183 | 0.685 | 458661.31
June | 97056 |  | 24872 |  |  |  |  |  | Retail | 318515.39 | 0.239 | 1014185 | 0.761 | 1332700.39
July | 95991 |  | 25213 |  | 121204 |  |  |  | Travel | 82767.15 | 0.106 | 698055 | 0.894 | 780822.15
Total
2019
Spreadsheet: 485136d1476725913-formula-making-problem-mid-1original30sepwof
Sheet: without formulas

 |  | 7.54 |  | 7.54
 |  | calculated field |  | calculated field
 |  | data feed (manually feed) |  | data feed
2016-08-01 00:00:00 | mon | 9.543 |  | 9.543
 |  | 26.56 |  | 26.56
2016-08-02 00:00:00 | tue | 8.97 |  | 8.97
 |  | -6 |  | -6
2016-08-03 00:00:00 | wed | 10.47 |  | 10.47
 |  | 16.72 |  | 16.72
2016-08-04 00:00:00 | thu | 9.87 |  | 9.87
 |  | -5.73 |  | -5.73
2016-08-05 00:00:00 | fri | 8.79 |  | 8.79
2016-08-06 00:00:00 | sat | -10.94 |  | -10.94
2016-08-07 00:00:00 | [NAME] | -10.94 %2d(#2dAV#5.5#3dAV#0.33#WKAV#4.2) |  | -10.94 %2d(#2dAV#5.5#3dAV#0.33#WKAV#4.2)
2016-08-08 00:00:00 | mon | 7.32 |  | 7.32
 |  | -16.72 |  | -16.72
2016-08-09 00:00:00 | tue | 7.85 |  | 7.85
 |  | 7.24 |  | 7.24
2016-08-10 00:00:00 | wed | 8.945 |  | 8.945
 |  | 13.95 |  | 13.95
2016-08-11 00:00:00 | thu | 7.89 |  | 7.89
 |  | -11.79 |  | -11.79
2016-08-12 00:00:00 | fri | 7.65 |  | 7.65
2016-08-13 00:00:00 | sat | -3.04 |  | -3.04
2016-08-14 00:00:00 | [NAME] | -3.04 %2d(#2dAV#1#3dAV#-0.33#WKAV#-1.96) |  | -3.04 %2d(#2dAV#1#3dAV#-0.33#WKAV#-1.96)
2016-08-15 00:00:00 | mon | 7.33 |  | 7.33
 |  | -4.18 |  | -4.18
2016-08-16 00:00:00 | tue | 6.99 |  | 6.99
 |  | -4.64 |  | -4.64
2016-08-17 00:00:00 | wed | 7.834 |  | 7.834
 |  | 12.07 |  | 12.07
2016-08-18 00:00:00 | thu | 6.87 |  | 6.87
 |  | -12.31 |  | -12.31
2016-08-19 00:00:00 | fri | 17.98 |  | 6.02
2016-08-20 00:00:00 | sat | 161.72 |  | -12.37
2016-08-21 00:00:00 | [NAME] | 161.72 %2d(#2dAV#0#3dAV#53.67#WKAV#30.6) |  | -12.37 %2d(#2dAV#0#3dAV#-4#WKAV#-4)
2016-08-22 00:00:00 | mon | 6.02 |  | 17.98
 |  | -66.52 |  | 198.67
2016-08-23 00:00:00 | tue | 8.02 |  | 8.02
 |  | 33.22 |  | -55.39
2016-08-24 00:00:00 | wed | 8.04 |  | #8.02
 |  |  |  | here as due to special character added, the formula is not working AND this has further effects
 |  | 0.25 |  | #[NAME]!
2016-08-25 00:00:00 | thu | 26.89 |  | 6.89
 |  | 234.45 |  | #[NAME]!
2016-08-26 00:00:00 | fri | 6.34 |  | 6.34
 |  | -75.77 |  | -7.98
 |  | -76.42 %2d(#2dAV#79.5#3dAV#53.07#WKAV#25.24) | 25.24 | #[NAME]!
 |  | mid function IS USED AS ONLY RELEVANT NUMBERS FROM A STRING HAS TO BE CONSIDERED
 |  | BUT THIS CREATED PROBLEM WHEN THE NUMBER OF NUMERALS TO BE CONSIDERED ARE NOT ENOUGH AND HAS OTHER CHARACTER/SYMBOLS ahead/BEHIND THE SIGN--if is -ve(WHICH IS NORMAL)
 |  | seen in e57,e60, e63
 |  | So has to make formula such that only numerals string(with -ve sign if is there)  that are at starting of value is considered(till 1 places after decimal, if there is decimal)----
 |  | after "#" delimiter till the next "#" delimiter.
 |  | Last two days average is ALSO calculated seperately in the data feed field before weekly average as this is needed as input in formauls that are used in weekly average, so done this to avoic [NAME] issue
Spreadsheet: 767033d1644250423-what-would-cause-excel-to-pause-its-calcs-when-it-is-set-to-automatic-livecards
Sheet: Padres

Hitters |  |  | Pitchers
UIG | NAME |  | UIG | NAME