tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 71871d1272557507-how-to-move-sort-data-from-one-sheet-to-the-next-so-close-1
Sheet: goes

PublisherId | ParentId | Tier | CSR | [NAME] | [NAME] | Phone | FirstName | LastName | CompanyName | ISORep | SRMRep | Note | Tags
 |  |  |  | column L | column AG | column AH |  |  | column AE |  |  | column AC | columns AV - BA; if the cell says NULL please ignore; if it says "On" then paste the header. For example, if columns AV and AW are "On" and the rest say "Null" then the cell should say "Opportunity_AFC, Opportunity_AFS"
 |  |  |  |  |  |  |  |  |  |  |  |  | on
Spreadsheet: 1baea446-1fea-4519-857f-9fa3c60f1cf0
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2013/14 |  |  |  | 2012/13 |  |  |  | 2013/14 |  |  |  | 2012/13
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 15.2 |  | 6668 |  | 14 |  | 8176 |  | 17.5 |  | 2029 |  | 16.6 |  | 2680
September | 15.3 |  | 10021 |  | 13.8 |  | 9172 |  | 18.1 |  | 1197 |  | 17.8 |  | 1458
October | 15.4 |  | 10865 |  | 13.9 |  | 11849 |  | 15.9 |  | 2018 |  | 16.8 |  | 2261
November | 15.5 | 1/ |  |  | 14 |  | 12784 |  | 17 | 1/ |  |  | 17 |  | 3559
December |  |  |  |  | 14.1 |  | 11332 |  |  |  |  |  | 16.9 |  | 3940
January |  |  |  |  | 14.4 |  | 13973 |  |  |  |  |  | 16.7 |  | 4886
February |  |  |  |  | 14.6 |  | 12945 |  |  |  |  |  | 16.1 |  | 2527
March |  |  |  |  | 14.7 |  | 11123 |  |  |  |  |  | 16.4 |  | 3178
April |  |  |  |  | 14.8 |  | 9546 |  |  |  |  |  | 16.7 |  | 3103
May |  |  |  |  | 14.9 |  | 9103 |  |  |  |  |  | 16.6 |  | 2147
June |  |  |  |  | 15 |  | 7551 |  |  |  |  |  | 16.7 |  | 2292
July |  |  |  |  | 15.1 |  | 6929 |  |  |  |  |  | 16.4 |  | 2050
Average to date 2/ | 15.35 |  |  |  |  |  |  |  | 17.125
Season-average farm price | 14.80-15.80 | 3/ |  |  | 14.4 |  |  |  | 16.80-17.80 | 3/ 4/ |  |  | 16.7
Average marketings |  |  | 9184.666666666666 |  |  |  | 10373.58333333333 |  |  |  | 1748 |  |  |  | 2840.083333333333
Total volume marketed |  |  | 27554 |  |  |  | 124483 |  |  |  | 5244 |  |  |  | 34081
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated December 11, 2013.
Spreadsheet: 220084d1363049986-how-to-complete-a-lookup-from-a-table-matrix-with-4-variables-rates-table-with-4-variables
Sheet: Sheet1

New / Used | Year | Beacon | Term | Rate
611 | 2014 | 740 | 37 | #N/A
611 | 2013 | 700 | 37
611 | 2012 | 787 | 12
611 | 2012 | 798 | 24
MODEL | YEAR |  | TERMS |  | 1 | 2 | 3
 |  |  |  |  | 900 | 739 | 699
 |  |  |  |  | 740 | 700 | 650
611 | 2014 | 2012 | 1 | 36 | 0.0223 | 0.02733333333333333 | 0.03233333333333333
611 | 2014 | 2012 | 37 | 51 | 0.0235 | 0.02695 | 0.03195
611 | 2014 | 2012 | 52 | 63 | 0.0245 | 0.02840943396226416 | 0.03340943396226415
611 | 2014 | 2012 | 64 | 75 | 0.0275 | 0.02928370370370368 | 0.03428370370370368
611 | 2014 | 2012 | 76 | 84 | 0.035 | 0.0574 | 0.0624
Spreadsheet: 474441d1470756439-looking-for-easy-data-entry-to-output-monthly-calendar-view-zb-calendar
Sheet: Bookings

