tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 06c7ea65-b56f-44c9-a416-1aea0d9252f7
Sheet: Figure 5

Figure 5: State Characteristics
 |  | Statewide District | Statewide Charter
Percentage of students eligible for free or reduced price lunch |  | 0.372 | 0.323
Percentage of schools eligible for Title 1 |  | 0.831 | 1
Percent of students by school type
 | Primary (K-5) | 0.434 | 0.594
 | Middle (6-8) | 0.239 | 0.077
 | High (9-12) | 0.304 | 0.21
 | Other (K-12,K-8, etc.) | 0.023 | 0.119
Spreadsheet: 329697d1404386395-help-to-prepare-dynamic-table-in-excel-dummy
Sheet: Sheet4

Sum of Quantity | Column Labels
Row Labels | week-22 | week-23 | week-24 | Grand Total
a | 19 |  |  | 19
b | 20 |  |  | 20
c | 30 | 12 | 18 | 60
d | 28 | 11 | 29 | 68
e | 14 | 26 | 20 | 60
f | 16 | 11 | 14 | 41
g |  | 29 | 13 | 42
i |  | 18 |  | 18
m |  |  | 24 | 24
Grand Total | 127 | 107 | 118 | 352
Spreadsheet: 873478d1719965367-logistics-time-on-the-road-per-day-logistics-revised
Sheet: Sheet1

 | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Hour
 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 | 1 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8
 | 2 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0
 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0
 | 4 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0
 | 5 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0
 | 6 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0
 | 7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
 | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | 9 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0
 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0
 | 11 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0
 | 12 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0
 | 13 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0
 | 14 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0
 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | 16 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0
 | 18 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0
 | 19 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0
 | 20 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0
 | 21 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0
 | 22 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 | 23 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0
 | 1 |  | 24 | 8 | 24 | 16 | 24 | 24 | 24 | 24 | 8
 | 1 |  |  | 16 |  | 8 |  |  |  |  | 16
 | 2 | 17 | 24 |  | 24 | 23 | 24 | 24 | 7 | 24 | 15
 | 2 |  |  | 9 |  | 1 |  |  | 17 |  | 9
 | 3 | 10 | 24 | 22 | 24 | 24 | 6 | 24 | 14 | 24 | 22
 | 3 |  |  | 2 |  |  | 18 |  | 10 |  | 2
 | 4 | 3 | 24 | 24 | 5 | 24 | 13 | 24 | 21 | 24 | 24
 | 4 |  |  |  | 19 |  | 11 |  | 3
 | 5 |  | 20 | 24 | 12 | 24 | 20 | 24 | 24 | 4 | 24
 | 5 |  |  |  | 12 |  | 4 |  |  | 20
 | 6 |  | 13 | 24 | 19 | 24 | 24 | 3 | 24 | 11 | 24
 | 6 |  |  |  | 5 |  |  | 21 |  | 13
 | 7 |  | 6 | 24 | 24 | 24 | 24 | 10 | 24 | 18 | 24
 | 7 |  |  |  |  |  |  | 14 |  | 6
 | 8 |  |  | 23 | 24 | 24 | 24 | 17 | 24 | 24 | 1
 | 8 |  |  |  |  |  |  | 7 |  |  | 23
 | Total
Spreadsheet: f16faa77-46db-472a-970d-808e8b8f3f53
Sheet: Comprehensive income

 |  | Current Period | Prior Period
 |  | ([NAME]) | ([NAME])
 |  | 1 January 2011 - | 1 January 2010 -
 |  | 31 March 2011 | 31  March  2010
 | Notes
Profit for the period |  | 571289 | 503688
Other comprehensive income:
Profit / (loss) from derivative financial instruments transferred to condensed consolidated income statement | 14 | 12875 | 30852
Change in fair value of derivative financial instruments |  | -427 | -10652
Net investment hedge |  | -14671 | -
Deferred tax effect of net investment hedge |  | 2934 | -
Currency translation gain / (loss) |  | 10379 | -44
Other comprehensive income (After tax) |  | 11090 | 20156
Total comprehensive income |  | 582379 | 523844
Distrubution of total comprehensive income:
Attributable to equity holders of the parent |  | 617783 | 562648
Minority interest |  | -35404 | -38804
Spreadsheet: 779721d1652048361-index-match-with-multiple-criteria-blanks-and-drop-down-lists-index-match-multiple-criteria
Sheet: Sheet3

