tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 792364d1660859394-generating-a-list-by-category-where-items-can-be-used-one-time-sample-spreadsheet
Sheet: Sheet1

ID | A1 | A2 | A3 | A4 | B1 | B2 | B3 | B4 |  | Category | ID | Explanation
0001 |  |  | x | x |  |  |  |  |  | A1 | 0005 | First available value with A1
0002 |  |  |  |  |  | x | x |  |  | A2 | 0003 | First available value with A2
0003 |  | x |  |  | x |  | x |  |  | A3 | 0001 | First available value with A3
0004 |  |  |  |  |  |  |  | x |  | A4 | 0008 | Cannot use 0001, already used above, next available value
0005 | x |  |  |  | x |  |  |  |  | B1 | 0011 | Cannot use 0003, 5, or 8, next available value
0006 |  | x |  |  |  |  |  |  |  | B2 | 0002 | First available value
0007 |  |  | x |  |  |  |  |  |  | B3 |  | Cannot use 0002 or 3, no value available
0008 |  |  |  | x | x | x |  |  |  | B4 | 0004 | First available value
0009 |  | x |  |  |  |  |  | x
0010 |  |  |  | x
0011 |  | x |  |  | x
0012 |  |  | x |  |  |  |  | x
Spreadsheet: 98a06de6-f9c8-40bb-af3d-12b0f2e6ed42
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5599 | 7981 | [NAME] | [NAME] | USA | 0 | 00:34:45 | 00:07:11 | 01:16:17 | 00:03:02 | 00:49:49 | 1 | 02:51:07
5599 | 39132 | [NAME] | [NAME] | CAN | 0 | 00:31:43 | 00:07:45 | 01:15:07 | 00:04:10 | 01:01:40 | 2 | 03:00:29
5599 | 19285 | [NAME] | [NAME] | CAN | 0 | 00:27:49 | 00:06:29 | 01:33:46 | [NAME] | 00:51:30 | 3 | 03:04:22
Spreadsheet: 773625d1647961792-formula-for-time-difference-planner-amitesh9-
Sheet: Sheet2

 | Country | EST | EDT | GMT
 | India | 10:30:00 | 09:30:00 | +5:30
 | Japan | 14:00:00 | 13:00:00 | +9:00
 | Malaysia | 13:00:00 | 12:00:00 | +8:00
 | Mexico
 | Netherlands
 | Phillipines | 13:00:00 | 12:00:00 | +8:00
 | EST |  |  | -4:00
 | EDT |  |  | -5:00
Spreadsheet: 814746d1674573038-waterfall-simplification-sample-43-ans2
Sheet: New infra planner

New |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Month | Plan | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | YTD |  |  |  |  |  | [NAME] for Cf C4="",  color ->>Fill-> >Grey
APR | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have changed values in row 1 for verification.
MAY | 30
JUN | 30
JUL | 30
AUG | 30
SEP | 30
OCT | 30
NOV | 30
DEC | 30
JAN | 30
FEB | 30
MAR | 30
TOTAL
Spreadsheet: 206557d1358221339-sort-name-winner-and-gender-sort-name-and-winner-revised
Sheet: Sheet2

21 k REGISTRATION
BIB # | NAME |  | GENDER
2141 | AGBIGAY | [NAME] | M
2110 | AGULAY | RALLY | M
2166 | AGDIGOS | [NAME] | M
2125 | AYSON | KATE | F
2109 | ABELLA IVAN | FRANCIS | M
2163 | BONOAN | TITO | M
2104 | BAPTISTA | ANTHONY | M
2145 | CORPUZ | EDWARD | M
2179 | CHUA | AGNES | F
2188 | GO | KATHLYN | F
Spreadsheet: 256dfaef-7c57-460a-a746-1de0ce1a50f5
Sheet: Sheet1

Table 10--Global rice exporters, calendar years; monthly revisions and annual changes | 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
 | 2011 |  |  |  | 2012 |  |  |  |  |  | 2013 1/
 | November |  | October | November |  | Monthly | Annual |  | October | November |  | Monthly | Annual
 | 2012 |  | 2012 | 2012 |  | revisions | changes |  | 2012 | 2012 |  | revisions | changes
 |  |  |  |  |  |  | 1,000 metric tons (milled basis)