Days |  | Cumulative |  | Row | Car_hired | Date | Day_car
 |  | 0 |  |  |  |  |  |  | Group |  | Group | Initative detail | Start Date | End Date
 |  |  |  |  |  |  |  |  | Group 1 Activity |  | Group 1 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  | Group 2 Activity |  | Group 2 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  | Group 3 Activity |  | Group 3 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  | Group 4 Activity |  | Group 4 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  | Group 5 Activity |  | Group 5 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Group 2 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Group 4 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Group 2 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Group 4 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Group 2 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
Spreadsheet: 044c39e5-ab72-4ead-a719-de13433ec545
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Risk Parity II HV Fund
 | [NAME]
 | Inception Date | 2012-11-05 00:00:00
 |  |  |  | 60/40
 |  |  |  | Blended
 |  | Class I | Class N | S&P / Barc
 | Date | QRHIX | QRHNX | Custom Index
** | 2012-11-30 00:00:00 | 0.02200000000000002 | 0.02200000000000002 | 0.001828994995952371
 | 2012-12-31 00:00:00 | 0.002349964183449904 | 0.001806903365910939 | 0.00503769344610272
 | 2013-01-31 00:00:00 | 0.03232125367286964 | 0.032258064516129 | 0.02827941685265651
 | 2013-02-28 00:00:00 | -0.00189753320683117 | -0.001893939393939448 | 0.01014975740510864
 | 2013-03-31 00:00:00 | 0.03136882129277585 | 0.03130929791271342 | 0.02273670456071808
 | 2013-04-30 00:00:00 | 0 | 0 | 0.01583695293272935
 | 2013-05-31 00:00:00 | -0.053456221 | -0.054277829 | 0.006856361981235626
 | 2013-06-30 00:00:00 | -0.1012658227848101 | -0.1011673151750972 | -0.01402606676892237
 | 2013-07-31 00:00:00 | 0.03033586132177679 | 0.03138528138528129 | 0.03087256773426739
 | 2013-08-31 00:00:00 | -0.01261829652996838 | -0.01364113326337868 | -0.01934649386957499
 | 2013-09-30 00:00:00 | 0.0319488818 | 0.0319148936 | 0.0226279998795389
 | 2013-10-31 00:00:00 | 0.0392156863 | 0.0391752577 | 0.03081525070913016
 | 2013-11-30 00:00:00 | -0.0009930486593843213 | -0.002976190476190466 | 0.01674754374759413
 | 2013-12-31 00:00:00 | -0.013800461 | -0.012819168 | 0.01292919
 | 2014-01-31 00:00:00 | -0.001013171225937248 | -0.002026342451874386 | -0.01483426358353035
 | * annualized for periods 1 year or greater
 | ** partial month return, inception date 11/5/2012
 | Risk Parity II HV Fund
 | [NAME]
 |  |  |  | 60/40
 |  |  |  | Blended
 | Month-end Returns as of | Class I | Class N | S&P / Barc
 | January 31, 2014 | QRHIX | QRHNX | Custom Index
 | 1 Year | -0.05966645887447164 | -0.06239927297816616 | 0.1264835553450445
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.005586363531793315 | -0.009074200452273362 | 0.1663044851137445
 | Since Inception Annualized Return | -0.004513542835831386 | -0.007334039964146499 | 0.1322755367788044
* | Since Inception Annualized Monthly Volatility | 0.1291621194100573 | 0.1295956826489064 | 0.05681850148001109
 | Since Inception [NAME] | -0.03494478765482332 | -0.05659169977147684
 |  |  |  | 60/40
 |  |  |  | Blended
 | Quarter-end Returns as of | Class I | Class N | S&P / Barc
 | December 31, 2013 | QRHIX | QRHNX | Custom Index
 | 1 Year | -0.02828919052255086 | -0.03018891887153752 | 0.1757879622761613
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.004577830431926944 | -0.007062168371973376 | 0.1838725654986717
 | Since Inception Annualized Return | -0.003970113350030502 | -0.006125666082197223 | 0.1575884328785624
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9908

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1999-08-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.53 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.56
IFGMR (PEPL/TX/OK) |  |  | 2.51
IFGMR (ANR/LA) |  |  | 2.55
IFGMR (HENRY HUB) |  |  | 2.62
NX3 |  |  | 2.5723
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5
TRIGGER* (LA) |  | 2.5
DIFFERENTIAL (TX)
DIFFERENTIAL (LA)
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 145850d1331772755-concatenate-error-error
Sheet: Sheet1