Person: | Person A | ß [NAME]-down list
Time Between: | Column 7 & Column 9 | ß [NAME]-down list
Total | Total | Total | Total | Total | Total | Total
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 |  | ß Header changes based on cell B2
Spreadsheet: andy_zipper__757__10_23_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 270 | 21.5 | 23.5 | 110.1 | 120.4 | 19.56 | 2001-10-23 12:48:00
 | NG Z1 | 290 | 54 | 56 | 75.8 | 78.6 | 14.08 | 2001-10-23 12:48:00
 | NG F2 | 310 | 76 | 80 | 74.2 | 78.1 | 14.84 | 2001-10-23 12:48:00
 | NG G2 | 315 | 86 | 89 | 67.4 | 69.8 | 13.59 | 2001-10-23 12:48:00
 | NG H2 | 310 | 89 | 91 | 62.7 | 64.1 | 12.36 | 2001-10-23 12:48:00
 | NG J2 | 305 | 78 | 80 | 50.6 | 51.9 | 9.83 | 2001-10-23 12:48:00
 | NG K2 | 305 | 79 | 83 | 46.9 | 49.3 | 9.22 | 2001-10-23 12:48:00
 | NG M2 | 310 | 84 | 88 | 45.4 | 47.6 | 9.06 | 2001-10-23 12:48:00
 | NG N2 | 310 | 89 | 94 | 45.4 | 48 | 9.1 | 2001-10-23 12:48:00
 | NG Q2 | 315 | 96 | 101 | 45.7 | 48.1 | 9.29 | 2001-10-23 12:48:00
 | NG U2 | 315 | 102 | 107 | 46.2 | 48.5 | 9.38 | 2001-10-23 12:48:00
 | NG V2 | 320 | 105 | 112 | 44.9 | 48 | 9.34 | 2001-10-23 12:48:00
 | [NAME] |  |  |  |  |  | 10.12 | 2001-10-18 10:52:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: kay_mann__19209__Breakout Contracts
Sheet: Contract Payment Summary

LM 6000 Contract Payment Summary
 | # of | Contract | Paid Through |  | Dec '00 Change
Project Name | Turbines | Value | October | Nov. Pymt. | Order Pymt. | 2001-01-15 00:00:00 | 2001-05-15 00:00:00 | 2001-07-30 00:00:00 | 2001-08-15 00:00:00 | TOTAL
Austin - Units 9 -12 | 4 |  | 42216000 | 14072000 | 0
PSCO - Units 13-16 | 4 |  | 42216000 | 7036000
PSCO - Units 7 & 8 | 2 |  | 21108000 | 3518000
Coral - Unit 17 | 1 |  | 10554000 | 1759000
Coral - Unit 18 | 1 |  | 10554000 | 1759000
ESA - Units 1-6 | 6 |  | 63324000 | 4221600
ESA - Units 21 & 22 | 2 |  | 22019200 | 3310400
[NAME] 19-20 & 23-24 | 4 |  | 5628800 | 0 | 0 | 0 | 16886400 | 16886400 | 16886400
TOTAL
1 Contract Value represents GE's allocation of the total costs of the 24 turbines and options D, I, J, and Y (excludes [NAME]).
Please note that although only 16 turbines have Option D, GE has split the cost over all 24 turbines.
2 Dec. '00 Change Order Payment represents 75% of the total amount due.
Spreadsheet: 2048b846-7252-431e-865f-b5d6f7e94571
Sheet: Sheet1

参 考 表 2　　  主 要 国 の 消 費 者 物 価 指 数 変 化 率 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Reference Table 2 　 Rates of Change in Consumer Price Index of Principal Countries
 |  |  |  |  |  |  |  | 前年(同月)比 (％)
 |  |  |  |  |  |  |  | % Change over the year
 |  |  |  | 1）
 | 日　本 | アメリカ | カ ナ ダ | イギリス | ド イ ツ | フランス | イタリア | 中  国 | 韓 　国 | Year
