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

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | EXP |  |  | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 20 | 263 | 270 | 57.7 | 59.2 | 0.73 | 2001-11-14 14:42:00
 | CL G2 | 20 | 362 | 375 | 55.1 | 57.1 | 0.71 | 2001-11-14 14:42:00
 | CL H2 | 20.5 | 442 | 447 | 54.5 | 55.1 | 0.71 | 2001-11-14 14:42:00
 | CL J2 | 20.5 | 475 | 490 | 51.3 | 52.9 | 0.67 | 2001-11-14 14:42:00
 | CL K2 | 20.5 | 520 | 535 | 50 | 51.5 | 0.65 | 2001-11-14 14:42:00
 | CL M2 | 20.5 | 535 | 550 | 47.4 | 48.8 | 0.62 | 2001-11-14 14:42:00
 | CL N2 | 20.5 | 550 | 570 | 45.1 | 46.8 | 0.59 | 2001-11-14 14:42:00
 | CL Q2 | 20.5 | 560 | 580 | 43.2 | 44.8 | 0.57 | 2001-11-14 14:42:00
 | CL U2 | 20.5 | 565 | 585 | 41.4 | 42.9 | 0.54 | 2001-11-14 14:42:00
 | [NAME] | 20.5 | 570 | 590 | 39.6 | 41 | 0.52 | 2001-11-14 14:42:00
 | CL X2 | 20.5 | 580 | 600 | 38.6 | 40 | 0.51 | 2001-11-14 14:42:00
 | [NAME] | 20.5 | 590 | 605 | 37.9 | 38.9 | 0.49 | 2001-11-14 14:42:00
 | CL M3 | 20.5 | 580 | 600 | 31.4 | 32.4 | 0.41 | 2001-11-14 14:42:00
 | CL Z3 | 20.5 | 580 | 600 | 27.8 | 28.8 | 0.36 | 2001-11-14 14:42:00
Spreadsheet: 95332d1294936871-problem-with-pivot-table-top-10-filter-pvtheadersmulttotalsshowas
Sheet: Commodity Analysis

 | Period | (Multiple Items) |  |  |  |  | Period | (Multiple Items)
 | Sum of Tons | Column Labels |  |  |  |  |  | Column Labels
 | Commodity | FY2011, YTD | FY2010, YTD | [NAME] | % Inc/Dec |  |  | 2011 |  |  | 2010
 | PHOSPHATE | 593248.79 | 518889.95 | 74358.84000000003 | 0.1433036812526433 |  | Row Labels | Sum of Tons | Sum of Tons2 | Sum of Tons3 | Sum of Tons | Sum of Tons2 | Sum of Tons3
 | SULFUR PRODUCTS | 69894.88 | 176839 | -106944.12 | -0.6047541549092678 |  | PHOSPHATE | 593248.79 |  |  | 518889.95 | -74358.84000000003 | -0.1253417474311242
 | RUBBER | 48307.54000000001 | 35424.58 | 12882.96000000001 | 0.3636729073428677 |  | SULFUR PRODUCTS | 69894.88 |  |  | 176839 | 106944.12 | 1.530070872143997
 | SCRAP STEEL PRODUCTS | 38529.62 | 29248 | 9281.620000000003 | 0.3173420404814005 |  | RUBBER | 48307.54000000001 |  |  | 35424.58 | -12882.96000000001 | -0.2666863185332974
 | ORE, MICA, SCHIST | 23148.3 |  | 23148.3 | N/A |  | SCRAP STEEL PRODUCTS | 38529.62 |  |  | 29248 | -9281.620000000003 | -0.240895705693438
 | METAL PRODUCTS (EXCL SCRAP) | 21924.01 | 12169.65 | 9754.359999999999 | 0.8015316792183833 |  | ORE, MICA, SCHIST | 23148.3 |  |  |  | -23148.3 | -1
 | OTHER BULK | 15728.49 |  | 15728.49 | N/A |  | METAL PRODUCTS (EXCL SCRAP) | 21924.01 |  |  | 12169.65 | -9754.359999999999 | -0.4449167830155158
 | MILITARY | 2939.14 | 612 | 2327.14 | 3.802516339869281 |  | OTHER BULK | 15728.49 |  |  |  | -15728.49 | -1
 | FOREST PRODUCTS | 1134.02 | 7518.530000000001 | -6384.51 | -0.8491699840261328 |  | MILITARY | 2939.14 |  |  | 612 | -2327.14 | -0.7917758255816327
 | OTHER BREAKBULK | 118.6 | 136.49 | -17.89000000000001 | -0.1310718733973186 |  | FOREST PRODUCTS | 1134.02 |  |  | 7518.530000000001 | 6384.51 | 5.62998007089822
 | URAN FERTILIZER |  |  | 0 | N/A |  | OTHER BREAKBULK | 118.6 |  |  | 136.49 | 17.89000000000001 | 0.1508431703204048
 | POTASH |  |  | 0 | N/A |  | Grand Total | 814973.3900000001 |  |  | 780838.2 | -34135.19000000018 | -0.04188503627093907
 | Total YTD | 814973.3900000001 | 780838.2 | 34135.19000000003 | N/A
 |  |  |  |  |  |  | Hi [NAME]
 |  |  |  |  |  |  | I copied and pasted your data on MHC to Sheet2
 |  |  |  |  |  |  | and did the above pivot table again..
 |  |  |  |  |  |  | Bring up the Field list and click on both [NAME]
 |  |  |  |  |  |  | Why Values shows on mine and not on yours is a mystery to me.
 |  |  |  |  |  |  | My above Pivot Table has multiple Sum of the same field
 |  |  |  |  |  |  | Then deep in the menu's is Show As - it is easier in 2010 Excel
 |  |  |  |  |  |  | Hope my example is what you want.
 |  |  |  |  |  |  | I'd Hide the Blank Columns on my sheet to make it viewable.
