tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 720965d1614400824-calculate-total-costs-based-on-recurring-costs-start-date-and-frequency-samplecosttrackerformula
Sheet: Sheet1

Task | Status | Frequency | $ Amount Per Occurrence | Start Date | Total YTD | Projected 2021*Formula Needed
Cost 1 | Complete | Monthly | 10 | 2021-01-01 00:00:00 | 20 | 120
Cost 2 | In-Process | Quarterly | 20 | 2021-02-01 00:00:00 | 0 | 80
Cost 3 | Complete | Monthly | 100 | 2021-02-06 00:00:00 | 100 | 1100
Cost 4 | Complete | Monthly | 50 | 2021-01-15 00:00:00 | 100 | 600
Cost 4 | Planning | One-Time | 40 | 2021-02-27 00:00:00 | 0 | 40
Cost 5 | Planning | Complete | 100 | 2021-01-30 00:00:00 | 100 | 100
 |  |  |  | Date to start calculating # of occurences from | Amount per occurrence multiplied by # of occurences since start date (only calculate if status = complete) | Amount per occurrence multiplied by total # of occurences in 2021 from start date through end of year
**NOTE
Potential Frequencies |  | Conditions
Daily |  | If Status = "In-Process" Then 0
Weekly |  | If Status = "Cancelled" Then 0
Bi-Monthly |  | If Status = "Planning" Then 0
Monthly |  | If Status = "Complete" & Frequency = "Daily" Then
Quarterly |  | If Status = "Complete" & Frequency = "Weekly" Then
One-Time |  | If Status = "Complete" & Frequency = "Bi-Monthly" Then
 |  | If Status = "Complete" & Frequency = "Monthly" Then
 |  | If Status = "Complete" & Frequency = "Quarterly" Then
 |  | If Status = "Complete" & Frequency = "Daily" Then
Spreadsheet: 61589d1262526555-two-y-axis-both-using-same-data-series-frost-20iwi-20graphsv1-1-
Sheet: 5- historical

 | WDR Zone 1 |  | WDR Zone 2 |  | WDR Zone 3 |  | WDR Zone 4
 | Cambridge | London | Grendon Underwood | Wallingford | [NAME] | [NAME] | [NAME] | Rawtenstall
None | 11.89 | 7.42 | 33.94 | 21.28 | 25.62 | 20.201 | 21.04 | 25.41
WF | 32.83 | 31.92 | 45.58 | 29.53 | 40.58 | 33.06 | 23.48 | 39.66
MW | 34.08 | 31.92 | 45.7 | 29.63 | 42.81 | 35.49 | 23.67 | 41.96
EPS | 34.2 | 32.96 | 46.56 | 31.11 | 42.14 | 35.42 | 23.84 | 42.07
PF | 34.34 | 34.38 | 47.1 | 31.04 | 42.48 | 35.2 | 24.74 | 42.056
% | 20.47826086956522 | 20.47826086956522 | 20.47826086956522 | 20.47826086956522 | 20.47826086956522 | 20.47826086956522 | 20.47826086956522 | 20.47826086956522
Historical brick free water saturation (Wf) |  |  |  | 230 | kg/m3 | 230 is 100%
75% of Wf Fmax |  |  |  | 172.5 | kg/m3
 |  |  |  | 115
 |  |  |  | 57.5 | 57.5
Spreadsheet: 90562d1290299894-prioritized-to-do-items-on-separate-worksheets-feed-into-master-worksheet-priority
Sheet: Sheet1

CATEGORY | PRIORITY | ITEM | PRIORITY TIE BREAKER |  | HIGHEST to LOWEST PRIORITY
Gardening | 1.5 | Buy soil | 1.500002 |  | PRIORITY | ITEM
Gardening | 2.5 | Plant seeds | 2.500003 |  | 1.2 | [NAME]
Gardening | 3.7 | Water | 3.700004 |  | 1.5 | Buy soil
[NAME] | 1.2 | [NAME] | 1.200005 |  | 2 | Hire Curator
[NAME] | 2 | Hire Curator | 2.000006 |  | 2.5 | Plant seeds
[NAME] | 3.5 | Purchase [NAME] | 3.500007 |  | 3.5 | Purchase [NAME]
 |  |  |  |  | 3.7 | Water