年　月 |  |  |  |  |  |  |  | People's   Rep. of   China |  | and
 | Japan | United 　 States | Canada | United 　 Kingdom | Fed. Rep. 　of Germany | France | Italy |  | Rep. of 　 Korea | month
平成17年平均 | -0.3 | 3.4 | 2.2 | 2.8 | 1.5 | 1.8 | 1.9 | 1.8 | 2.8 | 2005
18 | 0.3 | 3.2 | 2 | 3.2 | 1.6 | 1.6 | 2.1 | 1.5 | 2.2 | 2006
19 | 0 | 2.8 | 2.2 | 4.3 | 2.3 | 1.5 | 1.8 | 4.8 | 2.5 | 2007
20 | 1.4 | 3.8 | 2.3 | 4 | 2.6 | 2.8 | 3.3 | 5.9 | 4.7 | 2008
21 | -1.4 | -0.4 | 0.3 | -0.5 | 0.4 | 0.1 | 0.8 | -0.7 | 2.8 | 2009
22 | -0.7 | 1.6 | 1.8 | 4.6 | 1.1 | 1.5 | 1.5 | 3.3 | 3 | 2010
23 | -0.3 | 3.2 | 2.9 | 5.2 | 2.3 | 2.1 | 2.8 | 5.4 | 4 | 2011
平成22年 2月 | -1.1 | 2.1 | 1.6 | 3.7 | 0.6 | 1.3 | 1.2 | 2.7 | 3 | Feb. 2010
3 | -1.1 | 2.3 | 1.4 | 4.4 | 1.1 | 1.6 | 1.4 | 2.4 | 2.5 | Mar.
4 | -1.2 | 2.2 | 1.8 | 5.3 | 1 | 1.7 | 1.5 | 2.8 | 2.6 | Apr.
5 | -0.9 | 2 | 1.4 | 5.1 | 1.2 | 1.6 | 1.4 | 3.1 | 2.7 | May
6 | -0.7 | 1.1 | 1 | 5 | 0.9 | 1.5 | 1.3 | 2.9 | 2.7 | June
7 | -0.9 | 1.2 | 1.8 | 4.8 | 1.2 | 1.7 | 1.7 | 3.3 | 2.5 | July
8 | -0.9 | 1.1 | 1.7 | 4.7 | 1 | 1.4 | 1.6 | 3.5 | 2.7 | Aug.
9 | -0.6 | 1.1 | 1.9 | 4.6 | 1.3 | 1.6 | 1.6 | 3.6 | 3.4 | Sep.
10 | 0.2 | 1.2 | 2.4 | 4.5 | 1.3 | 1.6 | 1.7 | 4.4 | 3.7 | Oct.
11 | 0.1 | 1.1 | 2 | 4.7 | 1.5 | 1.6 | 1.7 | 5.1 | 3 | Nov.
12 | 0 | 1.5 | 2.4 | 4.8 | 1.7 | 1.8 | 1.9 | 4.6 | 3 | Dec.
平成23年 1月 | -0.6 | 1.6 | 2.3 | 5.1 | 2 | 1.8 | 2.1 | 4.9 | 3.4 | Jan. 2011
2 | -0.5 | 2.1 | 2.2 | 5.5 | 2.1 | 1.7 | 2.4 | 4.9 | 3.9 | Feb.
3 | -0.5 | 2.7 | 3.3 | 5.3 | 2.1 | 2 | 2.5 | 5.4 | 4.1 | Mar.
4 | -0.4 | 3.2 | 3.3 | 5.2 | 2.4 | 2.1 | 2.6 | 5.3 | 3.8 | Apr.
5 | -0.4 | 3.6 | 3.7 | 5.2 | 2.3 | 2 | 2.6 | 5.5 | 3.9 | May
6 | -0.4 | 3.6 | 3.1 | 5 | 2.3 | 2.1 | 2.7 | 6.4 | 4.2 | June
7 | 0.2 | 3.6 | 2.7 | 5 | 2.4 | 1.9 | 2.7 | 6.5 | 4.5 | July
8 | 0.2 | 3.8 | 3.1 | 5.2 | 2.4 | 2.2 | 2.8 | 6.2 | 4.7 | Aug.
9 | 0 | 3.9 | 3.2 | 5.6 | 2.6 | 2.2 | 3 | 6.1 | 3.8 | Sep.
10 | -0.2 | 3.5 | 2.9 | 5.4 | 2.5 | 2.3 | 3.4 | 5.5 | 3.6 | Oct.
11 | -0.5 | 3.4 | 2.9 | 5.2 | 2.4 | 2.5 | 3.3 | 4.2 | 4.2 | Nov.
12 | -0.2 | 3 | 2.3 | 4.8 | 2.1 | 2.5 | 3.3 | 4.1 | 4.2 | Dec.
平成24年 1月 | 0.1 | 2.9 | 2.5 | 3.9 | 2.1 | 2.3 | 3.2 | 4.5 | 3.4 | Jan. 2012
1）　小売物価指数 |  | Retail Prices Index
Spreadsheet: 691474d1597712515-how-make-excel-automatically-choose-from-a-list-off-missing-items-excel-forum-attachment-sample
Sheet: Sheet1

 | designs they already have (have=1;don't have=0) |  |  |  |  |  |  |  |  |  | next design to send
name | peacock | rose | daisy | cleopatra | [NAME] | butterfly | bunny | reign | coral | feline
[NAME] | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | cleopatra
[NAME] | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Peacock
Rachel | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | rose
Mandy | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | peacock
[NAME] | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME]
Zena | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | feline
all available designs | priority
peacock | 1
rose | 2
daisy | 3
cleopatra | 4
[NAME] | 5
butterfly | 6
bunny | 7
reign | 8
coral | 9
feline | 10
Spreadsheet: 883359d1731984720-sumifs-with-indirect-did-not-work-stock-control-sumifs
Sheet: Terry