Argentina | 732 |  | 650 | 675 |  | 25 | -57 |  | 560 | 525 |  | -35 | -150
Australia | 311 |  | 450 | 450 |  | 0 | 139 |  | 500 | 500 |  | 0 | 50
Brazil | 1296 |  | 1100 | 1200 |  | 100 | -96 |  | 800 | 800 |  | 0 | -400
Burma | 778 |  | 750 | 700 |  | -50 | -78 |  | 600 | 600 |  | 0 | -100
Cambodia | 860 |  | 800 | 800 |  | 0 | -60 |  | 950 | 950 |  | 0 | 150
China | 487 |  | 400 | 400 |  | 0 | -87 |  | 500 | 500 |  | 0 | 100
Ecuador | 70 |  | 30 | 30 |  | 0 | -40 |  | 15 | 15 |  | 0 | -15
Egypt | 320 |  | 600 | 600 |  | 0 | 280 |  | 850 | 850 |  | 0 | 250
European Union-27 | 241 |  | 245 | 210 |  | -35 | -31 |  | 235 | 235 |  | 0 | 25
Guinea | 80 |  | 80 | 80 |  | 0 | 0 |  | 80 | 80 |  | 0 | 0
Guyana | 250 |  | 230 | 230 |  | 0 | -20 |  | 250 | 250 |  | 0 | 20
India | 4637 |  | 9750 | 10000 |  | 250 | 5363 |  | 6500 | 6500 |  | 0 | -3500
Japan | 200 |  | 200 | 200 |  | 0 | 0 |  | 200 | 200 |  | 0 | 0
Korea, South | 4 |  | 5 | 5 |  | 0 | 1 |  | 5 | 5 |  | 0 | 0
Pakistan | 3414 |  | 3750 | 3750 |  | 0 | 336 |  | 4000 | 4000 |  | 0 | 250
Paraguay | 208 |  | 250 | 250 |  | 0 | 42 |  | 200 | 200 |  | 0 | -50
Peru | 50 |  | 30 | 30 |  | 0 | -20 |  | 60 | 60 |  | 0 | 30
Russia | 142 |  | 200 | 200 |  | 0 | 58 |  | 160 | 170 |  | 10 | -30
Thailand | 10647 |  | 6500 | 6500 |  | 0 | -4147 |  | 8000 | 8000 |  | 0 | 1500
Turkey | 90 |  | 75 | 75 |  | 0 | -15 |  | 80 | 80 |  | 0 | 5
Uganda | 40 |  | 35 | 35 |  | 0 | -5 |  | 35 | 35 |  | 0 | 0
United States | 3247 |  | 3500 | 3300 |  | -200 | 53 |  | 3350 | 3400 |  | 50 | 100
Uruguay | 841 |  | 850 | 1050 |  | 200 | 209 |  | 800 | 850 |  | 50 | -200
Vietnam | 7000 |  | 7000 | 7200 |  | 200 | 200 |  | 7000 | 7000 |  | 0 | -200
Subtotal | 35945 |  | 37480 | 37970 |  | 490 | 2025 |  | 35730 | 35805 |  | 75 | -2165
Other | 269 |  | 239 | 239 |  | 0 | -31 |  | 260 | 260 |  | 0 | 21
 |  |  |  |  |  |  |  |  |  |  |  | 0
World total | 36214 |  | 37719 | 38209 |  | 490 | 1995 |  | 35990 | 36065 |  | 75 | -2144
U.S. Share | 0.08966145689512343 |  | 0.09279143137410854 | 0.08636708628857076 |  | -- | -- |  | 0.09308141150319534 | 0.09427422708997643 |  | -- | --
-- Not available.  Note: All trade data are reported on a calendar-year basis.
1/ Projected.
Source: Production, Supply, & Distribution Online Data Base, FAS/USDA, http://www.fas.usda.gov/psdonline/psdHome.aspx.
Last updated November 9, 2012.
Spreadsheet: 195833d1353680562-return-an-array-based-on-condition-copy-of-book1566
Sheet: Sheet1