Spreadsheet: 541532d1507348989-annoying-drop-down-box-dnr-dropdown
Sheet: Sheet1

Growers1 | Fields
Client1 | hello | asd | a | 324 | 4 | 23 | 23 | 2 | 234
Client2
Client3
client4
Client5
Client6 | dsd | sfdsd | s | 2 | 32 | 32 | 23 | dsff | 2 | 23
Client7
 | dfsdf | e | 34 | 3423 | 7 | 567 | 5 | 56 | 6 | 6 | 56
 | sdfsd | sdj | cc | ghj | gg | gd | ss | e | fg |  |  | fg
 | sff | fsf | d | s |  | sd | 5555 | df | sf | s |  | df
 | sdfsd | df | 34 | 2344 | 675 | 8567
 | 2433 | 234 | 234 | 2 | fas | sdas
Spreadsheet: 440232d1452703404-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2016
Sheet: April

Employee Absence Schedule
April | Dates of Absence
Employee Name | 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 |  | Total Hours
A
B
C
D
E
F
G
H
J
K
L
N
O
Spreadsheet: 456405d1460832136-for-excel-to-automatically-add-in-a-line-if-customer-places-bigger-order-johntopley5
Sheet: Sheet1

CABINETS | MODEL | COLOR | PRICE/EACH | QUANTITY | TOTALS | Column1
 |  |  |  |  |  | Coffee
BASE | B12 |  |  | 2
BASE SINK | SB33 |  |  | 0
BASE SINK | SB33 |  |  | 0
BASE | B09 |  |  | 0
BASE | B15 |  |  | 0
BASE | B15 |  |  | 0
BASE | B18 |  |  | 0
BASE | B33 |  |  | 0
BASE | B18 |  |  | 0
PANTRY | PC24 |  |  | 0
WALL | W15 |  |  | 0
BASE | B12 |  |  | 0
BASE | LAZY2 |  |  | 0
BASE | B09 |  |  | 0
 |  |  |  | SUBTOTAL
 |  |  |  | DISCOUNT - | 0.1
 |  |  |  | TAX
 |  |  |  | TOTAL