Date | Stock | Quantity | Price | Total
2024-11-02 00:00:00 | Milk | 4
2024-11-10 00:00:00 | Milk | 4
2024-11-11 00:00:00 | Milo | 1
2024-11-12 00:00:00 | Coffee | 1
Spreadsheet: 690627d1597209295-formula-for-producing-customers-statement-customers-statement
Sheet: Receipts

Date | [NAME] | Customer  Name | VAT Number | Invoice Number | Amount Received
2020-08-10 00:00:00 | 100 | Ok Mart | 1000200 | 1 | 10000
2020-08-11 00:00:00 | 101 | [NAME] | 1000201 | 2 | 27324
2020-08-12 00:00:00 | 102 | Ok Mart | 1000200 | 3 | 7500
2020-08-12 00:00:00 | 103 | ZIMNAT | 1000203 | 4 | 1000
Spreadsheet: 871691d1718110218-creating-dynamic-forecast-values-each-month-when-new-data-is-added-forecast-data-examples
Sheet: Sheet5

Date | Sales - actual values | Forecast
2022-01-01 00:00:00 | 3334
2022-02-01 00:00:00 | 2318
2022-03-01 00:00:00 | 4969
2022-04-01 00:00:00 | 3117
2022-05-01 00:00:00 | 3419
2022-06-01 00:00:00 | 2791
2022-07-01 00:00:00 | 2874
2022-08-01 00:00:00 | 2372
2022-09-01 00:00:00 | 2901
2022-10-01 00:00:00 | 2795
2022-11-01 00:00:00 | 3459
2022-12-01 00:00:00 | 2257
2023-01-01 00:00:00 | 4438
2023-02-01 00:00:00 | 3930
2023-03-01 00:00:00 | 5231
2023-04-01 00:00:00 | 4821
2023-05-01 00:00:00 | 5696
2023-06-01 00:00:00 | 5175
2023-07-01 00:00:00 | 5105
2023-08-01 00:00:00 | 4002
2023-09-01 00:00:00 | 4769
2023-10-01 00:00:00 | 3256
2023-11-01 00:00:00 | 3277
2023-12-01 00:00:00 | 3636
2024-01-01 00:00:00 | 3364
2024-02-01 00:00:00 | 2586
2024-03-01 00:00:00 | 3235
2024-04-01 00:00:00 | 6653
2024-05-01 00:00:00 | 2066
2024-06-01 00:00:00 | 0
2024-07-01 00:00:00 | 0
2024-08-01 00:00:00 | 0
2024-09-01 00:00:00 | 0
2024-10-01 00:00:00 | 0
2024-11-01 00:00:00 | 0
2024-12-01 00:00:00 | 0
Spreadsheet: 113645d1309470479-total-time-calculation-sample-book1
Sheet: Sheet1

