tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814289d1674254738-formula-to-calculate-up-to-a-number-then-back-to-zero-game-stats-3
Sheet: Sheet2

0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
LEZ | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | M | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | REZ
LEZ0 | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | L8 | L9 | L10 | L11 | L12 | [NAME] | [NAME] | L15 | L16 | L17 | L18 | L19 | L20 | [NAME] | L22 | [NAME] | L24 | [NAME] | L26 | L27 | L28 | L29 | L30 | [NAME] | L32 | [NAME] | L34 | L35 | [NAME] | L37 | L38 | L39 | L40 | [NAME] | L42 | [NAME] | L44 | L45 | L46 | L47 | L48 | L49 | M50 | R49 | R48 | R47 | R46 | R45 | R44 | R43 | R42 | R41 | R40 | R39 | R38 | R37 | R36 | R35 | R34 | R33 | R32 | R31 | R30 | R29 | R28 | R27 | R26 | R25 | R24 | R23 | R22 | R21 | R20 | R19 | R18 | R17 | R16 | R15 | R14 | R13 | R12 | R11 | R10 | R9 | R8 | R7 | R6 | R5 | R4 | R3 | R2 | R1 | REZ0
Spreadsheet: 878760d1726045457-referencing-multiple-sheet-inorder-to-create-pt-ekac-pl2-spill-indirect-365-aligw
Sheet: Result

Sheet Name > | [NAME]
Subject > | Science
Above amount > | 1000
 | Step 1 |  |  |  | Step 2 |  | Step 3
 |  |  |  |  | Adding unique |  | filtering >1000 based on Name
 |  |  | >>>>> | Name | Marks | >>>>> | Name | ID | Marks
 |  |  |  | Shweta |  |  | Shweta | 74
 |  |  |  | Check | 192
Spreadsheet: 850338d1700689553-dynamic-calendar-calendar-2024-landscape-year-at-a-glance
Sheet: Raw Data

Date | Category | Code
2023-01-01 00:00:00 | Hotel | HTL
2023-01-02 00:00:00 | Hotel | HTL
2023-02-12 00:00:00 | Dubai Trip | TRP
2023-02-13 00:00:00 | Dubai Trip | TRP
2023-02-14 00:00:00 | Dubai Trip | TRP
2023-02-15 00:00:00 | Dubai Trip | TRP
2023-02-16 00:00:00 | Dubai Trip | TRP
2023-03-06 00:00:00 | Outing | OUT
2023-04-28 00:00:00 | Wedding | WED
Spreadsheet: 78537d1278939480-weighted-average-excel-forum-weighted-average
Sheet: Sheet1

col 1 | col 2 | col 3
2 | 34 | 0
2 | 35 | 1
2 | 36 | 2 |  |  | 2 | 35
1 | 22 | 3
1 | 21 | 3
1 | 20 | 4 |  |  | 1 | 21
3 | 67 | 5
3 | 67 | 6
3 | 65 | 6 |  |  | 1 | 66.33
2a | 36 | 7
2a | 37 | 9 |  |  | 2 | 36.5 |  |  | Average of col 2 | col 3
 |  |  |  |  |  |  |  |  | col 1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 9 | Grand Total
 |  |  |  |  |  |  |  |  | 1 |  |  |  | 21.5 | 20 |  |  |  |  | 21
 |  |  |  |  |  |  |  |  | 2 | 34 | 35 | 36 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 67 | 66 |  |  | 66.33333333333333
 |  |  |  |  |  |  |  |  | 2a |  |  |  |  |  |  |  | 36 | 37 | 36.5
 |  |  |  |  |  |  |  |  | Grand Total | 34 | 35 | 36 | 21.5 | 20 | 67 | 66 | 36 | 37 | 40
Question regarding to weighted Average - Excel Help Forum
Spreadsheet: 785609d1656513107-googlesheets-ifvlookup-on-different-sheet-with-result-of-y-this-also-works-aligw
Sheet: Sheet2

 |  | Colomn B result shall be :