Spreadsheet: 142218d1329741486-looking-up-dates-with-if-problem-sample-project-overview-sheet
Sheet: PROJECTS

 |  |  | FEB |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL
Date | w/c |  | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00 | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00
Project 1
 | Event Type 1
 | Event Type 2
Project 2
 | Event Type 1 |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Event Type 2 |  |  |  |  |  |  |  |  |  | x
VALID | X
Spreadsheet: 853208d1703109728-need-help-getting-lambda-to-work-scheduling-kansas-2-1-
Sheet: Blast Media Estimate

T1 |  | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 |  | 1 | Blast Media | 21 | 24 | 36 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-26 00:00:00 |  | T2
 |  | 2 | Blast Media | 1 | 48 | 54 | ART-4231 - 48x96 10MM COROPLAST | 1 | 4 Pass | 2023-12-26 00:00:00 |  | T2
 |  | 3 | Blast Media | 4 | 24 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-26 00:00:00 |  | T2
Spreadsheet: 764535d1642781602-find-last-x-values-from-column-j-excluding-blanks-return-value-from-column-a-last-8-sample-worksheet
Sheet: Sheet1

ID | Name | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | Test 7 | Test 8
8191423 | [NAME] | 72.9
8215499 | [NAME] | 75.7
413972 | [NAME] | 91.1 |  |  | 3.4 |  | 3.703 |  | 2.3
424284 | [NAME] | 88.66000000000001 | 680.52 |  | 1.8 |  | 2.104 | 46.64 | 2.8
429103 | [NAME] | 74.52
431720 | [NAME] | 76.32 | 479.28 | 1.548 | 1.9 |  | 2.106 |  | 4.2 |  |  |  | RETURN: | 431720
440466 | [NAME] | 119.88 |  | 1.341 |  |  |  |  |  |  |  |  |  | 448598
448598 | [NAME] | 147.39 | 289 | 2.088 | 4.3 |  | 7.408 |  | 10.2 |  |  |  |  | 456730
456730 | [NAME] | 94.2 | 2200 | 1.8 | <0.5 |  | 2.109 |  | 3.2896 |  |  |  |  | 472994
464862 | [NAME] | 72.9 |  |  |  |  |  |  |  |  |  |  |  | 481126
472994 | [NAME] | 91.1 |  |  | 3.4 |  | 3.703 |  | 17.4 |  |  |  |  | 489258
481126 | [NAME] | 88.66000000000001 | 680.52 |  | 1.8 |  | 2.104 | 46.64 | 41.2 |  |  |  |  | 513654
489258 | [NAME] | 74.52 |  |  |  |  |  |  | 7.2 |  |  |  |  | 521786
497390 | [NAME] | 76.32 | 479.28 | 1.548 | 1.9 |  | 2.106
505522 | [NAME] | 119.88 |  | 1.341
513654 | [NAME] | 147.39 | 289 | 2.088 | 4.3 |  | 7.408 |  | 11.8
521786 | [NAME] | 94.2 | 2200 | 1.8 | <0.5 |  | 2.109 |  | 19.4
Spreadsheet: 2252c6c5-ba65-4990-beea-74a8bb43f5f0
Sheet: Sheet1