EMPLOYEE 1
 | In | Out | Total Hours Worked
SUNDAY | 17:00:00 | 07:00:00
MONDAY | 17:00:00 | 07:00:00
TUESDAY | 17:00:00 | 07:00:00
WEDNESDAY | 17:00:00 | 07:00:00
THURSDAY | 17:00:00 | 07:00:00
FRIDAY
SATURDAY | 17:00:00 | 07:00:00
 |  | TOTAL HOURS WEEK | 1900-01-01 00:00:00
EMPLOYEE 2
 | In | Out | Total Hours Worked
SUNDAY | 08:00:00 | 16:00:00
MONDAY
TUESDAY | 08:00:00 | 16:00:00
WEDNESDAY | 08:00:00 | 16:00:00
THURSDAY | 08:00:00 | 16:00:00
FRIDAY | 08:00:00 | 16:00:00
SATURDAY | 08:00:00 | 16:00:00
 |  | TOTAL HOURS WEEK | 1900-01-01 00:00:00
Spreadsheet: 876480d1723167952-percentage-of-quarterly-target-to-date-as-of-today-help-kpi-percentage
Sheet: Utilisation Tracking

Month | Hours Billed | Target | Hours Remaining | % Month | Work Days | Qtr Total | Target | % | Qtr to Date | Target Hours + / -
January | 79.83 | 92 |  |  | 18
February | 119.92 | 105 |  |  | 21
March | 100.25 | 90 |  |  | 19
April | 100.48 | 90 |  |  | 19 |  | 295
May | 108.07 |  |  |  | 22
June | 111.5 | 95 |  |  | 19
July | 130.5 |  |  |  | 23
August | 42 |  |  |  | 22
September | 0 |  |  |  | 21
October | 0 |  |  |  | 23
November | 0 |  |  |  | 21
December | 0 |  |  |  | 20
Spreadsheet: 168718d1342549715-unique-record-sum-sampledata
Sheet: Sheet1

TripID | ReceiptDate | ItemType | DriverID | Jurisdiction | EnvMiles
37553 | 2012-01-02 00:00:00 | Truck Fuel | 88 | 43 |  |  | I want the sum of EnvMiles for unique TripID
37553 | 2012-01-02 00:00:00 | Service Fee | 88 | 43
37553 | 2012-01-02 00:00:00 | [NAME] | 88 | 43 |  |  | Example,
37634 | 2012-01-02 00:00:00 | Truck Fuel | 39 | 51 |  |  | In the database
37634 | 2012-01-02 00:00:00 | Service Fee | 39 | 51 |  |  | ItemType | Truck Fuel
37644 | 2012-01-02 00:00:00 | Truck Fuel | 3 | 16 |  |  | DriverID | 88
37644 | 2012-01-02 00:00:00 | [NAME] | 3 | 16
37649 | 2012-01-02 00:00:00 | Truck Fuel | 192 | 40
37650 | 2012-01-02 00:00:00 | Truck Fuel | 208 | 40 |  |  | Current [NAME] I'm using
37650 | 2012-01-02 00:00:00 | Discount | 208 | 40
37650 | 2012-01-02 00:00:00 | Service Fee | 208 | 40 |  |  | *But this formula is using 2 identical numbers from the SAME TripID (67656).
37654 | 2012-01-02 00:00:00 | Truck Fuel | 214 | 40 |  |  | I need suum EnvMIles with UNIQUE TripID only!
37654 | 2012-01-02 00:00:00 | Discount | 214 | 40
37654 | 2012-01-02 00:00:00 | Cash Advance | 214 | 40
37654 | 2012-01-02 00:00:00 | Service Fee | 214 | 40
37655 | 2012-01-02 00:00:00 | Truck Fuel | 215 | 40
37656 | 2012-01-02 00:00:00 | Truck Fuel | 88 | 43 | 11500
37656 | 2012-01-02 00:00:00 | Service Fee | 88 | 43 | 11500
37656 | 2012-01-02 00:00:00 | [NAME] | 88 | 43 | 11500
67656 | 2012-01-02 00:00:00 | Truck Fuel | 88 | 43 | 11500
67656 | 2012-01-02 00:00:00 | Service Fee | 88 | 43 | 11500
67656 | 2012-01-02 00:00:00 | [NAME] | 88 | 43 | 11500
Spreadsheet: 765032d1643128788-sum-sumifs-with-multiple-criteria-sum-sumifs
Sheet: Sheet1