Spreadsheet: 80371d1280533019-lookup-or-match-index-archery_again-2
Sheet: Input sheet

 | Bow | Category | Round | Score |  | Classification |  | F-Row | L-Row | Col | Match
 | Recurve | Gentlemen | York | 890 |  | #N/A |  | #N/A | #N/A | 4 | #N/A
 | Archery classifications explained.
 | Every time you shoot one of the 59 rounds (which vary in the numbers of arrows, distance, and target size) in addition to a handicap score you earn a classification. They Range from Grand Master Bowman (GMB) to unclassified. You need to achieve or exceed a particular score to get the respective classification.  Some rounds are less demanding and the higher classification cannot be earned by shooting them.  There are 40 Categories of archer depending on age, gender and bow type with varying ‘thresholds’ for the awards.
 | In the table for example looking at the recurve gents ‘Hereford Round’ |  |  |  |  |  |  | Score | Clasification
 |  |  |  |  |  |  |  | 900 | 1st class |  | Bows | Categories
 |  |  |  |  |  |  |  | 883 | 2nd class |  | Recurve Compound | Ladies
 |  |  |  |  |  |  |  |  |  |  | Compound | J Ladies U-18
 |  |  |  |  |  |  |  |  |  |  | [NAME] | J Ladies U-16
 |  |  |  |  |  |  |  |  |  |  | Barebow | J Ladies U-14
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-12
 |  |  |  |  |  |  |  |  |  |  |  | Gentlemen
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-18
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-16
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-14
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-12
Spreadsheet: 761070d1640620990-income-by-location-sumproduct-room-rental-income
Sheet: Sheet1

 | Check-In Date | Check-Out Date | Rate per day | Site |  | INCOME
 | 2021-02-16 00:00:00 | 2021-07-15 00:00:00 | 50 | Room C |  | Month | Room A | Room B | Room C | Room D
 | 2021-02-18 00:00:00 | 2021-05-08 00:00:00 | 90 | Room A |  | 2021-01-31 00:00:00
 | 2021-03-27 00:00:00 | 2021-06-27 00:00:00 | 50 | Room C |  |  | 990 |  | 650 |  |  | Feb 21 - Room A
 | 2021-04-01 00:00:00 | 2021-04-12 00:00:00 | 50 | Room A |  |  |  |  |  |  |  | Only Data in ROW4 has dates that Fall in February AND Room A
 | 2021-04-17 00:00:00 | 2021-10-05 00:00:00 | 40 | Room D |  |  |  |  |  |  |  | ** Number of dates in February = 11; Rate = 90; Total to be entered in H5 = (11*90) = 990
 | 2021-04-23 00:00:00 | 2021-06-03 00:00:00 | 35 | Room B
 | 2021-04-28 00:00:00 | 2021-07-03 00:00:00 | 20 | Room B |  |  |  |  |  |  |  | Feb 21 - Room C
 | 2021-05-24 00:00:00 | 2021-11-29 00:00:00 | 40 | Room B |  |  |  |  |  |  |  | Only Data in ROW3 has dates that Fall in February AND Room C
 | 2021-09-06 00:00:00 | 2021-10-10 00:00:00 | 30 | Room C |  |  |  |  |  |  |  | ** Number of dates in February = 13; Rate = 50; Total to be entered in H5 = (13*50) = 650
 | 2021-10-07 00:00:00 | 2021-10-11 00:00:00 | 100 | Room A
 | 2021-10-09 00:00:00 | 2021-12-28 00:00:00 | 50 | Room B
 | 2021-10-09 00:00:00 | 2021-12-25 00:00:00 | 50 | Room D
 | 2021-11-10 00:00:00 | 2021-11-13 00:00:00 | 90 | Room D
 | 2021-11-18 00:00:00 | 2021-11-29 00:00:00 | 40 | Room B
 | 2021-12-11 00:00:00 | 2021-12-25 00:00:00 | 75 | Room D |  | Columns B-E is Raw Data. Columns H-K is calculated Data.  If a checkin and checkout data falls in a particular month, the number of days in that month should be counted and multiplied by the Rate per day for that specific Room.
 | 2021-12-16 00:00:00 | 2021-12-31 00:00:00 | 35 | Room A
 | 2021-12-28 00:00:00 | 2022-01-01 00:00:00 | 75 | Room C
 | 2021-12-30 00:00:00 | 2021-12-31 00:00:00 | 40 | Room B