adam | ? | Y
kjhg | ?
ikjn | ?
kilo | ? | Y
jhg | ? | Y
hjk | ?
seda | ? | Y
[NAME] | ? | Y
Spreadsheet: 151756d1335107858-calculate-cost-with-three-variables-water-cost
Sheet: Sheet1

 | Month | Cost | Commulative | Cost
 | Jan | 5284 | 5284 | 5039.56
 | Feb | 3250 | 8534 | 2402.2
 | Mar | 2464 | 10998 | 1576.960000000001
 | Apr | 5000 | 15998 | 3200
 | May | 4000 | 19998 | 2559.999999999998
Spreadsheet: 850469d1700810795-help-with-countif-based-on-criteria-count-basis-aligw
Sheet: Sheet1

 |  | Item | Count Of Item | Incremental Count
 |  | 86
 |  | 503
 |  | 142
 |  | 216
 |  | 125
 |  | 173
 |  | 35
 |  | 434
 |  | 627
 |  | 377
 |  | 508
 |  | 374
 |  | 374
 |  | 374
 |  | 321
 |  | 321
 |  | 321
 |  | 9
 |  | 141
 |  | 109
Spreadsheet: 66452965-05a4-4b8f-9323-160ba494f684
Sheet: Sheet1

Table 4--Wheat: Monthly food disappearance estimates (1,000 grain-equivalent bushels), 4/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/
 |  |  | Wheat ground for flour | + | Food imports 2/ | + | Nonmilled food use 3/ | - | Food exports 2/ | = | Food use 4/
2011/12 | Jun |  | 70554 |  | 2237 |  | 2000 |  | 1743 |  | 73048
 | Jul |  | 72573 |  | 2098 |  | 2000 |  | 1326 |  | 75344
 | Aug |  | 79317 |  | 2308 |  | 2000 |  | 2390 |  | 81235
 | Sep |  | 76269 |  | 2245 |  | 2000 |  | 1652 |  | 78863
 | Oct |  | 81402 |  | 2246 |  | 2000 |  | 1487 |  | 84162
 | Nov |  | 77915 |  | 2568 |  | 2000 |  | 1763 |  | 80720
 | Dec |  | 73135 |  | 2464 |  | 2000 |  | 1291 |  | 76308
 | Jan |  | 74522 |  | 2583 |  | 2000 |  | 1280 |  | 77826
 | Feb |  | 73931 |  | 2056 |  | 2000 |  | 1336 |  | 76650
 | Mar |  | 78437 |  | 2556 |  | 2000 |  | 1764 |  | 81230
 | Apr |  | 74497 |  | 2621 |  | 2000 |  | 1506 |  | 77613
 | May |  | 76171 |  | 2527 |  | 2000 |  | 2342 |  | 78355
2012/13 | Jun |  | 72876 |  | 2178 |  | 2000 |  | 1724 |  | 75330
 | Jul |  | 75861 |  | 2295 |  | 2000 |  | 2906 |  | 77250
 | Aug |  | 82910 |  | 2345 |  | 2000 |  | 2187 |  | 85069
 | Sep |  | 79725 |  | 2062 |  | 2000 |  | 2283 |  | 81504
 | Oct |  | 81567 |  | 2460 |  | 2000 |  | 1834 |  | 84194
 | Nov |  | 78073 |  | 2446 |  | 2000 |  | 1598 |  | 80920
 | Dec |  | 73283 |  | 2371 |  | 2000 |  | 1447 |  | 76207
 | Jan |  | 0 |  | 2191 |  | 0 |  | 1550 |  | 641
 | Feb |  | 0 |  | 2101 |  | 0 |  | 1674 |  | 427
1/ Current year is preliminary. Previous year is preliminary through August of current year, estimated afterwards. 2/ Food imports and exports used to calculate total food use. Includes all categories of wheat flour, semolina, bulgur, and couscous and selected categories of pasta. 3/ Wheat prepared for food use by processes other than milling.
4/ Estimated food use equals wheat ground for flour plus food imports plus nonmilled food use minus food exports. See http://www.ers.usda.gov/topics/crops/wheat/estimating-wheat-supply-and-use/food-use-estimates.aspx for more information. Source: Data through the 2nd quarter of 2011 was calculated using data from U.S. Department of Commerce, Bureau of the Census’ Flour Milling Products (MQ311A) and U.S. Department of Commerce, Bureau of Economic Analysis’ Foreign Trade Statistics. Subsequent flour milling calculations are based on data from the North American Millers Association.
Date run: 4/11/2013
Spreadsheet: 63808d1264679907-drop-menus-elseaccounts
Sheet: Lists