Additional File 9. qRT-PCR analysis of MYB98 in seven pairs of ms1-dif1 ovary RNAs used in this study. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Normalized CT, ms1 | DDCT
experiment | RNA |  | avg. | s.d | n | P (t-test)
primary qRT-PCR screen | a | 25.72026315789474 | 4.941052631578948 | 0.5213018499647507 | 38 | 2.377947401380451e-38
primary qRT-PCR screen | b | 25.95125 | 4.824166666666668 | 0.3783823309904802 | 24 | 1.771249260553621e-27
primary qRT-PCR screen | c | 24.66596338873268 | 3.927716748530639 | 0.2737239602853849 | 99 | 8.279775075343356e-116
primary qRT-PCR screen | d | 25.81203461982216 | 3.437414743869939 | 0.2801105327479324 | 18 | 1.71828448980434e-20
primary qRT-PCR screen | e | 25.1857318072901 | 3.56238079463795 | 0.2017222682401009 | 4 | 2.495395524213952e-05
secondary qRT-PCR screen | e | 25.2682756886424 | 3.65971017261745 | 0.111428278987765 | 10 | 1.804254033264384e-15
secondary qRT-PCR screen | f | 25.21468754678687 | 3.373991043548482 | 0.1897641054572227 | 6 | 6.022771072343207e-08
secondary qRT-PCR screen | g | 25.71051151985533 | 3.148514057521918 | 0.1982409598474833 | 6 | 1.057462417766177e-07
MYB98 mRNA levels were measured in each qRT-PCR run. A total of seven pairs of ms1-dif1 RNA samples (a-g) were used in the primary and the secondary qRT-PCR screens. Data was analyzed using a one tailed, paired Student's t-test as described in Methods. avg., average DDCT value; s.d., standard deviation; n, number of reactions.
Spreadsheet: 141031-populating-the-cells-by-performing-calculations-example3
Sheet: Sheet1

category | Total amount | Remainng after allocation to all names |  |  |  |  | Name | Amount | Allocated finally
category1 | 1000 |  |  |  |  |  | suresh | 1000
category2 | 2500 |  |  |  |  |  | ravi | 800
category3 | 600 |  |  |  |  |  | rajesh | 479
category4 | 9000 |  |  |  |  |  | ramesh | 9040
Spreadsheet: 852972d1702939107-trying-to-set-up-a-formula-that-enables-a-leapfrog-points-system-for-a-sports-ladder-tennis-ladder-jameswestlake-
Sheet: Ladder

 | Men's Team  Tennis Ladder
 | Player | Total Matches Played | Total Wins | Total Losses | Challenges made | Challenges Won |  | Points from challenges | Total Points
RAW DATA
Player | [NAME] | Total Wins | Total Losses | Total Challenges | Challenges Won | Challenges Won (%) | Points Won | Total Points | Initial Ladder Ranking
[NAME] |  |  |  |  |  |  |  |  | 15
Zak |  |  |  |  |  |  |  |  | 14
[NAME] |  |  |  |  |  |  |  |  | 13
Martin |  |  |  |  |  |  |  |  | 12
Clive |  |  |  |  |  |  |  |  | 11
[NAME] |  |  |  |  |  |  |  |  | 10
[NAME] |  |  |  |  |  |  |  |  | 9
Ian |  |  |  |  |  |  |  |  | 8
[NAME] |  |  |  |  |  |  |  |  | 7
[NAME] |  |  |  |  |  |  |  |  | 6
[NAME] |  |  |  |  |  |  |  |  | 5
Julian |  |  |  |  |  |  |  |  | 4
Nick |  |  |  |  |  |  |  |  | 3
[NAME] |  |  |  |  |  |  |  |  | 2
Guy |  |  |  |  |  |  |  |  | 1
Spreadsheet: 862424d1710161965-referencing-a-list-of-cells-in-a-non-sequential-layout-for-a-report-audit_longbrian
Sheet: Sheet2

Report
Question
Why are we asking?
Business Alalysis
Question
Why are we asking?
Business Alalysis
Question
Why are we asking?
Business Alalysis
Spreadsheet: 84731d1284730558-find-and-highlight-first-occurrences-highlight-first-occurrence
Sheet: Sheet1

 | Name 7
 | Name 9
 | Name 4
 | Name 5
 | Name 8
 | Name 7
 | Name 7
 | Name 6
 | Name 9
 | Name 10
 | Name 4
 | Name 2
 | Name 3
 | Name 4
 | Name 6
 | Name 8
 | Name 4
 | Name 10
 | Name 5
 | Name 2
 | Name 6
 | Name 8
 | Name 9
 | Name 7
 | Name 1
 | Name 4
 | Name 6
 | Name 7
 | Name 4
 | Name 8
 | Name 7
 | Name 9