Spreadsheet: 329978d1404474233-if-statements-sample
Sheet: Sheet1

Item | Staff | Group | Value | Status
A | Zak | USG | 3098.634
B | Zak | MSG | 3133.963
E | Zak | LKP | 3234.873
F | Zak | ERP | 3246.239
G | Zak | THN | 3239.249
H | Zak | USG2 | 3189.453
J | Zak | TSG2 | 3086.576
K | Zak | HJG2 | 3025.664
L | Zak | TUG | 3066.468
M | Zak | EFG | 3136.902
N | Zak | CVG | 3025.771
P | Zak | USG | 3109.814
V | Zak | MSG | 3228.03
W | Zak | TSG | 3281.61
A | Zak | HJG | 3113.525
B | DI | LKP | 3055.938
C | DI | ERP | 3077.635
D | DI | THN | 3128.622
E | DI | USG2 | 3000.447
F | DI | ERP3 | 3058.526
S | DI | TSG2 | 3068.039
A | MO | HJG2 | 3066.468
E | MO | TUG | 3136.902
F | MO | EFG | 3025.771
G | MO | CVG | 3077.635
H | MO | USG2 | 3128.622
I | MO | ERP3 | 3000.447
M | MO | TSG2 | 3058.526
Q | MO | HJG2 | 3068.039
L | MO | TUG | 3125.777
T | MO | LPG | 3148.113
V | MO | KMG | 3054.485
W | MO | FLG | 3078.543
N | MO | CLG | 3013.273
X | MO | SDG | 3017.519
Y | MO | NBG | 3002.292
I | MO | HBG | 3072.569
M | MO | AFG | 3071.095
Q | MO | XDG | 2988.049
A | SAM | USG | 3113.084
B | SAM | MSG | 3080.999
C | SAM | TSG | 3071.174
D | SAM | HJG | 3061.787
E | SAM | LKP | 3063.071
F | SAM | ERP | 3064.486
G | SAM | THN | 3189.453
H | SAM | USG2 | 3062.979
I | SAM | ERP3 | 3007.711
J | SAM | TSG2 | 3025.664
K | SAM | HJG2 | 3066.468
L | SAM | TUG | 3036.953
M | SAM | EFG | 3025.771
N | SAM | CVG | 3109.814
P | SAM | ERP3 | 3095.98
Q | SAM | TSG2 | 3115.365
R | SAM | HJG2 | 3113.525
T | SAM | TUG | 3055.938
XY | SAM | LPG | 3056.938
WK | SAM | KMG | 3057.938
Spreadsheet: 0abff8d9-b9c1-47e4-a0de-889fc22bc7ab
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In U.S. Dollars and Futures Equivalent Contracts
 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 1.2 | -0.4 | 0.8 | 53 | -19 | 34