-4.2
-0.8
0.1
Spreadsheet: 748819d1632370208-partial-name-lookup-partial-name-lookup-ans
Sheet: Sheet1

 | Name | Start | End |  |  | Unit |  |  | ARRAY formula is used
 | Lot A | 2021-01-24 00:00:00 | 2022-04-07 00:00:00 |  |  | [NAME]
 | Unit 7 | 2021-01-25 00:00:00 | 2022-08-01 00:00:00
 | Lurch 77 | 2021-01-26 00:00:00 | 2022-08-02 00:00:00
 | Step 5y | 2021-01-27 00:00:00 | 2022-08-03 00:00:00
 | Chair 88 | 2021-03-25 00:00:00 | 2022-08-07 00:00:00
 | Desk u | 2021-05-29 00:00:00 | 2022-09-05 00:00:00
 | Gimbal 78 | 2021-07-30 00:00:00 | 2022-10-06 00:00:00
 | Was thinking a VLOOKUP would work but can't seem to figure it out. Need to do it without helper columns.
1 | Find the cell based on partial name - for example "Step"
2 | Return the value in column D - 8/3/2022
 | If the first four letters in column B equal "Step", then return the value in the End column
Spreadsheet: 126163d1319552934-generating-a-parts-list-report-with-subcategories-in-excel-2003-example_parts_list
Sheet: Sample Sub-Modules

Phone
Serial No | Main Part Serial Numbers
 | PCB | Chassis | Screen | Case
S001
S002
S003
S004
Laptop
Serial No | Main Part Serial Numbers
 | Motherboard | Screen | Hard Drive | CD Drive | Battery
S006
S005
S007
S008
Spreadsheet: 127299e7-75ae-40f3-a3f7-3c3fb5b5485d
Sheet: FV

FV function: FV(rate, nper, pmt, pv, type)
 | (a) | (b) | (c )
rate: | 0.05 |  | 0.06
nper: | 7 |  | 10
pmt: | 0 | -1500 | -1500
pv: | -1000 | 0 | -20000
Future value:
Spreadsheet: 105868d1303143449-adding-cells-using-if-formula-alum
Sheet: Sheet1

Alum     Day Tank   Level | Refill Level
31.125 |  | 0
30.75 |  | 0
30.5 |  | 0
30 |  | 0
29.625 |  | 0
29.125 |  | 0
28.75 |  | 0
28.375 |  | 0
28 |  | 0
27.5 |  | 0
27.125 |  | 0
26.625 |  | 0
26.25 |  | 0
25.875 |  | 0
25.5 |  | 0
25 |  | 0
24.75 |  | 0
24.25 |  | 0
23.75 |  | 0
23.375 |  | 0
23 |  | 0
22.5 |  | 0
22 | 31.125 | 9.125
30.875 |  | 0
30.5
Spreadsheet: 855643d1705149113-novice-would-appreciate-feedback-on-best-way-to-track-receipts-receipt_template
Sheet: example 1

date | store | total | tax | price | description
2024-01-01 00:00:00 | store1 | 13 | 1 | 5 | [NAME]
 |  |  |  | 7 | item2
2024-01-01 00:00:00 | store1 | 39 | 3 | 11 | item3
 |  |  |  | 12 | item4
 |  |  |  | 13 | [NAME]
2024-01-03 00:00:00 | [NAME] | 6 | 1 | 2 | item6
 |  |  |  | 3 | [NAME]
Spreadsheet: 287471d1388811341-copying-data-to-cells-timesheet
Sheet: Bob

 |  | [NAME]
Name |  | 2013-12-12 00:00:00 | 2013-12-13 00:00:00 | 2013-12-14 00:00:00 | 2013-12-15 00:00:00 | 2013-12-16 00:00:00 | 2013-12-17 00:00:00 | 2013-12-18 00:00:00 | 2013-12-19 00:00:00 | 2013-12-20 00:00:00 | 2013-12-21 00:00:00 | 2013-12-22 00:00:00 | 2013-12-23 00:00:00
[NAME]
Spreadsheet: 146615d1332270831-sum-on-several-conditions-example_20mar_fixed
Sheet: Sheet1