Spreadsheet: 699403d1602591054-incorrect-formula-conditionnal-formatting-employees-in-and-out
Sheet: For Forum

1/ Select the Year & Month------> |  | 3 | 2020 |  |  |  |  |  |  |  |  |  | $C$2&$D$2=MONTH(P7)&YEAR(P7)
The column " Status" has a formula which changes depending on the situation of the employee :
"New"  if the date of joining  is the same with the date of reporting (see row 2 ). Besides, the entire row is expected to turn automatically into Green font.
"Active" if the date of joining is before of the date of reporting
"Out" if the employee will leave or has already left the company. It is expected that the row to turn into Red font when the date of leaving is the same as the date of reporting
Last Name | Fist Name | Date of Joining | status | Date_of leaving | Position
A | G | 2019-12-02 00:00:00 |  | 2020-03-31 00:00:00 | SALES MANAGER
B | H | 2019-06-01 00:00:00 |  |  | PROJECT MANAGER
C | I | 2019-05-23 00:00:00 |  | 2020-03-31 00:00:00 | FINANCE MANAGER
D | J | 2020-05-20 00:00:00 |  |  | ACCOUNTANT
E | K | 2019-05-08 00:00:00 |  | 2020-01-31 00:00:00 | DESIGNER
F | L | 2020-03-08 00:00:00 |  |  | SITE SUPERVISOR
Spreadsheet: 147243d1332636949-product-and-sum-based-on-a-condition-sample
Sheet: Sheet1

2 | 3 | 4 | 1 | 0 | 1 | 3 | 2 | 1
2 | 3 | 4 | 1 | 1 | 1 | 3 | 2 | 1
2 | 3 | 4 | 1 | 1 | 0 | 3 | 2 | 1
 | TOTAL
1.
2.
3.
Spreadsheet: 177e0f13-8aac-4a4d-8646-0aea7e648619
Sheet: Operating

OPERATING/PROGRAMMATIC
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Accepting a Weatherization Grant  From KCP&L
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2009-10 |  |  | FY 2010-10
 | General Fund |  |  | $ |  |  | $
 | Special Revenue |  |  | $ |  |  | $ | 70000
 | Enterprise |  |  | $ |  |  | $
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known or, if grant revenue, please identify source of funds (federal or state) and duration of grant support.)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail
 | General Fund |  |  | $
 | Special Revenue |  |  | $ |  |  | $
 | Enterprise/Other |  |  | $ |  |  | $
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | No |  | X | Yes
 | (Please detail estimated number of people to be served, who is currently delivering services to that population, service
 | performance expectations and, if grant supported, provisions for support if grant support ends.)
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
0ffice of Management and Budget |  |  |  |  |  | OMB Approval Date
Spreadsheet: 782041d1653731249-vlook-up-second-and-third-value-vlook-up-index-aligw
Sheet: Sheet1

# | code | from | to |  | search |  |  | Together
 | 11 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | code | 11
 | 22 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
 | 11 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | from | to
 | 22 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
 | 11 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
 | 55 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | from | to
 | 33 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
 |  |  |  |  | from | to
 |  |  |  |  | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
Spreadsheet: 41690d1240244521-create-tables-in-excel-test_tables_database
Sheet: BLA

NAME1 | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7
Timmy | [NAME] | Shaune | Riz | [NAME] | Ian | Emerson
HOLDING1 | HOLDING2 | HOLDING3 | HOLDING4 | HOLDING5 | HOLDING6 | HOLDING7
1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000
PRICE1 | PRICE2 | PRICE3 | PRICE4 | PRICE5 | PRICE6 | PRICE7
70 | 60 | 50 | 40 | 30 | 20 | 10
INTEREST1 | INTEREST2 | INTEREST3 | INTEREST4 | INTEREST5 | INTEREST6 | INTEREST7
5 | 10 | 15 | 3 | 6 | 9 | 12
Spreadsheet: 776182d1649562304-count-days-in-a-month-from-given-range-updated-sheet-count-days-in-a-month-for-specific-stock
Sheet: Result Sheet

 | 2022-03-01 00:00:00 | 50 |  |  | Data Source = | All companies day by day Sale% is in other sheet, "Source data Sheet"in this workbook only