Code | Region | Name | Amount |  |  | Code | ABC | XYZ
ABC | North | [NAME] | 5 |  |  | Region | North | South
ABC | North | [NAME] | 9 |  |  | Name | [NAME]
ABC | North | [NAME] | 22
ABC | South | [NAME] | 36
ABC | South | [NAME] | 14
ABC | South | [NAME] | 48
XYZ | North | [NAME] | 34
XYZ | North | [NAME] | 46
XYZ | North | [NAME] | 4
XYZ | South | [NAME] | 21
XYZ | South | [NAME] | 17
XYZ | South | [NAME] | 39
A1A | North | [NAME] | 1
A1A | North | [NAME] | 49
A1A | North | [NAME] | 10
A1A | South | [NAME] | 9
A1A | South | [NAME] | 26
A1A | South | [NAME] | 3
Spreadsheet: 676890d1589041869-sumif-formula-help-required-sample-1
Sheet: Sheet1

DATE WORKED | AMOUNT | MONTH NUM | MONTHLY TOTAL
2020-01-01 00:00:00 | 100 | =[@[DATED WORKED]]
2020-01-18 00:00:00 | 300 | 1
2020-01-27 00:00:00 | 50 | 1
2020-02-14 00:00:00 | 200 | 2
2020-02-14 00:00:00 | 150 | 2
2020-02-19 00:00:00 | 100 | 2
2020-02-25 00:00:00 | 50 | 2
2020-03-03 00:00:00 | 100 | 3
2020-03-06 00:00:00 | 50 | 3
Spreadsheet: 49016b0e-ffb0-4bef-9692-21818adb4e04
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
VWFM2 | Test | VWFM2 | von Willebrand Factor Multimer Analysis, Plasma | von Willebrand Factor Multimer, P | Agarose Gel Electrophoresis/Infrared Dye-Labeled Antibody Detection | Light blue-top (citrate) tube: LgtBlu |  |  | 0.5 | mL | VWFX / von Willebrand Factor Activity, [NAME] and VWAG / von Willebrand Factor [NAME], Plasma are required before performing this test. If already assayed, submit results. If no results are included, submit separate specimens for the above assays following specimen requirements for each test.    See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vials [NAME]: 1 mL in 2 plastic vials each containing 0.5 mL Collection Instructions: 1. [NAME] should be drawn prior to coagulation factor replacement therapy. 2. Spin down, remove plasma, and spin plasma again. 3. Freeze specimens immediately at < or =-40 degrees C, if possible. 4. Send specimens in the same shipping container. Additional Information: 1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. Each coagulation assay requested should have its own vial. 3. Coagulation testing is highly complex, often requiring the performance of multiple assays and correlation with clinical information. For that reason, we suggest ordering VWPR / von Willebrand Profile. Forms: Coagulation Patient Information Sheet (Supply T675) in Special Instructions | 0.5 mL if prior ristocetin cofac | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK-refreeze and note to lab Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | An interpretive report will be provided. | Monday, Tuesday; 9 a.m.-4 p.m. | 7 days | 10 days | 1 | 85247 |  |  |  |  | Rochester
VWFM2 | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 42 days
VWFM2 | Order Question | VWAGR | von Willebrand Ag Result |  | Plain Text
VWFM2 | Order Question | VFXRR | VWF Activity or [NAME] |  | Plain Text
VWFM2 | Result | 8844 | von Willebrand Factor Multimer, P | von Willebrand Factor Multimer, P | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32217-2 | [NAME] factor multimers:ACnc:Pt:PPP:[NAME]:
Spreadsheet: 16de2982-958c-4874-90ce-5ee88b831fa4
Sheet: Sheet1