Else |  |  |  |  |  |  |  |  | Months
Income | Expenses |  |  |  |  |  |  |  | January
1 | 1 |  |  |  |  |  |  |  | February
2 | 2 |  |  |  |  |  |  |  | March
3 | 3 |  |  |  |  |  |  |  | April
4 | 4 |  |  |  |  |  |  |  | May
5 | 5 |  |  |  |  |  |  |  | June
6 | 6 |  |  |  |  |  |  |  | July
7 | 7 |  |  |  |  |  |  |  | August
8 | 8 |  |  |  |  |  |  |  | September
9 | 9 |  |  |  |  |  |  |  | October
10 | 10 |  |  |  |  |  |  |  | November
11 | 11 |  |  |  |  |  |  |  | December
12 | 12
13 | 13
14 | 14
15 | 15
16 | 16
17 | 17
18 | 18
19 | 19
20 | 20
21 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
Spreadsheet: 024f0463-c88e-4e6c-906d-6010e1e646e2
Sheet: Salaries

Service Center Calculations
Salaries & Benefits Expenditures
Purpose:  To list personnel paid on the service center and allocate personnel costs to each service.
Sheet Instructions
1) Only fill in the areas shaded in yellow
2) Fill in the name of the person(s) that is providing the service (board apptd only)
3) For TH employee costs you may put in a lump sum total for the estimated expenditures.
4) Fill in that person's PCN
5) Enter in the employee type |  | *<<Type is EX for exempt, CL for classified, TH for temporary help, or GA for graduate assistant>>
6) Enter in the employee's annual salary
7) Enter in the employee's annual FTE (0.5, 1, 0.75, etc.)
8) Enter in the FTE % of this employee's time associated with the service and this budget
 |  |  |  |  |  |  | SERVICE 1 |  | SERVICE 2
NAME | PCN | TYPE* | ANNUAL SALARY | FTE | FRINGES | TOTAL COST | FTE % | Amount | FTE % | Amount
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
TOTAL SALARIES
SUBSIDY - AMOUNT THAT WILL NOT BE CHARGED TO CUSTOMERS |  |  |  |  |  | 0 | 0 |  | 0
TOTAL SALARY COSTS CHARGED TO CUSTOMERS
Fringe Benefits* | Rate
Variable | 0.245
Fixed (Health) | 9100
TH | 0.0821
GA | 0.0038
*The FB rates can be modified if needed in this rate box
Spreadsheet: 275939d1383691941-index-formula-not-working-leavea
Sheet: Sheet2

Name | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 |  | 2013-02-03 00:00:00
#N/A | r | [NAME] | u | [NAME] | s
#N/A | r
#N/A | s
#N/A | u
#N/A | u
#N/A | r
#N/A | s
Spreadsheet: 821444d1678722472-lookup-part-of-text-in-excel-example
Sheet: Sheet2

 |  |  |  |  |  | PRICE LOOKUP TABLE
 | REF | CATEGORY | TRANSCATION DESCRIPTION | PRICE LOOKUP |  | Category | Item | Price
 | 001 | Car | [NAME] to John's Motors Ltd |  |  | Car | Wheel | 65
 | 002 | Motorbike | [NAME] in Warehouse |  |  | Car | Bearings | 62
 | 003 | Car | COGS Bearings |  |  | Car | [NAME] | 100
 | 004 | Motorbike | Transfer Wheel from Goods Inwards |  |  | Car | Tyre | 88
 | 005 | Car | Sold Chrome Wheel to Car Repair LLC |  |  | Motorbike | Wheel | 35
 | 006 | Car | [NAME] to Techno Repair |  |  | Motorbike | Tyre | 24