firm_id | [NAME] | man_id | date | number | cumulated_number | sum_number
1 | 1 | 1 | 2010-02-01 00:00:00 | 233565 | 1
1 | 2 | 1 | 2010-02-02 00:00:00 | 346546 | 1
1 | 3 | 1 | 2010-02-03 00:00:00 | 324 | 0
1 | 3 | 1 | 2010-02-03 00:00:00 | 4235 | 0
1 | 3 | 1 | 2010-02-03 00:00:00 | 235 | 1
1 | 3 | 1 | 2010-02-04 00:00:00 | 3466573 | 0
2 | 1 | 2 | 2010-02-01 00:00:00 | 7523 | 0
2 | 1 | 2 | 2010-02-01 00:00:00 | 5735 | 1
2 | 1 | 3 | 2010-02-01 00:00:00 | 75374 | 0
2 | 1 | 3 | 2010-02-01 00:00:00 | 753 | 0
2 | 1 | 3 | 2010-02-01 00:00:00 | 753457 | 0
2 | 1 | 3 | 2010-02-01 00:00:00 | 45735 | 1
Spreadsheet: 881177d1729101031-financial-forecasting-spreadsheet-financial-forecast_sheet
Sheet: Current_Sales

JOB NO | CUSTOMER ID | Due Date | Price Total
417523 | 200068 | 2010-10-15 00:00:00 | 9000
417524 | 200076 | 2016-10-22 00:00:00 | 1000
417525 | 200071 | 2016-09-10 00:00:00 | 25000
417526 | 200071 | 2016-08-21 00:00:00 | 90000
417527 | 200068 | 2016-08-19 00:00:00 | 150000
417528 | 200005 | 2016-08-21 00:00:00 | 2500
417529 | 200046 | 2016-08-22 00:00:00 | 6000
417530 | 200046 | 2016-08-21 00:00:00 | 9000
417531 | 200046 | 2016-08-21 00:00:00 | 10000
417532 | 200036 | 2016-08-21 00:00:00 | 10000
417533 | 200036 | 2016-08-21 00:00:00 | 10500
417534 | 200027 | 2016-08-21 00:00:00 | 30000
417535 | 200046 | 2016-08-21 00:00:00 | 20000
417536 | 200017 | 2016-08-21 00:00:00 | 80000
417537 | 200068 | 2016-08-21 00:00:00 | 60000
417538 | 200068 | 2016-08-21 00:00:00 | 80000
417539 | 200005 | 2016-08-21 00:00:00 | 2000
417540 | 200067 | 2016-10-20 00:00:00 | 25000
417541 | 200068 | 2018-11-29 00:00:00 | 20000
417542 | 200089 | 2016-11-29 00:00:00 | 15000
Spreadsheet: 57001d1257183109-pivot-count-query-example-a-and-b-
Sheet: Master Sheet

Name | A or B | Hours |  |  |  | Count of Name
Giff | A | 2 |  |  |  | Name | A or B | Total
Giff | A | 2 |  |  |  | Giff | A | 2
[NAME] | B | 2 |  |  |  | [NAME] | A | 1
[NAME] | B | 2 |  |  |  | [NAME] | A | 2
[NAME] | A | 2 |  |  |  | [NAME] | B | 3
[NAME] | A | 2 |  |  |  | [NAME] | B | 2
[NAME] | B | 2 |  |  |  | Grand Total |  | 10
[NAME] | B | 2
[NAME] | B | 2 |  |  |  | Unique A's | A | 3
[NAME] | A | 2 |  |  |  | Unique B's | B | 2
[NAME] | A | 2
Clem | A | 2
[NAME] | A | 2
Glock | A | 1
[NAME] | A | 1
Chock | A | 2
[NAME] | A | 1
TOTAL
Spreadsheet: 835739d1688760941-collapsing-multiple-rows-with-same-name-into-columns-book1
Sheet: Sheet1