Coffee | 5.5 | -2.4 | 3.1 | 72 | -32 | 40
Copper | 10.7 | -3.9 | 6.7 | 110 | -41 | 69
Corn | 19.5 | -7.5 | 12 | 607 | -229 | 378
Cotton | 5.2 | -2 | 3.2 | 114 | -44 | 70
[NAME] | 0.8 | -0.3 | 0.6 | 11 | -4 | 7
Gold | 24 | -5.8 | 18.1 | 140 | -34 | 106
Heating Oil | 11 | -2.8 | 8.2 | 82 | -21 | 61
[NAME] | 5.3 | -2 | 3.3 | 143 | -55 | 87
Live Cattle | 9.3 | -3 | 6.3 | 180 | -58 | 122
Natural Gas | 16.1 | -5 | 11.1 | 581 | -187 | 394
Platinum | 0.7 | -0.2 | 0.5 | 9 | -2 | 6
RBOB Unleaded Gas | 12.3 | -2.9 | 9.4 | 92 | -22 | 71
Silver | 7.3 | -2.1 | 5.2 | 42 | -13 | 30
Soybean Meal | 1 | -0.1 | 0.9 | 29 | -4 | 25
Soybean Oil | 5.6 | -2 | 3.7 | 172 | -60 | 112
Soybeans | 17.8 | -5.8 | 12 | 271 | -89 | 182
Sugar | 11.2 | -3.9 | 7.3 | 405 | -140 | 266
Wheat (CBOT) | 14.2 | -6.8 | 7.3 | 418 | -204 | 214
Wheat (KCBT) | 1.8 | -0.6 | 1.2 | 50 | -17 | 33
WTI Crude Oil | 59.1 | -19.7 | 39.4 | 553 | -184 | 369
Subtotal (>0.5 billion US$) | 239.6 | -79.4 | 160.2
Subtotal (<0.5 billion US$) | 1 | -0.2 | 0.8
Total Notional US Mkts | 240.6 | -79.7 | 161
Total Not'l Non-US Mkts | 69.4 | -20.5 | 48.9
Total All Markets | 310 | -100.2 | 209.9
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with 0.5 billion US dollars or more in reported net index investment notional value on the report date.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: 1f0f51f5-c210-458c-a5c4-9fee98337908
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
 | ACADEMIC GRADUATION PLANNING SCHEDULE
 | NAME: | SMITH |  |  | WILLIAM |  |  | J
 |  | Last |  |  | First |  |  | Middle
 | University: | Florida A&M University
 | Student ID#:
 | Major: | INTERNATIONAL AFFAIRS
 | YEAR: | 2008 |  |  | TERM: | FALL
 |  |  |  |  |  |  |  |  |  | 1) FILL OUT ALL OF THE INFORMATION IN THE FIELDS
 | COURSE # |  | COURSE NAME |  |  |  | CREDIT HOURS
 | NSC1110 |  | INTRO TO NAVAL ORG |  |  |  | 3
 | [NAME] |  | FRESH COMP & RHETORIC |  |  |  | 3 |  |  | 2) CHECK TO MAKE SURE ALL OF THE INFORMATION IS CORRECT
 | AMH1000 |  | AMERICAN CIVILIZATION |  |  |  | 3
 | PSY2012 |  | GENERAL PSYCHOLOGY |  |  |  | 3
 | MAC1120 |  | PRE-CALCULUS ALGEBRA |  |  |  | 3 |  |  | 3)  CLICK "FILE" THEN "SAVE AS" AND SAVE THE FILE
 |  |  |  |  |  |  |  |  |  | AS "GRAD PLAN YOUR LAST NAME"
 |  |  |  |  |  |  |  |  |  |  |  | ex: GRAD PLAN SMITH
 | TOTAL CREDIT HOURS: |  |  |  |  |  | 15 |  |  | 4)  YOU ARE REQUIRED TO TAKE 15-18 CREDIT HOURS
 |  |  |  |  |  |  |  |  |  | PER SEMESTER.  A CHIT IS REQUIRED FOR ANY
 | YEAR: | 2009 |  |  | TERM: | SPRING |  |  |  | MORE OR LESS.
 | COURSE # |  | COURSE NAME |  |  |  | CREDIT HOURS
 | CHM1045C |  | GENERAL CHEMISTRY I |  |  |  | 4
 | ENC1102 |  | FRESH WRITING RESEARCH |  |  |  | 3
 | MAC2311 |  | CALC W/ ANLYT GEOMETRY I |  |  |  | 3
 | HUM3321 |  | MULTICULTURAL FILM |  |  |  | 3
 | CLT3378 |  | ANCIENT MYTHOLOGY EAST & WEST |  |  |  | 3
 | TOTAL CREDIT HOURS: |  |  |  |  |  | 16
 | [NAME] SIGNATURE:
 |  |  |  |  |  | DATE:
 | NROTC ADVISOR'S SIGNATURE:
 |  |  |  |  |  | DATE:
Spreadsheet: 733287d1621490391-help-with-formula-to-extract-multiple-values-from-table-test-workbook
Sheet: Table

 |  | Framer