Company | Total Days in a Month | Days with Sale% More than 50
DIVISLAB | 20 | 1 |  |  | I need help for these querries | B Coloumn = In Source Data Sheet there is 2 month data for each company, So I want to count number of Days in a Month mentioned in Cell B2 of Result Sheet (March 2022)
HINDALCO | 20 | 3 |  |  |  | C Coloumn - for a month mentioned in B2, I want to count days when Sale% is greater than value mentioned in C2 of Result Sheet
TATASTEEL | 20 | 1
DRREDDY |  |  |  |  |  | B & C Column Data in Red Figures are the manually entered data which I want with the help of formulas.
Spreadsheet: 279252d1385049116-tweaking-a-excel-schedule-dockschedule
Sheet: Schedule

 | DAILY DOCK SCHEDULE |  |  |  |  | For the day of | Show schedule for:
 |  |  |  |  |  | 2013-11-21 00:00:00 | 12
 | TIME | DOOR  3 | DOOR 4 | DOOR 5 | DOOR 6 | DOOR 7 | DOOR 8 | DOOR 9 | DOOR  10 | DOOR 11 | DOOR 12 | DOOR 13 | DOOR 14 | DOOR 15 | DOOR 16
 | 05:00:00
 | 06:00:00
 | 07:00:00
 | 08:00:00
 | 09:00:00
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 | 16:00:00
 | 17:00:00
 | 18:00:00
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 22:00:00
 | 23:00:00
 | 1900-01-01 00:00:00
Spreadsheet: 95055d1294761028-filling-cells-based-on-drop-down-selection-wuc
Sheet: Sheet3