Spreadsheet: 57397d1257512424-line-graph-problem-rap-usage-tracker
Sheet: Lanwern

Tarmac - West Rap Usage tracker |  |  |  | Llanwern
 |  | 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 | 2010-01-01 00:00:00 | YTD Savings/ usage
 | Total RAP used |  | 180 | 270 | 213 | 278.27 | 252.2 | 409.57 | 269.1 | 769.73 | 1173.58
 | Total tonnage acceptable for RAP additon |  | 3356.64 | 2484.32 | 2373.03 | 2806.3 | 4530.3 | 3737.1 | 2179.7 | 4695.5 | 8227 |  |  |  | 34389.89
 | Target Addition (%) |  | 0.1 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18
 | Actual Addition (%) |  | 0.05362505362505363 | 0.1086816513170606 | 0.08975866297518362 | 0.09915903502832911 | 0.05566960245458358 | 0.109595675791389 | 0.1234573565169519 | 0.1639292940048983 | 0.1426498115959645
 | Benefit per tonne (£) | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72
 | Actual Total Benefit (£) | 0 | 3096 | 3095.14 | 2437.24 | 3182 | 2884.44 | 4687 | 3083.96 | 6615.12 | 11204.08 | 0 | 0 | 0 | 40284.98
 | Estimated Material with Rap Addition |  | 1800 | 1799.5 | 1417 | 1850 | 1677 | 2725 | 1793 | 3846 | 6514
 | [NAME] check |  | 180 | 269.925 | 212.55 | 277.5 | 251.55 | 408.75 | 268.95 | 692.28 | 1172.52
Spreadsheet: 856319d1705595385-automatic-formula-update-for-date-and-time-stamp-test
Sheet: Sheet1

Project | Opening Fiscal Year | Closing Fiscal Year | Amount |  | Sheet last updated:
A | FY17 | FY23 | 8.25
B | FY18 | FY27 | 10
C | FY19 | FY25 | 59.5
D | FY19 | FY25 | 150
E | FY19 | FY26 | 11.73
F | FY20 | FY25 | 2
G | FY20 | FY25 | 61.2
H | FY20 | FY26 | 75
I | FY20 | FY24 | 74.55
J | FY21 | FY27 | 0.98
K | FY21 | FY25 | 450
L | FY22 | FY28 | 8
M | FY23 | FY30 | 1.18
N | FY23 | FY24 | 83.33
Spreadsheet: 270546d1381517821-formula-for-ordering-inventory-based-on-maximum-allowed-product-example
Sheet: Sheet1

Min - Max Calculator |  |  |  |  | [NAME]-on hand
Min | [NAME] | Product |  | On Hand (LSG) | Need to Delivered ([NAME]) | Points
1 | 2 | APPLE JUICE  (ASEPTIC) |  | 0 |  | 7 | 0.36
1 | 2 | APPLE JUICE 11.5oz (CAN) |  | 1 |  | 8 | 0.41
1 | 2 | BLOODY [NAME] 11.5oz |  | 0 |  | 3 | 0.18
1 | 2 | CLUB SODA 12oz (CANADA DRY) -Blue Can |  | 0 |  | 6 | 0.32
1 | 4 | COKE 12oz |  | 1 |  | 20 | 0.95
0 | 0 | COKE ZERO 12oz |  | 0 |  | 0 | 0
1 | 2 | CRAN APPLE JUICE 11.5oz (CAN) |  | 0 |  | 13 | 0.65
1 | 4 | DIET COKE 12oz |  | 1 |  | 19 | 0.91
1 | 2 | DIET DR PEPPER 12oz |  | 1 |  | 9 | 0.48
1 | 3 | DIET PEPSI 12oz |  | 2 |  | 15 | 0.74
1 | 2 | DIET SIERRA MIST 12oz |  | 1 |  | 11 | 0.57
1 | 3 | DR PEPPER 12oz |  | 1 |  | 14 | 0.7
1 | 3 | GINGER ALE 12oz  (CANADA DRY) -Green Can |  | 1 |  | 18 | 0.87
0 | 0 | GINGER ALE 12oz  (SEAGRAMS) |  | 0 |  | 0 | 0
1 | 3 | ORANGE JUICE (ASEPTIC) |  | 1 |  | 17 | 0.83
1 | 3 | PEPSI 12oz |  | 1 |  | 16 | 0.78
1 | 2 | SIERRA MIST 12oz |  | 0 |  | 12 | 0.61
1 | 2 | SPRITE 12oz |  | 1 |  | 10 | 0.52
0 | 0 | SPRITE ZERO 12oz |  | 0 |  | 0 | 0
1 | 2 | TOMATO JUICE 11.5 oz (CANNED) |  | 1 |  | 4 | 0.26
1 | 2 | TONIC WATER 12oz (CANADA DRY) -Yellow Can |  | 0 |  | 5 | 0.3
1 | 2 | WATER .5 LT (NESTLE) |  | 0 |  | 2 | 0.17
1 | 6 | WATER 1LT (CRYSTAL GEYSER) |  | 4 |  | 21 | 1
1 | 1 | WATER 8oz (CRYSTAL GEYSER) |  | 0 |  | 1 | 0.13
 |  |  | needs to be 10 pallets
 |  | 0.619047619