Address | Job# | Framer | Start | Finish | Bricky | Actual start | Actual Finish
123 Sample St | 1234 | Mark | 2018-04-04 00:00:00 | 2018-04-11 00:00:00 | [NAME] | 2018-04-30 00:00:00 | 2018-05-11 00:00:00
Test st 1 |  | Ian | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | [NAME] | 2021-06-01 00:00:00 | 2021-06-10 00:00:00
Test st 2 |  | [NAME] | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | [NAME] | 2021-06-02 00:00:00 | 2021-06-11 00:00:00
Test st 3 |  | Mark | 2021-05-13 00:00:00 | 2021-05-20 00:00:00 | [NAME] | 2021-06-06 00:00:00 | 2021-06-20 00:00:00
test st 4 |  | Mark | 2021-05-21 00:00:00 | 2021-05-28 00:00:00 | [NAME] | 2021-06-15 00:00:00 | 2021-06-30 00:00:00
Test st 5 |  | Ian | 2021-05-18 00:00:00 | 2021-05-23 00:00:00 | [NAME] | 2021-06-07 00:00:00 | 2021-06-20 00:00:00
Spreadsheet: 214903d1361184490-how-to-catalogue-multiple-data-multiple-data
Sheet: INPUT

name | price | qty | value
name 1 | 2 | 50 | 100
name 1 | 2 | 20 | 40
name 2 | 1 | 30 | 30
name 3 | 5 | 10 | 50
Spreadsheet: 1b056794-bc00-4380-a96e-741bab531f36
Sheet: Sheet1

SBA PHYSICAL DISASTER SURVEY SHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
[NAME]: |  |  |  |  |  |  | Date of Damage:
Address:
Present Telephone Number: |  |  | Area Code | Telephone |  |  | Type of Disaster:
Name of Property Owner:
Type of Applicant or |  |  | Renter: |  | Homeowner: |  | Other:
Structure: |  |  | Single Family: |  | Business:
 |  | Place a check mark | Multiple Family: |  | Nonprofit:
2. MARKET VALUE OF PROPERTY-Please provide fair market value (FMV) pre-disaster or
fair replacement value.  Use whichever is lower.
STRUCTURE (includes total cost to replace primary buildings)
 |  | Home, mobile home, business structure
 |  | detached garage, storage building, other
CONTENTS (includes total cost to replace personal/business property)
 |  | Personal - clothing, furniture, household, appliances, other
 |  | Business - machinery, equipment, inventory, other
LAND AND IMPROVEMENTS (includes total cost to replace/repair damage to land)
 |  | Land + Access road, bridge, driveway, sidewalk, parking lot, fencing,
 |  | landscape, utilities, sewer lines, debris removal/other.
Name - Phone No. of Insurance Co./Agent
3. ESTIMATED DISASTER LOSS IN DOLLARS
 |  |  |  |  |  | Structures
 |  |  |  |  |  | Contents
 |  |  |  |  |  | Land and Improvements
4. AMOUNT OF INSURANCE
 |  |  |  |  |  | Structure
 |  |  |  |  |  | Contents
 |  |  |  |  |  | Land and Improvements
5. DOLLAR AMOUNT OF UNINSURED LOSS
 |  | (Estimated Disaster Loss) (3) - (Amount of Insurance) (4) = Total
 |  |  |  |  |  | Structure |  | 0
 |  |  |  |  |  | Contents |  | 0
 |  |  |  |  |  | Land and Improvements |  | 0
 |  |  |  |  |  |  | TOTAL | 0
6. PERCENT OF UNINSURED LOSS (5) [NAME]) = % UNINSURED LOSS
 |  | Dollar Amount of Uninsured Loss divided by Fair Market/Replacement Value.
Structure | Paragraph (5) | 0 | Divided By [NAME] (2) | 0 | = |  | % Uninsured Loss
Contents | Paragraph (5) | 0 | Divided By [NAME] (2) | 0 | = |  | % Uninsured Loss
Land & Improvements | Paragraph (5) | 0 | Divided By [NAME] (2) | 0 | = |  | % Uninsured Loss
Use one with largest percentage
7. COMMENTS: Provide details of loss,[NAME] and Bedrooms destroyed. Continue on reverse side if necessary.
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0113