AEE US EQUITY |  | Ameren Corp | Electric | -1.312993659660339 | 16 | 6 | -1 | 9/11/2012
PPL US EQUITY |  | PPL Corp | Electric | -2.279504941282718 | -18 | 5 | 1 | 8/11/2012
ETR US EQUITY |  | Entergy Corp | Electric | -38.09676323676323 | 0 | 3 | -11 | 5/11/2012
EQT US EQUITY |  | EQT Corp | Oil&Gas | -10.25607058673726 | -1 | 1 | -1 | 25/10/2012
CNP US EQUITY |  | CenterPoint Energy Inc | Gas | 17.66395604395604 | -6 | 1 | 5 | 7/11/2012
DUK US EQUITY |  | Duke Energy Corp | Electric | 0.8564835164835158 | -14 | 1 | 1 | 8/11/2012
OKE US EQUITY |  | ONEOK Inc | Pipelines | -7.543596403596405 | -6 | -5 | -3 | 30/10/2012
D US EQUITY |  | Dominion Resources Inc/VA | Electric | 3.603520923298702 | -14 | -9 | 1 | 25/10/2012
EXC US EQUITY |  | Exelon Corp | Electric | -6.64310355777023 | -14 | -9 | -1 | 1/11/2012
AEP US EQUITY |  | American Electric Power Co Inc | Electric | -1.371817071372627 | -25 | -9 | -1 | 24/10/2012
NRG US EQUITY |  | NRG Energy Inc | Electric | 19.03785769607992 | -26 | -9 | 7 | 2/11/2012
TE US EQUITY |  | TECO Energy Inc | Electric | -7.545629927852147 | -34 | -9 | -1 | 1/11/2012
GAS US EQUITY |  | AGL Resources Inc | Gas | -13.60268841513287 | 13 | -12 | -5 | 1/11/2012
QEP US EQUITY |  | QEP Resources Inc | Oil&Gas |  | -16 | -19 | -11 | 30/10/2012
NI US EQUITY |  | NiSource Inc | Gas | -23.36142522809191 | -3 | -27 | -9 | 2/11/2012
NEE US EQUITY |  | NextEra Energy Inc | Electric | -33.73369075746853 | -53 | -27 | -11 | 24/10/2012
1st result from column G>20 apear here (the hole row of the result)
2nd result from column G>20 apear here (the hole row of the result) |  |  |  |  |  | if existes
3rd result from column G>20 apear here (the hole row of the result) |  |  |  |  |  | if existes
4th result from column G>20 apear here (the hole row of the result) |  |  |  |  |  | if existes
Spreadsheet: 881109d1729021693-calculating-number-of-winter-workdays-between-two-dats-revised-structural-erection-worksheet-test
Sheet: Invoice 02

 |  | 511 East Steel Loop, Suite 201
 |  | Palmer, AK  99645
 |  | Phone:  [PHONE]
 |  | Fax:      [PHONE]
TO: |  |  |  |  | INVOICE DATE: |  | 0/00/2024
 |  |  |  |  | INVOICE NO:
 |  |  |  | Submitted
 |  |  |  | Via Email
JOB NO:
DOL NUMBER:
JOB NAME:
[NAME] |  | CONTRACT AMOUNT ( $ ) | PREVIOUS BILLED (%) | PREVIOUS BILLED ( $ ) | CURRENT BILLING (%) | CURRENT BILLING ( $ ) | [NAME] (%) | JTD  BILLING ( $ )
Labor
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
LABOR TOTALS: |  |  | 0 |  | 0
CHANGE REQUESTS:
CHANGE REQUEST TOTALS:
TOTALS ALL TO DATE:
Please Remit Payment to: |  |  |  | TOTAL CURRENT BILLING
Iron Inc
511 East Steel Loop |  |  |  | TOTAL PREVIOUS BILLING
Palmer, AK 99645
 |  |  |  | TOTAL AMOUNT DUE THIS INVOICE
Spreadsheet: 692634d1598470513-formula-to-evaluate-two-criteria-and-pull-data-if-both-met-scheduling-dummy-file
Sheet: Holiday INPUT