A | SERVICE INCLUDES ALL UNITS OF WORK ASSOCIATED WITH SERVICING, CLEANING (NOT PART OF AN INSPECTION), AND MOVEMENT OF EQUIPMENT.
B | UNSCHEDULED [NAME] INCLUDES ALL UNITS OF WORK ACCOMPLISHED BETWEEN SCHEDULED INSPECTIONS. DOES NOT INCLUDE THE “LOOK” AND “FIX” PHASES OF INSPECTIONS OR WORK COVERED BY TYPE MAINTENANCE CODE R OR T. THIS CODE INCLUDES REPAIR AND/OR CALIBRATION OF ITEMS OR EQUIPMENT BETWEEN SCHEDULED CALIBRATION INTERVALS.
F | DAILY/SHIFT/PHASE/PERIODIC INCLUDES ALL UNITS OF WORK ACCOMPLISHED DURING DAILY/SHIFT/PHASED/PERIODIC INSPECTIONS. USE THIS CODE ON BOTH THE “LOOK” PHASE OF THE INSPECTION AND ON ALL “FIX” PHASE DOCUMENTS GENERATED FOR THE CORRECTION OF DEFICIENCIES NOTED DURING THE INSPECTION.
H | EMERGENCY ON-SITE REPAIR INCLUDES ALL UNITS OF WORK AUTHORIZED AND ACCOMPLISHED AS A RESULT OF AN EMERGENCY REQUEST FOR ASSISTANCE. APPLICABLE TO ALL LEVELS OF [NAME]BY AFSCN ENGINEERING AND INSTALLATION TEAMS AND INCLUDES ORGANIZATIONAL AND INTERMEDIATE MAINTENANCE PERFORMED BY AFMC MOBILE DEPOT ACTIVITY (MDA) TEAMS. EXCLUDES ACCOMPLISHMENT OF TCTOs.
J | SCHEDULED CALIBRATION OF EQUIPMENT OR COMPONENTS INCLUDES ALL UNITS OF WORK ACCOMPLISHED CONCURRENTLY WITH A SCHEDULED CALIBRATION.
P | SCHEDULED MAINTENANCE INCLUDES ALL SCHEDULED WORK ACCOMPLISHED BETWEEN SCHEDULED INSPECTIONS, SUCH AS PERIODIC SCHEDULING OF EQUIPMENT THROUGH SHOPS. EXCLUDES THE “LOOK” AND “FIX” PHASES OF SCHEDULED INSPECTIONS OR WORK OUTLINED IN THE OTHER TYPE MAINTENANCE CODES.
R | [NAME] INCLUDES ALL UNITS OF WORK ACCOMPLISHED WHEN DEPOT MAINTENANCE OR REHABILITATION IS PERFORMED REGARDLESS OF LOCATION. THIS INCLUDES EMERGENCY ON-SITE REPAIR INVOLVING DEPOT-LEVEL MAINTENANCE BY AIR FORCE LOGISTICS COMMAND (AFLC) PERSONNEL. EXCLUDES ACCOMPLISHMENT OF TCTOs.
S | SPECIAL INSPECTION INCLUDES ALL UNITS OF WORK ACCOMPLISHED DURING SPECIAL INSPECTIONS. ALSO USE THIS CODE FOR ALL SEPARATE “FIX” AND “REPAIR” DOCUMENTS GENERATED FOR THE CORRECTION OF DEFICIENCIES NOTED DURING THE SPECIAL INSPECTION.
T | TIME COMPLIANCE TECHNICAL ORDER (TCTO) INCLUDES ACCOMPLISHMENT OF ALL TCTOs.
Z | RELIABILITY IMPROVEMENT WARRANTY (RIW)/ADVANCED CONFIGURATION MANAGEMENT USE THIS CODE FOR RELIABILITY IMPROVEMENT WARRANTY ITEMS AND FOR EQUIPMENT MANAGED UNDER THE ADVANCED CONFIGURATION MANAGEMENT SYSTEM (ACMS).
Spreadsheet: 827851d1683070582-cell-contains-either-2-of-10-conditions-return-1-result-test050223
Sheet: Sheet3

 | Code number | Reason | Uncontrollable
 | 001 | Technical Support Fee | N
 | 002 | Credit Hold - C1 | Y
 | 003 | Customer Carrier Issue / Call | Y
 | 004 | Export Coordination | N
 | 005 | Carrier Issue | N
 | 007 | Labor Issues /Repack Incomplet | N
 | 008 | Order Entry Error - OTC | N
 | 010 | RM / PO Issue | N
 | 011 | Truck Optimization - UC | N
 | 014 | [NAME]X2) | N
Spreadsheet: 793152d1661339498-summing-filtered-data-based-on-criteria-formula-to-total-filtered-data-with-criteria
Sheet: Imported Data

Ref | Total Amount | Date | Branch | Type
XXMRKANL8 | 18839.378 | 2022-08-16 00:00:00 | BR1 | SL
XXMRKANL9 | 18839.378 | 2022-08-16 00:00:00 | BR1 | SL
XXMRKANL10 | 18839.378 | 2022-08-17 00:00:00 | BR1 | Cred
XXMRKANL11 | 18839.378 | 2022-08-17 00:00:00 | BR1 | SL
XXMRKANL12 | 18839.378 | 2022-08-17 00:00:00 | BR1 | SL
XXMRKANL13 | 18839.378 | 2022-08-17 00:00:00 | BR1 | Cred
[NAME] | 18839.378 | 2022-08-23 00:00:00 | BR1 | SL
XXMRKANL15 | 51929.53733333333 | 2022-08-23 00:00:00 | BR1 | SL
XXMRKANL16 | 18779.97866666667 | 2022-08-23 00:00:00 | BR1 | Cred
Spreadsheet: 272636d1382451095-vlookup-help-please-best-light-images
Sheet: STOCK