Spreadsheet: 747185d1631273815-agent-state-vs-schedule-state-time-calculation-login-time-help
Sheet: Schedule States Report

Agent Check | Skill Region | Region | [NAME] | Other | Entity | Team | Employee ID | Agent | Date | [NAME] | Start Time | End Time | Duration | Paid Hours | Other2
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core | 08:00:00 | 09:30:00 | 01:30:00 | 01:30:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core Smart | 08:00:00 | 09:30:00 | 01:30:00 | 01:30:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | Break1 | 09:30:00 | 09:45:00 | 00:15:00 | 00:15:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core | 09:45:00 | 11:00:00 | 01:15:00 | 01:15:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core Smart | 09:45:00 | 11:00:00 | 01:15:00 | 01:15:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | [NAME]) | 11:00:00 | 12:00:00 | 01:00:00 | 01:00:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core | 12:00:00 | 13:15:00 | 01:15:00 | 01:15:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core Smart | 12:00:00 | 13:15:00 | 01:15:00 | 01:15:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | Training | 13:15:00 | 13:45:00 | 00:30:00 | 00:30:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core | 13:45:00 | 14:30:00 | 00:45:00 | 00:45:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core Smart | 13:45:00 | 14:30:00 | 00:45:00 | 00:45:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | Break2 | 14:30:00 | 14:45:00 | 00:15:00 | 00:15:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core | 14:45:00 | 15:15:00 | 00:30:00 | 00:30:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | C_Core Smart | 14:45:00 | 15:15:00 | 00:30:00 | 00:30:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] | 2021-08-31 00:00:00 | Annual Unauth - Half | 15:15:00 | 16:30:00 | 01:15:00 | 01:15:00
 |  |  |  |  |  | C_CCC ECP Team - Jane | 5555 | [NAME] |  |  |  |  | 08:30:00 | 08:30:00 | Total for Agent:
Spreadsheet: 841663d1693839063-date-and-time-matching-between-2-sheets-desired-result
Sheet: Sheet1

Date | Time | Value | Desired result
2023-08-02 00:00:00 | 20:15:00.000000 | 35412
2023-08-02 00:00:00 | 20:16:00.000000 | 35412
2023-08-02 00:00:00 | 20:17:00.000000 | 35410
2023-08-02 00:00:00 | 20:18:00.000000 | 35411
2023-08-02 00:00:00 | 20:19:00.000000 | 35411
2023-08-02 00:00:00 | 20:20:00.000000 | 35415
2023-08-02 00:00:00 | 20:21:00.000000 | 35417
2023-08-02 00:00:00 | 20:22:00.000000 | 35417
2023-08-02 00:00:00 | 20:23:00.000000 | 35417
2023-08-02 00:00:00 | 20:24:00.000000 | 35415
2023-08-02 00:00:00 | 20:25:00.000000 | 35417
2023-08-02 00:00:00 | 20:26:00.000000 | 35417
2023-08-02 00:00:00 | 20:27:00.000000 | 35417
2023-08-02 00:00:00 | 20:28:00.000000 | 35419
2023-08-02 00:00:00 | 20:29:00.000000 | 35420
2023-08-02 00:00:00 | 20:31:00.000000 | 35420
Spreadsheet: 115580d1311157641-summing-numbers-income-expense
Sheet: Totals