Date of Holiday | 2020-08-05 00:00:00 |  |  |  |  |  | Holiday Hours Scheduled |  |  | How to Use
Role | Shift Start | Shift End | Scheduled Break | Hours | Scheduled Server |  |  |  |  | This template is used for scheduling holiday's requiring higher staffing levels and shift times for a single day outside of the standard labor models.  This template will display scheduled servers onto the Printable Schedule only if the Date of Holiday is properly changed to the needed day.
Server 1 | 07:30:00 | 13:30:00 | 0.5 |  | [NAME]
Server 2 | 10:00:00 | 15:30:00 | 0
Server 3 | 10:00:00 | 15:30:00 | 0
Server 4 | 10:30:00 | 15:30:00 | 0
Server 5 | 10:30:00 | 15:30:00 | 0 |  |  |  |  |  |  | 1. Change the Date of Holiday in the yellow highlighted cell
Server 6 | 11:00:00 | 15:30:00 | 0 |  |  |  |  |  |  | 2. Adjust Shift Start and Shift End times as needed
Server 7 | 11:00:00 | 15:30:00 | 0 |  |  |  |  |  |  | 3. Enter "0.50" into the Scheduled Break column with .5 for any FT shift (over 5 hours) or remove if not needed
Server 8 | 11:00:00 | 15:30:00 | 0 |  |  |  |  |  |  | 4. Enter servers into the Scheduled Server column for the shifts times needed
Server 9 | 11:00:00 | 15:30:00 | 0 |  | Braden |  |  |  |  | 5. Check the Printable Schedule to ensure the [NAME] are displaying for the right date
Server 10 | 16:00:00 | 19:00:00 | 0 |  |  |  |  |  |  | 6. Any hours scheduled over the standard labor hours will need to be coded to Special Events in TimeStar by the Managers
Server 11 | 16:30:00 | 19:00:00 | 0
Server 12 | 17:00:00 | 19:30:00 | 0
Server 13 | 17:00:00 | 19:30:00 | 0 |  | Apiya
Server 14 | 17:30:00 | 19:30:00 | 0
Server 15 | 17:30:00 | 19:30:00 | 0
Server 16 | 17:30:00 | 19:30:00 | 0
Server 17 | 17:30:00 | 19:30:00 | 0
Server 18 | 17:30:00 | 19:30:00 | 0 |  | [NAME]
Server 19 | 17:30:00 | 19:30:00 | 0
Server 20 | 14:30:00 | 19:30:00 | 0
Server 21 | 14:30:00 | 19:30:00 | 0
Server 22 | 14:30:00 | 19:30:00 | 0
Server 23 | 14:30:00 | 19:30:00 | 0
Server 24 | 14:30:00 | 19:30:00 | 0
Server 25 | 14:30:00 | 19:30:00 | 0
Server 26 | 14:30:00 | 19:30:00 | 0
Server 27 | 14:30:00 | 19:30:00 | 0
Server 28 | 14:30:00 | 19:30:00 | 0
Spreadsheet: 767812d1644659887-rank-and-sort-2-columns-auto-group_rank_test-ans
Sheet: Sheet1

Dash Board layout
Car Num | Class | Time | Overall Rank | Class Rank |  | Car Num | Class | Time | Overall Rank | Class Rank
1 | B | 00:01:50.300000
2 | A | 00:01:26.030000
3 | B | 00:01:33.900000
4 | A | 00:01:23.400000
5 | C | 00:01:26.730000
6 | C | 00:01:31.990000
7 | A | 00:01:31.080000
8 | A | 00:01:24.410000
9 | C | 00:01:28.070000
10 | B | 00:01:34.750000
Spreadsheet: 828157d1683265649-consolidated-report-in-one-page-excel-forum-pnl
Sheet: Brand 1