01/13/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 10 | 7 |  |  |  |  | 86 | 2 | reporting | 6.25 | 13.76
 | Dustin |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Sharron | 3 | 27 | 5 |  |  |  |  | 127 |  |  | 9.25 | 13.72972972972973
 | Roxy |  | 20 | 6 |  |  |  |  | 108 |  |  | 8 | 13.5
 | [NAME] |  |  | 1 |  |  | 15 | 1 | 136 |  |  | 8 | 17
 | Ana | 1 | 3 | 16 |  |  |  |  | 139 |  |  | 8.25 | 16.84848484848485
 |  |  |  |  |  |  |  |  | 0
 | [NAME] |  | 27 | 7 |  |  |  |  | 137 | 0.5 | CISS | 8.25 | 16.60606060606061
 | Petra | 1 |  |  |  | 1 | 7 | 6 | 108 | 3.25 | RSRCH | 8.75 | 12.34285714285714
 | Regina |  |  |  |  |  | 12 |  | 96 | 5 | SWT | 4.75 | 20.21052631578947
 | Noy | 1 |  |  |  | 1 | 7 | 1 | 68 | 2.5 | SWT | 6.25 | 10.88
 | [NAME] |  |  |  |  | 26 | 7 |  | 108 |  |  | 9.75 | 11.07692307692308
 | [NAME] | 16 | 9 |  |  |  |  |  | 59 |  | SME | 2.75 | 21.45454545454545
 | Michelle |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Keisha |  |  |  |  |  |  |  | 0.01 |  | cpu down | 0.01 | 1
 | [NAME] |  | 44 | 7 |  |  |  |  | 188 |  |  | 11.75 | 16
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 170.4091271743903
 | TASK VOLUME: | 22 | 140 | 49 | 0 | 28 | 48 | 8 | 1360 | 13.25 |  | 92.03 | 14.7777898511355
 | Pts Earned: | 44 | 420 | 392 | 0 | 56 | 384 | 64
 |  |  |  |  |  |  |  | Average PTS | 85.001875 |  | Total Task Volume |  | 295
 | MID-DAY PPH
Spreadsheet: 27315d1220475479-search-for-stack-number-using-input-ics
Sheet: data sheet

Stack # | Date made on SM | SM | Intermediate Product # | Actual Piece count at SM | Date stack went into AC | AC # stack went in | Date Stack came out of AC | Date stack went onto Finishing line | CL | Actual Piece count at Finishing | # of tickets assigned to Stack | made on SM | in AC | out of AC | on CL | on Finished good pallet | [NAME] | Comments
123456 | 2008-08-19 00:00:00 | 1 | 215518 | 96 | 2008-08-20 00:00:00 | 4 | 2008-08-20 00:00:00 | 2008-08-23 00:00:00 | 1 | 96 | 2 | 96 | 96 | 96 | 96 | 96 | 0
123457 | 2008-08-20 00:00:00 | 1 | 215518 | 96 | 2008-08-21 00:00:00 | 4 | 2008-08-21 00:00:00 | 2008-08-23 00:00:00 | 1 | 96 | 2 | 96 | 96 | 96 | 96 | 96 | 0
123458 | 2008-08-20 00:00:00 | 1 | 215518 | 96 | 2008-08-21 00:00:00 | 4 | 2008-08-21 00:00:00 | 2008-08-23 00:00:00 | 1 | 95 | 2 | 96 | 96 | 96 | 95 | 95 | 1 | Took 1 piece for QC sample
Spreadsheet: 156682d1337380292-calculate-number-of-days-depending-on-some-date-criteria-dates-in-between-eot
Sheet: Sheet1

 |  |  |  | Period Extension of Time (EOT)>> |  |  | Start | End | Total EOT
 |  |  | Need Formula here. |  |  |  | 2011-01-02 00:00:00 | 2011-02-17 00:00:00 | 46