2011  Annual Totals
 | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Total
Income | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Expense | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Total: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Total
Books | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Money Collected | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Refreshments | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
copies | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Loans | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Supplies | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
TOTALS: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 754696d1636453775-matching-row-and-adding-colomn-with-matching-header-sample-1
Sheet: 3WLAH (2)

 |  | Wk 46 Yr 21
 |  | Last Week | This Week | Next Next Week | Next Next Week | Next Next Week | Next Next Week
 |  | 2021-11-08 00:00:00
S/N | Work Description | Planned Qty. | Planned Qty. | Planned Qty. | Planned Qty. | Planned Qty. | Planned Qty.
3 | Location | 0
5.1 | CHVAC Ducting FAB Zone 4 L1 | 49
5.2 | CHVAC Ducting FAB Zone 4 L2 | 0 | 42
5.3 | CHVAC Ducting FAB Zone 1 L3 | 0
5.4 | CHVAC Ducting FAB Zone 2 L3 | 0
5.5 | CHVAC Ducting FAB Zone 3 L3 | 0
 |  | Sample Above | Sample Above
 |  |  |  | How to write this function to match Row and Add up Colomn that match Week and Year?
Spreadsheet: 472300ea-e141-4bd1-b3fa-7fad09d81c0b
Sheet: Sheet1

Table 6--Cottonseed oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Imports | Production | Total |  | Domestic | Exports | Total | stocks
 |  |  |  | Million pounds
2010/11 | 92.539 | 0.202 | 835 | 927.741 |  | 598.913 | 163.828 | 762.741 | 165
2011/121 | 165 | 10 | 755 | 930 |  | 565 | 265 | 830 | 100
2012/132 | 100 | 0.3 | 830 | 930.3 |  | 700.3 | 130 | 830.3 | 100
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2012-10-17 11:40:04.900000
Spreadsheet: 200161d1355434657-formula-to-calculate-years-of-service-for-next-year-vacation-days-accured
Sheet: List

Emp No | Status | Name (Last, First) | [NAME] | Date Seniority | Dept | Shift | YOS | Vacation Days | Vacation Hours
12345 | A | POLO, MARCUS | 6/29/2008 | 10/3/2005 | B | 1 | 7
67899 | A | MULA, LIZ | 6/29/2008 | 11/8/1993 | C | 2 | 19
Spreadsheet: 88220d1288107275-excel-2007-previously-created-text-boxes-in-2007-dummy-work-book
Sheet: Testing Sample Selection

IA obtained the approver's job title using Microsoft Outlook and validated that the approval was consistent with the dollar amount of the invoice (based on the Delegation of Authority).  IA then looked up the G/L account
description in SAP and compared it to the Invoice description to determine whether the G/L account was appropriate.
 | Invoice Number | CC'd | Document Number | Invoice Amount | Approver per Invoice | Job Title per MS Outlook | Is apprval appropriate per DOA (NMP015.2)? | Acct Per Invoice | Invoice Description | Acct per SAP | G/L Description per SAP | Is GL acct coding appropriate?
1 | 2370875 | 1001 | 54321 | 37 |  |  |  | 123 | Parking | 123 | GROUND | Yes
2 | ALPI-100520-1 | 1001 | 54321 | 298.85 |  |  |  | 123 | Parking | 123 | GROUND | Yes
3 | [PHONE]-0510 | 1001 | 54321 | 70.99 |  |  |  | 123 | Parking | 123 | GROUND | Yes
4 | 487524 | 1001 | 54321 | 188.4 |  |  |  | 123 | Parking | 123 | GROUND | Yes
5 | 524757-0 | 1001 | 54321 | 68.6 |  |  |  | 123 | Parking | 123 | GROUND | Yes
6 | MER032010 | 1001 | 54321 | 246.61 |  |  |  | 123 | Parking | 123 | GROUND | Yes
 |  | 1001 | 54321 |  |  |  |  | 123 | Parking | 123 | GROUND | Yes
 |  | 1001 | 54321 |  |  |  |  | 123 | Parking | 123 | GROUND | Yes