Financial Row | Jan | Feb | Mar
600101 - Sales | 50000 | 60000 | 65000
600105 - Sales Discount / Discount Allowed | -5000 | -6000 | -6500
Total - Revenue
700101 - Cost of Goods Sold | -15000 | -18000 | -19500
700105 - Purchase Discount / Discount Received | 150 | 180 | 195
Total - Cost of Goods Sold
Gross Profit
710101 - Directors' Remuneration | -5000 | -5000 | -5000
710107 - Salary & Bonus | -15000 | -15000 | -15000
710133 - Staff Welfare | -750 | -750 | -750
710135 - Medical Fee | -250 | -250 | -250
Total - Employee Benefit Cost
Nett Profit
Spreadsheet: a3bd1fe9-ff17-47f4-b561-0d93b75f8774
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4022 | 25830 | Rosalinde | Bakker Rens | NED | 0 | 01:31:37 | 00:00:43 | 02:23:16 | 00:00:10 | 00:47:47 | 1 | 04:43:34
4022 | 16299 | [NAME] | Fortune | NZL | 0 | 01:27:41 | 00:01:13 | 02:25:16 | 00:01:30 | 00:49:46 | 2 | [NAME]
4022 | 7475 | Francoise | Hantke | FRA | 386 | [NAME] | 00:01:15 | [NAME] | 00:01:04 | 00:45:51 | 3 | 04:50:17
4022 | 16775 | Hilary | Walker | GBR | 387 | 01:37:07 | 00:01:58 | 02:27:09 | 00:01:25 | 00:52:26 | 4 | 05:00:06
4022 | 9397 | [NAME] | Cole-Hryciw | CAN | 385 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 855109d1704804537-help-with-let-function-digital-operator-production-log-v3-3-
Sheet: Crystal Anderson

Client | Job # | Lettercode/ Part | Remake # | Printer | Speed | Today's Date | Scheduled  Time | Start Time | Stop Time | Actual Time | [NAME] | Sheets Printed | Material | [NAME] | Height | # Up | Column1 | Column2 | Square Feet | Sq. Feet / Hr | MS UPDATE
npn360 | 243695 | 1 | y | Tauro-2 | 4 Pass | 2024-01-08 00:00:00 | 0.22 | 06:23:00 | 06:25:00 |  |  | 2 | pap-so-0061 | 69 | 42 | 1 |  |  |  |  | Yes
calares | 242973 | 10, 12 | y | Tauro-2 | 4 Pass | 2024-01-09 00:00:00 | 0.5 | 06:26:00 | 06:50:00 |  |  | 8 | pap-so-1374 | 28 | 47 | 3
ggpm | 20307 | 122.1 | n | Tauro-2 | 4 Pass | 2024-01-10 00:00:00 | 1.55 | 06:52:00 | 15:30:00 |  |  | 420 | pap-so-0017 | 22 | 28 | 4 |  |  |  |  | Yes
Total
 |  |  |  |  |  |  |  |  | Press Summary
 |  |  |  |  |  |  |  |  | Press | Hrs | Sq. Ft | % SchHrs | % of SqFt | Run Time | SqFt/Hr
 |  |  |  |  |  |  |  |  | GS3250
 |  |  |  |  |  |  |  |  | HS125
 |  |  |  |  |  |  |  |  | Tauro-1
 |  |  |  |  |  |  |  |  | Tauro-2
 |  |  |  |  |  |  |  |  | 3R-1
 |  |  |  |  |  |  |  |  | 3R-2
Spreadsheet: 931d4dc1-f174-426a-b11c-c6c3c6690bf5
Sheet: Sheet1