NAME | MOB | DEMOB | EOT Days
[NAME] | 2010-09-01 00:00:00 | 2011-01-31 00:00:00 | 29 | Partly within the period of Start/End.
Gray | 2010-09-01 00:00:00 | 2011-02-25 00:00:00 | 46 | It is within the period of Start/End.
[NAME] | 2011-05-16 00:00:00 | 2012-02-15 00:00:00 | 0 | Beyond the period of Start/End
[NAME] | 2010-08-25 00:00:00 | 2011-03-15 00:00:00 | 46 | It is within the period of Start/End.
[NAME] | 2010-12-01 00:00:00 | 2011-05-02 00:00:00 | 46 | It is within the period of Start/End.
June | 2010-06-01 00:00:00 | 2010-11-10 00:00:00 | 0 | Before the period of Start/End.
Colins | 2010-12-05 00:00:00 | 2011-02-15 00:00:00 | 44 | Within the period of Start/End.
[NAME] | 2010-09-01 00:00:00 | 2011-01-15 00:00:00 | 13 | Partly within the period of Start/End.
Spreadsheet: 99445d1298056578-predetermined-sliding-scale-book2
Sheet: Sheet1

type | A | B | C
Total # of users | photoshop | Illustrator | Photoshop + Illustrator
0 - 9 | 12 | 11 | 20
10 - 39 | 11 | 10 | 19
40 - 79 | 10 | 9.5 | 18.5
80 - 149 | 9 | 9 | 16
150 - 229 | 8 | 7.5 | 13
230 - 349 | 7 | 6 | 10
350 - 499 | 6 | 3 | 9
500 - 749 | 5 | 2 | 8
750 - 999 | 4 | 1.5 | 7
 |  | Sept
 |  | Users
Mo | All | 52 | Total user Usage % | Pays # of mo | Pay for  # of users | User Cost
Project A | C | 150 |  |  |  |  | 2516.48
Project B | C | 8 |  |  |  |  | 206.48
Project C | B | 10 |  |  |  |  | 129.05
Project D | A | 11 |  |  |  |  | 156.15
total P Users
total all
Spreadsheet: 83968d1283979120-if-statements-for-time-lunch-time
Sheet: Blad1

Lunch time between
12:00:00 | 12:30:00
Start | End |  | Total |  |  |  |  | Total
Work |  |  | Lunch time |  |  |  |  | Work
07:00:00 | 21:00:00 |  | 0.5000000000000009 | '=(MIN(B6;$B$3)-MAX($A$3;A6))*24 |  |  |  | 13.5
12:30:00 | 15:00:00 |  | 0 |  |  |  |  | 2.499999999999999
11:00:00 | 12:45:00 |  | 0.5000000000000009 |  |  |  |  | 1.25
10:00:00 | 14:00:00 |  | 0.5000000000000009 |  |  |  |  | 3.499999999999999
11:45:00 | 12:45:00 |  | 0.5000000000000009 |  |  |  |  | 0.4999999999999996
Or with the formula from arthurbr
07:00:00 |  |  |  |  |  |  |  | 13:30:00
21:00:00
12:30:00 |  |  |  |  |  |  |  | 02:30:00
15:00:00
11:00:00 |  |  |  |  |  |  |  | 01:15:00
12:45:00
10:00:00 |  |  |  |  |  |  |  | 03:30:00
14:00:00
11:45:00 |  |  |  |  |  |  |  | 00:30:00
12:45:00
Spreadsheet: 845095d1696631660-formula-to-add-numbers-in-a-column-adding-the-new-line-each-time-diesel-data
Sheet: Diesel

Date | Odometer | [NAME] | Gallons Purchased | $ Purchased | Miles/Gallon | Total Miles Driven
2023-09-30 00:00:00 | 3088.1 |  | 152.851 | 625.5
2023-10-02 00:00:00 | 3582.7 |  | 100.146 | 395.48
2023-10-03 00:00:00 | 3872.2 |  | 56.36 | 247.93
2023-10-04 00:00:00 | 4119.6 |  | 43.746 | 183.5