NO | CATEGORY | [NAME] | UNIT COST | QUANTITY | STOCK VALUE | RETAIL PRICE | RETAIL STOCK VALUE | SALES
1 | A6 Cards | Duke Of Portland | 0.3 | 6 |  | 2.5
2 | A6 Cards | [NAME] | 0.3 | 6 |  | 2.5
3 | A6 Cards | Hawes In Winter - Merry Christmas | 0.3 | 8 |  | 2.5
4 | A6 Cards | Bengali Eagle Owl | 0.3 | 6 |  | 2.5
5 | A6 Cards | [NAME] | 0.3 | 6 |  | 2.5
6 | A6 Cards | Hartsop Cottage | 0.3 | 4 |  | 2.5
7 | A6 Cards | Robin - Season Greetings | 0.3 | 5 |  | 2.5
8 | A6 Cards | Golden Hardraw | 0.3 | 4 |  | 2.5
9 | A6 Cards | Cloud Inversion | 0.3 | 5 |  | 2.5
10 | A6 Cards | [NAME] | 0.3 | 7 |  | 2.5
11 | A6 Cards | Hawes In Winter | 0.3 | 6 |  | 2.5
12 | A6 Cards | High Dam | 0.3 | 1 |  | 2.5
13 | A6 Cards | [NAME] | 0.3 | 1 |  | 2.5
14 | A6 Cards | Season Greetings - Robin | 0.3 | 1 |  | 2.5
15 | A6 Cards | [NAME] | 0.3 | 1 |  | 2.5
16 | A6 Cards | [NAME] Bay | 0.3 | 6 |  | 2.5
17 | A6 Cards | The Millennium Cairn | 0.3 | 6 |  | 2.5
18 | A6 Cards | [NAME] | 0.3 | 6 |  | 2.5
19 | A6 Cards | [NAME] | 0.3 | 6 |  | 2.5
20 | A6 Cards | 199 Steps Whitby | 0.3 | 6 |  | 2.5
21 | A6 Cards | Hartsop Barn | 0.3 | 3 |  | 2.5
22 | A6 Cards | [NAME] | 0.3 | 7 |  | 2.5
23 | A6 Cards | Muker To Keld | 0.3 | 6 |  | 2.5
24 | A6 Cards | Muker Tea Shop | 0.3 | 6 |  | 2.5
25 | A6 Cards | [NAME] | 0.3 | 3 |  | 2.5
26 | A6 Cards | Richmond | 0.3 | 6 |  | 2.5
27 | A6 Cards | Highland Cow | 0.3 | 6 |  | 2.5
28 | A6 Cards | Candle - Season Greetings | 0.3 | 6 |  | 2.5
29 | A6 Cards | Keld Views | 0.3 | 6 |  | 2.5
30 | A6 Cards | Wainwath Force | 0.3 | 6 |  | 2.5
31 | A6 Cards | [NAME] | 0.3 | 6 |  | 2.5
32 | A6 Cards | Rays Of Light | 0.3 | 6 |  | 2.5
33 | A6 Cards | [NAME] | 0.3 | 4 |  | 2.5
34 | A6 Cards | Healaugh Bridge | 0.3 | 6 |  | 2.5
35 | A6 Cards | Swaledale Views | 0.3 | 6 |  | 2.5
36 | A6 Cards | [NAME] | 0.3 | 6 |  | 2.5
37 | A6 Cards | Hardy Ponies | 0.3 | 6 |  | 2.5
38 | [NAME] | Keld Views | 4 | 1 |  | 8
39 | Jigsaw | Keld Views | 10 | 1 |  | 15
40 | Phone Cases | Keld Views | 5 | 1 |  | 12
41 | Slate | Keld Views | 7 | 2 |  | 15
42 | Slate | [NAME] | 7 | 1 |  | 15
43 | Coaster | Keld Views | 4 | 1 |  | 6
44 | Clock | Keld Views | 12 | 1 |  | 25
45 | Clock | [NAME] | 12 | 1 |  | 25
46 | [NAME] | Keld Views | 12 | 1 |  | 25
47 | Ovals | Hartsop Barn | 8 | 1 |  | 18
48 | Laminate Blocks | Hartsop Barn | 5 | 2 |  | 15
49 | Laminate Blocks | [NAME] | 5 | 2 |  | 15
50 | Laminate Blocks | Keld Views | 5 | 1 |  | 15
51 | Laminate Blocks | Blea Tarn Black White | 5 | 1 |  | 15