Unnamed: 0 | Things to do/Questions for S.Hall Manager | Response/Comments
1 | Check booking form and inform the manager of the time you want access to the hall and anticipated finish time. Take booking form with you.
2 | Ensure the Sports Hall is cleaned thoroughly before the event start of event
3 | That there are enough well maintained posts suitable for the standard of the event.
4 | Ask the Sports Hall to make a clean broom available throughout the event.
5 | Check the quality and if necessary bring from outside.
6 | If there is a dividing curtain inform the staff if you want it to be open or closed.
7 | Ensure that table(s) and sufficient chairs are provided to cater for all the desk officials and identify a suitable place for them to be placed.
8 | If coaching is to be permitted ensure sufficient chairs (2xCourt) for this task to be performed.
9 | Inform Sports hall of anticipated numbers and liaise how best to cater for this number.
10 | Check if there will be a PA system that can be used in the Sports Hall throughout the day? If not an emergency plan needs to be devised (eg. [NAME]) to notify players when they are required to play.
11 | Check that a suitable number rubbish bins/bags will be placed around the sports hall floor and any viewing area and that they will be emptied as required. NB it is useful to provide own rubbish bags and old towel for cleaning up spillages.
12 | Male and female changing rooms and toilet facilities will be required and you need to know that they are checked on a regular basis.
13 | Can the temperature be controlled and if fans are likely to interfere with flight of shuttles can they be turned off.
14 | Find out if a first aider will be present during the event and how to contact them.
15 | Is drinking water available within the Sport Centre if so where?
16 | Does the Sports hall have any safeguarding regulations the tournament needs to be aware of (eg Photography). Which member of staff should the Tournament organisers refer any non tournament  safeguarding and protection issues.
17 | Find out if their will be catering and opening times. Inform participants if there is to be no catering provision. Also inform Sport Hall manager of the number of people you will expect to attend event.
18 | Check what car parking arrangements are and notify participants in advance of any charges or difficulties there may be.
19 | Identify a sutiable spot to place results and get Sports Hall managers permission to use  bluetac.
20 | Find out what the emergency evacuation procedures and make sure that they are announced prior to start of event and at other appropriate times.
Spreadsheet: 848897d1699508002-formulation-to-get-summary-sample
Sheet: Sheet1

 | Weight |  |  |  |  |  | Summary |  |  |  |  | Price |  |  |  |  |  | Quantity
 | a | b | c | d | e | f | D | E | F | G |  |  | D | E | F | G |  | D | E | F | G
 | 0.15 | 0.34 | 0.65 | 0.234 | 0.78 | 0.23 |  |  |  |  |  | a | 3 | 6 | 7 | 7 |  | 120 | 140 | 180 | 111
 | 0.54 | 0.78 | 0.575 | 0.969 | 0.876 | 0.787 |  |  |  |  |  | b | 5 | 6 | 6 | 6 |  | 435 | 235 | 23 | 123
 | 0.786 | 0.098 | 0.546 | 0.273 | 0.433 | 0.12 |  |  |  |  |  | c | 1 | 3 | 4 | 4 |  | 67 | 457 | 36 | 36
 | 0.453 | 0.986 | 0.222 | 0.246 | 0.278 | 0.274 |  |  |  |  |  | d | 1 | 10 | 9 | 9 |  | 235 | 45 | 34 | 436
 |  |  |  |  |  |  |  |  |  |  |  | e | 1 | 4 | 7 | 7 |  | 67 | 457 | 36 | 36
 |  |  |  |  |  |  |  |  |  |  |  | f | 6 | 3 | 2 | 2 |  | 235 | 45 | 34 | 436
 | Result Required in Blue Cells with following combination
 | a(Weight)*a(Price)*Quanity |  |  |  |  | As per D,E,F & G column.
 | For instance:
 | Cell H5 | ((B5*N5)+(C5*N6)+(D5*N7)+(E5*N8)+(F5*N9)+(G5*N10))*S5 |  |  |  |  |  | =
 | Same way in H6, Heading E and so on
Spreadsheet: 875216d1721800651-excel-changes-9hours-and-20minutes-to-9-3-when-added-up-in-the-timesheet-timeliste-juli-2024-frigoglass
Sheet: Ark1