Aggravated Assault | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 14.87837749875603 | 24.31491842912845 | 4.982665557262293
13-14 | 260.974155438573 | 393.3229902354815 | 121.9807706851208
15 | 453.4158681581793 | 711.5660176347006 | 181.3757942484858
16 | 566.3439452252948 | 923.5421860511456 | 187.5782054972601
17 | 622.6015448486845 | 1043.492150699449 | 174.5174558636265
18 | 650.1437109504996 | 1113.655374918125 | 162.8101594551046
19 | 592.309277789573 | 1011.51429343293 | 155.1591205748939
20 | 573.18879512593 | 969.3285990685721 | 159.6869336226443
21 | 568.673489038859 | 961.0399862039645 | 159.1650701515113
22 | 542.1757298752644 | 917.6374062595629 | 153.7148474329239
23 | 524.306079637221 | 880.440739003756 | 157.2312312979266
24 | 500.5257644665654 | 835.7453013236958 | 156.4492548313686
25-29 | 461.104746586958 | 766.7587774786468 | 153.1884845630087
30-34 | 372.2460380956807 | 617.3544592113745 | 128.4860400765103
35-39 | 275.8679653353323 | 461.8137857258894 | 91.97119790210263
40-44 | 183.1614670965391 | 314.9208393468475 | 54.53480405922909
45-49 | 121.9906025910606 | 215.0710693850535 | 32.26321035457519
50-54 | 81.437671941933 | 146.0399336977321 | 20.31201276640025
55-59 | 54.49285483945921 | 99.73529738463884 | 12.80808033923744
60-64 | 34.52548507392773 | 66.30055668650942 | 6.417787710782314
65 and over | 13.12790377644692 | 29.15141455382144 | 2.203484538329327
Spreadsheet: 836216d1689176142-depreciation-calculator-depreciation-nsandeepv87-
Sheet: Sheet1

 | 2023-12-31 00:00:00
 | Purchase Date | Amount | Rate | Days | Depreciation | 2023-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 2023-03-31 00:00:00 | 49000 | 0.31
 | 2009-12-06 00:00:00 | 49000 | 0.31
 | 2023-02-28 00:00:00 | 49000 | 0.31
 | 2023-04-20 00:00:00 | 49000 | 0.31
 | 2024-01-31 00:00:00 | 49000 | 0.31
Spreadsheet: 807943d1670177186-incremental-counting-with-criteria-chadsample
Sheet: Sheet1