year | name | Grade=C | Grade=B | Grade=A |  |  |  |  | Years
2022 | a | 7 | 12 | 13 |  |  |  |  | 2020 |  |  | 2021 |  |  | 2022
2021 | a | 12 | 14 | 15 |  |  |  | Names | Grade=C | Grade=B | Grade=A | Grade=C | Grade=B | Grade=A | Grade=C | Grade=B | Grade=A
2020 | a | 6 | 8 | 11 |  |  |  | a | 6 | 8 | 11 | 12 | 14 | 15 | 7 | 12 | 13
2022 | b | 10 | 7 | 4 |  |  |  | b | 11 | 15 | 4 | 11 | 12 | 14 | 10 | 7 | 4
2021 | b | 11 | 12 | 14 |  |  |  | c | 4 | 13 | 13 | 11 | 14 | 11 | 7 | 10 | 4
2020 | b | 11 | 15 | 4
2022 | c | 7 | 10 | 4
2021 | c | 11 | 14 | 11
2020 | c | 4 | 13 | 13
Spreadsheet: 110299d1307014797-macro-to-delete-row-if-criteria-is-not-met-sample
Sheet: Report

ID Number | Last | First | Class Title | End Date
1 | Smith | [NAME] | Psych 101 | 2011-08-01 00:00:00
2 | Jones | Jon | Soc  203 | 2011-07-15 00:00:00
3 | Ford | [NAME] | Soc 200 | 2011-06-30 00:00:00
4 | McCall | [NAME] | Eng 301 | 2011-04-01 00:00:00
5 | Berry | [NAME] | Soc 400 | 2010-06-01 00:00:00
6 | Maxwell | [NAME] | Psych 200
7 | [NAME] | Cort | Eng 101 | 2011-05-14 00:00:00
8 | Barker | Mark | Soc 101
9 | [NAME] | [NAME] | Eng 400
10 | Fields | [NAME] | Soc 220
11 | [NAME] | [NAME] | Psych 300 | 2011-08-30 00:00:00
12 | [NAME] | Fran | Soc 366 | 2011-07-01 00:00:00
13 | Michaels | [NAME] | Eng 101 | 2010-01-01 00:00:00
14 | Harper | [NAME] | Soc 101
15 | Marks | [NAME] | Psych 101
16 | Sampson | Doug | Eng 301 | 2011-06-02 00:00:00
Spreadsheet: 61985d1262893464-excel-2007-time-calculation-alculation-from-midnight-timeraport
Sheet: Jan2010

United Parcel Service Sweden AB
Närvaro och övertidsrapport
 |  | Månad: |  |  | År:
Namn: | [NAME] |  |  | Personnr:
Funktion: |  |  |  | Anst. Nummer:
Datum | [NAME] | [NAME] | [NAME] | Totala Timmar | OB | mertid | enkel        ö-tid | [NAME]
2010-01-01 00:00:00
 | 01:30:00 | 08:00:00 | 00:30:00
 | 01:30:00 | 08:00:00 | 00:30:00
 | 01:30:00 | 08:00:00 | 00:30:00 |  |  | [NAME]
 | 01:30:00
Total
Jag vill har min övertid i: |  |  |  | [NAME] |  | X | [NAME]
Signatur: _______________________________   Datum:_______________
[NAME]:________________________________________________
Enkel ö-tid: vardag fram till kl 20:00
Kval ö-tid: vardag från kl 20:00 till 06:00 och från fredag kl 20:00 till måndag kl 06:00
Spreadsheet: 870134d1716675388-dynamically-copy-filter-rows-to-another-sheet-based-on-multiple-criteria-dynamically-copyfilter-rows-to-another-sheet-based-on-multiple-criteria2-copy
Sheet: Hanging TMS v2

 | FLOOR | RC | UNIT TYPE | TOT SF CEILING | TOT SF | 12 C | 12X | 10X | 9X | 9MR | 8TILE | 8SOFF | UNIT | HANGERS $/SF | HANGERS | HANGERS PAY | HANGERS PAID
Building # 2 (24) | 2 FLOOR | 0 | A2 | 702 | 2878 | 15 | 0 | 0 | 50 | 6 | 3 | 2 | 2205 | 0.15 | [NAME] | 432 | Green
Building # 2 (24) | 2 FLOOR | 1 | A5 | 777 | 2878 | 15 | 0 | 0 | 50 | 6 | 3 | 2 | 2205 | 0.15 | [NAME] | 555 | Green
Building # 2 (24) | 3 FLOOR | 1 | A4 | 766 | 2942 | 16 | 0 | 0 | 50 | 6 | 3 | 2 | 2303 | 0.15 | [NAME] | 441 | Green
Building # 2 (24) | 1 FLOOR | 1 | B1 | 1090 | 4550 | 23 | 0 | 0 | 80 | 9 | 6 | 2 | 2101 | 0.15 | [NAME] | 683 | Green
Spreadsheet: 169586d1342969424-how-to-apply-countif-formula-when-data-are-on-different-sheets-book1
Sheet: August

 |  |  |  | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri
S.no | Employee Name | SID | Process | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | 2012-08-03 00:00:00 | 2012-08-04 00:00:00 | 2012-08-05 00:00:00 | 2012-08-06 00:00:00 | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 2012-08-09 00:00:00 | 2012-08-10 00:00:00 | 2012-08-11 00:00:00 | 2012-08-12 00:00:00 | 2012-08-13 00:00:00 | 2012-08-14 00:00:00 | 2012-08-15 00:00:00 | 2012-08-16 00:00:00 | 2012-08-17 00:00:00 | 2012-08-18 00:00:00 | 2012-08-19 00:00:00 | 2012-08-20 00:00:00 | 2012-08-21 00:00:00 | 2012-08-22 00:00:00 | 2012-08-23 00:00:00 | 2012-08-24 00:00:00 | 2012-08-25 00:00:00 | 2012-08-26 00:00:00 | 2012-08-27 00:00:00 | 2012-08-28 00:00:00 | 2012-08-29 00:00:00 | 2012-08-30 00:00:00 | 2012-08-31 00:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 88692d1288541136-convert-vertical-row-data-into-horizontal-sample
Sheet: Sheet1

C_ID | E_NAME | C_NAME | P_NAME | EVENT_DT |  | C_ID | E_NAME | C_NAME | P_NAME | EVENT_ID
80 | AB | A | A123 | 2010-07-15 00:00:00 |  | 80 | AB | A | A123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00 | 2010-08-26 00:00:00 | 2010-09-02 00:00:00
80 | AB | A | A123 | 2010-07-22 00:00:00 |  | 92 | AB | B | A123 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00 | 2010-08-26 00:00:00 | 2010-09-02 00:00:00
80 | AB | A | A123 | 2010-07-29 00:00:00 |  | 93 | ACD | C | B123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-09-02 00:00:00
80 | AB | A | A123 | 2010-08-05 00:00:00 |  | 104 | CD | D | B123 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 2010-07-29 00:00:00 | 2010-08-05 00:00:00 | 2010-08-12 00:00:00 | 2010-08-19 00:00:00
80 | AB | A | A123 | 2010-08-12 00:00:00
80 | AB | A | A123 | 2010-08-19 00:00:00
80 | AB | A | A123 | 2010-08-26 00:00:00
80 | AB | A | A123 | 2010-09-02 00:00:00
92 | AB | B | A123 | 2010-07-22 00:00:00
92 | AB | B | A123 | 2010-07-29 00:00:00
92 | AB | B | A123 | 2010-08-05 00:00:00
92 | AB | B | A123 | 2010-08-12 00:00:00
92 | AB | B | A123 | 2010-08-19 00:00:00
92 | AB | B | A123 | 2010-08-26 00:00:00
92 | AB | B | A123 | 2010-09-02 00:00:00
93 | CD | C | B123 | 2010-07-15 00:00:00
93 | CD | C | B123 | 2010-07-22 00:00:00
93 | CD | C | B123 | 2010-07-29 00:00:00
93 | CD | C | B123 | 2010-08-05 00:00:00
93 | CD | C | B123 | 2010-09-02 00:00:00
104 | CD | D | B123 | 2010-07-15 00:00:00
104 | CD | D | B123 | 2010-07-22 00:00:00
104 | CD | D | B123 | 2010-07-29 00:00:00
104 | CD | D | B123 | 2010-08-05 00:00:00
104 | CD | D | B123 | 2010-08-12 00:00:00
104 | CD | D | B123 | 2010-08-19 00:00:00
Spreadsheet: 278275d1384674313-cf-icon-set-based-on-text-not-values-con-format-wingdings
Sheet: Sheet1

Yes
No
Yes
Yes
Yes
No
No
No
No
Yes
Yes
Spreadsheet: 113320d1309267839-stacked-bar-chart-781962
Sheet: Sheet1