TIMELISTE FOR [NAME]  2024, NORCOOL FRIGOGLASS
Beskrivelse | Uke | Dato | Fra | [NAME] | Timer | Timer, minus lunsj. | Brutto dags lønn |  | Parametre | Verdier
 |  | 2024-07-01 00:00:00 | 06:00:00 | 15:20:00 |  |  |  |  | Normaltid | 07:30:00
 |  | 2024-07-02 00:00:00 | 06:00:00 | 15:30:00 |  |  |  |  | Junsj, 30min (hvis ikke betalt) | 00:30:00
 |  | 2024-07-03 00:00:00 | 07:00:00 | 16:00:00 |  |  |  |  | Overtid 50% | 0.5
 |  | 2024-07-04 00:00:00 | 06:00:00 | 15:00:00 |  |  |  |  | Timelønn. Eks mva | 350
 |  | 2024-07-05 00:00:00 | 06:00:00 | 15:00:00 |  |  |  |  | MVA | 0.25
 |  | 2024-07-06 00:00:00 |  |  |  |  |  |  | Timelønn. Ink mva
 |  | 2024-07-07 00:00:00
 |  | 2024-07-08 00:00:00 | 06:00:00 | 15:00:00
 |  | 2024-07-09 00:00:00 | 05:50:00 | 15:20:00
 |  | 2024-07-10 00:00:00 | 06:00:00 | 15:00:00
 |  | 2024-07-11 00:00:00 | 06:00:00 | 15:00:00
 |  | 2024-07-12 00:00:00 | 06:00:00 | 15:00:00
 |  | 2024-07-13 00:00:00 |  |  |  |  |  |  |  |  |  | Tid | minutter | [NAME] | resultat |  |  |  | Tid | minutter | [NAME] | resultat
 |  | 2024-07-14 00:00:00 |  |  |  |  |  |  |  |  |  | 09:00:00 | 30 | =M16+(N17/1440) |  |  |  |  | 09:00:00 | 30 | =T16+TID(0;U16;0)
 |  | 2024-07-15 00:00:00 | 06:00:00 | 15:00:00 |  |  |  |  |  |  |  | 11:30:00 | 18 | =M17+(N17/1440) |  |  |  |  | 10:00:00 | 18 | =T17+TID(0;U17;0)
 |  | 2024-07-16 00:00:00 |  |  |  |  |  |  |  |  |  | 15:25:00 | 40 | =M18+(N18/1440) |  |  |  |  | 11:00:00 | 40 | =T18+TID(0;U18;0)
 |  | 2024-07-17 00:00:00 |  |  |  |  |  |  |  |  |  | 23:50:00 | 10 | =M19+(N19/1440) |  |  |  |  | 12:00:00 | 10 | =T19+TID(0;U19;0)
 |  | 2024-07-18 00:00:00 | 06:00:00 | 15:00:00
 |  | 2024-07-19 00:00:00 | 06:00:00 | 15:00:00
 |  | 2024-07-20 00:00:00
 |  | 2024-07-21 00:00:00
 |  | 2024-07-22 00:00:00 | 06:00:00 | 15:15:00
 |  | 2024-07-23 00:00:00 | 07:15:00 | 15:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 | 15:20:00
 |  | 2024-07-24 00:00:00
 |  | 2024-07-25 00:00:00
 |  | 2024-07-26 00:00:00
 |  | 2024-07-27 00:00:00
 |  | 2024-07-28 00:00:00
 |  | 2024-07-29 00:00:00
 |  | 2024-07-30 00:00:00
 |  | 2024-07-31 00:00:00
 |  |  | TOTAL TIMER:
 |  |  | Timelønn. eks mva.
 |  |  | Total lønn. Ink mva
Spreadsheet: 73982d1274561286-trouble-with-laying-out-data-set-dataset_rev2
Sheet: Dept1

Year | Forecast Month | Revenue Category | [NAME] | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2010 | Jan | Complete |  | 10 | a
2010 | Jan | Live |  | 20 | b |  |  |  |  | testA
2010 | Jan | Booked on |  | 30 | c
2010 | Jan | High Prob |  | 40 | d
2010 | Jan | Indentified |  | 50 | e
2010 | Jan | Blue Sky |  | 60 | f
2011 | Jan | Complete |  | 11111 | test1
2011 | Jan | Live |  | 22222 | test2
2011 | Jan | Booked on |  | 33333 | test3
2011 | Jan | High Prob |  | 44444 | test4
2011 | Jan | Indentified |  | 55555 | test5
2011 | Jan | Blue Sky |  | 66666 | test6
 | Each department has a sheet similar to this in there revenue spreadsheets which capture the different parameters  from a detailed sheet.
Spreadsheet: 220115d1363070193-multiple-table-lookup-shortest-approach-ef-sample
Sheet: TABLE AGE

 |  |  |  |  |  | MONTHS