7 | 10110 | 1001 | 54321 | 250.56 |  |  |  | 123 | Parking | 123 | GROUND | Yes
8 | INV0045057 | 1001 | 54321 | 1554.62 |  |  |  | 123 | Parking | 123 | GROUND | Yes
9 | 7567 | 1001 | 54321 | 4273.74 |  |  |  | 123 | Parking | 123 | GROUND | Yes
10 | 275131 | 1001 | 54321 | 284.25 |  |  |  | 123 | Parking | 123 | GROUND | Yes
11 | 62 | 1001 | 54321 | 1200 |  |  |  | 123 | Parking | 123 | GROUND | Yes
 |  | 1001 | 54321 |  |  |  |  | 123 | Parking | 123 | GROUND | Yes
12 | 1213192 | 1001 | 54321 | 2700 |  |  |  | 123 | Parking | 123 | GROUND | Yes
13 | MER030610 | 1001 | 54321 | 160.48 |  |  |  | 123 | Parking | 123 | GROUND | Yes
 |  | 1001 | 54321 |  |  |  |  | 123 | Parking | 123 | GROUND | Yes
14 | 4008 | 1001 | 54321 | 135.43 |  |  |  | 123 | Parking | 123 | GROUND | Yes
15 | MER060510 | 1001 | 54321 | 100 |  |  |  | 123 | Parking | 123 | GROUND | Yes
16 | 4386LIC10 | 1001 | 54321 | 1424.45 |  |  |  | 123 | Parking | 123 | GROUND | Yes
17 | P14549 | 1001 | 54321 | 12.52 |  |  |  | 123 | Parking | 123 | GROUND | Yes
18 | 282410 | 1001 | 54321 | 140 |  |  |  | 123 | Parking | 123 | GROUND | Yes
19 | 268812 | 1001 | 54321 | 6780.45 |  |  |  | 123 | Parking | 123 | GROUND | Yes
20 | 835841 | 1001 | 54321 | 663.48 |  |  |  | 123 | Parking | 123 | GROUND | Yes
21 | [PHONE]-0510 | 1001 | 54321 | 47.06 |  |  |  | 123 | Parking | 123 | GROUND | Yes
22 | MER050810 | 1001 | 54321 | 89.84 |  |  |  | 123 | Parking | 123 | GROUND | Yes
 |  | 1001 | 54321 |  |  |  |  | 123 | Parking | 123 | GROUND | Yes
23 | MER031310 | 1001 | 54321 | 236.41 |  |  |  | 123 | Parking | 123 | GROUND | Yes
24 | MER012310 | 1001 | 54321 | 37 |  |  |  | 123 | Parking | 123 | GROUND | Yes
25 | TO BE SELECTED IN Q4
Spreadsheet: 743263d1628334462-look-up-time-and-return-blank-and-not-with-0-sample
Sheet: Sheet1

 |  |  | Time | Time | Sample |  |  | Time | column 2
 |  | aaaa |  |  | 06:00:00 |  |  | 06:00:00 | aaaa
 |  | bbbb |  |  |  |  |  |  | bbbb
 |  | cccc |  |  | 23:00:00 |  |  | 23:00:00 | cccc
Spreadsheet: 81917d1282037952-set-up-automatic-currency-detection-from-a-list-of-companies-workbook-1-
Sheet: Sheet2

 | Currencies
Santander | EUR
Mercedes Benz | EUR
SABB | SAR
Microsoft | USD
Apple | USD
Rolls Royce | GBP
Bentley | GBP
 |  | Microsoft | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
Spreadsheet: 113256d1309209361-excel-2007-protect-only-two-columns-sample
Sheet: Test

0 | 0 | 1 | 2 | 3 | Protect | Protect | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Comments
 |  |  | 1 | Yes |  |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  |  | 2 | No |  |  | No | No | No | No | No | No | No
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9