game.date | site.key | team.key | opponent.key | h/a | G # | H/A Stand | HA_Series# | Game of Series | HA_Situation | Series Length
2021-04-01 00:00:00 | ANA01 | ANA | CHA | H |  |  | 1H |  |  | 4
2021-04-02 00:00:00 | ANA01 | ANA | CHA | H |  |  | 1H |  |  | 4
2021-04-03 00:00:00 | ANA01 | ANA | CHA | H |  |  | 1H |  |  | 4
2021-04-04 00:00:00 | ANA01 | ANA | CHA | H |  |  | 1H |  |  | 4
2021-04-05 00:00:00 | ANA01 | ANA | HOU | H |  |  | 2H |  |  | 2
2021-04-06 00:00:00 | ANA01 | ANA | HOU | H |  |  | 2H |  |  | 2
2021-04-08 00:00:00 | DUN01 | ANA | TOR | A |  |  | 1A |  |  | 3
2021-04-09 00:00:00 | DUN01 | ANA | TOR | A |  |  | 1A |  |  | 3
2021-04-10 00:00:00 | DUN01 | ANA | TOR | A |  |  | 1A |  |  | 3
2021-04-12 00:00:00 | KAN06 | ANA | KCA | A |  |  | 2A |  |  | 3
2021-04-13 00:00:00 | KAN06 | ANA | KCA | A |  |  | 2A |  |  | 3
2021-04-14 00:00:00 | KAN06 | ANA | KCA | A |  |  | 2A |  |  | 3
2021-04-16 00:00:00 | ANA01 | ANA | MIN | H |  |  | 1H |  |  | 1
2021-04-19 00:00:00 | ANA01 | ANA | TEX | H |  |  | 2H |  |  | 3
2021-04-20 00:00:00 | ANA01 | ANA | TEX | H |  |  | 2H |  |  | 3
2021-04-21 00:00:00 | ANA01 | ANA | TEX | H |  |  | 2H |  |  | 3
2021-04-22 00:00:00 | HOU03 | ANA | HOU | A |  |  | 1A |  |  | 4
2021-04-23 00:00:00 | HOU03 | ANA | HOU | A |  |  | 1A |  |  | 4
2021-04-24 00:00:00 | HOU03 | ANA | HOU | A |  |  | 1A |  |  | 4
2021-04-25 00:00:00 | HOU03 | ANA | HOU | A |  |  | 1A |  |  | 4
2021-04-26 00:00:00 | ARL03 | ANA | TEX | A |  |  | 2A |  |  | 3
2021-04-27 00:00:00 | ARL03 | ANA | TEX | A |  |  | 2A |  |  | 3
2021-04-28 00:00:00 | ARL03 | ANA | TEX | A |  |  | 2A |  |  | 3
2021-04-30 00:00:00 | SEA03 | ANA | SEA | A |  |  | 3A |  |  | 3
2021-05-01 00:00:00 | SEA03 | ANA | SEA | A |  |  | 3A |  |  | 3
2021-05-02 00:00:00 | SEA03 | ANA | SEA | A |  |  | 3A |  |  | 3
2021-05-03 00:00:00 | ANA01 | ANA | TBA | H |  |  | 1H |  |  | 4
2021-05-04 00:00:00 | ANA01 | ANA | TBA | H |  |  | 1H |  |  | 4
2021-05-05 00:00:00 | ANA01 | ANA | TBA | H |  |  | 1H |  |  | 4
2021-05-06 00:00:00 | ANA01 | ANA | TBA | H |  |  | 1H |  |  | 4
2021-05-07 00:00:00 | ANA01 | ANA | LAN | H |  |  | 2H |  |  | 3
2021-05-08 00:00:00 | ANA01 | ANA | LAN | H |  |  | 2H |  |  | 3
2021-05-09 00:00:00 | ANA01 | ANA | LAN | H |  |  | 2H |  |  | 3
2021-05-10 00:00:00 | HOU03 | ANA | HOU | A |  |  | 1A |  |  | 3
2021-05-11 00:00:00 | HOU03 | ANA | HOU | A |  |  | 1A |  |  | 3
2021-05-12 00:00:00 | HOU03 | ANA | HOU | A |  |  | 1A |  |  | 3
2021-05-14 00:00:00 | BOS07 | ANA | BOS | A |  |  | 2A |  |  | 3
2021-05-15 00:00:00 | BOS07 | ANA | BOS | A |  |  | 2A |  |  | 3
2021-05-16 00:00:00 | BOS07 | ANA | BOS | A |  |  | 2A |  |  | 3
Spreadsheet: 587713d1535196801-return-search-results-from-various-worksheets-into-one-worksheet-without-macros-monthly-report_trial-18
Sheet: Daily Report

 |  | DAILY REPORT FOR: | 2018-08-20 00:00:00
DATE | Month Name | Name | AMT. | HEAD | GROUP
 |  | [NAME] | 2000 | CLIENT | SALES
 |  | RHIANNA SMITH | 2500 | RENT | COMMON
 |  | [NAME] | -5600 | LOAN | BANK
 |  | PQR LIMited | -5000 | PHONES | COMMON
Spreadsheet: 704596d1605635913-possible-vlookup-testbadge-4-1
Sheet: Sheet1

Date/Time | Who | Credential Hotstamp | EMP ID
2020-11-05 17:50:54 | Green, [NAME] | 1001111 | TAB0100914
2020-11-05 18:31:32 | [NAME], [NAME] | 1001112 | TAB0100420
2020-11-05 08:56:40 | Doe, [NAME] | 1001113 | [NAME]
2020-11-05 09:56:40 | Black, [NAME] | 1001114 | TAB0100965
Spreadsheet: 152522d1335423080-excel-2007-find-a-specific-number-on-a-formula-formula_2-1-
Sheet: @ 122

 | USD | PROFIT | LKR | True/False
 | 2.69
 | 3.46
 | 0.98
 | 1.5
 | 0.98
 | 1.08
 |  |  |  |  | How do I exactly find whether E3 contains 122 or multiplied by 122