YEARS |  |  |  |  |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec
2012 | 2013 | 2014 | 2015 | 2016 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | <--header
2007 | 2008 | 2009 | 2010 | 2011 |  | 5.5 | 5.5 | 5.5 | 5 | 5 | 5 | 5 | 5 | 5 | 4.5 | 4.5 | 4.5 |  | GIVEN Date Value | Expected Answer
2006 | 2007 | 2008 | 2009 | 2010 |  | 6.5 | 6.5 | 6.5 | 6 | 6 | 6 | 6 | 6 | 6 | 5.5 | 5.5 | 5.5 |  | 2002-02-20 00:00:00 | 10.5
2005 | 2006 | 2007 | 2008 | 2009 |  | 7.5 | 7.5 | 7.5 | 7 | 7 | 7 | 7 | 7 | 7 | 6.5 | 6.5 | 6.5
2004 | 2005 | 2006 | 2007 | 2008 |  | 8.5 | 8.5 | 8.5 | 8 | 8 | 8 | 8 | 8 | 8 | 7.5 | 7.5 | 7.5 |  | based on month and year
2003 | 2004 | 2005 | 2006 | 2007 |  | 9.5 | 9.5 | 9.5 | 9 | 9 | 9 | 9 | 9 | 9 | 8.5 | 8.5 | 8.5 |  | month is february
2002 | 2003 | 2004 | 2005 | 2006 |  | 10.5 | 10.5 | 10.5 | 10 | 10 | 10 | 10 | 10 | 10 | 9.5 | 9.5 | 9.5 |  | year is 2002
2001 | 2002 | 2003 | 2004 | 2005 |  | 11.5 | 11.5 | 11.5 | 11 | 11 | 11 | 11 | 11 | 11 | 10.5 | 10.5 | 10.5 | * | look at year today minus 1
2000 | 2001 | 2002 | 2003 | 2004 |  | 12.5 | 12.5 | 12.5 | 12 | 12 | 12 | 12 | 12 | 12 | 11.5 | 11.5 | 11.5 | * | that will be the range for the lookup
1999 | 2000 | 2001 | 2002 | 2003 |  | 13.5 | 13.5 | 13.5 | 13 | 13 | 13 | 13 | 13 | 13 | 12.5 | 12.5 | 12.5
1998 | 1999 | 2000 | 2001 | 2002 |  | 14.5 | 14.5 | 14.5 | 14 | 14 | 14 | 14 | 14 | 14 | 13.5 | 13.5 | 13.5
1997 | 1998 | 1999 | 2000 | 2001 |  | 15.5 | 15.5 | 15.5 | 15 | 15 | 15 | 15 | 15 | 15 | 14.5 | 14.5 | 14.5
1996 | 1997 | 1998 | 1999 | 2000 |  | 16.5 | 16.5 | 16.5 | 16 | 16 | 16 | 16 | 16 | 16 | 15.5 | 15.5 | 15.5
1995 | 1996 | 1997 | 1998 | 1999 |  | 17.5 | 17.5 | 17.5 | 17 | 17 | 17 | 17 | 17 | 17 | 16.5 | 16.5 | 16.5
1994 | 1995 | 1996 | 1997 | 1998 |  | 18.5 | 18.5 | 18.5 | 18 | 18 | 18 | 18 | 18 | 18 | 17.5 | 17.5 | 17.5
1993 | 1994 | 1995 | 1996 | 1997 |  | 19.5 | 19.5 | 19.5 | 19 | 19 | 19 | 19 | 19 | 19 | 18.5 | 18.5 | 18.5
1992 | 1993 | 1994 | 1995 | 1996 |  | 20.5 | 20.5 | 20.5 | 20 | 20 | 20 | 20 | 20 | 20 | 19.5 | 19.5 | 19.5
1991 | 1992 | 1993 | 1994 | 1995 |  | 21.5 | 21.5 | 21.5 | 21 | 21 | 21 | 21 | 21 | 21 | 20.5 | 20.5 | 20.5
1990 | 1991 | 1992 | 1993 | 1994 |  | 22.5 | 22.5 | 22.5 | 22 | 22 | 22 | 22 | 22 | 22 | 21.5 | 21.5 | 21.5
1989 | 1990 | 1991 | 1992 | 1993 |  | 23.5 | 23.5 | 23.5 | 23 | 23 | 23 | 23 | 23 | 23 | 22.5 | 22.5 | 22.5
1988 | 1989 | 1990 | 1991 | 1992 |  | 24.5 | 24.5 | 24.5 | 24 | 24 | 24 | 24 | 24 | 24 | 23.5 | 23.5 | 23.5
Spreadsheet: 802798d1667047008-how-to-add-amount-based-on-month-example
Sheet: Sheet1

 |  |  |  | New Question
Date | Amount | Description
2022-07-01 00:00:00 | 2 | food
2022-07-22 00:00:00 | 3 | Pet
2022-07-22 00:00:00 | 2 | Food
2022-08-15 00:00:00 | 3 | Pet
2022-08-19 00:00:00 | 3 | Food
 |  | Result
July | Food
August | Pet