Name | Amount | Colour
[NAME] | 10000 | Black |  |  |  | Black | Blue | Orange
[NAME] | 12000 | Blue |  |  | [NAME]
[NAME] | 9000 | Orange |  |  | [NAME]
Sue | 11000 | Black |  |  | [NAME]
[NAME] | 5000 | Orange |  |  | Sue
[NAME] | 4000 | Blue |  |  | [NAME]
 |  |  |  |  | [NAME]
Spreadsheet: 831110d1685431030-match-and-sum-match-and-sum3
Sheet: Sheet2

Case1
Magh | Ma-45 | [NAME] |  |  |  |  | 64
Magh | Ma-49 | [NAME] |  |  |  |  | 75
Magh | Ma-54 | [NAME] |  |  |  |  | 88
Case2
Magh | Ma-45 | [NAME] | * | * | * | * | * | 25 | 64 | 6 | 64 | 1 | 500
Magh | Ma-49 | [NAME] | * | * | * | * | * | 23 | 75 | 12 | 44 | 4 | 300
Magh | Ma-54 | [NAME] | * | * | * | * | * | 44 | 88 | 19 | 77 | 9 | 450
Case3
Magh | Ma-45 | [NAME] | 2023.5.26 |  | 4626
Magh | Ma-49 | [NAME] | 2023.5.24 |  | 846
Magh | Ma-54 | [NAME] | 2023.5.27 |  | 342
Spreadsheet: 761477d1640938103-best-of-three-best-3-selection
Sheet: Sheet1

 |  |  |  |  |  | expected results
MUSHTAK ESMAIL | 1 | 1 | 1 | 5 | need formula here | 1
TOYO KITUA | 2 | 3 | 2 | 4 |  | 2.333333333333333
SHAHNAZ HIRJI | 3 | 2 | 0 | 3 |  | 2.666666666666667
MAKBUL MANJI | 0 | 4 | 3 | 2 |  | 3
HAMISI [NAME] | 4 | 6 | 4 | 1 |  | 3
[NAME] | 0 | 5 | 0 | 1 |  | dis
Spreadsheet: 771683d1646793377-make-a-new-table-but-removing-all-the-rows-that-have-a-zero-value-in-a-column-example-4thgenlude-full
Sheet: Invoice

Residential Total:
Sum 1: |  |  | 250 | $50 charge | $50 charge | $50/revision
Project ID # | Due | Notes | Initial Design Date | [NAME]? | Complex? | # of Revisions | Final Design Date
Spreadsheet: 03edbbe8-091c-4642-87d1-9a3fac3c8b99
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | FORM N
INTERNATIONAL CIVIL AVIATION ORGANIZATION
AIR TRANSPORT REPORTING FORM
AVIATION PERSONNEL, LICENSING AND TRAINING
Contact person: |  |  |  | State:
Organization:
Tel: |  |  |  | Year:
Fax:
E-mail:
AVIATION PERSONNEL QUALIFICATIONS
ICAO code | Qualification category |  | Qualifications issued  (annual) | Total active  qualifications | Annual validations/conversions | Total validations/conversions | Retirement age
 | a |  | b | c | d | e | f
 | 1 | ATPL
 | 2 | CPL
 | 3 | MPL
 | 4 | PPL
 | 5 | Flight instructor ratings
 | 6 | Specific authorizations
 | 7 | Aircraft maintenance licences
 | 8 | ATC licences
AVIATION PERSONNEL FUTURE TRAINING CAPACITIES
ICAO code | Licence category |  | Training organizations  (current) | Training organizations  (5-year) | Training capacity  (5-year)
 | g |  | h | i | j
 | 9 | Pilots (PPL/CPL/ATPL)
 | 10 | Pilots (MPL)
 | 11 | Aircraft maintenance licences
 | 12 | ATC licences
Spreadsheet: 768692d1645085073-get-a-certain-data-across-a-row-but-within-the-range-of-a-merged-cell-data-from-merged-cell-ans
Sheet: Sheet1

 |  |  |  |  | Team | a | b | c | d | Total
 |  |  |  |  | A | 12 | 34 | 67 | 23
 |  |  |  |  | B | 12 | 766 | 3 | 90
Team A | a | 12
 | b | 34
 | c | 67
 | d | 23
 | Total
Team B | a | 12
 | b | 766
 | c | 3
 | d | 90
 | Total
 | Team B |  |  |  | B